Quais scripts/procedures são utilizados pelo Pacote TaxPlus e BankPlus?

Dúvida

Quais scripts/procedures são utilizados pelo Pacote TaxPlus e BankPlus?

Procedimento

♦ SQL Server

» On Premise

○ SBO_SP_TransactionNotification (clique aqui para download)

--Start TaxPlus

DECLARE @currDbNameForTaxOne nvarchar(128)

SELECT @currDbNameForTaxOne = DB_NAME()

EXEC [SBO_TaxOne]..[TransNotificationValidate]

@currDbNameForTaxOne, @object_type, @list_of_cols_val_tab_del, @error OUTPUT, @error_message OUTPUT

--End TaxPlus

--Start IntegrationBank

DECLARE @companyDbIntBank nvarchar(128)

SELECT @companyDbIntBank = (SELECT DB_NAME())

EXEC [IntegrationBank]..[IV_IB_TransNotificationValidateIntBank]

'IntegrationBank', @companyDbIntBank, 'IV_IB_Setting', 'IV_IB_BillOfExchange', 'IV_IB_BillOfExchangeInstallment',

'IV_IB_CompanyLocal', @object_type, @transaction_type, @list_of_cols_val_tab_del, @error OUTPUT, @error_message OUTPUT

--End IntegrationBank

○ SBO_SP_PostTransactionNotice (clique aqui para download)

--Start TaxPlus NFe

DECLARE @dbNameInv nvarchar(128)

SET @dbNameInv = db_Name()

EXECUTE [DBInvOne]..[TransNoticeNfe]

@dbNameInv, @object_type, @transaction_type, @num_of_cols_in_key,

@list_of_key_cols_tab_del, @list_of_cols_val_tab_del

--End TaxPlus NFe

--Start TaxPlus DFe

EXECUTE [DBInvOne]..[UpdateStatusDocReceived]

@dbNameInv, @object_type, @transaction_type, @num_of_cols_in_key,

@list_of_key_cols_tab_del, @list_of_cols_val_tab_del

--End TaxPlus DFe

--Start TaxPlus NFSe

DECLARE @dbNameTaxInv nvarchar(128)

SET @dbNameTaxInv = db_Name()

EXECUTE [SBO_TaxOne]..[TransNoticeNfse]

@dbNameTaxInv, @object_type, @transaction_type, @num_of_cols_in_key,

@list_of_key_cols_tab_del, @list_of_cols_val_tab_del

--Start TaxPlus NFSe

» CCC

○ SBO_SP_TransactionNotification (clique aqui para download)

--Start TaxPlus

DECLARE @currDbNameForTaxOne nvarchar(128)

SELECT @currDbNameForTaxOne = DB_NAME()

EXEC [TransNotificationValidate]

@currDbNameForTaxOne, @object_type, @list_of_cols_val_tab_del, @error OUTPUT, @error_message OUTPUT

--End TaxPlus

--Start IntegrationBank

DECLARE @companyDbIntBank nvarchar(128)

SELECT @companyDbIntBank = (SELECT DB_NAME())

EXEC [IV_IB_TransNotificationValidateIntBank]

@companyDbIntBank, @companyDbIntBank, 'IV_IB_Setting', 'IV_IB_BillOfExchange', 'IV_IB_BillOfExchangeInstallment',

'IV_IB_CompanyLocal', @object_type, @transaction_type, @list_of_cols_val_tab_del, @error OUTPUT, @error_message OUTPUT

--End IntegrationBank

○ SBO_SP_PostTransactionNotice (clique aqui para download)

--Start TaxPlus NFe

DECLARE @dbNameInv nvarchar(128)

SET @dbNameInv = db_Name()

EXECUTE [TransNoticeNfe]

@dbNameInv, @object_type, @transaction_type, @num_of_cols_in_key,

@list_of_key_cols_tab_del, @list_of_cols_val_tab_del

--End TaxPlus NFe

--Start TaxPlus DFe

EXECUTE [UpdateStatusDocReceived]

@dbNameInv, @object_type, @transaction_type, @num_of_cols_in_key,

@list_of_key_cols_tab_del, @list_of_cols_val_tab_del

--End TaxPlus DFe

--Start TaxPlus NFSe

DECLARE @dbNameTaxInv nvarchar(128)

SET @dbNameTaxInv = db_Name()

EXECUTE [TransNoticeNfse]

@dbNameTaxInv, @object_type, @transaction_type, @num_of_cols_in_key,

@list_of_key_cols_tab_del, @list_of_cols_val_tab_del

--Start TaxPlus NFSe

♦ HANA

» On Premise

○ SBO_SP_TransactionNotification (clique aqui para download)

Necessário declarar as variáveis currDbNameForTaxOne e companyDbIntBank antes do begin:

currDbNameForTaxOne nvarchar(128);

companyDbIntBank nvarchar(128);

--Start TaxPlus

SELECT CURRENT_SCHEMA INTO currDbNameForTaxOne FROM DUMMY;

IF (IFNULL(error,0)=0)

THEN

Call "SBO_TaxOne"."TransNotificationValidate"

(currDbNameForTaxOne, object_type, list_of_cols_val_tab_del, error, error_message);

END IF;

--End TaxPlus

--Start IntegrationBank

SELECT CURRENT_SCHEMA INTO companyDbIntBank FROM DUMMY;

Call "IntegrationBank"."TransNotificationValidateIntBank"

('IntegrationBank', companyDbIntBank, 'IV_IB_Setting', 'IV_IB_BillOfExchange', 'IV_IB_BillOfExchangeInstallment',

'IV_IB_CompanyLocal', object_type, transaction_type, list_of_cols_val_tab_del, error, error_message);

--End IntegrationBank

○ SBO_SP_PostTransactionNotice (clique aqui para download)

Necessário declarar a variável db_invname antes do begin:

db_invname nvarchar(128);

--Start TaxPlus NFe

SELECT CURRENT_SCHEMA INTO db_invname FROM DUMMY;

Call "DBInvOne"."TransNoticeNfe"

(:db_invname, :object_type, :transaction_type, :num_of_cols_in_key, :list_of_key_cols_tab_del, :list_of_cols_val_tab_del);

--End TaxPlus NFe

--Start TaxPlus DFe

SELECT CURRENT_SCHEMA INTO db_invname FROM DUMMY;

Call "DBInvOne"."UpdateStatusDocReceived"

(:db_invname, :object_type, :transaction_type, :num_of_cols_in_key, :list_of_key_cols_tab_del, :list_of_cols_val_tab_del);

--End TaxPlus DFe

--Start TaxPlus NFSe

SELECT CURRENT_SCHEMA INTO db_invname FROM DUMMY;

Call "SBO_TaxOne"."TransNoticeNfse"

(:db_invname, :object_type, :transaction_type, :num_of_cols_in_key, :list_of_key_cols_tab_del, :list_of_cols_val_tab_del);

--Start TaxPlus NFSe

» CCC

○ SBO_SP_TransactionNotification (clique aqui para download)

Necessário declarar as variáveis currDbNameForTaxOne e companyDbIntBank antes do begin:

currDbNameForTaxOne nvarchar(128);

companyDbIntBank nvarchar(128);

--Start TaxPlus

SELECT CURRENT_SCHEMA INTO currDbNameForTaxOne FROM DUMMY;

IF (IFNULL(error,0)=0)

THEN

Call "TransNotificationValidate"

(currDbNameForTaxOne, object_type, list_of_cols_val_tab_del, error, error_message);

END IF;

--End TaxPlus

--Start IntegrationBank

SELECT CURRENT_SCHEMA INTO companyDbIntBank FROM DUMMY;

Call "IV_IB_TransNotificationValidateIntBank"

(companyDbIntBank, companyDbIntBank, 'IV_IB_Setting', 'IV_IB_BillOfExchange', 'IV_IB_BillOfExchangeInstallment',

'IV_IB_CompanyLocal', object_type, transaction_type, list_of_cols_val_tab_del, error, error_message);

--End IntegrationBank

○ SBO_SP_PostTransactionNotice (clique aqui para download)

Necessário declarar a variável db_invname antes do begin:

db_invname nvarchar(128);

--Start TaxPlus NFe

SELECT CURRENT_SCHEMA INTO db_invname FROM DUMMY;

Call "TransNoticeNfe"

(:db_invname, :object_type, :transaction_type, :num_of_cols_in_key, :list_of_key_cols_tab_del, :list_of_cols_val_tab_del);

--End TaxPlus NFe

--Start TaxPlus DFe

SELECT CURRENT_SCHEMA INTO db_invname FROM DUMMY;

Call "UpdateStatusDocReceived"

(:db_invname, :object_type, :transaction_type, :num_of_cols_in_key, :list_of_key_cols_tab_del, :list_of_cols_val_tab_del);

--End TaxPlus DFe

--Start TaxPlus NFSe

SELECT CURRENT_SCHEMA INTO db_invname FROM DUMMY;

Call "TransNoticeNfse"

(:db_invname, :object_type, :transaction_type, :num_of_cols_in_key, :list_of_key_cols_tab_del, :list_of_cols_val_tab_del);

--Start TaxPlus NFSe

Referências

Sem referência

O que você precisa resolver hoje?