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 . . . . . . .