iPayment Table Cheatsheet

Here's an overview of each table in iPayment and a short description of what they contain.

BOY_E0_ADDCCR - Add Credit Card Requests.

Contains requests for the Add Credit Card Link system.

BOY_E0_AUTH_DATAST - Gateway transactions (Auths/Settlements)

Very useful when debugging. Contains information on all transactions performed to the gateway on a document level, with gateway status, amounts etc.

BOY_E0_BPCCL - Old Add Credit Card lnik table [No longer used]

Contains requests used for the Trust Payments (Secure Trading) add credit card links. When the new generic Add Credit Card system was built, this was replaced.

BOY_E0_BPEXT - Business Partner extended

Contains the 'customer profile' identifier for Authorize.Net and ProPay. Also contains the token of the default credit card for each business partner, if a default has been selected.

BOY_E0_CC_MAPPING - Credit card mapping configuration

Contains information on the credit card mapping between iPayment credit card types and SAP card types. This is also configured on the configuration screen.

BOY_E0_CONFIG - Configuration

Contains data relating to the configuration screen. Most configurations are shared between gateways, but some are exclusive for each gateway.

BOY_E0_CREDITCAEX - Credit card tokens

Very useful when debugging. Contains information on the BP credit cards. Address data, card type, token etc.

BOY_E0_CYB_TOKENR - Cybersource token requests

Contains requests used when adding credit cards on Cybersource.

BOY_E0_DEL_CRE_CAR - Deleted credit cards

Contains the token for deleted credit cards.

BOY_E0_DOC_STATUS - Document status

Sometimes needed for debugging. Contains the status for iPayment status for each document that has been associated with a transaction. The document status shown in the header in SAP is based on this table.

BOY_E0_IMQ - Internal message queue

Contains Internal Messages that have not yet been sent.

BOY_E0_IMR - Internal message recipients

Contains information on which users are configured to receive internal messages.

BOY_E0_LOG - Log table

Contains various logging information from within iPayment. Usually the eventlog is more useful for debugging.

BOY_E0_LOGARCH - Log archive

Contains archived logging data. These entries are moved from the log table to the log archive table when the "Archive log entries" feature inside iPayment is used.

BOY_E0_OTCC - One-Time credit cards

Similar to BOY_E0_CREDITCAEX, except it contains data of one-time cards.

BOY_E0_OTCCL - One-Time credit card links

Contains One-time credit card link requests.

BOY_E0_OTCCP - One-time credit card incoming payments

Contains OTC information for incoming payments using one-time cards.

BOY_E0_OTCINTE - Integration table

Useful when debugging OTC integration issues. Allows the user to do integrations from 3rd party applications to import credit card tokens and authorizations into iPayment for further processing.

BOY_E0_PAYNOWR - Pay-Now link requests

Contains requests for the Pay Now Link system. 

BOY_E0_PT_CONFIG - Payment terms configuration

Contains PT configurations. If there's no entry for a given Payment Term that means nothing has been defined, and the default will be used.

BOY_E0_REFUND_ST - Refund status

Contains statuses and details on refund transactions. In case of CFT (direct) refunds, the transaction/document won't be listed in BOY_E0_AUTH_DATAST.

BOY_E0_SCHEDULE - Scheduled actions

Contains all of the scheduled actions configured through the scheduler.

BOY_E0_TEMPLATE - Batch filter templates

Contains batch filter templates, which the batch filter wizards use to save filter configurations.

BOY_E0_TNL - Transaction notification log