UPDATE TYPE_OPER SET IDBUHSCHET = 225 WHERE (ID = 299); UPDATE TYPE_OPER SET IDBUHSCHET = 315 WHERE (ID = 300); UPDATE TYPE_OPER SET IDBUHSCHET = 462 WHERE (ID = 20); UPDATE TYPE_OPER SET IDBUHSCHET = 376 WHERE (ID = 23); UPDATE TYPE_OPER SET IDBUHSCHET = 342 WHERE (ID = 11); UPDATE TYPE_OPER SET IDBUHSCHET = 90 WHERE (ID = 303); UPDATE TYPE_OPER SET IDBUHSCHET = 0 WHERE (ID = 91); UPDATE TYPE_OPER SET IDBUHSCHET = 45 WHERE (ID = 123); UPDATE TYPE_OPER SET IDBUHSCHET = 88 WHERE (ID = 242); UPDATE TYPE_OPER SET IDBUHSCHET = 375 WHERE (ID = 178); UPDATE TYPE_OPER SET IDBUHSCHET = 461 WHERE (ID = 227); UPDATE TYPE_OPER SET IDBUHSCHET = 45 WHERE (ID = 305); UPDATE TYPE_OPER SET IDBUHSCHET = 375 WHERE (ID = 307); UPDATE TYPE_OPER SET IDBUHSCHET = 389 WHERE (ID = 315); UPDATE TYPE_OPER SET IDBUHSCHET = 390 WHERE (ID = 324); UPDATE TYPE_OPER SET IDBUHSCHET = 376 WHERE (ID = 317); UPDATE TYPE_OPER SET IDBUHSCHET = 433 WHERE (ID = 309); UPDATE TYPE_OPER SET IDBUHSCHET = 394 WHERE (ID = 311); UPDATE TYPE_OPER SET IDBUHSCHET = 0 WHERE (ID = 313); UPDATE TYPE_OPER SET IDBUHSCHET = 263 WHERE (ID = 318); UPDATE TYPE_OPER SET IDBUHSCHET = 1 WHERE (ID = 320); UPDATE TYPE_OPER SET IDBUHSCHET = 375 WHERE (ID = 326); UPDATE TYPE_OPER SET IDBUHSCHET = 221 WHERE (ID = 330); UPDATE TYPE_OPER SET IDBUHSCHET = 375 WHERE (ID = 328); UPDATE TYPE_OPER SET IDBUHSCHET = 376 WHERE (ID = 322); UPDATE TYPE_OPER SET IDBUHSCHET = 463 WHERE (ID = 332); UPDATE TYPE_OPER SET IDBUHSCHET = 39 WHERE (ID = 334); UPDATE TYPE_OPER SET IDBUHSCHET = 413 WHERE (ID = 337); UPDATE TYPE_OPER SET IDBUHSCHET = 291 WHERE (ID = 336); UPDATE TYPE_OPER SET IDBUHSCHET = 0 WHERE (ID = 340); DELETE FROM BUHPLANSCHET where id > 0; INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (363, '19.3', 'НДС по нематериальным активам', NULL, 0, 1, 4, 1, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (285, '02', 'Износ основных средств', '', 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (289, '62', 'Расчеты с покупателями', '', 0, 0, 0, 0, 1, 2, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (291, '66.10', 'Краткоср. кредиты', '', 0, 1, 203, 1, 1, 1, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (292, '66.11', 'Проценты по краткосрочным кредитам', '', 0, 1, 86, 1, 1, 1, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (385, '69.23', 'Расчеты с ПФ (накопительная часть)', '', 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (386, '69.31', 'Расчеты по медиц. страх. ФФОМС-0.2%', '', 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (409, '91.22', 'Прочие расходы, облаг. НДС', '', 0, 1, 54, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (410, '91.6', 'Выплаты из соб.ср-в,не уменьш.н/о базу по прибыли', '', 0, 1, 54, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (401, '82', 'Резервный капитал', '', 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (402, '83', 'Добавочный капитал', '', 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (412, '91.12', 'Прочие доходы по операциям обл. НДС', '', 0, 1, 54, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (413, '91.11', 'Прочие доходы по операциям необл НДС', '', 0, 1, 54, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (66, '0000', 'Начальные остатки', '', 0, 0, 0, 1, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (251, '001', 'Основные средства < 10000', '', 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (1, '01', 'Основные средства', '', 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (8, '05', 'Амортизация нематериальных активов', '', 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (34, '08', 'Вложения во внеоборотные активы', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (35, '10', 'Материалы', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (30, '10.1', 'Сырье и материалы', '', 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (38, '19', 'НДС по приобретенным ценностям', '', 0, 1, 148, 1, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (440, '68.5', 'Налог на имущество', '', 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (442, '69.12', 'Расчеты по соц. страх. от несч.случ. 0.2%', '', 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (389, '70', 'Расчеты с персоналом по оплате труда', NULL, 0, 1, 8, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (375, '50', 'Касса', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (390, '71', 'Расчеты с подотчетными лицами', '', 0, 1, 8, 1, 1, 1, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (261, '04', 'Нематериальные активы', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (376, '51.1', 'Расчетный счет Внешторгбанк', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (12, '44', 'Расходы на продажу', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (3, '51', 'Расчетный счет', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (273, '69.32', 'Расчеты по медиц. страх. ТФОМС-3.4%', NULL, 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (275, '69.21', 'Расчеты с ПФ (бюджет)', NULL, 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (39, '58', 'Краткосрочные финансовые вложения', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (205, '58.1', 'Паи и акции', '', 0, 1, 131, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (445, '68.21', 'Налог на прибыль в федеральный бюджет', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (206, '58.2', 'Долговые ценные бумаги', '', 0, 1, 133, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (5, '60', 'Расчеты с поставщиками и подрядчиками', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (45, '60.1', 'Расчеты с поставщиками товара', '', 0, 1, 1, 1, 1, 1, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (357, '19.4', 'НДС по основным средствам', NULL, 0, 1, 4, 1, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (380, '52', 'Валютный счет', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (90, '62.1', 'Расчеты с покупателями (иногородние)', '', 0, 1, 160, 1, 1, 2, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (358, '19.1', 'НДС по приобретенным материалам', '', 0, 1, 4, 1, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (403, '90.21', 'Себестоимость по товарам', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (18, '66', 'Расчеты по краткоср. кредитам и займам', '', 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (404, '90.31', 'НДС по товарам', '', 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (40, '68', 'Расчеты с бюджетом', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (48, '68.2', 'Налог на прибыль', '', 0, 0, 0, 0, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (448, '76.АВ', 'НДС с аванса (пок оптовые)', '', 0, 1, 2, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (52, '68.1', 'Расчеты по НДФЛ', '', 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (405, '90.91', 'Прибыль, убыток от продаж (необл ЕНВД)', '', 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (391, '76.6', 'Расчеты с прочими дебиторами/кредиторами', NULL, 0, 1, 137, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (62, '68.4', 'Налог на рекламу', '', 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (392, '76.H', 'НДС по товарам неоплаченный (пок оптовые)', NULL, 0, 1, 2, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (210, '68.6', 'Штрафы', '', 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (37, '69', 'Расчеты по социальному страхованию и обеспечению', '', 0, 0, 0, 0, 1, 2, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (20, '69.11', 'Расчеты по соц. страхованию 4%', '', 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (21, '69.22', 'Расчеты с ПФ (страховая часть)', '', 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (394, '76.2', 'Расчеты по претензиям', NULL, 0, 1, 137, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (395, '76.3', 'Расчеты по дивидендам и пр доходам', NULL, 0, 1, 137, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (444, '91.3', 'Налоги, относимые на финансовый результат', '', 0, 1, 54, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (103, '73', 'Расчеты с персоналом по прочим операциям', '', 0, 1, 8, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (43, '75', 'Расчеты с учредителями', '', 0, 1, 46, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (16, '76', 'Расчеты с дебиторами/кредиторами', '', 0, 0, 0, 0, 1, 2, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (360, '19.9', 'НДС по приобретенным товарам', NULL, 0, 1, 1, 1, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (397, '80', 'Уставный капитал', '', 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (399, '81', 'Собственные акции', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (342, '41', 'Товары на складе', '', 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (221, '84', 'Нераспределенная прибыль', '', 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (446, '68.22', 'Налог на прибыль в территориальный бюджет', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (447, '68.23', 'Налог на прибыль в местный бюджет', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (429, '99.3', 'Прибыли и убытки по внереализ. операциям', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (416, '91.9', 'Сальдо прочих доходов/расходов', '', 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (224, '90', 'Продажи', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (225, '90.11', 'Выручка по товарам', '', 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (417, '91.5', 'Расходы сверх. норм (ст. 270 НК РФ)', '', 0, 1, 54, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (217, '91', 'Прочие доходы и расходы', '', 0, 1, 54, 0, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (430, '99.2', 'Прибыли и убытки по услугам', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (219, '91.21', 'Прочие расходы, необл. НДС', '', 0, 1, 54, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (431, '99.5', 'Платежи в бюджет штрафов и пени', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (88, '94', 'Недостачи и потери от порчи ценностей', '', 0, 0, 0, 1, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (249, '96', 'Резервы предстоящих расходов и платежей', '', 0, 0, 0, 1, 1, 1, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (41, '99', 'Прибыли и убытки', '', 0, 0, 0, 0, 1, 2, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (263, '08.1', 'Приобретение объектов ОС', NULL, 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (264, '08.2', 'Приобретение объектов НМА', NULL, 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (265, '10.91', 'Инветарь и хоз принадлежности', NULL, 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (382, '55', 'Ссудный счет', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (383, '57', 'Переводы в пути', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (419, '97', 'Расходы будущих периодов (необл ЕНВД)', NULL, 0, 1, 125, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (313, '98', 'Доходы будущих периодов', NULL, 0, 1, 139, 1, 1, 1, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (315, '44.1', 'Коммерческие расходы', NULL, 0, 1, 187, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (51, '68.3', 'Налог на добавленную стоимость', '', 0, 0, 0, 1, 1, 2, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (461, '62.2', 'Расчеты с покупателями (пермские)', '', 0, 1, 191, 1, 1, 2, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (422, '99.1', 'Прибыли и убытки от продажи товаров', '', 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (424, '99.4', 'Начисление и уплата налога на прибыль', '', 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (408, '90.22', 'Себестоимость по услугам', '', 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (361, '19.5', 'НДС по работам и услугам', NULL, 0, 1, 4, 1, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (426, '90.12', 'Выручка по услугам', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (427, '90.32', 'НДС по услугам', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (428, '90.92', 'Прибыль и убыток по услугам', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (432, '99.9', 'Сальдо прибылей и убытков', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (433, '60.2', 'Расчеты с поставщиками услуг', '', 0, 1, 195, 1, 1, 1, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (435, '10.93', 'Подписка', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (450, '68.7', 'Выписка из Госреестра', NULL, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (451, '66.3', 'Краткосроч.кредиты прочих организаций', NULL, 0, 1, 86, 1, 1, 1, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (452, '66.20', 'Овердрафтный кредит банка', '', 0, 1, 86, 1, 1, 1, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (453, '66.21', 'Проценты по овердрафтному кредиту банка', '', 0, 1, 86, 1, 1, 1, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (454, '76.7', 'Перевыставляемые услуги (покупатели)', NULL, 0, 1, 2, 1, 1, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (458, '51.2', 'Расчетный счет ОСБ', '', 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (459, '009', 'Обеспечения обязательств и платежей выданные', NULL, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (462, '62.3', 'Расчеты с покупателями (сотрудники)', '', 0, 1, 8, 1, 1, 2, 0, 1, 0, 0, NULL, NULL); INSERT INTO BUHPLANSCHET (ID, SCHET, NAME, DESCRIPTION, STATUS, ISANALITIC, ANALITIC, ISOPEN, ISBALANS, SCHETTYPE, SALDOTYPE, IDBUHPLAN, IDOWNER, IDINOWNER, RECORDCOLOR, RECORDFONT) VALUES (463, '62.6', 'Расчеты с покупателями (аренда)', '', 0, 1, 199, 1, 1, 2, 0, 1, 0, 0, NULL, NULL); DELETE FROM CODOP where id > 0; INSERT INTO CODOP (ID, NAME, DT_SCHET, KT_SCHET, LETMANUALOPERBYDOC, LETINVOICE, DATEBEGIN, DATEEND, USEBUHOPERBUFFER) VALUES (1, 'Реализация товара', '62', '41', NULL, NULL, '2000-01-01 00:00:00', '2010-01-01 00:00:00', NULL); INSERT INTO CODOP (ID, NAME, DT_SCHET, KT_SCHET, LETMANUALOPERBYDOC, LETINVOICE, DATEBEGIN, DATEEND, USEBUHOPERBUFFER) VALUES (4, 'Возврат товара', '41', '62', NULL, NULL, '2000-01-01 00:00:00', '2010-01-01 00:00:00', NULL); DELETE FROM CODOPA where id > 0; INSERT INTO CODOPA (ID, IDPARENT, DT_SCHET, KT_SCHET, DT_CODE, KT_CODE, NAMEOPER, NROUND, IDBUHBOOKS, ISCOMMONSCRIPT) VALUES (2, 1, '', '90.11', '', '', 'Реализация товара', 2, 1, NULL); INSERT INTO CODOPA (ID, IDPARENT, DT_SCHET, KT_SCHET, DT_CODE, KT_CODE, NAMEOPER, NROUND, IDBUHBOOKS, ISCOMMONSCRIPT) VALUES (4, 1, '90.21', '41', '', '', 'Реализация товара (себестоимость)', 2, 1, NULL); INSERT INTO CODOPA (ID, IDPARENT, DT_SCHET, KT_SCHET, DT_CODE, KT_CODE, NAMEOPER, NROUND, IDBUHBOOKS, ISCOMMONSCRIPT) VALUES (5, 4, '', '90.11', '', '', 'Возврат товара', 2, 1, NULL); INSERT INTO CODOPA (ID, IDPARENT, DT_SCHET, KT_SCHET, DT_CODE, KT_CODE, NAMEOPER, NROUND, IDBUHBOOKS, ISCOMMONSCRIPT) VALUES (6, 4, '90.21', '41', '', '', 'Возврат товара (себестоимость)', 2, 1, NULL);