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
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

81 columns | Print definition?812 | PA8

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP01: Address Book
1F0101Z2Address Book - Interoperability111SZPA8Address Number - ParentNumericGeneric Edit80
2F0150Address Organization Structure Master File - OSTP - PA8 - AN82MAPA8Address 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
8F03B11Z1Invoice Transactions - Batch File35VJPA8Address Number - ParentNumericGeneric Edit80
9F03B11Z2F03B11 Interoperability Table30SYPA8Address Number - ParentNumericGeneric Edit80
10F03B13Receipts Header File21RYPA8Address Number - ParentNumericGeneric Edit80
11F03B13PReceipts Header Purge File21RYPA8Address Number - ParentNumericGeneric Edit80
12F03B13Z2F03B13 Interoperability Table34SYPA8Address Number - ParentNumericGeneric Edit80
13F03B14A/R Check Detail File22RZPA8Address 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 Remittance Work File - One World Only24RDPA8Address 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: Property 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
TOP55: Reserved for Clients
65F55IF311As Of101RPPA8Address Number - ParentNumericGeneric Edit80
66F55IF421Sales Order per BO21SDPA8Address Number - ParentNumericGeneric Edit80
67F55IF425Sales Order per BO - 200521SDPA8Address Number - ParentNumericGeneric Edit80
68F55IFCCHCredit Check Info3X1PA8Address Number - ParentNumericGeneric Edit80
69F55IFSCHCust / Supp Balance Workfile - Copia estesa di F744125RPPA8Address Number - ParentNumericGeneric Edit80
70F55W0100Correction Invoice Print - WF121SDPA8Address Number - ParentNumericGeneric Edit80
71F59BF001B Formlar? Tablosu8BFPA8Address Number - ParentNumericGeneric Edit80
TOP74: EMEA Localization
72F74412Customer / Supplier Balance Workfile (A/R and A/P)7RPPA8Address Number - ParentNumericGeneric Edit80
73F74900Foreign Receivables and Payables - EMEA23RPPA8Address Number - ParentNumericGeneric Edit80
TOP76C: Colombia
74F76C031AA/R Customer ledger As Of - F76C031A - COL - 0417RPPA8Address Number - ParentNumericGeneric Edit80
75F76C034AA/R Check Detail file As Of - COL - 76C22RZPA8Address Number - ParentNumericGeneric Edit80
TOP90CA: CRM Foundation
76F90CA042Flat Employee Hierarchy2EMPA8Address Number - ParentNumericGeneric Edit80
TOPH90: ONEWORLD TOOLS
77F01131PPAT Message Control File14ZZPA8Address Number - ParentNumericGeneric Edit80
78F01131MJDEM Multi Level Message7ZMPA8Address Number - ParentNumericGeneric Edit80
79F01136JDEM Mail Filters1ZPPA8Address Number - ParentNumericGeneric Edit80
80F98840Organizational Structure Master15OMPA8Address Number - ParentNumericGeneric Edit80
81F98840NOrganizational Structure Master - Net Change3OMPA8Address Number - ParentNumericGeneric Edit80