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

63 COLUMNS | 9 INDEXES | Print definition?812 | H91 | F91300 TABLE

H91: Design Tools
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F91300SJ639Schedule Job MasterExtra Features FilesH91: Design ToolsSystem 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 SJSCHJBTYP, SJSCHJBNM, SJSCHRPTNM, SJSCHVER, SJPROCNAME, SJSCHSTTIME, SJSCHENTIME, SJNUMJOBOCC, SJCURRUNCNT, SJMAXRESUB, SJSCHJBSTAT, SJSCHENHV, SJSCHJOBSVR, SJSCHUSER, SJSCHPSWD, SJSCHROLE, SJJDELOG, SJTRACING, SJUBELOGLVL, SJSCHPI, SJPNTR, SJJOBQUE, SJRESBONERR, SJRESBTIME, SJINPRTMOTPY, SJINPRMAX, SJINPRTMOUT, SJJOBEXPIRE, SJSCHRCRTYP, SJCO, SJSCHNUMMNS, SJSCHNUMHRS, SJSCHNUMDY, SJSCHNUMWKS, SJSCHNUMMN, SJSCHDAY, SJWEEKDAY, SJWEEKEND, SJMONDAY, SJTUESDAY, SJWEDNESDAY, SJTHURSDAY, SJFRIDAY, SJSATURDAY, SJSUNDAY, SJTIMEZONES, SJDAYLIGHTSV, SJDSAVNAME, SJSCHCTCD01, SJSCHCTCD02, SJSCHCTCD03, SJSCHCTCD04, SJSCHCTCD05, SJSCHFU1, SJSCHFU2, SJSCHFU3, SJSCHFU4, SJUSER, SJPID, SJJOBN, SJUPMJ, SJUPMT, SJSCHPWD FROM F91300

TOP812 | H91 | F91300 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SJSCHJBTYPScheduled Job TypeStringUDC (H91 JT)20 Allow NULL? 
2SJSCHJBNMScheduled Job NameStringGeneric Edit300 Allow NULL? 
3SJSCHRPTNMScheduled Report NameStringGeneric Edit100 Allow NULL? 
4SJSCHVERScheduled VersionStringGeneric Edit100 Allow NULL? 
5SJPROCNAMEProcess IDStringGeneric Edit100 Allow NULL? 
6SJSCHSTTIMEScheduled Start ANSI C UTC TimeNumericGeneric Edit150 Allow NULL? 
7SJSCHENTIMEScheduled End ANSI C UTC TimeNumericGeneric Edit150 Allow NULL? 
8SJNUMJOBOCCNumber Of Job OccurencesNumericGeneric Edit90 Allow NULL? 
9SJCURRUNCNTNumber Of RunsNumericGeneric Edit90 Allow NULL? 
10SJMAXRESUBMax Number of Job re-submissionsIntegerGeneric Edit90 Allow NULL? 
11SJSCHJBSTATScheduled Job StatusStringUDC (H91 JS)20 Allow NULL? 
12SJSCHENHVEnvironment job will be launched inStringGeneric Edit100 Allow NULL? 
13SJSCHJOBSVRServer scheduled job will be launched onStringGeneric Edit300 Allow NULL? 
14SJSCHUSERUser the job will be launched withStringGeneric Edit100 Allow NULL? 
15SJSCHPSWDPassword to be used to launch jobStringGeneric Edit100 Allow NULL? 
16SJSCHROLEScheduled User RoleStringGeneric Edit150 Allow NULL? 
17SJJDELOGLogging (JDE.log)CharacterGeneric Edit10 Allow NULL? 
18SJTRACINGTracingCharacterGeneric Edit10 Allow NULL? 
19SJUBELOGLVLUBE Logging LevelCharacterUDC (H93 LL)10 Allow NULL? 
20SJSCHPIScheduler - Print Immediate FlagCharacterGeneric Edit10 Allow NULL? 
21SJPNTRPrinter NameStringGeneric Edit300 Allow NULL? 
22SJJOBQUEJob QueueStringUDC (98 JQ)100 Allow NULL? 
23SJRESBONERRPolicy to resubmit on job errorStringUDC (H91 RE)20 Allow NULL? 
24SJRESBTIMETime delay before resubmitting error jobNumericGeneric Edit150 Allow NULL? 
25SJINPRTMOTPYIn Process Time Out PolicyStringUDC (H91 TO)20 Allow NULL? 
26SJINPRMAXMaximum time a job should be in processNumericGeneric Edit150 Allow NULL? 
27SJINPRTMOUTDelay until resubmitting a time out jobNumericGeneric Edit150 Allow NULL? 
28SJJOBEXPIREJob expires this many minutes after strtNumericGeneric Edit150 Allow NULL? 
29SJSCHRCRTYPRecurrenc TypeStringUDC (H91 RC)20 Allow NULL? 
30SJCOCompanyStringGeneric Edit50 Allow NULL? 
31SJSCHNUMMNSScheduled MinutesNumericGeneric Edit50 Allow NULL? 
32SJSCHNUMHRSScheduled HoursNumericGeneric Edit50 Allow NULL? 
33SJSCHNUMDYScheduled DaysNumericGeneric Edit90 Allow NULL? 
34SJSCHNUMWKSScheduled WeeksNumericUDC50 Allow NULL? 
35SJSCHNUMMNScheduled MonthNumericGeneric Edit50 Allow NULL? 
36SJSCHDAYDayCharacterGeneric Edit10 Allow NULL? 
37SJWEEKDAYWeekdayCharacterGeneric Edit10 Allow NULL? 
38SJWEEKENDWeekendCharacterGeneric Edit10 Allow NULL? 
39SJMONDAYMondayCharacterGeneric Edit10 Allow NULL? 
40SJTUESDAYTuesdayCharacterGeneric Edit10 Allow NULL? 
41SJWEDNESDAYWednesdayCharacterGeneric Edit10 Allow NULL? 
42SJTHURSDAYThursdayCharacterGeneric Edit10 Allow NULL? 
43SJFRIDAYFridayCharacterGeneric Edit10 Allow NULL? 
44SJSATURDAYSaturdayCharacterGeneric Edit10 Allow NULL? 
45SJSUNDAYSundayCharacterGeneric Edit10 Allow NULL? 
46SJTIMEZONESTime Zone ListStringUDC (H91 TZ)20 Allow NULL? 
47SJDAYLIGHTSVAdjust local time for daylight savingsCharacterGeneric Edit10 Allow NULL? 
48SJDSAVNAMEDaylight Savings Rule NameStringUDC100 Allow NULL? 
49SJSCHCTCD01Scheduler Category Code 1StringUDC (H91 1S)60 Allow NULL? 
50SJSCHCTCD02Scheduler Category Code 2StringUDC (H91 2S)60 Allow NULL? 
51SJSCHCTCD03Scheduler Category Code 3StringUDC (H91 3S)60 Allow NULL? 
52SJSCHCTCD04Scheduler Category Code 4StringUDC (H91 4S)60 Allow NULL? 
53SJSCHCTCD05Scheduler Category Code 5StringUDC (H91 5S)60 Allow NULL? 
54SJSCHFU1Numeric Future Use 1NumericGeneric Edit150 Allow NULL? 
55SJSCHFU2Numeric Future Use 2NumericGeneric Edit150 Allow NULL? 
56SJSCHFU3String Future Use 3StringGeneric Edit300 Allow NULL? 
57SJSCHFU4String Future Use 4StringGeneric Edit300 Allow NULL? 
58SJUSERUser IDStringGeneric Edit100 Allow NULL? 
59SJPIDProgram IDStringGeneric Edit100 Allow NULL? 
60SJJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
61SJUPMJDate - UpdatedDateGeneric Edit60
62SJUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
63SJSCHPWDUser Password for Scheduled JobBinary (Blob)Generic Edit41960

TOP812 | H91 | F91300 INDEXES

NumberDescription
1Job Name (Primary/Unique)
ElementAliasDescriptionSequence
1SCHJBNMScheduled Job NameAscending
2Report Name Version
ElementAliasDescriptionSequence
1SCHRPTNMScheduled Report NameAscending
2SCHVERScheduled VersionAscending
3WorkFlow Process
ElementAliasDescriptionSequence
1PROCNAMEProcess IDAscending
4Job Type
ElementAliasDescriptionSequence
1SCHJBTYPScheduled Job TypeAscending
6StartDateTime
ElementAliasDescriptionSequence
1SCHSTTIMEScheduled Start ANSI C UTC TimeAscending
7Category Codes
ElementAliasDescriptionSequence
1SCHCTCD01Scheduler Category Code 1Ascending
2SCHCTCD02Scheduler Category Code 2Ascending
3SCHCTCD03Scheduler Category Code 3Ascending
4SCHCTCD04Scheduler Category Code 4Ascending
5SCHCTCD05Scheduler Category Code 5Ascending
8User Server Env
ElementAliasDescriptionSequence
1SCHUSERUser the job will be launched withAscending
2SCHJOBSVRServer scheduled job will be launched onAscending
3SCHENHVEnvironment job will be launched inAscending
9Error Policy
ElementAliasDescriptionSequence
1RESBONERRPolicy to resubmit on job errorAscending
10Time Out Policy
ElementAliasDescriptionSequence
1INPRTMOTPYIn Process Time Out PolicyAscending