<style>
._code {
position: relative;
}
._navigator {
padding: 0;
}
._navigator ul {
list-style: none;
margin: 0;
padding: 0;
}
._navigator ul li {
padding: 2px 0;
}
ul._objects {
padding: 0;
list-style: none;
}
ul._objects li {
border-radius: 5px;
border: 1px solid #ccc;
padding: 15px 20px 10px;
background-color: #f5f5f5;
cursor: pointer;
position: relative;
margin-bottom: 20px;
}
ul._objects li:hover {
border-color: #666;
}
ul._objects h5 {
margin: 0;
}
._description {
margin-top: 10px;
font-style: italic;
color: #333;
}
._link {
background-image: url('http://wiki.latera.ru/s/en_GB/3143/5/4.1.5/_/download/resources/com.atlassian.plugins.editor:atlassian-rte-resources/toolbar-icons.png');
background-position: -48px top;
width: 16px;
height: 16px;
position: absolute;
right: 15px;
top: 15px;
border: 1px solid #ddd;
border-radius: 5px;
background-color: rgba(230, 230, 230, 0.3);
}
._link:hover {
border-color: #666;
background-color: rgba(200, 200, 200, 0.9);
}
._full_description {
padding-top: 20px;
cursor: default;
overflow-x: auto;
}
._full_description th {
font-weight: normal;
border-bottom: 1px solid #999 !important;
}
._full_description td, ._full_description th{
padding: 7px 5px;
border: 0;
border-collapse: collapse;
font-size: 11px;
}
._full_description tr:hover td {
background-color: white;
}
._code .added {
background-color: rgba(148,222,130,0.5);
}
._code .removed {
background-color: rgba(255, 145, 139, 0.6);
}
._code .changed {
background-color: rgba(255,216,2,0.4);
}
</style>
<script type="text/javascript">
jQuery(function() {
var path = document.location.hash;
if (path) {
var path = path.replace(/^#/, '').split('-');
if (path.length == 1) {
jQuery('[data-object="' + path[0] + '"]').show()
}
if (path.length == 2) {
// Find procedure
jQuery('[data-object="' + path[0] + '"][data-overload="' + path[1] + '"]').show()
}
}
});
</script>
<div class="_code">
<h1>Изменения API программных пакетов и представлений между версиями 4.1.2 и 4.1.3</h1>
<div style="margin-top: 20px;">
Легенда:
<span class="added">добавлено</span>,
<span class="changed">изменено</span>.
<span class="removed">удалено</span>.
</div>
<div>
<div class="_navigator">
<h4>Список объектов</h4>
<ul>
<li><a href='#AP_USER_OFFICE_PKG' title='Работа с личным кабинетом пользователя'>AP_USER_OFFICE_PKG</a></li>
<li><a href='#EX_PAYMENTS_PKG' title='Загрузка и обработка платежей из внешних систем'>EX_PAYMENTS_PKG</a></li>
<li><a href='#EX_PAYMENTS_PKG_S' title='Сервисный пакет для загрузки и обработки платежей из внешних систем'>EX_PAYMENTS_PKG_S</a></li>
<li><a href='#RP_PROFILES_PKG' title=''>RP_PROFILES_PKG</a></li>
<li><a href='#SD_BILLS_PKG' title=''>SD_BILLS_PKG</a></li>
<li><a href='#SD_INVOICES_PKG' title='Пакет для работы с инвойсами'>SD_INVOICES_PKG</a></li>
<li><a href='#SD_INVOICES_PKG_S' title='Сервисный пакет для работы с инвойсами'>SD_INVOICES_PKG_S</a></li>
<li><a href='#SD_OVERDRAFTS_PKG' title='Пакет для работы с актами выдачи кредитного лимита (АВКЛ)'>SD_OVERDRAFTS_PKG</a></li>
<li><a href='#SD_OVERDRAFTS_PKG_S' title='Сервисные функции для работы с кредитными лимитами'>SD_OVERDRAFTS_PKG_S</a></li>
<li><a href='#SI_DEVICES_PKG' title='Работа с сетевыми устройствами'>SI_DEVICES_PKG</a></li>
<li><a href='#SI_OBJECTS_PKG' title='Работа с объектами учета'>SI_OBJECTS_PKG</a></li>
<li><a href='#SI_REF_PKG_S' title=''>SI_REF_PKG_S</a></li>
<li><a href='#SI_SUBJECTS_PKG' title='Работа с субъектами учета'>SI_SUBJECTS_PKG</a></li>
<li><a href='#SI_SUBSCRIPTIONS_PKG' title='Работа с подписками и услугами'>SI_SUBSCRIPTIONS_PKG</a></li>
<li><a href='#SI_USERS_PKG' title='Работа с абонентами'>SI_USERS_PKG</a></li>
<li><a href='#SI_USERS_PKG_S' title='Сервисные функции для работы с абонентами и пользователями'>SI_USERS_PKG_S</a></li>
<li><a href='#SP_COMMANDS_PKG' title=''>SP_COMMANDS_PKG</a></li>
<li><a href='#STR_UTILS_PKG_S' title='Работа с символьными строками'>STR_UTILS_PKG_S</a></li>
<li><a href='#UTILS_PKG_S' title='Работа с различными утилитами'>UTILS_PKG_S</a></li>
<li><a href='#AP_V_USERS' title='Данные абонента'>AP_V_USERS</a></li>
<li><a href='#EP_V_SESSIONS' title='Sessions'>EP_V_SESSIONS</a></li>
<li><a href='#EP_V_SESSIONS_AND_CDRS' title='CDRs and sessions'>EP_V_SESSIONS_AND_CDRS</a></li>
<li><a href='#RG_V_SERV_STATUS' title='Представление регистра состояний услуг'>RG_V_SERV_STATUS</a></li>
<li><a href='#RPT_V_SESSIONS' title='Sessions report'>RPT_V_SESSIONS</a></li>
<li><a href='#RPT_V_SESSIONS_ARCH' title='Sessions report'>RPT_V_SESSIONS_ARCH</a></li>
<li><a href='#SD_V_CHARGE_LOGS' title=''>SD_V_CHARGE_LOGS</a></li>
<li><a href='#SD_V_PRICE_ORDERS_C' title='Состав общий'>SD_V_PRICE_ORDERS_C</a></li>
<li><a href='#SI_V_SUBSCRIPTIONS' title='Подписка абонентов на услуги'>SI_V_SUBSCRIPTIONS</a></li>
<li><a href='#SI_V_USER_GOODS' title='Подписка абонентов на услуги'>SI_V_USER_GOODS</a></li>
<li><a href='#SS_MV_QUICK_SEARCH' title=''>SS_MV_QUICK_SEARCH</a></li>
</ul>
</div>
<h2>Программные пакеты</h2>
<div>
<h2><a href="#AP_USER_OFFICE_PKG" name="AP_USER_OFFICE_PKG">AP_USER_OFFICE_PKG</a></h2>
<div class="_description">
Работа с личным кабинетом пользователя
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#AP_USER_OFFICE_PKG.DO_TARIFF_CHANGE-0" name="AP_USER_OFFICE_PKG.DO_TARIFF_CHANGE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE DO_TARIFF_CHANGE</h5>
<div class="_description">
Изменить подписку на услугу — тарифный план.
</div>
<div style="display: none;"
class="_full_description"
data-package="AP_USER_OFFICE_PKG"
data-subprogram="DO_TARIFF_CHANGE"
data-object="AP_USER_OFFICE_PKG.DO_TARIFF_CHANGE"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_SUBJ_GOOD_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Старая подписка</td>
</tr>
<tr class="">
<td>num_N_GOOD_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_GOOD_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Новый тарифный план</td>
</tr>
<tr class="">
<td>dt_D_CHANGE</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_BEGIN%TYPE</td>
<td>DATE</td>
<td>SYSDATE</td>
<td>Дата начала новой подписки</td>
</tr>
<tr class="">
<td>dt_D_INVOICE_END</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата окончания инвойса по новой подписке</td>
</tr>
<tr class="">
<td>b_CloseCurrentInvoice</td>
<td>IN</td>
<td>MAIN.BOOL</td>
<td>NUMBER</td>
<td>MAIN.b_FALSE</td>
<td>Флаг для закрытия действующего инвойса по старой подписке</td>
</tr>
<tr class="">
<td>b_ChangeImmediately</td>
<td>IN</td>
<td>MAIN.BOOL</td>
<td>NUMBER</td>
<td>MAIN.b_FALSE</td>
<td>Признак срочной смены тарифного плана</td>
</tr>
<tr class="added">
<td>b_UseSubscriptionBillingDay</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Использовать значение расчётного дня из предыдущей подписки</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="removed">
<a href="#AP_USER_OFFICE_PKG.CLOSE_TARIFF-0" name="AP_USER_OFFICE_PKG.CLOSE_TARIFF-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE CLOSE_TARIFF</h5>
<div class="_description">
Закрыть подписку на тариф.
</div>
<div style="display: none;"
class="_full_description"
data-package="AP_USER_OFFICE_PKG"
data-subprogram="CLOSE_TARIFF"
data-object="AP_USER_OFFICE_PKG.CLOSE_TARIFF"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_SUBJ_GOOD_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор подписки</td>
</tr>
<tr class="">
<td>dt_D_CLOSE</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_END%TYPE</td>
<td>DATE</td>
<td>SYSDATE</td>
<td>Дата закрытия подписки</td>
</tr>
<tr class="">
<td>b_CloseCurrentInvoice</td>
<td>IN</td>
<td>MAIN.BOOL</td>
<td>NUMBER</td>
<td>MAIN.b_FALSE</td>
<td>Флаг, определяющий, будет ли закрыт текущий инвойс по подписке</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#AP_USER_OFFICE_PKG.CHANGE_TARIFF-0" name="AP_USER_OFFICE_PKG.CHANGE_TARIFF-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION CHANGE_TARIFF</h5>
<div class="_description">
Изменить подписку на услугу — тарифный план.
</div>
<div style="display: none;"
class="_full_description"
data-package="AP_USER_OFFICE_PKG"
data-subprogram="CHANGE_TARIFF"
data-object="AP_USER_OFFICE_PKG.CHANGE_TARIFF"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_SUBJ_GOOD_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Старая подписка</td>
</tr>
<tr class="">
<td>num_N_GOOD_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_GOOD_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Новый тарифный план</td>
</tr>
<tr class="">
<td>dt_D_CHANGE</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_BEGIN%TYPE</td>
<td>DATE</td>
<td>SYSDATE</td>
<td>Дата начала новой подписки</td>
</tr>
<tr class="">
<td>dt_D_INVOICE_END</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата окончания инвойса по новой подписке</td>
</tr>
<tr class="">
<td>b_CloseCurrentInvoice</td>
<td>IN</td>
<td>MAIN.BOOL</td>
<td>NUMBER</td>
<td>MAIN.b_FALSE</td>
<td>Флаг для закрытия действующего инвойса по старой подписке</td>
</tr>
<tr class="">
<td>b_ChangeImmediately</td>
<td>IN</td>
<td>MAIN.BOOL</td>
<td>NUMBER</td>
<td>MAIN.b_FALSE</td>
<td>Признак срочной смены тарифного плана</td>
</tr>
<tr class="added">
<td>b_UseSubscriptionBillingDay</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Использовать значение расчётного дня из предыдущей подписки</td>
</tr>
<tr class="">
<td colspan="5">RETURN SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE</td>
<td>Подписка на новый тарифный план</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#AP_USER_OFFICE_PKG.SET_PROMISED_PAY-0" name="AP_USER_OFFICE_PKG.SET_PROMISED_PAY-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SET_PROMISED_PAY</h5>
<div class="_description">
Установить обещанный платеж.
</div>
<div style="display: none;"
class="_full_description"
data-package="AP_USER_OFFICE_PKG"
data-subprogram="SET_PROMISED_PAY"
data-object="AP_USER_OFFICE_PKG.SET_PROMISED_PAY"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_ACCOUNT_ID</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор лицевого счета</td>
</tr>
<tr class="added">
<td>num_N_PROMISED_PAY_SUM</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Сумма обещанного платежа</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#AP_USER_OFFICE_PKG.CUSTOMER_BY_LOGIN_AND_PHONE-0" name="AP_USER_OFFICE_PKG.CUSTOMER_BY_LOGIN_AND_PHONE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION CUSTOMER_BY_LOGIN_AND_PHONE</h5>
<div class="_description">
Find cutomer by login and phone number.
</div>
<div style="display: none;"
class="_full_description"
data-package="AP_USER_OFFICE_PKG"
data-subprogram="CUSTOMER_BY_LOGIN_AND_PHONE"
data-object="AP_USER_OFFICE_PKG.CUSTOMER_BY_LOGIN_AND_PHONE"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>vch_VC_LOGIN</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td>vch_VC_PHONE</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td colspan="5">RETURN SI_SUBJECTS.N_SUBJECT_ID%TYPE</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#AP_USER_OFFICE_PKG.RESET_PASSWORD-0" name="AP_USER_OFFICE_PKG.RESET_PASSWORD-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE RESET_PASSWORD</h5>
<div class="_description">
Reset customer cabinet password.
</div>
<div style="display: none;"
class="_full_description"
data-package="AP_USER_OFFICE_PKG"
data-subprogram="RESET_PASSWORD"
data-object="AP_USER_OFFICE_PKG.RESET_PASSWORD"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>vch_VC_LOGIN</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td>vch_VC_NEW_PASSWORD</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#EX_PAYMENTS_PKG" name="EX_PAYMENTS_PKG">EX_PAYMENTS_PKG</a></h2>
<div class="_description">
Загрузка и обработка платежей из внешних систем
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#EX_PAYMENTS_PKG.CREATE_AUTO_TOP_UP-0" name="EX_PAYMENTS_PKG.CREATE_AUTO_TOP_UP-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE CREATE_AUTO_TOP_UP</h5>
<div class="_description">
Create auto top up subscription by rule.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG"
data-subprogram="CREATE_AUTO_TOP_UP"
data-object="EX_PAYMENTS_PKG.CREATE_AUTO_TOP_UP"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_AUTO_TOP_UP_ID</td>
<td>OUT</td>
<td>SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>ID</td>
</tr>
<tr class="">
<td>num_N_DOC_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Payment order</td>
</tr>
<tr class="">
<td>num_N_RULE_ID</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.N_RULE_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Top up rule</td>
</tr>
<tr class="">
<td>num_N_AUTO_TOP_UP_TYPE_ID</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_TYPE_ID%TYPE</td>
<td>NUMBER</td>
<td>CONST.ATU_TYPE_CreditCard</td>
<td>Auto top up type</td>
</tr>
<tr class="">
<td>num_N_AUTO_TOP_UP_STATE_ID</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_STATE_ID%TYPE</td>
<td>NUMBER</td>
<td>CONST.ATU_STATE_Unverified</td>
<td>Auto top up state</td>
</tr>
<tr class="">
<td>num_N_TOP_UP_SUM</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.N_TOP_UP_SUM%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Top up amount</td>
</tr>
<tr class="">
<td>num_N_MIN_SUM</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.N_MIN_SUM%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Minimal amount</td>
</tr>
<tr class="">
<td>num_N_MAX_SUM</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.N_MAX_SUM%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Maximal amount</td>
</tr>
<tr class="">
<td>num_N_MAX_SUM_MONTHLY</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.N_MAX_SUM_MONTHLY%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Maximal amount per calendar month</td>
</tr>
<tr class="">
<td>num_N_MAX_TXNS_MONTHLY</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.N_MAX_TXNS_MONTHLY%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Maximal number of trapactions per calendar month</td>
</tr>
<tr class="">
<td>num_N_LOW_BALANCE_LIMIT</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.N_LOW_BALANCE_LIMIT%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Low-balance trigger</td>
</tr>
<tr class="">
<td>dt_D_TERMS_ACCEPTED</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.D_TERMS_ACCEPTED%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>When customer has accepted terms of service</td>
</tr>
<tr class="">
<td>vch_VC_TOKEN</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.VC_TOKEN%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Recurrent payment token</td>
</tr>
<tr class="">
<td>vch_VC_CARD_TYPE</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.VC_CARD_TYPE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Card type</td>
</tr>
<tr class="">
<td>vch_VC_TRUNCATED_PAN</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.VC_TRUNCATED_PAN%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Truncated PAN</td>
</tr>
<tr class="">
<td>dt_D_VALID_UNTIL</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.D_VALID_UNTIL%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Subscription expiration date</td>
</tr>
<tr class="added">
<td>vch_VC_EMAIL</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.VC_EMAIL%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Payer e-mail</td>
</tr>
<tr class="added">
<td>vch_VC_PHONE</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.VC_PHONE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Payer phone</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#EX_PAYMENTS_PKG.EX_PAYMENTS_CHANGE_DOC_STATE-0" name="EX_PAYMENTS_PKG.EX_PAYMENTS_CHANGE_DOC_STATE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE EX_PAYMENTS_CHANGE_DOC_STATE</h5>
<div class="_description">
Изменение состояния документа.
Используется в HPD.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG"
data-subprogram="EX_PAYMENTS_CHANGE_DOC_STATE"
data-object="EX_PAYMENTS_PKG.EX_PAYMENTS_CHANGE_DOC_STATE"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_DOC_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор документа</td>
</tr>
<tr class="">
<td>num_N_DOC_STATE_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_DOC_STATE_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор нового состояния</td>
</tr>
<tr class="">
<td>b_DisableTriggers</td>
<td>IN</td>
<td>MAIN.BOOL</td>
<td>NUMBER</td>
<td>MAIN.b_FALSE</td>
<td>Флаг отключения триггеров</td>
</tr>
<tr class="added">
<td>vch_VC_TRANSACTION_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TRANSACTION_ID%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Идентификатор транзакции</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#EX_PAYMENTS_PKG.LOAD_PAYMENTS_1C-0" name="EX_PAYMENTS_PKG.LOAD_PAYMENTS_1C-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE LOAD_PAYMENTS_1C</h5>
<div class="_description">
Массовая загрузка платежей из 1C. Внимание: информация о платежах должна быть в кодировке UTF-8.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG"
data-subprogram="LOAD_PAYMENTS_1C"
data-object="EX_PAYMENTS_PKG.LOAD_PAYMENTS_1C"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>clb_CL_PAYMENTS_DATA</td>
<td>IN</td>
<td>CLOB</td>
<td>CLOB</td>
<td></td>
<td>Входные данные</td>
</tr>
<tr class="">
<td>num_N_FIRM_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Фирма</td>
</tr>
<tr class="">
<td>num_N_DOC_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Банковская выписка</td>
</tr>
<tr class="">
<td>num_N_TAX_RATE_ID</td>
<td>IN</td>
<td>SI_REF.N_REF_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Ставка налога</td>
</tr>
<tr class="">
<td>num_N_CURRENCY_ID</td>
<td>IN</td>
<td>SI_REF.N_REF_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Валюта</td>
</tr>
<tr class="">
<td>num_N_PAY_TYPE_ID</td>
<td>IN</td>
<td>SI_REF.N_REF_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Тип платежа</td>
</tr>
<tr class="added">
<td>vch_VC_FILE_ENCODING</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Кодировка файла банковской выгрузки</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#EX_PAYMENTS_PKG_S" name="EX_PAYMENTS_PKG_S">EX_PAYMENTS_PKG_S</a></h2>
<div class="_description">
Сервисный пакет для загрузки и обработки платежей из внешних систем
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" style="cursor: default" class="added">
<a href="#EX_PAYMENTS_PKG_S.AUTO_TOP_UPS_INIT_CHARGES_TBL" name="EX_PAYMENTS_PKG_S.AUTO_TOP_UPS_INIT_CHARGES_TBL" class="_link" title="Ссылка на тип"></a>
<h5>TYPE AUTO_TOP_UPS_INIT_CHARGES_TBL PL/SQL TABLE</h5>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#EX_PAYMENTS_PKG_S.GET_ATU_INIT_CHARGES-0" name="EX_PAYMENTS_PKG_S.GET_ATU_INIT_CHARGES-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION GET_ATU_INIT_CHARGES</h5>
<div class="_description">
List of auto top ups found by initial payment doc id
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG_S"
data-subprogram="GET_ATU_INIT_CHARGES"
data-object="EX_PAYMENTS_PKG_S.GET_ATU_INIT_CHARGES"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_DOC_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Payment doc id</td>
</tr>
<tr class="">
<td colspan="5">RETURN AUTO_TOP_UPS_INIT_CHARGES_TBL</td>
<td>List of ATU.</td>
</tr>
<tr class="">
<td colspan="6">PIPELINED</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#EX_PAYMENTS_PKG_S.GET_PAYMENT_ID_BY_TXN_ID-0" name="EX_PAYMENTS_PKG_S.GET_PAYMENT_ID_BY_TXN_ID-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION GET_PAYMENT_ID_BY_TXN_ID</h5>
<div class="_description">
Подбор платежного поручения по платежным данным.
Используется в HPD.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG_S"
data-subprogram="GET_PAYMENT_ID_BY_TXN_ID"
data-object="EX_PAYMENTS_PKG_S.GET_PAYMENT_ID_BY_TXN_ID"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>vch_VC_TO_BANK</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TO_BANK%TYPE</td>
<td>VARCHAR2</td>
<td></td>
<td>Банк получателя</td>
</tr>
<tr class="">
<td>num_N_FORWHO_ACCOUNT_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_TO_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор счета «За кого»</td>
</tr>
<tr class="">
<td>vch_VC_TRANSACTION_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TRANSACTION_ID%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Идентификатор платежы</td>
</tr>
<tr class="">
<td>vch_VC_TRANSACTION_NO</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TRANSACTION_NO%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Номер платежа</td>
</tr>
<tr class="">
<td>num_N_SUM</td>
<td>IN</td>
<td>EX_PAYMENTS.N_SUM%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Сумма платежа</td>
</tr>
<tr class="">
<td>dt_D_TAKING</td>
<td>IN</td>
<td>EX_PAYMENTS.D_TAKG%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата поступления</td>
</tr>
<tr class="">
<td>num_N_TAKING_PERIOD</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Период поступления</td>
</tr>
<tr class="">
<td>vch_VC_FROM</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_FROM%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Наименования плательщика</td>
</tr>
<tr class="">
<td>vch_VC_FROM_BANK</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_FROM_BANK%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Банк плательщика</td>
</tr>
<tr class="">
<td>vch_VC_FROM_BANK_ACCOUNT</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_FROM_BANK_ACCOUNT%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Номер счета плательщика</td>
</tr>
<tr class="">
<td>vch_VC_TO</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TO%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Наименование получателя</td>
</tr>
<tr class="">
<td>num_N_LOOKUP_DOC_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Подбор по идентификатору документа</td>
</tr>
<tr class="">
<td colspan="5">RETURN EX_PAYMENTS.N_PAYMENT_ID%TYPE</td>
<td>Идентификатор платежа</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#EX_PAYMENTS_PKG_S.GET_ACCOUNT_AND_BANK_BY_NUMBER-0" name="EX_PAYMENTS_PKG_S.GET_ACCOUNT_AND_BANK_BY_NUMBER-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE GET_ACCOUNT_AND_BANK_BY_NUMBER</h5>
<div class="_description">
Get account and bank id by account number.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG_S"
data-subprogram="GET_ACCOUNT_AND_BANK_BY_NUMBER"
data-object="EX_PAYMENTS_PKG_S.GET_ACCOUNT_AND_BANK_BY_NUMBER"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>vch_VC_ACCOUNT</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.VC_ACCOUNT%TYPE</td>
<td>VARCHAR2</td>
<td></td>
<td>Account number</td>
</tr>
<tr class="">
<td>num_N_ACCOUNT_ID</td>
<td>OUT</td>
<td>SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Account</td>
</tr>
<tr class="">
<td>num_N_BANK_ID</td>
<td>OUT</td>
<td>SI_SUBJ_ACCOUNTS.N_BANK_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Bank</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#EX_PAYMENTS_PKG_S.GET_ADDITIONAL_ACCOUNT_INFO-0" name="EX_PAYMENTS_PKG_S.GET_ADDITIONAL_ACCOUNT_INFO-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE GET_ADDITIONAL_ACCOUNT_INFO</h5>
<div class="_description">
Get first name, second name and surname by account id.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG_S"
data-subprogram="GET_ADDITIONAL_ACCOUNT_INFO"
data-object="EX_PAYMENTS_PKG_S.GET_ADDITIONAL_ACCOUNT_INFO"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_ACCOUNT_ID</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Account id</td>
</tr>
<tr class="">
<td>vch_FirstName</td>
<td>OUT</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td></td>
<td>First name</td>
</tr>
<tr class="">
<td>vch_SecondName</td>
<td>OUT</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td></td>
<td>Patronymic</td>
</tr>
<tr class="">
<td>vch_Surname</td>
<td>OUT</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td></td>
<td>Surname</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#RP_PROFILES_PKG" name="RP_PROFILES_PKG">RP_PROFILES_PKG</a></h2>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#RP_PROFILES_PKG.TRY_SYNC_ALL_PROFILES-0" name="RP_PROFILES_PKG.TRY_SYNC_ALL_PROFILES-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION TRY_SYNC_ALL_PROFILES</h5>
<div class="_description">
Create and update all profiles by firm if time interval was changed.
</div>
<div style="display: none;"
class="_full_description"
data-package="RP_PROFILES_PKG"
data-subprogram="TRY_SYNC_ALL_PROFILES"
data-object="RP_PROFILES_PKG.TRY_SYNC_ALL_PROFILES"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_FIRM_ID</td>
<td>IN</td>
<td>SP_VERSIONS.N_FIRM_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Firm</td>
</tr>
<tr class="">
<td>ts_TS_START</td>
<td>IN</td>
<td>SP_VERSIONS.TS_START%TYPE</td>
<td>TIMESTAMP</td>
<td>SYSTIMESTAMP</td>
<td>Timestamp of start</td>
</tr>
<tr class="">
<td>num_N_BATCH_SIZE</td>
<td>IN</td>
<td>SP_VERSIONS.N_BATCH_SIZE%TYPE</td>
<td>NUMBER</td>
<td>5000</td>
<td>Size of batch</td>
</tr>
<tr class="added">
<td>dt_D_PREV_SYNC</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>NULL</td>
<td>Previous sync date</td>
</tr>
<tr class="">
<td colspan="5">RETURN SP_VERSIONS%ROWTYPE</td>
<td>Version</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#RP_PROFILES_PKG.RECREATE_FOR_CONTEXT-0" name="RP_PROFILES_PKG.RECREATE_FOR_CONTEXT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE RECREATE_FOR_CONTEXT</h5>
<div class="_description">
Re-generate all profiles for context.
</div>
<div style="display: none;"
class="_full_description"
data-package="RP_PROFILES_PKG"
data-subprogram="RECREATE_FOR_CONTEXT"
data-object="RP_PROFILES_PKG.RECREATE_FOR_CONTEXT"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>vch_VC_CONTEXT</td>
<td>IN</td>
<td>RP_PROFILES.VC_CONTEXT%TYPE</td>
<td>VARCHAR2</td>
<td></td>
<td>Context</td>
</tr>
<tr class="">
<td>ch_C_FL_GENERATE_COMMANDS</td>
<td>IN</td>
<td>SP_VERSIONS.C_FL_GENERATE_COMMANDS%TYPE</td>
<td>CHAR</td>
<td>'Y'</td>
<td>Generate commands on profile changes</td>
</tr>
<tr class="">
<td>ch_C_FL_SEND_PROFILES</td>
<td>IN</td>
<td>SP_VERSIONS.C_FL_SEND_PROFILES%TYPE</td>
<td>CHAR</td>
<td>'Y'</td>
<td>Send new profiles to a queue</td>
</tr>
<tr class="">
<td>b_DeleteProfiles</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Perform DELETE on profiles table</td>
</tr>
<tr class="added">
<td>b_SendRemoveCommand</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td>Send command for removing profiles into queue</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#RP_PROFILES_PKG.SYNC_ALL_PROFILES-0" name="RP_PROFILES_PKG.SYNC_ALL_PROFILES-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION SYNC_ALL_PROFILES</h5>
<div class="_description">
Create and update all profiles by firm.
</div>
<div style="display: none;"
class="_full_description"
data-package="RP_PROFILES_PKG"
data-subprogram="SYNC_ALL_PROFILES"
data-object="RP_PROFILES_PKG.SYNC_ALL_PROFILES"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_FIRM_ID</td>
<td>IN</td>
<td>SP_VERSIONS.N_FIRM_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Firm</td>
</tr>
<tr class="">
<td>ts_TS_START</td>
<td>IN</td>
<td>SP_VERSIONS.TS_START%TYPE</td>
<td>TIMESTAMP</td>
<td>SYSTIMESTAMP</td>
<td>Timestamp of start</td>
</tr>
<tr class="">
<td>num_N_BATCH_SIZE</td>
<td>IN</td>
<td>SP_VERSIONS.N_BATCH_SIZE%TYPE</td>
<td>NUMBER</td>
<td>5000</td>
<td>Size of batch</td>
</tr>
<tr class="added">
<td>dt_D_PREV_SYNC</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td colspan="5">RETURN SP_VERSIONS%ROWTYPE</td>
<td>Row of table SP_VERSIONS with created version</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#RP_PROFILES_PKG.RECREATE_FOR_EQUIPMENT-0" name="RP_PROFILES_PKG.RECREATE_FOR_EQUIPMENT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE RECREATE_FOR_EQUIPMENT</h5>
<div class="_description">
Re-generate all profiles for equipment.
</div>
<div style="display: none;"
class="_full_description"
data-package="RP_PROFILES_PKG"
data-subprogram="RECREATE_FOR_EQUIPMENT"
data-object="RP_PROFILES_PKG.RECREATE_FOR_EQUIPMENT"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_EQUIPMENT_ID</td>
<td>IN</td>
<td>RP_PROFILES.VC_CONTEXT%TYPE</td>
<td>VARCHAR2</td>
<td></td>
<td>Equipment</td>
</tr>
<tr class="">
<td>ch_C_FL_GENERATE_COMMANDS</td>
<td>IN</td>
<td>SP_VERSIONS.C_FL_GENERATE_COMMANDS%TYPE</td>
<td>CHAR</td>
<td>'Y'</td>
<td>Generate commands on profile changes</td>
</tr>
<tr class="">
<td>ch_C_FL_SEND_PROFILES</td>
<td>IN</td>
<td>SP_VERSIONS.C_FL_SEND_PROFILES%TYPE</td>
<td>CHAR</td>
<td>'Y'</td>
<td>Send new profiles to a queue</td>
</tr>
<tr class="">
<td>b_DeleteProfiles</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Perform DELETE on profiles table</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SD_BILLS_PKG" name="SD_BILLS_PKG">SD_BILLS_PKG</a></h2>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" style="cursor: default" class="added">
<a href="#SD_BILLS_PKG.RENDERED_SERVICES_TBL" name="SD_BILLS_PKG.RENDERED_SERVICES_TBL" class="_link" title="Ссылка на тип"></a>
<h5>TYPE RENDERED_SERVICES_TBL PL/SQL TABLE</h5>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SD_BILLS_PKG.SD_BILLS_CHANGE_STATE-0" name="SD_BILLS_PKG.SD_BILLS_CHANGE_STATE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SD_BILLS_CHANGE_STATE</h5>
<div class="_description">
Изменение состояния счета.
Внимание: вызов данной процедуры происходит только из SD_DOC_STATES_PKG.SD_DOCUMENTS_CHANGE_STATE.
Состояние документа реально переводится там, в данной процедуре производятся специфичные только для счета операции.
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_BILLS_PKG"
data-subprogram="SD_BILLS_CHANGE_STATE"
data-object="SD_BILLS_PKG.SD_BILLS_CHANGE_STATE"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_DOC_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор счета</td>
</tr>
<tr class="">
<td>num_N_Old_DOC_STATE_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_DOC_STATE_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Предыдущее состояние счета</td>
</tr>
<tr class="">
<td>num_N_New_DOC_STATE_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_DOC_STATE_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Новое состояние счета</td>
</tr>
<tr class="removed">
<td>b_DisableTriggers</td>
<td>IN</td>
<td>MAIN.BOOL</td>
<td>NUMBER</td>
<td>MAIN.b_FALSE</td>
<td>Флаг отмены срабатывания архивных тригеров</td>
</tr>
<tr class="added">
<td>b_DisableTriggers</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Флаг отмены срабатывания архивных тригеров</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SD_BILLS_PKG.SD_BILLS_CREATE-0" name="SD_BILLS_PKG.SD_BILLS_CREATE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SD_BILLS_CREATE</h5>
<div class="_description">
Формирование счетов.
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_BILLS_PKG"
data-subprogram="SD_BILLS_CREATE"
data-object="SD_BILLS_PKG.SD_BILLS_CREATE"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>dt_D_BEGIN</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td></td>
<td>Дата начала периода формирования</td>
</tr>
<tr class="">
<td>dt_D_END</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td></td>
<td>Дата окончания периода формирования</td>
</tr>
<tr class="">
<td>dt_D_BEGIN_AddServExclude</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата начала для исключения доп. услуг</td>
</tr>
<tr class="">
<td>dt_D_END_AddServExclude</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата окончания для исключения доп. услуг</td>
</tr>
<tr class="">
<td>num_N_FIRM_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_FIRM_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Фирма</td>
</tr>
<tr class="">
<td>num_N_FIRM_ACCOUNT_ID</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Счет фирмы</td>
</tr>
<tr class="">
<td>num_N_CONTRACT_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Абонентский договор на оказание услуг</td>
</tr>
<tr class="">
<td>num_N_BASE_SUBJ_TYPE_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_SUBJ_TYPE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Тип базового субъекта</td>
</tr>
<tr class="">
<td>num_N_USER_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Абонент</td>
</tr>
<tr class="">
<td>num_N_DOC_STATE_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_DOC_STATE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Состояние документа</td>
</tr>
<tr class="">
<td>dt_D_BILLS</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата формирования счетов</td>
</tr>
<tr class="removed">
<td>num_N_REPLACE_UNKNOWN_UNIT_ID</td>
<td>IN</td>
<td>SI_REF.N_REF_ID%TYPE</td>
<td>NUMBER</td>
<td>SS_CONSTANTS_PKG_S.UNIT_Piece</td>
<td>Единица измерения, заменяющая неуказанную единицу</td>
</tr>
<tr class="added">
<td>num_N_REPLACE_UNKNOWN_UNIT_ID</td>
<td>IN</td>
<td>SI_REF.N_REF_ID%TYPE</td>
<td>NUMBER</td>
<td>CONST.UNIT_Piece</td>
<td>Единица измерения, заменяющая неуказанную единицу</td>
</tr>
<tr class="">
<td>b_SplitContracts</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td>Признак группировки по договорам</td>
</tr>
<tr class="">
<td>b_SplitAccounts</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Признак группировки по счетам</td>
</tr>
<tr class="">
<td>b_SplitObjects</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Признак группировки по оборудованию</td>
</tr>
<tr class="">
<td>b_SeparateByObjects</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td></td>
</tr>
<tr class="">
<td>b_Actualize</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Признак актуализации сформированных счетов</td>
</tr>
<tr class="">
<td>b_OnlyNegativeBal</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Признак формирования счетов только для абонентов с отрицательным балансом</td>
</tr>
<tr class="">
<td>b_ConsiderAdvanceBills</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td></td>
</tr>
<tr class="">
<td>num_N_GOOD_ID</td>
<td>IN</td>
<td>SR_GOODS.N_GOOD_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Услуга/пакет услуг</td>
</tr>
<tr class="added">
<td>b_CommitEveryBill</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Фиксировать каждый созданный счет</td>
</tr>
<tr class="added">
<td>tbl_T_TAGS</td>
<td>IN</td>
<td>TAGS</td>
<td>TABLE</td>
<td>TAGS()</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SD_BILLS_PKG.SD_BILLS_PREPAYMENT_CREATE-0" name="SD_BILLS_PKG.SD_BILLS_PREPAYMENT_CREATE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION SD_BILLS_PREPAYMENT_CREATE</h5>
<div class="_description">
Формирование счета на предоплату.
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_BILLS_PKG"
data-subprogram="SD_BILLS_PREPAYMENT_CREATE"
data-object="SD_BILLS_PKG.SD_BILLS_PREPAYMENT_CREATE"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_FIRM_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_FIRM_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Фирма-поставщик</td>
</tr>
<tr class="">
<td>num_N_FIRM_ACCOUNT_ID</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Счет поставщика</td>
</tr>
<tr class="">
<td>num_N_CONTRACT_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Договор на оказание услуг</td>
</tr>
<tr class="">
<td>num_N_ACCOUNT_ID</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Лицевой счет</td>
</tr>
<tr class="">
<td>num_N_USER_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Абонент</td>
</tr>
<tr class="">
<td>num_N_GOOD_ID</td>
<td>IN</td>
<td>SR_GOODS.N_GOOD_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Услуга</td>
</tr>
<tr class="">
<td>dt_D_BILLS</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>SYSDATE</td>
<td>Дата счета</td>
</tr>
<tr class="">
<td>num_N_TAX_RATE_ID</td>
<td>IN</td>
<td>SI_REF.N_REF_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Ставка налога</td>
</tr>
<tr class="">
<td>num_N_CURRENCY_ID</td>
<td>IN</td>
<td>SI_REF.N_REF_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Валюта</td>
</tr>
<tr class="">
<td>num_N_SUM_WO_TAX</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Сумма без налога</td>
</tr>
<tr class="">
<td>num_N_SUM_TAX</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Сумма налога</td>
</tr>
<tr class="">
<td>num_N_SUM</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td></td>
<td>Сумма</td>
</tr>
<tr class="removed">
<td>b_Actualize</td>
<td>IN</td>
<td>MAIN.BOOL</td>
<td>NUMBER</td>
<td>MAIN.b_FALSE</td>
<td>Флаг для перевода счета в актуальное состояние</td>
</tr>
<tr class="added">
<td>b_Actualize</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Флаг для перевода счета в актуальное состояние</td>
</tr>
<tr class="">
<td colspan="5">RETURN SD_DOCUMENTS.N_DOC_ID%TYPE</td>
<td>Счет</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SD_BILLS_PKG.SD_BILLS_ADVANCE_CREATE-0" name="SD_BILLS_PKG.SD_BILLS_ADVANCE_CREATE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SD_BILLS_ADVANCE_CREATE</h5>
<div class="_description">
Формирование авансовых счетов.
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_BILLS_PKG"
data-subprogram="SD_BILLS_ADVANCE_CREATE"
data-object="SD_BILLS_PKG.SD_BILLS_ADVANCE_CREATE"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>dt_D_BEGIN</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td></td>
<td>Дата начала периода формирования</td>
</tr>
<tr class="">
<td>dt_D_END</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td></td>
<td>Дата окончания периода формирования</td>
</tr>
<tr class="">
<td>num_N_FIRM_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_FIRM_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Фирма</td>
</tr>
<tr class="">
<td>num_N_FIRM_ACCOUNT_ID</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Счет фирмы</td>
</tr>
<tr class="">
<td>num_N_CONTRACT_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Абонентский договор на оказание услуг</td>
</tr>
<tr class="">
<td>num_N_USER_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Абонент</td>
</tr>
<tr class="">
<td>num_N_SERVICE_ID</td>
<td>IN</td>
<td>SR_GOODS.N_GOOD_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Услуга</td>
</tr>
<tr class="">
<td>dt_D_BILLS</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата формирования счетов</td>
</tr>
<tr class="removed">
<td>num_N_REPLACE_UNKNOWN_UNIT_ID</td>
<td>IN</td>
<td>SI_REF.N_REF_ID%TYPE</td>
<td>NUMBER</td>
<td>SS_CONSTANTS_PKG_S.UNIT_Piece</td>
<td>Единица измерения, заменяющая неуказанную единицу</td>
</tr>
<tr class="added">
<td>num_N_REPLACE_UNKNOWN_UNIT_ID</td>
<td>IN</td>
<td>SI_REF.N_REF_ID%TYPE</td>
<td>NUMBER</td>
<td>CONST.UNIT_Piece</td>
<td>Единица измерения, заменяющая неуказанную единицу</td>
</tr>
<tr class="removed">
<td>b_SplitContracts</td>
<td>IN</td>
<td>MAIN.BOOL</td>
<td>NUMBER</td>
<td>MAIN.b_TRUE</td>
<td>Признак группировки по договорам</td>
</tr>
<tr class="added">
<td>b_SplitContracts</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td>Признак группировки по договорам</td>
</tr>
<tr class="removed">
<td>b_Actualize</td>
<td>IN</td>
<td>MAIN.BOOL</td>
<td>NUMBER</td>
<td>MAIN.b_FALSE</td>
<td>Признак актуализации сформированных счетов</td>
</tr>
<tr class="added">
<td>b_Actualize</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Признак актуализации сформированных счетов</td>
</tr>
<tr class="">
<td>num_N_MAX_COUNT</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Максимальное число формируемых счетов</td>
</tr>
<tr class="">
<td>b_SplitObjects</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Признак группировки по оборудованию</td>
</tr>
<tr class="">
<td>b_SeparateByObjects</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td>Разделение счетов по оборудованию</td>
</tr>
<tr class="added">
<td>tbl_T_TAGS</td>
<td>IN</td>
<td>TAGS</td>
<td>TABLE</td>
<td>TAGS()</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SD_BILLS_PKG.GET_RENDERED_SEVICES-0" name="SD_BILLS_PKG.GET_RENDERED_SEVICES-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION GET_RENDERED_SEVICES</h5>
<div class="_description">
Get cursor value.
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_BILLS_PKG"
data-subprogram="GET_RENDERED_SEVICES"
data-object="SD_BILLS_PKG.GET_RENDERED_SEVICES"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>dt_D_BEGIN</td>
<td>IN</td>
<td>SD_GOOD_MOVES.D_BEG%TYPE</td>
<td>DATE</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td>dt_D_END</td>
<td>IN</td>
<td>SD_GOOD_MOVES.D_END%TYPE</td>
<td>DATE</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td>num_N_SERVICE_ID</td>
<td>IN</td>
<td>SR_GOODS.N_GOOD_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td>num_N_DOC_STATE_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_DOC_STATE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td>b_SplitContracts</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td>b_SplitAccounts</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td>b_SplitObjects</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td>b_OnlyNegativeBal</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td colspan="5">RETURN RENDERED_SERVICES_TBL</td>
<td></td>
</tr>
<tr class="">
<td colspan="6">PIPELINED</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SD_INVOICES_PKG" name="SD_INVOICES_PKG">SD_INVOICES_PKG</a></h2>
<div class="_description">
Пакет для работы с инвойсами
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SD_INVOICES_PKG.SD_INVOICES_C_PUT-0" name="SD_INVOICES_PKG.SD_INVOICES_C_PUT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SD_INVOICES_C_PUT</h5>
<div class="_description">
Процедура для добавления/изменения строк в составе инвойса.
Если передается строка ПЦ, то при этом можно не передавать товар/услугу, ставку налога, единицы измерения,
валюту, цены и суммы — все это автоматически будет рассчитано на основании строки ПЦ.
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_INVOICES_PKG"
data-subprogram="SD_INVOICES_C_PUT"
data-object="SD_INVOICES_PKG.SD_INVOICES_C_PUT"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_LINE_ID</td>
<td>IN/OUT</td>
<td>SD_GOOD_MOVES.N_LINE_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор строки движения</td>
</tr>
<tr class="">
<td>num_N_DOC_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор документа</td>
</tr>
<tr class="">
<td>num_N_GOOD_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_GOOD_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор товара/услуги</td>
</tr>
<tr class="">
<td>num_N_MOVE_TYPE_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_MOVE_TYPE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор типа движения (справочник REF_TYPE_Good_Move_Type)</td>
</tr>
<tr class="">
<td>num_N_PAR_LINE_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_PAR_LINE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор родительской записи движения(например, пакет услуг)</td>
</tr>
<tr class="">
<td>num_N_UNIT_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_UNIT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор основной единицы измерения (справочники REF_TYPE_Measure_Unit, REF_TYPE_Unit_Time_Type, REF_TYPE_Unit_Data_Type, REF_TYPE_Unit_DataSpeed_Type)</td>
</tr>
<tr class="">
<td>num_N_QUANT</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_QUANT%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Количество в основных единицах</td>
</tr>
<tr class="">
<td>num_N_UNIT_BASE_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_UNIT_BASE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор базовой единицы измерения (справочники REF_TYPE_Measure_Unit, REF_TYPE_Unit_Time_Type, REF_TYPE_Unit_Data_Type, REF_TYPE_Unit_DataSpeed_Type)</td>
</tr>
<tr class="">
<td>num_N_QUANT_BASE</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_QUANT_BASE%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Количество в базовых единицах</td>
</tr>
<tr class="">
<td>num_N_TAX_RATE_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_TAX_RATE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор налоговой ставки (справочник REF_TYPE_TAX_Rates)</td>
</tr>
<tr class="">
<td>num_N_CURRENCY_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_CURRENCY_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор валюты (справочник REF_TYPE_Currency)</td>
</tr>
<tr class="">
<td>num_N_PRICE</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_PRICE%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Цена с налогами</td>
</tr>
<tr class="">
<td>num_N_PRICE_WO_TAX</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_PRICE_WO_TAX%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Цена без налогов</td>
</tr>
<tr class="">
<td>num_N_BASE_SUM</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_BASE_SUM%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Сумма без скидки</td>
</tr>
<tr class="">
<td>num_N_BASE_SUM_WO_TAX</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_BASE_SUM_WO_TAX%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Сумма без скидки и без налогов</td>
</tr>
<tr class="">
<td>num_N_DISCOUNT_CERT_LINE_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_DISCOUNT_CERT_LINE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Строка акта предоставления скидки</td>
</tr>
<tr class="">
<td>num_N_SUM_WO_TAX</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_SUM_WO_TAX%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Сумма без налогов</td>
</tr>
<tr class="">
<td>num_N_SUM_TAX</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_SUM_TAX%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Сумма налогов</td>
</tr>
<tr class="">
<td>num_N_SUM</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_SUM%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Сумма с налогами</td>
</tr>
<tr class="">
<td>num_N_OBJECT_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_OBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор объекта/службы (где оказывается услуга)</td>
</tr>
<tr class="">
<td>num_N_LINE_NO</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_LINE_NO%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Порядковый номер</td>
</tr>
<tr class="">
<td>dt_D_BEGIN</td>
<td>IN</td>
<td>SD_GOOD_MOVES.D_BEGIN%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата начала оказания услуги</td>
</tr>
<tr class="">
<td>dt_D_END</td>
<td>IN</td>
<td>SD_GOOD_MOVES.D_END%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата окончания оказания услуги</td>
</tr>
<tr class="">
<td>dt_D_OPER</td>
<td>IN</td>
<td>SD_GOOD_MOVES.D_OPER%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата операции(в инвойсах это дата списания), дата по которой ведется балансовый учет</td>
</tr>
<tr class="">
<td>vch_VC_REM</td>
<td>IN</td>
<td>SD_GOOD_MOVES.VC_REM%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Комментарий</td>
</tr>
<tr class="">
<td>num_N_PRICE_LINE_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_PRICE_LINE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор строки ПЦ, согласно которому произошла тарификация услуги/товара</td>
</tr>
<tr class="">
<td>num_N_ADDRESS_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_ADDRESS_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор адреса(номер телефона, IP-адрес и др.)</td>
</tr>
<tr class="">
<td>num_N_BASE_LINE_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_BASE_LINE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор базовой строки движения (используется в случае, если одно движение нельзя представить одной строкой, например, части этого движения проходят по разной цене)</td>
</tr>
<tr class="">
<td>num_N_SUBJ_GOOD_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_SUBJ_GOOD_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор подписки на услуги, согласно которой было вызвано это движение</td>
</tr>
<tr class="">
<td>num_N_PROVISION_RULE_ID</td>
<td>IN</td>
<td>SR_PROVISION_RULES.N_PROVISION_RULE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="added">
<td>dt_D_PROVISION_BEGIN</td>
<td>IN</td>
<td>SD_GOOD_MOVES.D_PROVISION_BEGIN%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата начала оказания услуги в рамках инвойса</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SD_INVOICES_PKG_S" name="SD_INVOICES_PKG_S">SD_INVOICES_PKG_S</a></h2>
<div class="_description">
Сервисный пакет для работы с инвойсами
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SD_INVOICES_PKG_S.IS_NONPAY_SUSPENSION_CL-0" name="SD_INVOICES_PKG_S.IS_NONPAY_SUSPENSION_CL-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION IS_NONPAY_SUSPENSION_CL</h5>
<div class="_description">
Check if charge log is for nonpayment suspension
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_INVOICES_PKG_S"
data-subprogram="IS_NONPAY_SUSPENSION_CL"
data-object="SD_INVOICES_PKG_S.IS_NONPAY_SUSPENSION_CL"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_DOC_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES_T.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Charge log</td>
</tr>
<tr class="">
<td colspan="5">RETURN CONST.BOOL</td>
<td>Boolean result</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SD_OVERDRAFTS_PKG" name="SD_OVERDRAFTS_PKG">SD_OVERDRAFTS_PKG</a></h2>
<div class="_description">
Пакет для работы с актами выдачи кредитного лимита (АВКЛ)
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SD_OVERDRAFTS_PKG.CLOSE_OVERDRAFT_BY_CONTRACT-0" name="SD_OVERDRAFTS_PKG.CLOSE_OVERDRAFT_BY_CONTRACT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE CLOSE_OVERDRAFT_BY_CONTRACT</h5>
<div class="_description">
Закрытие действующего кредитного лимита по договору.
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_OVERDRAFTS_PKG"
data-subprogram="CLOSE_OVERDRAFT_BY_CONTRACT"
data-object="SD_OVERDRAFTS_PKG.CLOSE_OVERDRAFT_BY_CONTRACT"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_CONTRACT_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Договор</td>
</tr>
<tr class="">
<td>dt_D_END</td>
<td>IN</td>
<td>RG_OVERDRAFTS.D_END%TYPE</td>
<td>DATE</td>
<td></td>
<td>Дата закрытия</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SD_OVERDRAFTS_PKG_S" name="SD_OVERDRAFTS_PKG_S">SD_OVERDRAFTS_PKG_S</a></h2>
<div class="_description">
Сервисные функции для работы с кредитными лимитами
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SD_OVERDRAFTS_PKG_S.TOTAL_CREDIT_LIMIT" name="SD_OVERDRAFTS_PKG_S.TOTAL_CREDIT_LIMIT" class="_link" title="Ссылка на тип"></a>
<h5>TYPE TOTAL_CREDIT_LIMIT PL/SQL RECORD</h5>
<div class="_description">
Amount of all credit limits.
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_OVERDRAFTS_PKG_S"
data-type="TOTAL_CREDIT_LIMIT"
data-object="SD_OVERDRAFTS_PKG_S.TOTAL_CREDIT_LIMIT"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Название поля</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>N_ACCOUNT_ID</td>
<td>SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td>Account</td>
</tr>
<tr class="">
<td>N_SUM</td>
<td>SD_OVERDRAFTS.N_SUM%TYPE</td>
<td>NUMBER</td>
<td>Amount</td>
</tr>
<tr class="">
<td>D_END</td>
<td>SD_OVERDRAFTS.D_END%TYPE</td>
<td>DATE</td>
<td>End date</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" style="cursor: default" class="added">
<a href="#SD_OVERDRAFTS_PKG_S.TOTAL_CREDIT_LIMIT_ROWS" name="SD_OVERDRAFTS_PKG_S.TOTAL_CREDIT_LIMIT_ROWS" class="_link" title="Ссылка на тип"></a>
<h5>TYPE TOTAL_CREDIT_LIMIT_ROWS PL/SQL TABLE</h5>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SD_OVERDRAFTS_PKG_S.GET_TOTAL_CREDIT_LIMIT-0" name="SD_OVERDRAFTS_PKG_S.GET_TOTAL_CREDIT_LIMIT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION GET_TOTAL_CREDIT_LIMIT</h5>
<div class="_description">
Amount of all credit limits.
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_OVERDRAFTS_PKG_S"
data-subprogram="GET_TOTAL_CREDIT_LIMIT"
data-object="SD_OVERDRAFTS_PKG_S.GET_TOTAL_CREDIT_LIMIT"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_ACCOUNT_ID</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Account</td>
</tr>
<tr class="">
<td colspan="5">RETURN TOTAL_CREDIT_LIMIT_ROWS</td>
<td></td>
</tr>
<tr class="">
<td colspan="6">PIPELINED</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SI_DEVICES_PKG" name="SI_DEVICES_PKG">SI_DEVICES_PKG</a></h2>
<div class="_description">
Работа с сетевыми устройствами
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SI_DEVICES_PKG.SI_DEVICES_PUT-0" name="SI_DEVICES_PKG.SI_DEVICES_PUT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SI_DEVICES_PUT</h5>
<div class="_description">
Изменение или добавление записи об активном оборудовании.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_DEVICES_PKG"
data-subprogram="SI_DEVICES_PUT"
data-object="SI_DEVICES_PKG.SI_DEVICES_PUT"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_OBJECT_ID</td>
<td>IN/OUT</td>
<td>SI_OBJECTS.N_OBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Оборудование</td>
</tr>
<tr class="">
<td>num_N_GOOD_ID</td>
<td>IN</td>
<td>SI_OBJECTS.N_GOOD_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Позиция номенклатуры</td>
</tr>
<tr class="">
<td>vch_VC_NAME</td>
<td>IN</td>
<td>SI_OBJECTS.VC_NAME%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Наименование</td>
</tr>
<tr class="">
<td>vch_VC_CODE</td>
<td>IN</td>
<td>SI_OBJECTS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Краткое наименование (код)</td>
</tr>
<tr class="removed">
<td>num_N_FIRM_ID</td>
<td>IN</td>
<td>SI_OBJECTS.N_FIRM_ID%TYPE</td>
<td>NUMBER</td>
<td>MAIN.GET_N_OWNER_ID</td>
<td>Фирма</td>
</tr>
<tr class="added">
<td>num_N_FIRM_ID</td>
<td>IN</td>
<td>SI_OBJECTS.N_FIRM_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Фирма</td>
</tr>
<tr class="">
<td>vch_VC_CODE_ADD</td>
<td>IN</td>
<td>SI_OBJECTS.VC_CODE_ADD%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Дополнительный код</td>
</tr>
<tr class="">
<td>vch_VC_REM</td>
<td>IN</td>
<td>SI_OBJECTS.VC_REM%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Комментарий</td>
</tr>
<tr class="">
<td>vch_VC_SERIAL</td>
<td>IN</td>
<td>SI_OBJECTS.VC_SERIAL%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Серийный номер</td>
</tr>
<tr class="">
<td>vch_VC_INV_NO</td>
<td>IN</td>
<td>SI_OBJECTS.VC_INV_NO%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Инвентарный номер</td>
</tr>
<tr class="">
<td>dt_D_WARRANTY_TILL</td>
<td>IN</td>
<td>SI_OBJECTS.D_WARRANTY_TILL%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата окончания гарантии</td>
</tr>
<tr class="">
<td>num_N_OWNER_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Владелец</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SI_OBJECTS_PKG" name="SI_OBJECTS_PKG">SI_OBJECTS_PKG</a></h2>
<div class="_description">
Работа с объектами учета
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SI_OBJECTS_PKG.SI_OBJECTS_PUT-0" name="SI_OBJECTS_PKG.SI_OBJECTS_PUT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SI_OBJECTS_PUT</h5>
<div class="_description">
Добавление/изменение записи об объекте учета.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_OBJECTS_PKG"
data-subprogram="SI_OBJECTS_PUT"
data-object="SI_OBJECTS_PKG.SI_OBJECTS_PUT"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_OBJECT_ID</td>
<td>IN/OUT</td>
<td>SI_OBJECTS.N_OBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор ОУ</td>
</tr>
<tr class="">
<td>num_N_BOUND_OBJECT_ID</td>
<td>IN</td>
<td>SI_OBJECTS.N_OBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Привязанный ОУ (для формирования кода)</td>
</tr>
<tr class="">
<td>num_N_GOOD_ID</td>
<td>IN</td>
<td>SI_OBJECTS.N_GOOD_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Тип ОУ (позиция номенклатуры)</td>
</tr>
<tr class="">
<td>vch_VC_NAME</td>
<td>IN</td>
<td>SI_OBJECTS.VC_NAME%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Наименование</td>
</tr>
<tr class="">
<td>vch_VC_CODE</td>
<td>IN</td>
<td>SI_OBJECTS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Код</td>
</tr>
<tr class="removed">
<td>num_N_FIRM_ID</td>
<td>IN</td>
<td>SI_OBJECTS.N_FIRM_ID%TYPE</td>
<td>NUMBER</td>
<td>SYS_CONTEXT('MAIN' 'N_FIRM_ID')</td>
<td>Фирма</td>
</tr>
<tr class="added">
<td>num_N_FIRM_ID</td>
<td>IN</td>
<td>SI_OBJECTS.N_FIRM_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Фирма</td>
</tr>
<tr class="">
<td>vch_VC_CODE_ADD</td>
<td>IN</td>
<td>SI_OBJECTS.VC_CODE_ADD%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Дополнительный код</td>
</tr>
<tr class="">
<td>vch_VC_REM</td>
<td>IN</td>
<td>SI_OBJECTS.VC_REM%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Примечание</td>
</tr>
<tr class="">
<td>vch_VC_SERIAL</td>
<td>IN</td>
<td>SI_OBJECTS.VC_SERIAL%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Серийный номер</td>
</tr>
<tr class="">
<td>vch_VC_INV_NO</td>
<td>IN</td>
<td>SI_OBJECTS.VC_INV_NO%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Инвентарный номер</td>
</tr>
<tr class="">
<td>dt_D_WARRANTY_TILL</td>
<td>IN</td>
<td>SI_OBJECTS.D_WARRANTY_TILL%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата окончания гарантийного срока</td>
</tr>
<tr class="">
<td>num_N_OWNER_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Владелец (СУ)</td>
</tr>
<tr class="">
<td>num_N_SCN</td>
<td>IN</td>
<td>SI_OBJECTS.N_SCN%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Версия</td>
</tr>
<tr class="">
<td>num_N_MAIN_OBJECT_ID</td>
<td>IN</td>
<td>SI_OBJECTS.N_MAIN_OBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Основной ОУ</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SI_REF_PKG_S" name="SI_REF_PKG_S">SI_REF_PKG_S</a></h2>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SI_REF_PKG_S.GET_VC_VALUE_FOR_REGION-0" name="SI_REF_PKG_S.GET_VC_VALUE_FOR_REGION-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION GET_VC_VALUE_FOR_REGION</h5>
<div class="_description">
Возвратить строковое значение справочной величины для регионов.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_REF_PKG_S"
data-subprogram="GET_VC_VALUE_FOR_REGION"
data-object="SI_REF_PKG_S.GET_VC_VALUE_FOR_REGION"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_REF_ID</td>
<td>IN</td>
<td>SI_REF.N_REF_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Справочное значение</td>
</tr>
<tr class="">
<td>num_N_LANG_ID</td>
<td>IN</td>
<td>SI_REF.N_LANG_ID%TYPE</td>
<td>NUMBER</td>
<td>SYS_CONTEXT('MAIN' 'N_LANG_ID')</td>
<td>Язык</td>
</tr>
<tr class="">
<td colspan="5">RETURN SI_REF.VC_VALUE%TYPE</td>
<td>Строковое значение</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SI_SUBJECTS_PKG" name="SI_SUBJECTS_PKG">SI_SUBJECTS_PKG</a></h2>
<div class="_description">
Работа с субъектами учета
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SI_SUBJECTS_PKG.PUT_SUBJ_VALUE-0" name="SI_SUBJECTS_PKG.PUT_SUBJ_VALUE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE PUT_SUBJ_VALUE</h5>
<div class="_description">
Универсальная процедура для работы с дополнительными параметрами СУ.
Внимание: процедура не расчитана на работу со множественными параметрами.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_SUBJECTS_PKG"
data-subprogram="PUT_SUBJ_VALUE"
data-object="SI_SUBJECTS_PKG.PUT_SUBJ_VALUE"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_SUBJECT_ID</td>
<td>IN</td>
<td>SI_SUBJ_VALUES.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Субъект</td>
</tr>
<tr class="">
<td>num_N_SUBJ_VALUE_TYPE_ID</td>
<td>IN</td>
<td>SI_SUBJ_VALUES.N_SUBJ_VALUE_TYPE_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Тип дополнительного параметра</td>
</tr>
<tr class="">
<td>dt_D_VALUE</td>
<td>IN</td>
<td>SI_SUBJ_VALUES.D_VALUE%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Датавременное значение</td>
</tr>
<tr class="">
<td>ch_C_VALUE</td>
<td>IN</td>
<td>SI_SUBJ_VALUES.C_VALUE%TYPE</td>
<td>CHAR</td>
<td>NULL</td>
<td>Символьное значение</td>
</tr>
<tr class="">
<td>vch_VC_VALUE</td>
<td>IN</td>
<td>SI_SUBJ_VALUES.VC_VALUE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Строковое значение</td>
</tr>
<tr class="">
<td>num_N_VALUE</td>
<td>IN</td>
<td>SI_SUBJ_VALUES.N_VALUE%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Числовое значение</td>
</tr>
<tr class="">
<td>ch_C_FL_VALUE</td>
<td>IN</td>
<td>SI_SUBJ_VALUES.C_FL_VALUE%TYPE</td>
<td>CHAR</td>
<td>NULL</td>
<td>Флаговое значение</td>
</tr>
<tr class="">
<td>num_N_REF_ID</td>
<td>IN</td>
<td>SI_SUBJ_VALUES.N_REF_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Справочное значение</td>
</tr>
<tr class="">
<td>clb_CL_VALUE</td>
<td>IN</td>
<td>SI_SUBJ_VALUES.CL_VALUE%TYPE</td>
<td>CLOB</td>
<td>NULL</td>
<td>Текстовое значение</td>
</tr>
<tr class="added">
<td>num_N_SCN</td>
<td>IN</td>
<td>SI_SUBJ_VALUES.N_SCN%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>SCN</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SI_SUBSCRIPTIONS_PKG" name="SI_SUBSCRIPTIONS_PKG">SI_SUBSCRIPTIONS_PKG</a></h2>
<div class="_description">
Работа с подписками и услугами
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SI_SUBSCRIPTIONS_PKG.SI_SUBSCRIPTIONS_PUT-0" name="SI_SUBSCRIPTIONS_PKG.SI_SUBSCRIPTIONS_PUT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SI_SUBSCRIPTIONS_PUT</h5>
<div class="_description">
Create or update service subscription.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_SUBSCRIPTIONS_PKG"
data-subprogram="SI_SUBSCRIPTIONS_PUT"
data-object="SI_SUBSCRIPTIONS_PKG.SI_SUBSCRIPTIONS_PUT"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_SUBSCRIPTION_ID</td>
<td>IN/OUT</td>
<td>SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Subscription id</td>
</tr>
<tr class="">
<td>num_N_SERVICE_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_SERVICE_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Service</td>
</tr>
<tr class="">
<td>num_N_CUSTOMER_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Customer</td>
</tr>
<tr class="">
<td>num_N_ACCOUNT_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Account</td>
</tr>
<tr class="">
<td>num_N_OBJECT_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_OBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Equipment</td>
</tr>
<tr class="">
<td>num_N_PAY_DAY</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_BILLING_DAY%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Pay day</td>
</tr>
<tr class="">
<td>num_N_LINE_NO</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_LINE_NO%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Customer subscriptions line no</td>
</tr>
<tr class="">
<td>num_N_QUANT</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_QUANT%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Quantity</td>
</tr>
<tr class="">
<td>num_N_UNIT_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_UNIT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Measurement unit (SI_V_UNITS)</td>
</tr>
<tr class="">
<td>num_N_DOC_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Contract</td>
</tr>
<tr class="">
<td>num_N_PAR_SUBSCRIPTION_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_PAR_SUBSCRIPTION_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Parent subscription row</td>
</tr>
<tr class="removed">
<td>num_N_RENDER_CONDITIONS_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_RENDER_CONDITIONS_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Service rendering conditions (REF_TYPE_ServRenderCond)</td>
</tr>
<tr class="">
<td>dt_D_BEGIN</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_BEGIN%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Subscription begin date</td>
</tr>
<tr class="">
<td>dt_D_END</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_END%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Subscription end date</td>
</tr>
<tr class="">
<td>dt_D_INVOICE_END</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Next charge log end date</td>
</tr>
<tr class="">
<td>num_N_PREV_SUBSCRIPTION_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_PREV_SUBSCRIPTION_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Previous subscription</td>
</tr>
<tr class="">
<td>b_EvaluateDiscounts</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td>Analyze and provide discounts</td>
</tr>
<tr class="">
<td>b_FilterByContext</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Use current user from context to restrict available services.<br/>By default: yes if context is not empty (N_USER_ID is not null)</td>
</tr>
<tr class="">
<td>b_RecreateOnUpdate</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td>Recreate subscription instead update</td>
</tr>
<tr class="added">
<td>b_UseMaterializedView</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td>Use materialized view</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SI_USERS_PKG" name="SI_USERS_PKG">SI_USERS_PKG</a></h2>
<div class="_description">
Работа с абонентами
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SI_USERS_PKG.CHANGE_TARIFF-1" name="SI_USERS_PKG.CHANGE_TARIFF-1" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION CHANGE_TARIFF</h5>
<div class="_description">
Смена существующего тарифного плана в подписке.
Если по подписке нет инвойсов и ее изменение производится текущей датой или датой в прошлом,
изменяются параметры этой же подписки, в противном случае создается новая подписка, а для
текущей устанавливается дата окончания.
Если тариф меняется на временную блокировку, то добавляется параллельная подписка, старая не закрывается.
Если выставлен специальный флаг b_CloseCurrentInvoice, то:
1) при закрытии подписки закрывается по ней и инвойс этой же датой;
2) при смене подписки на временную блокировку закрываем инвойсы по всем блокированным подпискам, а не только по той, по которой проводили смену;
3) запускаем процедуру предвыставления инвойсов по новой подписке.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_USERS_PKG"
data-subprogram="CHANGE_TARIFF"
data-object="SI_USERS_PKG.CHANGE_TARIFF"
data-overload="1"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_SUBJ_GOOD_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор существуюшей строки подписки на тарифный план</td>
</tr>
<tr class="">
<td>num_N_GOOD_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_GOOD_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор нового тарифного плана</td>
</tr>
<tr class="">
<td>dt_D_CHANGE</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_BEGIN%TYPE</td>
<td>DATE</td>
<td>SYSDATE</td>
<td>Дата, с которой должна начаться новая подписка (по умолчанию текущая дата)</td>
</tr>
<tr class="">
<td>dt_D_INVOICE_END</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата закрытия инвойса по новой подписке.<br/>Если же происходит смена на временную блокировку, то для подписки на нее<br/>дата окончания также выставляется в dt_D_INVOICE_END</td>
</tr>
<tr class="">
<td>num_N_BILLING_DAY</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_BILLING_DAY%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Расчетный день. Если не передан, то берется из предыдущей подписки</td>
</tr>
<tr class="">
<td>b_CloseCurrentInvoice</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Флаг закрытия инвойса по текущей подписке:<br/>{*} 0 — не закрывать текущий инвойс<br/>{*} 1 — закрыть текущий инвойс</td>
</tr>
<tr class="added">
<td>b_UseSubscriptionBillingDay</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Использовать значение расчётного дня из предыдущей подписки</td>
</tr>
<tr class="">
<td colspan="5">RETURN SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE</td>
<td>Идентификатор подписки с новым тарифным планом</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SI_USERS_PKG.CHANGE_TARIFF-2" name="SI_USERS_PKG.CHANGE_TARIFF-2" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE CHANGE_TARIFF</h5>
<div class="_description">
Аналог функции CHANGE_TARIFF.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_USERS_PKG"
data-subprogram="CHANGE_TARIFF"
data-object="SI_USERS_PKG.CHANGE_TARIFF"
data-overload="2"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_SUBJ_GOOD_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор существуюшей строки подписки на тарифный план</td>
</tr>
<tr class="">
<td>num_N_GOOD_ID</td>
<td>IN</td>
<td>SD_GOOD_MOVES.N_GOOD_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор нового тарифного плана</td>
</tr>
<tr class="">
<td>dt_D_CHANGE</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_BEGIN%TYPE</td>
<td>DATE</td>
<td>SYSDATE</td>
<td>Дата, с которой должна начаться новая подписка (по умолчанию текущая дата)</td>
</tr>
<tr class="">
<td>dt_D_INVOICE_END</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата закрытия инвойса по новой подписке.<br/>Если же происходит смена на временную блокировку, то для подписки на нее<br/>дата окончания также выставляется в dt_D_INVOICE_END</td>
</tr>
<tr class="">
<td>num_N_BILLING_DAY</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_BILLING_DAY%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Расчетный день. Если не передан, то берется из предыдущей подписки</td>
</tr>
<tr class="">
<td>b_CloseCurrentInvoice</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Флаг закрытия инвойса по текущей подписке:<br/>{*} 0 — не закрывать текущий инвойс<br/>{*} 1 — закрыть текущий инвойс</td>
</tr>
<tr class="added">
<td>b_UseSubscriptionBillingDay</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Использовать значение расчётного дня из предыдущей подписки</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SI_USERS_PKG.SI_USER_GOODS_PUT-0" name="SI_USERS_PKG.SI_USER_GOODS_PUT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SI_USER_GOODS_PUT</h5>
<div class="_description">
Добавление/изменение подписки абонента на услугу.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_USERS_PKG"
data-subprogram="SI_USER_GOODS_PUT"
data-object="SI_USERS_PKG.SI_USER_GOODS_PUT"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_SUBJ_GOOD_ID</td>
<td>IN/OUT</td>
<td>SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор записи</td>
</tr>
<tr class="">
<td>num_N_GOOD_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_SERVICE_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор товара/услуги</td>
</tr>
<tr class="">
<td>num_N_SUBJECT_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор абонента</td>
</tr>
<tr class="">
<td>num_N_ACCOUNT_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор лицевого счета абонента</td>
</tr>
<tr class="">
<td>num_N_OBJECT_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_OBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор оборудования абонента</td>
</tr>
<tr class="">
<td>num_N_PAY_DAY</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_BILLING_DAY%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Расчетный день месяца</td>
</tr>
<tr class="">
<td>num_N_LINE_NO</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_LINE_NO%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Номер строки по порядку при отображении таблицы</td>
</tr>
<tr class="">
<td>num_N_QUANT</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_QUANT%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Количество</td>
</tr>
<tr class="">
<td>num_N_UNIT_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_UNIT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор единицы измерения (выборка из SI_V_UNITS)</td>
</tr>
<tr class="">
<td>num_N_DOC_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор договора</td>
</tr>
<tr class="">
<td>num_N_PAR_SUBJ_GOOD_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_PAR_SUBSCRIPTION_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор родительской строки (для услуг в рамках тарифного плана)</td>
</tr>
<tr class="removed">
<td>num_N_RENDER_CONDITIONS_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_RENDER_CONDITIONS_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор условия оказания (справочник REF_TYPE_ServRenderCond)</td>
</tr>
<tr class="">
<td>dt_D_BEGIN</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_BEGIN%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата начала действия подписки</td>
</tr>
<tr class="">
<td>dt_D_END</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_END%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата окончания действия подписки</td>
</tr>
<tr class="">
<td>dt_D_INVOICE_END</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата окончания действия следующего инвойса</td>
</tr>
<tr class="">
<td>num_N_PREV_SUBSCRIPTION_ID</td>
<td>IN</td>
<td>SI_SUBSCRIPTIONS.N_PREV_SUBSCRIPTION_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Предыдущая подписка</td>
</tr>
<tr class="">
<td>b_EvaluateDiscounts</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td>Отслеживать и предоставлять возможные скидки</td>
</tr>
<tr class="">
<td>b_FilterByContext</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Учитывать текущего пользователя в проверке на доступность услуги.<br/>(По умолчанию учитывается, если контекст текущего пользователя задан)</td>
</tr>
<tr class="">
<td>b_RecreateOnUpdate</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SI_USERS_PKG_S" name="SI_USERS_PKG_S">SI_USERS_PKG_S</a></h2>
<div class="_description">
Сервисные функции для работы с абонентами и пользователями
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SI_USERS_PKG_S.GET_RECOMMENDED_PAYMENT-0" name="SI_USERS_PKG_S.GET_RECOMMENDED_PAYMENT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION GET_RECOMMENDED_PAYMENT</h5>
<div class="_description">
Получение суммы рекоммендуемого платежа.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_USERS_PKG_S"
data-subprogram="GET_RECOMMENDED_PAYMENT"
data-object="SI_USERS_PKG_S.GET_RECOMMENDED_PAYMENT"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>num_N_ACCOUNT_ID</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Счет абонента</td>
</tr>
<tr class="added">
<td>num_N_LOOKUP_DAYS_REQ</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="added">
<td>num_N_LOOKUP_DAYS_REC</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td colspan="5">RETURN TT_V_USER_RECOMMENDED_PAY.N_SUM%TYPE</td>
<td>Сумма рекомендуемого платежа</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SP_COMMANDS_PKG" name="SP_COMMANDS_PKG">SP_COMMANDS_PKG</a></h2>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SP_COMMANDS_PKG.GENERATE_COMMANDS-0" name="SP_COMMANDS_PKG.GENERATE_COMMANDS-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE GENERATE_COMMANDS</h5>
<div class="_description">
Generate and send commands.
</div>
<div style="display: none;"
class="_full_description"
data-package="SP_COMMANDS_PKG"
data-subprogram="GENERATE_COMMANDS"
data-object="SP_COMMANDS_PKG.GENERATE_COMMANDS"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>rc_Version</td>
<td>IN/OUT</td>
<td>SP_VERSIONS%ROWTYPE</td>
<td>PL/SQL RECORD</td>
<td></td>
<td>Version</td>
</tr>
<tr class="">
<td>num_N_COMMAND_TYPE_ID</td>
<td>IN</td>
<td>SP_COMMANDS.N_COMMAND_TYPE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Type of commands</td>
</tr>
<tr class="">
<td>b_ResetRetryCounter</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td>Reset number of command retries</td>
</tr>
<tr class="added">
<td>b_SendImmediate</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td>Send commands immediately</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#STR_UTILS_PKG_S" name="STR_UTILS_PKG_S">STR_UTILS_PKG_S</a></h2>
<div class="_description">
Работа с символьными строками
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#STR_UTILS_PKG_S.CONVERT_BLOB_TO_CLOB-0" name="STR_UTILS_PKG_S.CONVERT_BLOB_TO_CLOB-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE CONVERT_BLOB_TO_CLOB</h5>
<div class="_description">
Конвертировать BLOB в CLOB.
</div>
<div style="display: none;"
class="_full_description"
data-package="STR_UTILS_PKG_S"
data-subprogram="CONVERT_BLOB_TO_CLOB"
data-object="STR_UTILS_PKG_S.CONVERT_BLOB_TO_CLOB"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>blb_BL_DATA</td>
<td>IN/OUT</td>
<td>NOCOPY BLOB</td>
<td>BLOB</td>
<td></td>
<td>Входные двоичные данные</td>
</tr>
<tr class="">
<td>clb_CL_DATA</td>
<td>OUT</td>
<td>CLOB</td>
<td>CLOB</td>
<td></td>
<td>Выходные текстовые данные</td>
</tr>
<tr class="added">
<td>num_N_BLOB_CSID</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>DBMS_LOB.DEFAULT_CSID</td>
<td>Идентификатор кодировки входного объекта</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#STR_UTILS_PKG_S.STR_TO_NUMBER_TABLE-0" name="STR_UTILS_PKG_S.STR_TO_NUMBER_TABLE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION STR_TO_NUMBER_TABLE</h5>
<div class="_description">
Parse string as list of integers.
</div>
<div style="display: none;"
class="_full_description"
data-package="STR_UTILS_PKG_S"
data-subprogram="STR_TO_NUMBER_TABLE"
data-object="STR_UTILS_PKG_S.STR_TO_NUMBER_TABLE"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>vch_VC_STRING</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td></td>
<td>Input string</td>
</tr>
<tr class="added">
<td>ch_C_DELIMITER</td>
<td>IN</td>
<td>CHAR</td>
<td>CHAR</td>
<td>''</td>
<td>Delimiter</td>
</tr>
<tr class="">
<td colspan="5">RETURN DETERMINISTIC</td>
<td>Resulted numbers list</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#UTILS_PKG_S" name="UTILS_PKG_S">UTILS_PKG_S</a></h2>
<div class="_description">
Работа с различными утилитами
</div>
<br/>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#UTILS_PKG_S.HTTP_REQUEST-0" name="UTILS_PKG_S.HTTP_REQUEST-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE HTTP_REQUEST</h5>
<div class="_description">
Perform HTTP request.
</div>
<div style="display: none;"
class="_full_description"
data-package="UTILS_PKG_S"
data-subprogram="HTTP_REQUEST"
data-object="UTILS_PKG_S.HTTP_REQUEST"
data-overload="0"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Аргумент</th>
<th>Направление</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Значение по умолчанию</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>vch_VC_URL</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td></td>
<td>URL</td>
</tr>
<tr class="">
<td>vch_VC_WALLET_PATH</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Certificates wallet path</td>
</tr>
<tr class="">
<td>vch_VC_WALLET_PASSWORD</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Wallet's password</td>
</tr>
<tr class="">
<td>vch_VC_BASIC_AUTH_USER</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Basic authentication username</td>
</tr>
<tr class="">
<td>vch_VC_BASIC_AUTH_PASSWORD</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Basic authentication password</td>
</tr>
<tr class="">
<td>clb_CL_RESPONSE</td>
<td>OUT</td>
<td>CLOB</td>
<td>CLOB</td>
<td></td>
<td>Response</td>
</tr>
<tr class="added">
<td>num_N_RESPONSE_CSID</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>DBMS_LOB.DEFAULT_CSID</td>
<td>Response CSID</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2>Представления</h2>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#AP_V_USERS" name="AP_V_USERS" class="_link" title="Ссылка на представление"></a>
<h5>AP_V_USERS</h5>
<div class="_description">Данные абонента</div>
<div style="display: none;"
class="_full_description"
data-object="AP_V_USERS"
data-overload=""
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Поле</th>
<th>Тип</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>N_SUBJECT_ID</td>
<td>NUMBER</td>
<td>Абонент</td>
</tr>
<tr class="">
<td>N_BASE_SUBJECT_ID</td>
<td>NUMBER</td>
<td>Базовый субъект</td>
</tr>
<tr class="">
<td>VC_NAME</td>
<td>VARCHAR2</td>
<td>Наименование абонента</td>
</tr>
<tr class="">
<td>VC_CODE</td>
<td>VARCHAR2</td>
<td>Код абонента</td>
</tr>
<tr class="">
<td>N_SUBJ_GROUP_ID</td>
<td>NUMBER</td>
<td>Основная группа</td>
</tr>
<tr class="">
<td>VC_SUBJ_GROUP_NAME</td>
<td>VARCHAR2</td>
<td>Наименование основной группы</td>
</tr>
<tr class="added">
<td>VC_TAGS</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_PROVIDER_ID</td>
<td>VARCHAR2</td>
<td>Оператор связи</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#EP_V_SESSIONS" name="EP_V_SESSIONS" class="_link" title="Ссылка на представление"></a>
<h5>EP_V_SESSIONS</h5>
<div class="_description">Sessions</div>
<div style="display: none;"
class="_full_description"
data-object="EP_V_SESSIONS"
data-overload=""
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Поле</th>
<th>Тип</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>N_SESSION_ID</td>
<td>NUMBER</td>
<td>Session</td>
</tr>
<tr class="">
<td>N_TYPE_ID</td>
<td>NUMBER</td>
<td>Session type</td>
</tr>
<tr class="">
<td>VC_TYPE_NAME</td>
<td>VARCHAR2</td>
<td>Session type name</td>
</tr>
<tr class="">
<td>N_STATE_ID</td>
<td>NUMBER</td>
<td>Session state</td>
</tr>
<tr class="">
<td>N_CDR_STATE_ID</td>
<td>NUMBER</td>
<td>Session CDR state</td>
</tr>
<tr class="">
<td>VC_EXT_ID</td>
<td>VARCHAR2</td>
<td>Session external ID</td>
</tr>
<tr class="">
<td>VC_PAR_EXT_UNIQ_ID</td>
<td>VARCHAR2</td>
<td>Parent session unique external ID</td>
</tr>
<tr class="">
<td>VC_EXT_UNIQ_ID</td>
<td>VARCHAR2</td>
<td>Session unique external ID</td>
</tr>
<tr class="">
<td>VC_CACHE_ID</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_TERMINATION_CODE</td>
<td>VARCHAR2</td>
<td>Termination code</td>
</tr>
<tr class="">
<td>N_CUSTOMER_EQUIPMENT_ID</td>
<td>NUMBER</td>
<td>Customer equipment</td>
</tr>
<tr class="">
<td>VC_CUSTOMER_EQUIPMENT</td>
<td>VARCHAR2</td>
<td>Customer equipment code</td>
</tr>
<tr class="">
<td>N_PAR_CUSTOMER_EQUIPMENT_ID</td>
<td>NUMBER</td>
<td>Parent customer equipment</td>
</tr>
<tr class="">
<td>VC_PAR_CUSTOMER_EQUIPMENT</td>
<td>VARCHAR2</td>
<td>Parent customer equipment code</td>
</tr>
<tr class="">
<td>N_PROVIDER_EQUIPMENT_ID</td>
<td>NUMBER</td>
<td>Provider equipment</td>
</tr>
<tr class="">
<td>VC_PROVIDER_EQUIPMENT</td>
<td>VARCHAR2</td>
<td>Provider equipment code</td>
</tr>
<tr class="">
<td>N_PAR_PROVIDER_EQUIPMENT_ID</td>
<td>NUMBER</td>
<td>Parent provider equipment</td>
</tr>
<tr class="">
<td>VC_PAR_PROVIDER_EQUIPMENT</td>
<td>VARCHAR2</td>
<td>Parent provider equipment code</td>
</tr>
<tr class="">
<td>N_EQUIPMENT_BIND_ID</td>
<td>NUMBER</td>
<td>Equipment bind</td>
</tr>
<tr class="">
<td>N_CUSTOMER_ID</td>
<td>NUMBER</td>
<td>Customer</td>
</tr>
<tr class="">
<td>VC_CUSTOMER_CODE</td>
<td>VARCHAR2</td>
<td>Customer code</td>
</tr>
<tr class="">
<td>N_START_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Customer profile when session was created</td>
</tr>
<tr class="">
<td>N_START_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Provider profile when session was created</td>
</tr>
<tr class="">
<td>N_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Customer profile</td>
</tr>
<tr class="">
<td>T_CUST_CHILD_PROFILE_IDS</td>
<td>NUMBER_TABLE</td>
<td>Customer child profiles</td>
</tr>
<tr class="">
<td>N_PREV_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Previous customer profile</td>
</tr>
<tr class="">
<td>T_PREV_CHILD_PROFILE_IDS</td>
<td>NUMBER_TABLE</td>
<td>Previous customer child profiles</td>
</tr>
<tr class="">
<td>N_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Provider profile</td>
</tr>
<tr class="">
<td>N_PREV_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Previous provider profile</td>
</tr>
<tr class="">
<td>N_SERVICE_PROFILE_ID</td>
<td>NUMBER</td>
<td>Service customer profile</td>
</tr>
<tr class="">
<td>D_START</td>
<td>DATE</td>
<td>Date and time of start</td>
</tr>
<tr class="">
<td>D_FINISH</td>
<td>DATE</td>
<td>Date and time of finish</td>
</tr>
<tr class="">
<td>D_LAST_UPD</td>
<td>DATE</td>
<td>Date and time of last update</td>
</tr>
<tr class="">
<td>D_LAST_LOAD</td>
<td>DATE</td>
<td>Date and time of last load</td>
</tr>
<tr class="">
<td>C_FL_KILLED</td>
<td>CHAR</td>
<td>Was session killed?</td>
</tr>
<tr class="added">
<td>T_ATTRIBUTES</td>
<td>KEY_VALUE_TABLE</td>
<td>Session attributes</td>
</tr>
<tr class="">
<td>N_FIRM_ID</td>
<td>NUMBER</td>
<td>Firm</td>
</tr>
<tr class="">
<td>VC_SRC_APP</td>
<td>VARCHAR2</td>
<td>Source application</td>
</tr>
<tr class="">
<td>VC_LOAD_SEANCE_ID</td>
<td>VARCHAR2</td>
<td>Load seance</td>
</tr>
<tr class="">
<td>N_SCN</td>
<td>NUMBER</td>
<td>SCN</td>
</tr>
<tr class="removed">
<td>T_START_ATTRIBUTES</td>
<td>KEY_VALUE_TABLE</td>
<td>Session start attributes</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#EP_V_SESSIONS_AND_CDRS" name="EP_V_SESSIONS_AND_CDRS" class="_link" title="Ссылка на представление"></a>
<h5>EP_V_SESSIONS_AND_CDRS</h5>
<div class="_description">CDRs and sessions</div>
<div style="display: none;"
class="_full_description"
data-object="EP_V_SESSIONS_AND_CDRS"
data-overload=""
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Поле</th>
<th>Тип</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>N_CDR_ID</td>
<td>NUMBER</td>
<td>CDR</td>
</tr>
<tr class="">
<td>N_CDR_TYPE_ID</td>
<td>NUMBER</td>
<td>Type of CDR</td>
</tr>
<tr class="">
<td>VC_EXT_ID</td>
<td>VARCHAR2</td>
<td>External ID</td>
</tr>
<tr class="">
<td>VC_EXT_UNIQ_ID</td>
<td>VARCHAR2</td>
<td>Unique external ID</td>
</tr>
<tr class="">
<td>N_SERVICE_ID</td>
<td>NUMBER</td>
<td>Service</td>
</tr>
<tr class="">
<td>N_FIRM_ID</td>
<td>NUMBER</td>
<td>Firm</td>
</tr>
<tr class="">
<td>N_SESSION_STATE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_CDR_STATE_ID</td>
<td>NUMBER</td>
<td>State of CDR</td>
</tr>
<tr class="">
<td>N_USER_A_ID</td>
<td>NUMBER</td>
<td>Customer A</td>
</tr>
<tr class="">
<td>N_USER_B_ID</td>
<td>NUMBER</td>
<td>Customer B</td>
</tr>
<tr class="">
<td>N_BASE_USER_A_ID</td>
<td>NUMBER</td>
<td>Base subject of customer A</td>
</tr>
<tr class="">
<td>N_ACCOUNT_A_ID</td>
<td>NUMBER</td>
<td>Account of user A</td>
</tr>
<tr class="">
<td>N_ACCOUNT_B_ID</td>
<td>NUMBER</td>
<td>Account of user B</td>
</tr>
<tr class="">
<td>N_PROVIDER_A_ID</td>
<td>NUMBER</td>
<td>Provider A</td>
</tr>
<tr class="">
<td>N_PROVIDER_B_ID</td>
<td>NUMBER</td>
<td>Provider B</td>
</tr>
<tr class="">
<td>N_EQUIP_A_ID</td>
<td>NUMBER</td>
<td>Equipment A</td>
</tr>
<tr class="">
<td>N_EQUIP_B_ID</td>
<td>NUMBER</td>
<td>Equipment B</td>
</tr>
<tr class="">
<td>VC_EQUIP_A</td>
<td>VARCHAR2</td>
<td>Code of equipment A</td>
</tr>
<tr class="">
<td>VC_EQUIP_B</td>
<td>VARCHAR2</td>
<td>Code of equipment B</td>
</tr>
<tr class="">
<td>N_ADDRESS_A_ID</td>
<td>NUMBER</td>
<td>Address A</td>
</tr>
<tr class="">
<td>N_ADDRESS_B_ID</td>
<td>NUMBER</td>
<td>Address B</td>
</tr>
<tr class="">
<td>N_GROUP_ADDR_B_ID</td>
<td>NUMBER</td>
<td>Group of address B</td>
</tr>
<tr class="">
<td>N_GROUP_ADDR_A_ID</td>
<td>NUMBER</td>
<td>Group of address A</td>
</tr>
<tr class="">
<td>VC_STATION_A</td>
<td>VARCHAR2</td>
<td>Code of station A</td>
</tr>
<tr class="">
<td>VC_STATION_B</td>
<td>VARCHAR2</td>
<td>Code of station B</td>
</tr>
<tr class="">
<td>N_GOOD_AB_ID</td>
<td>NUMBER</td>
<td>Streaming service from A to B</td>
</tr>
<tr class="">
<td>N_GOOD_BA_ID</td>
<td>NUMBER</td>
<td>Streaming service from B to A</td>
</tr>
<tr class="">
<td>D_BEGIN</td>
<td>DATE</td>
<td>Date and time of begin CDR</td>
</tr>
<tr class="">
<td>D_BEGIN_ACC</td>
<td>DATE</td>
<td>Date and time of begin tariffing</td>
</tr>
<tr class="">
<td>D_END</td>
<td>DATE</td>
<td>Date and time of end CDR</td>
</tr>
<tr class="">
<td>N_DURATION_SEC</td>
<td>NUMBER</td>
<td>Duration in seconds</td>
</tr>
<tr class="">
<td>N_CREDIT_TIME_SEC</td>
<td>NUMBER</td>
<td>Credit time in seconds</td>
</tr>
<tr class="">
<td>VC_ROUTE_LIST_B</td>
<td>VARCHAR2</td>
<td>List of routes B</td>
</tr>
<tr class="">
<td>VC_ROUTE_A</td>
<td>VARCHAR2</td>
<td>Route A</td>
</tr>
<tr class="">
<td>VC_ROUTE_B</td>
<td>VARCHAR2</td>
<td>Route B</td>
</tr>
<tr class="">
<td>N_PURCH_PRICE_LINE_A_ID</td>
<td>NUMBER</td>
<td>Price line of purchasing price order for A</td>
</tr>
<tr class="">
<td>N_PURCH_PRICE_LINE_B_ID</td>
<td>NUMBER</td>
<td>Price line of purchasing price order for B</td>
</tr>
<tr class="">
<td>N_TERMINATION_CAUSE</td>
<td>NUMBER</td>
<td>Termination cause (number)</td>
</tr>
<tr class="">
<td>VC_TERMINATION_CAUSE</td>
<td>VARCHAR2</td>
<td>Termination cause (string)</td>
</tr>
<tr class="">
<td>N_AB_BYTES</td>
<td>NUMBER</td>
<td>Count of bytes from A to B</td>
</tr>
<tr class="">
<td>N_BA_BYTES</td>
<td>NUMBER</td>
<td>Count of bytes from B to A</td>
</tr>
<tr class="">
<td>N_GM_LINE_A_ID</td>
<td>NUMBER</td>
<td>Charge log line A</td>
</tr>
<tr class="">
<td>N_GM_LINE_B_ID</td>
<td>NUMBER</td>
<td>Charge log line B</td>
</tr>
<tr class="">
<td>N_SUM_A</td>
<td>NUMBER</td>
<td>Amount for A</td>
</tr>
<tr class="">
<td>N_SUM_WO_TAX_A</td>
<td>NUMBER</td>
<td>Amount for A without tax</td>
</tr>
<tr class="">
<td>N_SUM_B</td>
<td>NUMBER</td>
<td>Amount for B</td>
</tr>
<tr class="">
<td>N_SUM_WO_TAX_B</td>
<td>NUMBER</td>
<td>Amount for B without tax</td>
</tr>
<tr class="">
<td>N_QUANT_B</td>
<td>NUMBER</td>
<td>Quant for B</td>
</tr>
<tr class="">
<td>N_QUANT_BASE_B</td>
<td>NUMBER</td>
<td>Base quant for B</td>
</tr>
<tr class="">
<td>N_QUANT_A</td>
<td>NUMBER</td>
<td>Quant for A</td>
</tr>
<tr class="">
<td>N_QUANT_BASE_A</td>
<td>NUMBER</td>
<td>Base quant for A</td>
</tr>
<tr class="">
<td>N_CURRENCY_A_ID</td>
<td>NUMBER</td>
<td>Currency of A (ID)</td>
</tr>
<tr class="">
<td>VC_CURRENCY_A</td>
<td>VARCHAR2</td>
<td>Currency of A (name)</td>
</tr>
<tr class="">
<td>N_CURRENCY_B_ID</td>
<td>NUMBER</td>
<td>Currency of B (ID)</td>
</tr>
<tr class="">
<td>VC_CURRENCY_B</td>
<td>VARCHAR2</td>
<td>Currency of B (name)</td>
</tr>
<tr class="">
<td>N_GM_PURCH_LINE_A_ID</td>
<td>NUMBER</td>
<td>Purchasing charge log line for A</td>
</tr>
<tr class="">
<td>N_GM_PURCH_LINE_B_ID</td>
<td>NUMBER</td>
<td>Purchasing charge log line for B</td>
</tr>
<tr class="">
<td>N_CDR_ACC_STATE_ID</td>
<td>NUMBER</td>
<td>State of tariffing</td>
</tr>
<tr class="">
<td>VC_NAS</td>
<td>VARCHAR2</td>
<td>Code of NAS</td>
</tr>
<tr class="">
<td>D_LOG_CREATE</td>
<td>DATE</td>
<td>Date and time of creating</td>
</tr>
<tr class="">
<td>D_LOG_LAST_MOD</td>
<td>DATE</td>
<td>Date and time of last modification</td>
</tr>
<tr class="">
<td>N_LOG_SESSION_ID</td>
<td>NUMBER</td>
<td>Session of last modification</td>
</tr>
<tr class="">
<td>N_QUALITY</td>
<td>NUMBER</td>
<td>Quality</td>
</tr>
<tr class="">
<td>VC_REM</td>
<td>VARCHAR2</td>
<td>Remark</td>
</tr>
<tr class="">
<td>VC_AUTH_USERNAME</td>
<td>VARCHAR2</td>
<td>Authentication username</td>
</tr>
<tr class="">
<td>VC_PORT_NO</td>
<td>VARCHAR2</td>
<td>Number of port</td>
</tr>
<tr class="">
<td>VC_FRAMED_PREFIX</td>
<td>VARCHAR2</td>
<td>Subnet IPv6 for WAN-interface of customer (code)</td>
</tr>
<tr class="">
<td>N_FRAMED_PREFIX_ID</td>
<td>NUMBER</td>
<td>Subnet IPv6 for WAN-interface of customer (ID)</td>
</tr>
<tr class="">
<td>VC_DELEGATED_PREFIX</td>
<td>VARCHAR2</td>
<td>Subnet IPv6 for LAN-interface of customer (code)</td>
</tr>
<tr class="">
<td>N_DELEGATED_PREFIX_ID</td>
<td>NUMBER</td>
<td>Subnet IPv6 for LAN-interface of customer (ID)</td>
</tr>
<tr class="">
<td>N_TYPE_ID</td>
<td>NUMBER</td>
<td>Type of session</td>
</tr>
<tr class="">
<td>N_PROVIDER_EQUIPMENT_ID</td>
<td>NUMBER</td>
<td>Provider equipment</td>
</tr>
<tr class="">
<td>N_EQUIPMENT_BIND_ID</td>
<td>NUMBER</td>
<td>Bind of equipment</td>
</tr>
<tr class="">
<td>N_START_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Customer profile at the starting session</td>
</tr>
<tr class="">
<td>N_START_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Provider profile at the starting session</td>
</tr>
<tr class="">
<td>N_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Customer profile</td>
</tr>
<tr class="">
<td>T_CUST_CHILD_PROFILE_IDS</td>
<td>NUMBER_TABLE</td>
<td>Customer child profiles</td>
</tr>
<tr class="">
<td>N_PREV_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Previous customer profile</td>
</tr>
<tr class="">
<td>T_PREV_CHILD_PROFILE_IDS</td>
<td>NUMBER_TABLE</td>
<td>Previous customer child profiles</td>
</tr>
<tr class="">
<td>N_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Provider profile</td>
</tr>
<tr class="">
<td>N_PREV_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Previous provider profile</td>
</tr>
<tr class="">
<td>D_LAST_LOAD</td>
<td>DATE</td>
<td>Date and time of last loading</td>
</tr>
<tr class="">
<td>C_FL_KILLED</td>
<td>CHAR</td>
<td>Was session killed?</td>
</tr>
<tr class="added">
<td>T_ATTRIBUTES</td>
<td>KEY_VALUE_TABLE</td>
<td>Session attributes</td>
</tr>
<tr class="">
<td>VC_SRC_APP</td>
<td>VARCHAR2</td>
<td>Source loader-application</td>
</tr>
<tr class="">
<td>VC_LOAD_SEANCE_ID</td>
<td>VARCHAR2</td>
<td>ID of load seance</td>
</tr>
<tr class="">
<td>N_SCN</td>
<td>NUMBER</td>
<td>Version</td>
</tr>
<tr class="removed">
<td>T_START_ATTRIBUTES</td>
<td>KEY_VALUE_TABLE</td>
<td>Attributes obtainet at the start session</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#RG_V_SERV_STATUS" name="RG_V_SERV_STATUS" class="_link" title="Ссылка на представление"></a>
<h5>RG_V_SERV_STATUS</h5>
<div class="_description">Представление регистра состояний услуг</div>
<div style="display: none;"
class="_full_description"
data-object="RG_V_SERV_STATUS"
data-overload=""
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Поле</th>
<th>Тип</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>N_LINE_ID</td>
<td>NUMBER</td>
<td>Идентификатор записи</td>
</tr>
<tr class="">
<td>N_DOC_ID</td>
<td>NUMBER</td>
<td>Идент. документа</td>
</tr>
<tr class="">
<td>VC_DOC_NO</td>
<td>VARCHAR2</td>
<td>Номер документа</td>
</tr>
<tr class="">
<td>VC_DOC_CODE</td>
<td>VARCHAR2</td>
<td>Краткое наименование документа</td>
</tr>
<tr class="">
<td>N_SERVICE_ID</td>
<td>NUMBER</td>
<td>Идент. услуги</td>
</tr>
<tr class="">
<td>VC_SERVICE_CODE</td>
<td>VARCHAR2</td>
<td>Краткое наименование услуги</td>
</tr>
<tr class="">
<td>VC_SERVICE_NAME</td>
<td>VARCHAR2</td>
<td>Полное наименование услуги</td>
</tr>
<tr class="">
<td>N_PARENT_SERVICE_ID</td>
<td>NUMBER</td>
<td>Идент. вышестоящей услуги</td>
</tr>
<tr class="">
<td>N_ACCOUNT_ID</td>
<td>NUMBER</td>
<td>Идентификатор счёта клиента</td>
</tr>
<tr class="">
<td>VC_ACCOUNT</td>
<td>VARCHAR2</td>
<td>Код счёта</td>
</tr>
<tr class="">
<td>N_OBJECT_ID</td>
<td>NUMBER</td>
<td>Идент. объекта</td>
</tr>
<tr class="">
<td>VC_OBJ_CODE</td>
<td>VARCHAR2</td>
<td>Краткое наименование объекта</td>
</tr>
<tr class="">
<td>N_SUBSCRIPTION_ID</td>
<td>NUMBER</td>
<td>Ссылка на строку подписки</td>
</tr>
<tr class="">
<td>N_SUBJ_GOOD_ID</td>
<td>NUMBER</td>
<td>Ссылка на строку подписки</td>
</tr>
<tr class="">
<td>D_BEGIN</td>
<td>DATE</td>
<td>Дата начала</td>
</tr>
<tr class="">
<td>D_END</td>
<td>DATE</td>
<td>Дата окончания</td>
</tr>
<tr class="">
<td>D_EXPIRATION</td>
<td>DATE</td>
<td>Дата следующей актуализации</td>
</tr>
<tr class="">
<td>D_NEXT_EXPIRATION</td>
<td>DATE</td>
<td>Дата послеследующей актуализации</td>
</tr>
<tr class="">
<td>N_CONTRACT_ID</td>
<td>NUMBER</td>
<td>Договор</td>
</tr>
<tr class="">
<td>N_SERVICE_STATE_ID</td>
<td>NUMBER</td>
<td>Состояние услуги</td>
</tr>
<tr class="">
<td>VC_SERVICE_STATE_CODE</td>
<td>VARCHAR2</td>
<td>Код состояния услуги</td>
</tr>
<tr class="">
<td>VC_SERVICE_STATE_NAME</td>
<td>VARCHAR2</td>
<td>Наименование состояния услуги</td>
</tr>
<tr class="">
<td>N_NEXT_SERVICE_STATE_ID</td>
<td>NUMBER</td>
<td>Следующее состояние услуги</td>
</tr>
<tr class="">
<td>VC_NEXT_SERVICE_STATE_CODE</td>
<td>VARCHAR2</td>
<td>Код следующего состояния услуги</td>
</tr>
<tr class="">
<td>VC_NEXT_SERVICE_STATE_NAME</td>
<td>VARCHAR2</td>
<td>Наименование следующего состояния услуги</td>
</tr>
<tr class="">
<td>D_OPER</td>
<td>DATE</td>
<td>Дата расчета</td>
</tr>
<tr class="">
<td>N_PAR_LINE_ID</td>
<td>NUMBER</td>
<td>Ссылка на основную строку регистра</td>
</tr>
<tr class="">
<td>N_QUANT</td>
<td>NUMBER</td>
<td>Количество</td>
</tr>
<tr class="">
<td>N_UNIT_ID</td>
<td>NUMBER</td>
<td>Единица измерения</td>
</tr>
<tr class="">
<td>N_LAST_DOC_ID</td>
<td>NUMBER</td>
<td>Последний инвойс по услуге</td>
</tr>
<tr class="">
<td>N_SUSPENSION_LINE_ID</td>
<td>NUMBER</td>
<td>Услуга блокировки</td>
</tr>
<tr class="">
<td>N_PRICE_LINE_ID</td>
<td>NUMBER</td>
<td>Строка ПЦ</td>
</tr>
<tr class="">
<td>N_TIME_INTERVAL_ID</td>
<td>NUMBER</td>
<td>Временной интервал</td>
</tr>
<tr class="removed">
<td>N_PROVISION_RULE_ID</td>
<td>NUMBER</td>
<td>Контекст подключения</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#RPT_V_SESSIONS" name="RPT_V_SESSIONS" class="_link" title="Ссылка на представление"></a>
<h5>RPT_V_SESSIONS</h5>
<div class="_description">Sessions report</div>
<div style="display: none;"
class="_full_description"
data-object="RPT_V_SESSIONS"
data-overload=""
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Поле</th>
<th>Тип</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>N_SESSION_ID</td>
<td>NUMBER</td>
<td>Session</td>
</tr>
<tr class="">
<td>N_TYPE_ID</td>
<td>NUMBER</td>
<td>Type of session</td>
</tr>
<tr class="">
<td>VC_TYPE_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_STATE_ID</td>
<td>NUMBER</td>
<td>State</td>
</tr>
<tr class="">
<td>VC_EXT_ID</td>
<td>VARCHAR2</td>
<td>External ID</td>
</tr>
<tr class="">
<td>VC_EXT_UNIQ_ID</td>
<td>VARCHAR2</td>
<td>Unique external ID</td>
</tr>
<tr class="">
<td>N_CUSTOMER_EQUIPMENT_ID</td>
<td>NUMBER</td>
<td>Customer equipment</td>
</tr>
<tr class="">
<td>N_PROVIDER_EQUIPMENT_ID</td>
<td>NUMBER</td>
<td>Provider equipment</td>
</tr>
<tr class="">
<td>N_EQUIPMENT_BIND_ID</td>
<td>NUMBER</td>
<td>Equipment bind</td>
</tr>
<tr class="">
<td>N_BIND_TYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_CUSTOMER_ID</td>
<td>NUMBER</td>
<td>Customer</td>
</tr>
<tr class="">
<td>N_START_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Customer profile at the start session</td>
</tr>
<tr class="">
<td>N_START_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Provider profile at the start session</td>
</tr>
<tr class="">
<td>N_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Customer profile</td>
</tr>
<tr class="">
<td>N_PREV_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Previous customer profile</td>
</tr>
<tr class="">
<td>N_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Provider profile</td>
</tr>
<tr class="">
<td>N_PREV_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Previous provider profile</td>
</tr>
<tr class="">
<td>D_BEGIN</td>
<td>DATE</td>
<td>Date and time of start session</td>
</tr>
<tr class="">
<td>D_END</td>
<td>DATE</td>
<td>Date and time of finish session</td>
</tr>
<tr class="">
<td>D_LAST_UPD</td>
<td>DATE</td>
<td>Date and time of last update</td>
</tr>
<tr class="">
<td>D_LAST_LOAD</td>
<td>DATE</td>
<td>Date and time of last loading</td>
</tr>
<tr class="">
<td>C_FL_KILLED</td>
<td>CHAR</td>
<td>Was session killed?</td>
</tr>
<tr class="">
<td>N_FIRM_ID</td>
<td>NUMBER</td>
<td>Firm</td>
</tr>
<tr class="">
<td>VC_SRC_APP</td>
<td>VARCHAR2</td>
<td>Source loader-application</td>
</tr>
<tr class="">
<td>VC_LOAD_SEANCE_ID</td>
<td>VARCHAR2</td>
<td>Seance of loading</td>
</tr>
<tr class="">
<td>N_SCN</td>
<td>NUMBER</td>
<td>Version</td>
</tr>
<tr class="">
<td>VC_TERMINATION_CODE</td>
<td>VARCHAR2</td>
<td>Code of termination</td>
</tr>
<tr class="added">
<td>T_ATTRIBUTES</td>
<td>KEY_VALUE_TABLE</td>
<td>Session attributes</td>
</tr>
<tr class="removed">
<td>T_START_ATTRIBUTES</td>
<td>KEY_VALUE_TABLE</td>
<td>Session start attributes</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#RPT_V_SESSIONS_ARCH" name="RPT_V_SESSIONS_ARCH" class="_link" title="Ссылка на представление"></a>
<h5>RPT_V_SESSIONS_ARCH</h5>
<div class="_description">Sessions report</div>
<div style="display: none;"
class="_full_description"
data-object="RPT_V_SESSIONS_ARCH"
data-overload=""
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Поле</th>
<th>Тип</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>N_SESSION_ID</td>
<td>NUMBER</td>
<td>Session</td>
</tr>
<tr class="">
<td>N_TYPE_ID</td>
<td>NUMBER</td>
<td>Type of session</td>
</tr>
<tr class="">
<td>VC_TYPE_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_STATE_ID</td>
<td>NUMBER</td>
<td>State</td>
</tr>
<tr class="">
<td>VC_EXT_ID</td>
<td>VARCHAR2</td>
<td>External ID</td>
</tr>
<tr class="">
<td>VC_EXT_UNIQ_ID</td>
<td>VARCHAR2</td>
<td>Unique external ID</td>
</tr>
<tr class="">
<td>N_CUSTOMER_EQUIPMENT_ID</td>
<td>NUMBER</td>
<td>Customer equipment</td>
</tr>
<tr class="">
<td>N_PROVIDER_EQUIPMENT_ID</td>
<td>NUMBER</td>
<td>Provider equipment</td>
</tr>
<tr class="">
<td>N_EQUIPMENT_BIND_ID</td>
<td>NUMBER</td>
<td>Equipment bind</td>
</tr>
<tr class="">
<td>N_BIND_TYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_CUSTOMER_ID</td>
<td>NUMBER</td>
<td>Customer</td>
</tr>
<tr class="">
<td>N_START_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Customer profile at the start session</td>
</tr>
<tr class="">
<td>N_START_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Provider profile at the start session</td>
</tr>
<tr class="">
<td>N_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Customer profile</td>
</tr>
<tr class="">
<td>N_PREV_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Previous customer profile</td>
</tr>
<tr class="">
<td>N_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Provider profile</td>
</tr>
<tr class="">
<td>N_PREV_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td>Previous provider profile</td>
</tr>
<tr class="">
<td>D_BEGIN</td>
<td>DATE</td>
<td>Date and time of start session</td>
</tr>
<tr class="">
<td>D_END</td>
<td>DATE</td>
<td>Date and time of finish session</td>
</tr>
<tr class="">
<td>D_LAST_UPD</td>
<td>DATE</td>
<td>Date and time of last update</td>
</tr>
<tr class="">
<td>D_LAST_LOAD</td>
<td>DATE</td>
<td>Date and time of last loading</td>
</tr>
<tr class="">
<td>C_FL_KILLED</td>
<td>CHAR</td>
<td>Was session killed?</td>
</tr>
<tr class="">
<td>N_FIRM_ID</td>
<td>NUMBER</td>
<td>Firm</td>
</tr>
<tr class="">
<td>VC_SRC_APP</td>
<td>VARCHAR2</td>
<td>Source loader-application</td>
</tr>
<tr class="">
<td>VC_LOAD_SEANCE_ID</td>
<td>VARCHAR2</td>
<td>Seance of loading</td>
</tr>
<tr class="">
<td>N_SCN</td>
<td>NUMBER</td>
<td>Version</td>
</tr>
<tr class="">
<td>VC_TERMINATION_CODE</td>
<td>VARCHAR2</td>
<td>Code of termination</td>
</tr>
<tr class="added">
<td>T_ATTRIBUTES</td>
<td>KEY_VALUE_TABLE</td>
<td>Session attributes</td>
</tr>
<tr class="removed">
<td>T_START_ATTRIBUTES</td>
<td>KEY_VALUE_TABLE</td>
<td>Session start attributes</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SD_V_CHARGE_LOGS" name="SD_V_CHARGE_LOGS" class="_link" title="Ссылка на представление"></a>
<h5>SD_V_CHARGE_LOGS</h5>
<div class="_description"></div>
<div style="display: none;"
class="_full_description"
data-object="SD_V_CHARGE_LOGS"
data-overload=""
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Поле</th>
<th>Тип</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>N_DOC_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_DOC_TYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_DOC_TYPE_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_DOC_STATE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_DOC_STATE_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_PARENT_DOC_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_PARENT_DOC</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_REASON_DOC_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_REASON_DOC</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_PREV_DOC_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_PREV_DOC</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_STORNO_DOC_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_STORNO_DOC</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_WORKFLOW_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_WORKFLOW_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>D_DOC</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>D_TIME</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>VC_DOC_NO</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_CODE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>D_BEGIN</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>D_END</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>N_CREATOR_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>D_CREATED</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>VC_CREATOR_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_CREATOR_CODE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_FIRM_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_FIRM</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_REM</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>T_TAGS</td>
<td>TAGS</td>
<td></td>
</tr>
<tr class="">
<td>VC_TAGS</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>C_FL_ARCHIVED</td>
<td>CHAR</td>
<td></td>
</tr>
<tr class="">
<td>D_END_INITIAL</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>N_CLOSE_REASON_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_CLOSE_REASON</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_CANCEL_REASON_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_CANCEL_REASON</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_SUBSCRIPTION_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_UNIT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_QUANT</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_OBJECT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_CURRENCY_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SUM</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_CHARGED_SUM</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_ADD_SERVICES_CHARGES_SUM</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_ACCOUNT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SERVICE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="added">
<td>D_GMT_BEGIN</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="added">
<td>D_GMT_END</td>
<td>DATE</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SD_V_PRICE_ORDERS_C" name="SD_V_PRICE_ORDERS_C" class="_link" title="Ссылка на представление"></a>
<h5>SD_V_PRICE_ORDERS_C</h5>
<div class="_description">Состав общий</div>
<div style="display: none;"
class="_full_description"
data-object="SD_V_PRICE_ORDERS_C"
data-overload=""
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Поле</th>
<th>Тип</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>N_PRICE_LINE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_PRICE_ORDER_LINE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_DOC_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_GOOD_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_GOOD_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_GOOD_TYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_TAX_RATE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_TAX_RATE_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_CURRENCY_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_CURRENCY_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_PRICE</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_PRICE_WO_TAX</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SUM_ROUNDING_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_SUM_ROUNDING</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_UNIT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_UNIT_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_QUANT_ROUNDING_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_QUANT_ROUNDING</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_QUANT_RATING</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_RATING_UNIT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_QUANT_FIRST</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_QUANT_LAST</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_QUANT_PRICE</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_INIT_PAY_SUM</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_INIT_PAY_WO_TAX</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_LINE_NO</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_PAR_LINE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SPEED_VOLUME</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SPEED_UNIT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_SPEED_UNIT_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_USER_REM</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_ADDRESS_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_ADDRESS</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_TIME_INTERVAL_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_TIME_INTERVAL</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_PRICE_LINE_TYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_FORMULA</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_PROVIDER_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_PROVIDER</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_PRICE_PARAM_VALUE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_SUM_LAST</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="added">
<td>D_LOG_LAST_MOD</td>
<td>DATE</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SI_V_SUBSCRIPTIONS" name="SI_V_SUBSCRIPTIONS" class="_link" title="Ссылка на представление"></a>
<h5>SI_V_SUBSCRIPTIONS</h5>
<div class="_description">Подписка абонентов на услуги</div>
<div style="display: none;"
class="_full_description"
data-object="SI_V_SUBSCRIPTIONS"
data-overload=""
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Поле</th>
<th>Тип</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>N_SUBSCRIPTION_ID</td>
<td>NUMBER</td>
<td>Идентификатор записи</td>
</tr>
<tr class="">
<td>N_SERVICE_ID</td>
<td>NUMBER</td>
<td>Услуга</td>
</tr>
<tr class="">
<td>VC_SERVICE</td>
<td>VARCHAR2</td>
<td>Наименование услуги</td>
</tr>
<tr class="">
<td>N_CUSTOMER_ID</td>
<td>NUMBER</td>
<td>СУ</td>
</tr>
<tr class="">
<td>N_ACCOUNT_ID</td>
<td>NUMBER</td>
<td>ЛС</td>
</tr>
<tr class="">
<td>VC_ACCOUNT</td>
<td>VARCHAR2</td>
<td>Номер счета</td>
</tr>
<tr class="">
<td>N_OBJECT_ID</td>
<td>NUMBER</td>
<td>ОУ</td>
</tr>
<tr class="">
<td>VC_OBJECT</td>
<td>VARCHAR2</td>
<td>Наименование ОУ</td>
</tr>
<tr class="">
<td>N_PAY_DAY</td>
<td>NUMBER</td>
<td>Расчетный день месяца</td>
</tr>
<tr class="">
<td>N_QUANT</td>
<td>NUMBER</td>
<td>Количество</td>
</tr>
<tr class="">
<td>N_UNIT_ID</td>
<td>NUMBER</td>
<td>Единица измерения</td>
</tr>
<tr class="">
<td>VC_UNIT</td>
<td>VARCHAR2</td>
<td>Наименование единицы измерения</td>
</tr>
<tr class="">
<td>N_DOC_ID</td>
<td>NUMBER</td>
<td>Документ</td>
</tr>
<tr class="">
<td>D_BEGIN</td>
<td>DATE</td>
<td>Дата начала</td>
</tr>
<tr class="">
<td>D_END</td>
<td>DATE</td>
<td>Дата окончания</td>
</tr>
<tr class="">
<td>D_INVOICE_END</td>
<td>DATE</td>
<td>Дата окончания инвойса</td>
</tr>
<tr class="">
<td>C_FL_CLOSED</td>
<td>CHAR</td>
<td>Флаг закрытия</td>
</tr>
<tr class="">
<td>N_DOC_TYPE_ID</td>
<td>NUMBER</td>
<td>Тип документа</td>
</tr>
<tr class="">
<td>N_DOC_STATE_ID</td>
<td>NUMBER</td>
<td>Состояние документа</td>
</tr>
<tr class="">
<td>N_PARENT_DOC_ID</td>
<td>NUMBER</td>
<td>Базовый документ</td>
</tr>
<tr class="">
<td>VC_DOC_NAME</td>
<td>VARCHAR2</td>
<td>Наименование документа</td>
</tr>
<tr class="">
<td>VC_DOC_CODE</td>
<td>VARCHAR2</td>
<td>Код документа</td>
</tr>
<tr class="">
<td>D_DOC_BEGIN</td>
<td>DATE</td>
<td>Дата начала документа</td>
</tr>
<tr class="">
<td>D_DOC_END</td>
<td>DATE</td>
<td>Дата окончания документа</td>
</tr>
<tr class="">
<td>N_LINE_NO</td>
<td>NUMBER</td>
<td>Номер строки по порядку</td>
</tr>
<tr class="">
<td>N_GOOD_TYPE_ID</td>
<td>NUMBER</td>
<td>Тип позиции номенклатуры</td>
</tr>
<tr class="">
<td>N_SUBSCR_PERMISSION_ID</td>
<td>NUMBER</td>
<td>Права подключения</td>
</tr>
<tr class="">
<td>N_SERVICE_TYPE_ID</td>
<td>NUMBER</td>
<td>Тип услуги</td>
</tr>
<tr class="">
<td>N_UNSUBSCR_PERMISSION_ID</td>
<td>NUMBER</td>
<td>Право отключения</td>
</tr>
<tr class="">
<td>N_SERV_END_CHARGE_TYPE_ID</td>
<td>NUMBER</td>
<td>Тип списания при закрытии инвойса</td>
</tr>
<tr class="">
<td>N_PROVIDING_TYPE_ID</td>
<td>NUMBER</td>
<td>Тип оказания услуги (Периодическая/Разовая)</td>
</tr>
<tr class="">
<td>N_PAR_SUBSCRIPTION_ID</td>
<td>NUMBER</td>
<td>Родительская строка</td>
</tr>
<tr class="">
<td>N_INVOICE_ID</td>
<td>NUMBER</td>
<td>Действующий инвойс</td>
</tr>
<tr class="">
<td>N_PREV_SUBSCRIPTION_ID</td>
<td>NUMBER</td>
<td>Предыдущая подписка</td>
</tr>
<tr class="">
<td>N_CONTRACT_COMMITMENT_ID</td>
<td>NUMBER</td>
<td>Контрактное обязательство</td>
</tr>
<tr class="">
<td>D_LOG_LAST_MOD</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>N_LOG_SESSION_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="removed">
<td>N_GOOD_REND_CONDITIONS_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="removed">
<td>VC_GOOD_REND_CONDITIONS</td>
<td>VARCHAR2</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SI_V_USER_GOODS" name="SI_V_USER_GOODS" class="_link" title="Ссылка на представление"></a>
<h5>SI_V_USER_GOODS</h5>
<div class="_description">Подписка абонентов на услуги</div>
<div style="display: none;"
class="_full_description"
data-object="SI_V_USER_GOODS"
data-overload=""
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Поле</th>
<th>Тип</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>N_SUBJ_GOOD_ID</td>
<td>NUMBER</td>
<td>Идентификатор записи</td>
</tr>
<tr class="">
<td>N_GOOD_ID</td>
<td>NUMBER</td>
<td>Услуга</td>
</tr>
<tr class="">
<td>VC_GOOD_NAME</td>
<td>VARCHAR2</td>
<td>Наименование услуги</td>
</tr>
<tr class="">
<td>N_SUBJECT_ID</td>
<td>NUMBER</td>
<td>СУ</td>
</tr>
<tr class="">
<td>N_ACCOUNT_ID</td>
<td>NUMBER</td>
<td>ЛС</td>
</tr>
<tr class="">
<td>VC_ACCOUNT</td>
<td>VARCHAR2</td>
<td>Номер счета</td>
</tr>
<tr class="">
<td>N_OBJECT_ID</td>
<td>NUMBER</td>
<td>ОУ</td>
</tr>
<tr class="">
<td>VC_OBJECT</td>
<td>VARCHAR2</td>
<td>Наименование ОУ</td>
</tr>
<tr class="">
<td>N_PAY_DAY</td>
<td>NUMBER</td>
<td>Расчетный день месяца</td>
</tr>
<tr class="">
<td>N_QUANT</td>
<td>NUMBER</td>
<td>Количество</td>
</tr>
<tr class="">
<td>N_UNIT_ID</td>
<td>NUMBER</td>
<td>Единица измерения</td>
</tr>
<tr class="">
<td>VC_UNIT</td>
<td>VARCHAR2</td>
<td>Наименование единицы измерения</td>
</tr>
<tr class="">
<td>N_DOC_ID</td>
<td>NUMBER</td>
<td>Документ</td>
</tr>
<tr class="">
<td>D_BEGIN</td>
<td>DATE</td>
<td>Дата начала</td>
</tr>
<tr class="">
<td>D_END</td>
<td>DATE</td>
<td>Дата окончания</td>
</tr>
<tr class="">
<td>D_INVOICE_END</td>
<td>DATE</td>
<td>Дата окончания инвойса</td>
</tr>
<tr class="">
<td>C_FL_CLOSED</td>
<td>CHAR</td>
<td>Флаг закрытия</td>
</tr>
<tr class="">
<td>N_DOC_TYPE_ID</td>
<td>NUMBER</td>
<td>Тип документа</td>
</tr>
<tr class="">
<td>N_DOC_STATE_ID</td>
<td>NUMBER</td>
<td>Состояние документа</td>
</tr>
<tr class="">
<td>N_PARENT_DOC_ID</td>
<td>NUMBER</td>
<td>Базовый документ</td>
</tr>
<tr class="">
<td>VC_DOC_NAME</td>
<td>VARCHAR2</td>
<td>Наименование документа</td>
</tr>
<tr class="">
<td>VC_DOC_CODE</td>
<td>VARCHAR2</td>
<td>Код документа</td>
</tr>
<tr class="">
<td>D_DOC_BEGIN</td>
<td>DATE</td>
<td>Дата начала документа</td>
</tr>
<tr class="">
<td>D_DOC_END</td>
<td>DATE</td>
<td>Дата окончания документа</td>
</tr>
<tr class="">
<td>N_LINE_NO</td>
<td>NUMBER</td>
<td>Номер строки по порядку</td>
</tr>
<tr class="">
<td>N_SUBSCR_PERMISSION_ID</td>
<td>NUMBER</td>
<td>Права подключения</td>
</tr>
<tr class="">
<td>N_SERV_TYPE_ID</td>
<td>NUMBER</td>
<td>Тип услуги</td>
</tr>
<tr class="">
<td>N_UNSUBSCR_PERMISSION_ID</td>
<td>NUMBER</td>
<td>Право отключения</td>
</tr>
<tr class="">
<td>N_SERV_END_CHARGE_TYPE_ID</td>
<td>NUMBER</td>
<td>Тип списания при закрытии инвойса</td>
</tr>
<tr class="">
<td>N_PAR_SUBJ_GOOD_ID</td>
<td>NUMBER</td>
<td>Родительская строка</td>
</tr>
<tr class="">
<td>N_INVOICE_ID</td>
<td>NUMBER</td>
<td>Действующий инвойс</td>
</tr>
<tr class="">
<td>N_PREV_SUBSCRIPTION_ID</td>
<td>NUMBER</td>
<td>Предыдущая подписка</td>
</tr>
<tr class="">
<td>D_LOG_LAST_MOD</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>N_LOG_SESSION_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="removed">
<td>N_GOOD_REND_CONDITIONS_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="removed">
<td>VC_GOOD_REND_CONDITIONS</td>
<td>VARCHAR2</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SS_MV_QUICK_SEARCH" name="SS_MV_QUICK_SEARCH" class="_link" title="Ссылка на представление"></a>
<h5>SS_MV_QUICK_SEARCH</h5>
<div class="_description"></div>
<div style="display: none;"
class="_full_description"
data-object="SS_MV_QUICK_SEARCH"
data-overload=""
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Поле</th>
<th>Тип</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>RID</td>
<td>ROWID</td>
<td></td>
</tr>
<tr class="">
<td>N_ENTITY_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_ENTITY_ROLE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SEARCH_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SEARCH_TYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SEARCH_SUBTYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_RESULT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_RESULT_TYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="added">
<td>D_BEGIN</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="added">
<td>D_END</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>N_RESULT_SUBTYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_RESULT_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_RESULT_FIRM_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_CODE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>CL_TEXT</td>
<td>CLOB</td>
<td></td>
</tr>
<tr class="">
<td>MARKER</td>
<td>NUMBER</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
</div>
</div>
|