JournalEntryQuery

In traditional accounting, transactions are entered into the general journal and categorized exclusively by account. In QuickBooks, most transactions can be categorized either by account or by type (invoice, check, and so on). For a few activities in QuickBooks, you must use the general journal directly, for example for recording depreciation. Notice that you must supply the credit line and a corresponding debit line in the same request. It will not work to supply them in two distinct requests. You can supply as many credit lines and debit lines in one single request as you want so long as the total monetary amount from the credits equals the total monetary amount from the debits in that request. Finally, DO NOT supply negative sign for the monetary amounts. QuickBooks does that for you. If you do supply the negative sign amounts will add instead of cancel and you’ll get a runtime error. Querying for Condensed Transactions If you need the query to return condensed transactions, you can do this by using either an Entity or Account filter in the journal query request. Alternatively, you could use the The generic TransactionQuery, which can return condensed transactions.


Request

Response

XMLOps

VB.NET

C#

Tag Type Max length Implementation Required

IJournalEntryQuery

In traditional accounting, transactions are entered into the general journal and categorized exclusively by account. In QuickBooks, most transactions can be categorized either by account or by type (invoice, check, and so on). For a few activities in QuickBooks, you must use the general journal directly, for example for recording depreciation. Notice that you must supply the credit line and a corresponding debit line in the same request. It will not work to supply them in two distinct requests. You can supply as many credit lines and debit lines in one single request as you want so long as the total monetary amount from the credits equals the total monetary amount from the debits in that request. Finally, DO NOT supply negative sign for the monetary amounts. QuickBooks does that for you. If you do supply the negative sign amounts will add instead of cancel and you’ll get a runtime error.Querying for Condensed Transactions If you need the query to return condensed transactions, you can do this by using either an Entity or Account filter in the journal query request. Alternatively, you could use the The generic TransactionQuery, which can return condensed transactions.
       

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  

ORTxnQuery

IORTxnQuery      

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  

TxnFilter

The ITxnFilter group object allows you to search according to various criteria.
ITxnFilter      

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, orthe 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    

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      

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

In traditional accounting, transactions are entered into the general journal and categorized exclusively by account. In QuickBooks, most transactions can be categorized either by account or by type (invoice, check, and so on). For a few activities in QuickBooks, you must use the general journal directly, for example for recording depreciation. Notice that you must supply the credit line and a corresponding debit line in the same request. It will not work to supply them in two distinct requests. You can supply as many credit lines and debit lines in one single request as you want so long as the total monetary amount from the credits equals the total monetary amount from the debits in that request. Finally, DO NOT supply negative sign for the monetary amounts. QuickBooks does that for you. If you do supply the negative sign amounts will add instead of cancel and you’ll get a runtime error.Querying for Condensed Transactions If you need the query to return condensed transactions, you can do this by using either an Entity or Account filter in the journal query request. Alternatively, you could use the The generic TransactionQuery, which can return condensed transactions.
       

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

IJournalEntryRetList      

(List

of IJournalEntryRet 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      

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 11 chars    

IsAdjustment

When a change is an “adjustment,” the original information is retained, usually so an accountant can see the effects of the adjustment.
IQBBoolType   3.0  

IsHomeCurrencyAdjustment

Indicates whether the transaction is using a home currency or foreign currency.
IQBBoolType   8.0  

IsAmountsEnteredInHomeCurrency

Flag that indicates the amount being entered is in the home currency.
IQBBoolType   8.0  

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  

ExternalGUID

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

ORJournalLineList

IORJournalLineList      

(List

of IORJournalLine Objects)
       

JournalDebitLine

If no amount is included in the first debit line (or credit line) of a journal entry in the QuickBooks user interface, then subsequent SDK queries on that JournalEntry object will fail XML validation.
IJournalDebitLine      

defMacro

Note that defMacro was introduced with SDK 2.0, so it only works with 2.0 and higher requests. You can use the defMacro attribute to assign a name to the TxnID or TxnListID that this aggregate will return. This way you can refer to the transaction by name in a later request. For example, if you were using the qbXML API and you defined an invoice add request with the name TxnID:RecvPmt1234, as shown below, then you could refer to that invoice by name in a later receive payment add request: … … …If you use macros with QBOE… There may be a bug in the QBOE implementation of this feature. If this feature is not working for you in QBOE, try stripping the prefix “TxnID:” from the name of the useMacro. For example, defMacro=”TxnID:RecvPmt1234” and useMacro=”RecvPmt1234”
IQBStringType   2.0  

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      

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.
IQBStringType 4095 chars    

EntityRef

A QuickBooks “entity” is a customer, vendor, employee, or person on the QuickBooks “other names” list. Special cases to note: In a BillToPayQuery message, EntityRef refers to the vendor name.In JournalCreditLine and JournalDebitLine messages for A/R accounts, EntityRef must refer to a customer, or else the transaction will not be recorded. For A/P accounts the EntityRef must refer to a vendor, or else the transaction will not be recorded.In a TimeTracking message, EntityRef cannot refer to a customer, only to an employee, vendor, or person on the “other names” list whose time is being tracked.
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    

ItemSalesTaxRef

A sales-tax item is used to calculate a single sales tax that is collected at a specified rate and paid to a single agency. (Compare with the ItemSalesTaxGroupAdd message.) An ItemSalesTaxRef aggregate refers to an item on this list. In a request, if an ItemSalesTaxRef aggregate includes both FullName and ListID, FullName will be ignored. Taxes can be reflected in transaction line items The following information refers to invoices specifically, but it also applies to sales receipts. Generally its best to assign a tax item or tax group item to an invoice and allow QuickBooks to apply the same tax to all taxable items on the invoice. However in some situations multiple tax combinations are required, so this method doesn’t work. In this case one must use techniques to apply the taxes in the invoice itself as line items. Using lines to apply taxes isn’t always straight forward. When applying taxes as line items, only single tax items can be used, tax groups can only be used for the entire invoice. If you have multiple taxes which apply to all taxable items, and one or more other taxes that only apply to some of the items on an invoice its better to use a tax group which applies to the entire invoice for the taxes which applies to all taxable items and then apply the other taxes in the invoice itself. One applies a tax or tax group to an entire invoice by using the ItemSalesTaxRef aggregate. One can use subtotals to apply a single tax line to multiple items in an invoice, but the tax is only applied automatically for the first tax line after the subtotal line. Any other tax lines which need to be applied to the subtotal line must supply their own amount. If you don’t supply an amount the amount comes out as zero and the tax line is useless. When one does supply an amount, the amount of tax on the subtotal also shows up in the rate column for that tax line. There isn’t any way for the rate to show up as anything other than the amount of the tax. If you have a complicated tax situation where no single tax applies to all taxable items on the invoice, you must choose a zero percent tax to apply for the entire invoice. It is recommended to name such a tax item “Tax Calculated On Invoice” so that it’s clear that the tax is not being applied by QuickBooks on the entire invoice.
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 31 chars 6.0 CA.png uk.png  

BillableStatus

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

JournalCreditLine

If no amount is included in the first credit line (or debit line) of a journal entry in the QuickBooks user interface, then subsequent SDK queries on that JournalEntry object will fail XML validation.
IJournalCreditLine      

defMacro

Note that defMacro was introduced with SDK 2.0, so it only works with 2.0 and higher requests. You can use the defMacro attribute to assign a name to the TxnID or TxnListID that this aggregate will return. This way you can refer to the transaction by name in a later request. For example, if you were using the qbXML API and you defined an invoice add request with the name TxnID:RecvPmt1234, as shown below, then you could refer to that invoice by name in a later receive payment add request: … … …If you use macros with QBOE… There may be a bug in the QBOE implementation of this feature. If this feature is not working for you in QBOE, try stripping the prefix “TxnID:” from the name of the useMacro. For example, defMacro=”TxnID:RecvPmt1234” and useMacro=”RecvPmt1234”
IQBStringType   2.0  

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      

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.
IQBStringType 4095 chars    

EntityRef

A QuickBooks “entity” is a customer, vendor, employee, or person on the QuickBooks “other names” list. Special cases to note: In a BillToPayQuery message, EntityRef refers to the vendor name.In JournalCreditLine and JournalDebitLine messages for A/R accounts, EntityRef must refer to a customer, or else the transaction will not be recorded. For A/P accounts the EntityRef must refer to a vendor, or else the transaction will not be recorded.In a TimeTracking message, EntityRef cannot refer to a customer, only to an employee, vendor, or person on the “other names” list whose time is being tracked.
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    

ItemSalesTaxRef

A sales-tax item is used to calculate a single sales tax that is collected at a specified rate and paid to a single agency. (Compare with the ItemSalesTaxGroupAdd message.) An ItemSalesTaxRef aggregate refers to an item on this list. In a request, if an ItemSalesTaxRef aggregate includes both FullName and ListID, FullName will be ignored. Taxes can be reflected in transaction line items The following information refers to invoices specifically, but it also applies to sales receipts. Generally its best to assign a tax item or tax group item to an invoice and allow QuickBooks to apply the same tax to all taxable items on the invoice. However in some situations multiple tax combinations are required, so this method doesn’t work. In this case one must use techniques to apply the taxes in the invoice itself as line items. Using lines to apply taxes isn’t always straight forward. When applying taxes as line items, only single tax items can be used, tax groups can only be used for the entire invoice. If you have multiple taxes which apply to all taxable items, and one or more other taxes that only apply to some of the items on an invoice its better to use a tax group which applies to the entire invoice for the taxes which applies to all taxable items and then apply the other taxes in the invoice itself. One applies a tax or tax group to an entire invoice by using the ItemSalesTaxRef aggregate. One can use subtotals to apply a single tax line to multiple items in an invoice, but the tax is only applied automatically for the first tax line after the subtotal line. Any other tax lines which need to be applied to the subtotal line must supply their own amount. If you don’t supply an amount the amount comes out as zero and the tax line is useless. When one does supply an amount, the amount of tax on the subtotal also shows up in the rate column for that tax line. There isn’t any way for the rate to show up as anything other than the amount of the tax. If you have a complicated tax situation where no single tax applies to all taxable items on the invoice, you must choose a zero percent tax to apply for the entire invoice. It is recommended to name such a tax item “Tax Calculated On Invoice” so that it’s clear that the tax is not being applied by QuickBooks on the entire invoice.
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 31 chars 6.0 CA.png uk.png  

BillableStatus

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

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
<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="16.0"?>
<QBXML>
        <QBXMLMsgsRq onError="stopOnError">
                <JournalEntryQueryRq 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>
                        <!-- END OR -->
                        <IncludeLineItems >BOOLTYPE</IncludeLineItems> <!-- optional -->
                        <IncludeRetElement >STRTYPE</IncludeRetElement> <!-- optional, may repeat -->
                        <OwnerID >GUIDTYPE</OwnerID> <!-- optional, may repeat -->
                </JournalEntryQueryRq>

                <JournalEntryQueryRs statusCode="INTTYPE" statusSeverity="STRTYPE" statusMessage="STRTYPE" retCount="INTTYPE" iteratorRemainingCount="INTTYPE" iteratorID="UUIDTYPE">
                        <JournalEntryRet> <!-- optional, may repeat -->
                                <TxnID >IDTYPE</TxnID> <!-- required -->
                                <TimeCreated >DATETIMETYPE</TimeCreated> <!-- required -->
                                <TimeModified >DATETIMETYPE</TimeModified> <!-- required -->
                                <EditSequence >STRTYPE</EditSequence> <!-- required -->
                                <TxnNumber >INTTYPE</TxnNumber> <!-- optional -->
                                <TxnDate >DATETYPE</TxnDate> <!-- required -->
                                <RefNumber >STRTYPE</RefNumber> <!-- optional -->
                                <IsAdjustment >BOOLTYPE</IsAdjustment> <!-- optional -->
                                <IsHomeCurrencyAdjustment >BOOLTYPE</IsHomeCurrencyAdjustment> <!-- optional -->
                                <IsAmountsEnteredInHomeCurrency >BOOLTYPE</IsAmountsEnteredInHomeCurrency> <!-- optional -->
                                <CurrencyRef> <!-- optional -->
                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                </CurrencyRef>
                                <ExchangeRate >FLOATTYPE</ExchangeRate> <!-- optional -->
                                <ExternalGUID >GUIDTYPE</ExternalGUID> <!-- optional -->
                                <!-- BEGIN OR -->
                                        <JournalDebitLine defMacro="MACROTYPE"> <!-- optional -->
                                                <TxnLineID >IDTYPE</TxnLineID> <!-- optional -->
                                                <AccountRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </AccountRef>
                                                <Amount >AMTTYPE</Amount> <!-- optional -->
                                                <Memo >STRTYPE</Memo> <!-- optional -->
                                                <EntityRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </EntityRef>
                                                <ClassRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </ClassRef>
                                                <ItemSalesTaxRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </ItemSalesTaxRef>
                                                <!-- BillableStatus may have one of the following values: Billable, NotBillable, HasBeenBilled -->
                                                <BillableStatus >ENUMTYPE</BillableStatus> <!-- optional -->
                                        </JournalDebitLine>
                                <!-- OR -->
                                        <JournalCreditLine defMacro="MACROTYPE"> <!-- optional -->
                                                <TxnLineID >IDTYPE</TxnLineID> <!-- optional -->
                                                <AccountRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </AccountRef>
                                                <Amount >AMTTYPE</Amount> <!-- optional -->
                                                <Memo >STRTYPE</Memo> <!-- optional -->
                                                <EntityRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </EntityRef>
                                                <ClassRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </ClassRef>
                                                <ItemSalesTaxRef> <!-- optional -->
                                                        <ListID >IDTYPE</ListID> <!-- optional -->
                                                        <FullName >STRTYPE</FullName> <!-- optional -->
                                                </ItemSalesTaxRef>
                                                <!-- BillableStatus may have one of the following values: Billable, NotBillable, HasBeenBilled -->
                                                <BillableStatus >ENUMTYPE</BillableStatus> <!-- optional -->
                                        </JournalCreditLine>
                                <!-- END OR -->
                                <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>
                        </JournalEntryRet>
                </JournalEntryQueryRs>
        </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
'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  DoJournalEntryQuery()
                        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

                                BuildJournalEntryQueryRq(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

                                WalkJournalEntryQueryRs(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 BuildJournalEntryQueryRq(requestMsgSet as IMsgSetRequest)
                        Dim JournalEntryQueryRq as IJournalEntryQuery
                        JournalEntryQueryRq= requestMsgSet.AppendJournalEntryQueryRq()
                        Dim ORTxnQueryElementType16633 as String
                        ORTxnQueryElementType16633 = "TxnIDList"
                        if (ORTxnQueryElementType16633 == "TxnIDList") then
                                'Set field value for TxnIDList
                                'May create more than one of these if needed
                                JournalEntryQueryRq.ORTxnQuery.TxnIDList.Add("200000-1011023419")
                        End If
                        if (ORTxnQueryElementType16633 == "RefNumberList") then
                                'Set field value for RefNumberList
                                'May create more than one of these if needed
                                JournalEntryQueryRq.ORTxnQuery.RefNumberList.Add("ab")
                        End If
                        if (ORTxnQueryElementType16633 == "RefNumberCaseSensitiveList") then
                                'Set field value for RefNumberCaseSensitiveList
                                'May create more than one of these if needed
                                JournalEntryQueryRq.ORTxnQuery.RefNumberCaseSensitiveList.Add("ab")
                        End If
                        if (ORTxnQueryElementType16633 == "TxnFilter") then
                                'Set field value for MaxReturned
                                JournalEntryQueryRq.ORTxnQuery.TxnFilter.MaxReturned.SetValue(6)
                                Dim ORDateRangeFilterElementType16634 as String
                                ORDateRangeFilterElementType16634 = "ModifiedDateRangeFilter"
                                if (ORDateRangeFilterElementType16634 == "ModifiedDateRangeFilter") then
                                        'Set field value for FromModifiedDate
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
                                        'Set field value for ToModifiedDate
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
                                End If
                                if (ORDateRangeFilterElementType16634 == "TxnDateRangeFilter") then
                                        Dim ORTxnDateRangeFilterElementType16635 as String
                                        ORTxnDateRangeFilterElementType16635 = "TxnDateFilter"
                                        if (ORTxnDateRangeFilterElementType16635 == "TxnDateFilter") then
                                                'Set field value for FromTxnDate
                                                JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007"))
                                                'Set field value for ToTxnDate
                                                JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007"))
                                        End If
                                        if (ORTxnDateRangeFilterElementType16635 == "DateMacro") then
                                                'Set field value for DateMacro
                                                JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll)
                                        End If
                                End If
                                Dim OREntityFilterElementType16636 as String
                                OREntityFilterElementType16636 = "ListIDList"
                                if (OREntityFilterElementType16636 == "ListIDList") then
                                        'Set field value for ListIDList
                                        'May create more than one of these if needed
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.ListIDList.Add("200000-1011023419")
                                End If
                                if (OREntityFilterElementType16636 == "FullNameList") then
                                        'Set field value for FullNameList
                                        'May create more than one of these if needed
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.FullNameList.Add("ab")
                                End If
                                if (OREntityFilterElementType16636 == "ListIDWithChildren") then
                                        'Set field value for ListIDWithChildren
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.ListIDWithChildren.SetValue("200000-1011023419")
                                End If
                                if (OREntityFilterElementType16636 == "FullNameWithChildren") then
                                        'Set field value for FullNameWithChildren
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.FullNameWithChildren.SetValue("ab")
                                End If
                                Dim ORAccountFilterElementType16637 as String
                                ORAccountFilterElementType16637 = "ListIDList"
                                if (ORAccountFilterElementType16637 == "ListIDList") then
                                        'Set field value for ListIDList
                                        'May create more than one of these if needed
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.ListIDList.Add("200000-1011023419")
                                End If
                                if (ORAccountFilterElementType16637 == "FullNameList") then
                                        'Set field value for FullNameList
                                        'May create more than one of these if needed
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.FullNameList.Add("ab")
                                End If
                                if (ORAccountFilterElementType16637 == "ListIDWithChildren") then
                                        'Set field value for ListIDWithChildren
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.ListIDWithChildren.SetValue("200000-1011023419")
                                End If
                                if (ORAccountFilterElementType16637 == "FullNameWithChildren") then
                                        'Set field value for FullNameWithChildren
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.FullNameWithChildren.SetValue("ab")
                                End If
                                Dim ORRefNumberFilterElementType16638 as String
                                ORRefNumberFilterElementType16638 = "RefNumberFilter"
                                if (ORRefNumberFilterElementType16638 == "RefNumberFilter") then
                                        'Set field value for MatchCriterion
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.MatchCriterion.SetValue(ENMatchCriterion.mcStartsWith)
                                        'Set field value for RefNumber
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.RefNumber.SetValue("ab")
                                End If
                                if (ORRefNumberFilterElementType16638 == "RefNumberRangeFilter") then
                                        'Set field value for FromRefNumber
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberRangeFilter.FromRefNumber.SetValue("ab")
                                        'Set field value for ToRefNumber
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberRangeFilter.ToRefNumber.SetValue("ab")
                                End If
                                Dim ORCurrencyFilterElementType16639 as String
                                ORCurrencyFilterElementType16639 = "ListIDList"
                                if (ORCurrencyFilterElementType16639 == "ListIDList") then
                                        'Set field value for ListIDList
                                        'May create more than one of these if needed
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.CurrencyFilter.ORCurrencyFilter.ListIDList.Add("200000-1011023419")
                                End If
                                if (ORCurrencyFilterElementType16639 == "FullNameList") then
                                        'Set field value for FullNameList
                                        'May create more than one of these if needed
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.CurrencyFilter.ORCurrencyFilter.FullNameList.Add("ab")
                                End If
                        End If
                        'Set field value for IncludeLineItems
                        JournalEntryQueryRq.IncludeLineItems.SetValue(True)
                        'Set field value for IncludeRetElementList
                        'May create more than one of these if needed
                        JournalEntryQueryRq.IncludeRetElementList.Add("ab")
                        'Set field value for OwnerIDList
                        'May create more than one of these if needed
                        JournalEntryQueryRq.OwnerIDList.Add(System.Guid.NewGuid().ToString())
                End Sub




                Public Sub WalkJournalEntryQueryRs( 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.rtJournalEntryQueryRs) then
                                                        'upcast to more specific type here, this is safe because we checked with response.Type check above
                                                        Dim JournalEntryRet as IJournalEntryRetList
                                                        JournalEntryRet = CType(response.Detail,IJournalEntryRetList)
                                                        WalkJournalEntryRet(JournalEntryRet)
                                                End If
                                        End If
                                End If
                        Next j
                End Sub




                Public Sub WalkJournalEntryRet(JournalEntryRet as IJournalEntryRetList)
                        if (JournalEntryRet is nothing) then
                                Exit Sub
                        End If

                        'Go through all the elements of IJournalEntryRetList
                        'Get value of TxnID
                        Dim TxnID16640 as String
                        TxnID16640 = JournalEntryRet.TxnID.GetValue()
                        'Get value of TimeCreated
                        Dim TimeCreated16641 as DateTime
                        TimeCreated16641 = JournalEntryRet.TimeCreated.GetValue()
                        'Get value of TimeModified
                        Dim TimeModified16642 as DateTime
                        TimeModified16642 = JournalEntryRet.TimeModified.GetValue()
                        'Get value of EditSequence
                        Dim EditSequence16643 as String
                        EditSequence16643 = JournalEntryRet.EditSequence.GetValue()
                        'Get value of TxnNumber
                        if ( not JournalEntryRet.TxnNumber is nothing) then
                                Dim TxnNumber16644 as Integer
                                TxnNumber16644 = JournalEntryRet.TxnNumber.GetValue()
                        End If
                        'Get value of TxnDate
                        Dim TxnDate16645 as DateTime
                        TxnDate16645 = JournalEntryRet.TxnDate.GetValue()
                        'Get value of RefNumber
                        if ( not JournalEntryRet.RefNumber is nothing) then
                                Dim RefNumber16646 as String
                                RefNumber16646 = JournalEntryRet.RefNumber.GetValue()
                        End If
                        'Get value of IsAdjustment
                        if ( not JournalEntryRet.IsAdjustment is nothing) then
                                Dim IsAdjustment16647 as Boolean
                                IsAdjustment16647 = JournalEntryRet.IsAdjustment.GetValue()
                        End If
                        'Get value of IsHomeCurrencyAdjustment
                        if ( not JournalEntryRet.IsHomeCurrencyAdjustment is nothing) then
                                Dim IsHomeCurrencyAdjustment16648 as Boolean
                                IsHomeCurrencyAdjustment16648 = JournalEntryRet.IsHomeCurrencyAdjustment.GetValue()
                        End If
                        'Get value of IsAmountsEnteredInHomeCurrency
                        if ( not JournalEntryRet.IsAmountsEnteredInHomeCurrency is nothing) then
                                Dim IsAmountsEnteredInHomeCurrency16649 as Boolean
                                IsAmountsEnteredInHomeCurrency16649 = JournalEntryRet.IsAmountsEnteredInHomeCurrency.GetValue()
                        End If
                        if (not JournalEntryRet.CurrencyRef. is nothing) then
                                'Get value of ListID
                                if ( not JournalEntryRet.CurrencyRef.ListID is nothing) then
                                        Dim ListID16650 as String
                                        ListID16650 = JournalEntryRet.CurrencyRef.ListID.GetValue()
                                End If
                                'Get value of FullName
                                if ( not JournalEntryRet.CurrencyRef.FullName is nothing) then
                                        Dim FullName16651 as String
                                        FullName16651 = JournalEntryRet.CurrencyRef.FullName.GetValue()
                                End If
                        End If
                        'Get value of ExchangeRate
                        if ( not JournalEntryRet.ExchangeRate is nothing) then
                                Dim ExchangeRate16652 as IQBFloatType
                                ExchangeRate16652 = JournalEntryRet.ExchangeRate.GetValue()
                        End If
                        'Get value of ExternalGUID
                        if ( not JournalEntryRet.ExternalGUID is nothing) then
                                Dim ExternalGUID16653 as String
                                ExternalGUID16653 = JournalEntryRet.ExternalGUID.GetValue()
                        End If
                        if (not JournalEntryRet.ORJournalLineList is nothing) then
                                Dim i16654 as Integer
                                for i16654 = 0 to JournalEntryRet.ORJournalLineList.Count - 1
                                        Dim ORJournalLine16655 as IORJournalLine
                                        ORJournalLine16655 = JournalEntryRet.ORJournalLineList.GetAt(i16654)
                                        if (not ORJournalLine16655.JournalDebitLine is nothing) then
                                                if (not ORJournalLine16655.JournalDebitLine. is nothing) then
                                                        'Get value of TxnLineID
                                                        if ( not ORJournalLine16655.JournalDebitLine.TxnLineID is nothing) then
                                                                Dim TxnLineID16656 as String
                                                                TxnLineID16656 = ORJournalLine16655.JournalDebitLine.TxnLineID.GetValue()
                                                        End If
                                                        if (not ORJournalLine16655.JournalDebitLine.AccountRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORJournalLine16655.JournalDebitLine.AccountRef.ListID is nothing) then
                                                                        Dim ListID16657 as String
                                                                        ListID16657 = ORJournalLine16655.JournalDebitLine.AccountRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORJournalLine16655.JournalDebitLine.AccountRef.FullName is nothing) then
                                                                        Dim FullName16658 as String
                                                                        FullName16658 = ORJournalLine16655.JournalDebitLine.AccountRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        'Get value of Amount
                                                        if ( not ORJournalLine16655.JournalDebitLine.Amount is nothing) then
                                                                Dim Amount16659 as Double
                                                                Amount16659 = ORJournalLine16655.JournalDebitLine.Amount.GetValue()
                                                        End If
                                                        'Get value of Memo
                                                        if ( not ORJournalLine16655.JournalDebitLine.Memo is nothing) then
                                                                Dim Memo16660 as String
                                                                Memo16660 = ORJournalLine16655.JournalDebitLine.Memo.GetValue()
                                                        End If
                                                        if (not ORJournalLine16655.JournalDebitLine.EntityRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORJournalLine16655.JournalDebitLine.EntityRef.ListID is nothing) then
                                                                        Dim ListID16661 as String
                                                                        ListID16661 = ORJournalLine16655.JournalDebitLine.EntityRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORJournalLine16655.JournalDebitLine.EntityRef.FullName is nothing) then
                                                                        Dim FullName16662 as String
                                                                        FullName16662 = ORJournalLine16655.JournalDebitLine.EntityRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        if (not ORJournalLine16655.JournalDebitLine.ClassRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORJournalLine16655.JournalDebitLine.ClassRef.ListID is nothing) then
                                                                        Dim ListID16663 as String
                                                                        ListID16663 = ORJournalLine16655.JournalDebitLine.ClassRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORJournalLine16655.JournalDebitLine.ClassRef.FullName is nothing) then
                                                                        Dim FullName16664 as String
                                                                        FullName16664 = ORJournalLine16655.JournalDebitLine.ClassRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        if (not ORJournalLine16655.JournalDebitLine.ItemSalesTaxRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORJournalLine16655.JournalDebitLine.ItemSalesTaxRef.ListID is nothing) then
                                                                        Dim ListID16665 as String
                                                                        ListID16665 = ORJournalLine16655.JournalDebitLine.ItemSalesTaxRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORJournalLine16655.JournalDebitLine.ItemSalesTaxRef.FullName is nothing) then
                                                                        Dim FullName16666 as String
                                                                        FullName16666 = ORJournalLine16655.JournalDebitLine.ItemSalesTaxRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        'Get value of BillableStatus
                                                        if ( not ORJournalLine16655.JournalDebitLine.BillableStatus is nothing) then
                                                                Dim BillableStatus16667 as ENBillableStatus
                                                                BillableStatus16667 = ORJournalLine16655.JournalDebitLine.BillableStatus.GetValue()
                                                        End If
                                                End If
                                        End If
                                        if (not ORJournalLine16655.JournalCreditLine is nothing) then
                                                if (not ORJournalLine16655.JournalCreditLine. is nothing) then
                                                        'Get value of TxnLineID
                                                        if ( not ORJournalLine16655.JournalCreditLine.TxnLineID is nothing) then
                                                                Dim TxnLineID16668 as String
                                                                TxnLineID16668 = ORJournalLine16655.JournalCreditLine.TxnLineID.GetValue()
                                                        End If
                                                        if (not ORJournalLine16655.JournalCreditLine.AccountRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORJournalLine16655.JournalCreditLine.AccountRef.ListID is nothing) then
                                                                        Dim ListID16669 as String
                                                                        ListID16669 = ORJournalLine16655.JournalCreditLine.AccountRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORJournalLine16655.JournalCreditLine.AccountRef.FullName is nothing) then
                                                                        Dim FullName16670 as String
                                                                        FullName16670 = ORJournalLine16655.JournalCreditLine.AccountRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        'Get value of Amount
                                                        if ( not ORJournalLine16655.JournalCreditLine.Amount is nothing) then
                                                                Dim Amount16671 as Double
                                                                Amount16671 = ORJournalLine16655.JournalCreditLine.Amount.GetValue()
                                                        End If
                                                        'Get value of Memo
                                                        if ( not ORJournalLine16655.JournalCreditLine.Memo is nothing) then
                                                                Dim Memo16672 as String
                                                                Memo16672 = ORJournalLine16655.JournalCreditLine.Memo.GetValue()
                                                        End If
                                                        if (not ORJournalLine16655.JournalCreditLine.EntityRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORJournalLine16655.JournalCreditLine.EntityRef.ListID is nothing) then
                                                                        Dim ListID16673 as String
                                                                        ListID16673 = ORJournalLine16655.JournalCreditLine.EntityRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORJournalLine16655.JournalCreditLine.EntityRef.FullName is nothing) then
                                                                        Dim FullName16674 as String
                                                                        FullName16674 = ORJournalLine16655.JournalCreditLine.EntityRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        if (not ORJournalLine16655.JournalCreditLine.ClassRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORJournalLine16655.JournalCreditLine.ClassRef.ListID is nothing) then
                                                                        Dim ListID16675 as String
                                                                        ListID16675 = ORJournalLine16655.JournalCreditLine.ClassRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORJournalLine16655.JournalCreditLine.ClassRef.FullName is nothing) then
                                                                        Dim FullName16676 as String
                                                                        FullName16676 = ORJournalLine16655.JournalCreditLine.ClassRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        if (not ORJournalLine16655.JournalCreditLine.ItemSalesTaxRef. is nothing) then
                                                                'Get value of ListID
                                                                if ( not ORJournalLine16655.JournalCreditLine.ItemSalesTaxRef.ListID is nothing) then
                                                                        Dim ListID16677 as String
                                                                        ListID16677 = ORJournalLine16655.JournalCreditLine.ItemSalesTaxRef.ListID.GetValue()
                                                                End If
                                                                'Get value of FullName
                                                                if ( not ORJournalLine16655.JournalCreditLine.ItemSalesTaxRef.FullName is nothing) then
                                                                        Dim FullName16678 as String
                                                                        FullName16678 = ORJournalLine16655.JournalCreditLine.ItemSalesTaxRef.FullName.GetValue()
                                                                End If
                                                        End If
                                                        'Get value of BillableStatus
                                                        if ( not ORJournalLine16655.JournalCreditLine.BillableStatus is nothing) then
                                                                Dim BillableStatus16679 as ENBillableStatus
                                                                BillableStatus16679 = ORJournalLine16655.JournalCreditLine.BillableStatus.GetValue()
                                                        End If
                                                End If
                                        End If
                                Next i16654
                        End If
                        if (not JournalEntryRet.DataExtRetList is nothing)
                                Dim i16680 as Integer
                                for i16680 = 0  to JournalEntryRet.DataExtRetList.Count - 1
                                        Dim DataExtRet as IDataExtRet
                                        DataExtRet = JournalEntryRet.DataExtRetList.GetAt(i16680)
                                        'Get value of OwnerID
                                        if ( not DataExtRetOwnerID is nothing) then
                                                Dim OwnerID16681 as String
                                                OwnerID16681 = DataExtRetOwnerID.GetValue()
                                        End If
                                        'Get value of DataExtName
                                        Dim DataExtName16682 as String
                                        DataExtName16682 = DataExtRetDataExtName.GetValue()
                                        'Get value of DataExtType
                                        Dim DataExtType16683 as ENDataExtType
                                        DataExtType16683 = DataExtRetDataExtType.GetValue()
                                        'Get value of DataExtValue
                                        Dim DataExtValue16684 as String
                                        DataExtValue16684 = DataExtRetDataExtValue.GetValue()
                                Next i16680
                        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
