© Tillypad 2008-2014
- 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 | ||
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 |
При удалении пользователем продукта из спецификации, продукт не удаляется сразу из документа, а только помечается на удаление. Удаление произойдет только после проводки документа по складу, если не будет обнаружено причин припятствующих этой операции (закрытый период, есть списания с этой позиции и т.д.) |