# BasicSalesOrdersByTypeOrderTypeOrderNumber: Visma.net Financials Basic Sales Orders by Type Order Type Order Number Get a specific type of Order Data for a single Sales Order Basic. OBS: End of life March 31 2026. REPLACED BY v3 ENDPOINT. SEE https://salesorder.visma.net/swagger/index.html - Catalog: `VismaNet` - Schema: `SalesOrderBasic` - Label: Basic Sales Orders by Type Order Type Order Number This is a read-only table function. The Visma.net Financials API may not support changing the data or the Invantive UniversalSQL driver for Visma.net Financials does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Visma.net Financials API. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `BasicSalesOrdersByTypeOrderTypeOrderNumber`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `orderNbr` | `` | ☑ | | Identifies the Sales Order Number | | `orderType` | `` | ☑ | | Identifies the Sales Order Type | ## Columns of Table Function The columns of the table function `BasicSalesOrdersByTypeOrderTypeOrderNumber` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `branchNumber_name` | `varchar2` | Branch Name | ☐ | Click the magnifier. > The name. | | `branchNumber_number` | `varchar2` | Branch Number | ☐ | Click the magnifier. > The identifier. | | `COMPANY_CODE` | `varchar2(30)` | Company Code | ☑ | Partition code, segmenting the data. | | `COMPANY_NAME` | `varchar2(240)` | Company Name | ☑ | Name of the partition. | | `contactId` | `int32` | Contact ID | ☐ | The top part > Contact > The contact person of the customer. | | `currency` | `varchar2` | Currency | ☐ | The top part > Currency > The currency of the document. | | `customer_internalId` | `int32` | Customer Internal ID | ☐ | | | `customer_name` | `varchar2` | Customer Name | ☐ | The name of the particular destination of the selected type. | | `customer_number` | `varchar2` | Customer Number | ☐ | The identifier of the particular destination of the selected type. | | `customerOrder` | `varchar2` | Customer Order | ☐ | The top part > Customer order > The reference number of the original customer document that the sales order is based on. | | `customerRefNo` | `varchar2` | Customer Reference Number | ☐ | The top part > External reference > The reference number of the sales order in a third-party application if Visma.net Financials is integrated with such an application and imports the sales orders from it. | | `date` | `datetime` | Date | ☐ | Mandatory field: The top part > Date* > The date of the document. | | `description` | `varchar2` | Description | ☐ | The top part > Description > A brief description of the document. | | `discountTotal` | `double` | Discount Total | ☐ | | | `discountTotalInBaseCurrency` | `double` | | ☐ | | | `errorInfo` | `varchar2` | Error Message | ☐ | | | `exchangeRate` | `double` | Exchange Rate | ☐ | | | `hold` | `char` | Hold | ☐ | The top part > Hold > A check box that you select if the document is on hold and should not be processed further at this time. | | `lastModifiedDateTime` | `datetime` | Last Modified | ☐ | Background information collected from the system. | | `location_countryId` | `varchar2` | Location Country ID | ☐ | Location*. | | `location_id` | `varchar2` | Location ID | ☐ | Click the magnifier > The identifier | | `location_name` | `varchar2` | Location Name | ☐ | Click the magnifier > The displayed name | | `metadata_maxPageSize` | `int64` | Metadata Max Pagesize | ☐ | | | `metadata_totalCount` | `int64` | Total Count | ☐ | | | `note` | `varchar2` | Note | ☐ | Icon Notes on top of the window > Pop-up window for providing any user-defined text connected to the order. | | `orderNo` | `varchar2` | Order Number | ☐ | The top part > Order no.: > The reference number of the document. | | `orderTotal` | `double` | Order Total | ☐ | The top part > Order total > The total amount of the document, which is calculated as follows: Line Total + Misc.Charges + Freight + Premium Freight – Discount Total+ Tax Total | | `orderTotalInBaseCurrency` | `double` | | ☐ | | | `orderType` | `varchar2` | Order Type | ☐ | Mandatory field: The top part > Order type > The type of the document, which is one of the predefined order types or a custom order type created by using the (SO201000) window. | | `requestOn` | `datetime` | Request On | ☐ | Mandatory field: The top part > Requested on > The date when the customer wants to receive the goods; this date provides the default values for the Requested on dates for order lines. | | `status` | `varchar2` | Status | ☐ | The top part > Status > The status of the document, which can be one of the following options: On hold, Credit hold, Pending aååroval, Rejected, Open, Cancelled, Shipping, Back order, Invoiced, Completed. | | `taxTotal` | `double` | Tax Total | ☐ | The top part > VAT total > The total amount of tax paid on the document. | | `taxTotalInBaseCurrency` | `double` | | ☐ | | | `vatExemptTotal` | `double` | VAT Exempt Total | ☐ | The top part > VAT exempt total > The document total that is exempt from VAT. | | `vatExemptTotalInBaseCurrency` | `double` | | ☐ | | | `vatTaxableTotal` | `double` | VAT Taxable Total | ☐ | The top part > VAT taxable total > The document total that is subject to VAT. | | `vatTaxableTotalInBaseCurrency` | `double` | | ☐ | |