This appendix contains the following topics:
The JD Edwards EnterpriseOne Job Cost system uses tables to store job related and account information.
The JD Edwards EnterpriseOne Job Cost system uses these primary tables:
| Table Name and Number | Description |
|---|---|
| Business Unit Master (F0006) | Stores job master information, including the job description, job number, job type, company, and category codes. |
| Ledger Type Master (F0025) | Stores rules for specific ledger types, such as:
|
| Account Master (F0901) | Stores the JD Edwards EnterpriseOne Job Cost system cost code structure account information, cost code schedule information, and category codes. When a job master record is created, a header account is created in the Account Master led. The header account enables adjustment of the percentage of completion for jobs during profit recognition processing. |
| Account Balances (F0902) | Stores the JD Edwards EnterpriseOne Job Cost system original budget information. Also stores JD Edwards EnterpriseOne Job Cost system account balance details of ledgers for each account in the cost code structure. Data stored in the Account Balances table is used to calculate job progress information. Profit recognition journal entries are posted to the Account Balances table. |
| Account Ledger (F0911) | Tracks revisions to account balance amounts and quantities by providing a detailed audit trail of transactions. JD Edwards EnterpriseOne Job Cost ledgers can contain both amounts and quantities. |
The JD Edwards EnterpriseOne Job Cost system also uses these secondary tables:
| Table Name and Number | Description |
|---|---|
| Company Constants (F0010) | Stores company definitions, including number and name, fiscal date pattern, and current period. |
| Batch Control Records (F0011) | Stores identification header records for each batch. |
| Automatic Accounting Instructions Master (F0012) | Stores the rules that control how the system creates journal entries for profit recognition, protects actual unit amounts during job progress calculations, identifies the accounts that are eligible for draw reporting, and forces general ledger entries to be in balance. |
| Next Numbers (F0002) | Stores the next available number for all automatically assigned numbers in the system, such as profit recognition numbers and draw numbers. For draw reporting, you have the option of using the System 51 next number or draw next number. |
| Job Cost Draws Next Number (F51002) | Stores the job and a draw next number that you assign. |
| Address Book Master (F0101) | Stores names, address numbers, search types, and category codes. |
| Customer Master (F03012) | Stores accounts receivable and billing information about a customer. |
| Supplier Master (F0401) | Stores accounts payable information about a supplier. |
| Accounts Payable Ledger (F0411) | Stores accounts payable transaction history. |
| Inquiry Columns (F5192) | Stores user defined column information to display on the Job Status Inquiry User Defined Columns form. |
| Profit Recognition (F5144) | Stores the financial information for current profit recognition processing. |
| Profit Recognition Account Balance (F5145) | Stores the financial information for previous profit recognition processing. |
| Extended Job Master (F5108) | Stores planned and actual schedule information. |
| Cost Code Schedule (F51901) | Stores Account Master category codes that you set up for alternate sequence viewing and reporting. |
| Draw Reporting Master (F51911) | Stores draw information in addition to the eligible account from the Account Ledger table (F0911). |
| Draw Explanation (F51911EX) | Stores explanations for changed or added draws. |
| Supplemental Database Data Types (F00091) | Stores the definitions of the data types used to track additional information for jobs. |
| Supplemental Data (F00092) | Stores additional information entered about jobs, categorized by data types. |
| Multiple Cost Code Setup (F51092) | Stores versions set up in the Multiple Cost Code Setup program. |
| Chart Type Master (F5109) | Stores chart types used in setting up cost code structures. |