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