# quota__headings

heading:
0305 – Fish, dried, salted or in brine; smoked fish, whether or not cooked before or during the smoking process


heading:
1104 – Cereal grains otherwise worked (for example, hulled, rolled, flaked, pearled, sliced or kibbled), except rice of heading|1006; germ of cereals, whole, rolled, flaked or ground


heading:
0706 – Carrots, turnips, salad beetroot, salsify, celeriac, radishes and similar edible roots, fresh or chilled


heading:
2009 – Fruit or nut juices (including grape must and coconut water) and vegetable juices, unfermented and not containing added spirit, whether or not containing added sugar or other sweetening matter


heading:
2302 – Bran, sharps and other residues, whether or not in the form of pellets, derived from the sifting, milling or other working of cereals or of leguminous plants


heading:
1902 – Pasta, whether or not cooked or stuffed (with meat or other substances) or otherwise prepared, such as spaghetti, macaroni, noodles, lasagne, gnocchi, ravioli, cannelloni; couscous, whether or not prepared


heading:
2008 – Fruit, nuts and other edible parts of plants, otherwise prepared or preserved, whether or not containing added sugar or other sweetening matter or spirit, not elsewhere specified or included


heading:
1601 – Sausages and similar products, of meat, meat offal, blood or insects; food preparations based on these products


heading:
0714 – Manioc, arrowroot, salep, Jerusalem artichokes, sweet potatoes and similar roots and tubers with high starch or inulin content, fresh, chilled, frozen or dried, whether or not sliced or in the form of pellets; sago pith


heading:
0206 – Edible offal of bovine animals, swine, sheep, goats, horses, asses, mules or hinnies, fresh, chilled or frozen


heading:
2007 – Jams, fruit jellies, marmalades, fruit or nut purée and fruit or nut pastes, obtained by cooking, whether or not containing added sugar or other sweetening matter


heading:
0811 – Fruit and nuts, uncooked or cooked by steaming or boiling in water, frozen, whether or not containing added sugar or other sweetening matter


heading:
1901 – Malt extract; food preparations of flour, groats, meal, starch or malt extract, not containing cocoa or containing less than 40|% by weight of cocoa calculated on a totally defatted basis, not elsewhere specified or included; food preparations of goods of headings|0401|to 0404, not containing cocoa or containing less than 5|% by weight of cocoa calculated on a totally defatted basis, not elsewhere specified or included


heading:
1904 – Prepared foods obtained by the swelling or roasting of cereals or cereal products (for example, corn flakes); cereals (other than maize (corn)) in grain form or in the form of flakes or other worked grains (except flour, groats and meal), pre-cooked or otherwise prepared, not elsewhere specified or included


heading:
1905 – Bread, pastry, cakes, biscuits and other bakers' wares, whether or not containing cocoa; communion wafers, empty cachets of a kind suitable for pharmaceutical use, sealing wafers, rice paper and similar products


heading:
0210 – Meat and edible meat offal, salted, in brine, dried or smoked; edible flours and meals of meat or meat offal


heading:
0307 – Molluscs, whether in shell or not, live, fresh, chilled, frozen, dried, salted or in brine; smoked molluscs, whether in shell or not, whether or not cooked before or during the smoking process


heading:
0306 – Crustaceans, whether in shell or not, live, fresh, chilled, frozen, dried, salted or in brine; smoked crustaceans, whether in shell or not, whether or not cooked before or during the smoking process; crustaceans, in shell, cooked by steaming or by boiling in water, whether or not chilled, frozen, dried, salted or in brine


heading:
2202 – Waters, including mineral waters and aerated waters, containing added sugar or other sweetening matter or flavoured, and other non-alcoholic beverages, not including fruit, nut or vegetable juices of heading|2009


heading:
0603 – Cut flowers and flower buds of a kind suitable for bouquets or for ornamental purposes, fresh, dried, dyed, bleached, impregnated or otherwise prepared


heading:
1106 – Flour, meal and powder of the dried leguminous vegetables of heading 0713, of sago or of roots or tubers of heading 0714 or of the products of Chapter 8


heading:
2004 – Other vegetables prepared or preserved otherwise than by vinegar or acetic acid, frozen, other than products of heading|2006


heading:
2005 – Other vegetables prepared or preserved otherwise than by vinegar or acetic acid, not frozen, other than products of heading|2006


heading:
1702 – Other sugars, including chemically pure lactose, maltose, glucose and fructose, in solid form; sugar syrups not containing added flavouring or colouring matter; artificial honey, whether or not mixed with natural honey; caramel


heading:
1510 – Other oils and their fractions, obtained solely from olives, whether or not refined, but not chemically modified, including blends of these oils or fractions with oils or fractions of heading|1509


heading:
0404 – Whey, whether or not concentrated or containing added sugar or other sweetening matter; products consisting of natural milk constituents, whether or not containing added sugar or other sweetening matter, not elsewhere specified or included


heading:
2001 – Vegetables, fruit, nuts and other edible parts of plants, prepared or preserved by vinegar or acetic acid


heading:
0105 – Live poultry, that is to say, fowls of the species Gallus domesticus, ducks, geese, turkeys and guinea fowls


heading:
3505 – Dextrins and other modified starches (for example, pregelatinised or esterified starches); glues based on starches, or on dextrins or other modified starches


heading:
0309 – Flours, meals and pellets of fish, crustaceans, molluscs and other aquatic invertebrates, fit for human consumption


heading:
2101 – Extracts, essences and concentrates, of coffee, tea or maté and preparations with a basis of these products or with a basis of coffee, tea or maté; roasted chicory and other roasted coffee substitutes, and extracts, essences and concentrates thereof


heading:
3302 – Mixtures of odoriferous substances and mixtures (including alcoholic solutions) with a basis of one or more of these substances, of a kind used as raw materials in industry; other preparations based on odoriferous substances, of a kind used for the manufacture of beverages


heading:
2102 – Yeasts (active or inactive); other single-cell micro-organisms, dead (but not including vaccines of heading|3002); prepared baking powders


heading:
0408 – Birds' eggs, not in shell, and egg yolks, fresh, dried, cooked by steaming or by boiling in water, moulded, frozen or otherwise preserved, whether or not containing added sugar or other sweetening matter


heading:
3502 – Albumins (including concentrates of two or more whey proteins, containing by weight more than 80|% whey proteins, calculated on the dry matter), albuminates and other albumin derivatives


heading:
2207 – Undenatured ethyl alcohol of an alcoholic strength by volume of 80|%|vol or higher; ethyl alcohol and other spirits, denatured, of any strength


heading:
5408 – Woven fabrics of artificial filament yarn, including woven fabrics obtained from materials of heading|5405


heading:
2303 – Residues of starch manufacture and similar residues, beet-pulp, bagasse and other waste of sugar manufacture, brewing or distilling dregs and waste, whether or not in the form of pellets


heading:
0403 – Yogurt; buttermilk, curdled milk and cream, kephir and other fermented or acidified milk and cream, whether or not concentrated or containing added sugar or other sweetening matter or flavoured or containing added fruit, nuts or cocoa


heading:
1903 – Tapioca and substitutes therefor prepared from starch, in the form of flakes, grains, pearls, siftings or similar forms


heading:
2208 – Undenatured ethyl alcohol of an alcoholic strength by volume of less than 80|%|vol; spirits, liqueurs and other spirituous beverages


heading:
3824 – Prepared binders for foundry moulds or cores; chemical products and preparations of the chemical or allied industries (including those consisting of mixtures of natural products), not elsewhere specified or included


heading:
3809 – Finishing agents, dye carriers to accelerate the dyeing or fixing of dyestuffs and other products and preparations (for example, dressings and mordants), of a kind used in the textile, paper, leather or like industries, not elsewhere specified or included


heading:
3920 – Other plates, sheets, film, foil and strip, of plastics, non-cellular and not reinforced, laminated, supported or similarly combined with other materials


heading:
8544 – Insulated (including enamelled or anodised) wire, cable (including coaxial cable) and other insulated electric conductors, whether or not fitted with connectors; optical fibre cables, made up of individually sheathed fibres, whether or not assembled with electric conductors or fitted with connectors


heading:
6103 – Men's or boys' suits, ensembles, jackets, blazers, trousers, bib and brace overalls, breeches and shorts (other than swimwear), knitted or crocheted


heading:
6107 – Men's or boys' underpants, briefs, nightshirts, pyjamas, bathrobes, dressing gowns and similar articles, knitted or crocheted


heading:
6108 – Women's or girls' slips, petticoats, briefs, panties, nightdresses, pyjamas, négligés, bathrobes, dressing gowns and similar articles, knitted or crocheted


heading:
6115 – Pantyhose, tights, stockings, socks and other hosiery, including graduated compression hosiery (for example, stockings for varicose veins) and footwear without applied soles, knitted or crocheted


heading:
6117 – Other made-up clothing accessories, knitted or crocheted; knitted or crocheted parts of garments or of clothing accessories


heading:
6201 – Men's or boys' overcoats, car-coats, capes, cloaks, anoraks (including ski-jackets), wind-cheaters, wind-jackets and similar articles, other than those of heading|6203


heading:
6202 – Women's or girls' overcoats, car-coats, capes, cloaks, anoraks (including ski-jackets), wind-cheaters, wind-jackets and similar articles, other than those of heading|6204


heading:
6203 – Men's or boys' suits, ensembles, jackets, blazers, trousers, bib and brace overalls, breeches and shorts (other than swimwear)


heading:
6204 – Women's or girls' suits, ensembles, jackets, blazers, dresses, skirts, divided skirts, trousers, bib and brace overalls, breeches and shorts (other than swimwear)


heading:
6212 – Brassières, girdles, corsets, braces, suspenders, garters and similar articles and parts thereof, whether or not knitted or crocheted


heading:
6104 – Women's or girls' suits, ensembles, jackets, blazers, dresses, skirts, divided skirts, trousers, bib and brace overalls, breeches and shorts (other than swimwear), knitted or crocheted


heading:
7607 – Aluminium foil (whether or not printed or backed with paper, paperboard, plastics or similar backing materials) of a thickness (excluding any backing) not exceeding 0,2 mm


heading:
6102 – Women's or girls' overcoats, car coats, capes, cloaks, anoraks (including ski jackets), windcheaters, wind-jackets and similar articles, knitted or crocheted, other than those of heading|6104


heading:
6207 – Men's or boys' singlets and other vests, underpants, briefs, nightshirts, pyjamas, bathrobes, dressing gowns and similar articles


heading:
6208 – Women's or girls' singlets and other vests, slips, petticoats, briefs, panties, nightdresses, pyjamas, négligés, bathrobes, dressing gowns and similar articles


heading:
7321 – Stoves, ranges, grates, cookers (including those with subsidiary boilers for central heating), barbecues, braziers, gas rings, plate warmers and similar non-electric domestic appliances, and parts thereof, of iron or steel


heading:
7323 – Table, kitchen or other household articles and parts thereof, of iron or steel; iron or steel wool; pot scourers and scouring or polishing pads, gloves and the like, of iron or steel


heading:
5607 – Twine, cordage, ropes and cables, whether or not plaited or braided and whether or not impregnated, coated, covered or sheathed with rubber or plastics


heading:
5608 – Knotted netting of twine, cordage or rope; made-up fishing nets and other made-up nets, of textile materials


heading:
2006 – Vegetables, fruit, nuts, fruit-peel and other parts of plants, preserved by sugar (drained, glacé or crystallised)


heading:
7208 – Flat-rolled products of iron or non-alloy steel, of a width of 600|mm or more, hot-rolled, not clad, plated or coated


heading:
7211 – Flat-rolled products of iron or non-alloy steel, of a width of less than 600|mm, not clad, plated or coated


heading:
7212 – Flat-rolled products of iron or non-alloy steel, of a width of less than 600|mm, clad, plated or coated


heading:
7209 – Flat-rolled products of iron or non-alloy steel, of a width of 600|mm or more, cold-rolled (cold-reduced), not clad, plated or coated


heading:
7210 – Flat-rolled products of iron or non-alloy steel, of a width of 600|mm or more, clad, plated or coated


heading:
7214 – Other bars and rods of iron or non-alloy steel, not further worked than forged, hot-rolled, hot-drawn or hot-extruded, but including those twisted after rolling


heading:
7228 – Other bars and rods of other alloy steel; angles, shapes and sections, of other alloy steel; hollow drill bars and rods, of alloy or non-alloy steel


heading:
7302 – Railway or tramway track construction material of iron or steel, the following: rails, check-rails and rack rails, switch blades, crossing frogs, point rods and other crossing pieces, sleepers (cross-ties), fish-plates, chairs, chair wedges, sole plates (base plates), rail clips, bedplates, ties and other material specialised for jointing or fixing rails


heading:
7306 – Other tubes, pipes and hollow profiles (for example, open seam or welded, riveted or similarly closed), of iron or steel


heading:
7305 – Other tubes and pipes (for example, welded, riveted or similarly closed), having circular cross-sections, the external diameter of which exceeds 406,4 mm, of iron or steel


heading:
1302 – Vegetable saps and extracts; pectic substances, pectinates and pectates; agar-agar and other mucilages and thickeners, whether or not modified, derived from vegetable products


heading:
2103 – Sauces and preparations therefor; mixed condiments and mixed seasonings; mustard flour and meal and prepared mustard


heading:
2404 – Products containing tobacco, reconstituted tobacco, nicotine, or tobacco or nicotine substitutes, intended for inhalation without combustion; other nicotine containing products intended for the intake of nicotine into the human body


heading:
5205 – Cotton yarn (other than sewing thread), containing 85|% or more by weight of cotton, not put up for retail sale


heading:
5208 – Woven fabrics of cotton, containing 85|% or more by weight of cotton, weighing not more than 200|g/m$2


heading:
5209 – Woven fabrics of cotton, containing 85|% or more by weight of cotton, weighing more than 200|g/m$2


heading:
5402 – Synthetic filament yarn (other than sewing thread), not put up for retail sale, including synthetic monofilament of less than 67|decitex


heading:
5404 – Synthetic monofilament of 67|decitex or more and of which no cross-sectional dimension exceeds 1|mm; strip and the like (for example, artificial straw), of synthetic textile materials, of an apparent width not exceeding 5|mm


heading:
5407 – Woven fabrics of synthetic filament yarn, including woven fabrics obtained from materials of heading|5404


heading:
5513 – Woven fabrics of synthetic staple fibres, containing less than 85|% by weight of such fibres, mixed mainly or solely with cotton, of a weight not exceeding 170|g/m$2


heading:
5806 – Narrow woven fabrics, other than goods of heading|5807; narrow fabrics consisting of warp without weft assembled by means of an adhesive (bolducs)


heading:
5811 – Quilted textile products in the piece, composed of one or more layers of textile materials assembled with padding by stitching or otherwise, other than embroidery of heading|5810


heading:
5903 – Textile fabrics impregnated, coated, covered or laminated with plastics, other than those of heading|5902


heading:
5904 – Linoleum, whether or not cut to shape; floor coverings consisting of a coating or covering applied on a textile backing, whether or not cut to shape


heading:
5907 – Textile fabrics otherwise impregnated, coated or covered; painted canvas being theatrical scenery, studio backcloths or the like


