Total purchase amount by supplier
SQL query for WeClapp
Calculate the total purchase amount for each supplier.
SELECT supplier.name, SUM(purchaseInvoice.totalAmount) AS total_purchase_amount FROM supplier INNER JOIN purchaseOrder ON supplier.id = purchaseOrder.supplierId INNER JOIN purchaseInvoice ON purchaseOrder.id = purchaseInvoice.orderId GROUP BY supplier.name
WeClapp data model
Accounting Transaction
View 30 columns
IdString
TypeString
DraftBoolean
StatusString
VersionString
CurrencyIdString
CreatedDateDate-time
CurrencyNameString
TransactionDateInteger
LastModifiedDateDate-time
TransactionNumberString
ReverseTransactionBoolean
TransactionDetailsString
ExternalRecordNumberString
InternalRecordNumberString
TransactionEstablishDateInteger
TransactionDetails_0_taxIdString
TransactionDetails_1_taxIdString
TransactionDetails_0_amountString
TransactionDetails_1_amountString
TransactionDetails_2_amountString
TransactionDetails_0_accountIdString
TransactionDetails_1_accountIdString
TransactionDetails_2_accountIdString
TransactionDetails_0_debitCreditString
TransactionDetails_0_descriptionString
TransactionDetails_1_debitCreditString
TransactionDetails_1_descriptionString
TransactionDetails_2_debitCreditString
TransactionDetails_2_descriptionString
Article
View 123 columns
IdString
NameString
ActiveBoolean
UnitIdString
VersionString
UnitNameString
AccountIdString
ArticleTypeString
CreatedDateDate-time
DescriptionString
TaxRateTypeString
InternalNoteString
LowLevelCodeInteger
AccountNumberString
ArticleNumberString
InvoicingTypeString
CommissionRateString
ManufacturerIdString
AvailableInSaleBoolean
LastModifiedDateDate-time
ManufacturerNameString
ApplyCashDiscountBoolean
ArticleCategoryIdString
ProductionArticleBoolean
ShortDescription1String
ArticlePrices_0_idString
ArticlePrices_1_idString
ArticlePrices_2_idString
ArticlePrices_3_idString
ShowOnDeliveryNoteBoolean
SupplySources_0_idString
AverageDeliveryTimeInteger
BatchNumberRequiredBoolean
CountryOfOriginCodeString
SerialNumberRequiredBoolean
ArticlePrices_0_priceString
ArticlePrices_1_priceString
ArticlePrices_2_priceString
ArticlePrices_3_priceString
PrimarySupplySourceIdString
ArticlePrices_0_versionString
ArticlePrices_1_versionString
ArticlePrices_2_endDateInteger
ArticlePrices_2_versionString
ArticlePrices_3_endDateInteger
ArticlePrices_3_versionString
SupplySources_0_versionString
SalesBillOfMaterialItemsString
ArticlePrices_0_startDateInteger
ArticlePrices_1_startDateInteger
ArticlePrices_2_startDateInteger
ArticlePrices_3_startDateInteger
PlannedWorkingTimePerUnitInteger
ArticlePrices_0_currencyIdString
ArticlePrices_1_currencyIdString
ArticlePrices_2_currencyIdString
ArticlePrices_3_currencyIdString
MarginCalculationPriceTypeString
PackagingUnitBaseArticleIdString
ArticlePrices_0_createdDateInteger
ArticlePrices_1_createdDateInteger
ArticlePrices_2_createdDateInteger
ArticlePrices_3_createdDateInteger
DefaultPriceCalculationTypeString
ProductionConfigurationRuleString
SupplySources_0_createdDateInteger
ArticlePrices_0_currencyNameString
ArticlePrices_0_salesChannelString
ArticlePrices_1_currencyNameString
ArticlePrices_1_salesChannelString
ArticlePrices_2_currencyNameString
ArticlePrices_2_salesChannelString
ArticlePrices_3_currencyNameString
ArticlePrices_3_salesChannelString
UseAvailableForSalesChannelsBoolean
DefineIndividualTaskTemplatesBoolean
SalesBillOfMaterialItems_0_idString
SalesBillOfMaterialItems_1_idString
SalesBillOfMaterialItems_2_idString
ArticlePrices_0_priceScaleTypeString
ArticlePrices_1_priceScaleTypeString
ArticlePrices_2_priceScaleTypeString
ArticlePrices_3_priceScaleTypeString
SupplySources_0_positionNumberInteger
ArticlePrices_0_priceScaleValueString
ArticlePrices_1_priceScaleValueString
ArticlePrices_2_priceScaleValueString
ArticlePrices_3_priceScaleValueString
ArticlePrices_0_lastModifiedDateInteger
ArticlePrices_1_lastModifiedDateInteger
ArticlePrices_2_lastModifiedDateInteger
ArticlePrices_3_lastModifiedDateInteger
SupplySources_0_lastModifiedDateInteger
UseSalesBillOfMaterialItemPricesBoolean
BillOfMaterialPartDeliveryPossibleBoolean
SalesBillOfMaterialItems_0_versionString
SalesBillOfMaterialItems_1_versionString
SalesBillOfMaterialItems_2_versionString
UseSalesBillOfMaterialSubitemCostsBoolean
SalesBillOfMaterialItems_0_quantityString
SalesBillOfMaterialItems_1_quantityString
SalesBillOfMaterialItems_2_quantityString
ArticlePrices_0_lastModifiedByUserIdString
ArticlePrices_1_lastModifiedByUserIdString
ArticlePrices_2_lastModifiedByUserIdString
ArticlePrices_3_lastModifiedByUserIdString
SalesBillOfMaterialItems_0_articleIdString
SalesBillOfMaterialItems_1_articleIdString
SalesBillOfMaterialItems_2_articleIdString
SupplySources_0_articleSupplySourceIdString
SalesBillOfMaterialItems_0_createdDateInteger
SalesBillOfMaterialItems_1_createdDateInteger
SalesBillOfMaterialItems_2_createdDateInteger
SalesBillOfMaterialItems_0_articleNumberString
SalesBillOfMaterialItems_1_articleNumberString
SalesBillOfMaterialItems_2_articleNumberString
SalesBillOfMaterialItems_0_positionNumberInteger
SalesBillOfMaterialItems_1_positionNumberInteger
SalesBillOfMaterialItems_2_positionNumberInteger
SalesBillOfMaterialItems_0_lastModifiedDateInteger
SalesBillOfMaterialItems_1_lastModifiedDateInteger
SalesBillOfMaterialItems_2_lastModifiedDateInteger
UseSalesBillOfMaterialItemPricesForPurchaseBoolean
Article Custom Attributes
View 6 columns
DateValueDate-time
Article_idString
NumberValueNumber
StringValueString
BooleanValueBoolean
AttributeDefinitionIdString
Batch Number
View 7 columns
IdString
VersionString
ArticleIdString
BatchNumberString
CreatedDateDate-time
ArticleNumberString
LastModifiedDateDate-time
Contact
View 40 columns
IdString
EmailString
OptInBoolean
PhoneString
TitleString
TitleIdString
VersionString
Company2String
LastNameString
OptInSmsBoolean
FirstNameString
FixPhone2String
PartyTypeString
OptInPhoneBoolean
SalutationString
CreatedDateDate-time
OptInLetterBoolean
MobilePhone1String
PersonCompanyString
Addresses_0_idString
LastModifiedDateDate-time
PrimaryAddressIdString
Customfield_BezugString
PersonDepartmentIdString
Addresses_0_versionString
Customfield_PartnerBoolean
Addresses_0_countryCodeString
Addresses_0_createdDateInteger
Addresses_0_primeAddressBoolean
Customfield_pipedrive_idString
Addresses_0_invoiceAddressBoolean
Addresses_0_deliveryAddressBoolean
Addresses_0_lastModifiedDateInteger
CustomAttributes_2_numberValueString
CustomAttributes_0_booleanValueBoolean
CustomAttributes_0_attributeDefinitionIdString
CustomAttributes_1_attributeDefinitionIdString
CustomAttributes_2_attributeDefinitionIdString
CustomAttributes_3_attributeDefinitionIdString
Customfield_alte Kundennummer (Filemaker)String
Custom Attribute Definition
View 24 columns
IdString
LabelString
ActiveBoolean
VersionString
EntitiesString
ReadOnlyBoolean
MandatoryBoolean
Entities_0String
Entities_1String
Entities_2String
CreatedDateDate-time
AttributeKeyString
AttributeTypeString
ShowInOverviewBoolean
LastModifiedDateDate-time
LegacyEntities_0String
LegacyEntities_1String
LegacyEntities_2String
LegacyEntities_3String
SelectableValuesString
DefaultBooleanValueBoolean
ShowOnCreationDialogBoolean
SystemCustomAttributeBoolean
ShowAttributeEntityTypeBoolean
Incoming Goods
View 143 columns
IdString
StatusString
VersionString
CreatorIdString
CreatedDateDate-time
DescriptionString
WarehouseIdString
SalesOrderIdString
RecordCommentString
SenderPartyIdString
WarehouseNameString
PurchaseOrderIdString
SentToRecipientBoolean
LastModifiedDateDate-time
SalesOrderNumberString
SalesOrders_0_idString
IncomingGoodsTypeString
RelatedShipmentIdString
SourceWarehouseIdString
CommercialLanguageString
DeliveryNoteNumberString
IncomingGoodsItemsString
InvoiceRecipientIdString
ReturnAddress_cityString
IncomingGoodsNumberString
InvoiceAddress_cityString
PurchaseOrderNumberString
PurchaseOrders_0_idString
SourceWarehouseNameString
DisableEmailTemplateBoolean
SenderCustomerNumberString
SenderSupplierNumberString
RecipientAddress_cityString
ReturnAddress_companyString
ReturnAddress_street1String
ReturnAddress_zipcodeString
InvoiceAddress_companyString
InvoiceAddress_street1String
InvoiceAddress_zipcodeString
ReturnAddress_company2String
ReturnAddress_lastNameString
StatusHistory_0_statusString
StatusHistory_0_userIdString
StatusHistory_1_statusString
StatusHistory_1_userIdString
IncomingGoodsItems_0_idString
IncomingGoodsItems_1_idString
IncomingGoodsItems_2_idString
IncomingGoodsItems_3_idString
ReturnAddress_firstNameString
RecipientAddress_companyString
RecipientAddress_street1String
RecipientAddress_zipcodeString
ReturnAddress_salutationString
RecipientAddress_company2String
RecipientAddress_lastNameString
ReturnAddress_countryCodeString
IncomingGoodsItems_0_titleString
IncomingGoodsItems_1_titleString
IncomingGoodsItems_2_titleString
IncomingGoodsItems_3_titleString
InvoiceAddress_countryCodeString
InvoiceAddress_phoneNumberString
RecipientAddress_firstNameString
StatusHistory_0_statusDateInteger
StatusHistory_1_statusDateInteger
CustomerInvoiceAddress_cityString
IncomingGoodsItems_0_unitIdString
IncomingGoodsItems_1_unitIdString
IncomingGoodsItems_2_unitIdString
IncomingGoodsItems_3_unitIdString
RecipientAddress_salutationString
CustomerDeliveryAddress_cityString
IncomingGoodsItems_0_versionString
IncomingGoodsItems_1_versionString
IncomingGoodsItems_2_versionString
IncomingGoodsItems_3_versionString
RecipientAddress_countryCodeString
IncomingGoodsItems_0_quantityString
IncomingGoodsItems_0_unitNameString
IncomingGoodsItems_1_quantityString
IncomingGoodsItems_1_unitNameString
IncomingGoodsItems_2_quantityString
IncomingGoodsItems_2_unitNameString
IncomingGoodsItems_3_quantityString
IncomingGoodsItems_3_unitNameString
CustomerInvoiceAddress_companyString
CustomerInvoiceAddress_street1String
CustomerInvoiceAddress_zipcodeString
IncomingGoodsItems_0_articleIdString
IncomingGoodsItems_1_articleIdString
IncomingGoodsItems_2_articleIdString
IncomingGoodsItems_3_articleIdString
CustomerDeliveryAddress_companyString
CustomerDeliveryAddress_street1String
CustomerDeliveryAddress_zipcodeString
CustomerInvoiceAddress_company2String
CustomerInvoiceAddress_lastNameString
CustomerDeliveryAddress_company2String
CustomerDeliveryAddress_lastNameString
CustomerInvoiceAddress_firstNameString
IncomingGoodsItems_0_createdDateInteger
IncomingGoodsItems_0_descriptionString
IncomingGoodsItems_1_createdDateInteger
IncomingGoodsItems_1_descriptionString
IncomingGoodsItems_2_createdDateInteger
IncomingGoodsItems_2_descriptionString
IncomingGoodsItems_3_createdDateInteger
IncomingGoodsItems_3_descriptionString
CustomerDeliveryAddress_firstNameString
CustomerInvoiceAddress_salutationString
IncomingGoodsItems_0_parentItemIdString
IncomingGoodsItems_2_parentItemIdString
CustomerDeliveryAddress_salutationString
CustomerInvoiceAddress_countryCodeString
IncomingGoodsItems_0_articleNumberString
IncomingGoodsItems_1_articleNumberString
IncomingGoodsItems_2_articleNumberString
IncomingGoodsItems_3_articleNumberString
CustomerDeliveryAddress_countryCodeString
IncomingGoodsItems_0_manualQuantityBoolean
IncomingGoodsItems_0_positionNumberInteger
IncomingGoodsItems_1_manualQuantityBoolean
IncomingGoodsItems_1_positionNumberInteger
IncomingGoodsItems_2_manualQuantityBoolean
IncomingGoodsItems_2_positionNumberInteger
IncomingGoodsItems_3_manualQuantityBoolean
IncomingGoodsItems_3_positionNumberInteger
IncomingGoodsItems_0_descriptionFixedBoolean
IncomingGoodsItems_0_lastModifiedDateInteger
IncomingGoodsItems_0_salesOrderItemIdString
IncomingGoodsItems_1_descriptionFixedBoolean
IncomingGoodsItems_1_lastModifiedDateInteger
IncomingGoodsItems_1_salesOrderItemIdString
IncomingGoodsItems_2_descriptionFixedBoolean
IncomingGoodsItems_2_lastModifiedDateInteger
IncomingGoodsItems_2_salesOrderItemIdString
IncomingGoodsItems_3_descriptionFixedBoolean
IncomingGoodsItems_3_lastModifiedDateInteger
IncomingGoodsItems_0_purchaseOrderItemIdString
IncomingGoodsItems_1_purchaseOrderItemIdString
IncomingGoodsItems_2_purchaseOrderItemIdString
IncomingGoodsItems_3_purchaseOrderItemIdString
Lead
View 102 columns
IdString
EmailString
OptInBoolean
PhoneString
CompanyString
VersionString
Company2String
LastNameString
OptInSmsBoolean
SectorIdString
FirstNameString
PartyTypeString
CurrencyIdString
LeadNumberString
LeadStatusString
OptInPhoneBoolean
SalutationString
SectorNameString
CreatedDateDate-time
DescriptionString
OptInLetterBoolean
CurrencyNameString
MobilePhone1String
SalesChannelString
Contacts_0_idString
Contacts_1_idString
OldLeadNumberString
Addresses_0_idString
PaymentMethodIdString
TermOfPaymentIdString
Addresses_0_cityString
Contacts_0_emailString
Contacts_0_optInBoolean
Contacts_0_phoneString
Contacts_1_emailString
Contacts_1_optInBoolean
Contacts_1_phoneString
CustomAttributesString
InvoiceAddressIdString
LastModifiedDateDate-time
PrimaryAddressIdString
PrimaryContactIdString
ShipmentMethodIdString
Addresses_0_stateString
Customfield_BezugString
DeliveryAddressIdString
PaymentMethodNameString
ResponsibleUserIdString
TermOfPaymentNameString
Contacts_0_versionString
Contacts_1_versionString
ShipmentMethodNameString
Addresses_0_street1String
Addresses_0_versionString
Addresses_0_zipcodeString
Contacts_0_company2String
Contacts_0_lastNameString
Contacts_0_optInSmsBoolean
Contacts_1_lastNameString
Contacts_1_optInSmsBoolean
Customfield_LeasingBoolean
Customfield_PartnerBoolean
Customfield_ProduktString
Addresses_0_lastNameString
CommercialLanguageIdString
Contacts_0_firstNameString
Contacts_0_partyTypeString
Contacts_1_firstNameString
Contacts_1_partyTypeString
ResponsibleUserFixedBoolean
Addresses_0_firstNameString
Contacts_0_optInPhoneBoolean
Contacts_0_salutationString
Contacts_1_optInPhoneBoolean
Contacts_1_salutationString
Customfield_AnspracheString
VatRegistrationNumberString
Addresses_0_salutationString
Contacts_0_createdDateInteger
Contacts_0_optInLetterBoolean
Contacts_1_createdDateInteger
Contacts_1_optInLetterBoolean
Addresses_0_countryCodeString
Addresses_0_createdDateInteger
Contacts_0_mobilePhone1String
Contacts_0_personRoleIdString
Contacts_1_mobilePhone1String
Customfield_Key AccountString
ResponsibleUserUsernameString
Addresses_0_primeAddressBoolean
Contacts_0_personCompanyString
Contacts_1_personCompanyString
Customfield_TeststellungString
Customfield_pipedrive_idString
Addresses_0_invoiceAddressBoolean
Addresses_0_deliveryAddressBoolean
Contacts_0_lastModifiedDateInteger
Contacts_0_primaryAddressIdString
Contacts_1_lastModifiedDateInteger
Contacts_1_primaryAddressIdString
Addresses_0_lastModifiedDateInteger
Customfield_alte Kundennummer (Filemaker)String
Ledger Account
View 8 columns
IdString
TypeString
VersionString
AutomaticBoolean
CreatedDateDate-time
DescriptionString
AccountNumberString
LastModifiedDateDate-time
Party
View 68 columns
IdString
EmailString
PhoneString
TitleString
TitleIdString
VersionString
Company2String
CustomerBoolean
LastNameString
OptInSmsBoolean
RegionIdString
SectorIdString
SupplierBoolean
FactoringBoolean
FirstNameString
FixPhone2String
PartyTypeString
OptInEmailBoolean
OptInPhoneBoolean
SalutationString
SectorNameString
CreatedDateDate-time
OptInLetterBoolean
InvoiceBlockBoolean
LeadSourceIdString
MobilePhone1String
SalesPartnerBoolean
PersonCompanyString
Addresses_0_idString
LeadSourceNameString
CommissionBlockBoolean
CustomerBlockedBoolean
CustomerInsuredBoolean
HabitualExporterBoolean
LastModifiedDateDate-time
PrimaryAddressIdString
CustomerInsolventBoolean
Customfield_BezugString
ResponsibleUserIdString
FormerSalesPartnerBoolean
PersonDepartmentIdString
PurchaseViaPlafondBoolean
SupplierOrderBlockBoolean
Addresses_0_versionString
Customfield_PartnerBoolean
CommercialLanguageIdString
CustomerBusinessTypeString
FixedResponsibleUserBoolean
CustomerDeliveryBlockBoolean
Addresses_0_countryCodeString
Addresses_0_createdDateInteger
ResponsibleUserUsernameString
Addresses_0_primeAddressBoolean
Customfield_pipedrive_idString
Addresses_0_invoiceAddressBoolean
AllowPurchaseOrderCreationBoolean
Addresses_0_deliveryAddressBoolean
Addresses_0_lastModifiedDateInteger
CustomAttributes_2_numberValueString
CustomerUseCustomsTariffNumberBoolean
CustomAttributes_0_booleanValueBoolean
EnableDropshippingInNewSupplySourcesBoolean
CustomerAllowDropshippingOrderCreationBoolean
CustomAttributes_0_attributeDefinitionIdString
CustomAttributes_1_attributeDefinitionIdString
CustomAttributes_2_attributeDefinitionIdString
CustomAttributes_3_attributeDefinitionIdString
Customfield_alte Kundennummer (Filemaker)String
Pick
View 19 columns
IdString
VersionString
QuantityString
BookedDateInteger
BatchNumberString
CreatedDateDate-time
ConfirmedDateInteger
SerialNumbersString
PositionNumberInteger
ShipmentItemIdString
StoragePlaceIdString
SerialNumbers_0String
LastModifiedDateDate-time
ConfirmedByUserIdString
SourceStoragePlaceIdString
TransportationOrderIdString
PackagingUnitBaseArticleIdString
InternalTransportReferenceIdString
SourceInternalTransportReferenceIdString
Purchase Order
View 219 columns
IdString
PaidBoolean
StatusString
VersionString
InvoicedBoolean
ReceivedBoolean
CreatorIdString
NetAmountString
OrderDateInteger
SupplierIdString
CreatedDateDate-time
DescriptionString
GrossAmountString
WarehouseIdString
RecordCommentString
StatusHistoryString
WarehouseNameString
HeaderDiscountString
RecordFreeTextString
SupplierNumberString
HeaderSurchargeString
PaymentMethodIdString
SentToRecipientBoolean
LastModifiedDateDate-time
RecordCurrencyIdString
PaymentMethodNameString
PurchaseOrderTypeString
ResponsibleUserIdString
SenderCountryCodeString
ShippingCarrierIdString
CommercialLanguageString
PackageTrackingUrlString
PurchaseOrderItemsString
RecordAddress_cityString
RecordCurrencyNameString
InvoiceAddress_cityString
PlannedDeliveryDateInteger
PlannedShippingDateInteger
PurchaseOrderNumberString
DeliveryAddress_cityString
DisableEmailTemplateBoolean
PackageTrackingNumberString
RecordAddress_companyString
RecordAddress_street1String
RecordAddress_zipcodeString
CurrencyConversionDateInteger
CurrencyConversionRateString
InvoiceAddress_companyString
InvoiceAddress_street1String
InvoiceAddress_zipcodeString
RecordAddress_lastNameString
ShippingCostItems_0_idString
StatusHistory_0_statusString
StatusHistory_0_userIdString
StatusHistory_1_statusString
StatusHistory_1_userIdString
StatusHistory_2_statusString
StatusHistory_2_userIdString
StatusHistory_3_statusString
StatusHistory_3_userIdString
DeliveryAddress_companyString
DeliveryAddress_street1String
DeliveryAddress_zipcodeString
PurchaseOrderItems_0_idString
PurchaseOrderItems_1_idString
PurchaseOrderItems_2_idString
PurchaseOrderItems_3_idString
RecordAddress_firstNameString
ResponsibleUserUsernameString
DeliveryAddress_company2String
DeliveryAddress_lastNameString
RecordAddress_salutationString
DeliveryAddress_firstNameString
RecordAddress_countryCodeString
ShippingCostItems_0_taxIdString
DeliveryAddress_salutationString
InvoiceAddress_countryCodeString
InvoiceAddress_phoneNumberString
NetAmountInCompanyCurrencyString
PurchaseOrderItems_0_taxIdString
PurchaseOrderItems_0_titleString
PurchaseOrderItems_1_taxIdString
PurchaseOrderItems_1_titleString
PurchaseOrderItems_2_taxIdString
PurchaseOrderItems_2_titleString
PurchaseOrderItems_3_taxIdString
PurchaseOrderItems_3_titleString
StatusHistory_0_statusDateInteger
StatusHistory_1_statusDateInteger
StatusHistory_2_statusDateInteger
StatusHistory_3_statusDateInteger
DeliveryAddress_countryCodeString
PurchaseOrderItems_0_unitIdString
PurchaseOrderItems_1_unitIdString
PurchaseOrderItems_2_unitIdString
PurchaseOrderItems_3_unitIdString
ShippingCostItems_0_taxNameString
ShippingCostItems_0_versionString
GrossAmountInCompanyCurrencyString
PurchaseOrderItems_0_taxNameString
PurchaseOrderItems_0_versionString
PurchaseOrderItems_1_taxNameString
PurchaseOrderItems_1_versionString
PurchaseOrderItems_2_taxNameString
PurchaseOrderItems_2_versionString
PurchaseOrderItems_3_taxNameString
PurchaseOrderItems_3_versionString
PurchaseOrderItems_0_quantityString
PurchaseOrderItems_0_unitNameString
PurchaseOrderItems_1_quantityString
PurchaseOrderItems_1_unitNameString
PurchaseOrderItems_2_quantityString
PurchaseOrderItems_2_unitNameString
PurchaseOrderItems_3_quantityString
PurchaseOrderItems_3_unitNameString
ShippingCostItems_0_articleIdString
ShippingCostItems_0_netAmountString
ShippingCostItems_0_unitPriceString
PurchaseOrderItems_0_articleIdString
PurchaseOrderItems_0_netAmountString
PurchaseOrderItems_0_unitPriceString
PurchaseOrderItems_1_articleIdString
PurchaseOrderItems_1_netAmountString
PurchaseOrderItems_1_unitPriceString
PurchaseOrderItems_2_articleIdString
PurchaseOrderItems_2_netAmountString
PurchaseOrderItems_2_unitPriceString
PurchaseOrderItems_3_articleIdString
PurchaseOrderItems_3_netAmountString
PurchaseOrderItems_3_unitPriceString
ShippingCostItems_0_createdDateInteger
ShippingCostItems_0_grossAmountString
PurchaseOrderItems_0_createdDateInteger
PurchaseOrderItems_0_descriptionString
PurchaseOrderItems_0_grossAmountString
PurchaseOrderItems_1_createdDateInteger
PurchaseOrderItems_1_descriptionString
PurchaseOrderItems_1_grossAmountString
PurchaseOrderItems_2_createdDateInteger
PurchaseOrderItems_2_descriptionString
PurchaseOrderItems_2_grossAmountString
PurchaseOrderItems_3_createdDateInteger
PurchaseOrderItems_3_descriptionString
PurchaseOrderItems_3_grossAmountString
RecordEmailAddresses_toAddressesString
PurchaseOrderItems_0_freeTextItemBoolean
PurchaseOrderItems_1_freeTextItemBoolean
PurchaseOrderItems_2_freeTextItemBoolean
PurchaseOrderItems_3_freeTextItemBoolean
ShippingCostItems_0_articleNumberString
PurchaseOrderItems_0_articleNumberString
PurchaseOrderItems_1_articleNumberString
PurchaseOrderItems_2_articleNumberString
PurchaseOrderItems_3_articleNumberString
PurchaseOrderItems_0_manualQuantityBoolean
PurchaseOrderItems_0_positionNumberInteger
PurchaseOrderItems_1_manualQuantityBoolean
PurchaseOrderItems_1_positionNumberInteger
PurchaseOrderItems_2_manualQuantityBoolean
PurchaseOrderItems_2_positionNumberInteger
PurchaseOrderItems_3_manualQuantityBoolean
PurchaseOrderItems_3_positionNumberInteger
ShippingCostItems_0_manualUnitPriceBoolean
PurchaseOrderItems_0_manualUnitPriceBoolean
PurchaseOrderItems_1_manualUnitPriceBoolean
PurchaseOrderItems_2_manualUnitPriceBoolean
PurchaseOrderItems_3_manualUnitPriceBoolean
ShippingCostItems_0_lastModifiedDateInteger
PurchaseOrderItems_0_descriptionFixedBoolean
PurchaseOrderItems_0_invoicedQuantityString
PurchaseOrderItems_0_lastModifiedDateInteger
PurchaseOrderItems_0_receivedQuantityString
PurchaseOrderItems_1_descriptionFixedBoolean
PurchaseOrderItems_1_invoicedQuantityString
PurchaseOrderItems_1_lastModifiedDateInteger
PurchaseOrderItems_1_receivedQuantityString
PurchaseOrderItems_2_descriptionFixedBoolean
PurchaseOrderItems_2_invoicedQuantityString
PurchaseOrderItems_2_lastModifiedDateInteger
PurchaseOrderItems_2_receivedQuantityString
PurchaseOrderItems_3_descriptionFixedBoolean
PurchaseOrderItems_3_invoicedQuantityString
PurchaseOrderItems_3_lastModifiedDateInteger
PurchaseOrderItems_3_receivedQuantityString
PurchaseOrderItems_0_supplierArticleIdString
PurchaseOrderItems_1_supplierArticleIdString
PurchaseOrderItems_2_supplierArticleIdString
PurchaseOrderItems_3_supplierArticleIdString
PurchaseOrderItems_0_addPageBreakBeforeBoolean
PurchaseOrderItems_0_discountPercentageString
PurchaseOrderItems_1_addPageBreakBeforeBoolean
PurchaseOrderItems_1_discountPercentageString
PurchaseOrderItems_2_addPageBreakBeforeBoolean
PurchaseOrderItems_2_discountPercentageString
PurchaseOrderItems_3_addPageBreakBeforeBoolean
PurchaseOrderItems_3_discountPercentageString
PurchaseOrderItems_0_netAmountForStatisticsString
PurchaseOrderItems_1_netAmountForStatisticsString
PurchaseOrderItems_2_netAmountForStatisticsString
PurchaseOrderItems_3_netAmountForStatisticsString
ShippingCostItems_0_netAmountInCompanyCurrencyString
ShippingCostItems_0_unitPriceInCompanyCurrencyString
PurchaseOrderItems_0_netAmountInCompanyCurrencyString
PurchaseOrderItems_0_unitPriceInCompanyCurrencyString
PurchaseOrderItems_1_netAmountInCompanyCurrencyString
PurchaseOrderItems_1_unitPriceInCompanyCurrencyString
PurchaseOrderItems_2_netAmountInCompanyCurrencyString
PurchaseOrderItems_2_unitPriceInCompanyCurrencyString
PurchaseOrderItems_3_netAmountInCompanyCurrencyString
PurchaseOrderItems_3_unitPriceInCompanyCurrencyString
ShippingCostItems_0_grossAmountInCompanyCurrencyString
PurchaseOrderItems_0_grossAmountInCompanyCurrencyString
PurchaseOrderItems_1_grossAmountInCompanyCurrencyString
PurchaseOrderItems_2_grossAmountInCompanyCurrencyString
PurchaseOrderItems_3_grossAmountInCompanyCurrencyString
PurchaseOrderItems_0_netAmountForStatisticsInCompanyCurrencyString
PurchaseOrderItems_1_netAmountForStatisticsInCompanyCurrencyString
PurchaseOrderItems_2_netAmountForStatisticsInCompanyCurrencyString
PurchaseOrderItems_3_netAmountForStatisticsInCompanyCurrencyString
Quotation
View 298 columns
IdString
StatusString
ValidToInteger
VersionString
TemplateBoolean
CreatorIdString
FactoringBoolean
NetAmountString
ValidFromInteger
CustomerIdString
CreatedDateDate-time
DescriptionString
GrossAmountString
PricingDateInteger
RequestDateInteger
WarehouseIdString
SalesChannelString
SalesStageIdString
ActiveVersionBoolean
QuotationDateInteger
QuotationTypeString
RecordCommentString
RecordOpeningString
WarehouseNameString
CustomerNumberString
HeaderDiscountString
QuotationItemsString
RecordFreeTextString
SalesStageNameString
HeaderSurchargeString
PaymentMethodIdString
QuotationNumberString
RejectionReasonString
SentToRecipientBoolean
TermOfPaymentIdString
CustomAttributesString
LastModifiedDateDate-time
QuotationVersionInteger
RecordCurrencyIdString
SalesProbabilityInteger
ShipmentMethodIdString
PaymentMethodNameString
ResponsibleUserIdString
TermOfPaymentNameString
CommercialLanguageString
InvoiceRecipientIdString
RecordAddress_cityString
RecordCurrencyNameString
ShipmentMethodNameString
Customfield_LeasingBoolean
DispatchCountryCodeString
InvoiceAddress_cityString
PlannedDeliveryDateInteger
QuotationItems_0_idString
QuotationItems_1_idString
QuotationItems_2_idString
QuotationItems_3_idString
RecordAddress_titleString
Customfield_ReferenzString
DeliveryAddress_cityString
DisableEmailTemplateBoolean
DeliveryAddress_titleString
RecordAddress_companyString
RecordAddress_street1String
RecordAddress_titleIdString
RecordAddress_zipcodeString
CurrencyConversionDateInteger
CurrencyConversionRateString
InvoiceAddress_companyString
InvoiceAddress_street1String
InvoiceAddress_zipcodeString
QuotationItems_0_taxIdString
QuotationItems_0_titleString
QuotationItems_1_taxIdString
QuotationItems_1_titleString
QuotationItems_2_taxIdString
QuotationItems_2_titleString
QuotationItems_3_taxIdString
QuotationItems_3_titleString
RecordAddress_company2String
RecordAddress_lastNameString
SalesStageHistory_0_idString
SalesStageHistory_1_idString
SalesStageHistory_2_idString
ShippingCostItems_0_idString
StatusHistory_0_statusString
StatusHistory_0_userIdString
StatusHistory_1_statusString
StatusHistory_1_userIdString
StatusHistory_2_statusString
StatusHistory_2_userIdString
StatusHistory_3_statusString
StatusHistory_3_userIdString
DeliveryAddress_companyString
DeliveryAddress_street1String
DeliveryAddress_titleIdString
DeliveryAddress_zipcodeString
InvoiceAddress_company2String
InvoiceAddress_lastNameString
QuotationItems_0_unitIdString
QuotationItems_1_unitIdString
QuotationItems_2_unitIdString
QuotationItems_3_unitIdString
RecordAddress_firstNameString
ResponsibleUserUsernameString
Customfield_TeststellungString
DefaultShippingCarrierIdString
DeliveryAddress_company2String
DeliveryAddress_lastNameString
InvoiceAddress_firstNameString
QuotationItems_0_taxNameString
QuotationItems_0_versionString
QuotationItems_1_taxNameString
QuotationItems_1_versionString
QuotationItems_2_taxNameString
QuotationItems_2_versionString
QuotationItems_3_taxNameString
QuotationItems_3_versionString
RecordAddress_salutationString
RecordCommentInheritanceBoolean
RecordOpeningInheritanceBoolean
DeliveryAddress_firstNameString
InvoiceAddress_salutationString
QuotationItems_0_itemTypeString
QuotationItems_0_optionalBoolean
QuotationItems_0_quantityString
QuotationItems_0_unitCostString
QuotationItems_0_unitNameString
QuotationItems_1_itemTypeString
QuotationItems_1_optionalBoolean
QuotationItems_1_quantityString
QuotationItems_1_unitCostString
QuotationItems_1_unitNameString
QuotationItems_2_itemTypeString
QuotationItems_2_optionalBoolean
QuotationItems_2_quantityString
QuotationItems_2_unitCostString
QuotationItems_2_unitNameString
QuotationItems_3_itemTypeString
QuotationItems_3_optionalBoolean
QuotationItems_3_quantityString
QuotationItems_3_unitNameString
RecordAddress_countryCodeString
RecordFreeTextInheritanceBoolean
ShippingCostItems_0_taxIdString
DefaultShippingCarrierNameString
DeliveryAddress_salutationString
InvoiceAddress_countryCodeString
NetAmountInCompanyCurrencyString
QuotationItems_0_articleIdString
QuotationItems_0_netAmountString
QuotationItems_0_unitPriceString
QuotationItems_1_articleIdString
QuotationItems_1_netAmountString
QuotationItems_1_unitPriceString
QuotationItems_2_articleIdString
QuotationItems_2_netAmountString
QuotationItems_2_unitPriceString
QuotationItems_3_articleIdString
QuotationItems_3_netAmountString
QuotationItems_3_unitPriceString
SalesStageHistory_0_userIdString
SalesStageHistory_1_userIdString
SalesStageHistory_2_userIdString
StatusHistory_0_statusDateInteger
StatusHistory_1_statusDateInteger
StatusHistory_2_statusDateInteger
StatusHistory_3_statusDateInteger
DeliveryAddress_countryCodeString
SalesStageHistory_0_versionString
SalesStageHistory_1_versionString
SalesStageHistory_2_versionString
ShippingCostItems_0_taxNameString
ShippingCostItems_0_versionString
GrossAmountInCompanyCurrencyString
QuotationItems_0_alternativeBoolean
QuotationItems_0_createdDateInteger
QuotationItems_0_descriptionString
QuotationItems_0_grossAmountString
QuotationItems_1_alternativeBoolean
QuotationItems_1_createdDateInteger
QuotationItems_1_descriptionString
QuotationItems_1_grossAmountString
QuotationItems_2_alternativeBoolean
QuotationItems_2_createdDateInteger
QuotationItems_2_descriptionString
QuotationItems_2_grossAmountString
QuotationItems_3_alternativeBoolean
QuotationItems_3_createdDateInteger
QuotationItems_3_descriptionString
QuotationItems_3_grossAmountString
Customfield_RabattbezeichnungString
QuotationItems_0_freeTextItemBoolean
QuotationItems_0_parentItemIdString
QuotationItems_1_freeTextItemBoolean
QuotationItems_1_parentItemIdString
QuotationItems_2_freeTextItemBoolean
QuotationItems_2_parentItemIdString
QuotationItems_3_freeTextItemBoolean
QuotationItems_3_parentItemIdString
ShippingCostItems_0_articleIdString
ShippingCostItems_0_netAmountString
ShippingCostItems_0_unitPriceString
QuotationItems_0_articleNumberString
QuotationItems_0_invoicingTypeString
QuotationItems_1_articleNumberString
QuotationItems_2_articleNumberString
QuotationItems_3_articleNumberString
Customfield_pipedrive_bcc_emailString
QuotationItems_0_manualQuantityBoolean
QuotationItems_0_manualUnitCostBoolean
QuotationItems_0_positionNumberInteger
QuotationItems_1_manualQuantityBoolean
QuotationItems_1_manualUnitCostBoolean
QuotationItems_1_positionNumberInteger
QuotationItems_2_manualQuantityBoolean
QuotationItems_2_manualUnitCostBoolean
QuotationItems_2_positionNumberInteger
QuotationItems_3_manualQuantityBoolean
QuotationItems_3_manualUnitCostBoolean
QuotationItems_3_positionNumberInteger
SalesStageHistory_0_createdDateInteger
SalesStageHistory_1_createdDateInteger
SalesStageHistory_2_createdDateInteger
ShippingCostItems_0_createdDateInteger
ShippingCostItems_0_grossAmountString
QuotationItems_0_manualUnitPriceBoolean
QuotationItems_1_manualUnitPriceBoolean
QuotationItems_2_manualUnitPriceBoolean
QuotationItems_3_manualUnitPriceBoolean
RecordEmailAddresses_toAddressesString
SalesStageHistory_0_salesStageIdString
SalesStageHistory_1_salesStageIdString
SalesStageHistory_2_salesStageIdString
QuotationItems_0_descriptionFixedBoolean
QuotationItems_0_lastModifiedDateInteger
QuotationItems_1_descriptionFixedBoolean
QuotationItems_1_lastModifiedDateInteger
QuotationItems_2_descriptionFixedBoolean
QuotationItems_2_lastModifiedDateInteger
QuotationItems_3_descriptionFixedBoolean
QuotationItems_3_lastModifiedDateInteger
RecordEmailAddresses_bccAddressesString
ShippingCostItems_0_articleNumberString
DeliveryEmailAddresses_toAddressesString
SalesStageHistory_0_salesStageNameString
SalesStageHistory_1_salesStageNameString
SalesStageHistory_2_salesStageNameString
ShippingCostItems_0_manualUnitCostBoolean
DeliveryEmailAddresses_bccAddressesString
QuotationItems_0_addPageBreakBeforeBoolean
QuotationItems_0_discountPercentageString
QuotationItems_1_addPageBreakBeforeBoolean
QuotationItems_1_discountPercentageString
QuotationItems_2_addPageBreakBeforeBoolean
QuotationItems_2_discountPercentageString
QuotationItems_3_addPageBreakBeforeBoolean
QuotationItems_3_discountPercentageString
ShippingCostItems_0_manualUnitPriceBoolean
SalesOrderEmailAddresses_toAddressesString
SalesStageHistory_0_lastModifiedDateInteger
SalesStageHistory_1_lastModifiedDateInteger
SalesStageHistory_2_lastModifiedDateInteger
ShippingCostItems_0_lastModifiedDateInteger
SalesOrderEmailAddresses_bccAddressesString
SalesInvoiceEmailAddresses_toAddressesString
QuotationItems_0_netAmountForStatisticsString
QuotationItems_1_netAmountForStatisticsString
QuotationItems_2_netAmountForStatisticsString
QuotationItems_3_netAmountForStatisticsString
SalesInvoiceEmailAddresses_bccAddressesString
QuotationItems_0_plannedWorkingTimePerUnitInteger
QuotationItems_0_unitCostInCompanyCurrencyString
QuotationItems_1_unitCostInCompanyCurrencyString
QuotationItems_2_unitCostInCompanyCurrencyString
QuotationItems_0_netAmountInCompanyCurrencyString
QuotationItems_0_unitPriceInCompanyCurrencyString
QuotationItems_1_netAmountInCompanyCurrencyString
QuotationItems_1_unitPriceInCompanyCurrencyString
QuotationItems_2_netAmountInCompanyCurrencyString
QuotationItems_2_unitPriceInCompanyCurrencyString
QuotationItems_3_netAmountInCompanyCurrencyString
QuotationItems_3_unitPriceInCompanyCurrencyString
QuotationItems_0_grossAmountInCompanyCurrencyString
QuotationItems_1_grossAmountInCompanyCurrencyString
QuotationItems_2_grossAmountInCompanyCurrencyString
QuotationItems_3_grossAmountInCompanyCurrencyString
ShippingCostItems_0_netAmountInCompanyCurrencyString
ShippingCostItems_0_unitPriceInCompanyCurrencyString
QuotationItems_0_manualPlannedWorkingTimePerUnitBoolean
QuotationItems_1_manualPlannedWorkingTimePerUnitBoolean
QuotationItems_2_manualPlannedWorkingTimePerUnitBoolean
QuotationItems_3_manualPlannedWorkingTimePerUnitBoolean
ShippingCostItems_0_grossAmountInCompanyCurrencyString
QuotationItems_0_netAmountForStatisticsInCompanyCurrencyString
QuotationItems_1_netAmountForStatisticsInCompanyCurrencyString
QuotationItems_2_netAmountForStatisticsInCompanyCurrencyString
QuotationItems_3_netAmountForStatisticsInCompanyCurrencyString
Sales Invoice
View 277 columns
IdString
PaidBoolean
StatusString
DueDateInteger
VersionString
CreatorIdString
FactoringBoolean
NetAmountString
CustomerIdString
BookingTextString
CreatedDateDate-time
DescriptionString
GrossAmountString
InvoiceDateInteger
PricingDateInteger
DeliveryDateInteger
SalesChannelString
SalesOrderIdString
ShippingDateInteger
InvoiceNumberString
PaymentStatusString
RecordCommentString
CustomerNumberString
HeaderDiscountString
RecordFreeTextString
CommissionBlockBoolean
HeaderSurchargeString
PaymentMethodIdString
SentToRecipientBoolean
TermOfPaymentIdString
CancellationDateInteger
LastModifiedDateDate-time
RecordCurrencyIdString
SalesInvoiceTypeString
SalesOrderNumberString
SalesOrders_0_idString
ShipmentMethodIdString
DunningBlockStateString
PaymentMethodNameString
ResponsibleUserIdString
SalesInvoiceItemsString
TermOfPaymentNameString
CancellationNumberString
CommercialLanguageString
RecordAddress_cityString
RecordCurrencyNameString
ShipmentMethodNameString
DispatchCountryCodeString
RecordAddress_titleString
Customfield_ReferenzString
DeliveryAddress_cityString
DisableEmailTemplateBoolean
DeliveryAddress_titleString
OrderNumberAtCustomerString
RecordAddress_companyString
RecordAddress_street1String
RecordAddress_titleIdString
RecordAddress_zipcodeString
VatRegistrationNumberString
CreditResetsOrderStateBoolean
CurrencyConversionDateInteger
CurrencyConversionRateString
DirectDebitFileCreatedBoolean
RecordAddress_company2String
RecordAddress_lastNameString
SalesInvoiceItems_0_idString
SalesInvoiceItems_1_idString
SalesInvoiceItems_2_idString
SalesInvoiceItems_3_idString
ShippingCostItems_0_idString
StatusHistory_0_statusString
StatusHistory_0_userIdString
StatusHistory_1_statusString
StatusHistory_1_userIdString
StatusHistory_2_statusString
StatusHistory_2_userIdString
StatusHistory_3_statusString
StatusHistory_3_userIdString
DeliveryAddress_companyString
DeliveryAddress_street1String
DeliveryAddress_titleIdString
DeliveryAddress_zipcodeString
PrecedingSalesInvoiceIdString
RecordAddress_firstNameString
ResponsibleUserUsernameString
CommissionSettlementDoneBoolean
DeliveryAddress_company2String
DeliveryAddress_lastNameString
RecordAddress_salutationString
RecordCommentInheritanceBoolean
RecordOpeningInheritanceBoolean
DeliveryAddress_firstNameString
RecordAddress_countryCodeString
RecordFreeTextInheritanceBoolean
SalesInvoiceItems_0_taxIdString
SalesInvoiceItems_0_titleString
SalesInvoiceItems_1_taxIdString
SalesInvoiceItems_1_titleString
SalesInvoiceItems_2_taxIdString
SalesInvoiceItems_2_titleString
SalesInvoiceItems_3_taxIdString
SalesInvoiceItems_3_titleString
ShippingCostItems_0_taxIdString
DeliveryAddress_salutationString
NetAmountInCompanyCurrencyString
SalesInvoiceItems_0_unitIdString
SalesInvoiceItems_1_unitIdString
SalesInvoiceItems_2_unitIdString
SalesInvoiceItems_3_unitIdString
StatusHistory_0_statusDateInteger
StatusHistory_1_statusDateInteger
StatusHistory_2_statusDateInteger
StatusHistory_3_statusDateInteger
DeliveryAddress_countryCodeString
SalesInvoiceItems_0_taxNameString
SalesInvoiceItems_0_versionString
SalesInvoiceItems_1_taxNameString
SalesInvoiceItems_1_versionString
SalesInvoiceItems_2_taxNameString
SalesInvoiceItems_2_versionString
SalesInvoiceItems_3_taxNameString
SalesInvoiceItems_3_versionString
ShippingCostItems_0_taxNameString
ShippingCostItems_0_versionString
GrossAmountInCompanyCurrencyString
SalesInvoiceItems_0_quantityString
SalesInvoiceItems_0_unitCostString
SalesInvoiceItems_0_unitNameString
SalesInvoiceItems_1_quantityString
SalesInvoiceItems_1_unitCostString
SalesInvoiceItems_1_unitNameString
SalesInvoiceItems_2_quantityString
SalesInvoiceItems_2_unitCostString
SalesInvoiceItems_2_unitNameString
SalesInvoiceItems_3_quantityString
SalesInvoiceItems_3_unitNameString
Customfield_RabattbezeichnungString
SalesInvoiceItems_0_accountIdString
SalesInvoiceItems_0_articleIdString
SalesInvoiceItems_0_netAmountString
SalesInvoiceItems_0_unitPriceString
SalesInvoiceItems_1_accountIdString
SalesInvoiceItems_1_articleIdString
SalesInvoiceItems_1_netAmountString
SalesInvoiceItems_1_unitPriceString
SalesInvoiceItems_2_accountIdString
SalesInvoiceItems_2_articleIdString
SalesInvoiceItems_2_netAmountString
SalesInvoiceItems_2_unitPriceString
SalesInvoiceItems_3_accountIdString
SalesInvoiceItems_3_articleIdString
SalesInvoiceItems_3_netAmountString
SalesInvoiceItems_3_unitPriceString
ShippingCostItems_0_articleIdString
ShippingCostItems_0_netAmountString
ShippingCostItems_0_unitPriceString
CustomAttributes_0_stringValueString
CustomAttributes_1_stringValueString
CancellationSlipCommissionBlockBoolean
SalesInvoiceItems_0_createdDateInteger
SalesInvoiceItems_0_descriptionString
SalesInvoiceItems_0_grossAmountString
SalesInvoiceItems_1_createdDateInteger
SalesInvoiceItems_1_descriptionString
SalesInvoiceItems_1_grossAmountString
SalesInvoiceItems_2_createdDateInteger
SalesInvoiceItems_2_descriptionString
SalesInvoiceItems_2_grossAmountString
SalesInvoiceItems_3_createdDateInteger
SalesInvoiceItems_3_grossAmountString
ShippingCostItems_0_createdDateInteger
ShippingCostItems_0_grossAmountString
RecordEmailAddresses_ccAddressesString
RecordEmailAddresses_toAddressesString
SalesInvoiceItems_0_freeTextItemBoolean
SalesInvoiceItems_0_shippingDateInteger
SalesInvoiceItems_1_freeTextItemBoolean
SalesInvoiceItems_1_parentItemIdString
SalesInvoiceItems_1_shippingDateInteger
SalesInvoiceItems_2_freeTextItemBoolean
SalesInvoiceItems_2_parentItemIdString
SalesInvoiceItems_2_shippingDateInteger
SalesInvoiceItems_3_freeTextItemBoolean
SalesInvoiceItems_3_parentItemIdString
SalesInvoiceItems_3_shippingDateInteger
RecordEmailAddresses_bccAddressesString
SalesInvoiceItems_0_accountNumberString
SalesInvoiceItems_0_articleNumberString
SalesInvoiceItems_1_accountNumberString
SalesInvoiceItems_1_articleNumberString
SalesInvoiceItems_2_accountNumberString
SalesInvoiceItems_2_articleNumberString
SalesInvoiceItems_3_accountNumberString
SalesInvoiceItems_3_articleNumberString
ShippingCostItems_0_articleNumberString
SalesInvoiceItems_0_manualQuantityBoolean
SalesInvoiceItems_0_manualUnitCostBoolean
SalesInvoiceItems_0_positionNumberInteger
SalesInvoiceItems_1_manualQuantityBoolean
SalesInvoiceItems_1_manualUnitCostBoolean
SalesInvoiceItems_1_positionNumberInteger
SalesInvoiceItems_2_manualQuantityBoolean
SalesInvoiceItems_2_manualUnitCostBoolean
SalesInvoiceItems_2_positionNumberInteger
SalesInvoiceItems_3_manualQuantityBoolean
SalesInvoiceItems_3_manualUnitCostBoolean
SalesInvoiceItems_3_positionNumberInteger
ShippingCostItems_0_manualUnitCostBoolean
SalesInvoiceItems_0_manualUnitPriceBoolean
SalesInvoiceItems_1_manualUnitPriceBoolean
SalesInvoiceItems_2_manualUnitPriceBoolean
SalesInvoiceItems_2_serialNumbers_0String
SalesInvoiceItems_3_manualUnitPriceBoolean
ShippingCostItems_0_manualUnitPriceBoolean
SalesInvoiceItems_0_descriptionFixedBoolean
SalesInvoiceItems_0_lastModifiedDateInteger
SalesInvoiceItems_1_descriptionFixedBoolean
SalesInvoiceItems_1_lastModifiedDateInteger
SalesInvoiceItems_2_descriptionFixedBoolean
SalesInvoiceItems_2_lastModifiedDateInteger
SalesInvoiceItems_3_descriptionFixedBoolean
SalesInvoiceItems_3_lastModifiedDateInteger
ShippingCostItems_0_lastModifiedDateInteger
SalesInvoiceItems_0_addPageBreakBeforeBoolean
SalesInvoiceItems_0_discountPercentageString
SalesInvoiceItems_1_addPageBreakBeforeBoolean
SalesInvoiceItems_1_discountPercentageString
SalesInvoiceItems_2_addPageBreakBeforeBoolean
SalesInvoiceItems_2_discountPercentageString
SalesInvoiceItems_3_addPageBreakBeforeBoolean
SalesInvoiceItems_3_discountPercentageString
CancellationSlipCommissionSettlementDoneBoolean
CustomAttributes_0_attributeDefinitionIdString
CustomAttributes_1_attributeDefinitionIdString
SalesInvoiceItems_0_creditedInvoiceItemIdString
SalesInvoiceItems_0_netAmountForStatisticsString
SalesInvoiceItems_1_netAmountForStatisticsString
SalesInvoiceItems_2_netAmountForStatisticsString
SalesInvoiceItems_3_netAmountForStatisticsString
SalesInvoiceItems_0_unitCostInCompanyCurrencyString
SalesInvoiceItems_1_unitCostInCompanyCurrencyString
SalesInvoiceItems_2_unitCostInCompanyCurrencyString
SalesInvoiceItems_0_netAmountInCompanyCurrencyString
SalesInvoiceItems_0_unitPriceInCompanyCurrencyString
SalesInvoiceItems_1_netAmountInCompanyCurrencyString
SalesInvoiceItems_1_unitPriceInCompanyCurrencyString
SalesInvoiceItems_2_netAmountInCompanyCurrencyString
SalesInvoiceItems_2_unitPriceInCompanyCurrencyString
SalesInvoiceItems_3_netAmountInCompanyCurrencyString
SalesInvoiceItems_3_unitPriceInCompanyCurrencyString
ShippingCostItems_0_netAmountInCompanyCurrencyString
ShippingCostItems_0_unitPriceInCompanyCurrencyString
SalesInvoiceItems_0_grossAmountInCompanyCurrencyString
SalesInvoiceItems_1_grossAmountInCompanyCurrencyString
SalesInvoiceItems_2_grossAmountInCompanyCurrencyString
SalesInvoiceItems_3_grossAmountInCompanyCurrencyString
ShippingCostItems_0_grossAmountInCompanyCurrencyString
SalesInvoiceItems_0_netAmountForStatisticsInCompanyCurrencyString
SalesInvoiceItems_0_salesInvoiceItemRelationship_0_quantityString
SalesInvoiceItems_1_netAmountForStatisticsInCompanyCurrencyString
SalesInvoiceItems_1_salesInvoiceItemRelationship_0_quantityString
SalesInvoiceItems_2_netAmountForStatisticsInCompanyCurrencyString
SalesInvoiceItems_2_salesInvoiceItemRelationship_0_quantityString
SalesInvoiceItems_3_netAmountForStatisticsInCompanyCurrencyString
SalesInvoiceItems_3_salesInvoiceItemRelationship_0_quantityString
SalesInvoiceItems_0_salesInvoiceItemRelationship_0_shipmentItemIdString
SalesInvoiceItems_1_salesInvoiceItemRelationship_0_shipmentItemIdString
SalesInvoiceItems_2_salesInvoiceItemRelationship_0_shipmentItemIdString
SalesInvoiceItems_3_salesInvoiceItemRelationship_0_shipmentItemIdString
SalesInvoiceItems_0_salesInvoiceItemRelationship_0_salesOrderItemIdString
SalesInvoiceItems_1_salesInvoiceItemRelationship_0_salesOrderItemIdString
SalesInvoiceItems_2_salesInvoiceItemRelationship_0_salesOrderItemIdString
SalesInvoiceItems_3_salesInvoiceItemRelationship_0_salesOrderItemIdString
SalesInvoiceItems_0_salesInvoiceItemRelationship_0_salesInvoiceItemIdString
SalesInvoiceItems_1_salesInvoiceItemRelationship_0_salesInvoiceItemIdString
SalesInvoiceItems_2_salesInvoiceItemRelationship_0_salesInvoiceItemIdString
SalesInvoiceItems_3_salesInvoiceItemRelationship_0_salesInvoiceItemIdString
Sales Order
View 328 columns
IdString
NoteString
PaidBoolean
StatusString
ShippedBoolean
VersionString
InvoicedBoolean
TemplateBoolean
CreatorIdString
FactoringBoolean
NetAmountString
OrderDateInteger
CustomerIdString
OrderItemsString
CreatedDateDate-time
DescriptionString
GrossAmountString
OrderNumberString
PricingDateInteger
QuotationIdString
WarehouseIdString
AvailabilityString
OnlyServicesBoolean
SalesChannelString
Payments_0_idString
Payments_1_idString
RecordCommentString
RecordOpeningString
StatusHistoryString
WarehouseNameString
CustomerNumberString
HeaderDiscountString
RecordFreeTextString
HeaderSurchargeString
OrderItems_0_idString
OrderItems_1_idString
OrderItems_2_idString
OrderItems_3_idString
PaymentMethodIdString
QuotationNumberString
SentToRecipientBoolean
TermOfPaymentIdString
CustomAttributesString
LastModifiedDateDate-time
RecordCurrencyIdString
ServicesFinishedBoolean
ShipmentMethodIdString
Customfield_BezugString
PaymentMethodNameString
Payments_0_amountString
Payments_1_amountString
ProjectModeActiveBoolean
ResponsibleUserIdString
TermOfPaymentNameString
CommercialLanguageString
InvoiceRecipientIdString
OrderItems_0_taxIdString
OrderItems_0_titleString
OrderItems_1_taxIdString
OrderItems_1_titleString
OrderItems_2_taxIdString
OrderItems_2_titleString
OrderItems_3_taxIdString
OrderItems_3_titleString
Payments_0_dueDateInteger
Payments_0_versionString
Payments_1_dueDateInteger
Payments_1_versionString
RecordAddress_cityString
RecordCurrencyNameString
ShipmentMethodNameString
Customfield_LeasingBoolean
DispatchCountryCodeString
InvoiceAddress_cityString
OrderItems_0_unitIdString
OrderItems_1_unitIdString
OrderItems_2_unitIdString
OrderItems_3_unitIdString
PlannedDeliveryDateInteger
PlannedShippingDateInteger
RecordAddress_titleString
ShippingLabelsCountInteger
AdvancePaymentStatusString
Customfield_ReferenzString
DeliveryAddress_cityString
DisableEmailTemplateBoolean
InvoiceAddress_titleString
OrderItems_0_shippedBoolean
OrderItems_0_taxNameString
OrderItems_0_versionString
OrderItems_1_shippedBoolean
OrderItems_1_taxNameString
OrderItems_1_versionString
OrderItems_2_shippedBoolean
OrderItems_2_taxNameString
OrderItems_2_versionString
OrderItems_3_shippedBoolean
OrderItems_3_taxNameString
OrderItems_3_versionString
Payments_0_conditionString
Payments_1_conditionString
DeliveryAddress_titleString
FulfillmentProviderIdString
OrderItems_0_itemTypeString
OrderItems_0_quantityString
OrderItems_0_unitCostString
OrderItems_0_unitNameString
OrderItems_1_itemTypeString
OrderItems_1_quantityString
OrderItems_1_unitCostString
OrderItems_1_unitNameString
OrderItems_2_itemTypeString
OrderItems_2_quantityString
OrderItems_2_unitCostString
OrderItems_2_unitNameString
OrderItems_3_itemTypeString
OrderItems_3_quantityString
OrderItems_3_unitNameString
OrderNumberAtCustomerString
RecordAddress_companyString
RecordAddress_street1String
RecordAddress_titleIdString
RecordAddress_zipcodeString
SalesOrderPaymentTypeString
CurrencyConversionDateInteger
CurrencyConversionRateString
InvoiceAddress_companyString
InvoiceAddress_street1String
InvoiceAddress_titleIdString
InvoiceAddress_zipcodeString
OrderItems_0_articleIdString
OrderItems_0_netAmountString
OrderItems_0_unitPriceString
OrderItems_1_articleIdString
OrderItems_1_netAmountString
OrderItems_1_unitPriceString
OrderItems_2_articleIdString
OrderItems_2_netAmountString
OrderItems_2_unitPriceString
OrderItems_3_articleIdString
OrderItems_3_netAmountString
OrderItems_3_unitPriceString
Payments_0_createdDateInteger
Payments_1_createdDateInteger
RecordAddress_company2String
RecordAddress_lastNameString
ShippingCostItems_0_idString
StatusHistory_0_statusString
StatusHistory_0_userIdString
StatusHistory_1_statusString
StatusHistory_1_userIdString
StatusHistory_2_statusString
StatusHistory_2_userIdString
StatusHistory_3_statusString
StatusHistory_3_userIdString
DeliveryAddress_companyString
DeliveryAddress_street1String
DeliveryAddress_titleIdString
DeliveryAddress_zipcodeString
InvoiceAddress_company2String
InvoiceAddress_lastNameString
OrderItems_0_tasks_0_idString
Payments_0_conditionMetBoolean
Payments_1_conditionMetBoolean
RecordAddress_firstNameString
ResponsibleUserUsernameString
Customfield_TeststellungString
DefaultShippingCarrierIdString
DeliveryAddress_company2String
DeliveryAddress_lastNameString
InvoiceAddress_firstNameString
OrderItems_0_createdDateInteger
OrderItems_0_descriptionString
OrderItems_0_grossAmountString
OrderItems_1_createdDateInteger
OrderItems_1_descriptionString
OrderItems_1_grossAmountString
OrderItems_2_createdDateInteger
OrderItems_2_descriptionString
OrderItems_2_grossAmountString
OrderItems_3_createdDateInteger
OrderItems_3_grossAmountString
RecordAddress_salutationString
RecordCommentInheritanceBoolean
RecordOpeningInheritanceBoolean
DeliveryAddress_firstNameString
InvoiceAddress_salutationString
OrderItems_0_availabilityString
OrderItems_0_freeTextItemBoolean
OrderItems_1_availabilityString
OrderItems_1_freeTextItemBoolean
OrderItems_1_parentItemIdString
OrderItems_2_availabilityString
OrderItems_2_freeTextItemBoolean
OrderItems_2_parentItemIdString
OrderItems_3_availabilityString
OrderItems_3_freeTextItemBoolean
OrderItems_3_parentItemIdString
Payments_0_positionNumberInteger
Payments_0_salesInvoiceIdString
Payments_1_positionNumberInteger
Payments_1_salesInvoiceIdString
RecordAddress_countryCodeString
RecordFreeTextInheritanceBoolean
ShippingCostItems_0_taxIdString
ApplyShippingCostsOnlyOnceBoolean
DefaultShippingCarrierNameString
DeliveryAddress_salutationString
InvoiceAddress_countryCodeString
NetAmountInCompanyCurrencyString
OrderItems_0_articleNumberString
OrderItems_0_invoicingTypeString
OrderItems_1_articleNumberString
OrderItems_2_articleNumberString
OrderItems_3_articleNumberString
StatusHistory_0_statusDateInteger
StatusHistory_1_statusDateInteger
StatusHistory_2_statusDateInteger
StatusHistory_3_statusDateInteger
DeliveryAddress_countryCodeString
OrderItems_0_manualQuantityBoolean
OrderItems_0_manualUnitCostBoolean
OrderItems_0_positionNumberInteger
OrderItems_1_manualQuantityBoolean
OrderItems_1_manualUnitCostBoolean
OrderItems_1_positionNumberInteger
OrderItems_2_manualQuantityBoolean
OrderItems_2_manualUnitCostBoolean
OrderItems_2_positionNumberInteger
OrderItems_3_manualQuantityBoolean
OrderItems_3_manualUnitCostBoolean
OrderItems_3_positionNumberInteger
Payments_0_lastModifiedDateInteger
Payments_1_lastModifiedDateInteger
ShippingCostItems_0_taxNameString
ShippingCostItems_0_versionString
AvailabilityForAllWarehousesString
GrossAmountInCompanyCurrencyString
OrderItems_0_manualUnitPriceBoolean
OrderItems_0_shippedQuantityString
OrderItems_1_manualUnitPriceBoolean
OrderItems_1_shippedQuantityString
OrderItems_2_manualUnitPriceBoolean
OrderItems_2_shippedQuantityString
OrderItems_3_manualUnitPriceBoolean
OrderItems_3_shippedQuantityString
Customfield_RabattbezeichnungString
OrderItems_0_descriptionFixedBoolean
OrderItems_0_invoicedQuantityString
OrderItems_0_lastModifiedDateInteger
OrderItems_1_descriptionFixedBoolean
OrderItems_1_invoicedQuantityString
OrderItems_1_lastModifiedDateInteger
OrderItems_2_descriptionFixedBoolean
OrderItems_2_invoicedQuantityString
OrderItems_2_lastModifiedDateInteger
OrderItems_3_descriptionFixedBoolean
OrderItems_3_invoicedQuantityString
OrderItems_3_lastModifiedDateInteger
Payments_0_salesInvoices_0_idString
Payments_0_salesInvoices_1_idString
Payments_1_salesInvoices_0_idString
Payments_1_salesInvoices_1_idString
ShippingCostItems_0_articleIdString
ShippingCostItems_0_netAmountString
ShippingCostItems_0_unitPriceString
OrderItems_0_addPageBreakBeforeBoolean
OrderItems_0_discountPercentageString
OrderItems_1_addPageBreakBeforeBoolean
OrderItems_1_discountPercentageString
OrderItems_2_addPageBreakBeforeBoolean
OrderItems_2_discountPercentageString
OrderItems_3_addPageBreakBeforeBoolean
OrderItems_3_discountPercentageString
ShippingCostItems_0_createdDateInteger
ShippingCostItems_0_grossAmountString
RecordEmailAddresses_ccAddressesString
RecordEmailAddresses_toAddressesString
RecordEmailAddresses_bccAddressesString
ShippingCostItems_0_articleNumberString
DeliveryEmailAddresses_ccAddressesString
DeliveryEmailAddresses_toAddressesString
ShippingCostItems_0_manualUnitCostBoolean
DeliveryEmailAddresses_bccAddressesString
OrderItems_0_netAmountForStatisticsString
OrderItems_1_netAmountForStatisticsString
OrderItems_2_netAmountForStatisticsString
OrderItems_3_netAmountForStatisticsString
ShippingCostItems_0_manualUnitPriceBoolean
StatusHistory_0_creditLimitExceededBoolean
StatusHistory_1_creditLimitExceededBoolean
StatusHistory_2_creditLimitExceededBoolean
StatusHistory_3_creditLimitExceededBoolean
ShippingCostItems_0_lastModifiedDateInteger
OrderItems_0_plannedWorkingTimePerUnitInteger
OrderItems_0_unitCostInCompanyCurrencyString
OrderItems_1_unitCostInCompanyCurrencyString
OrderItems_2_unitCostInCompanyCurrencyString
SalesInvoiceEmailAddresses_ccAddressesString
SalesInvoiceEmailAddresses_toAddressesString
OrderItems_0_netAmountInCompanyCurrencyString
OrderItems_0_unitPriceInCompanyCurrencyString
OrderItems_1_netAmountInCompanyCurrencyString
OrderItems_1_unitPriceInCompanyCurrencyString
OrderItems_2_netAmountInCompanyCurrencyString
OrderItems_2_unitPriceInCompanyCurrencyString
OrderItems_3_netAmountInCompanyCurrencyString
OrderItems_3_unitPriceInCompanyCurrencyString
SalesInvoiceEmailAddresses_bccAddressesString
OrderItems_0_availabilityForAllWarehousesString
OrderItems_0_grossAmountInCompanyCurrencyString
OrderItems_1_availabilityForAllWarehousesString
OrderItems_1_grossAmountInCompanyCurrencyString
OrderItems_2_availabilityForAllWarehousesString
OrderItems_2_grossAmountInCompanyCurrencyString
OrderItems_3_availabilityForAllWarehousesString
OrderItems_3_grossAmountInCompanyCurrencyString
OrderItems_0_manualPlannedWorkingTimePerUnitBoolean
OrderItems_1_manualPlannedWorkingTimePerUnitBoolean
OrderItems_2_manualPlannedWorkingTimePerUnitBoolean
OrderItems_3_manualPlannedWorkingTimePerUnitBoolean
ShippingCostItems_0_netAmountInCompanyCurrencyString
ShippingCostItems_0_unitPriceInCompanyCurrencyString
ShippingCostItems_0_grossAmountInCompanyCurrencyString
OrderItems_0_netAmountForStatisticsInCompanyCurrencyString
OrderItems_1_netAmountForStatisticsInCompanyCurrencyString
OrderItems_2_netAmountForStatisticsInCompanyCurrencyString
OrderItems_3_netAmountForStatisticsInCompanyCurrencyString
Shipment
View 210 columns
IdString
StatusString
VersionString
CreatorIdString
CreatedDateDate-time
DescriptionString
WarehouseIdString
AvailabilityString
DeliveryDateInteger
PackageWidthInteger
SalesOrderIdString
ShipmentTypeString
ShippingDateInteger
PackageHeightInteger
PackageLengthInteger
PackageWeightString
PicksCompleteBoolean
RecordCommentString
ShipmentItemsString
StatusHistoryString
WarehouseNameString
RecordFreeTextString
ShipmentNumberString
SentToRecipientBoolean
LastModifiedDateDate-time
RecipientPartyIdString
SalesOrderNumberString
SalesOrders_0_idString
ShipmentMethodIdString
Customfield_BezugString
ShippingCarrierIdString
CommercialLanguageString
InvoiceRecipientIdString
PackageTrackingUrlString
ShipmentItems_0_idString
ShipmentItems_1_idString
ShipmentItems_2_idString
ShipmentItems_3_idString
ShipmentMethodNameString
DeclaredValueAmountString
InvoiceAddress_cityString
PickingInstructionsString
ShippingCarrierNameString
ShippingLabelsCountInteger
DisableEmailTemplateBoolean
InvoiceAddress_titleString
PackageTrackingNumberString
RecipientAddress_cityString
ShipmentItems_0_titleString
ShipmentItems_1_titleString
ShipmentItems_2_titleString
ShipmentItems_3_titleString
DestinationWarehouseIdString
InvoiceAddress_companyString
InvoiceAddress_street1String
InvoiceAddress_titleIdString
InvoiceAddress_zipcodeString
PackageReferenceNumberString
RecipientAddress_titleString
ShipmentItems_0_unitIdString
ShipmentItems_1_unitIdString
ShipmentItems_2_unitIdString
ShipmentItems_3_unitIdString
StatusHistory_0_statusString
StatusHistory_0_userIdString
StatusHistory_1_statusString
StatusHistory_1_userIdString
StatusHistory_2_statusString
StatusHistory_2_userIdString
InvoiceAddress_company2String
InvoiceAddress_lastNameString
RecipientCustomerNumberString
RecipientSupplierNumberString
ShipmentItems_0_versionString
ShipmentItems_1_versionString
ShipmentItems_2_versionString
ShipmentItems_3_versionString
ShippedFromAddress_cityString
DestinationWarehouseNameString
InvoiceAddress_firstNameString
RecipientAddress_companyString
RecipientAddress_street1String
RecipientAddress_titleIdString
RecipientAddress_zipcodeString
ShipmentItems_0_quantityString
ShipmentItems_0_unitNameString
ShipmentItems_1_quantityString
ShipmentItems_1_unitNameString
ShipmentItems_2_quantityString
ShipmentItems_2_unitNameString
ShipmentItems_3_quantityString
ShipmentItems_3_unitNameString
DestinationStoragePlaceIdString
InvoiceAddress_salutationString
RecipientAddress_company2String
RecipientAddress_lastNameString
ShipmentItems_0_articleIdString
ShipmentItems_1_articleIdString
ShipmentItems_2_articleIdString
ShipmentItems_3_articleIdString
InvoiceAddress_countryCodeString
RecipientAddress_firstNameString
ShipmentItems_0_picks_0_idString
ShipmentItems_1_picks_0_idString
ShipmentItems_2_picks_0_idString
ShippedFromAddress_street1String
ShippedFromAddress_zipcodeString
StatusHistory_0_statusDateInteger
StatusHistory_1_statusDateInteger
StatusHistory_2_statusDateInteger
CustomerPurchaseOrderNumberString
RecipientAddress_salutationString
ShipmentItems_0_createdDateInteger
ShipmentItems_0_descriptionString
ShipmentItems_1_createdDateInteger
ShipmentItems_1_descriptionString
ShipmentItems_2_createdDateInteger
ShipmentItems_2_descriptionString
ShipmentItems_3_createdDateInteger
ShipmentItems_3_descriptionString
AvailabilityForAllWarehousesString
RecipientAddress_countryCodeString
ShipmentItems_0_availabilityString
ShipmentItems_0_freeTextItemBoolean
ShipmentItems_0_parentItemIdString
ShipmentItems_1_availabilityString
ShipmentItems_1_freeTextItemBoolean
ShipmentItems_1_parentItemIdString
ShipmentItems_2_availabilityString
ShipmentItems_2_freeTextItemBoolean
ShipmentItems_2_parentItemIdString
ShipmentItems_3_availabilityString
ShipmentItems_3_freeTextItemBoolean
AdditionalDeliveryInformationString
DeclaredValueAmountCurrencyIdString
ShipmentItems_0_articleNumberString
ShipmentItems_1_articleNumberString
ShipmentItems_2_articleNumberString
ShipmentItems_3_articleNumberString
ShipmentItems_0_manualQuantityBoolean
ShipmentItems_0_positionNumberInteger
ShipmentItems_1_manualQuantityBoolean
ShipmentItems_1_positionNumberInteger
ShipmentItems_2_manualQuantityBoolean
ShipmentItems_2_positionNumberInteger
ShipmentItems_3_manualQuantityBoolean
ShipmentItems_3_positionNumberInteger
ShippedFromAddress_countryCodeString
DeclaredValueAmountCurrencyNameString
ShipmentItems_0_picks_0_versionString
ShipmentItems_1_picks_0_versionString
ShipmentItems_2_picks_0_versionString
RecordEmailAddresses_ccAddressesString
RecordEmailAddresses_toAddressesString
ShipmentItems_0_descriptionFixedBoolean
ShipmentItems_0_lastModifiedDateInteger
ShipmentItems_0_picks_0_quantityString
ShipmentItems_0_salesOrderItemIdString
ShipmentItems_1_descriptionFixedBoolean
ShipmentItems_1_lastModifiedDateInteger
ShipmentItems_1_picks_0_quantityString
ShipmentItems_1_salesOrderItemIdString
ShipmentItems_2_descriptionFixedBoolean
ShipmentItems_2_lastModifiedDateInteger
ShipmentItems_2_picks_0_quantityString
ShipmentItems_2_salesOrderItemIdString
ShipmentItems_3_descriptionFixedBoolean
ShipmentItems_3_lastModifiedDateInteger
ShipmentItems_3_salesOrderItemIdString
ShipmentItems_0_addPageBreakBeforeBoolean
ShipmentItems_0_picks_0_bookedDateInteger
ShipmentItems_1_addPageBreakBeforeBoolean
ShipmentItems_1_picks_0_bookedDateInteger
ShipmentItems_2_addPageBreakBeforeBoolean
ShipmentItems_2_picks_0_bookedDateInteger
ShipmentItems_3_addPageBreakBeforeBoolean
CustomAttributes_0_entityReferencesString
ShipmentItems_0_picks_0_batchNumberString
ShipmentItems_0_picks_0_createdDateInteger
ShipmentItems_1_picks_0_batchNumberString
ShipmentItems_1_picks_0_createdDateInteger
ShipmentItems_2_picks_0_createdDateInteger
ShipmentItems_0_picks_0_confirmedDateInteger
ShipmentItems_0_picks_0_serialNumbersString
SalesInvoiceEmailAddresses_ccAddressesString
SalesInvoiceEmailAddresses_toAddressesString
ShipmentItems_0_picks_0_storagePlaceIdString
ShipmentItems_1_picks_0_storagePlaceIdString
ShipmentItems_2_picks_0_storagePlaceIdString
ShipmentItems_0_picks_0_serialNumbers_0String
ShipmentItems_0_picks_0_serialNumbers_1String
ShipmentItems_0_picks_0_serialNumbers_2String
ShipmentItems_1_picks_0_serialNumbers_0String
CustomAttributes_0_attributeDefinitionIdString
ShipmentItems_0_picks_0_lastModifiedDateInteger
ShipmentItems_1_picks_0_lastModifiedDateInteger
ShipmentItems_2_picks_0_lastModifiedDateInteger
ShipmentItems_0_picks_0_confirmedByUserIdString
ShipmentItems_0_availabilityForAllWarehousesString
ShipmentItems_0_picks_0_sourceStoragePlaceIdString
ShipmentItems_1_availabilityForAllWarehousesString
ShipmentItems_1_picks_0_sourceStoragePlaceIdString
ShipmentItems_2_availabilityForAllWarehousesString
ShipmentItems_2_picks_0_sourceStoragePlaceIdString
ShipmentItems_3_availabilityForAllWarehousesString
ShipmentItems_0_picks_0_transportationOrderIdString
CustomAttributes_0_entityReferences_0_entityIdString
CustomAttributes_0_entityReferences_0_entityNameString
ShipmentItems_0_picks_0_internalTransportReferenceIdString
ShipmentItems_0_picks_0_sourceInternalTransportReferenceIdString
Supplier
View 98 columns
IdString
EmailString
PhoneString
CompanyString
VersionString
SectorIdString
PartyTypeString
CurrencyIdString
OrderBlockBoolean
SectorNameString
CreatedDateDate-time
DescriptionString
CurrencyNameString
Contacts_0_idString
Addresses_0_idString
Addresses_1_idString
SupplierNumberString
PaymentMethodIdString
Addresses_0_cityString
Addresses_1_cityString
Contacts_0_emailString
Contacts_0_optInBoolean
Contacts_0_phoneString
CustomAttributesString
LastModifiedDateDate-time
PrimaryAddressIdString
PrimaryContactIdString
BankAccounts_0_idString
Customfield_BezugString
DeliveryAddressIdString
PaymentMethodNameString
Contacts_0_versionString
Addresses_0_street1String
Addresses_0_versionString
Addresses_0_zipcodeString
Addresses_1_street1String
Addresses_1_street2String
Addresses_1_versionString
Addresses_1_zipcodeString
Contacts_0_lastNameString
Contacts_0_optInSmsBoolean
Customfield_LeasingBoolean
Customfield_PartnerBoolean
Customfield_ProduktString
Addresses_0_lastNameString
Addresses_1_lastNameString
CommercialLanguageIdString
Contacts_0_firstNameString
Contacts_0_partyTypeString
Addresses_0_firstNameString
Addresses_1_firstNameString
Contacts_0_optInPhoneBoolean
Contacts_0_salutationString
Customfield_AnspracheString
VatRegistrationNumberString
Addresses_0_salutationString
Addresses_1_salutationString
BankAccounts_0_partyIdString
BankAccounts_0_primaryBoolean
BankAccounts_0_versionString
Contacts_0_createdDateInteger
Contacts_0_optInLetterBoolean
Customfield_HerstellerBoolean
Addresses_0_countryCodeString
Addresses_0_createdDateInteger
Addresses_1_countryCodeString
Addresses_1_createdDateInteger
BankAccounts_0_bankCodeString
Contacts_0_mobilePhone1String
Customfield_Key AccountString
Addresses_0_primeAddressBoolean
Addresses_1_primeAddressBoolean
Contacts_0_personCompanyString
CustomerNumberAtSupplierString
Customfield_TeststellungString
Customfield_pipedrive_idString
Contacts_0_addresses_0_idString
Addresses_0_invoiceAddressBoolean
Addresses_1_invoiceAddressBoolean
BankAccounts_0_createdDateInteger
Addresses_0_deliveryAddressBoolean
Addresses_1_deliveryAddressBoolean
Contacts_0_lastModifiedDateInteger
Contacts_0_primaryAddressIdString
Addresses_0_lastModifiedDateInteger
Addresses_1_lastModifiedDateInteger
BankAccounts_0_accountHolderString
BankAccounts_0_accountNumberString
BankAccounts_0_creditInstituteString
Contacts_0_addresses_0_versionString
BankAccounts_0_lastModifiedDateInteger
Contacts_0_addresses_0_countryCodeString
Contacts_0_addresses_0_createdDateInteger
Contacts_0_addresses_0_primeAddressBoolean
Contacts_0_addresses_0_invoiceAddressBoolean
Contacts_0_addresses_0_deliveryAddressBoolean
Contacts_0_addresses_0_lastModifiedDateInteger
Customfield_alte Kundennummer (Filemaker)String
User
View 14 columns
IdString
EmailString
StatusString
ImageIdString
VersionString
LastNameString
UsernameString
FirstNameString
UserRolesString
Licenses_0String
CreatedDateDate-time
PhoneNumberString
LastModifiedDateDate-time
MobilePhoneNumberString
Article Basic
Article Supply Source Map
Attendance
Calendar Event
Campaign
Campaign Participant
Contract
Currency
Crm Event
Opportunity
Payment Method
Production Order
Production Work Schedule
Purchase Invoice
Shipment Method
Tag
Ticket
Person Role
Sales Open Item
Purchase Open Item
Customer
Warehouse Stock
Warehouse Stock Movement
Inventory
Purchase Order Request
Purchase Requisition
Sales Order Items
Sales Invoice Items
Shipment Items
Incoming Goods Items
Production Order Items
Warehouse
Article Supply Source
Production Bill Of Material Items
Sales Bill Of Material Items
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed