Case journal

This table can be used in accounting offices to get an overview of activities regarding clients.

Property	Value	Description
Database	Company	This table is in the company databases.
SQL name	TaskJ	The table name in the database.
API identifier	taskJournal	The API identifier used in GraphQL.
Table no.	244	The table number in the data model.

The following fields exist in this table:

Actual end date

The actual end date.

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	REndDt	The database field name.
API identifier	actualEndDate	The API identifier used in GraphQL.
Number	9073

Agreed end date

The agreed end date.

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	AgEndDt	The database field name.
API identifier	agreedEndDate	The API identifier used in GraphQL.
Number	9072

Agreement revised

The date on which the agreement with the client was last revised.

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	AgrRevDt	The database field name.
API identifier	agreementRevisedDate	The API identifier used in GraphQL.
Number	9108

Annual report

The date on which the annual report was run for your client.

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	AnStlDt	The database field name.
API identifier	annualReportDate	The API identifier used in GraphQL.
Number	9103

Auditor

The number of the auditor in the Associate 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	Associate no.	Integer
SQL name	AudActNo	The database field name.
API identifier	auditor	The API identifier used in GraphQL.
Number	9101

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	Auditor	Auditor	Associate no.

Case jour. no.

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	No	This field is not visible by default in the table display.
Domain	No.	Integer
Primary key	Yes	Case jour. no.
SQL name	JNo	The database field name.
API identifier	taskJournalNo	The API identifier used in GraphQL.
Number	9069

Case responsible

A case responsible number.

The Empl. no. is a unique number identifying one specific Employee.

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	Empl. no.	Integer
SQL name	SuitP	The database field name.
API identifier	caseOfficial	The API identifier used in GraphQL.
Number	9078

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	CaseOfficial	Case responsible	Empl. no.

Case type

A describtion of the case.

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

Central register

The date on which the client's accounts were sent to the central register.

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	PbArDt	The database field name.
API identifier	centralRegisterDate	The API identifier used in GraphQL.
Number	9105

Changed share capital

The date on which the client's share capital was changed.

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	ChEqDt	The database field name.
API identifier	changedShareCapitalDate	The API identifier used in GraphQL.
Number	9098

Contact

The contact person at the client.

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	Associate no.	Integer
SQL name	LiaActNo	The database field name.
API identifier	contact	The API identifier used in GraphQL.
Number	9079

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	Contact	Contact	Associate no.

Cust. no.

The client's customer 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	Cust. no.	Integer
SQL name	CustNo	The database field name.
API identifier	customerNo	The API identifier used in GraphQL.
Number	9070

Table 4. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	Customer	Cust. no.	Cust. no.

Date 1

Optional field for additional dates.

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	Dt1	The database field name.
API identifier	date1	The API identifier used in GraphQL.
Number	12935

Date 2

Optional field for additional dates.

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	Dt2	The database field name.
API identifier	date2	The API identifier used in GraphQL.
Number	12936

Date 3

Optional field for additional dates.

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	Dt3	The database field name.
API identifier	date3	The API identifier used in GraphQL.
Number	12937

Date 4

Optional field for additional dates.

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	Dt4	The database field name.
API identifier	date4	The API identifier used in GraphQL.
Number	12938

Date 5

Optional field for additional dates.

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	Dt5	The database field name.
API identifier	date5	The API identifier used in GraphQL.
Number	12939

Date 6

Optional field for additional dates.

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	Dt6	The database field name.
API identifier	date6	The API identifier used in GraphQL.
Number	12940

Date 7

Optional field for additional dates.

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	Dt7	The database field name.
API identifier	date7	The API identifier used in GraphQL.
Number	12941

Date 8

Optional field for additional dates.

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	Dt8	The database field name.
API identifier	date8	The API identifier used in GraphQL.
Number	12942

Date 9

Optional field for additional dates.

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	Dt9	The database field name.
API identifier	date9	The API identifier used in GraphQL.
Number	12943

Date 10

Optional field for additional dates.

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	Dt10	The database field name.
API identifier	date10	The API identifier used in GraphQL.
Number	12944

Date 11

Optional field for additional dates.

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	Dt11	The database field name.
API identifier	date11	The API identifier used in GraphQL.
Number	12945

Date 12

Optional field for additional dates.

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	Dt12	The database field name.
API identifier	date12	The API identifier used in GraphQL.
Number	12946

