Factoring company

This table contains one row for each factoring company or CID code rule.

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL nameFactCompThe table name in the database.
API identifierfactoringCompanyThe API identifier used in GraphQL.
Table no.217The table number in the data model.

The following fields exist in this table:

Agio voucher type for currency 2

Select voucher type for currency 2 not using standard agio/disagio general ledger accounts.

The voucher type that is used for exchange rate variations on payments when Currency no 2 is used, and you do not want to use standard agio/disagio general ledger accounts which are defined in the agio voucher type.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainVoucher typeInteger
SQL nameAgioVTp2The database field name.
API identifieragioVoucherTypeForCurrency2The API identifier used in GraphQL.
Number15481 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
Voucher typeVoucherType
  • Agio voucher type for currency 2

Bank account

The client's bank account number.

To be able to load OCR transactions from several bank accounts for a client, you must define which bank account is to be used.

This field is used when importing incoming payments from Visma.net AutoPay, and by some external EFT systems.

Note:
For Visma.net AutoPay both IBAN and BBAN can be entered in this field. The import routine for incoming payments is able to match both against bank account in the import file.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBank accountText (35)
SQL nameBGiroThe database field name.
API identifierbankAccountThe API identifier used in GraphQL.
Number12765 

CID Company no. of digits

How many characters are to be used by the company number in the CID code.

If this field is filled in, the CID is filled in with preceding zeros. This field is only read by some EFT systems. On invoices,Transfer to debt collection and List debt collection related transactions the company number must come first in the CID code; otherwise the cust. no, invoice number and check digit must come first.

Note:
You cannot use this field if you have to load data into the internal OCR routine.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNumber of digitsInteger
SQL nameCIDFrmThe database field name.
API identifiercidCompanyNoDigitsThe API identifier used in GraphQL.
Number13032 

CID cust./suppl. chars.

How many digits the cust. no. part of the CID code is to consist of.

How many digits the cust. no. part of the CID code is to consist of. The cust. no. part may be up to 10 digits. If the cust. no. is shorter, leading zeros are inserted. If it is longer, the digits are counted from the back and the internal OCR routine will not work to find the cust. no. The field is used by some EFT systems.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNumber of digitsInteger
SQL nameCIDCustThe database field name.
API identifiercidCustomerOrSupplierNoDigitsThe API identifier used in GraphQL.
Number12255 

CID factoring chars

How many characters are to be used from the Factoring ID field between the customer and reference number parts of the CID code produced by the CID code macro.

How many characters are to be used from the Factoring ID field between the customer and reference number parts of the CID code which is produced with the CID code macro in order documents, reminders and interest forms. See the description of the @CID macro in the chapter on order documents in the system specification for logistics, or the chapter on reminders and interest calculation in the system specification for accounting.

The field is used by some EFT systems.

Note:
You cannot use this field if you have to upload data into the internal OCR routine.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNumber of digitsInteger
SQL nameCIDFactThe database field name.
API identifiercidFactoringCharsThe API identifier used in GraphQL.
Number12229 

CID ref. no. digits

How many digits the reference number part of the CID code is to consist of.

How many digits the reference number part of the CID code is to consist of. The reference number part may be up to 9 digits. If the reference number is shorter, leading zeros are inserted. If it is longer, the digits are counted from the back and the internal OCR routine will not find the invoices that are to be matched. The field is used by some EFT systems.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNumber of digitsInteger
SQL nameCIDRefThe database field name.
API identifiercidReferenceNoDigitsThe API identifier used in GraphQL.
Number12259 

Direct debit. status after export

The direct. deb. status the customer should get in the Associate table after the export.

Valid values are:

  • 2. Has agreement without notification
  • 3. Has agreement with notification

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
SQL nameDirDebStThe database field name.
API identifierdirectDebitingStatusAfterExportThe API identifier used in GraphQL.
Number15478 

Fact. processing

Whether payments are to be treated as Factoring company, OCR Definition, Debt collection list or Debt collection list changes.

In the print dialog box for invoicing and In the dialog boxes for processings Factoring, Transfer to debt collection, List debt collection related transactions you only bring up valid values on the basis of what you have selected in the Fact. processing field.

This information is also used by EFT systems. When the row shall be used as a CID definition for incoming payments, OCR Definition must be selected in the Fact. processing dialog.

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

