Wiki source code of ARFILEREPORT127
Last modified by Jens Kral on 2021/12/02 09:54
1 | (% class="jumbotron" %) |
2 | ((( |
3 | (% class="container" %) |
4 | ((( |
5 | The ARFILEREPORT127 file contains a Credit report including book account details |
6 | ))) |
7 | ))) |
8 | |
9 | (% id="HAccountingDetail" %) |
10 | == Name convention == |
11 | |
12 | ARFILEREPORT127##_<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. ARFILEREPORT127_367_20210127084304_2## |
21 | |
22 | (% class="table-bordered table-striped" %) |
23 | |=Table Header|= |
24 | |ReportName|Name of the report :Credit Report |
25 | |ReportType|Internal name : ARFILEREPORT127 |
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|((( |
31 | Report date : YYYY-MM-DD |
32 | ))) |
33 | |ReportStartDate|Start of report : YYYY-MM-DD |
34 | |ReportEndDate|End of report :YYYY-MM-DD |
35 | |
36 | (% id="HXSDValidation" %) |
37 | == Example == |
38 | |
39 | 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; |
40 | 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; |
41 | D;10052671903;252147815294;18251119-4322;2021-01-22;2021-07-11;15080;CreditAll;Remission;SEK;100,00;0,00; |
42 | D;10052671904;252147815295;18251119-4322;2021-01-22;2021-07-31;15080;CreditAll;Remission;SEK;110,00;0,00; |
43 | E; |
44 | |
45 | (% id="HDownloadsamplefile" %) |
46 | == Download sample file == |
47 | |
48 | [[ARFILEREPORT127_28960_20210128154851_3.DAT>>attach:ARFILEREPORT127_367_20210128154851_3.DAT]] |