1. Change Management Implementation Guide
  2. Tables and Descriptions

Tables and Descriptions

The JD Edwards EnterpriseOne Change Management system uses these tables:

Table

Description

Change Request Master table (F5301B)

Stores change request master information, such as:

  • Job number

  • Change request number

  • Description

  • Status

  • PCO number

Change Request Details table (F5311)

Stores detail information for change requests, such as:

  • Detail status code for each cost, revenue, and subcontract account

  • Line number

  • Ledger type

  • Requote number

  • Account cost code

  • Account cost type

  • Original, quoted, final, and best amounts for each account type

  • Subcontract number for subcontract accounts

  • Closed flag

Planned Change Order Master table (F5314)

Stores information for PCOs, such as:

  • Status

  • Closed flag

  • CO number of the change order to which the PCO is attached

Change Order Master table (F5315)

Stores information regarding a change order, such as:

  • Status

  • Closed flag

Business Unit Master table (F0006)

Stores job master information, including the job description, job number, job type, company, and category codes.

Account Ledger table (F0911)

Stores detail transactions in the general ledger. One record exists per transaction. The Account Ledger table tracks revisions to account balance amounts and quantities by providing a detailed audit trail of transactions.

Purchase Order Detail File table (F4311)

Stores master information for subcontract management, including subcontract numbers and vendor addresses.

Change Request Detail Status Update table (F53101)

Stores the detail status codes for the ledger that the system updates with the amount type and quantity for cost, revenue, and subcontract accounts.

Log Master Revision table (F4303)

Tracks information for contracts, including:

  • Job number

  • Change request number

  • Log type

  • Log number

  • Status

  • Dates

Log Master table (F4305)

Tracks information for logs at five levels, including:

  • Contract level logs

  • Company level logs

  • Subcontractor level logs

  • Project level logs

  • Job level logs

Account Master table (F0901)

Stores account definitions, including account numbers and descriptions. One record exists per account. The Account Master table enables the adjustment of the percentage of completion for jobs during profit recognition processing by using the header account that is created when a job master record is created.

Account Balances table (F0902)

Stores information about amount and unit ledger types that are used in detail status codes for change requests.

Job-Specific UDCs Master table (F53005)

Stores by job the user-defined code (UDC) information that is specific to the JD Edwards EnterpriseOne Change Management system.

Ledger Type Master File table (F0025)

Stores rules for specific ledger types, such as:

  • Budget amounts

  • Budget units

  • Annual close budget

  • Summarize and close

Automatic Accounting Instructions Master table (F0012)

Stores the rules that determine how the system creates automatic balancing entries, special interim totals for reports, and general information about the chart of accounts.

User Defined Codes table (F0005)

Stores UDCs and their descriptions.