| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_LINE_ID | OUT | EX_DATA_COLLECT.N_LINE_ID%TYPE | NUMBER | ID of a line | |
| num_N_SERVICE_ID | IN | EX_DATA_COLLECT.N_SERVICE_ID%TYPE | NUMBER | Network service | |
| num_N_TYPE_ID | IN | EX_DATA_COLLECT.N_TYPE_ID%TYPE | NUMBER | CONST.DATA_COL_TYPE_Cumulative | Line type |
| num_N_FIRM_ID | IN | EX_DATA_COLLECT.N_FIRM_ID%TYPE | NUMBER | SYS_CONTEXT('MAIN' 'N_FIRM_ID') | Division |
| num_N_GOOD_ID | IN | EX_DATA_COLLECT.N_GOOD_ID%TYPE | NUMBER | NULL | Service |
| num_N_OBJECT_ID | IN | EX_DATA_COLLECT.N_OBJECT_ID%TYPE | NUMBER | NULL | Equipment |
| num_N_USER_ID | IN | EX_DATA_COLLECT.N_USER_ID%TYPE | NUMBER | NULL | Customer |
| vch_VC_EXT_ID | IN | EX_DATA_COLLECT.VC_EXT_ID%TYPE | VARCHAR2 | NULL | External ID |
| dt_D_BEGIN | IN | EX_DATA_COLLECT.D_BEGIN%TYPE | DATE | NULL | Statistics collection period start date |
| dt_D_END | IN | EX_DATA_COLLECT.D_END%TYPE | DATE | NULL | Statistics collection period end date |
| num_N_QUANT_OPER | IN | EX_DATA_COLLECT.N_QUANT_OPER%TYPE | NUMBER | Quantity | |
| num_N_UNIT_ID | IN | EX_DATA_COLLECT.N_UNIT_ID%TYPE | NUMBER | CONST.UNIT_Byte | Unit |
| num_N_CDR_ID | IN | EX_DATA_COLLECT.N_CDR_ID%TYPE | NUMBER | NULL | CDR |
| vch_VC_EXT_SERVICE | IN | EX_DATA_COLLECT.VC_EXT_SERVICE%TYPE | VARCHAR2 | NULL | External code of service |
| num_N_ACCOUNT_ID | IN | EX_DATA_COLLECT.N_ACCOUNT_ID%TYPE | NUMBER | NULL | Account ID |
| b_ResetQuantOnInsert | IN | MAIN.BOOL | NUMBER | MAIN.b_FALSE | Reset quantity upon inserting a new line? Used for cumulative updates {*} CONST.b_TRUE — quantity is set to 0 upon inserting a line into the table {*} CONST.b_FALSE — quantity is set to a value received |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_OBJECT_ID | IN | RG_GOOD_MOVES_T.N_OBJECT_ID%TYPE | NUMBER | ||
| num_N_SERVICE_ID | IN | RG_GOOD_MOVES_T.N_SERVICE_ID%TYPE | NUMBER | ||
| dt_D_BEGIN | IN | RG_GOOD_MOVES_T.D_CHARGE_LOG_BEGIN%TYPE | DATE | ||
| num_N_FIRM_ID | IN | RG_GOOD_MOVES_T.N_FIRM_ID%TYPE | NUMBER | ||
| RETURN RG_GOOD_MOVES_T.N_ACCOUNT_ID%TYPE | |||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| clb_CL_DATA | IN | CLOB | CLOB | Data to load | |
| num_N_SERVICE_ID | IN | SR_GOODS.N_GOOD_ID%TYPE | NUMBER | Customer equipment type | |
| num_N_GOOD_SPEC_ID | IN | SR_GOODS.N_GOOD_ID%TYPE | NUMBER | Customer equipment specification | |
| num_N_BASE_CONTRACT_ID | IN | SD_DOCUMENTS.N_DOC_ID%TYPE | NUMBER | Basic contract | |
| vch_VC_CONTRACT_MASK | IN | VARCHAR2 | VARCHAR2 | '^.+$' | Customer contract mask |
| vch_VC_CONTRACT_MASK | IN | VARCHAR2 | VARCHAR2 | '.*' | Customer contract mask |
| num_ErrorsLimit | IN | NUMBER | NUMBER | 10 | Maximum number of errors tolerated |
| vch_VC_FIELD_SEPARATOR | IN | VARCHAR2 | VARCHAR2 | ';' | CSV field separator |
| vch_VC_PHONE_SEPARATOR | IN | VARCHAR2 | VARCHAR2 | ' ' | Phone numbers list separator |
| b_SKIP_HEADER | IN | CONST.BOOL | NUMBER | CONST.b_FALSE | |
| b_WO_TARIFF | IN | MAIN.BOOL | NUMBER | MAIN.b_FALSE | Skip subscriptions? |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| clb_CL_DATA | IN | CLOB | CLOB | Data to load | |
| num_N_DEFAULT_REGION_ID | IN | SR_REGIONS.N_REGION_ID%TYPE | NUMBER | Default region | |
| num_N_REALTY_GOOD_ID | IN | SR_GOODS.N_GOOD_ID%TYPE | NUMBER | SS_CONSTANTS_PKG_S.REALTY_House | Product catalog position for realty |
| num_N_REALTY_GOOD_ID | IN | SR_GOODS.N_GOOD_ID%TYPE | NUMBER | CONST.REALTY_House | Product catalog position for realty |
| num_ErrorsLimit | IN | NUMBER | NUMBER | 10 | Maximum number of errors tolerated |
| vch_VC_FIELD_SEPARATOR | IN | VARCHAR2 | VARCHAR2 | ';' | CSV field separator |
| b_SKIP_HEADER | IN | CONST.BOOL | NUMBER | CONST.b_FALSE |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_DEFAULT_REGION_ID | IN | SR_REGIONS.N_REGION_ID%TYPE | NUMBER | Default region | |
| vch_VC_EXT_ID | IN | VARCHAR2 | VARCHAR2 | NULL | External ID |
| vch_VC_DISTRICT | IN | VARCHAR2 | VARCHAR2 | NULL | District |
| vch_VC_CITY | IN | VARCHAR2 | VARCHAR2 | NULL | City |
| vch_VC_CITY_TYPE | IN | VARCHAR2 | VARCHAR2 | NULL | City type |
| vch_VC_INNER_CITY | IN | VARCHAR2 | VARCHAR2 | NULL | Town |
| vch_VC_INNER_CITY_TYPE | IN | VARCHAR2 | VARCHAR2 | NULL | Town type |
| vch_VC_CITY_CODE | IN | VARCHAR2 | VARCHAR2 | NULL | City code as in an external classifier |
| vch_VC_STREET | IN | VARCHAR2 | VARCHAR2 | NULL | Street |
| vch_VC_STREET_TYPE | IN | VARCHAR2 | VARCHAR2 | NULL | Street type |
| vch_VC_STREET_CODE | IN | VARCHAR2 | VARCHAR2 | NULL | Street code as in an external classifier |
| vch_VC_BUILDING | IN | VARCHAR2 | VARCHAR2 | NULL | Building |
| vch_VC_BUILDING_CODE | IN | VARCHAR2 | VARCHAR2 | NULL | Building code as in an external classifier |
| vch_VC_POST_INDEX | IN | VARCHAR2 | VARCHAR2 | NULL | ZIP code |
| vch_VC_HIERARCHY_BIND | IN | VARCHAR2 | VARCHAR2 | NULL | Municipal hierarchy bind |
| vch_VC_MUNICIPAL_TYPE | IN | VARCHAR2 | VARCHAR2 | NULL | Municipal hierarchy bind type |
| vch_VC_PAR_HIERARCHY_BIND | IN | VARCHAR2 | VARCHAR2 | NULL | Parent municipal hierarchy bind |
| vch_VC_MUNICIPAL_PAR_TYPE | IN | VARCHAR2 | VARCHAR2 | NULL | Parent municipal hierarchy bind type |
| num_N_CITY_ID | OUT | SR_REGIONS.N_REGION_ID%TYPE | NUMBER | City | |
| num_N_INNER_CITY_ID | OUT | SR_REGIONS.N_REGION_ID%TYPE | NUMBER | Town | |
| num_N_STREET_ID | OUT | SR_REGIONS.N_REGION_ID%TYPE | NUMBER | Street | |
| num_N_BUILDING_ID | OUT | SR_REGIONS.N_REGION_ID%TYPE | NUMBER | Building |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| clb_CL_DATA | IN | CLOB | CLOB | Data to load | |
| num_N_OBJECT_GOOD_ID | IN | SR_GOODS.N_GOOD_ID%TYPE | NUMBER | Customer equipment type | |
| num_N_SERVICE_ID | IN | SR_GOODS.N_GOOD_ID%TYPE | NUMBER | Customer equipment type | |
| num_N_BASE_CONTRACT_ID | IN | SD_DOCUMENTS.N_DOC_ID%TYPE | NUMBER | Basic contract | |
| vch_VC_CONTRACT_MASK | IN | VARCHAR2 | VARCHAR2 | '.*' | Customer contract mask |
| vch_VC_CONTRACT_MASK | IN | VARCHAR2 | VARCHAR2 | '^.+$' | Customer contract mask |
| num_ErrorsLimit | IN | NUMBER | NUMBER | 10 | Maximum number of errors tolerated |
| vch_VC_FIELD_SEPARATOR | IN | VARCHAR2 | VARCHAR2 | ';' | CSV field separator |
| b_SKIP_HEADER | IN | CONST.BOOL | NUMBER | CONST.b_FALSE |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_SUBJECT_TYPE_ID | IN | SI_SUBJECTS.N_SUBJ_TYPE_ID%TYPE | NUMBER | Subject type | |
| clb_CL_DATA | IN | CLOB | CLOB | Data to load | |
| num_ErrorsLimit | IN | NUMBER | NUMBER | 10 | Maximum number of errors tolerated |
| num_N_REGION_ID | IN | SI_SUBJECTS.N_REGION_ID%TYPE | NUMBER | NULL | Region |
| vch_VC_FIELD_SEPARATOR | IN | VARCHAR2 | VARCHAR2 | ';' | CSV field separator |
| b_SKIP_HEADER | IN | CONST.BOOL | NUMBER | CONST.b_FALSE |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| clb_CL_DATA | IN | CLOB | CLOB | Data to load | |
| num_N_OWNER_ID | IN | SI_SUBJECTS.N_OWNER_ID%TYPE | NUMBER | Owner | |
| num_N_SERVICE_ID | IN | SI_SUBJ_SERVICES.N_SERVICE_ID%TYPE | NUMBER | Network service | |
| num_N_DEFAULT_REGION_ID | IN | SR_REGIONS.N_REGION_ID%TYPE | NUMBER | MAIN.GET_N_REGION_ID | Default region |
| b_InitializeContent | IN | MAIN.BOOL | NUMBER | Initialize ports? | |
| num_ErrorsLimit | IN | NUMBER | NUMBER | 10 | Maximum number of errors tolerated |
| vch_VC_FIELD_SEPARATOR | IN | VARCHAR2 | VARCHAR2 | ';' | CSV field separator |
| b_SKIP_HEADER | IN | CONST.BOOL | NUMBER | CONST.b_FALSE |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_DOC_ID | IN/OUT | SD_DOCUMENTS.N_DOC_ID%TYPE | NUMBER | Document | |
| num_N_PARENT_DOC_ID | IN | SD_DOCUMENTS.N_PARENT_DOC_ID%TYPE | NUMBER | NULL | Parent document — basic contract for providing services by cards |
| num_N_REASON_DOC_ID | IN | SD_DOCUMENTS.N_REASON_DOC_ID%TYPE | NUMBER | NULL | Reason document (currently not in use) |
| dt_D_DOC | IN | SD_DOCUMENTS.D_DOC%TYPE | DATE | NULL | Document date |
| dt_D_TIME | IN | SD_DOCUMENTS.D_TIME%TYPE | DATE | NULL | Document date with time |
| vch_VC_DOC_NO | IN | SD_DOCUMENTS.VC_DOC_NO%TYPE | VARCHAR2 | NULL | Document no |
| dt_D_BEGIN | IN | SD_DOCUMENTS.D_BEGIN%TYPE | DATE | NULL | Document start date |
| dt_D_END | IN | SD_DOCUMENTS.D_END%TYPE | DATE | NULL | Document end date |
| vch_VC_REM | IN | SD_DOCUMENTS.VC_REM%TYPE | VARCHAR2 | NULL | Remark |
| num_N_GOOD_ID | IN | SD_CARDS_ISSUE_T.N_GOOD_ID%TYPE | NUMBER | Voucher type id from the product catalog | |
| num_N_APPLICATION_ID | IN | SD_CARDS_ISSUE_T.N_APPLICATION_ID%TYPE | NUMBER | Self Care Portal application | |
| vch_VC_SERIAL | IN | SD_CARDS_ISSUE_T.VC_SERIAL%TYPE | VARCHAR2 | NULL | Serial number (currently not in use) |
| num_N_BEGIN_NUMBER | IN | SD_CARDS_ISSUE_T.N_BEGIN_NUMBER%TYPE | NUMBER | NULL | Voucher number range start |
| num_N_END_NUMBER | IN | SD_CARDS_ISSUE_T.N_END_NUMBER%TYPE | NUMBER | NULL | Voucher number range end |
| ch_C_FL_PAYMENTS | IN | SD_CARDS_ISSUE_T.C_FL_PAYMENTS%TYPE | CHAR | Can use vouchers to top up accounts? | |
| ch_C_FL_SERVS | IN | SD_CARDS_ISSUE_T.C_FL_SERVS%TYPE | CHAR | Can use vouchers to consume services? | |
| num_N_FACE_VALUE | IN | SD_CARDS_ISSUE_T.N_FACE_VALUE%TYPE | NUMBER | Face value of vouchers | |
| num_N_CURRENCY_ID | IN | SD_CARDS_ISSUE_T.N_CURRENCY_ID%TYPE | NUMBER | Currency (REF_TYPE_Currency reference) | |
| num_N_AFTER_ACTIVATE_DAYS | IN | SD_CARDS_ISSUE_T.N_AFTER_ACTIVATE_DAYS%TYPE | NUMBER | Validity period after activation, days | |
| num_N_WORKFLOW_ID | IN | SD_DOCUMENTS.N_WORKFLOW_ID%TYPE | NUMBER | Workflow | |
| num_N_ACTIVATION_TYPE_ID | IN | SD_CARDS_ISSUE_T.N_ACTIVATION_TYPE_ID%TYPE | NUMBER | Activation type (REF_TYPE_Card_Act_Type reference) | |
| num_N_PIN_LENGTH | IN | SD_CARDS_ISSUE_T.N_PIN_LENGTH%TYPE | NUMBER | PIN-code length | |
| num_N_NET_SERVICE_ID | IN | SD_CARDS_ISSUE_T.N_NET_SERVICE_ID%TYPE | NUMBER | NULL | Net service identificator |
| ch_C_PIN_FORMAT | IN | SD_CARDS_ISSUE_T.C_PIN_FORMAT%TYPE | CHAR | PIN-code format: {*} 'N' — numeric PIN {*} 'A' — PIN consisting of letters only {*} 'L' — PIN consisting of lowercase letters only {*} 'U' — PIN consisting of uppercase letters only {*} 'X' — PIN consisting of numbers and uppercase letters |
|
| num_N_FIRM_ID | IN | SD_DOCUMENTS.N_FIRM_ID%TYPE | NUMBER | SYS_CONTEXT('MAIN' 'N_FIRM_ID') | |
| tbl_T_TAGS | IN | TAGS | TABLE | TAGS() | Tags |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_DOC_ID | IN/OUT | SD_DOCUMENTS.N_DOC_ID%TYPE | NUMBER | Document | |
| num_N_DOC_TYPE_ID | IN | SD_DOCUMENTS.N_DOC_TYPE_ID%TYPE | NUMBER | Document type (REF_TYPE_Document_Type reference data) | |
| num_N_FIRM_ID | IN | SD_DOCUMENTS.N_FIRM_ID%TYPE | NUMBER | NULL | Division |
| num_N_PARENT_DOC_ID | IN | SD_DOCUMENTS.N_PARENT_DOC_ID%TYPE | NUMBER | NULL | Parent document |
| num_N_REASON_DOC_ID | IN | SD_DOCUMENTS.N_REASON_DOC_ID%TYPE | NUMBER | NULL | Reason document |
| num_N_PREV_DOC_ID | IN | SD_DOCUMENTS.N_PREV_DOC_ID%TYPE | NUMBER | NULL | Original document the current document is copied from |
| num_N_STORNO_DOC_ID | IN | SD_DOCUMENTS.N_STORNO_DOC_ID%TYPE | NUMBER | NULL | Document that was reversed by the current one |
| dt_D_DOC | IN | SD_DOCUMENTS.D_DOC%TYPE | DATE | NULL | Document date |
| dt_D_TIME | IN | SD_DOCUMENTS.D_TIME%TYPE | DATE | NULL | Document time |
| vch_VC_DOC_NO | IN | SD_DOCUMENTS.VC_DOC_NO%TYPE | VARCHAR2 | NULL | Document number |
| vch_VC_NAME | IN | SD_DOCUMENTS.VC_NAME%TYPE | VARCHAR2 | NULL | Document name |
| vch_VC_CODE | IN | SD_DOCUMENTS.VC_CODE%TYPE | VARCHAR2 | NULL | Document code |
| vch_VC_REM | IN | SD_DOCUMENTS.VC_REM%TYPE | VARCHAR2 | NULL | Remark |
| dt_D_BEGIN | IN | SD_DOCUMENTS.D_BEGIN%TYPE | DATE | NULL | Document period start date |
| dt_D_END | IN | SD_DOCUMENTS.D_END%TYPE | DATE | NULL | Document period end date |
| num_N_WORKFLOW_ID | IN | SD_DOCUMENTS.N_WORKFLOW_ID%TYPE | NUMBER | NULL | Workflow |
| tbl_T_TAGS | IN | TAGS | TABLE | NULL | Tags |
| num_N_DISCOUNT_ORIGIN_ID | IN | SD_DOCUMENTS.N_DISCOUNT_ORIGIN_ID%TYPE | NUMBER | NULL | Discount document origin (core/application server) |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_DOC_ID | IN | SD_DOCUMENTS.N_DOC_ID%TYPE | NUMBER | Document | |
| num_N_PRIMARY_KEY_VALUE | IN | NUMBER | NUMBER | NULL | Primary key value (when searching for a specific binding) |
| dt_D_BEGIN | IN | DATE | DATE | ADD_MONTHS(SYSDATE -3) | Start date of a search period |
| dt_D_END | IN | DATE | DATE | SYSDATE | End date of the search period |
| RETURN SS_AUDIT_PKG_S.TABLE_HISTORY_LIST_TABLE_TYPE | Table with changes in services | ||||
| PIPELINED | |||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_DOC_ID | IN | SD_DOCUMENTS.N_DOC_ID%TYPE | NUMBER | ID of document to check | |
| RETURN MAIN.BOOL | CONST.b_TRUE if the document is temporary unlocked, otherwise CONST.b_FALSE | ||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_DOC_ID | IN | SD_DOCUMENTS.N_DOC_ID%TYPE | NUMBER | ID of document to unlock | |
| vch_ISSUE_CODE | IN | VARCHAR2 | VARCHAR2 | Issue code | |
| vch_HASH | IN | VARCHAR2 | VARCHAR2 | Hash |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_FIRM_ID | IN | SI_SUBJ_ACCOUNTS.N_BANK_ID%TYPE | NUMBER | Firm | |
| num_N_BATCH_SIZE | IN | NUMBER | NUMBER | Batch size | |
| num_N_ROWS | OUT | NUMBER | NUMBER | Number of seeded rows |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_ACCOUNT_ID | IN | SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE | NUMBER | Account | |
| num_N_DOC_TYPE_ID | IN | SD_DOCUMENTS.N_DOC_TYPE_ID%TYPE | NUMBER | NULL | Document type |
| dt_D_OPER | IN | DATE | DATE | NULL | Date |
| b_Force | IN | CONST.BOOL | NUMBER | CONST.b_FALSE | Create register row |
| b_LockAccount | IN | CONST.BOOL | NUMBER | CONST.b_FALSE | Lock an account |
| RETURN BALANCE_EXTENDED | Account balance register row with amounts without GM. | ||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_ACCOUNT_ID | IN | SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE | NUMBER | Account | |
| dt_D_PROCESS_AFTER | IN | SI_SUBJ_ACCOUNTS.D_PROCESS_AFTER%TYPE | DATE | Processing date |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_FIRM_ID | IN | ACCOUNT_SHARDS.FIRM_ID%TYPE | NUMBER | Firm | |
| rc_ShardsRange | IN | SI_ACCOUNTS_PKG_S.SHARDS_RANGE | PL/SQL RECORD | Locked shards range |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_FIRM_ID | IN | SI_SUBJECTS.N_SUBJECT_ID%TYPE | NUMBER | New firm |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_SUBJECT_ID | IN | SI_SUBJ_ADDRESSES.N_SUBJECT_ID%TYPE | NUMBER | Subject | |
| num_N_ADDR_TYPE_ID | IN | SI_ADDRESSES.N_ADDR_TYPE_ID%TYPE | NUMBER | Address type | |
| num_N_SUBJ_ADDR_TYPE_ID | IN | SI_SUBJ_ADDRESSES.N_SUBJ_ADDR_TYPE_ID%TYPE | NUMBER | Address purpose | |
| b_DeleteAddresses | IN | CONST.BOOL | NUMBER | CONST.b_TRUE | Delete bind? Bind is deleted if CONST.b_TRUE or switched off if CONST.b_FALSE |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_SUBJECT_ID | IN/OUT | SI_SUBJECTS.N_SUBJECT_ID%TYPE | NUMBER | Company | |
| num_N_OPF_ID | IN | SI_COMPANIES.N_OPF_ID%TYPE | NUMBER | Legal form (REF_TYPE_OPF reference) | |
| num_N_PARENT_SUBJ_ID | IN | SI_SUBJECTS.N_PARENT_SUBJ_ID%TYPE | NUMBER | NULL | Parent subject. Used for divisions hierarchy |
| vch_VC_CODE | IN | SI_COMPANIES.VC_CODE%TYPE | VARCHAR2 | NULL | Short name |
| vch_VC_ENG_CODE | IN | SI_COMPANIES.VC_ENG_CODE%TYPE | VARCHAR2 | NULL | Short name in English |
| vch_VC_NAME | IN | SI_COMPANIES.VC_NAME%TYPE | VARCHAR2 | NULL | Full name |
| vch_VC_ENG_NAME | IN | SI_COMPANIES.VC_ENG_NAME%TYPE | VARCHAR2 | NULL | Full name in English |
| vch_VC_INN | IN | SI_COMPANIES.VC_INN%TYPE | VARCHAR2 | NULL | Tax ID |
| vch_VC_OGRN | IN | SI_SUBJ_VALUES.VC_VALUE%TYPE | VARCHAR2 | NULL | OGRN code |
| vch_VC_OKPO | IN | SI_SUBJ_VALUES.VC_VALUE%TYPE | VARCHAR2 | NULL | OKPO code |
| vch_VC_OCATO | IN | SI_SUBJ_VALUES.VC_VALUE%TYPE | VARCHAR2 | NULL | OCATO code |
| vch_VC_OKVED | IN | SI_SUBJ_VALUES.VC_VALUE%TYPE | VARCHAR2 | NULL | OKVED code |
| vch_VC_OCFS | IN | SI_SUBJ_VALUES.VC_VALUE%TYPE | VARCHAR2 | NULL | OCFS code |
| vch_VC_OCOPF | IN | SI_SUBJ_VALUES.VC_VALUE%TYPE | VARCHAR2 | NULL | OCOPF code |
| vch_VC_OCOGU | IN | SI_SUBJ_VALUES.VC_VALUE%TYPE | VARCHAR2 | NULL | OCOGU code |
| vch_VC_KPP | IN | SI_COMPANIES.VC_KPP%TYPE | VARCHAR2 | NULL | VAT code |
| vch_VC_EGRP | IN | SI_SUBJ_VALUES.VC_VALUE%TYPE | VARCHAR2 | NULL | EGRP code |
| vch_VC_REM | IN | SI_SUBJECTS.VC_REM%TYPE | VARCHAR2 | NULL | Remark |
| num_N_FIRM_ID | IN | SI_SUBJECTS.N_FIRM_ID%TYPE | NUMBER | NULL | Division |
| num_N_SUBJ_STATE_ID | IN | SI_SUBJECTS.N_SUBJ_STATE_ID%TYPE | NUMBER | NULL | Subject state (REF_TYPE_Subject_State reference) |
| num_N_REGION_ID | IN | SI_SUBJECTS.N_REGION_ID%TYPE | NUMBER | NULL | Subject region |
| num_N_SUBJ_GROUP_ID | IN | SI_SUBJ_GROUPS.N_SUBJ_GROUP_ID%TYPE | NUMBER | NULL | Subject group |
| tbl_T_TAGS | IN | TAGS | TABLE | NULL | Tags |
| tbl_T_GROUP_IDS | IN | NUMBER_TABLE | TABLE | NULL | Group IDs |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_SUBJECT_ID | IN/OUT | SI_SUBJECTS.N_SUBJECT_ID%TYPE | NUMBER | Company | |
| num_N_OPF_ID | IN | SI_COMPANIES.N_OPF_ID%TYPE | NUMBER | Legal form (REF_TYPE_OPF reference) | |
| num_N_PARENT_SUBJ_ID | IN | SI_SUBJECTS.N_PARENT_SUBJ_ID%TYPE | NUMBER | NULL | Parent subject. Used for divisions hierarchy |
| vch_VC_CODE | IN | SI_COMPANIES.VC_CODE%TYPE | VARCHAR2 | NULL | Short name |
| vch_VC_ENG_CODE | IN | SI_COMPANIES.VC_ENG_CODE%TYPE | VARCHAR2 | NULL | Short name in English |
| vch_VC_NAME | IN | SI_COMPANIES.VC_NAME%TYPE | VARCHAR2 | NULL | Full name |
| vch_VC_ENG_NAME | IN | SI_COMPANIES.VC_ENG_NAME%TYPE | VARCHAR2 | NULL | Full name in English |
| vch_VC_INN | IN | SI_COMPANIES.VC_INN%TYPE | VARCHAR2 | NULL | Tax ID |
| vch_VC_KPP | IN | SI_COMPANIES.VC_KPP%TYPE | VARCHAR2 | NULL | VAT code |
| vch_VC_REM | IN | SI_SUBJECTS.VC_REM%TYPE | VARCHAR2 | NULL | Remark |
| num_N_FIRM_ID | IN | SI_SUBJECTS.N_FIRM_ID%TYPE | NUMBER | NULL | Division |
| num_N_SUBJ_STATE_ID | IN | SI_SUBJECTS.N_SUBJ_STATE_ID%TYPE | NUMBER | NULL | Subject state (REF_TYPE_Subject_State reference) |
| num_N_REGION_ID | IN | SI_SUBJECTS.N_REGION_ID%TYPE | NUMBER | NULL | Subject region |
| num_N_SUBJ_GROUP_ID | IN | SI_SUBJ_GROUPS.N_SUBJ_GROUP_ID%TYPE | NUMBER | NULL | Subject group |
| tbl_T_TAGS | IN | TAGS | TABLE | NULL | Tags |
| tbl_T_GROUP_IDS | IN | NUMBER_TABLE | TABLE | NULL | Group IDs |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_SUBJECT_ID | IN/OUT | SI_SUBJECTS.N_SUBJECT_ID%TYPE | NUMBER | Individual | |
| num_N_OPF_ID | IN | SI_PERSONS.N_OPF_ID%TYPE | NUMBER | Legal form (REF_TYPE_OPF refernce) | |
| vch_VC_FIRST_NAME | IN | SI_PERSONS.VC_NAME%TYPE | VARCHAR2 | Name | |
| vch_VC_SURNAME | IN | SI_PERSONS.VC_SURNAME%TYPE | VARCHAR2 | Surname | |
| vch_VC_SECOND_NAME | IN | SI_PERSONS.VC_SECOND_NAME%TYPE | VARCHAR2 | Middle name | |
| num_N_SEX_ID | IN | SI_PERSONS.N_SEX_ID%TYPE | NUMBER | Sex (REF_TYPE_Sex reference) | |
| num_N_SUBJ_GROUP_ID | IN | SI_SUBJ_GROUPS.N_SUBJ_GROUP_ID%TYPE | NUMBER | Subject group | |
| vch_VC_INN | IN | SI_PERSONS.VC_INN%TYPE | VARCHAR2 | Tax ID | |
| dt_D_BIRTH | IN | SI_PERSONS.D_BIRTH%TYPE | DATE | Date of birth | |
| vch_VC_REM | IN | SI_SUBJECTS.VC_REM%TYPE | VARCHAR2 | Remark | |
| num_N_SUBJ_STATE_ID | IN | SI_SUBJECTS.N_SUBJ_STATE_ID%TYPE | NUMBER | Subject state (REF_TYPE_Subject_State reference) | |
| tbl_T_GROUP_IDS | IN | NUMBER_TABLE | TABLE | NULL | Group IDs |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_SUBJECT_ID | IN/OUT | SI_SUBJECTS.N_SUBJECT_ID%TYPE | NUMBER | Individual | |
| num_N_OPF_ID | IN | SI_PERSONS.N_OPF_ID%TYPE | NUMBER | NULL | Legal form (REF_TYPE_OPF refernce) |
| num_N_FIRM_ID | IN | SI_SUBJECTS.N_FIRM_ID%TYPE | NUMBER | NULL | Division |
| vch_VC_FIRST_NAME | IN | SI_PERSONS.VC_NAME%TYPE | VARCHAR2 | Name | |
| vch_VC_SURNAME | IN | SI_PERSONS.VC_SURNAME%TYPE | VARCHAR2 | NULL | Surname |
| vch_VC_SECOND_NAME | IN | SI_PERSONS.VC_SECOND_NAME%TYPE | VARCHAR2 | NULL | Middle name |
| num_N_SEX_ID | IN | SI_PERSONS.N_SEX_ID%TYPE | NUMBER | NULL | Sex (REF_TYPE_Sex reference) |
| vch_VC_INN | IN | SI_PERSONS.VC_INN%TYPE | VARCHAR2 | NULL | Tax ID |
| num_N_DOC_AUTH_TYPE_ID | IN | SI_PERSONS.N_DOC_AUTH_TYPE_ID%TYPE | NUMBER | NULL | ID type (справочник REF_TYPE_Document) |
| vch_VC_DOC_SERIAL | IN | SI_PERSONS.VC_DOC_SERIAL%TYPE | VARCHAR2 | NULL | ID serial number |
| vch_VC_DOC_NO | IN | SI_PERSONS.VC_DOC_NO%TYPE | VARCHAR2 | NULL | ID number |
| dt_D_DOC | IN | SI_PERSONS.D_DOC%TYPE | DATE | NULL | Date of issue |
| vch_VC_DOCUMENT | IN | SI_PERSONS.VC_DOCUMENT%TYPE | VARCHAR2 | NULL | Issued by |
| dt_D_BIRTH | IN | SI_PERSONS.D_BIRTH%TYPE | DATE | NULL | Date of birth |
| vch_VC_BIRTH_PLACE | IN | SI_PERSONS.VC_BIRTH_PLACE%TYPE | VARCHAR2 | NULL | Place of birth |
| vch_VC_PENS_INSURANCE | IN | SI_PERSONS.VC_PENS_INSURANCE%TYPE | VARCHAR2 | NULL | Social security number |
| vch_VC_MED_INSURANCE | IN | SI_PERSONS.VC_MED_INSURANCE%TYPE | VARCHAR2 | NULL | Medical insurance number |
| num_N_CITIZENSHIP_ID | IN | SI_PERSONS.N_CITIZENSHIP_ID%TYPE | NUMBER | NULL | Citizenship |
| vch_VC_KPP | IN | SI_PERSONS.VC_KPP%TYPE | VARCHAR2 | NULL | VAT code |
| vch_VC_REM | IN | SI_SUBJECTS.VC_REM%TYPE | VARCHAR2 | NULL | Remark |
| num_N_SUBJ_STATE_ID | IN | SI_SUBJECTS.N_SUBJ_STATE_ID%TYPE | NUMBER | NULL | Subject state (REF_TYPE_Subject_State reference) |
| num_N_SUBJ_GROUP_ID | IN | SI_SUBJ_GROUPS.N_SUBJ_GROUP_ID%TYPE | NUMBER | NULL | Subject group |
| vch_VC_DOC_DEPARTMENT | IN | SI_PERSONS.VC_DOC_DEPARTMENT%TYPE | VARCHAR2 | NULL | Department of of ID issuer |
| tbl_T_TAGS | IN | TAGS | TABLE | NULL | Tags |
| num_N_SCN | IN | SI_SUBJECTS.N_SCN%TYPE | NUMBER | NULL | Version |
| tbl_T_GROUP_IDS | IN | NUMBER_TABLE | TABLE | NULL | Group IDs |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| vch_VC_NAME | IN | SI_REF.VC_NAME%TYPE | VARCHAR2 | Name of a reference data entry | |
| num_N_REF_TYPE_ID | IN | SI_REF.N_REF_ID%TYPE | NUMBER | Reference data code | |
| RETURN SI_REF.N_REF_ID%TYPE | Reference data entry | ||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_SUBJECT_ID | IN/OUT | SI_SUBJECTS.N_SUBJECT_ID%TYPE | NUMBER | Subject ID | |
| num_N_SUBJ_TYPE_ID | IN | SI_SUBJECTS.N_SUBJ_TYPE_ID%TYPE | NUMBER | Subject type | |
| num_N_BASE_SUBJECT_ID | IN | SI_SUBJECTS.N_BASE_SUBJECT_ID%TYPE | NUMBER | NULL | Basic subject |
| num_N_SUBJ_STATE_ID | IN | SI_SUBJECTS.N_SUBJ_STATE_ID%TYPE | NUMBER | NULL | Subject state |
| num_N_PARENT_SUBJ_ID | IN | SI_SUBJECTS.N_PARENT_SUBJ_ID%TYPE | NUMBER | NULL | Parent subject |
| num_N_OWNER_ID | IN | SI_SUBJECTS.N_OWNER_ID%TYPE | NUMBER | NULL | Owner |
| vch_VC_NAME | IN | SI_SUBJECTS.VC_NAME%TYPE | VARCHAR2 | NULL | Full name |
| vch_VC_CODE | IN | SI_SUBJECTS.VC_CODE%TYPE | VARCHAR2 | NULL | Short name |
| vch_VC_REM | IN | SI_SUBJECTS.VC_REM%TYPE | VARCHAR2 | NULL | Remark |
| num_N_FIRM_ID | IN | SI_SUBJECTS.N_FIRM_ID%TYPE | NUMBER | NULL | Division |
| num_N_REGION_ID | IN | SI_SUBJECTS.N_REGION_ID%TYPE | NUMBER | NULL | Region |
| dt_D_ACTUALIZE | IN | SI_SUBJECTS.D_ACTUALIZE%TYPE | DATE | NULL | Subject data actualization date |
| vch_VC_CODE_ADD | IN | SI_SUBJECTS.VC_CODE_ADD%TYPE | VARCHAR2 | NULL | Additional code |
| num_N_SERVER_ID | IN | NUMBER | NUMBER | NULL | Server |
| num_N_SUBJ_GROUP_ID | IN | SI_SUBJ_GROUPS.N_SUBJ_GROUP_ID%TYPE | NUMBER | NULL | Subject group |
| tbl_T_TAGS | IN | TAGS | TABLE | NULL | Tags |
| num_N_SCN | IN | SI_SUBJECTS.N_SCN%TYPE | NUMBER | NULL | Version |
| num_N_RESELLER_ID | IN | SI_SUBJECTS.N_RESELLER_ID%TYPE | NUMBER | NULL | Dealer |
| tbl_T_GROUP_IDS | IN | NUMBER_TABLE | TABLE | NUMBER_TABLE() | Group IDs |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| vch_VC_LOGIN | IN | SI_SUBJ_SERVICES.VC_LOG%TYPE | VARCHAR2 | Login | |
| vch_VC_PASS | IN | SI_SUBJ_SERVICES.VC_PASS%TYPE | VARCHAR2 | Password | |
| vch_VC_APP_CODE | IN | SI_OBJECTS.VC_CODE%TYPE | VARCHAR2 | App code | |
| RETURN SI_SUBJ_SERVICES.N_SUBJECT_ID%TYPE | |||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_DISCOUNT_CERT_LINE_ID | IN | SD_DISCOUNT_CERTIFICATES_C.N_LE_ID%TYPE | NUMBER | Discount certificate content line | |
| RETURN SI_REF.N_REF_ID%TYPE | Discount reference id | ||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_DISCOUNT_CERT_LINE_ID | IN | SD_DISCOUNT_CERTIFICATES_C.N_LE_ID%TYPE | NUMBER | Discount certificate content line | |
| RETURN SD_DISCOUNT_CERTIFICATES_C.VC_DISCOUNT_NAME%TYPE | Discount name | ||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_SUBJECT_ID | IN/OUT | SI_SUBJECTS.N_SUBJECT_ID%TYPE | NUMBER | Customer | |
| vch_VC_CODE | IN | SI_SUBJECTS.VC_CODE%TYPE | VARCHAR2 | Customer code | |
| num_N_BASE_SUBJECT_ID | IN | SI_SUBJECTS.N_BASE_SUBJECT_ID%TYPE | NUMBER | Basic subject (an individual or an organization) | |
| num_N_SUBJ_GROUP_ID | IN | SI_SUBJ_SUBJECTS.N_SUBJ_SUBJECT_ID%TYPE | NUMBER | Customer group | |
| num_N_PARENT_SUBJ_ID | IN | SI_SUBJECTS.N_PARENT_SUBJ_ID%TYPE | NUMBER | NULL | Parent subject (not used) |
| num_N_SUBJ_STATE_ID | IN | SI_SUBJECTS.N_SUBJ_STATE_ID%TYPE | NUMBER | NULL | Customer status (REF_TYPE_Subject_State reference data) |
| num_N_FIRM_ID | IN | SI_SUBJECTS.N_FIRM_ID%TYPE | NUMBER | NULL | Division |
| vch_VC_REM | IN | SI_SUBJECTS.VC_REM%TYPE | VARCHAR2 | NULL | Remark |
| tbl_T_TAGS | IN | TAGS | TABLE | NULL | Tags |
| num_N_RESELLER_ID | IN | SI_SUBJECTS.N_RESELLER_ID%TYPE | NUMBER | NULL | Dealer |
| tbl_T_GROUP_IDS | IN | NUMBER_TABLE | TABLE | NULL | Group IDs |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| dt_D_BEGIN | IN | DATE | DATE | Start date | |
| dt_D_END | IN | DATE | DATE | End date | |
| num_N_ACCOUNT_ID | IN | NUMBER | NUMBER | Customer account | |
| b_Payment | IN | MA.BOOL | NUMBER | MAIN.b_FALSE | Include payments in the list? {*} CONST.b_TRUE — include payments {*} CONST.b_FALSE — do not include payments |
| b_WriteOff | IN | MA.BOOL | NUMBER | MAIN.b_FALSE | Include service charges in the list? {*} CONST.b_TRUE — include charges {*} CONST.b_FALSE — do not include charges |
| b_Overdraft | IN | MA.BOOL | NUMBER | MAIN.b_FALSE | Include credit limits in the list? {*} CONST.b_TRUE — include credit limits {*} CONST.b_FALSE — do not include credit limits |
| b_ShowZeroLines | IN | MA.BOOL | NUMBER | MAIN.b_FALSE | |
| vch_VC_TRANSACTION_ID | IN | EX_PAYMENTS.VC_TRANSACTION_ID%TYPE | VARCHAR2 | NULL | Payment transaction ID |
| RETURN DETALIZATION_LIST_TABLE_TYPE | Table with charges, payments and credit limits | ||||
| PIPELINED | |||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| vch_VC_VALUE | IN | VARCHAR2 | VARCHAR2 | Short name of a region type | |
| RETURN SI_REF.N_REF_ID%TYPE | Get region type reference | ||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| vch_VC_VALUE | IN | VARCHAR2 | VARCHAR2 | Short name of a region type | |
| RETURN SI_REF.N_REF_ID%TYPE | Get region type reference | ||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_REGION_ID | IN | SR_REGIONS.N_REGION_ID%TYPE | NUMBER | Region | |
| num_N_REGION_TYPE_ID | IN | SR_REGIONS.N_REGION_TYPE_ID%TYPE | NUMBER | Parent region type | |
| RETURN SR_REGIONS.VC_CODE%TYPE | Parent region code | ||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| vch_VC_IP | IN | VARCHAR2 | VARCHAR2 | Client IP | |
| vch_VC_LOGIN | IN | VARCHAR2 | VARCHAR2 | NULL | Login |
| vch_VC_PASSWORD | IN | VARCHAR2 | VARCHAR2 | NULL | Password |
| vch_VC_PASSWORD_HASH | IN | VARCHAR2 | VARCHAR2 | NULL | Password hash |
| vch_VC_APP_CODE | IN | VARCHAR2 | VARCHAR2 | NULL | Application code |
| vch_VC_CLN_APPID | IN | VARCHAR2 | VARCHAR2 | NULL | Application identifier (i.e. app version) |
| vch_VC_CLN_SESSIONID | IN | VARCHAR2 | VARCHAR2 | NULL | Client session ID |
| num_N_USER_ID | IN | NUMBER | NUMBER | NULL | User for logging on |
| vch_VC_AUTH_APP_CODE | IN | VARCHAR2 | VARCHAR2 | NULL | Authentication proxy app code |
| b_CHECK_FIRM | IN | CONST.BOOL | NUMBER | CONST.b_FALSE | |
| tbl_N_ALLOWED_FIRMS | IN | NUMBER_TABLE | TABLE | NULL | List of allowed firm ids |
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| num_N_USER_ID | IN | NUMBER | NUMBER | User for logging on | |
| tbl_N_ALLOWED_FIRMS | IN | NUMBER_TABLE | TABLE | List of allowed firm ids | |
| RETURN BOOLEAN | Return true if user firm is in the allowed list | ||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| dt_D_BEGIN | IN | DATE | DATE | Begin date | |
| dt_D_END | IN | DATE | DATE | NULL | End date |
| RETURN VARCHAR2 | Formatted date interval (localized) | ||||
| Argument | Direction | Reference type | Type | Default value | Description |
|---|---|---|---|---|---|
| vch_String | IN | VARCHAR2 | VARCHAR2 | String | |
| RETURN VARCHAR2 | string in CamelCase | ||||
| Field | Type | Description |
|---|---|---|
| N_DISCOUNT_PARAMS_ID | NUMBER | Параметр скидки |
| N_DISCOUNT_TYPE_ID | NUMBER | Тип скидки |
| N_DISCOUNT_PERCENT | NUMBER | Процент скидки |
| N_ALTER_PRICE | NUMBER | Абсолютный размер скидки |
| N_CURRENCY_ID | NUMBER | Валюта скидки |
| N_MAX_TRIGGERS_TOTAL | NUMBER | |
| VC_CURRENCY_CODE | VARCHAR2 | Код валюты |
| N_DISCOUNT_SPEC_LINE_ID | NUMBER | Строка приказа по скидкам |
| VC_DISCOUNT_VALUE | VARCHAR2 | Наименование скидки |
| N_DISCOUNT_ID | NUMBER | Скидка |
| Field | Type | Description |
|---|---|---|
| N_ACCOUNT_ID | NUMBER | Лицевой счет |
| N_PROMISED_PAY_SUM | NUMBER | Сумма разрешенного обещанного платежа |
| D_PROMISED_PAY_DAY | DATE | Дата, до которой выдается обещанный платеж |
| VC_PROMISED_PAY | VARCHAR2 | Причина отказа или комментарий |
| N_CURRENT_PROMISED_PAY_SUM | NUMBER | Сумма активного обещанного платежа |
| D_CURRENT_PROMISED_PAY_DAY | DATE | Дата окончания текущего обещанного платежа |
| Field | Type | Description |
|---|---|---|
| N_DOC_ID | NUMBER | Акт начислений |
| N_DOC_STATE_ID | NUMBER | Состояние акта начислений |
| N_REASON_DOC_ID | NUMBER | Договор |
| N_FIRM_ID | NUMBER | Фирма |
| D_DOC | DATE | Дата акта начислений |
| D_TIME | DATE | Время акта начислений |
| VC_CODE | VARCHAR2 | Краткое наименование акта начислений |
| VC_NAME | VARCHAR2 | Наименование акта начислений |
| N_CREATOR_ID | NUMBER | Автор акта начислений |
| D_CREATED | DATE | Дата создания акта начислений |
| VC_REM | VARCHAR2 | Примечание |
| N_USER_ID | NUMBER | Абонент |
| T_CUSTOMER_TAGS | TAGS | Теги абонента |
| N_USER_ACC_ID | NUMBER | Лицевой счет абонента |
| N_USER_BALANCE_SUM | NUMBER | Баланс абонента |
| N_RESELLER_ID | NUMBER | Дилер абонента |
| N_PROVIDER_ID | NUMBER | Поставщик |
| N_PROVIDER_ACC_ID | NUMBER | Счет поставщика |
| N_LINE_ID | NUMBER | Строка движения |
| N_MOVE_TYPE_ID | NUMBER | Тип движения |
| N_GOOD_ID | NUMBER | Услуга/Товар |
| N_GOOD_TYPE_ID | NUMBER | Тип услуги/товара |
| T_SERVICE_TAGS | TAGS | |
| N_UNIT_ID | NUMBER | Ед. изм. |
| N_QUANT | NUMBER | Объем |
| N_UNIT_BASE_ID | NUMBER | Базовая ед. изм. |
| N_QUANT_BASE | NUMBER | Объем в базовых ед. |
| N_TAX_RATE_ID | NUMBER | Ставка налога |
| N_OBJECT_ID | NUMBER | Оборудование |
| N_CURRENCY_ID | NUMBER | Валюта |
| N_PRICE | NUMBER | Цена |
| N_PRICE_WO_TAX | NUMBER | Цена без налогов |
| N_SUM | NUMBER | Сумма с налогами |
| N_SUM_TAX | NUMBER | Налоги |
| N_SUM_WO_TAX | NUMBER | Сумма без налогов |
| N_BASE_SUM | NUMBER | |
| N_BASE_SUM_WO_TAX | NUMBER | |
| N_LINE_NO | NUMBER | Порядковый номер |
| D_OPER | DATE | Дата операции |
| D_BEGIN | DATE | Дата начала |
| D_END | DATE | Дата окончания |
| VC_LINE_REM | VARCHAR2 | Примечание по строке движения |
| N_PRICE_LINE_ID | NUMBER | Приказ по ценам |
| N_SUBJ_GOOD_ID | NUMBER | Подписка |
| N_PAR_LINE_ID | NUMBER | Строка с тарифным планом |
| D_SUBJ_GOOD_BEGIN | DATE | Дата начала подписки |
| D_SUBJ_GOOD_END | DATE | Дата окончания подписки |
| N_PARENT_GOOD_ID | NUMBER | Тарифный план |
| VC_PARENT_GOOD_NAME | VARCHAR2 | Название тарифного плана |
| N_PAR_PRICE | NUMBER | Цена ТП |
| N_PAR_PRICE_WO_TAX | NUMBER | Цена ТП без налогов |
| N_PAR_SUM | NUMBER | Стоимость тарифного плана |
| N_PAR_SUM_TAX | NUMBER | Сумма налогов по ТП |
| N_PAR_SUM_WO_TAX | NUMBER | Стоимость тарифного плана без налогов |
| D_PAR_OPER | DATE | Дата операции по ТП |
| D_PAR_BEGIN | DATE | Дата начала ТП |
| D_PAR_END | DATE | Дата окончания ТП |
| N_ADDRESS_ID | NUMBER | IP-адрес |
| VC_ADDRESS | VARCHAR2 | IP-адрес |
| N_BASE_PROVIDER_ID | NUMBER | Базовый СУ поставщика |
| N_BASE_PRV_SUBJ_TYPE_ID | NUMBER | Тип базового СУ поставщика |
| N_BASE_RECEIVER_ID | NUMBER | Базовый СУ получателя |
| N_BASE_REC_SUBJ_TYPE_ID | NUMBER | Тип базового СУ получателя |
| N_USER_STATE_ID | NUMBER | Cостояние абонента |
| N_USER_BASE_ID | NUMBER | Базовый СУ абонента |
| N_REGION_ID | NUMBER | Регион |
| VC_ENTRANCE_NO | VARCHAR2 | Подъезд |
| N_FLOOR_NO | NUMBER | Этаж |
| VC_FLAT | VARCHAR2 | Номер квартиры |
| N_PARENT_DOC_ID | NUMBER | Базовый договор |
| VC_DISCOUNT_NAME | VARCHAR2 | |
| N_DISCOUNT_REF_ID | NUMBER |
| Field | Type | Description |
|---|---|---|
| N_LINE_ID | NUMBER | Строка акта предоставления скидки |
| N_DOC_ID | NUMBER | Акт предоставления скидки |
| N_DISCOUNT_PARAMS_ID | NUMBER | Параметры скидки |
| N_SUBSCRIPTION_ID | NUMBER | Строка подписки |
| N_SUBJECT_ID | NUMBER | |
| N_ACCOUNT_ID | NUMBER | |
| N_CONTRACT_ID | NUMBER | |
| N_SERVICE_ID | NUMBER | |
| N_DEVICE_ID | NUMBER | |
| D_BEGIN | DATE | Дата начала действия скидки |
| D_END | DATE | Дата окончания скидки |
| N_DISCOUNT_REASON_ID | NUMBER | Причина предоставления скидки |
| VC_DISCOUNT_NAME | VARCHAR2 | Скидка |
| N_DISCOUNT_TYPE_ID | NUMBER | |
| N_ALTER_PRICE | NUMBER | |
| N_CURRENCY_ID | NUMBER | |
| N_DISCOUNT_PERCENT | NUMBER | |
| N_LINE_NO | NUMBER | Номер по порядку |
| VC_REM | VARCHAR2 | Комментарий |
| N_DISCOUNT_SPEC_DOC_ID | NUMBER | |
| N_DISCOUNT_ID | NUMBER | Скидка |
| Field | Type | Description |
|---|---|---|
| N_DOC_ID | NUMBER | Документ |
| N_DOC_TYPE_ID | NUMBER | Тип документ |
| VC_DOC_TYPE_NAME | VARCHAR2 | Наименование типа документа |
| N_DOC_STATE_ID | NUMBER | Состояние документа |
| VC_DOC_STATE_NAME | VARCHAR2 | Наименование состояния документа |
| N_PARENT_DOC_ID | NUMBER | Родительский документ |
| VC_PARENT_DOC | VARCHAR2 | Наименование родительского документа |
| N_REASON_DOC_ID | NUMBER | Документ-основание |
| VC_REASON_DOC | VARCHAR2 | Наименование документа-основание |
| N_PREV_DOC_ID | NUMBER | Предыдущий документ |
| VC_PREV_DOC | VARCHAR2 | Наименование предыдущего документа |
| N_STORNO_DOC_ID | NUMBER | Сторнируемый документ |
| VC_STORNO_DOC | VARCHAR2 | Наименование сторнируемого документа |
| N_WORKFLOW_ID | NUMBER | Схема документооборота |
| VC_WORKFLOW_NAME | VARCHAR2 | Наименование схемы документооборота |
| D_DOC | DATE | Дата документа |
| D_TIME | DATE | Время документа |
| VC_DOC_NO | VARCHAR2 | Номер документа |
| VC_NAME | VARCHAR2 | Наименование документа |
| VC_CODE | VARCHAR2 | Краткое наименование документа |
| D_BEGIN | DATE | Дата начала действия |
| D_END | DATE | Дата окончания действия |
| N_CREATOR_ID | NUMBER | Автор документа |
| D_CREATED | DATE | Дата создания |
| VC_CREATOR_NAME | VARCHAR2 | Наименование автора документа |
| VC_CREATOR_CODE | VARCHAR2 | Краткое наименование автора |
| N_FIRM_ID | NUMBER | Фирма |
| VC_FIRM | VARCHAR2 | Наименование фирмы |
| VC_REM | VARCHAR2 | Комментарий |
| T_TAGS | TAGS | Теги |
| VC_TAGS | VARCHAR2 | Теги |
| N_PAYMENT_ID | NUMBER | Платеж |
| N_DISCOUNT_ORIGIN_ID | NUMBER | Origin of the discount document |
| Field | Type | Description |
|---|---|---|
| N_LINE_ID | NUMBER | Строка ПС |
| N_DOC_ID | NUMBER | Приказ по скидкам |
| VC_DISCOUNT_NAME | VARCHAR2 | Скидка |
| N_LINE_NO | NUMBER | Номер по порядку |
| D_BEGIN | DATE | Дата начала периода подключения скидки |
| D_END | DATE | Дата окончания периода подключения скидки |
| N_CONDITION_TYPE_ID | NUMBER | Тип условия скидки |
| N_CURRENCY_ID | NUMBER | Валюта |
| N_MIN_PAYMENT_SUM | NUMBER | Максимальная сумма платежа |
| N_MAX_PAYMENT_SUM | NUMBER | |
| N_PAYMENT_COVER | NUMBER | Период для расчета покрытия услуг платежом |
| N_PAYMENT_COVER_UNIT_ID | NUMBER | Единица измерения для покрываемого платежом периода |
| N_MAX_TRIGGERS_CONCUR | NUMBER | Максимальное число одновременных срабатываний |
| N_MAX_TRIGGERS_TOTAL | NUMBER | Максимальное число срабатываний |
| N_DURATION | NUMBER | Срок действия скидки |
| N_DURATION_UNIT_ID | NUMBER | Единица измерения для срока действия скидки |
| D_DISCOUNT_BEGIN | DATE | Дата начала действия скидки |
| D_DISCOUNT_END | DATE | Дата окончания действия скидки |
| VC_REM | VARCHAR2 | Комментарий |
| N_DISCOUNT_ID | NUMBER | Скидка |
| Field | Type | Description |
|---|---|---|
| N_DOC_ID | NUMBER | Документ |
| N_DOC_TYPE_ID | NUMBER | Тип документ |
| VC_DOC_TYPE_NAME | VARCHAR2 | Наименование типа документа |
| N_DOC_STATE_ID | NUMBER | Состояние документа |
| VC_DOC_STATE_NAME | VARCHAR2 | Наименование состояния документа |
| N_PARENT_DOC_ID | NUMBER | Родительский документ |
| VC_PARENT_DOC | VARCHAR2 | Наименование родительского документа |
| N_REASON_DOC_ID | NUMBER | Документ-основание |
| VC_REASON_DOC | VARCHAR2 | Наименование документа-основание |
| N_PREV_DOC_ID | NUMBER | Предыдущий документ |
| VC_PREV_DOC | VARCHAR2 | Наименование предыдущего документа |
| N_STORNO_DOC_ID | NUMBER | Сторнируемый документ |
| VC_STORNO_DOC | VARCHAR2 | Наименование сторнируемого документа |
| N_WORKFLOW_ID | NUMBER | Схема документооборота |
| VC_WORKFLOW_NAME | VARCHAR2 | Наименование схемы документооборота |
| D_DOC | DATE | Дата документа |
| D_TIME | DATE | Время документа |
| VC_DOC_NO | VARCHAR2 | Номер документа |
| VC_NAME | VARCHAR2 | Наименование документа |
| VC_CODE | VARCHAR2 | Краткое наименование документа |
| D_BEGIN | DATE | Дата начала действия |
| D_END | DATE | Дата окончания действия |
| N_CREATOR_ID | NUMBER | Автор документа |
| D_CREATED | DATE | Дата создания |
| VC_CREATOR_NAME | VARCHAR2 | Наименование автора документа |
| VC_CREATOR_CODE | VARCHAR2 | Краткое наименование автора |
| N_FIRM_ID | NUMBER | Фирма |
| VC_FIRM | VARCHAR2 | Наименование фирмы |
| VC_REM | VARCHAR2 | Комментарий |
| T_TAGS | TAGS | Теги |
| VC_TAGS | VARCHAR2 | Теги |
| N_DISCOUNT_ORIGIN_ID | NUMBER | Origin of the discount document |
| Field | Type | Description |
|---|---|---|
| N_DOC_ID | NUMBER | Document |
| N_DOC_TYPE_ID | NUMBER | Document type |
| N_DOC_STATE_ID | NUMBER | Document status |
| N_PARENT_DOC_ID | NUMBER | Parent document |
| N_REASON_DOC_ID | NUMBER | Reason document |
| N_PREV_DOC_ID | NUMBER | Previous document |
| N_STORNO_DOC_ID | NUMBER | Reversed document |
| N_FIRM_ID | NUMBER | Division |
| D_DOC | DATE | Document date |
| D_TIME | DATE | Document time |
| VC_DOC_NO | VARCHAR2 | Document number |
| VC_NAME | VARCHAR2 | Document name |
| VC_CODE | VARCHAR2 | Document code |
| D_BEGIN | DATE | Start date of the document validity period |
| D_END | DATE | End date of the document validity period |
| N_CREATOR_ID | NUMBER | Author |
| D_CREATED | DATE | Creation date |
| VC_REM | VARCHAR2 | Remark |
| D_LOG_LAST_MOD | DATE | Last modified date |
| N_LOG_SESSION_ID | NUMBER | Last modified session |
| VC_CODE_UPPER | VARCHAR2 | Document code in upper case |
| VC_NAME_UPPER | VARCHAR2 | Document name in upper case |
| C_FL_ARCHIVED | CHAR | Is the document archived (Y/N)? |
| N_WORKFLOW_ID | NUMBER | Document workflow |
| N_DOC_AUTONUM_ID | NUMBER | Autonumberer for the document number |
| D_ARCHIVED | DATE | Archiving date |
| N_DISCOUNT_ORIGIN_ID | NUMBER | Origin of the discount document |
| T_TAGS | TAGS | Document tags |
| VC_TAGS | VARCHAR2 | Comma-separated list of the document tags |
| Field | Type | Description |
|---|---|---|
| N_DOC_ID | NUMBER | Document |
| N_DOC_TYPE_ID | NUMBER | Document type |
| VC_DOC_TYPE_NAME | VARCHAR2 | Document type name |
| N_DOC_STATE_ID | NUMBER | Document state |
| VC_DOC_STATE_NAME | VARCHAR2 | Document state name |
| N_PARENT_DOC_ID | NUMBER | Parent document |
| VC_PARENT_DOC | VARCHAR2 | Parent document name |
| N_REASON_DOC_ID | NUMBER | Base document |
| N_PREV_DOC_ID | NUMBER | Previous document when copying |
| VC_PREV_DOC | VARCHAR2 | Previous document name when copying |
| N_STORNO_DOC_ID | NUMBER | Reversed document |
| VC_STORNO_DOC | VARCHAR2 | Reversed document name |
| N_WORKFLOW_ID | NUMBER | Workflow |
| VC_WORKFLOW_NAME | VARCHAR2 | Workflow name |
| D_DOC | DATE | Document date |
| D_TIME | DATE | Document time |
| VC_DOC_NO | VARCHAR2 | Document number |
| VC_NAME | VARCHAR2 | Document name |
| VC_CODE | VARCHAR2 | Short name of document |
| D_BEGIN | DATE | Begin date |
| D_END | DATE | End date |
| N_CREATOR_ID | NUMBER | Creator |
| D_CREATED | DATE | Document creation date |
| VC_CREATOR_NAME | VARCHAR2 | Document creator name |
| VC_CREATOR_CODE | VARCHAR2 | Document creator code |
| N_FIRM_ID | NUMBER | Firm |
| VC_FIRM | VARCHAR2 | Firm name |
| VC_REM | VARCHAR2 | Remark |
| T_TAGS | TAGS | Tags |
| VC_TAGS | VARCHAR2 | |
| C_FL_PURCHASING_PRICE | CHAR | Flag of purchasing price order |
| N_TAX_RATE_ID | NUMBER | Tax rate |
| VC_TAX_RATE_NAME | VARCHAR2 | Tax rate name |
| N_CURRENCY_ID | NUMBER | Currency |
| VC_CURRENCY_NAME | VARCHAR2 | Currency name |
| N_SUM_ROUNDING_ID | NUMBER | Amount rounding rule |
| VC_SUM_ROUNDING | VARCHAR2 | Amount rounding rule name |
| N_CALC_DESIGN_PROC_ID | NUMBER | Tax calculation rule |
| VC_CALC_DESIGN_PROC | VARCHAR2 | Tax calculation rule name |
| N_QUANT_ROUNDING_ID | NUMBER | Quantity rounding rule |
| VC_QUANT_ROUNDING | VARCHAR2 | Quantity rounding rule name |
| N_DEFER_TYPE_ID | NUMBER | Charge log deferment type |
| N_SCHED_DEFER_TYPE_ID | NUMBER | Deferment type for scheduled services |
| N_SCHED_DEFER_PAY_DAYS | NUMBER | Deferment for scheduled services in days (DEPRECATED in favor of N_SCHED_DEFER_PAY_VALUE + N_SCHED_DEFER_PAY_UNIT_ID), NULL if N_SCHED_DEFER_PAY_UNIT_ID != CONST.UNIT_Day |
| N_UNSCHED_DEFER_PAY_DAYS | NUMBER | Deferment for unscheduled services in days (DEPRECATED in favor of N_UNSCHED_DEFER_PAY_VALUE + N_UNSCHED_DEFER_PAY_UNIT_ID), NULL if N_UNSCHED_DEFER_PAY_UNIT_ID != CONST.UNIT_Day |
| N_RATING_TYPE_ID | NUMBER | Rating type |
| N_DOC_AUTONUM_ID | NUMBER | |
| N_TIME_INTERVALS_DOC_ID | NUMBER | |
| C_FL_DEF_RECEIVABLE_PAY | CHAR | Use deferred pay for receivables |
| N_SCHED_DEFER_PAY_VALUE | NUMBER | Deferment length for scheduled services |
| N_SCHED_DEFER_PAY_UNIT_ID | NUMBER | Deferment unit for scheduled services (CONST.UNIT_Day, CONST.UNIT_Month) |
| N_UNSCHED_DEFER_PAY_VALUE | NUMBER | Deferment length for unscheduled services |
| N_UNSCHED_DEFER_PAY_UNIT_ID | NUMBER | Deferment unit for unscheduled services (CONST.UNIT_Day, CONST.UNIT_Month) |
| Field | Type | Description |
|---|---|---|
| N_COMPANY_ID | NUMBER | |
| N_OPF_ID | NUMBER | |
| VC_OPF_CODE | VARCHAR2 | |
| VC_OPF_NAME | VARCHAR2 | |
| VC_CODE | VARCHAR2 | |
| VC_ENG_CODE | VARCHAR2 | |
| VC_NAME | VARCHAR2 | |
| VC_ENG_NAME | VARCHAR2 | |
| VC_INN | VARCHAR2 | |
| VC_OGRN | VARCHAR2 | |
| VC_OKPO | VARCHAR2 | |
| VC_OCATO | VARCHAR2 | |
| VC_OKVED | VARCHAR2 | |
| VC_OCFS | VARCHAR2 | |
| VC_OCOPF | VARCHAR2 | |
| VC_OCOGU | VARCHAR2 | |
| VC_EGRP | VARCHAR2 | |
| VC_KPP | VARCHAR2 | |
| N_SUBJECT_ID | NUMBER | |
| N_SUBJ_TYPE_ID | NUMBER | |
| N_PARENT_SUBJ_ID | NUMBER | |
| N_SUBJ_STATE_ID | NUMBER | |
| VC_SUBJ_STATE_NAME | VARCHAR2 | |
| N_BASE_SUBJECT_ID | NUMBER | |
| N_FIRM_ID | NUMBER | |
| VC_FIRM | VARCHAR2 | |
| N_REGION_ID | NUMBER | |
| VC_REGION | VARCHAR2 | |
| N_OWNER_ID | NUMBER | |
| VC_SUBJ_NAME | VARCHAR2 | |
| VC_SUBJ_CODE | VARCHAR2 | |
| D_CREATED | DATE | |
| N_CREATOR_ID | NUMBER | |
| T_TAGS | TAGS | |
| VC_TAGS | VARCHAR2 | |
| VC_REM | VARCHAR2 | |
| VC_CODE_UPPER | VARCHAR2 | |
| VC_NAME_UPPER | VARCHAR2 | |
| VC_SUBJ_CODE_UPPER | VARCHAR2 | |
| VC_SUBJ_NAME_UPPER | VARCHAR2 | |
| N_SUBJ_GROUP_ID | NUMBER | |
| T_GROUP_IDS | NUMBER_TABLE | |
| VC_SUBJ_GROUP_NAME | VARCHAR2 | |
| D_LOG_LAST_MOD_COMP | DATE | |
| N_LOG_SESSION_COMP_ID | NUMBER | |
| D_LOG_LAST_MOD_SUBJ | DATE | |
| N_LOG_SESSION_SUBJ_ID | NUMBER |
| Field | Type | Description |
|---|---|---|
| N_ADDRESS_ID | NUMBER | Идентификатор адреса |
| N_ADDR_TYPE_ID | NUMBER | Идентификатор типа адреса |
| VC_ADDR_TYPE_NAME | VARCHAR2 | Наименование типа адреса |
| N_PAR_ADDR_ID | NUMBER | Идентификатор вышестоящего адреса |
| VC_PAR_ADDR_CODE | VARCHAR2 | Код вышестоящего адреса |
| VC_PAR_ADDR_NAME | VARCHAR2 | Наименование вышестоящего адреса |
| VC_NAME | VARCHAR2 | Полный адрес |
| VC_CODE | VARCHAR2 | Краткий адрес |
| VC_NAME_VIEW | VARCHAR2 | Наименование для отображения |
| VC_VISUAL_CODE | VARCHAR2 | Отображаемый адрес |
| VC_ADDRESS | VARCHAR2 | Нестандартный адрес |
| VC_FLAT | VARCHAR2 | Комната, квартира |
| VC_CODE_UPPER | VARCHAR2 | Краткий адрес в верхнем регистре |
| N_REGION_ID | NUMBER | Идентификатор региона |
| VC_ENTRANCE_NO | VARCHAR2 | Подъезд |
| N_FLOOR_NO | NUMBER | Этаж |
| VC_DIS_CODE | VARCHAR2 | Код домофона |
| N_FIRM_ID | NUMBER | Идентификатор создавшей фирмы |
| N_OBJ_FIRM_ID | NUMBER | |
| VC_ADDR_REM | VARCHAR2 | Комментарий адреса |
| N_BIND_ADDR_ID | NUMBER | Идентификатор связанного адреса |
| N_OBJ_ADDRESS_ID | NUMBER | Идентификатор записи |
| N_PAR_OBJ_ADDR_ID | NUMBER | Идентификатор вышестоящей записи |
| VC_PAR_OBJ_ADDR_FULL_CODE | VARCHAR2 | Краткий адрес вышестоящего адреса |
| N_PAR_OBJ_ADDR_TYPE_ID | NUMBER | Идентификатор типа вышестоящего адреса |
| N_OBJECT_ID | NUMBER | Идентификатор ОУ |
| N_OBJ_ADDR_TYPE_ID | NUMBER | Идентификатор вида адреса |
| VC_OBJ_ADDR_TYPE_NAME | VARCHAR2 | Наименование вида адреса |
| D_BEGIN | DATE | Дата начала действия |
| D_END | DATE | Дата окончания действия |
| C_FL_MAIN | CHAR | Флаг основного адреса |
| N_ADDR_STATE_ID | NUMBER | Идентификатор состояния адреса |
| VC_ADDR_STATE_NAME | VARCHAR2 | Наименование состояния адреса |
| VC_REM | VARCHAR2 | Комментарий |
| VC_OBJ_NAME | VARCHAR2 | Наименование ОУ |
| VC_OBJ_CODE | VARCHAR2 | Код ОУ |
| N_GOOD_ID | NUMBER | Идентификатор типа ОУ |
| N_OBJ_STATE_ID | NUMBER | Идентификатор состояния ОУ |
| N_MAIN_OBJECT_ID | NUMBER | |
| N_CATALOG_BRANCH_ID | NUMBER | |
| C_FL_ACTUAL | CHAR | Флаг действующей привязки |
| Field | Type | Description |
|---|---|---|
| N_ADDRESS_ID | NUMBER | |
| N_ADDR_TYPE_ID | NUMBER | |
| N_PAR_ADDR_ID | NUMBER | |
| VC_NAME | VARCHAR2 | |
| VC_CODE | VARCHAR2 | |
| VC_VISUAL_CODE | VARCHAR2 | |
| VC_ADDRESS | VARCHAR2 | |
| VC_FLAT | VARCHAR2 | |
| VC_CODE_UPPER | VARCHAR2 | |
| N_REGION_ID | NUMBER | |
| VC_ENTRANCE_NO | VARCHAR2 | |
| N_FLOOR_NO | NUMBER | |
| VC_DIS_CODE | VARCHAR2 | |
| N_FIRM_ID | NUMBER | |
| VC_ADDR_REM | VARCHAR2 | |
| N_VALUE | NUMBER | |
| N_VALUE_2 | NUMBER | |
| N_MASK | NUMBER | |
| VC_VALUE | VARCHAR2 | |
| VC_VALUE_2 | VARCHAR2 | |
| N_LENGTH | NUMBER | |
| VC_PREFIX | VARCHAR2 | |
| N_BIND_ADDR_ID | NUMBER | |
| N_PROVIDER_ID | NUMBER | |
| N_OBJ_ADDRESS_ID | NUMBER | |
| N_PAR_OBJ_ADDR_ID | NUMBER | |
| N_OBJECT_ID | NUMBER | |
| N_OBJ_ADDR_TYPE_ID | NUMBER | |
| D_BEGIN | DATE | |
| D_END | DATE | |
| C_FL_MAIN | CHAR | |
| N_ADDR_STATE_ID | NUMBER | |
| VC_REM | VARCHAR2 | |
| VC_OBJ_NAME | VARCHAR2 | |
| VC_OBJ_CODE | VARCHAR2 | |
| N_GOOD_ID | NUMBER | |
| N_OBJ_STATE_ID | NUMBER | |
| N_MAIN_OBJECT_ID | NUMBER | |
| N_CATALOG_BRANCH_ID | NUMBER | |
| N_OBJ_FIRM_ID | NUMBER | |
| C_FL_ACTUAL | CHAR |
| Field | Type | Description |
|---|---|---|
| N_COMPANY_ID | NUMBER | |
| N_OPF_ID | NUMBER | |
| VC_OPF_CODE | VARCHAR2 | |
| VC_OPF_NAME | VARCHAR2 | |
| VC_CODE | VARCHAR2 | |
| VC_ENG_CODE | VARCHAR2 | |
| VC_NAME | VARCHAR2 | |
| VC_ENG_NAME | VARCHAR2 | |
| VC_INN | VARCHAR2 | |
| VC_KPP | VARCHAR2 | |
| N_SUBJECT_ID | NUMBER | |
| N_SUBJ_TYPE_ID | NUMBER | |
| N_PARENT_SUBJ_ID | NUMBER | |
| N_SUBJ_STATE_ID | NUMBER | |
| VC_SUBJ_STATE_NAME | VARCHAR2 | |
| N_BASE_SUBJECT_ID | NUMBER | |
| N_FIRM_ID | NUMBER | |
| VC_FIRM | VARCHAR2 | |
| N_REGION_ID | NUMBER | |
| VC_REGION | VARCHAR2 | |
| N_OWNER_ID | NUMBER | |
| VC_SUBJ_NAME | VARCHAR2 | |
| VC_SUBJ_CODE | VARCHAR2 | |
| D_CREATED | DATE | |
| N_CREATOR_ID | NUMBER | |
| T_TAGS | TAGS | |
| VC_TAGS | VARCHAR2 | |
| VC_REM | VARCHAR2 | |
| VC_CODE_UPPER | VARCHAR2 | |
| VC_NAME_UPPER | VARCHAR2 | |
| VC_SUBJ_CODE_UPPER | VARCHAR2 | |
| VC_SUBJ_NAME_UPPER | VARCHAR2 | |
| N_SUBJ_GROUP_ID | NUMBER | |
| T_GROUP_IDS | NUMBER_TABLE | |
| VC_SUBJ_GROUP_NAME | VARCHAR2 | |
| D_LOG_LAST_MOD_COMP | DATE | |
| N_LOG_SESSION_COMP_ID | NUMBER | |
| D_LOG_LAST_MOD_SUBJ | DATE | |
| N_LOG_SESSION_SUBJ_ID | NUMBER |
| Field | Type | Description |
|---|---|---|
| N_PERSON_ID | NUMBER | |
| N_OPF_ID | NUMBER | |
| VC_OPF_CODE | VARCHAR2 | |
| VC_OPF_NAME | VARCHAR2 | |
| VC_FIRST_NAME | VARCHAR2 | |
| VC_SURNAME | VARCHAR2 | |
| VC_SECOND_NAME | VARCHAR2 | |
| N_SEX_ID | NUMBER | |
| VC_SEX | VARCHAR2 | |
| VC_INN | VARCHAR2 | |
| D_BIRTH | DATE | |
| N_SUBJECT_ID | NUMBER | |
| N_SUBJ_TYPE_ID | NUMBER | |
| N_PARENT_SUBJ_ID | NUMBER | |
| N_SUBJ_STATE_ID | NUMBER | |
| VC_SUBJ_STATE_NAME | VARCHAR2 | |
| N_BASE_SUBJECT_ID | NUMBER | |
| N_FIRM_ID | NUMBER | |
| VC_FIRM | VARCHAR2 | |
| N_REGION_ID | NUMBER | |
| VC_REGION | VARCHAR2 | |
| N_OWNER_ID | NUMBER | |
| VC_SUBJ_NAME | VARCHAR2 | |
| VC_SUBJ_CODE | VARCHAR2 | |
| VC_NAME | VARCHAR2 | |
| VC_CODE | VARCHAR2 | |
| D_CREATED | DATE | |
| N_CREATOR_ID | NUMBER | |
| T_TAGS | TAGS | |
| VC_TAGS | VARCHAR2 | |
| VC_REM | VARCHAR2 | |
| VC_CODE_UPPER | VARCHAR2 | |
| VC_NAME_UPPER | VARCHAR2 | |
| VC_SUBJ_CODE_UPPER | VARCHAR2 | |
| VC_SUBJ_NAME_UPPER | VARCHAR2 | |
| N_SUBJ_GROUP_ID | NUMBER | |
| T_GROUP_IDS | NUMBER_TABLE | |
| VC_SUBJ_GROUP_NAME | VARCHAR2 | |
| VC_SUBJ_GROUPS | VARCHAR2 | |
| D_LOG_LAST_MOD_PERS | DATE | |
| N_LOG_SESSION_PERS_ID | NUMBER | |
| D_LOG_LAST_MOD_SUBJ | DATE | |
| N_LOG_SESSION_SUBJ_ID | NUMBER |
| Field | Type | Description |
|---|---|---|
| N_PERSON_ID | NUMBER | |
| N_OPF_ID | NUMBER | |
| VC_OPF_CODE | VARCHAR2 | |
| VC_OPF_NAME | VARCHAR2 | |
| VC_FIRST_NAME | VARCHAR2 | |
| VC_SURNAME | VARCHAR2 | |
| VC_SECOND_NAME | VARCHAR2 | |
| N_SEX_ID | NUMBER | |
| VC_SEX | VARCHAR2 | |
| VC_INN | VARCHAR2 | |
| N_DOC_AUTH_TYPE_ID | NUMBER | |
| VC_DOC_AUTH_TYPE_CODE | VARCHAR2 | |
| VC_DOC_AUTH_TYPE_NAME | VARCHAR2 | |
| VC_DOC_SERIAL | VARCHAR2 | |
| VC_DOC_NO | VARCHAR2 | |
| D_DOC | DATE | |
| VC_DOCUMENT | VARCHAR2 | |
| VC_DOC_DEPARTMENT | VARCHAR2 | |
| D_BIRTH | DATE | |
| VC_BIRTH_PLACE | VARCHAR2 | |
| VC_PENS_INSURANCE | VARCHAR2 | |
| VC_MED_INSURANCE | VARCHAR2 | |
| N_SUBJECT_ID | NUMBER | |
| N_SUBJ_TYPE_ID | NUMBER | |
| N_PARENT_SUBJ_ID | NUMBER | |
| N_SUBJ_STATE_ID | NUMBER | |
| VC_SUBJ_STATE_NAME | VARCHAR2 | |
| N_BASE_SUBJECT_ID | NUMBER | |
| N_FIRM_ID | NUMBER | |
| VC_FIRM | VARCHAR2 | |
| N_REGION_ID | NUMBER | |
| VC_REGION | VARCHAR2 | |
| N_OWNER_ID | NUMBER | |
| VC_SUBJ_NAME | VARCHAR2 | |
| VC_SUBJ_CODE | VARCHAR2 | |
| VC_NAME | VARCHAR2 | |
| VC_CODE | VARCHAR2 | |
| D_CREATED | DATE | |
| N_CREATOR_ID | NUMBER | |
| T_TAGS | TAGS | |
| VC_TAGS | VARCHAR2 | |
| VC_REM | VARCHAR2 | |
| VC_CODE_UPPER | VARCHAR2 | |
| VC_NAME_UPPER | VARCHAR2 | |
| N_SUBJ_GROUP_ID | NUMBER | |
| T_GROUP_IDS | NUMBER_TABLE | |
| VC_SUBJ_GROUP_NAME | VARCHAR2 | |
| N_CITIZENSHIP_ID | NUMBER | |
| VC_CITIZENSHIP | VARCHAR2 | |
| VC_KPP | VARCHAR2 |
| Field | Type | Description |
|---|---|---|
| N_SUBJECT_ID | NUMBER | Идентификатор СУ |
| N_SUBJ_TYPE_ID | NUMBER | Идентификатор типа СУ |
| VC_SUBJ_TYPE_NAME | VARCHAR2 | Наименование типа СУ |
| N_PARENT_SUBJ_ID | NUMBER | Идентификатор вышестоящего СУ |
| VC_PARENT_SUBJ | VARCHAR2 | Наименование вышестоящего СУ |
| N_SUBJ_STATE_ID | NUMBER | Идентификатор статуса СУ |
| VC_SUBJ_STATE_NAME | VARCHAR2 | Наименование статуса СУ |
| N_BASE_SUBJECT_ID | NUMBER | Идентификатор базового СУ |
| N_FIRM_ID | NUMBER | Идентификатор создавшей фирмы |
| VC_FIRM | VARCHAR2 | Наименование создавшей фирмы |
| N_REGION_ID | NUMBER | Идентификатор региона |
| VC_REGION | VARCHAR2 | Наименование региона |
| N_OWNER_ID | NUMBER | Идентификатор владельца |
| VC_NAME | VARCHAR2 | Полное наименование |
| VC_CODE | VARCHAR2 | Краткое наименование |
| D_CREATED | DATE | Дата создания |
| N_CREATOR_ID | NUMBER | Идентификатор создателя |
| VC_CREATOR_CODE | VARCHAR2 | |
| VC_CREATOR_NAME | VARCHAR2 | |
| T_TAGS | TAGS | Теги |
| T_GROUP_IDS | NUMBER_TABLE | |
| VC_TAGS | VARCHAR2 | Список тегов |
| VC_REM | VARCHAR2 | Примечание |
| VC_CODE_UPPER | VARCHAR2 | Краткое наименование в верхнем регистре |
| VC_NAME_UPPER | VARCHAR2 | Полное наименование в верхнем регистре |
| D_LOG_LAST_MOD | DATE | Дата последнего изменения |
| N_LOG_SESSION_ID | NUMBER | Идентификатор сессии |
| VC_SUBJ_NAME | VARCHAR2 | |
| VC_SUBJ_CODE | VARCHAR2 | |
| VC_SUBJ_CODE_UPPER | VARCHAR2 | |
| VC_SUBJ_NAME_UPPER | VARCHAR2 | |
| VC_CODE_ADD | VARCHAR2 | |
| D_ACTUALIZE | DATE | |
| N_RESELLER_ID | NUMBER | Дилер |
| Field | Type | Description |
|---|---|---|
| N_SUBJECT_ID | NUMBER | Customer |
| N_CUSTOMER_ID | NUMBER | Customer |
| N_SUBJ_TYPE_ID | NUMBER | Subject type |
| N_BASE_SUBJECT_ID | NUMBER | Basic subject |
| VC_BASE_SUBJECT_NAME | VARCHAR2 | Basic subject name |
| N_BASE_SUBJ_TYPE_ID | NUMBER | Basic subject type |
| N_PARENT_SUBJ_ID | NUMBER | Parent subject |
| N_SUBJ_STATE_ID | NUMBER | Customer's status |
| N_OWNER_ID | NUMBER | Owner |
| VC_SUBJ_NAME | VARCHAR2 | Customer's name |
| VC_SUBJ_CODE | VARCHAR2 | Customer's code |
| VC_NAME | VARCHAR2 | Customer's name |
| VC_CODE | VARCHAR2 | Customer's code |
| VC_SUBJ_CODE_UPPER | VARCHAR2 | Customer's code in upper case |
| VC_SUBJ_NAME_UPPER | VARCHAR2 | Customer's name in upper case |
| VC_CREATOR_NAME | VARCHAR2 | Customer's creator name |
| VC_CREATOR_CODE | VARCHAR2 | Customer's creator code |
| D_CREATED | DATE | Creation date |
| N_CREATOR_ID | NUMBER | Customer's creator |
| T_TAGS | TAGS | Customer's tags |
| VC_TAGS | VARCHAR2 | Comma-separated list of the customer's tags |
| VC_REM | VARCHAR2 | Remark |
| N_FIRM_ID | NUMBER | Division |
| N_REGION_ID | NUMBER | Region |
| D_ACTUALIZE | DATE | Customer's data update date |
| VC_CODE_ADD | VARCHAR2 | Additional customer's code |
| N_SUBJ_GROUP_ID | NUMBER | Customer's primary group |
| T_GROUP_IDS | NUMBER_TABLE | |
| VC_SUBJ_GROUP_NAME | VARCHAR2 | Customer's primary group name |
| N_RESELLER_ID | NUMBER | Dealer |
| D_LOG_LAST_MOD | DATE | Last modified date |
| N_LOG_SESSION_ID | NUMBER | Last modified session |