OI_USETY_VW(SQL View) |
Index Back |
---|---|
VAT Use TypePrimary record for VAT Use Type |
SELECT VU.SETID , VU.VAT_USE_ID , VU.EFFDT , ED.EFF_END_DT , VU.EFF_STATUS , VU.DESCR , VU.DESCRSHORT , XLI1.DESCR VAT_RCVRY_SRC_DESC , VU.VAT_RCVRY_ACT_PCT , VU.VAT_REBATE_ACT_PCT , VU.DISTRIB_LINE_NUM , XLI2.DESCR VAT_PSB_TY_CD_DESC , VU.VAT_ADMISSION_PCT , VU.VAT_ADMPCT_DESCR , VU.VAT_CONPCT_DESCR , VU.VAT_CONSTRAINT_PCT , VU.VAT_TAXPCT_DESCR , VU.VAT_TAXATION_PCT , VU.USE_COEFFICIENT FROM PS_VAT_USE_TBL VU INNER JOIN %Table(OI_USETY_EFF_VW) ED ON VU.SETID = ED.SETID AND VU.VAT_USE_ID=ED.VAT_USE_ID AND VU.EFFDT =ED.EFF_ST_DT LEFT OUTER JOIN PS_OI_COMMON_VW XLI1 ON XLI1.CODESETNAME = VU.VAT_RCVRY_SRC AND XLI1.CODESETGROUPNAME='VAT_RCVRY_SRC' LEFT OUTER JOIN PS_OI_COMMON_VW XLI2 ON XLI2.CODESETNAME = VU.VAT_PSB_TYPE_CD AND XLI2.CODESETGROUPNAME='VAT_PSB_TYPE_CD' UNION SELECT SETID , ' ' , %DateIn('1900-01-01') , %DateIn('9999-12-31') , 'A' , 'Not Available' , '-' , '-' , 0 , 0 , 0 , '-' , 0 , '-' , '-' , 0 , '-' , 0 , '-' FROM PS_SETID_TBL UNION SELECT ' ' , ' ' , %DateIn('1900-01-01') , %DateIn('9999-12-31') , 'A' , 'Not Available' , '-' , '-' , 0 , 0 , 0 , '-' , 0 , '-' , '-' , 0 , '-' , 0 , '-' FROM PS_INSTALLATION |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | VAT_USE_ID | Character(6) | VARCHAR2(6) NOT NULL | VAT Use Type |
3 | EFF_ST_DT | Date(10) | DATE | Effective Start Date |
4 | EFF_END_DT | Date(10) | DATE | Effective End Date |
5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
8 | VAT_RCVRY_SRC_DESC | Character(30) | VARCHAR2(30) NOT NULL | VAT Recovery Source description |
9 | VAT_RCVRY_ACT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | VAT Taxable Activity Percent |
10 | VAT_REBATE_ACT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | VAT Exempt Activity Percent |
11 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
12 | VAT_PSB_TY_CD_DESC | Character(30) | VARCHAR2(30) NOT NULL | VAT Recovery Source description |
13 | VAT_ADMISSION_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Admission |
14 | VAT_ADMPCT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | VAT Admission Description |
15 | VAT_CONPCT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | VAT Constraint Description |
16 | VAT_CONSTRAINT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Constraint |
17 | VAT_TAXPCT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | VAT Taxation Description |
18 | VAT_TAXATION_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Taxation |
19 | USE_COEFFICIENT | Character(1) | VARCHAR2(1) NOT NULL |
Status flg to enable recovory coefficients
N=No Y=Yes |