VAT_USE_TBL

(SQL Table)
 Index Back

VAT Use Table

  • Related Language Record: VAT_USE_TBL_LNG

    • # 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: SP_SETID_NONVW

    2 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 VAT_RCVRY_SRC Character(1) VARCHAR2(1) NOT NULL VAT Recovery Source
    M=Mixed Apportionment
    U=Use Type

    Default Value: M

    8 VAT_RCVRY_ACT_PCT Number(6,2) DECIMAL(5,2) NOT NULL VAT Taxable Activity Percent
    9 VAT_REBATE_ACT_PCT Number(6,2) DECIMAL(5,2) NOT NULL VAT Exempt Activity Percent
    10 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
    11 VAT_PSB_TYPE_CD Character(4) VARCHAR2(4) NOT NULL VAT Public Service Body Type
    CHRT=Charitable Organizations
    HOSP=Hospital Authorities
    MNCP=Municipalities
    NPOR=Non-Profit Organizations
    PBCL=Public Colleges
    SCHL=School Authorities
    UNIV=Universities
    12 VAT_ADMISSION_PCT Number(6,2) DECIMAL(5,2) NOT NULL Coefficient of Admission
    13 VAT_ADMPCT_DESCR Character(30) VARCHAR2(30) NOT NULL VAT Admission Description
    14 VAT_CONPCT_DESCR Character(30) VARCHAR2(30) NOT NULL VAT Constraint Description
    15 VAT_CONSTRAINT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Coefficient of Constraint
    16 VAT_TAXPCT_DESCR Character(30) VARCHAR2(30) NOT NULL VAT Taxation Description
    17 VAT_TAXATION_PCT Number(6,2) DECIMAL(5,2) NOT NULL Coefficient of Taxation
    18 USE_COEFFICIENT Character(1) VARCHAR2(1) NOT NULL Status flg to enable recovory coefficients
    N=No
    Y=Yes

    Default Value: N