Skip to content
TwinfieldPHP Twinfield SDK

Transaction list (020)

Browse code 020 (BrowseCode::TransactionList, “Invoerverslag”): the transaction lines as they were entered, per day book, with the input date and the user. Use it to check what was booked in a period, e.g. per day book or per user.

Twinfield documentation: Browse data.

  • equal('fin.trs.head.code', $dayBook): one day book. equal('fin.trs.head.typecategory', 'SALESINVOICE') selects all day books of a category.
  • equal('fin.trs.head.status', 'normal'): provisional and final. Without it you also get drafts, with number -1.
  • fin.trs.head.inpdate is when the transaction was entered, a Datetime: dateTime(). It is also a criterion, like fin.trs.head.modified and fin.trs.head.user.
  • fin.trs.head.browseregime is the regime of the transaction (Generic, Fiscal, …) and can be a criterion.

Criteria: period, day book category, day book, number, status, date, input date, change date, the three dimensions, amount, invoice number, user and regime. See browse-definitions/020.xml and the browse data guide.

Fields

Section titled “Fields”

All fields of the browse definition (browse-definitions/020.xml), with the label for a Dutch user, the data type and the values of a field with a fixed list (browsefields.xml). A field that is not visible is meant as criterion: asking for it as column can give a server error. Twinfield does not apply the proposed values: send every criterion you need.

Field Label Type Visible Criterion
fin.trs.head.yearperiod Periode string yes between (proposed $DEFAULT$ … $DEFAULT$)
fin.trs.head.typecategory Dagboekcategorie string yes equal
fin.trs.head.code Dagboek string yes equal
fin.trs.head.shortname Naam string yes
fin.trs.head.number Boekst.nr. decimal yes between
fin.trs.head.status Status special: draft, temporary, final, inuse, normal yes equal (proposed normal)
fin.trs.head.date Boekdatum date yes between
fin.trs.head.inpdate Invoerdatum datetime no between
fin.trs.head.modified Wijzigingsdatum datetime no between
fin.trs.line.dim1 Grootboek string yes between
fin.trs.line.dim2 Relatie string yes between
fin.trs.line.dim3 Project string yes between
fin.trs.head.curcode Valuta string no
fin.trs.line.valuesigned Bedrag value no
fin.trs.line.basevaluesigned Euro value yes between
fin.trs.line.repvaluesigned – value no
fin.trs.line.invnumber Factuurnr. string yes equal
fin.trs.head.user Gebruiker string no equal
fin.trs.head.inpdate Invoerdatum datetime yes
fin.trs.line.description Omschrijving string yes
fin.trs.head.browseregime Regime special: Generic, Commercial, Economic, Fiscal yes equal

Code

Section titled “Code”
$twinfield = Example::twinfield();


$year = (int) ($argv[1] ?? Example::lastYear($twinfield));
$dayBook = $argv[2] ?? null;


$query = $twinfield->browse(BrowseCode::TransactionList)
    ->columns(
        'fin.trs.head.code',
        'fin.trs.head.number',
        'fin.trs.head.status',
        'fin.trs.head.date',
        'fin.trs.head.inpdate',
        'fin.trs.line.dim1',
        'fin.trs.line.dim2',
        'fin.trs.line.basevaluesigned',
        'fin.trs.line.description',
    )
    ->between('fin.trs.head.yearperiod', sprintf('%d/00', $year), sprintf('%d/55', $year))
    ->equal('fin.trs.head.status', 'normal');


if ($dayBook !== null) {
    $query = $query->equal('fin.trs.head.code', $dayBook);
}


$result = $query->get();


echo count($result), ' transaction line(s) entered in ', $year;
echo $dayBook === null ? '' : ' in day book ' . $dayBook, PHP_EOL;


foreach ($result as $index => $row) {
    echo rtrim(sprintf(
        '[%d/%d] %s %d line %d (%s), %s, entered %s: %s %s %s %s',
        $index + 1,
        count($result),
        $row->string('fin.trs.head.code'),
        $row->int('fin.trs.head.number'),
        $row->transactionLine?->line,
        $row->displayName('fin.trs.head.status') ?? $row->string('fin.trs.head.status'),
        $row->date('fin.trs.head.date')->format('Y-m-d'),
        $row->dateTime('fin.trs.head.inpdate')->format('Y-m-d H:i'),
        $row->string('fin.trs.line.dim1'),
        $row->nullableString('fin.trs.line.dim2') ?? '-',
        $row->amount('fin.trs.line.basevaluesigned'),
        $row->nullableString('fin.trs.line.description') ?? '',
    )), PHP_EOL;
}

Run

Section titled “Run”
Terminal window
php examples/browse-data/020-transaction-list/example.php            # the last year
php examples/browse-data/020-transaction-list/example.php 2026 VRK   # day book VRK in 2026

