REVENUEGLDISTRIBUTIONAUDITORIGINAL
This table contains the audit trail for rows in the dbo.REVENUEGLDISTRIBUTION table.
Primary Key
| Primary Key | Field Type |
|---|---|
| AUDITID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| AUDITRECORDID | uniqueidentifier | The AuditRecordID column is a foreign key to the dbo.REVENUEGLDISTRIBUTION.ID field. | ||
| AUDITKEY | uniqueidentifier | When a update occurs to the dbo.REVENUEGLDISTRIBUTION table, both the ''before'' and ''after'' changes are written to the dbo.REVENUEGLDISTRIBUTIONAUDIT table. The AuditKey is used to associate both rows together, so that they can be aggregated when reporting the audit trail for a given record. Note that for deletes to the dbo.REVENUEGLDISTRIBUTION table, only the ''deleted'' data is written to the dbo.REVENUEGLDISTRIBUTIONAUDIT table. | ||
| AUDITCHANGEAGENTID | uniqueidentifier | FK to CHANGEAGENT, indicating the agent that invoked the change being audited. | ||
| AUDITDATE | datetime | Default = getdate() | The AuditDate field indicates the date that a change (update or delete) occurred to the dbo.REVENUEGLDISTRIBUTION table. | |
| AUDITTYPECODE | tinyint | Default = 0 | The AuditType field describes context of each row in the dbo.REVENUEGLDISTRIBUTIONAUDIT table. A value of 0 implies the data before an update, 1 implies the data after an update, and 2 implies the data before a delete. | |
| AUDITTYPE | nvarchar(13) (Computed) | yes | Computed column - translation for AUDITTYPECODE. | |
| REVENUEID | uniqueidentifier | yes | ||
| GLPAYMENTMETHODREVENUETYPEMAPPINGID | uniqueidentifier | yes | ||
| PROJECT | nvarchar(100) | yes | ||
| REFERENCE | nvarchar(255) | yes | ||
| AMOUNT | money | yes | ||
| ADDEDBYID | uniqueidentifier | yes | ||
| CHANGEDBYID | uniqueidentifier | yes | ||
| DATEADDED | datetime | yes | ||
| DATECHANGED | datetime | yes | ||
| ACCOUNT | nvarchar(100) | yes | ||
| TRANSACTIONTYPECODE | tinyint | yes | ||
| GLTRANSACTIONID | uniqueidentifier | yes | ||
| OUTDATED | bit | yes | ||
| BASECURRENCYID | uniqueidentifier | yes | ||
| ORGANIZATIONAMOUNT | money | yes | ||
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | ||
| TRANSACTIONAMOUNT | money | yes | ||
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | ||
| BASEEXCHANGERATEID | uniqueidentifier | yes |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_REVENUEGLDISTRIBUTIONAUDIT_AUDITDATE | AUDITDATE | yes | ||
| IX_REVENUEGLDISTRIBUTIONAUDIT_AUDITRECORDID | AUDITRECORDID | |||
| IX_REVENUEGLDISTRIBUTIONAUDIT_REVENUEID | REVENUEID | |||
| PK_REVENUEGLDISTRIBUTIONAUDIT | AUDITID | yes | yes |