Revenue API V1
API Name: CoreconAPI_Revenue
The job cost code, internal grouping, and owner code fields will be blank when multiple projects are selected.
- ProjectId
- ProjectNumber
- ProjectTitle
- ProjectBidContactName
- ProjectSalesContactName
- ProjectPMContactName
- ProjectEstStartDateUtc
- ProjectEstStartDateOrgLocal
- ProjectEstFinishDateUtc
- ProjectEstFinishDateOrgLocal
- PrimeContractId
- PrimeContractNumber
- PrimeContractSubject
- PrimeContractIssueDateUtc
- PrimeContractIssueDateOrgLocal
- PrimeContractStatus
- PrimeContractApprovalDateUtc
- PrimeContractApprovalDateOrgLocal
- PrimeContractBillingType
- PrimeContractBillingTypeValue
- OwnerCompanyName
- OwnerContactName
- ContractorCompanyName
- ContractorContactName
- PrimeContractEstStartDateUtc
- PrimeContractEstFinishDateUtc
- PrimeContractEstStartDateOrgLocal
- PrimeContractEstFinishDateOrgLocal
- JobCostCodeId
- JobCostCodeOrderNumber
- JobCostCode
- JobCostCodeDescription
- JobCostCodeQuantity
- JobCostCodeUnit
- JobCostCodeInternalDivision
- JobCostCodeInternalDivisionDesc
- JobCostCodeInternalMajor
- JobCostCodeInternalMajorDesc
- JobCostCodeInternalMinor
- JobCostCodeInternalMinorDesc
- JobCostCodeInternalSubMinor
- JobCostCodeInternalSubMinorDesc
- OwnerCostCode
- OwnerCostCodeDescription
- RevenueBudget_Prime_Subtotal
- RevenueBudget_Prime_Tax
- RevenueBudget_Prime_Total
- RevenueBudget_ApprovedCOs_Subtotal
- RevenueBudget_ApprovedCOs_Tax
- RevenueBudget_ApprovedCOs_Total
- RevenueBudget_PendingCOs_Subtotal
- RevenueBudget_PendingCOs_Tax
- RevenueBudget_PendingCOs_Total
- RevenueBudget_Revised_Subtotal
- RevenueBudget_Revised_Tax
- RevenueBudget_Revised_Total
- RevenueBudget_ApprovedCPRs_Subtotal
- RevenueBudget_ApprovedCPRs_Tax
- RevenueBudget_ApprovedCPRs_Total
- RevenueBudget_PendingCPRs_Subtotal
- RevenueBudget_PendingCPRs_Tax
- RevenueBudget_PendingCPRs_Total
- PrimeInvoice_Approved_GrossTotal_NoCORef
- PrimeInvoice_Approved_GrossTotal_WithCORef
- PrimeInvoice_Approved_GrossTotal
- PrimeInvoice_Approved_Retainage
- PrimeInvoice_Approved_RetainageBilled
- PrimeInvoice_Approved_NetRetainage
- PrimeInvoice_Approved_Subtotal
- PrimeInvoice_Approved_Tax
- PrimeInvoice_Approved_Total
- PrimeInvoice_Pending_GrossTotal_NoCORef
- PrimeInvoice_Pending_GrossTotal_WithCORef
- PrimeInvoice_Pending_GrossTotal
- PrimeInvoice_Pending_Retainage
- PrimeInvoice_Pending_RetainageBilled
- PrimeInvoice_Pending_NetRetainage
- PrimeInvoice_Pending_Subtotal
- PrimeInvoice_Pending_Tax
- PrimeInvoice_Pending_Total
- RevenueBudgetPrimeInvoiceVariance_Approved_Gross
Is equal to the revised revenue budget subtotal (RevenueBudget_Revised_Subtotal) minus the approved prime invoice gross total (PrimeInvoice_Approved_GrossTotal).
- RevenueBudgetPrimeInvoiceVariance_Approved_Total
Is equal to the revised revenue budget total (RevenueBudget_Revised_Total) minus the approved prime invoice total (PrimeInvoice_Approved_Total).
- Percent_Invoiced_Gross
Is equal to the approved prime invoice gross total (PrimeInvoice_Approved_GrossTotal) divided by the revised revenue budget subtotal (RevenueBudget_Revised_Subtotal), multiplied by 100.
- Percent_Invoiced_Subtotal
Is equal to the approved prime invoice subtotal (PrimeInvoice_Approved_Subtotal) divided by the revised revenue budget subtotal (RevenueBudget_Revised_Subtotal), multiplied by 100.
- EstimatedFieldPercentComplete