Item transaction/company

The following describes the record layout for the database table ArtTraTComp in which the data for the Item transaction/company statistics is stored.

Additional data fields are transferred from the database table TrTypeTMix.

The relevant field names, the data type and the field size as well as a short review of the field contents are described below.


Time interval

Number 1 - 9

The following values are 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.


Category

Number 0 - 99

Category of type of transaction:

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

Operation mode

Number 1 - 9999

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


Item

Decimal (14,0)

Item no.


MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin