RA_OpenRMAWrk RA Open RMA Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: RA_OpenRMAReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_OpenRMAWrk"+%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 RMADate . . . . . . . . . . . 8 SNN RMA Date. . . . . . . . . . . .DATE 5 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 6 ARDivisionDesc. . . . . . . . 30 SNN AR Division Description . . . . 7 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 8 RMAStatus . . . . . . . . . . 1 SNN RMA Status. . . . . . . . . . . 9 ExpireDate. . . . . . . . . . 8 SNN Expire Date . . . . . . . . . .DATE 10 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . . 11 ReturnToAddressCode . . . . . 4 SNN Return To Address Code. . . . . 12 ReturnToName. . . . . . . . . 30 SNN Return To Name. . . . . . . . . 13 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 14 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 15 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . . 16 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . 17 DetailSeqNo . . . . . . . . . 6 SNN Detail Sequence Number. . . . . 18 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 19 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 20 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 21 ReturnReasonCode. . . . . . . 10 SNN Return Reason Code. . . . . . . 22 CustomerAction. . . . . . . . 1 SNN Customer Action . . . . . . . . 23 ItemAction. . . . . . . . . . 1 SNN Item Action . . . . . . . . . . 24 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 25 ReplacementItemCode . . . . . 30 SNN Replacement Item Code . . . . . 26 ReplacementItemType . . . . . 1 SNN Replacement Item Type . . . . . 27 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 28 CrossShip . . . . . . . . . . 1 SNN Cross Ship. . . . . . . . . . . 29 WarrantyCode. . . . . . . . . 10 SNN WarrantyCode. . . . . . . . . . 30 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE 31 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost Of Goods Sold Account Key. 32 CostOfGoodsSoldAccount. . . . 41 SNN Fully Formatted Cost Of Goods S 33 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . . 34 SalesAccount. . . . . . . . . 41 SNN Fully Formatted Sales Account N 35 HistoryCOGSAcctKey. . . . . . 9 SNN History Cost Of Goods Sold Acct 36 HistoryCOGSAccount. . . . . . 41 SNN Fully Formatted History Cost Of 37 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 38 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 39 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 40 VendorWarrantyCode. . . . . . 10 SNN Vendor Warranty Code. . . . . . 41 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . . 42 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . . 43 InvoiceUnitPrice. . . . . . . 16.6 NNN Invoice Unit Price. . . . . . . 44 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . 45 RestockingCharge. . . . . . . 11.3 NNN Restocking Charge . . . . . . .