VAT_DEFAULT_VW

(SQL View)
 Index Back

VAT Default VW


SELECT DISTINCT A.VAT_DRIVER , A.VAT_DRIVER_KEY1 , A.VAT_DRIVER_KEY2 , A.VAT_DRIVER_KEY3 , A.VAT_DRIVER_KEY4 , A.VAT_DRIVER_KEY5 , A.COUNTRY , A.STATE FROM PS_VAT_DEFAULTS A , PS_VAT_FIELDS B WHERE A.FIELDNAME = B.FIELDNAME AND B.VAT_DEFAULT_USAGE IN ('C','H')

  • Parent Record Of VAT_DFLT_EFF_VW

    • # 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: %EDT_VAT_1

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

    Prompt Table: %EDT_VAT_2