CS_DOC_REL_HIST

(SQL Table)
Index Back

History of Related Contracts

4/2008 cel added visible to supplier flag

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
2 CS_DOC_ATT_VER Number(3,0) SMALLINT NOT NULL This is the cycle/seq nbr that indicates the change interation/version that the normal attachments are on. Since we want to save them off in history
3 CS_REL_DOC_ID Character(25) VARCHAR2(25) NOT NULL Related Doc ID
4 EXT_FLAG Character(1) VARCHAR2(1) NOT NULL External Resource

Y/N Table Edit

5 CS_VISIBLE_EXT Character(1) VARCHAR2(1) NOT NULL Visible to Supplier

Y/N Table Edit

Default Value: N