{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Document","Metadata"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Document","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Section","Content"]
["Sheet: Template Info","Sheet: Template Info\n====================\n\n[GAP: Missing data for Sheet: Template Info]"]
["Sheet: Scope Filters","# Sheet: Scope Filters"]
["1. Introduction","This section defines the explicit scope filters for the system, identifying included and excluded features, data domains, and technical boundaries. These filters are established to ensure alignment with project objectives, technical constraints, and compliance requirements.\n\n---"]
["2. Functional Scope Filters","### 2.1 Included Functionalities\n\nThe following functionalities are within the scope of the current system:\n\n| Functionality                       | Description                                                                                                         | Source Requirement                                      |\n|-------------------------------------|---------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------|\n| Single order creation               | Orders can only be created one at a time via the REST API.                                                          | [KB-146a6a29-932f-485d-96d6-6a92ee610336]              |\n| Order detail retrieval              | Fetch order, payment, and notification data for a single order.                                                     | [KB-16181d30-2dd3-421e-bab0-939cd85255d2]              |\n| Order cancellation                  | Cancels a single order and triggers refund and notification.                                                        | [KB-186b33d7-f985-455b-8117-0cd019912510]              |\n| Payment processing                  | Each order is processed with an individual payment API call.                                                        | [KB-0a7d4d64-4d48-4214-94eb-2f3f278ec66a]              |\n| Notification dispatch               | Each order triggers an individual notification; no bulk notification capability.                                    | [KB-0a7d4d64-4d48-4214-94eb-2f3f278ec66a]              |\n| Pagination for order listing        | Orders can be listed with pagination (skip, limit).                                                                 | [KB-0e0f1dd0-0f46-4d13-a092-e3cdc6fdd205]              |\n\n---\n\n### 2.2 Excluded Functionalities\n\nThe following functionalities are explicitly out of scope for the current system:\n\n| Excluded Functionality              | Description                                                                                                         | Source Requirement                                      |\n|-------------------------------------|---------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------|\n| Bulk or batch order creation        | No capability to create multiple orders at once (no CSV upload, drag-and-drop, or batch creation form).             | [KB-146a6a29-932f-485d-96d6-6a92ee610336], [KB-0a36efdc-f63e-4c6b-8191-220e34d8af3f] |\n| CSV/file-based order import         | No endpoint or mechanism to upload and process order data from files (CSV, Excel, etc.).                            | [KB-146a6a29-932f-485d-96d6-6a92ee610336]              |\n| Batch payment processing            | No batch payment API exists; payments must be processed individually per order.                                     | [KB-0a7d4d64-4d48-4214-94eb-2f3f278ec66a]              |\n| Bulk notification dispatch          | No bulk notification capability; notifications are sent individually per order.                                      | [KB-0a7d4d64-4d48-4214-94eb-2f3f278ec66a]              |\n| Progress tracking for batch ops     | No mechanism to track progress of multi-item operations; batch progress bars are not supported.                     | [KB-0a7d4d64-4d48-4214-94eb-2f3f278ec66a]              |\n| Partial failure handling in batch   | No support for partial success/failure in batch operations (as batch operations are not supported).                 | [KB-0a7d4d64-4d48-4214-94eb-2f3f278ec66a]              |\n| Real-time dashboard updates         | No real-time updates; dashboard statistics are computed client-side and updated via polling only.                   | [KB-0a36efdc-f63e-4c6b-8191-220e34d8af3f]              |\n| Multi-language (i18n) support       | Only Japanese language is supported; no internationalization framework is implemented.                              | [KB-0a36efdc-f63e-4c6b-8191-220e34d8af3f]              |\n\n---"]
["3. Data Scope Filters","### 3.1 Included Data Domains\n\n| Data Domain              | Inclusion Criteria                                            | Source Requirement                        |\n|-------------------------|--------------------------------------------------------------|-------------------------------------------|\n| Orders                  | Single-entry only; no batch/group tracking fields present     | [KB-0f930ddc-1f3e-4a78-8662-d52514894afd] |\n| Payments                | 1:1 relationship to orders; batch grouping not supported      | [KB-11739ab0-b209-41e4-b73e-7d7e0c4338b2] |\n| Notifications           | Linked to individual orders only                              | [KB-0a7d4d64-4d48-4214-94eb-2f3f278ec66a] |\n\n---\n\n### 3.2 Excluded Data Domains\n\n| Data Domain              | Exclusion Criteria                                            | Source Requirement                        |\n|-------------------------|--------------------------------------------------------------|-------------------------------------------|\n| Batch import tracking    | No batch_id, csv_source, or bulk_import_group columns exist  | [KB-0f930ddc-1f3e-4a78-8662-d52514894afd] |\n| CSV row mapping          | No import_row_number or row-level mapping for CSV imports    | [KB-02c65582-456a-4ebf-b934-b7e08bd16081] |\n\n---"]
["4. Technical Scope Filters","### 4.1 Included Technical Boundaries\n\n| Area                   | Scope Detail                                                                                 | Source Requirement                        |\n|------------------------|----------------------------------------------------------------------------------------------|-------------------------------------------|\n| REST API               | All service-to-service communication is synchronous REST over HTTP                           | [KB-0d7daadd-e958-4592-900a-55db91f8aa55] |\n| Timeout/Retry Policy   | Payment API: 30s timeout, no retry; Notification API: 10s timeout, no retry                  | [KB-0d7daadd-e958-4592-900a-55db91f8aa55] |\n| Sequential Processing  | Order creation, payment, and notification are executed sequentially, not in parallel         | [KB-0a7d4d64-4d48-4214-94eb-2f3f278ec66a] |\n\n---\n\n### 4.2 Excluded Technical Boundaries\n\n| Area                   | Scope Detail                                                                                 | Source Requirement                        |\n|------------------------|----------------------------------------------------------------------------------------------|-------------------------------------------|\n| Asynchronous Messaging | No message broker, event bus, or asynchronous communication channel exists                   | [KB-0d7daadd-e958-4592-900a-55db91f8aa55] |\n| Parallel Processing    | No parallel or queue-based processing for order creation, payment, or notification           | [KB-0a7d4d64-4d48-4214-94eb-2f3f278ec66a] |\n| Bulk API Endpoints     | No bulk/batch endpoints for orders, payments, or notifications                              | [KB-0a7d4d64-4d48-4214-94eb-2f3f278ec66a] |\n\n---"]
["5. Summary Table: Scope Filters","| Category      | Included Scope                                                                 | Excluded Scope                                                                 |\n|---------------|-------------------------------------------------------------------------------|--------------------------------------------------------------------------------|\n| Functional    | Single order create/cancel/list, payment, notification, pagination            | Bulk/batch order creation, CSV import, batch payment, bulk notification        |\n| Data          | Orders, payments, notifications (single-entry)                                | Batch import tracking, CSV row mapping                                         |\n| Technical     | Synchronous REST API, sequential processing, defined timeouts                 | Async/event bus, parallel/batch processing, bulk endpoints                     |\n\n---"]
["6. Out-of-Scope Items","Any feature, data domain, or technical capability not explicitly listed as \"included\" above is considered out of scope for the current system and will require architectural and/or schema changes to support in the future.\n\n---\n\n**References:**  \n- [KB-146a6a29-932f-485d-96d6-6a92ee610336]  \n- [KB-0a36efdc-f63e-4c6b-8191-220e34d8af3f]  \n- [KB-0a7d4d64-4d48-4214-94eb-2f3f278ec66a]  \n- [KB-0f930ddc-1d3e-4a78-8662-d52514894afd]  \n- [KB-02c65582-456a-4ebf-b934-b7e08bd16081]  \n- [KB-11739ab0-b209-41e4-b73e-7d7e0c4338b2]  \n- [KB-0d7daadd-e958-4592-900a-55db91f8aa55]  \n- [KB-16181d30-2dd3-421e-bab0-939cd85255d2]  \n- [KB-186b33d7-f985-455b-8117-0cd019912510]"]
["Sheet: Sections","# Sheet: Sections"]
["1. Introduction","This section documents the system's functional and non-functional requirements, constraints, and limitations, as mandated by ISO-29148. All content is strictly derived from validated source materials and reflects the current operational, architectural, and compliance boundaries of the system.\n\n---"]
["2. Functional Requirements","### 2.1 Order Management\n\n- **Single Order Creation Only:** The system supports creation of one order at a time via REST API. There is no capability for bulk or batch order creation. [KB-146a6a29-932f-485d-96d6-6a92ee610336]\n- **No CSV/File Import:** There is no endpoint or mechanism to upload and process order data from files (CSV, Excel, etc.). [KB-146a6a29-932f-485d-96d6-6a92ee610336]\n- **Order Management UI:** The UI displays a disabled CSV Import button labeled “CSVインポート（未実装）” and an amber warning banner indicating CSV import is not available. Orders can be searched, filtered, and sorted, but only single order creation is possible. [KB-16181d30-2dd3-421e-bab0-939cd85255d2]\n\n### 2.2 Payment Processing\n\n- **One Transaction at a Time:** Payment processing is limited to one transaction per API call. There is no batch payment API. Each order requires an individual payment API call. [KB-146a6a29-932f-485d-96d6-6a92ee610336]\n- **Transaction Limits:** Minimum amount per transaction is 100 JPY; maximum is 1,000,000 JPY. These limits apply to each individual order and cannot be aggregated across multiple orders. [KB-186b33d7-f985-455b-8117-0cd019912510], [KB-11739ab0-b209-41e4-b73e-7d7e0c4338b2], [KB-10744011-e9ca-48b5-ac6d-4f9f3627b7e6]\n\n### 2.3 Notification Service\n\n- **No Bulk Notification:** Notifications are sent individually per order. There is no bulk notification capability; each notification requires a separate API call. [KB-146a6a29-932f-485d-96d6-6a92ee610336]\n- **Rate Limiting:** The notification service enforces a rate limit of 10 notifications per second. For example, sending notifications for 10,000 orders would require a minimum of 1,000 seconds (~17 minutes). [KB-06c5403a-d177-4525-b247-1d7ae37a86b8], [KB-04a84995-0820-4319-c1582821058a]\n\n### 2.4 Service Integration and Processing Flow\n\n- **Sequential Processing:** All cross-service calls (Order → Payment → Notification) are executed sequentially. There is no parallel or queue-based processing. The total latency for order creation is the sum of the time taken for saving the order, processing payment, and sending notification. [KB-150eb89c-77b0-415b-a547-3ed0502eec24], [KB-033639ab-c6f8-4f72-a373-bf76d05dd6cf]\n- **No Retry or Circuit Breaker:** There is no retry mechanism or circuit breaker for cross-service calls. If a service (e.g., Payment Service) is unavailable, the operation fails immediately and the order status is reverted to pending. [KB-150eb89c-77b0-415b-a547-3ed0502eec24], [KB-033639ab-c6f8-4f72-a373-bf76d05dd6cf]\n\n---"]
["3. Data and Schema Constraints","- **No Batch Tracking:** The orders table does not include batch_id, csv_source, or bulk_import_group columns. There is no mechanism to track which orders belong to a batch import. [KB-0f930ddc-1f3a-4014-a015-49fe1808f8d8], [KB-02c65582-456a-4ffe-8f7b-7d37af08e656]\n- **Payments Table 1:1 Constraint:** The payments table enforces a 1:1 relationship with orders via a unique order_id constraint, preventing batch grouping of payments. [KB-11739ab0-b209-41e4-b73e-7d7e0c4338b2], [KB-10744011-e9ca-48b5-ac6d-4f9f3627b7e6]\n\n---"]
["4. System Limitations","| ID      | Limitation                                                                                                   | Impact Area          | Severity   |\n|---------|--------------------------------------------------------------------------------------------------------------|----------------------|------------|\n| LIM-001 | Order creation is single-entry only. No bulk or batch order creation capability exists.                      | Order Service        | High       |\n| LIM-002 | No CSV/file-based order import functionality. No endpoint or mechanism to upload and process order data.     | Order Service        | High       |\n| LIM-003 | Payment processing handles one transaction at a time. No batch payment API exists.                           | Payment Service      | High       |\n| LIM-004 | Notifications are sent individually per order. No bulk notification capability exists.                       | Notification Service | Medium     |\n| LIM-005 | Cross-service calls are sequential. No parallel processing of payment and notification.                      | All Services         | Medium     |\n| LIM-006 | No progress tracking for batch operations. No mechanism to track progress of multi-item operations.          | All Services         | Medium     |  \n[KB-146a6a29-932f-485d-96d6-6a92ee610336], [KB-0a36efdc-f63e-4c6b-8191-220e34d8af3f], [KB-0a7d4d64-4d48-4214-94eb-2f3f278ec66a]\n\n---"]
["5. Performance and Scalability","- **Bulk Operations Not Supported:** Processing 10,000 orders requires 10,000 individual API calls. This results in extremely slow processing for large order volumes. [KB-150eb89c-77b0-415b-a547-3ed0502eec24]\n- **Notification Throughput:** Due to the 10/sec rate limit, sending notifications for 10,000 orders takes at least 1,000 seconds (~17 minutes). [KB-06c5403a-d177-4525-b247-1d7ae37a86b8], [KB-04a84995-0820-4319-c1582821058a]\n\n---"]
["6. User Interface Constraints","- **No Bulk Import UI:** There is no UI for bulk order import. No CSV upload, drag-and-drop, or batch creation form is available. [KB-0a36efdc-f63e-4c6b-8191-220e34d8af3f]\n- **Client-Side Aggregation:** Dashboard statistics are computed in the browser only; there is no backend endpoint for aggregate data retrieval. [KB-0a36efdc-f63e-4c6b-8191-220e34d8af3f]\n- **No Real-Time Updates:** The system uses polling for updates; there is no WebSocket or push-based real-time update capability. [KB-0a36efdc-f63e-4c6b-8191-220e34d8af3f]\n- **Single Language Support:** The system supports only Japanese; there is no internationalization (i18n) framework. [KB-0a36efdc-f63e-4c6b-8191-220e34d8af3f]\n\n---"]
["7. Compliance and Security","- **Error Handling:** Error responses in production must never contain PHI, stack traces, SQL queries, internal file paths, server names, or framework version information. Violations are treated as security incidents. [KB-10300d8a-a98a-4726-9be3-3957c2fe7bf4], [KB-140ca7f3-3348-4419-b06b-89561882a35e]\n- **Versioning:** Only major versions are included in the API path (e.g., /v1/). Minor and patch changes must be backward-compatible. Deprecation requires a minimum 6-month notice. [KB-10300d8a-a98a-4726-9be3-3957c2fe7bf4], [KB-140ca7f3-3348-4419-b06b-89561882a35e]\n\n---"]
["8. Summary Table: Key Constraints and Limitations","| Area                | Constraint / Limitation                                                                                      | Source(s)                                                  |\n|---------------------|-------------------------------------------------------------------------------------------------------------|------------------------------------------------------------|\n| Order Creation      | Single-entry only; no batch or CSV import                                                                   | [KB-146a6a29-932f-485d-96d6-6a92ee610336], [KB-0a36efdc-f63e-4c6b-8191-220e34d8af3f] |\n| Payment Processing  | One transaction per API call; no batch payments; 100–1,000,000 JPY per transaction                         | [KB-186b33d7-f985-455b-8117-0cd019912510], [KB-11739ab0-b209-41e4-b73e-7d7e0c4338b2]  |\n| Notification        | No bulk notification; 10/sec rate limit; sequential processing                                              | [KB-06c5403a-d177-4525-b247-1d7ae37a86b8], [KB-04a84995-0820-4319-c1582821058a]        |\n| Data Schema         | No batch_id or group tracking in orders/payments; 1:1 payment-order constraint                              | [KB-0f930ddc-1f3a-4014-a015-49fe1808f8d8], [KB-11739ab0-b209-41e4-b73e-7d7e0c4338b2]  |\n| UI                  | No bulk import UI; client-side aggregation only; no real-time updates; Japanese only                        | [KB-0a36efdc-f63e-4c6b-8191-220e34d8af3f]                                                    |\n| Error Handling      | No sensitive data in error responses; strict versioning policy                                              | [KB-10300d8a-a98a-4726-9be3-3957c2fe7bf4], [KB-140ca7f3-3348-4419-b06b-89561882a35e]    |\n\n---"]
["9. [GAP: Missing data for Sheet: Sections] (if additional ISO-29148 content is required beyond the above)","---\n\n**References:**  \n- [KB-146a6a29-932f-485d-96d6-6a92ee610336]  \n- [KB-0a36efdc-f63e-4c6b-8191-220e34d8af3f]  \n- [KB-16181d30-2dd3-421e-bab0-939cd85255d2]  \n- [KB-186b33d7-f985-455b-8117-0cd019912510]  \n- [KB-11739ab0-b209-41e4-b73e-7d7e0c4338b2]  \n- [KB-10744011-e9ca-48b5-ac6d-4f9f3627b7e6]  \n- [KB-06c5403a-d177-4525-b247-1d7ae37a86b8]  \n- [KB-04a84995-0820-4319-c1582821058a]  \n- [KB-150eb89c-77b0-415b-a547-3ed0502eec24]  \n- [KB-033639ab-c6f8-4f72-a373-bf76d05dd6cf]  \n- [KB-0f930ddc-1f3a-4014-a015-49fe1808f8d8]  \n- [KB-02c65582-456a-4ffe-8f7b-7d37af08e656]  \n- [KB-10300d8a-a98a-4726-9be3-3957c2fe7bf4]  \n- [KB-140ca7f3-3348-4419-b06b-89561882a35e]"]

{"sheet":"Metadata","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Property","Value"]
["document_id","29cd5f03-ba7e-40c1-aa7f-4fcb9addda21"]
["tenant_id","28aa3971-48af-4f2a-aa73-9e4f89fbfba4"]
["kb_project_id","None"]
["document_type","markdown"]
["is_stale","False"]
["generated_at","2026-03-25T03:19:08.915984+00:00"]