Search TipsSubscription Service
|
Field No. |
Field Name |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|---|
|
1 |
Subscription |
Y |
Numeric |
8,0 |
CMP Subscription Number |
|
2 |
Company |
Y |
Alphanumeric |
3 |
CMP Company Number |
|
3 |
Service |
Y |
Alphanumeric |
6 |
CMP Service Code |
|
4 |
SS Effective Date |
Y |
Numeric |
7,0 |
Service Effective Date. YYYY-MM-DD format. |
|
5 |
Service Description |
|
Alphanumeric |
30 |
Text Description |
|
6 |
Package |
|
Alphanumeric |
6 |
Package Code |
|
7 |
Recurring Charge? |
|
Alphanumeric |
1 |
Either 1=Yes or 0=No |
|
8 |
Price Number of Months |
|
Numeric |
3,0 |
How many months the service charge covers |
|
9 |
Price Number of Days |
|
Numeric |
3,0 |
How many days the service charge covers |
|
10 |
SS Price Expiry Date |
|
Numeric |
7,0 |
Service Expiry Date, if populated. YYYY-MM-DD format. |
|
11 |
Service Price |
|
Numeric |
11,2 |
Price in pounds and pence, to 2 decimal places, positive or negative |
|
12 |
Invoiced Up-to Date |
|
Numeric |
7,0 |
Date the service is invoiced up to. YYYY-MM-DD format. |
|
13 |
Invoice this Service? |
|
Alphanumeric |
1 |
Either 1=Yes or 0=No |
|
14 |
Billing Offset |
|
Numeric |
2,0 |
1 = Monthly , 3 = Quarterly, 12 =Yearly etc. |
|
15 |
Date Created |
|
Numeric |
7,0 |
Date record created in CMP. YYYY-MM-DD format. |
|
16 |
Created By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
17 |
Date Changed |
|
Numeric |
7,0 |
Date record changed in CMP. YYYY-MM-DD format. |
|
18 |
Changed By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
19 |
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format. |