BALANCE_ID_TBL

(SQL Table)
 Index Back

Balance ID Table

Defines balance ID's to track balances in calendar or fiscal year. Setid added as high level key for release 7.0.

  • Related Language Record: BALANCE_ID_LANG

  • Parent Record Of BALANCES_LNG_VW BALANCES_VW BALANCE_ID_DEF BALANCE_ID_QTR BAL_ID_DEF_LANG BAL_ID_QTR_LANG

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

    Prompt Table: SETID_TBL

    2 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 NUMBER_OF_PERIODS Number(3,0) SMALLINT NOT NULL Periods in a Year

    Default Value: 12

    6 NUMBER_OF_QTRS Number(3,0) SMALLINT NOT NULL Quarters in a Year

    Default Value: 4

    7 BAL_FOR_CAL_YEAR Character(1) VARCHAR2(1) NOT NULL Bal for Calendar Year

    Y/N Table Edit

    Default Value: N

    8 MAINTAIN_EARN_BAL Character(1) VARCHAR2(1) NOT NULL Maintain Earns Bal

    Y/N Table Edit

    Default Value: Y

    9 MAINTAIN_DED_BAL Character(1) VARCHAR2(1) NOT NULL Maintain Dedn Bal

    Y/N Table Edit

    Default Value: Y

    10 MAINTAIN_TAX_BAL Character(1) VARCHAR2(1) NOT NULL Maintain Tax Bal

    Y/N Table Edit

    Default Value: Y

    11 MAINTAIN_CHK_BAL Character(1) VARCHAR2(1) NOT NULL Maintain Check Bal

    Y/N Table Edit

    Default Value: Y

    12 MAINTAIN_GARN_BAL Character(1) VARCHAR2(1) NOT NULL Maintain Garn Bal

    Y/N Table Edit

    Default Value: Y

    13 DATE_TO_USE Character(1) VARCHAR2(1) NOT NULL Date to Use
    C=Check Date
    P=Period End Date

    Default Value: C