Type

Factoring company
OCR Definition
Must be set if the row is a CID definition that shall be used when importing incoming payments.
Debt collection list
Debt collection list changes
Autogiro
Avtalegiro

Generate voucher at Direct debiting receipt

If you have selected the Autogiro or Avtalegiro in the Fact. processing dialog box, the fields under Generate voucher at Direct debiting receipt in the same dialog box become activated.

Do not create voucher before payment of agreement
If you select this field the voucher for Autogiro/AvtaleGiro is created before payment agreement. This selection can be used for example for debiting of voluntary memberships.
Look for new payment agreements
This selection can be used when payment agreements are generated for the bank. Only special formats open for this option. Function for sending new Autogiro agreements, this selection does not apply to AvtaleGiros.
Create payment file from payment agreements
If you select this field, a dialog box appears for selecting the date for which agreements will be imported into transfer funds when exporting.
Ask for number of days at next payment
If you select this field, you will be asked about the number of days at next payment agreement.
Generate CID exchange file
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainFact. processingInteger
SQL nameFactProThe database field name.
API identifierfactoringProcessingThe API identifier used in GraphQL.
Number7831 

Fact. company no./CID-def.

A unique number identifying factoring company.

Note:
If you press + in this field, the next available number is suggested. Gaps in the number series resulting from any deleted rows are not suggested. If you enter an existing number you will receive an error message. The number cannot be changed once it is entered.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainFactoring no.Integer
Primary keyYesFact. company no./CID-def.
SQL nameFCNoThe database field name.
API identifierfactoringCompanyNoThe API identifier used in GraphQL.
Number7549 

Factoring CID-def.

Define how the CID codes are to be built up for factoring.

The definition in this field is used by the @CID macro in order documents when factoring is selected in the order document dialog box.

Looking up in the field leads to a dialog box with a selection of the macro functions which apply to order documents (see the system specification for logistics) and the macro function @Modulus (). You have the following options:
  • @System (Field name)
  • @Firm (Field name)
  • @Factor (Field name)
  • @DokNr ()
  • @Order(Field name)
  • @DocDate ()
  • @Modulus ()
  • @Factoring companies and CID def (Field name)

The default CID code is Customer no. + Factoring ID + Invoice no. + Check digit.

Field length

In the same way as with the macro functions in the Form element table, you can, before the right bracket, include a vertical line (|) followed by an integer which indicates the number of characters the field is to have.

  • If the number of characters is less, leading zeros are added.
  • If the number of characters was less, the characters are kept from the back.

This applies regardless of whether the macro function returns numbers or text.

@Modulus ()

This macro function returns a modulus 10 check digit, or a modulus 11 check digit. If 11 is entered as the parameter for the function. The check digit is calculated from numbers that comes earlier in the field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainFactoring CID-def.Text (128)
SQL nameFactCIDThe database field name.
API identifierfactoringCidDefinitionThe API identifier used in GraphQL.
Number12230 

Factoring customer

Enter the cust. no. defining the factoring company in the Associate table to which all ledger entries are posted.

For factoring the factoring company is entered as a customer and you refer to this customer in the Factoring customer field. This cust. no. will be used in the voucher lines for orders. The field can also be used in debt collection routines to upload information to the debt collection agency from this cust. no. in the EDI file.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCust. no.Integer
SQL nameFactCustThe database field name.
API identifierfactoringCustomerNoThe API identifier used in GraphQL.
Number12227 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateFactoringCustomer
  • Factoring customer

Factoring file

The path and the name of the imp file to be used by default when you send data to the factoring company.

Only used by processings Factoring, Transfer to debt collection and List debt collection related transactions.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainData filenameText (260)
SQL nameFactFNmThe database field name.
API identifierfactoringFileNameThe API identifier used in GraphQL.
Number7551 

Factoring ID

Your cust. no. with the factoring company. This field is a part of the CID code.

You can also use the field for a different fixed value that is to be included in the CID code and that is not defined elsewhere.

