SalesOrderQuery(2.1)
Queries for the specified sales order or set of sales orders.
Request
Response
XMLOps
VB.NET
C#
| Tag | Type | Max length | Implementation | Required |
|---|---|---|---|---|
ISalesOrderQuery
Queries for the specified sales order or set of sales orders.
|
2.1 | |||
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 |
||
ORTxnNoAccountQuery |
IORTxnNoAccountQuery | |||
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 | ||
TxnFilterNoAccount
TxnFilterNoAccount is similar to the filters found in other transaction queries, but it does not include an Account filter.
|
ITxnFilterNoAccount | |||
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 | |||
ORRefNumberFilter |
IORRefNumberFilter | |||
RefNumberFilter
Filters according to RefNumber.
|
IRefNumberFilter | |||
MatchCriterion
The criterion to match.
|
IQBENMatchCriterionType | Y | ||
RefNumber
A string of characters that refers to this transaction and that can be arbitrarily changed by the QuickBooks user. In a BillPaymentCheckAdd request, if you want to set the check number, use RefNumber.Note (especially relevant to CheckAdd requests): When RefNumber is left blank in an SDK transaction add request (that is, or ), the RefNumber will be left blank in QuickBooks. This behavior is new as of QBFC3. It used to select the next sequential reference number since the last one used by QuickBooks, as though no RefNumber had been provided. This is especially relevant to CheckAdd requests because with the current behavior, you will not know the number until the check is printed.
|
IQBStringType | Y | ||
RefNumberRangeFilter
Filters according to RefNumber. The filtering code will do a numerical comparison (if FromRefNumber and ToRefNumber only contain digits) or a lexicographical comparison (if either FromRefNumber or ToRefNumber contain any nondigit characters). In the first situation, if you need to query for a RefNumber that is larger than the maximum long integer value of 2147483647, one workaround is to specify a FromRefNumber that is less than or equal to 2147483647 without specifying a ToRefNumber.
|
IRefNumberRangeFilter | |||
FromRefNumber
The first RefNumber in the search range. If FromRefNumber is omitted, the range will begin with first number on the list.
|
IQBStringType | |||
ToRefNumber
The final RefNumber in the search range. If ToRefNumber is omitted, the range will end with last number on the list.
|
IQBStringType | |||
CurrencyFilter
Filters by the specified currency.
|
ICurrencyFilter | 8.0 | ||
ORCurrencyFilter |
IORCurrencyFilter | Y | ||
ListIDList
One or more ListID values. Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IBSTRList | |||
FullNameList
A list of one or more FullName values. FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IBSTRList | 64 chars | ||
IncludeLineItems
This filter allows you to omit line items from a query response to get a smaller result. The default value is false, so line items are omitted by default. Set IncludeLineItems to true to include line items in the response if you don’t mind getting a larger result.
|
IQBBoolType | |||
IncludeLinkedTxns
If you set IncludeLinkedTxns to true, then the returned object will include a list of all the transactions linked to the queried object. (This list is similar to the History view of a transaction in the user interface, but not identical, as the SDK list contains only linked transactions, not items.) Each linked transaction will be represented by a LinkedTxn aggregate. If no linked transactions exist, no LinkedTxn aggregates will be returned.
|
IQBBoolType | 2.0 | ||
IncludeRetElementList
You use this if you want to limit the data that will be returned in the response. In this list, you specify the name of each top-level element or aggregate that you want to be returned in the response to the request. You cannot specify fields within an aggregate, for example, you cannot specify a City within an Address: you must specify Address and will get the entire address. The names specified in the list are not parsed, so you must be especially careful to supply valid names, properly cased. No error is returned in the status code if you specify an invalid name. Notice that if you want to return custom data or private data extensions, you must specify the DataExtRet element and you must supply the OwnerID set to either a value of 0 (custom data) or the GUID for the private data.
|
IBSTRList | 50 chars | 4.0 | |
OwnerIDList
Zero or more OwnerID values. OwnerID refers to the owner of a data extension:If OwnerID is 0, this is a public data extension, also known as a custom field. Custom fields appear in the QuickBooks UI.If OwnerID is a GUID, for example {6B063959-81B0-4622-85D6-F548C8CCB517}, this field is a private data extension defined by an integrated application. Private data extensions do not appear in the QuickBooks UI. Note that OwnerID values are not case-sensitive, meaning that if you enter an OwnerID value with lower-case letters, the value will be saved and returned with upper-case letters. When you share a private data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
|
IGUIDList | 2.0 |
| Tag | Type | Max length | Implementation | Required |
|---|---|---|---|---|
IResponse
Queries for the specified sales order or set of sales orders.
|
2.1 | |||
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 |
ISalesOrderRetList | |||
(List
of ISalesOrderRet 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 | ||
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 transaction. In some cases, if you leave TxnDate out of an -Add message, QuickBooks will prefill TxnDate with the date of the last-saved transaction of the same type.
|
IQBDateType | Y | ||
RefNumber
A string of characters that refers to this transaction and that can be arbitrarily changed by the QuickBooks user. In a BillPaymentCheckAdd request, if you want to set the check number, use RefNumber.Note (especially relevant to CheckAdd requests): When RefNumber is left blank in an SDK transaction add request (that is, or ), the RefNumber will be left blank in QuickBooks. This behavior is new as of QBFC3. It used to select the next sequential reference number since the last one used by QuickBooks, as though no RefNumber had been provided. This is especially relevant to CheckAdd requests because with the current behavior, you will not know the number until the check is printed.
|
IQBStringType | 11 chars | ||
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 | ||
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
The date on which payment is due.
|
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 the amounts in all the lines of an invoice, estimate, sales receipt, or credit memo before taxes or payments 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 | |||
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 | |||
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 | ||
TotalAmountInHomeCurrency
Total amount of money paid or received in the home currency.
|
IQBAmountType | 8.0 | ||
IsManuallyClosed
If IsManuallyClosed is true, this sales order has been closed, even if some line items within it have not been invoiced.
|
IQBBoolType | |||
IsFullyInvoiced
If IsFullyInvoiced is true, all the items in the sales order have been invoiced.
|
IQBBoolType | |||
Memo
Additional information.
|
IQBStringType | 4095 chars | ||
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 | ||
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 | |||
(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 | ||
ORSalesOrderLineRetList |
IORSalesOrderLineRetList | |||
(List
of IORSalesOrderLineRet Objects)
|
||||
SalesOrderLineRet
Represents one line in the sales order. Compare with SalesOrderLineGroup, which represents a previously defined group of lines in the sales order.
|
ISalesOrderLineRet | |||
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 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 |
|
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 | ||
Invoiced
The amount of this sales order line that has been invoiced.
|
IQBQuanType | |||
IsManuallyClosed
If IsManuallyClosed is true, this line of the sales order has been closed even if it has not been invoiced.
|
IQBBoolType | |||
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 | |||
(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 | ||
SalesOrderLineGroupRet
Represents a previously defined group of lines in the sales order. Compare with SalesOrderLine, which represents just one line in the sales order.
|
ISalesOrderLineGroupRet | |||
TxnLineID
Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
|
IQBIDType | 3.0 | Y | |
ItemGroupRef
ItemGroup objects represent items that are grouped together for fast entry, and an ItemGroupRef aggregate refers to one of these item groups. In a request, if an ItemGroupRef aggregate includes both FullName and ListID, FullName will be ignored. You can use an ItemGroupQuery request to get information about all the item groups that are set up in the QuickBooks file.
|
IQBBaseRef | Y | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | ||
Desc
A descriptive text field.
|
IQBStringType | 4095 chars | ||
Quantity
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 | ||
SalesOrderLineRetList
A list of SalesOrderLineRet objects, each representing one line in the sales order.
|
ISalesOrderLineRetList | |||
(List
of ISalesOrderLineRet 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 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 |
|
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 | ||
Invoiced
The amount of this sales order line that has been invoiced.
|
IQBQuanType | |||
IsManuallyClosed
If IsManuallyClosed is true, this line of the sales order has been closed even if it has not been invoiced.
|
IQBBoolType | |||
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 | |||
(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 | |||
(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 | |||
(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 | ||
FulfillmentStatus
The Sales order Fulfillment Status details.
|
IQBEnumType | 16.0 | ||
ShippingDetails |
IQBEnumType | 16.0 | ||
ShippingDetailsLineRet
Represents one Line in Sales Order Tracking Details.
|
IShippingDetailsLineRet | 16.0 | ||
TrackingID
The Tracking ID of Sales order which is already shipped.
|
IQBIDType | 16.0 | ||
CarrierName
The Carries Name of Sales Order which is already shipped.
|
IQBStringType | 16.0 | ||
ShippingMethod
The Shipping Method of Sales Order which is already shipped.
|
IQBStringType | 16.0 | ||
ShippingCharges
The Shipping Charges of Sales Order which is already shipped.
|
IQBAmountType | 16.0 | ||
SOChannel
|
IQBEnumType | 16.0 | ||
StoreName
|
IQBStringType | 16.0 | ||
StoreType
|
IQBStringType | 16.0 |
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 | <?xml version="1.0" encoding="utf-8"?> <?qbxml version="17.0"?> <QBXML> <QBXMLMsgsRq onError="stopOnError"> <SalesOrderQueryRq 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> <!-- BEGIN OR --> <RefNumberFilter> <!-- optional --> <!-- MatchCriterion may have one of the following values: StartsWith, Contains, EndsWith --> <MatchCriterion >ENUMTYPE</MatchCriterion> <!-- required --> <RefNumber >STRTYPE</RefNumber> <!-- required --> </RefNumberFilter> <!-- OR --> <RefNumberRangeFilter> <!-- optional --> <FromRefNumber >STRTYPE</FromRefNumber> <!-- optional --> <ToRefNumber >STRTYPE</ToRefNumber> <!-- optional --> </RefNumberRangeFilter> <!-- END OR --> <CurrencyFilter> <!-- optional --> <!-- BEGIN OR --> <ListID >IDTYPE</ListID> <!-- optional, may repeat --> <!-- OR --> <FullName >STRTYPE</FullName> <!-- optional, may repeat --> <!-- END OR --> </CurrencyFilter> <!-- END OR --> <IncludeLineItems >BOOLTYPE</IncludeLineItems> <!-- optional --> <IncludeLinkedTxns >BOOLTYPE</IncludeLinkedTxns> <!-- optional --> <IncludeRetElement >STRTYPE</IncludeRetElement> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional, may repeat --> </SalesOrderQueryRq> <SalesOrderQueryRs statusCode="INTTYPE" statusSeverity="STRTYPE" statusMessage="STRTYPE" retCount="INTTYPE" iteratorRemainingCount="INTTYPE" iteratorID="UUIDTYPE"> <SalesOrderRet> <!-- 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> <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> <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 --> <TotalAmount >AMTTYPE</TotalAmount> <!-- optional --> <CurrencyRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </CurrencyRef> <ExchangeRate >FLOATTYPE</ExchangeRate> <!-- optional --> <TotalAmountInHomeCurrency >AMTTYPE</TotalAmountInHomeCurrency> <!-- optional --> <IsManuallyClosed >BOOLTYPE</IsManuallyClosed> <!-- optional --> <IsFullyInvoiced >BOOLTYPE</IsFullyInvoiced> <!-- optional --> <Memo >STRTYPE</Memo> <!-- 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> <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 --> <SalesOrderLineRet> <!-- 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 --> <SalesTaxCodeRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </SalesTaxCodeRef> <Invoiced >QUANTYPE</Invoiced> <!-- optional --> <IsManuallyClosed >BOOLTYPE</IsManuallyClosed> <!-- optional --> <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> </SalesOrderLineRet> <!-- OR --> <SalesOrderLineGroupRet> <!-- 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 --> <SalesOrderLineRet> <!-- 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 --> <SalesTaxCodeRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </SalesTaxCodeRef> <Invoiced >QUANTYPE</Invoiced> <!-- optional --> <IsManuallyClosed >BOOLTYPE</IsManuallyClosed> <!-- optional --> <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> </SalesOrderLineRet> <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> </SalesOrderLineGroupRet> <!-- 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> <FulfillmentStatus>ENUMTYPE</FulfillmentStatus> <!-- optional --> <ShippingDetails> <!-- optional --> <ShippingDetailsLineRet> <!-- optional --> <TrackingID>IDTYPE</TrackingID> <!-- optional --> <CarrierName>STRTYPE</CarrierName> <!-- optional --> <ShippingMethod>STRTYPE</ShippingMethod> <!-- optional --> <ShippingCharges>AMTTYPE</ShippingCharges> <!-- optional --> </ShippingDetailsLineRet> </ShippingDetails> <SOChannel>ENUMTYPE</SOChannel> <!-- optional --> <StoreName>STRTYPE</StoreName> <!-- optional --> <StoreType>STRTYPE</StoreType> <!-- optional --> </SalesOrderRet> </SalesOrderQueryRs> </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 | '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 DoSalesOrderQuery()
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
BuildSalesOrderQueryRq(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
WalkSalesOrderQueryRs(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 BuildSalesOrderQueryRq(requestMsgSet as IMsgSetRequest)
Dim SalesOrderQueryRq as ISalesOrderQuery
SalesOrderQueryRq= requestMsgSet.AppendSalesOrderQueryRq()
Dim ORTxnNoAccountQueryElementType19894 as String
ORTxnNoAccountQueryElementType19894 = "TxnIDList"
if (ORTxnNoAccountQueryElementType19894 == "TxnIDList") then
'Set field value for TxnIDList
'May create more than one of these if needed
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnIDList.Add("200000-1011023419")
End If
if (ORTxnNoAccountQueryElementType19894 == "RefNumberList") then
'Set field value for RefNumberList
'May create more than one of these if needed
SalesOrderQueryRq.ORTxnNoAccountQuery.RefNumberList.Add("ab")
End If
if (ORTxnNoAccountQueryElementType19894 == "RefNumberCaseSensitiveList") then
'Set field value for RefNumberCaseSensitiveList
'May create more than one of these if needed
SalesOrderQueryRq.ORTxnNoAccountQuery.RefNumberCaseSensitiveList.Add("ab")
End If
if (ORTxnNoAccountQueryElementType19894 == "TxnFilterNoAccount") then
'Set field value for MaxReturned
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.MaxReturned.SetValue(6)
Dim ORDateRangeFilterElementType19895 as String
ORDateRangeFilterElementType19895 = "ModifiedDateRangeFilter"
if (ORDateRangeFilterElementType19895 == "ModifiedDateRangeFilter") then
'Set field value for FromModifiedDate
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
'Set field value for ToModifiedDate
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
End If
if (ORDateRangeFilterElementType19895 == "TxnDateRangeFilter") then
Dim ORTxnDateRangeFilterElementType19896 as String
ORTxnDateRangeFilterElementType19896 = "TxnDateFilter"
if (ORTxnDateRangeFilterElementType19896 == "TxnDateFilter") then
'Set field value for FromTxnDate
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007"))
'Set field value for ToTxnDate
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007"))
End If
if (ORTxnDateRangeFilterElementType19896 == "DateMacro") then
'Set field value for DateMacro
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll)
End If
End If
Dim OREntityFilterElementType19897 as String
OREntityFilterElementType19897 = "ListIDList"
if (OREntityFilterElementType19897 == "ListIDList") then
'Set field value for ListIDList
'May create more than one of these if needed
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.EntityFilter.OREntityFilter.ListIDList.Add("200000-1011023419")
End If
if (OREntityFilterElementType19897 == "FullNameList") then
'Set field value for FullNameList
'May create more than one of these if needed
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.EntityFilter.OREntityFilter.FullNameList.Add("ab")
End If
if (OREntityFilterElementType19897 == "ListIDWithChildren") then
'Set field value for ListIDWithChildren
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.EntityFilter.OREntityFilter.ListIDWithChildren.SetValue("200000-1011023419")
End If
if (OREntityFilterElementType19897 == "FullNameWithChildren") then
'Set field value for FullNameWithChildren
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.EntityFilter.OREntityFilter.FullNameWithChildren.SetValue("ab")
End If
Dim ORRefNumberFilterElementType19898 as String
ORRefNumberFilterElementType19898 = "RefNumberFilter"
if (ORRefNumberFilterElementType19898 == "RefNumberFilter") then
'Set field value for MatchCriterion
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORRefNumberFilter.RefNumberFilter.MatchCriterion.SetValue(ENMatchCriterion.mcStartsWith)
'Set field value for RefNumber
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORRefNumberFilter.RefNumberFilter.RefNumber.SetValue("ab")
End If
if (ORRefNumberFilterElementType19898 == "RefNumberRangeFilter") then
'Set field value for FromRefNumber
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORRefNumberFilter.RefNumberRangeFilter.FromRefNumber.SetValue("ab")
'Set field value for ToRefNumber
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORRefNumberFilter.RefNumberRangeFilter.ToRefNumber.SetValue("ab")
End If
Dim ORCurrencyFilterElementType19899 as String
ORCurrencyFilterElementType19899 = "ListIDList"
if (ORCurrencyFilterElementType19899 == "ListIDList") then
'Set field value for ListIDList
'May create more than one of these if needed
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.CurrencyFilter.ORCurrencyFilter.ListIDList.Add("200000-1011023419")
End If
if (ORCurrencyFilterElementType19899 == "FullNameList") then
'Set field value for FullNameList
'May create more than one of these if needed
SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.CurrencyFilter.ORCurrencyFilter.FullNameList.Add("ab")
End If
End If
'Set field value for IncludeLineItems
SalesOrderQueryRq.IncludeLineItems.SetValue(True)
'Set field value for IncludeLinkedTxns
SalesOrderQueryRq.IncludeLinkedTxns.SetValue(True)
'Set field value for IncludeRetElementList
'May create more than one of these if needed
SalesOrderQueryRq.IncludeRetElementList.Add("ab")
'Set field value for OwnerIDList
'May create more than one of these if needed
SalesOrderQueryRq.OwnerIDList.Add(System.Guid.NewGuid().ToString())
End Sub
Public Sub WalkSalesOrderQueryRs( 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.rtSalesOrderQueryRs) then
'upcast to more specific type here, this is safe because we checked with response.Type check above
Dim SalesOrderRet as ISalesOrderRetList
SalesOrderRet = CType(response.Detail,ISalesOrderRetList)
WalkSalesOrderRet(SalesOrderRet)
End If
End If
End If
Next j
End Sub
Public Sub WalkSalesOrderRet(SalesOrderRet as ISalesOrderRetList)
if (SalesOrderRet is nothing) then
Exit Sub
End If
'Go through all the elements of ISalesOrderRetList
'Get value of TxnID
Dim TxnID19900 as String
TxnID19900 = SalesOrderRet.TxnID.GetValue()
'Get value of TimeCreated
Dim TimeCreated19901 as DateTime
TimeCreated19901 = SalesOrderRet.TimeCreated.GetValue()
'Get value of TimeModified
Dim TimeModified19902 as DateTime
TimeModified19902 = SalesOrderRet.TimeModified.GetValue()
'Get value of EditSequence
Dim EditSequence19903 as String
EditSequence19903 = SalesOrderRet.EditSequence.GetValue()
'Get value of TxnNumber
if ( not SalesOrderRet.TxnNumber is nothing) then
Dim TxnNumber19904 as Integer
TxnNumber19904 = SalesOrderRet.TxnNumber.GetValue()
End If
'Get value of ListID
if ( not SalesOrderRet.CustomerRef.ListID is nothing) then
Dim ListID19905 as String
ListID19905 = SalesOrderRet.CustomerRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderRet.CustomerRef.FullName is nothing) then
Dim FullName19906 as String
FullName19906 = SalesOrderRet.CustomerRef.FullName.GetValue()
End If
if (not SalesOrderRet.ClassRef. is nothing) then
'Get value of ListID
if ( not SalesOrderRet.ClassRef.ListID is nothing) then
Dim ListID19907 as String
ListID19907 = SalesOrderRet.ClassRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderRet.ClassRef.FullName is nothing) then
Dim FullName19908 as String
FullName19908 = SalesOrderRet.ClassRef.FullName.GetValue()
End If
End If
if (not SalesOrderRet.TemplateRef. is nothing) then
'Get value of ListID
if ( not SalesOrderRet.TemplateRef.ListID is nothing) then
Dim ListID19909 as String
ListID19909 = SalesOrderRet.TemplateRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderRet.TemplateRef.FullName is nothing) then
Dim FullName19910 as String
FullName19910 = SalesOrderRet.TemplateRef.FullName.GetValue()
End If
End If
'Get value of TxnDate
Dim TxnDate19911 as DateTime
TxnDate19911 = SalesOrderRet.TxnDate.GetValue()
'Get value of RefNumber
if ( not SalesOrderRet.RefNumber is nothing) then
Dim RefNumber19912 as String
RefNumber19912 = SalesOrderRet.RefNumber.GetValue()
End If
if (not SalesOrderRet.BillAddress. is nothing) then
'Get value of Addr1
if ( not SalesOrderRet.BillAddress.Addr1 is nothing) then
Dim Addr119913 as String
Addr119913 = SalesOrderRet.BillAddress.Addr1.GetValue()
End If
'Get value of Addr2
if ( not SalesOrderRet.BillAddress.Addr2 is nothing) then
Dim Addr219914 as String
Addr219914 = SalesOrderRet.BillAddress.Addr2.GetValue()
End If
'Get value of Addr3
if ( not SalesOrderRet.BillAddress.Addr3 is nothing) then
Dim Addr319915 as String
Addr319915 = SalesOrderRet.BillAddress.Addr3.GetValue()
End If
'Get value of Addr4
if ( not SalesOrderRet.BillAddress.Addr4 is nothing) then
Dim Addr419916 as String
Addr419916 = SalesOrderRet.BillAddress.Addr4.GetValue()
End If
'Get value of Addr5
if ( not SalesOrderRet.BillAddress.Addr5 is nothing) then
Dim Addr519917 as String
Addr519917 = SalesOrderRet.BillAddress.Addr5.GetValue()
End If
'Get value of City
if ( not SalesOrderRet.BillAddress.City is nothing) then
Dim City19918 as String
City19918 = SalesOrderRet.BillAddress.City.GetValue()
End If
'Get value of State
if ( not SalesOrderRet.BillAddress.State is nothing) then
Dim State19919 as String
State19919 = SalesOrderRet.BillAddress.State.GetValue()
End If
'Get value of PostalCode
if ( not SalesOrderRet.BillAddress.PostalCode is nothing) then
Dim PostalCode19920 as String
PostalCode19920 = SalesOrderRet.BillAddress.PostalCode.GetValue()
End If
'Get value of Country
if ( not SalesOrderRet.BillAddress.Country is nothing) then
Dim Country19921 as String
Country19921 = SalesOrderRet.BillAddress.Country.GetValue()
End If
'Get value of Note
if ( not SalesOrderRet.BillAddress.Note is nothing) then
Dim Note19922 as String
Note19922 = SalesOrderRet.BillAddress.Note.GetValue()
End If
End If
if (not SalesOrderRet.BillAddressBlock. is nothing) then
'Get value of Addr1
if ( not SalesOrderRet.BillAddressBlock.Addr1 is nothing) then
Dim Addr119923 as String
Addr119923 = SalesOrderRet.BillAddressBlock.Addr1.GetValue()
End If
'Get value of Addr2
if ( not SalesOrderRet.BillAddressBlock.Addr2 is nothing) then
Dim Addr219924 as String
Addr219924 = SalesOrderRet.BillAddressBlock.Addr2.GetValue()
End If
'Get value of Addr3
if ( not SalesOrderRet.BillAddressBlock.Addr3 is nothing) then
Dim Addr319925 as String
Addr319925 = SalesOrderRet.BillAddressBlock.Addr3.GetValue()
End If
'Get value of Addr4
if ( not SalesOrderRet.BillAddressBlock.Addr4 is nothing) then
Dim Addr419926 as String
Addr419926 = SalesOrderRet.BillAddressBlock.Addr4.GetValue()
End If
'Get value of Addr5
if ( not SalesOrderRet.BillAddressBlock.Addr5 is nothing) then
Dim Addr519927 as String
Addr519927 = SalesOrderRet.BillAddressBlock.Addr5.GetValue()
End If
End If
if (not SalesOrderRet.ShipAddress. is nothing) then
'Get value of Addr1
if ( not SalesOrderRet.ShipAddress.Addr1 is nothing) then
Dim Addr119928 as String
Addr119928 = SalesOrderRet.ShipAddress.Addr1.GetValue()
End If
'Get value of Addr2
if ( not SalesOrderRet.ShipAddress.Addr2 is nothing) then
Dim Addr219929 as String
Addr219929 = SalesOrderRet.ShipAddress.Addr2.GetValue()
End If
'Get value of Addr3
if ( not SalesOrderRet.ShipAddress.Addr3 is nothing) then
Dim Addr319930 as String
Addr319930 = SalesOrderRet.ShipAddress.Addr3.GetValue()
End If
'Get value of Addr4
if ( not SalesOrderRet.ShipAddress.Addr4 is nothing) then
Dim Addr419931 as String
Addr419931 = SalesOrderRet.ShipAddress.Addr4.GetValue()
End If
'Get value of Addr5
if ( not SalesOrderRet.ShipAddress.Addr5 is nothing) then
Dim Addr519932 as String
Addr519932 = SalesOrderRet.ShipAddress.Addr5.GetValue()
End If
'Get value of City
if ( not SalesOrderRet.ShipAddress.City is nothing) then
Dim City19933 as String
City19933 = SalesOrderRet.ShipAddress.City.GetValue()
End If
'Get value of State
if ( not SalesOrderRet.ShipAddress.State is nothing) then
Dim State19934 as String
State19934 = SalesOrderRet.ShipAddress.State.GetValue()
End If
'Get value of PostalCode
if ( not SalesOrderRet.ShipAddress.PostalCode is nothing) then
Dim PostalCode19935 as String
PostalCode19935 = SalesOrderRet.ShipAddress.PostalCode.GetValue()
End If
'Get value of Country
if ( not SalesOrderRet.ShipAddress.Country is nothing) then
Dim Country19936 as String
Country19936 = SalesOrderRet.ShipAddress.Country.GetValue()
End If
'Get value of Note
if ( not SalesOrderRet.ShipAddress.Note is nothing) then
Dim Note19937 as String
Note19937 = SalesOrderRet.ShipAddress.Note.GetValue()
End If
End If
if (not SalesOrderRet.ShipAddressBlock. is nothing) then
'Get value of Addr1
if ( not SalesOrderRet.ShipAddressBlock.Addr1 is nothing) then
Dim Addr119938 as String
Addr119938 = SalesOrderRet.ShipAddressBlock.Addr1.GetValue()
End If
'Get value of Addr2
if ( not SalesOrderRet.ShipAddressBlock.Addr2 is nothing) then
Dim Addr219939 as String
Addr219939 = SalesOrderRet.ShipAddressBlock.Addr2.GetValue()
End If
'Get value of Addr3
if ( not SalesOrderRet.ShipAddressBlock.Addr3 is nothing) then
Dim Addr319940 as String
Addr319940 = SalesOrderRet.ShipAddressBlock.Addr3.GetValue()
End If
'Get value of Addr4
if ( not SalesOrderRet.ShipAddressBlock.Addr4 is nothing) then
Dim Addr419941 as String
Addr419941 = SalesOrderRet.ShipAddressBlock.Addr4.GetValue()
End If
'Get value of Addr5
if ( not SalesOrderRet.ShipAddressBlock.Addr5 is nothing) then
Dim Addr519942 as String
Addr519942 = SalesOrderRet.ShipAddressBlock.Addr5.GetValue()
End If
End If
'Get value of PONumber
if ( not SalesOrderRet.PONumber is nothing) then
Dim PONumber19943 as String
PONumber19943 = SalesOrderRet.PONumber.GetValue()
End If
if (not SalesOrderRet.TermsRef. is nothing) then
'Get value of ListID
if ( not SalesOrderRet.TermsRef.ListID is nothing) then
Dim ListID19944 as String
ListID19944 = SalesOrderRet.TermsRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderRet.TermsRef.FullName is nothing) then
Dim FullName19945 as String
FullName19945 = SalesOrderRet.TermsRef.FullName.GetValue()
End If
End If
'Get value of DueDate
if ( not SalesOrderRet.DueDate is nothing) then
Dim DueDate19946 as DateTime
DueDate19946 = SalesOrderRet.DueDate.GetValue()
End If
if (not SalesOrderRet.SalesRepRef. is nothing) then
'Get value of ListID
if ( not SalesOrderRet.SalesRepRef.ListID is nothing) then
Dim ListID19947 as String
ListID19947 = SalesOrderRet.SalesRepRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderRet.SalesRepRef.FullName is nothing) then
Dim FullName19948 as String
FullName19948 = SalesOrderRet.SalesRepRef.FullName.GetValue()
End If
End If
'Get value of FOB
if ( not SalesOrderRet.FOB is nothing) then
Dim FOB19949 as String
FOB19949 = SalesOrderRet.FOB.GetValue()
End If
'Get value of ShipDate
if ( not SalesOrderRet.ShipDate is nothing) then
Dim ShipDate19950 as DateTime
ShipDate19950 = SalesOrderRet.ShipDate.GetValue()
End If
if (not SalesOrderRet.ShipMethodRef. is nothing) then
'Get value of ListID
if ( not SalesOrderRet.ShipMethodRef.ListID is nothing) then
Dim ListID19951 as String
ListID19951 = SalesOrderRet.ShipMethodRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderRet.ShipMethodRef.FullName is nothing) then
Dim FullName19952 as String
FullName19952 = SalesOrderRet.ShipMethodRef.FullName.GetValue()
End If
End If
'Get value of Subtotal
if ( not SalesOrderRet.Subtotal is nothing) then
Dim Subtotal19953 as Double
Subtotal19953 = SalesOrderRet.Subtotal.GetValue()
End If
if (not SalesOrderRet.ItemSalesTaxRef. is nothing) then
'Get value of ListID
if ( not SalesOrderRet.ItemSalesTaxRef.ListID is nothing) then
Dim ListID19954 as String
ListID19954 = SalesOrderRet.ItemSalesTaxRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderRet.ItemSalesTaxRef.FullName is nothing) then
Dim FullName19955 as String
FullName19955 = SalesOrderRet.ItemSalesTaxRef.FullName.GetValue()
End If
End If
'Get value of SalesTaxPercentage
if ( not SalesOrderRet.SalesTaxPercentage is nothing) then
Dim SalesTaxPercentage19956 as Double
SalesTaxPercentage19956 = SalesOrderRet.SalesTaxPercentage.GetValue()
End If
'Get value of SalesTaxTotal
if ( not SalesOrderRet.SalesTaxTotal is nothing) then
Dim SalesTaxTotal19957 as Double
SalesTaxTotal19957 = SalesOrderRet.SalesTaxTotal.GetValue()
End If
'Get value of TotalAmount
if ( not SalesOrderRet.TotalAmount is nothing) then
Dim TotalAmount19958 as Double
TotalAmount19958 = SalesOrderRet.TotalAmount.GetValue()
End If
if (not SalesOrderRet.CurrencyRef. is nothing) then
'Get value of ListID
if ( not SalesOrderRet.CurrencyRef.ListID is nothing) then
Dim ListID19959 as String
ListID19959 = SalesOrderRet.CurrencyRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderRet.CurrencyRef.FullName is nothing) then
Dim FullName19960 as String
FullName19960 = SalesOrderRet.CurrencyRef.FullName.GetValue()
End If
End If
'Get value of ExchangeRate
if ( not SalesOrderRet.ExchangeRate is nothing) then
Dim ExchangeRate19961 as IQBFloatType
ExchangeRate19961 = SalesOrderRet.ExchangeRate.GetValue()
End If
'Get value of TotalAmountInHomeCurrency
if ( not SalesOrderRet.TotalAmountInHomeCurrency is nothing) then
Dim TotalAmountInHomeCurrency19962 as Double
TotalAmountInHomeCurrency19962 = SalesOrderRet.TotalAmountInHomeCurrency.GetValue()
End If
'Get value of IsManuallyClosed
if ( not SalesOrderRet.IsManuallyClosed is nothing) then
Dim IsManuallyClosed19963 as Boolean
IsManuallyClosed19963 = SalesOrderRet.IsManuallyClosed.GetValue()
End If
'Get value of IsFullyInvoiced
if ( not SalesOrderRet.IsFullyInvoiced is nothing) then
Dim IsFullyInvoiced19964 as Boolean
IsFullyInvoiced19964 = SalesOrderRet.IsFullyInvoiced.GetValue()
End If
'Get value of Memo
if ( not SalesOrderRet.Memo is nothing) then
Dim Memo19965 as String
Memo19965 = SalesOrderRet.Memo.GetValue()
End If
if (not SalesOrderRet.CustomerMsgRef. is nothing) then
'Get value of ListID
if ( not SalesOrderRet.CustomerMsgRef.ListID is nothing) then
Dim ListID19966 as String
ListID19966 = SalesOrderRet.CustomerMsgRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderRet.CustomerMsgRef.FullName is nothing) then
Dim FullName19967 as String
FullName19967 = SalesOrderRet.CustomerMsgRef.FullName.GetValue()
End If
End If
'Get value of IsToBePrinted
if ( not SalesOrderRet.IsToBePrinted is nothing) then
Dim IsToBePrinted19968 as Boolean
IsToBePrinted19968 = SalesOrderRet.IsToBePrinted.GetValue()
End If
'Get value of IsToBeEmailed
if ( not SalesOrderRet.IsToBeEmailed is nothing) then
Dim IsToBeEmailed19969 as Boolean
IsToBeEmailed19969 = SalesOrderRet.IsToBeEmailed.GetValue()
End If
'Get value of IsTaxIncluded
if ( not SalesOrderRet.IsTaxIncluded is nothing) then
Dim IsTaxIncluded19970 as Boolean
IsTaxIncluded19970 = SalesOrderRet.IsTaxIncluded.GetValue()
End If
if (not SalesOrderRet.CustomerSalesTaxCodeRef. is nothing) then
'Get value of ListID
if ( not SalesOrderRet.CustomerSalesTaxCodeRef.ListID is nothing) then
Dim ListID19971 as String
ListID19971 = SalesOrderRet.CustomerSalesTaxCodeRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderRet.CustomerSalesTaxCodeRef.FullName is nothing) then
Dim FullName19972 as String
FullName19972 = SalesOrderRet.CustomerSalesTaxCodeRef.FullName.GetValue()
End If
End If
'Get value of Other
if ( not SalesOrderRet.Other is nothing) then
Dim Other19973 as String
Other19973 = SalesOrderRet.Other.GetValue()
End If
'Get value of ExternalGUID
if ( not SalesOrderRet.ExternalGUID is nothing) then
Dim ExternalGUID19974 as String
ExternalGUID19974 = SalesOrderRet.ExternalGUID.GetValue()
End If
if (not SalesOrderRet.LinkedTxnList is nothing)
Dim i19975 as Integer
for i19975 = 0 to SalesOrderRet.LinkedTxnList.Count - 1
Dim LinkedTxn as ILinkedTxn
LinkedTxn = SalesOrderRet.LinkedTxnList.GetAt(i19975)
'Get value of TxnID
Dim TxnID19976 as String
TxnID19976 = LinkedTxnTxnID.GetValue()
'Get value of TxnType
Dim TxnType19977 as ENTxnType
TxnType19977 = LinkedTxnTxnType.GetValue()
'Get value of TxnDate
Dim TxnDate19978 as DateTime
TxnDate19978 = LinkedTxnTxnDate.GetValue()
'Get value of RefNumber
if ( not LinkedTxnRefNumber is nothing) then
Dim RefNumber19979 as String
RefNumber19979 = LinkedTxnRefNumber.GetValue()
End If
'Get value of LinkType
if ( not LinkedTxnLinkType is nothing) then
Dim LinkType19980 as ENLinkType
LinkType19980 = LinkedTxnLinkType.GetValue()
End If
'Get value of Amount
Dim Amount19981 as Double
Amount19981 = LinkedTxnAmount.GetValue()
Next i19975
End If
if (not SalesOrderRet.ORSalesOrderLineRetList is nothing) then
Dim i19982 as Integer
for i19982 = 0 to SalesOrderRet.ORSalesOrderLineRetList.Count - 1
Dim ORSalesOrderLineRet19983 as IORSalesOrderLineRet
ORSalesOrderLineRet19983 = SalesOrderRet.ORSalesOrderLineRetList.GetAt(i19982)
if (not ORSalesOrderLineRet19983.SalesOrderLineRet is nothing) then
if (not ORSalesOrderLineRet19983.SalesOrderLineRet. is nothing) then
'Get value of TxnLineID
Dim TxnLineID19984 as String
TxnLineID19984 = ORSalesOrderLineRet19983.SalesOrderLineRet.TxnLineID.GetValue()
if (not ORSalesOrderLineRet19983.SalesOrderLineRet.ItemRef. is nothing) then
'Get value of ListID
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.ItemRef.ListID is nothing) then
Dim ListID19985 as String
ListID19985 = ORSalesOrderLineRet19983.SalesOrderLineRet.ItemRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.ItemRef.FullName is nothing) then
Dim FullName19986 as String
FullName19986 = ORSalesOrderLineRet19983.SalesOrderLineRet.ItemRef.FullName.GetValue()
End If
End If
'Get value of Desc
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.Desc is nothing) then
Dim Desc19987 as String
Desc19987 = ORSalesOrderLineRet19983.SalesOrderLineRet.Desc.GetValue()
End If
'Get value of Quantity
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.Quantity is nothing) then
Dim Quantity19988 as Integer
Quantity19988 = ORSalesOrderLineRet19983.SalesOrderLineRet.Quantity.GetValue()
End If
'Get value of UnitOfMeasure
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.UnitOfMeasure is nothing) then
Dim UnitOfMeasure19989 as String
UnitOfMeasure19989 = ORSalesOrderLineRet19983.SalesOrderLineRet.UnitOfMeasure.GetValue()
End If
if (not ORSalesOrderLineRet19983.SalesOrderLineRet.OverrideUOMSetRef. is nothing) then
'Get value of ListID
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.OverrideUOMSetRef.ListID is nothing) then
Dim ListID19990 as String
ListID19990 = ORSalesOrderLineRet19983.SalesOrderLineRet.OverrideUOMSetRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.OverrideUOMSetRef.FullName is nothing) then
Dim FullName19991 as String
FullName19991 = ORSalesOrderLineRet19983.SalesOrderLineRet.OverrideUOMSetRef.FullName.GetValue()
End If
End If
if (not ORSalesOrderLineRet19983.SalesOrderLineRet.ORRate is nothing) then
if (not ORSalesOrderLineRet19983.SalesOrderLineRet.ORRate.Rate is nothing) then
'Get value of Rate
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.ORRate.Rate is nothing) then
Dim Rate19993 as Double
Rate19993 = ORSalesOrderLineRet19983.SalesOrderLineRet.ORRate.Rate.GetValue()
End If
End If
if (not ORSalesOrderLineRet19983.SalesOrderLineRet.ORRate.RatePercent is nothing) then
'Get value of RatePercent
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.ORRate.RatePercent is nothing) then
Dim RatePercent19994 as Double
RatePercent19994 = ORSalesOrderLineRet19983.SalesOrderLineRet.ORRate.RatePercent.GetValue()
End If
End If
End If
if (not ORSalesOrderLineRet19983.SalesOrderLineRet.ClassRef. is nothing) then
'Get value of ListID
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.ClassRef.ListID is nothing) then
Dim ListID19995 as String
ListID19995 = ORSalesOrderLineRet19983.SalesOrderLineRet.ClassRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.ClassRef.FullName is nothing) then
Dim FullName19996 as String
FullName19996 = ORSalesOrderLineRet19983.SalesOrderLineRet.ClassRef.FullName.GetValue()
End If
End If
'Get value of Amount
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.Amount is nothing) then
Dim Amount19997 as Double
Amount19997 = ORSalesOrderLineRet19983.SalesOrderLineRet.Amount.GetValue()
End If
if (not ORSalesOrderLineRet19983.SalesOrderLineRet.InventorySiteRef. is nothing) then
'Get value of ListID
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.InventorySiteRef.ListID is nothing) then
Dim ListID19998 as String
ListID19998 = ORSalesOrderLineRet19983.SalesOrderLineRet.InventorySiteRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.InventorySiteRef.FullName is nothing) then
Dim FullName19999 as String
FullName19999 = ORSalesOrderLineRet19983.SalesOrderLineRet.InventorySiteRef.FullName.GetValue()
End If
End If
if (not ORSalesOrderLineRet19983.SalesOrderLineRet.InventorySiteLocationRef. is nothing) then
'Get value of ListID
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.InventorySiteLocationRef.ListID is nothing) then
Dim ListID20000 as String
ListID20000 = ORSalesOrderLineRet19983.SalesOrderLineRet.InventorySiteLocationRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.InventorySiteLocationRef.FullName is nothing) then
Dim FullName20001 as String
FullName20001 = ORSalesOrderLineRet19983.SalesOrderLineRet.InventorySiteLocationRef.FullName.GetValue()
End If
End If
if (not ORSalesOrderLineRet19983.SalesOrderLineRet.ORSerialLotNumber is nothing) then
if (not ORSalesOrderLineRet19983.SalesOrderLineRet.ORSerialLotNumber.SerialNumber is nothing) then
'Get value of SerialNumber
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.ORSerialLotNumber.SerialNumber is nothing) then
Dim SerialNumber20003 as String
SerialNumber20003 = ORSalesOrderLineRet19983.SalesOrderLineRet.ORSerialLotNumber.SerialNumber.GetValue()
End If
End If
if (not ORSalesOrderLineRet19983.SalesOrderLineRet.ORSerialLotNumber.LotNumber is nothing) then
'Get value of LotNumber
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.ORSerialLotNumber.LotNumber is nothing) then
Dim LotNumber20004 as String
LotNumber20004 = ORSalesOrderLineRet19983.SalesOrderLineRet.ORSerialLotNumber.LotNumber.GetValue()
End If
End If
End If
'Get value of ExpirationDateForSerialLotNumber
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.ExpirationDateForSerialLotNumber is nothing) then
Dim ExpDate as String
ExpDate = ORSalesOrderLineRet19983.SalesOrderLineRet.ExpirationDateForSerialLotNumber.GetValue()
End If
if (not ORSalesOrderLineRet19983.SalesOrderLineRet.SalesTaxCodeRef. is nothing) then
'Get value of ListID
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.SalesTaxCodeRef.ListID is nothing) then
Dim ListID20005 as String
ListID20005 = ORSalesOrderLineRet19983.SalesOrderLineRet.SalesTaxCodeRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.SalesTaxCodeRef.FullName is nothing) then
Dim FullName20006 as String
FullName20006 = ORSalesOrderLineRet19983.SalesOrderLineRet.SalesTaxCodeRef.FullName.GetValue()
End If
End If
'Get value of Invoiced
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.Invoiced is nothing) then
Dim Invoiced20007 as Integer
Invoiced20007 = ORSalesOrderLineRet19983.SalesOrderLineRet.Invoiced.GetValue()
End If
'Get value of IsManuallyClosed
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.IsManuallyClosed is nothing) then
Dim IsManuallyClosed20008 as Boolean
IsManuallyClosed20008 = ORSalesOrderLineRet19983.SalesOrderLineRet.IsManuallyClosed.GetValue()
End If
'Get value of Other1
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.Other1 is nothing) then
Dim Other120009 as String
Other120009 = ORSalesOrderLineRet19983.SalesOrderLineRet.Other1.GetValue()
End If
'Get value of Other2
if ( not ORSalesOrderLineRet19983.SalesOrderLineRet.Other2 is nothing) then
Dim Other220010 as String
Other220010 = ORSalesOrderLineRet19983.SalesOrderLineRet.Other2.GetValue()
End If
if (not ORSalesOrderLineRet19983.SalesOrderLineRet.DataExtRetList is nothing)
Dim i20011 as Integer
for i20011 = 0 to ORSalesOrderLineRet19983.SalesOrderLineRet.DataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = ORSalesOrderLineRet19983.SalesOrderLineRet.DataExtRetList.GetAt(i20011)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID20012 as String
OwnerID20012 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName20013 as String
DataExtName20013 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType20014 as ENDataExtType
DataExtType20014 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue20015 as String
DataExtValue20015 = DataExtRetDataExtValue.GetValue()
Next i20011
End If
End If
End If
if (not ORSalesOrderLineRet19983.SalesOrderLineGroupRet is nothing) then
if (not ORSalesOrderLineRet19983.SalesOrderLineGroupRet. is nothing) then
'Get value of TxnLineID
Dim TxnLineID20016 as String
TxnLineID20016 = ORSalesOrderLineRet19983.SalesOrderLineGroupRet.TxnLineID.GetValue()
'Get value of ListID
if ( not ORSalesOrderLineRet19983.SalesOrderLineGroupRet.ItemGroupRef.ListID is nothing) then
Dim ListID20017 as String
ListID20017 = ORSalesOrderLineRet19983.SalesOrderLineGroupRet.ItemGroupRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORSalesOrderLineRet19983.SalesOrderLineGroupRet.ItemGroupRef.FullName is nothing) then
Dim FullName20018 as String
FullName20018 = ORSalesOrderLineRet19983.SalesOrderLineGroupRet.ItemGroupRef.FullName.GetValue()
End If
'Get value of Desc
if ( not ORSalesOrderLineRet19983.SalesOrderLineGroupRet.Desc is nothing) then
Dim Desc20019 as String
Desc20019 = ORSalesOrderLineRet19983.SalesOrderLineGroupRet.Desc.GetValue()
End If
'Get value of Quantity
if ( not ORSalesOrderLineRet19983.SalesOrderLineGroupRet.Quantity is nothing) then
Dim Quantity20020 as Integer
Quantity20020 = ORSalesOrderLineRet19983.SalesOrderLineGroupRet.Quantity.GetValue()
End If
'Get value of UnitOfMeasure
if ( not ORSalesOrderLineRet19983.SalesOrderLineGroupRet.UnitOfMeasure is nothing) then
Dim UnitOfMeasure20021 as String
UnitOfMeasure20021 = ORSalesOrderLineRet19983.SalesOrderLineGroupRet.UnitOfMeasure.GetValue()
End If
if (not ORSalesOrderLineRet19983.SalesOrderLineGroupRet.OverrideUOMSetRef. is nothing) then
'Get value of ListID
if ( not ORSalesOrderLineRet19983.SalesOrderLineGroupRet.OverrideUOMSetRef.ListID is nothing) then
Dim ListID20022 as String
ListID20022 = ORSalesOrderLineRet19983.SalesOrderLineGroupRet.OverrideUOMSetRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORSalesOrderLineRet19983.SalesOrderLineGroupRet.OverrideUOMSetRef.FullName is nothing) then
Dim FullName20023 as String
FullName20023 = ORSalesOrderLineRet19983.SalesOrderLineGroupRet.OverrideUOMSetRef.FullName.GetValue()
End If
End If
'Get value of IsPrintItemsInGroup
Dim IsPrintItemsInGroup20024 as Boolean
IsPrintItemsInGroup20024 = ORSalesOrderLineRet19983.SalesOrderLineGroupRet.IsPrintItemsInGroup.GetValue()
'Get value of TotalAmount
Dim TotalAmount20025 as Double
TotalAmount20025 = ORSalesOrderLineRet19983.SalesOrderLineGroupRet.TotalAmount.GetValue()
if (not ORSalesOrderLineRet19983.SalesOrderLineGroupRet.SalesOrderLineRetList is nothing)
Dim i20026 as Integer
for i20026 = 0 to ORSalesOrderLineRet19983.SalesOrderLineGroupRet.SalesOrderLineRetList.Count - 1
Dim SalesOrderLineRet as ISalesOrderLineRet
SalesOrderLineRet = ORSalesOrderLineRet19983.SalesOrderLineGroupRet.SalesOrderLineRetList.GetAt(i20026)
'Get value of TxnLineID
Dim TxnLineID20027 as String
TxnLineID20027 = SalesOrderLineRetTxnLineID.GetValue()
if (not SalesOrderLineRetItemRef. is nothing) then
'Get value of ListID
if ( not SalesOrderLineRetItemRef.ListID is nothing) then
Dim ListID20028 as String
ListID20028 = SalesOrderLineRetItemRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderLineRetItemRef.FullName is nothing) then
Dim FullName20029 as String
FullName20029 = SalesOrderLineRetItemRef.FullName.GetValue()
End If
End If
'Get value of Desc
if ( not SalesOrderLineRetDesc is nothing) then
Dim Desc20030 as String
Desc20030 = SalesOrderLineRetDesc.GetValue()
End If
'Get value of Quantity
if ( not SalesOrderLineRetQuantity is nothing) then
Dim Quantity20031 as Integer
Quantity20031 = SalesOrderLineRetQuantity.GetValue()
End If
'Get value of UnitOfMeasure
if ( not SalesOrderLineRetUnitOfMeasure is nothing) then
Dim UnitOfMeasure20032 as String
UnitOfMeasure20032 = SalesOrderLineRetUnitOfMeasure.GetValue()
End If
if (not SalesOrderLineRetOverrideUOMSetRef. is nothing) then
'Get value of ListID
if ( not SalesOrderLineRetOverrideUOMSetRef.ListID is nothing) then
Dim ListID20033 as String
ListID20033 = SalesOrderLineRetOverrideUOMSetRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderLineRetOverrideUOMSetRef.FullName is nothing) then
Dim FullName20034 as String
FullName20034 = SalesOrderLineRetOverrideUOMSetRef.FullName.GetValue()
End If
End If
if (not SalesOrderLineRetORRate is nothing) then
if (not SalesOrderLineRetORRate.Rate is nothing) then
'Get value of Rate
if ( not SalesOrderLineRetORRate.Rate is nothing) then
Dim Rate20036 as Double
Rate20036 = SalesOrderLineRetORRate.Rate.GetValue()
End If
End If
if (not SalesOrderLineRetORRate.RatePercent is nothing) then
'Get value of RatePercent
if ( not SalesOrderLineRetORRate.RatePercent is nothing) then
Dim RatePercent20037 as Double
RatePercent20037 = SalesOrderLineRetORRate.RatePercent.GetValue()
End If
End If
End If
if (not SalesOrderLineRetClassRef. is nothing) then
'Get value of ListID
if ( not SalesOrderLineRetClassRef.ListID is nothing) then
Dim ListID20038 as String
ListID20038 = SalesOrderLineRetClassRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderLineRetClassRef.FullName is nothing) then
Dim FullName20039 as String
FullName20039 = SalesOrderLineRetClassRef.FullName.GetValue()
End If
End If
'Get value of Amount
if ( not SalesOrderLineRetAmount is nothing) then
Dim Amount20040 as Double
Amount20040 = SalesOrderLineRetAmount.GetValue()
End If
if (not SalesOrderLineRetInventorySiteRef. is nothing) then
'Get value of ListID
if ( not SalesOrderLineRetInventorySiteRef.ListID is nothing) then
Dim ListID20041 as String
ListID20041 = SalesOrderLineRetInventorySiteRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderLineRetInventorySiteRef.FullName is nothing) then
Dim FullName20042 as String
FullName20042 = SalesOrderLineRetInventorySiteRef.FullName.GetValue()
End If
End If
if (not SalesOrderLineRetInventorySiteLocationRef. is nothing) then
'Get value of ListID
if ( not SalesOrderLineRetInventorySiteLocationRef.ListID is nothing) then
Dim ListID20043 as String
ListID20043 = SalesOrderLineRetInventorySiteLocationRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderLineRetInventorySiteLocationRef.FullName is nothing) then
Dim FullName20044 as String
FullName20044 = SalesOrderLineRetInventorySiteLocationRef.FullName.GetValue()
End If
End If
if (not SalesOrderLineRetORSerialLotNumber is nothing) then
if (not SalesOrderLineRetORSerialLotNumber.SerialNumber is nothing) then
'Get value of SerialNumber
if ( not SalesOrderLineRetORSerialLotNumber.SerialNumber is nothing) then
Dim SerialNumber20046 as String
SerialNumber20046 = SalesOrderLineRetORSerialLotNumber.SerialNumber.GetValue()
End If
End If
if (not SalesOrderLineRetORSerialLotNumber.LotNumber is nothing) then
'Get value of LotNumber
if ( not SalesOrderLineRetORSerialLotNumber.LotNumber is nothing) then
Dim LotNumber20047 as String
LotNumber20047 = SalesOrderLineRetORSerialLotNumber.LotNumber.GetValue()
End If
End If
End If
'Get value of ExpirationDateForSerialLotNumber
if ( not SalesOrderLineRetExpirationDateForSerialLotNumber is nothing) then
Dim ExpDate as String
ExpDate = SalesOrderLineRetExpirationDateForSerialLotNumber.GetValue()
End If
if (not SalesOrderLineRetSalesTaxCodeRef. is nothing) then
'Get value of ListID
if ( not SalesOrderLineRetSalesTaxCodeRef.ListID is nothing) then
Dim ListID20048 as String
ListID20048 = SalesOrderLineRetSalesTaxCodeRef.ListID.GetValue()
End If
'Get value of FullName
if ( not SalesOrderLineRetSalesTaxCodeRef.FullName is nothing) then
Dim FullName20049 as String
FullName20049 = SalesOrderLineRetSalesTaxCodeRef.FullName.GetValue()
End If
End If
'Get value of Invoiced
if ( not SalesOrderLineRetInvoiced is nothing) then
Dim Invoiced20050 as Integer
Invoiced20050 = SalesOrderLineRetInvoiced.GetValue()
End If
'Get value of IsManuallyClosed
if ( not SalesOrderLineRetIsManuallyClosed is nothing) then
Dim IsManuallyClosed20051 as Boolean
IsManuallyClosed20051 = SalesOrderLineRetIsManuallyClosed.GetValue()
End If
'Get value of Other1
if ( not SalesOrderLineRetOther1 is nothing) then
Dim Other120052 as String
Other120052 = SalesOrderLineRetOther1.GetValue()
End If
'Get value of Other2
if ( not SalesOrderLineRetOther2 is nothing) then
Dim Other220053 as String
Other220053 = SalesOrderLineRetOther2.GetValue()
End If
if (not SalesOrderLineRetDataExtRetList is nothing)
Dim i20054 as Integer
for i20054 = 0 to SalesOrderLineRetDataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = SalesOrderLineRetDataExtRetList.GetAt(i20054)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID20055 as String
OwnerID20055 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName20056 as String
DataExtName20056 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType20057 as ENDataExtType
DataExtType20057 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue20058 as String
DataExtValue20058 = DataExtRetDataExtValue.GetValue()
Next i20054
End If
Next i20026
End If
if (not ORSalesOrderLineRet19983.SalesOrderLineGroupRet.DataExtRetList is nothing)
Dim i20059 as Integer
for i20059 = 0 to ORSalesOrderLineRet19983.SalesOrderLineGroupRet.DataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = ORSalesOrderLineRet19983.SalesOrderLineGroupRet.DataExtRetList.GetAt(i20059)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID20060 as String
OwnerID20060 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName20061 as String
DataExtName20061 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType20062 as ENDataExtType
DataExtType20062 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue20063 as String
DataExtValue20063 = DataExtRetDataExtValue.GetValue()
Next i20059
End If
End If
End If
Next i19982
End If
if (not SalesOrderRet.DataExtRetList is nothing)
Dim i20064 as Integer
for i20064 = 0 to SalesOrderRet.DataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = SalesOrderRet.DataExtRetList.GetAt(i20064)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID20065 as String
OwnerID20065 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName20066 as String
DataExtName20066 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType20067 as ENDataExtType
DataExtType20067 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue20068 as String
DataExtValue20068 = DataExtRetDataExtValue.GetValue()
Next i20064
End If
if (not SalesOrderRet.FulfillmentStatus is nothing) then
Dim fulfillmentStatus20069 as String
fulfillmentStatus20069 = SalesOrderLineRetClassRef.FulfillmentStatus.GetValue();
End If
if (not SalesOrderRet.ShippingDetails is nothing) then
if (not SalesOrderRet.ShippingDetails.ShippingDetailsLineRetList is nothing)
Dim k20070 as Integer
for k20070 = 0 to SalesOrderRet.ShippingDetails.ShippingDetailsLineRetList.Count - 1
Dim ShippingDetailsLineRet as IShippingDetailsLineRet
ShippingDetailsLineRet = SalesOrderRet.ShippingDetails.ShippingDetailsLineRetList.GetAt(k20070);
Dim trackingID20071 as String;
trackingID20071 = ShippingDetailsLineRet.TrackingID.GetValue();
Dim carrierName20072 as String;
carrierName20072 = (string)ShippingDetailsLineRet.CarrierName.GetValue();
Dim shippingMethod20073 as String;
shippingMethod20073 = (string)ShippingDetailsLineRet.ShippingMethod.GetValue();
Dim shippingCharges20074 as Double;
shippingCharges20074 = (double)ShippingDetailsLineRet.ShippingCharges.GetValue();
Next k20070
End If
if (not SalesOrderRet.SOChannel s nothing) then
Dim SOChannel20075 as String;
SOChannel20075 = SalesOrderRet.SOChannel.GetAsString();
End If
if (not SalesOrderRet.StoreName s nothing) then
Dim StoreName20076 as String;
string StoreName20076 = SalesOrderRet.StoreName.GetValue();
End If
if (not SalesOrderRet.StoreType s nothing) then
Dim StoreType20077 as String;
StoreType20077 = SalesOrderRet.StoreType.GetValue();
End If
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 | //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 DoSalesOrderQuery() { 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; BuildSalesOrderQueryRq(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; WalkSalesOrderQueryRs(responseMsgSet); } catch (Exception e) { MessageBox.Show(e.Message, "Error"); if (sessionBegun) { sessionManager.EndSession(); } if (connectionOpen) { sessionManager.CloseConnection(); } } } void BuildSalesOrderQueryRq(IMsgSetRequest requestMsgSet) { ISalesOrderQuery SalesOrderQueryRq= requestMsgSet.AppendSalesOrderQueryRq(); //Set attributes //Set field value for metaData SalesOrderQueryRq.metaData.SetValue("IQBENmetaDataType"); //Set field value for iterator SalesOrderQueryRq.iterator.SetValue("IQBENiteratorType"); //Set field value for iteratorID SalesOrderQueryRq.iteratorID.SetValue("IQBUUIDType"); string ORTxnNoAccountQueryElementType19719 = "TxnIDList"; if (ORTxnNoAccountQueryElementType19719 == "TxnIDList") { //Set field value for TxnIDList //May create more than one of these if needed SalesOrderQueryRq.ORTxnNoAccountQuery.TxnIDList.Add("200000-1011023419"); } if (ORTxnNoAccountQueryElementType19719 == "RefNumberList") { //Set field value for RefNumberList //May create more than one of these if needed SalesOrderQueryRq.ORTxnNoAccountQuery.RefNumberList.Add("ab"); } if (ORTxnNoAccountQueryElementType19719 == "RefNumberCaseSensitiveList") { //Set field value for RefNumberCaseSensitiveList //May create more than one of these if needed SalesOrderQueryRq.ORTxnNoAccountQuery.RefNumberCaseSensitiveList.Add("ab"); } if (ORTxnNoAccountQueryElementType19719 == "TxnFilterNoAccount") { //Set field value for MaxReturned SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.MaxReturned.SetValue(6); string ORDateRangeFilterElementType19720 = "ModifiedDateRangeFilter"; if (ORDateRangeFilterElementType19720 == "ModifiedDateRangeFilter") { //Set field value for FromModifiedDate SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); //Set field value for ToModifiedDate SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); } if (ORDateRangeFilterElementType19720 == "TxnDateRangeFilter") { string ORTxnDateRangeFilterElementType19721 = "TxnDateFilter"; if (ORTxnDateRangeFilterElementType19721 == "TxnDateFilter") { //Set field value for FromTxnDate SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007")); //Set field value for ToTxnDate SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007")); } if (ORTxnDateRangeFilterElementType19721 == "DateMacro") { //Set field value for DateMacro SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll); } } string OREntityFilterElementType19722 = "ListIDList"; if (OREntityFilterElementType19722 == "ListIDList") { //Set field value for ListIDList //May create more than one of these if needed SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.EntityFilter.OREntityFilter.ListIDList.Add("200000-1011023419"); } if (OREntityFilterElementType19722 == "FullNameList") { //Set field value for FullNameList //May create more than one of these if needed SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.EntityFilter.OREntityFilter.FullNameList.Add("ab"); } if (OREntityFilterElementType19722 == "ListIDWithChildren") { //Set field value for ListIDWithChildren SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.EntityFilter.OREntityFilter.ListIDWithChildren.SetValue("200000-1011023419"); } if (OREntityFilterElementType19722 == "FullNameWithChildren") { //Set field value for FullNameWithChildren SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.EntityFilter.OREntityFilter.FullNameWithChildren.SetValue("ab"); } string ORRefNumberFilterElementType19723 = "RefNumberFilter"; if (ORRefNumberFilterElementType19723 == "RefNumberFilter") { //Set field value for MatchCriterion SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORRefNumberFilter.RefNumberFilter.MatchCriterion.SetValue(ENMatchCriterion.mcStartsWith); //Set field value for RefNumber SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORRefNumberFilter.RefNumberFilter.RefNumber.SetValue("ab"); } if (ORRefNumberFilterElementType19723 == "RefNumberRangeFilter") { //Set field value for FromRefNumber SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORRefNumberFilter.RefNumberRangeFilter.FromRefNumber.SetValue("ab"); //Set field value for ToRefNumber SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.ORRefNumberFilter.RefNumberRangeFilter.ToRefNumber.SetValue("ab"); } string ORCurrencyFilterElementType19724 = "ListIDList"; if (ORCurrencyFilterElementType19724 == "ListIDList") { //Set field value for ListIDList //May create more than one of these if needed SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.CurrencyFilter.ORCurrencyFilter.ListIDList.Add("200000-1011023419"); } if (ORCurrencyFilterElementType19724 == "FullNameList") { //Set field value for FullNameList //May create more than one of these if needed SalesOrderQueryRq.ORTxnNoAccountQuery.TxnFilterNoAccount.CurrencyFilter.ORCurrencyFilter.FullNameList.Add("ab"); } } //Set field value for IncludeLineItems SalesOrderQueryRq.IncludeLineItems.SetValue(true); //Set field value for IncludeLinkedTxns SalesOrderQueryRq.IncludeLinkedTxns.SetValue(true); //Set field value for IncludeRetElementList //May create more than one of these if needed SalesOrderQueryRq.IncludeRetElementList.Add("ab"); //Set field value for OwnerIDList //May create more than one of these if needed SalesOrderQueryRq.OwnerIDList.Add(Guid.NewGuid().ToString()); } void WalkSalesOrderQueryRs(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.rtSalesOrderQueryRs) { //upcast to more specific type here, this is safe because we checked with response.Type check above ISalesOrderRetList SalesOrderRet = (ISalesOrderRetList)response.Detail; WalkSalesOrderRet(SalesOrderRet); } } } } } void WalkSalesOrderRet(ISalesOrderRetList SalesOrderRet) { if (SalesOrderRet == null) return; //Go through all the elements of ISalesOrderRetList //Get value of TxnID string TxnID19725 = (string)SalesOrderRet.TxnID.GetValue(); //Get value of TimeCreated DateTime TimeCreated19726 = (DateTime)SalesOrderRet.TimeCreated.GetValue(); //Get value of TimeModified DateTime TimeModified19727 = (DateTime)SalesOrderRet.TimeModified.GetValue(); //Get value of EditSequence string EditSequence19728 = (string)SalesOrderRet.EditSequence.GetValue(); //Get value of TxnNumber if (SalesOrderRet.TxnNumber != null) { int TxnNumber19729 = (int)SalesOrderRet.TxnNumber.GetValue(); } //Get value of ListID if (SalesOrderRet.CustomerRef.ListID != null) { string ListID19730 = (string)SalesOrderRet.CustomerRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderRet.CustomerRef.FullName != null) { string FullName19731 = (string)SalesOrderRet.CustomerRef.FullName.GetValue(); } if (SalesOrderRet.ClassRef != null) { //Get value of ListID if (SalesOrderRet.ClassRef.ListID != null) { string ListID19732 = (string)SalesOrderRet.ClassRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderRet.ClassRef.FullName != null) { string FullName19733 = (string)SalesOrderRet.ClassRef.FullName.GetValue(); } } if (SalesOrderRet.TemplateRef != null) { //Get value of ListID if (SalesOrderRet.TemplateRef.ListID != null) { string ListID19734 = (string)SalesOrderRet.TemplateRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderRet.TemplateRef.FullName != null) { string FullName19735 = (string)SalesOrderRet.TemplateRef.FullName.GetValue(); } } //Get value of TxnDate DateTime TxnDate19736 = (DateTime)SalesOrderRet.TxnDate.GetValue(); //Get value of RefNumber if (SalesOrderRet.RefNumber != null) { string RefNumber19737 = (string)SalesOrderRet.RefNumber.GetValue(); } if (SalesOrderRet.BillAddress != null) { //Get value of Addr1 if (SalesOrderRet.BillAddress.Addr1 != null) { string Addr119738 = (string)SalesOrderRet.BillAddress.Addr1.GetValue(); } //Get value of Addr2 if (SalesOrderRet.BillAddress.Addr2 != null) { string Addr219739 = (string)SalesOrderRet.BillAddress.Addr2.GetValue(); } //Get value of Addr3 if (SalesOrderRet.BillAddress.Addr3 != null) { string Addr319740 = (string)SalesOrderRet.BillAddress.Addr3.GetValue(); } //Get value of Addr4 if (SalesOrderRet.BillAddress.Addr4 != null) { string Addr419741 = (string)SalesOrderRet.BillAddress.Addr4.GetValue(); } //Get value of Addr5 if (SalesOrderRet.BillAddress.Addr5 != null) { string Addr519742 = (string)SalesOrderRet.BillAddress.Addr5.GetValue(); } //Get value of City if (SalesOrderRet.BillAddress.City != null) { string City19743 = (string)SalesOrderRet.BillAddress.City.GetValue(); } //Get value of State if (SalesOrderRet.BillAddress.State != null) { string State19744 = (string)SalesOrderRet.BillAddress.State.GetValue(); } //Get value of PostalCode if (SalesOrderRet.BillAddress.PostalCode != null) { string PostalCode19745 = (string)SalesOrderRet.BillAddress.PostalCode.GetValue(); } //Get value of Country if (SalesOrderRet.BillAddress.Country != null) { string Country19746 = (string)SalesOrderRet.BillAddress.Country.GetValue(); } //Get value of Note if (SalesOrderRet.BillAddress.Note != null) { string Note19747 = (string)SalesOrderRet.BillAddress.Note.GetValue(); } } if (SalesOrderRet.BillAddressBlock != null) { //Get value of Addr1 if (SalesOrderRet.BillAddressBlock.Addr1 != null) { string Addr119748 = (string)SalesOrderRet.BillAddressBlock.Addr1.GetValue(); } //Get value of Addr2 if (SalesOrderRet.BillAddressBlock.Addr2 != null) { string Addr219749 = (string)SalesOrderRet.BillAddressBlock.Addr2.GetValue(); } //Get value of Addr3 if (SalesOrderRet.BillAddressBlock.Addr3 != null) { string Addr319750 = (string)SalesOrderRet.BillAddressBlock.Addr3.GetValue(); } //Get value of Addr4 if (SalesOrderRet.BillAddressBlock.Addr4 != null) { string Addr419751 = (string)SalesOrderRet.BillAddressBlock.Addr4.GetValue(); } //Get value of Addr5 if (SalesOrderRet.BillAddressBlock.Addr5 != null) { string Addr519752 = (string)SalesOrderRet.BillAddressBlock.Addr5.GetValue(); } } if (SalesOrderRet.ShipAddress != null) { //Get value of Addr1 if (SalesOrderRet.ShipAddress.Addr1 != null) { string Addr119753 = (string)SalesOrderRet.ShipAddress.Addr1.GetValue(); } //Get value of Addr2 if (SalesOrderRet.ShipAddress.Addr2 != null) { string Addr219754 = (string)SalesOrderRet.ShipAddress.Addr2.GetValue(); } //Get value of Addr3 if (SalesOrderRet.ShipAddress.Addr3 != null) { string Addr319755 = (string)SalesOrderRet.ShipAddress.Addr3.GetValue(); } //Get value of Addr4 if (SalesOrderRet.ShipAddress.Addr4 != null) { string Addr419756 = (string)SalesOrderRet.ShipAddress.Addr4.GetValue(); } //Get value of Addr5 if (SalesOrderRet.ShipAddress.Addr5 != null) { string Addr519757 = (string)SalesOrderRet.ShipAddress.Addr5.GetValue(); } //Get value of City if (SalesOrderRet.ShipAddress.City != null) { string City19758 = (string)SalesOrderRet.ShipAddress.City.GetValue(); } //Get value of State if (SalesOrderRet.ShipAddress.State != null) { string State19759 = (string)SalesOrderRet.ShipAddress.State.GetValue(); } //Get value of PostalCode if (SalesOrderRet.ShipAddress.PostalCode != null) { string PostalCode19760 = (string)SalesOrderRet.ShipAddress.PostalCode.GetValue(); } //Get value of Country if (SalesOrderRet.ShipAddress.Country != null) { string Country19761 = (string)SalesOrderRet.ShipAddress.Country.GetValue(); } //Get value of Note if (SalesOrderRet.ShipAddress.Note != null) { string Note19762 = (string)SalesOrderRet.ShipAddress.Note.GetValue(); } } if (SalesOrderRet.ShipAddressBlock != null) { //Get value of Addr1 if (SalesOrderRet.ShipAddressBlock.Addr1 != null) { string Addr119763 = (string)SalesOrderRet.ShipAddressBlock.Addr1.GetValue(); } //Get value of Addr2 if (SalesOrderRet.ShipAddressBlock.Addr2 != null) { string Addr219764 = (string)SalesOrderRet.ShipAddressBlock.Addr2.GetValue(); } //Get value of Addr3 if (SalesOrderRet.ShipAddressBlock.Addr3 != null) { string Addr319765 = (string)SalesOrderRet.ShipAddressBlock.Addr3.GetValue(); } //Get value of Addr4 if (SalesOrderRet.ShipAddressBlock.Addr4 != null) { string Addr419766 = (string)SalesOrderRet.ShipAddressBlock.Addr4.GetValue(); } //Get value of Addr5 if (SalesOrderRet.ShipAddressBlock.Addr5 != null) { string Addr519767 = (string)SalesOrderRet.ShipAddressBlock.Addr5.GetValue(); } } //Get value of PONumber if (SalesOrderRet.PONumber != null) { string PONumber19768 = (string)SalesOrderRet.PONumber.GetValue(); } if (SalesOrderRet.TermsRef != null) { //Get value of ListID if (SalesOrderRet.TermsRef.ListID != null) { string ListID19769 = (string)SalesOrderRet.TermsRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderRet.TermsRef.FullName != null) { string FullName19770 = (string)SalesOrderRet.TermsRef.FullName.GetValue(); } } //Get value of DueDate if (SalesOrderRet.DueDate != null) { DateTime DueDate19771 = (DateTime)SalesOrderRet.DueDate.GetValue(); } if (SalesOrderRet.SalesRepRef != null) { //Get value of ListID if (SalesOrderRet.SalesRepRef.ListID != null) { string ListID19772 = (string)SalesOrderRet.SalesRepRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderRet.SalesRepRef.FullName != null) { string FullName19773 = (string)SalesOrderRet.SalesRepRef.FullName.GetValue(); } } //Get value of FOB if (SalesOrderRet.FOB != null) { string FOB19774 = (string)SalesOrderRet.FOB.GetValue(); } //Get value of ShipDate if (SalesOrderRet.ShipDate != null) { DateTime ShipDate19775 = (DateTime)SalesOrderRet.ShipDate.GetValue(); } if (SalesOrderRet.ShipMethodRef != null) { //Get value of ListID if (SalesOrderRet.ShipMethodRef.ListID != null) { string ListID19776 = (string)SalesOrderRet.ShipMethodRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderRet.ShipMethodRef.FullName != null) { string FullName19777 = (string)SalesOrderRet.ShipMethodRef.FullName.GetValue(); } } //Get value of Subtotal if (SalesOrderRet.Subtotal != null) { double Subtotal19778 = (double)SalesOrderRet.Subtotal.GetValue(); } if (SalesOrderRet.ItemSalesTaxRef != null) { //Get value of ListID if (SalesOrderRet.ItemSalesTaxRef.ListID != null) { string ListID19779 = (string)SalesOrderRet.ItemSalesTaxRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderRet.ItemSalesTaxRef.FullName != null) { string FullName19780 = (string)SalesOrderRet.ItemSalesTaxRef.FullName.GetValue(); } } //Get value of SalesTaxPercentage if (SalesOrderRet.SalesTaxPercentage != null) { double SalesTaxPercentage19781 = (double)SalesOrderRet.SalesTaxPercentage.GetValue(); } //Get value of SalesTaxTotal if (SalesOrderRet.SalesTaxTotal != null) { double SalesTaxTotal19782 = (double)SalesOrderRet.SalesTaxTotal.GetValue(); } //Get value of TotalAmount if (SalesOrderRet.TotalAmount != null) { double TotalAmount19783 = (double)SalesOrderRet.TotalAmount.GetValue(); } if (SalesOrderRet.CurrencyRef != null) { //Get value of ListID if (SalesOrderRet.CurrencyRef.ListID != null) { string ListID19784 = (string)SalesOrderRet.CurrencyRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderRet.CurrencyRef.FullName != null) { string FullName19785 = (string)SalesOrderRet.CurrencyRef.FullName.GetValue(); } } //Get value of ExchangeRate if (SalesOrderRet.ExchangeRate != null) { IQBFloatType ExchangeRate19786 = (IQBFloatType)SalesOrderRet.ExchangeRate.GetValue(); } //Get value of TotalAmountInHomeCurrency if (SalesOrderRet.TotalAmountInHomeCurrency != null) { double TotalAmountInHomeCurrency19787 = (double)SalesOrderRet.TotalAmountInHomeCurrency.GetValue(); } //Get value of IsManuallyClosed if (SalesOrderRet.IsManuallyClosed != null) { bool IsManuallyClosed19788 = (bool)SalesOrderRet.IsManuallyClosed.GetValue(); } //Get value of IsFullyInvoiced if (SalesOrderRet.IsFullyInvoiced != null) { bool IsFullyInvoiced19789 = (bool)SalesOrderRet.IsFullyInvoiced.GetValue(); } //Get value of Memo if (SalesOrderRet.Memo != null) { string Memo19790 = (string)SalesOrderRet.Memo.GetValue(); } if (SalesOrderRet.CustomerMsgRef != null) { //Get value of ListID if (SalesOrderRet.CustomerMsgRef.ListID != null) { string ListID19791 = (string)SalesOrderRet.CustomerMsgRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderRet.CustomerMsgRef.FullName != null) { string FullName19792 = (string)SalesOrderRet.CustomerMsgRef.FullName.GetValue(); } } //Get value of IsToBePrinted if (SalesOrderRet.IsToBePrinted != null) { bool IsToBePrinted19793 = (bool)SalesOrderRet.IsToBePrinted.GetValue(); } //Get value of IsToBeEmailed if (SalesOrderRet.IsToBeEmailed != null) { bool IsToBeEmailed19794 = (bool)SalesOrderRet.IsToBeEmailed.GetValue(); } //Get value of IsTaxIncluded if (SalesOrderRet.IsTaxIncluded != null) { bool IsTaxIncluded19795 = (bool)SalesOrderRet.IsTaxIncluded.GetValue(); } if (SalesOrderRet.CustomerSalesTaxCodeRef != null) { //Get value of ListID if (SalesOrderRet.CustomerSalesTaxCodeRef.ListID != null) { string ListID19796 = (string)SalesOrderRet.CustomerSalesTaxCodeRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderRet.CustomerSalesTaxCodeRef.FullName != null) { string FullName19797 = (string)SalesOrderRet.CustomerSalesTaxCodeRef.FullName.GetValue(); } } //Get value of Other if (SalesOrderRet.Other != null) { string Other19798 = (string)SalesOrderRet.Other.GetValue(); } //Get value of ExternalGUID if (SalesOrderRet.ExternalGUID != null) { string ExternalGUID19799 = (string)SalesOrderRet.ExternalGUID.GetValue(); } if (SalesOrderRet.LinkedTxnList != null) { for (int i19800 = 0; i19800 < SalesOrderRet.LinkedTxnList.Count; i19800++) { ILinkedTxn LinkedTxn = SalesOrderRet.LinkedTxnList.GetAt(i19800); //Get value of TxnID string TxnID19801 = (string)LinkedTxn.TxnID.GetValue(); //Get value of TxnType ENTxnType TxnType19802 = (ENTxnType)LinkedTxn.TxnType.GetValue(); //Get value of TxnDate DateTime TxnDate19803 = (DateTime)LinkedTxn.TxnDate.GetValue(); //Get value of RefNumber if (LinkedTxn.RefNumber != null) { string RefNumber19804 = (string)LinkedTxn.RefNumber.GetValue(); } //Get value of LinkType if (LinkedTxn.LinkType != null) { ENLinkType LinkType19805 = (ENLinkType)LinkedTxn.LinkType.GetValue(); } //Get value of Amount double Amount19806 = (double)LinkedTxn.Amount.GetValue(); } } if (SalesOrderRet.ORSalesOrderLineRetList != null) { for (int i19807 = 0; i19807 < SalesOrderRet.ORSalesOrderLineRetList.Count; i19807++) { IORSalesOrderLineRet ORSalesOrderLineRet19808 = SalesOrderRet.ORSalesOrderLineRetList.GetAt(i19807); if (ORSalesOrderLineRet19808.SalesOrderLineRet != null) { if (ORSalesOrderLineRet19808.SalesOrderLineRet != null) { //Get value of TxnLineID string TxnLineID19809 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.TxnLineID.GetValue(); if (ORSalesOrderLineRet19808.SalesOrderLineRet.ItemRef != null) { //Get value of ListID if (ORSalesOrderLineRet19808.SalesOrderLineRet.ItemRef.ListID != null) { string ListID19810 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.ItemRef.ListID.GetValue(); } //Get value of FullName if (ORSalesOrderLineRet19808.SalesOrderLineRet.ItemRef.FullName != null) { string FullName19811 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.ItemRef.FullName.GetValue(); } } //Get value of Desc if (ORSalesOrderLineRet19808.SalesOrderLineRet.Desc != null) { string Desc19812 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.Desc.GetValue(); } //Get value of Quantity if (ORSalesOrderLineRet19808.SalesOrderLineRet.Quantity != null) { int Quantity19813 = (int)ORSalesOrderLineRet19808.SalesOrderLineRet.Quantity.GetValue(); } //Get value of UnitOfMeasure if (ORSalesOrderLineRet19808.SalesOrderLineRet.UnitOfMeasure != null) { string UnitOfMeasure19814 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.UnitOfMeasure.GetValue(); } if (ORSalesOrderLineRet19808.SalesOrderLineRet.OverrideUOMSetRef != null) { //Get value of ListID if (ORSalesOrderLineRet19808.SalesOrderLineRet.OverrideUOMSetRef.ListID != null) { string ListID19815 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.OverrideUOMSetRef.ListID.GetValue(); } //Get value of FullName if (ORSalesOrderLineRet19808.SalesOrderLineRet.OverrideUOMSetRef.FullName != null) { string FullName19816 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.OverrideUOMSetRef.FullName.GetValue(); } } if (ORSalesOrderLineRet19808.SalesOrderLineRet.ORRate != null) { if (ORSalesOrderLineRet19808.SalesOrderLineRet.ORRate.Rate != null) { //Get value of Rate if (ORSalesOrderLineRet19808.SalesOrderLineRet.ORRate.Rate != null) { double Rate19818 = (double)ORSalesOrderLineRet19808.SalesOrderLineRet.ORRate.Rate.GetValue(); } } if (ORSalesOrderLineRet19808.SalesOrderLineRet.ORRate.RatePercent != null) { //Get value of RatePercent if (ORSalesOrderLineRet19808.SalesOrderLineRet.ORRate.RatePercent != null) { double RatePercent19819 = (double)ORSalesOrderLineRet19808.SalesOrderLineRet.ORRate.RatePercent.GetValue(); } } } if (ORSalesOrderLineRet19808.SalesOrderLineRet.ClassRef != null) { //Get value of ListID if (ORSalesOrderLineRet19808.SalesOrderLineRet.ClassRef.ListID != null) { string ListID19820 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.ClassRef.ListID.GetValue(); } //Get value of FullName if (ORSalesOrderLineRet19808.SalesOrderLineRet.ClassRef.FullName != null) { string FullName19821 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.ClassRef.FullName.GetValue(); } } //Get value of Amount if (ORSalesOrderLineRet19808.SalesOrderLineRet.Amount != null) { double Amount19822 = (double)ORSalesOrderLineRet19808.SalesOrderLineRet.Amount.GetValue(); } if (ORSalesOrderLineRet19808.SalesOrderLineRet.InventorySiteRef != null) { //Get value of ListID if (ORSalesOrderLineRet19808.SalesOrderLineRet.InventorySiteRef.ListID != null) { string ListID19823 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.InventorySiteRef.ListID.GetValue(); } //Get value of FullName if (ORSalesOrderLineRet19808.SalesOrderLineRet.InventorySiteRef.FullName != null) { string FullName19824 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.InventorySiteRef.FullName.GetValue(); } } if (ORSalesOrderLineRet19808.SalesOrderLineRet.InventorySiteLocationRef != null) { //Get value of ListID if (ORSalesOrderLineRet19808.SalesOrderLineRet.InventorySiteLocationRef.ListID != null) { string ListID19825 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.InventorySiteLocationRef.ListID.GetValue(); } //Get value of FullName if (ORSalesOrderLineRet19808.SalesOrderLineRet.InventorySiteLocationRef.FullName != null) { string FullName19826 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.InventorySiteLocationRef.FullName.GetValue(); } } if (ORSalesOrderLineRet19808.SalesOrderLineRet.ORSerialLotNumber != null) { if (ORSalesOrderLineRet19808.SalesOrderLineRet.ORSerialLotNumber.SerialNumber != null) { //Get value of SerialNumber if (ORSalesOrderLineRet19808.SalesOrderLineRet.ORSerialLotNumber.SerialNumber != null) { string SerialNumber19828 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.ORSerialLotNumber.SerialNumber.GetValue(); } } if (ORSalesOrderLineRet19808.SalesOrderLineRet.ORSerialLotNumber.LotNumber != null) { //Get value of LotNumber if (ORSalesOrderLineRet19808.SalesOrderLineRet.ORSerialLotNumber.LotNumber != null) { string LotNumber19829 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.ORSerialLotNumber.LotNumber.GetValue(); } } } //Get value of ExpirationDateForSerialLotNumber if (ORSalesOrderLineRet19808.SalesOrderLineRet.ExpirationDateForSerialLotNumber != null) { string ExpDate = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.ExpirationDateForSerialLotNumber.GetValue(); } if (ORSalesOrderLineRet19808.SalesOrderLineRet.SalesTaxCodeRef != null) { //Get value of ListID if (ORSalesOrderLineRet19808.SalesOrderLineRet.SalesTaxCodeRef.ListID != null) { string ListID19830 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.SalesTaxCodeRef.ListID.GetValue(); } //Get value of FullName if (ORSalesOrderLineRet19808.SalesOrderLineRet.SalesTaxCodeRef.FullName != null) { string FullName19831 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.SalesTaxCodeRef.FullName.GetValue(); } } //Get value of Invoiced if (ORSalesOrderLineRet19808.SalesOrderLineRet.Invoiced != null) { int Invoiced19832 = (int)ORSalesOrderLineRet19808.SalesOrderLineRet.Invoiced.GetValue(); } //Get value of IsManuallyClosed if (ORSalesOrderLineRet19808.SalesOrderLineRet.IsManuallyClosed != null) { bool IsManuallyClosed19833 = (bool)ORSalesOrderLineRet19808.SalesOrderLineRet.IsManuallyClosed.GetValue(); } //Get value of Other1 if (ORSalesOrderLineRet19808.SalesOrderLineRet.Other1 != null) { string Other119834 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.Other1.GetValue(); } //Get value of Other2 if (ORSalesOrderLineRet19808.SalesOrderLineRet.Other2 != null) { string Other219835 = (string)ORSalesOrderLineRet19808.SalesOrderLineRet.Other2.GetValue(); } if (ORSalesOrderLineRet19808.SalesOrderLineRet.DataExtRetList != null) { for (int i19836 = 0; i19836 < ORSalesOrderLineRet19808.SalesOrderLineRet.DataExtRetList.Count; i19836++) { IDataExtRet DataExtRet = ORSalesOrderLineRet19808.SalesOrderLineRet.DataExtRetList.GetAt(i19836); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID19837 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName19838 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType19839 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue19840 = (string)DataExtRet.DataExtValue.GetValue(); } } } } if (ORSalesOrderLineRet19808.SalesOrderLineGroupRet != null) { if (ORSalesOrderLineRet19808.SalesOrderLineGroupRet != null) { //Get value of TxnLineID string TxnLineID19841 = (string)ORSalesOrderLineRet19808.SalesOrderLineGroupRet.TxnLineID.GetValue(); //Get value of ListID if (ORSalesOrderLineRet19808.SalesOrderLineGroupRet.ItemGroupRef.ListID != null) { string ListID19842 = (string)ORSalesOrderLineRet19808.SalesOrderLineGroupRet.ItemGroupRef.ListID.GetValue(); } //Get value of FullName if (ORSalesOrderLineRet19808.SalesOrderLineGroupRet.ItemGroupRef.FullName != null) { string FullName19843 = (string)ORSalesOrderLineRet19808.SalesOrderLineGroupRet.ItemGroupRef.FullName.GetValue(); } //Get value of Desc if (ORSalesOrderLineRet19808.SalesOrderLineGroupRet.Desc != null) { string Desc19844 = (string)ORSalesOrderLineRet19808.SalesOrderLineGroupRet.Desc.GetValue(); } //Get value of Quantity if (ORSalesOrderLineRet19808.SalesOrderLineGroupRet.Quantity != null) { int Quantity19845 = (int)ORSalesOrderLineRet19808.SalesOrderLineGroupRet.Quantity.GetValue(); } //Get value of UnitOfMeasure if (ORSalesOrderLineRet19808.SalesOrderLineGroupRet.UnitOfMeasure != null) { string UnitOfMeasure19846 = (string)ORSalesOrderLineRet19808.SalesOrderLineGroupRet.UnitOfMeasure.GetValue(); } if (ORSalesOrderLineRet19808.SalesOrderLineGroupRet.OverrideUOMSetRef != null) { //Get value of ListID if (ORSalesOrderLineRet19808.SalesOrderLineGroupRet.OverrideUOMSetRef.ListID != null) { string ListID19847 = (string)ORSalesOrderLineRet19808.SalesOrderLineGroupRet.OverrideUOMSetRef.ListID.GetValue(); } //Get value of FullName if (ORSalesOrderLineRet19808.SalesOrderLineGroupRet.OverrideUOMSetRef.FullName != null) { string FullName19848 = (string)ORSalesOrderLineRet19808.SalesOrderLineGroupRet.OverrideUOMSetRef.FullName.GetValue(); } } //Get value of IsPrintItemsInGroup bool IsPrintItemsInGroup19849 = (bool)ORSalesOrderLineRet19808.SalesOrderLineGroupRet.IsPrintItemsInGroup.GetValue(); //Get value of TotalAmount double TotalAmount19850 = (double)ORSalesOrderLineRet19808.SalesOrderLineGroupRet.TotalAmount.GetValue(); if (ORSalesOrderLineRet19808.SalesOrderLineGroupRet.SalesOrderLineRetList != null) { for (int i19851 = 0; i19851 < ORSalesOrderLineRet19808.SalesOrderLineGroupRet.SalesOrderLineRetList.Count; i19851++) { ISalesOrderLineRet SalesOrderLineRet = ORSalesOrderLineRet19808.SalesOrderLineGroupRet.SalesOrderLineRetList.GetAt(i19851); //Get value of TxnLineID string TxnLineID19852 = (string)SalesOrderLineRet.TxnLineID.GetValue(); if (SalesOrderLineRet.ItemRef != null) { //Get value of ListID if (SalesOrderLineRet.ItemRef.ListID != null) { string ListID19853 = (string)SalesOrderLineRet.ItemRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderLineRet.ItemRef.FullName != null) { string FullName19854 = (string)SalesOrderLineRet.ItemRef.FullName.GetValue(); } } //Get value of Desc if (SalesOrderLineRet.Desc != null) { string Desc19855 = (string)SalesOrderLineRet.Desc.GetValue(); } //Get value of Quantity if (SalesOrderLineRet.Quantity != null) { int Quantity19856 = (int)SalesOrderLineRet.Quantity.GetValue(); } //Get value of UnitOfMeasure if (SalesOrderLineRet.UnitOfMeasure != null) { string UnitOfMeasure19857 = (string)SalesOrderLineRet.UnitOfMeasure.GetValue(); } if (SalesOrderLineRet.OverrideUOMSetRef != null) { //Get value of ListID if (SalesOrderLineRet.OverrideUOMSetRef.ListID != null) { string ListID19858 = (string)SalesOrderLineRet.OverrideUOMSetRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderLineRet.OverrideUOMSetRef.FullName != null) { string FullName19859 = (string)SalesOrderLineRet.OverrideUOMSetRef.FullName.GetValue(); } } if (SalesOrderLineRet.ORRate != null) { if (SalesOrderLineRet.ORRate.Rate != null) { //Get value of Rate if (SalesOrderLineRet.ORRate.Rate != null) { double Rate19861 = (double)SalesOrderLineRet.ORRate.Rate.GetValue(); } } if (SalesOrderLineRet.ORRate.RatePercent != null) { //Get value of RatePercent if (SalesOrderLineRet.ORRate.RatePercent != null) { double RatePercent19862 = (double)SalesOrderLineRet.ORRate.RatePercent.GetValue(); } } } if (SalesOrderLineRet.ClassRef != null) { //Get value of ListID if (SalesOrderLineRet.ClassRef.ListID != null) { string ListID19863 = (string)SalesOrderLineRet.ClassRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderLineRet.ClassRef.FullName != null) { string FullName19864 = (string)SalesOrderLineRet.ClassRef.FullName.GetValue(); } } //Get value of Amount if (SalesOrderLineRet.Amount != null) { double Amount19865 = (double)SalesOrderLineRet.Amount.GetValue(); } if (SalesOrderLineRet.InventorySiteRef != null) { //Get value of ListID if (SalesOrderLineRet.InventorySiteRef.ListID != null) { string ListID19866 = (string)SalesOrderLineRet.InventorySiteRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderLineRet.InventorySiteRef.FullName != null) { string FullName19867 = (string)SalesOrderLineRet.InventorySiteRef.FullName.GetValue(); } } if (SalesOrderLineRet.InventorySiteLocationRef != null) { //Get value of ListID if (SalesOrderLineRet.InventorySiteLocationRef.ListID != null) { string ListID19868 = (string)SalesOrderLineRet.InventorySiteLocationRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderLineRet.InventorySiteLocationRef.FullName != null) { string FullName19869 = (string)SalesOrderLineRet.InventorySiteLocationRef.FullName.GetValue(); } } if (SalesOrderLineRet.ORSerialLotNumber != null) { if (SalesOrderLineRet.ORSerialLotNumber.SerialNumber != null) { //Get value of SerialNumber if (SalesOrderLineRet.ORSerialLotNumber.SerialNumber != null) { string SerialNumber19871 = (string)SalesOrderLineRet.ORSerialLotNumber.SerialNumber.GetValue(); } } if (SalesOrderLineRet.ORSerialLotNumber.LotNumber != null) { //Get value of LotNumber if (SalesOrderLineRet.ORSerialLotNumber.LotNumber != null) { string LotNumber19872 = (string)SalesOrderLineRet.ORSerialLotNumber.LotNumber.GetValue(); } } } //Get value of ExpirationDateForSerialLotNumber if (SalesOrderLineRet.ExpirationDateForSerialLotNumber != null) { string ExpDate = (string)SalesOrderLineRet.ExpirationDateForSerialLotNumber.GetValue(); } if (SalesOrderLineRet.SalesTaxCodeRef != null) { //Get value of ListID if (SalesOrderLineRet.SalesTaxCodeRef.ListID != null) { string ListID19873 = (string)SalesOrderLineRet.SalesTaxCodeRef.ListID.GetValue(); } //Get value of FullName if (SalesOrderLineRet.SalesTaxCodeRef.FullName != null) { string FullName19874 = (string)SalesOrderLineRet.SalesTaxCodeRef.FullName.GetValue(); } } //Get value of Invoiced if (SalesOrderLineRet.Invoiced != null) { int Invoiced19875 = (int)SalesOrderLineRet.Invoiced.GetValue(); } //Get value of IsManuallyClosed if (SalesOrderLineRet.IsManuallyClosed != null) { bool IsManuallyClosed19876 = (bool)SalesOrderLineRet.IsManuallyClosed.GetValue(); } //Get value of Other1 if (SalesOrderLineRet.Other1 != null) { string Other119877 = (string)SalesOrderLineRet.Other1.GetValue(); } //Get value of Other2 if (SalesOrderLineRet.Other2 != null) { string Other219878 = (string)SalesOrderLineRet.Other2.GetValue(); } if (SalesOrderLineRet.DataExtRetList != null) { for (int i19879 = 0; i19879 < SalesOrderLineRet.DataExtRetList.Count; i19879++) { IDataExtRet DataExtRet = SalesOrderLineRet.DataExtRetList.GetAt(i19879); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID19880 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName19881 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType19882 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue19883 = (string)DataExtRet.DataExtValue.GetValue(); } } } } if (ORSalesOrderLineRet19808.SalesOrderLineGroupRet.DataExtRetList != null) { for (int i19884 = 0; i19884 < ORSalesOrderLineRet19808.SalesOrderLineGroupRet.DataExtRetList.Count; i19884++) { IDataExtRet DataExtRet = ORSalesOrderLineRet19808.SalesOrderLineGroupRet.DataExtRetList.GetAt(i19884); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID19885 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName19886 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType19887 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue19888 = (string)DataExtRet.DataExtValue.GetValue(); } } } } } } if (SalesOrderRet.DataExtRetList != null) { for (int i19889 = 0; i19889 < SalesOrderRet.DataExtRetList.Count; i19889++) { IDataExtRet DataExtRet = SalesOrderRet.DataExtRetList.GetAt(i19889); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID19890 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName19891 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType19892 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue19893 = (string)DataExtRet.DataExtValue.GetValue(); } } //Get value of Fulfillment Status if (SalesOrderRet.FulfillmentStatus != null) { string FulfillmentStatus19893 = (string)SalesOrderRet.FulfillmentStatus.GetAsString(); } //Get value of ShippingDetails if (SalesOrderRet.ShippingDetails != null) { if (SalesOrderRet.ShippingDetails.ShippingDetailsLineRetList != null) for (int k19894 = 0; k < SalesOrderRet.ShippingDetails.ShippingDetailsLineRetList.Count; k19894++) { IShippingDetailsLineRet ShippingDetailsLineRet = SalesOrderRet.ShippingDetails.ShippingDetailsLineRetList.GetAt(k19894); string trackingID19895 = (string)ShippingDetailsLineRet.TrackingID.GetValue(); string carrierName19896 = (string)ShippingDetailsLineRet.CarrierName.GetValue(); string shippingMethod19897 = (string)ShippingDetailsLineRet.ShippingMethod.GetValue(); string shippingCharges19898 = (double)ShippingDetailsLineRet.ShippingCharges.GetValue(); } //Get value of SOchannel if (SalesOrderRet.SOChannel != null) { string SOChannel19899 = (string)SalesOrderRet.SOChannel.GetAsString(); } //Get value of StoreName if (SalesOrderRet.StoreName != null) { string StoreName19900 = (string)SalesOrderRet.StoreName.GetValue(); } //Get value of StoreType if (SalesOrderRet.StoreType != null) { string StoreType19901 = (string)SalesOrderRet.StoreType.GetValue(); } } } } } |