Konica Minolta Digital StoreFront - Manual (Page 471)

Logs and Reporting
471
Reference Guide for Creating Queries with the Dynamic Query Tool (DQT)
The chart below will serve as a reference for site administrators who are extracting data from Digital
StoreFront using the Dynamic Query Tool (DQT).
Report Column Data Type Description
ORDERS Use this root table to get information about orders placed in the system
Orders Contains order information
Order # Numeric Order number
User # Numeric Internal Buyer ID (e.g., 10012)
Order Status # Numeric Internal ID for current order
status. Could be one of the
following:
1 - Input
2 - Approved
3 - Rejected
4 - Processing
5 - Shipped
6 - Cancelled
7 – Manual Quote Required
8 – User Approval Required
9 - Deleted
10 - Printed
11 – Approval Required
Total Cost Decimal Total order cost
Order Date Date The date on which the order was
placed
Comments String Any comments entered by the
customer while placing the order
Billing Address Id Numeric Depends on the order payment
method:
Cash payment: null
CreditCard: null
AccountingCodes: null
OnAccount: CostCenter contact
person’s address ID OR buyer’s
contact person’s address ID
DeferredPayment: Buyer’s
address ID
Order Placed At Numeric Internal ID of the print shop at
which the order was placed