BillQuery

Provides functionality found in the Find/Advanced Find window to find bills that are to be paid by check. The Find/Advanced Find windows can be reached by clicking the Find button on the main QuickBooks menubar, by selecting Edit->Find, or simply by using the shortcut CTRL-F. Notice that you can use the metaData attribute inside the query tag if you want only a count of the bills that will be returned from the query.
If you know the bill’s transaction ID or reference number, you could use these, or search by transaction date, or search by the date where the bill was last modified. You can search for paid/unpaid bills by using the PaidStatus flag.
If you need additional filters, you can use the entity filter to search for bills from a specific vendor or vendor sub (using the ListIDWithChildren or FullNameWithChildren tags). You can also search for bills entered against a particular account (the APAccountRef specified in the originating BillAdd request). You can specify all subaccounts by using the various *WithChildren tags. For example, to find all bills entered against Checking where you have multiple checking accounts, you would use the ListIDWithChildren or FullNameWithChildren tags inside your AccountFilter tags. You can filter on the RefNumber or RefNumber range. Notice that all of these filters can be used together (ANDed) if desired.
If you want bill line items returned from the query, you must use the IncludeLineItems tag. Notice that you don’t specify line item groups. If line item groups were set up for the line items, the returned line items are automatically segregated by group.
You can get all of the linked transactions such as PurchaseOrders and Credits by using the IncludeLinkedTxns tag. You can get public data extensions (these are custom data whose fields can be displayed in QuickBooks) by supplying the OwnerID tag set to 0. To get private data extensions (custom data not displayable in QuickBooks) you must use the OwnerID tag set to the known GUID value. You must know the GUID value in order to access private data extensions.
To prevent the return of too much data, you can use MaxReturned to limit the total number of bills returned from the query. In addition, you can limit the type of data that is returned for each bill, using IncludeRetElement. Finally, you can specify whether each bill contains line items using the IncludeLineItems, which by default is False (no line item data).

Request

Response

XMLOps

VB.NET

C#

Tag Type Max length Implementation Required

IBillQuery

Provides functionality found in the Find/Advanced Find window to find bills that are to be paid by check. The Find/Advanced Find windows can be reached by clicking the Find button on the main QuickBooks menubar, by selecting Edit->Find, or simply by using the shortcut CTRL-F. Notice that you can use the metaData attribute inside the query tag if you want only a count of the bills that will be returned from the query. If you know the bill’s transaction ID or reference number, you could use these, or search by transaction date, or search by the date where the bill was last modified. You can search for paid/unpaid bills by using the PaidStatus flag. If you need additional filters, you can use the entity filter to search for bills from a specific vendor or vendor sub (using the ListIDWithChildren or FullNameWithChildren tags). You can also search for bills entered against a particular account (the APAccountRef specified in the originating BillAdd request). You can specify all subaccounts by using the various *WithChildren tags. For example, to find all bills entered against Checking where you have multiple checking accounts, you would use the ListIDWithChildren or FullNameWithChildren tags inside your AccountFilter tags. You can filter on the RefNumber or RefNumber range. Notice that all of these filters can be used together (ANDed) if desired. If you want bill line items returned from the query, you must use the IncludeLineItems tag. Notice that you don’t specify line item groups. If line item groups were set up for the line items, the returned line items are automatically segregated by group. You can get all of the linked transactions such as PurchaseOrders and Credits by using the IncludeLinkedTxns tag. You can get public data extensions (these are custom data whose fields can be displayed in QuickBooks) by supplying the OwnerID tag set to 0. To get private data extensions (custom data not displayable in QuickBooks) you must use the OwnerID tag set to the known GUID value. You must know the GUID value in order to access private data extensions. To prevent the return of too much data, you can use MaxReturned to limit the total number of bills returned from the query. In addition, you can limit the type of data that is returned for each bill, using IncludeRetElement. Finally, you can specify whether each bill contains line items using the IncludeLineItems, which by default is False (no line item data).
        

metaData

This is used in a query to cause a count of query objects to be returned. You can specify that the count of query objects is to be returned with the returned objects, or you can specify that only a count and no data is returned. (The default is that no count is returned.) A common use of this feature is to specify a count with no data in order to determine how many objects to expect from the actual query. If you don’t want a query to return a count, either don’t use this feature, or specify the value NoMetaData. If you want only a count, specify the value MetaDataOnly. If you want data and a count, specify MetaDataAndResponseData. You should be aware that the count returned via this setting is not guaranteed to be exact: it could be off slightly due to new object creation or deletions.
 IQBENmetaDataType   4.0 us.png  

iterator

The iterator attribute provided with most query types also allows you to break down query results in smaller and more manageable chunks of data. An iterator results in responses that contain only the specified number of objects. Iterators are only valid for the application that starts them, and they are only valid for the current QuickBooks session.
 IQBENiteratorType   5.0 us.png  

iteratorID

Returned in the response in the first iteration and supplied in subsequent iterations, this identifies which iteration is to be used in the query continuing the iteration. Required because many different iterations may be currently in use.
 IQBUUIDType   5.0 us.png  

ORBillQuery

 IORBillQuery      

TxnIDList

One or more TxnID values. QuickBooks generates a unique TxnID for each transaction that is added to QuickBooks. Notice that you cannot supply the TxnID of a TimeTracking transaction to TransactionQuery requests. If you do, you get an error stating that no such record could be found, even though the transaction is in QuickBooks. This behavior reflects the behavior in the QuicKBooks UI in the Find window.
 IBSTRList      

RefNumberList

A list of one or more RefNumber values. A RefNumber is a string of characters that refers to a transaction and that can be arbitrarily changed by the QuickBooks user. Note (especially relevant to CheckAdd requests): When RefNumber is left blank in an SDK transaction add request, the RefNumber will be left blank in QuickBooks. This behavior is new as of QBFC3. It used to select the next sequential reference number since the last one used by QuickBooks, as though no RefNumber had been provided. This is especially relevant to CheckAdd requests because with the current behavior, you will not know the number until the check is printed.
 IBSTRList      

RefNumberCaseSensitiveList

A list of one or more case sensitive RefNumber values. A RefNumber is a string of characters that refers to a transaction and that can be arbitrarily changed by the QuickBooks user. You should use this case sensitive ref number list rather than the older RefNumber list, because it provides much better performance in certain circumstances. The older refNumber list provided slow performance if the refNumber values contained letters, not just digits. This RefNumberCaseSensitive list, new in SDK 4.0, eliminates this performance hit.
 IBSTRList   4.0  

BillFilter

The IBillFilter group object allows you to search for bills based on when they were created or last modified, which entities or accounts they refer to, their reference numbers, and their paid status.
 IBillFilter      

MaxReturned

Limits the number of objects that a query returns. (To get a count of how many objects could possibly be returned, use the metaData query attribute.) If you include a MaxReturned value, it must be at least 1.
 IQBIntType      

ORDateRangeFilter

 IORDateRangeFilter      

ModifiedDateRangeFilter

Filters according to the dates when transactions were last modified. The ModifiedDateRangeFilter aggregate is not required to contain any elements, but if it is empty, we recommend that you leave it out altogether. Note that the time portion of the FromModifiedDate and ToModifiedDate fields was not supported in qbXML version 1.0 or 1.1. (To filter according to the dates when transactions were deleted, use a TxnDeletedQuery message.)
 IModifiedDateRangeFilter      

FromModifiedDate

Selects objects modified on or after this date. See the note below regarding QBFC usage. For desktop versions of QuickBooks, the FromModifiedDate and ToModifiedDate must be between 1970-01-01 and 2038-01-19T03:14:07 (2038-01-18T19:14:07-08:00 PST). (The time portion of the field was not supported in qbXML version 1.0 or 1.1.) Also, for desktop versions of QuickBooks, if FromModifiedDate includes a date but not a time (for example, if you set FromModifiedDate to 2003-02-14), the time is assumed to be zero (2003-02-14T00:00:00). If you omit FromModifiedDate, it will be set to 1970-01-01T00:00:00 (1969-12-31T16:00:00-08:00 PST). For QBOE, the FromModifiedDate and ToModifiedDate must be between 1900-01-01T00:00:00 and 9999-12-31T00:00:00. If FromModifiedDate includes a date but not a time (for example, if you set FromModifiedDate to 2003-02-14), the time is assumed to be zero (2003-02-14T00:00:00). If you omit FromModifiedDate, it will be set to 1900-01-01T00:00:00. Note: When specifying this in QBFC, you need to supply the parameter asDateOnly, which is a Boolean. If asDateOnly is true, the date value will be represented as a date only (without a time). If asDateOnly is false, the date value will be represented as date and time, padded with zeros if necessary, and set to the beginning of the day if no time is provided. The asDateOnly parameter is especially useful in the ToModifiedDate field of a query: If asDateOnly is set to true in the ToModifiedDate field of a query, then the query includes elements modified up to the end of the day. If asDateOnly is false, the query includes elements modified up to the specified time (or up to the beginning of the day if no time is included).
 IQBDateTimeType      

ToModifiedDate

Selects objects modified on or before this date. See the note below on QBFC usage. For desktop versions of QuickBooks, the ToModifiedDate and FromModifiedDate must be between 01/01/1970 and 2038-01-19T03:14:07 (2038-01-18T19:14:07-08:00 PST). (Note that the time portion of the field was not supported in qbXML version 1.0 or 1.1.) If ToModifiedDate includes a date but not a time (for example, if you set ToModifiedDate to 2003-02-14), the time is assumed to be the end of the day (2003-02-14T23:59:59). If you omit ToModifiedDate altogether, it will be set to 2038-01-19T03:14:07 (2038-01-18T19:14:07-08:00 PST). For QBOE, the ToModifiedDate and FromModifiedDate must be between 01/01/1900 and 9999-12-31T00:00:00. If ToModifiedDate includes a date but not a time (for example, if you set ToModifiedDate to 2003-02-14), the time is assumed to be the end of the day (2003-02-14T23:59:59). If you omit ToModifiedDate altogether, it will be set to 9999-12-31T00:00:00. Note: When specifying this in QBFC, you need to supply the parameter asDateOnly, which is a Boolean. If asDateOnly is true, the date value will be represented as a date only (without a time). If asDateOnly is false, the date value will be represented as date and time, padded with zeros if necessary, and set to the beginning of the day if no time is provided. The asDateOnly parameter is especially useful in the ToModifiedDate field of a query: If asDateOnly is set to true in the ToModifiedDate field of a query, then the query includes elements modified up to the end of the day. If asDateOnly is false, the query includes elements modified up to the specified time (or up to the beginning of the day if no time is included).
 IQBDateTimeType      

TxnDateRangeFilter

Filters according to the original transaction dates.
 ITxnDateRangeFilter      

ORTxnDateRangeFilter

 IORTxnDateRangeFilter     Y

TxnDateFilter

The ITxnDateFilter group object allows you to filter by transaction creation date.
 ITxnDateFilter      

FromTxnDate

Selects transactions created on or after this date. Both FromTxnDate and ToTxnDate must be between 01/01/1901 and 12/31/9999. If you omit FromTxnDate, it will be set to 1970-01-01 (1969-12-31 PST).
 IQBDateType      

ToTxnDate

Selects transactions created on or before this date. Both ToTxnDate and FromTxnDate must be between 01/01/1901 and 12/31/9999. If you omit ToTxnDate, it will be set to 2038-01-19 (2038-01-18 PST).
 IQBDateType      

DateMacro

Refers to the transaction date, not the last modification date. Do not include DateMacro if either FromModifedDate or ToModifiedDate are specified. If a query does not specify DateMacro, FromModifedDate, or ToModifiedDate, it includes all dates. DateMacro values, in alphabetical order, that are new with QBFC3: dmAll, dmdmLastCalendarQuarter, dmdmLastCalendarQuarterToDate, dmdmLastCalendarYear, dmdmLastCalendarYearToDate, dmLastFiscalQuarterToDate, dmLastFiscalYearToDate, dmLastMonthToDate, dmLastWeekToDate, dmNextCalendarQuarter, dmNextCalendarYear, dmNextFiscalQuarter, dmNextFiscalYear, dmNextFourWeeks, dmNextMonth, dmNextWeek, dmThisCalendarQuarter, dmThisCalendarQuarterToDate, dmThisCalendarYear, dm ThisCalendarYearToDate, dmThisFiscalQuarter, dmThisFiscalYear, dmThisMonth, dmThisWeek, dmThisWeekToDate, dmToday, dmYesterday The list given when you click IQBENDateMacroType shows the complete list of valid version 3.0 values.
 IQBENDateMacroType      

EntityFilter

An entity refers to a person on the QuickBooks Customer list, Vendor list, Employee list, or Other Names list. You can use an EntityQuery request to get information about all the entities that are set up in the QuickBooks file. In an ARRefundCreditCard query, this must be a customer/customer job.
 IEntityFilter      

OREntityFilter

 IOREntityFilter     Y

ListIDList

One or more ListID values. Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IBSTRList   2.0  

FullNameList

A list of one or more FullName values. FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IBSTRList      

ListIDWithChildren

Allows you to filter for data that relates to the specified object and its descendants.
 IQBIDType   2.0  

FullNameWithChildren

Allows you to filter for data that relates to the specified object and its descendants. For names that do not have children, FullNameWithChildren is exactly the same as FullName.
 IQBStringType      

AccountFilter

Filters according to the account name or ListID. If the “Use account numbers” preference is enabled in the QuickBooks company file, you can specify an account number (instead of an account name) for FullName and get the account you’re looking for. But if numbers have been used as account names, confusion could arise. For example, if you queried for an account named 2050, and 2050 happened to be the account number of a totally different account, the query would not return what you asked for (the account named 2050), but instead would return the account with the account number 2050. This problem will not happen if the “Use account numbers” preference is turned off in the QuickBooks file, or the account name exactly matches the account number. (In this case, query would return the correct account either way.) To avoid this problem: Do not name an account using a number unless the number exactly matches the account’s account number. If an account name must contain a number that does not match its own account number, have the QuickBooks user change the account’s name slightly, for example to 2050a.
 IAccountFilter      

ORAccountFilter

 IORAccountFilter     Y

ListIDList

One or more ListID values. Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IBSTRList   2.0  

FullNameList

A list of one or more FullName values. FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IBSTRList      

ListIDWithChildren

Allows you to filter for data that relates to the specified object and its descendants.
 IQBIDType   2.0  

FullNameWithChildren

Allows you to filter for data that relates to the specified object and its descendants. For names that do not have children, FullNameWithChildren is exactly the same as FullName.
 IQBStringType      

ORRefNumberFilter

 IORRefNumberFilter      

RefNumberFilter

Filters according to RefNumber.
 IRefNumberFilter      

MatchCriterion

The criterion to match.
 IQBENMatchCriterionType     Y

RefNumber

A string of characters that refers to this transaction and that can be arbitrarily changed by the QuickBooks user. In a BillPaymentCheckAdd request, if you want to set the check number, use RefNumber. Note (especially relevant to CheckAdd requests): When RefNumber is left blank in an SDK transaction add request (that is, or ), the RefNumber will be left blank in QuickBooks. This behavior is new as of QBFC3. It used to select the next sequential reference number since the last one used by QuickBooks, as though no RefNumber had been provided. This is especially relevant to CheckAdd requests because with the current behavior, you will not know the number until the check is printed.
 IQBStringType     Y

RefNumberRangeFilter

Filters according to RefNumber. The filtering code will do a numerical comparison (if FromRefNumber and ToRefNumber only contain digits) or a lexicographical comparison (if either FromRefNumber or ToRefNumber contain any nondigit characters). In the first situation, if you need to query for a RefNumber that is larger than the maximum long integer value of 2147483647, one workaround is to specify a FromRefNumber that is less than or equal to 2147483647 without specifying a ToRefNumber.
 IRefNumberRangeFilter      

FromRefNumber

The first RefNumber in the search range. If FromRefNumber is omitted, the range will begin with first number on the list.
 IQBStringType      

ToRefNumber

The final RefNumber in the search range. If ToRefNumber is omitted, the range will end with last number on the list.
 IQBStringType      

CurrencyFilter

Filters by the specified currency.
 ICurrencyFilter   8.0  

ORCurrencyFilter

 IORCurrencyFilter     Y

ListIDList

One or more ListID values. Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IBSTRList      

FullNameList

A list of one or more FullName values. FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IBSTRList 64 chars    

PaidStatus

Allows you to filter for transactions according to whether or not they are paid.
 IQBENPaidStatusType      

IncludeLineItems

This filter allows you to omit line items from a query response to get a smaller result. The default value is false, so line items are omitted by default. Set IncludeLineItems to true to include line items in the response if you don’t mind getting a larger result.
 IQBBoolType      

IncludeLinkedTxns

If you set IncludeLinkedTxns to true, then the returned object will include a list of all the transactions linked to the queried object. (This list is similar to the History view of a transaction in the user interface, but not identical, as the SDK list contains only linked transactions, not items.) Each linked transaction will be represented by a LinkedTxn aggregate. If no linked transactions exist, no LinkedTxn aggregates will be returned.
 IQBBoolType   2.0  

IncludeRetElementList

You use this if you want to limit the data that will be returned in the response. In this list, you specify the name of each top-level element or aggregate that you want to be returned in the response to the request. You cannot specify fields within an aggregate, for example, you cannot specify a City within an Address: you must specify Address and will get the entire address. The names specified in the list are not parsed, so you must be especially careful to supply valid names, properly cased. No error is returned in the status code if you specify an invalid name. Notice that if you want to return custom data or private data extensions, you must specify the DataExtRet element and you must supply the OwnerID set to either a value of 0 (custom data) or the GUID for the private data.
 IBSTRList 50 chars 4.0  

OwnerIDList

Zero or more OwnerID values. OwnerID refers to the owner of a data extension: If OwnerID is 0, this is a public data extension, also known as a custom field. Custom fields appear in the QuickBooks UI. If OwnerID is a GUID, for example {6B063959-81B0-4622-85D6-F548C8CCB517}, this field is a private data extension defined by an integrated application. Private data extensions do not appear in the QuickBooks UI. Note that OwnerID values are not case-sensitive, meaning that if you enter an OwnerID value with lower-case letters, the value will be saved and returned with upper-case letters. When you share a private data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
 IGUIDList   2.0  
Tag Type Max length Implementation Required

IResponse

Provides functionality found in the Find/Advanced Find window to find bills that are to be paid by check. The Find/Advanced Find windows can be reached by clicking the Find button on the main QuickBooks menubar, by selecting Edit->Find, or simply by using the shortcut CTRL-F. Notice that you can use the metaData attribute inside the query tag if you want only a count of the bills that will be returned from the query. If you know the bill’s transaction ID or reference number, you could use these, or search by transaction date, or search by the date where the bill was last modified. You can search for paid/unpaid bills by using the PaidStatus flag. If you need additional filters, you can use the entity filter to search for bills from a specific vendor or vendor sub (using the ListIDWithChildren or FullNameWithChildren tags). You can also search for bills entered against a particular account (the APAccountRef specified in the originating BillAdd request). You can specify all subaccounts by using the various *WithChildren tags. For example, to find all bills entered against Checking where you have multiple checking accounts, you would use the ListIDWithChildren or FullNameWithChildren tags inside your AccountFilter tags. You can filter on the RefNumber or RefNumber range. Notice that all of these filters can be used together (ANDed) if desired. If you want bill line items returned from the query, you must use the IncludeLineItems tag. Notice that you don’t specify line item groups. If line item groups were set up for the line items, the returned line items are automatically segregated by group. You can get all of the linked transactions such as PurchaseOrders and Credits by using the IncludeLinkedTxns tag. You can get public data extensions (these are custom data whose fields can be displayed in QuickBooks) by supplying the OwnerID tag set to 0. To get private data extensions (custom data not displayable in QuickBooks) you must use the OwnerID tag set to the known GUID value. You must know the GUID value in order to access private data extensions. To prevent the return of too much data, you can use MaxReturned to limit the total number of bills returned from the query. In addition, you can limit the type of data that is returned for each bill, using IncludeRetElement. Finally, you can specify whether each bill contains line items using the IncludeLineItems, which by default is False (no line item data).
        

StatusCode

A number that corresponds to a statusSeverity and statusMessage. Five status codes relate directly to signon messages: 2000, 2010, 2020, 2030, and 2040. For details about these and other statusCode values that can be returned, see the statusCode table on the Error Codes page.
 IQBIntType     Y

StatusSeverity

One of the following values: INFO The request was completed, and the results are consistent with what your application expected. WARNING The request was completed, but the results might not be consistent with what you expected. ERROR The request was not completed. No data will appear in the server’s response after the statusMessage.
 IQBStringType     Y

StatusMessage

A user-readable explanation of the success or error condition that is indicated by the statusCode. For details about the statusMessage values that can be returned, see the “Explanation” column of the statusCode table on the Error Codes page.
 IQBStringType     Y

retCount

The retCount is returned in a query if in the query request you specified the metaData attribute with a value of MetaDataOnly (in which case the retCount is the only data returned in the query response) or MetaDataAndResponseData (the query response contains object data AND the approximate count). The retCount value contains the approximate count of the objects that could be expected to be returned from the query. A common use of this feature is to specify a count with no data in order to determine how many objects to expect from the actual query. You should be aware that the count returned in retCount is not guaranteed to be exact: it could be off slightly due to new object creation or deletions.
 IQBIntType   4.0 us.png Y

iteratorRemainingCount

This attribute is provided in the response in a query using iterators, indicating the number of objects remaining in the iteration. This can help you specify a MaxReturn value tailored to the number of objects still to be iterated through in your query.
 IQBIntType   5.0 us.png Y

iteratorID

Returned in the response in the first iteration and supplied in subsequent iterations, this identifies which iteration is to be used in the query continuing the iteration. Required because many different iterations may be currently in use.
 IQBUUIDType   5.0 us.png Y

Detail

 IBillRetList      

(List

of IBillRet Objects)
        

TxnID

QuickBooks generates a unique TxnID for each transaction that is added to QuickBooks. A TxnID returned from a request can be used to refer to the transaction in subsequent requests. Notice that you cannot supply the TxnID of a TimeTracking transaction to TransactionQueryRq requests. If you do, you get an error stating that no such record could be found, even though the transaction is in QuickBooks. This behavior reflects the behavior in the QuicKBooks UI in the Find window.
 IQBIDType     Y

TimeCreated

Time the object was created.
 IQBDateTimeType     Y

TimeModified

Time the object was last modified.
 IQBDateTimeType     Y

EditSequence

A number that the server generates and assigns to this object. Every time the object is changed, the server will change its EditSequence value. When you try to modify a list object, you must provide its EditSequence. The server compares the EditSequence you provide with the EditSequence in memory to make sure you are dealing with the latest copy of the object. If you are not, the server will reject the request and return an error. Because EditSequence is only used to check whether two objects match, there is no reason to interpret its value.
 IQBStringType 16 chars   Y

TxnNumber

An identifying number for this transaction.
 IQBIntType      

VendorRef

A vendor is any person or company from whom a small business owner buys goods and services. (Banks and tax agencies usually are included on the vendor list.) A company’s vendor list contains information such as account balance and contact information about each vendor. A VendorRef aggregate refers to one of the vendors on the list. In a request, if a VendorRef aggregate includes both FullName and ListID, FullName will be ignored.
 IQBBaseRef     Y

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType      

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 41 chars    

VendorAddress

If an address request fails, some combination of address fields might be too long.
 IAddress   13.0  

Addr1

The first line of an address.
 IQBStringType 41 chars    

Addr2

The second line of an address (if a second line is needed).
 IQBStringType 41 chars    

Addr3

The third line of an address (if a third line is needed).
 IQBStringType 41 chars    

Addr4

The fourth line of an address (if a fourth line is needed).
 IQBStringType 41 chars 2.0  

Addr5

The fifth line of an address (if a fifth line is needed).
 IQBStringType 41 chars 6.0  

City

The city name in an address.
 IQBStringType 31 chars    

State

The state name in an address.
 IQBStringType 21 chars    

PostalCode

The postal code in an address.
 IQBStringType 13 chars    

Country

The country name in an address, or, in returned Host information (HostRet or HostInfo), the country for which this edition of QuickBooks was designed. (Possible values are US, CA, UK, and AU.)
 IQBStringType 31 chars    

Note

In a BillAddress or ShipAddress aggregate, the Note field value is written at the bottom of the address in the form in which it appears, such as the invoice form.
 IQBStringType 41 chars 6.0  

APAccountRef

Refers to an accounts payable account in the QuickBooks file. (The AccountType of this account will be AccountsPayable.) If APAccountRef is missing, the SDK will use the QuickBooks default AP account. In a request, if an APAccountRef aggregate includes both FullName and ListID, FullName will be ignored.
 IQBBaseRef   2.0  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   2.0  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 159 chars 2.0  

TxnDate

The date of the transaction. In some cases, if you leave TxnDate out of an -Add message, QuickBooks will prefill TxnDate with the date of the last-saved transaction of the same type.
 IQBDateType     Y

DueDate

The date on which payment is due.
 IQBDateType      

AmountDue

The total monetary amount shown on a bill or packing slip received from a vendor. AmountDue will be the total of the amounts in the expense lines, item lines, and item group lines. AmountDue minus any credits or discounts equals the OpenAmount.
 IQBAmountType     Y

CurrencyRef

The currency object contains all of the information needed by QuickBooks to display and use. For built-in currencies, the name and currency code values are internationally accepted values and thus are not editable. The comma format is editable, as is the IsActive status. For user-defined currencies, every value in the object is editable including name and currency code. When used with PriceLevels, the CurrencyRef should only be used with “per item” price levels.
 IQBBaseRef   8.0  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   8.0  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 64 chars 8.0  

ExchangeRate

The exchange rate is the market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the “home” currency. The exchange rate should be considered a snapshot of the rates in effect at the AsOfDate. You can update the exchange rate using the exchange rate property when you add a transaction. However, you need to obtain and supply the exchange rate. If you are using USD (United States Dollars) as the home currency and are connected to the Internet, you can download the current exchange rates for all active currencies automatically in the QuickBooks UI by selecting Lists->Currency->Activities->Download latest exchange rates. (Currently, you can’t do this in the SDK.)
 IQBFloatType   8.0  

AmountDueInHomeCurrency

Amount due in units of the home currency.
 IQBAmountType   8.0  

RefNumber

A string of characters that refers to this transaction and that can be arbitrarily changed by the QuickBooks user. In a BillPaymentCheckAdd request, if you want to set the check number, use RefNumber. Note (especially relevant to CheckAdd requests): When RefNumber is left blank in an SDK transaction add request (that is, or ), the RefNumber will be left blank in QuickBooks. This behavior is new as of QBFC3. It used to select the next sequential reference number since the last one used by QuickBooks, as though no RefNumber had been provided. This is especially relevant to CheckAdd requests because with the current behavior, you will not know the number until the check is printed.
 IQBStringType 20 chars    

IsPending

If IsPending is set to true, the bill has not been completed or in draft version. IsPending is supported from QB Desktop 2023 version 3 (USA & Canada) and SDK 16.0.
 IQBBoolType   16.0 CA.png us.png  

TermsRef

Refers to the payment terms associated with this entity. (This will be an item on the DateDrivenTerms or StandardTerms list.) If a TermsRef aggregate includes both FullName and ListID, FullName will be ignored.
 IQBBaseRef      

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType      

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 31 chars    

Memo

Appears in the A/P register and in reports that include this bill.
 IQBStringType 4095 chars    

IsTaxIncluded

For future use with international versions of QuickBooks.
 IQBBoolType   6.0 CA.png uk.png  

SalesTaxCodeRef

Each item on a sales form is assigned a sales-tax code that indicates whether the item is taxable or non-taxable, and why. Two general codes, which can be modified but not deleted, appear on the sales-tax code list by default: Non-taxable (Name = NON; Desc = Non-Taxable; IsTaxable = false) Taxable (Name = TAX; Desc = Taxable; IsTaxable = true) A sales-tax code can be deleted only if it is no longer associated with any customer, item, or transaction. If the “Do You Charge Sales Tax?” preference within QuickBooks is set to No, QuickBooks will assign the default non-taxable sales-tax code to all sales. A SalesTaxCodeRef aggregate refers to a sales-tax code on the list. In a request, if a SalesTaxCodeRef aggregate includes both FullName and ListID, FullName will be ignored. In a Customer message, SalesTaxCodeRef refers to the sales-tax code that will be used for items related to this customer. In an ItemInventory message, SalesTaxCodeRef refers to the type of sales tax that will be charged for this item, if it is a taxable item and if sales tax is set up within QuickBooks.
 IQBBaseRef   6.0 CA.png uk.png  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   6.0 CA.png uk.png  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 3 chars 6.0 CA.png uk.png  

IsPaid

If IsPaid is true, this transaction has been paid.
 IQBBoolType   2.0  

ExternalGUID

Allows for the attachment of a user defined GUID value.
 IQBGUIDType   9.0  

LinkedTxnList

If the IncludeLinkedTxns flag is set to true in a query, or if you create an item receipt that links to other transactionsthen the returned object will include a list of linked transactions, if any exist. If no linked transactions exist, the ILinkedTxnList object will be empty. The list of linked transactions is similar to the History view of a transaction in the user interface, but not identical, as the SDK list contains only linked transactions, not items.
 ILinkedTxnList   2.0  

(List

of ILinkedTxn Objects)
        

TxnID

QuickBooks generates a unique TxnID for each transaction that is added to QuickBooks. A TxnID returned from a request can be used to refer to the transaction in subsequent requests. Notice that you cannot supply the TxnID of a TimeTracking transaction to TransactionQueryRq requests. If you do, you get an error stating that no such record could be found, even though the transaction is in QuickBooks. This behavior reflects the behavior in the QuicKBooks UI in the Find window.
 IQBIDType     Y

TxnType

The type of transaction.
 IQBENTxnTypeType     Y

TxnDate

The date of the transaction. In some cases, if you leave TxnDate out of an -Add message, QuickBooks will prefill TxnDate with the date of the last-saved transaction of the same type.
 IQBDateType     Y

RefNumber

A string of characters that refers to this transaction and that can be arbitrarily changed by the QuickBooks user. In a BillPaymentCheckAdd request, if you want to set the check number, use RefNumber. Note (especially relevant to CheckAdd requests): When RefNumber is left blank in an SDK transaction add request (that is, or ), the RefNumber will be left blank in QuickBooks. This behavior is new as of QBFC3. It used to select the next sequential reference number since the last one used by QuickBooks, as though no RefNumber had been provided. This is especially relevant to CheckAdd requests because with the current behavior, you will not know the number until the check is printed.
 IQBStringType 20 chars    

LinkType

Indicates the nature of the link between the transactions: ltAMTTYPE means the two transactions are linked based on an amount value (for example an invoice linked to a payment). ltQUANTYPE means the two transactions are linked based on a quantity. This affects transactions that are linked to sales orders, estimates and purchase orders. For example, an invoice might be created from a sales order, based on the quantity of items received.
 IQBENLinkTypeType   3.0  

Amount

A monetary amount.
 IQBAmountType     Y

ExpenseLineRetList

A list of IExpenseLine objects, each representing one line in this expense.
 IExpenseLineRetList      

(List

of IExpenseLineRet Objects)
        

TxnLineID

Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
 IQBIDType     Y

AccountRef

The Account list is the company file’s list of accounts. An AccountRef aggregate refers to one of these accounts. (If an AccountRef aggregate includes both FullName and ListID, FullName will be ignored.) Special cases to note: In a Check message, AccountRef refers to the account from which the funds are being drawn for this check, for example, Checking or Savings. In an ExpenseLineAdd message, you must include AccountRef if the “Require accounts” check box is selected in the QuickBooks Accounting preferences. (It is selected by default.) In a CreditCardCredit message, AccountRef refers to the bank account or credit card account to which the credit is applied. In a CreditCardCharge message, AccountRef refers to the bank or credit card company to whom money is owed. How do you increase and decrease amounts in bank accounts? The following requests increase the balance in a bank account: Deposit Add ReceivePaymentAdd Journal Entry Add Sales ReceiptAdd The following requests decrease the balance in a bank account: CheckAdd Bill PaymentCheckAdd JournalEntryAdd
 IQBBaseRef      

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType      

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 159 chars    

Amount

A monetary amount.
 IQBAmountType      

Memo

Additional information about this expense line.
 IQBStringType 4095 chars    

CustomerRef

The customer list includes information about the QuickBooks user’s customers and the individual jobs that are being performed for them. A CustomerRef aggregate refers to one of the customers (or customer jobs) on the list. In a request, if a CustomerRef aggregate includes both FullName and ListID, FullName will be ignored. Special cases to note: In SalesReceipt and ReceivePayment requests, CustomerRef refers to the customer or customer job to which the payment is credited. In a TimeTracking request, CustomerRef refers to the customer or customer job to which this time could be billed. If IsBillable is set to true, CustomerRef is required in TimeTrackingAdd. In an ExpenseLineAdd request, if AccountRef refers to an A/P account, CustomerRef must refer to a vendor (not to a customer). If AccountRef refers to any other type of account, the CustomerRef must refer to a customer.
 IQBBaseRef      

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType      

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 209 chars    

ClassRef

