# Precal_Openstaande_posten_debiteur: Precal Outstanding Items Debtor ## Documentation Precal [Open customer items] - Name: `Precal_Openstaande_posten_debiteur` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: Precal Outstanding Items Debtor ## Table Columns The columns of the table `Precal_Openstaande_posten_debiteur` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Administratie` | `int32` | Administration | | | | `BetaaldBedrag` | `decimal` | Amount paid | | | | `BetaaldBedragValuta` | `decimal` | Paid in currency | | | | `Boekstukdatum` | `datetime` | Document date | | | | `Debet_Credit` | `string` | Debit/credit | | | | `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 | | |