Primary Key Field Type
 ID uniqueidentifier

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) CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   FINANCIALTRANSACTIONLINEITEM.ID Primary Key.
 BILLINGITEMID uniqueidentifier   BILLINGITEM.ID Foreign key to the billing item table
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_RECEIVABLECREDITLINEITEM_DATEADDED DATEADDED    
 IX_RECEIVABLECREDITLINEITEM_DATECHANGED DATECHANGED      
 PK_RECEIVABLECREDITLINEITEM ID  

Trigger Name Description
 TR_RECEIVABLECREDITLINEITEM_VALIDBILLINGTYPEFORRECEIVABLECREDIT
 TR_RECEIVABLECREDITLINEITEM_AUDIT_UPDATE
 TR_RECEIVABLECREDITLINEITEM_AUDIT_DELETE
 TR_RECEIVABLECREDITLINEITEM_BILLINGITEMVALID
 TR_RECEIVABLECREDITLINEITEM_LINEITEMANDCREDITAREVALID

Referenced by Field
 CHARGERECEIVABLECREDITLINEITEMS RECEIVABLECREDITLINEITEMID

Entity-Relationship diagram of this table