{"ok":true,"success":true,"canonical":true,"marker":"CODEX741_ERP_EXECUTION_COMPLETION","version":"codex741-erp-execution-completion-v1","routeOwner":"backend/server.js","frontendRoot":"frontend/app","forbiddenFrontendRoot":"frontend/src/app","tradeCoreJs":"NOT_RECREATED_NOT_TOUCHED","route":"/api/trade-core/erp/inventory-execution/batch-lot-serial","key":"batch_lot_serial","label":"Batch lot serial execution","implementedBy":"CODEX715 overlay completion","status":"ERP_EXECUTION_BATCH_LOT_SERIAL_FILE_BACKED_READBACK_READY","readOnly":true,"selectOnly":true,"noDbSchemaChange":true,"noDbMutation":true,"noInventoryMutation":true,"noAccountingPostingMutation":true,"noWorkflowMutation":true,"noPermissionMutation":true,"noReportingExportMutation":true,"noMoneyMovement":true,"noExternalApiCall":true,"noSchedulerEnablement":true,"noDuplicateRoutes":true,"noFakeStockLots":true,"noFakeSerialNumbers":true,"noFakeStockQuantity":true,"noAccountingPostingExecution":true,"sourceTables":["trade_inventory_snapshots","erp_inventory_movement_ledger","inventoryLots","inventoryLayers"],"sourceFiles":["backend/data/warehouse.inventoryLots.json","backend/data/erp_lot_traceability.json","backend/data/mktProductLots.json","backend/data/inventoryLots.json","backend/data/inventoryLayers.json"],"linkedRoutes":["/api/trade-core/erp/inventory/lineage"],"executionEvidence":{"inventoryExecution":"existing inventory execution routes now include DB table readback","procurementExecution":"existing CODEX714 DB-backed routes preserved","manufacturingExecution":"existing CODEX713 DB-backed routes preserved","accountingPosting":"existing CODEX733 DB-backed posting connector preserved","workflowRbac":"existing workflow RBAC routes now include DB table readback","reportingLinkage":"existing reporting-center routes now include execution source linkage"},"readbackSummary":{"tableCount":9,"existingTableCount":7,"missingTableCount":2,"rowCountTotal":97,"warningCount":2,"status":"ERP_EXECUTION_READBACK_PARTIAL","warnings":[{"table":"inventoryLots","status":"MISSING","error":"not present"},{"table":"inventoryLayers","status":"MISSING","error":"not present"}]},"tableReadbacks":[{"table":"trade_inventory_snapshots","exists":true,"status":"READY","rowCount":1,"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"],"rows":[{"id":1,"lot_no":null,"status":"AVAILABLE","batch_id":null,"order_id":null,"sku_code":"STEP29-LISTING-1777991056","uom_code":"KG","item_code":"STEP29-LISTING-1777991056","qty_after":1,"rack_code":"ERP-RACK-PENDING","seller_id":"step29-seller","created_at":"2026-06-11T18:11:02.433959+00:00","listing_id":"step29-listing-1777991056","module_key":"yarn","qty_before":1,"updated_at":"2026-06-11T18:11:02.433959+00:00","stock_truth":"trade_inventory_snapshots.qty_after","anomaly_json":{},"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"},"qty_reserved":0,"source_event":"LISTING_OPERATIONAL_STOCK_BRIDGE","dispatch_zone":"ERP-DISPATCH-PENDING","quantity_json":{"unit":"kg","numeric":{"qtyAfter":1,"qtyBefore":1,"qtyReserved":0,"requestedQty":null},"qtyAfter":1,"qtyBefore":1,"qtyReserved":0,"requestedQty":null,"requestedQtyNumeric":null},"reorder_level":null,"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"},"warehouse_code":"ERP-WH-PENDING","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_state":"WAREHOUSE_PLACEHOLDER","last_recompute_at":null,"stock_aging_started_at":"2026-06-11T18:11:02.433959+00:00"}]},{"table":"erp_inventory_movement_ledger","exists":true,"status":"READY","rowCount":91,"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"],"rows":[{"id":91,"uom":"kg","lot_no":"","sector":"textile","status":"POSTED","batch_id":null,"bin_code":"SELLABLE","order_id":"","branch_id":"main","item_code":"F5-ITEM-YARN","qty_delta":10,"serial_no":"","company_id":"ach-admin","created_at":"2026-07-13T13:57:14.083089+00:00","flow_stage":"ADJUSTMENT_GAIN","listing_id":"F5-LIST-YARN","module_key":"yarn","location_id":"SELLABLE","product_key":"F5-LIST-YARN","qty_balance":null,"transfer_id":"","movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT-1783951029","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},"product_name":null,"source_table":"erp_inventory_adjustments","stock_status":"AVAILABLE","movement_type":"ADJUSTMENT_GAIN","reservation_id":"","warehouse_code":"MAIN","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},"product_master_id":"PM-yarn","source_document_id":"ADJ-F5-STOCK-COUNT-1783951029","production_order_id":null,"source_document_type":"ADJUSTMENT","counterparty_warehouse_code":""},{"id":90,"uom":"kg","lot_no":"","sector":"textile","status":"POSTED","batch_id":null,"bin_code":"SELLABLE","order_id":"","branch_id":"main","item_code":"F5-ITEM-YARN","qty_delta":10,"serial_no":"","company_id":"ach-admin","created_at":"2026-07-13T13:56:18.742476+00:00","flow_stage":"ADJUSTMENT_GAIN","listing_id":"F5-LIST-YARN","module_key":"yarn","location_id":"SELLABLE","product_key":"F5-LIST-YARN","qty_balance":null,"transfer_id":"","movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT-1783950974","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},"product_name":null,"source_table":"erp_inventory_adjustments","stock_status":"AVAILABLE","movement_type":"ADJUSTMENT_GAIN","reservation_id":"","warehouse_code":"MAIN","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},"product_master_id":"PM-yarn","source_document_id":"ADJ-F5-STOCK-COUNT-1783950974","production_order_id":null,"source_document_type":"ADJUSTMENT","counterparty_warehouse_code":""},{"id":89,"uom":"kg","lot_no":"","sector":"textile","status":"POSTED","batch_id":null,"bin_code":"SELLABLE","order_id":"","branch_id":"main","item_code":"F5-ITEM-YARN","qty_delta":10,"serial_no":"","company_id":"ach-admin","created_at":"2026-07-13T13:53:24.20769+00:00","flow_stage":"ADJUSTMENT_GAIN","listing_id":"F5-LIST-YARN","module_key":"yarn","location_id":"SELLABLE","product_key":"F5-LIST-YARN","qty_balance":null,"transfer_id":"","movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT-1783950799","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},"product_name":null,"source_table":"erp_inventory_adjustments","stock_status":"AVAILABLE","movement_type":"ADJUSTMENT_GAIN","reservation_id":"","warehouse_code":"MAIN","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},"product_master_id":"PM-yarn","source_document_id":"ADJ-F5-STOCK-COUNT-1783950799","production_order_id":null,"source_document_type":"ADJUSTMENT","counterparty_warehouse_code":""},{"id":88,"uom":"kg","lot_no":"","sector":"textile","status":"POSTED","batch_id":null,"bin_code":"SELLABLE","order_id":"","branch_id":"main","item_code":"F5-ITEM-YARN","qty_delta":10,"serial_no":"","company_id":"ach-admin","created_at":"2026-07-13T13:52:37.649917+00:00","flow_stage":"ADJUSTMENT_GAIN","listing_id":"F5-LIST-YARN","module_key":"yarn","location_id":"SELLABLE","product_key":"F5-LIST-YARN","qty_balance":null,"transfer_id":"","movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT-1783950753","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},"product_name":null,"source_table":"erp_inventory_adjustments","stock_status":"AVAILABLE","movement_type":"ADJUSTMENT_GAIN","reservation_id":"","warehouse_code":"MAIN","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},"product_master_id":"PM-yarn","source_document_id":"ADJ-F5-STOCK-COUNT-1783950753","production_order_id":null,"source_document_type":"ADJUSTMENT","counterparty_warehouse_code":""},{"id":87,"uom":"kg","lot_no":"","sector":"textile","status":"POSTED","batch_id":null,"bin_code":"SELLABLE","order_id":"","branch_id":"main","item_code":"F5-ITEM-YARN","qty_delta":100,"serial_no":"","company_id":"ach-admin","created_at":"2026-07-13T13:49:57.369674+00:00","flow_stage":"ADJUSTMENT_GAIN","listing_id":"F5-LIST-YARN","module_key":"yarn","location_id":"SELLABLE","product_key":"F5-LIST-YARN","qty_balance":null,"transfer_id":"","movement_ref":"BCF13-ADJ-MOV-ADJ-F5-STOCK-COUNT","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},"product_name":null,"source_table":"erp_inventory_adjustments","stock_status":"AVAILABLE","movement_type":"ADJUSTMENT_GAIN","reservation_id":"","warehouse_code":"MAIN","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},"product_master_id":"PM-yarn","source_document_id":"ADJ-F5-STOCK-COUNT","production_order_id":null,"source_document_type":"ADJUSTMENT","counterparty_warehouse_code":""},{"id":86,"uom":"kg","lot_no":"B13B-LOT","sector":"textile","status":"POSTED","batch_id":"B13B-BATCH","bin_code":null,"order_id":null,"branch_id":"main","item_code":"B13B-ITEM","qty_delta":9,"serial_no":null,"company_id":"ach-admin","created_at":"2026-07-11T07:06:06.324836+00:00","flow_stage":"BCF13B","listing_id":"B13B-LIST","module_key":"yarn","location_id":"B13BWH3564816-DSP","product_key":"B13B-LIST","qty_balance":null,"transfer_id":null,"movement_ref":"BCF13B-MOV-DSP-BCF13B-1783753564731","payload_json":{"run":"BCF13B-1783753564731"},"product_name":null,"source_table":"codex_bcf13b_uat","stock_status":"AVAILABLE","movement_type":"BCF13B_SEED","reservation_id":null,"warehouse_code":"B13BWH3564816","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},"product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-DSP-BCF13B-1783753564731","production_order_id":null,"source_document_type":"UAT","counterparty_warehouse_code":null},{"id":85,"uom":"kg","lot_no":"B13B-LOT","sector":"textile","status":"POSTED","batch_id":"B13B-BATCH","bin_code":null,"order_id":null,"branch_id":"main","item_code":"B13B-ITEM","qty_delta":-4,"serial_no":null,"company_id":"ach-admin","created_at":"2026-07-11T07:06:06.323391+00:00","flow_stage":"BCF13B","listing_id":"B13B-LIST","module_key":"yarn","location_id":"B13BWH3564816-AVL","product_key":"B13B-LIST","qty_balance":null,"transfer_id":null,"movement_ref":"BCF13B-MOV-IT-BCF13B-1783753564731","payload_json":{"run":"BCF13B-1783753564731"},"product_name":null,"source_table":"codex_bcf13b_uat","stock_status":"IN_TRANSIT","movement_type":"BCF13B_SEED","reservation_id":null,"warehouse_code":"B13BWH3564816","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},"product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-IT-BCF13B-1783753564731","production_order_id":null,"source_document_type":"UAT","counterparty_warehouse_code":null},{"id":84,"uom":"kg","lot_no":"B13B-LOT","sector":"textile","status":"POSTED","batch_id":"B13B-BATCH","bin_code":null,"order_id":null,"branch_id":"main","item_code":"B13B-ITEM","qty_delta":7,"serial_no":null,"company_id":"ach-admin","created_at":"2026-07-11T07:06:06.321922+00:00","flow_stage":"BCF13B","listing_id":"B13B-LIST","module_key":"yarn","location_id":"B13BWH3564816-REJ","product_key":"B13B-LIST","qty_balance":null,"transfer_id":null,"movement_ref":"BCF13B-MOV-REJ-BCF13B-1783753564731","payload_json":{"run":"BCF13B-1783753564731"},"product_name":null,"source_table":"codex_bcf13b_uat","stock_status":"REJECTED","movement_type":"BCF13B_SEED","reservation_id":null,"warehouse_code":"B13BWH3564816","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},"product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-REJ-BCF13B-1783753564731","production_order_id":null,"source_document_type":"UAT","counterparty_warehouse_code":null},{"id":83,"uom":"kg","lot_no":"B13B-LOT","sector":"textile","status":"POSTED","batch_id":"B13B-BATCH","bin_code":null,"order_id":null,"branch_id":"main","item_code":"B13B-ITEM","qty_delta":12,"serial_no":null,"company_id":"ach-admin","created_at":"2026-07-11T07:06:06.32037+00:00","flow_stage":"BCF13B","listing_id":"B13B-LIST","module_key":"yarn","location_id":"B13BWH3564816-QUA","product_key":"B13B-LIST","qty_balance":null,"transfer_id":null,"movement_ref":"BCF13B-MOV-Q-BCF13B-1783753564731","payload_json":{"run":"BCF13B-1783753564731"},"product_name":null,"source_table":"codex_bcf13b_uat","stock_status":"QUARANTINE","movement_type":"BCF13B_SEED","reservation_id":null,"warehouse_code":"B13BWH3564816","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},"product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-Q-BCF13B-1783753564731","production_order_id":null,"source_document_type":"UAT","counterparty_warehouse_code":null},{"id":82,"uom":"kg","lot_no":"B13B-LOT","sector":"textile","status":"POSTED","batch_id":"B13B-BATCH","bin_code":null,"order_id":null,"branch_id":"main","item_code":"B13B-ITEM","qty_delta":100,"serial_no":null,"company_id":"ach-admin","created_at":"2026-07-11T07:06:06.318352+00:00","flow_stage":"BCF13B","listing_id":"B13B-LIST","module_key":"yarn","location_id":"B13BWH3564816-AVL","product_key":"B13B-LIST","qty_balance":null,"transfer_id":null,"movement_ref":"BCF13B-MOV-AVL-BCF13B-1783753564731","payload_json":{"run":"BCF13B-1783753564731"},"product_name":null,"source_table":"codex_bcf13b_uat","stock_status":"AVAILABLE","movement_type":"BCF13B_SEED","reservation_id":null,"warehouse_code":"B13BWH3564816","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},"product_master_id":"B13B-PROD","source_document_id":"BCF13B-MOV-AVL-BCF13B-1783753564731","production_order_id":null,"source_document_type":"UAT","counterparty_warehouse_code":null}]},{"table":"inventoryLots","exists":false,"status":"MISSING","rowCount":0,"columns":[],"rows":[]},{"table":"inventoryLayers","exists":false,"status":"MISSING","rowCount":0,"columns":[],"rows":[]}],"fileReadbacks":[{"file":"backend/data/warehouse.inventoryLots.json","exists":true,"status":"READY","rowCount":2,"rows":[{"id":"LOT_YARN_001","module":"yarn","sku":"40S-COMBED-COTTON","lotNo":"Y40C-001","warehouse":"MAIN","location":"A-01-01","qtyTotal":5000,"qtyReserved":0,"qtyBlocked":0,"qtyAvailable":5000,"uom":"kg","sellerId":"SELLER_001","status":"available","createdAt":"2026-03-18T13:47:18.286Z","updatedAt":"2026-03-18T13:47:18.286Z","currency":"INR","price":100,"quantity":10,"amount":1000,"orderAmount":1000,"totalAmount":1000,"amountStatus":"calculated_test_amount"},{"id":"LOT_GREY_001","module":"grey","sku":"GREY-58-60","lotNo":"G5860-001","warehouse":"MAIN","location":"B-02-05","qtyTotal":12000,"qtyReserved":0,"qtyBlocked":0,"qtyAvailable":12000,"uom":"mtr","sellerId":"SELLER_002","status":"available","createdAt":"2026-03-18T13:47:18.286Z","updatedAt":"2026-03-18T13:47:18.286Z"}]},{"file":"backend/data/erp_lot_traceability.json","exists":true,"status":"READY","rowCount":1,"rows":[{"id":"trc_1773924956591_26368","lotNo":"LOT-RP-001","fgItem":"cotton polo t-shirt","sourceChain":[{"stage":"fiber","ref":"cotton fiber fresh"},{"stage":"yarn","ref":"cotton yarn 30s"},{"stage":"fabric","ref":"knitted dyed fabric"},{"stage":"ready-products","ref":"cotton polo t-shirt"}],"qcStatus":"PASS","dispatchLinked":"DSP-1001","createdAt":"2026-03-19T12:55:56.591Z","currency":"INR","price":100,"quantity":10,"amount":1000,"orderAmount":1000,"totalAmount":1000,"amountStatus":"calculated_test_amount"}]},{"file":"backend/data/mktProductLots.json","exists":true,"status":"READY","rowCount":0,"rows":[]},{"file":"backend/data/inventoryLots.json","exists":true,"status":"READY","rowCount":2,"rows":[{"id":"seed_1773639824075_343","sellerId":"store-001","product":"Reactive Dyes","qty":20,"availableQty":20,"heldQty":0,"warehouse":"RM-CHEM","uom":"kg","lotNo":"SEED-REACTIVE-DYES","moduleKey":"raw","createdAt":"2026-03-16T05:43:44.075Z","updatedAt":"2026-03-16T05:43:44.075Z"},{"id":"seed_1773639824075_2589","sellerId":"store-001","product":"Grey Fabric 60x60","qty":500,"availableQty":500,"heldQty":0,"warehouse":"RM-GREY","uom":"mtr","lotNo":"SEED-GREY-FABRIC-60X60","moduleKey":"raw","createdAt":"2026-03-16T05:43:44.075Z","updatedAt":"2026-03-16T05:43:44.075Z"}]},{"file":"backend/data/inventoryLayers.json","exists":true,"status":"READY","rowCount":0,"rows":[]}],"batch2Readiness":{"scope":["Lot","Batch","Serial","Expiry","FIFO","LIFO","Traceability"],"workflow":[{"step":"Stock Receipt","state":"Receipt and stock readback available","rowCount":92,"routes":["/api/trade-core/erp/warehouse-logistics/grn","/api/trade-core/erp/inventory-execution/stock-ledger"]},{"step":"Lot / Batch / Serial","state":"Lot and batch readback available; serial waiting for business execution","rowCount":5,"routes":["/api/trade-core/erp/inventory-execution/batch-lot-serial","/api/trade-core/erp/warehouse-logistics/serial-tracking"]},{"step":"Expiry / Shelf Life","state":"Waiting for business execution","rowCount":0,"routes":["/api/trade-core/erp/warehouse-logistics/fefo-fifo"]},{"step":"FIFO / LIFO Picking","state":"Layer selection readback available","rowCount":92,"routes":["/api/trade-core/erp/warehouse-logistics/fefo-fifo","/api/trade-core/erp/inventory/lineage"]},{"step":"Traceability","state":"Traceability readback available","rowCount":92,"routes":["/api/trade-core/erp/inventory/lineage","/api/trade-core/erp/warehouse-logistics/batch-lot-tracking"]},{"step":"Dispatch / Production Issue","state":"Dispatch and production issue handoff visible","rowCount":91,"routes":["/api/trade-core/erp/warehouse-logistics/dispatch","/api/trade-core/erp/manufacturing-mrp-full-chain/material-issue-readback"]}],"readiness":{"lot":"READY","batch":"READY","serial":"WAITING_FOR_BUSINESS_EXECUTION","expiry":"WAITING_FOR_BUSINESS_EXECUTION","fifo":"READY","lifo":"READY","traceability":"READY"},"counts":{"existingLotRows":5,"lotFileRows":4,"layerFileRows":0,"traceFileRows":1,"serialRows":0,"expiryRows":0,"movementLedger":91,"stockSnapshots":1,"listings":0,"productionOutputs":0,"qualityInspections":0},"pickingPolicy":{"fifo":"readback/config evidence only","lifo":"readback/config evidence only","fefo":"expiry-priority readback when expiry fields exist","executionApi":"Waiting for business execution"},"executionGate":"Existing readbacks only. No stock lots, serial numbers, expiry dates, FIFO/LIFO layers, dispatches, or production issues are simulated."},"batch3Readiness":null,"batch4Readiness":null,"generatedAt":"2026-07-17T06:41:04.481Z"}