BATCH_COMPUTATION_LOG | |
| Log of computation runs, identifying their type and initiator | |
| Column | Description |
|---|---|
| computation_id | Identification of a specific computation run |
| computation_type | Type of computation |
| start | Time of computation start |
| end | Time of computation end |
| crashed | Identification if computation crashed |
| batch_count | Number of processed batches |
| plid_count | Number of processed SKUs (product-locator) |
CATEGORY | |
| Product and warehouse categories | |
| Column | Description |
|---|---|
| category_id | Category |
| category_id_from_customer | Category external identification |
| category_type_id | Category type |
| category_name | Catgory name |
| category_shortcut | Category abbreviation |
CATEGORY_TYPE | |
| Types of categories | |
| Column | Description |
|---|---|
| category_type_id | Category type ofc_id_from_customer |
| category_type_name | Category type name |
CLIENT | |
| Register of customers | |
| Column | Description |
|---|---|
| client_id | Identification of a Client (Customer) |
| client_id_from_customer | External client ID as provided |
| client_name | Client name |
| client_shortcut | Abbreviation |
CONFIGURATION | |
| This table resumes settings on global level, contained in multiple tables. For more detail and enumeration of the tables, see description of config tables at https://doc.logio.cz/docs/Veritico/master/STOCK_DB_CONFIG/ | |
| Column | Description |
|---|---|
| config_table | Internal configuration table |
| config_key | Configuration paramater |
| config_value | Configured paramater value |
| computation_id | Reference to computation run |
CONFIGURATION_PRODUCT_LOCATOR | |
| This table resumes settings on product-locator level contained in multiple tables: forecast_configuration_product_locator, iopt_dayshare_configuration_product_locator, order_configuration_product_locator, outliers_configuration_product_locator, stockout_configuration_product_locator. For more detail, see description of config tables at https://doc.logio.cz/docs/Veritico/master/STOCK_DB_CONFIG/ | |
| Column | Description |
|---|---|
| config_table | Internal configuration table |
| product_locator_id | Identification of SKU (product-locator) |
| config_key | Configuration parameter |
| config_value | Configuration parameter value |
| computation_id | Reference to computation run |
CURRENCY | |
| Currencies | |
| Column | Description |
|---|---|
| default_currency_id | Default currency id |
| default_currency_code | Default currency code |
| currency_id | Currency id |
| currency_code | Currency code |
| currency_ratio | Currency ration |
| computation_id | Reference to computation run |
DATA_QUALITY_CHECKS | |
| Data quality checks | |
| Column | Description |
|---|---|
| check_id | Data check identification |
| check_name | Data identification name |
DATA_QUALITY_RESULT | |
| Results of data quality checks | |
| Column | Description |
|---|---|
| check_date | Data check run time |
| check_id | Reference to data check |
| check_status | Result of data check |
| computation_id | Reference to computation run |
FORECAST | |
| Sales forecasted as of the first day of a month | |
| Column | Description |
|---|---|
| product_locator_id | SKU identification (product-locator) |
| fcst_date | Date of forecasted day |
| fcst_snapshot_date | Date of forecast |
| fcst_amount | Forecasted sales quantity |
| fcst_quantity_baseline | Forecasted quantity baseline |
| fcst_quantity_adjust_promo | Forecasted quantity increase due to promotion |
| fcst_quantity_adjust_fast_adapt | Forecasted quantity adjustment by Fast Adapt |
| fcst_quantity_adjust_cannibalisation | Forecasted quantity adjustment by canibalisation (in promotion) |
| outlook | Index of forecasted data shift into the future, referenced to the month of forecast computation (1 = current), as set in the forecast_composite_configuration table |
| computation_id | Reference to computation run |
FUTURE_MOVE | |
| Expected transactions (e.g. incoming inventory already ordered) | |
| Column | Description |
|---|---|
| future_move_id_in_pw | Future transaction internal identification |
| product_locator_id | Reference to SKU (prodyct-locator) |
| estimated_delivery_date | Estimated transaction (delivery) date |
| order_date | Date of ordering of the delivery |
| future_move_quantity | Expected quantity delivered |
| future_move_value | Transaction value (price) |
| computation_id | Reference to computation run |
MOVE | |
| Transactions – (sales and replenishment) issuing and receiving stock items | |
| Column | Description |
|---|---|
| pw_move_id | Inventory transaction (move), in and out |
| product_locator_id | Reference to SKU (prodyct-locator) |
| date_of_order | Reference to ordering date |
| amount | Quantity |
| amount_without_cancelation | Quantity adjusted of cancellations |
| price | Price |
| stock_price | Stock price |
| move_type_id | Reference to transaction type |
| client_id | Reference to client (customer) |
| date | Transaction date |
| computation_id | Reference to computation run |
MOVE_TYPE | |
| Type of fransaction | |
| Column | Description |
|---|---|
| move_type_id | Warehouse transaction type id |
| move_type_name | Warehouse transaction type name |
ORDER_FROM_CLIENT | |
| Orders from client (possible future sales) | |
| Column | Description |
|---|---|
| ofc_id | Identification of order-by-client |
| product_locator_id | Reference to SKU (product-locator) |
| ofc_id_from_customer | Reference to external order |
| ofc_order_date | Order date |
| est_sale_date | Estimated sale |
| ofc_quantity | Ordered quantity |
| client_id | Reference to ordering client/customer |
| computation_id | Reference to computation run |
ORDER_SUGGESTED | |
| Orders suggested by STOCK, per date | |
| Column | Description |
|---|---|
| pw_order_sugg_row_id | Order row identification |
| product_locator_id | Reference to SKU (product-locator) |
| supplier_id | Refernce to supplier |
| suggested_order_date | Date of ordering |
| estimated_delivery_date | Estimated delivery date of order |
| order_quantity | Suggested ordered quantity |
| quantity_computed | Suggested quantity as computed |
| quantity_ordering_unit | Suggested ordered quantity in ordering unit |
| ordering_unit | Ordering unit |
| promotion_id | Reference to promotion |
| delivery_slot_id | Reference to delivery slot (intra-day dalivery) |
| computation_id | Reference to computation run |
PRODUCT_CATEGORY | |
| Product categories | |
| Column | Description |
|---|---|
| category_id | product category identification |
| product_id | Reference to product |
PRODUCTION_SUGGESTED | |
| Suggested production of products | |
| Column | Description |
|---|---|
| pw_production_sugg_id | Suggested item production identification |
| product_locator_id | Reference to SKU (product-locator) |
| date | Suggestion date |
| production_date | Suggested production date |
| amount | Suggested quantity |
| amount_ordering_unit | Suggested quantity in ordering unit |
| ordering_unit | Ordering unit |
| computation_id | Reference to computation run |
PRODUCT | |
| Products | |
| Column | Description |
|---|---|
| product_id | Product identification |
| product_id_from_customer | Reference to external product identification |
| product_name | Product name |
| product_shortcut | Product abbreviation |
PROMOTION | |
| Promotion actions | |
| Column | Description |
|---|---|
| promotion_id | Promotion identification |
| promotion_name | Promotion description |
| promotion_shortcut | Promotion abbreviation (code) |
| promotion_id_from_customer | Reference to external promotion identification |
REDISTRIBUTION_SUGGESTED | |
| Suggested transfer of goods between warehouses | |
| Column | Description |
|---|---|
| pw_order_id | Suggested redistribution identification (order id) |
| redist_date | Suggested distribution date |
| delivery_date | Expected delivery date |
| redist_quantity | Quantity for redistribution |
| redist_quantity_computed | Qriginal quantity for redistribution |
| redist_quantity_ordering_unit | Quantity for redistribution in ordering unit |
| ordering_unit | Ordering unit |
| source_product_locator_id_in_pw | Reference to source product-locator |
| target_product_locator_id_in_pw | Reference to target product-locator |
| computation_id | Reference to computation run |
RESERVE_DAILY | |
| Stock level by date | |
| Column | Description |
|---|---|
| product_locator_id | Reference to SKU (product-locator) |
| reserve_date | Date of reserve |
| reserve_quantity | Reserve quantity |
STOCKOUT_POTENCIAL | |
| List of potential product running out-of-stock in the future (based on current inventory level and forecast) | |
| Column | Description |
|---|---|
| product_locator_id | Reference to SKU (product-locator) |
| date_from | Expected to be out of stock from date |
| date_to | Expected to be out of stock until date |
| estimated_lost_sales_quantity | Expected lost sales |
| potential_sales_price | Potential lost sales value |
| computation_id | Reference to computation run |
STOCKOUT | |
| List of detected incidents of out-of-stock products | |
| Column | Description |
|---|---|
| product_locator_id | Reference to SKU (product-locator) |
| stockout_date_from | Out of stock from date |
| stockout_date_to | Out of stock until date |
| estimated_sale_per_day | Estimated lost sales quantity per day |
| stockout_is_promo | Stockout during promotion |
| promotion_id | Reference to promotion |
| stockout_sales_price | Estimated lost sales in value |
| computation_id | Reference to computation run |
SUPPLIER | |
| Suppliers | |
| Column | Description |
|---|---|
| supplier_id | Supplier identification |
| supplier_id_from_customer | External supplier identification |
| supplier_name | Supplier name |
| supplier_shortcut | Supplier abbreviation |
WAREHOUSE_CATEGORY | |
| Warehouse categories | |
| Column | Description |
|---|---|
| category_id | Reference to hierarchy level |
| warehouse_id | Warehouse identification |
WAREHOUSE_PRODUCT_PROMOTION | |
| Promoted items, products in a warehouse | |
| Column | Description |
|---|---|
| promotion_id | Reference to promotion |
| product_locator_id | Reference to SKU (product-locator) |
| promo_type_id | Promo type ID |
| date_from | In promotion from date |
| date_to | In promotion until date |
| discounted_price | Discounted price |
| discounted_purchase_price | Discounted purchase price |
| base_price | Base price |
| nonpromo_purchase_price | Purchase price withou promotion |
| quantity_total_predicted | Sales in promotion predicted |
| quantity_total_real | Sold in promotion total quantity |
| quantity_post_promo | Sold after promotion, cannibalized |
| quantity_purchase | Quantity purchased for the promotion |
| computation_id | Reference to computation run |
WAREHOUSE_PRODUCT | |
| SKUs, items – products in a warehouse | |
| Column | Description |
|---|---|
| product_locator_id | Identification of SKU (product-locator) |
| warehouse_id | Reference to warehouse |
| product_id | Reference to product |
| stock_price | Stock (purchase) price |
| sale_price | Sale price |
| new_product | Is a new product? |
| selling_out | Is selling out? |
| sporadic | Is sporadic/slow-moving? |
| dont_order | No to be ordered? |
| zero_forecast | Should forecast be zeroed? |
| zero_basestock | Should basestock be zeroed? |
| zero_safetystock | Should safetystock be zeroed? |
| zero_promo_safetystock | Should be promotion safetystock be zeroed? |
| order_only_ofc | Is replenished only in case of order from customer? |
| promo_only | Is sold only in promotion? |
| mandatory | Is mandatory? |
| rounding | How many decimals should be used? |
| sale_set | Sale set |
| expiration_in_days | Days of shelf-life remaining |
| available_supply | Quantity available in stock |
| purchase_price | Purchase price |
| virtual_parent_product_locator_id | Reference to virtual unit |
| vat_in_percent | Value-Added Tax in per cent |
| fast_adapt_this_month | Fast adapt this month |
| category_management_id | Reference to CatMan group |
| expiration_days | Days of shelf-life |
| expiration_days_for_orders | Expiration days for orders |
| expiration_days_for_orders_critical | Expiration days for orders critical |
| flag | Flag |
| promo_product | Product in promotion |
| catalogue_sale_price | Catalogue sale price |
| buyer | Reference toproduct buyer |
| freeze_forecast | Should forecast be freezed? |
| zero_promo_forecast | Should be promotion forecast be zeroed? |
| special_type_id | Reference to special type |
| critical | Critical |
| sale_internal | Sale inetrnal |
| safetystock_modified | Modified safetystock |
| basestock_modified | Modified basestock |
| stockout_level | Stockout level |
| blocking_value | Blocking value |
| blocking_amount | Blocking amount |
| ofc_value | Value of customers' orders |
| ofc_amount | Quantity for customers' orders |
| abc_value | ABC value |
| overstock_amount | Overstock amount |
| computation_id | Reference to computation run |
WAREHOUSE_PRODUCT_SUPPLIER | |
| Supplier of product for a warehouse | |
| Column | Description |
|---|---|
| product_locator_id | Reference to SKU (product-locator) |
| supplier_id | Reference to supplier |
| computation_id | Reference to computation run |
WAREHOUSE | |
| Warehouses | |
| Column | Description |
|---|---|
| warehouse_id | Warehouse identification |
| warehouse_id_from_customer | Warehouse external id |
| warehouse_name | Warehouse name |
| warehouse_shortcut | Warehouse abbreviation |