Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
MESSAGE | nvarchar(1000) | Default = '' | ||
ROWNUMBER | int | Default = 0 | The number of the row that caused the exception. | |
ROWDATA | nvarchar(max) | Default = '' | The row of data that caused the exception. | |
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) | CONVERT(bigint, TS) | Numeric representation of the timestamp. | |
ACCOUNTNUMBER | nvarchar(4000) | Default = '' | ||
SORTCODE | nvarchar(8) | Default = '' | ||
TRANSACTIONAMOUNT | money | Default = 0 | ||
TRANSACTIONDATE | datetime | |||
CONSTITUENTLOOKUPID | nvarchar(100) | Default = '' | ||
CONSTITUENTNAME | nvarchar(200) | Default = '' | ||
REFERENCENUMBER | nvarchar(20) | Default = '' |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
BUSINESSPROCESSSTATUSID | uniqueidentifier | BUSINESSPROCESSSTATUS.ID | ID of the batch process status record to which the exception belongs | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_STANDINGORDERSIMPORTPROCESSEXCEPTION_BUSINESSPROCESSSTATUSID | BUSINESSPROCESSSTATUSID | |||
IX_STANDINGORDERSIMPORTPROCESSEXCEPTION_DATEADDED | DATEADDED | |||
IX_STANDINGORDERSIMPORTPROCESSEXCEPTION_DATECHANGED | DATECHANGED | |||
PK_STANDINGORDERSIMPORTPROCESSEXCEPTION | ID |
Trigger Name | Description |
---|---|
TR_STANDINGORDERSIMPORTPROCESSEXCEPTION_AUDIT_UPDATE | |
TR_STANDINGORDERSIMPORTPROCESSEXCEPTION_AUDIT_DELETE |