SF_OP_DC_TMP

(SQL Table)
Index Back

Operation Documents tmp

9/10/97 rlk - resave for unique key issue on dddaudit

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUMGOP_NONVW

2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

Prompt Table: SF_OP_MTN_VW

3 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
4 DC_OBJECT_ID Character(16) VARCHAR2(16) NOT NULL Document Object ID
5 DC_FIXED Character(1) VARCHAR2(1) NOT NULL fixed to specific doc version
N=No
Y=Yes

Y/N Table Edit

Default Value: N

6 DC_OBJECT_NAME Character(254) VARCHAR2(254) NOT NULL Document Name
7 DC_TITLE Character(64) VARCHAR2(64) NOT NULL Title