SCHEMA REFERENCES
/
Commerce Query
/
Query Orders
Last updated

Query Orders schemas

The Orders Namespace in Norce Commerce Query has the entities and methods orders, delivery notes and invoices. Everything regarding transactions that happens after the purchase.

Address

Idstring

Id. Key property.

TypeIdinteger(int32)

TypeId. Nullable.

Namestring

Name. MaxLength: 100. Nullable.

Attentionstring

Attention. MaxLength: 100. Nullable.

CareOfstring

CareOf. MaxLength: 100. Nullable.

Line1string

Line1. MaxLength: 255. Nullable.

Line2string

Line2. 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.

RowIdstring

RowId. MaxLength: 8. Nullable.

EmailAddressstring

EmailAddress. MaxLength: 255. Nullable.

PhoneNumberstring

PhoneNumber. MaxLength: 50. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ShippingPhoneNumberstring

ShippingPhoneNumber. MaxLength: 50. Nullable.

Glnstring

Gln. MaxLength: 50. Nullable.

DeliveryNote

Idstring

Id. Key property.

ClientIdinteger(int32)

ClientId.

NoteNostring

NoteNo. MaxLength: 50. Nullable.

SupplierIdinteger(int32)

SupplierId. Nullable.

TypeIdinteger(int32)

TypeId.

ReferenceOrderIdstring

ReferenceOrderId.

BuyerCompanyIdinteger(int32)

BuyerCompanyId. Nullable.

BuyerCompanyCodestring

BuyerCompanyCode. MaxLength: 50. Nullable.

BuyerCustomerIdinteger(int32)

BuyerCustomerId. Nullable.

BuyerCustomerCodestring

BuyerCustomerCode. MaxLength: 50. Nullable.

PayerCompanyIdinteger(int32)

PayerCompanyId. Nullable.

PayerCompanyCodestring

PayerCompanyCode. MaxLength: 50. Nullable.

PayerCustomerIdinteger(int32)

PayerCustomerId. Nullable.

PayerCustomerCodestring

PayerCustomerCode. MaxLength: 50. Nullable.

ResellerCompanyIdinteger(int32)

ResellerCompanyId. Nullable.

ResellerCompanyCodestring

ResellerCompanyCode. MaxLength: 50. Nullable.

ResellerCustomerIdinteger(int32)

ResellerCustomerId. Nullable.

ResellerCustomerCodestring

ResellerCustomerCode. MaxLength: 50. Nullable.

GroupCodestring

GroupCode. MaxLength: 50. Nullable.

DeliveryNamestring

DeliveryName. MaxLength: 100. Nullable.

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.

DeliveryDatestring(date-time)

DeliveryDate. Nullable.

Quantitynumber(decimal)

Quantity. Nullable.

Volumenumber(decimal)

Volume. Nullable.

Weightnumber(decimal)

Weight. Nullable.

IsPrintedboolean

IsPrinted.

DeliveryTermsstring

DeliveryTerms. MaxLength: 10. Nullable.

DeliveryModestring

DeliveryMode. MaxLength: 50. Nullable.

Sourcestring

Source. MaxLength: 255. Nullable.

DeliveryMarkstring

DeliveryMark. MaxLength: 255. Nullable.

NoteTextstring

NoteText. MaxLength: 255. Nullable.

Departmentstring

Department. MaxLength: 10. Nullable.

Centrestring

Centre. MaxLength: 10. Nullable.

ShippingNostring

ShippingNo. MaxLength: 50. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

DeliveryAddressIdstring

DeliveryAddressId. Nullable.

DivisionCodestring

DivisionCode. MaxLength: 50. Nullable.

StatusIdinteger(int32)

StatusId.

IsForgottenboolean

IsForgotten.

ForgottenByinteger(int32)

ForgottenBy. Nullable.

ForgottenDatestring(date-time)

ForgottenDate. Nullable.

ItemsArray of objects(OrderService.DeliveryNoteItem)(OrderService.DeliveryNoteItem)

Items.

PackagesArray of objects(OrderService.DeliveryNotePackage)(OrderService.DeliveryNotePackage)

Packages.

DeliveryNoteItem

Idstring

Id. Key property.

DeliveryNoteIdstring

DeliveryNoteId.

LineNumbernumber(decimal)

LineNumber. Nullable.

PartNostring

PartNo. MaxLength: 50. Nullable.

ExternalPartNostring

ExternalPartNo. MaxLength: 50. Nullable.

ProductNamestring

ProductName. MaxLength: 255. Nullable.

StockUnitOfMeasurementCountnumber(decimal)

StockUnitOfMeasurementCount.

PriceUnitOfMeasurementCountnumber(decimal)

PriceUnitOfMeasurementCount.

QtyOrderednumber(decimal)

QtyOrdered.

Quantitynumber(decimal)

Quantity.

QtyBackOrderednumber(decimal)

QtyBackOrdered.

IsPartDeliveryboolean

IsPartDelivery.

SalesRepContactIdinteger(int32)

SalesRepContactId. Nullable.

VatRatenumber(decimal)

VatRate.

ValueMstnumber(decimal)

ValueMst.

NoteTextstring

NoteText. MaxLength: 255. Nullable.

Departmentstring

Department. MaxLength: 10. Nullable.

Centrestring

Centre. MaxLength: 10. Nullable.

TransIdinteger(int32)

TransId.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

OrderItemIdstring

OrderItemId. Nullable.

PurchaseOrderItemIdstring

PurchaseOrderItemId. Nullable.

LineNumberStringstring

LineNumberString. MaxLength: 50. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

PurchaseOrderItemobject(OrderService.PurchaseOrderItem)(OrderService.PurchaseOrderItem)

DeliveryNotePackage

Idstring

Id. Key property.

DeliveryNoteIdstring

DeliveryNoteId.

ShippingNostring

ShippingNo. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

StatusIdinteger(int32)

StatusId.

ClientIdinteger(int32)

ClientId. Nullable.

Invoice

Idstring

Id. Key property.

ClientIdinteger(int32)

ClientId.

InvoiceNostring

InvoiceNo. MaxLength: 50. Nullable.

TypeIdinteger(int32)

TypeId.

ReferenceOrderIdstring

ReferenceOrderId.

BuyerCompanyIdinteger(int32)

BuyerCompanyId. Nullable.

BuyerCustomerIdinteger(int32)

BuyerCustomerId. Nullable.

PayerCompanyIdinteger(int32)

PayerCompanyId. Nullable.

PayerCustomerIdinteger(int32)

PayerCustomerId. Nullable.

ResellerCompanyIdinteger(int32)

ResellerCompanyId. Nullable.

ResellerCustomerIdinteger(int32)

ResellerCustomerId. Nullable.

GroupCodestring

GroupCode. MaxLength: 50. Nullable.

DeliveryDatestring(date-time)

DeliveryDate. Nullable.

InvoiceDatestring(date-time)

InvoiceDate.

InvoiceDueDatestring(date-time)

InvoiceDueDate. Nullable.

SalesRepContactIdinteger(int32)

SalesRepContactId. Nullable.

Sourcestring

Source. MaxLength: 255. Nullable.

Quantitynumber(decimal)

Quantity.

Volumenumber(decimal)

Volume. Nullable.

Weightnumber(decimal)

Weight. Nullable.

CurrencyIdinteger(int32)

CurrencyId.

CurrencyRatenumber(decimal)

CurrencyRate.

CashDiscountnumber(decimal)

CashDiscount.

CashDiscountDatestring(date-time)

CashDiscountDate. Nullable.

SumLineDiscountnumber(decimal)

SumLineDiscount.

FreightCostnumber(decimal)

FreightCost.

InvoiceFeenumber(decimal)

InvoiceFee.

CostValuenumber(decimal)

CostValue.

SalesBalancenumber(decimal)

SalesBalance.

InvoiceAmountnumber(decimal)

InvoiceAmount.

InvoiceRoundOffnumber(decimal)

InvoiceRoundOff.

VatDutiable1number(decimal)

VatDutiable1.

VatDutiable2number(decimal)

VatDutiable2.

VatDutiable3number(decimal)

VatDutiable3.

Vat1number(decimal)

Vat1.

Vat2number(decimal)

Vat2.

Vat3number(decimal)

Vat3.

