The following describes the record layout for the
database table ArtTraTProC
in which the data for the statistics Item
transaction/prof.cent. is stored.
Item transactions are merchandise returns and
on-the-house receipt recordings.
The field names, the data type and the field size are
described below together with a short description of the appropriate field
content.
Decimal (12,2)
Decimal (12,2)
Total of the calculated cost of goods.
This value is always shown if this is a stock item and
if a calculated cost price exists for this stock item.
Decimal (11,3)
Number of all items sold in this type of transaction
Number
Number of all recordings made for this type of
transaction
Number 1 - 9
The following values can be entered depending on the statistic
parameters
set:
Date
Recording date
Number 1 - 9999
Number of company.
Number 1 - 99999
Number of branch.
Number 1 - 9999
Number of profit center.
Number 0 - 99
Category of type of transaction:
Number 1 - 9999
Number under which this type of transaction is stored
in the system (see update program Operation mode).
Decimal (14,0)
Item no.