Bin
Stores data about bins used in warehouse or inventory management, including identifiers and descriptions.
Table Specific Information
Select
- In the Legacy API, SELECT * queries return not only the columns documented below, but additional columns as well.
- In the non-Legacy API, you cannot use SELECT * with this table. You should build a query with the columns listed below, for example:
SELECT Recordno, Binid, Bindesc, Whencreated, Whenmodified, Createdby, Modifiedby FROM Bin
Columns
| Name | Type | ReadOnly | Description |
| Recordno | Int64 | False |
A unique identifier for the bin record. |
| Binid [KEY] | String | False |
The identifier for the bin. |
| Bindesc | String | False |
The description of the bin. |
| Whencreated | Datetime | False |
The date and time when the bin record was created. |
| Whenmodified | Datetime | False |
The date and time when the bin record was last modified. |
| Createdby | Int64 | False |
The ID of the user or process that created the bin record. |
| Modifiedby | Int64 | False |
The ID of the user or process that last modified the bin record. |
| Record_url | String | False |
Provides a URL to access the bin record. |