Query Customers schemas

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

Account

Id
integer <int32>

Id. Key property.

ApplicationId
integer <int32>

ApplicationId.

Key
string <guid>

Key.

LoginName
string

LoginName. MaxLength: 255. Nullable.

TypeId
integer <int32>

TypeId.

ContactId
integer <int32>

ContactId. Nullable.

CustomerId
integer <int32>

CustomerId. Nullable.

StatusId
integer <int32>

StatusId.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.AccountRole> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.AccountRole)

Roles.

AccountRole

Id
integer <int32>

Id. Key property.

AccountId
integer <int32>

AccountId. Key property.

ApplicationRoleId
integer <int32>

ApplicationRoleId. Key property.

ApplicationId
integer <int32>

ApplicationId. Nullable.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

Company

Id
integer <int32>

Id. Key property.

Key
string <guid>

Key.

ClientId
integer <int32>

ClientId.

CompanyCodePrefix
string

CompanyCodePrefix. MaxLength: 10. Nullable.

CompanyCode
string

CompanyCode. MaxLength: 50. Nullable.

TypeId
integer <int32>

TypeId.

LogoPath
string

LogoPath. MaxLength: 255. Nullable.

OrganizationNo
string

OrganizationNo. MaxLength: 50. Nullable.

Name
string

Name. MaxLength: 100. Nullable.

EmailAddress
string

EmailAddress. MaxLength: 255. Nullable.

PhoneNumber
string

PhoneNumber. MaxLength: 50. Nullable.

FaxNumber
string

FaxNumber. MaxLength: 50. Nullable.

ParentCompanyId
integer <int32>

ParentCompanyId. Nullable.

ReferId
integer <int32>

ReferId. Nullable.

ReferUrl
string

ReferUrl. MaxLength: 255. Nullable.

UseBillingAddressAsShippingAddress
boolean

UseBillingAddressAsShippingAddress.

OldCompanyCodePrefix
string

OldCompanyCodePrefix. MaxLength: 10. Nullable.

OldCompanyCode
string

OldCompanyCode. MaxLength: 50. Nullable.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

LogoKey
string <guid>

LogoKey. Nullable.

NormalizedOrganizationNo
string

NormalizedOrganizationNo. MaxLength: 50. Nullable.

ApplicationId
integer <int32>

ApplicationId. Nullable.

VatNo
string

VatNo. MaxLength: 50. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerCompany> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerCompany)

Customers.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerOrder> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerOrder)

Orders.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyInfo> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyInfo)

Infos.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyAddress> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyAddress)

Addresses.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyFlag> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyFlag)

Flags.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyPriceList> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyPriceList)

PriceLists.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyDiscount> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyDiscount)

Discounts.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyDeliveryMethod> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyDeliveryMethod)

DeliveryMethods.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyPaymentMethod> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CompanyPaymentMethod)

PaymentMethods.

CompanyAddress

Id
integer <int32>

Id. Key property.

CompanyId
integer <int32>

CompanyId. Key property.

TypeId
integer <int32>

TypeId.

CareOf
string

CareOf. MaxLength: 100. Nullable.

AddressLine1
string

AddressLine1. MaxLength: 255. Nullable.

AddressLine2
string

AddressLine2. MaxLength: 255. Nullable.

ZipCode
string

ZipCode. MaxLength: 50. Nullable.

City
string

City. MaxLength: 50. Nullable.

Region
string

Region. MaxLength: 100. Nullable.

CountryId
integer <int32>

CountryId. Nullable.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

StatusId
integer <int32>

StatusId. Nullable.

StatusUpdated
string <date-time>

StatusUpdated. Nullable.

StatusUpdatedBy
integer <int32>

StatusUpdatedBy. Nullable.

Gln
string

Gln. MaxLength: 50. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

ShippingPhoneNumber
string

ShippingPhoneNumber. MaxLength: 50. Nullable.

