--RECIBIR DE PARAMETRO EL CODIGO DE SITE PARA LOS PRODUCTOS
insert into country (COUNTRYID,DESCR) values ('PER','PERU')
insert into country (COUNTRYID,DESCR) values ('BRA','Brazil')
insert into country (COUNTRYID,DESCR) values ('CAN','Canada')
insert into country (COUNTRYID,DESCR) values ('CHL','Chile')
insert into country (COUNTRYID,DESCR) values ('COL','Colombia')
insert into country (COUNTRYID,DESCR) values ('ECU','Ecuador')
insert into country (COUNTRYID,DESCR) values ('GER','Germany')
insert into country (COUNTRYID,DESCR) values ('USA','United States')
insert into country (COUNTRYID,DESCR) values ('VEN','Venezuela')

insert into state (STATEID,DESCR ) values ('LI','LIMA')
insert into state (STATEID,DESCR ) values ('AM','Amazonas')
insert into state (STATEID,DESCR ) values ('AN','Ancash')
insert into state (STATEID,DESCR ) values ('AP','Apurimac')
insert into state (STATEID,DESCR ) values ('AR','Arequipa')
insert into state (STATEID,DESCR ) values ('AY','Ayacucho')
insert into state (STATEID,DESCR ) values ('CH','Chimbote')
insert into state (STATEID,DESCR ) values ('CJ','Cajamarca')
insert into state (STATEID,DESCR ) values ('CP','Cerro de Pasco')
insert into state (STATEID,DESCR ) values ('CU','Cuzco')
insert into state (STATEID,DESCR ) values ('HC','Huancavelica')
insert into state (STATEID,DESCR ) values ('HU','Huanuco')
insert into state (STATEID,DESCR ) values ('IC','Ica')
insert into state (STATEID,DESCR ) values ('JU','Junin')
insert into state (STATEID,DESCR ) values ('LA','Lambayeque')
insert into state (STATEID,DESCR ) values ('LL','La Libertad')
insert into state (STATEID,DESCR ) values ('LO','Loreto')
insert into state (STATEID,DESCR ) values ('MD','Madre de Dios')
insert into state (STATEID,DESCR ) values ('MO','Moquegua')
insert into state (STATEID,DESCR ) values ('PI','Piura')
insert into state (STATEID,DESCR ) values ('PU','Puno')
insert into state (STATEID,DESCR ) values ('SM','San Martin')
insert into state (STATEID,DESCR ) values ('TA','Tacna')
insert into state (STATEID,DESCR ) values ('TU','Tumbes')
insert into state (STATEID,DESCR ) values ('UC','Ucayali')

insert into city (CITYID,STATEID,DESCR) values ('000','AP','ABANCAY')
insert into city (CITYID,STATEID,DESCR) values ('01 ','LI','LIMA')
insert into city (CITYID,STATEID,DESCR) values ('001','AM','ALTO AMAZONAS')
insert into city (CITYID,STATEID,DESCR) values ('002','AM','AMAZONAS')
insert into city (CITYID,STATEID,DESCR) values ('003','HU','AMBO')
insert into city (CITYID,STATEID,DESCR) values ('004','AN','ANCASH')
insert into city (CITYID,STATEID,DESCR) values ('005','LI','ANCON')
insert into city (CITYID,STATEID,DESCR) values ('006','UC','ANDAHUAYLAS')
insert into city (CITYID,STATEID,DESCR) values ('007','UC','ANTA')
insert into city (CITYID,STATEID,DESCR) values ('008','UC','ANTONIO RAYMONDI')
insert into city (CITYID,STATEID,DESCR) values ('009','AP','APURIMAC')
insert into city (CITYID,STATEID,DESCR) values ('010','AR','AREQUIPA')
insert into city (CITYID,STATEID,DESCR) values ('011','UC','ASCOPE')
insert into city (CITYID,STATEID,DESCR) values ('012','LI','ATE VITARTE')
insert into city (CITYID,STATEID,DESCR) values ('013','AY','AYACUCHO')
insert into city (CITYID,STATEID,DESCR) values ('014','UC','AZANGARO')
insert into city (CITYID,STATEID,DESCR) values ('015','AM','BAGUA')
insert into city (CITYID,STATEID,DESCR) values ('016','LI','BARRANCA')
insert into city (CITYID,STATEID,DESCR) values ('017','LI','BARRANCO')
insert into city (CITYID,STATEID,DESCR) values ('018','LI','BELLAVISTA')
insert into city (CITYID,STATEID,DESCR) values ('019','TA','BOLOGNESI')
insert into city (CITYID,STATEID,DESCR) values ('020','UC','BONGARA')
insert into city (CITYID,STATEID,DESCR) values ('022','LI','BREÑA')
insert into city (CITYID,STATEID,DESCR) values ('023','CJ','CAJABAMBA')
insert into city (CITYID,STATEID,DESCR) values ('024','CJ','CAJAMARCA')
insert into city (CITYID,STATEID,DESCR) values ('025','UC','CALCA')
insert into city (CITYID,STATEID,DESCR) values ('026','LI','CALLAO')
insert into city (CITYID,STATEID,DESCR) values ('027','AR','CAMANA')
insert into city (CITYID,STATEID,DESCR) values ('029','UC','CANCHIS')
insert into city (CITYID,STATEID,DESCR) values ('030','LI','CANTA')
insert into city (CITYID,STATEID,DESCR) values ('031','LI','CAÑETE')
insert into city (CITYID,STATEID,DESCR) values ('032','LI','CARABAYLLO')
insert into city (CITYID,STATEID,DESCR) values ('033','LI','CARAVELI')
insert into city (CITYID,STATEID,DESCR) values ('034','JU','CARHUAMAYO')
insert into city (CITYID,STATEID,DESCR) values ('035','AN','CARHUAZ')
insert into city (CITYID,STATEID,DESCR) values ('036','AN','CASMA')
insert into city (CITYID,STATEID,DESCR) values ('037','UC','CASTILLA')
insert into city (CITYID,STATEID,DESCR) values ('038','UC','CAYLLOMA')
insert into city (CITYID,STATEID,DESCR) values ('039','UC','CELENDIN')
insert into city (CITYID,STATEID,DESCR) values ('040','CP','CERRO DE PASCO')
insert into city (CITYID,STATEID,DESCR) values ('041','LI','CHACLACAYO')
insert into city (CITYID,STATEID,DESCR) values ('042','LI','CHANCAY')
insert into city (CITYID,STATEID,DESCR) values ('043','JU','CHANCHAMAYO')
insert into city (CITYID,STATEID,DESCR) values ('044','LL','CHEPEN')
insert into city (CITYID,STATEID,DESCR) values ('045','LA','CHICLAYO')
insert into city (CITYID,STATEID,DESCR) values ('047','AN','CHIMBOTE')
insert into city (CITYID,STATEID,DESCR) values ('048','IC','CHINCHA')
insert into city (CITYID,STATEID,DESCR) values ('049','LI','CHORRILLOS')
insert into city (CITYID,STATEID,DESCR) values ('050','LI','CHOSICA')
insert into city (CITYID,STATEID,DESCR) values ('051','CJ','CHOTA')
insert into city (CITYID,STATEID,DESCR) values ('052','PU','CHUCUITO')
insert into city (CITYID,STATEID,DESCR) values ('053','PU','COLLAO')
insert into city (CITYID,STATEID,DESCR) values ('055','LI','COMAS')
insert into city (CITYID,STATEID,DESCR) values ('056','JU','CONCEPCION')
insert into city (CITYID,STATEID,DESCR) values ('057','TU','CONTRALMIRANTE VILLAR')
insert into city (CITYID,STATEID,DESCR) values ('058','UC','CORONEL PORTILLO')
insert into city (CITYID,STATEID,DESCR) values ('059','CU','CUSCO')
insert into city (CITYID,STATEID,DESCR) values ('060','CJ','CUTERVO')
insert into city (CITYID,STATEID,DESCR) values ('061','CU','CUZCO')
insert into city (CITYID,STATEID,DESCR) values ('062','HU','DOS DE MAYO')
insert into city (CITYID,STATEID,DESCR) values ('064','LI','EL AGUSTINO')
insert into city (CITYID,STATEID,DESCR) values ('065','CU','ESPINAR')
insert into city (CITYID,STATEID,DESCR) values ('066','LA','FERRAÑAFE')
insert into city (CITYID,STATEID,DESCR) values ('068','LI','HUACHIPA')
insert into city (CITYID,STATEID,DESCR) values ('069','LI','HUACHO')
insert into city (CITYID,STATEID,DESCR) values ('070','CJ','HUALGAYOC')
insert into city (CITYID,STATEID,DESCR) values ('071','SM','HUALLAGA')
insert into city (CITYID,STATEID,DESCR) values ('072','PI','HUANCABAMBA')
insert into city (CITYID,STATEID,DESCR) values ('073','PU','HUANCANE')
insert into city (CITYID,STATEID,DESCR) values ('074','HC','HUANCAVELICA')
insert into city (CITYID,STATEID,DESCR) values ('075','JU','HUANCAYO')
insert into city (CITYID,STATEID,DESCR) values ('076','AY','HUANTA')
insert into city (CITYID,STATEID,DESCR) values ('077','HU','HUANUCO')
insert into city (CITYID,STATEID,DESCR) values ('078','LI','HUARAL')
insert into city (CITYID,STATEID,DESCR) values ('079','AN','HUARAZ')
insert into city (CITYID,STATEID,DESCR) values ('080','AN','HUARI')
insert into city (CITYID,STATEID,DESCR) values ('081','AN','HUARMEY')
insert into city (CITYID,STATEID,DESCR) values ('082','LI','HUAROCHIRI')
insert into city (CITYID,STATEID,DESCR) values ('083','LI','HUAURA')
insert into city (CITYID,STATEID,DESCR) values ('084','AN','HUAYLAS')
insert into city (CITYID,STATEID,DESCR) values ('085','IC','ICA')
insert into city (CITYID,STATEID,DESCR) values ('086','MO','ILO')
insert into city (CITYID,STATEID,DESCR) values ('087','LI','INDEPENDENCIA')
insert into city (CITYID,STATEID,DESCR) values ('088','LO','IQUITOS')
insert into city (CITYID,STATEID,DESCR) values ('089','AR','ISLAY')
insert into city (CITYID,STATEID,DESCR) values ('090','CJ','JAEN')
insert into city (CITYID,STATEID,DESCR) values ('091','JU','JAUJA')
insert into city (CITYID,STATEID,DESCR) values ('092','LI','JESUS MARIA')
insert into city (CITYID,STATEID,DESCR) values ('093','TA','JORGE BASADRE GROHKAN')
insert into city (CITYID,STATEID,DESCR) values ('094','JU','JUNIN')
insert into city (CITYID,STATEID,DESCR) values ('095','UC','LA CONVENCION')
insert into city (CITYID,STATEID,DESCR) values ('096','LL','LA LIBERTAD')
insert into city (CITYID,STATEID,DESCR) values ('097','AY','LA MAR')
insert into city (CITYID,STATEID,DESCR) values ('098','LI','LA MOLINA')
insert into city (CITYID,STATEID,DESCR) values ('099','JU','LA OROYA')
insert into city (CITYID,STATEID,DESCR) values ('100','LI','LA VICTORIA')
insert into city (CITYID,STATEID,DESCR) values ('101','SM','LAMAS')
insert into city (CITYID,STATEID,DESCR) values ('102','LA','LAMBAYEQUE')
insert into city (CITYID,STATEID,DESCR) values ('103','AY','LEONCIO PRADO')
insert into city (CITYID,STATEID,DESCR) values ('105','LI','LINCE')
insert into city (CITYID,STATEID,DESCR) values ('106','LO','LORETO')
insert into city (CITYID,STATEID,DESCR) values ('107','LI','LOS OLIVOS')
insert into city (CITYID,STATEID,DESCR) values ('108','AY','LUCANAS')
insert into city (CITYID,STATEID,DESCR) values ('109','LI','LURIN')
insert into city (CITYID,STATEID,DESCR) values ('110','MD','MADRE DE DIOS')
insert into city (CITYID,STATEID,DESCR) values ('111','LI','MAGDALENA')
insert into city (CITYID,STATEID,DESCR) values ('112','LI','MALA')
insert into city (CITYID,STATEID,DESCR) values ('113','MD','MANU')
insert into city (CITYID,STATEID,DESCR) values ('114','SM','MARISCAL CACERES')
insert into city (CITYID,STATEID,DESCR) values ('115','MO','MARISCAL NIETO')
insert into city (CITYID,STATEID,DESCR) values ('116','AN','MATAHUASI')
insert into city (CITYID,STATEID,DESCR) values ('117','LO','MAYNAS')
insert into city (CITYID,STATEID,DESCR) values ('118','AR','MELGAR')
insert into city (CITYID,STATEID,DESCR) values ('119','LI','MIRAFLORES')
insert into city (CITYID,STATEID,DESCR) values ('120','AR','MOLLENDO')
insert into city (CITYID,STATEID,DESCR) values ('121','LI','MONTERRICO')
insert into city (CITYID,STATEID,DESCR) values ('122','MO','MOQUEGUA')
insert into city (CITYID,STATEID,DESCR) values ('123','PI','MORROPON')
insert into city (CITYID,STATEID,DESCR) values ('124','SM','MOYOBAMBA')
insert into city (CITYID,STATEID,DESCR) values ('125','IC','NAZCA')
insert into city (CITYID,STATEID,DESCR) values ('126','LL','OTUZCO')
insert into city (CITYID,STATEID,DESCR) values ('127','CP','OXAPAMPA')
insert into city (CITYID,STATEID,DESCR) values ('128','LL','PACASMAYO')
insert into city (CITYID,STATEID,DESCR) values ('129','UC','PADRE ABAD')
insert into city (CITYID,STATEID,DESCR) values ('130','IC','PALPA')
insert into city (CITYID,STATEID,DESCR) values ('131','CP','PASACO')
insert into city (CITYID,STATEID,DESCR) values ('132','CP','PASCO')
insert into city (CITYID,STATEID,DESCR) values ('133','CU','PAUCARTAMBO')
insert into city (CITYID,STATEID,DESCR) values ('135','JU','PERENE')
insert into city (CITYID,STATEID,DESCR) values ('137','IC','PISCO')
insert into city (CITYID,STATEID,DESCR) values ('138','PI','PIURA')
insert into city (CITYID,STATEID,DESCR) values ('139','UC','PUCALLPA')
insert into city (CITYID,STATEID,DESCR) values ('140','LI','PUEBLO LIBRE')
insert into city (CITYID,STATEID,DESCR) values ('141','LI','PUENTE PIEDRA')
insert into city (CITYID,STATEID,DESCR) values ('142','PU','PUNO')
insert into city (CITYID,STATEID,DESCR) values ('143','CU','QUISPICANCHIS')
insert into city (CITYID,STATEID,DESCR) values ('144','AN','RECUAY')
insert into city (CITYID,STATEID,DESCR) values ('145','LI','RIMAC')
insert into city (CITYID,STATEID,DESCR) values ('146','UC','RIOJA')
insert into city (CITYID,STATEID,DESCR) values ('148','LI','S. MARTIN DE PORRES')
insert into city (CITYID,STATEID,DESCR) values ('149','LI','S.JUAN DE LURIGANCHO')
insert into city (CITYID,STATEID,DESCR) values ('150','LI','S.JUAN DE MIRAFLORES')
insert into city (CITYID,STATEID,DESCR) values ('151','LI','SAN BORJA')
insert into city (CITYID,STATEID,DESCR) values ('153','UC','SAN IGNACIO')
insert into city (CITYID,STATEID,DESCR) values ('154','LI','SAN ISIDRO')
insert into city (CITYID,STATEID,DESCR) values ('155','LI','SAN JACINTO')
insert into city (CITYID,STATEID,DESCR) values ('156','LI','SAN LUIS')
insert into city (CITYID,STATEID,DESCR) values ('157','LI','SAN MARCOS')
insert into city (CITYID,STATEID,DESCR) values ('158','SM','SAN MARTIN')
insert into city (CITYID,STATEID,DESCR) values ('159','LI','SAN MIGUEL')
insert into city (CITYID,STATEID,DESCR) values ('160','JU','SAN RAMON')
insert into city (CITYID,STATEID,DESCR) values ('161','LI','SANCHEZ CARRION')
insert into city (CITYID,STATEID,DESCR) values ('162','LI','SANTA')
insert into city (CITYID,STATEID,DESCR) values ('163','LI','SANTA ANITA')
insert into city (CITYID,STATEID,DESCR) values ('164','JU','SANTA CRUZ')
insert into city (CITYID,STATEID,DESCR) values ('165','JU','SATIPO')
insert into city (CITYID,STATEID,DESCR) values ('166','PI','SECHURA')
insert into city (CITYID,STATEID,DESCR) values ('167','CU','SICUANI')
insert into city (CITYID,STATEID,DESCR) values ('168','PI','SULLANA')
insert into city (CITYID,STATEID,DESCR) values ('169','LI','SUPE')
insert into city (CITYID,STATEID,DESCR) values ('170','LI','SURCO')
insert into city (CITYID,STATEID,DESCR) values ('171','LI','SURQUILLO')
insert into city (CITYID,STATEID,DESCR) values ('172','TA','TACNA')
insert into city (CITYID,STATEID,DESCR) values ('173','PI','TALARA')
insert into city (CITYID,STATEID,DESCR) values ('174','CU','TAMBOPATA')
insert into city (CITYID,STATEID,DESCR) values ('175','JU','TARMA')
insert into city (CITYID,STATEID,DESCR) values ('176','HC','TAYACAJA')
insert into city (CITYID,STATEID,DESCR) values ('177','SM','TOCACHE')
insert into city (CITYID,STATEID,DESCR) values ('178','LL','TRUJILLO')
insert into city (CITYID,STATEID,DESCR) values ('179','TU','TUMBES')
insert into city (CITYID,STATEID,DESCR) values ('180','UC','UCAYALI')
insert into city (CITYID,STATEID,DESCR) values ('182','CU','URUBAMBA')
insert into city (CITYID,STATEID,DESCR) values ('183','AM','UTCUBAMBA')
insert into city (CITYID,STATEID,DESCR) values ('184','LI','V. EL SALVADOR')
insert into city (CITYID,STATEID,DESCR) values ('185','LI','V. MARIA DEL TRIUNFO')
insert into city (CITYID,STATEID,DESCR) values ('187','JU','YAULI')
insert into city (CITYID,STATEID,DESCR) values ('188','AN','YUNGAY')
insert into city (CITYID,STATEID,DESCR) values ('189','PU','YUNGUYO')


INSERT TAXS (TAXID,DESCR,VALUE) VALUES ('IV','IGV',18) /*AGREGAR IGV*/
INSERT TAXS (TAXID,DESCR,VALUE) VALUES ('SC','ISC',18) /*AGREGAR ISC*/
INSERT TAXS (TAXID,DESCR,VALUE) VALUES ('00','ISC',0) /*ningn impuesto*/

--siteS
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('50','01','PER','E/S ARICA (TAU OMEGA)','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('51','01','PER','E/S RICARDO PALMA (TEX CAR)','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('52','01','PER','E/S  NAVAL (CENTRO NAVAL)','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('53','01','PER','E/S OVALO GRAU','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('54','01','PER','E/S  JESUS (UNION)','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('55','01','PER','E/S  MARISCAL CASTILLA (SINDICATO)','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('56','01','PER','E/S SANTA AMALIA','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('57','01','PER','E/S PRINCIPAL','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('58','01','PER','E/S PASEO DE LA REPUBLICA','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('59','01','PER','E/S COLONIAL I (El Cano)','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('61','01','PER','E/S COLONIAL II','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('62','01','PER','E/S TOMAS MARSANO','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('63','01','PER','E/S PISCO','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('64','01','PER','E/S  CASTILLA (VIRGEN DEL CARMEN)','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('65','01','PER','E/S ESCARDO','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('66','01','PER','E/S CUARTO CENTENARIO','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('67','01','PER','E/S MIRAFLORES (STAKE)','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('68','01','PER','E/S PERSHING (PRO DESARROLLO)','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('69','01','PER','E/S RIVERFRONT(Cuarto Puente)','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('70','01','PER','E/S JOSE GALVEZ (SAN JUDAS)','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('71','01','PER','E/S ANGAMOS','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('72','01','PER','E/S GOYENECHE','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('73','01','PER','E/S ARENALES','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('74','01','PER','E/S CAÑETE','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('75','01','PER','E/S SALAVERRY','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('01','01','PER','PLANTA CALLAO','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('02','01','PER','TERMINAL PAMPILLA','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('03','01','PER','ALMACEN AREQUIPA','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('06','01','PER','TERMINAL MOLLENDO','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('07','01','PER','TERMINAL PISCO','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('10','01','PER','TERMINAL PIURA','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('11','01','PER','OFICINA CENTRAL','??',0,0,'??','SYSADMIN','19000101','19000101')
INSERT site (siteid,CITYID,countryid,name,addr1,status,ADJUST,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) values ('19','01','PER','ALMACEN SALAVERRY','??',0,0,'??','SYSADMIN','19000101','19000101')

--NECESARIO PARA TRANSFERENCIA DE DATOS DE ZIGMA A SQL
INSERT SITE (SITEID,CITYID,COUNTRYID,NAME,ADDR1,STATUS,ATTN,userid,STARTDATEINVEN,ENDDATEINVEN) VALUES   ('00057','01','PER','TEMPORAL','??',0,'??','SYSADMIN','19000101','19000101')

--monedas
INSERT currency (CURYID,DESCR,DESCRMONEY) VALUES ('USD','DOLARES','$')
INSERT currency (CURYID,DESCR,DESCRMONEY) VALUES ('PEN','SOLES','S/.')

--TENER CUIDADO DE LOS PRODUCTOS EN LOS QUE LAS SUBCATEGORIAS SON INCORRECTAS 
--TENER CUIDADO CON LOS PRODUCTOS CUYA UNIDAD DE MEDIDA NO EXISTE     U
---terms

INSERT terms (TERMID,DESCR,DUEINTRV) values ('00','pago contraentrega',0)
DECLARE @DIAS INTEGER
DECLARE @CADE VARCHAR(100)
DECLARE @CDIAS AS CHAR(2)
SET @DIAS=1
WHILE ( @DIAS<99)
	BEGIN
		SET @CDIAS=LTRIM(CAST(@DIAS AS CHAR(2)))
		SET @CDIAS=REPLICATE('0',2-LEN(@CDIAS))+@CDIAS

		SET @CADE="INSERT terms (TERMID,DESCR,DUEINTRV) values ('"+ @CDIAS +"','" +CAST(@DIAS AS CHAR(2) )+" DIAS DE CREDITO',"+CAST(@DIAS AS CHAR(2) )+")"
		exec (@CADE)
		SET @DIAS=@DIAS+1
	END

INSERT DOCTYPE(DOCTYPEID,DESCR,MINDES,STKSCREEN) VALUES ('01','FACTURA','FAC',1) --ventas
INSERT DOCTYPE(DOCTYPEID,DESCR,MINDES,STKSCREEN) VALUES ('03','BOLETA','BOL',1) --ventas
INSERT DOCTYPE(DOCTYPEID,DESCR,MINDES,STKSCREEN) VALUES ('07','NOTA CREDITO','NC',2) --notas de credito/debito
INSERT DOCTYPE(DOCTYPEID,DESCR,MINDES,STKSCREEN) VALUES ('08','NOTA DEBITO ','NC',2)--notas de credito/debito
INSERT DOCTYPE(DOCTYPEID,DESCR,MINDES,STKSCREEN) VALUES ('09','GUIA DE REMISION','GR',1) --ventas
INSERT DOCTYPE(DOCTYPEID,DESCR,MINDES,STKSCREEN) VALUES ('12','TICKET','TIC',1) --ventas
INSERT DOCTYPE(DOCTYPEID,DESCR,MINDES,STKSCREEN) VALUES ('15','ORDEN DE COMPRA','PED',3) --compras
INSERT DOCTYPE(DOCTYPEID,DESCR,MINDES,STKSCREEN) VALUES ('19','DOC.INTERNO INVENTARIO','DII',4) --nadie sabe
INSERT DOCTYPE(DOCTYPEID,DESCR,MINDES,STKSCREEN) VALUES ('91','AJUSTE NOTA CREDITO','ANC',4) --nadie sabe
INSERT DOCTYPE(DOCTYPEID,DESCR,MINDES,STKSCREEN) VALUES ('92','AJUSTE NOTA DEBITO','AND',4)--nadie sabe

INSERT curyratetype (curytypeid,descr) values ('DIAVT','TIPO CAMBIO CONTABLE')
INSERT curyratetype (curytypeid,descr) values ('TCONV','TIPO CAMBIO CONVERSION')

INSERT TYPEPAYMENT (TYPEPAYMENTID, DESCR,SHOW) VALUES ('00','OTROS',0)
INSERT TYPEPAYMENT (TYPEPAYMENTID, DESCR,SHOW) VALUES ('01','EFECTIVO',1)
INSERT TYPEPAYMENT (TYPEPAYMENTID, DESCR,SHOW) VALUES ('02','TARJETA DE CREDITO',0)
INSERT TYPEPAYMENT (TYPEPAYMENTID, DESCR,SHOW) VALUES ('03','CHEQUE GERENCIA',1)
INSERT TYPEPAYMENT (TYPEPAYMENTID, DESCR,SHOW) VALUES ('04','CHEQUE COMERCIAL',1 )
INSERT TYPEPAYMENT (TYPEPAYMENTID, DESCR,SHOW) VALUES ('05','CHEQUE DIFERIDO (CREDITO)',1)
INSERT TYPEPAYMENT (TYPEPAYMENTID, DESCR,SHOW) VALUES ('06','VALES (CREDITO)',0 )
INSERT TYPEPAYMENT (TYPEPAYMENTID, DESCR,SHOW) VALUES ('10','FACTURA GENERADA',0 )
INSERT TYPEPAYMENT (TYPEPAYMENTID, DESCR,SHOW) VALUES ('11','NTA CREDITO GENERADA',0 )
INSERT TYPEPAYMENT (TYPEPAYMENTID, DESCR,SHOW) VALUES ('12','FACTURA FICTICIA',0 )
INSERT TYPEPAYMENT (TYPEPAYMENTID, DESCR,SHOW) VALUES ('13','N.CREDITO FICTICIA',0 )
INSERT TYPEPAYMENT (TYPEPAYMENTID, DESCR,SHOW) VALUES ('14','CONTADO ADELANTO',0 )

-- La FACTURA DE ADELANTO (INICIAL) ES TIPO 01 Y ADEMAS SE GRABA EN OP_DOCANTI

--TIPO DE NEGOCIO

INSERT BANK (BANKID, DESCR) VALUES('02','Bco.de Crédito')
INSERT BANK (BANKID, DESCR) VALUES('07','CitiBank')
INSERT BANK (BANKID, DESCR) VALUES('09','Bco.Wiese Ltdo')
INSERT BANK (BANKID, DESCR) VALUES('29','BancoSur')
INSERT BANK (BANKID, DESCR) VALUES('99','Otros')

INSERT in_classvendor (classvendorid,descr) values ('01','COMBUSTIBLES Y LUBRICANTES')
INSERT in_classvendor (classvendorid,descr) values ('02','FILTROS')
INSERT in_classvendor (classvendorid,descr) values ('03','TIENDAS')

INSERT IN_DOCSTATUS (DOCSTATUSID,DESCR)VALUES ('CA','CANCELADO')
INSERT IN_DOCSTATUS (DOCSTATUSID,DESCR)VALUES ('PE','PENDIENTE')
INSERT IN_DOCSTATUS (DOCSTATUSID,DESCR)VALUES ('AN','ANULADO')
INSERT IN_DOCSTATUS (DOCSTATUSID,DESCR)VALUES ('OK','EMITIDO')
INSERT IN_DOCSTATUS (DOCSTATUSID,DESCR)VALUES ('NA','NINGUNA ACCION')

--IN_INVENTOTY ALTER

--INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('307','NOTA CREDITO VENTA               ',0,0,0,0,0,0,0,'N.C.VENTA   ',1,'000','0','0','0')
--INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('308','NOTA DEBITO  VENTA               ',0,0,0,0,0,0,0,'N.D.VENTA   ',1)

INSERT IN_INVENTORYTYPE (INVTYPEID,DESCR) VALUES ('01','REGIONAL')
INSERT IN_INVENTORYTYPE (INVTYPEID,DESCR) VALUES ('02','LOCAL')

INSERT IN_PRICELEVELTYPE (PRECLVID,DESCR,CURYID,CURYTYPEID) VALUES('001','PRECIO VENTA AL PUBLICO SOLES','PEN','DIAVT')
INSERT IN_PRICELEVELTYPE (PRECLVID,DESCR,CURYID,CURYTYPEID) VALUES('002','PRECIO VENTA AL PUBLICO DOLARES','USD','DIAVT')
INSERT IN_PRICELEVELTYPE (PRECLVID,DESCR,CURYID,CURYTYPEID) VALUES('003','PRECIOS ACTUALIZABLES SOLES','PEN','DIAVT')
INSERT IN_PRICELEVELTYPE (PRECLVID,DESCR,CURYID,CURYTYPEID) VALUES('004','PRECIOS ACTUALIZABLES DOLARES','USD','DIAVT')
INSERT IN_PRICELEVELTYPE (PRECLVID,DESCR,CURYID,CURYTYPEID) VALUES('005','OFERTAS SOLES','PEN','DIAVT')


INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('101','COMPRA PLAYA                     ',1,1,1,0,1,0,1,'COMP.COMBST.',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('102','COMPRA C-STORE                   ',1,1,1,0,1,0,1,'COMP.C-STORE',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('103','CONSIGNACION                     ',1,0,1,0,0,1,0,'CONSIGNACION',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('104','INVENTARIO INICIAL               ',1,1,1,0,0,1,1,'INVENT.INIC.',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('105','ING.TRANSFERENCIA                ',1,1,1,0,0,1,1,'I.TRANSFER. ',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('106','ING.BONIFICACION                 ',1,0,1,0,0,1,1,'BONIFICACION',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('107','ING.RECLASIFICACION HOMOGENEA    ',1,0,0,0,0,1,0,'RECLAS.HOMOG',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('108','ING.RECLASIFICACION DESENSAMBLE  ',1,1,1,0,0,1,0,'RECLAS.DESEM',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP,PRECLVLID) VALUES ('109','ING.GANANCIA DE OPERACION        ',1,1,0,0,0,1,0,'GANANCIA OP.',1,'000','0','0','0','001')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('110','INGRESO DE INVENTARIO FISICO     ',1,1,1,1,0,1,0,'INVT.FISICO ',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('111','ING.EVAPORACION COMBUSTIBLE      ',1,1,1,0,0,1,0,'EVAPORACION ',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('112','ING.CONSUMO PROPIO               ',1,1,1,1,0,0,0,'CONSUMO PR. ',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('114','INGRESO AJUSTE INVENTARIO FISICO ',1,1,1,1,0,1,1,'ING.AJ.IN.F.',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('201','SAL.CORRECCION COMPRA PLAYA      ',0,1,1,0,1,0,1,'CORR.COM.COM',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('202','SAL.CORRECCION COMPRA C-STORE    ',0,1,1,0,1,0,1,'CORR.COM.STO',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('203','SAL.CONSIGNACION                 ',0,0,1,0,0,1,0,'CONSIGNACION',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('205','SAL.TRANSFERENCIA                ',0,1,1,0,0,1,0,'TRANSFERENC.',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('206','NOTA DE CREDITO INVENTARIO       ',0,1,1,0,1,1,1,'N.C.INVENTR.',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('207','SAL.RECLASIFICACION HOMOGENEA    ',0,0,0,0,0,1,0,'COMP.COMBST.',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('208','SAL.RECLASIFICACION DESENSAMBLE  ',0,1,1,0,0,1,0,'REC.DESEMSA.',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP,PRECLVLID) VALUES ('209','SAL.PERDIDA EN OPERACION         ',0,1,0,0,0,1,0,'PERDIDA OPR.',1,'000','0','0','0','001')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('211','SAL.EVAPORACION COMBUSTIBLE      ',0,1,1,0,0,1,0,'EVAP.COMBUST',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('212','SAL.CONSUMO PROPIO               ',0,1,1,1,0,0,0,'CONSUMO PROP',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('213','MERMAS                           ',0,0,0,0,0,0,0,'MERMAS      ',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('214','SALIDA AJUSTE INVENTARIO FISICO  ',0,0,0,0,0,1,1,'SAL.A.INV.F.',1,'000','0','0','0')
INSERT IN_TYPEDOC (TYPEDOCID,DESCR,INOUT,STKVALUE,STKCOSPRICE,STKAVGCOST,STKBUY,STKVENDOR,STKAVERAGE,DESCR_ABR,STKDISPLAY,TYPEINV,MODINV,MODBUY,MODCXP) VALUES ('301','SALIDAS VENTA                    ',0,0,0,0,0,0,0,'SALIDA VENTA',1,'000','0','0','0')

INSERT IN_INVENTORYUNITMED (stkunitid,descr,STKDIVIDE) values ('UND','UNIDAD',0)
INSERT IN_INVENTORYUNITMED (stkunitid,descr,STKDIVIDE) values ('GLN','GALON',0)
INSERT IN_INVENTORYUNITMED (stkunitid,descr,STKDIVIDE) values ('CAJ','CAJAS',1)
INSERT IN_INVENTORYUNITMED (stkunitid,descr,STKDIVIDE) values ('FRS','FRASCOS',0)
INSERT IN_INVENTORYUNITMED (stkunitid,descr,STKDIVIDE) values ('BAL','BALDES',0)
INSERT IN_INVENTORYUNITMED (stkunitid,descr,STKDIVIDE) values ('CIL','CILINDROS',0)
INSERT IN_INVENTORYUNITMED (stkunitid,descr,STKDIVIDE) values ('BOL','BOLSAS',0)
INSERT IN_INVENTORYUNITMED (stkunitid,descr,STKDIVIDE) values ('CM3','CENTIMETROS CUBICOS',0)

INSERT SE_MODULE (MODULEID,MODULENAME) VALUES ('OP','VENTAS')
INSERT SE_MODULE (MODULEID,MODULENAME) VALUES ('CF','CONFIGURACION')
INSERT SE_MODULE (MODULEID,MODULENAME) VALUES ('MA','MAESTRAS')
INSERT SE_MODULE (MODULEID,MODULENAME) VALUES ('IN','INVENTARIO')
INSERT SE_MODULE (MODULEID,MODULENAME) VALUES ('UT','UTILITARIOS')
INSERT SE_MODULE (MODULEID,MODULENAME) VALUES ('AR','CUENTAS POR COBRAR')

INSERT SE_MODULE (MODULEID,MODULENAME) VALUES ('SE','SEGURIDAD')
INSERT SE_MODULE (MODULEID,MODULENAME) VALUES ('SH','ENVIO/RECEPCION')

INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','ARTICULOS','M','0101000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','CATEGORIAS','M','0103000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','SUBCATEGORIAS','M','0104000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','TIPOS','M','0105000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','UNIDAD DE MEDIDA','M','0106000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','TIPOS DE MOVIMIENTOS ','M','0107000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','ALMACENES','M','0108000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','PROVEEDORES','M','0109000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','FORMULAS ','M','0110000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','CLIENTES ','M','0111000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','ESTADOS DE CLIENTES','M','0111500')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','TIPOS DE CLIENTES','M','0112000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','TIPOS DE FACTURA ','M','0113000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','VENDEDOR','M','0114000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','ESTADO DE VENDEDOR','M','0114500')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','DOCUMENTOS','M','0116000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','BANCOS','M','0117000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','TARJETAS DE CREDITO','M','0118000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','MONEDA','M','0119000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','ZONAS','M','0120000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','MODALIDAD DE VENTAS','M','0120500')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','TIPO DE PROVEEDOR','M','0121000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','TIPO DE DEPOSITO','M','0121500')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','TIPO DE IMPUESTO','M','0122000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','MANTENIMIENTO ESTADOS','M','0123000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','PAIS','M','0124000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','DEPARTAMENTOS','M','0125000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','PROVINCIAS','M','0126000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','TIPO DE PRECIOS DE INVENTARIO','M','0127000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','PRECIOS DE INVENTARIO','M','0127300')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','HISTORIAL DE PRECIOS DE INVENTARIO','T','0127500')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','CLASES DE TIPOS DE CAMBIO','M','0128000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','LISTA DE PRECIOS PARA CLIENTE','M','0129000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','HISTORIAL DE PRECIOS PARA CLIENTE','M','0129500')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','RELACION PROVEEDOR ARTICULO','M','0130000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('MA ','RELACION CLIENTE/ESTACION/TPC','T','0131000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','INGRESOS DE PRODUCTOS A INVENTARIO','T','1001000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','SALIDAS DE PRODUCTOS A INVENTARIO','T','1002000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','PRODUCTOS DEBAJO DEL STOCK MINIMO','R','1004000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','PRODUCTOS CON STOCK MAXIMO','R','1005000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','PRODUCTOS POR PROVEEDOR','R','1006000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','ANALISIS DE COSTOS POR ARTICULO','R','1007000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','PRECIOS POR ARTICULO','R','1008000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','STOCK ACTUAL','R','1009000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','KARDEX GENERAL','R','1010000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','KARDEX POR ARTICULO','R','1011000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','COMPRAS X PROVEEDOR BIMONETARIO','R','1012000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','RESUMEN DE INGRESOS Y SALIDAS','R','1013000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','INICIO DE TOMA DE INVENTARIO','P','1015000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','INGRESO DE STOCK FISICO MANUAL','P','1016000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','INGRESO AUTOMATICO ','P','1017000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','INGRESO DE STOCK FISICO POR BLOQUE','P','1018000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','REPORTE DE DIFERENCIAS','R','1019000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','CIERRE TOMA DE INVENTARIO','P','1020000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','INVENTARIO VALORIZADO DE STOCK FISICO','R','1021000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('IN ','LISTA DE PRECIOS POR ARTICULO','R','1023000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','FACTURACION PLAYA','T','0501000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','FACTURACION TIENDA','T','0502000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','FACTURACION MANUAL ','T','0502500')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','NOTAS DE CREDITO/DEBITO','T','0503000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','CONSULTA/ANULACION DOCUMENTOS','T','0503500')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','MANTENIMIENTO CASH DROP','P','0504000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','CIERRE DE VENTAS DIARIA','P','0505000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','CONFIGURACION CARA /VENDEDOR','T','0505500')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','CONTROL PRECIOS COMPETENCIA','T','0505800')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','REGISTRO CONTOMETROS MANUALES','P','0506000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','CONTROL DE COMBUSTIBLES (VARILLAJE)','T','0508000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','REGISTRO TARJETAS DE CREDITO','T','0509000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','FALTANTES SOBRANTES ','P','0510000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','RESUMEN DE VENTAS/VALES DEL DIA','P','0511000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','DEPOSITOS ','P','0512000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','EMISION DE PARTE DIARIO ','R','0513000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','APROBACION DE PARTE DIARIO ','P','0514000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','REGISTRO DE VENTAS','R','0515000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','VENTAS ','R','0516000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','VENTAS X ARTICULO','R','0517000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','VENTAS TARJETA CREDITO','R','0518000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','VENTAS VALES CREDITO','R','0519000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','VENTAS X FORMA PAGO','R','0520000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','VENTAS CASH DROP','R','0521000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','FALTANTES/SOBRANTES','R','0522000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','REGISTROS TARJETAS CREDITO','R','0523000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','DEPOSITOS X DIA ','R','0524000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('OP','REPORTE DE ANULACIONES','R','0525000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('AR','INGRESO/EMISION DOCUMENTOS POR COBRAR','T','0801000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('AR','ESTADO DE CUENTA POR CLIENTES','R','0802000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('AR','COBRANZA DE DOCUMENTOS','T','0803000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('AR','RESUMEN PENDIENTES DE COBRANZA','R','0804000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('AR','INFORME DE COBRANZA','R','0805000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','REINDEXADO','P','9501000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','BACKUP','P','9502000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','CONFIGURACION DE PUNTO DE VENTA','P','9503000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','CONFIGURACION DE MODULO DE VENTAS','P','9504000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','CONFIGURACION DE MODULO DE INVENTARIOS','P','9505000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','INGRESO DE TIPO DE CAMBIO','M','9506000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','FORMATO DE TICKET','P','9508000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','FORMATO DE DOCUMENTOS PRE-IMPRESOS','P','9509000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','CONFIGURAR FECHA DE PROCESO','P','9510000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','RECALCULO DE STOCK ','P','9511000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','CALCULO COSTO PROMEDIO ','P','9511500')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','CIERRE DE MES','P','9512000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','ENVIO DE INFORMACION HACIA E/S','P','9514000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','RECEPCION DE INFORMACION EN E/S','P','9516000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','ACTIVAR VENTA DE COMBUSTIBLE MANUAL','P','9517000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','ACTIVAR DISPENSADORES ','P','9518000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('UT','CONFIGURACION DE CARAS DE DISPENSADORES','P','9519000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('CF','CREACION DE USUARIOS','M','9601000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('CF','DATOS DE LAS ESTACION','S','9603000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('CF','CANTIDAD DE CARAS','P','9604000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('CF','RELACION DE COMBUSTIBLES CON CARAS ','P','9605000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('CF','CANTIDAD DE TURNOS','P','9606000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('CF','ENLACE CON SISTEMAS DE DISPENSADORES ','P','9607000')
INSERT se_screen (moduleid,screenname,screentype,screenid) values('CF','CREACION DE GRUPOS DE USUARIOS ','M','9608000')

INSERT SE_USERREC (USERID,USERNAME,location,password,status,expired) values ('SYSADMIN','SYSADMIN','SYSTEM','SYSADMIN',1,'01/01/05') /*usuario de sistema*/
INSERT SE_GROUPREC (GROUPID,GROUPNAME) VALUES('DATAMAN','DATAMAN')

INSERT se_accessdetrights (USERID,SCREENID,VIEWRIGHTS,INSERTRIGHTS,UPDATERIGHTS,DELETERIGHTS,PRINTRIGHTS,closerights,nullrights )
SELECT DISTINCT 'SYSADMIN',SCREENID,1,1,1,1,1,1,1 FROM SE_USERREC CROSS JOIN SE_SCREEN ORDER BY SCREENID

INSERT se_accessdetrights (USERID,SCREENID,VIEWRIGHTS,INSERTRIGHTS,UPDATERIGHTS,DELETERIGHTS,PRINTRIGHTS,closerights,nullrights )
SELECT DISTINCT 'DATAMAN',SCREENID,1,1,1,1,1,1,1 FROM SE_USERREC CROSS JOIN SE_SCREEN ORDER BY SCREENID

INSERT  OP_CARD (CARDID,ACCOUNT ,DESCR,NUMBERORDER) values ('01','000-0257818','VISA',1)
INSERT  OP_CARD (CARDID,ACCOUNT ,DESCR,NUMBERORDER)  values ('03','000-0257885','MASTERCARD',3)
INSERT  OP_CARD (CARDID,ACCOUNT ,DESCR,NUMBERORDER)  values ('02','000-0257907','DINERS',2)
INSERT  OP_CARD (CARDID,ACCOUNT ,DESCR,NUMBERORDER) values ('07','000-0000000','VISA ELECTRON',7)
INSERT  OP_CARD (CARDID,ACCOUNT ,DESCR,NUMBERORDER) values ('06','000-0000000','NET CARS',6)
INSERT  OP_CARD (CARDID,ACCOUNT ,DESCR,NUMBERORDER)  values ('05','000-0000000','RIPLEY',5)
INSERT  OP_CARD (CARDID,ACCOUNT ,DESCR,NUMBERORDER)  values ('04','000-0000000','MAESTRO',4)

INSERT OP_CUSTZONE (CUSTZONEID, DESCR ) VALUES('01','ZONA CENTRO')
INSERT OP_CUSTZONE (CUSTZONEID, DESCR ) VALUES('02','ZONA NORTE')
INSERT OP_CUSTZONE (CUSTZONEID, DESCR ) VALUES('03','ZONA SUR')

INSERT OP_CUSTCLASS (CUSTCLASSID,DESCR) VALUES('00','CONTADO')
INSERT OP_CUSTCLASS (CUSTCLASSID,DESCR) VALUES('01','PAGO ADELANTADO')
INSERT OP_CUSTCLASS (CUSTCLASSID,DESCR) VALUES('02','CREDITO CORPORATIVO')
INSERT OP_CUSTCLASS (CUSTCLASSID,DESCR) VALUES('03','CREDITO LOCALES')
INSERT OP_CUSTCLASS (CUSTCLASSID,DESCR) VALUES('04','OTROS')

INSERT CUSTSTATUS (CUSTSTATUSID,DESCRCUST) VALUES('R','RETENCION CREDITICIA')
INSERT CUSTSTATUS (CUSTSTATUSID,DESCRCUST) VALUES('H','RETENCION ADMINISTRATIVA')
INSERT CUSTSTATUS (CUSTSTATUSID,DESCRCUST) VALUES('A','ACTIVO')
INSERT CUSTSTATUS (CUSTSTATUSID,DESCRCUST) VALUES('I','INACTIVO')

INSERT OP_DOCSUMMARYTYPE (DOCSUMMARYTYPEID, DESCRDOCSUMMARYTYPE,userid,DOCTYPEID,SITEID) VALUES('01','FACTURA PHANTOM','SYSADMIN','101','57')
INSERT OP_DOCSUMMARYTYPE (DOCSUMMARYTYPEID, DESCRDOCSUMMARYTYPE,userid,DOCTYPEID,SITEID) VALUES('05','NOTA CREDITO PHANTOM','SYSADMIN','101','57')
INSERT OP_DOCSUMMARYTYPE (DOCSUMMARYTYPEID, DESCRDOCSUMMARYTYPE,userid,DOCTYPEID,SITEID) VALUES('06','NOTA DEBITO PHANTOM','SYSADMIN','101','57')

INSERT OP_STATUSPERSON(STATUSPERSONID, DESCRSTATUSPERSON,userid) VALUES('01','ACTIVO','SYSADMIN')
INSERT OP_STATUSPERSON(STATUSPERSONID, DESCRSTATUSPERSON,userid) VALUES('02','INACTIVO','SYSADMIN')
INSERT OP_STATUSPERSON(STATUSPERSONID, DESCRSTATUSPERSON,userid) VALUES('03','SUSPENCION ADMINISTRATIVA','SYSADMIN')

--- OP_CCSALESPERSONTYPE --------
---------------------------------

INSERT op_deposittype (DEPOSITTYPEID, DESCRDEPOSTITYPE ) values ('E','Efectivo')
INSERT op_deposittype (DEPOSITTYPEID, DESCRDEPOSTITYPE ) values ('T','Tarjeta Credito')
INSERT op_deposittype (DEPOSITTYPEID, DESCRDEPOSTITYPE ) values ('V','Vales')


INSERT CUSTWARRANTYTYPE (CUSTWARRANTYTYPEID,DECRCUSTWARRANTY,userid) VALUES('01','LETRAS','SYSADMIN')
INSERT CUSTWARRANTYTYPE (CUSTWARRANTYTYPEID,DECRCUSTWARRANTY,userid) VALUES('02','HIPOTECAS','SYSADMIN')

insert Xdias_pago (DIAPAGID,COMBDIA1,COMBDIA2,COMBDIA3,COMBDIA4,DESCR,D1LUNES,D2MARTES,D3MIERCOLES,D4JUEVES,D5VIERNES,D6SABADO,D7DOMINGO,FECCREACION,FECULTACT,STATUSSEM,userid) values('DEFAULT0',0,0,0,0,'NO TIENE UN DIA DE PAGO ESPECIFICO',0,0,0,0,0,0,0,'22:49.4','22:49.4',-1,'SYSADMIN')
insert Xdias_pago (DIAPAGID,COMBDIA1,COMBDIA2,COMBDIA3,COMBDIA4,DESCR,D1LUNES,D2MARTES,D3MIERCOLES,D4JUEVES,D5VIERNES,D6SABADO,D7DOMINGO,FECCREACION,FECULTACT,STATUSSEM,userid) values('DP05152500',5,15,25,0,'Días de Pago 05-15-25',0,0,0,0,0,0,0,'22:49.4','22:49.4',-1,'SYSADMIN')
insert Xdias_pago (DIAPAGID,COMBDIA1,COMBDIA2,COMBDIA3,COMBDIA4,DESCR,D1LUNES,D2MARTES,D3MIERCOLES,D4JUEVES,D5VIERNES,D6SABADO,D7DOMINGO,FECCREACION,FECULTACT,STATUSSEM,userid) values('SEMJUE',0,0,0,0,'Semana Pesquera paga Jueves   ',0,0,0,0,0,0,0,'22:49.4','22:49.4',-1,'SYSADMIN')
Insert Xdias_pago (DIAPAGID,COMBDIA1,COMBDIA2,COMBDIA3,COMBDIA4,DESCR,D1LUNES,D2MARTES,D3MIERCOLES,D4JUEVES,D5VIERNES,D6SABADO,D7DOMINGO,FECCREACION,FECULTACT,STATUSSEM,userid) values('SEMLUN',0,0,0,0,'Semana Pesquera paga Lunes    ',0,0,0,0,0,0,0,'22:49.4','22:49.4',-1,'SYSADMIN')
insert Xdias_pago (DIAPAGID,COMBDIA1,COMBDIA2,COMBDIA3,COMBDIA4,DESCR,D1LUNES,D2MARTES,D3MIERCOLES,D4JUEVES,D5VIERNES,D6SABADO,D7DOMINGO,FECCREACION,FECULTACT,STATUSSEM,userid) values('SEMMAR',0,0,0,0,'Semana Pesquera paga Martes   ',0,0,0,0,0,0,0,'22:49.4','22:49.4',-1,'SYSADMIN')
insert Xdias_pago (DIAPAGID,COMBDIA1,COMBDIA2,COMBDIA3,COMBDIA4,DESCR,D1LUNES,D2MARTES,D3MIERCOLES,D4JUEVES,D5VIERNES,D6SABADO,D7DOMINGO,FECCREACION,FECULTACT,STATUSSEM,userid) values('SEMMIE',0,0,0,0,'Semana Pesquera paga Miercoles',0,0,0,0,0,0,0,'22:49.4','22:49.4',-1,'SYSADMIN')
insert Xdias_pago (DIAPAGID,COMBDIA1,COMBDIA2,COMBDIA3,COMBDIA4,DESCR,D1LUNES,D2MARTES,D3MIERCOLES,D4JUEVES,D5VIERNES,D6SABADO,D7DOMINGO,FECCREACION,FECULTACT,STATUSSEM,userid) values('SEMVIE',0,0,0,0,'Semana Pesquera paga Viernes  ',0,0,0,0,0,0,0,'22:49.4','22:49.4',-1,'SYSADMIN')


-- OP_BUSINESSTYPE
----------------------------------------------------------------------
-- debe configurarse en el instalador por cada estacion
INSERT OP_BUSINESSTYPE (BUSINESSTYPE,DESCRBUSINESS ) VALUES('1','PLAYA')
INSERT OP_BUSINESSTYPE (BUSINESSTYPE,DESCRBUSINESS ) VALUES('0','DESACTIVADO')
INSERT OP_BUSINESSTYPE (BUSINESSTYPE,DESCRBUSINESS ) VALUES('2','CSTORE')
INSERT OP_BUSINESSTYPE (BUSINESSTYPE,DESCRBUSINESS ) VALUES('3','OFICINA')

-- OP_DOCSERIES
----------------------------------------------------------------------
-- debe configurarse en el instalador por cada estacion
INSERT OP_DOCSERIES(DOCTYPEID,NBRSERIES,SITEID, NBRDOC) VALUES('01',571,'57',1)
INSERT OP_DOCSERIES(DOCTYPEID,NBRSERIES,SITEID, NBRDOC) VALUES('01',572,'57',1)
INSERT OP_DOCSERIES(DOCTYPEID,NBRSERIES,SITEID, NBRDOC) VALUES('03',571,'57',1)
INSERT OP_DOCSERIES(DOCTYPEID,NBRSERIES,SITEID, NBRDOC) VALUES('03',572,'57',1)
INSERT OP_DOCSERIES(DOCTYPEID,NBRSERIES,SITEID, NBRDOC) VALUES('07',571,'57',1)
INSERT OP_DOCSERIES(DOCTYPEID,NBRSERIES,SITEID, NBRDOC) VALUES('07',572,'57',1)
INSERT OP_DOCSERIES(DOCTYPEID,NBRSERIES,SITEID, NBRDOC) VALUES('08',573,'57',1)
INSERT OP_DOCSERIES(DOCTYPEID,NBRSERIES,SITEID, NBRDOC) VALUES('15',574,'57',1)

INSERT OP_CORELATIVE(TYPECORELATIVE, NBRCORELATIVE,userid) VALUES('BATNBRTURN',1,'SYSADMIN')
INSERT OP_CORELATIVE(TYPECORELATIVE, NBRCORELATIVE,userid) VALUES('BATNBRDEPOSIT',1,'SYSADMIN')
INSERT OP_CORELATIVE(TYPECORELATIVE, NBRCORELATIVE,userid) VALUES('BATNBRTURNPERSON',1,'SYSADMIN')
INSERT OP_CORELATIVE(TYPECORELATIVE, NBRCORELATIVE,userid) VALUES('BATNBRPRCLVLCUST',1,'SYSADMIN')
INSERT OP_CORELATIVE(TYPECORELATIVE, NBRCORELATIVE,userid) VALUES('BATNBRDIARYSUMMARY',1,'SYSADMIN')
INSERT OP_CORELATIVE(TYPECORELATIVE, NBRCORELATIVE,userid) VALUES('BATNBRCTRLFUEL',1,'SYSADMIN')
INSERT OP_CORELATIVE(TYPECORELATIVE, NBRCORELATIVE,userid) VALUES('BATNBRDEPOSITSITE',1,'SYSADMIN')
INSERT OP_CORELATIVE(TYPECORELATIVE, NBRCORELATIVE,userid) VALUES('BATNBRPRICELEVELTEM',1,'SYSADMIN')
INSERT OP_CORELATIVE(TYPECORELATIVE, NBRCORELATIVE,userid) VALUES('BATNBRCOMPETITIONPR',1,'SYSADMIN')
INSERT OP_CORELATIVE(TYPECORELATIVE, NBRCORELATIVE,userid) VALUES('BATNBRCCSALESP',1,'SYSADMIN')
INSERT OP_CORELATIVE(TYPECORELATIVE, NBRCORELATIVE,userid) VALUES('BATNBRAR_CCDOCDET',1,'SYSADMIN')


-------------------------------------------------------------------------
-- debe configurarse en el instalador por cada estacion
INSERT IN_SETUP (PERPOST,INTYPETRANSFERIN,INTYPETRANSFEROUT,REPORTPATH,INTYPESALES,INTYPEDESIN,INTYPEDESOUT,
		INTYPECREDMEM,INTYPEBONUS,INTYPEFISIN,INTYPEFISOUT,INTYPETRBUYSTORE,INTYPETRBUYFUELS,BATNBRTYPEDOC,
		BATNBRTYPEPRICE,STKFISI,INTYPEQTYINI,STKSTOCK,DOCTYPEIDFIS,IDVENDORSS,CLOSEDMONTH) 
		VALUES ('200210','105','205','C:\sies\Inventarios\Reportes\','301','108','208','206','106','114','214',
			'102','101','5700000001','5700000001',0,'104',0,'05','00000000000','200301')
--------------------------------------------------------------------------------------------------------------------
insert setup (TYPEPRICEUPDATE,CUSTID,QTYSALESPERSONTURN,SALESPERSONTURN,QTYSIDE,sourceSITE,CURYORIG,FLOATPRICE,FLOATCOST
		,FLOATQTY,FLOATOUTPUT,TAXVALUEigv,DATEPROCE,TAXID,SOURCECURYTYPEID,TYPECONTROLLERFUEL,CURYTYPEIDSALES,
		SENDPATH,RECEPPATH)
		values ('003','SS00000057',3,1,6,'57','PEN',2,3,3,2,18,'10/10/02','IV','DIAVT',1,'TCONV',
		'd:\tranferencia\envios','d:\tranferencia\envios')
--------------------------------------------------------------------------------------------------------------------
INSERT OP_SETUP (AUTOMATICSALES,CATEGORYFUEL,BADGE,MTOMAXSALES,ACCOUNTCARD,DATEPROCESALES,
	CCLASSIDCASH,CCLASSIDANTICIPATE,CCLASSIDCREDLOCAL,CCLASSIDCREDCORPORATE,
	CCLASSIDOTHER, DOCTYPEIDTICKET,DOCTYPEIDFAC,DOCTYPEIDBOL,DOCTYPEIDNC,DOCTYPEIDND,
	STKCORRELATIVE,STKENDBYDAY,ACCESSCLOSEDZ,UNITMEDFUEL,CATEGORYLUBES,TRANSACFUELPATH,TABLESTRANSACFUEL,REPORTPATH)
	VALUES(1,'01', 0,10000,'165010','20021201','00','01','03','02','??','12','01','03','07','08',1,0,0,'CM3','21',
	'g:\chevron\data\','c:\','c:\')
--------------------------------------------------------------------------------------------------------------------
--ENVIOS Y RECEPCION DE INFORMACION
--delete sh_shippingtables
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('001 ','AR_CCDOC ',900 ,'T ','AR ','DATEPROCESALES ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('002 ','AR_CCDOCDET ',905 ,'T ','AR ','DATEPROCESALES ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('003 ','BANK ',150 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('004 ','CITY ',190 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('005 ','COMPETITION ',155 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('006 ','COUNTRY ',170 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('007 ','CURRENCY ',160 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('008 ','CURYRATE ',200 ,'T ','MA ','CURYDATE ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('009 ','CURYRATETYPE ',195 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('010 ','CUSTOMER ',260 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('011 ','CUSTSTATUS ',180 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('012 ','CUSTWARRANTY ',175 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('013 ','CUSTWARRANTYTYPE ',165 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('014 ','DOCTYPE ',250 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('015 ','IN_CATEGORY ',100 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('016 ','in_classvendor ',245 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('017 ','IN_COMPETITIONPRICE ',430 ,'T ','IN ','DATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('018 ','IN_COMPETITIONPRICEDET ',435 ,'T ','IN ','DATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('019 ','IN_DOCSTATUS ',240 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('020 ','IN_INTRAHEAD ',440 ,'T ','IN ','INTRDATEPROCE ',0 ,1 ,0,1)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('021 ','IN_INTRAITEM ',445 ,'T ','IN ','INTRDATEPROCE ',0 ,1 ,0,1)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('022 ','IN_INVENTHISTOPHISI ',425 ,'T ','IN ','INTRDATEPHISICAL ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('023 ','IN_INVENTORY ',125 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('024 ','IN_INVENTORYALTER ',130 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('025 ','IN_INVENTORYDAT ',145 ,'M ','MA ',' ',1 ,0 ,1,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('026 ','IN_INVENTORYDES ',135 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('027 ','IN_INVENTORYTYPE ',115 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('028 ','IN_INVENTORYUNITMED ',110 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('029 ','IN_INVENTPHISICAL ',0 ,'X ','IN ',' ',0 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('030 ','IN_KDXHIST ',455 ,'M ','IN ',' ',0 ,1 ,1,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('031 ','IN_KIT ',400 ,'M ','IN ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('032 ','in_kitcomponent ',405 ,'M ','IN ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('033 ','IN_PRICELEVELTEM ',410 ,'M ','IN ',' ',1 ,0 ,1,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('034 ','IN_PRICELEVELTEMDET ',415 ,'M ','IN ',' ',1 ,0 ,1,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('035 ','IN_PRICELEVELTYPE ',140 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('037 ','IN_SUBCATEGORY ',105 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('038 ','IN_TYPEDOC ',235 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('039 ','IN_VENDOR ',210 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('040 ','IN_VENDORINVT ',215 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('041 ','INTRAMOV ',450 ,'T ','IN ','INTRDATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('042 ','OP_BONUS ',500 ,'M ','OP ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('043 ','OP_BUSINESSTYPE ',505 ,'M ','OP ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('044 ','OP_CARD ',225 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('045 ','OP_CARD_MONT ',510 ,'T ','OP ','DATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('046 ','OP_CCSALESPERSON ',530 ,'T ','OP ','DATEPROCE ',1 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('047 ','OP_CCSALESPERSONDET ',535 ,'T ','OP ','DATEPROCE ',1 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('048 ','OP_CCSALESPERSONTYPE ',525 ,'M ','OP ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('049 ','OP_CORELATIVE ',540 ,'X ','OP ',' ',0 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('050 ','OP_CTRLFUEL ',545 ,'T ','OP ','DATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('051 ','OP_CTRLFUELDET ',550 ,'T ','OP ','DATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('052 ','OP_CTRLFUELPRICE ',555 ,'T ','OP ','DATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('053 ','OP_CTRLTURN ',560 ,'T ','OP ','DATEPROCES ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('054 ','OP_CTRLTURNDET ',565 ,'T ','OP ','DATEPROCES ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('055 ','OP_CUST_LIMIT ',570 ,'M ','OP ',' ',1 ,0 ,1,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('056 ','OP_CUSTBADGE ',575 ,'M ','OP ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('057 ','OP_CUSTCARD ',580 ,'M ','OP ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('058 ','OP_CUSTCLASS ',220 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('059 ','OP_CUSTOMER_PRCLVL ',585 ,'M ','OP ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('060 ','OP_CUSTZONE ',590 ,'M ','OP ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('061 ','OP_DEFINITIONPD ',595 ,'X ','OP ',' ',0 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('062 ','OP_DEPOSIT ',600 ,'T ','OP ','DATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('063 ','OP_DEPOSITDET ',605 ,'T ','OP ','DATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('064 ','OP_DEPOSITSITE ',610 ,'T ','OP ','DATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('065 ','OP_DEPOSITSITEDET ',615 ,'T ','OP ','DATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('066 ','OP_DEPOSITTYPE ',230 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('067 ','OP_DOCREFERENCE ',620 ,'M ','OP ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('068 ','OP_DOCSERIES ',625 ,'M ','OP ',' ',1 ,0 ,1,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('069 ','OP_DOCSUMMARY ',635 ,'T ','OP ','DOCDATE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('070 ','OP_DOCSUMMARYDET ',640 ,'T ','OP ','DOCDATE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('071 ','OP_DOCSUMMARYTYPE ',630 ,'M ','OP ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('072 ','OP_HISTRANSFUEL ',0 ,'X ','OP ',' ',0 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('073 ','OP_LOADSALESORD ',0 ,'X ','OP ',' ',0 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('074 ','OP_LOADSALESORDDET ',0 ,'X ','OP ',' ',0 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('075 ','OP_PRCLVLCUST ',645 ,'M ','OP ',' ',1 ,0 ,1,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('076 ','OP_PRCLVLCUSTDET ',650 ,'M ','OP ',' ',1 ,0 ,1,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('077 ','OP_PRINTERTYPE ',655 ,'M ','OP ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('078 ','OP_PROMOTIONCARD ',665 ,'M ','OP ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('079 ','OP_PROMOTIONCARDTYPE ',660 ,'M ','OP ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('080 ','OP_SALES ',675 ,'T ','OP ','DATEPROCESALES ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('081 ','OP_SALESCARD ',680 ,'T ','OP ','DATEPROCESALES ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('082 ','OP_SALESDET ',685 ,'T ','OP ','DATEPROCESALES ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('083 ','OP_SALESPERSON ',520 ,'M ','OP ',' ',1 ,0 ,1,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('084 ','OP_SALESPOINTSETTING ',0 ,'X ','OP ',' ',0 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('085 ','OP_SALESPOINTVSSIDE ',0 ,'X ','OP ',' ',0 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('087 ','OP_SIDE_FUEL ',0 ,'X ','OP ',' ',0 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('088 ','OP_STATUSPERSON ',515 ,'M ','OP ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('089 ','OP_SUMMARYDAY ',695 ,'T ','OP ','DATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('090 ','OP_SUMMARYSALES ',700 ,'T ','OP ','DATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('091 ','OP_SUMMARYSALESDET ',705 ,'T ','OP ','DATEPROCE ',0 ,1 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('092 ','OP_TICKETFORM ',0 ,'X ','OP ',' ',0 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('093 ','OP_TRAN ',0 ,'X ','OP ',' ',0 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('094 ','OP_TURNVSSIDE ',0 ,'X ','OP ',' ',0 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('095 ','OP_ZETA ',0 ,'X ','OP ','DATEPROCESALES ',0 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('096 ','SE_ACCESSDETRIGHTS ',425 ,'M ','SE ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('097 ','SE_GROUPREC ',415 ,'M ','SE ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('098 ','SE_MODULE ',400 ,'M ','SE ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('099 ','SE_SCREEN ',405 ,'M ','SE ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('100 ','SE_USERGROUP ',420 ,'M ','SE ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('101 ','SE_USERREC ',410 ,'M ','SE ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('103 ','SH_SHIPPINGTABLES ',0 ,'M ','SH ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('104 ','SITE ',205 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('105 ','STATE ',185 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('106 ','TAXS ',120 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('107 ','TERMS ',255 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('128 ','TYPEPAYMENT ',270 ,'M ','MA ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('129 ','XDIAS_PAGO ',0 ,'X ','AR ',' ',1 ,0 ,0,0)
insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('130 ','XTMP_DIAS_SEMANA_PAGO ',0 ,'X ','AR ',' ',0 ,0 ,0,0)

--insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('102 ','SETUP ',265 ,'S ','MA ',' ',0 ,0 ,1)
--insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('086 ','OP_SETUP ',690 ,'S ','OP ',' ',0 ,0 ,1)
--insert into sh_shippingtables (tableid,tablename,sequence,type,moduleid,datefield,central_to_station,station_to_central,persite,RLSED) values ('036 ','IN_SETUP ',420 ,'S ','IN ',' ',0 ,0 ,1)

