Domain - Purchase diary
Domain description
This domain contains the purchase diary (by cultural institution) of a selection of goods and corresponds to the view D_GOODS_PURCHASE_DIARY_V1_0 in which:
1 record = 1 purchase order (by cultural institution) of a good intended to a storage place with the information related to:
The good product
The order (date, quantity, price, supplier)
Storage place
Domain's columns description
The following link contains more information on the data of the domain: D_GOODS_PURCHASE_DIARY
Domain - Stock status
Domain description
This domain contains stock status of goods and corresponds to the view D_GOODS_STATUS_V1_0 in which:
1 record = stock status of a given good in a given storage place with the information related to:
- The good product
- Quantity and total order price of the stock
- Storage place
A record is identified in a unique way by means of the attributes: T_GOODSITEM_ID, T_GOODSSTOCK_ID
Domain's columns description
The following link contains more information on the data of the domain: D_GOODS_STATUS