# Profit_Transactions_Allocated: Profit Transactions Allocated ## Documentation Profit_Transactions_Allocated - Name: `Profit_Transactions_Allocated` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: Profit Transactions Allocated ## 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` | Account number | | | | `AmtCredit` | `decimal` | Credit amount | | | | `AmtDebit` | `decimal` | Debit amount | | | | `Collect_On` | `string` | Control account type | | | | `Created` | `datetime` | Date added | | | | `Description` | `string` | Entry description | | | | `DimAx1` | `string` | Allocation dimension 1 code | | | | `DimAx2` | `string` | Allocation dimension 2 code | | | | `DimAx3` | `string` | Allocation dimension 3 code | | | | `DimAx4` | `string` | Allocation dimension 4 code | | | | `DimAx5` | `string` | Allocation dimension 5 code | | | | `EntryDate` | `datetime` | Entry date | | | | `EntryNo` | `int32` | Journal entry number | | | | `InvoiceId` | `string` | Invoice number | | | | `JournalId` | `string` | Journal code | | | | `Modified` | `datetime` | Date modified | | | | `Omschrijving` | `string` | Description | | | | `Period` | `int32` | Period Number | | | | `SeqNo` | `int32` | Journal entry sequence number | | | | `Type` | `string` | Account type | | | | `UnitId` | `int32` | Administration | | | | `VatAmt` | `decimal` | VAT amount | | | | `VatCode` | `string` | VAT code | | | | `VoucherDate` | `datetime` | Document date | | | | `VoucherNo` | `string` | Document number | | | | `Year` | `int32` | Year | | |