Wiki source code of ARFILEREPORT125

Last modified by Jens Kral on 2021/12/02 09:54
Show last authors
1 (% class="jumbotron" %)
2 (((
3 (% class="container" %)
4 (((
5 The ARFILEREPORT125 file contains a Credit report standard
6 )))
7 )))
8
9 (% id="HAccountingDetail" %)
10 == Name convention ==
11
12 ARFILEREPORT125##_<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. ARFILEREPORT125_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 : ARFILEREPORT125
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 date : YYYY-MM-DD
31 |ReportStartDate|Start of report :YYYY-MM-DD 00:00:00
32 |ReportEndDate|End of report :YYYY-MM-DD 00:00:00
33
34 (% id="HXSDValidation" %)
35 == Example ==
36
37 H1;Credit report;ARFILEREPORT125;367;PayEx Sverige AB;112233-1234;2021-01-28 15:42:29;2021-01-28;2021-01-01 00:00:00;2021-01-31 00:00:00;
38 H2;Customer no.;Customer name;Invoice no.;Amount;Credit cause;Account;Sign;
39 D;252145715303;Shae Elofson;10035671912;110,00;Remission;15080;ahu;
40 D;Cust763033418;Dr Stephen Strange;Inv511446934;520,00;Bankruptcy;15080;ahu;
41 E;
42
43 (% id="HDownloadsamplefile" %)
44 == Download sample file ==
45
46 [[ARFILEREPORT125_367_20210128154231_2:DAT>>attach:ARFILEREPORT125_367_20210128154231_2.DAT]]