RA_GenerateTransactionsWrk RA Generate Transactions Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: RA_GenerateTransactions_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_GenerateTransactionsWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 9 SNN Group Field . . . . . . . . . . 3 DocumentType. . . . . . . . . 1 SNN Document Type . . . . . . . . . 4 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . . 5 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 6 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 7 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 8 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 9 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 10 ActualInvoiceNo . . . . . . . 7 SNN Actual Invoice Number . . . . . 11 SequenceNo. . . . . . . . . . 6 SNN Sequence Number . . . . . . . . 12 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 13 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 14 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 15 ReceiptsDetailLineKey . . . . 6 SNN Receipts Detail Line Key. . . . 16 SOPOBatchNo . . . . . . . . . 5 SNN SO/PO Batch Number. . . . . . . 17 CustomerAction. . . . . . . . 1 SNN Customer Action . . . . . . . . 18 ItemAction. . . . . . . . . . 1 SNN Item Action . . . . . . . . . . 19 ReplacementItemCode . . . . . 30 SNN Replacement Item Code . . . . . 20 ReplacementItemType . . . . . 1 SNN Replacement Item Type . . . . . 21 VendorAction. . . . . . . . . 1 SNN Vendor Action . . . . . . . . . 22 DropShip. . . . . . . . . . . 1 SNN Drop Ship . . . . . . . . . . . 23 CrossShip . . . . . . . . . . 1 SNN Cross Ship. . . . . . . . . . . 24 CreditFreight . . . . . . . . 1 SNN Credit Freight. . . . . . . . . 25 WarrantyCode. . . . . . . . . 10 SNN Warranty Code . . . . . . . . . 26 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE 27 ExpirationDateOverridden. . . 1 SNN Expiration Date Overridden. . . 28 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost Of Goods Sold Account Key. 29 CostOfGoodsSoldAccount. . . . 41 SNN Fully Formatted Cost Of Goods S 30 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . . 31 SalesAccount. . . . . . . . . 41 SNN Fully Formatted Sales Account N 32 HistoryCOGSAcctKey. . . . . . 9 SNN History Cost Of Goods Sold Acco 33 HistoryCOGSAccount. . . . . . 41 SNN Fully Formatted History Cost Of 34 CommentText . . . . . . . . . 2048 SNN . . . . . . . . . . . . . . . 35 InvoiceNotOnFile. . . . . . . 1 SNN Invoice Not On File . . . . . . 36 GenerateDocumentSO. . . . . . 1 SNN Generate Document Sales Order . 37 GenerateDocumentCM. . . . . . 1 SNN Generate Document Credit Memo . 38 GenerateDocumentRO. . . . . . 1 SNN Generate Document Return Order. 39 GenerateDocumentPO. . . . . . 1 SNN Generate Document Purchase Orde 40 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . . 41 InvoiceUnitPrice. . . . . . . 16.6 NNN Invoice Unit Price. . . . . . . 42 RestockingCharge. . . . . . . 11.3 NNN Restocking Charge . . . . . . .