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
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

104 tables920 | 05

05: Time Accounting and HRM Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F05005GF211Generic UBE FileFiles05: Time Accounting and HRM Base
2920F050116WEM272Employee Master Integrations Work FileFiles05: Time Accounting and HRM Base
3920F050611UR112URL DefinitionsFiles05: Time Accounting and HRM Base
4920F050612UR93Media Object URL IntersectionFiles05: Time Accounting and HRM Base
5920F05100CM112Resource CompetencyMaster Files05: Time Accounting and HRM BaseBusiness Data
6920F05100Z1CU282Resource Competencies Unedited Transactions FileFiles05: Time Accounting and HRM Base
7920F05101CY142Course MasterMaster Files05: Time Accounting and HRM BaseBusiness Data
8920F05102SM226Goal MasterMaster Files05: Time Accounting and HRM BaseBusiness Data
9920F05103AM91Scale MasterMaster Files05: Time Accounting and HRM BaseBusiness Data
10920F05104CM111Competency MasterMaster Files05: Time Accounting and HRM BaseBusiness Data
11920F05105GS153Goal SuggestionsFiles05: Time Accounting and HRM BaseBusiness Data
12920F05106CU91Competency Update EventsFiles05: Time Accounting and HRM BaseBusiness Data
13920F05107CU91Competency Update Approval RoutingFiles05: Time Accounting and HRM BaseBusiness Data
14920F05107ACU101Competency Update Approval Routing Tag FileFiles05: Time Accounting and HRM Base
15920F05108UT151Unconfirmed Training AdditionalFiles08: Human Resources
16920F05111CT183Training/DevelopmentTransaction Files05: Time Accounting and HRM BaseBusiness Data
17920F05112ST131Skills/ResourcesTransaction Files05: Time Accounting and HRM BaseBusiness Data
18920F051124Y491Director Text Setup FileFiles05T: Time EntryBusiness Data
19920F05113AT131AccomplishmentsTransaction Files05: Time Accounting and HRM BaseBusiness Data
20920F05114CT191CertificationsTransaction Files05: Time Accounting and HRM BaseBusiness Data
21920F05115ET143EducationTransaction Files05: Time Accounting and HRM BaseBusiness Data
22920F05116LT111LanguagesTransaction Files05: Time Accounting and HRM BaseBusiness Data
23920F05117GL112Goal Action PlanTransaction Files05: Time Accounting and HRM BaseBusiness Data
24920F051171GL205Goal ActionsFiles05: Time Accounting and HRM BaseBusiness Data
25920F05118AC91Aggregate CompetenciesTransaction Files05: Time Accounting and HRM BaseBusiness Data
26920F05119CL91Competency LevelsTransaction Files05: Time Accounting and HRM BaseBusiness Data
27920F05120MM151Competency HistoryHistory Files05: Time Accounting and HRM BaseBusiness Data
28920F05121CR92Competency/CourseTransaction Files05: Time Accounting and HRM BaseBusiness Data
29920F05122AP102Action PlanSecondary Master Files05: Time Accounting and HRM BaseBusiness Data
30920F051400SF91Searchable Competency FieldsFiles05: Time Accounting and HRM Base
31920F051402SC81Search ConstantsFiles05: Time Accounting and HRM Base
32920F051413SI71Competency Search ImportanceFiles05: Time Accounting and HRM Base
33920F051421WI82Word IndexFiles05: Time Accounting and HRM Base
34920F051422CW91Competency WordsFiles05: Time Accounting and HRM Base
35920F051423LW101Level WordsFiles05: Time Accounting and HRM Base
36920F051424CD101Competency Detail UDC WordsFiles05: Time Accounting and HRM Base
37920F051425CD101Competency Detail WordsFiles05: Time Accounting and HRM Base
38920F051427IW61Ignore WordsFiles05: Time Accounting and HRM Base
39920F051428RW71Related WordsFiles05: Time Accounting and HRM Base
40920F051429AC91AcronymFiles05: Time Accounting and HRM Base
41920F05152WFWF81Results Work FileFiles05: Time Accounting and HRM Base
42920F05153WFWF91Results Work File Competency DetailFiles05: Time Accounting and HRM Base
43920F05154WFWF101Results Work File Competency Words DetailFiles05: Time Accounting and HRM Base
44920F05400PF274Self-Service Process Flow SettingsFiles05: Time Accounting and HRM Base
45920F054101EH511Employee Personal Profile Information History TableFiles05: Time Accounting and HRM Base
46920F054101WEP525Employee Personal Profile Information Work TableFiles05: Time Accounting and HRM Base
47920F054111CH251Employee Emergency Contact History TableFiles05: Time Accounting and HRM Base
48920F054111WEC264Employee Emergency Contact Work TableFiles05: Time Accounting and HRM Base
49920F05420WA152Workflow Approval TableFiles05: Time Accounting and HRM Base
50920F05430UT121ESS User Defined TextFiles05: Time Accounting and HRM Base
51920F06005JE301Batch Processing ParametersWork Files07: PayrollBusiness Data
52920F0605J@271D/B/A Period Control FileBalance Files05: Time Accounting and HRM BaseBusiness Data
53920F0607JI261Wage Attachment Ledger FileTransaction Files05: Time Accounting and HRM BaseBusiness Data
54920F0609Y$419Deduction/Benefit/Accrual Ledger FileTransaction Files05: Time Accounting and HRM BaseBusiness Data
55920F06106YM1058Employee Pay InstructionsSecondary Master Files05: Time Accounting and HRM BaseBusiness Data
56920F06107J$491Employee Wage Attachment RulesSecondary Master Files05: Time Accounting and HRM BaseBusiness Data
57920F061071J$231Employee Wage Attachment Fee FileSecondary Master Files07: PayrollBusiness Data
58920F06145YH543Calendar Month DBA Summary History FileHistory Files07: PayrollBusiness Data
59920F06149Y7141Fiscal and Anniversary Rollover Work FileBalance Files05: Time Accounting and HRM BaseBusiness Data
60920F0618YT14927Employee Transaction HistoryHistory Files05: Time Accounting and HRM BaseBusiness Data
61920F0619Y$339Benefit/Accrual Detail FileHistory Files05: Time Accounting and HRM BaseBusiness Data
62920F0625JB195Change Code History FileHistory Files05: Time Accounting and HRM BaseBusiness Data
63920F06251JB104Step Progression Rate History FileTransaction Files07: PayrollBusiness Data
64920F0626JG244Wage Attachment Control FileTransaction Files05: Time Accounting and HRM BaseBusiness Data
65920F0627JH1001Workers Compensation Summary HistoryHistory Files05: Time Accounting and HRM BaseBusiness Data
66920F069016YP213Payroll Tax Area ProfileConstants Files07: PayrollBusiness Data
67920F069016TYP91Payroll Tax Area Profile - Tag FileConstants Files07: Payroll
68920F069027Y2101Table Code Unit-of-Measure WindowConstants Files05: Time Accounting and HRM BaseBusiness Data
69920F069036YX72Payroll Transaction Cross ReferenceConstants Files05: Time Accounting and HRM BaseBusiness Data
70920F069086YI104Payroll Corporate Tax IdentificationConstants Files05: Time Accounting and HRM BaseBusiness Data
71920F069106Y1534Union Benefits MasterConstants Files05: Time Accounting and HRM BaseBusiness Data
72920F069116YC13510Payroll Transaction ConstantsConstants Files07: PayrollBusiness Data
73920F069116TYC471Payroll Transaction Constants - Tag FileConstants Files07: Payroll
74920F069117YB31Tax Authority Tax Exemption FileConstants Files05: Time Accounting and HRM BaseBusiness Data
75920F069126YL403Union Rates FileConstants Files05: Time Accounting and HRM BaseBusiness Data
76920F0691261YL251Additional Union RatesFiles05: Time Accounting and HRM Base
77920F069130YD161Group LimitsConstants Files07: Payroll
78920F069140YM171Employee DBA Group Limit OverridesFiles07: Payroll
79920F06915JH165Holiday TableConstants Files05: Time Accounting and HRM BaseBusiness Data
80920F069150Y1201DBA Group Plan Group Limit OverridesFiles07: Payroll
81920F069160Y9181Employee DBA Override Instructions Group LimitsFiles07: Payroll
82920F069162JH51Job Type/ Item Cross Reference FileConstants Files05: Time Accounting and HRM BaseBusiness Data
83920F06919YB41Denomination Table FileConstants Files05: Time Accounting and HRM BaseBusiness Data
84920F06920YQ221Savings Bond General ConstantExtra Features Files05: Time Accounting and HRM BaseBusiness Data
85920F069216YB194Workers Compensation Insurance RatesConstants Files05: Time Accounting and HRM BaseBusiness Data
86920F069226YH142Unemployment Insurance RatesConstants Files05: Time Accounting and HRM Base
87920F06923YH362Valid Job Type/ Step ConstantConstants Files05: Time Accounting and HRM BaseBusiness Data
88920F06925YG91Employee/Vendor Cross ReferenceExtra Features Files05: Time Accounting and HRM BaseBusiness Data
89920F06926Y#41Tax Area/ Vendor Cross ReferenceExtra Features Files05: Time Accounting and HRM BaseBusiness Data
90920F06927J531Payee Voucher RulesExtra Features Files07: PayrollBusiness Data
91920F06931J3101Wage Attachment FileConstants Files07: PayrollBusiness Data
92920F069311J361Wage Attachment Additional ExemptionsConstants Files07: PayrollBusiness Data
93920F069312J391Wage Attachment Exemptions FileConstants Files07: PayrollBusiness Data
94920F06933J@202Step Progression ParametersConstants Files07: PayrollBusiness Data
95920F06936JA197Retro Pay Types RateConstants Files07: PayrollBusiness Data
96920F06972YR63Retro Pay Type TableConstants Files07: PayrollBusiness Data
97920F0709Y$5915Deduction/Benefit/Accrual Ledger FileTransaction Files07: PayrollBusiness Data
98920F07300YB112Employee Lockout Code FileRegular Work Files05: Time Accounting and HRM BaseBusiness Data
99920F073111AA82Pay Type to Activity Type AssociationFiles05: Time Accounting and HRM Base
100920F07315GS103Employee Group Schedules DirectorFiles05: Time Accounting and HRM Base
101920F085590DS231Disability and Veteran Status History TableFiles05: Time Accounting and HRM Base
102920F085590WDS181Disability Status Work TableFiles05: Time Accounting and HRM Base
103920F085605WVS201Veteran Status Work TableFiles05: Time Accounting and HRM Base
104920F086011CO161Establishment InformationFiles05: Time Accounting and HRM Base