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

33 COLUMNS | 10 INDEXES | Print definition?920 | H95 | F00950 TABLE

H95: Object and Environment Tech
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F00950FS3310Security Workbench TableMaster FilesH95: Object and Environment TechSystem Tables
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 FSSETY, FSUSER, FSOBNM, FSDTAI, FSFRDV, FSSY, FSOWDI, FSFMNM, FSFUNO, FSINSL, FSRUN, FSVWYN, FSA, FSCHNG, FSDLT, FSTHDV, FSOBID, FSADDC, FSIOK, FSICPY, FSIUPT, FSATN1, FSATN2, FSATN3, FSMUSE, FSPID, FSJOBN, FSUPMJ, FSUPMT, FSEXITID, FSTABID, FSTEXTID, FSPTH FROM F00950

TOP920 | H95 | F00950 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1FSSETYSecurity TypeCharacterUDC (98 TY)10 Allow NULL? 
2FSUSERUser IDStringGeneric Edit100 Allow NULL? 
3FSOBNMObject NameStringGeneric Edit100 Allow NULL? 
4FSDTAIData ItemStringGeneric Edit100 Allow NULL? 
5FSFRDVFrom Data ValueStringGeneric Edit300 Allow NULL? 
6FSSYProduct CodeStringUDC (98 SY)40 Allow NULL? 
7FSOWDIData Item (EnterpriseOne)StringGeneric Edit400 Allow NULL? 
8FSFMNMForm NameStringGeneric Edit100 Allow NULL? 
9FSFUNOObject TypeStringUDC (98 OF)40 Allow NULL? 
10FSINSLInstall Application (Y/N)CharacterUDC (H00 YN)10 Allow NULL? 
11FSRUNRun Application (Y/N)CharacterUDC (H00 YN)10 Allow NULL? 
12FSVWYNView (Y/N)CharacterGeneric Edit10 Allow NULL? 
13FSAAdd (Y/N)CharacterUDC (H00 YN)10 Allow NULL? 
14FSCHNGChange (Y/N)CharacterUDC (H00 CH)10 Allow NULL? 
15FSDLTDelete (Y/N)CharacterUDC (H00 DL)10 Allow NULL? 
16FSTHDVThru Data ValueStringGeneric Edit300 Allow NULL? 
17FSOBIDObject IdentifierIdentifier (ID)Generic Edit110
18FSADDCAdd or ChangeCharacterUDC (98 AC)10 Allow NULL? 
19FSIOKOK/Select ActionCharacterGeneric Edit10 Allow NULL? 
20FSICPYCopy ActionCharacterGeneric Edit10 Allow NULL? 
21FSIUPTUpdate ActionCharacterGeneric Edit10 Allow NULL? 
22FSATN1Scroll to End (Y/N)CharacterGeneric Edit10 Allow NULL? 
23FSATN2Prompt for VersionCharacterGeneric Edit10 Allow NULL? 
24FSATN3Reserve Action 3CharacterGeneric Edit10 Allow NULL? 
25FSMUSEUser IDStringGeneric Edit100 Allow NULL? 
26FSPIDProgram IDStringGeneric Edit100 Allow NULL? 
27FSJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
28FSUPMJDate - UpdatedDateGeneric Edit60
29FSUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
30FSEXITIDExit IdentifierIdentifier (ID)Generic Edit110
31FSTABIDTab IdentifierIdentifier (ID)Generic Edit110
32FSTEXTIDText ID - EnterpriseOneIdentifier (ID)Generic Edit110
33FSPTHPathStringGeneric Edit1200 Allow NULL? 

TOP920 | H95 | F00950 INDEXES

NumberDescription
1TYPE USER OBJ DTAI (Primary/Unique)
ElementAliasDescriptionSequence
1SETYSecurity TypeAscending
2USERUser IDAscending
3OBNMObject NameAscending
4DTAIData ItemAscending
5FRDVFrom Data ValueAscending
6SYProduct CodeAscending
2TYPE USER OBJ SY
ElementAliasDescriptionSequence
1SETYSecurity TypeAscending
2USERUser IDAscending
3OBNMObject NameAscending
4SYProduct CodeAscending
3TYPE USER OBJ OBID
ElementAliasDescriptionSequence
1SETYSecurity TypeAscending
2USERUser IDAscending
3OBNMObject NameAscending
4FMNMForm NameAscending
5OBIDObject IdentifierAscending
4TYPE USER OBJ FMNM EXIT
ElementAliasDescriptionSequence
1SETYSecurity TypeAscending
2USERUser IDAscending
3OBNMObject NameAscending
4FMNMForm NameAscending
5EXITIDExit IdentifierAscending
5TYPE USER OBJ FMNM TABID
ElementAliasDescriptionSequence
1SETYSecurity TypeAscending
2USERUser IDAscending
3OBNMObject NameAscending
4FMNMForm NameAscending
5TABIDTab IdentifierAscending
6TYPE USER PATH
ElementAliasDescriptionSequence
1SETYSecurity TypeAscending
2USERUser IDAscending
3PTHPathAscending
7TYPE OBNM
ElementAliasDescriptionSequence
1SETYSecurity TypeAscending
2OBNMObject NameAscending
8User
ElementAliasDescriptionSequence
1USERUser IDAscending
9TYPE USER OBJ DTAI FROM ATN3
ElementAliasDescriptionSequence
1SETYSecurity TypeAscending
2USERUser IDAscending
3OBNMObject NameAscending
4DTAIData ItemAscending
5FRDVFrom Data ValueAscending
6THDVThru Data ValueAscending
7ATN3Reserve Action 3Ascending
10TYPE USER OBJ PATH
ElementAliasDescriptionSequence
1SETYSecurity TypeAscending
2USERUser IDAscending
3OBNMObject NameAscending
4PTHPathAscending