Table Name:	expense_log
Table Number:	268
Group:	Workflow Mgr
Description:	Expenses incurred for an activity
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_expense_log

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
bill_to	CHAR	varchar		40			Organization, department, group to which the line item is to be billed; defined as a user-defined pop up list with default name BILL_TO_EXPENSE
billable	LONG	int				DIRECT	Indicates whether the line item is considered billable; i.e., 0=non-billable, 1=billable
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
expense_type	CHAR	varchar		40			Type of expense; defined as a user-defined pop up list with default name EXPENSE_TYPE
objid	LONG	int	3			DIRECT	Internal record number
quantity	FLOAT	real					Number of units; implied by expense type; e.g., if the expense type is mileage, the units are miles
rate	FLOAT	real				CURRENCY	Currency per unit of expense
removed	LONG	int			0	DIRECT	Indicates the logical removal of the log object; i.e., 0=present, 1=removed, default=0
total	FLOAT	real				CURRENCY	Total expense=rate * quantity

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
expense2onsite_log	MTO	onsite_log	onsite_log2expense	Related time & expense log

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

expense_log

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user