Navigation: Catalog: VismaNet > Schemas > Schema: Customer > Tables

CustomerSalesOrderBasicLineAttachmentsByCustomerCode: Visma.net Financials Customer Sales Order Line Attachments by Customer Code

Get a range of SO Orders Basic of a specific customer

Catalog: VismaNet

Schema: Customer

Label: Customer Sales Order Line Attachments by Customer Code

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 CustomerSalesOrderBasicLineAttachmentsByCustomerCode. 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	Documentation
customerCd	string	☑
greaterThanValue	string	☐	Filter on Order no. greater than value.
lastModifiedDateTime	string	☐	This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present.Accepted format:* ```yyyy-MM-dd```* ```yyyy-MM-dd HH:mm:ss```* ```yyyy-MM-dd HH:mm:ss.FFF```* ```yyyy-MM-ddTHH:mm:ss```* ```yyyy-MM-ddTHH:mm:ss.FFF```_Note:_ __LastModifiedDateTime__ and __LastModifiedDateTimeCondition__ are __mutually inclusive__.
lastModifiedDateTimeCondition	string	☐	This value represents the condition to be applied when retrieving records.Accepted values (without the single quotes):* '>' for greater than* '<' for less than* '>=' for greater than or equal* '<=' for less than or equal_Note:_ __LastModifiedDateTime__ and __LastModifiedDateTimeCondition__ are __mutually inclusive__.
orderBy	string	☐	This field has been deprecated and will be removed in future versions. The OrderBy parameter has no effect on the result.
orderType	string	☐	Filter by Order type.
showNotes	boolean	☐	Set to true to include notes.
status	string	☐	Select to filter on status on order. (Values: Open, Hold, CreditHold, Completed, Cancelled, BackOrder, Shipping, Invoiced, PendingApproval, Voided)

Columns of Table Function

The columns of the table function CustomerSalesOrderBasicLineAttachmentsByCustomerCode are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required	Documentation
branchNumber_name_2	string	Branch Number Name 2	☐	Click the magnifier. > The name.
branchNumber_name	string	Branch Name	☐	Click the magnifier. > The name.
branchNumber_number_2	string	Branch Number 2	☐	Click the magnifier. > The identifier.
branchNumber_number	string	Branch Number	☐	Click the magnifier. > The identifier.
COMPANY_CODE	string(30)	Company Code	☑	Partition code, segmenting the data.
COMPANY_NAME	string(240)	Company Name	☑	Name of the partition.
contactId	int32	Contact ID	☐	The top part > Contact > The contact person of the customer.
currency	string	Currency	☐	The top part > Currency > The currency of the document.
customer_internalId	int32	Customer Internal ID	☐
customer_name	string	Customer Name	☐	The name of the particular destination of the selected type.
customer_number	string	Customer Number	☐	The identifier of the particular destination of the selected type.
customerOrder	string	Customer Order	☐	The top part > Customer order > The reference number of the original customer document that the sales order is based on.
customerRefNo	string	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	string	Description	☐	The top part > Description > A brief description of the document.
discountAmount	double	{res:itgen_vnet_discountamount}	☐	Document details tab > Discount amount > The amount of the line-level discount that has been applied manually or automatically to this line item (if the item is not a free item).
discountCode	string	Discount Code	☐	Mandatory field: Document details tab > Discount details tab > Discount code* > The code of the discount that has been applied to this line.
discountPercent	double	Discount Percent	☐	Document details tab > Discount percent > The percent of the line-level discount that has been applied manually or automatically to this line item (if the item is not a free item).
discountTotal	double	Discount Total	☐
discountTotalInBaseCurrency	double	{res:itgen_vnet_discounttotalinbasecurrency}	☐
discUnitPrice	double	{res:itgen_vnet_discunitprice}	☐	Document details tab > Disc. unit price > The unit price, which has been recalculated after the application of discounts.
errorInfo	string	Error Message	☐
exchangeRate	double	Exchange Rate	☐
extPrice	double	Extended Price	☐	Document details tab > Extended cost > The extended price, which is the unit price multiplied by the quantity.
hold	boolean	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.
id	guid	ID	☐	The ID of the attachment
inventory_description	string	Inventory Description	☐	Name of item/description
inventory_number	string	Inventory Number	☐	Number of item
lastModifiedDateTime	datetime	Last Modified	☐	Background information collected from the system.
lineDescription	string	Line Description	☐	Document details tab > Line description > The description of the unit.
lineNbr	int32	{res:itgen_vnet_linenbr}	☐	Document details tab > Line no. > The line number of the document.
location_countryId	string	Location Country ID	☐	Location*.
location_id	string	Location ID	☐	Click the magnifier > The identifier
location_name	string	Location Name	☐	Click the magnifier > The displayed name
manualDiscount	boolean	Manual Discount	☐	Document details tab > Manual discount > A check box that indicates (if selected) that the discount has been applied manually.
metadata_maxPageSize	int64	Metadata Max Pagesize	☐
metadata_totalCount	int64	Total Count	☐
name	string	Name	☐	The name of the attachment.
note_2	string	Note 2	☐	Icon Notes on top of the window > Pop-up window for providing any user-defined text connected to the order.
note	string	Note	☐	Tables in tab > Icon Notes > Pop-up window for providing any user-defined text connected to the order.
openQty	double	Open Quantity	☐	Document details tab > Open qty. > The quantity of the item to be shipped; that is, the total quantity minus the quantity shipped according to closed shipment documents.
orderNo	string	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	{res:itgen_vnet_ordertotalinbasecurrency}	☐
orderType	string	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.
qtyOnShipments	double	{res:itgen_vnet_qtyonshipments}	☐	Document details tab > Qty. on shipments > A read-only column that displays the quantity of the stock item being prepared for shipment and already shipped for this order.
quantity	double	Quantity	☐	Document details tab > Quantity > The quantity of the item sold, measured in the UoM.
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.
revision	int32	Revision	☐	The version of the attachment.
sortOrder	int32	{res:itgen_vnet_sortorder}	☐	Document details tab > Line order > The order number of the document line. The system regenerates this number automatically when you reorder the lines in the table.
status	string	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	{res:itgen_vnet_taxtotalinbasecurrency}	☐
unbilledAmount	double	{res:itgen_vnet_unbilledamount}	☐	Document details tab > Amount not yet invoiced > The amount of cancelled shipments and cancelled remainders.
unitCost	double	Unit Cost	☐	Document details tab > Unit Cost > The cost of the unit on the sales order.
unitPrice	double	{res:itgen_vnet_unitprice}	☐	Document details tab > Unit price > The price of the unit on the sales order.
unitPriceInBaseCurrency	double	{res:itgen_vnet_unitpriceinbasecurrency}	☐
uom	string	Unit of Measure	☐	Mandatory field: Document details tab > UoM* > The unit of measure (UoM) used for the item with this item ID.
vatExemptTotal	double	VAT Exempt Total	☐	The top part > VAT exempt total > The document total that is exempt from VAT.
vatExemptTotalInBaseCurrency	double	{res:itgen_vnet_vatexempttotalinbasecurrency}	☐
vatTaxableTotal	double	VAT Taxable Total	☐	The top part > VAT taxable total > The document total that is subject to VAT.
vatTaxableTotalInBaseCurrency	double	{res:itgen_vnet_vattaxabletotalinbasecurrency}	☐
warehouse_description	string	Warehouse Description	☐	Click on the magnifier. > The description.
warehouse_id	string	Warehouse ID	☐	Click on the magnifier. > The identifier.

23-06-2025 19:16 Version 24.1.116-BETA+5455

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

Please enable JavaScript to view this site.

Visma.net Financials API Data Model

CustomerSalesOrderBasicLineAttachmentsByCustomerCode: Visma.net Financials Customer Sales Order Line Attachments by Customer Code

Parameters of Table Function

Columns of Table Function

Important Safety and Usage Information