jef-caferimo-purchase-orders

Source

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

• Table: jef-caferimo-purchase-orders

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

• Commit: 68f1d63bb0c29ff458bdd0d7076dd6c31cee741c

• Generated at: 2026-04-27T14:07:43Z

Attributes

{
  "entity_number": "string",
  "purchase_order_number": "string",
  "order_number": "string",
  "purchase_order_date": "string",
  "purchase_order_datetime": "string",
  "business_date": "string",
  "purchase_order_status": "string",
  "owed_status": "string",
  "company_name": "string",
  "company_contact_person": "string",
  "company_contact_number": "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",
  "discount_amount": "number",
  "final_total": "number",
  "amount_owed": "number",
  "amount_settled": "number",
  "balance_amount": "number",
  "prepared_by": "string",
  "approved_by": "string",
  "branch_name": "string",
  "terminal_name": "string",
  "purchase_order_remarks": "string",
  "linked_sales_invoice_number": "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": "purchase_order_number"
}

Raw Schema

{
  "table": "jef-caferimo-purchase-orders",
  "attributes": {
    "entity_number": "string",
    "purchase_order_number": "string",
    "order_number": "string",
    "purchase_order_date": "string",
    "purchase_order_datetime": "string",
    "business_date": "string",
    "purchase_order_status": "string",
    "owed_status": "string",
    "company_name": "string",
    "company_contact_person": "string",
    "company_contact_number": "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",
    "discount_amount": "number",
    "final_total": "number",
    "amount_owed": "number",
    "amount_settled": "number",
    "balance_amount": "number",
    "prepared_by": "string",
    "approved_by": "string",
    "branch_name": "string",
    "terminal_name": "string",
    "purchase_order_remarks": "string",
    "linked_sales_invoice_number": "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": "purchase_order_number"
  },
  "gsi_1": {
    "gsi_1_pk": "entity_number",
    "gsi_1_sk": "purchase_order_date"
  }
}