I_NominationTicketDetail

Nomination Ticket Detail | view: INOMTICKETDET | TRAN | Extraction: Not supported | Component: Downstream
Tables used: OIJNOMH, OIJNOMI, OIJPEG, OIJ_EL_TKT_I_O2, OIJ_EL_TICKET_H, OIJ_EL_TICKET_I, OIJNMTC1, TOIJ_EL_MVSCEN, ADRC, OIFSPBL, OIJTS
Column Name Description
NominationDoc FK Nomination (technical) Key
NominationDocItem Nomination Key Item
Column Name Description
Column Name Description
📏 Scheduled UoM (ScheduledQuantityUnit):
ScheduledQuantity Scheduled qty
📏 Base Unit of Measure (NominationTicketActualQtyUoM):
NominationTicketActualQuantity Scheduled qty
NominationInProcessQuantity null
📏 Actual posted quantity Unit of Measure (ActualScheduledQuantityUnit):
ActualScheduledQuantity Actual posted quantity
Column Name Description
NominationScheduleDate Scheduled date
NominationTicketLoadStartDate null
NominationTicketLoadStartTime null
NominationTicketLoadEndDate null
NominationTicketLoadEndTime null
TicketCreationDate Date on which the record was created
TicketCreationTime Time of creation
Column Name Description
NominationIsClosed IS OIL TSW: Indicator close nomination Show values
NominationItemIsComplete Nomination item complete flag Show values
NominationTicketPurpose OIL-TSW: Ticket Purpose Show values
NominationLastTicketStatus OIL-TSW: Ticket process return code Show values
NominationDocIsBlocked Flag to Set Nomination Selectable Show values
Column Name Description Domain name
NominationPegID Pegging identifier OIJ_PEGID
NominationExtNumber Nomination number OIJ_NOMNR
NominationOriginLocation null
NominationDestinationLocation null
NominationInspector Inspector OIJ_PARTNR
NominationTicketLoadStrtDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
NominationTicketLoadEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
NominationTicketStatus null
OilMovementScenario TSW: Movement scenario number NUM02
NominationHasTicket null
NominationTicketItem OIL-TSW: Ticket item number OIJ_EL_TKT_POSNR
NominationTicketVersion OIL-TSW: Ticket version OIJ_EL_TKT_VERSION
LocationIDDesc null
NominationOriginLocationDesc null
NominationDestLocationDesc null
NominationModeOfTransportDesc null
NominationScheduleTypeDesc null
TransportSystemDesc null
VehicleIdDesc null
NominationTicketActlQtyUoMDesc null
ScheduledQuantityUnitDesc null
NominationInProcessUoMDesc null
ActualSchedldQuantityUnitDesc null
Master Data Relations Join Conditions
Actual posted quantity Unit of Measure
  • Client
  • Actual posted quantity Unit of Measure
  • I_NOMINATIONTICKETDETAIL.MANDT == T006.MANDT
  • I_NOMINATIONTICKETDETAIL.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI
TD shipment type
  • Client
  • TD shipment type
  • I_NOMINATIONTICKETDETAIL.MANDT == TOIGS.CLIENT
  • I_NOMINATIONTICKETDETAIL.BULKSHIPMENTTYPE == TOIGS.SHTYP
Location ID
  • Client
  • Location ID
  • I_NOMINATIONTICKETDETAIL.MANDT == OIJLOC.MANDT
  • I_NOMINATIONTICKETDETAIL.LOCATIONID == OIJLOC.LOCID
Mode of Transport
  • Client
  • Mode of Transport
  • I_NOMINATIONTICKETDETAIL.MANDT == TVTR.MANDT
  • I_NOMINATIONTICKETDETAIL.NOMINATIONMODEOFTRANSPORT == TVTR.VKTRA
Schedule type
  • Client
  • Schedule type
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_NOMINATIONTICKETDETAIL.MANDT == T006.MANDT
  • I_NOMINATIONTICKETDETAIL.NOMINATIONTICKETACTUALQTYUOM == T006.MSEHI
Location Partner Plant
  • Client
  • Location Partner Plant
  • I_NOMINATIONTICKETDETAIL.MANDT == T001W.MANDT
  • I_NOMINATIONTICKETDETAIL.OILLOCATIONPARTNERPLANT == T001W.WERKS
Location Partner Storage Location
  • Client
  • Location Partner Plant
  • Location Partner Storage Location
  • I_NOMINATIONTICKETDETAIL.MANDT == T001L.MANDT
  • I_NOMINATIONTICKETDETAIL.OILLOCATIONPARTNERPLANT == T001L.WERKS
  • I_NOMINATIONTICKETDETAIL.OILLOCATIONPARTNERSTORAGELOC == T001L.LGORT
Scheduled material
  • Client
  • Scheduled material
  • I_NOMINATIONTICKETDETAIL.MANDT == MARA.MANDT
  • I_NOMINATIONTICKETDETAIL.SCHEDULEDMATERIAL == MARA.MATNR
Scheduled UoM
  • Client
  • Scheduled UoM
  • I_NOMINATIONTICKETDETAIL.MANDT == T006.MANDT
  • I_NOMINATIONTICKETDETAIL.SCHEDULEDQUANTITYUNIT == T006.MSEHI
Address time zone
  • Client
  • Address time zone
  • I_NOMINATIONTICKETDETAIL.MANDT == TTZZ.CLIENT
  • I_NOMINATIONTICKETDETAIL.TIMEZONEID == TTZZ.TZONE
TD Vehicle Number
  • Client
  • TD Vehicle Number
  • I_NOMINATIONTICKETDETAIL.MANDT == OIGV.CLIENT
  • I_NOMINATIONTICKETDETAIL.VEHICLEID == OIGV.VEHICLE