Skip to content

Open-source manufacturing ERP, MES and QMS. Quoting, MRP, inventory, shop floor, quality and lot/serial traceability on one Postgres schema, with a REST API and MCP server. Self-host or use Carbon Cloud.

64.0 KB
Raw Blame
// SPDX-License-Identifier: AGPL-3.0-only
// Carbon (github.com/crbnos/carbon). Modified or adapted versions of this file,
// including ports, remain AGPLv3; serving them over a network requires releasing their source.

/**
 * Shared seed data for company initialization, used by the seed-company server
 * function and the dataset tooling.
 *
 * This is the single source of truth for all seed data.
 */

export const dimensions = [
  { name: "Location", entityType: "Location" },
  { name: "Department", entityType: "Department" },
  { name: "Employee", entityType: "Employee" },
  { name: "Cost Center", entityType: "CostCenter" },
  { name: "Item Posting Group", entityType: "ItemPostingGroup" },
  { name: "Customer Type", entityType: "CustomerType" },
  { name: "Supplier Type", entityType: "SupplierType" },
  { name: "Work Center", entityType: "WorkCenter" },
  { name: "Process", entityType: "Process" },
  { name: "Asset Class", entityType: "FixedAssetClass" },
  { name: "Customer", entityType: "Customer" },
  { name: "Supplier", entityType: "Supplier" },
  { name: "Item", entityType: "Item" },
  { name: "Scrap Reason", entityType: "ScrapReason" },
  { name: "Project", entityType: "Project" }
] as const;

export const supplierStatuses = [
  "Active",
  "Inactive",
  "Pending",
  "Rejected"
] as const;

export const customerStatuses = [
  "Active",
  "Inactive",
  "Lead",
  "On Hold",
  "Cancelled"
] as const;

export const scrapReasons = ["Defective", "Damaged", "Quality"] as const;

export const returnReasons = [
  "Defective",
  "Wrong Item Shipped",
  "Damaged in Transit",
  "No Longer Needed",
  "Warranty",
  "Other"
] as const;

export const paymentTerms = [
  {
    name: "Net 15",
    daysDue: 15,
    calculationMethod: "Net",
    daysDiscount: 0,
    discountPercentage: 0,
    createdBy: "system"
  },
  {
    name: "Net 30",
    daysDue: 30,
    calculationMethod: "Net",
    daysDiscount: 0,
    discountPercentage: 0,
    createdBy: "system"
  },
  {
    name: "Net 60",
    daysDue: 60,
    calculationMethod: "Net",
    daysDiscount: 0,
    discountPercentage: 0,
    createdBy: "system"
  },
  {
    name: "1% 10 Net 30",
    daysDue: 30,
    calculationMethod: "Net",
    daysDiscount: 10,
    discountPercentage: 1,
    createdBy: "system"
  },
  {
    name: "2% 10 Net 30",
    daysDue: 30,
    calculationMethod: "Net",
    daysDiscount: 10,
    discountPercentage: 2,
    createdBy: "system"
  },
  {
    name: "COD",
    daysDue: 0,
    calculationMethod: "Net",
    daysDiscount: 0,
    discountPercentage: 0,
    createdBy: "system"
  },
  {
    name: "Prepaid/ Pro forma",
    daysDue: 0,
    calculationMethod: "Net",
    daysDiscount: 0,
    discountPercentage: 0,
    createdBy: "system"
  },
  {
    name: "Net EOM 10th",
    daysDue: 10,
    calculationMethod: "End of Month",
    daysDiscount: 0,
    discountPercentage: 0,
    createdBy: "system"
  }
] as const;

export const unitOfMeasures = [
  { name: "Each", code: "EA", createdBy: "system" },
  { name: "Case", code: "CS", createdBy: "system" },
  { name: "Pack", code: "PK", createdBy: "system" },
  { name: "Pallet", code: "PL", createdBy: "system" },
  { name: "Roll", code: "RL", createdBy: "system" },
  { name: "Box", code: "BX", createdBy: "system" },
  { name: "Bag", code: "BG", createdBy: "system" },
  { name: "Drum", code: "DR", createdBy: "system" },
  { name: "Gallon", code: "GL", createdBy: "system" },
  { name: "Liter", code: "LT", createdBy: "system" },
  { name: "Ounce", code: "OZ", createdBy: "system" },
  { name: "Pound", code: "LB", createdBy: "system" },
  { name: "Ton", code: "TN", createdBy: "system" },
  { name: "Yard", code: "YD", createdBy: "system" },
  { name: "Meter", code: "MT", createdBy: "system" },
  { name: "Inch", code: "INCH", createdBy: "system" },
  { name: "Foot", code: "FOOT", createdBy: "system" }
] as const;

export const gaugeTypes = [
  "Gauge Block",
  "Caliper - Inside",
  "Caliper - Outside",
  "Caliper - Depth",
  "Micrometer - Outside",
  "Micrometer - Inside",
  "Micrometer - Depth",
  "Dial Indicator",
  "Height Gauge",
  "Thread Gauge",
  "Pin Gauge",
  "Ring Gauge",
  "Plug Gauge",
  "Bore Gauge",
  "Feeler Gauge",
  "Surface Plate",
  "Go/No-Go Gauge",
  "Profile Gauge",
  "Coordinate Measuring Machine (CMM)",
  "Optical Comparator"
] as const;

export const failureModes = [
  "Bearing Failure",
  "Lubrication Failure",
  "Electrical Fault",
  "Leak",
  "Excessive Wear",
  "Misalignment",
  "Overheating",
  "Cracking/Fatigue",
  "Blockage",
  "Excessive Vibration"
] as const;

export const nonConformanceTypes = [
  { name: "Design Error", createdBy: "system" },
  { name: "Manufacturing Defect", createdBy: "system" },
  { name: "Process Deviation", createdBy: "system" },
  { name: "Material Issue", createdBy: "system" },
  { name: "Testing Failure", createdBy: "system" },
  { name: "Documentation Error", createdBy: "system" },
  { name: "Training Issue", createdBy: "system" },
  { name: "Equipment Malfunction", createdBy: "system" },
  { name: "Supplier Issue", createdBy: "system" },
  { name: "Customer Complaint", createdBy: "system" }
] as const;

// Change Order types (the changeOrderType lookup). Kept in sync with the
// one-time seed in the change-orders migration so new companies get the same
// default types the migration gave existing ones.
export const changeOrderTypes = [
  { name: "Design Improvement", createdBy: "system" },
  { name: "Cost Reduction", createdBy: "system" },
  { name: "Quality / Reliability Improvement", createdBy: "system" },
  { name: "Supplier / Sourcing Change", createdBy: "system" },
  { name: "Material or Component Change", createdBy: "system" },
  { name: "Obsolescence / End-of-Life", createdBy: "system" },
  { name: "Regulatory / Compliance", createdBy: "system" },
  { name: "Safety", createdBy: "system" },
  { name: "Manufacturing / Producibility", createdBy: "system" },
  { name: "Customer Request", createdBy: "system" },
  { name: "Documentation Error / Correction", createdBy: "system" }
] as const;

export const nonConformanceRequiredActions = [
  {
    name: "Corrective Action",
    systemType: "Corrective" as const,
    createdBy: "system"
  },
  {
    name: "Preventive Action",
    systemType: "Preventive" as const,
    createdBy: "system"
  },
  {
    name: "Containment Action",
    systemType: "Containment" as const,
    createdBy: "system"
  },
  {
    name: "Verification",
    systemType: "Verification" as const,
    createdBy: "system"
  },
  {
    name: "Customer Communication",
    systemType: "Communication" as const,
    createdBy: "system"
  },
  { name: "Root Cause Analysis", createdBy: "system" },
  { name: "Inventory", createdBy: "system" },
  { name: "WIP", createdBy: "system" },
  { name: "Finished Goods", createdBy: "system" },
  { name: "Incoming Materials", createdBy: "system" },
  { name: "Process", createdBy: "system" },
  { name: "Documentation", createdBy: "system" }
] as const;

// Default change-order actions (the changeOrderRequiredAction templates). Kept in
// sync with the one-time backfill in the change-order-required-actions migration so
// new companies get the same defaults existing ones were backfilled with.
export const changeOrderRequiredActions = [
  { name: "Engineering Review", createdBy: "system" },
  { name: "Update Drawings / CAD", createdBy: "system" },
  { name: "Update BOM / Routing", createdBy: "system" },
  { name: "Cost Impact Review", createdBy: "system" },
  { name: "Quality Review", createdBy: "system" },
  {
    name: "Inventory Disposition (rework / scrap / use-as-is)",
    createdBy: "system"
  },
  { name: "Notify Affected Parties", createdBy: "system" }
] as const;

export const sequences = [
  {
    table: "journalEntry",
    name: "Journal Entry",
    prefix: "JE-%{yyyy}-%{mm}-",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "job",
    name: "Job",
    prefix: "J",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "jobOperationBatch",
    name: "Operation Batch",
    prefix: "BAT",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "gauge",
    name: "Gauge",
    prefix: "G",
    suffix: null,
    next: 0,
    size: 5,
    step: 1
  },
  {
    // Existing companies keep their re-keyed II sequence (20260722132135);
    // only new companies seed the INS prefix.
    table: "inspection",
    name: "Inspection",
    prefix: "INS",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "inventoryCount",
    name: "Inventory Count",
    prefix: "IC",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "maintenanceDispatch",
    name: "Maintenance Dispatch",
    prefix: "MAIN",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "nonConformance",
    name: "Issue",
    prefix: "NCR",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "changeOrder",
    name: "Change Notice",
    prefix: "CN-",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "purchaseOrder",
    name: "Purchase Order",
    prefix: "PO",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "purchaseInvoice",
    name: "Purchase Invoice",
    prefix: "AP",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "purchasingRfq",
    name: "Purchasing RFQ",
    prefix: "PRFQ",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "receipt",
    name: "Receipt",
    prefix: "RE",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "salesRfq",
    name: "RFQ (Sales)",
    prefix: "RFQ",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "salesOrder",
    name: "Sales Order",
    prefix: "SO",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "salesReturnOrder",
    name: "Sales Return Order",
    prefix: "RMA",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "purchaseReturnOrder",
    name: "Purchase Return Order",
    prefix: "RTS",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "salesInvoice",
    name: "Sales Invoice",
    prefix: "AR",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "stockTransfer",
    name: "Stock Transfer",
    prefix: "ST",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "kanban",
    name: "Kanban",
    prefix: "KB",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "quote",
    name: "Quote",
    prefix: "Q",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "supplierQuote",
    name: "Supplier Quote",
    prefix: "SQ",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "shipment",
    name: "Shipment",
    prefix: "SHP",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "warehouseTransfer",
    name: "Warehouse Transfer",
    prefix: "WT",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "supplier",
    name: "Supplier",
    prefix: "SUP",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "customer",
    name: "Customer",
    prefix: "CUS",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "fixedAsset",
    name: "Fixed Asset",
    prefix: "FA",
    suffix: null,
    next: 1,
    size: 6,
    step: 1
  },
  {
    table: "depreciationRun",
    name: "Depreciation Run",
    prefix: "DR",
    suffix: null,
    next: 1,
    size: 6,
    step: 1
  },
  {
    table: "pickingList",
    name: "Picking List",
    prefix: "PL",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "payment",
    name: "Payment",
    prefix: "PAY-%{yyyy}-%{mm}-",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "charge",
    name: "Charge",
    prefix: "CHG-%{yyyy}-%{mm}-",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "reimbursement",
    name: "Reimbursement",
    prefix: "REIMB-%{yyyy}-%{mm}-",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    // Credit/debit memos are payment-shaped `memo` documents with their own
    // numbering; the insert path picks the sequence by direction. Mirrors the
    // backfill in 20260628143012_ar-ap-payments.sql.
    table: "creditMemo",
    name: "Credit Memo",
    prefix: "CR-%{yyyy}-%{mm}-",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "debitMemo",
    name: "Debit Memo",
    prefix: "DR-%{yyyy}-%{mm}-",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "revenueRecognitionRun",
    name: "Revenue Recognition Run",
    prefix: "RR",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "fixedAssetTransfer",
    name: "Fixed Asset Transfer",
    prefix: "FAT",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "rentalAgreement",
    name: "Rental Agreement",
    prefix: "RA",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "lease",
    name: "Lease",
    prefix: "LSE",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "leaseRun",
    name: "Lease Run",
    prefix: "LR",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  },
  {
    table: "customerContract",
    name: "Contract",
    prefix: "CON",
    suffix: null,
    next: 0,
    size: 6,
    step: 1
  }
] as const;

