AUC_STDCOM_VW

(SQL View)
Index Back

Auctions Std Comments Search


SELECT A.SETID , A.STD_COMMENT_TYPE , A.STD_COMMENT_ID , A.DESCR FROM PS_AUC_STD_COM_TBL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 STD_COMMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Standard Comment Type

Prompt Table: AUC_STD_COM_TYP

3 STD_COMMENT_ID Character(4) VARCHAR2(4) NOT NULL Standard Comment ID

Prompt Table: AUC_STD_COM_SRC

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description