Installation Parameter Setup |
|||||
|
|
|||||
|
Table Name ips_processparam_sys |
|
||||
|
|
|||||
|
Table Comment Stores the information of user setting values that are done in Ips component. |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
parameter_type |
varchar(6) |
NOT NULL |
Parameter Type |
Yes |
No |
|
parameter_category |
varchar(16) |
NOT NULL |
Parameter Category |
Yes |
No |
|
language_id |
int |
NOT NULL |
Language Id |
Yes |
No |
|
company_code |
varchar(10) |
NOT NULL |
Company Code |
Yes |
No |
|
ou_id |
int |
NOT NULL |
Organization Unit Id |
Yes |
No |
|
timestamp |
int |
NULL |
Time Stamp |
No |
No |
|
parameter_code |
varchar(30) |
NULL |
Parameter 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 |
|
|
|
|
|
|
|