Date 13

Optional field for additional dates.

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	Dt13	The database field name.
API identifier	date13	The API identifier used in GraphQL.
Number	12947

Date 14

Optional field for additional dates.

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	Dt14	The database field name.
API identifier	date14	The API identifier used in GraphQL.
Number	12948

Delivered date

A date for delivery.

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	SentDt	The database field name.
API identifier	deliveredDate	The API identifier used in GraphQL.
Number	9084

Deliv. tax statement

The date on which you delivered the client's tax statement.

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	TxRetDt	The database field name.
API identifier	deliveredTaxStatementDate	The API identifier used in GraphQL.
Number	9106

Empl. no.

An employee number.

The Empl. no. is a unique number identifying one specific Employee.

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	Empl. no.	Integer
SQL name	EmpNo	The database field name.
API identifier	employeeNo	The API identifier used in GraphQL.
Number	9077

Table 5. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	Employee	Empl. no.	Empl. no.

Final accounting

The date on which the final accounts for the client were ready.

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	FinAcDt	The database field name.
API identifier	finalAccountingDate	The API identifier used in GraphQL.
Number	9100

FP lists sent

The date when you sent the Holiday Allowance list.

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	HolAlSDt	The database field name.
API identifier	holidayAllowanceListSentDate	The API identifier used in GraphQL.
Number	9090

Inf. 1

Additional case journal information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf1	The database field name.
API identifier	information1	The API identifier used in GraphQL.
Number	9109

Inf. 2

Additional case journal information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf2	The database field name.
API identifier	information2	The API identifier used in GraphQL.
Number	9110

Inf. 3

Additional case journal information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf3	The database field name.
API identifier	information3	The API identifier used in GraphQL.
Number	9111

Inf. 4

Additional case journal information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf4	The database field name.
API identifier	information4	The API identifier used in GraphQL.
Number	9112

Inf. 5

Additional case journal information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf5	The database field name.
API identifier	information5	The API identifier used in GraphQL.
Number	9113

Inf. 6

Additional case journal information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf6	The database field name.
API identifier	information6	The API identifier used in GraphQL.
Number	9114

Invoiced

The date on which you invoiced your client.

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	Invd	The database field name.
API identifier	invoicedDate	The API identifier used in GraphQL.
Number	9094

Invoiced date

The planned date for invoicing.

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	InvngDt	The database field name.
API identifier	invoicingDate	The API identifier used in GraphQL.
Number	9088

Memo file name

If you link a memo to the Voucher line, this field will refer a file name.

If you do not specify a file name yourself, Business NXT will automatically suggest a file name.

On the Editing menu, click Memo to create a new memo or to view the existing memo. The memo file name is saved in this text box.

Double-click or press * to open the Select file dialog box to manually select a memo file.

Note:

It is important that you save the file on a server and in a folder that is available to all users, otherwise users who try to open the memo will receive an error message.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Memo file name	Text (260)
SQL name	NoteNm	The database field name.
API identifier	memoFileName	The API identifier used in GraphQL.
Number	9115

Memo no.

Link to the memo for the entry.

The actual memo is stored in the Memo 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	Memo no.	Integer
SQL name	MemoNo	The database field name.
API identifier	memoNo	The API identifier used in GraphQL.
Number	19247

Table 6. Table relations
To table	Purpose	From columns	To columns	Comments
Memo	Memo	Memo no.	Memo no.

Monthly up to date

The date on which the month was up to date.

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	MtAjDt	The database field name.
API identifier	monthlyUpToDate	The API identifier used in GraphQL.
Number	9097

PAYE report

The date on which the PAYE reports for your client were finished.

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	WDSDt	The database field name.
API identifier	payeReportDate	The API identifier used in GraphQL.
Number	9091

Payroll finished

The date on which the payroll run was finished for your client.

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	WgFinDt	The database field name.
API identifier	payrollFinishedDate	The API identifier used in GraphQL.
Number	9089

Period

The period.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Period	Integer
SQL name	Pr	The database field name.
API identifier	period	The API identifier used in GraphQL.
Number	9075

Period rep. finished

The date on which you finished the period report for your client.

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	RepFDt	The database field name.
API identifier	periodReportFinishedDate	The API identifier used in GraphQL.
Number	9081

Preliminary accounting

The date on which you had preliminary accounts finished.

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	SkAcDt	The database field name.
API identifier	preliminaryAccountingDate	The API identifier used in GraphQL.
Number	9099

Reconciled

The date on which you last ran reconciliation.

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	TallyDt	The database field name.
API identifier	reconciledDate	The API identifier used in GraphQL.
Number	9087

Registration date

The date on which you registered the vouchers for your client.

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	PuncDt	The database field name.
API identifier	registrationDate	The API identifier used in GraphQL.
Number	9086

Sent auditor

The date on which you sent the client's accounts to the auditor.

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	StAudDt	The database field name.
API identifier	sentAuditorDate	The API identifier used in GraphQL.
Number	9102

Specification

The date of the specification.

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	AcpLtDt	The database field name.
API identifier	specificationDate	The API identifier used in GraphQL.
Number	9092

Start date

The start date.

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	StDt	The database field name.
API identifier	startDate	The API identifier used in GraphQL.
Number	9071

Tax office

The number of the tax office in the Associate 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	Associate no.	Integer
SQL name	Assessm	The database field name.
API identifier	taxOffice	The API identifier used in GraphQL.
Number	9080

Table 7. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	TaxOffice	Tax office	Associate no.

Tax papers

The date on which the tax papers were finished for your client.

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	AsPaDt	The database field name.
API identifier	taxPapersDate	The API identifier used in GraphQL.
Number	9104

Tax/VAT finished

The date on which you finished the tax and VAT calculation for your client.

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	TaxFDt	The database field name.
API identifier	taxFinishedDate	The API identifier used in GraphQL.
Number	9083

Term

The term for which this case journal applies.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	Term	The database field name.
API identifier	term	The API identifier used in GraphQL.
Number	9076

Term up to date

The date on which this term was up to date.

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	TermAjDt	The database field name.
API identifier	termUpToDate	The API identifier used in GraphQL.
Number	9096

Updated date

The date on which you updated the vouchers for the client.

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	AcSpDt	The database field name.
API identifier	updatedDate	The API identifier used in GraphQL.
Number	9085

Used hours

The number of hours for which you have worked for your client.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	AcrHrs	The database field name.
API identifier	usedHours	The API identifier used in GraphQL.
Number	9093

Value 1

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val1	The database field name.
API identifier	value1	The API identifier used in GraphQL.
Number	14500

Value 2

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val2	The database field name.
API identifier	value2	The API identifier used in GraphQL.
Number	14501

Value 3

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val3	The database field name.
API identifier	value3	The API identifier used in GraphQL.
Number	14502

Value 4

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val4	The database field name.
API identifier	value4	The API identifier used in GraphQL.
Number	14503

Value 5

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val5	The database field name.
API identifier	value5	The API identifier used in GraphQL.
Number	14504

Value 6

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val6	The database field name.
API identifier	value6	The API identifier used in GraphQL.
Number	14505

Value 7

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val7	The database field name.
API identifier	value7	The API identifier used in GraphQL.
Number	14506

Value 8

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val8	The database field name.
API identifier	value8	The API identifier used in GraphQL.
Number	14507

Value 9

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val9	The database field name.
API identifier	value9	The API identifier used in GraphQL.
Number	14508

Value 10

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val10	The database field name.
API identifier	value10	The API identifier used in GraphQL.
Number	14509

Value 11

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val11	The database field name.
API identifier	value11	The API identifier used in GraphQL.
Number	14510

Value 12

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val12	The database field name.
API identifier	value12	The API identifier used in GraphQL.
Number	14511

Value 13

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val13	The database field name.
API identifier	value13	The API identifier used in GraphQL.
Number	14512

Value 14

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Val14	The database field name.
API identifier	value14	The API identifier used in GraphQL.
Number	14513

VAT finished

The date on which you finished the VAT statement for your client.

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	VatFDt	The database field name.
API identifier	vatFinishedDate	The API identifier used in GraphQL.
Number	9082

Working committee

The date on which the working committee is finished.

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	BoardDt	The database field name.
API identifier	workingComitteeDate	The API identifier used in GraphQL.
Number	9107

Year

The year.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Year	Integer
SQL name	Yr	The database field name.
API identifier	year	The API identifier used in GraphQL.
Number	9074

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.

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 8. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.