CAN_TAX_PROVNCT(SQL Table) |
Index Back |
---|---|
CAN Provincial Net Claim TableProvincial Net Claim amounts for income surtax calculation. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
2 | PROVINCE | Character(6) | VARCHAR2(6) NOT NULL | Province |
3 | CIT_NCA | Number(10,2) | DECIMAL(9,2) NOT NULL | Net Claim Amount Threshold |
4 | CIT_Y | Number(8,2) | DECIMAL(7,2) NOT NULL | Provincial Tax Reduction (Y) |