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)}