PDACCOUNTLOOKUPCACHE
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ERRORMESSAGE | nvarchar(max) | yes | ||
| GLACCOUNTID | uniqueidentifier | yes | ||
| TRANSACTIONTYPECODE | tinyint | yes | ||
| ERRORNUMBER | tinyint | yes | ||
| MAPPEDVALUES | nvarchar(max) | yes | ||
| PDACCOUNTSYSTEMID | uniqueidentifier | |||
| MD5HASHCODE | uniqueidentifier | yes |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_PDACCOUNTLOOKUPCACHE_MD5HASH | MD5HASHCODE | yes | ||
| IX_PDACCOUNTLOOKUPCACHE_MD5HASHCODE_TRANSACTIONTYPECODE_MAPPEDVALUES | MD5HASHCODE, TRANSACTIONTYPECODE |