Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 DEFAULTDUEDATE bit   Default = 0 Indicates whether charge is using default due date.
 DEFAULTTYPECODE tinyint   Default = 0 Flag indicating which default option is used.
 DEFAULTTYPE nvarchar(47) (Computed) CASE [DEFAULTTYPECODE] WHEN 0 THEN N'Specified number of days after transaction date' WHEN 1 THEN N'The selected day of the selected month' WHEN 2 THEN N'The same transaction date next month' END Provides a translation for the 'DEFAULTTYPECODE' field.
 NUMBEROFDAYS smallint   Default = ((0))
 SPECIFIEDDAY smallint   Default = ((1))
 SPECIFIEDMONTHCODE tinyint   Default = 0 Flag indicating which month is used.
 SPECIFIEDMONTH nvarchar(7) (Computed) CASE [SPECIFIEDMONTHCODE] WHEN 0 THEN N'current' WHEN 1 THEN N'next' END Provides a translation for the 'SPECIFIEDMONTHCODE' field.
 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
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_CHARGEDEFAULTS_DATEADDED DATEADDED    
 IX_CHARGEDEFAULTS_DATECHANGED DATECHANGED      
 PK_CHARGEDEFAULTS ID  

Trigger Name Description
 TR_CHARGEDEFAULTS_ONLYONEROW
 TR_CHARGEDEFAULTS_AUDIT_UPDATE
 TR_CHARGEDEFAULTS_AUDIT_DELETE