Wiki source code of ARFILEREPORT127

Last modified by Jens Kral on 2021/12/02 09:54
Show last authors
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]]