Bank link details (680_2)

Browse code 680_2 (BrowseCode::BankLinkDetailsV2, “Bankkoppeling details (v2)”): the bank books of the company with their IBAN, currency and the kind of link for account information, payments and direct debits, and when the consent of the bank expires.

Twinfield documentation: Browse data.

• fin.bnk.accountintegrationtype, payments and directdebits: none, classic, commercial or Bank feed (the bank link).
• equal('fin.bnk.accountstatus', 'active'): only active bank books, not the archived ones. It is the only criterion.
• fin.bnk.consentexpirydate is a date and empty without a bank link: nullableDate().

Criteria: status. See browse-definitions/680_2.xml and the browse data guide.

Fields

All fields of the browse definition (browse-definitions/680_2.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.office	Administratie	string	yes
fin.trs.head.officename	Adm.naam	string	yes
fin.bnk.iban	IBAN	string	yes
fin.bnk.transactiontype	Dagboek	string	yes
fin.bnk.accountintegrationtype	Rekeninginformatie	special: none, classic, commercial, Bank feed	yes
fin.bnk.payments	Betaalopdrachten	special: none, classic, commercial, Bank feed	yes
fin.bnk.directdebits	Incasso-opdrachten	special: none, classic, commercial, Bank feed	yes
fin.bnk.accountstatus	Status	special: archived, active	yes	equal
fin.bnk.dim1	Grootboekrek.	string	yes
fin.bnk.dim1name	Grootboekrek.naam	string	yes
fin.bnk.currency	Valuta	string	yes
fin.bnk.consentexpirydate	Consent expiry date	date	yes

Code

$twinfield = Example::twinfield();

$query = $twinfield->browse(BrowseCode::BankLinkDetailsV2)
    ->columns(
        'fin.bnk.transactiontype',
        'fin.bnk.iban',
        'fin.bnk.currency',
        'fin.bnk.accountintegrationtype',
        'fin.bnk.payments',
        'fin.bnk.directdebits',
        'fin.bnk.consentexpirydate',
    )
    ->equal('fin.bnk.accountstatus', 'active');

$result = $query->get();

echo count($result), ' active bank book(s)', PHP_EOL;

foreach ($result as $index => $row) {
    $consent = $row->nullableDate('fin.bnk.consentexpirydate');

    echo sprintf(
        '[%d/%d] %s IBAN %s %s: account information %s, payments %s, direct debits %s, consent until %s',
        $index + 1,
        count($result),
        $row->string('fin.bnk.transactiontype'),
        $row->string('fin.bnk.iban'),
        $row->string('fin.bnk.currency'),
        $row->string('fin.bnk.accountintegrationtype'),
        $row->string('fin.bnk.payments'),
        $row->string('fin.bnk.directdebits'),
        $consent === null ? '-' : $consent->format('Y-m-d'),
    ), PHP_EOL;
}

Run

php examples/browse-data/680_2-bank-link-details-v2/example.php   # all active bank books

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

2 active bank book(s)
[1/2] BNK IBAN NL91ABNA0417164300 EUR: account information Bank feed, payments none, direct debits none, consent until 2027-01-15
[2/2] BNK2 IBAN - EUR: account information none, payments none, direct debits none, consent until -

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::BankLinkDetailsV2)
    ->columns(
        'fin.bnk.transactiontype',
        'fin.bnk.iban',
        'fin.bnk.currency',
        'fin.bnk.accountintegrationtype',
        'fin.bnk.payments',
        'fin.bnk.directdebits',
        'fin.bnk.consentexpirydate',
    )
    ->equal('fin.bnk.accountstatus', 'active')
    ->get();

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

<columns code="680_2" optimize="true">
  <column>
    <field>fin.bnk.transactiontype</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.bnk.iban</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.bnk.currency</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.bnk.accountintegrationtype</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.bnk.payments</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.bnk.directdebits</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.bnk.consentexpirydate</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.bnk.accountstatus</field>
    <operator>equal</operator>
    <from>active</from>
  </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.bnk.transactiontype</td>
    <td label="" hideforuser="false" type="String">fin.bnk.iban</td>
    <td label="" hideforuser="false" type="String">fin.bnk.currency</td>
    <td label="" hideforuser="false" type="String">fin.bnk.accountintegrationtype</td>
    <td label="" hideforuser="false" type="String">fin.bnk.payments</td>
    <td label="" hideforuser="false" type="String">fin.bnk.directdebits</td>
    <td label="" hideforuser="false" type="Date">fin.bnk.consentexpirydate</td>
  </th>
  <tr>
    <td>BNK</td>
    <td>NL91ABNA0417164300</td>
    <td>EUR</td>
    <td name="Bankkoppeling">Bank feed</td>
    <td name="Geen">none</td>
    <td name="Geen">none</td>
    <td name="15/01/2027">20270115</td>
    <key>
      <office>1000</office>
    </key>
  </tr>
  <tr>
    <td>BNK2</td>
    <td>-</td>
    <td>EUR</td>
    <td name="Geen">none</td>
    <td name="Geen">none</td>
    <td name="Geen">none</td>
    <td/>
    <key>
      <office>1000</office>
    </key>
  </tr>
</browse>

Source

View examples/browse-data/680_2-bank-link-details-v2/example.php on GitHub.