API Data Provider - Online Help

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

WorkOrderContracts.Id

Amount Double
Description String
CompanyId Integer
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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060.0