JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

1 column | Print definition?920 | W250 | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP07: Payroll
1F06720W-2/1099 Processing Control107JEW250Included Pay Type Table 50StringUDC30

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 06 / IP (Basis Table Codes) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1 . N
2       01BAmounts added to Box 1 N
3       03BAmounts added to Box 3 N
4       05BAmounts added to Box 5 N
5       10BAmounts reported in Box 10 N
6       11BAmounts reported in Box 11 N
7       12BAmounts reported in Box 12 N
8       13BAmounts reported in Box 13 N
9       14Employment Income Before Ded. N
10       14BAmounts reported in Box 14 N
11       14TTier I Amounts N
12       16Canada/Quebec Pension Plan N
13       16APension or Superannuation N
14       17BAmounts added bo Box 17 N
15       18Employee's EI Premium N
16       18ALump-sum payments N
17       20Reg. Retirement Savings Plan N
18       20ASelf-employed commissions N
19       20BAmounts added to Box 20 N
20       21BAmounts added to Box 21 N
21       22Income Tax Deducted N
22       22AIncome Tax Included N
23       24EI Insurable Earnings N
24       24AAnnuities N
25       26CPP/QPP Pensionable Earnings N
26       26ARetiring Allowances N
27       28AOther Income N
28       30Housing, Board and Lodging N
29       30APatronage allocations N
30       32Travel In a Prescribed Area N
31       32ARegistered pension plan N
32       34Personal Use of Employers Auto N
33       34APension Adjustments N
34       36Low/No Interest Loans N
35       38Stock Option Benefits N
36       40Other TXBl Allowances/Benefits N
37       40TAlberta N
38       42Self-Employment Commissions N
39       44Union Dues N
40       46Charitable Donations N
41       48Payments to a DPSP N
42       4TPStep Progression Pay Tapes Tbl N
43       52Pension Adjustment N
44       AEmployment Income N
45       ABAlberta N
46       ALCAllocated Tips N
47       BEmployees QPP Contributions N
48       BCBritish Columbia N
49       CEmployees EIC Contributions N
50       C01Colorado - Exclude Sick Pay N
51       CACalifornia N
52       COColorado N
53       CODCoda Amounts N
54       COMCommission Amounts N
55       CONConcession Amounts N
56       COUAmounts added to Box 20 N
57       DReg. Pension Plan Contribution N
58       DEPDependent Care N
59       DFCDefferred Compensation N
60       EQuebec Income Tax Withheld N
61       ECTEmployee Contribution Amounts N
62       EPP109 Excess Golden Parachute N
63       FUnion Dues N
64       FLFlorida N
65       FRBFringe Benefits N
66       GQPP Pensionable Earnings N
67       GRDGross Distribution Amounts N
68       GTLGroup Term Life N
69       HFood and Lodging N
70       IUser of Employer's Car N
71       ILIllinois N
72       JPrivate Health Plan N
73       JOBJob Step Progession Basis Tbl N
74       KTrips Within a Prescribed Area N
75       LOther Benefits N
76       LOCAmounts added to Box 20 N
77       MCommissions N
78       MBManitoba N
79       MHCMedical & Health Care Amounts N
80       MINTipped Employee Minimum Wage N
81       MOMissouri N
82       NCharitable Donations N
83       N41Gross Income N
84       N42Non-resident tax withheld N
85       NBNew Brunswick N
86       NECNon-Employee Comp. Amounts N
87       NFNewfoundland N
88       NMNext Method for Progression N
89       NQ4NR4 Special Handling Test N
90       NQPNon-Qualified Plan Amounts N
91       NSNova Scotia N
92       NTNorthwest Territories N
93       NYNew York N
94       OOther Taxable Benefits N
95       OHOhio N
96       ONOntario N
97       OTHOther Income N
98       PMulti-Employer Insurance N
99       PAPennsylvania N
100       PNSPension Pay Amounts N
101       QDeferred Salary or Wages N
102       QCQuebec N
103       RTax Exempt Inc./Status Indian N
104       R2Releve 2-Footnote N
105       R2ALife Annuity payments N
106       R2BBenefits N
107       R2COther Payments N
108       R2DRefund of RRSP N
109       R2EAmt Received prior to death N
110       R2FRefund of undeducted N
111       R2GAmount received upon revocatio N
112       R2HOther income from an RRSP/RRIF N
113       R2IAmt giving entitlement N
114       R2JQuebec Income Tax N
115       R2KTax-paid amounts N
116       REMReimbursed Expense Amounts N
117       RETRetirement Fund Amounts N
118       RPPRegistered Pension Plan N
119       RTDRent Amounts N
120       RTSRent Amounts N
121       RYTRoyality Amounts N
122       STips N
123       SCHSchool District Tax N
124       SCWSchool District Wages N
125       SKSaskatchewan N
126       SPYSubstitute Payment Amounts N
127       STPStep Progression Pay Types N
128       T4AT4A Footnote N
129       TPS3rd Party Sick N
130       TXTexas N
131       VAVirginia N
132       WAWashington State N
133       WAFWashington State - Water Rates N
134       WYWyoming N
135       XSLGroup Term Life N
136       YTYukon Territory N
137       ZZOther Areas N