RA_ReceiptsDetail RA Receipts Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: RA_ReceiptsDetail_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_ReceiptsDetail.M4T"
KPRIMARY: RMANo+LineKey KDISPLAY: RMANo+LineSeqNo+LineKey KEXTENDEDDESC: ExtendedDescriptionKey+RMANo+LineKey KITEM: ItemCode+RMANo+LineKey KITEMWHSE: ItemCode+WarehouseCode+RMANo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 RMANo . . . . . . . . . . . . 7 SYY RMA Number. . . . . . . . . . .RMANO Read Only:Y FmtType:CHARNUM 2 LineKey . . . . . . . . . . . 6 SNY LineKey . . . . . . . . . . . . Read Only:Y Mask:000000 FmtType:ZEROFILL 3 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . . Read Only:Y Mask:000000000000 00 FmtType:ZEROFILL 4 InvoiceNo . . . . . . . . . . 7 SYN Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM DepVal:REQU IRED 5 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . Mask:000000 FmtType:ZEROFILL 6 DetailSeqNo . . . . . . . . . 6 SNN Detail Sequence Number. . . . . Mask:000000 FmtType:ZEROFILL Notes: From ARN when Invoice is available 7 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE DepVal:REQUIRED 8 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . . Valid:1,2,3,4,5 Notes: 1=Inventory Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item 9 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION ValGroup:ItemRequired 10 ExtendedDescriptionKey. . . . 10 SYN Extended Description Key. . . .EXTDESCKEY Read Only:Y DfltVal:000000000 0 ValGroup:NotComment, ItemRequired,ItemTypes 11 CustomerAction. . . . . . . . 1 SYN Customer Action . . . . . . . . DfltVal:N Valid:N,C,P,R ValGroup:NotComment Notes: N=None, C=Credit,P=rePlacemen t,R=Repair 12 ItemAction. . . . . . . . . . 1 SYN Item Action . . . . . . . . . . DfltVal:N Valid:N,S,P,R DepVal:REQUIRED ValGroup:NotC omment Notes: N=None, S=Stock,P=Scrap,R=Repair 13 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM ValGroup:IMIn tegrated,ItemRequired, NotComment,MultiWarehouse, RegularItem 14 ReplacementItemCode . . . . . 30 SYN Replacement Item Code . . . . .ITEMCODE ValGroup:ReplacementRequired 15 ReplacementItemType . . . . . 1 SNN Replacement Item Type . . . . . Valid:1,2,3,4,5 ValGroup:Repl acementRequired Notes: 1=Inventory Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item 16 VendorAction. . . . . . . . . 1 SYN Vendor Action . . . . . . . . . DfltVal:N Valid:C,P,N ValGroup:POIntegrated, ItemRequired,NotComment, RegularItem Notes: C=Credit, P=rePlacement, N=None 17 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL ValGroup:POIntegrated, VendorActionRequired 18 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ValGroup:PO Integrated,VendorActionRequir ed ChngTag:Replace1/APDivisio nNo$ 19 ReturnReasonCode. . . . . . . 10 SYN Return Reason Code. . . . . . .RETURNREASONCODE 20 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE ValGroup:ItemRequired, ItemTypes 21 DropShip. . . . . . . . . . . 1 SYN Drop Ship . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:ItemTypes 22 CrossShip . . . . . . . . . . 1 SYN Cross Ship. . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:ItemTypes 23 CreditFreight . . . . . . . . 1 SYN Credit Freight. . . . . . . . .YESNO DfltVal:N Valid:Y,N 24 XpressSOCreated . . . . . . . 1 SYN Xpress SO Created . . . . . . .YESNO DfltVal:N Valid:Y,N 25 AliasItemNo . . . . . . . . . 30 SYN Alias Item Number . . . . . . . ValGroup:ItemRequired, RegularItem 26 WarrantyCode. . . . . . . . . 10 SYN Warranty Code . . . . . . . . .WARRANTYCODE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:ItemRequired, RegularItem,WarrantyTracking 27 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE ValGroup:ItemRequired, RegularItem,WarrantyTracking 28 ExpirationDateOverridden. . . 1 SYN Expiration Date Overridden. . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 29 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . . 30 BillOption1 . . . . . . . . . 2 SYN Bill Option 1 . . . . . . . . .BILLOPTION FmtType: CHARNUM DepVal:REQUI RED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 31 BillOption2 . . . . . . . . . 2 SYN Bill Option 2 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 32 BillOption3 . . . . . . . . . 2 SYN Bill Option 3 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 33 BillOption4 . . . . . . . . . 2 SYN Bill Option 4 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 34 BillOption5 . . . . . . . . . 2 SYN Bill Option 5 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 35 BillOption6 . . . . . . . . . 2 SYN Bill Option 6 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 36 BillOption7 . . . . . . . . . 2 SYN Bill Option 7 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 37 BillOption8 . . . . . . . . . 2 SYN Bill Option 8 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 38 BillOption9 . . . . . . . . . 2 SYN Bill Option 9 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 39 CostOverridden. . . . . . . . 1 SYN Cost Overridden . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 40 SalesKitLineKey . . . . . . . 6 SNN Sales Kit Line Key. . . . . . . Mask:000000 FmtType:ZEROFILL 41 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost of Goods Sold Account Key.ACCOUNT ValGroup:ItemRequired, ItemTypes 42 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . .ACCOUNT ValGroup:NotComment, ItemRequired,ItemTypes 43 ExplodedKitItem . . . . . . . 1 SYN Exploded Kit Item . . . . . . . DfltVal:N Valid:Y,N,C ValGroup:NotComment Notes: Y=Yes,N=No,C=Component 44 StandardKitBill . . . . . . . 1 SYN Standard/Kit Bill . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 45 BackorderKitCompLines . . . . 1 SYN Backorder Kit Component Lines .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment Notes: Kit Bckord=0,Comp Bckord>0, Flg=Y 46 RMADetailLineKey. . . . . . . 6 SNN RMA Detail Line Key . . . . . . Mask:000000 FmtType:ZEROFILL 47 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT 48 ApplyCommentsToAll. . . . . . 1 SYN Apply Comments To All . . . . .YESNO DfltVal:N Valid:Y,N 49 ApplyToCustomerRMA. . . . . . 1 SYN Apply To Customer RMA . . . . .YESNO DfltVal:N Valid:Y,N 50 ApplyToRMAReceiver. . . . . . 1 SYN Apply To RMA Receiver . . . . .YESNO DfltVal:N Valid:Y,N 51 ApplyToSalesOrder . . . . . . 1 SYN Apply To Sales Order. . . . . .YESNO DfltVal:N Valid:Y,N 52 ApplyToCreditMemo . . . . . . 1 SYN Apply To Credit Memo. . . . . .YESNO DfltVal:N Valid:Y,N 53 VendorRMANo . . . . . . . . . 10 SYN Vendor RMA Number . . . . . . . FmtType:CHARNUM ValGroup:POIn tegrated 54 InvoiceNotOnFile. . . . . . . 1 SYN Invoice Not On File . . . . . .YESNO DfltVal:Y Valid:Y,N 55 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO FmtType:CHARNUM 56 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO 57 ReplacementRevision . . . . . 3 SNN Replacement Bill Revision Code. 58 ReplacementRepairBillOption1. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 59 ReplacementRepairBillOption2. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 60 ReplacementRepairBillOption3. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 61 ReplacementRepairBillOption4. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 62 ReplacementRepairBillOption5. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 63 ReplacementRepairBillOption6. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 64 ReplacementRepairBillOption7. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 65 ReplacementRepairBillOption8. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 66 ReplacementRepairBillOption9. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 67 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE FmtType:CHARNUM ValGroup:NotC omment 68 Valuation . . . . . . . . . . 1 SYN Valuation . . . . . . . . . . . Valid:1,2,3,4,5,6 ValGroup:No tComment Notes: 1=Std, 2=Avg, 3=Fifo, 4=Lifo, 5=Lot, 6=Serial 69 LotSerialFullyDistributed . . 1 SYN Lot/Serial Fully Distributed. .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 70 Discount. . . . . . . . . . . 1 SYN Discount. . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment, ItemRequired,NotComponent 71 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . . ValGroup:IMIntegrated, NotComment,ItemRequired, RegularItem,NotComponent 72 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS ValGroup:ARSalesTax, NotComment 73 SubjectToExemption. . . . . . 1 SYN Subject to Exemption. . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 74 Commissionable. . . . . . . . 1 SYN Commissionable. . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment, SalespersonReporting, NotComponent 75 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:SalespersonReporting ,OnFileInvoice 76 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO FmtType:CHARNUM ValGroup:Sale spersonReporting,OnFileInvoic e 77 XpressSalesOrderNo. . . . . . 7 SYN Xpress Sales Order Number . . .SALESORDERNO FmtType:CHARNUM 78 PriceOverridden . . . . . . . 1 SYN Price Overridden. . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 79 ReceiptSeqNo. . . . . . . . . 6 SNN Receipt Sequence Number . . . . Mask:000000 FmtType:ZEROFILL 80 HistoryWarehouseCode. . . . . 3 SYN History Warehouse Code. . . . .WAREHOUSE FmtType:CHARNUM ValGroup:IMIn tegrated,OnFileInvoice, ItemRequired,NotComment, MultiWarehouse,RegularItem 81 HistoryCOGSAcctKey. . . . . . 9 SYN History COGS Account Key. . . .ACCOUNT ValGroup:ItemRequired, ItemTypes,OnFileInvoice 82 SkipPrintCompLine . . . . . . 1 SYN Skip Print of Component Line. .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment Notes: in S/O 83 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 84 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 85 QuantityRemaining . . . . . . 16.6 NNN Quantity Remaining. . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 86 InvoiceUnitPrice. . . . . . . 16.6 NNN Invoice Unit Price. . . . . . .PRICE Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes, NotComponent 87 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . Mask:##,###,###.00- ValGroup:NotComment, ItemRequired 88 RestockingCharge. . . . . . . 11.3 NNN Restocking Charge . . . . . . . Mask:###,###.000- ValGroup:No tComment,ItemRequired, ItemTypes 89 InvoiceUnitCost . . . . . . . 16.6 NNN Invoice Unit Cost . . . . . . .COST Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired Notes: Average/Standard 90 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Mask:#####0.0000 ValGroup:Not Comment 91 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment 92 OriginalPrice . . . . . . . . 16.6 NNN Original Price. . . . . . . . .PRICE Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,OnFileInvoice 93 OriginalCost. . . . . . . . . 16.6 NNN Original Cost . . . . . . . . .COST Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,OnFileInvoice 94 InvoiceHistoryQty . . . . . . 16.6 NNN Invoice History Quantity. . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,OnFileInvoice 95 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percent . . . . . Mask:###0.000- ValGroup:NotCo mment,LineDiscount,ItemRequir ed,ItemTypes