Sales record specifications (stock items)

Sales record specifications (stock items)

tp_SaleDocumentItems - tp_SaleDocumentItems

Object: Sales record

Field

Name

Description

sdit_ID

ID for: Sales record specifications (stock items)

sdit_sdoc_ID

Document

Document. Link to tp_SaleDocuments (Sales records)

sdit_sdit_ID_Parent

Parent

Parent If the field's value equals NULL, this is a composed dish. If the field's value is not NULL, this is an ingredient of the recipe.

sdit_pitm_ID

Stock item

Stock item. Link to tp_ProductItems (Stock items)

sdit_meit_ID

Unit of measurement for sales record specification

Unit of measurement for stock item quantity. Link to tp_MeasureItems (Stock item units of measurement)

sdit_cmmd_ID

Recipe mode. The Recipe mode field determines whether the recipe will be unfolded when the stock item is added to the store document specification or when it is recalculated. The recipe mode is specified for stock item recipe ingredients and for store document specification items (except for Stock-in and Butchering records). There are three recipe modes: 1. By stock item concurrence – the stock item concurrence determines whether the recipe needs to be unfolded 2. Always without recipe – the stock item is always added without recipe 3. Always with recipe – the recipe of the stock item is always unfolded irrespective of the concurrence. Link to tp_CompoundModes (Recipe modes)

sdit_Volume_OrderItems

???

sdit_Volume

Quantity

Stock item quantity 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.

sdit_Netto

Net

Net. 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.

sdit_VolumeOut

Yield

Yield of the stock item (preparation wastages are taken into account) 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.

sdit_EditIndex

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

sdit_Comment

Comment

Comment

sdit_Order

Index

Index. This is an info field. It is used to sort out items in the list

sdit_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)

sdit_Done

Calculated

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

sdit_IsDeleted

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