TAX_HEADER_TBL

(SQL Table)
 Index Back

Tax Code Header Information

Tax Code Header Information

  • Related Language Record: TAXHEADTBL_LANG

  • Parent Record Of TAX_CD VAT_ACCT_TBL VAT_BU_HDR_TBL VAT_DST_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: SP_SETID_NONVW

    2 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

    Prompt Table: TAX_HEADER_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 TAX_VAT_FLG Character(1) VARCHAR2(1) NOT NULL Include VAT
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    6 TAX_FRGHT_FLG Character(1) VARCHAR2(1) NOT NULL Include Freight

    Y/N Table Edit

    Default Value: N

    7 TAX_DSCNT_FLG Character(1) VARCHAR2(1) NOT NULL Include Discount

    Y/N Table Edit

    Default Value: N

    8 TAX_MISC_FLG Character(1) VARCHAR2(1) NOT NULL Include Misc Charges

    Y/N Table Edit

    Default Value: N

    9 DESCRLONG Long Character CLOB Long Description
    10 TAX_CD_TYPE Character(1) VARCHAR2(1) NOT NULL Tax Code Type
    S=Sales Tax
    V=VAT

    Default Value: S

    11 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line