Runs the daily shortage meeting on live projected stock: planning, sourcing, sales and the plant allocate scarce components to orders and write the decisions to the ERP.
Tables are read in place through the native Snowflake connector: the app sends only the filter and the columns it needs, Snowflake returns the matching rows. The Backbone landing model (RAW, CONFORMED and HISTORY schemas) is the usual source, so history and aggregates are already prepared.
| Object | Read from | Fields the app uses | Freshness |
|---|---|---|---|
| Material master | CONFORMED.MATERIAL | material_id (id) · description (desc) · material_type (type) · plant (plant) | prepared by the Backbone; refreshed on its schedule |
| Stock position | CONFORMED.STOCK_POSITION · HISTORY.STOCK_DAILY | on_hand_qty (on hand) · material_id (material) · plant (plant) · storage_location (sloc) | prepared by the Backbone; refreshed on its schedule |
| Purchase order line | CONFORMED.PURCHASE_ORDER_LINE · HISTORY.PO_LINE_VERSIONS | ordered_qty (qty) · received_qty (received qty) · po_number (number) · po_line (line) | prepared by the Backbone; refreshed on its schedule |
| Production order | CONFORMED.PRODUCTION_ORDER | order_qty (qty) · order_id (number) · material_id (material) · start_date (start) | prepared by the Backbone; refreshed on its schedule |
| Sales order line | CONFORMED.SALES_ORDER_LINE | ordered_qty (qty) · so_number (number) · so_line (line) · customer_id (customer) | prepared by the Backbone; refreshed on its schedule |
| Bill of materials | CONFORMED.BOM_COMPONENT | parent_material (parent) · component_material (component) · component_qty (qty) · valid_from (valid from) | prepared by the Backbone; refreshed on its schedule |
In plain words: Each working day at 07:00 the app projects stock for every component on the critical list; a component whose projected stock falls below 0 within 4 weeks is on that day's agenda.
The criterion runs in Snowflake through the data handler, so only the matching rows return. The editor shows the rows it selects, and their count, as it is written.
# start criterion in Snowflake fields on_hand_qty + (ordered_qty - received_qty due within 28 days) < demand from order_qty and ordered_qty within 28 days # the same criterion in canonical fields {stock.on_hand} + ({po.qty} - {po.received_qty} due within 28 days) < demand from {prod_order.qty} and {so.qty} within 28 days
Decisions are recorded in a Lima-owned table in Snowflake through stage, COPY INTO and MERGE, so analytics see them next to the history. The operational write goes to the system of record through its released interface, and the app records the acknowledgement. For this app the operational change (start and finish dates changed to the allocation) goes to SAP S/4HANA or Oracle Fusion through its released interface, and the pair pages for those systems show the exact call.
| Object | What changes | Interface |
|---|---|---|
| Production order | start and finish dates changed to the allocation | MERGE into LIMA.APP_DECISIONS |
| Purchase order line | pull-in date and quantity changed on the schedule line; premium buy added as a new line | MERGE into LIMA.APP_DECISIONS · PO change to the ERP |
| Sales order line | confirmed quantity and date updated on the customer order | MERGE into LIMA.APP_DECISIONS |
Each write stores the identifier Snowflake returns beside the decision, the person and the time, so the log answers who changed what, and the reconciliation shows it arrived.
Snowflake roles and row-access policies are mapped to Lima access policies once, so a person sees the same rows in the app that they see in a worksheet.
This app reads material master from Snowflake because the screens need history at scale: months of rows, aggregates by period, several versions. The Backbone lands the objects in the conformed model and refreshes them on a schedule, and the handler reads them in place with the filter and the columns pushed down. The person's grants in Snowflake decide what they see.
The operational rows the person acts on can come live from the ERP in the same app: one handler per object per system, and a screen that shows both.
The screens read through handlers that leave the rows in Snowflake. The conformed tables it reads were landed there by the Backbone from the ERP; the app reads them there.
The prerequisites above: an integration identity with read rights on the objects listed and write rights on the interfaces named, connectivity, and the scopes agreed with the process owner.
Yes. The screens, criteria and roles stay; the handlers are re-bound to the other system's objects, and the app's other system pages show them.
Bring the process and the systems it touches. In the first session we register the data handlers, draw the levels or the lanes and run the first screen on your live rows.
