Data Dictionary -- Taxes Charges and Discounts

Srl. No.	Table Name	Comment
1	TCD_TAXATTR_APPLIC_RULE_MET	This is the table in which Tax/Charges/discount codes applicable rule are defined.
2	TCD_TAXATTR_CATEG_RULE_MET	This is the table in which Tax/Charges/discount codes category rule are defined.
3	TCD_TAXATTR_CLASS_RULE_MET	This is the table in which Tax/Charges/discount codes class rule are defined.
4	TCD_TAXATTR_INCID_RULE_MET	This is the table in which Tax/Charges/discount codes incidence rule are defined.
5	TCD_TAXATTR_NATURE_RULE_MET	This is the table in which Tax/Charges/discount codes TAX Nature rule are defined.
6	TCD_TAXATTR_TAX_ATTR_HDR	This is the table in which Tax/Charges/Discounts attribute values are stored
7	TCD_TCDDT_TCDCODEDTL	This is the table in which Tax/Charges/Discounts details stored
8	TCD_TCDHD_TCDCODEHDR	This is the table in which Tax/Charges/Discounts header values stored
9	TCD_TCDHD_TCD_CODE_HDR	This is the table in which Tax/Charges/discount codes are defined.
10	TCD_TCDMP_TCD_CODE_MAP	THis table holds the mapping details of TCD codes .This table will not contain unmapped TCD codes
11	TCD_TCDPRM_PARAMETER_DTL	This is the table in which parameter details of the TCD component are stored
12	TCD_TCDSQ_TCD_SEQUENCE	This temporary table is used internally by TCD component for sequencing of dependant TCD codes based on mapping.Eventhough the calculation is based on the sequence of entries by user,this table is used to avoid cyclic reference of mapping.
13	TCD_TCDVDT_TCD_VAR_DTL	This is the table in which Tax/Charges/discount variants are defined.

Table Name :	TCD_TAXATTR_APPLIC_RULE_MET
Comment :	This is the table in which Tax/Charges/discount codes applicable rule are defined.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LANGUAGE_ID	udd_lang_id	tinyint(1)	Yes	Language id	No
COMPONENT_ID	udd_componentshortid	varchar(20)	No	Component id	No
SEQUENCE_NO	udd_sequence	numeric(9)	No	Sequence no.	No
TAXTYPE_CODE	udd_taxtype	varchar(20)	No	Tax type code	No
APPLICABILITY_CODE	udd_taxappl	varchar(25)	No	Applicability code	No
APPLICABILITY_DESC	udd_taxappl	varchar(25)	Yes	Applicability Description	No
TIMESTAMP	udd_timestamp	int(4)	Yes	Timestamp value	No
CREATEDBY	udd_ctxt_user	varchar(30)	Yes	Created by	No
CREATEDDATE	udd_date	varchar(15)	Yes	Created date	No
MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	Modified by	No
MODIFIEDDATE	udd_date	varchar(15)	Yes	Modified date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	TCD_TAXATTR_CATEG_RULE_MET
Comment :	This is the table in which Tax/Charges/discount codes category rule are defined.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LANGUAGE_ID	udd_lang_id	tinyint(1)	Yes	Language id	No
COMPONENT_ID	udd_componentshortid	varchar(20)	No	Component id	No
SEQUENCE_NO	udd_sequence	numeric(9)	No	Sequence no.	No
TAXTYPE_CODE	udd_taxtype	varchar(20)	No	Tax type code	No
APPLICABILITY_CODE	udd_taxappl	varchar(25)	No	Applicability code	No
TAXCATEGORY_CODE	udd_taxcat	varchar(25)	No	Taxcategory code	No
TAXCATEGORY_DESC	udd_taxcat	varchar(25)	Yes	Tax category description	No
TIMESTAMP	udd_timestamp	int(4)	Yes	Time stamp values	No
CREATEDBY	udd_ctxt_user	varchar(30)	Yes	Created by	No
CREATEDDATE	udd_date	varchar(15)	Yes	Created date	No
MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	Modified by	No
MODIFIEDDATE	udd_date	varchar(15)	Yes	Modified date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	TCD_TAXATTR_CLASS_RULE_MET
Comment :	This is the table in which Tax/Charges/discount codes class rule are defined.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LANGUAGE_ID	udd_lang_id	tinyint(1)	Yes	Language id	No
COMPONENT_ID	udd_componentshortid	varchar(20)	No	Component id	No
SEQUENCE_NO	udd_sequence	numeric(9)	No	Sequence no.	No
TAXTYPE_CODE	udd_taxtype	varchar(20)	No	Tax type code	No
TAXCATEGORY_CODE	udd_taxcat	varchar(25)	Yes	Taxcategory code	No
TAXCLASS_CODE	udd_taxclass	varchar(20)	Yes	Tax class code	No
TAXCLASS_DESC	udd_taxclass	varchar(20)	Yes	Tax class description	No
TIMESTAMP	udd_timestamp	int(4)	Yes	Time stamp values	No
CREATEDBY	udd_ctxt_user	varchar(30)	Yes	Created by	No
CREATEDDATE	udd_date	varchar(15)	Yes	Created date	No
MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	Modified by	No
MODIFIEDDATE	udd_date	varchar(15)	Yes	Modified date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	TCD_TAXATTR_INCID_RULE_MET
Comment :	This is the table in which Tax/Charges/discount codes incidence rule are defined.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LANGUAGE_ID	udd_lang_id	tinyint(1)	Yes	Language id	No
COMPONENT_ID	udd_componentshortid	varchar(20)	No	Component id	No
SEQUENCE_NO	udd_sequence	numeric(9)	No	Sequence no.	No
TAXTYPE_CODE	udd_taxtype	varchar(20)	No	Tax type code	No
INCIDENCE_CODE	udd_taxinci	varchar(40)	No	Incidence code	No
INCIDENCE_DESC	udd_taxinci	varchar(40)	Yes	Incidence description	No
TIMESTAMP	udd_timestamp	int(4)	Yes	Time stamp values	No
CREATEDBY	udd_ctxt_user	varchar(30)	Yes	Created by	No
CREATEDDATE	udd_date	varchar(15)	Yes	Created date	No
MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	Modified by	No
MODIFIEDDATE	udd_date	varchar(15)	Yes	Modified date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	TCD_TAXATTR_NATURE_RULE_MET
Comment :	This is the table in which Tax/Charges/discount codes TAX Nature rule are defined.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LANGUAGE_ID	udd_lang_id	tinyint(1)	Yes	Language id	No
COMPONENT_ID	udd_componentshortid	varchar(20)	No	Component id	No
SEQUENCE_NO	udd_sequence	numeric(9)	No	Sequence no.	No
TAXTYPE_CODE	udd_taxtype	varchar(20)	No	Tax type code	No
APPLICABILITY_CODE	udd_taxappl	varchar(25)	No	Applicability code	No
TAXNATURE_CODE	udd_taxnat	varchar(25)	No	Taxnature code	No
TAXNATURE_DESC	udd_taxnat	varchar(25)	Yes	Tax nature description	No
TIMESTAMP	udd_timestamp	int(4)	Yes	Time stamp values	No
CREATEDBY	udd_ctxt_user	varchar(30)	Yes	Created by	No
CREATEDDATE	udd_date	varchar(15)	Yes	Created date	No
MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	Modified by	No
MODIFIEDDATE	udd_date	varchar(15)	Yes	Modified date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	TCD_TAXATTR_TAX_ATTR_HDR
Comment :	This is the table in which Tax/Charges/Discounts attribute values are stored

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TAXATTR_CREATED_OUINSTANCE	udd_ou	varchar(256)	No	This is the ou instance in which TCD codes are defined	No
TAXATTR_TCD_CODE	udd_quickcodes	varchar(25)	No	This field captures the codes defined for Tax/Charges/discounts	No
TAXATTR_TCD_VAR_CODE	udd_quickcodes	varchar(25)	No	This field captures the variant codes defined for Tax/Charges/discounts	No
TAXATTR_TCD_CODE_BASIS	udd_quickcodes	varchar(25)	No	TCD Code basis	No
TAXATTR_TAX_KEY	Udd_TaxKey	varchar(15)	No	Tax key	No
TAXATTR_TCD_VAR_FROM_DATE	udd_date_chk	datetime(8)	No	Effective from date	No
TAXATTR_TCD_VAR_TO_DATE	udd_date_chk	datetime(8)	No	Effective to date	No
TAXATTR_TIMESTAMP	udd_timestamp	int(4)	No	Time stamp values	No
TAXATTR_TAX_TYPE	udd_applicableon	varchar(20)	No	Tax type	No
TAXATTR_TAX_APPL	udd_taxappl	varchar(25)	No	Tax applicability	No
TAXATTR_TAX_INCID	udd_taxinci	varchar(40)	No	Tax Incidence	No
TAXATTR_TAX_NATURE	udd_taxnat	varchar(25)	No	Tax nature	No
TAXATTR_TAX_CATEGORY	udd_taxcat	varchar(25)	No	Tax Category	No
TAXATTR_TAX_CLASS	udd_taxclass	varchar(20)	No	Tax class	No
TAXATTR_TAX_APPR	udd_quickcodes	varchar(25)	No	Tax Appropriation	No
TAXATTR_PERC_ALLOW	udd_amount	numeric(13)	Yes	Percentage Allowed	No
TAXATTR_THRES_BASIS	udd_quickcodes	varchar(25)	No	Threshold basis	No
TAXATTR_THRES_VALUE	udd_amount	numeric(13)	Yes	Threshold Value	No
TAXATTR_USER_DEF_VALUE1	udd_quickcodes	varchar(25)	Yes	User defined value 1	No
TAXATTR_USER_DEF_VALUE2	udd_quickcodes	varchar(25)	Yes	User defined value 2	No
TAXATTR_USER_DEF_VALUE3	udd_quickcodes	varchar(25)	Yes	User defined value 3	No
TAXATTR_USER_DEF_VALUE4	udd_quickcodes	varchar(25)	Yes	User defined value 4	No
TAXATTR_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	Created by	No
TAXATTR_MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	Modified by	No
TAXATTR_CREATEDDATE	udd_date_chk	datetime(8)	Yes	Created date	No
TAXATTR_MODIFIEDDATE	udd_date_chk	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes
created_area_code	_varchar_40	varchar(40)	Yes	Created Area code	No
TAXATTR_GENCRNOTE	udd_designparamcode	varchar(5)	Yes	Hold values of Generation of Credit note or debit note values	No
TAXATTR_SUPCODE	udd_vendorcode	varchar(45)	Yes	Tax supplier code	No
WHT_POST_FLAG	fin_designparamcode	varchar(5)	Yes	With Holding tax Post Flag	No
taxattr_erate_date_typ	fin_type	varchar(25)	Yes	Tax Rate type	No
taxattr_acct_event	fin_quickcodes	varchar(25)	Yes	Accounting Event	No
taxattr_exchrate_ref	fin_quickcodes	varchar(25)	Yes	Exchange rate reference	No
taxattr_prov_acct_flag	fin_quickcodes	varchar(25)	Yes	Provission accounting Flag	No
taxattr_erate_type	fin_type	varchar(25)	Yes	Erate Type	No
taxattr_rofmet	fin_param_text	varchar(255)	Yes	Tax Round off method	No
taxattr_rofsig	fin_param_text	varchar(255)	Yes	Rounding off Significance	No
taxattr_tax_numtype	fin_designparamcode	varchar(5)	Yes	Tax Numbering Type	No
taxattr_tax_recptaxinv	fin_designparamcode	varchar(5)	Yes	Customer Tax Invoice Required	No

Table Name :	TCD_TCDDT_TCDCODEDTL
Comment :	This is the table in which Tax/Charges/Discounts details stored

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TCDDT_LOID	_varchar_20	varchar(20)	No	tcd unique id	No
TCDDT_TCDCODE	_varchar_10	varchar(10)	No	Tcd unique code	No
TCDDT_TCDVARIANT	_varchar_10	varchar(10)	No	TCD variant code	No
TCDDT_VERSIONNO	_decimal_10_0	decimal(10)	No	TCD version no	No
TCDDT_VARIANTDESC	_varchar_40	varchar(40)	No	TCD variant code description	No
TCDDT_VARIANTVALUE	_decimal_28_8	decimal(28)	No	TCD variant code calue	No
TCDDT_EFFFROMDT	_datetime_8	datetime(8)	Yes	TCD effective from date	No
TCDDT_EFFTODT	_datetime_8	datetime(8)	Yes	TCD effective to date	No
TCDDT_ACCOUNTRULE	_char_2	char(2)	No	TCD account rule	No
TCDDT_CREATED_AT	_decimal_10_0	decimal(10)	No	TCD created place	No
TCDDT_STATUS	_char_2	char(2)	No	TCD status	No
TCDDT_CREATED_BY	_varchar_30	varchar(30)	No	the person who created the TCD code	No
TCDDT_CREATED_DATE	_datetime_8	datetime(8)	No	the date on which the TCD created	No
TCDDT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	the person who modified the TCD code	No
TCDDT_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	the date on which the TCD code modified	No
TCDDT_VARIANTDESC_UPP	_varchar_40	varchar(40)	No	TCD variant code description in upper case	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	TCD_TCDHD_TCDCODEHDR
Comment :	This is the table in which Tax/Charges/Discounts header values stored

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TCDHD_LOID	_varchar_20	varchar(20)	No	TCD unique id	No
TCDHD_TCDCODE	_varchar_10	varchar(10)	No	Tcd unique code	No
TCDHD_TCDDESCRIPTION	_varchar_40	varchar(40)	No	TCD code description	No
TCDHD_STATUS	_char_2	char(2)	No	TCD status	No
TCDHD_TCDTYPE	_char_2	char(2)	No	TCD code type	No
TCDHD_TCDBASIS	_char_2	char(2)	No	TCD code basis	No
TCDHD_FOLDER	_varchar_10	varchar(10)	Yes	TCD folder	No
TCDHD_TCDAPPON	_char_2	char(2)	Yes	TCD applicable value	No
TCDHD_CREATED_AT	_decimal_10_0	decimal(10)	No	TCD created	No
TCDHD_CREATED_BY	_varchar_30	varchar(30)	No	the person who created the TCD code	No
TCDHD_CREATED_DATE	_datetime_8	datetime(8)	No	the date on which tcd code created	No
TCDHD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	the person who modified the TCD code	No
TCDHD_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	the date on which tcd code modified	No
TCDHD_TIMESTAMP	_decimal_10_0	decimal(10)	No	TCD code status	No
TCDHD_TCDDESCRIPTION_UPP	_varchar_40	varchar(40)	No	TCD code descriptopn in upper	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	TCD_TCDHD_TCD_CODE_HDR
Comment :	This is the table in which Tax/Charges/discount codes are defined.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TCDHD_TCD_CODE	_varchar_25	Varchar(25)	No	TCD code	Yes
TCDHD_CREATED_OUINSTANCE	_int_0	int(0)	No	TCD code created OU instance	Yes
TCDHD_TCD_CODE_DESC	_varchar_80	varchar(80)	Yes	TCD code description	No
TCDHD_TCD_CODE_DESC_UP	_varchar_80	varchar(80)	Yes	TCD code descriptopn in upper	No
TCDHD_TCD_CODE_TYPE	_varchar_5	varchar(5)	Yes	TCD code type	No
TCDHD_TCD_CODE_BASIS	_varchar_5	varchar(5)	Yes	TCD code basis	No
TCDHD_TCD_CODE_CATEGORY	_varchar_25	Varchar(25)	Yes	TCD code category	No
TCDHD_APP_ON_BASIC_VALUE	_decimal_10_0	decimal(10)	Yes	TCD applicable basic value	No
TCDHD_APP_ON_TOTAL_VALUE	_decimal_10_0	decimal(10)	Yes	TCD applicable total value	No
TCDHD_TCD_CODE_FROM_DATE	_datetime_8	datetime(8)	Yes	TCD code effective from date	No
TCDHD_TCD_CODE_TO_DATE	_datetime_8	datetime(8)	Yes	TCD code effective to date	No
TCDHD_TCD_CODE_STATUS	_varchar_5	varchar(5)	Yes	TCD code satus	No
TCDHD_CREATEDDATE	_datetime_8	datetime(8)	Yes	the date on which tcd code created	No
TCDHD_CREATED_BY	_varchar_30	varchar(30)	Yes	the person who created the TCD code	No
TCDHD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	the date on which TCD code modified	No
TCDHD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	the person who modified the TCD code	No
TCDHD_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field is to capture the timestamp of the record	No

