# Profit_Subscriptions: Profit Subscriptions ## Documentation Profit_Subscriptions - Name: `Profit_Subscriptions` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Profit Subscriptions - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Profit_Subscriptions` - Insert Service URL (OData-specific): `/connectors/Profit_Subscriptions` - Update Service URL (OData-specific): `/connectors/Profit_Subscriptions` - Delete Service URL (OData-specific): `/connectors/Profit_Subscriptions` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Profit_Subscriptions` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CreateDate` | `datetime` | Created on | | | | `DateEnd` | `datetime` | End Date | | | | `DateEndSub` | `datetime` | Subscription end date | | | | `DateStart` | `datetime` | Start date | | | | `DateStartSub` | `datetime` | Subscription start date | | | | `DebtorId` | `string(16)` | Sales relation | | | | `Indentity` | `int32` | Line number | | | | `InvoicesUntil` | `datetime` | Invoiced up to | | | | `Itemcode` | `string(40)` | Item code | | | | `ItemType` | `string(20)` | Item type code | | | | `ModifiedDate` | `datetime` | Modified on | | | | `OriginalPrice` | `decimal` | Original price base currency | | | | `PresentationSeqno` | `int32` | Presentation order | | | | `ProjectId` | `string(15)` | Project | | | | `Quantity` | `decimal` | Quantity | | | | `SalesAmount` | `decimal` | Sales amount base currency | | | | `SalesDiscount` | `decimal` | Sales discount amount base currency | | | | `SubscriptionNr` | `int32` | Subscription number | | | | `UnitIdFin` | `int32` | Administration | | | | `ValueIntIdSu` | `string(20)` | Subscription type code | | |