Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
NAME | nvarchar(255) | Default = '' | Name of donor | |
DATE | datetime | Date of payment or last payment in series | ||
AMOUNTRECEIVED | money | Default = 0 | Total donations received | |
AMOUNTCLAIMED | money | Default = 0 | Total tax claimed | |
DATEADDED | datetime | Default = getdate() | Indicates the date this record was added. | |
DATECHANGED | datetime | Default = getdate() | Indicates the date this record was last changed. | |
TS | timestamp | Timestamp. | ||
TSLONG | bigint (Computed) | CONVERT(bigint, TS) | Numeric representation of the timestamp. |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
R68ID | uniqueidentifier | R68.ID | Indicates which R68 business process parameter set was used to generate the claim detail record. | |
REVENUESPLITID | uniqueidentifier | FINANCIALTRANSACTIONLINEITEM.ID | The revenue split that this tax claim detail refers to. | |
CONSTITUENTID | uniqueidentifier | CONSTITUENT.LOCALID | The constituent that this tax claim detail refers to. | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_R68DETAIL_CONSTITUENTID | CONSTITUENTID | |||
IX_R68DETAIL_DATEADDED | DATEADDED | |||
IX_R68DETAIL_DATECHANGED | DATECHANGED | |||
PK_R68DETAIL | ID |
Trigger Name | Description |
---|---|
TR_R68DETAIL_AUDIT_UPDATE | |
TR_R68DETAIL_AUDIT_DELETE |