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
1910F54HS01MI1911Incident Master Change HistoryFiles54HS: 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 I1HSINO, I1HSIMN, I1HSIMT, I1MODDT, I1HSIDN, I1HSIDT, I1HSITM, I1HSIDM, I1WKD, I1HSIDR, I1HSITR, I1HSIST, I1HSISV, I1HSINOP, I1HSINM, I1HSIPED, I1HSIMV, I1HSIINJ, I1HSIENV, I1HSISEC, I1HSISC, I1HSIOT, I1HSIOC, I1HSIXS, I1HSIAA, I1HSILN, I1ESTB, I1CO, I1MCUS, I1MCU, I1CTR, I1ADDS, I1ADD1, I1ADD2, I1ADD3, I1ADD4, I1CTY1, I1ADDZ, I1COUN, I1LATT, I1LONG, I1REGION, I1DOCO, I1HSITEC, I1HSITAC, I1CRCD, I1HSIDA, I1HSIDC, I1HSIDAR, I1HSICR, I1HSICRN, I1HSICRNM, I1HSIFR, I1HSIPR, I1HSIPRC, I1HSIPRN, I1HSIPRNM, I1HSIDTC, I1HSICSF, I1HSIINS, I1HSICIS, I1HSIEF, I1HSIRT, I1HSICMT, I1HSINT, I1HSIC01, I1HSIC02, I1HSIC03, I1HSIC04, I1HSIC05, I1HSIC06, I1HSIC07, I1HSIC08, I1HSIC09, I1HSIC10, I1HSIOR, I1HSIRB, I1HSIHR, I1HSIIB, I1KBCO, I1URAB, I1URCD, I1URAT, I1URDT, I1URRF, I1USER, I1UPMJ, I1UPMT, I1JOBN, I1PID, I1CRTU FROM F54HS01M

