Project transactions (300)

Browse code 300 (BrowseCode::ProjectTransactions, “Projectkaart”): the transaction lines booked on projects (dimension 3), with the general ledger account and cost centre.

Twinfield documentation: Browse data.

• fin.trs.line.dim3 is the project, dim1 the general ledger account and dim2 the cost centre or relation.
• between('fin.trs.line.dim3', $project, $project): one project.
• The status is not a criterion in 300: you get all transactions, also drafts (number -1). Ask for fin.trs.head.status as column and skip them when needed.
• fin.trs.head.yearperiod is visible in 300: it can be a column as well as a criterion.

Criteria: period, day book, number, the three dimensions, invoice number and regime. See browse-definitions/300.xml and the browse data guide.

Fields

All fields of the browse definition (browse-definitions/300.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.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	no
fin.trs.line.dim1	Grootboek	string	yes	between
fin.trs.line.dim1name	Naam	string	yes
fin.trs.line.dim2	Kostenplaats	string	yes	between
fin.trs.line.dim2name	Naam	string	yes
fin.trs.line.dim3	Project	string	yes	between
fin.trs.line.dim3name	Naam	string	yes
fin.trs.head.curcode	Valuta	string	no
fin.trs.line.valuesigned	Bedrag	value	no
fin.trs.line.basevaluesigned	Euro	value	yes
fin.trs.line.repvaluesigned	–	value	no
fin.trs.line.invnumber	Factuurnr.	string	yes	equal
fin.trs.head.browseregime	Regime	special: Generic, Commercial, Economic, Fiscal	yes	equal

Code

$twinfield = Example::twinfield();

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

$query = $twinfield->browse(BrowseCode::ProjectTransactions)
    ->columns(
        'fin.trs.line.dim3',
        'fin.trs.line.dim3name',
        'fin.trs.head.yearperiod',
        'fin.trs.head.code',
        'fin.trs.head.number',
        'fin.trs.head.status',
        'fin.trs.line.dim1',
        'fin.trs.line.dim2',
        'fin.trs.line.basevaluesigned',
    )
    ->between('fin.trs.head.yearperiod', sprintf('%d/00', $year), sprintf('%d/55', $year));

if ($project !== null) {
    $query = $query->between('fin.trs.line.dim3', $project, $project);
}

$result = $query->get();

echo count($result), ' project line(s) in ', $year, $project === null ? '' : ' of project ' . $project, PHP_EOL;

foreach ($result as $index => $row) {
    echo sprintf(
        '[%d/%d] %s %s, %s %s %d (%s): %s %s %s',
        $index + 1,
        count($result),
        $row->string('fin.trs.line.dim3'),
        $row->nullableString('fin.trs.line.dim3name') ?? '',
        $row->period('fin.trs.head.yearperiod'),
        $row->string('fin.trs.head.code'),
        $row->int('fin.trs.head.number'),
        $row->string('fin.trs.head.status'),
        $row->string('fin.trs.line.dim1'),
        $row->nullableString('fin.trs.line.dim2') ?? '-',
        $row->amount('fin.trs.line.basevaluesigned'),
    ), PHP_EOL;
}

Run

php examples/browse-data/300-project-transactions/example.php              # the last year
php examples/browse-data/300-project-transactions/example.php 2026 P0001   # project P0001 in 2026

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

2 project line(s) in 2026
[1/2] P0001 Example project, 2026/01 VRK 202600001 (final): 8000 00100 -100.00
[2/2] P0001 Example project, 2026/02 INK 202600003 (final): 4500 00100 50.00

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

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

$twinfield->browse(BrowseCode::ProjectTransactions)
    ->columns(
        'fin.trs.line.dim3',
        'fin.trs.line.dim3name',
        'fin.trs.head.yearperiod',
        'fin.trs.head.code',
        'fin.trs.head.number',
        'fin.trs.head.status',
        'fin.trs.line.dim1',
        'fin.trs.line.dim2',
        'fin.trs.line.basevaluesigned',
    )
    ->between('fin.trs.head.yearperiod', '2026/00', '2026/55')
    ->between('fin.trs.line.dim3', 'P0001', 'P0001')
    ->get();

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

<columns code="300" optimize="true">
  <column>
    <field>fin.trs.line.dim3</field>
    <visible>true</visible>
    <operator>between</operator>
    <from>P0001</from>
    <to>P0001</to>
  </column>
  <column>
    <field>fin.trs.line.dim3name</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.head.yearperiod</field>
    <visible>true</visible>
    <operator>between</operator>
    <from>2026/00</from>
    <to>2026/55</to>
  </column>
  <column>
    <field>fin.trs.head.code</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.head.number</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.head.status</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>
</columns>

Twinfield answers with this XML in ProcessXmlStringResult:

<browse result="1" first="1" last="2" total="2">
  <th>
    <td label="" hideforuser="false" type="String">fin.trs.line.dim3</td>
    <td label="" hideforuser="false" type="String">fin.trs.line.dim3name</td>
    <td label="" hideforuser="false" type="String">fin.trs.head.yearperiod</td>
    <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="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>
  </th>
  <tr>
    <td>P0001</td>
    <td>Example project</td>
    <td>2026/01</td>
    <td>VRK</td>
    <td>202600001</td>
    <td name="Definitief">final</td>
    <td>8000</td>
    <td>00100</td>
    <td>-100.00</td>
    <key>
      <office>1000</office>
      <code>VRK</code>
      <number>202600001</number>
      <line>2</line>
    </key>
  </tr>
  <tr>
    <td>P0001</td>
    <td>Example project</td>
    <td>2026/02</td>
    <td>INK</td>
    <td>202600003</td>
    <td name="Definitief">final</td>
    <td>4500</td>
    <td>00100</td>
    <td>50.00</td>
    <key>
      <office>1000</office>
      <code>INK</code>
      <number>202600003</number>
      <line>2</line>
    </key>
  </tr>
</browse>

Source

View examples/browse-data/300-project-transactions/example.php on GitHub.