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
4F4211SDSales Order Detail File
5F4311PDPurchase Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

92 tables812 | 05

05: Time Accounting and HRM Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F05005GF211Generic UBE FileFiles05: Time Accounting and HRM Base
2812F05100CM112Resource CompetencyMaster Files05: Time Accounting and HRM BaseNo
3812F05100Z1CU282Resource Competencies Unedited Transactions FileFiles05: Time Accounting and HRM Base
4812F05101CY142Course MasterMaster Files05: Time Accounting and HRM BaseNo
5812F05102SM226Goal MasterMaster Files05: Time Accounting and HRM BaseNo
6812F05103AM91Scale MasterMaster Files05: Time Accounting and HRM BaseNo
7812F05104CM111Competency MasterMaster Files05: Time Accounting and HRM BaseNo
8812F05105GS153Goal SuggestionsFiles05: Time Accounting and HRM BaseBusiness Data
9812F05106CU91Competency Update EventsFiles05: Time Accounting and HRM BaseNo
10812F05107CU91Competency Update Approval RoutingFiles05: Time Accounting and HRM BaseNo
11812F05107ACU101Competency Update Approval Routing Tag FileFiles05: Time Accounting and HRM Base
12812F05108UT151Unconfirmed Training AdditionalFiles08: Human Resources
13812F05111CT183Training/DevelopmentTransaction Files05: Time Accounting and HRM BaseNo
14812F05112ST131Skills/ResourcesTransaction Files05: Time Accounting and HRM BaseNo
15812F051124Y491Director Text Setup FileFiles05T: Time EntryBusiness Data
16812F05113AT131AccomplishmentsTransaction Files05: Time Accounting and HRM BaseNo
17812F05114CT191CertificationsTransaction Files05: Time Accounting and HRM BaseNo
18812F05115ET143EducationTransaction Files05: Time Accounting and HRM BaseNo
19812F05116LT111LanguagesTransaction Files05: Time Accounting and HRM BaseNo
20812F05117GL112Goal Action PlanTransaction Files05: Time Accounting and HRM BaseNo
21812F051171GL205Goal ActionsFiles05: Time Accounting and HRM BaseBusiness Data
22812F05118AC91Aggregate CompetenciesTransaction Files05: Time Accounting and HRM BaseNo
23812F05119CL91Competency LevelsTransaction Files05: Time Accounting and HRM BaseNo
24812F05120MM151Competency HistoryHistory Files05: Time Accounting and HRM BaseNo
25812F05121CR92Competency/CourseTransaction Files05: Time Accounting and HRM BaseNo
26812F05122AP102Action PlanSecondary Master Files05: Time Accounting and HRM BaseNo
27812F051400SF91Searchable Competency FieldsFiles05: Time Accounting and HRM Base
28812F051402SC81Search ConstantsFiles05: Time Accounting and HRM Base
29812F051413SI71Competency Search ImportanceFiles05: Time Accounting and HRM Base
30812F051421WI82Word IndexFiles05: Time Accounting and HRM Base
31812F051422CW91Competency WordsFiles05: Time Accounting and HRM Base
32812F051423LW101Level WordsFiles05: Time Accounting and HRM Base
33812F051424CD101Competency Detail UDC WordsFiles05: Time Accounting and HRM Base
34812F051425CD101Competency Detail WordsFiles05: Time Accounting and HRM Base
35812F051427IW61Ignore WordsFiles05: Time Accounting and HRM Base
36812F051428RW71Related WordsFiles05: Time Accounting and HRM Base
37812F051429AC91AcronymFiles05: Time Accounting and HRM Base
38812F05152WFWF81Results Work FileFiles05: Time Accounting and HRM Base
39812F05153WFWF91Results Work File Competency DetailFiles05: Time Accounting and HRM Base
40812F05154WFWF101Results Work File Competency Words DetailFiles05: Time Accounting and HRM Base
41812F05400PF273Self-Service Process Flow SettingsFiles05: Time Accounting and HRM Base
42812F054101EH511Employee Personal Profile Information History TableFiles05: Time Accounting and HRM Base
43812F054101WEP524Employee Personal Profile Information Work TableFiles05: Time Accounting and HRM Base
44812F054111CH251Employee Emergency Contact History TableFiles05: Time Accounting and HRM Base
45812F054111WEC264Employee Emergency Contact Work TableFiles05: Time Accounting and HRM Base
46812F05420WA151Workflow Approval TableFiles05: Time Accounting and HRM Base
47812F05430UT121ESS User Defined TextFiles05: Time Accounting and HRM Base
48812F06005JE301Batch Processing ParametersWork Files07: PayrollAS400 Coexistence Tables
49812F0605J@271D/B/A Period Control FileBalance Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
50812F0607JI261Wage Attachment Ledger FileTransaction Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
51812F0609Y$419Deduction/Benefit/Accrual Ledger FileTransaction Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
52812F06106YM1056Employee Pay InstructionsSecondary Master Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
53812F06107J$491Employee Wage Attachment RulesSecondary Master Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
54812F061071J$231Employee Wage Attachment Fee FileSecondary Master Files07: PayrollAS400 Coexistence Tables
55812F06145YH543Calendar Month DBA Summary History FileHistory Files07: PayrollAS400 Coexistence Tables
56812F06149Y7141Fiscal and Anniversary Rollover Work FileBalance Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
57812F0618YT12926Employee Transaction HistoryHistory Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
58812F0619Y$339Benefit/Accrual Detail FileHistory Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
59812F0625JB195Change Code History FileHistory Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
60812F06251JB104Step Progression Rate History FileTransaction Files07: PayrollAS400 Coexistence Tables
61812F0626JG244Wage Attachment Control FileTransaction Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
62812F0627JH881Workers Compensation Summary HistoryHistory Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
63812F069016YP213Payroll Tax Area ProfileConstants Files07: PayrollAS400 Coexistence Tables
64812F069016TYP91Payroll Tax Area Profile - Tag FileConstants Files07: Payroll
65812F069027Y2101Table Code Unit-of-Measure WindowConstants Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
66812F069036YX72Payroll Transaction Cross ReferenceConstants Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
67812F069086YI104Payroll Corporate Tax IdentificationConstants Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
68812F069106Y1534Union Benefits MasterConstants Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
69812F069116YC1339Payroll Transaction ConstantsConstants Files07: PayrollAS400 Coexistence Tables
70812F069117YB31Tax Authority Tax Exemption FileConstants Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
71812F069126YL403Union Rates FileConstants Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
72812F06915JH165Holiday TableConstants Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
73812F069162JH51Job Type/ Item Cross Reference FileConstants Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
74812F06919YB41Denomination Table FileConstants Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
75812F06920YQ221Savings Bond General ConstantExtra Features Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
76812F069216YB194Workers Compensation Insurance RatesConstants Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
77812F069226YH142Unemployment Insurance RatesConstants Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
78812F06923YH362Valid Job Type/ Step ConstantConstants Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
79812F06925YG91Employee/Vendor Cross ReferenceExtra Features Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
80812F06926Y#41Tax Area/ Vendor Cross ReferenceExtra Features Files05: Time Accounting and HRM BaseAS400 Coexistence Tables
81812F06927J531Payee Voucher RulesExtra Features Files07: PayrollAS400 Coexistence Tables
82812F06931J3101Wage Attachment FileConstants Files07: PayrollAS400 Coexistence Tables
83812F069311J361Wage Attachment Additional ExemptionsConstants Files07: PayrollAS400 Coexistence Tables
84812F069312J391Wage Attachment Exemptions FileConstants Files07: PayrollAS400 Coexistence Tables
85812F06933J@202Step Progression ParametersConstants Files07: PayrollAS400 Coexistence Tables
86812F06936JA197Retro Pay Types RateConstants Files07: PayrollAS400 Coexistence Tables
87812F06972YR63Retro Pay Type TableConstants Files07: PayrollAS400 Coexistence Tables
88812F0709Y$5615Deduction/Benefit/Accrual Ledger FileTransaction Files07: PayrollNo
89812F07300YB112Employee Lockout Code FileRegular Work Files05: Time Accounting and HRM BaseNo
90812F073111AA82Pay Type to Activity Type AssociationFiles05: Time Accounting and HRM Base
91812F07315GS103Employee Group Schedules DirectorFiles05: Time Accounting and HRM Base
92812F086011CO161Establishment InformationFiles05: Time Accounting and HRM Base