OPR_DEF_TBL_VND

(SQL Table)
Index Back

Operator Defaults - Suppliers

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_FS.OPRID

Prompt Table: OPRID_VW

2 AUTH_VNDR_UNCERTFY Character(1) VARCHAR2(1) NOT NULL Supplier Entered Status

Y/N Table Edit

Default Value: N

3 AUTH_VNDR_CERTFY Character(1) VARCHAR2(1) NOT NULL Supplier Active Status

Y/N Table Edit

Default Value: N

4 AUTH_VNDR_INACT_ST Character(1) VARCHAR2(1) NOT NULL Supplier Inactive Status

Y/N Table Edit

Default Value: N

5 AUTH_VNDR_HIR Character(1) VARCHAR2(1) NOT NULL Authority to View Supplier Hierarchy

Default Value: N

6 AUTH_VNDR_AUDIT Character(1) VARCHAR2(1) NOT NULL Supplier Audit

Y/N Table Edit

Default Value: Y