JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

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

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F0911GLAccount Ledger
4F4101IMItem Master
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

53 tables812 | 43

43: Procurement
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F40910P#143Commitment Integrity Report Work FileRegular Work Files43: ProcurementAS400 Coexistence Tables
2812F4095TEMML91F4095 Temporary TableConstants Files43: ProcurementNo
3812F41061CB235Supplier Price/Catalog FileMaster Files45: Advanced PricingAS400 Coexistence Tables
4812F41291IG283Item Cost ComponentsSecondary Master Files43: ProcurementAS400 Coexistence Tables
5812F43008AP63Approval LevelsExtra Features Files43: ProcurementAS400 Coexistence Tables
6812F4301PH895Purchase Order HeaderTransaction Files43: ProcurementAS400 Coexistence Tables
7812F4301ZPA1045PO Header Work FileWork Files43: ProcurementNo
8812F4301Z1SY1051Purchase Order Header Unedited Transaction TableTransaction Files43: ProcurementNo
9812F4304PC71Log Hierarchy ConstantsConstants Files43: Procurement
10812F4305PL345Log MasterTransaction Files43: Procurement
11812F43080PD1951Approvals Fields ConstantsTransaction Files43: ProcurementBusiness Data
12812F43090PC525Supplier/Item RelationshipsExtra Features Files43: ProcurementAS400 Coexistence Tables
13812F43091PP111Receipt Routing Master FileExtra Features Files43: ProcurementAS400 Coexistence Tables
14812F43092PX224Purchase Order Receipt Routing FileExtra Features Files43: ProcurementAS400 Coexistence Tables
15812F43092ZPV581Receipt Routing Work FileRegular Work Files43A: Purchase Order Receipt/RoutingNo
16812F43092Z1SZ751Receipt Routing Unedited Transaction TableTransaction Files43: ProcurementAS400 Coexistence Tables
17812F43093PE101Inspection/Sample Size TableExtra Features Files43: ProcurementAS400 Coexistence Tables
18812F43094P581Supplier Item Additional RoutesExtra Features Files43: ProcurementBusiness Data
19812F43099PO291Receipt Routing Ledger FileHistory Files43: ProcurementAS400 Coexistence Tables
20812F43100IX71Supplier and Branch Plant RelationshipFiles43: Procurement
21812F4311PD21810Purchase Order Detail FileTransaction Files43: ProcurementAS400 Coexistence Tables
22812F4311TPD192Purchase Order Detail Tag FileTransaction Files43: ProcurementNo
23812F4311ZPW2445Purchase Order Generator FileRegular Work Files43: ProcurementNo
24812F4311Z1SZ2281Purchase Order Detail Unedited Transaction TableTransaction Files43: ProcurementNo
25812F43121PR15411Purchase Order Receiver FileTransaction Files43A: Purchase Order Receipt/RoutingBusiness Data
26812F43121TPR262Purchase Order Receiver Tag FileTransaction Files43: ProcurementNo
27812F43121TBPR102Purchase Order Receiver Tag TableTransaction Files43A: Purchase Order Receipt/Routing
28812F43121ZPW1973Receiver workfileRegular Work Files43A: Purchase Order Receipt/RoutingNo
29812F43121Z1SZ1991Receipts Unedited Transaction TableTransaction Files43: ProcurementNo
30812F4314ZPN2082Voucher Match Selection FileRegular Work Files43: ProcurementNo
31812F4316P3554Purchase Order Multiple Account FileFiles43: ProcurementBusiness Data
32812F4316MP481Model Purchase Order Multiple Account FileFiles43: ProcurementBusiness Data
33812F4316TP3161Purchase Order Multiple Account Tag FileFiles43: Procurement
34812F4318PY171Approval/Rejection ReasonsTransaction Files43: ProcurementAS400 Coexistence Tables
35812F43199OL2208P.O. Detail Ledger File - Flexible VersionHistory Files43: ProcurementAS400 Coexistence Tables
36812F4322PZ141Purchasing Tolerance RulesConstants Files43: ProcurementAS400 Coexistence Tables
37812F4330P0143Supplier Selection FileTransaction Files43: ProcurementAS400 Coexistence Tables
38812F4331P1121Quantity Breaks FileTransaction Files43: ProcurementAS400 Coexistence Tables
39812F4332P2141Multiple Requisition FileTransaction Files43: ProcurementAS400 Coexistence Tables
40812F4333WFPO101Purchase Order Dispatch Work FileFiles43: Procurement
41812F4340RD281Purchase Rebate Master FileMaster Files45: Advanced PricingAS400 Coexistence Tables
42812F4341RL61Purchase Rebate Threshold FileMaster Files45: Advanced PricingAS400 Coexistence Tables
43812F4342RK71Purchase Inclusion RulesMaster Files45: Advanced PricingAS400 Coexistence Tables
44812F4343RH291Purchase Rebate HistoryTransaction Files45: Advanced PricingAS400 Coexistence Tables
45812F4350H121Supplier Page HyperlinksExtra Features Files43: ProcurementNo
46812F4351H231Supplier Item HyperlinksExtra Features Files43: ProcurementNo
47812F4355PT71Subcontractor ThresholdFiles43: Procurement
48812F43632ZOI271Open Purchase Order by Item Work FileRegular Work Files43: Procurement
49812F4371PD351Suggested Reorder Stock ItemsFiles43: Procurement
50812F43E09AA441F43E09 - Approvals Activity TableFiles43: Procurement
51812F43UI50DPW681PO Print Detail Work FileExtra Features Files43: ProcurementNo
52812F43UI50HPA641PO Print Header Work FileExtra Features Files43: ProcurementNo
53812F44445ZSW81Subcontractor WaiverWork Files43: ProcurementNo