jef-fuel-pump-inventories-sales-invoices

Source

• Repository: jef-systems/jef-fuel-pump-inventories-backend

• Table: jef-fuel-pump-inventories-sales-invoices

• Schema path: dynamodb/jef-fuel-pump-inventories-sales-invoices/schema.json

• Commit: 362423d6643b4c56bde9582b7285270d5f4fa789

• Generated at: 2026-04-10T19:31:25Z

Attributes

{
  "pk": "string-salesInvoiceId",
  "sk": "string-YYYY-MM-DD",
  "salesInvoiceId": "string",
  "salesInvoiceNumber": "string",
  "invoiceDate": "string-YYYY-MM-DD",
  "issuedAt": "string-ISO8601",
  "issuedBy": "string-employeeId",
  "issuedByNameSnapshot": "string",
  "customerId": "string-optional",
  "customerNameSnapshot": "string",
  "customerTinSnapshot": "string-optional",
  "currency": "string-enum-PHP-USD",
  "status": "string-enum-draft-posted-paid-cancelled",
  "paymentTerms": "string-enum-cash-net15-net30-optional",
  "dueDate": "string-YYYY-MM-DD-optional",
  "paidAt": "string-ISO8601-optional",
  "paymentMethod": "string-enum-cash-gcash-bank_transfer-optional",
  "lineItems": "array-document_line_items",
  "totals": "object-document_totals",
  "notes": "string-optional",
  "referenceDocumentType": "string-optional",
  "referenceDocumentId": "string-optional",
  "createdAt": "string-ISO8601",
  "updatedAt": "string-ISO8601",
  "gsi_1_pk": "string-YYYY-MM",
  "gsi_1_sk": "string-date#salesInvoiceNumber",
  "gsi_2_pk": "string-enum-draft-posted-paid-cancelled",
  "gsi_2_sk": "string-date#salesInvoiceNumber",
  "gsi_3_pk": "string-customerIdOrName",
  "gsi_3_sk": "string-date#salesInvoiceNumber",
  "gsi_4_pk": "string-referenceDocumentId",
  "gsi_4_sk": "string-date#salesInvoiceNumber"
}

Main Index

{
  "pk": "pk",
  "sk": "sk"
}

Raw Schema

{
  "table": "jef-fuel-pump-inventories-sales-invoices",
  "attributes": {
    "pk": "string-salesInvoiceId",
    "sk": "string-YYYY-MM-DD",
    "salesInvoiceId": "string",
    "salesInvoiceNumber": "string",
    "invoiceDate": "string-YYYY-MM-DD",
    "issuedAt": "string-ISO8601",
    "issuedBy": "string-employeeId",
    "issuedByNameSnapshot": "string",
    "customerId": "string-optional",
    "customerNameSnapshot": "string",
    "customerTinSnapshot": "string-optional",
    "currency": "string-enum-PHP-USD",
    "status": "string-enum-draft-posted-paid-cancelled",
    "paymentTerms": "string-enum-cash-net15-net30-optional",
    "dueDate": "string-YYYY-MM-DD-optional",
    "paidAt": "string-ISO8601-optional",
    "paymentMethod": "string-enum-cash-gcash-bank_transfer-optional",
    "lineItems": "array-document_line_items",
    "totals": "object-document_totals",
    "notes": "string-optional",
    "referenceDocumentType": "string-optional",
    "referenceDocumentId": "string-optional",
    "createdAt": "string-ISO8601",
    "updatedAt": "string-ISO8601",
    "gsi_1_pk": "string-YYYY-MM",
    "gsi_1_sk": "string-date#salesInvoiceNumber",
    "gsi_2_pk": "string-enum-draft-posted-paid-cancelled",
    "gsi_2_sk": "string-date#salesInvoiceNumber",
    "gsi_3_pk": "string-customerIdOrName",
    "gsi_3_sk": "string-date#salesInvoiceNumber",
    "gsi_4_pk": "string-referenceDocumentId",
    "gsi_4_sk": "string-date#salesInvoiceNumber"
  },
  "main_index": {
    "pk": "pk",
    "sk": "sk"
  },
  "gsi_1": {
    "pk": "gsi_1_pk",
    "sk": "gsi_1_sk"
  },
  "gsi_2": {
    "pk": "gsi_2_pk",
    "sk": "gsi_2_sk"
  },
  "gsi_3": {
    "pk": "gsi_3_pk",
    "sk": "gsi_3_sk"
  },
  "gsi_4": {
    "pk": "gsi_4_pk",
    "sk": "gsi_4_sk"
  }
}