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

56 COLUMNS | 1 INDEXES | Print definition?920 | 07 | F8907427 TABLE

07: Payroll
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F8907427MT561New Hire Detail File - Montana (27)Master 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 MTMATH01, MTEV01, MTDTI1, MTMATH02, MTALPH1, MTTAXX, MTETAX, MTADD4, MTADD5, MTMSCY, MTSTCD, MTADDO, MTCRRT, MTDL02, MTFPC2, MTALPH3, MTPH1, MTPXT1, MTPH2, MTEV02, MTADD10, MTADD11, MTCTYNH2, MTADDSNH2, MTADDZNH2, MTCRTENH2, MTDL03, MTFPC4, MTDTI2, MTSSN, MTSRNM, MTGNNM, MTMDNM, MTADD1, MTADD2, MTCTY1, MTADDS, MTADDZ, MTCRTE, MTDL04, MTFPC1, MTADD13, MTADD14, MTCTYNH3, MTADDSNH3, MTADDZNH3, MTCRTENH3, MTDL05, MTFPC5, MTPH3, MTPH4, MTPHO1, MTDTI3, MTSCOD, MTEV03, MTDTI4 FROM F8907427

TOP920 | 07 | F8907427 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1MTMATH01Math Numeric 01NumericGeneric Edit152 Allow NULL? 
2MTEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10 Allow NULL? 
3MTDTI1Data Item 1StringGeneric Edit100 Allow NULL? 
4MTMATH02Math Numeric 02NumericGeneric Edit152 Allow NULL? 
5MTALPH1Name - Alpha Contact 1StringGeneric Edit400 Allow NULL? 
6MTTAXXTax Identification NumberStringGeneric Edit200 Allow NULL? 
7MTETAXTax Identification Number -Business UnitStringGeneric Edit200 Allow NULL? 
8MTADD4Address Line 4StringGeneric Edit400 Allow NULL? 
9MTADD5Address Line 5StringGeneric Edit400 Allow NULL? 
10MTMSCYCityStringGeneric Edit250 Allow NULL? 
11MTSTCDState CodeStringGeneric Edit30 Allow NULL? 
12MTADDOPostal Code - OriginStringGeneric Edit120 Allow NULL? 
13MTCRRTCarrier RouteStringGeneric Edit40 Allow NULL? 
14MTDL02Description 02StringGeneric Edit300 Allow NULL? 
15MTFPC2ForeignPostalCodeStringGeneric Edit150 Allow NULL? 
16MTALPH3Name - AlphaStringGeneric Edit400 Allow NULL? 
17MTPH1Phone NumberStringGeneric Edit200 Allow NULL? 
18MTPXT1Phone ExtensionStringGeneric Edit50 Allow NULL? 
19MTPH2Phone Number 2StringGeneric Edit200 Allow NULL? 
20MTEV02J.D. EnterpriseOne Event Point 02CharacterGeneric Edit10 Allow NULL? 
21MTADD10Address Line 10StringGeneric Edit400 Allow NULL? 
22MTADD11Address Line 11StringGeneric Edit400 Allow NULL? 
23MTCTYNH2CityStringGeneric Edit250 Allow NULL? 
24MTADDSNH2StateStringUDC (00 S)30 Allow NULL? 
25MTADDZNH2Postal CodeStringGeneric Edit120 Allow NULL? 
26MTCRTENH2Carrier Route (Future)StringGeneric Edit40 Allow NULL? 
27MTDL03Description 03StringGeneric Edit300 Allow NULL? 
28MTFPC4ForeignPostalCodeStringGeneric Edit150 Allow NULL? 
29MTDTI2Data Item 2StringGeneric Edit100 Allow NULL? 
30MTSSNEmployee Tax IDStringGeneric Edit200 Allow NULL? 
31MTSRNMName - SurnameStringGeneric Edit250 Allow NULL? 
32MTGNNMName - GivenStringGeneric Edit250 Allow NULL? 
33MTMDNMName - MiddleStringGeneric Edit250 Allow NULL? 
34MTADD1Address Line 1StringGeneric Edit400 Allow NULL? 
35MTADD2Address Line 2StringGeneric Edit400 Allow NULL? 
36MTCTY1CityStringGeneric Edit250 Allow NULL? 
37MTADDSStateStringUDC (00 S)30 Allow NULL? 
38MTADDZPostal CodeStringGeneric Edit120 Allow NULL? 
39MTCRTECarrier Route (Future)StringGeneric Edit40 Allow NULL? 
40MTDL04Description 04StringGeneric Edit300 Allow NULL? 
41MTFPC1ForeignPostalCodeStringGeneric Edit150 Allow NULL? 
42MTADD13Address Line 13StringGeneric Edit400 Allow NULL? 
43MTADD14Address Line 14StringGeneric Edit400 Allow NULL? 
44MTCTYNH3CityStringGeneric Edit250 Allow NULL? 
45MTADDSNH3StateStringUDC (00 S)30 Allow NULL? 
46MTADDZNH3Postal CodeStringGeneric Edit120 Allow NULL? 
47MTCRTENH3Carrier Route (Future)StringGeneric Edit40 Allow NULL? 
48MTDL05Description 05StringGeneric Edit300 Allow NULL? 
49MTFPC5ForeignPostalCodeStringGeneric Edit150 Allow NULL? 
50MTPH3Phone NumberStringGeneric Edit200 Allow NULL? 
51MTPH4Phone NumberStringGeneric Edit200 Allow NULL? 
52MTPHO1Phone ID 1NumericGeneric Edit50 Allow NULL? 
53MTDTI3Data Item 3StringGeneric Edit100 Allow NULL? 
54MTSCODStatutory CodeStringUDC (06 SC)30 Allow NULL? 
55MTEV03J.D. EnterpriseOne Point 03CharacterGeneric Edit10 Allow NULL? 
56MTDTI4Data Item 4StringGeneric Edit100 Allow NULL? 

TOP920 | 07 | F8907427 INDEXES

NumberDescription
1Counter (Primary/Unique)
ElementAliasDescriptionSequence
1MATH01Math Numeric 01Ascending