VAT_DFLT_EFF_VW

(SQL View)
 Index Back

VAT Default Effective Dated 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 , A.EFFDT , A.EFF_STATUS , C.VAT_SETID FROM PS_VAT_DEFAULTS A , PS_VAT_FIELDS B , PS_VAT_DEFAULT_HDR C WHERE A.FIELDNAME = B.FIELDNAME AND B.VAT_DEFAULT_USAGE IN ('C','H') AND %Join(COMMON_FIELDS, VAT_DEFAULTS A , VAT_DEFAULT_HDR C)

  • Parent record: VAT_DEFAULT_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: 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