CS_BIND_MAP_DTL(SQL Table) |
Index Back |
|---|---|
Field Mapcel 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 |
| 3 | CS_BIND_VAR |
Character(30) | VARCHAR2(30) NOT NULL |
Bind Variable
Prompt Table: CS_BINDS_VW3 |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: CS_BINDFLD_VW |
| 5 | CS_DISPLAYTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Display Type
1=Xlat Long Name 2=Xlat Short Name 3=Xlat Value |
| 6 | CS_FIELD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bind Variable Field Type
5/11/07 F-AHAYT-X0ES6 - Added new field type of Prompt
1=String 3=Date 4=Date/Time 5=Yes/No 6=Integer 7=Decimal 8=Prompt Table 9=Checkbox |
| 7 | CS_RELEASE_ADDED | Character(5) | VARCHAR2(5) NOT NULL | Release Added |