# Operator DSP Consolidated source: https://developer.mastercard.com/account-to-account-commerce-for-dsp/documentation/tutorials-and-guides/standard-reports/operator-dsp-consolidation-report/index.md ## Overview {#overview} Consolidated report provided to the Operator. It contains a report for all activities for all DSPs enrolled in the program. ## Report Attributes {#report-attributes} | Report Identifier | ZAPP_REP363 | |-------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | Report Version | V1.0 | | Report Name | Operator DSP Consolidated | | File Name | *DSP_Consolidated_ZAPP_REP363* **\** ***\*** **\** .xml Example: DSP_Consolidated_ZAPP_REP363_operatorId_RECON1101202301_1.xml **\** is the Operator Identifier for which the report is produced **\** is the Reconciliation Cycle ID for which the report is produced **\** is the file sequence number. | | Frequency | DAILY | | Retention Period | 30 days | ## Report Layout {#report-layout} | Section | Seq | Elements/XML Node | Datatype | Multiplicity | Description | Example | |--------------|------|-------------------------------|------------|--------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------| | Root Element | + | operatorConsolDspReport | | 1..1 | This report includes single immediate payment, payment with agreement, agreement, and refund transactions for all DSPs of an operator | | | Header | ++ | header | | 1..1 | | | | | +++ | rptId | Max6Text | 1..1 | Report identifier and value will always be REP363. | REP363 | | | +++ | rptName | Max50Text | 1..1 | Report name and value will always be OperatorDSPConsolidateReport. | OperatorDSPConsolidateReport | | | +++ | rptDateTime | Max24Text | 1..1 | Report creation date time in UTC format. | 2022-11-21T05:15:24.465Z | | | +++ | rptPeriodFrom | Max24Text | 1..1 | Report period start date time in UTC format. | 2022-11-20T00:00:00.000Z | | | +++ | rptPeriodTo | Max24Text | 1..1 | Report period end date time in UTC format. | 2022-11-20T23:59:59.999Z | | | +++ | reconCycleId | Max15Text | 1..1 | Reconciliation cycle identifier assigned by Mastercard for the report. Note\*: Last 2 digits indicate sequence of report chunks. | RECON1104202201 | | Details | ++ | paymentRequestRecords | | 0..1 | | | | | +++ | paymentRequest | | 1..n | | | | | ++++ | debtorServiceProviderId | Max35Text | 1..1 | Identifier assigned to the debtor service provider by Mastercard. | 000007 | | | ++++ | paymentRequestLifecycleId | Max35Text | 1..1 | A unique identifier assigned by Mastercard, to identify the payment request in subsequent transactions or services. | 23123123123123100 | | | ++++ | businessType | Number | 1..1 | A unique identifier assigned by Mastercard to define the commercial product construct that uses this service. This value is provided to participants through documentation. | 2 | | | ++++ | paymentRequestType | Exact4Text | 1..1 | Set by the Creditor/Creditor Service Provider to define the settlement type of the Payment Request. | IMDT | | | ++++ | purpose | Max35Text | 1..1 | Set by Creditor/Creditor Service Provider to indicate the underlying reason for the Payment Request. | ONLN | | | ++++ | categoryPurpose | Max35Text | 1..1 | Set by the Creditor to allow the Creditor Service Provider or Debtor Service Provider to offer specific processing agreed with the Creditor. | MTOM | | | ++++ | creditorTradeName | Max35Text | 1..1 | Name used by the Creditor in dealing with customers, which may not be the same as the one it uses for legal purposes. | VerizonoMobileLtd | | | ++++ | instructionId | Max60Text | 1..1 | Unique identifier for the transaction assigned by the transaction initiator Creditor Service Provider to assist with identifying a transaction uniquely. | 98dj4eab35a542e085add0363a40jk564 | | | ++++ | endToEndId | Max35Text | 1..1 | A unique identifier assigned by Creditor to identify Payment Request in their system. This identification is passed on, unchanged, throughout the entire end-to-end chain. | 7jhg5eab35a542e085add0363a4423o6 | | | ++++ | debtorId | Max35Text | 1..1 | A unique identifier of the Debtor provided to Mastercard by the Debtor Service Provider. | Fxrsi5345 | | | ++++ | agreementId | Max35Text | 0..1 | A unique identifier assigned by Mastercard, to the agreement, to be used in Payment Requests for routing them to the destined party. | 3e2a749088440eab8b40c926efe2931 | | | ++++ | agreementType | Max4Text | 0..1 | Agreement Type of the payment request made with agreement. | AOF | | | ++++ | transactionCreationDateTime | Max24Text | 1..1 | ISO 8601 format date and time in Coordinated Universal Time (UTC) when the Payment Request was created. | 2022-11-20T23:59:59.999Z | | | ++++ | currency | Exact3Text | 1..1 | Curreny in which the payment was processed. ISO 4217 code for Currency. | PHP | | | ++++ | amount | Number | 1..1 | Amount value processed in the payment and contains upto 2 decimal digits. | 100.25 | | | ++++ | paymentRequestStatus | Exact4Text | 1..1 | Status of the Payment Request returned by Mastercard. | APPR | | | ++++ | paymentStatusReason | Exact4Text | 0..1 | Reason for declined transaction. | FRDS | | | ++++ | clearingSystem | Max35Text | 0..1 | The clearingSystem (may vary by country) used to settle the authorised transactions. | Instapay | | | ++++ | paymentReference | Max42Text | 0..1 | Unique Payment Reference of the real time settlement method provided by Debtor Service Provider. | 749088440eab | | | ++++ | strongCustomerAuthentication | Exact1Text | 0..1 | When opted as 'True' by Creditor for a payment request, the Debtor Service Provider will be notified that Creditor requested step-up authentication by the Debtor. | N | | | ++++ | stepUpAuthenticationInitiated | Exact1Text | 0..1 | Indicates if the Debtor Service Provider initiated Stepup for payment request with agreement. | N | | | ++++ | statusRequestFlag | Exact1Text | 0..1 | Flag which indicates whether status enquiry was done for this payment request. | N | | | ++ | refundRequestRecords | | 0..1 | | | | | +++ | refundRequest | | 1..n | | | | | ++++ | debtorServiceProviderId | Max35Text | 1..1 | Identifier assigned to the debtor service provider by Mastercard. | 000007 | | | ++++ | refundRequestLifecycleId | Max35Text | 1..1 | A unique identifier assigned by Mastercard, to identify the refund request in subsequent transactions or services. | 464684551569746789 | | | ++++ | refundRequestDateTime | Max24Text | 1..1 | ISO 8601 format date and time in Coordinated Universal Time (UTC) when the Refund Request was created. | 2022-12-02T23:59:59.99Z | | | ++++ | paymentRequestLifecycleId | Max35Text | 1..1 | A unique identifier assigned by Mastercard, to identify the payment request in subsequent transactions or services. | 23123123123123100 | | | ++++ | paymentRequestDateTime | Max24Text | 1..1 | ISO 8601 date and time when this particular transaction was created, which may be the same as the creation date time of the Payment Request message provided by Creditor Service Provider. | 2022-11-20T23:59:59.999Z | | | ++++ | paymentAmount | Number | 1..1 | Amount value instructed in the Payment. | 100.25 | | | ++++ | businessType | Number | 1..1 | A unique identifier assigned by Mastercard to define the commercial product construct that uses this service. This value is provided to participants through documentation. | 2 | | | ++++ | paymentRequestType | Exact4Text | 1..1 | Set by the Creditor/Creditor Service Provider to define the settlement type of the Payment Request. | IMDT | | | ++++ | purpose | Max35Text | 1..1 | Set by Creditor/Creditor Service Provider to indicate the underlying reason for the Payment Request. | ONLN | | | ++++ | categoryPurpose | Max35Text | 1..1 | Set by the Creditor to allow the Creditor Service Provider or Debtor Service Provider to offer specific processing agreed with the Creditor. | MTOM | | | ++++ | debtorId | Max35Text | 1..1 | A unique identifier of the Debtor provided to Mastercard by the Debtor Service Provider. | Fxrsi5345 | | | ++++ | debtorAccountType | Number | 0..1 | Flag which need to hold the debtor account type. | 1 | | | ++++ | refundPaymentReference | Max42Text | 1..1 | Unique refund payment Reference of the real time settlement method provided by CSP. | y18dvGsj3GJ57Tt | | | ++++ | refundReason | Max25Text | 1..1 | Identifies the reason for the refund, such as whether a refund is the result of a query or dispute case. | DISPUTES | | | ++++ | refundRequestStatus | Exact4Text | 1..1 | Indicates whether the Debtor Service Provider was able to provide the account details or not.Will contains only APPR/ DECL values. | APPR | | | ++++ | refundRequestStatusReason | Exact4Text | 0..1 | Reason for declined transaction. | SYSM | | | ++++ | currency | Exact3Text | 1..1 | Curreny in which the payment was processed. ISO 4217 code for Currency. | PHP | | | ++++ | refundAmount | Number | 1..1 | Amount value processed in the Refund. | 100.25 | | | ++++ | caseReferenceId | Max35Text | 0..1 | CaseReferenceId generated by Dispute Management System to be populated when the refund is a result of dispute. This should be populated only when the value for refundReason is DISPUTES. | 2324252627 | | | ++++ | creditorTradeName | Max35Text | 1..1 | Name used by the Creditor in dealing with customers, which may not be the same as the one it uses for legal purposes. | VerizonoMobileLtd | | | ++++ | creditorRefundReference | Max35Text | 0..1 | Identifier assigned for the refund transaction by the Creditor or Creditor Service Provider. | 454647894521236 | | | ++++ | statusRequestFlag | Exact1Text | 0..1 | Flag which indicates whether status enquiry was done for this refund request. | N | | | ++++ | retrievalRequestStatus | Max35Text | 0..1 | Informs the status of the Retrieval Request. | WFPC | | | ++ | agreementRequestRecords | | 0..1 | | | | | +++ | agreementRequest | | 1..n | | | | | ++++ | debtorServiceProviderId | Max35Text | 1..1 | Identifier assigned to the debtor service provider by Mastercard. | 000007 | | | ++++ | agreementId | Max35Text | 1..1 | A unique identifier assigned by Mastercard, to the agreement, to be used in Payment Requests for routing them to the destined party. | a3e2a749088440eab8b40c926efe2931 | | | ++++ | agreementType | Max4Text | 1..1 | Set by Creditor Service Provider or Debtor Service Provider to specify Agreement Type in AgreementRequest. | AOF | | | ++++ | agreementStatus | Max35Text | 1..1 | Specifies the status of the agreement, in a coded form. | APPR | | | ++++ | agreementStatusReason | Max35Text | 0..1 | Reason for declined agreement. | SYSP | | | ++++ | debtorId | Max35Text | 1..1 | A unique identifier of the Debtor provided to Mastercard by the Debtor Service Provider. | Fxrsi5345 | | | ++++ | creationDateTime | Max24Text | 1..1 | ISO 8601 format date and time in Coordinated Universal Time (UTC) when the Refund Request was created. | 2022-12-02T23:59:59.999Z | | | ++++ | creditorTradeName | Max35Text | 1..1 | Name used by the Creditor in dealing with customers, which may not be the same as the one it uses for legal purposes. | VerizonoMobileLtd | | | ++++ | statusRequestFlag | Exact1Text | 0..1 | Flag which indicates whether status enquiry was done for this Agreement request. | N | | Footer | ++ | footer | | 1..1 | | | | | +++ | totals | | 1..1 | | | | | ++++ | RecordCount | Number | 1..1 | Total number of refund records in the report. | 25 | [Back](https://developer.mastercard.com/account-to-account-commerce-for-dsp/documentation/tutorials-and-guides/standard-reports/index.md)