Oracle API diff 5.1.2 and 6.0

Legend: added, changed, deleted.

Renamed objects:

From	To	Type
ACC_BILLS_PKG	ACC_INVOICES_PKG	Package
SD_BILLS_PKG	SD_INVOICES_PKG	Package
SD_INVOICES_PKG	SD_CHARGE_LOGS_PKG	Package
SD_INVOICES_PKG_S	SD_CHARGE_LOGS_PKG_S	Package
AP_V_USER_OFFICE_BILLS	AP_V_USER_OFFICE_INVOICES	View
AP_V_USER_OFFICE_BILLS_C	AP_V_USER_OFFICE_INVOICES_C	View
AP_V_USER_OFFICE_BILLS_PRINTS	AP_V_USER_OFFICE_INVOICES_PRINTS	View
RPT_V_USER_BILLS	RPT_V_USER_INVOICES	View
SD_V_BILLS_C	SD_V_INVOICES_C	View
SD_V_BILLS_JR	SD_V_INVOICES_JR	View
SD_V_BILLS_T	SD_V_INVOICES_T	View
SD_V_INVOICES_C	SD_V_CHARGE_LOGS_C	View
SD_V_INVOICES_C_SUMS	SD_V_CHARGE_LOGS_C_SUMS	View
SD_V_INVOICES_JR	SD_V_CHARGE_LOGS_JR	View
SD_V_INVOICES_T	SD_V_CHARGE_LOGS_T	View

Packages

ACC_INVOICES_PKG

Invoice export for accounting software

PROCEDURE UNLOAD_DOCUMENTS

Export invoices.

Argument	Direction	Reference type	Type	Default value	Description
tbl_N_FIRM_IDS	IN	NUMBER_TABLE	TABLE		Divisions
tbl_N_SUBJ_GROUP_IDS	IN	NUMBER_TABLE	TABLE		Customer groups
tbl_T_TAGS	IN	TAGS	TABLE	TAGS()
dt_D_BEGIN	IN	SD_DOCUMENTS.D_BEGIN%TYPE	DATE		Export period beginning date
dt_D_END	IN	SD_DOCUMENTS.D_END%TYPE	DATE		Export period end date
b_UseDocCreatedDate	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Filter invoices by document creation date {} CONST.b_TRUE — filter by document creation date {} CONST.b_FALSE — filter by document begin/end date

AP_USER_OFFICE_PKG

Customer care portal package

PROCEDURE AV_SERVICE_CHANGE_STATE

Change antivirus software subscription state.

Argument	Direction	Reference type	Type	Default value	Description
num_N_SUBJ_GOOD_ID	IN	SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE	NUMBER		Antivirus software subscription
b_Cancel	IN	MAIN.BOOL	NUMBER		Disable/cancel flag {} CONST.b_TRUE — disable {} CONST.b_FALSE — cancel disabling
dt_D_INVOICE_END	IN	SD_GOOD_MOVES.D_END%TYPE	DATE	NULL	Date of subscription usage end (NULL — charge log end)
dt_D_CHARGE_LOG_END	IN	SD_GOOD_MOVES.D_END%TYPE	DATE	NULL	Date of subscription usage end (NULL — charge log end)

PROCEDURE CREATE_PREPAYMENT_BILL

Create prepayment invoice.

Argument	Direction	Reference type	Type	Description
num_N_CONTRACT_ID	IN	SD_CONTRACTS.N_DOC_ID%TYPE	NUMBER	Contract
num_N_SUM	IN	NUMBER	NUMBER	Amount
num_N_DOC_ID	OUT	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER	Created document id

FUNCTION CHANGE_TARIFF

Change a service subsciption to a specified price plan.

Argument	Direction	Reference type	Type	Default value	Description
num_N_SUBJ_GOOD_ID	IN	SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE	NUMBER		Old subscription
num_N_GOOD_ID	IN	SD_GOOD_MOVES.N_GOOD_ID%TYPE	NUMBER		New price plan
dt_D_CHANGE	IN	SI_SUBSCRIPTIONS.D_BEGIN%TYPE	DATE	SYSDATE	New subscription beginning date
dt_D_INVOICE_END	IN	SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE	DATE	NULL	Charge log end date for the new subscription
dt_D_CHARGE_LOG_END	IN	SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE	DATE	NULL	Charge log end date for the new subscription
b_CloseCurrentInvoice	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Close current charge log by subscription?
b_CloseCurrentChargeLog	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Close current charge log by subscription?
b_ChangeImmediately	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Change price plan immediately?
b_UseSubscriptionBillingDay	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Use the same billing day as in old subscription?
RETURN SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE					New subscription

PROCEDURE DO_TARIFF_CHANGE

Change a service subsciption to a specified price plan.

PROCEDURE ACCESS_SERV_CHG_STATE

Manually enable or disable the access service.

Argument	Direction	Reference type	Type	Description
num_N_GOOD_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER	Access service
num_N_PARENT_GOOD_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER	Price plan
num_N_ACCOUNT_ID	IN	SI_SUBSCRIPTIONS.N_ACCOUNT_ID%TYPE	NUMBER	Account
num_N_OBJECT_ID	IN	SI_OBJECTS.N_OBJECT_ID%TYPE	NUMBER	Equipment
num_N_INVOICE_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER	Charge log
num_N_CHARGE_LOG_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER	Charge log
b_Enable	IN	MAIN.BOOL	NUMBER	Action flag: {} MAIN.b_TRUE — enable {} MAIN.b_FALSE — disable

FUNCTION ADD_TARIFF

Add a new price plan for the next belling period (if there is no active subscription).

Argument	Direction	Reference type	Type	Default value	Description
num_N_GOOD_ID	IN	SD_GOOD_MOVES.N_GOOD_ID%TYPE	NUMBER		Price plan
num_N_ACCOUNT_ID	IN	SI_SUBSCRIPTIONS.N_ACCOUNT_ID%TYPE	NUMBER		Account
num_N_OBJECT_ID	IN	SI_SUBSCRIPTIONS.N_OBJECT_ID%TYPE	NUMBER		Equipment
num_N_DOC_ID	IN	SI_SUBSCRIPTIONS.N_DOC_ID%TYPE	NUMBER		Contract
num_N_PAY_DAY	IN	SI_SUBSCRIPTIONS.N_BILLING_DAY%TYPE	NUMBER	NULL	Billing day
b_CreateInvoice	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Create charge logs?
b_CreateChargeLog	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Create charge logs?
dt_D_INVOICE_END	IN	SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE	DATE	NULL	Charge logs end
dt_D_CHARGE_LOG_END	IN	SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE	DATE	NULL	Charge logs end
dt_D_BEGIN	IN	SI_SUBSCRIPTIONS.D_BEGIN%TYPE	DATE	SYSDATE	Subscription beginning date
RETURN SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE	Subscription

PROCEDURE ADD_TARIFF

Add a new price plan for the next belling period (if there is no active subscription).

Argument	Direction	Reference type	Type	Default value	Description
num_N_GOOD_ID	IN	SD_GOOD_MOVES.N_GOOD_ID%TYPE	NUMBER		Price plan
num_N_ACCOUNT_ID	IN	SI_SUBSCRIPTIONS.N_ACCOUNT_ID%TYPE	NUMBER		Account
num_N_OBJECT_ID	IN	SI_SUBSCRIPTIONS.N_OBJECT_ID%TYPE	NUMBER		Equipment
num_N_DOC_ID	IN	SI_SUBSCRIPTIONS.N_DOC_ID%TYPE	NUMBER		Contract
num_N_PAY_DAY	IN	SI_SUBSCRIPTIONS.N_BILLING_DAY%TYPE	NUMBER	NULL	Billing day
b_CreateInvoice	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Create charge logs?
b_CreateChargeLog	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Create charge logs?
dt_D_INVOICE_END	IN	SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE	DATE	NULL	Charge logs end
dt_D_CHARGE_LOG_END	IN	SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE	DATE	NULL	Charge logs end
dt_D_BEGIN	IN	SI_SUBSCRIPTIONS.D_BEGIN%TYPE	DATE	SYSDATE	Subscription beginning date

PROCEDURE PROCESS_ADD_GOODS

Enable or disable additional periodic services within a price plan subscription.

Argument	Direction	Reference type	Type	Default value	Description
num_N_PAR_SUBJ_GOOD_ID	IN	SI_SUBSCRIPTIONS.N_PAR_SUBSCRIPTION_ID%TYPE	NUMBER		Price plan subscription
t_GOODS_LIST	IN	NUMBER_TABLE	TABLE		List of services to enable. Already enabled services not in this list will be disabled
b_UseCurrentInvoice	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Include services to current charge log?
b_UseCurrentChargeLog	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Include services to current charge log?

PROCEDURE ADD_GOOD_TO_INVOICE

Add a service to a to a current charge log.

Argument	Direction	Reference type	Type	Default value	Description
num_N_INVOICE_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Charge log
num_N_GOOD_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER		Service
num_N_QUANT	IN	SD_GOOD_MOVES.N_QUANT%TYPE	NUMBER	NULL	Quantity

PROCEDURE REMOVE_GOOD_FROM_INVOICE

Remove a service from a current charge log.

Argument	Direction	Reference type	Type	Default value	Description
num_N_INVOICE_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Current charge log
num_N_GOOD_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER		Service
b_CloseSubjGood	IN	MAIN.BOOL	NUMBER	MAIN.b_TRUE	Close subscription too?

PROCEDURE PUT_REDIRECT_PHONE_NUMBER

Add redirect phone number.

Argument	Direction	Reference type	Type	Default value	Description
num_N_COMPONENT_ID	IN	SI_OBJECTS.N_OBJECT_ID%TYPE	NUMBER		Component
vch_VC_REDIRECT_PHONE_NUMBER	IN	SI_ADDRESSES.VC_CODE%TYPE	VARCHAR2		Phone number

PROCEDURE CREATE_PREPAYMENT_INVOICE

Create prepayment invoice.

Argument	Direction	Reference type	Type	Description
num_N_CONTRACT_ID	IN	SD_CONTRACTS.N_DOC_ID%TYPE	NUMBER	Contract
num_N_SUM	IN	NUMBER	NUMBER	Amount
num_N_DOC_ID	OUT	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER	Created document id

PROCEDURE CLOSE_REDIRECT_PHONE_NUMBER

Close redirect phone number period.

Argument	Direction	Reference type	Type	Default value	Description
num_N_COMPONENT_ID	IN	SI_OBJ_ADDRESSES.N_OBJ_ADDRESS_ID%TYPE	NUMBER		Component

PROCEDURE REMOVE_GOOD_FROM_CHARGE_LOG

Remove a service from a current charge log.

Argument	Direction	Reference type	Type	Default value	Description
num_N_CHARGE_LOG_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Current charge log
num_N_GOOD_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER		Service
b_CloseSubjGood	IN	MAIN.BOOL	NUMBER	MAIN.b_TRUE	Close subscription too?

PROCEDURE ADD_GOOD_TO_CHARGE_LOG

Add a service to a to a current charge log.

Argument	Direction	Reference type	Type	Default value	Description
num_N_CHARGE_LOG_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Charge log
num_N_GOOD_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER		Service
num_N_QUANT	IN	SD_GOOD_MOVES.N_QUANT%TYPE	NUMBER	NULL	Quantity

EX_LOADINGS_PKG

External data bulk loading

PROCEDURE LOAD_ACTUAL_INVOICES_FROM_CSV

Load actual charge logs.

Argument	Direction	Reference type	Type	Default value	Description
clb_CL_DATA	IN	CLOB	CLOB		Data to load
dt_D_OPER	IN	DATE	DATE	NULL	Date the billing period will be open
num_ErrorsLimit	IN	NUMBER	NUMBER	10	Maximum number of errors tolerated
vch_VC_FIELD_SEPARATOR	IN	VARCHAR2	VARCHAR2	';'	CSV field separator

PROCEDURE CREATE_INVOICE_BY_SUBJ_GOOD

Create a charge log by subscription.

Argument	Direction	Reference type	Type	Default value	Description
num_N_SUBJ_GOOD_ID	IN	SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE	NUMBER		Subscription
num_N_SUBJECT_ID	IN	SI_SUBJECTS.N_SUBJECT_ID%TYPE	NUMBER	NULL	Customer
num_N_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER	NULL	Account
dt_D_OPER	IN	DATE	DATE	SYSDATE	Date the billing period will be open
b_AllInvoicesAtOnce	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Create all charge logs by account?

PROCEDURE LOAD_CHARGE_LOGS_FROM_CSV

Load actual charge logs.

Argument	Direction	Reference type	Type	Default value	Description
clb_CL_DATA	IN	CLOB	CLOB		Data to load
dt_D_OPER	IN	DATE	DATE	NULL	Date the billing period will be open
num_ErrorsLimit	IN	NUMBER	NUMBER	10	Maximum number of errors tolerated
vch_VC_FIELD_SEPARATOR	IN	VARCHAR2	VARCHAR2	';'	CSV field separator

PROCEDURE CREATE_CHARGE_LOG_BY_SUBJ_GOOD

Create a charge log by subscription.

Argument	Direction	Reference type	Type	Default value	Description
num_N_SUBJ_GOOD_ID	IN	SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE	NUMBER		Subscription
num_N_SUBJECT_ID	IN	SI_SUBJECTS.N_SUBJECT_ID%TYPE	NUMBER	NULL	Customer
num_N_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER	NULL	Account
dt_D_OPER	IN	DATE	DATE	SYSDATE	Date the billing period will be open
b_AllChargeLogsAtOnce	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Create all charge logs by account?

Argument	Direction	Reference type	Type	Description
num_N_DOC_VALUE_ID	OUT	SD_DOC_VALUES.N_DOC_VALUE_ID%TYPE	NUMBER	Additional value ID
num_N_DOC_ID	IN	SD_DOC_VALUES.N_DOC_ID%TYPE	NUMBER	Bill
vch_VC_ADD_VALUE_CODE	IN	SD_DOC_VALUES_TYPE.VC_CODE%TYPE	VARCHAR2	Additional value code
num_N_VALUE	IN	SD_DOC_VALUES.N_VALUE%TYPE	NUMBER	Value

Argument	Direction	Reference type	Type	Default value	Description
vch_VC_BANK_CODE	IN	EX_PAYMENTS.VC_TO_BANK%TYPE	VARCHAR2
vch_VC_BANK_ACCOUNT	IN	SI_SUBJ_ACCOUNTS.VC_ACCOUNT%TYPE	VARCHAR2
num_N_SUM	IN	EX_PAYMENTS.N_SUM%TYPE	NUMBER		Amount
num_N_FEE	IN	NUMBER	NUMBER
vch_VC_PAY_TYPE	IN	SI_REF.VC_CODE%TYPE	VARCHAR2		Payment type code (REF_TYPE_Real_MM_Kind reference data)
vch_VC_CURRENCY	IN	SI_REF.VC_VALUE_2%TYPE	VARCHAR2		ISO 4217 currency code
vch_VC_TRANSACTION_ID	IN	EX_PAYMENTS.VC_TRANSACTION_ID%TYPE	VARCHAR2		Transaction ID
vch_VC_TRANSACTION_NO	IN	EX_PAYMENTS.VC_TRANSACTION_ID%TYPE	VARCHAR2	NULL	Transaction number
num_N_CUSTOMER_ACCOUNT_ID	IN	EX_PAYMENTS.N_FORWHO_ACCOUNT_ID%TYPE	NUMBER	NULL	Customer account
vch_VC_CUSTOMER_ACCOUNT	IN	SI_SUBJ_ACCOUNTS.VC_CODE%TYPE	VARCHAR2	NULL	Customer account number
vch_VC_CUSTOMER_CODE	IN	SI_SUBJECTS.VC_CODE%TYPE	VARCHAR2	NULL	Customer code
vch_VC_PHONE_NUMBER	IN	SI_ADDRESSES.VC_CODE%TYPE	VARCHAR2	NULL	Phone number
vch_VC_CONTRACT_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Service contract number
vch_VC_BILL_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Invoice number
vch_VC_INVOICE_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Invoice number
b_AllowCompanyPayments	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Allow to make payments for organizations? {} CONST.b_TRUE — make a payment for an organization {} CONST.b_FALSE — do not make a payment when the payee is an organization
vch_VC_CUSTOMER_GROUP	IN	SI_SUBJECTS.VC_CODE%TYPE	VARCHAR2	NULL	Customer group code
num_N_SUM_WO_FEE	IN	EX_PAYMENTS.N_SUM_WO_FEE%TYPE	NUMBER	NULL	Amount excl. commission
dt_D_TXN	IN	EX_PAYMENTS.D_TAKING%TYPE	DATE	NULL	Payment date
vch_VC_PAYER_CODE	IN	EX_PAYMENTS.VC_FROM%TYPE	VARCHAR2	NULL	Payer's code
vch_VC_PAYER_BANK	IN	EX_PAYMENTS.VC_FROM_BANK%TYPE	VARCHAR2	NULL	Payer's bank code
vch_VC_PAYER_BANK_ACCOUNT	IN	EX_PAYMENTS.VC_FROM_BANK_ACCOUNT%TYPE	VARCHAR2	NULL	Payer's current account
vch_VC_REM	IN	EX_PAYMENTS.VC_REM%TYPE	VARCHAR2	NULL	Purpose of the payment
num_N_DOC_STATE_ID	IN	SD_DOCUMENTS.N_DOC_STATE_ID%TYPE	NUMBER	NULL	Payment document status (REF_TYPE_Document_State reference data)
num_N_AUTO_TOP_UP_ID	IN	SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_ID%TYPE	NUMBER	NULL	Subscription to auto top-up
b_Autonomous	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Create the payment in an autonomous transaction? {} CONST.b_TRUE — create the payment in an autonomous transaction {} CONST.b_FALSE — do not use an autonomous transaction
num_N_DOC_ID	OUT	EX_PAYMENTS.N_DOC_ID%TYPE	NUMBER		Payment document
dt_D_LOAD	OUT	EX_PAYMENTS.D_LOAD%TYPE	DATE		Payment loading date

Argument	Direction	Reference type	Type	Default value	Description
vch_VC_TO_BANK	IN	EX_PAYMENTS.VC_TO_BANK%TYPE	VARCHAR2		Payee's bank code
vch_VC_TO_ACCOUNT	IN	SI_SUBJ_ACCOUNTS.VC_ACCOUNT%TYPE	VARCHAR2		Payee's account number
num_N_SUM	IN	EX_PAYMENTS.N_SUM%TYPE	NUMBER		Amount
num_Fee	IN	NUMBER	NUMBER		Percentage commission on a payment
vch_PayType	IN	SI_REF.VC_CODE%TYPE	VARCHAR2		Payment type code (REF_TYPE_Real_MM_Kind reference data)
vch_Currency	IN	SI_REF.VC_VALUE_2%TYPE	VARCHAR2		ISO 4217 currency code
vch_VC_TRANSACTION_ID	IN	EX_PAYMENTS.VC_TRANSACTION_ID%TYPE	VARCHAR2		Transaction ID
vch_VC_TRANSACTION_NO	IN	EX_PAYMENTS.VC_TRANSACTION_ID%TYPE	VARCHAR2	NULL	Transaction number
num_N_FORWHO_ACCOUNT_ID	IN	EX_PAYMENTS.N_FORWHO_ACCOUNT_ID%TYPE	NUMBER	NULL	Customer account
vch_VC_ACCOUNT	IN	SI_SUBJ_ACCOUNTS.VC_CODE%TYPE	VARCHAR2	NULL	Customer account number
vch_VC_USER_CODE	IN	SI_SUBJECTS.VC_CODE%TYPE	VARCHAR2	NULL	Customer code
vch_VC_TEL_NUMBER	IN	SI_OBJECTS.VC_CODE%TYPE	VARCHAR2	NULL	Phone number
vch_VC_CONTRACT_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Service contract number
vch_VC_BILL_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Invoice number
vch_VC_INVOICE_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Invoice number
b_AllowCompanyPaying	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Allow to make payments for organizations? {} CONST.b_TRUE — make a payment for an organization {} CONST.b_FALSE — do not make a payment when the payee is an organization
vch_VC_USER_GROUP	IN	SI_SUBJECTS.VC_CODE%TYPE	VARCHAR2	NULL	Customer group code
num_N_SUM_WO_FEE	IN	EX_PAYMENTS.N_SUM_WO_FEE%TYPE	NUMBER	NULL	Amount excl. commission
dt_D_TAKING	IN	EX_PAYMENTS.D_TAKING%TYPE	DATE	NULL	Payment date
vch_VC_FROM	IN	EX_PAYMENTS.VC_FROM%TYPE	VARCHAR2	NULL	Payer's code
vch_VC_FROM_BANK	IN	EX_PAYMENTS.VC_FROM_BANK%TYPE	VARCHAR2	NULL	Payer's bank code
vch_VC_FROM_BANK_ACCOUNT	IN	EX_PAYMENTS.VC_FROM_BANK_ACCOUNT%TYPE	VARCHAR2	NULL	Payer's current account
vch_VC_TO	IN	EX_PAYMENTS.VC_TO%TYPE	VARCHAR2	NULL	Payee's code
vch_VC_REM	IN	EX_PAYMENTS.VC_REM%TYPE	VARCHAR2	NULL	Purpose of the payment
num_N_DOC_STATE_ID	IN	SD_DOCUMENTS.N_DOC_STATE_ID%TYPE	NUMBER	NULL	Payment document status (REF_TYPE_Document_State reference data)
num_N_AUTO_TOP_UP_ID	IN	SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_ID%TYPE	NUMBER	NULL	Subscription to auto top-up
num_N_DOC_ID	OUT	EX_PAYMENTS.N_DOC_ID%TYPE	NUMBER		Payment document
dt_D_LOAD	OUT	EX_PAYMENTS.D_LOAD%TYPE	DATE		Payment loading date

Argument	Direction	Reference type	Type	Description
num_N_DOC_VALUE_ID	OUT	SD_DOC_VALUES.N_DOC_VALUE_ID%TYPE	NUMBER	Additional value ID
num_N_DOC_ID	IN	SD_DOC_VALUES.N_DOC_ID%TYPE	NUMBER	Invoice
vch_VC_ADD_VALUE_CODE	IN	SD_DOC_VALUES_TYPE.VC_CODE%TYPE	VARCHAR2	Additional value code
num_N_VALUE	IN	SD_DOC_VALUES.N_VALUE%TYPE	NUMBER	Value

EX_PAYMENTS_PKG_S

Retrieving data on payments, accounts, banks, subscriptions to auto top-up and autopayments.

TYPE LIST_ACCOUNT_PAYMENTS_TBL PL/SQL TABLE

Table type for list of account payments in date range.

FUNCTION GET_ACCOUNT_ID_FOR_CHARGE

Find a customer account to credit a payment. The function is used by the HPD agent.

Argument	Direction	Reference type	Type	Default value	Description
vch_VC_ACCOUNT	IN	SI_SUBJ_ACCOUNTS.VC_CODE%TYPE	VARCHAR2	NULL	Customer account number
vch_VC_USER_CODE	IN	SI_SUBJECTS.VC_CODE%TYPE	VARCHAR2	NULL	Customer code
vch_VC_TEL_NUMBER	IN	SI_OBJECTS.VC_CODE%TYPE	VARCHAR2	NULL	Customer phone number
vch_VC_CONTRACT_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Service contract number
vch_VC_BILL_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Invoice number
vch_VC_INVOICE_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Invoice number
b_AllowCompanyPaying	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Search for the account when the payment is made for an organization? {} CONST.b_TRUE — search for the account {} CONST.b_FALSE — do not return the account
vch_VC_USER_GROUP	IN	SI_SUBJECTS.VC_CODE%TYPE	VARCHAR2	NULL	Code of a group the customer should belong to
b_Allow_Disabled	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Search among disabled customers? {} CONST.b_TRUE — consider disabled customers {} CONST.b_FALSE — exclude disabled customers from the search
b_EvalRecommendedPayment	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Calculate a recommended payment amount? {} CONST.b_TRUE — calculate the recommended payment amount {} CONST.b_FALSE — do not calculate the recommended payment amount
vch_Info	OUT	VARCHAR2	VARCHAR2		Data on the customer's basic subject
num_RecommendedPayment	OUT	TT_V_USER_RECOMMENDED_PAY.N_SUM%TYPE	NUMBER		Recommended payment amount
RETURN SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE					Customer account

PROCEDURE GET_ACCOUNT_INFO

Find a customer account to credit a payment. The procedure is used by the HPD agent.

Argument	Direction	Reference type	Type	Default value	Description
vch_VC_ACCOUNT	IN	SI_SUBJ_ACCOUNTS.VC_CODE%TYPE	VARCHAR2	NULL	Customer account number
vch_VC_USER_CODE	IN	SI_SUBJECTS.VC_CODE%TYPE	VARCHAR2	NULL	Customer code
vch_VC_TEL_NUMBER	IN	SI_OBJECTS.VC_CODE%TYPE	VARCHAR2	NULL	Customer phone number
vch_VC_CONTRACT_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Service contract number
vch_VC_BILL_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Invoice number
vch_VC_INVOICE_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Invoice number
b_AllowCompanyPaying	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Search for the account when the payment is made for an organization? {} CONST.b_TRUE — search for the account {} CONST.b_FALSE — do not return the account
vch_VC_USER_GROUP	IN	SI_SUBJECTS.VC_CODE%TYPE	VARCHAR2	NULL	Code of a group the customer should belong to
b_Lock	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Lock the found account? {} CONST.b_TRUE — lock the account {} CONST.b_FALSE — do not lock the account
num_N_LOCK_TIMEOUT_SEC	IN	NUMBER	NUMBER	10	Number of seconds to wait for the locked account to become available
b_Allow_Disabled	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Search among disabled customers? {} CONST.b_TRUE — consider disabled customers {} CONST.b_FALSE — exclude disabled customers from the search
b_EvalRecommendedPayment	IN	CONST.BOOL	NUMBER	CONST.b_TRUE
num_N_ACCOUNT_ID	OUT	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Customer account
vch_Info	OUT	VARCHAR2	VARCHAR2		Data on the customer's basic subject
num_RecommendedPayment	OUT	TT_V_USER_RECOMMENDED_PAY.N_SUM%TYPE	NUMBER		Recommended payment amount
b_Locked	OUT	CONST.BOOL	NUMBER		Is the account locked? {} CONST.b_TRUE – the account is successfully locked {} CONST.b_FALSE – the account hasn't been locked {*} NULL – account not found or b_Lock = CONST.b_FALSE

FUNCTION GET_LIST_ACCOUNT_PAYMENTS_P

Get list of account payments in date range.

Argument	Direction	Reference type	Type
vch_VC_ACCOUNT	IN	SI_SUBJ_ACCOUNTS.VC_ACCOUNT%TYPE	VARCHAR2
dt_D_START	IN	EX_PAYMENTS.D_LOAD%TYPE	DATE
dt_D_END	IN	EX_PAYMENTS.D_LOAD%TYPE	DATE
RETURN LIST_ACCOUNT_PAYMENTS_TBL	Table with account details
PIPELINED

RP_PROFILES_PKG

PROCEDURE RECREATE_FOR_CONTEXT

Re-generate all profiles for context.

Argument	Direction	Reference type	Type	Default value	Description
vch_VC_CONTEXT	IN	RP_PROFILES.VC_CONTEXT%TYPE	VARCHAR2		Context
ch_C_FL_GENERATE_COMMANDS	IN	SP_VERSIONS.C_FL_GENERATE_COMMANDS%TYPE	CHAR	'Y'	Generate commands on profile changes
ch_C_FL_SEND_PROFILES	IN	SP_VERSIONS.C_FL_SEND_PROFILES%TYPE	CHAR	'Y'	Send new profiles to a queue
b_DeleteProfiles	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Perform DELETE on profiles table
b_SendRemoveCommand	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Send command for removing profiles into queue

PROCEDURE RECREATE_FOR_TEMPLATE

Re-generate all substitutions for template.

Argument	Direction	Reference type	Type	Default value	Description
num_N_TEMPLATE_ID	IN	SP_PROFILE_TPLS.N_TEMPLATE_ID%TYPE	NUMBER		Template
num_N_BATCH_SIZE	IN	SP_VERSIONS.N_BATCH_SIZE%TYPE	NUMBER	5000	Batch size
ch_C_FL_GENERATE_COMMANDS	IN	SP_VERSIONS.C_FL_GENERATE_COMMANDS%TYPE	CHAR	'Y'	Generate commands on profile changes
ch_C_FL_SEND_PROFILES	IN	SP_VERSIONS.C_FL_SEND_PROFILES%TYPE	CHAR	'Y'	Send new profiles to a queue
b_DeleteProfiles	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Perform DELETE on profiles table
num_N_LOG_SESSION_ID	IN	SP_VERSIONS.N_LOG_SESSION_ID%TYPE	NUMBER	MAIN.GET_N_SESSION_ID	User session identifier
num_N_BASE_SCN	OUT	SP_VERSIONS.N_SCN%TYPE	NUMBER		Base SCN

PROCEDURE RECREATE_FOR_TEMPLATE

Re-generate all substitutions for template.

Argument	Direction	Reference type	Type	Default value	Description
num_N_TEMPLATE_ID	IN	SP_PROFILE_TPLS.N_TEMPLATE_ID%TYPE	NUMBER		Template
num_N_BATCH_SIZE	IN	SP_VERSIONS.N_BATCH_SIZE%TYPE	NUMBER	5000	Batch size
ch_C_FL_GENERATE_COMMANDS	IN	SP_VERSIONS.C_FL_GENERATE_COMMANDS%TYPE	CHAR	'Y'	Generate commands on profile changes
ch_C_FL_SEND_PROFILES	IN	SP_VERSIONS.C_FL_SEND_PROFILES%TYPE	CHAR	'Y'	Send new profiles to a queue
b_DeleteProfiles	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Perform DELETE on profiles table

FUNCTION SYNC_ALL_PROFILES

Create and update all profiles by firm.

Argument	Direction	Reference type	Type	Default value	Description
num_N_FIRM_ID	IN	SP_VERSIONS.N_FIRM_ID%TYPE	NUMBER		Firm
ts_TS_START	IN	SP_VERSIONS.TS_START%TYPE	TIMESTAMP	UTILS2_PKG_S.GET_SYSTIMESTAMP	Timestamp of start
num_N_BATCH_SIZE	IN	SP_VERSIONS.N_BATCH_SIZE%TYPE	NUMBER	5000	Size of batch
dt_D_PREV_SYNC	IN	DATE	DATE	NULL
b_RefreshImmediate	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Refresh profiles immediate
RETURN SP_VERSIONS.N_SCN%TYPE	Created version

FUNCTION TRY_SYNC_ALL_PROFILES

Create and update all profiles by firm if time interval was changed.

Argument	Direction	Reference type	Type	Default value	Description
num_N_FIRM_ID	IN	SP_VERSIONS.N_FIRM_ID%TYPE	NUMBER		Firm
ts_TS_START	IN	SP_VERSIONS.TS_START%TYPE	TIMESTAMP	SYSTIMESTAMP	Timestamp of start
num_N_BATCH_SIZE	IN	SP_VERSIONS.N_BATCH_SIZE%TYPE	NUMBER	5000	Size of batch
dt_D_PREV_SYNC	IN	DATE	DATE	NULL	Previous sync date
b_RefreshImmediate	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Refresh profiles immediate
RETURN SP_VERSIONS.N_SCN%TYPE	Version

SD_BALANCE_ADJUSTMENTS_PKG

PROCEDURE CHARGE_ADJUSTMENT

Charge an adjustment of a specicfied amount against a specified account.

Argument	Direction	Reference type	Type	Default value	Description
num_N_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Account
num_N_CONTRACT_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Contract
num_N_OBJECT_ID	IN	SI_OBJECTS.N_OBJECT_ID%TYPE	NUMBER		Object
num_N_SERVICE_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER		Adjustment service
num_N_SUM	IN	SD_GOOD_MOVES.N_SUM%TYPE	NUMBER	NULL	Amount
num_N_SUM_WO_TAX	IN	SD_GOOD_MOVES.N_SUM_WO_TAX%TYPE	NUMBER	NULL	Amount without tax
dt_D_OPER	IN	SD_GOOD_MOVES.D_OPER%TYPE	DATE	NULL	Operation date
num_N_CHARGE_LOG_ID	OUT	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Created charge log

SD_CHARGE_LOGS_PKG

DEPRECATED in v5.1! Charge log management

PROCEDURE CANCEL_NON_PAY_SUSPENSION

Cancel non-payment suspension charge log.

Argument	Direction	Reference type	Type	Default value	Description
num_N_CHARGE_LOG_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER

PROCEDURE RAISE_DOC_EVENTS

DEPRECATED in v5.1! Generate events by charge log.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Charge log

PROCEDURE CONNECT_ACCESS_SERVS

DEPRECATED in v5.1! Switch on all access services by account.

Argument	Direction	Reference type	Type	Default value	Description
num_N_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Account

PROCEDURE SD_CHARGE_LOGS_C_PUT

Create or replace a charge log content line.

Argument	Direction	Reference type	Type	Default value	Description
num_N_LINE_ID	IN/OUT	SD_GOOD_MOVES.N_LINE_ID%TYPE	NUMBER		Line ID
num_N_DOC_ID	IN	SD_GOOD_MOVES.N_DOC_ID%TYPE	NUMBER		Document
num_N_GOOD_ID	IN	SD_GOOD_MOVES.N_GOOD_ID%TYPE	NUMBER	NULL	Service
num_N_MOVE_TYPE_ID	IN	SD_GOOD_MOVES.N_MOVE_TYPE_ID%TYPE	NUMBER	NULL	Transaction type (REF_TYPE_Good_Move_Type reference)
num_N_PAR_LINE_ID	IN	SD_GOOD_MOVES.N_PAR_LINE_ID%TYPE	NUMBER	NULL	Parent line (price plan)
num_N_UNIT_ID	IN	SD_GOOD_MOVES.N_UNIT_ID%TYPE	NUMBER	NULL	Unit (REF_TYPE_Measure_Unit, REF_TYPE_Unit_Time_Type, REF_TYPE_Unit_Data_Type, REF_TYPE_Unit_DataSpeed_Type references)
num_N_QUANT	IN	SD_GOOD_MOVES.N_QUANT%TYPE	NUMBER	NULL	Quantity
num_N_UNIT_BASE_ID	IN	SD_GOOD_MOVES.N_UNIT_BASE_ID%TYPE	NUMBER	NULL	Basic units (REF_TYPE_Measure_Unit, REF_TYPE_Unit_Time_Type, REF_TYPE_Unit_Data_Type, REF_TYPE_Unit_DataSpeed_Type references)
num_N_QUANT_BASE	IN	SD_GOOD_MOVES.N_QUANT_BASE%TYPE	NUMBER	NULL	Quantity in basic units
num_N_TAX_RATE_ID	IN	SD_GOOD_MOVES.N_TAX_RATE_ID%TYPE	NUMBER	NULL	Tax rate (REF_TYPE_TAX_Rates reference)
num_N_CURRENCY_ID	IN	SD_GOOD_MOVES.N_CURRENCY_ID%TYPE	NUMBER	NULL	Currency (REF_TYPE_Currency reference)
num_N_PRICE	IN	SD_GOOD_MOVES.N_PRICE%TYPE	NUMBER	NULL	Price including taxes
num_N_PRICE_WO_TAX	IN	SD_GOOD_MOVES.N_PRICE_WO_TAX%TYPE	NUMBER	NULL	Price excluding taxes
num_N_BASE_SUM	IN	SD_GOOD_MOVES.N_BASE_SUM%TYPE	NUMBER	NULL	Pre-discount amount
num_N_BASE_SUM_WO_TAX	IN	SD_GOOD_MOVES.N_BASE_SUM_WO_TAX%TYPE	NUMBER	NULL	Pre-discount amount excluding taxes
num_N_DISCOUNT_CERT_LINE_ID	IN	SD_GOOD_MOVES.N_DISCOUNT_CERT_LINE_ID%TYPE	NUMBER	NULL	Discount certificate line
num_N_SUM_WO_TAX	IN	SD_GOOD_MOVES.N_SUM_WO_TAX%TYPE	NUMBER	NULL	Amount excluding taxes
num_N_SUM_TAX	IN	SD_GOOD_MOVES.N_SUM_TAX%TYPE	NUMBER	NULL	Taxes
num_N_SUM	IN	SD_GOOD_MOVES.N_SUM%TYPE	NUMBER	NULL	Amount including taxes
num_N_OBJECT_ID	IN	SD_GOOD_MOVES.N_OBJECT_ID%TYPE	NUMBER	NULL	Equipment
num_N_LINE_NO	IN	SD_GOOD_MOVES.N_LINE_NO%TYPE	NUMBER	NULL	Line number
dt_D_BEGIN	IN	SD_GOOD_MOVES.D_BEGIN%TYPE	DATE	NULL	Start date
dt_D_END	IN	SD_GOOD_MOVES.D_END%TYPE	DATE	NULL	End date
dt_D_OPER	IN	SD_GOOD_MOVES.D_OPER%TYPE	DATE	NULL	Operation date (charge date)
vch_VC_REM	IN	SD_GOOD_MOVES.VC_REM%TYPE	VARCHAR2	NULL	Remark
num_N_PRICE_LINE_ID	IN	SD_GOOD_MOVES.N_PRICE_LINE_ID%TYPE	NUMBER	NULL	Price specification line
num_N_ADDRESS_ID	IN	SD_GOOD_MOVES.N_ADDRESS_ID%TYPE	NUMBER	NULL	Address
num_N_PROVIDER_ID	IN	SD_GOOD_MOVES.N_PROVIDER_ID%TYPE	NUMBER	NULL	Address provider
num_N_BASE_LINE_ID	IN	SD_GOOD_MOVES.N_BASE_LINE_ID%TYPE	NUMBER	NULL	Basic line
num_N_SUBJ_GOOD_ID	IN	SD_GOOD_MOVES.N_SUBJ_GOOD_ID%TYPE	NUMBER	NULL	Service subscription
num_N_PROVISION_RULE_ID	IN	SR_PROVISION_RULES.N_PROVISION_RULE_ID%TYPE	NUMBER	NULL
dt_D_PROVISION_BEGIN	IN	SD_GOOD_MOVES.D_PROVISION_BEGIN%TYPE	DATE	NULL	Service provisioning start date

PROCEDURE ACTUALIZE_CHARGE_LOG

Change charge log state to actual.

Argument	Direction	Reference type	Type	Default value	Description
num_N_CHARGE_LOG_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Charge log

PROCEDURE COMPRESS_CHARGE_LOG

Compress charge log contents. Collapses lines in SD_GOOD_MOVES.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Charge log

PROCEDURE MAKE_CHARGE_LOG_CLOSABLE

Make charge log closable.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SD_CHARGE_LOGS_T.N_DOC_ID%TYPE	NUMBER		Charge log
dt_D_CLOSABLE	IN	SD_CHARGE_LOGS_T.D_CLOSABLE%TYPE	DATE	UTILS2_PKG_S.GET_SYSDATE	Date that charge log becames closable since

PROCEDURE SET_CHARGE_LOG_CLOSE_REASON

Set charge log end.

Argument	Direction	Reference type	Type	Default value	Description
num_N_CHARGE_LOG_ID	IN	SD_CHARGE_LOGS_T.N_DOC_ID%TYPE	NUMBER		Charge log
num_N_CLOSE_REASON_ID	IN	SD_CHARGE_LOGS_T.N_CLOSE_REASON_ID%TYPE	NUMBER		Close reason
b_Force	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Forcibly override close reason

PROCEDURE CORRECT_CHARGE_LOG_TOTAL_SUMS

Correcting decimal amounts by charge log.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Charge log
b_UpdateTotals	IN	MAIN.BOOL	NUMBER	MAIN.b_TRUE	Update total lines

PROCEDURE SD_CHARGE_LOGS_C_DEL

Delete a charge log line.

Argument	Direction	Reference type	Type	Default value	Description
num_N_LINE_ID	IN	SD_GOOD_MOVES.N_LINE_ID%TYPE	NUMBER		Charge log line

PROCEDURE ACCESS_SERV_CHG_STATE

DEPRECATED in v5.1! Switch access service on/off.

Argument	Direction	Reference type	Type	Default value	Description
num_N_GOOD_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER		Access service
num_N_PARENT_GOOD_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER	NULL	Price plan
num_N_ACCOUNT_ID	IN	SI_SUBSCRIPTIONS.N_ACCOUNT_ID%TYPE	NUMBER		Account
num_N_OBJECT_ID	IN	SI_OBJECTS.N_OBJECT_ID%TYPE	NUMBER	NULL	Equipment
num_N_CHARGE_LOG_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER	NULL	Charge log
b_Enable	IN	MAIN.BOOL	NUMBER		Enable/Disable? {} CONST.b_TRUE — enable {} CONST.b_FALSE — disable
b_Manual	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Switch mode: {} CONST.b_TRUE — manual {} CONST.b_FALSE — auto

PROCEDURE CHANGE_CHARGE_LOG_PERIOD

Change end date of a charge log (both premature closing and stretching of a charge log).

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Charge log
dt_D_OPER	IN	SD_GOOD_MOVES.D_END%TYPE	DATE	UTILS2_PKG_S.GET_SYSDATE	New closing date
num_N_CLOSE_REASON_ID	IN	SD_CHARGE_LOGS_T.N_CLOSE_REASON_ID%TYPE	NUMBER	NULL	Charge log close reason

PROCEDURE DISCONNECT_ACCESS_SERVS

DEPRECATED in v5.1! Switch off all access services by account.

Argument	Direction	Reference type	Type	Default value	Description
num_N_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Account

PROCEDURE SD_CHARGE_LOGS_T_PUT

Create or replace charge log header.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN/OUT	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Document
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 (contract)
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 number
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
dt_D_END_INITIAL	IN	SD_CHARGE_LOGS_T.D_END_INITIAL%TYPE	DATE	NULL	Scheduled end date
dt_D_SCHED_DEFER_END	IN	SD_CHARGE_LOGS_T.D_SCHED_DEFER_END%TYPE	DATE	NULL	Credit limit period end for scheduled services
dt_D_UNSCHED_DEFER_END	IN	SD_CHARGE_LOGS_T.D_UNSCHED_DEFER_END%TYPE	DATE	NULL	Credit limit period end for unscheduled services
num_N_CLOSE_REASON_ID	IN	SD_CHARGE_LOGS_T.N_CLOSE_REASON_ID%TYPE	NUMBER	NULL	Charge log close reason
num_N_CANCEL_REASON_ID	IN	SD_CHARGE_LOGS_T.N_CANCEL_REASON_ID%TYPE	NUMBER	NULL	Charge log cancel reason
dt_D_CLOSABLE	IN	SD_CHARGE_LOGS_T.D_CLOSABLE%TYPE	DATE	NULL	Date since which the charge log can be closed
dt_D_BILLING_DATE	IN	SD_CHARGE_LOGS_T.D_BILLING_DATE%TYPE	DATE	NULL	Date of the next billing day
vch_VC_REM	IN	SD_DOCUMENTS.VC_REM%TYPE	VARCHAR2	NULL	Remark
num_N_WORKFLOW_ID	IN	SD_DOCUMENTS.N_WORKFLOW_ID%TYPE	NUMBER	NULL	Workflow
tbl_T_TAGS	IN	TAGS	TABLE	TAGS()	Tags

PROCEDURE CANCEL_CHARGE_LOG

Cancel charge log.

Argument	Direction	Reference type	Type	Default value	Description
num_N_CHARGE_LOG_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Charge log

PROCEDURE EXECUTE_CHARGE_LOG

Change charge log state to executed.

Argument	Direction	Reference type	Type	Default value	Description
num_N_CHARGE_LOG_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Charge log

SD_CHARGE_LOGS_PKG_S

DEPRECATED in v5.1! Service package for charge log management

TYPE DEFER_PARAMS PL/SQL RECORD

Defer params from price order by charge log.
TYPE GOOD_BURST_VALUE_TYPE PL/SQL TABLE

FUNCTION GET_CHARGE_LOG_BURST_VALUES

Получение текущих значений burst для услуг в составе тарифного плана.

FUNCTION GET_CHARGE_LOG_BY_CONTRACT

Определить последний акт начислений по договору и счету (без учета того, выставлен акт начислений по тарифному плану или услуге).

FUNCTION GET_NONPAY_BLOCK_CHARGE_LOG

Определение текущего акта начислений по блокировке за неуплату по лицевому счету.

FUNCTION CALC_PRICE_FOR_CHARGE_LOG_GOOD

Расчет стоимости подключения услуги в составе пакета по действующему акту начислений.

FUNCTION GET_DEFER_PARAMS

Get price order defer parameters by charge log.

FUNCTION GET_PRICE_BY_RGMT

Определить по ОРДУ действующую строку ПЦ для потоковой услуги.

FUNCTION GET_PRICE_DOC

Получение заголовка приказа по ценам, который используется в акте начислений.

FUNCTION GET_CHARGE_LOG_LINE_PRICE_GOOD

Определить строку движения по фирме, оборудованию и детальной услуге, входящей в неизвестный тарифный план.

FUNCTION GET_APPLIED_PROVISION_RULE

Get provision rule that charge log was created with.

FUNCTION GET_BILLING_DATE

Get charge log billing date.

FUNCTION GET_PRICE_LINE_AND_ACCOUNT

Определение родительской строки ПЦ и счета по услуге в составе тарифного плана.

FUNCTION GET_CHARGE_LOG_BEGIN_DATE

Определение даты начала действия акта начислений.

FUNCTION GET_CHARGE_LOG_LINE_BY_OBJECT

Определить строку движения по оборудованию и детальной услуге, входящей в неизвестный тарифный план.

FUNCTION GET_CLOSE_REASON_ID

Получение причины закрытия акта начислений.

FUNCTION GET_CL_PAR_LINE_FOR_GOOD

Подбор подходящей родительской строки в акте начислений для потоковых услуг.

FUNCTION GET_DOC_FOR_CURRENT_GOOD

Определить акт начислений для оказываемой в текущий момент услуги.

FUNCTION GET_PREPARED_CHARGE_LOG

Get prepared charge log by subscription. Raises too_many_rows if several prepared charge logs found.

FUNCTION IS_NONPAY_SUSPENSION_CL

Check if charge log is for nonpayment suspension

FUNCTION GET_BLOCKING_GP_PRICE

Определение тарифа блокировки по договору на оказание услуг, доп. соглашению или приложению.

FUNCTION GET_CHARGE_LOG_ID_BY_SUBJ_GOOD

Определение акта начислений по подписке на услугу.

FUNCTION GET_CHARGE_LOG_LINE_FOR_GOOD

Get latest charge log line for a specified service and a customer/account/contract/equipment within a specified time period.

FUNCTION GET_LAST_TARIFF

Определение последнего тарифного плана абонента.

Terminate contract/appendix/addendum. 1) Sets the charge logs end dates to contract termination date. 2) Sets the subscriptions end dates to contract termination date. 3) Deletes the subscriptions to services that can be provided after the contract is terminated. 4) Sets the contract end date.

SD_INVOICES_PKG

Invoices

TYPE RENDERED_SERVICES_TBL PL/SQL TABLE

PROCEDURE CORRECT_INVOICE_TOTAL_SUMS

Correcting decimal amounts by charge log.

PROCEDURE EXECUTE_CHARGE_LOG

Change charge log state to executed.

PROCEDURE MAKE_CHARGE_LOG_CLOSABLE

Make charge log closable.

PROCEDURE RAISE_DOC_EVENTS

DEPRECATED in v5.1! Generate events by charge log.

PROCEDURE ACCESS_SERV_CHG_STATE

DEPRECATED in v5.1! Switch access service on/off.

PROCEDURE ACTUALIZE_CHARGE_LOG

Change charge log state to actual.

PROCEDURE CANCEL_CHARGE_LOG

Cancel charge log.

PROCEDURE CHANGE_INVOICE_PERIOD

Change end date of a charge log (both premature closing and stretching of a charge log).

PROCEDURE COMPRESS_CHARGE_LOG

Compress charge log contents. Collapses lines in SD_GOOD_MOVES.

PROCEDURE CONNECT_ACCESS_SERVS

DEPRECATED in v5.1! Switch on all access services by account.

PROCEDURE SD_INVOICES_T_PUT

Create or replace invoice header.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN/OUT	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Invoice
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
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 number
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
dt_D_END_INITIAL	IN	SD_INVOICES_T.D_END_INITIAL%TYPE	DATE	NULL	Scheduled end date
vch_VC_REM	IN	SD_DOCUMENTS.VC_REM%TYPE	VARCHAR2	NULL	Remark
dt_D_SCHED_DEFER_END	IN	SD_INVOICES_T.D_SCHED_DEFER_END%TYPE	DATE	NULL	Credit limit period end for scheduled services
num_N_WORKFLOW_ID	IN	SD_DOCUMENTS.N_WORKFLOW_ID%TYPE	NUMBER	NULL	Workflow
dt_D_UNSCHED_DEFER_END	IN	SD_INVOICES_T.D_UNSCHED_DEFER_END%TYPE	DATE	NULL	Credit limit period end for unscheduled services
tbl_T_TAGS	IN	TAGS	TABLE	TAGS()	Tags
num_N_CLOSE_REASON_ID	IN	SD_INVOICES_T.N_CLOSE_REASON_ID%TYPE	NUMBER	NULL	Charge log close reason
num_N_CANCEL_REASON_ID	IN	SD_INVOICES_T.N_CANCEL_REASON_ID%TYPE	NUMBER	NULL	Charge log cancel reason
dt_D_CLOSABLE	IN	SD_INVOICES_T.D_CLOSABLE%TYPE	DATE	NULL	Date since which the charge log can be closed
dt_D_BILLING_DATE	IN	SD_INVOICES_T.D_BILLING_DATE%TYPE	DATE	NULL	Date of the next billing day

PROCEDURE SET_CHARGE_LOG_CLOSE_REASON

Set charge log end.

PROCEDURE DISCONNECT_ACCESS_SERVS

DEPRECATED in v5.1! Switch off all access services by account.

PROCEDURE SD_INVOICES_C_PUT

Argument	Direction	Reference type	Type	Default value	Description
num_N_LINE_ID	IN/OUT	SD_INVOICES_C.N_LINE_ID%TYPE	NUMBER
num_N_DOC_ID	IN	SD_GOOD_MOVES.N_DOC_ID%TYPE	NUMBER		Document
num_N_INVOICE_ID	IN	SD_INVOICES_C.N_INVOICE_ID%TYPE	NUMBER
num_N_GOOD_ID	IN	SD_GOOD_MOVES.N_GOOD_ID%TYPE	NUMBER	NULL	Service
num_N_CONTRACT_ID	IN	SD_INVOICES_C.N_CONTRACT_ID%TYPE	NUMBER	NULL
num_N_MOVE_TYPE_ID	IN	SD_GOOD_MOVES.N_MOVE_TYPE_ID%TYPE	NUMBER	NULL	Transaction type (REF_TYPE_Good_Move_Type reference)
num_N_SERVICE_ID	IN	SD_INVOICES_C.N_SERVICE_ID%TYPE	NUMBER
num_N_PAR_LINE_ID	IN	SD_GOOD_MOVES.N_PAR_LINE_ID%TYPE	NUMBER	NULL	Parent line (price plan)
num_N_UNIT_ID	IN	SD_INVOICES_C.N_UNIT_ID%TYPE	NUMBER		Measuring unit
num_N_UNIT_ID	IN	SD_GOOD_MOVES.N_UNIT_ID%TYPE	NUMBER	NULL	Unit (REF_TYPE_Measure_Unit, REF_TYPE_Unit_Time_Type, REF_TYPE_Unit_Data_Type, REF_TYPE_Unit_DataSpeed_Type references)
num_N_QUANTITY	IN	SD_INVOICES_C.N_QUANTITY%TYPE	NUMBER	NULL	Quantity
num_N_QUANT	IN	SD_GOOD_MOVES.N_QUANT%TYPE	NUMBER	NULL	Quantity
num_N_UNIT_BASE_ID	IN	SD_INVOICES_C.N_UNIT_BASE_ID%TYPE	NUMBER	NULL	Basic measuring unit
num_N_QUANTITY_BASE	IN	SD_INVOICES_C.N_QUANTITY_BASE%TYPE	NUMBER	NULL	Quantity in basic units
num_N_QUANT_BASE	IN	SD_GOOD_MOVES.N_QUANT_BASE%TYPE	NUMBER	NULL	Quantity in basic units
num_N_TAX_RATE_ID	IN	SD_INVOICES_C.N_TAX_RATE_ID%TYPE	NUMBER	NULL	Tax rate
num_N_CURRENCY_ID	IN	SD_INVOICES_C.N_CURRENCY_ID%TYPE	NUMBER	NULL	Currency
num_N_PRICE	IN	SD_INVOICES_C.N_PRICE%TYPE	NUMBER		Service price
num_N_PRICE	IN	SD_GOOD_MOVES.N_PRICE%TYPE	NUMBER	NULL	Price including taxes
num_N_PRICE_WO_TAX	IN	SD_INVOICES_C.N_PRICE_WO_TAX%TYPE	NUMBER	NULL	Price excl. taxes
num_N_PRICE_LINE_ID	IN	SD_INVOICES_C.N_PRICE_LINE_ID%TYPE	NUMBER	NULL	Price line
num_N_BASE_SUM	IN	SD_GOOD_MOVES.N_BASE_SUM%TYPE	NUMBER	NULL	Pre-discount amount
num_N_AMOUNT_WO_TAX	IN	SD_INVOICES_C.N_AMOUNT_WO_TAX%TYPE	NUMBER	NULL	Amount excl. taxes
num_N_BASE_SUM_WO_TAX	IN	SD_GOOD_MOVES.N_BASE_SUM_WO_TAX%TYPE	NUMBER	NULL	Pre-discount amount excluding taxes
num_N_AMOUNT_TAX	IN	SD_INVOICES_C.N_AMOUNT_TAX%TYPE	NUMBER	NULL	Taxes
num_N_AMOUNT	IN	SD_INVOICES_C.N_AMOUNT%TYPE	NUMBER	NULL	Amount
num_N_SUM_WO_TAX	IN	SD_GOOD_MOVES.N_SUM_WO_TAX%TYPE	NUMBER	NULL	Amount excluding taxes
num_N_BASE_AMOUNT	IN	SD_INVOICES_C.N_BASE_AMOUNT%TYPE	NUMBER	NULL	Amount excl. discounts
num_N_SUM_TAX	IN	SD_GOOD_MOVES.N_SUM_TAX%TYPE	NUMBER	NULL	Taxes
num_N_BASE_AMOUNT_WO_TAX	IN	SD_INVOICES_C.N_BASE_AMOUNT_WO_TAX%TYPE	NUMBER	NULL	Amount excl. discounts and taxes
num_N_SUM	IN	SD_GOOD_MOVES.N_SUM%TYPE	NUMBER	NULL	Amount including taxes
num_N_DISCOUNT_CERT_LINE_ID	IN	SD_INVOICES_C.N_DISCOUNT_CERT_LINE_ID%TYPE	NUMBER	NULL	Discount ID
num_N_OBJECT_ID	IN	SD_GOOD_MOVES.N_OBJECT_ID%TYPE	NUMBER	NULL	Equipment
num_N_EQUIPMENT_ID	IN	SD_INVOICES_C.N_EQUIPMENT_ID%TYPE	NUMBER	NULL	CPE
num_N_LINE_NO	IN	SD_INVOICES_C.N_LINE_NO%TYPE	NUMBER	NULL	Line number
dt_D_BEGIN	IN	SD_INVOICES_C.D_BEGIN%TYPE	DATE	NULL	Start date
dt_D_END	IN	SD_INVOICES_C.D_END%TYPE	DATE	NULL	End date
dt_D_OPER	IN	SD_GOOD_MOVES.D_OPER%TYPE	DATE	NULL	Operation date (charge date)
vch_VC_REM	IN	SD_INVOICES_C.VC_REM%TYPE	VARCHAR2	NULL	Remark
num_N_ADDRESS_ID	IN	SD_GOOD_MOVES.N_ADDRESS_ID%TYPE	NUMBER	NULL	Address
num_N_PROVIDER_ID	IN	SD_GOOD_MOVES.N_PROVIDER_ID%TYPE	NUMBER	NULL	Address provider
num_N_BASE_LINE_ID	IN	SD_GOOD_MOVES.N_BASE_LINE_ID%TYPE	NUMBER	NULL	Basic line
num_N_SUBJ_GOOD_ID	IN	SD_GOOD_MOVES.N_SUBJ_GOOD_ID%TYPE	NUMBER	NULL	Service subscription
num_N_PROVISION_RULE_ID	IN	SR_PROVISION_RULES.N_PROVISION_RULE_ID%TYPE	NUMBER	NULL
dt_D_PROVISION_BEGIN	IN	SD_GOOD_MOVES.D_PROVISION_BEGIN%TYPE	DATE	NULL	Service provisioning start date

PROCEDURE SD_INVOICES_C_COPY

Copy invoice content line.

PROCEDURE SD_PROFORMA_INVOICES_CREATE

Create proforma invoices

Argument	Direction	Reference type	Type	Default value	Description
dt_D_BEGIN	IN	DATE	DATE		Lookup period start date
dt_D_END	IN	DATE	DATE		Lookup period end date
num_N_FIRM_ID	IN	SD_DOCUMENTS.N_FIRM_ID%TYPE	NUMBER		Division
num_N_FIRM_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Division account
num_N_CONTRACT_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER	NULL	Customer contract
num_N_USER_ID	IN	SI_SUBJECTS.N_SUBJECT_ID%TYPE	NUMBER	NULL	Customer
num_N_SERVICE_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER	NULL	Service
dt_D_INVOICES	IN	DATE	DATE	NULL	Operation date
num_N_REPLACE_UNKNOWN_UNIT_ID	IN	SI_REF.N_REF_ID%TYPE	NUMBER	CONST.UNIT_Piece	Unit for replacing unknown units
b_SplitContracts	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Group by contract?
b_Actualize	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Actualize created invoices?
num_N_MAX_COUNT	IN	NUMBER	NUMBER	NULL	Maximum number of invoices
b_SplitObjects	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Group by equipment?
b_SeparateByObjects	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Create separate invoices for different objects
tbl_T_TAGS	IN	TAGS	TABLE	TAGS()

PROCEDURE SD_INVOICES_CREATE

Create invoices.

Argument	Direction	Reference type	Type	Default value	Description
dt_D_BEGIN	IN	DATE	DATE		Lookup period start date
dt_D_END	IN	DATE	DATE		Lookup period end date
dt_D_BEGIN_AddServExclude	IN	DATE	DATE	NULL	Exclude additional services starting on
dt_D_END_AddServExclude	IN	DATE	DATE	NULL	Exclude additional services until
num_N_FIRM_ID	IN	SD_DOCUMENTS.N_FIRM_ID%TYPE	NUMBER		Division
num_N_FIRM_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Division account
num_N_CONTRACT_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER	NULL	Customer contract
num_N_BASE_SUBJ_TYPE_ID	IN	SI_SUBJECTS.N_SUBJ_TYPE_ID%TYPE	NUMBER	NULL	Basic subject type
num_N_USER_ID	IN	SI_SUBJECTS.N_SUBJECT_ID%TYPE	NUMBER	NULL	Customer
num_N_DOC_STATE_ID	IN	SD_DOCUMENTS.N_DOC_STATE_ID%TYPE	NUMBER	NULL	Document state
dt_D_INVOICES	IN	DATE	DATE	NULL	Operation date
num_N_REPLACE_UNKNOWN_UNIT_ID	IN	SI_REF.N_REF_ID%TYPE	NUMBER	CONST.UNIT_Piece	Unit for replacing unknown units
b_SplitContracts	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Group by contract?
b_SplitAccounts	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Group by account?
b_SplitObjects	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Group by equipment?
b_SeparateByObjects	IN	CONST.BOOL	NUMBER	CONST.b_TRUE
b_Actualize	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Actualize created invoices?
b_OnlyNegativeBal	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Create invoices ONLY for customers with negative account balances?
b_ConsiderProformaInvoices	IN	CONST.BOOL	NUMBER	CONST.b_FALSE
num_N_GOOD_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER	NULL	Service/Price plan
b_CommitEveryInvoice	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Commit after each invoice?
tbl_T_TAGS	IN	TAGS	TABLE	TAGS()
b_SplitDiscounts	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Group by discount certificate line?

