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 | VN16 | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP07: Payroll
1F07901Pre-Payroll DBA Calculation Control Table21Y5VN16Variable Name 16StringUDC100

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

TOPUDC 07 / VN (Variable Name) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1          .AY
2ADL       Annual Dollar LimitNY
3AGE       AgeNY
4AN8       Address NumberNY
5ARRA      ArreageNY
6BHRT      Hourly Rate BaseNY
7CKCN      Check Control NumberNY
8CMAX      Carryover MaximumNY
9DCLC      Accrue DaysCY
10DDAD      Days WorkedNY
11DEDM      Method of CalculationCY
12DEFR      Rate ControlCY
13DESQ      Source of CalculationCY
14DGRP      Deduction GroupSY
15DOB       Date of BirthDY
16DPR1      Proration Factor 1NY
17DPR2      Proration Factor 2NY
18DSI       Original EmploymentDY
19DST       Date StartedDY
20DTAB      Table CodeSY
21DTEY      Pay Period YearNY
22ED01      User Defined Date 01DY
23ED02      User Defined Date 02DY
24ED03      User Defined Date 03DY
25ED04      User Defined Date 04DY
26ED05      User Defined Date 05DY
27ED06      User Defined Date 06DY
28ED07      User Defined Date 07DY
29ED08      User Defined Date 08DY
30ED09      User Defined Date 09DY
31ED10      User Defined Date 10DY
32ED11      User Defined Date 11DY
33ED12      User Defined Date 12DY
34ED13      User Defined Date 13DY
35ED14      User Defined Date 14DY
36ED15      User Defined Date 15DY
37ED16      User Defined Date 16DY
38ED17      User Defined Date 17DY
39ED18      User Defined Date 18DY
40ED19      User Defined Date 19DY
41ED20      User Defined Date 20DY
42EKY1      Error MessageSY
43ESAL      Estimated SalaryNY
44EXRT      Experience RateNY
45FAGE      AgeNY
46FREQ      Pay FrequencyNY
47FSAL      Fixed Insurance SalaryNY
48FT2       Table Amount 1NY
49FT3       RateNY
50FT4       Amount 2NY
51FTC       Table CodeNY
52GNUM      Generic Numeric ValueNY
53GPA       Gross PayNY
54GPAW      Gross Wages (MTD Or YTD)NY
55GPY1      Amount Gross Pay 1 (WA)NY
56HMAX      Hourly MaximumNY
57HMIN      Hourly MinimumNY
58HPPG      Historical Source Period GrossNY
59HPPH      Historical Source Period HoursNY
60LCL       Lower LimitNY
61LSAL      Insurance SalaryNY
62LSDT      Leave Begin DateDY
63MIN       Minimum FlagCY
64MSTX      Marital Status for TaxesCY
65NPAY      Net PayNY
66NPAY1     Gross - Mandatory - TaxNY
67NPAY2     Gross - TaxNY
68NPY1      Net Pay 1NY
69PADT      Participation DateDY
70PBAS      Pay Period Disposable Wage (WANY
71PBRT      Rate DistributionNY
72PCUN      Pieces or UnitsNY
73PDBA      Payroll Ded/Ben/AccNY
74PEDT      Payroll End DateDY
75PF        UDC Code TypeSY
76PFRQ      Pay Freq CodeCY
77PFRX      Proration FactorNY
78PGPA      Pay Period Gross Amount (WA)NY
79PHRT      Hourly RateNY
80PHRW      HoursNY
81PPBD      Pay Period Begin DateDY
82PPED      Pay Period End DateDY
83PPMO      Pay Period MonthNY
84PPPL      Limit on Pay Period PercentNY
85PPRD      Pay PeriodNY
86PPRT      Piece RateNY
87PRUM      Payroll Unit of MeasureSY
88PSDT      Payroll Start DateDY
89RAT       Rate or AmountNY
90RHRW      Hours Worked (Work Field)NY
91RTAB      Rollover TableSY
92RTAM      Rate or AmountNY
93SAGE      Spouse AgeNY
94SAL       Annual Salary or RateNY
95SALR      Salary (Work Field Only)NY
96SDOB      Spouse Date of BirthDY
97SFQ       Pay FrequencyCY
98SFQOW     Pay FrequencyCY
99SLAMT     Spouse Life Insurance AmountNY
100TABT      Table TypeCY
101TGRS      Total GrossNY
102THRS      Total HoursNY
103TOTL      Total (Work Field Only)NY
104TTDE      Total DeductionsNY
105TTHS      Total HoursNY
106U1DT      Generic Work DateDY
107UCL       Upper LimitNY
108UCL2      Upper Limit 2NY
109WANO      Wage Attachment NumberNY
110WAPF      Child Support Split Flag (WA)CY
111WATA      Total Wage Attachment AmountsNY
112WKSV      Weeks of Service FlagCY
113WMAND     Working Mandatory DeductionsNY
114WVOL      Working Voluntary DeductionsNY