Table Name:	fcs_header
Table Number:	250
Group:	obsolete
Description:	Reserved; custom
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_fcs_header

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
header_status	CHAR	varchar		20			Reserved; custom
objid	LONG	int	3			DIRECT	Reserved; custom
req_case_num	CHAR	varchar		15			Reserved; custom
req_originator	CHAR	varchar		30			Reserved; custom
request_date	CLK_TIME	datetime					Reserved; custom
request_note	CHAR	varchar		255			Reserved; custom
ship_addr1	CHAR	varchar		200			Reserved; custom
ship_addr2	CHAR	varchar		200			Reserved; custom
ship_attn	CHAR	varchar		30			Reserved; custom
ship_city	CHAR	varchar		30			Reserved; custom
ship_country	CHAR	varchar		40			Reserved; custom
ship_state	CHAR	varchar		40			Reserved; custom
ship_zip	CHAR	varchar		20			Reserved; custom
site_name	CHAR	varchar		80			Reserved; custom

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
req_by2case	MTO	case	case_info2fcs_header	Reserved; custom
fcs_header2fcs_detail	OTM	fcs_detail	fcs_detail2fcs_header	Reserved; custom
req_by2subcase	MTO	subcase	subc_info2fcs_header	Reserved; custom
cur_owner2owner	MTO	user	curr_owner2fcs_header	Reserved; custom

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

fcs_header

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user