DEPR_LIM_YR_TBL

(SQL Table)
Index Back

Depreciation Yearly Limits

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SETID_TBL

    2 DEPR_LIMIT_CD Character(10) VARCHAR2(10) NOT NULL Depreciation Limit Code
    3 LIFE_YEAR Number(3,0) SMALLINT NOT NULL Year of Life
    4 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    5 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: CURR_CD_AM_VW.CURRENCY_CD