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.
- Month
-
Includes all dates from the start of the month through the end of the month.
- Week
-
This is the week number using a 12 month calendar year.
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