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