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

125 columns | Print definition?812 | 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
7F04UI0061099 Workfiles User Index6G1CTIDComputer IDStringGeneric Edit150
TOP09: General Accounting
8F0902Z1Account Balances - Batch File9GBCTIDComputer IDStringGeneric Edit150
9F09UI008Global Business Unit Change1GMCTIDComputer IDStringGeneric Edit150
10F09UI009Trial Balance Generic Work File - OneWorld ONLY2GBCTIDComputer IDStringGeneric Edit150
TOP15L: Adv Real Estate Forecasting
11F15L302AREF Prior Gross Billings1PGCTIDComputer IDStringGeneric Edit150
TOP16: Profit Management (EPS)
12F16UI001Enabled Tables by Application work file1CACTIDComputer IDStringGeneric Edit150
TOP30: Product Data Management
13F30UI008Bill of Material Comparison Work File2IJCTIDComputer IDStringGeneric Edit150
TOP31: Shop Floor Control
14F31UI002User Index - Variances21IGCTIDComputer IDStringGeneric Edit150
15F31UI006Line Scheduling Workbench - Work File1LSCTIDComputer IDStringGeneric Edit150
16F31UI427Labor Variance User Index2W1CTIDComputer IDStringGeneric Edit150
17F31UI802Accumulate Amounts by Account14WGCTIDComputer IDStringGeneric Edit150
18F31UI803Work File for Summarizing Journal Entries14SGCTIDComputer IDStringGeneric Edit150
19F31UI804Exception Report Work FIle12WRCTIDComputer IDStringGeneric Edit150
TOP31B: Blend Management
20F31B33DCDependency Chain Cache Structure2DTCTIDComputer IDStringGeneric Edit150
TOP32: Configuration Management
21F32UI002External Data Item Work File1WYCTIDComputer 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
33F40UI16Preference Print Message Work File1DSCTIDComputer IDStringGeneric Edit150
34F40UI17Allocation Work File1ZGCTIDComputer IDStringGeneric Edit150
35F40UI74Price Adjustment History Work File1AWCTIDComputer IDStringGeneric Edit150
36F40UI801Generic Error Table1ZBCTIDComputer 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
TOP42: Sales Management
45F42565Invoice Print File1IWCTIDComputer IDStringGeneric Edit150
46F42A011Campaigns41CACTIDComputer IDStringGeneric Edit150
47F42A012Opportunity41OPCTIDComputer IDStringGeneric Edit150
48F42CSSCustomer Self Service Workfile9CSCTIDComputer IDStringGeneric Edit150
49F42UI005Sales Commission File54SCCTIDComputer IDStringGeneric Edit150
50F42UI01SO Header Cache File (MBF)1ZHCTIDComputer IDStringGeneric Edit150
51F42UI11SO Detail Cache File (MBF)1ZDCTIDComputer IDStringGeneric Edit150
52F42UI11CCustomer Self Service Shopping Cart Workfile1SCCTIDComputer IDStringGeneric Edit150
53F42UI12Sales Order Detail Cache 2 (MBF)1ZDCTIDComputer IDStringGeneric Edit150
54F42UI130Commitment Work File3ZCCTIDComputer IDStringGeneric Edit150
55F42UI150Sales Order Header Commission Information Work File2ZHCTIDComputer IDStringGeneric Edit150
56F42UI160Sales Order Detail Commission Information Work File2ZDCTIDComputer IDStringGeneric Edit150
57F42UI520Pick Slips Header File52S8CTIDComputer IDStringGeneric Edit150
58F42UI521Pick Slips Detail File135S9CTIDComputer IDStringGeneric Edit150
59F42UI800Sales Detail Work File - Sales Update1SDCTIDComputer IDStringGeneric Edit150
TOP42B: Sales Order Entry
60F42UI440Customer Segment Items - Work File15CSCTIDComputer IDStringGeneric Edit150
TOP43: Procurement
61F40910Commitment Integrity Report Work File2P#CTIDComputer IDStringGeneric Edit150
62F4301ZPO Header Work File1PACTIDComputer IDStringGeneric Edit150
63F43092ZReceipt Routing Work File1PVCTIDComputer IDStringGeneric Edit150
64F4311ZPurchase Order Generator File1PWCTIDComputer IDStringGeneric Edit150
65F43121ZReceiver workfile9PWCTIDComputer IDStringGeneric Edit150
66F4314ZVoucher Match Selection File1PNCTIDComputer IDStringGeneric Edit150
67F43632ZOpen Purchase Order by Item Work File4OICTIDComputer IDStringGeneric Edit150
68F4371Suggested Reorder Stock Items27PDCTIDComputer IDStringGeneric Edit150
69F43UI50DPO Print Detail Work File68PWCTIDComputer IDStringGeneric Edit150
70F43UI50HPO Print Header Work File63PACTIDComputer IDStringGeneric Edit150
TOP45: Advanced Pricing
71F4072WPrice Adjustment Detail Work File37ADCTIDComputer IDStringGeneric Edit150
72F40UI84Orders Affected by Price Change (Work-file)6XRCTIDComputer IDStringGeneric Edit150
73F4511WPricing Structure View1APCTIDComputer IDStringGeneric Edit150
74F45511WSearch Agent Directives Work File1SWCTIDComputer IDStringGeneric Edit150
TOP46R: RFID Outbound
75F46R010EPC Segment Definition16SDCTIDComputer IDStringGeneric Edit150
76F46R020EPC Manager Master16EMCTIDComputer IDStringGeneric Edit150
TOP47: Electronic Commerce
77F47003EDI Discrepancy Report Work File1SXCTIDComputer IDStringGeneric Edit150
78F47UI001ASN Extract Work File1SZCTIDComputer IDStringGeneric Edit150
TOP48: Work Order Processing
79F48UI001X4801 Master Business Function Workfile2WACTIDComputer IDStringGeneric Edit150
TOP49: Transportation Management
80F49110Transportation Bill of Lading Workfile6BWCTIDComputer IDStringGeneric Edit150
81F49111Carton Detail Shipment Workfile6CDCTIDComputer IDStringGeneric Edit150
82F49130Shipment Document Workfile4BWCTIDComputer IDStringGeneric Edit150
83F49140SSCC Print Label Workfile4BWCTIDComputer IDStringGeneric Edit150
84F49141Packing List Workfile4PWCTIDComputer IDStringGeneric Edit150
TOP74W: Sweden - Reporting System Only
85F74W210A/P Automatic Payments Spot Rate - 74W8K5CTIDComputer IDStringGeneric Edit150
TOP76A: Argentina
86F76A0209Header and Footer Invoice/ShipmentNote History WF - ARG - 76A2HFCTIDComputer IDStringGeneric Edit150
87F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A2HFCTIDComputer IDStringGeneric Edit150
88F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A2DLCTIDComputer IDStringGeneric Edit150
89F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A2DLCTIDComputer IDStringGeneric Edit150
90F76A20Credit Invoice Constants - ARG - 03B - 76A23ICCTIDComputer IDStringGeneric Edit150
91F76A21Credit Invoice Header - F76A21 - ARG - 3B - 76A26IHCTIDComputer IDStringGeneric Edit150
92F76A21PCredit Invoice Header Purge - ARG - 03B - 76A26IHCTIDComputer IDStringGeneric Edit150
93F76A22Credit Invoice Detail - F76A22 - ARG - 03B - 76A20IDCTIDComputer IDStringGeneric Edit150
94F76A22PCredit Invoice Detail Purge - ARG - 03B - 76A20IDCTIDComputer IDStringGeneric Edit150
95F76A23Credit Invoice Withholdings - F76A23 - ARG - 03B - 76A14IWCTIDComputer IDStringGeneric Edit150
96F76A23PCredit Invoice Withholdings Purge - ARG - 03B - 76A14IWCTIDComputer IDStringGeneric Edit150
97F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A35IECTIDComputer IDStringGeneric Edit150
98F76A25Credit Invoice Tax Area Relationship - ARG - 04 - 76A13IFCTIDComputer IDStringGeneric Edit150
99F76A26Credit Invoice Status Rules - ARG - 04 - 76A14IGCTIDComputer IDStringGeneric Edit150
100F76A8230Percentages by state / agreement Gross Income - ARG - - 76A14C1CTIDComputer IDStringGeneric Edit150
101F76A8231States members by Multilateral Agreement Gross Inc AR - 76A3C2CTIDComputer IDStringGeneric Edit150
102F76A8500Tag File F03B14 - ARG - 03B - 76A38TFCTIDComputer IDStringGeneric Edit150
103F76A8510Tag File F76A60 - ARG - 03B - 76A25TFCTIDComputer IDStringGeneric Edit150
104F76A85Z1Tag File F76A60 Batch Entry - ARG - 03B - 76A30BECTIDComputer IDStringGeneric Edit150
105F76AUI18Taxes - Tax amount by order line - Work File - ARG - 422WFCTIDComputer IDStringGeneric Edit150
106F76AUI20Header and Footer Invoice/ShipmentNote Workfile - ARG - - 002HFCTIDComputer IDStringGeneric Edit150
107F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 002DLCTIDComputer IDStringGeneric Edit150
108F76AUI22WF - Legal Reports Errors - ARG - 002WFCTIDComputer IDStringGeneric Edit150
109F76AUI23Taxes - Totals by Tax Code - ARG2TWCTIDComputer IDStringGeneric Edit150
110F76AUI24Taxes Work File - ARG - 0022TICTIDComputer IDStringGeneric Edit150
111F76AUI81Draft - Invoices Work File - ARG - 03B - 76A42WFCTIDComputer IDStringGeneric Edit150
112F76AUI82Draft - Drafts Work File - ARG - 03B - 03B33WFCTIDComputer IDStringGeneric Edit150
113F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A48WFCTIDComputer IDStringGeneric Edit150
114F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A2WFCTIDComputer IDStringGeneric Edit150
115F76AUI98Cost Account Work Table - Work in Progress Adjustment - 76A2CACTIDComputer IDStringGeneric Edit150
TOP76C: Colombia
116F76C311TA/R Tag File - Recycle Recurring - COL - 03B - 76C5RPCTIDComputer IDStringGeneric Edit150
117F76CUI04Tax Detail for Distribution - Work File - COL - 76C65TDCTIDComputer IDStringGeneric Edit150
TOP76E: Ecuador
118F76E0018Print Withholding Workfile - EC - 042TDCTIDComputer IDStringGeneric Edit150
TOP76H: Chile
119F76HUI31Document Related Work File - CHI - 42 - 76H1DRCTIDComputer IDStringGeneric Edit150
120F76HUI32Workfile for R76H3B40 - CHI - 42 - 76H1WFCTIDComputer IDStringGeneric Edit150
121F76HUI33Workfile for R76H3B40 - CHI - 42 - 76H1WFCTIDComputer IDStringGeneric Edit150
122F76HUI34Order Related Work File - CHI - 42 - 76H2ORCTIDComputer IDStringGeneric Edit150
123F76HUI52Document Selection Work File - CHI - 42 - 76H1DRCTIDComputer IDStringGeneric Edit150
124F76HUI61Cache F76H3B1Z EDI Tag File - CHI - 03B - 76H2ZTCTIDComputer IDStringGeneric Edit150
TOP76P: Peru
125F76PUI45Workfile VAT Purchasing Ledger - PER - 04 - 76P1WFCTIDComputer IDStringGeneric Edit150