VAT_DEFAULT_HDR

(SQL Table)
 Index Back

VAT Default Header

VAT Default Header

  • Parent Record Of VAT_DEFAULTS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VAT_DRIVER Character(15) VARCHAR2(15) NOT NULL VAT Driver

    Prompt Table: VAT_DRIVER

    2 VAT_DRIVER_KEY1 Character(30) VARCHAR2(30) NOT NULL VAT Driver Key1

    Prompt Table: %EDITTABLE2

    3 VAT_DRIVER_KEY2 Character(30) VARCHAR2(30) NOT NULL VAT Driver Key2

    Prompt Table: %EDITTABLE3

    4 VAT_DRIVER_KEY3 Character(30) VARCHAR2(30) NOT NULL VAT Driver Key3

    Prompt Table: %EDITTABLE4

    5 VAT_DRIVER_KEY4 Character(30) VARCHAR2(30) NOT NULL VAT Driver Key4

    Prompt Table: %EDITTABLE5

    6 VAT_DRIVER_KEY5 Character(30) VARCHAR2(30) NOT NULL VAT Driver Key5

    Prompt Table: %EDITTABLE6

    7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_VAT_TBL

    8 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: VAT_STATE_VW2

    9 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    11 VAT_SETID Character(5) VARCHAR2(5) NOT NULL VAT SetID

    Prompt Table: SETID_TBL

    12 END_EFFDT Date(10) DATE Ending effective date established to be used by queries to improve effective-date processing performance.