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