Skip to content
SCHEMA REFERENCES
/
/
Query Customers
Last updated

Query Customers schemas

The Customer Namespace in Norce Commerce Query has the entities and methods of all the customer and company related information.

Account

Idinteger(int32)

Id. Key property.

ApplicationIdinteger(int32)

ApplicationId.

Keystring(guid)

Key.

LoginNamestring

LoginName. MaxLength: 255. Nullable.

TypeIdinteger(int32)

TypeId.

ContactIdinteger(int32)

ContactId. Nullable.

CustomerIdinteger(int32)

CustomerId. Nullable.

StatusIdinteger(int32)

StatusId.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

RolesArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.AccountRole)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.AccountRole)

Roles.

AccountRole

Idinteger(int32)

Id. Key property.

AccountIdinteger(int32)

AccountId. Key property.

ApplicationRoleIdinteger(int32)

ApplicationRoleId. Key property.

ApplicationIdinteger(int32)

ApplicationId. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

Company

Idinteger(int32)

Id. Key property.

Keystring(guid)

Key.

ClientIdinteger(int32)

ClientId.

CompanyCodePrefixstring

CompanyCodePrefix. MaxLength: 10. Nullable.

CompanyCodestring

CompanyCode. MaxLength: 50. Nullable.

TypeIdinteger(int32)

TypeId.

LogoPathstring

LogoPath. MaxLength: 255. Nullable.

OrganizationNostring

OrganizationNo. MaxLength: 50. Nullable.

Namestring

Name. MaxLength: 100. Nullable.

EmailAddressstring

EmailAddress. MaxLength: 255. Nullable.

PhoneNumberstring

PhoneNumber. MaxLength: 50. Nullable.

FaxNumberstring

FaxNumber. MaxLength: 50. Nullable.

ParentCompanyIdinteger(int32)

ParentCompanyId. Nullable.

ReferIdinteger(int32)

ReferId. Nullable.

ReferUrlstring

ReferUrl. MaxLength: 255. Nullable.

UseBillingAddressAsShippingAddressboolean

UseBillingAddressAsShippingAddress.

OldCompanyCodePrefixstring

OldCompanyCodePrefix. MaxLength: 10. Nullable.

OldCompanyCodestring

OldCompanyCode. MaxLength: 50. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

LogoKeystring(guid)

LogoKey. Nullable.

NormalizedOrganizationNostring

NormalizedOrganizationNo. MaxLength: 50. Nullable.

ApplicationIdinteger(int32)

ApplicationId. Nullable.

VatNostring

VatNo. MaxLength: 50. Nullable.

CustomersArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerCompany)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerCompany)

Customers.

OrdersArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerOrder)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerOrder)

Orders.

InfosArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyInfo)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyInfo)

Infos.

AddressesArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyAddress)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyAddress)

Addresses.

FlagsArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyFlag)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyFlag)

Flags.

PriceListsArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyPriceList)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyPriceList)

PriceLists.

DiscountsArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyDiscount)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyDiscount)

Discounts.

DeliveryMethodsArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyDeliveryMethod)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyDeliveryMethod)

DeliveryMethods.

PaymentMethodsArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyPaymentMethod)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyPaymentMethod)

PaymentMethods.

CompanyAddress

Idinteger(int32)

Id. Key property.

CompanyIdinteger(int32)

CompanyId. Key property.

TypeIdinteger(int32)

TypeId.

CareOfstring

CareOf. MaxLength: 100. Nullable.

AddressLine1string

AddressLine1. MaxLength: 255. Nullable.

AddressLine2string

AddressLine2. MaxLength: 255. Nullable.

ZipCodestring

ZipCode. MaxLength: 50. Nullable.

Citystring

City. MaxLength: 50. Nullable.

Regionstring

Region. MaxLength: 100. Nullable.

CountryIdinteger(int32)

CountryId. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

StatusIdinteger(int32)

StatusId. Nullable.

StatusUpdatedstring(date-time)

StatusUpdated. Nullable.

StatusUpdatedByinteger(int32)

StatusUpdatedBy. Nullable.

Glnstring

Gln. MaxLength: 50. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ShippingPhoneNumberstring

ShippingPhoneNumber. MaxLength: 50. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

IsPrimaryboolean

IsPrimary.

CompanyDeliveryMethod

Codestring

Code. MaxLength: 50. Key property.

CompanyIdinteger(int32)

CompanyId. Key property.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

CompanyDiscount

TypeIdinteger(int32)

TypeId. Key property.

ValueCodestring

ValueCode. MaxLength: 50. Key property.

CompanyIdinteger(int32)

CompanyId. Key property.

ClientIdinteger(int32)

ClientId.

DiscountPctnumber(decimal)

DiscountPct.

PriceListTypeIdSeedstring

PriceListTypeIdSeed. MaxLength: 50. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CompanyFlag

FlagIdinteger(int32)

FlagId. Key property.

CompanyIdinteger(int32)

CompanyId. Key property.

IsActiveboolean

IsActive.

StoppedDatestring(date-time)

StoppedDate. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

CompanyInfo

CompanyIdinteger(int32)

CompanyId. Key property.

TypeIdinteger(int32)

TypeId. Key property.

Idinteger(int32)

Id.

Valuestring

Value. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

CompanyPaymentMethod

Codestring

Code. MaxLength: 50. Key property.

CompanyIdinteger(int32)

CompanyId. Key property.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

InvoiceCaptureSettingsCodestring

InvoiceCaptureSettingsCode. MaxLength: 100. Nullable.

CompanyPriceList

PriceListIdinteger(int32)

PriceListId. Key property.

CompanyIdinteger(int32)

CompanyId. Key property.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

IsExclusiveboolean

IsExclusive.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

Customer

Idinteger(int32)

Id. Key property.

Keystring(guid)

Key.

ClientIdinteger(int32)

ClientId.

CustomerCodePrefixstring

CustomerCodePrefix. MaxLength: 10. Nullable.

CustomerCodestring

CustomerCode. MaxLength: 50. Nullable.

TypeIdinteger(int32)

TypeId.

EmailAddressstring

EmailAddress. MaxLength: 255. Nullable.

SocialSecurityNumberstring

SocialSecurityNumber. MaxLength: 50. Nullable.

Titlestring

Title. MaxLength: 10. Nullable.

FirstNamestring

FirstName. MaxLength: 50. Nullable.

MiddleNamestring

MiddleName. MaxLength: 50. Nullable.

LastNamestring

LastName. MaxLength: 50. Nullable.

Suffixstring

Suffix. MaxLength: 10. Nullable.

PhoneNumberstring

PhoneNumber. MaxLength: 50. Nullable.

CellPhoneNumberstring

CellPhoneNumber. MaxLength: 50. Nullable.

ReferIdinteger(int32)

ReferId. Nullable.

ReferUrlstring

ReferUrl. MaxLength: 255. Nullable.

UseBillingAddressAsShippingAddressboolean

UseBillingAddressAsShippingAddress.

OldCustomerNoPrefixstring

OldCustomerNoPrefix. MaxLength: 10. Nullable.

OldCustomerNostring

OldCustomerNo. MaxLength: 50. Nullable.

ReplacementCustomerIdinteger(int32)

ReplacementCustomerId. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

LastOrderDatestring(date-time)

LastOrderDate. Nullable.

NormalizedSocialSecurityNumberstring

NormalizedSocialSecurityNumber. MaxLength: 50. Nullable.

ApplicationIdinteger(int32)

ApplicationId. Nullable.

IsForgottenboolean

IsForgotten.

ForgottenByinteger(int32)

ForgottenBy. Nullable.

ForgottenDatestring(date-time)

ForgottenDate. Nullable.

StoppedDatestring(date-time)

StoppedDate. Nullable.

StoppedByinteger(int32)

StoppedBy. Nullable.

CrmIdstring

CrmId. MaxLength: 50. Nullable.

AccountArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.Account)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.Account)

Account.

CompaniesArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerCompany)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerCompany)

Companies.

AddressesArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerAddress)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerAddress)

Addresses.

OrdersArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerOrder)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerOrder)

Orders.

InfosArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerInfo)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerInfo)

Infos.

FlagsArray of objects(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerFlag)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerFlag)

Flags.

CustomerAddress

Idinteger(int32)

Id. Key property.

CustomerIdinteger(int32)

CustomerId. Key property.

TypeIdinteger(int32)

TypeId.

CareOfstring

CareOf. MaxLength: 100. Nullable.

AddressLine1string

AddressLine1. MaxLength: 255. Nullable.

AddressLine2string

AddressLine2. MaxLength: 255. Nullable.

ZipCodestring

ZipCode. MaxLength: 50. Nullable.

Citystring

City. MaxLength: 50. Nullable.

Regionstring

Region. MaxLength: 50. Nullable.

CountryIdinteger(int32)

CountryId. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

StatusIdinteger(int32)

StatusId. Nullable.

StatusUpdatedstring(date-time)

StatusUpdated. Nullable.

StatusUpdatedByinteger(int32)

StatusUpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ShippingPhoneNumberstring

ShippingPhoneNumber. MaxLength: 50. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

IsPrimaryboolean

IsPrimary.

CustomerCompany

CustomerIdinteger(int32)

CustomerId. Nullable. Key property.

CompanyIdinteger(int32)

CompanyId. Nullable. Key property.

RoleIdinteger(int32)

RoleId. Nullable.

CustomerCodePrefixstring

CustomerCodePrefix. MaxLength: 10. Nullable.

CustomerCodestring

CustomerCode. MaxLength: 50. Nullable.

Departmentstring

Department. MaxLength: 255. Nullable.

OrganizationTitlestring

OrganizationTitle. MaxLength: 50. Nullable.

IsPrimaryboolean

IsPrimary.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

Customerobject(Enferno.Storm.Query.Api.DataContexts.CustomerModel.Customer)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.Customer)
Companyobject(Enferno.Storm.Query.Api.DataContexts.CustomerModel.Company)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.Company)

CustomerFlag

FlagIdinteger(int32)

FlagId. Key property.

CustomerIdinteger(int32)

CustomerId. Key property.

IsActiveboolean

IsActive.

StoppedDatestring(date-time)

StoppedDate. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

CustomerInfo

CustomerIdinteger(int32)

CustomerId. Key property.

TypeIdinteger(int32)

TypeId. Key property.

Idinteger(int32)

Id.

Valuestring

Value. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

ClientIdinteger(int32)

ClientId. Nullable.

CustomerOrder

Idstring

Id. Key property.

ClientIdinteger(int32)

ClientId.

ApplicationIdinteger(int32)

ApplicationId.

QuotationIdinteger(int32)

QuotationId. Nullable.

OrderNostring

OrderNo. MaxLength: 50. Nullable.

OrderDatestring(date-time)

OrderDate.

BuyerCompanyCodestring

BuyerCompanyCode. MaxLength: 50. Nullable.

BuyerCompanyIdinteger(int32)

BuyerCompanyId. Nullable.

BuyerCustomerCodestring

BuyerCustomerCode. MaxLength: 50. Nullable.

BuyerCustomerIdinteger(int32)

BuyerCustomerId. Nullable.

PayerCompanyCodestring

PayerCompanyCode. MaxLength: 50. Nullable.

PayerCompanyIdinteger(int32)

PayerCompanyId. Nullable.

PayerCustomerCodestring

PayerCustomerCode. MaxLength: 50. Nullable.

PayerCustomerIdinteger(int32)

PayerCustomerId. Nullable.

ResellerCompanyCodestring

ResellerCompanyCode. MaxLength: 50. Nullable.

ResellerCompanyIdinteger(int32)

ResellerCompanyId. Nullable.

ResellerCustomerCodestring

ResellerCustomerCode. MaxLength: 50. Nullable.

ResellerCustomerIdinteger(int32)

ResellerCustomerId. Nullable.

GroupCodestring

GroupCode. MaxLength: 50. Nullable.

StatusIdinteger(int32)

StatusId.

SalesRepContactIdinteger(int32)

SalesRepContactId. Nullable.

Sourcestring

Source. MaxLength: 255. Nullable.

DeliveryTermsstring

DeliveryTerms. MaxLength: 10. Nullable.

DeliveryModestring

DeliveryMode. MaxLength: 50. Nullable.

DeliveryDatestring(date-time)

DeliveryDate. Nullable.

IsPartDeliveryboolean

IsPartDelivery.

PaymentTermsstring

PaymentTerms. MaxLength: 100. Nullable.

CurrencyIdinteger(int32)

CurrencyId.

VatRatenumber(decimal)

VatRate.

CashDiscountnumber(decimal)

CashDiscount.

LineDiscountnumber(decimal)

LineDiscount.

FreightCostnumber(decimal)

FreightCost.

OrderFeenumber(decimal)

OrderFee.

DeliveryAttentionstring

DeliveryAttention. MaxLength: 100. Nullable.

DeliveryCareOfstring

DeliveryCareOf. MaxLength: 100. Nullable.

DeliveryAddressLine1string

DeliveryAddressLine1. MaxLength: 255. Nullable.

DeliveryAddressLine2string

DeliveryAddressLine2. MaxLength: 255. Nullable.

DeliveryZipCodestring

DeliveryZipCode. MaxLength: 50. Nullable.

DeliveryCitystring

DeliveryCity. MaxLength: 50. Nullable.

DeliveryRegionstring

DeliveryRegion. MaxLength: 100. Nullable.

DeliveryCountryIdinteger(int32)

DeliveryCountryId. Nullable.

LedgerAccountstring

LedgerAccount. MaxLength: 50. Nullable.

Departmentstring

Department. MaxLength: 10. Nullable.

Centrestring

Centre. MaxLength: 10. Nullable.

ExternalPurchaseNostring

ExternalPurchaseNo. MaxLength: 50. Nullable.

SalesCodestring

SalesCode. MaxLength: 50. Nullable.

DeliveryMarkstring

DeliveryMark. MaxLength: 255. Nullable.

InvoiceMarkstring

InvoiceMark. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

PayerCustomerInfoIdstring

PayerCustomerInfoId. Nullable.

EstimatedDeliveryTimestring(date-time)

EstimatedDeliveryTime. Nullable.

DeliveryTimestring(date-time)

DeliveryTime. Nullable.

BuyerCustomerInfoIdstring

BuyerCustomerInfoId. Nullable.

ShipToCustomerInfoIdstring

ShipToCustomerInfoId. Nullable.

ExternalRefstring

ExternalRef. MaxLength: 50. Nullable.

PaymentMethodIdinteger(int32)

PaymentMethodId. Nullable.

DeliveryMethodIdinteger(int32)

DeliveryMethodId. Nullable.

OrderTypeIdinteger(int32)

OrderTypeId. Nullable.

IsForgottenboolean

IsForgotten.

ForgottenByinteger(int32)

ForgottenBy. Nullable.

ForgottenDatestring(date-time)

ForgottenDate. Nullable.

DropPointCustomerInfoIdstring

DropPointCustomerInfoId. Nullable.

DropPointCodestring

DropPointCode. MaxLength: 50. Nullable.

Yearinteger(int32)

Year. Nullable.

Weekinteger(int32)

Week. Nullable.

Companyobject(Enferno.Storm.Query.Api.DataContexts.CustomerModel.Company)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.Company)
Customerobject(Enferno.Storm.Query.Api.DataContexts.CustomerModel.Customer)(Enferno.Storm.Query.Api.DataContexts.CustomerModel.Customer)
Previous page
Next page