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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F0411RPAccounts Payable Ledger
5F4311PDPurchase Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

167 tables910 | 07

07: Payroll
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F05290JR702WF - Payroll Journal (Detail)Extra Features Files07: PayrollBusiness Data
2910F06053YW362Interim Check Parameters FileMaster Files07: PayrollBusiness Data
3910F06136YZ7413Tax HistoryHistory Files07: PayrollBusiness Data
4910F06136AYZ681Tax Summary (Additional)Files07: Payroll
5910F06136BYZ741Tax Summary (PA ACT 32)Files07: Payroll
6910F06147YD173Fiscal and Anniversary Year HistoryHistory Files07: PayrollBusiness Data
7910F06148Y@136Tax Area Transaction HistoryHistory Files07: Payroll
8910F06156YU4511Pay Check History SummaryHistory Files07: PayrollBusiness Data
9910F06166YV197Pay Check History Tax LedgerHistory Files07: PayrollBusiness Data
10910F06166AYV271Tax Ledger (Additional)Files07: Payroll
11910F06166BYV311Tax Ledger (PA ACT 32)Files07: Payroll
12910F06209Y@641Execution Control ParametersConstants Files07: PayrollBusiness Data
13910F06270JP831Retro Processing ParameterExtra Features Files07: PayrollBusiness Data
14910F06271JQ41Retro Processing SelectionExtra Features Files07: PayrollBusiness Data
15910F063106Y7292Deduction/Benefit Work FileWork Files07: PayrollBusiness Data
16910F06350IY4532WF - Paycheck (Interims)Regular Work Files07: PayrollBusiness Data
17910F06490JR233Payroll/Accounts Payable Ledger DetailExtra Features Files07: PayrollBusiness Data
18910F06491J6201Payroll/Accounts Payable Ledger DetailExtra Features Files07: PayrollBusiness Data
19910F06492JC102Payroll - Accounts Payable ControlExtra Features Files07: PayrollBusiness Data
20910F065016YG281Automatic Bank Deposit MasterMaster Files07: PayrollBusiness Data
21910F065016TYG241Automatic Bank Deposit Master (Additional)Files07: Payroll
22910F06560Y861Bank Reconciliation - Issue FileBatch Input Files07: PayrollBusiness Data
23910F06561Y961Bank Reconciliation - Paid FileBatch Input Files07: PayrollBusiness Data
24910F06720JE2201W-2/1099 Processing ControlExtra Features Files07: PayrollBusiness Data
25910F068500YZ121941 - Federal Tax HistoryExtra Features Files07: PayrollBusiness Data
26910F06900Y$151Payroll Fiscal PatternsConstants Files07: PayrollBusiness Data
27910F069025TR41Calculation Table RulesFiles07: Payroll
28910F069026Y2233Payroll Generic TablesConstants Files07: PayrollBusiness Data
29910F0690361RO91Employee Rollover Table OverridesFiles07: Payroll
30910F069066JD247Pay Cycle ConstantConstants Files07: PayrollBusiness Data
31910F069076YF72Insured Pay CodeConstants Files07: PayrollBusiness Data
32910F069171YP241Payroll Payment/ Reporting TermsConstants Files07: PayrollBusiness Data
33910F0701730VS92Populate Vertex Filing StatusFiles07: Payroll
34910F0701731YC131Compensation OverridesFiles07: Payroll
35910F0701732AO261Additional Tax OverridesFiles07: Payroll
36910F0701733YC291Additional Calc MethodsFiles07: Payroll
37910F0701734Y3211Prior Head Tax from a Previous EmployerFiles07: Payroll
38910F0701735YC161Pretax Deduction OverridesFiles07: Payroll
39910F0701740YQ162Quantum Control TaxFiles07: Payroll
40910F0701741YD162Canadian DeductionFiles07: Payroll
41910F0705J@163DBA Period Control FileTransaction Files07: PayrollBusiness Data
42910F07100F7172CCQ WORKFILEWork Files07: PayrollBusiness Data
43910F07107JW612Employee Wage Attachment RulesMaster Files07: PayrollBusiness Data
44910F071072JX91Employee Level Multi Child Support OverridesConstants Files07: PayrollBusiness Data
45910F071073J3121Employee Level Multi Wage Attachment RulesFiles07: Payroll
46910F071074WE141Wage Attachment Exemption RulesFiles07: Payroll
47910F071075JW232Wage Attachment Child Support EFT DetailFiles07: Payroll
48910F07149Y8203Accrual Fiscal/Anniversary History Work FileFiles07: PayrollBusiness Data
49910F0716701EA971Employee Assignment T/E Template InformationFiles07: PayrollBusiness Data
50910F0716702EA212Employee Assignment RatesFiles07: PayrollBusiness Data
51910F0716703EA142Employee Assignment Job DescriptionFiles07: PayrollBusiness Data
52910F0716704EA71Employee Assignment Default Pay TypeFiles07: PayrollBusiness Data
53910F0716709EA971Employee Assignment T/E Template Info HistoryFiles07: PayrollBusiness Data
54910F0717JF538ROE Summary HistoryHistory Files07: PayrollBusiness Data
55910F07171JP42ROE Summary History CommentsHistory Files07: PayrollBusiness Data
56910F07172YD51ROE Max/MinConstants Files07: PayrollBusiness Data
57910F07186Y8221Stub Information History TableWork Files07: PayrollBusiness Data
58910F071861Y8201Stub Detail Piece Rate History FileFiles07: PayrollBusiness Data
59910F0719Y$592DBA Transaction Detail HistoryHistory Files07: PayrollBusiness Data
60910F07209Y@411Execution Control ParametersConstants Files07: PayrollBusiness Data
61910F07210YD993Pay Cycle Parameters FileWork Files07: PayrollBusiness Data
62910F07212Y281Paystub Retro Pay State SetupFiles07: Payroll
63910F07235Y672Auto Deposit Bank WorkfileFiles07: PayrollBusiness Data
64910F07236Y6141Auto Deposit Tape File SetupFiles07: PayrollBusiness Data
65910F07236TY6231Auto Deposit Tape File Setup (Additional)Files07: Payroll
66910F0724YS241Burden Distribution FileHistory Files07: PayrollBusiness Data
67910F07241YS242Burden Distribution FileHistory Files07: PayrollBusiness Data
68910F0728YW132Employee Paid Workers Compensation TransactionsFiles07: Payroll
69910F0729Y9932Employee DBA Override InstructionsFiles07: PayrollBusiness Data
70910F07350Y0525Payment FileWork Files07: PayrollBusiness Data
71910F07351Y1272Payment Distribution FileWork Files07: PayrollBusiness Data
72910F07351TY1241Payment Distribution File (Additional)Files07: Payroll
73910F07352Y2221Stub Information FileWork Files07: PayrollBusiness Data
74910F073521Y2201Stub Detail Piece Rate FileFiles07: PayrollBusiness Data
75910F07353Y3323Tax Detail FileWork Files07: PayrollBusiness Data
76910F07354Y4101Report Setup FileConstants Files07: PayrollBusiness Data
77910F07355Y5362Pre-Payroll Error FileWork Files07: PayrollBusiness Data
78910F07390RO141Year-End Rollover WorkfileFiles07: Payroll
79910F073911Y8171Leave Rollover Balance Report Work FileWork Files07: PayrollBusiness Data
80910F07400NH81New Hire Detail File - Common FormatWork Files07S: Payroll SUIBusiness Data
81910F074001NH1151New Hire Reporting Workfile - OneWorld OnlyWork Files07S: Payroll SUIBusiness Data
82910F074001RNH151New Hire Report Setup - OneWorld OnlyConstants Files07S: Payroll SUIBusiness Data
83910F074001WNH151SUI/New Hire Client loader for F074001RInstall Files07S: Payroll SUIBusiness Data
84910F07415NH81New Hire Detail File - IndianaWork Files07: PayrollBusiness Data
85910F07436NH81New Hire Detail File - OhioMaster Files07S: Payroll SUIBusiness Data
86910F07439NH81New Hire Detail File - PennsylvaniaMaster Files07S: Payroll SUIBusiness Data
87910F07440NH81New Hire Detail File - Rhode IslandWork Files07: PayrollBusiness Data
88910F07490JR244Payroll - Accounts Payable Detail (One World)Extra Features Files07: PayrollBusiness Data
89910F07491J6232Payroll - Accounts Payable Summary FileExtra Features Files07: PayrollBusiness Data
90910F07492JC113Payroll - Accounts Payable Control FileExtra Features Files07: PayrollBusiness Data
91910F07500GC91Geocoder Report SetupFiles07: PayrollBusiness Data
92910F075611Y911Bank File of Cleared Checks - Flat File OneWorld OnlyWork Files07: PayrollBusiness Data
93910F07600LC211Leave Administration ControlFiles07: PayrollBusiness Data
94910F07601LS153Leave Type SetupFiles07: PayrollBusiness Data
95910F07602LR151Leave Verification RulesFiles07: Payroll
96910F07603FV281FMLA Leave Substitution RulesFiles07: Payroll
97910F07620LV255Leave TransactionsFiles07: PayrollBusiness Data
98910F07621L1261Employee Medical Leave InformationFiles07: PayrollBusiness Data
99910F07622L2151Employee Leave - Medical OpinionsFiles07: PayrollBusiness Data
100910F07623L3211Employee FMLA Request HeaderFiles07: PayrollBusiness Data
101910F07624L4251Employee Medical Leave Change InformationFiles07: PayrollBusiness Data
102910F07630LM111Leave Messaging and AuditFiles07: Payroll
103910F077011Y$121Tax History Integrity (Temp)Regular Work Files07: PayrollBusiness Data
104910F077011AY$141Tax History Integrity Additional (Temp)Regular Work Files07: PayrollBusiness Data
105910F077011BY3151Tax Integrity (PA Act32)Files07: Payroll
106910F077021Y$151Transaction History Integrity(Temp)Regular Work Files07: PayrollBusiness Data
107910F07727J7283Canadian Pension InformationHistory Files07: PayrollBusiness Data
108910F07800JE92Year-End Employee TableExtra Features Files07Y: US Payroll Year End
109910F07810JE521Year-End Control TableExtra Features Files07Y: US Payroll Year End
110910F07811JE121Negative Amount WorkfileExtra Features Files07Y: US Payroll Year End
111910F07815YF91Special Handling Codes SetupExtra Features Files07Y: US Payroll Year End
112910F07821JG163Company Form Count TableExtra Features Files07Y: US Payroll Year EndBusiness Data
113910F07822JI512Company Federal Control TableExtra Features Files07Y: US Payroll Year End
114910F07823YF142Year-End Report TableExtra Features Files07Y: US Payroll Year End
115910F07824JD253Company State/Local Control TableExtra Features Files07Y: US Payroll Year End
116910F07825JA493Company Special Handling Control TableExtra Features Files07Y: US Payroll Year End
117910F07826JB92Additional ParametersExtra Features Files07Y: US Payroll Year End
118910F07830Y09011Employee Federal Control TableExtra Features Files07Y: US Payroll Year EndBusiness Data
119910F078303YF81Arizona SUI magnetic media table (03)Regular Work Files07S: Payroll SUIBusiness Data
120910F078305YW81California SUI Magnetic Media Table (05)Work Files07S: Payroll SUIBusiness Data
121910F078306YF81Colorado SUI magnetic media table (06)Regular Work Files07S: Payroll SUIBusiness Data
122910F07831YB5313Employee State/Local Control TableExtra Features Files07Y: US Payroll Year EndBusiness Data
123910F078310YF81Florida SUI magnetic media table (10)Regular Work Files07S: Payroll SUIBusiness Data
124910F078311YF81Georgia SUI magnetic media table (11)Regular Work Files07S: Payroll SUIBusiness Data
125910F078312YF81Hawaii SUI magnetic media table (12)Extra Features Files07S: Payroll SUIBusiness Data
126910F07832YH6611Employee Special Handling Control TableExtra Features Files07Y: US Payroll Year EndBusiness Data
127910F078329YF81Nevada SUI Magnetic Media Table (29)Regular Work Files07S: Payroll SUIBusiness Data
128910F078344YW81Texas SUI Magnetic Media Table(44)Work Files07S: Payroll SUIBusiness Data
129910F078345YF81Utah SUI magnetic media table (45)Regular Work Files07S: Payroll SUIBusiness Data
130910F078348YW81Washington SUI Magnetic Media Table (48)Work Files07S: Payroll SUIBusiness Data
131910F07835JE41W-2 Magnetic Media WorkfileExtra Features Files07Y: US Payroll Year End
132910F07836JE411099 Magnetic Media WorkfileExtra Features Files07Y: US Payroll Year End
133910F07845FZ151Fund MasterFiles07: Payroll
134910F07850FG161Group Fund SetupFiles07: Payroll
135910F078504VA261Vertex Geo Code to ADP CodeFiles07: PayrollBusiness Data
136910F078505YA21ADP PDBA Quarterly Table SetupFiles07: PayrollBusiness Data
137910F078506YJ21ADP Company Code to JDE Company CodeFiles07: PayrollBusiness Data
138910F078507YE211ADP Employee Additional InformationFiles07: PayrollBusiness Data
139910F07855AF131Employee Fund AllocationFiles07: Payroll
140910F07860ST71Superannuation Date TrackingFiles07: Payroll
141910F078601RF41Table for storing W2 Mag Media InformationExtra Features Files07Y: US Payroll Year End
142910F078602RS51State Mag Media TableExtra Features Files07Y: US Payroll Year End
143910F078603R9411099 Mag MediaTransaction Files07Y: US Payroll Year End
144910F078651RM41W2 EFW2 Electronic Filing BuildExtra Features Files07Y: US Payroll Year End
145910F078652RF41W-2C EFW2C Electronic Filing BuildExtra Features Files07Y: US Payroll Year End
146910F07869RM41W-2 EFW2 Electronic Filing State BuildExtra Features Files07Y: US Payroll Year End
147910F07880YW912SUI Magnetic Media WorkfileWork Files07S: Payroll SUIBusiness Data
148910F07881YF81SUI Magnetic Media Flat File - GenericWork Files07S: Payroll SUIBusiness Data
149910F07885YW283SUI Payments for Quarterly ReportingWork Files07S: Payroll SUI
150910F07900NC201Non Calendar Tax Fiscal Date PatternsConstants Files07: PayrollBusiness Data
151910F07901Y5492Pre-Payroll DBA Calculation Control TableConstants Files07: PayrollBusiness Data
152910F079320WX351Wage Attachment Exemptions by Pay FrequencyFiles07: Payroll
153910F07940YY131Set Vertex Tax TableConstants Files07: PayrollBusiness Data
154910F079420PD221Prevailing Wage DBAsFiles07: Payroll
155910F079425PR241Prevailing Wage DBA RangeFiles07: Payroll
156910F079430PW402Prevailing Wage Transaction DetailFiles07: Payroll
157910F079435PF282Prevailing Wage Fringe DetailFiles07: Payroll
158910F079440PW392Prevailing Wage Transaction HistoryFiles07: Payroll
159910F079445PH272Prevailing Wage Fringe HistoryFiles07: Payroll
160910F07991YX111Deduction - Benefit - Accrual History Conversion DataBatch Input Files07: PayrollBusiness Data
161910F07992YQ111Payroll Tax History Conversion DataBatch Input Files07: PayrollBusiness Data
162910F07UI200TH1016Timecard History Work FileWork Files07: PayrollBusiness Data
163910F186206LG32Leave Group ListFiles07: Payroll
164910F8907422MA181New Hire Detail File - Massachusetts (22)Master Files07S: Payroll SUIBusiness Data
165910F8907427MT561New Hire Detail File - Montana (27)Master Files07S: Payroll SUIBusiness Data
166910F8907428NE181New Hire Detail File - Nebraska(28)Master Files07S: Payroll SUIBusiness Data
167910F8907444TX451New Hire Detail File Transfer - Texas (44)Master Files07S: Payroll SUIBusiness Data