ACT_BAL_DTL_VW

(SQL View)
 Index Back

Account Bal Attribute Detail


SELECT %subrec(ACT_BAL_DTL_VW,A) FROM PS_ACT_BAL_GRP_DTL A , PS_ACT_BAL_GRP B WHERE A.ACT_BAL_GRP = B.ACT_BAL_GRP AND B.EFF_STATUS = 'A'

  • Parent record: ACT_BAL_GRP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACT_BAL_GRP Character(10) VARCHAR2(10) NOT NULL Account Balancing Group
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: ACCT_ATTRIB_TBL

    3 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Field Value

    Prompt Table: %EDITTABLE2