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
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

115 COLUMNS | 1 INDEXES | Print definition?910 | 07 | F074001 TABLE

07: Payroll
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F074001NH1151New Hire Reporting Workfile - OneWorld OnlyWork Files07S: Payroll SUIBusiness 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 NHAN8, NHCO, NHWST, NHTARA, NHNHBD, NHNHED, NHSSN, NHALPH, NHGNNM, NHMDNM, NHSRNM, NHADD1, NHADD2, NHADD3, NHCTY1, NHADDS, NHADDZ, NHCRTE, NHCTR, NHCOUN, NHFPC1, NHDST, NHDT, NHECNT, NHMSTX, NHTAXX, NHCTAX, NHETAX, NHALPH1, NHADD4, NHADD5, NHADD6, NHMSCY, NHSTCD, NHADDO, NHCRRT, NHCTR2, NHCNT2, NHFPC2, NHAR1, NHPH1, NHDL01, NHSAL, NHPFRQ, NHSCOD, NHWKSE, NHHMCO, NHSEX, NHDOB, NHED01, NHEEF, NHED02, NHEEDF, NHADD7, NHADD8, NHADD9, NHCTYNH, NHADDSNH, NHADDZNH, NHCRTENH, NHCTR4, NHCOUNNH, NHFPC3, NHAR2, NHPH2, NHAN80, NHALPH3, NHALPH4, NHADD10, NHADD11, NHADD12, NHCTYNH2, NHADDSNH2, NHADDZNH2, NHCRTENH2, NHCTR5, NHCOUNNH2, NHFPC4, NHAR3, NHPH3, NHJBCD, NHJBST, NHDL02, NHAN8Z, NHALPH5, NHALPH6, NHADD13, NHADD14, NHADD15, NHCTYNH3, NHADDSNH3, NHADDZNH3, NHCRTENH3, NHCTR6, NHCOUNNH3, NHFPC5, NHAR4, NHPH4, NHAR12, NHPHN1, NHTAXX2, NHOTAX, NHCTRY, NHGLBA, NHICU, NHAC01, NHAC02, NHAC03, NHMCU, NHDTE, NHUPMJ, NHUPMT, NHPID, NHJOBN, NHUSER FROM F074001

