Weclapp

Number of shipments by shipment method

SQL query for WeClapp

Count the number of shipments for each shipment method.

SELECT shipmentMethod.name, COUNT(shipment.id) AS shipment_count FROM shipment INNER JOIN shipmentMethod ON shipment.methodId = shipmentMethod.id GROUP BY shipmentMethod.name

WeClapp data model

Weclapp
Table Accounting Transaction
Id: String
Type: String
Draft: Boolean
Status: String
Version: String
CurrencyId: String
CreatedDate: Date-time
CurrencyName: String
TransactionDate: Integer
LastModifiedDate: Date-time
TransactionNumber: String
ReverseTransaction: Boolean
TransactionDetails: String
ExternalRecordNumber: String
InternalRecordNumber: String
TransactionEstablishDate: Integer
TransactionDetails_0_taxId: String
TransactionDetails_1_taxId: String
TransactionDetails_0_amount: String
TransactionDetails_1_amount: String
TransactionDetails_2_amount: String
TransactionDetails_0_accountId: String
TransactionDetails_1_accountId: String
TransactionDetails_2_accountId: String
TransactionDetails_0_debitCredit: String
TransactionDetails_0_description: String
TransactionDetails_1_debitCredit: String
TransactionDetails_1_description: String
TransactionDetails_2_debitCredit: String
TransactionDetails_2_description: String

Weclapp
Table Article
Id: String
Name: String
Active: Boolean
UnitId: String
Version: String
UnitName: String
AccountId: String
ArticleType: String
CreatedDate: Date-time
Description: String
TaxRateType: String
InternalNote: String
LowLevelCode: Integer
AccountNumber: String
ArticleNumber: String
InvoicingType: String
CommissionRate: String
ManufacturerId: String
AvailableInSale: Boolean
LastModifiedDate: Date-time
ManufacturerName: String
ApplyCashDiscount: Boolean
ArticleCategoryId: String
ProductionArticle: Boolean
ShortDescription1: String
ArticlePrices_0_id: String
ArticlePrices_1_id: String
ArticlePrices_2_id: String
ArticlePrices_3_id: String
ShowOnDeliveryNote: Boolean
SupplySources_0_id: String
AverageDeliveryTime: Integer
BatchNumberRequired: Boolean
CountryOfOriginCode: String
SerialNumberRequired: Boolean
ArticlePrices_0_price: String
ArticlePrices_1_price: String
ArticlePrices_2_price: String
ArticlePrices_3_price: String
PrimarySupplySourceId: String
ArticlePrices_0_version: String
ArticlePrices_1_version: String
ArticlePrices_2_endDate: Integer
ArticlePrices_2_version: String
ArticlePrices_3_endDate: Integer
ArticlePrices_3_version: String
SupplySources_0_version: String
SalesBillOfMaterialItems: String
ArticlePrices_0_startDate: Integer
ArticlePrices_1_startDate: Integer
ArticlePrices_2_startDate: Integer
ArticlePrices_3_startDate: Integer
PlannedWorkingTimePerUnit: Integer
ArticlePrices_0_currencyId: String
ArticlePrices_1_currencyId: String
ArticlePrices_2_currencyId: String
ArticlePrices_3_currencyId: String
MarginCalculationPriceType: String
PackagingUnitBaseArticleId: String
ArticlePrices_0_createdDate: Integer
ArticlePrices_1_createdDate: Integer
ArticlePrices_2_createdDate: Integer
ArticlePrices_3_createdDate: Integer
DefaultPriceCalculationType: String
ProductionConfigurationRule: String
SupplySources_0_createdDate: Integer
ArticlePrices_0_currencyName: String
ArticlePrices_0_salesChannel: String
ArticlePrices_1_currencyName: String
ArticlePrices_1_salesChannel: String
ArticlePrices_2_currencyName: String
ArticlePrices_2_salesChannel: String
ArticlePrices_3_currencyName: String
ArticlePrices_3_salesChannel: String
UseAvailableForSalesChannels: Boolean
DefineIndividualTaskTemplates: Boolean
SalesBillOfMaterialItems_0_id: String
SalesBillOfMaterialItems_1_id: String
SalesBillOfMaterialItems_2_id: String
ArticlePrices_0_priceScaleType: String
ArticlePrices_1_priceScaleType: String
ArticlePrices_2_priceScaleType: String
ArticlePrices_3_priceScaleType: String
SupplySources_0_positionNumber: Integer
ArticlePrices_0_priceScaleValue: String
ArticlePrices_1_priceScaleValue: String
ArticlePrices_2_priceScaleValue: String
ArticlePrices_3_priceScaleValue: String
ArticlePrices_0_lastModifiedDate: Integer
ArticlePrices_1_lastModifiedDate: Integer
ArticlePrices_2_lastModifiedDate: Integer
ArticlePrices_3_lastModifiedDate: Integer
SupplySources_0_lastModifiedDate: Integer
UseSalesBillOfMaterialItemPrices: Boolean
BillOfMaterialPartDeliveryPossible: Boolean
SalesBillOfMaterialItems_0_version: String
SalesBillOfMaterialItems_1_version: String
SalesBillOfMaterialItems_2_version: String
UseSalesBillOfMaterialSubitemCosts: Boolean
SalesBillOfMaterialItems_0_quantity: String
SalesBillOfMaterialItems_1_quantity: String
SalesBillOfMaterialItems_2_quantity: String
ArticlePrices_0_lastModifiedByUserId: String
ArticlePrices_1_lastModifiedByUserId: String
ArticlePrices_2_lastModifiedByUserId: String
ArticlePrices_3_lastModifiedByUserId: String
SalesBillOfMaterialItems_0_articleId: String
SalesBillOfMaterialItems_1_articleId: String
SalesBillOfMaterialItems_2_articleId: String
SupplySources_0_articleSupplySourceId: String
SalesBillOfMaterialItems_0_createdDate: Integer
SalesBillOfMaterialItems_1_createdDate: Integer
SalesBillOfMaterialItems_2_createdDate: Integer
SalesBillOfMaterialItems_0_articleNumber: String
SalesBillOfMaterialItems_1_articleNumber: String
SalesBillOfMaterialItems_2_articleNumber: String
SalesBillOfMaterialItems_0_positionNumber: Integer
SalesBillOfMaterialItems_1_positionNumber: Integer
SalesBillOfMaterialItems_2_positionNumber: Integer
SalesBillOfMaterialItems_0_lastModifiedDate: Integer
SalesBillOfMaterialItems_1_lastModifiedDate: Integer
SalesBillOfMaterialItems_2_lastModifiedDate: Integer
UseSalesBillOfMaterialItemPricesForPurchase: Boolean

Weclapp
Table Article Custom Attributes
DateValue: Date-time
Article_id: String
NumberValue: Number
StringValue: String
BooleanValue: Boolean
AttributeDefinitionId: String

Weclapp
Table Batch Number
Id: String
Version: String
ArticleId: String
BatchNumber: String
CreatedDate: Date-time
ArticleNumber: String
LastModifiedDate: Date-time

Weclapp
Table Contact
Id: String
Email: String
OptIn: Boolean
Phone: String
Title: String
TitleId: String
Version: String
Company2: String
LastName: String
OptInSms: Boolean
FirstName: String
FixPhone2: String
PartyType: String
OptInPhone: Boolean
Salutation: String
CreatedDate: Date-time
OptInLetter: Boolean
MobilePhone1: String
PersonCompany: String
Addresses_0_id: String
LastModifiedDate: Date-time
PrimaryAddressId: String
Customfield_Bezug: String
PersonDepartmentId: String
Addresses_0_version: String
Customfield_Partner: Boolean
Addresses_0_countryCode: String
Addresses_0_createdDate: Integer
Addresses_0_primeAddress: Boolean
Customfield_pipedrive_id: String
Addresses_0_invoiceAddress: Boolean
Addresses_0_deliveryAddress: Boolean
Addresses_0_lastModifiedDate: Integer
CustomAttributes_2_numberValue: String
CustomAttributes_0_booleanValue: Boolean
CustomAttributes_0_attributeDefinitionId: String
CustomAttributes_1_attributeDefinitionId: String
CustomAttributes_2_attributeDefinitionId: String
CustomAttributes_3_attributeDefinitionId: String
Customfield_alte Kundennummer (Filemaker): String

Weclapp
Table Custom Attribute Definition
Id: String
Label: String
Active: Boolean
Version: String
Entities: String
ReadOnly: Boolean
Mandatory: Boolean
Entities_0: String
Entities_1: String
Entities_2: String
CreatedDate: Date-time
AttributeKey: String
AttributeType: String
ShowInOverview: Boolean
LastModifiedDate: Date-time
LegacyEntities_0: String
LegacyEntities_1: String
LegacyEntities_2: String
LegacyEntities_3: String
SelectableValues: String
DefaultBooleanValue: Boolean
ShowOnCreationDialog: Boolean
SystemCustomAttribute: Boolean
ShowAttributeEntityType: Boolean

Weclapp
Table Incoming Goods
Id: String
Status: String
Version: String
CreatorId: String
CreatedDate: Date-time
Description: String
WarehouseId: String
SalesOrderId: String
RecordComment: String
SenderPartyId: String
WarehouseName: String
PurchaseOrderId: String
SentToRecipient: Boolean
LastModifiedDate: Date-time
SalesOrderNumber: String
SalesOrders_0_id: String
IncomingGoodsType: String
RelatedShipmentId: String
SourceWarehouseId: String
CommercialLanguage: String
DeliveryNoteNumber: String
IncomingGoodsItems: String
InvoiceRecipientId: String
ReturnAddress_city: String
IncomingGoodsNumber: String
InvoiceAddress_city: String
PurchaseOrderNumber: String
PurchaseOrders_0_id: String
SourceWarehouseName: String
DisableEmailTemplate: Boolean
SenderCustomerNumber: String
SenderSupplierNumber: String
RecipientAddress_city: String
ReturnAddress_company: String
ReturnAddress_street1: String
ReturnAddress_zipcode: String
InvoiceAddress_company: String
InvoiceAddress_street1: String
InvoiceAddress_zipcode: String
ReturnAddress_company2: String
ReturnAddress_lastName: String
StatusHistory_0_status: String
StatusHistory_0_userId: String
StatusHistory_1_status: String
StatusHistory_1_userId: String
IncomingGoodsItems_0_id: String
IncomingGoodsItems_1_id: String
IncomingGoodsItems_2_id: String
IncomingGoodsItems_3_id: String
ReturnAddress_firstName: String
RecipientAddress_company: String
RecipientAddress_street1: String
RecipientAddress_zipcode: String
ReturnAddress_salutation: String
RecipientAddress_company2: String
RecipientAddress_lastName: String
ReturnAddress_countryCode: String
IncomingGoodsItems_0_title: String
IncomingGoodsItems_1_title: String
IncomingGoodsItems_2_title: String
IncomingGoodsItems_3_title: String
InvoiceAddress_countryCode: String
InvoiceAddress_phoneNumber: String
RecipientAddress_firstName: String
StatusHistory_0_statusDate: Integer
StatusHistory_1_statusDate: Integer
CustomerInvoiceAddress_city: String
IncomingGoodsItems_0_unitId: String
IncomingGoodsItems_1_unitId: String
IncomingGoodsItems_2_unitId: String
IncomingGoodsItems_3_unitId: String
RecipientAddress_salutation: String
CustomerDeliveryAddress_city: String
IncomingGoodsItems_0_version: String
IncomingGoodsItems_1_version: String
IncomingGoodsItems_2_version: String
IncomingGoodsItems_3_version: String
RecipientAddress_countryCode: String
IncomingGoodsItems_0_quantity: String
IncomingGoodsItems_0_unitName: String
IncomingGoodsItems_1_quantity: String
IncomingGoodsItems_1_unitName: String
IncomingGoodsItems_2_quantity: String
IncomingGoodsItems_2_unitName: String
IncomingGoodsItems_3_quantity: String
IncomingGoodsItems_3_unitName: String
CustomerInvoiceAddress_company: String
CustomerInvoiceAddress_street1: String
CustomerInvoiceAddress_zipcode: String
IncomingGoodsItems_0_articleId: String
IncomingGoodsItems_1_articleId: String
IncomingGoodsItems_2_articleId: String
IncomingGoodsItems_3_articleId: String
CustomerDeliveryAddress_company: String
CustomerDeliveryAddress_street1: String
CustomerDeliveryAddress_zipcode: String
CustomerInvoiceAddress_company2: String
CustomerInvoiceAddress_lastName: String
CustomerDeliveryAddress_company2: String
CustomerDeliveryAddress_lastName: String
CustomerInvoiceAddress_firstName: String
IncomingGoodsItems_0_createdDate: Integer
IncomingGoodsItems_0_description: String
IncomingGoodsItems_1_createdDate: Integer
IncomingGoodsItems_1_description: String
IncomingGoodsItems_2_createdDate: Integer
IncomingGoodsItems_2_description: String
IncomingGoodsItems_3_createdDate: Integer
IncomingGoodsItems_3_description: String
CustomerDeliveryAddress_firstName: String
CustomerInvoiceAddress_salutation: String
IncomingGoodsItems_0_parentItemId: String
IncomingGoodsItems_2_parentItemId: String
CustomerDeliveryAddress_salutation: String
CustomerInvoiceAddress_countryCode: String
IncomingGoodsItems_0_articleNumber: String
IncomingGoodsItems_1_articleNumber: String
IncomingGoodsItems_2_articleNumber: String
IncomingGoodsItems_3_articleNumber: String
CustomerDeliveryAddress_countryCode: String
IncomingGoodsItems_0_manualQuantity: Boolean
IncomingGoodsItems_0_positionNumber: Integer
IncomingGoodsItems_1_manualQuantity: Boolean
IncomingGoodsItems_1_positionNumber: Integer
IncomingGoodsItems_2_manualQuantity: Boolean
IncomingGoodsItems_2_positionNumber: Integer
IncomingGoodsItems_3_manualQuantity: Boolean
IncomingGoodsItems_3_positionNumber: Integer
IncomingGoodsItems_0_descriptionFixed: Boolean
IncomingGoodsItems_0_lastModifiedDate: Integer
IncomingGoodsItems_0_salesOrderItemId: String
IncomingGoodsItems_1_descriptionFixed: Boolean
IncomingGoodsItems_1_lastModifiedDate: Integer
IncomingGoodsItems_1_salesOrderItemId: String
IncomingGoodsItems_2_descriptionFixed: Boolean
IncomingGoodsItems_2_lastModifiedDate: Integer
IncomingGoodsItems_2_salesOrderItemId: String
IncomingGoodsItems_3_descriptionFixed: Boolean
IncomingGoodsItems_3_lastModifiedDate: Integer
IncomingGoodsItems_0_purchaseOrderItemId: String
IncomingGoodsItems_1_purchaseOrderItemId: String
IncomingGoodsItems_2_purchaseOrderItemId: String
IncomingGoodsItems_3_purchaseOrderItemId: String

Weclapp
Table Lead
Id: String
Email: String
OptIn: Boolean
Phone: String
Company: String
Version: String
Company2: String
LastName: String
OptInSms: Boolean
SectorId: String
FirstName: String
PartyType: String
CurrencyId: String
LeadNumber: String
LeadStatus: String
OptInPhone: Boolean
Salutation: String
SectorName: String
CreatedDate: Date-time
Description: String
OptInLetter: Boolean
CurrencyName: String
MobilePhone1: String
SalesChannel: String
Contacts_0_id: String
Contacts_1_id: String
OldLeadNumber: String
Addresses_0_id: String
PaymentMethodId: String
TermOfPaymentId: String
Addresses_0_city: String
Contacts_0_email: String
Contacts_0_optIn: Boolean
Contacts_0_phone: String
Contacts_1_email: String
Contacts_1_optIn: Boolean
Contacts_1_phone: String
CustomAttributes: String
InvoiceAddressId: String
LastModifiedDate: Date-time
PrimaryAddressId: String
PrimaryContactId: String
ShipmentMethodId: String
Addresses_0_state: String
Customfield_Bezug: String
DeliveryAddressId: String
PaymentMethodName: String
ResponsibleUserId: String
TermOfPaymentName: String
Contacts_0_version: String
Contacts_1_version: String
ShipmentMethodName: String
Addresses_0_street1: String
Addresses_0_version: String
Addresses_0_zipcode: String
Contacts_0_company2: String
Contacts_0_lastName: String
Contacts_0_optInSms: Boolean
Contacts_1_lastName: String
Contacts_1_optInSms: Boolean
Customfield_Leasing: Boolean
Customfield_Partner: Boolean
Customfield_Produkt: String
Addresses_0_lastName: String
CommercialLanguageId: String
Contacts_0_firstName: String
Contacts_0_partyType: String
Contacts_1_firstName: String
Contacts_1_partyType: String
ResponsibleUserFixed: Boolean
Addresses_0_firstName: String
Contacts_0_optInPhone: Boolean
Contacts_0_salutation: String
Contacts_1_optInPhone: Boolean
Contacts_1_salutation: String
Customfield_Ansprache: String
VatRegistrationNumber: String
Addresses_0_salutation: String
Contacts_0_createdDate: Integer
Contacts_0_optInLetter: Boolean
Contacts_1_createdDate: Integer
Contacts_1_optInLetter: Boolean
Addresses_0_countryCode: String
Addresses_0_createdDate: Integer
Contacts_0_mobilePhone1: String
Contacts_0_personRoleId: String
Contacts_1_mobilePhone1: String
Customfield_Key Account: String
ResponsibleUserUsername: String
Addresses_0_primeAddress: Boolean
Contacts_0_personCompany: String
Contacts_1_personCompany: String
Customfield_Teststellung: String
Customfield_pipedrive_id: String
Addresses_0_invoiceAddress: Boolean
Addresses_0_deliveryAddress: Boolean
Contacts_0_lastModifiedDate: Integer
Contacts_0_primaryAddressId: String
Contacts_1_lastModifiedDate: Integer
Contacts_1_primaryAddressId: String
Addresses_0_lastModifiedDate: Integer
Customfield_alte Kundennummer (Filemaker): String

Weclapp
Table Ledger Account
Id: String
Type: String
Version: String
Automatic: Boolean
CreatedDate: Date-time
Description: String
AccountNumber: String
LastModifiedDate: Date-time

Weclapp
Table Party
Id: String
Email: String
Phone: String
Title: String
TitleId: String
Version: String
Company2: String
Customer: Boolean
LastName: String
OptInSms: Boolean
RegionId: String
SectorId: String
Supplier: Boolean
Factoring: Boolean
FirstName: String
FixPhone2: String
PartyType: String
OptInEmail: Boolean
OptInPhone: Boolean
Salutation: String
SectorName: String
CreatedDate: Date-time
OptInLetter: Boolean
InvoiceBlock: Boolean
LeadSourceId: String
MobilePhone1: String
SalesPartner: Boolean
PersonCompany: String
Addresses_0_id: String
LeadSourceName: String
CommissionBlock: Boolean
CustomerBlocked: Boolean
CustomerInsured: Boolean
HabitualExporter: Boolean
LastModifiedDate: Date-time
PrimaryAddressId: String
CustomerInsolvent: Boolean
Customfield_Bezug: String
ResponsibleUserId: String
FormerSalesPartner: Boolean
PersonDepartmentId: String
PurchaseViaPlafond: Boolean
SupplierOrderBlock: Boolean
Addresses_0_version: String
Customfield_Partner: Boolean
CommercialLanguageId: String
CustomerBusinessType: String
FixedResponsibleUser: Boolean
CustomerDeliveryBlock: Boolean
Addresses_0_countryCode: String
Addresses_0_createdDate: Integer
ResponsibleUserUsername: String
Addresses_0_primeAddress: Boolean
Customfield_pipedrive_id: String
Addresses_0_invoiceAddress: Boolean
AllowPurchaseOrderCreation: Boolean
Addresses_0_deliveryAddress: Boolean
Addresses_0_lastModifiedDate: Integer
CustomAttributes_2_numberValue: String
CustomerUseCustomsTariffNumber: Boolean
CustomAttributes_0_booleanValue: Boolean
EnableDropshippingInNewSupplySources: Boolean
CustomerAllowDropshippingOrderCreation: Boolean
CustomAttributes_0_attributeDefinitionId: String
CustomAttributes_1_attributeDefinitionId: String
CustomAttributes_2_attributeDefinitionId: String
CustomAttributes_3_attributeDefinitionId: String
Customfield_alte Kundennummer (Filemaker): String

Weclapp
Table Pick
Id: String
Version: String
Quantity: String
BookedDate: Integer
BatchNumber: String
CreatedDate: Date-time
ConfirmedDate: Integer
SerialNumbers: String
PositionNumber: Integer
ShipmentItemId: String
StoragePlaceId: String
SerialNumbers_0: String
LastModifiedDate: Date-time
ConfirmedByUserId: String
SourceStoragePlaceId: String
TransportationOrderId: String
PackagingUnitBaseArticleId: String
InternalTransportReferenceId: String
SourceInternalTransportReferenceId: String

Weclapp
Table Purchase Order
Id: String
Paid: Boolean
Status: String
Version: String
Invoiced: Boolean
Received: Boolean
CreatorId: String
NetAmount: String
OrderDate: Integer
SupplierId: String
CreatedDate: Date-time
Description: String
GrossAmount: String
WarehouseId: String
RecordComment: String
StatusHistory: String
WarehouseName: String
HeaderDiscount: String
RecordFreeText: String
SupplierNumber: String
HeaderSurcharge: String
PaymentMethodId: String
SentToRecipient: Boolean
LastModifiedDate: Date-time
RecordCurrencyId: String
PaymentMethodName: String
PurchaseOrderType: String
ResponsibleUserId: String
SenderCountryCode: String
ShippingCarrierId: String
CommercialLanguage: String
PackageTrackingUrl: String
PurchaseOrderItems: String
RecordAddress_city: String
RecordCurrencyName: String
InvoiceAddress_city: String
PlannedDeliveryDate: Integer
PlannedShippingDate: Integer
PurchaseOrderNumber: String
DeliveryAddress_city: String
DisableEmailTemplate: Boolean
PackageTrackingNumber: String
RecordAddress_company: String
RecordAddress_street1: String
RecordAddress_zipcode: String
CurrencyConversionDate: Integer
CurrencyConversionRate: String
InvoiceAddress_company: String
InvoiceAddress_street1: String
InvoiceAddress_zipcode: String
RecordAddress_lastName: String
ShippingCostItems_0_id: String
StatusHistory_0_status: String
StatusHistory_0_userId: String
StatusHistory_1_status: String
StatusHistory_1_userId: String
StatusHistory_2_status: String
StatusHistory_2_userId: String
StatusHistory_3_status: String
StatusHistory_3_userId: String
DeliveryAddress_company: String
DeliveryAddress_street1: String
DeliveryAddress_zipcode: String
PurchaseOrderItems_0_id: String
PurchaseOrderItems_1_id: String
PurchaseOrderItems_2_id: String
PurchaseOrderItems_3_id: String
RecordAddress_firstName: String
ResponsibleUserUsername: String
DeliveryAddress_company2: String
DeliveryAddress_lastName: String
RecordAddress_salutation: String
DeliveryAddress_firstName: String
RecordAddress_countryCode: String
ShippingCostItems_0_taxId: String
DeliveryAddress_salutation: String
InvoiceAddress_countryCode: String
InvoiceAddress_phoneNumber: String
NetAmountInCompanyCurrency: String
PurchaseOrderItems_0_taxId: String
PurchaseOrderItems_0_title: String
PurchaseOrderItems_1_taxId: String
PurchaseOrderItems_1_title: String
PurchaseOrderItems_2_taxId: String
PurchaseOrderItems_2_title: String
PurchaseOrderItems_3_taxId: String
PurchaseOrderItems_3_title: String
StatusHistory_0_statusDate: Integer
StatusHistory_1_statusDate: Integer
StatusHistory_2_statusDate: Integer
StatusHistory_3_statusDate: Integer
DeliveryAddress_countryCode: String
PurchaseOrderItems_0_unitId: String
PurchaseOrderItems_1_unitId: String
PurchaseOrderItems_2_unitId: String
PurchaseOrderItems_3_unitId: String
ShippingCostItems_0_taxName: String
ShippingCostItems_0_version: String
GrossAmountInCompanyCurrency: String
PurchaseOrderItems_0_taxName: String
PurchaseOrderItems_0_version: String
PurchaseOrderItems_1_taxName: String
PurchaseOrderItems_1_version: String
PurchaseOrderItems_2_taxName: String
PurchaseOrderItems_2_version: String
PurchaseOrderItems_3_taxName: String
PurchaseOrderItems_3_version: String
PurchaseOrderItems_0_quantity: String
PurchaseOrderItems_0_unitName: String
PurchaseOrderItems_1_quantity: String
PurchaseOrderItems_1_unitName: String
PurchaseOrderItems_2_quantity: String
PurchaseOrderItems_2_unitName: String
PurchaseOrderItems_3_quantity: String
PurchaseOrderItems_3_unitName: String
ShippingCostItems_0_articleId: String
ShippingCostItems_0_netAmount: String
ShippingCostItems_0_unitPrice: String
PurchaseOrderItems_0_articleId: String
PurchaseOrderItems_0_netAmount: String
PurchaseOrderItems_0_unitPrice: String
PurchaseOrderItems_1_articleId: String
PurchaseOrderItems_1_netAmount: String
PurchaseOrderItems_1_unitPrice: String
PurchaseOrderItems_2_articleId: String
PurchaseOrderItems_2_netAmount: String
PurchaseOrderItems_2_unitPrice: String
PurchaseOrderItems_3_articleId: String
PurchaseOrderItems_3_netAmount: String
PurchaseOrderItems_3_unitPrice: String
ShippingCostItems_0_createdDate: Integer
ShippingCostItems_0_grossAmount: String
PurchaseOrderItems_0_createdDate: Integer
PurchaseOrderItems_0_description: String
PurchaseOrderItems_0_grossAmount: String
PurchaseOrderItems_1_createdDate: Integer
PurchaseOrderItems_1_description: String
PurchaseOrderItems_1_grossAmount: String
PurchaseOrderItems_2_createdDate: Integer
PurchaseOrderItems_2_description: String
PurchaseOrderItems_2_grossAmount: String
PurchaseOrderItems_3_createdDate: Integer
PurchaseOrderItems_3_description: String
PurchaseOrderItems_3_grossAmount: String
RecordEmailAddresses_toAddresses: String
PurchaseOrderItems_0_freeTextItem: Boolean
PurchaseOrderItems_1_freeTextItem: Boolean
PurchaseOrderItems_2_freeTextItem: Boolean
PurchaseOrderItems_3_freeTextItem: Boolean
ShippingCostItems_0_articleNumber: String
PurchaseOrderItems_0_articleNumber: String
PurchaseOrderItems_1_articleNumber: String
PurchaseOrderItems_2_articleNumber: String
PurchaseOrderItems_3_articleNumber: String
PurchaseOrderItems_0_manualQuantity: Boolean
PurchaseOrderItems_0_positionNumber: Integer
PurchaseOrderItems_1_manualQuantity: Boolean
PurchaseOrderItems_1_positionNumber: Integer
PurchaseOrderItems_2_manualQuantity: Boolean
PurchaseOrderItems_2_positionNumber: Integer
PurchaseOrderItems_3_manualQuantity: Boolean
PurchaseOrderItems_3_positionNumber: Integer
ShippingCostItems_0_manualUnitPrice: Boolean
PurchaseOrderItems_0_manualUnitPrice: Boolean
PurchaseOrderItems_1_manualUnitPrice: Boolean
PurchaseOrderItems_2_manualUnitPrice: Boolean
PurchaseOrderItems_3_manualUnitPrice: Boolean
ShippingCostItems_0_lastModifiedDate: Integer
PurchaseOrderItems_0_descriptionFixed: Boolean
PurchaseOrderItems_0_invoicedQuantity: String
PurchaseOrderItems_0_lastModifiedDate: Integer
PurchaseOrderItems_0_receivedQuantity: String
PurchaseOrderItems_1_descriptionFixed: Boolean
PurchaseOrderItems_1_invoicedQuantity: String
PurchaseOrderItems_1_lastModifiedDate: Integer
PurchaseOrderItems_1_receivedQuantity: String
PurchaseOrderItems_2_descriptionFixed: Boolean
PurchaseOrderItems_2_invoicedQuantity: String
PurchaseOrderItems_2_lastModifiedDate: Integer
PurchaseOrderItems_2_receivedQuantity: String
PurchaseOrderItems_3_descriptionFixed: Boolean
PurchaseOrderItems_3_invoicedQuantity: String
PurchaseOrderItems_3_lastModifiedDate: Integer
PurchaseOrderItems_3_receivedQuantity: String
PurchaseOrderItems_0_supplierArticleId: String
PurchaseOrderItems_1_supplierArticleId: String
PurchaseOrderItems_2_supplierArticleId: String
PurchaseOrderItems_3_supplierArticleId: String
PurchaseOrderItems_0_addPageBreakBefore: Boolean
PurchaseOrderItems_0_discountPercentage: String
PurchaseOrderItems_1_addPageBreakBefore: Boolean
PurchaseOrderItems_1_discountPercentage: String
PurchaseOrderItems_2_addPageBreakBefore: Boolean
PurchaseOrderItems_2_discountPercentage: String
PurchaseOrderItems_3_addPageBreakBefore: Boolean
PurchaseOrderItems_3_discountPercentage: String
PurchaseOrderItems_0_netAmountForStatistics: String
PurchaseOrderItems_1_netAmountForStatistics: String
PurchaseOrderItems_2_netAmountForStatistics: String
PurchaseOrderItems_3_netAmountForStatistics: String
ShippingCostItems_0_netAmountInCompanyCurrency: String
ShippingCostItems_0_unitPriceInCompanyCurrency: String
PurchaseOrderItems_0_netAmountInCompanyCurrency: String
PurchaseOrderItems_0_unitPriceInCompanyCurrency: String
PurchaseOrderItems_1_netAmountInCompanyCurrency: String
PurchaseOrderItems_1_unitPriceInCompanyCurrency: String
PurchaseOrderItems_2_netAmountInCompanyCurrency: String
PurchaseOrderItems_2_unitPriceInCompanyCurrency: String
PurchaseOrderItems_3_netAmountInCompanyCurrency: String
PurchaseOrderItems_3_unitPriceInCompanyCurrency: String
ShippingCostItems_0_grossAmountInCompanyCurrency: String
PurchaseOrderItems_0_grossAmountInCompanyCurrency: String
PurchaseOrderItems_1_grossAmountInCompanyCurrency: String
PurchaseOrderItems_2_grossAmountInCompanyCurrency: String
PurchaseOrderItems_3_grossAmountInCompanyCurrency: String
PurchaseOrderItems_0_netAmountForStatisticsInCompanyCurrency: String
PurchaseOrderItems_1_netAmountForStatisticsInCompanyCurrency: String
PurchaseOrderItems_2_netAmountForStatisticsInCompanyCurrency: String
PurchaseOrderItems_3_netAmountForStatisticsInCompanyCurrency: String

Weclapp
Table Quotation
Id: String
Status: String
ValidTo: Integer
Version: String
Template: Boolean
CreatorId: String
Factoring: Boolean
NetAmount: String
ValidFrom: Integer
CustomerId: String
CreatedDate: Date-time
Description: String
GrossAmount: String
PricingDate: Integer
RequestDate: Integer
WarehouseId: String
SalesChannel: String
SalesStageId: String
ActiveVersion: Boolean
QuotationDate: Integer
QuotationType: String
RecordComment: String
RecordOpening: String
WarehouseName: String
CustomerNumber: String
HeaderDiscount: String
QuotationItems: String
RecordFreeText: String
SalesStageName: String
HeaderSurcharge: String
PaymentMethodId: String
QuotationNumber: String
RejectionReason: String
SentToRecipient: Boolean
TermOfPaymentId: String
CustomAttributes: String
LastModifiedDate: Date-time
QuotationVersion: Integer
RecordCurrencyId: String
SalesProbability: Integer
ShipmentMethodId: String
PaymentMethodName: String
ResponsibleUserId: String
TermOfPaymentName: String
CommercialLanguage: String
InvoiceRecipientId: String
RecordAddress_city: String
RecordCurrencyName: String
ShipmentMethodName: String
Customfield_Leasing: Boolean
DispatchCountryCode: String
InvoiceAddress_city: String
PlannedDeliveryDate: Integer
QuotationItems_0_id: String
QuotationItems_1_id: String
QuotationItems_2_id: String
QuotationItems_3_id: String
RecordAddress_title: String
Customfield_Referenz: String
DeliveryAddress_city: String
DisableEmailTemplate: Boolean
DeliveryAddress_title: String
RecordAddress_company: String
RecordAddress_street1: String
RecordAddress_titleId: String
RecordAddress_zipcode: String
CurrencyConversionDate: Integer
CurrencyConversionRate: String
InvoiceAddress_company: String
InvoiceAddress_street1: String
InvoiceAddress_zipcode: String
QuotationItems_0_taxId: String
QuotationItems_0_title: String
QuotationItems_1_taxId: String
QuotationItems_1_title: String
QuotationItems_2_taxId: String
QuotationItems_2_title: String
QuotationItems_3_taxId: String
QuotationItems_3_title: String
RecordAddress_company2: String
RecordAddress_lastName: String
SalesStageHistory_0_id: String
SalesStageHistory_1_id: String
SalesStageHistory_2_id: String
ShippingCostItems_0_id: String
StatusHistory_0_status: String
StatusHistory_0_userId: String
StatusHistory_1_status: String
StatusHistory_1_userId: String
StatusHistory_2_status: String
StatusHistory_2_userId: String
StatusHistory_3_status: String
StatusHistory_3_userId: String
DeliveryAddress_company: String
DeliveryAddress_street1: String
DeliveryAddress_titleId: String
DeliveryAddress_zipcode: String
InvoiceAddress_company2: String
InvoiceAddress_lastName: String
QuotationItems_0_unitId: String
QuotationItems_1_unitId: String
QuotationItems_2_unitId: String
QuotationItems_3_unitId: String
RecordAddress_firstName: String
ResponsibleUserUsername: String
Customfield_Teststellung: String
DefaultShippingCarrierId: String
DeliveryAddress_company2: String
DeliveryAddress_lastName: String
InvoiceAddress_firstName: String
QuotationItems_0_taxName: String
QuotationItems_0_version: String
QuotationItems_1_taxName: String
QuotationItems_1_version: String
QuotationItems_2_taxName: String
QuotationItems_2_version: String
QuotationItems_3_taxName: String
QuotationItems_3_version: String
RecordAddress_salutation: String
RecordCommentInheritance: Boolean
RecordOpeningInheritance: Boolean
DeliveryAddress_firstName: String
InvoiceAddress_salutation: String
QuotationItems_0_itemType: String
QuotationItems_0_optional: Boolean
QuotationItems_0_quantity: String
QuotationItems_0_unitCost: String
QuotationItems_0_unitName: String
QuotationItems_1_itemType: String
QuotationItems_1_optional: Boolean
QuotationItems_1_quantity: String
QuotationItems_1_unitCost: String
QuotationItems_1_unitName: String
QuotationItems_2_itemType: String
QuotationItems_2_optional: Boolean
QuotationItems_2_quantity: String
QuotationItems_2_unitCost: String
QuotationItems_2_unitName: String
QuotationItems_3_itemType: String
QuotationItems_3_optional: Boolean
QuotationItems_3_quantity: String
QuotationItems_3_unitName: String
RecordAddress_countryCode: String
RecordFreeTextInheritance: Boolean
ShippingCostItems_0_taxId: String
DefaultShippingCarrierName: String
DeliveryAddress_salutation: String
InvoiceAddress_countryCode: String
NetAmountInCompanyCurrency: String
QuotationItems_0_articleId: String
QuotationItems_0_netAmount: String
QuotationItems_0_unitPrice: String
QuotationItems_1_articleId: String
QuotationItems_1_netAmount: String
QuotationItems_1_unitPrice: String
QuotationItems_2_articleId: String
QuotationItems_2_netAmount: String
QuotationItems_2_unitPrice: String
QuotationItems_3_articleId: String
QuotationItems_3_netAmount: String
QuotationItems_3_unitPrice: String
SalesStageHistory_0_userId: String
SalesStageHistory_1_userId: String
SalesStageHistory_2_userId: String
StatusHistory_0_statusDate: Integer
StatusHistory_1_statusDate: Integer
StatusHistory_2_statusDate: Integer
StatusHistory_3_statusDate: Integer
DeliveryAddress_countryCode: String
SalesStageHistory_0_version: String
SalesStageHistory_1_version: String
SalesStageHistory_2_version: String
ShippingCostItems_0_taxName: String
ShippingCostItems_0_version: String
GrossAmountInCompanyCurrency: String
QuotationItems_0_alternative: Boolean
QuotationItems_0_createdDate: Integer
QuotationItems_0_description: String
QuotationItems_0_grossAmount: String
QuotationItems_1_alternative: Boolean
QuotationItems_1_createdDate: Integer
QuotationItems_1_description: String
QuotationItems_1_grossAmount: String
QuotationItems_2_alternative: Boolean
QuotationItems_2_createdDate: Integer
QuotationItems_2_description: String
QuotationItems_2_grossAmount: String
QuotationItems_3_alternative: Boolean
QuotationItems_3_createdDate: Integer
QuotationItems_3_description: String
QuotationItems_3_grossAmount: String
Customfield_Rabattbezeichnung: String
QuotationItems_0_freeTextItem: Boolean
QuotationItems_0_parentItemId: String
QuotationItems_1_freeTextItem: Boolean
QuotationItems_1_parentItemId: String
QuotationItems_2_freeTextItem: Boolean
QuotationItems_2_parentItemId: String
QuotationItems_3_freeTextItem: Boolean
QuotationItems_3_parentItemId: String
ShippingCostItems_0_articleId: String
ShippingCostItems_0_netAmount: String
ShippingCostItems_0_unitPrice: String
QuotationItems_0_articleNumber: String
QuotationItems_0_invoicingType: String
QuotationItems_1_articleNumber: String
QuotationItems_2_articleNumber: String
QuotationItems_3_articleNumber: String
Customfield_pipedrive_bcc_email: String
QuotationItems_0_manualQuantity: Boolean
QuotationItems_0_manualUnitCost: Boolean
QuotationItems_0_positionNumber: Integer
QuotationItems_1_manualQuantity: Boolean
QuotationItems_1_manualUnitCost: Boolean
QuotationItems_1_positionNumber: Integer
QuotationItems_2_manualQuantity: Boolean
QuotationItems_2_manualUnitCost: Boolean
QuotationItems_2_positionNumber: Integer
QuotationItems_3_manualQuantity: Boolean
QuotationItems_3_manualUnitCost: Boolean
QuotationItems_3_positionNumber: Integer
SalesStageHistory_0_createdDate: Integer
SalesStageHistory_1_createdDate: Integer
SalesStageHistory_2_createdDate: Integer
ShippingCostItems_0_createdDate: Integer
ShippingCostItems_0_grossAmount: String
QuotationItems_0_manualUnitPrice: Boolean
QuotationItems_1_manualUnitPrice: Boolean
QuotationItems_2_manualUnitPrice: Boolean
QuotationItems_3_manualUnitPrice: Boolean
RecordEmailAddresses_toAddresses: String
SalesStageHistory_0_salesStageId: String
SalesStageHistory_1_salesStageId: String
SalesStageHistory_2_salesStageId: String
QuotationItems_0_descriptionFixed: Boolean
QuotationItems_0_lastModifiedDate: Integer
QuotationItems_1_descriptionFixed: Boolean
QuotationItems_1_lastModifiedDate: Integer
QuotationItems_2_descriptionFixed: Boolean
QuotationItems_2_lastModifiedDate: Integer
QuotationItems_3_descriptionFixed: Boolean
QuotationItems_3_lastModifiedDate: Integer
RecordEmailAddresses_bccAddresses: String
ShippingCostItems_0_articleNumber: String
DeliveryEmailAddresses_toAddresses: String
SalesStageHistory_0_salesStageName: String
SalesStageHistory_1_salesStageName: String
SalesStageHistory_2_salesStageName: String
ShippingCostItems_0_manualUnitCost: Boolean
DeliveryEmailAddresses_bccAddresses: String
QuotationItems_0_addPageBreakBefore: Boolean
QuotationItems_0_discountPercentage: String
QuotationItems_1_addPageBreakBefore: Boolean
QuotationItems_1_discountPercentage: String
QuotationItems_2_addPageBreakBefore: Boolean
QuotationItems_2_discountPercentage: String
QuotationItems_3_addPageBreakBefore: Boolean
QuotationItems_3_discountPercentage: String
ShippingCostItems_0_manualUnitPrice: Boolean
SalesOrderEmailAddresses_toAddresses: String
SalesStageHistory_0_lastModifiedDate: Integer
SalesStageHistory_1_lastModifiedDate: Integer
SalesStageHistory_2_lastModifiedDate: Integer
ShippingCostItems_0_lastModifiedDate: Integer
SalesOrderEmailAddresses_bccAddresses: String
SalesInvoiceEmailAddresses_toAddresses: String
QuotationItems_0_netAmountForStatistics: String
QuotationItems_1_netAmountForStatistics: String
QuotationItems_2_netAmountForStatistics: String
QuotationItems_3_netAmountForStatistics: String
SalesInvoiceEmailAddresses_bccAddresses: String
QuotationItems_0_plannedWorkingTimePerUnit: Integer
QuotationItems_0_unitCostInCompanyCurrency: String
QuotationItems_1_unitCostInCompanyCurrency: String
QuotationItems_2_unitCostInCompanyCurrency: String
QuotationItems_0_netAmountInCompanyCurrency: String
QuotationItems_0_unitPriceInCompanyCurrency: String
QuotationItems_1_netAmountInCompanyCurrency: String
QuotationItems_1_unitPriceInCompanyCurrency: String
QuotationItems_2_netAmountInCompanyCurrency: String
QuotationItems_2_unitPriceInCompanyCurrency: String
QuotationItems_3_netAmountInCompanyCurrency: String
QuotationItems_3_unitPriceInCompanyCurrency: String
QuotationItems_0_grossAmountInCompanyCurrency: String
QuotationItems_1_grossAmountInCompanyCurrency: String
QuotationItems_2_grossAmountInCompanyCurrency: String
QuotationItems_3_grossAmountInCompanyCurrency: String
ShippingCostItems_0_netAmountInCompanyCurrency: String
ShippingCostItems_0_unitPriceInCompanyCurrency: String
QuotationItems_0_manualPlannedWorkingTimePerUnit: Boolean
QuotationItems_1_manualPlannedWorkingTimePerUnit: Boolean
QuotationItems_2_manualPlannedWorkingTimePerUnit: Boolean
QuotationItems_3_manualPlannedWorkingTimePerUnit: Boolean
ShippingCostItems_0_grossAmountInCompanyCurrency: String
QuotationItems_0_netAmountForStatisticsInCompanyCurrency: String
QuotationItems_1_netAmountForStatisticsInCompanyCurrency: String
QuotationItems_2_netAmountForStatisticsInCompanyCurrency: String
QuotationItems_3_netAmountForStatisticsInCompanyCurrency: String

Weclapp
Table Sales Invoice
Id: String
Paid: Boolean
Status: String
DueDate: Integer
Version: String
CreatorId: String
Factoring: Boolean
NetAmount: String
CustomerId: String
BookingText: String
CreatedDate: Date-time
Description: String
GrossAmount: String
InvoiceDate: Integer
PricingDate: Integer
DeliveryDate: Integer
SalesChannel: String
SalesOrderId: String
ShippingDate: Integer
InvoiceNumber: String
PaymentStatus: String
RecordComment: String
CustomerNumber: String
HeaderDiscount: String
RecordFreeText: String
CommissionBlock: Boolean
HeaderSurcharge: String
PaymentMethodId: String
SentToRecipient: Boolean
TermOfPaymentId: String
CancellationDate: Integer
LastModifiedDate: Date-time
RecordCurrencyId: String
SalesInvoiceType: String
SalesOrderNumber: String
SalesOrders_0_id: String
ShipmentMethodId: String
DunningBlockState: String
PaymentMethodName: String
ResponsibleUserId: String
SalesInvoiceItems: String
TermOfPaymentName: String
CancellationNumber: String
CommercialLanguage: String
RecordAddress_city: String
RecordCurrencyName: String
ShipmentMethodName: String
DispatchCountryCode: String
RecordAddress_title: String
Customfield_Referenz: String
DeliveryAddress_city: String
DisableEmailTemplate: Boolean
DeliveryAddress_title: String
OrderNumberAtCustomer: String
RecordAddress_company: String
RecordAddress_street1: String
RecordAddress_titleId: String
RecordAddress_zipcode: String
VatRegistrationNumber: String
CreditResetsOrderState: Boolean
CurrencyConversionDate: Integer
CurrencyConversionRate: String
DirectDebitFileCreated: Boolean
RecordAddress_company2: String
RecordAddress_lastName: String
SalesInvoiceItems_0_id: String
SalesInvoiceItems_1_id: String
SalesInvoiceItems_2_id: String
SalesInvoiceItems_3_id: String
ShippingCostItems_0_id: String
StatusHistory_0_status: String
StatusHistory_0_userId: String
StatusHistory_1_status: String
StatusHistory_1_userId: String
StatusHistory_2_status: String
StatusHistory_2_userId: String
StatusHistory_3_status: String
StatusHistory_3_userId: String
DeliveryAddress_company: String
DeliveryAddress_street1: String
DeliveryAddress_titleId: String
DeliveryAddress_zipcode: String
PrecedingSalesInvoiceId: String
RecordAddress_firstName: String
ResponsibleUserUsername: String
CommissionSettlementDone: Boolean
DeliveryAddress_company2: String
DeliveryAddress_lastName: String
RecordAddress_salutation: String
RecordCommentInheritance: Boolean
RecordOpeningInheritance: Boolean
DeliveryAddress_firstName: String
RecordAddress_countryCode: String
RecordFreeTextInheritance: Boolean
SalesInvoiceItems_0_taxId: String
SalesInvoiceItems_0_title: String
SalesInvoiceItems_1_taxId: String
SalesInvoiceItems_1_title: String
SalesInvoiceItems_2_taxId: String
SalesInvoiceItems_2_title: String
SalesInvoiceItems_3_taxId: String
SalesInvoiceItems_3_title: String
ShippingCostItems_0_taxId: String
DeliveryAddress_salutation: String
NetAmountInCompanyCurrency: String
SalesInvoiceItems_0_unitId: String
SalesInvoiceItems_1_unitId: String
SalesInvoiceItems_2_unitId: String
SalesInvoiceItems_3_unitId: String
StatusHistory_0_statusDate: Integer
StatusHistory_1_statusDate: Integer
StatusHistory_2_statusDate: Integer
StatusHistory_3_statusDate: Integer
DeliveryAddress_countryCode: String
SalesInvoiceItems_0_taxName: String
SalesInvoiceItems_0_version: String
SalesInvoiceItems_1_taxName: String
SalesInvoiceItems_1_version: String
SalesInvoiceItems_2_taxName: String
SalesInvoiceItems_2_version: String
SalesInvoiceItems_3_taxName: String
SalesInvoiceItems_3_version: String
ShippingCostItems_0_taxName: String
ShippingCostItems_0_version: String
GrossAmountInCompanyCurrency: String
SalesInvoiceItems_0_quantity: String
SalesInvoiceItems_0_unitCost: String
SalesInvoiceItems_0_unitName: String
SalesInvoiceItems_1_quantity: String
SalesInvoiceItems_1_unitCost: String
SalesInvoiceItems_1_unitName: String
SalesInvoiceItems_2_quantity: String
SalesInvoiceItems_2_unitCost: String
SalesInvoiceItems_2_unitName: String
SalesInvoiceItems_3_quantity: String
SalesInvoiceItems_3_unitName: String
Customfield_Rabattbezeichnung: String
SalesInvoiceItems_0_accountId: String
SalesInvoiceItems_0_articleId: String
SalesInvoiceItems_0_netAmount: String
SalesInvoiceItems_0_unitPrice: String
SalesInvoiceItems_1_accountId: String
SalesInvoiceItems_1_articleId: String
SalesInvoiceItems_1_netAmount: String
SalesInvoiceItems_1_unitPrice: String
SalesInvoiceItems_2_accountId: String
SalesInvoiceItems_2_articleId: String
SalesInvoiceItems_2_netAmount: String
SalesInvoiceItems_2_unitPrice: String
SalesInvoiceItems_3_accountId: String
SalesInvoiceItems_3_articleId: String
SalesInvoiceItems_3_netAmount: String
SalesInvoiceItems_3_unitPrice: String
ShippingCostItems_0_articleId: String
ShippingCostItems_0_netAmount: String
ShippingCostItems_0_unitPrice: String
CustomAttributes_0_stringValue: String
CustomAttributes_1_stringValue: String
CancellationSlipCommissionBlock: Boolean
SalesInvoiceItems_0_createdDate: Integer
SalesInvoiceItems_0_description: String
SalesInvoiceItems_0_grossAmount: String
SalesInvoiceItems_1_createdDate: Integer
SalesInvoiceItems_1_description: String
SalesInvoiceItems_1_grossAmount: String
SalesInvoiceItems_2_createdDate: Integer
SalesInvoiceItems_2_description: String
SalesInvoiceItems_2_grossAmount: String
SalesInvoiceItems_3_createdDate: Integer
SalesInvoiceItems_3_grossAmount: String
ShippingCostItems_0_createdDate: Integer
ShippingCostItems_0_grossAmount: String
RecordEmailAddresses_ccAddresses: String
RecordEmailAddresses_toAddresses: String
SalesInvoiceItems_0_freeTextItem: Boolean
SalesInvoiceItems_0_shippingDate: Integer
SalesInvoiceItems_1_freeTextItem: Boolean
SalesInvoiceItems_1_parentItemId: String
SalesInvoiceItems_1_shippingDate: Integer
SalesInvoiceItems_2_freeTextItem: Boolean
SalesInvoiceItems_2_parentItemId: String
SalesInvoiceItems_2_shippingDate: Integer
SalesInvoiceItems_3_freeTextItem: Boolean
SalesInvoiceItems_3_parentItemId: String
SalesInvoiceItems_3_shippingDate: Integer
RecordEmailAddresses_bccAddresses: String
SalesInvoiceItems_0_accountNumber: String
SalesInvoiceItems_0_articleNumber: String
SalesInvoiceItems_1_accountNumber: String
SalesInvoiceItems_1_articleNumber: String
SalesInvoiceItems_2_accountNumber: String
SalesInvoiceItems_2_articleNumber: String
SalesInvoiceItems_3_accountNumber: String
SalesInvoiceItems_3_articleNumber: String
ShippingCostItems_0_articleNumber: String
SalesInvoiceItems_0_manualQuantity: Boolean
SalesInvoiceItems_0_manualUnitCost: Boolean
SalesInvoiceItems_0_positionNumber: Integer
SalesInvoiceItems_1_manualQuantity: Boolean
SalesInvoiceItems_1_manualUnitCost: Boolean
SalesInvoiceItems_1_positionNumber: Integer
SalesInvoiceItems_2_manualQuantity: Boolean
SalesInvoiceItems_2_manualUnitCost: Boolean
SalesInvoiceItems_2_positionNumber: Integer
SalesInvoiceItems_3_manualQuantity: Boolean
SalesInvoiceItems_3_manualUnitCost: Boolean
SalesInvoiceItems_3_positionNumber: Integer
ShippingCostItems_0_manualUnitCost: Boolean
SalesInvoiceItems_0_manualUnitPrice: Boolean
SalesInvoiceItems_1_manualUnitPrice: Boolean
SalesInvoiceItems_2_manualUnitPrice: Boolean
SalesInvoiceItems_2_serialNumbers_0: String
SalesInvoiceItems_3_manualUnitPrice: Boolean
ShippingCostItems_0_manualUnitPrice: Boolean
SalesInvoiceItems_0_descriptionFixed: Boolean
SalesInvoiceItems_0_lastModifiedDate: Integer
SalesInvoiceItems_1_descriptionFixed: Boolean
SalesInvoiceItems_1_lastModifiedDate: Integer
SalesInvoiceItems_2_descriptionFixed: Boolean
SalesInvoiceItems_2_lastModifiedDate: Integer
SalesInvoiceItems_3_descriptionFixed: Boolean
SalesInvoiceItems_3_lastModifiedDate: Integer
ShippingCostItems_0_lastModifiedDate: Integer
SalesInvoiceItems_0_addPageBreakBefore: Boolean
SalesInvoiceItems_0_discountPercentage: String
SalesInvoiceItems_1_addPageBreakBefore: Boolean
SalesInvoiceItems_1_discountPercentage: String
SalesInvoiceItems_2_addPageBreakBefore: Boolean
SalesInvoiceItems_2_discountPercentage: String
SalesInvoiceItems_3_addPageBreakBefore: Boolean
SalesInvoiceItems_3_discountPercentage: String
CancellationSlipCommissionSettlementDone: Boolean
CustomAttributes_0_attributeDefinitionId: String
CustomAttributes_1_attributeDefinitionId: String
SalesInvoiceItems_0_creditedInvoiceItemId: String
SalesInvoiceItems_0_netAmountForStatistics: String
SalesInvoiceItems_1_netAmountForStatistics: String
SalesInvoiceItems_2_netAmountForStatistics: String
SalesInvoiceItems_3_netAmountForStatistics: String
SalesInvoiceItems_0_unitCostInCompanyCurrency: String
SalesInvoiceItems_1_unitCostInCompanyCurrency: String
SalesInvoiceItems_2_unitCostInCompanyCurrency: String
SalesInvoiceItems_0_netAmountInCompanyCurrency: String
SalesInvoiceItems_0_unitPriceInCompanyCurrency: String
SalesInvoiceItems_1_netAmountInCompanyCurrency: String
SalesInvoiceItems_1_unitPriceInCompanyCurrency: String
SalesInvoiceItems_2_netAmountInCompanyCurrency: String
SalesInvoiceItems_2_unitPriceInCompanyCurrency: String
SalesInvoiceItems_3_netAmountInCompanyCurrency: String
SalesInvoiceItems_3_unitPriceInCompanyCurrency: String
ShippingCostItems_0_netAmountInCompanyCurrency: String
ShippingCostItems_0_unitPriceInCompanyCurrency: String
SalesInvoiceItems_0_grossAmountInCompanyCurrency: String
SalesInvoiceItems_1_grossAmountInCompanyCurrency: String
SalesInvoiceItems_2_grossAmountInCompanyCurrency: String
SalesInvoiceItems_3_grossAmountInCompanyCurrency: String
ShippingCostItems_0_grossAmountInCompanyCurrency: String
SalesInvoiceItems_0_netAmountForStatisticsInCompanyCurrency: String
SalesInvoiceItems_0_salesInvoiceItemRelationship_0_quantity: String
SalesInvoiceItems_1_netAmountForStatisticsInCompanyCurrency: String
SalesInvoiceItems_1_salesInvoiceItemRelationship_0_quantity: String
SalesInvoiceItems_2_netAmountForStatisticsInCompanyCurrency: String
SalesInvoiceItems_2_salesInvoiceItemRelationship_0_quantity: String
SalesInvoiceItems_3_netAmountForStatisticsInCompanyCurrency: String
SalesInvoiceItems_3_salesInvoiceItemRelationship_0_quantity: String
SalesInvoiceItems_0_salesInvoiceItemRelationship_0_shipmentItemId: String
SalesInvoiceItems_1_salesInvoiceItemRelationship_0_shipmentItemId: String
SalesInvoiceItems_2_salesInvoiceItemRelationship_0_shipmentItemId: String
SalesInvoiceItems_3_salesInvoiceItemRelationship_0_shipmentItemId: String
SalesInvoiceItems_0_salesInvoiceItemRelationship_0_salesOrderItemId: String
SalesInvoiceItems_1_salesInvoiceItemRelationship_0_salesOrderItemId: String
SalesInvoiceItems_2_salesInvoiceItemRelationship_0_salesOrderItemId: String
SalesInvoiceItems_3_salesInvoiceItemRelationship_0_salesOrderItemId: String
SalesInvoiceItems_0_salesInvoiceItemRelationship_0_salesInvoiceItemId: String
SalesInvoiceItems_1_salesInvoiceItemRelationship_0_salesInvoiceItemId: String
SalesInvoiceItems_2_salesInvoiceItemRelationship_0_salesInvoiceItemId: String
SalesInvoiceItems_3_salesInvoiceItemRelationship_0_salesInvoiceItemId: String

Weclapp
Table Sales Order
Id: String
Note: String
Paid: Boolean
Status: String
Shipped: Boolean
Version: String
Invoiced: Boolean
Template: Boolean
CreatorId: String
Factoring: Boolean
NetAmount: String
OrderDate: Integer
CustomerId: String
OrderItems: String
CreatedDate: Date-time
Description: String
GrossAmount: String
OrderNumber: String
PricingDate: Integer
QuotationId: String
WarehouseId: String
Availability: String
OnlyServices: Boolean
SalesChannel: String
Payments_0_id: String
Payments_1_id: String
RecordComment: String
RecordOpening: String
StatusHistory: String
WarehouseName: String
CustomerNumber: String
HeaderDiscount: String
RecordFreeText: String
HeaderSurcharge: String
OrderItems_0_id: String
OrderItems_1_id: String
OrderItems_2_id: String
OrderItems_3_id: String
PaymentMethodId: String
QuotationNumber: String
SentToRecipient: Boolean
TermOfPaymentId: String
CustomAttributes: String
LastModifiedDate: Date-time
RecordCurrencyId: String
ServicesFinished: Boolean
ShipmentMethodId: String
Customfield_Bezug: String
PaymentMethodName: String
Payments_0_amount: String
Payments_1_amount: String
ProjectModeActive: Boolean
ResponsibleUserId: String
TermOfPaymentName: String
CommercialLanguage: String
InvoiceRecipientId: String
OrderItems_0_taxId: String
OrderItems_0_title: String
OrderItems_1_taxId: String
OrderItems_1_title: String
OrderItems_2_taxId: String
OrderItems_2_title: String
OrderItems_3_taxId: String
OrderItems_3_title: String
Payments_0_dueDate: Integer
Payments_0_version: String
Payments_1_dueDate: Integer
Payments_1_version: String
RecordAddress_city: String
RecordCurrencyName: String
ShipmentMethodName: String
Customfield_Leasing: Boolean
DispatchCountryCode: String
InvoiceAddress_city: String
OrderItems_0_unitId: String
OrderItems_1_unitId: String
OrderItems_2_unitId: String
OrderItems_3_unitId: String
PlannedDeliveryDate: Integer
PlannedShippingDate: Integer
RecordAddress_title: String
ShippingLabelsCount: Integer
AdvancePaymentStatus: String
Customfield_Referenz: String
DeliveryAddress_city: String
DisableEmailTemplate: Boolean
InvoiceAddress_title: String
OrderItems_0_shipped: Boolean
OrderItems_0_taxName: String
OrderItems_0_version: String
OrderItems_1_shipped: Boolean
OrderItems_1_taxName: String
OrderItems_1_version: String
OrderItems_2_shipped: Boolean
OrderItems_2_taxName: String
OrderItems_2_version: String
OrderItems_3_shipped: Boolean
OrderItems_3_taxName: String
OrderItems_3_version: String
Payments_0_condition: String
Payments_1_condition: String
DeliveryAddress_title: String
FulfillmentProviderId: String
OrderItems_0_itemType: String
OrderItems_0_quantity: String
OrderItems_0_unitCost: String
OrderItems_0_unitName: String
OrderItems_1_itemType: String
OrderItems_1_quantity: String
OrderItems_1_unitCost: String
OrderItems_1_unitName: String
OrderItems_2_itemType: String
OrderItems_2_quantity: String
OrderItems_2_unitCost: String
OrderItems_2_unitName: String
OrderItems_3_itemType: String
OrderItems_3_quantity: String
OrderItems_3_unitName: String
OrderNumberAtCustomer: String
RecordAddress_company: String
RecordAddress_street1: String
RecordAddress_titleId: String
RecordAddress_zipcode: String
SalesOrderPaymentType: String
CurrencyConversionDate: Integer
CurrencyConversionRate: String
InvoiceAddress_company: String
InvoiceAddress_street1: String
InvoiceAddress_titleId: String
InvoiceAddress_zipcode: String
OrderItems_0_articleId: String
OrderItems_0_netAmount: String
OrderItems_0_unitPrice: String
OrderItems_1_articleId: String
OrderItems_1_netAmount: String
OrderItems_1_unitPrice: String
OrderItems_2_articleId: String
OrderItems_2_netAmount: String
OrderItems_2_unitPrice: String
OrderItems_3_articleId: String
OrderItems_3_netAmount: String
OrderItems_3_unitPrice: String
Payments_0_createdDate: Integer
Payments_1_createdDate: Integer
RecordAddress_company2: String
RecordAddress_lastName: String
ShippingCostItems_0_id: String
StatusHistory_0_status: String
StatusHistory_0_userId: String
StatusHistory_1_status: String
StatusHistory_1_userId: String
StatusHistory_2_status: String
StatusHistory_2_userId: String
StatusHistory_3_status: String
StatusHistory_3_userId: String
DeliveryAddress_company: String
DeliveryAddress_street1: String
DeliveryAddress_titleId: String
DeliveryAddress_zipcode: String
InvoiceAddress_company2: String
InvoiceAddress_lastName: String
OrderItems_0_tasks_0_id: String
Payments_0_conditionMet: Boolean
Payments_1_conditionMet: Boolean
RecordAddress_firstName: String
ResponsibleUserUsername: String
Customfield_Teststellung: String
DefaultShippingCarrierId: String
DeliveryAddress_company2: String
DeliveryAddress_lastName: String
InvoiceAddress_firstName: String
OrderItems_0_createdDate: Integer
OrderItems_0_description: String
OrderItems_0_grossAmount: String
OrderItems_1_createdDate: Integer
OrderItems_1_description: String
OrderItems_1_grossAmount: String
OrderItems_2_createdDate: Integer
OrderItems_2_description: String
OrderItems_2_grossAmount: String
OrderItems_3_createdDate: Integer
OrderItems_3_grossAmount: String
RecordAddress_salutation: String
RecordCommentInheritance: Boolean
RecordOpeningInheritance: Boolean
DeliveryAddress_firstName: String
InvoiceAddress_salutation: String
OrderItems_0_availability: String
OrderItems_0_freeTextItem: Boolean
OrderItems_1_availability: String
OrderItems_1_freeTextItem: Boolean
OrderItems_1_parentItemId: String
OrderItems_2_availability: String
OrderItems_2_freeTextItem: Boolean
OrderItems_2_parentItemId: String
OrderItems_3_availability: String
OrderItems_3_freeTextItem: Boolean
OrderItems_3_parentItemId: String
Payments_0_positionNumber: Integer
Payments_0_salesInvoiceId: String
Payments_1_positionNumber: Integer
Payments_1_salesInvoiceId: String
RecordAddress_countryCode: String
RecordFreeTextInheritance: Boolean
ShippingCostItems_0_taxId: String
ApplyShippingCostsOnlyOnce: Boolean
DefaultShippingCarrierName: String
DeliveryAddress_salutation: String
InvoiceAddress_countryCode: String
NetAmountInCompanyCurrency: String
OrderItems_0_articleNumber: String
OrderItems_0_invoicingType: String
OrderItems_1_articleNumber: String
OrderItems_2_articleNumber: String
OrderItems_3_articleNumber: String
StatusHistory_0_statusDate: Integer
StatusHistory_1_statusDate: Integer
StatusHistory_2_statusDate: Integer
StatusHistory_3_statusDate: Integer
DeliveryAddress_countryCode: String
OrderItems_0_manualQuantity: Boolean
OrderItems_0_manualUnitCost: Boolean
OrderItems_0_positionNumber: Integer
OrderItems_1_manualQuantity: Boolean
OrderItems_1_manualUnitCost: Boolean
OrderItems_1_positionNumber: Integer
OrderItems_2_manualQuantity: Boolean
OrderItems_2_manualUnitCost: Boolean
OrderItems_2_positionNumber: Integer
OrderItems_3_manualQuantity: Boolean
OrderItems_3_manualUnitCost: Boolean
OrderItems_3_positionNumber: Integer
Payments_0_lastModifiedDate: Integer
Payments_1_lastModifiedDate: Integer
ShippingCostItems_0_taxName: String
ShippingCostItems_0_version: String
AvailabilityForAllWarehouses: String
GrossAmountInCompanyCurrency: String
OrderItems_0_manualUnitPrice: Boolean
OrderItems_0_shippedQuantity: String
OrderItems_1_manualUnitPrice: Boolean
OrderItems_1_shippedQuantity: String
OrderItems_2_manualUnitPrice: Boolean
OrderItems_2_shippedQuantity: String
OrderItems_3_manualUnitPrice: Boolean
OrderItems_3_shippedQuantity: String
Customfield_Rabattbezeichnung: String
OrderItems_0_descriptionFixed: Boolean
OrderItems_0_invoicedQuantity: String
OrderItems_0_lastModifiedDate: Integer
OrderItems_1_descriptionFixed: Boolean
OrderItems_1_invoicedQuantity: String
OrderItems_1_lastModifiedDate: Integer
OrderItems_2_descriptionFixed: Boolean
OrderItems_2_invoicedQuantity: String
OrderItems_2_lastModifiedDate: Integer
OrderItems_3_descriptionFixed: Boolean
OrderItems_3_invoicedQuantity: String
OrderItems_3_lastModifiedDate: Integer
Payments_0_salesInvoices_0_id: String
Payments_0_salesInvoices_1_id: String
Payments_1_salesInvoices_0_id: String
Payments_1_salesInvoices_1_id: String
ShippingCostItems_0_articleId: String
ShippingCostItems_0_netAmount: String
ShippingCostItems_0_unitPrice: String
OrderItems_0_addPageBreakBefore: Boolean
OrderItems_0_discountPercentage: String
OrderItems_1_addPageBreakBefore: Boolean
OrderItems_1_discountPercentage: String
OrderItems_2_addPageBreakBefore: Boolean
OrderItems_2_discountPercentage: String
OrderItems_3_addPageBreakBefore: Boolean
OrderItems_3_discountPercentage: String
ShippingCostItems_0_createdDate: Integer
ShippingCostItems_0_grossAmount: String
RecordEmailAddresses_ccAddresses: String
RecordEmailAddresses_toAddresses: String
RecordEmailAddresses_bccAddresses: String
ShippingCostItems_0_articleNumber: String
DeliveryEmailAddresses_ccAddresses: String
DeliveryEmailAddresses_toAddresses: String
ShippingCostItems_0_manualUnitCost: Boolean
DeliveryEmailAddresses_bccAddresses: String
OrderItems_0_netAmountForStatistics: String
OrderItems_1_netAmountForStatistics: String
OrderItems_2_netAmountForStatistics: String
OrderItems_3_netAmountForStatistics: String
ShippingCostItems_0_manualUnitPrice: Boolean
StatusHistory_0_creditLimitExceeded: Boolean
StatusHistory_1_creditLimitExceeded: Boolean
StatusHistory_2_creditLimitExceeded: Boolean
StatusHistory_3_creditLimitExceeded: Boolean
ShippingCostItems_0_lastModifiedDate: Integer
OrderItems_0_plannedWorkingTimePerUnit: Integer
OrderItems_0_unitCostInCompanyCurrency: String
OrderItems_1_unitCostInCompanyCurrency: String
OrderItems_2_unitCostInCompanyCurrency: String
SalesInvoiceEmailAddresses_ccAddresses: String
SalesInvoiceEmailAddresses_toAddresses: String
OrderItems_0_netAmountInCompanyCurrency: String
OrderItems_0_unitPriceInCompanyCurrency: String
OrderItems_1_netAmountInCompanyCurrency: String
OrderItems_1_unitPriceInCompanyCurrency: String
OrderItems_2_netAmountInCompanyCurrency: String
OrderItems_2_unitPriceInCompanyCurrency: String
OrderItems_3_netAmountInCompanyCurrency: String
OrderItems_3_unitPriceInCompanyCurrency: String
SalesInvoiceEmailAddresses_bccAddresses: String
OrderItems_0_availabilityForAllWarehouses: String
OrderItems_0_grossAmountInCompanyCurrency: String
OrderItems_1_availabilityForAllWarehouses: String
OrderItems_1_grossAmountInCompanyCurrency: String
OrderItems_2_availabilityForAllWarehouses: String
OrderItems_2_grossAmountInCompanyCurrency: String
OrderItems_3_availabilityForAllWarehouses: String
OrderItems_3_grossAmountInCompanyCurrency: String
OrderItems_0_manualPlannedWorkingTimePerUnit: Boolean
OrderItems_1_manualPlannedWorkingTimePerUnit: Boolean
OrderItems_2_manualPlannedWorkingTimePerUnit: Boolean
OrderItems_3_manualPlannedWorkingTimePerUnit: Boolean
ShippingCostItems_0_netAmountInCompanyCurrency: String
ShippingCostItems_0_unitPriceInCompanyCurrency: String
ShippingCostItems_0_grossAmountInCompanyCurrency: String
OrderItems_0_netAmountForStatisticsInCompanyCurrency: String
OrderItems_1_netAmountForStatisticsInCompanyCurrency: String
OrderItems_2_netAmountForStatisticsInCompanyCurrency: String
OrderItems_3_netAmountForStatisticsInCompanyCurrency: String

Weclapp
Table Shipment
Id: String
Status: String
Version: String
CreatorId: String
CreatedDate: Date-time
Description: String
WarehouseId: String
Availability: String
DeliveryDate: Integer
PackageWidth: Integer
SalesOrderId: String
ShipmentType: String
ShippingDate: Integer
PackageHeight: Integer
PackageLength: Integer
PackageWeight: String
PicksComplete: Boolean
RecordComment: String
ShipmentItems: String
StatusHistory: String
WarehouseName: String
RecordFreeText: String
ShipmentNumber: String
SentToRecipient: Boolean
LastModifiedDate: Date-time
RecipientPartyId: String
SalesOrderNumber: String
SalesOrders_0_id: String
ShipmentMethodId: String
Customfield_Bezug: String
ShippingCarrierId: String
CommercialLanguage: String
InvoiceRecipientId: String
PackageTrackingUrl: String
ShipmentItems_0_id: String
ShipmentItems_1_id: String
ShipmentItems_2_id: String
ShipmentItems_3_id: String
ShipmentMethodName: String
DeclaredValueAmount: String
InvoiceAddress_city: String
PickingInstructions: String
ShippingCarrierName: String
ShippingLabelsCount: Integer
DisableEmailTemplate: Boolean
InvoiceAddress_title: String
PackageTrackingNumber: String
RecipientAddress_city: String
ShipmentItems_0_title: String
ShipmentItems_1_title: String
ShipmentItems_2_title: String
ShipmentItems_3_title: String
DestinationWarehouseId: String
InvoiceAddress_company: String
InvoiceAddress_street1: String
InvoiceAddress_titleId: String
InvoiceAddress_zipcode: String
PackageReferenceNumber: String
RecipientAddress_title: String
ShipmentItems_0_unitId: String
ShipmentItems_1_unitId: String
ShipmentItems_2_unitId: String
ShipmentItems_3_unitId: String
StatusHistory_0_status: String
StatusHistory_0_userId: String
StatusHistory_1_status: String
StatusHistory_1_userId: String
StatusHistory_2_status: String
StatusHistory_2_userId: String
InvoiceAddress_company2: String
InvoiceAddress_lastName: String
RecipientCustomerNumber: String
RecipientSupplierNumber: String
ShipmentItems_0_version: String
ShipmentItems_1_version: String
ShipmentItems_2_version: String
ShipmentItems_3_version: String
ShippedFromAddress_city: String
DestinationWarehouseName: String
InvoiceAddress_firstName: String
RecipientAddress_company: String
RecipientAddress_street1: String
RecipientAddress_titleId: String
RecipientAddress_zipcode: String
ShipmentItems_0_quantity: String
ShipmentItems_0_unitName: String
ShipmentItems_1_quantity: String
ShipmentItems_1_unitName: String
ShipmentItems_2_quantity: String
ShipmentItems_2_unitName: String
ShipmentItems_3_quantity: String
ShipmentItems_3_unitName: String
DestinationStoragePlaceId: String
InvoiceAddress_salutation: String
RecipientAddress_company2: String
RecipientAddress_lastName: String
ShipmentItems_0_articleId: String
ShipmentItems_1_articleId: String
ShipmentItems_2_articleId: String
ShipmentItems_3_articleId: String
InvoiceAddress_countryCode: String
RecipientAddress_firstName: String
ShipmentItems_0_picks_0_id: String
ShipmentItems_1_picks_0_id: String
ShipmentItems_2_picks_0_id: String
ShippedFromAddress_street1: String
ShippedFromAddress_zipcode: String
StatusHistory_0_statusDate: Integer
StatusHistory_1_statusDate: Integer
StatusHistory_2_statusDate: Integer
CustomerPurchaseOrderNumber: String
RecipientAddress_salutation: String
ShipmentItems_0_createdDate: Integer
ShipmentItems_0_description: String
ShipmentItems_1_createdDate: Integer
ShipmentItems_1_description: String
ShipmentItems_2_createdDate: Integer
ShipmentItems_2_description: String
ShipmentItems_3_createdDate: Integer
ShipmentItems_3_description: String
AvailabilityForAllWarehouses: String
RecipientAddress_countryCode: String
ShipmentItems_0_availability: String
ShipmentItems_0_freeTextItem: Boolean
ShipmentItems_0_parentItemId: String
ShipmentItems_1_availability: String
ShipmentItems_1_freeTextItem: Boolean
ShipmentItems_1_parentItemId: String
ShipmentItems_2_availability: String
ShipmentItems_2_freeTextItem: Boolean
ShipmentItems_2_parentItemId: String
ShipmentItems_3_availability: String
ShipmentItems_3_freeTextItem: Boolean
AdditionalDeliveryInformation: String
DeclaredValueAmountCurrencyId: String
ShipmentItems_0_articleNumber: String
ShipmentItems_1_articleNumber: String
ShipmentItems_2_articleNumber: String
ShipmentItems_3_articleNumber: String
ShipmentItems_0_manualQuantity: Boolean
ShipmentItems_0_positionNumber: Integer
ShipmentItems_1_manualQuantity: Boolean
ShipmentItems_1_positionNumber: Integer
ShipmentItems_2_manualQuantity: Boolean
ShipmentItems_2_positionNumber: Integer
ShipmentItems_3_manualQuantity: Boolean
ShipmentItems_3_positionNumber: Integer
ShippedFromAddress_countryCode: String
DeclaredValueAmountCurrencyName: String
ShipmentItems_0_picks_0_version: String
ShipmentItems_1_picks_0_version: String
ShipmentItems_2_picks_0_version: String
RecordEmailAddresses_ccAddresses: String
RecordEmailAddresses_toAddresses: String
ShipmentItems_0_descriptionFixed: Boolean
ShipmentItems_0_lastModifiedDate: Integer
ShipmentItems_0_picks_0_quantity: String
ShipmentItems_0_salesOrderItemId: String
ShipmentItems_1_descriptionFixed: Boolean
ShipmentItems_1_lastModifiedDate: Integer
ShipmentItems_1_picks_0_quantity: String
ShipmentItems_1_salesOrderItemId: String
ShipmentItems_2_descriptionFixed: Boolean
ShipmentItems_2_lastModifiedDate: Integer
ShipmentItems_2_picks_0_quantity: String
ShipmentItems_2_salesOrderItemId: String
ShipmentItems_3_descriptionFixed: Boolean
ShipmentItems_3_lastModifiedDate: Integer
ShipmentItems_3_salesOrderItemId: String
ShipmentItems_0_addPageBreakBefore: Boolean
ShipmentItems_0_picks_0_bookedDate: Integer
ShipmentItems_1_addPageBreakBefore: Boolean
ShipmentItems_1_picks_0_bookedDate: Integer
ShipmentItems_2_addPageBreakBefore: Boolean
ShipmentItems_2_picks_0_bookedDate: Integer
ShipmentItems_3_addPageBreakBefore: Boolean
CustomAttributes_0_entityReferences: String
ShipmentItems_0_picks_0_batchNumber: String
ShipmentItems_0_picks_0_createdDate: Integer
ShipmentItems_1_picks_0_batchNumber: String
ShipmentItems_1_picks_0_createdDate: Integer
ShipmentItems_2_picks_0_createdDate: Integer
ShipmentItems_0_picks_0_confirmedDate: Integer
ShipmentItems_0_picks_0_serialNumbers: String
SalesInvoiceEmailAddresses_ccAddresses: String
SalesInvoiceEmailAddresses_toAddresses: String
ShipmentItems_0_picks_0_storagePlaceId: String
ShipmentItems_1_picks_0_storagePlaceId: String
ShipmentItems_2_picks_0_storagePlaceId: String
ShipmentItems_0_picks_0_serialNumbers_0: String
ShipmentItems_0_picks_0_serialNumbers_1: String
ShipmentItems_0_picks_0_serialNumbers_2: String
ShipmentItems_1_picks_0_serialNumbers_0: String
CustomAttributes_0_attributeDefinitionId: String
ShipmentItems_0_picks_0_lastModifiedDate: Integer
ShipmentItems_1_picks_0_lastModifiedDate: Integer
ShipmentItems_2_picks_0_lastModifiedDate: Integer
ShipmentItems_0_picks_0_confirmedByUserId: String
ShipmentItems_0_availabilityForAllWarehouses: String
ShipmentItems_0_picks_0_sourceStoragePlaceId: String
ShipmentItems_1_availabilityForAllWarehouses: String
ShipmentItems_1_picks_0_sourceStoragePlaceId: String
ShipmentItems_2_availabilityForAllWarehouses: String
ShipmentItems_2_picks_0_sourceStoragePlaceId: String
ShipmentItems_3_availabilityForAllWarehouses: String
ShipmentItems_0_picks_0_transportationOrderId: String
CustomAttributes_0_entityReferences_0_entityId: String
CustomAttributes_0_entityReferences_0_entityName: String
ShipmentItems_0_picks_0_internalTransportReferenceId: String
ShipmentItems_0_picks_0_sourceInternalTransportReferenceId: String

