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?812 | 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 1N
3       03BAmounts added to Box 3N
4       05BAmounts added to Box 5N
5       10BAmounts reported in Box 10N
6       11BAmounts reported in Box 11N
7       12BAmounts reported in Box 12N
8       13BAmounts reported in Box 13N
9       14 Employment Income Before Ded.N
10       14BAmounts reported in Box 14N
11       14TTier I AmountsN
12       16 Canada/Quebec Pension PlanN
13       16APension or SuperannuationN
14       17BAmounts added bo Box 17N
15       18 Employee's UI PremiumsN
16       18ALump-sum paymentsN
17       20 Reg. Retirement Savings PlanN
18       20ASelf-employed commissionsN
19       20BAmounts added to Box 20N
20       21BAmounts added to Box 21N
21       22 Income Tax DeductedN
22       22AIncome Tax IncludedN
23       24 UI Insurable EarningsN
24       24AAnnuitiesN
25       26 CPP/QPP Pensionable EarningsN
26       26ARetiring AllowancesN
27       28AOther IncomeN
28       30 Housing, Board and LodgingN
29       30APatronage allocationsN
30       32 Travel In a Prescribed AreaN
31       32ARegistered pension planN
32       34 Personal Use of Employers AutoN
33       34APension AdjustmentsN
34       36 Low/No Interest LoansN
35       38 Stock Option BenefitsN
36       40 Other TXBl Allowances/BenefitsN
37       40TAlbertaN
38       42 Self-Employment CommissionsN
39       44 Union DuesN
40       46 Charitable DonationsN
41       48 Payments to a DPSPN
42       4TPStep Progression Pay Tapes TblN
43       52 Pension AdjustmentN
44       A  Employment IncomeN
45       AB AlbertaN
46       ALCAllocated TipsN
47       B  Employees QPP ContributionsN
48       BC British ColumbiaN
49       C  Employees UIC ContributionsN
50       C01Colorado - Exclude Sick PayN
51       CA CaliforniaN
52       CO ColoradoN
53       CODCoda AmountsN
54       COMCommission AmountsN
55       CONConcession AmountsN
56       COUAmounts added to Box 20N
57       D  Reg. Pension Plan ContributionN
58       DEPDependent CareN
59       DFCDefferred CompensationN
60       E  Quebec Income Tax WithheldN
61       ECTEmployee Contribution AmountsN
62       EPP109 Excess Golden ParachuteN
63       F  Union DuesN
64       FL FloridaN
65       FRBFringe BenefitsN
66       G  QPP Pensionable EarningsN
67       GRDGross Distribution AmountsN
68       GTLGroup Term LifeN
69       H  Food and LodgingN
70       I  User of Employer's CarN
71       IL IllinoisN
72       J  Private Health PlanN
73       K  Trips Within a Prescribed AreaN
74       L  Other BenefitsN
75       LOCAmounts added to Box 20N
76       M  CommissionsN
77       MB ManitobaN
78       MHCMedical & Health Care AmountsN
79       MINTipped Employee Minimum WageN
80       MO MissouriN
81       N  Charitable DonationsN
82       N41Gross IncomeN
83       N42Non-resident tax withheldN
84       NB New BrunswickN
85       NECNon-Employee Comp. AmountsN
86       NF NewfoundlandN
87       NM Next Method for ProgressionN
88       NQ4NR4 Special Handling TestN
89       NQPNon-Qualified Plan AmountsN
90       NS Nova ScotiaN
91       NT Northwest TerritoriesN
92       NY New YorkN
93       O  Other Taxable BenefitsN
94       OH OhioN
95       ON OntarioN
96       OTHOther IncomeN
97       P  Multi-Employer InsuranceN
98       PA PennsylvaniaN
99       PNSPension Pay AmountsN
100       Q  Deferred Salary or WagesN
101       QC QuebecN
102       R  Tax Exempt Inc./Status IndianN
103       R2 Releve 2-FootnoteN
104       R2ALife Annuity paymentsN
105       R2BBenefitsN
106       R2COther PaymentsN
107       R2DRefund of RRSPN
108       R2EAmt Received prior to deathN
109       R2FRefund of undeductedN
110       R2GAmount received upon revocatioN
111       R2HOther income from an RRSP/RRIFN
112       R2IAmt giving entitlementN
113       R2JQuebec Income TaxN
114       R2KTax-paid amountsN
115       REMReimbursed Expense AmountsN
116       RETRetirement Fund AmountsN
117       RPPRegistered Pension PlanN
118       RTDRent AmountsN
119       RTSRent AmountsN
120       RYTRoyality AmountsN
121       S  TipsN
122       SCHSchool District TaxN
123       SCWSchool District WagesN
124       SK SaskatchewanN
125       SPYSubstitute Payment AmountsN
126       STPStep Progression Pay TypesN
127       T4AT4A FootnoteN
128       TPS3rd Party SickN
129       TX TexasN
130       VA VirginiaN
131       WA Washington StateN
132       WAFWashington State - Water RatesN
133       WY WyomingN
134       XSLGroup Term LifeN
135       YT Yukon TerritoryN
136       ZZ Other AreasN