     IM_ItemVendor                          IM Item Vendor                 Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: IM_ItemVendor_bus,IM_TransactionRegister_upd,PO_ReceiptRegister_upd,BM_ProductionRegister_upd,
     SQL Def: Y  SysDB: N                                         "MAS_"+%C$+"/IM"+%C$+"/IM_ItemVendor.M4T"

     KPRIMARY: ItemCode+APDivisionNo+VendorNo
     KVENDOR: APDivisionNo+VendorNo+ItemCode

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                    ChngTag:Replace0 Notes:
                                                    {IM_12$(1,15)}
       2  APDivisionNo. . . . . . . . .     2 SYY  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00 Notes: {IM_12$(16,2)}
       3  VendorNo. . . . . . . . . . .     7 SYY  Vendor Number . . . . . . . . .VENDORNO
                                                    ChngTag:Replace1/APDivisionNo
                                                    $ Notes: {IM_12$(18,7)}
       4  VendorAliasItemNo . . . . . .    30 SYN  Vendor Alias Item Number. . . .
                                                    Notes: {IM_12$(25,30)}
       5  LastReceiptDate . . . . . . .     8 SNN  Last Receipt Date . . . . . . .DATE
                                                    Notes: {IM_12$(55,8)}
       6  LastReceiptNo . . . . . . . .     6 SNN  Last Receipt Number . . . . . .
                                                    Notes: {IM_12$(61,6)}
       7  LastReceiptHeaderSeqNo. . . .     6 SNN  Last Receipt Header Sequence Nu
       8  LastReturnDate. . . . . . . .     8 SNN  Last Return Date. . . . . . . .DATE
                                                    Notes: {IM_12$(67,8)}
       9  LastReturnPurchaseOrderNo . .     7 SYN  Last Return Purchase Order NumbPURCHASEORDERNO
      10  LastReturnType. . . . . . . .     1 SYN  Last Return Type. . . . . . . .
                                                    Valid:G,R Notes: G = Goods,
                                                    R = Return
      11  LastReceiptPurchaseOrderNo. .     7 SYN  Last Receipt Purchase Order NumPURCHASEORDERNO
      12  LastReceiptType . . . . . . .     1 SYN  Last Receipt Type . . . . . . .
                                                    Valid:G,R Notes: G = Goods,
                                                    R = Return
      13  LastReturnNo. . . . . . . . .     6 SNN  Last Return Number. . . . . . .
                                                    Notes: {IM_12$(73,6)}
      14  LastReturnHeaderSeqNo . . . .     6 SNN  Last Return Header Sequence Num
      15  VendorWarrantyCode. . . . . .    10 SYN  Vendor Warranty Code. . . . . .WARRANTYCODE
                                                    Notes: {IM_12$(79,10)}
      16  LastReceiptQuantity . . . . . 16.6  NNN  Last Receipt Quantity . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {IM_12[0]}
      17  LastUnitCost. . . . . . . . . 16.6  NNN  Last Unit Cost. . . . . . . . .COST
                                                    Mask:##,###,###.000000-
                                                    Notes: {IM_12[1]}
      18  LastAllocatedUnitCost . . . . 16.6  NNN  Last Allocated Unit Cost. . . .COST
                                                    Mask:##,###,###.000000-
                                                    Notes: {IM_12[2]}
      19  StandardLeadTime. . . . . . .  6.0  NNN  Standard Lead Time. . . . . . .
                                                    Mask:###0 Notes: {IM_12[3]}
      20  LastLeadTime. . . . . . . . .  6.0  NNN  Last Lead Time. . . . . . . . .
                                                    Mask:###0 Notes: {IM_12[4]}
      21  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      22  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                    Read Only:Y
      23  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
      24  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      25  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y
      26  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL