jef-caferimo-orders

Source

• Repository: jef-systems/jef-caferimo-backend

• Table: jef-caferimo-orders

• Schema path: dynamodb/jef-caferimo-orders/schema.json

• Commit: 2a5142b3bd910e8046f3b2bd2241955550b7d85f

Attributes

{
  "pk": "string-id",
  "gsi_1_pk": "string-status",
  "gsi_1_sk": "number-created_at_ms",
  "id": "string",
  "document_type": "string",
  "print_template": "string",
  "printer_target": "string",
  "reference_no": "string",
  "title": "string",
  "created_at": "string-iso8601",
  "created_at_ms": "number-epoch-milliseconds",
  "order_created_at": "string-iso8601",
  "status": "string-enum-pending-preparing-completed-cancelled",
  "paper_width": "number-whole-number",
  "currency": "string",
  "order_type": "string-enum-dine_in-takeout-to_go",
  "order_type_label": "string",
  "table_no": "number-whole-number-or-null",
  "discount": {
    "label": "string-optional",
    "type": "string-optional",
    "id_no": "string-optional"
  },
  "items": [
    {
      "line_no": "number-whole-number",
      "item_id": "string",
      "item_name": "string",
      "category": "string",
      "quantity": "number-whole-number",
      "size": "string-enum-medium-large-or-null",
      "size_label": "string",
      "unit_price": "number-decimal",
      "subtotal": "number-decimal",
      "note": "string",
      "customization_tags": [
        "string"
      ],
      "status": "string",
      "customizations": {
        "temperature": "string-optional",
        "sugar_level": "string-optional",
        "milk_type": "string-optional",
        "extra_shots": "number-whole-number-optional",
        "extra_shot_unit_price": "number-decimal-optional"
      },
      "recipe_reference": {
        "recipe_number": "string-4-digits-optional",
        "recipe_name": "string-optional"
      },
      "recipe_resolution": {
        "binding_mode": "string-enum-none-single_recipe-variant_recipe",
        "matched_by": "string-enum-none-default-size-temperature-size_and_temperature",
        "selected_output": {
          "key": "string-optional",
          "value": "string-optional"
        }
      },
      "recipe_snapshot": {
        "pk": "string-optional",
        "recipe_number": "string-4-digits-optional",
        "recipe_name": "string-optional",
        "specifications": [
          {
            "key": "string",
            "value": "string"
          }
        ],
        "equipments": [
          {
            "asset_number": "string",
            "asset_name": "string"
          }
        ],
        "ingredients": [
          {
            "jsin": "string",
            "barcode": "string",
            "product_name": "string",
            "product_unit": "string"
          }
        ],
        "steps": [
          {
            "step_number": "number-whole-number",
            "title": "string",
            "description": "string",
            "ingredients": [
              {
                "jsin": "string",
                "barcode": "string",
                "product_name": "string",
                "product_unit": "string",
                "quantity": "number-two-decimals",
                "quantity_unit": "string"
              }
            ],
            "equipments": [
              {
                "asset_number": "string",
                "asset_name": "string",
                "quantity": "number-two-decimals",
                "quantity_unit": "string"
              }
            ]
          }
        ],
        "outputs": [
          {
            "key": "string",
            "value": "string"
          }
        ]
      }
    }
  ],
  "summary": {
    "total_items": "number-whole-number",
    "unique_items": "number-whole-number",
    "subtotal": "number-decimal",
    "service_charge": "number-decimal",
    "discount_amount": "number-decimal",
    "vatable_sales": "number-decimal",
    "vat_exempt_sales": "number-decimal",
    "vat_amount": "number-decimal",
    "grand_total": "number-decimal"
  },
  "payments": [
    {
      "method": "string-enum-cash-gcash-card",
      "amount": "number-decimal",
      "label": "string"
    }
  ],
  "payment": {
    "status": "string-optional",
    "amount_received": "number-decimal-optional",
    "change": "number-decimal-optional",
    "method_label": "string-optional",
    "lines": [
      {
        "method": "string-enum-cash-gcash-card",
        "amount": "number-decimal",
        "label": "string"
      }
    ]
  },
  "print_payload": {
    "header": [
      "string"
    ],
    "body": [
      {
        "qty_text": "string",
        "name_text": "string",
        "subtotal_text": "string",
        "note_text": "string",
        "customization_text": "string"
      }
    ],
    "footer": [
      "string"
    ]
  }
}

Main Index

{
  "pk": "pk"
}

Raw Schema

{
  "table": "jef-caferimo-orders",
  "attributes": {
    "pk": "string-id",
    "gsi_1_pk": "string-status",
    "gsi_1_sk": "number-created_at_ms",
    "id": "string",
    "document_type": "string",
    "print_template": "string",
    "printer_target": "string",
    "reference_no": "string",
    "title": "string",
    "created_at": "string-iso8601",
    "created_at_ms": "number-epoch-milliseconds",
    "order_created_at": "string-iso8601",
    "status": "string-enum-pending-preparing-completed-cancelled",
    "paper_width": "number-whole-number",
    "currency": "string",
    "order_type": "string-enum-dine_in-takeout-to_go",
    "order_type_label": "string",
    "table_no": "number-whole-number-or-null",
    "discount": {
      "label": "string-optional",
      "type": "string-optional",
      "id_no": "string-optional"
    },
    "items": [
      {
        "line_no": "number-whole-number",
        "item_id": "string",
        "item_name": "string",
        "category": "string",
        "quantity": "number-whole-number",
        "size": "string-enum-medium-large-or-null",
        "size_label": "string",
        "unit_price": "number-decimal",
        "subtotal": "number-decimal",
        "note": "string",
        "customization_tags": [
          "string"
        ],
        "status": "string",
        "customizations": {
          "temperature": "string-optional",
          "sugar_level": "string-optional",
          "milk_type": "string-optional",
          "extra_shots": "number-whole-number-optional",
          "extra_shot_unit_price": "number-decimal-optional"
        },
        "recipe_reference": {
          "recipe_number": "string-4-digits-optional",
          "recipe_name": "string-optional"
        },
        "recipe_resolution": {
          "binding_mode": "string-enum-none-single_recipe-variant_recipe",
          "matched_by": "string-enum-none-default-size-temperature-size_and_temperature",
          "selected_output": {
            "key": "string-optional",
            "value": "string-optional"
          }
        },
        "recipe_snapshot": {
          "pk": "string-optional",
          "recipe_number": "string-4-digits-optional",
          "recipe_name": "string-optional",
          "specifications": [
            {
              "key": "string",
              "value": "string"
            }
          ],
          "equipments": [
            {
              "asset_number": "string",
              "asset_name": "string"
            }
          ],
          "ingredients": [
            {
              "jsin": "string",
              "barcode": "string",
              "product_name": "string",
              "product_unit": "string"
            }
          ],
          "steps": [
            {
              "step_number": "number-whole-number",
              "title": "string",
              "description": "string",
              "ingredients": [
                {
                  "jsin": "string",
                  "barcode": "string",
                  "product_name": "string",
                  "product_unit": "string",
                  "quantity": "number-two-decimals",
                  "quantity_unit": "string"
                }
              ],
              "equipments": [
                {
                  "asset_number": "string",
                  "asset_name": "string",
                  "quantity": "number-two-decimals",
                  "quantity_unit": "string"
                }
              ]
            }
          ],
          "outputs": [
            {
              "key": "string",
              "value": "string"
            }
          ]
        }
      }
    ],
    "summary": {
      "total_items": "number-whole-number",
      "unique_items": "number-whole-number",
      "subtotal": "number-decimal",
      "service_charge": "number-decimal",
      "discount_amount": "number-decimal",
      "vatable_sales": "number-decimal",
      "vat_exempt_sales": "number-decimal",
      "vat_amount": "number-decimal",
      "grand_total": "number-decimal"
    },
    "payments": [
      {
        "method": "string-enum-cash-gcash-card",
        "amount": "number-decimal",
        "label": "string"
      }
    ],
    "payment": {
      "status": "string-optional",
      "amount_received": "number-decimal-optional",
      "change": "number-decimal-optional",
      "method_label": "string-optional",
      "lines": [
        {
          "method": "string-enum-cash-gcash-card",
          "amount": "number-decimal",
          "label": "string"
        }
      ]
    },
    "print_payload": {
      "header": [
        "string"
      ],
      "body": [
        {
          "qty_text": "string",
          "name_text": "string",
          "subtotal_text": "string",
          "note_text": "string",
          "customization_text": "string"
        }
      ],
      "footer": [
        "string"
      ]
    }
  },
  "main_index": {
    "pk": "pk"
  },
  "gsi_1": {
    "pk": "gsi_1_pk",
    "sk": "gsi_1_sk"
  }
}