PYMNT_VCHR_XREF

(SQL Table)
Index Back

Voucher Scheduled Payment

  • 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

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

    Default Value: NEXT

    3 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments

    Default Value: 1

    4 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
    5 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
    6 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
    7 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
    8 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.
    9 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount
    10 DSCNT_DUE_DT Date(10) DATE Discount Due Date
    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

    Prompt Table: BANK_CURR_AP_VW

    15 RVL_DTTM DateTime(26) TIMESTAMP Revaluation DateTime
    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 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

    Prompt Table: REMIT_SETID_VW

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

    Prompt Table: VNDR_RMT_VW

    19 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

    Prompt Table: VNDR_REM_LOC_VW

    20 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location

    Default Value: VNDR_RMTADD2_VW.REMIT_ADDR_SEQ_NUM

    Prompt Table: VNDR_RMTADD3_VW

    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

    Prompt Table: %EDITTABLE23

    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

    Prompt Table: BANK_VACCT_VW11

    24 PYMNT_ACTION Character(1) VARCHAR2(1) NOT NULL Payment Action
    P=Prepayment Applied
    R=Record a Payment
    S=Schedule Payment
    W=Escheated Payment
    X=Cancelled

    Default Value: S

    25 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: BNK_PYMTHD_VW1

    26 PYMNT_MESSAGE Character(70) VARCHAR2(70) NOT NULL Payment Message
    27 PYMNT_HOLD_CD Character(5) VARCHAR2(5) NOT NULL Payment Hold Code
    28 PYMNT_HOLD Character(1) VARCHAR2(1) NOT NULL Hold Payment
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    29 VNDR_PYMNT_HLD_FLG Character(1) VARCHAR2(1) NOT NULL Vendor Payment Hold
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    33 BANK_ACCT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Bank Account Sequence Number

    Prompt Table: RMT_BANK_SEQ_VW

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

    Prompt Table: PYMNT_HNDL_TBL

    35 REMIT_BANK_SETID Character(5) VARCHAR2(5) NOT NULL Remit Bank Setid

    Prompt Table: RMT_BANK_SET_VW

    36 REMIT_BANK_CD Character(5) VARCHAR2(5) NOT NULL Remit Bank Code
    37 REMIT_BNK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL Remit Bank Account
    38 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    39 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    40 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    41 EFT_PYMNT_FMT_CD Character(3) VARCHAR2(3) NOT NULL Payment Format
    00=Standard SWIFT transfer
    10=Urgent SWIFT
    15=Euro-Transfer
    21=Check, w/ receipt confirmation
    22=Check, Urgent
    23=Check, urgent w/ receipt
    40=Postal Order
    CTX=Corp Trade Exchange
    PBC=Check, standard
    PPD=Prearranged Pay & Deposit
    WRT=Wire Transfer
    42 ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag

    Y/N Table Edit

    Default Value: N

    43 PAID_AMT_BNK_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount - Base Bank Unit
    44 BASE_CURRENCY_BNK Character(3) VARCHAR2(3) NOT NULL The base currency of the subject bank general ledger business unit.
    45 CUR_RT_TYPE_BNK Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    46 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
    47 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
    48 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    49 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
    N=Payment Not Applied
    P=Posted
    U=Unposted

    Default Value: U

    50 BUSINESS_UNIT_BANK Character(5) VARCHAR2(5) NOT NULL The general ledger business unit associated with a given bank/counterparty.
    51 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    52 HOL_PROC_OPT Character(1) VARCHAR2(1) NOT NULL Holiday Processing Option
    A=Due After Holiday
    B=Due Before Holiday
    N=Not Applicable

    Default Value: N

    53 HOL_PROC_DAYS Number(3,0) SMALLINT NOT NULL Days before/after Holiday
    54 HOL_PROC_OVERFL Character(1) VARCHAR2(1) NOT NULL Allow due date in next month

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: LC_HDR_AP_VW

    56 ORIG_PYMNT_CNT Number(5,0) INTEGER NOT NULL Original Payment Count
    57 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. "
    58 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
    59 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    60 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    61 GROSS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Amount
    62 DSCNT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Amount
    63 CUR_RT_TYPE_PYMNT Character(5) VARCHAR2(5) NOT NULL Payment Currency Rate Type
    64 PYMNT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange rate is stored
    65 PYMNT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange rate is store
    66 PAID_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Paid Amount
    67 PAID_AMT_GROSS_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Payment Amount
    68 PAID_AMT_DSCNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Paid Amount
    69 RVL_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Rate Type
    70 RVL_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL Revaluation Exchange Rate Mult
    71 RVL_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Revaluation Exchange Rate Div
    72 RVL_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Revalued Amount
    73 RVL_AMT_DSCNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Revalued Discount Amount
    74 PREPAID_STATUS Character(1) VARCHAR2(1) NOT NULL Prepaid Status
    A=Applied
    B=Pending Application
    C=Pending Unapply
    D=Pending Change
    F=Fully Applied
    I=Inactive
    P=Available Prepayment
    R=Restricted
    U=Unapplied
    X=Cancelled

    Default Value: U

    75 PREPAID_APPLIED_BU Character(5) VARCHAR2(5) NOT NULL Applied Business Unit
    76 PREPAID_APPL_VCHR Character(8) VARCHAR2(8) NOT NULL Applied Voucher ID
    77 PREPAID_APPL_PYMNT Number(5,0) INTEGER NOT NULL Applied Payment Count
    78 WTHD_PYMNT_CNT Number(5,0) INTEGER NOT NULL Wthd Payment Count

    Default Value: 0

    79 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

    80 WTHD_ADDTL_GROSS Signed Number(17,2) DECIMAL(15,2) NOT NULL Additional Withheld Gross Amt
    81 GRP_PYMNT_DT Character(1) VARCHAR2(1) NOT NULL Group by Payment Date

    Y/N Table Edit

    Default Value: N

    82 SOURCE_TXN Character(4) VARCHAR2(4) NOT NULL Source Transaction
    83 PYMNT_GROUP_CD Character(2) VARCHAR2(2) NOT NULL Pay Group Code

    Prompt Table: VNDR_PAYGRP_TBL

    84 SINGLE_PYMNT_FLG Character(1) VARCHAR2(1) NOT NULL Single Payment

    Y/N Table Edit

    Default Value: N

    85 CUR_RT_TYPE_PAID Character(5) VARCHAR2(5) NOT NULL Payment Rate Type

    Prompt Table: CUR_RT_TYPE_TBL

    86 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
    87 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
    88 SPEC_PYMNT_EX_RT Character(1) VARCHAR2(1) NOT NULL Specify Pymnt Ex Rate

    Y/N Table Edit

    Default Value: N

    89 APPLIED_PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
    90 NET_SELCT_STATUS Character(1) VARCHAR2(1) NOT NULL Netting Select Status
    H=Hold
    N=Not Applicable
    S=Selected

    Default Value: N

    91 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

    92 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
    93 DFT_SIGHT_CD Character(5) VARCHAR2(5) NOT NULL Draft Sight Code

    Prompt Table: APD_SIGHTCD_TBL

    94 DFT_MAT_DT Date(10) DATE Draft Maturity Date
    95 DFT_SCHED_MAT_DT Date(10) DATE Draft Scheduled Maturity Date
    96 DFT_GROUP_CD Character(5) VARCHAR2(5) NOT NULL Draft Group Code
    97 DFT_MASTER_ID Character(10) VARCHAR2(10) NOT NULL Draft Master ID
    98 DFT_CREATE_KEY Character(10) VARCHAR2(10) NOT NULL Draft Create Key
    99 PYMNT_REASON_CD Character(4) VARCHAR2(4) NOT NULL Payment Reason Code

    Prompt Table: XPYM_RSN_US_VW

    100 SCHEDULE_ID Character(10) VARCHAR2(10) NOT NULL Schedule ID
    101 LATE_CHRG_CD Character(4) VARCHAR2(4) NOT NULL Late Charge Code

    Prompt Table: LATE_CHRG_VW

    102 LATE_CHRG_OPT Character(1) VARCHAR2(1) NOT NULL Late Charge Option
    C=Compute Charges
    N=Not Applicable

    Default Value: N

    103 LATE_CHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Late Charge Amount
    104 LATE_CHRG_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Late Charge Amount Base
    105 LATE_CHRG_DNIE Signed Number(28,3) DECIMAL(26,3) NOT NULL Late Charge Denied
    106 LATE_CHRG_DNIE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Late Charge Paid Base
    107 LATE_CHRG_PAID Signed Number(28,3) DECIMAL(26,3) NOT NULL Late Charge Paid
    108 LATE_CHRG_PAID_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Late Charge Paid Base
    109 ECN_DSCNT_DNIE_FLG Character(1) VARCHAR2(1) NOT NULL Discount Denied

    Y/N Table Edit

    Default Value: N

    110 VOUCHER_ID_RELATED Character(8) VARCHAR2(8) NOT NULL Related Voucher
    111 BUS_UNIT_RELATED Character(5) VARCHAR2(5) NOT NULL AP Business Unit
    112 APPL_CREDIT_STATUS Character(1) VARCHAR2(1) NOT NULL Apply Credit Status
    A=Applied
    N=Not Applicable
    P=Pending

    Default Value: N

    113 PYMNT_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
    N=Approved Status
    P=Pending
    114 BANK_RPL_STATUS Character(1) VARCHAR2(1) NOT NULL Replacement Status
    B=Invalid electronic bank setup
    C=Bank currency not supported
    L=Invalid bank layout
    N=Not Replaced
    P=Payment method not supported
    R=Missing currency convert rates
    S=Invalid Set ID
    Y=Bank Replaced

    Default Value: N

    115 PYMNT_CNT_RELATED Number(5,0) INTEGER NOT NULL Payment
    116 IPAC_PYMNT_FLG Character(1) VARCHAR2(1) NOT NULL IPAC Payment flag - will indicate that a payment is for IPAC

    Y/N Table Edit

    Default Value: N

    117 EFT_LAYOUT_CD Character(10) VARCHAR2(10) NOT NULL EFT Layout Code

    Prompt Table: AP_BNKLYT_VW

    118 STL_THROUGH Character(2) VARCHAR2(2) NOT NULL Settle through
    01=Financial Gateway
    02=Pay Cycle