CS_DOC_ALLK_TMP

(SQL Table)
Index Back

Keys for All Doc Sources

Keys for all Doc Sources in Supply Contract Mgmt. This record is mostly used in reporting, to reduce the need and complexity of left outer joins.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
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_SETID_VAR Character(5) VARCHAR2(5) NOT NULL Variable SetID
5 CS_CNTRCT_VAR Character(25) VARCHAR2(25) NOT NULL Variable Contract Document ID
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 CS_ADHOC_ID Character(25) VARCHAR2(25) NOT NULL Ad Hoc ID
8 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
9 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
10 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
12 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
13 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
14 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
15 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version