Returns a list of payments.

/cnbs/v1/invoices/payments

GET

• Payer (payer_data)
  • Payer Number (customer_number)
  • Company Code (company_code)
• Parameters (search_parameters)
  • Document type (document_type)
    • 02 … Payments
  • Date From (date_from)
    • Refers to posting date in the backend.
    • Format MM-DD-YYYY
  • Date To (date_to)
    • Refers to posting date in the backend.
    • Format MM-DD-YYYY

• Parameters (search_parameters)
  • Filter Table (filter)
    • Table with 2 rows where filter_type is the filter type and value is the respective filter value.
      • Standard Filter Types:
        • 01 … SD document number
        • 02 … FI document number
      • Custom Filter Types:
        • 90-99 … Custom Filters can be implemented on a project basis and require a custom implementation in the backend as well.

cURL:

curl -X GET "https://deveselling.cnbssoftware.com/cnbs/v1/invoices/payments?sap-client=800&sap-language=EN&apiid=CNBSMV01R&payer_number=3050&company_code=3000&document_type=02&date_from=12-18-2023&date_to=12-31-2099" -H  "accept: application/json" -H  "cnbssysid: W1B//vRKywJ2sPUVQG4CQ16Sf9XSN+N4Fkc6Bfmky3k="

The response consists of a payment list table (payment_list) and a status (status). The payment list table contains a sub table returning the related sales invoices (sd_invoices).
Hint: The sd_invoices will only be filled, if the payment is related to an SD invoice. e.g. a deposit payment will not have any related SD invoices!

• Payment List (payment_list)
  • Finance Document Number (document_number_finance)
    • Contains the document number under which the transaction is recorded in the financial accounting ledger.
  • Finance Document Type (finance_document_type)
    • Contains the financial accounting document type.
  • Clearing Document Number (clearing_document_number_finance)
    • Contains the clearing document number from financial accounting.
  • Reference Document Number (reference_number)
    • Contains the Reference Document Number found in the header of the financial accounting document.
  • Document Fiscal Year (fiscal_year_of_the_relevant invoice)
    • Contains the Fiscal Year when the related document got recorded.
  • Payer Number (payer_number)
    • Number of the payer customer.
  • Posting Date (posting_date)
    • Contains the posting date used in the financial accounting ledger.
  • Document Date (document_date)
    • Contains the document date used in the financial accounting ledger.
  • Currency (currency_key)
    • Document currency key.
  • Paid Amount (paid_amount)
    • Amount of the payment document.
  • Item text (item_text)
    • Item text of financial accounting ledger document item.
  • Authorization Number (authorization_number)
  • Authorization Reference Code (authorization_reference_code)
  • Authorization Amount (authorization_amount)
  • Payment Method (payment_method)
    • CC … Credit Card
    • EC … E-Check
  • Payment Card Type (payment_card_type)
    • Payment card type used for this transaction.
  • Payment Card Token (payment_card_token)
    • Tokenized payment card.
  • Payment Card Name (payment_card_name)
    • Full name of the payment card holder.
  • Payment Card Valid-To (valid_to)
    • Expiry date of the payment card.
  • Sales invoces (sd_invoices)
    • Billing Document Number (billing_document_number)
      • Contains the billing document number.
    • Billing Document Type (billing_document_type)
      • Contains the billing document type of the billing document.
    • Sales Organization (sales_organization)
    • Distribution Channel (distribution_channel)
    • Division (division)
    • Reference Document Number (reference_number)
      • Contains the Reference Document Number found in the header of the financial accounting document.
    • Currency (currency_key)
      • Document currency key.
    • Currency (currency_key)
      • Document currency key.
    • Sold-to (soldto_number)
    • Document Date (document_date)
      • Contains the document date used in the financial accounting ledger.
    • Due Date (due_date)
      • Net due date of this line item.
    • Clearing Date (clearing_date)
      • Clearing date of the line item. Date when the item got flagged as completed in financial accounting.
    • Days in arrears (days_in_arrears)
      • Number of overdue days.
      • Total amount (total_amount)
        • Total amount of the line item.
      • Paid amount (paid_amount)
        • Amount already paid for the line item.
      • Current Paid amount (current_paid_amount)
        • Amount paid related to the current payment.
    • PDF field
      • PDF Document Available(pdf_document_available)
        • If this flag is set a PDF can be retrieved for this line item.
• Status (status)
  • Message Type (message_type)
    • SAP Message Type.
      • Errors:
        • E = Error
        • A = Abort
        • X = Exception
      • Others:
        • S = Success
        • W = Warning
        • I = Information
  • Message Identifier (message_identification)
    • SAP Message ID.
  • Message Number (message_number)
    • SAP Message Number.
  • Message Line (message_line_string)
    • SAP Message Text.

JSON:

{
  "payment_list": [
    {
      "document_number_finance": "1400004405",
      "finance_document_type": "DZ",
      "clearing_document_number_finance": "1400004405",
      "reference_number": "CNBS WEBAR REF",
      "fiscal_year_of_the_relevant_invoice": 2023,
      "payer_number": "0000003050",
      "posting_date": "12-18-2023",
      "document_date": "12-18-2023",
      "currency_key": "USD",
      "paid_amount": -787.99,
      "item_text": "CNBS WEBAR CLR",
      "authorization_number": "XI00",
      "authorization_reference_code": "300903317",
      "authorization_amount": 787.99,
      "payment_method": "CC",
      "payment_card_type": "VISA",
      "payment_card_token": "-E803-0002-PH3AE4RZAK831S",
      "payment_card_name": "Test",
      "valid_to": "07-31-2025",
      "sd_invoices": [
        {
          "billing_document_number": "0090040888",
          "billing_document_type": "F2",
          "sales_organization": "3000",
          "distribution_channel": "10",
          "division": "00",
          "reference_number": "0090040888",
          "currency_key": "USD",
          "posting_date": "05-05-2022",
          "document_date": "05-05-2022",
          "due_date": "06-04-2022",
          "clearing_date": "12-18-2023",
          "days_in_arrears": 563,
          "total_amount": 117.99,
          "paid_amount": 117.99,
          "pdf_document_available": "X"
        },
        {
          "billing_document_number": "0090040879",
          "billing_document_type": "L2",
          "sales_organization": "3000",
          "distribution_channel": "10",
          "division": "00",
          "reference_number": "0090040879",
          "currency_key": "USD",
          "posting_date": "06-01-2022",
          "document_date": "06-01-2022",
          "due_date": "07-01-2022",
          "clearing_date": "12-18-2023",
          "days_in_arrears": 536,
          "total_amount": 670,
          "paid_amount": 670,
          "pdf_document_available": "X"
        }
      ]
    }
  ],
  "status": {
    "message_type": "S",
    "message_identification": "/CNBS/X_API",
    "message_number": 10,
    "message_line_string": "Request successfully processed 1"
  }
}