AP_WC_PYHLD_V1

(SQL View)
 Index Back

AP Workcenter Payment Holds

AP Workcenter Payment Holds

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , B.PYMNT_CNT , A.INVOICE_ID , C.SETID , C.VENDOR_ID , B.REMIT_SETID , B.REMIT_VENDOR , C.VENDOR_NAME_SHORT , B.PYMNT_HOLD_REASON , B.SCHEDULED_PAY_DT , B.PYMNT_GROSS_AMT , B.TXN_CURRENCY_CD , B.PYMNT_HOLD_WTHD , A.APPR_STATUS , A.OPRID , A.OPRID_LAST_UPDT , A.ENTERED_DT FROM PS_VOUCHER A , PS_PYMNT_VCHR_XREF B , PS_VENDOR C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND B.REMIT_SETID = C.SETID AND B.REMIT_VENDOR = C.VENDOR_ID AND A.ENTRY_STATUS <> 'X' AND A.CLOSE_STATUS <> 'C' AND B.PYMNT_HOLD = 'Y'

  • Related Language Record: AP_WC_PYHLD_LVW

    • # 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