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
1910F54HS02S21113Incident 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, 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 FROM F54HS02

TOP910 | 54HS | F54HS02 COLUMNS

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

TOP910 | 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