CS_SRC_STRUCT(SQL Table) |
Index Back |
---|---|
Source Trans Record Structure |
# | 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_SRC_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Source Record
Prompt Table: PSRECDEFN |
3 | CS_LEVEL | Number(2,0) | SMALLINT NOT NULL | Level |
4 | CS_PAR_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Parent Record
Prompt Table: PSRECDEFN |
5 | CS_PSOFT_ADDED | Character(1) | VARCHAR2(1) NOT NULL |
PeopleSoft Added
Y/N Table Edit Default Value: N |