PROPERTYDETAILADJUSTMENT (4.0SP20)

ID

uniqueidentifier

PROPERTYDETAILID

uniqueidentifier

false

FK to PROPERTYDETAIL

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

REASONCODEID

uniqueidentifier

true

Indicates the reason this adjustment was made.

BASECURRENCYID

uniqueidentifier

true

The base currency associated with this adjustment.

ORGANIZATIONEXCHANGERATEID

uniqueidentifier

true

The exchange rate used to convert to organization amount.

TRANSACTIONCURRENCYID

uniqueidentifier

true

The transaction currency associated with this adjustment.

BASEEXCHANGERATEID

uniqueidentifier

true

The exchange rate used to convert from transaction amount to amount.

PREVIOUSAMOUNT

money

false

Amount of gift prior to adjustment

DATE

datetime

true

The date of the adjustment to the revenue record.

POSTDATE

datetime

true

The date to use when posting the adjustment to the revenue record.

POSTSTATUSCODE

tinyint

false

Flag used to indicate if the adjustment has been posted.

REASON

nvarchar(300)

false

Gives further details for why this adjustment was made.

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

POSTSTATUS

nvarchar(11) (Computed)

true

Provides a translation for the 'POSTSTATUSCODE' field.

ORGANIZATIONPREVIOUSAMOUNT

money

false

Amount of gift prior to adjustment in organization currency.

TRANSACTIONPREVIOUSAMOUNT

money

false

Amount of gift prior to adjustment in transaction currency.

IX_PROPERTYDETAILADJUSTMENT_DATEADDED

False

False

True

IX_PROPERTYDETAILADJUSTMENT_DATECHANGED

False

False

False

IX_PROPERTYDETAILADJUSTMENT_PROPERTYDETAILID

False

False

False

PK_PROPERTYDETAILADJUSTMENT

True

True

False

TR_PROPERTYDETAILADJUSTMENT_AUDIT_UPDATE

TR_PROPERTYDETAILADJUSTMENT_AUDIT_DELETE

TR_PROPERTYDETAILADJUSTMENT_INSERTUPDATE_CURRENCY

ADJUSTMENTHISTORYPROPERTY

PROPERTYDETAILADJUSTMENTID