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 | BUSINESS_UNIT | 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 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
12 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
13 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
14 | ADDRESS_SEQ_NUM | 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 |