033 - Banco Santander

...

- Contas a Receber

...

- Arquivo de Remessa

...

Aviso
title Importante
A coluna "

...

Opções de Edição"

...

contém as lista de possíveis valores para edição da expressão do "Conteúdo

...

". Os campos que não possuem listas de edição, não permitem edição no processo de download dos modelos.

Controle Linhas

Controle Detalhes

Controle Sequencial

Posição Inicial

Posição Final

Decimal

Informação

da Linha

Conteúdo

da LinhaValor Para

Opções de edição
0	H					HEADER DE

ARQUIVO 

ARQUIVO

.T.

                                                                                                    

0	T

TRAILLER 

TRAILER DE

ARQUIVO

ARQUIVO

.T.

                                                                                                    

1	D	1				DETALHE SEGMENTO

P

P

.T.

                                                                                                    

1	D	2				DETALHE SEGMENTO

Q

Q

.T.

                                                                                                    

1	D	3				DETALHE SEGMENTO

R

R

.T.

                                                                                                    

1	H					HEADER DE

LOTE

LOTE

.T.

                                                                                                    

1	T

TRAILLER

TRAILER DE

LOTE

LOTE

.T.

                                                                                                    

0	H		1	3	0	COD DO

BANCO

BANCO

33

                                                                                                    

0	H		4	7	0	LOTE

SERVICO

SERVICO

0

                                                                                                    

0	H		8	8	0	TIPO

REGISTRO

REGISTRO

0

                                                                                                    

0	H		9	16	0	USO EXCL

CNAB

CNAB

SPACE(8)

                                                                                                    

0	H		17	17	0	TIPO INSC

EMPRE

EMPRE

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

                                                                                                    

0	H		18	32	0	NRO INSC

EMPRES

EMPRES

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

                                                                                                    

0	H		33	47	0	COD

TRANSMISSAO

TRANSMISSAO

REPLICATE("0",15)

                                                                                                    

0	H		48	72	0	RESERV USO

BCO

BCO

SPACE(25)

                                                                                                    

0	H		73	102	0	NOME DA

EMPRESA

EMPRESA

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

                                                                                                    

0	H		103	132	0	NOME

BANCO

BANCO

PADR("BANCO SANTANDER",30,"")

                                                                                                    

0	H		133	142	0	RESERV USO

BCO

BCO

SPACE(10)

                                                                                                    

0	H		143	143	0	COD REM/

RET

RET

1

                                                                                                    

0	H		144	151	0	DT GERAC

ARQ0H

ARQ	GRAVADATA(DDATABASE,.F.,5)

{"DATE()","DDATABASE"}                                                                              

0	H

152

157

0

RESERV USO

BCO

BCO

SPACE(6)

                                                                                                    

0	H		158	163	0	NUM SEQ

ARQ

ARQ	PADL(ALLTRIM(INCREMENTA()),6,"0")

                                                                                                    

0	H		164	166	0	VER LAYOUT

ARQU

ARQU

40

                                                                                                    

0	H		167	240	0	DENSID GRV

ARQ

ARQ

SPACE(74)

                                                                                                    

0	T		1	3	0	COD BANCO	33

                                                                                                    

0	T		4	7	0	NRO LOTE

REMESS

REMESS

9999

                                                                                                    

0	T		8	8	0	TIPO

REGISTRO

REGISTRO

9

                                                                                                    

0	T		9	17	0	RESERVADO

BCO

BCO

SPACE(9)

                                                                                                    

0	T		18	23	0	QUANT LOT

ARQ

ARQ

                                                                                                    

0	T		24	29	0	QUANT REG

ARQ                                                                                                                                       

ARQ	PADL(ALLTRIM(QTDTOTTIT()),6,"0")

                                                                                                    

0	T		30	240	0	RESERVADO

BCO

BCO	SPACE(211)

                                                                                                    

1	D	2	1	3	0	COD BANCO	33

                                                                                                    

1	D	2	4	7	0	NRO LOTE

REMESS

REMESS

1

                                                                                                    

1	D	2	8	8	0	TIPO

REGISTRO

REGISTRO

3

                                                                                                    

1	D	2	9	13	0	NRO SEQ

LOTE

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

                                                                                                                                                                                                                

1	D	2	14	14	0	COD SEG

DETALHE

DETALHE

Q

                                                                                                    

1	D	2	15	15	0	RESERVADO

BCO

BCO

SPACE(1)

                                                                                                    

1	D	2	16	17	0	COD MOV

REMESSA                                                                                                    

REMESSA

                                                                                                                                       

1
1	D	2	18	18	0	TIPO INSC

SACAD

SACAD

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

                                                                                                    

1	D	2	19	33	0	NRO INSC

SACADO

SACADO

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

                                                                                                    

1	D	2	34	73	0	NOME

SACADO

SACADO

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

{"A1_NREDUZ","A1_NOME"}                                                                             

1	D	2	74	113	0	ENDERECO

SACADO

SACADO

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

                                                                                                    

1	D	2	114	128	0	BAIRRO

SACADO

SACADO

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

1	D	2	129	133	0	CEP

SACADO

SACADO

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

                                                                                                    

1	D	2	134	151	0	CIDADE

SACADO

SACADO

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

                                                                                                    

1	D	2	152	153	0	UF SACADO	SA1->A1_EST

                                                                                                    

1	D	2	154	154	0	TP INSC SAC

AVA

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

                                                                                                    

1	D	2	155	169	0	NRO INSC SAC

AV 

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

                                                                                                    

1	D	2	170	209	0	NOME SAC

AVALI1D2

AVALI

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

{"A1_NREDUZ","A1_NOME"}                                                                             

1	D	2

210

212

0

IDENT CARNE

0

                                                                                                    

1	D	2	213	215	0	SEQ PARC NRO

IN

IN

0

                                                                                                    

1	D	2	216	218	0	QTD TOTAL

PARCE

PARCE

0

                                                                                                    

1	D	2	219	221	0	NUMERO

PLANO

PLANO

0

                                                                                                    

1	D	2	222	240	0	RESERVADO

BCO

BCO

SPACE(19)

                                                                                                    

1	D	3	1	3	0	COD BANCO	33

                                                                                                    

1	D	3	4	7	0	NRO LOTE

REMESS

REMESS

1

                                                                                                    

1	D	3	8	8	0	TIPO

REGISTRO

REGISTRO

3

                                                                                                    

1	D	3	9	13	0	NRO SEQ

LOTE

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

                                                                                                    

1	D	3	14	14	0	COD SEG

DETALHE

DETALHE

R

                                                                                                    

1	D	3	15	15	0	RESERVADO

BCO

BCO

SPACE(1)

                                                                                                    

1	D	3	16	17	0	CODIGO

MOVIMENT

MOVIMENT

                                                                                                                                       

1

                                                                                                    

1	D	3	18	18	0	COD DESCONTO

2

2

                                                                                                                                       

0

                                                                                                    

1	D	3	19	26	0	DATA DESCONTO

2

2

                                                                                                    

1	D	3	27	41	2	VLR PERC

DESCON

DESCON

                                                                                                    

1	D	3	42	65	0	RESERVADO

BCO

BCO

SPACE(24)

                                                                                                    

1	D	3	66	66	0	CODIGO

MULTA                                                                                                    

MULTA

                                                                                                                                       

1
1	D	3	67	74	0	DATA MULTA

                                                                                                    

1	D	3	75	89	2	VLR PERC

MULTA                                                                                                                                       

MULTA

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

                                                                                                    

1	D	3	90	99	0	RESERVADO

BCO

BCO

SPACE(10)

                                                                                                    

1	D	3	100	139	0	MENSAGEM

3

3

SPACE(40)

                                                                                                    

1	D	3	140	179	0	MENSAGEM

4

4

SPACE(40)

                                                                                                    

1	D	3	180	240	0	RESERVADO	SPACE(61)

                                                                                                    

1	H		1	3	0	COD BANCO	33

                                                                                                    

1	H		4	7	0	NRO LOTE

REMESS

REMESS

1

                                                                                                    

1	H		8	8	0	TIPO

REGISTRO

REGISTRO

1

                                                                                                    

1	H		9	9	0	TIPO

OPERACAO

OPERACAO

R

                                                                                                    

1	H		10	11	0	TIPO SERVICO	1

                                                                                                    

1	H		12	13	0	RESERVADO

BCO

BCO

SPACE(2)

                                                                                                    

1	H		14	16	0	NRO VERS

LOTE

LOTE

30

                                                                                                    

1	H		17	17	0	RESERVADO

BCO

BCO

SPACE(1)

                                                                                                    

1	H		18	18	0	TIPO INSC

EMPRE

EMPRE

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

                                                                                                    

1	H		19	33	0	NUM INSC

EMP

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

                                                                                                    

1	H		34	53	0	RESERVADO

BCO

BCO

SPACE(20)

                                                                                                    

1	H		54	68	0	CODIGO

TRANSMIS

TRANSMIS

REPLICATE("0",15)

                                                                                                    

1	H		69	73	0	RESERVADO

BCO

BCO

SPACE(5)

                                                                                                    

1	H		74	103	0	NOME

CEDENTE

CEDENTE

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

                                                                                                    

1	H		104	143	0	MENSAGEM

1

1

SPACE(40)

                                                                                                    

1	H		144	183	0	MENSAGEM

2

2

SPACE(40)

                                                                                                    

1	H		184	191	0	NRO

REMESSA

REMESSA

PADL(ALLTRIM(INCREMENTA()),6,"0")

                                                                                                    

1	H		192	199	0	DATA GRAV

REMES

REMES

GRAVADATA(DDATABASE,.F.,5)

{"DATE()","DDATABASE"}                                                                              

1	H		200	240	0	RESERVADO

BCO

BCO

SPACE(41)

                                                                                                    

1	T		1	3	0	COD BANCO	33

                                                                                                    

1	T		4	7	0	NRO LOTE

REMESS

REMESS

1

                                                                                                    

1	T		8	8	0	TIPO

REGISTRO

REGISTRO

5

                                                                                                    

1	T		9	17	0	RESERVADO

BCO

BCO

SPACE(9)

                                                                                                    

1	T		18	23	0	QUANT REG

LOTE                                                                                                                                       

LOTE	PADL(QTDTITLOTE(),6,"0")

                                                                                                    

1	T		24	240	0	RESERVADO

BCO

BCO	SPACE(217)

                                                                                                    

1	D	1	1	3	0	COD BANCO	33

                                                                                                    

1	D	1	4	7	0	NRO LOTE

REMESS

REMESS

1

                                                                                                    

1	D	1	8	8	0	TIPO

REGISTRO

REGISTRO

3

                                                                                                    

1	D	1	9	13	0	NRO SEQ

LOTE

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

                                                                                                    

1	D	1	14	14	0	COD SEG

DETALHE

DETALHE

P

                                                                                                    

1	D	1	15	15	0	RESERV USO

BCO

BCO

SPACE(1)

                                                                                                    

1	D	1	16	17	0	COD MOVIM

REMES

REMES

                                                                                                    

1	D	1	18	21	0	AGENCIA

CEDENTE

CEDENTE

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

1	D	1	22	22	0	DV AGENCIA	CNABDVAG()

                                                                                                    

1	D	1	23	31	0	NRO CTA

CORRENT

CORRENT

PADL(ALLTRIM(SEA->EA_NUMCON),9,"0")

1	D	1	32	32	0	DV CTA

CORRENTE1

CORRENTE

CNABDVCC()

                                                                                                    

1

D

1

33

41

0

CONTA

COBRANCA

COBRANCA

PADL(ALLTRIM(SA6->A6_NUMCON),9,"0")

1	D	1	42	42	0	DV CONTA	SA6->A6_DVCTA

                                                                                                    

1	D	1	43	44	0	RESERV USO

BCO

BCO

SPACE(2)

                                                                                                    

1	D	1	45	57	0	ID TITULO

BANCO

BANCO

PADL(ALLTRIM(SE1->E1_NUMBCO),13,"0")

                                                                                                    

1	D	1	58	58	0	TIPO

COBRANCA

COBRANCA

1

                                                                                                    

1	D	1	59	59	0	FORMA

CADASTRAM

CADASTRAM

1

                                                                                                    

1	D	1	60	60	0	TIPO

DOCUMENTO

DOCUMENTO

1

                                                                                                    

1	D	1	61	61	0	RESERV USO

BCO

BCO

SPACE(1)

                                                                                                    

1	D	1	62	62	0	RESERV USO

BCO

BCO

SPACE(1)

                                                                                                    

1	D	1	63	77	0	NRO

DOCUMENTO

DOCUMENTO

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

1	D	1	78	85	0	DATA

VENCIMENTO

VENCIMENTO

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

{"E1_VENCREA","E1_EMISSAO","E1_VENCTO"}                                                             

1	D	1	86

1D186

100

2

VLR NOM

TITULO

TITULO

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

{"E1_SALDO","E1_VALOR"}                                                                             

1	D	1	101	104	0	AGENCIA ENC

COBREPLICATE("0",4)                                                                                                                                                                                                                           

COB	REPLICATE("0",4)

1D11051050DV AGENCIA                              0                                                                                                    1D11061060RESERV USO BCOSPACE(1)                                                                                                                                                                                                                                   1D11071080ESPECIE TITULO                                                                                                                                                                                                                                           1D11091090ID TITULO ACEIT                         N                                                                                                                                                                                                                                        1D11101170DATA EMIS TITULGRAVADATA(SE1->E1_EMISSAO,.F.,5){"E1_VENCREA","E1_EMISSAO","E1_VENCTO"}                                                             1D11181180COD JUROS MORA                                                                                                                                                                                                                                           1D11191260DATA JUROA MORA                                                                                                                                                                                                                                           1D11271412VLR MORA DIA                                                                                                                                                                                                                                                                       1D11421420COD DESCONTO 1                                                                                                                                                                                                                                           1D11431500DATA DESCONTO 1                                                                                                                                                                                                                                           1D11511652VLR PERC DESCON                                                                                                                                                                                                                                           1D11661802VLR IOF RECOLHI                                                                                                                                                                                                                                           1D11811952VLR ABATIMENTO                                                                                                                                                                                                                                           1D11962200ID TITULO EMPREPADR(ALLTRIM(SE1->E1_IDCNAB),25,"")                                                                                                    1D12212210COD PROTESTO                                                                                                                                                                                                                                           1D12222230NRO DIAS PROTES                                                                                                                                                                                                                                           1D12242240COD BAIXA DEVOL                                                                                                                                                                                                                                           1D12252250RESERV USO BCO0                                                                                                    

1	D	1

226

105

227

105

0

NRO DIAS BAIXA                                                                                                                                       

DV AGENCIA

0

                                                                                                    

1	D	1

228

106

229

106

0

CODIGO MOEDA0

RESERV USO BCO

SPACE(1)

                                                                                                    

1	D	1

230

107

240

108

0

RESERV USO BCOSPACE(11)                                                                                                                              

ESPECIE TITULO