Search TipsAgreement 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 |
|---|---|---|---|---|
|
Agreement Number |
Y |
Numeric |
8,0 |
CMP Agreement Number |
|
Account Number |
|
Numeric |
8,0 |
CMP Account Number |
|
Bill Cycle |
|
Numeric |
2,0 |
Bill cycle day of the month |
|
Billing Media |
|
Alphanumeric |
6 |
CMP code for the Billing media, for example, ONLINE, PAPER |
| Billing Media Description | Alphanumeric | 30 | Text description of the Billing media, for example, Online Billing | |
| Billing Frequency | Numeric | 2,0 | The frequency of the billing, in months | |
|
Next Expected Invoice Date |
|
Numeric |
25,0 |
Date of next invoice as held on the Agreement file in CMP. YYYY-MM-DD HH:MM:SS format |
|
First Invoice Date |
|
Numeric |
25,0 |
Date of first invoice. YYYY-MM-DD HH:MM:SS format |
|
Last Invoice Date |
|
Numeric |
25,0 |
Date of last invoice. YYYY-MM-DD HH:MM:SS format |
|
Last Invoice Run Number |
|
Numeric |
8,0 |
Last CMP run number |
|
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 created the record |
|
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format |