REVENUEAUDIT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| AUDITID | uniqueidentifier | ||
| AUDITRECORDID | uniqueidentifier | ||
| AUDITKEY | uniqueidentifier | ||
| AUDITCHANGEAGENTID | uniqueidentifier | ||
| AUDITDATE | datetime | ||
| AUDITTYPECODE | tinyint | ||
| AUDITTYPE | nvarchar(13) | yes | |
| CONSTITUENTID | uniqueidentifier | yes | |
| DATE | datetime | yes | |
| BATCHNUMBER | nvarchar(100) | yes | |
| POSTDATE | date | yes | |
| DONOTPOST | int | yes | |
| DONOTRECEIPT | bit | yes | |
| RECEIPTAMOUNT | money | yes | |
| AMOUNT | money | yes | |
| SOURCECODE | nvarchar(50) | yes | |
| FINDERNUMBER | bigint | yes | |
| APPEALID | uniqueidentifier | yes | |
| MAILINGID | uniqueidentifier | yes | |
| CHANNELCODEID | uniqueidentifier | yes | |
| GIVENANONYMOUSLY | bit | yes | |
| DONOTACKNOWLEDGE | bit | yes | |
| BENEFITSWAIVED | bit | yes | |
| ADDEDBYID | uniqueidentifier | yes | |
| CHANGEDBYID | uniqueidentifier | yes | |
| DATEADDED | datetime | yes | |
| DATECHANGED | datetime | yes | |
| RECEIPTTYPECODE | tinyint | yes | |
| NEEDSRERECEIPT | bit | yes | |
| TRANSACTIONTYPECODE | tinyint | yes | |
| ELIGIBLEFORMATCHINGGIFTCLAIM | bit | yes | |
| CUSTOMIDENTIFIER | nvarchar(100) | yes | |
| SEQUENCEID | int | yes | |
| ISREIMBURSABLE | bit | yes | |
| BASECURRENCYID | uniqueidentifier | yes | |
| ORGANIZATIONAMOUNT | money | yes | |
| TRANSACTIONAMOUNT | money | yes | |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | |
| BASEEXCHANGERATEID | uniqueidentifier | yes |
Definition
Copy
CREATE view dbo.REVENUEAUDIT as
select A.AUDITID
,A.AUDITRECORDID
,A.AUDITKEY
,A.AUDITCHANGEAGENTID
,A.AUDITDATE
,A.AUDITTYPECODE
,A.AUDITTYPE
,A.CONSTITUENTID
,A.[DATE]
,A.BATCHNUMBER
,A.POSTDATE
,A.DONOTPOST
,A.DONOTRECEIPT
,A.RECEIPTAMOUNT
,A.AMOUNT
,A.SOURCECODE
,A.FINDERNUMBER
,A.APPEALID
,A.MAILINGID
,A.CHANNELCODEID
,A.GIVENANONYMOUSLY
,A.DONOTACKNOWLEDGE
,A.BENEFITSWAIVED
,A.ADDEDBYID
,A.CHANGEDBYID
,A.DATEADDED
,A.DATECHANGED
,A.RECEIPTTYPECODE
,A.NEEDSRERECEIPT
,A.TRANSACTIONTYPECODE
,A.ELIGIBLEFORMATCHINGGIFTCLAIM
,A.CUSTOMIDENTIFIER
,A.SEQUENCEID
,A.ISREIMBURSABLE
,A.BASECURRENCYID
,A.ORGANIZATIONAMOUNT
,A.TRANSACTIONAMOUNT
,A.TRANSACTIONCURRENCYID
,A.ORGANIZATIONEXCHANGERATEID
,A.BASEEXCHANGERATEID
from dbo.UFN_GET_REVENUEAUDIT_FROM_FTM() A