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

157 columns | Print definition?920 | VERS

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00091Supplemental Database Data Types28T2VERSVersion HistoryStringGeneric Edit100
2F0046Processing Log9PLVERSVersion HistoryStringGeneric Edit100
3F0047Data Export Control5DEVERSVersion HistoryStringGeneric Edit100
4F0095Integration Timestamp2ITVERSVersion HistoryStringGeneric Edit100
5F80D306Action Definition5HDVERSVersion HistoryStringGeneric Edit100
TOP01: Address Book
6F01090Supplemental Database - Core14A1VERSVersion HistoryStringGeneric Edit100
TOP03B: Enhanced Accounts Receivable
7F007101Text Processor Header6TAVERSVersion HistoryStringGeneric Edit100
8F03B13Receipts Header65RYVERSVersion HistoryStringGeneric Edit100
9F03B13PReceipts Header Purge File65RYVERSVersion HistoryStringGeneric Edit100
10F03B13Z2F03B13 Interoperability Table78SYVERSVersion HistoryStringGeneric Edit100
11F03B50Receipt Application Algorithm Execution Lists5REVERSVersion HistoryStringGeneric Edit100
12F03B672Draft Remittance3RDVERSVersion HistoryStringGeneric Edit100
13F03B67OWDrafts Standard Formatted Tape File3REVERSVersion HistoryStringGeneric Edit100
TOP04: Accounts Payable
14F04571A/P Payment Processing - Header3KHVERSVersion HistoryStringGeneric Edit100
TOP05: Time Accounting and HRM Base
15F05400Self-Service Process Flow Settings11PFVERSVersion HistoryStringGeneric Edit100
16F06005Batch Processing Parameters1JEVERSVersion HistoryStringGeneric Edit100
TOP05T: Time Entry
17F06278Retro Timecard Detail File1YTVERSVersion HistoryStringGeneric Edit100
TOP06: Payroll (old) - Obsolete-do not reuse
18F06210Payroll Cycle Parameters2YDVERSVersion HistoryStringGeneric Edit100
TOP07: Payroll
19F06270Retro Processing Parameter1JPVERSVersion HistoryStringGeneric Edit100
20F06271Retro Processing Selection1JQVERSVersion HistoryStringGeneric Edit100
21F06720W-2/1099 Processing Control1JEVERSVersion HistoryStringGeneric Edit100
22F068500941 - Federal Tax History10YZVERSVersion HistoryStringGeneric Edit100
23F0717ROE Summary History49JFVERSVersion HistoryStringGeneric Edit100
24F07210Pay Cycle Parameters File29YDVERSVersion HistoryStringGeneric Edit100
25F07235Auto Deposit Bank Workfile3Y6VERSVersion HistoryStringGeneric Edit100
26F07400New Hire Detail File - Common Format2NHVERSVersion HistoryStringGeneric Edit100
27F07415New Hire Detail File - Indiana2NHVERSVersion HistoryStringGeneric Edit100
28F07436New Hire Detail File - Ohio3NHVERSVersion HistoryStringGeneric Edit100
29F07439New Hire Detail File - Pennsylvania3NHVERSVersion HistoryStringGeneric Edit100
30F07440New Hire Detail File - Rhode Island3NHVERSVersion HistoryStringGeneric Edit100
31F07810Year-End Control Table5JEVERSVersion HistoryStringGeneric Edit100
32F078303Arizona SUI magnetic media table (03)3YFVERSVersion HistoryStringGeneric Edit100
33F078305California SUI Magnetic Media Table (05)3YWVERSVersion HistoryStringGeneric Edit100
34F078306Colorado SUI magnetic media table (06)3YFVERSVersion HistoryStringGeneric Edit100
35F078310Florida SUI magnetic media table (10)3YFVERSVersion HistoryStringGeneric Edit100
36F078311Georgia SUI magnetic media table (11)3YFVERSVersion HistoryStringGeneric Edit100
37F078312Hawaii SUI magnetic media table (12)3YFVERSVersion HistoryStringGeneric Edit100
38F078329Nevada SUI Magnetic Media Table (29)3YFVERSVersion HistoryStringGeneric Edit100
39F078344Texas SUI Magnetic Media Table(44)3YWVERSVersion HistoryStringGeneric Edit100
40F078345Utah SUI magnetic media table (45)3YFVERSVersion HistoryStringGeneric Edit100
41F078348Washington SUI Magnetic Media Table (48)3YWVERSVersion HistoryStringGeneric Edit100
42F078510ADP Quarterly Integrity Report8VRVERSVersion HistoryStringGeneric Edit100
43F07881SUI Magnetic Media Flat File - Generic3YFVERSVersion HistoryStringGeneric Edit100
TOP08: Human Resources
44F05402Self-Service Step/ApplicationCross-Reference4SAVERSVersion HistoryStringGeneric Edit100
45F08090HRM Supplemental Data Types24JXVERSVersion HistoryStringGeneric Edit100
46F081162ACA Parameters2APVERSVersion HistoryStringGeneric Edit100
47F0811629ACA Parameters History3APVERSVersion HistoryStringGeneric Edit100
48F083305Mail Merge Header/Detail5MMVERSVersion HistoryStringGeneric Edit100
49F085550Employee Self-Service Personal Information Options5IOVERSVersion HistoryStringGeneric Edit100
50F087103Setup Task Details16TDVERSVersion HistoryStringGeneric Edit100
51F08740Manager's Self Service Reports6MRVERSVersion HistoryStringGeneric Edit100
TOP08B: Benefits Administration
52F085518Benefit Confirmation Statement Options2SOVERSVersion HistoryStringGeneric Edit100
TOP08U: PeopleSoft HR US
53F08362NDT - Tests Associated with Plan5NBVERSVersion HistoryStringGeneric Edit100
TOP10: Financial Reporting
54F1001Multi-Site Consolidation Transfer File Header35GPVERSVersion HistoryStringGeneric Edit100
55F1001Z1Unedited MSC Interoperability Header Table48IAVERSVersion HistoryStringGeneric Edit100
56F1002Multi-Site Consolidation Transfer File42GQVERSVersion HistoryStringGeneric Edit100
57F1002Z1Unedited MSC Interoperability Table54SZVERSVersion HistoryStringGeneric Edit100
58F10470Consolidation Specifications (OW)21CSVERSVersion HistoryStringGeneric Edit100
TOP16: Profit Management (EPS)
59F1630Driver Definitions40CDVERSVersion HistoryStringGeneric Edit100
TOP17: Customer Service Management
60F1720Contract Header54CHVERSVersion HistoryStringGeneric Edit100
TOP34: Requirements Planning
61F3420Semphore Value Table2MSVERSVersion HistoryStringGeneric Edit100
TOP40: Inventory/OP Base
62F40052Return Material Authorization Defaults15RVVERSVersion HistoryStringGeneric Edit100
63F49190Document Definition File (Conversion from World File)4DSVERSVersion HistoryStringGeneric Edit100
TOP41: Inventory Management
64F41081Allowed Lot Status8LSVERSVersion HistoryStringGeneric Edit100
65F41090Item Supplemental Data Types14T1VERSVersion HistoryStringGeneric Edit100
TOP42: Sales Management
66F42CSSCustomer Self Service Workfile2CSVERSVersion HistoryStringGeneric Edit100
TOP42X: In-Memory Sales Advisor
67F42X000Sales Advisor Constants13PCVERSVersion HistoryStringGeneric Edit100
TOP43E: Requisition Self Service
68F43E22Direct Connect Setup10PSVERSVersion HistoryStringGeneric Edit100
TOP43S: JSSS/Supplier Self Service
69F43S002Alerts Configuration5ACVERSVersion HistoryStringGeneric Edit100
TOP47: Electronic Commerce
70F47036EDI Shipping Notice Header - Outbound17SYVERSVersion HistoryStringGeneric Edit100
TOP49: Transportation Management
71F49191Document Definition4DSVERSVersion HistoryStringGeneric Edit100
72F49590Document Print Batch Header6DBVERSVersion HistoryStringGeneric Edit100
73F49592Document Print Batch Document Header6DHVERSVersion HistoryStringGeneric Edit100
TOP51: Job Costing
74F5144Profit Recognition1G7VERSVersion HistoryStringGeneric Edit100
TOP53: Change Management
75F5301BZ1Change Request Master Table Workfile4DIVERSVersion HistoryStringGeneric Edit100
TOP74: EMEA Localization
76F7430024Legal Documents Print UBEs & Versions - COMM -03B6DUVERSVersion HistoryStringGeneric Edit100
TOP74R: Russia
77F74R0007Legal Document Footer Signature Setup - RUS - 00 - 74R5FSVERSVersion HistoryStringGeneric Edit100
TOP76A: Argentina
78F76A7101Batch for Remittance - ARG - 03B - 76A6TAVERSVersion HistoryStringGeneric Edit100
TOP76B: Brazil
79F76B0531Electronic Reporting Detail Blocks - BR -5DBVERSVersion HistoryStringGeneric Edit100
80F76B0731Ato Cotepe Detail Blocks Template - BR - 005DBVERSVersion HistoryStringGeneric Edit100
81F76B0742Ato Cotepe Process Detail Blocks - BR - 005PDVERSVersion HistoryStringGeneric Edit100
82F76B942SPED Job Detail Blocks-UBE - BR - 096DBVERSVersion HistoryStringGeneric Edit100
TOP76C: Colombia
83F76C0F01DIAN Output Format Header - COL - 0010FHVERSVersion HistoryStringGeneric Edit100
84F76C4F02DIAN Formats File by Invoice - COL - 0418FIVERSVersion HistoryStringGeneric Edit100
85F76C9F01DIAN Setup Concept Code by Format and Account - 09 - COL14SCVERSVersion HistoryStringGeneric Edit100
86F76C9F02DIAN Formats by AccountID - COL - 0941DFVERSVersion HistoryStringGeneric Edit100
87F76C9F11DIAN Formats File by Account Id - COL - 0918DFVERSVersion HistoryStringGeneric Edit100
TOP76H: Chile
88F76H3B39Legal Documents Print UBE & Versions - CHI - 03B - 76H6UVVERSVersion HistoryStringGeneric Edit100
TOP81: DREAM Writer
89F81A122Dream Writer Processing Option Interim File F59012 - F81A1223M4VERSVersion HistoryStringGeneric Edit100
TOP81A: DREAMWriter Conversion Tool
90F81A10DW Log File - OneWorld3MEVERSVersion HistoryStringGeneric Edit100
91F81A11DW Master Interim Table3M3VERSVersion HistoryStringGeneric Edit100
92F81A11EMigration Aid PO Value Validation Error log8MEVERSVersion HistoryStringGeneric Edit100
93F81A13DreamWriter Selections Interim Table3M5VERSVersion HistoryStringGeneric Edit100
94F81A14DreamWriter Selection Values Interim Table3M6VERSVersion HistoryStringGeneric Edit100
95F81A15DreamWriter Sequence Interim Table3M7VERSVersion HistoryStringGeneric Edit100
TOP89: Conversion Programs
96F98305VBatch Versions Web Versions2WVVERSVersion HistoryStringGeneric Edit100
97F98950TTC Temporary table for AQ, CAFE17WOVERSVersion HistoryStringGeneric Edit100
TOP90CA: CRM Foundation
98F90CA23AWizard Process Flow Settings9WPVERSVersion HistoryStringGeneric Edit100
TOPH79: Translation Tools
99F79760Report Design Aid Extracted Text2RTVERSVersion HistoryStringGeneric Edit100
100F797601Report Design Aid Extracted Spec Language Status2LSVERSVersion HistoryStringGeneric Edit100
101F79761Report Design Aid Extracted Spec2RSVERSVersion HistoryStringGeneric Edit100
102F989501User Override Language Translation Table7LSVERSVersion HistoryStringGeneric Edit100
TOPH90: EnterpriseOne TOOLS
103F01131PPAT Message Control File37ZZVERSVersion HistoryStringGeneric Edit100
104F01131MJDEM Multi Level Message12ZMVERSVersion HistoryStringGeneric Edit100
TOPH91: Design Tools
105F91400Report Director Templates17DTVERSVersion HistoryStringGeneric Edit100
106F984052Table Conversion - History Log15SHVERSVersion HistoryStringGeneric Edit100
107F98610Debug Information3DBVERSVersion HistoryStringGeneric Edit100
TOPH92: Interactive Engine/OL
108F983051Versions List2VRVERSVersion HistoryStringGeneric Edit100
109F98740Event Rules - Link Table15ELVERSVersion HistoryStringGeneric Edit100
110F98760Report Design Aid Text Information12RTVERSVersion HistoryStringGeneric Edit100
111F98761Report Design Aid Specification Info16RSVERSVersion HistoryStringGeneric Edit100
112F9882Checkout Log Table11CLVERSVersion HistoryStringGeneric Edit100
113F98950User Overrides Table7UOVERSVersion HistoryStringGeneric Edit100
TOPH94: Batch Engine
114F986168OSA Interface Usage3OHVERSVersion HistoryStringGeneric Edit100
TOPH95: Object and Environment Tech
115F8303FASTR General Specifications Master File2R3VERSVersion HistoryStringGeneric Edit100
116F8304FASTR - Column Specifications Master File2R4VERSVersion HistoryStringGeneric Edit100
117F8305FASTR - Row Specifications Master File2R5VERSVersion HistoryStringGeneric Edit100
118F8306FASTR - Cell Specifications Master File2R6VERSVersion HistoryStringGeneric Edit100
119F91500Application Header for Tip of the Day3TDVERSVersion HistoryStringGeneric Edit100
120F91510Tip Details for Tip of the Day3TDVERSVersion HistoryStringGeneric Edit100
121F93081Unicode Flat File Encoding Configuration4UFVERSVersion HistoryStringGeneric Edit100
122F9500006Signature Table4STVERSVersion HistoryStringGeneric Edit100
123F952430Advance Query7AQVERSVersion HistoryStringGeneric Edit100
124F952440Grid Formats Detail6GFVERSVersion HistoryStringGeneric Edit100
125F952450CafeOne Layout Table9WOVERSVersion HistoryStringGeneric Edit100
126F952471Modified Web Object Metadata11XMVERSVersion HistoryStringGeneric Edit100
127F95610Fusion Reporting UBE Associations2FUVERSVersion HistoryStringGeneric Edit100
128F98301DREAM Writer Master Parameter2DEVERSVersion HistoryStringGeneric Edit100
129F983052Versions List Tag Table2VTVERSVersion HistoryStringGeneric Edit100
130F98311Processing Options Additional Headings2DHVERSVersion HistoryStringGeneric Edit100
131F986114Auditing Information Data Repository4JCVERSVersion HistoryStringGeneric Edit100
132F986166Bar Code font support8BCVERSVersion HistoryStringGeneric Edit100
133F986167New Default Printer Table3DPVERSVersion HistoryStringGeneric Edit100
134F98881CFDSS Specification Logging File2CFVERSVersion HistoryStringGeneric Edit100
135F98881CUSpecification Logging File2SMVERSVersion HistoryStringGeneric Edit100
136F98950DUser Overrides Language Table7LOVERSVersion HistoryStringGeneric Edit100
TOPH96: Deployment
137F96400Sar grouping file for ESUs5SGVERSVersion HistoryStringGeneric Edit100
TOPH96B: Package Build
138F9622Software Package Build Detail5BDVERSVersion HistoryStringGeneric Edit100
139F96225Software Package Build Detail - History8HDVERSVersion HistoryStringGeneric Edit100
140F9631Software Package Detail5PDVERSVersion HistoryStringGeneric Edit100
141F988259MDK Table for UBE Locking6DBVERSVersion HistoryStringGeneric Edit100
TOPH96P: Product Packaging Tools
142F9642Change Table Configuration Details6CFVERSVersion HistoryStringGeneric Edit100
TOPH96U: Upgrade
143F9672Software Update Pathcode Information5SUVERSVersion HistoryStringGeneric Edit100
144F968902TC Performance Estimation Detail Table6EDVERSVersion HistoryStringGeneric Edit100
145F969000Change Table - Task Master17CMVERSVersion HistoryStringGeneric Edit100
146F9691400Change Table - Report Director Template Header11DTVERSVersion HistoryStringGeneric Edit100
147F9691500Change Table - Tips of the Day Header4TPVERSVersion HistoryStringGeneric Edit100
148F9691510Change Table - Tips of the Day Detail4TPVERSVersion HistoryStringGeneric Edit100
149F969861Object Change Table Definition4CTVERSVersion HistoryStringGeneric Edit100
150F98405Table Conversion Scheduler10STVERSVersion HistoryStringGeneric Edit100
151F9843Table Conversion - JDE Scheduler7JSVERSVersion HistoryStringGeneric Edit100
152F9843TTC Schedule - Tag File6JSVERSVersion HistoryStringGeneric Edit100
153F98881Specification Merge Logging File2SMVERSVersion HistoryStringGeneric Edit100
154F988810SpecMerge Tracking5SMVERSVersion HistoryStringGeneric Edit100
TOPH97: Benchmarking/Performance
155F9720AutoPilot Script Repository Table66TSVERSVersion HistoryStringGeneric Edit100
TOPH98: Internet
156F986113Subsystem Job Master2SSVERSVersion HistoryStringGeneric Edit100
TOPH99: Product Version Control
157F99099FDA Cleanup - Data Items10FSVERSVersion HistoryStringGeneric Edit100