Field Mapping The tables below map corresponding report fields in the Classic Business Center to report fields in the New Business Center, This information will help you to create reports in the New Business Center that resemble the reports available in the Classic Business Center. The tables show the Simple Order API and SCMP API field names along with the corresponding name in the new reports. Reports listed below are either: ■ Commonly used reports such as the Transaction Request Report that are of interest to most users. ■ Replacements for recently retired reports such as the Chargeback and Representment Details Report, found under Merchant Account Reports. Users of the Custom Reports module can create reports that run on a frequency and schedule that best suits their needs. Transaction Request Report Table 7 Field Mapping for the Transaction Request Report Classic Business Center CSV Fields (SCMP API) Classic Business Center XML Fields (SO API) New Business Center Fields Required/Optional ics_applications Name Name Optional auth_rcode auth_reversal_rcode bill_rcode credit_rcode ecp_debit_rcode ecp_credit_rcode score_rcode tax_rcode dav_rcode export_rcode elc_rcode elc_revoke_rcode download_rcode create_isv_rcode add_value_to_isv_rcode get_isv_history_rcode get_isv_info_rcode get_isv_profiles_rcode modify_isv_rcode redeem_isv_rcode Rcode Rcode Optional auth_rflag auth_reversal_rflag bill_rflag credit_rflag ecp_debit_rflag ecp_credit_rflag score_rflag tax_rflag dav_rflag export_rflag elc_rflag elc_revoke_rflag download_rflag create_isv_rflag add_value_to_isv_rflag get_isv_history_rflag get_isv_info_rflag get_isv_profiles_rflag modify_isv_rflag redeem_isv_rflag Rflag Rflag Optional auth_rmsg auth_reversal_rmsg bill_rmsg credit_rmsg ecp_debit_rmsg ecp_credit_rmsg score_rmsg tax_rmsg dav_rmsg export_rmsg elc_rmsg elc_revoke_rmsg download_rmsg create_isv_rmsg add_value_to_isv_rmsg get_isv_history_rmsg get_isv_info_rmsg get_isv_profiles_rmsg modify_isv_rmsg redeem_isv_rmsg Rmsg Rmsg Optional bill_address1 Address1 Address1 Optional bill_address2 Address2 Address2 Optional bill_city City City Optional company_name CompanyName CompanyName Optional bill_country Country Country Optional customer_id CustomerID CustomerID Optional customer_email Email Email Optional customer_firstname FirstName FirstName Optional customer_hostname HostName HostName Optional customer_ipaddress IPAddress Optional customer_lastname LastName LastName Optional customer_middlename MiddleName MiddleName Optional customer_loyalty — — — customer_password_pprovided — — — customer_promotions — — — — NameSuffix NameSuffix Optional — PersonalID PersonalID Optional — Phone Phone Optional bill_state State State Optional customer_title Title Title Optional — UserName UserName Optional bill_zip Zip Zip Optional — FulfillmentType FulfillmentType Optional — InvoiceNumber InvoiceNumber Optional — MerchantProductSKU MerchantProductSKU Optional — — Number Optional — ProductCode ProductCode Optional — ProductName ProductName Optional — Quantity Quantity Optional — TaxAmount TaxAmount Optional — field1-field20 Field1-Field20 Optional — — AAV_CAVV Optional — ACHVerificationResult ACHVerificationResult Optional — ACHVerificationResultMapped ACHVerificationResultMapped Optional — AFTIndicator — — — Amount Amount Optional auth_code AuthorizationCode AuthorizationCode Optional — AuthorizationType AuthorizationType Optional avs — — — auth_auth_avs — — — — AVSResult AVSResult Optional — AVSResultMapped AVSResultMapped Optional — BalanceAmount BalanceAmount Optional — BalanceCurrencyCode BalanceCurrencyCode Optional — — BankAccountName Optional — — BankCode Optional — BinNumber BinNumber Optional — BoletoBarCodeNumber BoletoBarCodeNumber Optional currency CurrencyCode CurrencyCode Optional cv — — — auth_cv_result CVResult CVResult Optional — — DCCIndicator Optional — EMVServiceCode — — — N//A ECI Optional — EVEmail EVEmail Optional — EVEmailRaw EVEmailRaw Optional — EventType EventType Optional — EVName EVName Optional — EVNameRaw EVNameRaw Optional — EVPhoneNumber EVPhoneNumber Optional — EVPhoneNumberRaw EVPhoneNumberRaw Optional — EVPostalCode EVPostalCode Optional — EVPostalCodeRaw EVPostalCodeRaw Optional — EVStreet EVStreet Optional — EVStreetRaw EVStreetRaw Optional — — ExchangeRate Optional — — ExchangeRateDate Optional — GrandTotal GrandTotal Optional — InstallmentSequence — — — NetworkTransactionID NetworkTransactionID Optional — NumberOfInstallments NumberOfInstallments Optional — PayerAuthenticationInfo — — payment_processor PaymentProcessor PaymentProcessor Optional — PaymentRequestID PaymentRequestID Optional — PaymentType — — — ProcessorResponseCode ProcessorResponseCode Optional — ProcessorResponseID ProcessorResponseID Optional — ProcessorTID ProcessorTID Optional — RequestedAmount RequestedAmount Optional — RequestedAmountCurrencyCode RequestedAmountCurrencyCode Optional — SenderReferenceID — — — — TargetAmount Optional — — TargetCurrency Optional — TotalTaxAmount TotalTaxAmount Optional — — XID Optional payment_method — — — account_suffix AccountSuffix AccountSuffix Optional — BoletoNumber BoletoNumber Optional — CardCategory CardCategory Optional — CardCategoryCode CardCategoryCode Optional — CardType CardType Optional — — CheckNumber Optional customer_cc_expmo ExpirationMonth ExpirationMonth Optional customer_cc_expyr ExpirationYear ExpirationYear Optional customer_cc_issue_number IssueNumber IssueNumber Optional — — MandateId Optional — — MandateType Optional — — SignatureDate Optional customer_cc_startmo StartMonth StartMonth Optional customer_cc_startyr StartYear StartYear Optional — Type — — — SubType — — — ProfileDecision ProfileDecision Optional — ProfileMode ProfileMode Optional — RuleName RuleName Optional — RuleDecision — — — Comments Comments Optional — eCommerceIndicator eCommerceIndicator Optional merchant_id — MerchantID Required merchant_ref_number MerchantReferenceNumber MerchantReferenceNumber Optional — PredecessorRequestID — — — RequestDate — — request_id RequestID RequestID Required source Source Source Optional subscription_id SubscriptionID SubscriptionID Optional — — — — transaction_date — TransactionDate Required — TransactionReferenceNumber TransactionReferenceNumber Optional — TokenProvider — — — User User Optional — AppliedAVS AppliedAVS Optional — AppliedCV AppliedCV Optional applied_category_gift AppliedCategoryGift AppliedCategoryGift Optional applied_category_time AppliedCategoryTime AppliedCategoryTime Optional applied_host_hedge AppliedHostHedge AppliedHostHedge Optional applied_score_threshold AppliedThreshold AppliedThreshold Optional applied_time_hedge AppliedTimeHedge AppliedTimeHedge Optional applied_velocity_hedge AppliedVelocityHedge AppliedVelocityHedge Optional — BinAccountType BinAccountType Optional — BinCountry BinCountry Optional — BinIssuer BinIssuer Optional — BinScheme BinScheme Optional — — CodeType Optional — — CodeValue Optional — ConsumerLoyalty ConsumerLoyalty Optional — ConsumerPasswordProvided ConsumerPasswordProvided Optional — ConsumerPromotions ConsumerPromotions Optional cookies_accepted CookiesAccepted CookiesAccepted Optional — CookiesEnabled CookiesEnabled Optional — DeviceFingerprint DeviceFingerprint Optional score_factors Factors Factors Optional — FlashEnabled FlashEnabled Optional gift_wrap GiftWrap GiftWrap Optional score_host_severity HostSeverity HostSeverity Optional score_score_result — — — score_time_local — — — — ImagesEnabled — — — InfoCodes — — — IPCity IPCity Optional — IPCountry IPCountry Optional — IPRoutingMethod IPRoutingMethod Optional — IPState IPState Optional — — ImagesEnabled Optional — JavascriptEnabled JavascriptEnabled Optional lost_password LostPassword LostPassword Optional product_risk ProductRisk ProductRisk Optional — ProxyIPAddress ProxyIPAddress Optional — ProxyIPAddressActivities ProxyIPAddressActivities Optional — ProxyIPAddressAttributes ProxyIPAddressAttributes Optional — ProxyServerType ProxyServerType Optional repeat_customer RepeatCustomer RepeatCustomer Optional returns_accepted ReturnsAccepted ReturnsAccepted Optional — Score Score Optional — TimeLocal TimeLocal Optional — TrueIPAddress TrueIPAddress Optional — TrueIPAddressActivities TrueIPAddressActivities Optional — TrueIPAddressAttributes TrueIPAddressAttributes Optional — TrueIPAddressCity TrueIPAddressCity Optional — TrueIPAddressCountry TrueIPAddressCountry Optional ship_to_address1 Address1 Address1 Optional ship_to_address2 Address2 Address2 Optional ship_to_city City City Optional ship_to_country Country Country Optional — CompanyName — — — FirstName FirstName Optional — LastName LastName Optional ship_to_phone Phone Phone Optional ship_to_state State State Optional ship_to_zip Zip Zip Optional shipping_carrier Carrier Carrier Optional shipping_method Method Method Optional — CompleteRoute CompleteRoute Optional — DepartureDateTime DepartureDateTime Optional — JourneyType JourneyType Optional — — Number Optional — PassengerEmail PassengerEmail Optional — PassengerFirstName PassengerFirstName Optional — PassengerID PassengerID Optional — PassengerLastName PassengerLastName Optional — PassengerPhone PassengerPhone Optional — PassengerStatus PassengerStatus Optional — PassengerType PassengerType Optional row_descriptor — — — Card-Present Fields The fields in the table below are available in the Transaction Request Report (TRR) but only for card-present transactions. Table 8 Card-Present Fields for the Transaction Request Report SCMP API Field SO API Field New Business Center Fields cat_level pos_catLevel POSCatLevel pos_environment pos_environment POSEnvironment terminal_id_alternate pos_terminalIDAlternate TerminalIDAlternate cardholder_verification_methodpin_data_encrypted_pin ccAuthService_cardholderVerificationMethodpinDataEncryptedPin CardVerificationMethod partner_sdk_version partnerSDKversion PartnerSDKVersion pos_device_id pos_deviceID DeviceID card_present pos_cardPresent CardPresent pos_entry_mode pos_entryMode POSEntryMode emv_request_fallback emvRequest_fallback EMVRequestFallback cardholder_verification_methodpin_data_encrypted_pin ccAuthService_cardholderVerificationMethodpinDataEncryptedPin PinType issuer_response_code issuer_responseCode IssuerResponseCode store_and_forward_indicator pos_storeAndForwardIndicator StoreAndForwardIndicator acquirer_merchant_number acquirerMerchantNumber AcquirerMerchantNumber partner_original_transaction_id partnerOriginalTransactionID PartnerOriginalTransactionID terminal_serial_number pos_terminalSerialNumber TerminalSerialNumber Payment Batch Detail Report To create a new Payment Batch Detail Report (PBDR) that contains the same range of transactions as the Classic PBDR, schedule your report to run daily at 12:00 a.m. PST. The report will generate within 6 hours. If the report starts after 6:00 p.m., it might have a report generate date of the following day. For a discussion of nuances related to batch and report scheduling, see "Generate Date and Time," page 9. Table 9 Field Mapping for the Payment Batch Detail Report Classic Business Center CSV Fields (SCMP API) Classic Business Center XML Fields (SO API) New Business Center Fields Required/Optional batch_id BatchID BatchID Required merchant_id MerchantID MerchantID Required batch_date BatchDate BatchDate Required request_id RequestID RequestID Required merchant_ref_number MerchantReferenceNumber MerchantReferenceNumber Optional trans_ref_no TransactionReferenceNumber TransactionReferenceNumber Optional payment_method PaymentMethod PaymentMethod Optional currency CurrencyCode CurrencyCode Optional amount Amount Amount Optional transaction_type — — Optional Transaction Exception Detail Report Table 10 Field Mapping for the Transaction Exception Detail Report Classic Business Center CSV Fields (SCMP API) Classic Business Center XML Fields (SO API) New Business Center Fields Required/Optional action Action Action Required error_category ErrorCategory ErrorCategory Required — — LastActionDate Optional — — NextActionDate Optional — — Payment# Optional — — ProcessorResponseCode Required — — ReasonCode Required — — Retries Optional account_suffix AccountSuffix AccountSuffix Optional amount Amount Amount Optional bank_account_name BankAccountName BankAccountName Optional bank_code BankCode BankCode Optional bill_address1 BillTo_Address1 BillTo_Address1 Optional bill_address2 BillTo_Address2 BillTo_Address2 Optional bill_city BillTo_City BillTo_City Optional bill_country BillTo_Country BillTo_Country Optional bill_state BillTo_State BillTo_State Optional bill_zip BillTo_Zip BillTo_Zip Optional company_name BillTo_CompanyName BillTo_CompanyName Optional currency_code CurrencyCode CurrencyCode Optional customer_cc_expmo ExpirationMonth ExpirationMonth Optional customer_cc_expyr ExpirationYear ExpirationYear Optional customer_email BillTo_Email BillTo_Email Optional customer_firstname BillTo_FirstName BillTo_FirstName Optional customer_lastname BillTo_LastName BillTo_LastName Optional customer_phone BillTo_Phone BillTo_Phone Optional merchant_id MerchantID MerchantID Required merchant_ref_number MerchantReferenceNumber MerchantReferenceNumber Optional original_request_id OriginalRequestID OriginalRequestID Optional payment_method PaymentMethod PaymentMethod Optional payment_processor PaymentProcessor PaymentProcessor Optional reason_code ReasonCode ReasonCode Optional request_id RequestID RequestID Required row_descriptor — — — ship_to_address1 ShipTo_Address1 ShipTo_Address1 Optional ship_to_address2 ShipTo_Address2 ShipTo_Address2 Optional ship_to_city ShipTo_City ShipTo_City Optional ship_to_country ShipTo_Country ShipTo_Country Optional ship_to_first_name ShipTo_FirstName ShipTo_FirstName Optional ship_to_last_name ShipTo_LastName ShipTo_LastName Optional ship_to_state ShipTo_State ShipTo_State Optional ship_to_zip ShipTo_Zip ShipTo_Zip Optional transaction_date TransactionDate TransactionDate Required transaction_ref_number TransactionReferenceNumber TransactionReferenceNumber Optional transaction_type TransactionType TransactionType Optional — SubsscriptionID SubsscriptionID Optional Chargeback and Retrieval Detail Report The Chargeback and Retrieval Detail Report in the New Business Center replaces the following Classic Business Center reports: Chargeback and Representment Details, Chargeback and Representment Financial Details, and Retrieval Request. Refer to the table below for field comparisons. Table 11 Field Mapping for the Chargeback and Retrieval Detail Report Classic Business Center Fields New Business Center Fields Required/Optional orig_capture_request_id RequestID Required cybs_mid MerchantID Required processor_mid — — hierarchy_id Not supported — cybs_exception_id — — processor_case_id CaseNumber Required case_amount ChargebackAmount Required case_amount_currency ChargebackCurrency Required cb_reason_code ChargebackReasonCode Optional cb_reason_description ChargebackReasonCodeDescription Optional financial_impact_type FinancialImpactType Required orig_capture_trans_ref_number TransactionRefNumber Optional case_type_description CaseType Required cb_initiated_date ChargebackTime Required response_date ResponseByDate Optional status_description CaseIdentifier Optional arn ARN Optional event_posting_date CaseTime Required orig_capture_amount RequestedAmount Optional orig_capture_currency RequestedAmountCurrencyCode Optional payment_method cardType Optional account_suffix AccountSuffix Optional orig_capture_sub_date TransactionDate Optional orig_transaction_type TransactionType Required orig_merchant_ref_number MerchantReferenceNumber Optional orig_auth_trans_ref_number TransactionRefNumber Optional orig_auth_date TransactionDate Optional cb_exception_fee_amount FeeAmount Optional cb_exception_fee_currency FeeCurrency Optional issuer_message_text ChargebackMessage Optional funding_currency_case_amount ChargebackAmount Required funding_currency ChargebackCurrency Required first_name FirstName Optional last_name LastName Optional — DocumentIndicator Optional — FinancialImpact Required — MerchantCategoryCode Optional — PartialIndicator Optional — ResolutionTime Optional — ResolvedToIndicator Optional Deposit Detail Report The Deposit Detail Report in the New Business Center replaces the Transfer Log Report. Refer to the table below for field comparisons. Table 12 Field Mapping for the Deposit Detail Report Classic Business Center Fields New Business Center Fields Required/Optional transfer_ref_no Identifier Required origination_date Time Required processor_mid — — cybs_mid MerchantID Required effective_date N//A — amount Amount Required currency_code Currency Required type_description Type Required hierarchy_id Not Supported Optional masked_dda MerchantBankAcctLast4 Optional routing_number MerchantBankCode Optional transfer_method Method Required acquirer — — — Category Required — ExchangeRate Optional — ExchangeRateDescription Optional — Identifier Required — MerchantBankAcctName Optional — MerchantBankCountry Optional — MerchantBankName Optional — Status Required — TransferMessage Optional Invoice Summary Report The Invoice Summary Report in the New Business Center replaces the Invoice Summary Report. Refer to the table below for field comparisons. Table 13 Field Mapping for the Invoice Summary Report Classic Business Center Fields New Business Center Fields Required/Optional BillingGroupDescription BillingGroupDescription Required OrganizationID OrganizationID Required NotProcessed NotProcessed Required PerformedServices PerformedServices Required Processed Processed Required Total Total Required Transaction Exception Detail Report The Transaction Exception Detail Report in the New Business Center replaces the Subscription Payment Exception Report. Refer to the table below for field comparisons. Table 14 Field Mapping for the Transaction Exception Detail Report Classic Business Center Fields New Business Center Fields Required/Optional SubscriptionID SubscriptionID Optional OrderNumber MerchantReferenceNumber Optional Amount PaymentData.RequestedAmount Optional Currency RequestedAmountCurrency Optional CustomerName BillTo.FirstName and BillTo.Lastname Optional PaymentType PaymentMethod.CardType Optional PaymentNumber PaymentNumber Optional LastAction LastActionDate Optional Status Application.RMsg Optional Retries Retries Optional NextAction NextActionDate Optional — Action Required — CYBSExceptionID Optional — ExceptionAmount Optional — ExceptionAmountCurrency Optional — ExceptionCategory Required — ExceptionDate Optional — ExceptionMessage Required — ExceptionReasonDescription Optional — ExceptionStatus Optional — ExceptionType Required — FinancialStatus Optional — OriginalTransactionSubmissionDate Optional — ProcessorCaseID Optional — ProcessorResponseCode Required — ReasonCode Required — Request Optional — MerchantID Required — TransactionDate Required
