Chat With Your Database

Show Results Only (Alt+S)

Selected Database:

Edit generated query

Username

Password

No data to show.

Browse the tables and columns for Packtex Live

Filter Tables (Alt+T)

dbo.__EFMigrationsHistory
- MigrationId
- ProductVersion
dbo.AccountManagers
- Email
- Id
- MobileNumber
- Name
- TelephoneNumber
dbo.Addresses
- AddressLine1
- AddressLine2
- AddressLine3
- CountryId
- CustomerId
- CustomerOrderId
- Guid
- Id
- PostalCode
- Remove
- SupplierId
- TownCity
- Type
dbo.AspNetRoleClaims
- ClaimType
- ClaimValue
- Id
- RoleId
dbo.AspNetRoles
- ConcurrencyStamp
- Id
- Name
- NormalizedName
dbo.AspNetUserClaims
- ClaimType
- ClaimValue
- Id
- UserId
dbo.AspNetUserLogins
- LoginProvider
- ProviderDisplayName
- ProviderKey
- UserId
dbo.AspNetUserRoles
- RoleId
- UserId
dbo.AspNetUsers
- AccessFailedCount
- ConcurrencyStamp
- Email
- EmailConfirmed
- Id
- LockoutEnabled
- LockoutEnd
- NormalizedEmail
- NormalizedUserName
- PasswordHash
- PhoneNumber
- PhoneNumberConfirmed
- SecurityStamp
- TwoFactorEnabled
- UserName
dbo.AspNetUserTokens
- LoginProvider
- Name
- UserId
- Value
dbo.Attachment
- ApprovedFile
- AttachToEmail
- ContentType
- CustomerOrderId
- Description
- DocketId
- DocumentUrl
- DTGDesignId
- FashionCoProductId
- FileLabelId
- FileName
- Id
- IncludeInSearch
- IncludeInWebsite
- InspirationNumber
- NewDevelopmentId
- ProcessId
- ProductId
- ProductKeyWordId
- PurchaseOrderId
- SampleOrderId
- ShippedOrderId
- ShowOnBackNeckPrint
- ShowOnCADRef
- ShowOnDocketBack
- ShowOnDocketFront
- ShowOnOrderHistory
- UploadedBy
- UploadedOn
dbo.Categories
- CategoryName
- Description
- Id
- LastUsedNumber
- Prefix
dbo.Colours
- ColourName
- Id
- MaterialId
- ProductTypeId
dbo.CompanyDetails
- AddressLine1
- City
- CompanyName
- Email
- EmailNotificationAddress
- Id
- PhoneNumber
- PostalCode
dbo.CompanyTypes
- CompanyTypeName
- Id
dbo.Contacts
- ContactName
- CustomerId
- Email
- Id
- LinkedToUser
- TelephoneNumber
- Website
dbo.Countries
- CountryCode
- CountryName
- Id
- IddCode
dbo.Courier
- Active
- CourierName
- Description
- Id
- TrackingLink
dbo.CourierItems
- CourierId
- CustomerOrderId
- Id
- ItemDescription
- Quantity
- TrackingNumber
dbo.Currencies
- CurrencyCode
- CurrencyName
- ExchangeRate
- Id
- OldId
dbo.CustomerOrderGarmentSupplyBridges
- CustomerOrderId
- GarmentSupplyId
- Id
dbo.CustomerOrderLines
- Colour
- CustomerOrderId
- Id
- LabelSize
- Printed
- PrintQuantity
- Processed
- ProcessQuantity
- Quantity
- Size
- SortOrder
dbo.CustomerOrders
- AutomaticallyUploadDispatchNotification
- BarcodesLabels
- CompletedBy
- CompletedWhen
- CompletionDate
- ContactId
- Cost
- CreatedBy
- CreatedWhen
- CustomerId
- CustomerOrderReference
- CustomerOrderType
- CustomerReference
- DTGDesignId
- DueDate
- FibreComposition
- GarmentCategoryId
- GarmentColour
- GarmentSupplyId
- GarmentTypeId
- Id
- IndividuallyBoxed
- InternalNotes
- MakeVisibleToDesigner
- ModifiedBy
- ModifiedWhen
- Notes
- OrderDate
- OrderStatus
- PacktexReference
- PantoneReference
- PBSalesInvoiceNumber
- PODate
- Price
- PricePerUnitExcludingVAT
- PrinterId
- PrintType
- SampleApproved
- SampleDate
- Status
- StockStatus
dbo.CustomerQuotes
- CurrencyId
- CustomerId
- EmployeeId
- Freight
- Id
- LastUpdated
- LineNumber
- Notes
- OldId
- Price
- ProductId
- Size
- UpdatedBy
dbo.Customers
- AccountManagerId
- Active
- Code
- CompanyName
- Contact
- CurrencyId
- CustomerType
- Email
- FaxNumber
- Id
- TelephoneNumber
- Website
dbo.CustomersExport
- companyEmail
- companyFax
- companyID
- companyName
- companyPhone
- companyPK
- contactName
- currencyID
- displayName
- url
dbo.DefaultCosts
- CostDescription
- GarmentSupplyId
- Id
- PerUnitCost
- ProcessManagementId
- SortOrder
dbo.Departments
- DepartmentName
- Description
- Id
- OldId
dbo.Designers
- DesignerName
- EmailAddress
- Id
dbo.Dockets
- CustomerOrderId
- DecorMethod
- GarmentColour
- GarmentId
- HowToPack
- Id
- LabelInformation
- PurchaseOrder
- Requested
- Required
- Specifics
- Style
- WhoToPack
dbo.DTGCategory
- CategoryName
- Id
dbo.DTGDesign
- CreatedBy
- CreatedWhen
- CustomerId
- CustomerStyleCode
- Description
- DesignType
- DTGCategoryId
- DTGSubCategoryId
- DTGSubCategoryLicencesId
- Id
- ModifiedBy
- ModifiedWhen
- Notes
dbo.DTGSubCategory
- CategoryType
- Id
- SubCategoryName
dbo.Employees
- CurrentDepartment
- Email
- EmployeeName
- Id
dbo.ExpenseBreakdowns
- Amount
- CostingId
- Description
- Id
- ReferenceNumber
dbo.FashionCoProducts
- ArtworkSize
- CreatedBy
- CreatedWhen
- CustomerDesignInfo
- CustomerId
- DateUploaded
- Description
- DesignerInfo
- GarmentCategory
- GarmentColour
- GarmentSize
- GarmentType
- Id
- ModifiedBy
- ModifiedWhen
- ProductCode
- Status
dbo.FileLabels
- Id
- Label
dbo.GarmentCategories
- GarmentCategoryName
- Id
dbo.GarmentSupplies
- GarmentSupplyName
- Id
dbo.GarmentTypes
- GarmentTypeName
- Id
dbo.GeneralLookUps
- Category
- Description
- Id
- ItemValue
- SortOrder
dbo.Invoices
- Id
- IssuedOn
- SupplierId
dbo.LatestFilters
- ActionName
- ControllerName
- CreatedWhen
- FilterValue
- Id
- SearchValue
- Username
dbo.Materials
- Id
- MaterialName
dbo.NewDevelopments
- CategoryId
- Comments
- CompletedOn
- Composition
- CoreldrawFile
- CustomerId
- Description
- DesignerId
- DueDate
- EmployeeId
- Id
- InputDate
- JpegFile
- JpegOnBlackBackground
- JPEGOnPlainWhiteBackground
- MouldFile
- OldId
- PriorityId
- ProductDevCode
- ProductKeywordId
- PxNumber
- Requirement
- StartDate
- Status
- SupplierId
dbo.OrderTypes
- Id
- OrderTypeName
dbo.PaymentMethods
- Id
- PaymentMethodName
dbo.PriceQuotes
- CurrencyId
- DevelopReference
- Final
- Id
- LastUpdated
- LooseMaterialCost
- PaperCost
- PaperQuality
- PaperSize
- ProductId
- SizeId
- Total
dbo.Printers
- Id
- PrinterName
dbo.Priorities
- Id
- PriorityName
- SortOrder
dbo.Process
- Completed
- CustomerId
- CustomerOrderId
- DTGDesignId
- Id
- OrderBy
- ProcessManagementId
- ProcessName
- ProcessType
- ToBeApplied
dbo.ProcessCost
- CostDescription
- CustomerOrderId
- GarmentSupplyId
- Id
- PerUnitCost
- PerUnitSales
- ProcessId
- Quantity
- SortOrder
- TotalCost
dbo.ProcessManagement
- Colour
- DefaultProcessCapacity
- DepartmentName
- Id
- IncludeOnDashboard
- ProcessName
- ProcessOrder
- StatusToBeSet
dbo.ProductColours
- Colour
- Id
dbo.ProductCostValues
- DutyRate
- ExchangeRate
- Id
- MinimumProfitRate
- ShippingCost
- ValidFrom
- ValidUntil
dbo.ProductionCapacities
- Actual
- Capacity
- Cost
- Id
- Month
- ProcessManagementId
- Year
dbo.ProductKeywords
- Id
- ProductKeywordName
dbo.Products
- CategoryId
- ColourId
- Composition
- CreatedBy
- CreatedWhen
- CurrencyId
- CustomerId
- CustomerReference
- DateCreated
- Description
- DesignerId
- Id
- MaterialId
- ModifiedBy
- ModifiedWhen
- MouldStatus
- NewDevelopmentId
- Notes
- OldId
- PaymentMethodId
- Price
- ProductCostValueId
- ProductDevFK
- ProductKeywordId
- ReferenceNumber
- Requirement
- Sample
- ShippingMethodId
- ShipToId
- SizeId
- Status
- SupplierId
- TrimsCategoryId
- TrimsSubCategoryId
- UnitId
- Visual
dbo.ProductSizes
- Colour
- Id
- OldId
- Size
dbo.ProductTypes
- Id
- ProductTypeName
dbo.PurchaseOrderLines
- Colour
- CustomerOrderId
- Id
- LineNumber
- Notes
- OldId
- ProductId
- PurchaseOrderId
- Quantity
- SellPrice
- Size
- SupplierUnitPrice
- UnitId
dbo.PurchaseOrders
- CurrencyId
- CustomerDeliveryAddress
- CustomerDeliveryDate
- CustomerExchangeRate
- CustomerId
- CustomerPONumber
- DepartmentId
- DispatchDate
- EmployeeId
- ExchangeRate
- Id
- IssuedOn
- Notes
- OldDepartment
- OldId
- PurchaseOrderNumber
- SellCurrencyId
- ShipToId
- Status
- SupplierId
- TradeTerm
dbo.ReturnLocations
- ActionName
- ControllerName
- CreatedWhen
- Id
- Username
dbo.SampleOrderLines
- Colour
- Cost
- CustomerOrderId
- Id
- LineNumber
- Note
- ProductId
- Quantity
- QuantitySent
- SampleOrderId
- SamplingCost
- Size
- UnitId
- UnitSent
- Weight
dbo.SampleOrders
- CompletedOn
- CustomerId
- CustomerReferenceNumber
- EmployeeId
- Id
- IssuedOn
- Notes
- OrderTypeId
- PriorityId
- ShipmentMethodId
- ShipToId
- Status
- SupplierId
- ToBeReadyOn
dbo.ShipmentMethods
- Id
- ShipmentMethodName
dbo.ShippedAmounts
- Id
- InvoiceId
- PurchaseOrderLineId
- QuantityShipped
- ShippedDate
- ShippedOrderId
dbo.ShippedOrders
- AirwayBill
- AirwayBillNumber
- CartonTotal
- ClearanceCostDocUploaded
- ClearingAgent
- CourierCharge
- DispatchDate
- Id
- IssuedOn
- ReferenceNumber
- ShipmentMethodId
- ShippingCompany
- ShippingCostDocUploaded
- Status
- SupplierId
- SupplierInvoiceUploaded
- ValueAddedTax
- VatDocUpload
- WeightTotalKgs
dbo.ShippingMethods
- Id
- ShippingMethodName
dbo.ShipTos
- Id
- ShipToName
dbo.SizeAndColours
- Colour
- Id
- NewDevelopmentId
- ProductId
- Size
dbo.Sizes
- Id
- MaterialId
- ProductTypeId
- SizeName
dbo.SupplierQuotes
- Colour
- Cost
- CurrencyId
- ExchangeRate
- Id
- LastUpdated
- LineNumber
- MaximumOrderQuantity
- MinimumOrderQuantity
- Notes
- OldId
- PaperSize
- Price
- Priority
- ProductId
- ProductSizeId
- SupplierId
- SupplierItemNumber
- UnitId
- Weight
dbo.Suppliers
- AccountManagerId
- Active
- Code
- CompanyName
- CompanyTypeId
- Contact
- CurrencyId
- Email
- FaxNumber
- Id
- Notes
- TelephoneNumber
- Website
dbo.SuppliersExport
- companyEmail
- companyFax
- companyID
- companyName
- companyPhone
- companyPK
- contactName
- currencyID
- displayName
- english
- url
dbo.SystemSettings
- AutomaticallyCreatePdf
- EmailFrom
- EmailHost
- EmailPort
- Id
- Office365Password
- Office365Username
- Website
dbo.TrimsCategories
- Active
- Category
- Id
dbo.TrimsSubCategories
- Id
- SubCategory
- TrimsCategoryId
dbo.Units
- Id
- OldId
- QuantityPerUnit
- UnitName
- UnitNamePlural