| 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) |
yes |
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 |
yes |
|
Transactions are included when their due date is equal or less than this date. |
| DISCOUNTDATE |
date |
yes |
|
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 |
yes |
|
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) |
yes |
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) |
yes |
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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| TYPE |
nvarchar(21) (Computed) |
yes |
CASE [TYPECODE] WHEN 0 THEN N'Payables disbursement' END |
Provides a translation for the 'TYPECODE' field. |
| STATUS |
nvarchar(9) (Computed) |
yes |
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) |
yes |
CASE [POSTSTATUSCODE] WHEN 1 THEN N'Not posted' WHEN 3 THEN N'Do not post' END |
Provides a translation for the 'POSTSTATUSCODE' field. |