JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

Implementation Guides | 920 VMs | Schema: System Table Column Search^beta

JDE TABLESv3

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

910: Top 10 requests

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

812: Top 10 requests

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

18 tables920 | 43E

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43E: Requisition Self Service
1	920	F43E01	RH	19	3	Requisition Order Header	Files	43E: Requisition Self Service
2	920	F43E09	AA	44	1	F43E09 - Approvals Activity Table	Files	43E: Requisition Self Service
3	920	F43E091	AE	11	1	Approval Authority (Employee)	Files	43E: Requisition Self Service
4	920	F43E092	AG	12	2	Approval Authority (Employee Group/BU)	Files	43E: Requisition Self Service
5	920	F43E093	AU	11	1	Approval Authority (Business Unit)	Files	43E: Requisition Self Service
6	920	F43E094	AC	7	1	Approval Authority Constants	Files	43E: Requisition Self Service
7	920	F43E095	AC	12	2	Approval Authority (Commodity/BU)	Files	43E: Requisition Self Service
8	920	F43E11	RD	64	9	Requisition Detail	Files	43E: Requisition Self Service
9	920	F43E121	ER	23	4	eRequisition Receiver file	Files	43E: Requisition Self Service
10	920	F43E15	SX	19	3	Shopping Cart Cross Reference	Files	43E: Requisition Self Service
11	920	F43E16	P3	44	2	Requisition Multiple Account File	Files	43E: Requisition Self Service	Business Data
12	920	F43E20	SC	38	1	Shopping Cart Detail	Files	43E: Requisition Self Service
13	920	F43E20WF	SW	54	1	eReq - Shopping Cart Work File	Files	43E: Requisition Self Service
14	920	F43E21WF	SU	4	1	Supplier Item URL Work File	Files	43E: Requisition Self Service
15	920	F43E22	PS	33	1	Direct Connect Setup	Files	43E: Requisition Self Service
16	920	F43E25	EI	11	1	Direct Connect Supplier Extrinsic Information	Files	43E: Requisition Self Service
17	920	F43E280	DT	13	2	Delegation Master	Files	43E: Requisition Self Service
18	920	F43E35	CP	16	2	Direct Connect Communication Document BSSV Properties	Files	43E: Requisition Self Service