Table Name:	amort_dtl
Table Number:	5055
Group:	Sales Mgr
Description:	Represents the amount of a contract line item billing component that applies to a specific billing period
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_amort_dtl

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
bill_prd_amt	DECIMAL	decimal (19,4)				CURRENCY	The amortized amount for a billing component
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
last_gen_dt	CLK_TIME	datetime					The date time that the object was generated. This corresponds to a run of the aggregator function
net_prd_amt	DECIMAL	decimal (19,4)				CURRENCY	Net amount associated with the detail
objid	LONG	int	3			DIRECT	Internal record number
prd_end_dt	CLK_TIME	datetime					The last date of the billing period
prd_start_dt	CLK_TIME	datetime					The start date of the billing period

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
amort_dtl2contr_itm	MTO	contr_itm	contr_itm2amort_dtl	Related contract line item
amort_dtl2contr_pr	MTO	contr_pr	contr_pr2amort_dtl	Related price adjustment
detail2contr_schedule	MTO	contr_schedule	schedule2amort_dtl	Related contract schedule. For schedule-level billing components
amort_dtl2period_amt	MTO	period_amt	period_amt2amort_dtl	Sum of billing period components
detail2trans_record	MTO	trans_record	detail2amort_dtl	Transferred amount including the detail

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
amort_dtl_ind	prd_start_dt:last_gen_dt:amort_dtl2contr_itm:amort_dtl2contr_pr:detail2contr_schedule	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
amort_dtl_ind	prd_start_dt, last_gen_dt, amort_dtl2contr_itm, amort_dtl2contr_pr, detail2contr_schedule	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

amort_dtl

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user