Query.Text =
"SELECT ALLOWED
| SalesInvoice.Ref AS Ref,
| SalesInvoice.Number AS Number,
| SalesInvoice.Date AS Date,
| SalesInvoice.Company AS Company,
| SalesInvoice.CompanyVATNumber AS CompanyVATNumber,
| SalesInvoice.Counterparty AS Counterparty,
| SalesInvoice.Contract AS Contract,
| SalesInvoice.ShippingAddress AS ShippingAddress,
| SalesInvoice.ContactPerson AS ContactPerson,
| SalesInvoice.AmountIncludesVAT AS AmountIncludesVAT,
| SalesInvoice.DocumentCurrency AS DocumentCurrency,
| CAST(SalesInvoice.Comment AS STRING(1024)) AS Comment,
| SalesInvoice.Order AS Order,
| SalesInvoice.SalesOrderPosition AS SalesOrderPosition,
| SalesInvoice.VATTaxation = VALUE(Enum.VATTaxationTypes.ReverseChargeVAT) AS ReverseCharge,
| SalesInvoice.StructuralUnit AS StructuralUnit,
| SalesInvoice.DeliveryOption AS DeliveryOption,
| SalesInvoice.ProvideEPD AS ProvideEPD,
| SalesInvoice.DeliveryStartDate AS DeliveryStartDate,
| SalesInvoice.DeliveryEndDate AS DeliveryEndDate,
| SalesInvoice.DeliveryDatePeriod AS DeliveryDatePeriod,
| SalesInvoice.DeliveryDatePosition AS DeliveryDatePosition,
| SalesInvoice.IsRegisterDeliveryDate AS IsRegisterDeliveryDate,
| CASE
| WHEN SalesInvoice.OperationKind = VALUE(Enum.OperationTypesSalesInvoice.ZeroInvoice)
| THEN TRUE
| ELSE FALSE
| END AS ZeroInvoice,
| SalesInvoice.AccountBank AS AccountBank
|INTO SalesInvoices
|FROM
| Document.SalesInvoice AS SalesInvoice
|WHERE
| SalesInvoice.Ref IN(&ObjectsArray)
|;
|
|////////////////////////////////////////////////////////////////////////////////
|SELECT ALLOWED
| SalesInvoice.Ref AS Ref,
| SalesInvoice.Number AS DocumentNumber,
| SalesInvoice.Date AS DocumentDate,
| SalesInvoice.Company AS Company,
| SalesInvoice.CompanyVATNumber AS CompanyVATNumber,
| SalesInvoice.Counterparty AS Counterparty,
| SalesInvoice.Contract AS Contract,
| SalesInvoice.ShippingAddress AS ShippingAddress,
| CASE
| WHEN SalesInvoice.ContactPerson <> VALUE(Catalog.ContactPersons.EmptyRef)
| THEN SalesInvoice.ContactPerson
| WHEN CounterpartyContracts.ContactPerson <> VALUE(Catalog.ContactPersons.EmptyRef)
| THEN CounterpartyContracts.ContactPerson
| ELSE Counterparties.ContactPerson
| END AS CounterpartyContactPerson,
| SalesInvoice.AmountIncludesVAT AS AmountIncludesVAT,
| SalesInvoice.DocumentCurrency AS DocumentCurrency,
| ISNULL(SalesOrder.Number, """") AS SalesOrderNumber,
| ISNULL(SalesOrder.Date, DATETIME(1, 1, 1)) AS SalesOrderDate,
| SalesInvoice.Comment AS Comment,
| SalesInvoice.ReverseCharge AS ReverseCharge,
| SUM(ISNULL(SalesInvoicePrepayment.AmountDocCur, 0)) AS Paid,
| SalesInvoice.StructuralUnit AS StructuralUnit,
| SalesInvoice.DeliveryOption AS DeliveryOption,
| SalesInvoice.ProvideEPD AS ProvideEPD,
| SalesInvoice.IsRegisterDeliveryDate AS IsRegisterDeliveryDate,
| SalesInvoice.DeliveryDatePosition AS DeliveryDatePosition,
| SalesInvoice.DeliveryDatePeriod AS DeliveryDatePeriod,
| SalesInvoice.DeliveryStartDate AS DeliveryStartDate,
| SalesInvoice.DeliveryEndDate AS DeliveryEndDate,
| SalesInvoice.ZeroInvoice AS ZeroInvoice,
| SalesInvoice.AccountBank AS AccountBank
|INTO Header
|FROM
| SalesInvoices AS SalesInvoice
| LEFT JOIN Catalog.Counterparties AS Counterparties
| ON SalesInvoice.Counterparty = Counterparties.Ref
| LEFT JOIN Catalog.BankAccounts AS BankAccounts
| ON SalesInvoice.AccountBank = BankAccounts.Ref
| LEFT JOIN Catalog.CounterpartyContracts AS CounterpartyContracts
| ON SalesInvoice.Contract = CounterpartyContracts.Ref
| LEFT JOIN Document.SalesOrder AS SalesOrder
| ON SalesInvoice.Order = SalesOrder.Ref
| AND (SalesInvoice.SalesOrderPosition = VALUE(Enum.AttributeStationing.InHeader))
| LEFT JOIN Document.SalesInvoice.Prepayment AS SalesInvoicePrepayment
| ON SalesInvoice.Ref = SalesInvoicePrepayment.Ref
|
|GROUP BY
| SalesInvoice.Number,
| SalesInvoice.Date,
| SalesInvoice.Counterparty,
| SalesInvoice.Company,
| SalesInvoice.CompanyVATNumber,
| SalesInvoice.Ref,
| SalesInvoice.Comment,
| ISNULL(SalesOrder.Date, DATETIME(1, 1, 1)),
| ISNULL(SalesOrder.Number, """"),
| SalesInvoice.DocumentCurrency,
| SalesInvoice.AmountIncludesVAT,
| SalesInvoice.ShippingAddress,
| CASE
| WHEN SalesInvoice.ContactPerson <> VALUE(Catalog.ContactPersons.EmptyRef)
| THEN SalesInvoice.ContactPerson
| WHEN CounterpartyContracts.ContactPerson <> VALUE(Catalog.ContactPersons.EmptyRef)
| THEN CounterpartyContracts.ContactPerson
| ELSE Counterparties.ContactPerson
| END,
| SalesInvoice.ReverseCharge,
| SalesInvoice.Contract,
| SalesInvoice.StructuralUnit,
| SalesInvoice.DeliveryOption,
| SalesInvoice.ProvideEPD,
| SalesInvoice.IsRegisterDeliveryDate,
| SalesInvoice.DeliveryDatePosition,
| SalesInvoice.DeliveryDatePeriod,
| SalesInvoice.DeliveryStartDate,
| SalesInvoice.DeliveryEndDate,
| SalesInvoice.ZeroInvoice,
| SalesInvoice.AccountBank
|; |