WTHD_TRXN_TMP4(SQL Table) |
Index Back |
|---|
| # | 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 | PYMNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Document Type
E=Express Payment M=Manual Payment R=Regular payment W=Withholding Payment Z=Zero Payment Check |
| 5 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
| 6 | WTHD_ENTITY | Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
| 7 | PYMNT_SELCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid |
| 8 | ORIG_PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Original Payment Count |
| 9 | WTHD_AMT_ENT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withhold Amount (Entity Curr) |
| 10 | WTHD_BASIS_AMT_ENT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |