EXS_TAX_CMPNT

(SQL Table)
 Index Back

Tax Component Codes

  • Related Language Record: EXS_TAX_CMP_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_CMPNT_CD Character(10) VARCHAR2(10) NOT NULL Tax Component Code
    3 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    5 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

    Default Value: E

    6 EXD_REG_COL_SEQ Character(1) VARCHAR2(1) NOT NULL Register Column Sequence
    1=Column1
    2=Column2
    3=Column3
    4=Column4
    5=Column5
    6=Column6
    7 EXS_CALC_SCHEME Character(1) VARCHAR2(1) NOT NULL Calculation Scheme
    A=Amount
    P=Percentage
    Q=Quantity

    Default Value: P

    8 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement

    Prompt Table: CM_LC_COMPNT_VW