IM_DetailTransactionWrk IM Detail Transaction Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_DetailTransactionReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_DetailTransactionWrk"+%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 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 4 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 5 StandardUnitOfMeasure . . . . 4 SNN Standard Unit of Measure. . . . 6 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 7 ProductLineDesc . . . . . . . 25 SNN Product Line Description. . . . 8 Valuation . . . . . . . . . . 1 SNN Valuation . . . . . . . . . . . 9 PrimaryAPDivisionNo . . . . . 2 SNN Primary AP Division Number. . . 10 PrimaryVendorNo . . . . . . . 7 SNN Primary Vendor Number . . . . . 11 PrimaryVendorName . . . . . . 30 SNN Primary Vendor Name . . . . . . 12 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 13 WarehouseDesc . . . . . . . . 30 SNN Warehouse Description . . . . . 14 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE 15 IMTransactionEntryComment . . 30 SNN IM Transaction Entry Comment. .COMMENT30 16 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 17 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 18 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 19 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 20 TransactionCode . . . . . . . 2 SNN Transaction Code. . . . . . . . 21 EntryNo . . . . . . . . . . . 10 SNN Entry Number. . . . . . . . . . 22 SequenceNo. . . . . . . . . . 6 SNN Sequence Number . . . . . . . . 23 LotSerialSeqNo. . . . . . . . 6 SNN Lot Serial Sequence Number. . . 24 ReferenceDate . . . . . . . . 8 SNN Reference Date. . . . . . . . .DATE 25 LotSerialNo . . . . . . . . . 15 SNN Lot Serial Number . . . . . . . 26 Category1Desc . . . . . . . . 15 SNN Category 1 Description. . . . . 27 Category1 . . . . . . . . . . 10 SNN Category 1. . . . . . . . . . . 28 Category2Desc . . . . . . . . 15 SNN Category 2 Description. . . . . 29 Category2 . . . . . . . . . . 10 SNN Category 2. . . . . . . . . . . 30 Category3Desc . . . . . . . . 15 SNN Category 3 Description. . . . . 31 Category3 . . . . . . . . . . 10 SNN Category 3. . . . . . . . . . . 32 Category4Desc . . . . . . . . 15 SNN Category 4 Description. . . . . 33 Category4 . . . . . . . . . . 10 SNN Category 4. . . . . . . . . . . 34 BeginningBalQty . . . . . . . 16.6 NNN Beginning Balance Quantity. . . 35 BeginningBalDollarAmt . . . . 15.2 NNN Beginning Balance Dollar Amount 36 BeginningBalExtendedStdCost . 15.2 NNN Beginning Balance Extended Stan 37 TransactionQty. . . . . . . . 16.6 NNN Transaction Quantity. . . . . . 38 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . . 39 StandardUnitCost. . . . . . . 16.6 NNN Standard Unit Cost. . . . . . . 40 ExtendedCost. . . . . . . . . 15.2 NNN Extended Cost . . . . . . . . . 41 ExtendedStandardCost. . . . . 15.2 NNN Extended Standard Cost. . . . . 42 LotSerialNoTransactionQty . . 16.6 NNN Lot Serial Number Transaction Q 43 LotSerialNoUnitCost . . . . . 16.6 NNN Lot Serial Number Unit Cost . . 44 LotSerialNoExtendedCost . . . 15.2 NNN Lot Serial Number Extended Cost