TSYS Retail Item

Added On: 03/27/12

SQL Table: TSYS_RETAIL_ITEM

Module: UniCharge

Type: Entity Status: Active

Java Class: TsysRetailItem

Represents a level III transaction item that is used in level III transactions processed through TSYS.

Available Fields:

Alternative Tax Identifier
Credit Indicator
Discount Amount
Discount Rate
Id

Item Commodity Code
Item Description
Line Item Card Type
Line Item Total
Merchant Account Code

Product Code
Quantity
Tax Amount
Tax Rate
Tax Type Applied

Unit Cost
Unit Measure

Alternative Tax Identifier

Added On: 03/27/12

SQL Column: ALTERNATIVE_TAX_IDENTIFIER

Java Field: alternativeTaxIdentifier

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

This field contains the tax identification number of the merchant that reported the alternate tax amount.

Credit Indicator

Added On: 03/27/12

SQL Column: CREDIT_INDICATOR

Java Field: creditIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

This field represents the sign of the "extended item amount".
C - Extended item Amount is Credit
D - Extended item Amount is Debit

Discount Amount

Added On: 03/27/12

SQL Column: DISCOUNT_AMOUNT

Java Field: discountAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

This field contains the total discount amount applied against the lint item total. This field should be zeroes if the unit cost reflects a discount price or if no line item discount applies.

Discount Rate

Added On: 03/27/12

SQL Column: DISCOUNT_RATE

Java Field: discountRate

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

This field contains the discount rate for the line item.

Added On: 03/27/12

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.

Item Commodity Code

Added On: 03/27/12

SQL Column: ITEM_COMMODITY_CODE

Java Field: itemCommodityCode

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Will contain an international description code of the individual good or service being supplied. The acquirer bank or processor should provide the merchant an updated listing of currently defined codes. It is recommended to use a National or International list of standardized codes.

Item Description

Added On: 03/27/12

SQL Column: ITEM_DESCRIPTION

Java Field: itemDescription

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

Contains a description of the retail item that was purchased

Line Item Card Type

Added On: 03/27/12

SQL Column: LINE_ITEM_CARD_TYPE

Java Field: lineItemCardType

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Indicates which card type with which the line item details are
associated. Valid values for this field are "VISA" for Visa, and "MCRD" for MasterCard.

Line Item Total

Added On: 03/27/12

SQL Column: LINE_ITEM_TOTAL

Java Field: lineItemTotal

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

This field contains the purchase amount associated with the specific line item detail record.

Merchant Account Code

Added On: 03/27/12

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.

Product Code

Added On: 03/27/12

SQL Column: PRODUCT_CODE

Java Field: productCode

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

This 12-character field can contain a merchant-defined description code of the item being purchased.

Quantity

Added On: 03/27/12

SQL Column: QUANTITY

Java Field: quantity

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

This 12-character numeric field contains the quantity of the item(s) being purchased.

Tax Amount

Added On: 03/27/12

SQL Column: TAX_AMOUNT

Java Field: taxAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

This field contains the amount of any value added taxes which can be associated with the purchased item.

Tax Rate

Added On: 03/27/12

SQL Column: TAX_RATE

Java Field: taxRate

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

This field contains the tax rate used to calculate the sales tax amount. For fueling transactions, this field is expressed in percentage terms for the fuel purchased. This field has a two-character numeric implied decimal position.

Tax Type Applied

Added On: 03/27/12

SQL Column: TAX_TYPE_APPLIED

Java Field: taxTypeApplied

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

This field designates the type of value-added taxes that are being used.

Unit Cost

Added On: 03/27/12

SQL Column: UNIT_COST

Java Field: unitCost

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

This field contains the unit cost of the item purchased. This field
reflects an implied decimal point of a four-character numeric.

Unit Measure

Added On: 03/27/12

SQL Column: UNIT_MEASURE

Java Field: unitMeasure

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

This field contains the alphanumeric code for units of measurement as used in international trade.