Pick list
This table contains one row for each pick list printed for an order.
Rows are added to this table from the Pick lists report in the Order table.
You can join the Pick list table with the Reservation table, to see the picked items.
The process that is being performed, has been completed or has been attempted for the pick list is presented in the Pick list status field.
See also: Pick list
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | PicLst | The table name in the database. |
| API identifier | pickList | The API identifier used in GraphQL. |
| Table no. | 164 | The table number in the data model. |
The following fields exist in this table:
Order no.
The order number.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Order no. | Integer |
| Primary key | Yes | Pick list no., Order no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdNo | The database field name. |
| API identifier | orderNo | The API identifier used in GraphQL. |
| Number | 5036 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | Order |
|
Pick list no.
A unique number identifying the pick list.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Pick list no., Order no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PicLstNo | The database field name. |
| API identifier | pickListNo | The API identifier used in GraphQL. |
| Number | 4977 |
Pick list run no.
The run number to which the pick list belong.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RunNo | The database field name. |
| API identifier | pickListRunNo | The API identifier used in GraphQL. |
| Number | 5997 |
Pick list status
The process that is being performed, has been completed or has been attempted for the pick list.
The other status levels then 1 and 2 are determined by the selections you made under Processing in the menu bar, in the Pick lists table.
This takes place subject to the selections you make under the Print tab in the Processing method dialog box, for example if an order or order line is to be Picked completely, Pick complete structures or Same fraction of structure lines to be picked. You will see a star in the margin beside order lines that Business NXT does not pick. However, they are nevertheless included in the printout. This is because something else is being picked in the structure or the order line.
- 1 - Reserving in progress
- The pick list has this status while printing is in progress.
- 2 - Reserving completed
- The pick list is given this status when the printing is done.
- 3 - Finishing in progress
- 4 - Finishing completed
- 5 - Withdrawal in progress
- 6 - Withdrawal too late
- 7 - Empty pick list
- No longer set. A pick list where nothing can be picked is deleted instead of being saved. Rows created earlier can still have this status.
- 8 - Withdraw
- The rows in the Pick lists table are not deleted on withdrawal, but are given this status.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Pick list status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PicLstSt | The database field name. |
| API identifier | pickListStatus | The API identifier used in GraphQL. |
| Number | 4978 |
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. |