JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool
08AD: ADP Integration
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F051375AD1332ADP Payroll DBA Transaction ConstantsTransaction Files08AD: ADP IntegrationBusiness Data
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT ADCHGF, ADPAYBN, ADANN8, ADEXA, ADDC, ADPGRP, ADPAYG, ADPAYN, ADDTAB, ADSPW2, ADPB, ADDESQ, ADMV, ADDISO, ADPDBA, ADPCK, ADDEDM, ADUM, ADRTAM, ADPAYM, ADSHD, ADCMTH, ADPPDL, ADMDL, ADADL, ADPPPL, ADNP, ADAD, ADACO, ADAI, ADHMIN, ADHMAX, ADIIAP, ADDEP1, ADDEP2, ADDEP3, ADDEP4, ADDEP5, ADDEP6, ADTT01, ADTT02, ADTT03, ADTT04, ADTT05, ADTT06, ADTT07, ADTT08, ADTT09, ADTT10, ADTT11, ADTT12, ADTT13, ADTT14, ADTT15, ADNMTH, ADPDED, ADDPRI, ADDGRP, ADDBAL, ADARRR, ADNPER, ADSVCD, ADQDL, ADSVH, ADAAF, ADPTCT, ADCPE, ADEFTB, ADEFTE, ADACEQ, ADSADL, ADSDED, ADAMTS, ADPR01, ADPR02, ADPR03, ADPR04, ADPR05, ADTASF, ADTRPF, ADSALY, ADCOVA, ADTRID, ADTYST, ADBENF, ADPPPM, ADEPRI, ADPTER, ADSTAB, ADCMAX, ADRTAB, ADTARA, ADHMCO, ADPGM1, ADPGM2, ADTDBA, ADCMHU, ADBDT, ADDBAS, ADUDBA, ADAIGR, ADPR06, ADPR07, ADPR08, ADPR09, ADPR10, ADPR11, ADPR12, ADPR13, ADPR14, ADUSER, ADPR15, ADPID, ADPR16, ADUPMJ, ADPR17, ADPR18, ADPR19, ADPR20, ADODBA, ADSACC, ADCALC, ADPPRY, ADGVCH, ADPRTX, ADF415, ADCLCI, ADRYTP, ADAFDT, ADSHDL, ADCHCK, ADLVPT, ADPHISH FROM F051375

