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

94 columns | Print definition?920 | CRDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0087Conversion Constants File for Euro7EUCRDCCurrency Code - ToStringGeneric Edit30
2F09190Inter/Intra Company Account Relationships5C9CRDCCurrency Code - ToStringGeneric Edit30
TOP04: Accounts Payable
3F0411Z3F0411 Interoperability Table57SZCRDCCurrency Code - ToStringGeneric Edit30
4F0413Z1F0413 Interoperability Table28SYCRDCCurrency Code - ToStringGeneric Edit30
TOP05: Time Accounting and HRM Base
5F0618Employee Transaction History115YTCRDCCurrency Code - ToStringGeneric Edit30
TOP05T: Time Entry
6F06116Employee Transaction Detail File166YTCRDCCurrency Code - ToStringGeneric Edit30
7F06116Z1Employee Transactions - Batch File179VLCRDCCurrency Code - ToStringGeneric Edit30
8F06116Z2ESS Timecard History179VMCRDCCurrency Code - ToStringGeneric Edit30
9F063951Payroll Journal (Compressed) File37GLCRDCCurrency Code - ToStringGeneric Edit30
TOP06: Payroll (old) - Obsolete-do not reuse
10F0618TATemp table for F0618T for conversion10YTCRDCCurrency Code - ToStringGeneric Edit30
TOP07: Payroll
11F05290WF - Payroll Journal (Detail)40JRCRDCCurrency Code - ToStringGeneric Edit30
12F0716701Employee Assignment T/E Template Information88EACRDCCurrency Code - ToStringGeneric Edit30
13F0716709Employee Assignment T/E Template Info History88EACRDCCurrency Code - ToStringGeneric Edit30
TOP09: General Accounting
14F0911Z4F0911 Interoperability Table123SZCRDCCurrency Code - ToStringGeneric Edit30
15F11151Currency Cross Rates Calculation Master2CECRDCCurrency Code - ToStringGeneric Edit30
TOP09E: Expense Reimbursment
16F20112Expense Report Detail69EDCRDCCurrency Code - ToStringGeneric Edit30
TOP11: Multi Currency
17F0015Currency Exchange Rates2CXCRDCCurrency Code - ToStringGeneric Edit30
18F0015Z1External Currency Exchange Rates24ZECRDCCurrency Code - ToStringGeneric Edit30
19F1113Currency Restatement Rates File2C1CRDCCurrency Code - ToStringGeneric Edit30
20F1114Company Conversions Parameter File7C2CRDCCurrency Code - ToStringGeneric Edit30
TOP17: Customer Service Management
21F1775Claim Temporary Table35TCCRDCCurrency Code - ToStringGeneric Edit30
22F3111Z2Warranty Claim/Supplier Recovery processing133WPCRDCCurrency Code - ToStringGeneric Edit30
23F3112Z2Warranty Claim/Supplier Recovery processing150WLCRDCCurrency Code - ToStringGeneric Edit30
24F31171Parts List - Extension40WSCRDCCurrency Code - ToStringGeneric Edit30
25F31171SPurge Parts List - Extension40WSCRDCCurrency Code - ToStringGeneric Edit30
26F31172Routing Instructions - Extension43WSCRDCCurrency Code - ToStringGeneric Edit30
27F31172SPurge Routing Instructions - Extension43WSCRDCCurrency Code - ToStringGeneric Edit30
28F4801TZ2Warranty Claim/Supplier Recovery processing104WQCRDCCurrency Code - ToStringGeneric Edit30
TOP17C: Call Management
29F1755Case Master108ZACRDCCurrency Code - ToStringGeneric Edit30
30F1760Time Entry26ZBCRDCCurrency Code - ToStringGeneric Edit30
TOP18: Timecard Automation
31F186602Labor Rules Tag File172TFCRDCCurrency Code - ToStringGeneric Edit30
TOP31P: Engineer To Order
32F31P10Project Quote Header11PQCRDCCurrency Code - ToStringGeneric Edit30
TOP32: Configuration Management
33F3201Configurator Master Table15CMCRDCCurrency Code - ToStringGeneric Edit30
34F32019Configurator Master History Table15CHCRDCCurrency Code - ToStringGeneric Edit30
TOP40: Inventory/OP Base
35F4211AUSales Order Detail Audit File12AUCRDCCurrency Code - ToStringGeneric Edit30
TOP40S: Supply Chain Self Service
36F4947SWSelf-Service Shipment Tracking Work File19SWCRDCCurrency Code - ToStringGeneric Edit30
TOP41F: Apparel Management
37FCW38Price List Exchange Rate2TRCRDCCurrency Code - ToStringGeneric Edit30
38FCW84Exchange Rate for Outsource Operations3TRCRDCCurrency Code - ToStringGeneric Edit30
TOP42: Sales Management
39F42565Invoice Print File87IWCRDCCurrency Code - ToStringGeneric Edit30
40F42800GSales Update G Batch Workfile29SGCRDCCurrency Code - ToStringGeneric Edit30
41F42800G1Sales Update G Batch Detail Workfile53DGCRDCCurrency Code - ToStringGeneric Edit30
42F42CSSCustomer Self Service Workfile17CSCRDCCurrency Code - ToStringGeneric Edit30
43F42UI01SO Header Cache File (MBF)104ZHCRDCCurrency Code - ToStringGeneric Edit30
44F42UI520Pick Slips Header File28S8CRDCCurrency Code - ToStringGeneric Edit30
45F42UI800Sales Detail Work File - Sales Update16SDCRDCCurrency Code - ToStringGeneric Edit30
TOP43: Procurement
46F4301SWPurchase Order Summary Work Table6PSCRDCCurrency Code - ToStringGeneric Edit30
47F4301ZPO Header Work File88PACRDCCurrency Code - ToStringGeneric Edit30
48F4311TPurchase Order Detail Tag File11PDCRDCCurrency Code - ToStringGeneric Edit30
49F43121TPurchase Order Receiver Tag File18PRCRDCCurrency Code - ToStringGeneric Edit30
50F43121ZReceiver workfile92PWCRDCCurrency Code - ToStringGeneric Edit30
51F4371Suggested Reorder Stock Items7PDCRDCCurrency Code - ToStringGeneric Edit30
52F43UI50HPO Print Header Work File33PACRDCCurrency Code - ToStringGeneric Edit30
TOP43E: Requisition Self Service
53F43E01Requisition Order Header6RHCRDCCurrency Code - ToStringGeneric Edit30
54F43E20Shopping Cart Detail12SCCRDCCurrency Code - ToStringGeneric Edit30
TOP43Q: Strategic Sourcing
55F43Q10Event Header17EHCRDCCurrency Code - ToStringGeneric Edit30
56F43Q40Response Header9RACRDCCurrency Code - ToStringGeneric Edit30
57F43Q50Analyze Event Header9AVCRDCCurrency Code - ToStringGeneric Edit30
TOP46: Warehouse Management
58F4942Z1Work File for F494241SYCRDCCurrency Code - ToStringGeneric Edit30
TOP48: Work Order Processing
59F4801STPurge - Work Order Master Tag File91WACRDCCurrency Code - ToStringGeneric Edit30
60F4801TWork Order Master Tag File91WACRDCCurrency Code - ToStringGeneric Edit30
61F4817Service Order Extension52SRCRDCCurrency Code - ToStringGeneric Edit30
TOP48S: Service Billing
62F48S0618Payroll Reclassification Workfile115YTCRDCCurrency Code - ToStringGeneric Edit30
TOP49: Transportation Management
63F4941Shipment Routing Steps62RSCRDCCurrency Code - ToStringGeneric Edit30
64F4945Shipment Charges17SCCRDCCurrency Code - ToStringGeneric Edit30
65F4981Freight Audit History35FHCRDCCurrency Code - ToStringGeneric Edit30
66F49T50Order Release Location Staging37LOCRDCCurrency Code - ToStringGeneric Edit30
TOP51: Job Costing
67F51006MCM Currency Code Mapping3VMCRDCCurrency Code - ToStringGeneric Edit30
TOP74: EMEA Localization
68F0018TIntrastat Revision42TDCRDCCurrency Code - ToStringGeneric Edit30
69F740018DData extraction ESL - 7433DECRDCCurrency Code - ToStringGeneric Edit30
70F740018WData extraction ESL - Workfile - 7433DECRDCCurrency Code - ToStringGeneric Edit30
TOP74S: Spain
71F74S70Model 347 - Record Type 0 - Spain - 03B18Q0CRDCCurrency Code - ToStringGeneric Edit30
72F74S71Model 347 - Record Type 1 - Spain - 03B24Q1CRDCCurrency Code - ToStringGeneric Edit30
73F74S72Model 347 - Record Type 2 - Spain18Q2CRDCCurrency Code - ToStringGeneric Edit30
74F74S73Model 347 - Record Type 3 - Spain21Q3CRDCCurrency Code - ToStringGeneric Edit30
75F74S90Model 349 - Record Type 0 - Spain - 03B24Q0CRDCCurrency Code - ToStringGeneric Edit30
76F74S91Model 349 - Record Type 1 - Spain - 03B21Q1CRDCCurrency Code - ToStringGeneric Edit30
77F74S92Model 349 - Record Type 2 Spain - 03B18Q2CRDCCurrency Code - ToStringGeneric Edit30
TOP75C: China
78F75C001Chinese GUI cross reference file14CRCRDCCurrency Code - ToStringGeneric Edit30
TOP75I: India
79F75I357Consignment Header24CHCRDCCurrency Code - ToStringGeneric Edit30
80F75I3571Consignment - Work Orders25CWCRDCCurrency Code - ToStringGeneric Edit30
81F75I3572Consignment - Stock Transfers28CSCRDCCurrency Code - ToStringGeneric Edit30
82F75I3573Consignment - Order Items30COCRDCCurrency Code - ToStringGeneric Edit30
83F75I3574Consignment - Issues/Receipts Transactions39CTCRDCCurrency Code - ToStringGeneric Edit30
84F75I3575Consignment - Work Order Part List Items - Balances22CPCRDCCurrency Code - ToStringGeneric Edit30
85F75I3576Stock Transfer - Work Orders27SWCRDCCurrency Code - ToStringGeneric Edit30
86F75I380Excise - RG-1 - Transaction File - IND50RGCRDCCurrency Code - ToStringGeneric Edit30
87F75I3901Work With Consignment - IND -4343COCRDCCurrency Code - ToStringGeneric Edit30
TOP75T: Taiwan
88F75T1113Taiwan Exchange Rate Update2TRCRDCCurrency Code - ToStringGeneric Edit30
TOP89: Conversion Programs
89F00151Needed for upgrade for XE and below2T1CRDCCurrency Code - ToStringGeneric Edit30
90F05290TNeeded for upgrade from Xe to B94JRCRDCCurrency Code - ToStringGeneric Edit30
91F06116TNeeded for upgrade from Xe to B98YTCRDCCurrency Code - ToStringGeneric Edit30
92F06116TZNeeded for upgrade from Xe to B99VLCRDCCurrency Code - ToStringGeneric Edit30
93F0618TNeeded for upgrade from Xe to B98YTCRDCCurrency Code - ToStringGeneric Edit30
94F063951TNeeded for upgrade from Xe to B94GLCRDCCurrency Code - ToStringGeneric Edit30