Wiki source code of ARFILEREPORT110

Last modified by Jens Kral on 2021/12/02 09:53
Show last authors
1 (% class="jumbotron" %)
2 (((
3 (% class="container" %)
4 (((
5 The ARFILEREPORT110 file contains a Complete ledger report with invoice details (ledger value as of the time of scheduled ordering)
6 )))
7 )))
8
9 (% id="HAccountingDetail" %)
10 == Name convention ==
11
12 ARFILEREPORT110##_<OwnerCode>_<YYYYMMDDHHMMSS>_<SeqNo>.CSV##
13
14 (% class="table-bordered table-striped" %)
15 |=Name components|=Description
16 |OwnerCode|The company number in our ledger system
17 |DateTime|The date and time that the file was created. Uses ISO 8601 format, ##YYYYMMDDhhmmss##
18 |SeqNo|Should follow an uninterrupted number series, 1, 2, 3 and so on.
19
20 ##E.g. ARFILEREPORT110_367_20210127084304_2##
21
22 (% class="table-bordered table-striped" %)
23 |=Table Header|=
24 |ReportName|Name of the report :Ledger report
25 |ReportType|Internal name : ARFILEREPORT110
26 |CompanyNo|The company number in our ledger system
27 |CompanyName|The company name in our ledger system
28 |RegNo|The company regno in our ledger system
29 |CreatedDateTime|Date and time of creation : YYYY-MM-DD hh:mm:ss
30 |ReportDate|Report data date : YYYY-MM-DD
31
32 (% id="HXSDValidation" %)
33 == Example ==
34
35 H1;Leger report;ARFILEREPORT110;367;Payex Sverige AB;112233-1234;2021-01-28 15:33:54;2021-01-27;
36 H2;Legal entity;Seller no.;Seller;Customer no.;Customer name;Reg no.;Invoice no.;Invoice date;Due date;Recent claimdate;Claimlevel;Currentcapitaldebt;BadCapitaldebt;Currentdebt;OriginalDebt;Currency;Status;Respitedate;
37 D;N/A;;;25327089639;Corinna Annett;18180515-9579;367-71361795;2019-04-03;2019-04-29;2019-06-04;Transferred to debt collection;499,00;0,00;562,38;499,00;SEK;;;
38 E;
39
40 (% id="HDownloadsamplefile" %)
41 == Download sample file ==
42
43 [[ARFILEREPORT110_367_20210128153452_1>>attach:ARFILEREPORT110_367_20210128153452_1.DAT]]