Amex Processing Cost

Added On: 06/07/15

SQL Table: AMEX_PROCESSING_COST

Module: UniCharge

Type: Entity Status: Active

Java Class: AmexProcessingCost

Represents processing cost record as it is defined in Amex's processing cost specification.

Available Fields:

Amex Payee Number
Amex Se Number
Approval Code
Asset Billing Amount
Asset Billing Description
Asset Billing Tax
Batch Code
Bill Code
Cost Matching Status CL
Discount Amount
Discount Rate
Fee Amount
Fee Code
Fee Description
Fee Rate
Id
Merchant Account Code
Merchant Category Code
Merchant ID
Non Compliant Error Code1
Non Compliant Error Code2
Non Compliant Error Code3
Non Compliant Error Code4
Non Compliant Indicator
Non Swiped Indicator

Other Fee Amount
Other Fee Description
Pay In Gross Indicator
Payment Number
Payment Year
Se Rej Ind
Se Unit Number
SOC Detail Amex Gross Amount
SOC Detail Amex Payee Number
SOC Detail Amex Process Date
SOC Detail Amex ROC Count
SOC Detail Amex ROC Count POA
SOC Detail Amex Se Number
SOC Detail Base Discount Amount
SOC Detail Card Not Present BPA Amount
SOC Detail Card Not Present BPA Rate
SOC Detail Card Not Present PTA Amount
SOC Detail Card Not Present PTA Rate
SOC Detail CPC Indicator
SOC Detail Discount Amount
SOC Detail Discount Rate
SOC Detail Net SOC Amount
SOC Detail Payment Number
SOC Detail Payment Year
SOC Detail Se Business Date

SOC Detail Se Unit Number
SOC Detail Service Fee Amount
SOC Detail Service Fee Rate
SOC Detail SOC Amount
SOC Detail SOC Invoice Number
SOC Detail Tracking ID
SOC Detail Transaction Fee Amount
SOC Detail Transaction Fee Rate
Take One Commision Amount
Take One Description
Terminal ID
Tlrr Amex Payee Number
Tlrr AmEx Process Date
Tlrr Amex Se Number
Tlrr Cm Number
Tlrr Cm Ref No
Tlrr Payment Number
Tlrr Payment Year
Tlrr ROC Amount
Tlrr Se Business Date
Tlrr Se Ref Poa
Tlrr Se Unit Number
Tlrr SOC Amount
Tlrr SOC Invoice Number
Tlrr Tran Date

Transaction Time

Amex Payee Number

Added On: 06/07/15

SQL Column: AMEX_PAYEE_NUMBER

Java Field: amexPayeeNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Amex Se Number

Added On: 06/07/15

SQL Column: AMEX_SE_NUMBER

Java Field: amexSeNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Approval Code

Added On: 06/07/15

SQL Column: APPROVAL_CODE

Java Field: approvalCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Authorization code returned by Provider that approved this transaction. In some instances might also be used to store response code returned by Provider when transaction declines.

Asset Billing Amount

Added On: 06/20/15

SQL Column: ASSET_BILLING_AMOUNT

Java Field: assetBillingAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Asset Billing Description

Added On: 06/20/15

SQL Column: ASSET_BILLING_DESCRIPTION

Java Field: assetBillingDescription

Status: Active

SQL Type: varchar(65)

Java Type: String

Attributes:

Asset Billing Tax

Added On: 06/20/15

SQL Column: ASSET_BILLING_TAX

Java Field: assetBillingTax

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Batch Code

Added On: 06/20/15

SQL Column: BATCH_CODE

Java Field: batchCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bill Code

Added On: 06/20/15

SQL Column: BILL_CODE

Java Field: billCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Cost Matching Status CL

Added On: 06/09/15

SQL Column: COST_MATCHING_STATUS_CL

Java Field: costMatchingStatusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Cost Matching Status Classifier

Attributes:

Represents current cost matching status.

Discount Amount

Added On: 06/07/15

SQL Column: DISCOUNT_AMOUNT

Java Field: discountAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Discount Rate

Added On: 06/07/15

SQL Column: DISCOUNT_RATE

Java Field: discountRate

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Fee Amount

Added On: 06/07/15

SQL Column: FEE_AMOUNT

Java Field: feeAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Fee Code

Added On: 06/07/15

SQL Column: FEE_CODE

Java Field: feeCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Fee Description

Added On: 06/07/15

SQL Column: FEE_DESCRIPTION

Java Field: feeDescription

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Fee Rate

Added On: 06/07/15

SQL Column: FEE_RATE

Java Field: feeRate

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Added On: 06/07/15

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.

Merchant Account Code

Added On: 06/07/15

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. Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The 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 Category Code

Added On: 06/07/15

SQL Column: MERCHANT_CATEGORY_CODE

Java Field: merchantCategoryCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Merchant ID

Added On: 06/07/15

SQL Column: MERCHANT_ID

Java Field: merchantId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Non Compliant Error Code1

Added On: 06/07/15

SQL Column: NON_COMPLIANT_ERROR_CODE1

Java Field: nonCompliantErrorCode1

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Non Compliant Error Code2

Added On: 06/07/15

SQL Column: NON_COMPLIANT_ERROR_CODE2

Java Field: nonCompliantErrorCode2

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Non Compliant Error Code3

Added On: 06/07/15

SQL Column: NON_COMPLIANT_ERROR_CODE3

Java Field: nonCompliantErrorCode3

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Non Compliant Error Code4

Added On: 06/07/15

SQL Column: NON_COMPLIANT_ERROR_CODE4

Java Field: nonCompliantErrorCode4

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Non Compliant Indicator

Added On: 06/07/15

SQL Column: NON_COMPLIANT_INDICATOR

Java Field: nonCompliantIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Non Swiped Indicator

Added On: 06/07/15

SQL Column: NON_SWIPED_INDICATOR

Java Field: nonSwipedIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Other Fee Amount

Added On: 06/20/15

SQL Column: OTHER_FEE_AMOUNT

Java Field: otherFeeAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Other Fee Description

Added On: 06/20/15

SQL Column: OTHER_FEE_DESCRIPTION

Java Field: otherFeeDescription

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Pay In Gross Indicator

Added On: 06/20/15

SQL Column: PAY_IN_GROSS_INDICATOR

Java Field: payInGrossIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Payment Number

Added On: 06/07/15

SQL Column: PAYMENT_NUMBER

Java Field: paymentNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Payment Year

Added On: 06/07/15

SQL Column: PAYMENT_YEAR

Java Field: paymentYear

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Se Rej Ind

Added On: 06/07/15

SQL Column: SE_REJ_IND

Java Field: seRejInd

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Se Unit Number

Added On: 06/07/15

SQL Column: SE_UNIT_NUMBER

Java Field: seUnitNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

SOC Detail Amex Gross Amount

Added On: 06/18/15

SQL Column: SOC_DETAIL_AMEX_GROSS_AMOUNT

Java Field: socDetailAmexGrossAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

SOC Detail Amex Payee Number

Added On: 06/18/15

SQL Column: SOC_DETAIL_AMEX_PAYEE_NUMBER

Java Field: socDetailAmexPayeeNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

SOC Detail Amex Process Date

Added On: 06/18/15

SQL Column: SOC_DETAIL_AMEX_PROCESS_DATE

Java Field: socDetailAmexProcessDate

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

SOC Detail Amex ROC Count

Added On: 06/18/15

SQL Column: SOC_DETAIL_AMEX_ROC_COUNT

Java Field: socDetailAmexRocCount

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

SOC Detail Amex ROC Count POA

Added On: 06/18/15

SQL Column: SOC_DETAIL_AMEX_ROC_COUNT_POA

Java Field: socDetailAmexRocCountPoa

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

SOC Detail Amex Se Number

Added On: 06/18/15

SQL Column: SOC_DETAIL_AMEX_SE_NUMBER

Java Field: socDetailAmexSeNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

SOC Detail Base Discount Amount

Added On: 06/18/15

SQL Column: SOC_DETAIL_BASE_DISCOUNT_AMOUNT

Java Field: socDetailBaseDiscountAmount

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

SOC Detail Card Not Present BPA Amount

Added On: 06/18/15

SQL Column: SOC_DETAIL_CARD_NOT_PRESENT_BPA_AMOUNT

Java Field: socDetailCardNotPresentBpaAmount

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

SOC Detail Card Not Present BPA Rate

Added On: 06/18/15

SQL Column: SOC_DETAIL_CARD_NOT_PRESENT_BPA_RATE

Java Field: socDetailCardNotPresentBpaRate

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

SOC Detail Card Not Present PTA Amount

Added On: 06/18/15

SQL Column: SOC_DETAIL_CARD_NOT_PRESENT_PTA_AMOUNT

Java Field: socDetailCardNotPresentPtaAmount

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

SOC Detail Card Not Present PTA Rate

Added On: 06/18/15

SQL Column: SOC_DETAIL_CARD_NOT_PRESENT_PTA_RATE

Java Field: socDetailCardNotPresentPtaRate

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

SOC Detail CPC Indicator

Added On: 06/18/15

SQL Column: SOC_DETAIL_CPC_INDICATOR

Java Field: socDetailCpcIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

SOC Detail Discount Amount

Added On: 06/18/15

SQL Column: SOC_DETAIL_DISCOUNT_AMOUNT

Java Field: socDetailDiscountAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

SOC Detail Discount Rate

Added On: 06/18/15

SQL Column: SOC_DETAIL_DISCOUNT_RATE

Java Field: socDetailDiscountRate

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

SOC Detail Net SOC Amount

Added On: 06/18/15

SQL Column: SOC_DETAIL_NET_SOC_AMOUNT

Java Field: socDetailNetSocAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

SOC Detail Payment Number

Added On: 06/18/15

SQL Column: SOC_DETAIL_PAYMENT_NUMBER

Java Field: socDetailPaymentNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

SOC Detail Payment Year

Added On: 06/18/15

SQL Column: SOC_DETAIL_PAYMENT_YEAR

Java Field: socDetailPaymentYear

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

SOC Detail Se Business Date

Added On: 06/18/15

SQL Column: SOC_DETAIL_SE_BUSINESS_DATE

Java Field: socDetailSeBusinessDate

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

SOC Detail Se Unit Number

Added On: 06/18/15

SQL Column: SOC_DETAIL_SE_UNIT_NUMBER

Java Field: socDetailSeUnitNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

SOC Detail Service Fee Amount

Added On: 06/18/15

SQL Column: SOC_DETAIL_SERVICE_FEE_AMOUNT

Java Field: socDetailServiceFeeAmount

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

SOC Detail Service Fee Rate

Added On: 06/18/15

SQL Column: SOC_DETAIL_SERVICE_FEE_RATE

Java Field: socDetailServiceFeeRate

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

SOC Detail SOC Amount

Added On: 06/18/15

SQL Column: SOC_DETAIL_SOC_AMOUNT

Java Field: socDetailSocAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

SOC Detail SOC Invoice Number

Added On: 06/18/15

SQL Column: SOC_DETAIL_SOC_INVOICE_NUMBER

Java Field: socDetailSocInvoiceNumber

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

SOC Detail Tracking ID

Added On: 06/18/15

SQL Column: SOC_DETAIL_TRACKING_ID

Java Field: socDetailTrackingId

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

SOC Detail Transaction Fee Amount

Added On: 06/18/15

SQL Column: SOC_DETAIL_TRANSACTION_FEE_AMOUNT

Java Field: socDetailTransactionFeeAmount

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

SOC Detail Transaction Fee Rate

Added On: 06/18/15

SQL Column: SOC_DETAIL_TRANSACTION_FEE_RATE

Java Field: socDetailTransactionFeeRate

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Take One Commision Amount

Added On: 06/20/15

SQL Column: TAKE_ONE_COMMISION_AMOUNT

Java Field: takeOneCommisionAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Take One Description

Added On: 06/20/15

SQL Column: TAKE_ONE_DESCRIPTION

Java Field: takeOneDescription

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Terminal ID

Added On: 06/07/15

SQL Column: TERMINAL_ID

Java Field: terminalId

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Assigned by the processor. Identifies subunits of a merchant such as department, location etc, or an ID of processing device, associated with a merchant or subunit of a merchant.

The identification number of the terminal.

Tlrr Amex Payee Number

Added On: 06/07/15

SQL Column: TLRR_AMEX_PAYEE_NUMBER

Java Field: tlrrAmexPayeeNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Tlrr AmEx Process Date

Added On: 06/11/15

SQL Column: TLRR_AMEX_PROCESS_DATE

Java Field: tlrrAmexProcessDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Tlrr Amex Se Number

Added On: 06/07/15

SQL Column: TLRR_AMEX_SE_NUMBER

Java Field: tlrrAmexSeNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Tlrr Cm Number

Added On: 06/07/15

SQL Column: TLRR_CM_NUMBER

Java Field: tlrrCmNumber

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Tlrr Cm Ref No

Added On: 06/07/15

SQL Column: TLRR_CM_REF_NO

Java Field: tlrrCmRefNo

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Tlrr Payment Number

Added On: 06/07/15

SQL Column: TLRR_PAYMENT_NUMBER

Java Field: tlrrPaymentNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Tlrr Payment Year

Added On: 06/07/15

SQL Column: TLRR_PAYMENT_YEAR

Java Field: tlrrPaymentYear

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Tlrr ROC Amount

Added On: 06/07/15

SQL Column: TLRR_ROC_AMOUNT

Java Field: tlrrRocAmount

Status: Active

SQL Type: varchar(13)

Java Type: String

Attributes:

Tlrr Se Business Date

Added On: 06/11/15

SQL Column: TLRR_SE_BUSINESS_DATE

Java Field: tlrrSeBusinessDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Tlrr Se Ref Poa

Added On: 06/07/15

SQL Column: TLRR_SE_REF_POA

Java Field: tlrrSeRefPoa

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Tlrr Se Unit Number

Added On: 06/07/15

SQL Column: TLRR_SE_UNIT_NUMBER

Java Field: tlrrSeUnitNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Tlrr SOC Amount

Added On: 06/07/15

SQL Column: TLRR_SOC_AMOUNT

Java Field: tlrrSocAmount

Status: Active

SQL Type: varchar(13)

Java Type: String

Attributes:

Tlrr SOC Invoice Number

Added On: 06/07/15

SQL Column: TLRR_SOC_INVOICE_NUMBER

Java Field: tlrrSocInvoiceNumber

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Tlrr Tran Date

Added On: 06/11/15

SQL Column: TLRR_TRAN_DATE

Java Field: tlrrTranDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Transaction Time

Added On: 06/07/15

SQL Column: TRANSACTION_TIME

Java Field: transactionTime

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes: