CS_WIZARD_DEFN

(SQL Table)
 Index Back

Wizard Definition

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

  • Related Language Record: CS_WIZDEFN_LNG

    • # 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_WIZARD_TYPE Character(1) VARCHAR2(1) NOT NULL Wizard Type
    1=Document Creation
    2=Configurator Selection

    Default Value: 1

    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    5 CS_INACTIVE Character(1) VARCHAR2(1) NOT NULL Wizard Status
    A=Available
    D=Draft

    Default Value: D

    6 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

    7 CS_INSTRUCTIONS Character(254) VARCHAR2(254) NOT NULL Description
    8 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date