Aline.cardoso: Criou página com 'Contábil > Contabilidade > Rotinas > EDI > Exportação/Importação...'

2023-07-18T16:59:12Z

Criou página com 'Contábil > Contabilidade > Rotinas > EDI > Exportação/Importação...'

Página nova

[[Contábil]] > [[CC_Contabilidade|Contabilidade]] > [[CC_Rotinas|Rotinas]] > [[CC_Rotinas_EDI|EDI]] >
[[CC_Rotinas_EDI_Exportação/Importação|Exportação/Importação]] > [[CC_Exp. Histórico Contábil|Exp. Histórico Contábil]]
 
 
 
[[Image: RotinasExportHistContabil.png|550px|centro]]
 

'''Histórico Contábil '''
{| style="border-spacing:0;width:16.51cm;"
|- style="background-color:#000000;border:0.5pt solid #ffffff;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;"
| style="color:#ffffff;" |
|| '''Nome Campo'''
|| '''Atributo'''
|| '''Máscara'''
|| '''Colunas'''
|-
| style="border-top:none;border-bottom:0.5pt solid #000000;border-left:0.5pt solid #000000;border-right:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 001
| style="border-top:none;border-bottom:0.5pt solid #000000;border-left:0.5pt solid #000000;border-right:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Código do histórico
| style="border-top:none;border-bottom:0.5pt solid #000000;border-left:0.5pt solid #000000;border-right:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | N
| style="border-top:none;border-bottom:0.5pt solid #000000;border-left:0.5pt solid #000000;border-right:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 4
| style="border-top:none;border-bottom:0.5pt solid #000000;border-left:0.5pt solid #000000;border-right:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 001 A 005
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 002
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Descrição do Histórico
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | M
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 100
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 006 A 106
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 003
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Tipo 1
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | A
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 107 A 110
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 004
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Posição 1
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | N
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 111 A 114
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 005
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Tipo 2
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | A
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 115 A 118
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 006
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Posição 2
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | N
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 119 A 122
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 007
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Tipo 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | A
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 123 A 126
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 008
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Posição 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | N
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 126 A 130
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 009
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Tipo 4
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | A
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 131 A 134
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 010
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Posição 4
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | N
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 135 A 138
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 011
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Tipo 5
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | A
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 139 A 142
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 012
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Posição 5
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | N
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 143 A 146
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 013
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Situação
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | A
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | U
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 147 A 148
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 014
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Livre Numero 14
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | N
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 149 A 152
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 015
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Livre Numero 15
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | N
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 153 A 156
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 016
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Livre Numero 16
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | N
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 6
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 157 A 163
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 017
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Livre Alfa 17
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | A
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 30
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 164 A 194
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 018
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Livre Data 18
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | D
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | DD/MM/YY
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 195 A 203
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 019
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Livre Data 19
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | D
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | DD/MM/YY
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 206 A 214
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 020
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Sessão
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | N
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 8
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 215 A 223
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 021
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Usuário criação
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | A
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 224 A 225
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 022
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Usuário Modificação
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | A
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 3
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 228 A 231
|-
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 023
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | Data Modificação
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | D
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | DD/MM/YY
| style="border:0.5pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.123cm;padding-right:0.123cm;" | 232 A 240
|-
|}
 

'''INSTRUÇÕES'''

Os campos tipo e posição referem-se a campos de histórico montado, os tipos podem ser:

'''@CL – Para campo livre''' 
'''@VL – Para valor''' 
'''@NM – Para numero''' 
'''@DC – Para data completa''' 
'''@dc – Para data abreviada''' 
'''@MA – Para mês e ano completo''' 
'''@ma – Para mês e ano abreviado''' 
'''@HR – Para hora''' 
'''*DB – Para conta débito''' 
'''*CR – Para conta crédito''' 
'''*MC – Para mês e ano correntes completos''' 
'''*Mc – Para mês e ano correntes abreviados''' 
'''*MA – Para mês e ano anteriores completos''' 
'''*Ma – Para mês e ano anteriores abreviados''' 
'''*DC – Para Documento'''

O campo posição refere-se ao número da posição do primeiro caractere montado, isto está o “@” ou o “*”.

O Campo situação pode ser preenchido com os seguintes tipos: 
'''R''' - Receber, para histórico montado que recebe valor, isto é, pergunta valor (com @) 
'''C''' - Calcular, para histórico que coloca valor (com *) 
'''N''' - Nenhum, para histórico que não possui nenhum campo montado 
*Os campos não utilizam qualquer tipo de caractere separador, porém devem respeitar as colunas iniciais e finais no arquivo; 
*Os campos não utilizam qualquer tipo de caractere separador;
*Os campos numéricos são alinhados à direita e a máscara é preenchida com zeros à esquerda para completar o tamanho;
*Os campos alfas são alinhados à esquerda e a máscara é preenchida com brancos à direita para completar o tamanho;

CC Exp. Histórico Contábil - Histórico de revisão

Aline.cardoso: Criou página com 'Contábil > Contabilidade > Rotinas > EDI > Exportação/Importação...'