FirstData Nashville Retail Item


Added On:  07/17/13 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  FirstDataNashvilleRetailItem 
Added On:  07/17/13
SQL Column:  COMMODITY_CODE
Java Field:  commodityCode
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
The commodity code used to classify the item purchased. Blank filled if not used. This is found on the 40/80 Byte Purchasing Card ―XD34‖
Added On:  07/17/13
SQL Column:  DEBIT_CREDIT_IND
Java Field:  debitCreditInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicator used to reflect debit or credit transaction.

Mandatory for MC data rate 3 and MC corp large ticket Amex purchase card level 2- space.
Added On:  07/17/13
SQL Column:  DESCRIPTION
Java Field:  description
Status:  Active
SQL Type:  varchar(26)
Java Type:  String
Attributes:
The text description of the individual item purchased (for MasterCard only, if description is more than 26 characters, description can be continued on Item Description Part B). Blank filled if not used.
Added On:  07/17/13
SQL Column:  DISCOUNT_AMOUNT
Java Field:  discountAmount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Discount applied to the item (Visa Level 3) Must not be all zeros if a Discount exists, and the last two digits are implied decimal places. Otherwise must be all zeros.
Added On:  07/17/13
SQL Column:  DISCOUNT_AMOUNT_IND
Java Field:  discountAmountInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicator used to reflect item discount amount.
Added On:  07/17/13
SQL Column:  DISCOUNT_RATE
Java Field:  discountRate
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Discount rate applied to item- Optional for MC, zero fill for other card types or if not supplied.
Added On:  07/17/13
SQL Column:  EXTENDED_AMOUNT
Java Field:  extendedAmount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
May include Item Tax Amount. Required for reduced interchange. (also required for WEX and Voyager) Mandatory for MasterCard Data Rate III and MC Corp large ticket rate. For MC if item is zero cost to customer, this field can be zero. The last two digits are implied decimal places.
Added On:  07/17/13
SQL Column:  EXTENDED_AMOUNT_IND
Java Field:  extendedAmountInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicator used to reflect item extended amount.
Added On:  07/17/13
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:  07/17/13
SQL Column:  LOCAL_TAX_AMOUNT
Java Field:  localTaxAmount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Sales tax applied to the item If additional information is available regarding item tax amount, this field may be supplied in the XD 35 record.
Added On:  07/17/13
SQL Column:  LOCAL_TAX_AMOUNT_IND
Java Field:  localTaxAmountInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicator used to reflect item local tax amount.
Added On:  07/17/13
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.
Added On:  07/17/13
SQL Column:  PRODUCT_CODE
Java Field:  productCode
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
The product code of the individual item purchased. Blank filled if not used. For Fleet cards, see Page 12-59. This is found on the 40/80 Byte Purchasing Card ―XD32‖ Record
Added On:  07/17/13
SQL Column:  QUANTITY
Java Field:  quantity
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
The quantity of the item purchased. This field is found on the Purchasing Card XD32 Record (40/80-Byte Formats).
Added On:  07/17/13
SQL Column:  TAX_COLLECTED_IND
Java Field:  taxCollectedInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicator used to reflect tax capture and reporting.

Required for reduced interchange. Amex purchase card level 2- space.
Added On:  07/17/13
SQL Column:  UNIT_COST
Java Field:  unitCost
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
The unit cost of the item purchased. Four (4) decimal places are implied and can be all zeros. This is found on the 40/80 Byte Purchasing Card ―XD33‖ Record
Added On:  07/17/13
SQL Column:  UNIT_COST_IND
Java Field:  unitCostInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicator used to reflect unit cost of item purchased.
Added On:  07/17/13
SQL Column:  UNIT_OF_MEASURE
Java Field:  unitOfMeasure
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
The three (3) position measurement code or unit of measure used for this item. Blank filled if not used or not a bulk item. This is found on the 40/80 Byte Purchasing Card ―XD34‖