Wiki source code of ARFILEREPORT110
Last modified by Jens Kral on 2021/12/02 09:53
1 | (% class="jumbotron" %) |
2 | ((( |
3 | (% class="container" %) |
4 | ((( |
5 | The ARFILEREPORT110 file contains a Complete ledger report with invoice details (ledger value as of the time of scheduled ordering) |
6 | ))) |
7 | ))) |
8 | |
9 | (% id="HAccountingDetail" %) |
10 | == Name convention == |
11 | |
12 | ARFILEREPORT110##_<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. ARFILEREPORT110_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 : ARFILEREPORT110 |
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;Leger report;ARFILEREPORT110;367;Payex Sverige AB;112233-1234;2021-01-28 15:33:54;2021-01-27; |
36 | H2;Legal entity;Seller no.;Seller;Customer no.;Customer name;Reg no.;Invoice no.;Invoice date;Due date;Recent claimdate;Claimlevel;Currentcapitaldebt;BadCapitaldebt;Currentdebt;OriginalDebt;Currency;Status;Respitedate; |
37 | D;N/A;;;25327089639;Corinna Annett;18180515-9579;367-71361795;2019-04-03;2019-04-29;2019-06-04;Transferred to debt collection;499,00;0,00;562,38;499,00;SEK;;; |
38 | E; |
39 | |
40 | (% id="HDownloadsamplefile" %) |
41 | == Download sample file == |
42 | |
43 | [[ARFILEREPORT110_367_20210128153452_1>>attach:ARFILEREPORT110_367_20210128153452_1.DAT]] |