Tsys Processing Cost UML


Added On:  06/07/19 
SQL Table:  TSYS_PROCESSING_COST 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  TsysProcessingCost 
Available Fields:
Added On:  06/07/19
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:  02/04/19
SQL Column:  CHARGE_TRANSACTION_FK
Java Field:  chargeTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Charge Transaction
Attributes:
Added On:  02/04/19
SQL Column:  RAW_DATA
Java Field:  rawData
Status:  Active
SQL Type:  varchar(1202)
Java Type:  String
Attributes: Transient
Added On:  02/04/19
SQL Column:  TRANSACTION_IDENTITY
Java Field:  transactionIdentity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  TSYS_PROCESSING_COST_BATCH_FK
Java Field:  tsysProcessingCostBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  02/04/19
SQL Column:  SEQUENCE_NUMBER_AREA
Java Field:  sequenceNumberArea
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  ENTRY_RUN_NUMBER
Java Field:  entryRunNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  SEQUENCE_NUMBER_WITHIN_ENTRY_RUN
Java Field:  sequenceNumberWithinEntryRun
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  MERCHANT_ACCOUNT_NUMBER
Java Field:  merchantAccountNumber
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  TRANSACTION_CODE
Java Field:  transactionCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  ASSOCIATION_NUMBER
Java Field:  associationNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  REFERENCE_NUMBER
Java Field:  referenceNumber
Status:  Active
SQL Type:  varchar(23)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  TRANSACTION_DATE
Java Field:  transactionDate
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  TRANSACTION_AMOUNT
Java Field:  transactionAmount
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  BATCH_JULIAN_DATE
Java Field:  batchJulianDate
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  NET_DEPOSIT
Java Field:  netDeposit
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  CARDHOLDER_ACCOUNT_NUMBER_MASKED
Java Field:  cardholderAccountNumberMasked
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  BEST_INTERCHANGE_ELIGIBLE
Java Field:  bestInterchangeEligible
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  TRANSACTION_DATA_CONDITION_CODE
Java Field:  transactionDataConditionCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DOWNGRADE_REASON1
Java Field:  downgradeReason1
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DOWNGRADE_REASON2
Java Field:  downgradeReason2
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DOWNGRADE_REASON3
Java Field:  downgradeReason3
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  ONLINE_ENTRY
Java Field:  onlineEntry
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  ACH_FLAG
Java Field:  achFlag
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  AUTH_SOURCE
Java Field:  authSource
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  CARDHOLDER_ID_METHOD
Java Field:  cardholderIdMethod
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  CAT_INDICATOR
Java Field:  catIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  REIMBURSEMENT_ATTRIBUTE
Java Field:  reimbursementAttribute
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  MAIL_ORDER_TELEPHONE_ORDER_INDICATOR
Java Field:  mailOrderTelephoneOrderIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  ACI
Java Field:  aci
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  BANKNET_REFERENCE_NUMBER
Java Field:  banknetReferenceNumber
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  BANKNET_AUTH_DATE
Java Field:  banknetAuthDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  TRANSACTION_IDENTIFIER
Java Field:  transactionIdentifier
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DRAFT_A_FLAG
Java Field:  draftAFlag
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  AUTH_CURRENCY_CODE
Java Field:  authCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  AUTH_AMOUNT
Java Field:  authAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  VALIDATION_CODE
Java Field:  validationCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  AUTH_RESPONSE_CODE
Java Field:  authResponseCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  NETWORK_IDENTIFIER_DEBIT
Java Field:  networkIdentifierDebit
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  SWITCH_SETTLED_INDICATOR
Java Field:  switchSettledIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  POS_ENTRY_MODE
Java Field:  posEntryMode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DEBIT_CREDIT_INDICATOR
Java Field:  debitCreditIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  REVERSAL_FLAG
Java Field:  reversalFlag
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  MERCHANT_NAME
Java Field:  merchantName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  AUTHORIZATION_NUMBER
Java Field:  authorizationNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  REJECT_REASON
Java Field:  rejectReason
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  CARD_TYPE
Java Field:  cardType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  CURRENCY_CODE
Java Field:  currencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  ORIGINAL_TRANSACTION_AMOUNT
Java Field:  originalTransactionAmount
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  FOREIGN_CARD_INDICATOR
Java Field:  foreignCardIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  CARRYOVER_INDICATOR
Java Field:  carryoverIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  EXTENSION_RECORD_INDICATOR
Java Field:  extensionRecordIndicator
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  MCC_CODE
Java Field:  mccCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  TERMINAL_ID
Java Field:  terminalId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DISCOVER_POS_ENTRY_MODE
Java Field:  discoverPosEntryMode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  PURCHASE_ID
Java Field:  purchaseId
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  CASH_BACK_AMOUNT
Java Field:  cashBackAmount
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  CASH_BACK_AMOUNT_SIGN
Java Field:  cashBackAmountSign
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  POS_DATA_CODE
Java Field:  posDataCode
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  PROGRAM_REGISTRATION_ID
Java Field:  programRegistrationId
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  CARD_TYPE2
Java Field:  cardType2
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  PRODUCT_ID
Java Field:  productId
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  SUBMITTED_INTERCHANGE
Java Field:  submittedInterchange
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  SYSTEM_TRACE_AUDIT_NUMBER
Java Field:  systemTraceAuditNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DISCOVER_TRANSACTION_TYPE
Java Field:  discoverTransactionType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  LOCAL_TRANSACTION_TIME
Java Field:  localTransactionTime
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DISCOVER_PROCESSING_CODE
Java Field:  discoverProcessingCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  COMMERCIAL_CARD_SERVICE_INDICATOR
Java Field:  commercialCardServiceIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  FEE_AMOUNT
Java Field:  feeAmount
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  FEE_TYPE
Java Field:  feeType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DCC_INDICATOR
Java Field:  dccIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  REGULATED_INDICATOR
Java Field:  regulatedIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  VISA_INTEGRITY_FEE
Java Field:  visaIntegrityFee
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  IASF_FEE_TYPE
Java Field:  iasfFeeType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  IASF_FEE_AMOUNT
Java Field:  iasfFeeAmount
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DEBIT_OR_CREDIT_INDICATOR
Java Field:  debitOrCreditIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  ADJUSTMENT_AMOUNT
Java Field:  adjustmentAmount
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DEBIT_CREDIT_INDICATOR2
Java Field:  debitCreditIndicator2
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  CASHBACK_FEE_AMOUNT
Java Field:  cashbackFeeAmount
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  CASHBACK_FEE_SIGN
Java Field:  cashbackFeeSign
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  INDUSTRY_SE
Java Field:  industrySe
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  SELLER_ID
Java Field:  sellerId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  SELLER_DBA
Java Field:  sellerDba
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  SELLER_ADDRESS
Java Field:  sellerAddress
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  SELLER_PHONE
Java Field:  sellerPhone
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  SELLER_POSTAL_CODE
Java Field:  sellerPostalCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  SELLER_EMAIL
Java Field:  sellerEmail
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  MC_LANE_ID
Java Field:  mcLaneId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_SEQUENCE_NUMBER_AREA
Java Field:  p1SequenceNumberArea
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_ENTRY_RUN_NUMBER
Java Field:  p1EntryRunNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_SEQUENCE_NUMBER_WITHIN_ENTRY_RUN
Java Field:  p1SequenceNumberWithinEntryRun
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_MERCHANT_ACCOUNT_NUMBER
Java Field:  p1MerchantAccountNumber
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_TRANSACTION_CODE
Java Field:  p1TransactionCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_VAT_TAX_AMOUNT_FREIGHT
Java Field:  p1VatTaxAmountFreight
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_VAT_TAX_RATE_FREIGHT
Java Field:  p1VatTaxRateFreight
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_PRODUCT_IDENTIFIER
Java Field:  p1ProductIdentifier
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_PRODUCT_IDENTIFIER2
Java Field:  p1ProductIdentifier2
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_CUSTOMER_CODE
Java Field:  p1CustomerCode
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_LOCAL_TAX
Java Field:  p1LocalTax
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_LOCAL_TAX_AMOUNT
Java Field:  p1LocalTaxAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_FREIGHT_AMOUNT
Java Field:  p1FreightAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_DESTINATION_ZIP
Java Field:  p1DestinationZip
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_MERCHANT_TYPE
Java Field:  p1MerchantType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_DUTY_AMOUNT
Java Field:  p1DutyAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_MERCHANT_TAX_ID
Java Field:  p1MerchantTaxId
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_SHIP_FROM_ZIP_CODE
Java Field:  p1ShipFromZipCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_NATIONAL_TAX_INCLUDED
Java Field:  p1NationalTaxIncluded
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_NATIONAL_ALT_TAX_AMOUNT
Java Field:  p1NationalAltTaxAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_OTHER_TAX
Java Field:  p1OtherTax
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_DESTINATION_COUNTRY_CODE
Java Field:  p1DestinationCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_MERCHANT_REFERENCE_NUMBER
Java Field:  p1MerchantReferenceNumber
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_DISCOUNT_AMOUNT
Java Field:  p1DiscountAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_MERCHANT_VAT_REGISTRATION
Java Field:  p1MerchantVatRegistration
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_CUSTOMER_VAT_REGISTRATION
Java Field:  p1CustomerVatRegistration
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_SUMMARY_COMMODITY_CODE
Java Field:  p1SummaryCommodityCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_VAT_INVOICE_REFERENCE_NUMBER
Java Field:  p1VatInvoiceReferenceNumber
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_ORDER_DATE
Java Field:  p1OrderDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  P1_DETAIL_RECORD_TO_FOLLOW
Java Field:  p1DetailRecordToFollow
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DR_SEQUENCE_NUMBER_AREA
Java Field:  drSequenceNumberArea
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DR_ENTRY_RUN_NUMBER
Java Field:  drEntryRunNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DR_SEQUENCE_NUMBER_WITHIN_ENTRY_RUN
Java Field:  drSequenceNumberWithinEntryRun
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DR_MERCHANT_ACCOUNT_NUMBER
Java Field:  drMerchantAccountNumber
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DR_TRANSACTION_CODE
Java Field:  drTransactionCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DR_PURCHASE_ID_DIRECT_MARKETING_ORD_NUMBER
Java Field:  drPurchaseIdDirectMarketingOrdNumber
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DR_ADDRESS_VERIFICATION_SERVICE_RESPONSE
Java Field:  drAddressVerificationServiceResponse
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DR_TOTAL_AUTHORIZED_AMOUNT
Java Field:  drTotalAuthorizedAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DR_MERCHANT_CUSTOMER_SERVICE_PHONE_NUMBER
Java Field:  drMerchantCustomerServicePhoneNumber
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DR_MAIL_PHONE_INSTALLMENT_SEQUENCE_NUMBER
Java Field:  drMailPhoneInstallmentSequenceNumber
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DR_MAIL_PHONE_INSTALLMENT_COUNT
Java Field:  drMailPhoneInstallmentCount
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  DR_EXTENSION_RECORD_INDICATOR
Java Field:  drExtensionRecordIndicator
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/04/19
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/04/19
SQL Column:  INTERCHANGE_FLAT_FEE4P
Java Field:  interchangeFlatFee4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/04/19
SQL Column:  INTERCHANGE_PERCENTAGE_RATE4P
Java Field:  interchangePercentageRate4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/04/19
SQL Column:  INTERCHANGE_PERCENTAGE_AMOUNT4P
Java Field:  interchangePercentageAmount4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/04/19
SQL Column:  INTERCHANGE_RATE_NAME
Java Field:  interchangeRateName
Status:  Active
SQL Type:  varchar(65)
Java Type:  String
Attributes: