Customer document
This table contains one row for each archived customer document, according to the Document copies field in the Company information table.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | CsDoc | The table name in the database. |
| API identifier | customerDocument | The API identifier used in GraphQL. |
| Table no. | 358 | The 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ad1 | The database field name. |
| API identifier | addressLine1 | The API identifier used in GraphQL. |
| Number | 15539 |
Address line 2
The street address, PO Box address, c/o address and/or attention.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ad2 | The database field name. |
| API identifier | addressLine2 | The API identifier used in GraphQL. |
| Number | 15540 |
Address line 3
The street address, PO Box address, c/o address and/or attention.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ad3 | The database field name. |
| API identifier | addressLine3 | The API identifier used in GraphQL. |
| Number | 15541 |
Address line 4
The street address, PO Box address, c/o address and/or attention.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ad4 | The database field name. |
| API identifier | addressLine4 | The API identifier used in GraphQL. |
| Number | 15542 |
Amount
The amount due in the domestic currency.
Corresponds to the @GiroAmount macro function on the form.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Am | The database field name. |
| API identifier | amountDomestic | The API identifier used in GraphQL. |
| Number | 15879 |
Amount in currency
The amount due in the actual currency.
Corresponds to the @GiroAmountInCurrency macro function on the form.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CurAm | The database field name. |
| API identifier | amountInCurrency | The API identifier used in GraphQL. |
| Number | 15878 |
Appointment flow balance
The balance of all open appointments for the associate, i.e. all appointments which are not yet transferred to an order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AgrChBal | The database field name. |
| API identifier | appointmentFlowBalance | The API identifier used in GraphQL. |
| Number | 15648 |
Associate no.
A unique number identifying the associate.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ActNo | The database field name. |
| API identifier | associateNo | The API identifier used in GraphQL. |
| Number | 15537 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Associate |
| ||
| Participant | Participant |
| ||
| Associate reference | AssociateReference |
|
Associate processing
Settings defining the behaviour of the associate.
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate processing | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ActPro | The database field name. |
| API identifier | associateProcessing | The API identifier used in GraphQL. |
| Number | 15626 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Att | The database field name. |
| API identifier | approvalOfficial | The API identifier used in GraphQL. |
| Number | 15560 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | ApprovalOfficial |
|
AutoInvoice document ID
A unique identifier that is returned from Visma AutoInvoice, on successfully transferred documents.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | GUID | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MavDocId | The database field name. |
| API identifier | autoInvoiceDocumentID | The API identifier used in GraphQL. |
| Number | 18567 |
AutoInvoice status
The status for Visma AutoInvoice documents.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | AutoInvoice status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MavStat | The database field name. |
| API identifier | autoInvoiceStatus | The API identifier used in GraphQL. |
| Number | 18566 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Bank account | Text (35) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BGiro | The database field name. |
| API identifier | bankAccount | The API identifier used in GraphQL. |
| Number | 15576 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Bank account | Text (35) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Branch | The database field name. |
| API identifier | bankBranch | The API identifier used in GraphQL. |
| Number | 15606 |
Bank no.
The associate's bank. This value is not in use for payments.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Bank no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BankCon | The database field name. |
| API identifier | bankNo | The API identifier used in GraphQL. |
| Number | 15640 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Bank | Bank |
|
Buyer
The buyer for the supplier.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Buyer | The database field name. |
| API identifier | buyer | The API identifier used in GraphQL. |
| Number | 15558 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Buyer |
|
CID code
The CID code for the document.
Corresponds to the @CID macro function on the form.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | CID code | Text (30) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CID | The database field name. |
| API identifier | cid | The API identifier used in GraphQL. |
| Number | 15530 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ClReAcNo | The database field name. |
| API identifier | clientResponsibleAccountNo1 | The API identifier used in GraphQL. |
| Number | 15631 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | ClientResponsibleAccount1 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ClBaAcNo | The database field name. |
| API identifier | clientResponsibleAccountNo2 | The API identifier used in GraphQL. |
| Number | 15632 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | ClientResponsibleAccount2 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cl3AcNo | The database field name. |
| API identifier | clientResponsibleAccountNo3 | The API identifier used in GraphQL. |
| Number | 15647 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | ClientResponsibleAccount3 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LiaAct | The database field name. |
| API identifier | contactFor | The API identifier used in GraphQL. |
| Number | 15556 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | ContactFor |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Country no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ctry | The database field name. |
| API identifier | countryNo | The API identifier used in GraphQL. |
| Number | 15545 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Country | Country |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Name | Text (80) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrEval | The database field name. |
| API identifier | creditEvaluation | The API identifier used in GraphQL. |
| Number | 15569 |
Credit limit
The amount that the customer (invoice recipient) is allowed to owe the company.
- 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrLmt | The database field name. |
| API identifier | creditLimit | The API identifier used in GraphQL. |
| Number | 15567 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CNtDy | The database field name. |
| API identifier | creditNoteDueDays | The API identifier used in GraphQL. |
| Number | 15645 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrSusp | The database field name. |
| API identifier | creditDenied | The API identifier used in GraphQL. |
| Number | 15568 |
Currency no.
The currency no for the customer or supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 15571 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
Currency no. 2
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cur2 | The database field name. |
| API identifier | currencyNo2 | The API identifier used in GraphQL. |
| Number | 15650 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency2 |
|
Cust. doc. no.
A unique number identifying the customer document.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Cust. doc. no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CsDocNo | The database field name. |
| API identifier | customerDocumentNo | The API identifier used in GraphQL. |
| Number | 15528 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Cust. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CustNo | The database field name. |
| API identifier | customerNo | The API identifier used in GraphQL. |
| Number | 15554 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Customer |
|
Customer doc. proc.
Settings defining the behaviour of the customer document.
- Giro document
- The customer document has a giro amount (greater than 0).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Customer doc. proc. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CsDPro | The database field name. |
| API identifier | customerDocumentProcessing | The API identifier used in GraphQL. |
| Number | 15536 |
Customer options
Settings defining the behaviour of the customer.
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.
- 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Customer options | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CustPref | The database field name. |
| API identifier | customerPreferences1 | The API identifier used in GraphQL. |
| Number | 15609 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DebFrDt | The database field name. |
| API identifier | directDebitingFromDate | The API identifier used in GraphQL. |
| Number | 15578 |
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.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Direct deb. status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DirDeb | The database field name. |
| API identifier | directDebitingStatus | The API identifier used in GraphQL. |
| Number | 15607 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DebToDt | The database field name. |
| API identifier | directDebitingToDate | The API identifier used in GraphQL. |
| Number | 15579 |
District
Can be used for groupings.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | District | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Distr | The database field name. |
| API identifier | district | The API identifier used in GraphQL. |
| Number | 15588 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StDt | The database field name. |
| API identifier | documentDate | The API identifier used in GraphQL. |
| Number | 15532 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DocNo | The database field name. |
| API identifier | documentNo | The API identifier used in GraphQL. |
| Number | 15875 |
Doc. type
The type of customer document.
- 1 - Reminder
- 2 - Interest note
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Doc. type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DocTp | The database field name. |
| API identifier | documentType | The API identifier used in GraphQL. |
| Number | 15529 |
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.
- 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.
- 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.
In addition to the document types with the associated delivery methods described above, there are some additional settings.
EDI Settings
Media type
- E-media
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document delivery method 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DocSMt | The database field name. |
| API identifier | documentDeliveryMethod1 | The API identifier used in GraphQL. |
| Number | 15621 |
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.
- 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.
- 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.
In addition to the document types with the associated delivery methods described above, there are some additional settings.
EDI Settings
Media type
- E-media
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Document delivery method 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcDocSMt | The database field name. |
| API identifier | documentDeliveryMethod2 | The API identifier used in GraphQL. |
| Number | 15625 |
Due date
The due date.
Corresponds to the @DueDate macro function on the form.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DueDt | The database field name. |
| API identifier | dueDate | The API identifier used in GraphQL. |
| Number | 15877 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EAN code | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EANLocCd | The database field name. |
| API identifier | eanLocationCode | The API identifier used in GraphQL. |
| Number | 15629 |
E-mail address
The e-mail address of the associate.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | E-mail address | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MailAd | The database field name. |
| API identifier | emailAddress | The API identifier used in GraphQL. |
| Number | 15548 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OlAcNo | The database field name. |
| API identifier | outlayAccountNo | The API identifier used in GraphQL. |
| Number | 15630 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | OutlayAccount |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Factoring no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FCNo | The database field name. |
| API identifier | factoringCompanyNo | The API identifier used in GraphQL. |
| Number | 15646 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Factoring company | FactoringCompany |
|
Factoring no.
The customer's factoring number indicating that factoring will be used for this associate.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisation no. | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FactNo | The database field name. |
| API identifier | factoringNo | The API identifier used in GraphQL. |
| Number | 15573 |
Fax
The fax number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Phone | Text (20) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Fax | The database field name. |
| API identifier | fax1 | The API identifier used in GraphQL. |
| Number | 15553 |
Fax 2
The second fax number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Phone | Text (20) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Fax2 | The database field name. |
| API identifier | fax2 | The API identifier used in GraphQL. |
| Number | 15619 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Fee | The database field name. |
| API identifier | reminderFeeDomestic | The API identifier used in GraphQL. |
| Number | 15649 |
Fee in currency
The reminder/interest fee in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CurFee | The database field name. |
| API identifier | reminderFeeInCurrency | The API identifier used in GraphQL. |
| Number | 15880 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Form no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FormNo | The database field name. |
| API identifier | formNo | The API identifier used in GraphQL. |
| Number | 15533 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FrDt | The database field name. |
| API identifier | fromDate | The API identifier used in GraphQL. |
| Number | 15603 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | GiroChSm | The database field name. |
| API identifier | giroNoCheckSum | The API identifier used in GraphQL. |
| Number | 15639 |
Gr. 1
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate grouping 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr | The database field name. |
| API identifier | group1 | The API identifier used in GraphQL. |
| Number | 15591 |
Gr. 2
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate grouping 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr2 | The database field name. |
| API identifier | group2 | The API identifier used in GraphQL. |
| Number | 15592 |
Gr. 3
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate grouping 3 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr3 | The database field name. |
| API identifier | group3 | The API identifier used in GraphQL. |
| Number | 15593 |
Gr. 4
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate grouping 4 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr4 | The database field name. |
| API identifier | group4 | The API identifier used in GraphQL. |
| Number | 15594 |
Gr. 5
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate grouping 5 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr5 | The database field name. |
| API identifier | group5 | The API identifier used in GraphQL. |
| Number | 15595 |
Gr. 6
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate grouping 6 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr6 | The database field name. |
| API identifier | group6 | The API identifier used in GraphQL. |
| Number | 15596 |
Gr. 7
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate grouping 7 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr7 | The database field name. |
| API identifier | group7 | The API identifier used in GraphQL. |
| Number | 15610 |
Gr. 8
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate grouping 8 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr8 | The database field name. |
| API identifier | group8 | The API identifier used in GraphQL. |
| Number | 15611 |
Gr. 9
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate grouping 9 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr9 | The database field name. |
| API identifier | group9 | The API identifier used in GraphQL. |
| Number | 15612 |
Gr. 10
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate grouping 10 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr10 | The database field name. |
| API identifier | group10 | The API identifier used in GraphQL. |
| Number | 15613 |
Gr. 11
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate grouping 11 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr11 | The database field name. |
| API identifier | group11 | The API identifier used in GraphQL. |
| Number | 15614 |
Gr. 12
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate grouping 12 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Gr12 | The database field name. |
| API identifier | group12 | The API identifier used in GraphQL. |
| Number | 15615 |
Inf. 1
Additional associate information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf | The database field name. |
| API identifier | information1 | The API identifier used in GraphQL. |
| Number | 15597 |
Inf. 2
Additional associate information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf2 | The database field name. |
| API identifier | information2 | The API identifier used in GraphQL. |
| Number | 15598 |
Inf. 3
Additional associate information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf3 | The database field name. |
| API identifier | information3 | The API identifier used in GraphQL. |
| Number | 15599 |
Inf. 4
Additional associate information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf4 | The database field name. |
| API identifier | information4 | The API identifier used in GraphQL. |
| Number | 15600 |
Inf. 5
Additional associate information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf5 | The database field name. |
| API identifier | information5 | The API identifier used in GraphQL. |
| Number | 15601 |
Inf. 6
Additional associate information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf6 | The database field name. |
| API identifier | information6 | The API identifier used in GraphQL. |
| Number | 15602 |
Inf. 7
Additional associate information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf7 | The database field name. |
| API identifier | information7 | The API identifier used in GraphQL. |
| Number | 15616 |
Inf. 8
Additional associate information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Inf8 | The database field name. |
| API identifier | information8 | The API identifier used in GraphQL. |
| Number | 15617 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | IntRt | The database field name. |
| API identifier | interestRate | The API identifier used in GraphQL. |
| Number | 15583 |
Interest rate group
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Interest rate group | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | IntGr | The database field name. |
| API identifier | interestRateGroup | The API identifier used in GraphQL. |
| Number | 15644 |
Invoice customer no.
The customer paying the invoice, if it is different from the buyer/receiver of the goods or services.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Cust. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoCust | The database field name. |
| API identifier | invoiceCustomerNo | The API identifier used in GraphQL. |
| Number | 15572 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | InvoiceCustomer |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Language no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Lang | The database field name. |
| API identifier | languageNo | The API identifier used in GraphQL. |
| Number | 15546 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Language | Language |
|
Last reminder date
The date when the last reminder was sent to the customer.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LstRemDt | The database field name. |
| API identifier | lastReminderDate | The API identifier used in GraphQL. |
| Number | 15581 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LayNo | The database field name. |
| API identifier | layoutNo | The API identifier used in GraphQL. |
| Number | 15534 |
Letter no.
The sequence number of the reminder letter, to the customer.
Corresponds to the @LetterNo macro function on the form.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LtrNo | The database field name. |
| API identifier | reminderLetterNo | The API identifier used in GraphQL. |
| Number | 15876 |
Main associate
The main associate to which an associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MainAct | The database field name. |
| API identifier | mainAssociateNo | The API identifier used in GraphQL. |
| Number | 15622 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | MainAssociate |
|
Max direct debit. amount
The maximum direct debit amount for each entry.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MaxDebAm | The database field name. |
| API identifier | maxDirectDebitingAmount | The API identifier used in GraphQL. |
| Number | 15608 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MaxDueP | The database field name. |
| API identifier | maxPercentOfCreditOverdue | The API identifier used in GraphQL. |
| Number | 15623 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Days | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MaxDueDy | The database field name. |
| API identifier | maxDaysOverdue | The API identifier used in GraphQL. |
| Number | 15624 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Number of reminders | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MaxRems | The database field name. |
| API identifier | maxNoOfReminders | The API identifier used in GraphQL. |
| Number | 15580 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo file name | Text (260) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NoteNm | The database field name. |
| API identifier | memoFileName | The API identifier used in GraphQL. |
| Number | 15605 |
Memo no.
Link to the memo for the entry.
The actual memo is stored in the Memo table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MemoNo | The database field name. |
| API identifier | memoNo | The API identifier used in GraphQL. |
| Number | 19207 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Memo | Memo |
|
Mobile phone
The mobile phone number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Phone | Text (20) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MobPh | The database field name. |
| API identifier | mobilePhone | The API identifier used in GraphQL. |
| Number | 15551 |
Name
The name of the associate.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Nm | The database field name. |
| API identifier | name | The API identifier used in GraphQL. |
| Number | 15538 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Number of reminders | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LstRemNo | The database field name. |
| API identifier | noOfRemindersSent | The API identifier used in GraphQL. |
| Number | 15582 |
Organisation no.
The company's organisation number in the national registry.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisation no. | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BsNo | The database field name. |
| API identifier | companyNo | The API identifier used in GraphQL. |
| Number | 15589 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R1 | The database field name. |
| API identifier | orgUnit1 | The API identifier used in GraphQL. |
| Number | 15561 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R2 | The database field name. |
| API identifier | orgUnit2 | The API identifier used in GraphQL. |
| Number | 15562 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R3 | The database field name. |
| API identifier | orgUnit3 | The API identifier used in GraphQL. |
| Number | 15563 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R4 | The database field name. |
| API identifier | orgUnit4 | The API identifier used in GraphQL. |
| Number | 15564 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R5 | The database field name. |
| API identifier | orgUnit5 | The API identifier used in GraphQL. |
| Number | 15565 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R6 | The database field name. |
| API identifier | orgUnit6 | The API identifier used in GraphQL. |
| Number | 15566 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Long alphanumeric organisational unit no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R7 | The database field name. |
| API identifier | orgUnit7 | The API identifier used in GraphQL. |
| Number | 15633 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R8 | The database field name. |
| API identifier | orgUnit8 | The API identifier used in GraphQL. |
| Number | 15634 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R9 | The database field name. |
| API identifier | orgUnit9 | The API identifier used in GraphQL. |
| Number | 15635 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R10 | The database field name. |
| API identifier | orgUnit10 | The API identifier used in GraphQL. |
| Number | 15636 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R11 | The database field name. |
| API identifier | orgUnit11 | The API identifier used in GraphQL. |
| Number | 15637 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R12 | The database field name. |
| API identifier | orgUnit12 | The API identifier used in GraphQL. |
| Number | 15638 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Our cust./sup. no.
Your customer number with the supplier or your supplier number with the customer.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisation no. | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OurCNo | The database field name. |
| API identifier | ourCustomerOrSupplierNo | The API identifier used in GraphQL. |
| Number | 15586 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PgElNo | The database field name. |
| API identifier | pageElementNo | The API identifier used in GraphQL. |
| Number | 15535 |
Pager
The pager number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Phone | Text (20) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Pers | The database field name. |
| API identifier | pager | The API identifier used in GraphQL. |
| Number | 15552 |
Payment method
The payment method for the customer.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment method | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CPmtMt | The database field name. |
| API identifier | paymentMethod | The API identifier used in GraphQL. |
| Number | 15575 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment method | PaymentMethod |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment priority | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RmtPri | The database field name. |
| API identifier | remittancePriority | The API identifier used in GraphQL. |
| Number | 15584 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sup. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RmtSup | The database field name. |
| API identifier | remittanceSupplierNo | The API identifier used in GraphQL. |
| Number | 15585 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | RemittanceSupplier |
|
Payment terms
The payment terms for the customer.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment terms | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CPmtTrm | The database field name. |
| API identifier | paymentTerms | The API identifier used in GraphQL. |
| Number | 15574 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment term | PaymentTerms |
|
Phone
The phone number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Phone | Text (20) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Phone | The database field name. |
| API identifier | phone | The API identifier used in GraphQL. |
| Number | 15549 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Post code | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PNo | The database field name. |
| API identifier | postCode | The API identifier used in GraphQL. |
| Number | 15543 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Postal address | PostalAddress |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PArea | The database field name. |
| API identifier | postalArea | The API identifier used in GraphQL. |
| Number | 15544 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Bank account | Text (35) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PGiro | The database field name. |
| API identifier | postalGiro | The API identifier used in GraphQL. |
| Number | 15577 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DocDt | The database field name. |
| API identifier | printedDate | The API identifier used in GraphQL. |
| Number | 15531 |
Private phone
The private phone number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Phone | Text (20) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PrivPh | The database field name. |
| API identifier | privatePhone | The API identifier used in GraphQL. |
| Number | 15550 |
Reminder printing date
The date when the last reminder got printed for the customer.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RemPrDt | The database field name. |
| API identifier | reminderPrintingDate | The API identifier used in GraphQL. |
| Number | 15643 |
Responsible
The official for the associate.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Rsp | The database field name. |
| API identifier | official | The API identifier used in GraphQL. |
| Number | 15559 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Official |
|
Sector
A group to which the associate belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trade | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Trade | The database field name. |
| API identifier | sector | The API identifier used in GraphQL. |
| Number | 15587 |
Seller
The seller who is responsible for the customer.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Seller | The database field name. |
| API identifier | seller | The API identifier used in GraphQL. |
| Number | 15557 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | 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.
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.| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Name | Text (80) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Shrt | The database field name. |
| API identifier | shortName | The API identifier used in GraphQL. |
| Number | 15547 |
Title
The professional title for a private individual.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Name | Text (80) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Title | The database field name. |
| API identifier | title | The API identifier used in GraphQL. |
| Number | 15555 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ToDt | The database field name. |
| API identifier | toDate | The API identifier used in GraphQL. |
| Number | 15604 |
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.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trade area | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExVat | The database field name. |
| API identifier | tradeArea | The API identifier used in GraphQL. |
| Number | 15570 |
Turnover
The annual turnover.
This is only used for information purposes.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Turn | The database field name. |
| API identifier | turnover | The API identifier used in GraphQL. |
| Number | 15590 |
VAT reg. no.
VAT registration number for the company.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisation no. | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EUTaxNo | The database field name. |
| API identifier | euVatRegistrationNo | The API identifier used in GraphQL. |
| Number | 15620 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Post code | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ViPNo | The database field name. |
| API identifier | visitPostCode | The API identifier used in GraphQL. |
| Number | 15641 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Postal address | VisitPostalAddress |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ViPArea | The database field name. |
| API identifier | visitPostalArea | The API identifier used in GraphQL. |
| Number | 15642 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | IntAd1 | The database field name. |
| API identifier | webPage1 | The API identifier used in GraphQL. |
| Number | 15627 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | IntAd2 | The database field name. |
| API identifier | webPage2 | The API identifier used in GraphQL. |
| Number | 15628 |
Your ref.
The customer's/supplier's reference.
The reference is suggested on orders for the customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Reference | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | YrRef | The database field name. |
| API identifier | yourReference | The API identifier used in GraphQL. |
| Number | 15618 |
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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed by user
The name of the user that changed the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A unique column number. |
Process no
The Process no. from the Active company process table which is currently using or has control of this record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |