IT_Customer IT Customer Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: IT_Customer_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/IT"+%C$+"/IT_Customer.M4T"
KPRIMARY: ARDivisionNo+CustomerNo
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {IT2$(1,2)}
2 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC Notes:
{IT2$(3,7)}
3 DefaultWarehouseCode. . . . . 3 SYY Default Warehouse Code. . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{IT2$(10,3)}
4 RequireAcceptOfCustChange . . 1 SYN Require Acceptance Of Customer YESNO
DfltVal:N Valid:Y,N Notes:
{IT2$(13,1)}
5 RequireAcceptOfUIDChange. . . 1 SYN Require Acceptance Of Uid ChangYESNO
DfltVal:N Valid:Y,N Notes:
{IT2$(14,1)}
6 RequireAcceptOfSOSubmits. . . 1 SYN Require Acceptance Of SO SubmitYESNO
DfltVal:N Valid:Y,N Notes:
{IT2$(15,1)}
7 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
8 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
9 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
10 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
11 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
12 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL