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

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

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
2ADLAnnual Dollar LimitNY
3AGEAgeNY
4AN8Address NumberNY
5ARRAArreageNY
6BHRTHourly Rate BaseNY
7CKCNCheck Control NumberNY
8CKDTCheck DateDY
9CLBSCalculation BasisNY
10CMAXCarryover MaximumNY
11DAAFDeduction FactorNY
12DBADETAILDBA Detail Cache NameSY
13DCLCAccrue DaysCY
14DDADDays WorkedNY
15DEDMMethod of CalculationCY
16DEFRRate ControlCY
17DESQSource of CalculationCY
18DGRPDeduction GroupSY
19DOBDate of BirthDY
20DPR1Proration Factor 1NY
21DPR2Proration Factor 2NY
22DSIOriginal EmploymentDY
23DSTDate StartedDY
24DTABTable CodeSY
25DTEYPay Period YearNY
26ED01User Defined Date 01DY
27ED02User Defined Date 02DY
28ED03User Defined Date 03DY
29ED04User Defined Date 04DY
30ED05User Defined Date 05DY
31ED06User Defined Date 06DY
32ED07User Defined Date 07DY
33ED08User Defined Date 08DY
34ED09User Defined Date 09DY
35ED10User Defined Date 10DY
36ED11User Defined Date 11DY
37ED12User Defined Date 12DY
38ED13User Defined Date 13DY
39ED14User Defined Date 14DY
40ED15User Defined Date 15DY
41ED16User Defined Date 16DY
42ED17User Defined Date 17DY
43ED18User Defined Date 18DY
44ED19User Defined Date 19DY
45ED20User Defined Date 20DY
46EGPAEligible Gross (Retirement)NY
47EKY1Error MessageSY
48ESALEstimated SalaryNY
49EXRTExperience RateNY
50FAGEAgeNY
51FREQPay FrequencyNY
52FSALFixed Insurance SalaryNY
53FT2Table Amount 1NY
54FT3RateNY
55FT4Amount 2NY
56FTCTable CodeNY
57GADL.NY
58GNUMGeneric Numeric ValueNY
59GPAGross PayNY
60GPAWGross Wages (MTD Or YTD)NY
61GPY1Amount Gross Pay 1 (WA)NY
62HMAXHourly MaximumNY
63HMINHourly MinimumNY
64HPPGHistorical Source Period GrossNY
65HPPHHistorical Source Period HoursNY
66JBCDJob TypeSY
67JBSTJob StepSY
68JOBSAuto Pay Job NumberNY
69LCLLower LimitNY
70LSALInsurance SalaryNY
71LSDTLeave Begin DateDY
72MCUOJob LocationSY
73MINMinimum FlagCY
74MSTXMarital Status for TaxesCY
75NPAYNet PayNY
76NPAY1Gross - Mandatory - TaxNY
77NPAY2Gross - TaxNY
78NPY1Net Pay 1NY
79PADTParticipation DateDY
80PAYDPayroll IDSY
81PBASPay Period Disposable Wage (WANY
82PBRTRate DistributionNY
83PCUNPieces or UnitsNY
84PDBAPayroll Ded/Ben/AccNY
85PEDTPayroll End DateDY
86PFUDC Code TypeSY
87PFRQPay Freq CodeCY
88PGPAPay Period Gross Amount (WA)NY
89PHRTHourly RateNY
90PHRWHoursNY
91PNPAYPeriod Net PayNY
92PPBDPay Period Begin DateDY
93PPEDPay Period End DateDY
94PPMOPay Period MonthNY
95PPPLLimit on Pay Period PercentNY
96PPRDPay PeriodNY
97PPRTPiece RateNY
98PRFXProration FactorNY
99PRUMPayroll Unit of MeasureSY
100PSDTPayroll Start DateDY
101PWTHPercent Withheld (RETIREMENT)NY
102RATRate or AmountNY
103RHRWHours Worked (Work Field)NY
104RTABRollover TableSY
105RTAMRate or AmountNY
106SAGESpouse AgeNY
107SALAnnual Salary or RateNY
108SALRSalary (Work Field Only)NY
109SDOBSpouse Date of BirthDY
110SFQPay FrequencyCY
111SFQOWPay FrequencyCY
112SLAMTSpouse Life Insurance AmountNY
113TABTTable TypeCY
114TCDAEFTimecard Date Effectivity FlagCY
115TGRSTotal GrossNY
116THRSTotal HoursNY
117TIMECARDTimecard Cache NameSY
118TOTLTotal (Work Field Only)NY
119TRANDETAILTransaction Detail Cache NameSY
120TTDETotal DeductionsNY
121TTHSTotal HoursNY
122U1DTGeneric Work DateDY
123UCLUpper LimitNY
124UCL2Upper Limit 2NY
125UKIDUnique IDNY
126UNUnionSY
127VERSTETime Entry VersionSY
128WANOWage Attachment NumberNY
129WAPFChild Support Split Flag (WA)CY
130WATATotal Wage Attachment AmountsNY
131WKSVWeeks of Service FlagCY
132WMANDWorking Mandatory DeductionsNY
133WVOLWorking Voluntary DeductionsNY