BUSINESS_UNITPrompt Table: EM_BUYER_SEC_VW
VOUCHER_IDPrompt Table: EM_PYMT_EXP_VW1
PYMNT_CNTPrompt Table: EM_PYMT_EXP_VW3
EM_PYMT_EXP_VW2(SQL View) |
Index Back |
|---|---|
MP - Select Vouchers to Pay VwMP - Select Vouchers to Pay View |
| SELECT a.business_unit , a.voucher_id , a.pymnt_cnt FROM PS_PYMNT_VCHR_XREF a WHERE a.pymnt_hold='N' AND a.pymnt_hold_wthd='N' AND a.pymnt_selct_status='N' AND a.pymnt_method IN ('EFT', 'ACH', 'CHK','GE') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: EM_BUYER_SEC_VW |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table: EM_PYMT_EXP_VW1 |
| 3 | PYMNT_CNT |
Number(5,0) | INTEGER NOT NULL |
Payments
Prompt Table: EM_PYMT_EXP_VW3 |