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

154 columns | Print definition?812 | JOBS

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00UI391Generated Document Work Table2GWJOBSJob NumberNumericGeneric Edit80
2F00UI392Text Substitution Work Table1GWJOBSJob NumberNumericGeneric Edit80
3F00UI393Bookmark Work Table2GWJOBSJob NumberNumericGeneric Edit80
TOP03B: Enhanced Accounts Receivable
4F03BUI05Auto Receipts Batch Workfile2R5JOBSJob NumberNumericGeneric Edit80
TOP04: Accounts Payable
5F04UI0061099 Workfiles User Index5G1JOBSJob NumberNumericGeneric Edit80
TOP05: Time Accounting and HRM Base
6F05005Generic UBE File1GFJOBSJob NumberNumericGeneric Edit80
7F05152WFResults Work File1WFJOBSJob NumberNumericGeneric Edit80
8F05153WFResults Work File Competency Detail1WFJOBSJob NumberNumericGeneric Edit80
9F05154WFResults Work File Competency Words Detail1WFJOBSJob NumberNumericGeneric Edit80
TOP08: Human Resources
10F087721CBPA Appraisal Creation Work File1XPJOBSJob NumberNumericGeneric Edit80
11F08JDWF1Job Description Changes Integration Work File1JCJOBSJob NumberNumericGeneric Edit80
TOP08B: Benefits Administration
12F08380WFBatch Enrollment Work File1BEJOBSJob NumberNumericGeneric Edit80
13F08381WFRecalculate Plan Option Costs1RCJOBSJob NumberNumericGeneric Edit80
TOP08H: Health and Safety
14F086400Injury/Illness Establishment Detail Information1ORJOBSJob NumberNumericGeneric Edit80
15F086401Injury/Illness Report Header Information2RHJOBSJob NumberNumericGeneric Edit80
TOP08R: Recruitment Management - (Appl. Track. & Req.)
16F08401WFApplicant Work File2XNJOBSJob NumberNumericGeneric Edit80
TOP09: General Accounting
17F09UI008Global Business Unit Change2GMJOBSJob NumberNumericGeneric Edit80
18F09UI009Trial Balance Generic Work File - OneWorld ONLY1GBJOBSJob NumberNumericGeneric Edit80
19F09UI017Cash Forecast Detail4FWJOBSJob NumberNumericGeneric Edit80
20F09UI618Auto Bank Statement Process Work Table38NBJOBSJob NumberNumericGeneric Edit80
21F70UI001Work File for G/L by Cat. Code Localization30WAJOBSJob NumberNumericGeneric Edit80
TOP10: Financial Reporting
22F10UI520Cash Flow Statement Worktable9CWJOBSJob NumberNumericGeneric Edit80
TOP11C: Cash Basis
23F11CUI01A/R Cash Basis Work File1CBJOBSJob NumberNumericGeneric Edit80
24F11CUI02A/P Cash Basis Work File1CBJOBSJob NumberNumericGeneric Edit80
TOP16: Profit Management (EPS)
25F16UI001Enabled Tables by Application work file2CAJOBSJob NumberNumericGeneric Edit80
TOP30: Product Data Management
26F30UI008Bill of Material Comparison Work File1IJJOBSJob NumberNumericGeneric Edit80
TOP31: Shop Floor Control
27F31UI002User Index - Variances18IGJOBSJob NumberNumericGeneric Edit80
28F31UI006Line Scheduling Workbench - Work File2LSJOBSJob NumberNumericGeneric Edit80
29F31UI427Labor Variance User Index1W1JOBSJob NumberNumericGeneric Edit80
30F31UI802Accumulate Amounts by Account13WGJOBSJob NumberNumericGeneric Edit80
31F31UI803Work File for Summarizing Journal Entries13SGJOBSJob NumberNumericGeneric Edit80
32F31UI804Exception Report Work FIle11WRJOBSJob NumberNumericGeneric Edit80
TOP31B: Blend Management
33F31B0800F31B0800 Recalculation Error Handling4REJOBSJob NumberNumericGeneric Edit80
34F31B33DCDependency Chain Cache Structure1DTJOBSJob NumberNumericGeneric Edit80
TOP32: Configuration Management
35F32UI002External Data Item Work File2WYJOBSJob NumberNumericGeneric Edit80
TOP33: Capacity Planning
36F33UI001Shop Floor Control Routing Instructions25WLJOBSJob NumberNumericGeneric Edit80
TOP34: Requirements Planning
37F34UI003MPS Time Series User Index65M8JOBSJob NumberNumericGeneric Edit80
38F34UI004MPS Net Change User Index1M8JOBSJob NumberNumericGeneric Edit80
39F34UI005MRP Orders/Requirements User Index-Process Item1F5JOBSJob NumberNumericGeneric Edit80
40F34UI006MRP Co/By Product Net Quantity User Index1W6JOBSJob NumberNumericGeneric Edit80
TOP35: Enterprise Facility Planning
41F35UI001MPS/MRP Planning - Multiple Plant User Index1MAJOBSJob NumberNumericGeneric Edit80
TOP40: Inventory/OP Base
42F30UI001Component Locators Work File2WFJOBSJob NumberNumericGeneric Edit80
43F30UI006Lot Tracking Work File2ILJOBSJob NumberNumericGeneric Edit80
44F40UI16Preference Print Message Work File2DSJOBSJob NumberNumericGeneric Edit80
45F40UI17Allocation Work File2ZGJOBSJob NumberNumericGeneric Edit80
46F40UI74Price Adjustment History Work File2AWJOBSJob NumberNumericGeneric Edit80
47F40UI801Generic Error Table2ZBJOBSJob NumberNumericGeneric Edit80
TOP40R: Demand Scheduling
48F40R12WFCUM Rollback Workfile1CQJOBSJob NumberNumericGeneric Edit80
49F40R30WFDemand Work File2DSJOBSJob NumberNumericGeneric Edit80
50F47UI002ASN Extract Packaging Work File2SPJOBSJob NumberNumericGeneric Edit80
TOP40S: Supply Chain Self Service
51F4947SWSelf-Service Shipment Tracking Work File1SWJOBSJob NumberNumericGeneric Edit80
TOP41: Inventory Management
52F41021WFF41021 Transaction Workfile1LWJOBSJob NumberNumericGeneric Edit80
53F41291ZLanded Cost Cache Table2IGJOBSJob NumberNumericGeneric Edit80
54F41UI001Inventory Transactions Detail File2ITJOBSJob NumberNumericGeneric Edit80
TOP42: Sales Management
55F42565Invoice Print File2IWJOBSJob NumberNumericGeneric Edit80
56F42CSSCustomer Self Service Workfile3CSJOBSJob NumberNumericGeneric Edit80
57F42UI005Sales Commission File53SCJOBSJob NumberNumericGeneric Edit80
58F42UI01SO Header Cache File (MBF)2ZHJOBSJob NumberNumericGeneric Edit80
59F42UI11SO Detail Cache File (MBF)2ZDJOBSJob NumberNumericGeneric Edit80
60F42UI11CCustomer Self Service Shopping Cart Workfile4SCJOBSJob NumberNumericGeneric Edit80
61F42UI12Sales Order Detail Cache 2 (MBF)2ZDJOBSJob NumberNumericGeneric Edit80
62F42UI130Commitment Work File4ZCJOBSJob NumberNumericGeneric Edit80
63F42UI150Sales Order Header Commission Information Work File1ZHJOBSJob NumberNumericGeneric Edit80
64F42UI160Sales Order Detail Commission Information Work File1ZDJOBSJob NumberNumericGeneric Edit80
65F42UI520Pick Slips Header File53S8JOBSJob NumberNumericGeneric Edit80
66F42UI521Pick Slips Detail File136S9JOBSJob NumberNumericGeneric Edit80
67F42UI800Sales Detail Work File - Sales Update2SDJOBSJob NumberNumericGeneric Edit80
TOP42B: Sales Order Entry
68F42UI440Customer Segment Items - Work File14CSJOBSJob NumberNumericGeneric Edit80
TOP43: Procurement
69F4301ZPO Header Work File2PAJOBSJob NumberNumericGeneric Edit80
70F43092ZReceipt Routing Work File2PVJOBSJob NumberNumericGeneric Edit80
71F4311ZPurchase Order Generator File2PWJOBSJob NumberNumericGeneric Edit80
72F43121ZReceiver workfile8PWJOBSJob NumberNumericGeneric Edit80
73F4314ZVoucher Match Selection File2PNJOBSJob NumberNumericGeneric Edit80
74F43632ZOpen Purchase Order by Item Work File1OIJOBSJob NumberNumericGeneric Edit80
TOP44H: Homebuilder Management
75F44H401WOption Master Work File1OWJOBSJob NumberNumericGeneric Edit80
76F44H501WSales Statistics Work Table1SSJOBSJob NumberNumericGeneric Edit80
77F44H602WTake Off Summary Workfile1TSJOBSJob NumberNumericGeneric Edit80
78F44H604WVendor Assignment Workfile1VWJOBSJob NumberNumericGeneric Edit80
79F44H611WBid Details Work File1BWJOBSJob NumberNumericGeneric Edit80
80F44H711Lot Start Workfile12SWJOBSJob NumberNumericGeneric Edit80
81F44H711ZHB Lot Start Unedited Transaction File25SZJOBSJob NumberNumericGeneric Edit80
82F44H73W1Lot Start - P.O. / Committment Generation Work File1CGJOBSJob NumberNumericGeneric Edit80
83F44H73W2Lot Start - Budget Generation Workfile1BGJOBSJob NumberNumericGeneric Edit80
84F44H902WBudget Creation Workfile1WFJOBSJob NumberNumericGeneric Edit80
TOP45: Advanced Pricing
85F4072WPrice Adjustment Detail Work File38ADJOBSJob NumberNumericGeneric Edit80
86F40UI84Orders Affected by Price Change (Work-file)5XRJOBSJob NumberNumericGeneric Edit80
87F4511WPricing Structure View2APJOBSJob NumberNumericGeneric Edit80
88F45511WSearch Agent Directives Work File2SWJOBSJob NumberNumericGeneric Edit80
TOP46L: License Plating
89F46LUI01Assign/Remove Items To LP Work File2WFJOBSJob NumberNumericGeneric Edit80
90F46LUI02Work Table for Manual Build UOM Structure1LPJOBSJob NumberNumericGeneric Edit80
91F46LUI03Assign/Remove Child LP Work File2WFJOBSJob NumberNumericGeneric Edit80
TOP47: Electronic Commerce
92F47003EDI Discrepancy Report Work File2SXJOBSJob NumberNumericGeneric Edit80
93F47UI001ASN Extract Work File2SZJOBSJob NumberNumericGeneric Edit80
TOP48: Work Order Processing
94F48UI001X4801 Master Business Function Workfile1WAJOBSJob NumberNumericGeneric Edit80
TOP49: Transportation Management
95F49110Transportation Bill of Lading Workfile7BWJOBSJob NumberNumericGeneric Edit80
96F49130Shipment Document Workfile5BWJOBSJob NumberNumericGeneric Edit80
97F49141Packing List Workfile5PWJOBSJob NumberNumericGeneric Edit80
TOP53: Change Management
98F5301BZ1Change Request Master Table Workfile1DIJOBSJob NumberNumericGeneric Edit80
99F5311Z1Change Request Details Table Workfile1DKJOBSJob NumberNumericGeneric Edit80
TOP55: Reserved for Clients
100F74H1001Hierarchical Summary Work Table1HWJOBSJob NumberNumericGeneric Edit80
101F74H1006BalanceandPL Work Table1BWJOBSJob NumberNumericGeneric Edit80
102F74H1009Intrastat - Small Transaction Work Table1ISJOBSJob NumberNumericGeneric Edit80
103F74H1050Invoicing Workfile Header - New1IHJOBSJob NumberNumericGeneric Edit80
104F74H1051Invoicing Workfile - New1IWJOBSJob NumberNumericGeneric Edit80
105F74H1052Tax Summary Work Table - New1TSJOBSJob NumberNumericGeneric Edit80
106F74H1054Invoiced Order Lines - Work1IOJOBSJob NumberNumericGeneric Edit80
107F74H1055Invoicing Selection Work Table1ISJOBSJob NumberNumericGeneric Edit80
108F74H1056Invoicing Additional References1ARJOBSJob NumberNumericGeneric Edit80
109F74H1057Invoice Line Pricing Information1IPJOBSJob NumberNumericGeneric Edit80
110F74H1058Invoice Lines - SO Details1IOJOBSJob NumberNumericGeneric Edit80
111F74H105AInvoice References - Extended1ARJOBSJob NumberNumericGeneric Edit80
112F74H105SSlovakian Invoice Accounting Summary1ASJOBSJob NumberNumericGeneric Edit80
113F74HS006BalanceandPL Work Table Slovakian1BWJOBSJob NumberNumericGeneric Edit80
TOP74: EMEA Localization
114F74UI90WF - Report Detail - EMEA - 741RDJOBSJob NumberNumericGeneric Edit80
115F74UI91WF - Account Detail - EMEA - 741ADJOBSJob NumberNumericGeneric Edit80
116F74UI92WF - Account Cell Value - EMEA - 741CVJOBSJob NumberNumericGeneric Edit80
117F74UI93WF - Cost Center Detail - EMEA - 741CDJOBSJob NumberNumericGeneric Edit80
118F74UI94WF - Cost Center Detail by Company - EMEA - 741CCJOBSJob NumberNumericGeneric Edit80
119F74UI95WF - Report History - EMEA - 741RHJOBSJob NumberNumericGeneric Edit80
TOP75C: China - Reporting System Only
120F75C04Z1China A/P tax interface file to JinSui1CTJOBSJob NumberNumericGeneric Edit80
121F75C09Z1GUI cancel printing invoice-Jinsui - China1FFJOBSJob NumberNumericGeneric Edit80
122F75CUI1China Financial Report Work File - 103CFJOBSJob NumberNumericGeneric Edit80
123F75CUI2China Financial Report Staging Work File - 103CFJOBSJob NumberNumericGeneric Edit80
TOP76A: Argentina
124F76A0209Header and Footer Invoice/ShipmentNote History WF - ARG - 76A1HFJOBSJob NumberNumericGeneric Edit80
125F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A1HFJOBSJob NumberNumericGeneric Edit80
126F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A1DLJOBSJob NumberNumericGeneric Edit80
127F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A1DLJOBSJob NumberNumericGeneric Edit80
128F76A08Credit Invoice Payments - ARG - 0029CFJOBSJob NumberNumericGeneric Edit80
129F76A8500Tag File F03B14 - ARG - 03B - 76A39TFJOBSJob NumberNumericGeneric Edit80
130F76A8510Tag File F76A60 - ARG - 03B - 76A26TFJOBSJob NumberNumericGeneric Edit80
131F76A85Z1Tag File F76A60 Batch Entry - ARG - 03B - 76A31BEJOBSJob NumberNumericGeneric Edit80
132F76AUI18Taxes - Tax amount by order line - Work File - ARG - 421WFJOBSJob NumberNumericGeneric Edit80
133F76AUI20Header and Footer Invoice/ShipmentNote Workfile - ARG - - 001HFJOBSJob NumberNumericGeneric Edit80
134F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 001DLJOBSJob NumberNumericGeneric Edit80
135F76AUI22WF - Legal Reports Errors - ARG - 001WFJOBSJob NumberNumericGeneric Edit80
136F76AUI23Taxes - Totals by Tax Code - ARG1TWJOBSJob NumberNumericGeneric Edit80
137F76AUI24Taxes Work File - ARG - 0021TIJOBSJob NumberNumericGeneric Edit80
138F76AUI81Draft - Invoices Work File - ARG - 03B - 76A41WFJOBSJob NumberNumericGeneric Edit80
139F76AUI82Draft - Drafts Work File - ARG - 03B - 03B34WFJOBSJob NumberNumericGeneric Edit80
140F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A47WFJOBSJob NumberNumericGeneric Edit80
141F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A1WFJOBSJob NumberNumericGeneric Edit80
142F76AUI98Cost Account Work Table - Work in Progress Adjustment - 76A1CAJOBSJob NumberNumericGeneric Edit80
TOP76C: Colombia
143F76C311TA/R Tag File - Recycle Recurring - COL - 03B - 76C6RPJOBSJob NumberNumericGeneric Edit80
144F76CUI04Tax Detail for Distribution - Work File - COL - 76C66TDJOBSJob NumberNumericGeneric Edit80
TOP76E: Ecuador
145F76E0018Print Withholding Workfile - EC - 041TDJOBSJob NumberNumericGeneric Edit80
TOP76H: Chile
146F76HUI31Document Related Work File - CHI - 42 - 76H2DRJOBSJob NumberNumericGeneric Edit80
147F76HUI32Workfile for R76H3B40 - CHI - 42 - 76H2WFJOBSJob NumberNumericGeneric Edit80
148F76HUI33Workfile for R76H3B40 - CHI - 42 - 76H2WFJOBSJob NumberNumericGeneric Edit80
149F76HUI34Order Related Work File - CHI - 42 - 76H1ORJOBSJob NumberNumericGeneric Edit80
150F76HUI52Document Selection Work File - CHI - 42 - 76H2DRJOBSJob NumberNumericGeneric Edit80
151F76HUI61Cache F76H3B1Z EDI Tag File - CHI - 03B - 76H1ZTJOBSJob NumberNumericGeneric Edit80
TOP76P: Peru
152F76PUI45Workfile VAT Purchasing Ledger - PER - 04 - 76P2WFJOBSJob NumberNumericGeneric Edit80
TOPD3N: dcLINK (data collection) - DSI
153FD3N120TAsset Number Work File1FAJOBSJob NumberNumericGeneric Edit80
154FD3N4116dcLINK Interface - Inventory Reclassification5IRJOBSJob NumberNumericGeneric Edit80