INSERT INTO ITM2MENU 
(
	APPLICATION,
	LEVEL_1,
	LEVEL_2,
	LEVEL_3,
	LEVEL_4,
	LEVEL_5,
	WIN_NAME,
	DESCR,
	COMMENTS,
	MENU_PATH,
	ICON_PATH,
	OBJ_TYPE,
	CHG_USER,
	CHG_TERM,
	CHG_DATE,
	OPEN_ICON,
	CLOSE_ICON
)
VALUES
(
	'DIS',
	2,31,1,0,0,
	'w_sorder_type',
	'A.Sales Order Type',
	null,
	'DIS.2.31.1.0.0',
	null,
	null,
	null,
	null,
	null,
	null,
	null
);


INSERT INTO TRANSETUP
(TRAN_WINDOW,SAVE_FLAG,VAL_FLAG,KEY_FLAG,KEY_STRING,REPEATE_ADD,CHG_DATE,CHG_USER,CHG_TERM,
 EDI_OPTION,SITE_ACC_COL,CONFIRM_COL,CONFIRM_VAL,LEDG_POST_CONF,CHG_DATE_ON_CONF,TRAN_ID_COL,
 CONFIRM_MODE,MAIL_OPTION,GARBAGE_OPT,REF_SER,VIEW_MODE) 
VALUES 
('w_sorder_type','2','2','M','site_code,tran_date,seq04','Y',sysdate,'BASE','BASE',
 null,'SITE_CODE',null,null,'N','Y','TRAN_ID',
 '0','0','N','S-STK',null);	

INSERT INTO OBJ_FORMS
(
win_name,
title,
obj_brow_name,
obj_edit_name,	
form_no,
auto_accept_scan,
scan_metadata,
scan_flag,
scan_delimiter,
auto_accept_weighdata
)
values (
'w_sorder_type',
'header',
'd_sorder_type11',
'd_sorder_type21',
'1',
null,
null,
null,
null,
null
);	


INSERT INTO OBJ_ACTIONS 
(	
	OBJ_NAME ,
	LINE_NO ,
	RIGHTS_CHAR,
	INTERACTIVE,
	SERVICE_CODE,
	DESCRIPTION,
	TITLE,
	IMAGE,
	ACTION_TYPE,
	FORM_NO,
	SERVICE_HANDLER,
	PLACEMENT,
	TRAN_TYPE
) VALUES (
	'sorder_type',
	'1',
	'A',
	'a',
	'a',
	'Adding New',
	'Add',
	'add.gif',
	'S',
	'1',
	NULL,
	NULL,
	NULL
);
	
INSERT INTO OBJ_ACTIONS 
(
	OBJ_NAME ,
	LINE_NO,
	RIGHTS_CHAR,
	INTERACTIVE, 
	SERVICE_CODE, 
	DESCRIPTION, 
	TITLE, 
	IMAGE,
	ACTION_TYPE,		
	FORM_NO, 
	SERVICE_HANDLER,
	PLACEMENT,
	TRAN_TYPE
) VALUES (
	'sorder_type',
	'2',
	'E',
	'a',
	'a',
	'Editing Existing Record',
	'EDIT',
	'edit.gif',
	'S',
	'1',
	NULL,
	NULL,
	NULL
);



INSERT INTO SYSTEM_EVENTS
(
	OBJ_NAME,
	EVENT_CODE,
	EVENT_CONTEXT,
	SERVICE_CODE,
	METHOD_RULE,
	CHG_DATE,
	CHG_USER,
	CHG_TERM,
	RESULT_HANDLE,
	OVERWRITE_CORE,
	COMP_TYPE,
	COMP_NAME,
	COMM_FORMAT
) VALUES (
	'sorder_type',
	'pre_validate',
	'1',
	'prv_default_ejb',
	null,
	sysdate,
	'BASE',
	'BASE',
	'2',
	'0',
	'EJB',
	'SOrderType',
	NULL
);

INSERT INTO SYSTEM_EVENTS
(	
	OBJ_NAME,
	EVENT_CODE,
	EVENT_CONTEXT,
	SERVICE_CODE,
	METHOD_RULE,
	CHG_DATE,
	CHG_USER,
	CHG_TERM,
	RESULT_HANDLE,
	OVERWRITE_CORE,
	COMP_TYPE,
	COMP_NAME,
	COMM_FORMAT
) VALUES (
	'sorder_type',
	'post_item_change',
	'1',
	'poic_default_ejb',
	null,
	sysdate,
	'BASE',
	'BASE',
	'2',
	'0',
	'EJB',
	'SOrderType',
	NULL
);

insert into messages(
MSG_NO,         
MSG_STR ,       
MSG_DESCR,      
MSG_TYPE,
MSG_OPT,
chg_date,
chg_user,
chg_term
)
values(
'VMORTYBK',
'Invalid Order Type',
'Order Type can not be blank',
'E',
'Y',
sysdate,
'base',
'base'
);

insert into messages(
MSG_NO,         
MSG_STR ,       
MSG_DESCR,      
MSG_TYPE,
MSG_OPT,
chg_date,
chg_user,
chg_term
)
values(
'VMREPRTBK',
'Invalid Replacement Rate',
'Replacement can not be blank',
'E',
'Y',
sysdate,
'base',
'base'
);



insert into messages(
MSG_NO,         
MSG_STR ,       
MSG_DESCR,      
MSG_TYPE,
MSG_OPT,
chg_date,
chg_user,
chg_term
)
values(
'VMORTYDB',
'Invalid Order Type',
'Order Type  allready exist in master',
'E',
'Y',
sysdate,
'base',
'base'
);

insert into  POPHELP
(
field_name,
mod_name,
sql_str,
msg_title,
sql_input,
chg_date,
chg_user,
chg_term,
dist_opt
)
values
(
'PRICE_LIST__CLG',
'W_SORDER_TYPE',
'select price_list,descr from pricelist_mst',
'Price List',
NULL,
sysdate,
'BASE',
'BASE',
'1'
);

-----added by akhilesh S on 27/AUG/12

alter table sordertype add returnable  char(1);
alter table sordertype add reas_code  char(5);

insert into  POPHELP
(
field_name,
mod_name,
sql_str,
msg_title,
sql_input,
chg_date,
chg_user,
chg_term,
dist_opt
)
values
(
'REAS_CODE',
'W_SORDER_TYPE',
'select fld_value,descr from gencodes',
'REAS CODE',
NULL,
sysdate,
'BASE',
'BASE',
'1'
);


-- these two field not found in taro added by akhilesh on 27/AUG/12
alter table sordertype add fmode CHAR(1);
alter table sordertype add tax_class CHAR(5);