TOP910 | 07 | F074001 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1NHAN8Address NumberNumericUDC80 Allow NULL? 
2NHCOCompanyStringGeneric Edit50 Allow NULL? 
3NHWSTWork StateNumericGeneric Edit20 Allow NULL? 
4NHTARATax Area (Work)StringGeneric Edit100 Allow NULL? 
5NHNHBDDate - Report BeginsDateGeneric Edit60
6NHNHEDDate - Report EndsDateGeneric Edit60
7NHSSNEmployee Tax IDStringGeneric Edit200 Allow NULL? 
8NHALPHName - AlphaStringGeneric Edit400 Allow NULL? 
9NHGNNMName - GivenStringGeneric Edit250 Allow NULL? 
10NHMDNMName - MiddleStringGeneric Edit250 Allow NULL? 
11NHSRNMName - SurnameStringGeneric Edit250 Allow NULL? 
12NHADD1Address Line 1StringGeneric Edit400 Allow NULL? 
13NHADD2Address Line 2StringGeneric Edit400 Allow NULL? 
14NHADD3Address Line 3StringGeneric Edit400 Allow NULL? 
15NHCTY1CityStringGeneric Edit250 Allow NULL? 
16NHADDSStateStringUDC (00 S)30 Allow NULL? 
17NHADDZPostal CodeStringGeneric Edit120 Allow NULL? 
18NHCRTECarrier Route (Future)StringGeneric Edit40 Allow NULL? 
19NHCTRCountryStringUDC (00 CN)30 Allow NULL? 
20NHCOUNCountyStringUDC (00 CT)250 Allow NULL? 
21NHFPC1ForeignPostalCodeStringGeneric Edit150 Allow NULL? 
22NHDSTDate StartedDateGeneric Edit60
23NHDTDate - TerminatedDateGeneric Edit60
24NHECNTEmployee Classification StatusCharacterUDC (05A EC)10 Allow NULL? 
25NHMSTXMarital Status - TaxCharacterUDC (06 MS)10 Allow NULL? 
26NHTAXXTax Identification NumberStringGeneric Edit200 Allow NULL? 
27NHCTAXTax Identification Number - CountyStringGeneric Edit200 Allow NULL? 
28NHETAXTax Identification Number -Business UnitStringGeneric Edit200 Allow NULL? 
29NHALPH1Name - Alpha Contact 1StringGeneric Edit400 Allow NULL? 
30NHADD4Address Line 4StringGeneric Edit400 Allow NULL? 
31NHADD5Address Line 5StringGeneric Edit400 Allow NULL? 
32NHADD6Address Line 6StringGeneric Edit400 Allow NULL? 
33NHMSCYCityStringGeneric Edit250 Allow NULL? 
34NHSTCDState CodeStringGeneric Edit30 Allow NULL? 
35NHADDOPostal Code - OriginStringGeneric Edit120 Allow NULL? 
36NHCRRTCarrier RouteStringGeneric Edit40 Allow NULL? 
37NHCTR2CountryStringUDC (00 CN)30 Allow NULL? 
38NHCNT2CountyStringGeneric Edit250 Allow NULL? 
39NHFPC2ForeignPostalCodeStringGeneric Edit150 Allow NULL? 
40NHAR1Phone PrefixStringGeneric Edit60 Allow NULL? 
41NHPH1Phone NumberStringGeneric Edit200 Allow NULL? 
42NHDL01DescriptionStringGeneric Edit300 Allow NULL? 
43NHSALRate - Salary AnnualNumericGeneric Edit112 Allow NULL? 
44NHPFRQPay FrequencyCharacterUDC (06 PF)10 Allow NULL? 
45NHSCODStatutory CodeStringUDC (06 SC)30 Allow NULL? 
46NHWKSEState - WorkingStringUDC (06 SC)30 Allow NULL? 
47NHHMCOCompany - HomeStringGeneric Edit50 Allow NULL? 
48NHSEXGender (Male/Female)CharacterUDC (07 SG)10 Allow NULL? 
49NHDOBDate - BirthDateGeneric Edit60
50NHED01Date - User Defined1DateGeneric Edit60
51NHEEFEmployee Eligibility FlagCharacterGeneric Edit10 Allow NULL? 
52NHED02Date - User Defined2DateGeneric Edit60
53NHEEDFDependent Eligibility FlagCharacterGeneric Edit10 Allow NULL? 
54NHADD7Address Line 8StringGeneric Edit400 Allow NULL? 
55NHADD8Address Line 8StringGeneric Edit400 Allow NULL? 
56NHADD9Address Line 8StringGeneric Edit400 Allow NULL? 
57NHCTYNHCityStringGeneric Edit250 Allow NULL? 
58NHADDSNHStateStringUDC (00 S)30 Allow NULL? 
59NHADDZNHPostal CodeStringGeneric Edit120 Allow NULL? 
60NHCRTENHCarrier Route (Future)StringGeneric Edit40 Allow NULL? 
61NHCTR4CountryStringUDC (00 CN)30 Allow NULL? 
62NHCOUNNHCountyStringUDC (00 CT)250 Allow NULL? 
63NHFPC3ForeignPostalCodeStringGeneric Edit150 Allow NULL? 
64NHAR2Phone Prefix 2StringGeneric Edit60 Allow NULL? 
65NHPH2Phone Number 2StringGeneric Edit200 Allow NULL? 
66NHAN80Address NumberNumericGeneric Edit80 Allow NULL? 
67NHALPH3Name - AlphaStringGeneric Edit400 Allow NULL? 
68NHALPH4Name - Alpha EmployerStringGeneric Edit400 Allow NULL? 
69NHADD10Address Line 10StringGeneric Edit400 Allow NULL? 
70NHADD11Address Line 11StringGeneric Edit400 Allow NULL? 
71NHADD12Address Line 12StringGeneric Edit400 Allow NULL? 
72NHCTYNH2CityStringGeneric Edit250 Allow NULL? 
73NHADDSNH2StateStringUDC (00 S)30 Allow NULL? 
74NHADDZNH2Postal CodeStringGeneric Edit120 Allow NULL? 
75NHCRTENH2Carrier Route (Future)StringGeneric Edit40 Allow NULL? 
76NHCTR5CountryStringUDC (00 CN)30 Allow NULL? 
77NHCOUNNH2CountyStringUDC (00 CT)250 Allow NULL? 
78NHFPC4ForeignPostalCodeStringGeneric Edit150 Allow NULL? 
79NHAR3Phone Area Code 3StringGeneric Edit60 Allow NULL? 
80NHPH3Phone NumberStringGeneric Edit200 Allow NULL? 
81NHJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
82NHJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
83NHDL02Description 02StringGeneric Edit300 Allow NULL? 
84NHAN8ZAddress Location KeyNumericGeneric Edit80 Allow NULL? 
85NHALPH5Name - Alpha ContactStringGeneric Edit400 Allow NULL? 
86NHALPH6Name - Alpha ContactStringGeneric Edit400 Allow NULL? 
87NHADD13Address Line 13StringGeneric Edit400 Allow NULL? 
88NHADD14Address Line 14StringGeneric Edit400 Allow NULL? 
89NHADD15Address Line 15StringGeneric Edit400 Allow NULL? 
90NHCTYNH3CityStringGeneric Edit250 Allow NULL? 
91NHADDSNH3StateStringUDC (00 S)30 Allow NULL? 
92NHADDZNH3Postal CodeStringGeneric Edit120 Allow NULL? 
93NHCRTENH3Carrier Route (Future)StringGeneric Edit40 Allow NULL? 
94NHCTR6CountryStringUDC (00 CN)30 Allow NULL? 
95NHCOUNNH3CountyStringUDC (00 CT)250 Allow NULL? 
96NHFPC5ForeignPostalCodeStringGeneric Edit150 Allow NULL? 
97NHAR4Phone Area Code 4StringGeneric Edit60 Allow NULL? 
98NHPH4Phone NumberStringGeneric Edit200 Allow NULL? 
99NHAR12Phone Prefix 2StringGeneric Edit60 Allow NULL? 
100NHPHN1Phone NumberStringGeneric Edit200 Allow NULL? 
101NHTAXX2Tax Identification NumberStringGeneric Edit200 Allow NULL? 
102NHOTAXTax Identification Number - OldStringGeneric Edit200 Allow NULL? 
103NHCTRYCenturyNumericGeneric Edit20 Allow NULL? 
104NHGLBAG/L Bank AccountStringGeneric Edit80 Allow NULL? 
105NHICUBatch NumberNumericGeneric Edit80 Allow NULL? 
106NHAC01Category Code - Address Book 01StringUDC (01 01)30 Allow NULL? 
107NHAC02Category Code - Address Book 02StringUDC (01 02)30 Allow NULL? 
108NHAC03Category Code - Address Book 03StringUDC (01 03)30 Allow NULL? 
109NHMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
110NHDTEDateDateGeneric Edit60
111NHUPMJDate - UpdatedDateGeneric Edit60
112NHUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
113NHPIDProgram IDStringGeneric Edit100 Allow NULL? 
114NHJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
115NHUSERUser IDStringGeneric Edit100 Allow NULL? 

TOP910 | 07 | F074001 INDEXES

NumberDescription
1CO WST AN8 (Primary/Unique)
ElementAliasDescriptionSequence
1COCompanyAscending
2WSTWork StateAscending
3AN8Address NumberAscending