PYMNT_ADV_VW1

(SQL View)
 Index Back

AP Express Payment Advice Info


SELECT A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_ID , A.PAY_CYCLE , A.PAY_CYCLE_SEQ_NUM , A.PYMNT_METHOD , A.PYMNT_SEPARATE , A.PAY_DOC_SEQ , A.PYMNT_ID_REF , A.PYMNT_OVERFLOW_ID , A.SOURCE_TXN , A.BUSINESS_UNIT , A.PAY_DOC_ID , A.REMIT_LINE_TYPE , A.PYMNT_ADVICE_COMBO , A.PYCYCL_KEY_FIELD2 , A.CURRENCY_PYMNT , A.REMIT_SETID , A.REMIT_VENDOR , A.AR_NUM , A.VENDOR_ID , A.EMPLID , A.INVOICE_ID , A.PAY_DOC_DT , A.PAID_AMT_GROSS , A.PAID_AMT , A.DISCOUNT_TAKEN , A.PAID_AMT_DSCNT , A.PYMNT_MESSAGE , A.PYMNT_HANDLING_CD , A.ORIGIN , A.SBI_NUM , A.ADVICE_SEQ_CHAR FROM PS_PYMNT_ADVICE A

  • Parent record: PAYMENT_TBL_VW

    • # 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.
    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 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    6 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    7 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
    8 PYMNT_SEPARATE Character(1) VARCHAR2(1) NOT NULL Separate Payment
    9 PAY_DOC_SEQ Number(5,0) INTEGER NOT NULL Advice Sequence
    10 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
    11 PYMNT_OVERFLOW_ID Character(20) VARCHAR2(20) NOT NULL Payment Overflow ID
    12 SOURCE_TXN Character(4) VARCHAR2(4) NOT NULL Source Transaction
    13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    14 PAY_DOC_ID Character(20) VARCHAR2(20) NOT NULL Advice ID
    15 REMIT_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Remit Line Type
    A=Remittance Advice Line
    M=Remittance Message Line

    Default Value: A

    16 PYMNT_ADVICE_COMBO Character(38) VARCHAR2(38) NOT NULL Payment Advice Combo Key
    17 PYCYCL_KEY_FIELD2 Date(10) DATE Pay Cycle Mapping Key Field 2
    18 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    19 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    20 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    21 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number
    22 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    23 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    24 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    25 PAY_DOC_DT Date(10) DATE Advice Date
    26 PAID_AMT_GROSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Paid Amount
    27 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
    28 DISCOUNT_TAKEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Taken
    29 PAID_AMT_DSCNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount on Paid Amount
    30 PYMNT_MESSAGE Character(70) VARCHAR2(70) NOT NULL Payment Message
    31 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
    32 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    33 SBI_NUM Character(40) VARCHAR2(40) NOT NULL SBI_num
    34 ADVICE_SEQ_CHAR Character(5) VARCHAR2(5) NOT NULL Advice Sequence