//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  DoJournalEntryQuery()
                {
                        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;

                                BuildJournalEntryQueryRq(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;

                                WalkJournalEntryQueryRs(responseMsgSet);
                        }
                        catch (Exception e)
                        {
                                MessageBox.Show(e.Message, "Error");
                                if (sessionBegun)
                                {
                                        sessionManager.EndSession();
                                }
                                if (connectionOpen)
                                {
                                        sessionManager.CloseConnection();
                                }
                        }
                }
                void BuildJournalEntryQueryRq(IMsgSetRequest requestMsgSet)
                {
                        IJournalEntryQuery JournalEntryQueryRq= requestMsgSet.AppendJournalEntryQueryRq();
                        //Set attributes
                        //Set field value for metaData
                        JournalEntryQueryRq.metaData.SetValue("IQBENmetaDataType");
                        //Set field value for iterator
                        JournalEntryQueryRq.iterator.SetValue("IQBENiteratorType");
                        //Set field value for iteratorID
                        JournalEntryQueryRq.iteratorID.SetValue("IQBUUIDType");
                        string ORTxnQueryElementType16581 = "TxnIDList";
                        if (ORTxnQueryElementType16581 == "TxnIDList")
                        {
                                //Set field value for TxnIDList
                                //May create more than one of these if needed
                                JournalEntryQueryRq.ORTxnQuery.TxnIDList.Add("200000-1011023419");
                        }
                        if (ORTxnQueryElementType16581 == "RefNumberList")
                        {
                                //Set field value for RefNumberList
                                //May create more than one of these if needed
                                JournalEntryQueryRq.ORTxnQuery.RefNumberList.Add("ab");
                        }
                        if (ORTxnQueryElementType16581 == "RefNumberCaseSensitiveList")
                        {
                                //Set field value for RefNumberCaseSensitiveList
                                //May create more than one of these if needed
                                JournalEntryQueryRq.ORTxnQuery.RefNumberCaseSensitiveList.Add("ab");
                        }
                        if (ORTxnQueryElementType16581 == "TxnFilter")
                        {
                                //Set field value for MaxReturned
                                JournalEntryQueryRq.ORTxnQuery.TxnFilter.MaxReturned.SetValue(6);
                                string ORDateRangeFilterElementType16582 = "ModifiedDateRangeFilter";
                                if (ORDateRangeFilterElementType16582 == "ModifiedDateRangeFilter")
                                {
                                        //Set field value for FromModifiedDate
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false);
                                        //Set field value for ToModifiedDate
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false);
                                }
                                if (ORDateRangeFilterElementType16582 == "TxnDateRangeFilter")
                                {
                                        string ORTxnDateRangeFilterElementType16583 = "TxnDateFilter";
                                        if (ORTxnDateRangeFilterElementType16583 == "TxnDateFilter")
                                        {
                                                //Set field value for FromTxnDate
                                                JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007"));
                                                //Set field value for ToTxnDate
                                                JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007"));
                                        }
                                        if (ORTxnDateRangeFilterElementType16583 == "DateMacro")
                                        {
                                                //Set field value for DateMacro
                                                JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll);
                                        }
                                }
                                string OREntityFilterElementType16584 = "ListIDList";
                                if (OREntityFilterElementType16584 == "ListIDList")
                                {
                                        //Set field value for ListIDList
                                        //May create more than one of these if needed
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.ListIDList.Add("200000-1011023419");
                                }
                                if (OREntityFilterElementType16584 == "FullNameList")
                                {
                                        //Set field value for FullNameList
                                        //May create more than one of these if needed
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.FullNameList.Add("ab");
                                }
                                if (OREntityFilterElementType16584 == "ListIDWithChildren")
                                {
                                        //Set field value for ListIDWithChildren
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.ListIDWithChildren.SetValue("200000-1011023419");
                                }
                                if (OREntityFilterElementType16584 == "FullNameWithChildren")
                                {
                                        //Set field value for FullNameWithChildren
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.FullNameWithChildren.SetValue("ab");
                                }
                                string ORAccountFilterElementType16585 = "ListIDList";
                                if (ORAccountFilterElementType16585 == "ListIDList")
                                {
                                        //Set field value for ListIDList
                                        //May create more than one of these if needed
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.ListIDList.Add("200000-1011023419");
                                }
                                if (ORAccountFilterElementType16585 == "FullNameList")
                                {
                                        //Set field value for FullNameList
                                        //May create more than one of these if needed
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.FullNameList.Add("ab");
                                }
                                if (ORAccountFilterElementType16585 == "ListIDWithChildren")
                                {
                                        //Set field value for ListIDWithChildren
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.ListIDWithChildren.SetValue("200000-1011023419");
                                }
                                if (ORAccountFilterElementType16585 == "FullNameWithChildren")
                                {
                                        //Set field value for FullNameWithChildren
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.FullNameWithChildren.SetValue("ab");
                                }
                                string ORRefNumberFilterElementType16586 = "RefNumberFilter";
                                if (ORRefNumberFilterElementType16586 == "RefNumberFilter")
                                {
                                        //Set field value for MatchCriterion
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.MatchCriterion.SetValue(ENMatchCriterion.mcStartsWith);
                                        //Set field value for RefNumber
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.RefNumber.SetValue("ab");
                                }
                                if (ORRefNumberFilterElementType16586 == "RefNumberRangeFilter")
                                {
                                        //Set field value for FromRefNumber
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberRangeFilter.FromRefNumber.SetValue("ab");
                                        //Set field value for ToRefNumber
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberRangeFilter.ToRefNumber.SetValue("ab");
                                }
                                string ORCurrencyFilterElementType16587 = "ListIDList";
                                if (ORCurrencyFilterElementType16587 == "ListIDList")
                                {
                                        //Set field value for ListIDList
                                        //May create more than one of these if needed
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.CurrencyFilter.ORCurrencyFilter.ListIDList.Add("200000-1011023419");
                                }
                                if (ORCurrencyFilterElementType16587 == "FullNameList")
                                {
                                        //Set field value for FullNameList
                                        //May create more than one of these if needed
                                        JournalEntryQueryRq.ORTxnQuery.TxnFilter.CurrencyFilter.ORCurrencyFilter.FullNameList.Add("ab");
                                }
                        }
                        //Set field value for IncludeLineItems
                        JournalEntryQueryRq.IncludeLineItems.SetValue(true);
                        //Set field value for IncludeRetElementList
                        //May create more than one of these if needed
                        JournalEntryQueryRq.IncludeRetElementList.Add("ab");
                        //Set field value for OwnerIDList
                        //May create more than one of these if needed
                        JournalEntryQueryRq.OwnerIDList.Add(Guid.NewGuid().ToString());
                }




                void WalkJournalEntryQueryRs(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.rtJournalEntryQueryRs)
                                                {
                                                        //upcast to more specific type here, this is safe because we checked with response.Type check above
                                                        IJournalEntryRetList JournalEntryRet = (IJournalEntryRetList)response.Detail;
                                                        WalkJournalEntryRet(JournalEntryRet);
                                                }
                                        }
                                }
                        }
                }




                void WalkJournalEntryRet(IJournalEntryRetList JournalEntryRet)
                {
                        if (JournalEntryRet == null) return;
                        //Go through all the elements of IJournalEntryRetList
                        //Get value of TxnID
                        string TxnID16588 = (string)JournalEntryRet.TxnID.GetValue();
                        //Get value of TimeCreated
                        DateTime TimeCreated16589 = (DateTime)JournalEntryRet.TimeCreated.GetValue();
                        //Get value of TimeModified
                        DateTime TimeModified16590 = (DateTime)JournalEntryRet.TimeModified.GetValue();
                        //Get value of EditSequence
                        string EditSequence16591 = (string)JournalEntryRet.EditSequence.GetValue();
                        //Get value of TxnNumber
                        if (JournalEntryRet.TxnNumber != null)
                        {
                                int TxnNumber16592 = (int)JournalEntryRet.TxnNumber.GetValue();
                        }
                        //Get value of TxnDate
                        DateTime TxnDate16593 = (DateTime)JournalEntryRet.TxnDate.GetValue();
                        //Get value of RefNumber
                        if (JournalEntryRet.RefNumber != null)
                        {
                                string RefNumber16594 = (string)JournalEntryRet.RefNumber.GetValue();
                        }
                        //Get value of IsAdjustment
                        if (JournalEntryRet.IsAdjustment != null)
                        {
                                bool IsAdjustment16595 = (bool)JournalEntryRet.IsAdjustment.GetValue();
                        }
                        //Get value of IsHomeCurrencyAdjustment
                        if (JournalEntryRet.IsHomeCurrencyAdjustment != null)
                        {
                                bool IsHomeCurrencyAdjustment16596 = (bool)JournalEntryRet.IsHomeCurrencyAdjustment.GetValue();
                        }
                        //Get value of IsAmountsEnteredInHomeCurrency
                        if (JournalEntryRet.IsAmountsEnteredInHomeCurrency != null)
                        {
                                bool IsAmountsEnteredInHomeCurrency16597 = (bool)JournalEntryRet.IsAmountsEnteredInHomeCurrency.GetValue();
                        }
                        if (JournalEntryRet.CurrencyRef != null)
                        {
                                //Get value of ListID
                                if (JournalEntryRet.CurrencyRef.ListID != null)
                                {
                                        string ListID16598 = (string)JournalEntryRet.CurrencyRef.ListID.GetValue();
                                }
                                //Get value of FullName
                                if (JournalEntryRet.CurrencyRef.FullName != null)
                                {
                                        string FullName16599 = (string)JournalEntryRet.CurrencyRef.FullName.GetValue();
                                }
                        }
                        //Get value of ExchangeRate
                        if (JournalEntryRet.ExchangeRate != null)
                        {
                                IQBFloatType ExchangeRate16600 = (IQBFloatType)JournalEntryRet.ExchangeRate.GetValue();
                        }
                        //Get value of ExternalGUID
                        if (JournalEntryRet.ExternalGUID != null)
                        {
                                string ExternalGUID16601 = (string)JournalEntryRet.ExternalGUID.GetValue();
                        }
                        if (JournalEntryRet.ORJournalLineList != null)
                        {
                                for (int i16602 = 0; i16602 < JournalEntryRet.ORJournalLineList.Count; i16602++)
                                {
                                        IORJournalLine ORJournalLine16603 = JournalEntryRet.ORJournalLineList.GetAt(i16602);
                                        if (ORJournalLine16603.JournalDebitLine != null)
                                        {
                                                if (ORJournalLine16603.JournalDebitLine != null)
                                                {
                                                        //Get value of TxnLineID
                                                        if (ORJournalLine16603.JournalDebitLine.TxnLineID != null)
                                                        {
                                                                string TxnLineID16604 = (string)ORJournalLine16603.JournalDebitLine.TxnLineID.GetValue();
                                                        }
                                                        if (ORJournalLine16603.JournalDebitLine.AccountRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORJournalLine16603.JournalDebitLine.AccountRef.ListID != null)
                                                                {
                                                                        string ListID16605 = (string)ORJournalLine16603.JournalDebitLine.AccountRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORJournalLine16603.JournalDebitLine.AccountRef.FullName != null)
                                                                {
                                                                        string FullName16606 = (string)ORJournalLine16603.JournalDebitLine.AccountRef.FullName.GetValue();
                                                                }
                                                        }
                                                        //Get value of Amount
                                                        if (ORJournalLine16603.JournalDebitLine.Amount != null)
                                                        {
                                                                double Amount16607 = (double)ORJournalLine16603.JournalDebitLine.Amount.GetValue();
                                                        }
                                                        //Get value of Memo
                                                        if (ORJournalLine16603.JournalDebitLine.Memo != null)
                                                        {
                                                                string Memo16608 = (string)ORJournalLine16603.JournalDebitLine.Memo.GetValue();
                                                        }
                                                        if (ORJournalLine16603.JournalDebitLine.EntityRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORJournalLine16603.JournalDebitLine.EntityRef.ListID != null)
                                                                {
                                                                        string ListID16609 = (string)ORJournalLine16603.JournalDebitLine.EntityRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORJournalLine16603.JournalDebitLine.EntityRef.FullName != null)
                                                                {
                                                                        string FullName16610 = (string)ORJournalLine16603.JournalDebitLine.EntityRef.FullName.GetValue();
                                                                }
                                                        }
                                                        if (ORJournalLine16603.JournalDebitLine.ClassRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORJournalLine16603.JournalDebitLine.ClassRef.ListID != null)
                                                                {
                                                                        string ListID16611 = (string)ORJournalLine16603.JournalDebitLine.ClassRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORJournalLine16603.JournalDebitLine.ClassRef.FullName != null)
                                                                {
                                                                        string FullName16612 = (string)ORJournalLine16603.JournalDebitLine.ClassRef.FullName.GetValue();
                                                                }
                                                        }
                                                        if (ORJournalLine16603.JournalDebitLine.ItemSalesTaxRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORJournalLine16603.JournalDebitLine.ItemSalesTaxRef.ListID != null)
                                                                {
                                                                        string ListID16613 = (string)ORJournalLine16603.JournalDebitLine.ItemSalesTaxRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORJournalLine16603.JournalDebitLine.ItemSalesTaxRef.FullName != null)
                                                                {
                                                                        string FullName16614 = (string)ORJournalLine16603.JournalDebitLine.ItemSalesTaxRef.FullName.GetValue();
                                                                }
                                                        }
                                                        //Get value of BillableStatus
                                                        if (ORJournalLine16603.JournalDebitLine.BillableStatus != null)
                                                        {
                                                                ENBillableStatus BillableStatus16615 = (ENBillableStatus)ORJournalLine16603.JournalDebitLine.BillableStatus.GetValue();
                                                        }
                                                }
                                        }
                                        if (ORJournalLine16603.JournalCreditLine != null)
                                        {
                                                if (ORJournalLine16603.JournalCreditLine != null)
                                                {
                                                        //Get value of TxnLineID
                                                        if (ORJournalLine16603.JournalCreditLine.TxnLineID != null)
                                                        {
                                                                string TxnLineID16616 = (string)ORJournalLine16603.JournalCreditLine.TxnLineID.GetValue();
                                                        }
                                                        if (ORJournalLine16603.JournalCreditLine.AccountRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORJournalLine16603.JournalCreditLine.AccountRef.ListID != null)
                                                                {
                                                                        string ListID16617 = (string)ORJournalLine16603.JournalCreditLine.AccountRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORJournalLine16603.JournalCreditLine.AccountRef.FullName != null)
                                                                {
                                                                        string FullName16618 = (string)ORJournalLine16603.JournalCreditLine.AccountRef.FullName.GetValue();
                                                                }
                                                        }
                                                        //Get value of Amount
                                                        if (ORJournalLine16603.JournalCreditLine.Amount != null)
                                                        {
                                                                double Amount16619 = (double)ORJournalLine16603.JournalCreditLine.Amount.GetValue();
                                                        }
                                                        //Get value of Memo
                                                        if (ORJournalLine16603.JournalCreditLine.Memo != null)
                                                        {
                                                                string Memo16620 = (string)ORJournalLine16603.JournalCreditLine.Memo.GetValue();
                                                        }
                                                        if (ORJournalLine16603.JournalCreditLine.EntityRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORJournalLine16603.JournalCreditLine.EntityRef.ListID != null)
                                                                {
                                                                        string ListID16621 = (string)ORJournalLine16603.JournalCreditLine.EntityRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORJournalLine16603.JournalCreditLine.EntityRef.FullName != null)
                                                                {
                                                                        string FullName16622 = (string)ORJournalLine16603.JournalCreditLine.EntityRef.FullName.GetValue();
                                                                }
                                                        }
                                                        if (ORJournalLine16603.JournalCreditLine.ClassRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORJournalLine16603.JournalCreditLine.ClassRef.ListID != null)
                                                                {
                                                                        string ListID16623 = (string)ORJournalLine16603.JournalCreditLine.ClassRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORJournalLine16603.JournalCreditLine.ClassRef.FullName != null)
                                                                {
                                                                        string FullName16624 = (string)ORJournalLine16603.JournalCreditLine.ClassRef.FullName.GetValue();
                                                                }
                                                        }
                                                        if (ORJournalLine16603.JournalCreditLine.ItemSalesTaxRef != null)
                                                        {
                                                                //Get value of ListID
                                                                if (ORJournalLine16603.JournalCreditLine.ItemSalesTaxRef.ListID != null)
                                                                {
                                                                        string ListID16625 = (string)ORJournalLine16603.JournalCreditLine.ItemSalesTaxRef.ListID.GetValue();
                                                                }
                                                                //Get value of FullName
                                                                if (ORJournalLine16603.JournalCreditLine.ItemSalesTaxRef.FullName != null)
                                                                {
                                                                        string FullName16626 = (string)ORJournalLine16603.JournalCreditLine.ItemSalesTaxRef.FullName.GetValue();
                                                                }
                                                        }
                                                        //Get value of BillableStatus
                                                        if (ORJournalLine16603.JournalCreditLine.BillableStatus != null)
                                                        {
                                                                ENBillableStatus BillableStatus16627 = (ENBillableStatus)ORJournalLine16603.JournalCreditLine.BillableStatus.GetValue();
                                                        }
                                                }
                                        }
                                }
                        }
                        if (JournalEntryRet.DataExtRetList != null)
                        {
                                for (int i16628 = 0; i16628 < JournalEntryRet.DataExtRetList.Count; i16628++)
                                {
                                        IDataExtRet DataExtRet = JournalEntryRet.DataExtRetList.GetAt(i16628);
                                        //Get value of OwnerID
                                        if (DataExtRet.OwnerID != null)
                                        {
                                                string OwnerID16629 = (string)DataExtRet.OwnerID.GetValue();
                                        }
                                        //Get value of DataExtName
                                        string DataExtName16630 = (string)DataExtRet.DataExtName.GetValue();
                                        //Get value of DataExtType
                                        ENDataExtType DataExtType16631 = (ENDataExtType)DataExtRet.DataExtType.GetValue();
                                        //Get value of DataExtValue
                                        string DataExtValue16632 = (string)DataExtRet.DataExtValue.GetValue();
                                }
                        }
                }




        }
}