Report Field Definitions

Table 10 defines the New Business Center’s report fields and lists them alphabetically See Appendix B, "Report Fields Available," on page 69, for listing of available fields by report.

Table 15

Report Field Definitions

Field Name	Definition	Data Type and Field Length
Application.Name	Name of application used.	VARCHAR2 (30)
Application.Rcode	One-digit code that indicates whether the entire request was successful.	Number (12)
Application.Rflag	One-word description of the result of the entire request.	VARCHAR2 (50)
Application.RMsg	Message that explains the <ics_flag> value.	VARCHAR2 (255)
BankInfo.Address	Bank’s address.	VARCHAR2 (50)
BankInfo.BranchCode	Code that identifies the branch of the customer's bank when you are not using the IBAN.	VARCHAR2 (50)
BankInfo.City	City in which the bank is located.	VARCHAR2 (50)
BankInfo.Country	Country in which the bank is located.	VARCHAR2 (50)
BankInfo.Name	Bank’s name.	VARCHAR2 (50)
BankInfo.SwiftCode	Bank’s SWIFT code. Unique address of the bank. Also known as the Bank Identification Code (BIC).	VARCHAR2 (50)
Batch.BatchDate	Date when the batch was sent to the processor.	Date
Batch.BatchID	CyberSource batch in which the transaction was sent.	VARCHAR2 (8)
Batch.Status	Status of batch file.	VARCHAR2 (10)
Batch.SuccessFlag	Indicates whether batch file processing was successful.	VARCHAR
BillTo.Address1	First line of the billing street address as it appears on the credit card issuer’s records.	VARCHAR2 (400)
BillTo.Address2	Additional address information.	VARCHAR2 (400)
BillTo.City	City of the billing address.	VARCHAR2 (50)
BillTo.CompanyName	Name of the customer’s company.	VARCHAR2 (60)
BillTo.CompanyTaxID	Tax identification number of customer's company.	VARCHAR2 (9)
BillTo.Country	Country of the billing address.	VARCHAR2 (2)
BillTo.CustomerID	Your identifier for the customer.	VARCHAR2 (30)
BillTo.Email	Customer’s email address, including the full domain name.	VARCHAR2 (1500)
BillTo.FirstName	First name of the billed customer.	VARCHAR2 60)
BillTo.HostName	DNS resolved hostname from billTo_ipAddress.	VARCHAR2 (255)
BillTo.IPAddress	Customer’s IP address.	VARCHAR2 (15)
BillTo.LastName	Last name of the billed customer.	VARCHAR2 (60)
BillTo.MiddleName	Middle name of the billed customer.	VARCHAR2 (60)
BillTo.NameSuffix	Suffix of billed customer.	VARCHAR2 (60)
BillTo.PersonalID	Personal identifier. This field is supported only for Redecard in Brazil for CyberSource Latin American Processing. Set this field to the Cadastro de Pessoas Fisicas (CPF), which is required for AVS for Redecard in Brazil.	VARCHAR2 (40)
BillTo.Phone	Customer’s phone number.	VARCHAR2 (100)
BillTo.State	State or province of the billing address.	VARCHAR2 (64)
BillTo.Title	Title of the billed customer.	VARCHAR2 (30)
BillTo.UserName	Customer's user name.	VARCHAR2 (30)
BillTo.Zip	Postal code for the billing address. The postal code must consist of 5 to 9 digits.	VARCHAR2 (10)
ChargebackAndRetrieval. AdjustmentAmount	Amount of the chargeback adjustment.	Number
ChargebackAndRetrieval. AdjustmentCurrency	Currency of the chargeback adjustment.	VARCHAR2 (3)
ChargebackAndRetrieval. AdjustmentARN	Association reference number.	VARCHAR2 (64)
ChargebackAndRetrieval. CaseIdentifier	Numerical identifier created by CyberSource to represent a unique chargeback, representment, or other exception.	Number
ChargebackAndRetrieval. CaseNumber	Processor-assigned case number.	VARCHAR2 (64)
ChargebackAndRetrieval. CaseTime	The date that the case was opened.	Date
ChargebackAndRetrieval. CaseType	Description of the case type.	VARCHAR
ChargebackAndRetrieval. ChargebackAmount	Amount of the chargeback.	Number
ChargebackAndRetrieval. ChargebackCurrency	Chargeback currency code.	VARCHAR2 (3)
ChargebackAndRetrieval. ChargebackMessage	Text message from the issuer explaining the reason for the chargeback or other exception.	VARCHAR2 (64)
ChargebackAndRetrieval. ChargebackOriginalAmount	Amount of the original chargeback.
ChargebackAndRetrieval. ChargebackOriginal Currency	Currency of the original chargeback.
ChargebackAndRetrieval. ChargebackReasonCode	Association chargeback reason code.	VARCHAR2 (10)
ChargebackAndRetrieval. ChargebackReasonCodeDescription	Text description of the reason code.	VARCHAR2 (64)
ChargebackAndRetrieval. ChargebackTime	The date that the chargeback was originated by the issuing bank.	Date
ChargebackAndRetrieval. DocumentIndicator	Indicates whether or not there are associated documents. Possible values: ■ Y ■ N	VARCHAR2 (1)
ChargebackAndRetrieval. FeeAmount	Amount of the chargeback exception fee.	Number
ChargebackAndRetrieval. FeeCurrency	Currency code for the chargeback exception fee.	VARCHAR2 (3)
ChargebackAndRetrieval. FinancialImpact	Indicates whether or not there is a financial impact. Possible values: ■ Y ■ N	VARCHAR2 (1)
ChargebackAndRetrieval. FinancialImpactType	Debit, credit, or none.	VARCHAR2 (2)
ChargebackAndRetrieval. MerchantCategoryCode	Four-digit number that the payment card industry uses to classify merchants into market segments.	VARCHAR2 (4)
ChargebackAndRetrieval. PartialIndicator	Flag indicating whether the transaction is enabled for partial chargeback.	VARCHAR2 (1)
ChargebackAndRetrieval. ResolutionTime	Resolution time in UTC.	Date
ChargebackAndRetrieval. ResolvedToIndicator	Indicates resolved to status of transaction. Possible values: ■ B (bank) ■ M (merchant) ■ S (split) ■ G (general ledger)	VARCHAR2 (20)
ChargebackAndRetrieval. RespondByDate	Date by which item must be submitted to the chargeback processor to allow sufficient time for representment.	Date
ChargebackAndRetrieval. TransactionType	Capture type of the original transaction.	VARCHAR2 (6)
Check.AccountEncoderID	Identifier for the bank that provided the customer’s encoded account number.	VARCHAR2 (3)
Check.SecCode	Authorization method used for the transaction.	VARCHAR2 (3)
Deposit.Amount	Amount of the deposit.	Number
Deposit.Category	Category of the deposit.	VARCHAR2 (25)
Deposit.Currency	Currency code of the deposit.	VARCHAR2 (3)
Deposit.ExchangeRate	Exchange rate. Includes a decimal point and up to 4 decimal places.	Number
Deposit.ExchangeRate Description	Exchange rate description from the funding bank.	VARCHAR2 (64)
Deposit.Identifier	Unique reference number for this deposit.	VARCHAR2 (64)
Deposit.MerchantBank AcctLast4	Bank account number to which the funds transfer will be deposited. For security purposes, all but the last 4 digits are masked.	VARCHAR2 (4)
Deposit.MerchantBank AcctName	Name used on the bank account.	VARCHAR2 (35)
Deposit.MerchantBank Code	Routing number for the account to which the funds transfer will be deposited.	VARCHAR2 (35)
Deposit.MerchantBank Country	Country in which the bank is located. Use the two-character ISO Standard Country Codes.	VARCHAR2 (2)
Deposit.MerchantBank Name	Bank's name.	VARCHAR2 (35)
Deposit.MerchantID	CyberSource merchant ID.	VARCHAR2 (30)
Deposit.Method	Funds transfer method.	VARCHAR2 (25)
Deposit.Status	Status of the deposit. Possible values: ■ S (success) ■ P (pending) ■ F (failed)	VARCHAR2 (7)
Deposit.Time	Deposit time for the transaction in UTC.	Date
Deposit.TransferMessage	Deposit transfer message provided by the processor.	VARCHAR2 (64)
Deposit.Type	Description of events included in this funds transfer.	VARCHAR2 (3)
Device.DeviceID	Identification number of device used for transaction.	VARCHAR2 (3)
Event.Amount	Amount for the event.	Number (19)
Event.CurrencyCode	Currency code for the event.	VARCHAR2 (5)
Event.Event	Type of event that occurred for the transaction.	VARCHAR2 (20)
Event.EventDate	Date in GMT format that the event occurred. This field can be null for some event types, such as Declined.	Date
Event.ProcessorMessage	Additional information from the processor about the event, such as an error message or explanation.	VARCHAR2 (255)
Exception.Action	Brief description of the action.	VARCHAR2 (20)
Exception.CYBSException ID	Exception ID number assigned by CyberSource.	Number (18)
Exception.Exception Amount	Amount specified in the exception.	Number (19)
Exception.Exception AmountCurrency	Exception currency represented in ISO 4217:2008 alpha-3.	VARCHAR2 (255)
Exception.Exception Category	Type of exception.	VARCHAR2 (20)
Exception.ExceptionDate	Date of exception.	Number (18)
Exception.Exception Message	Description of the exception.	VARCHAR2 (255)
Exception.Exception ReasonCode	Reason code for the error that occurred. This reason code is the same one that you receive in the reply or transaction receipt.	VARCHAR2 (60)
Exception.Exception ReasonDescription	Description of exception reason.	VARCHAR2 (255)
Exception.ExceptionStatus	Current status of the transaction.	VARCHAR2 (30)
Exception.ExceptionType	Type of exception.	Number (26)
Exception.FinancialStatus	Financial status of the transaction.	Number (5)
Exception.LastActionDate	Date of last action on the transaction.	Date
Exception.NextActionDate	Date of next action on the transaction.	Date
Exception.Original TransactionSubmission Date	Date on which the transaction was submitted.	Date
Exception.Payment Number	Payment number.	VARCHAR2
Exception.ProcessorCase ID	Processor-assigned case number	VARCHAR2 (30)
Exception.Processor ResponseCode	Code returned directly from the processor for the exception that occurred.	VARCHAR2 (12)
Exception.ReasonCode	Reason code for the exception that occurred.	VARCHAR2 (12)
Exception.RetryCount	Total number of payments that are pending in retry mode.	Number
Exception.Settlement Processor	Name of settlement processor.	VARCHAR2 (40)
Fee.AssessmentAmount	Amount of the assessment.	Number
Fee.AssessmentCurrency	Currency of the assessment.	VARCHAR2 (3)
Fee.BillingCycle	Billing cycle of the merchant. Possible values: ■ daily ■ weekly ■ monthly	VARCHAR2 (25)
Fee.BillingType	Billing type of the merchant. Possible values: ■ discount ■ interchangePlus ■ serviceFee ■ other	VARCHAR2 (25)
Fee.ClearedInterchange Level	Code for the clearing level.	VARCHAR2 (3)
Fee.ConversionFee	Amount of the conversion fee.
Fee.ConversionFee Currency	Currency of the conversion fee.
Fee.DiscountAmount	DiscountRate *TransactionAmount. This value includes 4 decimal points.	Number
Fee.DiscountCurrency	Currency of the discount.	VARCHAR2 (3)
Fee.DiscountRate	Discount rate.	Number
Fee.DowngradeReason Code	Reason for downgrade. Possible values: ■ 1: Transaction exceeded timeliness. ■ 2: Authorization code is missing. ■ 8: POS entry mode does not qualify. ■ 9: POS condition code does not qualify. ■ A: POS terminal capability does not qualify. ■ D: Mail/phone/e-commerce indicator does not qualify. ■ K: Transaction cleared as intraregional. ■ L: Transaction cleared as interregional. ■ R: Reclassification. ■ U: UK domestic. ■ V: German domestic. ■ W: Transaction cleared as world signia. ■ X: Did not qualify at merchant price level	VARCHAR2 (6)
Fee.ExchangeRate	Exchange rate used for the transaction.
Fee.InterchangeAmount	Final amount of transaction after the interchange rates are applied.	Number
Fee.InterchangeCurrency	ISO currency code for the currency of the clearing rate.	VARCHAR2 (3)
Fee.InterchangeRate	Interchange rate for the transaction.	Number
Fee.PerItemFeeAmount	Fee for a single item.	Number
Fee.PerItemFeeCurrency	Currency for a single item fee.	VARCHAR2 (3)
Fee.PricedInterchange Level	Interchange flat rate that was assigned when you set up your account. This value includes 4 decimal points.	VARCHAR2 (3)
Fee.ServiceFeeAmount	Amount of service fee for transaction.	Number
Fee.ServiceFeeAmount Ccy	Currency of the service fee.	VARCHAR2 (3)
Fee.ServiceFeeFixed Amount	Amount of the fixed service fee for the transaction.	Number
Fee.ServiceFeeFixed AmountCcy	Currency of the fixed service fee.	VARCHAR2 (3)
Fee.ServiceFeeRate	Percentage rate of the service fee.	Number
Fee.SettlementAmount	Amount of the settlement.	Number
Fee.SettlementCurrency	Currency of the settlement.	VARCHAR2 (3)
Fee.SettlementTime	Time the settlement was processed.	Date
Fee.SettlementTimeZone	Time zone of the settlement.	VARCHAR2 (6)
Fee.SourceDescriptor	Descriptor of fee source.	VARCHAR2 (6)
Fee.TotalFeeAmount	Total amount of all fee transactions for the specified date range.	Number
Fee.TotalFeeCurrency	Currency for all fee transactions for the specified date range.	VARCHAR2 (3)
FeeSummary.CardType	Type of card to authorize.	VARCHAR2 (5)
FeeSummary.Count	Number of transactions.	Number
FeeSummary.Fee Description	Fee description from the processor.	VARCHAR2 (64)
FeeSummary.FeeType	Type of fee.	VARCHAR2 (30)
FeeSummary.Funding Currency	Funding currency represented in ISO 4217:2008 alpha-3.	VARCHAR2 (3)
FeeSummary.Payment Method	Payment method used for the transaction.	VARCHAR2 (30)
FeeSummary.PerItemFee	Fee for a single item.	Number
FeeSummary.Percentage Fee	Percentage charged for a single item.	Number
FeeSummary.TotalFee Amount	Total amount of all fee transactions for the specified date range.	Number
FeeSummary.Transaction Amount	Amount of the transaction.	Number
FeeSummary.Transaction Type	Capture type of the original transaction.	VARCHAR2 (6)
Funding.Currency ExchangeDescription	Exchange rate description from the processor.	VARCHAR2 (64)
Funding.Currency ExchangeRate	Exchange rate for converting from transaction currency to funding currency.	Number
Funding.ExchangeRate	Exchange rate used for the transaction.
Funding.ExchangeRateDate	Time stamp for the exchange rate.
Funding.ExchangeDate OriginalTimezone	Time zone of the country where the original transaction took place.
Funding.FeeAmount	Fee for the transaction.	Number
Funding.FeeCurrency	Fee currency represented in ISO 4217:2008 alpha-3.	VARCHAR2 (3)
Funding.FeeDescription	Fee description from the processor.	VARCHAR2 (64)
Funding.FundingAccount Suffix	Last 4 digits of funding account.	VARCHAR2 (40)
Funding.FundingAmount	Funding amount of the transaction.	Number
Funding.FundingBank Code	Bank code of the funding bank.
Funding.FundingBank Country	Bank country of the funding bank represented in ISO 3166-1 alpha-3.
Funding.FundingBank Name	Name of bank funding the transaction.
Funding.FundingCurrency	Funding currency represented in ISO 4217:2008 alpha-3.	VARCHAR2 (3)
Funding.FundingDate	Funding date of the transaction.	Date
Funding.Funding IdentificationNumber	Funding identification for the funding of the transaction.	VARCHAR2 (64)
Funding.Funding ProcessorMessage	Funding response message from the processor.	VARCHAR2 (64)
Funding.LocalAmount	Local amount of the transaction.
Funding.LocalCurrency	Local currency of the transaction.
Funding.OriginalAmount	Original amount of the transaction, before the exchange rate is applied.
Funding.OriginalCurrency	Original currency of the transaction.
Funding.FundingTransfer Message	Funding transfer message provided by the processor.	VARCHAR2 (64)
Funding.Processor ResponseCode	Funding response code from the processor.	VARCHAR2 (10)
Funding.Status	Funding status. Possible values: ■ S (success) ■ P (pending) ■ F (failed)	VARCHAR2 (10)
FundTransfer.BankCheck Digit	Code used to validate the customer's account number.	CHAR (2)
FundTransfer.Iban Indicator	International Bank Account Number (IBAN).	CHAR (1)
Invoice.BillingGroup Description	Description of the billing group.	VARCHAR2 (50)
Invoice.NotProcessed	Number of unprocessed transactions.	Number
Invoice.OrganizationID	Merchant ID.	VARCHAR2 (30)
Invoice.Performed Services	CyberSource ICS service name.	VARCHAR2 (30)
Invoice.Processed	Number of processed transactions.	Number
Invoice.Total	Invoice count.	Number
LineItems.FulfillmentType	Information about the product code used for the line item.	VARCHAR2 (2)
LineItems.InvoiceNumber	Invoice number for order.	VARCHAR2 (30)
LineItems.Merchant ProductSku	Identification code for the product.	VARCHAR2 (255)
LineItems.Number	Number of the line item in an order.	Number
LineItems.ProductCode	Type of product. This value is used to determine the category that the product is in: electronic, handling, physical, service, or shipping.	VARCHAR2 (255)
LineItems.ProductName	Name of product.	VARCHAR2 (255)
LineItems.Quantity	Quantity of product.	Number (12)
LineItems.TaxAmount	Total tax to apply to the product.	Number (19)
LineItems.UnitPrice	Per-item price of the product.	Number
MerchantDefinedData. Field1 - MerchantDefinedData. Field20	Fields that you can use to store information.	VARCHAR2 (1175)
PaymentData.AAV_CAVV	Optional authentication data that you can receive after the customer is authenticated.	VARCHAR2 (3)
PaymentData.ACH VerificationResult	Raw result of the ACH Verification service.
PaymentData.ACH VerificationResultMapped	Mapped result of the ACH Verification service.
PaymentData.Amount	Grand total for the order.	Number (19)
PaymentData. AuthorizationCode	Authorization code for the payment.	VARCHAR2 (15)
PaymentData. AuthorizationType	Authorization type of the payment.	VARCHAR2 (1)
PaymentData.AVSResult	Raw code for Address Verification Service result for the payment.	VARCHAR2 (10)
PaymentData.AVSResult Mapped	Address Verification Service result for the payment.	VARCHAR2 (5)
PaymentData.Balance Amount	Remaining balance on the account.	Number (19)
PaymentData.Balance CurrencyCode	Currency of the remaining balance on the account.	VARCHAR2 (3)
PaymentData.BinNumber	Bank identification number.	VARCHAR2 (6)
PaymentData.Card Category	Type of card used in the transaction.	VARCHAR2 (10)
PaymentData.Card CategoryCode	Category code of card used in the transaction.
PaymentData.Currency Code	Currency code for the payment.	VARCHAR2 (3)
PaymentData.CVResult	CVN result code.
PaymentData.DCC Indicator	Flag that indicates whether DCC is being used for the transaction.	VARCHAR2 (1)
PaymentData.ECI	Optional information that you can receive if you use the Payer Authentication service.	Number (5)
PaymentData.eCommerce Indicator	Type of eCommerce transaction.	CHAR (1)
PaymentData.EVEmail	Mapped Electronic Verification response code for the customer’s email address.	VARCHAR2 (5)
PaymentData.EVEmailRaw	Raw Electronic Verification response code from the processor for the customer’s email address.	VARCHAR2 (10)
PaymentData.EventType	Type of event that occurred for the transaction.
PaymentData.EVName	Mapped Electronic Verification response code for the customer’s name.	VARCHAR2 (5)
PaymentData.EVName Raw	Raw Electronic Verification response code from the processor for the customer’s last name.	VARCHAR2 (10)
PaymentData.EVPhone Number	Mapped Electronic Verification response code for the customer’s phone number.	VARCHAR2 (5)
PaymentData.EVPhone NumberRaw	Raw Electronic Verification response code from the processor for the customer’s phone number.	VARCHAR2 (10)
PaymentData.EVPostal Code	Mapped Electronic Verification response code for the customer’s postal code.	VARCHAR2 (5)
PaymentData.EVPostal CodeRaw	Raw Electronic Verification response code from the processor for the customer’s postal code.	VARCHAR2 (10)
PaymentData.EVStreet	Mapped Electronic Verification response code for the customer’s street address.	VARCHAR2 (5)
PaymentData.EVStreet Raw	Raw Electronic Verification response code from the processor for the customer’s street address.	VARCHAR2 (10)
PaymentData.Exchange Rate	Exchange rate used for the transaction..	Number (27)
PaymentData.Exchange RateDate	Time stamp for the exchange rate.	Date
PaymentData.GrandTotal	Grand total amount for the order, including tax, for requests that do not contain payment information.	Number (19)
PaymentData.NumberOf Installments	Total number of installments when making payments in installments.	VARCHAR2 (3)
PaymentData.Payment Processor	Name of payment processor.	VARCHAR2 (40)
PaymentData.Payment ProductCode	Type of payment product used by the consumer to pay on a payment provider’s site, such as installments or bank transfer
PaymentData.Payment RequestID	Original request ID for the purchase.	Number (26)
PaymentData.Processor ResponseCode	The error message sent directly from the bank.	VARCHAR2 (60)
PaymentData.Processor ResponseID	Response ID sent from the processor.	VARCHAR2 (50)
PaymentData.ProcessorTID	Transaction identification (TID) that is used to identify and track a transaction throughout its life cycle.	VARCHAR2 (60)
PaymentData.Requested Amount	Amount requested to be authorized.	Number (19)
PaymentData.Requested AmountCurrencyCode	Currency for the amount requested to be authorized.	VARCHAR2 (5)
PaymentData.Target Amount	Converted amount.	Number (19)
PaymentData.Target Currency	Billing currency.	VARCHAR2 (3)
PaymentData.TotalTax Amount	Total tax amount for all of the line items in the transaction.	Number (19)
PaymentData.Transaction RefNumber	Reference number for the transaction.	VARCHAR2 (60)
PaymentData.XID	Optional transaction identifier generated by Payer Authentication that you can receive when the customer is enrolled and when validation is successful.	VARCHAR2 (40)
PaymentMethod.Account Suffix	Last four digits of the customer’s payment account number.	VARCHAR2 (4)
PaymentMethod.Bank AccountName	Bank's account name.	VARCHAR2 (90)
PaymentMethod.Bank Code	Bank's code. Used for some countries when you are not using the IBAN. Contact CyberSource Customer Support for required country-specific bank account information.	VARCHAR2 (15)
PaymentMethod.Boleto BarCodeNumber	Numeric representation of the boleto barcode.	VARCHAR2 (50)
PaymentMethod.Boleto Number	Boleto Bancário payment number.	VARCHAR2 (50)
PaymentMethod.Card Category	Type of card used.	VARCHAR2 (10)
PaymentMethod.Card CategoryCode	Code for card type used.	VARCHAR2 (10)
PaymentMethod.CardType	Type of card to authorize.	VARCHAR2 (5)
PaymentMethod.Check Number	Check number.	VARCHAR2 (10)
PaymentMethod. ExpirationMonth	Two-digit month in which the credit card expires.	VARCHAR2 (4)
PaymentMethod. ExpirationYear	Four-digit year in which the credit card expires.	VARCHAR2 (4)
PaymentMethod.Issue Number	Number of times a Maestro (UK Domestic) card has been issued to the account holder.	VARCHAR2 (5)
PaymentMethod.MandateId	Identification reference for the direct debit mandate.	VARCHAR2 (35)
PaymentMethod.Mandate Type	Type of mandate.	VARCHAR2 (20)
PaymentMethod.Signature Date	Date of signature.	Date
PaymentMethod.StartMonth	Month of the start of the Maestro (UK Domestic) card validity period.	VARCHAR2 (4)
PaymentMethod.StartYear	Year of the start of the Maestro (UK Domestic) card validity period.	VARCHAR2 (4)
PaymentMethod.Wallet Type	Type of wallet.	VARCHAR2 (20)
POSTerminalException.Bill ToEmail	Email address of the user.	String (255)
POSTerminalException. CardVerificationMethod	Type of customer verification.	String (60)
POSTerminalException. ClientID	Client identifier for an installation; generated by the operating system.	String (60)
POSTerminalException. DCCExchangeRate	Dynamic Currency Conversion exchange rate.	Decimal (22.4)
POSTerminalException. DCCLookupStatus	Lookup Status of Dynamic Currency Conversion.	String (255)
POSTerminalException. DCCMarginRate	Margin rate of Dynamic Currency Conversion.	Decimal (22.4)
POSTerminalException. DeviceHardwareRevision	Hardware revision printed on the back of the credit card reader.	String (60)
POSTerminalException. DeviceID	Serial number printed on the back of the credit card reader. Dashes are stripped from the serial number.	String (1024)
POSTerminalException. DeviceOS	Operating system of the device.	String (60)
POSTerminalException. DeviceOSVersion	Operating system version of the device.	String (30)
POSTerminalException. DeviceTerminalID	Terminal identifier assigned to the credit card reader; used by the clearing institute to identify credit card readers.	String (255)
POSTerminalException. ExceptionCategory	Status of the transaction.	String (255)
POSTerminalException. ExceptionDescription	Detailed description of the status of the transaction.	String (255)
POSTerminalException. ExceptionStatusCode	Code that represents the status of the transaction.	String (255)
POSTerminalException. LocalCurrencyCode	Three-digit security code for the local currency.	String (3)
POSTerminalException. PartnerMerchantID	Three-digit identifier for the partner merchant.	String (3)
POSTerminalException. PartnerMerchantName	Name of the merchant that performed the transaction.	String (100)
POSTerminalException. PartnerOriginalTransaction ID	Unique identifier of the transaction.	String (60)
POSTerminalException. ProcessorMID	Merchant identifier of the merchant that performed the transaction; as assigned by the clearing institute.	String (120)
POSTerminalException. RequestID	Unique identifier of the transaction processor; for debugging purposes.	Integer (26)
POSTerminalException. SchemeOperator	Scheme of the credit card.	String (60)
POSTerminalException. SDKVersion	Version of the software development kit (SDK).	String (30)
POSTerminalException. StorageMechanism	Source from which payment details have been collected.	String (60)
POSTerminalException. TerminalID	Terminal identifier of the merchant that performed the transaction.	String (60)
Profile.Name	Name of the profile.	VARCHAR2 (30)
Profile.ProfileDecision	Decision returned by the profile.	VARCHAR2 (255)
Profile.ProfileMode	Activity mode of the profile.	VARCHAR2 (1)
Profile.RuleDecision	Decision returned by the rule.	VARCHAR2 (255)
Profile.RuleName	Name of the rule.	VARCHAR2 (30)
Recipient.RecipientBilling Amount	Billing amount of transaction.	Number (19)
Recipient.RecipientBilling Currency	Currency of billed transaction.	CHAR (3)
Request.Comments	Optional comments that you can make about the subscription or customer profile.	VARCHAR2 255)
Request.MerchantID	CyberSource merchant ID used for the transactions.	VARCHAR2 (30)
Request.Merchant ReferenceNumber	Merchant-generated order reference or tracking number.	Number (38)
Request.RequestID	Identifier for the transaction request.	Number (26)
Request.Source	Source of request.
Request.SubscriptionID	Identifier for the customer profile.	VARCHAR2 (26)
Request.TransactionDate	Date on which the transaction took place.	Date
Request.User	Information about a user.	VARCHAR2 (30)
Risk.AppliedAVS	Indicates whether or not Address Verification Service rules were applied to the transaction.
Risk.AppliedCategoryGift	Importance of billing and shipping addresses in assessing the order. If you do not specify a value in your request, the server uses the default value for your merchant ID.	VARCHAR2 (1)
Risk.AppliedCategoryTime	Importance of time of day in assessing the order. If you do not specify a value in your request, the server uses the default value for your merchant ID.	VARCHAR2 (6)
Risk.AppliedCV	Indicates whethor or not Card Verification was applied to the transaction.	VARCHAR2 (1)
Risk.AppliedHostHedge	Importance of email and IP addresses of the customer in assessing the order. If you do not specify a value in your request, the server uses the default value for your merchant ID.	VARCHAR2 (6)
Risk.AppliedThreshold	Score threshold applied to the order.	Number (7)
Risk.AppliedTimeHedge	Importance of time of day in assessing the order. If you do not specify a value in your request, the server uses the default value for your merchant ID.	VARCHAR2 (6)
Risk.AppliedVelocityHedge	Importance of the number of orders from the customer in a specific time period in assessing the order. If you do not specify a value in your request, the server uses the default value for your merchant ID.	VARCHAR2 (6)
Risk.BinAccountType	Type of customer.	VARCHAR2 (2)
Risk.BinCountry	Country (two-digit country code) associated with the BIN of the customer’s card used for the payment.	VARCHAR2 (2)
Risk.BinIssuer	Name of the bank or entity that issued the card account.	VARCHAR2 (128)
Risk.BinScheme	Subtype of card account.	VARCHAR2 (64)
Risk.CodeType	Category of information code returned for an order.
Risk.CodeValue	Description of the information code returned in the <CodeType> element.
Risk.ConsumerLoyalty	Indicates whether a loyalty program is used or the number of the loyalty reward account that is used.	VARCHAR2 (1)
Risk.ConsumerPassword Provided	Reserved for future use.	VARCHAR2 (1)
Risk.ConsumerPromotions	Reserved for future use.	VARCHAR2 (1)
Risk.CookiesAccepted	Indicates whether the customer’s Web browser accepts cookies. This field can contain one of the following values: ■ true: The customer’s browser accepts cookies. ■ false: The customer’s browser does not accept cookies.	VARCHAR2 (1)
Risk.CookiesEnabled	Indicates whether cookies are enabled in the customer’s browser.	VARCHAR2 (1)
Risk.DeviceFingerPrint	Indicates whether Device Fingerprint is used.	VARCHAR2 (80)
Risk.Factors	Information that affected the score of the order.	VARCHAR2 (100)
Risk.FlashEnabled	Indicates whether Flash is enabled in the customer’s browser.	VARCHAR2 (1)
Risk.GiftWrap	Reserved for future use.	VARCHAR2 (1)
Risk.HostSeverity	Risk associated with the customer's email domain.	Number (7)
Risk.ImagesEnabled	Indicates whether images are enabled in the customer’s browser.	VARCHAR2 (1)
Risk.IPCity	Name of the city decoded from the IP address used directly or indirectly by the customer to send the order.	VARCHAR2 (50)
Risk.IPCountry	Name of the country decoded from the IP address used directly or indirectly by the customer to send the order.	VARCHAR2 (60)
Risk.IPRoutingMethod	Routing method decoded from the IP address used directly or indirectly by the customer to send the order.	VARCHAR2 (30)
Risk.IPState	Name of the state decoded from the IP address used directly or indirectly by the customer to send the order.	VARCHAR2 (20)
Risk.JavascriptEnabled	Indicates whether JavaScript is enabled in the customer’s browser.	VARCHAR2 (1)
Risk.LostPassword	Reserved for future use.	VARCHAR2 (1)
Risk.ProductRisk	Indicates the level of risk for the product. This field can contain one of the following values: ■ low: The product is associated with few chargebacks. ■ normal: The product is associated with a normal number of chargebacks. ■ high: The product is associated with many chargebacks.	VARCHAR2 (6)
Risk.ProxyIPAddress	IP address of the proxy if it is available.	VARCHAR2 (64)
Risk.ProxyIPAddress Activities	Actions associated with the proxy IP address.	VARCHAR2 (255)
Risk.ProxyIPAddress Attributes	Characteristics associated with the proxy IP address.	VARCHAR2 (255)
Risk.ProxyServerType	Type of proxy server based on the HTTP header.	VARCHAR2 12)
Risk.RepeatCustomer	Reserved for future use.	VARCHAR2 (1)
Risk.ReturnsAccepted	Indicates whether returns are accepted for this order. This field can contain one of the following values: ■ true: Returns are accepted for this order. ■ false: Returns are not accepted for this order.	VARCHAR2 (1)
Risk.Score	Total score calculated for the order.	Number
Risk.TimeLocal	Local time of order.	Date
Risk.TrueIPAddress	Customer’s true IP address detected by the application.	VARCHAR2 (64)
Risk.TrueIPaddress Activities	Actions associated with the true IP address.	VARCHAR2 (255)
Risk.TrueIPAddress Attributes	Characteristics associated with the true IP address.	VARCHAR2 (255)
Risk.TrueIPAddressCity	City associated with the true IP address.	VARCHAR2 (50)
Risk.TrueIPAddress Country	Country associated with the true IP address.	VARCHAR2 (2)
Sender.SenderReference Number	Reference number generated by you that uniquely identifies the sender.	VARCHAR2 (16)
Settlement.ExchangeRate	Exchange rate used for the transaction.
Settlement.ExchangeRate Date	Time stamp for the exchange rate.
Settlement.ExchangeDate OriginalTimezone	Time zone of the country where the original transaction took place.
Settlement.LocalAmount	Local amount of the transaction.
Settlement.LocalCurrency	Local currency of the transaction.
Settlement.OriginalAmount	Original amount of the transaction, before the exchange rate is applied.
Settlement.OriginalCurrency	Original currency of the transaction.
Settlement.SettlementAge	Age of settlement.	Number
Settlement.Settlement Amount	Settlement amount of the transaction.	Number
Settlement.Settlement CurrencyCode	Settlement currency represented in ISO 4217:2008 alpha-3.	VARCHAR2 (3)
Settlement.SettlementDate	Settlement date of the transaction.	Date
Settlement.Source ResponseCode	Settlement response code from the processor.	VARCHAR2 (10)
Settlement.Source ResponseMessage	Settlement response message from the processor.	VARCHAR2 (64)
Settlement.Status	Settlement status. Possible values: ■ S (success) ■ P (pending) ■ F (failed)	VARCHAR2 (10)
Shipping.Carrier	Carrier used to ship product.	VARCHAR2 (12)
Shipping.Method	Shipping method for the product.	VARCHAR2 (10)
ShipTo.Address1	First line of the shipping address.	VARCHAR2 (400)
ShipTo.Address2	Second line of the shipping address.	VARCHAR2 (400)
ShipTo.City	City of the shipping address.	VARCHAR2 (50)
ShipTo.Country	Country of the shipping address.	VARCHAR2 (60)
ShipTo.FirstName	First name of the recipient	VARCHAR2 (60)
ShipTo.LastName	Last name of the recipient.	VARCHAR2 (60)
ShipTo.Phone	Phone number of the recipient.	VARCHAR2 (100)
ShipTo.State	State or province of the shipping address.	VARCHAR2 (25)
ShipTo.Zip	Postal code for the shipping address. The postal code must consist of 5 to 9 digits.	VARCHAR2 (10)
Token.TokenCode	Transaction token code.	VARCHAR2 (255)
Travel.CompleteRoute	Concatenation of individual travel legs.	VARCHAR2 (255)
Travel.DepartureDateTime	Departure date and time of the first leg of the trip.	Date
Travel.JourneyType	Type of travel.	VARCHAR2 (32)
Travel.Number	Offer level or rank of the passenger in the order.
Travel.PassengerFirstName	Passenger’s first name.	VARCHAR2 (60)
Travel.PassengerEmail	Passenger's email address, including the complete domain name.	VARCHAR2 (1500)
Travel.PassengerId	ID of the passenger to whom the ticket was issued.	VARCHAR2 (32)
Travel.PassengerLastName	Passenger’s last name.	VARCHAR2 (60)
Travel.PassengerPhone	Passenger's phone number.	VARCHAR2 (100)
Travel.PassengerStatus	Your company's passenger classification, such as with a frequent flyer program.	VARCHAR2 (32)
Travel.PassengerType	Passenger classification associated with the price of the ticket.	VARCHAR2 (32)

Card-Present Fields

The fields in the table below are available in the Transaction Request Report but only for card-present transactions.

Table 16

Card-Present Field Definitions for the Transaction Request Report

Field Name	Definition	Data Type and Field Length
Device.DeviceID	Value created by the client software that uniquely identifies the POS device. This value is provided by the client software that is installed on the POS terminal. CyberSource does not forward this value to the processor. Instead, the value is forwarded to the CyberSource reporting functionality. This field is supported only on American Express Direct and SIX.	String (32)
PaymentData.Acquirer MerchantNumber	Identifier that was assigned to you by your acquirer. This value must be printed on the receipt. This field is supported only on American Express Direct and SIX.	String (15)
PaymentData.CardPresent	Indicates whether the card is present at the time of the transaction. Possible values: ■ N: Card is not present. ■ Y: Card is present.	String (1)
PaymentData.Card VerificationMethod	Method that was used to verify the cardholder's identity. See "Card-Present Fields," page 35. Possible values: ■ 0: No verification ■ 1: Signature ■ 2: PIN This field is supported only on American Express Direct, OmniPay Direct, and SIX.	Integer (1)
PaymentData.EMVRequestFallback	Indicates that a fallback method was used to enter credit card information into the POS terminal. When a technical problem prevents a successful exchange of information between a chip card and a chip-capable terminal: 1 Swipe the card or key the credit card information into the POS terminal. 2 Use the pos_entryMode field to indicate whether the information was swiped or keyed. See "Card-Present Fields," page 35. Possible values: ■ true: Fallback method was used. ■ false (default): Fallback method was not used. This field is supported only on American Express Direct, Chase Paymentech Solutions, GPN, OmniPay Direct, and SIX.	String (5)
PaymentData.Issuer ResponseCode	Additional authorization code that must be printed on the receipt when returned by the processor. This value is generated by the processor and is returned only for a successful transaction. This field is supported only on SIX.	Varchar2 (15)
PaymentData.PinType	Method that was used to verify the cardholder's identity. Possible values: ■ 0: No verification ■ 1: Signature ■ 2: PIN This field is supported only on American Express Direct, OmniPay Direct, and SIX.	Integer (1)
PaymentData.POSCat Level	Type of cardholder-activated terminal. Possible values: ■ 1: Automated dispensing machine ■ 2: Self-service terminal ■ 3: Limited amount terminal ■ 4: In-flight commerce (IFC) terminal ■ 5: Radio frequency device ■ 6: Mobile acceptance terminal ■ 7: Electronic cash register ■ 8: E-commerce device at your location ■ 9: Terminal or cash register that uses a dial-up connection to the transaction processing network Chase Paymentech Solutions Only values 1, 2, and 3 are supported. FDC Nashville Global Only values 7, 8, and 9 are supported. GPN Only values 6, 7, 8, and 9 are supported. TSYS Acquiring Solutions Only value 6 is supported	Nonnegative integer (1)
PaymentData.POSEntry Mode	Method of entering credit card information into the POS terminal. Possible values: ■ contact: Read from direct contact with chip card. ■ contactless: Read from a contactless interface using chip data. ■ keyed: Manually keyed into POS terminal. This value is not supported on OmniPay Direct or SIX. ■ msd: Read from a contactless interface using magnetic stripe data (MSD). This value is not supported on OmniPay Direct. ■ swiped: Read from credit card magnetic stripe. The contact, contactless, and msd values are supported only for Europay, Mastercard, and Visa (EMV) transactions.	String (11)
PaymentData.POS Environment	Operating environment. Possible values: ■ 0: No terminal used, or unknown environment. ■ 1: On merchant premises, attended. ■ 2: On merchant premises, unattended, or cardholder terminal. Examples: oil, kiosks, self-checkout, home computer, mobile telephone, personal digital assistant (PDA). Cardholder terminal is supported only for Mastercard transactions. ■ 3: Off merchant premises, attended. Examples: portable POS devices at trade shows, at service calls, or in taxis. ■ 4: Off merchant premises, unattended, or cardholder terminal. Examples: vending machines, home computer, mobile telephone, PDA. Cardholder terminal is supported only for Mastercard transactions. ■ 5: On premises of cardholder, unattended. ■ 9: Unknown delivery mode. ■ S: Electronic delivery of product. Examples: music, software, or eTickets that are downloaded over the Internet. ■ T: Physical delivery of product. Examples: music or software that is delivered by mail or by courier. For Mastercard transactions, the only valid values are 2 and 4.	String (1)
PaymentData.Routing NetworkType
PaymentData.StoreAnd ForwardIndicator	When connectivity is unavailable, the client software that is installed on the POS terminal can store a transaction in its memory and send it for authorization when connectivity is restored. This value is provided by the client software that is installed on the POS terminal. CyberSource does not forward this value to the processor. Instead, the value is forwarded to the CyberSource reporting functionality. Possible values: ■ Y (SCMP) / true (SO API) ■ N (SCMP) / false (SO API) This field is supported only on American Express Direct and SIX.	String (1) (SCMP) String (5) (SO API)
PaymentData.TerminalID Alternate	Identifier for an alternate terminal at your retail location. You define the value for this field. This field is supported only for Mastercard transactions on FDC Nashville Global. Use the pos_terminalID field to identify the main terminal at your retail location. If your retail location has multiple terminals, use this pos_terminalIDAlternate field to identify the terminal used for the transaction. This field is a pass-through; CyberSource does not check the value or modify the value in any way before sending it to the processor.	String (8)
Request.PartnerOriginal TransactionID	Value that links the previous transaction to the current follow-on request. This value is assigned by the client software that is installed on the POS terminal, which makes it available to the terminal’s software and to CyberSource. Therefore, you can use this value to reconcile transactions between CyberSource and the terminal’s software. CyberSource does not forward this value to the processor. Instead, the value is forwarded to the CyberSource reporting functionality. This field is supported only on American Express Direct and SIX.	String (32)
Requst.PartnerSDKVersion	Version of the software installed on the POS terminal. This value is provided by the client software that is installed on the POS terminal. CyberSource does not forward this value to the processor. Instead, the value is forwarded to the CyberSource reporting functionality. This field is supported only on American Express Direct and SIX.	String (32)
Request.TerminalSerial Number	Terminal serial number assigned by the hardware manufacturer. This value is provided by the client software that is installed on the POS terminal. CyberSource does not forward this value to the processor. Instead, the value is forwarded to the CyberSource reporting functionality. This field is supported only on American Express Direct and SIX.	String (32)