Wiki source code of ARFILEREPORT127
Last modified by Jens Kral on 2021/12/02 09:54
 |
7.1 | 1 | (% class="jumbotron" %) |
| 2 | ((( | ||
| 3 | (% class="container" %) | ||
| 4 | ((( | ||
| |
8.1 | 5 | The ARFILEREPORT127 file contains a Credit report including book account details |
| |
7.1 | 6 | ))) |
| 7 | ))) | ||
| |
3.1 | 8 | |
| 9 | (% id="HAccountingDetail" %) | ||
| 10 | == Name convention == | ||
| 11 | |||
| 12 | ARFILEREPORT127##_<OwnerCode>_<YYYYMMDDHHMMSS>_<SeqNo>.CSV## | ||
| 13 | |||
| 14 | (% class="table-bordered table-striped" %) | ||
| |
11.1 | 15 | |=Name components|=Description |
| |
8.1 | 16 | |OwnerCode|The company number in our ledger system |
| |
3.1 | 17 | |DateTime|The date and time that the file was created. Uses ISO 8601 format, ##YYYYMMDDhhmmss## |
| |
11.1 | 18 | |SeqNo|Should follow an uninterrupted number series, 1, 2, 3 and so on. |
| |
3.1 | 19 | |
| |
10.1 | 20 | ##E.g. ARFILEREPORT127_367_20210127084304_2## |
| |
3.1 | 21 | |
| 22 | (% class="table-bordered table-striped" %) | ||
| 23 | |=Table Header|= | ||
| |
8.1 | 24 | |ReportName|Name of the report :Credit Report |
| |
4.1 | 25 | |ReportType|Internal name : ARFILEREPORT127 |
| |
3.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 | ||
| |
5.1 | 30 | |ReportDate|((( |
| |
6.1 | 31 | Report date : YYYY-MM-DD |
| |
5.1 | 32 | ))) |
| 33 | |ReportStartDate|Start of report : YYYY-MM-DD | ||
| 34 | |ReportEndDate|End of report :YYYY-MM-DD | ||
| |
3.1 | 35 | |
| 36 | (% id="HXSDValidation" %) | ||
| 37 | == Example == | ||
| 38 | |||
| |
10.1 | 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; |
| |
3.1 | 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 | |||
| |
10.1 | 48 | [[ARFILEREPORT127_28960_20210128154851_3.DAT>>attach:ARFILEREPORT127_367_20210128154851_3.DAT]] |