ACCOUNTINGELEMENTRELATIONSHIPDETAIL (4.0SP20)

This table holds details about all accounting element relationships.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
ACCOUNTINGELEMENTRELATIONSHIPID	uniqueidentifier	true	ACCOUNTINGELEMENTRELATIONSHIP.ID	FK to ACCOUNTINGELEMENTRELATIONSHIP
DATAELEMENT1ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT2ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT3ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT4ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT5ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT6ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT7ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT8ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT9ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT10ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT11ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT12ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT13ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT14ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT15ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT16ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT17ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT18ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT19ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT20ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT21ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT22ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT23ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT24ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT25ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT26ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT27ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT28ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT29ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
DATAELEMENT30ID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
BASEELEMENTID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	FK to PDACCOUNTSEGMENTVALUE
ACCOUNTID	uniqueidentifier	true	GLACCOUNT.ID	Account ID

Fields
Field	Field Type	Null	Notes	Description
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
RESTRICTIONCODE	tinyint	false	1	Whether this relationship detail is allowed or restricted.
RESTRICTION	nvarchar(55) (Computed)	true		Provides a translation for the 'RESTRICTIONCODE' field.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_ACCOUNTINGELEMENTRELATIONSHIPDETAIL_ACCOUNTINGELEMENTRELATIONSHIPID	ACCOUNTINGELEMENTRELATIONSHIPID	False	False	False
IX_ACCOUNTINGELEMENTRELATIONSHIPDETAIL_DATEADDED	DATEADDED	False	False	True
IX_ACCOUNTINGELEMENTRELATIONSHIPDETAIL_DATECHANGED	DATECHANGED	False	False	False
PK_ACCOUNTINGELEMENTRELATIONSHIPDETAIL	ID	True	True	False

Triggers
Trigger Name	Description
TR_ACCOUNTINGELEMENTRELATIONSHIPDETAIL_AUDIT_UPDATE
TR_ACCOUNTINGELEMENTRELATIONSHIPDETAIL_AUDIT_DELETE
TR_ACCOUNTINGELEMENTRELATIONSHIPDETAIL_INSUPD