Classes can be used to separate transactions into meaningful categories. (For example, transactions could be classified according to department, business location, or type of work.) In QuickBooks, class tracking is off by default. A ClassRef aggregate refers to one of these named classes. For example, in a TimeTracking message, ClassRef refers to the QuickBooks class into which the timed activity falls. If a ClassRef aggregate includes both FullName and ListID, FullName will be ignored. In an InvoiceAdd request, if you specify a ClassRef for the whole invoice, that same ClassRef is automatically used in the line items. If you want to clear that (that is, have NO ClassRef for the line item, you can clear it in the line item by simply not specifying it in the line item.
 IQBBaseRef      

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType      

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 159 chars    

SalesTaxCodeRef

Each item on a sales form is assigned a sales-tax code that indicates whether the item is taxable or non-taxable, and why. Two general codes, which can be modified but not deleted, appear on the sales-tax code list by default: Non-taxable (Name = NON; Desc = Non-Taxable; IsTaxable = false) Taxable (Name = TAX; Desc = Taxable; IsTaxable = true) A sales-tax code can be deleted only if it is no longer associated with any customer, item, or transaction. If the “Do You Charge Sales Tax?” preference within QuickBooks is set to No, QuickBooks will assign the default non-taxable sales-tax code to all sales. A SalesTaxCodeRef aggregate refers to a sales-tax code on the list. In a request, if a SalesTaxCodeRef aggregate includes both FullName and ListID, FullName will be ignored. In a Customer message, SalesTaxCodeRef refers to the sales-tax code that will be used for items related to this customer. In an ItemInventory message, SalesTaxCodeRef refers to the type of sales tax that will be charged for this item, if it is a taxable item and if sales tax is set up within QuickBooks.
 IQBBaseRef   6.0 CA.png uk.png  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   6.0 CA.png uk.png  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 3 chars 6.0 CA.png uk.png  

BillableStatus

The billing status of this item line or expense line.
 IQBENBillableStatusType   2.0  

SalesRepRef

A sales representative must be on the Employee, Vendor, or Other Names list within QuickBooks. Sales representative’s names and initials appear on the Rep drop-down list on QuickBooks sales forms. A SalesRepRef refers to a person on the SalesRep list. In a request, if a SalesRepRef aggregate includes both FullName and ListID, FullName will be ignored.
 IQBBaseRef   13.0  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   13.0  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 5 chars 13.0  

DataExtRetList

A list of IDataExtRet objects, each of which represents a field that has been added to QuickBooks as a data extension.
 IDataExtRetList   13.0  

(List

of IDataExtRet Objects)
        

OwnerID

OwnerID refers to the owner of a data extension, and must be 0 or a valid GUID. (Custom fields, which are visible in the QuickBooks UI, always have an OwnerID of 0. ) Usually you would keep your application’s GUID confidential to prevent other applications from accessing your data extensions. But if you want to share data extensions with another application, the applications need to use the same GUID. In this case, each application could use two GUIDs, one for shared data extensions and one for confidential data extensions. (An application can have any number of GUIDs.) When you share a data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
 IQBGUIDType      

DataExtName

The name of the data extension. If this is a custom field, DataExtName will be visible as a label in the QuickBooks user interface. Also because OwnerID and DataExtName together make the data extension unique, and because custom fields all have the same OwnerID of zero, the DataExtName must be a unique value among existing custom fields. In contrast, the DataExtName for private data extensions must be unique only for the specified OwnerID GUID.
 IQBStringType 31 chars   Y

DataExtType

The field’s data type, which corresponds to a qbXML data type. In an IDataExtDefAdd request object, if this is a custom field, DataExtType must be detSTR255TYPE.
 IQBENDataExtTypeType     Y

DataExtValue

The data in this field. The maximum length of DataExtValue will depend on the DataExtType of this data extension. For example, if DataExtType is STR255TYPE, the maximum length of DataExtValue is 255 characters. If DataExtType is STR1024TYPE, the maximum size of DataExtValue is 1KB.
 IQBStringType     Y

ORItemLineRetList

 IORItemLineRetList      

(List

of IORItemLineRet Objects)
        

ItemLineRet

An ItemLine is used to track any portion of a transaction that represents the purchase of an “item.” If ItemLineAdd does not specify an Amount, Cost, or Quantity, then QuickBooks will calculate Amount based on a Quantity of 1 and the suggested Cost.
 IItemLineRet      

TxnLineID

Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
 IQBIDType     Y

ItemRef

Depending on the request containing it, ItemRef can refer to an item on any Item list such as ItemDiscount, ItemInventory, and so forth, or it may accept only a subset of item types. For example, here are some requests that impose limits on what items ItemRef can refer to. For PurchaseOrder and Bill requests, ItemRef cannot refer to discount items or sales-tax items For VehicleMilageAdd requests, the ItemRef must refer to a service item or an other charge item. For BillingRateAdd requests, the ItemRef must refer to a service item. You can use an ItemQuery request to get information about all the items that are set up in the QuickBooks file. “Items” are line items used for fast entry on sales and purchase forms. They include services and goods that a business buys and sells, as well as special items that perform calculations–for example, subtotal, discount, and sales-tax items. Note: In a request, if an ItemRef aggregate includes both FullName and ListID, FullName will be ignored.
 IQBBaseRef      

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType      

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType      

InventorySiteRef

Site where inventory is located.
 IQBBaseRef   10.0  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   10.0  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 31 chars 10.0  

InventorySiteLocationRef

Location within the Inventory Site
 IQBBaseRef   12.0  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   12.0  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 31 chars 12.0  

ORSerialLotNumber

 IORSerialLotNumber   11.0  

SerialNumber

The serial number of the asset.
 IQBStringType 4095 chars    

LotNumber

The lot number of the asset.
 IQBStringType 40 chars    

ExpirationDateForSerialLotNumber

The expiration date of the inventory serial/lot number. Expiration Date is supported from QB Desktop 2023 version 3 (USA & Canada) and SDK 16.0.
 IQBStringType 1099 chars 16.0 CA.png us.png  

Desc

A descriptive text field.
 IQBStringType 4095 chars    

Quantity

Quantity For transactions: If an item line add on a transaction request specifies Quantity and Amount but not Rate, QuickBooks will use Quantity and Amount to calculate Rate. Likewise, if a request specifies Quantity and Rate but not Amount, QuickBooks will calculate the Amount. If a transaction add request includes a reference to an ItemDiscount item, do not include a Quantity element as well, or you will get an error. For Item requests: Quantity indicates how many of this item there are.
 IQBQuanType      

UnitOfMeasure

In a transaction line item, the name of the unit of measure selected from within the item’s available units. If the company file is enabled only for single unit of measure per item, this must be the base unit!
 IQBStringType 31 chars 7.0  

OverrideUOMSetRef

When you modify a transaction line to change the unit of measure used in that line, you use this aggregate to specify the UOM set within which you are choosing an available unit of measure. The “override” here refers to the unit within the set, not the UOM Set itself, which you cannot change or override–the UOM set that can be set or changed only in the item itself via an Item Mod request.
 IQBBaseRef   7.0  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   7.0  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 31 chars 7.0  

Cost

If both Quantity and Amount are specified, QuickBooks will use them to calculate Cost. Likewise, if both Quantity and Cost are specified, QuickBooks will use them to calculate the total Amount.
 IQBPriceType      

Amount

A monetary amount.
 IQBAmountType      

CustomerRef

The customer list includes information about the QuickBooks user’s customers and the individual jobs that are being performed for them. A CustomerRef aggregate refers to one of the customers (or customer jobs) on the list. In a request, if a CustomerRef aggregate includes both FullName and ListID, FullName will be ignored. Special cases to note: In SalesReceipt and ReceivePayment requests, CustomerRef refers to the customer or customer job to which the payment is credited. In a TimeTracking request, CustomerRef refers to the customer or customer job to which this time could be billed. If IsBillable is set to true, CustomerRef is required in TimeTrackingAdd. In an ExpenseLineAdd request, if AccountRef refers to an A/P account, CustomerRef must refer to a vendor (not to a customer). If AccountRef refers to any other type of account, the CustomerRef must refer to a customer.
 IQBBaseRef      

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType      

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 209 chars    

ClassRef

Classes can be used to separate transactions into meaningful categories. (For example, transactions could be classified according to department, business location, or type of work.) In QuickBooks, class tracking is off by default. A ClassRef aggregate refers to one of these named classes. For example, in a TimeTracking message, ClassRef refers to the QuickBooks class into which the timed activity falls. If a ClassRef aggregate includes both FullName and ListID, FullName will be ignored. In an InvoiceAdd request, if you specify a ClassRef for the whole invoice, that same ClassRef is automatically used in the line items. If you want to clear that (that is, have NO ClassRef for the line item, you can clear it in the line item by simply not specifying it in the line item.
 IQBBaseRef      

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType      

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 159 chars    

SalesTaxCodeRef

Each item on a sales form is assigned a sales-tax code that indicates whether the item is taxable or non-taxable, and why. Two general codes, which can be modified but not deleted, appear on the sales-tax code list by default: Non-taxable (Name = NON; Desc = Non-Taxable; IsTaxable = false) Taxable (Name = TAX; Desc = Taxable; IsTaxable = true) A sales-tax code can be deleted only if it is no longer associated with any customer, item, or transaction. If the “Do You Charge Sales Tax?” preference within QuickBooks is set to No, QuickBooks will assign the default non-taxable sales-tax code to all sales. A SalesTaxCodeRef aggregate refers to a sales-tax code on the list. In a request, if a SalesTaxCodeRef aggregate includes both FullName and ListID, FullName will be ignored. In a Customer message, SalesTaxCodeRef refers to the sales-tax code that will be used for items related to this customer. In an ItemInventory message, SalesTaxCodeRef refers to the type of sales tax that will be charged for this item, if it is a taxable item and if sales tax is set up within QuickBooks.
 IQBBaseRef   6.0 CA.png uk.png  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   6.0 CA.png uk.png  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 3 chars 6.0 CA.png uk.png  

BillableStatus

The billing status of this item line or expense line.
 IQBENBillableStatusType   2.0  

SalesRepRef

A sales representative must be on the Employee, Vendor, or Other Names list within QuickBooks. Sales representative’s names and initials appear on the Rep drop-down list on QuickBooks sales forms. A SalesRepRef refers to a person on the SalesRep list. In a request, if a SalesRepRef aggregate includes both FullName and ListID, FullName will be ignored.
 IQBBaseRef   13.0  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   13.0  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 5 chars 13.0  

DataExtRetList

A list of IDataExtRet objects, each of which represents a field that has been added to QuickBooks as a data extension.
 IDataExtRetList   13.0  

(List

of IDataExtRet Objects)
        

OwnerID

OwnerID refers to the owner of a data extension, and must be 0 or a valid GUID. (Custom fields, which are visible in the QuickBooks UI, always have an OwnerID of 0. ) Usually you would keep your application’s GUID confidential to prevent other applications from accessing your data extensions. But if you want to share data extensions with another application, the applications need to use the same GUID. In this case, each application could use two GUIDs, one for shared data extensions and one for confidential data extensions. (An application can have any number of GUIDs.) When you share a data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
 IQBGUIDType      

DataExtName

The name of the data extension. If this is a custom field, DataExtName will be visible as a label in the QuickBooks user interface. Also because OwnerID and DataExtName together make the data extension unique, and because custom fields all have the same OwnerID of zero, the DataExtName must be a unique value among existing custom fields. In contrast, the DataExtName for private data extensions must be unique only for the specified OwnerID GUID.
 IQBStringType 31 chars   Y

DataExtType

The field’s data type, which corresponds to a qbXML data type. In an IDataExtDefAdd request object, if this is a custom field, DataExtType must be detSTR255TYPE.
 IQBENDataExtTypeType     Y

DataExtValue

The data in this field. The maximum length of DataExtValue will depend on the DataExtType of this data extension. For example, if DataExtType is STR255TYPE, the maximum length of DataExtValue is 255 characters. If DataExtType is STR1024TYPE, the maximum size of DataExtValue is 1KB.
 IQBStringType     Y

ItemGroupLineRet

Refers to items that are grouped together in QuickBooks for fast entry.
 IItemGroupLineRet      

TxnLineID

Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
 IQBIDType   3.0 Y

ItemGroupRef

ItemGroup objects represent items that are grouped together for fast entry, and an ItemGroupRef aggregate refers to one of these item groups. In a request, if an ItemGroupRef aggregate includes both FullName and ListID, FullName will be ignored. You can use an ItemGroupQuery request to get information about all the item groups that are set up in the QuickBooks file.
 IQBBaseRef     Y

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType      

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 31 chars    

Desc

A descriptive text field.
 IQBStringType 4095 chars    

Quantity

Quantity For transactions: If an item line add on a transaction request specifies Quantity and Amount but not Rate, QuickBooks will use Quantity and Amount to calculate Rate. Likewise, if a request specifies Quantity and Rate but not Amount, QuickBooks will calculate the Amount. If a transaction add request includes a reference to an ItemDiscount item, do not include a Quantity element as well, or you will get an error. For Item requests: Quantity indicates how many of this item there are.
 IQBQuanType      

UnitOfMeasure

In a transaction line item, the name of the unit of measure selected from within the item’s available units. If the company file is enabled only for single unit of measure per item, this must be the base unit!
 IQBStringType 31 chars 7.0  

OverrideUOMSetRef

When you modify a transaction line to change the unit of measure used in that line, you use this aggregate to specify the UOM set within which you are choosing an available unit of measure. The “override” here refers to the unit within the set, not the UOM Set itself, which you cannot change or override–the UOM set that can be set or changed only in the item itself via an Item Mod request.
 IQBBaseRef   7.0  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   7.0  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 31 chars 7.0  

TotalAmount

Total amount of money paid or received. In a receive payment add transaction that has payment amount elements (such as AppliedToTxnAdd lines) you must supply a TotalAmount and the sum of all the PaymentAmount elements must not be greater than the TotalAmount.
 IQBAmountType     Y

ItemLineRetList

A list of IItemLineRet objects, each representing one line of the item. Each item line is used to track a portion of a transaction that represents the purchase of an “item.”
 IItemLineRetList      

(List

of IItemLineRet Objects)
        

TxnLineID

Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
 IQBIDType     Y

ItemRef

Depending on the request containing it, ItemRef can refer to an item on any Item list such as ItemDiscount, ItemInventory, and so forth, or it may accept only a subset of item types. For example, here are some requests that impose limits on what items ItemRef can refer to. For PurchaseOrder and Bill requests, ItemRef cannot refer to discount items or sales-tax items For VehicleMilageAdd requests, the ItemRef must refer to a service item or an other charge item. For BillingRateAdd requests, the ItemRef must refer to a service item. You can use an ItemQuery request to get information about all the items that are set up in the QuickBooks file. “Items” are line items used for fast entry on sales and purchase forms. They include services and goods that a business buys and sells, as well as special items that perform calculations–for example, subtotal, discount, and sales-tax items. Note: In a request, if an ItemRef aggregate includes both FullName and ListID, FullName will be ignored.
 IQBBaseRef      

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType      

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType      

InventorySiteRef

Site where inventory is located.
 IQBBaseRef   10.0  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   10.0  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 31 chars 10.0  

InventorySiteLocationRef

Location within the Inventory Site
 IQBBaseRef   12.0  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   12.0  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 31 chars 12.0  

ORSerialLotNumber

 IORSerialLotNumber   11.0  

SerialNumber

The serial number of the asset.
 IQBStringType 4095 chars    

LotNumber

The lot number of the asset.
 IQBStringType 40 chars    

ExpirationDateForSerialLotNumber

The expiration date of the inventory serial/lot number. Expiration Date is supported from QB Desktop 2023 version 3 (USA & Canada) and SDK 16.0.
 IQBStringType 1099 chars 16.0 CA.png us.png  

Desc

A descriptive text field.
 IQBStringType 4095 chars    

Quantity

Quantity For transactions: If an item line add on a transaction request specifies Quantity and Amount but not Rate, QuickBooks will use Quantity and Amount to calculate Rate. Likewise, if a request specifies Quantity and Rate but not Amount, QuickBooks will calculate the Amount. If a transaction add request includes a reference to an ItemDiscount item, do not include a Quantity element as well, or you will get an error. For Item requests: Quantity indicates how many of this item there are.
 IQBQuanType      

UnitOfMeasure

In a transaction line item, the name of the unit of measure selected from within the item’s available units. If the company file is enabled only for single unit of measure per item, this must be the base unit!
 IQBStringType 31 chars 7.0  

OverrideUOMSetRef

When you modify a transaction line to change the unit of measure used in that line, you use this aggregate to specify the UOM set within which you are choosing an available unit of measure. The “override” here refers to the unit within the set, not the UOM Set itself, which you cannot change or override–the UOM set that can be set or changed only in the item itself via an Item Mod request.
 IQBBaseRef   7.0  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   7.0  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 31 chars 7.0  

Cost

If both Quantity and Amount are specified, QuickBooks will use them to calculate Cost. Likewise, if both Quantity and Cost are specified, QuickBooks will use them to calculate the total Amount.
 IQBPriceType      

Amount

A monetary amount.
 IQBAmountType      

CustomerRef

The customer list includes information about the QuickBooks user’s customers and the individual jobs that are being performed for them. A CustomerRef aggregate refers to one of the customers (or customer jobs) on the list. In a request, if a CustomerRef aggregate includes both FullName and ListID, FullName will be ignored. Special cases to note: In SalesReceipt and ReceivePayment requests, CustomerRef refers to the customer or customer job to which the payment is credited. In a TimeTracking request, CustomerRef refers to the customer or customer job to which this time could be billed. If IsBillable is set to true, CustomerRef is required in TimeTrackingAdd. In an ExpenseLineAdd request, if AccountRef refers to an A/P account, CustomerRef must refer to a vendor (not to a customer). If AccountRef refers to any other type of account, the CustomerRef must refer to a customer.
 IQBBaseRef      

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType      

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 209 chars    

ClassRef

Classes can be used to separate transactions into meaningful categories. (For example, transactions could be classified according to department, business location, or type of work.) In QuickBooks, class tracking is off by default. A ClassRef aggregate refers to one of these named classes. For example, in a TimeTracking message, ClassRef refers to the QuickBooks class into which the timed activity falls. If a ClassRef aggregate includes both FullName and ListID, FullName will be ignored. In an InvoiceAdd request, if you specify a ClassRef for the whole invoice, that same ClassRef is automatically used in the line items. If you want to clear that (that is, have NO ClassRef for the line item, you can clear it in the line item by simply not specifying it in the line item.
 IQBBaseRef      

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType      

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 159 chars    

SalesTaxCodeRef

Each item on a sales form is assigned a sales-tax code that indicates whether the item is taxable or non-taxable, and why. Two general codes, which can be modified but not deleted, appear on the sales-tax code list by default: Non-taxable (Name = NON; Desc = Non-Taxable; IsTaxable = false) Taxable (Name = TAX; Desc = Taxable; IsTaxable = true) A sales-tax code can be deleted only if it is no longer associated with any customer, item, or transaction. If the “Do You Charge Sales Tax?” preference within QuickBooks is set to No, QuickBooks will assign the default non-taxable sales-tax code to all sales. A SalesTaxCodeRef aggregate refers to a sales-tax code on the list. In a request, if a SalesTaxCodeRef aggregate includes both FullName and ListID, FullName will be ignored. In a Customer message, SalesTaxCodeRef refers to the sales-tax code that will be used for items related to this customer. In an ItemInventory message, SalesTaxCodeRef refers to the type of sales tax that will be charged for this item, if it is a taxable item and if sales tax is set up within QuickBooks.
 IQBBaseRef   6.0 CA.png uk.png  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   6.0 CA.png uk.png  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 3 chars 6.0 CA.png uk.png  

BillableStatus

The billing status of this item line or expense line.
 IQBENBillableStatusType   2.0  

SalesRepRef

A sales representative must be on the Employee, Vendor, or Other Names list within QuickBooks. Sales representative’s names and initials appear on the Rep drop-down list on QuickBooks sales forms. A SalesRepRef refers to a person on the SalesRep list. In a request, if a SalesRepRef aggregate includes both FullName and ListID, FullName will be ignored.
 IQBBaseRef   13.0  

ListID

Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
 IQBIDType   13.0  

FullName

FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
 IQBStringType 5 chars 13.0  

DataExtRetList

A list of IDataExtRet objects, each of which represents a field that has been added to QuickBooks as a data extension.
 IDataExtRetList   13.0  

(List

of IDataExtRet Objects)
        

OwnerID

OwnerID refers to the owner of a data extension, and must be 0 or a valid GUID. (Custom fields, which are visible in the QuickBooks UI, always have an OwnerID of 0. ) Usually you would keep your application’s GUID confidential to prevent other applications from accessing your data extensions. But if you want to share data extensions with another application, the applications need to use the same GUID. In this case, each application could use two GUIDs, one for shared data extensions and one for confidential data extensions. (An application can have any number of GUIDs.) When you share a data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
 IQBGUIDType      

DataExtName

The name of the data extension. If this is a custom field, DataExtName will be visible as a label in the QuickBooks user interface. Also because OwnerID and DataExtName together make the data extension unique, and because custom fields all have the same OwnerID of zero, the DataExtName must be a unique value among existing custom fields. In contrast, the DataExtName for private data extensions must be unique only for the specified OwnerID GUID.
 IQBStringType 31 chars   Y

DataExtType

The field’s data type, which corresponds to a qbXML data type. In an IDataExtDefAdd request object, if this is a custom field, DataExtType must be detSTR255TYPE.
 IQBENDataExtTypeType     Y

DataExtValue

The data in this field. The maximum length of DataExtValue will depend on the DataExtType of this data extension. For example, if DataExtType is STR255TYPE, the maximum length of DataExtValue is 255 characters. If DataExtType is STR1024TYPE, the maximum size of DataExtValue is 1KB.
 IQBStringType     Y

DataExtList

A list of IDataExtRet objects, each of which represents a field that has been added to QuickBooks as a data extension.
 IDataExtList   13.0  

(List

of IDataExt Objects)
        

OwnerID

OwnerID refers to the owner of a data extension, and must be 0 or a valid GUID. (Custom fields, which are visible in the QuickBooks UI, always have an OwnerID of 0. ) Usually you would keep your application’s GUID confidential to prevent other applications from accessing your data extensions. But if you want to share data extensions with another application, the applications need to use the same GUID. In this case, each application could use two GUIDs, one for shared data extensions and one for confidential data extensions. (An application can have any number of GUIDs.) When you share a data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
 IQBGUIDType     Y

DataExtName

The name of the data extension. If this is a custom field, DataExtName will be visible as a label in the QuickBooks user interface. Also because OwnerID and DataExtName together make the data extension unique, and because custom fields all have the same OwnerID of zero, the DataExtName must be a unique value among existing custom fields. In contrast, the DataExtName for private data extensions must be unique only for the specified OwnerID GUID.
 IQBStringType 31 chars   Y

DataExtValue

The data in this field. The maximum length of DataExtValue will depend on the DataExtType of this data extension. For example, if DataExtType is STR255TYPE, the maximum length of DataExtValue is 255 characters. If DataExtType is STR1024TYPE, the maximum size of DataExtValue is 1KB.
 IQBStringType     Y

OpenAmount

Indicates the amount that is still owed. AmountDue minus any credits or discounts equals the OpenAmount.
 IQBAmountType      

DataExtRetList

A list of IDataExtRet objects, each of which represents a field that has been added to QuickBooks as a data extension.
 IDataExtRetList   2.0  

(List

of IDataExtRet Objects)
        

OwnerID

OwnerID refers to the owner of a data extension, and must be 0 or a valid GUID. (Custom fields, which are visible in the QuickBooks UI, always have an OwnerID of 0. ) Usually you would keep your application’s GUID confidential to prevent other applications from accessing your data extensions. But if you want to share data extensions with another application, the applications need to use the same GUID. In this case, each application could use two GUIDs, one for shared data extensions and one for confidential data extensions. (An application can have any number of GUIDs.) When you share a data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
 IQBGUIDType      

DataExtName

The name of the data extension. If this is a custom field, DataExtName will be visible as a label in the QuickBooks user interface. Also because OwnerID and DataExtName together make the data extension unique, and because custom fields all have the same OwnerID of zero, the DataExtName must be a unique value among existing custom fields. In contrast, the DataExtName for private data extensions must be unique only for the specified OwnerID GUID.
 IQBStringType 31 chars   Y

DataExtType

The field’s data type, which corresponds to a qbXML data type. In an IDataExtDefAdd request object, if this is a custom field, DataExtType must be detSTR255TYPE.
 IQBENDataExtTypeType     Y

DataExtValue

The data in this field. The maximum length of DataExtValue will depend on the DataExtType of this data extension. For example, if DataExtType is STR255TYPE, the maximum length of DataExtValue is 255 characters. If DataExtType is STR1024TYPE, the maximum size of DataExtValue is 1KB.
 IQBStringType     Y 

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="16.0"?>
<QBXML>
        <QBXMLMsgsRq onError="stopOnError">
                <BillQueryRq metaData="ENUMTYPE" iterator="ENUMTYPE" iteratorID="UUIDTYPE">
                        <!-- BEGIN OR -->
                                <TxnID >IDTYPE</TxnID> <!-- optional, may repeat -->
                        <!-- OR -->
                                <RefNumber >STRTYPE</RefNumber> <!-- optional, may repeat -->
                        <!-- OR -->
                                <RefNumberCaseSensitive >STRTYPE</RefNumberCaseSensitive> <!-- optional, may repeat -->
                        <!-- OR -->
                                <MaxReturned >INTTYPE</MaxReturned> <!-- optional -->
                                <!-- BEGIN OR -->
                                        <ModifiedDateRangeFilter> <!-- optional -->
                                                <FromModifiedDate >DATETIMETYPE</FromModifiedDate> <!-- optional -->
                                                <ToModifiedDate >DATETIMETYPE</ToModifiedDate> <!-- optional -->
                                        </ModifiedDateRangeFilter>
                                <!-- OR -->
                                        <TxnDateRangeFilter> <!-- optional -->
                                                <!-- BEGIN OR -->
                                                        <FromTxnDate >DATETYPE</FromTxnDate> <!-- optional -->
                                                        <ToTxnDate >DATETYPE</ToTxnDate> <!-- optional -->
                                                <!-- OR -->
                                                        <!-- DateMacro may have one of the following values: All, Today, ThisWeek, ThisWeekToDate, ThisMonth, ThisMonthToDate, ThisCalendarQuarter, ThisCalendarQuarterToDate, ThisFiscalQuarter, ThisFiscalQuarterToDate, ThisCalendarYear, ThisCalendarYearToDate, ThisFiscalYear, ThisFiscalYearToDate, Yesterday, LastWeek, LastWeekToDate, LastMonth, LastMonthToDate, LastCalendarQuarter, LastCalendarQuarterToDate, LastFiscalQuarter, LastFiscalQuarterToDate, LastCalendarYear, LastCalendarYearToDate, LastFiscalYear, LastFiscalYearToDate, NextWeek, NextFourWeeks, NextMonth, NextCalendarQuarter, NextCalendarYear, NextFiscalQuarter, NextFiscalYear -->
                                                        <DateMacro >ENUMTYPE</DateMacro> <!-- optional -->
                                                <!-- END OR -->
                                        </TxnDateRangeFilter>
                                <!-- END OR -->
                                <EntityFilter> <!-- optional -->
                                        <!-- BEGIN OR -->
                                                <ListID >IDTYPE</ListID> <!-- optional, may repeat -->
                                        <!-- OR -->
                                                <FullName >STRTYPE</FullName> <!-- optional, may repeat -->
                                        <!-- OR -->
                                                <ListIDWithChildren >IDTYPE</ListIDWithChildren> <!-- optional -->
                                        <!-- OR -->
                                                <FullNameWithChildren >STRTYPE</FullNameWithChildren> <!-- optional -->
                                        <!-- END OR -->
                                </EntityFilter>
                                <AccountFilter> <!-- optional -->
                                        <!-- BEGIN OR -->
                                                <ListID >IDTYPE</ListID> <!-- optional, may repeat -->
                                        <!-- OR -->
                                                <FullName >STRTYPE</FullName> <!-- optional, may repeat -->
                                        <!-- OR -->
                                                <ListIDWithChildren >IDTYPE</ListIDWithChildren> <!-- optional -->
                                        <!-- OR -->
                                                <FullNameWithChildren >STRTYPE</FullNameWithChildren> <!-- optional -->
                                        <!-- END OR -->
                                </AccountFilter>
                                <!-- BEGIN OR -->
                                        <RefNumberFilter> <!-- optional -->
                                                <!-- MatchCriterion may have one of the following values: StartsWith, Contains, EndsWith -->
                                                <MatchCriterion >ENUMTYPE</MatchCriterion> <!-- required -->
                                                <RefNumber >STRTYPE</RefNumber> <!-- required -->
                                        </RefNumberFilter>
                                <!-- OR -->
                                        <RefNumberRangeFilter> <!-- optional -->
                                                <FromRefNumber >STRTYPE</FromRefNumber> <!-- optional -->
                                                <ToRefNumber >STRTYPE</ToRefNumber> <!-- optional -->
                                        </RefNumberRangeFilter>
                                <!-- END OR -->
                                <CurrencyFilter> <!-- optional -->
                                        <!-- BEGIN OR -->
                                                <ListID >IDTYPE</ListID> <!-- optional, may repeat -->
                                        <!-- OR -->
                                                <FullName >STRTYPE</FullName> <!-- optional, may repeat -->
                                        <!-- END OR -->
                                </CurrencyFilter>
                                <!-- PaidStatus may have one of the following values: All [DEFAULT], PaidOnly, NotPaidOnly -->
                                <PaidStatus >ENUMTYPE</PaidStatus> <!-- optional -->
                        <!-- END OR -->
                        <IncludeLineItems >BOOLTYPE</IncludeLineItems> <!-- optional -->
                        <IncludeLinkedTxns >BOOLTYPE</IncludeLinkedTxns> <!-- optional -->
                        <IncludeRetElement >STRTYPE</IncludeRetElement> <!-- optional, may repeat -->
                        <OwnerID >GUIDTYPE</OwnerID> <!-- optional, may repeat -->
                </BillQueryRq>

                <BillQueryRs statusCode="INTTYPE" statusSeverity="STRTYPE" statusMessage="STRTYPE" retCount="INTTYPE" iteratorRemainingCount="INTTYPE" iteratorID="UUIDTYPE">
                        <BillRet> <!-- optional, may repeat -->
                                <TxnID >IDTYPE</TxnID> <!-- required -->
                                <TimeCreated >DATETIMETYPE</TimeCreated> <!-- required -->
                                <TimeModified >DATETIMETYPE</TimeModified> <!-- required -->
                                <EditSequence >STRTYPE</EditSequence> <!-- required -->
                                <TxnNumber >INTTYPE</TxnNumber> <!-- optional -->
                                <VendorRef> <!-- required -->
                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                </VendorRef>
                                <VendorAddress> <!-- optional -->
                                        <Addr1 >STRTYPE</Addr1> <!-- optional -->
                                        <Addr2 >STRTYPE</Addr2> <!-- optional -->
                                        <Addr3 >STRTYPE</Addr3> <!-- optional -->
                                        <Addr4 >STRTYPE</Addr4> <!-- optional -->
                                        <Addr5 >STRTYPE</Addr5> <!-- optional -->
                                        <City >STRTYPE</City> <!-- optional -->
                                        <State >STRTYPE</State> <!-- optional -->
                                        <PostalCode >STRTYPE</PostalCode> <!-- optional -->
                                        <Country >STRTYPE</Country> <!-- optional -->
                                        <Note >STRTYPE</Note> <!-- optional -->
                                </VendorAddress>
                                <APAccountRef> <!-- optional -->
                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                </APAccountRef>
                                <TxnDate >DATETYPE</TxnDate> <!-- required -->
                                <DueDate >DATETYPE</DueDate> <!-- optional -->
                                <AmountDue >AMTTYPE</AmountDue> <!-- required -->
                                <CurrencyRef> <!-- optional -->
                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                </CurrencyRef>
                                <ExchangeRate >FLOATTYPE</ExchangeRate> <!-- optional -->
                                <AmountDueInHomeCurrency >AMTTYPE</AmountDueInHomeCurrency> <!-- optional -->
                                <RefNumber >STRTYPE</RefNumber> <!-- optional -->
                                <IsPending>BOOLTYPE</IsPending> <!-- optional -->
                                <TermsRef> <!-- optional -->
                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                </TermsRef>
                                <Memo >STRTYPE</Memo> <!-- optional -->
                                <IsTaxIncluded >BOOLTYPE</IsTaxIncluded> <!-- optional -->
                                <SalesTaxCodeRef> <!-- optional -->
                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                </SalesTaxCodeRef>
                                <IsPaid >BOOLTYPE</IsPaid> <!-- optional -->
                                <ExternalGUID >GUIDTYPE</ExternalGUID> <!-- optional -->
                                <LinkedTxn> <!-- optional, may repeat -->
                                        <TxnID >IDTYPE</TxnID> <!-- required -->
                                        <!-- TxnType may have one of the following values: ARRefundCreditCard, Bill, BillPaymentCheck, BillPaymentCreditCard, BuildAssembly, Charge, Check, CreditCardCharge, CreditCardCredit, CreditMemo, Deposit, Estimate, InventoryAdjustment, Invoice, ItemReceipt, JournalEntry, LiabilityAdjustment, Paycheck, PayrollLiabilityCheck, PurchaseOrder, ReceivePayment, SalesOrder, SalesReceipt, SalesTaxPaymentCheck, Transfer, VendorCredit, YTDAdjustment -->
                                        <TxnType >ENUMTYPE</TxnType> <!-- required -->
                                        <TxnDate >DATETYPE</TxnDate> <!-- required -->
                                        <RefNumber >STRTYPE</RefNumber> <!-- optional -->
                                        <!-- LinkType may have one of the following values: AMTTYPE, QUANTYPE -->
                                        <LinkType >ENUMTYPE</LinkType> <!-- optional -->
                                        <Amount >AMTTYPE</Amount> <!-- required -->
                                </LinkedTxn>
                                <ExpenseLineRet> <!-- optional, may repeat -->
                                        <TxnLineID >IDTYPE</TxnLineID> <!-- required -->
                                        <AccountRef> <!-- optional -->
                                                <ListID >IDTYPE</ListID> <!-- optional -->
                                                <FullName >STRTYPE</FullName> <!-- optional -->
                                        </AccountRef>
                                        <Amount >AMTTYPE</Amount> <!-- optional -->
                                        <Memo >STRTYPE</Memo> <!-- optional -->
                                        <CustomerRef> <!-- optional -->
                                                <ListID >IDTYPE</ListID> <!-- optional -->
                                                <FullName >STRTYPE</FullName> <!-- optional -->
                                        </CustomerRef>
                                        <ClassRef> <!-- optional -->
                                                <ListID >IDTYPE</ListID> <!-- optional -->
                                                <FullName >STRTYPE</FullName> <!-- optional -->
                                        </ClassRef>
                                        <SalesTaxCodeRef> <!-- optional -->
                                                <ListID >IDTYPE</ListID> <!-- optional -->
                                                <FullName >STRTYPE</FullName> <!-- optional -->
                                        </SalesTaxCodeRef>
                                        <!-- BillableStatus may have one of the following values: Billable, NotBillable, HasBeenBilled -->
                                        <BillableStatus >ENUMTYPE</BillableStatus> <!-- optional -->
                                        <SalesRepRef> <!-- optional -->
                                                <ListID >IDTYPE</ListID> <!-- optional -->
                                                <FullName >STRTYPE</FullName> <!-- optional -->
                                        </SalesRepRef>
                                        <DataExtRet> <!-- optional, may repeat -->
                                                <OwnerID >GUIDTYPE</OwnerID> <!-- optional -->
                                                <DataExtName >STRTYPE</DataExtName> <!-- required -->
                                                <!-- DataExtType may have one of the following values: AMTTYPE, DATETIMETYPE, INTTYPE, PERCENTTYPE, PRICETYPE, QUANTYPE, STR1024TYPE, STR255TYPE -->
                                                <DataExtType >ENUMTYPE</DataExtType> <!-- required -->
                                                <DataExtValue >STRTYPE</DataExtValue> <!-- required -->
                                        </DataExtRet>
                                </ExpenseLineRet>
                                <!-- BEGIN OR -->
                                        <ItemLineRet> <!-- optional -->
                                                <TxnLineID >IDTYPE</TxnLineID> <!-- required -->
                                                <ItemRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </ItemRef>
                                                <InventorySiteRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </InventorySiteRef>
                                                <InventorySiteLocationRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </InventorySiteLocationRef>
                                                <!-- BEGIN OR -->
                                                        <SerialNumber >STRTYPE</SerialNumber> <!-- optional -->
                                                <!-- OR -->
                                                        <LotNumber >STRTYPE</LotNumber> <!-- optional -->
                                                <!-- END OR -->
                                                <ExpirationDateForSerialLotNumber >STRTYPE</ExpirationDateForSerialLotNumber> <!-- optional -->
                                                <Desc >STRTYPE</Desc> <!-- optional -->
                                                <Quantity >QUANTYPE</Quantity> <!-- optional -->
                                                <UnitOfMeasure >STRTYPE</UnitOfMeasure> <!-- optional -->
                                                <OverrideUOMSetRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </OverrideUOMSetRef>
                                                <Cost >PRICETYPE</Cost> <!-- optional -->
                                                <Amount >AMTTYPE</Amount> <!-- optional -->
                                                <CustomerRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </CustomerRef>
                                                <ClassRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </ClassRef>
                                                <SalesTaxCodeRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </SalesTaxCodeRef>
                                                <!-- BillableStatus may have one of the following values: Billable, NotBillable, HasBeenBilled -->
                                                <BillableStatus >ENUMTYPE</BillableStatus> <!-- optional -->
                                                <SalesRepRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </SalesRepRef>
                                                <DataExtRet> <!-- optional, may repeat -->
                                                        <OwnerID >GUIDTYPE</OwnerID> <!-- optional -->
                                                        <DataExtName >STRTYPE</DataExtName> <!-- required -->
                                                        <!-- DataExtType may have one of the following values: AMTTYPE, DATETIMETYPE, INTTYPE, PERCENTTYPE, PRICETYPE, QUANTYPE, STR1024TYPE, STR255TYPE -->
                                                        <DataExtType >ENUMTYPE</DataExtType> <!-- required -->
                                                        <DataExtValue >STRTYPE</DataExtValue> <!-- required -->
                                                </DataExtRet>
                                        </ItemLineRet>
                                <!-- OR -->
                                        <ItemGroupLineRet> <!-- optional -->
                                                <TxnLineID >IDTYPE</TxnLineID> <!-- required -->
                                                <ItemGroupRef> <!-- required -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </ItemGroupRef>
                                                <Desc >STRTYPE</Desc> <!-- optional -->
                                                <Quantity >QUANTYPE</Quantity> <!-- optional -->
                                                <UnitOfMeasure >STRTYPE</UnitOfMeasure> <!-- optional -->
                                                <OverrideUOMSetRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </OverrideUOMSetRef>
                                                <TotalAmount >AMTTYPE</TotalAmount> <!-- required -->
                                                <ItemLineRet> <!-- optional, may repeat -->
                                                        <TxnLineID >IDTYPE</TxnLineID> <!-- required -->
                                                        <ItemRef> <!-- optional -->
                                                                <ListID >IDTYPE</ListID> <!-- optional -->
                                                                <FullName >STRTYPE</FullName> <!-- optional -->
                                                        </ItemRef>
                                                        <InventorySiteRef> <!-- optional -->
                                                                <ListID >IDTYPE</ListID> <!-- optional -->
                                                                <FullName >STRTYPE</FullName> <!-- optional -->
                                                        </InventorySiteRef>
                                                        <InventorySiteLocationRef> <!-- optional -->
                                                                <ListID >IDTYPE</ListID> <!-- optional -->
                                                                <FullName >STRTYPE</FullName> <!-- optional -->
                                                        </InventorySiteLocationRef>
                                                        <!-- BEGIN OR -->
                                                                <SerialNumber >STRTYPE</SerialNumber> <!-- optional -->
                                                        <!-- OR -->
                                                                <LotNumber >STRTYPE</LotNumber> <!-- optional -->
                                                        <!-- END OR -->
                                                        <ExpirationDateForSerialLotNumber >STRTYPE</ExpirationDateForSerialLotNumber> <!-- optional -->
                                                        <Desc >STRTYPE</Desc> <!-- optional -->
                                                        <Quantity >QUANTYPE</Quantity> <!-- optional -->
                                                        <UnitOfMeasure >STRTYPE</UnitOfMeasure> <!-- optional -->
                                                        <OverrideUOMSetRef> <!-- optional -->
                                                                <ListID >IDTYPE</ListID> <!-- optional -->
                                                                <FullName >STRTYPE</FullName> <!-- optional -->
                                                        </OverrideUOMSetRef>
                                                        <Cost >PRICETYPE</Cost> <!-- optional -->
                                                        <Amount >AMTTYPE</Amount> <!-- optional -->
                                                        <CustomerRef> <!-- optional -->
                                                                <ListID >IDTYPE</ListID> <!-- optional -->
                                                                <FullName >STRTYPE</FullName> <!-- optional -->
                                                        </CustomerRef>
                                                        <ClassRef> <!-- optional -->
                                                                <ListID >IDTYPE</ListID> <!-- optional -->
                                                                <FullName >STRTYPE</FullName> <!-- optional -->
                                                        </ClassRef>
                                                        <SalesTaxCodeRef> <!-- optional -->
                                                                <ListID >IDTYPE</ListID> <!-- optional -->
                                                                <FullName >STRTYPE</FullName> <!-- optional -->
                                                        </SalesTaxCodeRef>
                                                        <!-- BillableStatus may have one of the following values: Billable, NotBillable, HasBeenBilled -->
                                                        <BillableStatus >ENUMTYPE</BillableStatus> <!-- optional -->
                                                        <SalesRepRef> <!-- optional -->
                                                                <ListID >IDTYPE</ListID> <!-- optional -->
                                                                <FullName >STRTYPE</FullName> <!-- optional -->
                                                        </SalesRepRef>
                                                        <DataExtRet> <!-- optional, may repeat -->
                                                                <OwnerID >GUIDTYPE</OwnerID> <!-- optional -->
                                                                <DataExtName >STRTYPE</DataExtName> <!-- required -->
                                                                <!-- DataExtType may have one of the following values: AMTTYPE, DATETIMETYPE, INTTYPE, PERCENTTYPE, PRICETYPE, QUANTYPE, STR1024TYPE, STR255TYPE -->
                                                                <DataExtType >ENUMTYPE</DataExtType> <!-- required -->
                                                                <DataExtValue >STRTYPE</DataExtValue> <!-- required -->
                                                        </DataExtRet>
                                                </ItemLineRet>
                                                <DataExt> <!-- optional, may repeat -->
                                                        <OwnerID >GUIDTYPE</OwnerID> <!-- required -->
                                                        <DataExtName >STRTYPE</DataExtName> <!-- required -->
                                                        <DataExtValue >STRTYPE</DataExtValue> <!-- required -->
                                                </DataExt>
                                        </ItemGroupLineRet>
                                <!-- END OR -->
                                <OpenAmount >AMTTYPE</OpenAmount> <!-- optional -->
                                <DataExtRet> <!-- optional, may repeat -->
                                        <OwnerID >GUIDTYPE</OwnerID> <!-- optional -->
                                        <DataExtName >STRTYPE</DataExtName> <!-- required -->
                                        <!-- DataExtType may have one of the following values: AMTTYPE, DATETIMETYPE, INTTYPE, PERCENTTYPE, PRICETYPE, QUANTYPE, STR1024TYPE, STR255TYPE -->
                                        <DataExtType >ENUMTYPE</DataExtType> <!-- required -->
                                        <DataExtValue >STRTYPE</DataExtValue> <!-- required -->
                                </DataExtRet>
                        </BillRet>
                </BillQueryRs>
        </QBXMLMsgsRq>
</QBXML>


   1
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
  41
  42
  43
  44
  45
  46
  47
  48
  49
  50
  51
  52
  53
  54
  55
  56
  57
  58
  59
  60
  61
  62
  63
  64
  65
  66
  67
  68
  69
  70
  71
  72
  73
  74
  75
  76
  77
  78
  79
  80
  81
  82
  83
  84
  85
  86
  87
  88
  89
  90
  91
  92
  93
  94
  95
  96
  97
  98
  99
 100
 101
 102
 103
 104
 105
 106
 107
 108
 109
 110
 111
 112
 113
 114
 115
 116
 117
 118
 119
 120
 121
 122
 123
 124
 125
 126
 127
 128
 129
 130
 131
 132
 133
 134
 135
 136
 137
 138
 139
 140
 141
 142
 143
 144
 145
 146
 147
 148
 149
 150
 151
 152
 153
 154
 155
 156
 157
 158
 159
 160
 161
 162
 163
 164
 165
 166
 167
 168
 169
 170
 171
 172
 173
 174
 175
 176
 177
 178
 179
 180
 181
 182
 183
 184
 185
 186
 187
 188
 189
 190
 191
 192
 193
 194
 195
 196
 197
 198
 199
 200
 201
 202
 203
 204
 205
 206
 207
 208
 209
 210
 211
 212
 213
 214
 215
 216
 217
 218
 219
 220
 221
 222
 223
 224
 225
 226
 227
 228
 229
 230
 231
 232
 233
 234
 235
 236
 237
 238
 239
 240
 241
 242
 243
 244
 245
 246
 247
 248
 249
 250
 251
 252
 253
 254
 255
 256
 257
 258
 259
 260
 261
 262
 263
 264
 265
 266
 267
 268
 269
 270
 271
 272
 273
 274
 275
 276
 277
 278
 279
 280
 281
 282
 283
 284
 285
 286
 287
 288
 289
 290
 291
 292
 293
 294
 295
 296
 297
 298
 299
 300
 301
 302
 303
 304
 305
 306
 307
 308
 309
 310
 311
 312
 313
 314
 315
 316
 317
 318
 319
 320
 321
 322
 323
 324
 325
 326
 327
 328
 329
 330
 331
 332
 333
 334
 335
 336
 337
 338
 339
 340
 341
 342
 343
 344
 345
 346
 347
 348
 349
 350
 351
 352
 353
 354
 355
 356
 357
 358
 359
 360
 361
 362
 363
 364
 365
 366
 367
 368
 369
 370
 371
 372
 373
 374
 375
 376
 377
 378
 379
 380
 381
 382
 383
 384
 385
 386
 387
 388
 389
 390
 391
 392
 393
 394
 395
 396
 397
 398
 399
 400
 401
 402
 403
 404
 405
 406
 407
 408
 409
 410
 411
 412
 413
 414
 415
 416
 417
 418
 419
 420
 421
 422
 423
 424
 425
 426
 427
 428
 429
 430
 431
 432
 433
 434
 435
 436
 437
 438
 439
 440
 441
 442
 443
 444
 445
 446
 447
 448
 449
 450
 451
 452
 453
 454
 455
 456
 457
 458
 459
 460
 461
 462
 463
 464
 465
 466
 467
 468
 469
 470
 471
 472
 473
 474
 475
 476
 477
 478
 479
 480
 481
 482
 483
 484
 485
 486
 487
 488
 489
 490
 491
 492
 493
 494
 495
 496
 497
 498
 499
 500
 501
 502
 503
 504
 505
 506
 507
 508
 509
 510
 511
 512
 513
 514
 515
 516
 517
 518
 519
 520
 521
 522
 523
 524
 525
 526
 527
 528
 529
 530
 531
 532
 533
 534
 535
 536
 537
 538
 539
 540
 541
 542
 543
 544
 545
 546
 547
 548
 549
 550
 551
 552
 553
 554
 555
 556
 557
 558
 559
 560
 561
 562
 563
 564
 565
 566
 567
 568
 569
 570
 571
 572
 573
 574
 575
 576
 577
 578
 579
 580
 581
 582
 583
 584
 585
 586
 587
 588
 589
 590
 591
 592
 593
 594
 595
 596
 597
 598
 599
 600
 601
 602
 603
 604
 605
 606
 607
 608
 609
 610
 611
 612
 613
 614
 615
 616
 617
 618
 619
 620
 621
 622
 623
 624
 625
 626
 627
 628
 629
 630
 631
 632
 633
 634
 635
 636
 637
 638
 639
 640
 641
 642
 643
 644
 645
 646
 647
 648
 649
 650
 651
 652
 653
 654
 655
 656
 657
 658
 659
 660
 661
 662
 663
 664
 665
 666
 667
 668
 669
 670
 671
 672
 673
 674
 675
 676
 677
 678
 679
 680
 681
 682
 683
 684
 685
 686
 687
 688
 689
 690
 691
 692
 693
 694
 695
 696
 697
 698
 699
 700
 701
 702
 703
 704
 705
 706
 707
 708
 709
 710
 711
 712
 713
 714
 715
 716
 717
 718
 719
 720
 721
 722
 723
 724
 725
 726
 727
 728
 729
 730
 731
 732
 733
 734
 735
 736
 737
 738
 739
 740
 741
 742
 743
 744
 745
 746
 747
 748
 749
 750
 751
 752
 753
 754
 755
 756
 757
 758
 759
 760
 761
 762
 763
 764
 765
 766
 767
 768
 769
 770
 771
 772
 773
 774
 775
 776
 777
 778
 779
 780
 781
 782
 783
 784
 785
 786
 787
 788
 789
 790
 791
 792
 793
 794
 795
 796
 797
 798
 799
 800
 801
 802
 803
 804
 805
 806
 807
 808
 809
 810
 811
 812
 813
 814
 815
 816
 817
 818
 819
 820
 821
 822
 823
 824
 825
 826
 827
 828
 829
 830
 831
 832
 833
 834
 835
 836
 837
 838
 839
 840
 841
 842
 843
 844
 845
 846
 847
 848
 849
 850
 851
 852
 853
 854
 855
 856
 857
 858
 859
 860
 861
 862
 863
 864
 865
 866
 867
 868
 869
 870
 871
 872
 873
 874
 875
 876
 877
 878
 879
 880
 881
 882
 883
 884
 885
 886
 887
 888
 889
 890
 891
 892
 893
 894
 895
 896
 897
 898
 899
 900
 901
 902
 903
 904
 905
 906
 907
 908
 909
 910
 911
 912
 913
 914
 915
 916
 917
 918
 919
 920
 921
 922
 923
 924
 925
 926
 927
 928
 929
 930
 931
 932
 933
 934
 935
 936
 937
 938
 939
 940
 941
 942
 943
 944
 945
 946
 947
 948
 949
 950
 951
 952
 953
 954
 955
 956
 957
 958
 959
 960
 961
 962
 963
 964
 965
 966
 967
 968
 969
 970
 971
 972
 973
 974
 975
 976
 977
 978
 979
 980
 981
 982
 983
 984
 985
 986
 987
 988
 989
 990
 991
 992
 993
 994
 995
 996
 997
 998
 999
1000
1001
1002
1003
'The following sample code is generated as an illustration of
'Creating requests and parsing responses ONLY
'This code is NOT intended to show best practices or ideal code
'Use at your most careful discretion

imports System
imports System.Net
imports System.Drawing
imports System.Collections
imports System.ComponentModel
imports System.Windows.Forms
imports System.Data
imports System.IO
imports Interop.QBFC16

Module com.intuit.idn.samples
        Public Class Sample
                Public Sub  DoBillQuery()
                        Dim sessionBegun as Boolean
                        sessionBegun = False
                        Dim connectionOpen as Boolean
                        connectionOpen = False
                        Dim sessionManager as QBSessionManager
                        sessionManager = nothing

                        Try
                                'Create the session Manager object
                                sessionManager = new QBSessionManager

                                'Create the message set request object to hold our request
                                Dim requestMsgSet as IMsgSetRequest
                                requestMsgSet = sessionManager.CreateMsgSetRequest("US",16,0)
                                requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue

                                BuildBillQueryRq(requestMsgSet)

                                'Connect to QuickBooks and begin a session
                                sessionManager.OpenConnection("","Sample Code from OSR")
                                connectionOpen = True
                                sessionManager.BeginSession("", ENOpenMode.omDontCare)
                                sessionBegun = True

                                'Send the request and get the response from QuickBooks
                                Dim responseMsgSet as IMsgSetResponse
                                responseMsgSet = sessionManager.DoRequests(requestMsgSet)

                                'End the session and close the connection to QuickBooks
                                sessionManager.EndSession()
                                sessionBegun = False
                                sessionManager.CloseConnection()
                                connectionOpen = False

                                WalkBillQueryRs(responseMsgSet)
                        Catch e as Exception
                                MessageBox.Show(e.Message, "Error")
                                if (sessionBegun) then
                                        sessionManager.EndSession()
                                End If
                                if (connectionOpen) then
                                        sessionManager.CloseConnection()
                                End If
                        End Try
                End Sub
                Public Sub BuildBillQueryRq(requestMsgSet as IMsgSetRequest)
                        Dim BillQueryRq as IBillQuery
                        BillQueryRq= requestMsgSet.AppendBillQueryRq()
                        Dim ORBillQueryElementType1892 as String
                        ORBillQueryElementType1892 = "TxnIDList"
                        if (ORBillQueryElementType1892 == "TxnIDList") then
                                'Set field value for TxnIDList
                                'May create more than one of these if needed
                                BillQueryRq.ORBillQuery.TxnIDList.Add("200000-1011023419")
                        End If
                        if (ORBillQueryElementType1892 == "RefNumberList") then
                                'Set field value for RefNumberList
                                'May create more than one of these if needed
                                BillQueryRq.ORBillQuery.RefNumberList.Add("ab")
                        End If
                        if (ORBillQueryElementType1892 == "RefNumberCaseSensitiveList") then
                                'Set field value for RefNumberCaseSensitiveList
                                'May create more than one of these if needed
                                BillQueryRq.ORBillQuery.RefNumberCaseSensitiveList.Add("ab")
                        End If
                        if (ORBillQueryElementType1892 == "BillFilter") then
                                'Set field value for MaxReturned
                                BillQueryRq.ORBillQuery.BillFilter.MaxReturned.SetValue(6)
                                Dim ORDateRangeFilterElementType1893 as String
                                ORDateRangeFilterElementType1893 = "ModifiedDateRangeFilter"
                                if (ORDateRangeFilterElementType1893 == "ModifiedDateRangeFilter") then
                                        'Set field value for FromModifiedDate
                                        BillQueryRq.ORBillQuery.BillFilter.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
                                        'Set field value for ToModifiedDate
                                        BillQueryRq.ORBillQuery.BillFilter.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
                                End If
                                if (ORDateRangeFilterElementType1893 == "TxnDateRangeFilter") then
                                        Dim ORTxnDateRangeFilterElementType1894 as String
                                        ORTxnDateRangeFilterElementType1894 = "TxnDateFilter"
                                        if (ORTxnDateRangeFilterElementType1894 == "TxnDateFilter") then
                                                'Set field value for FromTxnDate
                                                BillQueryRq.ORBillQuery.BillFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007"))
                                                'Set field value for ToTxnDate
                                                BillQueryRq.ORBillQuery.BillFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007"))
                                        End If
                                        if (ORTxnDateRangeFilterElementType1894 == "DateMacro") then
                                                'Set field value for DateMacro
                                                BillQueryRq.ORBillQuery.BillFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll)
                                        End If
                                End If
                                Dim OREntityFilterElementType1895 as String
                                OREntityFilterElementType1895 = "ListIDList"
                                if (OREntityFilterElementType1895 == "ListIDList") then
                                        'Set field value for ListIDList
                                        'May create more than one of these if needed
                                        BillQueryRq.ORBillQuery.BillFilter.EntityFilter.OREntityFilter.ListIDList.Add("200000-1011023419")
                                End If
                                if (OREntityFilterElementType1895 == "FullNameList") then
                                        'Set field value for FullNameList
                                        'May create more than one of these if needed
                                        BillQueryRq.ORBillQuery.BillFilter.EntityFilter.OREntityFilter.FullNameList.Add("ab")
                                End If
                                if (OREntityFilterElementType1895 == "ListIDWithChildren") then
                                        'Set field value for ListIDWithChildren
                                        BillQueryRq.ORBillQuery.BillFilter.EntityFilter.OREntityFilter.ListIDWithChildren.SetValue("200000-1011023419")
                                End If
                                if (OREntityFilterElementType1895 == "FullNameWithChildren") then
                                        'Set field value for FullNameWithChildren
                                        BillQueryRq.ORBillQuery.BillFilter.EntityFilter.OREntityFilter.FullNameWithChildren.SetValue("ab")
                                End If
                                Dim ORAccountFilterElementType1896 as String
                                ORAccountFilterElementType1896 = "ListIDList"
                                if (ORAccountFilterElementType1896 == "ListIDList") then
                                        'Set field value for ListIDList
                                        'May create more than one of these if needed
                                        BillQueryRq.ORBillQuery.BillFilter.AccountFilter.ORAccountFilter.ListIDList.Add("200000-1011023419")
                                End If
                                if (ORAccountFilterElementType1896 == "FullNameList") then
                                        'Set field value for FullNameList
                                        'May create more than one of these if needed
                                        BillQueryRq.ORBillQuery.BillFilter.AccountFilter.ORAccountFilter.FullNameList.Add("ab")
                                End If
                                if (ORAccountFilterElementType1896 == "ListIDWithChildren") then
                                        'Set field value for ListIDWithChildren
                                        BillQueryRq.ORBillQuery.BillFilter.AccountFilter.ORAccountFilter.ListIDWithChildren.SetValue("200000-1011023419")
                                End If
                                if (ORAccountFilterElementType1896 == "FullNameWithChildren") then
                                        'Set field value for FullNameWithChildren
                                        BillQueryRq.ORBillQuery.BillFilter.AccountFilter.ORAccountFilter.FullNameWithChildren.SetValue("ab")
                                End If
                                Dim ORRefNumberFilterElementType1897 as String
                                ORRefNumberFilterElementType1897 = "RefNumberFilter"
                                if (ORRefNumberFilterElementType1897 == "RefNumberFilter") then
                                        'Set field value for MatchCriterion
                                        BillQueryRq.ORBillQuery.BillFilter.ORRefNumberFilter.RefNumberFilter.MatchCriterion.SetValue(ENMatchCriterion.mcStartsWith)
                                        'Set field value for RefNumber
                                        BillQueryRq.ORBillQuery.BillFilter.ORRefNumberFilter.RefNumberFilter.RefNumber.SetValue("ab")
                                End If
                                if (ORRefNumberFilterElementType1897 == "RefNumberRangeFilter") then
                                        'Set field value for FromRefNumber
                                        BillQueryRq.ORBillQuery.BillFilter.ORRefNumberFilter.RefNumberRangeFilter.FromRefNumber.SetValue("ab")
                                        'Set field value for ToRefNumber
                                        BillQueryRq.ORBillQuery.BillFilter.ORRefNumberFilter.RefNumberRangeFilter.ToRefNumber.SetValue("ab")
                                End If
                                Dim ORCurrencyFilterElementType1898 as String
                                ORCurrencyFilterElementType1898 = "ListIDList"
                                if (ORCurrencyFilterElementType1898 == "ListIDList") then
                                        'Set field value for ListIDList
                                        'May create more than one of these if needed
                                        BillQueryRq.ORBillQuery.BillFilter.CurrencyFilter.ORCurrencyFilter.ListIDList.Add("200000-1011023419")
                                End If
                                if (ORCurrencyFilterElementType1898 == "FullNameList") then
                                        'Set field value for FullNameList
                                        'May create more than one of these if needed
                                        BillQueryRq.ORBillQuery.BillFilter.CurrencyFilter.ORCurrencyFilter.FullNameList.Add("ab")
                                End If
                                'Set field value for PaidStatus
                                BillQueryRq.ORBillQuery.BillFilter.PaidStatus.SetValue(ENPaidStatus.psAll [DEFAULT])
                        End If
                        'Set field value for IncludeLineItems
                        BillQueryRq.IncludeLineItems.SetValue(True)
                        'Set field value for IncludeLinkedTxns
                        BillQueryRq.IncludeLinkedTxns.SetValue(True)
                        'Set field value for IncludeRetElementList
                        'May create more than one of these if needed
                        BillQueryRq.IncludeRetElementList.Add("ab")
                        'Set field value for OwnerIDList
                        'May create more than one of these if needed
                        BillQueryRq.OwnerIDList.Add(System.Guid.NewGuid().ToString())
                End Sub




                Public Sub WalkBillQueryRs( responseMsgSet as IMsgSetResponse)
                        if (responseMsgSet is nothing) then
                                Exit Sub
                        End If

                        Dim responseList as IResponseList
                        responseList = responseMsgSet.ResponseList
                        if (responseList is nothing) then
                                Exit Sub
                        End If

                        'if we sent only one request, there is only one response, we'll walk the list for this sample
                        for j=0 to responseList.Count-1
                                Dim response as IResponse
                                response = responseList.GetAt(j)
                                'check the status code of the response, 0=ok, >0 is warning
                                if (response.StatusCode >= 0) then
                                        'the request-specific response is in the details, make sure we have some
                                        if (not response.Detail is nothing) then
                                                'make sure the response is the type we're expecting
                                                Dim responseType as ENResponseType
                                                responseType = CType(response.Type.GetValue(),ENResponseType)
                                                if (responseType == ENResponseType.rtBillQueryRs) then
                                                        'upcast to more specific type here, this is safe because we checked with response.Type check above
                                                        Dim BillRet as IBillRetList
                                                        BillRet = CType(response.Detail,IBillRetList)
                                                        WalkBillRet(BillRet)
                                                End If
                                        End If
                                End If
                        Next j
                End Sub




                Public Sub WalkBillRet(BillRet as IBillRetList)
                        if (BillRet is nothing) then
                                Exit Sub
                        End If

                        'Go through all the elements of IBillRetList
                        'Get value of TxnID
                        Dim TxnID1899 as String
                        TxnID1899 = BillRet.TxnID.GetValue()
                        'Get value of TimeCreated
                        Dim TimeCreated1900 as DateTime
                        TimeCreated1900 = BillRet.TimeCreated.GetValue()
                        'Get value of TimeModified
                        Dim TimeModified1901 as DateTime
                        TimeModified1901 = BillRet.TimeModified.GetValue()
                        'Get value of EditSequence
                        Dim EditSequence1902 as String
                        EditSequence1902 = BillRet.EditSequence.GetValue()
                        'Get value of TxnNumber
                        if ( not BillRet.TxnNumber is nothing) then
                                Dim TxnNumber1903 as Integer
                                TxnNumber1903 = BillRet.TxnNumber.GetValue()
                        End If
                        'Get value of ListID
                        if ( not BillRet.VendorRef.ListID is nothing) then
                                Dim ListID1904 as String
                                ListID1904 = BillRet.VendorRef.ListID.GetValue()
                        End If
                        'Get value of FullName
                        if ( not BillRet.VendorRef.FullName is nothing) then
                                Dim FullName1905 as String
                                FullName1905 = BillRet.VendorRef.FullName.GetValue()
                        End If
                        if (not BillRet.VendorAddress. is nothing) then
                                'Get value of Addr1
                                if ( not BillRet.VendorAddress.Addr1 is nothing) then
                                        Dim Addr11906 as String
                                        Addr11906 = BillRet.VendorAddress.Addr1.GetValue()
                                End If
                                'Get value of Addr2
                                if ( not BillRet.VendorAddress.Addr2 is nothing) then
                                        Dim Addr21907 as String
                                        Addr21907 = BillRet.VendorAddress.Addr2.GetValue()
                                End If
                                'Get value of Addr3
                                if ( not BillRet.VendorAddress.Addr3 is nothing) then
                                        Dim Addr31908 as String
                                        Addr31908 = BillRet.VendorAddress.Addr3.GetValue()
                                End If
                                'Get value of Addr4
                                if ( not BillRet.VendorAddress.Addr4 is nothing) then
                                        Dim Addr41909 as String
                                        Addr41909 = BillRet.VendorAddress.Addr4.GetValue()
                                End If
                                'Get value of Addr5
                                if ( not BillRet.VendorAddress.Addr5 is nothing) then
                                        Dim Addr51910 as String
                                        Addr51910 = BillRet.VendorAddress.Addr5.GetValue()
                                End If
                                'Get value of City
                                if ( not BillRet.VendorAddress.City is nothing) then
                                        Dim City1911 as String
                                        City1911 = BillRet.VendorAddress.City.GetValue()
                                End If
                                'Get value of State
                                if ( not BillRet.VendorAddress.State is nothing) then
                                        Dim State1912 as String
                                        State1912 = BillRet.VendorAddress.State.GetValue()
                                End If
                                'Get value of PostalCode
                                if ( not BillRet.VendorAddress.PostalCode is nothing) then
                                        Dim PostalCode1913 as String
                                        PostalCode1913 = BillRet.VendorAddress.PostalCode.GetValue()
                                End If
                                'Get value of Country
                                if ( not BillRet.VendorAddress.Country is nothing) then
                                        Dim Country1914 as String
                                        Country1914 = BillRet.VendorAddress.Country.GetValue()
                                End If
                                'Get value of Note
                                if ( not BillRet.VendorAddress.Note is nothing) then
                                        Dim Note1915 as String
                                        Note1915 = BillRet.VendorAddress.Note.GetValue()
                                End If
                        End If
                        if (not BillRet.APAccountRef. is nothing) then
                                'Get value of ListID
                                if ( not BillRet.APAccountRef.ListID is nothing) then
                                        Dim ListID1916 as String
                                        ListID1916 = BillRet.APAccountRef.ListID.GetValue()
                                End If
                                'Get value of FullName
                                if ( not BillRet.APAccountRef.FullName is nothing) then
                                        Dim FullName1917 as String
                                        FullName1917 = BillRet.APAccountRef.FullName.GetValue()
                                End If
                        End If
                        'Get value of TxnDate
                        Dim TxnDate1918 as DateTime
                        TxnDate1918 = BillRet.TxnDate.GetValue()
                        'Get value of DueDate
                        if ( not BillRet.DueDate is nothing) then
                                Dim DueDate1919 as DateTime
                                DueDate1919 = BillRet.DueDate.GetValue()
                        End If
                        'Get value of AmountDue
                        Dim AmountDue1920 as Double
                        AmountDue1920 = BillRet.AmountDue.GetValue()
                        if (not BillRet.CurrencyRef. is nothing) then
                                'Get value of ListID
                                if ( not BillRet.CurrencyRef.ListID is nothing) then
                                        Dim ListID1921 as String
                                        ListID1921 = BillRet.CurrencyRef.ListID.GetValue()
                                End If
                                'Get value of FullName
                                if ( not BillRet.CurrencyRef.FullName is nothing) then
                                        Dim FullName1922 as String
                                        FullName1922 = BillRet.CurrencyRef.FullName.GetValue()
                                End If
                        End If
                        'Get value of ExchangeRate
                        if ( not BillRet.ExchangeRate is nothing) then
                                Dim ExchangeRate1923 as IQBFloatType
                                ExchangeRate1923 = BillRet.ExchangeRate.GetValue()
                        End If
                        'Get value of AmountDueInHomeCurrency
                        if ( not BillRet.AmountDueInHomeCurrency is nothing) then
                                Dim AmountDueInHomeCurrency1924 as Double
                                AmountDueInHomeCurrency1924 = BillRet.AmountDueInHomeCurrency.GetValue()
                        End If
                        'Get value of RefNumber
                        if ( not BillRet.RefNumber is nothing) then
                                Dim RefNumber1925 as String
                                RefNumber1925 = BillRet.RefNumber.GetValue()
                        End If
                        'Get value of IsPending
                        if ( not BillRet.IsPending is nothing) then
                                Dim isPending as Boolean
                                isPending = BillRet.IsPending.GetValue()
                        End If
                        if (not BillRet.TermsRef. is nothing) then
                                'Get value of ListID
                                if ( not BillRet.TermsRef.ListID is nothing) then
                                        Dim ListID1926 as String
                                        ListID1926 = BillRet.TermsRef.ListID.GetValue()
                                End If
                                'Get value of FullName
                                if ( not BillRet.TermsRef.FullName is nothing) then
                                        Dim FullName1927 as String
                                        FullName1927 = BillRet.TermsRef.FullName.GetValue()
                                End If
                        End If
                        'Get value of Memo
                        if ( not BillRet.Memo is nothing) then
                                Dim Memo1928 as String
                                Memo1928 = BillRet.Memo.GetValue()
                        End If
                        'Get value of IsTaxIncluded
                        if ( not BillRet.IsTaxIncluded is nothing) then
                                Dim IsTaxIncluded1929 as Boolean
                                IsTaxIncluded1929 = BillRet.IsTaxIncluded.GetValue()
                        End If
                        if (not BillRet.SalesTaxCodeRef. is nothing) then
                                'Get value of ListID
                                if ( not BillRet.SalesTaxCodeRef.ListID is nothing) then
                                        Dim ListID1930 as String
                                        ListID1930 = BillRet.SalesTaxCodeRef.ListID.GetValue()
                                End If
                                'Get value of FullName
                                if ( not BillRet.SalesTaxCodeRef.FullName is nothing) then
                                        Dim FullName1931 as String
                                        FullName1931 = BillRet.SalesTaxCodeRef.FullName.GetValue()
                                End If
                        End If
                        'Get value of IsPaid
                        if ( not BillRet.IsPaid is nothing) then
                                Dim IsPaid1932 as Boolean
                                IsPaid1932 = BillRet.IsPaid.GetValue()
                        End If
                        'Get value of ExternalGUID
                        if ( not BillRet.ExternalGUID is nothing) then
                                Dim ExternalGUID1933 as String
                                ExternalGUID1933 = BillRet.ExternalGUID.GetValue()
                        End If
                        if (not BillRet.LinkedTxnList is nothing)
                                Dim i1934 as Integer
                                for i1934 = 0  to BillRet.LinkedTxnList.Count - 1
                                        Dim LinkedTxn as ILinkedTxn
                                        LinkedTxn = BillRet.LinkedTxnList.GetAt(i1934)
                                        'Get value of TxnID
                                        Dim TxnID1935 as String
                                        TxnID1935 = LinkedTxnTxnID.GetValue()
                                        'Get value of TxnType
                                        Dim TxnType1936 as ENTxnType
                                        TxnType1936 = LinkedTxnTxnType.GetValue()
                                        'Get value of TxnDate
                                        Dim TxnDate1937 as DateTime
                                        TxnDate1937 = LinkedTxnTxnDate.GetValue()
                                        'Get value of RefNumber
                                        if ( not LinkedTxnRefNumber is nothing) then
                                                Dim RefNumber1938 as String
                                                RefNumber1938 = LinkedTxnRefNumber.GetValue()
                                        End If
                                        'Get value of LinkType
                                        if ( not LinkedTxnLinkType is nothing) then
                                                Dim LinkType1939 as ENLinkType
                                                LinkType1939 = LinkedTxnLinkType.GetValue()
                                        End If
                                        'Get value of Amount
                                        Dim Amount1940 as Double
                                        Amount1940 = LinkedTxnAmount.GetValue()
                                Next i1934
                        End If
                        if (not BillRet.ExpenseLineRetList is nothing)
                                Dim i1941 as Integer
                                for i1941 = 0  to BillRet.ExpenseLineRetList.Count - 1
                                        Dim ExpenseLineRet as IExpenseLineRet
                                        ExpenseLineRet = BillRet.ExpenseLineRetList.GetAt(i1941)
                                        'Get value of TxnLineID
                                        Dim TxnLineID1942 as String
                                        TxnLineID1942 = ExpenseLineRetTxnLineID.GetValue()
                                        if (not ExpenseLineRetAccountRef. is nothing) then
                                                'Get value of ListID
                                                if ( not ExpenseLineRetAccountRef.ListID is nothing) then
                                                        Dim ListID1943 as String
                                                        ListID1943 = ExpenseLineRetAccountRef.ListID.GetValue()
                                                End If
                                                'Get value of FullName
                                                if ( not ExpenseLineRetAccountRef.FullName is nothing) then
                                                        Dim FullName1944 as String
                                                        FullName1944 = ExpenseLineRetAccountRef.FullName.GetValue()
                                                End If
                                        End If
                                        'Get value of Amount
                                        if ( not ExpenseLineRetAmount is nothing) then
                                                Dim Amount1945 as Double
                                                Amount1945 = ExpenseLineRetAmount.GetValue()
                                        End If
                                        'Get value of Memo
                                        if ( not ExpenseLineRetMemo is nothing) then
                                                Dim Memo1946 as String
                                                Memo1946 = ExpenseLineRetMemo.GetValue()
                                        End If
                                        if (not ExpenseLineRetCustomerRef. is nothing) then
                                                'Get value of ListID
                                                if ( not ExpenseLineRetCustomerRef.ListID is nothing) then
                                                        Dim ListID1947 as String
                                                        ListID1947 = ExpenseLineRetCustomerRef.ListID.GetValue()
                                                End If
                                                'Get value of FullName
                                                if ( not ExpenseLineRetCustomerRef.FullName is nothing) then
                                                        Dim FullName1948 as String
                                                        FullName1948 = ExpenseLineRetCustomerRef.FullName.GetValue()
                                                End If
                                        End If
                                        if (not ExpenseLineRetClassRef. is nothing) then
                                                'Get value of ListID
                                                if ( not ExpenseLineRetClassRef.ListID is nothing) then
                                                        Dim ListID1949 as String
                                                        ListID1949 = ExpenseLineRetClassRef.ListID.GetValue()
                                                End If
                                                'Get value of FullName
                                                if ( not ExpenseLineRetClassRef.FullName is nothing) then
                                                        Dim FullName1950 as String
                                                        FullName1950 = ExpenseLineRetClassRef.FullName.GetValue()
                                                End If
                                        End If
                                        if (not ExpenseLineRetSalesTaxCodeRef. is nothing) then
                                                'Get value of ListID
                                                if ( not ExpenseLineRetSalesTaxCodeRef.ListID is nothing) then
                                                        Dim ListID1951 as String
                                                        ListID1951 = ExpenseLineRetSalesTaxCodeRef.ListID.GetValue()
                                                End If
                                                'Get value of FullName
                                                if ( not ExpenseLineRetSalesTaxCodeRef.FullName is nothing) then
                                                        Dim FullName1952 as String
                                                        FullName1952 = ExpenseLineRetSalesTaxCodeRef.FullName.GetValue()
                                                End If
                                        End If
                                        'Get value of BillableStatus
                                        if ( not ExpenseLineRetBillableStatus is nothing) then
                                                Dim BillableStatus1953 as ENBillableStatus
                                                BillableStatus1953 = ExpenseLineRetBillableStatus.GetValue()
                                        End If
                                        if (not ExpenseLineRetSalesRepRef. is nothing) then
                                                'Get value of ListID
                                                if ( not ExpenseLineRetSalesRepRef.ListID is nothing) then
                                                        Dim ListID1954 as String
                                                        ListID1954 = ExpenseLineRetSalesRepRef.ListID.GetValue()
                                                End If
                                                'Get value of FullName
                                                if ( not ExpenseLineRetSalesRepRef.FullName is nothing) then
                                                        Dim FullName1955 as String
                                                        FullName1955 = ExpenseLineRetSalesRepRef.FullName.GetValue()
                                                End If
                                        End If
                                        if (not ExpenseLineRetDataExtRetList is nothing)
                                                Dim i1956 as Integer
                                                for i1956 = 0  to ExpenseLineRetDataExtRetList.Count - 1
                                                        Dim DataExtRet as IDataExtRet
                                                        DataExtRet = ExpenseLineRetDataExtRetList.GetAt(i1956)
                                                        'Get value of OwnerID
                                                        if ( not DataExtRetOwnerID is nothing) then
                                                                Dim OwnerID1957 as String
                                                                OwnerID1957 = DataExtRetOwnerID.GetValue()
                                                        End If
                                                        'Get value of DataExtName
                                                        Dim DataExtName1958 as String
                                                        DataExtName1958 = DataExtRetDataExtName.GetValue()
                                                        'Get value of DataExtType
                                                        Dim DataExtType1959 as ENDataExtType
                                                        DataExtType1959 = DataExtRetDataExtType.GetValue()
                                                        'Get value of DataExtValue
                                                        Dim DataExtValue1960 as String
                                                        DataExtValue1960 = DataExtRetDataExtValue.GetValue()
                                                Next i1956
                                        End If
                                Next i1941
                        End If
                        if (not BillRet.ORItemLineRetList is nothing) then
                                Dim i1961 as Integer
                                for i1961 = 0 to BillRet.ORItemLineRetList.Count - 1
                                        Dim ORItemLineRet1962 as IORItemLineRet
                                        ORItemLineRet1962 = BillRet.ORItemLineRetList.GetAt(i1961)
                                        if (not ORItemLineRet1962.ItemLineRet is nothing) then
                                                if (not ORItemLineRet1962.ItemLineRet. is nothing) then
                                                        'Get value of TxnLineID
                                                        Dim TxnLineID1963 as String
                                                        TxnLineID1963 = ORItemLineRet1962.ItemLineRet.TxnLineID.GetValue()
                                                        if (not ORItemLineRet1962.ItemLineRet.ItemRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORItemLineRet1962.ItemLineRet.ItemRef.ListID is nothing) then
                                                                        Dim ListID1964 as String
                                                                        ListID1964 = ORItemLineRet1962.ItemLineRet.ItemRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORItemLineRet1962.ItemLineRet.ItemRef.FullName is nothing) then
                                                                        Dim FullName1965 as String
                                                                        FullName1965 = ORItemLineRet1962.ItemLineRet.ItemRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        if (not ORItemLineRet1962.ItemLineRet.InventorySiteRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORItemLineRet1962.ItemLineRet.InventorySiteRef.ListID is nothing) then
                                                                        Dim ListID1966 as String
                                                                        ListID1966 = ORItemLineRet1962.ItemLineRet.InventorySiteRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORItemLineRet1962.ItemLineRet.InventorySiteRef.FullName is nothing) then
                                                                        Dim FullName1967 as String
                                                                        FullName1967 = ORItemLineRet1962.ItemLineRet.InventorySiteRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        if (not ORItemLineRet1962.ItemLineRet.InventorySiteLocationRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORItemLineRet1962.ItemLineRet.InventorySiteLocationRef.ListID is nothing) then
                                                                        Dim ListID1968 as String
                                                                        ListID1968 = ORItemLineRet1962.ItemLineRet.InventorySiteLocationRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORItemLineRet1962.ItemLineRet.InventorySiteLocationRef.FullName is nothing) then
                                                                        Dim FullName1969 as String
                                                                        FullName1969 = ORItemLineRet1962.ItemLineRet.InventorySiteLocationRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        if (not ORItemLineRet1962.ItemLineRet.ORSerialLotNumber is nothing) then
                                                                if (not ORItemLineRet1962.ItemLineRet.ORSerialLotNumber.SerialNumber is nothing) then
                                                                        'Get value of SerialNumber
                                                                        if ( not ORItemLineRet1962.ItemLineRet.ORSerialLotNumber.SerialNumber is nothing) then
                                                                                Dim SerialNumber1971 as String
                                                                                SerialNumber1971 = ORItemLineRet1962.ItemLineRet.ORSerialLotNumber.SerialNumber.GetValue()
                                                                        End If
                                                                End If
                                                                if (not ORItemLineRet1962.ItemLineRet.ORSerialLotNumber.LotNumber is nothing) then
                                                                        'Get value of LotNumber
                                                                        if ( not ORItemLineRet1962.ItemLineRet.ORSerialLotNumber.LotNumber is nothing) then
                                                                                Dim LotNumber1972 as String
                                                                                LotNumber1972 = ORItemLineRet1962.ItemLineRet.ORSerialLotNumber.LotNumber.GetValue()
                                                                        End If
                                                                End If
                                                        End If
                                                        'Get value of ExpirationDateForSerialLotNumber
                                                        if ( not ORItemLineRet1962.ItemLineRet.ExpirationDateForSerialLotNumber is nothing) then
                                                                Dim ExpDate as String
                                                                ExpDate = ORItemLineRet1962.ItemLineRet.ExpirationDateForSerialLotNumber.GetValue()
                                                        End If
                                                        'Get value of Desc
                                                        if ( not ORItemLineRet1962.ItemLineRet.Desc is nothing) then
                                                                Dim Desc1973 as String
                                                                Desc1973 = ORItemLineRet1962.ItemLineRet.Desc.GetValue()
                                                        End If
                                                        'Get value of Quantity
                                                        if ( not ORItemLineRet1962.ItemLineRet.Quantity is nothing) then
                                                                Dim Quantity1974 as Integer
                                                                Quantity1974 = ORItemLineRet1962.ItemLineRet.Quantity.GetValue()
                                                        End If
                                                        'Get value of UnitOfMeasure
                                                        if ( not ORItemLineRet1962.ItemLineRet.UnitOfMeasure is nothing) then
                                                                Dim UnitOfMeasure1975 as String
                                                                UnitOfMeasure1975 = ORItemLineRet1962.ItemLineRet.UnitOfMeasure.GetValue()
                                                        End If
                                                        if (not ORItemLineRet1962.ItemLineRet.OverrideUOMSetRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORItemLineRet1962.ItemLineRet.OverrideUOMSetRef.ListID is nothing) then
                                                                        Dim ListID1976 as String
                                                                        ListID1976 = ORItemLineRet1962.ItemLineRet.OverrideUOMSetRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORItemLineRet1962.ItemLineRet.OverrideUOMSetRef.FullName is nothing) then
                                                                        Dim FullName1977 as String
                                                                        FullName1977 = ORItemLineRet1962.ItemLineRet.OverrideUOMSetRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        'Get value of Cost
                                                        if ( not ORItemLineRet1962.ItemLineRet.Cost is nothing) then
                                                                Dim Cost1978 as Double
                                                                Cost1978 = ORItemLineRet1962.ItemLineRet.Cost.GetValue()
                                                        End If
                                                        'Get value of Amount
                                                        if ( not ORItemLineRet1962.ItemLineRet.Amount is nothing) then
                                                                Dim Amount1979 as Double
                                                                Amount1979 = ORItemLineRet1962.ItemLineRet.Amount.GetValue()
                                                        End If
                                                        if (not ORItemLineRet1962.ItemLineRet.CustomerRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORItemLineRet1962.ItemLineRet.CustomerRef.ListID is nothing) then
                                                                        Dim ListID1980 as String
                                                                        ListID1980 = ORItemLineRet1962.ItemLineRet.CustomerRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORItemLineRet1962.ItemLineRet.CustomerRef.FullName is nothing) then
                                                                        Dim FullName1981 as String
                                                                        FullName1981 = ORItemLineRet1962.ItemLineRet.CustomerRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        if (not ORItemLineRet1962.ItemLineRet.ClassRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORItemLineRet1962.ItemLineRet.ClassRef.ListID is nothing) then
                                                                        Dim ListID1982 as String
                                                                        ListID1982 = ORItemLineRet1962.ItemLineRet.ClassRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORItemLineRet1962.ItemLineRet.ClassRef.FullName is nothing) then
                                                                        Dim FullName1983 as String
                                                                        FullName1983 = ORItemLineRet1962.ItemLineRet.ClassRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        if (not ORItemLineRet1962.ItemLineRet.SalesTaxCodeRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORItemLineRet1962.ItemLineRet.SalesTaxCodeRef.ListID is nothing) then
                                                                        Dim ListID1984 as String
                                                                        ListID1984 = ORItemLineRet1962.ItemLineRet.SalesTaxCodeRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORItemLineRet1962.ItemLineRet.SalesTaxCodeRef.FullName is nothing) then
                                                                        Dim FullName1985 as String
                                                                        FullName1985 = ORItemLineRet1962.ItemLineRet.SalesTaxCodeRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        'Get value of BillableStatus
                                                        if ( not ORItemLineRet1962.ItemLineRet.BillableStatus is nothing) then
                                                                Dim BillableStatus1986 as ENBillableStatus
                                                                BillableStatus1986 = ORItemLineRet1962.ItemLineRet.BillableStatus.GetValue()
                                                        End If
                                                        if (not ORItemLineRet1962.ItemLineRet.SalesRepRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORItemLineRet1962.ItemLineRet.SalesRepRef.ListID is nothing) then
                                                                        Dim ListID1987 as String
                                                                        ListID1987 = ORItemLineRet1962.ItemLineRet.SalesRepRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORItemLineRet1962.ItemLineRet.SalesRepRef.FullName is nothing) then
                                                                        Dim FullName1988 as String
                                                                        FullName1988 = ORItemLineRet1962.ItemLineRet.SalesRepRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        if (not ORItemLineRet1962.ItemLineRet.DataExtRetList is nothing)
                                                                Dim i1989 as Integer
                                                                for i1989 = 0  to ORItemLineRet1962.ItemLineRet.DataExtRetList.Count - 1
                                                                        Dim DataExtRet as IDataExtRet
                                                                        DataExtRet = ORItemLineRet1962.ItemLineRet.DataExtRetList.GetAt(i1989)
                                                                        'Get value of OwnerID
                                                                        if ( not DataExtRetOwnerID is nothing) then
                                                                                Dim OwnerID1990 as String
                                                                                OwnerID1990 = DataExtRetOwnerID.GetValue()
                                                                        End If
                                                                        'Get value of DataExtName
                                                                        Dim DataExtName1991 as String
                                                                        DataExtName1991 = DataExtRetDataExtName.GetValue()
                                                                        'Get value of DataExtType
                                                                        Dim DataExtType1992 as ENDataExtType
                                                                        DataExtType1992 = DataExtRetDataExtType.GetValue()
                                                                        'Get value of DataExtValue
                                                                        Dim DataExtValue1993 as String
                                                                        DataExtValue1993 = DataExtRetDataExtValue.GetValue()
                                                                Next i1989
                                                        End If
                                                End If
                                        End If
                                        if (not ORItemLineRet1962.ItemGroupLineRet is nothing) then
                                                if (not ORItemLineRet1962.ItemGroupLineRet. is nothing) then
                                                        'Get value of TxnLineID
                                                        Dim TxnLineID1994 as String
                                                        TxnLineID1994 = ORItemLineRet1962.ItemGroupLineRet.TxnLineID.GetValue()
                                                        'Get value of ListID
                                                        if ( not ORItemLineRet1962.ItemGroupLineRet.ItemGroupRef.ListID is nothing) then
                                                                Dim ListID1995 as String
                                                                ListID1995 = ORItemLineRet1962.ItemGroupLineRet.ItemGroupRef.ListID.GetValue()
                                                        End If
                                                        'Get value of FullName
                                                        if ( not ORItemLineRet1962.ItemGroupLineRet.ItemGroupRef.FullName is nothing) then
                                                                Dim FullName1996 as String
                                                                FullName1996 = ORItemLineRet1962.ItemGroupLineRet.ItemGroupRef.FullName.GetValue()
                                                        End If
                                                        'Get value of Desc
                                                        if ( not ORItemLineRet1962.ItemGroupLineRet.Desc is nothing) then
                                                                Dim Desc1997 as String
                                                                Desc1997 = ORItemLineRet1962.ItemGroupLineRet.Desc.GetValue()
                                                        End If
                                                        'Get value of Quantity
                                                        if ( not ORItemLineRet1962.ItemGroupLineRet.Quantity is nothing) then
                                                                Dim Quantity1998 as Integer
                                                                Quantity1998 = ORItemLineRet1962.ItemGroupLineRet.Quantity.GetValue()
                                                        End If
                                                        'Get value of UnitOfMeasure
                                                        if ( not ORItemLineRet1962.ItemGroupLineRet.UnitOfMeasure is nothing) then
                                                                Dim UnitOfMeasure1999 as String
                                                                UnitOfMeasure1999 = ORItemLineRet1962.ItemGroupLineRet.UnitOfMeasure.GetValue()
                                                        End If
                                                        if (not ORItemLineRet1962.ItemGroupLineRet.OverrideUOMSetRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORItemLineRet1962.ItemGroupLineRet.OverrideUOMSetRef.ListID is nothing) then
                                                                        Dim ListID2000 as String
                                                                        ListID2000 = ORItemLineRet1962.ItemGroupLineRet.OverrideUOMSetRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORItemLineRet1962.ItemGroupLineRet.OverrideUOMSetRef.FullName is nothing) then
                                                                        Dim FullName2001 as String
                                                                        FullName2001 = ORItemLineRet1962.ItemGroupLineRet.OverrideUOMSetRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        'Get value of TotalAmount
                                                        Dim TotalAmount2002 as Double
                                                        TotalAmount2002 = ORItemLineRet1962.ItemGroupLineRet.TotalAmount.GetValue()
                                                        if (not ORItemLineRet1962.ItemGroupLineRet.ItemLineRetList is nothing)
                                                                Dim i2003 as Integer
                                                                for i2003 = 0  to ORItemLineRet1962.ItemGroupLineRet.ItemLineRetList.Count - 1
                                                                        Dim ItemLineRet as IItemLineRet
                                                                        ItemLineRet = ORItemLineRet1962.ItemGroupLineRet.ItemLineRetList.GetAt(i2003)
                                                                        'Get value of TxnLineID
                                                                        Dim TxnLineID2004 as String
                                                                        TxnLineID2004 = ItemLineRetTxnLineID.GetValue()
                                                                        if (not ItemLineRetItemRef. is nothing) then
                                                                                'Get value of ListID
                                                                                if ( not ItemLineRetItemRef.ListID is nothing) then
                                                                                Dim ListID2005 as String
                                                                                ListID2005 = ItemLineRetItemRef.ListID.GetValue()
                                                                                End If
                                                                                'Get value of FullName
                                                                                if ( not ItemLineRetItemRef.FullName is nothing) then
                                                                                Dim FullName2006 as String
                                                                                FullName2006 = ItemLineRetItemRef.FullName.GetValue()
                                                                                End If
                                                                        End If
                                                                        if (not ItemLineRetInventorySiteRef. is nothing) then
                                                                                'Get value of ListID
                                                                                if ( not ItemLineRetInventorySiteRef.ListID is nothing) then
                                                                                Dim ListID2007 as String
                                                                                ListID2007 = ItemLineRetInventorySiteRef.ListID.GetValue()
                                                                                End If
                                                                                'Get value of FullName
                                                                                if ( not ItemLineRetInventorySiteRef.FullName is nothing) then
                                                                                Dim FullName2008 as String
                                                                                FullName2008 = ItemLineRetInventorySiteRef.FullName.GetValue()
                                                                                End If
                                                                        End If
                                                                        if (not ItemLineRetInventorySiteLocationRef. is nothing) then
                                                                                'Get value of ListID
                                                                                if ( not ItemLineRetInventorySiteLocationRef.ListID is nothing) then
                                                                                Dim ListID2009 as String
                                                                                ListID2009 = ItemLineRetInventorySiteLocationRef.ListID.GetValue()
                                                                                End If
                                                                                'Get value of FullName
                                                                                if ( not ItemLineRetInventorySiteLocationRef.FullName is nothing) then
                                                                                Dim FullName2010 as String
                                                                                FullName2010 = ItemLineRetInventorySiteLocationRef.FullName.GetValue()
                                                                                End If
                                                                        End If
                                                                        if (not ItemLineRetORSerialLotNumber is nothing) then
                                                                                if (not ItemLineRetORSerialLotNumber.SerialNumber is nothing) then
                                                                                'Get value of SerialNumber
                                                                                if ( not ItemLineRetORSerialLotNumber.SerialNumber is nothing) then
                                                                                Dim SerialNumber2012 as String
                                                                                SerialNumber2012 = ItemLineRetORSerialLotNumber.SerialNumber.GetValue()
                                                                                End If
                                                                                End If
                                                                                if (not ItemLineRetORSerialLotNumber.LotNumber is nothing) then
                                                                                'Get value of LotNumber
                                                                                if ( not ItemLineRetORSerialLotNumber.LotNumber is nothing) then
                                                                                Dim LotNumber2013 as String
                                                                                LotNumber2013 = ItemLineRetORSerialLotNumber.LotNumber.GetValue()
                                                                                End If
                                                                                End If
                                                                        End If
                                                                        'Get value of ExpirationDateForSerialLotNumber
                                                                        if ( not ItemLineRetExpirationDateForSerialLotNumber is nothing) then
                                                                                Dim ExpDate as String
                                                                                ExpDate = ItemLineRetExpirationDateForSerialLotNumber.GetValue()
                                                                        End If
                                                                        'Get value of Desc
                                                                        if ( not ItemLineRetDesc is nothing) then
                                                                                Dim Desc2014 as String
                                                                                Desc2014 = ItemLineRetDesc.GetValue()
                                                                        End If
                                                                        'Get value of Quantity
                                                                        if ( not ItemLineRetQuantity is nothing) then
                                                                                Dim Quantity2015 as Integer
                                                                                Quantity2015 = ItemLineRetQuantity.GetValue()
                                                                        End If
                                                                        'Get value of UnitOfMeasure
                                                                        if ( not ItemLineRetUnitOfMeasure is nothing) then
                                                                                Dim UnitOfMeasure2016 as String
                                                                                UnitOfMeasure2016 = ItemLineRetUnitOfMeasure.GetValue()
                                                                        End If
                                                                        if (not ItemLineRetOverrideUOMSetRef. is nothing) then
                                                                                'Get value of ListID
                                                                                if ( not ItemLineRetOverrideUOMSetRef.ListID is nothing) then
                                                                                Dim ListID2017 as String
                                                                                ListID2017 = ItemLineRetOverrideUOMSetRef.ListID.GetValue()
                                                                                End If
                                                                                'Get value of FullName
                                                                                if ( not ItemLineRetOverrideUOMSetRef.FullName is nothing) then
                                                                                Dim FullName2018 as String
                                                                                FullName2018 = ItemLineRetOverrideUOMSetRef.FullName.GetValue()
                                                                                End If
                                                                        End If
                                                                        'Get value of Cost
                                                                        if ( not ItemLineRetCost is nothing) then
                                                                                Dim Cost2019 as Double
                                                                                Cost2019 = ItemLineRetCost.GetValue()
                                                                        End If
                                                                        'Get value of Amount
                                                                        if ( not ItemLineRetAmount is nothing) then
                                                                                Dim Amount2020 as Double
                                                                                Amount2020 = ItemLineRetAmount.GetValue()
                                                                        End If
                                                                        if (not ItemLineRetCustomerRef. is nothing) then
                                                                                'Get value of ListID
                                                                                if ( not ItemLineRetCustomerRef.ListID is nothing) then
                                                                                Dim ListID2021 as String
                                                                                ListID2021 = ItemLineRetCustomerRef.ListID.GetValue()
                                                                                End If
                                                                                'Get value of FullName
                                                                                if ( not ItemLineRetCustomerRef.FullName is nothing) then
                                                                                Dim FullName2022 as String
                                                                                FullName2022 = ItemLineRetCustomerRef.FullName.GetValue()
                                                                                End If
                                                                        End If
                                                                        if (not ItemLineRetClassRef. is nothing) then
                                                                                'Get value of ListID
                                                                                if ( not ItemLineRetClassRef.ListID is nothing) then
                                                                                Dim ListID2023 as String
                                                                                ListID2023 = ItemLineRetClassRef.ListID.GetValue()
                                                                                End If
                                                                                'Get value of FullName
                                                                                if ( not ItemLineRetClassRef.FullName is nothing) then
                                                                                Dim FullName2024 as String
                                                                                FullName2024 = ItemLineRetClassRef.FullName.GetValue()
                                                                                End If
                                                                        End If
                                                                        if (not ItemLineRetSalesTaxCodeRef. is nothing) then
                                                                                'Get value of ListID
                                                                                if ( not ItemLineRetSalesTaxCodeRef.ListID is nothing) then
                                                                                Dim ListID2025 as String
                                                                                ListID2025 = ItemLineRetSalesTaxCodeRef.ListID.GetValue()
                                                                                End If
                                                                                'Get value of FullName
                                                                                if ( not ItemLineRetSalesTaxCodeRef.FullName is nothing) then
                                                                                Dim FullName2026 as String
                                                                                FullName2026 = ItemLineRetSalesTaxCodeRef.FullName.GetValue()
                                                                                End If
                                                                        End If
                                                                        'Get value of BillableStatus
                                                                        if ( not ItemLineRetBillableStatus is nothing) then
                                                                                Dim BillableStatus2027 as ENBillableStatus
                                                                                BillableStatus2027 = ItemLineRetBillableStatus.GetValue()
                                                                        End If
                                                                        if (not ItemLineRetSalesRepRef. is nothing) then
                                                                                'Get value of ListID
                                                                                if ( not ItemLineRetSalesRepRef.ListID is nothing) then
                                                                                Dim ListID2028 as String
                                                                                ListID2028 = ItemLineRetSalesRepRef.ListID.GetValue()
                                                                                End If
                                                                                'Get value of FullName
                                                                                if ( not ItemLineRetSalesRepRef.FullName is nothing) then
                                                                                Dim FullName2029 as String
                                                                                FullName2029 = ItemLineRetSalesRepRef.FullName.GetValue()
                                                                                End If
                                                                        End If
                                                                        if (not ItemLineRetDataExtRetList is nothing)
                                                                                Dim i2030 as Integer
                                                                                for i2030 = 0  to ItemLineRetDataExtRetList.Count - 1
                                                                                Dim DataExtRet as IDataExtRet
                                                                                DataExtRet = ItemLineRetDataExtRetList.GetAt(i2030)
                                                                                'Get value of OwnerID
                                                                                if ( not DataExtRetOwnerID is nothing) then
                                                                                Dim OwnerID2031 as String
                                                                                OwnerID2031 = DataExtRetOwnerID.GetValue()
                                                                                End If
                                                                                'Get value of DataExtName
                                                                                Dim DataExtName2032 as String
                                                                                DataExtName2032 = DataExtRetDataExtName.GetValue()
                                                                                'Get value of DataExtType
                                                                                Dim DataExtType2033 as ENDataExtType
                                                                                DataExtType2033 = DataExtRetDataExtType.GetValue()
                                                                                'Get value of DataExtValue
                                                                                Dim DataExtValue2034 as String
                                                                                DataExtValue2034 = DataExtRetDataExtValue.GetValue()
                                                                                Next i2030
                                                                        End If
                                                                Next i2003
                                                        End If
                                                        if (not ORItemLineRet1962.ItemGroupLineRet.DataExtList is nothing)
                                                                Dim i2035 as Integer
                                                                for i2035 = 0  to ORItemLineRet1962.ItemGroupLineRet.DataExtList.Count - 1
                                                                        Dim DataExt as IDataExt
                                                                        DataExt = ORItemLineRet1962.ItemGroupLineRet.DataExtList.GetAt(i2035)
                                                                        'Get value of OwnerID
                                                                        Dim OwnerID2036 as String
                                                                        OwnerID2036 = DataExtOwnerID.GetValue()
                                                                        'Get value of DataExtName
                                                                        Dim DataExtName2037 as String
                                                                        DataExtName2037 = DataExtDataExtName.GetValue()
                                                                        'Get value of DataExtValue
                                                                        Dim DataExtValue2038 as String
                                                                        DataExtValue2038 = DataExtDataExtValue.GetValue()
                                                                Next i2035
                                                        End If
                                                End If
                                        End If
                                Next i1961
                        End If
                        'Get value of OpenAmount
                        if ( not BillRet.OpenAmount is nothing) then
                                Dim OpenAmount2039 as Double
                                OpenAmount2039 = BillRet.OpenAmount.GetValue()
                        End If
                        if (not BillRet.DataExtRetList is nothing)
                                Dim i2040 as Integer
                                for i2040 = 0  to BillRet.DataExtRetList.Count - 1
                                        Dim DataExtRet as IDataExtRet
                                        DataExtRet = BillRet.DataExtRetList.GetAt(i2040)
                                        'Get value of OwnerID
                                        if ( not DataExtRetOwnerID is nothing) then
                                                Dim OwnerID2041 as String
                                                OwnerID2041 = DataExtRetOwnerID.GetValue()
                                        End If
                                        'Get value of DataExtName
                                        Dim DataExtName2042 as String
                                        DataExtName2042 = DataExtRetDataExtName.GetValue()
                                        'Get value of DataExtType
                                        Dim DataExtType2043 as ENDataExtType
                                        DataExtType2043 = DataExtRetDataExtType.GetValue()
                                        'Get value of DataExtValue
                                        Dim DataExtValue2044 as String
                                        DataExtValue2044 = DataExtRetDataExtValue.GetValue()
                                Next i2040
                        End If
                End Sub




        End Class
End Module


   1
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
  41
  42
  43
  44
  45
  46
  47
  48
  49
  50
  51
  52
  53
  54
  55
  56
  57
  58
  59
  60
  61
  62
  63
  64
  65
  66
  67
  68
  69
  70
  71
  72
  73
  74
  75
  76
  77
  78
  79
  80
  81
  82
  83
  84
  85
  86
  87
  88
  89
  90
  91
  92
  93
  94
  95
  96
  97
  98
  99
 100
 101
 102
 103
 104
 105
 106
 107
 108
 109
 110
 111
 112
 113
 114
 115
 116
 117
 118
 119
 120
 121
 122
 123
 124
 125
 126
 127
 128
 129
 130
 131
 132
 133
 134
 135
 136
 137
 138
 139
 140
 141
 142
 143
 144
 145
 146
 147
 148
 149
 150
 151
 152
 153
 154
 155
 156
 157
 158
 159
 160
 161
 162
 163
 164
 165
 166
 167
 168
 169
 170
 171
 172
 173
 174
 175
 176
 177
 178
 179
 180
 181
 182
 183
 184
 185
 186
 187
 188
 189
 190
 191
 192
 193
 194
 195
 196
 197
 198
 199
 200
 201
 202
 203
 204
 205
 206
 207
 208
 209
 210
 211
 212
 213
 214
 215
 216
 217
 218
 219
 220
 221
 222
 223
 224
 225
 226
 227
 228
 229
 230
 231
 232
 233
 234
 235
 236
 237
 238
 239
 240
 241
 242
 243
 244
 245
 246
 247
 248
 249
 250
 251
 252
 253
 254
 255
 256
 257
 258
 259
 260
 261
 262
 263
 264
 265
 266
 267
 268
 269
 270
 271
 272
 273
 274
 275
 276
 277
 278
 279
 280
 281
 282
 283
 284
 285
 286
 287
 288
 289
 290
 291
 292
 293
 294
 295
 296
 297
 298
 299
 300
 301
 302
 303
 304
 305
 306
 307
 308
 309
 310
 311
 312
 313
 314
 315
 316
 317
 318
 319
 320
 321
 322
 323
 324
 325
 326
 327
 328
 329
 330
 331
 332
 333
 334
 335
 336
 337
 338
 339
 340
 341
 342
 343
 344
 345
 346
 347
 348
 349
 350
 351
 352
 353
 354
 355
 356
 357
 358
 359
 360
 361
 362
 363
 364
 365
 366
 367
 368
 369
 370
 371
 372
 373
 374
 375
 376
 377
 378
 379
 380
 381
 382
 383
 384
 385
 386
 387
 388
 389
 390
 391
 392
 393
 394
 395
 396
 397
 398
 399
 400
 401
 402
 403
 404
 405
 406
 407
 408
 409
 410
 411
 412
 413
 414
 415
 416
 417
 418
 419
 420
 421
 422
 423
 424
 425
 426
 427
 428
 429
 430
 431
 432
 433
 434
 435
 436
 437
 438
 439
 440
 441
 442
 443
 444
 445
 446
 447
 448
 449
 450
 451
 452
 453
 454
 455
 456
 457
 458
 459
 460
 461
 462
 463
 464
 465
 466
 467
 468
 469
 470
 471
 472
 473
 474
 475
 476
 477
 478
 479
 480
 481
 482
 483
 484
 485
 486
 487
 488
 489
 490
 491
 492
 493
 494
 495
 496
 497
 498
 499
 500
 501
 502
 503
 504
 505
 506
 507
 508
 509
 510
 511
 512
 513
 514
 515
 516
 517
 518
 519
 520
 521
 522
 523
 524
 525
 526
 527
 528
 529
 530
 531
 532
 533
 534
 535
 536
 537
 538
 539
 540
 541
 542
 543
 544
 545
 546
 547
 548
 549
 550
 551
 552
 553
 554
 555
 556
 557
 558
 559
 560
 561
 562
 563
 564
 565
 566
 567
 568
 569
 570
 571
 572
 573
 574
 575
 576
 577
 578
 579
 580
 581
 582
 583
 584
 585
 586
 587
 588
 589
 590
 591
 592
 593
 594
 595
 596
 597
 598
 599
 600
 601
 602
 603
 604
 605
 606
 607
 608
 609
 610
 611
 612
 613
 614
 615
 616
 617
 618
 619
 620
 621
 622
 623
 624
 625
 626
 627
 628
 629
 630
 631
 632
 633
 634
 635
 636
 637
 638
 639
 640
 641
 642
 643
 644
 645
 646
 647
 648
 649
 650
 651
 652
 653
 654
 655
 656
 657
 658
 659
 660
 661
 662
 663
 664
 665
 666
 667
 668
 669
 670
 671
 672
 673
 674
 675
 676
 677
 678
 679
 680
 681
 682
 683
 684
 685
 686
 687
 688
 689
 690
 691
 692
 693
 694
 695
 696
 697
 698
 699
 700
 701
 702
 703
 704
 705
 706
 707
 708
 709
 710
 711
 712
 713
 714
 715
 716
 717
 718
 719
 720
 721
 722
 723
 724
 725
 726
 727
 728
 729
 730
 731
 732
 733
 734
 735
 736
 737
 738
 739
 740
 741
 742
 743
 744
 745
 746
 747
 748
 749
 750
 751
 752
 753
 754
 755
 756
 757
 758
 759
 760
 761
 762
 763
 764
 765
 766
 767
 768
 769
 770
 771
 772
 773
 774
 775
 776
 777
 778
 779
 780
 781
 782
 783
 784
 785
 786
 787
 788
 789
 790
 791
 792
 793
 794
 795
 796
 797
 798
 799
 800
 801
 802
 803
 804
 805
 806
 807
 808
 809
 810
 811
 812
 813
 814
 815
 816
 817
 818
 819
 820
 821
 822
 823
 824
 825
 826
 827
 828
 829
 830
 831
 832
 833
 834
 835
 836
 837
 838
 839
 840
 841
 842
 843
 844
 845
 846
 847
 848
 849
 850
 851
 852
 853
 854
 855
 856
 857
 858
 859
 860
 861
 862
 863
 864
 865
 866
 867
 868
 869
 870
 871
 872
 873
 874
 875
 876
 877
 878
 879
 880
 881
 882
 883
 884
 885
 886
 887
 888
 889
 890
 891
 892
 893
 894
 895
 896
 897
 898
 899
 900
 901
 902
 903
 904
 905
 906
 907
 908
 909
 910
 911
 912
 913
 914
 915
 916
 917
 918
 919
 920
 921
 922
 923
 924
 925
 926
 927
 928
 929
 930
 931
 932
 933
 934
 935
 936
 937
 938
 939
 940
 941
 942
 943
 944
 945
 946
 947
 948
 949
 950
 951
 952
 953
 954
 955
 956
 957
 958
 959
 960
 961
 962
 963
 964
 965
 966
 967
 968
 969
 970
 971
 972
 973
 974
 975
 976
 977
 978
 979
 980
 981
 982
 983
 984
 985
 986
 987
 988
 989
 990
 991
 992
 993
 994
 995
 996
 997
 998
 999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
