Wiki source code of ARFILEREPORT106

Last modified by Jens Kral on 2021/12/02 09:53
Show last authors
1 (% class="jumbotron" %)
2 (((
3 (% class="container" %)
4 (((
5 The ARFILEREPORT106 file contains a Complete ledger report, for accounting reconciliation (ledger value as of any specified date)
6 )))
7 )))
8
9 (% id="HAccountingDetail" %)
10 == Name convention ==
11
12 ARFILEREPORT106##_<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. ARFILEREPORT106_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 : ARFILEREPORT106
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;Ledger report;ARFILEREPORT106;367;PayEx Sverige AB;112233-1234;2021-01-28 15:12:18;2021-01-27;
36 H2;Invoice no.;Customer no.;Reg no.;Currency;Capital debt;Invoice date;Due date;
37 D;367-71380016;25327371248;18120423-2704;SEK;199,00;2019-04-03;2019-04-29;
38 D;367-66745747;25327182973;18151112-9700;SEK;127,00;2018-06-08;2018-07-02;
39 E;
40
41 (% id="HDownloadsamplefile" %)
42 == Download sample file ==
43
44 [[ARFILEREPORT106_367_20210128151232_1.DAT>>attach:ARFILEREPORT106_367_20210128151232_1.DAT]]
45
46