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

61 columns | Print definition?920 | FRMP

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP17: Customer Service Management
1F3111Z2Warranty Claim/Supplier Recovery processing23WPFRMPFrom PotencyNumericGeneric Edit73
TOP30: Product Data Management
2F300211Lean Multi Level Bill of Material Detail46EDFRMPFrom PotencyNumericGeneric Edit73
3F3002Z1Bill of Material Transaction File45SZFRMPFrom PotencyNumericGeneric Edit73
TOP31: Shop Floor Control
4F3111Work Order Parts List10WMFRMPFrom PotencyNumericGeneric Edit73
5F3111SPurge - Shop Floor Parts List10WMFRMPFrom PotencyNumericGeneric Edit73
6F3111Z1Outbound Work Order Parts List23SZFRMPFrom PotencyNumericGeneric Edit73
TOP40: Inventory/OP Base
7F3002Bill of Material Master File32IXFRMPFrom PotencyNumericGeneric Edit73
8F3011Bill of Materials Change File32IZFRMPFrom PotencyNumericGeneric Edit73
9F3013ECO Parts List Detail38CYFRMPFrom PotencyNumericGeneric Edit73
10F30UI004Bill of Material Update Work File58WFFRMPFrom PotencyNumericGeneric Edit73
11F4011ZBatch Receiver File - Order Details56SZFRMPFrom PotencyNumericGeneric Edit73
12F40308Preference Profile - Grade and Potency14GSFRMPFrom PotencyNumericGeneric Edit73
13F40308RPreference Resolution Ledger - Grade and Potency16GSFRMPFrom PotencyNumericGeneric Edit73
14F4106Item Base Price File11BPFRMPFrom PotencyNumericGeneric Edit73
15F4211Z1Sales Order Detail Unedited Transaction File53SZFRMPFrom PotencyNumericGeneric Edit73
TOP41: Inventory Management
16F4101Item Master66IMFRMPFrom PotencyNumericGeneric Edit73
17F4101MItem Manufacturing Data37IMFRMPFrom PotencyNumericGeneric Edit73
18F4101Z1F4101 Item Master Unedited Transaction Table81SZFRMPFrom PotencyNumericGeneric Edit73
19F4102Item Branch File47IBFRMPFrom PotencyNumericGeneric Edit73
20F41UI001Inventory Transactions Detail File108ITFRMPFrom PotencyNumericGeneric Edit73
TOP41F: Apparel Management
21FCW10Item Branch Work File78WBFRMPFrom PotencyNumericGeneric Edit73
22FCW11Item Base Price File Work File10WPFRMPFrom PotencyNumericGeneric Edit73
23FCW57Work File Additional System Information (F4101)28WFFRMPFrom PotencyNumericGeneric Edit73
24FCW67Style Work Order Parts List16WMFRMPFrom PotencyNumericGeneric Edit73
TOP42: Sales Management
25F4211Sales Order Detail File40SDFRMPFrom PotencyNumericGeneric Edit73
26F42119Sales Order History File40SDFRMPFrom PotencyNumericGeneric Edit73
27F42199S.O. Detail Ledger File40SLFRMPFrom PotencyNumericGeneric Edit73
28F42UI12Sales Order Detail Cache 2 (MBF)13ZDFRMPFrom PotencyNumericGeneric Edit73
29F42UI130Commitment Work File50ZCFRMPFrom PotencyNumericGeneric Edit73
30F42UI521Pick Slips Detail File35S9FRMPFrom PotencyNumericGeneric Edit73
TOP43: Procurement
31F43080Approvals Fields Constants50PDFRMPFrom PotencyNumericGeneric Edit73
32F4311Purchase Order Detail File42PDFRMPFrom PotencyNumericGeneric Edit73
33F4311ZPurchase Order Generator File46PWFRMPFrom PotencyNumericGeneric Edit73
34F4311Z1Purchase Order Detail Unedited Transaction Table55SZFRMPFrom PotencyNumericGeneric Edit73
35F43199P.O. Detail Ledger File - Flexible Version42OLFRMPFrom PotencyNumericGeneric Edit73
36F43UI50DPO Print Detail Work File32PWFRMPFrom PotencyNumericGeneric Edit73
TOP45: Advanced Pricing
37F4574Key Reference Table12KRFRMPFrom PotencyNumericGeneric Edit73
TOP46: Warehouse Management
38F4600Warehouse Requests37R1FRMPFrom PotencyNumericGeneric Edit73
39F4600PUWarehouse Requests - Purged35R1FRMPFrom PotencyNumericGeneric Edit73
TOP47: Electronic Commerce
40F47012EDI Purchase Order Detail - Inbound57SZFRMPFrom PotencyNumericGeneric Edit73
41F47017EDI Purchase Order Detail - Outbound56SZFRMPFrom PotencyNumericGeneric Edit73
42F47022EDI P.O. Acknowledgment Detail - Inbound56SZFRMPFrom PotencyNumericGeneric Edit73
43F47027EDI P.O. Acknowledgment Detail - Outbound57SZFRMPFrom PotencyNumericGeneric Edit73
44F47037EDI Shipping Notice Detail - Outbound57SZFRMPFrom PotencyNumericGeneric Edit73
45F470371EDI Shipping Notice Detail - Outbound64SZFRMPFrom PotencyNumericGeneric Edit73
46F47042EDI Invoice Detail - Inbound40SZFRMPFrom PotencyNumericGeneric Edit73
47F47047EDI Invoice Detail (Sales) - Outbound57SZFRMPFrom PotencyNumericGeneric Edit73
48F47072EDI Receiving Advice Detail - Inbound57SZFRMPFrom PotencyNumericGeneric Edit73
49F47077EDI Receiving Advice Detail - Outbound57SZFRMPFrom PotencyNumericGeneric Edit73
50F47082EDI Price Sales Catalog Detail - Inbound48FYFRMPFrom PotencyNumericGeneric Edit73
51F47092EDI Request for Quote Detail - Inbound57SZFRMPFrom PotencyNumericGeneric Edit73
52F47097EDI Request for Quote Detail - Outbound56SZFRMPFrom PotencyNumericGeneric Edit73
53F47102EDI Response to RFQ Detail - Inbound56SZFRMPFrom PotencyNumericGeneric Edit73
54F47107EDI Response to RFQ Detail - Outbound57SZFRMPFrom PotencyNumericGeneric Edit73
55F47132EDI Purchase Order Change Detail - Inbound58SZFRMPFrom PotencyNumericGeneric Edit73
56F47137EDI Purchase Order Change Detail - Outbound57SZFRMPFrom PotencyNumericGeneric Edit73
57F47142EDI P.O. Change Acknowledgment Detail - Inbound58SZFRMPFrom PotencyNumericGeneric Edit73
58F47147EDI P.O. Change Acknowledgment Detail - Outbound59SZFRMPFrom PotencyNumericGeneric Edit73
59F47157EDI Shipping Schedule Detail - Outbound59SZFRMPFrom PotencyNumericGeneric Edit73
TOP89: Conversion Programs
60F43199ATemp F43199 for ERP 9.0 Upgrade42OLFRMPFrom PotencyNumericGeneric Edit73
TOPF30L: DFM Line Design
61FF30L002DFM Bill of Material Master26DHFRMPFrom PotencyNumericGeneric Edit73