AR_CustomerContact AR Customer Contact Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_CustomerContact_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerContact.M4T"
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 . . . . . . . . . 30 SNN Contact Name. . . . . . . . . .NAME
ValGroup:CRM Notes:
{AR_12$(20,30)}
5 AddressLine1. . . . . . . . . 30 SNN Contact Address Line 1. . . . .ADDRESSLINE
ValGroup:CRM Notes:
{AR_12$(50,30)}
6 AddressLine2. . . . . . . . . 30 SNN Contact Address Line 2. . . . .ADDRESSLINE
ValGroup:CRM Notes:
{AR_12$(80,30)}
7 AddressLine3. . . . . . . . . 30 SNN Contact Address Line 3. . . . .ADDRESSLINE
ValGroup:CRM Notes:
{AR_12$(110,30)}
8 City. . . . . . . . . . . . . 20 SNN Contact City. . . . . . . . . .CITY
ValGroup:CRM Notes:
{AR_12$(140,20)}
9 State . . . . . . . . . . . . 2 SYN Contact State . . . . . . . . .STATE
ValGroup:CRM Notes:
{AR_12$(160,2)}
10 ZipCode . . . . . . . . . . . 10 SYN Contact Zip Code. . . . . . . .ZIPCODE
ValGroup:CRM Notes:
{AR_12$(162,10)}
11 CountryCode . . . . . . . . . 3 SYN Contact Country Code. . . . . .COUNTRY
ValGroup:CRM Notes:
{AR_12$(172,3)}
12 Salutation. . . . . . . . . . 10 SNN Contact Salutation. . . . . . .
ValGroup:CRM Notes:
{AR_12$(192,10)}
13 ContactTitle. . . . . . . . . 15 SNN Contact Title . . . . . . . . .
ValGroup:CRM Notes:
{AR_12$(202,15)}
14 TelephoneNo1. . . . . . . . . 17 SNN Contact Telephone Number 1. . .TELEPHONENO
ValGroup:CRM Notes:
{AR_12$(217,17)}
15 TelephoneExt1 . . . . . . . . 5 SNN Contact Telephone Extension 1 .TELEPHONEEXT
ValGroup:CRM Notes:
{AR_12$(234,5)}
16 TelephoneNo2. . . . . . . . . 17 SNN Contact Telephone Number 2. . .TELEPHONENO
ValGroup:CRM Notes:
{AR_12$(239,17)}
17 TelephoneExt2 . . . . . . . . 5 SNN Contact Telephone Extension 2 .TELEPHONEEXT
ValGroup:CRM Notes:
{AR_12$(256,5)}
18 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO
ValGroup:CRM Notes:
{AR_12$(261,17)}
19 EmailAddress. . . . . . . . . 50 SNN Contact Email Address . . . . .EMAILADDRESS
ValGroup:CRM Notes:
{AR_12$(278,50)}
20 ContactNotes. . . . . . . . . 256 SNN Contact Notes . . . . . . . . .
Notes: {AR_12$(328,256)}
21 EBMUserID . . . . . . . . . . 15 SYN e Business Manager User ID. . .
22 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
23 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
24 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
25 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
26 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
27 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL