Published — v. 10

Theme: Goods

Owned by noemie.hermans (Unlicensed)
Last updated: Dec 18, 2023 by Bertrand BECHET
1 min read

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

This domain is available since Matterhorn V3.

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

This domain is available since Matterhorn V3.

Domain's columns description

The following link contains more information on the data of the domain: D_GOODS_STATUS

© SecuTix 2023 - Login