CI_MiscItemDetailTransWrk CI Miscellaneous Item Detail TransactionRel: 4.40 Bld: 398 8/28/2009 Bus Obj: CI_MiscItemDetailTrans_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/CI"+%C$+"/CI_MiscItemDetailTransWrk"+%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 SalesUnitOfMeasure. . . . . . 4 SNN Sales Unit of Measure . . . . . 6 PurchaseUnitOfMeasure . . . . 4 SNN Purchase Unit of Measure. . . . 7 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE 8 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 9 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 10 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 11 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 12 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 13 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 14 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 15 TransactionCode . . . . . . . 2 SNN Transaction Code. . . . . . . . 16 EntryNo . . . . . . . . . . . 10 SNN Entry Number. . . . . . . . . . 17 SequenceNo. . . . . . . . . . 6 SNN Sequence Number . . . . . . . . 18 ReferenceDate . . . . . . . . 8 SNN Reference Date. . . . . . . . .DATE 19 TransactionQty. . . . . . . . 16.6 NNN Transaction Quantity. . . . . . 20 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . . 21 ExtendedPrice . . . . . . . . 15.2 NNN Extended Price. . . . . . . . . 22 ExtendedCost. . . . . . . . . 15.2 NNN Extended Cost . . . . . . . . .