Query Application schemas
The Application Namespace in Norce Commerce Query has the entities and methods of all the different settings for the client and application. This data can preferrably be cached for longer times.
ApplicationCountry
A country that are enabled for shopping from the applicationid from the header.
ApplicationId. Key property.
CountryId. Key property.
IsPrimary.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
ApplicationCulture
A language that are enabled from the applicationid from the header.
ApplicationId. Key property.
CultureCode. MaxLength: 16. Key property.
IsPrimary.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
ApplicationPriceList
A price list that are enabled for the applicationid from the header.
ApplicationId. Key property.
PriceListId. Nullable. Key property.
IsPrimary.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
IsEditable.
ClientId. Nullable.
IsFavorite.
ApplicationRole
A role that can be used on the customer account.
Id. Key property.
ApplicationId. Nullable.
ClientId. Nullable.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. MaxLength: 500. Nullable.
ReplacesApplicationRoleId. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
IsDefault.
Code. MaxLength: 50. Nullable.
Cultures.
ApplicationRoleCulture
The language specific fields for the roles.
ApplicationRoleId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 50. Nullable.
Description. MaxLength: 500. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
ApplicationSalesArea
A sales area (VAT region) from the applicationid from the header.
ApplicationId. Key property.
SalesAreaId. Key property.
IsPrimary.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
Category
A category on the client.
Id. Key property.
ClientId.
Code. MaxLength: 50. Nullable.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. Nullable.
DefaultSynonyms. MaxLength: 500. Nullable.
DefaultImagePath. MaxLength: 255. Nullable.
UnspcCode. MaxLength: 50. Nullable.
BusinessArea. MaxLength: 50. Nullable.
DefaultCommodityCode. MaxLength: 50. Nullable.
DefaultIntegrationPartNo. MaxLength: 50. Nullable.
DefaultTrackingCodeTypeId. Nullable.
FreightClassId. Nullable.
DefaultGrossWeight. Nullable.
DefaultNetWeight. Nullable.
DefaultUnitOfMeasurementId. Nullable.
DefaultPackageId. Nullable.
DefaultIsReturnable. Nullable.
DefaultIsDropShipOnly. Nullable.
InsuranceCurrencyId. Nullable.
InsuranceStartPrice. Nullable.
InsuranceRunningPercentage. Nullable.
PopulationRuleId.
HideInTopList.
PhoneNumber. MaxLength: 255. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
CompetitivePricingMinPercentage. Nullable.
CompetitivePricingTargetPercentage. Nullable.
DefaultVariantGroupId. Nullable.
DefaultRecommendedSalesQty. Nullable.
ImageKey. Nullable.
DefaultFullName. MaxLength: 500. Nullable.
StructureSortOrder. Nullable.
DefaultStockDisplayBreakPoint. Nullable.
DefaultIsRecommendedSalesQtyFixed. Nullable.
DefaultIsRecurringOrderable. Nullable.
Cultures.
SalesAreas.
Parametrics.
CategoryCulture
The language specific fields for the category.
CategoryId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 50. Nullable.
Description. Nullable.
Synonyms. MaxLength: 500. Nullable.
ImagePath. MaxLength: 255. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
FullName. MaxLength: 500. Nullable.
ImageKey. Nullable.
ClientId. Nullable.
CategoryHierarchy
A parent-child category relation.
CategoryId. Nullable. Key property.
ParentCategoryId. Key property.
Hierarchy. Key property.
CategoryParametric
A parametric relations to a category.
CategoryId. Key property.
ParametricId. Key property.
ClientId.
GroupId. Nullable.
SortOrder. Nullable.
FocusSortOrder. Nullable.
IsSecondary.
IsRequired. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
PrioritySortOrder. Nullable.
CategorySalesArea
A sales area (VAT region) relation to a category (if not set default on application is used).
CategoryId. Key property.
SalesAreaId. Key property.
ClientId.
VatCodeId.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
CategoryStructure
Not used. All categories are same structure.
Id. Key property.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. MaxLength: 500. Nullable.
TypeId.
IsPrimary.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Items.
CategoryStructureItem
Parent and child information on the category.
Id. Key property.
StructureId.
UseCategoryName.
CategoryId. Nullable.
StructureLevel.
ParentItemId. Nullable.
IsParent.
IsDisplayOnly.
SortOrder.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Key.
ClientCulture
The language specific fields for the clients.
CultureCode. MaxLength: 16. Key property.
ClientId.
IsPrimary.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Collation. MaxLength: 128. Nullable.
ClientDivision
A physical store.
Id. Key property.
ClientId.
DivisionCode. MaxLength: 50. Nullable.
DefaultName. MaxLength: 50. Nullable.
DefaultGroupName. MaxLength: 50. Nullable.
DefaultSubGroupName. MaxLength: 50. Nullable.
DefaultDescription. Nullable.
DefaultImagePath. MaxLength: 255. Nullable.
IsPublic.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Key.
ImageKey. Nullable.
DefaultUniqueUrlName. MaxLength: 100. Nullable.
Latitude. Nullable.
Longitude. Nullable.
EmailAddress. MaxLength: 255. Nullable.
PhoneNumber. MaxLength: 50. Nullable.
FaxNumber. MaxLength: 50. Nullable.
AddressLine1. MaxLength: 255. Nullable.
AddressLine2. MaxLength: 255. Nullable.
ZipCode. MaxLength: 50. Nullable.
City. MaxLength: 50. Nullable.
Region. MaxLength: 100. Nullable.
CountryId. Nullable.
OpenHoursWeekday. MaxLength: 255. Nullable.
OpenHoursSaturday. MaxLength: 255. Nullable.
OpenHoursSunday. MaxLength: 255. Nullable.
Applications.
Infos.
PriceLists.
Warehouses.
Cultures.
ClientDivisionApplication
Store- application relation
DivisionId. Key property.
ApplicationId. Key property.
Created.
CreatedBy.
ClientId. Nullable.
ClientDivisionCulture
The language specific text on a physical store.
DivisionId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 50. Nullable.
GroupName. MaxLength: 50. Nullable.
SubGroupName. MaxLength: 50. Nullable.
Description. Nullable.
ImagePath. MaxLength: 255. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
UniqueUrlName. MaxLength: 100. Nullable.
IsUniqueUrlNameManuallyMaintained.
ImageKey. Nullable.
ClientId. Nullable.
ClientDivisionInfo
Extra field information on the physical store.
DivisionId. Key property.
TypeId. Key property.
Id.
Value. Nullable.
Updated.
UpdatedBy.
ClientId. Nullable.
ClientDivisionPriceList
Price list related to a physical store.
DivisionId. Key property.
PriceListId. Key property.
Created.
CreatedBy.
ClientId. Nullable.
ClientDivisionWarehouse
Warehouse related to physical store.
DivisionId. Key property.
ClientId. Key property.
WarehouseId. Key property.
Created.
CreatedBy.
Locations.
ClientDivisionWarehouseLocation
Location related to physical store and warehouse.
DivisionId. Key property.
ClientId. Key property.
WarehouseId. Key property.
LocationId. Key property.
Created.
CreatedBy.
ClientManufacturer
A Manufacturer.
ManufacturerId. Nullable. Key property.
ClientId.
ManufacturerCode. MaxLength: 50. Nullable.
Name. MaxLength: 100. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
UniqueUrlName. MaxLength: 255. Nullable.
IsUniqueUrlNameManuallyMaintained.
ClientSalesArea
A sales area (VAT region).
SalesAreaId. Key property.
ClientId.
IsPrimary.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Code. MaxLength: 50. Nullable.
ClientSalesAreaVatCode. Nullable.
ClientSupplier
A supplier.
SupplierId. Nullable. Key property.
ClientId.
SupplierCodePrefix. MaxLength: 10. Nullable.
SupplierCode. MaxLength: 50. Nullable.
Name. MaxLength: 100. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Warehouses.
WarehouseLocations.
Infos.
ClientSupplierInfo
Additional client speific information on the supplier, like dropshipping or penalty charges.
SupplierId. Key property.
Id.
TypeId.
Value. Nullable.
Updated.
UpdatedBy.
ClientId.
ClientSupplierWarehouse
Warehouse related to suppliers.
SupplierId. Key property.
WarehouseId. Key property.
ClientId.
Name. MaxLength: 50. Nullable.
StandardLeadTimeDayCount. Nullable.
MinimumOrderValue. Nullable.
MinimumOrderValueCost. Nullable.
FreightCost. Nullable.
CostBlock. Nullable.
IsConsignment. Nullable.
IncludeInStockCalculation.
TransferMethodId. Nullable.
TransferMethodValue. MaxLength: 255. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
ClientSupplierWarehouseLocation
Location related to supplier and warehouse.
SupplierId. Key property.
WarehouseId. Key property.
LocationId. Key property.
ClientId.
Name. MaxLength: 50. Nullable.
StandardLeadTimeDayCount. Nullable.
MinimumOrderValue. Nullable.
MinimumOrderValueCost. Nullable.
FreightCost. Nullable.
CostBlock. Nullable.
IsConsignment. Nullable.
IncludeInStockCalculation. Nullable.
TransferMethodId. Nullable.
TransferMethodValue. MaxLength: 255. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
SupportsReservation.
SupportsStockQuery.
ClientWarehouse
A warehouse.
WarehouseId. Key property.
ClientId.
TypeId.
Code. MaxLength: 50. Nullable.
Name. MaxLength: 50. Nullable.
IsStandard.
StandardLeadTimeDayCount. Nullable.
FreightCost. Nullable.
CostBlock. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Locations.
ClientWarehouseLocation
Location related to a warehouse.
WarehouseId. Key property.
LocationId. Key property.
ClientId.
Code. MaxLength: 50. Nullable.
Name. MaxLength: 50. Nullable.
IsStandard.
IsIncludedInStockCalculation.
StandardLeadTimeDayCount. Nullable.
FreightCost. Nullable.
UpToDateTypeId.
CostBlock. Nullable.
ValueBT. MaxLength: 100. Nullable.
PrimaryPriceListId. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
SupportsReservation.
SupportsStockQuery.
Corporation
An organisation, that can be a supplier or a manufacturer.
Id. Key property.
Key.
OrganizationNo. MaxLength: 50. Nullable.
DefaultName. MaxLength: 100. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Suppliers.
Manufacturers.
CurrencyClient
Currency enabled for a client with the current exchange rate.
CurrencyId. Key property.
ClientId.
ExchangeRate. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
IsPrimary.
ThresholdPercent. Nullable.
Schedule. MaxLength: 1000. Nullable.
CustomerInfoType
Extra field on different entities. The groups are: Customer info (1), Application info (2), Division / Store info (4), Company info (6), Supplier info (7).
Id. Key property.
ClientId.
GroupId.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. MaxLength: 500. Nullable.
SortOrder.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Code. MaxLength: 50. Nullable.
Cultures.
CustomerInfoTypeCulture
The language specific text on extra fields.
TypeId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 50. Nullable.
Description. MaxLength: 500. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
Family
A product family.
Id. Key property.
ClientId.
Code. MaxLength: 50. Nullable.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. Nullable.
DefaultImagePath. MaxLength: 255. Nullable.
DefaultThumbnailImagePath. MaxLength: 255. Nullable.
DefaultCampaignImagePath. MaxLength: 255. Nullable.
DefaultLargeImagePath. MaxLength: 255. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
ImageKey. Nullable.
Cultures.
FamilyCulture
The language specific text on product family.
FamilyId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 50. Nullable.
Description. Nullable.
ImagePath. MaxLength: 255. Nullable.
ThumbnailImagePath. MaxLength: 255. Nullable.
CampaignImagePath. MaxLength: 255. Nullable.
LargeImagePath. MaxLength: 255. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ImageKey. Nullable.
ClientId. Nullable.
FileInfo
File type information, like code and id.
FileId. Key property.
ClientId.
Code. MaxLength: 50. Nullable.
SortOrder. Nullable.
Updated.
UpdatedBy.
Manufacturer
A manufacturer, with the corporation relation.
Id. Key property.
CorporationId. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Key.
ClientManufacturers.
ManufacturerInfo
Additional client speific information on the manufacturer.
ManufacturerId. Key property.
ClientId.
Prefix. MaxLength: 50. Nullable.
Website. MaxLength: 255. Nullable.
LogoPath. MaxLength: 255. Nullable.
AssortmentId. Nullable.
PopulationRuleId.
DefaultSupportUrl. MaxLength: 255. Nullable.
DefaultSupportEmailAddress. MaxLength: 255. Nullable.
DefaultSupportPhoneNumber. MaxLength: 500. Nullable.
DefaultSupportAvailableHours. Nullable.
DefaultSupportPolicy. Nullable.
DefaultSupportDescription. Nullable.
DefaultInternalSupportUrl. MaxLength: 255. Nullable.
DefaultInternalSupportEmailAddress. MaxLength: 255. Nullable.
DefaultInternalSupportPhoneNumber. MaxLength: 500. Nullable.
DefaultInternalSupportAvailableHours. Nullable.
DefaultInternalSupportPolicy. Nullable.
DefaultInternalSupportDescription. Nullable.
Alias. MaxLength: 255. Nullable.
DefaultTitle. MaxLength: 255. Nullable.
DefaultTags. Nullable.
DefaultMetaTags. Nullable.
DefaultMetaDescription. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
LogoKey. Nullable.
OrderInfoType
Use Shopping info type instead.
Id. Key property.
ClientId.
ApplicationId.
Code. MaxLength: 50. Nullable.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. MaxLength: 500. Nullable.
SortOrder. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
GroupId.
Cultures.
OrderInfoTypeCulture
The language specific text on extra fields.
TypeId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 50. Nullable.
Description. MaxLength: 500. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
Parametric
Parametric with default information and more.
Id. Key property.
ClientId.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. MaxLength: 500. Nullable.
DefaultUom. MaxLength: 50. Nullable.
TypeId.
HasListValues.
HasMultipleValues.
IsVariantType.
IsRequired.
IsHidden.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Code. MaxLength: 50. Nullable.
CodeListKey. MaxLength: 50. Nullable.
IsReadOnly.
Editor. MaxLength: 16. Nullable.
IsFavorite.
IsPublic.
GroupId. Nullable.
DefaultIsVariantUnique.
ShowOnTextTab.
ShowInList.
Cultures.
ParametricCulture
The language specific text on parametrics.
ParametricId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 50. Nullable.
Description. MaxLength: 500. Nullable.
Uom. MaxLength: 50. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
ParametricList
List items for parametrics of type list.
Id. Key property.
ParametricId.
DefaultVarcharValue. MaxLength: 255. Nullable.
DefaultDescription. Nullable.
SortOrder. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Code. MaxLength: 50. Nullable.
ImageKey. Nullable.
ImagePath. MaxLength: 255. Nullable.
ClientId. Nullable.
Cultures.
ParametricListCulture
The language specific text on parametrics list items.
ListId. Key property.
CultureCode. MaxLength: 16. Key property.
VarcharValue. MaxLength: 255. Nullable.
Description. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
ParametricMultiple
List items for parametrics of type multiple list.
Id. Key property.
ParametricId.
DefaultValue. MaxLength: 255. Nullable.
DefaultDescription. Nullable.
SortOrder. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Code. MaxLength: 50. Nullable.
ImageKey. Nullable.
ImagePath. MaxLength: 255. Nullable.
ClientId. Nullable.
Cultures.
ParametricMultipleCulture
The language specific text on parametrics multiple list items.
MultipleId. Key property.
CultureCode. MaxLength: 16. Key property.
Value. MaxLength: 255. Nullable.
Description. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
PriceList
A price list, see PriceListClient for client specific information.
Id. Key property.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. Nullable.
Agreement. MaxLength: 50. Nullable.
StartDate. Nullable.
EndDate. Nullable.
IsPublic.
IsLimitedToStock.
IsBid.
IsStako.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
PriceListClient
A price list, with information like code (agreement), start and end date, parent, salesarea and more.
PriceListId. Nullable. Key property.
ClientId.
Name. MaxLength: 50. Nullable.
Description. Nullable.
ImagePath. MaxLength: 255. Nullable.
Agreement. MaxLength: 50. Nullable.
StartDate. Nullable.
EndDate. Nullable.
CurrencyId.
DefaultPriceRuleId. Nullable.
DefaultPriceRuleValue. Nullable.
DefaultSupplementChargePercentage.
DefaultKickbackPercentage. Nullable.
DefaultMinimumProductMarginPercentage. Nullable.
ParentPriceListId. Nullable.
PopulationRuleId.
ChosenWarehouseId. Nullable.
ChosenLocationId. Nullable.
IsErpUpdateable.
IsErpIntegrated.
IsPrimary.
IsPublic. Nullable.
IsLimitedToStock. Nullable.
IsBid. Nullable.
IsStako. Nullable.
IsActive.
StoppedDate. Nullable.
StoppedBy. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
ImageKey. Nullable.
TypeId.
ImageExtension. MaxLength: 16. Nullable.
DefaultSupplementCharge. Nullable.
DefaultLimitToPriceRecommended. Nullable.
IsVirtual.
SalesAreaId. Nullable.
InheritStructureCalculationRule.
ProductFlag
A product flag. Types are Product flag (1), Variant flag (2).
Id. Key property.
ClientId.
TypeId.
GroupId.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. MaxLength: 500. Nullable.
IsManuallyEditable.
SortOrder. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Code. MaxLength: 50. Nullable.
Cultures.
ProductFlagCulture
The language specific text on Product flag.
FlagId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 50. Nullable.
Description. MaxLength: 500. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
ProductFlagGroup
A product flag group.
Id. Key property.
ClientId.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. MaxLength: 500. Nullable.
IsMultipleChoice.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
IsDisplay.
IsFavorite.
Code. MaxLength: 50. Nullable.
Cultures.
ProductFlagGroupCulture
The language specific text on Product flag group.
GroupId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 50. Nullable.
Description. MaxLength: 500. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
ProductInfoType
Extra field on different product entities. Groups are Onhand info (2) and Pricelist info (3).
Id. Key property.
ClientId.
GroupId.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. MaxLength: 500. Nullable.
SortOrder.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Code. MaxLength: 50. Nullable.
Cultures.
ProductInfoTypeCulture
The language specific text on extra fields.
TypeId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 50. Nullable.
Description. MaxLength: 500. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
ProductRelationType
A client specified type for product relation.
Id. Key property.
ClientId.
Code. MaxLength: 50. Nullable.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. MaxLength: 500. Nullable.
IsBidirectional.
IsActive.
SortOrder. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Cultures.
ProductRelationTypeCulture
The language specific text on product relation types.
TypeId. Key property.
CultureCode. MaxLength: 16. Key property.
ClientId.
Name. MaxLength: 50. Nullable.
Description. MaxLength: 500. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ShoppingInfoType
Extra field on the basket entities. The groups are: Basket info (1), Basket item info (2).
Id. Key property.
ClientId.
GroupId.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. MaxLength: 500. Nullable.
DataType. MaxLength: 50. Nullable.
DefaultValue. Nullable.
SortOrder.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Code. MaxLength: 50. Nullable.
Cultures.
ShoppingInfoTypeCulture
The language specific text on extra fields.
TypeId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 50. Nullable.
Description. MaxLength: 500. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
Supplier
A supplier. See Client supplier for client specific information.
Id. Key property.
CorporationId. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Key.
SecretKey.
ClientSuppliers.
SupplierCategoryMapping
A mapping rule between supplier category and a category on the Client.
CategorySupplierId. Key property.
Code. Nullable.
CategoryId. Nullable.
CategoryName. Nullable.
ProductCount. Nullable.
IsMapped.
ClientId.
SupplierId.
IsActive.
SupplierInfo
More information on the supplier, like integration information and settings.
SupplierId. Key property.
ClientId.
AccountNo. MaxLength: 50. Nullable.
Website. MaxLength: 255. Nullable.
LogoPath. MaxLength: 255. Nullable.
PhoneNumber. MaxLength: 50. Nullable.
FaxNumber. MaxLength: 50. Nullable.
EmailAddress. MaxLength: 255. Nullable.
LastDocumentImported. Nullable.
IsChosenSupplierEnabled.
ChosenSupplierSupplementChargePercentage.
HasPriceList.
IsPurchaseIntegrated. Nullable.
PurchaseCutoff. MaxLength: 255. Nullable.
CurrencyId. Nullable.
PoDeliveryMethodId. Nullable.
DeliveryMethodId. Nullable.
PaymentTermId. Nullable.
PaymentTermValue. MaxLength: 50. Nullable.
PopulationRuleId.
ErrorCommunicationTypeId. Nullable.
ErrorCommunicationValue. MaxLength: 255. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
LogoKey. Nullable.
IsPurchaseManual. Nullable.
AutoMapManufacturers. Nullable.
AutoCreateManufacturers. Nullable.
AutoMapCategories. Nullable.
ChosenSupplierFreeFreightLimit. Nullable.
ChosenSupplierFreightCost. Nullable.
ChosenSupplierSupplementCharge. Nullable.
IsDropShipEnabled.
DropShipAllowBackOrders.
DropShipFreeFreightLimit. Nullable.
DropShipFreightCost. Nullable.
DropShipLogisticCost. Nullable.
DropShipSupplementCharge. Nullable.
DropShipSupplementChargePercentage. Nullable.
IsRealTimeCheckEnabled.
InternalInformation. Nullable.
IntegrationMaxAllowedPriceDiffPctPerRow. Nullable.
IntegrationMaxAllowedPriceDiffPerUniqueItem. Nullable.
IsSynchronouslyIntegrated.
DefaultPoDeliveryMethodCode. MaxLength: 50. Nullable.
ChosenSupplierPenaltyCharge. Nullable.
ChosenSupplierPenaltyChargePercentage. Nullable.
SupplierManufacturerMapping
A mapping rule between supplier manufacturer and a manufacturer on the Client.
ManufacturerSupplierId. Key property.
ClientId.
SupplierId.
Code. Nullable.
ProductCount.
IsActive.
VariantGroup
A definition of a variant grouping (Variant type in the admin ui).
Id. Key property.
ClientId.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. MaxLength: 500. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Code. MaxLength: 50. Nullable.
Cultures.
GroupTypes.
VariantGroupCulture
The language specific text on Variant group.
GroupId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 50. Nullable.
Description. MaxLength: 500. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
VariantGroupType
Relation between the variant group and variant type, has sort order.
GroupId. Key property.
TypeId. Key property.
SortOrder.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.
VariantType
Each dimension on a variant group. Has the relation to the Parametric.
Id. Key property.
ClientId.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. MaxLength: 500. Nullable.
ParametricId. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Code. MaxLength: 50. Nullable.
Cultures.
VariantTypeCulture
The language specific text on Variant type.
TypeId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 50. Nullable.
Description. MaxLength: 500. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ClientId. Nullable.