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

81 columns | Print definition?920 | TARA

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP05: Time Accounting and HRM Base
1F0607Wage Attachment Ledger File25JITARATax Area (Work)StringGeneric Edit100
2F06106Employee Pay Instructions18YMTARATax Area (Work)StringGeneric Edit100
3F06107Employee Wage Attachment Rules11J$TARATax Area (Work)StringGeneric Edit100
4F0626Wage Attachment Control File12JGTARATax Area (Work)StringGeneric Edit100
5F0627Workers Compensation Summary History2JHTARATax Area (Work)StringGeneric Edit100
6F069016Payroll Tax Area Profile1YPTARATax Area (Work)StringGeneric Edit100
7F069016TPayroll Tax Area Profile - Tag File1YPTARATax Area (Work)StringGeneric Edit100
8F069086Payroll Corporate Tax Identification2YITARATax Area (Work)StringGeneric Edit100
9F069116Payroll Transaction Constants90YCTARATax Area (Work)StringGeneric Edit100
10F069117Tax Authority Tax Exemption File3YBTARATax Area (Work)StringGeneric Edit100
11F069216Workers Compensation Insurance Rates2YBTARATax Area (Work)StringGeneric Edit100
12F069226Unemployment Insurance Rates2YHTARATax Area (Work)StringGeneric Edit100
13F06926Tax Area/ Vendor Cross Reference1Y#TARATax Area (Work)StringGeneric Edit100
14F06931Wage Attachment File3J3TARATax Area (Work)StringGeneric Edit100
15F069312Wage Attachment Exemptions File1J3TARATax Area (Work)StringGeneric Edit100
TOP05A: PeopleSoft HR & PR Foundation
16F060116Employee Master Information14YATARATax Area (Work)StringGeneric Edit100
17F0601161Point-In-Time Employee Master16PTTARATax Area (Work)StringGeneric Edit100
18F060116WEE Master Request File14YATARATax Area (Work)StringGeneric Edit100
19F060116ZUnedited Quick Hire Transaction File36SZTARATax Area (Work)StringGeneric Edit100
20F06345Historical Payroll Register29JLTARATax Area (Work)StringGeneric Edit100
TOP05T: Time Entry
21F069136Tip Disbursement20JETARATax Area (Work)StringGeneric Edit100
TOP07: Payroll
22F06136Tax History3YZTARATax Area (Work)StringGeneric Edit100
23F06136ATax Summary (Additional)3YZTARATax Area (Work)StringGeneric Edit100
24F06136BTax Summary (PA ACT 32)3YZTARATax Area (Work)StringGeneric Edit100
25F06148Tax Area Transaction History2Y@TARATax Area (Work)StringGeneric Edit100
26F06166Pay Check History Tax Ledger4YVTARATax Area (Work)StringGeneric Edit100
27F06166ATax Ledger (Additional)4YVTARATax Area (Work)StringGeneric Edit100
28F06166BTax Ledger (PA ACT 32)4YVTARATax Area (Work)StringGeneric Edit100
29F06270Retro Processing Parameter54JPTARATax Area (Work)StringGeneric Edit100
30F06350IWF - Paycheck (Interims)30Y4TARATax Area (Work)StringGeneric Edit100
31F06490Payroll/Accounts Payable Ledger Detail12JRTARATax Area (Work)StringGeneric Edit100
32F068500941 - Federal Tax History4YZTARATax Area (Work)StringGeneric Edit100
33F0701730Populate Vertex Filing Status2VSTARATax Area (Work)StringGeneric Edit100
34F0701731Compensation Overrides1YCTARATax Area (Work)StringGeneric Edit100
35F0701732Additional Tax Overrides2AOTARATax Area (Work)StringGeneric Edit100
36F0701734Prior Head Tax from a Previous Employer3Y3TARATax Area (Work)StringGeneric Edit100
37F0701735Pretax Deduction Overrides1YCTARATax Area (Work)StringGeneric Edit100
38F07107Employee Wage Attachment Rules14JWTARATax Area (Work)StringGeneric Edit100
39F0716701Employee Assignment T/E Template Information29EATARATax Area (Work)StringGeneric Edit100
40F0716709Employee Assignment T/E Template Info History29EATARATax Area (Work)StringGeneric Edit100
41F0717ROE Summary History43JFTARATax Area (Work)StringGeneric Edit100
42F07186Stub Information History Table12Y8TARATax Area (Work)StringGeneric Edit100
43F0729Employee DBA Override Instructions63Y9TARATax Area (Work)StringGeneric Edit100
44F07352Stub Information File12Y2TARATax Area (Work)StringGeneric Edit100
45F07353Tax Detail File3Y3TARATax Area (Work)StringGeneric Edit100
46F074001New Hire Reporting Workfile - OneWorld Only4NHTARATax Area (Work)StringGeneric Edit100
47F07490Payroll - Accounts Payable Detail (One World)11JRTARATax Area (Work)StringGeneric Edit100
48F07500Geocoder Report Setup2GCTARATax Area (Work)StringGeneric Edit100
49F077011Tax History Integrity (Temp)8Y$TARATax Area (Work)StringGeneric Edit100
50F077011ATax History Integrity Additional (Temp)8Y$TARATax Area (Work)StringGeneric Edit100
51F077011BTax Integrity (PA Act32)8Y3TARATax Area (Work)StringGeneric Edit100
52F07727Canadian Pension Information7J7TARATax Area (Work)StringGeneric Edit100
53F07811Negative Amount Workfile6JETARATax Area (Work)StringGeneric Edit100
54F078504Vertex Geo Code to ADP Code1VATARATax Area (Work)StringGeneric Edit100
55F078510ADP Quarterly Integrity Report6VRTARATax Area (Work)StringGeneric Edit100
56F07880SUI Magnetic Media Workfile3YWTARATax Area (Work)StringGeneric Edit100
57F07885SUI Payments for Quarterly Reporting2YWTARATax Area (Work)StringGeneric Edit100
58F079320Wage Attachment Exemptions by Pay Frequency1WXTARATax Area (Work)StringGeneric Edit100
59F07992Payroll Tax History Conversion Data5YQTARATax Area (Work)StringGeneric Edit100
TOP08: Human Resources
60F081161ACA Employee Eligibility32ADTARATax Area (Work)StringGeneric Edit100
61F0811619ACA Employee Eligibility Archive32ADTARATax Area (Work)StringGeneric Edit100
62F083303Benefit Statement Cross Reference Detail5CRTARATax Area (Work)StringGeneric Edit100
TOP08AD: ADP Integration
63F05137ADP Employee Master Information35ADTARATax Area (Work)StringGeneric Edit100
64F051371ADP Employee DBA Instructions23ADTARATax Area (Work)StringGeneric Edit100
65F051375ADP Payroll DBA Transaction Constants92ADTARATax Area (Work)StringGeneric Edit100
TOP75A: Australia
66F75A0003Australia/New Zealand tax calculation rules20ZRTARATax Area (Work)StringGeneric Edit100
67F75A0500AU Bonus and Back Pay Tax Workfile5BPTARATax Area (Work)StringGeneric Edit100
68F75A0501AU Bonus and Back Pay Tax History5THTARATax Area (Work)StringGeneric Edit100
TOP75Z: New Zealand
69F75Z0009New Zealand Tax Detail Work File3TXTARATax Area (Work)StringGeneric Edit100
70F75Z0010New Zealand Tax Detail Tag Table3TDTARATax Area (Work)StringGeneric Edit100
TOP77: Payroll (Canadian)
71F06176Unemployment Insurance History File11YSTARATax Area (Work)StringGeneric Edit100
72F0713Tax History3YZTARATax Area (Work)StringGeneric Edit100
73F0713SAVBackup Copy of F0713 For Tax Ledger Repost3YZTARATax Area (Work)StringGeneric Edit100
74F0716Pay Check History Tax Ledger - Canadian DB4YVTARATax Area (Work)StringGeneric Edit100
75F77200Canadian Employee Year-End Form Header - F772008J5TARATax Area (Work)StringGeneric Edit100
76F77200ACanadian Employee Year-End Form Header (Additional)7J5TARATax Area (Work)StringGeneric Edit100
77F77201TNegative Amount Print7NATARATax Area (Work)StringGeneric Edit100
78F77210Canadian Employee Year-End Form Detail - F722108J6TARATax Area (Work)StringGeneric Edit100
79F77220Employee Special Handling Detail - F772208J3TARATax Area (Work)StringGeneric Edit100
80F77230Employee Pension Maintenance - F772304J8TARATax Area (Work)StringGeneric Edit100
81F77703Payroll History Audit Report - Worktable9ARTARATax Area (Work)StringGeneric Edit100