When the row is used as CID definition for incoming payments (OCR Definition is selected in the Fact. processing field):
  • Start position for customer no. and invoice no. can be entered, separated by ; (semicolon).
  • E.g. format 1;7 means that the customer number starts in position 1 and the invoice number starts in position 7 in the CID field.
  • If the customer no. or the invoice no. is not a part of the CID, set 0 in the position.
  • If you enter 0;0 in this field, the import routine will take the CID from the import file and search directly in the CID code column in the Open customer entry table to find a match. No splitting of the CID code will be performed, meaning that it is not necessary to enter any value in the length fields like CID cust./suppl. chars. and CID ref. no. digits.
    Note:
    This is the recommended method, if the CID code is filled out on all invoices in the Open customer entry table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainFactoring IDText (6)
SQL nameFactIDThe database field name.
API identifierfactoringIdThe API identifier used in GraphQL.
Number12228 

Fixed account for non-reconciled payment received

If the account number is filled in, a non-reconciliated payment will be assigned to this account.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameEftErrAcThe database field name.
API identifierfixedAccountNoForNonReconciliatedPaymentReceivedThe API identifier used in GraphQL.
Number15480 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountFixedAccountForNonReconciliatedPaymentReceived
  • Fixed account for non-reconciled payment received

Free text-reconciliation field

Enter rules for free text-reconciliation.

Please refer to the ConvertX documentation for the syntax.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainTextText (260)
SQL nameFrTxtReFThe database field name.
API identifierfreeTextReconciliationFieldThe API identifier used in GraphQL.
Number15474 

GL account, bank fee

Is only used by some EFT systems to generate vouchers.

This field has no function in Business NXT.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameRmtFeeAcThe database field name.
API identifierfeeAccountNoThe API identifier used in GraphQL.
Number14537 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountFeeAccount
  • GL account, bank fee

Import file

The path and the name of the default imp file to be used when you import data from the factoring company.

The default files are in the Program files/imp folder. The import file is the file that describes the format in which data is to be saved. Select the import file that has been set up for the factoring company or debt collection company that you are to send the data to. This field is only used by processings Factoring, Transfer to debt collection and List debt collection related transactions.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainData filenameText (260)
SQL nameImpFNmThe database field name.
API identifierimportFileNameThe API identifier used in GraphQL.
Number7550 

Last run date

Shows date for uploading the factoring file or the debt collection file.

The date is set by the system.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDateInteger
SQL nameLstRnDtThe database field name.
API identifierlastRunDateThe API identifier used in GraphQL.
Number7552 

Last run no.

Shows how many files or debt collection files have been uploaded on this day.

This field is automatically updated.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
SQL nameLstRnNoThe database field name.
API identifierlastRunNoThe API identifier used in GraphQL.
Number7553 

Length for extra invoice no. search

An alternate length for the invoice number.

In this field you can define another length for the invoice number than the one defined in the CID ref. no. digits field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
SQL nameLnInvSrcThe database field name.
API identifierlengthForExteraInvoiceNoSearchThe API identifier used in GraphQL.
Number15479 

Name

The name of factoring company.

The system displays this name in the dialog box when you run the factoring routine. The field is used by some EFT systems.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNameText (80)
SQL nameNmThe database field name.
API identifiernameThe API identifier used in GraphQL.
Number12423 

No. of days before withdrawal

The number of days before the next deduction.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
SQL nameDyBefDedThe database field name.
API identifiernoOfDaysBeforeWithdrawalThe API identifier used in GraphQL.
Number15477 

OCR bank account no.

The general ledger account for the factoring company.

You must define which general ledger account is to be used to be able to load OCR transactions from several bank accounts for a client. This field has no function in Business NXT, but is used by external systems.
Note:
The field is only used to import OCR via ConvertX.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameOCRAcBThe database field name.
API identifierocrBankAccountNoThe API identifier used in GraphQL.
Number12766 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountCidBankAccount
  • OCR bank account no.

Organisational unit 1

The field is used to specify organisational unit.

When importing incoming payments from Visma.net AutoPay, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the bank account in the General ledger account table will be used.

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

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

Organisational unit 2

The field is used to specify organisational unit.

When importing incoming payments from Visma.net AutoPay, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the bank account in the General ledger account table will be used.

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

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

Organisational unit 3

The field is used to specify organisational unit.

When importing incoming payments from Visma.net AutoPay, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the bank account in the General ledger account table will be used.

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

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

Organisational unit 4

The field is used to specify organisational unit.

