VAT_DST_VAT_VW

(SQL View)
 Index Back

Account Types for VAT

All VAT DST types set to VAT_TXN_TBL_FLG = 'Y' will be part of this view; then this view is used for VAT Reports Definition.

SELECT VAT_DST_ACCT_TYPE , DESCR , DESCRSHORT , VAT_PRCHS_FLG , VAT_SALES_FLG , VAT_EXPENSES_FLG , VAT_GL_FLG , VAT_ACCT_FLG , VAT_TXN_TBL_FLG FROM PS_VAT_DST_TYPE WHERE vat_txn_tbl_flg = 'Y'

  • Related Language Record: VAT_DST_TY_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VAT_DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.

    Prompt Table: VAT_DST_TYPE_VW

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 VAT_PRCHS_FLG Character(1) VARCHAR2(1) NOT NULL Used for Purchases

    Y/N Table Edit

    Default Value: N

    5 VAT_SALES_FLG Character(1) VARCHAR2(1) NOT NULL Used for Sales

    Y/N Table Edit

    Default Value: N

    6 VAT_EXPENSES_FLG Character(1) VARCHAR2(1) NOT NULL Used for Expenses

    Y/N Table Edit

    Default Value: N

    7 VAT_GL_FLG Character(1) VARCHAR2(1) NOT NULL Used for GL

    Y/N Table Edit

    Default Value: N

    8 VAT_ACCT_FLG Character(1) VARCHAR2(1) NOT NULL Used for Accounting

    Y/N Table Edit

    Default Value: Y

    9 VAT_TXN_TBL_FLG Character(1) VARCHAR2(1) NOT NULL Used in VAT Transaction Table

    Y/N Table Edit

    Default Value: N