EDIN-Distribution XML Specifications

Price list (document PRICAT)

Price list (document PRICAT) serves to describe goods and services. This document is sent by the Producer; the document indicates the barcode of the product, its description, price, VAT rate. You can also use the PRICAT to specify price changes (increase / decrease).

Field name

Type 1

Format

Description

PRICAT

The beginning of the document

ACTION

O

Number - «15», «16», «17», «18», «19»

Document type and action selection:

  • 15 - price list for Distribution,

  • 16 - mass cleaning of the price list,

  • 17 - price list with the characteristics of the product position,

  • 18 - price list with the prices of the commodity position,

  • 19 - request a price list for the current date

NUMBER

M

String (16)

Document number

DATE

M

Date (YYYY-MM-DD)

Document date

DATEFROM

M (O - if ACTION = 17)

Date (YYYY-MM-DD)

The price list takes effect from the date

DATETO

M (O - if ACTION = 17)

Date (YYYY-MM-DD)

Expiration date of the price list

SUPPLIER

M

Number (13)

Producer GLN

BUYER

M (O - if ACTION = 17)

Number (13)

Distributor GLN

SENDER

M

Number (13)

Message sender GLN

RECIPIENT

M (O - if ACTION = 17)

Number (13)

Message recipient GLN

CATALOGUE

Catalog (the beginning of the block)

POSITION

Commodity items (the beginning of the block)

POSITIONNUMBER

O

Positive number

Commodity item number (The sequence number of the item in the document (1, 2, 3, 4… n))

ACTION

O

Number - «2», «3», «4», «27», «29»

Action required:

  • 2 - add new items,

  • 3 - delete items,

  • 4 - change items data

PRODUCTGROUP

M (O - if ACTION = 18)

String (75)

Product Line name

BRAND

M (O - if ACTION = 18)

String (75)

Product Category name

SUBBRAND

M (O - if ACTION = 18)

String (75)

Product Subcategory name

IDSUPPLIER

M

String (16)

Article

PRODUCTNAME

M (O - if ACTION = 18)

String (255)

Full product name

PRODUCT

M

Positive integer (20)

Barcode

MINORDERQUANTITY

O (M-for Rozetka)

Floating point number (maximal 10 symbols before dot, 3 symbols after dot)

Minimum order quantity

IDPRODUCER

O

String (8)

Producer code

IDNATIONAL

O

Positive integer (20)

Product code according to the national classifier (UKT FEA Code)

UNITWEIGHT

O

Floating point number (maximal 10 symbols before dot, 3 symbols after dot)

Unit weight (kg)

QUANTITYOFCUINTU

M (O - if ACTION = 18)

Positive integer (10)

Units quantity in a box (pce)

BOXWEIGHT

O

Floating point number (maximal 10 symbols before dot, 3 symbols after dot)

Box weight (kg)

BOXINLAYER

O

Positive integer (20)

Boxes quantity in the layer (pce in 1 level)

BOXINPALLET

O

Positive integer (20)

Boxes quantity on the pallet (pce)

PALLETWEIGHT

O

Floating point number (maximal 10 symbols before dot, 3 symbols after dot)

Pallet weight (kg)

UNIT

M

String (3)

Units of measurement

ACTUALQUANTITY

O

Floating point number (maximal 10 symbols before dot, 3 symbols after dot)

Items balance

UNITPRICE

M (O - if ACTION = 17)

Floating point number (maximal 6 symbols before dot, 6 symbols after dot)

Price per unit without VAT (UAH)

PRICEWITHVAT

O

Floating point number (maximal 6 symbols before dot, 6 symbols after dot)

Price per unit with VAT (UAH)

TAXRATE

O

Positive integer - «20», «0», «7»

VAT rate, %

QUOTA

O

Floating point number (maximal 10 symbols before dot, 3 symbols after dot)

Quota to order

INFO

O

String (255)

Comment

NEWPOSITION

O

Number - «0», «1»

Novelty

PROMO

О

Number - «0», «1»

Action

PUBLICPOSITION

О

Number - «0», «1»

Public position

POSITION

Commodity items (the end of the block)

CATALOGUE

Catalog (the end of the block)

PRICAT

End of the document

PRICAT example

Order (document ORDER)

Order (document ORDER) is sent for delivery by the Distributor; the document indicates the barcode of the product, its description, ordered quantity, price and other necessary information.

Field name

Type 1

Format

Description

ORDER

The beginning of the document

DOCUMENTNAME

М

Positive number

Title of the document (220 — order)

NUMBER

М

String (50)

Order number

DATE

М

Date (YYYY-MM-DD)

