Business Central gegevens in DocuBuilder

DocuBuilder haalt haar gegevens uit Business Central op via:

Business Central webservices
Na de installatie van de DocuBuilder App in Business Central zijn er een groot aantal webservices toegevoegd aan 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 hiervoor: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/

Webservices geïnstalleerd door de DocuBuilder App

Na de installatie van de DocuBuilder App in Business Central zijn de onderstaande webservices toegevoegd.

Object type	Object-id	Objectnaam	Business Central Servicenaam	DocuBuilder DataConnector
Pagina	70412550	DozBlanketPurchaseOrders	DocuBuilder_DocuBuilder_BlanketPurchaseOrders	Nog niet in gebruik
Pagina	70412551	DozBlanketSalesOrders	DocuBuilder_DocuBuilder_BlanketSalesOrders	Nog niet in gebruik
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 in gebruik
Pagina	70412530	DozEmployees	DocuBuilder_DocuBuilder_Ext_Employees	Nog niet in gebruik
Pagina	70412549	DozReminders	DocuBuilder_DocuBuilder_Ext_InvoiceReminders	Nog niet in gebruik
Pagina	70412552	DozPostedPurchaseCreditMemos	DocuBuilder_DocuBuilder_Ext_Posted_PurchaseCreditMemos	Nog niet in gebruik
Pagina	70412548	DozPostedSalesShipments	DocuBuilder_DocuBuilder_Ext_Posted_SalesShipments	Salesshipments_ext posted
Pagina	70412536	DozVendors	DocuBuilder_DocuBuilder_Ext_Vendors	Nog niet in gebruik
Pagina	435	Regels	DocuBuilder_DocuBuilder_InvoiceReminderLines	Nog niet in gebruik
Pagina	434	Aanmaning	DocuBuilder_DocuBuilder_InvoiceReminders	Nog niet in gebruik
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 in gebruik
Pagina	147	Geboekte inkoopcreditnota's	DocuBuilder_DocuBuilder_Posted_PurchaseCreditMemos	Nog niet in gebruik
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 in gebruik
Pagina	70412531	DozPurchaseInvoices	DocuBuilder_DocuBuilder_PurchaseInvoices	Nog niet in gebruik
Pagina	70412542	DozPurchaseOrders	DocuBuilder_DocuBuilder_PurchaseOrders	PurchaseOrders_ext
Pagina	70412543	DozPurchaseQuotes	DocuBuilder_DocuBuilder_PurchaseQuotes	Nog niet in gebruik
Pagina	70412553	DozPurchaseReturnOrders	DocuBuilder_DocuBuilder_PurchaseReturnOrders	Nog niet in gebruik
Pagina	70412532	DozSalesCreditMemos	DocuBuilder_DocuBuilder_SalesCreditMemos	Nog niet in gebruik
Pagina	70412533	DozSalesInvoices	DocuBuilder_DocuBuilder_SalesInvoices	Nog niet in gebruik
Pagina	70412534	DozSalesOrders	DocuBuilder_DocuBuilder_SalesOrders	Nog niet in gebruik
Pagina	14	Verkopers/inkopers	DocuBuilder_DocuBuilder_SalesPurchasersPersons	SalesPersons and purchasers
Pagina	70412535	DozSalesQuotes	DocuBuilder_DocuBuilder_SalesQuotes	Nog niet in gebruik
Pagina	70412554	DozSalesReturnOrders	DocuBuilder_DocuBuilder_SalesReturnOrders	Nog niet in gebruik
Pagina	26	Leverancierskaart	DocuBuilder_DocuBuilder_Vendors	Vendors

Standaard Business Central API

Dit is de standaard REST API waarmee DocuBuilder gegevens uit Business Central kan ophalen.
Zie hiervoor: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/
Via de DocuBuilder Settings → Microsoft Business Central → Instellingen → [Download queries] kunnen alle velden worden opgehaald in het bestand 'BusinessCentralQueries, zodat deze aan de DocuBuilder DataConnector kunnen worden toegevoegd.

Gebruikte webservices in de dataconnectoren van DocuBuilder

DocuBuilder DataConnector	Business Cental Webservice / API entiteit	Business Central Type Page of API	Toelichting
Company information	DocuBuilder_DocuBuilder_Companies	BC page - 1	Eigen organisatie
Contacts	DocuBuilder_DocuBuilder_Contacts	BC custom page	Contactpersonen
Countries and Regions	countryRegion	standaard API	Landgegevens
Customers	DocuBuilder_DocuBuilder_Customers	BC page - 21	Klanten
Document Emails	DocuBuilder_DocuBuilder_DocumentLayouts	BC page - 9657	Email instellingen per klant
Employees	DocuBuilder_DocuBuilder_Employees	BC page - 5200	Medewerkers
Invoice reminder lines	DocuBuilder_DocuBuilder_InvoiceReminderLines	BC page - 435	Betalingsherinnering regels
Invoice reminders	DocuBuilder_DocuBuilder_InvoiceReminders	BC page - 434	Betalingsherinneringen
Job	DocuBuilder_DocuBuilder_Jobs	BC custom page	Projecten
Job tasks	DocuBuilder_DocuBuilder_JobTasks	BC custom page	Project taken
Locations	DocuBuilder_DocuBuilder_Locations	PB page - 5703	Locaties van de organisaties
Payment methods	paymentMethod	standaard API	Betalingsmethoden
Payment terms	paymentTerm	standaard API	Betalingsvoorwaarden
Purchasedocument lines	purchaseDocumentLines	BC standaard page	Inkoop: (raam)contract / factuur / order / retourorder / creditfactuur - regels
Purchasedocuments	purchaseDocuments	BC standaard page	Inkoop: (raam)contracten / facturen / orders / retourorders / creditfacturen
PurchaseOrders_ext	DocuBuilder_DocuBuilder_PurchaseOrders	BC custom page	Bijwerken inkooporders vanuit DocuFlow
Salescreditmemo posted lines	DocuBuilder_DocuBuilder_Posted_SalesCreditMemoLines	BC custom page	Geboekte verkoop creditnota regels
Salescreditmemos posted	DocuBuilder_DocuBuilder_Posted_SalesCreditMemos	BC custom page	Geboekte verkoop creditnota's
Salesdocument lines	salesDocumentLines	BC standaard page	Verkoop: (raam)contract / factuur / offerte / order / retourorder / creditfactuur - regels
Salesdocuments	salesDocuments	BC standaard page	Verkoop: (raam)contracten / facturen / offertes / orders / retourorders / creditfacturen
Salesinvoice posted lines	DocuBuilder_DocuBuilder_Posted_SalesShipmentLines	BC custom page	Geboekte verkoopfactuur regels
Salesinvoices posted	DocuBuilder_DocuBuilder_Posted_SalesInvoices	BC custom page	Geboekte verkoopfacturen
SalesPersons and purchasers	DocuBuilder_DocuBuilder_SalesPurchasersPersons	BC page - 14	Contactpersoon voor verkoop en/of inkoop
Salesshipment posted lines	DocuBuilder_DocuBuilder_Posted_SalesShipmentLines	BC page - 131	Pakbon (geboekte verkoopverzending) regels
Salesshipments posted	DocuBuilder_DocuBuilder_Posted_SalesShipments	BC page - 130	Pakbonnen (geboekte verkoopverzendingen)
Salesshipments_ext posted	DocuBuilder_DocuBuilder_Ext_Posted_SalesShipments	BC custom page	Bijwerken pakbonnen (geboekte verkoopverzendingen) vanuit DocuFlow
Shipment methods	shipmentMethod	standaard API	Verzendmethoden
Vendors	DocuBuilder_DocuBuilder_Vendors	BC page - 26	Leveranciers

Gebruikte webservice velden in de dataconnectoren van DocuBuilder

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>

Business Central gegevens in DocuBuilder

Webservices geïnstalleerd door de DocuBuilder App

Standaard Business Central API

Gebruikte webservices in de dataconnectoren van DocuBuilder

Gebruikte webservice velden in de dataconnectoren van DocuBuilder

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