OPRDEFAP_TEO3(SQL Table) |
Index Back |
---|---|
Operator Defaults - PS/AP |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | QV_VCHR_BALANCE | Character(1) | VARCHAR2(1) NOT NULL | Require Balanced Invoice |
3 | AUTH_CLBK_VCHR | Character(1) | VARCHAR2(1) NOT NULL | Allow Claim Voucher |
4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID Prompt Table: OPRID_VW |
5 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL |
Origin
Prompt Table: ORIGIN_AP_EFFVW |
6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPTID_NB_VW |
7 | CHK_INV_AMT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Check Voucher Amount
C=Check Voucher Amount N=Do Not Check Voucher Amount Default Value: N |
8 | INVOICE_AMT_MAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Entry Limit |
9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
10 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: RT_TYPE_TBL |
11 | AUTH_APPROVE_VCHR | Character(1) | VARCHAR2(1) NOT NULL |
Authority to Approve Vouchers
Y/N Table Edit Default Value: N |
12 | VCHR_APPRVL_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Approval Limit |
13 | AUTH_POST_VOUCHER | Character(1) | VARCHAR2(1) NOT NULL |
Authority to Post Vouchers
Y/N Table Edit Default Value: N |
14 | AUTH_VCHR_GRP | Character(1) | VARCHAR2(1) NOT NULL |
Enter Vouchers Only in Groups
Y/N Table Edit Default Value: N |
15 | AUTH_SCHED_PYMNT | Character(1) | VARCHAR2(1) NOT NULL |
Manually Schedule Payments
Y/N Table Edit Default Value: N |
16 | USE_SOUND_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Use Sound Messages
Y/N Table Edit Default Value: N |
17 | AUTH_OVRRD_MATCH | Character(1) | VARCHAR2(1) NOT NULL |
Authority to Override Match
Y/N Table Edit Default Value: N |
18 | AUTH_PREPAY_VCHR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Prepay Voucher
Y/N Table Edit Default Value: N |
19 | PREPAY_LIMIT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Prepayment Limit Amount |
20 | AUTH_PAY_UNMTCHED | Character(1) | VARCHAR2(1) NOT NULL |
Pay Unmatched Vouchers
Y/N Table Edit Default Value: N |
21 | UNMATCH_PAY_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Pay Unmatched Limited |
22 | AUTH_CPY_MTCH_PO | Character(1) | VARCHAR2(1) NOT NULL |
Copy Matched and Closed PO
Y/N Table Edit Default Value: N |
23 | PYMNT_RCRD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Record Payment
Default Value: Y |
24 | AUTH_3RDPARTY_VCHR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Third Party Voucher
Y/N Table Edit Default Value: Y |
25 | AUTH_ADJUST_VCHR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Adjustment Voucher
Y/N Table Edit Default Value: Y |
26 | AUTH_JORUNAL_VCHR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Journal Voucher
Y/N Table Edit Default Value: Y |
27 | AUTH_REGISTER_VCHR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Register Voucher
Y/N Table Edit Default Value: Y |
28 | AUTH_REGULAR_VCHR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Regular Voucher
Y/N Table Edit Default Value: Y |
29 | AUTH_TEMPLATE_VCHR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Template Voucher
Y/N Table Edit Default Value: Y |
30 | AUTH_CORRECT_VCHR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Reversal Voucher
Y/N Table Edit Default Value: N |
31 | TMPLT_CHNG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Change Operator Entry Template
Y/N Table Edit Default Value: N |
32 | DFLT_SESSION_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Change Session Defaults
Y/N Table Edit Default Value: N |
33 | VCHR_ENTRY_CD | Character(10) | VARCHAR2(10) NOT NULL |
Voucher Entry Code
Prompt Table: VCHR_ENTRY_TMP |
34 | VCHR_DFLT_CD | Character(10) | VARCHAR2(10) NOT NULL |
Voucher Default Code
Prompt Table: VCHR_OPR_DFLTS |
35 | OVRD_ACCT_DT_EDIT | Character(1) | VARCHAR2(1) NOT NULL |
Override Accounting Date Edit
Y/N Table Edit Default Value: N |
36 | REAL_TIME_POST | Character(1) | VARCHAR2(1) NOT NULL |
Allow Real-Time Posting
Y/N Table Edit Default Value: N |
37 | AUTH_SGL_PYMNT_VCH | Character(1) | VARCHAR2(1) NOT NULL |
Allow Single Payment Voucher
Y/N Table Edit Default Value: Y |
38 | WTHD_CALC_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Override Withhold Calculation
Y/N Table Edit Default Value: N |
39 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
40 | QV_COMBO_EDIT | Character(1) | VARCHAR2(1) NOT NULL | Req. Valid Chart Field Combo's |