Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' Name
 DESCRIPTION nvarchar(255)   Default = '' 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.
 DUEDATE date Transactions are included when their due date is equal or less than this date.
 DISCOUNTDATE date Transactions are included when their discount expiration date is equal or less than this date.
 DISCOUNTASOFDATE date   Discounts are calculated as of this date.
 DISBURSEMENTDATE date   Use this date for the generated disbursements.
 POSTSTATUSCODE tinyint   Default = 1 Post status for the generated disbursements.
 POSTDATE date Post date for the generated disbursements.
 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.
 STATUSCODE tinyint   Default = 0 Status for the process.
 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.
 STATUS nvarchar(9) (Computed) CASE [STATUSCODE] WHEN 0 THEN N'Started' WHEN 1 THEN N'Created' WHEN 2 THEN N'Committed' END Provides a translation for the 'STATUSCODE' field.
 HASUNSUCCESSFUL bit   Default = 0 Signifies during the run when corrective action is needed (once all the corrective action is done this will be reset)
 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 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_DISBURSEMENTPROCESS_DATEADDED DATEADDED    
 IX_DISBURSEMENTPROCESS_DATECHANGED DATECHANGED      
 PK_DISBURSEMENTPROCESS ID  
 UIX_DISBURSEMENTPROCESS_STATUSCODE_NAME_DATEADDED STATUSCODE, NAME, DATEADDED    

Trigger Name Description
 TR_DISBURSEMENTPROCESS_BANKACCOUNTSIGNATURESNOTASSIGNED
 TR_DISBURSEMENTPROCESS_AUDIT_UPDATE
 TR_DISBURSEMENTPROCESS_AUDIT_DELETE

Referenced by Field
 BANKACCOUNTTRANSACTION_EXT DISBURSEMENTPROCESSID
 CREDITMEMO DISBURSEMENTPROCESSID
 DISBURSEMENTPROCESSDISBURSEMENT DISBURSEMENTPROCESSID
 DISBURSEMENTPROCESSFORMAT DISBURSEMENTPROCESSID
 DISBURSEMENTPROCESSPRINTFINALIZERANGE DISBURSEMENTPROCESSID
 DISBURSEMENTPROCESSSIGNATURE DISBURSEMENTPROCESSID
 INVOICE DISBURSEMENTPROCESSID

Entity-Relationship diagram of this table