JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

129 columns | Print definition?910 | EV01

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F01RS12WPCFGTV Role Public Data4TREV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP05: Time Accounting and HRM Base
2F054101Employee Personal Profile Information History Table46EHEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
3F054101WEmployee Personal Profile Information Work Table47EPEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
4F086011Establishment Information11COEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP07: Payroll
5F0701731Compensation Overrides5YCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
6F0701735Pretax Deduction Overrides4YCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
7F078507ADP Employee Additional Information3YEEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
8F8907422New Hire Detail File - Massachusetts (22)2MAEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
9F8907427New Hire Detail File - Montana (27)2MTEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP08B: Benefits Administration
10F08320DPlan Master Tag Table17PDEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
11F08320XPlan Name Conversion3PXEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP08H: Health and Safety
12F08601BInjury/Illness Case Master Tag Table3ITEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
13F08601CAdditional Health and Safety Information11PIEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP08R: Recruitment Management - (Appl. Track. & Req.)
14F08401WFApplicant Work File45XNEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP09: General Accounting
15F09UI007Match Bank Tape to Recon File - ONE WORLD ONLY8GLEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
16F09UI123Advanced Variable Numerator Worktable27VWEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP09E: Expense Reimbursment
17F09E109Expense Category Setup7PCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP15: Property Management
18F1514WArea Work File5NWEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
19F15525WPM Statements Credit/Cash Build Workfile17RTEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
20F8915CV2Property Management Table Conversion Detail Audit5N9EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP16: Profit Management (EPS)
21F1603Cost Analyzer View Structure20CVEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
22F1630Driver Definitions32CDEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP30: Product Data Management
23F3016TKanban Master Tag Table4KMEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
24F30UI010Bill Of Material Work File3WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP30A: Product Costing
25F30UI011Work File for Cost Component20CCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP31: Shop Floor Control
26F31UI006Line Scheduling Workbench - Work File21LSEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
27F31UI802Accumulate Amounts by Account3WGEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
28F31UI803Work File for Summarizing Journal Entries3SGEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP31B: Blend Management
29F31B25QA History Results Workfile24TREV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
30F31B60Operation Trace Track Workfile44OTEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP34: Requirements Planning
31F34A70Last Outbound Work Order Table7OWEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
32F34UI003MPS Time Series User Index2M8EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
33F34UI004MPS Net Change User Index13M8EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP34A: Advanced Planning & Scheduling
34F34A10APS Integration Constants31N0EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
35F34A60Last Outbound Purchase Order/Transfer Order10OBEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP35: Enterprise Facility Planning
36F35UI001MPS/MRP Planning - Multiple Plant User Index7MAEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP39: Advanced Stock Valuation
37F39120Temporary Period Build File for Stock Valuation7TFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP40: Inventory/OP Base
38F30UI006Lot Tracking Work File19ILEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
39F40205Line Type Control Constants File31LFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP41F: Apparel Management
40FCW08Category Codes Work File2WKEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
41FCW09Item Revisions Work File2WREV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
42FCW10Item Branch Work File3WBEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
43FCW11Item Base Price File Work File2WPEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
44FCW12Item Cost File Work File2WCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
45FCW13Item Location Work File2WLEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
46FCW14Item Master Tag Work File2WTEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
47FCW15Work File F411712WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
48FCW16Work File F40162WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
49FCW17Work File F410022WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
50FCW18Work File F490752WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
51FCW19Work File F460102WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
52FCW22Lot Master Work File2WLEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
53FCW32Item Shipping Information (F4908) Work File2WSEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
54FCW57Work File Additional System Information (F4101)2WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
55FCW58Item Master - Service/Warranty Extension (F4117) Work File2WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
56FCW59Bulk Item Master (F41011) Work File2WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
57FCW62Compositions (FCW60) Work File2WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
58FCW63Additional Style Item Information Work File2WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
59FCW83Work File F430902PCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
60FCW85Item Cost Component Add Ons Work File2IEEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
61FCW86BOM Quantity Work File1WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP42: Sales Management
62F42UI800Sales Detail Work File - Sales Update65SDEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP43: Procurement
63F43121ZReceiver workfile197PWEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP43E: Requisition Self Service
64F43E20WFeReq - Shopping Cart Work File36SWEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP45: Advanced Pricing
65F4575TMPShip and Debit History - Temp Table85AHEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP46L: License Plating
66F46LUI03Assign/Remove Child LP Work File4WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP47: Electronic Commerce
67F47CTLEDI Lockbox/Payment Work File10Z5EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP48: Work Order Processing
68F48714WWork Order Mass Update Workfile3MUEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
69F48UI001X4801 Master Business Function Workfile132WAEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP51: Job Costing
70F51006XCM Project Cross Reference4CMEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP55: Reserved for Clients
71F74H1050Invoicing Workfile Header - New14IHEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
72F74H105SSlovakian Invoice Accounting Summary3ASEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
73F74T550BGeneral Ledger PO Work File - Turkish15POEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP74: EMEA Localization
74F7400C2AFrench VAT on A/R3FCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
75F7400C3French VAT on A/P3TGEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
76F74101WAdditional Address Book & Vat Id Info Work File - EU - 0113VWEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP74B: Begium Localization
77F7403B11Belgium - Work File Yearly Vat Declaration Data6QAEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP74R: CIS
78F74R9029Open Accounts - RUS - 09 - 74R18OAEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
79F74RUI31VAT Sales Book Workfile - RUS - 03B31W1EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
80F74RUI41VAT Purchase Book Workfile - RUS - 0432W1EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP74U: United Kingdom Localizations
81F74U0120CiS Supp F0411 Tag File - UK - 046MVEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
82F74U0121CIS PO Transaction Tag File - UK - 046MPEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
83F74U03BTLease Master Alternative UOM Tag File - 1512PFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
84F74U0408SPC Lower Level Retention - UK - 436LREV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
85F74U0409SPC Lower Level MCD - UK - 436LMEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
86F74U0412Application Commitment Workfile - UK - 4332ACEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
87F74U0414Certificate Commitment Workfile - UK - 4332CCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
88F74U0416Purchase Order Commitment Workfile - UK - 4332PCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
89F74U203BBilling Pattern - Weekly - 156P5EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
90F74UCW03CIS Voucher Match Workfile - UK - 045VMEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP74Y: Italy - Reporting System Only
91F74YUI01Italy Legal Company WF - ITA - 74Y19LCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP75I: India
92F75I303Excise - ARE1 Bond Master-IND-75I11Q2EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
93F75I3051Excise Fiscal Years11FYEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
94F75I344YPrint ARE-1Bond Register-IND-0015CDEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
95F75I348CT2/CT3 Annexure Certificate Master-IND-008CTEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
96F75I382Amount of Interest Paid per month - IND - 0020IPEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
97F75I601TCS Register Details-IND-4232TREV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
98F75I611TCS Prepayment Transaction File - IND-03B33TTEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
99F75I754Advance Service Tax Payment File - IND -0413APEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
100F75I760Advance Service Tax Balance File - IND26ABEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
101F75I790TST-3 Section 5A - 5AA and 5B Setup file3SFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
102F75IUI7Service Tax Credit Register - Work File - IND24WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP76A: Argentina
103F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A8HFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
104F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A8HFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
105F76A10Taxes - Tax Definition - ARG - 00 - 76A23TDEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
106F76A42CERG G/L - Work File - ARG - 09 - 76A7TFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
107F76A48CERG A/P - Control Payments -ARG - 04 - 76A2PIEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
108F76A49CERG A/R - Control Receipts - ARG - 03B - 76A2CREV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
109F76A715Prenumbered Invoice / Shipment Note Print - ARG - 42 - 76A5PIEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
110F76A8030Taxes - Minimun Tax By Invoice - ARG - 03B - 76A5MTEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
111F76A8500Tag File F03B14 - ARG - 03B - 76A26TFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
112F76A8510Tag File F76A60 - ARG - 03B - 76A20TFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
113F76A85Z1Tag File F76A60 Batch Entry - ARG - 03B - 76A25BEEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
114F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A8HFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
115F76AUI44CERG A/P - Worktable - ARG - 04 - 76A1WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
116F76AUI46CERG A/R -Work File - ARG - 03B - 76A1WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
117F76AUI81Draft - Invoices Work File - ARG - 03B - 76A21WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
118F76AUI82Draft - Drafts Work File - ARG - 03B - 03B20WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP76B: Brazil - Reporting System Only
119F76B0735Ato - Cotepe11 - Block E - Work File12WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
120F76B4100Withholding Data Conversion Status - BR - 042PSEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP76H: Chile
121F76H3B30Print Template Definition for Legal Documents - CHI - - 76H3PTEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
122F76H3B32Legal Document Detail (Print Info) - CHI - 03B - 76H5PIEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP89: Conversion Programs
123F89701List of Data Items Not Used in FDA6PBEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
124F89702List of Data Items Not Used in RDA6PBEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOPH90: ONEWORLD TOOLS
125F012504Focus Registration15FOEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
126F907012Event Request Definition5RDEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOPH92: Interactive Engine/OL
127F98231DOMW Transfer Activity Rule Director - Detail12TDEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
128F98231HOMW Transfer Activity Rule Director - Header9TREV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOPH96U: Upgrade
129F9672Software Update Pathcode Information9SUEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10