{"ok":true,"success":true,"canonical":true,"status":"READY","code":"CODEX645","thread":"CODEX645_INVENTORY_STOCK_LEDGER_EXECUTION","marker":"CODEX645_INVENTORY_STOCK_LEDGER_EXECUTION_SERVER_JS_OWNER","sourceTruth":"latest CODEX775 truth only","owner":"backend/server.js","route":"/api/trade-core/erp/inventory/movement-ledger","aliasFor":"/api/trade-core/erp/inventory-warehouse/execution-chain/movement-ledger","view":"movement_ledger","label":"Inventory movement ledger compatibility readback","generatedAt":"2026-07-17T06:45:37.361Z","sourceTables":["erp_inventory_movement_ledger","trade_inventory_snapshots"],"sourceHealth":{"totalSources":2,"existingSources":2,"readySources":2,"partialSources":0},"readbacks":[{"table":"erp_inventory_movement_ledger","status":"READY","exists":true,"rowCount":91,"sampledRows":25,"columnsPresent":36,"columns":["id","movement_ref","transfer_id","movement_type","module_key","sector","listing_id","order_id","reservation_id","warehouse_code","counterparty_warehouse_code","qty_delta","qty_balance","status","source_table","payload_json","created_at","product_key","product_name","module_tag_json","product_tag_json","batch_id","production_order_id","flow_stage","company_id","branch_id","product_master_id","source_document_id","source_document_type","bin_code","lot_no","serial_no","item_code","uom","stock_status","location_id"],"sample":[{"id":"91","movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT-1783951029","transfer_id":"","movement_type":"ADJUSTMENT_GAIN","module_key":"yarn","sector":"textile","listing_id":"F5-LIST-YARN","order_id":"","reservation_id":"","warehouse_code":"MAIN","counterparty_warehouse_code":"","qty_delta":"10","qty_balance":null,"status":"POSTED","source_table":"erp_inventory_adjustments","payload_json":{"id":"2ae2aa92-b006-49af-a209-22df700afc64","source":"migration_schema_shell","status":"POSTED","metadata":{"uom":"kg","actorId":"admin-1","countId":"F5-STOCK-COUNT-1783951029","itemCode":"F5-ITEM-YARN","listingId":"F5-LIST-YARN","moduleKey":"yarn","locationId":"SELLABLE","reasonCode":"uat_stock_seed","warehouseCode":"MAIN","countedQuantity":100,"productMasterId":"PM-yarn"},"item_code":"F5-ITEM-YARN","company_id":"ach-admin","created_at":"2026-07-13T13:57:14.080074+00:00","created_by":null,"updated_at":"2026-07-13T13:57:14.080074+00:00","updated_by":null,"approved_by":"admin-2","location_id":"SELLABLE","reason_code":"uat_stock_seed","external_ref":null,"movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT-1783951029","warehouse_id":null,"adjustment_no":"ADJ-F5-STOCK-COUNT-1783951029","adjustment_qty":10,"approval_status":"APPROVED","idempotency_key":null},"created_at":"2026-07-13T13:57:14.083Z","product_key":"F5-LIST-YARN","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":null,"orderId":"","listingId":"F5-LIST-YARN","productKey":"F5-LIST-YARN","productName":null},"batch_id":null,"production_order_id":null,"flow_stage":"ADJUSTMENT_GAIN","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-yarn","source_document_id":"ADJ-F5-STOCK-COUNT-1783951029","source_document_type":"ADJUSTMENT","bin_code":"SELLABLE","lot_no":"","serial_no":"","item_code":"F5-ITEM-YARN","uom":"kg","stock_status":"AVAILABLE","location_id":"SELLABLE"},{"id":"90","movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT-1783950974","transfer_id":"","movement_type":"ADJUSTMENT_GAIN","module_key":"yarn","sector":"textile","listing_id":"F5-LIST-YARN","order_id":"","reservation_id":"","warehouse_code":"MAIN","counterparty_warehouse_code":"","qty_delta":"10","qty_balance":null,"status":"POSTED","source_table":"erp_inventory_adjustments","payload_json":{"id":"c99702bf-b414-466f-a253-0b9ba5a900d5","source":"migration_schema_shell","status":"POSTED","metadata":{"uom":"kg","actorId":"admin-1","countId":"F5-STOCK-COUNT-1783950974","itemCode":"F5-ITEM-YARN","listingId":"F5-LIST-YARN","moduleKey":"yarn","locationId":"SELLABLE","reasonCode":"uat_stock_seed","warehouseCode":"MAIN","countedQuantity":100,"productMasterId":"PM-yarn"},"item_code":"F5-ITEM-YARN","company_id":"ach-admin","created_at":"2026-07-13T13:56:18.740005+00:00","created_by":null,"updated_at":"2026-07-13T13:56:18.740005+00:00","updated_by":null,"approved_by":"admin-2","location_id":"SELLABLE","reason_code":"uat_stock_seed","external_ref":null,"movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT-1783950974","warehouse_id":null,"adjustment_no":"ADJ-F5-STOCK-COUNT-1783950974","adjustment_qty":10,"approval_status":"APPROVED","idempotency_key":null},"created_at":"2026-07-13T13:56:18.742Z","product_key":"F5-LIST-YARN","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":null,"orderId":"","listingId":"F5-LIST-YARN","productKey":"F5-LIST-YARN","productName":null},"batch_id":null,"production_order_id":null,"flow_stage":"ADJUSTMENT_GAIN","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-yarn","source_document_id":"ADJ-F5-STOCK-COUNT-1783950974","source_document_type":"ADJUSTMENT","bin_code":"SELLABLE","lot_no":"","serial_no":"","item_code":"F5-ITEM-YARN","uom":"kg","stock_status":"AVAILABLE","location_id":"SELLABLE"},{"id":"89","movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT-1783950799","transfer_id":"","movement_type":"ADJUSTMENT_GAIN","module_key":"yarn","sector":"textile","listing_id":"F5-LIST-YARN","order_id":"","reservation_id":"","warehouse_code":"MAIN","counterparty_warehouse_code":"","qty_delta":"10","qty_balance":null,"status":"POSTED","source_table":"erp_inventory_adjustments","payload_json":{"id":"3b6de760-b8b0-4cb5-9aaa-16f5b841b82c","source":"migration_schema_shell","status":"POSTED","metadata":{"uom":"kg","actorId":"admin-1","countId":"F5-STOCK-COUNT-1783950799","itemCode":"F5-ITEM-YARN","listingId":"F5-LIST-YARN","moduleKey":"yarn","locationId":"SELLABLE","reasonCode":"uat_stock_seed","warehouseCode":"MAIN","countedQuantity":100,"productMasterId":"PM-yarn"},"item_code":"F5-ITEM-YARN","company_id":"ach-admin","created_at":"2026-07-13T13:53:24.205258+00:00","created_by":null,"updated_at":"2026-07-13T13:53:24.205258+00:00","updated_by":null,"approved_by":"admin-2","location_id":"SELLABLE","reason_code":"uat_stock_seed","external_ref":null,"movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT-1783950799","warehouse_id":null,"adjustment_no":"ADJ-F5-STOCK-COUNT-1783950799","adjustment_qty":10,"approval_status":"APPROVED","idempotency_key":null},"created_at":"2026-07-13T13:53:24.207Z","product_key":"F5-LIST-YARN","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":null,"orderId":"","listingId":"F5-LIST-YARN","productKey":"F5-LIST-YARN","productName":null},"batch_id":null,"production_order_id":null,"flow_stage":"ADJUSTMENT_GAIN","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-yarn","source_document_id":"ADJ-F5-STOCK-COUNT-1783950799","source_document_type":"ADJUSTMENT","bin_code":"SELLABLE","lot_no":"","serial_no":"","item_code":"F5-ITEM-YARN","uom":"kg","stock_status":"AVAILABLE","location_id":"SELLABLE"},{"id":"88","movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT-1783950753","transfer_id":"","movement_type":"ADJUSTMENT_GAIN","module_key":"yarn","sector":"textile","listing_id":"F5-LIST-YARN","order_id":"","reservation_id":"","warehouse_code":"MAIN","counterparty_warehouse_code":"","qty_delta":"10","qty_balance":null,"status":"POSTED","source_table":"erp_inventory_adjustments","payload_json":{"id":"281cedb3-cb06-4835-8623-7a1f71c4b61b","source":"migration_schema_shell","status":"POSTED","metadata":{"uom":"kg","actorId":"admin-1","countId":"F5-STOCK-COUNT-1783950753","itemCode":"F5-ITEM-YARN","listingId":"F5-LIST-YARN","moduleKey":"yarn","locationId":"SELLABLE","reasonCode":"uat_stock_seed","warehouseCode":"MAIN","countedQuantity":100,"productMasterId":"PM-yarn"},"item_code":"F5-ITEM-YARN","company_id":"ach-admin","created_at":"2026-07-13T13:52:37.647506+00:00","created_by":null,"updated_at":"2026-07-13T13:52:37.647506+00:00","updated_by":null,"approved_by":"admin-2","location_id":"SELLABLE","reason_code":"uat_stock_seed","external_ref":null,"movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT-1783950753","warehouse_id":null,"adjustment_no":"ADJ-F5-STOCK-COUNT-1783950753","adjustment_qty":10,"approval_status":"APPROVED","idempotency_key":null},"created_at":"2026-07-13T13:52:37.649Z","product_key":"F5-LIST-YARN","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":null,"orderId":"","listingId":"F5-LIST-YARN","productKey":"F5-LIST-YARN","productName":null},"batch_id":null,"production_order_id":null,"flow_stage":"ADJUSTMENT_GAIN","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-yarn","source_document_id":"ADJ-F5-STOCK-COUNT-1783950753","source_document_type":"ADJUSTMENT","bin_code":"SELLABLE","lot_no":"","serial_no":"","item_code":"F5-ITEM-YARN","uom":"kg","stock_status":"AVAILABLE","location_id":"SELLABLE"},{"id":"87","movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT","transfer_id":"","movement_type":"ADJUSTMENT_GAIN","module_key":"yarn","sector":"textile","listing_id":"F5-LIST-YARN","order_id":"","reservation_id":"","warehouse_code":"MAIN","counterparty_warehouse_code":"","qty_delta":"100","qty_balance":null,"status":"POSTED","source_table":"erp_inventory_adjustments","payload_json":{"id":"d59b461c-b5c2-433b-b337-ba82c70a3514","source":"migration_schema_shell","status":"POSTED","metadata":{"uom":"kg","actorId":"admin-1","countId":"F5-STOCK-COUNT","itemCode":"F5-ITEM-YARN","listingId":"F5-LIST-YARN","moduleKey":"yarn","locationId":"SELLABLE","reasonCode":"uat_stock_seed","warehouseCode":"MAIN","countedQuantity":100,"productMasterId":"PM-yarn"},"item_code":"F5-ITEM-YARN","company_id":"ach-admin","created_at":"2026-07-13T13:49:57.365945+00:00","created_by":null,"updated_at":"2026-07-13T13:49:57.365945+00:00","updated_by":null,"approved_by":"admin-2","location_id":"SELLABLE","reason_code":"uat_stock_seed","external_ref":null,"movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT","warehouse_id":null,"adjustment_no":"ADJ-F5-STOCK-COUNT","adjustment_qty":100,"approval_status":"APPROVED","idempotency_key":null},"created_at":"2026-07-13T13:49:57.369Z","product_key":"F5-LIST-YARN","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":null,"orderId":"","listingId":"F5-LIST-YARN","productKey":"F5-LIST-YARN","productName":null},"batch_id":null,"production_order_id":null,"flow_stage":"ADJUSTMENT_GAIN","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-yarn","source_document_id":"ADJ-F5-STOCK-COUNT","source_document_type":"ADJUSTMENT","bin_code":"SELLABLE","lot_no":"","serial_no":"","item_code":"F5-ITEM-YARN","uom":"kg","stock_status":"AVAILABLE","location_id":"SELLABLE"},{"id":"86","movement_ref":"BCF13B-MOV-DSP-BCF13B-1783753564731","transfer_id":null,"movement_type":"BCF13B_SEED","module_key":"yarn","sector":"textile","listing_id":"B13B-LIST","order_id":null,"reservation_id":null,"warehouse_code":"B13BWH3564816","counterparty_warehouse_code":null,"qty_delta":"9","qty_balance":null,"status":"POSTED","source_table":"codex_bcf13b_uat","payload_json":{"run":"BCF13B-1783753564731"},"created_at":"2026-07-11T07:06:06.324Z","product_key":"B13B-LIST","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"B13B-BATCH","orderId":null,"listingId":"B13B-LIST","productKey":"B13B-LIST","productName":null},"batch_id":"B13B-BATCH","production_order_id":null,"flow_stage":"BCF13B","company_id":"ach-admin","branch_id":"main","product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-DSP-BCF13B-1783753564731","source_document_type":"UAT","bin_code":null,"lot_no":"B13B-LOT","serial_no":null,"item_code":"B13B-ITEM","uom":"kg","stock_status":"AVAILABLE","location_id":"B13BWH3564816-DSP"},{"id":"85","movement_ref":"BCF13B-MOV-IT-BCF13B-1783753564731","transfer_id":null,"movement_type":"BCF13B_SEED","module_key":"yarn","sector":"textile","listing_id":"B13B-LIST","order_id":null,"reservation_id":null,"warehouse_code":"B13BWH3564816","counterparty_warehouse_code":null,"qty_delta":"-4","qty_balance":null,"status":"POSTED","source_table":"codex_bcf13b_uat","payload_json":{"run":"BCF13B-1783753564731"},"created_at":"2026-07-11T07:06:06.323Z","product_key":"B13B-LIST","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"B13B-BATCH","orderId":null,"listingId":"B13B-LIST","productKey":"B13B-LIST","productName":null},"batch_id":"B13B-BATCH","production_order_id":null,"flow_stage":"BCF13B","company_id":"ach-admin","branch_id":"main","product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-IT-BCF13B-1783753564731","source_document_type":"UAT","bin_code":null,"lot_no":"B13B-LOT","serial_no":null,"item_code":"B13B-ITEM","uom":"kg","stock_status":"IN_TRANSIT","location_id":"B13BWH3564816-AVL"},{"id":"84","movement_ref":"BCF13B-MOV-REJ-BCF13B-1783753564731","transfer_id":null,"movement_type":"BCF13B_SEED","module_key":"yarn","sector":"textile","listing_id":"B13B-LIST","order_id":null,"reservation_id":null,"warehouse_code":"B13BWH3564816","counterparty_warehouse_code":null,"qty_delta":"7","qty_balance":null,"status":"POSTED","source_table":"codex_bcf13b_uat","payload_json":{"run":"BCF13B-1783753564731"},"created_at":"2026-07-11T07:06:06.321Z","product_key":"B13B-LIST","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"B13B-BATCH","orderId":null,"listingId":"B13B-LIST","productKey":"B13B-LIST","productName":null},"batch_id":"B13B-BATCH","production_order_id":null,"flow_stage":"BCF13B","company_id":"ach-admin","branch_id":"main","product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-REJ-BCF13B-1783753564731","source_document_type":"UAT","bin_code":null,"lot_no":"B13B-LOT","serial_no":null,"item_code":"B13B-ITEM","uom":"kg","stock_status":"REJECTED","location_id":"B13BWH3564816-REJ"},{"id":"83","movement_ref":"BCF13B-MOV-Q-BCF13B-1783753564731","transfer_id":null,"movement_type":"BCF13B_SEED","module_key":"yarn","sector":"textile","listing_id":"B13B-LIST","order_id":null,"reservation_id":null,"warehouse_code":"B13BWH3564816","counterparty_warehouse_code":null,"qty_delta":"12","qty_balance":null,"status":"POSTED","source_table":"codex_bcf13b_uat","payload_json":{"run":"BCF13B-1783753564731"},"created_at":"2026-07-11T07:06:06.320Z","product_key":"B13B-LIST","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"B13B-BATCH","orderId":null,"listingId":"B13B-LIST","productKey":"B13B-LIST","productName":null},"batch_id":"B13B-BATCH","production_order_id":null,"flow_stage":"BCF13B","company_id":"ach-admin","branch_id":"main","product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-Q-BCF13B-1783753564731","source_document_type":"UAT","bin_code":null,"lot_no":"B13B-LOT","serial_no":null,"item_code":"B13B-ITEM","uom":"kg","stock_status":"QUARANTINE","location_id":"B13BWH3564816-QUA"},{"id":"82","movement_ref":"BCF13B-MOV-AVL-BCF13B-1783753564731","transfer_id":null,"movement_type":"BCF13B_SEED","module_key":"yarn","sector":"textile","listing_id":"B13B-LIST","order_id":null,"reservation_id":null,"warehouse_code":"B13BWH3564816","counterparty_warehouse_code":null,"qty_delta":"100","qty_balance":null,"status":"POSTED","source_table":"codex_bcf13b_uat","payload_json":{"run":"BCF13B-1783753564731"},"created_at":"2026-07-11T07:06:06.318Z","product_key":"B13B-LIST","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"B13B-BATCH","orderId":null,"listingId":"B13B-LIST","productKey":"B13B-LIST","productName":null},"batch_id":"B13B-BATCH","production_order_id":null,"flow_stage":"BCF13B","company_id":"ach-admin","branch_id":"main","product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-AVL-BCF13B-1783753564731","source_document_type":"UAT","bin_code":null,"lot_no":"B13B-LOT","serial_no":null,"item_code":"B13B-ITEM","uom":"kg","stock_status":"AVAILABLE","location_id":"B13BWH3564816-AVL"},{"id":"81","movement_ref":"BCF13B-MOV-DSP-BCF13B-1783753543814","transfer_id":null,"movement_type":"BCF13B_SEED","module_key":"yarn","sector":"textile","listing_id":"B13B-LIST","order_id":null,"reservation_id":null,"warehouse_code":"B13BWH3543987","counterparty_warehouse_code":null,"qty_delta":"9","qty_balance":null,"status":"POSTED","source_table":"codex_bcf13b_uat","payload_json":{"run":"BCF13B-1783753543814"},"created_at":"2026-07-11T07:05:44.391Z","product_key":"B13B-LIST","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"B13B-BATCH","orderId":null,"listingId":"B13B-LIST","productKey":"B13B-LIST","productName":null},"batch_id":"B13B-BATCH","production_order_id":null,"flow_stage":"BCF13B","company_id":"ach-admin","branch_id":"main","product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-DSP-BCF13B-1783753543814","source_document_type":"UAT","bin_code":null,"lot_no":"B13B-LOT","serial_no":null,"item_code":"B13B-ITEM","uom":"kg","stock_status":"AVAILABLE","location_id":"B13BWH3543987-DSP"},{"id":"80","movement_ref":"BCF13B-MOV-IT-BCF13B-1783753543814","transfer_id":null,"movement_type":"BCF13B_SEED","module_key":"yarn","sector":"textile","listing_id":"B13B-LIST","order_id":null,"reservation_id":null,"warehouse_code":"B13BWH3543987","counterparty_warehouse_code":null,"qty_delta":"-4","qty_balance":null,"status":"POSTED","source_table":"codex_bcf13b_uat","payload_json":{"run":"BCF13B-1783753543814"},"created_at":"2026-07-11T07:05:44.390Z","product_key":"B13B-LIST","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"B13B-BATCH","orderId":null,"listingId":"B13B-LIST","productKey":"B13B-LIST","productName":null},"batch_id":"B13B-BATCH","production_order_id":null,"flow_stage":"BCF13B","company_id":"ach-admin","branch_id":"main","product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-IT-BCF13B-1783753543814","source_document_type":"UAT","bin_code":null,"lot_no":"B13B-LOT","serial_no":null,"item_code":"B13B-ITEM","uom":"kg","stock_status":"IN_TRANSIT","location_id":"B13BWH3543987-AVL"},{"id":"79","movement_ref":"BCF13B-MOV-REJ-BCF13B-1783753543814","transfer_id":null,"movement_type":"BCF13B_SEED","module_key":"yarn","sector":"textile","listing_id":"B13B-LIST","order_id":null,"reservation_id":null,"warehouse_code":"B13BWH3543987","counterparty_warehouse_code":null,"qty_delta":"7","qty_balance":null,"status":"POSTED","source_table":"codex_bcf13b_uat","payload_json":{"run":"BCF13B-1783753543814"},"created_at":"2026-07-11T07:05:44.388Z","product_key":"B13B-LIST","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"B13B-BATCH","orderId":null,"listingId":"B13B-LIST","productKey":"B13B-LIST","productName":null},"batch_id":"B13B-BATCH","production_order_id":null,"flow_stage":"BCF13B","company_id":"ach-admin","branch_id":"main","product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-REJ-BCF13B-1783753543814","source_document_type":"UAT","bin_code":null,"lot_no":"B13B-LOT","serial_no":null,"item_code":"B13B-ITEM","uom":"kg","stock_status":"REJECTED","location_id":"B13BWH3543987-REJ"},{"id":"78","movement_ref":"BCF13B-MOV-Q-BCF13B-1783753543814","transfer_id":null,"movement_type":"BCF13B_SEED","module_key":"yarn","sector":"textile","listing_id":"B13B-LIST","order_id":null,"reservation_id":null,"warehouse_code":"B13BWH3543987","counterparty_warehouse_code":null,"qty_delta":"12","qty_balance":null,"status":"POSTED","source_table":"codex_bcf13b_uat","payload_json":{"run":"BCF13B-1783753543814"},"created_at":"2026-07-11T07:05:44.387Z","product_key":"B13B-LIST","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"B13B-BATCH","orderId":null,"listingId":"B13B-LIST","productKey":"B13B-LIST","productName":null},"batch_id":"B13B-BATCH","production_order_id":null,"flow_stage":"BCF13B","company_id":"ach-admin","branch_id":"main","product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-Q-BCF13B-1783753543814","source_document_type":"UAT","bin_code":null,"lot_no":"B13B-LOT","serial_no":null,"item_code":"B13B-ITEM","uom":"kg","stock_status":"QUARANTINE","location_id":"B13BWH3543987-QUA"},{"id":"77","movement_ref":"BCF13B-MOV-AVL-BCF13B-1783753543814","transfer_id":null,"movement_type":"BCF13B_SEED","module_key":"yarn","sector":"textile","listing_id":"B13B-LIST","order_id":null,"reservation_id":null,"warehouse_code":"B13BWH3543987","counterparty_warehouse_code":null,"qty_delta":"100","qty_balance":null,"status":"POSTED","source_table":"codex_bcf13b_uat","payload_json":{"run":"BCF13B-1783753543814"},"created_at":"2026-07-11T07:05:44.385Z","product_key":"B13B-LIST","product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"B13B-BATCH","orderId":null,"listingId":"B13B-LIST","productKey":"B13B-LIST","productName":null},"batch_id":"B13B-BATCH","production_order_id":null,"flow_stage":"BCF13B","company_id":"ach-admin","branch_id":"main","product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-AVL-BCF13B-1783753543814","source_document_type":"UAT","bin_code":null,"lot_no":"B13B-LOT","serial_no":null,"item_code":"B13B-ITEM","uom":"kg","stock_status":"AVAILABLE","location_id":"B13BWH3543987-AVL"},{"id":"76","movement_ref":"BCF13-PICK-BCF13-1783752208962-PICK-1","transfer_id":"","movement_type":"SALES_PICK","module_key":"yarn","sector":"textile","listing_id":"","order_id":"BCF13-1783752208962-SO-2","reservation_id":"BCF13-1783752208962-RES-2B","warehouse_code":"BCF13-1783752208962-WH","counterparty_warehouse_code":"","qty_delta":"-20","qty_balance":null,"status":"POSTED","source_table":"erp_pick_lists","payload_json":{"uom":"kg","lot_no":"LOT-BCF13-1783752208962","status":"PICKED","pick_id":"BCF13-1783752208962-PICK-1","batch_no":"BATCH-BCF13-1783752208962","order_id":"BCF13-1783752208962-SO-2","company_id":"ach-admin","created_at":"2026-07-11T06:48:29.47925+00:00","listing_id":"","picked_qty":20,"location_id":"BCF13-1783752208962-AVL","operator_id":"admin-1","payload_json":{"uom":"kg","pickId":"BCF13-1783752208962-PICK-1","locationId":"BCF13-1783752208962-AVL","allocationRef":"BCF13-1783752208962-ALLOC-1","idempotencyKey":"BCF13-1783752208962-PICK-1","pickedQuantity":20,"productMasterId":"PM-BCF13-1783752208962"},"warehouse_id":"BCF13-1783752208962-WH","allocation_ref":"BCF13-1783752208962-ALLOC-1","idempotency_key":"BCF13-1783752208962-PICK-1","product_master_id":"PM-BCF13-1783752208962"},"created_at":"2026-07-11T06:48:29.481Z","product_key":null,"product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"BATCH-BCF13-1783752208962","orderId":"BCF13-1783752208962-SO-2","listingId":"","productKey":null,"productName":null},"batch_id":"BATCH-BCF13-1783752208962","production_order_id":null,"flow_stage":"SALES_PICK","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-BCF13-1783752208962","source_document_id":"BCF13-1783752208962-PICK-1","source_document_type":"PICK","bin_code":"BCF13-1783752208962-AVL","lot_no":"LOT-BCF13-1783752208962","serial_no":"","item_code":"","uom":"kg","stock_status":"PICKED","location_id":"BCF13-1783752208962-AVL"},{"id":"75","movement_ref":"BCF13-ADJ-MOV-BCF13-1783752208962-ADJ-3","transfer_id":"","movement_type":"ADJUSTMENT_GAIN","module_key":"yarn","sector":"textile","listing_id":"","order_id":"","reservation_id":"","warehouse_code":"BCF13-1783752208962-WH","counterparty_warehouse_code":"","qty_delta":"32","qty_balance":null,"status":"POSTED","source_table":"erp_inventory_adjustments","payload_json":{"id":"140c186e-3215-45a1-9113-20a7acaf221a","source":"migration_schema_shell","status":"POSTED","metadata":{"uom":"kg","lotNo":"LOT-BCF13-1783752208962","actorId":"admin-1","batchNo":"BATCH-BCF13-1783752208962","countId":"BCF13-1783752208962-COUNT-3","itemCode":"YARN-BCF13-1783752208962","approverId":"admin-2","locationId":"BCF13-1783752208962-AVL","reasonCode":"count_gain","adjustmentId":"BCF13-1783752208962-ADJ-3","warehouseCode":"BCF13-1783752208962-WH","countedQuantity":82,"productMasterId":"PM-BCF13-1783752208962"},"item_code":"YARN-BCF13-1783752208962","company_id":"ach-admin","created_at":"2026-07-11T06:48:29.239749+00:00","created_by":null,"updated_at":"2026-07-11T06:48:29.239749+00:00","updated_by":null,"approved_by":"admin-2","location_id":"BCF13-1783752208962-AVL","reason_code":"count_gain","external_ref":null,"movement_ref":"BCF13-ADJ-MOV-BCF13-1783752208962-ADJ-3","warehouse_id":null,"adjustment_no":"BCF13-1783752208962-ADJ-3","adjustment_qty":32,"approval_status":"APPROVED","idempotency_key":null},"created_at":"2026-07-11T06:48:29.242Z","product_key":null,"product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"BATCH-BCF13-1783752208962","orderId":"","listingId":"","productKey":null,"productName":null},"batch_id":"BATCH-BCF13-1783752208962","production_order_id":null,"flow_stage":"ADJUSTMENT_GAIN","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-BCF13-1783752208962","source_document_id":"BCF13-1783752208962-ADJ-3","source_document_type":"ADJUSTMENT","bin_code":"BCF13-1783752208962-AVL","lot_no":"LOT-BCF13-1783752208962","serial_no":"","item_code":"YARN-BCF13-1783752208962","uom":"kg","stock_status":"AVAILABLE","location_id":"BCF13-1783752208962-AVL"},{"id":"74","movement_ref":"BCF13-TRF-RCV-BCF13-1783752208962-TRF-1","transfer_id":"BCF13-1783752208962-TRF-1","movement_type":"TRANSFER_RECEIPT_PUTAWAY","module_key":"yarn","sector":"textile","listing_id":"","order_id":"","reservation_id":"","warehouse_code":"BCF13-1783752208962-WH","counterparty_warehouse_code":"BCF13-1783752208962-WH","qty_delta":"10","qty_balance":null,"status":"POSTED","source_table":"erp_warehouse_transfers","payload_json":{"id":1,"uom":"kg","sector":"textile","status":"CLOSED","order_id":"","seller_id":"","company_id":"ach-admin","created_at":"2026-07-11T06:46:12.730101+00:00","issued_qty":10,"listing_id":"","module_key":"yarn","request_id":"BCF13-1783752208962-TRF-1","updated_at":"2026-07-11T06:46:12.730101+00:00","approved_at":"2026-07-11T06:46:12.730101+00:00","approved_by":"admin-2","approver_id":"admin-2","product_key":"YARN-BCF13-1783752208962","rejected_at":null,"rejected_by":null,"transfer_id":"BCF13-1783752208962-TRF-1","payload_json":{"uom":"kg","lotNo":"LOT-BCF13-1783752208962","batchNo":"BATCH-BCF13-1783752208962","itemCode":"YARN-BCF13-1783752208962","quantity":10,"transferId":"BCF13-1783752208962-TRF-1","idempotencyKey":"BCF13-1783752208962-TRF-1","productMasterId":"PM-BCF13-1783752208962","sourceLocationId":"BCF13-1783752208962-AVL","sourceWarehouseId":"BCF13-1783752208962-WH","destinationLocationId":"BCF13-1783752208962-DSP","destinationWarehouseId":"BCF13-1783752208962-WH"},"product_name":"","received_qty":10,"requested_by":"admin-1","requester_id":"admin-1","reject_reason":null,"requested_qty":10,"reservation_id":null,"idempotency_key":"BCF13-1783752208962-TRF-1","module_tag_json":{},"product_tag_json":{},"to_warehouse_code":"BCF13-1783752208962-WH","source_location_id":"BCF13-1783752208962-AVL","from_warehouse_code":"BCF13-1783752208962-WH","destination_location_id":"BCF13-1783752208962-DSP"},"created_at":"2026-07-11T06:46:12.735Z","product_key":null,"product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"BATCH-BCF13-1783752208962","orderId":"","listingId":"","productKey":null,"productName":null},"batch_id":"BATCH-BCF13-1783752208962","production_order_id":null,"flow_stage":"TRANSFER_RECEIPT_PUTAWAY","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-BCF13-1783752208962","source_document_id":"BCF13-1783752208962-TRF-1","source_document_type":"TRANSFER","bin_code":"BCF13-1783752208962-DSP","lot_no":"LOT-BCF13-1783752208962","serial_no":"","item_code":"YARN-BCF13-1783752208962","uom":"kg","stock_status":"AVAILABLE","location_id":"BCF13-1783752208962-DSP"},{"id":"73","movement_ref":"BCF13-TRF-ISS-BCF13-1783752208962-TRF-1","transfer_id":"BCF13-1783752208962-TRF-1","movement_type":"TRANSFER_ISSUE","module_key":"yarn","sector":"textile","listing_id":"","order_id":"","reservation_id":"","warehouse_code":"BCF13-1783752208962-WH","counterparty_warehouse_code":"BCF13-1783752208962-WH","qty_delta":"-10","qty_balance":null,"status":"POSTED","source_table":"erp_warehouse_transfers","payload_json":{"id":1,"uom":"kg","sector":"textile","status":"CLOSED","order_id":"","seller_id":"","company_id":"ach-admin","created_at":"2026-07-11T06:46:12.730101+00:00","issued_qty":10,"listing_id":"","module_key":"yarn","request_id":"BCF13-1783752208962-TRF-1","updated_at":"2026-07-11T06:46:12.730101+00:00","approved_at":"2026-07-11T06:46:12.730101+00:00","approved_by":"admin-2","approver_id":"admin-2","product_key":"YARN-BCF13-1783752208962","rejected_at":null,"rejected_by":null,"transfer_id":"BCF13-1783752208962-TRF-1","payload_json":{"uom":"kg","lotNo":"LOT-BCF13-1783752208962","batchNo":"BATCH-BCF13-1783752208962","itemCode":"YARN-BCF13-1783752208962","quantity":10,"transferId":"BCF13-1783752208962-TRF-1","idempotencyKey":"BCF13-1783752208962-TRF-1","productMasterId":"PM-BCF13-1783752208962","sourceLocationId":"BCF13-1783752208962-AVL","sourceWarehouseId":"BCF13-1783752208962-WH","destinationLocationId":"BCF13-1783752208962-DSP","destinationWarehouseId":"BCF13-1783752208962-WH"},"product_name":"","received_qty":10,"requested_by":"admin-1","requester_id":"admin-1","reject_reason":null,"requested_qty":10,"reservation_id":null,"idempotency_key":"BCF13-1783752208962-TRF-1","module_tag_json":{},"product_tag_json":{},"to_warehouse_code":"BCF13-1783752208962-WH","source_location_id":"BCF13-1783752208962-AVL","from_warehouse_code":"BCF13-1783752208962-WH","destination_location_id":"BCF13-1783752208962-DSP"},"created_at":"2026-07-11T06:46:12.733Z","product_key":null,"product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"BATCH-BCF13-1783752208962","orderId":"","listingId":"","productKey":null,"productName":null},"batch_id":"BATCH-BCF13-1783752208962","production_order_id":null,"flow_stage":"TRANSFER_ISSUE","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-BCF13-1783752208962","source_document_id":"BCF13-1783752208962-TRF-1","source_document_type":"TRANSFER","bin_code":"BCF13-1783752208962-AVL","lot_no":"LOT-BCF13-1783752208962","serial_no":"","item_code":"YARN-BCF13-1783752208962","uom":"kg","stock_status":"IN_TRANSIT","location_id":"BCF13-1783752208962-AVL"},{"id":"72","movement_ref":"BCF13-GRN-REJ-BCF13-1783752208962-GRN-VAR","transfer_id":"","movement_type":"GOODS_RECEIPT_REJECTED","module_key":"yarn","sector":"textile","listing_id":"","order_id":"","reservation_id":"","warehouse_code":"BCF13-1783752208962-WH","counterparty_warehouse_code":"","qty_delta":"5","qty_balance":null,"status":"POSTED","source_table":"erp_goods_receipt_lines","payload_json":{"uom":"kg","grn_id":"BCF13-1783752208962-GRN-VAR","lot_no":"LOT-V-BCF13-1783752208962","line_id":"BCF13-1783752208962-GRN-VAR-1","batch_no":"BATCH-V-BCF13-1783752208962","item_code":"YARN-BCF13-1783752208962","serial_no":"","company_id":"ach-admin","created_at":"2026-07-11T06:43:35.508478+00:00","excess_qty":0,"listing_id":"","module_key":"yarn","receipt_id":"BCF13-1783752208962-GRN-VAR","updated_at":"2026-07-11T06:43:35.508478+00:00","approver_id":null,"damaged_qty":0,"expiry_date":null,"ordered_qty":50,"supplier_id":"supplier-bcf13","accepted_qty":40,"payload_json":{"uom":"kg","grnId":"BCF13-1783752208962-GRN-VAR","lotNo":"LOT-V-BCF13-1783752208962","batchNo":"BATCH-V-BCF13-1783752208962","itemCode":"YARN-BCF13-1783752208962","warehouseCode":"BCF13-1783752208962-WH","varianceReason":"shortage and rejection","orderedQuantity":50,"productMasterId":"PM-BCF13-1783752208962","purchaseOrderId":"BCF13-1783752208962-PO-VAR","acceptedQuantity":40,"receivedQuantity":45,"rejectedQuantity":5,"receivingLocationId":"BCF13-1783752208962-RCV"},"received_qty":45,"rejected_qty":5,"requester_id":"admin-1","shortage_qty":5,"warehouse_id":"BCF13-1783752208962-WH","posting_status":"RECEIVED","quality_status":"VARIANCE_REVIEW","variance_reason":"shortage and rejection","variance_status":"PENDING_APPROVAL","manufacture_date":null,"product_master_id":"PM-BCF13-1783752208962","purchase_order_id":"BCF13-1783752208962-PO-VAR","receiving_location_id":"BCF13-1783752208962-RCV"},"created_at":"2026-07-11T06:43:35.512Z","product_key":null,"product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"BATCH-V-BCF13-1783752208962","orderId":"","listingId":"","productKey":null,"productName":null},"batch_id":"BATCH-V-BCF13-1783752208962","production_order_id":null,"flow_stage":"GOODS_RECEIPT_REJECTED","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-BCF13-1783752208962","source_document_id":"BCF13-1783752208962-GRN-VAR","source_document_type":"GRN","bin_code":"BCF13-1783752208962-RCV","lot_no":"LOT-V-BCF13-1783752208962","serial_no":"","item_code":"YARN-BCF13-1783752208962","uom":"kg","stock_status":"REJECTED","location_id":"BCF13-1783752208962-RCV"},{"id":"71","movement_ref":"BCF13-GRN-ACC-BCF13-1783752208962-GRN-VAR","transfer_id":"","movement_type":"GOODS_RECEIPT_ACCEPTED","module_key":"yarn","sector":"textile","listing_id":"","order_id":"","reservation_id":"","warehouse_code":"BCF13-1783752208962-WH","counterparty_warehouse_code":"","qty_delta":"40","qty_balance":null,"status":"POSTED","source_table":"erp_goods_receipt_lines","payload_json":{"uom":"kg","grn_id":"BCF13-1783752208962-GRN-VAR","lot_no":"LOT-V-BCF13-1783752208962","line_id":"BCF13-1783752208962-GRN-VAR-1","batch_no":"BATCH-V-BCF13-1783752208962","item_code":"YARN-BCF13-1783752208962","serial_no":"","company_id":"ach-admin","created_at":"2026-07-11T06:43:35.508478+00:00","excess_qty":0,"listing_id":"","module_key":"yarn","receipt_id":"BCF13-1783752208962-GRN-VAR","updated_at":"2026-07-11T06:43:35.508478+00:00","approver_id":null,"damaged_qty":0,"expiry_date":null,"ordered_qty":50,"supplier_id":"supplier-bcf13","accepted_qty":40,"payload_json":{"uom":"kg","grnId":"BCF13-1783752208962-GRN-VAR","lotNo":"LOT-V-BCF13-1783752208962","batchNo":"BATCH-V-BCF13-1783752208962","itemCode":"YARN-BCF13-1783752208962","warehouseCode":"BCF13-1783752208962-WH","varianceReason":"shortage and rejection","orderedQuantity":50,"productMasterId":"PM-BCF13-1783752208962","purchaseOrderId":"BCF13-1783752208962-PO-VAR","acceptedQuantity":40,"receivedQuantity":45,"rejectedQuantity":5,"receivingLocationId":"BCF13-1783752208962-RCV"},"received_qty":45,"rejected_qty":5,"requester_id":"admin-1","shortage_qty":5,"warehouse_id":"BCF13-1783752208962-WH","posting_status":"RECEIVED","quality_status":"VARIANCE_REVIEW","variance_reason":"shortage and rejection","variance_status":"PENDING_APPROVAL","manufacture_date":null,"product_master_id":"PM-BCF13-1783752208962","purchase_order_id":"BCF13-1783752208962-PO-VAR","receiving_location_id":"BCF13-1783752208962-RCV"},"created_at":"2026-07-11T06:43:35.510Z","product_key":null,"product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"BATCH-V-BCF13-1783752208962","orderId":"","listingId":"","productKey":null,"productName":null},"batch_id":"BATCH-V-BCF13-1783752208962","production_order_id":null,"flow_stage":"GOODS_RECEIPT_ACCEPTED","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-BCF13-1783752208962","source_document_id":"BCF13-1783752208962-GRN-VAR","source_document_type":"GRN","bin_code":"BCF13-1783752208962-RCV","lot_no":"LOT-V-BCF13-1783752208962","serial_no":"","item_code":"YARN-BCF13-1783752208962","uom":"kg","stock_status":"RECEIVING","location_id":"BCF13-1783752208962-RCV"},{"id":"70","movement_ref":"BCF13-PUT-DST-BCF13-1783752208962-PUT-P2","transfer_id":"","movement_type":"PUTAWAY_TO_AVAILABLE","module_key":"yarn","sector":"textile","listing_id":"","order_id":"","reservation_id":"","warehouse_code":"BCF13-1783752208962-WH","counterparty_warehouse_code":"","qty_delta":"60","qty_balance":null,"status":"POSTED","source_table":"erp_putaway_tasks","payload_json":{"uom":"kg","grn_id":"BCF13-1783752208962-GRN-P2","lot_no":"LOT-P-BCF13-1783752208962","status":"PUTAWAY_POSTED","line_id":"BCF13-1783752208962-GRN-P2-1","batch_no":"BATCH-P-BCF13-1783752208962","quantity":60,"item_code":"YARN-BCF13-1783752208962","company_id":"ach-admin","created_at":"2026-07-11T06:43:35.293567+00:00","created_by":"admin-1","listing_id":"","putaway_id":"BCF13-1783752208962-PUT-P2","payload_json":{"grnId":"BCF13-1783752208962-GRN-P2","quantity":60,"putawayId":"BCF13-1783752208962-PUT-P2","idempotencyKey":"BCF13-1783752208962-PUT-P2","destinationLocationId":"BCF13-1783752208962-AVL"},"stock_status":"AVAILABLE","warehouse_id":"BCF13-1783752208962-WH","idempotency_key":"BCF13-1783752208962-PUT-P2","product_master_id":"PM-BCF13-1783752208962","source_location_id":"BCF13-1783752208962-RCV","destination_location_id":"BCF13-1783752208962-AVL"},"created_at":"2026-07-11T06:43:35.297Z","product_key":null,"product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"BATCH-P-BCF13-1783752208962","orderId":"","listingId":"","productKey":null,"productName":null},"batch_id":"BATCH-P-BCF13-1783752208962","production_order_id":null,"flow_stage":"PUTAWAY_TO_AVAILABLE","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-BCF13-1783752208962","source_document_id":"BCF13-1783752208962-PUT-P2","source_document_type":"PUTAWAY","bin_code":"BCF13-1783752208962-AVL","lot_no":"LOT-P-BCF13-1783752208962","serial_no":"","item_code":"YARN-BCF13-1783752208962","uom":"kg","stock_status":"AVAILABLE","location_id":"BCF13-1783752208962-AVL"},{"id":"69","movement_ref":"BCF13-PUT-SRC-BCF13-1783752208962-PUT-P2","transfer_id":"","movement_type":"PUTAWAY_FROM_RECEIVING","module_key":"yarn","sector":"textile","listing_id":"","order_id":"","reservation_id":"","warehouse_code":"BCF13-1783752208962-WH","counterparty_warehouse_code":"","qty_delta":"-60","qty_balance":null,"status":"POSTED","source_table":"erp_putaway_tasks","payload_json":{"uom":"kg","grn_id":"BCF13-1783752208962-GRN-P2","lot_no":"LOT-P-BCF13-1783752208962","status":"PUTAWAY_POSTED","line_id":"BCF13-1783752208962-GRN-P2-1","batch_no":"BATCH-P-BCF13-1783752208962","quantity":60,"item_code":"YARN-BCF13-1783752208962","company_id":"ach-admin","created_at":"2026-07-11T06:43:35.293567+00:00","created_by":"admin-1","listing_id":"","putaway_id":"BCF13-1783752208962-PUT-P2","payload_json":{"grnId":"BCF13-1783752208962-GRN-P2","quantity":60,"putawayId":"BCF13-1783752208962-PUT-P2","idempotencyKey":"BCF13-1783752208962-PUT-P2","destinationLocationId":"BCF13-1783752208962-AVL"},"stock_status":"AVAILABLE","warehouse_id":"BCF13-1783752208962-WH","idempotency_key":"BCF13-1783752208962-PUT-P2","product_master_id":"PM-BCF13-1783752208962","source_location_id":"BCF13-1783752208962-RCV","destination_location_id":"BCF13-1783752208962-AVL"},"created_at":"2026-07-11T06:43:35.295Z","product_key":null,"product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"BATCH-P-BCF13-1783752208962","orderId":"","listingId":"","productKey":null,"productName":null},"batch_id":"BATCH-P-BCF13-1783752208962","production_order_id":null,"flow_stage":"PUTAWAY_FROM_RECEIVING","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-BCF13-1783752208962","source_document_id":"BCF13-1783752208962-PUT-P2","source_document_type":"PUTAWAY","bin_code":"BCF13-1783752208962-RCV","lot_no":"LOT-P-BCF13-1783752208962","serial_no":"","item_code":"YARN-BCF13-1783752208962","uom":"kg","stock_status":"RECEIVING","location_id":"BCF13-1783752208962-RCV"},{"id":"68","movement_ref":"BCF13-PUT-DST-BCF13-1783752208962-PUT-P1","transfer_id":"","movement_type":"PUTAWAY_TO_AVAILABLE","module_key":"yarn","sector":"textile","listing_id":"","order_id":"","reservation_id":"","warehouse_code":"BCF13-1783752208962-WH","counterparty_warehouse_code":"","qty_delta":"40","qty_balance":null,"status":"POSTED","source_table":"erp_putaway_tasks","payload_json":{"uom":"kg","grn_id":"BCF13-1783752208962-GRN-P1","lot_no":"LOT-P-BCF13-1783752208962","status":"PUTAWAY_POSTED","line_id":"BCF13-1783752208962-GRN-P1-1","batch_no":"BATCH-P-BCF13-1783752208962","quantity":40,"item_code":"YARN-BCF13-1783752208962","company_id":"ach-admin","created_at":"2026-07-11T06:43:35.080518+00:00","created_by":"admin-1","listing_id":"","putaway_id":"BCF13-1783752208962-PUT-P1","payload_json":{"grnId":"BCF13-1783752208962-GRN-P1","quantity":40,"putawayId":"BCF13-1783752208962-PUT-P1","idempotencyKey":"BCF13-1783752208962-PUT-P1","destinationLocationId":"BCF13-1783752208962-AVL"},"stock_status":"AVAILABLE","warehouse_id":"BCF13-1783752208962-WH","idempotency_key":"BCF13-1783752208962-PUT-P1","product_master_id":"PM-BCF13-1783752208962","source_location_id":"BCF13-1783752208962-RCV","destination_location_id":"BCF13-1783752208962-AVL"},"created_at":"2026-07-11T06:43:35.084Z","product_key":null,"product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"BATCH-P-BCF13-1783752208962","orderId":"","listingId":"","productKey":null,"productName":null},"batch_id":"BATCH-P-BCF13-1783752208962","production_order_id":null,"flow_stage":"PUTAWAY_TO_AVAILABLE","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-BCF13-1783752208962","source_document_id":"BCF13-1783752208962-PUT-P1","source_document_type":"PUTAWAY","bin_code":"BCF13-1783752208962-AVL","lot_no":"LOT-P-BCF13-1783752208962","serial_no":"","item_code":"YARN-BCF13-1783752208962","uom":"kg","stock_status":"AVAILABLE","location_id":"BCF13-1783752208962-AVL"},{"id":"67","movement_ref":"BCF13-PUT-SRC-BCF13-1783752208962-PUT-P1","transfer_id":"","movement_type":"PUTAWAY_FROM_RECEIVING","module_key":"yarn","sector":"textile","listing_id":"","order_id":"","reservation_id":"","warehouse_code":"BCF13-1783752208962-WH","counterparty_warehouse_code":"","qty_delta":"-40","qty_balance":null,"status":"POSTED","source_table":"erp_putaway_tasks","payload_json":{"uom":"kg","grn_id":"BCF13-1783752208962-GRN-P1","lot_no":"LOT-P-BCF13-1783752208962","status":"PUTAWAY_POSTED","line_id":"BCF13-1783752208962-GRN-P1-1","batch_no":"BATCH-P-BCF13-1783752208962","quantity":40,"item_code":"YARN-BCF13-1783752208962","company_id":"ach-admin","created_at":"2026-07-11T06:43:35.080518+00:00","created_by":"admin-1","listing_id":"","putaway_id":"BCF13-1783752208962-PUT-P1","payload_json":{"grnId":"BCF13-1783752208962-GRN-P1","quantity":40,"putawayId":"BCF13-1783752208962-PUT-P1","idempotencyKey":"BCF13-1783752208962-PUT-P1","destinationLocationId":"BCF13-1783752208962-AVL"},"stock_status":"AVAILABLE","warehouse_id":"BCF13-1783752208962-WH","idempotency_key":"BCF13-1783752208962-PUT-P1","product_master_id":"PM-BCF13-1783752208962","source_location_id":"BCF13-1783752208962-RCV","destination_location_id":"BCF13-1783752208962-AVL"},"created_at":"2026-07-11T06:43:35.082Z","product_key":null,"product_name":null,"module_tag_json":{"engine":"transformation","sector":"textile","registry":"TEXTILE_MODULES_22","moduleKey":"yarn"},"product_tag_json":{"batchId":"BATCH-P-BCF13-1783752208962","orderId":"","listingId":"","productKey":null,"productName":null},"batch_id":"BATCH-P-BCF13-1783752208962","production_order_id":null,"flow_stage":"PUTAWAY_FROM_RECEIVING","company_id":"ach-admin","branch_id":"main","product_master_id":"PM-BCF13-1783752208962","source_document_id":"BCF13-1783752208962-PUT-P1","source_document_type":"PUTAWAY","bin_code":"BCF13-1783752208962-RCV","lot_no":"LOT-P-BCF13-1783752208962","serial_no":"","item_code":"YARN-BCF13-1783752208962","uom":"kg","stock_status":"RECEIVING","location_id":"BCF13-1783752208962-RCV"}],"error":null},{"table":"trade_inventory_snapshots","status":"READY","exists":true,"rowCount":1,"sampledRows":1,"columnsPresent":30,"columns":["id","listing_id","module_key","seller_id","stock_truth","quantity_json","warehouse_json","readiness_json","source_event","status","created_at","updated_at","order_id","qty_before","qty_reserved","qty_after","warehouse_code","rack_code","dispatch_zone","readiness_state","lot_no","batch_id","lineage_json","anomaly_json","last_recompute_at","item_code","sku_code","uom_code","reorder_level","stock_aging_started_at"],"sample":[{"id":"1","listing_id":"step29-listing-1777991056","module_key":"yarn","seller_id":"step29-seller","stock_truth":"trade_inventory_snapshots.qty_after","quantity_json":{"unit":"kg","numeric":{"qtyAfter":1,"qtyBefore":1,"qtyReserved":0,"requestedQty":null},"qtyAfter":1,"qtyBefore":1,"qtyReserved":0,"requestedQty":null,"requestedQtyNumeric":null},"warehouse_json":{"mode":"listing-metadata-only","source":"trade_listings.fields_json","rackCode":"ERP-RACK-PENDING","canonical":true,"rack_code":"ERP-RACK-PENDING","warehouses":[],"dispatchZone":"ERP-DISPATCH-PENDING","dispatch_zone":"ERP-DISPATCH-PENDING","warehouseCode":"ERP-WH-PENDING","pickupLocation":"","readinessState":"WAREHOUSE_PLACEHOLDER","warehouse_code":"ERP-WH-PENDING","readiness_state":"WAREHOUSE_PLACEHOLDER","dispatchLocation":"","logisticsPlaceholder":true},"readiness_json":{"moq":"","note":"Published listing stock bridged into canonical operational stock so order/create validates and reserves against trade_inventory_snapshots.qty_after.","unit":"kg","status":"READY","numeric":{"moq":null,"requestedQty":null,"totalQuantity":1,"readyDispatchQty":null,"availableQuantity":1},"version":"trade-core-operational-stock-bridge-v1","blockers":[],"sellerId":"step29-seller","warnings":[],"canonical":true,"listingId":"step29-listing-1777991056","moduleKey":"yarn","orderTruth":"trade_orders.payload_json","stockTruth":"trade_inventory_snapshots.qty_after","previewOnly":true,"nonEnforcing":true,"requestedQty":null,"totalQuantity":"1","inventoryTable":null,"mutationEngine":"none","listingStockRole":"trade_listings.fields_json.seller_declared_stock","readyDispatchQty":"","availableQuantity":"1","bridgeSourceEvent":"LISTING_OPERATIONAL_STOCK_BRIDGE","warehouseSnapshot":{"mode":"listing-metadata-only","source":"trade_listings.fields_json","rackCode":"ERP-RACK-PENDING","canonical":true,"rack_code":"ERP-RACK-PENDING","warehouses":[],"dispatchZone":"ERP-DISPATCH-PENDING","dispatch_zone":"ERP-DISPATCH-PENDING","warehouseCode":"ERP-WH-PENDING","pickupLocation":"","readinessState":"WAREHOUSE_PLACEHOLDER","warehouse_code":"ERP-WH-PENDING","readiness_state":"WAREHOUSE_PLACEHOLDER","dispatchLocation":"","logisticsPlaceholder":true},"originalSourceEvent":"LISTING_SAVE"},"source_event":"LISTING_OPERATIONAL_STOCK_BRIDGE","status":"AVAILABLE","created_at":"2026-06-11T18:11:02.433Z","updated_at":"2026-06-11T18:11:02.433Z","order_id":null,"qty_before":"1","qty_reserved":"0","qty_after":"1","warehouse_code":"ERP-WH-PENDING","rack_code":"ERP-RACK-PENDING","dispatch_zone":"ERP-DISPATCH-PENDING","readiness_state":"WAREHOUSE_PLACEHOLDER","lot_no":null,"batch_id":null,"lineage_json":{"chain":[{"id":"step29-listing-1777991056","step":"listing","table":"trade_listings"},{"id":null,"step":"order","table":"trade_orders"},{"id":null,"step":"reservation","table":"trade_inventory_reservations"},{"id":null,"step":"movement","table":"erp_inventory_movement_ledger"}],"lotNo":null,"engine":"transformation","sector":"textile","batchId":null,"orderId":null,"version":"trade-core-erp-operational-inventory-execution-v1","canonical":true,"listingId":"step29-listing-1777991056","moduleKey":"yarn","updatedAt":"2026-06-11T18:11:02.436Z","sourceEvent":"LISTING_OPERATIONAL_STOCK_BRIDGE","lineageStatus":"UNASSIGNED","reservationId":null,"engineSeparationRule":"textile uses transformation; electronics uses assembly; agriculture/natural resources use extraction"},"anomaly_json":{},"last_recompute_at":null,"item_code":"STEP29-LISTING-1777991056","sku_code":"STEP29-LISTING-1777991056","uom_code":"KG","reorder_level":null,"stock_aging_started_at":"2026-06-11T18:11:02.433Z"}],"error":null}],"executionSurface":{"movementLedgerReady":true,"stockLedgerReadbackReady":false,"reservationReadbackReady":false,"warehouseTransferReadbackReady":false,"stockAdjustmentReadbackReady":false,"batchLotTrackingReady":false,"valuationReadinessReady":false,"countReadinessReady":false,"mutationTriggeredByThisRoute":false},"routeOwnership":{"backendServerJsOwner":true,"patchedFile":"backend/server.js","routeFilesTouched":false,"frontendTouched":false,"duplicateRouteFilesCreated":false,"duplicateRoutesCreatedByRuntimeGuard":false},"safety":{"readOnlySelectOnly":true,"noDbSchemaChange":true,"noDbMutation":true,"noInventoryMutation":true,"noWarehouseMutation":true,"noMoneyMovement":true,"noAutomation":true,"schedulerEnabled":false,"frontendTouched":false,"routeFilesTouched":false},"smoke":{"acceptedStatuses":[200,403],"rejectedStatuses":[404,500],"health":"/health","tradeCoreHealth":"/api/trade-core/health","rfqHealth":"/api/rfq/health","base643Readiness":"/api/trade-core/erp/inventory-warehouse/execution-chain/readiness","routes":["/api/trade-core/erp/inventory-warehouse/execution-chain/movement-ledger","/api/trade-core/erp/inventory-warehouse/execution-chain/stock-ledger/readback","/api/trade-core/erp/inventory-warehouse/execution-chain/reservation/readback","/api/trade-core/erp/inventory-warehouse/execution-chain/warehouse-transfer/readback","/api/trade-core/erp/inventory-warehouse/execution-chain/stock-adjustment/readback","/api/trade-core/erp/inventory-warehouse/execution-chain/batch-lot/readiness","/api/trade-core/erp/inventory-warehouse/execution-chain/valuation/readiness","/api/trade-core/erp/inventory-warehouse/execution-chain/cycle-count/readiness","/api/trade-core/erp/inventory-warehouse/execution-chain/physical-count/readiness","/api/trade-core/erp/inventory/movement-ledger","/api/trade-core/erp/inventory/stock-ledger/readback","/api/trade-core/erp/inventory/reservation-readback","/api/trade-core/erp/warehouse-transfer/list","/api/trade-core/erp/inventory/stock-adjustment/readback","/api/trade-core/erp/inventory/batch-lot-movement/readback","/api/trade-core/erp/inventory/valuation/readback","/api/trade-core/erp/inventory/cycle-count/readback","/api/trade-core/erp/inventory/physical-count/readback"]}}