TOP910 | 54HS | F54HS01M COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1I1HSINOIncident NumberNumericGeneric Edit80 Allow NULL? 
2I1HSIMNIncident Modification NumberNumericGeneric Edit60 Allow NULL? 
3I1HSIMTIncident Modification TypeCharacterUDC (54HS MT)10 Allow NULL? 
4I1MODDTModification DateDateGeneric Edit60
5I1HSIDNIncident DescriptionStringGeneric Edit1000 Allow NULL? 
6I1HSIDTIncident DateDateGeneric Edit110
7I1HSITMIncident TimeNumericGeneric Edit60 Allow NULL? 
8I1HSIDMIncident MonthStringUDC (06 MN)20 Allow NULL? 
9I1WKDDay of WeekCharacterUDC (08 WD)10 Allow NULL? 
10I1HSIDRIncident Date ReportedDateGeneric Edit110
11I1HSITRIncident Time ReportedNumericGeneric Edit60 Allow NULL? 
12I1HSISTIncident StatusStringUDC (54HS ST)20 Allow NULL? 
13I1HSISVIncident SeverityStringUDC (54HS SV)20 Allow NULL? 
14I1HSINOPParent Incident NumberNumericGeneric Edit80 Allow NULL? 
15I1HSINMPotential IncidentIntegerGeneric Edit110 Allow NULL? 
16I1HSIPEDProperty / Equipment DamageIntegerGeneric Edit110 Allow NULL? 
17I1HSIMVMotor Vehicle InvolvedIntegerGeneric Edit110 Allow NULL? 
18I1HSIINJInjury / IllnessIntegerGeneric Edit110 Allow NULL? 
19I1HSIENVEnvironmental ImpactIntegerGeneric Edit110 Allow NULL? 
20I1HSISECSecurityIntegerGeneric Edit110 Allow NULL? 
21I1HSISCSecurity ClassificationStringUDC (54HS SC)20 Allow NULL? 
22I1HSIOTOtherIntegerGeneric Edit110 Allow NULL? 
23I1HSIOCOther ClassificationStringUDC (54HS OC)20 Allow NULL? 
24I1HSIXSExclude From Safety StatisticsIntegerGeneric Edit110 Allow NULL? 
25I1HSIAAAuthorities AlertedIntegerGeneric Edit110 Allow NULL? 
26I1HSILNIncident LocationStringGeneric Edit2000 Allow NULL? 
27I1ESTBNumber - Establishment of Business ActivNumericGeneric Edit80 Allow NULL? 
28I1COCompanyStringGeneric Edit50 Allow NULL? 
29I1MCUSBusiness Unit - SubsequentStringGeneric Edit120 Allow NULL? 
30I1MCUBusiness UnitStringGeneric Edit120 Allow NULL? 
31I1CTRCountryStringUDC (00 CN)30 Allow NULL? 
32I1ADDSStateStringUDC (00 S)30 Allow NULL? 
33I1ADD1Address Line 1StringGeneric Edit400 Allow NULL? 
34I1ADD2Address Line 2StringGeneric Edit400 Allow NULL? 
35I1ADD3Address Line 3StringGeneric Edit400 Allow NULL? 
36I1ADD4Address Line 4StringGeneric Edit400 Allow NULL? 
37I1CTY1CityStringGeneric Edit250 Allow NULL? 
38I1ADDZPostal CodeStringGeneric Edit120 Allow NULL? 
39I1COUNCountyStringUDC (00 CT)250 Allow NULL? 
40I1LATTLatitudeStringGeneric Edit250 Allow NULL? 
41I1LONGLongitudeStringGeneric Edit250 Allow NULL? 
42I1REGIONGeographic Region CodeStringUDC (17 GR)30 Allow NULL? 
43I1DOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
44I1HSITECTotal Incident Estimated CostNumericGeneric Edit152 Allow NULL? 
45I1HSITACTotal Incident Actual CostNumericGeneric Edit152 Allow NULL? 
46I1CRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
47I1HSIDADrug and Alcohol TestIntegerGeneric Edit110 Allow NULL? 
48I1HSIDCDrug and Alcohol CommentStringGeneric Edit400 Allow NULL? 
49I1HSIDARDrug and Alcohol ResultStringUDC (54HS DR)20 Allow NULL? 
50I1HSICRContractor/3rd Party InvolvedIntegerGeneric Edit110 Allow NULL? 
51I1HSICRNContractor/3rd Party NumberNumericGeneric Edit80 Allow NULL? 
52I1HSICRNMContractor/3rd Party NameStringGeneric Edit400 Allow NULL? 
53I1HSIFRIncident FrequencyStringUDC (54HS FR)20 Allow NULL? 
54I1HSIPRPotential RecurrenceStringUDC (54HS PR)20 Allow NULL? 
55I1HSIPRCParty Responsible CodeStringUDC (54HS RS)20 Allow NULL? 
56I1HSIPRNParty Responsible NumberNumericGeneric Edit80 Allow NULL? 
57I1HSIPRNMParty Responsible NameStringGeneric Edit400 Allow NULL? 
58I1HSIDTCDetermined CauseStringGeneric Edit400 Allow NULL? 
59I1HSICSFIncident Causal FactorStringUDC (54HS FC)30 Allow NULL? 
60I1HSIINSInsurance Claim NumberStringGeneric Edit400 Allow NULL? 
61I1HSICISInsurance Claim StatusStringUDC (54HS IS)20 Allow NULL? 
62I1HSIEFEffect on Environment TextStringGeneric Edit2000 Allow NULL? 
63I1HSIRTRemediation TextStringGeneric Edit2000 Allow NULL? 
64I1HSICMTCorrective Measures TextStringGeneric Edit2000 Allow NULL? 
65I1HSINTOther TextStringGeneric Edit2000 Allow NULL? 
66I1HSIC01Incident Category Code 01StringUDC (54HS C1)30 Allow NULL? 
67I1HSIC02Incident Category Code 02StringUDC (54HS C2)30 Allow NULL? 
68I1HSIC03Incident Category Code 03StringUDC (54HS C3)30 Allow NULL? 
69I1HSIC04Incident Category Code 04StringUDC (54HS C4)30 Allow NULL? 
70I1HSIC05Incident Category Code 05StringUDC (54HS C5)30 Allow NULL? 
71I1HSIC06Incident Category Code 06StringUDC (54HS C6)30 Allow NULL? 
72I1HSIC07Incident Category Code 07StringUDC (54HS C7)30 Allow NULL? 
73I1HSIC08Incident Category Code 08StringUDC (54HS C8)30 Allow NULL? 
74I1HSIC09Incident Category Code 09StringUDC (54HS C9)30 Allow NULL? 
75I1HSIC10Incident Category Code 10StringUDC (54HS C0)30 Allow NULL? 
76I1HSIOROriginator AddressNumericGeneric Edit80 Allow NULL? 
77I1HSIRBReported By AddressNumericGeneric Edit80 Allow NULL? 
78I1HSIHRIncident Handler AddressNumericGeneric Edit80 Allow NULL? 
79I1HSIIBInvestigated By AddressNumericGeneric Edit80 Allow NULL? 
80I1KBCOFailure Analysis CodeStringGeneric Edit150 Allow NULL? 
81I1URABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
82I1URCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
83I1URATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
84I1URDTUser Reserved DateDateGeneric Edit60
85I1URRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
86I1USERUser IDStringGeneric Edit100 Allow NULL? 
87I1UPMJDate - UpdatedDateGeneric Edit60
88I1UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
89I1JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
90I1PIDProgram IDStringGeneric Edit100 Allow NULL? 
91I1CRTUCreated by userStringGeneric Edit100 Allow NULL? 

TOP910 | 54HS | F54HS01M INDEXES

NumberDescription
1IncidentNo Modification (Primary/Unique)
ElementAliasDescriptionSequence
1HSINOIncident NumberAscending
2HSIMNIncident Modification NumberAscending