EXS_TAX_RATE

(SQL Table)
 Index Back

Tax Rate

  • Related Language Record: EXS_TAX_RAT_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 EXS_TAX_RATE_CD Character(10) VARCHAR2(10) NOT NULL Tax Rate Code
    3 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    4 EXS_TAX_TYPE Character(1) VARCHAR2(1) NOT NULL Tax Type
    C=Custom Duty
    E=Excise Duty
    G=Goods and Services Tax
    S=Sales Tax / VAT
    5 EXS_USE_AV_FLG Character(1) VARCHAR2(1) NOT NULL Use Assessable Flag

    Y/N Table Edit

    Default Value: N

    6 EXS_SERV_TAX_FLG Character(1) VARCHAR2(1) NOT NULL Service Tax Indicator
    N=Not Service Tax
    Y=Service Tax

    Y/N Table Edit

    Default Value: N

    7 STX_TAX_AUTH_CD Character(8) VARCHAR2(8) NOT NULL Tax Authority Code

    Prompt Table: %RECNAME_EDIT3

    8 STX_FORM_CD Character(8) VARCHAR2(8) NOT NULL Form Code

    Prompt Table: STX_FORM_CD_VW

    9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR

    10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

    Prompt Table: VNDR_LOC_AP_VW

    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURR_CD_EFF_VW