Work Order Tables

These tables are used in Work Orders:

Table

Description

Next Numbers (F0002)

Assigns a unique number to each work order that you create.

User Defined Codes (F0005)

Stores valid user defined system codes and descriptions.

Business Unit Master (F0006)

Stores job and business unit information.

Generic Message/Rates (F00191)

Stores general instructions that relate to a work order.

Address Book Master (F0101)

Contains name and address information for the customer, manager, originator, and supervisor.

Account Master (F0901)

Contains the chart of accounts information.

Account Balances (F0902)

Stores balances by account and by work order. It also stores information by ledger type and fiscal year.

Account Ledger (F0911)

Stores amount and unit information for each work order. The work order information is stored as a subledger with a subledger type of W.

Work Order Default Coding File (F48001)

Stores default manager and supervisor codes for work orders by category codes 01 through 03.

Work Order Record Types File (F48002)

Contains the valid work order record types. It stores header information for the Work Order Instruction (F4802) table.

Work Order Master File (F4801)

Stores information about a work order, such as the description, estimated hours, responsibility, and costing information. It also stores planned start and end dates. This table contains one record for each work order.

Work Order Instructions File (F4802)

Stores description text and the various record types that are defined in the user defined codes, such as Description of Request and Final Disposition. This table contains one record per line of instruction.

W.O. Status Action Table (F4826)

Stores activity rules that relate to a work order.

Work Order Approval Routing (F4827)

Stores rejection status of work orders.