CNTRCT_STYLESETIDPrompt Table: SP_SETID_NONVW
CS_DOCUMENT_TYPE001=Main Document
002=Amendment
003=Preview Document
004=Compare File
Prompt Table: CS_DOCT_USER_VW
A=Active
I=Inactive
CNTRCT_STYLE_DT(SQL Table) |
Index Back |
|---|---|
Contract Styles Doc Types11/15/2015 JOHAN PO0025 - Master contract fluid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CNTRCT_STYLE |
Character(10) | VARCHAR2(10) NOT NULL | Contract Style |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 3 | CS_DOCUMENT_TYPE |
Character(20) | VARCHAR2(20) NOT NULL |
Document Type
001=Main Document 002=Amendment 003=Preview Document 004=Compare File Prompt Table: CS_DOCT_USER_VW |
| 4 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive |