104 - Caixa Econômica - Cuentas por cobrar - Archivo de envío


Importante

La columna "Opciones de edición" contiene la lista de posibles valores para edición de la expresión de "Contenido". Los campos que no tienen listas de edición, no permiten la edición en el proceso de download de los modelos.

Control
Líneas

Control
Detalles

Control
Secuencial

Situación
Inicial

Situación
Final

Decimal

Información

Contenido

Opciones de edición

0

H


   

   


HEADER DE ARCHIVO

.T.                                                                                                                                    

                                                                                                    

0

T


   

   


TRAILER DE ARCHIVO

.T.                                                                                                                                    

                                                                                                    

1

D

1

   

   


DETALLE SEGMENTO P

.T.                                                                                                                                    

                                                                                                    

1

D

2

   

   


DETALLE SEGMENTO Q

.T.                                                                                                                                    

                                                                                                    

1

D

3

   

   


DETALLE SEGMENTO Q - 36,37,38

.T.                                                                                                                                    

                                                                                                    

1

H


   

   


HEADER DE LOTE

.T.                                                                                                                                    

                                                                                                    

1

T


   

   


TRAILER DE LOTE

.T.                                                                                                                                    

                                                                                                    

0

H


1

3

0

CÓD BANCO

104

                                                                                                    

0

H


4

7

0

CÓD LOTE

0

                                                                                                    

0

H


8

8

0

TIPO REGISTRO

0

                                                                                                    

0

H


9

17

0

USO EXCL CNAB

SPACE(9)                                                                                                                               

                                                                                                    

0

H


18

18

0

TO INSC BENEF

IIF(SM0->M0_TPINSC == 3,"1","2")                                                                                                       

                                                                                                    

0

H


19

32

0

Nº INSC BENEF

PADL(ALLTRIM(SM0->M0_CGC),14,"0")                                                                                                      

                                                                                                    

0

H


33

52

0

USO EXCL CNAB

REPLICATE("0",20)                                                                                                                      

                                                                                                    

0

H


53

57

0

AGENCIA BENEF

PADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")

                                                                                                    

0

H


58

58

0

DV AGEN BENEF

CNABDVAG()                                                                                                                             

                                                                                                    

0

H


59

64

0

CÓD BENEF

PADL(ALLTRIM(SEE->EE_CODEMP),6,"0")

                                                                                                    

0

H


65

71

0

USO EXCL CNAB

REPLICATE("0",7)                                                                                                                       

                                                                                                    

0

H


72

72

0

USO EXCL CNAB

0

                                                                                                    

0

H


73

102

0

NOMBRE BENEF

PADR(ALLTRIM(SM0->M0_NOMECOM),30,"")

                                                                                                    

0

H


103

132

0

NOMBRE BANCO

PADR("CAIXA ECONOMICA FEDERAL",30,"")

                                                                                                    

0

H


133

142

0

USO EXCL CNAB

SPACE(10)                                                                                                                              

                                                                                                    

0

H


143

143

0

CÓD ENVÍO

1

                                                                                                    

0

H


144

151

0

FCH GEN ARCHIVO

GRAVADATA(DDATABASE,.F.,5)                                                                                                             

  • DATE()
  • DDATABASE                                                                              

0

H


152

157

0

HORA GEN ARCHIV

STRTRAN(TIME(),":","")                                                                                                                 

                                                                                                    

0

H


158

163

0

SEC ARCH HEADER

PADL(ALLTRIM(SEE->EE_ULTDSK),6,"0")

                                                                                                    

0

H


164

166

0

Nº VER ARCHIVO

101

                                                                                                    

0

H


167

171

0

DENS GRB ARCHIV

REPLICATE("0",5)                                                                                                                       

                                                                                                    

0

H


172

191

0

USO EXCL CNAB

SPACE(20)                                                                                                                              

                                                                                                    

0

H


192

211

0

SITUACIÓN ARCHIV

REMESSA-TESTE                                                                                                                        

                                                                                                    

0

H


212

215

0

VERSIÓN APLICAC

SPACE(4)                                                                                                                               

                                                                                                    

0

H


216

240

0

USO EXCL CNAB

SPACE(25)                                                                                                                              

                                                                                                    

1

H


1

3

0

CÓD BANCO

104

                                                                                                    

1

H


4

7

0

LOTE SERVICIO

1

                                                                                                    

1

H


8

8

0

TIPO REGISTRO

1

                                                                                                    

1

H


9

9

0

TIPO OPERACIÓN

R                                                                                                                                    

                                                                                                    

1

H


10

11

0

TIPO SERVICIO

1

                                                                                                    

1

H


12

13

0

USO EXCL CNAB

REPLICATE("0",2)                                                                                                                       

                                                                                                    

1

H


14

16

0

Nº VERSIÓN  LOT

60

                                                                                                    

1

H


17

17

0

USO EXCL CNAB

SPACE(1)                                                                                                                               

                                                                                                    

1

H


18

18

0

TIPO BENEF 

IIF(SM0->M0_TPINSC == 3,"1","2")                                                                                                       

                                                                                                    

1

H


19

33

0

Nº INSC BENEF

PADL(ALLTRIM(SM0->M0_CGC),15,"0")                                                                                                      

                                                                                                    

1

H


34

39

0

CÓDIGO BENEF

PADL(ALLTRIM(SEE->EE_CODEMP),6,"0")

                                                                                                    

1

H


40

53

0

USO EXCL CNAB

REPLICATE("0",14)                                                                                                                      

                                                                                                    

1

H


54

58

0

AGENCIA MANTEN

PADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")

                                                                                                    

1

H


59

59

0

DV AGEN MANTEN

CNABDVAG()                                                                                                                             

                                                                                                    

1

H


60

65

0

CÓD CONV BANCO

PADL(ALLTRIM(SEE->EE_CODEMP),6,"0")

                                                                                                    

1

H


66

72

0

CÓD MOD BOLETA

REPLICATE("0",7)                                                                                                                       

                                                                                                    

1

H


73

73

0

USO EXCL CNAB

0

                                                                                                    

1

H


74

103

0

NOMBRE EMPRESA

PADR(ALLTRIM(SM0->M0_NOMECOM),30,"")

                                                                                                    

1

H


104

143

0

MENSAJE 1

SPACE(40)                                                                                                                              

                                                                                                    

1

H


144

183

0

MENSAJE 2

SPACE(40)                                                                                                                              

                                                                                                    

1

H


184

191

0

SEC Nº ENVÍO

PADL(ALLTRIM(SEE->EE_ULTDSK),8,"0")

                                                                                                    

1

H


192

199

0

FCH GRB ARCHIVO

GRAVADATA(DDATABASE,.F.,5)                                                                                                             

  • DATE()
  • DDATABASE

1

H


200

207

0

USO EXCL CNAB

REPLICATE("0",8)                                                                                                                       

                                                                                                    

1

H


208

240

0

USO EXCL CNAB

SPACE(33)                                                                                                                              

                                                                                                    

1

D

1

1

3

0

CÓD BANCO

104

                                                                                                    

1

D

1

4

7

0

LOTE SERVICIO

1

                                                                                                    

1

D

1

8

8

0

TIPO REGISTRO

3

                                                                                                    

1

D

1

9

13

0

N° SEC LOTE

PADL(INCREMENTA() -1,5,"0")                                                                                                            

                                                                                                    

1

D

1

14

14

0

CÓD SEG DETALLE

P                                                                                                                                    

                                                                                                    

1

D

1

15

15

0

USO EXCL CNAB

SPACE(1)                                                                                                                               

                                                                                                    

1

D

1

16

17

0

CÓD MOV ENVÍO

IIF(EMPTY(SE1->E1_OCORREN),"01",SE1->E1_OCORREN)

                                                                                                    

1

D

1

18

22

0

AGENCIA BENEF

PADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")

                                                                                                    

1

D

1

23

23

0

DV AGE BENEF

CNABDVAG()                                                                                                                             

                                                                                                    

1

D

1

24

29

0

CÓD CONV BANCO

PADR(ALLTRIM(SEE->EE_CODEMP),6,"0")

                                                                                                    

1

D

1

30

37

0

USO EXCL CNAB

REPLICATE("0",8)                                                                                                                       

                                                                                                    

1

D

1

38

39

0

USO EXCL CNAB

REPLICATE("0",2)                                                                                                                       

                                                                                                    

1

D

1

40

40

0

MOD CART SINCO

CNABG069()                                                                                                                             

                                                                                                    

1

D

1

41

42

0

MOD CART SIGCB

14

                                                                                                    

1

D

1

43

57

0

ID TÍTULO BANCO

PADL(ALLTRIM(SE1->E1_IDCNAB),15,"0")

                                                                                                    

1

D

1

58

58

0

CÓD CARTERA

SE1->E1_SITUACA                                                                                                                        

                                                                                                    

1

D

1

59

59

0

REG TÍTULO BANC

1

                                                                                                    

1

D

1

60

60

0

TIPO DOCUMENTO

2

                                                                                                    

1

D

1

61

61

0

ID EMISIÓN BOLE

1

                                                                                                    

1

D

1

62

62

0

ID ENTR BOLETA

0

                                                                                                    

1

D

1

63

73

0

N° DOC COBRANZ

PADR(ALLTRIM(SE1->E1_IDCNAB),11,"")

                                                                                                    

1

D

1

74

77

0

USO EXCL CNAB

SPACE(4)                                                                                                                               

                                                                                                    

1

D

1

78

85

0

FCH VENCIMIENTO

GRAVADATA(SE1->E1_VENCREA,.F.,5)

  • E1_VENCREA
  • E1_EMISSAO
  • E1_VENCTO                                                            

1

D

1

86

100

0

VALOR TÍTULO

PADL(SE1->(E1_SALDO+E1_MULTA+E1_JUROS)*100,15,"0")

                                                                                                    

1

D

1

101

105

0

AGENCIA COBRADO

REPLICATE("0",5)                                                                                                                       

                                                                                                    

1

D

1

106

106

0

DV AGEN COBRAD

0

                                                                                                    

1

D

1

107

108

0

CLASE TÍTULO

                                                                                                                                       

                                                                                                    

1

D

1

109

109

0

ACEPTACIÓN TÍTULO

S                                                                                                                                    

                                                                                                    

1

D

1

110

117

0

FCH EMISIÓN TÍTU

GRAVADATA(SE1->E1_EMISSAO,.F.,5)                                                                                                       

  • E1_VENCREA
  • E1_EMISSAO
  • E1_VENCTO

1

D

1

118

118

0

CÓD INTERESES MORA

                                                                                                                                       

                                                                                                    

1

D

1

119

126

0

FCH INTERESESD MORA

                                                                                                                                       

                                                                                                    

1

D

1

127

141

0

INTERESES MORA DÍA

                                                                                                                                       

                                                                                                    

1

D

1

142

142

0

CÓD DESCUENTO 1

                                                                                                                                       

                                                                                                    

1

D

1

143

150

0

FCH DESCUENTO 1

                                                                                                                                       

                                                                                                    

1

D

1

151

165

0

VAL DES CONCEDI

                                                                                                                                       

                                                                                                    

1

D

1

166

180

2

VAL IOF PAGADO

                                                                                                                                       

                                                                                                    

1

D

1

181

195

2

VAL REBAJA

PADL(SE1->(E1_DESCONT)*100,15,"0")                                                                                                     

                                                                                                    

1

D

1

196

220

0

ID TÍTULO EMPRE

PADR(ALLTRIM(SE1->E1_IDCNAB),25,"")

                                                                                                    

1

D

1

221

221

0

CÓD PROTESTO

                                                                                                                                       

                                                                                                    

1

D

1

222

223

0

Nº DÍAS PROTES

                                                                                                                                       

                                                                                                    

1

D

1

224

224

0

CÓD BAJA DEVOL

                                                                                                                                       

                                                                                                    

1

D

1

225

227

0

Nº DÍAS BAJA

                                                                                                                                       

                                                                                                    

1

D

1

228

229

0

CÓD MONEDA

9

                                                                                                    

1

D

1

230

239

0

USO EXCL CNAB

REPLICATE("0",10)                                                                                                                      

                                                                                                    

1

D

1

240

240

0

AUT PAGO PARCI

                                                                                                                                       

                                                                                                    

1

D

2

1

3

0

CÓD BANCO

104

                                                                                                    

1

D

2

4

7

0

LOTE SERVICIO

1

                                                                                                    

1

D

2

8

8

0

TIPO REGISTRO

3

                                                                                                    

1

D

2

9

13

0

SEC REG LOTE

PADL(INCREMENTA() -1,5,"0")                                                                                                            

                                                                                                    

1

D

2

14

14

0

CÓD SEG DETALLE

Q                                                                                                                                    

                                                                                                    

1

D

2

15

15

0

USO EXCL CNAB

SPACE(1)                                                                                                                               

                                                                                                    

1

D

2

16

17

0

CÓD MOVIM ENV

IIF(EMPTY(SE1->E1_OCORREN),"01",SE1->E1_OCORREN)

                                                                                                    

1

D

2

18

18

0

TP INSC PAGADOR

IIF(SA1->A1_TIPO == "J", "2"," 1")                                                                                                     

                                                                                                    

1

D

2

19

33

0

Nº INSC PAGAD

PADL(ALLTRIM(SA1->A1_CGC),15,"0")                                                                                                      

                                                                                                    

1

D

2

34

73

0

NOMBRE PAGADOR

PADR(ALLTRIM(SA1->A1_NOME),40,"")                                                                                                      

  • A1_NREDUZ
  • A1_NOME                                                                            

1

D

2

74

113

0

DIREC PAGADOR

PADR(ALLTRIM(SA1->A1_END),40,"")                                                                                                       

                                                                                                    

1

D

2

114

128

0

BARRIO PAGADOR

PADR(ALLTRIM(SA1->A1_BAIRRO),15,"")

                                                                                                    

1

D

2

129

136

0

CP PAGADOR

PADL(ALLTRIM(SA1->A1_CEP),8,"0")                                                                                                       

                                                                                                    

1

D

2

137

151

0

CIUDAD PAGADOR

PADR(ALLTRIM(SA1->A1_MUN),15,"")                                                                                                       

                                                                                                    

1

D

2

152

153

0

ESTADO/PROV/REG PAGADO

SA1->A1_EST                                                                                                                            

                                                                                                    

1

D

2

154

154

0

TP INSC LIBRAD

IIF(SA1->A1_TIPO == "J", "2"," 1")                                                                                                     

                                                                                                    

1

D

2

155

169

0

Nº INSC LIBRADO

PADL(ALLTRIM(SA1->A1_CGC),15,"0")                                                                                                      

                                                                                                    

1

D

2

170

209

0

NOMBRE LIBADOR

PADR(ALLTRIM(SA1->A1_NOME),40,"")                                                                                                      

                                                                                                    

1

D

2

210

212

0

CÓD BCO COMPENS

REPLICATE("0",3)                                                                                                                       

                                                                                                    

1

D

2

213

232

0

NUESTRO N° BCO

SPACE(20)                                                                                                                              

                                                                                                    

1

D

2

233

240

0

USO EXCL CNAB

SPACE(8)                                                                                                                               

                                                                                                    

1

D

3

1

3

0

CÓD BANCO                               

104

                                                                                                    

1

D

3

4

7

0

LOTE SERVICIO

1

                                                                                                    

1

D

3

8

8

0

TIPO REGISTRO

3

                                                                                                    

1

D

3

9

13

0

SEC REG LOTE

PADL(INCREMENTA() -1,5,"0")                                                                                                            

                                                                                                    

1

D

3

14

14

0

CÓD SEG DETALLE

Q                                                                                                                                    

                                                                                                    

1

D

3

15

15

0

USO EXCL CNAB

SPACE(1)                                                                                                                               

                                                                                                    

1

D

3

16

17

0

CÓD MOVIM ENV

IIF(EMPTY(SE1->E1_OCORREN),"01",SE1->E1_OCORREN)

                                                                                                    

1

D

3

18

18

0

TP INSC PAGADOR

IIF(SA1->A1_PESSOA == "J", "2"," 1")                                                                                                   

                                                                                                    

1

D

3

19

33

0

Nº INSC PAGAD

PADL(ALLTRIM(SA1->A1_CGC),15,"0")                                                                                                      

                                                                                                    

1

D

3

34

73

0

NOMBRE PAGADOR

PADR(ALLTRIM(SA1->A1_NOME),40,"")                                                                                                      

  • A1_NREDUZ
  • A1_NOME

1

D

3

74

113

0

DIREC PAGADOR

PADR(ALLTRIM(SA1->A1_END),40,"")                                                                                                       

                                                                                                    

1

D

3

114

128

0

BARRIO PAGADOR

PADR(ALLTRIM(SA1->A1_BAIRRO),15,"")

                                                                                                    

1

D

3

129

136

0

CP PAGADOR

PADL(ALLTRIM(SA1->A1_CEP),8,"0")                                                                                                       

                                                                                                    

1

D

3

137

151

0

CIUDAD PAGADOR

PADR(ALLTRIM(SA1->A1_MUN),15,"")                                                                                                       

                                                                                                    

1

D

3

152

153

0

ESTADO/PROV/REG PAGADO

SA1->A1_EST                                                                                                                            

                                                                                                    

1

D

3

154

156

0

Nº BCOS PAGADO

                                                                                                                                       

                                                                                                    

1

D

3

157

176

0

NOMBRE BCO PAGADO

                                                                                                                                       

                                                                                                    

1

D

3

177

191

0

CÓD PAGADOR BCO

                                                                                                                                       

                                                                                                    

1

D

3

192

192

0

ID MANTENIMIENTO

                                                                                                                                       

                                                                                                    

1

D

3

193

207

2

VALOR TÍTULO

PADL(SE1->E1_VALOR,15,"0")                                                                                                             

  • E1_SALDO
  • E1_VALOR
  • E1_VLCRUZ

1

D

3

208

209

0

USO EXCL CNAB

SPACE(2)                                                                                                                               

                                                                                                    

1

D

3

210

240

0

USO EXCL CNAB

SPACE(31)                                                                                                                              

                                                                                                    

1

T


1

3

0

CÓD BANCO

104

                                                                                                    

1

T


4

7

0

LOTE SERVICIO

1

                                                                                                    

1

T


8

8

0

TIPO REGISTRO

5

                                                                                                    

1

T


9

17

0

USO EXCL CNAB

SPACE(9)                                                                                                                               

                                                                                                    

1

T


18

23

0

CANT REG LOTE

PADL((NTOTCNAB2*3)+3,6,"0")                                                                                                            

                                                                                                    

1

T


24

29

0

CANT TÍT COBRAN

                                                                                                                                       

                                                                                                    

1

T


30

46

2

VAL TTL TÍT COB

PADL(ALLTRIM(NSOMAVLLOTE),18,"0")                                                                                                      

                                                                                                    

1

T


47

52

0

CANT TÍT GARANTIZ

REPLICATE("0",6)                                                                                                                       

                                                                                                    

1

T


53

69

2

VAL TÍT GARANTIZ

REPLICATE("0",17)                                                                                                                      

                                                                                                    

1

T


70

75

0

CANT TÍT CAR DES

REPLICATE("0",6)                                                                                                                       

                                                                                                    

1

T


76

92

0

CANT TÍT CAR DES

REPLICATE("0",17)                                                                                                                      

                                                                                                    

1

T


93

123

0

USO EXCL CNAB

SPACE(031)                                                                                                                             

                                                                                                    

1

T


124

240

0

USO EXCL CNAB

SPACE(117)                                                                                                                             

                                                                                                    

0

T


1

3

0

CÓD BANCO

104

                                                                                                    

0

T


4

7

0

LOTE SERVICIO

9999

                                                                                                    

0

T


8

8

0

TIPO REGISTRO

9

                                                                                                    

0

T


9

17

0

USO EXCL CNAB

SPACE(9)                                                                                                                               

                                                                                                    

0

T


18

23

0

CANT LOTES ARCHI

1

                                                                                                    

0

T


24

29

0

CANT REG ARCHIVO

PADL((NTOTCNAB2*3)+4,6,"0")                                                                                                            

                                                                                                    

0

T


30

35

0

USO EXCL CNAB

SPACE(6)                                                                                                                               

                                                                                                    

0

T


36

240

0

USO EXCL CNAB

SPACE(205)