VendorCreditQuery
Queries for the specified vendor credit or set of credits.
Request
Response
XMLOps
VB.NET
C#
| Tag | Type | Max length | Implementation | Required |
|---|---|---|---|---|
IVendorCreditQuery
Queries for the specified vendor credit or set of credits.
|
||||
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 |
||
ORTxnQuery |
IORTxnQuery | |||
TxnIDList
One or more TxnID values. QuickBooks generates a unique TxnID for each transaction that is added to QuickBooks. Notice that you cannot supply the TxnID of a TimeTracking transaction to TransactionQuery requests. If you do, you get an error stating that no such record could be found, even though the transaction is in QuickBooks. This behavior reflects the behavior in the QuicKBooks UI in the Find window.
|
IBSTRList | |||
RefNumberList
A list of one or more RefNumber values. A RefNumber is a string of characters that refers to a transaction and that can be arbitrarily changed by the QuickBooks user. Note (especially relevant to CheckAdd requests): When RefNumber is left blank in an SDK transaction add request, the RefNumber will be left blank in QuickBooks. This behavior is new as of QBFC3. It used to select the next sequential reference number since the last one used by QuickBooks, as though no RefNumber had been provided. This is especially relevant to CheckAdd requests because with the current behavior, you will not know the number until the check is printed.
|
IBSTRList | |||
RefNumberCaseSensitiveList
A list of one or more case sensitive RefNumber values. A RefNumber is a string of characters that refers to a transaction and that can be arbitrarily changed by the QuickBooks user. You should use this case sensitive ref number list rather than the older RefNumber list, because it provides much better performance in certain circumstances. The older refNumber list provided slow performance if the refNumber values contained letters, not just digits. This RefNumberCaseSensitive list, new in SDK 4.0, eliminates this performance hit.
|
IBSTRList | 4.0 | ||
TxnFilter
The ITxnFilter group object allows you to search according to various criteria.
|
ITxnFilter | |||
MaxReturned
Limits the number of objects that a query returns. (To get a count of how many objects could possibly be returned, use the metaData query attribute.) If you include a MaxReturned value, it must be at least 1.
|
IQBIntType | |||
ORDateRangeFilter |
IORDateRangeFilter | |||
ModifiedDateRangeFilter
Filters according to the dates when transactions were last modified. The ModifiedDateRangeFilter aggregate is not required to contain any elements, but if it is empty, we recommend that you leave it out altogether. Note that the time portion of the FromModifiedDate and ToModifiedDate fields was not supported in qbXML version 1.0 or 1.1. (To filter according to the dates when transactions were deleted, use a TxnDeletedQuery message.)
|
IModifiedDateRangeFilter | |||
FromModifiedDate
Selects objects modified on or after this date. See the note below regarding QBFC usage.For desktop versions of QuickBooks, the FromModifiedDate and ToModifiedDate must be between 1970-01-01 and 2038-01-19T03:14:07 (2038-01-18T19:14:07-08:00 PST). (The time portion of the field was not supported in qbXML version 1.0 or 1.1.) Also, for desktop versions of QuickBooks, if FromModifiedDate includes a date but not a time (for example, if you set FromModifiedDate to 2003-02-14), the time is assumed to be zero (2003-02-14T00:00:00). If you omit FromModifiedDate, it will be set to 1970-01-01T00:00:00 (1969-12-31T16:00:00-08:00 PST).For QBOE, the FromModifiedDate and ToModifiedDate must be between 1900-01-01T00:00:00 and 9999-12-31T00:00:00. If FromModifiedDate includes a date but not a time (for example, if you set FromModifiedDate to 2003-02-14), the time is assumed to be zero (2003-02-14T00:00:00). If you omit FromModifiedDate, it will be set to 1900-01-01T00:00:00.Note: When specifying this in QBFC, you need to supply the parameter asDateOnly, which is a Boolean. If asDateOnly is true, the date value will be represented as a date only (without a time). If asDateOnly is false, the date value will be represented as date and time, padded with zeros if necessary, and set to the beginning of the day if no time is provided. The asDateOnly parameter is especially useful in the ToModifiedDate field of a query: If asDateOnly is set to true in the ToModifiedDate field of a query, then the query includes elements modified up to the end of the day. If asDateOnly is false, the query includes elements modified up to the specified time (or up to the beginning of the day if no time is included).
|
IQBDateTimeType | |||
ToModifiedDate
Selects objects modified on or before this date. See the note below on QBFC usage.For desktop versions of QuickBooks, the ToModifiedDate and FromModifiedDate must be between 01/01/1970 and 2038-01-19T03:14:07 (2038-01-18T19:14:07-08:00 PST). (Note that the time portion of the field was not supported in qbXML version 1.0 or 1.1.) If ToModifiedDate includes a date but not a time (for example, if you set ToModifiedDate to 2003-02-14), the time is assumed to be the end of the day (2003-02-14T23:59:59). If you omit ToModifiedDate altogether, it will be set to 2038-01-19T03:14:07 (2038-01-18T19:14:07-08:00 PST).For QBOE, the ToModifiedDate and FromModifiedDate must be between 01/01/1900 and 9999-12-31T00:00:00. If ToModifiedDate includes a date but not a time (for example, if you set ToModifiedDate to 2003-02-14), the time is assumed to be the end of the day (2003-02-14T23:59:59). If you omit ToModifiedDate altogether, it will be set to 9999-12-31T00:00:00.Note: When specifying this in QBFC, you need to supply the parameter asDateOnly, which is a Boolean. If asDateOnly is true, the date value will be represented as a date only (without a time). If asDateOnly is false, the date value will be represented as date and time, padded with zeros if necessary, and set to the beginning of the day if no time is provided. The asDateOnly parameter is especially useful in the ToModifiedDate field of a query: If asDateOnly is set to true in the ToModifiedDate field of a query, then the query includes elements modified up to the end of the day. If asDateOnly is false, the query includes elements modified up to the specified time (or up to the beginning of the day if no time is included).
|
IQBDateTimeType | |||
TxnDateRangeFilter
Filters according to the original transaction dates.
|
ITxnDateRangeFilter | |||
ORTxnDateRangeFilter |
IORTxnDateRangeFilter | Y | ||
TxnDateFilter
The ITxnDateFilter group object allows you to filter by transaction creation date.
|
ITxnDateFilter | |||
FromTxnDate
Selects transactions created on or after this date. Both FromTxnDate and ToTxnDate must be between 01/01/1901 and 12/31/9999.If you omit FromTxnDate, it will be set to 1970-01-01 (1969-12-31 PST).
|
IQBDateType | |||
ToTxnDate
Selects transactions created on or before this date. Both ToTxnDate and FromTxnDate must be between 01/01/1901 and 12/31/9999. If you omit ToTxnDate, it will be set to 2038-01-19 (2038-01-18 PST).
|
IQBDateType | |||
DateMacro
Refers to the transaction date, not the last modification date. Do not include DateMacro if either FromModifedDate or ToModifiedDate are specified. If a query does not specify DateMacro, FromModifedDate, or ToModifiedDate, it includes all dates. DateMacro values, in alphabetical order, that are new with QBFC3: dmAll, dmdmLastCalendarQuarter, dmdmLastCalendarQuarterToDate, dmdmLastCalendarYear, dmdmLastCalendarYearToDate, dmLastFiscalQuarterToDate, dmLastFiscalYearToDate, dmLastMonthToDate, dmLastWeekToDate, dmNextCalendarQuarter, dmNextCalendarYear, dmNextFiscalQuarter, dmNextFiscalYear, dmNextFourWeeks, dmNextMonth, dmNextWeek, dmThisCalendarQuarter, dmThisCalendarQuarterToDate, dmThisCalendarYear, dm ThisCalendarYearToDate, dmThisFiscalQuarter, dmThisFiscalYear, dmThisMonth, dmThisWeek, dmThisWeekToDate, dmToday, dmYesterday The list given when you click IQBENDateMacroType shows the complete list of valid version 3.0 values.
|
IQBENDateMacroType | |||
EntityFilter
An entity refers to a person on the QuickBooks Customer list, Vendor list, Employee list, or Other Names list. You can use an EntityQuery request to get information about all the entities that are set up in the QuickBooks file. In an ARRefundCreditCard query, this must be a customer/customer job.
|
IEntityFilter | |||
OREntityFilter |
IOREntityFilter | Y | ||
ListIDList
One or more ListID values. Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IBSTRList | 2.0 | ||
FullNameList
A list of one or more FullName values. FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IBSTRList | |||
ListIDWithChildren
Allows you to filter for data that relates to the specified object and its descendants.
|
IQBIDType | 2.0 | ||
FullNameWithChildren
Allows you to filter for data that relates to the specified object and its descendants. For names that do not have children, FullNameWithChildren is exactly the same as FullName.
|
IQBStringType | |||
AccountFilter
Filters according to the account name or ListID. If the “Use account numbers” preference is enabled in the QuickBooks company file, you can specify an account number (instead of an account name) for FullName and get the account you’re looking for. But if numbers have been used as account names, confusion could arise. For example, if you queried for an account named 2050, and 2050 happened to be the account number of a totally different account, the query would not return what you asked for (the account named 2050), but instead would return the account with the account number 2050. This problem will not happen if the “Use account numbers” preference is turned off in the QuickBooks file, orthe account name exactly matches the account number. (In this case, query would return the correct account either way.) To avoid this problem: Do not name an account using a number unless the number exactly matches the account’s account number. If an account name must contain a number that does not match its own account number, have the QuickBooks user change the account’s name slightly, for example to 2050a.
|
IAccountFilter | |||
ORAccountFilter |
IORAccountFilter | Y | ||
ListIDList
One or more ListID values. Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IBSTRList | 2.0 | ||
FullNameList
A list of one or more FullName values. FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IBSTRList | |||
ListIDWithChildren
Allows you to filter for data that relates to the specified object and its descendants.
|
IQBIDType | 2.0 | ||
FullNameWithChildren
Allows you to filter for data that relates to the specified object and its descendants. For names that do not have children, FullNameWithChildren is exactly the same as FullName.
|
IQBStringType | |||
ORRefNumberFilter |
IORRefNumberFilter | |||
RefNumberFilter
Filters according to RefNumber.
|
IRefNumberFilter | |||
MatchCriterion
The criterion to match.
|
IQBENMatchCriterionType | Y | ||
RefNumber
A string of characters that refers to this transaction and that can be arbitrarily changed by the QuickBooks user. In a BillPaymentCheckAdd request, if you want to set the check number, use RefNumber.Note (especially relevant to CheckAdd requests): When RefNumber is left blank in an SDK transaction add request (that is, or ), the RefNumber will be left blank in QuickBooks. This behavior is new as of QBFC3. It used to select the next sequential reference number since the last one used by QuickBooks, as though no RefNumber had been provided. This is especially relevant to CheckAdd requests because with the current behavior, you will not know the number until the check is printed.
|
IQBStringType | Y | ||
RefNumberRangeFilter
Filters according to RefNumber. The filtering code will do a numerical comparison (if FromRefNumber and ToRefNumber only contain digits) or a lexicographical comparison (if either FromRefNumber or ToRefNumber contain any nondigit characters). In the first situation, if you need to query for a RefNumber that is larger than the maximum long integer value of 2147483647, one workaround is to specify a FromRefNumber that is less than or equal to 2147483647 without specifying a ToRefNumber.
|
IRefNumberRangeFilter | |||
FromRefNumber
The first RefNumber in the search range. If FromRefNumber is omitted, the range will begin with first number on the list.
|
IQBStringType | |||
ToRefNumber
The final RefNumber in the search range. If ToRefNumber is omitted, the range will end with last number on the list.
|
IQBStringType | |||
CurrencyFilter
Filters by the specified currency.
|
ICurrencyFilter | 8.0 | ||
ORCurrencyFilter |
IORCurrencyFilter | Y | ||
ListIDList
One or more ListID values. Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IBSTRList | |||
FullNameList
A list of one or more FullName values. FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IBSTRList | 64 chars | ||
IncludeLineItems
This filter allows you to omit line items from a query response to get a smaller result. The default value is false, so line items are omitted by default. Set IncludeLineItems to true to include line items in the response if you don’t mind getting a larger result.
|
IQBBoolType | |||
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 vendor credit or set of credits.
|
||||
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 |
IVendorCreditRetList | |||
(List
of IVendorCreditRet Objects)
|
||||
TxnID
QuickBooks generates a unique TxnID for each transaction that is added to QuickBooks. A TxnID returned from a request can be used to refer to the transaction in subsequent requests. Notice that you cannot supply the TxnID of a TimeTracking transaction to TransactionQueryRq requests. If you do, you get an error stating that no such record could be found, even though the transaction is in QuickBooks. This behavior reflects the behavior in the QuicKBooks UI in the Find window.
|
IQBIDType | Y | ||
TimeCreated
Time the object was created.
|
IQBDateTimeType | Y | ||
TimeModified
Time the object was last modified.
|
IQBDateTimeType | Y | ||
EditSequence
A number that the server generates and assigns to this object. Every time the object is changed, the server will change its EditSequence value. When you try to modify a list object, you must provide its EditSequence. The server compares the EditSequence you provide with the EditSequence in memory to make sure you are dealing with the latest copy of the object. If you are not, the server will reject the request and return an error. Because EditSequence is only used to check whether two objects match, there is no reason to interpret its value.
|
IQBStringType | 16 chars | Y | |
TxnNumber
An identifying number for this transaction.
|
IQBIntType | |||
VendorRef
A vendor is any person or company from whom a small business owner buys goods and services. (Banks and tax agencies usually are included on the vendor list.) A company’s vendor list contains information such as account balance and contact information about each vendor. A VendorRef aggregate refers to one of the vendors on the list. In a request, if a VendorRef aggregate includes both FullName and ListID, FullName will be ignored.
|
IQBBaseRef | Y | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 41 chars | ||
APAccountRef
Refers to an accounts payable account in the QuickBooks file. (The AccountType of this account will be AccountsPayable.) If APAccountRef is missing, the SDK will use the QuickBooks default AP account. In a request, if an APAccountRef aggregate includes both FullName and ListID, FullName will be ignored.
|
IQBBaseRef | 2.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 2.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | 2.0 | |
TxnDate
The date of the transaction. In some cases, if you leave TxnDate out of an -Add message, QuickBooks will prefill TxnDate with the date of the last-saved transaction of the same type.
|
IQBDateType | Y | ||
CreditAmount
The amount of a credit that is being applied to a vendor bill, reducing the amount that is owed on the bill.
|
IQBAmountType | Y | ||
CurrencyRef
The currency object contains all of the information needed by QuickBooks to display and use. For built-in currencies, the name and currency code values are internationally accepted values and thus are not editable. The comma format is editable, as is the IsActive status. For user-defined currencies, every value in the object is editable including name and currency code. When used with PriceLevels, the CurrencyRef should only be used with “per item” price levels.
|
IQBBaseRef | 8.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 8.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 64 chars | 8.0 | |
ExchangeRate
The exchange rate is the market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the “home” currency. The exchange rate should be considered a snapshot of the rates in effect at the AsOfDate. You can update the exchange rate using the exchange rate property when you add a transaction. However, you need to obtain and supply the exchange rate. If you are using USD (United States Dollars) as the home currency and are connected to the Internet, you can download the current exchange rates for all active currencies automatically in the QuickBooks UI by selecting Lists->Currency->Activities->Download latest exchange rates. (Currently, you can’t do this in the SDK.)
|
IQBFloatType | 8.0 | ||
CreditAmountInHomeCurrency
The amount of the credit, expressed in units of the current home currency.
|
IQBAmountType | 8.0 | ||
RefNumber
A string of characters that refers to this transaction and that can be arbitrarily changed by the QuickBooks user. In a BillPaymentCheckAdd request, if you want to set the check number, use RefNumber.Note (especially relevant to CheckAdd requests): When RefNumber is left blank in an SDK transaction add request (that is, or ), the RefNumber will be left blank in QuickBooks. This behavior is new as of QBFC3. It used to select the next sequential reference number since the last one used by QuickBooks, as though no RefNumber had been provided. This is especially relevant to CheckAdd requests because with the current behavior, you will not know the number until the check is printed.
|
IQBStringType | 20 chars | ||
Memo
Appears in the A/P register and in reports that include this credit.
|
IQBStringType | 4095 chars | ||
IsTaxIncluded
For future use with international versions of QuickBooks.
|
IQBBoolType | 8.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 | 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 | 3 chars | 8.0 |
|
ExternalGUID
Allows for the attachment of a user defined GUID value.
|
IQBGUIDType | 9.0 | ||
LinkedTxnList
If the IncludeLinkedTxns flag is set to true in a query, or if you create an item receipt that links to other transactionsthen the returned object will include a list of linked transactions, if any exist. If no linked transactions exist, the ILinkedTxnList object will be empty. The list of linked transactions is similar to the History view of a transaction in the user interface, but not identical, as the SDK list contains only linked transactions, not items.
|
ILinkedTxnList | 2.0 | ||
(List
of ILinkedTxn Objects)
|
||||
TxnID
QuickBooks generates a unique TxnID for each transaction that is added to QuickBooks. A TxnID returned from a request can be used to refer to the transaction in subsequent requests. Notice that you cannot supply the TxnID of a TimeTracking transaction to TransactionQueryRq requests. If you do, you get an error stating that no such record could be found, even though the transaction is in QuickBooks. This behavior reflects the behavior in the QuicKBooks UI in the Find window.
|
IQBIDType | Y | ||
TxnType
The type of transaction.
|
IQBENTxnTypeType | Y | ||
TxnDate
The date of the transaction. In some cases, if you leave TxnDate out of an -Add message, QuickBooks will prefill TxnDate with the date of the last-saved transaction of the same type.
|
IQBDateType | Y | ||
RefNumber
A string of characters that refers to this transaction and that can be arbitrarily changed by the QuickBooks user. In a BillPaymentCheckAdd request, if you want to set the check number, use RefNumber.Note (especially relevant to CheckAdd requests): When RefNumber is left blank in an SDK transaction add request (that is, or ), the RefNumber will be left blank in QuickBooks. This behavior is new as of QBFC3. It used to select the next sequential reference number since the last one used by QuickBooks, as though no RefNumber had been provided. This is especially relevant to CheckAdd requests because with the current behavior, you will not know the number until the check is printed.
|
IQBStringType | 20 chars | ||
LinkType
Indicates the nature of the link between the transactions:ltAMTTYPE means the two transactions are linked based on an amount value (for example an invoice linked to a payment).ltQUANTYPE means the two transactions are linked based on a quantity. This affects transactions that are linked to sales orders, estimates and purchase orders. For example, an invoice might be created from a sales order, based on the quantity of items received.
|
IQBENLinkTypeType | 3.0 | ||
Amount
A monetary amount.
|
IQBAmountType | Y | ||
ExpenseLineRetList
A list of IExpenseLine objects, each representing one line in this expense.
|
IExpenseLineRetList | |||
(List
of IExpenseLineRet Objects)
|
||||
TxnLineID
Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
|
IQBIDType | Y | ||
AccountRef
The Account list is the company file’s list of accounts. An AccountRef aggregate refers to one of these accounts. (If an AccountRef aggregate includes both FullName and ListID, FullName will be ignored.) Special cases to note:In a Check message, AccountRef refers to the account from which the funds are being drawn for this check, for example, Checking or Savings.In an ExpenseLineAdd message, you must include AccountRef if the “Require accounts” check box is selected in the QuickBooks Accounting preferences. (It is selected by default.) In a CreditCardCredit message, AccountRef refers to the bank account or credit card account to which the credit is applied.In a CreditCardCharge message, AccountRef refers to the bank or credit card company to whom money is owed. How do you increase and decrease amounts in bank accounts? The following requests increase the balance in a bank account: Deposit Add ReceivePaymentAdd Journal Entry Add Sales ReceiptAdd The following requests decrease the balance in a bank account: CheckAdd Bill PaymentCheckAdd JournalEntryAdd
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
Amount
A monetary amount.
|
IQBAmountType | |||
Memo
Additional information about this expense line.
|
IQBStringType | 4095 chars | ||
CustomerRef
The customer list includes information about the QuickBooks user’s customers and the individual jobs that are being performed for them. A CustomerRef aggregate refers to one of the customers (or customer jobs) on the list. In a request, if a CustomerRef aggregate includes both FullName and ListID, FullName will be ignored. Special cases to note:In SalesReceipt and ReceivePayment requests, CustomerRef refers to the customer or customer job to which the payment is credited.In a TimeTracking request, CustomerRef refers to the customer or customer job to which this time could be billed. If IsBillable is set to true, CustomerRef is required in TimeTrackingAdd. In an ExpenseLineAdd request, if AccountRef refers to an A/P account, CustomerRef must refer to a vendor (not to a customer). If AccountRef refers to any other type of account, the CustomerRef must refer to a customer.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 209 chars | ||
ClassRef
Classes can be used to separate transactions into meaningful categories. (For example, transactions could be classified according to department, business location, or type of work.) In QuickBooks, class tracking is off by default. A ClassRef aggregate refers to one of these named classes. For example, in a TimeTracking message, ClassRef refers to the QuickBooks class into which the timed activity falls. If a ClassRef aggregate includes both FullName and ListID, FullName will be ignored. In an InvoiceAdd request, if you specify a ClassRef for the whole invoice, that same ClassRef is automatically used in the line items. If you want to clear that (that is, have NO ClassRef for the line item, you can clear it in the line item by simply not specifying it in the line item.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
SalesTaxCodeRef
Each item on a sales form is assigned a sales-tax code that indicates whether the item is taxable or non-taxable, and why. Two general codes, which can be modified but not deleted, appear on the sales-tax code list by default:Non-taxable (Name = NON; Desc = Non-Taxable; IsTaxable = false)Taxable (Name = TAX; Desc = Taxable; IsTaxable = true) A sales-tax code can be deleted only if it is no longer associated with any customer, item, or transaction. If the “Do You Charge Sales Tax?” preference within QuickBooks is set to No, QuickBooks will assign the default non-taxable sales-tax code to all sales. A SalesTaxCodeRef aggregate refers to a sales-tax code on the list. In a request, if a SalesTaxCodeRef aggregate includes both FullName and ListID, FullName will be ignored. In a Customer message, SalesTaxCodeRef refers to the sales-tax code that will be used for items related to this customer. In an ItemInventory message, SalesTaxCodeRef refers to the type of sales tax that will be charged for this item, if it is a taxable item and if sales tax is set up within QuickBooks.
|
IQBBaseRef | 6.0 |
||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 6.0 |
||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 3 chars | 6.0 |
|
BillableStatus
The billing status of this item line or expense line.
|
IQBENBillableStatusType | 2.0 | ||
SalesRepRef
A sales representative must be on the Employee, Vendor, or Other Names list within QuickBooks. Sales representative’s names and initials appear on the Rep drop-down list on QuickBooks sales forms. A SalesRepRef refers to a person on the SalesRep list. In a request, if a SalesRepRef aggregate includes both FullName and ListID, FullName will be ignored.
|
IQBBaseRef | 13.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 13.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 5 chars | 13.0 | |
DataExtRetList
A list of IDataExtRet objects, each of which represents a field that has been added to QuickBooks as a data extension.
|
IDataExtRetList | 13.0 | ||
(List
of IDataExtRet Objects)
|
||||
OwnerID
OwnerID refers to the owner of a data extension, and must be 0 or a valid GUID. (Custom fields, which are visible in the QuickBooks UI, always have an OwnerID of 0. ) Usually you would keep your application’s GUID confidential to prevent other applications from accessing your data extensions. But if you want to share data extensions with another application, the applications need to use the same GUID. In this case, each application could use two GUIDs, one for shared data extensions and one for confidential data extensions. (An application can have any number of GUIDs.) When you share a data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
|
IQBGUIDType | |||
DataExtName
The name of the data extension. If this is a custom field, DataExtName will be visible as a label in the QuickBooks user interface. Also because OwnerID and DataExtName together make the data extension unique, and because custom fields all have the same OwnerID of zero, the DataExtName must be a unique value among existing custom fields. In contrast, the DataExtName for private data extensions must be unique only for the specified OwnerID GUID.
|
IQBStringType | 31 chars | Y | |
DataExtType
The field’s data type, which corresponds to a qbXML data type. In an IDataExtDefAdd request object, if this is a custom field, DataExtType must be detSTR255TYPE.
|
IQBENDataExtTypeType | Y | ||
DataExtValue
The data in this field. The maximum length of DataExtValue will depend on the DataExtType of this data extension. For example, if DataExtType is STR255TYPE, the maximum length of DataExtValue is 255 characters. If DataExtType is STR1024TYPE, the maximum size of DataExtValue is 1KB.
|
IQBStringType | Y | ||
ORItemLineRetList |
IORItemLineRetList | |||
(List
of IORItemLineRet Objects)
|
||||
ItemLineRet
An ItemLine is used to track any portion of a transaction that represents the purchase of an “item.” If ItemLineAdd does not specify an Amount, Cost, or Quantity, then QuickBooks will calculate Amount based on a Quantity of 1 and the suggested Cost.
|
IItemLineRet | |||
TxnLineID
Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
|
IQBIDType | Y | ||
ItemRef
Depending on the request containing it, ItemRef can refer to an item on any Item list such as ItemDiscount, ItemInventory, and so forth, or it may accept only a subset of item types. For example, here are some requests that impose limits on what items ItemRef can refer to. For PurchaseOrder and Bill requests, ItemRef cannot refer to discount items or sales-tax 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 | |||
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 |
|
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 | |
Cost
If both Quantity and Amount are specified, QuickBooks will use them to calculate Cost. Likewise, if both Quantity and Cost are specified, QuickBooks will use them to calculate the total Amount.
|
IQBPriceType | |||
Amount
A monetary amount.
|
IQBAmountType | |||
CustomerRef
The customer list includes information about the QuickBooks user’s customers and the individual jobs that are being performed for them. A CustomerRef aggregate refers to one of the customers (or customer jobs) on the list. In a request, if a CustomerRef aggregate includes both FullName and ListID, FullName will be ignored. Special cases to note:In SalesReceipt and ReceivePayment requests, CustomerRef refers to the customer or customer job to which the payment is credited.In a TimeTracking request, CustomerRef refers to the customer or customer job to which this time could be billed. If IsBillable is set to true, CustomerRef is required in TimeTrackingAdd. In an ExpenseLineAdd request, if AccountRef refers to an A/P account, CustomerRef must refer to a vendor (not to a customer). If AccountRef refers to any other type of account, the CustomerRef must refer to a customer.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 209 chars | ||
ClassRef
Classes can be used to separate transactions into meaningful categories. (For example, transactions could be classified according to department, business location, or type of work.) In QuickBooks, class tracking is off by default. A ClassRef aggregate refers to one of these named classes. For example, in a TimeTracking message, ClassRef refers to the QuickBooks class into which the timed activity falls. If a ClassRef aggregate includes both FullName and ListID, FullName will be ignored. In an InvoiceAdd request, if you specify a ClassRef for the whole invoice, that same ClassRef is automatically used in the line items. If you want to clear that (that is, have NO ClassRef for the line item, you can clear it in the line item by simply not specifying it in the line item.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
SalesTaxCodeRef
Each item on a sales form is assigned a sales-tax code that indicates whether the item is taxable or non-taxable, and why. Two general codes, which can be modified but not deleted, appear on the sales-tax code list by default:Non-taxable (Name = NON; Desc = Non-Taxable; IsTaxable = false)Taxable (Name = TAX; Desc = Taxable; IsTaxable = true) A sales-tax code can be deleted only if it is no longer associated with any customer, item, or transaction. If the “Do You Charge Sales Tax?” preference within QuickBooks is set to No, QuickBooks will assign the default non-taxable sales-tax code to all sales. A SalesTaxCodeRef aggregate refers to a sales-tax code on the list. In a request, if a SalesTaxCodeRef aggregate includes both FullName and ListID, FullName will be ignored. In a Customer message, SalesTaxCodeRef refers to the sales-tax code that will be used for items related to this customer. In an ItemInventory message, SalesTaxCodeRef refers to the type of sales tax that will be charged for this item, if it is a taxable item and if sales tax is set up within QuickBooks.
|
IQBBaseRef | 6.0 |
||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 6.0 |
||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 3 chars | 6.0 |
|
BillableStatus
The billing status of this item line or expense line.
|
IQBENBillableStatusType | 2.0 | ||
SalesRepRef
A sales representative must be on the Employee, Vendor, or Other Names list within QuickBooks. Sales representative’s names and initials appear on the Rep drop-down list on QuickBooks sales forms. A SalesRepRef refers to a person on the SalesRep list. In a request, if a SalesRepRef aggregate includes both FullName and ListID, FullName will be ignored.
|
IQBBaseRef | 13.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 13.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 5 chars | 13.0 | |
DataExtRetList
A list of IDataExtRet objects, each of which represents a field that has been added to QuickBooks as a data extension.
|
IDataExtRetList | 13.0 | ||
(List
of IDataExtRet Objects)
|
||||
OwnerID
OwnerID refers to the owner of a data extension, and must be 0 or a valid GUID. (Custom fields, which are visible in the QuickBooks UI, always have an OwnerID of 0. ) Usually you would keep your application’s GUID confidential to prevent other applications from accessing your data extensions. But if you want to share data extensions with another application, the applications need to use the same GUID. In this case, each application could use two GUIDs, one for shared data extensions and one for confidential data extensions. (An application can have any number of GUIDs.) When you share a data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
|
IQBGUIDType | |||
DataExtName
The name of the data extension. If this is a custom field, DataExtName will be visible as a label in the QuickBooks user interface. Also because OwnerID and DataExtName together make the data extension unique, and because custom fields all have the same OwnerID of zero, the DataExtName must be a unique value among existing custom fields. In contrast, the DataExtName for private data extensions must be unique only for the specified OwnerID GUID.
|
IQBStringType | 31 chars | Y | |
DataExtType
The field’s data type, which corresponds to a qbXML data type. In an IDataExtDefAdd request object, if this is a custom field, DataExtType must be detSTR255TYPE.
|
IQBENDataExtTypeType | Y | ||
DataExtValue
The data in this field. The maximum length of DataExtValue will depend on the DataExtType of this data extension. For example, if DataExtType is STR255TYPE, the maximum length of DataExtValue is 255 characters. If DataExtType is STR1024TYPE, the maximum size of DataExtValue is 1KB.
|
IQBStringType | Y | ||
ItemGroupLineRet
Refers to items that are grouped together in QuickBooks for fast entry.
|
IItemGroupLineRet | |||
TxnLineID
Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
|
IQBIDType | 3.0 | Y | |
ItemGroupRef
ItemGroup objects represent items that are grouped together for fast entry, and an ItemGroupRef aggregate refers to one of these item groups. In a request, if an ItemGroupRef aggregate includes both FullName and ListID, FullName will be ignored. You can use an ItemGroupQuery request to get information about all the item groups that are set up in the QuickBooks file.
|
IQBBaseRef | Y | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | ||
Desc
A descriptive text field.
|
IQBStringType | 4095 chars | ||
Quantity
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 | |
TotalAmount
Total amount of money paid or received. In a receive payment add transaction that has payment amount elements (such as AppliedToTxnAdd lines) you must supply a TotalAmount and the sum of all the PaymentAmount elements must not be greater than the TotalAmount.
|
IQBAmountType | Y | ||
ItemLineRetList
A list of IItemLineRet objects, each representing one line of the item. Each item line is used to track a portion of a transaction that represents the purchase of an “item.”
|
IItemLineRetList | |||
(List
of IItemLineRet Objects)
|
||||
TxnLineID
Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
|
IQBIDType | Y | ||
ItemRef
Depending on the request containing it, ItemRef can refer to an item on any Item list such as ItemDiscount, ItemInventory, and so forth, or it may accept only a subset of item types. For example, here are some requests that impose limits on what items ItemRef can refer to. For PurchaseOrder and Bill requests, ItemRef cannot refer to discount items or sales-tax 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 | |||
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 |
|
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 | |
Cost
If both Quantity and Amount are specified, QuickBooks will use them to calculate Cost. Likewise, if both Quantity and Cost are specified, QuickBooks will use them to calculate the total Amount.
|
IQBPriceType | |||
Amount
A monetary amount.
|
IQBAmountType | |||
CustomerRef
The customer list includes information about the QuickBooks user’s customers and the individual jobs that are being performed for them. A CustomerRef aggregate refers to one of the customers (or customer jobs) on the list. In a request, if a CustomerRef aggregate includes both FullName and ListID, FullName will be ignored. Special cases to note:In SalesReceipt and ReceivePayment requests, CustomerRef refers to the customer or customer job to which the payment is credited.In a TimeTracking request, CustomerRef refers to the customer or customer job to which this time could be billed. If IsBillable is set to true, CustomerRef is required in TimeTrackingAdd. In an ExpenseLineAdd request, if AccountRef refers to an A/P account, CustomerRef must refer to a vendor (not to a customer). If AccountRef refers to any other type of account, the CustomerRef must refer to a customer.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 209 chars | ||
ClassRef
Classes can be used to separate transactions into meaningful categories. (For example, transactions could be classified according to department, business location, or type of work.) In QuickBooks, class tracking is off by default. A ClassRef aggregate refers to one of these named classes. For example, in a TimeTracking message, ClassRef refers to the QuickBooks class into which the timed activity falls. If a ClassRef aggregate includes both FullName and ListID, FullName will be ignored. In an InvoiceAdd request, if you specify a ClassRef for the whole invoice, that same ClassRef is automatically used in the line items. If you want to clear that (that is, have NO ClassRef for the line item, you can clear it in the line item by simply not specifying it in the line item.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
SalesTaxCodeRef
Each item on a sales form is assigned a sales-tax code that indicates whether the item is taxable or non-taxable, and why. Two general codes, which can be modified but not deleted, appear on the sales-tax code list by default:Non-taxable (Name = NON; Desc = Non-Taxable; IsTaxable = false)Taxable (Name = TAX; Desc = Taxable; IsTaxable = true) A sales-tax code can be deleted only if it is no longer associated with any customer, item, or transaction. If the “Do You Charge Sales Tax?” preference within QuickBooks is set to No, QuickBooks will assign the default non-taxable sales-tax code to all sales. A SalesTaxCodeRef aggregate refers to a sales-tax code on the list. In a request, if a SalesTaxCodeRef aggregate includes both FullName and ListID, FullName will be ignored. In a Customer message, SalesTaxCodeRef refers to the sales-tax code that will be used for items related to this customer. In an ItemInventory message, SalesTaxCodeRef refers to the type of sales tax that will be charged for this item, if it is a taxable item and if sales tax is set up within QuickBooks.
|
IQBBaseRef | 6.0 |
||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 6.0 |
||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 3 chars | 6.0 |
|
BillableStatus
The billing status of this item line or expense line.
|
IQBENBillableStatusType | 2.0 | ||
SalesRepRef
A sales representative must be on the Employee, Vendor, or Other Names list within QuickBooks. Sales representative’s names and initials appear on the Rep drop-down list on QuickBooks sales forms. A SalesRepRef refers to a person on the SalesRep list. In a request, if a SalesRepRef aggregate includes both FullName and ListID, FullName will be ignored.
|
IQBBaseRef | 13.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 13.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 5 chars | 13.0 | |
DataExtRetList
A list of IDataExtRet objects, each of which represents a field that has been added to QuickBooks as a data extension.
|
IDataExtRetList | 13.0 | ||
(List
of IDataExtRet Objects)
|
||||
OwnerID
OwnerID refers to the owner of a data extension, and must be 0 or a valid GUID. (Custom fields, which are visible in the QuickBooks UI, always have an OwnerID of 0. ) Usually you would keep your application’s GUID confidential to prevent other applications from accessing your data extensions. But if you want to share data extensions with another application, the applications need to use the same GUID. In this case, each application could use two GUIDs, one for shared data extensions and one for confidential data extensions. (An application can have any number of GUIDs.) When you share a data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
|
IQBGUIDType | |||
DataExtName
The name of the data extension. If this is a custom field, DataExtName will be visible as a label in the QuickBooks user interface. Also because OwnerID and DataExtName together make the data extension unique, and because custom fields all have the same OwnerID of zero, the DataExtName must be a unique value among existing custom fields. In contrast, the DataExtName for private data extensions must be unique only for the specified OwnerID GUID.
|
IQBStringType | 31 chars | Y | |
DataExtType
The field’s data type, which corresponds to a qbXML data type. In an IDataExtDefAdd request object, if this is a custom field, DataExtType must be detSTR255TYPE.
|
IQBENDataExtTypeType | Y | ||
DataExtValue
The data in this field. The maximum length of DataExtValue will depend on the DataExtType of this data extension. For example, if DataExtType is STR255TYPE, the maximum length of DataExtValue is 255 characters. If DataExtType is STR1024TYPE, the maximum size of DataExtValue is 1KB.
|
IQBStringType | Y | ||
DataExtList
A list of IDataExtRet objects, each of which represents a field that has been added to QuickBooks as a data extension.
|
IDataExtList | 13.0 | ||
(List
of IDataExt Objects)
|
||||
OwnerID
OwnerID refers to the owner of a data extension, and must be 0 or a valid GUID. (Custom fields, which are visible in the QuickBooks UI, always have an OwnerID of 0. ) Usually you would keep your application’s GUID confidential to prevent other applications from accessing your data extensions. But if you want to share data extensions with another application, the applications need to use the same GUID. In this case, each application could use two GUIDs, one for shared data extensions and one for confidential data extensions. (An application can have any number of GUIDs.) When you share a data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
|
IQBGUIDType | Y | ||
DataExtName
The name of the data extension. If this is a custom field, DataExtName will be visible as a label in the QuickBooks user interface. Also because OwnerID and DataExtName together make the data extension unique, and because custom fields all have the same OwnerID of zero, the DataExtName must be a unique value among existing custom fields. In contrast, the DataExtName for private data extensions must be unique only for the specified OwnerID GUID.
|
IQBStringType | 31 chars | Y | |
DataExtValue
The data in this field. The maximum length of DataExtValue will depend on the DataExtType of this data extension. For example, if DataExtType is STR255TYPE, the maximum length of DataExtValue is 255 characters. If DataExtType is STR1024TYPE, the maximum size of DataExtValue is 1KB.
|
IQBStringType | Y | ||
OpenAmount
Indicates the amount that is still owed. AmountDue minus any credits or discounts equals the OpenAmount.
|
IQBAmountType | |||
DataExtRetList
A list of IDataExtRet objects, each of which represents a field that has been added to QuickBooks as a data extension.
|
IDataExtRetList | 2.0 | ||
(List
of IDataExtRet Objects)
|
||||
OwnerID
OwnerID refers to the owner of a data extension, and must be 0 or a valid GUID. (Custom fields, which are visible in the QuickBooks UI, always have an OwnerID of 0. ) Usually you would keep your application’s GUID confidential to prevent other applications from accessing your data extensions. But if you want to share data extensions with another application, the applications need to use the same GUID. In this case, each application could use two GUIDs, one for shared data extensions and one for confidential data extensions. (An application can have any number of GUIDs.) When you share a data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
|
IQBGUIDType | |||
DataExtName
The name of the data extension. If this is a custom field, DataExtName will be visible as a label in the QuickBooks user interface. Also because OwnerID and DataExtName together make the data extension unique, and because custom fields all have the same OwnerID of zero, the DataExtName must be a unique value among existing custom fields. In contrast, the DataExtName for private data extensions must be unique only for the specified OwnerID GUID.
|
IQBStringType | 31 chars | Y | |
DataExtType
The field’s data type, which corresponds to a qbXML data type. In an IDataExtDefAdd request object, if this is a custom field, DataExtType must be detSTR255TYPE.
|
IQBENDataExtTypeType | Y | ||
DataExtValue
The data in this field. The maximum length of DataExtValue will depend on the DataExtType of this data extension. For example, if DataExtType is STR255TYPE, the maximum length of DataExtValue is 255 characters. If DataExtType is STR1024TYPE, the maximum size of DataExtValue is 1KB.
|
IQBStringType | Y |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 | <?xml version="1.0" encoding="utf-8"?> <?qbxml version="16.0"?> <QBXML> <QBXMLMsgsRq onError="stopOnError"> <VendorCreditQueryRq metaData="ENUMTYPE" iterator="ENUMTYPE" iteratorID="UUIDTYPE"> <!-- BEGIN OR --> <TxnID >IDTYPE</TxnID> <!-- optional, may repeat --> <!-- OR --> <RefNumber >STRTYPE</RefNumber> <!-- optional, may repeat --> <!-- OR --> <RefNumberCaseSensitive >STRTYPE</RefNumberCaseSensitive> <!-- optional, may repeat --> <!-- OR --> <MaxReturned >INTTYPE</MaxReturned> <!-- optional --> <!-- BEGIN OR --> <ModifiedDateRangeFilter> <!-- optional --> <FromModifiedDate >DATETIMETYPE</FromModifiedDate> <!-- optional --> <ToModifiedDate >DATETIMETYPE</ToModifiedDate> <!-- optional --> </ModifiedDateRangeFilter> <!-- OR --> <TxnDateRangeFilter> <!-- optional --> <!-- BEGIN OR --> <FromTxnDate >DATETYPE</FromTxnDate> <!-- optional --> <ToTxnDate >DATETYPE</ToTxnDate> <!-- optional --> <!-- OR --> <!-- DateMacro may have one of the following values: All, Today, ThisWeek, ThisWeekToDate, ThisMonth, ThisMonthToDate, ThisCalendarQuarter, ThisCalendarQuarterToDate, ThisFiscalQuarter, ThisFiscalQuarterToDate, ThisCalendarYear, ThisCalendarYearToDate, ThisFiscalYear, ThisFiscalYearToDate, Yesterday, LastWeek, LastWeekToDate, LastMonth, LastMonthToDate, LastCalendarQuarter, LastCalendarQuarterToDate, LastFiscalQuarter, LastFiscalQuarterToDate, LastCalendarYear, LastCalendarYearToDate, LastFiscalYear, LastFiscalYearToDate, NextWeek, NextFourWeeks, NextMonth, NextCalendarQuarter, NextCalendarYear, NextFiscalQuarter, NextFiscalYear --> <DateMacro >ENUMTYPE</DateMacro> <!-- optional --> <!-- END OR --> </TxnDateRangeFilter> <!-- END OR --> <EntityFilter> <!-- optional --> <!-- BEGIN OR --> <ListID >IDTYPE</ListID> <!-- optional, may repeat --> <!-- OR --> <FullName >STRTYPE</FullName> <!-- optional, may repeat --> <!-- OR --> <ListIDWithChildren >IDTYPE</ListIDWithChildren> <!-- optional --> <!-- OR --> <FullNameWithChildren >STRTYPE</FullNameWithChildren> <!-- optional --> <!-- END OR --> </EntityFilter> <AccountFilter> <!-- optional --> <!-- BEGIN OR --> <ListID >IDTYPE</ListID> <!-- optional, may repeat --> <!-- OR --> <FullName >STRTYPE</FullName> <!-- optional, may repeat --> <!-- OR --> <ListIDWithChildren >IDTYPE</ListIDWithChildren> <!-- optional --> <!-- OR --> <FullNameWithChildren >STRTYPE</FullNameWithChildren> <!-- optional --> <!-- END OR --> </AccountFilter> <!-- BEGIN OR --> <RefNumberFilter> <!-- optional --> <!-- MatchCriterion may have one of the following values: StartsWith, Contains, EndsWith --> <MatchCriterion >ENUMTYPE</MatchCriterion> <!-- required --> <RefNumber >STRTYPE</RefNumber> <!-- required --> </RefNumberFilter> <!-- OR --> <RefNumberRangeFilter> <!-- optional --> <FromRefNumber >STRTYPE</FromRefNumber> <!-- optional --> <ToRefNumber >STRTYPE</ToRefNumber> <!-- optional --> </RefNumberRangeFilter> <!-- END OR --> <CurrencyFilter> <!-- optional --> <!-- BEGIN OR --> <ListID >IDTYPE</ListID> <!-- optional, may repeat --> <!-- OR --> <FullName >STRTYPE</FullName> <!-- optional, may repeat --> <!-- END OR --> </CurrencyFilter> <!-- END OR --> <IncludeLineItems >BOOLTYPE</IncludeLineItems> <!-- optional --> <IncludeLinkedTxns >BOOLTYPE</IncludeLinkedTxns> <!-- optional --> <IncludeRetElement >STRTYPE</IncludeRetElement> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional, may repeat --> </VendorCreditQueryRq> <VendorCreditQueryRs statusCode="INTTYPE" statusSeverity="STRTYPE" statusMessage="STRTYPE" retCount="INTTYPE" iteratorRemainingCount="INTTYPE" iteratorID="UUIDTYPE"> <VendorCreditRet> <!-- optional, may repeat --> <TxnID >IDTYPE</TxnID> <!-- required --> <TimeCreated >DATETIMETYPE</TimeCreated> <!-- required --> <TimeModified >DATETIMETYPE</TimeModified> <!-- required --> <EditSequence >STRTYPE</EditSequence> <!-- required --> <TxnNumber >INTTYPE</TxnNumber> <!-- optional --> <VendorRef> <!-- required --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </VendorRef> <APAccountRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </APAccountRef> <TxnDate >DATETYPE</TxnDate> <!-- required --> <CreditAmount >AMTTYPE</CreditAmount> <!-- required --> <CurrencyRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </CurrencyRef> <ExchangeRate >FLOATTYPE</ExchangeRate> <!-- optional --> <CreditAmountInHomeCurrency >AMTTYPE</CreditAmountInHomeCurrency> <!-- optional --> <RefNumber >STRTYPE</RefNumber> <!-- optional --> <Memo >STRTYPE</Memo> <!-- optional --> <IsTaxIncluded >BOOLTYPE</IsTaxIncluded> <!-- optional --> <SalesTaxCodeRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </SalesTaxCodeRef> <ExternalGUID >GUIDTYPE</ExternalGUID> <!-- optional --> <LinkedTxn> <!-- optional, may repeat --> <TxnID >IDTYPE</TxnID> <!-- required --> <!-- TxnType may have one of the following values: ARRefundCreditCard, Bill, BillPaymentCheck, BillPaymentCreditCard, BuildAssembly, Charge, Check, CreditCardCharge, CreditCardCredit, CreditMemo, Deposit, Estimate, InventoryAdjustment, Invoice, ItemReceipt, JournalEntry, LiabilityAdjustment, Paycheck, PayrollLiabilityCheck, PurchaseOrder, ReceivePayment, SalesOrder, SalesReceipt, SalesTaxPaymentCheck, Transfer, VendorCredit, YTDAdjustment --> <TxnType >ENUMTYPE</TxnType> <!-- required --> <TxnDate >DATETYPE</TxnDate> <!-- required --> <RefNumber >STRTYPE</RefNumber> <!-- optional --> <!-- LinkType may have one of the following values: AMTTYPE, QUANTYPE --> <LinkType >ENUMTYPE</LinkType> <!-- optional --> <Amount >AMTTYPE</Amount> <!-- required --> </LinkedTxn> <ExpenseLineRet> <!-- optional, may repeat --> <TxnLineID >IDTYPE</TxnLineID> <!-- required --> <AccountRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </AccountRef> <Amount >AMTTYPE</Amount> <!-- optional --> <Memo >STRTYPE</Memo> <!-- optional --> <CustomerRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </CustomerRef> <ClassRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ClassRef> <SalesTaxCodeRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </SalesTaxCodeRef> <!-- BillableStatus may have one of the following values: Billable, NotBillable, HasBeenBilled --> <BillableStatus >ENUMTYPE</BillableStatus> <!-- optional --> <SalesRepRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </SalesRepRef> <DataExtRet> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional --> <DataExtName >STRTYPE</DataExtName> <!-- required --> <!-- DataExtType may have one of the following values: AMTTYPE, DATETIMETYPE, INTTYPE, PERCENTTYPE, PRICETYPE, QUANTYPE, STR1024TYPE, STR255TYPE --> <DataExtType >ENUMTYPE</DataExtType> <!-- required --> <DataExtValue >STRTYPE</DataExtValue> <!-- required --> </DataExtRet> </ExpenseLineRet> <!-- BEGIN OR --> <ItemLineRet> <!-- optional --> <TxnLineID >IDTYPE</TxnLineID> <!-- required --> <ItemRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ItemRef> <InventorySiteRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </InventorySiteRef> <InventorySiteLocationRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </InventorySiteLocationRef> <!-- BEGIN OR --> <SerialNumber >STRTYPE</SerialNumber> <!-- optional --> <!-- OR --> <LotNumber >STRTYPE</LotNumber> <!-- optional --> <!-- END OR --> <ExpirationDateForSerialLotNumber>STRTYPE</ExpirationDateForSerialLotNumber> <!-- optional --> <Desc >STRTYPE</Desc> <!-- optional --> <Quantity >QUANTYPE</Quantity> <!-- optional --> <UnitOfMeasure >STRTYPE</UnitOfMeasure> <!-- optional --> <OverrideUOMSetRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </OverrideUOMSetRef> <Cost >PRICETYPE</Cost> <!-- optional --> <Amount >AMTTYPE</Amount> <!-- optional --> <CustomerRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </CustomerRef> <ClassRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ClassRef> <SalesTaxCodeRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </SalesTaxCodeRef> <!-- BillableStatus may have one of the following values: Billable, NotBillable, HasBeenBilled --> <BillableStatus >ENUMTYPE</BillableStatus> <!-- optional --> <SalesRepRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </SalesRepRef> <DataExtRet> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional --> <DataExtName >STRTYPE</DataExtName> <!-- required --> <!-- DataExtType may have one of the following values: AMTTYPE, DATETIMETYPE, INTTYPE, PERCENTTYPE, PRICETYPE, QUANTYPE, STR1024TYPE, STR255TYPE --> <DataExtType >ENUMTYPE</DataExtType> <!-- required --> <DataExtValue >STRTYPE</DataExtValue> <!-- required --> </DataExtRet> </ItemLineRet> <!-- OR --> <ItemGroupLineRet> <!-- optional --> <TxnLineID >IDTYPE</TxnLineID> <!-- required --> <ItemGroupRef> <!-- required --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ItemGroupRef> <Desc >STRTYPE</Desc> <!-- optional --> <Quantity >QUANTYPE</Quantity> <!-- optional --> <UnitOfMeasure >STRTYPE</UnitOfMeasure> <!-- optional --> <OverrideUOMSetRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </OverrideUOMSetRef> <TotalAmount >AMTTYPE</TotalAmount> <!-- required --> <ItemLineRet> <!-- optional, may repeat --> <TxnLineID >IDTYPE</TxnLineID> <!-- required --> <ItemRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ItemRef> <InventorySiteRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </InventorySiteRef> <InventorySiteLocationRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </InventorySiteLocationRef> <!-- BEGIN OR --> <SerialNumber >STRTYPE</SerialNumber> <!-- optional --> <!-- OR --> <LotNumber >STRTYPE</LotNumber> <!-- optional --> <!-- END OR --> <ExpirationDateForSerialLotNumber>STRTYPE</ExpirationDateForSerialLotNumber> <!-- optional --> <Desc >STRTYPE</Desc> <!-- optional --> <Quantity >QUANTYPE</Quantity> <!-- optional --> <UnitOfMeasure >STRTYPE</UnitOfMeasure> <!-- optional --> <OverrideUOMSetRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </OverrideUOMSetRef> <Cost >PRICETYPE</Cost> <!-- optional --> <Amount >AMTTYPE</Amount> <!-- optional --> <CustomerRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </CustomerRef> <ClassRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ClassRef> <SalesTaxCodeRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </SalesTaxCodeRef> <!-- BillableStatus may have one of the following values: Billable, NotBillable, HasBeenBilled --> <BillableStatus >ENUMTYPE</BillableStatus> <!-- optional --> <SalesRepRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </SalesRepRef> <DataExtRet> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional --> <DataExtName >STRTYPE</DataExtName> <!-- required --> <!-- DataExtType may have one of the following values: AMTTYPE, DATETIMETYPE, INTTYPE, PERCENTTYPE, PRICETYPE, QUANTYPE, STR1024TYPE, STR255TYPE --> <DataExtType >ENUMTYPE</DataExtType> <!-- required --> <DataExtValue >STRTYPE</DataExtValue> <!-- required --> </DataExtRet> </ItemLineRet> <DataExt> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- required --> <DataExtName >STRTYPE</DataExtName> <!-- required --> <DataExtValue >STRTYPE</DataExtValue> <!-- required --> </DataExt> </ItemGroupLineRet> <!-- END OR --> <OpenAmount >AMTTYPE</OpenAmount> <!-- optional --> <DataExtRet> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional --> <DataExtName >STRTYPE</DataExtName> <!-- required --> <!-- DataExtType may have one of the following values: AMTTYPE, DATETIMETYPE, INTTYPE, PERCENTTYPE, PRICETYPE, QUANTYPE, STR1024TYPE, STR255TYPE --> <DataExtType >ENUMTYPE</DataExtType> <!-- required --> <DataExtValue >STRTYPE</DataExtValue> <!-- required --> </DataExtRet> </VendorCreditRet> </VendorCreditQueryRs> </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 | '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 DoVendorCreditQuery()
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
BuildVendorCreditQueryRq(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
WalkVendorCreditQueryRs(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 BuildVendorCreditQueryRq(requestMsgSet as IMsgSetRequest)
Dim VendorCreditQueryRq as IVendorCreditQuery
VendorCreditQueryRq= requestMsgSet.AppendVendorCreditQueryRq()
Dim ORTxnQueryElementType24024 as String
ORTxnQueryElementType24024 = "TxnIDList"
if (ORTxnQueryElementType24024 == "TxnIDList") then
'Set field value for TxnIDList
'May create more than one of these if needed
VendorCreditQueryRq.ORTxnQuery.TxnIDList.Add("200000-1011023419")
End If
if (ORTxnQueryElementType24024 == "RefNumberList") then
'Set field value for RefNumberList
'May create more than one of these if needed
VendorCreditQueryRq.ORTxnQuery.RefNumberList.Add("ab")
End If
if (ORTxnQueryElementType24024 == "RefNumberCaseSensitiveList") then
'Set field value for RefNumberCaseSensitiveList
'May create more than one of these if needed
VendorCreditQueryRq.ORTxnQuery.RefNumberCaseSensitiveList.Add("ab")
End If
if (ORTxnQueryElementType24024 == "TxnFilter") then
'Set field value for MaxReturned
VendorCreditQueryRq.ORTxnQuery.TxnFilter.MaxReturned.SetValue(6)
Dim ORDateRangeFilterElementType24025 as String
ORDateRangeFilterElementType24025 = "ModifiedDateRangeFilter"
if (ORDateRangeFilterElementType24025 == "ModifiedDateRangeFilter") then
'Set field value for FromModifiedDate
VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
'Set field value for ToModifiedDate
VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
End If
if (ORDateRangeFilterElementType24025 == "TxnDateRangeFilter") then
Dim ORTxnDateRangeFilterElementType24026 as String
ORTxnDateRangeFilterElementType24026 = "TxnDateFilter"
if (ORTxnDateRangeFilterElementType24026 == "TxnDateFilter") then
'Set field value for FromTxnDate
VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007"))
'Set field value for ToTxnDate
VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007"))
End If
if (ORTxnDateRangeFilterElementType24026 == "DateMacro") then
'Set field value for DateMacro
VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll)
End If
End If
Dim OREntityFilterElementType24027 as String
OREntityFilterElementType24027 = "ListIDList"
if (OREntityFilterElementType24027 == "ListIDList") then
'Set field value for ListIDList
'May create more than one of these if needed
VendorCreditQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.ListIDList.Add("200000-1011023419")
End If
if (OREntityFilterElementType24027 == "FullNameList") then
'Set field value for FullNameList
'May create more than one of these if needed
VendorCreditQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.FullNameList.Add("ab")
End If
if (OREntityFilterElementType24027 == "ListIDWithChildren") then
'Set field value for ListIDWithChildren
VendorCreditQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.ListIDWithChildren.SetValue("200000-1011023419")
End If
if (OREntityFilterElementType24027 == "FullNameWithChildren") then
'Set field value for FullNameWithChildren
VendorCreditQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.FullNameWithChildren.SetValue("ab")
End If
Dim ORAccountFilterElementType24028 as String
ORAccountFilterElementType24028 = "ListIDList"
if (ORAccountFilterElementType24028 == "ListIDList") then
'Set field value for ListIDList
'May create more than one of these if needed
VendorCreditQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.ListIDList.Add("200000-1011023419")
End If
if (ORAccountFilterElementType24028 == "FullNameList") then
'Set field value for FullNameList
'May create more than one of these if needed
VendorCreditQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.FullNameList.Add("ab")
End If
if (ORAccountFilterElementType24028 == "ListIDWithChildren") then
'Set field value for ListIDWithChildren
VendorCreditQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.ListIDWithChildren.SetValue("200000-1011023419")
End If
if (ORAccountFilterElementType24028 == "FullNameWithChildren") then
'Set field value for FullNameWithChildren
VendorCreditQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.FullNameWithChildren.SetValue("ab")
End If
Dim ORRefNumberFilterElementType24029 as String
ORRefNumberFilterElementType24029 = "RefNumberFilter"
if (ORRefNumberFilterElementType24029 == "RefNumberFilter") then
'Set field value for MatchCriterion
VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.MatchCriterion.SetValue(ENMatchCriterion.mcStartsWith)
'Set field value for RefNumber
VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.RefNumber.SetValue("ab")
End If
if (ORRefNumberFilterElementType24029 == "RefNumberRangeFilter") then
'Set field value for FromRefNumber
VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberRangeFilter.FromRefNumber.SetValue("ab")
'Set field value for ToRefNumber
VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberRangeFilter.ToRefNumber.SetValue("ab")
End If
Dim ORCurrencyFilterElementType24030 as String
ORCurrencyFilterElementType24030 = "ListIDList"
if (ORCurrencyFilterElementType24030 == "ListIDList") then
'Set field value for ListIDList
'May create more than one of these if needed
VendorCreditQueryRq.ORTxnQuery.TxnFilter.CurrencyFilter.ORCurrencyFilter.ListIDList.Add("200000-1011023419")
End If
if (ORCurrencyFilterElementType24030 == "FullNameList") then
'Set field value for FullNameList
'May create more than one of these if needed
VendorCreditQueryRq.ORTxnQuery.TxnFilter.CurrencyFilter.ORCurrencyFilter.FullNameList.Add("ab")
End If
End If
'Set field value for IncludeLineItems
VendorCreditQueryRq.IncludeLineItems.SetValue(True)
'Set field value for IncludeLinkedTxns
VendorCreditQueryRq.IncludeLinkedTxns.SetValue(True)
'Set field value for IncludeRetElementList
'May create more than one of these if needed
VendorCreditQueryRq.IncludeRetElementList.Add("ab")
'Set field value for OwnerIDList
'May create more than one of these if needed
VendorCreditQueryRq.OwnerIDList.Add(System.Guid.NewGuid().ToString())
End Sub
Public Sub WalkVendorCreditQueryRs( 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.rtVendorCreditQueryRs) then
'upcast to more specific type here, this is safe because we checked with response.Type check above
Dim VendorCreditRet as IVendorCreditRetList
VendorCreditRet = CType(response.Detail,IVendorCreditRetList)
WalkVendorCreditRet(VendorCreditRet)
End If
End If
End If
Next j
End Sub
Public Sub WalkVendorCreditRet(VendorCreditRet as IVendorCreditRetList)
if (VendorCreditRet is nothing) then
Exit Sub
End If
'Go through all the elements of IVendorCreditRetList
'Get value of TxnID
Dim TxnID24031 as String
TxnID24031 = VendorCreditRet.TxnID.GetValue()
'Get value of TimeCreated
Dim TimeCreated24032 as DateTime
TimeCreated24032 = VendorCreditRet.TimeCreated.GetValue()
'Get value of TimeModified
Dim TimeModified24033 as DateTime
TimeModified24033 = VendorCreditRet.TimeModified.GetValue()
'Get value of EditSequence
Dim EditSequence24034 as String
EditSequence24034 = VendorCreditRet.EditSequence.GetValue()
'Get value of TxnNumber
if ( not VendorCreditRet.TxnNumber is nothing) then
Dim TxnNumber24035 as Integer
TxnNumber24035 = VendorCreditRet.TxnNumber.GetValue()
End If
'Get value of ListID
if ( not VendorCreditRet.VendorRef.ListID is nothing) then
Dim ListID24036 as String
ListID24036 = VendorCreditRet.VendorRef.ListID.GetValue()
End If
'Get value of FullName
if ( not VendorCreditRet.VendorRef.FullName is nothing) then
Dim FullName24037 as String
FullName24037 = VendorCreditRet.VendorRef.FullName.GetValue()
End If
if (not VendorCreditRet.APAccountRef. is nothing) then
'Get value of ListID
if ( not VendorCreditRet.APAccountRef.ListID is nothing) then
Dim ListID24038 as String
ListID24038 = VendorCreditRet.APAccountRef.ListID.GetValue()
End If
'Get value of FullName
if ( not VendorCreditRet.APAccountRef.FullName is nothing) then
Dim FullName24039 as String
FullName24039 = VendorCreditRet.APAccountRef.FullName.GetValue()
End If
End If
'Get value of TxnDate
Dim TxnDate24040 as DateTime
TxnDate24040 = VendorCreditRet.TxnDate.GetValue()
'Get value of CreditAmount
Dim CreditAmount24041 as Double
CreditAmount24041 = VendorCreditRet.CreditAmount.GetValue()
if (not VendorCreditRet.CurrencyRef. is nothing) then
'Get value of ListID
if ( not VendorCreditRet.CurrencyRef.ListID is nothing) then
Dim ListID24042 as String
ListID24042 = VendorCreditRet.CurrencyRef.ListID.GetValue()
End If
'Get value of FullName
if ( not VendorCreditRet.CurrencyRef.FullName is nothing) then
Dim FullName24043 as String
FullName24043 = VendorCreditRet.CurrencyRef.FullName.GetValue()
End If
End If
'Get value of ExchangeRate
if ( not VendorCreditRet.ExchangeRate is nothing) then
Dim ExchangeRate24044 as IQBFloatType
ExchangeRate24044 = VendorCreditRet.ExchangeRate.GetValue()
End If
'Get value of CreditAmountInHomeCurrency
if ( not VendorCreditRet.CreditAmountInHomeCurrency is nothing) then
Dim CreditAmountInHomeCurrency24045 as Double
CreditAmountInHomeCurrency24045 = VendorCreditRet.CreditAmountInHomeCurrency.GetValue()
End If
'Get value of RefNumber
if ( not VendorCreditRet.RefNumber is nothing) then
Dim RefNumber24046 as String
RefNumber24046 = VendorCreditRet.RefNumber.GetValue()
End If
'Get value of Memo
if ( not VendorCreditRet.Memo is nothing) then
Dim Memo24047 as String
Memo24047 = VendorCreditRet.Memo.GetValue()
End If
'Get value of IsTaxIncluded
if ( not VendorCreditRet.IsTaxIncluded is nothing) then
Dim IsTaxIncluded24048 as Boolean
IsTaxIncluded24048 = VendorCreditRet.IsTaxIncluded.GetValue()
End If
if (not VendorCreditRet.SalesTaxCodeRef. is nothing) then
'Get value of ListID
if ( not VendorCreditRet.SalesTaxCodeRef.ListID is nothing) then
Dim ListID24049 as String
ListID24049 = VendorCreditRet.SalesTaxCodeRef.ListID.GetValue()
End If
'Get value of FullName
if ( not VendorCreditRet.SalesTaxCodeRef.FullName is nothing) then
Dim FullName24050 as String
FullName24050 = VendorCreditRet.SalesTaxCodeRef.FullName.GetValue()
End If
End If
'Get value of ExternalGUID
if ( not VendorCreditRet.ExternalGUID is nothing) then
Dim ExternalGUID24051 as String
ExternalGUID24051 = VendorCreditRet.ExternalGUID.GetValue()
End If
if (not VendorCreditRet.LinkedTxnList is nothing)
Dim i24052 as Integer
for i24052 = 0 to VendorCreditRet.LinkedTxnList.Count - 1
Dim LinkedTxn as ILinkedTxn
LinkedTxn = VendorCreditRet.LinkedTxnList.GetAt(i24052)
'Get value of TxnID
Dim TxnID24053 as String
TxnID24053 = LinkedTxnTxnID.GetValue()
'Get value of TxnType
Dim TxnType24054 as ENTxnType
TxnType24054 = LinkedTxnTxnType.GetValue()
'Get value of TxnDate
Dim TxnDate24055 as DateTime
TxnDate24055 = LinkedTxnTxnDate.GetValue()
'Get value of RefNumber
if ( not LinkedTxnRefNumber is nothing) then
Dim RefNumber24056 as String
RefNumber24056 = LinkedTxnRefNumber.GetValue()
End If
'Get value of LinkType
if ( not LinkedTxnLinkType is nothing) then
Dim LinkType24057 as ENLinkType
LinkType24057 = LinkedTxnLinkType.GetValue()
End If
'Get value of Amount
Dim Amount24058 as Double
Amount24058 = LinkedTxnAmount.GetValue()
Next i24052
End If
if (not VendorCreditRet.ExpenseLineRetList is nothing)
Dim i24059 as Integer
for i24059 = 0 to VendorCreditRet.ExpenseLineRetList.Count - 1
Dim ExpenseLineRet as IExpenseLineRet
ExpenseLineRet = VendorCreditRet.ExpenseLineRetList.GetAt(i24059)
'Get value of TxnLineID
Dim TxnLineID24060 as String
TxnLineID24060 = ExpenseLineRetTxnLineID.GetValue()
if (not ExpenseLineRetAccountRef. is nothing) then
'Get value of ListID
if ( not ExpenseLineRetAccountRef.ListID is nothing) then
Dim ListID24061 as String
ListID24061 = ExpenseLineRetAccountRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ExpenseLineRetAccountRef.FullName is nothing) then
Dim FullName24062 as String
FullName24062 = ExpenseLineRetAccountRef.FullName.GetValue()
End If
End If
'Get value of Amount
if ( not ExpenseLineRetAmount is nothing) then
Dim Amount24063 as Double
Amount24063 = ExpenseLineRetAmount.GetValue()
End If
'Get value of Memo
if ( not ExpenseLineRetMemo is nothing) then
Dim Memo24064 as String
Memo24064 = ExpenseLineRetMemo.GetValue()
End If
if (not ExpenseLineRetCustomerRef. is nothing) then
'Get value of ListID
if ( not ExpenseLineRetCustomerRef.ListID is nothing) then
Dim ListID24065 as String
ListID24065 = ExpenseLineRetCustomerRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ExpenseLineRetCustomerRef.FullName is nothing) then
Dim FullName24066 as String
FullName24066 = ExpenseLineRetCustomerRef.FullName.GetValue()
End If
End If
if (not ExpenseLineRetClassRef. is nothing) then
'Get value of ListID
if ( not ExpenseLineRetClassRef.ListID is nothing) then
Dim ListID24067 as String
ListID24067 = ExpenseLineRetClassRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ExpenseLineRetClassRef.FullName is nothing) then
Dim FullName24068 as String
FullName24068 = ExpenseLineRetClassRef.FullName.GetValue()
End If
End If
if (not ExpenseLineRetSalesTaxCodeRef. is nothing) then
'Get value of ListID
if ( not ExpenseLineRetSalesTaxCodeRef.ListID is nothing) then
Dim ListID24069 as String
ListID24069 = ExpenseLineRetSalesTaxCodeRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ExpenseLineRetSalesTaxCodeRef.FullName is nothing) then
Dim FullName24070 as String
FullName24070 = ExpenseLineRetSalesTaxCodeRef.FullName.GetValue()
End If
End If
'Get value of BillableStatus
if ( not ExpenseLineRetBillableStatus is nothing) then
Dim BillableStatus24071 as ENBillableStatus
BillableStatus24071 = ExpenseLineRetBillableStatus.GetValue()
End If
if (not ExpenseLineRetSalesRepRef. is nothing) then
'Get value of ListID
if ( not ExpenseLineRetSalesRepRef.ListID is nothing) then
Dim ListID24072 as String
ListID24072 = ExpenseLineRetSalesRepRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ExpenseLineRetSalesRepRef.FullName is nothing) then
Dim FullName24073 as String
FullName24073 = ExpenseLineRetSalesRepRef.FullName.GetValue()
End If
End If
if (not ExpenseLineRetDataExtRetList is nothing)
Dim i24074 as Integer
for i24074 = 0 to ExpenseLineRetDataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = ExpenseLineRetDataExtRetList.GetAt(i24074)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID24075 as String
OwnerID24075 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName24076 as String
DataExtName24076 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType24077 as ENDataExtType
DataExtType24077 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue24078 as String
DataExtValue24078 = DataExtRetDataExtValue.GetValue()
Next i24074
End If
Next i24059
End If
if (not VendorCreditRet.ORItemLineRetList is nothing) then
Dim i24079 as Integer
for i24079 = 0 to VendorCreditRet.ORItemLineRetList.Count - 1
Dim ORItemLineRet24080 as IORItemLineRet
ORItemLineRet24080 = VendorCreditRet.ORItemLineRetList.GetAt(i24079)
if (not ORItemLineRet24080.ItemLineRet is nothing) then
if (not ORItemLineRet24080.ItemLineRet. is nothing) then
'Get value of TxnLineID
Dim TxnLineID24081 as String
TxnLineID24081 = ORItemLineRet24080.ItemLineRet.TxnLineID.GetValue()
if (not ORItemLineRet24080.ItemLineRet.ItemRef. is nothing) then
'Get value of ListID
if ( not ORItemLineRet24080.ItemLineRet.ItemRef.ListID is nothing) then
Dim ListID24082 as String
ListID24082 = ORItemLineRet24080.ItemLineRet.ItemRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORItemLineRet24080.ItemLineRet.ItemRef.FullName is nothing) then
Dim FullName24083 as String
FullName24083 = ORItemLineRet24080.ItemLineRet.ItemRef.FullName.GetValue()
End If
End If
if (not ORItemLineRet24080.ItemLineRet.InventorySiteRef. is nothing) then
'Get value of ListID
if ( not ORItemLineRet24080.ItemLineRet.InventorySiteRef.ListID is nothing) then
Dim ListID24084 as String
ListID24084 = ORItemLineRet24080.ItemLineRet.InventorySiteRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORItemLineRet24080.ItemLineRet.InventorySiteRef.FullName is nothing) then
Dim FullName24085 as String
FullName24085 = ORItemLineRet24080.ItemLineRet.InventorySiteRef.FullName.GetValue()
End If
End If
if (not ORItemLineRet24080.ItemLineRet.InventorySiteLocationRef. is nothing) then
'Get value of ListID
if ( not ORItemLineRet24080.ItemLineRet.InventorySiteLocationRef.ListID is nothing) then
Dim ListID24086 as String
ListID24086 = ORItemLineRet24080.ItemLineRet.InventorySiteLocationRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORItemLineRet24080.ItemLineRet.InventorySiteLocationRef.FullName is nothing) then
Dim FullName24087 as String
FullName24087 = ORItemLineRet24080.ItemLineRet.InventorySiteLocationRef.FullName.GetValue()
End If
End If
if (not ORItemLineRet24080.ItemLineRet.ORSerialLotNumber is nothing) then
if (not ORItemLineRet24080.ItemLineRet.ORSerialLotNumber.SerialNumber is nothing) then
'Get value of SerialNumber
if ( not ORItemLineRet24080.ItemLineRet.ORSerialLotNumber.SerialNumber is nothing) then
Dim SerialNumber24089 as String
SerialNumber24089 = ORItemLineRet24080.ItemLineRet.ORSerialLotNumber.SerialNumber.GetValue()
End If
End If
if (not ORItemLineRet24080.ItemLineRet.ORSerialLotNumber.LotNumber is nothing) then
'Get value of LotNumber
if ( not ORItemLineRet24080.ItemLineRet.ORSerialLotNumber.LotNumber is nothing) then
Dim LotNumber24090 as String
LotNumber24090 = ORItemLineRet24080.ItemLineRet.ORSerialLotNumber.LotNumber.GetValue()
End If
End If
End If
'Get value of ExpirationDateForSerialLotNumber
if ( not ORItemLineRet24080.ItemLineRet.ExpirationDateForSerialLotNumber is nothing) then
Dim ExpDate as String
ExpDate = ORItemLineRet24080.ItemLineRet.ExpirationDateForSerialLotNumber.GetValue()
End If
'Get value of Desc
if ( not ORItemLineRet24080.ItemLineRet.Desc is nothing) then
Dim Desc24091 as String
Desc24091 = ORItemLineRet24080.ItemLineRet.Desc.GetValue()
End If
'Get value of Quantity
if ( not ORItemLineRet24080.ItemLineRet.Quantity is nothing) then
Dim Quantity24092 as Integer
Quantity24092 = ORItemLineRet24080.ItemLineRet.Quantity.GetValue()
End If
'Get value of UnitOfMeasure
if ( not ORItemLineRet24080.ItemLineRet.UnitOfMeasure is nothing) then
Dim UnitOfMeasure24093 as String
UnitOfMeasure24093 = ORItemLineRet24080.ItemLineRet.UnitOfMeasure.GetValue()
End If
if (not ORItemLineRet24080.ItemLineRet.OverrideUOMSetRef. is nothing) then
'Get value of ListID
if ( not ORItemLineRet24080.ItemLineRet.OverrideUOMSetRef.ListID is nothing) then
Dim ListID24094 as String
ListID24094 = ORItemLineRet24080.ItemLineRet.OverrideUOMSetRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORItemLineRet24080.ItemLineRet.OverrideUOMSetRef.FullName is nothing) then
Dim FullName24095 as String
FullName24095 = ORItemLineRet24080.ItemLineRet.OverrideUOMSetRef.FullName.GetValue()
End If
End If
'Get value of Cost
if ( not ORItemLineRet24080.ItemLineRet.Cost is nothing) then
Dim Cost24096 as Double
Cost24096 = ORItemLineRet24080.ItemLineRet.Cost.GetValue()
End If
'Get value of Amount
if ( not ORItemLineRet24080.ItemLineRet.Amount is nothing) then
Dim Amount24097 as Double
Amount24097 = ORItemLineRet24080.ItemLineRet.Amount.GetValue()
End If
if (not ORItemLineRet24080.ItemLineRet.CustomerRef. is nothing) then
'Get value of ListID
if ( not ORItemLineRet24080.ItemLineRet.CustomerRef.ListID is nothing) then
Dim ListID24098 as String
ListID24098 = ORItemLineRet24080.ItemLineRet.CustomerRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORItemLineRet24080.ItemLineRet.CustomerRef.FullName is nothing) then
Dim FullName24099 as String
FullName24099 = ORItemLineRet24080.ItemLineRet.CustomerRef.FullName.GetValue()
End If
End If
if (not ORItemLineRet24080.ItemLineRet.ClassRef. is nothing) then
'Get value of ListID
if ( not ORItemLineRet24080.ItemLineRet.ClassRef.ListID is nothing) then
Dim ListID24100 as String
ListID24100 = ORItemLineRet24080.ItemLineRet.ClassRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORItemLineRet24080.ItemLineRet.ClassRef.FullName is nothing) then
Dim FullName24101 as String
FullName24101 = ORItemLineRet24080.ItemLineRet.ClassRef.FullName.GetValue()
End If
End If
if (not ORItemLineRet24080.ItemLineRet.SalesTaxCodeRef. is nothing) then
'Get value of ListID
if ( not ORItemLineRet24080.ItemLineRet.SalesTaxCodeRef.ListID is nothing) then
Dim ListID24102 as String
ListID24102 = ORItemLineRet24080.ItemLineRet.SalesTaxCodeRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORItemLineRet24080.ItemLineRet.SalesTaxCodeRef.FullName is nothing) then
Dim FullName24103 as String
FullName24103 = ORItemLineRet24080.ItemLineRet.SalesTaxCodeRef.FullName.GetValue()
End If
End If
'Get value of BillableStatus
if ( not ORItemLineRet24080.ItemLineRet.BillableStatus is nothing) then
Dim BillableStatus24104 as ENBillableStatus
BillableStatus24104 = ORItemLineRet24080.ItemLineRet.BillableStatus.GetValue()
End If
if (not ORItemLineRet24080.ItemLineRet.SalesRepRef. is nothing) then
'Get value of ListID
if ( not ORItemLineRet24080.ItemLineRet.SalesRepRef.ListID is nothing) then
Dim ListID24105 as String
ListID24105 = ORItemLineRet24080.ItemLineRet.SalesRepRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORItemLineRet24080.ItemLineRet.SalesRepRef.FullName is nothing) then
Dim FullName24106 as String
FullName24106 = ORItemLineRet24080.ItemLineRet.SalesRepRef.FullName.GetValue()
End If
End If
if (not ORItemLineRet24080.ItemLineRet.DataExtRetList is nothing)
Dim i24107 as Integer
for i24107 = 0 to ORItemLineRet24080.ItemLineRet.DataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = ORItemLineRet24080.ItemLineRet.DataExtRetList.GetAt(i24107)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID24108 as String
OwnerID24108 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName24109 as String
DataExtName24109 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType24110 as ENDataExtType
DataExtType24110 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue24111 as String
DataExtValue24111 = DataExtRetDataExtValue.GetValue()
Next i24107
End If
End If
End If
if (not ORItemLineRet24080.ItemGroupLineRet is nothing) then
if (not ORItemLineRet24080.ItemGroupLineRet. is nothing) then
'Get value of TxnLineID
Dim TxnLineID24112 as String
TxnLineID24112 = ORItemLineRet24080.ItemGroupLineRet.TxnLineID.GetValue()
'Get value of ListID
if ( not ORItemLineRet24080.ItemGroupLineRet.ItemGroupRef.ListID is nothing) then
Dim ListID24113 as String
ListID24113 = ORItemLineRet24080.ItemGroupLineRet.ItemGroupRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORItemLineRet24080.ItemGroupLineRet.ItemGroupRef.FullName is nothing) then
Dim FullName24114 as String
FullName24114 = ORItemLineRet24080.ItemGroupLineRet.ItemGroupRef.FullName.GetValue()
End If
'Get value of Desc
if ( not ORItemLineRet24080.ItemGroupLineRet.Desc is nothing) then
Dim Desc24115 as String
Desc24115 = ORItemLineRet24080.ItemGroupLineRet.Desc.GetValue()
End If
'Get value of Quantity
if ( not ORItemLineRet24080.ItemGroupLineRet.Quantity is nothing) then
Dim Quantity24116 as Integer
Quantity24116 = ORItemLineRet24080.ItemGroupLineRet.Quantity.GetValue()
End If
'Get value of UnitOfMeasure
if ( not ORItemLineRet24080.ItemGroupLineRet.UnitOfMeasure is nothing) then
Dim UnitOfMeasure24117 as String
UnitOfMeasure24117 = ORItemLineRet24080.ItemGroupLineRet.UnitOfMeasure.GetValue()
End If
if (not ORItemLineRet24080.ItemGroupLineRet.OverrideUOMSetRef. is nothing) then
'Get value of ListID
if ( not ORItemLineRet24080.ItemGroupLineRet.OverrideUOMSetRef.ListID is nothing) then
Dim ListID24118 as String
ListID24118 = ORItemLineRet24080.ItemGroupLineRet.OverrideUOMSetRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORItemLineRet24080.ItemGroupLineRet.OverrideUOMSetRef.FullName is nothing) then
Dim FullName24119 as String
FullName24119 = ORItemLineRet24080.ItemGroupLineRet.OverrideUOMSetRef.FullName.GetValue()
End If
End If
'Get value of TotalAmount
Dim TotalAmount24120 as Double
TotalAmount24120 = ORItemLineRet24080.ItemGroupLineRet.TotalAmount.GetValue()
if (not ORItemLineRet24080.ItemGroupLineRet.ItemLineRetList is nothing)
Dim i24121 as Integer
for i24121 = 0 to ORItemLineRet24080.ItemGroupLineRet.ItemLineRetList.Count - 1
Dim ItemLineRet as IItemLineRet
ItemLineRet = ORItemLineRet24080.ItemGroupLineRet.ItemLineRetList.GetAt(i24121)
'Get value of TxnLineID
Dim TxnLineID24122 as String
TxnLineID24122 = ItemLineRetTxnLineID.GetValue()
if (not ItemLineRetItemRef. is nothing) then
'Get value of ListID
if ( not ItemLineRetItemRef.ListID is nothing) then
Dim ListID24123 as String
ListID24123 = ItemLineRetItemRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ItemLineRetItemRef.FullName is nothing) then
Dim FullName24124 as String
FullName24124 = ItemLineRetItemRef.FullName.GetValue()
End If
End If
if (not ItemLineRetInventorySiteRef. is nothing) then
'Get value of ListID
if ( not ItemLineRetInventorySiteRef.ListID is nothing) then
Dim ListID24125 as String
ListID24125 = ItemLineRetInventorySiteRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ItemLineRetInventorySiteRef.FullName is nothing) then
Dim FullName24126 as String
FullName24126 = ItemLineRetInventorySiteRef.FullName.GetValue()
End If
End If
if (not ItemLineRetInventorySiteLocationRef. is nothing) then
'Get value of ListID
if ( not ItemLineRetInventorySiteLocationRef.ListID is nothing) then
Dim ListID24127 as String
ListID24127 = ItemLineRetInventorySiteLocationRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ItemLineRetInventorySiteLocationRef.FullName is nothing) then
Dim FullName24128 as String
FullName24128 = ItemLineRetInventorySiteLocationRef.FullName.GetValue()
End If
End If
if (not ItemLineRetORSerialLotNumber is nothing) then
if (not ItemLineRetORSerialLotNumber.SerialNumber is nothing) then
'Get value of SerialNumber
if ( not ItemLineRetORSerialLotNumber.SerialNumber is nothing) then
Dim SerialNumber24130 as String
SerialNumber24130 = ItemLineRetORSerialLotNumber.SerialNumber.GetValue()
End If
End If
if (not ItemLineRetORSerialLotNumber.LotNumber is nothing) then
'Get value of LotNumber
if ( not ItemLineRetORSerialLotNumber.LotNumber is nothing) then
Dim LotNumber24131 as String
LotNumber24131 = ItemLineRetORSerialLotNumber.LotNumber.GetValue()
End If
End If
End If
'Get value of ExpirationDateForSerialLotNumber
if ( not ItemLineRetExpirationDateForSerialLotNumber is nothing) then
Dim ExpDate as String
ExpDate = ItemLineRetExpirationDateForSerialLotNumber.GetValue()
End If
'Get value of Desc
if ( not ItemLineRetDesc is nothing) then
Dim Desc24132 as String
Desc24132 = ItemLineRetDesc.GetValue()
End If
'Get value of Quantity
if ( not ItemLineRetQuantity is nothing) then
Dim Quantity24133 as Integer
Quantity24133 = ItemLineRetQuantity.GetValue()
End If
'Get value of UnitOfMeasure
if ( not ItemLineRetUnitOfMeasure is nothing) then
Dim UnitOfMeasure24134 as String
UnitOfMeasure24134 = ItemLineRetUnitOfMeasure.GetValue()
End If
if (not ItemLineRetOverrideUOMSetRef. is nothing) then
'Get value of ListID
if ( not ItemLineRetOverrideUOMSetRef.ListID is nothing) then
Dim ListID24135 as String
ListID24135 = ItemLineRetOverrideUOMSetRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ItemLineRetOverrideUOMSetRef.FullName is nothing) then
Dim FullName24136 as String
FullName24136 = ItemLineRetOverrideUOMSetRef.FullName.GetValue()
End If
End If
'Get value of Cost
if ( not ItemLineRetCost is nothing) then
Dim Cost24137 as Double
Cost24137 = ItemLineRetCost.GetValue()
End If
'Get value of Amount
if ( not ItemLineRetAmount is nothing) then
Dim Amount24138 as Double
Amount24138 = ItemLineRetAmount.GetValue()
End If
if (not ItemLineRetCustomerRef. is nothing) then
'Get value of ListID
if ( not ItemLineRetCustomerRef.ListID is nothing) then
Dim ListID24139 as String
ListID24139 = ItemLineRetCustomerRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ItemLineRetCustomerRef.FullName is nothing) then
Dim FullName24140 as String
FullName24140 = ItemLineRetCustomerRef.FullName.GetValue()
End If
End If
if (not ItemLineRetClassRef. is nothing) then
'Get value of ListID
if ( not ItemLineRetClassRef.ListID is nothing) then
Dim ListID24141 as String
ListID24141 = ItemLineRetClassRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ItemLineRetClassRef.FullName is nothing) then
Dim FullName24142 as String
FullName24142 = ItemLineRetClassRef.FullName.GetValue()
End If
End If
if (not ItemLineRetSalesTaxCodeRef. is nothing) then
'Get value of ListID
if ( not ItemLineRetSalesTaxCodeRef.ListID is nothing) then
Dim ListID24143 as String
ListID24143 = ItemLineRetSalesTaxCodeRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ItemLineRetSalesTaxCodeRef.FullName is nothing) then
Dim FullName24144 as String
FullName24144 = ItemLineRetSalesTaxCodeRef.FullName.GetValue()
End If
End If
'Get value of BillableStatus
if ( not ItemLineRetBillableStatus is nothing) then
Dim BillableStatus24145 as ENBillableStatus
BillableStatus24145 = ItemLineRetBillableStatus.GetValue()
End If
if (not ItemLineRetSalesRepRef. is nothing) then
'Get value of ListID
if ( not ItemLineRetSalesRepRef.ListID is nothing) then
Dim ListID24146 as String
ListID24146 = ItemLineRetSalesRepRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ItemLineRetSalesRepRef.FullName is nothing) then
Dim FullName24147 as String
FullName24147 = ItemLineRetSalesRepRef.FullName.GetValue()
End If
End If
if (not ItemLineRetDataExtRetList is nothing)
Dim i24148 as Integer
for i24148 = 0 to ItemLineRetDataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = ItemLineRetDataExtRetList.GetAt(i24148)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID24149 as String
OwnerID24149 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName24150 as String
DataExtName24150 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType24151 as ENDataExtType
DataExtType24151 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue24152 as String
DataExtValue24152 = DataExtRetDataExtValue.GetValue()
Next i24148
End If
Next i24121
End If
if (not ORItemLineRet24080.ItemGroupLineRet.DataExtList is nothing)
Dim i24153 as Integer
for i24153 = 0 to ORItemLineRet24080.ItemGroupLineRet.DataExtList.Count - 1
Dim DataExt as IDataExt
DataExt = ORItemLineRet24080.ItemGroupLineRet.DataExtList.GetAt(i24153)
'Get value of OwnerID
Dim OwnerID24154 as String
OwnerID24154 = DataExtOwnerID.GetValue()
'Get value of DataExtName
Dim DataExtName24155 as String
DataExtName24155 = DataExtDataExtName.GetValue()
'Get value of DataExtValue
Dim DataExtValue24156 as String
DataExtValue24156 = DataExtDataExtValue.GetValue()
Next i24153
End If
End If
End If
Next i24079
End If
'Get value of OpenAmount
if ( not VendorCreditRet.OpenAmount is nothing) then
Dim OpenAmount24157 as Double
OpenAmount24157 = VendorCreditRet.OpenAmount.GetValue()
End If
if (not VendorCreditRet.DataExtRetList is nothing)
Dim i24158 as Integer
for i24158 = 0 to VendorCreditRet.DataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = VendorCreditRet.DataExtRetList.GetAt(i24158)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID24159 as String
OwnerID24159 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName24160 as String
DataExtName24160 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType24161 as ENDataExtType
DataExtType24161 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue24162 as String
DataExtValue24162 = DataExtRetDataExtValue.GetValue()
Next i24158
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 | //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 DoVendorCreditQuery() { 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; BuildVendorCreditQueryRq(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; WalkVendorCreditQueryRs(responseMsgSet); } catch (Exception e) { MessageBox.Show(e.Message, "Error"); if (sessionBegun) { sessionManager.EndSession(); } if (connectionOpen) { sessionManager.CloseConnection(); } } } void BuildVendorCreditQueryRq(IMsgSetRequest requestMsgSet) { IVendorCreditQuery VendorCreditQueryRq= requestMsgSet.AppendVendorCreditQueryRq(); //Set attributes //Set field value for metaData VendorCreditQueryRq.metaData.SetValue("IQBENmetaDataType"); //Set field value for iterator VendorCreditQueryRq.iterator.SetValue("IQBENiteratorType"); //Set field value for iteratorID VendorCreditQueryRq.iteratorID.SetValue("IQBUUIDType"); string ORTxnQueryElementType23885 = "TxnIDList"; if (ORTxnQueryElementType23885 == "TxnIDList") { //Set field value for TxnIDList //May create more than one of these if needed VendorCreditQueryRq.ORTxnQuery.TxnIDList.Add("200000-1011023419"); } if (ORTxnQueryElementType23885 == "RefNumberList") { //Set field value for RefNumberList //May create more than one of these if needed VendorCreditQueryRq.ORTxnQuery.RefNumberList.Add("ab"); } if (ORTxnQueryElementType23885 == "RefNumberCaseSensitiveList") { //Set field value for RefNumberCaseSensitiveList //May create more than one of these if needed VendorCreditQueryRq.ORTxnQuery.RefNumberCaseSensitiveList.Add("ab"); } if (ORTxnQueryElementType23885 == "TxnFilter") { //Set field value for MaxReturned VendorCreditQueryRq.ORTxnQuery.TxnFilter.MaxReturned.SetValue(6); string ORDateRangeFilterElementType23886 = "ModifiedDateRangeFilter"; if (ORDateRangeFilterElementType23886 == "ModifiedDateRangeFilter") { //Set field value for FromModifiedDate VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); //Set field value for ToModifiedDate VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); } if (ORDateRangeFilterElementType23886 == "TxnDateRangeFilter") { string ORTxnDateRangeFilterElementType23887 = "TxnDateFilter"; if (ORTxnDateRangeFilterElementType23887 == "TxnDateFilter") { //Set field value for FromTxnDate VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007")); //Set field value for ToTxnDate VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007")); } if (ORTxnDateRangeFilterElementType23887 == "DateMacro") { //Set field value for DateMacro VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll); } } string OREntityFilterElementType23888 = "ListIDList"; if (OREntityFilterElementType23888 == "ListIDList") { //Set field value for ListIDList //May create more than one of these if needed VendorCreditQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.ListIDList.Add("200000-1011023419"); } if (OREntityFilterElementType23888 == "FullNameList") { //Set field value for FullNameList //May create more than one of these if needed VendorCreditQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.FullNameList.Add("ab"); } if (OREntityFilterElementType23888 == "ListIDWithChildren") { //Set field value for ListIDWithChildren VendorCreditQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.ListIDWithChildren.SetValue("200000-1011023419"); } if (OREntityFilterElementType23888 == "FullNameWithChildren") { //Set field value for FullNameWithChildren VendorCreditQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.FullNameWithChildren.SetValue("ab"); } string ORAccountFilterElementType23889 = "ListIDList"; if (ORAccountFilterElementType23889 == "ListIDList") { //Set field value for ListIDList //May create more than one of these if needed VendorCreditQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.ListIDList.Add("200000-1011023419"); } if (ORAccountFilterElementType23889 == "FullNameList") { //Set field value for FullNameList //May create more than one of these if needed VendorCreditQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.FullNameList.Add("ab"); } if (ORAccountFilterElementType23889 == "ListIDWithChildren") { //Set field value for ListIDWithChildren VendorCreditQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.ListIDWithChildren.SetValue("200000-1011023419"); } if (ORAccountFilterElementType23889 == "FullNameWithChildren") { //Set field value for FullNameWithChildren VendorCreditQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.FullNameWithChildren.SetValue("ab"); } string ORRefNumberFilterElementType23890 = "RefNumberFilter"; if (ORRefNumberFilterElementType23890 == "RefNumberFilter") { //Set field value for MatchCriterion VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.MatchCriterion.SetValue(ENMatchCriterion.mcStartsWith); //Set field value for RefNumber VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.RefNumber.SetValue("ab"); } if (ORRefNumberFilterElementType23890 == "RefNumberRangeFilter") { //Set field value for FromRefNumber VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberRangeFilter.FromRefNumber.SetValue("ab"); //Set field value for ToRefNumber VendorCreditQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberRangeFilter.ToRefNumber.SetValue("ab"); } string ORCurrencyFilterElementType23891 = "ListIDList"; if (ORCurrencyFilterElementType23891 == "ListIDList") { //Set field value for ListIDList //May create more than one of these if needed VendorCreditQueryRq.ORTxnQuery.TxnFilter.CurrencyFilter.ORCurrencyFilter.ListIDList.Add("200000-1011023419"); } if (ORCurrencyFilterElementType23891 == "FullNameList") { //Set field value for FullNameList //May create more than one of these if needed VendorCreditQueryRq.ORTxnQuery.TxnFilter.CurrencyFilter.ORCurrencyFilter.FullNameList.Add("ab"); } } //Set field value for IncludeLineItems VendorCreditQueryRq.IncludeLineItems.SetValue(true); //Set field value for IncludeLinkedTxns VendorCreditQueryRq.IncludeLinkedTxns.SetValue(true); //Set field value for IncludeRetElementList //May create more than one of these if needed VendorCreditQueryRq.IncludeRetElementList.Add("ab"); //Set field value for OwnerIDList //May create more than one of these if needed VendorCreditQueryRq.OwnerIDList.Add(Guid.NewGuid().ToString()); } void WalkVendorCreditQueryRs(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.rtVendorCreditQueryRs) { //upcast to more specific type here, this is safe because we checked with response.Type check above IVendorCreditRetList VendorCreditRet = (IVendorCreditRetList)response.Detail; WalkVendorCreditRet(VendorCreditRet); } } } } } void WalkVendorCreditRet(IVendorCreditRetList VendorCreditRet) { if (VendorCreditRet == null) return; //Go through all the elements of IVendorCreditRetList //Get value of TxnID string TxnID23892 = (string)VendorCreditRet.TxnID.GetValue(); //Get value of TimeCreated DateTime TimeCreated23893 = (DateTime)VendorCreditRet.TimeCreated.GetValue(); //Get value of TimeModified DateTime TimeModified23894 = (DateTime)VendorCreditRet.TimeModified.GetValue(); //Get value of EditSequence string EditSequence23895 = (string)VendorCreditRet.EditSequence.GetValue(); //Get value of TxnNumber if (VendorCreditRet.TxnNumber != null) { int TxnNumber23896 = (int)VendorCreditRet.TxnNumber.GetValue(); } //Get value of ListID if (VendorCreditRet.VendorRef.ListID != null) { string ListID23897 = (string)VendorCreditRet.VendorRef.ListID.GetValue(); } //Get value of FullName if (VendorCreditRet.VendorRef.FullName != null) { string FullName23898 = (string)VendorCreditRet.VendorRef.FullName.GetValue(); } if (VendorCreditRet.APAccountRef != null) { //Get value of ListID if (VendorCreditRet.APAccountRef.ListID != null) { string ListID23899 = (string)VendorCreditRet.APAccountRef.ListID.GetValue(); } //Get value of FullName if (VendorCreditRet.APAccountRef.FullName != null) { string FullName23900 = (string)VendorCreditRet.APAccountRef.FullName.GetValue(); } } //Get value of TxnDate DateTime TxnDate23901 = (DateTime)VendorCreditRet.TxnDate.GetValue(); //Get value of CreditAmount double CreditAmount23902 = (double)VendorCreditRet.CreditAmount.GetValue(); if (VendorCreditRet.CurrencyRef != null) { //Get value of ListID if (VendorCreditRet.CurrencyRef.ListID != null) { string ListID23903 = (string)VendorCreditRet.CurrencyRef.ListID.GetValue(); } //Get value of FullName if (VendorCreditRet.CurrencyRef.FullName != null) { string FullName23904 = (string)VendorCreditRet.CurrencyRef.FullName.GetValue(); } } //Get value of ExchangeRate if (VendorCreditRet.ExchangeRate != null) { IQBFloatType ExchangeRate23905 = (IQBFloatType)VendorCreditRet.ExchangeRate.GetValue(); } //Get value of CreditAmountInHomeCurrency if (VendorCreditRet.CreditAmountInHomeCurrency != null) { double CreditAmountInHomeCurrency23906 = (double)VendorCreditRet.CreditAmountInHomeCurrency.GetValue(); } //Get value of RefNumber if (VendorCreditRet.RefNumber != null) { string RefNumber23907 = (string)VendorCreditRet.RefNumber.GetValue(); } //Get value of Memo if (VendorCreditRet.Memo != null) { string Memo23908 = (string)VendorCreditRet.Memo.GetValue(); } //Get value of IsTaxIncluded if (VendorCreditRet.IsTaxIncluded != null) { bool IsTaxIncluded23909 = (bool)VendorCreditRet.IsTaxIncluded.GetValue(); } if (VendorCreditRet.SalesTaxCodeRef != null) { //Get value of ListID if (VendorCreditRet.SalesTaxCodeRef.ListID != null) { string ListID23910 = (string)VendorCreditRet.SalesTaxCodeRef.ListID.GetValue(); } //Get value of FullName if (VendorCreditRet.SalesTaxCodeRef.FullName != null) { string FullName23911 = (string)VendorCreditRet.SalesTaxCodeRef.FullName.GetValue(); } } //Get value of ExternalGUID if (VendorCreditRet.ExternalGUID != null) { string ExternalGUID23912 = (string)VendorCreditRet.ExternalGUID.GetValue(); } if (VendorCreditRet.LinkedTxnList != null) { for (int i23913 = 0; i23913 < VendorCreditRet.LinkedTxnList.Count; i23913++) { ILinkedTxn LinkedTxn = VendorCreditRet.LinkedTxnList.GetAt(i23913); //Get value of TxnID string TxnID23914 = (string)LinkedTxn.TxnID.GetValue(); //Get value of TxnType ENTxnType TxnType23915 = (ENTxnType)LinkedTxn.TxnType.GetValue(); //Get value of TxnDate DateTime TxnDate23916 = (DateTime)LinkedTxn.TxnDate.GetValue(); //Get value of RefNumber if (LinkedTxn.RefNumber != null) { string RefNumber23917 = (string)LinkedTxn.RefNumber.GetValue(); } //Get value of LinkType if (LinkedTxn.LinkType != null) { ENLinkType LinkType23918 = (ENLinkType)LinkedTxn.LinkType.GetValue(); } //Get value of Amount double Amount23919 = (double)LinkedTxn.Amount.GetValue(); } } if (VendorCreditRet.ExpenseLineRetList != null) { for (int i23920 = 0; i23920 < VendorCreditRet.ExpenseLineRetList.Count; i23920++) { IExpenseLineRet ExpenseLineRet = VendorCreditRet.ExpenseLineRetList.GetAt(i23920); //Get value of TxnLineID string TxnLineID23921 = (string)ExpenseLineRet.TxnLineID.GetValue(); if (ExpenseLineRet.AccountRef != null) { //Get value of ListID if (ExpenseLineRet.AccountRef.ListID != null) { string ListID23922 = (string)ExpenseLineRet.AccountRef.ListID.GetValue(); } //Get value of FullName if (ExpenseLineRet.AccountRef.FullName != null) { string FullName23923 = (string)ExpenseLineRet.AccountRef.FullName.GetValue(); } } //Get value of Amount if (ExpenseLineRet.Amount != null) { double Amount23924 = (double)ExpenseLineRet.Amount.GetValue(); } //Get value of Memo if (ExpenseLineRet.Memo != null) { string Memo23925 = (string)ExpenseLineRet.Memo.GetValue(); } if (ExpenseLineRet.CustomerRef != null) { //Get value of ListID if (ExpenseLineRet.CustomerRef.ListID != null) { string ListID23926 = (string)ExpenseLineRet.CustomerRef.ListID.GetValue(); } //Get value of FullName if (ExpenseLineRet.CustomerRef.FullName != null) { string FullName23927 = (string)ExpenseLineRet.CustomerRef.FullName.GetValue(); } } if (ExpenseLineRet.ClassRef != null) { //Get value of ListID if (ExpenseLineRet.ClassRef.ListID != null) { string ListID23928 = (string)ExpenseLineRet.ClassRef.ListID.GetValue(); } //Get value of FullName if (ExpenseLineRet.ClassRef.FullName != null) { string FullName23929 = (string)ExpenseLineRet.ClassRef.FullName.GetValue(); } } if (ExpenseLineRet.SalesTaxCodeRef != null) { //Get value of ListID if (ExpenseLineRet.SalesTaxCodeRef.ListID != null) { string ListID23930 = (string)ExpenseLineRet.SalesTaxCodeRef.ListID.GetValue(); } //Get value of FullName if (ExpenseLineRet.SalesTaxCodeRef.FullName != null) { string FullName23931 = (string)ExpenseLineRet.SalesTaxCodeRef.FullName.GetValue(); } } //Get value of BillableStatus if (ExpenseLineRet.BillableStatus != null) { ENBillableStatus BillableStatus23932 = (ENBillableStatus)ExpenseLineRet.BillableStatus.GetValue(); } if (ExpenseLineRet.SalesRepRef != null) { //Get value of ListID if (ExpenseLineRet.SalesRepRef.ListID != null) { string ListID23933 = (string)ExpenseLineRet.SalesRepRef.ListID.GetValue(); } //Get value of FullName if (ExpenseLineRet.SalesRepRef.FullName != null) { string FullName23934 = (string)ExpenseLineRet.SalesRepRef.FullName.GetValue(); } } if (ExpenseLineRet.DataExtRetList != null) { for (int i23935 = 0; i23935 < ExpenseLineRet.DataExtRetList.Count; i23935++) { IDataExtRet DataExtRet = ExpenseLineRet.DataExtRetList.GetAt(i23935); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID23936 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName23937 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType23938 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue23939 = (string)DataExtRet.DataExtValue.GetValue(); } } } } if (VendorCreditRet.ORItemLineRetList != null) { for (int i23940 = 0; i23940 < VendorCreditRet.ORItemLineRetList.Count; i23940++) { IORItemLineRet ORItemLineRet23941 = VendorCreditRet.ORItemLineRetList.GetAt(i23940); if (ORItemLineRet23941.ItemLineRet != null) { if (ORItemLineRet23941.ItemLineRet != null) { //Get value of TxnLineID string TxnLineID23942 = (string)ORItemLineRet23941.ItemLineRet.TxnLineID.GetValue(); if (ORItemLineRet23941.ItemLineRet.ItemRef != null) { //Get value of ListID if (ORItemLineRet23941.ItemLineRet.ItemRef.ListID != null) { string ListID23943 = (string)ORItemLineRet23941.ItemLineRet.ItemRef.ListID.GetValue(); } //Get value of FullName if (ORItemLineRet23941.ItemLineRet.ItemRef.FullName != null) { string FullName23944 = (string)ORItemLineRet23941.ItemLineRet.ItemRef.FullName.GetValue(); } } if (ORItemLineRet23941.ItemLineRet.InventorySiteRef != null) { //Get value of ListID if (ORItemLineRet23941.ItemLineRet.InventorySiteRef.ListID != null) { string ListID23945 = (string)ORItemLineRet23941.ItemLineRet.InventorySiteRef.ListID.GetValue(); } //Get value of FullName if (ORItemLineRet23941.ItemLineRet.InventorySiteRef.FullName != null) { string FullName23946 = (string)ORItemLineRet23941.ItemLineRet.InventorySiteRef.FullName.GetValue(); } } if (ORItemLineRet23941.ItemLineRet.InventorySiteLocationRef != null) { //Get value of ListID if (ORItemLineRet23941.ItemLineRet.InventorySiteLocationRef.ListID != null) { string ListID23947 = (string)ORItemLineRet23941.ItemLineRet.InventorySiteLocationRef.ListID.GetValue(); } //Get value of FullName if (ORItemLineRet23941.ItemLineRet.InventorySiteLocationRef.FullName != null) { string FullName23948 = (string)ORItemLineRet23941.ItemLineRet.InventorySiteLocationRef.FullName.GetValue(); } } if (ORItemLineRet23941.ItemLineRet.ORSerialLotNumber != null) { if (ORItemLineRet23941.ItemLineRet.ORSerialLotNumber.SerialNumber != null) { //Get value of SerialNumber if (ORItemLineRet23941.ItemLineRet.ORSerialLotNumber.SerialNumber != null) { string SerialNumber23950 = (string)ORItemLineRet23941.ItemLineRet.ORSerialLotNumber.SerialNumber.GetValue(); } } if (ORItemLineRet23941.ItemLineRet.ORSerialLotNumber.LotNumber != null) { //Get value of LotNumber if (ORItemLineRet23941.ItemLineRet.ORSerialLotNumber.LotNumber != null) { string LotNumber23951 = (string)ORItemLineRet23941.ItemLineRet.ORSerialLotNumber.LotNumber.GetValue(); } } } //Get value of ExpirationDateForSerialLotNumber if (ORItemLineRet23941.ItemLineRet.ExpirationDateForSerialLotNumber != null) { string ExpDate = (string)ORItemLineRet23941.ItemLineRet.ExpirationDateForSerialLotNumber.GetValue(); } //Get value of Desc if (ORItemLineRet23941.ItemLineRet.Desc != null) { string Desc23952 = (string)ORItemLineRet23941.ItemLineRet.Desc.GetValue(); } //Get value of Quantity if (ORItemLineRet23941.ItemLineRet.Quantity != null) { int Quantity23953 = (int)ORItemLineRet23941.ItemLineRet.Quantity.GetValue(); } //Get value of UnitOfMeasure if (ORItemLineRet23941.ItemLineRet.UnitOfMeasure != null) { string UnitOfMeasure23954 = (string)ORItemLineRet23941.ItemLineRet.UnitOfMeasure.GetValue(); } if (ORItemLineRet23941.ItemLineRet.OverrideUOMSetRef != null) { //Get value of ListID if (ORItemLineRet23941.ItemLineRet.OverrideUOMSetRef.ListID != null) { string ListID23955 = (string)ORItemLineRet23941.ItemLineRet.OverrideUOMSetRef.ListID.GetValue(); } //Get value of FullName if (ORItemLineRet23941.ItemLineRet.OverrideUOMSetRef.FullName != null) { string FullName23956 = (string)ORItemLineRet23941.ItemLineRet.OverrideUOMSetRef.FullName.GetValue(); } } //Get value of Cost if (ORItemLineRet23941.ItemLineRet.Cost != null) { double Cost23957 = (double)ORItemLineRet23941.ItemLineRet.Cost.GetValue(); } //Get value of Amount if (ORItemLineRet23941.ItemLineRet.Amount != null) { double Amount23958 = (double)ORItemLineRet23941.ItemLineRet.Amount.GetValue(); } if (ORItemLineRet23941.ItemLineRet.CustomerRef != null) { //Get value of ListID if (ORItemLineRet23941.ItemLineRet.CustomerRef.ListID != null) { string ListID23959 = (string)ORItemLineRet23941.ItemLineRet.CustomerRef.ListID.GetValue(); } //Get value of FullName if (ORItemLineRet23941.ItemLineRet.CustomerRef.FullName != null) { string FullName23960 = (string)ORItemLineRet23941.ItemLineRet.CustomerRef.FullName.GetValue(); } } if (ORItemLineRet23941.ItemLineRet.ClassRef != null) { //Get value of ListID if (ORItemLineRet23941.ItemLineRet.ClassRef.ListID != null) { string ListID23961 = (string)ORItemLineRet23941.ItemLineRet.ClassRef.ListID.GetValue(); } //Get value of FullName if (ORItemLineRet23941.ItemLineRet.ClassRef.FullName != null) { string FullName23962 = (string)ORItemLineRet23941.ItemLineRet.ClassRef.FullName.GetValue(); } } if (ORItemLineRet23941.ItemLineRet.SalesTaxCodeRef != null) { //Get value of ListID if (ORItemLineRet23941.ItemLineRet.SalesTaxCodeRef.ListID != null) { string ListID23963 = (string)ORItemLineRet23941.ItemLineRet.SalesTaxCodeRef.ListID.GetValue(); } //Get value of FullName if (ORItemLineRet23941.ItemLineRet.SalesTaxCodeRef.FullName != null) { string FullName23964 = (string)ORItemLineRet23941.ItemLineRet.SalesTaxCodeRef.FullName.GetValue(); } } //Get value of BillableStatus if (ORItemLineRet23941.ItemLineRet.BillableStatus != null) { ENBillableStatus BillableStatus23965 = (ENBillableStatus)ORItemLineRet23941.ItemLineRet.BillableStatus.GetValue(); } if (ORItemLineRet23941.ItemLineRet.SalesRepRef != null) { //Get value of ListID if (ORItemLineRet23941.ItemLineRet.SalesRepRef.ListID != null) { string ListID23966 = (string)ORItemLineRet23941.ItemLineRet.SalesRepRef.ListID.GetValue(); } //Get value of FullName if (ORItemLineRet23941.ItemLineRet.SalesRepRef.FullName != null) { string FullName23967 = (string)ORItemLineRet23941.ItemLineRet.SalesRepRef.FullName.GetValue(); } } if (ORItemLineRet23941.ItemLineRet.DataExtRetList != null) { for (int i23968 = 0; i23968 < ORItemLineRet23941.ItemLineRet.DataExtRetList.Count; i23968++) { IDataExtRet DataExtRet = ORItemLineRet23941.ItemLineRet.DataExtRetList.GetAt(i23968); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID23969 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName23970 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType23971 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue23972 = (string)DataExtRet.DataExtValue.GetValue(); } } } } if (ORItemLineRet23941.ItemGroupLineRet != null) { if (ORItemLineRet23941.ItemGroupLineRet != null) { //Get value of TxnLineID string TxnLineID23973 = (string)ORItemLineRet23941.ItemGroupLineRet.TxnLineID.GetValue(); //Get value of ListID if (ORItemLineRet23941.ItemGroupLineRet.ItemGroupRef.ListID != null) { string ListID23974 = (string)ORItemLineRet23941.ItemGroupLineRet.ItemGroupRef.ListID.GetValue(); } //Get value of FullName if (ORItemLineRet23941.ItemGroupLineRet.ItemGroupRef.FullName != null) { string FullName23975 = (string)ORItemLineRet23941.ItemGroupLineRet.ItemGroupRef.FullName.GetValue(); } //Get value of Desc if (ORItemLineRet23941.ItemGroupLineRet.Desc != null) { string Desc23976 = (string)ORItemLineRet23941.ItemGroupLineRet.Desc.GetValue(); } //Get value of Quantity if (ORItemLineRet23941.ItemGroupLineRet.Quantity != null) { int Quantity23977 = (int)ORItemLineRet23941.ItemGroupLineRet.Quantity.GetValue(); } //Get value of UnitOfMeasure if (ORItemLineRet23941.ItemGroupLineRet.UnitOfMeasure != null) { string UnitOfMeasure23978 = (string)ORItemLineRet23941.ItemGroupLineRet.UnitOfMeasure.GetValue(); } if (ORItemLineRet23941.ItemGroupLineRet.OverrideUOMSetRef != null) { //Get value of ListID if (ORItemLineRet23941.ItemGroupLineRet.OverrideUOMSetRef.ListID != null) { string ListID23979 = (string)ORItemLineRet23941.ItemGroupLineRet.OverrideUOMSetRef.ListID.GetValue(); } //Get value of FullName if (ORItemLineRet23941.ItemGroupLineRet.OverrideUOMSetRef.FullName != null) { string FullName23980 = (string)ORItemLineRet23941.ItemGroupLineRet.OverrideUOMSetRef.FullName.GetValue(); } } //Get value of TotalAmount double TotalAmount23981 = (double)ORItemLineRet23941.ItemGroupLineRet.TotalAmount.GetValue(); if (ORItemLineRet23941.ItemGroupLineRet.ItemLineRetList != null) { for (int i23982 = 0; i23982 < ORItemLineRet23941.ItemGroupLineRet.ItemLineRetList.Count; i23982++) { IItemLineRet ItemLineRet = ORItemLineRet23941.ItemGroupLineRet.ItemLineRetList.GetAt(i23982); //Get value of TxnLineID string TxnLineID23983 = (string)ItemLineRet.TxnLineID.GetValue(); if (ItemLineRet.ItemRef != null) { //Get value of ListID if (ItemLineRet.ItemRef.ListID != null) { string ListID23984 = (string)ItemLineRet.ItemRef.ListID.GetValue(); } //Get value of FullName if (ItemLineRet.ItemRef.FullName != null) { string FullName23985 = (string)ItemLineRet.ItemRef.FullName.GetValue(); } } if (ItemLineRet.InventorySiteRef != null) { //Get value of ListID if (ItemLineRet.InventorySiteRef.ListID != null) { string ListID23986 = (string)ItemLineRet.InventorySiteRef.ListID.GetValue(); } //Get value of FullName if (ItemLineRet.InventorySiteRef.FullName != null) { string FullName23987 = (string)ItemLineRet.InventorySiteRef.FullName.GetValue(); } } if (ItemLineRet.InventorySiteLocationRef != null) { //Get value of ListID if (ItemLineRet.InventorySiteLocationRef.ListID != null) { string ListID23988 = (string)ItemLineRet.InventorySiteLocationRef.ListID.GetValue(); } //Get value of FullName if (ItemLineRet.InventorySiteLocationRef.FullName != null) { string FullName23989 = (string)ItemLineRet.InventorySiteLocationRef.FullName.GetValue(); } } if (ItemLineRet.ORSerialLotNumber != null) { if (ItemLineRet.ORSerialLotNumber.SerialNumber != null) { //Get value of SerialNumber if (ItemLineRet.ORSerialLotNumber.SerialNumber != null) { string SerialNumber23991 = (string)ItemLineRet.ORSerialLotNumber.SerialNumber.GetValue(); } } if (ItemLineRet.ORSerialLotNumber.LotNumber != null) { //Get value of LotNumber if (ItemLineRet.ORSerialLotNumber.LotNumber != null) { string LotNumber23992 = (string)ItemLineRet.ORSerialLotNumber.LotNumber.GetValue(); } } } //Get value of ExpirationDateForSerialLotNumber if (ItemLineRet.ExpirationDateForSerialLotNumber != null) { string ExpDate = (string)ItemLineRet.ExpirationDateForSerialLotNumber.GetValue(); } //Get value of Desc if (ItemLineRet.Desc != null) { string Desc23993 = (string)ItemLineRet.Desc.GetValue(); } //Get value of Quantity if (ItemLineRet.Quantity != null) { int Quantity23994 = (int)ItemLineRet.Quantity.GetValue(); } //Get value of UnitOfMeasure if (ItemLineRet.UnitOfMeasure != null) { string UnitOfMeasure23995 = (string)ItemLineRet.UnitOfMeasure.GetValue(); } if (ItemLineRet.OverrideUOMSetRef != null) { //Get value of ListID if (ItemLineRet.OverrideUOMSetRef.ListID != null) { string ListID23996 = (string)ItemLineRet.OverrideUOMSetRef.ListID.GetValue(); } //Get value of FullName if (ItemLineRet.OverrideUOMSetRef.FullName != null) { string FullName23997 = (string)ItemLineRet.OverrideUOMSetRef.FullName.GetValue(); } } //Get value of Cost if (ItemLineRet.Cost != null) { double Cost23998 = (double)ItemLineRet.Cost.GetValue(); } //Get value of Amount if (ItemLineRet.Amount != null) { double Amount23999 = (double)ItemLineRet.Amount.GetValue(); } if (ItemLineRet.CustomerRef != null) { //Get value of ListID if (ItemLineRet.CustomerRef.ListID != null) { string ListID24000 = (string)ItemLineRet.CustomerRef.ListID.GetValue(); } //Get value of FullName if (ItemLineRet.CustomerRef.FullName != null) { string FullName24001 = (string)ItemLineRet.CustomerRef.FullName.GetValue(); } } if (ItemLineRet.ClassRef != null) { //Get value of ListID if (ItemLineRet.ClassRef.ListID != null) { string ListID24002 = (string)ItemLineRet.ClassRef.ListID.GetValue(); } //Get value of FullName if (ItemLineRet.ClassRef.FullName != null) { string FullName24003 = (string)ItemLineRet.ClassRef.FullName.GetValue(); } } if (ItemLineRet.SalesTaxCodeRef != null) { //Get value of ListID if (ItemLineRet.SalesTaxCodeRef.ListID != null) { string ListID24004 = (string)ItemLineRet.SalesTaxCodeRef.ListID.GetValue(); } //Get value of FullName if (ItemLineRet.SalesTaxCodeRef.FullName != null) { string FullName24005 = (string)ItemLineRet.SalesTaxCodeRef.FullName.GetValue(); } } //Get value of BillableStatus if (ItemLineRet.BillableStatus != null) { ENBillableStatus BillableStatus24006 = (ENBillableStatus)ItemLineRet.BillableStatus.GetValue(); } if (ItemLineRet.SalesRepRef != null) { //Get value of ListID if (ItemLineRet.SalesRepRef.ListID != null) { string ListID24007 = (string)ItemLineRet.SalesRepRef.ListID.GetValue(); } //Get value of FullName if (ItemLineRet.SalesRepRef.FullName != null) { string FullName24008 = (string)ItemLineRet.SalesRepRef.FullName.GetValue(); } } if (ItemLineRet.DataExtRetList != null) { for (int i24009 = 0; i24009 < ItemLineRet.DataExtRetList.Count; i24009++) { IDataExtRet DataExtRet = ItemLineRet.DataExtRetList.GetAt(i24009); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID24010 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName24011 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType24012 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue24013 = (string)DataExtRet.DataExtValue.GetValue(); } } } } if (ORItemLineRet23941.ItemGroupLineRet.DataExtList != null) { for (int i24014 = 0; i24014 < ORItemLineRet23941.ItemGroupLineRet.DataExtList.Count; i24014++) { IDataExt DataExt = ORItemLineRet23941.ItemGroupLineRet.DataExtList.GetAt(i24014); //Get value of OwnerID string OwnerID24015 = (string)DataExt.OwnerID.GetValue(); //Get value of DataExtName string DataExtName24016 = (string)DataExt.DataExtName.GetValue(); //Get value of DataExtValue string DataExtValue24017 = (string)DataExt.DataExtValue.GetValue(); } } } } } } //Get value of OpenAmount if (VendorCreditRet.OpenAmount != null) { double OpenAmount24018 = (double)VendorCreditRet.OpenAmount.GetValue(); } if (VendorCreditRet.DataExtRetList != null) { for (int i24019 = 0; i24019 < VendorCreditRet.DataExtRetList.Count; i24019++) { IDataExtRet DataExtRet = VendorCreditRet.DataExtRetList.GetAt(i24019); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID24020 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName24021 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType24022 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue24023 = (string)DataExtRet.DataExtValue.GetValue(); } } } } } |