GM-EU

Tables (6)

Customer

  • Customer_ID — INT — Primary key — NOT NULL
  • Distributor Country ISO (CountryISO) — NVARCHAR(3) — Primary key — NOT NULL
  • First Name (FirstName) — NVARCHAR(30)
  • Last Name (LastName) — NVARCHAR(30)
  • Category(department) (Category) — NVARCHAR(20)
  • Billing Country (Bill_Country) — NVARCHAR(30)
  • Billing Postcode (Bill_Postcode) — NVARCHAR(15)
  • Billing City (Bill_City) — NVARCHAR(20)
  • Billing Street (Bill_Street) — NVARCHAR(50)
  • Company Name (Company) — NVARCHAR(50)
  • Email — NVARCHAR(100)
  • Mobile — NVARCHAR(15)
  • ContactPerson — NVARCHAR(40)
  • ID — NVARCHAR(50)
  • PW — varbinary(MAX)
  • Creation Date (CreatedDate) — datetime2(7)
  • ExactAPI (Apikey) — NVARCHAR(1000)

Delivery information (Delivery)

  • Delivery ID (DeliveryID) — INT — Primary key — NOT NULL
  • Country (Deli_Country) — NVARHAR(30)
  • Post code (Deli_Postcode) — NVARCHAR(15)
  • City (Deli_City) — NVARCHAR(20)
  • Street (Deli_Street) — NVARCHAR(50)
  • Contact (Deli_contact) — NVARCHAR(20)
  • CompanyName (Deli_Company) — NVARCHAR(50)
  • Email (Deli_Email) — NVARCHAR(100)
  • Mobile (Deli_Mobile) — NVARCHAR(15)
  • Incoterms — NVARCHAR(4)
  • Shipping Method (Method) — NVARCHAR(10)

Device_Price (Mapping_Device_Price)

  • ERP Code (ERP_Code) — NVARCHAR(20) — Foreign key → Items.ERP Code — NOT NULL
  • Distributor Country ISO (CountryISO) — NVARCHAR(3) — Foreign key → Customer.Distributor Country ISO — NOT NULL
  • Price in [1,6,12,18,24,30] (Price_Series) — NVARCHAR(100)

Items

  • ERP Code (ERP_Code) — NVARCHAR(20) — Primary key — NOT NULL
  • Price — decimal(32,2) — Primary key
  • Category — NVARCHAR(10) — Primary key — NOT NULL
  • Name (Item_Name) — NVARCHAR(100)
  • Dimension Length (Dimension_L) — INT
  • Dimension Width (Dimension_W) — INT
  • Dimension Height (Dimension_H) — INT
  • stock (Stock) — INT
  • Device picture (Pic_url) — NVARCHAR(1000)
  • Weight — decimal(32, 2)

Order Items (Order_Items)

  • ID — INT — Primary key — NOT NULL
  • OrderID — INT — Foreign key → Order information.OrderID — NOT NULL
  • Unit Price Received (UnitPrice) — Decimal(32,2)
  • Unit Price Discounted (Discounted) — Decimal(32,2)
  • ERP Code (ERP_Code) — NVARCHAR(20) — Foreign key → Items.ERP Code — NOT NULL
  • Price — decimal(32,2) — Foreign key → Items.Price
  • Quantity — INT
  • Key — Foreign key → Items.Category — NOT NULL

Order information (Order)

  • OrderID — INT — Primary key — NOT NULL
  • Delivery ID (DeliveryID) — INT — Foreign key → Delivery information.Delivery ID — NOT NULL
  • Payment Terms (PaymentTerm) — NVARCHAR(30)
  • CreatedDate — datetime2(7)
  • Approved Logistics (ApprovedLo) — bit
  • Approved Sales (ApprovedSa) — bit
  • Approved Cusomter (ApprovedCu) — bit
  • PaymentTerms (Paymentterms) — NVARCHAR(20)
  • Customer_ID — INT — Foreign key → Customer.Customer_ID — NOT NULL
  • TotalPrice — numeric(32, 2)
  • TotalDiscount — nemeric(32,2)
  • ShippingCost — Decimal(32,2)
  • Remark — NVARCHAR(MAX)