JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides |  920 VMs | 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
3F0411RPAccounts Payable Ledger
4F4211SDSales Order Detail File
5F4311PDPurchase Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

61 tables910 | 43

43: Procurement
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F40910P#143Commitment Integrity Report Work FileRegular Work Files43: ProcurementBusiness Data
2910F4095TEMML91F4095 Temporary TableConstants Files43: ProcurementBusiness Data
3910F41061CB235Supplier Price/Catalog FileMaster Files45: Advanced PricingBusiness Data
4910F41291IG283Item Cost ComponentsSecondary Master Files43B: Voucher Match and Landed Cost
5910F43008AP63Approval LevelsExtra Features Files43: ProcurementBusiness Data
6910F4301PH1276Purchase Order HeaderTransaction Files43: ProcurementBusiness Data
7910F4301ZPA1425PO Header Work FileWork Files43: ProcurementBusiness Data
8910F4301Z1SY1431Purchase Order Header Unedited Transaction TableTransaction Files43: Procurement
9910F4303PK283Log MasterTransaction Files43: ProcurementBusiness Data
10910F4304PC71Log Hierarchy ConstantsConstants Files43: Procurement
11910F4305PL345Log MasterTransaction Files43: Procurement
12910F43080PD1951Approvals Fields ConstantsTransaction Files43: ProcurementBusiness Data
13910F43090PC525Supplier/Item RelationshipsExtra Features Files43: ProcurementBusiness Data
14910F43091PP111Receipt Routing Master FileExtra Features Files43A: Purchase Order Receipt/RoutingBusiness Data
15910F43092PX224Purchase Order Receipt Routing FileExtra Features Files43A: Purchase Order Receipt/RoutingBusiness Data
16910F43092ZPV581Receipt Routing Work FileRegular Work Files43A: Purchase Order Receipt/RoutingBusiness Data
17910F43092Z1SZ751Receipt Routing Unedited Transaction TableTransaction Files43A: Purchase Order Receipt/RoutingBusiness Data
18910F43093PE101Inspection/Sample Size TableExtra Features Files43A: Purchase Order Receipt/RoutingBusiness Data
19910F43094P581Supplier Item Additional RoutesExtra Features Files43: ProcurementBusiness Data
20910F43099PO291Receipt Routing Ledger FileHistory Files43A: Purchase Order Receipt/RoutingBusiness Data
21910F43100IX71Supplier and Branch Plant RelationshipFiles43: Procurement
22910F4310XCM112CM Purchase Order Cross ReferenceFiles43: ProcurementBusiness Data
23910F4311PD22812Purchase Order Detail FileTransaction Files43: Procurement
24910F4311TPD192Purchase Order Detail Tag FileTransaction Files43: ProcurementBusiness Data
25910F4311ZPW2545Purchase Order Generator FileRegular Work Files43: ProcurementBusiness Data
26910F4311Z1SZ2371Purchase Order Detail Unedited Transaction TableTransaction Files43: Procurement
27910F43121PR16312Purchase Order Receiver FileTransaction Files43A: Purchase Order Receipt/RoutingBusiness Data
28910F43121TPR262Purchase Order Receiver Tag FileTransaction Files43A: Purchase Order Receipt/RoutingBusiness Data
29910F43121TBPR102Purchase Order Receiver Tag TableTransaction Files43A: Purchase Order Receipt/Routing
30910F43121ZPW2123Receiver workfileRegular Work Files43A: Purchase Order Receipt/RoutingBusiness Data
31910F43121Z1SZ2031Receipts Unedited Transaction TableTransaction Files43A: Purchase Order Receipt/RoutingBusiness Data
32910F43147FD592Freight Distribution WorkfileWork Files43B: Voucher Match and Landed Cost
33910F4314ZPN2132Voucher Match Selection FileRegular Work Files43B: Voucher Match and Landed Cost
34910F4316P3574Purchase Order Multiple Account FileFiles43: ProcurementBusiness Data
35910F4316MP481Model Purchase Order Multiple Account FileFiles43: ProcurementBusiness Data
36910F4316TP3161Purchase Order Multiple Account Tag FileFiles43: Procurement
37910F4317PD241Purchase Order Detail Non-BillableFiles43: ProcurementBusiness Data
38910F4318PY171Approval/Rejection ReasonsTransaction Files43: ProcurementBusiness Data
39910F43199OL2308P.O. Detail Ledger File - Flexible VersionHistory Files43: ProcurementBusiness Data
40910F4320PC131Purchase Order ClausesFiles43: Procurement
41910F4322PZ141Purchasing Tolerance RulesConstants Files43: ProcurementBusiness Data
42910F4330P0143Supplier Selection FileTransaction Files43: ProcurementBusiness Data
43910F4331P1121Quantity Breaks FileTransaction Files43: ProcurementBusiness Data
44910F4332P2141Multiple Requisition FileTransaction Files43: ProcurementBusiness Data
45910F4333WFPO101Purchase Order Dispatch Work FileFiles43: Procurement
46910F4340RD281Purchase Rebate Master FileMaster Files45: Advanced PricingBusiness Data
47910F4341RL61Purchase Rebate Threshold FileMaster Files45: Advanced PricingBusiness Data
48910F4342RK71Purchase Inclusion RulesMaster Files45: Advanced PricingBusiness Data
49910F4343RH291Purchase Rebate HistoryTransaction Files45: Advanced PricingBusiness Data
50910F4350H121Supplier Page HyperlinksExtra Features Files43: ProcurementBusiness Data
51910F4351H231Supplier Item HyperlinksExtra Features Files43: ProcurementBusiness Data
52910F4355PT71Subcontractor ThresholdFiles43: Procurement
53910F43632ZOI271Open Purchase Order by Item Work FileRegular Work Files43: Procurement
54910F4371PD351Suggested Reorder Stock ItemsFiles43: Procurement
55910F43UI50CWC192PO Print Clauses TableFiles43: Procurement
56910F43UI50DPW801PO Print Detail Work FileExtra Features Files43: ProcurementBusiness Data
57910F43UI50HPA1061PO Print Header Work FileExtra Features Files43: ProcurementBusiness Data
58910F44445ZSW81Subcontractor WaiverWork Files43: ProcurementBusiness Data
59910F74U0140AC221ACM - Application Certificate ConstantsMaster Files43B: Voucher Match and Landed Cost
60910F74U0141AC457ACM - Application / Certificate MasterMaster Files43B: Voucher Match and Landed Cost
61910F74U0142DH261ACM - Application / Certificate Status HistoryHistory Files43B: Voucher Match and Landed Cost