Document date

DELIVERYDATE

М

Date (YYYY-MM-DD)

Delivery date

CURRENCY

O

String (3)

Currency code (UAH / RUB / USD / EUR / MDL / BYR…)

PAYMENTMETHOD

O

String (1)

Payment method code:

  • 1 - Cash payment

  • 2 - Cashless payment

DOCTYPE

O

String (1)

Document type:

  • O — original

DISTRIBUTOR

М

Filled in for Distribution service only

  • 1 — Distribution service document

HEAD

Start of the main block

SUPPLIER

M

Number (13)

Producer GLN

BUYER

M

Number (13)

Distributor GLN

DELIVERYPLACE

M

Number (13)

Delivery location GLN

SENDER

M

Number (13)

Message sender GLN

RECIPIENT

M

Number (13)

Message recipient GLN

EDIINTERCHANGEID

O

String (70)

Transaction number (Unique NUMBER generated by the sender)

DELIVERYTERMS

O

Number

Delivery:

  • 1 - Own transport;

  • 2 - Producers transport

POSITION

Commodity items (the beginning of the block)

POSITIONNUMBER

O

Positive number

Commodity item number (The sequence number of the item in the document (1, 2, 3, 4… n))

PRODUCT

M

Number (8, 10, 14)

Product barcode

PRODUCTIDSUPPLIER

O

String (16)

Item id in Producer database

IDPRODUCER

O

String (8)

Producer code

ORDEREDQUANTITY

M

Positive number

Ordered quantity (units quantity)

ORDERUNIT

M

String (3)

Units of measurement

ORDERPRICE

O

Decimal

Product price without VAT

PRICEWITHVAT

O

Decimal

Product price with VAT

VAT

O

Decimal

VAT rate, %

MAXIMUMORDERQUANTITY

O

Floating point number (maximal 10 symbols before dot, 3 symbols after dot)

Quota to order

CATEGORYNAME

O

String (70)

Product Line name

BRENDNAME

O

String (70)

Product Category name

GROUPNAME

Product Subcategory name

NOVELTY

O

Novelty

COUNTPIECESINBOX

O

Positive number

Units quantity in a box

COUNTBOXESINLAYER

O

Positive number

Boxes quantity in the layer (in 1 level)

COUNTPERPALLET

O

Positive number

Boxes quantity on the pallet

WEIGHT

O

Decimal

Box weight

UNITWEIGHT

O

Floating point number (maximal 10 symbols before dot, 3 symbols after dot)

Unit weight (kg)

PALLETS

O

Positive number

Pallets amount

BOXESCOUNT

O

Positive number

Boxes amount

CHARACTERISTIC

Characteristic (the beginning of the block)

DESCRIPTION

O

String (70)

Product name / description

CHARACTERISTIC

Characteristic (the end of the block)

POSITION

Commodity items (the end of the block)

HEAD

End of the main block

ORDER

End of the document

ORDER example

Limitation (document LIMITS)

Limitation (document LIMITS) to order is sent by the Producer; the document indicates the prices and quantities for the formation of the order from the specified Distributor.

Field name

Type 1

Format

Description

DISTRIBEX_LIMITS

The beginning of the document

HEAD

Start of the main block

SENDER

M

Number (13)

Producer GLN

RECIPIENT

M

Number (13)

Distributor GLN

LIMIT

Limitation (the beginning of the block)

NAME

M

String - «min_sum_nds», «max_sum_nds», «min_sum_without_nds», «max_sum_without_nds», «credit_limit», «max_weight», «max_pos_qty», «max_pack_qty», «max_pallet_qty», «multiplicity_packing», «surcharge_rate», «multiplicity_min_order_qty»

Limitation name

VALUE

M

Number (the format depends on NAME):

  • Minimal order sum with tax - float (10,4)

  • Maximal order sum with tax - float (10,4)

  • Minimal order sum without tax - float (10,4)

  • Maximal order sum without tax - float (10,4)

  • Credit limit - float (10,4)

  • Maximal order weight - float (13,3)

  • Maximal position quantity in order - Positive number (10)

  • Maximal packages quantity - Positive number (10)

  • Maximal pallets quantity - Positive number (10)

  • Multiplicity to package - 0-no; 1-yes

  • Tariff for the surcharge, UAH - float (10,2)

  • Multiplicity of the minimum order quantity - 0-no; 1-yes

Limitation meaning

LIMIT

Limitation (the end of the block)

HEAD

End of the main block

DISTRIBEX_LIMITS

End of the document

LIMITS example

1

The definition of an abbreviated notation:

  • M (mandatory);

  • O (optional).