PYMNT_VCHR_VW1

(SQL View)
 Index Back

Voucher Scheduled Payment View


SELECT a.business_unit ,a.voucher_id ,a.pymnt_cnt ,a.pymnt_id ,a.paid_amt ,a.paid_amt_bse ,a.pymnt_gross_amt ,a.dscnt_pay_amt ,a.rate_mult ,a.rate_div ,a.scheduled_pay_dt ,a.paid_amt_gross ,a.paid_amt_dscnt ,a.currency_pymnt ,a.cur_rt_type_pymnt ,a.pymnt_rate_mult ,a.pymnt_rate_div ,a.paid_amt_gross_bse ,a.paid_amt_dscnt_bse ,a.pymnt_selct_status ,a.bank_setid ,a.bank_cd ,a.bank_acct_key ,a.pymnt_method ,a.pymnt_message ,a.pymnt_hold ,a.pymnt_hold_reason ,a.pymnt_separate ,a.pymnt_handling_cd ,a.pay_cycle ,a.pay_cycle_seq_num ,a.process_instance ,a.dscnt_due_dt ,a.base_currency_bnk ,a.cur_rt_type_bnk ,a.bnk_rate_mult ,a.bnk_rate_div ,a.paid_amt_bnk_bse ,a.base_currency ,a.txn_currency_cd FROM PS_PYMNT_VCHR_XREF a

  • Parent record: VOUCHER

    • # 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_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
    5 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
    6 PAID_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Paid Amount
    7 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
    8 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount
    9 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    10 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    11 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
    12 PAID_AMT_GROSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Paid Amount
    13 PAID_AMT_DSCNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount on Paid Amount
    14 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    15 CUR_RT_TYPE_PYMNT Character(5) VARCHAR2(5) NOT NULL Payment Currency Rate Type
    16 PYMNT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange rate is stored
    17 PYMNT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange rate is store
    18 PAID_AMT_GROSS_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Payment Amount
    19 PAID_AMT_DSCNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Paid Amount
    20 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
    21 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    22 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    23 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
    24 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
    25 PYMNT_MESSAGE Character(70) VARCHAR2(70) NOT NULL Payment Message
    26 PYMNT_HOLD Character(1) VARCHAR2(1) NOT NULL Hold Payment
    N=No
    Y=Yes

    Y/N Table Edit

    27 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
    28 PYMNT_SEPARATE Character(1) VARCHAR2(1) NOT NULL Separate Payment

    Y/N Table Edit

    29 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
    30 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    31 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    32 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    33 DSCNT_DUE_DT Date(10) DATE Discount Due Date
    34 BASE_CURRENCY_BNK Character(3) VARCHAR2(3) NOT NULL The base currency of the subject bank general ledger business unit.
    35 CUR_RT_TYPE_BNK Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    36 BNK_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange spot rate is stored either as
    37 BNK_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange spot rate is store
    38 PAID_AMT_BNK_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount - Base Bank Unit
    39 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
    40 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency