# Profit_Transactions: Profit Transactions ## Documentation Profit_Transactions - Name: `Profit_Transactions` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Profit Transactions - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Profit_Transactions` - Insert Service URL (OData-specific): `/connectors/Profit_Transactions` - Update Service URL (OData-specific): `/connectors/Profit_Transactions` - Delete Service URL (OData-specific): `/connectors/Profit_Transactions` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Profit_Transactions` 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 | | | | `Created` | `datetime` | Date added | | | | `Description` | `string(120)` | Entry description | | | | `EntryDate` | `datetime` | Entry date | | | | `EntryNo` | `int32` | Journal entry number | | | | `InvoiceId` | `string(12)` | Invoice number | | | | `JournalId` | `string(6)` | Journal code | | | | `Modified` | `datetime` | Date modified | | | | `Period` | `int32` | Period Number | | | | `SeqNo` | `int32` | Journal entry sequence number | | | | `UnitId` | `int32` | Administration | | | | `VatAmt` | `decimal` | VAT amount | | | | `VatCode` | `string(3)` | VAT code | | | | `VoucherDate` | `datetime` | Document date | | | | `VoucherNo` | `string(32)` | Document number | | | | `Year` | `int32` | Year | | |