Settlement, reconciliation & API — found from sitemap — Ratepay

Cited by

Facts read from this source

• Settlement file format Report an error

  “Settlement files are generated with every payout and contains a breakdown of the payout, by stating the amounts and occured Ratepay fees for each transaction. These are provided as a csv file.”

• Settlement descriptor field Report an error

  “DESCRIPTOR char(20) Ratepay reference of order Ratepay - DG1234567Z1”

• Settlement shopinvoice field Report an error

  “SHOPINVOICE_ID char(50) Merchant identifier of shop invoice Merchant (based on transmitted <invoice-id> on Payment API 1.8, or partner_invoice_id on Payment API 2.0)”

• Settlement shopsorder field Report an error

  “SHOPSORDER_ID char(50) Merchant identifier of shop order Merchant (based on transmitted <order-id> on Payment API 1.8, or partner_transaction_id on Payment API 2.0) - 12344545abc”

• Settlement feetypes Report an error

  “FEETYPE char(10) ID of type of amount Ratepay 1 - Original amount, return, cancellation, credit memo, additional debit 2 - Disagio 3 - Transaction fee (occur at cancellation or delivery) 4 - Fees for return, cancellation, credit memo, additional debit 5 - Service charge 6 - VAT 7 - Interest cost (monthly fee or similar) 8 - Retransfer / Chargeback/Reassignment”

• Settlement customer group Report an error

  “CUSTOMERGROUP char(10) Customer Group Identifier Ratepay 1 - B2B 2 - B2C 2”

• Settlement known customer Report an error

  “KNOWNCUSTOMER char(1) Customer sent as known regular customer by shop Ratepay 1 - Known customer 0 - Unknown customer 1”

• Settlement product types Report an error

  “PRODUCT char(1) ID describing product Ratepay 1 - INVOICE 2 - INSTALLMENT 3 - DIRECT DEBIT 4 - PREPAYMENT 5 - INSTALLMENT DIRECT DEBIT 1”

• Settlement amount field Report an error

  “AMOUNT decimal(14,2) Amount of position Ratepay (based on captured amounts) - 111.99”

• Settlement accounting reference Report an error

  “REFERENCE_ID_ACCOUNTING char(255) Shop internal accounting number (e. g. from ERP systems), used to reference transaction changes Merchant (based on transmitted <reference-id> on Payment API 1.8, or partner_operation_id on Payment API 2.0) - ABC-123-B”

• Settlement chargeback reasons Report an error

  “CHARGEBACK_REASON char(50) Reason code for the chargeback at dispute process; provided only in case of fee type 8 Ratepay - INR - SUM - SNAD - DEFEND - FRAUD INR”

• API field mapping Report an error

  “based on transmitted <invoice-id> on Payment API 1.8, or partner_invoice_id on Payment API 2.0”

• Settlement doc sections Report an error

  “For Merchants Download Content Example Analyzing settlement report data For Plattform Partners Clearing files Regular customers Merchant invoice Additional resources Data exchange via SFTP”

Scores citing this record

• The Compliance Officer Payment methods & local coverage
• The Compliance Officer Subscriptions & recurring payments
• The Compliance Officer Settlement, reconciliation & API
• The Compliance Officer Pricing transparency
• The E-Commerce Lead Payment methods & local coverage
• The E-Commerce Lead Subscriptions & recurring payments
• The E-Commerce Lead Settlement, reconciliation & API
• The E-Commerce Lead Pricing transparency
• The Payments Engineer Payment methods & local coverage
• The Payments Engineer Subscriptions & recurring payments
• The Payments Engineer Settlement, reconciliation & API
• The Payments Engineer Pricing transparency
• The Finance Lead Payment methods & local coverage
• The Finance Lead Settlement, reconciliation & API
• The Finance Lead Pricing transparency
• The Skeptic Payment methods & local coverage
• The Skeptic Settlement, reconciliation & API
• The Skeptic Pricing transparency
• The SaaS Founder Settlement, reconciliation & API
• The SaaS Founder Pricing transparency