BANKACCOUNTADJUSTMENTCATEGORY (4.0SP20)

ID

uniqueidentifier

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

TRANSFERBANKACCOUNTID

uniqueidentifier

true

Transfer account

BANKACCOUNTID

uniqueidentifier

false

Bank account ID

ADJUSTMENTFUZZYDATEID

uniqueidentifier

true

Adjustment category fuzzy date

CATEGORY

nvarchar(60)

false

Category description

AMOUNT

decimal(19, 4)

false

Default amount

DEFAULTREFERENCE

nvarchar(100)

false

Default reference

POSTSTATUSCODE

tinyint

false

Post status

POSTDATECODE

tinyint

false

Post date

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.

ADJUSTMENTTYPECODE

tinyint

false

Type of adjustment

ADJUSTMENTTYPE

nvarchar(12) (Computed)

true

Provides a translation for the 'ADJUSTMENTTYPECODE' field.

POSTDATE

nvarchar(15) (Computed)

true

Provides a translation for the 'POSTDATECODE' field.

POSTSTATUS

nvarchar(11) (Computed)

true

Provides a translation for the 'POSTSTATUSCODE' field.

IX_BANKACCOUNTADJUSTMENTCATEGORY_BANKACCOUNTID_TRANSFERBANKACCOUNTID

False

False

False

IX_BANKACCOUNTADJUSTMENTCATEGORY_DATEADDED

False

False

True

IX_BANKACCOUNTADJUSTMENTCATEGORY_DATECHANGED

False

False

False

PK_BANKACCOUNTADJUSTMENTCATEGORY

True

True

False

UIX_BANKACCOUNTADJUSTMENTCATEGORY_BANKACCOUNTID_CATEGORY

True

False

False

TR_BANKACCOUNTADJUSTMENTCATEGORY_AUDIT_UPDATE

TR_BANKACCOUNTADJUSTMENTCATEGORY_AUDIT_DELETE

BANKACCOUNTADJUSTMENT

BANKACCOUNTADJUSTMENTCATEGORYID