Open topic with navigation

REVENUEVAT (4.0SP17)

Contains value added tax information for revenue records.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

VATTAXRATEID

uniqueidentifier

true

Value added tax rate to used.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

BASECURRENCYID

uniqueidentifier

true

The base currency associated with this revenue.

ORGANIZATIONEXCHANGERATEID

uniqueidentifier

true

The exchange rate used to convert to organization amount.

TRANSACTIONCURRENCYID

uniqueidentifier

true

The transaction currency associated with this revenue.

BASEEXCHANGERATEID

uniqueidentifier

true

The exchange rate used to convert from transaction amount to base amount.
Fields
Field Field Type Null Notes Description

AMOUNTTOTAX

money

false

0

Amount subject to value added tax in base currency.

VATAMOUNT

money

false

0

Amount of value added tax in base 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.

ORGANIZATIONAMOUNTTOTAX

money

false

0

Amount subject to value added tax in organization currency.

ORGANIZATIONVATAMOUNT

money

false

0

Amount of value added tax in organization currency.

TRANSACTIONAMOUNTTOTAX

money

false

0

Amount subject to value added tax in transaction currency.

TRANSACTIONVATAMOUNT

money

false

0

Amount of value added tax in transaction currency.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_REVENUEVAT_DATEADDED

DATEADDED

False

False

True

IX_REVENUEVAT_DATECHANGED

DATECHANGED

False

False

False

IX_REVENUEVAT_VATTAXRATEID

VATTAXRATEID

False

False

False

PK_REVENUEVAT

ID

True

True

False
Triggers
Trigger Name Description

TR_REVENUEVAT_AUDIT_UPDATE

TR_REVENUEVAT_INSERTUPDATE_CURRENCY

TR_REVENUEVAT_AUDIT_DELETE