CPE_TERM

CPE Term | #transactional | Component: Basic Functions
Column Name Description
CLIENT Client
DOCITEMCOND_GUID CPE Caller - GUID of Document Item Condition
TERMNO CPE Term - Number in Formula
Column Name Description
💲 CPE Term - Currency (TERMCURR):
TERMVAL CPE Term - Value
TERMRATE CPE Term - Rate in Term Currency
💲 Quotation Currency (QUOTCURR):
QUOTATION CPE Term - Calculated Quotation
💲 CPE Term - Currency of Absolute Surcharge (SURCHRATECURR):
SURCHARGERATE CPE Term - Total Surcharge for Commodity
💲 CPE - Currency for Fixed Rate (FIXTERMCURR):
FIXTERMRATE CPE Term - Fixed Rate
💲 CPE Term - Currency of Rate Calculation Limits (CALCMMCURR):
CALCMIN CPE Term - Minimum of Commodity Rate Calculation
CALCMAX CPE Term - Maximum of Commodity Rate Calculation
💲 CPE Term - Currency of Absolute Surcharge (SURCHARGECURR):
SURCHARGEABS CPE Term - Absolute Surcharge for Commodity
Column Name Description
📏 CPE Term - Unit of Measure of Total Commodity Quantity (TERMCOMMUOM):
TERMCOMMQUAN CPE Term - Total Commodity Quantity for Calculating Term
📏 CPE Term - UoM for Calculated Commodity Quantity (USEDUOM):
USEDQUAN CPE Term - Calculated Commodity Quantity
📏 CPE Quantity UoM for Price Fixation (QUANTITY_REF_UOM):
QUANTITY_REF CPE Quantity for Price Fixation
📏 CPE Price Fixation Limit Quantity UoM (LIMIT_QUANTITY_UOM):
LIMIT_QUANTITY CPE Price Fixation Limit Quantity
📏 CPE Quantity UoM for Price Fixation (NON_FIXED_QTY_UOM):
NON_FIXED_QUANTITY CPE Quantity for Price Fixation
📏 CPE Price Fixation Limit Quantity UoM (LIMIT_QUANTITY_UOM_OUT):
LIMIT_QUANTITY_OUT CPE Price Fixation Limit Quantity
📏 CPE Tiered Pricing UOM of Quantity Range (UOM):
QTY_TO Quantity Up To
Column Name Description
CURVE_DATE Curve Date
KEYDATE Maturity Key Date
EXPIRATIONDATE Commodity Derivative Order Request Expiration Date
DATEFROM_Q Quotation Start Date for Fixed Period
TIMEFROM_Q CPE Term - Start Time for Fixed Period for Quotation
DATETO_Q Quotation End Date for Fixed Period
TIMETO_Q CPE Term - End Time for Quotation Fixed Period
DATEFROM_C Exchange Start Date for Fixed Period
TIMEFROM_C CPE Term - Start Time for Fixed Period for Currency
DATETO_C Exchange End Date for Fixed Period
TIMETO_C CPE Term - End Time for Currency Fixed Period
REFDATE_Q CPE Term - Calculated Quotation Reference Date
REFDATE_C CPE Term - Calculated Currency Reference Date
EXER_DATE_EARLIEST CPE Price Fixation - Earliest Exercise Date
EXER_DATE_LATEST CPE Price Fixation - Latest Exercise Date
DATE_FROM CPE Tiered Pricing: Date From
DATE_TO Date Up To
Column Name Description
FORECAST_STATUS Status of Quotation or Exchange Rate Forecast Show values
CALC_LIMITUSED CPE Term - Used Limit of Calculation Rule Show values
EXTENSION_USAGE CPE Extension Usage Show values
FORMRES_REL Relevance for Formula Result Show values
DCS_TYPE Derivative Category Show values
REFDOCCAT CPE Term - Reference Document Category Show values
QUOTKEY Quotation Key Type in Document UI (all values) Show values
DCS_SELECTION_TYPE Maturity Selection Type Show values
TIMING Timing/Periodicity of Commodity Forward Indexes Show values
DCS_PERIOD_TYPE Period Type Show values
PSM_SIMULATION_ERROR Pricing Setting Has Error Show values
EXPRTNINSTRUCTION Commodity Derivative Order Request Expiry Instruction Show values
EXCL_BASEDATE_Q CPE Term - Exclude Base Date for Quotation Show values
EXCL_BASEDATE_C CPE Term - Exclude Base Date for Currency Show values
PRC_FIXATION_STATUS Status of Price Fixation Option Show values
EXER_DATE_EARLIEST_PRELIM_IND CPE Provisional Earliest Exercise Date Show values
EXER_DATE_LATEST_PRELIM_IND CPE Provisional Latest Exercise Date Show values
Column Name Description Domain name
DOCITEM_GUID CPE Caller - GUID of Document Item SYSUUID
COND_TYPE CPE: Condition Type for Commodity Pricing KSCHL
TERMID CPE Term - Key CPE_TERMID
TERMGROUP CPE Term - Term Group CHAR1
PROVIS CPE Term - Term Is Used only for Provisional Pricing CHAR1
PROVTERMNO CPE Term - Number of the Corresponding Provisional Term NUMC5
FACTOR1 CPE Term - Factor 1 CPE_FACTOR
FACTOR2 CPE Term - Factor 2 CPE_FACTOR
PERCENTAGE CPE Term - Percentage CPE_FACTOR
TERMTYPE CPE Term - Term Calculation Type CPE_ROUTINE
TERMRULE CPE Term - Term Rule CPE_RULE
FORMINPUT_GUID CPE Formula - GUID of Changed Input for General Data SYSUUID
TERMINPUT_GUID CPE Term - GUID of Changed General Input SYSUUID
TERMCONVIN_GUID CPE Term - GUID for Conversion Input SYSUUID
TERMROUNDIN_GUID CPE Term - GUID of Rounding Input SYSUUID
TERMCONVOUT_GUID CPE Term - GUID for Conversion Result SYSUUID
PERDTIN_GUID_Q CPE Term - GUID for Changed Input of Per Det. for Quotation SYSUUID
PERDTIN_GUID_C CPE Term - GUID for Changed Input of Per Det. for Currency SYSUUID
PERDTOUT_GUID_Q CPE Term - GUID for Result of Per. Determin. for Quotation SYSUUID
PERDTOUT_GUID_C CPE Term - GUID for Result of Per. Determin. for Currency SYSUUID
REF_GUID_PRCFIX Reference GUID for Price Fixation SYSUUID
REF_GUID_TIER Reference GUID for Tier SYSUUID
TERMSTATUS CPE Term - Status CPE_TERMSTATUS
BILLING_BLOCK CPE Caller - Billing: Blocking Reason for Document Items CPE_BILLING_BLOCK
TERMPRUN CPE Term - Price Unit CPE_PRUN
FORECAST_DATETIME Evaluation Key Date Used CPE_TIMESTAMP
TERMRATE_DF34 CPE - Used for internal calculation (rounding, conversion) CPE_INTERNAL_VALUE
TERMVAL_DF34 CPE Term - Value DF34 CPE_INTERNAL_VALUE
QUOTATION_DF34 Price Quotation (up to 14 decimals) CPE_INTERNAL_VALUE
QUOTPRUN Price Unit of Quotation CPE_PRUN
QUOT_UOMSUBST CPE Term - Unit of Measure Substitution for Quotations CHAR1
SURCHARGERATE_DF34 CPE Term - Total Surcharge for Commodity DF34 CPE_INTERNAL_VALUE
SURCHRATEPRUN CPE Term - Price Unit of Absolute Surcharge CPE_PRUN
SURCH_UOMSUBST CPE Term - Unit of Measure Substitution for Surcharge CHAR1
EXTENSION_GROUP CPE Extension Group CPE_EXTENSION_GROUP
IS_BASIS_ID_MANUAL Condition of Basis ID is manually selected CHAR1
BASIS_ID Basis ID TBAC_BASIS_ID
FUT_KSCHL CPE: Condition Type for Commodity Pricing KSCHL
FUT_TERMNO CPE Term - Number in Formula NUMC5
FLAT_GRP_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
REFDOC CPE Term - Reference Document Number CPE_DOCUMENT
REFITEM CPE Term - Reference Document Item Number CPE_DOCITEM
REFGUID CPE Term - GUID of Reference Document Item SYSUUID
REFCOND CPE Term - Reference Condition Type KSCHL
FIXTERMPRUN CPE - Price Unit of Fixed Rate CPE_PRUN
USERVAL1 CPE Term - Freely Usable Field CPE_USERVAL1
DCSID Derivative Contract Specification ID TBA_DCSID
MIC Market Identifier Code TBA_MIC
TENOR Time to Maturity TBA_TENOR
PRICETYPE Type of Price Quotation VVSKURSART
FORECAST_ROUTINE Quotation Forecast Routine CPE_ROUTINE
CURVE_TYPE Commodity Curve Type TBA_CTY_CURVE_TYPE
CURVE_DCSID Alternative Derivative Contract Specification ID TBA_DCSID
CURVE_MIC Alternative Market Identifier Code TBA_MIC
KEYDATE_REFDATE_ROUT Reference Date Routine for Maturity Selection CPE_ROUTINE
KEYDATE_SELECTION_ROUT Maturity Selection Routine CPE_ROUTINE
KEYDATE_OFFSET_ROUT CPE Term - Date Offset Routine for Period Determination CPE_ROUTINE
KEYDATE_OFFSET_UNITS CPE Term - Number of Time Units for Date Offset Routine DEC3
BASIS_TYPE Basis Type TBAC_BASIS_TYPE
QUOTGROUP Quotation Group CPE_RULE
QUOTATIONRULE CPE Quotation Rule CPE_RULE
CALCRULE CPE Term - Calculation Rule CPE_RULE
SURCHARGERULE CPE Term - Surcharge Rule CPE_RULE
PERDETRULE_Q CPE Term - Period Determination Rule for Commodity Rates CPE_RULE
PERDETRULE_C CPE Term - Period Determ. Rule for Currency Exchange Rates CPE_RULE
PRICEFIXRULE CPE Term - Rule for Definition of Price Fixation Option CPE_RULE
CALCROUT CPE Term - Calculation Routine CPE_ROUTINE
CALCMMPRUN CPE Term - Price Unit of Rate Calculation Limits CPE_PRUN
SURCHARGEROUT CPE Term - Surcharge Routine CPE_ROUTINE
SURCHARGEABS_DF34 CPE Term - Absolute Surcharge for Commodity in DF34 CPE_INTERNAL_VALUE
SURCHARGEPRUN CPE Term - Price Unit of Absolute Surcharge CPE_PRUN
SURCHARGEFACTOR1 CPE Term - Factor 1 when Combining Surcharge and Quotation CPE_FACTOR
SURCHARGEFACTOR2 CPE Term - Factor 2 when Combining Surcharge and Quotation CPE_FACTOR
TERMTEXT Term Description TEXT40
FORECAST_DATE_ROUTINE Latest Evaluation Key Date Routine CPE_ROUTINE
CALCMIN_DF34 CPE Term - Minimum of Commodity Rate Calc (up to 14 dec) CPE_INTERNAL_VALUE
CALCMAX_DF34 CPE Term - Maximum of Commodity Rate Calc (up to 14 dec) CPE_INTERNAL_VALUE
FIXTERMRATE_DF34 CPE Term - Fixed Rate (up to 14 decimals) CPE_INTERNAL_VALUE
RATE_CREATED_AT CPE - Date and Time Created CPE_TIMESTAMP
RATE_CREATED_BY Name of User who Created the Object USNAM
RATE_CHANGED_AT CPE: Date and Time Changed CPE_TIMESTAMP
RATE_CHANGED_BY Name of user who changed the object USNAM
PSMGUID PSM GUID SYSUUID_22
PSMETHOD Price Setting Method CPE_PSMETHOD
PSMSTATUS Price Setting Method Status CPE_PSMSTATUS
COMMODITYSUBACCOUNT Commodity Subaccount ID CMMFSA_SUBACCOUNTID
NUMBER_OF_LOTS Number of Lots CPET_NUMBER_OF_LOTS
FILLPACKETUUID Commodity Derivative Order Fill Packet UUID /BOBF/CONF_KEY
PRCGEXECINSTRN Commodity Order Request Pricing and Execution Instruction CMMFDOR_ORDERPRICINGEXECINST
LMTPRC Commodity Derivative Order Request Limit Price CPE_INTERNAL_VALUE
STOPPRICE Commodity Derivative Order Request Stop Price CPE_INTERNAL_VALUE
STOPLMTPRC Commodity Derivative Order Request Stop Limit Price CPE_INTERNAL_VALUE
FXDPRC Commodity Derivative Order Request Requested Price CPE_INTERNAL_VALUE
LEEWAYPRC Commodity Derivative Order Request Requested Price CPE_INTERNAL_VALUE
LEEWAYRNGEPRC Commodity Derivative Order Request Leeway Price CPE_INTERNAL_VALUE
LMTSPREADPRC Commodity Derivative Order Request Limit Spread Value CPE_INTERNAL_VALUE
FXDSPREADPRC Commodity Derivative Order Request Requested Spread Price CPE_INTERNAL_VALUE
TICKS Commodity Order Request Ticks CMMFDOR_ORDREQTICKS
CMMDTYORDREQCNTRPTYBROKER Counterparty Broker CMMFSA_COUNTERPARTY_BROKER
CMMDTYORDREQCNTRPTYREFACCT Reference Account CMMFSA_REFERENCEBROKERACCOUNT
SAVETERMRATE_DF34 CPE Term - Fixed Rate (up to 14 decimals) CPE_INTERNAL_VALUE
PERIODDETROUT_Q CPE Term- Period Determination Routine for Quotations CPE_ROUTINE
SOURCEROUT_Q CPE Term - Source Routine for Price Quotation CPE_ROUTINE
REFDATEROUT_Q Reference Date and Time Routine on CPE Term Level for Quot. CPE_ROUTINE
DATEOFFSETROUT_Q CPE Term - Date Offset Routine for Period Determination Quot CPE_ROUTINE
OFFSETUNITS_Q CPE Term - Number of Time Units for Date Offset Routine Quot DEC3
TIMEUOMROUT_Q CPE Term - Time UoM Routine for Quotation CPE_ROUTINE
TIMEUNITSBEF_Q CPE Term - Time Units Before Calculated Base Date Quotation DEC3
TIMEUNITSAFT_Q CPE Term - Time Units After Calculated Base Date Quotation DEC3
DATELISTROUT_Q CPE Term - Date List Routine for Quot. Period Determination CPE_ROUTINE
PERDETCALID_Q CPE Term - Calendar Used for Quotation Period Determination WFCID
MISSENTRYROUT_Q CPE Term - Routine for Missing Entry Used for Quot. Prd. Det CPE_ROUTINE
CLOSEDDAYSROUT_Q CPE Term - Routine for Closed Market Days for Quotation CPE_ROUTINE
MAXWEIGHTING_Q CPE Term - Maximum Weighting of a Element During Quot. Avg. DEC2
PERIODDETROUT_C CPE Term- Period Determination Routine for Currency CPE_ROUTINE
SOURCEROUT_C CPE Term - Source Routine for Currency Exchange Rates CPE_ROUTINE
REFDATEROUT_C Reference Date and Time Routine on CPE Term Level for Curr. CPE_ROUTINE
DATEOFFSETROUT_C CPE Term - Date Offset Routine for Period Determination Curr CPE_ROUTINE
OFFSETUNITS_C CPE Term - Number of Time Units for Date Offset Routine Curr DEC3
TIMEUOMROUT_C CPE Term - Time UoM Routine for Currency CPE_ROUTINE
TIMEUNITSBEF_C CPE Term - Time Units Before Calculated Base Date Currency DEC3
TIMEUNITSAFT_C CPE Term - Time Units After Calculated Base Date Currency DEC3
DATELISTROUT_C CPE Term - Date List Routine for Curr. Period Determination CPE_ROUTINE
PERDETCALID_C CPE Term - Calendar Used for Quotation Period Determination WFCID
MISSENTRYROUT_C CPE Term - Routine for Missing Entry Used for Curr. Prd. Det CPE_ROUTINE
CLOSEDDAYSROUT_C CPE Term - Routine for Closed Market Days for Currency CPE_ROUTINE
MAXWEIGHTING_C CPE Term - Maximum Weighting of a Element During Curr. Avg. DEC2
INCOMPLETE_Q CPE Term - Period Determination Incomplete Quotation CHAR1
PERIODSTATUS_Q CPE Term - Status of Quotation Period Determination CPE_PERIOD_STATUS
FIRSTTIMESTAMP_Q CPE Term - First Date and Time QuotaitonPeriod Determined CPE_TIMESTAMP
LASTTIMESTAMP_Q CPE Term - End Date and Time of Quotation Period Determined CPE_TIMESTAMP
LASTFOUNDDATE_Q CPE Term - Date and Time of Last Quotation Entry Found CPE_TIMESTAMP
BASEDATE_Q CPE Term - Calculated Quotation Base Date and Time CPE_TIMESTAMP
REFTIMESTAMP_Q CPE Term - Calculated Quotation Reference Date and Time CPE_TIMESTAMP
INCOMPLETE_C CPE Term - Period Determination Incomplete Currency CHAR1
PERIODSTATUS_C CPE Term - Status of Currency Period Determination CPE_PERIOD_STATUS
FIRSTTIMESTAMP_C CPE Term - First Date and Time CurrencyPeriod Determined CPE_TIMESTAMP
LASTTIMESTAMP_C CPE Term - End Date and Time of Currency Period Determined CPE_TIMESTAMP
LASTFOUNDDATE_C CPE Term - Date and Time of Last Currency Entry Found CPE_TIMESTAMP
BASEDATE_C CPE Term - Calculated Currency Base Date and Time CPE_TIMESTAMP
REFTIMESTAMP_C CPE Term - Calculated Currency Reference Date and Time CPE_TIMESTAMP
EXER_DATE_EARLY_ROUT Earliest Price Fixation Exercise Date Routine CPE_ROUTINE
EXER_DATE_EARLIEST_REF_DATE_RT Reference Date and Time Routine on CPE Term Level CPE_ROUTINE
EXER_DATE_LATEST_ROUT Latest Price Fixation Exercise Date Routine CPE_ROUTINE
EXER_DATE_LATEST_REF_DATE_RT Reference Date and Time Routine on CPE Term Level CPE_ROUTINE
QUANTITY_DISTR_ROUT CPE Quantity Distribution Routine for Price Fixation CPE_ROUTINE
LIMIT_ROUT CPE Price Fixation Limit Routine CPE_ROUTINE
LIMIT_FACTOR_1 CPE Price Fixation Limit Factor 1 CPE_FACTOR_POSITIVE
LIMIT_FACTOR_2 CPE Price Fixation Limit Factor 2 CPE_FACTOR_POSITIVE
PRICE_REF_ROUT CPE Reference Price Routine for Non-Fixed Quantity CPE_ROUTINE
TIER_REF_DATE_ROUT Reference Date and Time Routine on CPE Term Level CPE_ROUTINE
OPTION_COMMENT CPE Price Fixation Comment (packed)
OPTION_COMMENT_SHORT CPE Price Fixation Comment TEXT256
TIERNO CPE Tiered Pricing - Tier Number NUMC5