FUNCTION GET_RENDERED_SERVICES

Get cursor value.

PROCEDURE SD_INVOICES_CHANGE_STATE

Change invoice state. Attention: this procedure is only to be called from SD_DOC_STATES_PKG.SD_DOCUMENTS_CHANGE_STATE. The actual state change is performed there, this procedure only performs invoice-specific operations.

FUNCTION SD_INVOICES_PREPAYMENT_CREATE

Create prepayment invoice.

Argument	Direction	Reference type	Type	Default value	Description
num_N_FIRM_ID	IN	SD_DOCUMENTS.N_FIRM_ID%TYPE	NUMBER		Division
num_N_FIRM_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Division account
num_N_CONTRACT_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Customer contract
num_N_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER	NULL	Account
num_N_USER_ID	IN	SI_SUBJECTS.N_SUBJECT_ID%TYPE	NUMBER		Customer
num_N_GOOD_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER		Service
dt_D_INVOICES	IN	DATE	DATE	SYSDATE	Invoice date
num_N_TAX_RATE_ID	IN	SI_REF.N_REF_ID%TYPE	NUMBER	NULL	Tax rate
num_N_CURRENCY_ID	IN	SI_REF.N_REF_ID%TYPE	NUMBER	NULL	Currrency
num_N_SUM_WO_TAX	IN	NUMBER	NUMBER	NULL	Amount excluding taxes
num_N_SUM_TAX	IN	NUMBER	NUMBER	NULL	Taxes
num_N_SUM	IN	NUMBER	NUMBER		Amount
b_Actualize	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Actualize invoices?
RETURN SD_DOCUMENTS.N_DOC_ID%TYPE					Invoice

SD_INVOICES_PKG_S

DEPRECATED in v5.1! Service package for charge log management

TYPE DEFER_PARAMS PL/SQL RECORD

Defer params from price order by charge log.
TYPE GOOD_BURST_VALUE_TYPE PL/SQL TABLE

FUNCTION GET_APPLIED_PROVISION_RULE

Get provision rule that charge log was created with.

FUNCTION GET_BLOCKING_GP_PRICE

Определение тарифа блокировки по договору на оказание услуг, доп. соглашению или приложению.

FUNCTION GET_LAST_TARIFF

Определение последнего тарифного плана абонента.

FUNCTION GET_PRICE_LINE_AND_ACCOUNT

Определение родительской строки ПЦ и счета по услуге в составе тарифного плана.

FUNCTION IS_NONPAY_SUSPENSION_CL

Check if charge log is for nonpayment suspension

FUNCTION GET_DOC_FOR_CURRENT_GOOD

Определить инвойс для оказываемой в текущий момент услуги.

FUNCTION GET_INVOICE_BEGIN_DATE

Определение даты начала действия инвойса.

FUNCTION GET_INVOICE_BY_CONTRACT

Определить последний инвойс по договору и счету (без учета того, выставлен инвойс по тарифному плану или услуге).

FUNCTION GET_PRICE_DOC

Получение заголовка приказа по ценам, который используется в инвойсе.

FUNCTION GET_INVOICE_BURST_VALUES

Получение текущих значений burst для услуг в составе тарифного плана.

FUNCTION GET_BILLING_DATE

Get charge log billing date.

FUNCTION GET_CLOSE_REASON_ID

Получение причины закрытия инвойса.

FUNCTION GET_DEFER_PARAMS

Get price order defer parameters by charge log.

FUNCTION GET_INVOICE_LINE_BY_OBJECT

Определить строку движения по оборудованию и детальной услуге, входящей в неизвестный тарифный план.

FUNCTION GET_INVOICE_PAR_LINE_FOR_GOOD

Подбор подходящей родительской строки в инвойсе для потоковых услуг.

FUNCTION GET_INVOICE_LINE_PRICE_GOOD

Определить строку движения по фирме, оборудованию и детальной услуге, входящей в неизвестный тарифный план.

FUNCTION GET_PREPARED_CHARGE_LOG

Get prepared charge log by subscription. Raises too_many_rows if several prepared charge logs found.

FUNCTION GET_PRICE_BY_RGMT

Определить по ОРДУ действующую строку ПЦ для потоковой услуги.

FUNCTION CALC_PRICE_FOR_INVOICE_GOOD

Расчет стоимости подключения услуги в составе пакета по действующему инвойсу.

FUNCTION GET_INVOICE_ID_BY_SUBJ_GOOD

Определение инвойса по подписке на услугу.

FUNCTION GET_INVOICE_LINE_FOR_GOOD

Get latest charge log line for a specified service and a customer/account/contract/equipment within a specified time period.

FUNCTION GET_NONPAY_BLOCK_INVOICE

Определение текущего инвойса по блокировке за неуплату по лицевому счету.

SD_OVERDRAFTS_PKG

Credit limit management

PROCEDURE UNSET_PERMANENT_OVERDRAFT

Remove currently active permanent credit limit.

PROCEDURE SET_TEMPORAL_OVERDRAFT

Set temporary credit limit.

PROCEDURE UNSET_TEMPORAL_OVERDRAFT

Remove currently active temporary credit limit.

PROCEDURE SET_PERMANENT_OVERDRAFT

Set permanent credit limit.

SD_PAYMENT_REQUESTS_PKG

Managing auto top-up requests and subscriptions.

TYPE RECOMMENDED_PAYMENT_WS_TBL PL/SQL TABLE

FUNCTION GET_RECOMMENDED_PAYMENT_WS_P

Get recommended payment rows with subscription. Function does not return a row with totals.

FUNCTION FILL_RECOMMENDED_PAYMENT_TT

Fill recommended payment temporary tables.

FUNCTION GET_RECOMMENDED_PAYMENT_WS_C

Get recommended payment rows with subscriptions. Function does not return a row with totals.

SI_OBJECTS_PKG_S

Object management

PROCEDURE CHECK_OBJ_ACTIVE_INVOICES

Check if the equipment is used in actual/prepared/processing charge logs. Raises an exception if used.

PROCEDURE CHECK_OBJ_ACTIVE_CHARGE_LOGS

Check if the equipment is used in actual/prepared/processing charge logs. Raises an exception if used.

SI_SUBJECTS_PKG_S

Subjects management

FUNCTION GET_SUBJ_N_REF_VALUE_BY_CODE

Get ref custom value.

PROCEDURE VALIDATE_GROUP_BASIC_CONTRACTS

Check if group has actual basic contract.

SI_SUBSCRIPTIONS_PKG

Service subscriptions management

PROCEDURE SI_SUBSCRIPTIONS_PUT

Create or update a service subscription.

Argument	Direction	Reference type	Type	Default value	Description
num_N_SUBSCRIPTION_ID	IN/OUT	SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE	NUMBER		Subscription ID
num_N_SERVICE_ID	IN	SI_SUBSCRIPTIONS.N_SERVICE_ID%TYPE	NUMBER		Service
num_N_CUSTOMER_ID	IN	SI_SUBSCRIPTIONS.N_SUBJECT_ID%TYPE	NUMBER		Customer
num_N_ACCOUNT_ID	IN	SI_SUBSCRIPTIONS.N_ACCOUNT_ID%TYPE	NUMBER		Account
num_N_OBJECT_ID	IN	SI_SUBSCRIPTIONS.N_OBJECT_ID%TYPE	NUMBER	NULL	Equipment
num_N_PAY_DAY	IN	SI_SUBSCRIPTIONS.N_BILLING_DAY%TYPE	NUMBER	NULL	Pay day
num_N_LINE_NO	IN	SI_SUBSCRIPTIONS.N_LINE_NO%TYPE	NUMBER	NULL	Customer subscriptions line number
num_N_QUANT	IN	SI_SUBSCRIPTIONS.N_QUANT%TYPE	NUMBER	NULL	Quantity
num_N_UNIT_ID	IN	SI_SUBSCRIPTIONS.N_UNIT_ID%TYPE	NUMBER	NULL	Measurement unit (SI_V_UNITS)
num_N_DOC_ID	IN	SI_SUBSCRIPTIONS.N_DOC_ID%TYPE	NUMBER		Contract
num_N_PAR_SUBSCRIPTION_ID	IN	SI_SUBSCRIPTIONS.N_PAR_SUBSCRIPTION_ID%TYPE	NUMBER	NULL	Parent subscription line
dt_D_BEGIN	IN	SI_SUBSCRIPTIONS.D_BEGIN%TYPE	DATE	NULL	Subscription begin date
dt_D_END	IN	SI_SUBSCRIPTIONS.D_END%TYPE	DATE	NULL	Subscription end date
dt_D_INVOICE_END	IN	SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE	DATE	NULL	Next charge log end date
dt_D_CHARGE_LOG_END	IN	SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE	DATE	NULL	Next charge log end date
num_N_PREV_SUBSCRIPTION_ID	IN	SI_SUBSCRIPTIONS.N_PREV_SUBSCRIPTION_ID%TYPE	NUMBER	NULL	Previous subscription
num_N_CL_CREATING_STATE_ID	IN	SI_SUBSCRIPTIONS.N_CL_CREATING_STATE_ID%TYPE	NUMBER	CONST.CL_Creating_Allowed	State of creating charge logs
num_N_SERVICE_STATE_ID	IN	SI_SUBSCRIPTIONS.N_SERVICE_STATE_ID%TYPE	NUMBER	NULL	Service state
num_N_INVOICING_SCHEME_ID	IN	SI_SUBSCRIPTIONS.N_INVOICING_SCHEME_ID%TYPE	NUMBER	NULL	Invoicing scheme
b_EvaluateDiscounts	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Analyze and provide discounts?
b_FilterByContext	IN	CONST.BOOL	NUMBER	NULL	Use current user from context to restrict available services? By default: yes if context is not empty (N_USER_ID is not null)
b_RecreateOnUpdate	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Recreate subscription instead update?
b_UseMaterializedView	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Use materialized view?

SI_USERS_PKG

Customers management.

PROCEDURE SI_USER_GOODS_CLOSE

Close a subscription to a service.

PROCEDURE ACCESS_SERV_CHG_STATE

Enable or disable an access service.

PROCEDURE SI_USER_GOODS_PUT

Create or update a subscription to a service.

Argument	Direction	Reference type	Type	Default value	Description
num_N_SUBJ_GOOD_ID	IN/OUT	SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE	NUMBER		Subscription to a service
num_N_GOOD_ID	IN	SI_SUBSCRIPTIONS.N_SERVICE_ID%TYPE	NUMBER		Service
num_N_SUBJECT_ID	IN	SI_SUBSCRIPTIONS.N_SUBJECT_ID%TYPE	NUMBER		Customer
num_N_ACCOUNT_ID	IN	SI_SUBSCRIPTIONS.N_ACCOUNT_ID%TYPE	NUMBER		Customer account
num_N_OBJECT_ID	IN	SI_SUBSCRIPTIONS.N_OBJECT_ID%TYPE	NUMBER	NULL	CPE
num_N_PAY_DAY	IN	SI_SUBSCRIPTIONS.N_BILLING_DAY%TYPE	NUMBER	NULL	Billing date
num_N_LINE_NO	IN	SI_SUBSCRIPTIONS.N_LINE_NO%TYPE	NUMBER	NULL	Line number
num_N_QUANT	IN	SI_SUBSCRIPTIONS.N_QUANT%TYPE	NUMBER	NULL	Quantity
num_N_UNIT_ID	IN	SI_SUBSCRIPTIONS.N_UNIT_ID%TYPE	NUMBER	NULL	Measuring unit (REF_TYPE_Measure_Unit reference data)
num_N_DOC_ID	IN	SI_SUBSCRIPTIONS.N_DOC_ID%TYPE	NUMBER		Service contract/addendum/annex
num_N_PAR_SUBJ_GOOD_ID	IN	SI_SUBSCRIPTIONS.N_PAR_SUBSCRIPTION_ID%TYPE	NUMBER	NULL	Parent subscription for a service within a price plan
dt_D_BEGIN	IN	SI_SUBSCRIPTIONS.D_BEGIN%TYPE	DATE	NULL	Subscription start date
dt_D_END	IN	SI_SUBSCRIPTIONS.D_END%TYPE	DATE	NULL	Subscription end date
dt_D_INVOICE_END	IN	SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE	DATE	NULL	Charge log end date
dt_D_CHARGE_LOG_END	IN	SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE	DATE	NULL	Charge log end date
num_N_PREV_SUBSCRIPTION_ID	IN	SI_SUBSCRIPTIONS.N_PREV_SUBSCRIPTION_ID%TYPE	NUMBER	NULL	Previous subscription
num_N_CL_CREATING_STATE_ID	IN	SI_SUBSCRIPTIONS.N_CL_CREATING_STATE_ID%TYPE	NUMBER	CONST.CL_Creating_Allowed
num_N_SERVICE_STATE_ID	IN	SI_SUBSCRIPTIONS.N_SERVICE_STATE_ID%TYPE	NUMBER	NULL
b_EvaluateDiscounts	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Provide discounts? {} CONST.b_TRUE — check if there are any discounts to apply and issue discount certificates if needed {} CONST.b_FALSE — do not grant any discounts
b_FilterByContext	IN	CONST.BOOL	NUMBER	NULL	Consider a context to restrict available services? {} CONST.b_TRUE — when the attribute "N_APPLICATION_ID" of the context "MAIN" is set to CONST.NETSERV_ARM_Private_Office (a customer is working via the Customer Self-Care Portal), the service is available if its "Permission to subscribe" is set to "Customer or operator"; otherwise "Permission to subscribe" should be set to "Customer or operator" or "Operator only" {} CONST.b_FALSE — the permission to subscribe does not affect the availability of the service {*} NULL — when a user is logged in, the availability of the service is checked as if the value is CONST.b_TRUE, otherwise like CONST.b_FALSE
b_RecreateOnUpdate	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Allow to create a new subscription when changing current subscription parameters? {} CONST.b_TRUE — when changing subscription parameters a new subscription is created instead of updating the current one {} CONST.b_FALSE — the current subscription is updated but only several parameters can be changed: "Billing date", "End date", "Charge log end date"

PROCEDURE TT_V_ONE_TIME_SERV_C_INVOICE

Issue charge logs for one-off services.

FUNCTION CHANGE_TARIFF

Change a price plan within a subscription. If there are no charge logs for the subscription yet and a start date for a new price plan is a past or current date, the existing subscription is modified. Otherwise, an end date is set for the current subscription and a new one is created. If a new service is a suspension one, a separate simultaneous subscription is created for it, and the current subscription remains unclosed. If b_CloseCurrentChargeLog = CONST.b_TRUE, then: 1) when closing the current subscription a charge log in force issued for it also closes with the same date, 2) if the new service is a suspension one, charge logs for all affected subscriptions are closed, not only the current subscription, 3) a charge log for the new subscription is issued.

