Main.Invoicing.invoice-service.Implementation guide.Technical reference.Reports.ARFILEREPORT127 - ARFILEREPORT127

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

ARFILEREPORT127

Jens Kral

2021/12/02 09:54

Table of Contents

Name convention

Example

Download sample file

The ARFILEREPORT127 file contains a Credit report including book account details

Name convention

ARFILEREPORT127_<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. ARFILEREPORT127_367_20210127084304_2

Table Header
ReportName	Name of the report :Credit Report
ReportType	Internal name : ARFILEREPORT127
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 date : YYYY-MM-DD
ReportStartDate	Start of report : YYYY-MM-DD
ReportEndDate	End of report :YYYY-MM-DD

Example

H1;Credit report;ARFILEREPORT127;367;PayEx Sverige AB;112233-1234;2021-01-28 15:48:50;2021-01-28;2021-01-01;2021-01-31;
H2;Invoice no.;Customer no.;Reg no.;Book date;Value date;Bookaccount code;Transaction type;Transaction cause;Currency code;Total credited amount incl vat;Calc credited vat amount;
D;10052671903;252147815294;18251119-4322;2021-01-22;2021-07-11;15080;CreditAll;Remission;SEK;100,00;0,00;
D;10052671904;252147815295;18251119-4322;2021-01-22;2021-07-31;15080;CreditAll;Remission;SEK;110,00;0,00;
E;

Download sample file

ARFILEREPORT127_28960_20210128154851_3.DAT