| 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) |
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. |
| 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) |
yes |
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) |
yes |
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) |
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. |
| 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. |
| 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. |