jef-caferimo-sales-invoice-items

Source

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

  • Table: jef-caferimo-sales-invoice-items

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

  • Commit: f38252639861c015a1bc372c34c910ebb65db848

  • Generated at: 2026-05-03T15:52:25Z

Attributes

{
  "entity_number": "string",
  "sales_invoice_item_id": "string",
  "sales_invoice_number": "string",
  "order_id": "string",
  "order_number": "string",
  "business_date": "string",
  "line_number": "number",
  "product_number": "string",
  "product_name": "string",
  "recipe_number": "string",
  "recipe_name": "string",
  "category": "string",
  "family": "string",
  "quantity": "number",
  "size_label": "string",
  "milk_name": "string",
  "add_ons_text": "string",
  "vessel": "string",
  "note": "string",
  "base_price": "number",
  "size_upcharge": "number",
  "milk_upcharge": "number",
  "add_ons_total": "number",
  "unit_price": "number",
  "line_total": "number",
  "created_at": "string",
  "updated_at": "string",
  "is_active": "boolean",
  "is_deleted": "boolean",
  "deleted_at": "string",
  "schema_version": "number",
  "version": "number"
}

Main Index

{
  "pk": "sales_invoice_item_id"
}

Raw Schema

{
  "table": "jef-caferimo-sales-invoice-items",
  "attributes": {
    "entity_number": "string",
    "sales_invoice_item_id": "string",
    "sales_invoice_number": "string",
    "order_id": "string",
    "order_number": "string",
    "business_date": "string",
    "line_number": "number",
    "product_number": "string",
    "product_name": "string",
    "recipe_number": "string",
    "recipe_name": "string",
    "category": "string",
    "family": "string",
    "quantity": "number",
    "size_label": "string",
    "milk_name": "string",
    "add_ons_text": "string",
    "vessel": "string",
    "note": "string",
    "base_price": "number",
    "size_upcharge": "number",
    "milk_upcharge": "number",
    "add_ons_total": "number",
    "unit_price": "number",
    "line_total": "number",
    "created_at": "string",
    "updated_at": "string",
    "is_active": "boolean",
    "is_deleted": "boolean",
    "deleted_at": "string",
    "schema_version": "number",
    "version": "number"
  },
  "main_index": {
    "pk": "sales_invoice_item_id"
  },
  "gsi_1": {
    "gsi_1_pk": "sales_invoice_number",
    "gsi_1_sk": "line_number"
  }
}