Project Management: Job Cash Flow

Find descriptions of each of the fields in the Job Cash Flow data source organized by category.

Calendar Date

Year

Calendar year starting with January 1st and ending on December 31st. This may be different from the company's Fiscal Calendar. Note that this value is based on the actual date of each record.

Month

Includes all dates from the start of the month through the end of the month. Note that this value is based on the actual date of each record.

Week

This is the week number using a 12 month calendar year. Note that this value is based on the actual date of each record.

Customer

Customer Code

This code represents a specific customer.

  • Vista table.field: ARCM.Customer
  • Spectrum table.field: CR_CUSTOMER_MASTER_MC.Customer_Code
Contract Type

For Spectrum, the contract type is used to group projects by function, or by any other desired classification. For Vista, the contract's Default Bill Type.

  • Vista table.field: JCCM.DefaultBillType
  • Spectrum table.field: JC_JOB_MASTER_MC.Company_Code
Customer Type

For Spectrum only. The customer type is used to group customer by function, or by any other desired classification.

  • Spectrum table.field: CR_CUSTOMER_MASTER_MC.Type

Department

Department

This field is used to group jobs together.

  • Vista table.field: JCDM.Department
  • Spectrum table.field: JC_JOB_MASTER_MC.Division

Job

Company Code

This represents the specific company.

  • Vista table.field: JCJM.JCCo
  • Spectrum table.field: JC_JOB_MASTER_MC.Company_Code
Cost Center

For Spectrum only. This represents the cost center, profit center or some other way to group the organization.

  • Spectrum table.field: JC.PHASE_MASTER_MC.Cost_Center if it exists, otherwise JC_JOB_MASTER_MC.Cost_Center
Cost Groups

For Spectrum only. This represents the cost centers, profit centers or some other way to group the organization.

  • Spectrum table.field: EM_COST_GROUP_LIST_MC.Cost_Group
Job Code

This code is used to identify the job.

  • Vista table.field: JCJM.Job
  • Spectrum table.field: JC_JOB_MASTER_MC.Job_Code

Job Status

Job Status

The status of the job that includes Active, Inactive, and Complete.

  • Vista table.field: JCJM.Status
  • Spectrum table.field: JC_JOB_MASTER_MC.Status

Master Job

Master Job

For Spectrum only. The master job serves as the primary setup, and be for reporting purposes to include all sub-job activity as if performed in a single large job, It may also control how T+M billings of the sub-jobs work.

  • Spectrum table.field: JC_JOB_MASTER_MC.Master_Job

Measures

Cost

The total actual cost for the project.

  • Vista table.field: bJCCD.ActualCost
  • Spectrum table.field: JC_TRANSACTION_HISTORY_MC.Tran_Amount
Cost to Date

This is the job-to-date actual cost amount for the project.

Customer Billed

This is the current month's billing, before backing off the current month's retention. For Spectrum, this does not include sales tax or VAT. For Vista, tax depends on contract settings.

  • Spectrum table.field: CR_INVOICE_HEADER_MC.Invoice_Extension (If Credit Memo, multiply by -1)
  • Vista table.field: bJCID.BilledAmount
Customer Billed to Date
This is the job-to-date billing.
Customer Invoiced

This is the current month's invoices. It includes sales tax and VAT. This amount is calculated as follows:

Customer Billed + Customer Taxes

Customer Invoiced to Date

This is the job-to-date sum of invoices. It includes sales tax and VAT.

Customer Paid

This includes all monies paid against Invoiced, including taxes, plus any Discounts Taken.

  • Spectrum table.field: CR_PAY_ADJUST_HISTORY_MC.Payment_Amount + CR_PAY_ADJUST_HISTORY_MC.Discount_Amount + CR_OPEN_ITEM_MC.Invoice_Balance * -1
  • Vista table.field: When bARTH.Source = 'AR Receipt' THEN bARTH.CreditAmt ELSE bARTH.Paid
Customer Paid to Date

This includes all job-to-date monies paid against Invoiced to Date plus any discounts taken.

Customer Retention Due

This is the current month's retention minus retention paid.

  • Spectrum table.field: CR_PAY_ADJUST_HISTORY_MC.Retention_Amount + CR_PAY_ADJUST_HISTORY_MC.Retention_Discount
  • Vista table.field: bJCID.CurrentRetainage
Customer Retention Due to Date

This is the job-to-date retention minus retention paid.

