Taxes Charges and Discounts

Taxes Charges and Discounts

Table Name Fin_company_taxtype_map
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
LANGUAGE_ID	tinyint	NULL	Language	No	No
OUINSTANCE	int	NULL	OU Instance	No	No
COMPANY_CODE	varchar(16)	NULL	Company code	No	No
TAXTYPE_CODE	varchar(20)	NULL	Tax type code	No	No
EFFECTIVE_FROM	datetime	NULL	Effective from date	No	No
EFFECTIVE_TO	datetime	NULL	Effective To date	No	No
MAP_STATUS	varchr(25)	NULL	Map Status	No	No
TIMESTAMP	int	NULL	Timestamp	No	No
CREATEDBY	varchar(30)	NULL	Created by	No	No
CREATEDDATE	varchr(15)	NULL	Created date	No	No
MODIFIEDBY	varchar(30)	NULL	Modified by	No	No
MODIFIEDDATE	varchar(15)	NULL	Modified date	No	No

Table Name TCD_Taxattr_Applic_Rule_Met
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
LANGUAGE_ID	tinyint	NULL	Language id	No	No
COMPONENT_ID	char(18)	NULL	Component id	No	No
SEQUENCE_NO	numeric(18)	NULL	Sequence no.	No	No
TAXTYPE_CODE	varchar(20)	NULL	Tax type code	No	No
APPLICABILITY_CODE	varchar(25)	NULL	Applicability code	No	No
APPLICABILITY_DESC	varchar(25)	NULL	Applicability Description	No	No
TIMESTAMP	int	NULL	Timestamp	No	No
CREATEDBY	varchar(30)	NULL	Created by	No	No
CREATEDDATE	varchar(15)	NULL	Created date	No	No
MODIFIEDBY	varchar(30)	NULL	Modified by	No	No
MODIFIEDDATE	varchar(15)	NULL	Modified date	No	No

Table Name TCD_Taxattr_Categ_Rule_Met
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
LANGUAGE_ID	smallint	NULL	Language id	No	No
COMPONENT_ID	varchar(20)	NULL	Component id	No	No
SEQUENCE_NO	numeric(18)	NULL	Sequence no.	No	No
TAXTYPE_CODE	varchar(20)	NULL	Tax type code	No	No
APPLICABILITY_CODE	varchar(25)	NULL	Applicability code	No	No
TAXCATEGORY_CODE	varchar(25)	NULL	Tax category code	No	No
TAXCATEGORY_DESC	varchar(25)	NULL	Tax category description	No	No
TIMESTAMP	int	NULL	Timestamp	No	No
CREATEDBY	varchar(30)	NULL	Created by	No	No
CREATEDDATE	varchar(15)	NULL	Created date	No	No
MODIFIEDBY	varchar(30)	NULL	Modified by	No	No
MODIFIEDDATE	varchar(15)	NULL	Modified date	No	No

Table Name TCD_Taxattr_Class_Rule_Met
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
LANGUAGE_ID	tinyint	NULL	Language id	No	No
COMPONENT_ID	varchar(20)	NULL	Component id	No	No
SEQUENCE_NO	numeric(18)	NULL	Sequence no.	No	No
TAXTYPE_CODE	varchar(20)	NULL	Tax type code	No	No
TAXCATEGORY_CODE	varchar(25)	NULL	Tax category code	No	No
TAXCLASS_CODE	varchar(20)	NULL	Tax class code	No	No
TAXCLASS_DESC	varchar(20)	NULL	Tax class description	No	No
TIMESTAMP	int	NULL	Timestamp	No	No
CREATEDBY	varchar(30)	NULL	Created by	No	No
CREATEDDATE	varchar(15)	NULL	Created date	No	No
MODIFIEDBY	varchar(30)	NULL	Modified by	No	No
MODIFIEDDATE	varchar(15)	NULL	Modified date	No	No

