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:

• Ach Flag
• Aci
• Adjustment Amount
• Association Number
• Auth Amount
• Auth Currency Code
• Auth Response Code
• Auth Source
• Authorization Number
• Banknet Auth Date
• Banknet Reference Number
• Batch Julian Date
• Best Interchange Eligible
• Card Type
• Card Type 2
• Cardholder Account Number Masked
• Cardholder Id Method
• Carryover Indicator
• Cash Back Amount
• Cash Back Amount Sign
• Cashback Fee Amount
• Cashback Fee Sign
• Cat Indicator
• Charge Transaction
• Commercial Card Service Indicator
• Currency Code
• Dcc Indicator
• Debit Credit Indicator
• Debit Credit Indicator 2
• Debit Or Credit Indicator
• Discover Pos Entry Mode
• Discover Processing Code
• Discover Transaction Type
• Downgrade Reason 1
• Downgrade Reason 2
• Downgrade Reason 3
• Dr Address Verification Service Response
• Dr Entry Run Number
• Dr Extension Record Indicator
• Dr Mail Phone Installment Count
• Dr Mail Phone Installment Sequence Number
• Dr Merchant Account Number
• Dr Merchant Customer Service Phone Number
• Dr Purchase Id Direct Marketing Ord Number
• Dr Sequence Number Area

• Dr Sequence Number Within Entry Run
• Dr Total Authorized Amount
• Dr Transaction Code
• Draft A Flag
• Entry Run Number
• Extension Record Indicator
• Fee Amount
• Fee Type
• Foreign Card Indicator
• Iasf Fee Amount
• Iasf Fee Type
• Id
• Industry Se
• Interchange Flat Fee 4p
• Interchange Percentage Amount 4p
• Interchange Percentage Rate 4p
• Interchange Rate Name
• Local Transaction Time
• Mail Order Telephone Order Indicator
• Mc Lane Id
• Mcc Code
• Merchant Account Code
• Merchant Account Number
• Merchant Name
• Net Deposit
• Network Identifier Debit
• Online Entry
• Original Transaction Amount
• P 1 Customer Code
• P 1 Customer Vat Registration
• P 1 Destination Country Code
• P 1 Destination Zip
• P 1 Detail Record To Follow
• P 1 Discount Amount
• P 1 Duty Amount
• P 1 Entry Run Number
• P 1 Freight Amount
• P 1 Local Tax
• P 1 Local Tax Amount
• P 1 Merchant Account Number
• P 1 Merchant Reference Number
• P 1 Merchant Tax Id
• P 1 Merchant Type
• P 1 Merchant Vat Registration
• P 1 National Alt Tax Amount

• P 1 National Tax Included
• P 1 Order Date
• P 1 Other Tax
• P 1 Product Identifier
• P 1 Product Identifier 2
• P 1 Sequence Number Area
• P 1 Sequence Number Within Entry Run
• P 1 Ship From Zip Code
• P 1 Summary Commodity Code
• P 1 Transaction Code
• P 1 Vat Invoice Reference Number
• P 1 Vat Tax Amount Freight
• P 1 Vat Tax Rate Freight
• Pos Data Code
• Pos Entry Mode
• Product Id
• Program Registration Id
• Purchase Id
• Raw Data
• Reference Number
• Regulated Indicator
• Reimbursement Attribute
• Reject Reason
• Reversal Flag
• Seller Address
• Seller Dba
• Seller Email
• Seller Id
• Seller Phone
• Seller Postal Code
• Sequence Number Area
• Sequence Number Within Entry Run
• Submitted Interchange
• Switch Settled Indicator
• System Trace Audit Number
• Terminal Id
• Transaction Amount
• Transaction Code
• Transaction Data Condition Code
• Transaction Date
• Transaction Identifier
• Transaction Identity
• Tsys Processing Cost Batch
• Validation Code
• Visa Integrity Fee

Ach Flag

Added On:  02/04/19

SQL Column:  ACH_FLAG

Java Field:  achFlag

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Aci

Added On:  02/04/19

SQL Column:  ACI

Java Field:  aci

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Adjustment Amount

Added On:  02/04/19

SQL Column:  ADJUSTMENT_AMOUNT

Java Field:  adjustmentAmount

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Association Number

Added On:  02/04/19

SQL Column:  ASSOCIATION_NUMBER

Java Field:  associationNumber

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Auth Amount

Added On:  02/04/19

SQL Column:  AUTH_AMOUNT

Java Field:  authAmount

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Auth Currency Code

Added On:  02/04/19

SQL Column:  AUTH_CURRENCY_CODE

Java Field:  authCurrencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Auth Response Code

Added On:  02/04/19

SQL Column:  AUTH_RESPONSE_CODE

Java Field:  authResponseCode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Auth Source

Added On:  02/04/19

SQL Column:  AUTH_SOURCE

Java Field:  authSource

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Authorization Number

Added On:  02/04/19

SQL Column:  AUTHORIZATION_NUMBER

Java Field:  authorizationNumber

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Banknet Auth Date

Added On:  02/04/19

SQL Column:  BANKNET_AUTH_DATE

Java Field:  banknetAuthDate

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Banknet Reference Number

Added On:  02/04/19

SQL Column:  BANKNET_REFERENCE_NUMBER

Java Field:  banknetReferenceNumber

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Batch Julian Date

Added On:  02/04/19

SQL Column:  BATCH_JULIAN_DATE

Java Field:  batchJulianDate

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Best Interchange Eligible

Added On:  02/04/19

SQL Column:  BEST_INTERCHANGE_ELIGIBLE

Java Field:  bestInterchangeEligible

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Card Type

Added On:  02/04/19

SQL Column:  CARD_TYPE

Java Field:  cardType

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Card Type 2

Added On:  02/04/19

SQL Column:  CARD_TYPE2

Java Field:  cardType2

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Cardholder Account Number Masked

Added On:  02/04/19

SQL Column:  CARDHOLDER_ACCOUNT_NUMBER_MASKED

Java Field:  cardholderAccountNumberMasked

Status:  Active

SQL Type:  varchar(19)

Java Type:  String

Attributes:

Cardholder Id Method

Added On:  02/04/19

SQL Column:  CARDHOLDER_ID_METHOD

Java Field:  cardholderIdMethod

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Carryover Indicator

Added On:  02/04/19

SQL Column:  CARRYOVER_INDICATOR

Java Field:  carryoverIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Cash Back Amount

Added On:  02/04/19

SQL Column:  CASH_BACK_AMOUNT

Java Field:  cashBackAmount

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Cash Back Amount Sign

Added On:  02/04/19

SQL Column:  CASH_BACK_AMOUNT_SIGN

Java Field:  cashBackAmountSign

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Cashback Fee Amount

Added On:  02/04/19

SQL Column:  CASHBACK_FEE_AMOUNT

Java Field:  cashbackFeeAmount

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Cashback Fee Sign

Added On:  02/04/19

SQL Column:  CASHBACK_FEE_SIGN

Java Field:  cashbackFeeSign

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Cat Indicator

Added On:  02/04/19

SQL Column:  CAT_INDICATOR

Java Field:  catIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Charge Transaction

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:

Commercial Card Service Indicator

Added On:  02/04/19

SQL Column:  COMMERCIAL_CARD_SERVICE_INDICATOR

Java Field:  commercialCardServiceIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Currency Code

Added On:  02/04/19

SQL Column:  CURRENCY_CODE

Java Field:  currencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Dcc Indicator

Added On:  02/04/19

SQL Column:  DCC_INDICATOR

Java Field:  dccIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Debit Credit Indicator

Added On:  02/04/19

SQL Column:  DEBIT_CREDIT_INDICATOR

Java Field:  debitCreditIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Debit Credit Indicator 2

Added On:  02/04/19

SQL Column:  DEBIT_CREDIT_INDICATOR2

Java Field:  debitCreditIndicator2

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Debit Or Credit Indicator

Added On:  02/04/19

SQL Column:  DEBIT_OR_CREDIT_INDICATOR

Java Field:  debitOrCreditIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Discover Pos Entry Mode

Added On:  02/04/19

SQL Column:  DISCOVER_POS_ENTRY_MODE

Java Field:  discoverPosEntryMode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Discover Processing Code

Added On:  02/04/19

SQL Column:  DISCOVER_PROCESSING_CODE

Java Field:  discoverProcessingCode

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Discover Transaction Type

Added On:  02/04/19

SQL Column:  DISCOVER_TRANSACTION_TYPE

Java Field:  discoverTransactionType

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Downgrade Reason 1

Added On:  02/04/19

SQL Column:  DOWNGRADE_REASON1

Java Field:  downgradeReason1

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Downgrade Reason 2

Added On:  02/04/19

SQL Column:  DOWNGRADE_REASON2

Java Field:  downgradeReason2

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Downgrade Reason 3

Added On:  02/04/19

SQL Column:  DOWNGRADE_REASON3

Java Field:  downgradeReason3

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Dr Address Verification Service Response

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:

Dr Entry Run Number

Added On:  02/04/19

SQL Column:  DR_ENTRY_RUN_NUMBER

Java Field:  drEntryRunNumber

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Dr Extension Record Indicator

Added On:  02/04/19

SQL Column:  DR_EXTENSION_RECORD_INDICATOR

Java Field:  drExtensionRecordIndicator

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Dr Mail Phone Installment Count

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:

Dr Mail Phone Installment Sequence Number

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:

Dr Merchant Account Number

Added On:  02/04/19

SQL Column:  DR_MERCHANT_ACCOUNT_NUMBER

Java Field:  drMerchantAccountNumber

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

Dr Merchant Customer Service Phone Number

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:

Dr Purchase Id Direct Marketing Ord Number

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:

Dr Sequence Number Area

Added On:  02/04/19

SQL Column:  DR_SEQUENCE_NUMBER_AREA

Java Field:  drSequenceNumberArea

Status:  Active

SQL Type:  varchar(7)

Java Type:  String

Attributes:

Dr Sequence Number Within Entry Run

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:

Dr Total Authorized Amount

Added On:  02/04/19

SQL Column:  DR_TOTAL_AUTHORIZED_AMOUNT

Java Field:  drTotalAuthorizedAmount

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Dr Transaction Code

Added On:  02/04/19

SQL Column:  DR_TRANSACTION_CODE

Java Field:  drTransactionCode

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Draft A Flag

Added On:  02/04/19

SQL Column:  DRAFT_A_FLAG

Java Field:  draftAFlag

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Entry Run Number

Added On:  02/04/19

SQL Column:  ENTRY_RUN_NUMBER

Java Field:  entryRunNumber

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Extension Record Indicator

Added On:  02/04/19

SQL Column:  EXTENSION_RECORD_INDICATOR

Java Field:  extensionRecordIndicator

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Fee Amount

Added On:  02/04/19

SQL Column:  FEE_AMOUNT

Java Field:  feeAmount

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Fee Type

Added On:  02/04/19

SQL Column:  FEE_TYPE

Java Field:  feeType

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Foreign Card Indicator

Added On:  02/04/19

SQL Column:  FOREIGN_CARD_INDICATOR

Java Field:  foreignCardIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Iasf Fee Amount

Added On:  02/04/19

SQL Column:  IASF_FEE_AMOUNT

Java Field:  iasfFeeAmount

Status:  Active

SQL Type:  varchar(11)

Java Type:  String

Attributes:

Iasf Fee Type

Added On:  02/04/19

SQL Column:  IASF_FEE_TYPE

Java Field:  iasfFeeType

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Id

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.

Industry Se

Added On:  02/04/19

SQL Column:  INDUSTRY_SE

Java Field:  industrySe

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Interchange Flat Fee 4p

Added On:  02/04/19

SQL Column:  INTERCHANGE_FLAT_FEE4P

Java Field:  interchangeFlatFee4p

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Interchange Percentage Amount 4p

Added On:  02/04/19

SQL Column:  INTERCHANGE_PERCENTAGE_AMOUNT4P

Java Field:  interchangePercentageAmount4p

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Interchange Percentage Rate 4p

Added On:  02/04/19

SQL Column:  INTERCHANGE_PERCENTAGE_RATE4P

Java Field:  interchangePercentageRate4p

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Interchange Rate Name

Added On:  02/04/19

SQL Column:  INTERCHANGE_RATE_NAME

Java Field:  interchangeRateName

Status:  Active

SQL Type:  varchar(65)

Java Type:  String

Attributes:

Local Transaction Time

Added On:  02/04/19

SQL Column:  LOCAL_TRANSACTION_TIME

Java Field:  localTransactionTime

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Mail Order Telephone Order Indicator

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:

Mc Lane Id

Added On:  02/04/19

SQL Column:  MC_LANE_ID

Java Field:  mcLaneId

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

Mcc Code

Added On:  02/04/19

SQL Column:  MCC_CODE

Java Field:  mccCode

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Merchant Account Code

Added On:  02/04/19

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Merchant Account Number

Added On:  02/04/19

SQL Column:  MERCHANT_ACCOUNT_NUMBER

Java Field:  merchantAccountNumber

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

Merchant Name

Added On:  02/04/19

SQL Column:  MERCHANT_NAME

Java Field:  merchantName

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Net Deposit

Added On:  02/04/19

SQL Column:  NET_DEPOSIT

Java Field:  netDeposit

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Network Identifier Debit

Added On:  02/04/19

SQL Column:  NETWORK_IDENTIFIER_DEBIT

Java Field:  networkIdentifierDebit

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Online Entry

Added On:  02/04/19

SQL Column:  ONLINE_ENTRY

Java Field:  onlineEntry

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Original Transaction Amount

Added On:  02/04/19

SQL Column:  ORIGINAL_TRANSACTION_AMOUNT

Java Field:  originalTransactionAmount

Status:  Active

SQL Type:  varchar(11)

Java Type:  String

Attributes:

P 1 Customer Code

Added On:  02/04/19

SQL Column:  P1_CUSTOMER_CODE

Java Field:  p1CustomerCode

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

P 1 Customer Vat Registration

Added On:  02/04/19

SQL Column:  P1_CUSTOMER_VAT_REGISTRATION

Java Field:  p1CustomerVatRegistration

Status:  Active

SQL Type:  varchar(13)

Java Type:  String

Attributes:

P 1 Destination Country Code

Added On:  02/04/19

SQL Column:  P1_DESTINATION_COUNTRY_CODE

Java Field:  p1DestinationCountryCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

P 1 Destination Zip

Added On:  02/04/19

SQL Column:  P1_DESTINATION_ZIP

Java Field:  p1DestinationZip

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

P 1 Detail Record To Follow

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:

P 1 Discount Amount

Added On:  02/04/19

SQL Column:  P1_DISCOUNT_AMOUNT

Java Field:  p1DiscountAmount

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

P 1 Duty Amount

Added On:  02/04/19

SQL Column:  P1_DUTY_AMOUNT

Java Field:  p1DutyAmount

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

P 1 Entry Run Number

Added On:  02/04/19

SQL Column:  P1_ENTRY_RUN_NUMBER

Java Field:  p1EntryRunNumber

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

P 1 Freight Amount

Added On:  02/04/19

SQL Column:  P1_FREIGHT_AMOUNT

Java Field:  p1FreightAmount

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

P 1 Local Tax

Added On:  02/04/19

SQL Column:  P1_LOCAL_TAX

Java Field:  p1LocalTax

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

P 1 Local Tax Amount

Added On:  02/04/19

SQL Column:  P1_LOCAL_TAX_AMOUNT

Java Field:  p1LocalTaxAmount

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

P 1 Merchant Account Number

Added On:  02/04/19

SQL Column:  P1_MERCHANT_ACCOUNT_NUMBER

Java Field:  p1MerchantAccountNumber

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

P 1 Merchant Reference Number

Added On:  02/04/19

SQL Column:  P1_MERCHANT_REFERENCE_NUMBER

Java Field:  p1MerchantReferenceNumber

Status:  Active

SQL Type:  varchar(17)

Java Type:  String

Attributes:

P 1 Merchant Tax Id

Added On:  02/04/19

SQL Column:  P1_MERCHANT_TAX_ID

Java Field:  p1MerchantTaxId

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

P 1 Merchant Type

Added On:  02/04/19

SQL Column:  P1_MERCHANT_TYPE

Java Field:  p1MerchantType

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

P 1 Merchant Vat Registration

Added On:  02/04/19

SQL Column:  P1_MERCHANT_VAT_REGISTRATION

Java Field:  p1MerchantVatRegistration

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

P 1 National Alt Tax Amount

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:

P 1 National Tax Included

Added On:  02/04/19

SQL Column:  P1_NATIONAL_TAX_INCLUDED

Java Field:  p1NationalTaxIncluded

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

P 1 Order Date

Added On:  02/04/19

SQL Column:  P1_ORDER_DATE

Java Field:  p1OrderDate

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

P 1 Other Tax

Added On:  02/04/19

SQL Column:  P1_OTHER_TAX

Java Field:  p1OtherTax

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

P 1 Product Identifier

Added On:  02/04/19

SQL Column:  P1_PRODUCT_IDENTIFIER

Java Field:  p1ProductIdentifier

Status:  Active

SQL Type:  varchar(17)

Java Type:  String

Attributes:

P 1 Product Identifier 2

Added On:  02/04/19

SQL Column:  P1_PRODUCT_IDENTIFIER2

Java Field:  p1ProductIdentifier2

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

P 1 Sequence Number Area

Added On:  02/04/19

SQL Column:  P1_SEQUENCE_NUMBER_AREA

Java Field:  p1SequenceNumberArea

Status:  Active

SQL Type:  varchar(7)

Java Type:  String

Attributes:

P 1 Sequence Number Within Entry Run

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:

P 1 Ship From Zip Code

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:

P 1 Summary Commodity Code

Added On:  02/04/19

SQL Column:  P1_SUMMARY_COMMODITY_CODE

Java Field:  p1SummaryCommodityCode

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

P 1 Transaction Code

Added On:  02/04/19

SQL Column:  P1_TRANSACTION_CODE

Java Field:  p1TransactionCode

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

P 1 Vat Invoice Reference Number

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:

P 1 Vat Tax Amount Freight

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:

P 1 Vat Tax Rate Freight

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:

Pos Data Code

Added On:  02/04/19

SQL Column:  POS_DATA_CODE

Java Field:  posDataCode

Status:  Active

SQL Type:  varchar(13)

Java Type:  String

Attributes:

Pos Entry Mode

Added On:  02/04/19

SQL Column:  POS_ENTRY_MODE

Java Field:  posEntryMode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Product Id

Added On:  02/04/19

SQL Column:  PRODUCT_ID

Java Field:  productId

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Program Registration Id

Added On:  02/04/19

SQL Column:  PROGRAM_REGISTRATION_ID

Java Field:  programRegistrationId

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Purchase Id

Added On:  02/04/19

SQL Column:  PURCHASE_ID

Java Field:  purchaseId

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Raw Data

Added On:  02/04/19

SQL Column:  RAW_DATA

Java Field:  rawData

Status:  Active

SQL Type:  varchar(1202)

Java Type:  String

Attributes: Transient

Reference Number

Added On:  02/04/19

SQL Column:  REFERENCE_NUMBER

Java Field:  referenceNumber

Status:  Active

SQL Type:  varchar(23)

Java Type:  String

Attributes:

Regulated Indicator

Added On:  02/04/19

SQL Column:  REGULATED_INDICATOR

Java Field:  regulatedIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Reimbursement Attribute

Added On:  02/04/19

SQL Column:  REIMBURSEMENT_ATTRIBUTE

Java Field:  reimbursementAttribute

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Reject Reason

Added On:  02/04/19

SQL Column:  REJECT_REASON

Java Field:  rejectReason

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Reversal Flag

Added On:  02/04/19

SQL Column:  REVERSAL_FLAG

Java Field:  reversalFlag

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Seller Address

Added On:  02/04/19

SQL Column:  SELLER_ADDRESS

Java Field:  sellerAddress

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Seller Dba

Added On:  02/04/19

SQL Column:  SELLER_DBA

Java Field:  sellerDba

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Seller Email

Added On:  02/04/19

SQL Column:  SELLER_EMAIL

Java Field:  sellerEmail

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Seller Id

Added On:  02/04/19

SQL Column:  SELLER_ID

Java Field:  sellerId

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Seller Phone

Added On:  02/04/19

SQL Column:  SELLER_PHONE

Java Field:  sellerPhone

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

Seller Postal Code

Added On:  02/04/19

SQL Column:  SELLER_POSTAL_CODE

Java Field:  sellerPostalCode

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Sequence Number Area

Added On:  02/04/19

SQL Column:  SEQUENCE_NUMBER_AREA

Java Field:  sequenceNumberArea

Status:  Active

SQL Type:  varchar(7)

Java Type:  String

Attributes:

Sequence Number Within Entry Run

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:

Submitted Interchange

Added On:  02/04/19

SQL Column:  SUBMITTED_INTERCHANGE

Java Field:  submittedInterchange

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Switch Settled Indicator

Added On:  02/04/19

SQL Column:  SWITCH_SETTLED_INDICATOR

Java Field:  switchSettledIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

System Trace Audit Number

Added On:  02/04/19

SQL Column:  SYSTEM_TRACE_AUDIT_NUMBER

Java Field:  systemTraceAuditNumber

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Terminal Id

Added On:  02/04/19

SQL Column:  TERMINAL_ID

Java Field:  terminalId

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

Transaction Amount

Added On:  02/04/19

SQL Column:  TRANSACTION_AMOUNT

Java Field:  transactionAmount

Status:  Active

SQL Type:  varchar(11)

Java Type:  String

Attributes:

Transaction Code

Added On:  02/04/19

SQL Column:  TRANSACTION_CODE

Java Field:  transactionCode

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Transaction Data Condition Code

Added On:  02/04/19

SQL Column:  TRANSACTION_DATA_CONDITION_CODE

Java Field:  transactionDataConditionCode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Transaction Date

Added On:  02/04/19

SQL Column:  TRANSACTION_DATE

Java Field:  transactionDate

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

Transaction Identifier

Added On:  02/04/19

SQL Column:  TRANSACTION_IDENTIFIER

Java Field:  transactionIdentifier

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Transaction Identity

Added On:  02/04/19

SQL Column:  TRANSACTION_IDENTITY

Java Field:  transactionIdentity

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Tsys Processing Cost Batch

Added On:  02/04/19

SQL Column:  TSYS_PROCESSING_COST_BATCH_FK

Java Field:  tsysProcessingCostBatch

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Tsys Processing Cost Batch

Attributes:

Validation Code

Added On:  02/04/19

SQL Column:  VALIDATION_CODE

Java Field:  validationCode

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Visa Integrity Fee

Added On:  02/04/19

SQL Column:  VISA_INTEGRITY_FEE

Java Field:  visaIntegrityFee

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes: