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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

40 COLUMNS | 1 INDEXES | Print definition?920 | 75C | F75C011 TABLE

75C: China
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F75C011UV401Account - Subsidiary Cross Reference - China - 75CFiles75C: 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 UVAID, UVC75SUB1, UVC75SUB2, UVC75SUB3, UVC75SUB4, UVC75SUB5, UVC75SUB6, UVC75SUB7, UVC75SUB8, UVC75SUB9, UVC75SUB10, UVC75SUB11, UVC75SUB12, UVC75SUB13, UVC75SUB14, UVC75SUB15, UVC75SUB16, UVC75SUB17, UVC75SUB18, UVC75SUB19, UVC75SUB20, UVC75SUB21, UVC75SUB22, UVC75SUB23, UVC75SUB24, UVC75SUB25, UVC75SUB26, UVC75SUB27, UVC75SUB28, UVC75SUB29, UVC75SUB30, UVUSER, UVPID, UVUPMJ, UVUPMT, UVJOBN, UVFUTMATH1, UVFUTSTR2, UVFUTDATE1, UVFUTUO1 FROM F75C011

TOP920 | 75C | F75C011 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1UVAIDAccount IDStringGeneric Edit80 Allow NULL? 
2UVC75SUB1Subsidiary Item ID 1StringGeneric Edit600 Allow NULL? 
3UVC75SUB2Subsidiary Item ID 2StringGeneric Edit600 Allow NULL? 
4UVC75SUB3Subsidiary Item ID 3StringGeneric Edit600 Allow NULL? 
5UVC75SUB4Subsidiary Item ID 4StringGeneric Edit600 Allow NULL? 
6UVC75SUB5Subsidiary Item ID 5StringGeneric Edit600 Allow NULL? 
7UVC75SUB6Subsidiary Item ID 6StringGeneric Edit600 Allow NULL? 
8UVC75SUB7Subsidiary Item ID 7StringGeneric Edit600 Allow NULL? 
9UVC75SUB8Subsidiary Item ID 8StringGeneric Edit600 Allow NULL? 
10UVC75SUB9Subsidiary Item ID 9StringGeneric Edit600 Allow NULL? 
11UVC75SUB10Subsidiary Item ID 10StringGeneric Edit600 Allow NULL? 
12UVC75SUB11Subsidiary Item ID 11StringGeneric Edit600 Allow NULL? 
13UVC75SUB12Subsidiary Item ID 12StringGeneric Edit600 Allow NULL? 
14UVC75SUB13Subsidiary Item ID 13StringGeneric Edit600 Allow NULL? 
15UVC75SUB14Subsidiary Item ID 14StringGeneric Edit600 Allow NULL? 
16UVC75SUB15Subsidiary Item ID 15StringGeneric Edit600 Allow NULL? 
17UVC75SUB16Subsidiary Item ID 16StringGeneric Edit600 Allow NULL? 
18UVC75SUB17Subsidiary Item ID 17StringGeneric Edit600 Allow NULL? 
19UVC75SUB18Subsidiary Item ID 18StringGeneric Edit600 Allow NULL? 
20UVC75SUB19Subsidiary Item ID 19StringGeneric Edit600 Allow NULL? 
21UVC75SUB20Subsidiary Item ID 20StringGeneric Edit600 Allow NULL? 
22UVC75SUB21Subsidiary Item ID 21StringGeneric Edit600 Allow NULL? 
23UVC75SUB22Subsidiary Item ID 22StringGeneric Edit600 Allow NULL? 
24UVC75SUB23Subsidiary Item ID 23StringGeneric Edit600 Allow NULL? 
25UVC75SUB24Subsidiary Item ID 24StringGeneric Edit600 Allow NULL? 
26UVC75SUB25Subsidiary Item ID 25StringGeneric Edit600 Allow NULL? 
27UVC75SUB26Subsidiary Item ID 26StringGeneric Edit600 Allow NULL? 
28UVC75SUB27Subsidiary Item ID 27StringGeneric Edit600 Allow NULL? 
29UVC75SUB28Subsidiary Item ID 28StringGeneric Edit600 Allow NULL? 
30UVC75SUB29Subsidiary Item ID 29StringGeneric Edit600 Allow NULL? 
31UVC75SUB30Subsidiary Item ID 30StringGeneric Edit600 Allow NULL? 
32UVUSERUser IDStringGeneric Edit100 Allow NULL? 
33UVPIDProgram IDStringGeneric Edit100 Allow NULL? 
34UVUPMJDate - UpdatedDateGeneric Edit60
35UVUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
36UVJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
37UVFUTMATH1Future Use Math 1NumericGeneric Edit154 Allow NULL? 
38UVFUTSTR2Future Use String 2StringGeneric Edit500 Allow NULL? 
39UVFUTDATE1Future Use Translation Date 1DateGeneric Edit60
40UVFUTUO1Future Use Field 1CharacterGeneric Edit10 Allow NULL? 

TOP920 | 75C | F75C011 INDEXES

NumberDescription
1Account ID (Primary/Unique)
ElementAliasDescriptionSequence
1AIDAccount IDAscending