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
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

38 columns | Print definition?920 | SERK

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0040Z1Error Message Log Table6ZBSERKKey Value Serial NumberNumericGeneric Edit150
2F0041Z1Transaction Control File7ZFSERKKey Value Serial NumberNumericGeneric Edit150
TOP02: Electronic Mail
3F01132PPAT Message Text File1CYSERKKey Value Serial NumberNumericGeneric Edit150
TOP03B: Enhanced Accounts Receivable
4F03B20A/R Notification History53ZRSERKKey Value Serial NumberNumericGeneric Edit150
5F03B22A/R Fee Journal History21RSSERKKey Value Serial NumberNumericGeneric Edit150
TOP05: Time Accounting and HRM Base
6F05102Goal Master10SMSERKKey Value Serial NumberNumericGeneric Edit150
TOP05A: PeopleSoft HR & PR Foundation
7F05842Employee/Supervisor Approval History12ATSERKKey Value Serial NumberNumericGeneric Edit150
8F060120Employee Master Additional Information File25YASERKKey Value Serial NumberNumericGeneric Edit150
TOP08: Human Resources
9F087711CBPA Appraisal Header43XJSERKKey Value Serial NumberNumericGeneric Edit150
10F087711ACBPA Appraisal Header Tag Table5XJSERKKey Value Serial NumberNumericGeneric Edit150
11F087711BPerformance Appraisal Header Template Keys1XKSERKKey Value Serial NumberNumericGeneric Edit150
12F087715CBPA Diary Table10XMSERKKey Value Serial NumberNumericGeneric Edit150
13F087721CBPA Appraisal Creation Work File12XPSERKKey Value Serial NumberNumericGeneric Edit150
TOP10: Financial Reporting
14F1002Multi-Site Consolidation Transfer File5GQSERKKey Value Serial NumberNumericGeneric Edit150
15F1002Z1Unedited MSC Interoperability Table14SZSERKKey Value Serial NumberNumericGeneric Edit150
16F1017Consolidation Specifications2CSSERKKey Value Serial NumberNumericGeneric Edit150
17F10470Consolidation Specifications (OW)2CSSERKKey Value Serial NumberNumericGeneric Edit150
18F10471Elimination Rules (OW)2ERSERKKey Value Serial NumberNumericGeneric Edit150
19F10UI006MSC - F1002 Elimination Work File4GESERKKey Value Serial NumberNumericGeneric Edit150
TOP17C: Call Management
20F1755Case Master13ZASERKKey Value Serial NumberNumericGeneric Edit150
21F1757Task Master22ZASERKKey Value Serial NumberNumericGeneric Edit150
TOP41: Inventory Management
22F4101AItem File8IMSERKKey Value Serial NumberNumericGeneric Edit150
23F4101BItem Master Bulk Data8IMSERKKey Value Serial NumberNumericGeneric Edit150
24F4101CItem Category Codes8IMSERKKey Value Serial NumberNumericGeneric Edit150
25F4101FItem Customer Service Data8IMSERKKey Value Serial NumberNumericGeneric Edit150
26F4101GItem Branch Quantities8IBSERKKey Value Serial NumberNumericGeneric Edit150
27F4101MItem Manufacturing Data8IMSERKKey Value Serial NumberNumericGeneric Edit150
28F4101PItem Master Packaging8IMSERKKey Value Serial NumberNumericGeneric Edit150
29F4101SItem Master Shipping Data8IMSERKKey Value Serial NumberNumericGeneric Edit150
30F4101WItem Profile Data8IMSERKKey Value Serial NumberNumericGeneric Edit150
TOP43E: Requisition Self Service
31F43E09F43E09 - Approvals Activity Table1AASERKKey Value Serial NumberNumericGeneric Edit150
TOP89: Conversion Programs
32F0086Conversion Audit File for Euro Conversion1AUSERKKey Value Serial NumberNumericGeneric Edit150
TOPH90: EnterpriseOne TOOLS
33F01131PPAT Message Control File1ZZSERKKey Value Serial NumberNumericGeneric Edit150
34F01131MJDEM Multi Level Message2ZMSERKKey Value Serial NumberNumericGeneric Edit150
35F01131TMessage Attachment Tag File1ZCSERKKey Value Serial NumberNumericGeneric Edit150
36F01133PPAT Message Detail File1ZTSERKKey Value Serial NumberNumericGeneric Edit150
37F1761Electronic Help JDE Request Log24ZASERKKey Value Serial NumberNumericGeneric Edit150
TOPH95: Object and Environment Tech
38F00166Media Object Categories83GTSERKKey Value Serial NumberNumericGeneric Edit150