IT_UIDCustomerChange IT UID Customer Change Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: IT_UIDCustomerChange_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/IT"+%C$+"/IT_UIDCustomerChange.M4T"
KPRIMARY: ChangeType+UserID+ARDivisionNo+CustomerNo+DateSubmitted+TimeSubmitted
KCUSTUID: ARDivisionNo+CustomerNo+UserID+ChangeType+DateSubmitted+TimeSubmitted
KSTATUS: Status+ChangeType+UserID+ARDivisionNo+CustomerNo+DateSubmitted+TimeSubmitted
KEMAILADDR: EmailAddress+ChangeType+UserID+ARDivisionNo(**)+CustomerNo+DateSubmitted+TimeSubmitted **=
Case Sensitive
Fld Column Name M/L TUR Description/Notes Class
1 ChangeType. . . . . . . . . . 1 SYY Change Type . . . . . . . . . .
Valid:1,2,3 Notes: 1=order
user ID Change, 2=order
customer change, 3=store
profile change (both user ID
and customer), {IT8$(1,1)}
2 UserID. . . . . . . . . . . . 15 SYN e Business Manager User ID. . .
FmtType:CHARNUM
3 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00
4 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO
5 DateSubmitted . . . . . . . . 8 SNY Date Submitted. . . . . . . . .DATE
Notes: {IT8$(17,6)}
6 TimeSubmitted . . . . . . . . 6 SNY Time Submitted. . . . . . . . .
Notes: {IT8$(23,6)}
7 UserIDSubmittingChange. . . . 15 SYY User ID Submitting Change . . .
FmtType:CHARNUM Notes:
{IT8$(29,15)}
8 Status. . . . . . . . . . . . 1 SYY Status. . . . . . . . . . . . .
DfltVal:A Valid:A,M,P,R,S,U,
E Notes: M=Manual Accept,
A=Auto Accept, P=Pending,
R=Reject,, S=Suspended,
U=Updated, E=Error {IT8$(44,
1)}
9 EmailReasonCode . . . . . . . 5 SYN Email Reason Code . . . . . . .EMAILREASONCODE
Notes: {IT8$(45,5)}
10 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .NAME
ValGroup:CustomerChange
Notes: {IT8$(50,30)}
11 UserName. . . . . . . . . . . 30 SNN User Name . . . . . . . . . . .NAME
ValGroup:UserProfileChange
12 AddressLine1. . . . . . . . . 30 SNN Address Line 1. . . . . . . . .ADDRESSLINE
Notes: {IT8$(80,30)}
13 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . .ADDRESSLINE
Notes: {IT8$(110,30)}
14 AddressLine3. . . . . . . . . 30 SNN Address Line 3. . . . . . . . .ADDRESSLINE
Notes: {IT8$(140,30)}
15 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . .CITY
Notes: {IT8$(170,20)}
16 State . . . . . . . . . . . . 2 SNN State . . . . . . . . . . . . .STATE
Notes: {IT8$(190,2)}
17 ZipCode . . . . . . . . . . . 10 SNN Zip Code. . . . . . . . . . . .ZIPCODE
Notes: {IT8$(192,10)}
18 CountryCode . . . . . . . . . 3 SYN Country Code. . . . . . . . . .COUNTRY
Notes: {IT8$(202,3)}
19 TelephoneNo . . . . . . . . . 17 SNN Customer Telephone No . . . . .TELEPHONENO
ValGroup:CustomerChange
20 TelephoneExt. . . . . . . . . 5 SNN Customer Telephone Extension. .TELEPHONEEXT
ValGroup:CustomerChange
21 TelephoneNo1. . . . . . . . . 17 SNN User Telephone Number 1 . . . .TELEPHONENO
ValGroup:UserProfileChange
Notes: {IT8$(205,17)}
22 TelephoneExt1 . . . . . . . . 5 SNN User Telephone Extension 1. . .TELEPHONEEXT
ValGroup:UserProfileChange
Notes: {IT8$(222,5)}
23 TelephoneNo2. . . . . . . . . 17 SNN User Telephone Number 2 . . . .TELEPHONENO
ValGroup:UserProfileChange
Notes: {IT8$(227,17)}
24 TelephoneExt2 . . . . . . . . 5 SNN User Telephone Extension 2. . .TELEPHONEEXT
ValGroup:UserProfileChange
Notes: Customer Only
{IT8$(316,50)}
25 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO
Notes: {IT8$(249,17)}
26 EmailAddress. . . . . . . . . 50 SNN Email Address . . . . . . . . .EMAILADDRESS
Notes: {IT8$(266,50)}
27 URLAddress. . . . . . . . . . 50 SNN URL Address . . . . . . . . . .URLADDRESS
ValGroup:CustomerChange
Notes: Customer Only
{IT8$(316,50)}
28 ShipMethod. . . . . . . . . . 15 SNN Ship Method . . . . . . . . . .SHIPCODE
ValGroup:CustomerChange
29 Title . . . . . . . . . . . . 15 SNN Title . . . . . . . . . . . . .
ValGroup:UserChange Notes:
UID Only {IT8$(366,15)}
30 SuspendAccess . . . . . . . . 1 SNN Suspend Access. . . . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:UserChange Notes:
{IT8$(381,1)}
31 Password. . . . . . . . . . . 25 SNN Password. . . . . . . . . . . .
ValGroup:UserProfileChange
Notes: {IT8$(382,25)}
32 AllowSubmissionOfShoppingCart 1 SNN Allow Submission Of Shopping CaYESNO
DfltVal:N Valid:Y,N
ValGroup:UserChange Notes:
{IT8$(407,1)}