CS_CNT_STAGE(SQL Table) |
Index Back |
---|---|
Validation DetailsStaging and validation record for staged contracts. Contains results of any failed validations |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
2 | CS_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Contract Action Flag
D=Delete N=None R=Reprocess Default Value: R |
3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
4 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL |
Buying Agreement ID
Default Value: NEXT |
5 | CNTRCT_ID_DISTRIB | Character(25) | VARCHAR2(25) NOT NULL |
Distributor Contract ID
Default Value: NEXT |
6 | CHUNK_NBR | Number(3,0) | SMALLINT NOT NULL | Chunk Sequence Number |
7 | CHUNKCOUNT | Number(9,0) | DECIMAL(9) NOT NULL | Chunk Count |
8 | SUBNODE | Character(30) | VARCHAR2(30) NOT NULL | Subscribing Node |
9 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
10 | CS_CNTRCT_LOAD | Character(1) | VARCHAR2(1) NOT NULL | Contract Load |
11 | CS_BODY | Long Character | CLOB | stores the body text for clause/section. |