Collmex MCP by usefulapi

Review Collmex customers, products, invoices and orders; create customers and addresses.

사용해야 할까요

품질 및 안전성

A
설명 품질
100%
스키마 완전성
91%
이름 품질
79%
오염 위험
100%
권한 일치
100%
프로토콜 준수
100%

발견 사항 (1)

  • LOWTool 'collmex_list_accounting_documents' name length outside 3-30 rangecollmex_list_accounting_documents에서

도구 정의와 프로토콜 준수에 대한 자동 분석을 기반으로 합니다.

컨텍스트 비용

~6,046토큰 (도구 정의)
~3.5 KB일반적인 응답 크기
상당한 주의 영향 (128k 컨텍스트의 4.72%)

이는 서버의 도구가 모델의 컨텍스트에 로드될 때마다 소비되는 대략적인 토큰 수입니다. 수치가 높을수록 다른 작업에 사용할 수 있는 주의가 줄어듭니다.

설치

원클릭 설치

`claude_desktop_config.json` 파일에 다음을 추가하세요:

{
  "mcpServers": {
    "collmex": {
      "url": "https://collmex.usefulapi.io/mcp"
    }
  }
}

원격 엔드포인트

https://collmex.usefulapi.io/mcpstreamable-http

할 수 있는 일

도구 목록

도구 (15)

🟢 읽기 전용🟡 쓰기🔴 삭제⚪ 알 수 없음
🟢collmex_list_customers(customer_no, text, postcode_country, address_group, follow_up_due, ...)

Search Collmex customers (record CUSTOMER_GET): by customer number, free text (name, city, e-mail ...), postal code or country. Returns address, contact, bank (IBAN/BIC), VAT id, payment terms, agent and status fields. Inactive customers are left out unless asked for.

입력 스키마

