CPEC_PERIODDET

CPE Term - Period Determination Rule | #masterdata | Component: Commodity Pricing Engine
Column Name Description
CLIENT Client
LOGSYS FK Logical system
PERIODDETRULE CPE Term - Period Determination Rule
VALIDTO CPE - 'Valid From' Time Stamp of Commodity Pricing Object
Column Name Description
Column Name Description
Column Name Description
DATEFROM CPE Term - Start Date for Fixed Period
TIMEFROM CPE Term - Start Time for Fixed Period
DATETO CPE Term - End Date for Fixed Period
TIMETO CPE Term - End Time for Fixed Period
Column Name Description
EXCL_BASEDATE CPE Term - Exclude Base Date Show values
Column Name Description Domain name
OFFSETUNITS CPE Term - Number of Time Units for Date Offset Routine DEC3
TIMEUNITSBEF CPE Term - Time Units Before Calculated Base Date DEC3
TIMEUNITSAFT CPE Term - Time Units After Calculated Base Date DEC3
MAXWEIGHTING CPE Term - Maximum Weighting of a Element During Averaging DEC2
Master Data Relations Join Conditions
CPE Term - Routine for Closed Market Days
  • ?
  • ?
  • CPE Term - Routine for Closed Market Days
  • ?
  • CPEC_PERIODDET.CLIENT == CPEC_ROUTINE.CLIENT
  • CPEC_PERIODDET.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE
  • CPEC_PERIODDET.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE
  • CPEC_PERIODDET.CLOSEDDAYSROUT == CPEC_ROUTINE.CPE_ROUTINE
  • CPEC_PERIODDET.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS
CPE Term - Date List Routine for Period Determination
  • ?
  • ?
  • CPE Term - Date List Routine for Period Determination
  • ?
  • CPEC_PERIODDET.CLIENT == CPEC_ROUTINE.CLIENT
  • CPEC_PERIODDET.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE
  • CPEC_PERIODDET.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE
  • CPEC_PERIODDET.DATELISTROUT == CPEC_ROUTINE.CPE_ROUTINE
  • CPEC_PERIODDET.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS
CPE Term - Date Offset Routine for Period Determination
  • ?
  • ?
  • CPE Term - Date Offset Routine for Period Determination
  • ?
  • CPEC_PERIODDET.CLIENT == CPEC_ROUTINE.CLIENT
  • CPEC_PERIODDET.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE
  • CPEC_PERIODDET.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE
  • CPEC_PERIODDET.DATEOFFSETROUT == CPEC_ROUTINE.CPE_ROUTINE
  • CPEC_PERIODDET.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS
Logical system CPEC_PERIODDET.LOGSYS == TBDLS.LOGSYS
CPE Term - Routine for Missing Entry Used for Period Determ.
  • ?
  • ?
  • CPE Term - Routine for Missing Entry Used for Period Determ.
  • ?
  • CPEC_PERIODDET.CLIENT == CPEC_ROUTINE.CLIENT
  • CPEC_PERIODDET.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE
  • CPEC_PERIODDET.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE
  • CPEC_PERIODDET.MISSENTRYROUT == CPEC_ROUTINE.CPE_ROUTINE
  • CPEC_PERIODDET.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS
CPE Term - Calendar Used for Period Determination CPEC_PERIODDET.PERDETCALID == TFACD.IDENT
CPE Term- Period Determination Routine for Commodity Pricing
  • ?
  • ?
  • CPE Term- Period Determination Routine for Commodity Pricing
  • ?
  • CPEC_PERIODDET.CLIENT == CPEC_ROUTINE.CLIENT
  • CPEC_PERIODDET.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE
  • CPEC_PERIODDET.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE
  • CPEC_PERIODDET.PERIODDETROUT == CPEC_ROUTINE.CPE_ROUTINE
  • CPEC_PERIODDET.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS
Reference Date and Time Routine on CPE Term Level
  • ?
  • Client
  • ?
  • Reference Date and Time Routine on CPE Term Level
CPE Term - Source Routine for Price Quot. or Curr. Ex. Rates
  • ?
  • ?
  • CPE Term - Source Routine for Price Quot. or Curr. Ex. Rates
  • ?
  • CPEC_PERIODDET.CLIENT == CPEC_ROUTINE.CLIENT
  • CPEC_PERIODDET.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE
  • CPEC_PERIODDET.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE
  • CPEC_PERIODDET.SOURCEROUT == CPEC_ROUTINE.CPE_ROUTINE
  • CPEC_PERIODDET.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS
CPE Term - Time UoM Routine
  • ?
  • ?
  • CPE Term - Time UoM Routine
  • ?
  • CPEC_PERIODDET.CLIENT == CPEC_ROUTINE.CLIENT
  • CPEC_PERIODDET.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE
  • CPEC_PERIODDET.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE
  • CPEC_PERIODDET.TIMEUOMROUT == CPEC_ROUTINE.CPE_ROUTINE
  • CPEC_PERIODDET.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS