Contract line items
- Last UpdatedAug 02, 2024
- 5 minute read
The following table lists the fields which are available in the LineItems data model, which represents the line items configured for contracts:
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.
Note For DateTime fields, only the date is stored. The time portion of the value of DateTime fields is therefore always 00:00.
|
Field name |
Type |
Description |
Values |
Date type and size |
Nullable |
|
LineItemCode |
String |
The code of the line item. |
nvarchar(100) |
No |
|
|
LineItemTitle |
String |
The name of the line item. |
nvarchar(510) |
No |
|
|
LineItemCurrency |
String |
The base currency of the line item. |
nvarchar(510) |
No |
|
|
LineItemType |
String |
The type of line item. |
|
nvarchar(100) |
No |
|
SupplementaryCode |
String |
An additional code which can be used to identify the line item. |
nvarchar(100) |
Yes |
|
|
ContractId |
Int32 |
The unique identifier of the contract. |
Integer |
No |
|
|
ContractName |
String |
The name of the contract. |
nvarchar(510) |
No |
|
|
ContractReference |
String |
The unique reference for the contract. |
nvarchar(510) |
No |
|
|
BusinessUnitId |
Int32 |
The unique identifier of the business unit in which the contract is located. |
Integer |
No |
|
|
BusinessUnitName |
String |
The name of the business unit in which the contract is located. |
nvarchar(300) |
No |
|
|
ContractorReference |
String |
The unique reference for the contractor. |
nvarchar(40) |
No |
|
|
ContractorName |
String |
The name of the contractor. |
nvarchar(1022) |
No |
|
|
ContractAdministrators |
String |
A list of users assigned to the Contract Administrator contract role. |
nvarchar(8000) |
Yes |
|
|
BreakdownItemName |
String |
The name of the breakdown item that the contract line item is associated with. |
nvarchar(510) |
Yes |
|
|
BreakdownItemCode |
String |
The code of the breakdown item that the contract line item is associated with. |
nvarchar(100) |
Yes |
|
|
ControlAccountCode |
String |
The code for the control account that the contract line item is associated with. |
nvarchar(150) |
Yes |
|
|
ControlAccountName |
String |
The name of the control account that the contract line item is associated with. |
nvarchar(300) |
Yes |
|
|
InitialCommitmentValue |
Decimal |
The total price as agreed in the contract set for the line item when it was created, in the line item currency. For Unit Rate line items, this is calculated as Unit Rate x Committed Quantity. |
decimal |
No |
|
|
InitialCommitmentValueBase |
Decimal |
The total price as agreed in the contract set for the line item when it was created, in the base currency of the data. For Unit Rate line items, this is calculated as Unit Rate x Committed Quantity. |
decimal |
No |
|
|
InitialQuantity |
Decimal |
Unit Rate line items only. The initial maximum quantity of the line item that should be used. This has been negotiated between the company and contractor, and committed to in the contract. |
decimal |
Yes |
|
|
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) |
Yes |
|
|
LineItemUnitRate |
Decimal |
Unit Rate line items only. The unit price of the line item in the line item currency. |
money(19,4) |
Yes |
|
|
LineItemUnitRateBase |
Decimal |
Unit Rate line items only. The unit price of the line item in the base currency of the data. |
money(19,4) |
Yes |
|
|
ApprovedCommitmentValue |
Decimal |
The value of the Approved commitment recorded for the line item, in the line item currency. This is determined by the reporting categories of any communications the line item is used in. |
money(19,4) |
No |
|
|
ApprovedCommitmentValueBase |
Decimal |
The value of the Approved commitment recorded for the line item, in the base currency of the data. This is determined by the reporting categories of any communications the line item is used in. |
money(19,4) |
No |
|
|
ApprovedQuantity |
Decimal |
Unit Rate line items only. The maximum quantity of the line item that should be used, based on communications in the Approved Commitment reporting category which include changes to the line item. |
decimal |
Yes |
|
|
PendingCommitmentValue |
Decimal |
The value of the Pending commitment recorded for the line item, in the line item currency. This is determined by the reporting categories of any communications the line item is used in. |
money(19,4) |
Yes |
|
|
PendingCommitmentValueBase |
Decimal |
The value of the Pending commitment recorded for the line item, in the base currency of the data. This is determined by the reporting categories of any communications the line item is used in. |
money(19,4) |
Yes |
|
|
PotentialCommitmentValue |
Decimal |
The value of the Potential commitment recorded for the line item, in the line item currency. This is determined by the reporting categories of any communications the line item is used in. |
money(19,4) |
Yes |
|
|
PotentialCommitmentValueBase |
Decimal |
The value of the Potential commitment recorded for the line item, in the base currency of the data. This is determined by the reporting categories of any communications the line item is used in. |
money(19,4) |
Yes |
|
|
ApprovedExpenditureValue |
Decimal |
The value of the Approved expenditure recorded for the line item, in the line item currency. This is determined by the reporting categories of any communications the line item is used in. |
money(19,4) |
Yes |
|
|
ApprovedExpenditureValueBase |
Decimal |
The value of the Approved expenditure commitment recorded for the line item, in the base currency of the data. This is determined by the reporting categories of any communications the line item is used in. |
money(19,4) |
Yes |
|
|
PendingExpenditureValue |
Decimal |
The value of the Pending expenditure recorded for the line item, in the line item currency. This is determined by the reporting categories of any communications the line item is used in. |
money(19,4) |
Yes |
|
|
PendingExpenditureValueBase |
Decimal |
The value of the Pending expenditure recorded for the line item, in the base currency of the data. This is determined by the reporting categories of any communications the line item is used in. |
money(19,4) |
Yes |
|
|
PotentialExpenditureValue |
Decimal |
The value of the Potential expenditure recorded for the line item, in the line item currency. This is determined by the reporting categories of any communications the line item is used in. |
money(19,4) |
Yes |
|
|
PotentialExpenditureValueBase |
Decimal |
The value of the Potential expenditure recorded for the line item, in the base currency of the data. This is determined by the reporting categories of any communications the line item is used in. |
money(19,4) |
Yes |
|
|
CreationDate |
DateTime |
The date and time that the line item was created. |
datetime |
No |
|
|
ConsumedExpenditurePercentage |
Decimal |
Progressive Payment line items only. The percentage of the line item claimed in the contract (i.e. in a Company to Contractor expenditure communication which has been Agreed/Approved). |
decimal |
Yes |
|
|
LineItemChangePercentage |
Decimal |
Progressive Payment line items only. The percentage of the line item included in commitment change communications which have been Agreed/Approved. |
decimal |
Yes |
|
|
ConsumedCommitment |
Decimal |
Lump Sum, Milestone Payment and Reimbursable line items only. The amount of the line item claimed in the contract (i.e. in a Company to Contractor expenditure communication which has been Agreed/Approved), in the line item currency. |
money(19,4) |
Yes |
|
|
ConsumedCommitmentBase |
Decimal |
Lump Sum, Milestone Payment and Reimbursable line items only. The amount of the line item claimed in the contract (i.e. in a Company to Contractor expenditure communication which has been Agreed/Approved), in the base currency of the data. |
money(19,4) |
Yes |
|
|
ConsumedQuantity |
Decimal |
Unit Rate line items only. The quantity of the line item claimed in the contract (i.e. in a Company to Contractor expenditure communication which has been Agreed/Approved). |
decimal |
Yes |
|
|
TotalNumberOfRates |
Int32 |
Reimbursable line items only. The number of rates associated with the line item. |
Integer |
Yes |
|
|
ProjectReference |
String |
The unique reference of the project/dept in which the contract is located. |
nvarchar(40) |
No |