Customer-specific prices, Level 1

Information and description

In the customer-specific price file, you can send both discount records and net prices at the article level. (In Level 2, it is also possible to send net prices at the packaging level.)

Customer-specific price information can be delivered in two ways:

As a text file with fixed field lengths, according to the file specification
As a text file (CSV), created from a dedicated Excel template

CSV text file

To send net prices via Finfo, you can use a special Excel template where you fill in a few specific fields. The file is then sent to Finfo as a text file (CSV) for import and distribution.

Text file (file specification)

The agreement is delivered as a text file, i.e., a DOS/ASCII file.

Instruction

The record type code in position 1 determines how a record should be interpreted.

A = Agreement record
P = Price record
R = Discount record
T = Text record for messages

The first record must always be an Agreement record. The other record types are optional. You do not need to send Price records if you are sending Discount records, and vice versa.

All numeric fields (Type = N) in a record must always be completely filled with the specified number of characters. If the field is to be left empty, it must still be filled with the correct number of zeros (0). If the number of characters is fewer than the maximum allowed for the field, the value must be left-padded with zeros (0). No decimal symbols are used — decimals are determined by the field’s defined position.

All information in alphanumeric fields (Type = A) must be left-aligned.

Several agreements can be delivered in the same file, provided that the same contract ID is not used for different customers in the same file, and no empty lines occur.

File description

Layout post type A (Agreement record)

Pos	Len	Dec	Type	Description	Mandatory	Remarks / Explanation / Example
1	1		A	"A"	YES	Agreement record, always written as A.
2	20		A	Avtals-id	YES	The supplier’s ID for the agreement. Left-aligned.
22	12	0	N	Leverantör	YES	The supplier’s ID with Finfo. Example: ID number 1646213 is written as 000001646213.
34	15		A	Kund-id	YES	The supplier’s customer number for the party covered by the agreement. Left-aligned.
49	8	0	N	Första aktiverings-datum	YES	The date when the agreement should first be activated in Finfo. Should be entered at least 2 weeks before the agreement takes effect, to allow time for the subscriber’s calculations, etc. Written as YYYYMMDD. Future agreement updates (effective date or distribution date) are handled in R or P records.
57	8	0	N	Gäller t.o.m.	YES	The date when the agreement expires. Written as YYYYMMDD. 99999999 = until further notice.
65	1		A	Ansvarskod	YES	L/A/K (Supplier/Subscriber/Chain). Indicates who submitted the agreement and who should be notified if errors are found in the file.
66	12	0	N	Ansvarig abo	YES	The chain’s order number with Finfo. Only entered if the responsibility code is "K". Otherwise, enter 000000000000.
78	1		A	Avtalstyp	YES	N = Net price agreement C = Recommended price agreement
79	1		A	Renskod	NO	Blank = no clearing. P = all currently valid P records not included in the current file will expire. R = all currently valid R records not included in the current file will expire. A = all currently valid P and R records not included in the current file will expire.
80	1	0	A	Kod för gällandedatum	NO	J = code used to indicate from which date the prices or discount groups apply.

Layout post type P (Price record)

Pos	Len	Dec	Type	Description	Mandatory	Remarks / Explanation / Example
1	1	-	A	"P"	YES	Price record, always written as P.
2	20	-	A	Avtals-id	YES	The supplier’s ID for the agreement. Same as in the Agreement record.
22	18	-	A	Artikelnr	YES	The supplier’s article number.
40	15	8	N	Pris	YES	Net price or list price per base price unit as stated in the general article file. Agreement type N = net price, C = list price, as specified in the A record.
55	8	0	N	Distributions-datum	YES	The date when the agreement should be sent to the customer. The date should be at least 2 weeks earlier than the effective date to ensure timely delivery to the subscriber. If the same date as stated in the Agreement record applies, or if the changes should take effect immediately, write 00000000.
63	8	0	N	Gällandedatum	NO	The date when the price becomes effective. Written as YYYYMMDD. Mandatory if the code for effective date in the A record = J.

Layout post type R (Discount record)

Pos	Len	Dec	Type	Description	Mandatory	Remarks / Explanation / Example
1	1	-	A	"R"	YES	Discount record, always written as R.
2	20	-	A	Avtals-id	YES	The supplier’s ID for the agreement. Same as in the Agreement record.
22	5	-	A	Rabattgrupp	YES	The discount group to which the discount rate applies. The discount group must exist on the articles in the general article file in order for the subscriber’s net prices to be calculated.
27	4	2	N	Rabattsats	YES	Used to calculate the net price, based on the base price. Example: a discount of 2% is written as 0200.
31	8	0	N	Distributionsdatum	YES	The date when the agreement should be sent to the customer. The date should be at least 2 weeks earlier than the effective date to ensure timely delivery to the subscriber. If the same date as stated in the Agreement record applies, or if the changes should take effect immediately, write 00000000.

Layout post type T (Text record for messages)

Pos	Len	Dec	Type	Description	Mandatory	Remarks / Explanation / Example
1	1	-	A	"T"	YES	Text record, used for messages to the subscriber, for example, to indicate when the distributed agreement becomes valid.
2	20	-	A	Avtals-id	YES	The supplier’s ID for the agreement. Same as in the Agreement record.
22	8	0	N	Distributionsdatum	YES	If the same date as stated in the Agreement record applies, write 00000000; otherwise, enter the desired activation date for the text record. This date should correspond with the other dates to ensure that the text record is distributed at the same time as the other records.
30	2	0	N	Radnr	YES	Sequence number within the same date: 01, 02, etc.
32	45	-	A	Text	YES	Free text that the supplier controls and is responsible for. It is sent as a separate paragraph in the price notification from Finfo.