Capture Info UML

Added On: 03/16/12

SQL Table: CAPTURE_INFO

Module: UniBill

Type: Entity Status: Active

Java Class: CaptureInfo

Available Fields:

Accessory
Account Number
Address
Approval Code
Bank Info FK
Billing History FK
City
Collector Account Code
Country Code
Create Date
CVV2
Email
Encoded BIN
Holder Name

Id
Is BIN Unavailable
Is Proxynization Enabled
Issuer Bank Name
Issuer Bank Phone
Masked Account Number
Merchant Account Code
Network Transaction Id
Original Network Transaction Id
Payment Option FK
Phone
Reference Code
Reference Number
Request Date

Response Code
Response Date
Response Message
Risk Explanation
Risk Scope
Sequence Count
Sequence Number
State
Street
Sys Message
Tax Amount
Token Code
Track Data
Transaction CL

ZIP Code

Accessory

Added On: 08/30/15

SQL Column:

Java Field: accessory

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Expiration date of the card or bank routing number.

Account Number

Added On: 08/30/15

SQL Column:

Java Field: accountNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Encoded credit card number or bank account number.

Address

Added On: 09/20/18

SQL Column: ADDRESS

Java Field: address

Status: Active

SQL Type: varchar

Java Type: String

Attributes: Calculated

Approval Code

Added On: 03/16/12

SQL Column: APPROVAL_CODE

Java Field: approvalCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Authorization code returned by Provider that approved this transaction. In some instances might also be used to store response code returned by Provider when transaction declines.

Bank Info FK

Added On: 03/16/12

SQL Column: BANK_INFO_FK

Java Field: bankInfo

Status: Active

SQL Type: int(11)

Java Type: Integer

References Bank Info

Attributes:

Reference to the entity that represents bank information.

Billing History FK

Added On: 03/16/12

SQL Column: BILLING_HISTORY_FK

Java Field: billingHistory

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Billing History

Attributes:

Reference to the entity that represents billing history of the account.

City

Added On: 03/16/12

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

City mailing address of the cardholder.

Collector Account Code

Added On: 03/16/12

SQL Column: COLLECTOR_ACCOUNT_CODE

Java Field: collectorAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Account code of the collector's agent.

Country Code

Added On: 02/27/14

SQL Column: COUNTRY_CODE

Java Field: countryCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Country code of the mailing address of the cardholder.

Create Date

Added On: 03/16/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

CVV2

Added On: 08/30/15

SQL Column:

Java Field: cvv2

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

CVV2 security code of the credit card.

Added On: 03/16/12

SQL Column: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Email address associated with the cardholder.

Encoded BIN

Added On: 03/16/12

SQL Column: ENCODED_BIN

Java Field: encodedBin

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Encoded BIN (bank identification number).

Holder Name

Added On: 03/16/12

SQL Column: HOLDER_NAME

Java Field: holderName

Status: Active

SQL Type: varchar(150)

Java Type: String

Attributes:

Name of bank account or credit card holder.

Added On: 03/16/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Required

Identifier of the object used for references; auto-incremented integer value.

Is BIN Unavailable

Added On: 03/16/12

SQL Column: IS_BIN_UNAVAILABLE

Java Field: isBinUnavailable

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Indicates whether BIN is unavailable.

Is Proxynization Enabled

Added On: 08/30/15

SQL Column:

Java Field: isProxynizationEnabled

Status: Active

SQL Type:

Java Type: Boolean

Attributes: Transient, Default:false

Indicates whether the proxynization is enabled for this transaction.

Issuer Bank Name

Added On: 03/16/12

SQL Column: ISSUER_BANK_NAME

Java Field: issuerBankName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Bank name of the issuer.

Issuer Bank Phone

Added On: 03/16/12

SQL Column: ISSUER_BANK_PHONE

Java Field: issuerBankPhone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Service phone of the issuer bank.

Masked Account Number

Added On: 12/22/21

SQL Column: MASKED_ACCOUNT_NUMBER

Java Field: maskedAccountNumber

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes: Transient

Merchant Account Code

Added On: 03/16/12

SQL Column: MERCHANT_ACCOUNT_CODE

Java Field: merchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Code of Merchant Account to which instance of this object is attributed to.
Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.

Network Transaction Id

Added On: 01/24/18

SQL Column: NETWORK_TRANSACTION_ID

Java Field: networkTransactionId

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Original Network Transaction Id

Added On: 01/24/18

SQL Column: ORIGINAL_NETWORK_TRANSACTION_ID

Java Field: originalNetworkTransactionId

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Payment Option FK

Added On: 03/16/12

SQL Column: PAYMENT_OPTION_FK

Java Field: paymentOption

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Payment Option

Attributes:

Reference to the entity that represents payment options associated with the account.

Phone

Added On: 03/16/12

SQL Column: PHONE

Java Field: phone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Phone number associated with mailing address of the cardholder.

Reference Code

Added On: 03/16/12

SQL Column: REF_CODE

Java Field: refCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Secondary identifier, which can be used to cross-reference records between TidyPay and integrated systems.

See Reference Code for additional information.

Reference Number

Added On: 03/16/12

SQL Column: REFERENCE_NUMBER

Java Field: referenceNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Transaction identification in gateway.

Request Date

Added On: 03/16/12

SQL Column: REQUEST_DATE

Java Field: requestDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the request.

Response Code

Added On: 03/16/12

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Gateway generated response code.

Response Date

Added On: 03/16/12

SQL Column: RESPONSE_DATE

Java Field: responseDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the response.

Response Message

Added On: 07/18/18

SQL Column: RESPONSE_MESSAGE

Java Field: responseMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Risk Explanation

Added On: 03/16/12

SQL Column: RISK_EXPLANATION

Java Field: riskExplanation

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Risk Scope

Added On: 03/16/12

SQL Column: RISK_SCOPE

Java Field: riskScope

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Sequence Count

Added On: 02/09/18

SQL Column: SEQUENCE_COUNT

Java Field: sequenceCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Sequence Number

Added On: 02/09/18

SQL Column: SEQUENCE_NUMBER

Java Field: sequenceNumber

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

State

Added On: 03/16/12

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

State mailing address of the cardholder.

Street

Added On: 03/16/12

SQL Column: STREET

Java Field: street

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Street mailing address of the cardholder.

Sys Message

Added On: 03/16/12

SQL Column: SYS_MESSAGE

Java Field: sysMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Tax Amount

Added On: 03/16/12

SQL Column: TAX_AMOUNT

Java Field: taxAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of tax in cents included in the amount field.

Token Code

Added On: 03/16/12

SQL Column: TOKEN_CODE

Java Field: tokenCode

Status: Active

SQL Type: varchar(512)

Java Type: String

Attributes:

Token generated for the provided payment information.

Track Data

Added On: 08/30/15

SQL Column:

Java Field: trackData

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Transaction CL

Added On: 03/16/12

SQL Column: TRANSACTION_CL

Java Field: transactionCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Asset Transaction Classifier

Attributes:

Enumeration of possible asset transaction processing modes available in the system.

ZIP Code

Added On: 03/16/12

SQL Column: ZIP_CODE

Java Field: zipCode

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

ZIP/postal code of mailing address of the cardholder.

All Logos and Trademarks used or mentioned on this page are copyrighted property of their respective owners and are used for display purposes only.