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
54HS: Health & Safety Incident Mgt
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F54HS02S21143Incident PeopleFiles54HS: Health & Safety Incident Mgt
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 S2HSINO, S2UKID, S2AN8, S2DL01, S2HSIRL, S2HSIID, S2HSIPC, S2HSIPD, S2HSIEM, S2HSICON, S2JBCX, S2HSIINJD, S2WCMP, S2WET, S2HSICIA, S2HSICN, S2HSICIR, S2HMCO, S2HMCU, S2DSI, S2HSIRHD, S2JBCD, S2JBST, S2SEX, S2HSITOP, S2UOM, S2HSIHW, S2HSIWB, S2ANPA, S2XAN8, S2DOB, S2HSIAG, S2SHFT, S2HSIDAC, S2HSIDC, S2HSIDAR, S2HSI3P, S2VR01, S2MNTR, S2ADD1, S2ADD2, S2ADD3, S2CTY1, S2ADDS, S2ADDZ, S2COUN, S2CTR, S2PH1, S2PH2, S2PH3, S2HSIEE, S2HSIIC, S2HSIIC2, S2HSISI, S2HSICF, S2HSIP01, S2HSIP02, S2HSIP03, S2HSIP04, S2HSIP05, S2HSIP06, S2HSIP07, S2HSIP08, S2HSIP09, S2HSIP10, S2HSISR, S2HSISIG, S2HSIDOS, S2OSH, S2HSIYRC, S2CASE, S2CSFX, S2CSTS, S2DCLO, S2IR, S2HSIOI, S2HSIBP, S2NDAW, S2NDWA, S2DDEC, S2DRT, S2ONPRM, S2HSIOL, S2ERCHKBX, S2HCHKBX, S2FACAN8, S2HSIMC, S2HSISD, S2HSIHCP, S2HSINOC, S2HSINC, S2HSIAT, S2HSIHO, S2HSIPO, S2HSIBJ, S2HSIBJO, S2HSIBL, S2HSIBW, S2HSIO1, S2HSIO2, S2HSIO3, S2HSIO4, S2URAB, S2URCD, S2URAT, S2URDT, S2URRF, S2USER, S2UPMJ, S2UPMT, S2JOBN, S2PID, S2HSISB, S2HSICS FROM F54HS02

TOP920 | 54HS | F54HS02 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1S2HSINOIncident NumberNumericGeneric Edit80 Allow NULL? 
2S2UKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
3S2AN8Address NumberNumericGeneric Edit80 Allow NULL? 
4S2DL01DescriptionStringGeneric Edit300 Allow NULL? 
5S2HSIRLIncident RoleStringUDC (54HS RL)20 Allow NULL? 
6S2HSIIDInjury / Illness DescriptionStringGeneric Edit400 Allow NULL? 
7S2HSIPCPrivacy CaseCharacterGeneric Edit10 Allow NULL? 
8S2HSIPDPrivacy Case Alternate DescriptionStringGeneric Edit400 Allow NULL? 
9S2HSIEMEmployeeCharacterGeneric Edit10 Allow NULL? 
10S2HSICONContractorCharacterGeneric Edit10 Allow NULL? 
11S2JBCXJob TitleStringGeneric Edit300 Allow NULL? 
12S2HSIINJDInjuredCharacterGeneric Edit10 Allow NULL? 
13S2WCMPWorker's Comp. Insurance CodeStringUDC (00 W)40 Allow NULL? 
14S2WETSub Class - Workers CompCharacterUDC (07 WH)10 Allow NULL? 
15S2HSICIAInsurance Claim AppliedCharacterGeneric Edit10 Allow NULL? 
16S2HSICNClaim NumberStringGeneric Edit400 Allow NULL? 
17S2HSICIRInsurance Claim ReasonStringUDC (54HS IR)20 Allow NULL? 
18S2HMCOCompany - HomeStringGeneric Edit50 Allow NULL? 
19S2HMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
20S2DSIDate - Original EmploymentDateGeneric Edit60
21S2HSIRHDRehire DateDateGeneric Edit110
22S2JBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
23S2JBSTJob StepStringUDC (06 GS)40 Allow NULL? 
24S2SEXGender (Male/Female)CharacterUDC (07 SG)10 Allow NULL? 
25S2HSITOPTime on ProjectNumericGeneric Edit152 Allow NULL? 
26S2UOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
27S2HSIHWHours Worked Prior to IncidentNumericGeneric Edit152 Allow NULL? 
28S2HSIWBTime Work BeganNumericGeneric Edit60 Allow NULL? 
29S2ANPASupervisorNumericGeneric Edit80 Allow NULL? 
30S2XAN8Address Number - ForemanNumericGeneric Edit80 Allow NULL? 
31S2DOBDate - BirthDateGeneric Edit60
32S2HSIAGAge GroupStringUDC (54HS AG)20 Allow NULL? 
33S2SHFTShift CodeCharacterUDC (06 SH)10 Allow NULL? 
34S2HSIDACDrug and Alcohol Test ConductedCharacterGeneric Edit10 Allow NULL? 
35S2HSIDCDrug and Alcohol CommentStringGeneric Edit400 Allow NULL? 
36S2HSIDARDrug and Alcohol ResultStringUDC (54HS DR)20 Allow NULL? 
37S2HSI3P3rd PartyCharacterGeneric Edit10 Allow NULL? 
38S2VR01ReferenceStringGeneric Edit250 Allow NULL? 
39S2MNTRMentorNumericGeneric Edit80 Allow NULL? 
40S2ADD1Address Line 1StringGeneric Edit400 Allow NULL? 
41S2ADD2Address Line 2StringGeneric Edit400 Allow NULL? 
42S2ADD3Address Line 3StringGeneric Edit400 Allow NULL? 
43S2CTY1CityStringGeneric Edit250 Allow NULL? 
44S2ADDSStateStringUDC (00 S)30 Allow NULL? 
45S2ADDZPostal CodeStringGeneric Edit120 Allow NULL? 
46S2COUNCountyStringUDC (00 CT)250 Allow NULL? 
47S2CTRCountryStringUDC (00 CN)30 Allow NULL? 
48S2PH1Phone NumberStringGeneric Edit200 Allow NULL? 
49S2PH2Phone Number 2StringGeneric Edit200 Allow NULL? 
50S2PH3Phone NumberStringGeneric Edit200 Allow NULL? 
51S2HSIEEPerson EmailStringGeneric Edit750 Allow NULL? 
52S2HSIICInjury ClassificationStringUDC (54HS IC)20 Allow NULL? 
53S2HSIIC2Secondary Injury ClassificationStringUDC (54HS IC)20 Allow NULL? 
54S2HSISISeverity of InjuryStringUDC (54HS SI)20 Allow NULL? 
55S2HSICFPrimary Causal FactorStringUDC (54HS CF)20 Allow NULL? 
56S2HSIP01Incident People Category Code 1StringUDC (54HS P1)30 Allow NULL? 
57S2HSIP02Incident People Category Code 2StringUDC (54HS P2)30 Allow NULL? 
58S2HSIP03Incident People Category Code 3StringUDC (54HS P3)30 Allow NULL? 
59S2HSIP04Incident People Category Code 4StringUDC (54HS P4)30 Allow NULL? 
60S2HSIP05Incident People Category Code 5StringUDC (54HS P5)30 Allow NULL? 
61S2HSIP06Incident People Category Code 6StringUDC (54HS P6)30 Allow NULL? 
62S2HSIP07Incident People Category Code 7StringUDC (54HS P7)30 Allow NULL? 
63S2HSIP08Incident People Category Code 8StringUDC (54HS P8)30 Allow NULL? 
64S2HSIP09Incident People Category Code 9StringUDC (54HS P9)30 Allow NULL? 
65S2HSIP10Incident People Category Code 10StringUDC (54HS P0)30 Allow NULL? 
66S2HSISRSignature RequiredCharacterGeneric Edit10 Allow NULL? 
67S2HSISIGSignatureStringGeneric Edit400 Allow NULL? 
68S2HSIDOSDate of SignatureDateGeneric Edit110
69S2OSHYes or No - OSHACharacterUDC (05 YN)10 Allow NULL? 
70S2HSIYRCYear - Incident CaseNumericGeneric Edit40 Allow NULL? 
71S2CASENumber - Case/FileNumericGeneric Edit80 Allow NULL? 
72S2CSFXSuffix - Case Entry NumberNumericGeneric Edit30 Allow NULL? 
73S2CSTSStatus - CaseStringUDC (08 CS)20 Allow NULL? 
74S2DCLODate - Case ClosedDateGeneric Edit60
75S2IRInjury/Illness Related (IN/IL)StringUDC (08H IR)20 Allow NULL? 
76S2HSIOIOccupational Injury / IllnessStringUDC (54HS OI)30 Allow NULL? 
77S2HSIBPPart of BodyStringUDC (54HS BP)40 Allow NULL? 
78S2NDAWNumber - Days Away from WorkNumericGeneric Edit50 Allow NULL? 
79S2NDWANumber - Days RestrictedNumericGeneric Edit50 Allow NULL? 
80S2DDECDate - DeceasedDateGeneric Edit60
81S2DRTDate - Returned to WorkDateGeneric Edit60
82S2ONPRMIncident Occured on Employer's PremisesCharacterUDC (00 ZO)10 Allow NULL? 
83S2HSIOLOccurrence LocationStringUDC (54HS OL)30 Allow NULL? 
84S2ERCHKBXEmergency Room Check BoxCharacterGeneric Edit10 Allow NULL? 
85S2HCHKBXHospitalized Overnight Check BoxCharacterGeneric Edit10 Allow NULL? 
86S2FACAN8Facility Address NumberNumericGeneric Edit80 Allow NULL? 
87S2HSIMCSent to Onsite Medical CenterCharacterGeneric Edit10 Allow NULL? 
88S2HSISDSent to DoctorCharacterGeneric Edit10 Allow NULL? 
89S2HSIHCPName of PhysicianStringGeneric Edit400 Allow NULL? 
90S2HSINOCNon-Occupational InjuryCharacterGeneric Edit10 Allow NULL? 
91S2HSINCSecondary Non-Occupational InjuryCharacterGeneric Edit10 Allow NULL? 
92S2HSIATAction When InjuredStringGeneric Edit2000 Allow NULL? 
93S2HSIHOHow Accident OccurredStringGeneric Edit2000 Allow NULL? 
94S2HSIPOPhysical Object InvolvedStringGeneric Edit2000 Allow NULL? 
95S2HSIBJBLS Job CategoryStringUDC (54HS BJ)20 Allow NULL? 
96S2HSIBJOBLS Job Category OtherStringGeneric Edit400 Allow NULL? 
97S2HSIBLBLS Service LengthStringUDC (54HS BL)20 Allow NULL? 
98S2HSIBWBLS Work ShiftCharacterUDC (54HS BW)10 Allow NULL? 
99S2HSIO1OIICS Code 1 - Nature of IllnessStringUDC (54HS O1)40 Allow NULL? 
100S2HSIO2OIICS Code 2 - Part of BodyStringUDC (54HS O2)40 Allow NULL? 
101S2HSIO3OIICS Code 3 - Source of InjuryStringUDC (54HS O3)40 Allow NULL? 
102S2HSIO4OIICS Code 4 - Event / ExposureStringUDC (54HS O4)40 Allow NULL? 
103S2URABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
104S2URCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
105S2URATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
106S2URDTUser Reserved DateDateGeneric Edit60
107S2URRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
108S2USERUser IDStringGeneric Edit100 Allow NULL? 
109S2UPMJDate - UpdatedDateGeneric Edit60
110S2UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
111S2JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
112S2PIDProgram IDStringGeneric Edit100 Allow NULL? 
113S2HSISBSide of BodyStringUDC (54HS SB)20 Allow NULL? 
114S2HSICSCurrent Status of Injury / IllnessStringUDC (54HS CS)20 Allow NULL? 

TOP920 | 54HS | F54HS02 INDEXES

NumberDescription
1IncidentNo UKID (Primary/Unique)
ElementAliasDescriptionSequence
1HSINOIncident NumberAscending
2UKIDUnique Key ID (Internal)Ascending
2IncidentNo
ElementAliasDescriptionSequence
1HSINOIncident NumberAscending
3Year CaseNo
ElementAliasDescriptionSequence
1HSIYRCYear - Incident CaseAscending
2CASENumber - Case/FileAscending