OI_USETY_VW

(SQL View)
Index Back

VAT Use Type

Primary 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