CS_SOURCE_TRANS01=Ad Hoc
02=Purchasing Contracts
03=Purchase Orders
04=Sourcing Events
97=All Sources
98=Multiple Sources
99=Not Transactional
Default Value: 02
CS_BIND_RECNAMEPrompt Table: CS_RECVIEW_VW
Prompt Table: CS_SRC_STRUCT
CS_BIND_MAP(SQL Table) |
Index Back |
|---|---|
Record Mapscel 10/2007 -- added new field cs_release_added -- need this to help with upgrades when we add new rows. Any rows that we want to deliver we need to enter with the release we are adding it .. and need to use upgrade script to make sure it's okay to add depending on their data. See the 9.1 upgrade for more detail/example of this. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 Default Value: 02 |
| 2 | CS_BIND_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Binds Recordname
Prompt Table: CS_RECVIEW_VW |
| 3 | CS_SRC_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Source Record
Prompt Table: CS_SRC_STRUCT |
| 4 | CS_RELEASE_ADDED | Character(5) | VARCHAR2(5) NOT NULL | Release Added |