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)