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

43 COLUMNS | 1 INDEXES | Print definition?920 | 75C | F75C912 TABLE

75C: China
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F75C912TS431Transaction-wise Subsidiary Info - China - 09Files75C: China
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 TSKCO, TSDCT, TSDOC, TSDGJ, TSLT, TSJELN, TSEXTL, TSC75TRTP, TSC75SUB1, TSC75SUB2, TSC75SUB3, TSC75SUB4, TSC75SUB5, TSC75SUB6, TSC75SUB7, TSC75SUB8, TSC75SUB9, TSC75SUB10, TSC75SUB11, TSC75SUB12, TSC75SUB13, TSC75SUB14, TSC75SUB15, TSC75SUB16, TSC75SUB17, TSC75SUB18, TSC75SUB19, TSC75SUB20, TSC75SUB21, TSC75SUB22, TSC75SUB23, TSC75SUB24, TSC75SUB25, TSC75SUB26, TSC75SUB27, TSC75SUB28, TSC75SUB29, TSC75SUB30, TSPID, TSUSER, TSJOBN, TSUPMJ, TSUPMT FROM F75C912

TOP920 | 75C | F75C912 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1TSKCODocument CompanyStringGeneric Edit50 Allow NULL? 
2TSDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
3TSDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
4TSDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
5TSLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
6TSJELNJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
7TSEXTLLine Extension CodeStringGeneric Edit20 Allow NULL? 
8TSC75TRTPTransaction TypeCharacterGeneric Edit10 Allow NULL? 
9TSC75SUB1Subsidiary Item ID 1StringGeneric Edit600 Allow NULL? 
10TSC75SUB2Subsidiary Item ID 2StringGeneric Edit600 Allow NULL? 
11TSC75SUB3Subsidiary Item ID 3StringGeneric Edit600 Allow NULL? 
12TSC75SUB4Subsidiary Item ID 4StringGeneric Edit600 Allow NULL? 
13TSC75SUB5Subsidiary Item ID 5StringGeneric Edit600 Allow NULL? 
14TSC75SUB6Subsidiary Item ID 6StringGeneric Edit600 Allow NULL? 
15TSC75SUB7Subsidiary Item ID 7StringGeneric Edit600 Allow NULL? 
16TSC75SUB8Subsidiary Item ID 8StringGeneric Edit600 Allow NULL? 
17TSC75SUB9Subsidiary Item ID 9StringGeneric Edit600 Allow NULL? 
18TSC75SUB10Subsidiary Item ID 10StringGeneric Edit600 Allow NULL? 
19TSC75SUB11Subsidiary Item ID 11StringGeneric Edit600 Allow NULL? 
20TSC75SUB12Subsidiary Item ID 12StringGeneric Edit600 Allow NULL? 
21TSC75SUB13Subsidiary Item ID 13StringGeneric Edit600 Allow NULL? 
22TSC75SUB14Subsidiary Item ID 14StringGeneric Edit600 Allow NULL? 
23TSC75SUB15Subsidiary Item ID 15StringGeneric Edit600 Allow NULL? 
24TSC75SUB16Subsidiary Item ID 16StringGeneric Edit600 Allow NULL? 
25TSC75SUB17Subsidiary Item ID 17StringGeneric Edit600 Allow NULL? 
26TSC75SUB18Subsidiary Item ID 18StringGeneric Edit600 Allow NULL? 
27TSC75SUB19Subsidiary Item ID 19StringGeneric Edit600 Allow NULL? 
28TSC75SUB20Subsidiary Item ID 20StringGeneric Edit600 Allow NULL? 
29TSC75SUB21Subsidiary Item ID 21StringGeneric Edit600 Allow NULL? 
30TSC75SUB22Subsidiary Item ID 22StringGeneric Edit600 Allow NULL? 
31TSC75SUB23Subsidiary Item ID 23StringGeneric Edit600 Allow NULL? 
32TSC75SUB24Subsidiary Item ID 24StringGeneric Edit600 Allow NULL? 
33TSC75SUB25Subsidiary Item ID 25StringGeneric Edit600 Allow NULL? 
34TSC75SUB26Subsidiary Item ID 26StringGeneric Edit600 Allow NULL? 
35TSC75SUB27Subsidiary Item ID 27StringGeneric Edit600 Allow NULL? 
36TSC75SUB28Subsidiary Item ID 28StringGeneric Edit600 Allow NULL? 
37TSC75SUB29Subsidiary Item ID 29StringGeneric Edit600 Allow NULL? 
38TSC75SUB30Subsidiary Item ID 30StringGeneric Edit600 Allow NULL? 
39TSPIDProgram IDStringGeneric Edit100 Allow NULL? 
40TSUSERUser IDStringGeneric Edit100 Allow NULL? 
41TSJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
42TSUPMJDate - UpdatedDateGeneric Edit60
43TSUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP920 | 75C | F75C912 INDEXES

NumberDescription
1Doc Type Doc Number (Primary/Unique)
ElementAliasDescriptionSequence
1DCTDocument TypeAscending
2DOCDocument (Voucher Invoice etc.)Ascending
3KCODocument CompanyAscending
4DGJDate - For G/L (and Voucher) - JulianAscending
5JELNJournal Entry Line NumberAscending
6LTLedger TypesAscending
7EXTLLine Extension CodeAscending