JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

43 tables812 | 45

45: Advanced Pricing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F4070SN228Price Adjustment ScheduleMaster Files45: Advanced PricingAS400 Coexistence Tables
2812F4070PSNPrice Adjustment Schedule PurgeMaster Files45: Advanced PricingBusiness Data
3812F4071AT622Price Adjustment TypeMaster Files45: Advanced PricingAS400 Coexistence Tables
4812F4071PATPrice Adjustment Type PurgeMaster Files45: Advanced PricingBusiness Data
5812F4072AD377Price Adjustment DetailMaster Files45: Advanced PricingAS400 Coexistence Tables
6812F4072PADPrice Adjustment Detail PurgeMaster Files45: Advanced PricingBusiness Data
7812F4072WAD402Price Adjustment Detail Work FileMaster Files45: Advanced PricingBusiness Data
8812F4073FG233Free Goods Master FileMaster Files45: Advanced PricingAS400 Coexistence Tables
9812F4073PFGFree Goods Master File PurgeMaster Files45: Advanced PricingBusiness Data
10812F4075VB123Price Variable TableMaster Files45: Advanced PricingAS400 Coexistence Tables
11812F4076FM83Price Formula MasterMaster Files45: Advanced PricingAS400 Coexistence Tables
12812F4077RT315Rebate ThresholdsMaster Files45: Advanced PricingAS400 Coexistence Tables
13812F4077PRTRebate Thresholds PurgeMaster Files45: Advanced PricingBusiness Data
14812F4078RH332Rebate Transaction SummaryTransaction Files45: Advanced PricingAS400 Coexistence Tables
15812F4079SV365Rebate Transaction DetailTransaction Files45: Advanced PricingAS400 Coexistence Tables
16812F4094TEMTC133ICID Conversion X-RefFiles45: Advanced PricingBusiness Data
17812F40UI84XR71Orders Affected by Price Change (Work-file)Work Files45: Advanced PricingNo
18812F4501MS142Master Schedule AdjustmentMaster Files45: Advanced PricingNo
19812F4502FG131Free Goods CatalogFiles45: Advanced PricingBusiness Data
20812F4510PW166Price Workbench Query HeaderFiles45: Advanced Pricing
21812F4511WAP996Pricing Structure ViewFiles45: Advanced PricingBusiness Data
22812F4550BH131Basket Master HeaderFiles45: Advanced PricingBusiness Data
23812F4551BD182Basket Master DetailFiles45: Advanced PricingBusiness Data
24812F45510SH121Search Agent Directives HeaderFiles45: Advanced PricingBusiness Data
25812F45511SD121Search Agent Directives DetailFiles45: Advanced PricingBusiness Data
26812F45511WSW111Search Agent Directives Work FileFiles45: Advanced PricingBusiness Data
27812F45520PH291Price List HeaderFiles45: Advanced PricingBusiness Data
28812F45521PD292Price List DetailFiles45: Advanced PricingBusiness Data
29812F45522PL102Price List Level-Break PatternFiles45: Advanced PricingBusiness Data
30812F45523PC93Price List Columns Group PatternFiles45: Advanced PricingBusiness Data
31812F45524PI102Price List Item SelectionFiles45: Advanced PricingBusiness Data
32812F45715AB452Adjustment BalancesBalance Files45: Advanced PricingNo
33812F4572XR304Live Promotions X-Reference by Cost TypeFiles45: Advanced PricingNo
34812F4572Z1LP501Live Promotions Interface - Inbound / OutboundFiles45: Advanced PricingNo
35812F4572ZPPG501Purge Live Promotions InterfaceFiles45: Advanced PricingNo
36812F4573RF111Free Goods Reference FileTransaction Files45: Advanced PricingAS400 Coexistence Tables
37812F4574KR978Key Reference TableTransaction Files45: Advanced PricingNo
38812F4575AH831Ship and Debit HistoryTransaction Files45: Advanced PricingNo
39812F4575TMPAH851Ship and Debit History - Temp TableTransaction Files42: Sales ManagementBusiness Data
40812F4576AC881Ship and Debit ClaimsMaster Files45: Advanced PricingNo
41812F4576TMPAC881Ship and Debit Claims- Temp TableMaster Files42: Sales ManagementBusiness Data
42812F4576Z1Z11581Ship and Debit Claims Unedited Transaction TableTransaction Files45: Advanced PricingNo
43812F4580MX112Price Matrix DefinitionFiles45: Advanced Pricing