5 Contract Billing Tables

This chapter contains these topics:

The JD Edwards World Contract Billing system stores and accesses billing information in the following tables:

5.1 Contract Setup

Topic Description
Contract Billing Master

(F5201)

 Stores contract information, including:

  • Detail contract information by contract number

  • Customer/owner information

  • Contract description

  • Tax information

  • Retainage rules

  • Project and host business units

  • Parent contract number

  • Currency mode and codes

  • Billed-to-date information
Owner Pay Item Detail

(F5202)

 Stores the billing terms for the contract. This information includes:

  • Detailed owner pay items by contract

  • Multiple pricing types

  • Schedule of values by pay item

  • Quantities

  • Recurring amounts and frequencies

  • Tax information

  • Retainage rules
Account Cross Reference Accounts

(F5212)

 Stores the cross-reference information for T&M, lump sum, and unit price owner pay items.

For T&M owner pay items, the account number and related information associates the billable costs with the contract billing lines when the system creates the workflle transaction during Workfile Generation or reapplies information during Workfile Re-extend.

For lump sum and unit price owner pay items, the account number and related information associates the costs with the contract owner pay items when the system calculates workfile transactions for revenue and invoice pay item transactions for billing.

The information includes:

  • Account number

  • Subledger and type

  • Job type

  • Job step

  • Pay type

  • Employee number

  • Equipment number

  • Rate group
Pay Item Mark Up Cross Reference Accounts

(F5213)

 Stores the information you cross-reference with the contract owner pay items for fees. The information includes:

  • Fee rates, which are defined by a percentage or rate code

  • Amount basis for the fee calculation

  • Specific contract owner pay items that establish the basis of the fee calculation
Rate Code Definition (F52131) Stores the user defined information for the rate codes that you can use for the calculation of billing fee lines. The definition for a rate code includes the:

  • Description

  • Percentage rate

  • Effective dates
Component Code Reference (F5214) Stores component codes for component owner pay items.
Component Pay Item Cross Reference (F5215) Stores information to identify owner pay items that are cross-referenced to component codes.
Milestone / Progress Billing Information (F5216) Stores information of events or percentages that have been predefined to create invoices.

For these owner pay items, the system uses the completion flag and the percentage related to the event to calculate invoice pay item transactions during Invoice Generation.

The information includes:

Stores information of events or percentages that have been predefined to create invoices.

For these owner pay items, the system uses the completion flag and the percentage related to the event to calculate invoice pay item transactions during Invoice Generation.

The information includes:

  • Billing event

  • Percent or amount complete

  • Date complete

  • Completion flag
Milestone/Progress Billing Line Cross-reference Information (F52161) Stores information when cross-referencing a milestone or progress billing owner pay item. Prepayment owner pay items (rated or draw) and progress billing lines can be cross-referenced to another progress billing line.

5.2 System Setup

Topic Description
Billing Constants (F48091) Controls the global processing of:

  • Billable costs

  • Burden processing

  • Effective dates

  • Customer information

  • Journal processing

  • Default markup percentage
Cost Plus Mark Up Information (F48096) Determines how to mark up the selected transactions. The system uses one or more of the following markup rules:

  • Per unit rate

  • Percentage of costs

  • Fixed amount added to costs

  • Any combination of the above

  • No markup added to costs
Account Derivation Table (F48126) Stores accounting rules that control journal creation for:

  • Actual or unbilled revenue

  • Costs

  • Margins

  • Unbilled accounts receivable

  • Reallocations
Component Table Master (F4860) Stores information used to identify component tables. The Cost Plus Mark Up table uses this information to locate the correct entries to create component workfile transactions.
Component Table Detail (F4861) Determines the markups applied to billing transactions to create component workfile transactions. The system uses one or more of the following calculation rules:

  • Unit Based

  • Amount Based
Component Cross Reference (F4862) Stores cross-reference information used in the calculation of compound components.
Format Cross-Reference (F4858) Stores information used to print invoices. This table is used to assign invoice formats to specific customers, jobs, or work orders.

5.3 Workfile Management

Topic Description
Billing Workfile (F4812) Stores workfile transactions as an inventory of the billable costs. The workfile transactions correspond to the cost transactions generated in other systems or entered manually within the billing system. This information is the starting point for the billing process.
Billing Workfile History (F4812H) Stores historic information for processed workfile transactions. The information provides a detailed audit trail of the changes related to each individual workfile transaction.

5.4 Transaction Processing

Topic Description
Billing Batch Control (F48011) Stores information about invoice and G/L batches created within the Contract Billing system, including the batch status and the current activity.
Invoice Summary Work File (F4822) Stores the information that the system uses to print invoices and create A/R ledger information.
Delete Invoices - Contract/Service Billing (F48229) Provides an audit trail of deleted invoice numbers.
Invoice Summary Access (F48520) Stores cumulative invoice information that can be used for reporting purposes, such as displaying billed-to-date information on an invoice. This billed-to-date information is stored in more detail here than in the Invoice Summary. This optional file is controlled by an option in Billing Constants. Cumulative invoice amounts are stored by G/L date, employee/supplier, cost account, and contract owner pay item.
Detail Journal Work File (F48910) Temporarily stores the detail journal transactions used prior to creating accounting journal entries.
Compressed Journal Workfile (F48911) Temporarily stores a summary of the transactions stored in Detail Journal Work File. This summarization is based on ledger type, currency code, G/L date, business unit, object, subsidiary, and subledger. These entries are used to create the final journal entries in the Account Ledger (F0911).
G/L Link (F48912) Stores key information from the workfile transaction and the subsequent journal entry created in the Account Ledger table. This table is used for reporting and audit purposes.
Payroll Journal Reclassification Workfile (F0618WF) Temporarily stores the original and correcting entries created when the cost account of a workfile transaction originating from payroll has been changed in the Billing system. These entries are written to the Payroll History table (F0618) when Create G/L Entries or Create A/R Entries is run.

The following graphic illustrates the relationships between the tables in the Contract Billing system.

Figure 5-1 Contract Billing Tables

Description of Figure 5-1 follows
Description of ''Figure 5-1 Contract Billing Tables''