Communication line items
- Last UpdatedAug 02, 2024
- 4 minute read
The following table lists the fields which are available in the CommunicationLineItems data model, which represents line items used in communications.
If using a third-party application such as PowerBI, we recommend you select only the required fields. Many fields in the Analytics data models are duplicated and can be excluded from queries; see Duplicated fields for more information.
Note The base currency of the data is configured when AVEVA Contract Risk Management Analytics is installed.
|
Field name |
Type |
Description |
Values |
Date type and size |
Nullable |
|
LineItemCode |
String |
The code of the line item. |
nvarchar(100) |
No |
|
|
SupplementaryCode |
String |
An additional code which can be used to identify the line item. |
nvarchar(100) |
No |
|
|
LineItemType |
String |
The type of line item. |
|
nvarchar(100) |
No |
|
LineItemTitle |
String |
The name of the line item. |
nvarchar(510) |
No |
|
|
LineItemUnitOfMeasure |
String |
Unit Rate line items only. The unit of measure of the line item - see Units of measure for details of the default values. |
nvarchar(510) |
No |
|
|
QuantityClaimed |
Decimal |
Unit Rate line items only. The quantity of the line item used in this communication. |
decimal |
Yes |
|
|
UnitRateSubtotal |
Decimal |
Unit Rate line items only. The unit price of the line item in the communication currency. |
money(19,4) |
Yes |
|
|
UnitRateSubtotalBase |
Decimal |
Unit Rate line items only. The unit price of the line item in the base currency of the data. |
money(19,4) |
Yes |
|
|
LineItemFinancialImpactBase |
Decimal |
The financial impact of the line item in the base currency of the data. |
money(19,4) |
Yes |
|
|
LineItemFinancialImpact |
Decimal |
The financial impact of the line item in the communication currency. |
money(19,4) |
Yes |
|
|
ContractName |
String |
The name of the contract. |
nvarchar(510) |
No |
|
|
ContractReference |
String |
The unique reference for the contract. |
nvarchar(510) |
No |
|
|
ProjectDepartmentName |
String |
The name of the project/dept in which the contract is located. |
nvarchar(300) |
No |
|
|
BusinessUnitId |
Int32 |
The unique ID of the business unit in which the contract is located. |
Integer |
No |
|
|
CountryName |
String |
The country in which the contract operates. |
nvarchar(510) |
No |
|
|
ContractorReference |
String |
The unique reference for the contractor. |
nvarchar(40) |
No |
|
|
ContractorName |
String |
The name of the contractor. |
nvarchar(1022) |
No |
|
|
CompanyRepresentative |
String |
The name of the company user assigned to the Company Representative contract role. |
nvarchar(302) |
No |
|
|
ContractOwner |
String |
The name of the company user assigned to the Contract Owner contract role. |
nvarchar(302) |
No |
|
|
ContractorRepresentative |
String |
The name of the contractor user assigned to the Contractor Representative contract role. |
nvarchar(302) |
No |
|
|
BreakdownItemName |
String |
The name of the breakdown item that the contract line item is associated with. |
nvarchar(510) |
No |
|
|
BreakdownItemReference |
String |
The reference of the breakdown item that the contract line item is associated with. |
nvarchar(100) |
No |
|
|
ControlAccountCode |
String |
The code for the control account that the contract line item is associated with. |
nvarchar(150) |
No |
|
|
ControlAccountName |
String |
The name of the control account that the contract line item is associated with. |
nvarchar(300) |
No |
|
|
CommunicationId |
Int32 |
The unique ID of the communication. |
Integer |
No |
|
|
CommunicationTitle |
String |
The title (subject) of the communication. |
nvarchar(510) |
No |
|
|
CommunicationReference |
String |
The reference of the communication - unique in the contract. |
nvarchar(120) |
No |
|
|
CommunicationReportingCategory |
String |
The reporting category to which the communication is assigned. |
|
nvarchar(200) |
No |
|
CommunicationState |
String |
The state of the communication. |
|
nvarchar(100) |
No |
|
CommunicationCurrency |
String |
The base currency of the communication. |
nvarchar(510) |
No |
|
|
IsDeleted |
String |
Indicates whether the contract to which the communication belongs is in the Recycle Bin. |
|
nvarchar(100) |
No |
|
CurrentConsumption |
Decimal |
The consumption of the line item in the communication currency at the time that the communication was created. A line item is consumed when it is included in a Company to Contractor expenditure communication which is Approved or Agreed. |
money(19,4) |
Yes |
|
|
CurrentConsumptionBase |
Decimal |
The current consumption of the line item in the base currency of the data at the time that the communication was created. A line item is consumed when it is included in a Company to Contractor expenditure communication which is Approved or Agreed. |
money(19,4) |
Yes |
|
|
ProgressiveLineItemClaims |
Decimal |
Progressive Payment line items only. The percentage of the line item claimed for in this communication. |
decimal |
Yes |
|
|
BusinessUnitName |
String |
The name of the business unit in which the contract is located. |
nvarchar(300) |
No |
|
|
LineItemCurrency |
String |
The currency of the line item. |
nvarchar(510) |
Yes |
|
|
ContractAdministrators |
String |
A list of users assigned to the Contract Administrator contract role. |
nvarchar(8000) |
Yes |
|
|
RateCode |
String |
Reimbursable line items only. The code of the rate associated with the line item. |
nvarchar(150_ |
Yes |
|
|
RateTitle |
String |
Reimbursable line items only. The title of the rate associated with the line item. |
nvarchar(510) |
Yes |
|
|
RateVersionNumber |
Int32 |
The number which identifies the rate version, in date order. The earliest rate version is 1. |
Integer |
Yes |
|
|
ProjectReference |
String |
The unique reference of the project/dept in which the contract is located. |
nvarchar(40) |
No |