Exibir origem

Import Agreement CTF

There are two reasons why you can choose the data integration between CTF and Assets Maintenance module - Fleet Management. Check below:

1. Perform the automatic inflow, replacing filling data typing and odometer for the system.

2. Calculate filling average statistic calculation, among others, different than the average available in the CTF System.

The Fleet Management solution made available processes to import, internalise and consist these two data generated by CTF.

To use this functionality, the file sent by the CTF agreement must be saved as abast.txt in the folder where the data dictionary is and follow the structure below:

Field	Type	Size	Description
INDEX	NUMBER	9	Pointer
NUMABAST	NUMBER	12	Document Number
VEICODIGO	CHAR	9	Vehicle code
TPREG	CHAR	5	Records Type
PUMP	CHAR	5	Pump Number
NET	CHAR	5	Net Code
station	CHAR	5	station code
FLEET	CHAR	5	Fleet Code
C	CHAR	1	Fuel Type
UVE	CHAR	4	UVE Number
LICENSE PLATE	CHAR	7	License Plate
DRIVER	CHAR	20	Driver
KM	NUMBER	7	Mileage (in kilometers)
QTY	NUMBER	10	Amount of Liters
PU	NUMBER	9	Unit Price
PUBRAND	NUMBER	9	Discount Types
TOTAL	NUMBER	14	Total
FILLINGDATE	DD/MM/YYYY HH:MM	20	Filling date/hour
DATE DEB	DD/MM/YYYY	10	Debit Date
CREDIT DATE	DD/MM/YYYY	10	Credit Date
FILLINGFILE	CHAR	15	Filling File
DIST COVERED	NUMBER	9	Distance Covered
TOTAL FILLING	NUMBER	10	Total Filling
S	CHAR	1	CTF exclusive field
CD_ABAT_ANTR_VEIC	CHAR	17	Previous Filling
STATION TRADE NAME	CHAR	18	Station trade name
CITY STATION	CHAR	40	City Station
CGC	CHAR	20	Station CGC

Linha Microsiga Protheus - Inglês > Import Agreement CTF -mnta130f_importacao_conv_ctf.htm > help_button.zoom40.gif Important:

The fields displayed in red in the table above are read in the import; the fields in blue are not read but must be in the import as they are part of the CTF import layout.

Procedures

Processing filling import program:

1.	In Import Agreement, the System automatically performs the import.

After running the import program, the file records abast.txt are saved in the table Imported Fillings – TR6.