First Data Processing Cost

Added On: 10/31/19

SQL Table: FIRST_DATA_PROCESSING_COST

Module: UniCharge

Type: Entity Status: Active

Java Class: FirstDataProcessingCost

Available Fields:

Aba Number Masked
Adjustment Amount
Adjustment Amount Sign
Adjustment Code
Adjustment Date
Adjustment Description
Adjustment Invoice Number
Adjustment Type
Bank Reference Number
Batch Date
Batch Number
Card Number Masked
Card Type
Currency Code
Dda Number Masked
External Id

First Data Processing Cost Batch
Funded Date
Hierarchy Id
Hierarchy Level No
Id
Interchange Expense
Interchange Expense Sign
Interchange Rate Code
Interchange Rate Description
Invoice Date
Location Dba Name
Location Id
Merchant Account Code
Net Amount
Net Amount Sign
New Adjustment Description

Process Currency Code
Processed Date
Processed Transaction Amount
Processed Transaction Amount Sign
Rate
Record Data
Sales Percent By Amount
Sales Percent By Count
Sds Reference Number
Special Reference 1
Store Number
Submit Date
Submitted Currency Code
Submitted Transaction Amount
Submitted Transaction Amount Sign
Transaction Count

Transaction Type
Unit Amount

Aba Number Masked

Added On: 10/31/19

SQL Column: ABA_NUMBER_MASKED

Java Field: abaNumberMasked

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Adjustment Amount

Added On: 10/31/19

SQL Column: ADJUSTMENT_AMOUNT

Java Field: adjustmentAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Adjustment Amount Sign

Added On: 10/31/19

SQL Column: ADJUSTMENT_AMOUNT_SIGN

Java Field: adjustmentAmountSign

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Adjustment Code

Added On: 10/31/19

SQL Column: ADJUSTMENT_CODE

Java Field: adjustmentCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Adjustment Date

Added On: 10/31/19

SQL Column: ADJUSTMENT_DATE

Java Field: adjustmentDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Adjustment Description

Added On: 10/31/19

SQL Column: ADJUSTMENT_DESCRIPTION

Java Field: adjustmentDescription

Status: Active

SQL Type: varchar(200)

Java Type: String

Attributes:

Adjustment Invoice Number

Added On: 10/31/19

SQL Column: ADJUSTMENT_INVOICE_NUMBER

Java Field: adjustmentInvoiceNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Adjustment Type

Added On: 10/31/19

SQL Column: ADJUSTMENT_TYPE

Java Field: adjustmentType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Bank Reference Number

Added On: 10/31/19

SQL Column: BANK_REFERENCE_NUMBER

Java Field: bankReferenceNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Batch Date

Added On: 10/31/19

SQL Column: BATCH_DATE

Java Field: batchDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Batch Number

Added On: 10/31/19

SQL Column: BATCH_NUMBER

Java Field: batchNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Card Number Masked

Added On: 10/31/19

SQL Column: CARD_NUMBER_MASKED

Java Field: cardNumberMasked

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Card Type

Added On: 10/31/19

SQL Column: CARD_TYPE

Java Field: cardType

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Currency Code

Added On: 10/31/19

SQL Column: CURRENCY_CODE

Java Field: currencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Dda Number Masked

Added On: 10/31/19

SQL Column: DDA_NUMBER_MASKED

Java Field: ddaNumberMasked

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

External Id

Added On: 10/31/19

SQL Column: EXTERNAL_ID

Java Field: externalId

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

First Data Processing Cost Batch

Added On: 10/31/19

SQL Column: FIRST_DATA_PROCESSING_COST_BATCH_FK

Java Field: firstDataProcessingCostBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References First Data Processing Cost Batch

Attributes:

Funded Date

Added On: 10/31/19

SQL Column: FUNDED_DATE

Java Field: fundedDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Hierarchy Id

Added On: 10/31/19

SQL Column: HIERARCHY_ID

Java Field: hierarchyId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Hierarchy Level No

Added On: 10/31/19

SQL Column: HIERARCHY_LEVEL_NO

Java Field: hierarchyLevelNo

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Added On: 11/12/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.

Interchange Expense

Added On: 10/31/19

SQL Column: INTERCHANGE_EXPENSE

Java Field: interchangeExpense

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

Interchange Expense Sign

Added On: 10/31/19

SQL Column: INTERCHANGE_EXPENSE_SIGN

Java Field: interchangeExpenseSign

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Interchange Rate Code

Added On: 10/31/19

SQL Column: INTERCHANGE_RATE_CODE

Java Field: interchangeRateCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Interchange Rate Description

Added On: 10/31/19

SQL Column: INTERCHANGE_RATE_DESCRIPTION

Java Field: interchangeRateDescription

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Invoice Date

Added On: 10/31/19

SQL Column: INVOICE_DATE

Java Field: invoiceDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Location Dba Name

Added On: 10/31/19

SQL Column: LOCATION_DBA_NAME

Java Field: locationDbaName

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Location Id

Added On: 10/31/19

SQL Column: LOCATION_ID

Java Field: locationId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Merchant Account Code

Added On: 11/12/19

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.

Net Amount

Added On: 10/31/19

SQL Column: NET_AMOUNT

Java Field: netAmount

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

Net Amount Sign

Added On: 10/31/19

SQL Column: NET_AMOUNT_SIGN

Java Field: netAmountSign

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

New Adjustment Description

Added On: 10/31/19

SQL Column: NEW_ADJUSTMENT_DESCRIPTION

Java Field: newAdjustmentDescription

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Process Currency Code

Added On: 10/31/19

SQL Column: PROCESS_CURRENCY_CODE

Java Field: processCurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Processed Date

Added On: 10/31/19

SQL Column: PROCESSED_DATE

Java Field: processedDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Processed Transaction Amount

Added On: 10/31/19

SQL Column: PROCESSED_TRANSACTION_AMOUNT

Java Field: processedTransactionAmount

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Processed Transaction Amount Sign

Added On: 10/31/19

SQL Column: PROCESSED_TRANSACTION_AMOUNT_SIGN

Java Field: processedTransactionAmountSign

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Rate

Added On: 10/31/19

SQL Column: RATE

Java Field: rate

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

Record Data

Added On: 10/31/19

SQL Column: RECORD_DATA

Java Field: recordData

Status: Active

SQL Type: varchar(2500)

Java Type: String

Attributes: Transient

Sales Percent By Amount

Added On: 10/31/19

SQL Column: SALES_PERCENT_BY_AMOUNT

Java Field: salesPercentByAmount

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Sales Percent By Count

Added On: 10/31/19

SQL Column: SALES_PERCENT_BY_COUNT

Java Field: salesPercentByCount

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Sds Reference Number

Added On: 10/31/19

SQL Column: SDS_REFERENCE_NUMBER

Java Field: sdsReferenceNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Special Reference 1

Added On: 10/31/19

SQL Column: SPECIAL_REFERENCE1

Java Field: specialReference1

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Store Number

Added On: 10/31/19

SQL Column: STORE_NUMBER

Java Field: storeNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Submit Date

Added On: 10/31/19

SQL Column: SUBMIT_DATE

Java Field: submitDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Submitted Currency Code

Added On: 10/31/19

SQL Column: SUBMITTED_CURRENCY_CODE

Java Field: submittedCurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Submitted Transaction Amount

Added On: 10/31/19

SQL Column: SUBMITTED_TRANSACTION_AMOUNT

Java Field: submittedTransactionAmount

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

Submitted Transaction Amount Sign

Added On: 10/31/19

SQL Column: SUBMITTED_TRANSACTION_AMOUNT_SIGN

Java Field: submittedTransactionAmountSign

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Transaction Count

Added On: 10/31/19

SQL Column: TRANSACTION_COUNT

Java Field: transactionCount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Transaction Type

Added On: 10/31/19

SQL Column: TRANSACTION_TYPE

Java Field: transactionType

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Unit Amount

Added On: 10/31/19

SQL Column: UNIT_AMOUNT

Java Field: unitAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes: