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) |