84.4.4.16 STANDARD > GENERIC > TXT MONEY
Export Scope
The TXT Money Export allows stations to export the accounting data of all invoices issued in a given financial year, by Etere Money from orders created in Etere Air Sales.
At every export, 3 different plain-text files (.txt) are created containing accounting data retrieved from the Etere database:
Anagraf.txt - Full record of contacts in the Etere system (e.g. orders customers), including all their personal data.
Primanot.txt - Partial record (i.e. only for selected year) of all accounting documents issued for invoicing.
Provvigi.txt - Partial record (i.e. only for selected year) of commissions due to account executive involved on invoiced orders.
Note: In all text files, each line is a record which exported fields are separated by tab character (ASCII code # 9).
Export Parameters
In order to use this export function the following fields must be compiled:
5079_Export_standard_generic_txt_money
Parameters
Year to export - Specify the financial year to which accounting data to be exported is related.
Note: Current year cannot be selected as only past years can be exported.
Export path - Browse and select the directory on which exported XML files will be stored.
Launch the export
Once the export has been configured, it can be started just by pressing the <Export> button.
Sample exported files
The following text boxes illustrates a sample of exported data:
anagraf.txt
COD_CONTO RAG_SOCIAL CITTA VIA CAP PROVINCIA TELEFONO PART_IVA COD_FISC BANCA_APP COD_ABI COD_CAB COD_PAG ES_IVA SCONTO ST_ELENCO COD_RESPON PIAZZA INI_RAP TIPO_DITTA COD_SPE COD_TRA BUDGET DEST_1 DEST_2 DEST_3 NOTE_ANAG PAESE FAX TIPO_CLI LIVELLO_IN COD_MICRO AGE_RADIO AGE_TV AGE_CINEMA COD_CL_SP DESTB_1 DESTB_2 DESTB_3 ZONA AGENTE4 AGENTE5 AGENTE6 AGENTE7 CONTROPART POTENZIALE DATA_U_COM NUMERO_CC INTEST_CC IVA_FORN AGENTE8 COD_CIN COD_CORREN COD_RID INTES_RID E_MAIL SPRING
EmoClothes Emo Clothes Inc. Helsinki Muppets avenue #136 +358-533422342 Cash 0 358 +358-533422340 0 0 4 1070 emos@emode.com
ICOM iCOM ad-agency Perth 2834 Garden Place 13030 VC +61-523452347 122439821RT Cash VAT04 1 061 +61-523452344 4 0 4 1040 VAT02 jay.smith@i.com
Michael Panzer Rome Loc. ABC #666 00100 RM 0039-0733956348 VSQMHL007PER Multicredit italian bank BITA 76734 Cash VAT00 0 30/11/2010 SB Evil's Account Executive 039 1 4 0 AISEQ 30/11/2010 VAT00 michael@sale.it
michael.panzer@hotmail.com Panzer Florence 98030 ME 0 039 0 0 michael@sale.it
Sexy Phones S-Phones Tech Co. Singapore 147 31th avenue +65-01452832 T4JYTY6J9EJY897 Swiss national bank SWNB 78345 Long Instalment VAT01 0 Z 065 +65-011894237 A 1 0 20/10/2010 T4JYTY6J9EJY VAT01 T4JYTY6J9EJY lines@s-phones.com
Field
Description
Type
Length
COD_CONTO
Account code
nvarchar
510
RAG_SOCIAL
Company name
nvarchar
508
CITTA
City
nvarchar
80
VIA
Address
nvarchar
120
CAP
Postal code
nvarchar
16
PROVINCIA
State/Province
nvarchar
6
TELEFONO
Phone number
nvarchar
30
PART_IVA
VAT number
nvarchar
50
COD_FISC
Fiscal code / Registration Number
varchar
50
BANCA_APP
Bank name (Banche.Descrizione)
varchar
50
COD_ABI
ABI code (Banche.ABI)
varchar
32
COD_CAB
CAB code (Banche.CAB)
varchar
32
COD_PAG
Payment ID (id_pagamenti)
int
4
ES_IVA
VAT exempted (id_ivaesenzione)
int
4
SCONTO
Discount
decimal
5
ST_ELENCO
Not used
varchar
8
COD_RESPON
Responsible code
varchar
4
PIAZZA
Address square
nvarchar
120
INI_RAP
Relation starting date
datetime
8
TIPO_DITTA
Company type
varchar
5
COD_SPE
Shipping code
varchar
2
COD_TRA
Freight code
varchar
2
BUDGET
Budget
varchar
1
DEST_1
Address to ship 1
varchar
35
DEST_2
Address to ship 2
varchar
35
DEST_3
Address to ship 3
varchar
35
NOTE_ANAG
Personal notes
ntext
16
PAESE
Country
varchar
3
FAX
Fax
varchar
15
TIPO_CLI
Customer type
varchar
1
LIVELLO_IN
Insolvency level
int
4
COD_MICRO
Not used
int
4
AGE_RADIO
Account Executive 2
int
4
AGE_TV
Account Executive 3
int
4
AGE_CINEMA
Account Executive 1
int
4
COD_CL_SP
Customer shipping code
varchar
4
DESTB_1
Address to ship 1 (delivery)
varchar
35
DESTB_2
Address to ship 2 (delivery)
varchar
35
DESTB_3
Address to ship 3 (delivery)
varchar
35
ZONA
Zone
nvarchar
4
AGENTE4
Account Executive 4
int
4
AGENTE5
Account Executive 5
int
4
AGENTE6
Account Executive 6
int
4
AGENTE7
Account Executive 7
int
4
AGENTE8
Account Executive 8
int
4
CONTROPART
Account code (Pianoconti.id_pianoconti)
int
4
POTENZIALE
Potential
varchar
5
DATA_U_COM
Last communication date
datetime
8
NUMERO_CC
Current account number
varchar
12
INTEST_CC
Current account heading
varchar
25
IVA_FORN
Supplier VAT
int
4
COD_CIN
CIN code
varchar
1
COD_CORREN
varchar
16
COD_RID
RID code
varchar
16
INTES_RID
RID heading
varchar
20
E_MAIL
E-mail
varchar
300
SPRING
Spring
varchar
20
primano.txt
"PrimaNota_testata" table
DARE COD_CONTO IMPORTO COD_IVA N_REGISTR DESCRIZION DATA_DOC DATA_REG N_DOCUMEN ST_IVA PUNTO_IMM N_PROTOC BOLLAT NEW_REG COD_PAG ANNO_RIF T_VALUTA IMPORTO_VL STA1 STA2 STA3
True 4 0000 BeltzTV 770.00 1 Emissione fattura 01/25/2011 01/25/2011 1 V V 0 False 0 Cash 2011
False 5 5502 700.00 VAT03 1 Emissione fattura 01/25/2011 01/25/2011 1 V V 0 False 0 Cash 2011
False 5 0000 70.00 VAT03 1 Emissione fattura 01/25/2011 01/25/2011 1 V V 0 False 0 Cash 2011
True 1 1110 Sexy Phones .00 2 Emissione fattura 01/25/2011 01/25/2011 2 V V 0 False 0 Agency 2011
True 1 1110 Sexy Phones 5854.50 3 Emissione fattura 01/25/2011 01/25/2011 3 V V 0 False 0 Agency 2011
False 1 1110 100.00 VAT02 3 Emissione fattura 01/25/2011 01/25/2011 3 V V 0 False 0 Agency 2011
False 5 0000 7.00 VAT02 3 Emissione fattura 01/25/2011 01/25/2011 3 V V 0 False 0 Agency 2011
Field
Description
Type
Length
DARE
0=false=credit; 1=true=debit
bit
1
COD_CONTO
Account code
varchar
32
IMPORTO
Amount of the line
money
8
COD_IVA
VAT code
varchar
32
N_REGISTR
Record number
int
4
DESCRIZION
Description of the line
varchar
100
DATA_DOC
Document creation date
datetime
8
DATA_REG
Document registration date
datetime
8
N_DOCUMEN
Document number
varchar
10
ST_IVA
VAT
char
1
PUNTO_IMM
Insertion point
char
1
N_PROTOC
Protocol number
int
4
BOLLAT
Register stamped
bit
1
NEW_REG
Protocol of the registry
int
4
COD_PAG
Payment ID (id_pagamenti)
int
4
ANNO_RIF
Invoice financial year
int
8
T_VALUTA
Original currency
varchar
50
IMPORTO_VL
Original currency amount
decimal
5
STA1
Not used
int
4
STA2
Not used
int
4
STA3
Not used
int
4
provvigi.txt
"Provvigioni" table
NFA N_RIGA AGENTE_V PERC_AGENT DATA_SCAD DATA_PAG ANNO_RIF
1 0 Michael 5.00 01/25/2011 2011
6 0 Michael 20.00 03/03/2011 2011
11 0 Ricky 1.00 05/04/2011 2011
12 0 Michael 7.00 02/03/2011 2011
12 0 Mark 1.00 02/03/2011 2011
12 0 Ricky 1.00 02/03/2011 2011
40 0 Miette 3.00 05/16/2011 2011
40 0 Michael 10.00 05/16/2011 2011
40 0 Miette 3.00 05/16/2011 201
Field
Description
Type
Length
NFA
Invoice number
int
4
N_RIGA
Not used (always zero)
int
1
AGENTE_V
Account Executive code
nvarchar
80
PERC_AGENT
Account Executive commission
decimal
5
DATA_SCAD
Payment deadline date
datetime
8
DATA_PAG
Payment collection date
datetime
8
ANNO_RIF
Related financial year
int
4
5079_Export_standard_generic_txt_money