PayFacto Provisioning Transaction UML

Added On: 10/01/18

SQL Table: PAYFACTO_PROVISIONING_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: PayFactoProvisioningTransaction

Available Fields:

Amex Deposit Merchant Id
Amex Originator Id
Ccard Amex Result Code
Ccard Amex Result Text
Ccard Discover Result Code
Ccard Discover Result Text
Ccard Jcb Result Code
Ccard Jcb Result Text
Ccard Mc Result Code
Ccard Mc Result Text
Ccard Visa Result Code
Ccard Visa Result Text
City
Contact Name
Currency Code

Dcard Result Code
Dcard Result Text
Discover Deposit Merchant Id
Discover Originator Id
Email Address
Id
Interac Mvv
Jcb Deposit Merchant Id
Jcb Originator Id
Mc Deposit Merchant Id
Mc Originator Id
Merchant Account Code
Merchant Account Number
Merchant Bank Number
Merchant Branch Transit Number

Merchant Category Code
Merchant Command
Merchant Id
Merchant Name
Merchant Result Code
Merchant Result Text
Pay Facto Provisioning File Batch
Phone Number
Postal Code
Province
Provisioning Transaction
Result Code
Result Text
Set Like Merchant Id
Street

Visa Deposit Merchant Id
Visa Originator Id

Amex Deposit Merchant Id

Added On: 09/28/18

SQL Column: AMEX_DEPOSIT_MERCHANT_ID

Java Field: amexDepositMerchantId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Amex Originator Id

Added On: 09/28/18

SQL Column: AMEX_ORIGINATOR_ID

Java Field: amexOriginatorId

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Ccard Amex Result Code

Added On: 09/28/18

SQL Column: CCARD_AMEX_RESULT_CODE

Java Field: ccardAmexResultCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Ccard Amex Result Text

Added On: 09/28/18

SQL Column: CCARD_AMEX_RESULT_TEXT

Java Field: ccardAmexResultText

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Ccard Discover Result Code

Added On: 09/28/18

SQL Column: CCARD_DISCOVER_RESULT_CODE

Java Field: ccardDiscoverResultCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Ccard Discover Result Text

Added On: 09/28/18

SQL Column: CCARD_DISCOVER_RESULT_TEXT

Java Field: ccardDiscoverResultText

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Ccard Jcb Result Code

Added On: 09/28/18

SQL Column: CCARD_JCB_RESULT_CODE

Java Field: ccardJcbResultCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Ccard Jcb Result Text

Added On: 09/28/18

SQL Column: CCARD_JCB_RESULT_TEXT

Java Field: ccardJcbResultText

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Ccard Mc Result Code

Added On: 09/28/18

SQL Column: CCARD_MC_RESULT_CODE

Java Field: ccardMcResultCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Ccard Mc Result Text

Added On: 09/28/18

SQL Column: CCARD_MC_RESULT_TEXT

Java Field: ccardMcResultText

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Ccard Visa Result Code

Added On: 09/28/18

SQL Column: CCARD_VISA_RESULT_CODE

Java Field: ccardVisaResultCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Ccard Visa Result Text

Added On: 09/28/18

SQL Column: CCARD_VISA_RESULT_TEXT

Java Field: ccardVisaResultText

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

City

Added On: 09/28/18

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(13)

Java Type: String

Attributes:

Contact Name

Added On: 09/28/18

SQL Column: CONTACT_NAME

Java Field: contactName

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Currency Code

Added On: 09/28/18

SQL Column: CURRENCY_CODE

Java Field: currencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Dcard Result Code

Added On: 09/28/18

SQL Column: DCARD_RESULT_CODE

Java Field: dcardResultCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Dcard Result Text

Added On: 09/28/18

SQL Column: DCARD_RESULT_TEXT

Java Field: dcardResultText

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Discover Deposit Merchant Id

Added On: 09/28/18

SQL Column: DISCOVER_DEPOSIT_MERCHANT_ID

Java Field: discoverDepositMerchantId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Discover Originator Id

Added On: 09/28/18

SQL Column: DISCOVER_ORIGINATOR_ID

Java Field: discoverOriginatorId

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Email Address

Added On: 09/28/18

SQL Column: EMAIL_ADDRESS

Java Field: emailAddress

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Added On: 10/01/18

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Unique, Required, CreateOnly, ReadOnly

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

Interac Mvv

Added On: 09/28/18

SQL Column: INTERAC_MVV

Java Field: interacMvv

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Jcb Deposit Merchant Id

Added On: 09/28/18

SQL Column: JCB_DEPOSIT_MERCHANT_ID

Java Field: jcbDepositMerchantId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Jcb Originator Id

Added On: 09/28/18

SQL Column: JCB_ORIGINATOR_ID

Java Field: jcbOriginatorId

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Mc Deposit Merchant Id

Added On: 09/28/18

SQL Column: MC_DEPOSIT_MERCHANT_ID

Java Field: mcDepositMerchantId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Mc Originator Id

Added On: 09/28/18

SQL Column: MC_ORIGINATOR_ID

Java Field: mcOriginatorId

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Merchant Account Code

Added On: 10/01/18

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.\n\nDepending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.\n\nThe field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.

Merchant Account Number

Added On: 09/28/18

SQL Column: MERCHANT_ACCOUNT_NUMBER

Java Field: merchantAccountNumber

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes: Transient

Merchant Bank Number

Added On: 09/28/18

SQL Column: MERCHANT_BANK_NUMBER

Java Field: merchantBankNumber

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes: Transient

Merchant Branch Transit Number

Added On: 09/28/18

SQL Column: MERCHANT_BRANCH_TRANSIT_NUMBER

Java Field: merchantBranchTransitNumber

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes: Transient

Merchant Category Code

Added On: 09/28/18

SQL Column: MERCHANT_CATEGORY_CODE

Java Field: merchantCategoryCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Merchant Command

Added On: 09/28/18

SQL Column: MERCHANT_COMMAND

Java Field: merchantCommand

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Merchant Id

Added On: 09/28/18

SQL Column: MERCHANT_ID

Java Field: merchantId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Merchant Name

Added On: 09/28/18

SQL Column: MERCHANT_NAME

Java Field: merchantName

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Merchant Result Code

Added On: 09/28/18

SQL Column: MERCHANT_RESULT_CODE

Java Field: merchantResultCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Merchant Result Text

Added On: 09/28/18

SQL Column: MERCHANT_RESULT_TEXT

Java Field: merchantResultText

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Pay Facto Provisioning File Batch

Added On: 09/28/18

SQL Column: PAYFACTO_PROVISIONING_FILE_BATCH_FK

Java Field: payFactoProvisioningFileBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References PayFacto Provisioning File Batch

Attributes:

Phone Number

Added On: 09/28/18

SQL Column: PHONE_NUMBER

Java Field: phoneNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Postal Code

Added On: 09/28/18

SQL Column: POSTAL_CODE

Java Field: postalCode

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

Province

Added On: 09/28/18

SQL Column: PROVINCE

Java Field: province

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Provisioning Transaction

Added On: 09/28/18

SQL Column: PROVISIONING_TRANSACTION_FK

Java Field: provisioningTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Provisioning Transaction

Attributes:

Result Code

Added On: 09/28/18

SQL Column: RESULT_CODE

Java Field: resultCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Result Text

Added On: 09/28/18

SQL Column: RESULT_TEXT

Java Field: resultText

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Set Like Merchant Id

Added On: 09/28/18

SQL Column: SET_LIKE_MERCHANT_ID

Java Field: setLikeMerchantId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Street

Added On: 09/28/18

SQL Column: STREET

Java Field: street

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Visa Deposit Merchant Id

Added On: 09/28/18

SQL Column: VISA_DEPOSIT_MERCHANT_ID

Java Field: visaDepositMerchantId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Visa Originator Id

Added On: 09/28/18

SQL Column: VISA_ORIGINATOR_ID

Java Field: visaOriginatorId

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes: