# Profit_Composition: Profit Composition ## Documentation Profit_Composition - Name: `Profit_Composition` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Profit Composition - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Profit_Composition` - Insert Service URL (OData-specific): `/connectors/Profit_Composition` - Update Service URL (OData-specific): `/connectors/Profit_Composition` - Delete Service URL (OData-specific): `/connectors/Profit_Composition` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Profit_Composition` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AllwaysActive` | `boolean` | Mandatory component | | | | `Artikelgroep` | `string(15)` | Item group | | | | `Blocked` | `boolean` | Blocked | | | | `CompositionId` | `string(40)` | Item code | | | | `CompUnique` | `boolean` | Unique components | | | | `CompVar` | `boolean` | Variable composition | | | | `CompXpl` | `string(20)` | Composition type code | | | | `CreateDate` | `datetime` | Created on | | | | `CreateOrderLines` | `boolean` | Generate order lines | | | | `Description` | `string(100)` | Description | | | | `ItemCode` | `string(40)` | Item code | | | | `ItemType` | `string(100)` | Component item type | | | | `ModifiedDate` | `datetime` | Modified on | | | | `PresentationSeqno` | `int32` | Presentation order | | | | `Quantity` | `decimal` | Quantity | | | | `UnitId` | `string(15)` | Base unit | | | | `UnitId2` | `string(15)` | Unit | | |