B Tables Used by the JD Edwards EnterpriseOne Requisition Self Service System

This appendix contains the following topics:

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

B.1 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

F4301

 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.
Delegation Master (F43E280) Stores the details about the Requisition delegation. Details about the delegator, original requestor, delegated requestor, delegation period and the application on which the delegation is valid is stored in this table.