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

37 columns | Print definition?910 | BQTY

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP17C: Call Management
1F1790Product Family/Model Master13PMBQTYUnits - Batch QuantityNumericGeneric Edit152
TOP30: Product Data Management
2F3002Z1Bill of Material Transaction File28SZBQTYUnits - Batch QuantityNumericGeneric Edit152
3F300311Lean Multi-Level Routing Detail File15EHBQTYUnits - Batch QuantityNumericGeneric Edit152
4F3003TRouting Tag File - not used in B9 - obsolete in B107IRBQTYUnits - Batch QuantityNumericGeneric Edit152
5F3003Z1Routing Transactions File30SZBQTYUnits - Batch QuantityNumericGeneric Edit152
6F30UI014BOM Header Work File for BI3BHBQTYUnits - Batch QuantityNumericGeneric Edit152
7F30UI015BOM Item Fact Work File for BI5BDBQTYUnits - Batch QuantityNumericGeneric Edit152
8F30UI016BOM Explosion Work File for BI4BEBQTYUnits - Batch QuantityNumericGeneric Edit152
TOP30A: Product Costing
9F30UI011Work File for Cost Component8CCBQTYUnits - Batch QuantityNumericGeneric Edit152
10F30UI012Work File for Parent Child10PCBQTYUnits - Batch QuantityNumericGeneric Edit152
TOP34A: Advanced Planning & Scheduling
11F34A120Routing Master Resource Table7N0BQTYUnits - Batch QuantityNumericGeneric Edit152
12F34A180Routing Master Resource Set7RRBQTYUnits - Batch QuantityNumericGeneric Edit152
13F34A190Routing Master Resource and Set XRef7RDBQTYUnits - Batch QuantityNumericGeneric Edit152
14F34A90Last Outbound Phantom Information8PIBQTYUnits - Batch QuantityNumericGeneric Edit152
TOP40: Inventory/OP Base
15F3002Bill of Material Master File15IXBQTYUnits - Batch QuantityNumericGeneric Edit152
16F3003Routing Master File17IRBQTYUnits - Batch QuantityNumericGeneric Edit152
17F3011Bill of Materials Change File15IZBQTYUnits - Batch QuantityNumericGeneric Edit152
18F3013ECO Parts List Detail12CYBQTYUnits - Batch QuantityNumericGeneric Edit152
19F30UI002Bill of Material Structure Analysis Work File8IXBQTYUnits - Batch QuantityNumericGeneric Edit152
20F30UI004Bill of Material Update Work File15WFBQTYUnits - Batch QuantityNumericGeneric Edit152
TOP41: Inventory Management
21F4101AItem File83IMBQTYUnits - Batch QuantityNumericGeneric Edit152
22F4101Z1F4101 Item Master Unedited Transaction Table180SZBQTYUnits - Batch QuantityNumericGeneric Edit152
23F4102Item Branch File110IBBQTYUnits - Batch QuantityNumericGeneric Edit152
TOP41F: Apparel Management
24FCW48Bill of Material Association Header4BHBQTYUnits - Batch QuantityNumericGeneric Edit152
25FCW49Bill of Material Association Detail4BDBQTYUnits - Batch QuantityNumericGeneric Edit152
26FCW50Bill of Material Association Matrix4BXBQTYUnits - Batch QuantityNumericGeneric Edit152
27FCW51BOM Usage4BUBQTYUnits - Batch QuantityNumericGeneric Edit152
28FCW52Style Routing Master File4RCBQTYUnits - Batch QuantityNumericGeneric Edit152
29FCW86BOM Quantity Work File5WFBQTYUnits - Batch QuantityNumericGeneric Edit152
TOP75I: India
30F75I395BER - 5 (2)18ERBQTYUnits - Batch QuantityNumericGeneric Edit152
31F75I395TER - 5 (temp)19ERBQTYUnits - Batch QuantityNumericGeneric Edit152
32F75I396BER-622SEBQTYUnits - Batch QuantityNumericGeneric Edit152
33F75I396TER-6 Temp21SEBQTYUnits - Batch QuantityNumericGeneric Edit152
TOP76B: Brazil - Reporting System Only
34F76B3010Work Table for Item/Part List - 3015IPBQTYUnits - Batch QuantityNumericGeneric Edit152
TOPF30L: DFM Line Design
35FF30L002DFM Bill of Material Master11DHBQTYUnits - Batch QuantityNumericGeneric Edit152
36FF30L501DFM Item Definition Master74IBBQTYUnits - Batch QuantityNumericGeneric Edit152
37FF30L930DFM Routings16LRBQTYUnits - Batch QuantityNumericGeneric Edit152