{
  "type": "object",
  "properties": {
    "customer_no": {
      "description": "Only this customer number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "text": {
      "description": "Free-text search (max 80 characters).",
      "type": "string",
      "minLength": 1,
      "maxLength": 80
    },
    "postcode_country": {
      "description": "Postal code or country code to search by.",
      "type": "string",
      "minLength": 1,
      "maxLength": 8
    },
    "address_group": {
      "description": "Only customers of this address group number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "follow_up_due": {
      "description": "Only customers due for follow-up (Wiedervorlage).",
      "type": "boolean"
    },
    "include_inactive": {
      "description": "Also return inactive customers.",
      "type": "boolean"
    },
    "company_no": {
      "description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "limit": {
      "description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit).",
      "type": "integer",
      "minimum": 1,
      "maximum": 500
    },
    "offset": {
      "description": "Records to skip (use next_offset from the previous reply).",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟢collmex_list_vendors(vendor_no, text, postcode_country, follow_up_due, company_no, ...)

Search Collmex vendors/suppliers (record VENDOR_GET): by vendor number, free text, postal code or country. Returns address, contact, bank, VAT id, payment terms and expense account fields.

입력 스키마

{
  "type": "object",
  "properties": {
    "vendor_no": {
      "description": "Only this vendor number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "text": {
      "description": "Free-text search (max 80 characters).",
      "type": "string",
      "minLength": 1,
      "maxLength": 80
    },
    "postcode_country": {
      "description": "Postal code or country code to search by.",
      "type": "string",
      "minLength": 1,
      "maxLength": 8
    },
    "follow_up_due": {
      "description": "Only vendors due for follow-up (Wiedervorlage).",
      "type": "boolean"
    },
    "company_no": {
      "description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "limit": {
      "description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit).",
      "type": "integer",
      "minimum": 1,
      "maximum": 500
    },
    "offset": {
      "description": "Records to skip (use next_offset from the previous reply).",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟢collmex_list_addresses(address_no, address_type, text, postcode_country, address_group, ...)

Search the Collmex address book (record ADDRESS_GET): customers, vendors and address-book entries in one list, optionally with their contact persons. address_type: 0 all, 1 customers, 2 vendors, 3 address-book entries.

입력 스키마

{
  "type": "object",
  "properties": {
    "address_no": {
      "description": "Only this address number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "address_type": {
      "description": "0 or empty = all, 1 = customers, 2 = vendors, 3 = address-book entries.",
      "type": "integer",
      "minimum": 0,
      "maximum": 3
    },
    "text": {
      "description": "Free-text search (max 80 characters).",
      "type": "string",
      "minLength": 1,
      "maxLength": 80
    },
    "postcode_country": {
      "description": "Postal code or country code to search by.",
      "type": "string",
      "minLength": 1,
      "maxLength": 8
    },
    "address_group": {
      "description": "Only addresses of this address group number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "follow_up_due": {
      "description": "Only addresses due for follow-up (Wiedervorlage).",
      "type": "boolean"
    },
    "include_contacts": {
      "description": "Also return contact persons (address_type 4 rows).",
      "type": "boolean"
    },
    "include_inactive": {
      "description": "Also return inactive addresses.",
      "type": "boolean"
    },
    "company_no": {
      "description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "limit": {
      "description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit).",
      "type": "integer",
      "minimum": 1,
      "maximum": 500
    },
    "offset": {
      "description": "Records to skip (use next_offset from the previous reply).",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟢collmex_list_products(product_no, product_group, price_group, text, only_with_price, ...)

Search Collmex products (record PRODUCT_GET): by product number, product group, free text (number, description, remark, GTIN, manufacturer) or price group. Returns description, unit, tax class, sales price, purchase data and stock settings.

입력 스키마

{
  "type": "object",
  "properties": {
    "product_no": {
      "description": "Only this product number.",
      "type": "string",
      "minLength": 1,
      "maxLength": 20
    },
    "product_group": {
      "description": "Only products of this product group (and its subgroups).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "price_group": {
      "description": "Return the price of this price group (default: standard price group 0).",
      "type": "string",
      "minLength": 1,
      "maxLength": 20
    },
    "text": {
      "description": "Free-text search (max 80 characters).",
      "type": "string",
      "minLength": 1,
      "maxLength": 80
    },
    "only_with_price": {
      "description": "Only products that have a price.",
      "type": "boolean"
    },
    "company_no": {
      "description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "limit": {
      "description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit).",
      "type": "integer",
      "minimum": 1,
      "maximum": 500
    },
    "offset": {
      "description": "Records to skip (use next_offset from the previous reply).",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟢collmex_get_available_stock(product_no, company_no, limit, offset)

Currently available stock per product (record STOCK_AVAILABLE_GET): on-hand stock of the available stock types minus demand due today or earlier. A service product shows (NULL). Leave product_no empty for every product.

입력 스키마

{
  "type": "object",
  "properties": {
    "product_no": {
      "description": "Only this product number.",
      "type": "string",
      "minLength": 1,
      "maxLength": 20
    },
    "company_no": {
      "description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "limit": {
      "description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit).",
      "type": "integer",
      "minimum": 1,
      "maximum": 500
    },
    "offset": {
      "description": "Records to skip (use next_offset from the previous reply).",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟢collmex_list_invoices(invoice_no, customer_no, date_from, date_to, only_issued, ...)

Search Collmex customer invoices and credit notes (record INVOICE_GET): by invoice number, customer, invoice date range, customer order or product. Each invoice has its header (customer address, dates, payment terms, status code: 0 new, 10 to be posted, 20 open, 30 dunned, 40 settled, 100 deleted) and its positions with quantities, prices and values. Reads only; no PDF/XML export.

입력 스키마

{
  "type": "object",
  "properties": {
    "invoice_no": {
      "description": "Only this invoice number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "customer_no": {
      "description": "Only invoices of this customer number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "date_from": {
      "description": "Invoice date from (yyyy-mm-dd).",
      "type": "string",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
    },
    "date_to": {
      "description": "Invoice date to (yyyy-mm-dd).",
      "type": "string",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
    },
    "only_issued": {
      "description": "Only invoices already printed or sent.",
      "type": "boolean"
    },
    "customer_order_no": {
      "description": "Only invoices for this customer order number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "product_no": {
      "description": "Only invoices with this product on at least one position.",
      "type": "string",
      "minLength": 1,
      "maxLength": 20
    },
    "company_no": {
      "description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "limit": {
      "description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit).",
      "type": "integer",
      "minimum": 1,
      "maximum": 500
    },
    "offset": {
      "description": "Records to skip (use next_offset from the previous reply).",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟢collmex_list_sales_orders(order_no, customer_no, date_from, date_to, customer_purchase_order_no, ...)

Search Collmex customer orders (record SALES_ORDER_GET): by order number, customer, order date range or the customer's own order number. Each order has its header (customer address, dates, payment terms, status code: 0 new, 10 confirmed, 30 paid, 50 delivered, 90 invoiced, 100 done, 1000 cancelled) and its positions. Reads only; no PDF export.

입력 스키마

{
  "type": "object",
  "properties": {
    "order_no": {
      "description": "Only this order number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "customer_no": {
      "description": "Only orders of this customer number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "date_from": {
      "description": "Order date from (yyyy-mm-dd).",
      "type": "string",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
    },
    "date_to": {
      "description": "Order date to (yyyy-mm-dd).",
      "type": "string",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
    },
    "customer_purchase_order_no": {
      "description": "The customer's own order number.",
      "type": "string",
      "minLength": 1,
      "maxLength": 20
    },
    "company_no": {
      "description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "limit": {
      "description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit).",
      "type": "integer",
      "minimum": 1,
      "maximum": 500
    },
    "offset": {
      "description": "Records to skip (use next_offset from the previous reply).",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟢collmex_list_payment_terms(limit, offset)

The payment terms defined in Collmex (record TERMS_OF_PAYMENT_GET): number, description, payment method and discount periods. The number is what customers, vendors and invoices refer to as payment_terms.

입력 스키마

{
  "type": "object",
  "properties": {
    "limit": {
      "description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit).",
      "type": "integer",
      "minimum": 1,
      "maximum": 500
    },
    "offset": {
      "description": "Records to skip (use next_offset from the previous reply).",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟢collmex_list_open_items(kind, customer_no, vendor_no, key_date, company_no, ...)

Open items (unpaid invoices) from the Collmex accounting (record OPEN_ITEMS_GET), for customers (receivables, default) or vendors (payables). Returns invoice number, document and due date, days overdue, dunning level, amount, paid and outstanding. Optionally as of a key date.

입력 스키마

{
  "type": "object",
  "properties": {
    "kind": {
      "description": "customer (default) = receivables, vendor = payables.",
      "type": "string",
      "enum": [
        "customer",
        "vendor"
      ]
    },
    "customer_no": {
      "description": "Only this customer number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "vendor_no": {
      "description": "Only this vendor number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "key_date": {
      "description": "Key date (yyyy-mm-dd); default today.",
      "type": "string",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
    },
    "company_no": {
      "description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "limit": {
      "description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit).",
      "type": "integer",
      "minimum": 1,
      "maximum": 500
    },
    "offset": {
      "description": "Records to skip (use next_offset from the previous reply).",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟢collmex_list_accounting_documents(fiscal_year, posting_no, account_no, cost_center, customer_no, ...)

Accounting postings (record ACCDOC_GET), one row per posting position: posting number, date, text, account, debit/credit (0 debit, 1 credit), amount, customer/vendor, invoice number. Filter by fiscal year, account, cost centre, customer, vendor, invoice or document date range. Cancelled postings are excluded unless asked for.

입력 스키마

{
  "type": "object",
  "properties": {
    "fiscal_year": {
      "description": "Fiscal year (for example 2026); default all years.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "posting_no": {
      "description": "Only this posting number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "account_no": {
      "description": "Only this account number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "cost_center": {
      "description": "Only this cost centre.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "customer_no": {
      "description": "Only this customer number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "vendor_no": {
      "description": "Only this vendor number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "invoice_no": {
      "description": "Only this invoice number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "text": {
      "description": "Free text in the posting text and memo (max 80 characters).",
      "type": "string",
      "minLength": 1,
      "maxLength": 80
    },
    "date_from": {
      "description": "Document date from (yyyy-mm-dd).",
      "type": "string",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
    },
    "date_to": {
      "description": "Document date to (yyyy-mm-dd).",
      "type": "string",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
    },
    "include_reversals": {
      "description": "Also return cancelled and cancellation postings.",
      "type": "boolean"
    },
    "company_no": {
      "description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "limit": {
      "description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit).",
      "type": "integer",
      "minimum": 1,
      "maximum": 500
    },
    "offset": {
      "description": "Records to skip (use next_offset from the previous reply).",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟢collmex_get_account_balances(fiscal_year, date_to, account_no, account_group, customer_no, ...)

Account balances from the Collmex accounting (record ACCBAL_GET) for a fiscal year: account number, name and balance. Filter by account, account group (1 other, 2 fixed assets, 3 bank/cash, 4 income, 5 expenses, 6 output VAT, 7 input VAT, 8 receivables, 9 payables, 10 depreciation, 11 provisions, 12 inventory, 13 private, 14 non-deductible expenses), cost centre or an up-to date. With a customer or vendor given, the date is ignored.

입력 스키마

{
  "type": "object",
  "properties": {
    "fiscal_year": {
      "type": "integer",
      "minimum": 1990,
      "maximum": 2100,
      "description": "Fiscal year, for example 2026."
    },
    "date_to": {
      "description": "Balance up to this date (yyyy-mm-dd).",
      "type": "string",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
    },
    "account_no": {
      "description": "Only this account number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "account_group": {
      "description": "Only this account group (1-14).",
      "type": "integer",
      "minimum": 1,
      "maximum": 14
    },
    "customer_no": {
      "description": "Balance of this customer.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "vendor_no": {
      "description": "Balance of this vendor.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "cost_center": {
      "description": "Only this cost centre.",
      "type": "string",
      "minLength": 1,
      "maxLength": 10
    },
    "company_no": {
      "description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "limit": {
      "description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit).",
      "type": "integer",
      "minimum": 1,
      "maximum": 500
    },
    "offset": {
      "description": "Records to skip (use next_offset from the previous reply).",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "required": [
    "fiscal_year"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟢collmex_list_projects(project_no, customer_no, status, company_no, limit, ...)

Collmex projects (record PROJECT_GET) with customer, budget, value of recorded activities, completion state and the project's rates (rate number, description, product, hourly or daily rate).

입력 스키마

{
  "type": "object",
  "properties": {
    "project_no": {
      "description": "Only this project number.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "customer_no": {
      "description": "Only projects of this customer.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "status": {
      "description": "all (default), active or completed.",
      "type": "string",
      "enum": [
        "all",
        "active",
        "completed"
      ]
    },
    "company_no": {
      "description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "limit": {
      "description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit).",
      "type": "integer",
      "minimum": 1,
      "maximum": 500
    },
    "offset": {
      "description": "Records to skip (use next_offset from the previous reply).",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟢collmex_list_activities(project_no, employee_no, date_from, date_to, not_billed, ...)

Recorded time-tracking activities (record ACTIVITIES_GET): project, employee, date, from/to times, breaks, description, and the invoice that billed it. Filter by project, employee (needs company), date range, only not-yet-billed or only invoice-relevant activities.

입력 스키마

{
  "type": "object",
  "properties": {
    "project_no": {
      "description": "Only activities of this project.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "employee_no": {
      "description": "Only activities of this employee number (company_no applies).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "date_from": {
      "description": "Activity date from (yyyy-mm-dd).",
      "type": "string",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
    },
    "date_to": {
      "description": "Activity date to (yyyy-mm-dd).",
      "type": "string",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
    },
    "not_billed": {
      "description": "Only activities not yet invoiced.",
      "type": "boolean"
    },
    "billable_only": {
      "description": "Only activities of customer projects with an amount above zero.",
      "type": "boolean"
    },
    "company_no": {
      "description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "limit": {
      "description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit).",
      "type": "integer",
      "minimum": 1,
      "maximum": 500
    },
    "offset": {
      "description": "Records to skip (use next_offset from the previous reply).",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟡collmex_create_customer(company, salutation, title, first_name, last_name, ...)

WRITE: create a NEW customer in Collmex (record CMXKND without a customer number, so Collmex assigns the next number; an existing customer is never overwritten). Each call creates another customer: check collmex_list_customers first to avoid duplicates. Nothing is sent to the customer. Give at least a company or a last name. Returns the new customer number.

입력 스키마

{
  "type": "object",
  "properties": {
    "company": {
      "description": "Company name.",
      "type": "string",
      "maxLength": 80
    },
    "salutation": {
      "description": "Salutation (for example Herr, Frau).",
      "type": "string",
      "maxLength": 10
    },
    "title": {
      "description": "Title (for example Dr.).",
      "type": "string",
      "maxLength": 10
    },
    "first_name": {
      "description": "First name.",
      "type": "string",
      "maxLength": 40
    },
    "last_name": {
      "description": "Last name.",
      "type": "string",
      "maxLength": 40
    },
    "department": {
      "description": "Department.",
      "type": "string",
      "maxLength": 40
    },
    "street": {
      "description": "Street and house number.",
      "type": "string",
      "maxLength": 40
    },
    "postal_code": {
      "description": "Postal code.",
      "type": "string",
      "maxLength": 10
    },
    "city": {
      "description": "City.",
      "type": "string",
      "maxLength": 40
    },
    "country": {
      "description": "2-letter ISO country code (DE, AT, CH ...).",
      "type": "string",
      "pattern": "^[A-Za-z]{2}$"
    },
    "phone": {
      "description": "Phone.",
      "type": "string",
      "maxLength": 40
    },
    "fax": {
      "description": "Fax.",
      "type": "string",
      "maxLength": 40
    },
    "email": {
      "description": "E-mail address.",
      "type": "string",
      "maxLength": 50
    },
    "remark": {
      "description": "Internal remark.",
      "type": "string",
      "maxLength": 1024
    },
    "vat_id": {
      "description": "EU VAT id.",
      "type": "string",
      "maxLength": 20
    },
    "payment_terms": {
      "description": "Payment terms number (see collmex_list_payment_terms); empty = Collmex default.",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000
    },
    "currency": {
      "description": "3-letter currency code, for example EUR.",
      "type": "string",
      "pattern": "^[A-Za-z]{3}$"
    },
    "company_no": {
      "description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}
🟡collmex_create_address(company, salutation, title, first_name, last_name, ...)

WRITE: create a NEW entry in the Collmex address book (record CMXADR, address type 3, no address number so Collmex assigns one; existing addresses are never overwritten). Each call creates another entry: check collmex_list_addresses first to avoid duplicates. Nothing is sent to the person. Give at least a company or a last name. Returns the new address number.

입력 스키마

{
  "type": "object",
  "properties": {
    "company": {
      "description": "Company name.",
      "type": "string",
      "maxLength": 80
    },
    "salutation": {
      "description": "Salutation (for example Herr, Frau).",
      "type": "string",
      "maxLength": 10
    },
    "title": {
      "description": "Title (for example Dr.).",
      "type": "string",
      "maxLength": 10
    },
    "first_name": {
      "description": "First name.",
      "type": "string",
      "maxLength": 40
    },
    "last_name": {
      "description": "Last name.",
      "type": "string",
      "maxLength": 40
    },
    "department": {
      "description": "Department.",
      "type": "string",
      "maxLength": 40
    },
    "street": {
      "description": "Street and house number.",
      "type": "string",
      "maxLength": 40
    },
    "postal_code": {
      "description": "Postal code.",
      "type": "string",
      "maxLength": 10
    },
    "city": {
      "description": "City.",
      "type": "string",
      "maxLength": 40
    },
    "country": {
      "description": "2-letter ISO country code (DE, AT, CH ...).",
      "type": "string",
      "pattern": "^[A-Za-z]{2}$"
    },
    "phone": {
      "description": "Phone.",
      "type": "string",
      "maxLength": 40
    },
    "fax": {
      "description": "Fax.",
      "type": "string",
      "maxLength": 40
    },
    "email": {
      "description": "E-mail address.",
      "type": "string",
      "maxLength": 50
    },
    "remark": {
      "description": "Internal remark.",
      "type": "string",
      "maxLength": 1024
    },
    "url": {
      "description": "Website.",
      "type": "string",
      "maxLength": 80
    },
    "no_mailings": {
      "description": "Mark as 'no mailings'.",
      "type": "boolean"
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

커뮤니티

이 서버 평가하기

증거

최근 관측

검증됨버전이 기록되지 않음도구 15개