     IM_LotSerialTransactionHistory        IM Lot Serial Transaction HistorRel: 4.40  Bld: 398  8/28/2009
     Bus Obj: IM_LotSerialTransactionHistory_bus,IM_TransactionRegister_upd,PO_ReceiptRegister_upd,PO_Return
     SQL Def: Y  SysDB: N                        "MAS_"+%C$+"/IM"+%C$+"/IM_LotSerialTransactionHistory.M4T"

     KPRIMARY: ItemCode+WarehouseCode+TransactionDate+TransactionCode+EntryNo+SequenceNo+LotSerialSeqNo
     KLOTSERIAL: ItemCode+LotSerialNo+TransactionDate+WarehouseCode+TransactionCode+EntryNo+SequenceNo
     KTRANSDATE: TransactionDate+ItemCode+WarehouseCode+TransactionCode+EntryNo+SequenceNo+LotSerialSeqNo
     KVENDOR: APDivisionNo+VendorNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode+WarehouseCode+Transact
              ionDate+TransactionCode+EntryNo+SequenceNo+LotSerialSeqNo
     KCUSTOMER: ARDivisionNo+CustomerNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode+WarehouseCode+Tran
                sactionDate+TransactionCode+EntryNo+SequenceNo+LotSerialSeqNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                    ChngTag:Replace0 Notes:
                                                    {IM5$(1,15)}
       2  WarehouseCode . . . . . . . .     3 SYY  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM Notes:
                                                    {IM5$(16,3)}
       3  TransactionDate . . . . . . .     8 SNY  Transaction Date. . . . . . . .DATE
                                                    Notes: {IM5$(19,6)}
       4  TransactionCode . . . . . . .     2 SYY  Transaction Code. . . . . . . .
                                                    Valid: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)}
       5  EntryNo . . . . . . . . . . .    10 SYY  Entry Number. . . . . . . . . .
                                                    Notes: {IM5$(27,10)}
       6  SequenceNo. . . . . . . . . .     6 SNY  Sequence Number from IM Transac
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {IM5$(37,3)}
       7  LotSerialSeqNo. . . . . . . .     6 SNY  Lot Serial Sequence Number. . .
                                                    Mask:000000 FmtType:ZEROFILL
       8  LotSerialNo . . . . . . . . .    15 SYY  Lot Serial Number . . . . . . .
                                                    Notes: {IM5$(40,15)}
       9  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00 Notes: {IM5$(55,2)}
      10  VendorNo. . . . . . . . . . .     7 SYN  Vendor Number . . . . . . . . .VENDORNO
                                                    Notes: {IM5$(57,7)}
      11  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 Notes: {IM5$(55,2)}
      12  CustomerNo. . . . . . . . . .    20 SYN  Customer Number . . . . . . . .CUSTOMERNO
                                                    ChngTag:Replace1/ARDivisionNo
                                                    $ Notes: {IM5$(57,7)}
      13  ReferenceDate . . . . . . . .     8 SNN  Reference Date. . . . . . . . .DATE
                                                    Notes: {IM5$(64,6)}
      14  FiscalCalYear . . . . . . . .     4 SNN  Fiscal or Calendar Year . . . .YEAR
                                                    Mask:0000 Notes: {IM5$(70,4)}
      15  FiscalCalPeriod . . . . . . .     2 SNN  Fiscal or Calendar Period . . .FISCALPERIOD
                                                    Mask:00 Notes: {IM5$(74,2)}
      16  ShipToCode. . . . . . . . . .     4 SNN  Ship To Code. . . . . . . . . .SHIPTO
                                                    Notes: {IM5$(76,4)}
      17  TransactionQty. . . . . . . . 16.6  NNN  Transaction Quantity. . . . . .QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- ChngTag:Sum
                                                    Notes: {IM5[0]}
      18  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- Notes: {IM5[1]}
      19  AllocatedCost . . . . . . . . 16.6  NNN  Allocated Cost. . . . . . . . .IMCOST
                                                    Read Only:Y Notes: {IM5[2]}
      20  UnitPrice . . . . . . . . . . 16.6  NNN  Unit Price. . . . . . . . . . .PRICE
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- Notes: {IM5[3]}
      21  ExtendedPrice . . . . . . . . 15.2  NNN  Extended Price. . . . . . . . .
                                                    Read Only:Y Mask:##,###,###,
                                                    ###.00- ChngTag:Sum
      22  ExtendedCost. . . . . . . . . 15.2  NNN  Extended Cost . . . . . . . . .IMCOST
                                                    Read Only:Y ChngTag:Sum
      23  DateUpdated . . . . . . . . .     8 SNY  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      24  TimeUpdated . . . . . . . . .     8 SNY  Last Update Time. . . . . . . .
                                                    Read Only:Y
      25  UserUpdatedKey. . . . . . . .    10 SYY  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL