Item transaction/branch

The following describes the record layout for the database table ArtTraTBrch in which the data for the Item transaction/branch is stored.

Additional data fields are transferred from database table TrTypeTMix.

The relevant field names, the data type and the field size as well as a short review of the field content 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.


Branch

Number 1 - 99999

Number of branch.


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)

Number of the item


MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin