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
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

105 tables920 | 89

89: Conversion Programs
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F00151T161Needed for upgrade for XE and belowExtra Features Files11: Multi CurrencyBusiness Data
2920F0086AU362Conversion Audit File for Euro ConversionHistory Files03B: Enhanced Accounts ReceivableBusiness Data
3920F01111WN261Contact InformationSecondary Master Files89: Conversion ProgramsBusiness Data
4920F01111Z1CB641Batch - Contact InformationBatch Input Files01: Address BookBusiness Data
5920F05290TJR51Needed for upgrade from Xe to B9Transaction Files05: Time Accounting and HRM BaseBusiness Data
6920F06116TYT111Needed for upgrade from Xe to B9Transaction Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
7920F06116TZVL121Needed for upgrade from Xe to B9Transaction Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
8920F0618TYT111Needed for upgrade from Xe to B9Transaction Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
9920F063951TGL51Needed for upgrade from Xe to B9Transaction Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
10920F07186TY8191Piece Rate History FileFiles89: Conversion ProgramsBusiness Data
11920F07352TY2201Piece Rate Stub Detail Tag FileFiles89: Conversion ProgramsBusiness Data
12920F0901TGM61Needed for upgrade for XE and belowMaster Files09: General AccountingBusiness Data
13920F0902AGD281Account Debit BalancesFiles89: Conversion Programs
14920F0911TGL261Needed for upgrade for XE and belowTransaction Files09: General AccountingBusiness Data
15920F0911Z1TVN231Needed for upgrade for XE and belowBatch Input Files09: General AccountingBusiness Data
16920F0917SGD51Needed for upgrade for XE and belowExtra Features Files09: General AccountingBusiness Data
17920F186407DOB191Labor Rules tag file oneFiles89: Conversion ProgramsBusiness Data
18920F186407TOB81Labor Rules tage file twoFiles89: Conversion ProgramsBusiness Data
19920F31172TEWS71F31172 temp table for TC mergeFiles89: Conversion Programs
20920F31B35TOM71Owner Master Tag TableFiles89: Conversion ProgramsBusiness Data
21920F3214MT62Needed for upgrade from Xe and belowTransaction Files32: Configuration ManagementBusiness Data
22920F3294KZ225Needed for upgrade from Xe and belowTransaction Files32: Configuration ManagementBusiness Data
23920F32941SM101Needed for upgrade from Xe and belowSecondary Master Files32: Configuration ManagementBusiness Data
24920F32942SG133Needed for upgrade from Xe and belowSecondary Master Files32: Configuration ManagementBusiness Data
25920F32943KO235Needed for upgrade from Xe and belowTransaction Files32: Configuration ManagementBusiness Data
26920F32944KT112Needed for upgrade from Xe and belowSecondary Master Files32: Configuration ManagementBusiness Data
27920F32945SI144Needed for upgrade from Xe and belowSecondary Master Files32: Configuration ManagementBusiness Data
28920F3294ZAZ191Needed for upgrade from Xe and belowPC Download/Batch Edit Files32: Configuration ManagementBusiness Data
29920F3296KR211Needed for upgrade from Xe and belowTransaction Files32: Configuration ManagementBusiness Data
30920F32961KL121Needed for upgrade from Xe and belowTransaction Files32: Configuration ManagementBusiness Data
31920F329611KB151Needed for upgrade from Xe and belowTransaction Files32: Configuration ManagementBusiness Data
32920F3296TKA131Needed for upgrade from Xe and belowTransaction Files32: Configuration ManagementBusiness Data
33920F32UI002WY51Needed for upgrade from Xe and below"T" Work Files32: Configuration ManagementBusiness Data
34920F4009TCP61OBSOLETE - Distribution Manufacturing Constants Tag FileConstants Files89: Conversion ProgramsBusiness Data
35920F40242CS21Secondary Commodity CodeFiles43B: Voucher Match and Landed Cost
36920F40344ASA291Temporay Preference Profile - Sales CommissionExtra Features Files89: Conversion ProgramsBusiness Data
37920F4072TEMAD351Price Adjustment Detail - Temp for UpgradeWork Files45: Advanced Pricing
38920F4074TEMAL111Price Adjustment Ledger File - Temp for UpgradeWork Files45: Advanced Pricing
39920F41001TCI61OBSOLETE - Inventory Constants Tag FileSecondary Master Files89: Conversion ProgramsBusiness Data
40920F4100TLM31OBSOLETE - Location Master Tag FileSecondary Master Files89: Conversion ProgramsBusiness Data
41920F4101SRMIM21Item Master SRM Tag FileFiles41: Inventory Management
42920F4101TIM353OBSOLETE - Item Master Tag FileSecondary Master Files41: Inventory ManagementBusiness Data
43920F4101TTIX291Temp Table Merge Xe F4101T to E9 F4101Files41: Inventory Management
44920F4102SRMIB31Item Branch SRM Tag FileFiles41: Inventory Management
45920F4102TTIY41Temp Table Merge Xe F4101T to E9 F4102Files41: Inventory Management
46920F42005ASC521Sales Commission File - TemporaryFiles42: Sales Management
47920F42119ASD51Sales Order History File - temporary for upgrade (1)Files42B: Sales Order Entry
48920F42119BSD231Sales Order History File - temporary for upgrade (2)Files42B: Sales Order Entry
49920F4211ASD51Sales Order Detail File - temporary for upgrade (1)Files42B: Sales Order Entry
50920F4211BSD231Sales Order Detail File - temporary for upgrade (2)Files42B: Sales Order Entry
51920F42140ACM61Copy from F42140 to Temp Table F42140AFiles42: Sales Management
52920F42150ASH71ERP9.0 Update F42150 (Temp File)Files89: Conversion Programs
53920F4215TXT182OBSOLETE - Shipment Header Tag FileTransaction Files49: Transportation ManagementBusiness Data
54920F42199ASL71S.O. Detail Ledger File - temporary for upgradeWork Files42B: Sales Order Entry
55920F4311TAPD71Temp table for ERP 9.0 upgradeFiles89: Conversion Programs
56920F43121TAPR91ERP 9.0 temp F43121T for upgradeFiles43: Procurement
57920F43199AOL1881Temp F43199 for ERP 9.0 UpgradeHistory Files43: Procurement
58920F4600TR173OBSOLETE - Warehouse Requests Tag FileTransaction Files46: Warehouse ManagementBusiness Data
59920F4600TPUR1101OBSOLETE - Warehouse Requests Tag File - PurgedPurge Files46: Warehouse ManagementBusiness Data
60920F46011TIQ101OBSOLETE - Item Unit Of Measure Definition Tag FileFiles46: Warehouse ManagementBusiness Data
61920F46091TID81OBSOLETE - Container and Carton Codes Tag FileSecondary Master Files46: Warehouse ManagementBusiness Data
62920F4611TR273OBSOLETE - Warehouse Suggestions Tag FileTransaction Files46: Warehouse ManagementBusiness Data
63920F4611TPUR2101OBSOLETE - Warehouse Suggestions Tag File - PurgedPurge Files46: Warehouse ManagementBusiness Data
64920F4620TCD101Carton Detail Information - Tag FileFiles46: Warehouse Management
65920F470375TAK181EDI ASN Packaging Detail Tag TableFiles47: Electronic Commerce
66920F49090CZ422Work Day Calendar (Used for Table Conversions ONLY)Extra Features Files49: Transportation ManagementBusiness Data
67920F49711RV201OBSOLETE - Freight Rate Definition - Tag FileMaster Files49: Transportation ManagementBusiness Data
68920F74401RF51W/T Additional A/B Information - ItalyBalance Files04: Accounts PayableBusiness Data
69920F7460QL52Next Auto Debit NumberBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
70920F750401AJJ71Address Book - Withholding Tax Category-JapanConstants Files04: Accounts PayableBusiness Data
71920F75I101AQB262TDS Ceritificate Master Tabel ExtensionFiles75I: India
72920F894101TC21Lookup table for CRM Product ID and F4101.IMITMFiles90CA: CRM Foundation
73920F894101HPH41Lookup table for CRM and EOne Product Hierarchy IdsFiles90CA: CRM Foundation
74920F89701PB61List of Data Items Not Used in FDAMaster Files89: Conversion ProgramsBusiness Data
75920F89702PB61List of Data Items Not Used in RDAMaster Files89: Conversion ProgramsBusiness Data
76920F89AD020PE31Person_Address cross reference tableFiles90CA: CRM Foundation
77920F89AD050PA21Lookup table for populating CRM Partner AddressesFiles90CA: CRM Foundation
78920F89AD060AD21Lookup table for populating CRM Competitor AddressesFiles90CA: CRM Foundation
79920F89CA020PS41Lookup Table for CRM and EOne Person IdsFiles89: Conversion Programs
80920F89CA050PR21Lookup Table for CRM and EOne Partner IdsFiles89: Conversion Programs
81920F89CA060CM21Lookup Table for CRM and EOne Competitor IdsFiles89: Conversion Programs
82920F89CA080CO21Lookup Table for CRM to EOne Company IdsFiles89: Conversion Programs
83920F89CA65ATC21Table - Lookup Table for CRM Activity Call Plan ID and NNFiles89: Conversion Programs
84920F89CB06CTC31Table - Opportunity_For_FCST_ID - Opportunity Lookup TableFiles89: Conversion Programs
85920F89LU001PC31Lookup Table for CRM Person Company and Partner IdsFiles89: Conversion Programs
86920F89LU002CY21Lookup Table for CRM City Code and NameFiles90CA: CRM Foundation
87920F89LU003SR31Table - Service Request Status ID - UDC Lookup TableFiles89: Conversion Programs
88920F89LU005TC31Table - CRM Status Type Lookup TableFiles89: Conversion Programs
89920F89LU006TC31Table - CRM Priority Type Lookup TableFiles89: Conversion Programs
90920F89LU007TC31Table - CRM Problem Type Lookup TableFiles89: Conversion Programs
91920F89LU008LU21Table - Lookup Table for CRM Serivice Request - ChannelFiles89: Conversion Programs
92920F89LUADDAD41Address lookup tableFiles89: Conversion Programs
93920F90CB072PF271Profile TableFiles90CB: CRM Sales Force Automation
94920F90CB073PA271Profile-Answer TableFiles90CB: CRM Sales Force Automation
95920F952330BH172Context Cross-Reference Header Table for IntegrationFiles89: Conversion ProgramsBusiness Data
96920F952331BH192Context Cross-Reference Detail Table for IntegrationFiles89: Conversion ProgramsBusiness Data
97920F952332BH221Collaboration Configuration TableFiles89: Conversion ProgramsSystem Tables
98920F952334PR181Metadata Table for Public Resource URLFiles89: Conversion ProgramsBusiness Data
99920F952337PD151Related Information Publication List Detail TableFiles89: Conversion ProgramsBusiness Data
100920F98305VWV212Batch Versions Web VersionsFilesH95: Object and Environment TechVersions Tables
101920F98950TWO192TC Temporary table for AQ, CAFE1FilesH95: Object and Environment TechCentral Objects Tables
102920F99302PO111Processing Options Text TableExtra Features Files89: Conversion ProgramsBusiness Data
103920F993022PO111Processing Options Error TableExtra Features Files89: Conversion ProgramsBusiness Data
104920F993023PO111Translated Processing Options Text TableExtra Features Files89: Conversion ProgramsBusiness Data
105920F99303PP31PO && Object Cross Reference TablePC Download/Batch Edit Files89: Conversion ProgramsBusiness Data