PROPERTYDETAILAUDIT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| AUDITID | uniqueidentifier | ||
| AUDITRECORDID | uniqueidentifier | ||
| AUDITKEY | uniqueidentifier | ||
| AUDITCHANGEAGENTID | uniqueidentifier | ||
| AUDITDATE | datetime | ||
| AUDITTYPECODE | tinyint | ||
| AUDITTYPE | nvarchar(13) | yes | |
| PROPERTYSUBTYPECODEID | uniqueidentifier | yes | |
| SALEDATE | datetime | yes | |
| SALEAMOUNT | money | yes | |
| BROKERFEE | money | yes | |
| SALEPOSTDATE | datetime | yes | |
| SALEPOSTSTATUSCODE | tinyint | yes | |
| ADDEDBYID | uniqueidentifier | yes | |
| CHANGEDBYID | uniqueidentifier | yes | |
| DATEADDED | datetime | yes | |
| DATECHANGED | datetime | yes | |
| ORGANIZATIONSALEAMOUNT | money | yes | |
| ORGANIZATIONBROKERFEE | money | yes | |
| TRANSACTIONSALEAMOUNT | money | yes | |
| TRANSACTIONBROKERFEE | money | yes | |
| BASECURRENCYID | uniqueidentifier | yes | |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | |
| BASEEXCHANGERATEID | uniqueidentifier | yes |
Definition
Copy
create view dbo.PROPERTYDETAILAUDIT as
select A.AUDITID
,A.AUDITRECORDID
,A.AUDITKEY
,A.AUDITCHANGEAGENTID
,A.AUDITDATE
,A.AUDITTYPECODE
,A.AUDITTYPE
,A.PROPERTYSUBTYPECODEID
,A.SALEDATE
,A.SALEAMOUNT
,A.BROKERFEE
,A.SALEPOSTDATE
,A.SALEPOSTSTATUSCODE
,A.ADDEDBYID
,A.CHANGEDBYID
,A.DATEADDED
,A.DATECHANGED
,A.ORGANIZATIONSALEAMOUNT
,A.ORGANIZATIONBROKERFEE
,A.TRANSACTIONSALEAMOUNT
,A.TRANSACTIONBROKERFEE
,A.BASECURRENCYID
,A.ORGANIZATIONEXCHANGERATEID
,A.TRANSACTIONCURRENCYID
,A.BASEEXCHANGERATEID
from dbo.PROPERTYDETAILAUDITORIGINAL A
union all
select A.AUDITID
,A.AUDITRECORDID
,A.AUDITKEY
,A.AUDITCHANGEAGENTID
,A.AUDITDATE
,A.AUDITTYPECODE
,A.AUDITTYPE
,A.PROPERTYSUBTYPECODEID
,A.SALEDATE
,A.SALEAMOUNT
,A.BROKERFEE
,A.SALEPOSTDATE
,A.SALEPOSTSTATUSCODE
,A.ADDEDBYID
,A.CHANGEDBYID
,A.DATEADDED
,A.DATECHANGED
,A.ORGANIZATIONSALEAMOUNT
,A.ORGANIZATIONBROKERFEE
,A.TRANSACTIONSALEAMOUNT
,A.TRANSACTIONBROKERFEE
,A.BASECURRENCYID
,A.ORGANIZATIONEXCHANGERATEID
,A.TRANSACTIONCURRENCYID
,A.BASEEXCHANGERATEID
from dbo.UFN_GET_PROPERTYDETAILAUDIT_FROM_FTM() A