Project Financial Analytics - APIs - V1 - Vendor Cost Details
API Name: CoreconAPI_VendorDetails
Note: Job Cost Code, Internal Grouping and Owner Code fields will be blank if multi-projects are selected.
- VendorCompanyName
 
- 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
 
- PO_Approved_Subtotal
 - PO_Approved_Tax
 - PO_Approved_Total
 
- PO_Pending_Subtotal
 - PO_Pending_Tax
 - PO_Pending_Total
 
- Bill_Approved_Subtotal
 - Bill_Approved_Tax
 - Bill_Approved_Total
 
- Bill_Pending_Subtotal
 - Bill_Pending_Tax
 - Bill_Pending_Total
 
- Bill_NoPO_Approved_Subtotal
 - Bill_NoPO_Approved_Tax
 - Bill_NoPO_Approved_Total
 
- Bill_NoPO_Pending_Subtotal
 - Bill_NoPO_Pending_Tax
 - Bill_NoPO_Pending_Total
 
- Subcontract_Approved_Subtotal
 - Subcontract_Approved_Tax
 - Subcontract_Approved_Total
 
- Subcontract_Pending_Subtotal
 - Subcontract_Pending_Tax
 - Subcontract_Pending_Total
 
- SCO_Approved_Subtotal
 - SCO_Approved_Tax
 - SCO_Approved_Total
 
- SCO_Pending_Subtotal
 - SCO_Pending_Tax
 - SCO_Pending_Total
 
- RevisedSubcontract_Approved_Subtotal
 - RevisedSubcontract_Approved_Tax
 - RevisedSubcontract_Approved_Total
 
- SubInvoice_Approved_GrossTotal
 
- SubInvoice_Approved_Retainage
 - SubInvoice_Approved_RetainageBilled
 - SubInvoice_Approved_NetRetainage
 
- SubInvoice_Approved_Subtotal
 - SubInvoice_Approved_Tax
 - SubInvoice_Approved_Total
 
- SubInvoice_Pending_GrossTotal
 
- SubInvoice_Pending_Retainage
 - SubInvoice_Pending_RetainageBilled
 - SubInvoice_Pending_NetRetainage
 
- SubInvoice_Pending_Subtotal
 - SubInvoice_Pending_Tax
 - SubInvoice_Pending_Total
 
- PO_Approved_Open_Subtotal
 - PO_Approved_Open_Total
 
- RevisedSubcontract_Approved_Open_GrossTotal
 - RevisedSubcontract_Approved_Open_Subtotal
 - RevisedSubcontract_Approved_Open_Total
 
- Bill_Approved_TotalPayment
 - SubInvoice_Approved_TotalPayment