STOCKSALEAUDITORIGINAL
This table contains the audit trail for rows in the dbo.STOCKSALE 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.STOCKSALE.ID field. | ||
| AUDITKEY | uniqueidentifier | When an update occurs to the dbo.STOCKSALE table, both the ''before'' and ''after'' changes are written to the dbo.STOCKSALEAUDIT 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.STOCKSALE table, only the ''deleted'' data is written to the dbo.STOCKSALEAUDIT 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.STOCKSALE table. | |
| AUDITTYPECODE | tinyint | Default = 0 | The AuditType field describes context of each row in the dbo.STOCKSALEAUDIT 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. | |
| STOCKDETAILID | uniqueidentifier | yes | ||
| SALEDATE | datetime | yes | ||
| SALEAMOUNT | money | yes | ||
| FEE | money | yes | ||
| NUMBEROFUNITS | decimal(20, 3) | yes | ||
| LOWPRICE | decimal(19, 4) | yes | ||
| MEDIANPRICE | decimal(19, 4) | yes | ||
| HIGHPRICE | decimal(19, 4) | yes | ||
| SALEPOSTDATE | datetime | yes | ||
| SALEPOSTSTATUSCODE | tinyint | yes | ||
| ADDEDBYID | uniqueidentifier | yes | ||
| CHANGEDBYID | uniqueidentifier | yes | ||
| DATEADDED | datetime | yes | ||
| DATECHANGED | datetime | yes | ||
| ORGANIZATIONSALEAMOUNT | money | yes | ||
| ORGANIZATIONFEE | money | yes | ||
| ORGANIZATIONLOWPRICE | decimal(19, 4) | yes | ||
| ORGANIZATIONMEDIANPRICE | decimal(19, 4) | yes | ||
| ORGANIZATIONHIGHPRICE | decimal(19, 4) | yes | ||
| TRANSACTIONSALEAMOUNT | money | yes | ||
| TRANSACTIONFEE | money | yes | ||
| TRANSACTIONLOWPRICE | decimal(19, 4) | yes | ||
| TRANSACTIONMEDIANPRICE | decimal(19, 4) | yes | ||
| TRANSACTIONHIGHPRICE | decimal(19, 4) | yes | ||
| BASECURRENCYID | uniqueidentifier | yes | ||
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | ||
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | ||
| BASEEXCHANGERATEID | uniqueidentifier | yes |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_STOCKSALEAUDIT_AUDITDATE | AUDITDATE | yes | ||
| IX_STOCKSALEAUDIT_AUDITRECORDID | AUDITRECORDID | |||
| IX_STOCKSALEAUDIT_STOCKDETAILID | STOCKDETAILID | |||
| PK_STOCKSALEAUDIT | AUDITID | yes | yes |