APIPAC_VCHRPYMT(SQL View) |
Index Back |
---|---|
Voucher Staging Misc ChargesVoucher 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 |