Stock change
The Stock change table contains one row for each delivery date, per product/warehouse combination, with expected future stock changes and closing stock.
It can be used to find out whether and when you can make deliveries and replenish stock.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | DelTmBal | The table name in the database. |
| API identifier | stockChange | The API identifier used in GraphQL. |
| Table no. | 126 | The table number in the data model. |
The following fields exist in this table:
Accumulated decrease outside lead time
The accumulated decrease outside lead time, up to and including the date in each line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | accumulatedDecreaseOutsideLeadTime | The API identifier used in GraphQL. |
| Number | 6547 |
Accumulated increase
The accumulated increase, up to and including the date in each line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | accumulatedIncrease | The API identifier used in GraphQL. |
| Number | 6525 |
Accumulated reservations outside lead time
The accumulated reservations outside lead time, up to and including the date in each line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | accumulatedReservationsOutsideLeadTime | The API identifier used in GraphQL. |
| Number | 6554 |
Closing stock
How many units are expected to be available on the date in question.
- + Physical stock from the Stock balance table
- + Accumulated reservations outside lead time up to and including the date in the row
- - Decrease within lead time from the Stock balance table
- - Reservations outside lead time from the Stock balance table
- + Decrease within lead time from the Stock balance table
- - Accumulated decrease outside lead time
- = Closing stock
If the stock is negative, you do not have a sufficient quantity of units available on this date. When you enter the quantity in a decrease order line, the program issues a warning if the Closing stock is negative on the required delivery date.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | closingStock | The API identifier used in GraphQL. |
| Number | 4725 |
Confirmed by supplier
How much of the ordered quantity has been confirmed by the supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Conf | The database field name. |
| API identifier | confirmedBySupplier | The API identifier used in GraphQL. |
| Number | 6314 |
Credit expected loss
How many units of the product have been withdrawn for transaction type 4 - Adjustment/internal issue.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CExpLoss | The database field name. |
| API identifier | creditExpectedLoss | The API identifier used in GraphQL. |
| Number | 4537 |
Credit in hire order
How many units of the product have been withdrawn for transaction type 2 - Hire.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CInHireO | The database field name. |
| API identifier | creditInHireOrder | The API identifier used in GraphQL. |
| Number | 4533 |
Credit in loan order
How many units of the product have been withdrawn for transaction type 3 - Loan.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CInLoanO | The database field name. |
| API identifier | creditInLoanOrder | The API identifier used in GraphQL. |
| Number | 4535 |
Credit in order
How many units of the product have been withdrawn from an order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CInO | The database field name. |
| API identifier | creditInOrder | The API identifier used in GraphQL. |
| Number | 4531 |
Credit in order to prod.
How many units of the product have been withdrawn from an order to production.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CInProdO | The database field name. |
| API identifier | creditInOrderToProduction | The API identifier used in GraphQL. |
| Number | 4539 |
Credit in production
How many units of the product have not been produced.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CInProd | The database field name. |
| API identifier | creditInProduction | The API identifier used in GraphQL. |
| Number | 4543 |
Credit in purchase
How many units of the product have been withdrawn for transaction type 6 - Purchase.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CInPurc | The database field name. |
| API identifier | creditInPurchase | The API identifier used in GraphQL. |
| Number | 4541 |
Decrease
The outgoing quantity from the warehouse for all 8 transaction types.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | decrease | The API identifier used in GraphQL. |
| Number | 4547 |
Decrease outside lead time
The difference between the Decrease and Decrease within lead time fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DecOuts | The database field name. |
| API identifier | decreaseOutsideLeadTime | The API identifier used in GraphQL. |
| Number | 6552 |
Decrease within lead time
The difference between the Decrease and Decrease outside lead time fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | decreaseWithinLeadTime | The API identifier used in GraphQL. |
| Number | 6559 |
Delivery date
The date for when you expect a stock change for the product at the current warehouse.
- Arrival/departure date in the Order line
- Arrival/departure date in the Order
- Confirmed delivery date in the Order line
- Confirmed delivery date in the Order
- Required delivery date in the Order line
- Required delivery date in the Order
- Trans. date in the Order line
- Order date in the Order
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 |
| Primary key | Yes | Product no., Warehouse no., Delivery date |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelDt | The database field name. |
| API identifier | deliveryDate | The API identifier used in GraphQL. |
| Number | 2849 |
Delivery week
The week number for when you expect a stock change for the product at the current warehouse.
The week number is based on the Delivery date field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | deliveryWeek | The API identifier used in GraphQL. |
| Number | 5641 |
Expected loss
Hows much is entered for transaction type 4 - Adjustment/internal issue.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExpLoss | The database field name. |
| API identifier | expectedLoss | The API identifier used in GraphQL. |
| Number | 4536 |
Expected stock value
The expected stock value on the relevant date so that you can see how it changes over time.
The field is calculated as the product of the Average cost price from the Stock balance table and the Closing stock.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | expectedStockValue | The API identifier used in GraphQL. |
| Number | 5893 |
In hire order
How many units of the product are on hire.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InHireO | The database field name. |
| API identifier | inHireOrder | The API identifier used in GraphQL. |
| Number | 4532 |
In loan order
How many units of the product are on loan.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InLoanO | The database field name. |
| API identifier | inLoanOrder | The API identifier used in GraphQL. |
| Number | 4534 |
In order
How many units of the product are in an order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InO | The database field name. |
| API identifier | inOrder | The API identifier used in GraphQL. |
| Number | 4530 |
In order to prod.
How many units of the product are ready for production.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InProdO | The database field name. |
| API identifier | inOrderToProduction | The API identifier used in GraphQL. |
| Number | 4538 |
In production
How many units of the product are in production.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InProd | The database field name. |
| API identifier | inProduction | The API identifier used in GraphQL. |
| Number | 4542 |
In purchase
How many units of the product are in a purchase.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InPurc | The database field name. |
| API identifier | inPurchase | The API identifier used in GraphQL. |
| Number | 4540 |
In stock transfer from
How many units of the product to be transferred from another warehouse.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CInTrfO | The database field name. |
| API identifier | inStockTransferFrom | The API identifier used in GraphQL. |
| Number | 4545 |
In stock transfer to
How many units of the product to be transferred to another warehouse.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InTrfO | The database field name. |
| API identifier | inStockTransferTo | The API identifier used in GraphQL. |
| Number | 4544 |
Increase
The incoming quantity into the warehouse for all 8 transaction types.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | increase | The API identifier used in GraphQL. |
| Number | 4546 |
Net expected loss
The difference between the Credit expected loss and Expected loss fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | netExpectedLoss | The API identifier used in GraphQL. |
| Number | 2856 |
Net in hire order
The difference between the Credit in hire order and In hire order fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | netInHireOrder | The API identifier used in GraphQL. |
| Number | 2852 |
Net in loan order
The difference between the Credit in loan order and In loan order fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | netInLoanOrder | The API identifier used in GraphQL. |
| Number | 2854 |
Net in order
The difference between the Credit in order and In order fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | netInOrder | The API identifier used in GraphQL. |
| Number | 2851 |
Net in order to prod.
The difference between the Credit in order to prod. and In order to prod. fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | netInOrderToProduction | The API identifier used in GraphQL. |
| Number | 2857 |
Net in production
The difference between the In production and Credit in production fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | netInProduction | The API identifier used in GraphQL. |
| Number | 2859 |
Net in purchase
The difference between the In purchase and Credit in purchase fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | netInPurchase | The API identifier used in GraphQL. |
| Number | 2858 |
Net in stock transfer
The difference between the In stock transfer to and In stock transfer from fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | netInStockTransfer | The API identifier used in GraphQL. |
| Number | 2860 |
Net stock change
The total Net stock change for all 8 transaction types.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | netStockChange | The API identifier used in GraphQL. |
| Number | 2850 |
Physical stock balance closing balance
The physical stock balance closing balance calculated on the basis of the Physical stock value in the Stock balance table.
This field does not take into account the balance within and outside the lead time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ClosBal | The database field name. |
| API identifier | physicalStockBalanceCb | The API identifier used in GraphQL. |
| Number | 13874 |
Physical stock balance opening balance
The physical stock balance opening balance calculated on the basis of increases and decreases.
This field does not take into account the balance within and outside the lead time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | IncBal | The database field name. |
| API identifier | physicalStockBalanceOb | The API identifier used in GraphQL. |
| Number | 10961 |
Product no.
The product no. that the stock change applies to.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Product no. | Text (40) |
| Primary key | Yes | Product no., Warehouse no., Delivery date |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProdNo | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 2847 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| 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. | |
| Product | Product |
|
Realised year/week
The year and week number based on delivery date.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Realised year/week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | YrWk | The database field name. |
| API identifier | realisedYearAndWeek | The API identifier used in GraphQL. |
| Number | 5894 |
Reservations outside lead time
This field shows the difference between the Increase outside lead time, Decrease outside lead time and Reservations within lead time fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RsvOuts | The database field name. |
| API identifier | reservationsOutsideLeadTime | The API identifier used in GraphQL. |
| Number | 6553 |
Sent from supplier
How much of the ordered quantity has been sent from the supplier.
The field is updated on the basis of the same date in the purchase order lines as the unrealised stock changes.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Sent | The database field name. |
| API identifier | sentFromSupplier | The API identifier used in GraphQL. |
| Number | 6315 |
Warehouse no.
Which warehouse no. the stock change relates to.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Warehouse no. | Integer |
| Primary key | Yes | Product no., Warehouse no., Delivery date |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StcNo | The database field name. |
| API identifier | warehouseNo | The API identifier used in GraphQL. |
| Number | 2848 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| 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. | |
| Warehouse | Warehouse |
|
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. |