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