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
| Id | string Id. Key property. |
| TypeId | integer <int32> TypeId. Nullable. |
| Name | string Name. MaxLength: 100. Nullable. |
| Attention | string Attention. MaxLength: 100. Nullable. |
| CareOf | string CareOf. MaxLength: 100. Nullable. |
| Line1 | string Line1. MaxLength: 255. Nullable. |
| Line2 | string Line2. 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. |
| RowId | string RowId. MaxLength: 8. Nullable. |
| EmailAddress | string EmailAddress. MaxLength: 255. Nullable. |
| PhoneNumber | string PhoneNumber. MaxLength: 50. Nullable. |
| ClientId | integer <int32> ClientId. Nullable. |
| ShippingPhoneNumber | string ShippingPhoneNumber. MaxLength: 50. Nullable. |
| Gln | string Gln. MaxLength: 50. Nullable. |
DeliveryNote
| Id | string Id. Key property. |
| ClientId | integer <int32> ClientId. |
| NoteNo | string NoteNo. MaxLength: 50. Nullable. |
| SupplierId | integer <int32> SupplierId. Nullable. |
| TypeId | integer <int32> TypeId. |
| ReferenceOrderId | string ReferenceOrderId. |
| BuyerCompanyId | integer <int32> BuyerCompanyId. Nullable. |
| BuyerCompanyCode | string BuyerCompanyCode. MaxLength: 50. Nullable. |
| BuyerCustomerId | integer <int32> BuyerCustomerId. Nullable. |
| BuyerCustomerCode | string BuyerCustomerCode. MaxLength: 50. Nullable. |
| PayerCompanyId | integer <int32> PayerCompanyId. Nullable. |
| PayerCompanyCode | string PayerCompanyCode. MaxLength: 50. Nullable. |
| PayerCustomerId | integer <int32> PayerCustomerId. Nullable. |
| PayerCustomerCode | string PayerCustomerCode. MaxLength: 50. Nullable. |
| ResellerCompanyId | integer <int32> ResellerCompanyId. Nullable. |
| ResellerCompanyCode | string ResellerCompanyCode. MaxLength: 50. Nullable. |
| ResellerCustomerId | integer <int32> ResellerCustomerId. Nullable. |
| ResellerCustomerCode | string ResellerCustomerCode. MaxLength: 50. Nullable. |
| GroupCode | string GroupCode. MaxLength: 50. Nullable. |
| DeliveryName | string DeliveryName. MaxLength: 100. Nullable. |
| 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. |
| DeliveryDate | string <date-time> DeliveryDate. Nullable. |
| Quantity | number <decimal> Quantity. Nullable. |
| Volume | number <decimal> Volume. Nullable. |
| Weight | number <decimal> Weight. Nullable. |
| IsPrinted | boolean IsPrinted. |
| DeliveryTerms | string DeliveryTerms. MaxLength: 10. Nullable. |
| DeliveryMode | string DeliveryMode. MaxLength: 50. Nullable. |
| Source | string Source. MaxLength: 255. Nullable. |
| DeliveryMark | string DeliveryMark. MaxLength: 255. Nullable. |
| NoteText | string NoteText. MaxLength: 255. Nullable. |
| Department | string Department. MaxLength: 10. Nullable. |
| Centre | string Centre. MaxLength: 10. Nullable. |
| ShippingNo | string ShippingNo. MaxLength: 50. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
| DeliveryAddressId | string DeliveryAddressId. Nullable. |
| DivisionCode | string DivisionCode. MaxLength: 50. Nullable. |
| StatusId | integer <int32> StatusId. |
| IsForgotten | boolean IsForgotten. |
| ForgottenBy | integer <int32> ForgottenBy. Nullable. |
| ForgottenDate | string <date-time> ForgottenDate. Nullable. |
Array of objects <OrderService.DeliveryNoteItem> (OrderService.DeliveryNoteItem) Items. | |
Array of objects <OrderService.DeliveryNotePackage> (OrderService.DeliveryNotePackage) Packages. |
DeliveryNoteItem
| Id | string Id. Key property. |
| DeliveryNoteId | string DeliveryNoteId. |
| LineNumber | number <decimal> LineNumber. Nullable. |
| PartNo | string PartNo. MaxLength: 50. Nullable. |
| ExternalPartNo | string ExternalPartNo. MaxLength: 50. Nullable. |
| ProductName | string ProductName. MaxLength: 255. Nullable. |
| StockUnitOfMeasurementCount | number <decimal> StockUnitOfMeasurementCount. |
| PriceUnitOfMeasurementCount | number <decimal> PriceUnitOfMeasurementCount. |
| QtyOrdered | number <decimal> QtyOrdered. |
| Quantity | number <decimal> Quantity. |
| QtyBackOrdered | number <decimal> QtyBackOrdered. |
| IsPartDelivery | boolean IsPartDelivery. |
| SalesRepContactId | integer <int32> SalesRepContactId. Nullable. |
| VatRate | number <decimal> VatRate. |
| ValueMst | number <decimal> ValueMst. |
| NoteText | string NoteText. MaxLength: 255. Nullable. |
| Department | string Department. MaxLength: 10. Nullable. |
| Centre | string Centre. MaxLength: 10. Nullable. |
| TransId | integer <int32> TransId. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
| OrderItemId | string OrderItemId. Nullable. |
| PurchaseOrderItemId | string PurchaseOrderItemId. Nullable. |
| LineNumberString | string LineNumberString. MaxLength: 50. Nullable. |
| ClientId | integer <int32> ClientId. Nullable. |
object <OrderService.PurchaseOrderItem> (OrderService.PurchaseOrderItem) |
DeliveryNotePackage
| Id | string Id. Key property. |
| DeliveryNoteId | string DeliveryNoteId. |
| ShippingNo | string ShippingNo. MaxLength: 255. 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. |
| ClientId | integer <int32> ClientId. Nullable. |
Invoice
| Id | string Id. Key property. |
| ClientId | integer <int32> ClientId. |
| InvoiceNo | string InvoiceNo. MaxLength: 50. Nullable. |
| TypeId | integer <int32> TypeId. |
| ReferenceOrderId | string ReferenceOrderId. |
| BuyerCompanyId | integer <int32> BuyerCompanyId. Nullable. |
| BuyerCustomerId | integer <int32> BuyerCustomerId. Nullable. |
| PayerCompanyId | integer <int32> PayerCompanyId. Nullable. |
| PayerCustomerId | integer <int32> PayerCustomerId. Nullable. |
| ResellerCompanyId | integer <int32> ResellerCompanyId. Nullable. |
| ResellerCustomerId | integer <int32> ResellerCustomerId. Nullable. |
| GroupCode | string GroupCode. MaxLength: 50. Nullable. |
| DeliveryDate | string <date-time> DeliveryDate. Nullable. |
| InvoiceDate | string <date-time> InvoiceDate. |
| InvoiceDueDate | string <date-time> InvoiceDueDate. Nullable. |
| SalesRepContactId | integer <int32> SalesRepContactId. Nullable. |
| Source | string Source. MaxLength: 255. Nullable. |
| Quantity | number <decimal> Quantity. |
| Volume | number <decimal> Volume. Nullable. |
| Weight | number <decimal> Weight. Nullable. |
| CurrencyId | integer <int32> CurrencyId. |
| CurrencyRate | number <decimal> CurrencyRate. |
| CashDiscount | number <decimal> CashDiscount. |
| CashDiscountDate | string <date-time> CashDiscountDate. Nullable. |
| SumLineDiscount | number <decimal> SumLineDiscount. |
| FreightCost | number <decimal> FreightCost. |
| InvoiceFee | number <decimal> InvoiceFee. |
| CostValue | number <decimal> CostValue. |
| SalesBalance | number <decimal> SalesBalance. |
| InvoiceAmount | number <decimal> InvoiceAmount. |
| InvoiceRoundOff | number <decimal> InvoiceRoundOff. |
| VatDutiable1 | number <decimal> VatDutiable1. |
| VatDutiable2 | number <decimal> VatDutiable2. |
| VatDutiable3 | number <decimal> VatDutiable3. |
| Vat1 | number <decimal> Vat1. |
| Vat2 | number <decimal> Vat2. |
| Vat3 | number <decimal> Vat3. |
| VatRoundOff | number <decimal> VatRoundOff. |
| Vat | number <decimal> Vat. |
| InvoiceName | string InvoiceName. MaxLength: 255. Nullable. |
| InvoiceAttention | string InvoiceAttention. MaxLength: 100. Nullable. |
| InvoiceCareOf | string InvoiceCareOf. MaxLength: 100. Nullable. |
| InvoiceAddressLine1 | string InvoiceAddressLine1. MaxLength: 255. Nullable. |
| InvoiceAddressLine2 | string InvoiceAddressLine2. MaxLength: 255. Nullable. |
| InvoiceZipCode | string InvoiceZipCode. MaxLength: 50. Nullable. |
| InvoiceCity | string InvoiceCity. MaxLength: 50. Nullable. |
| InvoiceRegion | string InvoiceRegion. MaxLength: 100. Nullable. |
| InvoiceCountryId | integer <int32> InvoiceCountryId. Nullable. |
| LedgerVoucher | string LedgerVoucher. MaxLength: 50. Nullable. |
| Department | string Department. MaxLength: 10. Nullable. |
| Centre | string Centre. MaxLength: 10. Nullable. |
| NoteText | string NoteText. MaxLength: 255. Nullable. |
| LastInvoiceForOrder | boolean LastInvoiceForOrder. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
| InvoiceAddressId | string InvoiceAddressId. Nullable. |
| ReferenceNoPsp | string ReferenceNoPsp. MaxLength: 50. Nullable. |
| PaymentMethodId | integer <int32> PaymentMethodId. Nullable. |
| DeliveryMethodId | integer <int32> DeliveryMethodId. Nullable. |
| IsDebit | boolean IsDebit. Nullable. |
| CreditedInvoiceId | string CreditedInvoiceId. Nullable. |
| Comment | string Comment. MaxLength: 250. Nullable. |
| IsForgotten | boolean IsForgotten. |
| ForgottenBy | integer <int32> ForgottenBy. Nullable. |
| ForgottenDate | string <date-time> ForgottenDate. Nullable. |
| AggregatedInvoiceCode | string AggregatedInvoiceCode. MaxLength: 100. Nullable. |
| PaymentMethodCode | string PaymentMethodCode. MaxLength: 50. Nullable. |
| PaymentMethodName | string PaymentMethodName. MaxLength: 50. Nullable. |
Array of objects <OrderService.InvoiceItem> (OrderService.InvoiceItem) Items. | |
object <OrderService.Address> (OrderService.Address) |
InvoiceItem
| Id | string Id. Key property. |
| InvoiceId | string InvoiceId. |
| LineNumber | number <decimal> LineNumber. Nullable. |
| StatusId | integer <int32> StatusId. Nullable. |
| PartNo | string PartNo. MaxLength: 50. Nullable. |
| ExternalPartNo | string ExternalPartNo. MaxLength: 50. Nullable. |
| ProductName | string ProductName. MaxLength: 255. Nullable. |
| StockUnitOfMeasurementCount | number <decimal> StockUnitOfMeasurementCount. |
| PriceUnitOfMeasurementCount | number <decimal> PriceUnitOfMeasurementCount. |
| WarehouseId | integer <int32> WarehouseId. Nullable. |
| LocationId | integer <int32> LocationId. Nullable. |
| Quantity | integer <int32> Quantity. |
| CurrencyId | integer <int32> CurrencyId. |
| VatRate | number <decimal> VatRate. |
| CostUnit | number <decimal> CostUnit. |
| PriceSale | number <decimal> PriceSale. |
| DiscountPercentage | number <decimal> DiscountPercentage. |
| DiscountAmount | number <decimal> DiscountAmount. |
| LineAmount | number <decimal> LineAmount. |
| DeliveryMode | string DeliveryMode. MaxLength: 50. Nullable. |
| IsPartDelivery | boolean IsPartDelivery. |
| DeliveryDate | string <date-time> DeliveryDate. Nullable. |
| SalesRepContactId | integer <int32> SalesRepContactId. Nullable. |
| LedgerAccount | string LedgerAccount. MaxLength: 50. Nullable. |
| Department | string Department. MaxLength: 10. Nullable. |
| Centre | string Centre. MaxLength: 10. Nullable. |
| TransId | string TransId. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
| OrderItemId | string OrderItemId. Nullable. |
| PurchaseOrderItemId | string PurchaseOrderItemId. Nullable. |
| LineNumberString | string LineNumberString. MaxLength: 50. Nullable. |
| PriceUnit | number <decimal> PriceUnit. Nullable. |
| Quantity2 | number <decimal> Quantity2. Nullable. |
| ClientId | integer <int32> ClientId. Nullable. |
object <Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItem> (Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItem) |
Order
| Id | string Id. Key property. |
| ClientId | integer <int32> ClientId. |
| ApplicationId | integer <int32> ApplicationId. Nullable. |
| 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. |
object <Enferno.Storm.Query.Api.DataContexts.OrderModel.Quotation> (Enferno.Storm.Query.Api.DataContexts.OrderModel.Quotation) | |
Array of objects <Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItem> (Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItem) Items. | |
Array of objects <Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderInfo> (Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderInfo) Infos. | |
object <Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo> (Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo) | |
object <Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo> (Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo) | |
object <Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo> (Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo) | |
object <Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo> (Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderCustomerInfo) |
OrderCustomerInfo
| Id | string Id. Key property. |
| FirstName | string FirstName. MaxLength: 50. Nullable. |
| LastName | string LastName. MaxLength: 50. Nullable. |
| EmailAddress | string EmailAddress. MaxLength: 255. Nullable. |
| PhoneNumber | string PhoneNumber. MaxLength: 50. Nullable. |
| CellPhoneNumber | string CellPhoneNumber. MaxLength: 50. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Rowid | string Rowid. MaxLength: 8. Nullable. |
| CompanyName | string CompanyName. MaxLength: 100. Nullable. |
| 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. |
| ClientId | integer <int32> ClientId. Nullable. |
| ShippingPhoneNumber | string ShippingPhoneNumber. MaxLength: 50. Nullable. |
| Gln | string Gln. MaxLength: 50. Nullable. |
OrderInfo
| OrderId | string OrderId. Key property. |
| TypeId | integer <int32> TypeId. Key property. |
| Value | string Value. Nullable. |
| Updated | string <date-time> Updated. |
| UpdatedBy | integer <int32> UpdatedBy. |
| ClientId | integer <int32> ClientId. Nullable. |
OrderItem
| Id | string Id. Key property. |
| OrderId | string OrderId. |
| LineNumber | number <decimal> LineNumber. |
| ParentLineNumber | number <decimal> ParentLineNumber. Nullable. |
| StatusId | integer <int32> StatusId. |
| PartNo | string PartNo. MaxLength: 50. Nullable. |
| ExternalPartNo | string ExternalPartNo. MaxLength: 50. Nullable. |
| ProductName | string ProductName. MaxLength: 255. Nullable. |
| StockUnitOfMeasurementCount | number <decimal> StockUnitOfMeasurementCount. |
| PriceUnitOfMeasurementCount | number <decimal> PriceUnitOfMeasurementCount. |
| WarehouseId | integer <int32> WarehouseId. Nullable. |
| LocationId | integer <int32> LocationId. Nullable. |
| QtyOrdered | number <decimal> QtyOrdered. |
| CurrencyId | integer <int32> CurrencyId. |
| VatRate | number <decimal> VatRate. |
| CostUnit | number <decimal> CostUnit. |
| PriceSale | number <decimal> PriceSale. |
| DiscountPercentage | number <decimal> DiscountPercentage. |
| DiscountAmount | number <decimal> DiscountAmount. |
| LineAmount | number <decimal> LineAmount. |
| DeliveryMode | string DeliveryMode. MaxLength: 50. Nullable. |
| IsPartDelivery | boolean IsPartDelivery. |
| ExpectedDeliveryDate | string <date-time> ExpectedDeliveryDate. Nullable. |
| ConfirmedDeliveryDate | string <date-time> ConfirmedDeliveryDate. Nullable. |
| SalesRepContactId | integer <int32> SalesRepContactId. Nullable. |
| LedgerAccount | string LedgerAccount. MaxLength: 50. Nullable. |
| Department | string Department. MaxLength: 10. Nullable. |
| Centre | string Centre. MaxLength: 10. Nullable. |
| TransId | string TransId. |
| ExternalStatusText | string ExternalStatusText. MaxLength: 255. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
| LineNumberString | string LineNumberString. MaxLength: 50. Nullable. |
| PriceRecommended | number <decimal> PriceRecommended. Nullable. |
| PriceCatalog | number <decimal> PriceCatalog. Nullable. |
| PriceStandard | number <decimal> PriceStandard. Nullable. |
| ClientId | integer <int32> ClientId. Nullable. |
Array of objects <OrderService.InvoiceItem> (OrderService.InvoiceItem) InvoiceItem. | |
Array of objects <Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItemInfo> (Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItemInfo) Infos. |
OrderItemInfo
| OrderItemId | string OrderItemId. Key property. |
| TypeId | integer <int32> TypeId. Key property. |
| Value | string Value. Nullable. |
| Updated | string <date-time> Updated. |
| UpdatedBy | integer <int32> UpdatedBy. |
| ClientId | integer <int32> ClientId. Nullable. |
PurchaseOrder
| Id | string Id. Key property. |
| ClientId | integer <int32> ClientId. |
| ApplicationId | integer <int32> ApplicationId. Nullable. |
| PurchaseOrderNo | string PurchaseOrderNo. MaxLength: 50. Nullable. |
| PurchaseOrderDate | string <date-time> PurchaseOrderDate. |
| SupplierId | integer <int32> SupplierId. Nullable. |
| SupplierCode | string SupplierCode. MaxLength: 50. Nullable. |
| StatusId | integer <int32> StatusId. |
| PurchaseRepContactId | integer <int32> PurchaseRepContactId. Nullable. |
| PurchaseRepContactCode | string PurchaseRepContactCode. MaxLength: 50. 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. Nullable. |
| VatCodeId | integer <int32> VatCodeId. Nullable. |
| 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. |
| Comment | string Comment. Nullable. |
| SellToCustomerCode | string SellToCustomerCode. MaxLength: 50. Nullable. |
| SellToSupplierCustomerCode | string SellToSupplierCustomerCode. MaxLength: 50. Nullable. |
| SellToAddressId | string SellToAddressId. Nullable. |
| BillToCustomerCode | string BillToCustomerCode. MaxLength: 50. Nullable. |
| BillToSupplierCustomerCode | string BillToSupplierCustomerCode. MaxLength: 50. Nullable. |
| BillToAddressId | string BillToAddressId. Nullable. |
| ShipToCustomerCode | string ShipToCustomerCode. MaxLength: 50. Nullable. |
| ShipToSupplierCustomerCode | string ShipToSupplierCustomerCode. MaxLength: 50. Nullable. |
| ShipToAddressId | string ShipToAddressId. Nullable. |
| ShipToEmail | string ShipToEmail. MaxLength: 255. Nullable. |
| ShipToPhone | string ShipToPhone. MaxLength: 50. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
| RowId | string RowId. MaxLength: 8. Nullable. |
| BillToCustomerInfoId | string BillToCustomerInfoId. Nullable. |
| CurrencyCode | string CurrencyCode. MaxLength: 3. Nullable. |
| FreightTerms | string FreightTerms. MaxLength: 255. Nullable. |
| InternalComment | string InternalComment. MaxLength: 255. Nullable. |
| SupplierStatusId | integer <int32> SupplierStatusId. Nullable. |
| IsForgotten | boolean IsForgotten. |
| ForgottenBy | integer <int32> ForgottenBy. Nullable. |
| ForgottenDate | string <date-time> ForgottenDate. Nullable. |
Array of objects <OrderService.PurchaseOrderItem> (OrderService.PurchaseOrderItem) Items. | |
object <OrderService.Address> (OrderService.Address) | |
object <OrderService.Address> (OrderService.Address) | |
object <OrderService.Address> (OrderService.Address) |
PurchaseOrderItem
| Id | string Id. Key property. |
| PurchaseOrderId | string PurchaseOrderId. |
| LineNumber | number <decimal> LineNumber. Nullable. |
| StatusId | integer <int32> StatusId. |
| PartNo | string PartNo. MaxLength: 50. Nullable. |
| ExternalPartNo | string ExternalPartNo. MaxLength: 50. Nullable. |
| ProductName | string ProductName. MaxLength: 255. Nullable. |
| StockUnitOfMeasurementCount | number <decimal> StockUnitOfMeasurementCount. |
| PriceUnitOfMeasurementCount | number <decimal> PriceUnitOfMeasurementCount. |
| WarehouseId | integer <int32> WarehouseId. Nullable. |
| LocationId | integer <int32> LocationId. Nullable. |
| QtyOrdered | number <decimal> QtyOrdered. |
| CurrencyId | integer <int32> CurrencyId. Nullable. |
| VatCodeId | integer <int32> VatCodeId. Nullable. |
| PriceSale | number <decimal> PriceSale. |
| LineAmount | number <decimal> LineAmount. Nullable. |
| DeliveryMode | string DeliveryMode. MaxLength: 50. Nullable. |
| IsPartDelivery | boolean IsPartDelivery. |
| ExpectedDeliveryDate | string <date-time> ExpectedDeliveryDate. Nullable. |
| ConfirmedDeliveryDate | string <date-time> ConfirmedDeliveryDate. Nullable. |
| LedgerAccount | string LedgerAccount. MaxLength: 50. Nullable. |
| Department | string Department. MaxLength: 10. Nullable. |
| Centre | string Centre. MaxLength: 10. Nullable. |
| SupplierLineReference | string SupplierLineReference. MaxLength: 50. Nullable. |
| OrderTransId | string OrderTransId. Nullable. |
| TransId | string TransId. Nullable. |
| Comment | string Comment. MaxLength: 255. Nullable. |
| DeliveryMark | string DeliveryMark. MaxLength: 255. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
| RowId | string RowId. MaxLength: 8. Nullable. |
| QtyOriginallyOrdered | number <decimal> QtyOriginallyOrdered. Nullable. |
| QtyDelivered | number <decimal> QtyDelivered. Nullable. |
| RequestedDeliveryDate | string <date-time> RequestedDeliveryDate. Nullable. |
| OrderItemId | string OrderItemId. Nullable. |
| LineNumberString | string LineNumberString. MaxLength: 50. Nullable. |
| ClientProductSkuTypeId | integer <int32> ClientProductSkuTypeId. Nullable. |
| EndUserCode | string EndUserCode. MaxLength: 50. Nullable. |
| AgreementCode | string AgreementCode. MaxLength: 50. Nullable. |
| InternalComment | string InternalComment. MaxLength: 255. Nullable. |
| SupplierStatusId | integer <int32> SupplierStatusId. Nullable. |
| ClientId | integer <int32> ClientId. Nullable. |
Array of objects <OrderService.DeliveryNoteItem> (OrderService.DeliveryNoteItem) DeliveryNoteItem. |
Quotation
| Id | integer <int32> Id. Key property. |
| ApplicationId | integer <int32> ApplicationId. |
| SalesContactId | integer <int32> SalesContactId. Nullable. |
| BuyerAccountKey | string <guid> BuyerAccountKey. |
| BuyerAccountId | integer <int32> BuyerAccountId. Nullable. |
| PayerAccountId | integer <int32> PayerAccountId. Nullable. |
| PayerAccountKey | string <guid> PayerAccountKey. Nullable. |
| StatusId | integer <int32> StatusId. |
| IsPrimary | boolean IsPrimary. |
| Name | string Name. MaxLength: 50. Nullable. |
| ValidTo | string <date-time> ValidTo. Nullable. |
| IsDeletable | boolean IsDeletable. |
| DeleteDate | string <date-time> DeleteDate. Nullable. |
| Comment | string Comment. MaxLength: 250. Nullable. |
| RejectionReasonId | integer <int32> RejectionReasonId. Nullable. |
| Modified | string <date-time> Modified. Nullable. |
| Browsed | string <date-time> Browsed. Nullable. |
| PaymentMethodId | integer <int32> PaymentMethodId. Nullable. |
| DeliveryMethodId | integer <int32> DeliveryMethodId. Nullable. |
| IpAddress | string IpAddress. MaxLength: 50. Nullable. |
| PayerFirstName | string PayerFirstName. MaxLength: 50. Nullable. |
| PayerMiddleName | string PayerMiddleName. MaxLength: 50. Nullable. |
| PayerLastName | string PayerLastName. MaxLength: 50. Nullable. |
| PayerCellPhoneNumber | string PayerCellPhoneNumber. MaxLength: 50. Nullable. |
| PayerEmail | string PayerEmail. MaxLength: 255. Nullable. |
| CurrencyId | integer <int32> CurrencyId. |
| ResellerCustomerId | integer <int32> ResellerCustomerId. Nullable. |
| IsLocked | boolean IsLocked. Nullable. |
| DiscountCode | string DiscountCode. Nullable. |
| IsActive | boolean IsActive. Nullable. |
| ParentQuotationId | integer <int32> ParentQuotationId. Nullable. |
| ClientId | integer <int32> ClientId. Nullable. |
| BuyerCompanyId | integer <int32> BuyerCompanyId. Nullable. |
| PayerCompanyId | integer <int32> PayerCompanyId. Nullable. |
| HasPaymentTransaction | boolean HasPaymentTransaction. Nullable. |
| BuyerFirstName | string BuyerFirstName. MaxLength: 50. Nullable. |
| BuyerMiddleName | string BuyerMiddleName. MaxLength: 50. Nullable. |
| BuyerLastName | string BuyerLastName. MaxLength: 50. Nullable. |
| BuyerCellPhoneNumber | string BuyerCellPhoneNumber. MaxLength: 50. Nullable. |
| BuyerEmail | string BuyerEmail. MaxLength: 255. Nullable. |
| CustomerOrderReference | string CustomerOrderReference. MaxLength: 50. Nullable. |
| Created | string <date-time> Created. Nullable. |
| CreatedBy | integer <int32> CreatedBy. Nullable. |
| ReferId | integer <int32> ReferId. Nullable. |
| ReferUrl | string ReferUrl. MaxLength: 255. Nullable. |
| PayerSocialSecurityNumber | string PayerSocialSecurityNumber. MaxLength: 50. Nullable. |
| BuyerCustomerId | integer <int32> BuyerCustomerId. Nullable. |
| PayerCustomerId | integer <int32> PayerCustomerId. Nullable. |
| ShipToCustomerId | integer <int32> ShipToCustomerId. Nullable. |
| RowId | string RowId. MaxLength: 8. Nullable. |
| PickupCode | string PickupCode. MaxLength: 50. Nullable. |
| AttestedBy | integer <int32> AttestedBy. Nullable. |
| ModifiedBy | integer <int32> ModifiedBy. Nullable. |
| TypeId | integer <int32> TypeId. Nullable. |
| DoHold | boolean DoHold. |
| DeliveryMethodCode | string DeliveryMethodCode. MaxLength: 50. Nullable. |
| FreightPrice | number <decimal> FreightPrice. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.OrderModel.QuotationInfo> (Enferno.Storm.Query.Api.DataContexts.OrderModel.QuotationInfo) Infos. | |
Array of objects <OrderService.QuotationItem> (OrderService.QuotationItem) Items. | |
Array of objects <OrderService.QuotationCustomerAddress> (OrderService.QuotationCustomerAddress) Addresses. |
QuotationCustomerAddress
| Id | integer <int32> Id. Key property. |
| QuotationId | integer <int32> QuotationId. |
| ClientCustomerAddressId | integer <int32> ClientCustomerAddressId. Nullable. |
| ClientCompanyAddressId | integer <int32> ClientCompanyAddressId. Nullable. |
| CustomerId | integer <int32> CustomerId. Nullable. |
| CompanyId | integer <int32> CompanyId. Nullable. |
| 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. |
| CompanyName | string CompanyName. MaxLength: 100. Nullable. |
| FirstName | string FirstName. MaxLength: 50. Nullable. |
| LastName | string LastName. MaxLength: 50. Nullable. |
| CellPhoneNumber | string CellPhoneNumber. MaxLength: 50. Nullable. |
string Email. MaxLength: 255. Nullable. | |
| ClientId | integer <int32> ClientId. Nullable. |
| ShippingPhoneNumber | string ShippingPhoneNumber. MaxLength: 50. Nullable. |
| Gln | string Gln. MaxLength: 50. Nullable. |
QuotationInfo
| QuotationId | integer <int32> QuotationId. Key property. |
| TypeId | integer <int32> TypeId. Key property. |
| Id | string Id. |
| Value | string Value. Nullable. |
| Updated | string <date-time> Updated. |
| UpdatedBy | integer <int32> UpdatedBy. |
| ClientId | integer <int32> ClientId. Nullable. |
QuotationItem
| Id | integer <int32> Id. Key property. |
| QuotationId | integer <int32> QuotationId. |
| LineNumber | integer <int32> LineNumber. |
| CustomerLineCode | string CustomerLineCode. MaxLength: 50. Nullable. |
| StatusId | integer <int32> StatusId. |
| PartNo | string PartNo. MaxLength: 50. Nullable. |
| ProductNameWhenCreated | string ProductNameWhenCreated. MaxLength: 255. Nullable. |
| BundlePartno | string BundlePartno. MaxLength: 50. Nullable. |
| BundleTypeId | integer <int32> BundleTypeId. Nullable. |
| Qty | integer <int32> Qty. |
| OnHandWhenCreated | integer <int32> OnHandWhenCreated. Nullable. |
| PriceSale | number <decimal> PriceSale. Nullable. |
| PriceSaleWhenCreated | number <decimal> PriceSaleWhenCreated. Nullable. |
| PriceListId | integer <int32> PriceListId. |
| PatternId | integer <int32> PatternId. Nullable. |
| VatCode | integer <int32> VatCode. Nullable. |
| VatValue | number <decimal> VatValue. Nullable. |
| PromotionIdSeed | string PromotionIdSeed. MaxLength: 50. Nullable. |
| CampaignId | integer <int32> CampaignId. Nullable. |
| SearchString | string SearchString. MaxLength: 50. Nullable. |
| CategoryItemId | integer <int32> CategoryItemId. Nullable. |
| ParentPartnoId | string ParentPartnoId. MaxLength: 50. Nullable. |
| ParentLineNumber | integer <int32> ParentLineNumber. Nullable. |
| Comment | string Comment. MaxLength: 255. Nullable. |
| ExternalData | string ExternalData. Nullable. |
| RefererId | integer <int32> RefererId. Nullable. |
| RefererUrl | string RefererUrl. MaxLength: 255. Nullable. |
| PriceReseller | number <decimal> PriceReseller. Nullable. |
| IsLocked | boolean IsLocked. Nullable. |
| TotalPriceSaleExVat | number <decimal> TotalPriceSaleExVat. Nullable. |
| TotalPriceSaleIncVat | number <decimal> TotalPriceSaleIncVat. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| ExpectedDeliveryDate | string <date-time> ExpectedDeliveryDate. Nullable. |
| RequirementPromotionIdSeed | string RequirementPromotionIdSeed. MaxLength: 255. Nullable. |
| IsPriceManual | boolean IsPriceManual. Nullable. |
| Qty2 | number <decimal> Qty2. Nullable. |
| ClientId | integer <int32> ClientId. Nullable. |
Array of objects <OrderService.QuotationItemInfo> (OrderService.QuotationItemInfo) Infos. |
QuotationItemInfo
| Id | string Id. Key property. |
| QuotationItemId | integer <int32> QuotationItemId. |
| TypeId | integer <int32> TypeId. |
| Value | string Value. Nullable. |
| Updated | string <date-time> Updated. |
| UpdatedBy | integer <int32> UpdatedBy. |
| ClientId | integer <int32> ClientId. Nullable. |
WarehouseTransaction
| TransactionNo | string TransactionNo. MaxLength: 50. Nullable. |
| Id | string Id. Key property. |
| TransactionDate | string <date-time> TransactionDate. |
| WarehouseCode | string WarehouseCode. MaxLength: 50. Nullable. |
| LocationCode | string LocationCode. MaxLength: 50. Nullable. |
| Type | string Type. MaxLength: 50. Nullable. |
| OrderNo | string OrderNo. MaxLength: 50. Nullable. |
| PurchaseOrderNo | string PurchaseOrderNo. MaxLength: 50. Nullable. |
| DeliveryNoteNo | string DeliveryNoteNo. MaxLength: 50. Nullable. |
| ExternalReference | string ExternalReference. MaxLength: 50. Nullable. |
| ReasonCode | string ReasonCode. MaxLength: 50. Nullable. |
| Comment | string Comment. MaxLength: 500. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.OrderModel.WarehouseTransactionItem> (Enferno.Storm.Query.Api.DataContexts.OrderModel.WarehouseTransactionItem) Items. |
WarehouseTransactionItem
| WarehouseTransactionId | string WarehouseTransactionId. |
| Id | string Id. Key property. |
| LineNumber | number <decimal> LineNumber. |
| PartNo | string PartNo. MaxLength: 50. Nullable. |
| Qty | number <decimal> Qty. |
| Amount | number <decimal> Amount. |
| RemainingQty | number <decimal> RemainingQty. Nullable. |
| RemainingAmount | number <decimal> RemainingAmount. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |