RA_ReceiptsHistoryWrk RA Receipts History Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: RA_ReceiptsHistoryReport_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_ReceiptsHistoryWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . .
2 GroupField. . . . . . . . . . 30 SNN Group Field . . . . . . . . . .
3 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . .
4 ReceiptSeqNo. . . . . . . . . 6 SNN Receipt Sequence Number . . . .
5 RMADate . . . . . . . . . . . 8 SNN RMA Date. . . . . . . . . . . .DATE
6 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .
7 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .
8 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .
9 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .
10 CrossShip . . . . . . . . . . 1 SNN Cross Ship. . . . . . . . . . .
11 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . .
12 BillToAddress1. . . . . . . . 30 SNN Bill To Address 1 . . . . . . .
13 BillToAddress2. . . . . . . . 30 SNN Bill To Address 2 . . . . . . .
14 BillToAddress3. . . . . . . . 30 SNN Bill To Address 3 . . . . . . .
15 BillToCity. . . . . . . . . . 20 SNN Bill To City. . . . . . . . . .
16 BillToState . . . . . . . . . 2 SNN Bill To State . . . . . . . . .
17 BillToZipCode . . . . . . . . 10 SNN Bill To Zip Code. . . . . . . .
18 BillToCountryCode . . . . . . 3 SNN Bill To Country Code. . . . . .
19 BillToCountryName . . . . . . 30 SNN Bill To Country Name. . . . . .
20 ShipToName. . . . . . . . . . 30 SNN ShipToName. . . . . . . . . . .
21 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .
22 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .
23 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .
24 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .
25 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . .
26 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . .
27 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . .
28 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . .
29 ReturnShipVia . . . . . . . . 15 SNN Return Ship Via . . . . . . . .
30 ReturnToAddressCode . . . . . 4 SNN Return To Address Code. . . . .
31 ReturnToName. . . . . . . . . 30 SNN Return To Name. . . . . . . . .
32 ReturnToAddress1. . . . . . . 30 SNN Return To Address 1 . . . . . .
33 ReturnToAddress2. . . . . . . 30 SNN Return To Address 2 . . . . . .
34 ReturnToAddress3. . . . . . . 30 SNN Return To Address 3 . . . . . .
35 ReturnToCity. . . . . . . . . 20 SNN Return To City. . . . . . . . .
36 ReturnToState . . . . . . . . 2 SNN Return To State . . . . . . . .
37 ReturnToZipCode . . . . . . . 10 SNN Return To Zip Code. . . . . . .
38 ReturnToCountryCode . . . . . 3 SNN Return To Country Code. . . . .
39 ReturnToCountryName . . . . . 30 SNN Return To Country Name. . . . .
40 ReceiptDate . . . . . . . . . 8 SNN Receipt Date. . . . . . . . . .DATE
41 ReceiptDetailSeqNo. . . . . . 6 SNN Receipt Detail Sequence Number.
Mask:000000
42 InvoiceNo . . . . . . . . . . 7 SNN Invoice No. . . . . . . . . . .
43 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . .
44 DetailSeqNo . . . . . . . . . 6 SNN Detail Sequence Number. . . . .
45 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . .
46 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . .
47 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .
48 CustomerAction. . . . . . . . 1 SNN Customer Action . . . . . . . .
49 ItemAction. . . . . . . . . . 1 SNN Item Action . . . . . . . . . .
50 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . .
51 ReplacementItemCode . . . . . 30 SNN Replacement Item Code . . . . .
52 ReplacementItemType . . . . . 1 SNN Replacement Item Type . . . . .
53 VendorAction. . . . . . . . . 1 SNN Vendor Action . . . . . . . . .
54 ReturnReasonCode. . . . . . . 10 SNN Return Reason Code. . . . . . .
55 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . .
56 DropShip. . . . . . . . . . . 1 SNN Drop Ship . . . . . . . . . . .
57 CrossShipItem . . . . . . . . 1 SNN Cross Ship Item . . . . . . . .
58 WarrantyCode. . . . . . . . . 10 SNN Warranty Code . . . . . . . . .
59 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE
60 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . .
61 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .
62 XpressGeneratedSONo . . . . . 7 SNN Xpress/Generated SO Number. . .
63 GeneratedCMInvoiceNo. . . . . 7 SNN Generated CM Invoice Number . .
64 GeneratedPurchaseOrderNo. . . 7 SNN Generated Purchase Order Number
65 GeneratedPOReturnNo . . . . . 7 SNN Generated PO Return Number. . .
66 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost Of Goods Sold Account Key.
67 CostOfGoodsSoldAccount. . . . 41 SNN Fully Formatted Cost Of Goods S
68 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . .
69 SalesAccount. . . . . . . . . 41 SNN Fully Formatted Sales Account N
70 LotSerialNo . . . . . . . . . 15 SNN Lot Serial Number . . . . . . .
71 TierType. . . . . . . . . . . 1 SNN Tier Type . . . . . . . . . . .
72 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . .
73 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .
74 LotSerialQuantityReceived . . 16.6 NNN Lot Serial Quantity Received. .
75 InvoiceUnitPrice. . . . . . . 16.6 NNN Invoice Unit Price. . . . . . .
76 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .
77 RestockingCharge. . . . . . . 11.3 NNN Restocking Charge . . . . . . .