This chapter contains these topics:
The JD Edwards World Contract Billing system stores and accesses billing information in the following tables:
Topic | Description |
---|---|
Contract Billing Master
(F5201) |
Stores contract information, including:
|
Owner Pay Item Detail
(F5202) |
Stores the billing terms for the contract. This information includes:
|
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:
|
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:
|
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:
|
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:
|
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. |
Topic | Description |
---|---|
Billing Constants (F48091) | Controls the global processing of:
|
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:
|
Account Derivation Table (F48126) | Stores accounting rules that control journal creation for:
|
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:
|
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. |
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. |
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.