373 lines
14 KiB
Plaintext
373 lines
14 KiB
Plaintext
relationship 0c9c501a-fa6a-4c94-99ae-b825ee836e89
|
||
fromColumn: 'Стоимость МП'.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship 70d8fb19-ce6e-4331-bdd5-c48b97661c3a
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: Партнер.ДатаРегистрации
|
||
toColumn: LocalDateTable_67da7b50-915b-480b-9e3a-3a60739fb0c6.Date
|
||
|
||
relationship 34a39f02-5cb4-4c1b-b8e8-ea3ef9aafb4e
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: crm_company_uf.'Дата последнего звонка'
|
||
toColumn: LocalDateTable_49b06afb-4254-4da6-9109-618106084862.Date
|
||
|
||
relationship b7780e24-ae05-4812-ad3f-b6d9dc7f50cc
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: Партнер.'Дата последнего звонка'
|
||
toColumn: LocalDateTable_c661d468-0044-4990-b9e8-723cda59cf51.Date
|
||
|
||
relationship 8e2d6fc2-aec0-1ef2-5916-f2e35c465192
|
||
fromColumn: 'Стоимость МП'.ПартнерКод
|
||
toColumn: Партнер.'Код УТ'
|
||
|
||
relationship d56f34dd-d18a-4511-b10b-85895b67822c
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: Себестоимость.'Заказ закрыт'
|
||
toColumn: LocalDateTable_93d80160-0984-4e44-91de-316b6ab26727.Date
|
||
|
||
relationship 355102b6-e291-2095-8fd4-32447366f728
|
||
fromColumn: Себестоимость.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship 7505878b-5508-458a-653e-9360556cef53
|
||
fromColumn: Себестоимость.PartnerId
|
||
toColumn: Партнер.partner_id
|
||
|
||
relationship 5534460f-9c82-363b-9fe4-45f95118ac89
|
||
crossFilteringBehavior: bothDirections
|
||
fromColumn: Номенклатура._group_id
|
||
toColumn: Группы.group_id
|
||
|
||
relationship AutoDetected_e288bde8-030d-4a1f-8a03-91f31dd9f651
|
||
fromColumn: Остатки.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship 8208f512-c8a9-47d1-b47c-2bce30b6b8f8
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'Заявки на оплату'.date
|
||
toColumn: LocalDateTable_729bf6db-04e4-4a26-9dce-b3837667cb92.Date
|
||
|
||
relationship 55297e27-cac1-ef2a-4ee1-6cc80b8a1167
|
||
fromColumn: 'Заявки на оплату'.partner_id
|
||
toColumn: Партнер.partner_id
|
||
|
||
relationship 6bdd8855-c6d2-4c21-b90f-cb9f0b0bd52e
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'План продаж по группам'.Месяц
|
||
toColumn: LocalDateTable_704570fc-e0c6-4914-97ab-ebb645a2ab6e.Date
|
||
|
||
relationship 8afa5bd2-9707-4363-96f2-670a305dc4f3
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: Остатки.Дата
|
||
toColumn: LocalDateTable_2b612047-5dcc-402e-b2ed-154636b18544.Date
|
||
|
||
relationship 7fecb2f9-fc49-b4a1-2fd5-41f2e1888950
|
||
fromColumn: Себестоимость.Организация
|
||
toColumn: Организация.Организация
|
||
|
||
relationship 32985c97-823f-ffbc-00fe-9f92ac1bae11
|
||
fromColumn: 'Стоимость МП'.Организация
|
||
toColumn: Организация.Организация
|
||
|
||
relationship AutoDetected_e9e769be-3122-4b9c-a4eb-06f97eba8eae
|
||
fromColumn: 'План продаж менеджеров'.user_id
|
||
toColumn: Менеджеры.user_id
|
||
|
||
relationship 02f6fe40-78b9-93d1-f010-564c9b543bfe
|
||
fromColumn: Партнер.manager_id
|
||
toColumn: Менеджеры.user_id
|
||
|
||
relationship f2e0ac1f-b839-4157-6c3e-57b88efa417c
|
||
fromColumn: 'mp остатки'.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship 31cf1118-b7c5-7d77-48dd-1b589c984d03
|
||
fromColumn: 'mp аналитика продаж'.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship AutoDetected_34ee49f1-fee2-4e8c-ae63-add84ec273df
|
||
fromColumn: ПРАЙСлист.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship AutoDetected_3779c3ac-c497-4083-8eb0-ad86aaa8a771
|
||
fromColumn: 'Упущенные продажи'.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship 28a764af-4e8a-4c89-8ceb-304403c0d71a
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'Упущенные продажи'.'Дата первого поступления'
|
||
toColumn: LocalDateTable_2f146245-8120-4ed9-87dc-af8699bb0274.Date
|
||
|
||
relationship 4d693140-48df-ebb1-5b1f-775c66de2412
|
||
fromColumn: 'Заказы все'.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship 9178e59f-fd80-fe45-d854-b1b441024ce8
|
||
isActive: false
|
||
fromColumn: 'Заказы все'.partner_id
|
||
toColumn: Партнер.partner_id
|
||
|
||
relationship 8229a93a-e14d-491e-ac57-cbab91627fdd
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'mp реклама'.'Дата начала'
|
||
toColumn: LocalDateTable_1c75c57c-6ac4-4a07-ab45-b46636c3847c.Date
|
||
|
||
relationship fae31430-95d8-f385-acf1-a2826f31846c
|
||
fromColumn: 'mp реклама'.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship 381b6bd4-06f4-496e-9264-13deb45adbf2
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'План маркеты'.Месяц
|
||
toColumn: LocalDateTable_66d8bbba-35e3-44df-be7f-bb6fc44f271a.Date
|
||
|
||
relationship e4537ee3-4045-38dc-b214-cb1c5de0b9e2
|
||
fromColumn: Закупки.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship cf649bbe-1ad9-14ce-b264-dacef01746a7
|
||
fromColumn: Закупки.Организация
|
||
toColumn: Организация.Организация
|
||
|
||
relationship b3ea723a-e172-b759-0f23-bb851737fb34
|
||
fromColumn: Закупки.partner_id
|
||
toColumn: Партнер.partner_id
|
||
|
||
relationship AutoDetected_78bdb83b-79d3-4f5e-b7af-54227f9db024
|
||
fromColumn: Резервы.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship 8171e79f-bfe6-4798-bb1a-98146553bada
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: Партнер.'Дата первого заказа'
|
||
toColumn: LocalDateTable_588ed205-7c5f-41f0-9bd7-0d82b2484f09.Date
|
||
|
||
relationship 43da0466-6cb4-29cb-0624-f73171c1d064
|
||
toCardinality: many
|
||
fromColumn: 'Я.Директ расходы'.key_dir
|
||
toColumn: 'Я.Директ заказы'.key_dir
|
||
|
||
relationship e1b1daf7-34c4-f072-2ead-53e97f931563
|
||
fromColumn: Себестоимость.'Номер заказа'
|
||
toColumn: 'Я.Директ заказы'.'ID покупки'
|
||
|
||
relationship AutoDetected_817d2b4f-98f1-49e0-870f-fdecc60d7626
|
||
fromColumn: 'mp узел'.partner_id
|
||
toColumn: Партнер.partner_id
|
||
|
||
relationship AutoDetected_42494399-5383-444c-8db6-3ff0012aa9c5
|
||
fromColumn: 'mp остатки'.Узел
|
||
toColumn: 'mp узел'.Узел
|
||
|
||
relationship AutoDetected_77d661d6-36fd-48d2-b282-4961d4b5d737
|
||
fromColumn: 'mp аналитика продаж'.Узел
|
||
toColumn: 'mp узел'.Узел
|
||
|
||
relationship AutoDetected_372b4703-5804-44e3-9c83-e56aea6514b2
|
||
fromColumn: 'mp реклама'.Узел
|
||
toColumn: 'mp узел'.Узел
|
||
|
||
relationship 706a676c-ec4a-005d-17ab-0073194ef5f8
|
||
fromColumn: 'План продаж по группам'.group_id
|
||
toColumn: Группы.group_id
|
||
|
||
relationship 13260857-b641-cb5b-b3cb-f14771c5cec6
|
||
fromColumn: 'mp узел'.Организация
|
||
toColumn: Организация.Организация
|
||
|
||
relationship AutoDetected_3bd74343-497b-4516-b07f-1d3c2d6b07b6
|
||
fromColumn: 'mp оборот'.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship AutoDetected_db8d1849-dfff-4593-996d-4891727f496d
|
||
fromColumn: 'mp оборот'.partner_id
|
||
toColumn: Партнер.partner_id
|
||
|
||
relationship a388dedc-5e84-5967-96df-b8bae5c33891
|
||
fromColumn: 'mp оборот'.Организация
|
||
toColumn: Организация.Организация
|
||
|
||
relationship 3522cb5a-7b9d-47a3-a469-1de50bbf8710
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'Заявки товары'.'Дата заявки'
|
||
toColumn: LocalDateTable_12048057-749b-4527-a84c-3bfdddefb196.Date
|
||
|
||
relationship c4bab963-e6e9-4780-94ae-395563167574
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'Заказы в заявках'.'Дата заказа поставщику'
|
||
toColumn: LocalDateTable_c6e09ca3-6b32-4ef4-9981-cfccc66408bb.Date
|
||
|
||
relationship 60a062fa-8c9f-406d-ad17-21e2ab4966fb
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'Заказы в заявках'.'Дата заявки'
|
||
toColumn: LocalDateTable_9ff62669-b1cd-4e6c-90bc-0932c77640cf.Date
|
||
|
||
relationship AutoDetected_f37395a5-fefa-4a45-b1b8-27a7ad07b137
|
||
fromColumn: 'Заявки товары'.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship AutoDetected_7e50e045-d012-49cb-9bd4-0802da84759b
|
||
fromColumn: 'Заказы в заявках'.artic_id
|
||
toColumn: Номенклатура._artic_id
|
||
|
||
relationship AutoDetected_c740691f-c101-408e-8bac-a1bd8cbfa744
|
||
fromColumn: 'Заказы в заявках'.partner_id
|
||
toColumn: Партнер.partner_id
|
||
|
||
relationship 8d64ceb3-2d4c-432b-bcbf-9e73a511289d
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'analytics forecast'.updated_at
|
||
toColumn: LocalDateTable_7e7e5dfb-3918-439e-8cc1-8e832260b631.Date
|
||
|
||
relationship f0a81b20-b81c-4f65-b1a2-44940e80218c
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'analytics forecast_scenarios'.created_at
|
||
toColumn: LocalDateTable_a1ea6953-1d69-4540-a3ab-b29c1d3c0a60.Date
|
||
|
||
relationship 645f96e0-961b-49fe-b9ab-646fda4d3f67
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'analytics deficit_proposal'.arrival_month
|
||
toColumn: LocalDateTable_77ac0133-c2c3-477c-931d-38bebcad53cd.Date
|
||
|
||
relationship 57ff9db4-7131-4b38-802f-ba3520d01a25
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'analytics deficit_proposal'.updated_at
|
||
toColumn: LocalDateTable_e417dbf0-bc70-40b8-93ec-6b96a6799c13.Date
|
||
|
||
relationship 13fa959e-e248-406c-8743-4ee4f03e64f8
|
||
fromColumn: 'analytics forecast'.scenario_id
|
||
toColumn: 'analytics forecast_scenarios'.scenario_id
|
||
|
||
annotation PBI_IsFromSource = FS
|
||
|
||
relationship 05a4eb39-1b0b-28c1-abeb-13800dc3087f
|
||
fromColumn: 'analytics forecast'.code
|
||
toColumn: Номенклатура.'Код УТ'
|
||
|
||
relationship 2b37dc63-4b3d-81df-fc51-296f04af605c
|
||
fromColumn: 'analytics deficit_proposal'.code
|
||
toColumn: Номенклатура.'Код УТ'
|
||
|
||
relationship 301e2973-c602-4399-8a7b-6e57c818f483
|
||
fromColumn: 'analytics manufacturer_payment_stage'.manufacturer_id
|
||
toColumn: 'analytics manufacturers'.id
|
||
|
||
annotation PBI_IsFromSource = FS
|
||
|
||
relationship 614748ad-7b07-6fbe-74d4-e4da296ff487
|
||
fromColumn: Номенклатура.Производитель
|
||
toColumn: 'analytics manufacturers'.manufacturer
|
||
|
||
relationship be16665c-6e35-421d-a938-614c9b5b4485
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: '.Календарь'.Дата
|
||
toColumn: LocalDateTable_e0374236-67f4-4331-b4f5-c977a3082bab.Date
|
||
|
||
relationship aeabbc3f-c05e-16a8-0814-e1504239b9c6
|
||
fromColumn: 'Стоимость МП'.Период
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship 8be1b23d-e487-097c-bcee-1a32b231c1dc
|
||
fromColumn: Себестоимость.Период
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship f67b410c-fe68-57c7-552d-861cd0a89a3e
|
||
fromColumn: 'Заявки на оплату'.'Дата оплаты план'
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship 5e52a163-909c-6b8d-25bc-b035e9ac2da8
|
||
fromColumn: 'План продаж менеджеров'.Период
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship dd599fe4-4d7d-02f0-ff23-c15949d273d6
|
||
fromColumn: 'mp остатки'.'Дата обновления'
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship a9aa002f-ecc1-626a-3629-1649907a88ac
|
||
fromColumn: 'mp аналитика продаж'.Дата
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship 60f5c804-9c9a-709a-3a69-c4fdd8d95032
|
||
fromColumn: ПРАЙСлист.Дата
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship 4f365827-f1a2-9c34-5415-efb3452f5951
|
||
fromColumn: 'Упущенные продажи'.Дата
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship c3cb1aca-d642-4ed3-d7a7-c54fe18f71d3
|
||
fromColumn: 'mp реклама'.Дата
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship f9bb46c5-d73a-2219-3f8a-07559a96a567
|
||
fromColumn: Закупки.Период
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship e27252e4-5020-94c9-42db-b3a63806f34f
|
||
fromColumn: Резервы.'Дата обновления'
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship 634101f5-71e4-2d48-7d90-832b057647a3
|
||
fromColumn: 'Я.Директ расходы'.Дата
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship d0083c1d-7d13-e893-6081-a9eeae7c53f0
|
||
fromColumn: 'mp оборот'.Дата
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship e0df2295-6306-91df-347c-cf171af14fa6
|
||
fromColumn: 'analytics forecast'.month
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship 4230e2ac-3f77-bc65-b188-79568279fa7f
|
||
fromColumn: 'analytics deficit_proposal'.place_month
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship d20515bb-7f05-a20e-e708-afcd394cbac0
|
||
fromColumn: 'analytics deficit_proposal'.scenario_id
|
||
toColumn: 'analytics forecast_scenarios'.scenario_id
|
||
|
||
relationship 8120413a-959d-4c3b-ab8a-b244f0d75965
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'analytics.DeficitWithAmount'.place_month
|
||
toColumn: LocalDateTable_8f36e812-d721-465e-862e-5fd099a7c61e.Date
|
||
|
||
relationship 583e0026-bdf5-4210-b1a3-abf75ac6ca64
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'analytics.DeficitWithAmount'.arrival_month
|
||
toColumn: LocalDateTable_ef722ff8-f6aa-45b8-910a-cceeaaab07a8.Date
|
||
|
||
relationship 14187cae-2c10-49f9-9690-b7b6790691ee
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'analytics.DeficitWithAmount'.updated_at
|
||
toColumn: LocalDateTable_412a89d8-5aff-45e5-aa52-1ff15a1aa314.Date
|
||
|
||
relationship 77e661c1-299a-4f20-a58c-e226f3ae045c
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'analytics.Реальные оплаты'.place_month
|
||
toColumn: LocalDateTable_5f6dc3da-6a29-40b4-acad-82e16902db2f.Date
|
||
|
||
relationship 2f08555e-2b99-4160-9e0a-cdb00e352d99
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'analytics.Реальные оплаты'.arrival_month
|
||
toColumn: LocalDateTable_e0151ce2-492d-4287-8527-f0bc571c1c52.Date
|
||
|
||
relationship b1077884-696f-460a-a236-4e4f063a6977
|
||
joinOnDateBehavior: datePartOnly
|
||
fromColumn: 'analytics.Реальные оплаты'.updated_at
|
||
toColumn: LocalDateTable_1587fe6c-4054-45e2-9900-7dfe1bfd059a.Date
|
||
|
||
relationship f924ec24-8196-06f3-df14-c43e43eda051
|
||
fromColumn: 'analytics.Реальные оплаты'.PaymentDate
|
||
toColumn: '.Календарь'.Дата
|
||
|
||
relationship 44d02e5b-7534-2b22-4acf-c7ac598e6e43
|
||
fromColumn: 'analytics.Реальные оплаты'.code
|
||
toColumn: Номенклатура.'Код УТ'
|
||
|
||
relationship b6fb1110-f839-92c1-f102-83c9c5f6fd84
|
||
fromColumn: 'analytics.Реальные оплаты'.scenario_id
|
||
toColumn: 'analytics forecast_scenarios'.scenario_id
|
||
|