//The following sample code is generated as an illustration of
//Creating requests and parsing responses ONLY
//This code is NOT intended to show best practices or ideal code
//Use at your most careful discretion

using System;
using System.Net;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.IO;
using Interop.QBFC16;

namespace com.intuit.idn.samples
{
        public class Sample
        {
                public void  DoBillQuery()
                {
                        bool sessionBegun = false;
                        bool connectionOpen = false;
                        QBSessionManager sessionManager = null;

                        try
                        {
                                //Create the session Manager object
                                sessionManager = new QBSessionManager();

                                //Create the message set request object to hold our request
                                IMsgSetRequest requestMsgSet = sessionManager.CreateMsgSetRequest("US",16,0);
                                requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue;

                                BuildBillQueryRq(requestMsgSet);

                                //Connect to QuickBooks and begin a session
                                sessionManager.OpenConnection("","Sample Code from OSR");
                                connectionOpen = true;
                                sessionManager.BeginSession("", ENOpenMode.omDontCare);
                                sessionBegun = true;

                                //Send the request and get the response from QuickBooks
                                IMsgSetResponse responseMsgSet = sessionManager.DoRequests(requestMsgSet);

                                //End the session and close the connection to QuickBooks
                                sessionManager.EndSession();
                                sessionBegun = false;
                                sessionManager.CloseConnection();
                                connectionOpen = false;

                                WalkBillQueryRs(responseMsgSet);
                        }
                        catch (Exception e)
                        {
                                MessageBox.Show(e.Message, "Error");
                                if (sessionBegun)
                                {
                                        sessionManager.EndSession();
                                }
                                if (connectionOpen)
                                {
                                        sessionManager.CloseConnection();
                                }
                        }
                }
                void BuildBillQueryRq(IMsgSetRequest requestMsgSet)
                {
                        IBillQuery BillQueryRq= requestMsgSet.AppendBillQueryRq();
                        //Set attributes
                        //Set field value for metaData
                        BillQueryRq.metaData.SetValue("IQBENmetaDataType");
                        //Set field value for iterator
                        BillQueryRq.iterator.SetValue("IQBENiteratorType");
                        //Set field value for iteratorID
                        BillQueryRq.iteratorID.SetValue("IQBUUIDType");
                        string ORBillQueryElementType1739 = "TxnIDList";
                        if (ORBillQueryElementType1739 == "TxnIDList")
                        {
                                //Set field value for TxnIDList
                                //May create more than one of these if needed
                                BillQueryRq.ORBillQuery.TxnIDList.Add("200000-1011023419");
                        }
                        if (ORBillQueryElementType1739 == "RefNumberList")
                        {
                                //Set field value for RefNumberList
                                //May create more than one of these if needed
                                BillQueryRq.ORBillQuery.RefNumberList.Add("ab");
                        }
                        if (ORBillQueryElementType1739 == "RefNumberCaseSensitiveList")
                        {
                                //Set field value for RefNumberCaseSensitiveList
                                //May create more than one of these if needed
                                BillQueryRq.ORBillQuery.RefNumberCaseSensitiveList.Add("ab");
                        }
                        if (ORBillQueryElementType1739 == "BillFilter")
                        {
                                //Set field value for MaxReturned
                                BillQueryRq.ORBillQuery.BillFilter.MaxReturned.SetValue(6);
                                string ORDateRangeFilterElementType1740 = "ModifiedDateRangeFilter";
                                if (ORDateRangeFilterElementType1740 == "ModifiedDateRangeFilter")
                                {
                                        //Set field value for FromModifiedDate
                                        BillQueryRq.ORBillQuery.BillFilter.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false);
                                        //Set field value for ToModifiedDate
                                        BillQueryRq.ORBillQuery.BillFilter.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false);
                                }
                                if (ORDateRangeFilterElementType1740 == "TxnDateRangeFilter")
                                {
                                        string ORTxnDateRangeFilterElementType1741 = "TxnDateFilter";
                                        if (ORTxnDateRangeFilterElementType1741 == "TxnDateFilter")
                                        {
                                                //Set field value for FromTxnDate
                                                BillQueryRq.ORBillQuery.BillFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007"));
                                                //Set field value for ToTxnDate
                                                BillQueryRq.ORBillQuery.BillFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007"));
                                        }
                                        if (ORTxnDateRangeFilterElementType1741 == "DateMacro")
                                        {
                                                //Set field value for DateMacro
                                                BillQueryRq.ORBillQuery.BillFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll);
                                        }
                                }
                                string OREntityFilterElementType1742 = "ListIDList";
                                if (OREntityFilterElementType1742 == "ListIDList")
                                {
                                        //Set field value for ListIDList
                                        //May create more than one of these if needed
                                        BillQueryRq.ORBillQuery.BillFilter.EntityFilter.OREntityFilter.ListIDList.Add("200000-1011023419");
                                }
                                if (OREntityFilterElementType1742 == "FullNameList")
                                {
                                        //Set field value for FullNameList
                                        //May create more than one of these if needed
                                        BillQueryRq.ORBillQuery.BillFilter.EntityFilter.OREntityFilter.FullNameList.Add("ab");
                                }
                                if (OREntityFilterElementType1742 == "ListIDWithChildren")
                                {
                                        //Set field value for ListIDWithChildren
                                        BillQueryRq.ORBillQuery.BillFilter.EntityFilter.OREntityFilter.ListIDWithChildren.SetValue("200000-1011023419");
                                }
                                if (OREntityFilterElementType1742 == "FullNameWithChildren")
                                {
                                        //Set field value for FullNameWithChildren
                                        BillQueryRq.ORBillQuery.BillFilter.EntityFilter.OREntityFilter.FullNameWithChildren.SetValue("ab");
                                }
                                string ORAccountFilterElementType1743 = "ListIDList";
                                if (ORAccountFilterElementType1743 == "ListIDList")
                                {
                                        //Set field value for ListIDList
                                        //May create more than one of these if needed
                                        BillQueryRq.ORBillQuery.BillFilter.AccountFilter.ORAccountFilter.ListIDList.Add("200000-1011023419");
                                }
                                if (ORAccountFilterElementType1743 == "FullNameList")
                                {
                                        //Set field value for FullNameList
                                        //May create more than one of these if needed
                                        BillQueryRq.ORBillQuery.BillFilter.AccountFilter.ORAccountFilter.FullNameList.Add("ab");
                                }
                                if (ORAccountFilterElementType1743 == "ListIDWithChildren")
                                {
                                        //Set field value for ListIDWithChildren
                                        BillQueryRq.ORBillQuery.BillFilter.AccountFilter.ORAccountFilter.ListIDWithChildren.SetValue("200000-1011023419");
                                }
                                if (ORAccountFilterElementType1743 == "FullNameWithChildren")
                                {
                                        //Set field value for FullNameWithChildren
                                        BillQueryRq.ORBillQuery.BillFilter.AccountFilter.ORAccountFilter.FullNameWithChildren.SetValue("ab");
                                }
                                string ORRefNumberFilterElementType1744 = "RefNumberFilter";
                                if (ORRefNumberFilterElementType1744 == "RefNumberFilter")
                                {
                                        //Set field value for MatchCriterion
                                        BillQueryRq.ORBillQuery.BillFilter.ORRefNumberFilter.RefNumberFilter.MatchCriterion.SetValue(ENMatchCriterion.mcStartsWith);
                                        //Set field value for RefNumber
                                        BillQueryRq.ORBillQuery.BillFilter.ORRefNumberFilter.RefNumberFilter.RefNumber.SetValue("ab");
                                }
                                if (ORRefNumberFilterElementType1744 == "RefNumberRangeFilter")
                                {
                                        //Set field value for FromRefNumber
                                        BillQueryRq.ORBillQuery.BillFilter.ORRefNumberFilter.RefNumberRangeFilter.FromRefNumber.SetValue("ab");
                                        //Set field value for ToRefNumber
                                        BillQueryRq.ORBillQuery.BillFilter.ORRefNumberFilter.RefNumberRangeFilter.ToRefNumber.SetValue("ab");
                                }
                                string ORCurrencyFilterElementType1745 = "ListIDList";
                                if (ORCurrencyFilterElementType1745 == "ListIDList")
                                {
                                        //Set field value for ListIDList
                                        //May create more than one of these if needed
                                        BillQueryRq.ORBillQuery.BillFilter.CurrencyFilter.ORCurrencyFilter.ListIDList.Add("200000-1011023419");
                                }
                                if (ORCurrencyFilterElementType1745 == "FullNameList")
                                {
                                        //Set field value for FullNameList
                                        //May create more than one of these if needed
                                        BillQueryRq.ORBillQuery.BillFilter.CurrencyFilter.ORCurrencyFilter.FullNameList.Add("ab");
                                }
                                //Set field value for PaidStatus
                                BillQueryRq.ORBillQuery.BillFilter.PaidStatus.SetValue(ENPaidStatus.psAll [DEFAULT]);
                        }
                        //Set field value for IncludeLineItems
                        BillQueryRq.IncludeLineItems.SetValue(true);
                        //Set field value for IncludeLinkedTxns
                        BillQueryRq.IncludeLinkedTxns.SetValue(true);
                        //Set field value for IncludeRetElementList
                        //May create more than one of these if needed
                        BillQueryRq.IncludeRetElementList.Add("ab");
                        //Set field value for OwnerIDList
                        //May create more than one of these if needed
                        BillQueryRq.OwnerIDList.Add(Guid.NewGuid().ToString());
                }




                void WalkBillQueryRs(IMsgSetResponse responseMsgSet)
                {
                        if (responseMsgSet == null) return;
                        IResponseList responseList = responseMsgSet.ResponseList;
                        if (responseList == null) return;
                        //if we sent only one request, there is only one response, we'll walk the list for this sample
                        for(int i=0; i < responseList.Count; i++)
                        {
                                IResponse response = responseList.GetAt(i);
                                //check the status code of the response, 0=ok, >0 is warning
                                if (response.StatusCode >= 0)
                                {
                                        //the request-specific response is in the details, make sure we have some
                                        if (response.Detail != null)
                                        {
                                                //make sure the response is the type we're expecting
                                                ENResponseType responseType = (ENResponseType)response.Type.GetValue();
                                                if (responseType == ENResponseType.rtBillQueryRs)
                                                {
                                                        //upcast to more specific type here, this is safe because we checked with response.Type check above
                                                        IBillRetList BillRet = (IBillRetList)response.Detail;
                                                        WalkBillRet(BillRet);
                                                }
                                        }
                                }
                        }
                }




                void WalkBillRet(IBillRetList BillRet)
                {
                        if (BillRet == null) return;
                        //Go through all the elements of IBillRetList
                        //Get value of TxnID
                        string TxnID1746 = (string)BillRet.TxnID.GetValue();
                        //Get value of TimeCreated
                        DateTime TimeCreated1747 = (DateTime)BillRet.TimeCreated.GetValue();
                        //Get value of TimeModified
                        DateTime TimeModified1748 = (DateTime)BillRet.TimeModified.GetValue();
                        //Get value of EditSequence
                        string EditSequence1749 = (string)BillRet.EditSequence.GetValue();
                        //Get value of TxnNumber
                        if (BillRet.TxnNumber != null)
                        {
                                int TxnNumber1750 = (int)BillRet.TxnNumber.GetValue();
                        }
                        //Get value of ListID
                        if (BillRet.VendorRef.ListID != null)
                        {
                                string ListID1751 = (string)BillRet.VendorRef.ListID.GetValue();
                        }
                        //Get value of FullName
                        if (BillRet.VendorRef.FullName != null)
                        {
                                string FullName1752 = (string)BillRet.VendorRef.FullName.GetValue();
                        }
                        if (BillRet.VendorAddress != null)
                        {
                                //Get value of Addr1
                                if (BillRet.VendorAddress.Addr1 != null)
                                {
                                        string Addr11753 = (string)BillRet.VendorAddress.Addr1.GetValue();
                                }
                                //Get value of Addr2
                                if (BillRet.VendorAddress.Addr2 != null)
                                {
                                        string Addr21754 = (string)BillRet.VendorAddress.Addr2.GetValue();
                                }
                                //Get value of Addr3
                                if (BillRet.VendorAddress.Addr3 != null)
                                {
                                        string Addr31755 = (string)BillRet.VendorAddress.Addr3.GetValue();
                                }
                                //Get value of Addr4
                                if (BillRet.VendorAddress.Addr4 != null)
                                {
                                        string Addr41756 = (string)BillRet.VendorAddress.Addr4.GetValue();
                                }
                                //Get value of Addr5
                                if (BillRet.VendorAddress.Addr5 != null)
                                {
                                        string Addr51757 = (string)BillRet.VendorAddress.Addr5.GetValue();
                                }
                                //Get value of City
                                if (BillRet.VendorAddress.City != null)
                                {
                                        string City1758 = (string)BillRet.VendorAddress.City.GetValue();
                                }
                                //Get value of State
                                if (BillRet.VendorAddress.State != null)
                                {
                                        string State1759 = (string)BillRet.VendorAddress.State.GetValue();
                                }
                                //Get value of PostalCode
                                if (BillRet.VendorAddress.PostalCode != null)
                                {
                                        string PostalCode1760 = (string)BillRet.VendorAddress.PostalCode.GetValue();
                                }
                                //Get value of Country
                                if (BillRet.VendorAddress.Country != null)
                                {
                                        string Country1761 = (string)BillRet.VendorAddress.Country.GetValue();
                                }
                                //Get value of Note
                                if (BillRet.VendorAddress.Note != null)
                                {
                                        string Note1762 = (string)BillRet.VendorAddress.Note.GetValue();
                                }
                        }
                        if (BillRet.APAccountRef != null)
                        {
                                //Get value of ListID
                                if (BillRet.APAccountRef.ListID != null)
                                {
                                        string ListID1763 = (string)BillRet.APAccountRef.ListID.GetValue();
                                }
                                //Get value of FullName
                                if (BillRet.APAccountRef.FullName != null)
                                {
                                        string FullName1764 = (string)BillRet.APAccountRef.FullName.GetValue();
                                }
                        }
                        //Get value of TxnDate
                        DateTime TxnDate1765 = (DateTime)BillRet.TxnDate.GetValue();
                        //Get value of DueDate
                        if (BillRet.DueDate != null)
                        {
                                DateTime DueDate1766 = (DateTime)BillRet.DueDate.GetValue();
                        }
                        //Get value of AmountDue
                        double AmountDue1767 = (double)BillRet.AmountDue.GetValue();
                        if (BillRet.CurrencyRef != null)
                        {
                                //Get value of ListID
                                if (BillRet.CurrencyRef.ListID != null)
                                {
                                        string ListID1768 = (string)BillRet.CurrencyRef.ListID.GetValue();
                                }
                                //Get value of FullName
                                if (BillRet.CurrencyRef.FullName != null)
                                {
                                        string FullName1769 = (string)BillRet.CurrencyRef.FullName.GetValue();
                                }
                        }
                        //Get value of ExchangeRate
                        if (BillRet.ExchangeRate != null)
                        {
                                IQBFloatType ExchangeRate1770 = (IQBFloatType)BillRet.ExchangeRate.GetValue();
                        }
                        //Get value of AmountDueInHomeCurrency
                        if (BillRet.AmountDueInHomeCurrency != null)
                        {
                                double AmountDueInHomeCurrency1771 = (double)BillRet.AmountDueInHomeCurrency.GetValue();
                        }
                        //Get value of RefNumber
                        if (BillRet.RefNumber != null)
                        {
                                string RefNumber1772 = (string)BillRet.RefNumber.GetValue();
                        }
                        //Get value of IsPending
                        if (BillRet.IsPending != null)
                        {
                                bool isPending = (string)BillRet.IsPending.GetValue();
                        }
                        if (BillRet.TermsRef != null)
                        {
                                //Get value of ListID
                                if (BillRet.TermsRef.ListID != null)
                                {
                                        string ListID1773 = (string)BillRet.TermsRef.ListID.GetValue();
                                }
                                //Get value of FullName
                                if (BillRet.TermsRef.FullName != null)
                                {
                                        string FullName1774 = (string)BillRet.TermsRef.FullName.GetValue();
                                }
                        }
                        //Get value of Memo
                        if (BillRet.Memo != null)
                        {
                                string Memo1775 = (string)BillRet.Memo.GetValue();
                        }
                        //Get value of IsTaxIncluded
                        if (BillRet.IsTaxIncluded != null)
                        {
                                bool IsTaxIncluded1776 = (bool)BillRet.IsTaxIncluded.GetValue();
                        }
                        if (BillRet.SalesTaxCodeRef != null)
                        {
                                //Get value of ListID
                                if (BillRet.SalesTaxCodeRef.ListID != null)
                                {
                                        string ListID1777 = (string)BillRet.SalesTaxCodeRef.ListID.GetValue();
                                }
                                //Get value of FullName
                                if (BillRet.SalesTaxCodeRef.FullName != null)
                                {
                                        string FullName1778 = (string)BillRet.SalesTaxCodeRef.FullName.GetValue();
                                }
                        }
                        //Get value of IsPaid
                        if (BillRet.IsPaid != null)
                        {
                                bool IsPaid1779 = (bool)BillRet.IsPaid.GetValue();
                        }
                        //Get value of ExternalGUID
                        if (BillRet.ExternalGUID != null)
                        {
                                string ExternalGUID1780 = (string)BillRet.ExternalGUID.GetValue();
                        }
                        if (BillRet.LinkedTxnList != null)
                        {
                                for (int i1781 = 0; i1781 < BillRet.LinkedTxnList.Count; i1781++)
                                {
                                        ILinkedTxn LinkedTxn = BillRet.LinkedTxnList.GetAt(i1781);
                                        //Get value of TxnID
                                        string TxnID1782 = (string)LinkedTxn.TxnID.GetValue();
                                        //Get value of TxnType
                                        ENTxnType TxnType1783 = (ENTxnType)LinkedTxn.TxnType.GetValue();
                                        //Get value of TxnDate
                                        DateTime TxnDate1784 = (DateTime)LinkedTxn.TxnDate.GetValue();
                                        //Get value of RefNumber
                                        if (LinkedTxn.RefNumber != null)
                                        {
                                                string RefNumber1785 = (string)LinkedTxn.RefNumber.GetValue();
                                        }
                                        //Get value of LinkType
                                        if (LinkedTxn.LinkType != null)
                                        {
                                                ENLinkType LinkType1786 = (ENLinkType)LinkedTxn.LinkType.GetValue();
                                        }
                                        //Get value of Amount
                                        double Amount1787 = (double)LinkedTxn.Amount.GetValue();
                                }
                        }
                        if (BillRet.ExpenseLineRetList != null)
                        {
                                for (int i1788 = 0; i1788 < BillRet.ExpenseLineRetList.Count; i1788++)
                                {
                                        IExpenseLineRet ExpenseLineRet = BillRet.ExpenseLineRetList.GetAt(i1788);
                                        //Get value of TxnLineID
                                        string TxnLineID1789 = (string)ExpenseLineRet.TxnLineID.GetValue();
                                        if (ExpenseLineRet.AccountRef != null)
                                        {
                                                //Get value of ListID
                                                if (ExpenseLineRet.AccountRef.ListID != null)
                                                {
                                                        string ListID1790 = (string)ExpenseLineRet.AccountRef.ListID.GetValue();
                                                }
                                                //Get value of FullName
                                                if (ExpenseLineRet.AccountRef.FullName != null)
                                                {
                                                        string FullName1791 = (string)ExpenseLineRet.AccountRef.FullName.GetValue();
                                                }
                                        }
                                        //Get value of Amount
                                        if (ExpenseLineRet.Amount != null)
                                        {
                                                double Amount1792 = (double)ExpenseLineRet.Amount.GetValue();
                                        }
                                        //Get value of Memo
                                        if (ExpenseLineRet.Memo != null)
                                        {
                                                string Memo1793 = (string)ExpenseLineRet.Memo.GetValue();
                                        }
                                        if (ExpenseLineRet.CustomerRef != null)
                                        {
                                                //Get value of ListID
                                                if (ExpenseLineRet.CustomerRef.ListID != null)
                                                {
                                                        string ListID1794 = (string)ExpenseLineRet.CustomerRef.ListID.GetValue();
                                                }
                                                //Get value of FullName
                                                if (ExpenseLineRet.CustomerRef.FullName != null)
                                                {
                                                        string FullName1795 = (string)ExpenseLineRet.CustomerRef.FullName.GetValue();
                                                }
                                        }
                                        if (ExpenseLineRet.ClassRef != null)
                                        {
                                                //Get value of ListID
                                                if (ExpenseLineRet.ClassRef.ListID != null)
                                                {
                                                        string ListID1796 = (string)ExpenseLineRet.ClassRef.ListID.GetValue();
                                                }
                                                //Get value of FullName
                                                if (ExpenseLineRet.ClassRef.FullName != null)
                                                {
                                                        string FullName1797 = (string)ExpenseLineRet.ClassRef.FullName.GetValue();
                                                }
                                        }
                                        if (ExpenseLineRet.SalesTaxCodeRef != null)
                                        {
                                                //Get value of ListID
                                                if (ExpenseLineRet.SalesTaxCodeRef.ListID != null)
                                                {
                                                        string ListID1798 = (string)ExpenseLineRet.SalesTaxCodeRef.ListID.GetValue();
                                                }
                                                //Get value of FullName
                                                if (ExpenseLineRet.SalesTaxCodeRef.FullName != null)
                                                {
                                                        string FullName1799 = (string)ExpenseLineRet.SalesTaxCodeRef.FullName.GetValue();
                                                }
                                        }
                                        //Get value of BillableStatus
                                        if (ExpenseLineRet.BillableStatus != null)
                                        {
                                                ENBillableStatus BillableStatus1800 = (ENBillableStatus)ExpenseLineRet.BillableStatus.GetValue();
                                        }
                                        if (ExpenseLineRet.SalesRepRef != null)
                                        {
                                                //Get value of ListID
                                                if (ExpenseLineRet.SalesRepRef.ListID != null)
                                                {
                                                        string ListID1801 = (string)ExpenseLineRet.SalesRepRef.ListID.GetValue();
                                                }
                                                //Get value of FullName
                                                if (ExpenseLineRet.SalesRepRef.FullName != null)
                                                {
                                                        string FullName1802 = (string)ExpenseLineRet.SalesRepRef.FullName.GetValue();
                                                }
                                        }
                                        if (ExpenseLineRet.DataExtRetList != null)
                                        {
                                                for (int i1803 = 0; i1803 < ExpenseLineRet.DataExtRetList.Count; i1803++)
                                                {
                                                        IDataExtRet DataExtRet = ExpenseLineRet.DataExtRetList.GetAt(i1803);
                                                        //Get value of OwnerID
                                                        if (DataExtRet.OwnerID != null)
                                                        {
                                                                string OwnerID1804 = (string)DataExtRet.OwnerID.GetValue();
                                                        }
                                                        //Get value of DataExtName
                                                        string DataExtName1805 = (string)DataExtRet.DataExtName.GetValue();
                                                        //Get value of DataExtType
                                                        ENDataExtType DataExtType1806 = (ENDataExtType)DataExtRet.DataExtType.GetValue();
                                                        //Get value of DataExtValue
                                                        string DataExtValue1807 = (string)DataExtRet.DataExtValue.GetValue();
                                                }
                                        }
                                }
                        }
                        if (BillRet.ORItemLineRetList != null)
                        {
                                for (int i1808 = 0; i1808 < BillRet.ORItemLineRetList.Count; i1808++)
                                {
                                        IORItemLineRet ORItemLineRet1809 = BillRet.ORItemLineRetList.GetAt(i1808);
                                        if (ORItemLineRet1809.ItemLineRet != null)
                                        {
                                                if (ORItemLineRet1809.ItemLineRet != null)
                                                {
                                                        //Get value of TxnLineID
                                                        string TxnLineID1810 = (string)ORItemLineRet1809.ItemLineRet.TxnLineID.GetValue();
                                                        if (ORItemLineRet1809.ItemLineRet.ItemRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORItemLineRet1809.ItemLineRet.ItemRef.ListID != null)
                                                                {
                                                                        string ListID1811 = (string)ORItemLineRet1809.ItemLineRet.ItemRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORItemLineRet1809.ItemLineRet.ItemRef.FullName != null)
                                                                {
                                                                        string FullName1812 = (string)ORItemLineRet1809.ItemLineRet.ItemRef.FullName.GetValue();
                                                                }
                                                        }
                                                        if (ORItemLineRet1809.ItemLineRet.InventorySiteRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORItemLineRet1809.ItemLineRet.InventorySiteRef.ListID != null)
                                                                {
                                                                        string ListID1813 = (string)ORItemLineRet1809.ItemLineRet.InventorySiteRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORItemLineRet1809.ItemLineRet.InventorySiteRef.FullName != null)
                                                                {
                                                                        string FullName1814 = (string)ORItemLineRet1809.ItemLineRet.InventorySiteRef.FullName.GetValue();
                                                                }
                                                        }
                                                        if (ORItemLineRet1809.ItemLineRet.InventorySiteLocationRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORItemLineRet1809.ItemLineRet.InventorySiteLocationRef.ListID != null)
                                                                {
                                                                        string ListID1815 = (string)ORItemLineRet1809.ItemLineRet.InventorySiteLocationRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORItemLineRet1809.ItemLineRet.InventorySiteLocationRef.FullName != null)
                                                                {
                                                                        string FullName1816 = (string)ORItemLineRet1809.ItemLineRet.InventorySiteLocationRef.FullName.GetValue();
                                                                }
                                                        }
                                                        if (ORItemLineRet1809.ItemLineRet.ORSerialLotNumber != null)
                                                        {
                                                                if (ORItemLineRet1809.ItemLineRet.ORSerialLotNumber.SerialNumber != null)
                                                                {
                                                                        //Get value of SerialNumber
                                                                        if (ORItemLineRet1809.ItemLineRet.ORSerialLotNumber.SerialNumber != null)
                                                                        {
                                                                                string SerialNumber1818 = (string)ORItemLineRet1809.ItemLineRet.ORSerialLotNumber.SerialNumber.GetValue();
                                                                        }
                                                                }
                                                                if (ORItemLineRet1809.ItemLineRet.ORSerialLotNumber.LotNumber != null)
                                                                {
                                                                        //Get value of LotNumber
                                                                        if (ORItemLineRet1809.ItemLineRet.ORSerialLotNumber.LotNumber != null)
                                                                        {
                                                                                string LotNumber1819 = (string)ORItemLineRet1809.ItemLineRet.ORSerialLotNumber.LotNumber.GetValue();
                                                                        }
                                                                }
                                                        }
                                                        //Get value of Desc
                                                        if (ORItemLineRet1809.ItemLineRet.ExpirationDateForSerialLotNumber != null)
                                                        {
                                                                string ExpDate = (string)ORItemLineRet1809.ItemLineRet.ExpirationDateForSerialLotNumber.GetValue();
                                                        }
                                                        //Get value of Desc
                                                        if (ORItemLineRet1809.ItemLineRet.Desc != null)
                                                        {
                                                                string Desc1820 = (string)ORItemLineRet1809.ItemLineRet.Desc.GetValue();
                                                        }
                                                        //Get value of Quantity
                                                        if (ORItemLineRet1809.ItemLineRet.Quantity != null)
                                                        {
                                                                int Quantity1821 = (int)ORItemLineRet1809.ItemLineRet.Quantity.GetValue();
                                                        }
                                                        //Get value of UnitOfMeasure
                                                        if (ORItemLineRet1809.ItemLineRet.UnitOfMeasure != null)
                                                        {
                                                                string UnitOfMeasure1822 = (string)ORItemLineRet1809.ItemLineRet.UnitOfMeasure.GetValue();
                                                        }
                                                        if (ORItemLineRet1809.ItemLineRet.OverrideUOMSetRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORItemLineRet1809.ItemLineRet.OverrideUOMSetRef.ListID != null)
                                                                {
                                                                        string ListID1823 = (string)ORItemLineRet1809.ItemLineRet.OverrideUOMSetRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORItemLineRet1809.ItemLineRet.OverrideUOMSetRef.FullName != null)
                                                                {
                                                                        string FullName1824 = (string)ORItemLineRet1809.ItemLineRet.OverrideUOMSetRef.FullName.GetValue();
                                                                }
                                                        }
                                                        //Get value of Cost
                                                        if (ORItemLineRet1809.ItemLineRet.Cost != null)
                                                        {
                                                                double Cost1825 = (double)ORItemLineRet1809.ItemLineRet.Cost.GetValue();
                                                        }
                                                        //Get value of Amount
                                                        if (ORItemLineRet1809.ItemLineRet.Amount != null)
                                                        {
                                                                double Amount1826 = (double)ORItemLineRet1809.ItemLineRet.Amount.GetValue();
                                                        }
                                                        if (ORItemLineRet1809.ItemLineRet.CustomerRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORItemLineRet1809.ItemLineRet.CustomerRef.ListID != null)
                                                                {
                                                                        string ListID1827 = (string)ORItemLineRet1809.ItemLineRet.CustomerRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORItemLineRet1809.ItemLineRet.CustomerRef.FullName != null)
                                                                {
                                                                        string FullName1828 = (string)ORItemLineRet1809.ItemLineRet.CustomerRef.FullName.GetValue();
                                                                }
                                                        }
                                                        if (ORItemLineRet1809.ItemLineRet.ClassRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORItemLineRet1809.ItemLineRet.ClassRef.ListID != null)
                                                                {
                                                                        string ListID1829 = (string)ORItemLineRet1809.ItemLineRet.ClassRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORItemLineRet1809.ItemLineRet.ClassRef.FullName != null)
                                                                {
                                                                        string FullName1830 = (string)ORItemLineRet1809.ItemLineRet.ClassRef.FullName.GetValue();
                                                                }
                                                        }
                                                        if (ORItemLineRet1809.ItemLineRet.SalesTaxCodeRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORItemLineRet1809.ItemLineRet.SalesTaxCodeRef.ListID != null)
                                                                {
                                                                        string ListID1831 = (string)ORItemLineRet1809.ItemLineRet.SalesTaxCodeRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORItemLineRet1809.ItemLineRet.SalesTaxCodeRef.FullName != null)
                                                                {
                                                                        string FullName1832 = (string)ORItemLineRet1809.ItemLineRet.SalesTaxCodeRef.FullName.GetValue();
                                                                }
                                                        }
                                                        //Get value of BillableStatus
                                                        if (ORItemLineRet1809.ItemLineRet.BillableStatus != null)
                                                        {
                                                                ENBillableStatus BillableStatus1833 = (ENBillableStatus)ORItemLineRet1809.ItemLineRet.BillableStatus.GetValue();
                                                        }
                                                        if (ORItemLineRet1809.ItemLineRet.SalesRepRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORItemLineRet1809.ItemLineRet.SalesRepRef.ListID != null)
                                                                {
                                                                        string ListID1834 = (string)ORItemLineRet1809.ItemLineRet.SalesRepRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORItemLineRet1809.ItemLineRet.SalesRepRef.FullName != null)
                                                                {
                                                                        string FullName1835 = (string)ORItemLineRet1809.ItemLineRet.SalesRepRef.FullName.GetValue();
                                                                }
                                                        }
                                                        if (ORItemLineRet1809.ItemLineRet.DataExtRetList != null)
                                                        {
                                                                for (int i1836 = 0; i1836 < ORItemLineRet1809.ItemLineRet.DataExtRetList.Count; i1836++)
                                                                {
                                                                        IDataExtRet DataExtRet = ORItemLineRet1809.ItemLineRet.DataExtRetList.GetAt(i1836);
                                                                        //Get value of OwnerID
                                                                        if (DataExtRet.OwnerID != null)
                                                                        {
                                                                                string OwnerID1837 = (string)DataExtRet.OwnerID.GetValue();
                                                                        }
                                                                        //Get value of DataExtName
                                                                        string DataExtName1838 = (string)DataExtRet.DataExtName.GetValue();
                                                                        //Get value of DataExtType
                                                                        ENDataExtType DataExtType1839 = (ENDataExtType)DataExtRet.DataExtType.GetValue();
                                                                        //Get value of DataExtValue
                                                                        string DataExtValue1840 = (string)DataExtRet.DataExtValue.GetValue();
                                                                }
                                                        }
                                                }
                                        }
                                        if (ORItemLineRet1809.ItemGroupLineRet != null)
                                        {
                                                if (ORItemLineRet1809.ItemGroupLineRet != null)
                                                {
                                                        //Get value of TxnLineID
                                                        string TxnLineID1841 = (string)ORItemLineRet1809.ItemGroupLineRet.TxnLineID.GetValue();
                                                        //Get value of ListID
                                                        if (ORItemLineRet1809.ItemGroupLineRet.ItemGroupRef.ListID != null)
                                                        {
                                                                string ListID1842 = (string)ORItemLineRet1809.ItemGroupLineRet.ItemGroupRef.ListID.GetValue();
                                                        }
                                                        //Get value of FullName
                                                        if (ORItemLineRet1809.ItemGroupLineRet.ItemGroupRef.FullName != null)
                                                        {
                                                                string FullName1843 = (string)ORItemLineRet1809.ItemGroupLineRet.ItemGroupRef.FullName.GetValue();
                                                        }
                                                        //Get value of Desc
                                                        if (ORItemLineRet1809.ItemGroupLineRet.Desc != null)
                                                        {
                                                                string Desc1844 = (string)ORItemLineRet1809.ItemGroupLineRet.Desc.GetValue();
                                                        }
                                                        //Get value of Quantity
                                                        if (ORItemLineRet1809.ItemGroupLineRet.Quantity != null)
                                                        {
                                                                int Quantity1845 = (int)ORItemLineRet1809.ItemGroupLineRet.Quantity.GetValue();
                                                        }
                                                        //Get value of UnitOfMeasure
                                                        if (ORItemLineRet1809.ItemGroupLineRet.UnitOfMeasure != null)
                                                        {
                                                                string UnitOfMeasure1846 = (string)ORItemLineRet1809.ItemGroupLineRet.UnitOfMeasure.GetValue();
                                                        }
                                                        if (ORItemLineRet1809.ItemGroupLineRet.OverrideUOMSetRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORItemLineRet1809.ItemGroupLineRet.OverrideUOMSetRef.ListID != null)
                                                                {
                                                                        string ListID1847 = (string)ORItemLineRet1809.ItemGroupLineRet.OverrideUOMSetRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORItemLineRet1809.ItemGroupLineRet.OverrideUOMSetRef.FullName != null)
                                                                {
                                                                        string FullName1848 = (string)ORItemLineRet1809.ItemGroupLineRet.OverrideUOMSetRef.FullName.GetValue();
                                                                }
                                                        }
                                                        //Get value of TotalAmount
                                                        double TotalAmount1849 = (double)ORItemLineRet1809.ItemGroupLineRet.TotalAmount.GetValue();
                                                        if (ORItemLineRet1809.ItemGroupLineRet.ItemLineRetList != null)
                                                        {
                                                                for (int i1850 = 0; i1850 < ORItemLineRet1809.ItemGroupLineRet.ItemLineRetList.Count; i1850++)
                                                                {
                                                                        IItemLineRet ItemLineRet = ORItemLineRet1809.ItemGroupLineRet.ItemLineRetList.GetAt(i1850);
                                                                        //Get value of TxnLineID
                                                                        string TxnLineID1851 = (string)ItemLineRet.TxnLineID.GetValue();
                                                                        if (ItemLineRet.ItemRef != null)
                                                                        {
                                                                                //Get value of ListID
                                                                                if (ItemLineRet.ItemRef.ListID != null)
                                                                                {
                                                                                string ListID1852 = (string)ItemLineRet.ItemRef.ListID.GetValue();
                                                                                }
                                                                                //Get value of FullName
                                                                                if (ItemLineRet.ItemRef.FullName != null)
                                                                                {
                                                                                string FullName1853 = (string)ItemLineRet.ItemRef.FullName.GetValue();
                                                                                }
                                                                        }
                                                                        if (ItemLineRet.InventorySiteRef != null)
                                                                        {
                                                                                //Get value of ListID
                                                                                if (ItemLineRet.InventorySiteRef.ListID != null)
                                                                                {
                                                                                string ListID1854 = (string)ItemLineRet.InventorySiteRef.ListID.GetValue();
                                                                                }
                                                                                //Get value of FullName
                                                                                if (ItemLineRet.InventorySiteRef.FullName != null)
                                                                                {
                                                                                string FullName1855 = (string)ItemLineRet.InventorySiteRef.FullName.GetValue();
                                                                                }
                                                                        }
                                                                        if (ItemLineRet.InventorySiteLocationRef != null)
                                                                        {
                                                                                //Get value of ListID
                                                                                if (ItemLineRet.InventorySiteLocationRef.ListID != null)
                                                                                {
                                                                                string ListID1856 = (string)ItemLineRet.InventorySiteLocationRef.ListID.GetValue();
                                                                                }
                                                                                //Get value of FullName
                                                                                if (ItemLineRet.InventorySiteLocationRef.FullName != null)
                                                                                {
                                                                                string FullName1857 = (string)ItemLineRet.InventorySiteLocationRef.FullName.GetValue();
                                                                                }
                                                                        }
                                                                        if (ItemLineRet.ORSerialLotNumber != null)
                                                                        {
                                                                                if (ItemLineRet.ORSerialLotNumber.SerialNumber != null)
                                                                                {
                                                                                //Get value of SerialNumber
                                                                                if (ItemLineRet.ORSerialLotNumber.SerialNumber != null)
                                                                                {
                                                                                string SerialNumber1859 = (string)ItemLineRet.ORSerialLotNumber.SerialNumber.GetValue();
                                                                                }
                                                                                }
                                                                                if (ItemLineRet.ORSerialLotNumber.LotNumber != null)
                                                                                {
                                                                                //Get value of LotNumber
                                                                                if (ItemLineRet.ORSerialLotNumber.LotNumber != null)
                                                                                {
                                                                                string LotNumber1860 = (string)ItemLineRet.ORSerialLotNumber.LotNumber.GetValue();
                                                                                }
                                                                                }
                                                                        }
                                                                        //Get value of ExpirationDateForSerialLotNumber
                                                                        if (ItemLineRet.ExpirationDateForSerialLotNumber != null)
                                                                        {
                                                                                string ExpDate = (string)ItemLineRet.ExpirationDateForSerialLotNumber.GetValue();
                                                                        }
                                                                        //Get value of Desc
                                                                        if (ItemLineRet.Desc != null)
                                                                        {
                                                                                string Desc1861 = (string)ItemLineRet.Desc.GetValue();
                                                                        }
                                                                        //Get value of Quantity
                                                                        if (ItemLineRet.Quantity != null)
                                                                        {
                                                                                int Quantity1862 = (int)ItemLineRet.Quantity.GetValue();
                                                                        }
                                                                        //Get value of UnitOfMeasure
                                                                        if (ItemLineRet.UnitOfMeasure != null)
                                                                        {
                                                                                string UnitOfMeasure1863 = (string)ItemLineRet.UnitOfMeasure.GetValue();
                                                                        }
                                                                        if (ItemLineRet.OverrideUOMSetRef != null)
                                                                        {
                                                                                //Get value of ListID
                                                                                if (ItemLineRet.OverrideUOMSetRef.ListID != null)
                                                                                {
                                                                                string ListID1864 = (string)ItemLineRet.OverrideUOMSetRef.ListID.GetValue();
                                                                                }
                                                                                //Get value of FullName
                                                                                if (ItemLineRet.OverrideUOMSetRef.FullName != null)
                                                                                {
                                                                                string FullName1865 = (string)ItemLineRet.OverrideUOMSetRef.FullName.GetValue();
                                                                                }
                                                                        }
                                                                        //Get value of Cost
                                                                        if (ItemLineRet.Cost != null)
                                                                        {
                                                                                double Cost1866 = (double)ItemLineRet.Cost.GetValue();
                                                                        }
                                                                        //Get value of Amount
                                                                        if (ItemLineRet.Amount != null)
                                                                        {
                                                                                double Amount1867 = (double)ItemLineRet.Amount.GetValue();
                                                                        }
                                                                        if (ItemLineRet.CustomerRef != null)
                                                                        {
                                                                                //Get value of ListID
                                                                                if (ItemLineRet.CustomerRef.ListID != null)
                                                                                {
                                                                                string ListID1868 = (string)ItemLineRet.CustomerRef.ListID.GetValue();
                                                                                }
                                                                                //Get value of FullName
                                                                                if (ItemLineRet.CustomerRef.FullName != null)
                                                                                {
                                                                                string FullName1869 = (string)ItemLineRet.CustomerRef.FullName.GetValue();
                                                                                }
                                                                        }
                                                                        if (ItemLineRet.ClassRef != null)
                                                                        {
                                                                                //Get value of ListID
                                                                                if (ItemLineRet.ClassRef.ListID != null)
                                                                                {
                                                                                string ListID1870 = (string)ItemLineRet.ClassRef.ListID.GetValue();
                                                                                }
                                                                                //Get value of FullName
                                                                                if (ItemLineRet.ClassRef.FullName != null)
                                                                                {
                                                                                string FullName1871 = (string)ItemLineRet.ClassRef.FullName.GetValue();
                                                                                }
                                                                        }
                                                                        if (ItemLineRet.SalesTaxCodeRef != null)
                                                                        {
                                                                                //Get value of ListID
                                                                                if (ItemLineRet.SalesTaxCodeRef.ListID != null)
                                                                                {
                                                                                string ListID1872 = (string)ItemLineRet.SalesTaxCodeRef.ListID.GetValue();
                                                                                }
                                                                                //Get value of FullName
                                                                                if (ItemLineRet.SalesTaxCodeRef.FullName != null)
                                                                                {
                                                                                string FullName1873 = (string)ItemLineRet.SalesTaxCodeRef.FullName.GetValue();
                                                                                }
                                                                        }
                                                                        //Get value of BillableStatus
                                                                        if (ItemLineRet.BillableStatus != null)
                                                                        {
                                                                                ENBillableStatus BillableStatus1874 = (ENBillableStatus)ItemLineRet.BillableStatus.GetValue();
                                                                        }
                                                                        if (ItemLineRet.SalesRepRef != null)
                                                                        {
                                                                                //Get value of ListID
                                                                                if (ItemLineRet.SalesRepRef.ListID != null)
                                                                                {
                                                                                string ListID1875 = (string)ItemLineRet.SalesRepRef.ListID.GetValue();
                                                                                }
                                                                                //Get value of FullName
                                                                                if (ItemLineRet.SalesRepRef.FullName != null)
                                                                                {
                                                                                string FullName1876 = (string)ItemLineRet.SalesRepRef.FullName.GetValue();
                                                                                }
                                                                        }
                                                                        if (ItemLineRet.DataExtRetList != null)
                                                                        {
                                                                                for (int i1877 = 0; i1877 < ItemLineRet.DataExtRetList.Count; i1877++)
                                                                                {
                                                                                IDataExtRet DataExtRet = ItemLineRet.DataExtRetList.GetAt(i1877);
                                                                                //Get value of OwnerID
                                                                                if (DataExtRet.OwnerID != null)
                                                                                {
                                                                                string OwnerID1878 = (string)DataExtRet.OwnerID.GetValue();
                                                                                }
                                                                                //Get value of DataExtName
                                                                                string DataExtName1879 = (string)DataExtRet.DataExtName.GetValue();
                                                                                //Get value of DataExtType
                                                                                ENDataExtType DataExtType1880 = (ENDataExtType)DataExtRet.DataExtType.GetValue();
                                                                                //Get value of DataExtValue
                                                                                string DataExtValue1881 = (string)DataExtRet.DataExtValue.GetValue();
                                                                                }
                                                                        }
                                                                }
                                                        }
                                                        if (ORItemLineRet1809.ItemGroupLineRet.DataExtList != null)
                                                        {
                                                                for (int i1882 = 0; i1882 < ORItemLineRet1809.ItemGroupLineRet.DataExtList.Count; i1882++)
                                                                {
                                                                        IDataExt DataExt = ORItemLineRet1809.ItemGroupLineRet.DataExtList.GetAt(i1882);
                                                                        //Get value of OwnerID
                                                                        string OwnerID1883 = (string)DataExt.OwnerID.GetValue();
                                                                        //Get value of DataExtName
                                                                        string DataExtName1884 = (string)DataExt.DataExtName.GetValue();
                                                                        //Get value of DataExtValue
                                                                        string DataExtValue1885 = (string)DataExt.DataExtValue.GetValue();
                                                                }
                                                        }
                                                }
                                        }
                                }
                        }
                        //Get value of OpenAmount
                        if (BillRet.OpenAmount != null)
                        {
                                double OpenAmount1886 = (double)BillRet.OpenAmount.GetValue();
                        }
                        if (BillRet.DataExtRetList != null)
                        {
                                for (int i1887 = 0; i1887 < BillRet.DataExtRetList.Count; i1887++)
                                {
                                        IDataExtRet DataExtRet = BillRet.DataExtRetList.GetAt(i1887);
                                        //Get value of OwnerID
                                        if (DataExtRet.OwnerID != null)
                                        {
                                                string OwnerID1888 = (string)DataExtRet.OwnerID.GetValue();
                                        }
                                        //Get value of DataExtName
                                        string DataExtName1889 = (string)DataExtRet.DataExtName.GetValue();
                                        //Get value of DataExtType
                                        ENDataExtType DataExtType1890 = (ENDataExtType)DataExtRet.DataExtType.GetValue();
                                        //Get value of DataExtValue
                                        string DataExtValue1891 = (string)DataExtRet.DataExtValue.GetValue();
                                }
                        }
                }




        }
}