OPR_DEF_AP_VW(SQL View) |
Index Back |
|---|---|
View that makes name1 non-ndx |
| SELECT b.oprid , a.name1 , b.origin , b.deptid , b.chk_inv_amt_flg , b.invoice_amt_max , b.currency_cd , b.cur_rt_type , b.auth_approve_vchr , b.vchr_apprvl_amt , b.auth_post_voucher , c.auth_vndr_uncertfy , c.auth_vndr_certfy , c.auth_vndr_inact_st , b.auth_vchr_grp , b.auth_sched_pymnt , b.auth_ovrrd_match , b.auth_pay_unmtched , b.auth_cpy_mtch_po , b.unmatch_pay_amt , b.prepay_limit_amt , b.auth_prepay_vchr , b.pymnt_rcrd_flg FROM ps_opr_def_tbl_fs a , PS_OPR_DEF_TBL_AP b , ps_opr_def_tbl_vnd c WHERE a.oprid = b.oprid AND a.oprid = c.oprid UNION SELECT b.oprid , ' ' , b.origin , b.deptid , b.chk_inv_amt_flg , b.invoice_amt_max , b.currency_cd , b.cur_rt_type , b.auth_approve_vchr , b.vchr_apprvl_amt , b.auth_post_voucher , c.auth_vndr_uncertfy , c.auth_vndr_certfy , c.auth_vndr_inact_st , b.auth_vchr_grp , b.auth_sched_pymnt , b.auth_ovrrd_match , b.auth_pay_unmtched , b.auth_cpy_mtch_po , b.unmatch_pay_amt , b.prepay_limit_amt , b.auth_prepay_vchr , b.pymnt_rcrd_flg FROM PS_OPR_DEF_TBL_AP b , ps_opr_def_tbl_vnd c WHERE b.oprid = c.oprid AND c.oprid NOT IN ( SELECT a.oprid FROM ps_opr_def_tbl_fs a) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 2 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 3 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL |
Origin
Prompt Table: ORIGIN_AP_OPT |
| 4 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPTID_NB_VW |
| 5 | CHK_INV_AMT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Check Voucher Amount
C=Check Voucher Amount N=Do Not Check Voucher Amount |
| 6 | INVOICE_AMT_MAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Entry Limit |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 9 | AUTH_APPROVE_VCHR | Character(1) | VARCHAR2(1) NOT NULL |
Authority to Approve Vouchers
Y/N Table Edit Default Value: N |
| 10 | VCHR_APPRVL_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Approval Limit |
| 11 | AUTH_POST_VOUCHER | Character(1) | VARCHAR2(1) NOT NULL |
Authority to Post Vouchers
Y/N Table Edit Default Value: N |
| 12 | AUTH_VNDR_UNCERTFY | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Entered Status
Y/N Table Edit Default Value: N |
| 13 | AUTH_VNDR_CERTFY | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Active Status
Y/N Table Edit Default Value: N |
| 14 | AUTH_VNDR_INACT_ST | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Inactive Status
Y/N Table Edit Default Value: N |
| 15 | AUTH_VCHR_GRP | Character(1) | VARCHAR2(1) NOT NULL |
Enter Vouchers Only in Groups
Y/N Table Edit Default Value: N |
| 16 | AUTH_SCHED_PYMNT | Character(1) | VARCHAR2(1) NOT NULL |
Manually Schedule Payments
Y/N Table Edit Default Value: N |
| 17 | AUTH_OVRRD_MATCH | Character(1) | VARCHAR2(1) NOT NULL | Authority to Override Match |
| 18 | AUTH_PAY_UNMTCHED | Character(1) | VARCHAR2(1) NOT NULL |
Pay Unmatched Vouchers
Y/N Table Edit |
| 19 | AUTH_CPY_MTCH_PO | Character(1) | VARCHAR2(1) NOT NULL |
Copy Matched and Closed PO
Y/N Table Edit Default Value: N |
| 20 | UNMATCH_PAY_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Pay Unmatched Limited |
| 21 | PREPAY_LIMIT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Prepayment Limit Amount |
| 22 | AUTH_PREPAY_VCHR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Prepay Voucher
Y/N Table Edit Default Value: N |
| 23 | PYMNT_RCRD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Record Payment
Default Value: Y |