RA_ReceiptsHistoryDetail RA Receipts History Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: RA_ReceiptsHistoryDetail_bus,RA_GenerateTransactions_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_ReceiptsHistoryDetail.M4T"
KPRIMARY: RMANo+ReceiptSeqNo+ReceiptDetailSeqNo
KEXTENDEDDESC: ExtendedDescriptionKey+RMANo+ReceiptDetailSeqNo+ReceiptSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO
FmtType:CHARNUM
2 ReceiptDetailSeqNo. . . . . . 6 SNN Receipt Detail Sequence Number.
Mask:000000 FmtType:ZEROFILL
3 ReceiptSeqNo. . . . . . . . . 6 SNN Receipt Sequence Number . . . .
4 InvoiceNo . . . . . . . . . . 7 SYN Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM
5 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . .
Mask:000000 FmtType:ZEROFILL
6 DetailSeqNo . . . . . . . . . 6 SNN Detail Sequence Number. . . . .
Mask:000000 FmtType:ZEROFILL
7 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0
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
10 ExtendedDescriptionKey. . . . 10 SYN Extended Description Key. . . .EXTDESCKEY
Read Only:Y
11 CustomerAction. . . . . . . . 1 SYN Customer Action . . . . . . . .
Valid:C,P,R Notes: C=Credit,
P=rePlacement, R=Repair
12 ItemAction. . . . . . . . . . 1 SYN Item Action . . . . . . . . . .
Valid:S,P,R Notes: S=Stock,
P=scraP, R=Repair
13 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM
14 ReplacementItemCode . . . . . 30 SYN Replacement Item Code . . . . .ITEMCODE
ChngTag:Replace0
15 ReplacementItemType . . . . . 1 SYN Replacement 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
16 VendorAction. . . . . . . . . 1 SYN Vendor Action . . . . . . . . .
Valid:C,P,N Notes: C=Credit,
P=rePlacement, N=None
17 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
18 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/APDivisionNo$
19 ReturnReasonCode. . . . . . . 10 SYN Return Reason Code. . . . . . .RETURNREASONCODE
20 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE
21 DropShip. . . . . . . . . . . 1 SYN Drop Ship . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
22 CrossShip . . . . . . . . . . 1 SYN Cross Ship. . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
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 SNN Alias Item Number . . . . . . .
26 WarrantyCode. . . . . . . . . 10 SYN Warranty Code . . . . . . . . .WARRANTYCODE
27 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE
28 ExpirationDateOverridden. . . 1 SYN Expiration Date Overridden. . .YESNO
DfltVal:N Valid:Y,N
29 SOCostOverridden. . . . . . . 1 SYN SO Cost Overridden. . . . . . .YESNO
DfltVal:N Valid:Y,N
30 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost Of Goods Sold Account Key.
31 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . .
32 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . .
33 BillOption1 . . . . . . . . . 2 SYN Bill Option 1 . . . . . . . . .BILLOPTION
FmtType:CHARNUM
34 BillOption2 . . . . . . . . . 2 SYN Bill Option 2 . . . . . . . . .BILLOPTION
FmtType:CHARNUM
35 BillOption3 . . . . . . . . . 2 SYN Bill Option 3 . . . . . . . . .BILLOPTION
FmtType:CHARNUM
36 BillOption4 . . . . . . . . . 2 SYN Bill Option 4 . . . . . . . . .BILLOPTION
FmtType:CHARNUM
37 BillOption5 . . . . . . . . . 2 SYN Bill Option 5 . . . . . . . . .BILLOPTION
FmtType:CHARNUM
38 BillOption6 . . . . . . . . . 2 SYN Bill Option 6 . . . . . . . . .BILLOPTION
FmtType:CHARNUM
39 BillOption7 . . . . . . . . . 2 SYN Bill Option 7 . . . . . . . . .BILLOPTION
FmtType:CHARNUM
40 BillOption8 . . . . . . . . . 2 SYN Bill Option 8 . . . . . . . . .BILLOPTION
FmtType:CHARNUM
41 BillOption9 . . . . . . . . . 2 SYN Bill Option 9 . . . . . . . . .BILLOPTION
FmtType:CHARNUM
42 SalesKitLineKey . . . . . . . 6 SNN Sales Kit Line Key. . . . . . .
Mask:000000 FmtType:ZEROFILL
43 ExplodedKitItem . . . . . . . 1 SYN Exploded Kit Item . . . . . . .
DfltVal:N Valid:Y,N,C Notes:
Y=Yes, N=No,C=Component
44 StandardKitBill . . . . . . . 1 SYN Standard/Kit Bill . . . . . . .YESNO
DfltVal:N Valid:Y,N
45 BackorderKitCompLines . . . . 1 SYN Backorder Kit Component Lines .YESNO
DfltVal:N Valid:Y,N
46 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT
47 ApplyCommentsToAll. . . . . . 1 SYN Apply Comments to All . . . . .YESNO
DfltVal:N Valid:Y,N
48 ApplyToCustomerRMA. . . . . . 1 SYN Apply to Customer RMA . . . . .YESNO
DfltVal:N Valid:Y,N
49 ApplyToRMAReceiver. . . . . . 1 SYN Apply to RMA Receiver . . . . .YESNO
DfltVal:N Valid:Y,N
50 ApplyToSalesOrder . . . . . . 1 SYN Apply to Sales Order. . . . . .YESNO
DfltVal:N Valid:Y,N
51 ApplyToCreditMemo . . . . . . 1 SYN Apply to Credit Memo. . . . . .YESNO
DfltVal:N Valid:Y,N
52 VendorRMANo . . . . . . . . . 10 SYN Vendor RMA Number . . . . . . .
FmtType:CHARNUM
53 InvoiceNotOnFile. . . . . . . 1 SYN Invoice Not On File . . . . . .YESNO
DfltVal:N Valid:Y,N
54 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO
FmtType:CHARNUM
55 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO
56 ReplacementRevision . . . . . 3 SNN Replacement Bill Revision Code.
57 ReplacementRepairBillOption1. 2 SYN Replacement Repair Bill Option BILLOPTION
FmtType:CHARNUM
58 ReplacementRepairBillOption2. 2 SYN Replacement Repair Bill Option BILLOPTION
FmtType:CHARNUM
59 ReplacementRepairBillOption3. 2 SYN Replacement Repair Bill Option BILLOPTION
FmtType:CHARNUM
60 ReplacementRepairBillOption4. 2 SYN Replacement Repair Bill Option BILLOPTION
FmtType:CHARNUM
61 ReplacementRepairBillOption5. 2 SYN Replacement Repair Bill Option BILLOPTION
FmtType:CHARNUM
62 ReplacementRepairBillOption6. 2 SYN Replacement Repair Bill Option BILLOPTION
FmtType:CHARNUM
63 ReplacementRepairBillOption7. 2 SYN Replacement Repair Bill Option BILLOPTION
FmtType:CHARNUM
64 ReplacementRepairBillOption8. 2 SYN Replacement Repair Bill Option BILLOPTION
FmtType:CHARNUM
65 ReplacementRepairBillOption9. 2 SYN Replacement Repair Bill Option BILLOPTION
FmtType:CHARNUM
66 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE
FmtType:CHARNUM
67 Valuation . . . . . . . . . . 1 SYN Valuation . . . . . . . . . . .
Valid:1,2,3,4,5,6 Notes:
1=Std, 2=Avg, 3=Fifo, 4=Lifo,
5=Lot, 6=Serial
68 XpressGeneratedSONo . . . . . 7 SYN Xpress/Generated SO Number. . .SALESORDERNO
FmtType:CHARNUM
69 GeneratedCMInvoiceNo. . . . . 7 SYN Generated CM Invoice Number . .INVOICE
FmtType:MASTERNUM
70 GeneratedPurchaseOrderNo. . . 7 SYN Generated Purchase Order Number
FmtType:CHARNUM
71 GeneratedPOReturnNo . . . . . 7 SYN Generated PO Return Number. . .
FmtType:CHARNUM
72 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION
Mask:00 FmtType:ZEROFILL
73 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO
FmtType:CHARNUM
74 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . .QUANTITY
Mask:##,###,###.000000-
75 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY
Mask:##,###,###.000000-
76 QuantityRemaining . . . . . . 16.6 NNN Quantity Remaining. . . . . . .QUANTITY
Mask:##,###,###.000000-
77 InvoiceUnitPrice. . . . . . . 16.6 NNN Invoice Unit Price. . . . . . .PRICE
Mask:##,###,###.000000-
78 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .
Mask:##,###,###.00
79 RestockingCharge. . . . . . . 11.3 NNN Restocking Charge . . . . . . .
Mask:###,###.000-
80 InvoiceUnitCost . . . . . . . 16.6 NNN Invoice Unit Cost . . . . . . .COST
Mask:##,###,###.000000-
Notes: Average/Standard
81 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR
Mask:#####0.0000
82 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . .QUANTITY
Mask:##,###,###.000000-