SEPAMANDATEACTIVITY
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ENDTOENDID | nvarchar(35) | Default = '' | ||
| BUSINESSPROCESSSTATUSID | uniqueidentifier | yes | ||
| BATCHROWID | uniqueidentifier | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SEPAMANDATEID | uniqueidentifier | yes | SEPAMANDATE.ID | |
| FINANCIALTRANSACTIONID | uniqueidentifier | yes | FINANCIALTRANSACTION.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_SEPAMANDATEACTIVITY_BATCHROWID | BATCHROWID | |||
| IX_SEPAMANDATEACTIVITY_ENDTOENDID | ENDTOENDID | |||
| IX_SEPAMANDATEACTIVITY_FINANCIALTRANSACTIONID_ENDTOENDID | FINANCIALTRANSACTIONID, ENDTOENDID | |||
| IX_SEPAMANDATEACTIVITY_SEPAMANDATEID | SEPAMANDATEID | |||
| PK_SEPAMANDATEACTIVITY | ID | yes | yes | yes |