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

is JDE Date
Home | 920 | H95 | F8304
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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

52 COLUMNS | 1 INDEXES | Print definition?920 | H95 | F8304 TABLE

H95: Object and Environment Tech
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F8304R4521FASTR - Column 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 R4PID, R4VERS, R4CNBR, R4CH01, R4CH02, R4CH03, R4CH04, R4CSIZ, R4PCOL, R4LT, R4FIYR, R4COLT, R4CINC, R4OR01, R4OR02, R4OR03, R4OR04, R4OR05, R4OR06, R4OR07, R4OR08, R4OR09, R4OR10, R4OR11, R4OR12, R4OR13, R4OR14, R4OR15, R4OR16, R4OR17, R4OR18, R4OR19, R4OR20, R4OR21, R4OR22, R4OR23, R4OR24, R4DECI, R4DBA, R4CRA, R4UNTC, R4DBCC, R4CRCC, R4DBSL, R4CRSL, R4DSLT, R4CSLT, R4JELT, R4TOT, R4PNRF, R4EC, R4FLCY FROM F8304

TOP920 | H95 | F8304 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1R4PIDProgram IDStringGeneric Edit100 Allow NULL? 
2R4VERSVersion HistoryStringGeneric Edit100 Allow NULL? 
3R4CNBRColumn NumberStringGeneric Edit20 Allow NULL? 
4R4CH01Column Heading 01StringGeneric Edit100 Allow NULL? 
5R4CH02Column Heading 02StringGeneric Edit100 Allow NULL? 
6R4CH03Column Heading 03StringGeneric Edit100 Allow NULL? 
7R4CH04Column Heading 04StringGeneric Edit100 Allow NULL? 
8R4CSIZColumn SizeNumericGeneric Edit20 Allow NULL? 
9R4PCOLPrint ColumnStringGeneric Edit20 Allow NULL? 
10R4LTLedger TypesStringUDC (09 LT)20 Allow NULL? 
11R4FIYRFiscal YearStringGeneric Edit20 Allow NULL? 
12R4COLTColumn TypeStringUDC20 Allow NULL? 
13R4CINCColumn Account Selection CodeStringUDC20 Allow NULL? 
14R4OR01Object Range 01StringGeneric Edit150 Allow NULL? 
15R4OR02Object Range 02StringUDC150 Allow NULL? 
16R4OR03Object Range 03StringGeneric Edit150 Allow NULL? 
17R4OR04Object Range 04StringUDC150 Allow NULL? 
18R4OR05Object Range 05StringGeneric Edit150 Allow NULL? 
19R4OR06Object Range 06StringUDC150 Allow NULL? 
20R4OR07Object Range 07StringGeneric Edit150 Allow NULL? 
21R4OR08Object Range 08StringUDC150 Allow NULL? 
22R4OR09Object Range 09StringGeneric Edit150 Allow NULL? 
23R4OR10Object Range 10StringUDC150 Allow NULL? 
24R4OR11Object Range 11StringGeneric Edit150 Allow NULL? 
25R4OR12Object Range 12StringUDC150 Allow NULL? 
26R4OR13Object Range 13StringUDC150 Allow NULL? 
27R4OR14Object Range 14StringUDC150 Allow NULL? 
28R4OR15Object Range 15StringUDC150 Allow NULL? 
29R4OR16Object Range 16StringUDC150 Allow NULL? 
30R4OR17Object Range 17StringUDC150 Allow NULL? 
31R4OR18Object Range 18StringUDC150 Allow NULL? 
32R4OR19Object Range 19StringUDC150 Allow NULL? 
33R4OR20Object Range 20StringUDC150 Allow NULL? 
34R4OR21Object Range 21StringUDC150 Allow NULL? 
35R4OR22Object Range 22StringUDC150 Allow NULL? 
36R4OR23Object Range 23StringUDC150 Allow NULL? 
37R4OR24Object Range 24StringUDC150 Allow NULL? 
38R4DECIData Display DecimalsCharacterGeneric Edit10 Allow NULL? 
39R4DBAReport ResultStringGeneric Edit150 Allow NULL? 
40R4CRAJ.E. Offset AccountStringGeneric Edit150 Allow NULL? 
41R4UNTCJ.E. Units ColumnStringGeneric Edit20 Allow NULL? 
42R4DBCCReport Result Business UnitStringGeneric Edit120 Allow NULL? 
43R4CRCCJ.E. Offset Business UnitStringGeneric Edit120 Allow NULL? 
44R4DBSLReport Result SubledgerStringGeneric Edit80 Allow NULL? 
45R4CRSLJ.E. Offset SubledgerStringGeneric Edit80 Allow NULL? 
46R4DSLTJ.E. Debit Subledger TypeCharacterUDC (00 ST)10 Allow NULL? 
47R4CSLTJ.E. Credit Subledger TypeCharacterUDC (00 ST)10 Allow NULL? 
48R4JELTJ.E. Ledger TypeStringGeneric Edit20 Allow NULL? 
49R4TOTTotal (Y/N)CharacterGeneric Edit10 Allow NULL? 
50R4PNRFPeriod Number ReferenceStringGeneric Edit30 Allow NULL? 
51R4ECEdit CodeCharacterUDC (98 EC)10 Allow NULL? 
52R4FLCYFloating Currency SymbolCharacterUDC10 Allow NULL? 

TOP920 | H95 | F8304 INDEXES

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

All references to JDE, JD Edwards and Oracle logos are trademarks of Oracle Corporation USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the Oracle Corporation or any of its affiliates.
About :: Terms :: Privacy