RMATAX

This table stores return merchandise authorization (RMA) tax credits.

Column Descriptions:

NameTypeDescription
RMA_IDBIGINT NOT NULLThe ID of the RMA for which this tax amount applies.
TAXCGRY_IDINTEGER NOT NULLThe TaxCategory.
TAXAMOUNTDECIMAL (20,5) NOT NULLTax amount in the currency of the RMA.
LASTUPDATETIMESTAMP NOT NULLTimestamp of the last update.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RMA_ID+TAXCGRY_IDPrimary Key
I0000751TAXCGRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_717TAXCGRY_IDTAXCGRYTAXCGRY_IDCascade
F_718RMA_IDRMARMA_IDCascade