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

37 COLUMNS | 1 INDEXES | Print definition?920 | 75I | F75I331 TABLE

75I: India
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F75I331AI371Customer Master Tagfile - IND - 03BFiles75I: India
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 AIAN8, AICO, AII75AC01, AII75AC02, AII75AC03, AII75AC04, AII75AC05, AII75AC06, AII75AC07, AII75AC08, AII75AC09, AII75AC10, AII75AC11, AII75AC12, AII75AC13, AII75AC14, AII75AC15, AII75AC16, AII75AC17, AII75AC18, AII75AC19, AII75AC20, AII75AC21, AII75AC22, AII75AC23, AII75AC24, AII75AC25, AII75AC26, AII75AC27, AII75AC28, AII75AC29, AII75AC30, AIUSER, AIPID, AIJOBN, AIUPMJ, AIUPMT FROM F75I331

TOP920 | 75I | F75I331 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1AIAN8Address NumberNumericGeneric Edit80 Allow NULL? 
2AICOCompanyStringGeneric Edit50 Allow NULL? 
3AII75AC01Customer Loc Category Code 01StringUDC (01 01)30 Allow NULL? 
4AII75AC02Customer Loc Category Code 02StringUDC (01 02)30 Allow NULL? 
5AII75AC03Customer Loc Category Code 03StringUDC (01 03)30 Allow NULL? 
6AII75AC04Customer Loc Category Code 04StringUDC (01 04)30 Allow NULL? 
7AII75AC05Customer Loc Category Code 05StringUDC (01 05)30 Allow NULL? 
8AII75AC06Customer Loc Category Code 06StringUDC (01 06)30 Allow NULL? 
9AII75AC07Customer Loc Category Code 07StringUDC (01 07)30 Allow NULL? 
10AII75AC08Customer Loc Category Code 08StringUDC (01 08)30 Allow NULL? 
11AII75AC09Customer Loc Category Code 09StringUDC (01 09)30 Allow NULL? 
12AII75AC10Customer Loc Category Code 10StringUDC (01 10)30 Allow NULL? 
13AII75AC11Customer Loc Category Code 11StringUDC (01 11)30 Allow NULL? 
14AII75AC12Customer Loc Category Code 12StringUDC (01 12)30 Allow NULL? 
15AII75AC13Customer Loc Category Code 13StringUDC (01 13)30 Allow NULL? 
16AII75AC14Customer Loc Category Code 14StringUDC (01 14)30 Allow NULL? 
17AII75AC15Customer Loc Category Code 15StringUDC (01 15)30 Allow NULL? 
18AII75AC16Customer Loc Category Code 16StringUDC (01 16)30 Allow NULL? 
19AII75AC17Customer Loc Category Code 17StringUDC (01 17)30 Allow NULL? 
20AII75AC18Customer Loc Category Code 18StringUDC (01 18)30 Allow NULL? 
21AII75AC19Customer Loc Category Code 19StringUDC (01 19)30 Allow NULL? 
22AII75AC20Customer Loc Category Code 20StringUDC (01 20)30 Allow NULL? 
23AII75AC21Customer Loc Category Code 21StringUDC (01 21)30 Allow NULL? 
24AII75AC22Customer Loc Category Code 22StringUDC (01 22)30 Allow NULL? 
25AII75AC23Customer Loc Category Code 23StringUDC (01 23)30 Allow NULL? 
26AII75AC24Customer Loc Category Code 24StringUDC (01 24)30 Allow NULL? 
27AII75AC25Customer Loc Category Code 25StringUDC (01 25)30 Allow NULL? 
28AII75AC26Customer Loc Category Code 26StringUDC (01 26)30 Allow NULL? 
29AII75AC27Customer Loc Category Code 27StringUDC (01 27)30 Allow NULL? 
30AII75AC28Customer Loc Category Code 28StringUDC (01 28)30 Allow NULL? 
31AII75AC29Customer Loc Category Code 29StringUDC (01 29)30 Allow NULL? 
32AII75AC30Customer Loc Category Code 30StringUDC (01 30)30 Allow NULL? 
33AIUSERUser IDStringGeneric Edit100 Allow NULL? 
34AIPIDProgram IDStringGeneric Edit100 Allow NULL? 
35AIJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
36AIUPMJDate - UpdatedDateGeneric Edit60
37AIUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP920 | 75I | F75I331 INDEXES

NumberDescription
1AN8 CO (Primary/Unique)
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2COCompanyAscending