ARCHIVE_IDARCHIVE_DTBUSINESS_UNITVOUCHER_IDPYMNT_CNTVOUCHER_LINE_NUMWTHD_ENTITYWTHD_TYPEWTHD_CLASSN=Not Postable
P=Posted
U=Unposted
X=Cancelled Withholding
PYMNT_VCHWH_UPG(SQL Table) |
Index Back |
|---|---|
Upgrade Copy of HistoryA copy of PYMNT_VCHWH_HST is being moved by the upgrade to this table to keep a history record for the PYMNT_VCHR_WTHD table. This is necessary because of a key change in the 8.x upgrade. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ARCHIVE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID |
| 2 | ARCHIVE_DT |
Date(10) | DATE NOT NULL | Archive Date |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 5 | PYMNT_CNT |
Number(5,0) | INTEGER NOT NULL | Payments |
| 6 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 7 | WTHD_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
| 8 | WTHD_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 9 | WTHD_CLASS |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Class |
| 10 | WTHD_RULE | Character(5) | VARCHAR2(5) NOT NULL | Withholding Rule |
| 11 | WTHD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |
| 12 | WTHD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 13 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 14 | WTHD_AMT_BNK_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount Bank Base |
| 15 | BASE_CURRENCY_BNK | Character(3) | VARCHAR2(3) NOT NULL | The base currency of the subject bank general ledger business unit. |
| 16 | POSTING_DATE | Date(10) | DATE | Posting Date |
| 17 | POST_STATUS_WTHD | Character(1) | VARCHAR2(1) NOT NULL |
Post Withholding Status
N=Not Postable P=Posted U=Unposted X=Cancelled Withholding |
| 18 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 19 | CREATE_PAY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Create Withholding Payment |