// All 118 currencies from the original seed
export const currencies = [
  { code: "USD", decimalPlaces: 2, createdBy: "system" },
  { code: "CAD", decimalPlaces: 2, createdBy: "system" },
  { code: "EUR", decimalPlaces: 2, createdBy: "system" },
  { code: "AED", decimalPlaces: 2, createdBy: "system" },
  { code: "AFN", decimalPlaces: 0, createdBy: "system" },
  { code: "ALL", decimalPlaces: 0, createdBy: "system" },
  { code: "AMD", decimalPlaces: 0, createdBy: "system" },
  { code: "ARS", decimalPlaces: 2, createdBy: "system" },
  { code: "AUD", decimalPlaces: 2, createdBy: "system" },
  { code: "AZN", decimalPlaces: 2, createdBy: "system" },
  { code: "BAM", decimalPlaces: 2, createdBy: "system" },
  { code: "BDT", decimalPlaces: 2, createdBy: "system" },
  { code: "BGN", decimalPlaces: 2, createdBy: "system" },
  { code: "BHD", decimalPlaces: 3, createdBy: "system" },
  { code: "BIF", decimalPlaces: 0, createdBy: "system" },
  { code: "BND", decimalPlaces: 2, createdBy: "system" },
  { code: "BOB", decimalPlaces: 2, createdBy: "system" },
  { code: "BRL", decimalPlaces: 2, createdBy: "system" },
  { code: "BWP", decimalPlaces: 2, createdBy: "system" },
  { code: "BYN", decimalPlaces: 2, createdBy: "system" },
  { code: "BZD", decimalPlaces: 2, createdBy: "system" },
  { code: "CDF", decimalPlaces: 2, createdBy: "system" },
  { code: "CHF", decimalPlaces: 2, createdBy: "system" },
  { code: "CLP", decimalPlaces: 0, createdBy: "system" },
  { code: "CNY", decimalPlaces: 2, createdBy: "system" },
  { code: "COP", decimalPlaces: 0, createdBy: "system" },
  { code: "CRC", decimalPlaces: 0, createdBy: "system" },
  { code: "CVE", decimalPlaces: 2, createdBy: "system" },
  { code: "CZK", decimalPlaces: 2, createdBy: "system" },
  { code: "DJF", decimalPlaces: 0, createdBy: "system" },
  { code: "DKK", decimalPlaces: 2, createdBy: "system" },
  { code: "DOP", decimalPlaces: 2, createdBy: "system" },
  { code: "DZD", decimalPlaces: 2, createdBy: "system" },
  { code: "EGP", decimalPlaces: 2, createdBy: "system" },
  { code: "ERN", decimalPlaces: 2, createdBy: "system" },
  { code: "ETB", decimalPlaces: 2, createdBy: "system" },
  { code: "GBP", decimalPlaces: 2, createdBy: "system" },
  { code: "GEL", decimalPlaces: 2, createdBy: "system" },
  { code: "GHS", decimalPlaces: 2, createdBy: "system" },
  { code: "GNF", decimalPlaces: 0, createdBy: "system" },
  { code: "GTQ", decimalPlaces: 2, createdBy: "system" },
  { code: "HKD", decimalPlaces: 2, createdBy: "system" },
  { code: "HNL", decimalPlaces: 2, createdBy: "system" },
  { code: "HRK", decimalPlaces: 2, createdBy: "system" },
  { code: "HUF", decimalPlaces: 0, createdBy: "system" },
  { code: "IDR", decimalPlaces: 0, createdBy: "system" },
  { code: "ILS", decimalPlaces: 2, createdBy: "system" },
  { code: "INR", decimalPlaces: 2, createdBy: "system" },
  { code: "IQD", decimalPlaces: 0, createdBy: "system" },
  { code: "IRR", decimalPlaces: 0, createdBy: "system" },
  { code: "ISK", decimalPlaces: 0, createdBy: "system" },
  { code: "JMD", decimalPlaces: 2, createdBy: "system" },
  { code: "JOD", decimalPlaces: 3, createdBy: "system" },
  { code: "JPY", decimalPlaces: 0, createdBy: "system" },
  { code: "KES", decimalPlaces: 2, createdBy: "system" },
  { code: "KHR", decimalPlaces: 2, createdBy: "system" },
  { code: "KMF", decimalPlaces: 0, createdBy: "system" },
  { code: "KRW", decimalPlaces: 0, createdBy: "system" },
  { code: "KWD", decimalPlaces: 3, createdBy: "system" },
  { code: "KZT", decimalPlaces: 2, createdBy: "system" },
  { code: "LBP", decimalPlaces: 0, createdBy: "system" },
  { code: "LKR", decimalPlaces: 2, createdBy: "system" },
  { code: "LTL", decimalPlaces: 2, createdBy: "system" },
  { code: "LVL", decimalPlaces: 2, createdBy: "system" },
  { code: "LYD", decimalPlaces: 3, createdBy: "system" },
  { code: "MAD", decimalPlaces: 2, createdBy: "system" },
  { code: "MDL", decimalPlaces: 2, createdBy: "system" },
  { code: "MGA", decimalPlaces: 0, createdBy: "system" },
  { code: "MKD", decimalPlaces: 2, createdBy: "system" },
  { code: "MMK", decimalPlaces: 0, createdBy: "system" },
  { code: "MOP", decimalPlaces: 2, createdBy: "system" },
  { code: "MUR", decimalPlaces: 0, createdBy: "system" },
  { code: "MXN", decimalPlaces: 2, createdBy: "system" },
  { code: "MYR", decimalPlaces: 2, createdBy: "system" },
  { code: "MZN", decimalPlaces: 2, createdBy: "system" },
  { code: "NAD", decimalPlaces: 2, createdBy: "system" },
  { code: "NGN", decimalPlaces: 2, createdBy: "system" },
  { code: "NIO", decimalPlaces: 2, createdBy: "system" },
  { code: "NOK", decimalPlaces: 2, createdBy: "system" },
  { code: "NPR", decimalPlaces: 2, createdBy: "system" },
  { code: "NZD", decimalPlaces: 2, createdBy: "system" },
  { code: "OMR", decimalPlaces: 3, createdBy: "system" },
  { code: "PAB", decimalPlaces: 2, createdBy: "system" },
  { code: "PEN", decimalPlaces: 2, createdBy: "system" },
  { code: "PHP", decimalPlaces: 2, createdBy: "system" },
  { code: "PKR", decimalPlaces: 0, createdBy: "system" },
  { code: "PLN", decimalPlaces: 2, createdBy: "system" },
  { code: "PYG", decimalPlaces: 0, createdBy: "system" },
  { code: "QAR", decimalPlaces: 2, createdBy: "system" },
  { code: "RON", decimalPlaces: 2, createdBy: "system" },
  { code: "RSD", decimalPlaces: 0, createdBy: "system" },
  { code: "RUB", decimalPlaces: 2, createdBy: "system" },
  { code: "RWF", decimalPlaces: 0, createdBy: "system" },
  { code: "SAR", decimalPlaces: 2, createdBy: "system" },
  { code: "SDG", decimalPlaces: 2, createdBy: "system" },
  { code: "SEK", decimalPlaces: 2, createdBy: "system" },
  { code: "SGD", decimalPlaces: 2, createdBy: "system" },
  { code: "SOS", decimalPlaces: 0, createdBy: "system" },
  { code: "SYP", decimalPlaces: 0, createdBy: "system" },
  { code: "THB", decimalPlaces: 2, createdBy: "system" },
  { code: "TND", decimalPlaces: 3, createdBy: "system" },
  { code: "TOP", decimalPlaces: 2, createdBy: "system" },
  { code: "TRY", decimalPlaces: 2, createdBy: "system" },
  { code: "TTD", decimalPlaces: 2, createdBy: "system" },
  { code: "TWD", decimalPlaces: 2, createdBy: "system" },
  { code: "TZS", decimalPlaces: 0, createdBy: "system" },
  { code: "UAH", decimalPlaces: 2, createdBy: "system" },
  { code: "UGX", decimalPlaces: 0, createdBy: "system" },
  { code: "UYU", decimalPlaces: 2, createdBy: "system" },
  { code: "UZS", decimalPlaces: 0, createdBy: "system" },
  { code: "VEF", decimalPlaces: 2, createdBy: "system" },
  { code: "VND", decimalPlaces: 0, createdBy: "system" },
  { code: "XAF", decimalPlaces: 0, createdBy: "system" },
  { code: "XOF", decimalPlaces: 0, createdBy: "system" },
  { code: "YER", decimalPlaces: 0, createdBy: "system" },
  { code: "ZAR", decimalPlaces: 2, createdBy: "system" },
  { code: "ZMK", decimalPlaces: 0, createdBy: "system" },
  { code: "ZWL", decimalPlaces: 0, createdBy: "system" }
] as const;

