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.
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.
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.
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.
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.
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.
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.
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.
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.
A parent-child category relation.
CategoryId. Nullable. Key property.
ParentCategoryId. Key property.
Hierarchy. Key property.
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.
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.
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.
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.
The language specific fields for the clients.
CultureCode. MaxLength: 16. Key property.
ClientId.
IsPrimary.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Collation. MaxLength: 128. Nullable.
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.
Store- application relation
DivisionId. Key property.
ApplicationId. Key property.
Created.
CreatedBy.
ClientId. Nullable.
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.
Extra field information on the physical store.
DivisionId. Key property.
TypeId. Key property.
Id.
Value. Nullable.
Updated.
UpdatedBy.
ClientId. Nullable.
Price list related to a physical store.
DivisionId. Key property.
PriceListId. Key property.
Created.
CreatedBy.
ClientId. Nullable.
Warehouse related to physical store.
DivisionId. Key property.
ClientId. Key property.
WarehouseId. Key property.
Created.
CreatedBy.
Locations.
Location related to physical store and warehouse.
DivisionId. Key property.
ClientId. Key property.
WarehouseId. Key property.
LocationId. Key property.
Created.
CreatedBy.
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.
A sales area (VAT region).
SalesAreaId. Key property.
ClientId.
IsPrimary.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Code. MaxLength: 50. Nullable.
ClientSalesAreaVatCode. Nullable.
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.
Additional client speific information on the supplier, like dropshipping or penalty charges.
SupplierId. Key property.
Id.
TypeId.
Value. Nullable.
Updated.
UpdatedBy.
ClientId.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
File type information, like code and id.
FileId. Key property.
ClientId.
Code. MaxLength: 50. Nullable.
SortOrder. Nullable.
Updated.
UpdatedBy.
A manufacturer, with the corporation relation.
Id. Key property.
CorporationId. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Key.
ClientManufacturers.
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.
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.
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 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
A supplier. See Client supplier for client specific information.
Id. Key property.
CorporationId. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Key.
SecretKey.
ClientSuppliers.
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.
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.
A mapping rule between supplier manufacturer and a manufacturer on the Client.
ManufacturerSupplierId. Key property.
ClientId.
SupplierId.
Code. Nullable.
ProductCount.
IsActive.
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.
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.
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.
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.
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.