VatRoundOffnumber(decimal)

VatRoundOff.

Vatnumber(decimal)

Vat.

InvoiceNamestring

InvoiceName. MaxLength: 255. Nullable.

InvoiceAttentionstring

InvoiceAttention. MaxLength: 100. Nullable.

InvoiceCareOfstring

InvoiceCareOf. MaxLength: 100. Nullable.

InvoiceAddressLine1string

InvoiceAddressLine1. MaxLength: 255. Nullable.

InvoiceAddressLine2string

InvoiceAddressLine2. MaxLength: 255. Nullable.

InvoiceZipCodestring

InvoiceZipCode. MaxLength: 50. Nullable.

InvoiceCitystring

InvoiceCity. MaxLength: 50. Nullable.

InvoiceRegionstring

InvoiceRegion. MaxLength: 100. Nullable.

InvoiceCountryIdinteger(int32)

InvoiceCountryId. Nullable.

LedgerVoucherstring

LedgerVoucher. MaxLength: 50. Nullable.

Departmentstring

Department. MaxLength: 10. Nullable.

Centrestring

Centre. MaxLength: 10. Nullable.

NoteTextstring

NoteText. MaxLength: 255. Nullable.

LastInvoiceForOrderboolean

LastInvoiceForOrder. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

InvoiceAddressIdstring

InvoiceAddressId. Nullable.

ReferenceNoPspstring

ReferenceNoPsp. MaxLength: 50. Nullable.

PaymentMethodIdinteger(int32)

PaymentMethodId. Nullable.

DeliveryMethodIdinteger(int32)

DeliveryMethodId. Nullable.

IsDebitboolean

IsDebit. Nullable.

CreditedInvoiceIdstring

CreditedInvoiceId. Nullable.

Commentstring

Comment. MaxLength: 250. Nullable.

IsForgottenboolean

IsForgotten.

ForgottenByinteger(int32)

ForgottenBy. Nullable.

ForgottenDatestring(date-time)

ForgottenDate. Nullable.

AggregatedInvoiceCodestring

AggregatedInvoiceCode. MaxLength: 100. Nullable.

PaymentMethodCodestring

PaymentMethodCode. MaxLength: 50. Nullable.

PaymentMethodNamestring

PaymentMethodName. MaxLength: 50. Nullable.

ItemsArray of objects(OrderService.InvoiceItem)(OrderService.InvoiceItem)

Items.

Addressobject(OrderService.Address)(OrderService.Address)

InvoiceItem

Idstring

Id. Key property.

InvoiceIdstring

InvoiceId.

LineNumbernumber(decimal)

LineNumber. Nullable.

StatusIdinteger(int32)

StatusId. Nullable.

PartNostring

PartNo. MaxLength: 50. Nullable.

ExternalPartNostring

ExternalPartNo. MaxLength: 50. Nullable.

ProductNamestring

ProductName. MaxLength: 255. Nullable.

StockUnitOfMeasurementCountnumber(decimal)

StockUnitOfMeasurementCount.

PriceUnitOfMeasurementCountnumber(decimal)

PriceUnitOfMeasurementCount.

WarehouseIdinteger(int32)

WarehouseId. Nullable.

LocationIdinteger(int32)

LocationId. Nullable.

Quantityinteger(int32)

Quantity.

CurrencyIdinteger(int32)

CurrencyId.

VatRatenumber(decimal)

VatRate.

CostUnitnumber(decimal)

CostUnit.

PriceSalenumber(decimal)

PriceSale.

DiscountPercentagenumber(decimal)

DiscountPercentage.

DiscountAmountnumber(decimal)

DiscountAmount.

LineAmountnumber(decimal)

LineAmount.

DeliveryModestring

DeliveryMode. MaxLength: 50. Nullable.

IsPartDeliveryboolean

IsPartDelivery.

DeliveryDatestring(date-time)

DeliveryDate. Nullable.

SalesRepContactIdinteger(int32)

SalesRepContactId. Nullable.

LedgerAccountstring

LedgerAccount. MaxLength: 50. Nullable.

Departmentstring

Department. MaxLength: 10. Nullable.

Centrestring

Centre. MaxLength: 10. Nullable.

TransIdstring

