AP_SCHD_INQ_VW

(SQL View)
 Index Back

Voucher Scheduled Payment


SELECT V.BUSINESS_UNIT , V.VOUCHER_ID , V.VOUCHER_STYLE , V.APPR_STATUS , A.PYMNT_CNT , A.PYMNT_ID , A.PYMNT_TYPE , A.PAID_AMT , A.PYMNT_GROSS_AMT , A.DUE_DT , A.DSCNT_PAY_AMT , A.DSCNT_DUE_DT , A.SCHEDULED_PAY_DT , A.CURRENCY_PYMNT , A.TXN_CURRENCY_CD , A.PYMNT_SELCT_STATUS , V.VENDOR_SETID , V.VENDOR_ID , V.VNDR_LOC , VEN.VENDOR_NAME_SHORT , VEN.NAME1 , A.REMIT_SETID , A.REMIT_VENDOR , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , B.BANK_ACCOUNT_NUM , A.PYMNT_METHOD , A.PYMNT_MESSAGE , A.PYMNT_HOLD , A.PYMNT_HOLD_REASON , A.PYMNT_HOLD_WTHD , A.PYMNT_SEPARATE , A.PYMNT_HANDLING_CD , A.POST_STATUS_AP , A.LC_ID , A.WTHD_PYMNT_CNT , A.POST_STATUS_WTHD , A.PYMNT_GROUP_CD , A.NET_SELCT_STATUS , A.NET_TXN_STATUS , A.NET_REF_ID , A.DFT_SIGHT_CD , A.DFT_MAT_DT , A.DFT_SCHED_MAT_DT , V.INVOICE_ID , A.IPAC_PYMNT_FLG , VEN.OFAC_STATUS FROM PS_VOUCHER V , PS_PYMNT_VCHR_XREF A , PS_BANK_ACCT_DEFN B , PS_VENDOR VEN WHERE A.BUSINESS_UNIT = V.BUSINESS_UNIT AND A.VOUCHER_ID = V.VOUCHER_ID AND B.SETID = A.BANK_SETID AND B.BANK_CD = A.BANK_CD AND B.BANK_CD_CPTY = A.BANK_CD AND B.BANK_ACCT_KEY = A.BANK_ACCT_KEY AND VEN.SETID = V.VENDOR_SETID AND VEN.VENDOR_ID = V.VENDOR_ID AND V.VOUCHER_STYLE NOT IN ('TMPL', 'SGLP') AND (V.PROCESS_MAN_CLOSE = 'N' OR V.CLOSE_STATUS <> 'C') AND V.ENTRY_STATUS <> 'X' AND A.PYMNT_SELCT_STATUS NOT IN ('P','X','S') AND (A.NET_SELCT_STATUS <> 'S' OR A.NET_TXN_STATUS <> 'N') AND EXISTS ( SELECT 'X' FROM PS_BUS_UNIT_TBL_FS WHERE BUSINESS_UNIT = V.BUSINESS_UNIT )

  • Related Language Record: AP_SCHD_INQ_LVW

  • Parent record: VOUCHER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AP_NONVW

    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

    Prompt Table: VCHR_ID_VW

    3 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
    ADJ=Adjustments
    AMR=Amortization Voucher
    CLBK=Claim Voucher
    CORR=Reversal Voucher
    JRNL=Journal Voucher
    PPAY=Prepaid Voucher
    REG=Regular Voucher
    RGTR=Register Voucher
    SGLP=Single Payment Voucher
    THRD=Third Party Voucher
    TMPL=Template Voucher
    4 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
    5 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments

    Default Value: 1

    6 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
    7 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
    8 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
    9 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
    10 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
    11 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount
    12 DSCNT_DUE_DT Date(10) DATE Discount Due Date
    13 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
    14 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency

    Prompt Table: BANK_CURR_AP_VW

    15 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

    Prompt Table: CURR_TXN_VW

    16 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

    Default Value: N

    17 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    18 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    19 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    20 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    21 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    22 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

    Prompt Table: REMIT_SETID_VW

    23 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor

    Prompt Table: VNDR_RMT_VW

    24 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    25 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

    Prompt Table: BANK_CD_VW8

    26 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

    Prompt Table: BANK_ACCT_VW11

    27 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    28 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
    ACH=Automated Clearing House
    BEF=Draft - Customer EFT
    BOO=Draft - Customer Initiated
    CHK=System Check
    D=Deposit
    DD=Direct Debit
    DFT=Draft - Supplier Initiated
    DRA=Draft
    EFT=Electronic Funds Transfer
    GE=Giro - EFT
    GM=Giro - Manual
    LC=Letter of Credit
    MAN=Manual Check
    TRW=Treasury Wire
    WIR=Wire Transfer

    Prompt Table: PYMNT_MTHD_VW2

    29 PYMNT_MESSAGE Character(70) VARCHAR2(70) NOT NULL Payment Message
    30 PYMNT_HOLD Character(1) VARCHAR2(1) NOT NULL Hold Payment
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    31 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
    32 PYMNT_HOLD_WTHD Character(1) VARCHAR2(1) NOT NULL On Withholding Hold
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    33 PYMNT_SEPARATE Character(1) VARCHAR2(1) NOT NULL Separate Payment

    Y/N Table Edit

    Default Value: N

    34 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling

    Prompt Table: PYMNT_HNDL_TBL

    35 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
    N=Payment Not Applied
    P=Posted
    U=Unposted

    Default Value: U

    36 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System

    Prompt Table: LC_HDR_AP_VW

    37 WTHD_PYMNT_CNT Number(5,0) INTEGER NOT NULL Wthd Payment Count

    Default Value: 0

    38 POST_STATUS_WTHD Character(1) VARCHAR2(1) NOT NULL Post Withholding Status
    N=Not Postable
    P=Posted
    U=Unposted
    X=Cancelled Withholding

    Default Value: U

    39 PYMNT_GROUP_CD Character(2) VARCHAR2(2) NOT NULL Pay Group Code

    Prompt Table: VNDR_PAYGRP_TBL

    40 NET_SELCT_STATUS Character(1) VARCHAR2(1) NOT NULL Netting Select Status
    H=Hold
    N=Not Applicable
    S=Selected

    Default Value: N

    41 NET_TXN_STATUS Character(2) VARCHAR2(2) NOT NULL Transaction Status
    B=Balance
    D=DeSelect - Full
    DB=DeSelect Split - Balance
    DF=DeSelect - Full
    DN=DeSelect Split - Net
    N=Net
    NA=Not Applicable
    S=Split - Net / Balance

    Default Value: NA

    42 NET_REF_ID Character(12) VARCHAR2(12) NOT NULL A reference identifier associated with a cash transaction subject to netting with a given bank/count
    43 DFT_SIGHT_CD Character(5) VARCHAR2(5) NOT NULL Draft Sight Code

    Prompt Table: APD_SIGHTCD_TBL

    44 DFT_MAT_DT Date(10) DATE Draft Maturity Date
    45 DFT_SCHED_MAT_DT Date(10) DATE Draft Scheduled Maturity Date
    46 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    47 IPAC_PYMNT_FLG Character(1) VARCHAR2(1) NOT NULL IPAC Payment flag - will indicate that a payment is for IPAC
    48 OFAC_STATUS Character(1) VARCHAR2(1) NOT NULL OFAC Status
    B=Blocked
    C=Cleared
    R=Review
    V=Valid