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

169 tables920 | 07

07: Payroll
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F05290JR702WF - Payroll Journal (Detail)Extra Features Files07: PayrollBusiness Data
2920F055011WAD698Auto Deposit Instructions Work FileFiles07: Payroll
3920F06053YW362Interim Check Parameters FileMaster Files07: PayrollBusiness Data
4920F06136YZ7413Tax HistoryHistory Files07: PayrollBusiness Data
5920F06136AYZ681Tax Summary (Additional)Files07: Payroll
6920F06136BYZ741Tax Summary (PA ACT 32)Files07: Payroll
7920F06147YD173Fiscal and Anniversary Year HistoryHistory Files07: PayrollBusiness Data
8920F06148Y@136Tax Area Transaction HistoryHistory Files07: Payroll
9920F06156YU4511Pay Check History SummaryHistory Files07: PayrollBusiness Data
10920F06166YV197Pay Check History Tax LedgerHistory Files07: PayrollBusiness Data
11920F06166AYV271Tax Ledger (Additional)Files07: Payroll
12920F06166BYV311Tax Ledger (PA ACT 32)Files07: Payroll
13920F06209Y@641Execution Control ParametersConstants Files07: PayrollBusiness Data
14920F06270JP831Retro Processing ParameterExtra Features Files07: PayrollBusiness Data
15920F06271JQ41Retro Processing SelectionExtra Features Files07: PayrollBusiness Data
16920F063106Y7292Deduction/Benefit Work FileWork Files07: PayrollBusiness Data
17920F06350IY4532WF - Paycheck (Interims)Regular Work Files07: PayrollBusiness Data
18920F06490JR233Payroll/Accounts Payable Ledger DetailExtra Features Files07: PayrollBusiness Data
19920F06491J6201Payroll/Accounts Payable Ledger DetailExtra Features Files07: PayrollBusiness Data
20920F06492JC102Payroll - Accounts Payable ControlExtra Features Files07: PayrollBusiness Data
21920F065016YG281Automatic Bank Deposit MasterMaster Files07: PayrollBusiness Data
22920F065016TYG241Automatic Bank Deposit Master (Additional)Files07: Payroll
23920F06560Y861Bank Reconciliation - Issue FileBatch Input Files07: PayrollBusiness Data
24920F06561Y961Bank Reconciliation - Paid FileBatch Input Files07: PayrollBusiness Data
25920F06720JE2201W-2/1099 Processing ControlExtra Features Files07: PayrollBusiness Data
26920F068500YZ121941 - Federal Tax HistoryExtra Features Files07: PayrollBusiness Data
27920F06900Y$151Payroll Fiscal PatternsConstants Files07: PayrollBusiness Data
28920F069025TR41Calculation Table RulesFiles07: Payroll
29920F069026Y2233Payroll Generic TablesConstants Files07: PayrollBusiness Data
30920F0690361RO91Employee Rollover Table OverridesFiles07: Payroll
31920F069066JD247Pay Cycle ConstantConstants Files07: PayrollBusiness Data
32920F069076YF72Insured Pay CodeConstants Files07: PayrollBusiness Data
33920F069171YP241Payroll Payment/ Reporting TermsConstants Files07: PayrollBusiness Data
34920F0701730VS92Populate Vertex Filing StatusFiles07: Payroll
35920F0701731YC131Compensation OverridesFiles07: Payroll
36920F0701732AO261Additional Tax OverridesFiles07: Payroll
37920F0701733YC291Additional Calc MethodsFiles07: Payroll
38920F0701734Y3211Prior Head Tax from a Previous EmployerFiles07: Payroll
39920F0701735YC161Pretax Deduction OverridesFiles07: Payroll
40920F0701740YQ162Quantum Control TaxFiles07: Payroll
41920F0701741YD162Canadian DeductionFiles07: Payroll
42920F0705J@163DBA Period Control FileTransaction Files07: PayrollBusiness Data
43920F07100F7172CCQ WORKFILEWork Files07: PayrollBusiness Data
44920F07107JW612Employee Wage Attachment RulesMaster Files07: PayrollBusiness Data
45920F071072JX91Employee Level Multi Child Support OverridesConstants Files07: PayrollBusiness Data
46920F071073J3121Employee Level Multi Wage Attachment RulesFiles07: Payroll
47920F071074WE141Wage Attachment Exemption RulesFiles07: Payroll
48920F071075JW232Wage Attachment Child Support EFT DetailFiles07: Payroll
49920F07149Y8203Accrual Fiscal/Anniversary History Work FileFiles07: PayrollBusiness Data
50920F0716701EA971Employee Assignment T/E Template InformationFiles07: PayrollBusiness Data
51920F0716702EA212Employee Assignment RatesFiles07: PayrollBusiness Data
52920F0716703EA142Employee Assignment Job DescriptionFiles07: PayrollBusiness Data
53920F0716704EA71Employee Assignment Default Pay TypeFiles07: PayrollBusiness Data
54920F0716709EA971Employee Assignment T/E Template Info HistoryFiles07: PayrollBusiness Data
55920F0717JF538ROE Summary HistoryHistory Files07: PayrollBusiness Data
56920F07171JP42ROE Summary History CommentsHistory Files07: PayrollBusiness Data
57920F07172YD51ROE Max/MinConstants Files07: PayrollBusiness Data
58920F07186Y8221Stub Information History TableWork Files07: PayrollBusiness Data
59920F071861Y8201Stub Detail Piece Rate History FileFiles07: PayrollBusiness Data
60920F0719Y$592DBA Transaction Detail HistoryHistory Files07: PayrollBusiness Data
61920F07209Y@411Execution Control ParametersConstants Files07: PayrollBusiness Data
62920F07210YD993Pay Cycle Parameters FileWork Files07: PayrollBusiness Data
63920F07212Y281Paystub Retro Pay State SetupFiles07: Payroll
64920F07235Y672Auto Deposit Bank WorkfileFiles07: PayrollBusiness Data
65920F07236Y6141Auto Deposit Tape File SetupFiles07: PayrollBusiness Data
66920F07236TY6231Auto Deposit Tape File Setup (Additional)Files07: Payroll
67920F0724YS241Burden Distribution FileHistory Files07: PayrollBusiness Data
68920F07241YS242Burden Distribution FileHistory Files07: PayrollBusiness Data
69920F0728YW132Employee Paid Workers Compensation TransactionsFiles07: Payroll
70920F0729Y9932Employee DBA Override InstructionsFiles07: PayrollBusiness Data
71920F07350Y0525Payment FileWork Files07: PayrollBusiness Data
72920F07351Y1272Payment Distribution FileWork Files07: PayrollBusiness Data
73920F07351TY1241Payment Distribution File (Additional)Files07: Payroll
74920F07352Y2221Stub Information FileWork Files07: PayrollBusiness Data
75920F073521Y2201Stub Detail Piece Rate FileFiles07: PayrollBusiness Data
76920F07353Y3323Tax Detail FileWork Files07: PayrollBusiness Data
77920F07354Y4101Report Setup FileConstants Files07: PayrollBusiness Data
78920F07355Y5362Pre-Payroll Error FileWork Files07: PayrollBusiness Data
79920F07390RO141Year-End Rollover WorkfileFiles07: Payroll
80920F073911Y8171Leave Rollover Balance Report Work FileWork Files07: PayrollBusiness Data
81920F07400NH81New Hire Detail File - Common FormatWork Files07S: Payroll SUIBusiness Data
82920F074001NH1151New Hire Reporting Workfile - OneWorld OnlyWork Files07S: Payroll SUIBusiness Data
83920F074001RNH151New Hire Report Setup - OneWorld OnlyConstants Files07S: Payroll SUIBusiness Data
84920F074001WNH151SUI/New Hire Client loader for F074001RInstall Files07S: Payroll SUIBusiness Data
85920F07415NH81New Hire Detail File - IndianaWork Files07: PayrollBusiness Data
86920F07436NH81New Hire Detail File - OhioMaster Files07S: Payroll SUIBusiness Data
87920F07439NH81New Hire Detail File - PennsylvaniaMaster Files07S: Payroll SUIBusiness Data
88920F07440NH81New Hire Detail File - Rhode IslandWork Files07: PayrollBusiness Data
89920F07490JR244Payroll - Accounts Payable Detail (One World)Extra Features Files07: PayrollBusiness Data
90920F07491J6232Payroll - Accounts Payable Summary FileExtra Features Files07: PayrollBusiness Data
91920F07492JC113Payroll - Accounts Payable Control FileExtra Features Files07: PayrollBusiness Data
92920F07500GC91Geocoder Report SetupFiles07: PayrollBusiness Data
93920F075611Y911Bank File of Cleared Checks - Flat File OneWorld OnlyWork Files07: PayrollBusiness Data
94920F07600LC211Leave Administration ControlFiles07: PayrollBusiness Data
95920F07601LS153Leave Type SetupFiles07: PayrollBusiness Data
96920F07602LR151Leave Verification RulesFiles07: Payroll
97920F07603FV281FMLA Leave Substitution RulesFiles07: Payroll
98920F07620LV255Leave TransactionsFiles07: PayrollBusiness Data
99920F07621L1261Employee Medical Leave InformationFiles07: PayrollBusiness Data
100920F07622L2151Employee Leave - Medical OpinionsFiles07: PayrollBusiness Data
101920F07623L3211Employee FMLA Request HeaderFiles07: PayrollBusiness Data
102920F07624L4251Employee Medical Leave Change InformationFiles07: PayrollBusiness Data
103920F07630LM111Leave Messaging and AuditFiles07: Payroll
104920F077011Y$121Tax History Integrity (Temp)Regular Work Files07: PayrollBusiness Data
105920F077011AY$141Tax History Integrity Additional (Temp)Regular Work Files07: PayrollBusiness Data
106920F077011BY3151Tax Integrity (PA Act32)Files07: Payroll
107920F077021Y$151Transaction History Integrity(Temp)Regular Work Files07: PayrollBusiness Data
108920F07727J7283Canadian Pension InformationHistory Files07: PayrollBusiness Data
109920F07800JE92Year-End Employee TableExtra Features Files07Y: US Payroll Year End
110920F07810JE521Year-End Control TableExtra Features Files07Y: US Payroll Year End
111920F07811JE121Negative Amount WorkfileExtra Features Files07Y: US Payroll Year End
112920F07815YF91Special Handling Codes SetupExtra Features Files07Y: US Payroll Year End
113920F07821JG163Company Form Count TableExtra Features Files07Y: US Payroll Year EndBusiness Data
114920F07822JI512Company Federal Control TableExtra Features Files07Y: US Payroll Year End
115920F07823YF142Year-End Report TableExtra Features Files07Y: US Payroll Year End
116920F07824JD253Company State/Local Control TableExtra Features Files07Y: US Payroll Year End
117920F07825JA493Company Special Handling Control TableExtra Features Files07Y: US Payroll Year End
118920F07826JB92Additional ParametersExtra Features Files07Y: US Payroll Year End
119920F07830Y09011Employee Federal Control TableExtra Features Files07Y: US Payroll Year EndBusiness Data
120920F078303YF81Arizona SUI magnetic media table (03)Regular Work Files07S: Payroll SUIBusiness Data
121920F078305YW81California SUI Magnetic Media Table (05)Work Files07S: Payroll SUIBusiness Data
122920F078306YF81Colorado SUI magnetic media table (06)Regular Work Files07S: Payroll SUIBusiness Data
123920F07831YB5314Employee State/Local Control TableExtra Features Files07Y: US Payroll Year EndBusiness Data
124920F078310YF81Florida SUI magnetic media table (10)Regular Work Files07S: Payroll SUIBusiness Data
125920F078311YF81Georgia SUI magnetic media table (11)Regular Work Files07S: Payroll SUIBusiness Data
126920F078312YF81Hawaii SUI magnetic media table (12)Extra Features Files07S: Payroll SUIBusiness Data
127920F07832YH6611Employee Special Handling Control TableExtra Features Files07Y: US Payroll Year EndBusiness Data
128920F078329YF81Nevada SUI Magnetic Media Table (29)Regular Work Files07S: Payroll SUIBusiness Data
129920F078344YW81Texas SUI Magnetic Media Table(44)Work Files07S: Payroll SUIBusiness Data
130920F078345YF81Utah SUI magnetic media table (45)Regular Work Files07S: Payroll SUIBusiness Data
131920F078348YW81Washington SUI Magnetic Media Table (48)Work Files07S: Payroll SUIBusiness Data
132920F07835JE41W-2 Magnetic Media WorkfileExtra Features Files07Y: US Payroll Year End
133920F07836JE411099 Magnetic Media WorkfileExtra Features Files07Y: US Payroll Year End
134920F07845FZ151Fund MasterFiles07: Payroll
135920F07850FG161Group Fund SetupFiles07: Payroll
136920F078504VA261Vertex Geo Code to ADP CodeFiles07: PayrollBusiness Data
137920F078505YA21ADP PDBA Quarterly Table SetupFiles07: PayrollBusiness Data
138920F078506YJ21ADP Company Code to JDE Company CodeFiles07: PayrollBusiness Data
139920F078507YE211ADP Employee Additional InformationFiles07: PayrollBusiness Data
140920F078510VR1342ADP Quarterly Integrity ReportFiles07: Payroll
141920F07855AF301Employee Fund AllocationFiles07: Payroll
142920F07860ST71Superannuation Date TrackingFiles07: Payroll
143920F078601RF41Table for storing W2 Mag Media InformationExtra Features Files07Y: US Payroll Year End
144920F078602RS51State Mag Media TableExtra Features Files07Y: US Payroll Year End
145920F078603R9411099 Mag MediaTransaction Files07Y: US Payroll Year End
146920F078651RM41W2 EFW2 Electronic Filing BuildExtra Features Files07Y: US Payroll Year End
147920F078652RF41W-2C EFW2C Electronic Filing BuildExtra Features Files07Y: US Payroll Year End
148920F07869RM41W-2 EFW2 Electronic Filing State BuildExtra Features Files07Y: US Payroll Year End
149920F07880YW912SUI Magnetic Media WorkfileWork Files07S: Payroll SUIBusiness Data
150920F07881YF81SUI Magnetic Media Flat File - GenericWork Files07S: Payroll SUIBusiness Data
151920F07885YW283SUI Payments for Quarterly ReportingWork Files07S: Payroll SUI
152920F07900NC201Non Calendar Tax Fiscal Date PatternsConstants Files07: PayrollBusiness Data
153920F07901Y5492Pre-Payroll DBA Calculation Control TableConstants Files07: PayrollBusiness Data
154920F079320WX351Wage Attachment Exemptions by Pay FrequencyFiles07: Payroll
155920F07940YY131Set Vertex Tax TableConstants Files07: PayrollBusiness Data
156920F079420PD221Prevailing Wage DBAsFiles07: Payroll
157920F079425PR241Prevailing Wage DBA RangeFiles07: Payroll
158920F079430PW402Prevailing Wage Transaction DetailFiles07: Payroll
159920F079435PF282Prevailing Wage Fringe DetailFiles07: Payroll
160920F079440PW392Prevailing Wage Transaction HistoryFiles07: Payroll
161920F079445PH272Prevailing Wage Fringe HistoryFiles07: Payroll
162920F07991YX111Deduction, Benefit, Accrual History Conversion DataBatch Input Files07: PayrollBusiness Data
163920F07992YQ111Payroll Tax History Conversion DataBatch Input Files07: PayrollBusiness Data
164920F07UI200TH1016Timecard History Work FileWork Files07: PayrollBusiness Data
165920F186206LG32Leave Group ListFiles07: Payroll
166920F8907422MA181New Hire Detail File - Massachusetts (22)Master Files07S: Payroll SUIBusiness Data
167920F8907427MT561New Hire Detail File - Montana (27)Master Files07S: Payroll SUIBusiness Data
168920F8907428NE181New Hire Detail File - Nebraska(28)Master Files07S: Payroll SUIBusiness Data
169920F8907444TX451New Hire Detail File Transfer - Texas (44)Master Files07S: Payroll SUIBusiness Data