EM_PYMNTVCHRXRF

(SQL View)
Index Back

Voucher Scheduled Payment View


SELECT business_unit ,voucher_id ,pymnt_cnt ,pymnt_id ,paid_amt ,pymnt_gross_amt , TXN_CURRENCY_CD ,dscnt_pay_amt ,scheduled_pay_dt ,paid_amt_gross ,paid_amt_dscnt ,currency_pymnt ,pymnt_selct_status ,bank_setid ,bank_cd ,bank_acct_key ,pymnt_method ,pymnt_hold ,pymnt_hold_reason ,pay_cycle ,pay_cycle_seq_num ,dscnt_due_dt , REMIT_SETID , REMIT_VENDOR FROM PS_PYMNT_VCHR_XREF

  • 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 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    8 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount
    9 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
    10 PAID_AMT_GROSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Paid Amount
    11 PAID_AMT_DSCNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount on Paid Amount
    12 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    13 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
    14 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    15 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    16 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
    17 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
    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 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    21 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    22 DSCNT_DUE_DT Date(10) DATE Discount Due Date
    23 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    24 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor