WTHD_BU_JUR(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: WTHD_BU_HDR.BUSINESS_UNIT |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: WTHD_BU_HDR.EFFDT |
| 3 | WTHD_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Entity
Prompt Table: BU_WTHD_PRMT_VW |
| 4 | WTHD_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Type
Prompt Table: BU_WTHD_TP2_VW |
| 5 | WTHD_JUR_CD |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Jurisdiction
Prompt Table: BU_WHTP_JUR_VW |
| 6 | REGISTRATION_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Registration Type |
| 7 | REGISTRATION_ID | Character(20) | VARCHAR2(20) NOT NULL | Registration ID |
| 8 | BU_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit Category
Prompt Table: BU_WHTP_CAT_VW |
| 9 | COLLECT_AGENT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Collection Agent Flag
N=Is NOT Collection Agent Y=Is Collection Agent Y/N Table Edit Default Value: Y |
| 10 | LAST_CERT_NBR | Number(8,0) | INTEGER NOT NULL | Last Certificate Number |
| 11 | CODIGO_DGR | Character(10) | VARCHAR2(10) NOT NULL | Codigo DGR |