Add TWINFIELD_DEBUG=1 to see the SOAP requests and responses.

3 transaction line(s) entered in 2026
[1/3] VRK 202600001 line 1 (Definitief), 2026-01-15, entered 2026-01-15 10:15: 1300 1000 121.00 Invoice 2026-0001
[2/3] VRK 202600001 line 2 (Definitief), 2026-01-15, entered 2026-01-15 10:15: 8000 - -100.00 Invoice 2026-0001
[3/3] VRK 202600001 line 3 (Definitief), 2026-01-15, entered 2026-01-15 10:15: 1510 - -21.00 Invoice 2026-0001

XML

Section titled “XML”

What the SDK sends to Twinfield and what Twinfield sends back, for a call like the one in this example. The responses come from the tests, with example data.

Compose the browse request and send it

Section titled “Compose the browse request and send it”

Twinfield documentation: Browse data: Compose the browse request and send it.

$twinfield->browse(BrowseCode::TransactionList)
    ->columns(
        'fin.trs.head.code',
        'fin.trs.head.number',
        'fin.trs.head.status',
        'fin.trs.head.date',
        'fin.trs.head.inpdate',
        'fin.trs.line.dim1',
        'fin.trs.line.dim2',
        'fin.trs.line.basevaluesigned',
        'fin.trs.line.description',
    )
    ->between('fin.trs.head.yearperiod', '2026/00', '2026/55')
    ->equal('fin.trs.head.status', 'normal')
    ->equal('fin.trs.head.code', 'VRK')
    ->get();

The SDK sends this XML as xmlRequest of ProcessXmlString to processxml.asmx:

<columns code="020" optimize="true">
  <column>
    <field>fin.trs.head.code</field>
    <visible>true</visible>
    <operator>equal</operator>
    <from>VRK</from>
  </column>
  <column>
    <field>fin.trs.head.number</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.head.status</field>
    <visible>true</visible>
    <operator>equal</operator>
    <from>normal</from>
  </column>
  <column>
    <field>fin.trs.head.date</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.head.inpdate</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.line.dim1</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.line.dim2</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.line.basevaluesigned</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.line.description</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.head.yearperiod</field>
    <operator>between</operator>
    <from>2026/00</from>
    <to>2026/55</to>
  </column>
</columns>

Twinfield answers with this XML in ProcessXmlStringResult:

<browse result="1" first="1" last="3" total="3">
  <th>
    <td label="" hideforuser="false" type="String">fin.trs.head.code</td>
    <td label="" hideforuser="false" type="Decimal">fin.trs.head.number</td>
    <td label="" hideforuser="false" type="String">fin.trs.head.status</td>
    <td label="" hideforuser="false" type="Date">fin.trs.head.date</td>
    <td label="" hideforuser="false" type="Datetime">fin.trs.head.inpdate</td>
    <td label="" hideforuser="false" type="String">fin.trs.line.dim1</td>
    <td label="" hideforuser="false" type="String">fin.trs.line.dim2</td>
    <td label="" hideforuser="false" type="Value">fin.trs.line.basevaluesigned</td>
    <td label="" hideforuser="false" type="String">fin.trs.line.description</td>
  </th>
  <tr>
    <td>VRK</td>
    <td>202600001</td>
    <td name="Definitief">final</td>
    <td name="15/01/2026">20260115</td>
    <td name="15/01/2026 10:15:30">20260115101530</td>
    <td>1300</td>
    <td>1000</td>
    <td>121.00</td>
    <td>Invoice 2026-0001</td>
    <key>
      <office>1000</office>
      <code>VRK</code>
      <number>202600001</number>
      <line>1</line>
    </key>
  </tr>
  <tr>
    <td>VRK</td>
    <td>202600001</td>
    <td name="Definitief">final</td>
    <td name="15/01/2026">20260115</td>
    <td name="15/01/2026 10:15:30">20260115101530</td>
    <td>8000</td>
    <td/>
    <td>-100.00</td>
    <td>Invoice 2026-0001</td>
    <key>
      <office>1000</office>
      <code>VRK</code>
      <number>202600001</number>
      <line>2</line>
    </key>
  </tr>
  <tr>
    <td>VRK</td>
    <td>202600001</td>
    <td name="Definitief">final</td>
    <td name="15/01/2026">20260115</td>
    <td name="15/01/2026 10:15:30">20260115101530</td>
    <td>1510</td>
    <td/>
    <td>-21.00</td>
    <td>Invoice 2026-0001</td>
    <key>
      <office>1000</office>
      <code>VRK</code>
      <number>202600001</number>
      <line>3</line>
    </key>
  </tr>
</browse>

Source

Section titled “Source”

View examples/browse-data/020-transaction-list/example.php on GitHub.

Made by SolveBeam

Twinfield and Wolters Kluwer are trademarks of Wolters Kluwer. Their names and logos are used only to refer to their products.