Factoring invoice information

This table is used to add factoring text to electronic invoices sent using Visma.net AutoInvoice.

When invoicing using factoring, the factoring company requires a specific text to be included on the invoice. On print forms you may add this text directly, but this won't be included in the XML when sending to Visma.net AutoInvoice.

You can add one or several rows per Fact. company no./CID-def. with a text to include as a note in the invoice XML. You can differentiate the text per language, by adding a Language no.. Then, the rows corresponding with the Language no. on the order will be used. When invoicing using a Fact. company no./CID-def. reference, this text will be used as a note in the invoice XML.

Fact. company no./CID-def.

The factoring company that the text is used for.

Must be set for the factoring text to be used when invoicing. The field has a lookup to the Factoring company table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Factoring no.	Integer
SQL name	FCNo	The database field name.
API identifier	factoringCompanyNo	The API identifier used in GraphQL.
Number	18800

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Factoring company	FactoringInvoiceInformation	Fact. company no./CID-def.	Fact. company no./CID-def.

Language no.

Used to differentiate if there are multiple texts for the same Factoring company.

If the Factoring company only has the factoring text in one language, this field is not required. If there are multiple rows with the same Factoring company, the order's Language no. will be used to find the correct factoring text.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Language no.	Integer
SQL name	Lang	The database field name.
API identifier	languageNo	The API identifier used in GraphQL.
Number	18801

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Language	Language	Language no.	Language no.

Line no.

Primary key.

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.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
Primary key	Yes	Line no.
SQL name	LnNo	The database field name.
API identifier	lineNo	The API identifier used in GraphQL.
Number	18799

Text

The text the factoring company wants included in the invoice.

This text will be set as Note in the XML invoice. Any other Note content will be added after the factoring text.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	String of length 1000	Text (1000)
SQL name	Txt	The database field name.
API identifier	text	The API identifier used in GraphQL.
Number	18802

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 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 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.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

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.

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.