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