Transaction Detail with Level III Fleet Data - MS Excel (Report # 091E)

Description

Use this report to review transaction details and the associated fleet addendum data (Level III). Columns for all Level III fleet data are visible, but data is only included for the addendum information provided by the processor. This report is best viewed in Excel.

Report Columns

• Hierarchy Level

• Hierarchy ID

• Hierarchy Description

• Account Number

• Account Type

• Cardholder First Name

• Cardholder Middle Name

• Cardholder Last Name

• Account Balance

• Account Opened Date

• Account Closed Date

• Diversion Account Number

• Transaction ID

• Transaction Date

• Transaction Posting Date

• Transaction Amount

• Transaction Sales Tax Amount

• Transaction Original Amount

• Transaction Currency Code

• Transaction Code

• Transaction Reason Code

• Transaction Code Description

• Merchant PaymentNet ID

• Merchant Tax Payer ID

• Merchant Name

• Merchant Street Address

• Merchant City

• Merchant State

• Merchant Postal Code

• Merchant Country

• MCC

• MCC Description

• MCC Type

• Transaction Addendum Indicator

• T & E Type

• Alternate Tax Indicator Text

• City Motor Tax Amount

• Company Vehicle Number

• County Motor Tax Amount

• Coupon Discount Amount

• Customer Criteria Text

• Detail Tax Rate Exponent Number

• Detail Type Code

• Discount Rate

• Driver Number

• Extended Item Amount

• Federal Excise Tax Amount

• Fuel Brand

• Gross Price Amount

• Alternate Tax Indicator

• Item Applicable Tax Text

• Item Detail Tax Type Indicator

• Item Discount Indicator

• Item Effective Date

• Item Extended Item Amount

• Item Net Gross Indicator

• Item Net Non-Fuel Amount

• Item Line Item Date

• Item Line Item Order Date

• Item Line Item Total Amount

• Item Local Tax Include Indicator

• Item Commodity Code

• Item Message Text

• ItemProduct 1 Code

• ItemProduct 2 Code

• ItemProduct 3 Code

• ItemProduct 4 Code

• ItemProduct 5 Code

• ItemProduct 6 Code

• ItemProduct 7 Code

• ItemProduct 8 Code

• Quantity

• Item Shipping Tax Rate

• Item Tax Amount

• Item Tax Rate

• Item Tax Type Code

• Miscellaneous Exemption Indicator

• Miscellaneous Non Fuel Tax Amount

• Net Fuel Price Amount

• Net Gross Indicator

• Net Non Fuel Price Amount

• Odometer Reading Number

• Product Code (description)

• Product Identifier

• Purchase Date

• Purchase Type Code

• Sale Amount

• Service Code

• State Motor Tax Amount

• Tax Debit Credit Indicator

• Tax Exempt Amount

• Unit Cost Amount

• Unit Price Amount

• Value Added Tax Amount

• Value Added Tax Rate

• Value Added Tax Type Code