Table Name :	TCD_TCDMP_TCD_CODE_MAP
Comment :	THis table holds the mapping details of TCD codes .This table will not contain unmapped TCD codes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TCDMP_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ou instance in which TCD codes are defined	Yes
TCDMP_TCD_CODE	_varchar_25	Varchar(25)	No	This field captures the codes defined for Tax/Charges/discounts	Yes
TCDMP_TCD_MAP_ID	_decimal_10_0	decimal(10)	No	This is uniquely generated Tax/Charges/Discounts map id	Yes
TCDMP_APP_ON_TCD_CODE	_varchar_25	Varchar(25)	Yes	The tcd code which is mapped to tcd code given in header. ie) mapped tcd code	No
TCDMP_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field is to capture the created date of the record	No
TCDMP_CREATED_BY	_varchar_30	varchar(30)	Yes	This field is to capture the user who created the record	No
TCDMP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field is to capture the modified date of the record .	No
TCDMP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field is to capture the user who modified the record	No

Table Name :	TCD_TCDPRM_PARAMETER_DTL
Comment :	This is the table in which parameter details of the TCD component are stored

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TCDPRM_COMPONENTNAME	_varchar_80	varchar(80)	No	This field holds the Name of the component.	Yes
TCDPRM_PARAMCATEGORY	_varchar_10	varchar(10)	No	This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.	Yes
TCDPRM_PARAMTYPE	_varchar_25	Varchar(25)	No	Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.	Yes
TCDPRM_PARAMCODE	_varchar_5	varchar(5)	No	This is the code that may be used for data storage. This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained.	Yes
TCDPRM_LANGID	_decimal_10_0	decimal(10)	No	Language id. This is the language id of the record.	Yes
TCDPRM_PARAMDESC	_varchar_80	varchar(80)	Yes	Param description is the values to be filled in the combo box or guidance text. This is actually the meta data of this component	No
TCDPRM_CREATIONDATE	_datetime_8	datetime(8)	Yes	This field holds the record created date for auditing purpose.	No

