jef-caferimo-sales-invoices

Source

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

• Table: jef-caferimo-sales-invoices

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

• Commit: 61bf40027ec6f0d4c462cc0220b26c3c4a547dd3

• Generated at: 2026-04-27T14:22:01Z

Attributes

{
  "entity_number": "string",
  "sales_invoice_number": "string",
  "order_id": "string",
  "order_number": "string",
  "sales_date": "string",
  "sales_datetime": "string",
  "business_date": "string",
  "invoice_status": "string",
  "payment_status": "string",
  "order_lifecycle_status": "string",
  "items": [
    {
      "cartId": "string",
      "productId": "string",
      "name": "string",
      "size": {
        "label": "string",
        "upcharge": "number"
      },
      "milk": {
        "name": "string",
        "price": "number"
      },
      "addOns": [
        {
          "id": "string",
          "name": "string",
          "price": "number"
        }
      ],
      "note": "string",
      "basePrice": "number",
      "sizeUpcharge": "number",
      "milkUpcharge": "number",
      "addOnsTotal": "number",
      "unitPrice": "number",
      "quantity": "number",
      "line_total": "number"
    }
  ],
  "subtotal": "number",
  "vat_amount": "number",
  "discount_amount": "number",
  "final_total": "number",
  "payment_method": "string",
  "paid_amount": "number",
  "change_amount": "number",
  "gcash_reference": "string",
  "purchase_order_number": "string",
  "purchase_order_company": "string",
  "purchase_order_remarks": "string",
  "store_name_display": "string",
  "store_tagline": "string",
  "branch_name": "string",
  "store_address": "string",
  "store_city_tel": "string",
  "cashier_name": "string",
  "terminal_name": "string",
  "store_email": "string",
  "store_social": "string",
  "store_tin": "string",
  "store_accr": "string",
  "store_accr_valid": "string",
  "receipt_lines": [
    {
      "text": "string",
      "align": "string",
      "bold": "boolean",
      "size": "string"
    }
  ],
  "receipt_version": "string",
  "idempotency_key": "string",
  "created_at": "string",
  "updated_at": "string",
  "posted_at": "string",
  "is_deleted": "boolean",
  "version": "number",
  "void_reason": "string",
  "voided_at": "string"
}

Main Index

{
  "pk": "sales_invoice_number"
}

Raw Schema

{
  "table": "jef-caferimo-sales-invoices",
  "attributes": {
    "entity_number": "string",
    "sales_invoice_number": "string",
    "order_id": "string",
    "order_number": "string",
    "sales_date": "string",
    "sales_datetime": "string",
    "business_date": "string",
    "invoice_status": "string",
    "payment_status": "string",
    "order_lifecycle_status": "string",
    "items": [
      {
        "cartId": "string",
        "productId": "string",
        "name": "string",
        "size": {
          "label": "string",
          "upcharge": "number"
        },
        "milk": {
          "name": "string",
          "price": "number"
        },
        "addOns": [
          {
            "id": "string",
            "name": "string",
            "price": "number"
          }
        ],
        "note": "string",
        "basePrice": "number",
        "sizeUpcharge": "number",
        "milkUpcharge": "number",
        "addOnsTotal": "number",
        "unitPrice": "number",
        "quantity": "number",
        "line_total": "number"
      }
    ],
    "subtotal": "number",
    "vat_amount": "number",
    "discount_amount": "number",
    "final_total": "number",
    "payment_method": "string",
    "paid_amount": "number",
    "change_amount": "number",
    "gcash_reference": "string",
    "purchase_order_number": "string",
    "purchase_order_company": "string",
    "purchase_order_remarks": "string",
    "store_name_display": "string",
    "store_tagline": "string",
    "branch_name": "string",
    "store_address": "string",
    "store_city_tel": "string",
    "cashier_name": "string",
    "terminal_name": "string",
    "store_email": "string",
    "store_social": "string",
    "store_tin": "string",
    "store_accr": "string",
    "store_accr_valid": "string",
    "receipt_lines": [
      {
        "text": "string",
        "align": "string",
        "bold": "boolean",
        "size": "string"
      }
    ],
    "receipt_version": "string",
    "idempotency_key": "string",
    "created_at": "string",
    "updated_at": "string",
    "posted_at": "string",
    "is_deleted": "boolean",
    "version": "number",
    "void_reason": "string",
    "voided_at": "string"
  },
  "main_index": {
    "pk": "sales_invoice_number"
  },
  "gsi_1": {
    "gsi_1_pk": "entity_number",
    "gsi_1_sk": "sales_date"
  }
}