<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.3 и 5.0</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='#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_CONFIGURATIONS_PKG' title=''>RP_CONFIGURATIONS_PKG</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_DOCUMENTS_PKG_S' title='Пакет для работы с общими свойствами документов'>SD_DOCUMENTS_PKG_S</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='#SI_OBJECTS_PKG' title='Работа с объектами учета'>SI_OBJECTS_PKG</a></li>
<li><a href='#SI_OBJECTS_PKG_S' title='Работа с объектами учёта'>SI_OBJECTS_PKG_S</a></li>
<li><a href='#SI_SUBJECTS_PKG' title='Работа с субъектами учета'>SI_SUBJECTS_PKG</a></li>
<li><a href='#SI_SUBJECTS_PKG_S' title='Работа с субъектами учета'>SI_SUBJECTS_PKG_S</a></li>
<li><a href='#SI_SUBSCRIPTIONS_PKG' title='Работа с подписками и услугами'>SI_SUBSCRIPTIONS_PKG</a></li>
<li><a href='#SI_SUBSCRIPTIONS_PKG_S' title='Работа с подписками и услугами'>SI_SUBSCRIPTIONS_PKG_S</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='#SR_GOODS_PKG_S' title='Сервисные функции для работы с номенклатурой.'>SR_GOODS_PKG_S</a></li>
<li><a href='#SR_REGIONS_PKG' title='Пакет для работы с регионами'>SR_REGIONS_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_AUTO_TOP_UPS' title='Подписки на автоплатеж'>AP_V_AUTO_TOP_UPS</a></li>
<li><a href='#AP_V_DISCOUNT_PARAMS_DETAILS' title='Детализация параметров скидки'>AP_V_DISCOUNT_PARAMS_DETAILS</a></li>
<li><a href='#AP_V_PERSONAL_ACCOUNTS' title='Лицевые счета абонента'>AP_V_PERSONAL_ACCOUNTS</a></li>
<li><a href='#RPT_V_USERS' title='Отчет по абонентам'>RPT_V_USERS</a></li>
<li><a href='#SI_V_SUBJECTS' title='Субъекты учета'>SI_V_SUBJECTS</a></li>
<li><a href='#SI_V_TERM_EQUIP_IP' title='Соответствие абонентского оборудования и его IP'>SI_V_TERM_EQUIP_IP</a></li>
<li><a href='#SI_V_USERS' title='Абоненты'>SI_V_USERS</a></li>
<li><a href='#SI_V_USER_TEL_DETAIL_NEW' title=''>SI_V_USER_TEL_DETAIL_NEW</a></li>
<li><a href='#SR_V_GOODS' title='Номенклатура'>SR_V_GOODS</a></li>
<li><a href='#SS_V_AUTO_TOP_UP_RULES' title='Правила автоплатежей'>SS_V_AUTO_TOP_UP_RULES</a></li>
<li><a href='#SS_V_JOB_SEANCES' title='Сеансы обмена данными'>SS_V_JOB_SEANCES</a></li>
<li><a href='#SS_V_MANAGER_JOBS' title=''>SS_V_MANAGER_JOBS</a></li>
<li><a href='#AP_V_EQUIPMENT_ADDRESSES' title=''>AP_V_EQUIPMENT_ADDRESSES</a></li>
<li><a href='#EP_V_SESSIONS_SIMPLE' title='Sessions'>EP_V_SESSIONS_SIMPLE</a></li>
<li><a href='#RP_V_ALL_PROFILES' title='Профили'>RP_V_ALL_PROFILES</a></li>
<li><a href='#SD_V_CL_RECEIVABLES_DETAILS' title=''>SD_V_CL_RECEIVABLES_DETAILS</a></li>
<li><a href='#SD_V_RCVBLS_MATCHING_DETAILS' title=''>SD_V_RCVBLS_MATCHING_DETAILS</a></li>
<li><a href='#SI_V_REFDEPEND_SUBJ_STATES' title=''>SI_V_REFDEPEND_SUBJ_STATES</a></li>
<li><a href='#SI_V_RESELLERS' title=''>SI_V_RESELLERS</a></li>
<li><a href='#SI_V_RESELLERS_JR' title=''>SI_V_RESELLERS_JR</a></li>
<li><a href='#SI_V_SERVICE_COMMISSIONS' title=''>SI_V_SERVICE_COMMISSIONS</a></li>
</ul>
</div>
<h2>Программные пакеты</h2>
<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.EX_PAYMENTS_CHARGE-0" name="EX_PAYMENTS_PKG.EX_PAYMENTS_CHARGE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE EX_PAYMENTS_CHARGE</h5>
<div class="_description">
Провести платеж.
Используется в HPD.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG"
data-subprogram="EX_PAYMENTS_CHARGE"
data-object="EX_PAYMENTS_PKG.EX_PAYMENTS_CHARGE"
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>vch_VC_TO_ACCOUNT</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.VC_ACCOUNT%TYPE</td>
<td>VARCHAR2</td>
<td></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></td>
<td>Сумма</td>
</tr>
<tr class="">
<td>num_Fee</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td></td>
<td>Размер комиссии в процентах</td>
</tr>
<tr class="">
<td>vch_PayType</td>
<td>IN</td>
<td>SI_REF.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td></td>
<td>Краткое наименование типа платежа</td>
</tr>
<tr class="">
<td>vch_Currency</td>
<td>IN</td>
<td>SI_REF.VC_VALUE_2%TYPE</td>
<td>VARCHAR2</td>
<td></td>
<td>Код валюты в формате ISO-4217</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></td>
<td>Идентификатор транзакции</td>
</tr>
<tr class="">
<td>vch_VC_TRANSACTION_NO</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TRANSACTION_ID%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Номер транзакции</td>
</tr>
<tr class="">
<td>num_N_FORWHO_ACCOUNT_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_FORWHO_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Счет абонента</td>
</tr>
<tr class="">
<td>vch_VC_ACCOUNT</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Краткое наименование счета абонента</td>
</tr>
<tr class="">
<td>vch_VC_USER_CODE</td>
<td>IN</td>
<td>SI_SUBJECTS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Код абонента</td>
</tr>
<tr class="">
<td>vch_VC_TEL_NUMBER</td>
<td>IN</td>
<td>SI_OBJECTS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Телефонный номер</td>
</tr>
<tr class="">
<td>vch_VC_CONTRACT_DOC_NO</td>
<td>IN</td>
<td>SD_DOCUMENTS.VC_DOC_NO%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Номер договора на оказание услуг</td>
</tr>
<tr class="">
<td>vch_VC_BILL_DOC_NO</td>
<td>IN</td>
<td>SD_DOCUMENTS.VC_DOC_NO%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Номер счета</td>
</tr>
<tr class="">
<td>b_AllowCompanyPaying</td>
<td>IN</td>
<td>MAIN.BOOL</td>
<td>NUMBER</td>
<td>MAIN.b_FALSE</td>
<td>Флаг, разрешающий проводить платежи для юрлиц</td>
</tr>
<tr class="">
<td>vch_VC_USER_GROUP</td>
<td>IN</td>
<td>SI_SUBJECTS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Краткое наименование группы абонента</td>
</tr>
<tr class="">
<td>num_N_SUM_WO_FEE</td>
<td>IN</td>
<td>EX_PAYMENTS.N_SUM_WO_FEE%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_TAKING%TYPE</td>
<td>DATE</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>vch_VC_REM</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_REM%TYPE</td>
<td>VARCHAR2</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="added">
<td>num_N_AUTO_TOP_UP_ID</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Автоплатеж</td>
</tr>
<tr class="">
<td>num_N_DOC_ID</td>
<td>OUT</td>
<td>EX_PAYMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Платежный документ</td>
</tr>
<tr class="">
<td>dt_D_LOAD</td>
<td>OUT</td>
<td>EX_PAYMENTS.D_LOAD%TYPE</td>
<td>DATE</td>
<td></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.ACTIVATE_AUTO_TOP_UP-0" name="EX_PAYMENTS_PKG.ACTIVATE_AUTO_TOP_UP-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE ACTIVATE_AUTO_TOP_UP</h5>
<div class="_description">
Activate auto top up subscription by doc id.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG"
data-subprogram="ACTIVATE_AUTO_TOP_UP"
data-object="EX_PAYMENTS_PKG.ACTIVATE_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_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>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_CARDHOLDER_NAME</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.VC_CARDHOLDER_NAME%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Cardholder name</td>
</tr>
</tbody>
</table>
</div>
</li>
<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="">
<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="">
<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>
<tr class="added">
<td>vch_VC_CARDHOLDER_NAME</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.VC_CARDHOLDER_NAME%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Cardholder name</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_PUT-1" name="EX_PAYMENTS_PKG.EX_PAYMENTS_PUT-1" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE EX_PAYMENTS_PUT</h5>
<div class="_description">
Добавление или изменение записи о платеже.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG"
data-subprogram="EX_PAYMENTS_PUT"
data-object="EX_PAYMENTS_PKG.EX_PAYMENTS_PUT"
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_PAYMENT_ID</td>
<td>IN/OUT</td>
<td>EX_PAYMENTS.N_PAYMENT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Запись о платеже</td>
</tr>
<tr class="">
<td>num_N_REC_OF_BANK_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_REC_OF_BANK_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Банковская выписка</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>NULL</td>
<td>Платежный документ</td>
</tr>
<tr class="">
<td>vch_VC_DOC_NO</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_DOC_NO%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Номер платежного документа</td>
</tr>
<tr class="">
<td>dt_D_DOC</td>
<td>IN</td>
<td>EX_PAYMENTS.D_DOC%TYPE</td>
<td>DATE</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>vch_VC_CLIENT_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_CLIENT_ID%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Клиент</td>
</tr>
<tr class="">
<td>num_N_MOVE_TYPE_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_MOVE_TYPE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Вид движения</td>
</tr>
<tr class="">
<td>num_N_PAY_TYPE_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_PAY_TYPE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Тип платежа</td>
</tr>
<tr class="">
<td>num_N_TAX_RATE_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_TAX_RATE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Ставка налога</td>
</tr>
<tr class="">
<td>num_N_CURRENCY_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_CURRENCY_ID%TYPE</td>
<td>NUMBER</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>num_N_SUM_FEE</td>
<td>IN</td>
<td>EX_PAYMENTS.N_SUM_FEE%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Сумма налога</td>
</tr>
<tr class="">
<td>num_N_SUM_WO_FEE</td>
<td>IN</td>
<td>EX_PAYMENTS.N_SUM_WO_FEE%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_TAKING%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата поступления платежа</td>
</tr>
<tr class="">
<td>dt_D_LOAD</td>
<td>IN</td>
<td>EX_PAYMENTS.D_LOAD%TYPE</td>
<td>DATE</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_INN</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_FROM_INN%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>ИНН плательщика</td>
</tr>
<tr class="">
<td>vch_VC_FROM_KPP</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_FROM_KPP%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_BIK</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_FROM_BIK%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>БИК банка плательщика</td>
</tr>
<tr class="">
<td>vch_VC_FROM_CORR_ACCOUNT</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_FROM_CORR_ACCOUNT%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>num_N_FROM_SUBJECT_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_FROM_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Базовый субъект плательщика</td>
</tr>
<tr class="">
<td>num_N_FROM_BANK_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_FROM_BANK_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Банк плательщика</td>
</tr>
<tr class="">
<td>num_N_FROM_ACCOUNT_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_FROM_ACCOUNT_ID%TYPE</td>
<td>NUMBER</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>vch_VC_TO_INN</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TO_INN%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>ИНН получателя</td>
</tr>
<tr class="">
<td>vch_VC_TO_KPP</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TO_KPP%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>КПП получателя</td>
</tr>
<tr class="">
<td>vch_VC_TO_BANK</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TO_BANK%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Банк или платежная система получателя</td>
</tr>
<tr class="">
<td>vch_VC_TO_BIK</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TO_BIK%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>БИК банка получателя</td>
</tr>
<tr class="">
<td>vch_VC_TO_CORR_ACCOUNT</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TO_CORR_ACCOUNT%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Корреспондентский счет банка получателя</td>
</tr>
<tr class="">
<td>vch_VC_TO_BANK_ACCOUNT</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TO_BANK_ACCOUNT%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Расчетный счет получателя или счет в платежной системе</td>
</tr>
<tr class="">
<td>num_N_TO_SUBJECT_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_TO_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Базовый субъект получателя</td>
</tr>
<tr class="">
<td>num_N_TO_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>num_N_TO_BANK_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_TO_BANK_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Банк получателя</td>
</tr>
<tr class="">
<td>vch_VC_FORWHO</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_FORWHO%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Код абонента, которому зачисляется платеж</td>
</tr>
<tr class="">
<td>num_N_FORWHO_SUBJECT_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_FORWHO_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Абонент</td>
</tr>
<tr class="">
<td>vch_VC_FORWHO_ACCOUNT</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_FORWHO_ACCOUNT%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Наименование счета абонента</td>
</tr>
<tr class="">
<td>num_N_FORWHO_ACCOUNT_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_FORWHO_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Счет абонента</td>
</tr>
<tr class="">
<td>num_N_FIRM_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_FIRM_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Фирма</td>
</tr>
<tr class="">
<td>vch_VC_REM</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_REM%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Комментарий (назначение платежа)</td>
</tr>
<tr class="">
<td>num_N_CREATOR_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_CREATOR_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Абонент, создавший запись о платеже</td>
</tr>
<tr class="">
<td>num_N_RATING</td>
<td>IN</td>
<td>EX_PAYMENTS.N_RATING%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Числовой показатель оченки точности подбора данных в платеже (рейтинг)</td>
</tr>
<tr class="">
<td>vch_VC_REFUSE_REASON</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_REFUSE_REASON%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Причина отказа в приеме платежа</td>
</tr>
<tr class="added">
<td>num_N_AUTO_TOP_UP_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_AUTO_TOP_UP_ID%TYPE</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="changed">
<a href="#EX_PAYMENTS_PKG.EX_PAYMENTS_PUT-2" name="EX_PAYMENTS_PKG.EX_PAYMENTS_PUT-2" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE EX_PAYMENTS_PUT</h5>
<div class="_description">
Добавление записи о платеже в виде структуры.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG"
data-subprogram="EX_PAYMENTS_PUT"
data-object="EX_PAYMENTS_PKG.EX_PAYMENTS_PUT"
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>rc_PAYMENT</td>
<td>IN/OUT</td>
<td>NOCOPY EX_PAYMENTS%ROWTYPE</td>
<td>PL/SQL RECORD</td>
<td></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.CREATE_PAYMENT-0" name="EX_PAYMENTS_PKG.CREATE_PAYMENT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE CREATE_PAYMENT</h5>
<div class="_description">
Replacement for EX_PAYMENTS_CHARGE.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG"
data-subprogram="CREATE_PAYMENT"
data-object="EX_PAYMENTS_PKG.CREATE_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>vch_VC_BANK_CODE</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TO_BANK%TYPE</td>
<td>VARCHAR2</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td>vch_VC_BANK_ACCOUNT</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.VC_ACCOUNT%TYPE</td>
<td>VARCHAR2</td>
<td></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></td>
<td></td>
</tr>
<tr class="">
<td>num_N_FEE</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td>vch_VC_PAY_TYPE</td>
<td>IN</td>
<td>SI_REF.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td>vch_VC_CURRENCY</td>
<td>IN</td>
<td>SI_REF.VC_VALUE_2%TYPE</td>
<td>VARCHAR2</td>
<td></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></td>
<td></td>
</tr>
<tr class="">
<td>vch_VC_TRANSACTION_NO</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_TRANSACTION_ID%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td>num_N_CUSTOMER_ACCOUNT_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_FORWHO_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td>vch_VC_CUSTOMER_ACCOUNT</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td>vch_VC_CUSTOMER_CODE</td>
<td>IN</td>
<td>SI_SUBJECTS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td>vch_VC_PHONE_NUMBER</td>
<td>IN</td>
<td>SI_ADDRESSES.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td>vch_VC_CONTRACT_DOC_NO</td>
<td>IN</td>
<td>SD_DOCUMENTS.VC_DOC_NO%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td>vch_VC_BILL_DOC_NO</td>
<td>IN</td>
<td>SD_DOCUMENTS.VC_DOC_NO%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td>b_AllowCompanyPayments</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td></td>
</tr>
<tr class="">
<td>vch_VC_CUSTOMER_GROUP</td>
<td>IN</td>
<td>SI_SUBJECTS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td>num_N_SUM_WO_FEE</td>
<td>IN</td>
<td>EX_PAYMENTS.N_SUM_WO_FEE%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td>dt_D_TXN</td>
<td>IN</td>
<td>EX_PAYMENTS.D_TAKING%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td>vch_VC_PAYER_CODE</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_PAYER_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_PAYER_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_REM</td>
<td>IN</td>
<td>EX_PAYMENTS.VC_REM%TYPE</td>
<td>VARCHAR2</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="added">
<td>num_N_AUTO_TOP_UP_ID</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td>b_Autonomous</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td></td>
</tr>
<tr class="">
<td>num_N_DOC_ID</td>
<td>OUT</td>
<td>EX_PAYMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td>dt_D_LOAD</td>
<td>OUT</td>
<td>EX_PAYMENTS.D_LOAD%TYPE</td>
<td>DATE</td>
<td></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.CANCEL_AUTO_TOP_UP-0" name="EX_PAYMENTS_PKG.CANCEL_AUTO_TOP_UP-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE CANCEL_AUTO_TOP_UP</h5>
<div class="_description">
Cancel auto top up subscription by doc id.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG"
data-subprogram="CANCEL_AUTO_TOP_UP"
data-object="EX_PAYMENTS_PKG.CANCEL_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_DOC_ID</td>
<td>IN</td>
<td>EX_PAYMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Payment order</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#EX_PAYMENTS_PKG.UPDATE_AUTO_TOP_UP_TOKEN-0" name="EX_PAYMENTS_PKG.UPDATE_AUTO_TOP_UP_TOKEN-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE UPDATE_AUTO_TOP_UP_TOKEN</h5>
<div class="_description">
Update token for active auto top up by account.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG"
data-subprogram="UPDATE_AUTO_TOP_UP_TOKEN"
data-object="EX_PAYMENTS_PKG.UPDATE_AUTO_TOP_UP_TOKEN"
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>IN</td>
<td>SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Auto top up id</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></td>
<td>Token</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#EX_PAYMENTS_PKG.TRY_TO_CANCEL_PAY_REQ_BY_DOC-0" name="EX_PAYMENTS_PKG.TRY_TO_CANCEL_PAY_REQ_BY_DOC-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE TRY_TO_CANCEL_PAY_REQ_BY_DOC</h5>
<div class="_description">
Cancel payment requests by document
num_N_DOC_ID Payment
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG"
data-subprogram="TRY_TO_CANCEL_PAY_REQ_BY_DOC"
data-object="EX_PAYMENTS_PKG.TRY_TO_CANCEL_PAY_REQ_BY_DOC"
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></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#EX_PAYMENTS_PKG.CREATE_ATU_SUBSCRIPTION-0" name="EX_PAYMENTS_PKG.CREATE_ATU_SUBSCRIPTION-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE CREATE_ATU_SUBSCRIPTION</h5>
<div class="_description">
Create auto top up subscription for account and rule and cancel existing unverified ones.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG"
data-subprogram="CREATE_ATU_SUBSCRIPTION"
data-object="EX_PAYMENTS_PKG.CREATE_ATU_SUBSCRIPTION"
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_ACCOUNT_ID</td>
<td>IN</td>
<td>SI_AUTO_TOP_UPS.N_ACCOUNT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Account</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>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_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="">
<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>
</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.ACCOUNT_DETAILS_TBL" name="EX_PAYMENTS_PKG_S.ACCOUNT_DETAILS_TBL" class="_link" title="Ссылка на тип"></a>
<h5>TYPE ACCOUNT_DETAILS_TBL PL/SQL TABLE</h5>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<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>
<tr class="added">
<td>vch_CompanyName</td>
<td>OUT</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td></td>
<td>Company Name</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#EX_PAYMENTS_PKG_S.GET_TOP_UP_REQUESTS-0" name="EX_PAYMENTS_PKG_S.GET_TOP_UP_REQUESTS-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION GET_TOP_UP_REQUESTS</h5>
<div class="_description">
List of outstanding top up charges.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG_S"
data-subprogram="GET_TOP_UP_REQUESTS"
data-object="EX_PAYMENTS_PKG_S.GET_TOP_UP_REQUESTS"
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_BANK_CODE</td>
<td>IN</td>
<td>SI_SUBJECTS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td></td>
<td>Bank code</td>
</tr>
<tr class="added">
<td>vch_VC_BANK_ACCOUNT</td>
<td>IN</td>
<td>SI_SUBJ_ACCOUNTS.VC_ACCOUNT%TYPE</td>
<td>VARCHAR2</td>
<td></td>
<td>Bank account</td>
</tr>
<tr class="">
<td>dt_D_OPER</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>SYSDATE</td>
<td>Operation date</td>
</tr>
<tr class="">
<td colspan="5">RETURN TOP_UP_CARD_CHARGES_TBL</td>
<td>List of charges.</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_ACCOUNT_DETAILS_P-0" name="EX_PAYMENTS_PKG_S.GET_ACCOUNT_DETAILS_P-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION GET_ACCOUNT_DETAILS_P</h5>
<div class="_description">
List of account details.
</div>
<div style="display: none;"
class="_full_description"
data-package="EX_PAYMENTS_PKG_S"
data-subprogram="GET_ACCOUNT_DETAILS_P"
data-object="EX_PAYMENTS_PKG_S.GET_ACCOUNT_DETAILS_P"
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 ACCOUNT_DETAILS_TBL</td>
<td>List of account details.</td>
</tr>
<tr class="">
<td colspan="6">PIPELINED</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#RP_CONFIGURATIONS_PKG" name="RP_CONFIGURATIONS_PKG">RP_CONFIGURATIONS_PKG</a></h2>
<ul class="_objects">
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="removed">
<a href="#RP_CONFIGURATIONS_PKG.SYNC_CONFIGURATIONS_BY_RANGE-0" name="RP_CONFIGURATIONS_PKG.SYNC_CONFIGURATIONS_BY_RANGE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SYNC_CONFIGURATIONS_BY_RANGE</h5>
<div class="_description">
Sync configurations by base version
</div>
<div style="display: none;"
class="_full_description"
data-package="RP_CONFIGURATIONS_PKG"
data-subprogram="SYNC_CONFIGURATIONS_BY_RANGE"
data-object="RP_CONFIGURATIONS_PKG.SYNC_CONFIGURATIONS_BY_RANGE"
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_BaseVersion</td>
<td>IN</td>
<td>SP_VERSIONS%ROWTYPE</td>
<td>PL/SQL RECORD</td>
<td></td>
<td>Version</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#RP_CONFIGURATIONS_PKG.SYNC_CONFIGURATIONS_BY_VERSION-0" name="RP_CONFIGURATIONS_PKG.SYNC_CONFIGURATIONS_BY_VERSION-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SYNC_CONFIGURATIONS_BY_VERSION</h5>
<div class="_description">
Sync configurations by version
</div>
<div style="display: none;"
class="_full_description"
data-package="RP_CONFIGURATIONS_PKG"
data-subprogram="SYNC_CONFIGURATIONS_BY_VERSION"
data-object="RP_CONFIGURATIONS_PKG.SYNC_CONFIGURATIONS_BY_VERSION"
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</td>
<td>SP_VERSIONS%ROWTYPE</td>
<td>PL/SQL RECORD</td>
<td></td>
<td>Version</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="">
<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="added">
<td>b_RefreshImmediate</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Refresh profiles immediate</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.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="removed">
<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="added">
<td>ts_TS_START</td>
<td>IN</td>
<td>SP_VERSIONS.TS_START%TYPE</td>
<td>TIMESTAMP</td>
<td>UTILS2_PKG_S.GET_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="">
<td>dt_D_PREV_SYNC</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="added">
<td>b_RefreshImmediate</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Refresh profiles immediate</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>
</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')" 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="">
<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="">
<td>b_CommitEveryBill</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Фиксировать каждый созданный счет</td>
</tr>
<tr class="">
<td>tbl_T_TAGS</td>
<td>IN</td>
<td>TAGS</td>
<td>TABLE</td>
<td>TAGS()</td>
<td></td>
</tr>
<tr class="added">
<td>b_SplitDiscounts</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="#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>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SD_BILLS_PKG.GET_RENDERED_SERVICES-0" name="SD_BILLS_PKG.GET_RENDERED_SERVICES-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION GET_RENDERED_SERVICES</h5>
<div class="_description">
Get cursor value.
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_BILLS_PKG"
data-subprogram="GET_RENDERED_SERVICES"
data-object="SD_BILLS_PKG.GET_RENDERED_SERVICES"
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_DOCUMENTS_PKG_S" name="SD_DOCUMENTS_PKG_S">SD_DOCUMENTS_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="#SD_DOCUMENTS_PKG_S.CHK_DOC_PERIOD-0" name="SD_DOCUMENTS_PKG_S.CHK_DOC_PERIOD-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE CHK_DOC_PERIOD</h5>
<div class="_description">
Процедура проверяет период действия документа
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_DOCUMENTS_PKG_S"
data-subprogram="CHK_DOC_PERIOD"
data-object="SD_DOCUMENTS_PKG_S.CHK_DOC_PERIOD"
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_TYPE_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_DOC_TYPE_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>dt_D_DOC</td>
<td>IN</td>
<td>SD_DOCUMENTS.D_DOC%TYPE</td>
<td>DATE</td>
<td></td>
<td>Дата документа</td>
</tr>
<tr class="added">
<td>vch_VC_NAME</td>
<td>IN</td>
<td>SD_DOCUMENTS.VC_NAME%TYPE</td>
<td>VARCHAR2</td>
<td></td>
<td>Имя документа</td>
</tr>
<tr class="">
<td>num_N_PARENT_DOC_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_PARENT_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Родительский документ</td>
</tr>
<tr class="">
<td>dt_D_BEGIN</td>
<td>IN/OUT</td>
<td>SD_DOCUMENTS.D_BEGIN%TYPE</td>
<td>DATE</td>
<td></td>
<td>Дата начала действия документа</td>
</tr>
<tr class="">
<td>dt_D_END</td>
<td>IN/OUT</td>
<td>SD_DOCUMENTS.D_END%TYPE</td>
<td>DATE</td>
<td></td>
<td>Дата окончания действия документа</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_T_PUT-0" name="SD_INVOICES_PKG.SD_INVOICES_T_PUT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SD_INVOICES_T_PUT</h5>
<div class="_description">
Процедура для добавления/изменения заголовка инвойса.
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_INVOICES_PKG"
data-subprogram="SD_INVOICES_T_PUT"
data-object="SD_INVOICES_PKG.SD_INVOICES_T_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_DOC_ID</td>
<td>IN/OUT</td>
<td>SD_DOCUMENTS.N_DOC_ID%TYPE</td>
<td>NUMBER</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>NULL</td>
<td>Идентификатор фирмы-владельца</td>
</tr>
<tr class="">
<td>num_N_PARENT_DOC_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_PARENT_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор родительского документа</td>
</tr>
<tr class="">
<td>num_N_REASON_DOC_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_REASON_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор документа-основания (договор)</td>
</tr>
<tr class="">
<td>dt_D_DOC</td>
<td>IN</td>
<td>SD_DOCUMENTS.D_DOC%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата документа</td>
</tr>
<tr class="">
<td>dt_D_TIME</td>
<td>IN</td>
<td>SD_DOCUMENTS.D_TIME%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Время документа</td>
</tr>
<tr class="">
<td>vch_VC_DOC_NO</td>
<td>IN</td>
<td>SD_DOCUMENTS.VC_DOC_NO%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Номер документа</td>
</tr>
<tr class="">
<td>dt_D_BEGIN</td>
<td>IN</td>
<td>SD_DOCUMENTS.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_DOCUMENTS.D_END%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата окончания периода действия документа</td>
</tr>
<tr class="">
<td>dt_D_END_INITIAL</td>
<td>IN</td>
<td>SD_INVOICES_T.D_END_INITIAL%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Расчетная дата окончания инвойса</td>
</tr>
<tr class="">
<td>dt_D_SCHED_DEFER_END</td>
<td>IN</td>
<td>SD_INVOICES_T.D_SCHED_DEFER_END%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата окончания отсрочки по запланированным услугам</td>
</tr>
<tr class="">
<td>dt_D_UNSCHED_DEFER_END</td>
<td>IN</td>
<td>SD_INVOICES_T.D_UNSCHED_DEFER_END%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата окончания отсрочки по незапланированным услугам</td>
</tr>
<tr class="">
<td>num_N_CLOSE_REASON_ID</td>
<td>IN</td>
<td>SD_INVOICES_T.N_CLOSE_REASON_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Причина закрытия инвойса</td>
</tr>
<tr class="">
<td>num_N_CANCEL_REASON_ID</td>
<td>IN</td>
<td>SD_INVOICES_T.N_CANCEL_REASON_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Причина аннулирования инвойса</td>
</tr>
<tr class="">
<td>dt_D_CLOSABLE</td>
<td>IN</td>
<td>SD_INVOICES_T.D_CLOSABLE%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата, с которой возможно закрытие инвойса</td>
</tr>
<tr class="added">
<td>dt_D_BILLING_DATE</td>
<td>IN</td>
<td>SD_INVOICES_T.D_BILLING_DATE%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата следующего расчетного дня</td>
</tr>
<tr class="">
<td>vch_VC_REM</td>
<td>IN</td>
<td>SD_DOCUMENTS.VC_REM%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Комментарий</td>
</tr>
<tr class="">
<td>num_N_WORKFLOW_ID</td>
<td>IN</td>
<td>SD_DOCUMENTS.N_WORKFLOW_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор схемы документооборота</td>
</tr>
<tr class="">
<td>tbl_T_TAGS</td>
<td>IN</td>
<td>TAGS</td>
<td>TABLE</td>
<td>TAGS()</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.GET_BILLING_DATE-0" name="SD_INVOICES_PKG_S.GET_BILLING_DATE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION GET_BILLING_DATE</h5>
<div class="_description">
Get charge log billing date.
</div>
<div style="display: none;"
class="_full_description"
data-package="SD_INVOICES_PKG_S"
data-subprogram="GET_BILLING_DATE"
data-object="SD_INVOICES_PKG_S.GET_BILLING_DATE"
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_VOICES_T.N_DOC_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Charge log</td>
</tr>
<tr class="">
<td colspan="5">RETURN SD_INVOICES_T.D_BILLING_DATE%TYPE</td>
<td>Billing date</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_SUBJ_SERVICES_DEL-0" name="SI_OBJECTS_PKG.SI_SUBJ_SERVICES_DEL-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SI_SUBJ_SERVICES_DEL</h5>
<div class="_description">
Удаление записи привязки к службам или данных об управлении объектами.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_OBJECTS_PKG"
data-subprogram="SI_SUBJ_SERVICES_DEL"
data-object="SI_OBJECTS_PKG.SI_SUBJ_SERVICES_DEL"
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_SERV_ID</td>
<td>IN</td>
<td>SI_SUBJ_SERVICES.N_SUBJ_SERV_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Привязка</td>
</tr>
<tr class="added">
<td>num_N_SCN</td>
<td>IN</td>
<td>SI_SUBJ_SERVICES.N_SCN%TYPE</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="changed">
<a href="#SI_OBJECTS_PKG.SI_SUBJ_SERVICES_PUT-0" name="SI_OBJECTS_PKG.SI_SUBJ_SERVICES_PUT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SI_SUBJ_SERVICES_PUT</h5>
<div class="_description">
Добавление записи привязки к службам или данных об управлении объектами.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_OBJECTS_PKG"
data-subprogram="SI_SUBJ_SERVICES_PUT"
data-object="SI_OBJECTS_PKG.SI_SUBJ_SERVICES_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_SERV_ID</td>
<td>IN/OUT</td>
<td>SI_SUBJ_SERVICES.N_SUBJ_SERV_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Привязка</td>
</tr>
<tr class="">
<td>num_N_SUBJECT_ID</td>
<td>IN</td>
<td>SI_SUBJ_SERVICES.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Субъект учета</td>
</tr>
<tr class="">
<td>num_N_SERVICE_ID</td>
<td>IN</td>
<td>SI_SUBJ_SERVICES.N_SERVICE_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Служба</td>
</tr>
<tr class="">
<td>num_N_OBJECT_ID</td>
<td>IN</td>
<td>SI_SUBJ_SERVICES.N_OBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Компонент службы или отдельный объект учета</td>
</tr>
<tr class="">
<td>num_N_AUTH_TYPE_ID</td>
<td>IN</td>
<td>SI_SUBJ_SERVICES.N_AUTH_TYPE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Тип авторизаци</td>
</tr>
<tr class="">
<td>num_N_OBJ_ADDRESS_ID</td>
<td>IN</td>
<td>SI_SUBJ_SERVICES.N_OBJ_ADDRESS_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Интерфейс для усправления</td>
</tr>
<tr class="">
<td>num_N_PORT_NO</td>
<td>IN</td>
<td>SI_SUBJ_SERVICES.N_PORT_NO%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Номер порта для управления</td>
</tr>
<tr class="">
<td>vch_VC_LOGIN</td>
<td>IN</td>
<td>SI_SUBJ_SERVICES.VC_LOGIN%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Логин</td>
</tr>
<tr class="">
<td>vch_VC_VALUE</td>
<td>IN</td>
<td>SI_SUBJ_SERVICES.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_SERVICES.N_VALUE%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Числовой параметр</td>
</tr>
<tr class="added">
<td>num_N_LOCALE_ID</td>
<td>IN</td>
<td>SI_SUBJ_SERVICES.N_LOCALE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Локаль</td>
</tr>
<tr class="added">
<td>num_N_SCN</td>
<td>IN</td>
<td>SI_SUBJ_SERVICES.N_SCN%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Версия</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SI_OBJECTS_PKG_S" name="SI_OBJECTS_PKG_S">SI_OBJECTS_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="#SI_OBJECTS_PKG_S.OBJECT_HISTORY-0" name="SI_OBJECTS_PKG_S.OBJECT_HISTORY-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION OBJECT_HISTORY</h5>
<div class="_description">
List of object changes
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_OBJECTS_PKG_S"
data-subprogram="OBJECT_HISTORY"
data-object="SI_OBJECTS_PKG_S.OBJECT_HISTORY"
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_PRIMARY_KEY_VALUE</td>
<td>IN</td>
<td>SI_OBJECTS.N_OBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Object</td>
</tr>
<tr class="">
<td>vch_VC_FOREIGN_KEY</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Foreign key for content audit</td>
</tr>
<tr class="">
<td>num_N_FOREIGN_KEY_VALUE</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Foreign key value</td>
</tr>
<tr class="">
<td>dt_D_BEGIN</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>ADD_MONTHS(SYSDATE -3)</td>
<td>Search period begin date</td>
</tr>
<tr class="">
<td>dt_D_END</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>SYSDATE</td>
<td>Search period end date</td>
</tr>
<tr class="">
<td colspan="5">RETURN SS_AUDIT_PKG_S.TABLE_HISTORY_LIST_TABLE_TYPE</td>
<td>Object changes list</td>
</tr>
<tr class="">
<td colspan="6">PIPELINED</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.SI_SUBJECTS_PUT-0" name="SI_SUBJECTS_PKG.SI_SUBJECTS_PUT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SI_SUBJECTS_PUT</h5>
<div class="_description">
Добавление или изменение записи о субъекте учета.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_SUBJECTS_PKG"
data-subprogram="SI_SUBJECTS_PUT"
data-object="SI_SUBJECTS_PKG.SI_SUBJECTS_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_SUBJECT_ID</td>
<td>IN/OUT</td>
<td>SI_SUBJECTS.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Субъект</td>
</tr>
<tr class="">
<td>num_N_SUBJ_TYPE_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_SUBJ_TYPE_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Тип субъекта</td>
</tr>
<tr class="">
<td>num_N_BASE_SUBJECT_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_BASE_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Базовый субъект</td>
</tr>
<tr class="">
<td>num_N_SUBJ_STATE_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_SUBJ_STATE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Состояние субъекта</td>
</tr>
<tr class="">
<td>num_N_PARENT_SUBJ_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_PARENT_SUBJ_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Родительский субъект</td>
</tr>
<tr class="">
<td>num_N_OWNER_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_OWNER_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Владелец</td>
</tr>
<tr class="">
<td>vch_VC_NAME</td>
<td>IN</td>
<td>SI_SUBJECTS.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_SUBJECTS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Краткое наименование</td>
</tr>
<tr class="">
<td>vch_VC_REM</td>
<td>IN</td>
<td>SI_SUBJECTS.VC_REM%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Комментарий</td>
</tr>
<tr class="">
<td>num_N_FIRM_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_FIRM_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Фирма</td>
</tr>
<tr class="">
<td>num_N_REGION_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_REGION_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Регион</td>
</tr>
<tr class="">
<td>dt_D_ACTUALIZE</td>
<td>IN</td>
<td>SI_SUBJECTS.D_ACTUALIZE%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Дата актуализации данных по субъекту</td>
</tr>
<tr class="">
<td>vch_VC_CODE_ADD</td>
<td>IN</td>
<td>SI_SUBJECTS.VC_CODE_ADD%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Дополнительный код</td>
</tr>
<tr class="">
<td>num_N_SERVER_ID</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Сервер</td>
</tr>
<tr class="">
<td>num_N_SUBJ_GROUP_ID</td>
<td>IN</td>
<td>SI_SUBJ_GROUPS.N_SUBJ_GROUP_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Группа субъекта</td>
</tr>
<tr class="">
<td>tbl_T_TAGS</td>
<td>IN</td>
<td>TAGS</td>
<td>TABLE</td>
<td>NULL</td>
<td>Теги</td>
</tr>
<tr class="">
<td>num_N_SCN</td>
<td>IN</td>
<td>SI_SUBJECTS.N_SCN%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Версия</td>
</tr>
<tr class="added">
<td>num_N_RESELLER_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_RESELLER_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Реселлер</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SI_SUBJECTS_PKG_S" name="SI_SUBJECTS_PKG_S">SI_SUBJECTS_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="#SI_SUBJECTS_PKG_S.GET_PROVIDER_CODE-0" name="SI_SUBJECTS_PKG_S.GET_PROVIDER_CODE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION GET_PROVIDER_CODE</h5>
<div class="_description">
Возвратить код по идентификатору.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_SUBJECTS_PKG_S"
data-subprogram="GET_PROVIDER_CODE"
data-object="SI_SUBJECTS_PKG_S.GET_PROVIDER_CODE"
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_SUBJECTS.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Субъект учета</td>
</tr>
<tr class="">
<td colspan="5">RETURN DETERMINISTIC</td>
<td>Код субъекта</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_DEL-0" name="SI_SUBSCRIPTIONS_PKG.SI_SUBSCRIPTIONS_DEL-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SI_SUBSCRIPTIONS_DEL</h5>
<div class="_description">
Delete subscription.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_SUBSCRIPTIONS_PKG"
data-subprogram="SI_SUBSCRIPTIONS_DEL"
data-object="SI_SUBSCRIPTIONS_PKG.SI_SUBSCRIPTIONS_DEL"
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</td>
<td>SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>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="added">
<td>b_DeleteCommitment</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td>Delete contract commitment</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SI_SUBSCRIPTIONS_PKG_S" name="SI_SUBSCRIPTIONS_PKG_S">SI_SUBSCRIPTIONS_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_SUBSCRIPTIONS_PKG_S.GET_FULL_CHARGE_SUM-0" name="SI_SUBSCRIPTIONS_PKG_S.GET_FULL_CHARGE_SUM-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION GET_FULL_CHARGE_SUM</h5>
<div class="_description">
Getting total charge sum for subscription.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_SUBSCRIPTIONS_PKG_S"
data-subprogram="GET_FULL_CHARGE_SUM"
data-object="SI_SUBSCRIPTIONS_PKG_S.GET_FULL_CHARGE_SUM"
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</td>
<td>SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td></td>
</tr>
<tr class="">
<td>dt_D_OPER</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>SYSDATE</td>
<td>Operation date</td>
</tr>
<tr class="added">
<td>dt_D_BILLING_DATE</td>
<td>IN</td>
<td>SD_VOICES_T.D_BILLING_DATE%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td></td>
</tr>
<tr class="">
<td colspan="5">RETURN SD_GOOD_MOVES.N_SUM%TYPE</td>
<td>Сумма списания</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.SI_USERS_PUT-0" name="SI_USERS_PKG.SI_USERS_PUT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SI_USERS_PUT</h5>
<div class="_description">
Добавление/изменение абонента.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_USERS_PKG"
data-subprogram="SI_USERS_PUT"
data-object="SI_USERS_PKG.SI_USERS_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_SUBJECT_ID</td>
<td>IN/OUT</td>
<td>SI_SUBJECTS.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор абонента</td>
</tr>
<tr class="">
<td>vch_VC_CODE</td>
<td>IN</td>
<td>SI_SUBJECTS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td></td>
<td>Код</td>
</tr>
<tr class="">
<td>num_N_BASE_SUBJECT_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_BASE_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор базового СУ (юрлицо или физлицо)</td>
</tr>
<tr class="">
<td>num_N_SUBJ_GROUP_ID</td>
<td>IN</td>
<td>SI_SUBJ_SUBJECTS.N_SUBJ_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Идентификатор группы абонентов</td>
</tr>
<tr class="">
<td>num_N_PARENT_SUBJ_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_PARENT_SUBJ_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор вышестоящего СУ</td>
</tr>
<tr class="">
<td>num_N_SUBJ_STATE_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_SUBJ_STATE_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор состояния СУ (справочник REF_TYPE_Subject_State)</td>
</tr>
<tr class="">
<td>num_N_FIRM_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_FIRM_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Идентификатор фирмы</td>
</tr>
<tr class="">
<td>vch_VC_REM</td>
<td>IN</td>
<td>SI_SUBJECTS.VC_REM%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Примечание</td>
</tr>
<tr class="">
<td>tbl_T_TAGS</td>
<td>IN</td>
<td>TAGS</td>
<td>TABLE</td>
<td>NULL</td>
<td>Теги</td>
</tr>
<tr class="added">
<td>num_N_RESELLER_ID</td>
<td>IN</td>
<td>SI_SUBJECTS.N_RESELLER_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</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.VOICE_DETALIZATION" name="SI_USERS_PKG_S.VOICE_DETALIZATION" class="_link" title="Ссылка на тип"></a>
<h5>TYPE VOICE_DETALIZATION PL/SQL RECORD</h5>
<div class="_description">
Детализация по телефонии.
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_USERS_PKG_S"
data-type="VOICE_DETALIZATION"
data-object="SI_USERS_PKG_S.VOICE_DETALIZATION"
onclick="event.stopPropagation()">
<table cellspacing="0" cellspadding="0">
<thead>
<tr>
<th>Название поля</th>
<th>Ссылочный тип</th>
<th>Тип</th>
<th>Описание</th>
</tr>
</thead>
<tbody>
<tr class="">
<td>D_OPER</td>
<td>SI_V_USER_TEL_DETAIL.D_BEGIN%TYPE</td>
<td>DATE</td>
<td>Дата начала оказания услуги</td>
</tr>
<tr class="">
<td>VC_FROM</td>
<td>SI_V_USER_TEL_DETAIL.VC_FROM%TYPE</td>
<td>VARCHAR2</td>
<td>Место совершения звонка</td>
</tr>
<tr class="">
<td>VC_TO</td>
<td>SI_V_USER_TEL_DETAIL.VC_TO%TYPE</td>
<td>VARCHAR2</td>
<td>Направление звонка</td>
</tr>
<tr class="">
<td>N_QUANT</td>
<td>SI_V_USER_TEL_DETAIL.N_QUANT%TYPE</td>
<td>NUMBER</td>
<td>Количество</td>
</tr>
<tr class="">
<td>N_QUANT_BASE</td>
<td>SI_V_USER_TEL_DETAIL.N_QUANT_BASE%TYPE</td>
<td>NUMBER</td>
<td>Базовое количество</td>
</tr>
<tr class="">
<td>N_DURATION_SEC</td>
<td>SI_V_USER_TEL_DETAIL.N_DURATION_SEC%TYPE</td>
<td>NUMBER</td>
<td>Длительность в секундах</td>
</tr>
<tr class="">
<td>N_QUANT_MINUTES</td>
<td>SI_V_USER_TEL_DETAIL.N_QUANT_MINUTES%TYPE</td>
<td>NUMBER</td>
<td>Количество минут, с учетом бесплатных</td>
</tr>
<tr class="">
<td>VC_UNIT_NAME</td>
<td>SI_V_USER_TEL_DETAIL.VC_UNIT_NAME%TYPE</td>
<td>VARCHAR2</td>
<td>Наименование единицы измерения</td>
</tr>
<tr class="added">
<td>N_PAR_PRICE_LINE_ID</td>
<td>SD_PRICE_ORDERS_C.N_PAR_LINE_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SUM</td>
<td>SI_V_USER_TEL_DETAIL.N_SUM%TYPE</td>
<td>NUMBER</td>
<td>Cтоимость подключения услуги</td>
</tr>
<tr class="">
<td>N_SUM_WO_TAX</td>
<td>SI_V_USER_TEL_DETAIL.N_SUM_WO_TAX%TYPE</td>
<td>NUMBER</td>
<td>Сумма без налогов</td>
</tr>
<tr class="">
<td>VC_CURRENCY</td>
<td>SI_V_USER_TEL_DETAIL.VC_CURRENCY%TYPE</td>
<td>VARCHAR2</td>
<td>Наименование валюты</td>
</tr>
<tr class="">
<td>VC_GOOD_NAME</td>
<td>SI_V_USER_TEL_DETAIL.VC_GOOD_NAME%TYPE</td>
<td>VARCHAR2</td>
<td>Наименование услуги</td>
</tr>
<tr class="">
<td>VC_ADDR_NAME</td>
<td>SI_V_USER_TEL_DETAIL.VC_ADDR_NAME%TYPE</td>
<td>VARCHAR2</td>
<td>Наименование адреса</td>
</tr>
<tr class="">
<td>VC_ADDR_CODE</td>
<td>SI_V_USER_TEL_DETAIL.VC_ADDR_CODE%TYPE</td>
<td>VARCHAR2</td>
<td>Код адреса</td>
</tr>
<tr class="">
<td>N_PROVIDER_ID</td>
<td>SI_SUBJECTS.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>Поставщик</td>
</tr>
<tr class="">
<td>VC_PROVIDER</td>
<td>SI_SUBJECTS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td>Наименование поставщика</td>
</tr>
<tr class="">
<td>N_ROWNUM</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>Номер строки</td>
</tr>
<tr class="">
<td>N_CALC_DESIGN_PROC_ID</td>
<td>SI_V_USER_TEL_DETAIL.N_CALC_DESIGN_PROC_ID%TYPE</td>
<td>NUMBER</td>
<td>Методика рассчета стоимости</td>
</tr>
<tr class="">
<td>N_COUNT</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SI_USERS_PKG_S.USER_HISTORY-0" name="SI_USERS_PKG_S.USER_HISTORY-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION USER_HISTORY</h5>
<div class="_description">
List of user changes
</div>
<div style="display: none;"
class="_full_description"
data-package="SI_USERS_PKG_S"
data-subprogram="USER_HISTORY"
data-object="SI_USERS_PKG_S.USER_HISTORY"
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_PRIMARY_KEY_VALUE</td>
<td>IN</td>
<td>SI_SUBJECTS.N_SUBJECT_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>User</td>
</tr>
<tr class="">
<td>vch_VC_FOREIGN_KEY</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Foreign key</td>
</tr>
<tr class="">
<td>num_N_FOREIGN_KEY_VALUE</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Foreign key value</td>
</tr>
<tr class="">
<td>dt_D_BEGIN</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>ADD_MONTHS(SYSDATE -3)</td>
<td>Search period begin date</td>
</tr>
<tr class="">
<td>dt_D_END</td>
<td>IN</td>
<td>DATE</td>
<td>DATE</td>
<td>SYSDATE</td>
<td>Search period end date</td>
</tr>
<tr class="">
<td colspan="5">RETURN SS_AUDIT_PKG_S.TABLE_HISTORY_LIST_TABLE_TYPE</td>
<td>User changes list</td>
</tr>
<tr class="">
<td colspan="6">PIPELINED</td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SR_GOODS_PKG_S" name="SR_GOODS_PKG_S">SR_GOODS_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="#SR_GOODS_PKG_S.SERVICE_PERMITTED_CACHE_TYPE" name="SR_GOODS_PKG_S.SERVICE_PERMITTED_CACHE_TYPE" class="_link" title="Ссылка на тип"></a>
<h5>TYPE SERVICE_PERMITTED_CACHE_TYPE PL/SQL TABLE</h5>
<div class="_description">
Mapping of IS_SERVICE_PERMITTED args to result.
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SR_GOODS_PKG_S.GET_CHARGES_COUNT-0" name="SR_GOODS_PKG_S.GET_CHARGES_COUNT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION GET_CHARGES_COUNT</h5>
<div class="_description">
Get service charges count for charge log.
</div>
<div style="display: none;"
class="_full_description"
data-package="SR_GOODS_PKG_S"
data-subprogram="GET_CHARGES_COUNT"
data-object="SR_GOODS_PKG_S.GET_CHARGES_COUNT"
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>Service provision begin</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>Service provision end</td>
</tr>
<tr class="">
<td>num_N_DURATION_UNIT_ID</td>
<td>IN</td>
<td>SR_SERV_SCHEMES.N_DURATION_UNIT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Service period duration unit</td>
</tr>
<tr class="">
<td>num_N_DURATION_VALUE</td>
<td>IN</td>
<td>SR_SERV_SCHEMES.N_DURATION_VALUE%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Service period duration</td>
</tr>
<tr class="">
<td>num_N_CHARGE_PERIOD_UNIT_ID</td>
<td>IN</td>
<td>SR_PROVISION_PARAMETERS.N_CHARGE_PERIOD_UNIT_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Service charge period duration</td>
</tr>
<tr class="">
<td>num_N_CHARGE_PERIOD_VALUE</td>
<td>IN</td>
<td>SR_PROVISION_PARAMETERS.N_CHARGE_PERIOD_VALUE%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Service charge period</td>
</tr>
<tr class="added">
<td>dt_D_BILLING_DATE</td>
<td>IN</td>
<td>SD_VOICES_T.D_BILLING_DATE%TYPE</td>
<td>DATE</td>
<td>NULL</td>
<td>Billing date</td>
</tr>
<tr class="">
<td colspan="5">RETURN NUMBER</td>
<td>Charges count</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SR_GOODS_PKG_S.CATALOG_ITEM_INHERITED_TAGS-0" name="SR_GOODS_PKG_S.CATALOG_ITEM_INHERITED_TAGS-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION CATALOG_ITEM_INHERITED_TAGS</h5>
<div class="_description">
Get tags for catalog item
</div>
<div style="display: none;"
class="_full_description"
data-package="SR_GOODS_PKG_S"
data-subprogram="CATALOG_ITEM_INHERITED_TAGS"
data-object="SR_GOODS_PKG_S.CATALOG_ITEM_INHERITED_TAGS"
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_CATALOG_ITEM_ID</td>
<td>IN</td>
<td>SR_GOODS.N_GOOD_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Catalog item</td>
</tr>
<tr class="">
<td colspan="5">RETURN TAGS</td>
<td>Tags</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" style="cursor: default" class="added">
<a href="#SR_GOODS_PKG_S.DISABLE_SERV_PERMITTED_CACHE-0" name="SR_GOODS_PKG_S.DISABLE_SERV_PERMITTED_CACHE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE DISABLE_SERV_PERMITTED_CACHE</h5>
<div class="_description">
Disable IS_SERVICE_PERMITTED cache.
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" style="cursor: default" class="added">
<a href="#SR_GOODS_PKG_S.ENABLE_SERV_PERMITTED_CACHE-0" name="SR_GOODS_PKG_S.ENABLE_SERV_PERMITTED_CACHE-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE ENABLE_SERV_PERMITTED_CACHE</h5>
<div class="_description">
Enable IS_SERVICE_PERMITTED cache.
</div>
</li>
</ul>
</div>
<div>
<h2><a href="#SR_REGIONS_PKG" name="SR_REGIONS_PKG">SR_REGIONS_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="#SR_REGIONS_PKG.SR_REGIONS_PUT-0" name="SR_REGIONS_PKG.SR_REGIONS_PUT-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE SR_REGIONS_PUT</h5>
<div class="_description">
Добавление или изменение региона.
</div>
<div style="display: none;"
class="_full_description"
data-package="SR_REGIONS_PKG"
data-subprogram="SR_REGIONS_PUT"
data-object="SR_REGIONS_PKG.SR_REGIONS_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_REGION_ID</td>
<td>IN/OUT</td>
<td>SR_REGIONS.N_REGION_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Регион</td>
</tr>
<tr class="">
<td>num_N_REGION_TYPE_ID</td>
<td>IN</td>
<td>SR_REGIONS.N_REGION_TYPE_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Тип региона</td>
</tr>
<tr class="">
<td>num_N_PAR_REGION_ID</td>
<td>IN</td>
<td>SR_REGIONS.N_PAR_REGION_ID%TYPE</td>
<td>NUMBER</td>
<td></td>
<td>Вышестоящий регион</td>
</tr>
<tr class="">
<td>vch_VC_CODE</td>
<td>IN</td>
<td>SR_REGIONS.VC_CODE%TYPE</td>
<td>VARCHAR2</td>
<td></td>
<td>Код региона</td>
</tr>
<tr class="">
<td>vch_VC_NAME</td>
<td>IN</td>
<td>SR_REGIONS.VC_NAME%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Наименование региона</td>
</tr>
<tr class="">
<td>vch_VC_ENG_NAME</td>
<td>IN</td>
<td>SR_REGIONS.VC_ENG_NAME%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Международное наименование</td>
</tr>
<tr class="">
<td>num_N_HIERARCHY_TYPE_ID</td>
<td>IN</td>
<td>SR_REGIONS.N_HIERARCHY_TYPE_ID%TYPE</td>
<td>NUMBER</td>
<td>SS_CONSTANTS_PKG_S.HIER_REG_TYPE_Federal</td>
<td>Тип иерархии</td>
</tr>
<tr class="">
<td>num_N_BASE_REGION_ID</td>
<td>IN</td>
<td>SR_REGIONS.N_BASE_REGION_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Базовый регион для региона муниципальной иерархии</td>
</tr>
<tr class="">
<td>num_N_PAR_BIND_REGION_ID</td>
<td>IN</td>
<td>SR_REGIONS.N_REGION_ID%TYPE</td>
<td>NUMBER</td>
<td>NULL</td>
<td>Вышестоящий регион муниципальной иерархии для привязки</td>
</tr>
<tr class="">
<td>num_N_REALTY_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="">
<td>vch_VC_ZIP</td>
<td>IN</td>
<td>SR_REGIONS.VC_ZIP%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Индекс</td>
</tr>
<tr class="">
<td>vch_VC_HOME</td>
<td>IN</td>
<td>SR_REGIONS.VC_HOME%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Дом</td>
</tr>
<tr class="">
<td>vch_VC_BUILDING</td>
<td>IN</td>
<td>SR_REGIONS.VC_BUILDING%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Корпус</td>
</tr>
<tr class="">
<td>vch_VC_CONSTRUCT</td>
<td>IN</td>
<td>SR_REGIONS.VC_CONSTRUCT%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Строение</td>
</tr>
<tr class="">
<td>vch_VC_OWNERSHIP</td>
<td>IN</td>
<td>SR_REGIONS.VC_OWNERSHIP%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Владение</td>
</tr>
<tr class="">
<td>vch_VC_CODE_EXT</td>
<td>IN</td>
<td>SR_REGIONS.VC_CODE_EXT%TYPE</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Внешний код для синхронизации</td>
</tr>
<tr class="removed">
<td>b_UpdateSearchIndex</td>
<td>IN</td>
<td>MAIN.BOOL</td>
<td>NUMBER</td>
<td>MAIN.b_FALSE</td>
<td>Признак синхронизации индекса OracleText</td>
</tr>
<tr class="added">
<td>b_UpdateSearchIndex</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_TRUE</td>
<td>Признак синхронизации индекса OracleText</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.PARSE_SEARCH_STRING-0" name="STR_UTILS_PKG_S.PARSE_SEARCH_STRING-0" class="_link" title="Ссылка на процедуру"></a>
<h5>FUNCTION PARSE_SEARCH_STRING</h5>
<div class="_description">
Токенайзер для OracleText.
</div>
<div style="display: none;"
class="_full_description"
data-package="STR_UTILS_PKG_S"
data-subprogram="PARSE_SEARCH_STRING"
data-object="STR_UTILS_PKG_S.PARSE_SEARCH_STRING"
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_SEARCH_STR</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td></td>
<td>Строка для поиска</td>
</tr>
<tr class="">
<td>num_N_TOKEN_MIN_LENGTH</td>
<td>IN</td>
<td>NUMBER</td>
<td>NUMBER</td>
<td>0</td>
<td>Минимальная длина токена, при которой разрешен поиск по всему выражению.</td>
</tr>
<tr class="">
<td>vch_VC_PRINTJOINS</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td>NULL</td>
<td>Неалфавитноцифровые символы, не влияющие на формирование токенов</td>
</tr>
<tr class="added">
<td>num_N_LANG_ID</td>
<td>IN</td>
<td>SI_REF.N_REF_ID%TYPE</td>
<td>NUMBER</td>
<td>MAIN.GET_N_LANG_ID</td>
<td>Язык</td>
</tr>
<tr class="">
<td colspan="5">RETURN DETERMINISTIC</td>
<td>Строка из токенов для использования OracleText</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.REFRESH_MATERIALIZED_VIEW-0" name="UTILS_PKG_S.REFRESH_MATERIALIZED_VIEW-0" class="_link" title="Ссылка на процедуру"></a>
<h5>PROCEDURE REFRESH_MATERIALIZED_VIEW</h5>
<div class="_description">
Обновление материализованного представления
</div>
<div style="display: none;"
class="_full_description"
data-package="UTILS_PKG_S"
data-subprogram="REFRESH_MATERIALIZED_VIEW"
data-object="UTILS_PKG_S.REFRESH_MATERIALIZED_VIEW"
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_VIEW_NAME</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td></td>
<td>Наименования материализованного представления</td>
</tr>
<tr class="removed">
<td>vch_C_METHOD</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td>'C'</td>
<td></td>
</tr>
<tr class="added">
<td>vch_C_METHOD</td>
<td>IN</td>
<td>VARCHAR2</td>
<td>VARCHAR2</td>
<td></td>
<td></td>
</tr>
<tr class="removed">
<td>ch_C_FORCE_REFRESH</td>
<td>IN</td>
<td>CHAR</td>
<td>CHAR</td>
<td>'Y'</td>
<td>'Y' - безусловное обновление<br/>'N' - проверка, не обновляется ли уже представление</td>
</tr>
<tr class="">
<td>b_RetryComplete</td>
<td>IN</td>
<td>CONST.BOOL</td>
<td>NUMBER</td>
<td>CONST.b_FALSE</td>
<td>Обновить представление полностью, если<br/>быстрое обновление не удалось</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_AUTO_TOP_UPS" name="AP_V_AUTO_TOP_UPS" class="_link" title="Ссылка на представление"></a>
<h5>AP_V_AUTO_TOP_UPS</h5>
<div class="_description">Подписки на автоплатеж</div>
<div style="display: none;"
class="_full_description"
data-object="AP_V_AUTO_TOP_UPS"
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_AUTO_TOP_UP_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_RULE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="added">
<td>N_AUTO_TOP_UP_TYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="added">
<td>N_AUTO_TOP_UP_STATE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_ACCOUNT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="added">
<td>VC_EXT_ATU_IDENTIFIER</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>D_VALID_UNTIL</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>N_TOP_UP_SUM</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_MIN_SUM</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_MAX_SUM</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_MAX_SUM_MONTHLY</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_MAX_TXNS_MONTHLY</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_LOW_BALANCE_LIMIT</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_CARD_TYPE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>C_FL_VALID</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="added">
<td>D_TERMS_ACCEPTED</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="removed">
<td>VC_LAST_PAN_DIGITS</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="removed">
<td>C_FL_EXPIRED</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="removed">
<td>C_FL_EXPIRES_IN_MONTH</td>
<td>CHAR</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#AP_V_DISCOUNT_PARAMS_DETAILS" name="AP_V_DISCOUNT_PARAMS_DETAILS" class="_link" title="Ссылка на представление"></a>
<h5>AP_V_DISCOUNT_PARAMS_DETAILS</h5>
<div class="_description">Детализация параметров скидки</div>
<div style="display: none;"
class="_full_description"
data-object="AP_V_DISCOUNT_PARAMS_DETAILS"
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_DISCOUNT_PARAMS_ID</td>
<td>NUMBER</td>
<td>Параметр скидки</td>
</tr>
<tr class="">
<td>N_DISCOUNT_TYPE_ID</td>
<td>NUMBER</td>
<td>Тип скидки</td>
</tr>
<tr class="">
<td>N_DISCOUNT_PERCENT</td>
<td>NUMBER</td>
<td>Процент скидки</td>
</tr>
<tr class="">
<td>N_ALTER_PRICE</td>
<td>NUMBER</td>
<td>Абсолютный размер скидки</td>
</tr>
<tr class="">
<td>N_CURRENCY_ID</td>
<td>NUMBER</td>
<td>Валюта скидки</td>
</tr>
<tr class="added">
<td>N_MAX_TRIGGERS_TOTAL</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_CURRENCY_CODE</td>
<td>VARCHAR2</td>
<td>Код валюты</td>
</tr>
<tr class="">
<td>N_DISCOUNT_ID</td>
<td>NUMBER</td>
<td>Скидка</td>
</tr>
<tr class="">
<td>VC_DISCOUNT_VALUE</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="#AP_V_PERSONAL_ACCOUNTS" name="AP_V_PERSONAL_ACCOUNTS" class="_link" title="Ссылка на представление"></a>
<h5>AP_V_PERSONAL_ACCOUNTS</h5>
<div class="_description">Лицевые счета абонента</div>
<div style="display: none;"
class="_full_description"
data-object="AP_V_PERSONAL_ACCOUNTS"
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>VC_SUBJ_CODE</td>
<td>VARCHAR2</td>
<td>Наименование абонента</td>
</tr>
<tr class="">
<td>VC_SUBJ_NAME</td>
<td>VARCHAR2</td>
<td>Код абонента</td>
</tr>
<tr class="">
<td>N_ACCOUNT_ID</td>
<td>NUMBER</td>
<td>Лицевой счет</td>
</tr>
<tr class="">
<td>N_CURRENCY_ID</td>
<td>NUMBER</td>
<td>Валюта счета</td>
</tr>
<tr class="">
<td>VC_CURRENCY</td>
<td>VARCHAR2</td>
<td>Наименование валюты</td>
</tr>
<tr class="">
<td>VC_CURRENCY_CODE</td>
<td>VARCHAR2</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>VC_ACCOUNT</td>
<td>VARCHAR2</td>
<td>Номер счета</td>
</tr>
<tr class="">
<td>N_OVERDRAFT</td>
<td>NUMBER</td>
<td>Кредитный лимит</td>
</tr>
<tr class="">
<td>D_OVERDRAFT_END</td>
<td>DATE</td>
<td>Срок кредитного лимита</td>
</tr>
<tr class="">
<td>N_PERMANENT_OVERDRAFT</td>
<td>NUMBER</td>
<td>Постоянный кредитный лимит</td>
</tr>
<tr class="">
<td>N_TEMPORAL_OVERDRAFT</td>
<td>NUMBER</td>
<td>Временный кредитный лимит</td>
</tr>
<tr class="">
<td>D_TEMP_OVERDRAFT_END</td>
<td>DATE</td>
<td>Срок временного кредитного лимита</td>
</tr>
<tr class="">
<td>N_SCHED_SERV_OVERDRAFT</td>
<td>NUMBER</td>
<td>Кредит по запланированным услугам</td>
</tr>
<tr class="">
<td>D_SCHED_SERV_OVERDRAFT_END</td>
<td>DATE</td>
<td>Срок кредита по запланированным услугам</td>
</tr>
<tr class="">
<td>N_UNSCHED_SERV_OVERDRAFT</td>
<td>NUMBER</td>
<td>Кредит по незапланированным услугам</td>
</tr>
<tr class="">
<td>D_UNSCHED_SERV_OVERDRAFT_END</td>
<td>DATE</td>
<td>Срок кредита по незапланированным услугам</td>
</tr>
<tr class="">
<td>N_SUM_BAL</td>
<td>NUMBER</td>
<td>Баланс</td>
</tr>
<tr class="">
<td>N_SUM_RESERVED</td>
<td>NUMBER</td>
<td>Сумма резервирования</td>
</tr>
<tr class="">
<td>N_SUM_RESERVED_CUR</td>
<td>NUMBER</td>
<td>Сумма текущего резервирования</td>
</tr>
<tr class="">
<td>N_SUM_FREE</td>
<td>NUMBER</td>
<td>Свободные средства</td>
</tr>
<tr class="">
<td>D_ACCOUNTING_BEGIN</td>
<td>DATE</td>
<td>Дата начала расчетного периода</td>
</tr>
<tr class="">
<td>D_ACCOUNTING_END</td>
<td>DATE</td>
<td>Дата окончания расчетного периода</td>
</tr>
<tr class="">
<td>N_LAST_PAYMENT_SUM</td>
<td>NUMBER</td>
<td>Сумма последнего платежа</td>
</tr>
<tr class="">
<td>D_LAST_PAYMENT</td>
<td>DATE</td>
<td>Дата последнего платежа</td>
</tr>
<tr class="">
<td>VC_LAST_PAYMENT_TYPE</td>
<td>VARCHAR2</td>
<td>Тип последнего платежа</td>
</tr>
<tr class="">
<td>N_LAST_PAYMENT_BANK_ID</td>
<td>NUMBER</td>
<td>Банк последнего платежа</td>
</tr>
<tr class="">
<td>VC_LAST_PAYMENT_BANK</td>
<td>VARCHAR2</td>
<td>Наименование банка последнего платежа</td>
</tr>
<tr class="">
<td>N_RECOMMENDED_PAY</td>
<td>NUMBER</td>
<td>Сумма рекомендуемого платежа</td>
</tr>
<tr class="">
<td>C_FL_PROMISED_PAYMENT</td>
<td>VARCHAR2</td>
<td>Признак доступности обещанного платежа</td>
</tr>
<tr class="added">
<td>N_PROMISED_PAY_SUM</td>
<td>NUMBER</td>
<td>Сумма обещанного платежа</td>
</tr>
<tr class="">
<td>N_CURRENT_PROMISED_PAY_SUM</td>
<td>NUMBER</td>
<td>Сумма действующего обещанного платежа</td>
</tr>
<tr class="">
<td>D_CURRENT_PROMISED_PAY_DAY</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="#RPT_V_USERS" name="RPT_V_USERS" class="_link" title="Ссылка на представление"></a>
<h5>RPT_V_USERS</h5>
<div class="_description">Отчет по абонентам</div>
<div style="display: none;"
class="_full_description"
data-object="RPT_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_USER_ID</td>
<td>NUMBER</td>
<td>Идентификатор абонента</td>
</tr>
<tr class="">
<td>T_CUSTOMER_TAGS</td>
<td>TAGS</td>
<td>Теги абонента</td>
</tr>
<tr class="">
<td>N_BASE_SUBJECT_ID</td>
<td>NUMBER</td>
<td>Идентификатор базового СУ</td>
</tr>
<tr class="">
<td>T_BASE_SUBJECT_TAGS</td>
<td>TAGS</td>
<td>Теги базового СУ</td>
</tr>
<tr class="">
<td>N_SERV_STATE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_FIRM_ID</td>
<td>NUMBER</td>
<td>Идентификатор фирмы</td>
</tr>
<tr class="">
<td>N_USER_STATE_ID</td>
<td>NUMBER</td>
<td>Идентификатор состояния абонента</td>
</tr>
<tr class="">
<td>VC_USER_CODE</td>
<td>VARCHAR2</td>
<td>Краткое наименование абонента</td>
</tr>
<tr class="">
<td>D_CREATED</td>
<td>DATE</td>
<td>Дата создания</td>
</tr>
<tr class="added">
<td>N_RESELLER_ID</td>
<td>NUMBER</td>
<td>Реселлер</td>
</tr>
<tr class="">
<td>N_DEVICE_ID</td>
<td>NUMBER</td>
<td>Идентификатор оборудования</td>
</tr>
<tr class="">
<td>N_DEVICE_STATE_ID</td>
<td>NUMBER</td>
<td>Идентификатор состояния оборудования</td>
</tr>
<tr class="">
<td>VC_DEVICE</td>
<td>VARCHAR2</td>
<td>Наименование оборудования</td>
</tr>
<tr class="">
<td>N_REGION_ID</td>
<td>NUMBER</td>
<td>Идентификатор региона обслуживания</td>
</tr>
<tr class="">
<td>N_ADDRESS_ID</td>
<td>NUMBER</td>
<td>Идентификато адреса обслуживания</td>
</tr>
<tr class="">
<td>N_ENTRANCE_NO</td>
<td>NUMBER</td>
<td>Подъезд</td>
</tr>
<tr class="">
<td>N_FLOOR_NO</td>
<td>NUMBER</td>
<td>Этаж</td>
</tr>
<tr class="">
<td>VC_FLAT</td>
<td>VARCHAR2</td>
<td>Квартира</td>
</tr>
<tr class="">
<td>VC_VISUAL_ADDRESS</td>
<td>VARCHAR2</td>
<td>Полный адрес обслуживания</td>
</tr>
<tr class="">
<td>N_OBJ_ADDR_STATE_ID</td>
<td>NUMBER</td>
<td>Состояние адреса обслуживания</td>
</tr>
<tr class="">
<td>D_OBJ_ADDRESS_BEGIN</td>
<td>DATE</td>
<td>Дата начала действия адреса обслуживания</td>
</tr>
<tr class="">
<td>D_OBJ_ADDRESS_END</td>
<td>DATE</td>
<td>Дата окончания действия адреса обслуживания</td>
</tr>
<tr class="">
<td>N_RESID_NUMBER</td>
<td>NUMBER</td>
<td>Количество жилых помещений</td>
</tr>
<tr class="">
<td>N_NONRESID_NUMBER</td>
<td>NUMBER</td>
<td>Количество нежилых помещений</td>
</tr>
<tr class="">
<td>N_FLOORS_NUMBER</td>
<td>NUMBER</td>
<td>Количество этажей</td>
</tr>
<tr class="">
<td>N_SECTIONS_NUMBER</td>
<td>NUMBER</td>
<td>Количество секций</td>
</tr>
<tr class="">
<td>N_CONTRACT_ID</td>
<td>NUMBER</td>
<td>Идентификатор договора</td>
</tr>
<tr class="">
<td>N_CNTR_STATE_ID</td>
<td>NUMBER</td>
<td>Идентификатор состояние договора</td>
</tr>
<tr class="">
<td>N_BASE_CNTR_ID</td>
<td>NUMBER</td>
<td>Идентификатор базового договора</td>
</tr>
<tr class="">
<td>D_CNTR_DOC</td>
<td>DATE</td>
<td>Дата договора</td>
</tr>
<tr class="">
<td>D_CNTR_BEGIN</td>
<td>DATE</td>
<td>Дата начала срока действия договора</td>
</tr>
<tr class="">
<td>D_CNTR_END</td>
<td>DATE</td>
<td>Дата окончания срока действия договора</td>
</tr>
<tr class="">
<td>VC_CONTRACT_REM</td>
<td>VARCHAR2</td>
<td>Примечание к договору</td>
</tr>
<tr class="">
<td>N_GOOD_ID</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_HIGH_GOOD_GROUP_ID</td>
<td>NUMBER</td>
<td>Группа услуг</td>
</tr>
<tr class="">
<td>D_FIRST_INV_BEGIN</td>
<td>DATE</td>
<td>Дата начала первого инвойса</td>
</tr>
<tr class="">
<td>D_LAST_INV_END</td>
<td>DATE</td>
<td>Дата начала окончания первого инвойса</td>
</tr>
<tr class="">
<td>N_ACCOUNT_ID</td>
<td>NUMBER</td>
<td>Идентификатор счета</td>
</tr>
<tr class="">
<td>VC_ACCOUNT_CODE</td>
<td>VARCHAR2</td>
<td>Код счета</td>
</tr>
<tr class="">
<td>VC_ACCOUNT_NAME</td>
<td>VARCHAR2</td>
<td>Наименование счета</td>
</tr>
<tr class="">
<td>VC_COMMENT</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_SUBJECTS" name="SI_V_SUBJECTS" class="_link" title="Ссылка на представление"></a>
<h5>SI_V_SUBJECTS</h5>
<div class="_description">Субъекты учета</div>
<div style="display: none;"
class="_full_description"
data-object="SI_V_SUBJECTS"
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_SUBJ_TYPE_ID</td>
<td>NUMBER</td>
<td>Идентификатор типа СУ</td>
</tr>
<tr class="">
<td>VC_SUBJ_TYPE_NAME</td>
<td>VARCHAR2</td>
<td>Наименование типа СУ</td>
</tr>
<tr class="">
<td>N_PARENT_SUBJ_ID</td>
<td>NUMBER</td>
<td>Идентификатор вышестоящего СУ</td>
</tr>
<tr class="">
<td>VC_PARENT_SUBJ</td>
<td>VARCHAR2</td>
<td>Наименование вышестоящего СУ</td>
</tr>
<tr class="">
<td>N_SUBJ_STATE_ID</td>
<td>NUMBER</td>
<td>Идентификатор статуса СУ</td>
</tr>
<tr class="">
<td>VC_SUBJ_STATE_NAME</td>
<td>VARCHAR2</td>
<td>Наименование статуса СУ</td>
</tr>
<tr class="">
<td>N_BASE_SUBJECT_ID</td>
<td>NUMBER</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>N_REGION_ID</td>
<td>NUMBER</td>
<td>Идентификатор региона</td>
</tr>
<tr class="">
<td>VC_REGION</td>
<td>VARCHAR2</td>
<td>Наименование региона</td>
</tr>
<tr class="">
<td>N_OWNER_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>D_CREATED</td>
<td>DATE</td>
<td>Дата создания</td>
</tr>
<tr class="">
<td>N_CREATOR_ID</td>
<td>NUMBER</td>
<td>Идентификатор создателя</td>
</tr>
<tr class="">
<td>VC_CREATOR_CODE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_CREATOR_NAME</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>VC_REM</td>
<td>VARCHAR2</td>
<td>Примечание</td>
</tr>
<tr class="">
<td>VC_CODE_UPPER</td>
<td>VARCHAR2</td>
<td>Краткое наименование в верхнем регистре</td>
</tr>
<tr class="">
<td>VC_NAME_UPPER</td>
<td>VARCHAR2</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="">
<td>VC_SUBJ_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_SUBJ_CODE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_SUBJ_CODE_UPPER</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_SUBJ_NAME_UPPER</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_CODE_ADD</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>D_ACTUALIZE</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="added">
<td>N_RESELLER_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="#SI_V_TERM_EQUIP_IP" name="SI_V_TERM_EQUIP_IP" class="_link" title="Ссылка на представление"></a>
<h5>SI_V_TERM_EQUIP_IP</h5>
<div class="_description">Соответствие абонентского оборудования и его IP</div>
<div style="display: none;"
class="_full_description"
data-object="SI_V_TERM_EQUIP_IP"
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_ADDRESS_ID</td>
<td>NUMBER</td>
<td>Идентификатор адреса абонентского оборудования</td>
</tr>
<tr class="">
<td>N_ADDR_TYPE_ID</td>
<td>NUMBER</td>
<td>Идентификатор типа адреса абонентского оборудования</td>
</tr>
<tr class="">
<td>VC_IP</td>
<td>VARCHAR2</td>
<td>IP-адрес абонентского оборудования</td>
</tr>
<tr class="">
<td>N_FIRST_IP</td>
<td>NUMBER</td>
<td>Числовое значение первого IP-адреса в привязанной к оборудованию подсети</td>
</tr>
<tr class="">
<td>N_LAST_IP</td>
<td>NUMBER</td>
<td>Числовое значение последнего IP-адреса в привязанной к оборудованию подсети</td>
</tr>
<tr class="">
<td>VC_FIRST_IP6</td>
<td>VARCHAR2</td>
<td>Строковое значение первого IPv6-адреса в привязанной к оборудованию подсети</td>
</tr>
<tr class="">
<td>VC_LAST_IP6</td>
<td>VARCHAR2</td>
<td>Строковое значение последнего IPv6-адреса в привязанной к оборудованию подсети</td>
</tr>
<tr class="">
<td>N_ADDR_STATE_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>N_MAIN_OBJECT_ID</td>
<td>NUMBER</td>
<td>Идентификатор родительского оборудования по спецификации</td>
</tr>
<tr class="">
<td>VC_MAIN_OBJ_CODE</td>
<td>VARCHAR2</td>
<td>Код родительского оборудования по спецификации</td>
</tr>
<tr class="">
<td>N_MAIN_OBJ_STATE_ID</td>
<td>NUMBER</td>
<td>Идентификатор состояния родительского оборудования по спецификации</td>
</tr>
<tr class="">
<td>N_USE_OBJECT_ID</td>
<td>NUMBER</td>
<td>Идентификатор компонента абонентского оборудования</td>
</tr>
<tr class="">
<td>N_FIRM_ID</td>
<td>NUMBER</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_OBJ_STATE_ID</td>
<td>NUMBER</td>
<td>Состояние абонентского оборудования</td>
</tr>
<tr class="added">
<td>N_GOOD_TYPE_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="#SI_V_USERS" name="SI_V_USERS" class="_link" title="Ссылка на представление"></a>
<h5>SI_V_USERS</h5>
<div class="_description">Абоненты</div>
<div style="display: none;"
class="_full_description"
data-object="SI_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_SUBJ_TYPE_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_BASE_SUBJECT_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_PARENT_SUBJ_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SUBJ_STATE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_OWNER_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_SUBJ_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_SUBJ_CODE</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>VC_SUBJ_CODE_UPPER</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_SUBJ_NAME_UPPER</td>
<td>VARCHAR2</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>D_CREATED</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>N_CREATOR_ID</td>
<td>NUMBER</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>VC_REM</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_FIRM_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_REGION_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>D_ACTUALIZE</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>VC_CODE_ADD</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>N_RESELLER_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>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SI_V_USER_TEL_DETAIL_NEW" name="SI_V_USER_TEL_DETAIL_NEW" class="_link" title="Ссылка на представление"></a>
<h5>SI_V_USER_TEL_DETAIL_NEW</h5>
<div class="_description"></div>
<div style="display: none;"
class="_full_description"
data-object="SI_V_USER_TEL_DETAIL_NEW"
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></td>
</tr>
<tr class="">
<td>N_DOC_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_GM_DOC_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_LINE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_QUANT_MINUTES</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_QUANT_BASE</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_UNIT_BASE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_DURATION_SEC</td>
<td>NUMBER</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>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>VC_UNIT_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_ADDR_CODE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_ADDR_NAME</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_SUM</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SUM_WO_TAX</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_CALC_DESIGN_PROC_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="added">
<td>N_PAR_PRICE_LINE_ID</td>
<td>NUMBER</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>VC_REM</td>
<td>VARCHAR2</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>VC_OBJ_CODE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_CURRENCY</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_CURRENCY_CODE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_DIRECTION_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_DIRECTION</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_FROM</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_TO</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="#SR_V_GOODS" name="SR_V_GOODS" class="_link" title="Ссылка на представление"></a>
<h5>SR_V_GOODS</h5>
<div class="_description">Номенклатура</div>
<div style="display: none;"
class="_full_description"
data-object="SR_V_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_GOOD_ID</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_GOOD_GROUP_ID</td>
<td>NUMBER</td>
<td>Идентификатор группы товаров или услуг</td>
</tr>
<tr class="">
<td>VC_GOOD_GROUP_NAME</td>
<td>VARCHAR2</td>
<td>Наименование группы товаров или услуг</td>
</tr>
<tr class="">
<td>N_BASE_GOOD_ID</td>
<td>NUMBER</td>
<td>Идентификатор базового элемента</td>
</tr>
<tr class="">
<td>VC_GOOD_BASE_NAME</td>
<td>VARCHAR2</td>
<td>Наименование базового элемента</td>
</tr>
<tr class="">
<td>N_PARENT_GOOD_ID</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_CODE</td>
<td>VARCHAR2</td>
<td>Код единицы измерения</td>
</tr>
<tr class="">
<td>VC_UNIT_NAME</td>
<td>VARCHAR2</td>
<td>Наименование единицы измерения</td>
</tr>
<tr class="">
<td>VC_GOOD_CODE</td>
<td>VARCHAR2</td>
<td>Код</td>
</tr>
<tr class="">
<td>VC_GOOD_NAME</td>
<td>VARCHAR2</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>VC_GOOD_TYPE_CODE</td>
<td>VARCHAR2</td>
<td>Код типа товара или услуги</td>
</tr>
<tr class="">
<td>VC_GOOD_TYPE_NAME</td>
<td>VARCHAR2</td>
<td>Наименование типа товара или услуги</td>
</tr>
<tr class="">
<td>VC_REM</td>
<td>VARCHAR2</td>
<td>Комментарий</td>
</tr>
<tr class="">
<td>C_ACTIVE</td>
<td>CHAR</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_SUBJECT_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="">
<td>N_QUANT</td>
<td>NUMBER</td>
<td>Количество</td>
</tr>
<tr class="">
<td>N_QUANT_INIT</td>
<td>NUMBER</td>
<td>Количество, инициализируемое по-умолчанию</td>
</tr>
<tr class="">
<td>C_CAN_MODIFY</td>
<td>CHAR</td>
<td>Флаг возможности изменения</td>
</tr>
<tr class="">
<td>C_FL_CAN_OBJECT</td>
<td>CHAR</td>
<td>Флаг возможности быть объектом</td>
</tr>
<tr class="">
<td>VC_BORDER_COLOR</td>
<td>VARCHAR2</td>
<td>Цвет бордюра</td>
</tr>
<tr class="">
<td>VC_FILL_COLOR</td>
<td>VARCHAR2</td>
<td>Цвет заливки</td>
</tr>
<tr class="">
<td>N_LINE_NO</td>
<td>NUMBER</td>
<td>Номер строки спецификации</td>
</tr>
<tr class="">
<td>N_GOOD_BRANCH_ID</td>
<td>NUMBER</td>
<td>Идентификатор ветки номенклатуры</td>
</tr>
<tr class="">
<td>N_SERV_SCHEME_ID</td>
<td>NUMBER</td>
<td>Схема оказания услуг</td>
</tr>
<tr class="">
<td>N_GOOD_KIND_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="added">
<td>C_FL_PROVIDER_EQUIPMENT</td>
<td>CHAR</td>
<td>Признак возможности использования позиции для создания операторского оборудования</td>
</tr>
<tr class="added">
<td>C_FL_CUSTOMER_EQUIPMENT</td>
<td>CHAR</td>
<td>Признак возможности использования позиции для создания абонентского оборудования</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SS_V_AUTO_TOP_UP_RULES" name="SS_V_AUTO_TOP_UP_RULES" class="_link" title="Ссылка на представление"></a>
<h5>SS_V_AUTO_TOP_UP_RULES</h5>
<div class="_description">Правила автоплатежей</div>
<div style="display: none;"
class="_full_description"
data-object="SS_V_AUTO_TOP_UP_RULES"
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_RULE_ID</td>
<td>NUMBER</td>
<td>Идентификатор</td>
</tr>
<tr class="">
<td>N_FIRM_ID</td>
<td>NUMBER</td>
<td>Фирма</td>
</tr>
<tr class="">
<td>N_BANK_ID</td>
<td>NUMBER</td>
<td>Банк/платежная система</td>
</tr>
<tr class="">
<td>N_CONDITION_ID</td>
<td>NUMBER</td>
<td>Условие автоплатежа</td>
</tr>
<tr class="">
<td>N_WINDOW_DAYS_BACKWARD</td>
<td>NUMBER</td>
<td>Окно поиска автоплатежей (дней до)</td>
</tr>
<tr class="">
<td>N_WINDOW_DAYS_FORWARD</td>
<td>NUMBER</td>
<td>Окно поиска автоплатежей (дней после)</td>
</tr>
<tr class="">
<td>N_CHARGE_DELAY_HOURS</td>
<td>NUMBER</td>
<td>Интервал до списания, часы</td>
</tr>
<tr class="">
<td>N_CURRENCY_ID</td>
<td>NUMBER</td>
<td>Валюта</td>
</tr>
<tr class="">
<td>N_MIN_SUM</td>
<td>NUMBER</td>
<td>Минимальная сумма списания</td>
</tr>
<tr class="">
<td>N_MAX_SUM</td>
<td>NUMBER</td>
<td>Максимальная сумма списания</td>
</tr>
<tr class="">
<td>N_MAX_SUM_MONTHLY</td>
<td>NUMBER</td>
<td>Максимальная сумма списания за календарный месяц</td>
</tr>
<tr class="">
<td>N_MAX_TXNS_MONTHLY</td>
<td>NUMBER</td>
<td>Максимальное количество успешных запросов за календарный месяц</td>
</tr>
<tr class="">
<td>N_MAX_FAILED_ATTEMPTS</td>
<td>NUMBER</td>
<td>Максимальное количество неуспешных попыток списания подряд</td>
</tr>
<tr class="">
<td>N_ATTEMPT_INTERVAL_DAYS</td>
<td>NUMBER</td>
<td>Интервал между попытками списания</td>
</tr>
<tr class="">
<td>T_CUSTOMER_TAGS</td>
<td>TAGS</td>
<td>Теги абонентов</td>
</tr>
<tr class="">
<td>N_MAX_INVALID_TOP_UPS</td>
<td>NUMBER</td>
<td>Максимальное количество внутренних ошибок списания подряд</td>
</tr>
<tr class="added">
<td>VC_REM</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_V_JOB_SEANCES" name="SS_V_JOB_SEANCES" class="_link" title="Ссылка на представление"></a>
<h5>SS_V_JOB_SEANCES</h5>
<div class="_description">Сеансы обмена данными</div>
<div style="display: none;"
class="_full_description"
data-object="SS_V_JOB_SEANCES"
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_JOB_SEANCE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_JOB_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_JOB_STATUS</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_JOB_STATUS</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_SESSION_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>D_START</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>D_FINISH</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>C_REASON</td>
<td>CHAR</td>
<td></td>
</tr>
<tr class="">
<td>VC_REASON</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_TIME_DIFF</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_MESSAGE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_SJOB</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SPID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_SERIAL</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="added">
<td>C_FL_INTERRUPTED</td>
<td>CHAR</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="changed">
<a href="#SS_V_MANAGER_JOBS" name="SS_V_MANAGER_JOBS" class="_link" title="Ссылка на представление"></a>
<h5>SS_V_MANAGER_JOBS</h5>
<div class="_description"></div>
<div style="display: none;"
class="_full_description"
data-object="SS_V_MANAGER_JOBS"
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_ORACLE_JOB</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>D_LAST_DATE</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>D_THIS_DATE</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>D_NEXT_DATE</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>C_FL_BROKEN</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_FAILURES</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_TOTAL_TIME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_SPID</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_SID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_SERIAL</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SECONDS_IN_WAIT</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_STATE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="added">
<td>VC_CLIENT_INFO</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="added">
<td>VC_MODULE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="added">
<td>VC_ACTION</td>
<td>VARCHAR2</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#AP_V_EQUIPMENT_ADDRESSES" name="AP_V_EQUIPMENT_ADDRESSES" class="_link" title="Ссылка на представление"></a>
<h5>AP_V_EQUIPMENT_ADDRESSES</h5>
<div class="_description"></div>
<div style="display: none;"
class="_full_description"
data-object="AP_V_EQUIPMENT_ADDRESSES"
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_EQUIP_ADDR_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>C_FL_MAIN</td>
<td>CHAR</td>
<td></td>
</tr>
<tr class="">
<td>N_OBJECT_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>VC_VISUAL_CODE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_ADDR_TYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#EP_V_SESSIONS_SIMPLE" name="EP_V_SESSIONS_SIMPLE" class="_link" title="Ссылка на представление"></a>
<h5>EP_V_SESSIONS_SIMPLE</h5>
<div class="_description">Sessions</div>
<div style="display: none;"
class="_full_description"
data-object="EP_V_SESSIONS_SIMPLE"
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></td>
</tr>
<tr class="">
<td>N_TYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_STATE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_EXT_ID</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_EXT_UNIQ_ID</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_TERMINATION_CODE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_CUSTOMER_EQUIPMENT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_PROVIDER_EQUIPMENT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_EQUIPMENT_BIND_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_START_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_START_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>T_CUST_CHILD_PROFILE_IDS</td>
<td>NUMBER_TABLE</td>
<td></td>
</tr>
<tr class="">
<td>N_PREV_CUSTOMER_PROFILE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>T_PREV_CHILD_PROFILE_IDS</td>
<td>NUMBER_TABLE</td>
<td></td>
</tr>
<tr class="">
<td>N_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_PREV_PROVIDER_PROFILE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>D_START</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>D_FINISH</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>D_LAST_UPD</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>D_LAST_LOAD</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>C_FL_KILLED</td>
<td>CHAR</td>
<td></td>
</tr>
<tr class="">
<td>T_ATTRIBUTES</td>
<td>KEY_VALUE_TABLE</td>
<td></td>
</tr>
<tr class="">
<td>N_FIRM_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_SRC_APP</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_LOAD_SEANCE_ID</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_SCN</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SERVICE_PROFILE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>D_ARCHIVED</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>VC_PAR_EXT_UNIQ_ID</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_UPDATE_SEANCE_ID</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>C_FL_CLOSED</td>
<td>CHAR</td>
<td></td>
</tr>
<tr class="">
<td>VC_CACHE_ID</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_COMMAND_REPEATS</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>D_ALTER_COMMAND_SENT</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>N_ALTER_COMMAND_SCN</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SUBSCRIPTION_EQUIPMENT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#RP_V_ALL_PROFILES" name="RP_V_ALL_PROFILES" class="_link" title="Ссылка на представление"></a>
<h5>RP_V_ALL_PROFILES</h5>
<div class="_description">Профили</div>
<div style="display: none;"
class="_full_description"
data-object="RP_V_ALL_PROFILES"
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_PROFILE_ID</td>
<td>NUMBER</td>
<td>Профиль</td>
</tr>
<tr class="">
<td>N_TEMPLATE_ID</td>
<td>NUMBER</td>
<td>Шаблон профиля</td>
</tr>
<tr class="">
<td>VC_TEMPLATE</td>
<td>VARCHAR2</td>
<td>Наименование шаблон профиля</td>
</tr>
<tr class="">
<td>N_TEMPLATE_TYPE_ID</td>
<td>NUMBER</td>
<td>Тип шаблона</td>
</tr>
<tr class="">
<td>N_PAR_TEMPLATE_ID</td>
<td>NUMBER</td>
<td>Родительский шаблон</td>
</tr>
<tr class="">
<td>N_FIRM_ID</td>
<td>NUMBER</td>
<td>Фирма</td>
</tr>
<tr class="">
<td>VC_CONTEXT</td>
<td>VARCHAR2</td>
<td>Контекст профиля</td>
</tr>
<tr class="">
<td>VC_PAR_CONTEXT</td>
<td>VARCHAR2</td>
<td>Контекст родительского профиля</td>
</tr>
<tr class="">
<td>N_SUBSCRIPTION_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_NAME</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_NAME</td>
<td>VARCHAR2</td>
<td>Наименование услуги</td>
</tr>
<tr class="">
<td>N_CONTRACT_ID</td>
<td>NUMBER</td>
<td>Договор</td>
</tr>
<tr class="">
<td>VC_CONTRACT_NAME</td>
<td>VARCHAR2</td>
<td>Наименование договора</td>
</tr>
<tr class="">
<td>N_CHARGE_LOG_ID</td>
<td>NUMBER</td>
<td>Инвойс</td>
</tr>
<tr class="">
<td>VC_CHARGE_LOG_NO</td>
<td>VARCHAR2</td>
<td>Номер инвойса</td>
</tr>
<tr class="">
<td>T_ATTRIBUTES</td>
<td>PROFILE_ATTRS</td>
<td>Атрибуты профиля</td>
</tr>
<tr class="">
<td>N_TIME_INTERVAL_ID</td>
<td>NUMBER</td>
<td>Временной интервал</td>
</tr>
<tr class="">
<td>N_SCN</td>
<td>NUMBER</td>
<td>Версия</td>
</tr>
<tr class="">
<td>N_CREATED_SCN</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>TS_CREATED</td>
<td>TIMESTAMP(6)</td>
<td></td>
</tr>
<tr class="">
<td>C_FL_CURRENT</td>
<td>VARCHAR2</td>
<td>Флаг текущего профиля</td>
</tr>
<tr class="">
<td>N_CURRENT_SERVICE_STATE_ID</td>
<td>NUMBER</td>
<td>Текущее состояние услуги</td>
</tr>
<tr class="">
<td>VC_CURRENT_SERVICE_STATE</td>
<td>VARCHAR2</td>
<td>Наименование текущего состояния услуги</td>
</tr>
<tr class="">
<td>N_EQUIPMENT_ID</td>
<td>NUMBER</td>
<td>Оборудование</td>
</tr>
<tr class="">
<td>C_FL_VALID</td>
<td>CHAR</td>
<td>Флаг валидности профиля</td>
</tr>
<tr class="">
<td>T_CHILD_PROFILE_IDS</td>
<td>NUMBER_TABLE</td>
<td></td>
</tr>
<tr class="">
<td>C_ACTIVE</td>
<td>CHAR</td>
<td>Признак активности</td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SD_V_CL_RECEIVABLES_DETAILS" name="SD_V_CL_RECEIVABLES_DETAILS" class="_link" title="Ссылка на представление"></a>
<h5>SD_V_CL_RECEIVABLES_DETAILS</h5>
<div class="_description"></div>
<div style="display: none;"
class="_full_description"
data-object="SD_V_CL_RECEIVABLES_DETAILS"
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_RECEIVABLE_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_RECEIVABLE_DOC_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_RECEIVABLE_DOC</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_STATE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_STATE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_RECEIVABLE_AMOUNT</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_MATCHING_AMOUNT</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_REQUIRED_AMOUNT</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>D_DUE</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>N_PAYMENT_CURRENCY_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_PAYMENT_CURRENCY</td>
<td>VARCHAR2</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SD_V_RCVBLS_MATCHING_DETAILS" name="SD_V_RCVBLS_MATCHING_DETAILS" class="_link" title="Ссылка на представление"></a>
<h5>SD_V_RCVBLS_MATCHING_DETAILS</h5>
<div class="_description"></div>
<div style="display: none;"
class="_full_description"
data-object="SD_V_RCVBLS_MATCHING_DETAILS"
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_ACCOUNT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_CONTRACT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_RECEIVABLE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_RECEIVABLE_DOC_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_RECEIVABLE_DOC</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</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_STATE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_STATE</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_RECEIVABLE_AMOUNT</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>D_RECEIVABLE_BEGIN</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>D_RECEIVABLE_END</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>D_DUE</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>N_REQUIRED_AMOUNT</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_MATCHING_AMOUNT</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_PAYMENT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_PAYMENT_DOC</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_PAYMENT_AMOUNT</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_PAYMENT_CURRENCY_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_PAYMENT_CURRENCY</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>D_PAYMENT</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>D_OPER</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>N_MATCH_REASON_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_MATCHING_DOC_TYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SI_V_REFDEPEND_SUBJ_STATES" name="SI_V_REFDEPEND_SUBJ_STATES" class="_link" title="Ссылка на представление"></a>
<h5>SI_V_REFDEPEND_SUBJ_STATES</h5>
<div class="_description"></div>
<div style="display: none;"
class="_full_description"
data-object="SI_V_REFDEPEND_SUBJ_STATES"
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_REF_DEPEND_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SUBJ_TYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SUBJ_STATE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_LINE_NO</td>
<td>NUMBER</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SI_V_RESELLERS" name="SI_V_RESELLERS" class="_link" title="Ссылка на представление"></a>
<h5>SI_V_RESELLERS</h5>
<div class="_description"></div>
<div style="display: none;"
class="_full_description"
data-object="SI_V_RESELLERS"
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_RESELLER_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_COLLECTION_FEE_FIXED</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_CURRENCY_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_CURRENCY</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_COLLECTION_FEE_PERCENT</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SUBJECT_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SUBJ_TYPE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_PARENT_SUBJ_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SUBJ_STATE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_SUBJ_STATE_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_BASE_SUBJECT_ID</td>
<td>NUMBER</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>N_REGION_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_REGION</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_OWNER_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>D_CREATED</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>D_ACTUALIZE</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>N_CREATOR_ID</td>
<td>NUMBER</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>T_TAGS</td>
<td>TAGS</td>
<td></td>
</tr>
<tr class="">
<td>VC_TAGS</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_REM</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_CODE_UPPER</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_NAME_UPPER</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_SUBJ_CODE_UPPER</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_SUBJ_NAME_UPPER</td>
<td>VARCHAR2</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>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SI_V_RESELLERS_JR" name="SI_V_RESELLERS_JR" class="_link" title="Ссылка на представление"></a>
<h5>SI_V_RESELLERS_JR</h5>
<div class="_description"></div>
<div style="display: none;"
class="_full_description"
data-object="SI_V_RESELLERS_JR"
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_SUBJ_TYPE_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>N_PARENT_SUBJ_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_SUBJ_STATE_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_SUBJ_STATE_NAME</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>N_OWNER_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>VC_SUBJ_CODE_UPPER</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>VC_SUBJ_NAME_UPPER</td>
<td>VARCHAR2</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>D_CREATED</td>
<td>DATE</td>
<td></td>
</tr>
<tr class="">
<td>N_CREATOR_ID</td>
<td>NUMBER</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>VC_REM</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>N_REGION_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>VC_REGION</td>
<td>VARCHAR2</td>
<td></td>
</tr>
<tr class="">
<td>D_ACTUALIZE</td>
<td>DATE</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>
</tbody>
</table>
</div>
</li>
<li onclick="jQuery(this).find('._full_description').toggle('blind', 'fast')" class="added">
<a href="#SI_V_SERVICE_COMMISSIONS" name="SI_V_SERVICE_COMMISSIONS" class="_link" title="Ссылка на представление"></a>
<h5>SI_V_SERVICE_COMMISSIONS</h5>
<div class="_description"></div>
<div style="display: none;"
class="_full_description"
data-object="SI_V_SERVICE_COMMISSIONS"
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_COMMISSION_ID</td>
<td>NUMBER</td>
<td></td>
</tr>
<tr class="">
<td>N_RESELLER_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_INFRASTRUCT_FEE_PERCENT</td>
<td>NUMBER</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</li>
</ul>
</div>
</div>
</div>
|