Konica Minolta Digital StoreFront User Manual

Page 471

Advertising
background image

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

Advertising