Database diagram

Dependency diagram for the CSV output format, including SQL scripts for generating the tables and to load the data with load data local infile at the end of this article.

Overview of data format elements

In CSV output format, these elements are files, in XML or JSON output format these are nodes.

The data format standardUpdate consists of the following elements:

  • Product: product from the ITscope catalogue.
  • SupplierItem: source of supply for an ITscope product. A specific product offering from a distributor listed on ITscope.
  • Project: price, availability and further information on a project item.

Elements marked with a    vary depending on the selected export language.

product

Product from the ITscope catalogue.

Name Compulsory field Data type Description
puid   long Unique key
price   BigDecimal Price basis for the calculated price
priceCalc   BigDecimal Calculated price, based on the individual price calculation
currencyCode   String (3) Currency unit that applies to this price information
priceCalcVat   BigDecimal Sales tax rate that was used to determine the calculated price
priceLastUpdate   Date Time of last update of price information
priceSupplierId   long Reference to a supplier (1:1) who has provided the source of supply with this price information
priceSupplierName   String (255) Name of the supplier that provided this source of supply
priceSupplierItemId   long Reference to a source of supply (n:1); if this field is zero, then the price information refers to a product (source of supply reference and product reference are mutually exclusive)
priceSupplierSKU   String (40) Product identifier given by the supplier that provided this source of supply
stockSupplierText   String (40) Textual inventory information of the supplier, directly taken over, without interpretation
stockStatus   Integer Numeric key of the delivery status of the inventory information
 stockStatusText   String (255) Delivery status of inventory information, such as 'in stock' or 'in field warehouse'
stock   Integer Quantity of products for the delivery status indicated in this structure
externalStock   Integer External stock (additional information provided by some suppliers in structures with 'in stock' delivery status)
incomingStock   Integer Stock quantity that will be replenished (additional information provided by some suppliers in structures with 'in stock' delivery status)
stockAvailabilityDate   Date Delivery date for products that are not in stock
stockLastUpdate   Date Time of last update of inventory information
aggregatedStatus Yes Integer Best availability status
 aggregatedStatusText Yes String (20) Best availability status
aggregatedStock Yes Integer Sum of all stock levels
aggregatedSupplierItems Yes Integer Sum of all distributors offering this product
 supplierItem Yes List <supplierItem> Source of supply of an ITscope product. A specific offer from a distributor listed on ITscope.

supplierItem

Source of supply for an ITscope product. A specific offering from a distributor listed on ITscope.

Name Compulsory field Data type Description
id Yes long Unique key
supplierSKU   String (40) Product number of the supplier
supplierId Yes long Refers 1:1 to Supplier.id
supplierName   String (255) Name of Supplier
price Yes BigDecimal Price
priceCalc Yes BigDecimal Calculated price, based on the individual price calculation
currencyCode Yes String (3) Currency unit that applies to this price information
priceCalcVat Yes BigDecimal Sales tax rate that was used to determine the calculated price
priceLastUpdate Yes Date Time of last update of price information
stockSupplierText   String Stock information on the source of supply, as given by the supplier
stockStatus   Integer Numeric key for the delivery status of the inventory information
 stockStatusText   String (255) Delivery status of inventory information, such as 'in stock' or 'in field warehouse'
stock   Integer Stock level
externalStock   Integer External stock (additional information provided by some suppliers in structures with 'in stock' delivery status)
incomingStock   Integer Stock quantity that will be replenished (additional information provided by some suppliers in structures with 'in stock' delivery status)
stockAvailabilityDate   Date Delivery date for products that are not in stock
lastStockUpdate   Date Time of last update of inventory information

project

Price, availability and further information on a project agreement.

name Compulsory field Data type description
supplierProjectId   String (40) Project number of the supplier
manufacturerProjectId Yes String (40) Project number of the manufacturer (unique key)
price Yes BigDecimal Project price
remainingQuantity Yes Integer Remaining quota that can be ordered
projectLastUpdate   Date Time of last update of project information



Database scripts for CSV

Note: This page has been translated with the Google Translation Service.

Have more questions? Submit a request