Konica Minolta Digital StoreFront - Manual (Page 489)

Logs and Reporting
489
Report Column Data Type Description
Account Code String Name of the accounting code that
the buyer sees during checkout.
[Please note that this is at the
company level and NOT at the
order level.]
Company Contains information about companies in the system (may or may not be using
accounting codes)
Company # Numeric Internal ID of the company
Company String Name of the company
Cost Center String Name of the company’s cost
center that is displayed to the
buyers on the storefront
Account Code String The name the buyer sees for the
collection of accounting codes for
the company.
Account Code Enabled Boolean Value indicating whether
accounting codes are enabled for
the company
Account Code
Usage Contains information about buyer-supplied account code during order check-out
Account Code By Buyer String Account code entered by the
buyer when placing an order with
payment method as ‘Accounting
Codes’
Order
Payment
Transaction Contains information about order payments
Payment Method # Numeric Internal ID of payment method
used for the order
Amount Decimal Order amount
Payment Date Date Date on which the order payment
was made
Project Code TransactionID Numeric Internal ID of transaction
pertaining to the order
SPENDING
ACCOUNT Use this root table for getting information about spending accounts in the system
Spending
Account Contains basic information about spending account