Skip to main content

NCR Counterpoint to iPaaS.com Payment Method Mapping Documentation

Field-level mapping documentation for the NCR Counterpoint Payment Method collections.

NCR Counterpoint to iPaaS.com Payment Method Mapping Documentation

Summary

This mapping collection brings the payment methods maintained in NCR Counterpoint into iPaaS.com. It carries the payment method's code, its readable description, and a classification of what kind of tender it represents — cash, check, credit card, gift card, store credit, and the rest of Counterpoint's tender set.

Deleted Record Support

This family does not itself carry deletions. Where a separate Delete collection exists for this entity it handles removals from Counterpoint to iPaaS.com; otherwise a removal in Counterpoint is not propagated. See NCR Counterpoint Known Limitations.

Mapping Collection Status

  • Status: Enabled. No mapping filter is applied.

  • Trigger Events: see Transfer Methods in the collection description; automatic transfers require the relevant Outbound/Inbound Data Flow subscriptions to be enabled.

System Caveats

NCR Counterpoint Caveats

  • Custom tender codes need a matching translation row before the first transfer: the shipped translation covers every tender code Counterpoint documents for this field. A payment method carrying a code added outside Counterpoint's standard set matches no row, and because PaymentType is required, that payment method is rejected rather than transferred without a type. Subscribers or their MiSP who add custom tender codes should add a matching row before enabling this collection.

  • Stored value cards are reported as cash: Counterpoint records stored value cards under their own tender code, and this collection reports them to iPaaS.com as cash. Two rows therefore produce the same result. Subscribers who need stored value cards distinguished from cash downstream should change the stored-value row's result rather than remove it, and should confirm the value they choose is one iPaaS.com accepts.

iPaaS.com Caveats

  • The set of payment types is fixed: iPaaS.com constrains PaymentType to a fixed set of values. Subscribers editing the translation rows should validate any changed result in a staging environment before relying on it in production, rather than assuming an arbitrary label is accepted.

Integration Flow

  1. No records are transferred as prerequisites for this collection. The records it references are expected to exist already.

  2. The record is sent to iPaaS.com, where subsequent transfers are routed by the external ID recorded on transfer.

Mappings

Add/Update NCR Counterpoint Payment Method TO iPaaS.com

Mapping Type

Source Field (NCR Counterpoint)

Destination Field (iPaaS.com)

Description

Field

PAY_COD

Name

Required. IPaaS.com rejects the payment method without it.

Field

DESCR

Description

Optional. .

Lookup Translation

Lookup Translation — **CP Payment Method PAY_TYP To iPaaS**

PaymentType

Required. IPaaS.com rejects the payment method without it.

Name — Field

Source: PAY_COD · Destination: Name

This is a required field — iPaaS.com rejects the payment method without it. The pay code as maintained in NCR Counterpoint, carried across unchanged and used as the payment method's name in iPaaS.com.

This is the short code subscribers or their MiSP see against the payment method in Counterpoint, not its readable label — the label travels on Description. Counterpoint always supplies it, because it is the payment method's key.

Description — Field

Source: DESCR · Destination: Description

This is an optional field. The payment method's readable description as maintained in NCR Counterpoint, carried across unchanged. It is the label subscribers recognize where Name carries only the code.

PaymentType — Lookup Translation

Source: Lookup Translation — **CP Payment Method PAY_TYP To iPaaS** · Destination: PaymentType

This is a required field — iPaaS.com rejects the payment method without it. Classifies what kind of tender the payment method represents, so that iPaaS.com and any downstream system can reason about the payment without understanding Counterpoint's own codes.

NCR Counterpoint records the kind of tender as a single-letter code on the payment method. This translation converts each of those letters into the wording iPaaS.com uses. Unlike the other mappings in this collection, the value is not read from a Counterpoint column directly — it is produced by matching the code against the rows below.

  • A: A/R — a charge against the customer's account.

  • B: Cash.

  • C: Check.

  • D: Debit Card.

  • E: Credit Card.

  • F: EBT.

  • G: Gift Card.

  • L: Loyalty Points.

  • S: Store Credit.

  • V: Cash — Counterpoint uses this code for a stored value card, which is deliberately reported to iPaaS.com as cash rather than as its own tender type.

Two rows therefore produce Cash: the cash code itself and the stored value card code. That is intended, not a duplicate to be cleaned up. Subscribers who need stored value cards distinguished from cash downstream should change the V row's result rather than remove it, and should confirm the value they choose is one iPaaS.com accepts.

The rows cover every tender code Counterpoint documents for this field, so a payment method that matches none of them indicates a code added outside Counterpoint's standard set. Because PaymentType is required, such a payment method is rejected rather than transferred without a type. Subscribers or their MiSP who add custom tender codes must add a matching row here before the first transfer.

iPaaS.com constrains this field to a fixed set of payment types. Subscribers editing these rows should validate any changed result in a staging environment before relying on it in production, rather than assuming an arbitrary label is accepted.

Error Handling

Errors raised while transferring these records surface at Dashboard / Integration Monitoring / Error Logs. The specific messages, their causes and their resolutions are documented in NCR Counterpoint Error Messages. A record stopped by an error is not retried automatically; it must be resolved manually.

Testing & Validation

  1. Replace every placeholder value called out above with one from the target Counterpoint installation, and confirm each exists in Counterpoint.

  2. Transfer a single record through Manual Sync and confirm it appears in Counterpoint as expected.

  3. Confirm any child records transferred with the parent.

  4. Enable the relevant triggers and confirm a new record transfers automatically, and that a change updates the same Counterpoint record rather than creating a second one.

  5. Attempt a transfer with a missing required field and confirm the expected error appears at Dashboard / Integration Monitoring / Error Logs.


Related Documents

Did this answer your question?