jef-fuel-pump-inventories-purchase-orders

Source

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

• Table: jef-fuel-pump-inventories-purchase-orders

• Schema path: dynamodb/jef-fuel-pump-inventories-purchase-orders/schema.json

• Commit: 362423d6643b4c56bde9582b7285270d5f4fa789

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

Attributes

{
  "pk": "string-purchaseOrderId",
  "sk": "string-YYYY-MM-DD",
  "purchaseOrderId": "string",
  "purchaseOrderNumber": "string",
  "orderDate": "string-YYYY-MM-DD",
  "orderedAt": "string-ISO8601",
  "expectedDeliveryDate": "string-YYYY-MM-DD-optional",
  "approvedBy": "string-employeeId-optional",
  "approvedByNameSnapshot": "string-optional",
  "approvedAt": "string-ISO8601-optional",
  "receivedBy": "string-employeeId-optional",
  "receivedByNameSnapshot": "string-optional",
  "receivedAt": "string-ISO8601-optional",
  "supplierId": "string-optional",
  "supplierNameSnapshot": "string",
  "supplierTinSnapshot": "string-optional",
  "currency": "string-enum-PHP-USD",
  "status": "string-enum-draft-approved-partially_received-received-cancelled",
  "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#purchaseOrderNumber",
  "gsi_2_pk": "string-enum-draft-approved-partially_received-received-cancelled",
  "gsi_2_sk": "string-date#purchaseOrderNumber",
  "gsi_3_pk": "string-supplierIdOrName",
  "gsi_3_sk": "string-date#purchaseOrderNumber"
}

Main Index

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

Raw Schema

{
  "table": "jef-fuel-pump-inventories-purchase-orders",
  "attributes": {
    "pk": "string-purchaseOrderId",
    "sk": "string-YYYY-MM-DD",
    "purchaseOrderId": "string",
    "purchaseOrderNumber": "string",
    "orderDate": "string-YYYY-MM-DD",
    "orderedAt": "string-ISO8601",
    "expectedDeliveryDate": "string-YYYY-MM-DD-optional",
    "approvedBy": "string-employeeId-optional",
    "approvedByNameSnapshot": "string-optional",
    "approvedAt": "string-ISO8601-optional",
    "receivedBy": "string-employeeId-optional",
    "receivedByNameSnapshot": "string-optional",
    "receivedAt": "string-ISO8601-optional",
    "supplierId": "string-optional",
    "supplierNameSnapshot": "string",
    "supplierTinSnapshot": "string-optional",
    "currency": "string-enum-PHP-USD",
    "status": "string-enum-draft-approved-partially_received-received-cancelled",
    "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#purchaseOrderNumber",
    "gsi_2_pk": "string-enum-draft-approved-partially_received-received-cancelled",
    "gsi_2_sk": "string-date#purchaseOrderNumber",
    "gsi_3_pk": "string-supplierIdOrName",
    "gsi_3_sk": "string-date#purchaseOrderNumber"
  },
  "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"
  }
}