Search TipsAccount Analytics
Data is only considered up to midnight of the previous day. This is to ensure a common cut-off date across all Data Warehouse output.
|
Column Heading |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|
|
Account Number |
Y |
Numeric |
8,0 |
CMP Account Number |
|
Company Number |
|
Alphanumeric |
3 |
CMP Company Number |
|
Account Type Code |
|
Alphanumeric |
3 |
3-digit indicator of account type |
|
Account Type Description |
|
Alphanumeric |
30 |
Text description of account type |
|
Billing Media Code |
|
Alphanumeric |
6 |
The CMP code that indicates the type of billing media, for example, ONLINE (used for non-subscription invoicing) |
| Billing Media Code Description | Alphanumeric | 30 | Text description of the billing media, for example online billing, paper | |
|
Payment Type Code |
|
Alphanumeric |
6 |
CMP code that indicates the payment type associated with the account, for example, MANUAL |
| Payment Type Code Description | Alphanumeric | 30 | Text description of the payment type code, for example Manual Payment | |
|
Last Invoice Date |
|
Numeric |
25,0 |
Date last invoice created in CMP. YYYY-MM-DD HH:MM:SS format (used for non-subscription invoicing) |
|
Next Expected Invoice Date |
|
Numeric |
25,0 |
The next expected invoice date in CMP. YYYY-MM-DD HH:MM:SS format (used for non-subscription invoicing) |
|
Account in Query |
|
Alphanumeric |
1 |
Either 1=Yes or 0=No |
|
Account Balance |
|
Numeric |
11,2 |
Amount to 2 decimal places, positive or negative |
|
Amount Overdue |
|
Numeric |
11,2 |
Amount to 2 decimal places if populated, positive or negative |
|
Amount Query |
|
Numeric |
11,2 |
Amount in query, positive or negative |
|
Is Ignore CC Procedure |
|
Alphanumeric |
1 |
Either 1=Yes or 0=No |
|
Account Name |
|
Alphanumeric |
60 |
Delivery Address Name |
|
Address Line 1 |
|
Alphanumeric |
40 |
First line of the address to which the bill is sent |
|
Address Line 2 |
|
Alphanumeric |
40 |
Second line of the address to which the bill is sent |
|
Address Line 3 |
|
Alphanumeric |
40 |
Third line of the address to which the bill is sent |
|
Address Line 4 |
|
Alphanumeric |
40 |
Fourth line of the address to which the bill is sent |
|
Address Line 5 |
|
Alphanumeric |
40 |
Fifth line of the address to which the bill is sent |
|
Post Code |
|
Alphanumeric |
10 |
Post code of the address to which the bill is sent |
|
Date Time Created |
|
Numeric |
25,0 |
Date record created in CMP. YYYY-MM-DD HH:MM:SS format |
|
Created By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
Date Time Changed |
|
Numeric |
25,0 |
Date record changed in CMP. YYYY-MM-DD HH:MM:SS format |
|
Changed By |
|
Alphanumeric |
10 |
User ID of user who changed the record |
|
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format |