UPDT_BU_TMP(SQL Table) |
Index Back |
|---|---|
Vchr line wthd updatesInformation required for voucher line withholding update process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
| 2 | WTHD_ENTITY | Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
| 3 | NEW_WTHD_CLASS | Character(5) | VARCHAR2(5) NOT NULL | Withhold class |
| 4 | NEW_WTHD_TYPE | Character(5) | VARCHAR2(5) NOT NULL | New Withhold Type |
| 5 | NEW_WTHD_JUR_CD | Character(5) | VARCHAR2(5) NOT NULL | New Withholding Jurisdiction |
| 6 | NEW_WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Withholding applicable flag
N=No Y=Yes |
| 7 | CURRENT_WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL | Withholding applicable flag |
| 8 | NEW_BU_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | New business unit category based on the new withholding class |
| 9 | NEW_VNDR_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | New vendor category based on the new class |
| 10 | NEW_WTHD_RULE | Character(5) | VARCHAR2(5) NOT NULL | New withholding rule associated with the new withhold class |
| 11 | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID | |
| 12 | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier | |
| 13 | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location | |
| 14 | Number(5,0) | INTEGER NOT NULL | Address Sequence Number | |
| 15 | BU_REGIST_ID | Character(20) | VARCHAR2(20) NOT NULL | BU Tax Identification Number |
| 16 | VNDR_REGIST_ID | Character(20) | VARCHAR2(20) NOT NULL | Supplier Tax ID |
| 17 | ENT_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Entity Currency Code |
| 18 | ENT_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Rate Type for Wthd Entity |
| 19 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 20 | END_DATE | Date(10) | DATE | End Date |