| NAME |
nvarchar(100) |
|
Default = '' |
The name of the parameter set. |
| DESCRIPTION |
nvarchar(255) |
|
Default = '' |
The description of the parameter set. |
| CREATEOUTPUTIDSET |
bit |
|
Default = 0 |
Designates whether or not an ID set should be created as a result of the receipting process. |
| OUTPUTIDSETNAME |
nvarchar(100) |
|
Default = '' |
The name of the output ID set to be created by the receipting process. |
| OVERWRITEOUTPUTIDSET |
bit |
|
Default = 0 |
Designates whether or not to overwrite the output ID set if one with the same name already exists. |
| MARKRECEIPTED |
bit |
|
Default = 0 |
Indicates whether or not receipts for this process should be marked as receipted. |
| RECEIPTDATETYPECODE |
tinyint |
|
Default = 0 |
Designates whether to use today's date or a specific date in the receipting process as the receipt date. |
| RECEIPTDATE |
datetime |
yes |
|
This date is used as the receipt date when marking records as receipted. |
| LETTERFILENAME |
nvarchar(255) |
|
Default = '' |
The original file name for the letter template. |
| LETTERFILE |
varbinary |
yes |
|
The actual file to use for the letter template. |
| LABELFILENAME |
nvarchar(255) |
|
Default = '' |
The original file name for the label template. |
| LABELFILE |
varbinary |
yes |
|
The actual file for the label template. |
| 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. |
| CUSTOMPARAMETERDATAFORMITEM |
xml |
yes |
|
Custom parameters for the process. |
| RECEIPTTYPECODE |
tinyint |
|
Default = 0 |
The receipt type of payments to include in this process. |
| RECEIPTDATETYPE |
nvarchar(13) (Computed) |
yes |
CASE [RECEIPTDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'Specific date' END |
Provides a translation for the 'RECEIPTDATETYPECODE' field. |
| RECEIPTTYPE |
nvarchar(12) (Computed) |
yes |
CASE [RECEIPTTYPECODE] WHEN 0 THEN N'Per payment' WHEN 1 THEN N'Consolidated' END |
Provides a translation for the 'RECEIPTTYPECODE' field. |
| RERECEIPTSAMENUMBER |
bit |
|
Default = 1 |
Indicates whether or not receipts to reissue should be included. |
| RERECEIPTNEWNUMBER |
bit |
|
Default = 1 |
Indicates whether or not receipts to ereceipt should be included. |
| DUPLICATENUMBERACTIONCODE |
tinyint |
|
Default = 1 |
Indicates the action to take upon running into a duplicate receipt number. |
| STARTINGNUMBERCREATESGAPACTIONCODE |
tinyint |
|
Default = 0 |
Indicates the action to take if the entered starting number will cause gaps in receipt numbering. |
| STARTINGNUMBERCREATESGAPACTION |
nvarchar(42) (Computed) |
yes |
CASE [STARTINGNUMBERCREATESGAPACTIONCODE] WHEN 0 THEN N'Use starting receipt number as entered' WHEN 1 THEN N'Use next available starting receipt number' END |
Provides a translation for the 'STARTINGNUMBERCREATESGAPACTIONCODE' field. |
| DUPLICATENUMBERACTION |
nvarchar(27) (Computed) |
yes |
CASE [DUPLICATENUMBERACTIONCODE] WHEN 0 THEN N'Use next available number' WHEN 1 THEN N'Use duplicate number anyway' END |
Provides a translation for the 'DUPLICATENUMBERACTIONCODE' field. |