Page Comparison

Info

DocuBuilder haalt haar gegevens uit retrieves its data from Business Central op via:

Business Central webservices
Na de installatie van de web servicesAfter the installation of the DocuBuilder App in Business Central zijn er een groot aantal webservices toegevoegd aan , a large number of web services were added to Business Central.
De meeste webservices worden gebruikt in de DocuBuilder dataconnectoren (=velden en lijsten) van de standaard DocuBuilder omgeving.
Daarnaast maakt de standaard DocuBuilder omgeving ook gebruik van reeds aanwezige standaard webservices van Business Central.Standaard API van Business Central.
Zie hiervoorMost of the web services are used in the DocuBuilder data connectors (=fields and lists) of the standard DocuBuilder environment.
In addition, the standard DocuBuilder environment also uses already existing standard web services of Business Central.
Standard API from Business Central.
See: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/

Table of Contents

minLevel	2

...

Web services installed by the DocuBuilder App

Na de installatie van de After installing the DocuBuilder App in Business Central zijn de onderstaande webservices toegevoegd, the following web services were added.

Object type	Object-id	Objectnaam	Business Central Servicenaam	DocuBuilder DataConnector
Pagina	70412550	DozBlanketPurchaseOrders	DocuBuilder_DocuBuilder_BlanketPurchaseOrders	Nog niet Not yet in gebruikuse
Pagina	70412551	DozBlanketSalesOrders	DocuBuilder_DocuBuilder_BlanketSalesOrders	Nog niet Not yet in gebruikuse
Pagina	1	Bedrijfsgegevens	DocuBuilder_DocuBuilder_Companies	Company information
Pagina	70412528	DozContacts	DocuBuilder_DocuBuilder_Contacts	Contacts
Pagina	21	Klantenkaart	DocuBuilder_DocuBuilder_Customers	Customers
Pagina	70412539	DozDBButtons	DocuBuilder_DocuBuilder_DocuBuilderButtons	DocuBuilder BC App
Pagina	70412538	DozDBSettings	DocuBuilder_DocuBuilder_DocuBuilderSettings	DocuBuilder BC App
Pagina	9657	Documentindelingen	DocuBuilder_DocuBuilder_DocumentLayouts	Document Emails
Pagina	5200	Werknemer	DocuBuilder_DocuBuilder_Employees	Employees
Pagina	70412529	DozCustomers	DocuBuilder_DocuBuilder_Ext_Customers	Nog niet Not yet in gebruikuse
Pagina	70412530	DozEmployees	DocuBuilder_DocuBuilder_Ext_Employees	Nog niet Not yet in gebruikuse
Pagina	70412549	DozReminders	DocuBuilder_DocuBuilder_Ext_InvoiceReminders	Nog niet Not yet in gebruikuse
Pagina	70412552	DozPostedPurchaseCreditMemos	DocuBuilder_DocuBuilder_Ext_Posted_PurchaseCreditMemos	Nog niet Not yet in gebruikuse
Pagina	70412548	DozPostedSalesShipments	DocuBuilder_DocuBuilder_Ext_Posted_SalesShipments	Salesshipments_ext posted
Pagina	70412536	DozVendors	DocuBuilder_DocuBuilder_Ext_Vendors	Nog niet Not yet in gebruikuse
Pagina	435	Regels	DocuBuilder_DocuBuilder_InvoiceReminderLines	Nog niet Not yet in gebruikuse
Pagina	434	Aanmaning	DocuBuilder_DocuBuilder_InvoiceReminders	Nog niet Not yet in gebruikuse
Pagina	70412537	DozJobs	DocuBuilder_DocuBuilder_Jobs	Job
Pagina	70412540	DozJobTasks	DocuBuilder_DocuBuilder_JobTasks	Job tasks
Pagina	5703	Vestiging	DocuBuilder_DocuBuilder_Locations	Locations
Pagina	530	Geboekte inkoopcreditnotaregels	DocuBuilder_DocuBuilder_Posted_PurchaseCreditMemoLines	Nog niet Not yet in gebruikuse
Pagina	147	Geboekte inkoopcreditnota's	DocuBuilder_DocuBuilder_Posted_PurchaseCreditMemos	Nog niet Not yet in gebruikuse
Pagina	70412547	DozPostedSalesCreditMemoLines	DocuBuilder_DocuBuilder_Posted_SalesCreditMemoLines	Salescreditmemo posted lines
Pagina	70412546	DozPostedSalesCreditMemos	DocuBuilder_DocuBuilder_Posted_SalesCreditMemos	Salescreditmemos posted
Pagina	70412545	DozPostedSalesInvoiceLines	DocuBuilder_DocuBuilder_Posted_SalesInvoiceLines	Salesinvoice posted lines
Pagina	70412544	DozPostedSalesInvoices	DocuBuilder_DocuBuilder_Posted_SalesInvoices	Salesinvoices posted
Pagina	131	Regels	DocuBuilder_DocuBuilder_Posted_SalesShipmentLines	Salesshipment posted lines
Pagina	130	Geboekte verkoopverzending	DocuBuilder_DocuBuilder_Posted_SalesShipments	Salesshipments posted
Pagina	70412541	DozPurchaseCreditMemos	DocuBuilder_DocuBuilder_PurchaseCreditMemos	Nog niet Not yet in gebruikuse
Pagina	70412531	DozPurchaseInvoices	DocuBuilder_DocuBuilder_PurchaseInvoices	Nog niet Not yet in gebruikuse
Pagina	70412542	DozPurchaseOrders	DocuBuilder_DocuBuilder_PurchaseOrders	PurchaseOrders_ext
Pagina	70412543	DozPurchaseQuotes	DocuBuilder_DocuBuilder_PurchaseQuotes	Nog niet Not yet in gebruikuse
Pagina	70412553	DozPurchaseReturnOrders	DocuBuilder_DocuBuilder_PurchaseReturnOrders	Nog niet Not yet in gebruikuse
Pagina	70412532	DozSalesCreditMemos	DocuBuilder_DocuBuilder_SalesCreditMemos	Nog niet Not yet in gebruikuse
Pagina	70412533	DozSalesInvoices	DocuBuilder_DocuBuilder_SalesInvoices	Nog niet Not yet in gebruikuse
Pagina	70412534	DozSalesOrders	DocuBuilder_DocuBuilder_SalesOrders	Nog niet Not yet in gebruikuse
Pagina	14	Verkopers/inkopers	DocuBuilder_DocuBuilder_SalesPurchasersPersons	SalesPersons and purchasers
Pagina	70412535	DozSalesQuotes	DocuBuilder_DocuBuilder_SalesQuotes	Nog niet Not yet in gebruikuse
Pagina	70412554	DozSalesReturnOrders	DocuBuilder_DocuBuilder_SalesReturnOrders	Nog niet Not yet in gebruikuse
Pagina	26	Leverancierskaart	DocuBuilder_DocuBuilder_Vendors	Vendors

...

Standard Business Central API

Dit This is de standaard the standard REST API waarmee DocuBuilder gegevens uit that DocuBuilder uses to retrieve data from Business Central kan ophalen.
Zie hiervoorFor this, see: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/
Via de the DocuBuilder Settings → Microsoft Business Central → Instellingen Settings → [Download queries] kunnen alle velden worden opgehaald in het bestand 'BusinessCentralQueries, zodat deze aan de DocuBuilder DataConnector kunnen worden toegevoegd, all fields can be retrieved in the file 'BusinessCentralQueries, so that they can be added to the DocuBuilder DataConnector.

View file

name	BusinessCentralQueries.txt

...

Web services used in the data connectors of DocuBuilder

