AGING_CAT_SF_VW

(SQL View)
 Index Back

Aging Category Table view


SELECT A.SETID ,A.AGING_SET ,A.EFFDT ,A.AGE_CATEGORY ,A.DESCR FROM PS_AGING_CAT_TBL A WHERE A.SUMMARY_CATEGORY <> 'F' AND A.SUMMARY_CATEGORY <> 'C' AND A.SUMMARY_CATEGORY <> 'D'

  • Related Language Record: AGING_CATSF_LNG

  • Parent record: AGING_TBL

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

    Prompt Table: SP_SETID_NONVW

    2 AGING_SET Character(5) VARCHAR2(5) NOT NULL Aging Set

    Default Value: BUS_UNIT_TBL_SF.AGING_SET

    Prompt Table: AGING_TBL

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 AGE_CATEGORY Character(2) VARCHAR2(2) NOT NULL Aging Category
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description