Customer Taxes

This is the current month’s sales tax + VAT.

  • Spectrum table.field: CR_INVOICE_HEADER_MC.Sales_Tax_Amount
  • Vista table.field: ARTL.TaxAmount
Customer Taxes to Date

This is the job-to-date sales tax + VAT.

Customer Total Balance Due

This is what is owed to you on the job including Retention. It is calculated as Invoiced To Date – Paid To Date.

Customer Total Current Due

This is what is owed to you without Retention. It is calculated as (Invoiced To Date - Retention Due To Date - Paid To Date)

Vendor Billed

This is the current period's billing, before backing off the current period's retention amounts. It does not include sales/use tax or VAT. This amount is calculated as follows:

Vendor Invoiced - Vendor Taxes

Vendor Billed to Date

This is the job-to-date billed, before backing off retention amounts. It does not include sales/use tax or VAT amounts.

Vendor Invoiced

This is the current month's sum of invoices for the job. It is calculated as Billed + Taxes. It does not include use tax.

  • Vista table.field: bAPTH.InvTotal
  • Spectrum table.field: VN_GL_DISTRIBUTION_HEADER_MC.Invoice_Amount
Vendor Invoiced to Date

This is the job-to-date sum of invoices. It is calculated as Billed To Date + Taxes To Date. It does not include use tax.

Vendor Paid

This includes all monies paid against invoiced plus any discounts taken. It includes any retention paid.

  • Vista table.field: bAPTD.Amount (Status 3)
  • Spectrum table.field: VN_PAYMENT_HISTORY_MC.Payment_Amount + VN_PAYMENT_HISTORY_MC.Discount_Taken
Vendor Paid to Date

This includes all job-to-date monies paid against Invoiced To Date plus any Discounts Taken. It includes any Retention Paid To Date.

Vendor Retention

This is the sum of the retention for the vendor invoices.

  • Vista table.field: APTL.Retainage
  • Spectrum table.field:

    VN_GL_DISTRIBUTION_HEADER_MC.Retention_Amount + VN_GL_DISTRIBUTION_HEADER_MC.Retention_VAT_Amt

Vendor Retention Paid

This includes all monies paid for retention.

  • Vista table.field: SUM (bAPTD.Amount WHERE bAPTD.PayType = 9 AND bAPTD.Status = 3)
  • Spectrum table.field:

    case when VN_PAYMENT_HISTORY_MC.Retention_Paid <> 0 then VN_PAYMENT_HISTORY_MC.Retention_Paid + VN_PAYMENT_HISTORY_MC.Discount_Taken else 0 end

Vendor Retention Paid to Date

This includes all to date monies paid for retention.

Vendor Retention to Date

This is the job-to-date sum of retention for the vendor invoices.

Vendor Taxes

This is the current month’s sales tax + VAT.

  • Vista table.field: bAPTL.TaxAmount
  • Spectrum table.field:

    case when VN_PAYMENT_HISTORY_MC.Retention_Paid <> 0 then VN_PAYMENT_HISTORY_MC.Retention_Paid + VN_PAYMENT_HISTORY_MC.Discount_Taken else 0 end

Vendor Taxes to Date

This is the job-to-date sales tax + VAT.

Vendor Total Balance Owed

This is what you owe including Retention. It is calculated as follows:

Invoiced To Date - Paid To Date

Vendor Total Current Owed

This is what you owe without Retention. It is calculated as follows:

(Invoiced To Date - Retention To Date) - (Paid To Date - Retention Paid To Date)

Vendor VAT

This is the current month's VAT.

  • Vista table.field: APTL.TaxAmount WHEN TaxType = 3
  • Spectrum table.field:

    VN_GL_DISTRIBUTION_HEADER_MC.Total_VAT_Amt

Vendor VAT to Date

This is the job-to-date VAT.

Transaction Type

Transaction Type

This field indicates the source of the transaction.

table.field: JC_TRANSACTION_HISTORY_MC.Tran_Type_Code

Vendor

Vendor Code

This code represents a specific vendor.

  • Vista table.field: APVM.Vendor
  • Spectrum table.field: VN_VENDOR_MASTER_MC.Vendor_Code
Vendor Type

For Vista: Regular or Supplier. For Spectrum: this field groups vendors by function, or by any other desired classification.

  • Vista table.field: bAPVM.VendorType
  • Spectrum table.field: VN_VENDOR_MASTER_MC.Type