InvoiceQuery
Request
Response
XMLOps
VB.NET
C#
| Tag | Type | Max length | Implementation | Required |
|---|---|---|---|---|
IInvoiceQuery |
||||
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  |
||
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 |
||
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 |
||
ORInvoiceQuery |
IORInvoiceQuery | |||
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 | ||
InvoiceFilter
The IInvoiceFilter group object allows you to search for invoices based on when they were created or last modified, which entities or accounts they refer to, their reference numbers, and their paid status.
|
IInvoiceFilter | |||
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 | ||
PaidStatus
Allows you to filter for transactions according to whether or not they are paid.
|
IQBENPaidStatusType | |||
IncludeLineItems
This filter allows you to omit line items from a query response to get a smaller result. The default value is false, so line items are omitted by default. Set IncludeLineItems to true to include line items in the response if you don’t mind getting a larger result.
|
IQBBoolType | |||
IncludeLinkedTxns
If you set IncludeLinkedTxns to true, then the returned object will include a list of all the transactions linked to the queried object. (This list is similar to the History view of a transaction in the user interface, but not identical, as the SDK list contains only linked transactions, not items.) Each linked transaction will be represented by a LinkedTxn aggregate. If no linked transactions exist, no LinkedTxn aggregates will be returned.
|
IQBBoolType | 1.1 | ||
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 |
||||
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 |
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 |
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 |
Y | |
Detail |
IInvoiceRetList | |||
(List
of IInvoiceRet 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 | |||
CustomerRef
The customer list includes information about the QuickBooks user’s customers and the individual jobs that are being performed for them. A CustomerRef aggregate refers to one of the customers (or customer jobs) on the list. In a request, if a CustomerRef aggregate includes both FullName and ListID, FullName will be ignored. Special cases to note:In SalesReceipt and ReceivePayment requests, CustomerRef refers to the customer or customer job to which the payment is credited.In a TimeTracking request, CustomerRef refers to the customer or customer job to which this time could be billed. If IsBillable is set to true, CustomerRef is required in TimeTrackingAdd. In an ExpenseLineAdd request, if AccountRef refers to an A/P account, CustomerRef must refer to a vendor (not to a customer). If AccountRef refers to any other type of account, the CustomerRef must refer to a customer.
|
IQBBaseRef | Y | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 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 | ||
ARAccountRef
Refers to an accounts receivable account in the QuickBooks file. (The AccountType of this account will be AccountsReceivable.) If an ARAccountRef aggregate includes both FullName and ListID, FullName will be ignored. If this field is in a transaction that links to other transactions, make sure this ARAccountRef matches the ARAccountRef used in the other transactions. For example, in an ARRefundCreditCard transaction, the ARAccountRef of the credit card refund transaction must match the ARAccountRef used in each of the linked credit transactions.
|
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 | ||
TemplateRef
QuickBooks templates specify how to print certain transactions. A template query returns the names of all templates that have been defined in QuickBooks. A TemplateRef element refers to one of these templates.
|
IQBBaseRef | 3.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 | 3.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | 3.0 | |
TxnDate
The date of the invoice. If you leave TxnDate out of an InvoiceAdd message, QuickBooks might prefill it with the date of the invoice that was most recently saved.
|
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 | ||
BillAddress
Whatever address you specify in this aggregate must not result in an address greater than 5 lines, otherwise you’ll get a runtime error, because QuickBooks doesn’t support addresses more than 5 lines. There are two ways to specify an address within this aggregate: Using Addr1 through Addr3 along with the other possible aggregate elements, such as City, State, Postalcode.Using Addr1, Addr2, Addr3, Addr4, and Addr5 to fully specify the address. If you use this so called “address block” approach, you cannot use any other address elements, such as City, State, etc. (Note: this approach is not valid for EmployeeAdd/Mod/Query) If you use the address block approach above, the lines Addr1…Addr5 are each printed as a separate line on the transaction, and the values are returned in the Ret object under the aggregate ShipAddressBlock or BillAddressBlock.
|
IAddress | |||
Addr1
The first line of an address.
|
IQBStringType | 41 chars | ||
Addr2
The second line of an address (if a second line is needed).
|
IQBStringType | 41 chars | ||
Addr3
The third line of an address (if a third line is needed).
|
IQBStringType | 41 chars | ||
Addr4
The fourth line of an address (if a fourth line is needed).
|
IQBStringType | 41 chars | 2.0 | |
Addr5
The fifth line of an address (if a fifth line is needed).
|
IQBStringType | 41 chars | 6.0 | |
City
The city name in an address.
|
IQBStringType | 31 chars | ||
State
The state name in an address.
|
IQBStringType | 21 chars | ||
PostalCode
The postal code in an address.
|
IQBStringType | 13 chars | ||
Country
The country name in an address, or, in returned Host information (HostRet or HostInfo), the country for which this edition of QuickBooks was designed. (Possible values are US, CA, UK, and AU.)
|
IQBStringType | 31 chars | ||
Note
In a BillAddress or ShipAddress aggregate, the Note field value is written at the bottom of the address in the form in which it appears, such as the invoice form.
|
IQBStringType | 41 chars | 6.0 | |
BillAddressBlock
The address expressed as an address block of Addr1 through Addr5, depending on the number of lines in the original request that created the address.
|
IAddressBlock | 6.0 | ||
Addr1
The first line of an address.
|
IQBStringType | 41 chars | ||
Addr2
The second line of an address (if a second line is needed).
|
IQBStringType | 41 chars | ||
Addr3
The third line of an address (if a third line is needed).
|
IQBStringType | 41 chars | ||
Addr4
The fourth line of an address (if a fourth line is needed).
|
IQBStringType | 41 chars | ||
Addr5
The fifth line of an address (if a fifth line is needed).
|
IQBStringType | 41 chars | ||
ShipAddress
Whatever address you specify in this aggregate must not result in an address greater than 5 lines, otherwise you’ll get a runtime error, because QuickBooks doesn’t support addresses more than 5 lines. There are two ways to specify an address within this aggregate: Using Addr1 through Addr3 along with the other possible aggregate elements, such as City, State, Postalcode.Using Addr1, Addr2, Addr3, Addr4, and Addr5 to fully specify the address. If you use this so called “address block” approach, you cannot use any other address elements, such as City, State, etc. (Note: this approach is not valid for EmployeeAdd/Mod/Query) If you use the address block approach above, the lines Addr1…Addr5 are each printed as a separate line on the transaction, and the values are returned in the Ret object under the aggregate ShipAddressBlock or BillAddressBlock.
|
IAddress | |||
Addr1
The first line of an address.
|
IQBStringType | 41 chars | ||
Addr2
The second line of an address (if a second line is needed).
|
IQBStringType | 41 chars | ||
Addr3
The third line of an address (if a third line is needed).
|
IQBStringType | 41 chars | ||
Addr4
The fourth line of an address (if a fourth line is needed).
|
IQBStringType | 41 chars | 2.0 | |
Addr5
The fifth line of an address (if a fifth line is needed).
|
IQBStringType | 41 chars | 6.0 | |
City
The city name in an address.
|
IQBStringType | 31 chars | ||
State
The state name in an address.
|
IQBStringType | 21 chars | ||
PostalCode
The postal code in an address.
|
IQBStringType | 13 chars | ||
Country
The country name in an address, or, in returned Host information (HostRet or HostInfo), the country for which this edition of QuickBooks was designed. (Possible values are US, CA, UK, and AU.)
|
IQBStringType | 31 chars | ||
Note
In a BillAddress or ShipAddress aggregate, the Note field value is written at the bottom of the address in the form in which it appears, such as the invoice form.
|
IQBStringType | 41 chars | 6.0 | |
ShipAddressBlock
The address expressed as an address block of Addr1 through Addr5, depending on the number of lines in the original request that created the address.
|
IAddressBlock | 6.0 | ||
Addr1
The first line of an address.
|
IQBStringType | 41 chars | ||
Addr2
The second line of an address (if a second line is needed).
|
IQBStringType | 41 chars | ||
Addr3
The third line of an address (if a third line is needed).
|
IQBStringType | 41 chars | ||
Addr4
The fourth line of an address (if a fourth line is needed).
|
IQBStringType | 41 chars | ||
Addr5
The fifth line of an address (if a fifth line is needed).
|
IQBStringType | 41 chars | ||
IsPending
If IsPending is set to true, the invoice has not been completed. Pending sales might include unpaid orders, estimates, tracked hours that have not yet been billed, or sales of back-ordered items.
|
IQBBoolType | |||
IsFinanceCharge
If IsFinanceCharge is true, a finance-charge item has been added to the invoice.
|
IQBBoolType | |||
PONumber
Purchase order number.
|
IQBStringType | 25 chars | ||
TermsRef
Refers to the payment terms associated with this entity. (This will be an item on the DateDrivenTerms or StandardTerms list.) If a TermsRef aggregate includes both FullName and ListID, FullName will be ignored.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | ||
DueDate
If DueDate is not included in an InvoiceAdd request, QuickBooks might determine the due date according to the terms set for this customer.
|
IQBDateType | |||
SalesRepRef
A sales representative must be on the Employee, Vendor, or Other Names list within QuickBooks. Sales representative’s names and initials appear on the Rep drop-down list on QuickBooks sales forms. A SalesRepRef refers to a person on the SalesRep list. In a request, if a SalesRepRef aggregate includes both FullName and ListID, FullName will be ignored.
|
IQBBaseRef | |||
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 | 5 chars | ||
FOB
QuickBooks uses the term FOB, “freight on board,” to indicate the place from which the product is shipped. The FOB has no accounting implications.
|
IQBStringType | 13 chars | ||
ShipDate
The date when the product was, or will be, shipped.
|
IQBDateType | |||
ShipMethodRef
A shipping method, for example, standard mail or overnight delivery. A ShipMethodRef aggregate refers to an item on the ShipMethod list. In a request, if a ShipMethodRef aggregate includes both FullName and ListID, FullName will be ignored.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 15 chars | ||
Subtotal
The total of all the invoice lines, before taxes and AppliedAmount are applied. (By contrast, a subtotal item (an ItemSubtotal object) gives only the total of the amounts in the lines that appear above it.)
|
IQBAmountType | |||
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 | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | ||
SalesTaxPercentage
The percentage charged for sales tax.
|
IQBPercentType | |||
SalesTaxTotal
The total amount of sales tax charged.
|
IQBAmountType | |||
AppliedAmount
Amount of credit that is applied to the customer’s invoice, or amount that the customer has paid on this invoice.
|
IQBAmountType | |||
BalanceRemaining
The outstanding balance on this invoice. BalanceRemaining = (Subtotal + SalesTaxTotal) – AppliedAmount.
|
IQBAmountType | |||
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 | ||
BalanceRemainingInHomeCurrency
Balance remaining in units of the home currency.
|
IQBAmountType | 8.0 | ||
Memo
Message that appears in reports, but not on the invoice.
|
IQBStringType | 4095 chars | ||
IsPaid
If IsPaid is true, this transaction has been paid.
|
IQBBoolType | 2.0 | ||
CustomerMsgRef
A standard message such as “Thank you for your business,” or “Please sign and return this estimate to indicate your approval.” A customer message can be included at the bottom of a form. A CustomerMsgRef aggregate refers to one of the messages on the CustomerMsg list. In a request, if a CustomerMsgRef aggregate includes both FullName and ListID, FullName will be ignored.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 101 chars | ||
IsToBePrinted
If IsToBePrinted is set to true, this transaction is on a list of forms to be printed later. The user can then choose to print all these forms at once. Notice that setting this field to true does not actually perform the printing. Only the QuickBooks user can do that from within QuickBooks. This cannot be done from the SDK. Setting this field to false does not prevent the QuickBooks user from printing the transaction later. It simply results in the transaction NOT being placed in the list of transactions to be printed.
|
IQBBoolType | |||
IsToBeEmailed
If this is set to true, at runtime the customer referenced in this transaction will be checked for a valid email address. If there is no valid email address, the request will fail. If there is a valid email address currently in QuickBooks for the customer, and the request succeeds, the transaction will be added to QuickBook’s list of forms to be emailed, possibly in a batch. Notice that setting this field to true does not actually perform the emailing. Only the QuickBooks user can do that from within QuickBooks. This cannot be done from the SDK. Setting this field to false does not prevent the QuickBooks user from emailing the transaction later. It simply results in the transaction NOT being placed in the list of transactions to be emailed.
|
IQBBoolType | 6.0 | ||
IsTaxIncluded
For future use with international versions of QuickBooks.
|
IQBBoolType | 6.0   |
||
CustomerSalesTaxCodeRef
Refers to the sales-tax code for sales related to this customer. (That is, it refers to a member of the SalesTaxCode list.) The sales-tax code indicates whether an item is taxable or non-taxable, and why. In a request, if a CustomerSalesTaxCodeRef aggregate includes both FullName and ListID, FullName will be ignored.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 3 chars | ||
SuggestedDiscountAmount
The suggested discount for this invoice.
|
IQBAmountType | |||
SuggestedDiscountDate
The date when SuggestedDiscountAmount would apply.
|
IQBDateType | |||
Other
Other, Other1, and Other2 are standard QuickBooks custom fields available to transactions. The Other field is a transaction-level field, like the FOB field, PO Number field, and so forth. This field appears only once for the transaction: you can write to it and modify it. The Other1 and Other2 fields exist at the line item level; each line item has them, and you can write or modify the value in each line. These custom fields are available for immediate use: you don’t need to enable these in the transaction template to be able to access them via SDK. (However, those Other, Other1, Other2 fields and their values are viewable and printable in QuickBooks only if the transaction template has these enabled!) Note: you cannot use DataExtDef to define Other, Other1, Other2 for the transaction. There is no need to in any case. Those are automatically available. Notice that the Other, Other1, and Other2 names are the real SDK names for those custom fields: that is, their DataExtName value will always be Other, Other1, or Other2. Even if the user has re-labelled those custom fields to something else, such as “Barracks Number”, or “Max Headroom”, or even “Pleni Potentiary”. This re-labelling has no effect on the SDK. You’ll always write to them or modify them as Other, Other1, or Other2.
|
IQBStringType | 29 chars | 6.0 | |
ExternalGUID
Allows for the attachment of a user defined GUID value.
|
IQBGUIDType | 9.0 | ||
LinkedTxnList
If the IncludeLinkedTxns flag is set to true in a query, or if you create an item receipt that links to other transactionsthen the returned object will include a list of linked transactions, if any exist. If no linked transactions exist, the ILinkedTxnList object will be empty. The list of linked transactions is similar to the History view of a transaction in the user interface, but not identical, as the SDK list contains only linked transactions, not items.
|
ILinkedTxnList | 1.1 | ||
(List
of ILinkedTxn Objects)
|
||||
TxnID
QuickBooks generates a unique TxnID for each transaction that is added to QuickBooks. A TxnID returned from a request can be used to refer to the transaction in subsequent requests. Notice that you cannot supply the TxnID of a TimeTracking transaction to TransactionQueryRq requests. If you do, you get an error stating that no such record could be found, even though the transaction is in QuickBooks. This behavior reflects the behavior in the QuicKBooks UI in the Find window.
|
IQBIDType | Y | ||
TxnType
The type of transaction.
|
IQBENTxnTypeType | Y | ||
TxnDate
The date of the transaction. In some cases, if you leave TxnDate out of an -Add message, QuickBooks will prefill TxnDate with the date of the last-saved transaction of the same type.
|
IQBDateType | Y | ||
RefNumber
A string of characters that refers to this transaction and that can be arbitrarily changed by the QuickBooks user. In a BillPaymentCheckAdd request, if you want to set the check number, use RefNumber.Note (especially relevant to CheckAdd requests): When RefNumber is left blank in an SDK transaction add request (that is, or ), the RefNumber will be left blank in QuickBooks. This behavior is new as of QBFC3. It used to select the next sequential reference number since the last one used by QuickBooks, as though no RefNumber had been provided. This is especially relevant to CheckAdd requests because with the current behavior, you will not know the number until the check is printed.
|
IQBStringType | 20 chars | ||
LinkType
Indicates the nature of the link between the transactions:ltAMTTYPE means the two transactions are linked based on an amount value (for example an invoice linked to a payment).ltQUANTYPE means the two transactions are linked based on a quantity. This affects transactions that are linked to sales orders, estimates and purchase orders. For example, an invoice might be created from a sales order, based on the quantity of items received.
|
IQBENLinkTypeType | 3.0 | ||
Amount
A monetary amount.
|
IQBAmountType | Y | ||
ORInvoiceLineRetList |
IORInvoiceLineRetList | |||
(List
of IORInvoiceLineRet Objects)
|
||||
InvoiceLineRet
Represents one line in the invoice. Compare with InvoiceLineGroup, which represents a previously defined group of lines in the invoice.
|
IInvoiceLineRet | |||
TxnLineID
Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
|
IQBIDType | Y | ||
ItemRef
Depending on the request containing it, ItemRef can refer to an item on any Item list such as ItemDiscount, ItemInventory, and so forth, or it may accept only a subset of item types. For example, here are some requests that impose limits on what items ItemRef can refer to. For PurchaseOrder and Bill requests, ItemRef cannot refer to discount items or sales-tax itemsFor VehicleMilageAdd requests, the ItemRef must refer to a service item or an other charge item.For BillingRateAdd requests, the ItemRef must refer to a service item. You can use an ItemQuery request to get information about all the items that are set up in the QuickBooks file. “Items” are line items used for fast entry on sales and purchase forms. They include services and goods that a business buys and sells, as well as special items that perform calculations–for example, subtotal, discount, and sales-tax items. Note: In a request, if an ItemRef aggregate includes both FullName and ListID, FullName will be ignored.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | |||
Desc
A descriptive text field.
|
IQBStringType | 4095 chars | ||
Quantity
QuantityFor transactions: If an item line add on a transaction request specifies Quantity and Amount but not Rate, QuickBooks will use Quantity and Amount to calculate Rate. Likewise, if a request specifies Quantity and Rate but not Amount, QuickBooks will calculate the Amount. If a transaction add request includes a reference to an ItemDiscount item, do not include a Quantity element as well, or you will get an error. For Item requests: Quantity indicates how many of this item there are.
|
IQBQuanType | |||
UnitOfMeasure
In a transaction line item, the name of the unit of measure selected from within the item’s available units. If the company file is enabled only for single unit of measure per item, this must be the base unit!
|
IQBStringType | 31 chars | 7.0 | |
OverrideUOMSetRef
When you modify a transaction line to change the unit of measure used in that line, you use this aggregate to specify the UOM set within which you are choosing an available unit of measure. The “override” here refers to the unit within the set, not the UOM Set itself, which you cannot change or override–the UOM set that can be set or changed only in the item itself via an Item Mod request.
|
IQBBaseRef | 7.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 7.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | 7.0 | |
ORRate |
IORRate | |||
Rate
If you specify both Rate and Amount in a request, the Rate you provide will be ignored, and you will receive a warning. If you specify both Quantity and Amount in an Add or Mod request, QuickBooks will use them to calculate Rate. (Rate, Amount, and Quantity cannot be cleared.)
|
IQBPriceType | |||
RatePercent
Indicates the price of something as a percent.
|
IQBPercentType | |||
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 | ||
Amount
A monetary amount.
|
IQBAmountType | |||
InventorySiteRef
Site where inventory is located.
|
IQBBaseRef | 10.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 10.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | 10.0 | |
InventorySiteLocationRef
Location within the Inventory Site.
|
IQBBaseRef | 12.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 12.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | 12.0 | |
ORSerialLotNumber |
IORSerialLotNumber | 11.0 | ||
SerialNumber
The serial number of the asset.
|
IQBStringType | 4095 chars | ||
LotNumber
The lot number of the asset.
|
IQBStringType | 40 chars | ||
ExpirationDateForSerialLotNumber
The expiration date of the inventory serial/lot number. Expiration Date is supported from QB Desktop 2023 version 3 (USA & Canada) and SDK 16.0.
|
IQBStringType | 1099 chars | 16.0 |
|
ServiceDate
Indicates the date on which the QuickBooks user performs the service for the customer.
|
IQBDateType | |||
SalesTaxCodeRef
Each item on a sales form is assigned a sales-tax code that indicates whether the item is taxable or non-taxable, and why. Two general codes, which can be modified but not deleted, appear on the sales-tax code list by default:Non-taxable (Name = NON; Desc = Non-Taxable; IsTaxable = false)Taxable (Name = TAX; Desc = Taxable; IsTaxable = true) A sales-tax code can be deleted only if it is no longer associated with any customer, item, or transaction. If the “Do You Charge Sales Tax?” preference within QuickBooks is set to No, QuickBooks will assign the default non-taxable sales-tax code to all sales. A SalesTaxCodeRef aggregate refers to a sales-tax code on the list. In a request, if a SalesTaxCodeRef aggregate includes both FullName and ListID, FullName will be ignored. In a Customer message, SalesTaxCodeRef refers to the sales-tax code that will be used for items related to this customer. In an ItemInventory message, SalesTaxCodeRef refers to the type of sales tax that will be charged for this item, if it is a taxable item and if sales tax is set up within QuickBooks.
|
IQBBaseRef | |||
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 | 3 chars | ||
Other1
Other, Other1, and Other2 are standard QuickBooks custom fields available to transactions. The Other field is a transaction-level field, like the FOB field, PO Number field, and so forth. This field appears only once for the transaction: you can write to it and modify it. The Other1 and Other2 fields exist at the line item level; each line item has them, and you can write or modify the value in each line. These custom fields are available for immediate use: you don’t need to enable these in the transaction template to be able to access them via SDK. (However, those Other, Other1, Other2 fields and their values are viewable and printable in QuickBooks only if the transaction template has these enabled!) Note: you cannot use DataExtDef to define Other, Other1, Other2 for the transaction. There is no need to in any case. Those are automatically available. Notice that the Other, Other1, and Other2 names are the real SDK names for those custom fields: that is, their DataExtName value will always be Other, Other1, or Other2. Even if the user has re-labelled those custom fields to something else, such as “Barracks Number”, or “Max Headroom”, or even “Pleni Potentiary”. This re-labelling has no effect on the SDK. You’ll always write to them or modify them as Other, Other1, or Other2.
|
IQBStringType | 29 chars | 6.0 | |
Other2
Other, Other1, and Other2 are standard QuickBooks custom fields available to transactions. The Other field is a transaction-level field, like the FOB field, PO Number field, and so forth. This field appears only once for the transaction: you can write to it and modify it. The Other1 and Other2 fields exist at the line item level; each line item has them, and you can write or modify the value in each line. These custom fields are available for immediate use: you don’t need to enable these in the transaction template to be able to access them via SDK. (However, those Other, Other1, Other2 fields and their values are viewable and printable in QuickBooks only if the transaction template has these enabled!) Note: you cannot use DataExtDef to define Other, Other1, Other2 for the transaction. There is no need to in any case. Those are automatically available. Notice that the Other, Other1, and Other2 names are the real SDK names for those custom fields: that is, their DataExtName value will always be Other, Other1, or Other2. Even if the user has re-labelled those custom fields to something else, such as “Barracks Number”, or “Max Headroom”, or even “Pleni Potentiary”. This re-labelling has no effect on the SDK. You’ll always write to them or modify them as Other, Other1, or Other2.
|
IQBStringType | 29 chars | 6.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 | ||
InvoiceLineGroupRet
Represents a previously defined group of lines in the invoice. Compare with InvoiceLine, which represents just one line in the invoice.
|
IInvoiceLineGroupRet | |||
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 | 2.1 | Y | |
ItemGroupRef
ItemGroup objects represent items that are grouped together for fast entry, and an ItemGroupRef aggregate refers to one of these item groups. In a request, if an ItemGroupRef aggregate includes both FullName and ListID, FullName will be ignored. You can use an ItemGroupQuery request to get information about all the item groups that are set up in the QuickBooks file.
|
IQBBaseRef | Y | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | ||
Desc
A descriptive text field.
|
IQBStringType | 4095 chars | ||
Quantity
QuantityFor transactions: If an item line add on a transaction request specifies Quantity and Amount but not Rate, QuickBooks will use Quantity and Amount to calculate Rate. Likewise, if a request specifies Quantity and Rate but not Amount, QuickBooks will calculate the Amount. If a transaction add request includes a reference to an ItemDiscount item, do not include a Quantity element as well, or you will get an error. For Item requests: Quantity indicates how many of this item there are.
|
IQBQuanType | |||
UnitOfMeasure
In a transaction line item, the name of the unit of measure selected from within the item’s available units. If the company file is enabled only for single unit of measure per item, this must be the base unit!
|
IQBStringType | 31 chars | 7.0 | |
OverrideUOMSetRef
When you modify a transaction line to change the unit of measure used in that line, you use this aggregate to specify the UOM set within which you are choosing an available unit of measure. The “override” here refers to the unit within the set, not the UOM Set itself, which you cannot change or override–the UOM set that can be set or changed only in the item itself via an Item Mod request.
|
IQBBaseRef | 7.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 7.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | 7.0 | |
IsPrintItemsInGroup
If true, a list of this group’s individual items their amounts will appear on printed forms.
|
IQBBoolType | Y | ||
TotalAmount
Total amount of money paid or received. In a receive payment add transaction that has payment amount elements (such as AppliedToTxnAdd lines) you must supply a TotalAmount and the sum of all the PaymentAmount elements must not be greater than the TotalAmount.
|
IQBAmountType | Y | ||
InvoiceLineRetList
A list of IInvoiceLineRet objects, each representing one line in this group of invoice lines.
|
IInvoiceLineRetList | |||
(List
of IInvoiceLineRet Objects)
|
||||
TxnLineID
Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
|
IQBIDType | Y | ||
ItemRef
Depending on the request containing it, ItemRef can refer to an item on any Item list such as ItemDiscount, ItemInventory, and so forth, or it may accept only a subset of item types. For example, here are some requests that impose limits on what items ItemRef can refer to. For PurchaseOrder and Bill requests, ItemRef cannot refer to discount items or sales-tax itemsFor VehicleMilageAdd requests, the ItemRef must refer to a service item or an other charge item.For BillingRateAdd requests, the ItemRef must refer to a service item. You can use an ItemQuery request to get information about all the items that are set up in the QuickBooks file. “Items” are line items used for fast entry on sales and purchase forms. They include services and goods that a business buys and sells, as well as special items that perform calculations–for example, subtotal, discount, and sales-tax items. Note: In a request, if an ItemRef aggregate includes both FullName and ListID, FullName will be ignored.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | |||
Desc
A descriptive text field.
|
IQBStringType | 4095 chars | ||
Quantity
QuantityFor transactions: If an item line add on a transaction request specifies Quantity and Amount but not Rate, QuickBooks will use Quantity and Amount to calculate Rate. Likewise, if a request specifies Quantity and Rate but not Amount, QuickBooks will calculate the Amount. If a transaction add request includes a reference to an ItemDiscount item, do not include a Quantity element as well, or you will get an error. For Item requests: Quantity indicates how many of this item there are.
|
IQBQuanType | |||
UnitOfMeasure
In a transaction line item, the name of the unit of measure selected from within the item’s available units. If the company file is enabled only for single unit of measure per item, this must be the base unit!
|
IQBStringType | 31 chars | 7.0 | |
OverrideUOMSetRef
When you modify a transaction line to change the unit of measure used in that line, you use this aggregate to specify the UOM set within which you are choosing an available unit of measure. The “override” here refers to the unit within the set, not the UOM Set itself, which you cannot change or override–the UOM set that can be set or changed only in the item itself via an Item Mod request.
|
IQBBaseRef | 7.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 7.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | 7.0 | |
ORRate |
IORRate | |||
Rate
If you specify both Rate and Amount in a request, the Rate you provide will be ignored, and you will receive a warning. If you specify both Quantity and Amount in an Add or Mod request, QuickBooks will use them to calculate Rate. (Rate, Amount, and Quantity cannot be cleared.)
|
IQBPriceType | |||
RatePercent
Indicates the price of something as a percent.
|
IQBPercentType | |||
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 | ||
Amount
A monetary amount.
|
IQBAmountType | |||
InventorySiteRef
Site where inventory is located.
|
IQBBaseRef | 10.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 10.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | 10.0 | |
InventorySiteLocationRef
Location within the Inventory Site.
|
IQBBaseRef | 12.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 12.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | 12.0 | |
ORSerialLotNumber |
IORSerialLotNumber | 11.0 | ||
SerialNumber
The serial number of the asset.
|
IQBStringType | 4095 chars | ||
LotNumber
The lot number of the asset.
|
IQBStringType | 40 chars | ||
ExpirationDateForSerialLotNumber
The expiration date of the inventory serial/lot number. Expiration Date is supported from QB Desktop 2023 version 3 (USA & Canada) and SDK 16.0.
|
IQBStringType | 1099 chars | 16.0 |
|
ServiceDate
Indicates the date on which the QuickBooks user performs the service for the customer.
|
IQBDateType | |||
SalesTaxCodeRef
Each item on a sales form is assigned a sales-tax code that indicates whether the item is taxable or non-taxable, and why. Two general codes, which can be modified but not deleted, appear on the sales-tax code list by default:Non-taxable (Name = NON; Desc = Non-Taxable; IsTaxable = false)Taxable (Name = TAX; Desc = Taxable; IsTaxable = true) A sales-tax code can be deleted only if it is no longer associated with any customer, item, or transaction. If the “Do You Charge Sales Tax?” preference within QuickBooks is set to No, QuickBooks will assign the default non-taxable sales-tax code to all sales. A SalesTaxCodeRef aggregate refers to a sales-tax code on the list. In a request, if a SalesTaxCodeRef aggregate includes both FullName and ListID, FullName will be ignored. In a Customer message, SalesTaxCodeRef refers to the sales-tax code that will be used for items related to this customer. In an ItemInventory message, SalesTaxCodeRef refers to the type of sales tax that will be charged for this item, if it is a taxable item and if sales tax is set up within QuickBooks.
|
IQBBaseRef | |||
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 | 3 chars | ||
Other1
Other, Other1, and Other2 are standard QuickBooks custom fields available to transactions. The Other field is a transaction-level field, like the FOB field, PO Number field, and so forth. This field appears only once for the transaction: you can write to it and modify it. The Other1 and Other2 fields exist at the line item level; each line item has them, and you can write or modify the value in each line. These custom fields are available for immediate use: you don’t need to enable these in the transaction template to be able to access them via SDK. (However, those Other, Other1, Other2 fields and their values are viewable and printable in QuickBooks only if the transaction template has these enabled!) Note: you cannot use DataExtDef to define Other, Other1, Other2 for the transaction. There is no need to in any case. Those are automatically available. Notice that the Other, Other1, and Other2 names are the real SDK names for those custom fields: that is, their DataExtName value will always be Other, Other1, or Other2. Even if the user has re-labelled those custom fields to something else, such as “Barracks Number”, or “Max Headroom”, or even “Pleni Potentiary”. This re-labelling has no effect on the SDK. You’ll always write to them or modify them as Other, Other1, or Other2.
|
IQBStringType | 29 chars | 6.0 | |
Other2
Other, Other1, and Other2 are standard QuickBooks custom fields available to transactions. The Other field is a transaction-level field, like the FOB field, PO Number field, and so forth. This field appears only once for the transaction: you can write to it and modify it. The Other1 and Other2 fields exist at the line item level; each line item has them, and you can write or modify the value in each line. These custom fields are available for immediate use: you don’t need to enable these in the transaction template to be able to access them via SDK. (However, those Other, Other1, Other2 fields and their values are viewable and printable in QuickBooks only if the transaction template has these enabled!) Note: you cannot use DataExtDef to define Other, Other1, Other2 for the transaction. There is no need to in any case. Those are automatically available. Notice that the Other, Other1, and Other2 names are the real SDK names for those custom fields: that is, their DataExtName value will always be Other, Other1, or Other2. Even if the user has re-labelled those custom fields to something else, such as “Barracks Number”, or “Max Headroom”, or even “Pleni Potentiary”. This re-labelling has no effect on the SDK. You’ll always write to them or modify them as Other, Other1, or Other2.
|
IQBStringType | 29 chars | 6.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 | ||
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 | ||
DataExtRetList
A list of IDataExtRet objects, each of which represents a field that has been added to QuickBooks as a data extension.
|
IDataExtRetList | 2.0 | ||
(List
of IDataExtRet Objects)
|
||||
OwnerID
OwnerID refers to the owner of a data extension, and must be 0 or a valid GUID. (Custom fields, which are visible in the QuickBooks UI, always have an OwnerID of 0. ) Usually you would keep your application’s GUID confidential to prevent other applications from accessing your data extensions. But if you want to share data extensions with another application, the applications need to use the same GUID. In this case, each application could use two GUIDs, one for shared data extensions and one for confidential data extensions. (An application can have any number of GUIDs.) When you share a data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
|
IQBGUIDType | |||
DataExtName
The name of the data extension. If this is a custom field, DataExtName will be visible as a label in the QuickBooks user interface. Also because OwnerID and DataExtName together make the data extension unique, and because custom fields all have the same OwnerID of zero, the DataExtName must be a unique value among existing custom fields. In contrast, the DataExtName for private data extensions must be unique only for the specified OwnerID GUID.
|
IQBStringType | 31 chars | Y | |
DataExtType
The field’s data type, which corresponds to a qbXML data type. In an IDataExtDefAdd request object, if this is a custom field, DataExtType must be detSTR255TYPE.
|
IQBENDataExtTypeType | Y | ||
DataExtValue
The data in this field. The maximum length of DataExtValue will depend on the DataExtType of this data extension. For example, if DataExtType is STR255TYPE, the maximum length of DataExtValue is 255 characters. If DataExtType is STR1024TYPE, the maximum size of DataExtValue is 1KB.
|
IQBStringType | Y |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 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 | <?xml version="1.0" encoding="utf-8"?> <?qbxml version="16.0"?> <QBXML> <QBXMLMsgsRq onError="stopOnError"> <InvoiceQueryRq metaData="ENUMTYPE" iterator="ENUMTYPE" iteratorID="UUIDTYPE"> <!-- BEGIN OR --> <TxnID >IDTYPE</TxnID> <!-- optional, may repeat --> <!-- OR --> <RefNumber >STRTYPE</RefNumber> <!-- optional, may repeat --> <!-- OR --> <RefNumberCaseSensitive >STRTYPE</RefNumberCaseSensitive> <!-- optional, may repeat --> <!-- OR --> <MaxReturned >INTTYPE</MaxReturned> <!-- optional --> <!-- BEGIN OR --> <ModifiedDateRangeFilter> <!-- optional --> <FromModifiedDate >DATETIMETYPE</FromModifiedDate> <!-- optional --> <ToModifiedDate >DATETIMETYPE</ToModifiedDate> <!-- optional --> </ModifiedDateRangeFilter> <!-- OR --> <TxnDateRangeFilter> <!-- optional --> <!-- BEGIN OR --> <FromTxnDate >DATETYPE</FromTxnDate> <!-- optional --> <ToTxnDate >DATETYPE</ToTxnDate> <!-- optional --> <!-- OR --> <!-- DateMacro may have one of the following values: All, Today, ThisWeek, ThisWeekToDate, ThisMonth, ThisMonthToDate, ThisCalendarQuarter, ThisCalendarQuarterToDate, ThisFiscalQuarter, ThisFiscalQuarterToDate, ThisCalendarYear, ThisCalendarYearToDate, ThisFiscalYear, ThisFiscalYearToDate, Yesterday, LastWeek, LastWeekToDate, LastMonth, LastMonthToDate, LastCalendarQuarter, LastCalendarQuarterToDate, LastFiscalQuarter, LastFiscalQuarterToDate, LastCalendarYear, LastCalendarYearToDate, LastFiscalYear, LastFiscalYearToDate, NextWeek, NextFourWeeks, NextMonth, NextCalendarQuarter, NextCalendarYear, NextFiscalQuarter, NextFiscalYear --> <DateMacro >ENUMTYPE</DateMacro> <!-- optional --> <!-- END OR --> </TxnDateRangeFilter> <!-- END OR --> <EntityFilter> <!-- optional --> <!-- BEGIN OR --> <ListID >IDTYPE</ListID> <!-- optional, may repeat --> <!-- OR --> <FullName >STRTYPE</FullName> <!-- optional, may repeat --> <!-- OR --> <ListIDWithChildren >IDTYPE</ListIDWithChildren> <!-- optional --> <!-- OR --> <FullNameWithChildren >STRTYPE</FullNameWithChildren> <!-- optional --> <!-- END OR --> </EntityFilter> <AccountFilter> <!-- optional --> <!-- BEGIN OR --> <ListID >IDTYPE</ListID> <!-- optional, may repeat --> <!-- OR --> <FullName >STRTYPE</FullName> <!-- optional, may repeat --> <!-- OR --> <ListIDWithChildren >IDTYPE</ListIDWithChildren> <!-- optional --> <!-- OR --> <FullNameWithChildren >STRTYPE</FullNameWithChildren> <!-- optional --> <!-- END OR --> </AccountFilter> <!-- BEGIN OR --> <RefNumberFilter> <!-- optional --> <!-- MatchCriterion may have one of the following values: StartsWith, Contains, EndsWith --> <MatchCriterion >ENUMTYPE</MatchCriterion> <!-- required --> <RefNumber >STRTYPE</RefNumber> <!-- required --> </RefNumberFilter> <!-- OR --> <RefNumberRangeFilter> <!-- optional --> <FromRefNumber >STRTYPE</FromRefNumber> <!-- optional --> <ToRefNumber >STRTYPE</ToRefNumber> <!-- optional --> </RefNumberRangeFilter> <!-- END OR --> <CurrencyFilter> <!-- optional --> <!-- BEGIN OR --> <ListID >IDTYPE</ListID> <!-- optional, may repeat --> <!-- OR --> <FullName >STRTYPE</FullName> <!-- optional, may repeat --> <!-- END OR --> </CurrencyFilter> <!-- PaidStatus may have one of the following values: All [DEFAULT], PaidOnly, NotPaidOnly --> <PaidStatus >ENUMTYPE</PaidStatus> <!-- optional --> <!-- END OR --> <IncludeLineItems >BOOLTYPE</IncludeLineItems> <!-- optional --> <IncludeLinkedTxns >BOOLTYPE</IncludeLinkedTxns> <!-- optional --> <IncludeRetElement >STRTYPE</IncludeRetElement> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional, may repeat --> </InvoiceQueryRq> <InvoiceQueryRs statusCode="INTTYPE" statusSeverity="STRTYPE" statusMessage="STRTYPE" retCount="INTTYPE" iteratorRemainingCount="INTTYPE" iteratorID="UUIDTYPE"> <InvoiceRet> <!-- optional, may repeat --> <TxnID >IDTYPE</TxnID> <!-- required --> <TimeCreated >DATETIMETYPE</TimeCreated> <!-- required --> <TimeModified >DATETIMETYPE</TimeModified> <!-- required --> <EditSequence >STRTYPE</EditSequence> <!-- required --> <TxnNumber >INTTYPE</TxnNumber> <!-- optional --> <CustomerRef> <!-- required --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </CustomerRef> <ClassRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ClassRef> <ARAccountRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ARAccountRef> <TemplateRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </TemplateRef> <TxnDate >DATETYPE</TxnDate> <!-- required --> <RefNumber >STRTYPE</RefNumber> <!-- optional --> <BillAddress> <!-- optional --> <Addr1 >STRTYPE</Addr1> <!-- optional --> <Addr2 >STRTYPE</Addr2> <!-- optional --> <Addr3 >STRTYPE</Addr3> <!-- optional --> <Addr4 >STRTYPE</Addr4> <!-- optional --> <Addr5 >STRTYPE</Addr5> <!-- optional --> <City >STRTYPE</City> <!-- optional --> <State >STRTYPE</State> <!-- optional --> <PostalCode >STRTYPE</PostalCode> <!-- optional --> <Country >STRTYPE</Country> <!-- optional --> <Note >STRTYPE</Note> <!-- optional --> </BillAddress> <BillAddressBlock> <!-- optional --> <Addr1 >STRTYPE</Addr1> <!-- optional --> <Addr2 >STRTYPE</Addr2> <!-- optional --> <Addr3 >STRTYPE</Addr3> <!-- optional --> <Addr4 >STRTYPE</Addr4> <!-- optional --> <Addr5 >STRTYPE</Addr5> <!-- optional --> </BillAddressBlock> <ShipAddress> <!-- optional --> <Addr1 >STRTYPE</Addr1> <!-- optional --> <Addr2 >STRTYPE</Addr2> <!-- optional --> <Addr3 >STRTYPE</Addr3> <!-- optional --> <Addr4 >STRTYPE</Addr4> <!-- optional --> <Addr5 >STRTYPE</Addr5> <!-- optional --> <City >STRTYPE</City> <!-- optional --> <State >STRTYPE</State> <!-- optional --> <PostalCode >STRTYPE</PostalCode> <!-- optional --> <Country >STRTYPE</Country> <!-- optional --> <Note >STRTYPE</Note> <!-- optional --> </ShipAddress> <ShipAddressBlock> <!-- optional --> <Addr1 >STRTYPE</Addr1> <!-- optional --> <Addr2 >STRTYPE</Addr2> <!-- optional --> <Addr3 >STRTYPE</Addr3> <!-- optional --> <Addr4 >STRTYPE</Addr4> <!-- optional --> <Addr5 >STRTYPE</Addr5> <!-- optional --> </ShipAddressBlock> <IsPending >BOOLTYPE</IsPending> <!-- optional --> <IsFinanceCharge >BOOLTYPE</IsFinanceCharge> <!-- optional --> <PONumber >STRTYPE</PONumber> <!-- optional --> <TermsRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </TermsRef> <DueDate >DATETYPE</DueDate> <!-- optional --> <SalesRepRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </SalesRepRef> <FOB >STRTYPE</FOB> <!-- optional --> <ShipDate >DATETYPE</ShipDate> <!-- optional --> <ShipMethodRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ShipMethodRef> <Subtotal >AMTTYPE</Subtotal> <!-- optional --> <ItemSalesTaxRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ItemSalesTaxRef> <SalesTaxPercentage >PERCENTTYPE</SalesTaxPercentage> <!-- optional --> <SalesTaxTotal >AMTTYPE</SalesTaxTotal> <!-- optional --> <AppliedAmount >AMTTYPE</AppliedAmount> <!-- optional --> <BalanceRemaining >AMTTYPE</BalanceRemaining> <!-- optional --> <CurrencyRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </CurrencyRef> <ExchangeRate >FLOATTYPE</ExchangeRate> <!-- optional --> <BalanceRemainingInHomeCurrency >AMTTYPE</BalanceRemainingInHomeCurrency> <!-- optional --> <Memo >STRTYPE</Memo> <!-- optional --> <IsPaid >BOOLTYPE</IsPaid> <!-- optional --> <CustomerMsgRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </CustomerMsgRef> <IsToBePrinted >BOOLTYPE</IsToBePrinted> <!-- optional --> <IsToBeEmailed >BOOLTYPE</IsToBeEmailed> <!-- optional --> <IsTaxIncluded >BOOLTYPE</IsTaxIncluded> <!-- optional --> <CustomerSalesTaxCodeRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </CustomerSalesTaxCodeRef> <SuggestedDiscountAmount >AMTTYPE</SuggestedDiscountAmount> <!-- optional --> <SuggestedDiscountDate >DATETYPE</SuggestedDiscountDate> <!-- optional --> <Other >STRTYPE</Other> <!-- optional --> <ExternalGUID >GUIDTYPE</ExternalGUID> <!-- optional --> <LinkedTxn> <!-- optional, may repeat --> <TxnID >IDTYPE</TxnID> <!-- required --> <!-- TxnType may have one of the following values: ARRefundCreditCard, Bill, BillPaymentCheck, BillPaymentCreditCard, BuildAssembly, Charge, Check, CreditCardCharge, CreditCardCredit, CreditMemo, Deposit, Estimate, InventoryAdjustment, Invoice, ItemReceipt, JournalEntry, LiabilityAdjustment, Paycheck, PayrollLiabilityCheck, PurchaseOrder, ReceivePayment, SalesOrder, SalesReceipt, SalesTaxPaymentCheck, Transfer, VendorCredit, YTDAdjustment --> <TxnType >ENUMTYPE</TxnType> <!-- required --> <TxnDate >DATETYPE</TxnDate> <!-- required --> <RefNumber >STRTYPE</RefNumber> <!-- optional --> <!-- LinkType may have one of the following values: AMTTYPE, QUANTYPE --> <LinkType >ENUMTYPE</LinkType> <!-- optional --> <Amount >AMTTYPE</Amount> <!-- required --> </LinkedTxn> <!-- BEGIN OR --> <InvoiceLineRet> <!-- optional --> <TxnLineID >IDTYPE</TxnLineID> <!-- required --> <ItemRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ItemRef> <Desc >STRTYPE</Desc> <!-- optional --> <Quantity >QUANTYPE</Quantity> <!-- optional --> <UnitOfMeasure >STRTYPE</UnitOfMeasure> <!-- optional --> <OverrideUOMSetRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </OverrideUOMSetRef> <!-- BEGIN OR --> <Rate >PRICETYPE</Rate> <!-- optional --> <!-- OR --> <RatePercent >PERCENTTYPE</RatePercent> <!-- optional --> <!-- END OR --> <ClassRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ClassRef> <Amount >AMTTYPE</Amount> <!-- optional --> <InventorySiteRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </InventorySiteRef> <InventorySiteLocationRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </InventorySiteLocationRef> <!-- BEGIN OR --> <SerialNumber >STRTYPE</SerialNumber> <!-- optional --> <!-- OR --> <LotNumber >STRTYPE</LotNumber> <!-- optional --> <!-- END OR --> <ExpirationDateForSerialLotNumber>STRTYPE</ExpirationDateForSerialLotNumber> <!-- optional --> <ServiceDate >DATETYPE</ServiceDate> <!-- optional --> <SalesTaxCodeRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </SalesTaxCodeRef> <Other1 >STRTYPE</Other1> <!-- optional --> <Other2 >STRTYPE</Other2> <!-- optional --> <DataExtRet> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional --> <DataExtName >STRTYPE</DataExtName> <!-- required --> <!-- DataExtType may have one of the following values: AMTTYPE, DATETIMETYPE, INTTYPE, PERCENTTYPE, PRICETYPE, QUANTYPE, STR1024TYPE, STR255TYPE --> <DataExtType >ENUMTYPE</DataExtType> <!-- required --> <DataExtValue >STRTYPE</DataExtValue> <!-- required --> </DataExtRet> </InvoiceLineRet> <!-- OR --> <InvoiceLineGroupRet> <!-- optional --> <TxnLineID >IDTYPE</TxnLineID> <!-- required --> <ItemGroupRef> <!-- required --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ItemGroupRef> <Desc >STRTYPE</Desc> <!-- optional --> <Quantity >QUANTYPE</Quantity> <!-- optional --> <UnitOfMeasure >STRTYPE</UnitOfMeasure> <!-- optional --> <OverrideUOMSetRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </OverrideUOMSetRef> <IsPrintItemsInGroup >BOOLTYPE</IsPrintItemsInGroup> <!-- required --> <TotalAmount >AMTTYPE</TotalAmount> <!-- required --> <InvoiceLineRet> <!-- optional, may repeat --> <TxnLineID >IDTYPE</TxnLineID> <!-- required --> <ItemRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ItemRef> <Desc >STRTYPE</Desc> <!-- optional --> <Quantity >QUANTYPE</Quantity> <!-- optional --> <UnitOfMeasure >STRTYPE</UnitOfMeasure> <!-- optional --> <OverrideUOMSetRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </OverrideUOMSetRef> <!-- BEGIN OR --> <Rate >PRICETYPE</Rate> <!-- optional --> <!-- OR --> <RatePercent >PERCENTTYPE</RatePercent> <!-- optional --> <!-- END OR --> <ClassRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ClassRef> <Amount >AMTTYPE</Amount> <!-- optional --> <InventorySiteRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </InventorySiteRef> <InventorySiteLocationRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </InventorySiteLocationRef> <!-- BEGIN OR --> <SerialNumber >STRTYPE</SerialNumber> <!-- optional --> <!-- OR --> <LotNumber >STRTYPE</LotNumber> <!-- optional --> <!-- END OR --> <ExpirationDateForSerialLotNumber>STRTYPE</ExpirationDateForSerialLotNumber> <!-- optional --> <ServiceDate >DATETYPE</ServiceDate> <!-- optional --> <SalesTaxCodeRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </SalesTaxCodeRef> <Other1 >STRTYPE</Other1> <!-- optional --> <Other2 >STRTYPE</Other2> <!-- optional --> <DataExtRet> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional --> <DataExtName >STRTYPE</DataExtName> <!-- required --> <!-- DataExtType may have one of the following values: AMTTYPE, DATETIMETYPE, INTTYPE, PERCENTTYPE, PRICETYPE, QUANTYPE, STR1024TYPE, STR255TYPE --> <DataExtType >ENUMTYPE</DataExtType> <!-- required --> <DataExtValue >STRTYPE</DataExtValue> <!-- required --> </DataExtRet> </InvoiceLineRet> <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> </InvoiceLineGroupRet> <!-- 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> </InvoiceRet> </InvoiceQueryRs> </QBXMLMsgsRq> </QBXML> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 | '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 DoInvoiceQuery()
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
BuildInvoiceQueryRq(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
WalkInvoiceQueryRs(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 BuildInvoiceQueryRq(requestMsgSet as IMsgSetRequest)
Dim InvoiceQueryRq as IInvoiceQuery
InvoiceQueryRq= requestMsgSet.AppendInvoiceQueryRq()
Dim ORInvoiceQueryElementType12057 as String
ORInvoiceQueryElementType12057 = "TxnIDList"
if (ORInvoiceQueryElementType12057 == "TxnIDList") then
'Set field value for TxnIDList
'May create more than one of these if needed
InvoiceQueryRq.ORInvoiceQuery.TxnIDList.Add("200000-1011023419")
End If
if (ORInvoiceQueryElementType12057 == "RefNumberList") then
'Set field value for RefNumberList
'May create more than one of these if needed
InvoiceQueryRq.ORInvoiceQuery.RefNumberList.Add("ab")
End If
if (ORInvoiceQueryElementType12057 == "RefNumberCaseSensitiveList") then
'Set field value for RefNumberCaseSensitiveList
'May create more than one of these if needed
InvoiceQueryRq.ORInvoiceQuery.RefNumberCaseSensitiveList.Add("ab")
End If
if (ORInvoiceQueryElementType12057 == "InvoiceFilter") then
'Set field value for MaxReturned
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.MaxReturned.SetValue(6)
Dim ORDateRangeFilterElementType12058 as String
ORDateRangeFilterElementType12058 = "ModifiedDateRangeFilter"
if (ORDateRangeFilterElementType12058 == "ModifiedDateRangeFilter") then
'Set field value for FromModifiedDate
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
'Set field value for ToModifiedDate
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
End If
if (ORDateRangeFilterElementType12058 == "TxnDateRangeFilter") then
Dim ORTxnDateRangeFilterElementType12059 as String
ORTxnDateRangeFilterElementType12059 = "TxnDateFilter"
if (ORTxnDateRangeFilterElementType12059 == "TxnDateFilter") then
'Set field value for FromTxnDate
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007"))
'Set field value for ToTxnDate
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007"))
End If
if (ORTxnDateRangeFilterElementType12059 == "DateMacro") then
'Set field value for DateMacro
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll)
End If
End If
Dim OREntityFilterElementType12060 as String
OREntityFilterElementType12060 = "ListIDList"
if (OREntityFilterElementType12060 == "ListIDList") then
'Set field value for ListIDList
'May create more than one of these if needed
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.EntityFilter.OREntityFilter.ListIDList.Add("200000-1011023419")
End If
if (OREntityFilterElementType12060 == "FullNameList") then
'Set field value for FullNameList
'May create more than one of these if needed
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.EntityFilter.OREntityFilter.FullNameList.Add("ab")
End If
if (OREntityFilterElementType12060 == "ListIDWithChildren") then
'Set field value for ListIDWithChildren
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.EntityFilter.OREntityFilter.ListIDWithChildren.SetValue("200000-1011023419")
End If
if (OREntityFilterElementType12060 == "FullNameWithChildren") then
'Set field value for FullNameWithChildren
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.EntityFilter.OREntityFilter.FullNameWithChildren.SetValue("ab")
End If
Dim ORAccountFilterElementType12061 as String
ORAccountFilterElementType12061 = "ListIDList"
if (ORAccountFilterElementType12061 == "ListIDList") then
'Set field value for ListIDList
'May create more than one of these if needed
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.AccountFilter.ORAccountFilter.ListIDList.Add("200000-1011023419")
End If
if (ORAccountFilterElementType12061 == "FullNameList") then
'Set field value for FullNameList
'May create more than one of these if needed
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.AccountFilter.ORAccountFilter.FullNameList.Add("ab")
End If
if (ORAccountFilterElementType12061 == "ListIDWithChildren") then
'Set field value for ListIDWithChildren
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.AccountFilter.ORAccountFilter.ListIDWithChildren.SetValue("200000-1011023419")
End If
if (ORAccountFilterElementType12061 == "FullNameWithChildren") then
'Set field value for FullNameWithChildren
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.AccountFilter.ORAccountFilter.FullNameWithChildren.SetValue("ab")
End If
Dim ORRefNumberFilterElementType12062 as String
ORRefNumberFilterElementType12062 = "RefNumberFilter"
if (ORRefNumberFilterElementType12062 == "RefNumberFilter") then
'Set field value for MatchCriterion
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORRefNumberFilter.RefNumberFilter.MatchCriterion.SetValue(ENMatchCriterion.mcStartsWith)
'Set field value for RefNumber
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORRefNumberFilter.RefNumberFilter.RefNumber.SetValue("ab")
End If
if (ORRefNumberFilterElementType12062 == "RefNumberRangeFilter") then
'Set field value for FromRefNumber
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORRefNumberFilter.RefNumberRangeFilter.FromRefNumber.SetValue("ab")
'Set field value for ToRefNumber
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORRefNumberFilter.RefNumberRangeFilter.ToRefNumber.SetValue("ab")
End If
Dim ORCurrencyFilterElementType12063 as String
ORCurrencyFilterElementType12063 = "ListIDList"
if (ORCurrencyFilterElementType12063 == "ListIDList") then
'Set field value for ListIDList
'May create more than one of these if needed
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.CurrencyFilter.ORCurrencyFilter.ListIDList.Add("200000-1011023419")
End If
if (ORCurrencyFilterElementType12063 == "FullNameList") then
'Set field value for FullNameList
'May create more than one of these if needed
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.CurrencyFilter.ORCurrencyFilter.FullNameList.Add("ab")
End If
'Set field value for PaidStatus
InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.PaidStatus.SetValue(ENPaidStatus.psAll [DEFAULT])
End If
'Set field value for IncludeLineItems
InvoiceQueryRq.IncludeLineItems.SetValue(True)
'Set field value for IncludeLinkedTxns
InvoiceQueryRq.IncludeLinkedTxns.SetValue(True)
'Set field value for IncludeRetElementList
'May create more than one of these if needed
InvoiceQueryRq.IncludeRetElementList.Add("ab")
'Set field value for OwnerIDList
'May create more than one of these if needed
InvoiceQueryRq.OwnerIDList.Add(System.Guid.NewGuid().ToString())
End Sub
Public Sub WalkInvoiceQueryRs( 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.rtInvoiceQueryRs) then
'upcast to more specific type here, this is safe because we checked with response.Type check above
Dim InvoiceRet as IInvoiceRetList
InvoiceRet = CType(response.Detail,IInvoiceRetList)
WalkInvoiceRet(InvoiceRet)
End If
End If
End If
Next j
End Sub
Public Sub WalkInvoiceRet(InvoiceRet as IInvoiceRetList)
if (InvoiceRet is nothing) then
Exit Sub
End If
'Go through all the elements of IInvoiceRetList
'Get value of TxnID
Dim TxnID12064 as String
TxnID12064 = InvoiceRet.TxnID.GetValue()
'Get value of TimeCreated
Dim TimeCreated12065 as DateTime
TimeCreated12065 = InvoiceRet.TimeCreated.GetValue()
'Get value of TimeModified
Dim TimeModified12066 as DateTime
TimeModified12066 = InvoiceRet.TimeModified.GetValue()
'Get value of EditSequence
Dim EditSequence12067 as String
EditSequence12067 = InvoiceRet.EditSequence.GetValue()
'Get value of TxnNumber
if ( not InvoiceRet.TxnNumber is nothing) then
Dim TxnNumber12068 as Integer
TxnNumber12068 = InvoiceRet.TxnNumber.GetValue()
End If
'Get value of ListID
if ( not InvoiceRet.CustomerRef.ListID is nothing) then
Dim ListID12069 as String
ListID12069 = InvoiceRet.CustomerRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceRet.CustomerRef.FullName is nothing) then
Dim FullName12070 as String
FullName12070 = InvoiceRet.CustomerRef.FullName.GetValue()
End If
if (not InvoiceRet.ClassRef. is nothing) then
'Get value of ListID
if ( not InvoiceRet.ClassRef.ListID is nothing) then
Dim ListID12071 as String
ListID12071 = InvoiceRet.ClassRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceRet.ClassRef.FullName is nothing) then
Dim FullName12072 as String
FullName12072 = InvoiceRet.ClassRef.FullName.GetValue()
End If
End If
if (not InvoiceRet.ARAccountRef. is nothing) then
'Get value of ListID
if ( not InvoiceRet.ARAccountRef.ListID is nothing) then
Dim ListID12073 as String
ListID12073 = InvoiceRet.ARAccountRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceRet.ARAccountRef.FullName is nothing) then
Dim FullName12074 as String
FullName12074 = InvoiceRet.ARAccountRef.FullName.GetValue()
End If
End If
if (not InvoiceRet.TemplateRef. is nothing) then
'Get value of ListID
if ( not InvoiceRet.TemplateRef.ListID is nothing) then
Dim ListID12075 as String
ListID12075 = InvoiceRet.TemplateRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceRet.TemplateRef.FullName is nothing) then
Dim FullName12076 as String
FullName12076 = InvoiceRet.TemplateRef.FullName.GetValue()
End If
End If
'Get value of TxnDate
Dim TxnDate12077 as DateTime
TxnDate12077 = InvoiceRet.TxnDate.GetValue()
'Get value of RefNumber
if ( not InvoiceRet.RefNumber is nothing) then
Dim RefNumber12078 as String
RefNumber12078 = InvoiceRet.RefNumber.GetValue()
End If
if (not InvoiceRet.BillAddress. is nothing) then
'Get value of Addr1
if ( not InvoiceRet.BillAddress.Addr1 is nothing) then
Dim Addr112079 as String
Addr112079 = InvoiceRet.BillAddress.Addr1.GetValue()
End If
'Get value of Addr2
if ( not InvoiceRet.BillAddress.Addr2 is nothing) then
Dim Addr212080 as String
Addr212080 = InvoiceRet.BillAddress.Addr2.GetValue()
End If
'Get value of Addr3
if ( not InvoiceRet.BillAddress.Addr3 is nothing) then
Dim Addr312081 as String
Addr312081 = InvoiceRet.BillAddress.Addr3.GetValue()
End If
'Get value of Addr4
if ( not InvoiceRet.BillAddress.Addr4 is nothing) then
Dim Addr412082 as String
Addr412082 = InvoiceRet.BillAddress.Addr4.GetValue()
End If
'Get value of Addr5
if ( not InvoiceRet.BillAddress.Addr5 is nothing) then
Dim Addr512083 as String
Addr512083 = InvoiceRet.BillAddress.Addr5.GetValue()
End If
'Get value of City
if ( not InvoiceRet.BillAddress.City is nothing) then
Dim City12084 as String
City12084 = InvoiceRet.BillAddress.City.GetValue()
End If
'Get value of State
if ( not InvoiceRet.BillAddress.State is nothing) then
Dim State12085 as String
State12085 = InvoiceRet.BillAddress.State.GetValue()
End If
'Get value of PostalCode
if ( not InvoiceRet.BillAddress.PostalCode is nothing) then
Dim PostalCode12086 as String
PostalCode12086 = InvoiceRet.BillAddress.PostalCode.GetValue()
End If
'Get value of Country
if ( not InvoiceRet.BillAddress.Country is nothing) then
Dim Country12087 as String
Country12087 = InvoiceRet.BillAddress.Country.GetValue()
End If
'Get value of Note
if ( not InvoiceRet.BillAddress.Note is nothing) then
Dim Note12088 as String
Note12088 = InvoiceRet.BillAddress.Note.GetValue()
End If
End If
if (not InvoiceRet.BillAddressBlock. is nothing) then
'Get value of Addr1
if ( not InvoiceRet.BillAddressBlock.Addr1 is nothing) then
Dim Addr112089 as String
Addr112089 = InvoiceRet.BillAddressBlock.Addr1.GetValue()
End If
'Get value of Addr2
if ( not InvoiceRet.BillAddressBlock.Addr2 is nothing) then
Dim Addr212090 as String
Addr212090 = InvoiceRet.BillAddressBlock.Addr2.GetValue()
End If
'Get value of Addr3
if ( not InvoiceRet.BillAddressBlock.Addr3 is nothing) then
Dim Addr312091 as String
Addr312091 = InvoiceRet.BillAddressBlock.Addr3.GetValue()
End If
'Get value of Addr4
if ( not InvoiceRet.BillAddressBlock.Addr4 is nothing) then
Dim Addr412092 as String
Addr412092 = InvoiceRet.BillAddressBlock.Addr4.GetValue()
End If
'Get value of Addr5
if ( not InvoiceRet.BillAddressBlock.Addr5 is nothing) then
Dim Addr512093 as String
Addr512093 = InvoiceRet.BillAddressBlock.Addr5.GetValue()
End If
End If
if (not InvoiceRet.ShipAddress. is nothing) then
'Get value of Addr1
if ( not InvoiceRet.ShipAddress.Addr1 is nothing) then
Dim Addr112094 as String
Addr112094 = InvoiceRet.ShipAddress.Addr1.GetValue()
End If
'Get value of Addr2
if ( not InvoiceRet.ShipAddress.Addr2 is nothing) then
Dim Addr212095 as String
Addr212095 = InvoiceRet.ShipAddress.Addr2.GetValue()
End If
'Get value of Addr3
if ( not InvoiceRet.ShipAddress.Addr3 is nothing) then
Dim Addr312096 as String
Addr312096 = InvoiceRet.ShipAddress.Addr3.GetValue()
End If
'Get value of Addr4
if ( not InvoiceRet.ShipAddress.Addr4 is nothing) then
Dim Addr412097 as String
Addr412097 = InvoiceRet.ShipAddress.Addr4.GetValue()
End If
'Get value of Addr5
if ( not InvoiceRet.ShipAddress.Addr5 is nothing) then
Dim Addr512098 as String
Addr512098 = InvoiceRet.ShipAddress.Addr5.GetValue()
End If
'Get value of City
if ( not InvoiceRet.ShipAddress.City is nothing) then
Dim City12099 as String
City12099 = InvoiceRet.ShipAddress.City.GetValue()
End If
'Get value of State
if ( not InvoiceRet.ShipAddress.State is nothing) then
Dim State12100 as String
State12100 = InvoiceRet.ShipAddress.State.GetValue()
End If
'Get value of PostalCode
if ( not InvoiceRet.ShipAddress.PostalCode is nothing) then
Dim PostalCode12101 as String
PostalCode12101 = InvoiceRet.ShipAddress.PostalCode.GetValue()
End If
'Get value of Country
if ( not InvoiceRet.ShipAddress.Country is nothing) then
Dim Country12102 as String
Country12102 = InvoiceRet.ShipAddress.Country.GetValue()
End If
'Get value of Note
if ( not InvoiceRet.ShipAddress.Note is nothing) then
Dim Note12103 as String
Note12103 = InvoiceRet.ShipAddress.Note.GetValue()
End If
End If
if (not InvoiceRet.ShipAddressBlock. is nothing) then
'Get value of Addr1
if ( not InvoiceRet.ShipAddressBlock.Addr1 is nothing) then
Dim Addr112104 as String
Addr112104 = InvoiceRet.ShipAddressBlock.Addr1.GetValue()
End If
'Get value of Addr2
if ( not InvoiceRet.ShipAddressBlock.Addr2 is nothing) then
Dim Addr212105 as String
Addr212105 = InvoiceRet.ShipAddressBlock.Addr2.GetValue()
End If
'Get value of Addr3
if ( not InvoiceRet.ShipAddressBlock.Addr3 is nothing) then
Dim Addr312106 as String
Addr312106 = InvoiceRet.ShipAddressBlock.Addr3.GetValue()
End If
'Get value of Addr4
if ( not InvoiceRet.ShipAddressBlock.Addr4 is nothing) then
Dim Addr412107 as String
Addr412107 = InvoiceRet.ShipAddressBlock.Addr4.GetValue()
End If
'Get value of Addr5
if ( not InvoiceRet.ShipAddressBlock.Addr5 is nothing) then
Dim Addr512108 as String
Addr512108 = InvoiceRet.ShipAddressBlock.Addr5.GetValue()
End If
End If
'Get value of IsPending
if ( not InvoiceRet.IsPending is nothing) then
Dim IsPending12109 as Boolean
IsPending12109 = InvoiceRet.IsPending.GetValue()
End If
'Get value of IsFinanceCharge
if ( not InvoiceRet.IsFinanceCharge is nothing) then
Dim IsFinanceCharge12110 as Boolean
IsFinanceCharge12110 = InvoiceRet.IsFinanceCharge.GetValue()
End If
'Get value of PONumber
if ( not InvoiceRet.PONumber is nothing) then
Dim PONumber12111 as String
PONumber12111 = InvoiceRet.PONumber.GetValue()
End If
if (not InvoiceRet.TermsRef. is nothing) then
'Get value of ListID
if ( not InvoiceRet.TermsRef.ListID is nothing) then
Dim ListID12112 as String
ListID12112 = InvoiceRet.TermsRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceRet.TermsRef.FullName is nothing) then
Dim FullName12113 as String
FullName12113 = InvoiceRet.TermsRef.FullName.GetValue()
End If
End If
'Get value of DueDate
if ( not InvoiceRet.DueDate is nothing) then
Dim DueDate12114 as DateTime
DueDate12114 = InvoiceRet.DueDate.GetValue()
End If
if (not InvoiceRet.SalesRepRef. is nothing) then
'Get value of ListID
if ( not InvoiceRet.SalesRepRef.ListID is nothing) then
Dim ListID12115 as String
ListID12115 = InvoiceRet.SalesRepRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceRet.SalesRepRef.FullName is nothing) then
Dim FullName12116 as String
FullName12116 = InvoiceRet.SalesRepRef.FullName.GetValue()
End If
End If
'Get value of FOB
if ( not InvoiceRet.FOB is nothing) then
Dim FOB12117 as String
FOB12117 = InvoiceRet.FOB.GetValue()
End If
'Get value of ShipDate
if ( not InvoiceRet.ShipDate is nothing) then
Dim ShipDate12118 as DateTime
ShipDate12118 = InvoiceRet.ShipDate.GetValue()
End If
if (not InvoiceRet.ShipMethodRef. is nothing) then
'Get value of ListID
if ( not InvoiceRet.ShipMethodRef.ListID is nothing) then
Dim ListID12119 as String
ListID12119 = InvoiceRet.ShipMethodRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceRet.ShipMethodRef.FullName is nothing) then
Dim FullName12120 as String
FullName12120 = InvoiceRet.ShipMethodRef.FullName.GetValue()
End If
End If
'Get value of Subtotal
if ( not InvoiceRet.Subtotal is nothing) then
Dim Subtotal12121 as Double
Subtotal12121 = InvoiceRet.Subtotal.GetValue()
End If
if (not InvoiceRet.ItemSalesTaxRef. is nothing) then
'Get value of ListID
if ( not InvoiceRet.ItemSalesTaxRef.ListID is nothing) then
Dim ListID12122 as String
ListID12122 = InvoiceRet.ItemSalesTaxRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceRet.ItemSalesTaxRef.FullName is nothing) then
Dim FullName12123 as String
FullName12123 = InvoiceRet.ItemSalesTaxRef.FullName.GetValue()
End If
End If
'Get value of SalesTaxPercentage
if ( not InvoiceRet.SalesTaxPercentage is nothing) then
Dim SalesTaxPercentage12124 as Double
SalesTaxPercentage12124 = InvoiceRet.SalesTaxPercentage.GetValue()
End If
'Get value of SalesTaxTotal
if ( not InvoiceRet.SalesTaxTotal is nothing) then
Dim SalesTaxTotal12125 as Double
SalesTaxTotal12125 = InvoiceRet.SalesTaxTotal.GetValue()
End If
'Get value of AppliedAmount
if ( not InvoiceRet.AppliedAmount is nothing) then
Dim AppliedAmount12126 as Double
AppliedAmount12126 = InvoiceRet.AppliedAmount.GetValue()
End If
'Get value of BalanceRemaining
if ( not InvoiceRet.BalanceRemaining is nothing) then
Dim BalanceRemaining12127 as Double
BalanceRemaining12127 = InvoiceRet.BalanceRemaining.GetValue()
End If
if (not InvoiceRet.CurrencyRef. is nothing) then
'Get value of ListID
if ( not InvoiceRet.CurrencyRef.ListID is nothing) then
Dim ListID12128 as String
ListID12128 = InvoiceRet.CurrencyRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceRet.CurrencyRef.FullName is nothing) then
Dim FullName12129 as String
FullName12129 = InvoiceRet.CurrencyRef.FullName.GetValue()
End If
End If
'Get value of ExchangeRate
if ( not InvoiceRet.ExchangeRate is nothing) then
Dim ExchangeRate12130 as IQBFloatType
ExchangeRate12130 = InvoiceRet.ExchangeRate.GetValue()
End If
'Get value of BalanceRemainingInHomeCurrency
if ( not InvoiceRet.BalanceRemainingInHomeCurrency is nothing) then
Dim BalanceRemainingInHomeCurrency12131 as Double
BalanceRemainingInHomeCurrency12131 = InvoiceRet.BalanceRemainingInHomeCurrency.GetValue()
End If
'Get value of Memo
if ( not InvoiceRet.Memo is nothing) then
Dim Memo12132 as String
Memo12132 = InvoiceRet.Memo.GetValue()
End If
'Get value of IsPaid
if ( not InvoiceRet.IsPaid is nothing) then
Dim IsPaid12133 as Boolean
IsPaid12133 = InvoiceRet.IsPaid.GetValue()
End If
if (not InvoiceRet.CustomerMsgRef. is nothing) then
'Get value of ListID
if ( not InvoiceRet.CustomerMsgRef.ListID is nothing) then
Dim ListID12134 as String
ListID12134 = InvoiceRet.CustomerMsgRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceRet.CustomerMsgRef.FullName is nothing) then
Dim FullName12135 as String
FullName12135 = InvoiceRet.CustomerMsgRef.FullName.GetValue()
End If
End If
'Get value of IsToBePrinted
if ( not InvoiceRet.IsToBePrinted is nothing) then
Dim IsToBePrinted12136 as Boolean
IsToBePrinted12136 = InvoiceRet.IsToBePrinted.GetValue()
End If
'Get value of IsToBeEmailed
if ( not InvoiceRet.IsToBeEmailed is nothing) then
Dim IsToBeEmailed12137 as Boolean
IsToBeEmailed12137 = InvoiceRet.IsToBeEmailed.GetValue()
End If
'Get value of IsTaxIncluded
if ( not InvoiceRet.IsTaxIncluded is nothing) then
Dim IsTaxIncluded12138 as Boolean
IsTaxIncluded12138 = InvoiceRet.IsTaxIncluded.GetValue()
End If
if (not InvoiceRet.CustomerSalesTaxCodeRef. is nothing) then
'Get value of ListID
if ( not InvoiceRet.CustomerSalesTaxCodeRef.ListID is nothing) then
Dim ListID12139 as String
ListID12139 = InvoiceRet.CustomerSalesTaxCodeRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceRet.CustomerSalesTaxCodeRef.FullName is nothing) then
Dim FullName12140 as String
FullName12140 = InvoiceRet.CustomerSalesTaxCodeRef.FullName.GetValue()
End If
End If
'Get value of SuggestedDiscountAmount
if ( not InvoiceRet.SuggestedDiscountAmount is nothing) then
Dim SuggestedDiscountAmount12141 as Double
SuggestedDiscountAmount12141 = InvoiceRet.SuggestedDiscountAmount.GetValue()
End If
'Get value of SuggestedDiscountDate
if ( not InvoiceRet.SuggestedDiscountDate is nothing) then
Dim SuggestedDiscountDate12142 as DateTime
SuggestedDiscountDate12142 = InvoiceRet.SuggestedDiscountDate.GetValue()
End If
'Get value of Other
if ( not InvoiceRet.Other is nothing) then
Dim Other12143 as String
Other12143 = InvoiceRet.Other.GetValue()
End If
'Get value of ExternalGUID
if ( not InvoiceRet.ExternalGUID is nothing) then
Dim ExternalGUID12144 as String
ExternalGUID12144 = InvoiceRet.ExternalGUID.GetValue()
End If
if (not InvoiceRet.LinkedTxnList is nothing)
Dim i12145 as Integer
for i12145 = 0 to InvoiceRet.LinkedTxnList.Count - 1
Dim LinkedTxn as ILinkedTxn
LinkedTxn = InvoiceRet.LinkedTxnList.GetAt(i12145)
'Get value of TxnID
Dim TxnID12146 as String
TxnID12146 = LinkedTxnTxnID.GetValue()
'Get value of TxnType
Dim TxnType12147 as ENTxnType
TxnType12147 = LinkedTxnTxnType.GetValue()
'Get value of TxnDate
Dim TxnDate12148 as DateTime
TxnDate12148 = LinkedTxnTxnDate.GetValue()
'Get value of RefNumber
if ( not LinkedTxnRefNumber is nothing) then
Dim RefNumber12149 as String
RefNumber12149 = LinkedTxnRefNumber.GetValue()
End If
'Get value of LinkType
if ( not LinkedTxnLinkType is nothing) then
Dim LinkType12150 as ENLinkType
LinkType12150 = LinkedTxnLinkType.GetValue()
End If
'Get value of Amount
Dim Amount12151 as Double
Amount12151 = LinkedTxnAmount.GetValue()
Next i12145
End If
if (not InvoiceRet.ORInvoiceLineRetList is nothing) then
Dim i12152 as Integer
for i12152 = 0 to InvoiceRet.ORInvoiceLineRetList.Count - 1
Dim ORInvoiceLineRet12153 as IORInvoiceLineRet
ORInvoiceLineRet12153 = InvoiceRet.ORInvoiceLineRetList.GetAt(i12152)
if (not ORInvoiceLineRet12153.InvoiceLineRet is nothing) then
if (not ORInvoiceLineRet12153.InvoiceLineRet. is nothing) then
'Get value of TxnLineID
Dim TxnLineID12154 as String
TxnLineID12154 = ORInvoiceLineRet12153.InvoiceLineRet.TxnLineID.GetValue()
if (not ORInvoiceLineRet12153.InvoiceLineRet.ItemRef. is nothing) then
'Get value of ListID
if ( not ORInvoiceLineRet12153.InvoiceLineRet.ItemRef.ListID is nothing) then
Dim ListID12155 as String
ListID12155 = ORInvoiceLineRet12153.InvoiceLineRet.ItemRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORInvoiceLineRet12153.InvoiceLineRet.ItemRef.FullName is nothing) then
Dim FullName12156 as String
FullName12156 = ORInvoiceLineRet12153.InvoiceLineRet.ItemRef.FullName.GetValue()
End If
End If
'Get value of Desc
if ( not ORInvoiceLineRet12153.InvoiceLineRet.Desc is nothing) then
Dim Desc12157 as String
Desc12157 = ORInvoiceLineRet12153.InvoiceLineRet.Desc.GetValue()
End If
'Get value of Quantity
if ( not ORInvoiceLineRet12153.InvoiceLineRet.Quantity is nothing) then
Dim Quantity12158 as Integer
Quantity12158 = ORInvoiceLineRet12153.InvoiceLineRet.Quantity.GetValue()
End If
'Get value of UnitOfMeasure
if ( not ORInvoiceLineRet12153.InvoiceLineRet.UnitOfMeasure is nothing) then
Dim UnitOfMeasure12159 as String
UnitOfMeasure12159 = ORInvoiceLineRet12153.InvoiceLineRet.UnitOfMeasure.GetValue()
End If
if (not ORInvoiceLineRet12153.InvoiceLineRet.OverrideUOMSetRef. is nothing) then
'Get value of ListID
if ( not ORInvoiceLineRet12153.InvoiceLineRet.OverrideUOMSetRef.ListID is nothing) then
Dim ListID12160 as String
ListID12160 = ORInvoiceLineRet12153.InvoiceLineRet.OverrideUOMSetRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORInvoiceLineRet12153.InvoiceLineRet.OverrideUOMSetRef.FullName is nothing) then
Dim FullName12161 as String
FullName12161 = ORInvoiceLineRet12153.InvoiceLineRet.OverrideUOMSetRef.FullName.GetValue()
End If
End If
if (not ORInvoiceLineRet12153.InvoiceLineRet.ORRate is nothing) then
if (not ORInvoiceLineRet12153.InvoiceLineRet.ORRate.Rate is nothing) then
'Get value of Rate
if ( not ORInvoiceLineRet12153.InvoiceLineRet.ORRate.Rate is nothing) then
Dim Rate12163 as Double
Rate12163 = ORInvoiceLineRet12153.InvoiceLineRet.ORRate.Rate.GetValue()
End If
End If
if (not ORInvoiceLineRet12153.InvoiceLineRet.ORRate.RatePercent is nothing) then
'Get value of RatePercent
if ( not ORInvoiceLineRet12153.InvoiceLineRet.ORRate.RatePercent is nothing) then
Dim RatePercent12164 as Double
RatePercent12164 = ORInvoiceLineRet12153.InvoiceLineRet.ORRate.RatePercent.GetValue()
End If
End If
End If
if (not ORInvoiceLineRet12153.InvoiceLineRet.ClassRef. is nothing) then
'Get value of ListID
if ( not ORInvoiceLineRet12153.InvoiceLineRet.ClassRef.ListID is nothing) then
Dim ListID12165 as String
ListID12165 = ORInvoiceLineRet12153.InvoiceLineRet.ClassRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORInvoiceLineRet12153.InvoiceLineRet.ClassRef.FullName is nothing) then
Dim FullName12166 as String
FullName12166 = ORInvoiceLineRet12153.InvoiceLineRet.ClassRef.FullName.GetValue()
End If
End If
'Get value of Amount
if ( not ORInvoiceLineRet12153.InvoiceLineRet.Amount is nothing) then
Dim Amount12167 as Double
Amount12167 = ORInvoiceLineRet12153.InvoiceLineRet.Amount.GetValue()
End If
if (not ORInvoiceLineRet12153.InvoiceLineRet.InventorySiteRef. is nothing) then
'Get value of ListID
if ( not ORInvoiceLineRet12153.InvoiceLineRet.InventorySiteRef.ListID is nothing) then
Dim ListID12168 as String
ListID12168 = ORInvoiceLineRet12153.InvoiceLineRet.InventorySiteRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORInvoiceLineRet12153.InvoiceLineRet.InventorySiteRef.FullName is nothing) then
Dim FullName12169 as String
FullName12169 = ORInvoiceLineRet12153.InvoiceLineRet.InventorySiteRef.FullName.GetValue()
End If
End If
if (not ORInvoiceLineRet12153.InvoiceLineRet.InventorySiteLocationRef. is nothing) then
'Get value of ListID
if ( not ORInvoiceLineRet12153.InvoiceLineRet.InventorySiteLocationRef.ListID is nothing) then
Dim ListID12170 as String
ListID12170 = ORInvoiceLineRet12153.InvoiceLineRet.InventorySiteLocationRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORInvoiceLineRet12153.InvoiceLineRet.InventorySiteLocationRef.FullName is nothing) then
Dim FullName12171 as String
FullName12171 = ORInvoiceLineRet12153.InvoiceLineRet.InventorySiteLocationRef.FullName.GetValue()
End If
End If
if (not ORInvoiceLineRet12153.InvoiceLineRet.ORSerialLotNumber is nothing) then
if (not ORInvoiceLineRet12153.InvoiceLineRet.ORSerialLotNumber.SerialNumber is nothing) then
'Get value of SerialNumber
if ( not ORInvoiceLineRet12153.InvoiceLineRet.ORSerialLotNumber.SerialNumber is nothing) then
Dim SerialNumber12173 as String
SerialNumber12173 = ORInvoiceLineRet12153.InvoiceLineRet.ORSerialLotNumber.SerialNumber.GetValue()
End If
End If
if (not ORInvoiceLineRet12153.InvoiceLineRet.ORSerialLotNumber.LotNumber is nothing) then
'Get value of LotNumber
if ( not ORInvoiceLineRet12153.InvoiceLineRet.ORSerialLotNumber.LotNumber is nothing) then
Dim LotNumber12174 as String
LotNumber12174 = ORInvoiceLineRet12153.InvoiceLineRet.ORSerialLotNumber.LotNumber.GetValue()
End If
End If
End If
'Get value of ExpirationDateForSerialLotNumber
if ( not ORInvoiceLineRet12153.InvoiceLineRet.FulExpirationDateForSerialLotNumberlName is nothing) then
Dim ExpDate as String
ExpDate = ORInvoiceLineRet12153.InvoiceLineRet.ExpirationDateForSerialLotNumber.GetValue()
End If
'Get value of ServiceDate
if ( not ORInvoiceLineRet12153.InvoiceLineRet.ServiceDate is nothing) then
Dim ServiceDate12175 as DateTime
ServiceDate12175 = ORInvoiceLineRet12153.InvoiceLineRet.ServiceDate.GetValue()
End If
if (not ORInvoiceLineRet12153.InvoiceLineRet.SalesTaxCodeRef. is nothing) then
'Get value of ListID
if ( not ORInvoiceLineRet12153.InvoiceLineRet.SalesTaxCodeRef.ListID is nothing) then
Dim ListID12176 as String
ListID12176 = ORInvoiceLineRet12153.InvoiceLineRet.SalesTaxCodeRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORInvoiceLineRet12153.InvoiceLineRet.SalesTaxCodeRef.FullName is nothing) then
Dim FullName12177 as String
FullName12177 = ORInvoiceLineRet12153.InvoiceLineRet.SalesTaxCodeRef.FullName.GetValue()
End If
End If
'Get value of Other1
if ( not ORInvoiceLineRet12153.InvoiceLineRet.Other1 is nothing) then
Dim Other112178 as String
Other112178 = ORInvoiceLineRet12153.InvoiceLineRet.Other1.GetValue()
End If
'Get value of Other2
if ( not ORInvoiceLineRet12153.InvoiceLineRet.Other2 is nothing) then
Dim Other212179 as String
Other212179 = ORInvoiceLineRet12153.InvoiceLineRet.Other2.GetValue()
End If
if (not ORInvoiceLineRet12153.InvoiceLineRet.DataExtRetList is nothing)
Dim i12180 as Integer
for i12180 = 0 to ORInvoiceLineRet12153.InvoiceLineRet.DataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = ORInvoiceLineRet12153.InvoiceLineRet.DataExtRetList.GetAt(i12180)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID12181 as String
OwnerID12181 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName12182 as String
DataExtName12182 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType12183 as ENDataExtType
DataExtType12183 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue12184 as String
DataExtValue12184 = DataExtRetDataExtValue.GetValue()
Next i12180
End If
End If
End If
if (not ORInvoiceLineRet12153.InvoiceLineGroupRet is nothing) then
if (not ORInvoiceLineRet12153.InvoiceLineGroupRet. is nothing) then
'Get value of TxnLineID
Dim TxnLineID12185 as String
TxnLineID12185 = ORInvoiceLineRet12153.InvoiceLineGroupRet.TxnLineID.GetValue()
'Get value of ListID
if ( not ORInvoiceLineRet12153.InvoiceLineGroupRet.ItemGroupRef.ListID is nothing) then
Dim ListID12186 as String
ListID12186 = ORInvoiceLineRet12153.InvoiceLineGroupRet.ItemGroupRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORInvoiceLineRet12153.InvoiceLineGroupRet.ItemGroupRef.FullName is nothing) then
Dim FullName12187 as String
FullName12187 = ORInvoiceLineRet12153.InvoiceLineGroupRet.ItemGroupRef.FullName.GetValue()
End If
'Get value of Desc
if ( not ORInvoiceLineRet12153.InvoiceLineGroupRet.Desc is nothing) then
Dim Desc12188 as String
Desc12188 = ORInvoiceLineRet12153.InvoiceLineGroupRet.Desc.GetValue()
End If
'Get value of Quantity
if ( not ORInvoiceLineRet12153.InvoiceLineGroupRet.Quantity is nothing) then
Dim Quantity12189 as Integer
Quantity12189 = ORInvoiceLineRet12153.InvoiceLineGroupRet.Quantity.GetValue()
End If
'Get value of UnitOfMeasure
if ( not ORInvoiceLineRet12153.InvoiceLineGroupRet.UnitOfMeasure is nothing) then
Dim UnitOfMeasure12190 as String
UnitOfMeasure12190 = ORInvoiceLineRet12153.InvoiceLineGroupRet.UnitOfMeasure.GetValue()
End If
if (not ORInvoiceLineRet12153.InvoiceLineGroupRet.OverrideUOMSetRef. is nothing) then
'Get value of ListID
if ( not ORInvoiceLineRet12153.InvoiceLineGroupRet.OverrideUOMSetRef.ListID is nothing) then
Dim ListID12191 as String
ListID12191 = ORInvoiceLineRet12153.InvoiceLineGroupRet.OverrideUOMSetRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORInvoiceLineRet12153.InvoiceLineGroupRet.OverrideUOMSetRef.FullName is nothing) then
Dim FullName12192 as String
FullName12192 = ORInvoiceLineRet12153.InvoiceLineGroupRet.OverrideUOMSetRef.FullName.GetValue()
End If
End If
'Get value of IsPrintItemsInGroup
Dim IsPrintItemsInGroup12193 as Boolean
IsPrintItemsInGroup12193 = ORInvoiceLineRet12153.InvoiceLineGroupRet.IsPrintItemsInGroup.GetValue()
'Get value of TotalAmount
Dim TotalAmount12194 as Double
TotalAmount12194 = ORInvoiceLineRet12153.InvoiceLineGroupRet.TotalAmount.GetValue()
if (not ORInvoiceLineRet12153.InvoiceLineGroupRet.InvoiceLineRetList is nothing)
Dim i12195 as Integer
for i12195 = 0 to ORInvoiceLineRet12153.InvoiceLineGroupRet.InvoiceLineRetList.Count - 1
Dim InvoiceLineRet as IInvoiceLineRet
InvoiceLineRet = ORInvoiceLineRet12153.InvoiceLineGroupRet.InvoiceLineRetList.GetAt(i12195)
'Get value of TxnLineID
Dim TxnLineID12196 as String
TxnLineID12196 = InvoiceLineRetTxnLineID.GetValue()
if (not InvoiceLineRetItemRef. is nothing) then
'Get value of ListID
if ( not InvoiceLineRetItemRef.ListID is nothing) then
Dim ListID12197 as String
ListID12197 = InvoiceLineRetItemRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceLineRetItemRef.FullName is nothing) then
Dim FullName12198 as String
FullName12198 = InvoiceLineRetItemRef.FullName.GetValue()
End If
End If
'Get value of Desc
if ( not InvoiceLineRetDesc is nothing) then
Dim Desc12199 as String
Desc12199 = InvoiceLineRetDesc.GetValue()
End If
'Get value of Quantity
if ( not InvoiceLineRetQuantity is nothing) then
Dim Quantity12200 as Integer
Quantity12200 = InvoiceLineRetQuantity.GetValue()
End If
'Get value of UnitOfMeasure
if ( not InvoiceLineRetUnitOfMeasure is nothing) then
Dim UnitOfMeasure12201 as String
UnitOfMeasure12201 = InvoiceLineRetUnitOfMeasure.GetValue()
End If
if (not InvoiceLineRetOverrideUOMSetRef. is nothing) then
'Get value of ListID
if ( not InvoiceLineRetOverrideUOMSetRef.ListID is nothing) then
Dim ListID12202 as String
ListID12202 = InvoiceLineRetOverrideUOMSetRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceLineRetOverrideUOMSetRef.FullName is nothing) then
Dim FullName12203 as String
FullName12203 = InvoiceLineRetOverrideUOMSetRef.FullName.GetValue()
End If
End If
if (not InvoiceLineRetORRate is nothing) then
if (not InvoiceLineRetORRate.Rate is nothing) then
'Get value of Rate
if ( not InvoiceLineRetORRate.Rate is nothing) then
Dim Rate12205 as Double
Rate12205 = InvoiceLineRetORRate.Rate.GetValue()
End If
End If
if (not InvoiceLineRetORRate.RatePercent is nothing) then
'Get value of RatePercent
if ( not InvoiceLineRetORRate.RatePercent is nothing) then
Dim RatePercent12206 as Double
RatePercent12206 = InvoiceLineRetORRate.RatePercent.GetValue()
End If
End If
End If
if (not InvoiceLineRetClassRef. is nothing) then
'Get value of ListID
if ( not InvoiceLineRetClassRef.ListID is nothing) then
Dim ListID12207 as String
ListID12207 = InvoiceLineRetClassRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceLineRetClassRef.FullName is nothing) then
Dim FullName12208 as String
FullName12208 = InvoiceLineRetClassRef.FullName.GetValue()
End If
End If
'Get value of Amount
if ( not InvoiceLineRetAmount is nothing) then
Dim Amount12209 as Double
Amount12209 = InvoiceLineRetAmount.GetValue()
End If
if (not InvoiceLineRetInventorySiteRef. is nothing) then
'Get value of ListID
if ( not InvoiceLineRetInventorySiteRef.ListID is nothing) then
Dim ListID12210 as String
ListID12210 = InvoiceLineRetInventorySiteRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceLineRetInventorySiteRef.FullName is nothing) then
Dim FullName12211 as String
FullName12211 = InvoiceLineRetInventorySiteRef.FullName.GetValue()
End If
End If
if (not InvoiceLineRetInventorySiteLocationRef. is nothing) then
'Get value of ListID
if ( not InvoiceLineRetInventorySiteLocationRef.ListID is nothing) then
Dim ListID12212 as String
ListID12212 = InvoiceLineRetInventorySiteLocationRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceLineRetInventorySiteLocationRef.FullName is nothing) then
Dim FullName12213 as String
FullName12213 = InvoiceLineRetInventorySiteLocationRef.FullName.GetValue()
End If
End If
if (not InvoiceLineRetORSerialLotNumber is nothing) then
if (not InvoiceLineRetORSerialLotNumber.SerialNumber is nothing) then
'Get value of SerialNumber
if ( not InvoiceLineRetORSerialLotNumber.SerialNumber is nothing) then
Dim SerialNumber12215 as String
SerialNumber12215 = InvoiceLineRetORSerialLotNumber.SerialNumber.GetValue()
End If
End If
if (not InvoiceLineRetORSerialLotNumber.LotNumber is nothing) then
'Get value of LotNumber
if ( not InvoiceLineRetORSerialLotNumber.LotNumber is nothing) then
Dim LotNumber12216 as String
LotNumber12216 = InvoiceLineRetORSerialLotNumber.LotNumber.GetValue()
End If
End If
End If
'Get value of ExpirationDateForSerialLotNumber
if ( not InvoiceLineRetExpirationDateForSerialLotNumber is nothing) then
Dim ExpDate as String
ExpDate = InvoiceLineRetExpirationDateForSerialLotNumber.GetValue()
End If
'Get value of ServiceDate
if ( not InvoiceLineRetServiceDate is nothing) then
Dim ServiceDate12217 as DateTime
ServiceDate12217 = InvoiceLineRetServiceDate.GetValue()
End If
if (not InvoiceLineRetSalesTaxCodeRef. is nothing) then
'Get value of ListID
if ( not InvoiceLineRetSalesTaxCodeRef.ListID is nothing) then
Dim ListID12218 as String
ListID12218 = InvoiceLineRetSalesTaxCodeRef.ListID.GetValue()
End If
'Get value of FullName
if ( not InvoiceLineRetSalesTaxCodeRef.FullName is nothing) then
Dim FullName12219 as String
FullName12219 = InvoiceLineRetSalesTaxCodeRef.FullName.GetValue()
End If
End If
'Get value of Other1
if ( not InvoiceLineRetOther1 is nothing) then
Dim Other112220 as String
Other112220 = InvoiceLineRetOther1.GetValue()
End If
'Get value of Other2
if ( not InvoiceLineRetOther2 is nothing) then
Dim Other212221 as String
Other212221 = InvoiceLineRetOther2.GetValue()
End If
if (not InvoiceLineRetDataExtRetList is nothing)
Dim i12222 as Integer
for i12222 = 0 to InvoiceLineRetDataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = InvoiceLineRetDataExtRetList.GetAt(i12222)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID12223 as String
OwnerID12223 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName12224 as String
DataExtName12224 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType12225 as ENDataExtType
DataExtType12225 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue12226 as String
DataExtValue12226 = DataExtRetDataExtValue.GetValue()
Next i12222
End If
Next i12195
End If
if (not ORInvoiceLineRet12153.InvoiceLineGroupRet.DataExtRetList is nothing)
Dim i12227 as Integer
for i12227 = 0 to ORInvoiceLineRet12153.InvoiceLineGroupRet.DataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = ORInvoiceLineRet12153.InvoiceLineGroupRet.DataExtRetList.GetAt(i12227)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID12228 as String
OwnerID12228 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName12229 as String
DataExtName12229 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType12230 as ENDataExtType
DataExtType12230 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue12231 as String
DataExtValue12231 = DataExtRetDataExtValue.GetValue()
Next i12227
End If
End If
End If
Next i12152
End If
if (not InvoiceRet.DataExtRetList is nothing)
Dim i12232 as Integer
for i12232 = 0 to InvoiceRet.DataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = InvoiceRet.DataExtRetList.GetAt(i12232)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID12233 as String
OwnerID12233 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName12234 as String
DataExtName12234 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType12235 as ENDataExtType
DataExtType12235 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue12236 as String
DataExtValue12236 = DataExtRetDataExtValue.GetValue()
Next i12232
End If
End Sub
End Class
End Module
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 | //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 DoInvoiceQuery() { 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; BuildInvoiceQueryRq(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; WalkInvoiceQueryRs(responseMsgSet); } catch (Exception e) { MessageBox.Show(e.Message, "Error"); if (sessionBegun) { sessionManager.EndSession(); } if (connectionOpen) { sessionManager.CloseConnection(); } } } void BuildInvoiceQueryRq(IMsgSetRequest requestMsgSet) { IInvoiceQuery InvoiceQueryRq= requestMsgSet.AppendInvoiceQueryRq(); //Set attributes //Set field value for metaData InvoiceQueryRq.metaData.SetValue("IQBENmetaDataType"); //Set field value for iterator InvoiceQueryRq.iterator.SetValue("IQBENiteratorType"); //Set field value for iteratorID InvoiceQueryRq.iteratorID.SetValue("IQBUUIDType"); string ORInvoiceQueryElementType11877 = "TxnIDList"; if (ORInvoiceQueryElementType11877 == "TxnIDList") { //Set field value for TxnIDList //May create more than one of these if needed InvoiceQueryRq.ORInvoiceQuery.TxnIDList.Add("200000-1011023419"); } if (ORInvoiceQueryElementType11877 == "RefNumberList") { //Set field value for RefNumberList //May create more than one of these if needed InvoiceQueryRq.ORInvoiceQuery.RefNumberList.Add("ab"); } if (ORInvoiceQueryElementType11877 == "RefNumberCaseSensitiveList") { //Set field value for RefNumberCaseSensitiveList //May create more than one of these if needed InvoiceQueryRq.ORInvoiceQuery.RefNumberCaseSensitiveList.Add("ab"); } if (ORInvoiceQueryElementType11877 == "InvoiceFilter") { //Set field value for MaxReturned InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.MaxReturned.SetValue(6); string ORDateRangeFilterElementType11878 = "ModifiedDateRangeFilter"; if (ORDateRangeFilterElementType11878 == "ModifiedDateRangeFilter") { //Set field value for FromModifiedDate InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); //Set field value for ToModifiedDate InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); } if (ORDateRangeFilterElementType11878 == "TxnDateRangeFilter") { string ORTxnDateRangeFilterElementType11879 = "TxnDateFilter"; if (ORTxnDateRangeFilterElementType11879 == "TxnDateFilter") { //Set field value for FromTxnDate InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007")); //Set field value for ToTxnDate InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007")); } if (ORTxnDateRangeFilterElementType11879 == "DateMacro") { //Set field value for DateMacro InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll); } } string OREntityFilterElementType11880 = "ListIDList"; if (OREntityFilterElementType11880 == "ListIDList") { //Set field value for ListIDList //May create more than one of these if needed InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.EntityFilter.OREntityFilter.ListIDList.Add("200000-1011023419"); } if (OREntityFilterElementType11880 == "FullNameList") { //Set field value for FullNameList //May create more than one of these if needed InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.EntityFilter.OREntityFilter.FullNameList.Add("ab"); } if (OREntityFilterElementType11880 == "ListIDWithChildren") { //Set field value for ListIDWithChildren InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.EntityFilter.OREntityFilter.ListIDWithChildren.SetValue("200000-1011023419"); } if (OREntityFilterElementType11880 == "FullNameWithChildren") { //Set field value for FullNameWithChildren InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.EntityFilter.OREntityFilter.FullNameWithChildren.SetValue("ab"); } string ORAccountFilterElementType11881 = "ListIDList"; if (ORAccountFilterElementType11881 == "ListIDList") { //Set field value for ListIDList //May create more than one of these if needed InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.AccountFilter.ORAccountFilter.ListIDList.Add("200000-1011023419"); } if (ORAccountFilterElementType11881 == "FullNameList") { //Set field value for FullNameList //May create more than one of these if needed InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.AccountFilter.ORAccountFilter.FullNameList.Add("ab"); } if (ORAccountFilterElementType11881 == "ListIDWithChildren") { //Set field value for ListIDWithChildren InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.AccountFilter.ORAccountFilter.ListIDWithChildren.SetValue("200000-1011023419"); } if (ORAccountFilterElementType11881 == "FullNameWithChildren") { //Set field value for FullNameWithChildren InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.AccountFilter.ORAccountFilter.FullNameWithChildren.SetValue("ab"); } string ORRefNumberFilterElementType11882 = "RefNumberFilter"; if (ORRefNumberFilterElementType11882 == "RefNumberFilter") { //Set field value for MatchCriterion InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORRefNumberFilter.RefNumberFilter.MatchCriterion.SetValue(ENMatchCriterion.mcStartsWith); //Set field value for RefNumber InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORRefNumberFilter.RefNumberFilter.RefNumber.SetValue("ab"); } if (ORRefNumberFilterElementType11882 == "RefNumberRangeFilter") { //Set field value for FromRefNumber InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORRefNumberFilter.RefNumberRangeFilter.FromRefNumber.SetValue("ab"); //Set field value for ToRefNumber InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.ORRefNumberFilter.RefNumberRangeFilter.ToRefNumber.SetValue("ab"); } string ORCurrencyFilterElementType11883 = "ListIDList"; if (ORCurrencyFilterElementType11883 == "ListIDList") { //Set field value for ListIDList //May create more than one of these if needed InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.CurrencyFilter.ORCurrencyFilter.ListIDList.Add("200000-1011023419"); } if (ORCurrencyFilterElementType11883 == "FullNameList") { //Set field value for FullNameList //May create more than one of these if needed InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.CurrencyFilter.ORCurrencyFilter.FullNameList.Add("ab"); } //Set field value for PaidStatus InvoiceQueryRq.ORInvoiceQuery.InvoiceFilter.PaidStatus.SetValue(ENPaidStatus.psAll [DEFAULT]); } //Set field value for IncludeLineItems InvoiceQueryRq.IncludeLineItems.SetValue(true); //Set field value for IncludeLinkedTxns InvoiceQueryRq.IncludeLinkedTxns.SetValue(true); //Set field value for IncludeRetElementList //May create more than one of these if needed InvoiceQueryRq.IncludeRetElementList.Add("ab"); //Set field value for OwnerIDList //May create more than one of these if needed InvoiceQueryRq.OwnerIDList.Add(Guid.NewGuid().ToString()); } void WalkInvoiceQueryRs(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.rtInvoiceQueryRs) { //upcast to more specific type here, this is safe because we checked with response.Type check above IInvoiceRetList InvoiceRet = (IInvoiceRetList)response.Detail; WalkInvoiceRet(InvoiceRet); } } } } } void WalkInvoiceRet(IInvoiceRetList InvoiceRet) { if (InvoiceRet == null) return; //Go through all the elements of IInvoiceRetList //Get value of TxnID string TxnID11884 = (string)InvoiceRet.TxnID.GetValue(); //Get value of TimeCreated DateTime TimeCreated11885 = (DateTime)InvoiceRet.TimeCreated.GetValue(); //Get value of TimeModified DateTime TimeModified11886 = (DateTime)InvoiceRet.TimeModified.GetValue(); //Get value of EditSequence string EditSequence11887 = (string)InvoiceRet.EditSequence.GetValue(); //Get value of TxnNumber if (InvoiceRet.TxnNumber != null) { int TxnNumber11888 = (int)InvoiceRet.TxnNumber.GetValue(); } //Get value of ListID if (InvoiceRet.CustomerRef.ListID != null) { string ListID11889 = (string)InvoiceRet.CustomerRef.ListID.GetValue(); } //Get value of FullName if (InvoiceRet.CustomerRef.FullName != null) { string FullName11890 = (string)InvoiceRet.CustomerRef.FullName.GetValue(); } if (InvoiceRet.ClassRef != null) { //Get value of ListID if (InvoiceRet.ClassRef.ListID != null) { string ListID11891 = (string)InvoiceRet.ClassRef.ListID.GetValue(); } //Get value of FullName if (InvoiceRet.ClassRef.FullName != null) { string FullName11892 = (string)InvoiceRet.ClassRef.FullName.GetValue(); } } if (InvoiceRet.ARAccountRef != null) { //Get value of ListID if (InvoiceRet.ARAccountRef.ListID != null) { string ListID11893 = (string)InvoiceRet.ARAccountRef.ListID.GetValue(); } //Get value of FullName if (InvoiceRet.ARAccountRef.FullName != null) { string FullName11894 = (string)InvoiceRet.ARAccountRef.FullName.GetValue(); } } if (InvoiceRet.TemplateRef != null) { //Get value of ListID if (InvoiceRet.TemplateRef.ListID != null) { string ListID11895 = (string)InvoiceRet.TemplateRef.ListID.GetValue(); } //Get value of FullName if (InvoiceRet.TemplateRef.FullName != null) { string FullName11896 = (string)InvoiceRet.TemplateRef.FullName.GetValue(); } } //Get value of TxnDate DateTime TxnDate11897 = (DateTime)InvoiceRet.TxnDate.GetValue(); //Get value of RefNumber if (InvoiceRet.RefNumber != null) { string RefNumber11898 = (string)InvoiceRet.RefNumber.GetValue(); } if (InvoiceRet.BillAddress != null) { //Get value of Addr1 if (InvoiceRet.BillAddress.Addr1 != null) { string Addr111899 = (string)InvoiceRet.BillAddress.Addr1.GetValue(); } //Get value of Addr2 if (InvoiceRet.BillAddress.Addr2 != null) { string Addr211900 = (string)InvoiceRet.BillAddress.Addr2.GetValue(); } //Get value of Addr3 if (InvoiceRet.BillAddress.Addr3 != null) { string Addr311901 = (string)InvoiceRet.BillAddress.Addr3.GetValue(); } //Get value of Addr4 if (InvoiceRet.BillAddress.Addr4 != null) { string Addr411902 = (string)InvoiceRet.BillAddress.Addr4.GetValue(); } //Get value of Addr5 if (InvoiceRet.BillAddress.Addr5 != null) { string Addr511903 = (string)InvoiceRet.BillAddress.Addr5.GetValue(); } //Get value of City if (InvoiceRet.BillAddress.City != null) { string City11904 = (string)InvoiceRet.BillAddress.City.GetValue(); } //Get value of State if (InvoiceRet.BillAddress.State != null) { string State11905 = (string)InvoiceRet.BillAddress.State.GetValue(); } //Get value of PostalCode if (InvoiceRet.BillAddress.PostalCode != null) { string PostalCode11906 = (string)InvoiceRet.BillAddress.PostalCode.GetValue(); } //Get value of Country if (InvoiceRet.BillAddress.Country != null) { string Country11907 = (string)InvoiceRet.BillAddress.Country.GetValue(); } //Get value of Note if (InvoiceRet.BillAddress.Note != null) { string Note11908 = (string)InvoiceRet.BillAddress.Note.GetValue(); } } if (InvoiceRet.BillAddressBlock != null) { //Get value of Addr1 if (InvoiceRet.BillAddressBlock.Addr1 != null) { string Addr111909 = (string)InvoiceRet.BillAddressBlock.Addr1.GetValue(); } //Get value of Addr2 if (InvoiceRet.BillAddressBlock.Addr2 != null) { string Addr211910 = (string)InvoiceRet.BillAddressBlock.Addr2.GetValue(); } //Get value of Addr3 if (InvoiceRet.BillAddressBlock.Addr3 != null) { string Addr311911 = (string)InvoiceRet.BillAddressBlock.Addr3.GetValue(); } //Get value of Addr4 if (InvoiceRet.BillAddressBlock.Addr4 != null) { string Addr411912 = (string)InvoiceRet.BillAddressBlock.Addr4.GetValue(); } //Get value of Addr5 if (InvoiceRet.BillAddressBlock.Addr5 != null) { string Addr511913 = (string)InvoiceRet.BillAddressBlock.Addr5.GetValue(); } } if (InvoiceRet.ShipAddress != null) { //Get value of Addr1 if (InvoiceRet.ShipAddress.Addr1 != null) { string Addr111914 = (string)InvoiceRet.ShipAddress.Addr1.GetValue(); } //Get value of Addr2 if (InvoiceRet.ShipAddress.Addr2 != null) { string Addr211915 = (string)InvoiceRet.ShipAddress.Addr2.GetValue(); } //Get value of Addr3 if (InvoiceRet.ShipAddress.Addr3 != null) { string Addr311916 = (string)InvoiceRet.ShipAddress.Addr3.GetValue(); } //Get value of Addr4 if (InvoiceRet.ShipAddress.Addr4 != null) { string Addr411917 = (string)InvoiceRet.ShipAddress.Addr4.GetValue(); } //Get value of Addr5 if (InvoiceRet.ShipAddress.Addr5 != null) { string Addr511918 = (string)InvoiceRet.ShipAddress.Addr5.GetValue(); } //Get value of City if (InvoiceRet.ShipAddress.City != null) { string City11919 = (string)InvoiceRet.ShipAddress.City.GetValue(); } //Get value of State if (InvoiceRet.ShipAddress.State != null) { string State11920 = (string)InvoiceRet.ShipAddress.State.GetValue(); } //Get value of PostalCode if (InvoiceRet.ShipAddress.PostalCode != null) { string PostalCode11921 = (string)InvoiceRet.ShipAddress.PostalCode.GetValue(); } //Get value of Country if (InvoiceRet.ShipAddress.Country != null) { string Country11922 = (string)InvoiceRet.ShipAddress.Country.GetValue(); } //Get value of Note if (InvoiceRet.ShipAddress.Note != null) { string Note11923 = (string)InvoiceRet.ShipAddress.Note.GetValue(); } } if (InvoiceRet.ShipAddressBlock != null) { //Get value of Addr1 if (InvoiceRet.ShipAddressBlock.Addr1 != null) { string Addr111924 = (string)InvoiceRet.ShipAddressBlock.Addr1.GetValue(); } //Get value of Addr2 if (InvoiceRet.ShipAddressBlock.Addr2 != null) { string Addr211925 = (string)InvoiceRet.ShipAddressBlock.Addr2.GetValue(); } //Get value of Addr3 if (InvoiceRet.ShipAddressBlock.Addr3 != null) { string Addr311926 = (string)InvoiceRet.ShipAddressBlock.Addr3.GetValue(); } //Get value of Addr4 if (InvoiceRet.ShipAddressBlock.Addr4 != null) { string Addr411927 = (string)InvoiceRet.ShipAddressBlock.Addr4.GetValue(); } //Get value of Addr5 if (InvoiceRet.ShipAddressBlock.Addr5 != null) { string Addr511928 = (string)InvoiceRet.ShipAddressBlock.Addr5.GetValue(); } } //Get value of IsPending if (InvoiceRet.IsPending != null) { bool IsPending11929 = (bool)InvoiceRet.IsPending.GetValue(); } //Get value of IsFinanceCharge if (InvoiceRet.IsFinanceCharge != null) { bool IsFinanceCharge11930 = (bool)InvoiceRet.IsFinanceCharge.GetValue(); } //Get value of PONumber if (InvoiceRet.PONumber != null) { string PONumber11931 = (string)InvoiceRet.PONumber.GetValue(); } if (InvoiceRet.TermsRef != null) { //Get value of ListID if (InvoiceRet.TermsRef.ListID != null) { string ListID11932 = (string)InvoiceRet.TermsRef.ListID.GetValue(); } //Get value of FullName if (InvoiceRet.TermsRef.FullName != null) { string FullName11933 = (string)InvoiceRet.TermsRef.FullName.GetValue(); } } //Get value of DueDate if (InvoiceRet.DueDate != null) { DateTime DueDate11934 = (DateTime)InvoiceRet.DueDate.GetValue(); } if (InvoiceRet.SalesRepRef != null) { //Get value of ListID if (InvoiceRet.SalesRepRef.ListID != null) { string ListID11935 = (string)InvoiceRet.SalesRepRef.ListID.GetValue(); } //Get value of FullName if (InvoiceRet.SalesRepRef.FullName != null) { string FullName11936 = (string)InvoiceRet.SalesRepRef.FullName.GetValue(); } } //Get value of FOB if (InvoiceRet.FOB != null) { string FOB11937 = (string)InvoiceRet.FOB.GetValue(); } //Get value of ShipDate if (InvoiceRet.ShipDate != null) { DateTime ShipDate11938 = (DateTime)InvoiceRet.ShipDate.GetValue(); } if (InvoiceRet.ShipMethodRef != null) { //Get value of ListID if (InvoiceRet.ShipMethodRef.ListID != null) { string ListID11939 = (string)InvoiceRet.ShipMethodRef.ListID.GetValue(); } //Get value of FullName if (InvoiceRet.ShipMethodRef.FullName != null) { string FullName11940 = (string)InvoiceRet.ShipMethodRef.FullName.GetValue(); } } //Get value of Subtotal if (InvoiceRet.Subtotal != null) { double Subtotal11941 = (double)InvoiceRet.Subtotal.GetValue(); } if (InvoiceRet.ItemSalesTaxRef != null) { //Get value of ListID if (InvoiceRet.ItemSalesTaxRef.ListID != null) { string ListID11942 = (string)InvoiceRet.ItemSalesTaxRef.ListID.GetValue(); } //Get value of FullName if (InvoiceRet.ItemSalesTaxRef.FullName != null) { string FullName11943 = (string)InvoiceRet.ItemSalesTaxRef.FullName.GetValue(); } } //Get value of SalesTaxPercentage if (InvoiceRet.SalesTaxPercentage != null) { double SalesTaxPercentage11944 = (double)InvoiceRet.SalesTaxPercentage.GetValue(); } //Get value of SalesTaxTotal if (InvoiceRet.SalesTaxTotal != null) { double SalesTaxTotal11945 = (double)InvoiceRet.SalesTaxTotal.GetValue(); } //Get value of AppliedAmount if (InvoiceRet.AppliedAmount != null) { double AppliedAmount11946 = (double)InvoiceRet.AppliedAmount.GetValue(); } //Get value of BalanceRemaining if (InvoiceRet.BalanceRemaining != null) { double BalanceRemaining11947 = (double)InvoiceRet.BalanceRemaining.GetValue(); } if (InvoiceRet.CurrencyRef != null) { //Get value of ListID if (InvoiceRet.CurrencyRef.ListID != null) { string ListID11948 = (string)InvoiceRet.CurrencyRef.ListID.GetValue(); } //Get value of FullName if (InvoiceRet.CurrencyRef.FullName != null) { string FullName11949 = (string)InvoiceRet.CurrencyRef.FullName.GetValue(); } } //Get value of ExchangeRate if (InvoiceRet.ExchangeRate != null) { IQBFloatType ExchangeRate11950 = (IQBFloatType)InvoiceRet.ExchangeRate.GetValue(); } //Get value of BalanceRemainingInHomeCurrency if (InvoiceRet.BalanceRemainingInHomeCurrency != null) { double BalanceRemainingInHomeCurrency11951 = (double)InvoiceRet.BalanceRemainingInHomeCurrency.GetValue(); } //Get value of Memo if (InvoiceRet.Memo != null) { string Memo11952 = (string)InvoiceRet.Memo.GetValue(); } //Get value of IsPaid if (InvoiceRet.IsPaid != null) { bool IsPaid11953 = (bool)InvoiceRet.IsPaid.GetValue(); } if (InvoiceRet.CustomerMsgRef != null) { //Get value of ListID if (InvoiceRet.CustomerMsgRef.ListID != null) { string ListID11954 = (string)InvoiceRet.CustomerMsgRef.ListID.GetValue(); } //Get value of FullName if (InvoiceRet.CustomerMsgRef.FullName != null) { string FullName11955 = (string)InvoiceRet.CustomerMsgRef.FullName.GetValue(); } } //Get value of IsToBePrinted if (InvoiceRet.IsToBePrinted != null) { bool IsToBePrinted11956 = (bool)InvoiceRet.IsToBePrinted.GetValue(); } //Get value of IsToBeEmailed if (InvoiceRet.IsToBeEmailed != null) { bool IsToBeEmailed11957 = (bool)InvoiceRet.IsToBeEmailed.GetValue(); } //Get value of IsTaxIncluded if (InvoiceRet.IsTaxIncluded != null) { bool IsTaxIncluded11958 = (bool)InvoiceRet.IsTaxIncluded.GetValue(); } if (InvoiceRet.CustomerSalesTaxCodeRef != null) { //Get value of ListID if (InvoiceRet.CustomerSalesTaxCodeRef.ListID != null) { string ListID11959 = (string)InvoiceRet.CustomerSalesTaxCodeRef.ListID.GetValue(); } //Get value of FullName if (InvoiceRet.CustomerSalesTaxCodeRef.FullName != null) { string FullName11960 = (string)InvoiceRet.CustomerSalesTaxCodeRef.FullName.GetValue(); } } //Get value of SuggestedDiscountAmount if (InvoiceRet.SuggestedDiscountAmount != null) { double SuggestedDiscountAmount11961 = (double)InvoiceRet.SuggestedDiscountAmount.GetValue(); } //Get value of SuggestedDiscountDate if (InvoiceRet.SuggestedDiscountDate != null) { DateTime SuggestedDiscountDate11962 = (DateTime)InvoiceRet.SuggestedDiscountDate.GetValue(); } //Get value of Other if (InvoiceRet.Other != null) { string Other11963 = (string)InvoiceRet.Other.GetValue(); } //Get value of ExternalGUID if (InvoiceRet.ExternalGUID != null) { string ExternalGUID11964 = (string)InvoiceRet.ExternalGUID.GetValue(); } if (InvoiceRet.LinkedTxnList != null) { for (int i11965 = 0; i11965 < InvoiceRet.LinkedTxnList.Count; i11965++) { ILinkedTxn LinkedTxn = InvoiceRet.LinkedTxnList.GetAt(i11965); //Get value of TxnID string TxnID11966 = (string)LinkedTxn.TxnID.GetValue(); //Get value of TxnType ENTxnType TxnType11967 = (ENTxnType)LinkedTxn.TxnType.GetValue(); //Get value of TxnDate DateTime TxnDate11968 = (DateTime)LinkedTxn.TxnDate.GetValue(); //Get value of RefNumber if (LinkedTxn.RefNumber != null) { string RefNumber11969 = (string)LinkedTxn.RefNumber.GetValue(); } //Get value of LinkType if (LinkedTxn.LinkType != null) { ENLinkType LinkType11970 = (ENLinkType)LinkedTxn.LinkType.GetValue(); } //Get value of Amount double Amount11971 = (double)LinkedTxn.Amount.GetValue(); } } if (InvoiceRet.ORInvoiceLineRetList != null) { for (int i11972 = 0; i11972 < InvoiceRet.ORInvoiceLineRetList.Count; i11972++) { IORInvoiceLineRet ORInvoiceLineRet11973 = InvoiceRet.ORInvoiceLineRetList.GetAt(i11972); if (ORInvoiceLineRet11973.InvoiceLineRet != null) { if (ORInvoiceLineRet11973.InvoiceLineRet != null) { //Get value of TxnLineID string TxnLineID11974 = (string)ORInvoiceLineRet11973.InvoiceLineRet.TxnLineID.GetValue(); if (ORInvoiceLineRet11973.InvoiceLineRet.ItemRef != null) { //Get value of ListID if (ORInvoiceLineRet11973.InvoiceLineRet.ItemRef.ListID != null) { string ListID11975 = (string)ORInvoiceLineRet11973.InvoiceLineRet.ItemRef.ListID.GetValue(); } //Get value of FullName if (ORInvoiceLineRet11973.InvoiceLineRet.ItemRef.FullName != null) { string FullName11976 = (string)ORInvoiceLineRet11973.InvoiceLineRet.ItemRef.FullName.GetValue(); } } //Get value of Desc if (ORInvoiceLineRet11973.InvoiceLineRet.Desc != null) { string Desc11977 = (string)ORInvoiceLineRet11973.InvoiceLineRet.Desc.GetValue(); } //Get value of Quantity if (ORInvoiceLineRet11973.InvoiceLineRet.Quantity != null) { int Quantity11978 = (int)ORInvoiceLineRet11973.InvoiceLineRet.Quantity.GetValue(); } //Get value of UnitOfMeasure if (ORInvoiceLineRet11973.InvoiceLineRet.UnitOfMeasure != null) { string UnitOfMeasure11979 = (string)ORInvoiceLineRet11973.InvoiceLineRet.UnitOfMeasure.GetValue(); } if (ORInvoiceLineRet11973.InvoiceLineRet.OverrideUOMSetRef != null) { //Get value of ListID if (ORInvoiceLineRet11973.InvoiceLineRet.OverrideUOMSetRef.ListID != null) { string ListID11980 = (string)ORInvoiceLineRet11973.InvoiceLineRet.OverrideUOMSetRef.ListID.GetValue(); } //Get value of FullName if (ORInvoiceLineRet11973.InvoiceLineRet.OverrideUOMSetRef.FullName != null) { string FullName11981 = (string)ORInvoiceLineRet11973.InvoiceLineRet.OverrideUOMSetRef.FullName.GetValue(); } } if (ORInvoiceLineRet11973.InvoiceLineRet.ORRate != null) { if (ORInvoiceLineRet11973.InvoiceLineRet.ORRate.Rate != null) { //Get value of Rate if (ORInvoiceLineRet11973.InvoiceLineRet.ORRate.Rate != null) { double Rate11983 = (double)ORInvoiceLineRet11973.InvoiceLineRet.ORRate.Rate.GetValue(); } } if (ORInvoiceLineRet11973.InvoiceLineRet.ORRate.RatePercent != null) { //Get value of RatePercent if (ORInvoiceLineRet11973.InvoiceLineRet.ORRate.RatePercent != null) { double RatePercent11984 = (double)ORInvoiceLineRet11973.InvoiceLineRet.ORRate.RatePercent.GetValue(); } } } if (ORInvoiceLineRet11973.InvoiceLineRet.ClassRef != null) { //Get value of ListID if (ORInvoiceLineRet11973.InvoiceLineRet.ClassRef.ListID != null) { string ListID11985 = (string)ORInvoiceLineRet11973.InvoiceLineRet.ClassRef.ListID.GetValue(); } //Get value of FullName if (ORInvoiceLineRet11973.InvoiceLineRet.ClassRef.FullName != null) { string FullName11986 = (string)ORInvoiceLineRet11973.InvoiceLineRet.ClassRef.FullName.GetValue(); } } //Get value of Amount if (ORInvoiceLineRet11973.InvoiceLineRet.Amount != null) { double Amount11987 = (double)ORInvoiceLineRet11973.InvoiceLineRet.Amount.GetValue(); } if (ORInvoiceLineRet11973.InvoiceLineRet.InventorySiteRef != null) { //Get value of ListID if (ORInvoiceLineRet11973.InvoiceLineRet.InventorySiteRef.ListID != null) { string ListID11988 = (string)ORInvoiceLineRet11973.InvoiceLineRet.InventorySiteRef.ListID.GetValue(); } //Get value of FullName if (ORInvoiceLineRet11973.InvoiceLineRet.InventorySiteRef.FullName != null) { string FullName11989 = (string)ORInvoiceLineRet11973.InvoiceLineRet.InventorySiteRef.FullName.GetValue(); } } if (ORInvoiceLineRet11973.InvoiceLineRet.InventorySiteLocationRef != null) { //Get value of ListID if (ORInvoiceLineRet11973.InvoiceLineRet.InventorySiteLocationRef.ListID != null) { string ListID11990 = (string)ORInvoiceLineRet11973.InvoiceLineRet.InventorySiteLocationRef.ListID.GetValue(); } //Get value of FullName if (ORInvoiceLineRet11973.InvoiceLineRet.InventorySiteLocationRef.FullName != null) { string FullName11991 = (string)ORInvoiceLineRet11973.InvoiceLineRet.InventorySiteLocationRef.FullName.GetValue(); } } if (ORInvoiceLineRet11973.InvoiceLineRet.ORSerialLotNumber != null) { if (ORInvoiceLineRet11973.InvoiceLineRet.ORSerialLotNumber.SerialNumber != null) { //Get value of SerialNumber if (ORInvoiceLineRet11973.InvoiceLineRet.ORSerialLotNumber.SerialNumber != null) { string SerialNumber11993 = (string)ORInvoiceLineRet11973.InvoiceLineRet.ORSerialLotNumber.SerialNumber.GetValue(); } } if (ORInvoiceLineRet11973.InvoiceLineRet.ORSerialLotNumber.LotNumber != null) { //Get value of LotNumber if (ORInvoiceLineRet11973.InvoiceLineRet.ORSerialLotNumber.LotNumber != null) { string LotNumber11994 = (string)ORInvoiceLineRet11973.InvoiceLineRet.ORSerialLotNumber.LotNumber.GetValue(); } } } //Get value of ExpirationDateForSerialLotNumber if (ORInvoiceLineRet11973.InvoiceLineRet.ExpirationDateForSerialLotNumber != null) { string ExpDate = (string)ORInvoiceLineRet11973.InvoiceLineRet.ExpirationDateForSerialLotNumber.GetValue(); } //Get value of ServiceDate if (ORInvoiceLineRet11973.InvoiceLineRet.ServiceDate != null) { DateTime ServiceDate11995 = (DateTime)ORInvoiceLineRet11973.InvoiceLineRet.ServiceDate.GetValue(); } if (ORInvoiceLineRet11973.InvoiceLineRet.SalesTaxCodeRef != null) { //Get value of ListID if (ORInvoiceLineRet11973.InvoiceLineRet.SalesTaxCodeRef.ListID != null) { string ListID11996 = (string)ORInvoiceLineRet11973.InvoiceLineRet.SalesTaxCodeRef.ListID.GetValue(); } //Get value of FullName if (ORInvoiceLineRet11973.InvoiceLineRet.SalesTaxCodeRef.FullName != null) { string FullName11997 = (string)ORInvoiceLineRet11973.InvoiceLineRet.SalesTaxCodeRef.FullName.GetValue(); } } //Get value of Other1 if (ORInvoiceLineRet11973.InvoiceLineRet.Other1 != null) { string Other111998 = (string)ORInvoiceLineRet11973.InvoiceLineRet.Other1.GetValue(); } //Get value of Other2 if (ORInvoiceLineRet11973.InvoiceLineRet.Other2 != null) { string Other211999 = (string)ORInvoiceLineRet11973.InvoiceLineRet.Other2.GetValue(); } if (ORInvoiceLineRet11973.InvoiceLineRet.DataExtRetList != null) { for (int i12000 = 0; i12000 < ORInvoiceLineRet11973.InvoiceLineRet.DataExtRetList.Count; i12000++) { IDataExtRet DataExtRet = ORInvoiceLineRet11973.InvoiceLineRet.DataExtRetList.GetAt(i12000); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID12001 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName12002 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType12003 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue12004 = (string)DataExtRet.DataExtValue.GetValue(); } } } } if (ORInvoiceLineRet11973.InvoiceLineGroupRet != null) { if (ORInvoiceLineRet11973.InvoiceLineGroupRet != null) { //Get value of TxnLineID string TxnLineID12005 = (string)ORInvoiceLineRet11973.InvoiceLineGroupRet.TxnLineID.GetValue(); //Get value of ListID if (ORInvoiceLineRet11973.InvoiceLineGroupRet.ItemGroupRef.ListID != null) { string ListID12006 = (string)ORInvoiceLineRet11973.InvoiceLineGroupRet.ItemGroupRef.ListID.GetValue(); } //Get value of FullName if (ORInvoiceLineRet11973.InvoiceLineGroupRet.ItemGroupRef.FullName != null) { string FullName12007 = (string)ORInvoiceLineRet11973.InvoiceLineGroupRet.ItemGroupRef.FullName.GetValue(); } //Get value of Desc if (ORInvoiceLineRet11973.InvoiceLineGroupRet.Desc != null) { string Desc12008 = (string)ORInvoiceLineRet11973.InvoiceLineGroupRet.Desc.GetValue(); } //Get value of Quantity if (ORInvoiceLineRet11973.InvoiceLineGroupRet.Quantity != null) { int Quantity12009 = (int)ORInvoiceLineRet11973.InvoiceLineGroupRet.Quantity.GetValue(); } //Get value of UnitOfMeasure if (ORInvoiceLineRet11973.InvoiceLineGroupRet.UnitOfMeasure != null) { string UnitOfMeasure12010 = (string)ORInvoiceLineRet11973.InvoiceLineGroupRet.UnitOfMeasure.GetValue(); } if (ORInvoiceLineRet11973.InvoiceLineGroupRet.OverrideUOMSetRef != null) { //Get value of ListID if (ORInvoiceLineRet11973.InvoiceLineGroupRet.OverrideUOMSetRef.ListID != null) { string ListID12011 = (string)ORInvoiceLineRet11973.InvoiceLineGroupRet.OverrideUOMSetRef.ListID.GetValue(); } //Get value of FullName if (ORInvoiceLineRet11973.InvoiceLineGroupRet.OverrideUOMSetRef.FullName != null) { string FullName12012 = (string)ORInvoiceLineRet11973.InvoiceLineGroupRet.OverrideUOMSetRef.FullName.GetValue(); } } //Get value of IsPrintItemsInGroup bool IsPrintItemsInGroup12013 = (bool)ORInvoiceLineRet11973.InvoiceLineGroupRet.IsPrintItemsInGroup.GetValue(); //Get value of TotalAmount double TotalAmount12014 = (double)ORInvoiceLineRet11973.InvoiceLineGroupRet.TotalAmount.GetValue(); if (ORInvoiceLineRet11973.InvoiceLineGroupRet.InvoiceLineRetList != null) { for (int i12015 = 0; i12015 < ORInvoiceLineRet11973.InvoiceLineGroupRet.InvoiceLineRetList.Count; i12015++) { IInvoiceLineRet InvoiceLineRet = ORInvoiceLineRet11973.InvoiceLineGroupRet.InvoiceLineRetList.GetAt(i12015); //Get value of TxnLineID string TxnLineID12016 = (string)InvoiceLineRet.TxnLineID.GetValue(); if (InvoiceLineRet.ItemRef != null) { //Get value of ListID if (InvoiceLineRet.ItemRef.ListID != null) { string ListID12017 = (string)InvoiceLineRet.ItemRef.ListID.GetValue(); } //Get value of FullName if (InvoiceLineRet.ItemRef.FullName != null) { string FullName12018 = (string)InvoiceLineRet.ItemRef.FullName.GetValue(); } } //Get value of Desc if (InvoiceLineRet.Desc != null) { string Desc12019 = (string)InvoiceLineRet.Desc.GetValue(); } //Get value of Quantity if (InvoiceLineRet.Quantity != null) { int Quantity12020 = (int)InvoiceLineRet.Quantity.GetValue(); } //Get value of UnitOfMeasure if (InvoiceLineRet.UnitOfMeasure != null) { string UnitOfMeasure12021 = (string)InvoiceLineRet.UnitOfMeasure.GetValue(); } if (InvoiceLineRet.OverrideUOMSetRef != null) { //Get value of ListID if (InvoiceLineRet.OverrideUOMSetRef.ListID != null) { string ListID12022 = (string)InvoiceLineRet.OverrideUOMSetRef.ListID.GetValue(); } //Get value of FullName if (InvoiceLineRet.OverrideUOMSetRef.FullName != null) { string FullName12023 = (string)InvoiceLineRet.OverrideUOMSetRef.FullName.GetValue(); } } if (InvoiceLineRet.ORRate != null) { if (InvoiceLineRet.ORRate.Rate != null) { //Get value of Rate if (InvoiceLineRet.ORRate.Rate != null) { double Rate12025 = (double)InvoiceLineRet.ORRate.Rate.GetValue(); } } if (InvoiceLineRet.ORRate.RatePercent != null) { //Get value of RatePercent if (InvoiceLineRet.ORRate.RatePercent != null) { double RatePercent12026 = (double)InvoiceLineRet.ORRate.RatePercent.GetValue(); } } } if (InvoiceLineRet.ClassRef != null) { //Get value of ListID if (InvoiceLineRet.ClassRef.ListID != null) { string ListID12027 = (string)InvoiceLineRet.ClassRef.ListID.GetValue(); } //Get value of FullName if (InvoiceLineRet.ClassRef.FullName != null) { string FullName12028 = (string)InvoiceLineRet.ClassRef.FullName.GetValue(); } } //Get value of Amount if (InvoiceLineRet.Amount != null) { double Amount12029 = (double)InvoiceLineRet.Amount.GetValue(); } if (InvoiceLineRet.InventorySiteRef != null) { //Get value of ListID if (InvoiceLineRet.InventorySiteRef.ListID != null) { string ListID12030 = (string)InvoiceLineRet.InventorySiteRef.ListID.GetValue(); } //Get value of FullName if (InvoiceLineRet.InventorySiteRef.FullName != null) { string FullName12031 = (string)InvoiceLineRet.InventorySiteRef.FullName.GetValue(); } } if (InvoiceLineRet.InventorySiteLocationRef != null) { //Get value of ListID if (InvoiceLineRet.InventorySiteLocationRef.ListID != null) { string ListID12032 = (string)InvoiceLineRet.InventorySiteLocationRef.ListID.GetValue(); } //Get value of FullName if (InvoiceLineRet.InventorySiteLocationRef.FullName != null) { string FullName12033 = (string)InvoiceLineRet.InventorySiteLocationRef.FullName.GetValue(); } } if (InvoiceLineRet.ORSerialLotNumber != null) { if (InvoiceLineRet.ORSerialLotNumber.SerialNumber != null) { //Get value of SerialNumber if (InvoiceLineRet.ORSerialLotNumber.SerialNumber != null) { string SerialNumber12035 = (string)InvoiceLineRet.ORSerialLotNumber.SerialNumber.GetValue(); } } if (InvoiceLineRet.ORSerialLotNumber.LotNumber != null) { //Get value of LotNumber if (InvoiceLineRet.ORSerialLotNumber.LotNumber != null) { string LotNumber12036 = (string)InvoiceLineRet.ORSerialLotNumber.LotNumber.GetValue(); } } } //Get value of ExpirationDateForSerialLotNumber if (InvoiceLineRet.ExpirationDateForSerialLotNumber != null) { string ExpDate = (string)InvoiceLineRet.ExpirationDateForSerialLotNumber.GetValue(); } //Get value of ServiceDate if (InvoiceLineRet.ServiceDate != null) { DateTime ServiceDate12037 = (DateTime)InvoiceLineRet.ServiceDate.GetValue(); } if (InvoiceLineRet.SalesTaxCodeRef != null) { //Get value of ListID if (InvoiceLineRet.SalesTaxCodeRef.ListID != null) { string ListID12038 = (string)InvoiceLineRet.SalesTaxCodeRef.ListID.GetValue(); } //Get value of FullName if (InvoiceLineRet.SalesTaxCodeRef.FullName != null) { string FullName12039 = (string)InvoiceLineRet.SalesTaxCodeRef.FullName.GetValue(); } } //Get value of Other1 if (InvoiceLineRet.Other1 != null) { string Other112040 = (string)InvoiceLineRet.Other1.GetValue(); } //Get value of Other2 if (InvoiceLineRet.Other2 != null) { string Other212041 = (string)InvoiceLineRet.Other2.GetValue(); } if (InvoiceLineRet.DataExtRetList != null) { for (int i12042 = 0; i12042 < InvoiceLineRet.DataExtRetList.Count; i12042++) { IDataExtRet DataExtRet = InvoiceLineRet.DataExtRetList.GetAt(i12042); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID12043 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName12044 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType12045 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue12046 = (string)DataExtRet.DataExtValue.GetValue(); } } } } if (ORInvoiceLineRet11973.InvoiceLineGroupRet.DataExtRetList != null) { for (int i12047 = 0; i12047 < ORInvoiceLineRet11973.InvoiceLineGroupRet.DataExtRetList.Count; i12047++) { IDataExtRet DataExtRet = ORInvoiceLineRet11973.InvoiceLineGroupRet.DataExtRetList.GetAt(i12047); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID12048 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName12049 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType12050 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue12051 = (string)DataExtRet.DataExtValue.GetValue(); } } } } } } if (InvoiceRet.DataExtRetList != null) { for (int i12052 = 0; i12052 < InvoiceRet.DataExtRetList.Count; i12052++) { IDataExtRet DataExtRet = InvoiceRet.DataExtRetList.GetAt(i12052); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID12053 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName12054 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType12055 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue12056 = (string)DataExtRet.DataExtValue.GetValue(); } } } } } |