| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
CS_DOCUMENT_TYPE |
Character(20) |
VARCHAR2(20) NOT NULL |
Document Type
001=Main Document
002=Amendment
003=Preview Document
004=Compare File
|
| 3 |
CS_SOURCE_TRANS |
Character(2) |
VARCHAR2(2) NOT NULL |
Source Transaction
03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction
01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring)
01=Ad Hoc
02=Purchasing Contracts
03=Purchase Orders
04=Sourcing Events
97=All Sources
98=Multiple Sources
99=Not Transactional
|
| 4 |
CS_DOCTYPE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
SCC 12/05/05: Document Type Status
01=Available
02=Obsolete
Default Value: 01
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 7 |
CS_TEMPLATE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
SCC 09/01/04
Prompt Table:
CS_TEMPLATE_DVW
|
| 8 |
CS_WIZARD_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Wizard ID
Prompt Table:
CS_WIZ_CFGSL_VW
|
| 9 |
BEG_SEQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Start Sequence
Prompt Table:
CS_AUTONUM_VW
|
| 10 |
CS_ENABLE_PO_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Only with PO Requisitions
Y/N Table Edit
Default Value: N
|
| 11 |
CS_AUTO_GEN_DOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatic Document Creation
Y/N Table Edit
Default Value: N
|
| 12 |
CS_WIZ_RESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Prior Doc Wiz Respons
Y/N Table Edit
Default Value: N
|
| 13 |
CS_PRIOR_DOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Start from another source
Y/N Table Edit
Default Value: N
|
| 14 |
CS_APPL_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
SCC 12/13/05: Applicable Statuses for document type
01=Draft, Complete Statuses Only
02=Draft, Approve Statuses Only
03=Full Life Cycle Statuses
Default Value: 01
|
| 15 |
CS_USAGE |
Character(2) |
VARCHAR2(2) NOT NULL |
Internal Document
01=External Document
02=Internal Document
Default Value: 01
|
| 16 |
CS_EDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Edit
Y/N Table Edit
Default Value: Y
|
| 17 |
CS_COLLABORATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Internal Collaboration
Y/N Table Edit
Default Value: Y
|
| 18 |
CS_TEMPLATE_AMEND |
Character(20) |
VARCHAR2(20) NOT NULL |
SCC 09/01/04
Prompt Table:
CS_TEMPLATE_DVW
|
| 19 |
CS_EX_SUMM_TMPL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Executive Summary Configurator
Prompt Table:
CS_TEMPLATE_DVW
|
| 20 |
CS_USE_EXT_COLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable External Collaboration
Y/N Table Edit
Default Value: N
|
| 21 |
CS_INTERNAL_SIGS |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Internal Signatures
Y/N Table Edit
Default Value: N
|
| 22 |
CS_SIGN_PRIOR_APR |
Character(1) |
VARCHAR2(1) NOT NULL |
Prior to Approvals
Y/N Table Edit
Default Value: N
|
| 23 |
CS_SIGN_DURING_APR |
Character(1) |
VARCHAR2(1) NOT NULL |
During Approvals
Y/N Table Edit
Default Value: N
|
| 24 |
CS_SIGN_AFTER_APR |
Character(1) |
VARCHAR2(1) NOT NULL |
After Approvals
Y/N Table Edit
Default Value: N
|
| 25 |
CS_EXTERNAL_SIGS |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable External Signatures
Y/N Table Edit
Default Value: N
|
| 26 |
CS_CYCLE_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Cycle Time per Document
Default Value: 0
|
| 27 |
CS_CYCLE_DAY_AMEND |
Number(4,0) |
SMALLINT NOT NULL |
Cycle Time for Amendments
Default Value: 0
|
| 28 |
CS_ENABLE_CYCLES |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Cyle Time
Y/N Table Edit
Default Value: N
|
| 29 |
CS_BUS_CALENDAR |
Character(20) |
VARCHAR2(20) NOT NULL |
Business Calendar
Prompt Table:
BUS_CAL_HOL_DFN
|
| 30 |
CS_DAYS_RED |
Number(3,0) |
SMALLINT NOT NULL |
Red
Default Value: 0
|
| 31 |
CS_DAYS_YELLOW |
Number(3,0) |
SMALLINT NOT NULL |
Yellow
Default Value: 0
|
| 32 |
CS_DAYS_RED_AMEND |
Number(3,0) |
SMALLINT NOT NULL |
Red
Default Value: 0
|
| 33 |
CS_DAYS_YELL_AMEND |
Number(3,0) |
SMALLINT NOT NULL |
Yellow
Default Value: 0
|
| 34 |
CS_CYCLE_COMPLETE |
Character(2) |
VARCHAR2(2) NOT NULL |
Complete When Status is
AA=Approved
AP=Pending Approval
DS=Dispatched
EX=Executed/Complete
Default Value: EX
|
| 35 |
CS_USER_FLD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Option for User Defined Fields
1=No User Defined Fields
2=All User Defined Fields
3=Select User Defined Fields
Default Value: 1
|
| 36 |
CS_LOG_VIEW_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Log View Action in History
Y/N Table Edit
Default Value: N
|