VIEW: XTR.XTR_IRS_ACTUALS#

Source

View Text - Preformatted

select ACTUAL_FIXED ACTUAL_FIXED, AMOUNT_UNIT AMOUNT_UNIT, COMPANY_CODE COMPANY_CODE, COMPANY_NAME COMPANY_NAME, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, CURRENCY CURRENCY, DAY_ADJUST DAY_ADJUST, FLOATING_LESS FLOATING_LESS, FROM_DATE FROM_DATE, FUND_INVEST FUND_INVEST, INC_IG INC_IG, MAX_AMT MAX_AMT, MAX_WAMT MAX_WAMT, MIN_AMT MIN_AMT, MIN_WAMT MIN_WAMT, PFA_AMT PFA_AMT, PFA_DAYS PFA_DAYS, PFW_AMT PFW_AMT, PF_AMT PF_AMT, PF_COVER PF_COVER, PF_DAYS PF_DAYS, POLICY_MAX POLICY_MAX, POLICY_MIN POLICY_MIN, PORTFOLIO_CODE PORTFOLIO_CODE, PORT_NAME PORT_NAME, PTA_AMT PTA_AMT, PTA_DAYS PTA_DAYS, PTW_AMT PTW_AMT, PT_AMT PT_AMT, PT_COVER PT_COVER, PT_DAYS PT_DAYS, PXA_AMT PXA_AMT, PXA_DAYS PXA_DAYS, PXW_AMT PXW_AMT, PX_AMT PX_AMT, PX_COVER PX_COVER, PX_DAYS PX_DAYS, SA_AMT SA_AMT, SA_DAYS SA_DAYS, SF_AMT SF_AMT, STW_AMT STW_AMT, ST_AMT ST_AMT, ST_DAYS ST_DAYS, SX_AMT SX_AMT, S_COVER S_COVER, TO_DATE TO_DATE, UNIQUE_REF_NUMBER UNIQUE_REF_NUMBER, VARIANCE_MAX VARIANCE_MAX, VARIANCE_MIN VARIANCE_MIN from "XTR"."XTR_IRS_ACTUALS"

View Text - HTML Formatted

SELECT ACTUAL_FIXED ACTUAL_FIXED
, AMOUNT_UNIT AMOUNT_UNIT
, COMPANY_CODE COMPANY_CODE
, COMPANY_NAME COMPANY_NAME
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, CURRENCY CURRENCY
, DAY_ADJUST DAY_ADJUST
, FLOATING_LESS FLOATING_LESS
, FROM_DATE FROM_DATE
, FUND_INVEST FUND_INVEST
, INC_IG INC_IG
, MAX_AMT MAX_AMT
, MAX_WAMT MAX_WAMT
, MIN_AMT MIN_AMT
, MIN_WAMT MIN_WAMT
, PFA_AMT PFA_AMT
, PFA_DAYS PFA_DAYS
, PFW_AMT PFW_AMT
, PF_AMT PF_AMT
, PF_COVER PF_COVER
, PF_DAYS PF_DAYS
, POLICY_MAX POLICY_MAX
, POLICY_MIN POLICY_MIN
, PORTFOLIO_CODE PORTFOLIO_CODE
, PORT_NAME PORT_NAME
, PTA_AMT PTA_AMT
, PTA_DAYS PTA_DAYS
, PTW_AMT PTW_AMT
, PT_AMT PT_AMT
, PT_COVER PT_COVER
, PT_DAYS PT_DAYS
, PXA_AMT PXA_AMT
, PXA_DAYS PXA_DAYS
, PXW_AMT PXW_AMT
, PX_AMT PX_AMT
, PX_COVER PX_COVER
, PX_DAYS PX_DAYS
, SA_AMT SA_AMT
, SA_DAYS SA_DAYS
, SF_AMT SF_AMT
, STW_AMT STW_AMT
, ST_AMT ST_AMT
, ST_DAYS ST_DAYS
, SX_AMT SX_AMT
, S_COVER S_COVER
, TO_DATE TO_DATE
, UNIQUE_REF_NUMBER UNIQUE_REF_NUMBER
, VARIANCE_MAX VARIANCE_MAX
, VARIANCE_MIN VARIANCE_MIN
FROM "XTR"."XTR_IRS_ACTUALS"