DATA OF RETURNS | |||||
| |||||
|
|
|
|
|
|
|
|
|
|
|
|
SA: 30100 |
| from | array | remarks | |
Version 01 |
| position | length |
| |
General IDENT- Term | N | 1 | 28 |
| |
Identification part | |||||
| publisher number | N | 29 | 5 |
|
| wholesale number | N | 34 | 4 |
|
| branch number | N | 38 | 2 |
|
|
|
|
|
|
|
key portion |
|
|
|
| |
| object | N | 40 | 5 | VDZ – number |
| tranche | N | 45 | 2 |
|
| year | N | 47 | 2 |
|
| issue / week | N | 49 | 3 |
|
| weekday | N | 52 | 1 | 1=Mo; 2=Tu; ... ; 6=Sa; 7=Su |
|
|
|
|
|
|
data portion |
|
|
|
| |
| record type | N | 53 | 2 | see below |
| date of returns | N | 55 | 6 | YYMMDD |
| number of returns certificate | N | 61 | 6 | number of returns certificate or number of certificate |
| delivery differences | N | 67 | 6 |
|
| internal transfers | N | 73 | 6 | replacement supply |
| retail trade delivery | N | 79 | 6 |
|
| retail trade supply adjustments | N | 85 | 6 |
|
| retail trade subsequent delivery | N | 91 | 6 |
|
| retail trade supply returns – actual | N | 97 | 6 | equal or greater than zero |
| publisher returns total | N | 103 | 6 | retail returns + calculative stock returns |
|
|
|
|
|
|
|
|
|
|
|
|
N= numeric |
|
|
| record length: 108 | |
A= alphanumeric |
|
|
|
|
II. 1. 1. a. IDENTIFICATION PART – WHOLESALE TRADE
publisher number
five-digit, numeric
It is the customer number of the publisher which the ISPC data are sent to.
wholesale trade number
four-digit, numeric
It is the customer number of the wholesale trade head office which sends ISPC data.
branch number
two-digit, numeric
It is the customer number of a wholesale trade branch which sends ISPC data.
II.1.1.b. KEY PORTION
object
five-digit, numeric
Marketing code corresponding to the VDZ definition.
tranche
two-digit, numeric
Regional edition of the object defined by the publisher. If no regional editions are available for the object, this array is not filled.
year
two-digit, numeric
It is the year of publication of the object initialized with default valueby the publisher.
issue / week
three digit, numeric
Issue / week is either the issue of the journal or at newspapers the calendar week of the appearance of the newspaper.
weekday
one-digit, numeric
It is the weekday assigned by the publisher to the publication date of this newspaper. The array “weekday” has only to be filled at daily papers according to the information of the publisher. This array remains empty at journals.
II.1.1.c. DATA PORTION
record type
two-digit, numeric
wholesale trade
10 applies to information from retail traders exc. delivering and special traders.
11 only applies to data of delivering and special traders.
station book-trade
70 only applies to data from head offices and branches.
date of returns
six-digit, numeric
in the case of discarded copy reurns
Date from the list of returns and remuneration adjustment. Preparation occurs in the form of: year – two-digit, month - two-digit, day - two-digit (YYMMDD).
number of the returns certificate
six-digit, numeric
in the case of discarded copy returns
number of the returns certificate enclosed
delivery differences
six-digit, numeric
Differences in the publisher deliveries in the case of the goods received, thus the deviations between amounts delivered and information on the delivery receipt respectively top label. In the case of a negative (positive) delivery difference is the real delivery quantity smaller (larger) than the amount according to the delivery receipt of the publisher. Values transmitted require the accordant sign to be indicated in the utmost right position. If no value is sent, this array remains empty.
internal transfer
six-digit, numeric
Internal replacement deliveries with head offices respectively branches have to be registered in this array. The specimens sent in the product flow file of the transferring branch have to be stated as a negative amount and in the case of the supplied branch as a positive amount. The values must balance themselves per object and issue with the complete customer. The values have to be sent in the utmost right position of the array with the accordant sign.
retail trade delivery
six-digit, numeric
The total delivery amount is shown in this array. It also contains the direct delivery of the publisher. The array is indicated without signs as an absolute value.
supply adjustments for retail trade
six-digit, numeric
All specimens or dispatches which a delivery note was made for but had to be fetched back early by the retail trader for some reasons again and / or which could not be delivered at all, i.e. amounts, which have to be restored on the initiative of wholesale trade / station book-trade. Specimens which were
returned by the retail early, not according to the date of returns, may not be booked under “supply adjustments” but have to be expanded into the immaterial returns-procedure as retail return and then to be transmitted as a publisher return. The array is always indicated without signs as an absolute value during conveyance.
retail trade follow-up delivery
six-digit, numeric
To safeguard the remainder of the stock all retail trade subsequent deliveries have to be carried out with calculation. After clarification of the circumstance, if applicable, a customer credit note can occur. Replacement deliveries for specimens which have been lost in the retail trade have to be regarded within the framework of this procedure as a normal follow-up delivery. The array is sent without signs as an absolute value.
retail trade store returns – actual
six-digit, numeric
In this array the physically existing amount in the warehouse which was available at the moment of the returns call is recorded. The actual stock returns must always be equal or greater than “0”. This array must never be sent with signs.
publisher returns total
six-digit, numeric
In this array, the sum of the retail trade returns and calculative stock returns which a credit from the publisher is expected for,is registered. The calculative stock return as a balance from all goods movements can be negative, if specimens are taken from the retail trade returns and are delivered again to the retail trade. If modifications ought to be reported at a later date, these modifications have to be transmitted with a corresponding sign as a correction of the primarily reported total returns.
In the case of discarded copy returns
The total return appears in this array which is reported to the publisher.
In the case of copy returns
The total return appears in this array which is reported respectively returned to the publisher.