{"id":9942,"date":"2025-10-29T09:59:43","date_gmt":"2025-10-29T08:59:43","guid":{"rendered":"https:\/\/pomoc.comarch.pl\/cee\/?post_type=ht_kb&#038;p=9942"},"modified":"2025-10-29T09:59:54","modified_gmt":"2025-10-29T08:59:54","slug":"tabela-wirtualna-zapytanie-o-dostepnosc","status":"publish","type":"ht_kb","link":"https:\/\/pomoc.comarch.pl\/cee\/index.php\/documentation\/tabela-wirtualna-zapytanie-o-dostepnosc\/","title":{"rendered":"Tabela wirtualna: Zapytanie o dost\u0119pno\u015b\u0107"},"content":{"rendered":"<h3 id=\"wprowadzenie\" >Wprowadzenie<\/h3>\n<p>Tabela wirtualna <em>Zapytanie o dost\u0119pno\u015b\u0107<\/em> okre\u015bla dost\u0119pne ilo\u015bci wybranych w\u0142a\u015bcicieli zapas\u00f3w dla wybranych artyku\u0142\u00f3w w wybranych lokalizacjach magazynowych w danym dniu.<\/p>\n<p>Tabela wirtualna stanowi podstaw\u0119 raportu <em>Zapytanie o dost\u0119pno\u015b\u0107 <\/em>(com.cisag.app.inventory.rpt.Availability) i jest z nim \u015bci\u015ble powi\u0105zana. Tabela wirtualna nie powinna by\u0107 u\u017cywana w innych raportach.<\/p>\n<h3 id=\"grupa-docelowa\" >Grupa docelowa<\/h3>\n<ul>\n<li>Konsultant<\/li>\n<li>Programi\u015bci<\/li>\n<\/ul>\n<h3 id=\"tabela-wirtualna-zapytanie-o-dostepnosc\" >Tabela wirtualna: Zapytanie o dost\u0119pno\u015b\u0107<\/h3>\n<h4 id=\"nazwa-tabeli\" >Nazwa tabeli<\/h4>\n<p>W raporcie tabela mo\u017ce by\u0107 adresowana przy u\u017cyciu nazwy<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">app_inventory_ItemAvailabilityTable<\/pre>\n<h4 id=\"kolumny-w-tabeli\" >Kolumny w tabeli<\/h4>\n<table style=\"border-collapse: collapse; width: 100%; height: 376px;\">\n<tbody>\n<tr style=\"height: 49px;\">\n<td style=\"width: 100%; height: 49px; border-style: outset;\" colspan=\"2\">\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">app_inventory_ItemAvailabilityTable<\/pre>\n<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"width: 50%; height: 27px; border-style: outset;\"><strong>Nazwa kolumny<\/strong><\/td>\n<td style=\"width: 50%; height: 27px; border-style: outset;\"><strong>Opis<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 50%; height: 23px; border-style: outset;\">in_owner<\/td>\n<td style=\"width: 50%; height: 23px; border-style: outset;\">Identyfikator partnera jako kryterium wyszukiwania w\u0142a\u015bciciela zapas\u00f3w.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 50%; height: 23px; border-style: outset;\">in_warehouse<\/td>\n<td style=\"width: 50%; height: 23px; border-style: outset;\">Identyfikator co najmniej jednej lokalizacji magazynu jako kryterium wyszukiwania lokalizacji magazynu.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 50%; height: 23px; border-style: outset;\">in_item<\/td>\n<td style=\"width: 50%; height: 23px; border-style: outset;\">Identyfikator artyku\u0142u jako kryterium wyszukiwania artyku\u0142u<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 50%; height: 23px; border-style: outset;\">in_availabilityRule<\/td>\n<td style=\"width: 50%; height: 23px; border-style: outset;\">Regu\u0142a dost\u0119pno\u015bci. Pole obowi\u0105zkowe.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 50%; height: 23px; border-style: outset;\">in_perDate<\/td>\n<td style=\"width: 50%; height: 23px; border-style: outset;\">Data, od kt\u00f3rej maj\u0105 by\u0107 obliczane dost\u0119pne ilo\u015bci. Pole obowi\u0105zkowe.<\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 50%; height: 24px; border-style: outset;\">owner<\/td>\n<td style=\"width: 50%; height: 24px; border-style: outset;\">Identyfikator GUID w\u0142a\u015bciciela magazynu.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 50%; height: 23px; border-style: outset;\">warehouse<\/td>\n<td style=\"width: 50%; height: 23px; border-style: outset;\">Identyfikator GUID miejsca przechowywania.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 50%; height: 23px; border-style: outset;\">item<\/td>\n<td style=\"width: 50%; height: 23px; border-style: outset;\">Identyfikator GUID pozycji.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 50%; height: 23px; border-style: outset;\">reserved<\/td>\n<td style=\"width: 50%; height: 23px; border-style: outset;\">Ilo\u015b\u0107 zarezerwowana.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 50%; height: 23px; border-style: outset;\">released<\/td>\n<td style=\"width: 50%; height: 23px; border-style: outset;\">Ilo\u015b\u0107 zwolniona.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 50%; height: 23px; border-style: outset;\">notReleased<\/td>\n<td style=\"width: 50%; height: 23px; border-style: outset;\">Ilo\u015b\u0107 niezwolniona (status: <em>Zablokowany<\/em>, <em>W kwarantannie<\/em>).<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 50%; height: 23px; border-style: outset;\">complete<\/td>\n<td style=\"width: 50%; height: 23px; border-style: outset;\">Ilo\u015b\u0107 ca\u0142kowitego bie\u017cacego zapasu.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 50%; height: 23px; border-style: outset;\">available<\/td>\n<td style=\"width: 50%; height: 23px; border-style: outset;\">Ilo\u015b\u0107 dost\u0119pna we wskazanym dniu.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"typ-bazy-danych\" >Typ bazy danych<\/h4>\n<p>Tabela wirtualna <em>Zapytanie o dost\u0119pno\u015b\u0107<\/em> jest dost\u0119pna w bazach danych typu OLTP.<\/p>\n<h4 id=\"uprawnienia\" >Uprawnienia<\/h4>\n<p>Nast\u0119puj\u0105ca jednostka biznesowa jest istotna dla tabeli wirtualnej <em>Zapytanie o dost\u0119pno\u015b\u0107<\/em><\/p>\n<p>Artyku\u0142 &#8211;\u00a0com.cisag.app.general.obj.Item<\/p>\n<p>Jednostka biznesowa nale\u017cy do nast\u0119puj\u0105cej grupy jednostek biznesowych:<\/p>\n<p>com.cisag.app.general.MasterData<\/p>\n","protected":false},"author":28,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"class_list":["post-9942","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-logistyka-magazynowa-wirtualne-tabele-i-funkcje"],"_links":{"self":[{"href":"https:\/\/pomoc.comarch.pl\/cee\/index.php\/wp-json\/wp\/v2\/ht_kb\/9942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pomoc.comarch.pl\/cee\/index.php\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/pomoc.comarch.pl\/cee\/index.php\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/pomoc.comarch.pl\/cee\/index.php\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/pomoc.comarch.pl\/cee\/index.php\/wp-json\/wp\/v2\/comments?post=9942"}],"version-history":[{"count":2,"href":"https:\/\/pomoc.comarch.pl\/cee\/index.php\/wp-json\/wp\/v2\/ht_kb\/9942\/revisions"}],"predecessor-version":[{"id":39642,"href":"https:\/\/pomoc.comarch.pl\/cee\/index.php\/wp-json\/wp\/v2\/ht_kb\/9942\/revisions\/39642"}],"wp:attachment":[{"href":"https:\/\/pomoc.comarch.pl\/cee\/index.php\/wp-json\/wp\/v2\/media?parent=9942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}