OPR_DEF_TBL_CS(SQL Table) |
Index Back |
|---|---|
Supplier Contract Management |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |