VAT_PSB_TBL(SQL Table) |
Index Back |
---|---|
VAT Public Service Body Type |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | TAX_AUTHORITY_CD | Character(3) | VARCHAR2(3) NOT NULL | Tax Authority |
3 | 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 |
4 | VAT_REBATE_RT | Number(6,2) | DECIMAL(5,2) NOT NULL | VAT Rebate Rate |