Item transaction/profit center

The record layout of the database table ArtTraTProC in which the data for the Item transaction/prof.center statistics is stored is described below.

Additional data fields are transferred from the database table TrTypeTMix.

The description contains the field name, the data type and the field size as well as a short review of the field content.


Time interval

Number 1 - 9

The following values can be entered depending on the statistic parameters set:

  1. = Year
  2. = Month
  3. = Week
  4. = Day

Date

Date

Recording date


Company

Number 1 - 9999

Number of company


Branch

Number 1 - 99999

Number of branch.


Profit center

Number 1 - 9999

Number of profit centre.


Category

Number 0 - 99

Number of category:

  1. on-the-house receipt
  2. merchandise returns

Operation mode

Number 1 - 9999

Number under which this type of transaction is stored in the system (see update program Operation mode).


Item

Decimal (14,0)

Number of item which is recorded with this type of transaction.


MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin