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

siwi_patp_ID

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

Используется при калькулировании. Если продукт скалькулирован, то он сверен с остатками и подтвержден. При следующем калькулировании этот продукт не будет использоваться в обработке.

siwi_GTD

siwi_IsDeleted

При удалении пользователем продукта из спецификации, продукт не удаляется сразу из документа, а только помечается на удаление. Удаление произойдет только после проводки документа по складу, если не будет обнаружено причин припятствующих этой операции (закрытый период, есть списания с этой позиции и т.д.)