Company Parameter Setup |
|||||
|
|
|||||
|
Table Name cps_processparam_his |
|
||||
|
|
|||||
|
Table Comment Stores the history of user setting values that are done in Cps component. |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
timestamp |
int |
NULL |
Time Stamp |
No |
No |
|
ou_id |
int |
NULL |
Organization Unit Id |
No |
No |
|
parameter_type |
varchar(6) |
NULL |
Parameter Type |
No |
No |
|
parameter_category |
varchar(16) |
NULL |
Parameter Category |
No |
No |
|
parameter_code |
varchar(30) |
NULL |
Parameter Code |
No |
No |
|
language_id |
int |
NULL |
Language Id |
No |
No |
|
company_code |
varchar(10) |
NULL |
Company Code |
No |
No |
|
parameter_text |
varchar(100) |
NULL |
Parameter Text |
No |
No |
|
extension_flag |
varchar(1) |
NULL |
Extension Flag |
No |
No |
|
createdby |
varchar(15) |
NULL |
Created By |
No |
No |
|
createddate |
datetime |
NULL |
Created Date |
No |
No |
|
modifiedby |
varchar(15) |
NULL |
Modified By |
No |
No |
|
modifieddate |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name cps_processparam_his_roff |
|
||||
|
|
|||||
|
Table Comment Stores the history of Round Off user setting values that are done in Cps component. |
| ||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
timestamp |
int |
NULL |
Time Stamp |
No |
No |
|
ou_id |
int |
NULL |
Organization Unit Id |
No |
No |
|
bfg_code |
varchar(20) |
NULL |
Business Function Group Code |
No |
No |
|
company_code |
varchar(10) |
NULL |
Company Code |
No |
No |
|
value_type |
varchar(18) |
NULL |
Value Type |
No |
No |
|
curr_code |
varchar(5) |
NULL |
Currency Code |
No |
No |
|
significance |
numeric(28,8) |
NULL |
Significance |
No |
No |
|
language_id |
int |
NULL |
Language Id |
No |
No |
|
method |
varchar(30) |
NULL |
Method |
No |
No |
|
createdby |
varchar(15) |
NULL |
Created By |
No |
No |
|
createddate |
datetime |
NULL |
Created Date |
No |
No |
|
modifiedby |
varchar(15) |
NULL |
Modified By |
No |
No |
|
modifieddate |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name cps_processparam_his_vat |
|
||||
|
|
|||||
|
Table Comment Stores the history of VAT user setting values that are done in Cps component. |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
timestamp |
int |
NULL |
Time Stamp |
No |
No |
|
ou_id |
int |
NULL |
Organization Unit Id |
No |
No |
|
country_code |
varchar(5) |
NULL |
Country Code |
No |
No |
|
company_code |
varchar(40) |
NULL |
Company Code |
No |
No |
|
vat_reg_id |
varchar(40) |
NULL |
Value Added Tax Registered Id |
No |
No |
|
language_id |
int |
NULL |
Language Id |
No |
No |
|
extension_flag |
varchar(10) |
NULL |
Extension Flag |
No |
No |
|
createdby |
varchar(15) |
NULL |
Created By |
No |
No |
|
createddate |
datetime |
NULL |
Created Date |
No |
No |
|
modifiedby |
varchar(15) |
NULL |
Modified By |
No |
No |
|
modifieddate |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name cps_processparam_sys |
|
||||
|
|
|||||
|
Table Comment Stores the information of user setting values that are done in Cps component. |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
company_code |
varchar(10) |
NOT NULL |
Company Code |
Yes |
No |
|
ou_id |
int |
NOT NULL |
Organization Unit Id |
Yes |
No |
|
parameter_type |
varchar(6) |
NOT NULL |
Parameter Type |
Yes |
No |
|
parameter_category |
varchar(16) |
NOT NULL |
Parameter Category |
Yes |
No |
|
parameter_code |
varchar(30) |
NOT NULL |
Parameter Code |
Yes |
No |
|
language_id |
int |
NOT NULL |
Language Id |
Yes |
No |
|
timestamp |
int |
NULL |
Time Stamp |
No |
No |
|
parameter_text |
varchar(100) |
NULL |
Parameter Text |
No |
No |
|
extension_flag |
varchar(1) |
NULL |
Extension Flag |
No |
No |
|
createdby |
varchar(15) |
NULL |
Created By |
No |
No |
|
createddate |
datetime |
NULL |
Created Date |
No |
No |
|
modifiedby |
varchar(15) |
NULL |
Modified By |
No |
No |
|
modifieddate |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name cps_processparam_sys_roff |
|
||||
|
|
|||||
|
Table Comment Stores the information of Round Off user setting values that are done in Cps component. |
| ||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
company_code |
varchar(10) |
NOT NULL |
Company Code |
Yes |
No |
|
ou_id |
int |
NOT NULL |
Organization Unit Id |
Yes |
No |
|
bfg_code |
varchar(20) |
NOT NULL |
Business Function Group Code |
Yes |
No |
|
timestamp |
int |
NULL |
Time Stamp |
No |
No |
|
value_type |
varchar(18) |
NULL |
Value Type |
No |
No |
|
curr_code |
varchar(5) |
NULL |
Currency Code |
No |
No |
|
significance |
numeric(28,8) |
NULL |
Significance |
No |
No |
|
language_id |
int |
NULL |
Language Id |
No |
No |
|
method |
varchar(30) |
NULL |
Method |
No |
No |
|
createdby |
varchar(15) |
NULL |
Created By |
No |
No |
|
createddate |
datetime |
NULL |
Created Date |
No |
No |
|
modifiedby |
varchar(15) |
NULL |
Modified By |
No |
No |
|
modifieddate |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name cps_processparam_sys_vat |
|
||||
|
|
|||||
|
Table Comment Stores the information of VAT user setting values that are done in Cps component. |
| ||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
company_code |
varchar(10) |
NOT NULL |
Company Code |
Yes |
No |
|
ou_id |
int |
NOT NULL |
Organization Unit Id |
Yes |
No |
|
country_code |
varchar(5) |
NOT NULL |
Country Code |
Yes |
No |
|
timestamp |
int |
NULL |
Time Stamp |
No |
No |
|
vat_reg_id |
varchar(40) |
NULL |
Value Added Tax Register Id |
No |
No |
|
language_id |
int |
NULL |
Language Id |
No |
No |
|
extension_flag |
varchar(10) |
NULL |
Extension Flag |
No |
No |
|
createdby |
varchar(15) |
NULL |
Created By |
No |
No |
|
createddate |
datetime |
NULL |
Created Date |
No |
No |
|
modifiedby |
varchar(15) |
NULL |
Modified By |
No |
No |
|
modifieddate |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|
|
|
|
|