BUSINESS_UNITAUC_IDAUC_ROUNDAUC_VERSIONBID_FACTOR_NBRCS_OBJECT_IDPrompt Table:
AUC_CLAUSE_VW
Set Control Field: BUSINESS_UNIT
AUC_PARENT_CLS_IDF=Full Text
R=By Reference Text
Default Value: F
Y/N Table Edit
Default Value: N
RESP_XL_CLSH_VW(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT , AUC_ID , AUC_ROUND , AUC_VERSION , BID_FACTOR_NBR , CS_OBJECT_ID , AUC_PARENT_CLS_ID , SEQ_NBR_5 , CS_BODY_TYPE , CNTRCT_FCTR_FLG , ORDERBYNUM FROM PS_AUC_HDR_FCT_CLS WHERE 1 = 2 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | AUC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 3 | AUC_ROUND |
Number(5,0) | INTEGER NOT NULL | Event Round |
| 4 | AUC_VERSION |
Number(5,0) | INTEGER NOT NULL | Event Version |
| 5 | BID_FACTOR_NBR |
Number(10,0) | DECIMAL(10) NOT NULL | Bid Factor Number |
| 6 | CS_OBJECT_ID |
Character(20) | VARCHAR2(20) NOT NULL |
Object id -- clause, section
Prompt Table:
AUC_CLAUSE_VW
|
| 7 | AUC_PARENT_CLS_ID |
Character(20) | VARCHAR2(20) NOT NULL | Parent Clause ID |
| 8 | SEQ_NBR_5 | Number(5,0) | INTEGER NOT NULL | Sequence number five digits long |
| 9 | CS_BODY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
indicates body type -- full or by ref for clause/section
F=Full Text R=By Reference Text Default Value: F |
| 10 | CNTRCT_FCTR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include on Contract
Y/N Table Edit Default Value: N |
| 11 | ORDERBYNUM | Number(3,0) | SMALLINT NOT NULL | Order-By Number |