|
|
| Linha 29: |
Linha 29: |
| | font-family:"Cambria","serif";color:#365F91'> </span></b></p> | | font-family:"Cambria","serif";color:#365F91'> </span></b></p> |
| | | | |
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 863
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 864
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 589
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 647
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 651
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 675
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 693
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 697
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 675
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 675
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 693
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 697
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 693
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 697
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 589
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 241
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 242
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 241
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 242
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 241
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 242
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
| − | <h1><a name="_Toc387158726">Planilha Pactual 3040</a></h1> | + | <h1>Planilha Pactual 3040</h1> |
| | | | |
| | <p class=MsoNormal> </p> | | <p class=MsoNormal> </p> |
| Linha 71: |
Linha 71: |
| | font-family:"Cambria","serif";color:#365F91'> </span></b></p> | | font-family:"Cambria","serif";color:#365F91'> </span></b></p> |
| | | | |
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 863
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 864
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 589
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 647
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 651
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 675
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 693
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 697
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 675
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 675
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 693
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 697
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 693
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 697
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 589
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 610
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 241
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 242
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 241
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 242
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 241
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 242
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
Deprecated: assert(): Calling assert() with a string argument is deprecated in C:\www\cfi\wiki\includes\diff\DairikiDiff.php on line 956
| − | <h1><a name="_Toc387158727">Planilha Pactual 3050</a></h1> | + | <h1>Planilha Pactual 3050</h1> |
| | | | |
| | <p class=MsoNormal> </p> | | <p class=MsoNormal> </p> |
Edição das 16h57min de 1 de junho de 2015
Arquivo Texto Layout CFI
Layout se encontra no arquivo "Importação NCR - Layout
CFI.xls"
Arquivo texto Layout CSU
Layout se encontra no arquivo "Importação NCR - Layout
CSU.pdf"
Planilha Pactual 3040
Exemplo da Planilha no arquivo "Importação NCR -
Exemplo Layout Pactual 3040.xlsx"
Para a importação dessa planilha é fundamental seguir
exatamente o nome das colunas, manter esses nomes na linha 3 e seguir a mesma
ordem das abas. A ordem das colunas não importa, podem ser criadas outras
colunas com outras informações que isso também não afetará a importação.
Para a Importação dessa planilha temos na 1ª aba os
contratos com todas as informações necessárias para a geração do 3040. As
colunas cujo nome são anexos se referem aos anexos da própria norma do Banco
Central. Os contratos vem um por linha com os vencimentos nas colunas.
Na 2ª aba temos as informações Adicionais do 3040 (anexo
26), uma informação por linha. A chave usada é o contrato.
Na 3ª aba estão as garantias, também uma por linha e usando
o contrato como chave.
Na ultima aba temos os contratos offshore que vão sempre na
tag agregada por terem característica especial 32. Apenas nessa ultima aba a linha
com os nomes das colunas estão na primeira linha e não na 3ª. Nessa aba os
contratos são repetidos linha a linha para cada parcela. O vencimento de cada
parcela é calculado com base na informação dos dias de atraso. Se os dias de
atraso estiverem negativos significa que o contrato não está em atraso e sim a
vencer. Esses contrato não possuem InfoAd nem garantias. Para saber se o
contrato está baixado para prejuízo verificamos se a classOp = HH. Informação
de localização é fixo igual a RJ. O prazo em dobro também é fixo igual a 'Não'.
Planilha Pactual 3050
Exemplo da Planilha no arquivo "Importação NCR -
Exemplo Layout Pactual 3050.xlsx"
Para a importação dessa planilha é fundamental seguir
exatamente o nome das colunas, manter esses nomes na linha 1 e seguir a mesma
ordem das abas. A ordem das colunas não importa, podem ser criadas outras
colunas com outras informações que isso também não afetará a importação.
Para a Importação dessa planilha temos nas 3 primeiras abas
os contratos com as informações mínimas para o 3050 e nas 5 abas finais temos
as informações de quais contratos tiveram concessão. A chave usada para saber
quais contratos tiveram concessão é o próprio número do contrato.
Os contratos vem repetidos linha a linha para cada parcela.
Apenas no ultimo dia do mês é que o sistema leva em consideração o vencimento
de cada parcela, nos outros dias do mês o sistema apenas soma o valor das
parcelas.
O De-Para das modalidade enviadas na planilha é a seguinte:
|
MODALIDADE_SCO
|
MODALIDADE_3050
|
Tipo de pessoa
|
|
CCB
|
Capital de giro com prazo
até 365 dias
|
Pessoa Juridica
|
|
CCB
|
Capital de giro com prazo
superior a 365 dias
|
Pessoa Juridica
|
|
CCB
|
Crédito pessoal
não-consignado
|
Pessoa Fisica
|
|
CCB - Compror
|
Compror
|
|
|
CCB - Conta Garantida
|
Cheque especial
|
Pessoa Juridica
|
|
CCB - Conta
Garantida
|
Conta garantida
|
Pessoa Fisica
|
|
CCE
|
Financiamento a exportações
|
|
|
COMPROR
|
Compror
|
|
|
Conta Garantida
|
Cheque especial
|
Pessoa Fisica
|
|
Conta Garantida
|
Conta garantida
|
Pessoa Juridica
|
|
CPR
|
Crédito rural
|
|
|
Mutuo
|
Capital de giro com prazo
até 365 dias
|
Pessoa Juridica
|
|
Mutuo
|
Capital de giro com prazo
superior a 365 dias
|
Pessoa Juridica
|
|
Mutuo
|
Crédito pessoal
não-consignado
|
Pessoa Fisica
|
|
NCE
|
Financiamento a exportações
|
|
|
Outros Créditos - Cessão
com Coobrigação
|
Outros créditos livres
|
|
|
Outros Créditos - Cessão
sem Coobrigação
|
Outros créditos livres
|
|
|
Promessa de Cessão - Com
Coobrigação
|
Outros créditos livres
|
|
|
Promessa de Cessão - Sem
Coobrigação
|
Outros créditos livres
|
|
De-Para dos indexadores:
|
INDEXADOR
|
INDEXADOR_SCO
|
|
PRE
|
PRE
|
|
TAXA FLUTUANTE
|
CDIE
|
|
OUTROS INDEXADORES
|
SELIC
|
|
OUTROS INDEXADORES
|
IGP
|
|
OUTROS INDEXADORES
|
IGPM
|
|
OUTROS INDEXADORES
|
INPC
|
|
OUTROS INDEXADORES
|
IPCU
|
|
OUTROS INDEXADORES
|
NIGPM
|
|
OUTROS INDEXADORES
|
INCC
|
|
OUTROS INDEXADORES
|
NIPCA
|
|
OUTROS INDEXADORES
|
NINCC
|
|
MOEDA ESTRANGEIRA
|
PTXV
|
De-Para do Tipo de Pessoa:
|
Setor Econômico BACEN
|
Tipo de Pessoa
|
|
Pessoa Física
|
Pessoa física
|
|
Para todos os outros tipos
|
Pessoa Jurídica
|
|
|
<a name="_Toc387158728">Planilha Maxima 3040</a>
Em desenvolvimento.
<a name="_Toc387158729">Planilha Porto Seguros 3040</a>
Planilha utilizada apenas para atualização de rating.
Utiliza o CNPJ/CPF do cliente e o numero do contrato como
chave para atualizar o rating passado na planilha.
<a name="_Toc387158730">XML 3040 - Formato Bacen</a>
Importação do xml do 3040 no formato do Banco Central.
É importante que todos contratos estejam individualizados,
mesmo os de clientes abaixo do limite. Não podemos ler a tag agregada.
Existem propriedades para setar a Localização e Vinculação a
moeda estrangeira com valores default.
<a name="_Toc387158731">XML 3050 - Formato Bacen</a>
Importação do xml do 3050 no formato do Banco Central.
<a name="_Toc387158732">XML 3046 - Formato Bacen</a>
Em desenvolvimento.
<a name="_Toc387158733">Importação do Cosif - Formato Bacen</a>
<a name="_Toc387158734">Importação do Cosif - Formato XLS</a>
<a name="_Toc387158735">Importação do Plano de Contas</a>
<a name="_Toc387158736">Importação do Arquivo da BM&F</a>
Importação de Arquivo layout BMF para calculo de taxas
máxima e mínima de contratos indexados em taxas flutuantes para o calculo do
3050.
