VAT_USE_TYPE_VW(SQL View) |
Index Back |
|---|---|
Vat Use type |
| SELECT SETID , VAT_USE_ID , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , VAT_RCVRY_SRC , VAT_RCVRY_ACT_PCT , DISTRIB_LINE_NUM , VAT_REBATE_ACT_PCT , VAT_PSB_TYPE_CD , VAT_ADMISSION_PCT , VAT_ADMPCT_DESCR , VAT_CONPCT_DESCR , VAT_CONSTRAINT_PCT , VAT_TAXPCT_DESCR , VAT_TAXATION_PCT , USE_COEFFICIENT FROM PS_VAT_USE_TBL WHERE EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | VAT_USE_ID |
Character(6) | VARCHAR2(6) NOT NULL | VAT Use Type |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | VAT_RCVRY_SRC | Character(1) | VARCHAR2(1) NOT NULL |
VAT Recovery Source
M=Mixed Apportionment U=Use Type Default Value: M |
| 8 | VAT_RCVRY_ACT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | VAT Taxable Activity Percent |
| 9 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 10 | VAT_REBATE_ACT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | VAT Exempt Activity Percent |
| 11 | VAT_PSB_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
VAT Public Service Body Type
CHRT=Charitable Organizations HOSP=Hospital Authorities MNCP=Municipalities NPOR=Non-Profit Organizations PBCL=Public Colleges SCHL=School Authorities UNIV=Universities |
| 12 | VAT_ADMISSION_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Admission |
| 13 | VAT_ADMPCT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | VAT Admission Description |
| 14 | VAT_CONPCT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | VAT Constraint Description |
| 15 | VAT_CONSTRAINT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Constraint |
| 16 | VAT_TAXPCT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | VAT Taxation Description |
| 17 | VAT_TAXATION_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Taxation |
| 18 | USE_COEFFICIENT | Character(1) | VARCHAR2(1) NOT NULL |
Status flg to enable recovory coefficients
N=No Y=Yes Default Value: N |