Data Dictionary -- Company Parameter Setup

Srl. No.	Table Name	Comment
1	cps_processparam_his	Stores the History of User Setting Values
2	cps_processparam_his_roff	Stores the History of RoundOff User Setting Values
3	cps_processparam_his_vat	Stores the History of VAT User Setting Values
4	cps_processparam_sys	Stores the Information of User Setting Values
5	cps_processparam_sys_roff	Stores the Information of RoundOff User Setting Values
6	cps_processparam_sys_vat	Stores the Information of VAT User Setting Values
7	cps_process_param_fa_info	Stores the Information of Param Values

Table Name :	cps_processparam_his
Comment :	Stores the History of User Setting Values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
parameter_type	fin_param_type	varchar(6)	Yes	Parameter type	No
parameter_category	fin_param_categ	varchar(16)	Yes	Parameter category	No
parameter_code	fin_paramcode	varchar(30)	Yes	Parameter code	No
language_id	fin_languageid	int(4)	Yes	Language id	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
parameter_text	fin_remarks	varchar(100)	Yes	Parameter text	No
extension_flag	fin_eflag	varchar(1)	Yes	Extension flag	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	cps_processparam_his_roff
Comment :	Stores the History of RoundOff User Setting Values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ouinstid	int(4)	Yes	Oraganization unit id	No
bfg_code	fin_bfgid	varchar(20)	Yes	bfg code	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
value_type	fin_rule	varchar(18)	Yes	Value type	No
curr_code	fin_currencycode	varchar(5)	Yes	Current code	No
significance	fin_amount	numeric(13)	Yes	Significance	No
language_id	fin_languageid	int(4)	Yes	Language id	No
method	fin_method	varchar(30)	Yes	Method	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	cps_processparam_his_vat
Comment :	Stores the History of VAT User Setting Values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
country_code	fin_countrycode	varchar(5)	Yes	Country code	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
vat_reg_id	fin_desc40	varchar(40)	Yes	Vat registration id	No
language_id	fin_languageid	int(4)	Yes	Language id	No
extension_flag	fin_extentid	varchar(10)	Yes	Extension flag	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	cps_processparam_sys
Comment :	Stores the Information of User Setting Values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
parameter_type	fin_param_type	varchar(6)	No	Parameter type	Yes
parameter_category	fin_param_categ	varchar(16)	No	Parameter category	Yes
parameter_code	fin_paramcode	varchar(30)	No	Paramater code	Yes
language_id	fin_languageid	int(4)	No	Lanaguage id	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
parameter_text	fin_remarks	varchar(100)	Yes	Parameter text	No
extension_flag	fin_eflag	varchar(1)	Yes	Extension flag	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	cps_processparam_sys_roff
Comment :	Stores the Information of RoundOff User Setting Values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
ou_id	fin_ouinstid	int(4)	No	Organizaton unit id	Yes
bfg_code	fin_bfgid	varchar(20)	No	bfg code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
value_type	fin_rule	varchar(18)	Yes	Value type	No
curr_code	fin_currencycode	varchar(5)	Yes	Current code	No
significance	fin_amount	numeric(13)	Yes	Significance	No
language_id	fin_languageid	int(4)	Yes	Language id	No
method	fin_method	varchar(30)	Yes	Method	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_Datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_Datetime	datetime(8)	Yes	Modified date	No

Table Name :	cps_processparam_sys_vat
Comment :	Stores the Information of VAT User Setting Values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
country_code	fin_countrycode	varchar(5)	No	Country code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
vat_reg_id	fin_desc40	varchar(40)	Yes	Vat registration id	No
language_id	fin_languageid	int(4)	Yes	Language id	No
extension_flag	fin_extentid	varchar(10)	Yes	Extension flag	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	cps_process_param_fa_info
Comment :	Stores the Information of Param Values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	Yes	Company code	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
first_number	fin_serialno	varchar(18)	Yes	First number	No
last_number	fin_serialno	varchar(18)	Yes	Last number	No
createddate	fin_date	datetime(8)	Yes	Created date	No
modifieddate	fin_date	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_int	int(4)	No	REPLICATION_KEY	Yes