Argument	Direction	Reference type	Type	Default value	Description
num_N_SUBJ_GOOD_ID	IN	SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE	NUMBER		Subscription to a current price plan
num_N_GOOD_ID	IN	SD_GOOD_MOVES.N_GOOD_ID%TYPE	NUMBER		New price plan or service
dt_D_CHANGE	IN	SI_SUBSCRIPTIONS.D_BEGIN%TYPE	DATE	UTILS2_PKG_S.GET_SYSDATE	Start date for a subscription to the new price plan
dt_D_INVOICE_END	IN	SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE	DATE	NULL	Charge log end date for the subscription to the new price plan; also used as the subscription end date when subscribing to a suspension service
dt_D_CHARGE_LOG_END	IN	SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE	DATE	NULL	Charge log end date for the subscription to the new price plan; also used as the subscription end date when subscribing to a suspension service
num_N_BILLING_DAY	IN	SI_SUBSCRIPTIONS.N_BILLING_DAY%TYPE	NUMBER	NULL	Billing date
b_CloseCurrentInvoice	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Close a charge log for the current subscription? {} CONST.b_TRUE — close the charge log {} CONST.b_FALSE — do not close the charge log
b_CloseCurrentChargeLog	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Close a charge log for the current subscription? {} CONST.b_TRUE — close the charge log {} CONST.b_FALSE — do not close the charge log
b_UseSubscriptionBillingDay	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Use a billing date from the current subscription in the new subscription? {} CONST.b_TRUE — the new subscription has the same billing date as the current one {} CONST.b_FALSE — num_N_BILLING_DAY is used for the new subscription
RETURN SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE					Subscription to the new price plan or service

PROCEDURE CHANGE_TARIFF

PROCEDURE CHANGE_INVOICE_PERIOD

Change a charge log end date.

PROCEDURE ADD_GOOD_TO_INVOICE

Activate a service within a price plan under a charge log that is either in force or prepared.

PROCEDURE REMOVE_GOOD_FROM_INVOICE

Deactivate a service within a price plan under a charge log that is either in force or prepared.

PROCEDURE CHANGE_CHARGE_LOG_PERIOD

Change a charge log end date.

PROCEDURE REMOVE_GOOD_FROM_CHARGE_LOG

Deactivate a service within a price plan under a charge log that is either in force or prepared.

PROCEDURE TT_V_ONE_TIME_SERV_C_CL

Issue charge logs for one-off services.

PROCEDURE ADD_GOOD_TO_CHARGE_LOG

Activate a service within a price plan under a charge log that is either in force or prepared.

SI_USERS_PKG_S

Retrieving data on customers, accounts, equipment, subscriptions and services.

TYPE INVOICE_SERVS_LIST_TABLE_TYPE PL/SQL TABLE

Table type for available services.
TYPE CL_SERVS_LIST_TABLE_TYPE PL/SQL TABLE

Table type for available services.

FUNCTION GET_INVOICE_SERVS_LIST

Get a list of available services within a price plan under a current charge log.

FUNCTION GET_CHARGE_LOG_SERVS_LIST

Get a list of available services within a price plan under a current charge log.

SR_GOODS_PKG

The product catalog management.

PROCEDURE CREATE_CATALOG_VERSIONS_BY_SCN

Update versions of catalog entries and their custom field values for all divisions by scn.

STR_UTILS_PKG_S

String functions and procedures.

FUNCTION ESCAPE_REGEXP_SYMBOLS

Escape regexp symbols from a string.

Views

AP_V_COMPANIES

Данные юридического лица

AP_V_PERSONS

Данные физического лица

AP_V_USER_OFFICE_BILLS

Состав счетов

AP_V_USER_OFFICE_GOODS

Подписка на услуги абонента

Field	Type	Description
N_SUBJ_GOOD_ID	NUMBER
N_LINE_NO	NUMBER
N_PAR_SUBJ_GOOD_ID	NUMBER
N_GOOD_ID	NUMBER
VC_GOOD	VARCHAR2
N_ACCOUNT_ID	NUMBER
VC_ACCOUNT	VARCHAR2
N_OBJECT_ID	NUMBER
VC_OBJECT	VARCHAR2
N_PAY_DAY	NUMBER
N_SUBSCR_PERMISSION_ID	NUMBER
N_SERV_TYPE_ID	NUMBER
N_UNSUBSCR_PERMISSION_ID	NUMBER
N_SERV_END_CHARGE_TYPE_ID	NUMBER
N_DOC_ID	NUMBER
N_DOC_TYPE_ID	NUMBER
VC_DOC_NAME	VARCHAR2
VC_DOC_CODE	VARCHAR2
D_BEGIN	DATE
D_END	DATE
N_CHARGE_LOG_ID	NUMBER
VC_CHARGE_LOG_CODE	VARCHAR2
VC_CHARGE_LOG_NAME	VARCHAR2
N_INVOICE_ID	NUMBER
VC_INVOICE_CODE	VARCHAR2
VC_INVOICE_NAME	VARCHAR2

RPT_V_ADDRESSES

Отчет по использованию адресов

Field	Type	Description
N_ADDRESS_ID	NUMBER
VC_IP_ADDRESS	VARCHAR2	IP адрес
N_ADDRESS_ID	NUMBER
N_PHONE_NUMBER	NUMBER	Телефонный номер
N_ADDRESS_ID	NUMBER
N_ADDR_TYPE_ID	NUMBER	Тип адреса
N_ADDRESS_ID	NUMBER
VC_CODE	VARCHAR2	Код адреса
N_ADDRESS_ID	NUMBER
VC_NAME	VARCHAR2	Наименование адреса
N_ADDRESS_ID	NUMBER
N_VALUE	NUMBER	Начало диапазона
N_ADDRESS_ID	NUMBER
N_VALUE_2	NUMBER	Конец диапазона
N_ADDRESS_ID	NUMBER
VC_VALUE	VARCHAR2
N_ADDRESS_ID	NUMBER
VC_VALUE_2	VARCHAR2
N_ADDRESS_ID	NUMBER
N_FIRM_ID	NUMBER	Фирма
N_ADDRESS_ID	NUMBER
D_BEGIN	DATE	Дата начала использования адреса
N_ADDRESS_ID	NUMBER
D_END	DATE	Дата окончания использования адреса
N_ADDRESS_ID	NUMBER
N_ADDR_ASSIGNMENT_ID	VARCHAR2	Использование адреса
N_ADDRESS_ID	NUMBER
VC_REM	VARCHAR2	Комментарий к адресу
N_ADDRESS_ID	NUMBER
N_OBJECT_ID	NUMBER	Объект
N_ADDRESS_ID	NUMBER
N_OBJ_STATE_ID	NUMBER	Состояние объекта
N_ADDRESS_ID	NUMBER
N_MAIN_OBJECT_ID	NUMBER	Основной объект
N_ADDRESS_ID	NUMBER
N_MAIN_OBJ_STATE_ID	NUMBER	Состояние основного объекта
N_ADDRESS_ID	NUMBER
N_SERV_ADDR_REGION_ID	NUMBER	Регион из адреса обслуживания
N_ADDRESS_ID	NUMBER
VC_SERV_ADDR_ENTRANCE_NO	VARCHAR2	Подъезд из адреса обслуживания
N_ADDRESS_ID	NUMBER
N_SERV_ADDR_FLOOR_NO	NUMBER	Этаж из адреса обслуживания
N_ADDRESS_ID	NUMBER
VC_SERV_ADDR_FLAT	VARCHAR2	Квартира из адреса обслуживания
N_ADDRESS_ID	NUMBER
VC_SERV_ADDR_DIS_CODE	VARCHAR2	Код домофона из адреса обслуживания
N_ADDRESS_ID	NUMBER
VC_SERV_ADDR_CUSTOM_ADDR	VARCHAR2	Нестандартный адрес из адреса обслуживания
N_ADDRESS_ID	NUMBER
N_PAR_ADDR_REGION_ID	NUMBER	Регион из адреса обслуживания вышестоящего объекта
N_ADDRESS_ID	NUMBER
VC_PAR_ADDR_ENTRANCE_NO	VARCHAR2	Подъезд из адреса обслуживания вышестоящего объекта
N_ADDRESS_ID	NUMBER
N_PAR_ADDR_FLOOR_NO	NUMBER	Этаж из адреса обслуживания вышестоящего объекта
N_ADDRESS_ID	NUMBER
VC_PAR_ADDR_FLAT	VARCHAR2	Квартира из адреса обслуживания вышестоящего объекта
N_ADDRESS_ID	NUMBER
VC_PAR_ADDR_DIS_CODE	VARCHAR2	Код домофона из адреса обслуживания вышестоящего объекта
N_ADDRESS_ID	NUMBER
VC_PAR_ADDR_CUSTOM_ADDR	VARCHAR2	Нестандартный адрес из адреса обслуживания вышестоящего объекта
N_ADDRESS_ID	NUMBER
N_SUBJECT_ID	NUMBER	Абонент
N_ADDRESS_ID	NUMBER
N_SUBJ_STATE_ID	NUMBER	Состояние абонента
N_ADDRESS_ID	NUMBER
N_BASE_SUBJECT_ID	NUMBER	Базовый СУ
N_RESOURCE_ADDRESS_ID	NUMBER	Ресурс
VC_RESOURCE_ADDRESS	VARCHAR2	Ресурс
N_RESOURCE_OBJECT_ID	NUMBER	Объект учета - владелец ресурса для выдачи
VC_RESOURCE_OBJECT	VARCHAR2	Объект учета - владелец ресурса для выдачи
VC_OBJ_CODE	VARCHAR2	Код объекта
VC_OBJ_NAME	VARCHAR2	Наименование объект
VC_MAIN_OBJ_CODE	VARCHAR2	Код основного объекта
VC_MAIN_OBJ_NAME	VARCHAR2	Наименование основного объекта
VC_ADDR_ASSIGNMENT	VARCHAR2	Использование адреса
N_SERV_ADDRESS_ID	NUMBER	Адрес обслуживания оборудования
VC_SERV_ADDRESS	VARCHAR2	Адрес обслуживания оборудования
N_PAR_ADDRESS_ID	NUMBER	Адрес обслуживания вышестоящего объекта
VC_PAR_ADDRESS	VARCHAR2	Адрес обслуживания вышестоящего объекта
VC_SUBJ_CODE	VARCHAR2	Код абонента
VC_SUBJ_NAME	VARCHAR2	Наименование абонента
VC_BASE_SUBJECT_CODE	VARCHAR2	Код базового СУ
VC_BASE_SUBJECT_NAME	VARCHAR2	Наименование базового СУ

RPT_V_USERS

Customer report

Field	Type	Description
N_USER_ID	NUMBER	Customer
T_CUSTOMER_TAGS	TAGS	Customer tags
N_BASE_SUBJECT_ID	NUMBER	Customer basic subject
T_BASE_SUBJECT_TAGS	TAGS	Basic subject tags
N_SERV_STATE_ID	NUMBER
N_FIRM_ID	NUMBER	Division
N_USER_STATE_ID	NUMBER	Customer status
VC_USER_CODE	VARCHAR2	Customer code
D_CREATED	DATE	Creation date
N_RESELLER_ID	NUMBER	Dealer
N_DEVICE_ID	NUMBER	CPE
N_DEVICE_STATE_ID	NUMBER	CPE status
VC_DEVICE	VARCHAR2	CPE name
N_REGION_ID	NUMBER	Region
N_ADDRESS_ID	NUMBER	Service address
VC_ENTRANCE_NO	VARCHAR2	Entrance
N_FLOOR_NO	NUMBER	Floor
VC_FLAT	VARCHAR2	Apartment
VC_VISUAL_ADDRESS	VARCHAR2	Full service address
N_OBJ_ADDR_STATE_ID	NUMBER	Service address status
D_OBJ_ADDRESS_BEGIN	DATE	Start date of the service address validity period
D_OBJ_ADDRESS_END	DATE	End date of the service address validity period
N_RESID_NUMBER	NUMBER	Number of residential premises
N_NONRESID_NUMBER	NUMBER	Number of non-residential premises
N_FLOORS_NUMBER	NUMBER	Number of floors
N_SECTIONS_NUMBER	NUMBER	Number of sections
N_CONTRACT_ID	NUMBER	Contract
N_CNTR_STATE_ID	NUMBER	Contract status
N_BASE_CNTR_ID	NUMBER	Basic contract
D_CNTR_DOC	DATE	Contract date
D_CNTR_BEGIN	DATE	Contract start date
D_CNTR_END	DATE	Contract end date
VC_CONTRACT_REM	VARCHAR2	Contract remark
N_GOOD_ID	NUMBER	Service
N_GOOD_TYPE_ID	NUMBER	Product catalog section the service belongs to
N_HIGH_GOOD_GROUP_ID	NUMBER	Top group of a catalog section the service belongs to
D_FIRST_CL_BEGIN	DATE	Start date of the first charge log
D_LAST_CL_END	DATE	End date of the last charge Log
N_ACCOUNT_ID	NUMBER	Customer account
VC_ACCOUNT_CODE	VARCHAR2	Account code
VC_ACCOUNT_NAME	VARCHAR2	Account name
VC_COMMENT	VARCHAR2	Last comment
D_FIRST_INV_BEGIN	DATE	Дата начала первого инвойса
D_LAST_INV_END	DATE	Дата начала окончания первого инвойса

SD_V_BILLS_C

Состав счетов

Field	Type	Description
N_LINE_ID	NUMBER	Идентификатор записи
N_DOC_ID	NUMBER	Идентификатор документа
VC_DOC_NO	VARCHAR2
VC_DOC_CODE	VARCHAR2
VC_DOC_NAME	VARCHAR2
N_PAR_LINE_ID	NUMBER	Идентификатор вышестоящей записи
N_MOVE_TYPE_ID	NUMBER	Идентификатор типа движения
VC_MOVE_TYPE_NAME	VARCHAR2	Наименование типа движения
N_GOOD_ID	NUMBER	Идентификатор товара или услуги
VC_GOOD_NAME	VARCHAR2	Наименование товара или услуги
N_UNIT_ID	NUMBER	Идентификатор единицы измерения
VC_UNIT_NAME	VARCHAR2	Наименование единицы измерения
N_QUANT	NUMBER	Количество
N_UNIT_BASE_ID	NUMBER	Идентификатор базовой единицы измерения
VC_UNIT_BASE_NAME	VARCHAR2	Наименование базовой единицы измерения
N_QUANT_BASE	NUMBER	Количество в базовых единицах измерения
N_TAX_RATE_ID	NUMBER	Идентификатор ставки налога
VC_TAX_RATE_NAME	VARCHAR2	Наименование ставки налога
N_OBJECT_ID	NUMBER	Идентификатор ОУ
VC_OBJECT_CODE	VARCHAR2	Наименование ОУ
N_CURRENCY_ID	NUMBER	Идентификатор валюты
VC_CURRENCY_NAME	VARCHAR2	Наименование валюты
N_ADDRESS_ID	NUMBER	Идентификатор адреса
VC_ADDRESS_CODE	VARCHAR2	Краткий адрес
N_PRICE	NUMBER	Цена
VC_PRICE_IN_WORDS	VARCHAR2
N_PRICE_WO_TAX	NUMBER	Цена без налогов
VC_PRICE_WO_TAX_IN_WORDS	VARCHAR2
N_SUM	NUMBER	Сумма
VC_SUM_IN_WORDS	VARCHAR2
N_SUM_TAX	NUMBER	Сумма налогов
VC_SUM_TAX_IN_WORDS	VARCHAR2
N_SUM_WO_TAX	NUMBER	Сумма без налогов
VC_SUM_WO_TAX_IN_WORDS	VARCHAR2
N_BASE_SUM	NUMBER	Сумма без скидки
VC_BASE_SUM_IN_WORDS	VARCHAR2
N_BASE_SUM_WO_TAX	NUMBER	Сумма без скидки и налогов
VC_BASE_SUM_WO_TAX_IN_WORDS	VARCHAR2
N_DISCOUNT_CERT_LINE_ID	NUMBER	Идентификатор записи в акте предоставления скидки
N_DISCOUNT_DOC_ID	NUMBER	Акт предоставления скидки
N_LINE_NO	NUMBER	Номер записи по порядку
D_BEGIN	DATE	Дата начала
D_END	DATE	Дата окончания
N_FIRM_ID	NUMBER
VC_REM	VARCHAR2	Комментарий
N_PRICE_LINE_ID	NUMBER	Идентификатор строки ПЦ
N_PRICE_ORDER_DOC_ID	NUMBER	Идентификатор ПЦ
VC_PRICE_ORDER_CODE	VARCHAR2	Краткое наименование ПЦ
D_LOG_LAST_MOD	DATE
N_LOG_SESSION_ID	NUMBER

SD_V_BILLS_JR

Журнал счетов

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	Примечание
VC_TAGS	VARCHAR2	Теги
T_TAGS	TAGS	Теги
N_SUM	NUMBER	Сумма
N_SUM_WO_TAX	NUMBER	Сумма без налогов
N_CURRENCY_ID	NUMBER	Идентификатор валюты
VC_CURRENCY	VARCHAR2	Наименование валюты
VC_CURRENCY_CODE	VARCHAR2
N_PROVIDER_SUBJECT_ID	NUMBER	Идентификатор СУ поставщика
VC_PROVIDER_NAME	VARCHAR2	Наименование СУ поставщика
VC_PROVIDER_CODE	VARCHAR2	Код СУ поставщика
N_RECEIVER_SUBJECT_ID	NUMBER	Идентификатор СУ получателя
VC_RECEIVER_NAME	VARCHAR2	Наименование СУ получателя
VC_RECEIVER_CODE	VARCHAR2	Код СУ получателя
N_FEDERAL_REGION_ID	NUMBER	Регион основного фактического адреса получателя
N_MUNICIPAL_PAR_REGION_ID	NUMBER	Родительский муниципальный регион основного фактического адреса получателя
D_LOG_LAST_MOD	DATE
N_LOG_SESSION_ID	NUMBER

SD_V_BILLS_T

Заголовок счетов

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	Теги

SD_V_INVOICES_C

Состав фактур

Field	Type	Description
N_LINE_ID	NUMBER	Идентификатор записи
N_INVOICE_ID	NUMBER	Идентификатор документа
VC_DOC_NO	VARCHAR2
VC_DOC_CODE	VARCHAR2
VC_DOC_NAME	VARCHAR2
N_SERVICE_ID	NUMBER	Идентификатор товара или услуги
VC_SERVICE_NAME	VARCHAR2	Наименование товара или услуги
N_UNIT_ID	NUMBER	Идентификатор единицы измерения
VC_UNIT_NAME	VARCHAR2	Наименование единицы измерения
N_QUANTITY	NUMBER	Количество
N_UNIT_BASE_ID	NUMBER	Идентификатор базовой единицы измерения
VC_UNIT_BASE_NAME	VARCHAR2	Наименование базовой единицы измерения
N_QUANTITY_BASE	NUMBER	Количество в базовых единицах измерения
N_TAX_RATE_ID	NUMBER	Идентификатор ставки налога
VC_TAX_RATE_NAME	VARCHAR2	Наименование ставки налога
N_EQUIPMENT_ID	NUMBER	Идентификатор ОУ
VC_EQUIPMENT_CODE	VARCHAR2	Наименование ОУ
N_CURRENCY_ID	NUMBER	Идентификатор валюты
VC_CURRENCY_NAME	VARCHAR2	Наименование валюты
N_PRICE	NUMBER	Цена
VC_PRICE_IN_WORDS	VARCHAR2
N_PRICE_WO_TAX	NUMBER	Цена без налогов
VC_PRICE_WO_TAX_IN_WORDS	VARCHAR2
N_AMOUNT	NUMBER	Сумма
VC_SUM_IN_WORDS	VARCHAR2
N_AMOUNT_TAX	NUMBER	Сумма налогов
VC_SUM_TAX_IN_WORDS	VARCHAR2
N_AMOUNT_WO_TAX	NUMBER	Сумма без налогов
VC_SUM_WO_TAX_IN_WORDS	VARCHAR2
N_BASE_AMOUNT	NUMBER	Сумма без скидки
VC_BASE_SUM_IN_WORDS	VARCHAR2
N_BASE_AMOUNT_WO_TAX	NUMBER	Сумма без скидки и налогов
VC_BASE_SUM_WO_TAX_IN_WORDS	VARCHAR2
N_DISCOUNT_CERT_LINE_ID	NUMBER	Идентификатор записи в акте предоставления скидки
N_DISCOUNT_DOC_ID	NUMBER	Акт предоставления скидки
N_LINE_NO	NUMBER	Номер записи по порядку
D_BEGIN	DATE	Дата начала
D_END	DATE	Дата окончания
N_FIRM_ID	NUMBER
VC_REM	VARCHAR2	Комментарий
D_LOG_LAST_MOD	DATE
N_LOG_SESSION_ID	NUMBER
N_DOC_ID	NUMBER	Инвойс
N_SUBJ_GOOD_ID	NUMBER	Подписка на услугу
N_PAR_LINE_ID	NUMBER	Родительская строка
N_MOVE_TYPE_ID	NUMBER	Тип движения
VC_MOVE_TYPE_NAME	VARCHAR2	Наименование типа движения
N_GOOD_ID	NUMBER	Товар или услуга
VC_GOOD_NAME	VARCHAR2	Наименование товара или услуги
N_BASE_GOOD_ID	NUMBER	Базовый товар или услуга
VC_BASE_GOOD_NAME	VARCHAR2	Наименование базового товара или услуги
N_QUANT	NUMBER	Количество
N_QUANT_BASE	NUMBER	Количество в базовых единицах измерения
N_OBJECT_ID	NUMBER	Объект учета по движению
VC_OBJECT_CODE	VARCHAR2	Краткое наименование объекта учета по движению
N_ADDRESS_ID	NUMBER	Адрес
VC_ADDRESS_CODE	VARCHAR2	Краткое наименование адреса
N_BASE_SUM	NUMBER	Сумма без скидки с учетом налогов
N_BASE_SUM_WO_TAX	NUMBER	Сумма без скидки и без учета налогов
N_SUM	NUMBER	Сумма
N_SUM_TAX	NUMBER	Сумма налога
N_SUM_WO_TAX	NUMBER	Сумма без налогов
D_OPER	DATE	Дата операции по строке
N_PRICE_LINE_ID	NUMBER	Строка приказа по ценам
N_PRICE_ORDER_DOC_ID	NUMBER	Приказ по ценам
VC_PRICE_ORDER_CODE	VARCHAR2	Краткое наименование приказа по ценам
N_PROVISION_RULE_ID	NUMBER	Правило оказания услуги
N_PROVIDER_ID	NUMBER	Поставщик

SD_V_INVOICES_JR

Журнал фактур

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	Примечание
VC_TAGS	VARCHAR2	Теги
T_TAGS	TAGS	Теги
N_AMOUNT	NUMBER	Сумма
N_AMOUNT_WO_TAX	NUMBER	Сумма без налогов
N_CURRENCY_ID	NUMBER	Идентификатор валюты
VC_CURRENCY	VARCHAR2	Наименование валюты
VC_CURRENCY_CODE	VARCHAR2
N_PROVIDER_SUBJECT_ID	NUMBER	Идентификатор СУ поставщика
VC_PROVIDER_NAME	VARCHAR2	Наименование СУ поставщика
VC_PROVIDER_CODE	VARCHAR2	Код СУ поставщика
N_RECEIVER_SUBJECT_ID	NUMBER	Идентификатор СУ получателя
VC_RECEIVER_NAME	VARCHAR2	Наименование СУ получателя
VC_RECEIVER_CODE	VARCHAR2	Код СУ получателя
N_FEDERAL_REGION_ID	NUMBER	Регион основного фактического адреса получателя
N_MUNICIPAL_PAR_REGION_ID	NUMBER	Родительский муниципальный регион основного фактического адреса получателя
D_LOG_LAST_MOD	DATE
N_LOG_SESSION_ID	NUMBER
N_SUM	NUMBER	Сумма
N_WRITEOFF_SUM	NUMBER	Сумма за списанные услуги
N_ADD_SERVS_SUM	NUMBER
C_FL_ARCHIVED	CHAR	Флаг архивного документа

SI_V_SUBSCRIPTIONS

Подписка абонентов на услуги

Field	Type	Description
N_SUBSCRIPTION_ID	NUMBER	Идентификатор записи
N_SERVICE_ID	NUMBER	Услуга
VC_SERVICE	VARCHAR2	Наименование услуги
N_CUSTOMER_ID	NUMBER	СУ
N_ACCOUNT_ID	NUMBER	ЛС
VC_ACCOUNT	VARCHAR2	Номер счета
N_OBJECT_ID	NUMBER	ОУ
VC_OBJECT	VARCHAR2	Наименование ОУ
N_PAY_DAY	NUMBER	Расчетный день месяца
N_QUANT	NUMBER	Количество
N_UNIT_ID	NUMBER	Единица измерения
VC_UNIT	VARCHAR2	Наименование единицы измерения
N_DOC_ID	NUMBER	Документ
D_BEGIN	DATE	Дата начала
D_END	DATE	Дата окончания
D_CHARGE_LOG_END	DATE	Дата окончания акта начислений
C_FL_CLOSED	CHAR	Флаг закрытия
N_DOC_TYPE_ID	NUMBER	Тип документа
N_DOC_STATE_ID	NUMBER	Состояние документа
N_PARENT_DOC_ID	NUMBER	Базовый документ
VC_DOC_NAME	VARCHAR2	Наименование документа
VC_DOC_CODE	VARCHAR2	Код документа
D_DOC_BEGIN	DATE	Дата начала документа
D_DOC_END	DATE	Дата окончания документа
N_LINE_NO	NUMBER	Номер строки по порядку
N_GOOD_TYPE_ID	NUMBER	Тип позиции номенклатуры
N_SUBSCR_PERMISSION_ID	NUMBER	Права подключения
N_SERVICE_TYPE_ID	NUMBER	Тип услуги
N_UNSUBSCR_PERMISSION_ID	NUMBER	Право отключения
N_SERV_END_CHARGE_TYPE_ID	NUMBER	Тип начисления при закрытии акта начислений
N_PROVIDING_TYPE_ID	NUMBER	Тип оказания услуги (Периодическая/Разовая)
N_PAR_SUBSCRIPTION_ID	NUMBER	Родительская строка
N_CHARGE_LOG_ID	NUMBER	Действующий акт начислений
N_PREV_SUBSCRIPTION_ID	NUMBER	Предыдущая подписка
N_CONTRACT_COMMITMENT_ID	NUMBER	Контрактное обязательство
N_CL_CREATING_STATE_ID	NUMBER	Состояние выставления актов начислений
N_SERVICE_STATE_ID	NUMBER
D_LOG_LAST_MOD	DATE
N_LOG_SESSION_ID	NUMBER
D_INVOICE_END	DATE	Дата окончания инвойса
N_INVOICE_ID	NUMBER	Действующий инвойс

SS_V_CDR_DETAILS

Детализация CDR

Field	Type	Description
N_CDR_DETAIL_ID	NUMBER	Идентификатор записи
N_CDR_ID	NUMBER	CDR
N_RATING_TYPE_ID	NUMBER	Тип тарификации
VC_RATING_TYPE	VARCHAR2	Тип тарификации
N_LINE_NO	NUMBER	Номер строки
N_RATING_STATE_ID	NUMBER	Состояние тарификации
VC_ACC_STATE	VARCHAR2	Состояние тарификации
N_FAIL_REASON_ID	NUMBER	Причина неуспешной тарификации
VC_FAIL_REASON	VARCHAR2	Причина неуспешной тарификации
N_PROVIDER_ID	NUMBER	Поставщик
VC_PROVIDER	VARCHAR2	Поставщик
N_FIRM_ID	NUMBER	Фирма, для которой тарифицирована
N_ADDRESS_A_ID	NUMBER	Идентификатор адреса станции A
VC_ADDRESS_A	VARCHAR2
N_ADDRESS_B_ID	NUMBER	Идентификатор адреса станции B
VC_ADDRESS_B	VARCHAR2
N_OBJECT_ID	NUMBER	Абонентское оборудование
VC_OBJECT	VARCHAR2	Абонентское оборудование
N_CUSTOMER_ID	NUMBER	Абонент
VC_CUSTOMER	VARCHAR2	Абонент
N_ACCOUNT_ID	NUMBER	Лицевой счет абонента
VC_ACCOUNT	VARCHAR2	Наименование лицевого счета
VC_ACCOUNT_CODE	VARCHAR2	Код лицевого счета
N_SERVICE_ID	NUMBER	Услуга
VC_SERVICE	VARCHAR2	Услуга
N_CHARGE_LOG_ID	NUMBER	Акт начислений
N_CONTRACT_ID	NUMBER	Идентификатор договора
VC_CONTRACT	VARCHAR2	Договор
VC_CHARGE_LOG	VARCHAR2	Наименование акта начислений
VC_CHARGE_LOG_CODE	VARCHAR2	Код акта начислений
N_GM_LINE_ID	NUMBER	Строка акта начислений
N_CURRENCY_ID	NUMBER	Валюта
VC_CURRENCY	VARCHAR2	Валюта
N_AMOUNT	NUMBER	Стоимость
N_AMOUNT_TAX	NUMBER	Сумма налога
N_AMOUNT_WO_TAX	NUMBER	Сумма без налогов
N_QUANT	NUMBER	Количество
N_QUANT_BASE	NUMBER	Количество в секундах
N_QUANT_MINUTES	NUMBER	Количество в минутах
N_UNIT_ID	NUMBER	Единица измерения
VC_VISUAL_UNIT	VARCHAR2	Единица измерения
N_TAX_RATE_ID	NUMBER	Ставка налога
VC_TAX_RATE	VARCHAR2	Ставка налога
D_OPER	DATE	Дата операции
T_TEL_CODE_A_IDS	NUMBER_ARRAY_SHORT	Идентификаторы кодов А
VC_TEL_CODES_A	VARCHAR2	Телефонные коды А
T_TEL_CODE_B_IDS	NUMBER_ARRAY_SHORT	Идентификаторы кодов Б
VC_TEL_CODES_B	VARCHAR2	Телефонные коды Б
VC_VISUAL_ADDRESS_A	VARCHAR2
VC_VISUAL_ADDRESS_B	VARCHAR2
N_PRICE_ORDER_ID	NUMBER
VC_PRICE_ORDER	VARCHAR2
VC_PRICE_ORDER_CODE	VARCHAR2
VC_EXT_UNIQ_ID	VARCHAR2
VC_DIRECTION	VARCHAR2	Тип вызова
N_PRICE	NUMBER	Цена

AP_V_USER_OFFICE_INVOICES

Выставленные фактуры

RPT_V_USER_INVOICES

Отчёт по движению товаров и услуг

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	Базовый договор
N_DISCOUNT_REF_ID	NUMBER

SD_V_CHARGE_LOGS_C

Состав акта начислений

Field	Type	Description
N_LINE_ID	NUMBER	Идентификатор записи
N_DOC_ID	NUMBER	Акт начислений
N_SUBJ_GOOD_ID	NUMBER	Подписка на услугу
N_PAR_LINE_ID	NUMBER	Родительская строка
N_MOVE_TYPE_ID	NUMBER	Тип движения
VC_MOVE_TYPE_NAME	VARCHAR2	Наименование типа движения
N_GOOD_ID	NUMBER	Товар или услуга
N_SERVICE_ID	NUMBER
VC_GOOD_NAME	VARCHAR2	Наименование товара или услуги
N_BASE_GOOD_ID	NUMBER	Базовый товар или услуга
VC_BASE_GOOD_NAME	VARCHAR2	Наименование базового товара или услуги
N_UNIT_ID	NUMBER	Единица измерения
VC_UNIT_NAME	VARCHAR2	Наименование единицы измерения
N_QUANT	NUMBER	Количество
N_UNIT_BASE_ID	NUMBER	Базовая единица измерения
VC_UNIT_BASE_NAME	VARCHAR2	Наименование базовой единицы измерения
N_QUANT_BASE	NUMBER	Количество в базовых единицах измерения
N_TAX_RATE_ID	NUMBER	Ставка налога
VC_TAX_RATE_NAME	VARCHAR2	Значение ставки налога
N_OBJECT_ID	NUMBER	Объект учета по движению
VC_OBJECT_CODE	VARCHAR2	Краткое наименование объекта учета по движению
N_CURRENCY_ID	NUMBER	Валюта
VC_CURRENCY_NAME	VARCHAR2	Наименование валюты
N_ADDRESS_ID	NUMBER	Адрес
VC_ADDRESS_CODE	VARCHAR2	Краткое наименование адреса
N_PRICE	NUMBER	Цена с учетом налогов
N_PRICE_WO_TAX	NUMBER	Цена без учета налогов
N_BASE_SUM	NUMBER	Сумма без скидки с учетом налогов
N_BASE_SUM_WO_TAX	NUMBER	Сумма без скидки и без учета налогов
N_DISCOUNT_CERT_LINE_ID	NUMBER	Строка акта предоставления скидки
N_SUM	NUMBER	Сумма
N_SUM_TAX	NUMBER	Сумма налога
N_SUM_WO_TAX	NUMBER	Сумма без налогов
N_LINE_NO	NUMBER	Номер по порядку
D_OPER	DATE	Дата операции по строке
D_BEGIN	DATE	Дата начала
D_END	DATE	Дата окончания
VC_REM	VARCHAR2	Комментарий
N_PRICE_LINE_ID	NUMBER	Строка приказа по ценам
N_PRICE_ORDER_DOC_ID	NUMBER	Приказ по ценам
VC_PRICE_ORDER_CODE	VARCHAR2	Краткое наименование приказа по ценам
N_PROVISION_RULE_ID	NUMBER	Правило оказания услуги
N_PROVIDER_ID	NUMBER	Поставщик

SD_V_CHARGE_LOGS_C_SUMS

Итоги состава акта начислений по услуге

Field	Type	Description
N_DOC_ID	NUMBER	Акт начислений
N_GOOD_ID	NUMBER	Услуга
VC_GOOD_NAME	VARCHAR2	Наименование услуги
N_MOVE_TYPE_ID	NUMBER	Тип движения
VC_MOVE_TYPE	VARCHAR2	Наименование типа движения
N_UNIT_ID	NUMBER	Единица измерения
VC_UNIT	VARCHAR2	Наименование единицы измерения
N_QUANT_SUM	NUMBER	Суммарное количество
N_UNIT_BASE_ID	NUMBER	Базовая единица измерения
VC_UNIT_BASE	VARCHAR2	Наименование базовой единица измерения
N_QUANT_BASE_SUM	NUMBER	Суммарное количество в базовых единицах измерения
N_OBJECT_ID	NUMBER	Оборудование
VC_OBJECT_CODE	VARCHAR2	Код оборудования
N_CURRENCY_ID	NUMBER	Валюта
VC_CURRENCY	VARCHAR2	Наименование валюты
N_BASE_SUM	NUMBER	Сумма без скидки
N_BASE_SUM_WO_TAX	NUMBER	Сумма без скидки и налога
N_SUM	NUMBER	Сумма
N_SUM_TAX	NUMBER	Сумма налога
N_SUM_WO_TAX	NUMBER	Сумма без налогов
D_BEGIN	DATE	Дата начала
D_END	DATE	Дата окончания
N_DISCOUNT_CERT_ID	NUMBER	АПС основной услуги
VC_DISCOUNT_CERT_NAME	VARCHAR2	Наименование АПС для основной услуги

SD_V_CHARGE_LOGS_JR

Журнал актов начислений

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_SUM	NUMBER	Сумма
N_WRITEOFF_SUM	NUMBER	Сумма за начисленные услуги
N_ADD_SERVS_SUM	NUMBER
N_CURRENCY_ID	NUMBER	Валюта
VC_CURRENCY	VARCHAR2	Наименование валюты
N_FIRM_ID	NUMBER	Фирма-владелец
VC_FIRM	VARCHAR2	Наименование фирмы-владельца
VC_REM	VARCHAR2	Примечание
T_TAGS	TAGS	Теги
VC_TAGS	VARCHAR2	Теги
C_FL_ARCHIVED	CHAR	Флаг архивного документа

SD_V_CHARGE_LOGS_T

Заголовок акта начислений

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	Теги
C_FL_ARCHIVED	CHAR	Флаг архивного документа
D_END_INITIAL	DATE	Расчетная дата окончания
N_CLOSE_REASON_ID	NUMBER	Причина закрытия
VC_CLOSE_REASON	VARCHAR2	Наименование причины закрытия
N_CANCEL_REASON_ID	NUMBER	Причина аннулирования
VC_CANCEL_REASON	VARCHAR2	Наименование причины аннулирования

Argument	Direction	Reference type	Type	Default value	Description
num_N_GOOD_ID	IN	RG_GOOD_MOVES_T.N_SERVICE_ID%TYPE	NUMBER		Потоковая услуга
num_N_CHARGE_LOG_ID	IN	RG_GOOD_MOVES_T.N_CHARGE_LOG_ID%TYPE	NUMBER		Акт начислений, в рамках которого оказывается услуга
num_N_TIME_INTERVAL_ID	IN	SD_TIME_INTERVALS_C.N_TIME_INTERVAL_ID%TYPE	NUMBER	NULL	Идентификатор временного интервала
RETURN SD_PRICE_ORDERS_C.N_PRICE_LINE_ID%TYPE					Строка ПЦ, действующая по потоковой услуге на данный момент

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SD_GOOD_MOVES_T.N_DOC_ID%TYPE	NUMBER		Charge log
RETURN CONST.BOOL					Boolean result

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SD_INVOICES_T.N_DOC_ID%TYPE	NUMBER		Charge log
dt_D_CLOSABLE	IN	SD_INVOICES_T.D_CLOSABLE%TYPE	DATE	UTILS2_PKG_S.GET_SYSDATE	Date that charge log becames closable since

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID_Old	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Old document
num_N_DOC_ID_New	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		New document (copy)
b_Storno	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Storno?

Argument	Direction	Reference type	Type	Default value
dt_D_BEGIN	IN	SD_GOOD_MOVES.D_BEG%TYPE	DATE
dt_D_END	IN	SD_GOOD_MOVES.D_END%TYPE	DATE
num_N_SERVICE_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER	NULL
num_N_DOC_STATE_ID	IN	SD_DOCUMENTS.N_DOC_STATE_ID%TYPE	NUMBER	NULL
b_SplitContracts	IN	CONST.BOOL	NUMBER
b_SplitAccounts	IN	CONST.BOOL	NUMBER
b_SplitObjects	IN	CONST.BOOL	NUMBER
b_OnlyNegativeBal	IN	CONST.BOOL	NUMBER
RETURN RENDERED_SERVICES_TBL
PIPELINED

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SD_VOICES_T.N_DOC_ID%TYPE	NUMBER		Charge log
RETURN SD_INVOICES_T.D_BILLING_DATE%TYPE					Billing date

Argument	Direction	Reference type	Type	Default value	Description
num_N_SCN	IN	SP_VERSIONS.N_SCN%TYPE	NUMBER		Basic version
b_IncludeObjValues	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Update versions of object custom field values? {} CONST.b_TRUE — update versions of object values {} CONST.b_FALSE — do not update versions of object values

Argument	Direction	Reference type	Type	Default value	Description
vch_String	IN	VARCHAR2	VARCHAR2		String
RETURN VARCHAR2					string with escaped symbols

Field	Type	Description
N_COMPANY_ID	NUMBER	Юридическое лицо
N_OPF_ID	NUMBER	ОПФ
VC_OPF_NAME	VARCHAR2	Наименование ОПФ
VC_CODE	VARCHAR2	Краткое наименование
VC_NAME	VARCHAR2	Полное наименование
VC_INN	VARCHAR2	ИНН
VC_KPP	VARCHAR2

Field	Type	Description
N_PERSON_ID	NUMBER	Физического лицо
N_OPF_ID	NUMBER	ОПФ
VC_OPF_NAME	VARCHAR2	Наименование ОПФ
VC_FIRST_NAME	VARCHAR2	Имя
VC_SURNAME	VARCHAR2	Фамилия
VC_SECOND_NAME	VARCHAR2	Отчество
VC_NAME	VARCHAR2	Полное имя
N_SEX_ID	NUMBER	Пол
D_BIRTH	DATE	Дата рождения
VC_INN	VARCHAR2
VC_KPP	VARCHAR2

Oracle API diff 5.1.2 and 6.0

Renamed objects:

Objects

Packages

PROCEDURE UNLOAD_DOCUMENTS

PROCEDURE AV_SERVICE_CHANGE_STATE

PROCEDURE CREATE_PREPAYMENT_BILL

FUNCTION CHANGE_TARIFF

PROCEDURE DO_TARIFF_CHANGE

PROCEDURE ACCESS_SERV_CHG_STATE

FUNCTION ADD_TARIFF

PROCEDURE ADD_TARIFF

PROCEDURE PROCESS_ADD_GOODS

PROCEDURE ADD_GOOD_TO_INVOICE

PROCEDURE REMOVE_GOOD_FROM_INVOICE

PROCEDURE PUT_REDIRECT_PHONE_NUMBER

PROCEDURE CREATE_PREPAYMENT_INVOICE

PROCEDURE CLOSE_REDIRECT_PHONE_NUMBER

PROCEDURE REMOVE_GOOD_FROM_CHARGE_LOG

PROCEDURE ADD_GOOD_TO_CHARGE_LOG

PROCEDURE LOAD_ACTUAL_INVOICES_FROM_CSV

PROCEDURE CREATE_INVOICE_BY_SUBJ_GOOD

PROCEDURE LOAD_CHARGE_LOGS_FROM_CSV

PROCEDURE CREATE_CHARGE_LOG_BY_SUBJ_GOOD

PROCEDURE PUT_BILL_ADDITIONAL_VALUE

PROCEDURE CREATE_PAYMENT

PROCEDURE EX_PAYMENTS_CHARGE

PROCEDURE PUT_INVOICE_ADDITIONAL_VALUE

TYPE LIST_ACCOUNT_PAYMENTS_TBL PL/SQL TABLE

FUNCTION GET_ACCOUNT_ID_FOR_CHARGE

PROCEDURE GET_ACCOUNT_INFO

FUNCTION GET_LIST_ACCOUNT_PAYMENTS_P

PROCEDURE RECREATE_FOR_CONTEXT

PROCEDURE RECREATE_FOR_TEMPLATE

PROCEDURE RECREATE_FOR_TEMPLATE

FUNCTION SYNC_ALL_PROFILES

FUNCTION TRY_SYNC_ALL_PROFILES

PROCEDURE CHARGE_ADJUSTMENT

PROCEDURE CANCEL_NON_PAY_SUSPENSION

PROCEDURE RAISE_DOC_EVENTS

PROCEDURE CONNECT_ACCESS_SERVS

PROCEDURE SD_CHARGE_LOGS_C_PUT

PROCEDURE ACTUALIZE_CHARGE_LOG

PROCEDURE COMPRESS_CHARGE_LOG

PROCEDURE MAKE_CHARGE_LOG_CLOSABLE

PROCEDURE SET_CHARGE_LOG_CLOSE_REASON

PROCEDURE CORRECT_CHARGE_LOG_TOTAL_SUMS

PROCEDURE SD_CHARGE_LOGS_C_DEL

PROCEDURE ACCESS_SERV_CHG_STATE

PROCEDURE CHANGE_CHARGE_LOG_PERIOD

PROCEDURE DISCONNECT_ACCESS_SERVS

PROCEDURE SD_CHARGE_LOGS_T_PUT

PROCEDURE CANCEL_CHARGE_LOG

PROCEDURE EXECUTE_CHARGE_LOG

TYPE DEFER_PARAMS PL/SQL RECORD

TYPE GOOD_BURST_VALUE_TYPE PL/SQL TABLE

FUNCTION GET_CHARGE_LOG_BURST_VALUES

FUNCTION GET_CHARGE_LOG_BY_CONTRACT

FUNCTION GET_NONPAY_BLOCK_CHARGE_LOG

FUNCTION CALC_PRICE_FOR_CHARGE_LOG_GOOD

FUNCTION GET_DEFER_PARAMS

FUNCTION GET_PRICE_BY_RGMT

FUNCTION GET_PRICE_DOC

FUNCTION GET_CHARGE_LOG_LINE_PRICE_GOOD

FUNCTION GET_APPLIED_PROVISION_RULE

FUNCTION GET_BILLING_DATE

FUNCTION GET_PRICE_LINE_AND_ACCOUNT

FUNCTION GET_CHARGE_LOG_BEGIN_DATE

FUNCTION GET_CHARGE_LOG_LINE_BY_OBJECT

FUNCTION GET_CLOSE_REASON_ID

FUNCTION GET_CL_PAR_LINE_FOR_GOOD

FUNCTION GET_DOC_FOR_CURRENT_GOOD

FUNCTION GET_PREPARED_CHARGE_LOG

FUNCTION IS_NONPAY_SUSPENSION_CL

FUNCTION GET_BLOCKING_GP_PRICE

FUNCTION GET_CHARGE_LOG_ID_BY_SUBJ_GOOD

FUNCTION GET_CHARGE_LOG_LINE_FOR_GOOD

FUNCTION GET_LAST_TARIFF

PROCEDURE SD_CONTRACTS_DISSOLVE

TYPE RENDERED_SERVICES_TBL PL/SQL TABLE