heading:
6004 – Knitted or crocheted fabrics of a width exceeding 30|cm, containing by weight 5|% or more of elastomeric yarn or rubber thread, other than those of heading|6001


heading:
6005 – Warp knit fabrics (including those made on galloon knitting machines), other than those of headings 6001 to 6004


heading:
6306 – Tarpaulins, awnings and sunblinds; tents (including temporary canopies and similar articles); sails for boats, sailboards or landcraft; camping goods


heading:
6101 – Men's or boys' overcoats, car coats, capes, cloaks, anoraks (including ski jackets), windcheaters, wind-jackets and similar articles, knitted or crocheted, other than those of heading|6103


heading:
8703 – Motor cars and other motor vehicles principally designed for the transport of persons (other than those of heading|8702), including station wagons and racing cars


heading:
7610 – Aluminium structures (excluding prefabricated buildings of heading|9406) and parts of structures (for example, bridges and bridge-sections, towers, lattice masts, roofs, roofing frameworks, doors and windows and their frames and thresholds for doors, balustrades, pillars and columns); aluminium plates, rods, profiles, tubes and the like, prepared for use in structures


heading:
7611 – Aluminium reservoirs, tanks, vats and similar containers, for any material (other than compressed or liquefied gas), of a capacity exceeding 300|litres, whether or not lined or heat-insulated, but not fitted with mechanical or thermal equipment


heading:
7612 – Aluminium casks, drums, cans, boxes and similar containers (including rigid or collapsible tubular containers), for any material (other than compressed or liquefied gas), of a capacity not exceeding 300|litres, whether or not lined or heat-insulated, but not fitted with mechanical or thermal equipment


heading:
7615 – Table, kitchen or other household articles and parts thereof, of aluminium; pot scourers and scouring or polishing pads, gloves and the like, of aluminium; sanitary ware and parts thereof, of aluminium


heading:
0209 – Pig fat, free of lean meat, and poultry fat, not rendered or otherwise extracted, fresh, chilled, frozen, salted, in brine, dried or smoked


# _reports

name: quotas_including_current_volumes
script:
SELECT
    q.quota_definition__sid,
    q.quota__order_number,
    (
        SELECT
            group_concat(g.geographical_area, '|')
        FROM
            quota__geographical_areas g
        WHERE
            g.quota_definition__sid = q.quota_definition__sid
        ORDER BY
            g.idx
    ) AS quota__geographical_areas,
    (
        SELECT
            group_concat(h.heading, '|')
        FROM
            quota__headings h
        WHERE
            h.quota_definition__sid = q.quota_definition__sid
        ORDER BY
            h.idx
    ) AS quota__headings,
    (
        SELECT
            group_concat(c.commodity, '|')
        FROM
            quota__commodities c
        WHERE
            c.quota_definition__sid = q.quota_definition__sid
        ORDER BY
            c.idx
    ) AS quota__commodities,
    q.quota__measurement_unit,
    q.quota__monetary_unit,
    q.quota_definition__description,
    q.quota_definition__validity_start_date,
    q.quota_definition__validity_end_date,
    (
        SELECT
            group_concat(s.suspension_period_start || ';' || s.suspension_period_end, '|')
        FROM
            quota_definition__suspension_periods s
        WHERE
            s.quota_definition__sid = q.quota_definition__sid
        ORDER BY
            s.idx
    ) AS quota_definition__suspension_periods,
    (
        SELECT
            group_concat(b.blocking_period_start || ';' || b.blocking_period_end, '|')
        FROM
            quota_definition__blocking_periods b
        WHERE
            b.quota_definition__sid = q.quota_definition__sid
        ORDER BY
            b.idx
    ) AS quota_definition__blocking_periods,
    q.quota_definition__status,
    q.quota_definition__last_allocation_date,
    q.quota_definition__initial_volume,
    q.quota_definition__balance,
    q.quota_definition__fill_rate
FROM
    quotas q
ORDER BY
    q.quota__order_number, q.quota_definition__validity_start_date;


