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