> ## Documentation Index
> Fetch the complete documentation index at: https://docs.gr4vy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Settlement report Chase Orbital mapping

<Warning>This integration is currently in beta and the exact mapping of fields might still change.</Warning>

First, contact the Chase Orbital representative to enable Delimited File Reports (DFR) with the following considerations:

1. The report must be delivered via SFTP.
2. The following report types need to be enabled:
   1. **ACT0010 Deposit Detail Financial Report**
   2. **PDE0017 Chargeback Activity Exception Report**

After SFTP access has been set up, SFTP credentials are received from Chase Orbital. These credentials are used when enabling settlement reporting in the Chase Orbital connector configuration in the dashboard.

To set up these credentials, please go to the "Connections" tab, select the Chase Orbital connector and navigate to the "Settlement" tab.
Here settlement reporting can be enabled, after which prompts are provided to fill out the following:

1. The SFTP username.
2. The SFTP password.
3. The SFTP address, as a URL that starts with `sftp://`, for example `sftp://sftp.example.com:22`. The port is optional and defaults to `22`. An address without the `sftp://` scheme isn't recognized, and settlement reports aren't imported.

Below is the mapping of Chase Orbital's reports to the settlement report. This data is pulled from Chase Orbital's Delimited File Report (DFR).

**ACT0010 Deposit Detail Financial Report**:

| Settlement report | Chase Orbital field? | Chase Orbital report |
| :- | :- | :- |
| `payment_service_transaction_reconciliation_id` | Yes | `Merchant Order #` (only for `settlement`) |
| `transaction_id` | No | - |
| `payment_service_transaction_id` | Yes | Always `null` |
| `payment_service_id` | No | - |
| `payment_service_definition_id` | No | - |
| `payment_service_display_name` | No | - |
| `journal_type` | Yes | Check journal type mapping table below |
| `raw_journal_type` | Yes | `Record Type \| Action Code` |
| `payment_service_transaction_created_at` | Yes | Always `null` |
| `posted_at` | Yes | `Report Generation Date` + 12 hours |
| `processing_amount_plain` | Yes | Always `null` |
| `processing_currency` | Yes | Always `null` |
| `exchange_rate` | Yes | Always `null` |
| `currency` | Yes | Standardized value of `Presentment Currency` |
| `gross_credit_plain` | Yes | `Amount` for `settlement`, `0` otherwise |
| `net_credit_plain` | Yes | `Amount` for `settlement`, `0` otherwise |
| `gross_debit_plain` | Yes | `(-1) * Amount` for `refund`, `0` otherwise |
| `net_debit_plain` | Yes | `(-1) * Amount` for `refund`, `0` otherwise |
| `fee_markup_plain` | Yes | Always `null` |
| `fee_interchange_plain` | Yes | Always `null` |
| `fee_scheme_plain` | Yes | Always `null` |
| `fee_total_plain` | Yes | Always `0` |
| `method` | Yes | Standardized value of `MOP` |
| `raw_method` | Yes | `MOP` |
| `scheme` | Yes | Standardized value of `MOP` |
| `raw_scheme` | Yes | `MOP` for card transactions, `null` otherwise |
| `batch` | Yes | Always `null` |
| `report_id` | No | - |
| `raw_report_ids` | No | - |
| `ingested_at` | No | - |
| `description` | Yes | Always `null` |
| `transaction_external_identifier` | No | - |
| `transaction_metadata` | No | - |
| `report_payment_service_id` | No | - |
| `report_payment_service_definition_id` | No | - |
| `report_payment_service_display_name` | No | - |
| `payment_service_modification_reference` | Yes | Always `null` |
| `payment_service_refund_reconciliation_id` | Yes | `Merchant Order #` (only for `refund`) |
| `refund_external_identifier` | No | - |

**PDE0017 Chargeback Activity Exception Report**:

| Settlement report | Chase Orbital field? | Chase Orbital report |
| :- | :- | :- |
| `payment_service_transaction_reconciliation_id` | Yes | `Merchant Order #` |
| `transaction_id` | No | - |
| `payment_service_transaction_id` | Yes | Always `null` |
| `payment_service_id` | No | - |
| `payment_service_definition_id` | No | - |
| `payment_service_display_name` | No | - |
| `journal_type` | Yes | Check journal type mapping table below |
| `raw_journal_type` | Yes | `Record Type \| Category` |
| `payment_service_transaction_created_at` | Yes | Always `null` |
| `posted_at` | Yes | `Report Generation Date` + 12 hours |
| `processing_amount_plain` | Yes | Always `null` |
| `processing_currency` | Yes | Always `null` |
| `exchange_rate` | Yes | Always `null` |
| `currency` | Yes | Standardized value of `Presentment Currency` |
| `gross_credit_plain` | Yes | `(-1) * Amount` for `Chargeback Reversal`, `0` otherwise |
| `net_credit_plain` | Yes | `(-1) * Amount` for `Chargeback Reversal`, `0` otherwise |
| `gross_debit_plain` | Yes | `Amount` for `Chargeback`, `0` otherwise |
| `net_debit_plain` | Yes | `Amount` for `Chargeback`, `0` otherwise |
| `fee_markup_plain` | Yes | Always `null` |
| `fee_interchange_plain` | Yes | Always `null` |
| `fee_scheme_plain` | Yes | Always `null` |
| `fee_total_plain` | Yes | Always `0` |
| `method` | Yes | Standardized value of `MOP` |
| `raw_method` | Yes | `MOP` |
| `scheme` | Yes | Standardized value of `MOP` |
| `raw_scheme` | Yes | `MOP` for card transactions, `null` otherwise |
| `batch` | Yes | Always `null` |
| `report_id` | No | - |
| `raw_report_ids` | No | - |
| `ingested_at` | No | - |
| `description` | Yes | `Reason Code` |
| `transaction_external_identifier` | No | - |
| `transaction_metadata` | No | - |
| `report_payment_service_id` | No | - |
| `report_payment_service_definition_id` | No | - |
| `report_payment_service_display_name` | No | - |
| `payment_service_modification_reference` | Yes | Always `null` |
| `payment_service_refund_reconciliation_id` | Yes | Always `null` |
| `refund_external_identifier` | No | - |

### Notes

The `posted_at` value provided is an approximation, as the original report does not report this value with a time part.

### Journal type mapping

| Chase Orbital raw journal type | Journal type |
| :- | :- |
| `RACT0010 \| DP` | `settlement` |
| `RACT0010 \| RF` | `refund` |
| `RPDE0017D \| RECD` | `chargeback` |
| `RPDE0017D \| REPR` | `chargeback_reversal` |
| `RPDE0017D \| OPAACCEPT` | `chargeback_reversal` |

<Note>
  Fields marked as not a **Chase Orbital field** are populated from
  internal data and not from the imported payment service report.
</Note>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.