TransId.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

OrderItemIdstring

OrderItemId. Nullable.

PurchaseOrderItemIdstring

PurchaseOrderItemId. Nullable.

LineNumberStringstring

LineNumberString. MaxLength: 50. Nullable.

PriceUnitnumber(decimal)

PriceUnit. Nullable.

Quantity2number(decimal)

Quantity2. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

OrderItemobject(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItem)(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItem)

Order

Idstring

Id. Key property.

ClientIdinteger(int32)

ClientId.

ApplicationIdinteger(int32)

ApplicationId. Nullable.

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.

Quotationobject(Enferno.Storm.Query.Api.DataContexts.OrderModel.Quotation)(Enferno.Storm.Query.Api.DataContexts.OrderModel.Quotation)
ItemsArray of objects(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItem)(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItem)

Items.

InfosArray of objects(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderInfo)(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderInfo)

Infos.

Payerobject(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo)(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo)
Buyerobject(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo)(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo)
ShipToobject(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo)(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo)
DropPointobject(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo)(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo)

OrderCustomerInfo

Idstring

Id. Key property.

FirstNamestring

FirstName. MaxLength: 50. Nullable.

LastNamestring

LastName. MaxLength: 50. Nullable.

EmailAddressstring

EmailAddress. MaxLength: 255. Nullable.

PhoneNumberstring

PhoneNumber. MaxLength: 50. Nullable.

CellPhoneNumberstring

CellPhoneNumber. MaxLength: 50. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Rowidstring

Rowid. MaxLength: 8. Nullable.

CompanyNamestring

CompanyName. MaxLength: 100. Nullable.

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.

ClientIdinteger(int32)

ClientId. Nullable.

ShippingPhoneNumberstring

ShippingPhoneNumber. MaxLength: 50. Nullable.

Glnstring

Gln. MaxLength: 50. Nullable.

OrderInfo

OrderIdstring

OrderId. Key property.

TypeIdinteger(int32)

TypeId. Key property.

Valuestring

Value. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

ClientIdinteger(int32)

ClientId. Nullable.

OrderItem

Idstring

Id. Key property.

OrderIdstring

OrderId.

LineNumbernumber(decimal)

LineNumber.

ParentLineNumbernumber(decimal)

ParentLineNumber. Nullable.

StatusIdinteger(int32)

StatusId.

PartNostring

PartNo. MaxLength: 50. Nullable.

ExternalPartNostring

ExternalPartNo. MaxLength: 50. Nullable.

ProductNamestring

ProductName. MaxLength: 255. Nullable.

StockUnitOfMeasurementCountnumber(decimal)

StockUnitOfMeasurementCount.

PriceUnitOfMeasurementCountnumber(decimal)

PriceUnitOfMeasurementCount.

WarehouseIdinteger(int32)

WarehouseId. Nullable.

LocationIdinteger(int32)

LocationId. Nullable.

QtyOrderednumber(decimal)

QtyOrdered.

CurrencyIdinteger(int32)

CurrencyId.

VatRatenumber(decimal)

VatRate.

CostUnitnumber(decimal)

CostUnit.

PriceSalenumber(decimal)

PriceSale.

DiscountPercentagenumber(decimal)

DiscountPercentage.

DiscountAmountnumber(decimal)

DiscountAmount.

LineAmountnumber(decimal)

LineAmount.

DeliveryModestring

DeliveryMode. MaxLength: 50. Nullable.

IsPartDeliveryboolean

IsPartDelivery.

ExpectedDeliveryDatestring(date-time)

ExpectedDeliveryDate. Nullable.

ConfirmedDeliveryDatestring(date-time)

ConfirmedDeliveryDate. Nullable.

SalesRepContactIdinteger(int32)

SalesRepContactId. Nullable.

LedgerAccountstring

LedgerAccount. MaxLength: 50. Nullable.

Departmentstring

Department. MaxLength: 10. Nullable.

Centrestring

Centre. MaxLength: 10. Nullable.

TransIdstring

TransId.

ExternalStatusTextstring

ExternalStatusText. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

LineNumberStringstring

LineNumberString. MaxLength: 50. Nullable.

PriceRecommendednumber(decimal)

PriceRecommended. Nullable.

PriceCatalognumber(decimal)

PriceCatalog. Nullable.

PriceStandardnumber(decimal)

PriceStandard. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

InvoiceItemArray of objects(OrderService.InvoiceItem)(OrderService.InvoiceItem)

InvoiceItem.

InfosArray of objects(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItemInfo)(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItemInfo)

Infos.

OrderItemInfo

OrderItemIdstring

OrderItemId. Key property.

TypeIdinteger(int32)

TypeId. Key property.

Valuestring

Value. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

ClientIdinteger(int32)

ClientId. Nullable.

PurchaseOrder

Idstring

Id. Key property.

ClientIdinteger(int32)

ClientId.

ApplicationIdinteger(int32)

ApplicationId. Nullable.

PurchaseOrderNostring

PurchaseOrderNo. MaxLength: 50. Nullable.

PurchaseOrderDatestring(date-time)

PurchaseOrderDate.

SupplierIdinteger(int32)

SupplierId. Nullable.

SupplierCodestring

SupplierCode. MaxLength: 50. Nullable.

StatusIdinteger(int32)

StatusId.

PurchaseRepContactIdinteger(int32)

PurchaseRepContactId. Nullable.

PurchaseRepContactCodestring

PurchaseRepContactCode. MaxLength: 50. 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. Nullable.

VatCodeIdinteger(int32)

VatCodeId. Nullable.

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.

Commentstring

Comment. Nullable.

SellToCustomerCodestring

SellToCustomerCode. MaxLength: 50. Nullable.

SellToSupplierCustomerCodestring

SellToSupplierCustomerCode. MaxLength: 50. Nullable.

SellToAddressIdstring

SellToAddressId. Nullable.

BillToCustomerCodestring

BillToCustomerCode. MaxLength: 50. Nullable.

BillToSupplierCustomerCodestring

BillToSupplierCustomerCode. MaxLength: 50. Nullable.

BillToAddressIdstring

BillToAddressId. Nullable.

ShipToCustomerCodestring

ShipToCustomerCode. MaxLength: 50. Nullable.

ShipToSupplierCustomerCodestring

ShipToSupplierCustomerCode. MaxLength: 50. Nullable.

ShipToAddressIdstring

ShipToAddressId. Nullable.

ShipToEmailstring

ShipToEmail. MaxLength: 255. Nullable.

ShipToPhonestring

ShipToPhone. MaxLength: 50. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

RowIdstring

RowId. MaxLength: 8. Nullable.

BillToCustomerInfoIdstring

BillToCustomerInfoId. Nullable.

CurrencyCodestring

CurrencyCode. MaxLength: 3. Nullable.

FreightTermsstring

FreightTerms. MaxLength: 255. Nullable.

InternalCommentstring

InternalComment. MaxLength: 255. Nullable.

SupplierStatusIdinteger(int32)

SupplierStatusId. Nullable.

IsForgottenboolean

IsForgotten.

ForgottenByinteger(int32)

ForgottenBy. Nullable.

ForgottenDatestring(date-time)

ForgottenDate. Nullable.

ItemsArray of objects(OrderService.PurchaseOrderItem)(OrderService.PurchaseOrderItem)

Items.

ShipToAddressobject(OrderService.Address)(OrderService.Address)
SellToAddressobject(OrderService.Address)(OrderService.Address)
BillToAddressobject(OrderService.Address)(OrderService.Address)

PurchaseOrderItem

Idstring

Id. Key property.

PurchaseOrderIdstring

PurchaseOrderId.

LineNumbernumber(decimal)

LineNumber. Nullable.

StatusIdinteger(int32)

StatusId.

PartNostring

PartNo. MaxLength: 50. Nullable.

ExternalPartNostring

ExternalPartNo. MaxLength: 50. Nullable.

ProductNamestring

ProductName. MaxLength: 255. Nullable.

StockUnitOfMeasurementCountnumber(decimal)

StockUnitOfMeasurementCount.

PriceUnitOfMeasurementCountnumber(decimal)

PriceUnitOfMeasurementCount.

WarehouseIdinteger(int32)

WarehouseId. Nullable.

LocationIdinteger(int32)

LocationId. Nullable.

QtyOrderednumber(decimal)

QtyOrdered.

CurrencyIdinteger(int32)

CurrencyId. Nullable.

VatCodeIdinteger(int32)

VatCodeId. Nullable.

PriceSalenumber(decimal)

PriceSale.

LineAmountnumber(decimal)

LineAmount. Nullable.

DeliveryModestring

DeliveryMode. MaxLength: 50. Nullable.

IsPartDeliveryboolean

IsPartDelivery.

ExpectedDeliveryDatestring(date-time)

ExpectedDeliveryDate. Nullable.

ConfirmedDeliveryDatestring(date-time)

ConfirmedDeliveryDate. Nullable.

LedgerAccountstring

LedgerAccount. MaxLength: 50. Nullable.

Departmentstring

Department. MaxLength: 10. Nullable.

Centrestring

Centre. MaxLength: 10. Nullable.

SupplierLineReferencestring

SupplierLineReference. MaxLength: 50. Nullable.

OrderTransIdstring

OrderTransId. Nullable.

TransIdstring

TransId. Nullable.

Commentstring

Comment. MaxLength: 255. Nullable.

DeliveryMarkstring

DeliveryMark. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

RowIdstring

RowId. MaxLength: 8. Nullable.

QtyOriginallyOrderednumber(decimal)

QtyOriginallyOrdered. Nullable.

QtyDeliverednumber(decimal)

QtyDelivered. Nullable.

RequestedDeliveryDatestring(date-time)

RequestedDeliveryDate. Nullable.

OrderItemIdstring

OrderItemId. Nullable.

LineNumberStringstring

LineNumberString. MaxLength: 50. Nullable.

ClientProductSkuTypeIdinteger(int32)

ClientProductSkuTypeId. Nullable.

EndUserCodestring

EndUserCode. MaxLength: 50. Nullable.

AgreementCodestring

AgreementCode. MaxLength: 50. Nullable.

InternalCommentstring

InternalComment. MaxLength: 255. Nullable.

SupplierStatusIdinteger(int32)

SupplierStatusId. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

DeliveryNoteItemArray of objects(OrderService.DeliveryNoteItem)(OrderService.DeliveryNoteItem)

DeliveryNoteItem.

Quotation

Idinteger(int32)

Id. Key property.

ApplicationIdinteger(int32)

ApplicationId.

SalesContactIdinteger(int32)

SalesContactId. Nullable.

BuyerAccountKeystring(guid)

BuyerAccountKey.

BuyerAccountIdinteger(int32)

BuyerAccountId. Nullable.

PayerAccountIdinteger(int32)

PayerAccountId. Nullable.

PayerAccountKeystring(guid)

PayerAccountKey. Nullable.

StatusIdinteger(int32)

StatusId.

IsPrimaryboolean

IsPrimary.

Namestring

Name. MaxLength: 50. Nullable.

ValidTostring(date-time)

ValidTo. Nullable.

IsDeletableboolean

IsDeletable.

DeleteDatestring(date-time)

DeleteDate. Nullable.

Commentstring

Comment. MaxLength: 250. Nullable.

RejectionReasonIdinteger(int32)

RejectionReasonId. Nullable.

Modifiedstring(date-time)

Modified. Nullable.

Browsedstring(date-time)

Browsed. Nullable.

PaymentMethodIdinteger(int32)

PaymentMethodId. Nullable.

DeliveryMethodIdinteger(int32)

DeliveryMethodId. Nullable.

IpAddressstring

IpAddress. MaxLength: 50. Nullable.

PayerFirstNamestring

PayerFirstName. MaxLength: 50. Nullable.

PayerMiddleNamestring

PayerMiddleName. MaxLength: 50. Nullable.

PayerLastNamestring

PayerLastName. MaxLength: 50. Nullable.

PayerCellPhoneNumberstring

PayerCellPhoneNumber. MaxLength: 50. Nullable.

PayerEmailstring

PayerEmail. MaxLength: 255. Nullable.

CurrencyIdinteger(int32)

CurrencyId.

ResellerCustomerIdinteger(int32)

ResellerCustomerId. Nullable.

IsLockedboolean

IsLocked. Nullable.

DiscountCodestring

DiscountCode. Nullable.

IsActiveboolean

IsActive. Nullable.

ParentQuotationIdinteger(int32)

ParentQuotationId. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

BuyerCompanyIdinteger(int32)

BuyerCompanyId. Nullable.

PayerCompanyIdinteger(int32)

PayerCompanyId. Nullable.

HasPaymentTransactionboolean

HasPaymentTransaction. Nullable.

BuyerFirstNamestring

BuyerFirstName. MaxLength: 50. Nullable.

BuyerMiddleNamestring

BuyerMiddleName. MaxLength: 50. Nullable.

BuyerLastNamestring

BuyerLastName. MaxLength: 50. Nullable.

BuyerCellPhoneNumberstring

BuyerCellPhoneNumber. MaxLength: 50. Nullable.

BuyerEmailstring

BuyerEmail. MaxLength: 255. Nullable.

CustomerOrderReferencestring

CustomerOrderReference. MaxLength: 50. Nullable.

Createdstring(date-time)

Created. Nullable.

CreatedByinteger(int32)

CreatedBy. Nullable.

ReferIdinteger(int32)

ReferId. Nullable.

ReferUrlstring

ReferUrl. MaxLength: 255. Nullable.

PayerSocialSecurityNumberstring

PayerSocialSecurityNumber. MaxLength: 50. Nullable.

BuyerCustomerIdinteger(int32)

BuyerCustomerId. Nullable.

PayerCustomerIdinteger(int32)

PayerCustomerId. Nullable.

ShipToCustomerIdinteger(int32)

ShipToCustomerId. Nullable.

RowIdstring

RowId. MaxLength: 8. Nullable.

PickupCodestring

PickupCode. MaxLength: 50. Nullable.

AttestedByinteger(int32)

AttestedBy. Nullable.

ModifiedByinteger(int32)

ModifiedBy. Nullable.

TypeIdinteger(int32)

TypeId. Nullable.

DoHoldboolean

DoHold.

DeliveryMethodCodestring

DeliveryMethodCode. MaxLength: 50. Nullable.

FreightPricenumber(decimal)

FreightPrice. Nullable.

InfosArray of objects(Enferno.Storm.Query.Api.DataContexts.OrderModel.QuotationInfo)(Enferno.Storm.Query.Api.DataContexts.OrderModel.QuotationInfo)

Infos.

ItemsArray of objects(OrderService.QuotationItem)(OrderService.QuotationItem)

Items.

AddressesArray of objects(OrderService.QuotationCustomerAddress)(OrderService.QuotationCustomerAddress)

Addresses.

QuotationCustomerAddress

Idinteger(int32)

Id. Key property.

QuotationIdinteger(int32)

QuotationId.

ClientCustomerAddressIdinteger(int32)

ClientCustomerAddressId. Nullable.

ClientCompanyAddressIdinteger(int32)

ClientCompanyAddressId. Nullable.

CustomerIdinteger(int32)

CustomerId. Nullable.

CompanyIdinteger(int32)

CompanyId. Nullable.

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.

CompanyNamestring

CompanyName. MaxLength: 100. Nullable.

FirstNamestring

FirstName. MaxLength: 50. Nullable.

LastNamestring

LastName. MaxLength: 50. Nullable.

CellPhoneNumberstring

CellPhoneNumber. MaxLength: 50. Nullable.

Emailstring

Email. MaxLength: 255. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ShippingPhoneNumberstring

ShippingPhoneNumber. MaxLength: 50. Nullable.

Glnstring

Gln. MaxLength: 50. Nullable.

QuotationInfo

QuotationIdinteger(int32)

QuotationId. Key property.

TypeIdinteger(int32)

TypeId. Key property.

Idstring

Id.

Valuestring

Value. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

ClientIdinteger(int32)

ClientId. Nullable.

QuotationItem

Idinteger(int32)

Id. Key property.

QuotationIdinteger(int32)

QuotationId.

LineNumberinteger(int32)

LineNumber.

CustomerLineCodestring

CustomerLineCode. MaxLength: 50. Nullable.

StatusIdinteger(int32)

StatusId.

PartNostring

PartNo. MaxLength: 50. Nullable.

ProductNameWhenCreatedstring

ProductNameWhenCreated. MaxLength: 255. Nullable.

BundlePartnostring

BundlePartno. MaxLength: 50. Nullable.

BundleTypeIdinteger(int32)

BundleTypeId. Nullable.

Qtyinteger(int32)

Qty.

OnHandWhenCreatedinteger(int32)

OnHandWhenCreated. Nullable.

PriceSalenumber(decimal)

PriceSale. Nullable.

PriceSaleWhenCreatednumber(decimal)

PriceSaleWhenCreated. Nullable.

PriceListIdinteger(int32)

PriceListId.

PatternIdinteger(int32)

PatternId. Nullable.

VatCodeinteger(int32)

VatCode. Nullable.

VatValuenumber(decimal)

VatValue. Nullable.

PromotionIdSeedstring

PromotionIdSeed. MaxLength: 50. Nullable.

CampaignIdinteger(int32)

CampaignId. Nullable.

SearchStringstring

SearchString. MaxLength: 50. Nullable.

CategoryItemIdinteger(int32)

CategoryItemId. Nullable.

ParentPartnoIdstring

ParentPartnoId. MaxLength: 50. Nullable.

ParentLineNumberinteger(int32)

ParentLineNumber. Nullable.

Commentstring

Comment. MaxLength: 255. Nullable.

ExternalDatastring

ExternalData. Nullable.

RefererIdinteger(int32)

RefererId. Nullable.

RefererUrlstring

RefererUrl. MaxLength: 255. Nullable.

PriceResellernumber(decimal)

PriceReseller. Nullable.

IsLockedboolean

IsLocked. Nullable.

TotalPriceSaleExVatnumber(decimal)

TotalPriceSaleExVat. Nullable.

TotalPriceSaleIncVatnumber(decimal)

TotalPriceSaleIncVat. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy. Nullable.

Updatedstring(date-time)

Updated. Nullable.

ExpectedDeliveryDatestring(date-time)

ExpectedDeliveryDate. Nullable.

RequirementPromotionIdSeedstring

RequirementPromotionIdSeed. MaxLength: 255. Nullable.

IsPriceManualboolean

IsPriceManual. Nullable.

Qty2number(decimal)

Qty2. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

InfosArray of objects(OrderService.QuotationItemInfo)(OrderService.QuotationItemInfo)

Infos.

QuotationItemInfo

Idstring

Id. Key property.

QuotationItemIdinteger(int32)

QuotationItemId.

TypeIdinteger(int32)

TypeId.

Valuestring

Value. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

ClientIdinteger(int32)

ClientId. Nullable.

WarehouseTransaction

TransactionNostring

TransactionNo. MaxLength: 50. Nullable.

Idstring

Id. Key property.

TransactionDatestring(date-time)

TransactionDate.

WarehouseCodestring

WarehouseCode. MaxLength: 50. Nullable.

LocationCodestring

LocationCode. MaxLength: 50. Nullable.

Typestring

Type. MaxLength: 50. Nullable.

OrderNostring

OrderNo. MaxLength: 50. Nullable.

PurchaseOrderNostring

PurchaseOrderNo. MaxLength: 50. Nullable.

DeliveryNoteNostring

DeliveryNoteNo. MaxLength: 50. Nullable.

ExternalReferencestring

ExternalReference. MaxLength: 50. Nullable.

ReasonCodestring

ReasonCode. MaxLength: 50. Nullable.

Commentstring

Comment. MaxLength: 500. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

ItemsArray of objects(Enferno.Storm.Query.Api.DataContexts.OrderModel.WarehouseTransactionItem)(Enferno.Storm.Query.Api.DataContexts.OrderModel.WarehouseTransactionItem)

Items.

WarehouseTransactionItem

WarehouseTransactionIdstring

WarehouseTransactionId.

Idstring

Id. Key property.

LineNumbernumber(decimal)

LineNumber.

PartNostring

PartNo. MaxLength: 50. Nullable.

Qtynumber(decimal)

Qty.

Amountnumber(decimal)

Amount.

RemainingQtynumber(decimal)

RemainingQty. Nullable.

RemainingAmountnumber(decimal)

RemainingAmount. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Previous page
Next page