AUC_CLAUSE_TMP(SQL Table) |
Index Back |
|---|---|
Temp record used for clauses.Used for displaying exploded clause data in Bid Factor Setup component And Alternate Clause data in Event Create component. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CS_OBJECT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles
0001=Clause 0002=Section 0003=Ad Hoc Clause 0004=Rule 0005=Bind Variables 0006=Wizard Definition 0007=Document Configurator 0008=Document 0015=Word Template 1000=All Default Value: 0001 |
| 3 | CS_OBJECT_ID | Character(20) | VARCHAR2(20) NOT NULL | Object id -- clause, section |
| 4 | AUC_PARENT_CLS_ID | Character(20) | VARCHAR2(20) NOT NULL | Parent Clause ID |
| 5 | CS_ALT_OBJID | Character(30) | VARCHAR2(30) NOT NULL | Alternate ID |
| 6 | CS_TITLE | Character(254) | VARCHAR2(254) NOT NULL | title |
| 7 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 8 | NUM_CHILDREN | Number(3,0) | SMALLINT NOT NULL | Number of children |
| 9 | ALTS_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
cel - alternates exist flag in Contract Management
Y/N Table Edit Default Value: N |
| 10 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes Default Value: N |
| 11 | CS_BODY | Long Character | CLOB | stores the body text for clause/section. |