When importing incoming payments from Visma.net AutoPay, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the bank account in the General ledger account table will be used.

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

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

Organisational unit 5

The field is used to specify organisational unit.

When importing incoming payments from Visma.net AutoPay, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the bank account in the General ledger account table will be used.

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

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

Organisational unit 6

The field is used to specify organisational unit.

When importing incoming payments from Visma.net AutoPay, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the bank account in the General ledger account table will be used.

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

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

Organisational unit 7

The field is used to specify organisational unit.

When importing incoming payments from Visma.net AutoPay, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the bank account in the General ledger account table will be used.

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

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

Organisational unit 8

The field is used to specify organisational unit.

When importing incoming payments from Visma.net AutoPay, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the bank account in the General ledger account table will be used.

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

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

Organisational unit 9

The field is used to specify organisational unit.

When importing incoming payments from Visma.net AutoPay, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the bank account in the General ledger account table will be used.

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

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

Organisational unit 10

The field is used to specify organisational unit.

When importing incoming payments from Visma.net AutoPay, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the bank account in the General ledger account table will be used.

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

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

Organisational unit 11

The field is used to specify organisational unit.

When importing incoming payments from Visma.net AutoPay, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the bank account in the General ledger account table will be used.

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

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

Organisational unit 12

The field is used to specify organisational unit.

When importing incoming payments from Visma.net AutoPay, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the bank account in the General ledger account table will be used.

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

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

Payment processing

Processing rules for the payment.

Through the dialog box you can override the parameters found in EFT processing field in the EFT information table.

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

CID code generating

No leading zeros in customer/supp. no.
The customer/supplier number parts in the CID codes will not be completed with leading zeros when the number of digits is less than that stated in the CID cust./suppl. chars. field. This is normally used together with the Length digit check box in Swedish payment transfer.
Length digit
A length digit will be included before the check digit which shows the last digit in the total number of characters in the CID code (including the length digit and check digit). (The length digit is also included in the check digit calculation.) This is used in Swedish postal giros, among other things.
Finnish CID calculation
Modulus 10 check digits will be replaced by the algorithm for Solo reference payments. This is used in Finland.
Invoice no. first

The default CID code will be generated with the invoice number first. The order will then be as follows:

Invoice reference + Factoring ID + Customer number + Control digits.

The system will then produce a reversed CID code in connection with invoice printing and on importing OCR files. This enables the CID code to be imported in other accounting systems which expect an OCR with invoice number + customer number or receive OCR produced from accounting systems which have the invoice number before the customer number.

Note:
You must not use this parameter together with No leading zeros in customer/supp. no.

This field is also included in the Factoring company table and is activated when using Def. Factoring companys/CID code def.

Use customer no. as CID
You will only get the customer number and check digit in the CID code when you print invoices, interest notes and reminders.
Use Invoice no. as CID
You will only get the invoice number and check digit in the CID code when you print invoices, interest notes and reminders.

Payment suggestion

Payment if giro no.
Create payments only for transaction where Bank account or Postal giro is specified in Associate table, or Bank account is specified on the Open supplier entry.
Use bank partner from supplier/customer
Used as default value for the corresponding field in the Create payment suggestion processing dialog.

Processing when importing from EFT system

Prepayment
Some external EFT system processes OCR transactions for a specified series of advance payments that do not have open entries, but only advance orders that have not been invoiced. The order will be looked up and the suspension on the advance payment will be lifted when this payment is updated. You will find more about advance payments in the section about Advance payment.
Update bank account
Some EFT systems updates the bank account/postal giro for suppliers/customers if the format contains sufficient information to find suppliers/customers with an advanced search.
Generate batch/vouchers for settlement
The batch is created by the EFT system when the settlement is returned, and you cannot use the Create account batch processing in the Payment line table.

Control EFT system at payment

Control CID when importing
The CID code will be checked during data import.
Control if invoice no. is in the CID field
This field is used when the CID code field does not contain a complete CID code. This is common for payments from Sweden.
Only show CID sum
Only the sum per account is shown on the CID report.

Look up in open entries table

