Entity Definition

Logical Name : TaxRegistrationTaxType
Physical Name : RU_TX_RGST_TX_TYP

An associative entity recording which TaxJurisdictions and Tax Types a particular TaxRegistration is valid for.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TaxRegistrationTaxTypeID (PK) A system assigned unique identifier for an assocation of tax registrations to jurisdictions and tax types. ID_TX_RGST_TX_TYP Identity integer
EffectiveDateTime (AK) The date & time from which the TaxJurisdiction recognizes the TaxRegistration. TS_EF EffectiveDateTime datetime
TaxRegistrationID (AK)(FK) A unique system assigned identifier for this TaxRegistration. ID_RGST_TX Identity integer TaxRegistration(PA_TX_RGST)
TaxJurisdictionID (AK)(FK) A unique system assigned identifier for the TaxJurisdiction. ID_JRDT_TX Identity integer TaxJurisdictionTaxType(RU_JRDT_TX_TYP_TX)
TaxTypeCode (AK)(FK) A retailer assigned mnemonic code denoting a kind of tax. Eg: SalesTax, GST, PST, HST, VAT CD_TYP_TX Code4 char(4) TaxJurisdictionTaxType(RU_JRDT_TX_TYP_TX)
ExpirationDateTime The date & time after which the TaxJurisdiction no longer recognizes the TaxRegistration. TS_EP ExpirationDateTime datetime


Parent Entity Verb Phrase Child Entity
TaxJurisdictionTaxType is registered for TaxRegistrationTaxType
TaxRegistration applies to TaxRegistrationTaxType

Logical Views containing TaxRegistrationTaxType

Logical View
Logical 05000 - Taxation - Macro View
Logical 05050 - Taxation - Registration and Certification View