PYMNT_VCHR_VW3

(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.pymnt_gross_amt ,a.dscnt_pay_amt ,a.scheduled_pay_dt ,a.paid_amt_gross ,a.paid_amt_dscnt ,a.currency_pymnt ,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.txn_currency_cd ,a.business_unit_bank , a.cur_rt_type_paid , a.spec_pymnt_ex_rt , a.paid_rate_mult , a.paid_rate_div 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 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
    7 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount
    8 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
    9 PAID_AMT_GROSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Paid Amount
    10 PAID_AMT_DSCNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount on Paid Amount
    11 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    12 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
    13 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    14 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    15 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
    16 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
    17 PYMNT_MESSAGE Character(70) VARCHAR2(70) NOT NULL Payment Message
    18 PYMNT_HOLD Character(1) VARCHAR2(1) NOT NULL Hold Payment
    N=No
    Y=Yes

    Y/N Table Edit

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

    Y/N Table Edit

    21 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
    22 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    23 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    24 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    25 DSCNT_DUE_DT Date(10) DATE Discount Due Date
    26 BASE_CURRENCY_BNK Character(3) VARCHAR2(3) NOT NULL The base currency of the subject bank general ledger business unit.
    27 CUR_RT_TYPE_BNK Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    28 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
    29 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
    30 PAID_AMT_BNK_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount - Base Bank Unit
    31 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    32 BUSINESS_UNIT_BANK Character(5) VARCHAR2(5) NOT NULL The general ledger business unit associated with a given bank/counterparty.
    33 CUR_RT_TYPE_PAID Character(5) VARCHAR2(5) NOT NULL Payment Rate Type
    34 SPEC_PYMNT_EX_RT Character(1) VARCHAR2(1) NOT NULL Specify Pymnt Ex Rate
    35 PAID_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determing whether a currency exchange spot rate is stored either as
    36 PAID_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determing whether a currency exchange spot rate is store