OI_VT_ACTYP_VW

(SQL View)
 Index Back

Account Type

OTBI Account Type View

SELECT A.VAT_DST_ACCT_TYPE , A.DESCR DESCR , A.DESCRSHORT , A.VAT_PRCHS_FLG , A.VAT_SALES_FLG , A.VAT_EXPENSES_FLG , A.VAT_GL_FLG , A.VAT_ACCT_FLG , A.VAT_TXN_TBL_FLG , A.VAT_GL_ACCT_FLG , A11X.DESCR XLATLONGNAME , A.VAT_DST_TYPE_AUTH , B.DESCR DESCR1 , A.VAT_AM_FLG , A15X.DESCR DESCR30 , A.VAT_TR_FLG FROM (%Table(VAT_DST_TYPE) A LEFT OUTER JOIN %Table(VAT_DST_TYPE) B ON A.VAT_DST_TYPE_AUTH = B.VAT_DST_ACCT_TYPE ) LEFT OUTER JOIN PS_OI_COMMON_VW A11X ON A11X.CODESETNAME = A.VAT_ENTRY_TYPE_FLG AND A11X.CODESETGROUPNAME='VAT_ENTRY_TYPE_FLG' LEFT OUTER JOIN PS_OI_COMMON_VW A15X ON A15X.CODESETNAME = A.VAT_ACCTG_ENT_GRP AND A15X.CODESETGROUPNAME='VAT_ACCTG_ENT_GRP' UNION SELECT ' ' , 'Not Available' , 'NA' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' FROM %Table(INSTALLATION) C

# 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.
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
5 VAT_SALES_FLG Character(1) VARCHAR2(1) NOT NULL Used for Sales
6 VAT_EXPENSES_FLG Character(1) VARCHAR2(1) NOT NULL Used for Expenses
7 VAT_GL_FLG Character(1) VARCHAR2(1) NOT NULL Used for GL
8 VAT_ACCT_FLG Character(1) VARCHAR2(1) NOT NULL Used for Accounting
9 VAT_TXN_TBL_FLG Character(1) VARCHAR2(1) NOT NULL Used in VAT Transaction Table
10 VAT_GL_ACCT_FLG Character(1) VARCHAR2(1) NOT NULL General Ledger VAT Account
11 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
12 VAT_DST_TYPE_AUTH Character(4) VARCHAR2(4) NOT NULL VAT Distrib Type Group
13 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
14 VAT_AM_FLG Character(1) VARCHAR2(1) NOT NULL Used for Assets
15 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
16 VAT_TR_FLG Character(1) VARCHAR2(1) NOT NULL Used for Treasury