PC_GNT

(SQL Table)
Index Back

Investment Incentve Descr

Used to provide a detailed description about an investment incentive.

  • Related Language Record: PC_GNT_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID

    Prompt Table: PC_GNT

    2 INCENTIVE_TYPE Character(3) VARCHAR2(3) NOT NULL Investment Incentive Type
    DEP=Depreciation Method
    GNT=Grant
    REB=Rebate
    TAX=Tax Abatement

    Default Value: GNT

    3 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority

    Prompt Table: PC_TAX_AUTH_VW

    4 DATE_TYPE Character(1) VARCHAR2(1) NOT NULL From and To Date Type
    A=Accounting Date
    J=Journal Date
    P=Posted Date
    T=Transaction Date

    Default Value: A

    5 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
    6 END_DATE Date(10) DATE NOT NULL End Date
    7 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

    Prompt Table: PC_ANTYPE_VW

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    10 AUTHORIZATION_PCT Number(6,2) DECIMAL(5,2) NOT NULL Authorization Percentage
    11 AUTHORIZATION_MAX Number(27,3) DECIMAL(26,3) NOT NULL Authorization Amount
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    13 TAXABLE_CD Character(1) VARCHAR2(1) NOT NULL Taxable or Non-Taxable

    Y/N Table Edit

    14 MIN_IN_PERIOD Number(3,0) SMALLINT NOT NULL Minimum number of periods.
    15 REFUND_TYPE Character(1) VARCHAR2(1) NOT NULL Refund Type
    N=None
    P=Pro-rata
    T=Total

    Default Value: N

    16 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    17 PREPARE_BTN Character(1) VARCHAR2(1) NOT NULL Prepare Report

    Default Value: F

    18 MSTONE_SEQ Number(3,0) SMALLINT NOT NULL Milestone Sequence
    19 ISSUED_FLG Character(1) VARCHAR2(1) NOT NULL Refund Issued

    Y/N Table Edit

    Default Value: N

    20 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

    Prompt Table: %EDITTABLE