GENERATETRANSACTIONSPROCESS (4.0SP17)

ID

uniqueidentifier

IDSETREGISTERID

uniqueidentifier

true

Indicates the IDSETREGISTER to use filter records included in the process.

BATCHTEMPLATEID

uniqueidentifier

false

Specifies the batch instance to be used to create the batch to hold the transactions.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

OWNERID

uniqueidentifier

true

The user who will be the owner of the batch once it is created by the process.

PDACCOUNTSYSTEMID

uniqueidentifier

true

Foreign key to the account system.

NAME

nvarchar(100)

false

The name of the parameter set.

DESCRIPTION

nvarchar(255)

false

The description of the parameter set.

CUTOFFDATE

datetime

false

Specifies the cut-off date for transactions to be included in the process.

BATCHNUMBER

nvarchar(100)

false

Specifies the batch number assigned to the batch used to hold the transactions.

TRANSACTIONTYPECODE

tinyint

false

Specifies the type of transactions to generate.

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.

OVERRIDEBATCHNUMBER

bit

false

Indicates whether or not to use the default numbering scheme for the batch.

DUEDATETYPECODE

tinyint

false

Designates whether to use the date this process runs or a number of days after this process runs or a specific date in the process as the cutoff date.

DUEDATETYPE

nvarchar(30) (Computed)

true

Provides a translation for the 'DUEDATETYPECODE' field.

DAYSAFTER

int

false

Number of days after this process runs that will be used to calculate the cutoff date

CONSOLIDATEPAYMENTS

bit

false

Consolidate multiple commitments to a single payment by constituent.

TRANSACTIONTYPE

nvarchar(32) (Computed)

true

IX_GENERATETRANSACTIONSPROCESS_DATEADDED

False

False

True

IX_GENERATETRANSACTIONSPROCESS_DATECHANGED

False

False

False

PK_GENERATETRANSACTIONSPROCESS

True

True

False

UC_GENERATETRANSACTIONSPROCESS_NAME

True

False

False

TR_GENERATETRANSACTIONSPROCESS_AUDIT_UPDATE

TR_GENERATETRANSACTIONSPROCESS_AUDIT_DELETE

GENERATETRANSACTIONSPROCESSSTATUS

PARAMETERSETID