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:
|
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:
|
Maintenance Schedule File (F1207) |
Stores information about each preventive maintenance schedule, both current and history and includes information, such as:
|
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:
|