WTHD_RULEDefault Value: WTHD_RULE_HDR.WTHD_RULE
Prompt Table: WTHD_RULE_HDR
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
WTHD_RULE_DTL(SQL Table) |
Index Back |
|---|---|
Withholding Rule Detail Defn |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WTHD_RULE |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Rule
Default Value: WTHD_RULE_HDR.WTHD_RULE Prompt Table: WTHD_RULE_HDR |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | WTHD_SURCHRG_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Withholding SurCharge % |
| 5 | ADDL_SRCHRG_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Additional Surcharge % |
| 6 | WTHD_CESS_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Field to hold Withholding Cess Percentage |
| 7 | FLAT_RATE_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Field to hold the percentage for a Flat Rate while calculating TDS for India |
| 8 | RATE_FORCE_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Field to hold the Value of the Percentage when the Rate in Force is applied. |
| 9 | CUMM_THRESHOLD | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |