WorkOrderContractLineItems
Return a list of all Line Items of a specified Work Order Contract in a specified Project.
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| ProjectId | Integer |
Projects.Id | |
| ProjectName | String | ||
| WorkOrderContractId | Integer | ||
| Amount | Double | ||
| Description | String | ||
| CompanyId | Long | ||
| CompanyName | String | ||
| OriginData | String | ||
| OriginId | Integer | ||
| Position | Integer | ||
| Quantity | String | ||
| TaxCodeId | Integer | ||
| TotalAmount | Double | ||
| UnitCost | String | ||
| Uom | String | ||
| UpdatedAt | Datetime | ||
| CostCodeBiller | String | ||
| CostCodeBillerId | Integer | ||
| CostCodeBillerOriginId | String | ||
| CostCodeBillerType | String | ||
| CostCodeBudgeted | Boolean | ||
| CostCodeCode | String | ||
| CostCodeCreatedAt | Datetime | ||
| CostCodeDeletedAt | Datetime | ||
| CostCodeFullCode | Date | ||
| CostCodeId | Integer | ||
| CostCodeLineItemTypes | String | ||
| CostCodeName | String | ||
| CostCodeOriginData | String | ||
| CostCodeOriginId | String | ||
| CostCodeParentId | Integer | ||
| CostCodePosition | Integer | ||
| CostCodeSortableCode | Date | ||
| CostCodeStandardCostCodeId | Integer | ||
| CostCodeUpdatedAt | Datetime | ||
| CreatedAt | Datetime | ||
| ExtendedAmount | Double | ||
| ExtendedType | String | ||
| HolderHolderType | String | ||
| HolderId | Integer | ||
| LineItemTypeBaseType | String | ||
| LineItemTypeCode | String | ||
| LineItemTypeId | Integer | ||
| LineItemTypeName | String | ||
| LineItemTypeOriginData | String | ||
| LineItemTypeOriginId | String | ||
| ChangeEventLineItemCostCodeBiller | String | ||
| ChangeEventLineItemCostCodeBillerId | Integer | ||
| ChangeEventLineItemCostCodeBillerOriginId | String | ||
| ChangeEventLineItemCostCodeBillerType | String | ||
| ChangeEventLineItemCostCodeBudgeted | Boolean | ||
| ChangeEventLineItemCostCodeCode | String | ||
| ChangeEventLineItemCostCodeCreatedAt | Datetime | ||
| ChangeEventLineItemCostCodeDeletedAt | Datetime | ||
| ChangeEventLineItemCostCodeFullCode | Date | ||
| ChangeEventLineItemCostCodeId | Integer | ||
| ChangeEventLineItemCostCodeLineItemTypes | String | ||
| ChangeEventLineItemCostCodeName | String | ||
| ChangeEventLineItemCostCodeOriginData | String | ||
| ChangeEventLineItemCostCodeOriginId | String | ||
| ChangeEventLineItemCostCodeParentId | Integer | ||
| ChangeEventLineItemCostCodePosition | Integer | ||
| ChangeEventLineItemCostCodeSortableCode | Date | ||
| ChangeEventLineItemCostCodeStandardCostCodeId | Integer | ||
| ChangeEventLineItemCostCodeUpdatedAt | Datetime | ||
| ChangeEventLineItemCostRom | String | ||
| ChangeEventLineItemEventId | Integer | ||
| ChangeEventLineItemId | Integer | ||
| ChangeEventLineItemLineItemTypeBaseType | String | ||
| ChangeEventLineItemLineItemTypeCode | String | ||
| ChangeEventLineItemLineItemTypeId | Integer | ||
| ChangeEventLineItemLineItemTypeName | String | ||
| ChangeEventLineItemLineItemTypeOriginData | String | ||
| ChangeEventLineItemLineItemTypeOriginId | String | ||
| ChangeEventLineItemRevenueRom | String |