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

47 COLUMNS | 1 INDEXES | Print definition?920 | H95 | F8306 TABLE

H95: Object and Environment Tech
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F8306R6471FASTR - Cell Specifications Master FileFilesH95: Object and Environment TechBusiness 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 R6PID, R6VERS, R6RNBR, R6CNBR, R6DECI, R6RCLC, R6LT, R6CL01, R6MO01, R6CL02, R6MO02, R6CL03, R6MO03, R6CL04, R6MO04, R6CL05, R6MO05, R6CL06, R6MO06, R6CL07, R6MO07, R6CL08, R6MO08, R6CL09, R6MO09, R6CL10, R6MO10, R6CL11, R6MO11, R6CL12, R6MO12, R6CL13, R6MO13, R6CL14, R6MO14, R6CL15, R6MO15, R6CL16, R6MO16, R6CL17, R6MO17, R6CL18, R6MO18, R6CL19, R6MO19, R6CL20, R6MO20 FROM F8306

TOP920 | H95 | F8306 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1R6PIDProgram IDStringGeneric Edit100 Allow NULL? 
2R6VERSVersion HistoryStringGeneric Edit100 Allow NULL? 
3R6RNBRRow NumberStringGeneric Edit40 Allow NULL? 
4R6CNBRColumn NumberStringGeneric Edit20 Allow NULL? 
5R6DECIData Display DecimalsCharacterGeneric Edit10 Allow NULL? 
6R6RCLCRecalculate Cell (Y/N)CharacterGeneric Edit10 Allow NULL? 
7R6LTLedger TypesStringUDC (09 LT)20 Allow NULL? 
8R6CL01Worksheet Cell 01StringGeneric Edit100 Allow NULL? 
9R6MO01Math Operator 01StringUDC10 Allow NULL? 
10R6CL02Worksheet Cell 02StringGeneric Edit100 Allow NULL? 
11R6MO02Math Operator 02StringUDC10 Allow NULL? 
12R6CL03Worksheet Cell 03StringGeneric Edit100 Allow NULL? 
13R6MO03Math Operator 03StringUDC10 Allow NULL? 
14R6CL04Worksheet Cell 04StringGeneric Edit100 Allow NULL? 
15R6MO04Math Operator 04StringUDC10 Allow NULL? 
16R6CL05Worksheet Cell 05StringGeneric Edit100 Allow NULL? 
17R6MO05Math Operator 05StringUDC10 Allow NULL? 
18R6CL06Worksheet Cell 06StringGeneric Edit100 Allow NULL? 
19R6MO06Math Operator 06StringUDC10 Allow NULL? 
20R6CL07Worksheet Cell 07StringGeneric Edit100 Allow NULL? 
21R6MO07Math Operator 07StringUDC10 Allow NULL? 
22R6CL08Worksheet Cell 08StringGeneric Edit100 Allow NULL? 
23R6MO08Math Operator 08StringUDC10 Allow NULL? 
24R6CL09Worksheet Cell 09StringGeneric Edit100 Allow NULL? 
25R6MO09Math Operator 09StringUDC10 Allow NULL? 
26R6CL10Worksheet Cell 10StringGeneric Edit100 Allow NULL? 
27R6MO10Math Operator 10StringUDC10 Allow NULL? 
28R6CL11Worksheet Cell 11StringGeneric Edit100 Allow NULL? 
29R6MO11Math Operator 11StringUDC10 Allow NULL? 
30R6CL12Worksheet Cell 12StringGeneric Edit100 Allow NULL? 
31R6MO12Math Operator 12StringUDC10 Allow NULL? 
32R6CL13Worksheet Cell 13StringGeneric Edit100 Allow NULL? 
33R6MO13Math Operator 13StringUDC10 Allow NULL? 
34R6CL14Worksheet Cell 14StringGeneric Edit100 Allow NULL? 
35R6MO14Math Operator 14StringUDC10 Allow NULL? 
36R6CL15Worksheet Cell 15StringGeneric Edit100 Allow NULL? 
37R6MO15Math Operator 15StringUDC10 Allow NULL? 
38R6CL16Worksheet Cell 16StringGeneric Edit100 Allow NULL? 
39R6MO16Math Operator 16StringUDC10 Allow NULL? 
40R6CL17Worksheet Cell 17StringGeneric Edit100 Allow NULL? 
41R6MO17Math Operator 17StringUDC10 Allow NULL? 
42R6CL18Worksheet Cell 18StringGeneric Edit100 Allow NULL? 
43R6MO18Math Operator 18StringUDC10 Allow NULL? 
44R6CL19Worksheet Cell 19StringGeneric Edit100 Allow NULL? 
45R6MO19Math Operator 19StringUDC10 Allow NULL? 
46R6CL20Worksheet Cell 20StringGeneric Edit100 Allow NULL? 
47R6MO20Math Operator 20StringUDC10 Allow NULL? 

TOP920 | H95 | F8306 INDEXES

NumberDescription
1PID VERS RNBR CNBR (Primary/Unique)
ElementAliasDescriptionSequence
1PIDProgram IDAscending
2VERSVersion HistoryAscending
3RNBRRow NumberAscending
4CNBRColumn NumberAscending