APIPAC_VCHRPYMT

(SQL View)
Index Back

Voucher Staging Misc Charges

Voucher Payment Staging table

SELECT A.BUSINESS_UNIT , B.VOUCHER_ID , A.PYMNT_CNT , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , CASE WHEN ( SELECT X.ALC FROM PS_BANK_CD_TBL X WHERE X.SETID = A.BANK_SETID AND X.BANK_CD = A.BANK_CD) = B.CUSTOMER_ALC THEN 'MAN' WHEN ( SELECT X.ALC FROM PS_BANK_CD_TBL X WHERE X.SETID = A.BANK_SETID AND X.BANK_CD = A.BANK_CD) = B.ALC THEN 'EFT' END , B.IPAC_AMOUNT ,'N' , %CurrentDateIn , CASE WHEN ( SELECT X.ALC FROM PS_BANK_CD_TBL X WHERE X.SETID = A.BANK_SETID AND X.BANK_CD = A.BANK_CD) = B.CUSTOMER_ALC THEN 'R' WHEN ( SELECT X.ALC FROM PS_BANK_CD_TBL X WHERE X.SETID = A.BANK_SETID AND X.BANK_CD = A.BANK_CD) = B.ALC THEN 'S' END, ' ' , B.PROCESS_INSTANCE FROM PS_PYMNT_VCHR_XREF A , PS_AP_IPAC_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID_RELATED AND A.PYMNT_CNT = 1

# 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 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
5 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
6 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
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_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
9 PYMNT_SEPARATE Character(1) VARCHAR2(1) NOT NULL Separate Payment
10 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
11 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
12 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance