CA_RNW_CYCL_VW

(SQL View)
 Index Back

CA-Renewal Cycles

PSIRS-KK

SELECT RNW_PKG_ID , RNW_CYCLE_NBR , RNW_CYCLE_START_DT , RNW_CYCLE_END_DT , RNW_CYCLE_STATUS , PRODUCT_ID , CURRENCY_CD , RNW_GROSS_AMT , GROSS_AMT_REV FROM PS_CA_RNW_CYCLE

  • Parent record: CA_RNW_PKG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RNW_PKG_ID Character(10) VARCHAR2(10) NOT NULL PSIRS-KK
    2 RNW_CYCLE_NBR Number(6,0) INTEGER NOT NULL PSIRS-KK

    Default Value: 1

    3 RNW_CYCLE_START_DT Date(10) DATE NOT NULL PSIRS-KK
    4 RNW_CYCLE_END_DT Date(10) DATE NOT NULL PSIRS-KK
    5 RNW_CYCLE_STATUS Character(4) VARCHAR2(4) NOT NULL PSIRS-KK
    DON=Done
    PND=Pending
    RDY=Ready

    Default Value: PND

    6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    8 RNW_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL PSIRS-KK
    9 GROSS_AMT_REV Signed Number(28,3) DECIMAL(26,3) NOT NULL Revenue Amount