JC Job Ctrl Phases (JCJOBHPHS)

This folder lists all of the control phases (control cost codes). It includes control phase names, status codes, job codes, active flags, etc.

JC Job Phases (JCJOBHPHS)

This folder lists all job phases (cost codes) on each job. It includes company codes, job codes, cost codes, control cost codes, names, budgets, bill codes, max billing amounts, item codes, equipment codes, etc.

JC Categories (JCCAT)

This folder lists all cost categories on each job. It includes the category codes, names, control codes, account codes, WBS codes, and various flags.

JC Period Balances (JCBAL)

This folder contains data from stored contract forecasts, including projected costs and projected revenue. It includes job codes, job control codes, years, periods, cost codes, category codes, units, various amounts, earned value, projected costs including PCI risk, and projected revenue.

JC Transactions (JCDETAIL)

This folder lists all job cost transactions. It includes transaction numbers, transaction types, source codes, job codes, cost codes, category codes, journal codes, batch numbers, post dates, units, amounts, account codes, etc.

JC Summaries (JCJOBCAT)

This folder details a current snapshot of each job, broken down by cost code and category code. It includes budget amounts, budgeted units, current units complete, percent complete, spent to date, disbursed to date, billed to date, retainage paid, change order amounts, etc.

JC Projected Phase Quantities (JCBALPHS)

This folder details projected phase quantities by period at the time of manual forecasting. It includes years, periods, phase/cost codes, and projected quantities.

JC Snapshot Headers (JCSNAPSHOT)

This folder contains the headers from saved snapshots of the job to date information. This includes the snapshot codes, snapshot dates, and descriptions.

JC Snapshot Details (JCSNPSHTDET)

This folder contains the details from saved snapshots of the job to date information. This includes the various amounts, earned value, etc.

JC T&M Invoice Details (JCINVOICE)

This folder contains details from JC time and materials invoices. It includes invoice codes, customer codes, department codes, account codes, due dates, term codes, tax amounts, etc.

JC T&M Billing Rates (JCBILLRATE)

This folder lists the billing rates by job code, phase/cost code, and category code.

JC User Defined Reports (JC0000_V)

This folder contains information from user defined reports created in the Job Costing module in the User Defined Reports screen.

JC Batches (JCBATCH_TABLE)

This folder contains information about batches created in the Job Costing module that are posted to the General Ledger. It includes batch numbers, names, amounts, dates, source codes, etc.

JC Phase Master File (JCMPHS)

This folder contains a master list of the phase/cost codes that would be applied to a new job under a given company. It includes company codes, phase/cost codes, control cost codes, WBS codes, etc.

JC Revenue Summary Detail (JC_REV_SUMM_DRILLDOWN_DET)

This folder summarizes various job financials. It includes company codes, job codes, cost codes, category codes, cost amounts, earned amounts, billable amounts, invoiced amounts, and deferred amounts.

JC Units Completed (JCUTRAN_V)

This folder details information about units completed on a job. It includes batch numbers, transaction dates, transaction quantities, post dates, and various flags.

JC Unit Cost Query by Category (JC_UNIT_COST_QUERY_CAT_MAIN)

This folder shows information about yield and productivity by job category. It includes job codes, category codes, units, yield, productivity, etc.

JC Unit Cost Query by Phase (JC_UNIT_COST_QUERY_PHS_MAIN)

This folder shows information about yield and productivity by cost code. It includes job codes, cost codes, budgeted quantities, completed quantities, spent to date, etc.

JC Billing Query PM Notes (JC_BILLING_QRY_PMNOTES)

This folder shows the PM notes created and associated with different jobs. It includes the job codes, note numbers, creation dates, note descriptions, etc.

JC Billing Query Summary by Ctrl Job (JC_BILLING_QUERY_CTRL_JOB_MAIN)

This folder summarizes billing information by control job. It includes job codes, budget amounts, cost amounts, contract amounts, margin amounts, etc.

JC Billing Query Detail (JC_BILLING_QUERY_DETAIL)

This folder details the billing information by job. It includes job codes, phase/cost codes, category codes, budget amounts, billed amounts, cost amounts, contract amounts, etc.

JC Billing Query Summary by Sub Job (JC_BILLING_QUERY_SUB_JOB_L1)

This folder summarizes the billing information by sub job. It includes job codes, budget amounts, cost amounts, contract amounts, margin amounts, etc.

JC Contract Forecast Header (JCCONTFORECAST)

This folder contains the header information from contract forecasting. It includes the years, periods, company codes, contract codes, bill codes, max billing amounts, max billing quantities, billing rates, pending change order bill amounts, variances, etc.

JC Contract Forecast Detail (JCCONTFORECASTDET)

This folder contains the details around contract forecasting. It includes years, periods, bill codes, various forecasted amounts, percent complete, billed to date, change orders, and various flags and other amounts.

JC Contract Forecast Cost to Complete Details (JCCONTFCOSTCOMPDET)

This folder contains information about costs to complete a job, calculated from contract forecasting.

JC Forecast Period Status (JCCFCAST_PERIOD_STATUS_JSP)

This folder lists the statuses of contract forecasting periods. It includes contract codes, years, periods, and status codes.

JCBI Cost Status Snapshot (JC_COST_STATUS)

This folder shows saved snapshots of the job cost status. It includes snapshot dates, phase/cost codes, category codes, budgets, change orders, spent, committed, cost to complete, projected over/under, etc.

JCBI Job Phs Cat Summary (JC_JOB_PHS_CAT_SUMMARY)

This folder shows a summary of the job life to date information by phase/cost code and category code. It includes budgets, amounts, and projects on the cost side and on the revenue side.

JCBI Phase Unit Summary – Earned Value (JCBI_PHASE_UNIT_SUMMARY)

This folder contains information about earned value. It includes a breakdown of job to date quantities, hours, and costs by phase/cost codes, as well as budgets and projections.

JCBI Analysis Query (JC_ANALYSIS_LOG_V)

This folder summarizes the AP and AR invoice amounts per job. It includes job codes, revenue budgets, AR invoice amounts, AR receipt amounts, cost budget amounts, AP invoice amounts, and AP paid amounts.

JCBI Cost Budget Query (JC_COSTBUDGET_LOG_V)

This folder summarizes the budget and spent amounts by cost code and category code per job. It includes the company codes, job codes, cost codes, category codes, budgeted costs and revenues, spent amounts, and remaining amounts.

JCBI Cost Summary Query (JC_JOBCOST_LOG_V)

This folder summarizes the spent and billed amounts on a job broken down by phase/cost and category codes.

JCBI Transaction Detail Query (JC_DETAILS_LOG_V)

This folder shows details from JC transactions. It includes journal codes, transaction numbers, transaction amounts, type codes, etc.

JC Expected Cost 1 (JC_EXPECTED_COST1)

This folder displays the cost spreading for a list of projects across time. It also displays an average of the cumulative cost across time for a pre-defined list of projects. It uses the following context variables: PROJECT_LIST_ID, COMP_CODE, COST_CODE, CAT_CODE. The COMP_CODE is mandatory and all others are optional. The calculation steps are as follows:

1. Select all cost-type transactions on all jobs that roll up to the cost and category codes selected (if none selected, all transactions).

2. Calculate the relative date on each job cost transaction (percent of time between start and end date of the job).

3. Calculate the cumulative cost across time for each job (i.e., how much was spent at 10% time, at 20% time).

4. Normalize the cumulative costs as a percent of the current budget on each job.

5. Average the results from Step 4 into a single curve for a subset of jobs (PROJECT_LIST_ID) or all concluded jobs (if PROJECT_LIST_ID is not set).

6. Multiply the result of Step 5 by the average budget for a subset of jobs (PROJECT_LIST_ID) or all concluded jobs (if PROJECT_LIST_ID is not set).

7. Display the results of Step 6 with the results of Step 3.

JC Expected Cost 2 (JC_EXPECTED_COST2)

This folder displays the average cost spreading for a list of projects across time. It uses the following context variables: PROJECT_LIST_ID, COMP_CODE, PROJ_CODE, COST_CODE, CAT_CODE. The COMP_CODE and PROJ_CODE are mandatory and all others are optional. The calculation steps are as follows:

1. Select all cost-type transactions on all jobs that roll up to the cost and category codes selected (if none selected, all transactions).

2. Calculate the relative date on each job cost transaction (percent of time between start and end date of the job).

3. Calculate the cumulative cost across time for each job (i.e., how much was spent at 10% time, at 20% time).

4. Normalize the cumulative costs as a percent of the current budget on each job.

5. Average the results from Step 4 into a single curve for a subset of jobs (PROJECT_LIST_ID) or all concluded jobs (if PROJECT_LIST_ID is not set).

6. Multiply the result of Step 5 by the current budget of the currently selected job.

7. Display the results of Step 6 with the results of the currently selected job.

JC Expected Cost 3 (JC_EXPECTED_COST3)

This folder displays the cost spreading for the currently selected job. It also displays a projected cost spread for the remainder of the job. It uses the following context variables: PROJECT_LIST_ID, COMP_CODE, PROJ_CODE, COST_CODE, CAT_CODE. The COMP_CODE and PROJ_CODE are mandatory and all others are optional. The calculation steps are as follows:

1. Select all cost-type transactions on all jobs that roll up to the cost and category codes selected (if none selected, all transactions).

2. Calculate the relative date on each job cost transaction (percent of time between start and end date of the job).

3. Calculate the cumulative cost across time for each job (i.e., how much was spent at 10% time, at 20% time).

4. Normalize the cumulative costs as a percent of the current budget on each job.

5. Average the results from Step 4 into a single curve for a subset of jobs (PROJECT_LIST_ID) or all concluded jobs (if PROJECT_LIST_ID is not set).

6. Multiply the result of Step 5 by the current budget of the currently selected job.

7. Scale the result of Step 6 to match the “spent to date” on the currently selected job on the present day.

8. Display the results of Step 7 with the results of the currently selected job.