CS_WIZARD_DETL (SQL Table)	Index Back
Wizard Details /* 11/11/2011 TBG SCMT-92-MDEM-04 Add changes for Wizard/QGroup handling of AUC Sourcing */

CS_WIZARD_DETL

(SQL Table)

Wizard Details

/* 11/11/2011 TBG SCMT-92-MDEM-04 Add changes for Wizard/QGroup handling of AUC Sourcing */

# 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_WIZARD_ID Character(30) VARCHAR2(30) NOT NULL Wizard ID

3 CS_QUESTGRP Character(30) VARCHAR2(30) NOT NULL Question Group
Prompt Table: %EDITTABLE

4 CS_DISPLAY_SEQ Number(3,0) SMALLINT NOT NULL Display Sequence

5 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
Prompt Table: CS_SRC_TRAN_VW1

#	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_WIZARD_ID	Character(30)	VARCHAR2(30) NOT NULL	Wizard ID
3	CS_QUESTGRP	Character(30)	VARCHAR2(30) NOT NULL	Question Group Prompt Table: %EDITTABLE
4	CS_DISPLAY_SEQ	Number(3,0)	SMALLINT NOT NULL	Display Sequence
5	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 Prompt Table: CS_SRC_TRAN_VW1