Factoring company
This table contains one row for each factoring company or CID code rule.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | FactComp | The table name in the database. |
| API identifier | factoringCompany | The API identifier used in GraphQL. |
| Table no. | 217 | The 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher type | Integer |
| SQL name | AgioVTp2 | The database field name. |
| API identifier | agioVoucherTypeForCurrency2 | The API identifier used in GraphQL. |
| Number | 15481 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Voucher type | VoucherType |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank account | Text (35) |
| SQL name | BGiro | The database field name. |
| API identifier | bankAccount | The API identifier used in GraphQL. |
| Number | 12765 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Number of digits | Integer |
| SQL name | CIDFrm | The database field name. |
| API identifier | cidCompanyNoDigits | The API identifier used in GraphQL. |
| Number | 13032 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Number of digits | Integer |
| SQL name | CIDCust | The database field name. |
| API identifier | cidCustomerOrSupplierNoDigits | The API identifier used in GraphQL. |
| Number | 12255 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Number of digits | Integer |
| SQL name | CIDFact | The database field name. |
| API identifier | cidFactoringChars | The API identifier used in GraphQL. |
| Number | 12229 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Number of digits | Integer |
| SQL name | CIDRef | The database field name. |
| API identifier | cidReferenceNoDigits | The API identifier used in GraphQL. |
| Number | 12259 |
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
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | DirDebSt | The database field name. |
| API identifier | directDebitingStatusAfterExport | The API identifier used in GraphQL. |
| Number | 15478 |
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.
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
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Fact. processing | Integer |
| SQL name | FactPro | The database field name. |
| API identifier | factoringProcessing | The API identifier used in GraphQL. |
| Number | 7831 |
Fact. company no./CID-def.
A unique number identifying factoring company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Factoring no. | Integer |
| Primary key | Yes | Fact. company no./CID-def. |
| SQL name | FCNo | The database field name. |
| API identifier | factoringCompanyNo | The API identifier used in GraphQL. |
| Number | 7549 |
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.
- @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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Factoring CID-def. | Text (128) |
| SQL name | FactCID | The database field name. |
| API identifier | factoringCidDefinition | The API identifier used in GraphQL. |
| Number | 12230 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Cust. no. | Integer |
| SQL name | FactCust | The database field name. |
| API identifier | factoringCustomerNo | The API identifier used in GraphQL. |
| Number | 12227 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | FactoringCustomer |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Data filename | Text (260) |
| SQL name | FactFNm | The database field name. |
| API identifier | factoringFileName | The API identifier used in GraphQL. |
| Number | 7551 |
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.
- 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Factoring ID | Text (6) |
| SQL name | FactID | The database field name. |
| API identifier | factoringId | The API identifier used in GraphQL. |
| Number | 12228 |
Fixed account for non-reconciled payment received
If the account number is filled in, a non-reconciliated payment will be assigned to this account.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | EftErrAc | The database field name. |
| API identifier | fixedAccountNoForNonReconciliatedPaymentReceived | The API identifier used in GraphQL. |
| Number | 15480 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | FixedAccountForNonReconciliatedPaymentReceived |
|
Free text-reconciliation field
Enter rules for free text-reconciliation.
Please refer to the ConvertX documentation for the syntax.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (260) |
| SQL name | FrTxtReF | The database field name. |
| API identifier | freeTextReconciliationField | The API identifier used in GraphQL. |
| Number | 15474 |
GL account, bank fee
Is only used by some EFT systems to generate vouchers.
This field has no function in Business NXT.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | RmtFeeAc | The database field name. |
| API identifier | feeAccountNo | The API identifier used in GraphQL. |
| Number | 14537 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | FeeAccount |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Data filename | Text (260) |
| SQL name | ImpFNm | The database field name. |
| API identifier | importFileName | The API identifier used in GraphQL. |
| Number | 7550 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | LstRnDt | The database field name. |
| API identifier | lastRunDate | The API identifier used in GraphQL. |
| Number | 7552 |
Last run no.
Shows how many files or debt collection files have been uploaded on this day.
This field is automatically updated.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | LstRnNo | The database field name. |
| API identifier | lastRunNo | The API identifier used in GraphQL. |
| Number | 7553 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | LnInvSrc | The database field name. |
| API identifier | lengthForExteraInvoiceNoSearch | The API identifier used in GraphQL. |
| Number | 15479 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| SQL name | Nm | The database field name. |
| API identifier | name | The API identifier used in GraphQL. |
| Number | 12423 |
No. of days before withdrawal
The number of days before the next deduction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | DyBefDed | The database field name. |
| API identifier | noOfDaysBeforeWithdrawal | The API identifier used in GraphQL. |
| Number | 15477 |
OCR bank account no.
The general ledger account for the factoring company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | OCRAcB | The database field name. |
| API identifier | ocrBankAccountNo | The API identifier used in GraphQL. |
| Number | 12766 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | CidBankAccount |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R1 | The database field name. |
| API identifier | orgUnit1 | The API identifier used in GraphQL. |
| Number | 18485 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R2 | The database field name. |
| API identifier | orgUnit2 | The API identifier used in GraphQL. |
| Number | 18486 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R3 | The database field name. |
| API identifier | orgUnit3 | The API identifier used in GraphQL. |
| Number | 18487 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R4 | The database field name. |
| API identifier | orgUnit4 | The API identifier used in GraphQL. |
| Number | 18488 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R5 | The database field name. |
| API identifier | orgUnit5 | The API identifier used in GraphQL. |
| Number | 18489 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R6 | The database field name. |
| API identifier | orgUnit6 | The API identifier used in GraphQL. |
| Number | 18490 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
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.
| 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) |
| SQL name | R7 | The database field name. |
| API identifier | orgUnit7 | The API identifier used in GraphQL. |
| Number | 18491 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
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.
| 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) |
| SQL name | R8 | The database field name. |
| API identifier | orgUnit8 | The API identifier used in GraphQL. |
| Number | 18492 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
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.
| 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) |
| SQL name | R9 | The database field name. |
| API identifier | orgUnit9 | The API identifier used in GraphQL. |
| Number | 18493 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
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.
| 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) |
| SQL name | R10 | The database field name. |
| API identifier | orgUnit10 | The API identifier used in GraphQL. |
| Number | 18494 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
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.
| 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) |
| SQL name | R11 | The database field name. |
| API identifier | orgUnit11 | The API identifier used in GraphQL. |
| Number | 18495 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
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.
| 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) |
| SQL name | R12 | The database field name. |
| API identifier | orgUnit12 | The API identifier used in GraphQL. |
| Number | 18496 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
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.
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Payment processing | Integer |
| SQL name | CIDProc | The database field name. |
| API identifier | paymentProcessing | The API identifier used in GraphQL. |
| Number | 12231 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (260) |
| SQL name | SqlFltSP | The database field name. |
| API identifier | sqlFilterSpecialProcessing | The API identifier used in GraphQL. |
| Number | 15473 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher series no. | Integer |
| SQL name | VoSr | The database field name. |
| API identifier | voucherSeriesNo | The API identifier used in GraphQL. |
| Number | 12767 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Voucher series | VoucherSeries |
|
Wrap text on keyword 1
Key words that trigger a text wrapping.
With longer text messages, the text will be wrapped on specified words.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| SQL name | BrkTxt1 | The database field name. |
| API identifier | wrapTextOnKeyword1 | The API identifier used in GraphQL. |
| Number | 15475 |
Wrap text on keyword 2
Key words that trigger a text wrapping.
With longer text messages, the text will be wrapped on specified words.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| SQL name | BrkTxt2 | The database field name. |
| API identifier | wrapTextOnKeyword2 | The API identifier used in GraphQL. |
| Number | 15476 |
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. |