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