Business Central data in DocuBuilder

DocuBuilder retrieves its data from Business Central via:

  1. Business Central web servicesAfter the installation of the DocuBuilder App in Business Central, a large number of web services were added to Business Central.
    Most 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.

  2. Standard API from Business Central.
    See: API (v2.0) for Dynamics 365 Business Central - Business Central

Web services installed by the DocuBuilder App

After installing the DocuBuilder App in Business Central, the following web services were added.

Object
type

Object-id

Objectnaam

Business Central
Servicenaam

DocuBuilder
DataConnector

Object
type

Object-id

Objectnaam

Business Central
Servicenaam

DocuBuilder
DataConnector

Pagina

70412550

DozBlanketPurchaseOrders

DocuBuilder_DocuBuilder_BlanketPurchaseOrders

Not yet in use

Pagina

70412551

DozBlanketSalesOrders

DocuBuilder_DocuBuilder_BlanketSalesOrders

Not yet in use

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

Not yet in use

Pagina

70412530

DozEmployees

DocuBuilder_DocuBuilder_Ext_Employees

Not yet in use

Pagina

70412549

DozReminders

DocuBuilder_DocuBuilder_Ext_InvoiceReminders

Not yet in use

Pagina

70412552

DozPostedPurchaseCreditMemos

DocuBuilder_DocuBuilder_Ext_Posted_PurchaseCreditMemos

Not yet in use

Pagina

70412548

DozPostedSalesShipments

DocuBuilder_DocuBuilder_Ext_Posted_SalesShipments

Salesshipments_ext posted

Pagina

70412536

DozVendors

DocuBuilder_DocuBuilder_Ext_Vendors

Not yet in use

Pagina

435

Regels

DocuBuilder_DocuBuilder_InvoiceReminderLines

Not yet in use

Pagina

434

Aanmaning

DocuBuilder_DocuBuilder_InvoiceReminders

Not yet in use

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

Not yet in use

Pagina

147

Geboekte inkoopcreditnota's

DocuBuilder_DocuBuilder_Posted_PurchaseCreditMemos

Not yet in use

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

Not yet in use

Pagina

70412531

DozPurchaseInvoices

DocuBuilder_DocuBuilder_PurchaseInvoices

Not yet in use

Pagina

70412542

DozPurchaseOrders

DocuBuilder_DocuBuilder_PurchaseOrders

PurchaseOrders_ext

Pagina

70412543

DozPurchaseQuotes

DocuBuilder_DocuBuilder_PurchaseQuotes

Not yet in use

Pagina

70412553

DozPurchaseReturnOrders

DocuBuilder_DocuBuilder_PurchaseReturnOrders

Not yet in use

Pagina

70412532

DozSalesCreditMemos

DocuBuilder_DocuBuilder_SalesCreditMemos

Not yet in use

Pagina

70412533

DozSalesInvoices

DocuBuilder_DocuBuilder_SalesInvoices

Not yet in use

Pagina

70412534

DozSalesOrders

DocuBuilder_DocuBuilder_SalesOrders

Not yet in use

Pagina

14

Verkopers/inkopers

DocuBuilder_DocuBuilder_SalesPurchasersPersons

SalesPersons and purchasers

Pagina

70412535

DozSalesQuotes

DocuBuilder_DocuBuilder_SalesQuotes

Not yet in use

Pagina

70412554

DozSalesReturnOrders

DocuBuilder_DocuBuilder_SalesReturnOrders

Not yet in use

Pagina

26

Leverancierskaart

DocuBuilder_DocuBuilder_Vendors

Vendors

Standard Business Central API

This is the standard REST API that DocuBuilder uses to retrieve data from Business Central.
For this, see: API (v2.0) for Dynamics 365 Business Central - Business Central
Via the DocuBuilder Settings → Microsoft Business Central → Settings → [Download queries], all fields can be retrieved in the file 'BusinessCentralQueries, so that they can be added to the DocuBuilder DataConnector.

Web services used in the data connectors of DocuBuilder

DocuBuilder
DataConnector

Business Cental
Webservice / API entity

Business Central
Type Page of API

Explanation

DocuBuilder
DataConnector

Business Cental
Webservice / API entity

Business Central
Type Page of API

Explanation

Company information

DocuBuilder_DocuBuilder_Companies

BC page - 1

Own company

Contacts

DocuBuilder_DocuBuilder_Contacts

BC custom page

Contactn persons

Countries and Regions

countryRegion

standaard API

Country data

Customers

DocuBuilder_DocuBuilder_Customers

BC page - 21

Customers

Document Emails

DocuBuilder_DocuBuilder_DocumentLayouts

BC page - 9657

Email settings per customer

Employees

DocuBuilder_DocuBuilder_Employees

BC page - 5200

Employees

Invoice reminder lines

DocuBuilder_DocuBuilder_InvoiceReminderLines

BC page - 435

Payment reminder rules

Invoice reminders

DocuBuilder_DocuBuilder_InvoiceReminders

BC page - 434

Payment Reminders

Job

DocuBuilder_DocuBuilder_Jobs

BC custom page

Projects

Job tasks

DocuBuilder_DocuBuilder_JobTasks

BC custom page

Project tasks

Locations

DocuBuilder_DocuBuilder_Locations

PB page - 5703

Locations of the organisations

Payment methods

paymentMethod 

standaard API

Payment methods

Payment terms

paymentTerm

standaard API

Payment Terms

Purchasedocument lines

purchaseDocumentLines

BC standaard  page

Purchasing: (framework) contract / invoice / order / return order / credit invoice - rules

Purchasedocuments

purchaseDocuments

BC standaard  page

Purchasing: (framework) contracts / invoices / orders / return orders / credit invoices

PurchaseOrders_ext

DocuBuilder_DocuBuilder_PurchaseOrders

BC custom page

Updating purchase orders from DocuFlow

Salescreditmemo posted lines

DocuBuilder_DocuBuilder_Posted_SalesCreditMemoLines

BC custom page

Booked sales credit note lines

Salescreditmemos posted

DocuBuilder_DocuBuilder_Posted_SalesCreditMemos

BC custom page

Booked sales credit notes

Salesdocument lines

salesDocumentLines

BC standaard  page

Sales: (framework) contract / invoice / quotation / order / return order / credit invoice - rules

Salesdocuments

salesDocuments

BC standaard  page

Sales: (framework) contracts / invoices / quotations / orders / return orders / credit invoices

Salesinvoice posted lines

DocuBuilder_DocuBuilder_Posted_SalesShipmentLines

BC custom page

Booked sales invoice lines

Salesinvoices posted

DocuBuilder_DocuBuilder_Posted_SalesInvoices

BC custom page

Sales invoices booked

SalesPersons and purchasers

DocuBuilder_DocuBuilder_SalesPurchasersPersons

BC page - 14

Contact person for sales and/or purchasing

Salesshipment posted lines

DocuBuilder_DocuBuilder_Posted_SalesShipmentLines

BC page - 131

Packing slip (booked sales shipment) rules

Salesshipments posted

DocuBuilder_DocuBuilder_Posted_SalesShipments

BC page - 130

Packing slips (booked sales shipments)

Salesshipments_ext posted

DocuBuilder_DocuBuilder_Ext_Posted_SalesShipments

BC custom page

Update packing slips (booked sales shipments) from DocuFlow

Shipment methods

shipmentMethod

standaard API

Shipping Methods

Vendors

DocuBuilder_DocuBuilder_Vendors

BC page - 26

Suppliers

Web service fields used in DocuBuilder's data connectors

DocuBuilder
DataConnector

Business Central
DataSource

Business Central
fields

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>