Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 PAYMENT bit   Default = 0 Indicates whether payments are automatically applied
 CREDIT bit   Default = 0 Indicates whether payments are automatically applied
 CHARGE bit   Default = 0 Indicates whether payments are automatically applied
 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.
 ACCOUNTINGMETHODCODE bit (Computed) dbo.UFN_CONDITIONSETTING_EVALUATEEXISTSCONDITION('OpenItem') Returns the accounting method. 0 - Balance forward; 1 - Open item.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_APPLICATIONRULES_DATEADDED DATEADDED    
 IX_APPLICATIONRULES_DATECHANGED DATECHANGED      
 PK_APPLICATIONRULES ID  

Trigger Name Description
 TR_APPLICATIONRULES_ONLYONEROW
 TR_APPLICATIONRULES_AUDIT_UPDATE
 TR_APPLICATIONRULES_AUDIT_DELETE