BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AP_NONVW
VOUCHER_IDPrompt Table: PYMNT_EXP_VW1
PYMNT_CNTPrompt Table: PYMNT_EXP_VW3
PYMNT_EXP_VW2(SQL View) |
Index Back |
|---|
| 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 ('CHK' ,'EFT' ,'ACH', 'GE', 'BOO', 'BEF') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table: PYMNT_EXP_VW1 |
| 3 | PYMNT_CNT |
Number(5,0) | INTEGER NOT NULL |
Payments
Prompt Table: PYMNT_EXP_VW3 |