OPR_DEF_TBL_CS(SQL Table) |
Index Back |
---|---|
Supplier Contract Management |
# | 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 | CS_UPDATE_CURRENT | Character(1) | VARCHAR2(1) NOT NULL |
Reset to Dispatch
Y/N Table Edit Default Value: N |
3 | CS_FULL_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Full Authorization for All Doc
Y/N Table Edit Default Value: N |
4 | CS_ADMIN_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Document Administrator
Y/N Table Edit |
5 | CS_SECT_APPR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Approve Sections
Y/N Table Edit Default Value: N |
6 | CS_TMPL_APPR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Configurator Status Change
Y/N Table Edit Default Value: N |
7 | CS_SKIP_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL |
Bypass Approval
Y/N Table Edit Default Value: N |
8 | CS_IMPORT_APPR | Character(1) | VARCHAR2(1) NOT NULL |
Import Document
Y/N Table Edit Default Value: N |
9 | CS_DEF_CL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Default Clause Status
A=Approved I=Initial Default Value: I |
10 | CS_DEF_SEC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Default Section Status
A=Approved I=Initial Default Value: I |
11 | CS_DEL_DOC | Character(1) | VARCHAR2(1) NOT NULL |
Delete Documents
Y/N Table Edit Default Value: N |