XML mapping

In this table, it is determined in which table and column interpreted accounting data is saved.

Property	Value	Description
Database	System	This table is in the system (vbsys) database.
SQL name	XmlMap	The table name in the database.
API identifier	xmlMappingRule	The API identifier used in GraphQL.
Table no.	464	The table number in the data model.

The following fields exist in this table:

Copy from header mapping

Specifies a rule number to copy values to all lines.

Preferably use a document-level rule number.

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	Mapping rule no.	Integer
SQL name	CpRlNo	The database field name.
API identifier	copyFromHeaderMappingRuleNo	The API identifier used in GraphQL.
Number	19803

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
XML mapping	XmlMappingXmlHeaderMapping	Copy from header mapping	Mapping rule no.

Interpretation rule no.

The connected interpretation rule number.

Results from interpretation rules not listed here will be saved in the specified table and column.

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	Interpretation rule no.	Integer
SQL name	InRlNo	The database field name.
API identifier	interpretationRuleNo	The API identifier used in GraphQL.
Number	19796

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
XML interpretation rule	XmlMappingInterpretationRule	Interpretation rule no.	Rule no.

Mapping rule no.

The primary key identifying the rule.

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	Mapping rule no.	Integer
Primary key	Yes	Mapping rule no.
SQL name	RlNo	The database field name.
API identifier	ruleNo	The API identifier used in GraphQL.
Number	19795

Rule type

Automatically set to 0 - System or 10 - User defined.

User-defined rules are set to 10 - User defined by default and can't be changed to 0 - System.

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

0 - System
10 - User defined

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Rule type	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	RlTp	The database field name.
API identifier	ruleType	The API identifier used in GraphQL.
Number	19800

Suspended

You can choose not to use certain rules.

This applies to system-defined rules as well.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Boolean	Integer
SQL name	Susp	The database field name.
API identifier	suspended	The API identifier used in GraphQL.
Number	19802

Table no.

The table where you want to save the interpreted value.

You can select a table by looking up in this field.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Table no.	Integer
SQL name	TabNo	The database field name.
API identifier	tableNo	The API identifier used in GraphQL.
Number	19797

Value type

Specifies the data type to store; predefined values are available.

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

0 - Unknown
10 - Integer
20 - Decimal
30 - Text/String
40 - Date/Time

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Value type	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	VlTp	The database field name.
API identifier	valueType	The API identifier used in GraphQL.
Number	19801

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.