IM_AliasItem IM Alias Item Number Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_AliasItem_bus,BC_CommonImport SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_AliasItem.M4T"
KPRIMARY: ItemCode+AliasItemNo+Type+ARDivisionNo+CustomerNo+APDivisionNo+VendorNo KALIAS: AliasItemNo+ItemCode+Type+ARDivisionNo+CustomerNo+APDivisionNo+VendorNo KCUSTOMER: Type+ARDivisionNo+CustomerNo+AliasItemNo+ItemCode+APDivisionNo+VendorNo KVENDOR: Type+APDivisionNo+VendorNo+AliasItemNo+ItemCode+ARDivisionNo+CustomerNo KCUSTOMERITEM: Type+ARDivisionNo+CustomerNo+ItemCode+AliasItemNo+APDivisionNo+VendorNo KVENDORITEM: Type+APDivisionNo+VendorNo+ItemCode+AliasItemNo+ARDivisionNo+CustomerNo KITEMCUSTOMER: ItemCode+Type+ARDivisionNo+CustomerNo+AliasItemNo
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: {IM_04$(1,15)} 2 AliasItemNo . . . . . . . . . 30 SYY Alias Item Number . . . . . . . Notes: {IM_04$(16,30)} 3 Type. . . . . . . . . . . . . 1 SYY Type. . . . . . . . . . . . . . DfltVal:G Valid:C,V,G Notes: {IM_04$(46,1)}C=Customer, G=General, V=Vendor 4 ARDivisionNo. . . . . . . . . 2 SYN AR Division Number. . . . . . .ARDIVISION Mask:00 DepVal:REQUIRED Notes: {IM_04$(47,2)}Type="C" Only 5 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC DepVal:REQ UIRED ChngTag:Replace1/ARDivi sionNo$ Notes: {IM_04$(49, 7)}Type="C" only 6 APDivisionNo. . . . . . . . . 2 SYN AP Division Number. . . . . . .APDIVISION Mask:00 DepVal:REQUIRED Notes: {IM_04$(47,2)}Type="V" only 7 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM DepVal:REQU IRED ChngTag:Replace1/APDivis ionNo$ Notes: {IM_04$(49, 7)}Type="V" only 8 AliasItemDesc . . . . . . . . 30 SNN Alias Item Description. . . . .DESCRIPTION Notes: {IM_04$(56,30)} 9 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 10 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 11 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 12 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 13 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 14 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL