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