TCORT_CODMD

Transparent Table Application Table
178 Fields 1 CDS Views

Deal: Main Data

TCORT_CODMD is an SAP database table in S/4HANA. Deal: Main Data. It contains 178 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TrmCorrespondence view left_outer BASIC TRM Correspondence Application Data

Fields (178)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY codmd_uuid FTR_CODMDID Deal's main data Id
companycode FTR_CO_BUKRS Company Code
deal_number FTI_POSRFHA Transaction
se_deal_number FTI_SE_RFHA Sec./Futures Trans.
side TB_RKONDGR Direction
reference_no KL_NR Reference
reference_type KL_TYP Reference Cat.
objectnumber J_OBJNR Object number
create_user TB_CRUSER Entered By
create_date TB_DCRDAT Entry Date
create_time TB_TCRTIM Entry Time
update_user TB_UPUSER Changed By
update_date TB_DUPDAT Changed On
update_time TB_TUPTIM Time Changed
contract_type RANTYP Contract Type
product_cat SANLF Prod. Category
product_type VVSART Product Type
transaction_cat TB_SFGTYP Transaction Cat
activity_cat TB_SFGZUTY Activity Cat.
transaction_type TB_SFHAART Transactn Type
start_term FTI_DBLFZ_DEAL Start of Term
end_term FTI_DELFZ_DEAL End of Term
rollover_term FTI_ROLLOVER_DEAL Rollover Date
start_inclusive FTI_SINCLBE End Inclusive
end_inclusive TB_SINCLE Term End Incl.
notice_date TB_NOTICE_DATE Notice Date
period_of_notice TB_AKUEND Notice Period
period_of_notice_unit TB_SKUEND Unit
limit_date TB_LIMITDA Limit Date
contract_date TB_DVTRAB Contract Date
contract_time TB_TVTRAB ContrConcTime
trader RDEALER Trader
counterparty TB_KONTRH Counterparty
contact_person TB_GSPPART Contact Person
guarantor TB_RGARANT_NEW Guarantor
external_refnce TB_NORDEXT External Ref.
portfolio RPORTB Portfolio
finance_project TB_TFPROJ Finance Project
master_agreement TB_RMAID Agreement
assignment TB_ZUOND Assignment
internal_refnce TB_REFER Internal Ref.
characteristics TB_MERKM Characteristics
valuation_class TPM_COM_VAL_CLASS Gen. Valn Class
facility_dealno TB_FACILITYNR Facility
facility_ccode TB_FACILITYBUKRS CoCd of Facility
deal_active TB_SAKTIV Active Status
release_status TB_FRGZUST Release Status
reversal_reason SSTOGRD Reversal Reason
confirm_status TB_CONF Confirmation
confirm_date TB_DCONF Confirm. Date
confirm_user TB_UCONF User
cntrconfirm TB_RECONF Counterconfirm.
cntrconfirm_date TB_DREDAT Counterc. Date
cntrconfirm_user TB_URENAM User
currency FTI_WGSCHFT Transaction Crcy
currency_rcv FTI_WGSCHF2 Crcy Incoming Side
currency_pay FTI_WGSCHF1 Crcy Outgoing Side
nom_amount FTI_NOMAMT Nominal Amount
nom_amount_rcv FTI_BGSCHF2 NominalAmt: Incoming
nom_amount_pay FTI_BGSCHF1 NominalAmt: Outgoing
units FTI_POSITIONS_UNITS_L Units
lead_currency FTI_LWAERS LeadCrcy
foll_currency FTI_FWAERS Flng Crcy
rate TB_KKURS Rate
spotrate TB_KKASSA Spot Rate
swaprate TB_KSWAP Swap Rate
security_account RLDEPO Securities Acct
security_id VVRANLW Security Class
position_account TPM_POS_ACCOUNT_FUT Futures Acct
commodity_id TRCO_COMM_ID Cmdty ID (obsolete)
quantity_traded FTI_CTY_QUAN_DELVRD Open Comm. Quantity
commodity_uom TPM_CTY_UOM Unit of Measure
contract_price FTI_CTY_PRICE Comm. Contract Price
cty_spot_price FTI_CTY_SPOT_PRC Cmdty Spot Prc.
cont_back FTR_CONBACK Comm Contg
eff_int TB_PYIELD Effect.Int.Rate
eff_int_method SEFFMETH Eff.Int. Method
int_cat FTI_INTTYPE Int.Cat
int_current FTI_NOMINALZINS Nominal Int. Rate
int_ref FTI_INTREF Ref. Int. Rate
int_formula FTI_XINTFORMULA Formula
int_status FTI_INTSTATUS Int.Status
int_next_fix FTI_NEXT_FIXDATE Fixing Date
int_next_due FTI_NEXT_DUEDATE Due Date
int_amount FTI_INTAMOUNT Int.Amount
int_currency TB_WZBETR Payment Currency
int_cat_in FTI_INTTYPE_IN Interest Category In
int_current_in FTI_NOMINALZINS_IN Nominal Int.Rate: In
int_ref_in FTI_INTREF_IN Ref.Int.Rate: In
int_formula_in FTI_XINTFORMULA_IN Formula: Incoming
int_status_in FTI_INTSTATUS_IN IntSts: In
int_next_fix_in FTI_NEXT_FIXDATE_IN Nxt Fix.In
int_next_due_in FTI_NEXT_DUEDATE Due Date
int_amount_in FTI_INTAMOUNT_IN Int.Amount: In
int_currency_in TB_WZBETR Payment Currency
int_cat_out FTI_INTTYPE_OUT Interest Cat. Out
int_current_out FTI_NOMINALZINS_OUT Nominal Int.Rate:Out
int_ref_out FTI_INTREF_OUT Ref.Int.Rate: Out
int_formula_out FTI_XINTFORMULA_OUT Formula: Outgoing
int_status_out FTI_INTSTATUS_OUT IntSts:Out
int_next_fix_out FTI_NEXT_FIXDATE_OUT Nxt Fix.Out
int_next_due_out FTI_NEXT_DUEDATE Due Date
int_amount_out FTI_INTAMOUNT_OUT Int.Amount: Out
int_currency_out TB_WZBETR Payment Currency
put_call FTI_SPUTCAL Put/Call
expiration_date FTI_DMATUR Expiration Date
expiration_location FTR_EXPIRY_LOCATION Expiry Location
expiration_time FTR_EXPIRY_TIME Expiry Time
strike_currency FTI_OFWAERS Strike Currency
strike_amount FTI_OSTRIKE Strike Amount
strike_price FTI_STRIKE_PRICE Strike Price
exercise_type SOPTAUS Exercise Type
settlement_type TI_SETTLFL Settlement
option_category TV_OPTTYP Option Category
dir_strikeamount FTI_OSSIGN Direction
barrier_category TI_SLEVELT Level Category
lead_curr_ul FTI_LWAERS_UL Lead. Crcy U/L
follow_curr_ul FTI_FWAERS_UL Flng Crcy UT
barrier TX_KWKURB1 Barrier
barrier2 TX_KWKURB2 Barrier 2
premium_amt_pyc FTI_PREMIUM_PYC Premium PaymtCrcy
premium_date FTI_PREMIUM_DATE Premium Pay.Date
position_ccy SBWHR Position Currency
local_ccy TB_SHWHR Local Currency
number_traded FTI_NUMBER_TRADED_L Traded No. of Units
nom_amt_traded FTI_NOMAMT_TRADED Traded Nominal Amt
nomorgamt_traded FTI_NOMORGAMT_TRADED Traded Orig. Nom.Amt
price_traded FTI_PRICE_TRADED_L Traded Pr. (QC or %)
price_ccyunt TB_RUNIT Currency Unit
price_ccyunt_prc FTI_QUOT_UNIT_PRCT QC Unit/ %
quotation TB_NOTTYPE Quotation Type
quotation_ccy FTI_QUOT_CCY Quotation Currency
fx_rate_to_lc TB_KHWKURS Local Crcy Rate
housebnk_in FTI_HBANK_IN HouseBk: In
housebnkacct_in FTI_HBACCT_IN HBAcc. Incoming
payer_payee_in FTI_PAYERPAYEE_IN Payer/Payee:Incoming
partnerbnk_in FTI_PBANK_IN Partner Bank: In
housebnk_out FTI_HBANK_OUT HouseBk: Out
housebnkacct_out FTI_HBACCT_OUT HBAcc. Outgoing
payer_payee_out FTI_PAYERPAYEE_OUT Payer/Payee:Outgoing
partnerbnk_out FTI_PBANK_OUT Partner Bank: Out
quotation_name FTI_QUOTNAME Quotation Name
quotation_source TCR_CTY_QUOTSRC Quot Source
quotation_type TCR_CTY_QUOTTYPE Quotation Type
spread FTR_COMSPREAD Spread
commodity_id1 FTI_COMM_ID_OUT CommID out
quantity_in FTI_QUAN_IN Quantity In
uom_in FTI_UOM_IN Unit of Measure In
cty_price_in FTI_CTY_PRICE_IN Price In
quot_name_in FTI_QUOTNAME_IN Quot. Name In
quot_sourc_in FTI_QUOTSOURCE_IN Quot Source In
quot_type_in FTI_QUOTTYPE_IN Quotation Type In
cty_spread_in FTI_SPREAD_IN Spread Incoming
commodity_id2 FTI_COMM_ID_IN CommID in
quantity_out FTI_QUAN_OUT Quantity Out
uom_out FTI_UOM_OUT Unit of Measure Out
cty_price_out FTI_CTY_PRICE_OUT Price Out
quot_name_out FTI_QUOTNAME_OUT Quot. Name Out
quot_sourc_out FTI_QUOTSOURCE_OUT Quot Source Out
quot_type_out FTI_QUOTTYPE_OUT Quotation Type Out
cty_spread_out FTI_SPREAD_OUT Spread Outgoing
commodity_id_ul FTI_CTY_ID_UL Commodity ID UL
quantity_ul FTI_QUAN_UL Underlying Quantity
uom_ul FTI_UOM_UL Underlying UOM
div_pctc_otc TB_DIV_PCTC_OTC Div. Percentage
fixing_date TB_DFIX Fixing Date
fixing_ref_id FTR_FIXING_REF_ID Fixing Ref. ID
legal_basis FTR_THRESHOLD_SCHEME Legal Basis
trade_id FTR_TARO_TRADE_ID External Trade ID
pre_trade_id FTR_TARO_PRE_TRADE_ID Interim Trade ID
dcsid TBA_DCSID DCS ID
mic TBA_MIC MIC
price_type TBA_PRICETYPE Price Type
time_to_maturity TBA_TENOR Time to Maturity
timing TBA_TIMING Timing
avg_period_start CMM_AP_START Avg. Period Start
avg_period_end CMM_AP_END Avg. Period End

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Deal: Main Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCORT_CODMD (
    MANDT,                  -- Client [MANDT]
    CODMD_UUID,             -- Deal's main data Id [FTR_CODMDID]
    COMPANYCODE,            -- Company Code [FTR_CO_BUKRS]
    DEAL_NUMBER,            -- Transaction [FTI_POSRFHA]
    SE_DEAL_NUMBER,         -- Sec./Futures Trans. [FTI_SE_RFHA]
    SIDE,                   -- Direction [TB_RKONDGR]
    REFERENCE_NO,           -- Reference [KL_NR]
    REFERENCE_TYPE,         -- Reference Cat. [KL_TYP]
    OBJECTNUMBER,           -- Object number [J_OBJNR]
    CREATE_USER,            -- Entered By [TB_CRUSER]
    CREATE_DATE,            -- Entry Date [TB_DCRDAT]
    CREATE_TIME,            -- Entry Time [TB_TCRTIM]
    UPDATE_USER,            -- Changed By [TB_UPUSER]
    UPDATE_DATE,            -- Changed On [TB_DUPDAT]
    UPDATE_TIME,            -- Time Changed [TB_TUPTIM]
    CONTRACT_TYPE,          -- Contract Type [RANTYP]
    PRODUCT_CAT,            -- Prod. Category [SANLF]
    PRODUCT_TYPE,           -- Product Type [VVSART]
    TRANSACTION_CAT,        -- Transaction Cat [TB_SFGTYP]
    ACTIVITY_CAT,           -- Activity Cat. [TB_SFGZUTY]
    TRANSACTION_TYPE,       -- Transactn Type [TB_SFHAART]
    START_TERM,             -- Start of Term [FTI_DBLFZ_DEAL]
    END_TERM,               -- End of Term [FTI_DELFZ_DEAL]
    ROLLOVER_TERM,          -- Rollover Date [FTI_ROLLOVER_DEAL]
    START_INCLUSIVE,        -- End Inclusive [FTI_SINCLBE]
    END_INCLUSIVE,          -- Term End Incl. [TB_SINCLE]
    NOTICE_DATE,            -- Notice Date [TB_NOTICE_DATE]
    PERIOD_OF_NOTICE,       -- Notice Period [TB_AKUEND]
    PERIOD_OF_NOTICE_UNIT,  -- Unit [TB_SKUEND]
    LIMIT_DATE,             -- Limit Date [TB_LIMITDA]
    CONTRACT_DATE,          -- Contract Date [TB_DVTRAB]
    CONTRACT_TIME,          -- ContrConcTime [TB_TVTRAB]
    TRADER,                 -- Trader [RDEALER]
    COUNTERPARTY,           -- Counterparty [TB_KONTRH]
    CONTACT_PERSON,         -- Contact Person [TB_GSPPART]
    GUARANTOR,              -- Guarantor [TB_RGARANT_NEW]
    EXTERNAL_REFNCE,        -- External Ref. [TB_NORDEXT]
    PORTFOLIO,              -- Portfolio [RPORTB]
    FINANCE_PROJECT,        -- Finance Project [TB_TFPROJ]
    MASTER_AGREEMENT,       -- Agreement [TB_RMAID]
    ASSIGNMENT,             -- Assignment [TB_ZUOND]
    INTERNAL_REFNCE,        -- Internal Ref. [TB_REFER]
    CHARACTERISTICS,        -- Characteristics [TB_MERKM]
    VALUATION_CLASS,        -- Gen. Valn Class [TPM_COM_VAL_CLASS]
    FACILITY_DEALNO,        -- Facility [TB_FACILITYNR]
    FACILITY_CCODE,         -- CoCd of Facility [TB_FACILITYBUKRS]
    DEAL_ACTIVE,            -- Active Status [TB_SAKTIV]
    RELEASE_STATUS,         -- Release Status [TB_FRGZUST]
    REVERSAL_REASON,        -- Reversal Reason [SSTOGRD]
    CONFIRM_STATUS,         -- Confirmation [TB_CONF]
    CONFIRM_DATE,           -- Confirm. Date [TB_DCONF]
    CONFIRM_USER,           -- User [TB_UCONF]
    CNTRCONFIRM,            -- Counterconfirm. [TB_RECONF]
    CNTRCONFIRM_DATE,       -- Counterc. Date [TB_DREDAT]
    CNTRCONFIRM_USER,       -- User [TB_URENAM]
    CURRENCY,               -- Transaction Crcy [FTI_WGSCHFT]
    CURRENCY_RCV,           -- Crcy Incoming Side [FTI_WGSCHF2]
    CURRENCY_PAY,           -- Crcy Outgoing Side [FTI_WGSCHF1]
    NOM_AMOUNT,             -- Nominal Amount [FTI_NOMAMT]
    NOM_AMOUNT_RCV,         -- NominalAmt: Incoming [FTI_BGSCHF2]
    NOM_AMOUNT_PAY,         -- NominalAmt: Outgoing [FTI_BGSCHF1]
    UNITS,                  -- Units [FTI_POSITIONS_UNITS_L]
    LEAD_CURRENCY,          -- LeadCrcy [FTI_LWAERS]
    FOLL_CURRENCY,          -- Flng Crcy [FTI_FWAERS]
    RATE,                   -- Rate [TB_KKURS]
    SPOTRATE,               -- Spot Rate [TB_KKASSA]
    SWAPRATE,               -- Swap Rate [TB_KSWAP]
    SECURITY_ACCOUNT,       -- Securities Acct [RLDEPO]
    SECURITY_ID,            -- Security Class [VVRANLW]
    POSITION_ACCOUNT,       -- Futures Acct [TPM_POS_ACCOUNT_FUT]
    COMMODITY_ID,           -- Cmdty ID (obsolete) [TRCO_COMM_ID]
    QUANTITY_TRADED,        -- Open Comm. Quantity [FTI_CTY_QUAN_DELVRD]
    COMMODITY_UOM,          -- Unit of Measure [TPM_CTY_UOM]
    CONTRACT_PRICE,         -- Comm. Contract Price [FTI_CTY_PRICE]
    CTY_SPOT_PRICE,         -- Cmdty Spot Prc. [FTI_CTY_SPOT_PRC]
    CONT_BACK,              -- Comm Contg [FTR_CONBACK]
    EFF_INT,                -- Effect.Int.Rate [TB_PYIELD]
    EFF_INT_METHOD,         -- Eff.Int. Method [SEFFMETH]
    INT_CAT,                -- Int.Cat [FTI_INTTYPE]
    INT_CURRENT,            -- Nominal Int. Rate [FTI_NOMINALZINS]
    INT_REF,                -- Ref. Int. Rate [FTI_INTREF]
    INT_FORMULA,            -- Formula [FTI_XINTFORMULA]
    INT_STATUS,             -- Int.Status [FTI_INTSTATUS]
    INT_NEXT_FIX,           -- Fixing Date [FTI_NEXT_FIXDATE]
    INT_NEXT_DUE,           -- Due Date [FTI_NEXT_DUEDATE]
    INT_AMOUNT,             -- Int.Amount [FTI_INTAMOUNT]
    INT_CURRENCY,           -- Payment Currency [TB_WZBETR]
    INT_CAT_IN,             -- Interest Category In [FTI_INTTYPE_IN]
    INT_CURRENT_IN,         -- Nominal Int.Rate: In [FTI_NOMINALZINS_IN]
    INT_REF_IN,             -- Ref.Int.Rate: In [FTI_INTREF_IN]
    INT_FORMULA_IN,         -- Formula: Incoming [FTI_XINTFORMULA_IN]
    INT_STATUS_IN,          -- IntSts: In [FTI_INTSTATUS_IN]
    INT_NEXT_FIX_IN,        -- Nxt Fix.In [FTI_NEXT_FIXDATE_IN]
    INT_NEXT_DUE_IN,        -- Due Date [FTI_NEXT_DUEDATE]
    INT_AMOUNT_IN,          -- Int.Amount: In [FTI_INTAMOUNT_IN]
    INT_CURRENCY_IN,        -- Payment Currency [TB_WZBETR]
    INT_CAT_OUT,            -- Interest Cat. Out [FTI_INTTYPE_OUT]
    INT_CURRENT_OUT,        -- Nominal Int.Rate:Out [FTI_NOMINALZINS_OUT]
    INT_REF_OUT,            -- Ref.Int.Rate: Out [FTI_INTREF_OUT]
    INT_FORMULA_OUT,        -- Formula: Outgoing [FTI_XINTFORMULA_OUT]
    INT_STATUS_OUT,         -- IntSts:Out [FTI_INTSTATUS_OUT]
    INT_NEXT_FIX_OUT,       -- Nxt Fix.Out [FTI_NEXT_FIXDATE_OUT]
    INT_NEXT_DUE_OUT,       -- Due Date [FTI_NEXT_DUEDATE]
    INT_AMOUNT_OUT,         -- Int.Amount: Out [FTI_INTAMOUNT_OUT]
    INT_CURRENCY_OUT,       -- Payment Currency [TB_WZBETR]
    PUT_CALL,               -- Put/Call [FTI_SPUTCAL]
    EXPIRATION_DATE,        -- Expiration Date [FTI_DMATUR]
    EXPIRATION_LOCATION,    -- Expiry Location [FTR_EXPIRY_LOCATION]
    EXPIRATION_TIME,        -- Expiry Time [FTR_EXPIRY_TIME]
    STRIKE_CURRENCY,        -- Strike Currency [FTI_OFWAERS]
    STRIKE_AMOUNT,          -- Strike Amount [FTI_OSTRIKE]
    STRIKE_PRICE,           -- Strike Price [FTI_STRIKE_PRICE]
    EXERCISE_TYPE,          -- Exercise Type [SOPTAUS]
    SETTLEMENT_TYPE,        -- Settlement [TI_SETTLFL]
    OPTION_CATEGORY,        -- Option Category [TV_OPTTYP]
    DIR_STRIKEAMOUNT,       -- Direction [FTI_OSSIGN]
    BARRIER_CATEGORY,       -- Level Category [TI_SLEVELT]
    LEAD_CURR_UL,           -- Lead. Crcy U/L [FTI_LWAERS_UL]
    FOLLOW_CURR_UL,         -- Flng Crcy UT [FTI_FWAERS_UL]
    BARRIER,                -- Barrier [TX_KWKURB1]
    BARRIER2,               -- Barrier 2 [TX_KWKURB2]
    PREMIUM_AMT_PYC,        -- Premium PaymtCrcy [FTI_PREMIUM_PYC]
    PREMIUM_DATE,           -- Premium Pay.Date [FTI_PREMIUM_DATE]
    POSITION_CCY,           -- Position Currency [SBWHR]
    LOCAL_CCY,              -- Local Currency [TB_SHWHR]
    NUMBER_TRADED,          -- Traded No. of Units [FTI_NUMBER_TRADED_L]
    NOM_AMT_TRADED,         -- Traded Nominal Amt [FTI_NOMAMT_TRADED]
    NOMORGAMT_TRADED,       -- Traded Orig. Nom.Amt [FTI_NOMORGAMT_TRADED]
    PRICE_TRADED,           -- Traded Pr. (QC or %) [FTI_PRICE_TRADED_L]
    PRICE_CCYUNT,           -- Currency Unit [TB_RUNIT]
    PRICE_CCYUNT_PRC,       -- QC Unit/ % [FTI_QUOT_UNIT_PRCT]
    QUOTATION,              -- Quotation Type [TB_NOTTYPE]
    QUOTATION_CCY,          -- Quotation Currency [FTI_QUOT_CCY]
    FX_RATE_TO_LC,          -- Local Crcy Rate [TB_KHWKURS]
    HOUSEBNK_IN,            -- HouseBk: In [FTI_HBANK_IN]
    HOUSEBNKACCT_IN,        -- HBAcc. Incoming [FTI_HBACCT_IN]
    PAYER_PAYEE_IN,         -- Payer/Payee:Incoming [FTI_PAYERPAYEE_IN]
    PARTNERBNK_IN,          -- Partner Bank: In [FTI_PBANK_IN]
    HOUSEBNK_OUT,           -- HouseBk: Out [FTI_HBANK_OUT]
    HOUSEBNKACCT_OUT,       -- HBAcc. Outgoing [FTI_HBACCT_OUT]
    PAYER_PAYEE_OUT,        -- Payer/Payee:Outgoing [FTI_PAYERPAYEE_OUT]
    PARTNERBNK_OUT,         -- Partner Bank: Out [FTI_PBANK_OUT]
    QUOTATION_NAME,         -- Quotation Name [FTI_QUOTNAME]
    QUOTATION_SOURCE,       -- Quot Source [TCR_CTY_QUOTSRC]
    QUOTATION_TYPE,         -- Quotation Type [TCR_CTY_QUOTTYPE]
    SPREAD,                 -- Spread [FTR_COMSPREAD]
    COMMODITY_ID1,          -- CommID out [FTI_COMM_ID_OUT]
    QUANTITY_IN,            -- Quantity In [FTI_QUAN_IN]
    UOM_IN,                 -- Unit of Measure In [FTI_UOM_IN]
    CTY_PRICE_IN,           -- Price In [FTI_CTY_PRICE_IN]
    QUOT_NAME_IN,           -- Quot. Name In [FTI_QUOTNAME_IN]
    QUOT_SOURC_IN,          -- Quot Source In [FTI_QUOTSOURCE_IN]
    QUOT_TYPE_IN,           -- Quotation Type In [FTI_QUOTTYPE_IN]
    CTY_SPREAD_IN,          -- Spread Incoming [FTI_SPREAD_IN]
    COMMODITY_ID2,          -- CommID in [FTI_COMM_ID_IN]
    QUANTITY_OUT,           -- Quantity Out [FTI_QUAN_OUT]
    UOM_OUT,                -- Unit of Measure Out [FTI_UOM_OUT]
    CTY_PRICE_OUT,          -- Price Out [FTI_CTY_PRICE_OUT]
    QUOT_NAME_OUT,          -- Quot. Name Out [FTI_QUOTNAME_OUT]
    QUOT_SOURC_OUT,         -- Quot Source Out [FTI_QUOTSOURCE_OUT]
    QUOT_TYPE_OUT,          -- Quotation Type Out [FTI_QUOTTYPE_OUT]
    CTY_SPREAD_OUT,         -- Spread Outgoing [FTI_SPREAD_OUT]
    COMMODITY_ID_UL,        -- Commodity ID UL [FTI_CTY_ID_UL]
    QUANTITY_UL,            -- Underlying Quantity [FTI_QUAN_UL]
    UOM_UL,                 -- Underlying UOM [FTI_UOM_UL]
    DIV_PCTC_OTC,           -- Div. Percentage [TB_DIV_PCTC_OTC]
    FIXING_DATE,            -- Fixing Date [TB_DFIX]
    FIXING_REF_ID,          -- Fixing Ref. ID [FTR_FIXING_REF_ID]
    LEGAL_BASIS,            -- Legal Basis [FTR_THRESHOLD_SCHEME]
    TRADE_ID,               -- External Trade ID [FTR_TARO_TRADE_ID]
    PRE_TRADE_ID,           -- Interim Trade ID [FTR_TARO_PRE_TRADE_ID]
    DCSID,                  -- DCS ID [TBA_DCSID]
    MIC,                    -- MIC [TBA_MIC]
    PRICE_TYPE,             -- Price Type [TBA_PRICETYPE]
    TIME_TO_MATURITY,       -- Time to Maturity [TBA_TENOR]
    TIMING,                 -- Timing [TBA_TIMING]
    AVG_PERIOD_START,       -- Avg. Period Start [CMM_AP_START]
    AVG_PERIOD_END,         -- Avg. Period End [CMM_AP_END]
    PRIMARY KEY (MANDT, CODMD_UUID)
);

Learn More