Secondary Tables and Descriptions
This table lists the secondary tables for JD Edwards EnterpriseOne CAM:
Secondary Table |
Description |
|---|---|
User-Defined Codes (F0005) |
Contains all user-defined system values. |
Supplemental Database Setup (F00090) |
Stores supplemental database information. CAM uses these supplemental databases:
|
Supplemental Database Data Types (F00091) |
Stores data types for supplemental databases. |
Supplemental Data (F00092) |
Stores supplemental data in either columnar or narrative format about equipment or work order. |
Automatic Accounting Instructions Master (F0012) |
Contains information used to define the interfaces between CAM and the JD Edwards EnterpriseOne General Ledger chart of accounts. |
Address Book Master (F0101) |
Contains tax assessor and equipment user address information. |
Account Master (F0901) |
Maintains general ledger account data. |
Default Accounting Constants (F12002) |
Maintains default account information by company and asset cost account. |
Default Depreciation Constants (F12003) |
Maintains default information by company and asset cost account of all depreciation books and values. |
Equipment Messages (F1205) |
Stores user-generated messages regarding equipment maintenance. |
Equipment License Master (F1206) |
Stores license and permit information for equipment. |
Equipment PM Schedule (Model) (F12071) |
Stores model maintenance schedules. |
Location History Text (F1210) |
Contains text for location history records. |
Parent History (F1212) |
Contains the history of parents for a component. |
Specification Cross Reference (F1215) |
Stores, by equipment class, the values of each field in the Specification Data table (F1216). |
Specification Data (F1216) |
Stores static equipment information, such as power requirements, size, capacity, and other nameplate information. |
Equipment Parts List (F13017) |
Contains the spare parts information for the equipment. Both catalogued and non-catalogued items can be stored. |
Meter Reading Estimates (F1306) |
Maintains the estimated meter readings that the system uses to schedule maintenance activities. |
Status History File (F1307) |
Maintains a history of status changes to equipment and work orders. |
Equipment Routes Table (F1308) |
Stores equipment maintenance loop information by associated equipment and service type. |
PM Projections (F13411) |
Maintains information about projected Preventive Maintenance (PM) by service type for each piece of equipment. |
Equipment Analysis Groups (F1380) |
Contains the group or subgroup definitions. |
Equipment Analysis Filters (F1381) |
Contains the filters associated with the group or subgroup. |
Equipment Analysis Listing (F1382) |
Contains the current list of equipment associated with the group and subgroup based on the filters. |
Equipment Analysis Costs (F1383) |
Contains the summary and detailed cost information for the group, subgroup, and equipment. |
Equipment Analysis Rules (F1385) |
Contains the rules that control what accounts are included in the costs analysis and their cost classification. |
Equipment Category Code Mapping (F1391) |
Maintains the rules by which the system automatically assigns equipment and business unit category codes when you create master records for new equipment or create work orders for equipment. |
Maintenance Rules (F1393) |
Defines when preventive maintenance are scheduled and provides default values to work orders. |
Bill of Material Master File (F3002) |
Stores information about the parts that are needed to perform a specific type of maintenance. |
Routing Master File (F3003) |
Stores detailed instructions by labor step for a specific type of maintenance. |
Work Order Parts List (F3111) |
Maintains information about parts that are related to specific work orders. |
Work Order Routing (F3112) |
Maintains information about the labor steps that are related to specific work orders. |
Forecast File (F3460) |
Stores the forecast data that the Material Requirements Planning (MRP) program uses for calculation. |
Work Order Record Types File (F48002) |
Stores types of text that are associated with work orders. |
Work Order Instructions File (F4802) |
Stores description text and the various record types that are defined in the UDCs, such as Description of Request and Final Disposition. |
W.O. Status Action Table (F4826) |
Maintains information about the order of allowed statuses through which a work order must pass. |
Work Order Approval Routing (F4827) |
Maintains reject statuses for work orders according to work order type. |
Resource Assignment Constants (F48301) |
Contains constants and system wide default information by business unit. |
Maintenance Schedule Periods (F48302) |
Contains the date from and thru schedule period details. |
Resource Working Hours (F48307) |
Contains the working hour rules for the base and resource working hours. |
Resource Master (F48310) |
Contains the master record for crews, individual and equipment resources. |
Resource Assignments (F48311) |
Contains the detail assignment record for the crew schedule or individual and equipment assignment for the work order or labor detail step. |
Maintenance Schedule Metrics (F48315) |
Contains the availability and schedule compliance metric information for the crew and lead craft by schedule period. |
Maintenance Reschedule Metrics (F48316) |
Contains the rescheduling metric information indicate the reasons why work was rescheduled by crew, craft, and work order. |