Table Name TCD_Taxattr_Incid_Rule_Met
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
LANGUAGE_ID	tinyint	NULL	Language id	No	No
COMPONENT_ID	varchar(20)	NULL	Component id	No	No
SEQUENCE_NO	numeric(18)	NULL	Sequence no.	No	No
TAXTYPE_CODE	varchar(20)	NULL	Tax type code	No	No
INCIDENCE_CODE	varchar(40)	NULL	Incidence code	No	No
INCIDENCE_DESC	varchar(40)	NULL	Incidence description	No	No
TIMESTAMP	int	NULL	Timestamp	No	No
CREATEDBY	varchar(30)	NULL	Created by	No	No
CREATEDDATE	varchar(15)	NULL	Created date	No	No
MODIFIEDBY	varchar(30)	NULL	Modified by	No	No
MODIFIEDDATE	varchar(15)	NULL	Modified date	No	No

Table Name TCD_Taxattr_Nature_Rule_Met
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
LANGUAGE_ID	tinyint	NULL	Language id	No	No
COMPONENT_ID	varchar(20)	NULL	Component id	No	No
SEQUENCE_NO	numeric(18)	NULL	Sequence no.	No	No
TAXTYPE_CODE	varchar(20)	NULL	Tax type code	No	No
APPLICABILITY_CODE	varchar(25)	NULL	Applicability code	No	No
TAXNATURE_CODE	varchar(25)	NULL	Tax nature code	No	No
TAXNATURE_DESC	varchar(25)	NULL	Tax nature description	No	No
TIMESTAMP	int	NULL	Timestamp	No	No
CREATEDBY	varchar(30)	NULL	Created by	No	No
CREATEDDATE	varchar(15)	NULL	Created date	No	No
MODIFIEDBY	varchar(30)	NULL	Modified by	No	No
MODIFIEDDATE	varchar(15)	NULL	Modified date	No	No

Table Name TCD_TAXATTR_TAX_ATTR_HDR
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
TAXATTR_CREATED_OUINSTANCE	varchar(256)	NULL	This is the OU instance in which TCD codes are defined	No	No
TAXATTR_TCD_CODE	varchar(25)	NULL	This field captures the codes defined for Tax/Charges/discounts	No	No
TAXATTR_TCD_VAR_CODE	varchar(25)	NULL	This field captures the variant codes defined for Tax/Charges/discounts	No	No
TAXATTR_TCD_CODE_BASIS	varchar(25)	NULL	TCD Code basis	No	No
TAXATTR_TAX_KEY	varchar(15)	NULL	Tax key	No	No
TAXATTR_TCD_VAR_FROM_DATE	datetime	NULL	Effective from date	No	No
TAXATTR_TCD_VAR_TO_DATE	datetime	NULL	Effective to date	No	No
TAXATTR_TIMESTAMP	int	NULL	Timestamp	No	No
TAXATTR_TAX_TYPE	varchar(20)	NULL	Tax type	No	No
TAXATTR_TAX_APPL	varchar(25)	NULL	Tax applicability	No	No
TAXATTR_TAX_INCID	varchar(40)	NULL	Tax Incidence	No	No
TAXATTR_TAX_NATURE	varchar(25)	NULL	Tax nature	No	No
TAXATTR_TAX_CATEGORY	varchar(25)	NULL	Tax Category	No	No
TAXATTR_TAX_CLASS	varchar(20)	NULL	Tax class	No	No
TAXATTR_TAX_APPR	varchar(25)	NULL	Tax Appropriation	No	No
TAXATTR_PERC_ALLOW	numeric(28,8)	NULL	Percentage Allowed	No	No
TAXATTR_THRES_BASIS	varchar(25)	NULL	Threshold basis	No	No
TAXATTR_THRES_VALUE	numeric(28,8)	NULL	Threshold Value	No	No
TAXATTR_USER_DEF_VALUE1	varchar(25)	NULL	User defined value 1	No	No
TAXATTR_USER_DEF_VALUE2	varchar(25)	NULL	User defined value 2	No	No
TAXATTR_USER_DEF_VALUE3	varchar(25)	NULL	User defined value 3	No	No
TAXATTR_USER_DEF_VALUE4	varchar(25)	NULL	User defined value 4	No	No
TAXATTR_CREATEDBY	varchar(30)	NULL	Created by	No	No
TAXATTR_MODIFIEDBY	varchar(30)	NULL	Modified by	No	No
TAXATTR_CREATEDDATE	datetime	NULL	Created date	No	No
TAXATTR_MODIFIEDDATE	datetime	NULL	Modified date	No	No

Table Name TCD_TCDHd_TCD_Code_Hdr

Table Comment This is the table in which Tax/Charges/discount codes are defined.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
TCDHd_TCD_Code	varchar(25)	NOT NULL	This field captures the codes defined for Tax/Charges/discounts	Yes	No
TCDHd_Created_Ouinstance	int	NOT NULL	This is the OU instance in which TCD codes are defined	Yes	No
TCDHd_TCD_Code_Desc	varchar(80)	NULL	This field holds the description of the Tax/Charges/Discount code	No	No
TCDHD_TCD_CODE_DESC_UP	varchar(80)	NULL	This field holds the description of the Tax/Charges/Discount code in upper case	No	No
TCDHd_TCD_Code_Type	varchar(5)	NULL	This field holds the type of the Tax/Charges/Discount code. Allowed values are 1’T’ - "Tax", 2.’C’ - "Charge", 3.’D’ - "Discount"	No	No
TCDHd_TCD_Code_Basis	varchar(5)	NULL	This field holds the basis on which Tax/Charges/Discount code. is defined Allowed values are 1.’P’ - "Percentage", 2.’F’ - "Flat", 3.’U’ - "Unit Rate".	No	No
TCDHd_TCD_Code_Category	varchar(25)	NULL	This field holds the category on which Tax/Charges/Discount code. is defined. Allowed values are 1.Blank 2.Category values defined in Logisitics common master	No	No
TCDHd_App_On_Basic_Value	numeric(10)	NULL	If this applicability is set, the Tax/Charges/Discount code calculations are based on Basic value ’ABV’ - "Basic Value"	No	No
TCDHd_App_On_Total_Value	numeric(10)	NULL	If this applicability is set, the Tax/Charges/Discount code calculations are based on Total value ’ATV’ - "Total Value"	No	No
TCDHd_TCD_Code_From_Date	datetime	NULL	This is the TCD code which holds the effective from date of the record	No	No
TCDHd_TCD_Code_To_Date	datetime	NULL	This is the TCD code which holds the effective to date of the record	No	No
TCDHd_TCD_Code_Status	varchar(5)	NULL	This field holds the status of the Taxes/Charges/Discount code. Allowed values are A- Active I- Inactive	No	No
TCDHd_CreatedDate	datetime	NULL	This field is to capture the created date of the record	No	No
TCDHd_Created_By	varchar(30)	NULL	This field is to capture the user who created the record	No	No
TCDHd_ModifiedDate	datetime	NULL	This field is to capture the modified date of the record .	No	No
TCDHd_Modified_By	varchar(30)	NULL	This field is to capture the user who modified the record	No	No
TCDHd_Timestamp	numeric(10)	NULL	This field is to capture the timestamp of the record	No	No

Table Name TCD_TCDMp_TCD_Code_Map

Table Comment THis table holds the mapping details of TCD codes .This table will not contain unmapped TCD codes
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
TCDMp_Created_Ouinstance	int	NOT NULL	This is the OU instance in which TCD codes are defined	Yes	Yes
TCDMp_TCD_Code	varchar(25)	NOT NULL	This field captures the codes defined for Tax/Charges/discounts	Yes	Yes
TCDMp_TCD_Map_Id	numeric(10)	NOT NULL	This is uniquely generated Tax/Charges/Discounts map id	Yes	No
TCDMP_APP_ON_TCD_CODE	varchar(25)	NULL	The tcd code which is mapped to tcd code given in header. ie) mapped tcd code	No	No
TCDMp_CreatedDate	datetime	NULL	This field is to capture the created date of the record	No	No
TCDMp_Created_By	varchar(30)	NULL	This field is to capture the user who created the record	No	No
TCDMp_ModifiedDate	datetime	NULL	This field is to capture the modified date of the record .	No	No
TCDMp_Modified_By	varchar(30)	NULL	This field is to capture the user who modified the record	No	No

Table Name TCD_TCDPrm_parameter_dtl

Table Comment This is the table in which parameter details of the TCD component are stored
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
TCDPrm_ComponentName	varchar(80)	NOT NULL	This field holds the Name of the component.	Yes	No
TCDPrm_ParamCategory	varchar(10)	NOT NULL	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	No
TCDPrm_ParamType	varchar(25)	NOT NULL	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	No
TCDPrm_ParamCode	varchar(5)	NOT NULL	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	No
TCDPrm_Langid	numeric(10)	NOT NULL	Language id. This is the language id of the record.	Yes	No
TCDPrm_ParamDesc	varchar(80)	NULL	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	No
TCDPrm_CreationDate	datetime	NULL	This field holds the record created date for auditing purpose.	No	No

Table Name TCD_TCDSq_TCD_Sequence

Table Comment This temporary table is used internally by TCD component for sequencing of dependant TCD codes based on mapping. Even though the calculation is based on the sequence of entries by user,this table is used to avoid cyclic reference of mapping.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
TCDSq_Created_By	varchar(30)	NULL	This field holds the user who created the record	No	No
TCDSq_CreatedDate	datetime	NULL	This field contains the created date of the record.	No	No
TCDSq_ModifiedDate	datetime	NULL	This field contains the modified date of the record	No	No
TCDSq_Modified_By	varchar(30)	NULL	This field holds the user who modified the record	No	No
TCDSQ_Created_Ouinstance	int	NOT NULL	This is the OU instance in which TCD codes are defined	Yes	Yes
TCDSq_TCD_Sequence_No	numeric(10)	NULL	This is the sequence number generated by the system based on the mapping of TCD codes	No	No
TCDSQ_TCD_Code	varchar(25)	NOT NULL	This field captures the codes defined for Tax/Charges/discounts	Yes	Yes

Table Name TCD_TCDVDt_TCD_Var_Dtl

Table Comment This is the table in which Tax/Charges/discount variants are defined.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
TCDVDt_Created_Ouinstance	int	NOT NULL	This is the OU instance in which TCD codes are defined	Yes	Yes
TCDVDt_TCD_Code	varchar(25)	NOT NULL	This field captures the codes defined for Tax/Charges/discounts	Yes	Yes
TCDVDt_TCD_Var_Code	varchar(25)	NOT NULL	This field captures the variant code for Tax/Charges/Discounts	Yes	No
TCDVDt_TCD_Var_Desc	varchar(80)	NULL	This field captures the variant description for Tax/Charges/Discounts	No	No
TCDVDt_TCD_Var_Value	decimal(28,8)	NULL	This field captures the variant value for Tax/Charges/Discounts	No	No
TCDVDt_TCD_Var_Status	varchar(5)	NULL	This field captures the variant status for Tax/Charges/Discounts. Allowed values are A- Active I-Inactive	No	No
TCDVDT_TCD_ACCT_RULE	varchar(5)	NULL	’ATS’ - "Add To Stock" ’E’ - "Expense"	No	No
TCDVDt_TCD_Var_From_Date	datetime	NULL	This is the TCD variant which holds the effective from date of the record	No	No
TCDVDt_TCD_Var_To_Date	datetime	NULL	This is the TCD variant which holds the effective to date of the record	No	No
TCDVDt_CreatedDate	datetime	NULL	This field is to capture the created date of the record	No	No
TCDVDt_Created_By	varchar(30)	NULL	This field is to capture the user who created the record	No	No
TCDVDt_ModifiedDate	datetime	NULL	This field is to capture the modified date of the record .	No	No
TCDVDt_Modified_By	varchar(30)	NULL	This field is to capture the user who modified the record	No	No
TCDVDT_TAX_KEY	varchar(15)	NULL	This field holds the tax key value.	No	No
TCDVDT_TAX_KEY_DESC	varchar(40)	NULL	This field holds the tax key description.	No	No