import {
  createGetDB,
  type Generated,
  type Timestamp,
  type Serial,
  type NamespaceDB,
  type NamespaceInsertable,
  type NamespaceSelectable,
  type NamespaceTable,
  type NamespaceTableName,
  type NamespaceTransaction,
  type NamespaceUpdateable,
} from "@tailor-platform/sdk/kysely";

export interface Namespace {
  "main-db": {
    Account: {
      id: Generated<string>;
      code: string;
      name: string;
      accountType: "ASSET" | "LIABILITY" | "EQUITY" | "REVENUE" | "EXPENSE";
      companyId: string;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AccountPayableDistributionLine: {
      id: Generated<string>;
      accountPayableDocumentLineId: string;
      correctionOfDistributionLineId: string | null;
      accountId: string;
      amount: string;
      distributionType: "MANUAL" | "ACCRUAL" | "INVOICE_PRICE_VARIANCE";
      description: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AccountPayableDocument: {
      id: Generated<string>;
      companyId: string;
      supplierAccountId: string;
      currencyId: string;
      payableControlAccountId: string;
      documentType: "INVOICE" | "CREDIT_MEMO";
      correctionOfId: string | null;
      documentNumber: Serial<string>;
      externalDocumentNumber: string | null;
      documentDate: Timestamp;
      postingDate: Timestamp;
      totalAmount: string;
      description: string | null;
      status: "DRAFT" | "REGISTERED" | "CANCELLED" | "POSTED";
      registeredAt: Timestamp | null;
      postedAt: Timestamp | null;
      cancelledAt: Timestamp | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AccountPayableDocumentAttachment: {
      id: Generated<string>;
      accountPayableDocumentId: string;
      originalFileName: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AccountPayableDocumentHold: {
      id: Generated<string>;
      accountPayableDocumentId: string;
      accountPayableDocumentLineId: string | null;
      reasonCode: "INVOICE_UNIT_DIFFERS_FROM_PURCHASE_ORDER_UNIT" | "INVOICE_UNIT_PRICE_DIFFERS_FROM_PURCHASE_ORDER_UNIT_PRICE" | "INVOICE_QUANTITY_EXCEEDS_ORDERED_QUANTITY" | "INVOICE_QUANTITY_EXCEEDS_RECEIVED_QUANTITY";
      source: "SYSTEM" | "MANUAL";
      releasedAt: Timestamp | null;
      releaseReason: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AccountPayableDocumentLine: {
      id: Generated<string>;
      accountPayableDocumentId: string;
      netAmount: string;
      taxAmount: string | null;
      grossAmount: string;
      correctionOfLineId: string | null;
      correctionType: "PRICE" | "QUANTITY" | "AMOUNT" | null;
      quantity: string | null;
      unitPrice: string | null;
      matchedPurchaseOrderUnitPrice: string | null;
      unitId: string | null;
      description: string | null;
      sourceType: "PURCHASE_ORDER" | null;
      purchaseOrderLineId: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AccountPayableDueScheduleLine: {
      id: Generated<string>;
      accountPayableDocumentId: string;
      dueDate: Timestamp;
      amount: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AccountPayableSettlement: {
      id: Generated<string>;
      sourceType: "OUTGOING_PAYMENT";
      outgoingPaymentId: string;
      accountPayableDueScheduleLineId: string;
      settledAmount: string;
      reversalOfSettlementId: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AccountReceivableDistributionLine: {
      id: Generated<string>;
      accountReceivableDocumentLineId: string;
      correctionOfDistributionLineId: string | null;
      accountId: string;
      amount: string;
      description: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AccountReceivableDocument: {
      id: Generated<string>;
      companyId: string;
      customerAccountId: string;
      currencyId: string;
      receivableControlAccountId: string;
      documentType: "INVOICE" | "CREDIT_MEMO";
      correctionOfId: string | null;
      documentNumber: Serial<string>;
      externalDocumentNumber: string | null;
      documentDate: Timestamp;
      postingDate: Timestamp;
      totalAmount: string;
      description: string | null;
      status: "DRAFT" | "REGISTERED" | "POSTED" | "CANCELLED";
      registeredAt: Timestamp | null;
      postedAt: Timestamp | null;
      cancelledAt: Timestamp | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AccountReceivableDocumentLine: {
      id: Generated<string>;
      accountReceivableDocumentId: string;
      netAmount: string;
      taxAmount: string | null;
      grossAmount: string;
      correctionOfLineId: string | null;
      correctionType: "PRICE" | "QUANTITY" | "AMOUNT" | null;
      sourceType: "SALES_ORDER" | null;
      salesOrderLineId: string | null;
      quantity: string | null;
      unitPrice: string | null;
      unitId: string | null;
      description: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AccountReceivableDueScheduleLine: {
      id: Generated<string>;
      accountReceivableDocumentId: string;
      dueDate: Timestamp;
      amount: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AccountReceivableSettlement: {
      id: Generated<string>;
      sourceType: "INCOMING_PAYMENT";
      incomingPaymentId: string;
      accountReceivableDueScheduleLineId: string;
      settledAmount: string;
      reversalOfSettlementId: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AccountingPeriod: {
      id: Generated<string>;
      companyId: string;
      fiscalYearId: string;
      name: string;
      startDate: Timestamp;
      endDate: Timestamp;
      periodType: "OPERATING" | "ADJUSTMENT";
      status: "NEVER_OPENED" | "OPEN" | "CLOSED" | "PERMANENTLY_CLOSED";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AcquisitionCostAdjustment: {
      id: Generated<string>;
      sourceType: "ACCOUNT_PAYABLE_DOCUMENT" | "PURCHASE_ORDER_REVISION" | "INVENTORY_LEDGER";
      sourceId: string;
      sourceLineId: string | null;
      purchaseOrderId: string;
      purchaseOrderLineId: string;
      amount: string;
      kind: "INVOICE_PRICE" | "ORDER_PRICE" | "REDISTRIBUTION";
      effectiveDate: Timestamp;
      createdAt: Generated<Timestamp>;
    }

    AcquisitionCostAdjustmentAllocation: {
      id: Generated<string>;
      acquisitionCostAdjustmentId: string;
      costLayerId: string;
      amount: string;
      varianceKind: "INVOICE_PRICE" | "ORDER_PRICE";
      createdAt: Generated<Timestamp>;
    }

    AverageCost: {
      id: Generated<string>;
      itemId: string;
      companyId: string;
      sequence: number;
      eventType: "RECEIPT" | "ISSUE" | "COST_ADJUSTMENT";
      quantityBefore: string;
      unitCostBefore: string;
      quantity: string;
      unitCost: string | null;
      quantityAfter: string;
      unitCostAfter: string;
      createdAt: Generated<Timestamp>;
    }

    BusinessPartner: {
      id: Generated<string>;
      name: string;
      type: "ORGANIZATION" | "INDIVIDUAL";
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    Company: {
      id: Generated<string>;
      legalName: string;
      taxId: string | null;
      registrationNumber: string | null;
      baseCurrencyId: string | null;
      street: string | null;
      city: string | null;
      state: string | null;
      postalCode: string | null;
      country: string | null;
      status: "DRAFT" | "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    CostLayer: {
      id: Generated<string>;
      itemId: string;
      companyId: string;
      ledgerEntryId: string;
      effectiveDate: Timestamp;
      quantity: string;
      remainingQuantity: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    CostLayerConsumption: {
      id: Generated<string>;
      costLayerId: string;
      ledgerEntryId: string;
      quantity: string;
      createdAt: Generated<Timestamp>;
    }

    Currency: {
      id: Generated<string>;
      code: string;
      name: string;
      symbol: string;
      decimalPlaces: number;
      isBaseCurrency: boolean;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    CustomerAccount: {
      id: Generated<string>;
      partnerId: string;
      companyId: string;
      code: string;
      name: string;
      preferredCurrencyId: string | null;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    CustomerAddressUsage: {
      id: Generated<string>;
      accountId: string;
      addressId: string;
      purpose: "BILL_TO" | "SHIP_TO";
      isDefault: boolean;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    CustomerBankAccountUsage: {
      id: Generated<string>;
      accountId: string;
      bankAccountId: string;
      purpose: "RECEIPT" | "REFUND";
      isDefault: boolean;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    Department: {
      id: Generated<string>;
      code: string;
      name: string;
      companyId: string;
      parentDepartmentId: string | null;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    ExchangeRate: {
      id: Generated<string>;
      sourceCurrencyId: string;
      targetCurrencyId: string;
      rate: number;
      effectiveDate: Timestamp;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    FifoCost: {
      id: Generated<string>;
      costLayerId: string;
      version: number;
      unitCost: string;
      createdAt: Generated<Timestamp>;
    }

    FiscalYear: {
      id: Generated<string>;
      companyId: string;
      name: string;
      startDate: Timestamp;
      endDate: Timestamp;
      yearEndCloseExecuted: boolean;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    InboundShipment: {
      id: Generated<string>;
      status: "DRAFT" | "CANCELLED" | "POSTED";
      effectiveDate: Timestamp;
      postedAt: Timestamp | null;
      docNumber: Serial<string>;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    InboundShipmentLine: {
      id: Generated<string>;
      inboundShipmentId: string;
      itemId: string;
      quantity: string;
      unitId: string;
      primaryQuantity: string;
      primaryUnitId: string;
      unitConversionRate: string;
      unitCost: string | null;
      storageLocationId: string;
      stockType: "AVAILABLE" | "BLOCKED" | "IN_TRANSIT";
      sourceDocumentType: "PURCHASE_ORDER";
      sourceDocumentId: string;
      sourceLineId: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    IncomingPayment: {
      id: Generated<string>;
      companyId: string;
      customerAccountId: string;
      currencyId: string;
      paymentAccountId: string;
      paymentDate: Timestamp;
      totalAmount: string;
      status: "DRAFT" | "POSTED" | "CANCELLED" | "REVERSED";
      postedAt: Timestamp | null;
      reversalDate: Timestamp | null;
      reversedAt: Timestamp | null;
      cancelledAt: Timestamp | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    InventoryLedger: {
      id: Generated<string>;
      sourceType: "INBOUND_SHIPMENT" | "OUTBOUND_SHIPMENT" | "TRANSFER_ORDER" | "STOCK_ADJUSTMENT";
      sourceId: string;
      sourceLineId: string | null;
      orderDocumentType: "PURCHASE_ORDER" | "SALES_ORDER" | "TRANSFER_ORDER" | null;
      orderDocumentId: string | null;
      orderDocumentLineId: string | null;
      direction: "IN" | "OUT";
      action: "QUANTITY_CHANGE" | "TRANSFER" | "STOCK_TYPE_CHANGE";
      itemId: string;
      storageLocationId: string;
      stockType: "AVAILABLE" | "BLOCKED" | "IN_TRANSIT";
      quantity: string;
      executedAt: Timestamp;
      effectiveDate: Timestamp;
      createdAt: Generated<Timestamp>;
    }

    InventorySupplyPlan: {
      id: Generated<string>;
      sourceType: "PURCHASE_ORDER" | "TRANSFER_ORDER";
      sourceId: string;
      sourceLineId: string;
      itemId: string;
      siteId: string;
      expectedQuantity: string;
      receivedQuantity: string;
      status: "OPEN" | "CLOSED";
      expectedDate: Timestamp;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    InvoiceToleranceConfig: {
      id: Generated<string>;
      companyId: string;
      supplierAccountId: string;
      quantityAbsoluteTolerance: string | null;
      quantityPercentageTolerance: string | null;
      unitPriceAbsoluteTolerance: string | null;
      unitPricePercentageTolerance: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    Item: {
      id: Generated<string>;
      sku: string;
      name: string;
      barcode: string | null;
      unitId: string;
      status: "DRAFT" | "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    ItemTaxonomyAssignment: {
      id: Generated<string>;
      itemId: string;
      taxonomyNodeId: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    ItemValuation: {
      id: Generated<string>;
      itemId: string;
      companyId: string;
      valuationPolicyId: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    JournalEntry: {
      id: Generated<string>;
      companyId: string;
      accountingPeriodId: string;
      entryDate: Timestamp;
      status: "DRAFT" | "CANCELLED" | "POSTED";
      description: string | null;
      sourceDocumentType: "ACCOUNT_PAYABLE_DOCUMENT" | "OUTGOING_PAYMENT" | "INCOMING_PAYMENT" | "BANK_RECONCILIATION" | "SALES_INVOICE" | "INVENTORY_LEDGER" | "STANDARD_COST_REVISION" | "ACQUISITION_COST_ADJUSTMENT" | "PRODUCTION_ORDER" | "YEAR_END_CLOSE" | null;
      sourceDocumentId: string | null;
      reversalOfId: string | null;
      postedAt: Timestamp | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    JournalLine: {
      id: Generated<string>;
      journalEntryId: string;
      accountId: string;
      debitAmount: string | null;
      creditAmount: string | null;
      description: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    OutboundShipment: {
      id: Generated<string>;
      status: "DRAFT" | "CANCELLED" | "POSTED";
      effectiveDate: Timestamp;
      postedAt: Timestamp | null;
      docNumber: Serial<string>;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    OutboundShipmentLine: {
      id: Generated<string>;
      outboundShipmentId: string;
      itemId: string;
      quantity: string;
      unitId: string;
      primaryQuantity: string;
      primaryUnitId: string;
      unitConversionRate: string;
      storageLocationId: string;
      stockType: "AVAILABLE" | "BLOCKED" | "IN_TRANSIT";
      sourceDocumentType: "SALES_ORDER";
      sourceDocumentId: string;
      sourceLineId: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    OutgoingPayment: {
      id: Generated<string>;
      companyId: string;
      supplierAccountId: string;
      currencyId: string;
      paymentAccountId: string;
      paymentDate: Timestamp;
      totalAmount: string;
      status: "DRAFT" | "POSTED" | "CANCELLED" | "REVERSED";
      postedAt: Timestamp | null;
      reversalDate: Timestamp | null;
      reversedAt: Timestamp | null;
      cancelledAt: Timestamp | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    PartnerAddress: {
      id: Generated<string>;
      partnerId: string;
      active: boolean;
      line1: string;
      line2: string | null;
      city: string;
      state: string | null;
      postalCode: string;
      country: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    PartnerBankAccount: {
      id: Generated<string>;
      partnerId: string;
      active: boolean;
      bankName: string;
      accountHolderName: string;
      accountNumber: string;
      routingNumber: string | null;
      currencyId: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    Product: {
      id: Generated<string>;
      code: string;
      name: string;
      description: string | null;
      unitId: string;
      status: "DRAFT" | "ACTIVE" | "ARCHIVED";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    ProductAttribute: {
      id: Generated<string>;
      code: string;
      name: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    ProductAttributeAssignment: {
      id: Generated<string>;
      productId: string;
      attributeId: string;
      valueId: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    ProductAttributeValue: {
      id: Generated<string>;
      attributeId: string;
      label: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    ProductCategory: {
      id: Generated<string>;
      code: string;
      name: string;
      parentId: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    ProductCategoryAssignment: {
      id: Generated<string>;
      productId: string;
      categoryId: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    ProductVariant: {
      id: Generated<string>;
      productId: string;
      axisValueKey: string;
      itemId: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    PurchaseItem: {
      id: Generated<string>;
      itemId: string;
      requiresPhysicalReceipt: boolean;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    PurchaseOrder: {
      id: Generated<string>;
      companyId: string;
      supplierAccountId: string;
      currencyId: string;
      receivingSiteId: string | null;
      orderStatus: "DRAFT" | "SUBMITTED" | "ORDERED" | "CANCELLED" | "CLOSED";
      receiptStatus: "NOT_RECEIVED" | "PARTIALLY_RECEIVED" | "RECEIVED" | null;
      billingStatus: "NOT_BILLED" | "PARTIALLY_BILLED" | "BILLED" | null;
      orderDate: Timestamp;
      externalSupplierOrderReference: string | null;
      supplierSnapshotName: string | null;
      rejectionReason: string | null;
      closeReason: string | null;
      docNumber: Serial<string>;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    PurchaseOrderFieldChange: {
      id: Generated<string>;
      revisionId: string;
      recordType: "HEADER" | "LINE";
      recordId: string;
      fieldName: string;
      changeKind: "ADDED" | "MODIFIED" | "REMOVED";
      oldValue: string | null;
      newValue: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    PurchaseOrderLine: {
      id: Generated<string>;
      purchaseOrderId: string;
      itemId: string;
      itemSnapshotName: string | null;
      itemSnapshotSku: string | null;
      quantity: string;
      unitPrice: string;
      unitId: string;
      receivingSiteId: string | null;
      requiresPhysicalReceipt: boolean;
      billedQuantity: Generated<string>;
      receivedQuantity: Generated<string>;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    PurchaseOrderRevision: {
      id: Generated<string>;
      purchaseOrderId: string;
      revisionNumber: number;
      reason: string | null;
      amendedByUserId: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    Role: {
      id: Generated<string>;
      name: string;
      description: string | null;
      status: "ACTIVE" | "INACTIVE";
      permissions: string[] | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    SalesItem: {
      id: Generated<string>;
      itemId: string;
      requiresPhysicalFulfillment: boolean;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    SalesOrder: {
      id: Generated<string>;
      companyId: string;
      customerAccountId: string;
      currencyId: string;
      orderStatus: "DRAFT" | "SUBMITTED" | "CONFIRMED" | "CANCELLED" | "CLOSED";
      fulfillmentStatus: "NOT_FULFILLED" | "PARTIALLY_FULFILLED" | "FULFILLED" | null;
      billingStatus: "NOT_BILLED" | "PARTIALLY_BILLED" | "BILLED" | null;
      orderDate: Timestamp;
      shippingAddress: string | null;
      billingAddress: string | null;
      rejectionReason: string | null;
      closeReason: string | null;
      docNumber: Serial<string>;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    SalesOrderFieldChange: {
      id: Generated<string>;
      revisionId: string;
      recordType: "HEADER" | "LINE";
      recordId: string;
      fieldName: string;
      changeKind: "ADDED" | "MODIFIED" | "REMOVED";
      oldValue: string | null;
      newValue: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    SalesOrderLine: {
      id: Generated<string>;
      salesOrderId: string;
      itemId: string;
      description: string | null;
      quantity: string;
      unitPrice: string;
      unitId: string | null;
      requiresPhysicalFulfillment: boolean;
      fulfilledQuantity: Generated<string>;
      billedQuantity: Generated<string>;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    SalesOrderRevision: {
      id: Generated<string>;
      salesOrderId: string;
      revisionNumber: number;
      reason: string | null;
      amendedByUserId: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    Site: {
      id: Generated<string>;
      name: string;
      type: string;
      companyId: string;
      street: string;
      city: string;
      state: string | null;
      postalCode: string;
      country: string;
      timezone: string;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    StandardCost: {
      id: Generated<string>;
      itemId: string;
      version: number;
      unitCost: string;
      createdAt: Generated<Timestamp>;
    }

    StockAdjustment: {
      id: Generated<string>;
      adjustmentType: "CORRECTION" | "SCRAP" | "BLOCK" | "UNBLOCK";
      status: "DRAFT" | "SUBMITTED" | "CANCELLED" | "CONFIRMED" | "REJECTED";
      reasonCode: string;
      adjustmentDate: Timestamp;
      rejectionReason: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    StockAdjustmentLine: {
      id: Generated<string>;
      stockAdjustmentId: string;
      itemId: string;
      storageLocationId: string;
      quantity: string;
      adjustmentDirection: "INCREASE" | "DECREASE" | null;
      fromStockCategory: "AVAILABLE" | "BLOCKED" | null;
      unitCost: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    StockLevel: {
      id: Generated<string>;
      itemId: string;
      storageLocationId: string;
      stockType: "AVAILABLE" | "BLOCKED" | "IN_TRANSIT";
      quantity: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    StockReservation: {
      id: Generated<string>;
      sourceType: "SALES_ORDER" | "TRANSFER_ORDER";
      sourceId: string;
      sourceLineId: string;
      itemId: string;
      siteId: string;
      storageLocationId: string | null;
      reservedQuantity: string;
      consumedQuantity: string;
      status: "OPEN" | "CLOSED";
      requiredDate: Timestamp;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    StorageLocation: {
      id: Generated<string>;
      name: string;
      code: string | null;
      siteId: string;
      storageCondition: string | null;
      capacity: string | null;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    SupplierAccount: {
      id: Generated<string>;
      partnerId: string;
      companyId: string;
      code: string;
      name: string;
      preferredCurrencyId: string | null;
      defaultExpenseAccountId: string | null;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    SupplierAddressUsage: {
      id: Generated<string>;
      accountId: string;
      addressId: string;
      purpose: "ORDER_FROM" | "REMIT_TO" | "SHIP_FROM" | "RETURN_TO";
      isDefault: boolean;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    SupplierBankAccountUsage: {
      id: Generated<string>;
      accountId: string;
      bankAccountId: string;
      purpose: "PAYMENT" | "REFUND";
      isDefault: boolean;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    TaxonomyNode: {
      id: Generated<string>;
      code: string;
      name: string;
      parentId: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    TransferOrder: {
      id: Generated<string>;
      sourceSiteId: string;
      destinationSiteId: string;
      plannedShipmentDate: Timestamp;
      expectedReceiptDate: Timestamp;
      status: "DRAFT" | "OPEN" | "CLOSED";
      closedAt: Timestamp | null;
      docNumber: Serial<string>;
      notes: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    TransferOrderLine: {
      id: Generated<string>;
      transferOrderId: string;
      itemId: string;
      unitId: string;
      orderedQuantity: string;
      shippedQuantity: string;
      receivedQuantity: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    Unit: {
      id: Generated<string>;
      name: string;
      symbol: string;
      categoryId: string;
      conversionFactor: number;
      roundingPrecision: number;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    UoMCategory: {
      id: Generated<string>;
      name: string;
      description: string | null;
      referenceUnitId: string | null;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    User: {
      id: Generated<string>;
      email: string;
      name: string;
      status: "PENDING" | "ACTIVE" | "INACTIVE";
      permissions: string[] | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    UserRole: {
      id: Generated<string>;
      userId: string;
      roleId: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    ValuationPolicy: {
      id: Generated<string>;
      name: string;
      companyId: string;
      costingMethod: "STANDARD" | "FIFO" | "AVERAGE";
      defaultCompanyId: string | null;
      inventoryAccountId: string;
      accrualAccountId: string;
      invoicePriceVarianceAccountId: string;
      cogsAccountId: string;
      ppvAccountId: string;
      adjustmentAccountId: string;
      standardCostAdjustmentAccountId: string;
      consumedPriceVarianceAccountId: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }
  }
}

export const getDB = createGetDB<Namespace>();

export type DB<N extends keyof Namespace = keyof Namespace> = NamespaceDB<Namespace, N>;

export type Transaction<K extends keyof Namespace | DB = keyof Namespace> =
  NamespaceTransaction<Namespace, K>;

type TableName = NamespaceTableName<Namespace>;
export type Table<T extends TableName> = NamespaceTable<Namespace, T>;

export type Insertable<T extends TableName> = NamespaceInsertable<Namespace, T>;
export type Selectable<T extends TableName> = NamespaceSelectable<Namespace, T>;
export type Updateable<T extends TableName> = NamespaceUpdateable<Namespace, T>;