DocuBuilder lijsten

Countries_and_Regions

Countries and Regions

SELECT
code AS [CountryLetterCode],
displayName AS [Country]
FROM WCAXML_ROOT_Countries_and_Regions

Landen met bijbehorende gegevens

Document_Emails

Document Emails

SELECT
SendToEmail AS [SendToEmail],
Usage2 AS [DocType]
FROM WCAXML_ROOT_Document_Emails

Email adressen gedefinieerd bij de Customer

Invoice_reminder_lines

Invoice reminder lines

SELECT
Amount,
Applies_to_Document_No,
Applies_to_Document_Type,
Description, Document_No,
Document_Type,
Format(Document_Date,'d-m-yy') AS [Document_Date],
Format(Due_Date,'d-m-yy') AS [Due_Date],
Format(Posting_Date,'d-m-yyyy') AS [Posting_Date],
Line_No,
Line_Type,
No,
No_of_Reminders,
Original_Amount,
Remaining_Amount,
Reminder_No,
Type
FROM WCAXML_ROOT_Invoice_reminder_lines

Betalingsherinnering regels

Invoice_reminder_lines_Totals

Invoice reminder lines

SELECT
Sum(Original_Amount) AS Sum_Original_Amount,
Sum(Remaining_Amount) AS Sum_Remaining_Amount
FROM WCAXML_ROOT_Invoice_reminder_lines

Betalingsherinnering totalen van de regels

Job_tasks

Job tasks

SELECT
contractInvoicedCost,
contractInvoicedPrice,
description,
endDate,
globalDimension1Code,
globalDimension2Code,
indentation,
jobPostingGroup,
jobTaskNumber,
jobTaskType,
outstandingOrders,
Planning_Date_Filter,
Posting_Date_Filter,
startDate,
wipMethod,
wipTotal
FROM WCAXML_ROOT_Job_tasks

Projecttaken

Purchasedocument_lines

Purchasedocument lines

SELECT
number AS [ItemNo],
description AS [Description],
unitCost AS [UnitCost],
unitPriceLcy AS [UnitPrice],
quantity AS [Quantity],
IIf([LineDiscountPercent]=0,"",[LineDiscountPercent] & " %") AS [DiscountPercent],
amount AS [AmountExcludingVAT],
vatPercent AS [VATpercent],
amountIncludingVat AS [AmountIncludingVAT],
UnitOfMeasure AS [UnitOfMeasure],
Format(expectedReceiptDate,'d-m-yyyy') AS [ExpectedReceiptDate],
Type,
BlanketOrderNumber
FROM WCAXML_ROOT_Purchasedocument_lines

Inkoop order/factuur/etc. regels

Purchasedocument_lines_Totals

Purchasedocument lines

SELECT
Sum(amount) AS SumExcludingVat,
Sum(amountIncludingVat) AS SumIncludingVat,
Sum([amount]*[vatpercent]/100) AS SumVat
FROM WCAXML_ROOT_Purchasedocument_lines

Inkoop order/factuur/etc. totalen van de regels

Salescreditmemo_posted_lines

Salescreditmemo posted lines

SELECT
[No] AS [ItemNo],
Description,
LineAmount AS [AmountExcludingVAT],
Quantity,
UnitOfMeasure,
IIf([LineDiscountPercent]=0,"",[LineDiscountPercent] & " %") AS [DiscountPercent],
vatPercent & " %" AS [VATpercent],
UnitPrice AS [UnitPrice],
Type
FROM WCAXML_ROOT_Salescreditmemo_posted_lines

Geboekte creditfactuur regels

Salescreditmemo_posted_lines_Totals

Salescreditmemo posted lines

SELECT
Sum(lineamount) AS SumExcludingVat,
Sum(LineAmountIncludingVat) AS SumIncludingVat,
Sum([lineamount]*[vatpercent]/100) AS SumVat
FROM WCAXML_ROOT_Salescreditmemo_posted_lines

Geboekte creditfactuur totalen van de regels

Salesdocument_lines

Salesdocument lines

SELECT
number AS [ItemNo],
description AS [Description],
unitPrice AS [UnitPrice],
quantity AS [Quantity],
IIf([LineDiscountPercent]=0,"",[LineDiscountPercent] & " %") AS [DiscountPercent],
amount AS [AmountExcludingVAT],
vatPercent & " %" AS [VATpercent],
amountIncludingVat AS [AmountIncludingVAT],
UnitOfMeasure AS [UnitOfMeasure] ,
Format(shipmentDate,'d-m-yyyy') AS [ShipmentDate],
Format(plannedDeliveryDate,'d-m-yyyy') AS [PlannedDeliveryDate],
Format(requestedDeliveryDate,'d-m-yyyy') AS [RequestedDeliveryDate],
Type,
BlanketOrderNumber
FROM WCAXML_ROOT_SalesDocument_lines

Verkoop order/factuur/etc. regels

Salesdocument_lines_Totals

Salesdocument lines

SELECT
Sum(amount) AS SumExcludingVat,
Sum(amountIncludingVat) AS SumIncludingVat,
Sum([amount]*[vatpercent]/100) AS SumVat
FROM WCAXML_ROOT_Salesdocument_lines;

Verkoop order/factuur/etc. totalen van de regels

SalesInvoice_posted_lines

SalesInvoice posted lines

SELECT
[No] AS [ItemNo],
Description,
LineAmount AS [AmountExcludingVAT],
lineAmountIncludingVat AS [AmountIncludingVAT],
Quantity,
UnitOfMeasure,
IIf([LineDiscountPercent]=0,"",[LineDiscountPercent] & " %") AS [DiscountPercent],
Format(shipmentDate,'d-m-yyyy') AS [ShipmentDate],
vatPercent & " %" AS [VATpercent],
UnitPrice AS [UnitPrice],
Type
FROM WCAXML_ROOT_Salesinvoice_posted_lines

Verkoopfactuur regels

Salesinvoice_posted_lines_Totals

SalesInvoice posted lines

SELECT
Sum(lineamount) AS SumExcludingVat,
Sum(LineAmountIncludingVat) AS SumIncludingVat,
Sum([lineamount]*[vatpercent]/100) AS SumVat
FROM WCAXML_ROOT_Salesinvoice_posted_lines

Verkoopfactuur totalen van de regels

Salesshipment_posted_lines

Salesshipment posted lines

SELECT
[No] AS [ItemNo],
description AS [Description],
quantity AS [Quantity],
Unit_of_Measure AS [UnitOfMeasure] ,
Format(shipmentDate,'d-m-yyyy') AS [ShipmentDate],
Type
FROM WCAXML_ROOT_Salesshipment_posted_lines

Pakbon regels