The BATCH table stores batch instances that are used to view and update batches throughout the system.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
BATCHNUMBER
|
nvarchar(100)
|
false
|
|
The unique number of a given batch.
|
|
DESCRIPTION
|
nvarchar(1000)
|
false
|
|
|
|
PROJECTEDNUMBEROFRECORDS
|
int
|
false
|
|
The projected number of records in this batch.
|
|
PROJECTEDTOTALAMOUNT
|
money
|
false
|
|
The projected total amount for records in this batch.
|
|
STATUSCODE
|
tinyint
|
false
|
|
0=Uncommitted, 1=Committed, 2=Deleted, 3=Committing
|
|
DATECOMMITTED
|
datetime
|
true
|
|
The date that the batch was committed.
|
|
COMMENTS
|
nvarchar(2000)
|
false
|
|
|
|
CREATEOUTPUTIDSET
|
bit
|
false
|
|
Designates whether or not an ID set should be created as a result of the batch commit process.
|
|
OUTPUTIDSETNAME
|
nvarchar(100)
|
false
|
|
The name of the outpue ID set to be created by the batch commit process.
|
|
OVERWRITEOUTPUTIDSET
|
bit
|
false
|
|
Designates whether or not to overwrite the output ID set if one with the same name already exists.
|
|
CREATEEXCEPTIONBATCH
|
bit
|
false
|
|
Indicates whether a batch should be created for exceptions during the commit process.
|
|
EXCEPTIONBATCHNAME
|
nvarchar(60)
|
false
|
|
The name to use when creating an exception batch.
|
|
PURGEBATCH
|
bit
|
false
|
|
Indicates whether or not to delete the batch data and mark the batch as deleted after the commit process.
|
|
CREATECONTROLREPORT
|
bit
|
false
|
|
Indicates whether or not to generate data for a control report.
|
|
EFTFILECREATED
|
bit
|
false
|
|
Indicates whether or not an EFT transmission file has been created for this batch.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
FORMDEFINITIONXML
|
xml
|
true
|
|
Stores the field defaults for a batch.
|
|
VALIDATEBATCH
|
bit
|
false
|
|
Indicates whether or not to validate the batch before the commit process runs. Only a successful validate will allow the batch to be committed.
|
|
CHECKFORDUPLICATERECORDS
|
bit
|
false
|
|
Indicates whether or not to check for duplicate records in the batch.
|
|
USEPROJECTEDTOTALS
|
bit
|
false
|
|
Indicates whether or not the projected totals values should be used in validation.
|
|
AUTOSAVEONROWCHANGE
|
bit
|
false
|
|
Indicates whether or not the batch should auto save on each row change.
|
|
OVERRIDE
|
bit
|
false
|
|
Indicates whether a exception batch number is overridden with a user defined value.
|
|
STATUS
|
nvarchar(11) (Computed)
|
true
|
|
Provides a translation for the 'STATUSCODE' field.
|
|
AUTOMATCHTHRESHOLD
|
decimal(20, 4)
|
false
|
|
|
|
OVERALLMATCHTHRESHOLD
|
decimal(20, 4)
|
false
|
|
|
|
PARAMETERSXML
|
xml
|
true
|
|
|
|
DISABLEADDNEWROW
|
bit
|
false
|
|
|