// Chart of accounts - parent-child tree structure
// key/parentKey are used to resolve parentId at insert time (not stored in the database)
// Group accounts have number: null (they are organizational containers)
// Leaf accounts have 4-digit numbers following the standard COA structure:
//   1000-1999 Assets | 2000-2999 Liabilities | 3000-3999 Equity
//   4000-4999 Revenue | 5000-5999 COGS | 6000-6999 Operating Expenses | 7000-7999 Other Expenses
export const accounts = [
  // ═══════════════════════════════════════════════════════════
  // BALANCE SHEET
  // ═══════════════════════════════════════════════════════════
  {
    key: "balance-sheet",
    number: null,
    name: "Balance Sheet",
    isGroup: true,
    parentKey: null,
    accountType: null,
    incomeBalance: "Balance Sheet",
    class: null,
    consolidatedRate: "Current",
    isSystem: true,
    createdBy: "system"
  },

  // ─── 1000-1999: ASSETS ───
  {
    key: "assets",
    number: null,
    name: "Assets",
    isGroup: true,
    parentKey: "balance-sheet",
    accountType: "Other Current Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },

  // Cash & Bank
  {
    key: "cash-and-bank",
    number: null,
    name: "Cash & Bank",
    isGroup: true,
    parentKey: "assets",
    accountType: "Bank",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1010",
    number: "1010",
    name: "Bank - Cash",
    isGroup: false,
    parentKey: "cash-and-bank",
    accountType: "Bank",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1020",
    number: "1020",
    name: "Bank - Local Currency",
    isGroup: false,
    parentKey: "cash-and-bank",
    accountType: "Bank",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1030",
    number: "1030",
    name: "Bank - Foreign Currency",
    isGroup: false,
    parentKey: "cash-and-bank",
    accountType: "Bank",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },

  // Receivables
  {
    key: "receivables",
    number: null,
    name: "Receivables",
    isGroup: true,
    parentKey: "assets",
    accountType: "Accounts Receivable",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1110",
    number: "1110",
    name: "Accounts Receivable",
    isGroup: false,
    parentKey: "receivables",
    accountType: "Accounts Receivable",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1130",
    number: "1130",
    name: "Inter-Company Receivables",
    isGroup: false,
    parentKey: "receivables",
    accountType: "Accounts Receivable",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1145",
    number: "1145",
    name: "Contract Assets",
    isGroup: false,
    parentKey: "receivables",
    accountType: "Other Current Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1150",
    number: "1150",
    name: "Supplier Prepayments",
    isGroup: false,
    parentKey: "receivables",
    accountType: "Other Current Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1160",
    number: "1160",
    name: "Net Investment in Leases",
    isGroup: false,
    parentKey: "receivables",
    accountType: "Other Current Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },

  // Inventory
  {
    key: "inventory",
    number: null,
    name: "Inventory & Stock",
    isGroup: true,
    parentKey: "assets",
    accountType: "Inventory",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1210",
    number: "1210",
    name: "Raw Materials",
    isGroup: false,
    parentKey: "inventory",
    accountType: "Inventory",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1220",
    number: "1220",
    name: "Finished Goods",
    isGroup: false,
    parentKey: "inventory",
    accountType: "Inventory",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1230",
    number: "1230",
    name: "Work In Progress (WIP)",
    isGroup: false,
    parentKey: "inventory",
    accountType: "Inventory",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1240",
    number: "1240",
    name: "Inventory Reserves / Allowances",
    isGroup: false,
    parentKey: "inventory",
    accountType: "Inventory",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },

  // Property, Plant & Equipment
  {
    key: "ppe",
    number: null,
    name: "Property, Plant & Equipment",
    isGroup: true,
    parentKey: "assets",
    accountType: "Fixed Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1310",
    number: "1310",
    name: "Fixed Asset Acquisition Cost",
    isGroup: false,
    parentKey: "ppe",
    accountType: "Fixed Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1320",
    number: "1320",
    name: "Fixed Asset Acquisition Cost on Disposal",
    isGroup: false,
    parentKey: "ppe",
    accountType: "Fixed Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1330",
    number: "1330",
    name: "Accumulated Depreciation",
    isGroup: false,
    parentKey: "ppe",
    accountType: "Accumulated Depreciation",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1340",
    number: "1340",
    name: "Accumulated Depreciation on Disposal",
    isGroup: false,
    parentKey: "ppe",
    accountType: "Accumulated Depreciation",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1350",
    number: "1350",
    name: "Machinery & Equipment",
    isGroup: false,
    parentKey: "ppe",
    accountType: "Fixed Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1360",
    number: "1360",
    name: "Buildings & Leasehold Improvements",
    isGroup: false,
    parentKey: "ppe",
    accountType: "Fixed Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1370",
    number: "1370",
    name: "Rental Fleet",
    isGroup: false,
    parentKey: "ppe",
    accountType: "Fixed Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1380",
    number: "1380",
    name: "Accumulated Depreciation – Rental Fleet",
    isGroup: false,
    parentKey: "ppe",
    accountType: "Accumulated Depreciation",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1390",
    number: "1390",
    name: "Construction in Progress",
    isGroup: false,
    parentKey: "ppe",
    accountType: "Fixed Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },

  // Other Assets
  {
    key: "other-assets",
    number: null,
    name: "Other Assets",
    isGroup: true,
    parentKey: "assets",
    accountType: "Other Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1410",
    number: "1410",
    name: "Intangible Assets",
    isGroup: false,
    parentKey: "other-assets",
    accountType: "Other Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1420",
    number: "1420",
    name: "Accumulated Amortization",
    isGroup: false,
    parentKey: "other-assets",
    accountType: "Other Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1430",
    number: "1430",
    name: "Investments in Subsidiaries",
    isGroup: false,
    parentKey: "other-assets",
    accountType: "Investments",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1440",
    number: "1440",
    name: "Deferred Tax Assets",
    isGroup: false,
    parentKey: "other-assets",
    accountType: "Other Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1450",
    number: "1450",
    name: "Right-of-Use Assets",
    isGroup: false,
    parentKey: "other-assets",
    accountType: "Other Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "1460",
    number: "1460",
    name: "Accumulated Amortization – Right-of-Use Assets",
    isGroup: false,
    parentKey: "other-assets",
    accountType: "Other Asset",
    incomeBalance: "Balance Sheet",
    class: "Asset",
    consolidatedRate: "Current",
    createdBy: "system"
  },

  // ─── 2000-2999: LIABILITIES ───
  {
    key: "liabilities",
    number: null,
    name: "Liabilities",
    isGroup: true,
    parentKey: "balance-sheet",
    accountType: "Other Current Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },

  // Payables
  {
    key: "payables",
    number: null,
    name: "Payables",
    isGroup: true,
    parentKey: "liabilities",
    accountType: "Accounts Payable",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2010",
    number: "2010",
    name: "Accounts Payable",
    isGroup: false,
    parentKey: "payables",
    accountType: "Accounts Payable",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2020",
    number: "2020",
    name: "Inter-Company Payables",
    isGroup: false,
    parentKey: "payables",
    accountType: "Accounts Payable",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },

  // Current Liabilities
  {
    key: "current-liabilities",
    number: null,
    name: "Current Liabilities",
    isGroup: true,
    parentKey: "liabilities",
    accountType: "Other Current Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2110",
    number: "2110",
    name: "Customer Prepayments",
    isGroup: false,
    parentKey: "current-liabilities",
    accountType: "Other Current Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2125",
    number: "2125",
    name: "GR/IR Clearing",
    isGroup: false,
    parentKey: "current-liabilities",
    accountType: "Other Current Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2140",
    number: "2140",
    name: "Accrued Expenses",
    isGroup: false,
    parentKey: "current-liabilities",
    accountType: "Other Current Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2150",
    number: "2150",
    name: "Accrued Wages & Salaries",
    isGroup: false,
    parentKey: "current-liabilities",
    accountType: "Other Current Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2160",
    number: "2160",
    name: "Deferred Revenue",
    isGroup: false,
    parentKey: "current-liabilities",
    accountType: "Other Current Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2170",
    number: "2170",
    name: "Short-Term Loans",
    isGroup: false,
    parentKey: "current-liabilities",
    accountType: "Other Current Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2180",
    number: "2180",
    name: "Employee Reimbursements Payable",
    isGroup: false,
    parentKey: "current-liabilities",
    accountType: "Other Current Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },

  // Tax Liabilities
  {
    key: "tax-liabilities",
    number: null,
    name: "Tax Liabilities",
    isGroup: true,
    parentKey: "liabilities",
    accountType: "Tax",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2210",
    number: "2210",
    name: "Sales Tax Payable",
    isGroup: false,
    parentKey: "tax-liabilities",
    accountType: "Tax",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2220",
    number: "2220",
    name: "Purchase Tax Payable",
    isGroup: false,
    parentKey: "tax-liabilities",
    accountType: "Tax",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2230",
    number: "2230",
    name: "Reverse Charge Tax Payable",
    isGroup: false,
    parentKey: "tax-liabilities",
    accountType: "Tax",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },

  // Long-Term Liabilities
  {
    key: "long-term-liabilities",
    number: null,
    name: "Long-Term Liabilities",
    isGroup: true,
    parentKey: "liabilities",
    accountType: "Long Term Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2410",
    number: "2410",
    name: "Long-Term Debt / Loans",
    isGroup: false,
    parentKey: "long-term-liabilities",
    accountType: "Long Term Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2420",
    number: "2420",
    name: "Deferred Tax Liabilities",
    isGroup: false,
    parentKey: "long-term-liabilities",
    accountType: "Long Term Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2430",
    number: "2430",
    name: "Pension Obligations",
    isGroup: false,
    parentKey: "long-term-liabilities",
    accountType: "Long Term Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },
  {
    key: "2440",
    number: "2440",
    name: "Lease Liabilities",
    isGroup: false,
    parentKey: "long-term-liabilities",
    accountType: "Long Term Liability",
    incomeBalance: "Balance Sheet",
    class: "Liability",
    consolidatedRate: "Current",
    createdBy: "system"
  },

  // ─── 3000-3999: EQUITY ───
  {
    key: "equity",
    number: null,
    name: "Equity",
    isGroup: true,
    parentKey: "balance-sheet",
    accountType: "Equity - No Close",
    incomeBalance: "Balance Sheet",
    class: "Equity",
    consolidatedRate: "Historical",
    createdBy: "system"
  },
  {
    key: "3010",
    number: "3010",
    name: "Common Stock / Share Capital",
    isGroup: false,
    parentKey: "equity",
    accountType: "Equity - No Close",
    incomeBalance: "Balance Sheet",
    class: "Equity",
    consolidatedRate: "Historical",
    createdBy: "system"
  },
  {
    key: "3100",
    number: "3100",
    name: "Retained Earnings",
    isGroup: false,
    parentKey: "equity",
    accountType: "Retained Earnings",
    incomeBalance: "Balance Sheet",
    class: "Equity",
    consolidatedRate: "Historical",
    createdBy: "system"
  },
  {
    key: "3200",
    number: "3200",
    name: "Reserves (Currency Translation)",
    isGroup: false,
    parentKey: "equity",
    accountType: "Equity - Close",
    incomeBalance: "Balance Sheet",
    class: "Equity",
    consolidatedRate: "Historical",
    createdBy: "system"
  },
  {
    key: "3300",
    number: "3300",
    name: "Dividends Payable",
    isGroup: false,
    parentKey: "equity",
    accountType: "Equity - Close",
    incomeBalance: "Balance Sheet",
    class: "Equity",
    consolidatedRate: "Historical",
    createdBy: "system"
  },
  {
    // The opening journal of the accounting cutover offsets every open item
    // and trial balance line here; it must total zero before the enable.
    key: "3400",
    number: "3400",
    name: "Migration Clearing",
    isGroup: false,
    parentKey: "equity",
    accountType: "Equity - No Close",
    incomeBalance: "Balance Sheet",
    class: "Equity",
    consolidatedRate: "Historical",
    createdBy: "system"
  },

  // ═══════════════════════════════════════════════════════════
  // INCOME STATEMENT
  // ═══════════════════════════════════════════════════════════
  {
    key: "income-statement",
    number: null,
    name: "Income Statement",
    isGroup: true,
    parentKey: null,
    accountType: null,
    incomeBalance: "Income Statement",
    class: null,
    consolidatedRate: "Average",
    isSystem: true,
    createdBy: "system"
  },

  // ─── 4000-4999: REVENUE ───
  {
    key: "revenue",
    number: null,
    name: "Revenue",
    isGroup: true,
    parentKey: "income-statement",
    accountType: "Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "4010",
    number: "4010",
    name: "Sales",
    isGroup: false,
    parentKey: "revenue",
    accountType: "Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "4020",
    number: "4020",
    name: "Sales Discounts",
    isGroup: false,
    parentKey: "revenue",
    accountType: "Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "4030",
    number: "4030",
    name: "Manufacturing Services Revenue",
    isGroup: false,
    parentKey: "revenue",
    accountType: "Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "4040",
    number: "4040",
    name: "Customer Payment Discounts",
    isGroup: false,
    parentKey: "revenue",
    accountType: "Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "4050",
    number: "4050",
    name: "Shipping Revenue",
    isGroup: false,
    parentKey: "revenue",
    accountType: "Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "4060",
    number: "4060",
    name: "Rental Income",
    isGroup: false,
    parentKey: "revenue",
    accountType: "Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "4070",
    number: "4070",
    name: "Lease Revenue",
    isGroup: false,
    parentKey: "revenue",
    accountType: "Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "4900",
    number: "4900",
    name: "Sales Returns",
    isGroup: false,
    parentKey: "revenue",
    accountType: "Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },

  // Other Income
  {
    key: "other-income",
    number: null,
    name: "Other Income",
    isGroup: true,
    parentKey: "income-statement",
    accountType: "Other Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "4110",
    number: "4110",
    name: "Scrap Sales",
    isGroup: false,
    parentKey: "other-income",
    accountType: "Other Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "4120",
    number: "4120",
    name: "Foreign Exchange Gains",
    isGroup: false,
    parentKey: "other-income",
    accountType: "Other Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "4130",
    number: "4130",
    name: "Vendor Write-Off Income",
    isGroup: false,
    parentKey: "other-income",
    accountType: "Other Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "4140",
    number: "4140",
    name: "Gain on Disposal",
    isGroup: false,
    parentKey: "other-income",
    accountType: "Other Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "4150",
    number: "4150",
    name: "Interest Income – Leases",
    isGroup: false,
    parentKey: "other-income",
    accountType: "Other Income",
    incomeBalance: "Income Statement",
    class: "Revenue",
    consolidatedRate: "Average",
    createdBy: "system"
  },

  // ─── 5000-5999: COST OF GOODS SOLD ───
  {
    key: "cogs",
    number: null,
    name: "Cost of Goods Sold",
    isGroup: true,
    parentKey: "income-statement",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "5010",
    number: "5010",
    name: "Cost of Goods Sold - Direct",
    isGroup: false,
    parentKey: "cogs",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "5050",
    number: "5050",
    name: "Indirect Materials & Services",
    isGroup: false,
    parentKey: "cogs",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "5060",
    number: "5060",
    name: "Labor & Machine Absorption",
    isGroup: false,
    parentKey: "cogs",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "5070",
    number: "5070",
    name: "Overhead Absorption",
    isGroup: false,
    parentKey: "cogs",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "5080",
    number: "5080",
    name: "Supplier Payment Discounts",
    isGroup: false,
    parentKey: "cogs",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },

  // Variances
  {
    key: "variances",
    number: null,
    name: "Variances",
    isGroup: true,
    parentKey: "cogs",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "5210",
    number: "5210",
    name: "Purchase Price Variance",
    isGroup: false,
    parentKey: "variances",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "5220",
    number: "5220",
    name: "Material Usage Variance",
    isGroup: false,
    parentKey: "variances",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "5230",
    number: "5230",
    name: "Labor & Machine Variance",
    isGroup: false,
    parentKey: "variances",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "5240",
    number: "5240",
    name: "Overhead Variance",
    isGroup: false,
    parentKey: "variances",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "5250",
    number: "5250",
    name: "Lot Size Variance",
    isGroup: false,
    parentKey: "variances",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "5260",
    number: "5260",
    name: "Subcontracting Variance",
    isGroup: false,
    parentKey: "variances",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },

  // Inventory Adjustments
  {
    key: "inventory-adjustments",
    number: null,
    name: "Inventory Adjustments",
    isGroup: true,
    parentKey: "cogs",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "5310",
    number: "5310",
    name: "Inventory Adjustment",
    isGroup: false,
    parentKey: "inventory-adjustments",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "5320",
    number: "5320",
    name: "Scrap / Cost of Quality",
    isGroup: false,
    parentKey: "inventory-adjustments",
    accountType: "Cost of Goods Sold",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },

  // ─── 6000-6999: OPERATING EXPENSES ───
  {
    key: "operating-expenses",
    number: null,
    name: "Operating Expenses",
    isGroup: true,
    parentKey: "income-statement",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6010",
    number: "6010",
    name: "Maintenance Expense",
    isGroup: false,
    parentKey: "operating-expenses",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6020",
    number: "6020",
    name: "Sales Commissions",
    isGroup: false,
    parentKey: "operating-expenses",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6030",
    number: "6030",
    name: "Advertising & Marketing",
    isGroup: false,
    parentKey: "operating-expenses",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6040",
    number: "6040",
    name: "Freight & Shipping Out",
    isGroup: false,
    parentKey: "operating-expenses",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6050",
    number: "6050",
    name: "Bad Debts Expense",
    isGroup: false,
    parentKey: "operating-expenses",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6060",
    number: "6060",
    name: "Salaries - Administrative",
    isGroup: false,
    parentKey: "operating-expenses",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6070",
    number: "6070",
    name: "Rent & Utilities (Non-Factory)",
    isGroup: false,
    parentKey: "operating-expenses",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6080",
    number: "6080",
    name: "Professional Fees",
    isGroup: false,
    parentKey: "operating-expenses",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6090",
    number: "6090",
    name: "Travel & Entertainment",
    isGroup: false,
    parentKey: "operating-expenses",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6100",
    number: "6100",
    name: "Insurance",
    isGroup: false,
    parentKey: "operating-expenses",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6110",
    number: "6110",
    name: "Bank Charges & Fees",
    isGroup: false,
    parentKey: "operating-expenses",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6130",
    number: "6130",
    name: "Variable Lease Expense",
    isGroup: false,
    parentKey: "operating-expenses",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6140",
    number: "6140",
    name: "Operating Lease Expense",
    isGroup: false,
    parentKey: "operating-expenses",
    accountType: "Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },

  // Depreciation & Amortization
  {
    key: "depreciation",
    number: null,
    name: "Depreciation & Amortization",
    isGroup: true,
    parentKey: "operating-expenses",
    accountType: "Other Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6310",
    number: "6310",
    name: "Depreciation Expense",
    isGroup: false,
    parentKey: "depreciation",
    accountType: "Other Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6320",
    number: "6320",
    name: "Loss on Disposal",
    isGroup: false,
    parentKey: "depreciation",
    accountType: "Other Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "6330",
    number: "6330",
    name: "Amortization – Right-of-Use Assets",
    isGroup: false,
    parentKey: "depreciation",
    accountType: "Other Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },

  // ─── 7000-7999: OTHER / NON-OPERATING EXPENSES ───
  {
    key: "other-expenses",
    number: null,
    name: "Other Expenses",
    isGroup: true,
    parentKey: "income-statement",
    accountType: "Other Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "7010",
    number: "7010",
    name: "Interest Expense",
    isGroup: false,
    parentKey: "other-expenses",
    accountType: "Other Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "7020",
    number: "7020",
    name: "Interest Expense – Leases",
    isGroup: false,
    parentKey: "other-expenses",
    accountType: "Other Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "7040",
    number: "7040",
    name: "Service Charge Account",
    isGroup: false,
    parentKey: "other-expenses",
    accountType: "Other Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "7050",
    number: "7050",
    name: "Rounding Account",
    isGroup: false,
    parentKey: "other-expenses",
    accountType: "Other Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "7060",
    number: "7060",
    name: "Foreign Exchange Losses",
    isGroup: false,
    parentKey: "other-expenses",
    accountType: "Other Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "7070",
    number: "7070",
    name: "Income Tax Expense",
    isGroup: false,
    parentKey: "other-expenses",
    accountType: "Other Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "7080",
    number: "7080",
    name: "R&D Expenses",
    isGroup: false,
    parentKey: "other-expenses",
    accountType: "Other Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  },
  {
    key: "7090",
    number: "7090",
    name: "Deferred Tax Expense",
    isGroup: false,
    parentKey: "other-expenses",
    accountType: "Other Expense",
    incomeBalance: "Income Statement",
    class: "Expense",
    consolidatedRate: "Average",
    createdBy: "system"
  }
] as const;

export const accountDefaults = {
  salesAccount: "4010",
  salesShippingRevenueAccount: "4050",
  salesDiscountAccount: "4020",
  salesReturnsAccount: "4900",
  employeeReimbursementsPayableAccount: "2180",
  costOfGoodsSoldAccount: "5010",
  purchaseVarianceAccount: "5210",
  inventoryAdjustmentVarianceAccount: "5310",
  scrapAccount: "5320",
  materialVarianceAccount: "5220",
  laborAndMachineVarianceAccount: "5230",
  overheadVarianceAccount: "5240",
  lotSizeVarianceAccount: "5250",
  subcontractingVarianceAccount: "5260",
  laborAbsorptionAccount: "5060",
  overheadAbsorptionAccount: "5070",
  indirectCostAccount: "5050",
  maintenanceAccount: "6010",
  assetDepreciationExpenseAccount: "6310",
  assetGainOnDisposalAccount: "4140",
  assetLossOnDisposalAccount: "6320",
  serviceChargeAccount: "7040",
  interestAccount: "7010",
  supplierPaymentDiscountAccount: "5080",
  customerPaymentDiscountAccount: "4040",
  roundingAccount: "7050",
  assetAquisitionCostAccount: "1310",
  assetAquisitionCostOnDisposalAccount: "1320",
  accumulatedDepreciationAccount: "1330",
  accumulatedDepreciationOnDisposalAccount: "1340",
  rawMaterialsAccount: "1210",
  finishedGoodsAccount: "1220",
  workInProgressAccount: "1230",
  receivablesAccount: "1110",
  intercompanyReceivablesAccount: "1130",
  bankCashAccount: "1010",
  bankLocalCurrencyAccount: "1020",
  bankForeignCurrencyAccount: "1030",
  prepaymentAccount: "2110",
  supplierPrepaymentAccount: "1150",
  payablesAccount: "2010",
  intercompanyPayablesAccount: "2020",
  goodsReceivedNotInvoicedAccount: "2125",
  salesTaxPayableAccount: "2210",
  purchaseTaxPayableAccount: "2220",
  reverseChargeSalesTaxPayableAccount: "2230",
  retainedEarningsAccount: "3100",
  migrationClearingAccount: "3400",
  currencyTranslationAccount: "3200",
  customerWriteOffAccount: "6050",
  supplierWriteOffAccount: "4130",
  realizedExchangeGainAccount: "4120",
  realizedExchangeLossAccount: "7060",
  deferredTaxLiabilityAccountId: "2420",
  deferredTaxExpenseAccountId: "7090",
  deferredRevenueAccount: "2160",
  contractAssetAccount: "1145",
  rentalIncomeAccount: "4060",
  leaseRevenueAccount: "4070",
  leaseInterestIncomeAccount: "4150",
  netInvestmentInLeasesAccount: "1160",
  rightOfUseAssetAccount: "1450",
  accumulatedRightOfUseAmortizationAccount: "1460",
  leaseLiabilityAccount: "2440",
  operatingLeaseExpenseAccount: "6140",
  variableLeaseExpenseAccount: "6130",
  rightOfUseAmortizationExpenseAccount: "6330",
  leaseInterestExpenseAccount: "7020"
} as const;

export const fixedAssetClasses = [
  {
    name: "Buildings",
    depreciationMethod: "Straight Line" as const,
    usefulLifeMonths: 468,
    residualValuePercent: 0,
    assetAccount: "1360",
    accumulatedDepreciationAccount: "1330",
    depreciationExpenseAccount: "6310",
    writeOffAccount: "6320",
    writeDownAccount: "6320",
    gainOnDisposalAccount: "4140",
    lossOnDisposalAccount: "6320",
    isConstructionInProgress: false
  },
  {
    name: "Machinery & Equipment",
    depreciationMethod: "Straight Line" as const,
    usefulLifeMonths: 120,
    residualValuePercent: 0,
    assetAccount: "1350",
    accumulatedDepreciationAccount: "1330",
    depreciationExpenseAccount: "6310",
    writeOffAccount: "6320",
    writeDownAccount: "6320",
    gainOnDisposalAccount: "4140",
    lossOnDisposalAccount: "6320",
    isConstructionInProgress: false
  },
  {
    name: "Vehicles",
    depreciationMethod: "Straight Line" as const,
    usefulLifeMonths: 60,
    residualValuePercent: 0,
    assetAccount: "1310",
    accumulatedDepreciationAccount: "1330",
    depreciationExpenseAccount: "6310",
    writeOffAccount: "6320",
    writeDownAccount: "6320",
    gainOnDisposalAccount: "4140",
    lossOnDisposalAccount: "6320",
    isConstructionInProgress: false
  },
  {
    // Built or bought units rented out under operating leases: their own
    // balance-sheet line, depreciated whether or not on rent.
    name: "Rental Fleet",
    depreciationMethod: "Straight Line" as const,
    usefulLifeMonths: 60,
    residualValuePercent: 20,
    assetAccount: "1370",
    accumulatedDepreciationAccount: "1380",
    depreciationExpenseAccount: "6310",
    writeOffAccount: "6320",
    writeDownAccount: "6320",
    gainOnDisposalAccount: "4140",
    lossOnDisposalAccount: "6320",
    isConstructionInProgress: false
  },
  {
    // Self-constructed assets accumulate cost here until placed in service;
    // never depreciated (its depreciation accounts are conventional fillers).
    name: "Construction in Progress",
    depreciationMethod: "Straight Line" as const,
    usefulLifeMonths: 120,
    residualValuePercent: 0,
    assetAccount: "1390",
    accumulatedDepreciationAccount: "1330",
    depreciationExpenseAccount: "6310",
    writeOffAccount: "6320",
    writeDownAccount: "6320",
    gainOnDisposalAccount: "4140",
    lossOnDisposalAccount: "6320",
    isConstructionInProgress: true
  }
];

export const fiscalYearSettings = {
  startMonth: "January",
  taxStartMonth: "January",
  updatedBy: "system"
} as const;

/**
 * Default period-close checklist (NetSuite-style). Seeded per company as system
 * task definitions; getPeriodCloseChecklist instantiates a periodCloseTask per
 * period from the active definitions. `autoCheckKey` binds Auto tasks to a
 * readiness evaluator in accounting.service.ts (computePeriodReadiness).
 */
export const periodCloseTaskDefinitions = [
  {
    name: "Post pending operational documents",
    taskType: "Auto",
    autoCheckKey: "pending-postings",
    sortOrder: 1,
    required: true,
    severity: "Blocker",
    active: true,
    isSystem: true
  },
  {
    name: "Post or re-date draft journal entries",
    taskType: "Auto",
    autoCheckKey: "draft-journals",
    sortOrder: 2,
    required: true,
    severity: "Blocker",
    active: true,
    isSystem: true
  },
  {
    name: "Lock the period",
    taskType: "Action",
    autoCheckKey: null,
    sortOrder: 3,
    required: true,
    severity: null,
    active: true,
    isSystem: true
  },
  {
    name: "Post depreciation runs covering the period",
    taskType: "Auto",
    autoCheckKey: "draft-depreciation",
    sortOrder: 4,
    required: true,
    severity: "Warning",
    active: true,
    isSystem: true
  },
  {
    name: "Recognize revenue for the period",
    taskType: "Auto",
    autoCheckKey: "unposted-revenue-schedules",
    sortOrder: 5,
    required: true,
    severity: "Warning",
    active: true,
    isSystem: true
  },
  {
    name: "Post lease journals",
    taskType: "Auto",
    autoCheckKey: "unposted-lease-schedules",
    sortOrder: 5,
    required: true,
    severity: "Warning",
    active: true,
    isSystem: true
  },
  {
    name: "Match & eliminate intercompany transactions",
    taskType: "Auto",
    autoCheckKey: "unmatched-ic",
    sortOrder: 5,
    required: true,
    severity: "Warning",
    active: true,
    isSystem: true
  },
  {
    name: "Review negative on-hand inventory",
    taskType: "Action",
    autoCheckKey: null,
    sortOrder: 6,
    required: true,
    severity: null,
    active: true,
    isSystem: true
  },
  {
    name: "Trial balance in balance for the period",
    taskType: "Auto",
    autoCheckKey: "tb-balanced",
    sortOrder: 7,
    required: true,
    severity: "Blocker",
    active: true,
    isSystem: true
  },
  {
    name: "Review financial statements",
    taskType: "Action",
    autoCheckKey: null,
    sortOrder: 8,
    required: true,
    severity: null,
    active: true,
    isSystem: true
  },
  {
    name: "External GL sync complete",
    taskType: "Auto",
    autoCheckKey: "external-gl-sync",
    sortOrder: 9,
    required: true,
    severity: "Blocker",
    active: true,
    isSystem: true
  }
];

/**
 * Default location seeded for new companies
 * Required for inventory quantities, jobs, and other location-dependent features
 */
export const defaultLocation = {
  name: "Headquarters",
  code: "HQ",
  addressLine1: "123 Main Street",
  city: "Austin",
  stateProvince: "TX",
  postalCode: "78701",
  countryCode: "US",
  timezone: "America/Chicago",
  createdBy: "system"
} as const;

export const groups = [
  {
    idPrefix: "00000000-0000",
    name: "All Employees",
    isCustomerTypeGroup: false,
    isEmployeeTypeGroup: true,
    isSupplierTypeGroup: false
  },
  {
    idPrefix: "11111111-1111",
    name: "All Customers",
    isCustomerTypeGroup: true,
    isEmployeeTypeGroup: false,
    isSupplierTypeGroup: false
  },
  {
    idPrefix: "22222222-2222",
    name: "All Suppliers",
    isCustomerTypeGroup: false,
    isEmployeeTypeGroup: false,
    isSupplierTypeGroup: true
  }
] as const;

/**
 * Helper to generate group ID from idPrefix and company ID
 * The resulting ID format: {idPrefix}-{companyId formatted as XXXX-YYYY-ZZZZZZZZZZZZ}
 */
export function getGroupId(idPrefix: string, companyId: string): string {
  const companyIdPart = `${companyId.substring(0, 4)}-${companyId.substring(
    4,
    8
  )}-${companyId.substring(8, 20)}`;
  return `${idPrefix}-${companyIdPart}`;
}