# Precal_Openstaande_posten_crediteur: Precal Outstanding Items Creditor ## Documentation Precal [Open supplier items] - Name: `Precal_Openstaande_posten_crediteur` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: Precal Outstanding Items Creditor ## Table Columns The columns of the table `Precal_Openstaande_posten_crediteur` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Administratie` | `int32` | Administration | | | | `BetaaldBedrag` | `decimal` | Paid | | | | `BetaaldBedragValuta` | `decimal` | Paid in currency | | | | `Boekstukdatum` | `datetime` | Document date | | | | `Debet_Credit` | `string` | Invoice amount D/C | | | | `Factuurnummer` | `string` | Invoice number | | | | `Omschrijving` | `string` | Invoice description | | | | `Relatie` | `string` | Number | | | | `Saldo` | `decimal` | Balance | | | | `SaldoValuta` | `decimal` | Balance (currency) | | | | `Subnummer` | `string` | Sub-number | | | | `TotaalFactuurbedrag` | `decimal` | Total invoice amount | | | | `TotaalFactuurbedragValuta` | `decimal` | Total invoice amount in currency | | | | `Valutacode` | `string` | Currency | | | | `Vervaldagen` | `int32` | Due days | | | | `Vervaldatum` | `datetime` | Due date | | |