Files¶
Items¶
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales channel (PKey) | 3 | 001 | Sales channel |
| ArtNr (PKey) | Item No (PKey) | 15 | 123456 | Item number |
| Attr1 (PKey) | Attribute 1 (PKey) | 5 | 1234 | Attribute id 1 |
| Attr2 (PKey) | Attribute 2 (PKey) | 5 | 001 | Attribute id 2 |
| Attr3 (PKey) | Attribute 3 (PKey) | 5 | 12 | Attribute id 3 |
| Attr4 (PKey) | Attribute 4 (PKey) | 5 | 12 | Attribute id 4 |
| Attr5 (PKey) | Attribute 5 (PKey) | 5 | 12 | Attribute id 5 |
| LagArtnr | Stock item No | 15 | 123456 | Stock item number(Additional field) |
| LagAttr1 | Stock item attribute 1 | 5 | 1234 | Stock attribute id 1(Additional field) |
| LagAttr2 | Stock item attribute 2 | 5 | 001 | Stock attribute id 2(Additional field) |
| LagAttr3 | Stock item attribute 3 | 5 | 12 | Stock attribute id 3(Additional field) |
| LagAttr4 | Stock item attribute 4 | 5 | 12 | Stock attribute id 4(Additional field) |
| LagAttr5 | Stock item attribute 5 | 5 | 12 | Stock attribute id 5(Additional field) |
| Attr1Ben | Attribute 1 name | 75 | Blue | Attribute 1 Name |
| Attr2Ben | Attribute 2 name | 75 | XXL | Attribute 2 Name |
| Attr3Ben | Attribute 3 name | 75 | Attribute 3 Name | |
| Attr4Ben | Attribute 4 name | 75 | Attribute 4 Name | |
| Attr5Ben | Attribute 5 name | 75 | Attribute 5 Name | |
| ArtTyp | Item type | 2 | 01 | Item type Link to Artikeltyp |
| ArtTypBen | Item type name | 40 | Gift card | Name of the item type |
| Längd | Length | 10 | 30 | Indicated in millimeters |
| Bredd | Width | 10 | 30 | Indicated in millimeters |
| Höjd | Height | 10 | 30 | Indicated in millimeters |
| Vikt | Weight | 10 | 100 | Indicated in grams |
| InternetDatum*** | Internet date | 10 | 2017-03-20 | Is shown/sold on internet* |
| ReleaseDatum*** | Release date | 10 | 2017-03-20 | Start date when the item can be sold* |
| Enh | Unit | 2 | 01 | Unit. These values are configured by each client respectively on the item parameter form in Harmoney |
| MomsNivå | VAT level | 2 | 01 | Regular VAT or VAT for books |
| Varugrupp | Item group | 3 | Valid values and descriptions are configured in Harmoney | |
| Varuklass | Item class | 2 | Valid values are configured in Harmoney | |
| Varukod | Item code | 4 | Valid values are configured in Harmoney | |
| Varumärke | Brand | 2 | Valid values are configured in Harmoney | |
| Referensartikel | Referenced item | 15 | If the customer place an order with a reference item number it will get changed to the correct item number | |
| Referensattr1 | Referenced attribute | 5 | ||
| Referensattr2 | Referenced attribute | 5 | ||
| Leverantör | Supplier | 6 | 123456 | Main suppliers id |
| BestArtStatus** | Ordered item status | 2 | 01 | 01 = Active 04 = Cancel order, despite stock status 05 = Hold deliveries temporarily 70 = Cancel order if stock level is low |
| LagArtStatus | Stock item status | 2 | 01 | 01 = Active 70 = Passive 90 = Discontinued |
| InetHuvArt | 15 | 123459 | Used to tie together items having different item number(Additional field) | |
| InetVarTyp | 15 | Color | Used together with InetHuvArt, is used to specify the type of variant.(Additional field) | |
| InetVarText | 15 | Red | Used together with InteVarTyp, specifies the text of the variant(Additional field) | |
| MinAnt | Minimum units | 10 | 1 | Minimum units the customer has to by of the specific item.(Additional field) |
| MaxAnt | Maximum units | 10 | 1 | Maximum units the customer is allowed to by of the specific item.(Additional field) |
| MonstPass | Length of pattern | 10 | 5 | Length of pattern for metric items. (Additional field) |
| LevFarg | Suppliers color | 20 | Black | The color given by the supplier(Additional field) |
| KlKod | Classification code | 5 | 12345 | Classification code(Additional field) |
| InetVisa*** | 1 | X | Decides if the item should be shown in the web shop. Corresponds to the field “Visa” on the Item form in Harmoney(Additional field) | |
| ForsorjTyp | Supply type | 2 | 01 | The items supply type(Additional field) |
| AfrOmrde | Business area of the item | 2 | 02 | Which business area the stock item belongs to. Who is responsible for the stock item. (Additional field) |
| LevArtNr | 25 | 123456 | The suppliers item number(Additional field) | |
| UrsprLand | 2 | SE | Country of origin(Additional field) | |
| InetFors | Inernet sale | 2 | 01 | Is shown/sold on internet text(Additional field) |
| SepPack | Separate code | 2 | 01 | Code that separate items on invoice(Additional field) |
| DistrLevEmb | Original packaging | 1 | X | Checked signifies that the item will be delivered in its own original packaging(Additional field) |
*Date = If 0001-01-01 is sent. No date has been set.
*Fields marked with (Additional field) is not sent as default, only on request.
**Suggestion of interpretation of status values¶
| BestArtStatus | LagAnt-ResLagAnt | InkAnt-ResInkAnt | Orderable |
|---|---|---|---|
| Active | > 0 | 0 | Yes |
| Active | 0 | > 0 | Yes |
| Active | > 0 | > 0 | Yes |
| Passive(non active) | > 0 | 0 | No |
| Passive(non active) | 0 | > 0 | No |
| Passive(non active) | > 0 | > 0 | No |
| Cancel order on low stock | > 0 | 0 | Yes |
| Cancel order on low stock | 0 | > 0 | Yes |
| Cancel order on low stock | > 0 | > 0 | Yes |
| Additional status code | 0 | 0 | No |
***Suggestion of interpretation if an item should be shown in the web shop¶
The fields InetVisa, InternetDatum, ReleaseDatum, BestArtStatus and values for stockitem are suitable to decide if the item should be shown on the web shop or not. It’s up to the web shop developer and the client which algorithm to use. If help is needed don’t hesitate to contact Pulsen.
Suggestion: The web shop shows items if they have InetVisa = X where today’s date is later than InternetDatum and later or equal to the ReleaseDatum. The item should also be orderable according to the table above.
Item types¶
| Code | Name |
|---|---|
| 01 | Ordinary item |
| 02 | Package item, price allocated by contributing parts |
| 03 | Package item, price is summarized by parts |
| 04 | Bonus item |
| 05 | Priced item |
| 06 | Gift card item |
| 07 | Verification |
| 08 | Embroidery |
| 09 | Package insert item |
| 10 | Discount item |
| 71 | Fee COD-letter |
| 72 | Fee COD parcel |
| 73 | Administrative fee |
| 74 | Fee for carriage |
| 75 | Additional fee for the order |
| 76 | Fee for reply postage |
| 77 | Fee for express order |
| 78 | Fee for split order |
| 79 | Weight related administrative fee |
| 80 | Postage fee |
| 81 | Home delivery fee |
Example of the Item file¶
The name of the sent file is Prod_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCT, PXXDLSINRIVARTNY
Below is a typical content of the item file
001|00102|0010|00006||||Natur|S||||01|Normal artikel|400|300|30|840|0001-01-01|2009-10-12|01|01|000|01|1102|||||000SNG|05|01
001|00102|0010|00008||||Natur|M||||01|Normal artikel|400|300|30|840|0001-01-01|2009-10-12|01|01|000|01|1102|||||000SNG|05|01
001|00102|0010|00010||||Natur|L||||01|Normal artikel|400|300|30|840|0001-01-01|2009-10-12|01|01|000|01|1102|||||000SNG|05|01
001|00102|0010|00012||||Natur|XL||||01|Normal artikel|400|300|30|840|0001-01-01|2009-10-12|01|01|000|01|1102|||||000SNG|05|01
001|00102|0034|00006||||Terracotta|S||||01|Normal artikel|400|300|30|840|0001-01-01|2009-10-12|01|01|000|01|1102|||||000SNG|05|01
001|00102|0034|00008||||Terracotta|M||||01|Normal artikel|400|300|30|840|0001-01-01|2009-10-12|01|01|000|01|1102|||||000SNG|05|01
001|00102|0034|00010||||Terracotta|L||||01|Normal artikel|400|300|30|840|0001-01-01|2009-10-12|01|01|000|01|1102|||||000SNG|05|01
001|00102|0034|00012||||Terracotta|XL||||01|Normal artikel|400|300|30|840|0001-01-01|2009-10-12|01|01|000|01|1102|||||000SNG|05|01
Trigger for the Item file¶
The Item file is sent both as an incremental file, where only rows with updated/changed items since the last time the file was sent, and as a full file where all rows are inserted into the file. The latter will generate a lot of data, hence it is created on fewer occasions.
Factors that determines if a row will be added in the file.
| Trigger | Description |
| xLagArtLev.HuvLev | The item should have the flag HuvLev set to true, i.e. supplied by a main supplier |
| xPrmFok.ForsVar | The item should belong to sales variant 02(Warehouse/store) |
| xArtVar or xLagArtVar or xArt .SysAndrTidStamp | The item’s updated timestamp has to be later than the latest scheduled. i.e. the item has to be changed. When a full item file export is done the latter value is set hence all rows will be included in the file |
Deleted items¶
This file will contain the item variants that has been removed since the previous file was sent.
| Name | Max length | Example | Description |
|---|---|---|---|
| Fok (PKey) | 3 | 001 | Sales channel |
| Artnr (PKey) | 15 | 123456 | Item number |
| Attr1 (PKey) | 5 | 1234 | Attribute id 1 |
| Attr2 (PKey) | 5 | 001 | Attribute id 2 |
| Attr3 (PKey) | 5 | 12 | Attribute id 3 |
| Attr4 (PKey) | 5 | 12 | Attribute id 4 |
| Attr5 (PKey) | 5 | 12 | Attribute id 5 |
Example of the Deleted items file¶
The name of the sent file is DelProd_yymmdd_hhmmss.txt
Pulsen filename and SP¶
DELPROD, PXXDLSINRIVBORT
Below is a typical content of the deleted items file
001|000001|59|00036|||
006|000001|59|00036|||
001|000001|59|00038|||
006|000001|59|00038|||
001|000001|59|00040|||
006|000001|59|00040|||
001|000001|50|00036|||
006|000001|50|00036|||
001|000001|50|00038|||
006|000001|50|00038|||
001|000001|50|00040|||
006|000001|50|00040|||
007|000001|01|00004|||
Prices¶
An item can have many different sales prices. They are represented in the price file with different price groups(two letter suffix) The price group 00 always corresponds to the items “base price”. Every item must have a “base price”. When placing an order the price group can be added as a suffix to the item number to make sure that the current order row will get the desired price e.g. 01123456. The currency of the prices in the price file are as decided in the current sales channel. This is set while configuring Harmoney. The selling price of all item variants or those item variants that has been changed(not deleted) are sent in the price file.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales channel (PKey) | 3 | 001 | Sales channel |
| ArtNr (PKey) | Item No (PKey) | 15 | 123456 | Item number |
| Attr1 (PKey) | Attribute 1 (PKey) | 5 | 1234 | Attribute id 1 |
| Attr2 (PKey) | Attribute 2 (PKey) | 5 | 001 | Attribute id 2 |
| Attr3 (PKey) | Attribute 3 (PKey) | 5 | 12 | Attribute id 3 |
| Attr4 (PKey) | Attribute 4 (PKey) | 5 | 12 | Attribute id 4 |
| Attr5 (PKey) | Attribute 5 (PKey) | 5 | 12 | Attribute id 5 |
| Pris | Price | 10 | 150,00 | 2 decimal |
| PrisText | Price text | 40 | Club price | Text that corresponds with the price |
| PrisGrp (PKey) | Price group | 2 | 01 | Suffix(two letter) |
| HuvAkt | Main activity | 7 | 10802 | Main activity/campaign |
| Startdatum | Start date | 10 | 2017-03-25 | The first start date of all activities(campaigns) in the main activity(campaign)* |
| Stoppdatum | End date | 10 | 2017-04-20 | The last/final date of all activities(campaigns) in the main activity(campaign)* |
| Antal (PKey) | Units | 10 | 1,00 | The units of the article customer has to buy to get the current price. |
| PrisTextId | Price text id | 2 | 01 | The id of the price text |
| PrKod (PKey) | Index number | 5 | 1 | The index number within a price group Default value = 1. (Additional value) NOTE! Only for index. Never to be send in |
| PrisStopp | Stopped price | 1 | X | Tells if the price is stopped** (Additional value) |
| NetPrKod | Net price | 1 | X | Net price. No discount is given on this price** (Additional value) |
| FullPr | Full price | 1 | X | If the price refers to a full price purchase** (Additional value) |
| AktSida | Page | 3 | 17 | Catalogue page** (Additional value) |
| SidaProc | Page% | 6 | 25.00 | Catalogue page %** (Additional value) |
| Kostn1 | Cost 1 | 10 | 114,72 | Cost 1, no function only info** (Additional value) |
| Kostn2 | Cost 2 | 10 | 13,49 | Cost 2, no function only info** (Additional value) |
* Date = If 0001-01-01 is sent, no date is set
** Stopped price = Is only sent if the parameter for this function is set in Harmoney.
Example of the Price file¶
The name of the sent file is ProdPrice_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCT_PRICE, PXXDLSINRIVARTPRNY
Below is a typical content of the price file.
001|00102|0010|00006||||895,00|Pris|00|GRUND|2006-11-13|2099-12-31|1,00|00
001|00102|0010|00006||||895,00|Pris|01|10A01|2009-01-20|2010-10-31|1,00|00
001|00102|0010|00006||||895,00|Pris|03|10A03|2010-01-13|2010-11-15|1,00|00
001|00102|0010|00008||||895,00|Pris|00|GRUND|2006-11-13|2099-12-31|1,00|00
001|00102|0010|00008||||895,00|Pris|01|10A01|2009-01-20|2010-10-31|1,00|00
001|00102|0010|00008||||895,00|Pris|03|10A03|2010-01-13|2010-11-15|1,00|00
001|00102|0010|00010||||895,00|Pris|00|GRUND|2006-11-13|2099-12-31|1,00|00
Example of the file with the function PrisStopp activated:
001|00102|0034|00006||||895,00|Pris|00|GRUND|2006-11-13|2099-12-31|1,00|00|X
001|00102|0034|00006||||895,00|Pris|01|10A01|2009-01-20|2010-10-31|1,00|00|X
001|00102|0034|00006||||895,00|Pris|03|10A03|2010-01-13|2010-11-15|1,00|00|
001|00102|0034|00008||||895,00|Pris|00|GRUND|2006-11-13|2099-12-31|1,00|00|
001|00102|0034|00008||||895,00|Pris|01|10A01|2009-01-20|2010-10-31|1,00|00|
001|00102|0034|00008||||895,00|Pris|03|10A03|2010-01-13|2010-11-15|1,00|00|
001|00102|0034|00010||||895,00|Pris|00|GRUND|2006-11-13|2099-12-31|1,00|00|X
Trigger for the Price file¶
The Item price file is sent both as an incremental file, where only rows with updated/changed items since the last time the file was sent, and as a full file where all rows are inserted into the file. The latter will generate a lot of data, hence it is created on fewer occasions.
Factors that determines if a row will be added in the file.
| Trigger | Description |
| xArtPr.SysAndrTidStamp | The item price’s changing timestamp must be later than the latest scheduled file transfer. When a full Price file export is done the latter value is set, hence all rows will be included in the file |
| xArtPrGrp.SysAndrTidStamp | The item variants changing timestamp must be later than the latest scheduled file transfer. When a full Price file export is done the latter value is set, hence all rows will be included in the file |
Deleted prices¶
In this file only prices that has been deleted from an Item since the last files was sent will be set. This file has to be read before the file with updated/changed prices.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales channel (PKey) | 3 | 001 | Sales channel |
| ArtNr (PKey) | Item No (PKey) | 15 | 123456 | Item number |
| PrisGrp (PKey) | Price group (PKey) | 2 | 01 | Suffix(two letter) |
| PrKod | Index number | 5 | 00001 | The index number within a price group |
Example of a Deleted prices file¶
The name of the sent file is DelProdPrice_yymmdd_hhmmss.txt
Pulsen filename and SP¶
DELPRODPRICE, PXXDLSINRIVBORT
001|0000001|00|00001
001|0000002|00|00001
001|0000003|00|00001
002|0000001|00|00001
002|0000002|00|00001
003|0000001|00|00001
003|0000002|00|00001
101|0000001|00|00001
101|0000002|00|00001
101|0000003|00|00001
Deleted prices on item variant¶
In this file only prices on an item variant that has been removed since the previous file was sent. This file has to be read before the file with updated/changed prices.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales channel (PKey) | 3 | 001 | Sales channel |
| ArtNr (PKey) | Item No (PKey) | 15 | 123456 | Item number |
| Attr1 (PKey) | Attribute 1 (PKey) | 5 | 1234 | Attribute id 1 |
| Attr2 (PKey) | Attribute 2 (PKey) | 5 | 001 | Attribute id 2 |
| Attr3 (PKey) | Attribute 3 (PKey) | 5 | 12 | Attribute id 3 |
| Attr4 (PKey) | Attribute 4 (PKey) | 5 | 12 | Attribute id 4 |
| Attr5 (PKey) | Attribute 5 (PKey) | 5 | 12 | Attribute id 5 |
| PrisGrp (PKey) | Price group (PKey) | 2 | 01 | Price group |
| PrKod | Serieal number | 5 | 00001 | The index number within a price group |
Example of a file with deleted prices variant¶
The name of the sent file is DelProdPriceGroup_yymmdd_hhmmss.txt
Pulsen filename and SP¶
DELPRODPRICEGROUP, PXXDLSINRIVBORT
001|111222|59|00038||||01|00001
004|111222|59|00038||||01|00001
006|111222|59|00038||||01|00001
200|111222|59|00038||||01|00001
300|111222|59|00038||||01|00001
001|000001|59|00036||||00|00001
006|000001|59|00036||||00|00001
001|000001|59|00038||||00|00001
Item name¶
In this file all or only the item names change(d)(not removed) since the previous file was sent. An item in Harmoney includes various names and are listed in this file with different name types.
| Code | Type |
|---|---|
| 01 | Short name |
| 02 | Long name |
| Name | Max length | Example | Description |
|---|---|---|---|
| Fok (PKey) | 3 | 001 | Sales channel |
| Artnr (PKey) | 15 | 123456 | Item number |
| Sprak (PKey) | 2 | EN | Language |
| BenTyp (PKey) | 2 | 01 | Name type |
| Text | 75 | Shirt |
Example of an Item name file¶
The name of the sent file is ProdName_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTNAME, PXXDLSINRIVARTBEN
001|0000|DA|01|Christmas catalogue 2009
001|0000|DA|02|Christmas catalogue 2009
001|00001|SV|01|Erbjudande rabatt 50:-
001|00001|SV|02|Erbjudande rabatt 50:-
Deleted Item names¶
In this file only item names that has been deleted since the previous file are sent.
| Name | Max length | Example | Description |
|---|---|---|---|
| Fok (PKey) | 3 | 001 | Sales channel |
| Artnr (PKey) | 15 | 123456 | Item number |
| Sprak (PKey) | 2 | EN | Language |
| BenTyp (PKey) | 2 | 01 | Name type |
Example of a file with deleted item names¶
The name of the sent file is DelProdName_yymmdd_hhmmss.txt
Pulsen filename and SP¶
DELPRODUCTNAME, PXXDLSINRIVBORT
001|530814|01|SV
001|530814|02|SV
001|530815|01|SV
001|530815|02|SV
001|530817|01|SV
001|530817|02|SV
Trigger for the Item name file¶
The Item name file is sent both as an incremental file, where only rows with updated/changed items since the last time the file was sent, and as a full file where all rows are inserted into the file. The latter will generate a lot of data, hence it is created on fewer occasions.
Factors that determines if a row will be added in the file.
| Trigger | Description |
| xPrmFok.ForsVar | The item should not belong to the sales variant 02 |
| xArtBen.SysAndrTidStamp | The item name’s changing timestamp must be later than the latest scheduled file transfer. When a full Item name file export is done the latter value is set, hence all rows will be included in the file |
Item description¶
In this file all or only the item desciption change(d)(not removed) since the previous file was sent. These are configured/set up in Harmoney there can be one or many texts(different description types(BeskrTyp))
| Code | Type |
|---|---|
| 03 | Item description |
| 08 | Item description image text |
| 09 | Cross sales text |
In the export file line feeds are replaced with a space character.
| Name | Max length | Example | Description |
|---|---|---|---|
| Fok (PKey) | 3 | 001 | Sales channel |
| Artnr (PKey) | 15 | 123456 | Item number |
| Sprak (PKey) | 2 | EN | Language |
| BeskrTp (PKey) | 2 | 01 | Description type |
| Text | 3000 |
Example of an Item description file¶
The name of the sent file is ProdDesc_yymmdd_hhmmss.txt.
Pulsen filename and SP¶
PRODUCTDESC, PXXDLSINRIVPRODBESKR
001|276008|EN|03|Padded BRA with golden shining material. Handwash
Trigger for the Item description file¶
The Item description file is sent both as an incremental file, where only rows with updated/changed items since the last time the file was sent, and as a full file where all rows are inserted into the file. The latter will generate a lot of data, hence it is created on fewer occasions.
Factors that determines if a row will be added in the file.
| Trigger | Description |
| xPrmFok.ForsVar | The item should not belong to the sales variant 02 |
| xArtNot.Text | The should not be empty |
| xArtNot.SysAndrTidStamp | The item description changing timestamp must be later than the latest scheduled file transfer. When a full Item description file export is done the latter value is set, hence all rows will be included in the file |
Deleted Item descriptions¶
In this file only the description texts that has been deleted since the previous file are sent.
| Name | Max length | Example | Description |
|---|---|---|---|
| Fok (PKey) | 3 | 001 | Sales channel |
| Artnr (PKey) | 15 | 123456 | Item number |
| BeskrTp (PKey) | 2 | 01 | Description type |
| Sprak (PKey) | 2 | EN | Language |
| TidStamp | 26 | 2017-03-10- 14.45.05.325141 | Timestamp when deleted |
Example of a file with Deleted item descriptions¶
The name of the sent file is DelProdDesc_yymmdd_hhmmss.txt
Pulsen filename and SP¶
DELPRODDESC, PXXDLSINRIVBORT
007|100006|03|EN|2017-02-01-09.13.38.523589
001|100024|01|SV|2017-03-22-08.40.48.920805
006|100024|01|NO|2017-03-22-08.40.48.920805
001|330266|01|SV|2016-08-22-07.51.11.654757
006|330266|01|NO|2016-08-22-07.51.11.654757
Property file¶
In this file updated or changed properties are sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Egenskapsid (PKey) | Property id (PKey) | 5 | 118hR | Property identification |
| Sprak (PKey) | Language (PKey) | 2 | EN | Property language |
| Ben | Description | 40 | Armlength | Property Description |
| Egenskapstyp (Pkey) | Property type (PKey) | 2 | 01 | 01 = Dimensional feature 02 = Item property 03 = Color property |
Example of a file with Properties¶
The name of the sent file is ProdPropDesc_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTPROPDESC, PXXDLSINRIVKOMPBEN
0j0hI|DA|Omkreds|01
0j0hI|EN|Circumference|01
0j0hI|FI|Ympärysmitta|01
0j0hI|NO|Omkrets|01
0j0hI|SV|Omkrets|01
118hR|DA|Armlængde|01
118hR|EN|Armlength|01
118hR|FI|Käsivarren pituus|01
118hR|NO|Armlengde|01
118hR|SV|Ärmlängd|01
Property Values file¶
In this file updated or changed Property Values are sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Egenskapsid (PKey) | Property id (PKey) | 5 | VKWJk | Property identification |
| Egenskapsvärde (PKey) | Property value (PKey) | 5 | 1QM5m | Property value identification |
| Sprak (PKey) | Language (PKey) | 2 | EN | Property value language |
| Ben | Description | 40 | 127 | Property Value Description |
| Egenskapstyp (Pkey) | Property type (PKey) | 2 | 01 | 01 = Dimensional feature 02 = Item property 03 = Color property |
Example of a file with Property values¶
The name of the sent file is ProdPropValDesc_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTPROPVALDESC, PXXDLSINRIVKOMPVBEN
VKWJk|1QM5m|EN|127|01
VKWJk|y3vNQ|EN|130|01
VKWJk|vNlcs|EN|118|01
VKWJk|SNB4r|EN|132|01
VKWJk|oUBd9|EN|100|01
Item properties file¶
In this file updated or changed stock items are sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Artikelnr (PKey) | Item No (PKey) | 15 | 00968857 | Item number |
| Attr1 (PKey) | Attr1 (PKey) | 5 | Attribute id 1 | |
| Attr2 (PKey) | Attr2 (PKey) | 5 | Attribute id 2 | |
| Attr3 (PKey) | Attr3 (PKey) | 5 | Attribute id 3 | |
| Attr4 (PKey) | Attr4 (PKey) | 5 | Attribute id 4 | |
| Attr5 (PKey) | Attr5 (PKey) | 5 | Attribute id 5 | |
| Egenskapstyp (Pkey) | Property type (PKey) | 2 | 02 | 01 = Dimensional feature 02 = Item property 03 = Color property |
| Egenskapsid (PKey) | Property id (PKey) | 5 | gkvC0 | Property identification |
| Egenskapsvärde (PKey) | Property value (PKey) | 5 | 3vace | Property value identification |
| LöpNr (PKey) | Serial number (PKey) | 15 | 1984543 | The serial number |
Example of a file with Item properties¶
The name of the sent file is ProdProp_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTPROP, PXXDLSINRIVLAGARTKOMP
00968857||||||02|gkvC0|3vace|1984543
00968857||||||02|GMYnI|ZdnJZ|1984544
00968857||||||02|lwJV2|nfRIB|1984545
00968864||||||02|gkvC0|3vace|1984499
00968864||||||02|GMYnI|ZdnJZ|1984500
00968864||||||02|lwJV2|nfRIB|1984501
00968867||||||02|gkvC0|3vace|1984505
00968867||||||02|GMYnI|ZdnJZ|1984506
00968867||||||02|lwJV2|nfRIB|1984507
Trigger for the Item properties file¶
The Item properties file is sent both as an incremental file, where only rows with updated/changed items since the last time the file was sent, and as a full file where all rows are inserted into the file. The latter will generate a lot of data, hence it is created on fewer occasions.
Factors that determines if a row will be added in the file.
| Trigger | Description |
| xLagArtKomp.AndrDat | The item properties changing timestamp must be later than the latest scheduled file transfer. When a full Item properties file export is done the latter value is set, hence all rows will be included in the file. |
Deleted item properties file¶
In this file all or only the item properties change(d)(not removed) since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Artikelnr (PKey) | Item No (PKey) | 15 | 123456 | Item number |
| Attr1 (PKey) | Attr1 (PKey) | 5 | 1234 | Attribute id 1 |
| Attr2 (PKey) | Attr2 (PKey) | 5 | 001 | Attribute id 2 |
| Attr3 (PKey) | Attr3 (PKey) | 5 | Attribute id 3 | |
| Attr4 (PKey) | Attr4 (PKey) | 5 | Attribute id 4 | |
| Attr5 (PKey) | Attr5 (PKey) | 5 | Attribute id 5 | |
| Egenskapstyp (Pkey) | Property type (Pkey) | 2 | 01 | 01 = Dimensional feature 02 = Item property 03 = Color property |
| Egenskapsid (PKey) | Property id (Pkey) | 5 | Abc12 | Property identification |
| Egenskapsvärde (PKey) | Property value (Pkey) | 5 | 12Abc | Property value identification |
| LöpNr (Pkey) | Serial number (Pkey) | 15 | 12345 | The serial number |
Example of a file with Deleted item properties¶
The name of the sent file is DelProdProp_yymmdd_hhmmss.txt
Pulsen filename and SP¶
DELPRODUCTPROP, PXXDLSINRIVBORT
100001||||||02|xG2zR|YiO35|17895
100002||||||02|xG2zR|YiO35|17896
100003||||||02|xG2zR|YiO35|17897
Stock balance¶
In this file all or only the item change(d)(not removed) since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| LagId (PKey) | Stock id | 3 | 001 | Stock id. The id of the storage where the item is |
| LagArtnr (PKey) | Stock item number | 15 | 123456 | Stock item number |
| Attr1 (PKey) | Attr1(PKey) | 5 | 1234 | Attribute id 1 (Additional value) |
| Attr2 (PKey) | Attr2(PKey) | 5 | 001 | Attribute id 2 (Additional value) |
| Attr3 (PKey) | Attr3(PKey) | 5 | 12 | Attribute id 3 (Additional value) |
| Attr4 (PKey) | Attr4(PKey) | 5 | 12 | Attribute id 4 (Additional value) |
| Attr5 (PKey) | Attr5(PKey) | 5 | 12 | Attribute id 5 (Additional value) |
| LagAnt | Number of items | 10 | 15,00 | Physical units in stock (Additional value) |
| InkAnt | Number of items | 10 | 3,00 | Number of units on purchase order (Additional value) |
| ResLagAnt | Number of reserved | 10 | 4,00 | Number of reserved units in physical stock (Additional value) |
| ResInkAnt | Number of reserved | 10 | 6,00 | Number of reserved units on purchase order (Additional value) |
| InLevDat | Delivery date | 10 | 2017-03-27 | First expected delivery date from supplier where available units is larger than zero* (Additional value) |
| LevLedTid | Delivery time | 10 | 12,0 | Suppliers delivery time including lead after placing the purchase order (Additional value) |
| EjResvaAnt | 10 | 15,00 | Number of non reserved units(Additional field) | |
| SakLagAnt | 8 | 15 | Safety stock number(Additional field) | |
| InLagAnt | 8 | 25 | Stock balance for Stock.pos.type ‘03’ (Additional field) |
*Date = 0001-01-01 is sent if no date is set.
*Fields marked with (Additional field) is not sent as default, only on request.
Example of a stock balance file¶
The name of the sent file is ProdStock_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTSTOCK, PXXDLSINRIVLAGSALDONY
001|00100000||||||658,00|55,00|0,00|0,00|0001-01-01|15,0|23,00|2
001|00100000||||||423,00|30,00|0,00|0,00|0001-01-01|15,0|52,00|2
001|00100000||||||365,00|65,00|0,00|0,00|0001-01-01|15,0|46,00|2
How to calculate the physical stock balance¶
Example 1
| Stock examples | |
|---|---|
| LagAnt = physical quantity/number in stock(i.e. 15 pcs) | |
| InkAnt = quantity ordered from supplier through purchase order(100 pcs) | |
| ResLagAnt = quantity already reserved by customer order against physical stock(i.e. 15 pcs) | |
| ResInkAnt = quantity alreadey reserved by customer order against purchase order(i.e. 5 pcs) | |
| InLevDat = first scheduled delivery date from supplier(i.e. 2016-11-01) |
In this scenario there are 0 pcs(15(LagAnt) - 15(ResLagAnt)) available products at the main warehouse for immediate delivery, but there are 95 pcs(100(InkAnt) - 5(ResInkAnt) available against purchase order expected at the main warehouse 2016-11-01.
Example 2
| Stock examples | |
|---|---|
| LagAnt = physical quantity/number in stock(i.e. 15 pcs) | |
| InkAnt = quantity ordered from supplier through purchase order(0 pcs) | |
| ResLagAnt = quantity already reserved by customer order against physical stock(i.e. 4 pcs) | |
| ResInkAnt = quantity alreadey reserved by customer order against purchase order(i.e. 0 pcs) | |
| InLevDat = first scheduled delivery date from supplier(i.e. 0001-01-01) |
In this scenario there are 11 pcs(15(LagAnt) - 4(ResLagAnt)) available products at the main warehouse for immediate delivery and no products arriving from the supplier to the main warehouse.
Trigger for the stock balance file¶
The stock balance file is sent both as an incremental file, where only rows with updated/changed items since the last time the file was sent, and as a full file where all rows are inserted into the file. The latter will generate a lot of data, hence it is created on fewer occasions.
Factors that determines if a row will be added in the file.
| Trigger | Description |
LagAnt xLagPlTyp.RakLag xKolliSta.Tillg |
(Physical units in stock) The flag “included in physical storage” has to be set to true. The status code should define the package/item as available |
InkAnt xInkOrdTyp.RakLag xInkRadStl.SlutLev |
(Incoming stock number) The flag “included in physical storage” has to be set to true. The flag “finally delivered” has to set to false |
ResInkAnt xPrmFtg.SakLag xLagArtVar.SakLagBer xLag.SakLag |
(Reserved incoming stock number) The function “safety stock number” has to be set to true. The flag “include with available stock has to be active. The flag “safety stock is used for the current stock item id has to be set as true. |
| xLagArtVarLogg | Stock availability is triggered by the table xLagArtVarLogg which directly affects if the row will be included in the file or not. The table has many triggers and is used by a number of stored procedures that updates the status of the stock availability. |
Stock balance, B2B, with available balance per purchace order¶
In this file all or only the item change(d)(not removed) since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| LagId (PKey) | Stock id | 3 | 001 | Stock id. The id of the storage where the item is |
| LagArtnr (PKey) | Stock item number | 15 | 123456 | Stock item number |
| Attr1 (PKey) | Attr1(PKey) | 5 | 1234 | Attribute id 1 (Additional value) |
| Attr2 (PKey) | Attr2(PKey) | 5 | 001 | Attribute id 2 (Additional value) |
| Attr3 (PKey) | Attr3(PKey) | 5 | 12 | Attribute id 3 (Additional value) |
| Attr4 (PKey) | Attr4(PKey) | 5 | 12 | Attribute id 4 (Additional value) |
| Attr5 (PKey) | Attr5(PKey) | 5 | 12 | Attribute id 5 (Additional value) |
| Typ | Type | 5 | 1 | Type 1=In stock, 2=Purchase order, 3=Oversold |
| InLevnsDat | Delivery date | 10 | 2017-03-27 | Expected delivery date from supplier |
| Disp | Available balance | 10 | 45,00 | Available balance |
| TillgAnt | Number of items | 10 | 15,00 | Number of units available(Additional field) |
| ResvaAnt | 10 | 10,00 | Number of reserved units(Additional field) | |
| SakLagAnt | 8 | 15 | Safety stock number(Additional field) |
*Date = 0001-01-01 is sent if no date is set.
*Fields marked with (Additional field) is not sent as default, only on request.
Example of a stock balance B2B file¶
The name of the sent file is ProdDisp_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTDISP, PXXDLSINRIVDISPNY
001|611015|2101|27522||||2|24,00|24,00|0,00|0,00
001|611015|2101|27522||||3|0,00|0,00|0,00|0,00
001|611015|2101|27523||||1|0,00|0,00|0,00|0,00
001|611015|2101|27523||||2|12,00|12,00|0,00|0,00
Trigger for the stock balance B2B file¶
The stock balance B2B file is sent both as an incremental file, where only rows with updated/changed items since the last time the file was sent, and as a full file where all rows are inserted into the file. The latter will generate a lot of data, hence it is created on fewer occasions.
Factors that determines if a row will be added in the file.
| Trigger | Description |
LagAnt xLagPlTyp.RakLag xKolliSta.Tillg |
(Physical units in stock) The flag “included in physical storage” has to be set to true. The status code should define the package/item as available |
InkAnt xInkOrdTyp.RakLag xInkRadStl.SlutLev |
(Incoming stock number) The flag “included in physical storage” has to be set to true. The flag “finally delivered” has to set to false |
ResInkAnt xPrmFtg.SakLag xLagArtVar.SakLagBer xLag.SakLag |
(Reserved incoming stock number) The function “safety stock number” has to be set to true. The flag “include with available stock has to be active. The flag “safety stock is used for the current stock item id has to be set as true. |
| xLagArtVarLogg | Stock availability is triggered by the table xLagArtVarLogg which directly affects if the row will be included in the file or not. The table has many triggers and is used by a number of stored procedures that updates the status of the stock availability. |
Stock balance for stores¶
In this file all or only the item change(d)(not removed) since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| LagId (PKey) | Stock id | 3 | 001 | Stock id. The id of the storage where the item is |
| LagArtnr (PKey) | Stock item number | 15 | 123456 | Stock item number |
| Attr1 (PKey) | Attr1(PKey) | 5 | 1234 | Attribute id 1 (Additional value) |
| Attr2 (PKey) | Attr2(PKey) | 5 | 001 | Attribute id 2 (Additional value) |
| Attr3 (PKey) | Attr3(PKey) | 5 | 12 | Attribute id 3 (Additional value) |
| Attr4 (PKey) | Attr4(PKey) | 5 | 12 | Attribute id 4 (Additional value) |
| Attr5 (PKey) | Attr5(PKey) | 5 | 12 | Attribute id 5 (Additional value) |
| LagAnt | Number of items | 10 | 15,00 | Physical units in stock (Additional value) |
| InkAnt | Number of items | 10 | 3,00 | Number of units on purchase order (Additional value) |
| ResLagAnt | Number of reserved | 10 | 4,00 | Number of reserved units in physical stock (Additional value) |
| ResInkAnt | Number of reserved | 10 | 6,00 | Number of reserved units on purchase order (Additional value) |
| InLevDat | Delivery date | 10 | 2017-03-27 | First expected delivery date from supplier where available units is larger than zero* (Additional value) |
| LevLedTid | Delivery time | 10 | 12,0 | Suppliers delivery time including lead after placing the purchase order (Additional value) |
| EjResvaAnt | 10 | 15,00 | Number of non reserved units(Additional field) | |
| SakLagAnt | 8 | 15 | Safety stock number(Additional field) |
*Date = 0001-01-01 is sent if no date is set.
*Fields marked with (Additional field) is not sent as default, only on request.
Example of a stock balance for stores file¶
The name of the sent file is ProdStockVariant_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTSTOCKVARIANT, PXXDLSINRIVLAGSALDOFORSVAR
006|390000|10|00013||||1,00|0,00|0,00|0,00|0001-01-01|0,0|0,00|0
006|390000|10|00014||||1,00|0,00|0,00|0,00|0001-01-01|0,0|0,00|0
006|390000|10|00015||||1,00|0,00|0,00|0,00|0001-01-01|0,0|0,00|0
006|390000|80|00013||||1,00|0,00|0,00|0,00|0001-01-01|0,0|0,00|0
006|390000|80|00014||||1,00|0,00|0,00|0,00|0001-01-01|0,0|0,00|0
006|390000|80|00015||||1,00|0,00|0,00|0,00|0001-01-01|0,0|0,00|0
006|390001|10|00013||||2,00|0,00|0,00|0,00|0001-01-01|0,0|0,00|0
006|390001|10|00014||||2,00|0,00|0,00|0,00|0001-01-01|0,0|0,00|0
006|390002|10|00000||||29,00|0,00|0,00|0,00|0001-01-01|0,0|0,00|0
006|390003|10|00014||||1,00|0,00|0,00|0,00|0001-01-01|0,0|0,00|0
006|390003|80|00014||||1,00|0,00|0,00|0,00|0001-01-01|0,0|0,00|0
How to calculate the physical stock balance for stores¶
Example 1
| Stock examples | |
|---|---|
| LagAnt = physical quantity/number in stock(i.e. 15 pcs) | |
| InkAnt = quantity ordered from supplier through purchase order(100 pcs) | |
| ResLagAnt = quantity already reserved by customer order against physical stock(i.e. 15 pcs) | |
| ResInkAnt = quantity alreadey reserved by customer order against purchase order(i.e. 5 pcs) | |
| InLevDat = first scheduled delivery date from supplier(i.e. 2016-11-01) |
In this scenario there are 0 pcs(15(LagAnt) - 15(ResLagAnt)) available products at the main warehouse for immediate delivery, but there are 95 pcs(100(InkAnt) - 5(ResInkAnt) available against purchase order expected at the main warehouse 2016-11-01.
Example 2
| Stock examples | |
|---|---|
| LagAnt = physical quantity/number in stock(i.e. 15 pcs) | |
| InkAnt = quantity ordered from supplier through purchase order(0 pcs) | |
| ResLagAnt = quantity already reserved by customer order against physical stock(i.e. 4 pcs) | |
| ResInkAnt = quantity alreadey reserved by customer order against purchase order(i.e. 0 pcs) | |
| InLevDat = first scheduled delivery date from supplier(i.e. 0001-01-01) |
In this scenario there are 11 pcs(15(LagAnt) - 4(ResLagAnt)) available products at the main warehouse for immediate delivery and no products arriving from the supplier to the main warehouse.
Trigger for the stock balance file¶
The stock balance file is sent both as an incremental file, where only rows with updated/changed items since the last time the file was sent, and as a full file where all rows are inserted into the file. The latter will generate a lot of data, hence it is created on fewer occasions.
Factors that determines if a row will be added in the file.
| Trigger | Description |
LagAnt xLagPlTyp.RakLag xKolliSta.Tillg |
(Physical units in stock) The flag “included in physical storage” has to be set to true. The status code should define the package/item as available |
InkAnt xInkOrdTyp.RakLag xInkRadStl.SlutLev |
(Incoming stock number) The flag “included in physical storage” has to be set to true. The flag “finally delivered” has to set to false |
ResInkAnt xPrmFtg.SakLag xLagArtVar.SakLagBer xLag.SakLag |
(Reserved incoming stock number) The function “safety stock number” has to be set to true. The flag “include with available stock has to be active. The flag “safety stock is used for the current stock item id has to be set as true. |
| xLagArtVarLogg | Stock availability is triggered by the table xLagArtVarLogg which directly affects if the row will be included in the file or not. The table has many triggers and is used by a number of stored procedures that updates the status of the stock availability. |
Stock transactions¶
In this file the stock items oldest and last delivery dates was made at the storage defined as the main storage are sent. Only items that has changed since the previous file was sent are added into the file.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| LagId (PKey) | Stock id | 3 | 001 | Stock id. The id of the storage where the item is |
| LagArtnr (PKey) | Stock item number | 15 | 123456 | Stock item number |
| Attr1 (PKey) | Attr1(PKey) | 5 | 1234 | Attribute id 1 |
| Attr2 (PKey) | Attr2(PKey) | 5 | 001 | Attribute id 2 |
| Attr3 (PKey) | Attr3(PKey) | 5 | 12 | Attribute id 3 |
| Attr4 (PKey) | Attr4(PKey) | 5 | 12 | Attribute id 4 |
| Attr5 (PKey) | Attr5(PKey) | 5 | 12 | Attribute id 5 |
| MinInLevnsDat | 10 | 2017-01-25 | The date when the last delivery was made* | |
| MaxInLevnsDat | 10 | 2017-03-26 | The date when the oldest delivery was made* |
*Date = 0001-01-01 is sent if no date is set.
Example of a stock transactions file¶
The name of the sent file is Product_stockdates_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTSTOCKDATES, PXXDLSINRIVLAGTRANS
001|00100000||||||2014-01-01|2015-01-01
Trigger for the stock transactions file¶
The stock transactions file is sent both as an incremental file, where only rows with updated/changed items since the last time the file was sent, and as a full file where all rows are inserted into the file. The latter will generate a lot of data, hence it is created on fewer occasions.
Factors that determines if a row will be added in the file.
| Trigger | Description |
LagTrans xLagTrans.LagTransTyp xLagTrans.TidStamp |
(All stock item transactions) Only transaction of the type delivery(00300) is included Only transactions with timestamp > previous files date are included |
Stock item barcodes¶
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| LagArtnr (PKey) | Stock item No (PKey) | 15 | 123456 | Item number |
| Attr1 (PKey) | Attr1 (PKey) | 5 | 1234 | Attribute id 1(e.g color) |
| Attr2 (PKey) | Attr2 (PKey) | 5 | 001 | Attribute id 2(e.g. size) |
| Attr3 (PKey) | Attr3 (PKey) | 5 | 12 | Attribute id 3 |
| Attr4 (PKey) | Attr4 (PKey) | 5 | 12 | Attribute id 4 |
| Attr5 (PKey) | Attr5 (PKey) | 5 | 12 | Attribute id 5 |
| Type (PKey) | Type (PKey) | 2 | 01 | Type 01 = EAN(European article number), 02 = ISBN(Interantional standard book number) Types can be set up in Harmoney |
| MarknKod | Barcode | 15 | 7801314775132 | Barcode |
Example of a Stock item barcodes file¶
The name of the sent file is ProdMark_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTMARK, PXXDLSINRIVLAGARTMARKN
200016|5640|00000||||01|7391091011000
200641|5640|00000||||01|4008496623877
200775|0005|00000||||01|7350033083154
200775|0009|00000||||01|7350033083147
200776|0003|00000||||01|7350033083161
200776|0013|00000||||01|7350033083277
200777|0005|00000||||01|7350033083130
200989|5640|00000||||01|8712581492892
201124|5640|00000||||01|7350033083246
201125|5640|00000||||01|7350033083413
Trigger for the stock item barcodes file¶
The stock item barcodes file is sent both as an incremental file, where only rows with updated/changed items since the last time the file was sent, and as full file where all rows are inserted into the file. The latter will generate a lot of data, hence it is created on fewer occasions.
Factors that determines if a row will be added in the file.
| Trigger | Description |
| xLagArtMarkn.AndrDat | Only transactions with timestamp > previous files date are included. If a full file is created the latter date i set to include all rows of the datatable |
Deleted stock item barcodes¶
In this file all or only the stock item EAN and ISBN codes that has been removed since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| LagArtnr (PKey) | Stock item No (PKey) | 15 | 123456 | Stock item number |
| Attr1 (PKey) | Attr1 (PKey) | 5 | 1234 | Attribute id 1(e.g color) |
| Attr2 (PKey) | Attr2 (PKey) | 5 | 001 | Attribute id 2(e.g. size) |
| Attr3 (PKey) | Attr3 (PKey) | 5 | 12 | Attribute id 3 |
| Attr4 (PKey) | Attr4 (PKey) | 5 | 12 | Attribute id 4 |
| Attr5 (PKey) | Attr5 (PKey) | 5 | 12 | Attribute id 5 |
| Type (PKey) | Type (PKey) | 2 | 01 | Type 01 = EAN(European article number), 02 = ISBN(Interantional standard book number) Types can be set up in Harmoney |
Example of deleted stock item barcodes file¶
The name of the sent file is DelProdMark_yymmdd_hhmmss.txt
Pulsen filename and SP¶
DELPRODMARK, PXXDLSINRIVBORT
200016|5640|00000||||01
200641|5640|00000||||01
200775|0005|00000||||01
200775|0009|00000||||01
200776|0003|00000||||01
200776|0013|00000||||01
200777|0005|00000||||01
200989|5640|00000||||01
201124|5640|00000||||01
201125|5640|00000||||01
Bundled item¶
In this file all or only the item properties change(d)(not removed) since the previous file was sent.
A bundled item is an item number used to tie together multiple items under on name. It is actually the inlcuded items which is kept storaged and are picked when an order is to be delivered, but the sale information etc. could be on the package item(Package header).
The items included in the bundled item can also be sold separately. Hence they can be present in the Item file, Item price file, Item description file and included in the Package item file.
Explanation: If the customer buys the item 123456 with the color 1234 in size 123 he/she will also get 2 pcs of item 987654 with the color 1234 in size 123. The most common is that the file contains several posts(rows) with the same package header but different including items.
For example. Order item 111111(package header) and get item 222222 and 333333(included items). This is sent as two posts(rows) in the Package item file. The customer only has to book one item number on the order.
The stucture of the bundled item is configured in Harmoney. It’s not used by all clients.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales channel | 3 | 001 | Sales channel |
| PakArtnr (PKey) | Bundled item number | 15 | 123456 | The bundled header’s item number |
| PakAttr1 (PKey) | Attr1(PKey) | 5 | 1234 | The bundled header’s attribute id 1 |
| PakAttr2 (PKey) | Attr2(PKey) | 5 | 001 | The bundled header’s attribute id 2 |
| PakAttr3 (PKey) | Attr3(PKey) | 5 | 12 | The bundled header’s attribute id 3 |
| PakAttr4 (PKey) | Attr4(PKey) | 5 | 12 | The bundled header’s attribute id 4 |
| PakAttr5 (PKey) | Attr5(PKey) | 5 | 12 | The bundled header’s attribute id 5 |
| Artnr (PKey) | Artnr(PKey) | 15 | 123456 | Item number |
| Attr1 (PKey) | Attr1(PKey) | 5 | 1234 | Attribute id 1 |
| Attr2 (PKey) | Attr2(PKey) | 5 | 001 | Attribute id 2 |
| Attr3 (PKey) | Attr3(PKey) | 5 | 12 | Attribute id 3 |
| Attr4 (PKey) | Attr4(PKey) | 5 | 12 | Attribute id 4 |
| Attr5 (PKey) | Attr5(PKey) | 5 | 12 | Attribute id 5 |
| Antal | Number of units | 10 | 2017-01-25 | Number of included part |
Example of a Bundled item file¶
The name of the sent file is ProdBund_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTBUNDLE, PXXDLSINRIVPKTART
001|107103|0010|000||||107043|0010|002||||1
001|107103|0010|000||||107018|0010|002||||1
Trigger for the Bundled item file¶
The Bundled Item file is sent both as an incremental file, where only rows with updated/changed items since the last time the file was sent, and as a full file where all rows are inserted into the file. The latter will generate a lot of data, hence it is created on fewer occasions.
Factors that determines if a row will be added in the file.
| Trigger | Description |
| xPrmFok.ForsVar | The item should not belong to the sales variant 02 (Warehouse/store) |
| xPktArt.Ant | Number of item units has to larger than zero(0) |
| xPktArt.SysAndrTidStamp | The Package items changing timestamp must be later than the latest scheduled file transfer. When a full Bundled item file export is done the latter value is set, hence all rows will be included in the file |
Deleted bundled items¶
In this file all or only the item change(d)(not removed) since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales channel | 3 | 001 | Sales channel |
| Artnr (PKey) | Artnr(PKey) | 15 | 123456 | Item number |
| Attr1 (PKey) | Attr1(PKey) | 5 | 1234 | Attribute id 1 |
| Attr2 (PKey) | Attr2(PKey) | 5 | 001 | Attribute id 2 |
| Attr3 (PKey) | Attr3(PKey) | 5 | 12 | Attribute id 3 |
| Attr4 (PKey) | Attr4(PKey) | 5 | 12 | Attribute id 4 |
| Attr5 (PKey) | Attr5(PKey) | 5 | 12 | Attribute id 5 |
Example of a Deleted Bundled item file¶
The name of the sent file is DelProdBund_yymmdd_hhmmss.txt
Pulsen filename and SP¶
DELPRODBUND, PXXDLSINRIVBORT
200|000100|00|00000||||
004|000001|50|00005||||
004|000001|01|00004||||
004|000001|01|00005||||
Cross sale items¶
In this file all or only the item(s) change(d)(not removed) since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales chennel | 3 | 001 | Sales channel |
| Artnr (PKey) | Bundled item number | 15 | 123456 | The bundled header’s item number |
| Attr1 (PKey) | Attr1(PKey) | 5 | 1234 | The bundled header’s attribute id 1 |
| Attr2 (PKey) | Attr2(PKey) | 5 | 001 | The bundled header’s attribute id 2 |
| Attr3 (PKey) | Attr3(PKey) | 5 | 12 | The bundled header’s attribute id 3 |
| Attr4 (PKey) | Attr4(PKey) | 5 | 12 | The bundled header’s attribute id 4 |
| Attr5 (PKey) | Attr5(PKey) | 5 | 12 | The bundled header’s attribute id 5 |
| MerforsArtnr (PKey) | Stock item number | 15 | 123456 | The item number |
| MerforsAttr1 (PKey) | Attr1(PKey) | 5 | 1234 | Attribute id 1 |
| MerforsAttr2 (PKey) | Attr2(PKey) | 5 | 001 | Attribute id 2 |
| MerforsAttr3 (PKey) | Attr3(PKey) | 5 | 12 | Attribute id 3 |
| MerforsAttr4 (PKey) | Attr4(PKey) | 5 | 12 | Attribute id 4 |
| MerforsAttr5 (PKey) | Attr5(PKey) | 5 | 12 | Attribute id 5 |
| Antal | Number of units | 10 | 2017-01-25 | Number of included partsl |
| LöpNr* |
Example of a Cross sale item file¶
The name of the sent file is ProdCrossSale_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTCROSSSALE, PXXDLSINRIVMERFORS
001|00364006||||||13155016|0000|021||||1,00|1
001|00364006||||||13235002|0000|011||||1,00|1
001|00364006||||||09522001|0000|000||||1,00|1
001|00364014||||||07120020|0000|000||||1,00|2
001|00364014||||||02422022|0000|000||||1,00|2
001|00364014||||||13235021|0000|010||||1,00|2
001|00364014||||||04246126|0000|027||||1,00|2
001|00364014||||||09557048|0000|021||||1,00|2
001|00364014|0000|001||||07120020|0000|000||||1,00|2
001|00364015||||||04253235|0000|010||||1,00|3
Deleted cross sale items¶
In this file all or only the cross sale item(s) change(d)(not removed) since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales chennel | 3 | 001 | Sales channel |
| Artnr (PKey) | Bundled item number | 15 | 123456 | The bundled header’s item number |
| LöpNr | Serial number | 15 | 12345 | Serial numnber |
Example of a Deleted cross sale item file¶
The name of the sent file is DelProdCross_yymmdd_hhmmss.txt
Brands¶
In this file all or only the cross sale item(s) change(d)(not removed) since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Varumärke (PKey) | Brand | 2 | 01 | The brand |
| VarumärkeBen (PKey) | Name of brand | 40 | Pulsen | The brands name |
| Språk (PKey) | Language | 2 | EN | Language |
| Rubrik | Header | 254 | Text header | The header of the brands text |
| Text | Text | 32000 | Lorem ipsum | A text that corresponds to the brand(HTML is possible) |
Example of a Brands file¶
The name of the sent file is brands_yymmdd_hhmmss.txt
Pulsen filename and SP¶
BRANDS, PXXDLSINRIVVARUMARKE
01| Apple Mouth Bit®|DA||<center> <img src=http://www.company.se/butik/assets/images/varumarken/applemouth.gif></center><br><span class=stext>Populære syntetbid med æblesmag. Et revolutionerende materiale som hesten kan lide fra første øjeblik. Apple Mouth er slidstærkt og fremmer spytproduktionen. Alle metaldele er i rustfrit stål.</span>
01||EN||01| Apple Mouth Bit®|FI||<center> <img src=http://www.company.se/butik/assets/images/varumarken/applemouth.gif></center><br><span class=stext>Suositut omenanmakuiset synteettikuolaimet. Mullistava materiaali, josta hevoset todella pitävät. Apple Mouth on kulutusta kestävä ja lisää syljen eritystä. Kaikki metalliosat ovat ruostumatonta terästä.</span>
01| Apple Mouth Bit®|NO||<center> <img src=http://www.company.se/butik/assets/images/varumarken/applemouth.gif></center><br><span class=stext>Populære syntetiske bitt med eplesmak. Et revolusjonerende materiale som gjør at hesten liker det fra første stund. Apple Mouth er slitesterkt og stimulerer spyttsekresjonen. Alle metalldeler er i rustfritt stål. </span>
01| Apple Mouth Bit®|SV||<center> <img src=http://www.company.se/butik/assets/images/varumarken/applemouth.gif></center><br><span class=stext>Populära syntetbett med äppelsmak. Ett revolutionerande material som gör att hästen gillar det från första början. Apple Mouth är slitstarkt, och främjar salivavsöndringen. Alla metalldelar är i rostfritt stål. </span>
01| Apple Mouth Bit®|EN||<center> <img src=http://www.company.se/butik/assets/images/varumarken/applemouth.gif></center><br><span class=stext>Popular synthetic bite of apple flavor. A revolutionary material that allows the horse to it like from the beginning. Apple Mouth is durable and promotes salivation. All metal parts are stainless steel. </span>
Trigger for the Brands file¶
The Brands file is sent both as an incremental file, where only rows with updated/changed items since the last time the file was sent, and as a full file where all rows are inserted into the file. The latter will generate a lot of data, hence it is created on fewer occasions.
Factors that determines if a row will be added in the file.
| Trigger | Description |
| xVaruMarke.SysAndrTidStamp | The brands changing timestamp must be later than the latest scheduled file transfer. When a full Brands file export is done the latter value is set, hence all rows will be included in the file |
| xTextStor.AndrDat | The texts value changing timestamp must be later than the latest scheduled file transfer. When a full Brands file export is done the latter value is set, hence all rows will be included in the file |
Item class¶
This file describes the item classes configured in Harmoney. In this file all or only the Item class(es) change(d)(not removed) since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Varuklass (PKey) | Item class | 2 | 01 | The item class |
| Språk (PKey) | Language | 2 | EN | Language |
| VaruklassBen | Item class name | 40 | Pulsen | Item class name |
Example of an Item class file¶
The name of the sent file is ProdClass_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTCLASS, PXXDLSINRIVVARUKL
04|DA|Hund
04|EN|Dog
04|FI|Hund
04|NO|Hund
04|SV|Hund
05|DA|Hundtilbehør
05|EN|Dog accessories
05|FI|Koira tarvikkeet
05|DA|Hundtillbehör
30|DA|Læder/Grime
30|EN|Leather/Halter
30|FI|Nahka/Suitset
30|NO|Læer/Grimer
30|SV|Läder/Grimmor
Item group¶
This file describes the item groups configured in Harmoney. In this file all or only the Item class(es) change(d)(not removed) since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Varugrupp (PKey) | Item group | 3 | 01 | The item group |
| Språk (PKey) | Language | 2 | EN | Language |
| VarugruppBen | Item group name | 40 | Pulsen | Item group’s name |
Example of an Item group file¶
The name of the sent file is ProdGroup_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTGROUP, PXXDLSINRIVVARUGRP
014|DA|Hund
014|EN|Dog
014|FI|Koira
014|NO|Hund
014|SV|Hund
120|DA|Trøjer
120|EN|Sweatshirts
120|FI|Paidat
120|NO|Gensere
120|SV|Tröjor
Item code¶
This file describes the item codes configured in Harmoney. In this file all or only the Item code(s) change(d)(not removed) since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Varukod (PKey) | Item code | 4 | 01 | The item code |
| Språk (PKey) | Language | 2 | EN | Language |
| VarugruppBen | Item group name | 40 | Pulsen | Item group’s name |
Example of an Item code file¶
The name of the sent file is ProdCode_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTCODE, PXXDLSINRIVVARUKOD
1040|DA|Hundtilbehør
1040|EN|Dog accessories
1040|FI|Koira tarvikkeet
1040|DA|Hundtillbehör
3010|DA|Læder/Grime
3010|EN|Leather/Halter
3010|FI|Nahka/Suitset
3010|NO|Læer/Grimer
3010|SV|Läder/Grimmor
Activities(Campaigns)¶
This file describes the main activities and activities configured in Harmoney. In this file all or only the main activities and/or activities changed (not removed) since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales channel | 3 | 001 | Sales channel |
| HuvAkt (PKey) | Main activity | 7 | 11A01 | The main activity(campaign) |
| HuvAktBen | Name | 100 | Spring 1 2017 | The name of the main activity(campaign) |
| DefAkt | Default activity | 7 | 11A0104 | The default activity |
| RabId | Discount id | 7 | 11A0001 | The id of the discount |
| LagPr | Stock price | 1 | X | X = To be included when calculating the lowest price |
| InetStartDat | Start date | 10 | 2017-03-25 | Date when the main activity beigns at the web shop(internet) |
| InetStoppDat | End date | 10 | 2017-06-20 | Date when the main activity ends at the web shop(internet) |
| Akt (PKey) | Activity | 7 | 11A0104 | The activity |
| AktBen | Name | 100 | Spring catalogue | Name of the activity |
| AktTyp (PKey) | Type id | 3 | 001 | Id of the activity type |
| StartDat (PKey) | Start date | 10 | 2017-03-25 | Start date of the activity(Harmoney) |
| StoppDat (PKey) | End date | 10 | 2017-06-25 | End date of the activity(Harmoney) |
| AktRabId (PKey) | Activity dsicount id | 7 | 11A0001 | The activity’s discount id |
| AktKat (PKey) | Catalog | 1 | X | X = The activity generates a catalog request |
| PostOrdErb | Mailorder/Club | 1 | X | If prices on main activity is valid for mailorder/club (Additional field) |
| ButikErb | Store | 1 | X | If prices on main activity is valid for stores (Additional field) |
| EndFok | Only sales channel | 3 | 101 | Price on main activity valid for this sales channel only (Additional field) |
Activity type Id’s¶
| Code | Name |
|---|---|
| 001 | Huvudkatalog/Main catalog |
| 002 | Rea-aktivitet/Sale activity |
| 004 | Preview-aktivitet/Preview activity |
| 005 | Värvnings-aktivitet/Recruitment activity |
| 006 | Svarsaktivitet/Response activity |
| 007 | Svarsaktivitet intro/Response activity intro |
| 008 | Klubb-tidning/Club newsletter |
| 009 | Svarsaktivitet internet/Response activity internet |
| 010 | Push/Push |
| 011 | Follow-up/Follow up |
| 012 | Version/Version |
| 013 | Prislista/Price list |
| 014 | Katalogbegär internet/Catalogue request internet |
Example of an Activities(campaigns) file¶
The name of the sent file is Campaign_yymmdd_hhmmss.txt
Pulsen filename and SP¶
CAMPAIGN, PXXDLSINRIVAKTINFO
001|11B03|Home campaign autumn|11B0301||X|2017-03-25|2017-06-20|11B0301|Preview home card autumn|004|2017-03-25|2017-06-25||
101|11B03|Home campaign autumn|11B0301||X|2017-03-25|2017-06-20|11B0301|Preview home card autumn|004|2017-03-25|2017-06-25||
102|11B03|Home campaign autumn|11B0301||X|2017-03-25|2017-06-20|11B0301|Preview home card autumn|004|2017-03-25|2017-06-25||
103|11B03|Home campaign autumn|11B0301||X|2017-03-25|2017-06-20|11B0301|Preview home card autumn|004|2017-03-25|2017-06-25||
104|11B03|Home campaign autumn|11B0301||X|2017-03-25|2017-06-20|11B0301|Preview home card autumn|004|2017-03-25|2017-06-25||
105|11B03|Home campaign autumn|11B0301||X|2017-03-25|2017-06-20|11B0301|Preview home card autumn|004|2017-03-25|2017-06-25||
109|11B03|Home campaign autumn|11B0301||X|2017-03-25|2017-06-20|11B0301|Preview home card autumn|004|2017-03-25|2017-06-25||
301|11B03|Home campaign autumn|11B0301||X|2017-03-25|2017-06-20|11B0301|Preview home card autumn|004|2017-03-25|2017-06-25||
Trigger for the Activities(campaigns) file¶
The Activities file is sent both as an incremental file, where only rows with updated/changed activities since the last time the file was sent, and as a full file where all rows are inserted into the file. The latter will generate a lot of data, hence it is created on fewer occasions.
Factors that determines if a row will be added in the file.
| Trigger | Description |
| xErb.Andr or xAkt.AndrDat or xKat.AndrDat | The activities changing timestamp must be later than the latest scheduled file transfer. When a full Activities file export is done the latter value is set, hence all rows will be included in the file |
Discount terms¶
This file describes the Discount terms configured in Harmoney. In this file all or only the Discount terms change(d)(not removed) since the previous file was sent. Note Be aware that this is an additional function and it’s not included in Harmoney’s basic configuration set up.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Ftg (PKey) | Company | 2 | 01 | Company code |
| Fok (PKey) | Sales chennel | 3 | 001 | Sales channel |
| RabattId (PKey) | Discount id | 7 | 1234567 | The id of the discount |
| VillkGrp (PKey) | Discount group | 3 | 21 | Discount group 1-999 |
| Niva (PKey) | Level | 2 | 01 | Level of discount 1-99 |
| Benämning | Name | 50 | Discount VIP | Name of the dicsount term |
| StartDat | Start date | 10 | 2017-03-25 | Start date of the discount |
| StoppDat | End date | 10 | 2017-06-25 | End date of the discount |
| FullPris | Full price | 1 | X | X = Only items having full price is included |
| KöpBelopp | Purchase amount | 12 | 1000.00 | The amount the customer has to reach to get the discount |
| Antal art | Number of items | 10 | 12.00 | Number of items the customer has to buy to get the discount |
| KundSegmentStart | Customer segment | 2 | 01 | The discount term is only valid for customers in the intervall |
| KundSegmentStopp | Customer segment | 2 | 99 | The discount term is only valid for customers in the intervall |
| Varuklass | Item class | 2 | 10 | Terms for the item class |
| Varukod | Item code | 4 | 1000 | Terms for the item code |
| Varugrupp | Item group | 3 | 123 | Terms for the item group |
| Kundkategori | Customer category | 2 | 23 | Terms for the customer category |
| Ordersätt | Order method | 2 | 08 | Terms for the order method |
| Faktureringssätt | Payment method | 2 | 26 | Terms for the payment method |
| Artikellista | Items list | 2 | A1 | The code of the list of items the dicount terms are valid for |
| ArtikellistaEj | Items list | 1 | X | X = The items list is excluded from the discount terms |
| KundenFåttAktivitet | Recieved activity | 7 | 01123 | The customer has to have this activity to be able to use the discount |
| Antal dagar | Number of days | 3 | 10 | Within days the customer has to utilize the customer discount |
| RabattTyp | Discount id | 2 | 01 | The id of the discount type |
| RabattProcent | Percentage | 6 | 15.00 | Dicsount percentage |
| RabattBelopp | Amount | 12 | 150.00 | The amount of the discount |
| RabattStopp | Stop | 1 | X | If this discount type is fullfilled the customer can’t have more discounts |
| RabattAntal | Discounted item | 10 | 10.00 | Number of discounted items |
| RabattArtilellista | Discount list | 2 | A2 | The code for the items list containing items with discount |
| RabattArtilellistaEj | Discount list | 1 | X | X = The items list is excluded from the discount |
| RabattPris | Discount price | 12 | 99.00 | The discount price |
| RabatteradVaruklass | Discount item class | 2 | 20 | Discount for the item group |
| RabatteradVarukod | Discount item code | 4 | 9999 | Discount for the item code |
| RabatteradVarugrupp | Discount item group | 3 | 343 | Discount for the item group |
| AntalKundRabatter | Number of discounts | 3 | 1 | The maximum number of times a customer can utilize the current discount |
| FraktFritt | No shipping fee | 1 | X | X = No shipping fees on the order |
| IngaExpAvg | No service fee | 1 | X | X = No service fees on the order |
| NäraKöpBelopp | Teaser | 10 | 1200.00 | Display the discount term if the customer has this part value in the checkout basket to get a possible cross sale. |
| NäraKöpBelopp | Teaser | 10 | 13.00 | Display the discount term if the customer has this number of items in the checkout basket to get a possible cross sale. |
| StartSida | Home page | 1 | X | X = Show the discount terms on the start page |
Discount types¶
| Code | Name |
|---|---|
| 01 | Cheapest |
| 02 | Next order row |
| 03 | The entire order |
| 04 | From the discount list |
| 05 | Free, automatic set up |
| 06 | Free, no automatic set up |
| 07 | The most expensive |
Example of an Discount terms file¶
The name of the sent file is Discount_yymmdd_hhmmss.txt
Pulsen filename and SP¶
DISCOUNT, PXXDLSINRIVRABVILLK
01|001|ZR01|1|1|10% Hela Kvittot|2017-03-25|X|0.00|3|||||||||10.00||||1|0.00|0.00|0.00|A1||||||0.00|||||
01|002|ZR01|1|1|10% Hela Kvittot|2017-03-25|X|0.00|3|||||||||10.00||||1|0.00|0.00|0.00|A1||||||0.00|||||
01|004|ZR01|1|1|10% Hela Kvittot|2017-03-25|X|0.00|3|||||||||10.00||||1|0.00|0.00|0.00|A1||||||0.00|||||
01|005|ZR01|1|1|10% Hela Kvittot|2017-03-25|X|0.00|3|||||||||10.00||||1|0.00|0.00|0.00|A1||||||0.00|||||
01|007|ZR01|1|1|10% Hela Kvittot|2017-03-25|X|0.00|3|||||||||10.00||||1|0.00|0.00|0.00|A1||||||0.00|||||
Discount lists¶
This file describes the Discount lists configured in Harmoney. In this file all or only the Discount terms change(d)(not removed) since the previous file was sent. Note Be aware that this is an additional function and it’s not included in Harmoney’s basic configuration set up.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Ftg (PKey) | Company | 2 | 01 | Company code |
| Fok (PKey) | Sales chennel | 3 | 001 | Sales channel |
| RabattId (PKey) | Discount id | 7 | 1234567 | The id of the discount |
| Listkod (PKey) | List code | 2 | A1 | Discount group 1-999 |
| Artnr (PKey) | Bundled item number | 15 | 123456 | The bundled header’s item number |
| Attr1 (PKey) | Attr1(PKey) | 5 | 1234 | The bundled header’s attribute id 1 |
| Attr2 (PKey) | Attr2(PKey) | 5 | 001 | The bundled header’s attribute id 2 |
| Attr3 (PKey) | Attr3(PKey) | 5 | 12 | The bundled header’s attribute id 3 |
| Attr4 (PKey) | Attr4(PKey) | 5 | 12 | The bundled header’s attribute id 4 |
| Attr5 (PKey) | Attr5(PKey) | 5 | 12 | The bundled header’s attribute id 5 |
| Prisgrupp (PKey) | Price group | 2 | 01 | The price group |
| Pris | Price | 12 | 99.00 | The price the article can be payed for if the discount terms are met |
Example of an Discount lists file¶
The name of the sent file is DiscountProd_yymmdd_hhmmss.txt
Pulsen filename and SP¶
DISCOUNTPRODUCT, PXXDLSINRIVRABART
01|001|ZR01|A1|00001|01|0001||||01|199.00
01|001|ZR01|A1|00001|01|0009||||01|179.00
01|002|ZR01|A1|00001|01|0001||||01|99.00
01|002|ZR01|A1|00001|01|0009||||01|79.00
Discount Item detail file¶
This file contains all item with one or more discounts associated. In this file all or only those itmes change(d)(not removed) since the previous file was sent. Note Be aware that this is an additional function and it’s not included in Harmoney’s basic configuration set up. Contact Pulsen for more detailed information how to use this file and existing limitations.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales chennel | 3 | 001 | Sales channel |
| RabId (PKey) | Discount id | 7 | 1234567 | The id of the discount |
| VillkGrp (PKey) | Discount group | 3 | 21 | Discount group 1-999 |
| Niva (PKey) | Level | 2 | 01 | Level of discount 1-99 |
| VisaInet (PKey) | In the web shop | 1 | X | Displayed/to be viewed in web shop |
| Artnr (PKey) | Item number | 15 | 123456 | The item number(XXXXXXXXXXXXXXX applies to all items) |
| Attr1 (PKey) | Attr1(PKey) | 5 | 1234 | Attribute id 1(XXXXX applies to all attribute1) |
| Attr2 (PKey) | Attr2(PKey) | 5 | 001 | Attribute id 2(XXXXX applies to all attribute2) |
| Ben | Name | 50 | 15 % Chaps | Name of the dicsount term |
| DatFran | Start date | 10 | 2017-03-25 | Start date of the discount* |
| DatTill | End date | 10 | 2017-06-25 | End date of the discount* |
| KopBel | Purchase amount | 11 | 500 | Term: The purchase amount(Buy for X SEK) |
| VillkAntArt | Number of items | 9 | 2 | Term: Number of items(Buy X items) |
| VillkListKod | Code in the item list | 2 | A1 | Term: Code in the item list |
| VillkListKodEj | Excluded in the item list | 1 | X | Term: Excluded in the item list |
| FullPr | Full price | 1 | X | Term: Full price |
| VillkVaruKl | Item class | 2 | 04 | Term: Item class |
| VillkVaruGrp | Item group | 3 | 002 | Term: Item group |
| VillkVaruKod | Item code | 4 | 0001 | Term: Item code |
| RabTyp | Discount type | 2 | 03 | Discount:The id of the discount type (01 = The cheapest, 02 = Next orderrow, 03 = The entire order 04 = from the discount list, 05 = Free automatic registration, 06 = Free, no automatic registration, 07 = The most expensive, 08 = Average price) |
| RabProc | Percentage | 5 | 20 | Dicsount: Discount as a percentage |
| RabBel | Amount | 11 | 300 | Discount: The amount of the discount(local currency) |
| RabPr | Discount price | 11 | 100 | Discount: Fixed discount price(local currency) |
| RabAnt | Discounted item | 9 | 5 | Discount:Number of discounted items in discount items list |
| RabListKod | Discount list | 2 | A1 | Discount:The code for the items list |
| RabListaKodEj | Discount list | 1 | X | Discount: Item(s) excluded from the discount |
| FullPrAv | No full price | 1 | X | Discount: No full price |
| RabStopp | Stop | 1 | X | Discount:If this discount type is fullfilled the customer can’t have any more discounts |
| RabVaruKl | Discount item class | 2 | 02 | Discount:Item class |
| RabVaruGrp | Discount item group | 3 | 002 | Discount:Item group |
| RabVarukod | Discount item code | 4 | 001 | Discount:Item code |
| FraktAvgBort | No shipping fee | 1 | X | Discount: Remove shipping fees on the order |
| ExpAvgBort | No service fee | 1 | X | Discount: Remove service fees on the order |
| TextTyp | Text type | 3 | 015 | Type of text i.e. 015 = Discount text |
| Text | Text | 5 | 500 | Text id |
| LopText | Description | 3000 | Buy now - No shippin fees | Descriptive text |
| GrundPr | Ordinary price | 11 | 379 | The ordinary price of the item before the discount. (The price is always fetched from the price activity GRUND) |
| UrvalIdKund | Customer selection | 5 | 19 | Id of the customer selection 0 = No customer selection 7 = Member of loyalty program 19 = Valid for e-commerce 34 = Loyalty member e-commerce |
| Akt | Recieved Activity | 7 | CODES | Activity needed to get discount (Additional value) |
| AntUtn | Can be used.. | 5 | 2 | Discount can be used.. (Additional value) |
| AntUtnTyp | ..times at this level | 10 | Level | ..times at this Level, Group or DiscountId (Additional value) |
| KundKatgor | Customer category | 2 | 01 | Customer category (Additional value) |
*Date = 0001-01-01 is sent if no date is set.
Example of an DiscountProdDetail file¶
The name of the sent file is DiscountProdDetail_yymmdd_hhmmss.txt
Pulsen filename and SP¶
DISCOUNTPRODDETAIL, PXXDLSRABEXP
001|1710001|500|1||110282|10|00003|10% Classic Jacka|2017-02-16|2017-07-26|0,00|10,00|S4||X||||04|10,00|0,00|0,00|19,00|S4|||X||||||015|||799,00|19
001|1710001|500|1||110282|10|00004|10% Classic Jacka|2017-02-16|2017-07-26|0,00|10,00|S4||X||||04|10,00|0,00|0,00|19,00|S4|||X||||||015|||799,00|19
001|1710001|500|1||110282|10|00005|10% Classic Jacka|2017-02-16|2017-07-26|0,00|10,00|S4||X||||04|10,00|0,00|0,00|19,00|S4|||X||||||015|||799,00|19
001|1710001|500|1||110282|10|00006|10% Classic Jacka|2017-02-16|2017-07-26|0,00|10,00|S4||X||||04|10,00|0,00|0,00|19,00|S4|||X||||||015|||799,00|19
001|1710001|500|1||110282|10|00007|10% Classic Jacka|2017-02-16|2017-07-26|0,00|10,00|S4||X||||04|10,00|0,00|0,00|19,00|S4|||X||||||015|||799,00|19
001|1710001|500|1||110282|10|00008|10% Classic Jacka|2017-02-16|2017-07-26|0,00|10,00|S4||X||||04|10,00|0,00|0,00|19,00|S4|||X||||||015|||799,00|19
001|1710001|500|1||110282|10|12228|10% Classic Jacka|2017-02-16|2017-07-26|0,00|10,00|S4||X||||04|10,00|0,00|0,00|19,00|S4|||X||||||015|||699,00|19
001|1710001|500|1||110282|10|13440|10% Classic Jacka|2017-02-16|2017-07-26|0,00|10,00|S4||X||||04|10,00|0,00|0,00|19,00|S4|||X||||||015|||699,00|19
001|1710001|500|1||110282|10|14652|10% Classic Jacka|2017-02-16|2017-07-26|0,00|10,00|S4||X||||04|10,00|0,00|0,00|19,00|S4|||X||||||015|||699,00|19
001|1710001|500|1||110282|10|15864|10% Classic Jacka|2017-02-16|2017-07-26|0,00|10,00|S4||X||||04|10,00|0,00|0,00|19,00|S4|||X||||||015|||699,00|19
Discount Item file¶
This file contains all items with one or more discounts associated. In this file all or only those itmes change(d)(not removed) since the previous file was sent. Note Be aware that this is an additional function and it’s not included in Harmoney’s basic configuration set up. Contact Pulsen for more detailed information how to use this file and existing limitations.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales chennel | 3 | 001 | Sales channel |
| RabId (PKey) | Discount id | 7 | 1234567 | The id of the discount |
| VillkGrp (PKey) | Discount group | 3 | 21 | Discount group 1-999 |
| Niva (PKey) | Level | 2 | 01 | Level of discount 1-99 |
| VisaInet (PKey) | In the web shop | 1 | X | Displayed/to be viewed in web shop |
| Artnr (PKey) | Item number | 15 | 123456 | The item number(XXXXXXXXXXXXXXX applies to all items) |
| Attr1 (PKey) | Attr1(PKey) | 5 | 1234 | Attribute id 1(XXXXX applies to all attribute1) |
| Attr2 (PKey) | Attr2(PKey) | 5 | 001 | Attribute id 2(XXXXX applies to all attribute2) |
| Ben | Name | 50 | 15 % Chaps | Name of the dicsount term |
| DatFran | Start date | 10 | 2017-03-25 | Start date of the discount* |
| DatTill | End date | 10 | 2017-06-25 | End date of the discount* |
| KopBel | Purchase amount | 11 | 500 | Term: The purchase amount(Buy for X SEK) |
| VillkAntArt | Number of items | 9 | 2 | Term: Number of items(Buy X items) |
| VillkListKod | Code in the item list | 2 | A1 | Term: Code in the item list |
| VillkListKodEj | Excluded in the item list | 1 | X | Term: Excluded in the item list |
| FullPr | Full price | 1 | X | Term: Full price |
| VillkVaruKl | Item class | 2 | 04 | Term: Item class |
| VillkVaruGrp | Item group | 3 | 002 | Term: Item group |
| VillkVaruKod | Item code | 4 | 0001 | Term: Item code |
| RabTyp | Discount type | 2 | 03 | Discount:The id of the discount type (01 = The cheapest, 02 = Next orderrow, 03 = The entire order 04 = from the discount list, 05 = Free automatic registration, 06 = Free, no automatic registration, 07 = The most expensive, 08 = Average price) |
| RabProc | Percentage | 5 | 20 | Dicsount: Discount as a percentage |
| RabBel | Amount | 11 | 300 | Discount: The amount of the discount(local currency) |
| RabPr | Discount price | 11 | 100 | Discount: Fixed discount price(local currency) |
| RabAnt | Discounted item | 9 | 5 | Discount:Number of discounted items in discount items list |
| RabListKod | Discount list | 2 | A1 | Discount:The code for the items list |
| RabListaKodEj | Discount list | 1 | X | Discount: Item(s) excluded from the discount |
| FullPrAv | No full price | 1 | X | Discount: No full price |
| RabStopp | Stop | 1 | X | Discount:If this discount type is fullfilled the customer can’t have any more discounts |
| RabVaruKl | Discount item class | 2 | 02 | Discount:Item class |
| RabVaruGrp | Discount item group | 3 | 002 | Discount:Item group |
| RabVarukod | Discount item code | 4 | 001 | Discount:Item code |
| FraktAvgBort | No shipping fee | 1 | X | Discount: Remove shipping fees on the order |
| ExpAvgBort | No service fee | 1 | X | Discount: Remove service fees on the order |
| TextTyp | Text type | 3 | 015 | Type of text i.e. 015 = Discount text |
| Text | Text | 5 | 500 | Text id |
| LopText | Description | 3000 | Buy now - No shippin fees | Descriptive text |
| GrundPr | Ordinary price | 11 | 379 | The ordinary price of the item before the discount. (The price is always fetched from the price activity GRUND) |
| UrvalIdKund | Customer selection | 5 | 19 | Id of the customer selection 0 = No customer selection 7 = Member of loyalty program 19 = Valid for e-commerce 34 = Loyalty member e-commerce |
| Akt | Recieved Activity | 7 | CODES | Activity needed to get discount (Additional value) |
| AntUtn | Can be used.. | 5 | 2 | Discount can be used.. (Additional value) |
| AntUtnTyp | ..times at this level | 10 | Level | ..times at this Level, Group or DiscountId (Additional value) |
| KundKatgor | Customer category | 2 | 01 | Customer category (Additional value) |
*Date = 0001-01-01 is sent if no date is set.
Example of an DiscountProdItem file¶
The name of the sent file is DiscountProdItem_yymmdd_hhmmss.txt
Pulsen filename and SP¶
DISCOUNTPRODITEM, PXXDLSRABEXPNY
301|CODES2|1|1||200014|XXXXX|XXXXX|2110M -25% most expensive item+freedelivery m.offe|2021-04-07|2021-05-31|0,00|1,00|||||||07|25,00|0,00|0,00|1,00||||||||X|X|015|00019|25% rabatt på den dyraste varan + fri fakt|0,00|0|2110M|0||01
301|CODES2|1|1||200015|XXXXX|XXXXX|2110M -25% most expensive item+freedelivery m.offe|2021-04-07|2021-05-31|0,00|1,00|||||||07|25,00|0,00|0,00|1,00||||||||X|X|015|00019|25% rabatt på den dyraste varan + fri fakt|0,00|0|2110M|0||01
301|CODES2|1|1||200072|XXXXX|XXXXX|2110M -25% most expensive item+freedelivery m.offe|2021-04-07|2021-05-31|0,00|1,00|||||||07|25,00|0,00|0,00|1,00||||||||X|X|015|00019|25% rabatt på den dyraste varan + fri fakt|0,00|0|2110M|0||01
301|CODES2|1|1||200132|XXXXX|XXXXX|2110M -25% most expensive item+freedelivery m.offe|2021-04-07|2021-05-31|0,00|1,00|||||||07|25,00|0,00|0,00|1,00||||||||X|X|015|00019|25% rabatt på den dyraste varan + fri fakt|0,00|0|2110M|0||01
301|CODES2|1|1||200148|XXXXX|XXXXX|2110M -25% most expensive item+freedelivery m.offe|2021-04-07|2021-05-31|0,00|1,00|||||||07|25,00|0,00|0,00|1,00||||||||X|X|015|00019|25% rabatt på den dyraste varan + fri fakt|0,00|0|2110M|0||01
301|CODES2|1|1||200152|XXXXX|XXXXX|2110M -25% most expensive item+freedelivery m.offe|2021-04-07|2021-05-31|0,00|1,00|||||||07|25,00|0,00|0,00|1,00||||||||X|X|015|00019|25% rabatt på den dyraste varan + fri fakt|0,00|0|2110M|0||01
301|CODES2|1|1||200232|XXXXX|XXXXX|2110M -25% most expensive item+freedelivery m.offe|2021-04-07|2021-05-31|0,00|1,00|||||||07|25,00|0,00|0,00|1,00||||||||X|X|015|00019|25% rabatt på den dyraste varan + fri fakt|0,00|0|2110M|0||01
301|CODES2|1|1||200359|XXXXX|XXXXX|2110M -25% most expensive item+freedelivery m.offe|2021-04-07|2021-05-31|0,00|1,00|||||||07|25,00|0,00|0,00|1,00||||||||X|X|015|00019|25% rabatt på den dyraste varan + fri fakt|0,00|0|2110M|0||01
301|CODES2|1|1||200826|XXXXX|XXXXX|2110M -25% most expensive item+freedelivery m.offe|2021-04-07|2021-05-31|0,00|1,00|||||||07|25,00|0,00|0,00|1,00||||||||X|X|015|00019|25% rabatt på den dyraste varan + fri fakt|0,00|0|2110M|0||01
301|CODES2|1|1||200880|XXXXX|XXXXX|2110M -25% most expensive item+freedelivery m.offe|2021-04-07|2021-05-31|0,00|1,00|||||||07|25,00|0,00|0,00|1,00||||||||X|X|015|00019|25% rabatt på den dyraste varan + fri fakt|0,00|0|2110M|0||01
Item calculated average purchase price¶
This file describes the calculated average purchase price in Harmoney. In this file all or only the calculated average purchase prices change(d)(not removed) since the previous file was sent
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| LagId (PKey) | Stock id | 3 | 001 | Stock id. The id of the storage where the item is |
| LagArtnr (PKey) | Stock item number | 15 | 123456 | Stock item number |
| LagAttr1 (PKey) | Stock attribute 1 | 5 | 1234 | Attribute id 1 |
| LagAttr2 (PKey) | Stock attribute 2 | 5 | 001 | Attribute id 2 |
| LagAttr3 (PKey) | Stock attribute 3 | 5 | 12 | Attribute id 3 |
| LagAttr4 (PKey) | Stock attribute 4 | 5 | 12 | Attribute id 4 |
| LagAttr5 (PKey) | Stock attribute 5 | 5 | 12 | Attribute id 5 |
| KalkPr | Average purch. price | 12 | 99,00 | Average purchase price |
Example of an Item calculated average purchase file¶
The name of the sent file is ProdCalcPrice_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTCALCPRICE, PXXDLSINRIVKALKPR
001|031683|0188|03436||||34,79
001|031683|0188|03840||||34,79
001|031683|0188|04244||||34,79
001|031683|0188|04648||||34,79
001|031683|0188|05052||||34,79
001|031683|0188|05456||||34,79
001|031683|0188|05860||||34,79
001|031683|0188|06264||||34,79
001|031683|0042|03436||||34,79
Trigger for the Item calculated average purchase file¶
The Item calculated average purchase file is sent both as an incremental file, where only rows with updated/changed purchase prices since the last time the file was sent, and as a full file where all rows are inserted into the file.
Factors that determines if a row will be added in the file.
| Trigger | Description |
| xLagArtVarKalkPr. SysAndrTidStamp | The Item purchase price changing timestamp must be later than the latest scheduled file transfer. When a full Item purchase price file export is done the latter value is set, hence all rows will be included in the file |
Item statistical numbers¶
This file contains information about the item statistical number used in commerce between EU-country to/from non EU-country. In this file all or only those numbers change(d)(not removed) since the previous file was sent
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Id (PKey) | Id | 21 | 01-031681-02 | Company-StockItemNumber-CountryGroup |
| MottLand (PKey) | Country | 2 | GB | Recieving country |
| StatNr (PKey) | Statistical number | 13 | 6204300000 | Statistical number |
Example of an Item statistical number file¶
The name of the sent file is ProdStatNr_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTSTATNR, PXXDLSINRIVSTATNR
01-031681-02|SE|6204300000
01-031680-01|SE|6404400000
Trigger for the Item statistical number file¶
The Item statistical number file is sent both as an incremental file, where only rows with updated/changed since the last time the file was sent, and as a full file where all rows are inserted into the file.
Factors that determines if a row will be added in the file.
| Trigger | Description |
| xPrmFunk.Funk | The Items customs document code(TullDokKod) should be the same as the function code(configured in Harmoney) |
| xPrmFunk.Aktiv | The function has to be active(configured in Harmoney) |
| xPrmFunk.Agare | The functions “owner” has to be 02(configured in Harmoney) |
| xLagArtStatNr. SysAndrTidStamp | The statistical number’s changing timestamp must be later than the latest scheduled file transfer. When a full Item statistical number file export is done the latter value is set, hence all rows will be included in the file |
Suppliers¶
This file describes the suppliers configured in Harmoney In this file all or only those supppliers change(d)(not removed) since the previous file was sent
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Leverantör (PKey) | Supplier | 6 | 12345 | Supplier id in Harmoney |
| AktivPassiv | Status | 2 | 01 | 01 = Active 02 = Passive |
| Namn | Name | 35 | Pulsen | Name of the supplier |
| TranspLedTid | Lead time | 10 | 14 | The suppliers delivery time and general lead from placing the order/request. |
| KatGor | Category | 3 | 101 | Supplier’s category (Additional value) |
Example of an Suppliers file¶
The name of the sent file is ProdSuppl_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTSUPPLIER, PXXDLSINRIVLEV
000AWI|01|ART WORKS INTERNATIONAL|5|101
000BEN|01|BJÖRN SELLEN AB|5|101
000BER|01|BARBRO WESSLANDER|5|101
000BGS|01|SPRINGHILL TEXTILE AB|5|101
000BSA|01|BLUROSA INDUSTRIA E COMÉRCIO,LTD. |5|102
000BTA|01|BONITA EXPORT|5|102
000CAI|01|CHEUNG NGAI KNITTING FACTORY LTD|5|103
Trigger for the Suppliers file¶
The Suppliers file is sent both as an incremental file, where only rows with updated/changed since the last time the file was sent, and as a full file where all rows are inserted into the file.
Factors that determines if a row will be added in the file.
| Trigger | Description |
| xLagArtLev.HuvLevKod | The supplier should NOT be the main supplier |
| xLevAdr.Namn | The supplier has to have a name |
| xLev.AndrDat | The supplier’s changing timestamp must be later than the latest scheduled file transfer. When a full Suppliers file export is done the latter value is set, hence all rows will be included in the file |
Delivery methods¶
This file describes the delivery methods configured in Harmoney In this file all or only those delivery methods change(d)(not removed) since the previous file was sent
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales channel | 3 | 001 | Sales channel |
| LevnsSa (PKey) | Delivery method | 2 | 01 | Delivery method/distributor |
| LevnsSaTja (PKey) | Delivery service | 6 | 341256 | Additional service for the delivery method i.e. Home delivery or express delivery |
| LevnsSaBen | Name | 35 | MyPack | Name of the delivery method |
| LevnsSaTjaBen | Name | 35 | Express | Name of the delivery method’s additional service |
| Aktiv | Status | 1 | X | Is the delivery method active in the sales channel |
| Visa | Showable | 1 | X | Is the delivery method is to be shown in web shop |
| AvgArtNr | The item id of the fee | 15 | 989898 | The delivery fee’s item number |
Example of a Delivery methods file¶
The name of the sent file is DeliveryMethods_yymmdd_hhmmss.txt
Pulsen filename and SP¶
DELIVERYMETHODS, PXXDLSINRIVLEVNSSA
101|04|75|Posten Varubrev|Posten varubrev 1:a klass|X||
101|07|19|MyPack|MyPack|X|X|
102|02|2W45|Posten Brev|Brev PF|X||
102|07|19|MyPack|MyPack|X|X|
102|24|2W2103|Itella|Economy 16|X||
103|02|2W45|Posten Brev|Brev PF|X||
103|07|19|MyPack|MyPack|X|X|
103|07|1939|MyPack|MyPack Homedelivery|X|X|995102
104|07|19|MyPack|MyPack|X|X|
160|02|2W45|Posten Brev|Brev PF|X||
Item Delivery methods¶
This file describes the delivery methods and services that are linked to specific items in Harmoney. In this file all or only those itmes change(d)(not removed) since the previous file was sent
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales channel | 3 | 001 | Sales channel |
| ArtNr (PKey) | Item id | 15 | 131314 | Delivery method/distributor |
| LevnsSa (PKey) | Delivery method | 2 | 01 | Additional service for the delivery method |
| LevnsSaTja (PKey) | Delivery service | 6 | STYCKE | Name of the additional service |
| FastVal | Item id | 1 | X | The delivery method is active in the sales channel |
Example of an Item delivery methods file¶
The name of the sent file is ProdDeliveryMethods_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTDELIVERYMETHODS, PXXDLSINRIVARTLEVN
201|200001|04|S11|X
201|200001|07|S19|
201|200001|21|STYCKE|
201|200002|21|STYCKE|X
201|200529|21|STYCKE|X
201|227144|21|STYCKE|X
201|239182|21|STYCKE|X
Pick up locations¶
This file describes the pick up locations configured in Harmoney. In this file all or only those pick up locations change(d)(not removed) since the previous file was sent
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Ftg (PKey) | Company | 2 | 01 | Company code |
| Fok (PKey) | Sales chennel | 3 | 001 | Sales channel |
| Land (PKey) | Country | 2 | GB | Country code(ISO Standard) |
| LevnsSaTja (PKey) | Delivery service | 2 | S19 | Additional service for the delivery method |
| LevnsSaTjaBen | Name | 35 | MyPack | Name of the delivery method’s additional service |
| LevnsSa (PKey) | Delivery method | 2 | 01 | Delivery method/distributor |
| LevnsSaBen | Name | 35 | MyPack | Name of the delivery method |
| UtlamId (PKey) | Pick up point id | 10 | 101531 | The id of the pick up location |
| UtlamBen | Name of the pick up | 35 | Posten Borås | The name of the pick up location |
| UtlamAdr | Address | 35 | Main street 10 | The street address of the pick up location |
| UtlamPostNr | Postal code | 9 | 12121 | The postal code |
| UtlamPostOrt | City | 35 | Borås | The city |
| UtlamPostOrtDel | City district | 25 | Trandared | District of the city |
| UtlamInAktivDat | The date of inactivity | 10 | 9999-12-31 | The date when the pick up location became inactive. (9999-12-31 means that the pick up location is active) |
| UtlamTillgTid | Operating hours | 60 | Weekdays 8-20 Sat 8-16, Sun 9-16 | The pick up/access points operating hours |
| UtLamAktiv | Active | 1 | X | If the pick up location is active |
Example of a Pick up locations file¶
The name of the sent file is ProdPickUpLocation_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCT_PICKUPLOCATION, PXXDLSINRIVUTLAM
01|201|SE|S19|MyPack|07|MyPack|101531|POSTEN ALVESTA|HJÄRTENHOLMSVÄGEN 27|34230|ALVESTA||9999-12-31|VA 8:30-18|X
01|201|SE|S19|MyPack|07|MyPack|101561|ICA SUPERMARKET ALVESTA|ALLBOGATAN 11|34230|ALVESTA||9999-12-31|VA 8-20, LÖ 8-16, SÖ 9-16|X
01|201|SE|S19|MyPack|07|MyPack|101562|LAMMHULTSMACKEN|JÖNKÖPINGSVÄGEN 14|36030|LAMMHULT||9999-12-31|VA 8-21, LÖ 9-21, SÖ 9-21|X
01|201|SE|S19|MyPack|07|MyPack|101563|RADIO & TV-CENTER|V. JÄRNVÄGSGATAN 3|34260|MOHEDA||9999-12-31|VA 9-18, LÖ 9-13|X
Periods¶
This file describes all the periods configured in Harmoney, both active and historical In this file all periods are sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales chennel | 3 | 001 | Sales channel |
| Per (PKey) | Period | 6 | 2016S1 | The code for the period |
| Ben | Name | 20 | May 2017 | The name of the period |
| FranDat | From | 10 | 2017-04-30 | Start date |
| TillDat | To | 10 | 2017-06-01 | End date |
Example of a Periods file¶
The name of the sent file is ProdPer_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTPERIOD, PXXDLSINRIVPER
001|2017A|10SS|0001-01-01|0001-01-01
001|2017B|10HS|0001-01-01|0001-01-01
001|2017C|10AW|0001-01-01|0001-01-01
001|2017D|11SS|0001-01-01|0001-01-01
If period change is used the codes are interpreted in the following way.
Historical period: 001|2017A|10SS|2017-02-01|2017-02-15 Current period: 001|2017A|10SS|2017-02-16|0001-01-01 Coming period: 001|2017A|10SS|0001-01-01|0001-01-01
Item Period¶
This file describes all the periods configured in Harmoney, both active and historical In this file all periods are sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales chennel | 3 | 001 | Sales channel |
| ArtNr (PKey) | Item id | 15 | 123456 | Item id number |
| Per (PKey) | Period | 6 | 2016S1 | The code for the period |
Example of an Item period file¶
The name of the sent file is ProdArtPer_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTARTPER, PXXDLSINRIVARTPER
001|000002|200201
001|000002|200506
001|000002|201108
001|000002|201109
Item Club (Only for Club functionality)¶
This file describes club info configured in Harmoney. In this file all or only the club info change(d)(not removed) since the previous file was sent.
| Name | English desc. | Max length | Example | Description |
|---|---|---|---|---|
| Fok (PKey) | Sales channel | 3 | 001 | Sales channel |
| Fok_Ben | Sales channel name | 40 | Club Sweden | Sales channel name |
| Akt_Per (PKey) | Activity Period | 6 | 2016S1 | The code for the period on the activity |
| Akt_PerBen | Activity Period name | 20 | Spring 2016 | The name of the period on the activity |
| Akt_Akt (PKey) | Activity | 7 | 18A0101 | Activity code |
| Akt_Ben | Activity name | 100 | Spring activity | The name of the activity |
| Akt_StartDat (PKey) | Activity start date | 10 | 2018-04-01 | Activity start date |
| Akt_StoppDat (PKey) | Activity stop date | 10 | 2018-06-01 | Activity stop date |
| HuvAkt_HuvAkt (PKey) | Main Activity | 7 | 18A01 | Main Activity |
| HuvAkt_Ben | Main Activity name | 100 | Spring 2018 | Main Activity name |
| HuvAkt_InetStartDat | Main Activity web start date | 10 | 2018-04-02 | Main Activity web start date |
| HuvAkt_InetStoppDat | Main Activity web stop date | 10 | 2018-06-02 | Main Activity web stop date |
| HuvAkt_Prem_Typ (PKey) | Main Activity Premium type | 2 | 01 | Main Activity premium type |
| HuvAkt_Prem_TypBen | Main Activity Prem. type name | 40 | Loyalty premium | Main Activity premium type name |
| HuvAkt_Prem_ArtNr (PKey) | Main Activity Prem. article | 15 | 1234567 | Main Activity premium article |
| HuvAkt_Prem_Ant (PKey) | Main Activity Prem. quantity | 10 | 1,00 | Main Activity premium quantity |
| HuvAkt_Prem_Pr | Main Activity Prem. price | 10 | 55,00 | Main Activity premium price |
| HuvAkt_Prem_ArtNr_Grund_Pr | Main Activity Prem. price | 10 | 195,00 | Main Activity premium article GRUND price |
| HuvAkt_Prem_ArtNr_HuvAkt_Pr | Main Activity Prem. price | 10 | 195,00 | Main Activity premium article main activity price |
| HuvAkt_Prem_LevnsTillf | Main Activity Prem. delivery | 2 | 01 | Main Activity premium delivery |
| HuvAkt_Prem_TillgdTyp | Main Activity Prem. credittype | 2 | 01 | Main Activity premium credit type |
| HuvAkt_Prem_VardeChkGilt | Main Act. Prem. vouhcer valid | 6 | 90 | Main Activity premium voucher valid no of days |
| HuvAkt_Prem_FullPr | Main Activity Prem. full price | 1 | X | Main Activity premium full price |
| HuvAkt_Prem_NetPrKod | Main Activity Prem. net price | 1 | X | Main Activity premium net price |
| DistTab_Id (PKey) | Distribution table id | 5 | A | Distribution table id |
| DistTab_NegOptPer (PKey) | Distr. negative option period | 6 | 2016S1 | Distribution table negative option period |
| DistTab_NegOptDel (PKey) | Distr. negative option part | 6 | 1 | Distribution table negative option part in serie |
| DistTab_Tidn (PKey) | Distribution table magazine | 7 | 18A0101 | Distribution table magazine (activity) |
| DistTabLevArt_ArtNr (PKey) | Distribution table article | 15 | 7654321 | Distribution table leverance article |
| DistTabLevArt_Ant (PKey) | Distribution table quantity | 10 | 1,00 | Distribution table leverance article quantity |
| DistTabLevArt_ArtNr_Grund_Pr | Distribution table price | 10 | 129,00 | Distribution table leverance article GRUND price |
| DistTabLevArt_ArtNr_Tidn_Pr | Distribution table price | 10 | 129,00 | Distribution table leverance article magazine(activity) price |
| DistTabLevArt_DistArtTyp | Distribution table art. type | 02 | 01 | Distribution table leverance article type |
| DistTabLevArt_DistArtTypBen | Distr. table art. type name | 40 | Special delivery | Distribution table leverance article type name |
| Gren_Gren (PKey) | Club branch id | 2 | 01 | Club branch id |
| Gren_GrenBen | Club branch name | 20 | Branch A | Club branch name |
| Gren_GrenProcent | Club branch percent | 6 | 100,00 | Club branch percent |
Example of an Item club file¶
The name of the sent file is ProdClub_yymmdd_hhmmss.txt
Pulsen filename and SP¶
PRODUCTCLUB, PXXDLSINRIVKLUBB
021|021 Sundt Liv|201708|Blad 668A|GRND17|Grundaktivitet 2017|2017-05-01|2017-12-31|GRUND|Grundhuvudaktivitet|2006-12-15|2099-12-31||||0,00|0,00|0,00|0,00|||0|||||||0,00|0,00|0,00|||||0
021|021 Sundt Liv|201710|Blad 670A|IN001|intro web|2017-10-02|2018-02-08|F010001|intro web|0001-01-01|0001-01-01||||0,00|0,00|0,00|0,00|||0|||||||0,00|0,00|0,00|||||0
021|021 Sundt Liv|201717|Blad 677A|F010017|Blad 677A|2017-11-15|2017-12-09|F010017|F010017|0001-01-01|0001-01-01||||0,00|0,00|0,00|0,00|||0|||A|201717|F010017||0,00|0,00|0,00|||01|Grundgren A|100
021|021 Sundt Liv|201718|Blad 678A|F010018|Blad 678A|2017-12-01|2018-01-31|F010018|F010018|0001-01-01|0001-01-01||||0,00|0,00|0,00|0,00|||0|||A|201718|F010018||0,00|0,00|0,00|||01|Grundgren A|100
021|021 Sundt Liv|||||0001-01-01|0001-01-01|F010014|F010014|0001-01-01|0001-01-01||||0,00|0,00|0,00|0,00|||0|||||||0,00|0,00|0,00|||||0
021|021 Sundt Liv|||||0001-01-01|0001-01-01|F222222|Intro FB|0001-01-01|0001-01-01||||0,00|0,00|0,00|0,00|||0|||||||0,00|0,00|0,00|||||0
021|021 Sundt Liv|||||0001-01-01|0001-01-01|F010011|F010011|0001-01-01|0001-01-01||||0,00|0,00|0,00|0,00|||0|||||||0,00|0,00|0,00|||||0
021|021 Sundt Liv|||||0001-01-01|0001-01-01|F031017|Intro TM|0001-01-01|0001-01-01||||0,00|0,00|0,00|0,00|||0|||||||0,00|0,00|0,00|||||0
Tests¶
To run tests on any of our test systems please contact Pulsen. We have a number of test systems clients can use if needed.
Support¶
If you have any questions regarding this file description don’t hesitate to contact our support department.
Phone: +46 (0)33-17 19 40
Email: harmoneysupport@pulsen.se