Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' Process template name.
 DESCRIPTION nvarchar(255)   Default = '' Process template description.
 TYPECODE tinyint   Default = 0 Disbursement process template type.
 FILTERCODE tinyint   Default = 0 Type of transaction filter to use in the process.
 FILTER nvarchar(32) (Computed) CASE [FILTERCODE] WHEN 0 THEN N'Include transactions by due date' WHEN 1 THEN N'Include all unpaid transactions' WHEN 2 THEN N'Include selected transactions' END Provides a translation for the 'FILTERCODE' field.
 DUEDATENUMBEROFDAYS int   Default = 0 Transaction with due dates equal to or less than X number of days before or after this process runs.
 DUEDATECODE tinyint   Default = 0 Include transaction with due date before or after this process runs
 DUEDATE nvarchar(6) (Computed) CASE [DUEDATECODE] WHEN 0 THEN N'After' WHEN 1 THEN N'Before' END Provides a translation for the 'DUEDATECODE' field.
 INCLUDEINVOICESWITHDISCOUNT bit   Default = 0 Include invoices with discount expiration dates equal to or less than X number of days before or after this process runs.
 DISCOUNTDATENUMBEROFDAYS int   Default = 0 Invoices with discount expiration dates equal to or less than X number of days before or after this process runs.
 DISCOUNTDATECODE tinyint   Default = 0 Include invoices with discount expiration date before or after this process runs.
 DISCOUNTDATE nvarchar(6) (Computed) CASE [DISCOUNTDATECODE] WHEN 0 THEN N'After' WHEN 1 THEN N'Before' END Provides a translation for the 'DISCOUNTDATECODE' field.
 CALCULATEDISCOUNTDAYS int   Default = 0 Calculate discounts as of X number of days before this process runs.
 DISBURSEMENTDATENUMBEROFDAYS int   Default = 0 Assign the disbursement date equal to X number of days after this process runs.
 POSTSTATUSCODE tinyint   Default = 1 Post status
 POSTDATENUMBEROFDAYS int   Default = 0 Assign the post date equal to X number of days after this process runs.
 CREATESELECTIONFROMRESULT bit   Default = 0 Create selection from results.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the output ID set to be created by the disbursement process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 SIGNATURE1OPTIONCODE tinyint   Default = 1 Auto-signature 1 options
 SIGNATURE1OPTION nvarchar(33) (Computed) CASE [SIGNATURE1OPTIONCODE] WHEN 0 THEN N'Always print this signature' WHEN 1 THEN N'Do not print a signature' WHEN 2 THEN N'Print a signature based on amount' END Provides a translation for the 'SIGNATURE1OPTIONCODE' field.
 SIGNATURE2OPTIONCODE tinyint   Default = 1 Auto-signature 2 options
 SIGNATURE2OPTION nvarchar(33) (Computed) CASE [SIGNATURE2OPTIONCODE] WHEN 0 THEN N'Always print this signature' WHEN 1 THEN N'Do not print a signature' WHEN 2 THEN N'Print a signature based on amount' END Provides a translation for the 'SIGNATURE2OPTIONCODE' 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.
 TYPE nvarchar(21) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Payables disbursement' END Provides a translation for the 'TYPECODE' field.
 POSTSTATUS nvarchar(11) (Computed) CASE [POSTSTATUSCODE] WHEN 1 THEN N'Not posted' WHEN 3 THEN N'Do not post' END Provides a translation for the 'POSTSTATUSCODE' field.

Foreign Key Field Type Null Notes Description
 BANKACCOUNTID uniqueidentifier   BANKACCOUNT.ID Open bank account
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID Transaction selection
 OUTPUTIDSETRECORDTYPEID uniqueidentifier RECORDTYPE.ID A foreign key to the record type of the output ID set to be created by the disbursement process.
 SIGNATURE1ID uniqueidentifier BANKACCOUNTAUTHORIZEDSIGNATURE.ID Auto-Signature 1 to print on a disbursement
 SIGNATURE2ID uniqueidentifier BANKACCOUNTAUTHORIZEDSIGNATURE.ID Auto-Signature 2 to print on a disbursement
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_DISBURSEMENTPROCESSTEMPLATE_DATEADDED DATEADDED    
 IX_DISBURSEMENTPROCESSTEMPLATE_DATECHANGED DATECHANGED      
 PK_DISBURSEMENTPROCESSTEMPLATE ID  
 UC_DISBURSEMENTPROCESSTEMPLATE_NAME NAME    

Trigger Name Description
 TR_DISBURSEMENTPROCESSTEMPLATE_AUDIT_UPDATE
 TR_DISBURSEMENTPROCESSTEMPLATE_AUDIT_DELETE
 TR_DISBURSEMENTPROCESSTEMPLATE_BANKACCOUNTSIGNATURESNOTASSIGNED

Referenced by Field
 DISBURSEMENTPROCESSTEMPLATEFORMAT DISBURSEMENTPROCESSTEMPLATEID
 DISBURSEMENTPROCESSTEMPLATESIGNATURE DISBURSEMENTPROCESSTEMPLATEID

Entity-Relationship diagram of this table