GLREVERSAL (4.0SP17)

ID

uniqueidentifier

REVENUEID

uniqueidentifier

true

Indicates the revenue record to which this reversal applies.

GLPAYMENTMETHODREVENUETYPEMAPPINGID

uniqueidentifier

false

Foreign key to GLPaymentMethodRevenueTypeMapping table

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

DEBITACCOUNT

nvarchar(100)

false

Debit account

CREDITACCOUNT

nvarchar(100)

false

Credit account

PROJECT

nvarchar(100)

false

Project field

REFERENCE

nvarchar(255)

false

Reference field

AMOUNT

money

false

Amount

POSTDATE

datetime

true

The date to use when posting the reversal.

POSTSTATUSCODE

tinyint

false

Flag used to indicate if the reversal has been posted.

ISDELETE

bit

false

Indicaes if reversal is part of a delete.

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.

WRITEOFFID

uniqueidentifier

true

Logical foreign key to the WRITEOFF table. Indicates the write-off record to which this reveral applies.

POSTSTATUS

nvarchar(10) (Computed)

true

Provides a translation for the 'POSTSTATUSCODE' field.

IX_GLREVERSAL_DATEADDED

False

False

True

IX_GLREVERSAL_DATECHANGED

False

False

False

IX_GLREVERSAL_GLPAYMENTMETHODREVENUETYPEMAPPINGID

False

False

False

IX_GLREVERSAL_REVENUEID

False

False

False

PK_GLREVERSAL

True

True

False

TR_GLREVERSAL_AUDIT_UPDATE

TR_GLREVERSAL_AUDIT_DELETE