Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(20)   Default = '' User defined identification string
 DESCRIPTION nvarchar(100)   Default = '' Description of the disbursement format
 PAYMENTMETHODCODE tinyint   Default = 0 Payment method
 PAYMENTMETHOD nvarchar(5) (Computed) CASE [PAYMENTMETHODCODE] WHEN 0 THEN N'Check' END Provides a translation for the 'PAYMENTMETHODCODE' field.
 SORTTRANSACTIONSCODE tinyint   Default = 0 Field on which the transactions will be sorted by on the check stub.
 SORTTRANSACTIONS nvarchar(18) (Computed) CASE [SORTTRANSACTIONSCODE] WHEN 0 THEN N'Transaction number' WHEN 1 THEN N'Transaction date' END Provides a translation for the 'SORTTRANSACTIONSCODE' field.
 SORTORDERCODE tinyint   Default = 0 Sort order in which to sort the selected field
 SORTORDER nvarchar(10) (Computed) CASE [SORTORDERCODE] WHEN 0 THEN N'Ascending' WHEN 1 THEN N'Descending' END Provides a translation for the 'SORTORDERCODE' field.
 PRINTCUSTOMERNUMBER bit   Default = 1 Print the customer number on the check stub?
 PRINTSITEADDRESS bit   Default = 1 Print the site address on the check stub?
 PRINTSTUBLOGO bit   Default = 0 Print a log on the check stub?
 STUBLOGO varbinary Logo to print on the check stub.
 PRINTTRANSITABANUMBER bit   Default = 1 Print Transit ABA number on the check?
 PRINTORGANIZATIONNAME bit   Default = 1 Print organization name on the check?
 ORGANIZATIONNAME nvarchar(100)   Default = '' The organization name to print on the check.
 PRINTMESSAGE bit   Default = 1 Print message on the check?
 MESSAGE1 nvarchar(60)   Default = '' Message 1 to print on the check.
 MESSAGE2 nvarchar(60)   Default = '' Message 2 to print on the check.
 PRINTCHECKLOGO bit   Default = 0 Print the organization or bank logo on the check?
 CHECKLOGO varbinary Logo of the organization or bank to print on the check.
 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.
 TYPECODE tinyint   Default = 0 The type of disbursement form template
 PRENUMBERED bit   Default = 1 Is the stock pre-numbered?
 PRINTTRANSACTIONSORDERCODE tinyint   Default = 0 Field on which the disbursements will be sorted by for print order.
 PRINTTRANSACTIONSORDER nvarchar(19) (Computed) CASE [PRINTTRANSACTIONSORDERCODE] WHEN 0 THEN N'Payee' WHEN 1 THEN N'Disbursement amount' END Provides a translation for the 'PRINTTRANSACTIONSORDERCODE' field.
 PRINTORDERCODE tinyint   Default = 0 Sort order in whihc to sort the selected field
 PRINTORDER nvarchar(10) (Computed) CASE [PRINTORDERCODE] WHEN 0 THEN N'Ascending' WHEN 1 THEN N'Descending' END Provides a translation for the 'PRINTORDERCODE' field.
 PRINTNUMBER bit   Default = 1 Allow to selectively print the disbursement number for pre-numbered stock
 TYPE nvarchar(11) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Pre-printed' WHEN 1 THEN N'Blank' END Provides a translation for the 'TYPECODE' field.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 REPORTCATALOGID uniqueidentifier   REPORTCATALOG.ID The Report Spec used by this document

Index Name Field(s) Unique Primary Clustered
 IX_DISBURSEMENTFORMAT_DATEADDED DATEADDED    
 IX_DISBURSEMENTFORMAT_DATECHANGED DATECHANGED      
 PK_DISBURSEMENTFORMAT ID  

Trigger Name Description
 TR_DISBURSEMENTFORMAT_AUDIT_UPDATE
 TR_DISBURSEMENTFORMAT_AUDIT_DELETE

Referenced by Field
 DISBURSEMENTPROCESSFORMAT DISBURSEMENTFORMATID
 DISBURSEMENTPROCESSTEMPLATEFORMAT DISBURSEMENTFORMATID

Entity-Relationship diagram of this table