база 'pre-test-inside-pg3.unix.tensor.ru:6432/test-inside.tensor.ru' схема ''_00000003'':
SELECT "T0"."0" AS "0",
"T0"."1" AS "1",
"T0"."2" AS "2",
"T0"."3" AS "3",
"T0"."4" AS "4",
"T0"."5" AS "5",
"T0"."6" AS "6",
"T0"."7" AS "7",
"T0"."7@" AS "7@",
"T0"."8" AS "8",
"T0"."9" AS "9",
"T0"."10" AS "10",
"T0"."11" AS "11",
"T0"."12" AS "12",
"T0"."13" AS "13",
"T0"."14" AS "14",
"T0"."15" AS "15",
"T0"."16" AS "16",
"T0"."17" AS "17",
"T0"."18" AS "18",
"T0"."19" AS "19",
"T0"."20" AS "20",
"T0"."21" AS "21",
"T0"."22" AS "22",
"T0"."23" AS "23",
"T1"."@Документ" AS "24",
"T1"."Счетчики" AS "25",
"T1"."Регламент" AS "26",
"T0"."27" AS "27",
"T0"."28" AS "28",
"T0"."29" AS "29",
"T0"."30" AS "30",
"T0"."31" AS "31",
"T0"."32" AS "32",
"T0"."33" AS "33",
"T0"."34" AS "34",
"T0"."35" AS "35",
"T0"."36" AS "36",
"T0"."37" AS "37",
"T0"."38" AS "38",
"T0"."39" AS "39",
"T0"."40" AS "40",
"T0"."41" AS "41",
"T0"."42" AS "42",
"T0"."43" AS "43",
"T0"."44" AS "44",
"T0"."45" AS "45",
"T0"."46" AS "46",
"T0"."47" AS "47",
"T0"."48" AS "48",
"T0"."49" AS "49",
"T0"."50" AS "50",
"T0"."51" AS "51",
"T0"."52" AS "52",
"T0"."53" AS "53",
"T0"."54" AS "54",
"T0"."55" AS "55",
"T0"."56" AS "56",
"T0"."57" AS "57",
"T0"."58" AS "58",
"T0"."59" AS "59",
"T0"."60" AS "60",
"T0"."61" AS "61",
"T0"."62" AS "62",
"T0"."63" AS "63",
"T0"."64" AS "64",
"T0"."65" AS "65",
"T0"."66" AS "66",
"T0"."67" AS "67",
"T0"."68" AS "68",
"T0"."69" AS "69",
"T0"."70" AS "70",
"T0"."71" AS "71",
"T0"."72" AS "72",
"T0"."73" AS "73",
"T0"."74" AS "74",
"T0"."75" AS "75",
"T0"."76" AS "76",
"T0"."77" AS "77",
"T0"."78" AS "78",
"T0"."79" AS "79",
"T0"."80" AS "80",
"T0"."81" AS "81",
"T0"."82" AS "82",
"T0"."83" AS "83",
"T0"."84" AS "84",
"T0"."85" AS "85",
"T0"."86" AS "86",
"T0"."86@" AS "86@",
"T0"."87" AS "87",
"T0"."88" AS "88",
"T0"."89" AS "89",
"T0"."90" AS "90",
"T0"."91" AS "91",
"T0"."92" AS "92",
"T0"."93" AS "93",
"T0"."94" AS "94",
"T0"."95" AS "95",
"T0"."96" AS "96",
"T0"."97" AS "97",
"T0"."97@" AS "97@",
"T0"."98" AS "98",
"T0"."99" AS "99",
"T0"."100" AS "100",
"T0"."101" AS "101",
"T0"."102" AS "102",
"T0"."103" AS "103",
"T0"."104" AS "104",
"T0"."105" AS "105",
"T0"."106" AS "106",
"T0"."107" AS "107",
"T0"."108" AS "108",
"T0"."109" AS "109",
"T0"."110" AS "110",
"T0"."111" AS "111",
"T0"."112" AS "112",
"T0"."113" AS "113",
"T0"."114" AS "114",
"T0"."115" AS "115",
"T0"."116" AS "116",
"T0"."117" AS "117",
"T0"."118" AS "118",
"T0"."119" AS "119",
"T0"."120" AS "120",
"T0"."121" AS "121",
"T0"."122" AS "122",
"T0"."123" AS "123",
"T0"."124" AS "124",
"T0"."125" AS "125",
"T0"."126" AS "126",
"T0"."127" AS "127",
"T0"."128" AS "128",
"T0"."129" AS "129",
"T0"."130" AS "130",
"T0"."131" AS "131",
"T0"."132" AS "132",
"T0"."133" AS "133",
"T0"."134" AS "134",
"T0"."135" AS "135",
"T0"."136" AS "136",
"T0"."137" AS "137",
"T0"."138" AS "138",
"T0"."139" AS "139",
"T0"."140" AS "140",
"T0"."141" AS "141",
"T0"."142" AS "142",
"T0"."143" AS "143",
"T0"."144" AS "144",
"T0"."145" AS "145",
"T0"."146" AS "146",
"T0"."147" AS "147",
"T0"."148" AS "148",
"T0"."149" AS "149",
"T0"."150" AS "150",
"T0"."151" AS "151",
"T0"."152" AS "152",
"T0"."153" AS "153",
"T0"."154" AS "154",
"T0"."155" AS "155",
"T0"."156" AS "156",
"T0"."157" AS "157",
"T0"."158" AS "158",
"T0"."159" AS "159",
"T0"."160" AS "160",
"T0"."161" AS "161",
"T0"."162" AS "162",
"T0"."163" AS "163",
"T0"."164" AS "164",
"T0"."165" AS "165",
"T0"."166" AS "166",
"T0"."167" AS "167",
"T0"."168" AS "168",
"T0"."169" AS "169",
"T0"."170" AS "170",
"T0"."171" AS "171",
"T0"."172" AS "172",
"T0"."173" AS "173",
"T0"."174" AS "174",
"T0"."175" AS "175",
"T0"."176" AS "176",
"T0"."177" AS "177",
"T0"."178" AS "178",
"T0"."178@" AS "178@",
"T0"."179" AS "179",
"T0"."180" AS "180",
"T0"."181" AS "181",
"T0"."182" AS "182",
"T0"."183" AS "183",
"T0"."184" AS "184",
"T0"."185" AS "185",
"T0"."186" AS "186",
"T0"."187" AS "187",
"T0"."188" AS "188",
"T0"."189" AS "189",
"T0"."190" AS "190",
"T0"."191" AS "191",
"T0"."192" AS "192",
"T0"."193" AS "193",
"T0"."194" AS "194",
"T0"."195" AS "195",
"T0"."196" AS "196",
"T0"."197" AS "197",
"T0"."198" AS "198",
"T0"."199" AS "199",
"T0"."200" AS "200",
"T0"."201" AS "201",
"T0"."202" AS "202",
"T0"."203" AS "203",
"T0"."204" AS "204",
"T0"."205" AS "205",
"T0"."206" AS "206",
"T0"."207" AS "207",
"T0"."208" AS "208",
"T0"."208@" AS "208@",
"T0"."209" AS "209",
"T0"."210" AS "210",
"T0"."211" AS "211",
"T0"."212" AS "212",
"T0"."213" AS "213",
"T0"."214" AS "214",
"T0"."215" AS "215",
"T0"."216" AS "216",
"T0"."ctid_Лицо1" as "ctid_Лицо1",
"T0"."ctid_ТипДокумента" as "ctid_ТипДокумента",
"T0"."ctid_ДокументРасширение" as "ctid_ДокументРасширение",
"T0"."ctid_ЛицоСоздал" as "ctid_ЛицоСоздал",
"T0"."ctid_Контрагент" as "ctid_Контрагент",
"T0"."ctid_Сотрудник" as "ctid_Сотрудник",
"T0"."ctid_ДокументНашаОрганизация" as "ctid_ДокументНашаОрганизация",
"T0"."ctid_b5bbc3a49bb1c949402eaece14d16d2d" as "ctid_b5bbc3a49bb1c949402eaece14d16d2d",
"T0"."ctid_Подразделение" as "ctid_Подразделение",
"T1"."ctid" as "ctid_СписокЛидов"
FROM (
SELECT "T1"."@Документ" AS "0",
"T1"."Документ_" AS "1",
"T1"."Номер" AS "2",
"T1"."Дата" AS "3",
"T1"."ДокументНашаОрганизация" AS "4",
"T1"."ТипДокумента" AS "5",
"T1"."Сумма" AS "6",
"T1"."Раздел" AS "7",
"T1"."Раздел@" AS "7@",
"T1"."ЛицоИзменил" AS "8",
"T1"."Лицо" AS "9",
"T1"."Лицо1" AS "10",
"T1"."Примечание" AS "11",
"T1"."Сотрудник" AS "12",
"T1"."Подразделение" AS "13",
"T1"."ИдентификаторКаталога" AS "14",
"T1"."ЧисловойНомер" AS "15",
"T1"."ИдентификаторДокумента" AS "16",
"T1"."Время" AS "17",
"T1"."Удален" AS "18",
"T1"."Пометки" AS "19",
"T1"."Регламент" AS "20",
"T1"."Лицо2" AS "21",
"T1"."Лицо3" AS "22",
"T1"."ЛицоСоздал" AS "23",
"T8"."@Лицо" AS "27",
"T8"."РазрешенаПубликация" AS "28",
"T8"."Округлять" AS "29",
"T8"."Помещение" AS "30",
"T8"."СвидДата" AS "31",
"T8"."Префикс" AS "32",
"T8"."СвидНомер" AS "33",
"T8"."СвидКемВыдано" AS "34",
"T8"."СвидКемВыданоКод" AS "35",
"T8"."КодПодчиненностиФСС" AS "36",
"T8"."НомерТФОМС" AS "37",
"T8"."ПФНаименованиеКраткое" AS "38",
"T8"."ПФНаименованиеПолное" AS "39",
"T8"."ДопКодФСС" AS "40",
"T8"."КодТерритории" AS "41",
"T8"."РегНомерФСС" AS "42",
"T8"."КлиентСБИС2" AS "43",
"T8"."ПФТелефон" AS "44",
"T8"."ОграничиватьПраваПодписи" AS "45",
"T8"."GLN" AS "46",
"T8"."About" AS "47",
"T8"."УправленческийУчет" AS "48",
"T8"."Главная" AS "49",
"T8"."systemId" AS "50",
"T8"."hotelId" AS "51",
"T8"."userId" AS "52",
"T8"."SalesPoint" AS "53",
"T8"."TimeZone" AS "54",
"T8"."SPType" AS "55",
"T8"."SeparateSender" AS "56",
"T8"."AccountingDelegation" AS "57",
"T8"."CZNRegNum" AS "58",
"T8"."WorkplaceData" AS "59",
"T8"."ПодтверждаетПолучениеДокументов" AS "60",
"T3"."@ТипДокумента" AS "61",
"T3"."Порядок" AS "62",
"T3"."НазваниеРаздела" AS "63",
"T3"."ТипРеестра" AS "64",
"T3"."ТипЗагрузчика" AS "65",
"T3"."СпособСоздания" AS "66",
"T3"."ТипСуперфазы" AS "67",
"T3"."ТочкиПроведения" AS "68",
"T3"."НастройкаКарточкиДокумента" AS "69",
"T3"."ШаблонФильтра" AS "70",
"T3"."РежимОткрытия" AS "71",
"T3"."ЗонаДоступа" AS "72",
"T3"."ТипДокумента" AS "73",
"T3"."ПодТипДокумента" AS "74",
"T3"."Название" AS "75",
"T3"."ИмяБраузера" AS "76",
"T3"."НазваниеКраткое" AS "77",
"T3"."ИмяДиалога" AS "78",
"T3"."GUID" AS "79",
"T3"."ФлагиТипаДокумента" AS "80",
"T3"."ШаблонСтатистики" AS "81",
"T3"."Удален" AS "82",
"T3"."Иконки" AS "83",
"T3"."РеестрПара" AS "84",
"T3"."ШаблонЗакладок" AS "85",
"T3"."Раздел" AS "86",
"T3"."Раздел@" AS "86@",
"T2"."@Лицо" AS "87",
"T2"."Лицо_" AS "88",
"T2"."Название" AS "89",
"T2"."params" AS "90",
"T7"."@Лицо" AS "91",
"T7"."Лицо_" AS "92",
"T7"."Название" AS "93",
"T7"."params" AS "94",
"T10"."@Лицо" AS "95",
"T10"."Название" AS "96",
"T10"."Раздел" AS "97",
"T10"."Раздел@" AS "97@",
"T10"."ГрафикОтпусковСдается" AS "98",
"T10"."СдаетсяТабель" AS "99",
"T10"."Табельщик" AS "100",
"T10"."Код" AS "101",
"T10"."ПоследнийЗакрытыйМесяц" AS "102",
"T10"."ПервыйЗакрытыйМесяц" AS "103",
"T10"."Флаги" AS "104",
"T10"."Телефон" AS "105",
"T10"."Примечание" AS "106",
"T10"."Тип" AS "107",
"T10"."КолЧел" AS "108",
"T10"."Адрес" AS "109",
"T10"."ЭлектроннаяПочта" AS "110",
"T10"."ДатаЗакрытия" AS "111",
"T10"."ПорядковыйНомер" AS "112",
"T10"."Идентификатор" AS "113",
"T10"."KLADR_Code" AS "114",
"T10"."Description" AS "115",
"T10"."Контрагент" AS "116",
"T10"."ОфисПродаж" AS "117",
"T10"."Руководитель" AS "118",
"T5"."@Лицо" AS "119",
"T5"."Лицо_" AS "120",
"T5"."Название" AS "121",
"T5"."params" AS "122",
"T4"."@Документ" AS "123",
"T4"."ИзмененныеПараметры" AS "124",
"T4"."ДатаПолнойОплаты" AS "125",
"T4"."Состояние" AS "126",
"T4"."ПримечаниеУС" AS "127",
"T4"."РасчетныйСчет" AS "128",
"T4"."КодВалюта" AS "129",
"T4"."Название" AS "130",
"T4"."$Сумма" AS "131",
"T4"."Сумма" AS "132",
"T4"."СуммаБезНДС" AS "133",
"T4"."ДатаВремяСоздания" AS "134",
"T4"."Курс" AS "135",
"T4"."Срок" AS "136",
"T4"."Изменен" AS "137",
"T4"."СостояниеКраткое" AS "138",
"T4"."Флаги" AS "139",
"T4"."ТекстОшибки" AS "140",
"T4"."Ресурсы" AS "141",
"T4"."Оплачено" AS "142",
"T4"."$Оплачено" AS "143",
"T4"."Параметры" AS "144",
"T4"."ИдентификаторВИ" AS "145",
"T4"."ИдентификаторРедакции" AS "146",
"T4"."ЧислоПодзадач" AS "147",
"T4"."ПлановоеВремя" AS "148",
"T4"."Комментарий" AS "149",
"T4"."$СуммаБезНДС" AS "150",
"T6"."@Лицо" AS "151",
"T6"."Контрагент_" AS "152",
"T6"."ОтветственныйСотрудник" AS "153",
"T6"."ОтветственныйСтруктура" AS "154",
"T6"."Название" AS "155",
"T6"."Type" AS "156",
"T6"."LastDTAction" AS "157",
"T6"."КодФилиала" AS "158",
"T6"."ИНН" AS "159",
"T6"."KLADR" AS "160",
"T6"."НазваниеПолное" AS "161",
"T6"."ShortName" AS "162",
"T6"."АдресЮридический" AS "163",
"T6"."АдресФактический" AS "164",
"T6"."ДатаРегистрации" AS "165",
"T6"."ДатаЛиквидации" AS "166",
"T6"."ИдентификаторСПП" AS "167",
"T6"."РегНомерПФ" AS "168",
"T6"."ОКПО" AS "169",
"T6"."UUID" AS "170",
"T6"."ParsedAddress" AS "171",
"T6"."Entrepreneur" AS "172",
"T6"."КПП" AS "173",
"T6"."ОГРН" AS "174",
"T6"."НеОтображается" AS "175",
"T6"."Идентификатор" AS "176",
"T6"."ExternalId" AS "177",
"T6"."Раздел" AS "178",
"T6"."Раздел@" AS "178@",
"T6"."CountryCode" AS "179",
"T6"."MultiKPP" AS "180",
"T9"."@Лицо" AS "181",
"T9"."Контрагент_" AS "182",
"T9"."ОтветственныйСотрудник" AS "183",
"T9"."ОтветственныйСтруктура" AS "184",
"T9"."Название" AS "185",
"T9"."Type" AS "186",
"T9"."LastDTAction" AS "187",
"T9"."КодФилиала" AS "188",
"T9"."ИНН" AS "189",
"T9"."KLADR" AS "190",
"T9"."НазваниеПолное" AS "191",
"T9"."ShortName" AS "192",
"T9"."АдресЮридический" AS "193",
"T9"."АдресФактический" AS "194",
"T9"."ДатаРегистрации" AS "195",
"T9"."ДатаЛиквидации" AS "196",
"T9"."ИдентификаторСПП" AS "197",
"T9"."РегНомерПФ" AS "198",
"T9"."ОКПО" AS "199",
"T9"."UUID" AS "200",
"T9"."ParsedAddress" AS "201",
"T9"."Entrepreneur" AS "202",
"T9"."КПП" AS "203",
"T9"."ОГРН" AS "204",
"T9"."НеОтображается" AS "205",
"T9"."Идентификатор" AS "206",
"T9"."ExternalId" AS "207",
"T9"."Раздел" AS "208",
"T9"."Раздел@" AS "208@",
"T9"."CountryCode" AS "209",
"T9"."MultiKPP" AS "210",
(SELECT contr."ИНН"
FROM "Контрагент" contr
WHERE contr."@Лицо" = "T1"."ДокументНашаОрганизация"
)::varchar AS "211",
(SELECT sp."Название"
FROM "СтруктураПредприятия" sp
WHERE sp."@Лицо" = "T1"."Подразделение"
LIMIT 1
)::varchar AS "212",
(Select "Название"||':'||COALESCE("Иконка",'')
from "Регламент"
WHERE "Идентификатор"="T1"."ИдРегламента"::text
)::varchar AS "213",
(Select count("@Регламент")
   FROM "Регламент"
   WHERE "Регламент"."ТипДокумента"="T1"."ТипДокумента"

)::integer AS "214",
(SELECT
	"ТипДокумента"
FROM
	"ТипДокумента"
WHERE
	"@ТипДокумента" = (SELECT "ТипДокумента" FROM "Документ" WHERE "@Документ" = "T1"."Раздел")
)::varchar AS "215",
"T1"."$Черновик" AS "$Черновик",
"T1"."ctid" AS "216",
"T2"."ctid" as "ctid_Лицо1",
"T3"."ctid" as "ctid_ТипДокумента",
"T4"."ctid" as "ctid_ДокументРасширение",
"T5"."ctid" as "ctid_ЛицоСоздал",
"T6"."ctid" as "ctid_Контрагент",
"T7"."ctid" as "ctid_Сотрудник",
"T8"."ctid" as "ctid_ДокументНашаОрганизация",
"T9"."ctid" as "ctid_b5bbc3a49bb1c949402eaece14d16d2d",
"T10"."ctid" as "ctid_Подразделение"
FROM "Документ"  "T1" LEFT JOIN "Лицо" "T2"
ON "T1"."Лицо1" = "T2"."@Лицо"
LEFT JOIN "ТипДокумента" "T3"
ON "T1"."ТипДокумента" = "T3"."@ТипДокумента"
LEFT JOIN "ДокументРасширение" "T4"
ON "T1"."@Документ" = "T4"."@Документ"
LEFT JOIN "Лицо" "T5"
ON "T1"."ЛицоСоздал" = "T5"."@Лицо"
LEFT JOIN "Контрагент" "T6"
ON "T2"."@Лицо" = "T6"."@Лицо"
LEFT JOIN "Лицо" "T7"
ON "T1"."Сотрудник" = "T7"."@Лицо"
LEFT JOIN "НашаОрганизация" "T8"
ON "T1"."ДокументНашаОрганизация" = "T8"."@Лицо"
LEFT JOIN "Контрагент" "T9"
ON "T8"."@Лицо" = "T9"."@Лицо"
LEFT JOIN "СтруктураПредприятия" "T10"
ON "T1"."Подразделение" = "T10"."@Лицо"
WHERE ( ("T1"."@Документ" = 19613103))  )
"T0" LEFT JOIN "СписокЛидов" "T1"
ON "T0"."0" = "T1"."@Документ"
;