AP_WC_PYHLD_V2(SQL View) |
Index Back |
|---|---|
AP Workcenter Payment HoldsAP Workcenter Payment Holds |
| SELECT AA.BUSINESS_UNIT , AA.VOUCHER_ID , BB.PYMNT_CNT , AA.INVOICE_ID , CC.SETID , CC.VENDOR_ID , BB.REMIT_SETID , BB.REMIT_VENDOR , CC.VENDOR_NAME_SHORT , 'OTH' , BB.SCHEDULED_PAY_DT , BB.PYMNT_GROSS_AMT , BB.TXN_CURRENCY_CD , BB.PYMNT_HOLD_WTHD , AA.APPR_STATUS , AA.OPRID , AA.OPRID_LAST_UPDT , AA.ENTERED_DT FROM PS_VOUCHER AA , PS_PYMNT_VCHR_XREF BB , PS_VENDOR CC WHERE AA.BUSINESS_UNIT = BB.BUSINESS_UNIT AND AA.VOUCHER_ID = BB.VOUCHER_ID AND BB.REMIT_SETID = CC.SETID AND BB.REMIT_VENDOR = CC.VENDOR_ID AND AA.ENTRY_STATUS <> 'X' AND AA.CLOSE_STATUS <> 'C' AND BB.PYMNT_HOLD <> 'Y' AND BB.PYMNT_HOLD_WTHD = 'Y' |
| # | 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 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 7 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
| 8 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 9 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 10 | PYMNT_HOLD_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Hold Reason
ACC=Accounting in Dispute ACV=Federal Supplier Inactive ALC=Agency Location Code Required AMT=Amount in Dispute CCR=CCR Expired CRT=Contract Retention EFT=EFT incomplete or not Prenoted FNS=Financial Sanctions GDS=Goods in Dispute GNV=G-Invoicing Hold IPC=Inbound IPAC Required OTH=Other QTY=Quantity in Dispute SAM=SAM Expired WTH=Withholding Hold |
| 11 | SCHEDULED_PAY_DT | Date(10) | DATE | Scheduled to Pay |
| 12 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
| 13 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 14 | PYMNT_HOLD_WTHD | Character(1) | VARCHAR2(1) NOT NULL |
On Withholding Hold
N=No Y=Yes |
| 15 | APPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved D=Denied P=Pending |
| 16 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 17 | OPRID_LAST_UPDT | Character(30) | VARCHAR2(30) NOT NULL | Last User to Update |
| 18 | ENTERED_DT | Date(10) | DATE | Entered on |