Search TipsAccount
|
Field No. |
Field Name |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|---|
|
1 |
Account |
Y |
Numeric |
8,0 |
CMP Account Number |
|
2 |
Company |
|
Alphanumeric |
3 |
CMP Company Number |
|
3 |
Account Type |
|
Alphanumeric |
3 |
3-digit indicator of account type |
|
4 |
Account Type Description |
|
Alphanumeric |
30 |
Text description of account type |
|
5 |
Billing Media |
|
Alphanumeric |
6 |
Paper, Online ,and so on(used for non-subscription invoicing) |
|
6 |
Payment Type |
|
Alphanumeric |
6 |
Payment type associated with the account |
|
7 |
Last Invoice Date |
|
Numeric |
7,0 |
Date last invoice created in CMP. YYYY-MM-DD format (used for non-subscription invoicing) |
|
8 |
Next Expected Invoice Date |
|
Numeric |
7,0 |
The next expected invoice date in CMP. YYYY-MM-DD format (used for non-subscription invoicing) |
|
9 |
Account in Query? |
|
Alphanumeric |
1 |
Either 1=Yes or 0=No |
|
10 |
Account Balance |
|
Numeric |
11,2 |
Amount in pounds and pence, to 2 decimal places, positive or negative |
|
11 |
Amount Overdue |
|
Numeric |
11,2 |
Amount in pounds and pence, to 2 decimal places if populated, positive or negative |
|
12 |
Amount in Query |
|
Numeric |
11.2 |
Amount in query, positive or negative |
|
13 |
Ignore CC Procedures? |
|
Alphanumeric |
1 |
Either 1=Yes or 0=No |
|
14 |
Account Name |
|
Alphanumeric |
60 |
Delivery Address Name |
|
15 |
Address Line 1 |
|
Alphanumeric |
40 |
Address bill is sent to |
|
16 |
Address Line 2 |
|
Alphanumeric |
40 |
Address bill is sent to |
|
17 |
Address Line 3 |
|
Alphanumeric |
40 |
Address bill is sent to |
|
18 |
Address Line 4 |
|
Alphanumeric |
40 |
Address bill is sent to |
|
19 |
Address Line 5 |
|
Alphanumeric |
40 |
Address bill is sent to |
|
20 |
Address Post Code |
|
Alphanumeric |
10 |
Address bill is sent to |
|
21 |
Title |
|
Alphanumeric |
10 |
Title from CMP (for example, Ms, Mr, Mrs) |
|
22 |
Forename |
|
Alphanumeric |
15 |
First name from CMP |
|
23 |
Middle Name |
|
Alphanumeric |
10 |
Middle name from CMP |
|
24 |
Surname |
|
Alphanumeric |
25 |
Last name from CMP |
|
25 |
Gender |
|
Alphanumeric |
1 |
Gender from CMP - '0' = Male - '1' = Female - '2' = Unknown For Personal Address records where the Gender status is returned as ‘Unknown’, the Title field is used to further determine the Gender. Thus if the Title = ‘Mr’ the Gender is set to ‘Male’, and if the Title is one of ‘Mrs’ , ‘Miss’, or ‘Ms’, it is set to ‘Female’. Note: For Business Address records the Gender Status is set to ‘Unknown’. |
|
26 |
Date of Birth |
|
Numeric |
7,0 |
YYYY-MM-DD format. |
|
27 |
Date Created |
|
Numeric |
7,0 |
Date record created in CMP. YYYY-MM-DD format. |
|
28 |
Created By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
29 |
Date Changed |
|
Numeric |
7,0 |
Date record changed in CMP. YYYY-MM-DD format. |
|
30 |
Changed By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
31 |
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format. |