API Data Provider - Online Help

PurchaseOrderContracts

Returns a list of all Purchase Order Contracts.

Columns

Name Type References
Id [KEY] Integer
ProjectId Integer

Projects.Id

ProjectName String
Status String

The allowed values are Draft, Processing, Submitted, Partially Received, Received, Approved, Closed.

Title String
AccountingMethod String
ActualCompletionDate Date
ApprovalLetterDate Date
ApprovedChangeOrders String
BillingScheduleOfValuesStatus String
ContractDate Date
ContractEstimatedCompletionDate Date
ContractStartDate Date
CreatedAt Datetime
DeletedAt Datetime
Description String
DraftChangeOrdersAmount Double
Exclusions String
Executed Boolean
ExecutionDate Date
GrandTotal Double
Inclusions String
IssuedOnDate Date
LetterOfIntentDate Date
Number String
OriginCode String
OriginData String
OriginId Integer
PendingChangeOrders String
PendingRevisedContract String
PercentagePaid String
Private Boolean
RemainingBalanceOutstanding Double
RequisitionsAreEnabled Boolean
RetainagePercent String
ReturnedDate Date
RevisedContract String
ShowLineItemsToNonAdmins Boolean
SignedContractReceivedDate Date
TotalDrawRequestsAmount Double
TotalPayments Double
TotalRequisitionsAmount Double
UpdatedAt Datetime
VendorCompany String
VendorId Integer

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