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
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger 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
08AD: ADP Integration
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F051371AD1281ADP Employee DBA InstructionsTransaction 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, ADAN8, ADEST, ADMCU3, ADPFRQ, ADEXR, ADPDBA, ADDISO, ADPGRP, ADPSDT, ADPTDT, ADSFLG, ADDTAB, ADPB, ADDESQ, ADSHFT, ADAM, ADMCU, ADOBJ, ADSUB, ADSBL, ADTARA, ADWCMP, ADLMTH, ADLF, ADPHRW, ADPCUN, ADUM, ADPHRT, ADPPRT, ADBHRT, ADPBRT, ADBDRT, ADB2RT, ADRBOB, ADRBO2, ADRTAM, ADPAYM, ADSHD, ADCMTH, ADGPA, ADPPDL, ADMDL, ADADL, ADPPPL, ADNP, ADAD, ADAI, ADLD, ADSEC$, ADANN8, ADDEP1, ADDEP2, ADDEP3, ADDEP4, ADDEP5, ADDEP6, ADP001, ADP002, ADP003, ADP004, ADJBCD, ADJBST, ADHMIN, ADHMAX, ADWET, ADEQCG, ADEQHR, ADERC, ADQOBJ, ADEQRT, ADPDED, ADDGRP, ADDPRI, ADARRR, ADQDL, ADDW, ADPRTR, ADSBLT, ADAAF, ADDAAF, ADUDBA, ADACEQ, ADALHR, ADUN, ADAMTS, ADSADL, ADWR01, ADCOVA, ADZOVR, ADCMAX, ADUAMT, ADAR1Y, ADARSY, ADRTAB, ADCTAB, ADRCCD, ADPCNO, ADODBA, ADGVCH, ADPLAN, ADAOPT, ADUSER, ADPID, ADUPMJ, ADPOS, ADHMCU, ADADP06, ADADP07, ADADP08, ADADP09, ADADP10, ADADP16, ADADP17, ADADP18, ADADP19, ADADP20, ADADP26, ADADP27, ADADP28, ADADP29, ADADP30, ADADP36, ADADP37, ADADP38, ADADP39, ADADP40 FROM F051371

