PurchaseOrderContractLineItems
Return a list of all Purchase Order Contract Line Items.
Columns
Name | Type | References | |
Id [KEY] | Integer | ||
ProjectId | Integer |
Projects.Id | |
ProjectName | String | ||
PurchaseOrderContractId | Integer | ||
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 |