KK_FS_CFPROJ_VW

(SQL View)
 Index Back

Active non-affiliate LedGrp CF

Active, non-affiliate Ledger Group ChartFields. This is used by ledgers that won't support Affiliate like Commitment Control Ledgers. This view contains Project related chartfield and is used in FS Activity Log Inquiry as prompt table.

SELECT DISTINCT A.SETID , A.CHARTFIELD , B.LONGNAME , P.PROMPT_TBL2 FROM PS_LED_GRP_FLD_TBL A , PSDBFLDLABL_VW B , PSDBFIELD F , PS_LED_GRP_TBL T , PS_FS_FLD_PROMPT P WHERE A.CHARTFIELD = B.FIELDNAME AND A.CHARTFIELD<>'CURRENCY_CD' AND A.CHARTFIELD<>'BUSINESS_UNIT' AND A.CHARTFIELD<>'STATISTICS_CODE' AND A.CHARTFIELD<>'BUDGET_PERIOD' AND B.FIELDNAME = F.FIELDNAME AND F.FLDNOTUSED = 0 AND A.CHARTFIELD NOT IN ( SELECT X.FIELDNAME FROM PS_FS_CF_TEMPLATE X WHERE X.CF_TYPE = 'A') AND A.SETID = T.SETID AND A.LEDGER_GROUP = T.LEDGER_GROUP AND T.LEDGER_GROUP_TYPE IN ('E', 'R') AND A.CHARTFIELD = P.FIELDNAME

  • Related Language Record: KK_FS_CFLANG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
    3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    4 PROMPT_TBL2 Character(15) VARCHAR2(15) NOT NULL Prompt Table 2

    Prompt Table: RECDEFN_VW