VAT_PSB_TBL(SQL Table) |
Index Back |
|---|---|
VAT Public Service Body Type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | SetID | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Tax Authority | |
| 3 | 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 |