Stocktaking record specifications

Stocktaking record specifications

tp_StoreInventoryWriteOffItems - tp_StoreInventoryWriteOffItems

Object: Stocktaking record

Field

Name

Description

siwi_ID

ID for: Stocktaking record specifications

siwi_sinv_ID

Document

Document. Link to tp_StoreInventories (Stocktaking records)

siwi_pitm_ID

Stock item

Stock item. Link to tp_ProductItems (Stock items)

siwi_part_ID_Alco

Manufacturer

siwi_patp_ID

Alcoholic beverage sort

tp_ProductAlcoTypes

siwi_serc_ID

Store processing result. You need to check the status of the document processing progress. If its status indicates 'Running', the document has not yet been processed. Link to tp_StoreEngineResultCodes (Store document processing errors)

siwi_Volume

Accepted difference

Accepted difference. Stored in baseline units of measurement for a given stock item taking into account the ratio in its unit of measurement group. For example, the document might display "Potato" - 200 g The unit of measurement (g) has the ratio 0.001. Therefore, in the base it would be stored as 0.2.

siwi_CalcVolume

Calculated difference

Calculated difference Stored in baseline units of measurement for a given stock item taking into account the ratio in its unit of measurement group. For example, the document might display "Potato" - 200 g The unit of measurement (g) has the ratio 0.001. Therefore, in the base it would be stored as 0.2.

siwi_VolumeRegister

Theoretical on hand

Theoretical on hand Stored in baseline units of measurement for a given stock item taking into account the ratio in its unit of measurement group. For example, the document might display "Potato" - 200 g The unit of measurement (g) has the ratio 0.001. Therefore, in the base it would be stored as 0.2.

siwi_Price

Price

Price

siwi_Sum

Total

Total

siwi_EditIndex

Reference field It is used in the interface of editor windows for automatic recalculation of prices, amounts, etc.

siwi_Done

Confirmed

Used for calculation. If a stock item is calculated, the stock on hand has been checked and confirmed. This stock item will not be used in processing during the next calculation.

siwi_GTD

Customs declaration number

siwi_IsDeleted

When the user deletes a stock item from the specification, the stock item is not immediately deleted from the document. Instead, it is just marked to be deleted. Deletion will take place after the document will have been processed by the storekeeping system if there are no reasons, which prevent this operation (closed period, this item has been deducted, etc.)