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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

64 columns | Print definition?920 | CPNT

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP17: Customer Service Management
1F3111Z2Warranty Claim/Supplier Recovery processing22WPCPNTComponent Line NumberNumericGeneric Edit41
TOP17C: Call Management
2F1790Product Family/Model Master14PMCPNTComponent Line NumberNumericGeneric Edit41
TOP30: Product Data Management
3F300211Lean Multi Level Bill of Material Detail14EDCPNTComponent Line NumberNumericGeneric Edit41
4F3002Z1Bill of Material Transaction File23SZCPNTComponent Line NumberNumericGeneric Edit41
TOP31: Shop Floor Control
5F3111Work Order Parts List9WMCPNTComponent Line NumberNumericGeneric Edit41
6F3111SPurge - Shop Floor Parts List9WMCPNTComponent Line NumberNumericGeneric Edit41
7F3111Z1Outbound Work Order Parts List22SZCPNTComponent Line NumberNumericGeneric Edit41
TOP40: Inventory/OP Base
8F3002Bill of Material Master File10IXCPNTComponent Line NumberNumericGeneric Edit41
9F3011Bill of Materials Change File10IZCPNTComponent Line NumberNumericGeneric Edit41
10F3013ECO Parts List Detail14CYCPNTComponent Line NumberNumericGeneric Edit41
11F3015Component Locator File3CQCPNTComponent Line NumberNumericGeneric Edit41
12F30UI002Bill of Material Structure Analysis Work File11IXCPNTComponent Line NumberNumericGeneric Edit41
13F30UI004Bill of Material Update Work File19WFCPNTComponent Line NumberNumericGeneric Edit41
14F4011ZBatch Receiver File - Order Details67SZCPNTComponent Line NumberNumericGeneric Edit41
15F4013ZKit Components Batch File6KSCPNTComponent Line NumberNumericGeneric Edit41
16F4211Z1Sales Order Detail Unedited Transaction File64SZCPNTComponent Line NumberNumericGeneric Edit41
TOP41F: Apparel Management
17FCW49Bill of Material Association Detail8BDCPNTComponent Line NumberNumericGeneric Edit41
18FCW50Bill of Material Association Matrix6BXCPNTComponent Line NumberNumericGeneric Edit41
19FCW51BOM Usage8BUCPNTComponent Line NumberNumericGeneric Edit41
20FCW67Style Work Order Parts List15WMCPNTComponent Line NumberNumericGeneric Edit41
21FCW86BOM Quantity Work File6WFCPNTComponent Line NumberNumericGeneric Edit41
22FCW89Work Order Inventory Issues for Style Items6WMCPNTComponent Line NumberNumericGeneric Edit41
23FCW961Simulation Detailed Parts List8DLCPNTComponent Line NumberNumericGeneric Edit41
TOP42: Sales Management
24F4211Sales Order Detail File51SDCPNTComponent Line NumberNumericGeneric Edit41
25F42119Sales Order History File51SDCPNTComponent Line NumberNumericGeneric Edit41
26F42199S.O. Detail Ledger File51SLCPNTComponent Line NumberNumericGeneric Edit41
27F42UI11SO Detail Cache File (MBF)49ZDCPNTComponent Line NumberNumericGeneric Edit41
28F42UI521Pick Slips Detail File47S9CPNTComponent Line NumberNumericGeneric Edit41
TOP42I: Outbound Inventory Management
29F42I011Outbound Inventory Agreement Details33OQCPNTComponent Line NumberNumericGeneric Edit41
30F42I015Outbound Inventory Agreement Transaction File42OICPNTComponent Line NumberNumericGeneric Edit41
31F42I02Outbound Inventory Agreement Acknowledge48OICPNTComponent Line NumberNumericGeneric Edit41
TOP43: Procurement
32F4311Purchase Order Detail File201PDCPNTComponent Line NumberNumericGeneric Edit41
33F4311Z1Purchase Order Detail Unedited Transaction Table218SZCPNTComponent Line NumberNumericGeneric Edit41
34F43121Purchase Order Receiver File127PRCPNTComponent Line NumberNumericGeneric Edit41
35F43121ZReceiver workfile163PWCPNTComponent Line NumberNumericGeneric Edit41
36F43121Z1Receipts Unedited Transaction Table195SZCPNTComponent Line NumberNumericGeneric Edit41
37F43199P.O. Detail Ledger File - Flexible Version201OLCPNTComponent Line NumberNumericGeneric Edit41
TOP45: Advanced Pricing
38F4576Z1Ship and Debit Claims Unedited Transaction Table140Z1CPNTComponent Line NumberNumericGeneric Edit41
TOP46: Warehouse Management
39F4600Warehouse Requests22R1CPNTComponent Line NumberNumericGeneric Edit41
40F4600PUWarehouse Requests - Purged22R1CPNTComponent Line NumberNumericGeneric Edit41
41F4611Warehouse Suggestions72R2CPNTComponent Line NumberNumericGeneric Edit41
42F4611PUWarehouse Suggestions - Purged71R2CPNTComponent Line NumberNumericGeneric Edit41
43F4611Z1Unedited Suggestion Table163SZCPNTComponent Line NumberNumericGeneric Edit41
TOP47: Electronic Commerce
44F47012EDI Purchase Order Detail - Inbound68SZCPNTComponent Line NumberNumericGeneric Edit41
45F47017EDI Purchase Order Detail - Outbound212SZCPNTComponent Line NumberNumericGeneric Edit41
46F47022EDI P.O. Acknowledgment Detail - Inbound213SZCPNTComponent Line NumberNumericGeneric Edit41
47F47027EDI P.O. Acknowledgment Detail - Outbound68SZCPNTComponent Line NumberNumericGeneric Edit41
48F47032TEDI Shipping Notice Detail- Inbound Tag10SZCPNTComponent Line NumberNumericGeneric Edit41
49F47037EDI Shipping Notice Detail - Outbound68SZCPNTComponent Line NumberNumericGeneric Edit41
50F470371EDI Shipping Notice Detail - Outbound78SZCPNTComponent Line NumberNumericGeneric Edit41
51F47047EDI Invoice Detail (Sales) - Outbound68SZCPNTComponent Line NumberNumericGeneric Edit41
52F47072EDI Receiving Advice Detail - Inbound204SZCPNTComponent Line NumberNumericGeneric Edit41
53F47077EDI Receiving Advice Detail - Outbound204SZCPNTComponent Line NumberNumericGeneric Edit41
54F47092EDI Request for Quote Detail - Inbound68SZCPNTComponent Line NumberNumericGeneric Edit41
55F47097EDI Request for Quote Detail - Outbound213SZCPNTComponent Line NumberNumericGeneric Edit41
56F47102EDI Response to RFQ Detail - Inbound213SZCPNTComponent Line NumberNumericGeneric Edit41
57F47107EDI Response to RFQ Detail - Outbound68SZCPNTComponent Line NumberNumericGeneric Edit41
58F47132EDI Purchase Order Change Detail - Inbound69SZCPNTComponent Line NumberNumericGeneric Edit41
59F47142EDI P.O. Change Acknowledgment Detail - Inbound214SZCPNTComponent Line NumberNumericGeneric Edit41
60F47147EDI P.O. Change Acknowledgment Detail - Outbound70SZCPNTComponent Line NumberNumericGeneric Edit41
61F47157EDI Shipping Schedule Detail - Outbound69SZCPNTComponent Line NumberNumericGeneric Edit41
TOP54R: Rental Management
62F54R11Rental Contract Detail29CDCPNTComponent Line NumberNumericGeneric Edit41
63F54R199Rental Contract Detail Ledger25DLCPNTComponent Line NumberNumericGeneric Edit41
TOPF30L: DFM Line Design
64FF30L002DFM Bill of Material Master6DHCPNTComponent Line NumberNumericGeneric Edit41