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
10F4111ILItem Ledger File

812: Top 10 requests

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

45 tables920 | 45

45: Advanced Pricing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F4070SN228Price Adjustment ScheduleMaster Files45: Advanced PricingBusiness Data
2920F4070PSN238Price Adjustment Schedule PurgeMaster Files45: Advanced PricingBusiness Data
3920F4071AT622Price Adjustment TypeMaster Files45: Advanced PricingBusiness Data
4920F4071PAT632Price Adjustment Type PurgeMaster Files45: Advanced PricingBusiness Data
5920F4072AD377Price Adjustment DetailMaster Files45: Advanced PricingBusiness Data
6920F4072PAD387Price Adjustment Detail PurgeMaster Files45: Advanced PricingBusiness Data
7920F4072WAD402Price Adjustment Detail Work FileMaster Files45: Advanced PricingBusiness Data
8920F4073FG233Free Goods Master FileMaster Files45: Advanced PricingBusiness Data
9920F4073PFG243Free Goods Master File PurgeMaster Files45: Advanced PricingBusiness Data
10920F4075VB123Price Variable TableMaster Files45: Advanced PricingBusiness Data
11920F4076FM83Price Formula MasterMaster Files45: Advanced PricingBusiness Data
12920F4077RT315Rebate ThresholdsMaster Files45: Advanced PricingBusiness Data
13920F4077PRT325Rebate Thresholds PurgeMaster Files45: Advanced PricingBusiness Data
14920F4078RH332Rebate Transaction SummaryTransaction Files45: Advanced PricingBusiness Data
15920F4079SV365Rebate Transaction DetailTransaction Files45: Advanced PricingBusiness Data
16920F4094TEMTC133ICID Conversion X-RefFiles45: Advanced PricingBusiness Data
17920F40UI84XR71Orders Affected by Price Change (Work-file)Work Files45: Advanced PricingBusiness Data
18920F4501MS142Master Schedule AdjustmentMaster Files45: Advanced PricingBusiness Data
19920F4502FG131Free Goods CatalogFiles45: Advanced PricingBusiness Data
20920F4510PW166Price Workbench Query HeaderFiles45: Advanced Pricing
21920F4511WAP996Pricing Structure ViewFiles45: Advanced PricingBusiness Data
22920F4550BH131Basket Master HeaderFiles45: Advanced PricingBusiness Data
23920F4551BD182Basket Master DetailFiles45: Advanced PricingBusiness Data
24920F45510SH121Search Agent Directives HeaderFiles45: Advanced PricingBusiness Data
25920F45511SD121Search Agent Directives DetailFiles45: Advanced PricingBusiness Data
26920F45511WSW111Search Agent Directives Work FileFiles45: Advanced PricingBusiness Data
27920F45520PH291Price List HeaderFiles45: Advanced PricingBusiness Data
28920F45520TXPT111Price List Header Tax TableFiles45: Advanced Pricing
29920F45521PD292Price List DetailFiles45: Advanced PricingBusiness Data
30920F45521TXLT101Price List Detail Tax TableFiles45: Advanced Pricing
31920F45522PL102Price List Level-Break PatternFiles45: Advanced PricingBusiness Data
32920F45523PC93Price List Columns Group PatternFiles45: Advanced PricingBusiness Data
33920F45524PI102Price List Item SelectionFiles45: Advanced PricingBusiness Data
34920F45715AB452Adjustment BalancesBalance Files45: Advanced PricingBusiness Data
35920F4572XR304Live Promotions X-Reference by Cost TypeFiles45: Advanced PricingBusiness Data
36920F4572Z1LP501Live Promotions Interface - Inbound / OutboundFiles45: Advanced PricingBusiness Data
37920F4572ZPPG501Purge Live Promotions InterfaceFiles45: Advanced PricingBusiness Data
38920F4573RF111Free Goods Reference FileTransaction Files45: Advanced PricingBusiness Data
39920F4574KR978Key Reference TableTransaction Files45: Advanced PricingBusiness Data
40920F4575AH831Ship and Debit HistoryTransaction Files45: Advanced PricingBusiness Data
41920F4575TMPAH851Ship and Debit History - Temp TableTransaction Files42: Sales ManagementBusiness Data
42920F4576AC881Ship and Debit ClaimsMaster Files45: Advanced PricingBusiness Data
43920F4576TMPAC881Ship and Debit Claims- Temp TableMaster Files42: Sales ManagementBusiness Data
44920F4576Z1Z11581Ship and Debit Claims Unedited Transaction TableTransaction Files45: Advanced PricingBusiness Data
45920F4580MX112Price Matrix DefinitionFiles45: Advanced Pricing