VAT_PSB_TBL(SQL Table) |
Index Back |
---|---|
VAT Public Service Body TypeVAT 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 |