PAYMENT_TBL_VW

(SQL View)
 Index Back

View of AP Disbursements

This view has all the fields of the AP Payment table, except for the long description. This view is used in peoplecode to insert payments into the AP Payment table.

SELECT a.bank_setid , a.bank_cd , a.bank_acct_key , a.pymnt_id , a.pymnt_id_ref , a.bank_account_num , a.branch_id , a.check_digit , a.remit_setid , a.remit_vendor , a.vndr_loc , a.name1 , a.name2 , %subrec(address_sbr,a) , a.pymnt_dt , a.creation_dt , a.oprid , a.pymnt_amt , a.currency_pymnt , a.pymnt_method , a.pymnt_handling_cd , a.pymnt_status , a.pymnt_reconcile_dt , a.cancel_action , a.cancel_dt , a.dft_status , a.accounting_dt , a.post_status_ap , a.process_instance , a.pay_cycle , a.pay_cycle_seq_num , a.recon_type , a.recon_cycle_nbr , a.reconcile_oprid , a.bnk_id_nbr , a.recon_status , a.eft_pymnt_fmt_cd , a.eft_trans_handling , a.dfi_id_qual , a.dfi_id_num , a.rep_rtng_num , a.remit_bank_account , a.remit_branch_id , a.remit_check_digit , a.sttlmnt_dt_est , a.sttlmnt_dt_actual , a.form_nbr_confirmed , a.in_process_flg , a.positive_pay_dt , a.positive_pay_stat , a.micr_line , a.emplid , a.cash_cleared_flg , a.cash_cleared_dt , a.replaced_dt , a.pymnt_type , a.preferred_language , a.doc_type , a.doc_seq_date , a.doc_seq_nbr , a.doc_seq_status , a.source_txn , a.branch_name , a.lc_id , a.business_unit_gl , a.dft_master_id , a.dft_control_id , a.dft_stmp_tax_amt , a.dft_drawee , a.dft_approval_dt , a.dft_mat_dt , a.dft_wo_acct , a.dft_wo_dt , a.dft_opt_flg , a.dft_approve_flag , a.achieve_dt , a.dft_type , a.value_dt ,a.escheated_dt , a.USER_PYMNT_CHAR1 , a.USER_PYMNT_CHAR2 , a.user_pymnt_date , a.USER_PYMNT_DEC , a.USER_PYMNT_NUM , a.SCHEDULE_ID , a.dft_wo_altacct , a.cancel_post_status , a.treasury_pmt_nbr , a.single_pymnt_flg , a.ipac_pymnt_flg , a.BANK_ACCT_RVL_AMT , a.RECON_RUN_ID , a.eft_layout_cd , a.pmt_id , a.bank_ref_id , a.stl_through , a.pmt_pymnt_status , a.batch_id , a.record_seq_number , a.pymnt_hold_reason , a.interunit_pymt_flg , a.ar_stg_loaded , a.descrlong , a.PYMNT_REASON_CD , a.LAST_UPDATE_DTTM , a.SES_LAST_DTTM , a.ach_rrc FROM PS_PAYMENT_TBL a

  • Parent Record Of PYMNT_ADV_VW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

    Default Value: OPR_BANK_VW_AP.BANK_SETID

    Prompt Table: SP_SETBNK_NONVW

    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    3 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
    4 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
    5 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
    6 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    7 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
    8 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
    9 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    10 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    11 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    12 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

    Default Value: VENDOR_ADDR.NAME1

    13 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    15 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    16 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    17 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    18 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    19 CITY Character(30) VARCHAR2(30) NOT NULL City
    20 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    21 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    22 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat
    WW=Trailer
    23 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    24 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    25 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    26 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    27 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    28 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    29 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    30 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    31 PYMNT_DT Date(10) DATE Payment Date

    Default Value: %date

    32 CREATION_DT Date(10) DATE Creation Date
    33 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    34 PYMNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount
    35 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    36 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
    37 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
    38 PYMNT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status
    A=Alignment
    E=ACH/EFT Prenote
    L=Stale Dated Payment
    N=Reprinted with same ref number
    O=Overflow
    P=Paid
    R=Replaced
    S=Stopped
    T=Undo Escheatment
    U=Undo Cancel
    V=Void
    W=Escheated Check
    X=Deleted
    39 PYMNT_RECONCILE_DT Date(10) DATE Date Reconciled
    40 CANCEL_ACTION Character(1) VARCHAR2(1) NOT NULL Cancel Action
    C=Do Not Reissue/Close Liability
    H=Re-Open Voucher(s)/Put on Hold
    N=No Cancel Action
    P=Processed
    R=Re-Open Voucher(s)/Re-Issue
    S=Stale Dated Check
    W=Escheated
    41 CANCEL_DT Date(10) DATE Date Cancelled
    42 DFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Payment Status
    A=Approved
    C=Created
    D=Due
    N=Non-Draft Payment
    R=Reconciled
    W=Write Off
    X=Write Off Posted
    43 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
    44 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
    N=Payment Not Applied
    P=Posted
    U=Unposted

    Default Value: U

    45 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    46 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    47 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    48 RECON_TYPE Character(1) VARCHAR2(1) NOT NULL Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank
    A=Automatically Reconciled
    B=Balance System(s) to BankTran
    F=Forced to Reconcile
    M=Manually Reconciled
    S=Semi Manual
    U=Unreconciled

    Default Value: U

    49 RECON_CYCLE_NBR Number(10,0) DECIMAL(10) NOT NULL The bank statement ID.
    50 RECONCILE_OPRID Character(30) VARCHAR2(30) NOT NULL The user ID that performed the reconciliation for a given transaction.
    51 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    52 RECON_STATUS Character(3) VARCHAR2(3) NOT NULL Reconciliation Status
    ALG=Alignment Check
    AMB=Ambiguous Match
    AMT=Amounts Not Equal
    CUR=Currency not Defined
    DAT=Tran Date <> Value Date
    DPI=Duplicate Input Transactions
    DUP=Duplicate Transaction
    MSC=Miscellaneous Transaction
    NAM=Payee Names Not Equal
    NTB=Not Found in Statement
    NTF=Not Found In System
    NTP=Not Found in POS Data
    NUL=Null Transaction ID Ref
    OVR=Overflow
    PND=Pending Reconciliation
    REC=Reconciled
    RPR=Reprinted Check
    RR=Requires Review - BSAC
    STP=Stop Payment
    TYP=Wrong Transaction Type
    UNR=Unreconciled
    VOI=Voided Check
    53 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

    Prompt Table: PYMNT_FMT_TBL

    54 EFT_TRANS_HANDLING Character(1) VARCHAR2(1) NOT NULL Transaction Handling
    D=Payment Only
    P=Prenotification
    X=Payment and Advice
    55 DFI_ID_QUAL Character(2) VARCHAR2(2) NOT NULL A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
    01=Transit Number
    02=Swift ID/BIC
    03=CHIPS Participant ID
    04=Canadian Bank Branch/Institute
    05=CHIPS Universal ID
    ZZ=Mutually Defined
    56 DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
    57 REP_RTNG_NUM Character(10) VARCHAR2(10) NOT NULL Routing Code
    58 REMIT_BANK_ACCOUNT Character(35) VARCHAR2(35) NOT NULL Bank Account Number
    59 REMIT_BRANCH_ID Character(10) VARCHAR2(10) NOT NULL Branch ID
    60 REMIT_CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
    61 STTLMNT_DT_EST Date(10) DATE Date in which a deal transaction is estimated to be settled with a counterparty.
    62 STTLMNT_DT_ACTUAL Date(10) DATE Date in which a deal transaction is actually settled with a counterparty.
    63 FORM_NBR_CONFIRMED Character(1) VARCHAR2(1) NOT NULL Check Number Confirmed

    Y/N Table Edit

    64 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
    65 POSITIVE_PAY_DT Date(10) DATE Positive Payment Date
    66 POSITIVE_PAY_STAT Character(1) VARCHAR2(1) NOT NULL Positive Payment Status
    C=Sent to bank
    N=Not Sent to bank
    S=Selected for transmission
    Z=Zero Payment
    67 MICR_LINE Character(50) VARCHAR2(50) NOT NULL MICR Line
    68 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    69 CASH_CLEARED_FLG Character(1) VARCHAR2(1) NOT NULL Cash Cleared Flag
    70 CASH_CLEARED_DT Date(10) DATE Cash Cleared Date
    71 REPLACED_DT Date(10) DATE Replacement Date
    72 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
    73 PREFERRED_LANGUAGE Character(3) VARCHAR2(3) NOT NULL Preferred Language
    ARA=Arabic
    CFR=Canadian French
    CZE=Czech
    DAN=Danish
    DUT=Dutch
    E=English
    ENG=English
    ESP=Spanish
    F=French
    FIN=Finnish
    FRA=French
    GER=German
    HUN=Hungarian
    INE=International English
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    NOR=Norwegian
    POL=Polish
    POR=Portuguese
    RUS=Russian
    SVE=Swedish
    THA=Thai
    UKE=UK English
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    74 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
    75 DOC_SEQ_DATE Date(10) DATE Specifies the date that a document sequence number is assigned to a document or the date the document was created.
    76 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
    77 DOC_SEQ_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
    1=Document Sequencing Disabled
    A=GL BU Undefined
    B=GL BU Blank
    C=Accounting Date blank
    D=Doc Type Blank
    E=Jrnl Type, Code, Doc Undefine
    F=Sequence Range Undefine
    G=Max. Sequence Number Reached
    H=Manual Nbr for Auto Doc Type
    I=No Manual Number Entered
    J=Duplicate Manual Number
    K=Invalid Ledger
    L=Invalid Ledger Group
    N=No Status
    78 SOURCE_TXN Character(4) VARCHAR2(4) NOT NULL Source Transaction
    79 BRANCH_NAME Character(10) VARCHAR2(10) NOT NULL Branch Name
    80 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System
    81 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    82 DFT_MASTER_ID Character(10) VARCHAR2(10) NOT NULL Draft Master ID
    83 DFT_CONTROL_ID Character(20) VARCHAR2(20) NOT NULL Draft Control ID
    84 DFT_STMP_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Draft StampTax Amount
    85 DFT_DRAWEE Character(40) VARCHAR2(40) NOT NULL Draft Drawee
    86 DFT_APPROVAL_DT Date(10) DATE Draft Approval Date
    87 DFT_MAT_DT Date(10) DATE Draft Maturity Date
    88 DFT_WO_ACCT Character(10) VARCHAR2(10) NOT NULL Draft writeOff Account
    89 DFT_WO_DT Date(10) DATE Draft Write-Off Date
    90 DFT_OPT_FLG Character(1) VARCHAR2(1) NOT NULL Draft Optimization
    D=Use Pay Cycle Default
    N=Do Not Use
    S=Specify
    91 DFT_APPROVE_FLAG Character(1) VARCHAR2(1) NOT NULL Draft Issue Approval Required

    Y/N Table Edit

    Default Value: N

    92 ACHIEVE_DT Date(10) DATE Achieve Date
    93 DFT_TYPE Character(1) VARCHAR2(1) NOT NULL Draft Type
    A=Automatic
    M=Manual
    94 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.
    95 ESCHEATED_DT Date(10) DATE Stale Date
    96 USER_PYMNT_CHAR1 Character(1) VARCHAR2(1) NOT NULL User Character Field
    97 USER_PYMNT_CHAR2 Character(1) VARCHAR2(1) NOT NULL User Character Field
    98 USER_PYMNT_DATE Date(10) DATE User Date

    Default Value: %DATE

    99 USER_PYMNT_DEC Signed Number(28,3) DECIMAL(26,3) NOT NULL User Amount Field

    Default Value: 0

    100 USER_PYMNT_NUM Number(3,0) SMALLINT NOT NULL User Number field

    Default Value: 1

    101 SCHEDULE_ID Character(10) VARCHAR2(10) NOT NULL Schedule ID
    102 DFT_WO_ALTACCT Character(10) VARCHAR2(10) NOT NULL Write-off Alt Acct
    103 CANCEL_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Used to determine the post status of cancelled payment. If posting has not been run it will be set to W Pending. If the payment action is not V Void, S Stopped, W Escheated Check then the value is N. If the payment has not be posted but has been cancel the value = W. After the cancellation has been posted it the value is P posted.
    N=Not Applicable
    P=Posted
    W=Pending
    104 TREASURY_PMT_NBR Number(11,0) DECIMAL(11) NOT NULL Payment Confirm Number
    105 SINGLE_PYMNT_FLG Character(1) VARCHAR2(1) NOT NULL Single Payment

    Y/N Table Edit

    Default Value: N

    106 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

    107 BANK_ACCT_RVL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Field used to store the amount on a transaction revalued in the base currency of the transactions bank account.
    108 RECON_RUN_ID Character(15) VARCHAR2(15) NOT NULL Recon Run ID
    109 EFT_LAYOUT_CD Character(10) VARCHAR2(10) NOT NULL EFT Layout Code
    110 PMT_ID Character(15) VARCHAR2(15) NOT NULL Payment id
    111 BANK_REF_ID Character(16) VARCHAR2(16) NOT NULL A reference identifier associated with a given bank/counterparty transaction.
    112 STL_THROUGH Character(2) VARCHAR2(2) NOT NULL Settle through
    01=Financial Gateway
    02=Pay Cycle

    Default Value: 02

    113 PMT_PYMNT_STATUS Character(2) VARCHAR2(2) NOT NULL Settlement Status
    C=Canceled
    CM=Cancelled with Message
    E=Error
    H=Hold
    L=Loaded
    N=None
    P=Paid
    PC=Pending Cancellation
    R=Received by Bank
    S=Send to Bank
    SC=In Process

    Default Value: N

    114 BATCH_ID Character(18) VARCHAR2(18) NOT NULL Batch ID
    115 RECORD_SEQ_NUMBER Number(10,0) DECIMAL(10) NOT NULL An internal work field utilized to enumerate database records in bank statement processing.
    116 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
    117 INTERUNIT_PYMT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit Payment
    118 AR_STG_LOADED Character(1) VARCHAR2(1) NOT NULL AR Staging Table Populated
    119 DESCRLONG Long Character CLOB Long Description
    120 PYMNT_REASON_CD Character(4) VARCHAR2(4) NOT NULL Payment Reason Code
    121 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    122 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp
    123 ACH_RRC Character(3) VARCHAR2(3) NOT NULL ACH Return Reason Code