Search in open customer entries
Used by some EFT systems. Search for transactions will be done in the Open customer entry table.
Search in customer transactions
Used by some EFT systems. Search for transactions will be done in the Customer transaction table.
Search in open supplier entries
Used by some EFT systems. Search for transactions will be done in the Open supplier entry table.
Search in supplier transactions
Used by some EFT systems. Search for transactions will be done in the Supplier transaction table.

Matching rules

Invoice no. = one invoice
A search will be performed for invoice numbers in the invoice number field or the CID field in the file, and a row will be entered with the amount that has been paid.
Transaction info = Sum invoice
A search will be performed for invoice numbers from the text field in the file, and rows will be entered for the invoice numbers that are found. The outstanding amount will be entered as a separate row without a reference.
Customer no. + Amount = One invoice
A search will be performed for invoice numbers based on customer number in the customer number field or the CID field in the file. This rule will only add a row if the amount paid is equal to an open entry.
Transaction info + Customer no. + Amount = Sum Invoice
A search will be performed for all available invoices for customer numbers found in the text field in the field, and all the invoices will then be settled with the amount that has been paid.
Account no. + Amount = Sum Invoice
A search will be performed for all customers which have specified account numbers and open entries. The EFT system will then begin to settle the invoices that are found from the oldest invoice onwards.

Posting

Bank transaction per date
The bank transactions will be posted per date.
Bank transaction per Archive reference/batch
The bank transactions will be posted per archive reference/batch.
Bank transaction per transaction reference
The bank transactions will be posted per transaction reference.
Post rest amount in own customer record when invoice reference is missing
The outstanding amount will be posted if no references are found. If you have not selected this field, the outstanding amount will be settled against open entries according to the oldest date first.
Post difference record per processed record
Difference record per payment with a payment difference is produced.
Use open entries table for difference record
This field is not in use.
Use Cross reference table when paying
The Cross reference field is not used on the voucher line, but the Cross reference table is used instead when you are creating payments.
Use cross reference table when receiving payments
The Cross reference field is not used on the voucher line, but the Cross reference table is used instead when you retrieve OCR data.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainPayment processingInteger
SQL nameCIDProcThe database field name.
API identifierpaymentProcessingThe API identifier used in GraphQL.
Number12231 

SQL filter special processing

Used to omit customers who will not be automatically reconciled.

For example CustNo <> 12345. This means that you omit all customers aside from cust. no. 12345. It is only cust. no. 12345 who will be automatically reconciled.

We refer to the documentation from Z Data which uses this field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainTextText (260)
SQL nameSqlFltSPThe database field name.
API identifiersqlFilterSpecialProcessingThe API identifier used in GraphQL.
Number15473 

Voucher series no.

The voucher series that OCR transactions should use.

To be able to load OCR transactions from several bank accounts for a client, you must define which voucher series the OCR transactions are to use. This field has no function in Business NXT, but is used by some external EFT systems.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainVoucher series no.Integer
SQL nameVoSrThe database field name.
API identifiervoucherSeriesNoThe API identifier used in GraphQL.
Number12767 
Table 18. Table relations
To tablePurposeFrom columnsTo columnsComments
Voucher seriesVoucherSeries
  • Voucher series no.

Wrap text on keyword 1

Key words that trigger a text wrapping.

With longer text messages, the text will be wrapped on specified words.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNameText (80)
SQL nameBrkTxt1The database field name.
API identifierwrapTextOnKeyword1The API identifier used in GraphQL.
Number15475 

Wrap text on keyword 2

Key words that trigger a text wrapping.

With longer text messages, the text will be wrapped on specified words.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNameText (80)
SQL nameBrkTxt2The database field name.
API identifierwrapTextOnKeyword2The API identifier used in GraphQL.
Number15476 

Control columns

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

Changed by provenance

The provenance for the record change.

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

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

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

Changed by user

The name of the user that changed the record.

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

Changed date

The date when the record was changed.

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

Changed time

The time when the record was changed.

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

Changed time stamp

The date and time when the record was changed.

The field is updated with the UTC time.

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

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

Created by provenance

The provenance for the record creation.

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

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

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

Created by user

The name of the user that created the record.

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

Created date

The date when the record was created.

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

Created time

The time when the record was created.

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

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

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

Edit status

The current status of the record.

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

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

1 - Inserted: The record is new.

2 - Changed: The record is changed.

3 - Deleted: The record is deleted.

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

Process no

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

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