Database diagram

Abhängigkeitsdiagram the csv output format, including SQL scripts for generating the tables and to load the data with loadData local infile at the end of the contribution.

Overview of data format elements

In csv output format, these elements are files, in xml or json output format it is nodes.

The data format standard consists of the following elements:

  • Product: - Product of the ITscope catalog.
  • SupplierItem: - Reference source of an ITscope product. A specific offer from an ITScope listed distributor.

product

Product of the ITscope catalog.

name Compulsory field Data type description
puid Yes long Unique key
price Yes BigDecimal Price based on the closing price
priceCalc Yes BigDecimal Calculated price, based on the individual pricing
currencyCode Yes String (3) Currency unit that applies to this price information
priceCalcVat Yes BigDecimal Sales tax rate to calculate the calculated price was used
priceLastUpdate Yes Date Time of last update of price information
in the present circumstancesHier, an Yes long Reference to a supplier (1: 1) who has provided the source with this price information
priceSupplierName Yes String (255) Name of the supplier who provided this reference source
priceSupplierItemId Yes long Reference to a reference source (n: 1); If this field is zero, the price information refers to a product (reference source reference and product reference are mutually exclusive)
in the present circumstancesHier, an Yes String (40) Product identifier of the supplier who provided this reference source
stockSupplierText   String (40) Textual inventory information of the supplier, directly taken over, without interpretation
stockStatus Yes Integer Numeric key of the delivery status of the inventory information
stockStatusText Yes String (255) Delivery status of inventory information , such as "in stock" or "outdoor storage"
floor Yes Integer Quantity of the delivery status indicated in this structure
externalStock   Integer External stock in stock (additional information from suppliers in structures of delivery status "in stock")
incomingStock   Integer Quantity in stock (additional information from some suppliers in delivery status "in stock")
stockAvailabilityDate   Date Delivery date for goods not in stock
stockLastUpdate Yes Date Time of last update of inventory information
aggregatedStatus Yes Integer Best availability status
aggregatedStatusText Yes String (20) Best availability status
aggregatedStock Yes Integer Total of all inventories
aggregatedSupplierItems Yes Integer Sum of all distributors to this product
supplierItem Yes List <supplierItem> Reference source of an ITscope product. A specific offer from an ITScope listed distributor.

supplierItem

Reference source of an ITscope product. A specific offer from an ITScope listed distributor.

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 pricing
currencyCode Yes String (3) Currency unit that applies to this price information
priceCalcVat Yes BigDecimal Sales tax rate to calculate the calculated price was used
priceLastUpdate Yes Date Time of last update of price information
stockSupplierText   String Stock information on the source of supply, as supplied by the supplier
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 "outdoor storage"
floor   Integer stock quantity
externalStock   Integer External stock in stock (additional information from suppliers in structures of delivery status "in stock")
incomingStock   Integer Quantity in stock (additional information from some suppliers in delivery status "in stock")
stockAvailabilityDate   Date Delivery date for goods not in stock
lastStockUpdate   Date Time of last update of inventory information

Database scripts for CSV

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

Have more questions? Submit a request