ACCOUNTINGELEMENTRELATIONSHIPDETAIL

This table holds details about all accounting element relationships.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
DATEADDED	datetime		Default = getdate()	Indicates the date this record was added.
DATECHANGED	datetime		Default = getdate()	Indicates the date this record was last changed.
TS	timestamp			Timestamp.
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.
RESTRICTIONCODE	tinyint		Default = 1	Whether this relationship detail is allowed or restricted.
RESTRICTION	nvarchar(55) (Computed)	yes	CASE [RESTRICTIONCODE] WHEN 1 THEN N'Allow use of selected elements with basis element(s)' WHEN 2 THEN N'Restrict use of selected elements with basis element(s)' END	Provides a translation for the 'RESTRICTIONCODE' field.

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_ACCOUNTINGELEMENTRELATIONSHIPDETAIL_ACCOUNTINGELEMENTRELATIONSHIPID	ACCOUNTINGELEMENTRELATIONSHIPID
IX_ACCOUNTINGELEMENTRELATIONSHIPDETAIL_DATEADDED	DATEADDED			yes
IX_ACCOUNTINGELEMENTRELATIONSHIPDETAIL_DATECHANGED	DATECHANGED
PK_ACCOUNTINGELEMENTRELATIONSHIPDETAIL	ID	yes	yes

Triggers

Trigger Name	Description
TR_ACCOUNTINGELEMENTRELATIONSHIPDETAIL_AUDIT_UPDATE
TR_ACCOUNTINGELEMENTRELATIONSHIPDETAIL_AUDIT_DELETE
TR_ACCOUNTINGELEMENTRELATIONSHIPDETAIL_INSUPD