Weclapp
Table Supplier
Id: String
Email: String
Phone: String
Company: String
Version: String
SectorId: String
PartyType: String
CurrencyId: String
OrderBlock: Boolean
SectorName: String
CreatedDate: Date-time
Description: String
CurrencyName: String
Contacts_0_id: String
Addresses_0_id: String
Addresses_1_id: String
SupplierNumber: String
PaymentMethodId: String
Addresses_0_city: String
Addresses_1_city: String
Contacts_0_email: String
Contacts_0_optIn: Boolean
Contacts_0_phone: String
CustomAttributes: String
LastModifiedDate: Date-time
PrimaryAddressId: String
PrimaryContactId: String
BankAccounts_0_id: String
Customfield_Bezug: String
DeliveryAddressId: String
PaymentMethodName: String
Contacts_0_version: String
Addresses_0_street1: String
Addresses_0_version: String
Addresses_0_zipcode: String
Addresses_1_street1: String
Addresses_1_street2: String
Addresses_1_version: String
Addresses_1_zipcode: String
Contacts_0_lastName: String
Contacts_0_optInSms: Boolean
Customfield_Leasing: Boolean
Customfield_Partner: Boolean
Customfield_Produkt: String
Addresses_0_lastName: String
Addresses_1_lastName: String
CommercialLanguageId: String
Contacts_0_firstName: String
Contacts_0_partyType: String
Addresses_0_firstName: String
Addresses_1_firstName: String
Contacts_0_optInPhone: Boolean
Contacts_0_salutation: String
Customfield_Ansprache: String
VatRegistrationNumber: String
Addresses_0_salutation: String
Addresses_1_salutation: String
BankAccounts_0_partyId: String
BankAccounts_0_primary: Boolean
BankAccounts_0_version: String
Contacts_0_createdDate: Integer
Contacts_0_optInLetter: Boolean
Customfield_Hersteller: Boolean
Addresses_0_countryCode: String
Addresses_0_createdDate: Integer
Addresses_1_countryCode: String
Addresses_1_createdDate: Integer
BankAccounts_0_bankCode: String
Contacts_0_mobilePhone1: String
Customfield_Key Account: String
Addresses_0_primeAddress: Boolean
Addresses_1_primeAddress: Boolean
Contacts_0_personCompany: String
CustomerNumberAtSupplier: String
Customfield_Teststellung: String
Customfield_pipedrive_id: String
Contacts_0_addresses_0_id: String
Addresses_0_invoiceAddress: Boolean
Addresses_1_invoiceAddress: Boolean
BankAccounts_0_createdDate: Integer
Addresses_0_deliveryAddress: Boolean
Addresses_1_deliveryAddress: Boolean
Contacts_0_lastModifiedDate: Integer
Contacts_0_primaryAddressId: String
Addresses_0_lastModifiedDate: Integer
Addresses_1_lastModifiedDate: Integer
BankAccounts_0_accountHolder: String
BankAccounts_0_accountNumber: String
BankAccounts_0_creditInstitute: String
Contacts_0_addresses_0_version: String
BankAccounts_0_lastModifiedDate: Integer
Contacts_0_addresses_0_countryCode: String
Contacts_0_addresses_0_createdDate: Integer
Contacts_0_addresses_0_primeAddress: Boolean
Contacts_0_addresses_0_invoiceAddress: Boolean
Contacts_0_addresses_0_deliveryAddress: Boolean
Contacts_0_addresses_0_lastModifiedDate: Integer
Customfield_alte Kundennummer (Filemaker): String

Weclapp
Table User
Id: String
Email: String
Status: String
ImageId: String
Version: String
LastName: String
Username: String
FirstName: String
UserRoles: String
Licenses_0: String
CreatedDate: Date-time
PhoneNumber: String
LastModifiedDate: Date-time
MobilePhoneNumber: String

Weclapp
Table Attendance

Weclapp
Table Calendar Event

Weclapp
Table Campaign

Weclapp
Table Campaign Participant

Weclapp
Table Contract

Weclapp
Table Currency

Weclapp
Table Crm Event

Weclapp
Table Opportunity

Weclapp
Table Payment Method

Weclapp
Table Production Order

Weclapp
Table Production Work Schedule

Weclapp
Table Purchase Invoice

Weclapp
Table Shipment Method

Weclapp
Table Tag

Weclapp
Table Ticket

Weclapp
Table Person Role

Weclapp
Table Sales Open Item

Weclapp
Table Purchase Open Item

Weclapp
Table Customer

Weclapp
Table Warehouse Stock

Weclapp
Table Warehouse Stock Movement

Weclapp
Table Inventory

Weclapp
Table Purchase Order Request

Weclapp
Table Purchase Requisition

SQL - Combine data

Magical SQL for WeClapp with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Peliqan Overview

Ready to get instant access to
all your company data ?