AR_CustomerContact AR Customer Contact Rel: 7.50 Bld: 408 6/29/2026 Physical Path: "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerContact.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: N Create Tbl: N Bus Obj: AR_CustomerContact_bus
KPRIMARY: ARDivisionNo+CustomerNo+ContactCode KCONTACTNAME: ContactName+ARDivisionNo+CustomerNo+ContactCode KADDRESS1: AddressLine1+ARDivisionNo+CustomerNo+ContactCode KADDRESS2: AddressLine2+ARDivisionNo+CustomerNo+ContactCode KADDRESS3: AddressLine3+ARDivisionNo+CustomerNo+ContactCode KZIPCODE: ZipCode+ARDivisionNo+CustomerNo+ContactCode KPHONENO1: TelephoneNo1+ARDivisionNo+CustomerNo+ContactCode KPHONENO2: TelephoneNo2+ARDivisionNo+CustomerNo+ContactCode KEMAILADDRESS: EmailAddress+ARDivisionNo+CustomerNo+ContactCode
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {AR_12$(1,2)} 2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ Notes: {AR_12$(3,7)} 3 ContactCode . . . . . . . . . 10 SYY Contact Code. . . . . . . . . .ARCONTACT Notes: {AR_12$(10,10)} 4 ContactName . . . . . . . . . 50 SNN Contact Name. . . . . . . . . .NAME DepVal:REQUIRED ValGroup:CRM, ConsumerPII Notes: {AR_12$(20 ,30)} 5 AddressLine1. . . . . . . . . 40 SNN Contact Address Line 1. . . . .ADDRESSLINE ValGroup:CRM,ConsumerPII Notes: {AR_12$(50,30)} 6 AddressLine2. . . . . . . . . 40 SNN Contact Address Line 2. . . . .ADDRESSLINE ValGroup:CRM,ConsumerPII Notes: {AR_12$(80,30)} 7 AddressLine3. . . . . . . . . 40 SNN Contact Address Line 3. . . . .ADDRESSLINE ValGroup:CRM,ConsumerPII Notes: {AR_12$(110,30)} 8 City. . . . . . . . . . . . . 30 SNN Contact City. . . . . . . . . .CITY ValGroup:CRM,ConsumerPII Notes: {AR_12$(140,20)} 9 State . . . . . . . . . . . . 2 SYN Contact State . . . . . . . . .STATE ValGroup:CRM,ConsumerPII Notes: {AR_12$(160,2)} 10 ZipCode . . . . . . . . . . . 10 SYN Contact Zip Code. . . . . . . .ZIPCODE ValGroup:CRM,ConsumerPII Notes: {AR_12$(162,10)} 11 CountryCode . . . . . . . . . 3 SYN Contact Country Code. . . . . .COUNTRY ValGroup:CRM,ConsumerPII Notes: {AR_12$(172,3)} 12 Salutation. . . . . . . . . . 10 SNN Contact Salutation. . . . . . . ValGroup:CRM,ConsumerPII Notes: {AR_12$(192,10)} 13 ContactTitle. . . . . . . . . 15 SNN Contact Title . . . . . . . . . ValGroup:CRM,ConsumerPII Notes: {AR_12$(202,15)} 14 TelephoneNo1. . . . . . . . . 20 SNN Contact Telephone Number 1. . .TELEPHONENO ValGroup:CRM,ConsumerPII Notes: {AR_12$(217,17)} 15 TelephoneExt1 . . . . . . . . 6 SNN Contact Telephone Extension 1 .TELEPHONEEXT ValGroup:CRM,ConsumerPII Notes: {AR_12$(234,5)} 16 TelephoneType1. . . . . . . . 1 SYN Telephone Type 1. . . . . . . . DfltVal:W Valid:W,C,H,O ValGroup:CRM Notes: W-Work, C=Cell, H=Home, O=Other 17 PrimaryTelephone1 . . . . . . 1 SYY Primary Telephone 1 . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:CRM 18 TelephoneNo2. . . . . . . . . 20 SNN Contact Telephone Number 2. . .TELEPHONENO ValGroup:CRM,ConsumerPII Notes: {AR_12$(239,17)} 19 TelephoneExt2 . . . . . . . . 6 SNN Contact Telephone Extension 2 .TELEPHONEEXT ValGroup:CRM,ConsumerPII Notes: {AR_12$(256,5)} 20 TelephoneType2. . . . . . . . 1 SYN Telephone Type 2. . . . . . . . DfltVal:W Valid:W,C,H,O ValGroup:CRM Notes: W-Work, C=Cell, H=Home, O=Other 21 PrimaryTelephone2 . . . . . . 1 SYY Primary Telephone 2 . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:CRM 22 FaxNo . . . . . . . . . . . . 20 SNN Fax Number. . . . . . . . . . .TELEPHONENO ValGroup:CRM,ConsumerPII Notes: {AR_12$(261,17)} 23 EmailAddress. . . . . . . . . 50 SNN Contact Email Address . . . . .EMAILADDRESS ValGroup:CRM,ConsumerPII Notes: {AR_12$(278,50)} 24 ContactNotes. . . . . . . . . 256 SNN Contact Notes . . . . . . . . . Notes: {AR_12$(328,256)} 25 EBMUserID . . . . . . . . . . 15 SYN eBusiness Manager User ID . . . 26 EncryptedVals . . . . . . . . 768 SNN PII Encrypted Values. . . . . . 27 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 28 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .TIME Read Only:Y 29 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 30 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 31 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .TIME Read Only:Y 32 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL