BUSINESS_UNITDefault Value: BUS_UNIT_TBL_AP.BUSINESS_UNIT
WTHD_ENTITYEFFDTDefault Value: %date
Default Value: 1
WTHD_AUTO_NUM(SQL Table) |
Index Back |
|---|---|
WTHD_AUTO_NUMThis is created for Auto Numbering in TDS Certificate |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: BUS_UNIT_TBL_AP.BUSINESS_UNIT |
| 2 | WTHD_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | WTHD_PRE_FIX_1 | Character(5) | VARCHAR2(5) NOT NULL | Pre Fix 1 |
| 5 | WTHD_PRE_FIX_2 | Character(7) | VARCHAR2(7) NOT NULL | Pre Fix 2 |
| 6 | WTHD_STRT_FROM_NBR | Number(10,0) | DECIMAL(10) NOT NULL |
Start From Number
Default Value: 1 |
| 7 | WTHD_LAST_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Last Number Used |