Code
string

Code. MaxLength: 50. Nullable.

IsPrimary
boolean

IsPrimary.

CompanyDeliveryMethod

Code
string

Code. MaxLength: 50. Key property.

CompanyId
integer <int32>

CompanyId. Key property.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

CompanyDiscount

TypeId
integer <int32>

TypeId. Key property.

ValueCode
string

ValueCode. MaxLength: 50. Key property.

CompanyId
integer <int32>

CompanyId. Key property.

ClientId
integer <int32>

ClientId.

DiscountPct
number <decimal>

DiscountPct.

PriceListTypeIdSeed
string

PriceListTypeIdSeed. MaxLength: 50. Nullable.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

CompanyFlag

FlagId
integer <int32>

FlagId. Key property.

CompanyId
integer <int32>

CompanyId. Key property.

IsActive
boolean

IsActive.

StoppedDate
string <date-time>

StoppedDate. Nullable.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

CompanyInfo

CompanyId
integer <int32>

CompanyId. Key property.

TypeId
integer <int32>

TypeId. Key property.

Id
integer <int32>

Id.

Value
string

Value. Nullable.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

CompanyPaymentMethod

Code
string

Code. MaxLength: 50. Key property.

CompanyId
integer <int32>

CompanyId. Key property.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

InvoiceCaptureSettingsCode
string

InvoiceCaptureSettingsCode. MaxLength: 100. Nullable.

CompanyPriceList

PriceListId
integer <int32>

PriceListId. Key property.

CompanyId
integer <int32>

CompanyId. Key property.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

IsExclusive
boolean

IsExclusive.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

Customer

Id
integer <int32>

Id. Key property.

Key
string <guid>

Key.

ClientId
integer <int32>

ClientId.

CustomerCodePrefix
string

CustomerCodePrefix. MaxLength: 10. Nullable.

CustomerCode
string

CustomerCode. MaxLength: 50. Nullable.

TypeId
integer <int32>

TypeId.

EmailAddress
string

EmailAddress. MaxLength: 255. Nullable.

SocialSecurityNumber
string

SocialSecurityNumber. MaxLength: 50. Nullable.

Title
string

Title. MaxLength: 10. Nullable.

FirstName
string

FirstName. MaxLength: 50. Nullable.

MiddleName
string

MiddleName. MaxLength: 50. Nullable.

LastName
string

LastName. MaxLength: 50. Nullable.

Suffix
string

Suffix. MaxLength: 10. Nullable.

PhoneNumber
string

PhoneNumber. MaxLength: 50. Nullable.

CellPhoneNumber
string

CellPhoneNumber. MaxLength: 50. Nullable.

ReferId
integer <int32>

ReferId. Nullable.

ReferUrl
string

ReferUrl. MaxLength: 255. Nullable.

UseBillingAddressAsShippingAddress
boolean

UseBillingAddressAsShippingAddress.

OldCustomerNoPrefix
string

OldCustomerNoPrefix. MaxLength: 10. Nullable.

OldCustomerNo
string

OldCustomerNo. MaxLength: 50. Nullable.

ReplacementCustomerId
integer <int32>

ReplacementCustomerId. Nullable.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

LastOrderDate
string <date-time>

LastOrderDate. Nullable.

NormalizedSocialSecurityNumber
string

NormalizedSocialSecurityNumber. MaxLength: 50. Nullable.

ApplicationId
integer <int32>

ApplicationId. Nullable.

IsForgotten
boolean

IsForgotten.

ForgottenBy
integer <int32>

ForgottenBy. Nullable.

ForgottenDate
string <date-time>

ForgottenDate. Nullable.

StoppedDate
string <date-time>

StoppedDate. Nullable.

StoppedBy
integer <int32>

StoppedBy. Nullable.

CrmId
string

CrmId. MaxLength: 50. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.Account> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.Account)

Account.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerCompany> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerCompany)

Companies.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerAddress> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerAddress)

Addresses.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerOrder> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerOrder)

Orders.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerInfo> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerInfo)

Infos.

Array of objects <Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerFlag> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.CustomerFlag)

Flags.

CustomerAddress

Id
integer <int32>

Id. Key property.

CustomerId
integer <int32>

CustomerId. Key property.

TypeId
integer <int32>

TypeId.

CareOf
string

CareOf. MaxLength: 100. Nullable.

AddressLine1
string

AddressLine1. MaxLength: 255. Nullable.

AddressLine2
string

AddressLine2. MaxLength: 255. Nullable.

ZipCode
string

ZipCode. MaxLength: 50. Nullable.

City
string

City. MaxLength: 50. Nullable.

Region
string

Region. MaxLength: 50. Nullable.

CountryId
integer <int32>

CountryId. Nullable.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

StatusId
integer <int32>

StatusId. Nullable.

StatusUpdated
string <date-time>

StatusUpdated. Nullable.

StatusUpdatedBy
integer <int32>

StatusUpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

ShippingPhoneNumber
string

ShippingPhoneNumber. MaxLength: 50. Nullable.

Code
string

Code. MaxLength: 50. Nullable.

IsPrimary
boolean

IsPrimary.

CustomerCompany

CustomerId
integer <int32>

CustomerId. Nullable. Key property.

CompanyId
integer <int32>

CompanyId. Nullable. Key property.

RoleId
integer <int32>

RoleId. Nullable.

CustomerCodePrefix
string

CustomerCodePrefix. MaxLength: 10. Nullable.

CustomerCode
string

CustomerCode. MaxLength: 50. Nullable.

Department
string

Department. MaxLength: 255. Nullable.

OrganizationTitle
string

OrganizationTitle. MaxLength: 50. Nullable.

IsPrimary
boolean

IsPrimary.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

object <Enferno.Storm.Query.Api.DataContexts.CustomerModel.Customer> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.Customer)
object <Enferno.Storm.Query.Api.DataContexts.CustomerModel.Company> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.Company)

CustomerFlag

FlagId
integer <int32>

FlagId. Key property.

CustomerId
integer <int32>

CustomerId. Key property.

IsActive
boolean

IsActive.

StoppedDate
string <date-time>

StoppedDate. Nullable.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

CustomerInfo

CustomerId
integer <int32>

CustomerId. Key property.

TypeId
integer <int32>

TypeId. Key property.

Id
integer <int32>

Id.

Value
string

Value. Nullable.

Updated
string <date-time>

Updated.

UpdatedBy
integer <int32>

UpdatedBy.

ClientId
integer <int32>

ClientId. Nullable.

CustomerOrder

Id
string

Id. Key property.

ClientId
integer <int32>

ClientId.

ApplicationId
integer <int32>

ApplicationId.

QuotationId
integer <int32>

QuotationId. Nullable.

OrderNo
string

OrderNo. MaxLength: 50. Nullable.

OrderDate
string <date-time>

OrderDate.

BuyerCompanyCode
string

BuyerCompanyCode. MaxLength: 50. Nullable.

BuyerCompanyId
integer <int32>

BuyerCompanyId. Nullable.

BuyerCustomerCode
string

BuyerCustomerCode. MaxLength: 50. Nullable.

BuyerCustomerId
integer <int32>

BuyerCustomerId. Nullable.

PayerCompanyCode
string

PayerCompanyCode. MaxLength: 50. Nullable.

PayerCompanyId
integer <int32>

PayerCompanyId. Nullable.

PayerCustomerCode
string

PayerCustomerCode. MaxLength: 50. Nullable.

PayerCustomerId
integer <int32>

PayerCustomerId. Nullable.

ResellerCompanyCode
string

ResellerCompanyCode. MaxLength: 50. Nullable.

ResellerCompanyId
integer <int32>

ResellerCompanyId. Nullable.

ResellerCustomerCode
string

ResellerCustomerCode. MaxLength: 50. Nullable.

ResellerCustomerId
integer <int32>

ResellerCustomerId. Nullable.

GroupCode
string

GroupCode. MaxLength: 50. Nullable.

StatusId
integer <int32>

StatusId.

SalesRepContactId
integer <int32>

SalesRepContactId. Nullable.

Source
string

Source. MaxLength: 255. Nullable.

DeliveryTerms
string

DeliveryTerms. MaxLength: 10. Nullable.

DeliveryMode
string

DeliveryMode. MaxLength: 50. Nullable.

DeliveryDate
string <date-time>

DeliveryDate. Nullable.

IsPartDelivery
boolean

IsPartDelivery.

PaymentTerms
string

PaymentTerms. MaxLength: 100. Nullable.

CurrencyId
integer <int32>

CurrencyId.

VatRate
number <decimal>

VatRate.

CashDiscount
number <decimal>

CashDiscount.

LineDiscount
number <decimal>

LineDiscount.

FreightCost
number <decimal>

FreightCost.

OrderFee
number <decimal>

OrderFee.

DeliveryAttention
string

DeliveryAttention. MaxLength: 100. Nullable.

DeliveryCareOf
string

DeliveryCareOf. MaxLength: 100. Nullable.

DeliveryAddressLine1
string

DeliveryAddressLine1. MaxLength: 255. Nullable.

DeliveryAddressLine2
string

DeliveryAddressLine2. MaxLength: 255. Nullable.

DeliveryZipCode
string

DeliveryZipCode. MaxLength: 50. Nullable.

DeliveryCity
string

DeliveryCity. MaxLength: 50. Nullable.

DeliveryRegion
string

DeliveryRegion. MaxLength: 100. Nullable.

DeliveryCountryId
integer <int32>

DeliveryCountryId. Nullable.

LedgerAccount
string

LedgerAccount. MaxLength: 50. Nullable.

Department
string

Department. MaxLength: 10. Nullable.

Centre
string

Centre. MaxLength: 10. Nullable.

ExternalPurchaseNo
string

ExternalPurchaseNo. MaxLength: 50. Nullable.

SalesCode
string

SalesCode. MaxLength: 50. Nullable.

DeliveryMark
string

DeliveryMark. MaxLength: 255. Nullable.

InvoiceMark
string

InvoiceMark. MaxLength: 255. Nullable.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

PayerCustomerInfoId
string

PayerCustomerInfoId. Nullable.

EstimatedDeliveryTime
string <date-time>

EstimatedDeliveryTime. Nullable.

DeliveryTime
string <date-time>

DeliveryTime. Nullable.

BuyerCustomerInfoId
string

BuyerCustomerInfoId. Nullable.

ShipToCustomerInfoId
string

ShipToCustomerInfoId. Nullable.

ExternalRef
string

ExternalRef. MaxLength: 50. Nullable.

PaymentMethodId
integer <int32>

PaymentMethodId. Nullable.

DeliveryMethodId
integer <int32>

DeliveryMethodId. Nullable.

OrderTypeId
integer <int32>

OrderTypeId. Nullable.

IsForgotten
boolean

IsForgotten.

ForgottenBy
integer <int32>

ForgottenBy. Nullable.

ForgottenDate
string <date-time>

ForgottenDate. Nullable.

DropPointCustomerInfoId
string

DropPointCustomerInfoId. Nullable.

DropPointCode
string

DropPointCode. MaxLength: 50. Nullable.

Year
integer <int32>

Year. Nullable.

Week
integer <int32>

Week. Nullable.

object <Enferno.Storm.Query.Api.DataContexts.CustomerModel.Company> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.Company)
object <Enferno.Storm.Query.Api.DataContexts.CustomerModel.Customer> (Enferno.Storm.Query.Api.DataContexts.CustomerModel.Customer)