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

116 columns | Print definition?920 | PDBA

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP05: Time Accounting and HRM Base
1F06005Batch Processing Parameters15JEPDBADBA CodeNumericGeneric Edit50
2F0605D/B/A Period Control File2J@PDBADBA CodeNumericGeneric Edit50
3F0607Wage Attachment Ledger File14JIPDBADBA CodeNumericGeneric Edit50
4F0609Deduction/Benefit/Accrual Ledger File7Y$PDBADBA CodeNumericGeneric Edit50
5F06106Employee Pay Instructions3YMPDBADBA CodeNumericGeneric Edit50
6F06107Employee Wage Attachment Rules2J$PDBADBA CodeNumericGeneric Edit50
7F061071Employee Wage Attachment Fee File2J$PDBADBA CodeNumericGeneric Edit50
8F06145Calendar Month DBA Summary History File2YHPDBADBA CodeNumericGeneric Edit50
9F06149Fiscal and Anniversary Rollover Work File2Y7PDBADBA CodeNumericGeneric Edit50
10F0618Employee Transaction History60YTPDBADBA CodeNumericGeneric Edit50
11F0619Benefit/Accrual Detail File7Y$PDBADBA CodeNumericGeneric Edit50
12F0626Wage Attachment Control File2JGPDBADBA CodeNumericGeneric Edit50
13F069036Payroll Transaction Cross Reference1YXPDBADBA CodeNumericGeneric Edit50
14F069106Union Benefits Master5Y1PDBADBA CodeNumericGeneric Edit50
15F069116Payroll Transaction Constants13YCPDBADBA CodeNumericGeneric Edit50
16F069116TPayroll Transaction Constants - Tag File1YCPDBADBA CodeNumericGeneric Edit50
17F069117Tax Authority Tax Exemption File1YBPDBADBA CodeNumericGeneric Edit50
18F069140Employee DBA Group Limit Overrides2YMPDBADBA CodeNumericGeneric Edit50
19F06915Holiday Table14JHPDBADBA CodeNumericGeneric Edit50
20F069150DBA Group Plan Group Limit Overrides6Y1PDBADBA CodeNumericGeneric Edit50
21F069160Employee DBA Override Instructions Group Limits4Y9PDBADBA CodeNumericGeneric Edit50
22F06923Valid Job Type/ Step Constant36YHPDBADBA CodeNumericGeneric Edit50
23F06925Employee/Vendor Cross Reference5YGPDBADBA CodeNumericGeneric Edit50
24F06936Retro Pay Types Rate4JAPDBADBA CodeNumericGeneric Edit50
25F0709Deduction/Benefit/Accrual Ledger File7Y$PDBADBA CodeNumericGeneric Edit50
26F073111Pay Type to Activity Type Association2AAPDBADBA CodeNumericGeneric Edit50
TOP05A: PeopleSoft HR & PR Foundation
27F05002Pay Type by Category2EVPDBADBA CodeNumericGeneric Edit50
28F06345Historical Payroll Register23JLPDBADBA CodeNumericGeneric Edit50
TOP05T: Time Entry
29F06116Employee Transaction Detail File60YTPDBADBA CodeNumericGeneric Edit50
30F06116Z1Employee Transactions - Batch File71VLPDBADBA CodeNumericGeneric Edit50
31F06116Z2ESS Timecard History71VMPDBADBA CodeNumericGeneric Edit50
32F0624Burden Distribution File3J#PDBADBA CodeNumericGeneric Edit50
33F06241Burden Distribution File3J#PDBADBA CodeNumericGeneric Edit50
34F06278Retro Timecard Detail File57YTPDBADBA CodeNumericGeneric Edit50
35F06290Payroll Accounting Journal Work File21YRPDBADBA CodeNumericGeneric Edit50
36F06904Automatic Accounting Instructions5Y#PDBADBA CodeNumericGeneric Edit50
37F069136Tip Disbursement8JEPDBADBA CodeNumericGeneric Edit50
TOP06: Payroll (old) - Obsolete-do not reuse
38F06146Employee Transaction History Summary2YNPDBADBA CodeNumericGeneric Edit50
TOP07: Payroll
39F05290WF - Payroll Journal (Detail)37JRPDBADBA CodeNumericGeneric Edit50
40F06147Fiscal and Anniversary Year History2YDPDBADBA CodeNumericGeneric Edit50
41F06148Tax Area Transaction History3Y@PDBADBA CodeNumericGeneric Edit50
42F06270Retro Processing Parameter9JPPDBADBA CodeNumericGeneric Edit50
43F063106Deduction/Benefit Work File3Y7PDBADBA CodeNumericGeneric Edit50
44F06350IWF - Paycheck (Interims)15Y4PDBADBA CodeNumericGeneric Edit50
45F06490Payroll/Accounts Payable Ledger Detail11JRPDBADBA CodeNumericGeneric Edit50
46F0690361Employee Rollover Table Overrides2ROPDBADBA CodeNumericGeneric Edit50
47F0705DBA Period Control File2J@PDBADBA CodeNumericGeneric Edit50
48F07107Employee Wage Attachment Rules2JWPDBADBA CodeNumericGeneric Edit50
49F071073Employee Level Multi Wage Attachment Rules2J3PDBADBA CodeNumericGeneric Edit50
50F071074Wage Attachment Exemption Rules2WEPDBADBA CodeNumericGeneric Edit50
51F071075Wage Attachment Child Support EFT Detail2JWPDBADBA CodeNumericGeneric Edit50
52F07149Accrual Fiscal/Anniversary History Work File3Y8PDBADBA CodeNumericGeneric Edit50
53F0716701Employee Assignment T/E Template Information2EAPDBADBA CodeNumericGeneric Edit50
54F0716702Employee Assignment Rates3EAPDBADBA CodeNumericGeneric Edit50
55F0716704Employee Assignment Default Pay Type2EAPDBADBA CodeNumericGeneric Edit50
56F0716709Employee Assignment T/E Template Info History2EAPDBADBA CodeNumericGeneric Edit50
57F07186Stub Information History Table3Y8PDBADBA CodeNumericGeneric Edit50
58F0719DBA Transaction Detail History7Y$PDBADBA CodeNumericGeneric Edit50
59F0724Burden Distribution File6YSPDBADBA CodeNumericGeneric Edit50
60F07241Burden Distribution File6YSPDBADBA CodeNumericGeneric Edit50
61F0728Employee Paid Workers Compensation Transactions5YWPDBADBA CodeNumericGeneric Edit50
62F0729Employee DBA Override Instructions4Y9PDBADBA CodeNumericGeneric Edit50
63F07352Stub Information File3Y2PDBADBA CodeNumericGeneric Edit50
64F07355Pre-Payroll Error File16Y5PDBADBA CodeNumericGeneric Edit50
65F07390Year-End Rollover Workfile1ROPDBADBA CodeNumericGeneric Edit50
66F073911Leave Rollover Balance Report Work File5Y8PDBADBA CodeNumericGeneric Edit50
67F07490Payroll - Accounts Payable Detail (One World)10JRPDBADBA CodeNumericGeneric Edit50
68F077021Transaction History Integrity(Temp)8Y$PDBADBA CodeNumericGeneric Edit50
69F07811Negative Amount Workfile8JEPDBADBA CodeNumericGeneric Edit50
70F07815Special Handling Codes Setup4YFPDBADBA CodeNumericGeneric Edit50
71F07825Company Special Handling Control Table12JAPDBADBA CodeNumericGeneric Edit50
72F07832Employee Special Handling Control Table9YHPDBADBA CodeNumericGeneric Edit50
73F078505ADP PDBA Quarterly Table Setup2YAPDBADBA CodeNumericGeneric Edit50
74F079425Prevailing Wage DBA Range2PRPDBADBA CodeNumericGeneric Edit50
75F079435Prevailing Wage Fringe Detail3PFPDBADBA CodeNumericGeneric Edit50
76F079445Prevailing Wage Fringe History3PHPDBADBA CodeNumericGeneric Edit50
77F07991Deduction, Benefit, Accrual History Conversion Data4YXPDBADBA CodeNumericGeneric Edit50
78F07UI200Timecard History Work File63THPDBADBA CodeNumericGeneric Edit50
TOP08: Human Resources
79F083303Benefit Statement Cross Reference Detail4CRPDBADBA CodeNumericGeneric Edit50
TOP08AD: ADP Integration
80F051371ADP Employee DBA Instructions8ADPDBADBA CodeNumericGeneric Edit50
81F051375ADP Payroll DBA Transaction Constants15ADPDBADBA CodeNumericGeneric Edit50
TOP08B: Benefits Administration
82F083203Plan Master Rates3BGPDBADBA CodeNumericGeneric Edit50
83F08345401(k) Elections Setup2B3PDBADBA CodeNumericGeneric Edit50
84F08346401(K) Elections4B4PDBADBA CodeNumericGeneric Edit50
85F08370Reimbursement Spending Acct - Balance File5B7PDBADBA CodeNumericGeneric Edit50
86F08371Reimbursement Spending Account Claims File15B6PDBADBA CodeNumericGeneric Edit50
87F08381WFRecalculate Plan Option Costs7RCPDBADBA CodeNumericGeneric Edit50
88F08515Plan DBA/Enrollment DBA Cross Reference1QBPDBADBA CodeNumericGeneric Edit50
89F085573WEntered Benefit Amount/Rate Edits2MMPDBADBA CodeNumericGeneric Edit50
TOP08U: PeopleSoft HR US
90F08360Nondiscrimination Groups28HEPDBADBA CodeNumericGeneric Edit50
TOP09E: Expense Reimbursment
91F09E118Expense Category / Report Type to Pay Type Mapping5PMPDBADBA CodeNumericGeneric Edit50
TOP17C: Call Management
92F1760Time Entry35ZBPDBADBA CodeNumericGeneric Edit50
TOP18: Timecard Automation
93F186301Timecard Templates5TTPDBADBA CodeNumericGeneric Edit50
94F186408Overtime Rule Pay Type Inclusions2PIPDBADBA CodeNumericGeneric Edit50
95F186702Retropay Rules Paytype Inclusions2PIPDBADBA CodeNumericGeneric Edit50
TOP48S: Service Billing
96F48096Billing Rate / Mark up Table12WQPDBADBA CodeNumericGeneric Edit50
97F4812Billing Detail Workfile36WDPDBADBA CodeNumericGeneric Edit50
98F4812HBilling Workfile History36WDPDBADBA CodeNumericGeneric Edit50
99F4812HSBilling Workfile History Purged Save36WDPDBADBA CodeNumericGeneric Edit50
100F48S0618Payroll Reclassification Workfile60YTPDBADBA CodeNumericGeneric Edit50
101F48SUI01Billing Detail Print Workfile36WDPDBADBA CodeNumericGeneric Edit50
TOP52: Contract Billing
102F5212T and M, Unit Price and Lumpsum Cross Reference Accounts15G5PDBADBA CodeNumericGeneric Edit50
103F5214Component Code/Burden Cross Reference Table8A4PDBADBA CodeNumericGeneric Edit50
104F5215Component/Burden Billing Line Cross Reference Details10A5PDBADBA CodeNumericGeneric Edit50
TOP52G: Proj & Gov Contract Accounting
105F52G90Invoice Printing Work Table40WTPDBADBA CodeNumericGeneric Edit50
TOP75A: Australia
106F75A0009Employee DBA Instructions2A9PDBADBA CodeNumericGeneric Edit50
107F75A0405Australia State Payroll Tax Eligible PDBs1ZPPDBADBA CodeNumericGeneric Edit50
108F75A0406Australia State Payroll Taxable Wages History4ZHPDBADBA CodeNumericGeneric Edit50
109F75A670Long Service Leave Dates5LLPDBADBA CodeNumericGeneric Edit50
110F75A671Long Service Leave Audit2LAPDBADBA CodeNumericGeneric Edit50
TOP75Z: New Zealand
111F75Z0001New Zealand Special Processing Parameters1Z1PDBADBA CodeNumericGeneric Edit50
112F75Z0006Leave Taken A.G.E. Work File3Z6PDBADBA CodeNumericGeneric Edit50
TOP77: Payroll (Canadian)
113F07183Commission History Detail File7ZBPDBADBA CodeNumericGeneric Edit50
114F77190Special Handling Setup - F771906J2PDBADBA CodeNumericGeneric Edit50
115F77220Employee Special Handling Detail - F7722011J3PDBADBA CodeNumericGeneric Edit50
116F77703Payroll History Audit Report - Worktable10ARPDBADBA CodeNumericGeneric Edit50