PYMNT_ADVICE_VW

(SQL View)
 Index Back

AP Express Payment Advice Info


SELECT A.PAY_CYCLE , A.PAY_CYCLE_SEQ_NUM , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , 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.PYMNT_ID , A.ORIGIN , A.SBI_NUM , A.ADVICE_SEQ_CHAR , B.LATE_CHRG_PAID FROM PS_PYMNT_ADVICE A , PS_PYMNT_VCHR_XREF B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PAY_DOC_ID = B.VOUCHER_ID AND A.PAY_DOC_SEQ = B.PYMNT_CNT AND A.REMIT_LINE_TYPE = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
2 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
3 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
4 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
5 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
6 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
7 PYMNT_SEPARATE Character(1) VARCHAR2(1) NOT NULL Separate Payment
8 PAY_DOC_SEQ Number(5,0) INTEGER NOT NULL Advice Sequence
9 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
10 PYMNT_OVERFLOW_ID Character(20) VARCHAR2(20) NOT NULL Payment Overflow ID
11 SOURCE_TXN Character(4) VARCHAR2(4) NOT NULL Source Transaction
12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
13 PAY_DOC_ID Character(20) VARCHAR2(20) NOT NULL Advice ID
14 REMIT_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Remit Line Type
A=Remittance Advice Line
M=Remittance Message Line

Default Value: A

15 PYMNT_ADVICE_COMBO Character(38) VARCHAR2(38) NOT NULL Payment Advice Combo Key
16 PYCYCL_KEY_FIELD2 Date(10) DATE Pay Cycle Mapping Key Field 2
17 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
18 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
19 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
20 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number
21 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
22 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
23 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
24 PAY_DOC_DT Date(10) DATE Advice Date
25 PAID_AMT_GROSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Paid Amount
26 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
27 DISCOUNT_TAKEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Taken
28 PAID_AMT_DSCNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount on Paid Amount
29 PYMNT_MESSAGE Character(70) VARCHAR2(70) NOT NULL Payment Message
30 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
31 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
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
35 LATE_CHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Late Charge Amount