Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
appl_id	CHAR	varchar		20			Clarify application using the dataset. Not mappable
approved	LONG	tinyint				DIRECT	Approved status; i.e., 1=approved, 0=not approved (default). Not mappable	Search (1)
bill_to	CHAR	varchar		30			Organization, department, group to which the line item is to be billed
billable	LONG	tinyint				DIRECT	Indicates whether the line item is considered billable; i.e., 0=non-billable, 1=billable
case_id	CHAR	varchar		255			Case ID number of the case generating the billable charges. Not mappable
creation_date	CLK_TIME	datetime					Datetime that source event started
datetime_10	CLK_TIME	datetime					Transferred datetime
datetime_11	CLK_TIME	datetime					Transferred datetime
datetime_12	CLK_TIME	datetime					Transferred datetime
datetime_13	CLK_TIME	datetime					Transferred datetime
datetime_14	CLK_TIME	datetime					Transferred datetime
datetime_15	CLK_TIME	datetime					Transferred datetime
datetime_16	CLK_TIME	datetime					Transferred datetime
datetime_17	CLK_TIME	datetime					Transferred datetime
datetime_18	CLK_TIME	datetime					Transferred datetime
datetime_6	CLK_TIME	datetime					Transferred datetime
datetime_7	CLK_TIME	datetime					Transferred datetime
datetime_8	CLK_TIME	datetime					Transferred datetime
datetime_9	CLK_TIME	datetime					Transferred datetime
decimal_1	DECIMAL	decimal (19,4)				CURRENCY	Transferred decimal
decimal_2	DECIMAL	decimal (19,4)				CURRENCY	Transferred decimal
decimal_3	DECIMAL	decimal (19,4)				CURRENCY	Transferred decimal
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
expense_type	CHAR	varchar		20			Type of expense; available as a user-defined pop up list with default name EXPENSE_TYPE
extension	FLOAT	real				CURRENCY	Unit quantity times rate
extract_date	CLK_TIME	datetime					Datetime of the extract. Not mappable. Not mappable	Search (1)
focus_type	LONG	int				DIRECT	Object type ID (e.g., phone_log=28, expense_log=268) of the source object which furnishes the financial data. Not mappable
included	LONG	tinyint				DIRECT	Indicates whether the object will participate in summarization; i.e., 0=no, 1=yes. Not mappable
int_10	LONG	int				DIRECT	Transferred integer
int_11	LONG	int				DIRECT	Transferred integer
int_12	LONG	int				DIRECT	Transferred integer
int_13	LONG	int				DIRECT	Transferred integer
int_6	LONG	int				DIRECT	Transferred integer
int_7	LONG	int				DIRECT	Transferred integer
int_8	LONG	int				DIRECT	Transferred integer
int_9	LONG	int				DIRECT	Transferred integer
mod_crt_dt	CLK_TIME	datetime					Modified creation date as determined in a review/approval process. Not mappable
mod_extn	FLOAT	real				CURRENCY	Modified extension as determined in a review/approval process. Not mappable
mod_qty	FLOAT	real					Modified quantity as determined in a review/approval process. Not mappable
mod_rate	FLOAT	real				CURRENCY	Modified rate as determined in a review/approval process. Not mappable
mod_stop_dt	CLK_TIME	datetime					Modified stop date as determined in a review/approval process. Not mappable
mod_time	LONG	int				DIRECT	Modified elapsed time as determined in a review/approval process in seconds. Not mappable
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
part_number	CHAR	varchar		30			Part number of the installed part
quantity	FLOAT	real					Reported quantity in units
rate	FLOAT	real				CURRENCY	Reported per-unit amount
ref_objid	LONG	int				DIRECT	For detail-level data, the internal record number of the source object of the data. Not mappable
rem_part_num	CHAR	varchar		30			Part number/name of the removed part
rem_qty	FLOAT	real					Number of parts removed
rem_serial	CHAR	varchar		30			Serial number of the removed part
serial_no	CHAR	varchar		30			Serial number of the part
site_id	CHAR	varchar		80			Site ID number assigned according to auto-numbering definition. Not mappable
stop_date	CLK_TIME	datetime					Datetime that an source event ended
subtotal_cat	CHAR	varchar		10			States the category of a subtotal; i.e., e=expense, m=material, l=labor. Not mappable
time	LONG	int				DIRECT	Reported elapsed time in seconds
txn_comment	CHAR	varchar		255			User remark about the trans_record entry. Not mappable
varchar20_3	CHAR	varchar		20			Trasferred 20 byte character
varchar20_4	CHAR	varchar		20			Trasferred 20 byte character
varchar20_5	CHAR	varchar		20			Trasferred 20 byte character
varchar30_6	CHAR	varchar		30			Trasferred 20 byte character
varchar40_1	CHAR	varchar		40			Trasferred 40 byte character
varchar40_2	CHAR	varchar		40			Trasferred 40 byte character
varchar60_1	CHAR	varchar		60			Trasferred 60 byte character
varchar8_1	CHAR	varchar		8			Trasferred 8 byte character
varchar80_1	CHAR	varchar		80			Trasferred 80 byte character
varchar80_2	CHAR	varchar		80			Trasferred 80 byte character
varchar80_3	CHAR	varchar		80			Trasferred 80 byte character
varchar80_4	CHAR	varchar		80			Trasferred 80 byte character

Table Name:	trans_record
Table Number:	68
Group:	Invoice Interface
Description:	Holds data transferred (from source) objects based on user source-to-target mappings. Some fields are system controlled and not available for mapping. Reserved; custom
Flags:
Baseline/Custom:	Baseline

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views
detail2amort_dtl	OTM	amort_dtl	detail2trans_record	Amortization details amounts that are included in the trans_record
trans_record2case	MTO	case	case2trans_record	Source case for the extracted data	Search (1)
tr2contr_schedule	MTO	contr_schedule	sched2trans_record	Reserved; not used
trans_record2site	MTO	site	site2trans_record	Source site for the extracted data	Search (1)
trans_record2trans_map	MTO	trans_map	map2trans_record	Data mapping used for the trans_record
details2trans_record	MTO	trans_record	summary2trans_record	Summary record owning the record
summary2trans_record	OTM	trans_record	details2trans_record	Detail or summary records summarized by a summary record
trans_record2user	MTO	user	user2trans_record	User that approved the trans_record entry

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY
record_index	trans_record2trans_map, focus_type, ref_objid	nonclustered, unique located on PRIMARY

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog

Fields:

Relations:

Indexes: (Defined in Clarify Schema)

Indexes (Defined in Database):

Referenced in Views:

My Recent Objects

Quick Links