Primary Tables and Descriptions

This table lists the primary tables for JD Edwards EnterpriseOne CAM:

Primary Table

Description

Account Ledger (F0911)

Stores general ledger journal entries and provides an audit trail for both the Asset Account Balances File table (F1202) and the Account Balances table (F0902).

Asset Master File (F1201)

Stores basic information about each piece of equipment, such as:

  • Equipment number

  • Description

  • Account coding

  • Category codes

Asset Account Balances File (F1202)

Stores the account balance amount or unit for each equipment account.

Location Tracking Table (F1204)

Stores location information for a piece of equipment, including:

  • Equipment number.

  • Location.

  • Start effective date.

  • Ending date.

  • Equipment status.

  • Transfer number.

  • Location code, which indicates the type of location, such as planned, current, or history.

Maintenance Schedule File (F1207)

Stores information about each preventive maintenance schedule, both current and history and includes information, such as:

  • When the service is to be performed.

  • When the service was last completed.

  • Current status.

  • References to any associated work order.

Equipment Master Extension (F1217)

Stores additional information about each piece of equipment relating to the JD Edwards EnterpriseOne Service Management and CAM modules.

Equipment Master Location History (F1731)

Stores the owner and site history information for each piece of equipment when changed on the equipment master.

Work Order Master File (F4801)

Stores static information about each work order, such as:

  • Description of work

  • Estimated amount and hours

  • Equipment worked on

  • Charging information