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

143 columns | Print definition?920 | CTID

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0040Z1Error Message Log Table1ZBCTIDComputer IDStringGeneric Edit150
2F0041Z1Transaction Control File1ZFCTIDComputer IDStringGeneric Edit150
3F00UI391Generated Document Work Table1GWCTIDComputer IDStringGeneric Edit150
4F00UI392Text Substitution Work Table2GWCTIDComputer IDStringGeneric Edit150
5F00UI393Bookmark Work Table1GWCTIDComputer IDStringGeneric Edit150
TOP03B: Enhanced Accounts Receivable
6F03BUI05Auto Receipts Batch Workfile1R5CTIDComputer IDStringGeneric Edit150
TOP04: Accounts Payable
7F046UI01T5018 Tax Workfile6CVCTIDComputer IDStringGeneric Edit150
8F04UI0061099 Worktable User Index6G1CTIDComputer IDStringGeneric Edit150
TOP09: General Accounting
9F0902Z1Account Balances - Batch File9GBCTIDComputer IDStringGeneric Edit150
10F09UI008Global Business Unit Change1GMCTIDComputer IDStringGeneric Edit150
11F09UI009Trial Balance Generic Work File - OneWorld ONLY2GBCTIDComputer IDStringGeneric Edit150
TOP15L: Adv Real Estate Forecasting
12F15L302AREF Prior Gross Billings1PGCTIDComputer IDStringGeneric Edit150
TOP16: Profit Management (EPS)
13F16UI001Enabled Tables by Application work file1CACTIDComputer IDStringGeneric Edit150
TOP30: Product Data Management
14F30UI008Bill of Material Comparison Work File2IJCTIDComputer IDStringGeneric Edit150
TOP31: Shop Floor Control
15F31UI002User Index - Variances21IGCTIDComputer IDStringGeneric Edit150
16F31UI006Line Scheduling Workbench - Work File1LSCTIDComputer IDStringGeneric Edit150
17F31UI427Labor Variance User Index2W1CTIDComputer IDStringGeneric Edit150
18F31UI802Accumulate Amounts by Account14WGCTIDComputer IDStringGeneric Edit150
19F31UI803Work File for Summarizing Journal Entries14SGCTIDComputer IDStringGeneric Edit150
20F31UI804Exception Report Work FIle12WRCTIDComputer IDStringGeneric Edit150
TOP31B: Blend Management
21F31B33DCDependency Chain Cache Structure2DTCTIDComputer IDStringGeneric Edit150
TOP33: Capacity Planning
22F33UI001Shop Floor Control Routing Instructions24WLCTIDComputer IDStringGeneric Edit150
TOP34: Requirements Planning
23F34UI003MPS Time Series User Index60M8CTIDComputer IDStringGeneric Edit150
24F34UI004MPS Net Change User Index2M8CTIDComputer IDStringGeneric Edit150
25F34UI005MRP Orders/Requirements User Index-Process Item2F5CTIDComputer IDStringGeneric Edit150
26F34UI006MRP Co/By Product Net Quantity User Index2W6CTIDComputer IDStringGeneric Edit150
TOP35: Enterprise Facility Planning
27F35UI001MPS/MRP Planning - Multiple Plant User Index2MACTIDComputer IDStringGeneric Edit150
TOP40: Inventory/OP Base
28F30UI001Component Locators Work File1WFCTIDComputer IDStringGeneric Edit150
29F30UI002Bill of Material Structure Analysis Work File4IXCTIDComputer IDStringGeneric Edit150
30F30UI004Bill of Material Update Work File1WFCTIDComputer IDStringGeneric Edit150
31F30UI006Lot Tracking Work File1ILCTIDComputer IDStringGeneric Edit150
32F40UI00TTax Work File28PNCTIDComputer IDStringGeneric Edit150
33F40UI17Allocation Work File1ZGCTIDComputer IDStringGeneric Edit150
34F40UI74Price Adjustment History Work File1AWCTIDComputer IDStringGeneric Edit150
35F40UI801Generic Error Table1ZBCTIDComputer IDStringGeneric Edit150
TOP40G: Grower Management
36F40G30SAssessments / Donations Workfile3ADCTIDComputer IDStringGeneric Edit150
TOP40R: Demand Scheduling
37F40R12WFCUM Rollback Workfile2CQCTIDComputer IDStringGeneric Edit150
38F40R30WFDemand Work File1DSCTIDComputer IDStringGeneric Edit150
39F47UI002ASN Extract Packaging Work File1SPCTIDComputer IDStringGeneric Edit150
TOP40S: Supply Chain Self Service
40F4947SWSelf-Service Shipment Tracking Work File2SWCTIDComputer IDStringGeneric Edit150
TOP41: Inventory Management
41F41021WFF41021 Transaction Workfile2LWCTIDComputer IDStringGeneric Edit150
42F41291ZLanded Cost Cache Table1IGCTIDComputer IDStringGeneric Edit150
43F41UI001Inventory Transactions Detail File1ITCTIDComputer IDStringGeneric Edit150
44F41UI003ABC Analysis Detail - Work File1AACTIDComputer IDStringGeneric Edit150
TOP41F: Apparel Management
45FCW105Fair Share Sprinkling Rate7WFCTIDComputer IDStringGeneric Edit150
46FCW31Proposal Order Line Details34LVCTIDComputer IDStringGeneric Edit150
47FCW69Work Order Parts List Issues10WPCTIDComputer IDStringGeneric Edit150
TOP42: Sales Management
48F40UI16Preference Print Message Work File1DSCTIDComputer IDStringGeneric Edit150
49F42565Invoice Print File1IWCTIDComputer IDStringGeneric Edit150
50F42A011Campaigns41CACTIDComputer IDStringGeneric Edit150
51F42A012Opportunity41OPCTIDComputer IDStringGeneric Edit150
52F42CSSCustomer Self Service Workfile9CSCTIDComputer IDStringGeneric Edit150
53F42UI005Sales Commission File54SCCTIDComputer IDStringGeneric Edit150
54F42UI01SO Header Cache File (MBF)1ZHCTIDComputer IDStringGeneric Edit150
55F42UI11SO Detail Cache File (MBF)1ZDCTIDComputer IDStringGeneric Edit150
56F42UI11CCustomer Self Service Shopping Cart Workfile1SCCTIDComputer IDStringGeneric Edit150
57F42UI12Sales Order Detail Cache 2 (MBF)1ZDCTIDComputer IDStringGeneric Edit150
58F42UI130Commitment Work File3ZCCTIDComputer IDStringGeneric Edit150
59F42UI150Sales Order Header Commission Information Work File2ZHCTIDComputer IDStringGeneric Edit150
60F42UI160Sales Order Detail Commission Information Work File2ZDCTIDComputer IDStringGeneric Edit150
61F42UI520Pick Slips Header File52S8CTIDComputer IDStringGeneric Edit150
62F42UI521Pick Slips Detail File135S9CTIDComputer IDStringGeneric Edit150
63F42UI800Sales Detail Work File - Sales Update1SDCTIDComputer IDStringGeneric Edit150
TOP42B: Sales Order Entry
64F42UI440Customer Segment Items - Work File15CSCTIDComputer IDStringGeneric Edit150
TOP42W: Fulfilment Management
65F4277720Fulfillment Rules Header13AHCTIDComputer IDStringGeneric Edit150
66F4277730Fulfillment Rules Detail17ADCTIDComputer IDStringGeneric Edit150
TOP43: Procurement
67F40910Commitment Integrity Report Work File2P#CTIDComputer IDStringGeneric Edit150
68F4301ZPO Header Work File1PACTIDComputer IDStringGeneric Edit150
69F43092ZReceipt Routing Work File1PVCTIDComputer IDStringGeneric Edit150
70F4311ZPurchase Order Generator File1PWCTIDComputer IDStringGeneric Edit150
71F43121ZReceiver workfile9PWCTIDComputer IDStringGeneric Edit150
72F43147Freight Distribution Workfile2FDCTIDComputer IDStringGeneric Edit150
73F4314ZVoucher Match Selection File1PNCTIDComputer IDStringGeneric Edit150
74F43632ZOpen Purchase Order by Item Work File4OICTIDComputer IDStringGeneric Edit150
75F4371Suggested Reorder Stock Items27PDCTIDComputer IDStringGeneric Edit150
76F43UI50CPO Print Clauses Table14WCCTIDComputer IDStringGeneric Edit150
77F43UI50DPO Print Detail Work File68PWCTIDComputer IDStringGeneric Edit150
78F43UI50HPO Print Header Work File63PACTIDComputer IDStringGeneric Edit150
TOP45: Advanced Pricing
79F4072WPrice Adjustment Detail Work File37ADCTIDComputer IDStringGeneric Edit150
80F40UI84Orders Affected by Price Change (Work-file)6XRCTIDComputer IDStringGeneric Edit150
81F4511WPricing Structure View1APCTIDComputer IDStringGeneric Edit150
82F45511WSearch Agent Directives Work File1SWCTIDComputer IDStringGeneric Edit150
TOP46R: RFID Outbound
83F46R010EPC Segment Definition16SDCTIDComputer IDStringGeneric Edit150
84F46R020EPC Manager Master16EMCTIDComputer IDStringGeneric Edit150
TOP47: Electronic Commerce
85F47003EDI Discrepancy Report Work File1SXCTIDComputer IDStringGeneric Edit150
86F47UI001ASN Extract Work File1SZCTIDComputer IDStringGeneric Edit150
TOP48: Work Order Processing
87F48UI001X4801 Master Business Function Workfile2WACTIDComputer IDStringGeneric Edit150
TOP49: Transportation Management
88F49110Transportation Bill of Lading Workfile6BWCTIDComputer IDStringGeneric Edit150
89F49111Carton Detail Shipment Workfile6CDCTIDComputer IDStringGeneric Edit150
90F49130Shipment Document Workfile4BWCTIDComputer IDStringGeneric Edit150
91F49140SSCC Print Label Workfile4BWCTIDComputer IDStringGeneric Edit150
92F49141Packing List Workfile4PWCTIDComputer IDStringGeneric Edit150
TOP74R: Russia
93F74RUI31VAT Sales Book Workfile - RUS - 03B35W1CTIDComputer IDStringGeneric Edit150
94F74RUI41VAT Purchase Book Workfile - RUS - 0436W1CTIDComputer IDStringGeneric Edit150
95F74RUI42VAT Purchase Book Workfile II - RUS - 0410W2CTIDComputer IDStringGeneric Edit150
TOP74W: Sweden
96F74W210A/P Automatic Payments Spot Rate - 74W8K5CTIDComputer IDStringGeneric Edit150
TOP74Z: Czech Republic
97F74ZUI02Czech VAT Report - CZE - 74Z - Work File17CZCTIDComputer IDStringGeneric Edit150
TOP75I: India
98F75I790Form ST-3 Working Table - IND - 092WTCTIDComputer IDStringGeneric Edit150
TOP76A: Argentina
99F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A2HFCTIDComputer IDStringGeneric Edit150
100F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A2HFCTIDComputer IDStringGeneric Edit150
101F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A2DLCTIDComputer IDStringGeneric Edit150
102F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A2DLCTIDComputer IDStringGeneric Edit150
103F76A20Credit Invoice Constants - ARG - 03B - 76A23ICCTIDComputer IDStringGeneric Edit150
104F76A21Credit Invoice Header - F76A21 - ARG - 3B - 76A26IHCTIDComputer IDStringGeneric Edit150
105F76A21PCredit Invoice Header Purge - ARG - 03B - 76A26IHCTIDComputer IDStringGeneric Edit150
106F76A22Credit Invoice Detail - F76A22 - ARG - 03B - 76A20IDCTIDComputer IDStringGeneric Edit150
107F76A22PCredit Invoice Detail Purge - ARG - 03B - 76A20IDCTIDComputer IDStringGeneric Edit150
108F76A23Credit Invoice Withholdings - F76A23 - ARG - 03B - 76A14IWCTIDComputer IDStringGeneric Edit150
109F76A23PCredit Invoice Withholdings Purge - ARG - 03B - 76A14IWCTIDComputer IDStringGeneric Edit150
110F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A35IECTIDComputer IDStringGeneric Edit150
111F76A25Credit Invoice Tax Area Relationship - ARG - 04 - 76A13IFCTIDComputer IDStringGeneric Edit150
112F76A26Credit Invoice Status Rules - ARG - 04 - 76A14IGCTIDComputer IDStringGeneric Edit150
113F76A8230Percentages by state / agreement Gross Income - ARG - - 76A14C1CTIDComputer IDStringGeneric Edit150
114F76A8231States members by Multilateral Agreement Gross Inc AR - 76A3C2CTIDComputer IDStringGeneric Edit150
115F76A8500Tag File F03B14 - ARG - 03B - 76A38TFCTIDComputer IDStringGeneric Edit150
116F76A8510Tag File F76A60 - ARG - 03B - 76A25TFCTIDComputer IDStringGeneric Edit150
117F76A85Z1Tag File F76A60 Batch Entry - ARG - 03B - 76A30BECTIDComputer IDStringGeneric Edit150
118F76AUI18Taxes - Tax amount by order line - Work File - ARG - - 76A2WFCTIDComputer IDStringGeneric Edit150
119F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A2HFCTIDComputer IDStringGeneric Edit150
120F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A2DLCTIDComputer IDStringGeneric Edit150
121F76AUI22WF - Legal Reports Errors - ARG - 03B - 76A2WFCTIDComputer IDStringGeneric Edit150
122F76AUI23Taxes - Totals by Tax Code - ARG - 42 - 76A2TWCTIDComputer IDStringGeneric Edit150
123F76AUI24Taxes Work File - ARG - 03B - 76A22TICTIDComputer IDStringGeneric Edit150
124F76AUI81Draft - Invoices Work File - ARG - 03B - 76A42WFCTIDComputer IDStringGeneric Edit150
125F76AUI82Draft - Drafts Work File - ARG - 03B - 03B33WFCTIDComputer IDStringGeneric Edit150
126F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A48WFCTIDComputer IDStringGeneric Edit150
127F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A2WFCTIDComputer IDStringGeneric Edit150
128F76AUI98Cost Account Work Table - Work in Progress Adjustment - 76A2CACTIDComputer IDStringGeneric Edit150
TOP76B: Brazil
129F76B0570Brazil Elect Rpt Block E Work table - BRA - 002WFCTIDComputer IDStringGeneric Edit150
130F76B0735Ato - Cotepe11 - Block E - Work File2WFCTIDComputer IDStringGeneric Edit150
TOP76C: Colombia
131F76C311TA/R Tag File - Recycle Recurring - COL - 03B - 76C5RPCTIDComputer IDStringGeneric Edit150
132F76CUI04Tax Detail for Distribution - Work File - COL - 76C65TDCTIDComputer IDStringGeneric Edit150
TOP76E: Ecuador
133F76E0018Print Withholding Workfile - EC - 042TDCTIDComputer IDStringGeneric Edit150
TOP76H: Chile
134F76HUI31Document Related Work File - CHI - 42 - 76H1DRCTIDComputer IDStringGeneric Edit150
135F76HUI32Workfile for R76H3B40 - CHI - 42 - 76H1WFCTIDComputer IDStringGeneric Edit150
136F76HUI33Workfile for R76H3B40 - CHI - 42 - 76H1WFCTIDComputer IDStringGeneric Edit150
137F76HUI34Order Related Work File - CHI - 42 - 76H2ORCTIDComputer IDStringGeneric Edit150
138F76HUI52Document Selection Work File - CHI - 42 - 76H1DRCTIDComputer IDStringGeneric Edit150
139F76HUI61Cache F76H3B1Z EDI Tag File - CHI - 03B - 76H2ZTCTIDComputer IDStringGeneric Edit150
TOP76P: Peru
140F76PUI45Workfile VAT Purchasing Ledger - PER - 04 - 76P1WFCTIDComputer IDStringGeneric Edit150
TOP79A: Greenhouse Gas Accounting
141F79AU11GHG Ledger Work Table1GRCTIDComputer IDStringGeneric Edit150
142F79AU21GHG Ledger Gas Work File1GWCTIDComputer IDStringGeneric Edit150
TOP89: Conversion Programs
143F32UI002Needed for upgrade from Xe and below1WYCTIDComputer IDStringGeneric Edit150