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

131 columns | Print definition?920 | 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
5F055011WAuto Deposit Instructions Work File21ADEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
6F0701731Compensation Overrides5YCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
7F0701735Pretax Deduction Overrides4YCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
8F078507ADP Employee Additional Information3YEEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
9F078510ADP Quarterly Integrity Report5VREV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
10F8907422New Hire Detail File - Massachusetts (22)2MAEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
11F8907427New Hire Detail File - Montana (27)2MTEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP08B: Benefits Administration
12F08320DPlan Master Tag Table17PDEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
13F08320XPlan Name Conversion3PXEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP08H: Health and Safety
14F08601BInjury/Illness Case Master Tag Table3ITEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
15F08601CAdditional Health and Safety Information11PIEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP08R: Recruitment Management - (Appl. Track. & Req.)
16F08401WFApplicant Work File45XNEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP09: General Accounting
17F09UI007Match Bank Tape to Recon File - ONE WORLD ONLY8GLEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
18F09UI123Advanced Variable Numerator Worktable27VWEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP09E: Expense Reimbursment
19F09E109Expense Category Setup7PCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP15: Real Estate Management
20F1514WArea Work File5NWEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
21F15525WPM Statements Credit/Cash Build Workfile17RTEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
22F8915CV2Property Management Table Conversion Detail Audit5N9EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP16: Profit Management (EPS)
23F1603Cost Analyzer View Structure20CVEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
24F1630Driver Definitions32CDEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP30: Product Data Management
25F3016TKanban Master Tag Table4KMEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
26F30UI010Bill Of Material Work File3WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP30A: Product Costing
27F30UI011Work File for Cost Component20CCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP31: Shop Floor Control
28F31UI006Line Scheduling Workbench - Work File21LSEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
29F31UI802Accumulate Amounts by Account3WGEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
30F31UI803Work File for Summarizing Journal Entries3SGEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP31A: Manufacturing Accounting
31F30UI003WIP Revaluation Work File20WREV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP31B: Blend Management
32F31B25QA History Results Workfile24TREV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
33F31B60Operation Trace Track Workfile44OTEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP34: Requirements Planning
34F34A70Last Outbound Work Order Table7OWEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
35F34UI003MPS Time Series User Index2M8EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
36F34UI004MPS Net Change User Index13M8EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP34A: Advanced Planning & Scheduling
37F34A10APS Integration Constants31N0EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
38F34A60Last Outbound Purchase Order/Transfer Order10OBEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP35: Enterprise Facility Planning
39F35UI001MPS/MRP Planning - Multiple Plant User Index7MAEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP39: Advanced Stock Valuation
40F39120Temporary Period Build File for Stock Valuation7TFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP40: Inventory/OP Base
41F30UI006Lot Tracking Work File19ILEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
42F40205Line Type Control Constants File31LFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP41F: Apparel Management
43FCW08Category Codes Work File2WKEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
44FCW09Item Revisions Work File2WREV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
45FCW10Item Branch Work File3WBEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
46FCW11Item Base Price File Work File2WPEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
47FCW12Item Cost File Work File2WCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
48FCW13Item Location Work File2WLEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
49FCW14Item Master Tag Work File2WTEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
50FCW15Work File F411712WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
51FCW16Work File F40162WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
52FCW17Work File F410022WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
53FCW18Work File F490752WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
54FCW19Work File F460102WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
55FCW22Lot Master Work File2WLEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
56FCW32Item Shipping Information (F4908) Work File2WSEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
57FCW57Work File Additional System Information (F4101)2WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
58FCW58Item Master - Service/Warranty Extension (F4117) Work File2WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
59FCW59Bulk Item Master (F41011) Work File2WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
60FCW62Compositions (FCW60) Work File2WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
61FCW63Additional Style Item Information Work File2WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
62FCW83Work File F430902PCEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
63FCW85Item Cost Component Add Ons Work File2IEEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
64FCW86BOM Quantity Work File1WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP42: Sales Management
65F42UI800Sales Detail Work File - Sales Update65SDEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP43: Procurement
66F43121ZReceiver workfile197PWEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP43E: Requisition Self Service
67F43E20WFeReq - Shopping Cart Work File36SWEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP45: Advanced Pricing
68F4575TMPShip and Debit History - Temp Table85AHEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP46L: License Plating
69F46LUI03Assign/Remove Child LP Work File4WFEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP47: Electronic Commerce
70F47CTLEDI Lockbox/Payment Work File10Z5EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP48: Work Order Processing
71F48714WWork Order Mass Update Workfile3MUEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
72F48UI001X4801 Master Business Function Workfile132WAEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP51: Job Costing
73F51006XCM Project Cross Reference4CMEV01J.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: Russia
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
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
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
TOP77: Payroll (Canadian)
123F77110Canadian Year-End Sequential Number Setup10J9EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
124F77200ACanadian Employee Year-End Form Header (Additional)11J5EV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOP89: Conversion Programs
125F89701List of Data Items Not Used in FDA6PBEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
126F89702List of Data Items Not Used in RDA6PBEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOPH90: EnterpriseOne TOOLS
127F012504Focus Registration15FOEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
128F907012Event Request Definition5RDEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOPH92: Interactive Engine/OL
129F98231DOMW Transfer Activity Rule Director - Detail12TDEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
130F98231HOMW Transfer Activity Rule Director - Header9TREV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10
TOPH96U: Upgrade
131F9672Software Update Pathcode Information9SUEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10