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

88 COLUMNS | 8 INDEXES | Print definition?910 | 54HS | F54HS01 TABLE

54HS: Health & Safety Incident Mgt
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F54HS01S1888Incident MasterFiles54HS: 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 S1HSINO, S1HSIDN, S1HSIDT, S1HSITM, S1HSIDM, S1WKD, S1HSIDR, S1HSITR, S1HSIST, S1HSISV, S1HSINOP, S1HSINM, S1HSIPED, S1HSIMV, S1HSIINJ, S1HSIENV, S1HSISEC, S1HSISC, S1HSIOT, S1HSIOC, S1HSIXS, S1HSIAA, S1HSILN, S1ESTB, S1CO, S1MCUS, S1MCU, S1CTR, S1ADDS, S1ADD1, S1ADD2, S1ADD3, S1ADD4, S1CTY1, S1ADDZ, S1COUN, S1LATT, S1LONG, S1REGION, S1DOCO, S1HSITEC, S1HSITAC, S1CRCD, S1HSIDA, S1HSIDC, S1HSIDAR, S1HSICR, S1HSICRN, S1HSICRNM, S1HSIFR, S1HSIPR, S1HSIPRC, S1HSIPRN, S1HSIPRNM, S1HSIDTC, S1HSICSF, S1HSIINS, S1HSICIS, S1HSIEF, S1HSIRT, S1HSICMT, S1HSINT, S1HSIC01, S1HSIC02, S1HSIC03, S1HSIC04, S1HSIC05, S1HSIC06, S1HSIC07, S1HSIC08, S1HSIC09, S1HSIC10, S1HSIOR, S1HSIRB, S1HSIHR, S1HSIIB, S1KBCO, S1URAB, S1URCD, S1URAT, S1URDT, S1URRF, S1USER, S1UPMJ, S1UPMT, S1JOBN, S1PID, S1CRTU FROM F54HS01

