Search TipsInvoice Detail
|
Field No. |
Field Name |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|---|
|
1 |
Invoice |
Y |
Numeric |
8,0 |
CMP Invoice Number |
|
2 |
Invoice Line |
Y |
Numeric |
5,0 |
Invoice Line Number |
|
3 |
Account |
|
Numeric |
8,0 |
CMP Account Number |
|
4 |
Tariff |
|
Alphanumeric |
6 |
Tariff for Subscription |
|
5 |
Service |
|
Alphanumeric |
6 |
Service Code |
| 6 |
Service Description |
|
Alphanumeric |
30 |
CMP Service Description |
|
7 |
Subscription |
|
Numeric |
8,0 |
Subscription Number |
|
8 |
Workflow Event |
|
Numeric |
9,0 |
Workflow Event Number |
|
9 |
Network |
|
Alphanumeric |
6 |
Network relating to Service Code |
|
10 |
Network Serial Number |
|
Alphanumeric |
25 |
Telephone Number |
|
11 |
Total Number of Calls |
|
Numeric |
5,0 |
Number of Calls Invoiced |
|
12 |
Total Duration |
|
Numeric |
9,0 |
Duration of Calls Invoiced |
|
13 |
Total Service Units |
|
Numeric |
11,0 |
Number of units Invoiced |
|
14 |
SOP Order Number |
|
Alphanumeric |
15,0 |
CMP Order Number |
|
15 |
SOP Order Line |
|
Numeric |
6,0 |
CMP Order Line Number |
|
16 |
Charge Start Date |
|
Numeric |
7,0 |
Service Charge Start Date YYYY-MM-DD format. |
|
17 |
Charge End Date |
|
Numeric |
7,0 |
Service Charge End Date YYYY-MM-DD format. |
|
18 |
Net Amount |
|
Numeric |
11,2 |
Net Amount of Invoice Line, positive or negative |
|
19 |
Tax Amount |
|
Numeric |
13,4 |
VAT Amount of Invoice Line, positive or negative |
|
20 |
Charge Tax Code |
|
Alphanumeric |
10 |
Charged Tax Code |
|
21 |
Tax Rate |
|
Numeric |
5,2 |
Charged Tax Rate |
|
22 |
Charge to Nominal Code |
|
Alphanumeric |
29 |
Nominal Code |
|
23 |
Service Description |
|
Alphanumeric |
30 |
Description of Service Invoiced |
|
24 |
Comment 1 |
|
Alphanumeric |
78 |
Free text field 1 |
|
25 |
Comment 2 |
|
Alphanumeric |
78 |
Free text field 2 |
|
26 |
Comment 3 |
|
Alphanumeric |
78 |
Free text field 3 |
|
27 |
Invoice Tax Date |
|
Numeric |
7 |
Invoice date for the invoice the invoice detail line is associated with |
|
28 |
Payment Type |
|
Alphanumeric |
6 |
Code identifying the payment type the customer was on at the time of the invoice |
|
29 |
Charge to Nominal Desc |
|
Alphanumeric |
30 |
Description associated with the Charge to Nominal Code |
|
30 |
Package Code |
|
Alphanumeric |
6 |
CMP Package Code. |
|
31 |
Date Created |
|
Numeric |
7,0 |
Date Invoice Created in CMP YYYY-MM-DD format. |
|
32 |
Time Created |
|
Numeric |
6,0 |
Time Invoice Created in CMP YYYY-MM-DD format. |
|
33 |
Created By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
34 |
Date Changed |
|
Numeric |
7,0 |
Date record changed in CMP. YYYY-MM-DD format. |
|
35 |
Changed By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
36 |
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format. |