CI_ItemTransactionHistory              CI Item Transaction History    Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: CI_ItemTransactionHistory_bus,PO_ReturnRegister_upd,PO_ReceiptRegister_upd,BM_ProductionRegist
 SQL Def: Y  SysDB: N                             "MAS_"+%C$+"/CI"+%C$+"/CI_ItemTransactionHistory.M4T"

 kPRIMARY: ItemCode+TransactionDate+TransactionCode+EntryNo+SequenceNo
 kITEMYEARPER: ItemCode+FiscalCalYear+FiscalCalPeriod+TransactionDate+TransactionCode+EntryNo+SequenceNo
 kTRANDATE: TransactionDate+ItemCode+TransactionCode+EntryNo+SequenceNo
 kVENDOR: APDivisionNo+VendorNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode+TransactionDate+Transa
          ctionCode+EntryNo+SequenceNo
 kCUSTOMER: ARDivisionNo+CustomerNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode+TransactionDate+Tr
            ansactionCode+EntryNo+SequenceNo

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                ChngTag:Replace0 Notes:
                                                {IM5$(1,15)}
   2  TransactionDate . . . . . . .     8 SNY  Transaction Date. . . . . . . .DATE
                                                Notes: {IM5$(19,6)}
   3  TransactionCode . . . . . . .     2 SYY  Transaction Code. . . . . . . .
                                                Valid:AR,IC,BC,WC,BI,BR,BZ,
                                                IA,II,IN,IP,IR,IS,IT,IX,IZ,
                                                PM,PO,SI,SO,SK,WI,WR,PS,SP,
                                                SR,SS,PA,PZ,SZ,WZ Notes:
                                                {IM5$(25,2)}
   4  EntryNo . . . . . . . . . . .    10 SYY  Entry Number. . . . . . . . . .
                                                FmtType:ZEROFILL Notes:
                                                {IM5$(27,10)}
   5  SequenceNo. . . . . . . . . .     6 SNY  Sequence Number . . . . . . . .
                                                Mask:000000 FmtType:ZEROFILL
                                                Notes: {IM5$(37,3)}
   6  ItemType. . . . . . . . . . .     1 SNY  Item Type . . . . . . . . . . .
                                                Read Only:Y Valid:2,3,5
                                                Notes: 2=Special Item,
                                                3=Charge Item, 5=Miscellaneou
                                                s Item
   7  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .APDIVISION
                                                Mask:00 Notes: {IM5$(55,2)}
   8  VendorNo. . . . . . . . . . .     7 SNN  Vendor Number . . . . . . . . .VENDORNO
                                                ChngTag:Replace1/APDivisionNo
                                                $ Notes: {IM5$(57,7)}
   9  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                Mask:00 Notes: {IM5$(55,2)}
  10  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .CUSTOMERNO
                                                ChngTag:Replace1/ARDivisionNo
                                                $ Notes: {IM5$(57,7)}
  11  ReferenceDate . . . . . . . .     8 SNN  Reference Date. . . . . . . . .DATE
                                                Notes: {IM5$(64,6)}
  12  FiscalCalYear . . . . . . . .     4 SNN  Fiscal Calendar Year. . . . . .YEAR
                                                Mask:0000 Notes: {IM5$(70,4)}
  13  FiscalCalPeriod . . . . . . .     2 SNN  Fiscal Calendar Period. . . . .FISCALPERIOD
                                                Mask:00 Notes: {IM5$(74,2)}
  14  ShipToCode. . . . . . . . . .     4 SNN  Ship To Code. . . . . . . . . .SHIPTO
                                                Notes: {IM5$(76,4)}
  15  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
                                                Valid:CM,DM,IN,CA,AD
  16  TransactionQty. . . . . . . . 16.6  NNN  Transaction Quantity. . . . . .QUANTITY
                                                Read Only:Y Mask:##,###,
                                                ###.000000- ChngTag:Sum
                                                Notes: {IM5[0]}
  17  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                Read Only:Y Mask:##,###,
                                                ###.000000- Notes: {IM5[1]}
  18  AllocatedCost . . . . . . . . 16.6  NNN  Allocated Cost. . . . . . . . .COST
                                                Read Only:Y Mask:##,###,
                                                ###.000000- Notes: {IM5[2]}
  19  UnitPrice . . . . . . . . . . 16.6  NNN  Unit Price. . . . . . . . . . .PRICE
                                                Read Only:Y Mask:##,###,
                                                ###.000000- Notes: {IM5[3]}
  20  ExtendedPrice . . . . . . . . 15.2  NNN  Extended Price. . . . . . . . .
                                                Read Only:Y Mask:##,###,###,
                                                ###.00- ChngTag:Sum
  21  ExtendedCost. . . . . . . . . 15.2  NNN  Extended Cost . . . . . . . . .IMCOST
                                                Read Only:Y ChngTag:Sum
  22  DateUpdated . . . . . . . . .     8 SNY  Last Update Date. . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  23  TimeUpdated . . . . . . . . .     8 SNY  Last Update Time. . . . . . . .
                                                Read Only:Y
  24  UserUpdatedKey. . . . . . . .    10 SYY  Last Update User ID . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL