EM_PYMNTVCHRXRF(SQL View) |
Index Back |
---|---|
Voucher Scheduled Payment View |
SELECT business_unit ,voucher_id ,pymnt_cnt ,pymnt_id ,paid_amt ,pymnt_gross_amt , TXN_CURRENCY_CD ,dscnt_pay_amt ,scheduled_pay_dt ,paid_amt_gross ,paid_amt_dscnt ,currency_pymnt ,pymnt_selct_status ,bank_setid ,bank_cd ,bank_acct_key ,pymnt_method ,pymnt_hold ,pymnt_hold_reason ,pay_cycle ,pay_cycle_seq_num ,dscnt_due_dt , REMIT_SETID , REMIT_VENDOR FROM PS_PYMNT_VCHR_XREF |
# | 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 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
5 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
6 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
7 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
8 | DSCNT_PAY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Discount Amount |
9 | SCHEDULED_PAY_DT | Date(10) | DATE | Scheduled to Pay |
10 | PAID_AMT_GROSS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Paid Amount |
11 | PAID_AMT_DSCNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount on Paid Amount |
12 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
13 | PYMNT_SELCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid |
14 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
15 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
16 | 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 |
17 | 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 |
18 | PYMNT_HOLD | Character(1) | VARCHAR2(1) NOT NULL |
Hold Payment
N=No Y=Yes Y/N Table Edit |
19 | 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 |
20 | PAY_CYCLE | Character(6) | VARCHAR2(6) NOT NULL | Pay Cycle |
21 | PAY_CYCLE_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Pay Cycle Sequence Number |
22 | DSCNT_DUE_DT | Date(10) | DATE | Discount Due Date |
23 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
24 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |