Paymentech Principal UML


Added On:  09/03/18 
SQL Table:  PAYMENTECH_PRINCIPAL 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  PaymentechPrincipal 
Added On:  09/03/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.
Added On:  09/03/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.
Added On:  12/27/17
SQL Column:  BUSINESS_OWNER_FK
Java Field:  businessOwner
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Business Owner
Attributes:
Added On:  12/27/17
SQL Column:  PRINCIPAL_OWNER_FIRST_NAME
Java Field:  principalOwnerFirstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  12/27/17
SQL Column:  PRINCIPAL_OWNER_LAST_NAME
Java Field:  principalOwnerLastName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  12/27/17
SQL Column:  PRINCIPAL_OWNER_STREET_ADDRESS
Java Field:  principalOwnerStreetAddress
Status:  Active
SQL Type:  varchar(65)
Java Type:  String
Attributes:
Added On:  12/27/17
SQL Column:  PRINCIPAL_OWNER_STREET_ADDRESS2
Java Field:  principalOwnerStreetAddress2
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  12/27/17
SQL Column:  PRINCIPAL_OWNER_CITY
Java Field:  principalOwnerCity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  12/27/17
SQL Column:  PRINCIPAL_OWNER_STATE
Java Field:  principalOwnerState
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  12/27/17
SQL Column:  PRINCIPAL_OWNER_COUNTRY
Java Field:  principalOwnerCountry
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  12/27/17
SQL Column:  PRINCIPAL_OWNER_ZIP_CODE
Java Field:  principalOwnerZipCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  12/27/17
SQL Column:  PRINCIPAL_OWNER_DOB
Java Field:  principalOwnerDob
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  12/27/17
SQL Column:  PRINCIPAL_OWNER_TAX_ID
Java Field:  principalOwnerTaxId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  12/27/17
SQL Column:  PRINCIPAL_OWNER_ID_TYPE
Java Field:  principalOwnerIdType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  12/27/17
SQL Column:  PRINCIPAL_OWNER_PHONE_NUMBER
Java Field:  principalOwnerPhoneNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  12/27/17
SQL Column:  PAYMENTECH_PROVISIONING_TRANSACTION_FK
Java Field:  paymentechProvisioningTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/27/19
SQL Column:  ONBOARDING_OWNER_FK
Java Field:  onboardingOwner
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Onboarding Owner
Attributes: