Main.Invoicing.invoice-service.Implementation guide.Technical reference.Reports.ARREPORTS103 - ARFILEREPORT103

Page of - last modified by Jens Kral on 2021/12/02 09:50

ARFILEREPORT103

Jens Kral

2021/12/02 09:50

Table of Contents

Name convention

Example

Download sample file

The ARFILEREPORT103 file contains Surplus per customer

Name convention

ARFILEREPORT103_<OwnerCode>_<YYYYMMDDHHMMSS>_<SeqNo>.CSV

Name components	Description
OwnerCode	The company number in our ledger system
DateTime	The date and time that the file was created. Uses ISO 8601 format, YYYYMMDDhhmmss
SeqNo	Should follow an uninterrupted number series, 1, 2, 3 and so on.

E.g. ARFILEREPORT103_367_20210127084304_2

Table Header
ReportName	Name of the report :Remaining surplus details
ReportType	Internal name : ARFILEREPORT103
CompanyNo	The company number in our ledger system
CompanyName	The company name in our ledger system
RegNo	The company regno in our ledger system
CreatedDateTime	Date and time of creation : YYYY-MM-DD hh:mm:ss
ReportDate	Report data date : YYYY-MM-DD

Example

H1;Remaining surplus details;ARFILEREPORT103;367;payEx Sverige AB;112233-1234;2021-01-27 08:42:05;2020-12-05;

H2;Company no.;Reference id;Customer no.;Customer name;Amount;Currency;Payment date;

D;367;7427984;1234000;Sharron Biederman;299,00;SEK;2020-08-03;

D;367;7418409;4567000;Yoshiko Anzalone;62,17;SEK;2020-07-27;

E;

Download sample file

ARFILEREPORT103_367_20210127084304_1.DAT