Free information 2
The tables with free information can be used as extensions to other tables, using foreign keys.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | FreeInf2 | The table name in the database. |
| API identifier | freeInformation2 | The API identifier used in GraphQL. |
| Table no. | 307 | The table number in the data model. |
The following fields exist in this table:
Account no.
The referenced account from the General ledger account 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 | Account no. | Integer |
| SQL name | AcNo | The database field name. |
| API identifier | accountNo | The API identifier used in GraphQL. |
| Number | 11717 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | GeneralLedgerAccount |
|
Account type
The account type used to determine whether the Audit no. field references the Customer transaction, Supplier transaction, General ledger transaction or Capital asset transaction table.
- 1 - Customer
- The account number refer to a customer.
- 2 - Supplier
- The account number refer to a supplier.
- 3 - General ledger account
- The account number refer to a general ledger account.
- 4 - Capital asset
- The account number refer to a capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account type | Integer |
| SQL name | AcCl | The database field name. |
| API identifier | accountType | The API identifier used in GraphQL. |
| Number | 11718 |
Accounting period
The period of the accounting period.
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 | Period | Integer |
| SQL name | AcPr | The database field name. |
| API identifier | accountingPeriod | The API identifier used in GraphQL. |
| Number | 11725 |
Accounting period year
The year of the accounting period.
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 | Year | Integer |
| SQL name | AcYr | The database field name. |
| API identifier | accountingYear | The API identifier used in GraphQL. |
| Number | 11724 |
Addr. no.
The referenced address from the Address 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 | Addr. no. | Integer |
| SQL name | AdNo | The database field name. |
| API identifier | addressNo | The API identifier used in GraphQL. |
| Number | 15400 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Address | Address |
|
|
Appointm. ref. no.
The referenced appointment from the Appointment 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 | No. | Integer |
| SQL name | AgrRefNo | The database field name. |
| API identifier | appointmentReferenceNo | The API identifier used in GraphQL. |
| Number | 11723 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Appointment | Appointment |
|
Associate no.
The referenced associate from 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 | ActNo | The database field name. |
| API identifier | associateNo | The API identifier used in GraphQL. |
| Number | 11693 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Associate |
| ||
| Bank account | BankAccount |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Proxy | Proxy |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Audit no.
The referenced transaction from the Customer transaction, Supplier transaction, General ledger transaction or Capital asset transaction table, depending on the value in the Account type field.
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 | Audit no. | Integer |
| SQL name | EntNo | The database field name. |
| API identifier | auditNo | The API identifier used in GraphQL. |
| Number | 11720 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Customer transaction | CustomerTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Supplier transaction | SupplierTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger transaction | GeneralLedgerTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Capital asset transaction | CapitalAssetTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Accounting transaction | AllAccountingTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Bank seq. no.
The referenced bank account from the Bank account 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 | No. | Integer |
| SQL name | BankLnNo | The database field name. |
| API identifier | bankSequenceNo | The API identifier used in GraphQL. |
| Number | 15406 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Bank account | BankAccount |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Proxy | Proxy |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Batch no.
The referenced batch from the Batch 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 | Batch no. | Integer |
| SQL name | BndNo | The database field name. |
| API identifier | batchNo | The API identifier used in GraphQL. |
| Number | 11729 |
Budget line no.
The referenced budget line from the Budget line 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 | No. | Integer |
| SQL name | BgLnNo | The database field name. |
| API identifier | budgetLineNo | The API identifier used in GraphQL. |
| Number | 11722 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Budget line | BudgetLine |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Budget no.
The referenced budget from the Budget 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 | Budget no. | Integer |
| SQL name | BgNo | The database field name. |
| API identifier | budgetNo | The API identifier used in GraphQL. |
| Number | 11721 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Budget | Budget |
| ||
| Budget line | BudgetLine |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Cap. asset no.
The referenced capital asset from the Capital asset 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 | Cap. asset no. | Integer |
| SQL name | PropNo | The database field name. |
| API identifier | capitalAssetNo | The API identifier used in GraphQL. |
| Number | 13793 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Capital asset | CapitalAsset |
|
Cust. no.
The referenced customer from 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 | Cust. no. | Integer |
| SQL name | Cust | The database field name. |
| API identifier | customerNo | The API identifier used in GraphQL. |
| Number | 11694 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Customer |
|
Date 1
A free date field.
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 | 11738 |
Date 2
A free date field.
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 | 11739 |
Date 3
A free date field.
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 | 11740 |
Date 4
A free date field.
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 | 11741 |
Date 5
A free date field.
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 | 12959 |
Date 6
A free date field.
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 | 12960 |
Date 7
A free date field.
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 | 12961 |
Date 8
A free date field.
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 | 12962 |
Date 9
A free date field.
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 | 12963 |
Date 10
A free date field.
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 | 12964 |
Date 11
A free date field.
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 | 12965 |
Date 12
A free date field.
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 | 12966 |
Date 13
A free date field.
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 | 12967 |
Date 14
A free date field.
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 | 12968 |
Doc. link line no.
The referenced document link from the Document link 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 | No. | Integer |
| SQL name | DocLkLnNo | The database field name. |
| API identifier | documentLinkLineNo | The API identifier used in GraphQL. |
| Number | 15405 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Document link | DocumentLink |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Doc. no.
The referenced document from the Document 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 | Doc. no. | Integer |
| SQL name | DocNo | The database field name. |
| API identifier | documentNo | The API identifier used in GraphQL. |
| Number | 15403 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Document | Document |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Document link | DocumentLink |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Doc. version no.
The referenced document version from the Document 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 | No. | Integer |
| SQL name | DocVerNo | The database field name. |
| API identifier | documentVersionNo | The API identifier used in GraphQL. |
| Number | 15404 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Document | Document |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Document link | DocumentLink |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Empl. no.
The referenced employee from the Associate table.
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 | Emp | The database field name. |
| API identifier | employeeNo | The API identifier used in GraphQL. |
| Number | 11696 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Employee |
|
Free info 1
The referenced record from the Free information 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 | No. | Integer |
| SQL name | FreeInf1 | The database field name. |
| API identifier | freeInformation1 | The API identifier used in GraphQL. |
| Number | 12785 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Free information 1 | FreeInformation1 |
|
Free info 3
The referenced record from the Free information 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 | No. | Integer |
| SQL name | FreeInf3 | The database field name. |
| API identifier | freeInformation3 | The API identifier used in GraphQL. |
| Number | 12787 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Free information 3 | FreeInformation3 |
|
Free information 2 type 2
The type of information.
Free information 2 type 2 texts for different languages can be
defined in the Text
table. These texts has text type 191.
Note:
If you double-click or press
* in this field, you can look up a Free information 2 type 2 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information 2 type 2 | Integer |
| SQL name | FrInfTp2 | The database field name. |
| API identifier | freeInformationType2 | The API identifier used in GraphQL. |
| Number | 15307 |
Free information 2 type 3
The type of information.
Free information 2 type 3 texts for different languages can be
defined in the Text
table. These texts has text type 192.
Note:
If you double-click or press
* in this field, you can look up a Free information 2 type 3 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information 2 type 3 | Integer |
| SQL name | FrInfTp3 | The database field name. |
| API identifier | freeInformationType3 | The API identifier used in GraphQL. |
| Number | 15308 |
Free information category
Free categorisation.
Free information category texts for different languages can be
defined in the Text
table. These texts has text type 180.
Note:
If you double-click or press
* in this field, you can look up a Free information category in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information category | Integer |
| SQL name | InfCatNo | The database field name. |
| API identifier | freeInformationCategory | The API identifier used in GraphQL. |
| Number | 12861 |
Free information type 1
The type of information.
Free information type 1 texts for different languages can be
defined in the Text
table. These texts has text type 156.
Note:
If you double-click or press
* in this field, you can look up a Free information type 1 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information type 1 | Integer |
| SQL name | FrInfTp | The database field name. |
| API identifier | freeInformationType1 | The API identifier used in GraphQL. |
| Number | 11731 |
Gr. 1
Free grouping information.
Free information grouping 1 texts for different languages can be
defined in the Text
table. These texts has text type 157.
Note:
If you double-click or press
* in this field, you can look up a Free information grouping 1 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information grouping 1 | Integer |
| SQL name | Gr | The database field name. |
| API identifier | freeGroup1 | The API identifier used in GraphQL. |
| Number | 11732 |
Gr. 2
Free grouping information.
Free information grouping 2 texts for different languages can be
defined in the Text
table. These texts has text type 158.
Note:
If you double-click or press
* in this field, you can look up a Free information grouping 2 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information grouping 2 | Integer |
| SQL name | Gr2 | The database field name. |
| API identifier | freeGroup2 | The API identifier used in GraphQL. |
| Number | 11733 |
Gr. 3
Free grouping information.
Free information grouping 3 texts for different languages can be
defined in the Text
table. These texts has text type 159.
Note:
If you double-click or press
* in this field, you can look up a Free information grouping 3 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information grouping 3 | Integer |
| SQL name | Gr3 | The database field name. |
| API identifier | freeGroup3 | The API identifier used in GraphQL. |
| Number | 11734 |
Gr. 4
Free grouping information.
Free information grouping 4 texts for different languages can be
defined in the Text
table. These texts has text type 160.
Note:
If you double-click or press
* in this field, you can look up a Free information grouping 4 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information grouping 4 | Integer |
| SQL name | Gr4 | The database field name. |
| API identifier | freeGroup4 | The API identifier used in GraphQL. |
| Number | 11735 |
Gr. 5
Free grouping information.
Free information grouping 5 texts for different languages can be
defined in the Text
table. These texts has text type 195.
Note:
If you double-click or press
* in this field, you can look up a Free information grouping 5 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information grouping 5 | Integer |
| SQL name | Gr5 | The database field name. |
| API identifier | freeGroup5 | The API identifier used in GraphQL. |
| Number | 15323 |
Gr. 6
Free grouping information.
Free information grouping 6 texts for different languages can be
defined in the Text
table. These texts has text type 196.
Note:
If you double-click or press
* in this field, you can look up a Free information grouping 6 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information grouping 6 | Integer |
| SQL name | Gr6 | The database field name. |
| API identifier | freeGroup6 | The API identifier used in GraphQL. |
| Number | 15324 |
Gr. 7
Free grouping information.
Free information grouping 7 texts for different languages can be
defined in the Text
table. These texts has text type 197.
Note:
If you double-click or press
* in this field, you can look up a Free information grouping 7 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information grouping 7 | Integer |
| SQL name | Gr7 | The database field name. |
| API identifier | freeGroup7 | The API identifier used in GraphQL. |
| Number | 15325 |
Gr. 8
Free grouping information.
Free information grouping 8 texts for different languages can be
defined in the Text
table. These texts has text type 198.
Note:
If you double-click or press
* in this field, you can look up a Free information grouping 8 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information grouping 8 | Integer |
| SQL name | Gr8 | The database field name. |
| API identifier | freeGroup8 | The API identifier used in GraphQL. |
| Number | 15326 |
Gr. 9
Free grouping information.
Free information grouping 9 texts for different languages can be
defined in the Text
table. These texts has text type 199.
Note:
If you double-click or press
* in this field, you can look up a Free information grouping 9 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information grouping 9 | Integer |
| SQL name | Gr9 | The database field name. |
| API identifier | freeGroup9 | The API identifier used in GraphQL. |
| Number | 15327 |
Gr. 10
Free grouping information.
Free information grouping 10 texts for different languages can be
defined in the Text
table. These texts has text type 200.
Note:
If you double-click or press
* in this field, you can look up a Free information grouping 10 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information grouping 10 | Integer |
| SQL name | Gr10 | The database field name. |
| API identifier | freeGroup10 | The API identifier used in GraphQL. |
| Number | 15328 |
Gr. 11
Free grouping information.
Free information grouping 11 texts for different languages can be
defined in the Text
table. These texts has text type 201.
Note:
If you double-click or press
* in this field, you can look up a Free information grouping 11 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information grouping 11 | Integer |
| SQL name | Gr11 | The database field name. |
| API identifier | freeGroup11 | The API identifier used in GraphQL. |
| Number | 15329 |
Gr. 12
Free grouping information.
Free information grouping 12 texts for different languages can be
defined in the Text
table. These texts has text type 202.
Note:
If you double-click or press
* in this field, you can look up a Free information grouping 12 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Free information grouping 12 | Integer |
| SQL name | Gr12 | The database field name. |
| API identifier | freeGroup12 | The API identifier used in GraphQL. |
| Number | 15330 |
Main free info
The referenced Primary key from the same 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 | No. | Integer |
| SQL name | MainFrI2 | The database field name. |
| API identifier | mainFreeInformation | The API identifier used in GraphQL. |
| Number | 12786 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Free information 2 | FreeInformation2 |
|
Memo file name
The file name for the Memo attached to the record.
This can be used to add a number of texts for a product or product group. This
might be, for example, a product description, environmental information or product
information.
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 | 12860 |
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 | No | This field is not 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 | 19250 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Memo | Memo |
|
Order jour. no.
The referenced order journal from the Order journal 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 | Journal no. | Integer |
| SQL name | OrdJNo | The database field name. |
| API identifier | orderJournalNo | The API identifier used in GraphQL. |
| Number | 11715 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order journal | OrderJournal |
| ||
| Product transaction | ProductTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Product transaction before compression | ProductTransaction2 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Order line no.
The referenced order line from the Order line 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 | No. | Integer |
| SQL name | OrdLnNo | The database field name. |
| API identifier | orderLineNo | The API identifier used in GraphQL. |
| Number | 11710 |
Order no.
The referenced order from the Order 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 | Order no. | Integer |
| SQL name | OrdNo | The database field name. |
| API identifier | orderNo | The API identifier used in GraphQL. |
| Number | 11709 |
Organisational unit 1
The referenced organisational unit from the Organisational unit table.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 11697 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
Organisational unit 2
The referenced organisational unit from the Organisational unit table.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 11698 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
Organisational unit 3
The referenced organisational unit from the Organisational unit table.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 11699 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
Organisational unit 4
The referenced organisational unit from the Organisational unit table.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 11700 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
Organisational unit 5
The referenced organisational unit from the Organisational unit table.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 11701 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
Organisational unit 6
The referenced organisational unit from the Organisational unit table.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 11702 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
Organisational unit 7
The referenced organisational unit from the Organisational unit table.
The field appear with the name assigned to it in the Company information table.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 11703 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
Organisational unit 8
The referenced organisational unit from the Organisational unit table.
The field appear with the name assigned to it in the Company information table.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 11704 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
Organisational unit 9
The referenced organisational unit from the Organisational unit table.
The field appear with the name assigned to it in the Company information table.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 11705 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
Organisational unit 10
The referenced organisational unit from the Organisational unit table.
The field appear with the name assigned to it in the Company information table.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 11706 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
Organisational unit 11
The referenced organisational unit from the Organisational unit table.
The field appear with the name assigned to it in the Company information table.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 11707 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
Organisational unit 12
The referenced organisational unit from the Organisational unit table.
The field appear with the name assigned to it in the Company information table.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 11708 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Participant sequence no.
The referenced participant from the Participant 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 | No. | Integer |
| SQL name | PrtSeqNo | The database field name. |
| API identifier | participantSequenceNo | The API identifier used in GraphQL. |
| Number | 15399 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Participant | Participant |
|
Picture file name
A link to the picture file for the record.
This can be used to add a number of pictures of a product or product
group.
Tip:
Double-clicking or pressing * in this box
opens the picture. If the box is empty, a dialog box for selecting a picture file
will open.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Picture file name | Text (260) |
| SQL name | PictFNm | The database field name. |
| API identifier | pictureFileName | The API identifier used in GraphQL. |
| Number | 12858 |
Price line no.
The referenced price line from the Price- and discount matrix 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 | No. | Integer |
| SQL name | PriceLn | The database field name. |
| API identifier | priceLineNo | The API identifier used in GraphQL. |
| Number | 13794 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Price- and discount matrix | PriceAndDiscountMatrix |
|
Primary key
A unique number identifying the record.
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 | Primary key |
| SQL name | PK | The database field name. |
| API identifier | primaryKey | The API identifier used in GraphQL. |
| Number | 11692 |
Prod. trans. no.
The referenced transaction from the Product transaction 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 | No. | Integer |
| SQL name | ProdTrNo | The database field name. |
| API identifier | productTransactionNo | The API identifier used in GraphQL. |
| Number | 11716 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product transaction | ProductTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Product transaction before compression | ProductTransaction2 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Product category
The referenced product category from the Product category table, which enables you to perform one single grouping within the product structure.
Product category texts for different languages can be
defined in the Text
table. These texts has text type 145.
Note:
If you double-click or press
* in this field, you can look up a Product category in the Text
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 | Product category | Integer |
| SQL name | PrCatNo | The database field name. |
| API identifier | productCategoryNo | The API identifier used in GraphQL. |
| Number | 12862 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product category | ProductCategory |
|
Product no.
The referenced product from the Product 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 | Product no. | Text (40) |
| SQL name | ProdNo | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 11711 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
| ||
| Search product | SearchProduct |
| ||
| Structure | Structure |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Delivery alternative | DeliveryAlternative |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Stock balance | StockBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Shipment | Shipment |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Prog. no.
The referenced program from the Program 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 | Prog. no. | Integer |
| SQL name | ProgNo | The database field name. |
| API identifier | programNo | The API identifier used in GraphQL. |
| Number | 15401 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Program | Program |
| ||
| Template | Template |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Proxy no.
The referenced proxy from the Proxy 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 | No. | Integer |
| SQL name | PrxNo | The database field name. |
| API identifier | proxyNo | The API identifier used in GraphQL. |
| Number | 15407 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Proxy | Proxy |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Realisation journal line no.
The referenced line from the Realisation journal line 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 | No. | Integer |
| SQL name | RealLnNo | The database field name. |
| API identifier | realisationJournalLineNo | The API identifier used in GraphQL. |
| Number | 15409 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Realisation journal line | RealisationJournalLine |
|
Realisation journal no.
The referenced journal from the Realisation journal 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 | Journal no. | Integer |
| SQL name | RealJNo | The database field name. |
| API identifier | realisationJournalNo | The API identifier used in GraphQL. |
| Number | 15408 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Realisation journal | RealisationJournal |
|
Realised year/period
The referenced period from the Statistics period 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 | Year/Per. | Integer |
| SQL name | StYrPr | The database field name. |
| API identifier | realisedYearAndPeriod | The API identifier used in GraphQL. |
| Number | 11728 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Statistics period | StatisticsPeriod |
|
Res. no.
The referenced resource from the Resource 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 | Res. no. | Integer |
| SQL name | ResNo | The database field name. |
| API identifier | resourceNo | The API identifier used in GraphQL. |
| Number | 15396 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Resource | Resource |
| ||
| Time schedule balance | TimeScheduleBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Shipment no.
The referenced shipment from the Shipment 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 | Shipment no. | Integer |
| SQL name | ShpNo | The database field name. |
| API identifier | shipmentNo | The API identifier used in GraphQL. |
| Number | 13795 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Shipment | Shipment |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Structure line no.
The referenced structure from the Structure 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 | No. | Integer |
| SQL name | StrLnNo | The database field name. |
| API identifier | structureLineNo | The API identifier used in GraphQL. |
| Number | 11712 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Structure | Structure |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Sup. no.
The referenced supplier from 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 | Sup. no. | Integer |
| SQL name | Sup | The database field name. |
| API identifier | supplierNo | The API identifier used in GraphQL. |
| Number | 11695 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
|
Supplier alt. line no.
The referenced delivery alternative from the Delivery alternative 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 | No. | Integer |
| SQL name | DelLnNo | The database field name. |
| API identifier | deliveryAlternativeLineNo | The API identifier used in GraphQL. |
| Number | 11713 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Delivery alternative | DeliveryAlternative |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Template line no.
The referenced template from the Template 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 | No. | Integer |
| SQL name | TemplLnNo | The database field name. |
| API identifier | templateLineNo | The API identifier used in GraphQL. |
| Number | 15402 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Template | Template |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Text 1
A free text field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 60 | Text (60) |
| SQL name | Txt1 | The database field name. |
| API identifier | text1 | The API identifier used in GraphQL. |
| Number | 11736 |
Text 2
A free text field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 60 | Text (60) |
| SQL name | Txt2 | The database field name. |
| API identifier | text2 | The API identifier used in GraphQL. |
| Number | 11737 |
Text 3
A free text field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (260) |
| SQL name | Txt3 | The database field name. |
| API identifier | text3 | The API identifier used in GraphQL. |
| Number | 12761 |
Text 4
A free text field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (260) |
| SQL name | Txt4 | The database field name. |
| API identifier | text4 | The API identifier used in GraphQL. |
| Number | 12762 |
Time schedule group no.
The referenced group from the Time schedule group 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 | Time schedule group no. | Integer |
| SQL name | TsGrNo | The database field name. |
| API identifier | timeScheduleGroupNo | The API identifier used in GraphQL. |
| Number | 15397 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Time schedule group | TimeScheduleGroup |
| ||
| Time schedule calendar | TimeScheduleCalendarPeriod |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Time schedule balance | TimeScheduleBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Time schedule period
The referenced period from the Time schedule calendar table.
Tip:
The year is displayed with 4 digits (YYYY), but you only need to enter the final digit(s) in a year, e.g. the value 12 is interpreted as 2012.
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 | Year/Per. | Integer |
| SQL name | YrPr | The database field name. |
| API identifier | timeScheduleCalendarPeriod | The API identifier used in GraphQL. |
| Number | 15398 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Time schedule calendar | TimeScheduleCalendarPeriod |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Time schedule balance | TimeScheduleBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Value 1
Additional numeric information.
| 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 | 11742 |
Value 2
Additional numeric information.
| 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 | 11743 |
Value 3
Additional numeric information.
| 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 | 11744 |
Value 4
Additional numeric information.
| 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 | 11745 |
Value 5
Additional numeric information.
| 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 | 11746 |
Value 6
Additional numeric information.
| 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 | 11747 |
Value 7
Additional numeric information.
| 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 | 11748 |
Value 8
Additional numeric information.
| 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 | 11749 |
Value 9
Additional numeric information.
| 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 | 11750 |
Value 10
Additional numeric information.
| 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 | 11751 |
Value 11
Additional numeric information.
| 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 | 11752 |
Value 12
Additional numeric information.
| 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 | 11753 |
Value 13
Additional numeric information.
| 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 | 11754 |
Value 14
Additional numeric information.
| 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 | 11755 |
Value 15
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val15 | The database field name. |
| API identifier | value15 | The API identifier used in GraphQL. |
| Number | 15309 |
Value 16
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val16 | The database field name. |
| API identifier | value16 | The API identifier used in GraphQL. |
| Number | 15310 |
Value 17
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val17 | The database field name. |
| API identifier | value17 | The API identifier used in GraphQL. |
| Number | 15311 |
Value 18
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val18 | The database field name. |
| API identifier | value18 | The API identifier used in GraphQL. |
| Number | 15312 |
Value 19
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val19 | The database field name. |
| API identifier | value19 | The API identifier used in GraphQL. |
| Number | 15313 |
Value 20
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val20 | The database field name. |
| API identifier | value20 | The API identifier used in GraphQL. |
| Number | 15314 |
Value 21
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val21 | The database field name. |
| API identifier | value21 | The API identifier used in GraphQL. |
| Number | 15315 |
Value 22
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val22 | The database field name. |
| API identifier | value22 | The API identifier used in GraphQL. |
| Number | 15316 |
Value 23
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val23 | The database field name. |
| API identifier | value23 | The API identifier used in GraphQL. |
| Number | 15317 |
Value 24
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val24 | The database field name. |
| API identifier | value24 | The API identifier used in GraphQL. |
| Number | 15318 |
Value 25
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val25 | The database field name. |
| API identifier | value25 | The API identifier used in GraphQL. |
| Number | 15319 |
Value 26
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val26 | The database field name. |
| API identifier | value26 | The API identifier used in GraphQL. |
| Number | 15320 |
Value 27
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val27 | The database field name. |
| API identifier | value27 | The API identifier used in GraphQL. |
| Number | 15321 |
Value 28
Additional numeric information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Val28 | The database field name. |
| API identifier | value28 | The API identifier used in GraphQL. |
| Number | 15322 |
VAT term
The referenced period from the VAT period 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 | Period | Integer |
| SQL name | TxTrm | The database field name. |
| API identifier | taxTerm | The API identifier used in GraphQL. |
| Number | 11727 |
VAT year
The referenced year from the VAT period 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 | Year | Integer |
| SQL name | TxYr | The database field name. |
| API identifier | taxYear | The API identifier used in GraphQL. |
| Number | 11726 |
Voucher jour. no.
The referenced journal from the Updated journal 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 | Journal no. | Integer |
| SQL name | VoJNo | The database field name. |
| API identifier | voucherJournalNo | The API identifier used in GraphQL. |
| Number | 11719 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated journal | UpdatedJournal |
| ||
| Customer transaction | CustomerTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Supplier transaction | SupplierTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger transaction | GeneralLedgerTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Capital asset transaction | CapitalAssetTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Accounting transaction | AllAccountingTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Voucher line no.
The referenced voucher from the Voucher 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 | No. | Integer |
| SQL name | BndLnNo | The database field name. |
| API identifier | voucherLineNo | The API identifier used in GraphQL. |
| Number | 11730 |
Warehouse no.
The referenced warehouse from the Warehouse 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 | Warehouse no. | Integer |
| SQL name | StcNo | The database field name. |
| API identifier | warehouseNo | The API identifier used in GraphQL. |
| Number | 11714 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Warehouse | Warehouse |
| ||
| Stock balance | StockBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Shipment | Shipment |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Web page
The address of a web page for the record.
This can be used to add a number of web pages for a product.
Double-click or press * to open the web page in your web browser.
Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.
On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | WebPg | The database field name. |
| API identifier | webPage | The API identifier used in GraphQL. |
| Number | 12859 |
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. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |