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

90 tables920 | 08

08: Human Resources
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F05401DT101Self-Service Process Flow Director TextFiles08: Human Resources
2920F05402SA91Self-Service Step/ApplicationCross-ReferenceFiles08: Human Resources
3920F05403PR101Self-Service Script Position RulesFiles08: Human Resources
4920F05410ES131Employee E-SignatureFiles08: Human Resources
5920F054115HP151Employee Phone Number History TableFiles08: Human Resources
6920F054115WPN163Employee Phone Number Work TableFiles08: Human Resources
7920F0800601JC115Organizational Business Unit/Job Cross-ReferenceMaster Files08: Human ResourcesBusiness Data
8920F0800602JC181Job Competency MasterMaster Files08: Human ResourcesBusiness Data
9920F0800603JC125Job Group CompetenciesMaster Files08: Human ResourcesBusiness Data
10920F0800604JC125Organizational Business Unit CompetenciesMaster Files08: Human ResourcesBusiness Data
11920F0800605JC135Job Type/Step CompetenciesMaster Files08: Human ResourcesBusiness Data
12920F0800606JC207Competency Options - OverridesMaster Files08: Human ResourcesBusiness Data
13920F0800607JC115Organizational CompetenciesMaster Files08: Human ResourcesBusiness Data
14920F0800608JC91Date Effective Organizational StructureMaster Files08: Human ResourcesBusiness Data
15920F0800609YI394Gap Analysis SnapshotMaster Files08: Human ResourcesBusiness Data
16920F0800610JC156Competencies in Structure and JobMaster Files08: Human ResourcesBusiness Data
17920F0800611JC114Job Competency Default - OverridesMaster Files08: Human ResourcesBusiness Data
18920F0800612JC171User Defined Job Competency Description ReferenceMaster Files08: Human ResourcesBusiness Data
19920F08006WFJC205Job Competency Default Overrides Work FileMaster Files08: Human ResourcesBusiness Data
20920F080436VT722VETS-4212 Employment ReportFiles08: Human Resources
21920F080700XR121Fusion XREF TableFiles08: Human Resources
22920F080701LU191Fusion Lookup MapFiles08: Human Resources
23920F080702EM271Fusion Entity MapFiles08: Human Resources
24920F080703LT111Fusion Lookup TableFiles08: Human Resources
25920F080704FE121Fusion Business Objects Extracted TableFiles08: Human Resources
26920F080705FT101HR2HR Transaction DetailsFiles08: Human Resources
27920F080706FC152Fusion Configuration DetailsFiles08: Human Resources
28920F08090JX311HRM Supplemental Data TypesConstants Files08: Human ResourcesBusiness Data
29920F08092JZ174Human Resources General Description-User Def CodesTransaction Files08: Human ResourcesBusiness Data
30920F08093JY122Human Resources General Description - NarrationTransaction Files08: Human ResourcesBusiness Data
31920F08116AC81ACA Applicable Large EmployerFiles08: Human Resources
32920F081161AD585ACA Employee EligibilityFiles08: Human Resources
33920F0811619AD581ACA Employee Eligibility ArchiveFiles08: Human Resources
34920F081162AP271ACA ParametersFiles08: Human Resources
35920F0811629AP301ACA Parameters HistoryFiles08: Human Resources
36920F081163AS181ACA Home Company SummaryFiles08: Human Resources
37920F0811639AS181ACA Home Company Summary ArchiveFiles08: Human Resources
38920F082002YV181Grade/Step Progression Header FileRegular Work Files08: Human ResourcesBusiness Data
39920F082003YW291Grade/Step Progression Detail FileRegular Work Files08: Human ResourcesBusiness Data
40920F08320CPX111Plan Master Tag FileFiles08: Human Resources
41920F083301BS71Benefit StatementFiles08: Human ResourcesBusiness Data
42920F083302HT71Benefit Statement Heading Codes TypeFiles08: Human ResourcesBusiness Data
43920F083303CR101Benefit Statement Cross Reference DetailFiles08: Human ResourcesBusiness Data
44920F083304AH81Associate Benefit Statement HeadingFiles08: Human ResourcesBusiness Data
45920F083305MM361Mail Merge Header/DetailFiles08: Human ResourcesBusiness Data
46920F08336BE2121Dep/Ben X-Reference Tag TableMaster Files08: Human ResourcesBusiness Data
47920F08338E7161Primary Care Physician TableMaster Files08: Human Resources
48920F08338BPT112Primary Care Physician Tag TableFiles08: Human Resources
49920F08350CBX111Categories by Benefit Group Tag FileFiles08: Human Resources
50920F08391B0281User Program ParametersExtra Features Files08: Human ResourcesBusiness Data
51920F085500AD81Allowed Dependent Relations Per PlanFiles08: Human Resources
52920F085510ER91Benefit Categories by Enrollment EventsFiles08: Human Resources
53920F085515WP111Workflow Process FileFiles08: Human Resources
54920F085520PH291Available Plans and Plan Options by Employee History TableFiles08: Human Resources
55920F085520WAP535Available Plans and Plan Options by Employee Work TableFiles08: Human Resources
56920F085528ES91ESS History Table Cross ReferenceFiles08: Human Resources
57920F085530WCP303Employee Current/Pending Elections Work TableFiles08: Human Resources
58920F085536DH282Dependent/Beneficiary X-Reference History TableFiles08: Human Resources
59920F085536WDB295Dependent/Beneficiary X-Reference Work TableFiles08: Human Resources
60920F085537WXB213Current Dep/Ben X-Reference Work TableFiles08: Human Resources
61920F085540PU141Benefits Enrollment Plan/Option URL AddressFiles08: Human Resources
62920F085550IO142Employee Self-Service Personal Information OptionsFiles08: Human Resources
63920F085560NP31Number of Participants by EmployeeFiles08: Human Resources
64920F08710ES235Employee Setup MasterMaster Files08: Human ResourcesBusiness Data
65920F087101DT42Default Setup TasksMaster Files08: Human ResourcesBusiness Data
66920F087102TL143Setup Task ListMaster Files08: Human ResourcesBusiness Data
67920F087103TD263Setup Task DetailsMaster Files08: Human ResourcesBusiness Data
68920F08711ET174Employee Setup TasksMaster Files08: Human ResourcesBusiness Data
69920F08713PPI81Organization Chart Public Information FlagsFiles08: Human Resources
70920F08720SC134Employee Status ChangeTransaction Files08: Human ResourcesBusiness Data
71920F08721SD101Employee Status Change DetailsTransaction Files08: Human ResourcesBusiness Data
72920F08730SS91Employee Status Change SetupTransaction Files08: Human ResourcesBusiness Data
73920F08731SL81Employee Status Change Setup DetailTransaction Files08: Human ResourcesBusiness Data
74920F08740MR143Manager's Self Service ReportsTransaction Files08: Human ResourcesBusiness Data
75920F08750MD111Managers DelegatesTransaction Files08: Human ResourcesBusiness Data
76920F08771XG131CBPA System Company ConstantsMaster Files08: Human ResourcesBusiness Data
77920F087711XJ494CBPA Appraisal HeaderFiles08: Human ResourcesBusiness Data
78920F087711AXJ114CBPA Appraisal Header Tag TableFiles08: Human ResourcesBusiness Data
79920F087711BXK151Performance Appraisal Header Template KeysFiles08: Human ResourcesBusiness Data
80920F087715XM183CBPA Diary TableFiles08: Human ResourcesBusiness Data
81920F08771AXG71CBPA System Company Constants Tag TableMaster Files08: Human ResourcesBusiness Data
82920F08772XH131CBPA System Business Unit OverridesFiles08: Human ResourcesBusiness Data
83920F087721XP121CBPA Appraisal Creation Work FileFiles08: Human ResourcesBusiness Data
84920F08772AXH71CBPA System Business Unit Overrides Tag TableFiles08: Human ResourcesBusiness Data
85920F08773XL151CBPA System Appraisal Type OverridesFiles08: Human ResourcesBusiness Data
86920F08773AXL91CBPA System Appraisal Type Overrides Tag TableFiles08: Human ResourcesBusiness Data
87920F08776XO112CBPA Appraisal TemplatesFiles08: Human ResourcesBusiness Data
88920F089921DT112Rules DetailFiles08: Human ResourcesBusiness Data
89920F08JDWF1JC191Job Description Changes Integration Work FileFiles08: Human Resources
90920F08JDWF2JH263Job Description History Integration Work FileFiles08: Human Resources