Table Name :	TCD_TCDSQ_TCD_SEQUENCE
Comment :	This temporary table is used internally by TCD component for sequencing of dependant TCD codes based on mapping.Eventhough the calculation is based on the sequence of entries by user,this table is used to avoid cyclic reference of mapping.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TCDSQ_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ou instance in which TCD codes are defined	Yes
TCDSQ_TCD_CODE	_varchar_25	Varchar(25)	No	This field captures the codes defined for Tax/Charges/discounts	Yes
TCDSQ_TCD_SEQUENCE_NO	_decimal_10_0	decimal(10)	Yes	This is the sequence number generated by the system based on the mapping of TCD codes	No
TCDSQ_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field contains the created date of the record.	No
TCDSQ_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the record	No
TCDSQ_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field contains the modified date of the record	No
TCDSQ_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Theis field holds the user who modified the record	No

Table Name :	TCD_TCDVDT_TCD_VAR_DTL
Comment :	This is the table in which Tax/Charges/discount variants are defined.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TCDVDT_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ou instance in which TCD codes are defined	Yes
TCDVDT_TCD_CODE	_varchar_25	Varchar(25)	No	This field captures the codes defined for Tax/Charges/discounts	Yes
TCDVDT_TCD_VAR_CODE	_varchar_25	Varchar(25)	No	This field captures the variant code for Tax/Charges/Discounts	Yes
TCDVDT_TCD_VAR_DESC	_varchar_80	varchar(80)	Yes	This field captures the variant description for Tax/Charges/Discounts	No
TCDVDT_TCD_VAR_VALUE	_decimal_28_8	decimal(28)	Yes	This field captures the variant value for Tax/Charges/Discounts	No
TCDVDT_TCD_VAR_STATUS	_varchar_5	varchar(5)	Yes	This field captures the variant status for Tax/Charges/Discounts. Allowed values are A- Active I-Inactive	No
TCDVDT_TCD_ACCT_RULE	_varchar_5	varchar(5)	Yes	ATS - "Add To Stock" E - "Expense"	No
TCDVDT_TCD_VAR_FROM_DATE	_datetime_8	datetime(8)	Yes	This is the TCD variant which holds the effective from date of the record	No
TCDVDT_TCD_VAR_TO_DATE	_datetime_8	datetime(8)	Yes	This is the TCD variant which holds the effective to date of the record	No
TCDVDT_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field is to capture the created date of the record	No
TCDVDT_CREATED_BY	_varchar_30	varchar(30)	Yes	This field is to capture the user who created the record	No
TCDVDT_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field is to capture the modified date of the record .	No
TCDVDT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field is to capture the user who modified the record	No
TCDVDT_TAX_KEY	_varchar_15	varchar(15)	Yes	This field is to store tax key code	No
TCDVDT_TAX_KEY_DESC	_varchar_40	varchar(40)	Yes	This field is to store tax key code description	No