Visma.net Financials API Data Model

COMPANY_CODE

string

☐

Partition to retrieve data from.

orderNbr

string

☑

Identifies the Purchase Order

account_description

string

Account Description

☐

Name of item/description

account_number

string

Account Number

☐

Number of item

account_type

string

Account Type

☐

active

boolean

Active

☐

Active > The status of the identifier.

alternateId

string

Alternate ID

☐

Alternate ID > The alternate ID used for this stock item-subitem pair by the supplier.

amount

double

Amount

☐

Amount > The amount calculated (after the discount has been taken) for the item.

branch_name_1

string

☐

Click the magnifier. > The name.

branch_name

string

Branch Name

☐

Click the magnifier. > The name.

branch_number_1

string

☐

Click the magnifier. > The identifier.

branch_number

string

Branch Number

☐

Click the magnifier. > The identifier.

canceled

boolean

Canceled

☐

Cancelled > A check box that indicates (if selected) that this line of the purchase order has been cancelled.

COMPANY_CODE

string(30)

Company Code

☑

Partition code, segmenting the data.

COMPANY_NAME

string(240)

Company Name

☑

Name of the partition.

completed

boolean

Completed

☐

Completed > A check box that indicates (if selected) that the purchasing of the item requested by this line of the purchase order has been completed.

completeOn

double

☐

Complete on (%) > The minimum percentage of the ordered quantity for the stock item that must be received to complete the purchase order line (gets the default value from the Threshold receipt (%) setting of the supplier in the (AP303000) window).

controlTotal

double

Total for Control

☐

The top part > Control total > The order's total amount (including VAT), which you must enter manually when you attempt to save the order with the Balanced status.

controlTotalInBaseCurrency

double

☐

The top part > View base > A button that recalculates the Control total to your base currency if the amount on the purchase order is in another currency then base currency. When you click the button, the button toggles to View currency.

currency

string

Currency

☐

The top part > Currency > The currency the purchase order will be paid in.

date

datetime

Date

☐

Mandatory field: The top part > Date* > The date when the purchase order was created.

description_1

string

☐

The top part > Description > A brief description of the purchase order.

description

string

Description

☐

Description > The description of the identifier.

discountAmount

double

☐

Discount amount > If the Supplier customer discounts functionality is enabled in the Enable/disable functionalities (CS100000) window, the amount of the discount that has been specified manually or calculated based on the discount percent entered manually.

discountCode_description

string

Discount Code Description

☐

Name of item/description

discountCode_number

string

Discount Code Number

☐

Number of item

discountPercent

double

Discount Percent

☐

Discount percent > If the Supplier customer discounts functionality is enabled in the Enable/disable functionalities (CS100000) window, the percent of the discount that has been entered manually or calculated based on the discount amount entered manually for this line item.

dontEmail

boolean

Don't Email

☐

Other information > Do not email > A check box that indicates (if selected) indicates that the purchase order should not be emailed.

dontPrint

boolean

Don't Print

☐

Other information > Do not print > A check box that indicates (if selected) that the current purchase order should not be printed.

emailed

boolean

Emailed

☐

Other information > Emailed > A check box that indicates (if selected) indicates that the current purchase order was emailed.

errorInfo_1

string

☐

errorInfo

string

Error Message

☐

exchangeRate

double

Exchange Rate

☐

extCost

double

☐

Ext. cost > The extended cost of the item, which is the unit cost multiplied by the quantity.

fobPoint

string

☐

Delivery instructions tab > The Delivery instructions section > FOB point > The FOB point where the title of goods (listed on this purchase order) is transferred from the supplier to the company.

hold

boolean

Hold

☐

The top part > Hold > A check box that you select to give the purchase order the On hold status.

inventory_description

string

Inventory Description

☐

Name of item/description

inventory_number

string

Inventory Number

☐

Number of item

lastModifiedDateTime_1

datetime

☐

System generated information.

lastModifiedDateTime

datetime

Last Modified

☐

System generated information.

lineDescription

string

Line Description

☐

A description of the order line, which is copied from the item's description.

lineNbr

int32

☐

The line number

lineTotal

double

Line Total

☐

The top part > Line total > The total sum of the Extended amount entries for all lines in the current purchase order. This value is calculated by the system and users cannot manually change it.

lineTotalInBaseCurrency

double

☐

The top part > View base > A button that recalculates the Line total to your base currency if the amount on the purchase order is in another currency then base currency. When you click the button, the button toggles to View currency.

lineType

string

Line Type

☐

Line type > The type of the order line, which can be one of the following options: Goods for inventory, Non-stock, Service, Freight, Good for sales order, Non-stock for drop-ship, Drop-ship, Goods for RP, Description.

location_id

int32

Location ID

☐

Click the magnifier > The identifier

location_name

string

Location Name

☐

Click the magnifier > The displayed name

manualDiscount

boolean

☐

Manual discount > A check box that indicates (if selected) that the discount has been applied manually.

maxReceipt

double

☐

Max. receipt (%) > The maximum quantity of the item, expressed as a percentage of the ordered quantity, that is required for the item to be accepted at the warehouse if the Receipt action is Rejected.

metadata_maxPageSize_1

int64

☐

metadata_maxPageSize

int64

☐

metadata_totalCount_1

int64

☐

metadata_totalCount

int64

Total Count

☐

minReceipt

double

☐

Min. receipt (%) > The minimum quantity of the item, expressed as a percentage of the ordered quantity, that is required for the item to be accepted at the warehouse if the Receipt action is Rejected.

note_1

string

☐

Icon Notes on top of the window > Pop-up window for providing any user-defined text connected to the document.

note

string

Note

☐

Table > Icon Notes > Pop-up window for providing any user-defined text connected to the order.

openBalance

double

Open Balance

☐

Other information > Open amount > The amount of these items that are ordered but not received.

openQuantity

double

☐

Other information > Open Quantity > The difference between the quantities of ordered and received items.

orderNbr

string

Order Number

☐

The top part > Order no. > The unique reference number of the purchase order, which the system assigns based on the number series assigned to purchase orders of this type, as specified in the PO101000 window.

orderNumber

string

Order Number

☐

Order no. > The reference number of the blanket or standard order (for normal orders based on blanket or standard orders).

orderQty

double

Order Quantity

☐

Order qty. > The quantity of the item that has been ordered.

orderTotal

double

Order Total

☐

The Top part > Order total > The total sum for the purchase order, including VAT. This read-only value is the sum of the Line total and VAT total values.

orderTotalInBaseCurrency

double

☐

The top part > View base > A button that recalculates the Order total to your base currency if the amount on the purchase order is in another currency then base currency. When you click the button, the button toggles to View currency.

orderType_1

string

☐

The top part > Type > The type of the purchase order, which can be one of these options: Normal, Drop-ship, Blanket, Default

orderType

string

Order Type

☐

Order type > The order type this order is related to (for normal orders based on blanket or standard orders).

owner_id

string

Owner ID

☐

Click the magnifier > The identifier

owner_name

string

Owner Name

☐

Click the magnifier > The displayed name

paymentRefNbr

string

Payment Reference Number

☐

Other information tab > Prepayment ref. no. > The reference number of the prepayment request linked to this purchase order, if any.

printed

boolean

Printed

☐

Other information > Printed > A check box that indicates (if selected) that the current purchase order was printed.

project_description

string

Project Description

☐

Click on the magnifier. > The description.

project_id

string

Project ID

☐

Click on the magnifier. > The identifier.

projectTask_description

string

Project Task Description

☐

Click on the magnifier. > The description.

projectTask_id

string

Project Task ID

☐

Click on the magnifier. > The identifier.

promised

datetime

Promised

☐

Promised > The date when the item's deliver was promised.

promisedOn

datetime

Promised on

☐

The top part > Delivery date > The date when the supplier promised that the items listed in the order will be received at their destination location.

qtyOnReceipts

double

☐

Qty. on receipts > The quantity of the item that has been received according to all receipts, including the unreleased ones.

receiptAction

string

☐

Receipt action > The action that should be perform when the ordered item is received if its quantity is greater than the Max. receipt value or less than the Min. receipt value calculated based on the line's ordered quantity. Values: Reject, Accept but warn, Accept.

receivedAmt

double

Received Amount

☐

Received amt. > The amount received on this purchase order for this item.

remitAddress_addressId

int32

☐

remitAddress_addressLine1

string

☐

Address 1 > The first line of the customer's/supplier's/company's/employee's contact address.

remitAddress_addressLine2

string

☐

Address 2 > The second line of the address.

remitAddress_addressLine3

string

☐

Address 3 > The third line of the address.

remitAddress_city

string

☐

City > The city.

remitAddress_country_errorInfo

string

☐

remitAddress_country_id

string

☐

Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166.

remitAddress_country_metadata_maxPageSize

int64

☐

remitAddress_country_metadata_totalCount

int64

☐

remitAddress_country_name

string

☐

Mandatory field: Country name* > The complete name of the country.

remitAddress_county_id

string

☐

Click the magnifier > The identifier

remitAddress_county_name

string

☐

Click the magnifier > The displayed name

remitAddress_overrideAddress

boolean

☐

The Supplier info tab > The Supplier address section > Override > A check box that you select to override (that is, to edit ) the default shipping address for the supplier.

remitAddress_postalCode

string

☐

Postcode > The postcode.

remitContact_attention

string

☐

Attention > The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person.

remitContact_contactId

int32

☐

remitContact_email

string

☐

Email > The email address of the customer/supplier/company as a business entity.

remitContact_fax

string

☐

Fax > The fax number.

remitContact_name

string

☐

Name > The legal name of to appear on the documents.

remitContact_overrideContact

boolean

☐

The Supplier information tab > The Supplier contact section > Override > A check box that you select to override (edit) the default contact settings for the supplier.

remitContact_phone1

string

☐

Phone 1 > The default phone number.

remitContact_phone2

string

☐

Phone 2 > An additional phone number.

remitContact_web

string

☐

Web > The website of the company, if one exists.

requested

datetime

Requested

☐

Requested > The date when the item was requested.

requisitionRefNbr

string

☐

Other information tab > Requisition ref. no. > The reference number of the requisition document associated with the purchase order, if any.

salesOrderNbr

string

☐

Other information tab > Sales order no. > The ID of the sales order associated with the purchase order.

salesOrderType

string

☐

Other information tab > Sales order type > The type of the sales order associated with the purchase order.

segmentDescription

string

☐

The Segment values window > The Top part > The description of the segment.

segmentId

int32

Segment ID

☐

The Segment values window > The Top part > The ID of the segment.

segmentValue

string

Segment Value

☐

The Segment values window > The table > The value of the segment, alphanumeric.

segmentValueDescription

string

Segment Value Description

☐

The Segment values window > The table > The description of the segment value.

shippingAddress_addressId

int32

☐

shippingAddress_addressLine1

string

☐

Address 1 > The first line of the customer's/supplier's/company's/employee's contact address.

shippingAddress_addressLine2

string

☐

Address 2 > The second line of the address.

shippingAddress_addressLine3

string

☐

Address 3 > The third line of the address.

shippingAddress_city

string

☐

City > The city.

shippingAddress_country_errorInfo

string

☐

shippingAddress_country_id

string

☐

Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166.

shippingAddress_country_metadata_maxPageSize

int64

☐

shippingAddress_country_metadata_totalCount

int64

☐

shippingAddress_country_name

string

☐

Mandatory field: Country name* > The complete name of the country.

shippingAddress_county_id

string

☐

Click the magnifier > The identifier

shippingAddress_county_name

string

☐

Click the magnifier > The displayed name

shippingAddress_overrideAddress

boolean

☐

The Supplier info tab > The Supplier address section > Override > A check box that you select to override (that is, to edit ) the default shipping address for the supplier.

shippingAddress_postalCode

string

☐

Postcode > The postcode.

shippingContact_attention

string

☐

Attention > The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person.

shippingContact_contactId

int32

☐

shippingContact_email

string

☐

Email > The email address of the customer/supplier/company as a business entity.

shippingContact_fax

string

☐

Fax > The fax number.

shippingContact_name

string

☐

Name > The legal name of to appear on the documents.

shippingContact_overrideContact

boolean

☐

The Supplier information tab > The Supplier contact section > Override > A check box that you select to override (edit) the default contact settings for the supplier.

shippingContact_phone1

string

☐

Phone 1 > The default phone number.

shippingContact_phone2

string

☐

Phone 2 > An additional phone number.

shippingContact_web

string

☐

Web > The website of the company, if one exists.

shippingDestinationType

string

☐

Shipping instructions tab > The Delivery address section > Shipping destination type > The type of the shipping destination, which is one of the following options: Branch location (meaning a branch of your company), Customer, Supplier, and Warehouse.

shippingLocation_id

int32

Shipping Location ID

☐

Click the magnifier > The identifier

shippingLocation_name

string

Shipping Location Name

☐

Click the magnifier > The displayed name

shipTerms

string

☐

Delivery instructions tab > The Delivery instructions section > Shipping terms > The shipping terms for the purchase order.

shipTo_internalId

int32

☐

shipTo_name

string

☐

The name of the particular destination of the selected type.

shipTo_number

string

☐

The identifier of the particular destination of the selected type.

shipVia

string

Ship Via

☐

Delivery instructions tab > The Delivery instructions section > Ship via > The carrier selected to ship the goods for the purchase order.

status

string

Status

☐

The top part > Status > The system-generated status of the purchase order, which can be one of the following options: On hold, Open, Pending approval, Rejected, Pending printing, Pending e-mail, Closed, Cancelled.

subaccountId

int32

☐

SubID > The identifier of the subaccount.

subaccountNumber

string

☐

Mandatory field: Subaccount* > The subaccount number. Format 9-XX.

supplier_internalId

int32

Supplier Internal ID

☐

supplier_name

string

Supplier Name

☐

The name of the particular destination of the selected type.

supplier_number

string

Supplier Number

☐

The identifier of the particular destination of the selected type.

supplierRef

string

Supplier Reference

☐

The top part > Supplier ref. > The reference number of the supplier document related to this purchase order.

supplierVatZone_defaultTaxCategory_description

string

☐

Name of item/description

supplierVatZone_defaultTaxCategory_number

string

☐

Number of item

supplierVatZone_defaultVatCategory

string

☐

Click the magnifier. The Default VAT category for the VAT zone of the supplier, which is specified in the AP303000 window.

supplierVatZone_description

string

☐

Click the magnifier. The description for the VAT zone of the supplier, which is specified in the AP303000 window.

supplierVatZone_errorInfo

string

☐

supplierVatZone_id

string

☐

Click the magnifier. The identifier for the VAT zone of the supplier, which is specified in the AP303000 window.

supplierVatZone_metadata_maxPageSize

int64

☐

supplierVatZone_metadata_totalCount

int64

☐

taxCategory_description

string

☐

Name of item/description

taxCategory_number

string

☐

Number of item

taxTotal

double

Tax Total

☐

The Top part > VAT total > The total VAT amount for all lines added to the current purchase order. This value, also calculated by the system, is the sum of the VAT amounts for each line.

taxTotalInBaseCurrency

double

☐

The top part > View base > A button that recalculates the VAT total to your base currency if the amount on the purchase order is in another currency then base currency. When you click the button, the button toggles to View currency.

terms_description

string

Terms Description

☐

Click on the magnifier. > The description.

terms_id

string

Terms ID

☐

Click on the magnifier. > The identifier.

unitCost

double

Unit Cost

☐

Unit cost > The cost per UoM of the stock item.

unitCostInBaseCurrency

double

☐

Background calculation connected with the View base/View currency function in the top part. Changes the values in Unit cost, Amount, Disc. unit cost and Cost fields.

uom

string

Unit of Measure

☐

UoM > The unit of measure (UoM) in which the quantity of the item is specified.

vatExemptTotal

double

VAT Exempt Total

☐

The Top part > VAT exempt total > The document total that is exempt from VAT. This total is calculated as the taxable amount for the VAT with the Include in VAT exempt total check box selected in the TX205000 window.

vatExemptTotalInBaseCurrency

double

☐

The top part > View base > A button that recalculates the VAT exempt total to your base currency if the amount on the purchase order is in another currency then base currency. When you click the button, the button toggles to View currency.

warehouse_description_1

string

☐

Click on the magnifier. > The description.

warehouse_description

string

Warehouse Description

☐

Click on the magnifier. > The description.

warehouse_id_1

string

☐

Click on the magnifier. > The identifier.

warehouse_id

string

Warehouse ID

☐

Click on the magnifier. > The identifier.

workgroupID

int32

☐

Other information tab > Work group ID > The work group to which the purchase order was assigned for processing.