UA_WTHD_UPG_T2(SQL Table) |
Index Back |
|---|---|
AP Upgrade WTHD Temp Table |
| # | 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 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 4 | WTHD_ENTITY | Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
| 5 | WTHD_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 6 | WTHD_JUR_CD | Character(5) | VARCHAR2(5) NOT NULL | Withholding Jurisdiction |
| 7 | WTHD_CLASS | Character(5) | VARCHAR2(5) NOT NULL | Withholding Class |
| 8 | WTHD_RULE | Character(5) | VARCHAR2(5) NOT NULL | Withholding Rule |
| 9 | WTHD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |
| 10 | WTHD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 11 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 12 | POSTING_DATE | Date(10) | DATE | Posting Date |
| 13 | POST_STATUS_WTHD | Character(1) | VARCHAR2(1) NOT NULL |
Post Withholding Status
N=Not Postable P=Posted U=Unposted X=Cancelled Withholding |
| 14 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 15 | CREATE_PAY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Create Withholding Payment |