I_NominationTicketInfo

Nomination Ticket Information | view: INOMTKTINFO | TRAN | Extraction: Not supported | Component: Downstream
Tables used: OIJNOMH, OIJNOMI, OIJ_EL_TICKET_H, OIJ_EL_TICKET_I, OIJ_EL_ERROR_LOG
Column Name Description
NominationTicketKey FK OIL-TSW: Ticket key
NominationTicketItem OIL-TSW: Ticket item number
NominationTicketPurpose OIL-TSW: Ticket Purpose Show values
NominationTicketVersion OIL-TSW: Ticket version
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
ScheduledQuantity Scheduled qty
📏 Stop meter calculation UOM (StopMeterUnitOfMeasure):
StopMeterCalculationQuantity Stop meter calculation Quantity
OpenDipReading Open dip reading
CloseDipReading Close Dip reading
CalculatedGaugeQuantity Calculated Gauge Quantity
Column Name Description
TicketDocumentPostingDate Posting Date in the Document
TicketCreationDate Date on which the record was created
TicketCreationTime Time of creation
TicketChangedDate Last Changed On
NominationEventDate OIL-TSW: Event date
Column Name Description
NominationTicketPurpose OIL-TSW: Ticket Purpose Show values
TicketMessageType Message Type Show values
NominationItemStatus Nomination Item status Show values
NominationItemSubStatus Nomination Item sub-status Show values
NominationTicketStatus OIL-TSW: Ticket process return code Show values
QuantityIsMarked Boolean Variable (X = True, - = False, Space = Unknown) Show values
MeterIsMarked Boolean Variable (X = True, - = False, Space = Unknown) Show values
GaugeIsMarked Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
NominationExtNumber Nomination number OIJ_NOMNR
LocationName Location name (used by system owner) OIJ_LOCNAM
LatestTicketStatus null
TicketStatusColorCode null
QuantityStartDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
QuantityEndDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
QuantityPostingDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
GeneralMeterNumber GMM: Number of general meter OII_GMMNR
MeterOpenQuantity Character Field of Length 12 CHAR12
EndCounterMeterReading GMM: End counter reading OII_MCOUNT
OpenMeterDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CloseMeterDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
TankSequenceNumber Sequence number of tank assigned to a business location OII_SEQNR
StorageObjectSegmentNumber SOC: Storage object characteristic segment number OII_SOCNR
OpenTankDipDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CloseTankDipDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
GaugeTimeZone Character field of length 6 CHAR6
TicketCreatedByUser Name of Person Responsible for Creating the Object USNAM
TicketChangedByUser Name of Person Who Changed Object USNAM
TypeOfMovement null
TicketNumber External Ticket Number CHAR10
TicketExternalNumber OIL-TSW: External ticket number OIJ_TKTNR
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_NOMINATIONTICKETINFO.BASEUNIT == T006.MSEHI
  • I_NOMINATIONTICKETINFO.MANDT == T006.MANDT
TD shipment type
  • TD shipment type
  • Client
  • I_NOMINATIONTICKETINFO.BULKSHIPMENTTYPE == TOIGS.SHTYP
  • I_NOMINATIONTICKETINFO.MANDT == TOIGS.CLIENT
Demand material
  • Demand material
  • Client
  • I_NOMINATIONTICKETINFO.DEMANDMATERIAL == MARA.MATNR
  • I_NOMINATIONTICKETINFO.MANDT == MARA.MANDT
Plant
  • Plant
  • Client
  • I_NOMINATIONTICKETINFO.DESTINATIONPLANT == T001W.WERKS
  • I_NOMINATIONTICKETINFO.MANDT == T001W.MANDT
Storage location
  • Plant
  • Storage location
  • Client
  • I_NOMINATIONTICKETINFO.DESTINATIONPLANT == T001L.WERKS
  • I_NOMINATIONTICKETINFO.DESTINATIONSTORAGELOCATION == T001L.LGORT
  • I_NOMINATIONTICKETINFO.MANDT == T001L.MANDT
Location ID
  • Location ID
  • Client
  • I_NOMINATIONTICKETINFO.LOCATIONID == OIJLOC.LOCID
  • I_NOMINATIONTICKETINFO.MANDT == OIJLOC.MANDT
Schedule type
  • Schedule type
  • Client
OIL-TSW: Ticket type
  • OIL-TSW: Ticket type
  • Client
Nomination type
  • Client
  • Nomination type
  • I_NOMINATIONTICKETINFO.MANDT == TOIJNOMTYP.MANDT
  • I_NOMINATIONTICKETINFO.NOMINATIONTYPE == TOIJNOMTYP.NOMTYP
Plant
  • Plant
  • Client
  • I_NOMINATIONTICKETINFO.ORIGINPLANT == T001W.WERKS
  • I_NOMINATIONTICKETINFO.MANDT == T001W.MANDT
Storage location
  • Plant
  • Storage location
  • Client
  • I_NOMINATIONTICKETINFO.ORIGINPLANT == T001L.WERKS
  • I_NOMINATIONTICKETINFO.ORIGINSTORAGELOCATION == T001L.LGORT
  • I_NOMINATIONTICKETINFO.MANDT == T001L.MANDT
Material Number
  • Material Number
  • Client
  • I_NOMINATIONTICKETINFO.SCHEDULEDMATERIAL == MARA.MATNR
  • I_NOMINATIONTICKETINFO.MANDT == MARA.MANDT
TD Vehicle Number
  • TD Vehicle Number
  • Client
  • I_NOMINATIONTICKETINFO.VEHICLEID == OIGV.VEHICLE
  • I_NOMINATIONTICKETINFO.MANDT == OIGV.CLIENT