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

84 columns | Print definition?920 | PA8

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP01: Address Book
1F0101Z2Address Book - Interoperability111SZPA8Address Number - ParentNumericGeneric Edit80
2F0150Address Organization Structure Master2MAPA8Address Number - ParentNumericGeneric Edit80
TOP03: Accounts Receivable
3F0311Accounts Receivable Ledger19RPPA8Address Number - ParentNumericGeneric Edit80
TOP03B: Enhanced Accounts Receivable
4F03B11Customer Ledger17RPPA8Address Number - ParentNumericGeneric Edit80
5F03B112Invoice Revisions21RWPA8Address Number - ParentNumericGeneric Edit80
6F03B112PInvoice Revisions Purge File21RWPA8Address Number - ParentNumericGeneric Edit80
7F03B11PCustomer Ledger Purge File17RPPA8Address Number - ParentNumericGeneric Edit80
8F03B11Z1Batch Invoices35VJPA8Address Number - ParentNumericGeneric Edit80
9F03B11Z2F03B11 Interoperability Table30SYPA8Address Number - ParentNumericGeneric Edit80
10F03B13Receipts Header21RYPA8Address Number - ParentNumericGeneric Edit80
11F03B13PReceipts Header Purge File21RYPA8Address Number - ParentNumericGeneric Edit80
12F03B13Z2F03B13 Interoperability Table34SYPA8Address Number - ParentNumericGeneric Edit80
13F03B14Receipts Detail22RZPA8Address Number - ParentNumericGeneric Edit80
14F03B14PReceipts Detail Purge File22RZPA8Address Number - ParentNumericGeneric Edit80
15F03B14Z2F03B14 Interoperability Table35SZPA8Address Number - ParentNumericGeneric Edit80
16F03B15Credit and Cash Management5RTPA8Address Number - ParentNumericGeneric Edit80
17F03B22A/R Fee Journal History8RSPA8Address Number - ParentNumericGeneric Edit80
18F03B575Auto Debit Invoice Select and Build20RDPA8Address Number - ParentNumericGeneric Edit80
19F03B672Draft Remittance24RDPA8Address Number - ParentNumericGeneric Edit80
TOP05: Time Accounting and HRM Base
20F069086Payroll Corporate Tax Identification10YIPA8Address Number - ParentNumericGeneric Edit80
TOP07: Payroll
21F06720W-2/1099 Processing Control43JEPA8Address Number - ParentNumericGeneric Edit80
TOP12: Fixed Assets
22F1217Equipment Master Extension13WRPA8Address Number - ParentNumericGeneric Edit80
23F1217PEquipment Master Extension Purge Table13WRPA8Address Number - ParentNumericGeneric Edit80
24F1217Z1Unedited Equipment Tag Transactions26WRPA8Address Number - ParentNumericGeneric Edit80
25F1217Z2Unedited Equipment Tag Transactions26WRPA8Address Number - ParentNumericGeneric Edit80
TOP15: Real Estate Management
26F15525WPM Statements Credit/Cash Build Workfile5RTPA8Address Number - ParentNumericGeneric Edit80
TOP31P: Engineer To Order
27F31P01Project Attributes25PAPA8Address Number - ParentNumericGeneric Edit80
TOP40: Inventory/OP Base
28F4001ZBatch Receiver File - Order Headings38SYPA8Address Number - ParentNumericGeneric Edit80
29F4011ZBatch Receiver File - Order Details34SZPA8Address Number - ParentNumericGeneric Edit80
30F40300RPreference Resolution History - Master31PMPA8Address Number - ParentNumericGeneric Edit80
31F4201Z1Sales Order Header Unedited Transaction File28SYPA8Address Number - ParentNumericGeneric Edit80
32F4209Held Orders26HOPA8Address Number - ParentNumericGeneric Edit80
33F4211AUSales Order Detail Audit File15AUPA8Address Number - ParentNumericGeneric Edit80
34F4211Z1Sales Order Detail Unedited Transaction File33SZPA8Address Number - ParentNumericGeneric Edit80
TOP41: Inventory Management
35F41182Container Serial3CSPA8Address Number - ParentNumericGeneric Edit80
TOP42: Sales Management
36F4201Sales Order Header File15SHPA8Address Number - ParentNumericGeneric Edit80
37F42019Sales Order Header History File15SHPA8Address Number - ParentNumericGeneric Edit80
38F4211Sales Order Detail File20SDPA8Address Number - ParentNumericGeneric Edit80
39F42119Sales Order History File20SDPA8Address Number - ParentNumericGeneric Edit80
40F42199S.O. Detail Ledger File20SLPA8Address Number - ParentNumericGeneric Edit80
41F42565Invoice Print File77IWPA8Address Number - ParentNumericGeneric Edit80
42F42CSSCustomer Self Service Workfile7CSPA8Address Number - ParentNumericGeneric Edit80
43F42UI01SO Header Cache File (MBF)20ZHPA8Address Number - ParentNumericGeneric Edit80
44F42UI11SO Detail Cache File (MBF)24ZDPA8Address Number - ParentNumericGeneric Edit80
45F42UI521Pick Slips Detail File18S9PA8Address Number - ParentNumericGeneric Edit80
TOP45: Advanced Pricing
46F4576Z1Ship and Debit Claims Unedited Transaction Table134Z1PA8Address Number - ParentNumericGeneric Edit80
TOP47: Electronic Commerce
47F47011EDI Purchase Order Header - Inbound33SYPA8Address Number - ParentNumericGeneric Edit80
48F47012EDI Purchase Order Detail - Inbound34SZPA8Address Number - ParentNumericGeneric Edit80
49F47026EDI P.O. Acknowledgment Header - Outbound30SYPA8Address Number - ParentNumericGeneric Edit80
50F47027EDI P.O. Acknowledgment Detail - Outbound34SZPA8Address Number - ParentNumericGeneric Edit80
51F47037EDI Shipping Notice Detail - Outbound35SZPA8Address Number - ParentNumericGeneric Edit80
52F470371EDI Shipping Notice Detail - Outbound35SZPA8Address Number - ParentNumericGeneric Edit80
53F47041EDI Invoice Header - Inbound28SYPA8Address Number - ParentNumericGeneric Edit80
54F47046EDI Invoice Header (Sales) - Outbound30SYPA8Address Number - ParentNumericGeneric Edit80
55F47047EDI Invoice Detail (Sales) - Outbound34SZPA8Address Number - ParentNumericGeneric Edit80
56F47056WEDI Payment Order Header - Work27D1PA8Address Number - ParentNumericGeneric Edit80
57F47091EDI Request for Quote Header - Inbound33SYPA8Address Number - ParentNumericGeneric Edit80
58F47092EDI Request for Quote Detail - Inbound34SZPA8Address Number - ParentNumericGeneric Edit80
59F47106EDI Response to RFQ Header - Outbound30SYPA8Address Number - ParentNumericGeneric Edit80
60F47107EDI Response to RFQ Detail - Outbound34SZPA8Address Number - ParentNumericGeneric Edit80
61F47131EDI Purchase Order Change Header - Inbound30SYPA8Address Number - ParentNumericGeneric Edit80
62F47132EDI Purchase Order Change Detail - Inbound35SZPA8Address Number - ParentNumericGeneric Edit80
63F47146EDI P.O. Change Acknowledgment Header - Outbound31SYPA8Address Number - ParentNumericGeneric Edit80
64F47147EDI P.O. Change Acknowledgment Detail - Outbound36SZPA8Address Number - ParentNumericGeneric Edit80
TOP49: Transportation Management
65F49T50Order Release Location Staging7LOPA8Address Number - ParentNumericGeneric Edit80
66F49T70Corporations Staging Table1CSPA8Address Number - ParentNumericGeneric Edit80
67F49T80Locations Staging Table5LCPA8Address Number - ParentNumericGeneric Edit80
TOP54HS: Health & Safety Incident Mgt
68F54HS05Incident Notification Members4S6PA8Address Number - ParentNumericGeneric Edit80
69F54HS05HIncident Notifications Sent6I6PA8Address Number - ParentNumericGeneric Edit80
TOP54R: Rental Management
70F54R099Rental Contract Header Ledger14HLPA8Address Number - ParentNumericGeneric Edit80
71F54R10Rental Contract Header12CHPA8Address Number - ParentNumericGeneric Edit80
72F54R11Rental Contract Detail49CDPA8Address Number - ParentNumericGeneric Edit80
73F54R199Rental Contract Detail Ledger45DLPA8Address Number - ParentNumericGeneric Edit80
TOP74: EMEA Localization
74F74412Customer / Supplier Balance Worktable (A/P and A/R)7RPPA8Address Number - ParentNumericGeneric Edit80
75F74900Foreign Receivables and Payables - EMEA23RPPA8Address Number - ParentNumericGeneric Edit80
TOP75T: Taiwan
76F75T42WWork file with union of F4211 and F421199SWPA8Address Number - ParentNumericGeneric Edit80
TOP76C: Colombia
77F76C031AA/R Customer ledger As Of - F76C031A - COL - 0417RPPA8Address Number - ParentNumericGeneric Edit80
78F76C034AA/R Check Detail file As Of - COL - 03B22RZPA8Address Number - ParentNumericGeneric Edit80
TOP90CA: CRM Foundation
79F90CA042Flat Employee Hierarchy2EMPA8Address Number - ParentNumericGeneric Edit80
TOPH90: EnterpriseOne TOOLS
80F01131PPAT Message Control File14ZZPA8Address Number - ParentNumericGeneric Edit80
81F01131MJDEM Multi Level Message7ZMPA8Address Number - ParentNumericGeneric Edit80
82F01136JDEM Mail Filters1ZPPA8Address Number - ParentNumericGeneric Edit80
83F98840Organizational Structure Master15OMPA8Address Number - ParentNumericGeneric Edit80
84F98840NOrganizational Structure Master - Net Change3OMPA8Address Number - ParentNumericGeneric Edit80