DocuBuilder DataConnector	Business Cental Webservice / API entiteitentity	Business Central Type Page of API	ToelichtingExplanation
Company information	DocuBuilder_DocuBuilder_Companies	BC page - 1	Eigen organisatieOwn company
Contacts	DocuBuilder_DocuBuilder_Contacts	BC custom page	ContactpersonenContactn persons
Countries and Regions	countryRegion	standaard API	LandgegevensCountry data
Customers	DocuBuilder_DocuBuilder_Customers	BC page - 21	KlantenCustomers
Document Emails	DocuBuilder_DocuBuilder_DocumentLayouts	BC page - 9657	Email instellingen settings per klantcustomer
Employees	DocuBuilder_DocuBuilder_Employees	BC page - 5200	MedewerkersEmployees
Invoice reminder lines	DocuBuilder_DocuBuilder_InvoiceReminderLines	BC page - 435	Betalingsherinnering regelsPayment reminder rules
Invoice reminders	DocuBuilder_DocuBuilder_InvoiceReminders	BC page - 434	BetalingsherinneringenPayment Reminders
Job	DocuBuilder_DocuBuilder_Jobs	BC custom page	ProjectenProjects
Job tasks	DocuBuilder_DocuBuilder_JobTasks	BC custom page	Project takentasks
Locations	DocuBuilder_DocuBuilder_Locations	PB page - 5703	Locaties van de organisatiesLocations of the organisations
Payment methods	paymentMethod	standaard API	BetalingsmethodenPayment methods
Payment terms	paymentTerm	standaard API	BetalingsvoorwaardenPayment Terms
Purchasedocument lines	purchaseDocumentLines	BC standaard page	InkoopPurchasing: (raamframework) contract / factuur invoice / order / retourorder return order / creditfactuur credit invoice - regelsrules
Purchasedocuments	purchaseDocuments	BC standaard page	InkoopPurchasing: (raamframework) contracten contracts / facturen invoices / orders / retourorders return orders / creditfacturencredit invoices
PurchaseOrders_ext	DocuBuilder_DocuBuilder_PurchaseOrders	BC custom page	Bijwerken inkooporders vanuit Updating purchase orders from DocuFlow
Salescreditmemo posted lines	DocuBuilder_DocuBuilder_Posted_SalesCreditMemoLines	BC custom pageGeboekte verkoop creditnota regels	Booked sales credit note lines
Salescreditmemos posted	DocuBuilder_DocuBuilder_Posted_SalesCreditMemos	BC custom pageGeboekte	verkoop creditnota'sBooked sales credit notes
Salesdocument lines	salesDocumentLines	BC standaard page	VerkoopSales: (raamframework) contract / factuur invoice / offerte quotation / order / retourorder return order / creditfactuur credit invoice - regelsrules
Salesdocuments	salesDocuments	BC standaard page	VerkoopSales: (raamframework) contracten contracts / facturen invoices / offertes quotations / orders / retourorders return orders / creditfacturencredit invoices
Salesinvoice posted lines	DocuBuilder_DocuBuilder_Posted_SalesShipmentLines	BC custom pageGeboekte	verkoopfactuur regelsBooked sales invoice lines
Salesinvoices posted	DocuBuilder_DocuBuilder_Posted_SalesInvoices	BC custom page	Geboekte verkoopfacturenSales invoices booked
SalesPersons and purchasers	DocuBuilder_DocuBuilder_SalesPurchasersPersons	BC page - 14	Contactpersoon voor verkoop en/of inkoopContact person for sales and/or purchasing
Salesshipment posted lines	DocuBuilder_DocuBuilder_Posted_SalesShipmentLines	BC page - 131	Pakbon (geboekte verkoopverzending) regelsPacking slip (booked sales shipment) rules
Salesshipments posted	DocuBuilder_DocuBuilder_Posted_SalesShipments	BC page - 130	Pakbonnen (geboekte verkoopverzendingenPacking slips (booked sales shipments)
Salesshipments_ext posted	DocuBuilder_DocuBuilder_Ext_Posted_SalesShipments	BC custom page	Bijwerken pakbonnen (geboekte verkoopverzendingen) vanuit Update packing slips (booked sales shipments) from DocuFlow
Shipment methods	shipmentMethod	standaard API	VerzendmethodenShipping Methods
Vendors	DocuBuilder_DocuBuilder_Vendors	BC page - 26	Leveranciers

...

Suppliers

Web service fields used in DocuBuilder's data connectors

DocuBuilder DataConnector	Business Central DataSource	Business Central fields
Company information	<query entity="Company" extension="DocuBuilder">
	<properties>
		<property name="Address" />
		<property name="Address_2" />
		<property name="Allow_Blank_Payment_Info" />
		<property name="Auto_Send_Transactions" />
		<property name="Bank_Account_No" />
		<property name="Bank_Branch_No" />
		<property name="Bank_Name" />
		<property name="BankAccountPostingGroup" />
		<property name="Base_Calendar_Code" />
		<property name="Cal_Convergence_Time_Frame" />
		<property name="Check_Avail_Period_Calc" />
		<property name="Check_Avail_Time_Bucket" />
		<property name="City" />
		<property name="Company_Badge" />
		<property name="Contact_Person" />
		<property name="Country_Region_Code" />
		<property name="County" />
		<property name="Customized_Calendar" />
		<property name="E_Mail" />
		<property name="EORI_Number" />
		<property name="Experience" />
		<property name="Fax_No" />
		<property name="Fiscal_Entity_No" />
		<property name="Giro_No" />
		<property name="GLN" />
		<property name="Home_Page" />
		<property name="IBAN" />
		<property name="IC_Inbox_Details" />
		<property name="IC_Inbox_Type" />
		<property name="IC_Partner_Code" />
		<property name="Industrial_Classification" />
		<property name="Location_Code" />
		<property name="Name" />
		<property name="Payment_Routing_No" />
		<property name="Phone_No" />
		<property name="Picture" />
		<property name="Post_Code" />
		<property name="Primary_Key" />
		<property name="Responsibility_Center" />
		<property name="Ship_to_Address" />
		<property name="Ship_to_Address_2" />
		<property name="Ship_to_City" />
		<property name="Ship_to_Contact" />
		<property name="Ship_to_Country_Region_Code" />
		<property name="Ship_to_County" />
		<property name="Ship_to_Name" />
		<property name="Ship_to_Post_Code" />
		<property name="SWIFT_Code" />
		<property name="System_Indicator_Style" />
		<property name="System_Indicator_Text" />
		<property name="Use_GLN_in_Electronic_Document" />
		<property name="VAT_Registration_No" />
	</properties>
	</query>

Contacts	<query entity="Contact" extension="DocuBuilder">
	<properties>
		<property name="name" />
		<property name="number" />
		<property name="Action_Taken_Filter" />
		<property name="address" />
		<property name="address2" />
		<property name="Calcd_Current_Value_Filter" />
		<property name="calcdCurrentValue" />
		<property name="Campaign_Filter" />
		<property name="Chances_of_Success_Percent_Filter" />
		<property name="city" />
		<property name="Close_Opportunity_Filter" />
		<property name="comment" />
		<property name="companyName" />
		<property name="companyNumber" />
		<property name="Completed_Percent_Filter" />
		<property name="correspondenceType" />
		<property name="cost" />
		<property name="countryCode" />
		<property name="county" />
		<property name="currencyCode" />
		<property name="Date_Filter" />
		<property name="dateOfLastInteraction" />
		<property name="documentUrl" />
		<property name="duration" />
		<property name="email" />
		<property name="email2" />
		<property name="Estimated_Value_Filter" />
		<property name="estimatedValue" />
		<property name="excludeFromSegment" />
		<property name="extensionNumber" />
		<property name="externalId" />
		<property name="faxNumber" />
		<property name="firstName" />
		<property name="homePage" />
		<property name="initials" />
		<property name="jobTitle" />
		<property name="languageCode" />
		<property name="lastDateAttempted" />
		<property name="lastDateModified" />
		<property name="lastTimeModified" />
		<property name="lookupContactNumber" />
		<property name="middleName" />
		<property name="minor" />
		<property name="mobilePhoneNumber" />
		<property name="name2" />
		<property name="nextTaskDate" transform="replace(0001-01-01, )" />
		<property name="numberOfBusinessRelations" />
		<property name="numberOfIndustryGroups" />
		<property name="numberOfInteractions" />
		<property name="numberOfJobResponsibilities" />
		<property name="numberOfMailingGroups" />
		<property name="numberOfOpportunities" />
		<property name="numberSeries" />
		<property name="opportunityEntryExists" />
		<property name="organizationalLevelCode" />
		<property name="pager" />
		<property name="parentalConsentReceived" />
		<property name="phoneNumber" />
		<property name="postCode" />
		<property name="Priority_Filter" />
		<property name="privacyBlocked" />
		<property name="Probability_Percent_Filter" />
		<property name="Sales_Cycle_Filter" />
		<property name="Sales_Cycle_Stage_Filter" />
		<property name="Salesperson_Filter" />
		<property name="salespersonCode" />
		<property name="salutationCode" />
		<property name="searchEmail" />
		<property name="searchName" />
		<property name="surname" />
		<property name="Task_Closed_Filter" />
		<property name="Task_Status_Filter" />
		<property name="taskEntryExists" />
		<property name="Team_Filter" />
		<property name="telexAnswerBack" />
		<property name="telexNumber" />
		<property name="territoryCode" />
		<property name="type" />
		<property name="vatRegistrationNumber" />
		<property name="xrmId" />
		<property name="id" />
	</properties>
	</query>

Countries and Regions	<query entity="countryRegion">
	<properties>
		<property name="id" />
		<property name="code" />
		<property name="displayName" />
		<property name="addressFormat" />
		<property name="lastModifiedDateTime" />
	</properties>
	</query>

Customers	<query entity="Customer" extension="DocuBuilder">
	<properties>
		<property name="No" />
		<property name="Name" />
		<property name="Name_2" />
		<property name="Address" />
		<property name="Address_2" />
		<property name="AdjCustProfit" />
		<property name="AdjProfitPct" />
		<property name="Allow_Line_Disc" />
		<property name="AmountOnCrMemo" />
		<property name="AmountOnOutstandingCrMemos" />
		<property name="AmountOnOutstandingInvoices" />
		<property name="AmountOnPostedInvoices" />
		<property name="Application_Method" />
		<property name="Balance_Due" />
		<property name="Balance_Due_LCY" />
		<property name="Balance_LCY" />
		<property name="Base_Calendar_Code" />
		<property name="Bill_to_Customer_No" />
		<property name="Block_Payment_Tolerance" />
		<property name="Blocked" />
		<property name="CalcCreditLimitLCYExpendedPct" />
		<property name="Cash_Flow_Payment_Terms_Code" />
		<property name="City" />
		<property name="Combine_Shipments" />
		<property name="ContactName" />
		<property name="Copy_Sell_to_Addr_to_Qte_From" />
		<property name="Country_Region_Code" />
		<property name="County" />
		<property name="Credit_Limit_LCY" />
		<property name="Currency_Code" />
		<property name="Currency_Filter" />
		<property name="CustInvDiscAmountLCY" />
		<property name="Customer_Disc_Group" />
		<property name="Customer_Posting_Group" />
		<property name="Customer_Price_Group" />
		<property name="CustomerMgt_AvgDaysToPay_No" />
		<property name="Customized_Calendar" />
		<property name="CustSalesLCY_CustProfit_AdjmtCostLCY" />
		<property name="Date_Filter" />
		<property name="DaysPaidPastDueDate" />
		<property name="Disable_Search_by_Name" />
		<property name="Document_Sending_Profile" />
		<property name="DozDocumentUrl" />
		<property name="E_Mail" />
		<property name="EORI_Number" />
		<property name="ExpectedCustMoneyOwed" />
		<property name="Fax_No" />
		<property name="Fin_Charge_Terms_Code" />
		<property name="Gen_Bus_Posting_Group" />
		<property name="GLN" />
		<property name="Global_Dimension_1_Filter" />
		<property name="Global_Dimension_2_Filter" />
		<property name="Home_Page" />
		<property name="IC_Partner_Code" />
		<property name="Invoice_Copies" />
		<property name="Invoice_Disc_Code" />
		<property name="Language_Code" />
		<property name="Last_Date_Modified" />
		<property name="Last_Statement_No" />
		<property name="Location_Code" />
		<property name="MobilePhoneNo" />
		<property name="Name" />
		<property name="Name_2" />
		<property name="No" />
		<property name="Partner_Type" />
		<property name="Payment_Method_Code" />
		<property name="Payment_Terms_Code" />
		<property name="Payments_LCY" />
		<property name="Phone_No" />
		<property name="Post_Code" />
		<property name="Preferred_Bank_Account_Code" />
		<property name="Prepayment_Percent" />
		<property name="Price_Calculation_Method" />
		<property name="Prices_Including_VAT" />
		<property name="Primary_Contact_No" />
		<property name="Print_Statements" />
		<property name="Privacy_Blocked" />
		<property name="Reminder_Terms_Code" />
		<property name="Reserve" />
		<property name="Responsibility_Center" />
		<property name="Salesperson_Code" />
		<property name="Search_Name" />
		<property name="Service_Zone_Code" />
		<property name="Ship_to_Code" />
		<property name="Shipment_Method_Code" />
		<property name="Shipping_Advice" />
		<property name="Shipping_Agent_Code" />
		<property name="Shipping_Agent_Service_Code" />
		<property name="Shipping_Time" />
		<property name="ShowMap" />
		<property name="Tax_Area_Code" />
		<property name="Tax_Liable" />
		<property name="TotalMoneyOwed" />
		<property name="TotalSales2" />
		<property name="Transaction_Mode_Code" />
		<property name="Use_GLN_in_Electronic_Document" />
		<property name="VAT_Bus_Posting_Group" />
		<property name="VAT_Registration_No" />

		<extradata name="DocumentSourceNo" value="{CustomerNo}" />
	</properties>
	</query>

Document Emails	<query entity="DocumentLayout" extension="DocuBuilder">
	<properties>
		<property name="Custom_Report_Description" />
		<property name="Email_Body_Layout_Code" />
		<property name="Email_Body_Layout_Description" />
		<property name="ReportCaption" />
		<property name="ReportID" />
		<property name="SendToEmail" />
		<property name="Sequence" />
		<property name="Source_No" />
		<property name="Source_Type" />
		<property name="Usage" />
		<property name="Usage2" />
		<property name="Use_for_Email_Body" />
	</properties>
	</query>

Employees	<query entity="Employee" extension="DocuBuilder">
	<properties>
		<property name="No" />
		<property name="Last_Name" />
		<property name="First_Name" />
		<property name="Middle_Name" />
		<property name="Address" />
		<property name="Address_2" />
		<property name="Alt_Address_Code" />
		<property name="Alt_Address_End_Date" transform="replace(0001-01-01, )" />
		<property name="Alt_Address_Start_Date" transform="replace(0001-01-01, )" />
		<property name="Application_Method" />
		<property name="Bank_Account_No" />
		<property name="Bank_Branch_No" />
		<property name="Bank_City" />
		<property name="Bank_Name" />
		<property name="Birth_Date" transform="replace(0001-01-01, )" />
		<property name="Cause_of_Inactivity_Code" />
		<property name="City" />
		<property name="Company_E_Mail" />
		<property name="Country_Region_Code" />
		<property name="County" />
		<property name="DozDocumentUrl" />
		<property name="E_Mail" />
		<property name="Employee_Posting_Group" />
		<property name="Employment_Date" transform="replace(0001-01-01, )" />
		<property name="Emplymt_Contract_Code" />
		<property name="Extension" />
		<property name="Gender" />
		<property name="Grounds_for_Term_Code" />
		<property name="IBAN" />
		<property name="Inactive_Date" transform="replace(0001-01-01, )" />
		<property name="Initials" />
		<property name="Job_Title" />
		<property name="Last_Date_Modified" />
		<property name="Mobile_Phone_No" />
		<property name="Pager" />
		<property name="Phone_No_2" />
		<property name="Post_Code" />
		<property name="Privacy_Blocked" />
		<property name="Resource_No" />
		<property name="Salespers_Purch_Code" />
		<property name="Search_Name" />
		<property name="ShowMap" />
		<property name="Social_Security_No" />
		<property name="Statistics_Group_Code" />
		<property name="Status" />
		<property name="SWIFT_Code" />
		<property name="Termination_Date" transform="replace(0001-01-01, )" />
		<property name="Transaction_Mode_Code" />
		<property name="Union_Code" />
		<property name="Union_Membership_No" />
	</properties>
	</query>

Invoice reminder lines	<query entity="InvoiceReminderLine" extension="DocuBuilder">
	<properties>
		<property name="Amount" />
		<property name="Applies_to_Document_No" />
		<property name="Applies_to_Document_Type" />
		<property name="Description" />
		<property name="Document_Date" transform="replace(0001-01-01, )" />
		<property name="Document_No" />
		<property name="Document_Type" />
		<property name="Due_Date" transform="replace(0001-01-01, )" />
		<property name="Line_No" />
		<property name="Line_Type" />
		<property name="No" />
		<property name="No_of_Reminders" />
		<property name="Original_Amount" />
		<property name="Posting_Date" transform="replace(0001-01-01, )" />
		<property name="Remaining_Amount" />
		<property name="Reminder_No" />
		<property name="Type" />
	</properties>
	</query>

Invoice reminders	<query entity="InvoiceReminder" extension="DocuBuilder">
	<properties>
		<property name="No" />
		<property name="Name" />
		<property name="Address" />
		<property name="Address_2" />
		<property name="Assigned_User_ID" />
		<property name="City" />
		<property name="Contact" />
		<property name="Currency_Code" />
		<property name="Customer_No" />
		<property name="Document_Date" transform="replace(0001-01-01, )" />
		<property name="Due_Date" transform="replace(0001-01-01, )" />
		<property name="Fin_Charge_Terms_Code" />
		<property name="Post_Code" />
		<property name="Posting_Date" transform="replace(0001-01-01, )" />
		<property name="Reminder_Level" />
		<property name="Reminder_Terms_Code" />
		<property name="Shortcut_Dimension_1_Code" />
		<property name="Shortcut_Dimension_2_Code" />
		<property name="Use_Header_Level" />

		<extradata name="DocType" value="Reminder" />
	</properties>
	</query>

Job	<query entity="Job" extension="DocuBuilder">
	<properties>
		<property name="number" />
		<property name="description" />
		<property name="allowScheduleContractLines" />
		<property name="appliedCostsAmount" />
		<property name="appliedSalesAmount" />
		<property name="applyUsageLink" />
		<property name="billToAddress" />
		<property name="billToAddress2" />
		<property name="billToCity" />
		<property name="billToContact" />
		<property name="billToContactNumber" />
		<property name="billToCountry" />
		<property name="billToCountryRegionCode" />
		<property name="billToCustomerNumber" />
		<property name="billToName" />
		<property name="billToName2" />
		<property name="billToPostCode" />
		<property name="blocked" />
		<property name="calcRecogCostsAmount" />
		<property name="calcRecogCostsGLAmount" />
		<property name="calcRecogSalesAmount" />
		<property name="calcRecogSalesGLAmount" />
		<property name="comment" />
		<property name="complete" />
		<property name="creationDate" transform="replace(0001-01-01, )" />
		<property name="currencyCode" />
		<property name="customerDiscountGroup" />
		<property name="customerPriceGroup" />
		<property name="description2" />
		<property name="documentUrl" />
		<property name="endingDate" transform="replace(0001-01-01, )" />
		<property name="exchangeCalculationCost" />
		<property name="exchangeCalculationPrice" />
		<property name="globalDimension1Code" />
		<property name="globalDimension2Code" />
		<property name="id" />
		<property name="invoiceCurrencyCode" />
		<property name="jobPostingGroup" />
		<property name="languageCode" />
		<property name="lastDateModified" />
		<property name="nextInvoiceDate" transform="replace(0001-01-01, )" />
		<property name="numberSeries" />
		<property name="overBudget" />
		<property name="personResponsible" />
		<property name="Planning_Date_Filter" transform="replace(0001-01-01, )" />
		<property name="projectManager" />
		<property name="recogCostsAmount" />
		<property name="recogCostsGLAmount" />
		<property name="recogSalesAmount" />
		<property name="recogSalesGLAmount" />
		<property name="reserve" />
		<property name="Resource_Filter" />
		<property name="Resource_Gr_Filter" />
		<property name="scheduledResourceGroupQuantity" />
		<property name="scheduledResourceQuantity" />
		<property name="searchDescription" />
		<property name="startingDate" transform="replace(0001-01-01, )" />
		<property name="status" />
		<property name="totalWIPCostAmount" />
		<property name="totalWIPCostGLAmount" />
		<property name="totalWIPSalesAmount" />
		<property name="totalWIPSalesGLAmount" />
		<property name="wipCompletionCalculated" />
		<property name="wipCompletionPosted" />
		<property name="wipEntriesExist" />
		<property name="wipGLPostingDate" transform="replace(0001-01-01, )" />
		<property name="wipMethod" />
		<property name="wipPostingDate" transform="replace(0001-01-01, )" />
		<property name="wipPostingMethod" />
		<property name="wipWarnings" />
	</properties>
	</query>

Job tasks	<query entity="JobTask" extension="DocuBuilder">
	<properties>
		<property name="jobTaskNumber" />
		<property name="jobTaskType" />
		<property name="description" />
		<property name="jobNumber" />
		<property name="amountReceivedNotInvoiced" />
		<property name="contractInvoicedCost" />
		<property name="contractInvoicedPrice" />
		<property name="contractTotalCost" />
		<property name="contractTotalPrice" />
		<property name="endDate" transform="replace(0001-01-01, )" />
		<property name="globalDimension1Code" />
		<property name="globalDimension2Code" />
		<property name="id" />
		<property name="indentation" />
		<property name="jobPostingGroup" />
		<property name="newPage" />
		<property name="numberOfBlankLines" />
		<property name="outstandingOrders" />
		<property name="Planning_Date_Filter" />
		<property name="Posting_Date_Filter" />
		<property name="recognizedCostsAmount" />
		<property name="recognizedCostsGLAmount" />
		<property name="recognizedSalesAmount" />
		<property name="recognizedSalesGLAmount" />
		<property name="remainingTotalCost" />
		<property name="remainingTotalPrice" />
		<property name="scheduleTotalCost" />
		<property name="scheduleTotalPrice" />
		<property name="startDate" transform="replace(0001-01-01, )" />
		<property name="totaling" />
		<property name="usageTotalCost" />
		<property name="usageTotalPrice" />
		<property name="wipMethod" />
		<property name="wipTotal" />
	</properties>
	</query>

Locations	<query entity="Location" extension="DocuBuilder">
	<properties>
		<property name="Name" />
		<property name="City" />
		<property name="Address" />
		<property name="Address_2" />
		<property name="Code" />
		<property name="Adjustment_Bin_Code" />
		<property name="Allow_Breakbulk" />
		<property name="Always_Create_Pick_Line" />
		<property name="Always_Create_Put_away_Line" />
		<property name="Asm_to_Order_Shpt_Bin_Code" />
		<property name="Base_Calendar_Code" />
		<property name="Bin_Capacity_Policy" />
		<property name="Bin_Mandatory" />
		<property name="Contact" />
		<property name="Country_Region_Code" />
		<property name="Cross_Dock_Bin_Code" />
		<property name="Cross_Dock_Due_Date_Calc" />
		<property name="Customized_Calendar" />
		<property name="Default_Bin_Selection" />
		<property name="Directed_Put_away_and_Pick" />
		<property name="E_Mail" />
		<property name="Fax_No" />
		<property name="From_Assembly_Bin_Code" />
		<property name="From_Production_Bin_Code" />
		<property name="Home_Page" />
		<property name="Inbound_Whse_Handling_Time" />
		<property name="Open_Shop_Floor_Bin_Code" />
		<property name="Outbound_Whse_Handling_Time" />
		<property name="Phone_No" />
		<property name="Pick_According_to_FEFO" />
		<property name="Post_Code" />
		<property name="Put_away_Template_Code" />
		<property name="Receipt_Bin_Code" />
		<property name="Require_Pick" />
		<property name="Require_Put_away" />
		<property name="Require_Receive" />
		<property name="Require_Shipment" />
		<property name="Shipment_Bin_Code" />
		<property name="ShowMap" />
		<property name="Special_Equipment" />
		<property name="To_Assembly_Bin_Code" />
		<property name="To_Production_Bin_Code" />
		<property name="Use_ADCS" />
		<property name="Use_As_In_Transit" />
		<property name="Use_Cross_Docking" />
		<property name="Use_Put_away_Worksheet" />
	</properties>
	</query>

Payment methods	<query entity="paymentMethod">
	<properties>
		<property name="id" />
		<property name="code" />
		<property name="displayName" />
		<property name="lastModifiedDateTime" />
	</properties>
	</query>

Payment terms	<query entity="paymentTerm">
	<properties>
		<property name="id" />
		<property name="code" />
		<property name="displayName" />
		<property name="dueDateCalculation" />
		<property name="discountDateCalculation" />
		<property name="discountPercent" />
		<property name="calculateDiscountOnCreditMemos" />
		<property name="lastModifiedDateTime" />
	</properties>
	</query>

Purchasedocument lines	<query entity="purchaseDocumentLines">
	<properties>
		<property name="documentNumber" />
		<property name="documentType" />
		<property name="allowInvoiceDisc" />
		<property name="allowItemChargeAssignment" />
		<property name="amount" />
		<property name="amountIncludingVat" />
		<property name="amtRcdNotInvoiced" />
		<property name="amtRcdNotInvoicedLcy" />
		<property name="applToItemEntry" />
		<property name="aRcdNotInvExVatLcy" />
		<property name="area" />
		<property name="attachedToLineNumber" />
		<property name="binCode" />
		<property name="blanketOrderLineNumber" />
		<property name="blanketOrderNumber" />
		<property name="budgetedFaNumber" />
		<property name="buyFromVendorNumber" />
		<property name="completelyReceived" />
		<property name="crossReferenceNumber" />
		<property name="crossReferenceType" />
		<property name="crossReferenceTypeNumber" />
		<property name="currencyCode" />
		<property name="deferralCode" />
		<property name="deprAcquisitionCost" />
		<property name="depreciationBookCode" />
		<property name="deprUntilFaPostingDate" transform="replace(0001-01-01, )" />
		<property name="description" />
		<property name="description2" />
		<property name="dimensionSetId" />
		<property name="directUnitCost" />
		<property name="dropShipment" />
		<property name="duplicateInDepreciationBook" />
		<property name="entryPoint" />
		<property name="expectedReceiptDate" transform="replace(0001-01-01, )" />
		<property name="faPostingDate" transform="replace(0001-01-01, )" />
		<property name="faPostingType" />
		<property name="finished" />
		<property name="genBusPostingGroup" />
		<property name="genProdPostingGroup" />
		<property name="grossWeight" />
		<property name="icPartnerCode" />
		<property name="icPartnerReference" />
		<property name="icPartnerRefType" />
		<property name="inboundWhseHandlingTime" />
		<property name="indirectCostPercent" />
		<property name="insuranceNumber" />
		<property name="invDiscAmountToInvoice" />
		<property name="invDiscountAmount" />
		<property name="itemCategoryCode" />
		<property name="jobCurrencyCode" />
		<property name="jobCurrencyFactor" />
		<property name="jobLineAmount" />
		<property name="jobLineAmountLcy" />
		<property name="jobLineDiscAmountLcy" />
		<property name="jobLineDiscountAmount" />
		<property name="jobLineDiscountPercent" />
		<property name="jobLineType" />
		<property name="jobNumber" />
		<property name="jobPlanningLineNumber" />
		<property name="jobRemainingQty" />
		<property name="jobRemainingQtyBase" />
		<property name="jobTaskNumber" />
		<property name="jobTotalPrice" />
		<property name="jobTotalPriceLcy" />
		<property name="jobUnitPrice" />
		<property name="jobUnitPriceLcy" />
		<property name="leadTimeCalculation" />
		<property name="lineAmount" />
		<property name="lineDiscountAmount" />
		<property name="lineDiscountPercent" />
		<property name="lineNumber" />
		<property name="locationCode" />
		<property name="maintenanceCode" />
		<property name="mpsOrder" />
		<property name="netWeight" />
		<property name="nonstock" />
		<property name="number" />
		<property name="operationNumber" />
		<property name="orderDate" transform="replace(0001-01-01, )" />
		<property name="outstandingAmount" />
		<property name="outstandingAmountLcy" />
		<property name="outstandingAmtExVatLcy" />
		<property name="outstandingQtyBase" />
		<property name="outstandingQuantity" />
		<property name="overheadRate" />
		<property name="payToVendorNumber" />
		<property name="plannedReceiptDate" transform="replace(0001-01-01, )" />
		<property name="planningFlexibility" />
		<property name="postingGroup" />
		<property name="prepaymentAmount" />
		<property name="prepaymentLine" />
		<property name="prepaymentPercent" />
		<property name="prepaymentTaxAreaCode" />
		<property name="prepaymentTaxGroupCode" />
		<property name="prepaymentTaxLiable" />
		<property name="prepaymentVatDifference" />
		<property name="prepaymentVatIdentifier" />
		<property name="prepaymentVatPercent" />
		<property name="prepmtAmountInvInclVat" />
		<property name="prepmtAmountInvLcy" />
		<property name="prepmtAmtDeducted" />
		<property name="prepmtAmtInclVat" />
		<property name="prepmtAmtInv" />
		<property name="prepmtAmtToDeduct" />
		<property name="prepmtLineAmount" />
		<property name="prepmtVatAmountInvLcy" />
		<property name="prepmtVatBaseAmt" />
		<property name="prepmtVatCalcType" />
		<property name="prepmtVatDiffDeducted" />
		<property name="prepmtVatDiffToDeduct" />
		<property name="prodOrderLineNumber" />
		<property name="prodOrderNumber" />
		<property name="profitPercent" />
		<property name="promisedReceiptDate" transform="replace(0001-01-01, )" />
		<property name="purchasingCode" />
		<property name="qtyAssigned" />
		<property name="qtyInvoicedBase" />
		<property name="qtyPerUnitOfMeasure" />
		<property name="qtyRcdNotInvoiced" />
		<property name="qtyRcdNotInvoicedBase" />
		<property name="qtyReceivedBase" />
		<property name="qtyToAssign" />
		<property name="qtyToInvoice" />
		<property name="qtyToInvoiceBase" />
		<property name="qtyToReceive" />
		<property name="qtyToReceiveBase" />
		<property name="quantity" />
		<property name="quantityBase" />
		<property name="quantityInvoiced" />
		<property name="quantityReceived" />
		<property name="recalculateInvoiceDisc" />
		<property name="receiptLineNumber" />
		<property name="receiptNumber" />
		<property name="requestedReceiptDate" transform="replace(0001-01-01, )" />
		<property name="reservedQtyBase" />
		<property name="reservedQuantity" />
		<property name="responsibilityCenter" />
		<property name="retQtyShpdNotInvdBase" />
		<property name="returnQtyShipped" />
		<property name="returnQtyShippedBase" />
		<property name="returnQtyShippedNotInvd" />
		<property name="returnQtyToShip" />
		<property name="returnQtyToShipBase" />
		<property name="returnReasonCode" />
		<property name="returnsDeferralStartDate" transform="replace(0001-01-01, )" />
		<property name="returnShipmentLineNumber" />
		<property name="returnShipmentNumber" />
		<property name="returnShpdNotInvd" />
		<property name="returnShpdNotInvdLcy" />
		<property name="routingNumber" />
		<property name="routingReferenceNumber" />
		<property name="safetyLeadTime" />
		<property name="salesOrderLineNumber" />
		<property name="salesOrderNumber" />
		<property name="salvageValue" />
		<property name="shortcutDimension1Code" />
		<property name="shortcutDimension2Code" />
		<property name="specialOrder" />
		<property name="specialOrderSalesLineNumber" />
		<property name="specialOrderSalesNumber" />
		<property name="subtype" />
		<property name="systemCreatedEntry" />
		<property name="taxAreaCode" />
		<property name="taxGroupCode" />
		<property name="taxLiable" />
		<property name="transactionSpecification" />
		<property name="transactionType" />
		<property name="transportMethod" />
		<property name="type" />
		<property name="unitCost" />
		<property name="unitCostLcy" />
		<property name="unitOfMeasure" />
		<property name="unitOfMeasureCode" />
		<property name="unitOfMeasureCrossRef" />
		<property name="unitPriceLcy" />
		<property name="unitsPerParcel" />
		<property name="unitVolume" />
		<property name="useDuplicationList" />
		<property name="useTax" />
		<property name="variantCode" />
		<property name="vatBaseAmount" />
		<property name="vatBusPostingGroup" />
		<property name="vatCalculationType" />
		<property name="vatDifference" />
		<property name="vatIdentifier" />
		<property name="vatPercent" />
		<property name="vatProdPostingGroup" />
		<property name="vendorItemNumber" />
		<property name="whseOutstandingQtyBase" />
		<property name="workCenterNumber" />
	</properties>
	</query>

Purchasedocuments	<query entity="purchaseDocuments">
	<properties>
		<property name="number" />
		<property name="documentType" />
		<property name="yourReference" />
		<property name="amount" />
		<property name="amountIncludingVat" />
		<property name="amtRcdNotInvoicedLcy" />
		<property name="appliesToDocNumber" />
		<property name="appliesToDocType" />
		<property name="appliesToId" />
		<property name="aRcdNotInvExVatLcy" />
		<property name="area" />
		<property name="assignedUserId" />
		<property name="balAccountNumber" />
		<property name="balAccountType" />
		<property name="buyFromAddress" />
		<property name="buyFromAddress2" />
		<property name="buyFromCity" />
		<property name="buyFromContact" />
		<property name="buyFromContactNumber" />
		<property name="buyFromCountryRegionCode" />
		<property name="buyFromCounty" />
		<property name="buyFromIcPartnerCode" />
		<property name="buyFromPostCode" />
		<property name="buyFromVendorName" />
		<property name="buyFromVendorName2" />
		<property name="buyFromVendorNumber" />
		<property name="campaignNumber" />
		<property name="comment" />
		<property name="completelyReceived" />
		<property name="compressPrepayment" />
		<property name="correction" />
		<property name="creditorNumber" />
		<property name="currencyCode" />
		<property name="currencyFactor" />
		<property name="dimensionSetId" />
		<property name="docNumberOccurrence" />
		<property name="documentDate" transform="replace(0001-01-01, )" />
		<property name="dueDate" transform="replace(0001-01-01, )" />
		<property name="entryPoint" />
		<property name="expectedReceiptDate" transform="replace(0001-01-01, )" />
		<property name="genBusPostingGroup" />
		<property name="icDirection" />
		<property name="icStatus" />
		<property name="id" />
		<property name="inboundWhseHandlingTime" />
		<property name="incomingDocumentEntryNumber" />
		<property name="invoice" />
		<property name="invoiceDiscCode" />
		<property name="invoiceDiscountAmount" />
		<property name="invoiceDiscountCalculation" />
		<property name="invoiceDiscountValue" />
		<property name="jobQueueEntryId" />
		<property name="jobQueueStatus" />
		<property name="languageCode" />
		<property name="lastPostingNumber" />
		<property name="lastPrepaymentNumber" />
		<property name="lastPrepmtCrMemoNumber" />
		<property name="lastReceivingNumber" />
		<property name="lastReturnShipmentNumber" />
		<property name="leadTimeCalculation" />
		<property name="locationCode" />
		<property name="locationFilter" />
		<property name="numberOfArchivedVersions" />
		<property name="numberPrinted" />
		<property name="numberSeries" />
		<property name="onHold" />
		<property name="orderAddressCode" />
		<property name="orderClass" />
		<property name="orderDate" transform="replace(0001-01-01, )" />
		<property name="paymentDiscountPercent" />
		<property name="paymentMethodCode" />
		<property name="paymentReference" />
		<property name="paymentTermsCode" />
		<property name="payToAddress" />
		<property name="payToAddress2" />
		<property name="payToCity" />
		<property name="payToContact" />
		<property name="payToContactNumber" />
		<property name="payToCountryRegionCode" />
		<property name="payToCounty" />
		<property name="payToIcPartnerCode" />
		<property name="payToName" />
		<property name="payToName2" />
		<property name="payToPostCode" />
		<property name="payToVendorNumber" />
		<property name="pendingApprovals" />
		<property name="pmtDiscountDate" transform="replace(0001-01-01, )" />
		<property name="postingDate" transform="replace(0001-01-01, )" />
		<property name="postingDescription" />
		<property name="postingFromWhseRef" />
		<property name="postingNumber" />
		<property name="postingNumberSeries" />
		<property name="prepaymentDueDate" transform="replace(0001-01-01, )" />
		<property name="prepaymentNumber" />
		<property name="prepaymentNumberSeries" />
		<property name="prepaymentPercent" />
		<property name="prepmtCrMemoNumber" />
		<property name="prepmtCrMemoNumberSeries" />
		<property name="prepmtPaymentDiscountPercent" />
		<property name="prepmtPaymentTermsCode" />
		<property name="prepmtPmtDiscountDate" transform="replace(0001-01-01, )" />
		<property name="prepmtPostingDescription" />
		<property name="pricesIncludingVat" />
		<property name="printPostedDocuments" />
		<property name="promisedReceiptDate" transform="replace(0001-01-01, )" />
		<property name="purchaserCode" />
		<property name="quoteNumber" />
		<property name="reasonCode" />
		<property name="recalculateInvoiceDisc" />
		<property name="receive" />
		<property name="receivingNumber" />
		<property name="receivingNumberSeries" />
		<property name="requestedReceiptDate" transform="replace(0001-01-01, )" />
		<property name="responsibilityCenter" />
		<property name="returnShipmentNumber" />
		<property name="returnShipmentNumberSeries" />
		<property name="sellToCustomerNumber" />
		<property name="sendIcDocument" />
		<property name="ship" />
		<property name="shipmentMethodCode" />
		<property name="shipToAddress" />
		<property name="shipToAddress2" />
		<property name="shipToCity" />
		<property name="shipToCode" />
		<property name="shipToContact" />
		<property name="shipToCountryRegionCode" />
		<property name="shipToCounty" />
		<property name="shipToName" />
		<property name="shipToName2" />
		<property name="shipToPostCode" />
		<property name="shortcutDimension1Code" />
		<property name="shortcutDimension2Code" />
		<property name="status" />
		<property name="taxAreaCode" />
		<property name="taxLiable" />
		<property name="transactionSpecification" />
		<property name="transactionType" />
		<property name="transportMethod" />
		<property name="vatBaseDiscountPercent" />
		<property name="vatBusPostingGroup" />
		<property name="vatCountryRegionCode" />
		<property name="vatRegistrationNumber" />
		<property name="vendorAuthorizationNumber" />
		<property name="vendorCrMemoNumber" />
		<property name="vendorInvoiceNumber" />
		<property name="vendorOrderNumber" />
		<property name="vendorPostingGroup" />
		<property name="vendorShipmentNumber" />

		<extradata name="DocumentUsageCode" value="P." />
	</properties>
	</query>

PurchaseOrders_ext	<query entity="PurchaseOrders" extension="DocuBuilder">
	<properties>
		<property name="amount" />
		<property name="amountIncludingVAT" />
		<property name="amountReceivedNotInvoiced" />
		<property name="amountReceivedNotInvoicedExcludingVAT" />
		<property name="appliesToDocumentNumber" />
		<property name="appliesToDocumentType" />
		<property name="appliesToId" />
		<property name="area" />
		<property name="assignedUserId" />
		<property name="balAccountNumber" />
		<property name="balAccountType" />
		<property name="buyFromAddress" />
		<property name="buyFromAddress2" />
		<property name="buyFromCity" />
		<property name="buyFromContact" />
		<property name="buyFromContactNumber" />
		<property name="buyFromCountryRegionCode" />
		<property name="buyFromCounty" />
		<property name="buyFromICPartnerCode" />
		<property name="buyFromPostCode" />
		<property name="buyFromVendorName" />
		<property name="buyFromVendorName2" />
		<property name="buyFromVendorNumber" />
		<property name="campaignNumber" />
		<property name="comment" />
		<property name="completelyReceived" />
		<property name="compressPrepayment" />
		<property name="correction" />
		<property name="creditorNumber" />
		<property name="currencyCode" />
		<property name="currencyFactor" />
		<property name="dimensionSetId" />
		<property name="docNumberOccurrence" />
		<property name="documentDate" />
		<property name="documentStatus" />
		<property name="documentType" />
		<property name="documentUrl" />
		<property name="dueDate" />
		<property name="entryPoint" />
		<property name="expectedReceiptDate" />
		<property name="genBusPostingGroup" />
		<property name="icDirection" />
		<property name="icStatus" />
		<property name="id" />
		<property name="inboundWhseHandlingTime" />
		<property name="incomingDocumentEntryNumber" />
		<property name="invoice" />
		<property name="invoiceDiscountAmount" />
		<property name="invoiceDiscountCalculation" />
		<property name="invoiceDiscountCode" />
		<property name="invoiceDiscountValue" />
		<property name="jobQueueEntryId" />
		<property name="jobQueueStatus" />
		<property name="languageCode" />
		<property name="lastPostingNumber" />
		<property name="lastPrepaymentCreditMemoNumber" />
		<property name="lastPrepaymentNumber" />
		<property name="lastReceivingNumber" />
		<property name="lastReturnShipmentNumber" />
		<property name="leadTimeCalculation" />
		<property name="Location_Filter" />
		<property name="locationCode" />
		<property name="number" />
		<property name="numberOfArchivedVersions" />
		<property name="numberPrinted" />
		<property name="numberSeries" />
		<property name="onHold" />
		<property name="orderAddressCode" />
		<property name="orderClass" />
		<property name="orderDate" />
		<property name="partiallyInvoiced" />
		<property name="paymentDiscount" />
		<property name="paymentDiscountDate" />
		<property name="paymentMethodCode" />
		<property name="paymentReference" />
		<property name="paymentTermsCode" />
		<property name="payToAddress" />
		<property name="payToAddress2" />
		<property name="payToCity" />
		<property name="payToContact" />
		<property name="payToContactNumber" />
		<property name="payToCountryRegionCode" />
		<property name="payToCounty" />
		<property name="payToICPartnerCode" />
		<property name="payToName" />
		<property name="payToName2" />
		<property name="payToPostCode" />
		<property name="payToVendorNumber" />
		<property name="pendingApprovals" />
		<property name="postingDate" />
		<property name="postingDescription" />
		<property name="postingFromWhseRef" />
		<property name="postingNumber" />
		<property name="postingNumberSeries" />
		<property name="prepayment" />
		<property name="prepaymentCreditMemoNumber" />
		<property name="prepaymentCreditMemoNumberSeries" />
		<property name="prepaymentDueDate" />
		<property name="prepaymentNumber" />
		<property name="prepaymentNumberSeries" />
		<property name="prepaymentPaymentDiscount" />
		<property name="prepaymentPaymentDiscountDate" />
		<property name="prepaymentPaymentTermsCode" />
		<property name="prepaymentPostingDescription" />
		<property name="pricesIncludingVAT" />
		<property name="printPostedDocuments" />
		<property name="promisedReceiptDate" />
		<property name="purchaserCode" />
		<property name="quoteNumber" />
		<property name="reasonCode" />
		<property name="recalculateInvoiceDiscount" />
		<property name="receive" />
		<property name="receivingNumber" />
		<property name="receivingNumberSeries" />
		<property name="requestedReceiptDate" />
		<property name="responsibilityCenter" />
		<property name="returnShipmentNumber" />
		<property name="returnShipmentNumberSeries" />
		<property name="sellToCustomerNumber" />
		<property name="sendICDocument" />
		<property name="ship" />
		<property name="shipmentMethodCode" />
		<property name="shipToAddress" />
		<property name="shipToAddress2" />
		<property name="shipToCity" />
		<property name="shipToCode" />
		<property name="shipToContact" />
		<property name="shipToCountryRegionCode" />
		<property name="shipToCounty" />
		<property name="shipToName" />
		<property name="shipToName2" />
		<property name="shipToPostCode" />
		<property name="shortcutDimension1Code" />
		<property name="shortcutDimension2Code" />
		<property name="status" />
		<property name="taxAreaCode" />
		<property name="taxLiable" />
		<property name="transactionSpecification" />
		<property name="transactionType" />
		<property name="transportMethod" />
		<property name="vatBaseDiscount" />
		<property name="vatBusPostingGroup" />
		<property name="vatCountryRegionCode" />
		<property name="vatRegistrationNumber" />
		<property name="vendorAuthorizationNumber" />
		<property name="vendorCreditMemoNumber" />
		<property name="vendorInvoiceNumber" />
		<property name="vendorOrderNumber" />
		<property name="vendorPostingGroup" />
		<property name="vendorShipmentNumber" />
		<property name="yourReference" />
	</properties>
	</query>

Salescreditmemo posted lines	<query entity="Posted_SalesCreditMemoLine" extension="DocuBuilder">
	<properties>
		<property name="no" />
		<property name="lineAmount" />
		<property name="allowInvoiceDisc" />
		<property name="applFromItemEntry" />
		<property name="applToItemEntry" />
		<property name="crossReferenceNo" />
		<property name="deferralCode" />
		<property name="description" />
		<property name="documentNo" />
		<property name="icPartnerCode" />
		<property name="id" />
		<property name="invDiscountAmount" />
		<property name="itemReferenceNo" />
		<property name="jobNo" />
		<property name="jobTaskNo" />
		<property name="lineAmount" />
		<property name="lineAmountIncludingVat" />
		<property name="lineDiscountAmount" />
		<property name="lineDiscountPercent" />
		<property name="lineNo" />
		<property name="lineVatAmount" />
		<property name="no" />
		<property name="postingDate" transform="replace(0001-01-01, )" />
		<property name="quantity" />
		<property name="returnReasonCode" />
		<property name="shipmentDate" transform="replace(0001-01-01, )" />
		<property name="shortcutDimension1Code" />
		<property name="shortcutDimension2Code" />
		<property name="taxAreaCode" />
		<property name="taxGroupCode" />
		<property name="taxLiable" />
		<property name="type" />
		<property name="unitCostLcy" />
		<property name="unitOfMeasure" />
		<property name="unitOfMeasureCode" />
		<property name="unitPrice" />
		<property name="variantCode" />
		<property name="vatPercent" />
	</properties>
	</query>

Salescreditmemos posted	<query entity="Posted_SalesCreditMemo" extension="DocuBuilder">
	<properties>
		<property name="no" />
		<property name="sellToCustomerName" />
		<property name="yourReference" />
		<property name="amount" />
		<property name="amountIncludingVat" />
		<property name="appliesToDocType" />
		<property name="area" />
		<property name="billToAddress" />
		<property name="billToAddress2" />
		<property name="billToCity" />
		<property name="billToContact" />
		<property name="billToContactNo" />
		<property name="billToCountryRegionCode" />
		<property name="billToCounty" />
		<property name="billToCustomerNo" />
		<property name="billToName" />
		<property name="billToPostCode" />
		<property name="cancelled" />
		<property name="corrective" />
		<property name="currencyCode" />
		<property name="documentDate" transform="replace(0001-01-01, )" />
		<property name="documentExchangeStatus" />
		<property name="dueDate" transform="replace(0001-01-01, )" />
		<property name="eu3PartyTrade" />
		<property name="exitPoint" />
		<property name="externalDocumentNo" />
		<property name="id" />
		<property name="locationCode" />
		<property name="noPrinted" />
		<property name="packageTrackingNo" />
		<property name="paid" />
		<property name="paymentMethodCode" />
		<property name="paymentTermsCode" />
		<property name="pmtDiscountDate" transform="replace(0001-01-01, )" />
		<property name="postingDate" transform="replace(0001-01-01, )" />
		<property name="postingDescription" />
		<property name="preAssignedNo" />
		<property name="prepaymentOrderNo" />
		<property name="remainingAmount" />
		<property name="responsibilityCenter" />
		<property name="returnOrderNo" />
		<property name="salespersonCode" />
		<property name="sellToAddress" />
		<property name="sellToAddress2" />
		<property name="sellToCity" />
		<property name="sellToContact" />
		<property name="sellToContactNo" />
		<property name="sellToCountryRegionCode" />
		<property name="sellToCounty" />
		<property name="sellToCustomerNo" />
		<property name="sellToEmail" />
		<property name="sellToPostCode" />
		<property name="shipmentDate" transform="replace(0001-01-01, )" />
		<property name="shipmentMethodCode" />
		<property name="shippingAgentCode" />
		<property name="shipToAddress" />
		<property name="shipToAddress2" />
		<property name="shipToCity" />
		<property name="shipToCode" />
		<property name="shipToContact" />
		<property name="shipToCountryRegionCode" />
		<property name="shipToCounty" />
		<property name="shipToName" />
		<property name="shipToPostCode" />
		<property name="shortcutDimension1Code" />
		<property name="shortcutDimension2Code" />
		<property name="taxAreaCode" />
		<property name="taxLiable" />
		<property name="transactionSpecification" />
		<property name="transactionType" />
		<property name="transportMethod" />
		<property name="workDescription" />

		<extradata name="DocType" value="Credit Memo" />
		<extradata name="DocumentUsageCode" value="S." />
	</properties>
	</query>

Salesdocument lines	<query entity="salesDocumentLines">
	<properties>
		<property name="documentNumber" />
		<property name="documentType" />
		<property name="allowInvoiceDisc" />
		<property name="allowItemChargeAssignment" />
		<property name="allowLineDisc" />
		<property name="amount" />
		<property name="amountIncludingVat" />
		<property name="applFromItemEntry" />
		<property name="applToItemEntry" />
		<property name="area" />
		<property name="atoWhseOutstandingQty" />
		<property name="atoWhseOutstdQtyBase" />
		<property name="attachedToLineNumber" />
		<property name="billToCustomerNumber" />
		<property name="binCode" />
		<property name="blanketOrderLineNumber" />
		<property name="blanketOrderNumber" />
		<property name="bomItemNumber" />
		<property name="completelyShipped" />
		<property name="crossReferenceNumber" />
		<property name="crossReferenceType" />
		<property name="crossReferenceTypeNumber" />
		<property name="currencyCode" />
		<property name="customerDiscGroup" />
		<property name="customerPriceGroup" />
		<property name="deferralCode" />
		<property name="depreciationBookCode" />
		<property name="deprUntilFaPostingDate" transform="replace(0001-01-01, )" />
		<property name="description" />
		<property name="description2" />
		<property name="dimensionSetId" />
		<property name="dropShipment" />
		<property name="duplicateInDepreciationBook" />
		<property name="exitPoint" />
		<property name="faPostingDate" transform="replace(0001-01-01, )" />
		<property name="genBusPostingGroup" />
		<property name="genProdPostingGroup" />
		<property name="grossWeight" />
		<property name="icPartnerCode" />
		<property name="icPartnerReference" />
		<property name="icPartnerRefType" />
		<property name="invDiscAmountToInvoice" />
		<property name="invDiscountAmount" />
		<property name="itemCategoryCode" />
		<property name="jobContractEntryNumber" />
		<property name="jobNumber" />
		<property name="jobTaskNumber" />
		<property name="lineAmount" />
		<property name="lineDiscountAmount" />
		<property name="lineDiscountPercent" />
		<property name="lineNumber" />
		<property name="locationCode" />
		<property name="netWeight" />
		<property name="nonstock" />
		<property name="number" />
		<property name="originallyOrderedNumber" />
		<property name="originallyOrderedVarCode" />
		<property name="outboundWhseHandlingTime" />
		<property name="outOfStockSubstitution" />
		<property name="outstandingAmount" />
		<property name="outstandingAmountLcy" />
		<property name="outstandingQtyBase" />
		<property name="outstandingQuantity" />
		<property name="planned" />
		<property name="plannedDeliveryDate" transform="replace(0001-01-01, )" />
		<property name="plannedShipmentDate" transform="replace(0001-01-01, )" />
		<property name="postingDate" transform="replace(0001-01-01, )" />
		<property name="postingGroup" />
		<property name="prepaymentAmount" />
		<property name="prepaymentLine" />
		<property name="prepaymentPercent" />
		<property name="prepaymentTaxAreaCode" />
		<property name="prepaymentTaxGroupCode" />
		<property name="prepaymentTaxLiable" />
		<property name="prepaymentVatDifference" />
		<property name="prepaymentVatIdentifier" />
		<property name="prepaymentVatPercent" />
		<property name="prepmtAmountInvInclVat" />
		<property name="prepmtAmountInvLcy" />
		<property name="prepmtAmtDeducted" />
		<property name="prepmtAmtInclVat" />
		<property name="prepmtAmtInv" />
		<property name="prepmtAmtToDeduct" />
		<property name="prepmtLineAmount" />
		<property name="prepmtVatAmountInvLcy" />
		<property name="prepmtVatBaseAmt" />
		<property name="prepmtVatCalcType" />
		<property name="prepmtVatDiffDeducted" />
		<property name="prepmtVatDiffToDeduct" />
		<property name="priceDescription" />
		<property name="profitPercent" />
		<property name="promisedDeliveryDate" transform="replace(0001-01-01, )" />
		<property name="purchaseOrderNumber" />
		<property name="purchasingCode" />
		<property name="purchOrderLineNumber" />
		<property name="qtyAssigned" />
		<property name="qtyInvoicedBase" />
		<property name="qtyPerUnitOfMeasure" />
		<property name="qtyShippedBase" />
		<property name="qtyShippedNotInvdBase" />
		<property name="qtyShippedNotInvoiced" />
		<property name="qtyToAsmToOrderBase" />
		<property name="qtyToAssembleToOrder" />
		<property name="qtyToAssign" />
		<property name="qtyToInvoice" />
		<property name="qtyToInvoiceBase" />
		<property name="qtyToShip" />
		<property name="qtyToShipBase" />
		<property name="quantity" />
		<property name="quantityBase" />
		<property name="quantityInvoiced" />
		<property name="quantityShipped" />
		<property name="recalculateInvoiceDisc" />
		<property name="requestedDeliveryDate" transform="replace(0001-01-01, )" />
		<property name="reserve" />
		<property name="reservedQtyBase" />
		<property name="reservedQuantity" />
		<property name="responsibilityCenter" />
		<property name="retQtyRcdNotInvdBase" />
		<property name="returnQtyRcdNotInvd" />
		<property name="returnQtyReceived" />
		<property name="returnQtyReceivedBase" />
		<property name="returnQtyToReceive" />
		<property name="returnQtyToReceiveBase" />
		<property name="returnRcdNotInvd" />
		<property name="returnRcdNotInvdLcy" />
		<property name="returnReasonCode" />
		<property name="returnReceiptLineNumber" />
		<property name="returnReceiptNumber" />
		<property name="returnsDeferralStartDate" transform="replace(0001-01-01, )" />
		<property name="sellToCustomerNumber" />
		<property name="shipmentDate" transform="replace(0001-01-01, )" />
		<property name="shipmentLineNumber" />
		<property name="shipmentNumber" />
		<property name="shippedNotInvLcyNoVat" />
		<property name="shippedNotInvoiced" />
		<property name="shippedNotInvoicedLcy" />
		<property name="shippingAgentCode" />
		<property name="shippingAgentServiceCode" />
		<property name="shippingTime" />
		<property name="shortcutDimension1Code" />
		<property name="shortcutDimension2Code" />
		<property name="specialOrder" />
		<property name="specialOrderPurchaseNumber" />
		<property name="specialOrderPurchLineNumber" />
		<property name="substitutionAvailable" />
		<property name="subtype" />
		<property name="systemCreatedEntry" />
		<property name="taxAreaCode" />
		<property name="taxCategory" />
		<property name="taxGroupCode" />
		<property name="taxLiable" />
		<property name="transactionSpecification" />
		<property name="transactionType" />
		<property name="transportMethod" />
		<property name="type" />
		<property name="unitCost" />
		<property name="unitCostLcy" />
		<property name="unitOfMeasure" />
		<property name="unitOfMeasureCode" />
		<property name="unitOfMeasureCrossRef" />
		<property name="unitPrice" />
		<property name="unitsPerParcel" />
		<property name="unitVolume" />
		<property name="useDuplicationList" />
		<property name="variantCode" />
		<property name="vatBaseAmount" />
		<property name="vatBusPostingGroup" />
		<property name="vatCalculationType" />
		<property name="vatClauseCode" />
		<property name="vatDifference" />
		<property name="vatIdentifier" />
		<property name="vatPercent" />
		<property name="vatProdPostingGroup" />
		<property name="whseOutstandingQty" />
		<property name="whseOutstandingQtyBase" />
		<property name="workTypeCode" />
	</properties>
	</query>

Salesdocuments	<query entity="salesDocuments">
	<properties>
		<property name="number" />
		<property name="documentType" />
		<property name="sellToCustomerName" />
		<property name="yourReference" />
		<property name="id" />
		<property name="allowLineDisc" />
		<property name="amount" />
		<property name="amountIncludingVAT" />
		<property name="amountShippedNotInvoiced" />
		<property name="amountShippedNotInvoicedInclVat" />
		<property name="appliesToDocNumber" />
		<property name="appliesToDocType" />
		<property name="appliesToId" />
		<property name="area" />
		<property name="assignedUserId" />
		<property name="balAccountNumber" />
		<property name="balAccountType" />
		<property name="billToAddress" />
		<property name="billToAddress2" />
		<property name="billToCity" />
		<property name="billToContact" />
		<property name="billToContactNumber" />
		<property name="billToCountryRegionCode" />
		<property name="billToCounty" />
		<property name="billToCustomerNumber" />
		<property name="billToCustomerTemplateCode" />
		<property name="billToIcPartnerCode" />
		<property name="billToName" />
		<property name="billToName2" />
		<property name="billToPostCode" />
		<property name="campaignNumber" />
		<property name="combineShipments" />
		<property name="comment" />
		<property name="completelyShipped" />
		<property name="compressPrepayment" />
		<property name="correction" />
		<property name="currencyCode" />
		<property name="currencyFactor" />
		<property name="customerDiscGroup" />
		<property name="customerPostingGroup" />
		<property name="customerPriceGroup" />
		<property name="Date_Filter" />
		<property name="dimensionSetId" />
		<property name="directDebitMandateId" />
		<property name="docNumberOccurrence" />
		<property name="documentDate" transform="replace(0001-01-01, )" />
		<property name="documentType" />
		<property name="dueDate" transform="replace(0001-01-01, )" />
		<property name="eu3PartyTrade" />
		<property name="exitPoint" />
		<property name="externalDocumentNumber" />
		<property name="genBusPostingGroup" />
		<property name="getShipmentUsed" />
		<property name="icDirection" />
		<property name="icStatus" />
		<property name="incomingDocumentEntryNumber" />
		<property name="invoice" />
		<property name="invoiceDiscCode" />
		<property name="invoiceDiscountAmount" />
		<property name="invoiceDiscountCalculation" />
		<property name="invoiceDiscountValue" />
		<property name="jobQueueEntryId" />
		<property name="jobQueueStatus" />
		<property name="languageCode" />
		<property name="lastPostingNumber" />
		<property name="lastPremtCrMemoNumber" />
		<property name="lastPrepaymentNumber" />
		<property name="lastReturnReceiptNumber" />
		<property name="lastShippingNumber" />
		<property name="lateOrderShipping" />
		<property name="locationCode" />
		<property name="locationFilter" />
		<property name="numberOfArchivedVersions" />
		<property name="numberPrinted" />
		<property name="numberSeries" />
		<property name="onHold" />
		<property name="opportunityNumber" />
		<property name="orderClass" />
		<property name="orderDate" transform="replace(0001-01-01, )" />
		<property name="outboundWhseHandlingTime" />
		<property name="packageTrackingNumber" />
		<property name="paymentDiscountPercent" />
		<property name="paymentMethodCode" />
		<property name="paymentServiceSetId" />
		<property name="paymentTermsCode" />
		<property name="pmtDiscountDate" transform="replace(0001-01-01, )" />
		<property name="postingDate" transform="replace(0001-01-01, )" />
		<property name="postingDescription" />
		<property name="postingFromWhseRef" />
		<property name="postingNumber" />
		<property name="postingNumberSeries" />
		<property name="premptCrMemoNumber" />
		<property name="prepaymentDueDate" transform="replace(0001-01-01, )" />
		<property name="prepaymentNumber" />
		<property name="prepaymentNumberSeries" />
		<property name="prepaymentPercent" />
		<property name="prepmtCrMemoNumberSeries" />
		<property name="prepmtPaymentDiscountPercent" />
		<property name="prepmtPaymentTermsCode" />
		<property name="prepmtPmtDiscountDate" transform="replace(0001-01-01, )" />
		<property name="prepmtPostingDescription" />
		<property name="pricesIncludingVat" />
		<property name="printPostedDocuments" />
		<property name="promisedDeliveryDate" transform="replace(0001-01-01, )" />
		<property name="quoteAccepted" />
		<property name="quoteAcceptedDate" transform="replace(0001-01-01, )" />
		<property name="quoteNumber" />
		<property name="quoteSentToCustomer" />
		<property name="quoteValidUntilDate" transform="replace(0001-01-01, )" />
		<property name="reasonCode" />
		<property name="recalculateInvoiceDisc" />
		<property name="receive" />
		<property name="requestedDeliveryDate" transform="replace(0001-01-01, )" />
		<property name="reserve" />
		<property name="responsibilityCenter" />
		<property name="returnReceiptNumber" />
		<property name="returnReceiptNumberSeries" />
		<property name="salespersonCode" />
		<property name="sellToAddress" />
		<property name="sellToAddress2" />
		<property name="sellToCity" />
		<property name="sellToContact" />
		<property name="sellToContactNumber" />
		<property name="sellToCountryRegionCode" />
		<property name="sellToCounty" />
		<property name="sellToCustomerName2" />
		<property name="sellToCustomerNumber" />
		<property name="sellToCustomerTemplateCode" />
		<property name="sellToIcPartnerCode" />
		<property name="sellToPostCode" />
		<property name="sendIcDocument" />
		<property name="ship" />
		<property name="shipmentDate" transform="replace(0001-01-01, )" />
		<property name="shipmentMethodCode" />
		<property name="shipped" />
		<property name="shippedNotInvoiced" />
		<property name="shippingAdvice" />
		<property name="shippingAgentCode" />
		<property name="shippingAgentServiceCode" />
		<property name="shippingNumber" />
		<property name="shippingNumberSeries" />
		<property name="shippingTime" />
		<property name="shipToAddress" />
		<property name="shipToAddress2" />
		<property name="shipToCity" />
		<property name="shipToCode" />
		<property name="shipToContact" />
		<property name="shipToCountryRegionCode" />
		<property name="shipToCounty" />
		<property name="shipToName" />
		<property name="shipToName2" />
		<property name="shipToPostCode" />
		<property name="shortcutDimension1Code" />
		<property name="shortcutDimension2Code" />
		<property name="status" />
		<property name="taxAreaCode" />
		<property name="taxLiable" />
		<property name="transactionSpecification" />
		<property name="transactionType" />
		<property name="transportMethod" />
		<property name="vatBaseDiscountPercent" />
		<property name="vatBusPostingGroup" />
		<property name="vatCountryRegionCode" />
		<property name="vatRegistrationNumber" />
		<property name="workDescription" />

		<extradata name="DocumentUsageCode" value="S." />
	</properties>
	</query>

Salesinvoice posted lines	<query entity="Posted_SalesInvoiceLine" extension="DocuBuilder">
	<properties>
		<property name="no" />
		<property name="lineNo" />
		<property name="allowInvoiceDisc" />
		<property name="applFromItemEntry" />
		<property name="applToItemEntry" />
		<property name="crossReferenceNo" />
		<property name="deferralCode" />
		<property name="description" />
		<property name="documentNo" />
		<property name="icPartnerCode" />
		<property name="id" />
		<property name="invDiscountAmount" />
		<property name="itemReferenceNo" />
		<property name="jobNo" />
		<property name="jobTaskNo" />
		<property name="lineAmount" />
		<property name="lineAmountIncludingVat" />
		<property name="lineDiscountAmount" />
		<property name="lineDiscountPercent" />
		<property name="lineNo" />
		<property name="lineVatAmount" />
		<property name="no" />
		<property name="postingDate" transform="replace(0001-01-01, )" />
		<property name="quantity" />
		<property name="returnReasonCode" />
		<property name="shipmentDate" transform="replace(0001-01-01, )" />
		<property name="shortcutDimension1Code" />
		<property name="shortcutDimension2Code" />
		<property name="taxAreaCode" />
		<property name="taxGroupCode" />
		<property name="taxLiable" />
		<property name="type" />
		<property name="unitCostLcy" />
		<property name="unitOfMeasure" />
		<property name="unitOfMeasureCode" />
		<property name="unitPrice" />
		<property name="variantCode" />
		<property name="vatPercent" />
	</properties>
	</query>

Salesinvoices posted	<query entity="Posted_SalesInvoice" extension="DocuBuilder">
	<properties>
		<property name="no" />
		<property name="sellToCustomerName" />
		<property name="yourReference" />
		<property name="area" />
		<property name="id" />
		<property name="billToAddress" />
		<property name="billToAddress2" />
		<property name="billToCity" />
		<property name="billToContact" />
		<property name="billToContactNo" />
		<property name="billToCountryRegionCode" />
		<property name="billToCounty" />
		<property name="billToCustomerNo" />
		<property name="billToName" />
		<property name="billToPostCode" />
		<property name="cancelled" />
		<property name="closed" />
		<property name="corrective" />
		<property name="currencyCode" />
		<property name="directDebitMandateId" />
		<property name="documentDate" transform="replace(0001-01-01, )" />
		<property name="documentExchangeStatus" />
		<property name="dueDate" transform="replace(0001-01-01, )" />
		<property name="eu3PartyTrade" />
		<property name="exitPoint" />
		<property name="externalDocumentNo" />
		<property name="locationCode" />
		<property name="noPrinted" />
		<property name="orderDate" transform="replace(0001-01-01, )" />
		<property name="orderNo" />
		<property name="packageTrackingNo" />
		<property name="paymentDiscountPercent" />
		<property name="paymentMethodCode" />
		<property name="paymentTermsCode" />
		<property name="pmtDiscountDate" transform="replace(0001-01-01, )" />
		<property name="postingDate" transform="replace(0001-01-01, )" />
		<property name="postingDescription" />
		<property name="preAssignedNo" />
		<property name="prepaymentOrderNo" />
		<property name="quoteNo" />
		<property name="responsibilityCenter" />
		<property name="salespersonCode" />
		<property name="selectedPayments" />
		<property name="sellToAddress" />
		<property name="sellToAddress2" />
		<property name="sellToCity" />
		<property name="sellToContact" />
		<property name="sellToContactNo" />
		<property name="sellToCountryRegionCode" />
		<property name="sellToCounty" />
		<property name="sellToCustomerNo" />
		<property name="sellToPostCode" />
		<property name="shipmentDate" transform="replace(0001-01-01, )" />
		<property name="shipmentMethodCode" />
		<property name="shippingAgentCode" />
		<property name="shipToAddress" />
		<property name="shipToAddress2" />
		<property name="shipToCity" />
		<property name="shipToCode" />
		<property name="shipToContact" />
		<property name="shipToCountryRegionCode" />
		<property name="shipToCounty" />
		<property name="shipToName" />
		<property name="shipToPostCode" />
		<property name="shortcutDimension1Code" />
		<property name="shortcutDimension2Code" />
		<property name="taxAreaCode" />
		<property name="taxLiable" />
		<property name="transactionSpecification" />
		<property name="transactionType" />
		<property name="transportMethod" />
		<property name="workDescription" />

		<extradata name="DocType" value="Invoice" />
		<extradata name="DocumentUsageCode" value="S." />
	</properties>
	</query>

SalesPersons and purchasers	<query entity="SalesPurchasersPerson" extension="DocuBuilder">
	<properties>
		<property name="Code" />
		<property name="Commission_Percent" />
		<property name="Name" />
		<property name="Phone_No" />
		<property name="Privacy_Blocked" />
	</properties>
	</query>

Salesshipment posted lines	<query entity="Posted_SalesShipmentLine" extension="DocuBuilder">
	<properties>
		<property name="Appl_to_Item_Entry" />
		<property name="Bin_Code" />
		<property name="Correction" />
		<property name="Cross_Reference_No" />
		<property name="Description" />
		<property name="Document_No" />
		<property name="FilteredTypeField" />
		<property name="IDYS_Quantity_Sent" />
		<property name="IDYS_Quantity_To_Send" />
		<property name="Item_Reference_No" />
		<property name="Job_No" />
		<property name="Job_Task_No" />
		<property name="Line_No" />
		<property name="Location_Code" />
		<property name="No" />
		<property name="Outbound_Whse_Handling_Time" />
		<property name="Planned_Delivery_Date" transform="replace(0001-01-01, )" />
		<property name="Planned_Shipment_Date" transform="replace(0001-01-01, )" />
		<property name="Promised_Delivery_Date" transform="replace(0001-01-01, )" />
		<property name="Qty_Shipped_Not_Invoiced" />
		<property name="Quantity" />
		<property name="Quantity_Invoiced" />
		<property name="Requested_Delivery_Date" transform="replace(0001-01-01, )" />
		<property name="Return_Reason_Code" />
		<property name="Shipment_Date" transform="replace(0001-01-01, )" />
		<property name="Shipping_Time" />
		<property name="Shortcut_Dimension_1_Code" />
		<property name="Shortcut_Dimension_2_Code" />
		<property name="ShortcutDimCode_x005B_3_x005D_" />
		<property name="ShortcutDimCode_x005B_4_x005D_" />
		<property name="ShortcutDimCode_x005B_5_x005D_" />
		<property name="ShortcutDimCode_x005B_6_x005D_" />
		<property name="ShortcutDimCode_x005B_7_x005D_" />
		<property name="ShortcutDimCode_x005B_8_x005D_" />
		<property name="Type" />
		<property name="Unit_of_Measure" />
		<property name="Unit_of_Measure_Code" />
		<property name="Variant_Code" />
	</properties>
	</query>

Salesshipments posted	<query entity="Posted_SalesShipment" extension="DocuBuilder">
	<properties>
		<property name="No" />
		<property name="Sell_to_Customer_Name" />
		<property name="Bill_to_Address" />
		<property name="Bill_to_Address_2" />
		<property name="Bill_to_City" />
		<property name="Bill_to_Contact" />
		<property name="Bill_to_Contact_No" />
		<property name="Bill_to_Country_Region_Code" />
		<property name="Bill_to_County" />
		<property name="Bill_to_Customer_No" />
		<property name="Bill_to_Name" />
		<property name="Bill_to_Post_Code" />
		<property name="BillToContactEmail" />
		<property name="BillToContactMobilePhoneNo" />
		<property name="BillToContactPhoneNo" />
		<property name="Document_Date" transform="replace(0001-01-01, )" />
		<property name="External_Document_No" />
		<property name="GetWorkDescription" />
		<property name="IDYS_Account_No" />
		<property name="IDYS_Cost_Center" />
		<property name="IDYS_E_Mail_Type" />
		<property name="Location_Code" />
		<property name="No_Printed" />
		<property name="Order_No" />
		<property name="Outbound_Whse_Handling_Time" />
		<property name="Package_Tracking_No" />
		<property name="Posting_Date" transform="replace(0001-01-01, )" />
		<property name="Promised_Delivery_Date" transform="replace(0001-01-01, )" />
		<property name="Quote_No" />
		<property name="Requested_Delivery_Date" transform="replace(0001-01-01, )" />
		<property name="Responsibility_Center" />
		<property name="Salesperson_Code" />
		<property name="Sell_to_Address" />
		<property name="Sell_to_Address_2" />
		<property name="Sell_to_City" />
		<property name="Sell_to_Contact" />
		<property name="Sell_to_Contact_No" />
		<property name="Sell_to_Country_Region_Code" />
		<property name="Sell_to_County" />
		<property name="Sell_to_Post_Code" />
		<property name="SellToEmail" />
		<property name="SellToMobilePhoneNo" />
		<property name="SellToPhoneNo" />
		<property name="Ship_to_Address" />
		<property name="Ship_to_Address_2" />
		<property name="Ship_to_City" />
		<property name="Ship_to_Code" />
		<property name="Ship_to_Contact" />
		<property name="Ship_to_Country_Region_Code" />
		<property name="Ship_to_County" />
		<property name="Ship_to_Name" />
		<property name="Ship_to_Post_Code" />
		<property name="Shipment_Date" transform="replace(0001-01-01, )" />
		<property name="Shipment_Method_Code" />
		<property name="Shipping_Agent_Code" />
		<property name="Shipping_Agent_Service_Code" />
		<property name="Shipping_Time" />
		<property name="Shortcut_Dimension_1_Code" />
		<property name="Shortcut_Dimension_2_Code" />

		<extradata name="DocType" value="Shipment" />
		<extradata name="DocumentUsageCode" value="S." />
	</properties>
	</query>

Salesshipments_ext posted	<query entity="Ext_Posted_SalesShipments" extension="DocuBuilder">
	<properties>
		<property name="dimensionSetId" />
		<property name="documentStatus" />
		<property name="documentUrl" />
		<property name="id" />
		<property name="no" />
	</properties>
	</query>

Shipment methods	<query entity="shipmentMethod">
	<properties>
		<property name="id" />
		<property name="code" />
		<property name="displayName" />
		<property name="lastModifiedDateTime" />
	</properties>
	</query>

Vendors	<query entity="Vendor" extension="DocuBuilder">
	<properties>
		<property name="No" />
		<property name="Name" />
		<property name="Name_2" />
		<property name="Address" />
		<property name="Address_2" />
		<property name="APC_Address_Purpose" />
		<property name="APC_Address_Type" />
		<property name="APC_House_Number" />
		<property name="APC_House_Number_Addition" />
		<property name="APC_Municipality" />
		<property name="APC_Province" />
		<property name="APC_Street_Name" />
		<property name="Application_Method" />
		<property name="Balance_Due_LCY" />
		<property name="Balance_LCY" />
		<property name="Base_Calendar_Code" />
		<property name="Block_Payment_Tolerance" />
		<property name="Blocked" />
		<property name="Cash_Flow_Payment_Terms_Code" />
		<property name="City" />
		<property name="Control16" />
		<property name="Country_Region_Code" />
		<property name="County" />
		<property name="Creditor_No" />
		<property name="Currency_Code" />
		<property name="Currency_Filter" />
		<property name="Customized_Calendar" />
		<property name="Date_Filter" />
		<property name="Disable_Search_by_Name" />
		<property name="Document_Sending_Profile" />
		<property name="DozDocumentUrl" />
		<property name="E_Mail" />
		<property name="EORI_Number" />
		<property name="Fax_No" />
		<property name="Gen_Bus_Posting_Group" />
		<property name="GLN" />
		<property name="Global_Dimension_1_Filter" />
		<property name="Global_Dimension_2_Filter" />
		<property name="Home_Page" />
		<property name="IC_Partner_Code" />
		<property name="Invoice_Disc_Code" />
		<property name="Language_Code" />
		<property name="Last_Date_Modified" />
		<property name="Lead_Time_Calculation" />
		<property name="Location_Code" />
		<property name="MobilePhoneNo" />
		<property name="Our_Account_No" />
		<property name="Over_Receipt_Code" />
		<property name="Partner_Type" />
		<property name="Pay_to_Vendor_No" />
		<property name="Payment_Method_Code" />
		<property name="Payment_Terms_Code" />
		<property name="Phone_No" />
		<property name="Post_Code" />
		<property name="Preferred_Bank_Account_Code" />
		<property name="Prepayment_Percent" />
		<property name="Price_Calculation_Method" />
		<property name="Prices_Including_VAT" />
		<property name="Primary_Contact_No" />
		<property name="Priority" />
		<property name="Privacy_Blocked" />
		<property name="Purchaser_Code" />
		<property name="Responsibility_Center" />
		<property name="Search_Name" />
		<property name="Shipment_Method_Code" />
		<property name="ShowMap" />
		<property name="Tax_Area_Code" />
		<property name="Tax_Liable" />
		<property name="Transaction_Mode_Code" />
		<property name="VAT_Bus_Posting_Group" />
		<property name="VAT_Registration_No" />
		<property name="Vendor_Posting_Group" />

		<extradata name="DocumentSourceNo" value="{VendorNo}" />
	</properties>
	</query>

Versions Compared

Old Version 1

New Version Current

Key

Web services installed by the DocuBuilder App

Standard Business Central API

...

Web services used in the data connectors of DocuBuilder

Web service fields used in DocuBuilder's data connectors

Company information

Contacts

Countries and Regions

Customers

Document Emails

Employees

Invoice reminder lines

Invoice reminders

Job

Job tasks

Locations

Payment methods

Payment terms

Purchasedocument lines

Purchasedocuments

PurchaseOrders_ext

Salescreditmemo posted lines

Salescreditmemos posted

Salesdocument lines

Salesdocuments

Salesinvoice posted lines

Salesinvoices posted

SalesPersons and purchasers

Salesshipment posted lines

Salesshipments posted

Salesshipments_ext posted

Shipment methods

Vendors