/store-orders-patch-one

Summary

  • Source repository: jef-systems/jef-store-backend

  • Source SHA: 8aeea2418405bc456b822b328ee67dbf6f3df16c

  • Source run id: 25872688849

  • Lambda function: jef-store-orders-patch-one

  • HTTP method: PATCH

  • API path: /store-orders-patch-one

  • Endpoint URL: https://dqo3268ty9.execute-api.ap-southeast-1.amazonaws.com/prod/store-orders-patch-one

  • Payload mode: json-body

Description

  • Function: jef-store-orders-patch-one

  • Module: jef-store

  • Action: patch-one

  • Method: PATCH

  • Invocation Mode: ASYNC

  • Resource Path: /store-orders-patch-one

  • Table: jef-store-orders

  • Primary Key: order_number

API Gateway Response

  • status\_code: 202

  • message: Request accepted for asynchronous processing.

Payload Example

  • order\_number: 86b39313-ba69-445c-a1f3-44934db7442b

  • entity\_number: 218ea31f-036f-4b70-a0d6-1207af724d49

  • source: In-store POS

  • created\_at: 2026-05-14T16:36:01Z

  • paid\_at: 2026-05-14T16:36:01Z

  • status: PAID

  • payment\_status: PAID_FULL

  • payment\_method: GCASH

  • payment\_reference: GCASH-8A19K4F2

  • receipt\_mode: Digital

  • receipt\_printed\_at: 2026-05-14T16:36:01Z

  • customer\_number: CUST-10293

  • customer\_name: Maricel Dela Cruz

  • customer\_phone: +63 917 482 0193

  • customer\_email: maricel.delacruz@gmail.com

  • delivery\_mode: PICKUP

  • full\_address: Jef Store QC, 112 Tomas Morato St., Quezon City, Metro Manila, Philippines

  • branch\_pickup\_name: Jef Store Tomas Morato

  • delivery\_instructions: Pickup at the cashier window. Present receipt QR/code.

  • internal\_note: Order confirmed; items packed and ready for pickup.

  • call\_before\_delivery: False

  • subtotal: 1240

  • shipping\_fee: 0

  • discount: 120

  • grand\_total: 1120

  • amount\_paid: 1120

  • total\_quantity: 6

  • is\_deleted: False

  • deleted\_at: 1970-01-01T00:00:00Z

  • updated\_at: 2026-05-14T16:36:01Z

  • idempotency\_key: idem-jef-store-orders-1

  • schema\_version: 1

  • version: 1

  • children.order\_items\[0\].order\_item\_id: 1307aafd-6501-496a-9be1-3cc2a69b1a6f

  • children.order\_items\[0\].entity\_number: JEF-NEC_001

  • children.order\_items\[0\].order\_number: 86b39313-ba69-445c-a1f3-44934db7442b

  • children.order\_items\[0\].line\_number: 1

  • children.order\_items\[0\].product\_number: PRD-ICE-CG-001

  • children.order\_items\[0\].sku: ICE-COFFEE-473ML

  • children.order\_items\[0\].product\_name: Ice Coffee 473ml Can

  • children.order\_items\[0\].quantity: 6

  • children.order\_items\[0\].unit\_price: 55.0

  • children.order\_items\[0\].line\_total: 330.0

  • children.order\_items\[0\].is\_voided: False

  • children.order\_items\[0\].is\_deleted: False

  • children.order\_items\[0\].deleted\_at: 1970-01-01T00:00:00Z

  • children.order\_items\[0\].created\_at: 2026-05-14T16:37:08Z

  • children.order\_items\[0\].updated\_at: 2026-05-14T16:37:08Z

  • children.order\_items\[0\].idempotency\_key: idem-jef-store-order-items-1

  • children.order\_items\[0\].schema\_version: 1

  • children.order\_items\[0\].version: 1

  • children.payments\[0\].payment\_id: 33b4d6c3-a863-4720-acab-6f2f9819d379

  • children.payments\[0\].entity\_number: JEF-CEBU-0142

  • children.payments\[0\].order\_number: 86b39313-ba69-445c-a1f3-44934db7442b

  • children.payments\[0\].payment\_reference: PMT-8472-DS-86b3

  • children.payments\[0\].payment\_method: GCash

  • children.payments\[0\].payment\_status: PAID

  • children.payments\[0\].amount\_due: 18990

  • children.payments\[0\].amount\_paid: 18990

  • children.payments\[0\].paid\_at: 2026-05-14T16:36:14Z

  • children.payments\[0\].failure\_reason: - children.payments[0].is_active: True

  • children.payments\[0\].is\_deleted: False

  • children.payments\[0\].deleted\_at: 1970-01-01T00:00:00Z

  • children.payments\[0\].created\_at: 2026-05-14T16:36:14Z

  • children.payments\[0\].updated\_at: 2026-05-14T16:36:14Z

  • children.payments\[0\].idempotency\_key: idem-jef-store-payments-1

  • children.payments\[0\].schema\_version: 1

  • children.payments\[0\].version: 1

Payload Schema

{
  "root.type": "M",
  "root.required": "True",
  "root.attributes.order_number.type": "S",
  "root.attributes.order_number.required": "True",
  "root.attributes.order_number.format": "uuidv4",
  "root.attributes.order_number.regex": "^[1-9a-fA-F][0-9a-fA-F]{7}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$",
  "root.attributes.entity_number.type": "S",
  "root.attributes.entity_number.required": "False",
  "root.attributes.entity_number.format": "uuidv4",
  "root.attributes.entity_number.regex": "^[1-9a-fA-F][0-9a-fA-F]{7}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$",
  "root.attributes.source.type": "S",
  "root.attributes.source.required": "False",
  "root.attributes.source.regex": "^[A-Za-z0-9 ._-]{1,100}$",
  "root.attributes.created_at.type": "S",
  "root.attributes.created_at.required": "False",
  "root.attributes.created_at.format": "iso8601",
  "root.attributes.created_at.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "root.attributes.paid_at.type": "S",
  "root.attributes.paid_at.required": "False",
  "root.attributes.paid_at.format": "iso8601",
  "root.attributes.paid_at.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "root.attributes.status.type": "S",
  "root.attributes.status.required": "False",
  "root.attributes.status.regex": "^[A-Za-z0-9 ._-]{1,100}$",
  "root.attributes.payment_status.type": "S",
  "root.attributes.payment_status.required": "False",
  "root.attributes.payment_status.regex": "^[A-Za-z0-9_-]{1,64}$",
  "root.attributes.payment_method.type": "S",
  "root.attributes.payment_method.required": "False",
  "root.attributes.payment_method.regex": "^[A-Za-z0-9_-]{1,64}$",
  "root.attributes.payment_reference.type": "S",
  "root.attributes.payment_reference.required": "False",
  "root.attributes.payment_reference.regex": "^[A-Za-z0-9_-]{1,64}$",
  "root.attributes.receipt_mode.type": "S",
  "root.attributes.receipt_mode.required": "False",
  "root.attributes.receipt_mode.regex": "^[A-Za-z0-9_-]{1,64}$",
  "root.attributes.receipt_printed_at.type": "S",
  "root.attributes.receipt_printed_at.required": "False",
  "root.attributes.receipt_printed_at.format": "iso8601",
  "root.attributes.receipt_printed_at.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "root.attributes.customer_number.type": "S",
  "root.attributes.customer_number.required": "False",
  "root.attributes.customer_number.regex": "^[A-Za-z0-9_-]{1,64}$",
  "root.attributes.customer_name.type": "S",
  "root.attributes.customer_name.required": "False",
  "root.attributes.customer_name.regex": "^[A-Za-z0-9 ._-]{1,100}$",
  "root.attributes.customer_phone.type": "S",
  "root.attributes.customer_phone.required": "False",
  "root.attributes.customer_phone.regex": "^[0-9+() .-]{0,30}$",
  "root.attributes.customer_email.type": "S",
  "root.attributes.customer_email.required": "False",
  "root.attributes.customer_email.regex": "^[^@\\s]+@[^@\\s]+\\.[^@\\s]+$",
  "root.attributes.delivery_mode.type": "S",
  "root.attributes.delivery_mode.required": "False",
  "root.attributes.delivery_mode.regex": "^[A-Za-z0-9_-]{1,64}$",
  "root.attributes.full_address.type": "S",
  "root.attributes.full_address.required": "False",
  "root.attributes.full_address.regex": "^.{0,500}$",
  "root.attributes.branch_pickup_name.type": "S",
  "root.attributes.branch_pickup_name.required": "False",
  "root.attributes.branch_pickup_name.regex": "^[A-Za-z0-9 ._-]{1,100}$",
  "root.attributes.delivery_instructions.type": "S",
  "root.attributes.delivery_instructions.required": "False",
  "root.attributes.delivery_instructions.regex": "^.{0,500}$",
  "root.attributes.internal_note.type": "S",
  "root.attributes.internal_note.required": "False",
  "root.attributes.internal_note.regex": "^.{0,500}$",
  "root.attributes.call_before_delivery.type": "BOOL",
  "root.attributes.call_before_delivery.required": "False",
  "root.attributes.call_before_delivery.regex": "^(true|false)$",
  "root.attributes.subtotal.type": "N",
  "root.attributes.subtotal.required": "False",
  "root.attributes.subtotal.regex": "^-?\\d+(\\.\\d+)?$",
  "root.attributes.shipping_fee.type": "N",
  "root.attributes.shipping_fee.required": "False",
  "root.attributes.shipping_fee.regex": "^-?\\d+(\\.\\d+)?$",
  "root.attributes.discount.type": "N",
  "root.attributes.discount.required": "False",
  "root.attributes.discount.regex": "^-?\\d+(\\.\\d+)?$",
  "root.attributes.grand_total.type": "N",
  "root.attributes.grand_total.required": "False",
  "root.attributes.grand_total.regex": "^-?\\d+(\\.\\d+)?$",
  "root.attributes.amount_paid.type": "N",
  "root.attributes.amount_paid.required": "False",
  "root.attributes.amount_paid.regex": "^-?\\d+(\\.\\d+)?$",
  "root.attributes.total_quantity.type": "N",
  "root.attributes.total_quantity.required": "False",
  "root.attributes.total_quantity.regex": "^\\d+$",
  "root.attributes.is_deleted.type": "BOOL",
  "root.attributes.is_deleted.required": "False",
  "root.attributes.is_deleted.regex": "^(true|false)$",
  "root.attributes.deleted_at.type": "S",
  "root.attributes.deleted_at.required": "False",
  "root.attributes.deleted_at.format": "iso8601",
  "root.attributes.deleted_at.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "root.attributes.updated_at.type": "S",
  "root.attributes.updated_at.required": "False",
  "root.attributes.updated_at.format": "iso8601",
  "root.attributes.updated_at.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "root.attributes.idempotency_key.type": "S",
  "root.attributes.idempotency_key.required": "False",
  "root.attributes.idempotency_key.regex": "^.{1,300}$",
  "root.attributes.schema_version.type": "N",
  "root.attributes.schema_version.required": "False",
  "root.attributes.schema_version.regex": "^\\d+$",
  "root.attributes.version.type": "N",
  "root.attributes.version.required": "False",
  "root.attributes.version.regex": "^\\d+$",
  "root.attributes.children.type": "M",
  "root.attributes.children.required": "False",
  "root.attributes.children.attributes.order_items.type": "L",
  "root.attributes.children.attributes.order_items.required": "False",
  "root.attributes.children.attributes.order_items.items.type": "M",
  "root.attributes.children.attributes.order_items.items.attributes.order_item_id.type": "S",
  "root.attributes.children.attributes.order_items.items.attributes.order_item_id.required": "True",
  "root.attributes.children.attributes.order_items.items.attributes.order_item_id.format": "uuidv4",
  "root.attributes.children.attributes.order_items.items.attributes.order_item_id.regex": "^[1-9a-fA-F][0-9a-fA-F]{7}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$",
  "root.attributes.children.attributes.order_items.items.attributes.entity_number.type": "S",
  "root.attributes.children.attributes.order_items.items.attributes.entity_number.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.entity_number.regex": "^[A-Za-z0-9_-]{1,64}$",
  "root.attributes.children.attributes.order_items.items.attributes.order_number.type": "S",
  "root.attributes.children.attributes.order_items.items.attributes.order_number.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.order_number.format": "uuidv4",
  "root.attributes.children.attributes.order_items.items.attributes.order_number.regex": "^[1-9a-fA-F][0-9a-fA-F]{7}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$",
  "root.attributes.children.attributes.order_items.items.attributes.line_number.type": "N",
  "root.attributes.children.attributes.order_items.items.attributes.line_number.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.line_number.regex": "^\\d+$",
  "root.attributes.children.attributes.order_items.items.attributes.product_number.type": "S",
  "root.attributes.children.attributes.order_items.items.attributes.product_number.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.product_number.regex": "^[A-Za-z0-9_-]{1,64}$",
  "root.attributes.children.attributes.order_items.items.attributes.sku.type": "S",
  "root.attributes.children.attributes.order_items.items.attributes.sku.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.sku.regex": "^[A-Za-z0-9 ._-]{1,100}$",
  "root.attributes.children.attributes.order_items.items.attributes.product_name.type": "S",
  "root.attributes.children.attributes.order_items.items.attributes.product_name.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.product_name.regex": "^[A-Za-z0-9 ._-]{1,100}$",
  "root.attributes.children.attributes.order_items.items.attributes.quantity.type": "N",
  "root.attributes.children.attributes.order_items.items.attributes.quantity.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.quantity.regex": "^-?\\d+(\\.\\d+)?$",
  "root.attributes.children.attributes.order_items.items.attributes.unit_price.type": "N",
  "root.attributes.children.attributes.order_items.items.attributes.unit_price.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.unit_price.regex": "^-?\\d+(\\.\\d+)?$",
  "root.attributes.children.attributes.order_items.items.attributes.line_total.type": "N",
  "root.attributes.children.attributes.order_items.items.attributes.line_total.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.line_total.regex": "^-?\\d+(\\.\\d+)?$",
  "root.attributes.children.attributes.order_items.items.attributes.is_voided.type": "BOOL",
  "root.attributes.children.attributes.order_items.items.attributes.is_voided.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.is_voided.regex": "^(true|false)$",
  "root.attributes.children.attributes.order_items.items.attributes.is_deleted.type": "BOOL",
  "root.attributes.children.attributes.order_items.items.attributes.is_deleted.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.is_deleted.regex": "^(true|false)$",
  "root.attributes.children.attributes.order_items.items.attributes.deleted_at.type": "S",
  "root.attributes.children.attributes.order_items.items.attributes.deleted_at.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.deleted_at.format": "iso8601",
  "root.attributes.children.attributes.order_items.items.attributes.deleted_at.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "root.attributes.children.attributes.order_items.items.attributes.created_at.type": "S",
  "root.attributes.children.attributes.order_items.items.attributes.created_at.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.created_at.format": "iso8601",
  "root.attributes.children.attributes.order_items.items.attributes.created_at.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "root.attributes.children.attributes.order_items.items.attributes.updated_at.type": "S",
  "root.attributes.children.attributes.order_items.items.attributes.updated_at.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.updated_at.format": "iso8601",
  "root.attributes.children.attributes.order_items.items.attributes.updated_at.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "root.attributes.children.attributes.order_items.items.attributes.idempotency_key.type": "S",
  "root.attributes.children.attributes.order_items.items.attributes.idempotency_key.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.idempotency_key.regex": "^.{1,300}$",
  "root.attributes.children.attributes.order_items.items.attributes.schema_version.type": "N",
  "root.attributes.children.attributes.order_items.items.attributes.schema_version.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.schema_version.regex": "^\\d+$",
  "root.attributes.children.attributes.order_items.items.attributes.version.type": "N",
  "root.attributes.children.attributes.order_items.items.attributes.version.required": "False",
  "root.attributes.children.attributes.order_items.items.attributes.version.regex": "^\\d+$",
  "root.attributes.children.attributes.payments.type": "L",
  "root.attributes.children.attributes.payments.required": "False",
  "root.attributes.children.attributes.payments.items.type": "M",
  "root.attributes.children.attributes.payments.items.attributes.payment_id.type": "S",
  "root.attributes.children.attributes.payments.items.attributes.payment_id.required": "True",
  "root.attributes.children.attributes.payments.items.attributes.payment_id.format": "uuidv4",
  "root.attributes.children.attributes.payments.items.attributes.payment_id.regex": "^[1-9a-fA-F][0-9a-fA-F]{7}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$",
  "root.attributes.children.attributes.payments.items.attributes.entity_number.type": "S",
  "root.attributes.children.attributes.payments.items.attributes.entity_number.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.entity_number.regex": "^[A-Za-z0-9_-]{1,64}$",
  "root.attributes.children.attributes.payments.items.attributes.order_number.type": "S",
  "root.attributes.children.attributes.payments.items.attributes.order_number.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.order_number.format": "uuidv4",
  "root.attributes.children.attributes.payments.items.attributes.order_number.regex": "^[1-9a-fA-F][0-9a-fA-F]{7}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$",
  "root.attributes.children.attributes.payments.items.attributes.payment_reference.type": "S",
  "root.attributes.children.attributes.payments.items.attributes.payment_reference.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.payment_reference.regex": "^[A-Za-z0-9_-]{1,64}$",
  "root.attributes.children.attributes.payments.items.attributes.payment_method.type": "S",
  "root.attributes.children.attributes.payments.items.attributes.payment_method.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.payment_method.regex": "^[A-Za-z0-9_-]{1,64}$",
  "root.attributes.children.attributes.payments.items.attributes.payment_status.type": "S",
  "root.attributes.children.attributes.payments.items.attributes.payment_status.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.payment_status.regex": "^[A-Za-z0-9_-]{1,64}$",
  "root.attributes.children.attributes.payments.items.attributes.amount_due.type": "N",
  "root.attributes.children.attributes.payments.items.attributes.amount_due.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.amount_due.regex": "^-?\\d+(\\.\\d+)?$",
  "root.attributes.children.attributes.payments.items.attributes.amount_paid.type": "N",
  "root.attributes.children.attributes.payments.items.attributes.amount_paid.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.amount_paid.regex": "^-?\\d+(\\.\\d+)?$",
  "root.attributes.children.attributes.payments.items.attributes.paid_at.type": "S",
  "root.attributes.children.attributes.payments.items.attributes.paid_at.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.paid_at.format": "iso8601",
  "root.attributes.children.attributes.payments.items.attributes.paid_at.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "root.attributes.children.attributes.payments.items.attributes.failure_reason.type": "S",
  "root.attributes.children.attributes.payments.items.attributes.failure_reason.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.failure_reason.regex": "^.{0,500}$",
  "root.attributes.children.attributes.payments.items.attributes.is_active.type": "BOOL",
  "root.attributes.children.attributes.payments.items.attributes.is_active.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.is_active.regex": "^(true|false)$",
  "root.attributes.children.attributes.payments.items.attributes.is_deleted.type": "BOOL",
  "root.attributes.children.attributes.payments.items.attributes.is_deleted.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.is_deleted.regex": "^(true|false)$",
  "root.attributes.children.attributes.payments.items.attributes.deleted_at.type": "S",
  "root.attributes.children.attributes.payments.items.attributes.deleted_at.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.deleted_at.format": "iso8601",
  "root.attributes.children.attributes.payments.items.attributes.deleted_at.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "root.attributes.children.attributes.payments.items.attributes.created_at.type": "S",
  "root.attributes.children.attributes.payments.items.attributes.created_at.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.created_at.format": "iso8601",
  "root.attributes.children.attributes.payments.items.attributes.created_at.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "root.attributes.children.attributes.payments.items.attributes.updated_at.type": "S",
  "root.attributes.children.attributes.payments.items.attributes.updated_at.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.updated_at.format": "iso8601",
  "root.attributes.children.attributes.payments.items.attributes.updated_at.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "root.attributes.children.attributes.payments.items.attributes.idempotency_key.type": "S",
  "root.attributes.children.attributes.payments.items.attributes.idempotency_key.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.idempotency_key.regex": "^.{1,300}$",
  "root.attributes.children.attributes.payments.items.attributes.schema_version.type": "N",
  "root.attributes.children.attributes.payments.items.attributes.schema_version.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.schema_version.regex": "^\\d+$",
  "root.attributes.children.attributes.payments.items.attributes.version.type": "N",
  "root.attributes.children.attributes.payments.items.attributes.version.required": "False",
  "root.attributes.children.attributes.payments.items.attributes.version.regex": "^\\d+$"
}

Response Schema

{
  "root.type": "M",
  "root.required": "True",
  "root.attributes.is_accepted.type": "BOOL",
  "root.attributes.is_accepted.required": "True",
  "root.attributes.message.type": "S",
  "root.attributes.message.required": "True",
  "root.attributes.request_id.type": "S",
  "root.attributes.request_id.required": "False"
}

Request Payload

{
  "order_number": "86b39313-ba69-445c-a1f3-44934db7442b",
  "entity_number": "218ea31f-036f-4b70-a0d6-1207af724d49",
  "source": "In-store POS",
  "created_at": "2026-05-14T16:36:01Z",
  "paid_at": "2026-05-14T16:36:01Z",
  "status": "PAID",
  "payment_status": "PAID_FULL",
  "payment_method": "GCASH",
  "payment_reference": "GCASH-8A19K4F2",
  "receipt_mode": "Digital",
  "receipt_printed_at": "2026-05-14T16:36:01Z",
  "customer_number": "CUST-10293",
  "customer_name": "Maricel Dela Cruz",
  "customer_phone": "+63 917 482 0193",
  "customer_email": "[email protected]",
  "delivery_mode": "PICKUP",
  "full_address": "Jef Store QC, 112 Tomas Morato St., Quezon City, Metro Manila, Philippines",
  "branch_pickup_name": "Jef Store Tomas Morato",
  "delivery_instructions": "Pickup at the cashier window. Present receipt QR/code.",
  "internal_note": "Order confirmed; items packed and ready for pickup.",
  "call_before_delivery": "False",
  "subtotal": "1240",
  "shipping_fee": "0",
  "discount": "120",
  "grand_total": "1120",
  "amount_paid": "1120",
  "total_quantity": "6",
  "is_deleted": "False",
  "deleted_at": "1970-01-01T00:00:00Z",
  "updated_at": "2026-05-14T16:36:01Z",
  "idempotency_key": "idem-jef-store-orders-1",
  "schema_version": "1",
  "version": "1",
  "children.order_items[0].order_item_id": "1307aafd-6501-496a-9be1-3cc2a69b1a6f",
  "children.order_items[0].entity_number": "JEF-NEC_001",
  "children.order_items[0].order_number": "86b39313-ba69-445c-a1f3-44934db7442b",
  "children.order_items[0].line_number": "1",
  "children.order_items[0].product_number": "PRD-ICE-CG-001",
  "children.order_items[0].sku": "ICE-COFFEE-473ML",
  "children.order_items[0].product_name": "Ice Coffee 473ml Can",
  "children.order_items[0].quantity": "6",
  "children.order_items[0].unit_price": "55.0",
  "children.order_items[0].line_total": "330.0",
  "children.order_items[0].is_voided": "False",
  "children.order_items[0].is_deleted": "False",
  "children.order_items[0].deleted_at": "1970-01-01T00:00:00Z",
  "children.order_items[0].created_at": "2026-05-14T16:37:08Z",
  "children.order_items[0].updated_at": "2026-05-14T16:37:08Z",
  "children.order_items[0].idempotency_key": "idem-jef-store-order-items-1",
  "children.order_items[0].schema_version": "1",
  "children.order_items[0].version": "1",
  "children.payments[0].payment_id": "33b4d6c3-a863-4720-acab-6f2f9819d379",
  "children.payments[0].entity_number": "JEF-CEBU-0142",
  "children.payments[0].order_number": "86b39313-ba69-445c-a1f3-44934db7442b",
  "children.payments[0].payment_reference": "PMT-8472-DS-86b3",
  "children.payments[0].payment_method": "GCash",
  "children.payments[0].payment_status": "PAID",
  "children.payments[0].amount_due": "18990",
  "children.payments[0].amount_paid": "18990",
  "children.payments[0].paid_at": "2026-05-14T16:36:14Z",
  "children.payments[0].failure_reason": "",
  "children.payments[0].is_active": "True",
  "children.payments[0].is_deleted": "False",
  "children.payments[0].deleted_at": "1970-01-01T00:00:00Z",
  "children.payments[0].created_at": "2026-05-14T16:36:14Z",
  "children.payments[0].updated_at": "2026-05-14T16:36:14Z",
  "children.payments[0].idempotency_key": "idem-jef-store-payments-1",
  "children.payments[0].schema_version": "1",
  "children.payments[0].version": "1"
}

Response

{
  "root.type": "M",
  "root.required": "True",
  "root.attributes.is_accepted.type": "BOOL",
  "root.attributes.is_accepted.required": "True",
  "root.attributes.message.type": "S",
  "root.attributes.message.required": "True",
  "root.attributes.request_id.type": "S",
  "root.attributes.request_id.required": "False"
}

CMD curl

curl -X PATCH "https://dqo3268ty9.execute-api.ap-southeast-1.amazonaws.com/prod/store-orders-patch-one" -H "Content-Type: application/json" --data-raw "{\"order_number\": \"86b39313-ba69-445c-a1f3-44934db7442b\", \"entity_number\": \"218ea31f-036f-4b70-a0d6-1207af724d49\", \"source\": \"In-store POS\", \"created_at\": \"2026-05-14T16:36:01Z\", \"paid_at\": \"2026-05-14T16:36:01Z\", \"status\": \"PAID\", \"payment_status\": \"PAID_FULL\", \"payment_method\": \"GCASH\", \"payment_reference\": \"GCASH-8A19K4F2\", \"receipt_mode\": \"Digital\", \"receipt_printed_at\": \"2026-05-14T16:36:01Z\", \"customer_number\": \"CUST-10293\", \"customer_name\": \"Maricel Dela Cruz\", \"customer_phone\": \"+63 917 482 0193\", \"customer_email\": \"[email protected]\", \"delivery_mode\": \"PICKUP\", \"full_address\": \"Jef Store QC, 112 Tomas Morato St., Quezon City, Metro Manila, Philippines\", \"branch_pickup_name\": \"Jef Store Tomas Morato\", \"delivery_instructions\": \"Pickup at the cashier window. Present receipt QR/code.\", \"internal_note\": \"Order confirmed; items packed and ready for pickup.\", \"call_before_delivery\": false, \"subtotal\": 1240, \"shipping_fee\": 0, \"discount\": 120, \"grand_total\": 1120, \"amount_paid\": 1120, \"total_quantity\": 6, \"is_deleted\": false, \"deleted_at\": \"1970-01-01T00:00:00Z\", \"updated_at\": \"2026-05-14T16:36:01Z\", \"idempotency_key\": \"idem-jef-store-orders-1\", \"schema_version\": 1, \"version\": 1, \"children\": {\"order_items\": [{\"order_item_id\": \"1307aafd-6501-496a-9be1-3cc2a69b1a6f\", \"entity_number\": \"JEF-NEC_001\", \"order_number\": \"86b39313-ba69-445c-a1f3-44934db7442b\", \"line_number\": 1, \"product_number\": \"PRD-ICE-CG-001\", \"sku\": \"ICE-COFFEE-473ML\", \"product_name\": \"Ice Coffee 473ml Can\", \"quantity\": 6, \"unit_price\": 55.0, \"line_total\": 330.0, \"is_voided\": false, \"is_deleted\": false, \"deleted_at\": \"1970-01-01T00:00:00Z\", \"created_at\": \"2026-05-14T16:37:08Z\", \"updated_at\": \"2026-05-14T16:37:08Z\", \"idempotency_key\": \"idem-jef-store-order-items-1\", \"schema_version\": 1, \"version\": 1}], \"payments\": [{\"payment_id\": \"33b4d6c3-a863-4720-acab-6f2f9819d379\", \"entity_number\": \"JEF-CEBU-0142\", \"order_number\": \"86b39313-ba69-445c-a1f3-44934db7442b\", \"payment_reference\": \"PMT-8472-DS-86b3\", \"payment_method\": \"GCash\", \"payment_status\": \"PAID\", \"amount_due\": 18990, \"amount_paid\": 18990, \"paid_at\": \"2026-05-14T16:36:14Z\", \"failure_reason\": \"\", \"is_active\": true, \"is_deleted\": false, \"deleted_at\": \"1970-01-01T00:00:00Z\", \"created_at\": \"2026-05-14T16:36:14Z\", \"updated_at\": \"2026-05-14T16:36:14Z\", \"idempotency_key\": \"idem-jef-store-payments-1\", \"schema_version\": 1, \"version\": 1}]}}"

PowerShell curl

curl.exe -X PATCH "https://dqo3268ty9.execute-api.ap-southeast-1.amazonaws.com/prod/store-orders-patch-one" -H "Content-Type: application/json" --data-raw '{"order_number": "86b39313-ba69-445c-a1f3-44934db7442b", "entity_number": "218ea31f-036f-4b70-a0d6-1207af724d49", "source": "In-store POS", "created_at": "2026-05-14T16:36:01Z", "paid_at": "2026-05-14T16:36:01Z", "status": "PAID", "payment_status": "PAID_FULL", "payment_method": "GCASH", "payment_reference": "GCASH-8A19K4F2", "receipt_mode": "Digital", "receipt_printed_at": "2026-05-14T16:36:01Z", "customer_number": "CUST-10293", "customer_name": "Maricel Dela Cruz", "customer_phone": "+63 917 482 0193", "customer_email": "[email protected]", "delivery_mode": "PICKUP", "full_address": "Jef Store QC, 112 Tomas Morato St., Quezon City, Metro Manila, Philippines", "branch_pickup_name": "Jef Store Tomas Morato", "delivery_instructions": "Pickup at the cashier window. Present receipt QR/code.", "internal_note": "Order confirmed; items packed and ready for pickup.", "call_before_delivery": false, "subtotal": 1240, "shipping_fee": 0, "discount": 120, "grand_total": 1120, "amount_paid": 1120, "total_quantity": 6, "is_deleted": false, "deleted_at": "1970-01-01T00:00:00Z", "updated_at": "2026-05-14T16:36:01Z", "idempotency_key": "idem-jef-store-orders-1", "schema_version": 1, "version": 1, "children": {"order_items": [{"order_item_id": "1307aafd-6501-496a-9be1-3cc2a69b1a6f", "entity_number": "JEF-NEC_001", "order_number": "86b39313-ba69-445c-a1f3-44934db7442b", "line_number": 1, "product_number": "PRD-ICE-CG-001", "sku": "ICE-COFFEE-473ML", "product_name": "Ice Coffee 473ml Can", "quantity": 6, "unit_price": 55.0, "line_total": 330.0, "is_voided": false, "is_deleted": false, "deleted_at": "1970-01-01T00:00:00Z", "created_at": "2026-05-14T16:37:08Z", "updated_at": "2026-05-14T16:37:08Z", "idempotency_key": "idem-jef-store-order-items-1", "schema_version": 1, "version": 1}], "payments": [{"payment_id": "33b4d6c3-a863-4720-acab-6f2f9819d379", "entity_number": "JEF-CEBU-0142", "order_number": "86b39313-ba69-445c-a1f3-44934db7442b", "payment_reference": "PMT-8472-DS-86b3", "payment_method": "GCash", "payment_status": "PAID", "amount_due": 18990, "amount_paid": 18990, "paid_at": "2026-05-14T16:36:14Z", "failure_reason": "", "is_active": true, "is_deleted": false, "deleted_at": "1970-01-01T00:00:00Z", "created_at": "2026-05-14T16:36:14Z", "updated_at": "2026-05-14T16:36:14Z", "idempotency_key": "idem-jef-store-payments-1", "schema_version": 1, "version": 1}]}}'