Customer document

This table contains one row for each archived customer document, according to the Document copies field in the Company information table.

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL nameCsDocThe table name in the database.
API identifiercustomerDocumentThe API identifier used in GraphQL.
Table no.358The table number in the data model.

The following fields exist in this table:

Address line 1

The street address, PO Box address, c/o address and/or attention.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAd1The database field name.
API identifieraddressLine1The API identifier used in GraphQL.
Number15539 

Address line 2

The street address, PO Box address, c/o address and/or attention.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAd2The database field name.
API identifieraddressLine2The API identifier used in GraphQL.
Number15540 

Address line 3

The street address, PO Box address, c/o address and/or attention.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAd3The database field name.
API identifieraddressLine3The API identifier used in GraphQL.
Number15541 

Address line 4

The street address, PO Box address, c/o address and/or attention.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAd4The database field name.
API identifieraddressLine4The API identifier used in GraphQL.
Number15542 

Amount

The amount due in the domestic currency.

Corresponds to the @GiroAmount macro function on the form.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAmThe database field name.
API identifieramountDomesticThe API identifier used in GraphQL.
Number15879 

Amount in currency

The amount due in the actual currency.

Corresponds to the @GiroAmountInCurrency macro function on the form.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCurAmThe database field name.
API identifieramountInCurrencyThe API identifier used in GraphQL.
Number15878 

Appointment flow balance

The balance of all open appointments for the associate, i.e. all appointments which are not yet transferred to an order.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAgrChBalThe database field name.
API identifierappointmentFlowBalanceThe API identifier used in GraphQL.
Number15648 

Associate no.

A unique number identifying the associate.

Tip:
On start-up you should create an associate manually, for example with the associate number 1000 or 10000 depending on the number of digits you want to use in the employee number. This means you can use the same number as the employee number and associate number. The employee then only needs to use an employee number when an associate number is used in CRM.
Tip:
When converting from another system, you should use customer numbers and supplier numbers as associate numbers. This makes it easier to link to contacts.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameActNoThe database field name.
API identifierassociateNoThe API identifier used in GraphQL.
Number15537 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateAssociate
  • Associate no.
ParticipantParticipant
  • Associate no.
Associate referenceAssociateReference
  • Associate no.

Associate processing

Settings defining the behaviour of the associate.

A look-up opens the dialog box where you can see the following check boxes and options:

Selection

Exclude
When set, the corresponding row in the Associate table will no longer be displayed in the drop-down list of related lookups. The purpose of this flag is to allow the external employees to be distinguished from internal users.

Bank account

Do not read bank account when creating payments
The accounts for payments are not read from the external system.

Organisation no.

Do not read organisation no. during input
When reading an incoming e-document in the Visma XML format, a lookup is done on the Organisation no. to try to find the correct customer/supplier no. in the internal system. If you have several associates with the same Organisation no., you can block out the once you do not want to have associated with the organisation no. If all associate have option Do not read organisation no. during input selected in the Associate table, a second lookup will be done on the EAN location code.
VAT registered
The associate is in the VAT register. Will be updated automatically if qualified, when running the Update directly from Visma Bizweb processing.

Visma Bizweb

Exclude from mass update
When selected, the associate will be excluded from update when running the Update directly from Visma Bizweb processing.

EAN Location usage

Customer
When writing an e-document and check box Use EAN Location Code is selected in the EDI processing field in the Company information table, the EAN loc. code field for the customer (EANLocCd) can be found by adding the customer no. to the customer number tag of the associate. If XML Compliant format is selected in the EDI processing field in the Company information table, the Ord_CustNo tag will be used, if the XML Compliant format is not selected it will be the Ord.CustNo tag.

If EAN location code cannot be obtained an error message will be added to the EDI error message table.

Customer is blocked
When reading an incoming e-document in the Visma XML format, a lookup is done on the EAN loc. code field to try to find the correct customer no. in the internal system. If you have several associates with the same EAN location code, you can block out the once you do not want to have associated with the EAN location code. However, you will always try to first do a lookup on the Organisation no. field to try to find the corresponding internal customer no. If you instead want to use the EAN loc. code field, you can block the reading of the Organisation no. field by selecting Do not read organisation no. during input in the associate processing dialog.
Invoice customer
When writing an e-document and check box Use EAN Location Code is selected in the EDI processing field in the Company information table, the EAN loc. code field for the associate being invoiced EANInvoNo can be found by adding the customer no. to the invoice customer number tag of the associate. If XML Compliant format is selected in the EDI processing field in the Company information table, the Ord_InvoCust tag will be used, if the XML Compliant format is not selected it will be the Ord.InvoCust tag.
Invoice customer is blocked
When reading an incoming e-document in the Visma XML format, a lookup is done on the EAN loc. code field to try to find the correct invoice customer no. in the internal system. If you have several associates with the same EAN location code, you can block out the once you do not want to have associated with the EAN location code. However, you will always try to first do a lookup on the Organisation no. field to try to find the corresponding internal invoice customer no. If you instead want to use the EAN loc. code field, you can block the reading of the Organisation no. field by selecting Do not read organisation no. during input in the associate processing dialog.
Deliver to associate
When writing an e-document and check box Use EAN Location Code is selected in the EDI processing field in the Company information table, the EAN loc. code field for the associate being delivered to EANDelAct can be found by adding the customer no. to the deliver customer number tag of the associate. If XML Compliant format is selected in the EDI processing field in the Company information table, the Ord_DelActNo tag will be used, if the XML Compliant format is not selected it will be the Ord.DelActNo tag.
Delivery to associate is blocked
When reading an incoming e-document in the Visma XML format, a lookup is done on the EAN loc. code field to try to find the correct Delivery associate no. If you have serveral associates with the same EAN location code, you can block out the once you do not want to have associated with the EAN location code. However, you will always try to first do a lookup on the Organisation no. field to try to find the corresponding internal Delivery associate no. If you instead want to use the EAN loc. code field, you can block the reading of the Organisation no. field by selecting Do not read organisation no. during input in the associate processing dialog.
Supplier
When writing an e-document and check box Use EAN Location Code is selected in the EDI processing field in the Company information table, the EAN loc. code field for the supplier (EANSupNo) can be found by adding the supplier no. to the supplier number tag of the associate. If XML Compliant format is selected in the EDI processing field in the Company information table, the Ord_SupNo tag will be used, if the XML Compliant format is not selected it will be the Ord_SupNo tag.
Supplier is blocked
When reading an incoming e-document in the Visma XML format, a lookup is done on the EAN loc. code field to try to find the correct supplier no. in the internal system. If you have several associates with the same EAN location code, you can block out the once you do not want to have associated with the EAN location code. However, you will always try to first do a lookup on the Organisation no. field to try to find the corresponding internal supplier no. If you instead want to use the EAN loc. code field, you can block the reading of the Organisation no. field by selecting Do not read organisation no. during input in the associate processing dialog.
Send to associate
When writing an e-document and check box Use EAN Location Code is selected in the EDI processing field in the Company information table, the EAN loc. code field for the associate being sendt to EANShpNo can be found by adding the associate no. to the sendt associate number tag of the associate. If XML Compliant format is selected in the EDI processing field in the Company information table, the Ord_ShpActNo tag will be used, if the XML Compliant format is not selected it will be the Ord.ShpActNo tag.
Send to associate is blocked
When reading an incoming e-document in the Visma XML format, a lookup is done on the EAN loc. code field to try to find the correct ship to associate no. If you have several associates with the same EAN location code, you can block out the once you do not want to have associated with the EAN location code. However, you will always try to first do a lookup on the Organisation no. field to try to find the corresponding internal ship to associate no. If you instead want to use the EAN loc. code field, you can block the reading of the Organisation no. field by selecting Do not read organisation no. during input in the associate processing dialog.
Liaison associate
This check box is currently not in use.
Liaison associate is blocked
This check box is currently not in use.
Liaison associate 2
This check box is currently not in use.
Liaison associate 2 is blocked
This check box is currently not in use.

AutoInvoice

Do not use EAN for PartyIdentification
EAN loc. code field content will not be used for AutoInvoice PartyIdentification.
Specify operator code when sending invoice
When set, the value in AutoInvoice operator no. is used for routing when invoices are sent through Visma.net AutoInvoice. In most cases, it is not recommended or necessary to specify an operator code for invoice, unless there are conflicting routes available in AutoInvoice (meaning it is possible to deliver through more than one external access point) and an override is required.
Note:
This setting is not required for B2C invoicing with operator code.
Exclude e-invoice as route when sending invoice
When set, electronic route will be disregarded when AutoInvoice attempt to deliver the invoice. Meaning that even if the customer is able to receive invoices electronically, the invoice will be delivered as e-mail or printed.
Exclude EU goods stat. no. when sending invoice
When set, value in the EU goods stat. no. field will not be included in the XML invoice.

External processing

No access to delete
The row can not be deleted, even if there are no transactions linked to the row. This check box is intended for use when another program has imported the data and you want to prevent the row being deleted by mistake.
Note:
There are no restrictions on who can select or deselect this check box.
Inactive in external system
The associate is inactive in the external system.
Exclude from Visma Mobile
The associate is excluded from Visma Mobile Sales Order.
Exclude from Visma On Demand
The associate is excluded from Visma On Demand.
Exclude from Master Data Management
Created automatically
This setting is automatically selected when new associate is created from an incoming document.

Document center

Document processor
The value must be updated from Visma Document Center.
Document manager
The value must be updated from Visma Document Center.
Accountant
The value must be updated from Visma Document Center.
E-mail warning
The value must be updated from Visma Document Center.

External user

User in Time Ease
The associate is a Visma TimeEase user. If check box is selected, an x will be shown in the TimeEase user field in the Associate table.
User in Zpider
The associate is a Zpider user.
User in External system 3
The associate is a User in External system 3 user.
User in External system 4
The associate is a User in External system 4 user.

AutoInvoice payment means

Use default for all
The payment information is selected from the customer's location: Domestic customers get Bank account and/or Postal giro, international customers get IBAN. This is the standard behaviour, used for all customers where nothing else is selected.
Use domestic for all
When selected, Bank account and/or Postal giro is used as payment information on all invoices to this customer, also when the customer is international. Use this for customers abroad that cannot handle IBAN. If no bank account is found for the company, the invoice will not be transferred to AutoInvoice.
Use IBAN for all
When selected, IBAN is used as payment information on all invoices to this customer, also when the customer is domestic. Use this for domestic customers that require IBAN for payment. If no IBAN is found for the company, the invoice will not be transferred to AutoInvoice.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate processingInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameActProThe database field name.
API identifierassociateProcessingThe API identifier used in GraphQL.
Number15626 

Auth. responsible

The authorisation official for vouchers.

The authorisation official is suggested when you enter vouchers for the supplier.

The Empl. no. is a unique number identifying one specific Employee.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEmpl. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAttThe database field name.
API identifierapprovalOfficialThe API identifier used in GraphQL.
Number15560 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateApprovalOfficial
  • Auth. responsible

AutoInvoice document ID

A unique identifier that is returned from Visma AutoInvoice, on successfully transferred documents.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainGUIDText (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameMavDocIdThe database field name.
API identifierautoInvoiceDocumentIDThe API identifier used in GraphQL.
Number18567 

AutoInvoice status

The status for Visma AutoInvoice documents.

A look-up in this field gives you the following list of possible values:
0 - Not set
The document was printed without AutoInvoice as document delivery method, or the document delivery method was disregarded by using a different print method (Override to printer, Quick print, Print to PDF, Send e-mail, Design Excel template, Print to Excel, Print to clipboard, Print to file or Only approval). The document is ready to be sent to Visma.net AutoInvoice, unless it has been printed using an XML print form or the Document delivery method = EDI is set.
Note:
The document type 3 - Packing slips is always created with AutoInvoice status = 0 - Not set because of the way the document is processed.
1 - Transferred
The document has been delivered to Visma.net AutoInvoice. This status does not indicate what has happened after Visma.net AutoInvoice received the document. No further processing possible.
2 - Pending
The document is ready to be sent, but has not yet been processed. This status should only appear if the Document copies option Only approval - print later from document archive has been selected.
3 - Failed transfer
An error occurred while sending to Visma.net AutoInvoice. See the EDI error message table for more details. This status could indicate problems logging in to Visma.net AutoInvoice, communication with Visma.net AutoInvoice (firewall etc.) or issues with creating the XML data (corrupt data etc.).
4 - Cannot transfer
Status set when running the Set AutoInvoice status Cannot transfer processing. This status disables sending the document to Visma.net AutoInvoice. The processing is available for documents that have a status other than 1 - Transferred and 4 - Cannot transfer.
5 - Validation failed
This status is only in use if the System information processing setting Test content is selected. This setting is only available if AutoInvoice test is selected. The status indicates that the XML content includes validation errors, according to the PEPPOL BIS format rules. Detailed error message(s) can be found in the AutoInvoice validation error table.
6 - Preparing to send
7 - Sent from AutoInvoice
8 - Unsuccessful delivery
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAutoInvoice statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameMavStatThe database field name.
API identifierautoInvoiceStatusThe API identifier used in GraphQL.
Number18566 

Bank account

The bank account number used when you print completed bank giro forms in connection with reminders, interest notes and payments, or if you use Electronic Funds Transfer.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBank accountText (35)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameBGiroThe database field name.
API identifierbankAccountThe API identifier used in GraphQL.
Number15576 

Bank branch

The bank branch number used in connection with electronic funds transfer. The field must contain details about clearing code, bank code, BLZ, etc., obtained from the supplier.

The field is used for payments using the Telepay format. In some cases, the SWIFT code is also sent, as determined by the receiving bank/country. Your bank or supplier will tell you if you need to include this field. Used by Visma.net AutoPay as Fedwire information on payments to USA.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBank accountText (35)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameBranchThe database field name.
API identifierbankBranchThe API identifier used in GraphQL.
Number15606 

Bank no.

The associate's bank. This value is not in use for payments.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBank no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameBankConThe database field name.
API identifierbankNoThe API identifier used in GraphQL.
Number15640 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
BankBank
  • Bank no.

Buyer

The buyer for the supplier.

The Empl. no. is a unique number identifying one specific Employee.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEmpl. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameBuyerThe database field name.
API identifierbuyerThe API identifier used in GraphQL.
Number15558 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateBuyer
  • Buyer

CID code

The CID code for the document.

Corresponds to the @CID macro function on the form.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCID codeText (30)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCIDThe database field name.
API identifiercidThe API identifier used in GraphQL.
Number15530 

Client responsible account 1

The account for the customer used to accumulate client funds.

You can also define that for ranges of customer numbers in the Account no. series table. If the field is blank, account references in the Company information table are used.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAccount no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameClReAcNoThe database field name.
API identifierclientResponsibleAccountNo1The API identifier used in GraphQL.
Number15631 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountClientResponsibleAccount1
  • Client responsible account 1

Client responsible account 2

The account for the customer used to accumulate client funds.

You can also define that for ranges of customer numbers in the Account no. series table. If the field is blank, account references in the Company information table are used.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAccount no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameClBaAcNoThe database field name.
API identifierclientResponsibleAccountNo2The API identifier used in GraphQL.
Number15632 
Table 6. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountClientResponsibleAccount2
  • Client responsible account 2

Client responsible account 3

The account for the customer used to accumulate client funds.

You can also define that for ranges of customer numbers in the Account no. series table. If the field is blank, account references in the Company information table are used.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAccount no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCl3AcNoThe database field name.
API identifierclientResponsibleAccountNo3The API identifier used in GraphQL.
Number15647 
Table 7. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountClientResponsibleAccount3
  • Client responsible account 3

Contact for

The contact for an entry in the Associate table.

There is no limit to the number of contacts an associate can have. You can join the Associate table to itself using this field to view all contacts for an associate.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLiaActThe database field name.
API identifiercontactForThe API identifier used in GraphQL.
Number15556 
Table 8. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateContactFor
  • Contact for

Country no.

The country of the associate. It is only relevant if the associate's country is different from the default country.

You define default country in the Company information table. The Country no. field is used to enter the country number that applies to the associate.

When the country number is entered, values get updated in the Language no. and Currency no. fields if you have entered this information for the relevant country in the Country table. The values can be changed if required. The country number determines, amongst other things, the parameters to be used for invoicing, reminders and calculation of interest. The field appears in two sets in the order head, and is suggested based of the customer/supplier and the recipient. If required, the country can also be edited out in forms as a part of the address, by retrieving the name of the country (or nationality code) from the Country table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCountry no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCtryThe database field name.
API identifiercountryNoThe API identifier used in GraphQL.
Number15545 
Table 9. Table relations
To tablePurposeFrom columnsTo columnsComments
CountryCountry
  • Country no.

Credit evaluation

Information about the credit worthiness of the customer.

The value is copied to the Customer document table when you create open entry lists.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNameText (80)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrEvalThe database field name.
API identifiercreditEvaluationThe API identifier used in GraphQL.
Number15569 

Credit limit

The amount that the customer (invoice recipient) is allowed to owe the company.

Different responses, depending on the selection in the credit control dialog box in the Company information table, are possible. These include warning messages or the blocking of transactions. The responses are triggered by the following
  • The credit limit is exceeded by the total orders plus d/c ledger balance for the customer.
  • The customer has overdue invoices with a total outstanding amount that is bigger than the setting in the credit limit field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrLmtThe database field name.
API identifiercreditLimitThe API identifier used in GraphQL.
Number15567 

Credit note credit days

Used in payment mediation assumes that there is a check for allowed negative payments in the Accounting processing field in the Company information table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCNtDyThe database field name.
API identifiercreditNoteDueDaysThe API identifier used in GraphQL.
Number15645 

Credit suspension

If you have to suspend a customer's credit, e.g. if they are in breach of their payment obligations, you check the Credit suspension box.

The customer has its credit suspended when you approve reminders for the country in question.

Entering orders

If you have suspended the customer's credit Business NXT will not let you enter orders for the customer, and you have to cancel the credit suspension before you can enter new orders. You can, however, always enter credit notes (as long as you have checked Credit note in the order head before entering the customer number). Control takes place on the basis of the invoice recipient, whether the invoice issuer's customer number is filled in directly or indirectly via the customer number. If you cancel the credit suspension for a customer and the Set credit suspension on open customer orders? check box is selected under the Accounting processing dialog in the Company information table, Business NXT removes the credit suspension for all orders entered for the customer.

Voucher registration

When you run vouchers for a customer whose credit is suspended, you receive a message stating that the customer's credit is suspended, but Business NXT does not block this as the transaction has of course already taken place.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBooleanInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrSuspThe database field name.
API identifiercreditDeniedThe API identifier used in GraphQL.
Number15568 

Currency no.

The currency no for the customer or supplier.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCurrency no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCurThe database field name.
API identifiercurrencyNoThe API identifier used in GraphQL.
Number15571 
Table 10. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency
  • Currency no.

Currency no. 2

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCurrency no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCur2The database field name.
API identifiercurrencyNo2The API identifier used in GraphQL.
Number15650 
Table 11. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency2
  • Currency no. 2

Cust. doc. no.

A unique number identifying the customer document.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
Primary keyYesCust. doc. no.
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCsDocNoThe database field name.
API identifiercustomerDocumentNoThe API identifier used in GraphQL.
Number15528 

Cust. no.

A unique number identifying the customer.

You should place the customer number within the range for account type 1 (customers). You define this range in the Account no. series table. This enables you to avoid entering the account type when entering vouchers.

Note:
You can define a limited number series for customers in the Account no. series table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCust. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCustNoThe database field name.
API identifiercustomerNoThe API identifier used in GraphQL.
Number15554 
Table 12. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateCustomer
  • Cust. no.

Customer doc. proc.

Settings defining the behaviour of the customer document.

A look-up opens the dialog box where you can see the following check boxes and options:
Giro document
The customer document has a giro amount (greater than 0).
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCustomer doc. proc.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCsDProThe database field name.
API identifiercustomerDocumentProcessingThe API identifier used in GraphQL.
Number15536 

Customer options

Settings defining the behaviour of the customer.

A look-up opens the dialog box where you can see the following check boxes and options:

Order

Gross orders
The same check box will be selected in the Order options dialog box, based on the buyer (customer number).
Reserve on save
The same check box will be selected in the Order options dialog box, based on the buyer (customer number).
Reserve within lead time
The same check box will be selected in the Order options dialog box, based on the buyer (customer number).
Batch invoice
When this customer is set as the invoice recipient on an order the order will be suggested to be included in a batch invoice. See Order options domain.
Justify exchange rate
The same check box will be selected in the Order options dialog box, based on the buyer (customer number).
Exempt from invoice fee
The same check box will be selected in the Order options dialog box, based on the invoice recipient (the invoice's customer number).
Accept changes manually
The same check box will be selected in the Order options dialog box, based on the buyer (customer number).
Send confirmations automatically
The customer is sent confirmations for orders received by EDI.
Include all lines on delivery notes
All order lines are included on delivery notes, not only those with the order line status that they are ready for printing on delivery notes.
Pick complete orders
The same check box will be selected in the Order options dialog box, based on the buyer (customer number).
Invoice no. from 'Label'
The same check box will be selected in the Order options dialog box, based on the invoice recipient (the invoice's customer number).
Withdrawal from client bank account
The same check box will be selected in the Order options dialog box, based on the buyer (customer number).
Post client funds
The same check box will be selected in the Order options dialog box, based on the buyer (customer number).
Use client responsibility 2
The same check box will be selected in the Order options dialog box, based on the buyer (customer number).
Use client responsibility 3
The same check box will be selected in the Order options dialog box, based on the buyer (customer number).
Prepayment
You block the order from being processed at a higher status level than the order confirmation. In order for the order to be processed, you must enter a payment against this order in the voucher entry.
Do not move confirmed delivery date to earlier
The confirmed delivery date will not be changed for allocated orders which are to be delivered after the confirmed date. Orders with an earlier date get an updated confirmed delivery date with a confirmed date from the purchase production order when the Confirmed and Sent processings are used. For loose allocations, future orders will not be reserved if this field has not been selected:
  • Reserve by confirmed / sent under Reservation processing in the Company information table
  • Reserve against all orders in the dialog box for the Confirmed and Sent processings. A check is suggested when Reserve by confirmed / sent in Reservation processing in the Company information table is selected.
You can also select Do not move confirmed delivery date to earlier on order:
  • as standard for all orders in the Calculate delivery date field in the Company information table
  • at each individual order in the Order options field in the Order table
Use original exchange rate on credit notes
Use buyer's item ID to find the product
When selected, processing incoming orders will try to identify the product based on the customer's product ID in the XML, first searching Product customer field Customer's product no. followed by Product no. in Product. If not found, the default product search is run.

Accounting

Suggest VAT code
The VAT code and the Turnover class -derived from the Trade area- for the customer is suggested when you register vouchers.
Reminder suggested
No reminders
The customer is exempted from reminders. This can also be done automatically after approval of the last reminder for the country in question, using the After last reminder field in the Country table.
No debt collection
No functionality has been implemented in this field. You can process them further in an external application such as BIG if required.
Private person
The customer is treated as a private customer. This is relevant for the interest rate that is used and whether compound interest is calculated. See the description of the Country table.

Invoicing: When set, the customer will be identified as consumer when invoicing to Visma.net AutoInvoice. This means that if the route is available, the invoice may be sent electronically to the customer's bank for processing. If not available, the invoice will either be sent by e-mail or be printed and sent by mail.

No interest
The customer is exempted from interest computation. This can also be done automatically after approval of the last reminder for the country in question, using the After last reminder field in the Country table.
Foreign payment
You are making a payment transfer to a customer abroad.
No payment
The supplier is not to receive payment.
Use Postgiro for payments - Swedish
This field is used by some EFT systems for Swedish payments. Postgiro is also used with other formats, so you must leave this field unchecked if you are using bank formats other than Swedish ones.
Suspended on voucher
You will not be able to post the voucher lines directly on the customer. You will see the message "Customer xxxxxxx is suspended from direct posting" in the status bar.

Debt collection

To debt collection
This check box is selected when you have run the final reminder and checked the Set debt collection flag after last letter field under Accounting processing in the Company information table, and the customer is sent to debt collection.
Transferred to debt collection
This check box is selected when the customer is sent to debt collection. All vouchers that are registered after the customer has been sent to debt collection are registered as being subject to debt collection and can be sent in a change list to the debt collection company. This applies in particular to payments that have been sent to debt collection.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCustomer optionsInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCustPrefThe database field name.
API identifiercustomerPreferences1The API identifier used in GraphQL.
Number15609 

Direct deb. from date

Set to the current date when the Direct deb. status field is filled out.

Information field internally in Business NXT.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDebFrDtThe database field name.
API identifierdirectDebitingFromDateThe API identifier used in GraphQL.
Number15578 

Direct deb. status

Determines if Direct Debit is used for the customer.

Assigned value 2 or 3 for Direct Debit. Can be done manually, or when importing customer agreements from Visma.net AutoPay.

A look-up in this field gives you the following list of possible values:
1 - Process inquiry
For customers wishing to enter into an agreement on direct debiting.
2 - Agreement w/o notification
In the direct debiting dialog box, which you call up via the processing for direct debiting, there is an option to create new direct debitors. This will send an inquiry to the bank for approval of the associates with direct debiting status 1 and simultaneously change the status to 2.
3 - Agreement with notification
The debitor is accepted by the bank.
4 - Rejected
The debitor is rejected by the bank.
5 - e-Invoice
6 - B2B direct e-mail
7 - e-Invoice and AvtaleGiro
8 - e-Invoice and Vipps
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDirect deb. statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDirDebThe database field name.
API identifierdirectDebitingStatusThe API identifier used in GraphQL.
Number15607 

Direct deb. to date

Set to the current date when importing terminated Direct Debit customer agreements from Visma.net AutoPay.

Information field internally in Business NXT.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDebToDtThe database field name.
API identifierdirectDebitingToDateThe API identifier used in GraphQL.
Number15579 

District

Can be used for groupings.

District texts for different languages can be defined in the Text table. These texts has text type 9.
Note:
If you double-click or press * in this field, you can look up a District in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDistrictInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDistrThe database field name.
API identifierdistrictThe API identifier used in GraphQL.
Number15588 

Doc. date

The document date.

Originates from the Up-to-date from field in the print dialog box to the Reminders or Interest notes report.

Corresponds to the @DocDate macro function on the form.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStDtThe database field name.
API identifierdocumentDateThe API identifier used in GraphQL.
Number15532 

Doc. no.

The reminder no. or interest note no. for the document.

Corresponds to the @ReminderDocumentNo macro function on a Reminder form, or the @InterestNoteNo macro function on an Interest note form.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDocNoThe database field name.
API identifierdocumentNoThe API identifier used in GraphQL.
Number15875 

Doc. type

The type of customer document.

A look-up in this field gives you the following list of possible values:
1 - Reminder
2 - Interest note
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDoc. typeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDocTpThe database field name.
API identifierdocumentTypeThe API identifier used in GraphQL.
Number15529 

Document delivery method 1

How documents are to be sent.

The method is suggested in the order head for the associate.

Order documents

The dialog box contains boxes for each of the relevant document types, that you can check to define required delivery methods. You can send the same document in several different ways by selecting several delivery methods. No documents are sent unless you select at least one of the delivery methods. There is a block against removing all selections in invoices; at least one of the delivery methods must be selected. Print previews of the documents works regardless of which delivery methods have been selected.

Accounting documents

You can send interest notes and reminders as fax and e-mail attachments in the same way as the order documents.

The different delivery methods:
Printout
Printout (print to PDF) is the default value for all documents, so you only need to go into the dialog box if you want a different delivery method for any of the documents. You can define default values for this field via the Edit/Entry rules menu item. If the delivery method field is empty, Printout is still selected for all documents in the dialog box.
E-mail
You can send all order documents via e-mail. A valid e-mail address needs to be entered for the associate. There is no validation in place on value in the e-mail address field.

The name added to the Subject field of the e-mail is taken from the Text table, in the language in which the order/accounting document is entered. Otherwise, the text is obtained from the active language.

EDI
The EDI options are not available for delivery notes and production orders.

EDI documents will only work if you also define the relevant document type in EDI messages.

AutoInvoice
AutoInvoice documents will only work if you have set up Visma AutoInvoice in the Visma AutoInvoice portal and in Business NXT.
A look-up opens the dialog box where you can see the following check boxes and options:

In addition to the document types with the associated delivery methods described above, there are some additional settings.

EDI Settings

Media type

E-media
Print

Postage type

1. class mail
2. class mail

____

Stop before sending e-mail
Used to prevent immediate transmission by e-mail. This means you can edit the e-mail before it is sent to the contact.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDocument delivery method 1Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDocSMtThe database field name.
API identifierdocumentDeliveryMethod1The API identifier used in GraphQL.
Number15621 

Document delivery method 2

How documents are to be sent.

The method is suggested in the order head for the associate.

Order documents

The dialog box contains boxes for each of the relevant document types, that you can check to define required delivery methods. You can send the same document in several different ways by selecting several delivery methods. No documents are sent unless you select at least one of the delivery methods. There is a block against removing all selections in invoices; at least one of the delivery methods must be selected. Print previews of the documents works regardless of which delivery methods have been selected.

Accounting documents

You can send interest notes and reminders as fax and e-mail attachments in the same way as the order documents.

The different delivery methods:
Printout
Printout (print to PDF) is the default value for all documents, so you only need to go into the dialog box if you want a different delivery method for any of the documents. You can define default values for this field via the Edit/Entry rules menu item. If the delivery method field is empty, Printout is still selected for all documents in the dialog box.
E-mail
You can send all order documents via e-mail. A valid e-mail address needs to be entered for the associate. There is no validation in place on value in the e-mail address field.

The name added to the Subject field of the e-mail is taken from the Text table, in the language in which the order/accounting document is entered. Otherwise, the text is obtained from the active language.

EDI
The EDI options are not available for delivery notes and production orders.

EDI documents will only work if you also define the relevant document type in EDI messages.

AutoInvoice
AutoInvoice documents will only work if you have set up Visma AutoInvoice in the Visma AutoInvoice portal and in Business NXT.
A look-up opens the dialog box where you can see the following check boxes and options:

In addition to the document types with the associated delivery methods described above, there are some additional settings.

EDI Settings

Media type

E-media
Print

Postage type

1. class mail
2. class mail

____

Stop before sending e-mail
Used to prevent immediate transmission by e-mail. This means you can edit the e-mail before it is sent to the contact.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDocument delivery method 2Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAcDocSMtThe database field name.
API identifierdocumentDeliveryMethod2The API identifier used in GraphQL.
Number15625 

Due date

The due date.

Corresponds to the @DueDate macro function on the form.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDueDtThe database field name.
API identifierdueDateThe API identifier used in GraphQL.
Number15877 

EAN loc. code

The GLN/GS1 number for the associate.

The GLN/GS1 number is a numbering system developed to identify the legal entities involved in a transaction. Legal entities might be buyers, sellers, banks, hauliers, etc. You can also use the code to identify geographical locations in company addresses, departments, warehouse locations, loading bay doors, etc.

The allocation procedures guarantee that the location number is unique everywhere in the world. The number consists of a total of 18 digits. The structure can vary between member states.

If you have checked the Use EAN Location Code field under EDI processing field in the Company information table, a lookup is performed in this field during EDI import. It is important that two associates do not have the same GLN/GS1 number, as the lookup during EDI import would then lead to errors. If a company has administration and warehouse in different places, the company must have several GLN/GS1 numbers.

You can upload the field to the EDI export file.

An EAN/GTIN item number has either 8 or 13 digits. The 8-digit version is used for small packages. EAN/GTIN codes with 13 digits are unique all over the world, and the 2 or 3 first digits identify the country where the code was assigned.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEAN codeText (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameEANLocCdThe database field name.
API identifiereanLocationCodeThe API identifier used in GraphQL.
Number15629 

E-mail address

The e-mail address of the associate.

Note:
It is important that several employee associates do not share the same e-mail address because a lookup is performed in this field in the integration with Outlook.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainE-mail addressText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameMailAdThe database field name.
API identifieremailAddressThe API identifier used in GraphQL.
Number15548 

Expense account

Accumulated expenses in a specific account for each customer or range of customers (defined in the Account no. series table).

If you do not enter a value here the account references from the Company information table will be used.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAccount no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOlAcNoThe database field name.
API identifieroutlayAccountNoThe API identifier used in GraphQL.
Number15630 
Table 13. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountOutlayAccount
  • Expense account

Fact. company no./CID-def.

The factoring company, if you are using more than one factoring company or if you have a large number of customers abroad.

This is used for printing invoices and OCR scanning payments.

If you have a large number of customers abroad, you create payment accounts abroad for the customers in the relevant countries, and you define the CID code in this field according to the national requirements.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainFactoring no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFCNoThe database field name.
API identifierfactoringCompanyNoThe API identifier used in GraphQL.
Number15646 
Table 14. Table relations
To tablePurposeFrom columnsTo columnsComments
Factoring companyFactoringCompany
  • Fact. company no./CID-def.

Factoring no.

The customer's factoring number indicating that factoring will be used for this associate.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisation no.Text (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFactNoThe database field name.
API identifierfactoringNoThe API identifier used in GraphQL.
Number15573 

Fax

The fax number.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPhoneText (20)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFaxThe database field name.
API identifierfax1The API identifier used in GraphQL.
Number15553 

Fax 2

The second fax number.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPhoneText (20)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFax2The database field name.
API identifierfax2The API identifier used in GraphQL.
Number15619 

Fee

The reminder/interest fee in the domestic currency.

May originate from the Associate, Country or Reminder table.

Corresponds to the @ReminderFee macro function on the form.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFeeThe database field name.
API identifierreminderFeeDomesticThe API identifier used in GraphQL.
Number15649 

Fee in currency

The reminder/interest fee in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCurFeeThe database field name.
API identifierreminderFeeInCurrencyThe API identifier used in GraphQL.
Number15880 

Form no.

The form used to locate information on the sheets.

Originates from the Form drop-down list in the print dialog box to the Reminders or Interest notes report.

Refers together with the form type 3 - Reminder or 4 - Interest note to the Form table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainForm no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFormNoThe database field name.
API identifierformNoThe API identifier used in GraphQL.
Number15533 

From date

Can be used for two different reasons. The date when a customer relationship began or when an employee started in the company.

In the Created date field you bring up the date on which you created the associate.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFrDtThe database field name.
API identifierfromDateThe API identifier used in GraphQL.
Number15603 

Giro no. check sum

When you use a bank giro number, there is a check via BIG, that the giro no check sum matches with the giro number on the same line.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGiroChSmThe database field name.
API identifiergiroNoCheckSumThe API identifier used in GraphQL.
Number15639 

Gr. 1

A group to which the associate belongs.

Associate grouping 1 texts for different languages can be defined in the Text table. These texts has text type 24.
Note:
If you double-click or press * in this field, you can look up a Associate grouping 1 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate grouping 1Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGrThe database field name.
API identifiergroup1The API identifier used in GraphQL.
Number15591 

Gr. 2

A group to which the associate belongs.

Associate grouping 2 texts for different languages can be defined in the Text table. These texts has text type 25.
Note:
If you double-click or press * in this field, you can look up a Associate grouping 2 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate grouping 2Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGr2The database field name.
API identifiergroup2The API identifier used in GraphQL.
Number15592 

Gr. 3

A group to which the associate belongs.

Associate grouping 3 texts for different languages can be defined in the Text table. These texts has text type 26.
Note:
If you double-click or press * in this field, you can look up a Associate grouping 3 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate grouping 3Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGr3The database field name.
API identifiergroup3The API identifier used in GraphQL.
Number15593 

Gr. 4

A group to which the associate belongs.

Associate grouping 4 texts for different languages can be defined in the Text table. These texts has text type 27.
Note:
If you double-click or press * in this field, you can look up a Associate grouping 4 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate grouping 4Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGr4The database field name.
API identifiergroup4The API identifier used in GraphQL.
Number15594 

Gr. 5

A group to which the associate belongs.

Associate grouping 5 texts for different languages can be defined in the Text table. These texts has text type 28.
Note:
If you double-click or press * in this field, you can look up a Associate grouping 5 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate grouping 5Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGr5The database field name.
API identifiergroup5The API identifier used in GraphQL.
Number15595 

Gr. 6

A group to which the associate belongs.

Associate grouping 6 texts for different languages can be defined in the Text table. These texts has text type 29.
Note:
If you double-click or press * in this field, you can look up a Associate grouping 6 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate grouping 6Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGr6The database field name.
API identifiergroup6The API identifier used in GraphQL.
Number15596 

Gr. 7

A group to which the associate belongs.

Associate grouping 7 texts for different languages can be defined in the Text table. These texts has text type 74.
Note:
If you double-click or press * in this field, you can look up a Associate grouping 7 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate grouping 7Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGr7The database field name.
API identifiergroup7The API identifier used in GraphQL.
Number15610 

Gr. 8

A group to which the associate belongs.

Associate grouping 8 texts for different languages can be defined in the Text table. These texts has text type 75.
Note:
If you double-click or press * in this field, you can look up a Associate grouping 8 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate grouping 8Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGr8The database field name.
API identifiergroup8The API identifier used in GraphQL.
Number15611 

Gr. 9

A group to which the associate belongs.

Associate grouping 9 texts for different languages can be defined in the Text table. These texts has text type 76.
Note:
If you double-click or press * in this field, you can look up a Associate grouping 9 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate grouping 9Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGr9The database field name.
API identifiergroup9The API identifier used in GraphQL.
Number15612 

Gr. 10

A group to which the associate belongs.

Associate grouping 10 texts for different languages can be defined in the Text table. These texts has text type 77.
Note:
If you double-click or press * in this field, you can look up a Associate grouping 10 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate grouping 10Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGr10The database field name.
API identifiergroup10The API identifier used in GraphQL.
Number15613 

Gr. 11

A group to which the associate belongs.

Associate grouping 11 texts for different languages can be defined in the Text table. These texts has text type 78.
Note:
If you double-click or press * in this field, you can look up a Associate grouping 11 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate grouping 11Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGr11The database field name.
API identifiergroup11The API identifier used in GraphQL.
Number15614 

Gr. 12

A group to which the associate belongs.

Associate grouping 12 texts for different languages can be defined in the Text table. These texts has text type 79.
Note:
If you double-click or press * in this field, you can look up a Associate grouping 12 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate grouping 12Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGr12The database field name.
API identifiergroup12The API identifier used in GraphQL.
Number15615 

Inf. 1

Additional associate information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInfThe database field name.
API identifierinformation1The API identifier used in GraphQL.
Number15597 

Inf. 2

Additional associate information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInf2The database field name.
API identifierinformation2The API identifier used in GraphQL.
Number15598 

Inf. 3

Additional associate information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInf3The database field name.
API identifierinformation3The API identifier used in GraphQL.
Number15599 

Inf. 4

Additional associate information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInf4The database field name.
API identifierinformation4The API identifier used in GraphQL.
Number15600 

Inf. 5

Additional associate information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInf5The database field name.
API identifierinformation5The API identifier used in GraphQL.
Number15601 

Inf. 6

Additional associate information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInf6The database field name.
API identifierinformation6The API identifier used in GraphQL.
Number15602 

Inf. 7

Additional associate information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInf7The database field name.
API identifierinformation7The API identifier used in GraphQL.
Number15616 

Inf. 8

Additional associate information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInf8The database field name.
API identifierinformation8The API identifier used in GraphQL.
Number15617 

Interest rate

The interest rate, on an interest note.

May originate from the Associate or Country table.

Corresponds to the @InterestRate macro function on the form.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainPercentDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameIntRtThe database field name.
API identifierinterestRateThe API identifier used in GraphQL.
Number15583 

Interest rate group

A group to which the associate belongs.

Customers who have the same interest terms are assigned the same value in this field.

Interest rate group texts for different languages can be defined in the Text table. These texts has text type 154.
Note:
If you double-click or press * in this field, you can look up a Interest rate group in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInterest rate groupInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameIntGrThe database field name.
API identifierinterestRateGroupThe API identifier used in GraphQL.
Number15644 

Invoice customer no.

The customer paying the invoice, if it is different from the buyer/receiver of the goods or services.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCust. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInvoCustThe database field name.
API identifierinvoiceCustomerNoThe API identifier used in GraphQL.
Number15572 
Table 15. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateInvoiceCustomer
  • Invoice customer no.

Language no.

The language, if it is different from the default language defined in the Company information table.

The language determines which texts are printed in documents that are sent to the customer/supplier.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainLanguage no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLangThe database field name.
API identifierlanguageNoThe API identifier used in GraphQL.
Number15546 
Table 16. Table relations
To tablePurposeFrom columnsTo columnsComments
LanguageLanguage
  • Language no.

Last reminder date

The date when the last reminder was sent to the customer.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLstRemDtThe database field name.
API identifierlastReminderDateThe API identifier used in GraphQL.
Number15581 

Layout no.

The layout used when the document was produced, i.e. the output layout from the form, or the screen layout from which the report was run.

Refers to the Window table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLayNoThe database field name.
API identifierlayoutNoThe API identifier used in GraphQL.
Number15534 

Letter no.

The sequence number of the reminder letter, to the customer.

Corresponds to the @LetterNo macro function on the form.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLtrNoThe database field name.
API identifierreminderLetterNoThe API identifier used in GraphQL.
Number15876 

Main associate

The main associate to which an associate belongs.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameMainActThe database field name.
API identifiermainAssociateNoThe API identifier used in GraphQL.
Number15622 
Table 17. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateMainAssociate
  • Main associate

Max direct debit. amount

The maximum direct debit amount for each entry.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameMaxDebAmThe database field name.
API identifiermaxDirectDebitingAmountThe API identifier used in GraphQL.
Number15608 

Max. % of credit overdue

The percentage that will be used as a basis for testing for unpaid, overdue invoices.

The test is performed for orders if the associated field has a value greater than 0.

  • In the customer ledger there must be no overdue invoices with a total amount outstanding greater than the percentage multiplied by the customer’s (i.e. the invoice recipient’s) credit limit, and
  • none of the overdue invoices may be older than the number of days stated.

It overrides the corresponding fields under Company information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameMaxDuePThe database field name.
API identifiermaxPercentOfCreditOverdueThe API identifier used in GraphQL.
Number15623 

Max. days overdue

The number of days that will be used on the credit control check for overdue invoices.

It is used for the warning or block on the credit control setting in the Company information table. It overrides corresponding fields under Company information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDaysInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameMaxDueDyThe database field name.
API identifiermaxDaysOverdueThe API identifier used in GraphQL.
Number15624 

Max. no. of reminders

The number of reminders to send before the transactions will be included in the debt collection/change list.

When you send a reminder to a customer you define the reminder number and the reminder text. When you reach a number of reminders that you have specified in the field for the maximum number of reminders, the final reminder for the country is used. If you have not specified a maximum number of reminders all reminders will be written.

If you set the Max. no. of reminders for the associate to 2, transactions will not be included in the debt collection/change list until two reminders have been issued.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNumber of remindersInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameMaxRemsThe database field name.
API identifiermaxNoOfRemindersThe API identifier used in GraphQL.
Number15580 

Memo file name

The file name for the Memo attached to the associate.

On the Editing menu, click Memo to create a new memo or to view the existing memo. The memo file name is saved in this text box.

Double-click or press * to open the Select file dialog box to manually select a memo file.

Note:
It is important that you save the file on a server and in a folder that is available to all users, otherwise users who try to open the memo will receive an error message.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainMemo file nameText (260)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameNoteNmThe database field name.
API identifiermemoFileNameThe API identifier used in GraphQL.
Number15605 

Memo no.

Link to the memo for the entry.

The actual memo is stored in the Memo table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainMemo no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameMemoNoThe database field name.
API identifiermemoNoThe API identifier used in GraphQL.
Number19207 
Table 18. Table relations
To tablePurposeFrom columnsTo columnsComments
MemoMemo
  • Memo no.

Mobile phone

The mobile phone number.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPhoneText (20)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameMobPhThe database field name.
API identifiermobilePhoneThe API identifier used in GraphQL.
Number15551 

Name

The name of the associate.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNameText (80)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameNmThe database field name.
API identifiernameThe API identifier used in GraphQL.
Number15538 

No. of reminders sent

How many times you have issued reminders for the entry that has had the most reminders. This could be higher than the letter number.

This field is obsolete. No. of reminders is given per invoice in the Open customer entry and Customer transaction tables.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNumber of remindersInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLstRemNoThe database field name.
API identifiernoOfRemindersSentThe API identifier used in GraphQL.
Number15582 

Organisation no.

The company's organisation number in the national registry.

When addresses are transferred to the Associate table, this field is used for validations.
Note:
This is not the same as VAT no.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOrganisation no.Text (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameBsNoThe database field name.
API identifiercompanyNoThe API identifier used in GraphQL.
Number15589 

Organisational unit 1

The department, project, etc. the associate is linked to.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR1The database field name.
API identifierorgUnit1The API identifier used in GraphQL.
Number15561 
Table 19. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 1OrgUnit1
  • Organisational unit 1

Organisational unit 2

The department, project, etc. the associate is linked to.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR2The database field name.
API identifierorgUnit2The API identifier used in GraphQL.
Number15562 
Table 20. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 2OrgUnit2
  • Organisational unit 2

Organisational unit 3

The department, project, etc. the associate is linked to.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR3The database field name.
API identifierorgUnit3The API identifier used in GraphQL.
Number15563 
Table 21. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 3OrgUnit3
  • Organisational unit 3

Organisational unit 4

The department, project, etc. the associate is linked to.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR4The database field name.
API identifierorgUnit4The API identifier used in GraphQL.
Number15564 
Table 22. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 4OrgUnit4
  • Organisational unit 4

Organisational unit 5

The department, project, etc. the associate is linked to.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR5The database field name.
API identifierorgUnit5The API identifier used in GraphQL.
Number15565 
Table 23. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 5OrgUnit5
  • Organisational unit 5

Organisational unit 6

The department, project, etc. the associate is linked to.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR6The database field name.
API identifierorgUnit6The API identifier used in GraphQL.
Number15566 
Table 24. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 6OrgUnit6
  • Organisational unit 6

Organisational unit 7

The department, project, etc. the associate is linked to.

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainLong alphanumeric organisational unit no.Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR7The database field name.
API identifierorgUnit7The API identifier used in GraphQL.
Number15633 
Table 25. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 7OrgUnit7
  • Organisational unit 7

Organisational unit 8

The department, project, etc. the associate is linked to.

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR8The database field name.
API identifierorgUnit8The API identifier used in GraphQL.
Number15634 
Table 26. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 8OrgUnit8
  • Organisational unit 8

Organisational unit 9

The department, project, etc. the associate is linked to.

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR9The database field name.
API identifierorgUnit9The API identifier used in GraphQL.
Number15635 
Table 27. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 9OrgUnit9
  • Organisational unit 9

Organisational unit 10

The department, project, etc. the associate is linked to.

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR10The database field name.
API identifierorgUnit10The API identifier used in GraphQL.
Number15636 
Table 28. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 10OrgUnit10
  • Organisational unit 10

Organisational unit 11

The department, project, etc. the associate is linked to.

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR11The database field name.
API identifierorgUnit11The API identifier used in GraphQL.
Number15637 
Table 29. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 11OrgUnit11
  • Organisational unit 11

Organisational unit 12

The department, project, etc. the associate is linked to.

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR12The database field name.
API identifierorgUnit12The API identifier used in GraphQL.
Number15638 
Table 30. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 12OrgUnit12
  • Organisational unit 12

Our cust./sup. no.

Your customer number with the supplier or your supplier number with the customer.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisation no.Text (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOurCNoThe database field name.
API identifierourCustomerOrSupplierNoThe API identifier used in GraphQL.
Number15586 

Page elem. no.

The actual page element against the Associate table, in the layout used when the document was produced.

Refers together with the Layout no. field to the Window element table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePgElNoThe database field name.
API identifierpageElementNoThe API identifier used in GraphQL.
Number15535 

Pager

The pager number.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPhoneText (20)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePersThe database field name.
API identifierpagerThe API identifier used in GraphQL.
Number15552 

Payment method

The payment method for the customer.

Payment method texts for different languages can be defined in the Text table. These texts has text type 7.
Note:
If you double-click or press * in this field, you can look up a Payment method in the Text table.
Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPayment methodInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCPmtMtThe database field name.
API identifierpaymentMethodThe API identifier used in GraphQL.
Number15575 
Table 31. Table relations
To tablePurposeFrom columnsTo columnsComments
Payment methodPaymentMethod
  • Payment method

Payment priority

In the Payment priority field you can enter your own priority codes, which you can choose to sort or select by in connection with payment suggestions.

The value you enter here is suggested when you run vouchers for the supplier, and is carried forward to open customer and supplier entries and transactions. The priority can also be suggested from the voucher type.

Payment priority texts for different languages can be defined in the Text table. These texts has text type 67.
Note:
If you double-click or press * in this field, you can look up a Payment priority in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPayment priorityInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRmtPriThe database field name.
API identifierremittancePriorityThe API identifier used in GraphQL.
Number15584 

Payment supplier no.

You only need to complete this field if payment is to be made to someone other than the supplier.

Suggested when you enter orders for the supplier.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainSup. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRmtSupThe database field name.
API identifierremittanceSupplierNoThe API identifier used in GraphQL.
Number15585 
Table 32. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateRemittanceSupplier
  • Payment supplier no.

Payment terms

The payment terms for the customer.

Payment terms texts for different languages can be defined in the Text table. These texts has text type 6.
Note:
If you double-click or press * in this field, you can look up a Payment terms in the Text table.
Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPayment termsInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCPmtTrmThe database field name.
API identifierpaymentTermsThe API identifier used in GraphQL.
Number15574 
Table 33. Table relations
To tablePurposeFrom columnsTo columnsComments
Payment termPaymentTerms
  • Payment terms

Phone

The phone number.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPhoneText (20)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePhoneThe database field name.
API identifierphoneThe API identifier used in GraphQL.
Number15549 

Post code

The post code.

If you enter a Post code that exists in the Postal address table, the Postal area field is filled in and the cursor jumps to the next field. If the Post code does not exist you will see a warning in the Status bar and the cursor will then stop in the Postal area field so you can type in the Postal area manually.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainPost codeText (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePNoThe database field name.
API identifierpostCodeThe API identifier used in GraphQL.
Number15543 
Table 34. Table relations
To tablePurposeFrom columnsTo columnsComments
Postal addressPostalAddress
  • Post code

Postal area

The postal area.

If you enter a postcode that exists in the Postal address table, Business NXT fills in the Postal area field and the cursor jumps to the next field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePAreaThe database field name.
API identifierpostalAreaThe API identifier used in GraphQL.
Number15544 

Postal giro

The postal giro number of the associate.

This is relevant if you want to print completed postal giro forms in connection with reminders, interest notes and payments, or if you use electronic funds transfer. You can restrict payments to associates for whom at least one of the Bank account or Postal giro fields is completed. To do this you must select the Payment if giro no. option in the Payment processing field in the Company information table.

Note:
For suppliers who are remitted via electronic funds transfer, you must enter the correct postal giro number. Otherwise they will be remitted by direct payment. (This depends on the settings in Z Data).
Note:
The postal giro can be validated according to different rules. The validation is controlled in the Country processing field in the Country table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBank accountText (35)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePGiroThe database field name.
API identifierpostalGiroThe API identifier used in GraphQL.
Number15577 

Printed date

The date when the document was produced.

Corresponds to the @Date macro function on the form.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDocDtThe database field name.
API identifierprintedDateThe API identifier used in GraphQL.
Number15531 

Private phone

The private phone number.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPhoneText (20)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePrivPhThe database field name.
API identifierprivatePhoneThe API identifier used in GraphQL.
Number15550 

Reminder printing date

The date when the last reminder got printed for the customer.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRemPrDtThe database field name.
API identifierreminderPrintingDateThe API identifier used in GraphQL.
Number15643 

Responsible

The official for the associate.

The Empl. no. is a unique number identifying one specific Employee.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEmpl. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRspThe database field name.
API identifierofficialThe API identifier used in GraphQL.
Number15559 
Table 35. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateOfficial
  • Responsible

Sector

A group to which the associate belongs.

Trade texts for different languages can be defined in the Text table. These texts has text type 10.
Note:
If you double-click or press * in this field, you can look up a Trade in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTradeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTradeThe database field name.
API identifiersectorThe API identifier used in GraphQL.
Number15587 

Seller

The seller who is responsible for the customer.

The Empl. no. is a unique number identifying one specific Employee.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEmpl. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSellerThe database field name.
API identifiersellerThe API identifier used in GraphQL.
Number15557 
Table 36. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateSeller
  • Seller

Short name

Used to sort the associates in a particular order or to make selections on groups of associates.

Business NXT suggests the contents in the field when you enter a value in the Name field.

Note:
If you have accidentally deleted the name of the associate, this field contains the original name which was entered the first time. This enables you to restore names which have been deleted.

Example

If you enter the customer AS Ole Hansen in the Name field, this customer is sorted under A in an alphabetical list of names. To sort the customer under the letter H instead, you enter Hansen, Ole AS in the Short name field. For an alphabetical list of your customers, sort using the Short name field instead of the Name field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNameText (80)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameShrtThe database field name.
API identifiershortNameThe API identifier used in GraphQL.
Number15547 

Title

The professional title for a private individual.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNameText (80)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTitleThe database field name.
API identifiertitleThe API identifier used in GraphQL.
Number15555 

To date

You can use this field to state when a customer relationship ended or when an employee left the company.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameToDtThe database field name.
API identifiertoDateThe API identifier used in GraphQL.
Number15604 

Trade area

Defines the trade area for the associate. It is suggested in the orders, and specifies whether the customer/supplier is located within the country, in another EU country or outside the EU/abroad.

When this field has been filled in (with a value other than 0) this means that VAT will not be calculated on orders. 0 appears blank. The area code determines which of the account references for taxable, non-taxable domestic, EU and export/import are to be used in connection with sales, discounts, additions, special taxes and purchases in the Tax- and accounting inf. table, and invoice fees in the Currency table. If the product is not taxable and the associate is domestic, the account references for non-taxable are used regardless. This is an exception from the rule that the VAT follows the product. For example, the VAT rules of a country may require VAT to be invoiced to the customer if the product goes to another EU country but the invoice stays in the same country. If the Delivery associate number has Trade area 2, 4 or 5 in the Associate table, but Trade area 0 is within the trade area of the order, the system does not overwrite the value. Otherwise, the value in Delivery associate number overwrites the values from the Invoice customer number field.

The Order processing 2 field contains the parameter Do not overwrite trade area and EU VAT with local VAT, which you should use in combination with the Trade area and VAT codes from delivery associate number option. When you have set these parameters, Business NXT will calculate the VAT from the Delivery associate number when invoicing.

The area codes apply to both customers and suppliers, unless otherwise stated.

The area code forms the basis when Business NXT selects the turnover class of the vouchers.

Note:
When you enter one of the values 2, 4 or 5 in the Area field in the Associates table, and a customer number is defined, you receive a warning if the EU VAT reg. no. field has not been filled in.
A look-up in this field gives you the following list of possible values:
0 - Taxable domestic according to VAT- and accounting inf./VAT code
1 - Non-taxable domestic
2 - Within other EU country
only relevant if the company is located in an EU country
3 - Outside EU/Abroad
applies to all other foreign associates
4 - Subsidiary in another EU country
only relevant for customers, only relevant if the company is located in an EU country, treated in the same way as 2 in respect of account references
5 - Transfer between other EU countries
only relevant for suppliers, only relevant if the company is located in an EU country, treated in the same way as 2 in respect of account references
6 - Consuming of products
7 - Reversed domestic tax
8 - Rent income voluntary
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTrade areaInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameExVatThe database field name.
API identifiertradeAreaThe API identifier used in GraphQL.
Number15570 

Turnover

The annual turnover.

This is only used for information purposes.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTurnThe database field name.
API identifierturnoverThe API identifier used in GraphQL.
Number15590 

VAT reg. no.

VAT registration number for the company.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisation no.Text (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameEUTaxNoThe database field name.
API identifiereuVatRegistrationNoThe API identifier used in GraphQL.
Number15620 

Visit post code

The visiting post code.

When you enter a visiting postcode, the appropriate visiting postcode area is completed. If the postcode is not defined in the Postal address table, a warning is issued in the status bar.

If you enter a Post code that exists in the Postal address table, the Postal area field is filled in and the cursor jumps to the next field. If the Post code does not exist you will see a warning in the Status bar and the cursor will then stop in the Postal area field so you can type in the Postal area manually.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPost codeText (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameViPNoThe database field name.
API identifiervisitPostCodeThe API identifier used in GraphQL.
Number15641 
Table 37. Table relations
To tablePurposeFrom columnsTo columnsComments
Postal addressVisitPostalAddress
  • Visit post code

Visit postal area

The visiting postal area.

When you enter a visiting postcode, the appropriate visiting postcode area is completed. If the postcode is not defined in the Postal address table, a warning is issued in the status bar.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAddress lineText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameViPAreaThe database field name.
API identifiervisitPostalAreaThe API identifier used in GraphQL.
Number15642 

Web page 1

The address of a web page for the associate.

Double-click or press * to open the web page in your web browser.

Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.

On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeb pageText (260)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameIntAd1The database field name.
API identifierwebPage1The API identifier used in GraphQL.
Number15627 

Web page 2

The address of a web page for the associate.

Double-click or press * to open the web page in your web browser.

Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.

On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeb pageText (260)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameIntAd2The database field name.
API identifierwebPage2The API identifier used in GraphQL.
Number15628 

Your ref.

The customer's/supplier's reference.

The reference is suggested on orders for the customer/supplier.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainReferenceText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameYrRefThe database field name.
API identifieryourReferenceThe API identifier used in GraphQL.
Number15618 

Control columns

Control columns include information about who has changed the record last and when, and which process that is currently editing the record.

Changed by provenance

The provenance for the record change.

A look-up in this field gives you the following list of possible values:

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPvnThe database field name.
API identifierchangedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Changed by user

The name of the user that changed the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChUsrThe database field name.
API identifierchangedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Changed date

The date when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChDtThe database field name.
API identifierchangedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time

The time when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTmThe database field name.
API identifierchangedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time stamp

The date and time when the record was changed.

The field is updated with the UTC time.

This value can be used by external systems to replicate changed data. The column is indexed. 

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTsThe database field name.
API identifierchangedTimestampThe API identifier used in GraphQL.
NumberA unique column number. 

Created by provenance

The provenance for the record creation.

A look-up in this field gives you the following list of possible values:

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrePvnThe database field name.
API identifiercreatedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Created by user

The name of the user that created the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreUsrThe database field name.
API identifiercreatedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Created date

The date when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreDtThe database field name.
API identifiercreatedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Created time

The time when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTmThe database field name.
API identifiercreatedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTsThe database field name.
API identifiercreatedTimestampThe API identifier used in GraphQL.
NumberA unique column number. 

Edit status

The current status of the record.

A look-up in this field gives you the following list of possible values:

0 - Unchanged: The record is read, but not changed.

1 - Inserted: The record is new.

2 - Changed: The record is changed.

3 - Deleted: The record is deleted.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEdit statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLckStThe database field name.
API identifiereditStatusThe API identifier used in GraphQL.
NumberA unique column number. 

Process no

The Process no. from the Active company process table which is currently using or has control of this record.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProcess no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPrcThe database field name.
API identifierlockedByProcessNoThe API identifier used in GraphQL.
NumberA unique column number. 
Table 38. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.