Wiki source code of ARFILEREPORT110
Last modified by Jens Kral on 2021/12/02 09:53
8.1 | 1 | (% class="jumbotron" %) | |
2 | ((( | ||
3 | (% class="container" %) | ||
4 | ((( | ||
9.1 | 5 | The ARFILEREPORT110 file contains a Complete ledger report with invoice details (ledger value as of the time of scheduled ordering) | |
8.1 | 6 | ))) | |
7 | ))) | ||
2.1 | 8 | ||
9 | (% id="HAccountingDetail" %) | ||
10 | == Name convention == | ||
11 | |||
3.1 | 12 | ARFILEREPORT110##_<OwnerCode>_<YYYYMMDDHHMMSS>_<SeqNo>.CSV## | |
2.1 | 13 | ||
6.1 | 14 | (% class="table-bordered table-striped" %) | |
15.1 | 15 | |=Name components|=Description | |
9.1 | 16 | |OwnerCode|The company number in our ledger system | |
2.1 | 17 | |DateTime|The date and time that the file was created. Uses ISO 8601 format, ##YYYYMMDDhhmmss## | |
15.1 | 18 | |SeqNo|Should follow an uninterrupted number series, 1, 2, 3 and so on. | |
2.1 | 19 | ||
11.1 | 20 | ##E.g. ARFILEREPORT110_367_20210127084304_2## | |
2.1 | 21 | ||
6.1 | 22 | (% class="table-bordered table-striped" %) | |
2.1 | 23 | |=Table Header|= | |
9.1 | 24 | |ReportName|Name of the report :Ledger report | |
6.1 | 25 | |ReportType|Internal name : ARFILEREPORT110 | |
2.1 | 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 | |||
11.1 | 35 | H1;Leger report;ARFILEREPORT110;367;Payex Sverige AB;112233-1234;2021-01-28 15:33:54;2021-01-27; | |
4.1 | 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; | |
12.1 | 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;;; | |
2.1 | 38 | E; | |
39 | |||
40 | (% id="HDownloadsamplefile" %) | ||
41 | == Download sample file == | ||
42 | |||
14.1 | 43 | [[ARFILEREPORT110_367_20210128153452_1>>attach:ARFILEREPORT110_367_20210128153452_1.DAT]] |