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

62 COLUMNS | 1 INDEXES | Print definition?920 | H95 | F82100 TABLE

H95: Object and Environment Tech
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F82100A1621World Writer Query HeaderFilesH95: Object and Environment Tech
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 A1QRYG, A1QRYN, A1JD, A1EXCL, A1DEST, A1USER, A1VCD, A1VED, A1PTSP, A1HJBQ, A1QTL1, A1QTL2, A1QTL3, A1DTTL, A1JOBQ, A1DFLS, A1DFCS, A1WRAP, A1TCOL, A1MAXR, A1OLPP, A1OVTF, A1PRTQ, A1LPI, A1CPI, A1RCOP, A1DLIN, A1HLDQ, A1WDTH, A1LNTH, A1OVRF, A1FMTP, A1OAPG, A1SDRW, A1FNID, A1FMFD, A1PTQT, A1CCHR, A1GCHR, A1CDPG, A1PROT, A1PGFT, A1HJUS, A1SEPP, A1OUTP, A1OFIL, A1OLBR, A1OMBR, A1LNKG, A1LNKN, A1SVDL, A1DUPL, A1USRD, A1SAVE, A1SPLF, A1PDN, A1IPDS, A1DBAT, A1DBEC, A1DBRT, A1DBCD, A1DBPC FROM F82100

TOP920 | H95 | F82100 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1A1QRYGQuery GroupStringUDC100 Allow NULL? 
2A1QRYNQuery NameStringGeneric Edit100 Allow NULL? 
3A1JDVersion TitleStringGeneric Edit500 Allow NULL? 
4A1EXCLUser Exclusive (0/1/2/3/4)CharacterUDC (H98 EX)10 Allow NULL? 
5A1DESTOutput DestinationCharacterUDC10 Allow NULL? 
6A1USERUser IDStringGeneric Edit100 Allow NULL? 
7A1VCDDate - Last ChangedDateGeneric Edit60
8A1VEDDate - Last ExecutedDateGeneric Edit60
9A1PTSPPrint Specifications Cover Page (Y/N)CharacterGeneric Edit10 Allow NULL? 
10A1HJBQHold on Job QueueCharacterGeneric Edit10 Allow NULL? 
11A1QTL1Query Version Title Line 1StringGeneric Edit500 Allow NULL? 
12A1QTL2Query Version Title Line 2StringGeneric Edit500 Allow NULL? 
13A1QTL3Query Version Title Line 3StringGeneric Edit500 Allow NULL? 
14A1DTTLPrompt - Details or TotalsCharacterUDC10 Allow NULL? 
15A1JOBQBatch Job QueueStringGeneric Edit100 Allow NULL? 
16A1DFLSDefault Line SpacingNumericGeneric Edit20 Allow NULL? 
17A1DFCSDefault Column SpacingNumericGeneric Edit20 Allow NULL? 
18A1WRAPQuery Line Wrap OptionCharacterGeneric Edit10 Allow NULL? 
19A1TCOLTotal Report columnsNumericGeneric Edit50 Allow NULL? 
20A1MAXRMaximum records to QueryNumericGeneric Edit150 Allow NULL? 
21A1OLPPPrompt - One Line Per PageCharacterUDC10 Allow NULL? 
22A1OVTFOverride to File NameStringGeneric Edit100 Allow NULL? 
23A1PRTQPrint QueueStringGeneric Edit100 Allow NULL? 
24A1LPILines Per InchStringUDC30 Allow NULL? 
25A1CPICharacters Per InchStringUDC40 Allow NULL? 
26A1RCOPNumber of Report CopiesNumericGeneric Edit30 Allow NULL? 
27A1DLINNumber of Lines Between DetailNumericGeneric Edit10 Allow NULL? 
28A1HLDQHold on Print QueueCharacterUDC (H98 HL)10 Allow NULL? 
29A1WDTHMaximum Form WidthNumericGeneric Edit30 Allow NULL? 
30A1LNTHMaximum Form LengthNumericGeneric Edit30 Allow NULL? 
31A1OVRFLocation of Page OverflowNumericGeneric Edit30 Allow NULL? 
32A1FMTPForm TypeStringGeneric Edit100 Allow NULL? 
33A1OAPGAlign PageCharacterGeneric Edit10 Allow NULL? 
34A1SDRWSource DrawerStringUDC30 Allow NULL? 
35A1FNIDFont IdentificationStringGeneric Edit100 Allow NULL? 
36A1FMFDForm FeedStringGeneric Edit80 Allow NULL? 
37A1PTQTPrint QualityStringGeneric Edit60 Allow NULL? 
38A1CCHRControl CharacterStringGeneric Edit50 Allow NULL? 
39A1GCHRGraphic Character SetStringGeneric Edit70 Allow NULL? 
40A1CDPGCode PageStringGeneric Edit60 Allow NULL? 
41A1PROTPage RotationStringGeneric Edit50 Allow NULL? 
42A1PGFTPrint TextStringGeneric Edit300 Allow NULL? 
43A1HJUSJustificationStringGeneric Edit60 Allow NULL? 
44A1SEPPSeparator PagesCharacterGeneric Edit10 Allow NULL? 
45A1OUTPOutput PriorityCharacterGeneric Edit10 Allow NULL? 
46A1OFILOutput FileStringGeneric Edit100 Allow NULL? 
47A1OLBROutput LibraryStringGeneric Edit100 Allow NULL? 
48A1OMBROutput MemberStringGeneric Edit100 Allow NULL? 
49A1LNKGLink Query GroupStringUDC100 Allow NULL? 
50A1LNKNLink Query NameStringGeneric Edit100 Allow NULL? 
51A1SVDLSave or DeleteCharacterGeneric Edit10 Allow NULL? 
52A1DUPLDuplex OutputCharacterUDC (H98 DU)10 Allow NULL? 
53A1USRDUser DataStringGeneric Edit100 Allow NULL? 
54A1SAVESave Spool FileCharacterGeneric Edit10 Allow NULL? 
55A1SPLFSpool File NameStringGeneric Edit100 Allow NULL? 
56A1PDNPrinter Device NameStringGeneric Edit100 Allow NULL? 
57A1IPDSIntelligent Printer Data StreamCharacterGeneric Edit10 Allow NULL? 
58A1DBATInclude Double-Byte Character Data (Y/N)CharacterGeneric Edit10 Allow NULL? 
59A1DBECProcess Double-Byte Extension Char (Y/N)CharacterGeneric Edit10 Allow NULL? 
60A1DBRTRotate Double-Byte Characters (Y/N)CharacterGeneric Edit10 Allow NULL? 
61A1DBCDDouble-Byte Character DensityStringUDC (H98 DB)30 Allow NULL? 
62A1DBPCPrint Double-Byte Characters (Y/N)CharacterUDC (H98 DC)10 Allow NULL? 

TOP920 | H95 | F82100 INDEXES

NumberDescription
1Key1 (Primary/Unique)
ElementAliasDescriptionSequence
1QRYGQuery GroupAscending
2QRYNQuery NameAscending