SETIDVAT_TXN_TYPE_CDOI_VT_TXN_VW(SQL View) |
Index Back |
|---|---|
TransactionOTBI Transaction View |
| SELECT A.SETID , A.VAT_TXN_TYPE_CD , A.DESCR , A.DESCRSHORT , XLI1.DESCR DESCR1 , A.ACCTG_ENTRY_FLG , A.VAT_TXN_FLG , A.DISTRIB_LINE_NUM FROM %Table(VAT_TXN_CD) A LEFT OUTER JOIN PS_OI_COMMON_VW XLI1 ON XLI1.CODESETNAME = A.EC_SALES_LIST_TYPE AND XLI1.CODESETGROUPNAME ='EC_SALES_LIST_TYPE' UNION SELECT B.SETID , ' ' , '-' , '-' , '-' , '-' , '-' , 0 FROM %Table(SETID_TBL) B UNION SELECT ' ' , ' ' , '-' , '-' , '-' , '-' , '-' , 0 FROM %Table(INSTALLATION) C |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | VAT_TXN_TYPE_CD |
Character(4) | VARCHAR2(4) NOT NULL | Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales. |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 6 | ACCTG_ENTRY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Create Accounting Entries |
| 7 | VAT_TXN_FLG | Character(1) | VARCHAR2(1) NOT NULL | Create VAT Transaction |
| 8 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |