PC_INT_TMPLGLVW

(SQL View)
 Index Back

Integration Template GL


SELECT SETID , INTEGRATION_TMPL , BUSINESS_UNIT_GL , DESCR , CURRENCY_CD , PERCENTAGE_SHARE , DESCRLONG FROM PS_PC_INT_TMPL_GL WHERE PRIMARY_GL_BU = 'Y'

  • Related Language Record: PC_INT_TMPL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    2 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration

    Prompt Table: PC_INT_TMPL

    3 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT_GL

    Prompt Table: SP_BU_GL_NONVW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION_PC.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    6 PERCENTAGE_SHARE Number(6,2) DECIMAL(5,2) NOT NULL Percentage of the deal that is pledged to the collateral.

    Default Value: 100

    7 DESCRLONG Long Character CLOB Long Description