inventorycount
Tracks inventory counts, including cycle counts and full physical inventory counts, to maintain stock accuracy.
Columns
| Name | Type | References | Description |
| account | String | The general ledger account associated with this inventory count. This helps track financial impacts and categorizations within the chart of accounts. | |
| class | String | The classification of the inventory count, which can be used for reporting and segmentation purposes. | |
| createddate | Datetime | The date and time when this inventory count record was initially created in the system. | |
| department | String | The department associated with this inventory count. This can help with financial reporting and cost allocation. | |
| externalid | String | A unique identifier assigned to this record by an external system, facilitating data integration and synchronization. | |
| lastmodifieddate | Datetime | The date and time when this inventory count record was last updated or modified. | |
| location | String | The physical or logical location where the inventory count took place. This helps track inventory levels across multiple locations. | |
| memo | String | A free-form text field for adding additional notes or details related to this inventory count. | |
| status | String | The current status of the inventory count, indicating whether it is pending, in progress, completed, or otherwise. | |
| statusRef | String | A reference code associated with the status of the inventory count, often used for internal processing or API integrations. | |
| subsidiary | String | The subsidiary to which this inventory count belongs. This is relevant for multi-entity organizations that track inventory separately by subsidiary. | |
| trandate | Date | The transaction date of the inventory count, which represents when the count was conducted or recorded. | |
| tranid | String | A unique identifier or transaction number assigned to this inventory count within the system. |