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

94 COLUMNS | 1 INDEXES | Print definition?920 | 08AD | F05137 TABLE

08AD: ADP Integration
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F05137AD941ADP Employee Master InformationTransaction 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, ADNDEP, ADDOB, ADEEOM, ADEST, ADSEX, ADDST, ADPAST, ADHMCU, ADSHFT, ADSSN, ADUN, ADHM02, ADEEOJ, ADFLSA, ADPFRQ, ADPGRD, ADPGRS, ADSAL, ADPHRT, ADSALY, ADIH, ADSTDH, ADSTDD, ADANPA, ADWCMP, ADEIC, ADMSTX, ADTARR, ADSCDC, ADMSTI, ADSUI, ADTARA, ADHMCO, ADNRVW, ADPSDT, ADDSI, ADLADT, ADLSDT, ADDT, ADFICM, ADGNNM, ADSRNM, ADMDNM, ADAR1, ADPH1, ADPHTP, ADAR2, ADPH2, ADPHT2, ADADD1, ADADD2, ADADD3, ADADD4, ADCTY1, ADADDS, ADADDZ, ADEMAL, ADETP, ADMSA, ADTINCL, ADJBCX, ADDATRVW, ADLSRD, ADNSRD, ADRWTYP, ADPRNM, ADAPS, ADUPMJ, ADLVEL, ADAPPST, ADAPPTY, ADADP01, ADADP02, ADADP03, ADADP04, ADADP05, ADADP11, ADADP12, ADADP13, ADADP14, ADADP15, ADADP21, ADADP22, ADADP23, ADADP24, ADADP25, ADADP31, ADADP32, ADADP33, ADADP34, ADADP35 FROM F05137

TOP920 | 08AD | F05137 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ADCHGFChange FlagCharacterGeneric Edit10 Allow NULL? 
2ADPAYBNPayroll Batch NumberNumericGeneric Edit80 Allow NULL? 
3ADAN8Address NumberNumericGeneric Edit80 Allow NULL? 
4ADNDEPDependentsNumericGeneric Edit20 Allow NULL? 
5ADDOBDate - BirthDateGeneric Edit60
6ADEEOMEthnic CodeStringUDC (06 M)20 Allow NULL? 
7ADESTEmployment StatusCharacterUDC (06 ES)10 Allow NULL? 
8ADSEXGender (Male/Female)CharacterUDC (07 SG)10 Allow NULL? 
9ADDSTDate StartedDateGeneric Edit60
10ADPASTEmployee Pay StatusCharacterUDC (06 PS)10 Allow NULL? 
11ADHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
12ADSHFTShift CodeCharacterUDC (06 SH)10 Allow NULL? 
13ADSSNEmployee Tax IDStringGeneric Edit200 Allow NULL? 
14ADUNUnion CodeStringUDC (06 UN)60 Allow NULL? 
15ADHM02EEO - VeteranCharacterUDC (05 HO)10 Allow NULL? 
16ADEEOJJob Category (EEO)StringUDC (06 J)30 Allow NULL? 
17ADFLSAFLSA Exempt Y/NCharacterUDC (05 FL)10 Allow NULL? 
18ADPFRQPay FrequencyCharacterUDC (06 PF)10 Allow NULL? 
19ADPGRDPay GradeStringGeneric Edit60 Allow NULL? 
20ADPGRSPay Grade StepStringGeneric Edit40 Allow NULL? 
21ADSALRate - Salary AnnualNumericGeneric Edit112 Allow NULL? 
22ADPHRTRate - HourlyNumericGeneric Edit93 Allow NULL? 
23ADSALYPay Class (H/S/P)CharacterUDC (05A PK)10 Allow NULL? 
24ADIHHours per Standard YearNumericGeneric Edit72 Allow NULL? 
25ADSTDHHours - Standard per PayperiodNumericGeneric Edit52 Allow NULL? 
26ADSTDDHours - Standard per DayNumericGeneric Edit52 Allow NULL? 
27ADANPASupervisorNumericGeneric Edit80 Allow NULL? 
28ADWCMPWorker's Comp. Insurance CodeStringUDC (00 W)40 Allow NULL? 
29ADEICEarned Income Credit StatusCharacterUDC (05 EI)10 Allow NULL? 
30ADMSTXMarital Status - TaxCharacterUDC (06 MS)10 Allow NULL? 
31ADTARRTax Area (Residence)StringGeneric Edit100 Allow NULL? 
32ADSCDCSchool District CodeNumericUDC (07 SS)50 Allow NULL? 
33ADMSTIMarital Status - State TaxCharacterUDC (06 MS)10 Allow NULL? 
34ADSUISource of SUI ReportingCharacterUDC (05 SR)10 Allow NULL? 
35ADTARATax Area (Work)StringGeneric Edit100 Allow NULL? 
36ADHMCOCompany - HomeStringGeneric Edit50 Allow NULL? 
37ADNRVWDate - Next ReviewDateGeneric Edit60
38ADPSDTDate - Pay StartsDateGeneric Edit60
39ADDSIDate - Original EmploymentDateGeneric Edit60
40ADLADTDate - LOA Expiration DateDateGeneric Edit60
41ADLSDTDate - LOA Beginning DateDateGeneric Edit60
42ADDTDate - TerminatedDateGeneric Edit60
43ADFICMTax Calc MethodCharacterUDC (06 TM)10 Allow NULL? 
44ADGNNMName - GivenStringGeneric Edit250 Allow NULL? 
45ADSRNMName - SurnameStringGeneric Edit250 Allow NULL? 
46ADMDNMName - MiddleStringGeneric Edit250 Allow NULL? 
47ADAR1Phone PrefixStringGeneric Edit60 Allow NULL? 
48ADPH1Phone NumberStringGeneric Edit200 Allow NULL? 
49ADPHTPPhone Number TypeStringUDC (01 PH)40 Allow NULL? 
50ADAR2Phone Prefix 2StringGeneric Edit60 Allow NULL? 
51ADPH2Phone Number 2StringGeneric Edit200 Allow NULL? 
52ADPHT2Phone Number Type 2StringUDC (01 PH)40 Allow NULL? 
53ADADD1Address Line 1StringGeneric Edit400 Allow NULL? 
54ADADD2Address Line 2StringGeneric Edit400 Allow NULL? 
55ADADD3Address Line 3StringGeneric Edit400 Allow NULL? 
56ADADD4Address Line 4StringGeneric Edit400 Allow NULL? 
57ADCTY1CityStringGeneric Edit250 Allow NULL? 
58ADADDSStateStringUDC (00 S)30 Allow NULL? 
59ADADDZPostal CodeStringGeneric Edit120 Allow NULL? 
60ADEMALElectronic AddressStringGeneric Edit2560 Allow NULL? 
61ADETPElectronic Address TypeStringUDC (01 ET)40 Allow NULL? 
62ADMSAMarital Status - ActualCharacterUDC (07 MS)10 Allow NULL? 
63ADTINCLType of Increase Next ReviewCharacterUDC (06 RV)10 Allow NULL? 
64ADJBCXJob TitleStringGeneric Edit300 Allow NULL? 
65ADDATRVWDate Last ReviewedDateGeneric Edit60
66ADLSRDLast Compensation Review DateDateGeneric Edit60
67ADNSRDNext Compensation Review DateDateGeneric Edit60
68ADRWTYPReview TypeCharacterUDC (05 RY)10 Allow NULL? 
69ADPRNMPreferred NameStringGeneric Edit200 Allow NULL? 
70ADAPSStatus - ApplicantStringUDC (08 AS)20 Allow NULL? 
71ADUPMJDate - UpdatedDateGeneric Edit60
72ADLVELLevel In Relation To EmployeeIntegerGeneric Edit30 Allow NULL? 
73ADAPPSTApproval StatusCharacterGeneric Edit10 Allow NULL? 
74ADAPPTYApproval TypeStringUDC (05 AP)40 Allow NULL? 
75ADADP01ADP User Defined Cat Code - 01CharacterUDC (05 I1)10 Allow NULL? 
76ADADP02ADP User Defined Cat Code - 02CharacterUDC (05 I2)10 Allow NULL? 
77ADADP03ADP User Defined Cat Code - 03CharacterUDC (05 I3)10 Allow NULL? 
78ADADP04ADP User Defined Cat Code - 04CharacterUDC (05 I4)10 Allow NULL? 
79ADADP05ADP User Defined Cat Code - 05CharacterUDC (05 I5)10 Allow NULL? 
80ADADP11ADP User Defined Date - 01DateGeneric Edit60
81ADADP12ADP User Defined Date - 02DateGeneric Edit60
82ADADP13ADP User Defined Date - 03DateGeneric Edit60
83ADADP14ADP User Defined Date - 04DateGeneric Edit60
84ADADP15ADP User Defined Date - 05DateGeneric Edit60
85ADADP21ADP User Defined Data - 01StringGeneric Edit200 Allow NULL? 
86ADADP22ADP User Defined Data - 02StringGeneric Edit200 Allow NULL? 
87ADADP23ADP User Defined Data - 03StringGeneric Edit200 Allow NULL? 
88ADADP24ADP User Defined Data - 04StringGeneric Edit200 Allow NULL? 
89ADADP25ADP User Defined Data - 05StringGeneric Edit200 Allow NULL? 
90ADADP31ADP User Defined Numeric - 01NumericGeneric Edit150 Allow NULL? 
91ADADP32ADP User Defined Numeric - 02NumericGeneric Edit150 Allow NULL? 
92ADADP33ADP User Defined Numeric - 03NumericGeneric Edit150 Allow NULL? 
93ADADP34ADP User Defined Numeric - 04NumericGeneric Edit150 Allow NULL? 
94ADADP35ADP User Defined Numeric - 05NumericGeneric Edit150 Allow NULL? 

TOP920 | 08AD | F05137 INDEXES

NumberDescription
1Primary (Primary/Unique)
ElementAliasDescriptionSequence
1PAYBNPayroll Batch NumberAscending
2AN8Address NumberAscending