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
3F4101IMItem Master
4F0911GLAccount Ledger
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

62 tables920 | 43

43: Procurement
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F40910P#143Commitment Integrity Report Work FileRegular Work Files43: ProcurementBusiness Data
2920F4095TEMML91F4095 Temporary TableConstants Files43: ProcurementBusiness Data
3920F41061CB235Supplier Price/Catalog FileMaster Files45: Advanced PricingBusiness Data
4920F41291IG283Item Cost ComponentsSecondary Master Files43B: Voucher Match and Landed Cost
5920F43008AP63Approval LevelsExtra Features Files43: ProcurementBusiness Data
6920F4301PH1276Purchase Order HeaderTransaction Files43: ProcurementBusiness Data
7920F4301SWPS81Purchase Order Summary Work TableFiles43: Procurement
8920F4301ZPA1425PO Header Work FileWork Files43: ProcurementBusiness Data
9920F4301Z1SY1431Purchase Order Header Unedited Transaction TableTransaction Files43: Procurement
10920F4303PK283Log MasterTransaction Files43: ProcurementBusiness Data
11920F4304PC71Log Hierarchy ConstantsConstants Files43: Procurement
12920F4305PL345Log MasterTransaction Files43: Procurement
13920F43080PD1951Approvals Fields ConstantsTransaction Files43: ProcurementBusiness Data
14920F43090PC525Supplier/Item RelationshipsExtra Features Files43: ProcurementBusiness Data
15920F43091PP111Receipt Routing Master FileExtra Features Files43A: Purchase Order Receipt/RoutingBusiness Data
16920F43092PX224Purchase Order Receipt Routing FileExtra Features Files43A: Purchase Order Receipt/RoutingBusiness Data
17920F43092ZPV581Receipt Routing Work FileRegular Work Files43A: Purchase Order Receipt/RoutingBusiness Data
18920F43092Z1SZ751Receipt Routing Unedited Transaction TableTransaction Files43A: Purchase Order Receipt/RoutingBusiness Data
19920F43093PE101Inspection/Sample Size TableExtra Features Files43A: Purchase Order Receipt/RoutingBusiness Data
20920F43094P581Supplier Item Additional RoutesExtra Features Files43: ProcurementBusiness Data
21920F43099PO291Receipt Routing Ledger FileHistory Files43A: Purchase Order Receipt/RoutingBusiness Data
22920F43100IX71Supplier and Branch Plant RelationshipFiles43: Procurement
23920F4310XCM112CM Purchase Order Cross ReferenceFiles43: ProcurementBusiness Data
24920F4311PD22812Purchase Order Detail FileTransaction Files43: Procurement
25920F4311TPD192Purchase Order Detail Tag FileTransaction Files43: ProcurementBusiness Data
26920F4311ZPW2545Purchase Order Generator FileRegular Work Files43: ProcurementBusiness Data
27920F4311Z1SZ2371Purchase Order Detail Unedited Transaction TableTransaction Files43: Procurement
28920F43121PR16312Purchase Order Receiver FileTransaction Files43A: Purchase Order Receipt/RoutingBusiness Data
29920F43121TPR262Purchase Order Receiver Tag FileTransaction Files43A: Purchase Order Receipt/RoutingBusiness Data
30920F43121TBPR102Purchase Order Receiver Tag TableTransaction Files43A: Purchase Order Receipt/Routing
31920F43121ZPW2123Receiver workfileRegular Work Files43A: Purchase Order Receipt/RoutingBusiness Data
32920F43121Z1SZ2031Receipts Unedited Transaction TableTransaction Files43A: Purchase Order Receipt/RoutingBusiness Data
33920F43147FD592Freight Distribution WorkfileWork Files43B: Voucher Match and Landed Cost
34920F4314ZPN2132Voucher Match Selection FileRegular Work Files43B: Voucher Match and Landed Cost
35920F4316P3574Purchase Order Multiple Account FileFiles43: ProcurementBusiness Data
36920F4316MP481Model Purchase Order Multiple Account FileFiles43: ProcurementBusiness Data
37920F4316TP3161Purchase Order Multiple Account Tag FileFiles43: Procurement
38920F4317PD241Purchase Order Detail Non-BillableFiles43: ProcurementBusiness Data
39920F4318PY171Approval/Rejection ReasonsTransaction Files43: ProcurementBusiness Data
40920F43199OL2308P.O. Detail Ledger File - Flexible VersionHistory Files43: ProcurementBusiness Data
41920F4320PC131Purchase Order ClausesFiles43: Procurement
42920F4322PZ141Purchasing Tolerance RulesConstants Files43: ProcurementBusiness Data
43920F4330P0143Supplier Selection FileTransaction Files43: ProcurementBusiness Data
44920F4331P1121Quantity Breaks FileTransaction Files43: ProcurementBusiness Data
45920F4332P2141Multiple Requisition FileTransaction Files43: ProcurementBusiness Data
46920F4333WFPO101Purchase Order Dispatch Work FileFiles43: Procurement
47920F4340RD281Purchase Rebate Master FileMaster Files45: Advanced PricingBusiness Data
48920F4341RL61Purchase Rebate Threshold FileMaster Files45: Advanced PricingBusiness Data
49920F4342RK71Purchase Inclusion RulesMaster Files45: Advanced PricingBusiness Data
50920F4343RH291Purchase Rebate HistoryTransaction Files45: Advanced PricingBusiness Data
51920F4350H121Supplier Page HyperlinksExtra Features Files43: ProcurementBusiness Data
52920F4351H231Supplier Item HyperlinksExtra Features Files43: ProcurementBusiness Data
53920F4355PT71Subcontractor ThresholdFiles43: Procurement
54920F43632ZOI271Open Purchase Order by Item Work FileRegular Work Files43: Procurement
55920F4371PD351Suggested Reorder Stock ItemsFiles43: Procurement
56920F43UI50CWC192PO Print Clauses TableFiles43: Procurement
57920F43UI50DPW801PO Print Detail Work FileExtra Features Files43: ProcurementBusiness Data
58920F43UI50HPA1061PO Print Header Work FileExtra Features Files43: ProcurementBusiness Data
59920F44445ZSW81Subcontractor WaiverWork Files43: ProcurementBusiness Data
60920F74U0140AC221ACM - Application Certificate ConstantsMaster Files43B: Voucher Match and Landed Cost
61920F74U0141AC457ACM - Application / Certificate MasterMaster Files43B: Voucher Match and Landed Cost
62920F74U0142DH261ACM - Application / Certificate Status HistoryHistory Files43B: Voucher Match and Landed Cost