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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

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

61 tables812 | 89

89: Conversion Programs
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F0086AU362Conversion Audit File for Euro ConversionHistory Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
2812F05290TJR51Needed for upgrade from Xe to B9Transaction Files05: Time Accounting and HRM BaseBusiness Data
3812F06116TYT111Needed for upgrade from Xe to B9Transaction Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
4812F06116TZVL121Needed for upgrade from Xe to B9Transaction Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
5812F0618TYT111Needed for upgrade from Xe to B9Transaction Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
6812F063951TGL51Needed for upgrade from Xe to B9Transaction Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
7812F07186TY8191Piece Rate History FileFiles89: Conversion ProgramsBusiness Data
8812F07352TY2201Piece Rate Stub Detail Tag FileFiles89: Conversion ProgramsBusiness Data
9812F074001WNH151SUI/New Hire Client loader for F074001RInstall Files07S: Payroll SUINo
10812F0902AGD281Account Debit BalancesFiles89: Conversion Programs
11812F186407DOB191Labor Rules tag file oneFiles89: Conversion ProgramsBusiness Data
12812F186407TOB81Labor Rules tage file twoFiles89: Conversion ProgramsBusiness Data
13812F31172TEWS71F31172 temp table for TC mergeFiles89: Conversion Programs
14812F40242CS21Secondary Commodity CodeFiles43B: Voucher Match and Landed Cost
15812F40344ASA291Temporay Preference Profile - Sales CommissionExtra Features Files89: Conversion ProgramsBusiness Data
16812F4072TEMAD351Price Adjustment Detail - Temp for UpgradeWork Files45: Advanced Pricing
17812F4074TEMAL111Price Adjustment Ledger File - Temp for UpgradeWork Files45: Advanced Pricing
18812F4101SRMIM21Item Master SRM Tag FileFiles41: Inventory Management
19812F4101TTIX291Temp Table Merge Xe F4101T to E9 F4101Files41: Inventory Management
20812F4102SRMIB31Item Branch SRM Tag FileFiles41: Inventory Management
21812F4102TTIY41Temp Table Merge Xe F4101T to E9 F4102Files41: Inventory Management
22812F42005ASC521Sales Commission File - TemporaryFiles42: Sales Management
23812F42119ASD51Sales Order History File - temporary for upgrade (1)Files42B: Sales Order Entry
24812F42119BSD231Sales Order History File - temporary for upgrade (2)Files42B: Sales Order Entry
25812F4211ASD51Sales Order Detail File - temporary for upgrade (1)Files42B: Sales Order Entry
26812F4211BSD231Sales Order Detail File - temporary for upgrade (2)Files42B: Sales Order Entry
27812F42140ACM61Copy from F42140 to Temp Table F42140AFiles42: Sales Management
28812F42150ASH71ERP9.0 Update F42150 (Temp File)Files89: Conversion Programs
29812F42199ASL71S.O. Detail Ledger File - temporary for upgradeWork Files42B: Sales Order Entry
30812F4311TAPD71Temp table for ERP 9.0 upgradeFiles89: Conversion Programs
31812F43121TAPR91ERP 9.0 temp F43121T for upgradeFiles43: Procurement
32812F43199AOL1881Temp F43199 for ERP 9.0 UpgradeHistory Files43: Procurement
33812F4620TCD101Carton Detail Information - Tag FileFiles46: Warehouse Management
34812F470375TAK181EDI ASN Packaging Detail Tag TableFiles47: Electronic Commerce
35812F894101TC21Lookup table for CRM Product ID and F4101.IMITMFiles90CA: CRM Foundation
36812F894101HPH41Lookup table for CRM and EOne Product Hierarchy IdsFiles90CA: CRM Foundation
37812F89701PB61List of Data Items Not Used in FDAMaster Files89: Conversion ProgramsNo
38812F89702PB61List of Data Items Not Used in RDAMaster Files89: Conversion ProgramsNo
39812F89AD020PE31Person_Address cross reference tableFiles90CA: CRM Foundation
40812F89AD050PA21Lookup table for populating CRM Partner AddressesFiles90CA: CRM Foundation
41812F89AD060AD21Lookup table for populating CRM Competitor AddressesFiles90CA: CRM Foundation
42812F89CA020PS41Lookup Table for CRM and EOne Person IdsFiles89: Conversion Programs
43812F89CA050PR21Lookup Table for CRM and EOne Partner IdsFiles89: Conversion Programs
44812F89CA060CM21Lookup Table for CRM and EOne Competitor IdsFiles89: Conversion Programs
45812F89CA080CO21Lookup Table for CRM to EOne Company IdsFiles89: Conversion Programs
46812F89CA65ATC21Table - Lookup Table for CRM Activity Call Plan ID and NNFiles89: Conversion Programs
47812F89CB06CTC31Table - Opportunity_For_FCST_ID - Opportunity Lookup TableFiles89: Conversion Programs
48812F89LU001PC31Lookup Table for CRM Person Company and Partner IdsFiles89: Conversion Programs
49812F89LU002CY21Lookup Table for CRM City Code and NameFiles89: Conversion Programs
50812F89LU003SR31Table - Service Request Status ID - UDC Lookup TableFiles89: Conversion Programs
51812F89LU005TC31Table - CRM Status Type Lookup TableFiles89: Conversion Programs
52812F89LU006TC31Table - CRM Priority Type Lookup TableFiles89: Conversion Programs
53812F89LU007TC31Table - CRM Problem Type Lookup TableFiles89: Conversion Programs
54812F89LU008LU21Table - Lookup Table for CRM Serivice Request - ChannelFiles89: Conversion Programs
55812F89LUADDAD41Address lookup tableFiles89: Conversion Programs
56812F90CB072PF271Profile TableFiles90CB: CRM Sales Force Automation
57812F90CB073PA271Profile-Answer TableFiles90CB: CRM Sales Force Automation
58812F99302PO111Processing Options Text TableExtra Features Files89: Conversion ProgramsNo
59812F993022PO111Processing Options Error TableExtra Features Files89: Conversion ProgramsNo
60812F993023PO111Translated Processing Options Text TableExtra Features Files89: Conversion ProgramsNo
61812F99303PP31PO and Object Cross Reference TablePC Download/Batch Edit Files89: Conversion ProgramsNo