Secondary Tables and Descriptions

This table lists the secondary tables that JD Edwards EnterpriseOne Equipment Billing uses:

Secondary Table

Description

User-Defined Codes (F0005)

Contains all user-defined system values.

Supplemental Data (F00092)

Stores supplemental data in either columnar or narrative format about equipment or work orders.

Automatic Accounting Instructions Master (F0012)

Contains information used to define the interfaces between JD Edwards EnterpriseOne 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.

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 Rates (F1301)

Maintains billing rates used by equipment time billing and equipment location billing. Rates can be set up for specific rate groups, dates, and pieces of equipment. This table also is used to break up equipment rates into components if needed.

Equipment Distribution Rules (F1305)

Maintains distribution rules used by equipment location billing. This table stores account numbers used to charge for equipment use and transfer action codes (that is, rent to job, sold to job) which control how the system bills for the equipment use.

Status History (F1307)

Maintains a history of status changes to equipment and work orders.

Equipment Rate Code Definition (F1390)

Maintains a definition of each rate code. For example, what is its frequency (that is, monthly, weekly, and so forth), is it billable, and if it is part of a rate code hierarchy.

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.