## Appendix: Tables Used by the JD Edwards EnterpriseOne Requisition Self Service System

The JD Edwards EnterpriseOne Requisition Self Service System uses several tables to store processing information.

### Requisition Self Service Tables

This table lists the tables used by the JD Edwards EnterpriseOne Requisition Self Service system:

Table | Description
UNSPSC Commodity Code F40241 | Stores UNSPSC codes that you download from the UNSPSC website (www.unspsc.com).
Secondary Commodity Code F40242 | Stores a secondary relationship with a given commodity (optional).
Commodity Relationship F40243 | Stores the relationship between a UNSPSC code and a general ledger account number.
Commodity Structure Definitions F40500 | Stores the commodity structure.
UNSPSC and Commodity Structure Relationship F40510 | Stores the relationships between UNSPSC codes and commodities.
Supplier and Commodity Structure Relationship F40520 | Store the relationships between suppliers and commodities.
Supplier Commodity Structure Cross Reference F40530 | Stores the relationships between your commodities and the corresponding commodity code of suppliers.
Item and Commodity Structure Relationship F40540 | Stores the relationships between items and commodities.
G/L Account and Commodity Structure Relationship F40551 | Stores the relationships between general ledger account numbers and commodities.
Item Master F4101 | Stores basic information about each item, such as: item number, description, search keys, category codes, and default units of measure,
Item Branch F4102 | Stores default item information, such as each item's process and dimension groups.
Item Location F41021 | Stores each item's quantity information, G/L class, and lot status in each location.
Purchase Order Header | Stores header information for the purchase order created from the requisition.
Purchase Order Detail File F4311 | Stores the detail for the purchase order created from the requisition.
Requisition Order Header F43E01 | Stores requisition header information, such as: order company, order number, order type, business unit, order date, order amount, currency, number of detail lines, number of completed detail lines, number of canceled detail lines, requisition header status, and requisition title.
Requisition Detail F43E11 | Stores information for each detail line on a requisition, such as: supplier number, ship to number, buyer number, item number, unit cost, extended price, quantity ordered, commodity, and requisition detail status, and line type.
eRequisition Receiver file F43E121 | Stores requisitions and related receipt information, such as requisition order number, purchase order number, amount received, and quantity received.
Requisition Multiple Account File F43E16 | Stores account distribution information for requisitions with multiple account distribution.
eReq - Shopping Cart Work File F43E20WF | Stores information regarding items that a user selects when using the Shopping Cart program.
Shopping Cart Detail F43E20 | Stores information regarding items a user selected using the Shopping Cart program. The system creates records in this table when the user submits a requisition from the shopping cart program.
Direct Connect Setup F43E22 | Stores information for suppliers that is required for using Direct Connect.
Direct Connect Supplier Extrinsic Information F43E25 | Stores extrinsic information required for suppliers with which you use Direct Connect.
Approval Authority (Employee) F43E091 | Stores approval authority setup information that was created at the employee level.
Approval Authority (Employee Group/BU) F43E092 | Stores approval authority setup information that was created at the employee group and business unit level.
Approval Authority (Business Unit) F43E093 | Stores approval authority setup information that was created at the business unit level.
Approval Authority Constants F43E094 | Stores the settings for the approval authority constants.
Approval Authority (Commodity/BU) F43E095 | Stores approval authority setup information that was created at the commodity and business unit level.