© Tillypad, 2008-2015
- 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 | |
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.) |