# Profit_SalesorderLines: Sales Order Lines ## Documentation Profit_SalesorderLines - Name: `Profit_SalesorderLines` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Sales Order Lines - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Profit_SalesorderLines` - Insert Service URL (OData-specific): `/connectors/Profit_SalesorderLines` - Update Service URL (OData-specific): `/connectors/Profit_SalesorderLines` - Delete Service URL (OData-specific): `/connectors/Profit_SalesorderLines` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Profit_SalesorderLines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AmtRowDiscount` | `decimal` | Line discount amount | | | | `AmtTotal` | `decimal` | Line amount | | | | `CreateDate` | `datetime` | Created on | | | | `CurrencyId` | `string(3)` | Currency | | | | `CustomerReference` | `string(100)` | Assignment number/reference | | | | `DebtorId` | `string(16)` | Sales relation | | | | `Description` | `string(255)` | Description | | | | `ItemCodeId` | `string(40)` | Item code | | | | `ItemTypeCode` | `string(20)` | Item type code | | | | `LineGuid` | `string(38)` | Line GUID | | | | `LineStatusCode` | `string(20)` | Line status code | | | | `ModifiedDate` | `datetime` | Modified on | | | | `OrderDate` | `datetime` | Date | | | | `OrderNumber` | `string(12)` | Order number | | | | `PiecePerUnit` | `decimal` | Number of units | | | | `PriceNet` | `decimal` | Net price | | | | `PricePerUnit` | `decimal` | Price per unit | | | | `SeqNo` | `int32` | Sequence number | | | | `Status` | `string(100)` | Status | | | | `UnitId` | `string(15)` | Unit | | |