Entity Definition

Logical Name : TaxCertificateProgram
Physical Name : CO_TX_CF_PRGM

A program of tax exemption or modification for a tax jurisdicition and a specific time period.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TaxCertificateProgramID (PK) A system assigned unique identifier fo a tax certificate program. ID_TX_CF_PRGM Identity integer
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)
TaxCertificateProgramSequenceNumber (AK) A sequential counter used to uniquely identify a tax program for a specific jurisdiction and tax type. AI_TX_CF LineNumber smallint
TaxCertificateTypeCode (FK) A code that describes a categorization of tax certificate types, such as exemption, zero rated, reverse charges, etc. CD_TYP_TX_CF TaxCertificateTypeCode varchar(50) TaxCertificateType(CO_TYP_TX_CF)
MerchandiseHierarchyGroupID (FK) Unique system assigned identifier for a group or class of merchandise. ID_MRHRC_GP Identity integer MerchandiseHierarchyGroup(CO_MRHRC_GP)
TaxCertificateProgramName The name of the tax certificate program. NM_TX_CF_PRGM Name varchar(40)
EffectiveDateTime The effective date and time of this tax certificate program. TS_EF EffectiveDateTime datetime
ExpirationDatetime The expiration date and time of this tax certificate program. TS_EP ExpirationDateTime datetime


Parent Entity Verb Phrase Child Entity
MerchandiseHierarchyGroup is covered by TaxCertificateProgram
TaxCertificateType categorizes TaxCertificateProgram
TaxJurisdictionTaxType applies to TaxCertificateProgram
TaxCertificateProgram covers TaxCertificateProgramCoverage

Logical Views containing TaxCertificateProgram

Logical View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 05050 - Taxation - Registration and Certification View