Search TipsAgreement
|
Field No. |
Field Name |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|---|
|
1 |
Agreement |
Y |
Numeric |
8,0 |
CMP Agreement Number |
|
2 |
Account |
|
Numeric |
8,0 |
CMP Account Number |
|
3 |
Bill Cycle |
|
Numeric |
2,0 |
Bill cycle day |
|
4 |
Bill Frequency |
|
Numeric |
2,0 |
Frequency of billing in months |
|
5 |
Billing Media |
|
Alphanumeric |
6 |
Billing method |
|
6 |
Next Expected Invoice Date |
|
Numeric |
7,0 |
Date of next invoice as held on the Agreement file in CMP. YYYY-MM-DD format. |
|
7 |
First Invoice Date |
|
Numeric |
7,0 |
Date of first invoice. YYYY-MM-DD format. |
|
8 |
Last Invoice Date |
|
Numeric |
7,0 |
Date of last invoice. YYYY-MM-DD format. |
|
9 |
Last Invoice Run Number |
|
Numeric |
8,0 |
Last CMP run number |
|
10 |
Date Created |
|
Numeric |
7,0 |
Date record created in CMP. YYYY-MM-DD format. |
|
11 |
Created By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
12 |
Date Changed |
|
Numeric |
7,0 |
Date record changed in CMP. YYYY-MM-DD format. |
|
13 |
Changed By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
14 |
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP |