Wiki source code of ARFILEREPORT106
Last modified by Jens Kral on 2021/12/02 09:53
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 |