Version: 1.0
| Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
|---|---|---|---|---|---|
| DESIGNATION | VARCHAR2 | 492 | Y | Item | Item deisgnation |
| GOODS_COLLECTION | VARCHAR2 | 240 | Y | Collection | Name of goods collection |
| GOODS_DIMENSION | VARCHAR2 | 4000 | Y | Goods item characteristics | Conctenated value of good dimensions (example: Size:M, Colour: Red) |
| GOODS_FAMILY | VARCHAR2 | 240 | Y | Goods family | Name of goods family |
| GOODS_SUBFAMILY | VARCHAR2 | 240 | Y | Goods sub-family | Name of subfamily of goods product (only level 1) |
| GOODS_SUBTOPIC | VARCHAR2 | 240 | Y | Goods sub-topic | Name of subtopic of goods product (only level 1) |
| GOODS_TOPIC | VARCHAR2 | 240 | Y | Goods topic | Name of topic of goods product |
| G_AVG_ITEM_AMT_ETX | NUMBER | 22 | Y | Weighted avg price | Average unit amount of item purchase |
| G_TOTAL_AMT_ETX | NUMBER | 22 | Y | Total amount net HT | Total amount of item purchase |
| INSTIT_CODE | VARCHAR2 | 15 | N | Institution code | |
| QUANTITY | NUMBER | 22 | Y | Quantity | Number of items in stock |
| REFERENCE | VARCHAR2 | 80 | N | Reference | Item reference |
| STORAGE_LOCATION | VARCHAR2 | 240 | Y | Name of storage location | |
| T_FAMILY_ID | NUMBER | 22 | Y | Technical identifier of goods family | |
| T_GOODSCOLLECTION_ID | NUMBER | 22 | Y | Technical identifier of goods collection | |
| T_GOODSITEM_ID | NUMBER | 22 | N | Technical identifier of goods item | |
| T_GOODSSTOCK_ID | NUMBER | 22 | Y | Technical identifier of goods stock status (for the given goods item and storage location) | |
| T_ORGANIZATION_ID | NUMBER | 22 | N | Technical identifier of organization | |
| T_SUBFAMILY_ID | NUMBER | 22 | Y | Technical identifier of goods subfamily | |
| T_SUBTOPIC_ID | NUMBER | 22 | Y | Technical identifier of goods subtopic | |
| T_TOPIC_ID | NUMBER | 22 | Y | Technical identifier of goods topic | |
| WARNING_THRESHOLD | NUMBER | 22 | Y | If the stock is lower than this value, the item should be ordered to some provider |