Setting Up UDCs for ETO

JD Edwards EnterpriseOne from Oracle provides these UDC tables, which enable you to define engineer-to-order processes according to specifications that are derived from the business environment:

UDC

Description

Order Type (48/OT)

This table enables you to distinguish each work order record in the Work Order Master table (F4801) from other records with different work order types. For example, you do not use the same document type and work order type to represent both an equipment work order and a manufacturing work order.

Cost Classification (31P/CC)

This table lists the cost buckets that are used in the Project Workbench program (P31P001) to categorize the costs that are stored in the Production Cost (F3102) and Account Ledger (F0911) tables for visibility and rollup in the work breakdown structure for a project.

Project Quote Status (31P/QP)

This table provides the definitions of the statuses that the system uses to track the progress of the different quote versions that you create when you generate a proposal for a customer. The system provides five quote statuses that are hard-coded.

Project Quote Inactive Reason Code (31P/RC)

This table lists reasons why quotes are set to an inactive status.

Task Dependency Type (31P/DT)

This table lists the standard task dependency types that you can use to establish dependencies between the tasks on the work breakdown structure.

Stocking Type Code (41/I)

This table lists the stocking types that you assign to items in the Item Master program (P4101). You use the stocking type code to designate an item as project specific.

Commitment Document Types (40/CT)

This table lists the document types that are considered for financial commitments.

Project Accounting (31P/AI)

This table lists the automatic accounting instructions (AAIs) that are set to enable project accounting.

Project Billing Method (31P/PB)

This table lists the available project billing methods that you can select for the project on the Add/Revise Project form.

Distribution Requirements Planning (34/DR)

This table lists project-specific quantity types for distribution requirements planning (DRP).

DRP Unadjusted (34/DU)

This table lists project-specific quantity types for unadjusted DRP.

Electronic Mail Boxes (02/MB)

This table includes electronic mailboxes for project notifications.

Inventory Interface (H40/IV)

This table includes inventory interface C to enable financial commitments for projects with a Job Cost interface.

Maintenance Material Planning (34/MM)

This table lists project-specific quantity types for material maintenance planning.

Master Production Schedule (34/MS)

This table lists project-specific quantity types for master production scheduling (MPS).

Plant Maintenance Management (34/PM)

This table lists project-specific quantity types for plant maintenance management.

Material Requirements Planning (34/MR)

This table lists project-specific quantity types for material requirements planning (MRP).

Quantity Type (34/QT)

This table lists project-specific quantity types for supply and demand.

Resource Assignment Level (48/RL)

This table specifies whether resource assignments are at the level of the work order or the work-order labor detail, based on the document type of the work order. To make assignments at the labor detail level, you must use this UDC table to specify the work order document type. You use resource assignments UDC 48/RL for equipment and service orders only. UDC 48/RL is not used for manufacturing work orders.