# Precal_Openstaande_posten_debiteur: Precal Outstanding Items Debtor ## Documentation Precal [Open customer items] - Name: `Precal_Openstaande_posten_debiteur` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Precal Outstanding Items Debtor - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Precal_Openstaande_posten_debiteur` - Insert Service URL (OData-specific): `/connectors/Precal_Openstaande_posten_debiteur` - Update Service URL (OData-specific): `/connectors/Precal_Openstaande_posten_debiteur` - Delete Service URL (OData-specific): `/connectors/Precal_Openstaande_posten_debiteur` - Field Selection Method (OData-specific): NotRequired ## 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(1)` | Debit/credit | | | | `Factuurnummer` | `string(12)` | Invoice number | | | | `Omschrijving` | `string(120)` | Invoice description | | | | `Relatie` | `string(15)` | Number | | | | `Saldo` | `decimal` | Balance | | | | `SaldoValuta` | `decimal` | Balance (currency) | | | | `Subnummer` | `string(16)` | Sub-number | | | | `TotaalFactuurbedrag` | `decimal` | Total invoice amount | | | | `TotaalFactuurbedragValuta` | `decimal` | Total invoice amount in currency | | | | `Valutacode` | `string(3)` | Currency | | | | `Vervaldagen` | `int32` | Due days | | | | `Vervaldatum` | `datetime` | Due date | | |