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?910 | VN05 | STOCK UDC

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

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