TOP920 | 08AD | F051375 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ADCHGFChange FlagCharacterGeneric Edit10 Allow NULL? 
2ADPAYBNPayroll Batch NumberNumericGeneric Edit80 Allow NULL? 
3ADANN8Address Number-Provider/TrusteeNumericGeneric Edit80 Allow NULL? 
4ADEXAName - Alpha ExplanationStringGeneric Edit300 Allow NULL? 
5ADDCDescription - CompressedStringGeneric Edit400 Allow NULL? 
6ADPGRPDeduct/Benefit Override CodeStringGeneric Edit20 Allow NULL? 
7ADPAYGEffect on Gross PayCharacterUDC (07 PA)10 Allow NULL? 
8ADPAYNEffect on Net PayCharacterUDC (07 PA)10 Allow NULL? 
9ADDTABTable CodeStringGeneric Edit50 Allow NULL? 
10ADSPW2W-2 IRS Defined CodeStringUDC (06 S2)20 Allow NULL? 
11ADPBSource of PayCharacterUDC (06 PB)10 Allow NULL? 
12ADDESQSource of CalculationCharacterUDC (06 DB)10 Allow NULL? 
13ADMVEffect on Disposable WageCharacterUDC (05A MV)10 Allow NULL? 
14ADDISODBA TypeCharacterUDC (05 DI)10 Allow NULL? 
15ADPDBADBA CodeNumericGeneric Edit50 Allow NULL? 
16ADPCKMethod of PrintingCharacterUDC (05A PT)10 Allow NULL? 
17ADDEDMMethod of CalculationCharacterUDC (06 DM)10 Allow NULL? 
18ADUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
19ADRTAMAmount or RateNumericGeneric Edit94 Allow NULL? 
20ADPAYMMultiplier - Pay Type MultiplierNumericGeneric Edit52 Allow NULL? 
21ADSHDAmount - Shift DifferentialNumericGeneric Edit93 Allow NULL? 
22ADCMTHShift Diff Calc SequenceCharacterUDC (07 CO)10 Allow NULL? 
23ADPPDLPay Period LimitNumericGeneric Edit152 Allow NULL? 
24ADMDLMonthly LimitNumericGeneric Edit152 Allow NULL? 
25ADADLAnnual LimitNumericGeneric Edit152 Allow NULL? 
26ADPPPLLimit on Pay Period PercentNumericGeneric Edit154 Allow NULL? 
27ADNPNumber of Deduction PeriodsNumericGeneric Edit40 Allow NULL? 
28ADADAmount - DueNumericGeneric Edit152 Allow NULL? 
29ADACOAvailable DBACharacterGeneric Edit10 Allow NULL? 
30ADAIType - SalesCharacterUDC10 Allow NULL? 
31ADHMINHours - MinimumNumericGeneric Edit152 Allow NULL? 
32ADHMAXHours - MaximumNumericGeneric Edit152 Allow NULL? 
33ADIIAPAuto Pay MethodsCharacterUDC (07 II)10 Allow NULL? 
34ADDEP1Deduction Period 1CharacterUDC (05A DD)10 Allow NULL? 
35ADDEP2Deduction Period 2CharacterUDC (05A DD)10 Allow NULL? 
36ADDEP3Deduction Period 3CharacterUDC (05A DD)10 Allow NULL? 
37ADDEP4Deduction Period 4CharacterUDC (05A DD)10 Allow NULL? 
38ADDEP5Deduction Period 5CharacterUDC (05A DD)10 Allow NULL? 
39ADDEP6Deduction Period 6CharacterUDC (05A DD)10 Allow NULL? 
40ADTT01Non-Taxable Authority Types 01StringUDC (06 TX)20 Allow NULL? 
41ADTT02Non-Taxable Authority Types 02StringUDC (06 TX)20 Allow NULL? 
42ADTT03Non-Taxable Authority Types 03StringUDC (06 TX)20 Allow NULL? 
43ADTT04Non-Taxable Authority Types 04StringUDC (06 TX)20 Allow NULL? 
44ADTT05Non-Taxable Authority Types 05StringUDC (06 TX)20 Allow NULL? 
45ADTT06Non-Taxable Authority Types 06StringUDC (06 TX)20 Allow NULL? 
46ADTT07Non-Taxable Authority Types 07StringUDC (06 TX)20 Allow NULL? 
47ADTT08Non-Taxable Authority Types 08StringUDC (06 TX)20 Allow NULL? 
48ADTT09Non-Taxable Authority Types 09StringUDC (06 TX)20 Allow NULL? 
49ADTT10Non-Taxable Authority Types 10StringUDC (06 TX)20 Allow NULL? 
50ADTT11Non-Taxable Authority Types 11StringUDC (06 TX)20 Allow NULL? 
51ADTT12Non-Taxable Authority Types 12StringUDC (06 TX)20 Allow NULL? 
52ADTT13Non-Taxable Authority Types 13StringUDC (06 TX)20 Allow NULL? 
53ADTT14Non-Taxable Authority Types 14StringUDC (06 TX)20 Allow NULL? 
54ADTT15Non-Taxable Authority Types 15StringUDC (06 TX)20 Allow NULL? 
55ADNMTHEffect on GLCharacterUDC10 Allow NULL? 
56ADPDEDDBA For Prior LimitNumericGeneric Edit50 Allow NULL? 
57ADDPRIOrder To Adjust DedNumericGeneric Edit50 Allow NULL? 
58ADDGRPGroup Limit CodeStringUDC (06 GR)20 Allow NULL? 
59ADDBALDeclining Balance (Y N)CharacterGeneric Edit10 Allow NULL? 
60ADARRRArrearage MethodCharacterUDC (05A AR)10 Allow NULL? 
61ADNPERNumber of Deduction PeriodsCharacterGeneric Edit10 Allow NULL? 
62ADSVCDDate - ServiceDateGeneric Edit60
63ADQDLQuarterly LimitNumericGeneric Edit152 Allow NULL? 
64ADSVHBenefit/Accrual TypeCharacterUDC (06 SV)10 Allow NULL? 
65ADAAFVacation FactorCharacterUDC (07 AA)10 Allow NULL? 
66ADPTCTPay Type CategoryCharacterUDC (06 PC)10 Allow NULL? 
67ADCPECOBRA PlanNumericGeneric Edit50 Allow NULL? 
68ADEFTBDate - Beginning EffectiveDateGeneric Edit60
69ADEFTEDate - Ending EffectiveDateGeneric Edit60
70ADACEQAccrual EquivalentNumericGeneric Edit50 Allow NULL? 
71ADSADLAnnual Limit (Level 2)NumericGeneric Edit152 Allow NULL? 
72ADSDEDDeduction Number - SubsequentNumericGeneric Edit50 Allow NULL? 
73ADAMTSAmount or Rate - SecondaryNumericGeneric Edit154 Allow NULL? 
74ADPR01Report Codes - P/R Transaction 01StringUDC (06 T1)30 Allow NULL? 
75ADPR02Report Codes - P/R Transaction 02StringUDC (06 T2)30 Allow NULL? 
76ADPR03Report Codes - P/R Transaction 03StringUDC (06 T3)30 Allow NULL? 
77ADPR04Report Codes - P/R Transaction 04StringUDC (06 T4)30 Allow NULL? 
78ADPR05Report Codes - P/R Transaction 05StringUDC (06 T5)30 Allow NULL? 
79ADTASFLimit MethodCharacterUDC (07 TL)10 Allow NULL? 
80ADTRPFCalc For All Emp (Y N)CharacterUDC (05 YN)10 Allow NULL? 
81ADSALYPay Class (H/S/P)CharacterUDC (05A PK)10 Allow NULL? 
82ADCOVAAmount - CoverageNumericGeneric Edit152 Allow NULL? 
83ADTRIDTrans. Code - IdentifierStringGeneric Edit20 Allow NULL? 
84ADTYSTTrans. Code - Status CodeCharacterUDC (05 YN)10 Allow NULL? 
85ADBENFTrans. Code - Beneficiary FlagCharacterUDC (08 DC)10 Allow NULL? 
86ADPPPMLimit on Pay Period Percent - MinimumNumericGeneric Edit154 Allow NULL? 
87ADEPRIWhen To Adjust DedCharacterUDC (05A EP)10 Allow NULL? 
88ADPTERCanadian EI Allocation FlagCharacterCheck Box10 Allow NULL? 
89ADSTABBenefit/Deduction Table - SecondaryStringGeneric Edit50 Allow NULL? 
90ADCMAXInception to Date LimitNumericGeneric Edit92 Allow NULL? 
91ADRTABRollover TableStringGeneric Edit50 Allow NULL? 
92ADTARATax Area (Work)StringGeneric Edit100 Allow NULL? 
93ADHMCOCompany - HomeStringGeneric Edit50 Allow NULL? 
94ADPGM1Pgm Call 1StringGeneric Edit100 Allow NULL? 
95ADPGM2Pgm Call 2StringGeneric Edit100 Allow NULL? 
96ADTDBACode - Tax Area DeductionCharacterUDC (05 YN)10 Allow NULL? 
97ADCMHUCalendar Month MethodCharacterUDC (52 YN)10 Allow NULL? 
98ADBDTBased FromStringUDC (06 DT)40 Allow NULL? 
99ADDBASCalc Once Per PeriodCharacterUDC (05 YN)10 Allow NULL? 
100ADUDBAInclude in Union Plan (Y N)CharacterUDC (05 YN)10 Allow NULL? 
101ADAIGRInvestment Group CodesCharacterUDC (06 AI)10 Allow NULL? 
102ADPR06Report Codes - P/R Transaction 06StringUDC (06 T6)30 Allow NULL? 
103ADPR07Report Codes - P/R Transaction 07StringUDC (06 T7)30 Allow NULL? 
104ADPR08Report Codes - P/R Transaction 08StringUDC (06 T8)30 Allow NULL? 
105ADPR09Report Codes - P/R Transaction 09StringUDC (06 T9)30 Allow NULL? 
106ADPR10Report Codes - P/R Transaction 10StringUDC (06 T0)30 Allow NULL? 
107ADPR11Report Codes - P/R Transaction 11StringUDC (06 11)30 Allow NULL? 
108ADPR12Report Codes - P/R Transaction 12StringUDC (06 12)30 Allow NULL? 
109ADPR13Report Codes - P/R Transaction 13StringUDC (06 13)30 Allow NULL? 
110ADPR14Report Codes - P/R Transaction 14StringUDC (06 14)30 Allow NULL? 
111ADUSERUser IDStringGeneric Edit100 Allow NULL? 
112ADPR15Report Codes - P/R Transaction 15StringUDC (06 15)30 Allow NULL? 
113ADPIDProgram IDStringGeneric Edit100 Allow NULL? 
114ADPR16Report Codes - P/R Transaction 16StringUDC (06 16)30 Allow NULL? 
115ADUPMJDate - UpdatedDateGeneric Edit60
116ADPR17Report Codes - P/R Transaction 17StringUDC (06 17)30 Allow NULL? 
117ADPR18Report Codes - P/R Transaction 18StringUDC (06 18)30 Allow NULL? 
118ADPR19Report Codes - P/R Transaction 19StringUDC (06 19)30 Allow NULL? 
119ADPR20Report Codes - P/R Transaction 20StringUDC (06 20)30 Allow NULL? 
120ADODBAOptional DBA Processing FlagCharacterUDC (05 YN)10 Allow NULL? 
121ADSACCSpending Account TypeStringUDC (06 FS)30 Allow NULL? 
122ADCALCCalculate If No Gross (Y N)CharacterUDC (05 YN)10 Allow NULL? 
123ADPPRYCalc in Pre-Payroll (Y N)CharacterUDC (05 YN)10 Allow NULL? 
124ADGVCHA/P Voucher (Y N)CharacterUDC (05 YB)10 Allow NULL? 
125ADPRTXPre-Tax DeductionStringUDC (06 4K)30 Allow NULL? 
126ADF415415 Testing CodeStringUDC (06 F4)30 Allow NULL? 
127ADCLCICalculate During Interim ProcessingCharacterUDC (05 YN)10 Allow NULL? 
128ADRYTPType of Rollover YearCharacterGeneric Edit10 Allow NULL? 
129ADAFDTAnniversary Fiscal Beginning DateStringUDC (06 AF)40 Allow NULL? 
130ADSHDLW2 Special Handling DescriptionStringGeneric Edit40 Allow NULL? 
131ADCHCKEffect on CheckCharacterUDC (05A CK)10 Allow NULL? 
132ADLVPTLeave Pay TypeCharacterGeneric Edit10 Allow NULL? 
133ADPHISHRetrieve PDBA History Single FlagCharacterUDC (07 M3)10 Allow NULL? 

TOP920 | 08AD | F051375 INDEXES

NumberDescription
1Pay Type Ded. Ben. Accrual (Primary/Unique)
ElementAliasDescriptionSequence
1PAYBNPayroll Batch NumberAscending
2PDBADBA CodeAscending
3EFTBDate - Beginning EffectiveAscending
4EFTEDate - Ending EffectiveAscending
2PayrollBatchNo Desc
ElementAliasDescriptionSequence
1PAYBNPayroll Batch NumberDescending