TOP920 | 08AD | F051371 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ADCHGFChange FlagCharacterGeneric Edit10 Allow NULL? 
2ADPAYBNPayroll Batch NumberNumericGeneric Edit80 Allow NULL? 
3ADAN8Address NumberNumericGeneric Edit80 Allow NULL? 
4ADESTEmployment StatusCharacterUDC (06 ES)10 Allow NULL? 
5ADMCU3Business UnitStringGeneric Edit120 Allow NULL? 
6ADPFRQPay FrequencyCharacterUDC (06 PF)10 Allow NULL? 
7ADEXRName - Remark ExplanationStringGeneric Edit300 Allow NULL? 
8ADPDBADBA CodeNumericGeneric Edit50 Allow NULL? 
9ADDISODBA TypeCharacterUDC (05 DI)10 Allow NULL? 
10ADPGRPDeduct/Benefit Override CodeStringGeneric Edit20 Allow NULL? 
11ADPSDTDate - Pay StartsDateGeneric Edit60
12ADPTDTDate - Pay StopsDateGeneric Edit60
13ADSFLGVoid Flag (Y/N)CharacterGeneric Edit10 Allow NULL? 
14ADDTABTable CodeStringGeneric Edit50 Allow NULL? 
15ADPBSource of PayCharacterUDC (06 PB)10 Allow NULL? 
16ADDESQSource of CalculationCharacterUDC (06 DB)10 Allow NULL? 
17ADSHFTShift CodeCharacterUDC (06 SH)10 Allow NULL? 
18ADAMAccount Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
19ADMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
20ADOBJObject AccountStringGeneric Edit60 Allow NULL? 
21ADSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
22ADSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
23ADTARATax Area (Work)StringGeneric Edit100 Allow NULL? 
24ADWCMPWorker's Comp. Insurance CodeStringUDC (00 W)40 Allow NULL? 
25ADLMTHLabor Distribution MethodCharacterUDC (07 LT)10 Allow NULL? 
26ADLFLabor Distribution MultiplierNumericGeneric Edit54 Allow NULL? 
27ADPHRWHours WorkedNumericGeneric Edit92 Allow NULL? 
28ADPCUNUnits - PiecesNumericGeneric Edit92 Allow NULL? 
29ADUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
30ADPHRTRate - HourlyNumericGeneric Edit93 Allow NULL? 
31ADPPRTRate - PieceworkNumericGeneric Edit93 Allow NULL? 
32ADBHRTRate - Base HourlyNumericGeneric Edit93 Allow NULL? 
33ADPBRTRate - Distribution (or Billing)NumericGeneric Edit93 Allow NULL? 
34ADBDRTRate - Recharge BurdenNumericGeneric Edit93 Allow NULL? 
35ADB2RTRate - BurdenNumericGeneric Edit93 Allow NULL? 
36ADRBOBBurden Obj. Account - RechargeStringGeneric Edit60 Allow NULL? 
37ADRBO2Burden Obj. Account - Recharge 2StringGeneric Edit60 Allow NULL? 
38ADRTAMAmount or RateNumericGeneric Edit94 Allow NULL? 
39ADPAYMMultiplier - Pay Type MultiplierNumericGeneric Edit52 Allow NULL? 
40ADSHDAmount - Shift DifferentialNumericGeneric Edit93 Allow NULL? 
41ADCMTHShift Diff Calc SequenceCharacterUDC (07 CO)10 Allow NULL? 
42ADGPAAmount - Gross PayNumericGeneric Edit92 Allow NULL? 
43ADPPDLPay Period LimitNumericGeneric Edit152 Allow NULL? 
44ADMDLMonthly LimitNumericGeneric Edit152 Allow NULL? 
45ADADLAnnual LimitNumericGeneric Edit152 Allow NULL? 
46ADPPPLLimit on Pay Period PercentNumericGeneric Edit154 Allow NULL? 
47ADNPNumber of Deduction PeriodsNumericGeneric Edit40 Allow NULL? 
48ADADAmount - DueNumericGeneric Edit152 Allow NULL? 
49ADAIType - SalesCharacterUDC10 Allow NULL? 
50ADLDPercent or AmountCharacterUDC (07 LD)10 Allow NULL? 
51ADSEC$Security IndicatorCharacterGeneric Edit10 Allow NULL? 
52ADANN8Address Number-Provider/TrusteeNumericGeneric Edit80 Allow NULL? 
53ADDEP1Deduction Period 1CharacterUDC (05A DD)10 Allow NULL? 
54ADDEP2Deduction Period 2CharacterUDC (05A DD)10 Allow NULL? 
55ADDEP3Deduction Period 3CharacterUDC (05A DD)10 Allow NULL? 
56ADDEP4Deduction Period 4CharacterUDC (05A DD)10 Allow NULL? 
57ADDEP5Deduction Period 5CharacterUDC (05A DD)10 Allow NULL? 
58ADDEP6Deduction Period 6CharacterUDC (05A DD)10 Allow NULL? 
59ADP001Category Codes - Payroll1StringUDC (06 01)30 Allow NULL? 
60ADP002Category Codes - Payroll2StringUDC (06 02)30 Allow NULL? 
61ADP003Category Codes - Payroll3StringUDC (06 03)30 Allow NULL? 
62ADP004Category Codes - Payroll4StringUDC (06 04)30 Allow NULL? 
63ADJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
64ADJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
65ADHMINHours - MinimumNumericGeneric Edit152 Allow NULL? 
66ADHMAXHours - MaximumNumericGeneric Edit152 Allow NULL? 
67ADWETSub Class - Workers CompCharacterUDC (07 WH)10 Allow NULL? 
68ADEQCGEquipment WorkedStringGeneric Edit90 Allow NULL? 
69ADEQHRHours - EquipmentNumericGeneric Edit92 Allow NULL? 
70ADERCEquipment Rate CodeStringUDC (00 RC)20 Allow NULL? 
71ADQOBJEquipment Object AccountStringGeneric Edit60 Allow NULL? 
72ADEQRTBilling Rate - EquipmentNumericGeneric Edit92 Allow NULL? 
73ADPDEDDBA For Prior LimitNumericGeneric Edit50 Allow NULL? 
74ADDGRPGroup Limit CodeStringUDC (06 GR)20 Allow NULL? 
75ADDPRIOrder To Adjust DedNumericGeneric Edit50 Allow NULL? 
76ADARRRArrearage MethodCharacterUDC (05A AR)10 Allow NULL? 
77ADQDLQuarterly LimitNumericGeneric Edit152 Allow NULL? 
78ADDWDay of the WeekCharacterUDC (06 DW)10 Allow NULL? 
79ADPRTRTransaction No. - PayrollNumericGeneric Edit90 Allow NULL? 
80ADSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
81ADAAFVacation FactorCharacterUDC (07 AA)10 Allow NULL? 
82ADDAAFDeduction FactorCharacterUDC10 Allow NULL? 
83ADUDBAInclude in Union Plan (Y N)CharacterUDC (05 YN)10 Allow NULL? 
84ADACEQAccrual EquivalentNumericGeneric Edit50 Allow NULL? 
85ADALHRHours Worked - Annual LeaveNumericGeneric Edit72 Allow NULL? 
86ADUNUnion CodeStringUDC (06 UN)60 Allow NULL? 
87ADAMTSAmount or Rate - SecondaryNumericGeneric Edit154 Allow NULL? 
88ADSADLAnnual Limit (Level 2)NumericGeneric Edit152 Allow NULL? 
89ADWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
90ADCOVAAmount - CoverageNumericGeneric Edit152 Allow NULL? 
91ADZOVROverride FlagCharacterUDC (05 YB)10 Allow NULL? 
92ADCMAXInception to Date LimitNumericGeneric Edit92 Allow NULL? 
93ADUAMTAmount - UprateNumericGeneric Edit93 Allow NULL? 
94ADAR1YAccrual Rollover - First YearCharacterUDC (07 AU)10 Allow NULL? 
95ADARSYAccrual Rollover - Subsequent YearsCharacterUDC10 Allow NULL? 
96ADRTABRollover TableStringGeneric Edit50 Allow NULL? 
97ADCTABRollover Table -Subsequent YearStringGeneric Edit50 Allow NULL? 
98ADRCCDRecord TypeCharacterUDC (07 RC)10 Allow NULL? 
99ADPCNOPayroll Control NumberNumericGeneric Edit80 Allow NULL? 
100ADODBAOptional DBA Processing FlagCharacterUDC (05 YN)10 Allow NULL? 
101ADGVCHA/P Voucher (Y N)CharacterUDC (05 YB)10 Allow NULL? 
102ADPLANPlan IDStringGeneric Edit80 Allow NULL? 
103ADAOPTPlan Additional OptionStringGeneric Edit30 Allow NULL? 
104ADUSERUser IDStringGeneric Edit100 Allow NULL? 
105ADPIDProgram IDStringGeneric Edit100 Allow NULL? 
106ADUPMJDate - UpdatedDateGeneric Edit60
107ADPOSPosition IDStringGeneric Edit80 Allow NULL? 
108ADHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
109ADADP06ADP User Defined Cat Code - 06CharacterUDC (05 J1)10 Allow NULL? 
110ADADP07ADP User Defined Cat Code - 07CharacterUDC (05 J2)10 Allow NULL? 
111ADADP08ADP User Defined Cat Code - 08CharacterUDC (05 J3)10 Allow NULL? 
112ADADP09ADP User Defined Cat Code - 09CharacterUDC (05 J4)10 Allow NULL? 
113ADADP10ADP User Defined Cat Code - 10CharacterUDC (05 J5)10 Allow NULL? 
114ADADP16ADP User Defined Date - 06DateGeneric Edit60
115ADADP17ADP User Defined Date - 07DateGeneric Edit60
116ADADP18ADP User Defined Date - 08DateGeneric Edit60
117ADADP19ADP User Defined Date - 09DateGeneric Edit60
118ADADP20ADP User Defined Date - 10DateGeneric Edit60
119ADADP26ADP User Defined Data - 06StringGeneric Edit200 Allow NULL? 
120ADADP27ADP User Defined Data - 07StringGeneric Edit200 Allow NULL? 
121ADADP28ADP User Defined Data - 08StringGeneric Edit200 Allow NULL? 
122ADADP29ADP User Defined Data - 09StringGeneric Edit200 Allow NULL? 
123ADADP30ADP User Defined Data - 10StringGeneric Edit200 Allow NULL? 
124ADADP36ADP User Defined Numeric - 06NumericGeneric Edit150 Allow NULL? 
125ADADP37ADP User Defined Numeric - 07NumericGeneric Edit150 Allow NULL? 
126ADADP38ADP User Defined Numeric - 08NumericGeneric Edit150 Allow NULL? 
127ADADP39ADP User Defined Numeric - 09NumericGeneric Edit150 Allow NULL? 
128ADADP40ADP User Defined Numeric - 10NumericGeneric Edit150 Allow NULL? 

TOP920 | 08AD | F051371 INDEXES

NumberDescription
1Primary (Primary/Unique)
ElementAliasDescriptionSequence
1PAYBNPayroll Batch NumberAscending
2AN8Address NumberAscending
3PDBADBA CodeAscending
4PSDTDate - Pay StartsAscending
5PTDTDate - Pay StopsAscending
6PRTRTransaction No. - PayrollAscending