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

54 COLUMNS | 1 INDEXES | Print definition?920 | 40 | F40039 TABLE

40: Inventory/OP Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F40039DT541Document Type MasterSecondary Master Files41: Inventory ManagementBusiness 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 DTDCT, DTTNTP, DTIRPT, DTLTTC, DTILTT, DTNATN, DTCTPA, DTOCAT, DTOTQY, DTRELV, DTIBOR, DTSY, DTORNN, DTCSCT, DTCSOT, DTCSKT, DTCRTK, DTA101, DTA102, DTA103, DTA104, DTA105, DTA106, DTA107, DTA108, DTA109, DTA110, DTA111, DTA112, DTA113, DTA114, DTA115, DTA116, DTA117, DTA118, DTA119, DTA120, DTA201, DTA202, DTA203, DTA204, DTA205, DTA301, DTA302, DTA303, DTA304, DTA305, DTUSER, DTPID, DTJOBN, DTUPMJ, DTTDAY, DTDTSQ, DTCSNOT FROM F40039

TOP920 | 40 | F40039 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1DTDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
2DTTNTPTransaction TypeCharacterGeneric Edit10 Allow NULL? 
3DTIRPTInclude In Integrity ReportCharacterGeneric Edit10 Allow NULL? 
4DTLTTCConsolidate Lot Trace TrackCharacterGeneric Edit10 Allow NULL? 
5DTILTTDisplay Lot Trace TrackCharacterGeneric Edit10 Allow NULL? 
6DTNATNNatureOfTransactionCharacterGeneric Edit10 Allow NULL? 
7DTCTPACommit Procurement OrdersCharacterGeneric Edit10 Allow NULL? 
8DTOCATCategory of OrderStringGeneric Edit20 Allow NULL? 
9DTOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
10DTRELVRelieveOnHandCharacterGeneric Edit10 Allow NULL? 
11DTIBORInterbranchOrderStringGeneric Edit20 Allow NULL? 
12DTSYProduct CodeStringUDC (98 SY)40 Allow NULL? 
13DTORNNOrder Type Next NumberNumericGeneric Edit20 Allow NULL? 
14DTCSCTService/Warranty Case TypeCharacterGeneric Edit10 Allow NULL? 
15DTCSOTService Order TypeCharacterGeneric Edit10 Allow NULL? 
16DTCSKTService/Warranty Contract TypeCharacterGeneric Edit10 Allow NULL? 
17DTCRTKCreate S/WM ContractCharacterGeneric Edit10 Allow NULL? 
18DTA101Engineering Project Management TypeCharacterGeneric Edit10 Allow NULL? 
19DTA102Create Fixed AssetCharacterGeneric Edit10 Allow NULL? 
20DTA103Commit Manufacturing DocumentCharacterGeneric Edit (00 OO)10 Allow NULL? 
21DTA104Equipment Maintenance DocumentCharacterGeneric Edit (00 OO)10 Allow NULL? 
22DTA105Ship and Debit Y/NCharacterGeneric Edit10 Allow NULL? 
23DTA106Publish ExternallyCharacterGeneric Edit10 Allow NULL? 
24DTA107Generic Character 7CharacterGeneric Edit10 Allow NULL? 
25DTA108Generic Character 8CharacterGeneric Edit10 Allow NULL? 
26DTA109Recommend CartonsCharacterGeneric Edit10 Allow NULL? 
27DTA110Send Status NotificationCharacterGeneric Edit10 Allow NULL? 
28DTA111Generic Character11CharacterGeneric Edit10 Allow NULL? 
29DTA112Cross Docking SupplyCharacterGeneric Edit10 Allow NULL? 
30DTA113Generic Character13CharacterGeneric Edit10 Allow NULL? 
31DTA114Generic Character14CharacterGeneric Edit10 Allow NULL? 
32DTA115Generic Character15CharacterGeneric Edit10 Allow NULL? 
33DTA116Generic Character16CharacterGeneric Edit10 Allow NULL? 
34DTA117Generic Character17CharacterGeneric Edit10 Allow NULL? 
35DTA118Generic Character18CharacterGeneric Edit10 Allow NULL? 
36DTA119Generic Character19CharacterGeneric Edit10 Allow NULL? 
37DTA120Generic Character20CharacterGeneric Edit10 Allow NULL? 
38DTA201Work Order TypeStringUDC (48 OT)20 Allow NULL? 
39DTA202Generic 2 String 02StringGeneric Edit20 Allow NULL? 
40DTA203Generic 2 String 03StringGeneric Edit20 Allow NULL? 
41DTA204Carton Creation StatusStringUDC (46 RS)20 Allow NULL? 
42DTA205Carton Change StatusStringUDC (46 RS)20 Allow NULL? 
43DTA301Generic String 01StringGeneric Edit30 Allow NULL? 
44DTA302Generic String 02StringGeneric Edit30 Allow NULL? 
45DTA303Generic String 03StringGeneric Edit30 Allow NULL? 
46DTA304Generic String 04StringGeneric Edit30 Allow NULL? 
47DTA305Generic String 05StringGeneric Edit30 Allow NULL? 
48DTUSERUser IDStringGeneric Edit100 Allow NULL? 
49DTPIDProgram IDStringGeneric Edit100 Allow NULL? 
50DTJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
51DTUPMJDate - UpdatedDateGeneric Edit60
52DTTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
53DTDTSQDocument Type Sequencing FlagCharacterGeneric Edit10 Allow NULL? 
54DTCSNOTConsignment Order TypeCharacterGeneric Edit10 Allow NULL? 

TOP920 | 40 | F40039 INDEXES

NumberDescription
2DocType (Primary/Unique)
ElementAliasDescriptionSequence
1DCTDocument TypeAscending