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.
  • Project: - Price, availability and further information on a project agreement.

product

Product of the ITscope catalog.

name Compulsory field Data type description
puid   long Unique key
price   BigDecimal Price based on the closing price
priceCalc   BigDecimal Calculated price, based on the individual pricing
currencyCode   String (3) Currency unit that applies to this price information
priceCalcVat   BigDecimal Sales tax rate to calculate the calculated price was used
priceLastUpdate   Date Time of last update of price information
priceSupplierId   long Reference to a supplier (1: 1) who has provided the source with this price information
priceSupplierName   String (255) Name of the supplier who provided this reference source
priceSupplierItemId   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)
priceSupplierSKU   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   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"
stock   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   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"
stock   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

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