TOP910 | 54HS | F54HS01 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1S1HSINOIncident NumberNumericGeneric Edit80 Allow NULL? 
2S1HSIDNIncident DescriptionStringGeneric Edit1000 Allow NULL? 
3S1HSIDTIncident DateDateGeneric Edit110
4S1HSITMIncident TimeNumericGeneric Edit60 Allow NULL? 
5S1HSIDMIncident MonthStringUDC (06 MN)20 Allow NULL? 
6S1WKDDay of WeekCharacterUDC (08 WD)10 Allow NULL? 
7S1HSIDRIncident Date ReportedDateGeneric Edit110
8S1HSITRIncident Time ReportedNumericGeneric Edit60 Allow NULL? 
9S1HSISTIncident StatusStringUDC (54HS ST)20 Allow NULL? 
10S1HSISVIncident SeverityStringUDC (54HS SV)20 Allow NULL? 
11S1HSINOPParent Incident NumberNumericGeneric Edit80 Allow NULL? 
12S1HSINMPotential IncidentIntegerGeneric Edit110 Allow NULL? 
13S1HSIPEDProperty / Equipment DamageIntegerGeneric Edit110 Allow NULL? 
14S1HSIMVMotor Vehicle InvolvedIntegerGeneric Edit110 Allow NULL? 
15S1HSIINJInjury / IllnessIntegerGeneric Edit110 Allow NULL? 
16S1HSIENVEnvironmental ImpactIntegerGeneric Edit110 Allow NULL? 
17S1HSISECSecurityIntegerGeneric Edit110 Allow NULL? 
18S1HSISCSecurity ClassificationStringUDC (54HS SC)20 Allow NULL? 
19S1HSIOTOtherIntegerGeneric Edit110 Allow NULL? 
20S1HSIOCOther ClassificationStringUDC (54HS OC)20 Allow NULL? 
21S1HSIXSExclude From Safety StatisticsIntegerGeneric Edit110 Allow NULL? 
22S1HSIAAAuthorities AlertedIntegerGeneric Edit110 Allow NULL? 
23S1HSILNIncident LocationStringGeneric Edit2000 Allow NULL? 
24S1ESTBNumber - Establishment of Business ActivNumericGeneric Edit80 Allow NULL? 
25S1COCompanyStringGeneric Edit50 Allow NULL? 
26S1MCUSBusiness Unit - SubsequentStringGeneric Edit120 Allow NULL? 
27S1MCUBusiness UnitStringGeneric Edit120 Allow NULL? 
28S1CTRCountryStringUDC (00 CN)30 Allow NULL? 
29S1ADDSStateStringUDC (00 S)30 Allow NULL? 
30S1ADD1Address Line 1StringGeneric Edit400 Allow NULL? 
31S1ADD2Address Line 2StringGeneric Edit400 Allow NULL? 
32S1ADD3Address Line 3StringGeneric Edit400 Allow NULL? 
33S1ADD4Address Line 4StringGeneric Edit400 Allow NULL? 
34S1CTY1CityStringGeneric Edit250 Allow NULL? 
35S1ADDZPostal CodeStringGeneric Edit120 Allow NULL? 
36S1COUNCountyStringUDC (00 CT)250 Allow NULL? 
37S1LATTLatitudeStringGeneric Edit250 Allow NULL? 
38S1LONGLongitudeStringGeneric Edit250 Allow NULL? 
39S1REGIONGeographic Region CodeStringUDC (17 GR)30 Allow NULL? 
40S1DOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
41S1HSITECTotal Incident Estimated CostNumericGeneric Edit152 Allow NULL? 
42S1HSITACTotal Incident Actual CostNumericGeneric Edit152 Allow NULL? 
43S1CRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
44S1HSIDADrug and Alcohol TestIntegerGeneric Edit110 Allow NULL? 
45S1HSIDCDrug and Alcohol CommentStringGeneric Edit400 Allow NULL? 
46S1HSIDARDrug and Alcohol ResultStringUDC (54HS DR)20 Allow NULL? 
47S1HSICRContractor/3rd Party InvolvedIntegerGeneric Edit110 Allow NULL? 
48S1HSICRNContractor/3rd Party NumberNumericGeneric Edit80 Allow NULL? 
49S1HSICRNMContractor/3rd Party NameStringGeneric Edit400 Allow NULL? 
50S1HSIFRIncident FrequencyStringUDC (54HS FR)20 Allow NULL? 
51S1HSIPRPotential RecurrenceStringUDC (54HS PR)20 Allow NULL? 
52S1HSIPRCParty Responsible CodeStringUDC (54HS RS)20 Allow NULL? 
53S1HSIPRNParty Responsible NumberNumericGeneric Edit80 Allow NULL? 
54S1HSIPRNMParty Responsible NameStringGeneric Edit400 Allow NULL? 
55S1HSIDTCDetermined CauseStringGeneric Edit400 Allow NULL? 
56S1HSICSFIncident Causal FactorStringUDC (54HS FC)30 Allow NULL? 
57S1HSIINSInsurance Claim NumberStringGeneric Edit400 Allow NULL? 
58S1HSICISInsurance Claim StatusStringUDC (54HS IS)20 Allow NULL? 
59S1HSIEFEffect on Environment TextStringGeneric Edit2000 Allow NULL? 
60S1HSIRTRemediation TextStringGeneric Edit2000 Allow NULL? 
61S1HSICMTCorrective Measures TextStringGeneric Edit2000 Allow NULL? 
62S1HSINTOther TextStringGeneric Edit2000 Allow NULL? 
63S1HSIC01Incident Category Code 01StringUDC (54HS C1)30 Allow NULL? 
64S1HSIC02Incident Category Code 02StringUDC (54HS C2)30 Allow NULL? 
65S1HSIC03Incident Category Code 03StringUDC (54HS C3)30 Allow NULL? 
66S1HSIC04Incident Category Code 04StringUDC (54HS C4)30 Allow NULL? 
67S1HSIC05Incident Category Code 05StringUDC (54HS C5)30 Allow NULL? 
68S1HSIC06Incident Category Code 06StringUDC (54HS C6)30 Allow NULL? 
69S1HSIC07Incident Category Code 07StringUDC (54HS C7)30 Allow NULL? 
70S1HSIC08Incident Category Code 08StringUDC (54HS C8)30 Allow NULL? 
71S1HSIC09Incident Category Code 09StringUDC (54HS C9)30 Allow NULL? 
72S1HSIC10Incident Category Code 10StringUDC (54HS C0)30 Allow NULL? 
73S1HSIOROriginator AddressNumericGeneric Edit80 Allow NULL? 
74S1HSIRBReported By AddressNumericGeneric Edit80 Allow NULL? 
75S1HSIHRIncident Handler AddressNumericGeneric Edit80 Allow NULL? 
76S1HSIIBInvestigated By AddressNumericGeneric Edit80 Allow NULL? 
77S1KBCOFailure Analysis CodeStringGeneric Edit150 Allow NULL? 
78S1URABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
79S1URCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
80S1URATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
81S1URDTUser Reserved DateDateGeneric Edit60
82S1URRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
83S1USERUser IDStringGeneric Edit100 Allow NULL? 
84S1UPMJDate - UpdatedDateGeneric Edit60
85S1UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
86S1JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
87S1PIDProgram IDStringGeneric Edit100 Allow NULL? 
88S1CRTUCreated by userStringGeneric Edit100 Allow NULL? 

TOP910 | 54HS | F54HS01 INDEXES

NumberDescription
1IncidentNo (Primary/Unique)
ElementAliasDescriptionSequence
1HSINOIncident NumberAscending
2IncidentDate ExcludeSafetyFlag
ElementAliasDescriptionSequence
1HSIDTIncident DateAscending
2HSIXSExclude From Safety StatisticsAscending
3HSINMPotential IncidentAscending
3Establishment
ElementAliasDescriptionSequence
1ESTBNumber - Establishment of Business ActivAscending
4Company
ElementAliasDescriptionSequence
1COCompanyAscending
5Project
ElementAliasDescriptionSequence
1MCUSBusiness Unit - SubsequentAscending
6BusinessUnit
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
7Contractor
ElementAliasDescriptionSequence
1HSICRNContractor/3rd Party NumberAscending
8IncidentDateDesc
ElementAliasDescriptionSequence
1HSIDTIncident DateDescending