Currency correction data
This table contains the temporary results of an exchange rate adjustment, per transaction.
- Customer transaction
- Supplier transaction
- General ledger transaction
- Capital asset transaction
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | CurCData | The table name in the database. |
| API identifier | currencyCorrectionData | The API identifier used in GraphQL. |
| Table no. | 310 | The table number in the data model. |
The following fields exist in this table:
ABS Diff. amount
Shows the difference amount in default currency on adjustment with a positive sign in front.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ACorDAm | The database field name. |
| API identifier | absDifferenceAmount | The API identifier used in GraphQL. |
| Number | 11900 |
ABS Diff. in %
Shows the difference amount as a percentage in default currency on adjustment with a positive sign in front.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ACorDP | The database field name. |
| API identifier | absDifferencePercent | The API identifier used in GraphQL. |
| Number | 11899 |
Accepted
This field shows an x if the ABS Diff. in % field and ABS Diff. amount field are within the limits for the maximum accepted exchange rate difference specified in the Company information table in the Max Curr. corr. am. and Max Curr. corr. % fields.
You can edit the field manually but in order for Business NXT to update the transaction tables with new values and create an adjustment Voucher, there must be an x in the field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | accepted | The API identifier used in GraphQL. |
| Number | 11902 |
Account no.
Contains the Account no. field copied from the General ledger transaction table, the Cust. no. field copied from the Customer transaction table or the Sup. no. field copied from the Supplier transaction table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcNo | The database field name. |
| API identifier | accountNo | The API identifier used in GraphQL. |
| Number | 11887 |
Account type
Shows which account type the currency correction is using.
- 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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcCl | The database field name. |
| API identifier | accountType | The API identifier used in GraphQL. |
| Number | 11901 |
Amount
Shows the currency amount that has been copied from the Amount in currency field in the General ledger transaction table.
The amount can also be adjusted by the VAT amount converted to currency, using the original exchange rate from the Outstanding amount in currency field from the Customer transaction and Supplier transaction tables.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CurAm | The database field name. |
| API identifier | currencyAmount | The API identifier used in GraphQL. |
| Number | 11890 |
Audit no.
Together with the Voucher jour. no. field, the Audit no. field is the table's primary key and is copied directly from the General ledger transaction, Customer transaction or Supplier transaction tables.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Audit no. | Integer |
| Primary key | Yes | Voucher jour. no., Audit no. |
| SQL name | EntNo | The database field name. |
| API identifier | auditNo | The API identifier used in GraphQL. |
| Number | 11886 |
Corr. amount
Shows the latest, adjusted amount from the General ledger transaction table, the Customer transaction table or the Supplier transaction table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CorAm | The database field name. |
| API identifier | correctionAmount | The API identifier used in GraphQL. |
| Number | 11893 |
Corr. date
Shows the date on which you performed the currency correction.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CorDt | The database field name. |
| API identifier | correctionDate | The API identifier used in GraphQL. |
| Number | 11894 |
Corr. exch. rate
Shows the last exchange rate that was used and is copied from the General ledger transaction table, the Customer transaction table or the Supplier transaction table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CorExRt | The database field name. |
| API identifier | correctionExchangeRate | The API identifier used in GraphQL. |
| Number | 11892 |
Corr. new amount
Contains the new amount after the currency correction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NewCAm | The database field name. |
| API identifier | newCorrectionAmount | The API identifier used in GraphQL. |
| Number | 11896 |
Corr. new exch. rate
Shows the adjustment rate for the current adjustment date according to what you entered in the Currency and Currency rate tables.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NewCRt | The database field name. |
| API identifier | newCorrectionExchangeRate | The API identifier used in GraphQL. |
| Number | 11895 |
Curr. corr. status
Indicates whether it is a result or a balance account and whether or not the entry has selected the Accepted field.
- Accepted
- Balance account
- Voucher created
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Curr. corr. status | Integer |
| SQL name | TransSt | The database field name. |
| API identifier | currencyCorrectionStatus | The API identifier used in GraphQL. |
| Number | 11903 |
Currency no.
Shows the currency number of the currency which was copied from the General ledger transaction table, the Customer transaction table or the Supplier transaction table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Currency no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 11888 |
Diff. am
Shows the difference amount in the default currency on currency correction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CorDAm | The database field name. |
| API identifier | differenceAmount | The API identifier used in GraphQL. |
| Number | 11898 |
Diff. in %
Shows the difference in percent in the default currency on currency correction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CorDP | The database field name. |
| API identifier | differencePercent | The API identifier used in GraphQL. |
| Number | 11897 |
Exchange rate
Shows the exchange rate which was copied from the General ledger transaction table, the Customer transaction table or the Supplier transaction table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExRt | The database field name. |
| API identifier | exchangeRate | The API identifier used in GraphQL. |
| Number | 11889 |
Language no.
The language for the text.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Language no. | Integer |
| Primary key | Yes | Language no., Text type, Text no., Line no. |
| SQL name | Lang | The database field name. |
| API identifier | languageNo | The API identifier used in GraphQL. |
| Number | 2100 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Language | Language |
|
Last curr. corr. amount
Contains the computed exchange rate difference from the previous currency correction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | LastCAm | The database field name. |
| API identifier | lastCurrencyCorrectionAmount | The API identifier used in GraphQL. |
| Number | 11967 |
Organisational unit 1
The field is used to specify organisational unit.
When you execute the Currency correction processing from the General ledger transaction table, the transactions will be copied to the Currency correction data table. The fields for organisational units will be filled in. When you execute the Transfer corrections to table processing from the Currency correction data table, Business NXT will produce one voucher per debit - credit account/organisational unit combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | 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 | 12166 |
Organisational unit 2
The field is used to specify organisational unit.
When you execute the Currency correction processing from the General ledger transaction table, the transactions will be copied to the Currency correction data table. The fields for organisational units will be filled in. When you execute the Transfer corrections to table processing from the Currency correction data table, Business NXT will produce one voucher per debit - credit account/organisational unit combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | 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 | 12167 |
Organisational unit 3
The field is used to specify organisational unit.
When you execute the Currency correction processing from the General ledger transaction table, the transactions will be copied to the Currency correction data table. The fields for organisational units will be filled in. When you execute the Transfer corrections to table processing from the Currency correction data table, Business NXT will produce one voucher per debit - credit account/organisational unit combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | 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 | 12168 |
Organisational unit 4
The field is used to specify organisational unit.
When you execute the Currency correction processing from the General ledger transaction table, the transactions will be copied to the Currency correction data table. The fields for organisational units will be filled in. When you execute the Transfer corrections to table processing from the Currency correction data table, Business NXT will produce one voucher per debit - credit account/organisational unit combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | 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 | 12169 |
Organisational unit 5
The field is used to specify organisational unit.
When you execute the Currency correction processing from the General ledger transaction table, the transactions will be copied to the Currency correction data table. The fields for organisational units will be filled in. When you execute the Transfer corrections to table processing from the Currency correction data table, Business NXT will produce one voucher per debit - credit account/organisational unit combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | 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 | 12170 |
Organisational unit 6
The field is used to specify organisational unit.
When you execute the Currency correction processing from the General ledger transaction table, the transactions will be copied to the Currency correction data table. The fields for organisational units will be filled in. When you execute the Transfer corrections to table processing from the Currency correction data table, Business NXT will produce one voucher per debit - credit account/organisational unit combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | 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 | 12171 |
Organisational unit 7
The field is used to specify organisational unit.
When you execute the Currency correction processing from the General ledger transaction table, the transactions will be copied to the Currency correction data table. The fields for organisational units will be filled in. When you execute the Transfer corrections to table processing from the Currency correction data table, Business NXT will produce one voucher per debit - credit account/organisational unit combination.
The field appear with the name assigned to it in the Company information 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 | 12172 |
Organisational unit 8
The field is used to specify organisational unit.
When you execute the Currency correction processing from the General ledger transaction table, the transactions will be copied to the Currency correction data table. The fields for organisational units will be filled in. When you execute the Transfer corrections to table processing from the Currency correction data table, Business NXT will produce one voucher per debit - credit account/organisational unit combination.
The field appear with the name assigned to it in the Company information 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 | 12173 |
Organisational unit 9
The field is used to specify organisational unit.
When you execute the Currency correction processing from the General ledger transaction table, the transactions will be copied to the Currency correction data table. The fields for organisational units will be filled in. When you execute the Transfer corrections to table processing from the Currency correction data table, Business NXT will produce one voucher per debit - credit account/organisational unit combination.
The field appear with the name assigned to it in the Company information 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 | 12174 |
Organisational unit 10
The field is used to specify organisational unit.
When you execute the Currency correction processing from the General ledger transaction table, the transactions will be copied to the Currency correction data table. The fields for organisational units will be filled in. When you execute the Transfer corrections to table processing from the Currency correction data table, Business NXT will produce one voucher per debit - credit account/organisational unit combination.
The field appear with the name assigned to it in the Company information 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 | 12175 |
Organisational unit 11
The field is used to specify organisational unit.
When you execute the Currency correction processing from the General ledger transaction table, the transactions will be copied to the Currency correction data table. The fields for organisational units will be filled in. When you execute the Transfer corrections to table processing from the Currency correction data table, Business NXT will produce one voucher per debit - credit account/organisational unit combination.
The field appear with the name assigned to it in the Company information 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 | 12176 |
Organisational unit 12
The field is used to specify organisational unit.
When you execute the Currency correction processing from the General ledger transaction table, the transactions will be copied to the Currency correction data table. The fields for organisational units will be filled in. When you execute the Transfer corrections to table processing from the Currency correction data table, Business NXT will produce one voucher per debit - credit account/organisational unit combination.
The field appear with the name assigned to it in the Company information 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 | 12177 |
Posted amount
This amount is copied from the Posted amount field in the General ledger transaction table, from the Outstanding amount in currency field in the Customer transaction table and the Outstanding amount in currency field in the Supplier transaction table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcAm | The database field name. |
| API identifier | postedAmountDomestic | The API identifier used in GraphQL. |
| Number | 11891 |
Voucher jour. no.
The voucher journal number is copied directly from the General ledger transaction, Customer transaction or Supplier transaction tables.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Journal no. | Integer |
| Primary key | Yes | Voucher jour. no., Audit no. |
| SQL name | JNo | The database field name. |
| API identifier | voucherJournalNo | The API identifier used in GraphQL. |
| Number | 11885 |
Control columns
Control columns include information about who has changed the record last and when, and which process that is currently editing the record.
Changed by provenance
The provenance for the record change.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed by user
The name of the user that changed the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time stamp
The date and time when the record was changed.
The field is updated with the UTC time.
This value can be used by external systems to replicate changed data. The column is indexed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by provenance
The provenance for the record creation.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Edit status
The current status of the record.
A look-up in this field gives you the following list of possible values:
0 - Unchanged: The record is read, but not changed.
1 - Inserted: The record is new.
2 - Changed: The record is changed.
3 - Deleted: The record is deleted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A unique column number. |
Process no
The Process no. from the Active company process table which is currently using or has control of this record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |