AR_CustomerContactListingWrk AR Customer Contact Listing WorkRel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_CustomerContactListing_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerContactListingWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . .
2 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .
3 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .
4 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .
5 PrimaryContact. . . . . . . . 1 SNN PrimaryContact. . . . . . . . .
6 ContactCode . . . . . . . . . 10 SNN Contact Code. . . . . . . . . .
7 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . .
8 AddressLine1. . . . . . . . . 30 SNN Contact Address Line 1. . . . .
9 AddressLine2. . . . . . . . . 30 SNN Contact Address Line 2. . . . .
10 AddressLine3. . . . . . . . . 30 SNN Contact Address Line 3. . . . .
11 City. . . . . . . . . . . . . 30 SNN Contact City. . . . . . . . . .
12 State . . . . . . . . . . . . 2 SNN Contact State . . . . . . . . .
13 ZipCode . . . . . . . . . . . 10 SNN Contact Zip Code. . . . . . . .
14 CountryCode . . . . . . . . . 3 SNN Contact Country Code. . . . . .
15 CountryName . . . . . . . . . 30 SNN Contact Country Name. . . . . .
16 Salutation. . . . . . . . . . 10 SNN Contact Salutation. . . . . . .
17 ContactTitle. . . . . . . . . 15 SNN Contact Title . . . . . . . . .
18 TelephoneNo1. . . . . . . . . 17 SNN Contact Telephone Number 1. . .
19 TelephoneExt1 . . . . . . . . 5 SNN Contact Telephone Extension . .
20 TelephoneNo2. . . . . . . . . 17 SNN Contact Telephone Number 2. . .
21 TelephoneExt2 . . . . . . . . 17 SNN Contact Telephone Extension . .
22 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .
23 EmailAddress. . . . . . . . . 50 SNN Contact E-mail Address. . . . .
24 ContactNotes. . . . . . . . . 256 SNN Contact Notes . . . . . . . . .
25 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . .
26 CRMFirstName. . . . . . . . . 60 SNN CRM First Name. . . . . . . . .
27 CRMLastName . . . . . . . . . 80 SNN CRM Last Name . . . . . . . . .
28 EBMUserID . . . . . . . . . . 15 SNN Business Manager User ID. . . .
29 Password. . . . . . . . . . . 25 SNN Password. . . . . . . . . . . .
30 SupervisorRights. . . . . . . 1 SNN Supervisor Rights . . . . . . .
31 AllowSubmissionOfShoppingCart 1 SYN Allow Submission Of Shopping CaYESNO
DfltVal:N Valid:Y,N
32 SuspendAccess . . . . . . . . 1 SYN Suspend Access. . . . . . . . .
DfltVal:N Valid:Y,N