Open topic with navigation

ADJUSTMENTHISTORYGIFTINKINDPAYMENTMETHODDETAIL (4.0SP20)

no changes

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers

Stores detail information on historic sold gift-in-kind adjustments.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
ADJUSTMENTHISTORYGIFTINKINDID	uniqueidentifier	false	ADJUSTMENTHISTORYGIFTINKIND.ID	Indicates the history item to which this detail belongs.
BASECURRENCYID	uniqueidentifier	true	CURRENCY.ID	The base currency associated with this adjustment.
TRANSACTIONCURRENCYID	uniqueidentifier	true	CURRENCY.ID	The transaction currency associated with this adjustment.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.

Fields
Field	Field Type	Null	Notes	Description
ADJUSTEDFIELD	nvarchar(100)	false	''	Indicates the field that caused the adjustment.
ADJUSTEDFIELDPREVIOUSVALUE	nvarchar(4000)	false	''	Indicates the value of the adjusted field before the adjustment.
ADJUSTEDFIELDADJUSTEDVALUE	nvarchar(4000)	false	''	Indicates the value of the adjusted field after the adjustment.
ISMONEY	bit	false	0	Indicates whether or not the adjustment was for a monetary value.
ADJUSTEDFIELDPREVIOUSMONEYVALUE	money	false	0	Indicates the value of the adjusted money field before the adjustment.
ADJUSTEDFIELDADJUSTEDMONEYVALUE	money	false	0	Indicates the value of the adjusted money field after the adjustment.
TRANSACTIONADJUSTEDFIELDPREVIOUSVALUE	nvarchar(4000)	false	''	Indicates the value of the adjusted field before the adjustment in transaction currency.
TRANSACTIONADJUSTEDFIELDADJUSTEDVALUE	nvarchar(4000)	false	''	Indicates the value of the adjusted field after the adjustment in transaction currency.
TRANSACTIONADJUSTEDFIELDPREVIOUSMONEYVALUE	money	false	0	Indicates the value of the adjusted money field before the adjustment in transaction currency.
TRANSACTIONADJUSTEDFIELDADJUSTEDMONEYVALUE	money	false	0	Indicates the value of the adjusted money field after the adjustment in transaction currency.
ORGANIZATIONADJUSTEDFIELDPREVIOUSVALUE	nvarchar(4000)	false	''	Indicates the value of the adjusted field before the adjustment in organization currency.
ORGANIZATIONADJUSTEDFIELDADJUSTEDVALUE	nvarchar(4000)	false	''	Indicates the value of the adjusted field after the adjustment in organization currency.
ORGANIZATIONADJUSTEDFIELDPREVIOUSMONEYVALUE	money	false	0	Indicates the value of the adjusted money field before the adjustment in transaction currency.
ORGANIZATIONADJUSTEDFIELDADJUSTEDMONEYVALUE	money	false	0	Indicates the value of the adjusted money field after the adjustment in transaction currency.
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_ADJUSTMENTHISTORYGIFTINKINDPAYMENTMETHODDETAIL_ADJUSTMENTHISTORYGIFTINKINDID	ADJUSTMENTHISTORYGIFTINKINDID	False	False	False
IX_ADJUSTMENTHISTORYGIFTINKINDPAYMENTMETHODDETAIL_DATEADDED	DATEADDED	False	False	True
IX_ADJUSTMENTHISTORYGIFTINKINDPAYMENTMETHODDETAIL_DATECHANGED	DATECHANGED	False	False	False
PK_ADJUSTMENTHISTORYGIFTINKINDPAYMENTMETHODDETAIL	ID	True	True	False

Triggers
Trigger Name	Description
TR_ADJUSTMENTHISTORYGIFTINKINDPAYMENTMETHODDETAIL_AUDIT_UPDATE
TR_ADJUSTMENTHISTORYGIFTINKINDPAYMENTMETHODDETAIL_AUDIT_DELETE