UPDT_VCHR_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 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
3 | WTHD_ENTITY | Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
4 | NEW_WTHD_CLASS | Character(5) | VARCHAR2(5) NOT NULL | Withhold class |
5 | NEW_WTHD_TYPE | Character(5) | VARCHAR2(5) NOT NULL | New Withhold Type |
6 | NEW_WTHD_JUR_CD | Character(5) | VARCHAR2(5) NOT NULL | New Withholding Jurisdiction |
7 | NEW_WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Withholding applicable flag
N=No Y=Yes |
8 | CURRENT_WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL | Withholding applicable flag |
9 | NEW_BU_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | New business unit category based on the new withholding class |
10 | NEW_VNDR_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | New vendor category based on the new class |
11 | NEW_WTHD_RULE | Character(5) | VARCHAR2(5) NOT NULL | New withholding rule associated with the new withhold class |
12 | CREATE_PAY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Create Withholding Payment |
13 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
14 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
15 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
16 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
17 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
18 | GROSS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Gross Amount |
19 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
20 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
21 | ENT_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Entity Currency Code |
22 | ENT_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Rate Type for Wthd Entity |
23 | ENT_RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | TE Rate Multiplier |
24 | ENT_RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | TE Rate Divisor |
25 | BU_REGIST_ID | Character(20) | VARCHAR2(20) NOT NULL | BU Tax Identification Number |
26 | VNDR_REGIST_ID | Character(20) | VARCHAR2(20) NOT NULL | Supplier Tax ID |
27 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
28 | END_DATE | Date(10) | DATE | End Date |