# Profit_Transactions_Allocated: Profit Transactions Allocated ## Documentation Profit_Transactions_Allocated - Name: `Profit_Transactions_Allocated` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Profit Transactions Allocated - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Profit_Transactions_Allocated` - Insert Service URL (OData-specific): `/connectors/Profit_Transactions_Allocated` - Update Service URL (OData-specific): `/connectors/Profit_Transactions_Allocated` - Delete Service URL (OData-specific): `/connectors/Profit_Transactions_Allocated` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Profit_Transactions_Allocated` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountNo` | `string(16)` | Account number | | | | `AmtCredit` | `decimal` | Credit amount | | | | `AmtDebit` | `decimal` | Debit amount | | | | `Collect_On` | `string(100)` | Control account type | | | | `Created` | `datetime` | Date added | | | | `Description` | `string(120)` | Entry description | | | | `DimAx1` | `string(16)` | Allocation dimension 1 code | | | | `DimAx2` | `string(16)` | Allocation dimension 2 code | | | | `DimAx3` | `string(16)` | Allocation dimension 3 code | | | | `DimAx4` | `string(16)` | Allocation dimension 4 code | | | | `DimAx5` | `string(16)` | Allocation dimension 5 code | | | | `EntryDate` | `datetime` | Entry date | | | | `EntryNo` | `int32` | Journal entry number | | | | `InvoiceId` | `string(12)` | Invoice number | | | | `JournalId` | `string(6)` | Journal code | | | | `Modified` | `datetime` | Date modified | | | | `Omschrijving` | `string(50)` | Description | | | | `Period` | `int32` | Period Number | | | | `SeqNo` | `int32` | Journal entry sequence number | | | | `Type` | `string(100)` | Account type | | | | `UnitId` | `int32` | Administration | | | | `VatAmt` | `decimal` | VAT amount | | | | `VatCode` | `string(3)` | VAT code | | | | `VoucherDate` | `datetime` | Document date | | | | `VoucherNo` | `string(32)` | Document number | | | | `Year` | `int32` | Year | | |