GFAP_CERTAP_VW(SQL View) |
Index Back |
|---|---|
View that makes name1 non-ndx06/21/99 RB : List all the valid Certifier's (Operator's) who have access to the AP system. |
| 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 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 |
| # | 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 |
| 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 |