VendorAddresses
Return a list of: VendorAddresses
Columns
| Name | Type | Description |
| ExtensionsExtensionAggregate | String | |
| AccountsPayableGLAccountId | String | |
| AccountsPayableGLAccountKeyIsEncrypted | Bool | |
| AccruedPurchasesGLAccountId | String | |
| AccruedPurchasesGLAccountKeyIsEncrypted | Bool | |
| AddressesExtensionsExtensionAggregate | String | |
| AddressesCity | String | |
| AddressesLine1 | String | |
| AddressesLine2 | String | |
| AddressesLine3 | String | |
| AddressesPostalCode | String | |
| AddressesState | String | |
| AddressesCountryRegion | String | |
| AddressesFaxCountryCode | String | |
| AddressesFaxExtension | String | |
| AddressesFax | String | |
| AddressesPhone1CountryCode | String | |
| AddressesPhone1Extension | String | |
| AddressesPhone1 | String | |
| AddressesPhone2CountryCode | String | |
| AddressesPhone2Extension | String | |
| AddressesPhone2 | String | |
| AddressesPhone3CountryCode | String | |
| AddressesPhone3Extension | String | |
| AddressesPhone3 | String | |
| AddressesCountryRegionCodeId | String | |
| AddressesContactPerson | String | |
| AddressesName | String | |
| AddressesCreatedDate | Datetime | |
| AddressesInternetAddressesAdditionalInformation | String | |
| AddressesInternetAddressesEmailBccAddress | String | |
| AddressesInternetAddressesEmailCcAddress | String | |
| AddressesInternetAddressesEmailToAddress | String | |
| AddressesInternetAddressesInternetField1 | String | |
| AddressesInternetAddressesInternetField2 | String | |
| AddressesInternetAddressesInternetField3 | String | |
| AddressesInternetAddressesInternetField4 | String | |
| AddressesInternetAddressesInternetField5 | String | |
| AddressesInternetAddressesInternetField6 | String | |
| AddressesInternetAddressesInternetField7 | String | |
| AddressesInternetAddressesInternetField8 | String | |
| AddressesInternetAddressesMessengerAddress | String | |
| AddressesLastModifiedDate | Datetime | |
| AddressesModifiedDate | Datetime | |
| AddressesShippingMethodId | String | |
| AddressesTaxScheduleId | String | |
| AddressesUPSZone | String | |
| AddressesUserDefined1 | String | |
| AddressesUserDefined2 | String | |
| AddressesDeleteOnUpdate | Bool | |
| AddressesId [KEY] | String | |
| AddressesKeyVendorId [KEY] | String | |
| AllowRevaluation | Bool | |
| BankAccountId | String | |
| CashGLAccountId | String | |
| CashGLAccountKeyIsEncrypted | Bool | |
| CheckName | String | |
| ClassId | String | |
| Comment1 | String | |
| Comment2 | String | |
| CreatedDate | Datetime | |
| CreditLimitItem | String | |
| CurrencyKeyISOCode | String | |
| DefaultAddressId | String | |
| DefaultAddressKeyVendorId | String | |
| DefaultCashAccountType | String | |
| DiscountGracePeriod | Int | |
| DueDateGracePeriod | Int | |
| FinanceChargesGLAccountId | String | |
| FinanceChargesGLAccountKeyIsEncrypted | Bool | |
| FreeOnBoard | String | |
| FreightGLAccountId | String | |
| FreightGLAccountKeyIsEncrypted | Bool | |
| HistoryOptionsKeepCalendarHistory | Bool | |
| HistoryOptionsKeepDistributionHistory | Bool | |
| HistoryOptionsKeepFiscalHistory | Bool | |
| HistoryOptionsKeepTransactionHistory | Bool | |
| IsActive | Bool | |
| IsOnHold | Bool | |
| IsOneTime | Bool | |
| Id | String | |
| Language | String | |
| MaximumInvoiceItem | String | |
| MaximumWriteoffItem | String | |
| MinimumOrderAmountCurrency | String | |
| MinimumOrderAmount | Decimal | |
| MinimumPaymentItem | String | |
| MiscellaneousGLAccountId | String | |
| MiscellaneousGLAccountKeyIsEncrypted | Bool | |
| ModifiedDate | Datetime | |
| Name | String | |
| Notes | String | |
| PaymentPriority | String | |
| PaymentTermsId | String | |
| PostResultsTo | String | |
| ProjectAccountingOptionsDefaultPurchaseOrderFormat | String | |
| ProjectAccountingOptionsUnitCostCurrency | String | |
| ProjectAccountingOptionsUnitCost | Decimal | |
| ProjectAccountingOptionsUnitOfMeasure | String | |
| ProjectAccountingOptionsUserDefined1 | String | |
| ProjectAccountingOptionsUserDefined2 | String | |
| PurchaseAddressId | String | |
| PurchaseAddressKeyVendorId | String | |
| PurchasePriceVarianceGLAccountId | String | |
| PurchasePriceVarianceGLAccountKeyIsEncrypted | Bool | |
| PurchasesGLAccountId | String | |
| PurchasesGLAccountKeyIsEncrypted | Bool | |
| RateTypeId | String | |
| RemitToAddressId | String | |
| RemitToAddressKeyVendorId | String | |
| ShipFromAddressId | String | |
| ShipFromAddressKeyVendorId | String | |
| ShortName | String | |
| Tax1099BoxNumber | Int | |
| Tax1099Type | String | |
| TaxGLAccountId | String | |
| TaxGLAccountKeyIsEncrypted | Bool | |
| TaxIdentificationNumber | String | |
| TaxRegistrationNumber | String | |
| TaxSchedule | String | |
| TermsDiscountAvailableGLAccountId | String | |
| TermsDiscountAvailableGLAccountKeyIsEncrypted | Bool | |
| TermsDiscountTakenGLAccountId | String | |
| TermsDiscountTakenGLAccountKeyIsEncrypted | Bool | |
| TradeDiscountGLAccountId | String | |
| TradeDiscountGLAccountKeyIsEncrypted | Bool | |
| TradeDiscountPercent | Decimal | |
| UserDefined1 | String | |
| UserDefined2 | String | |
| UserLanguageId | Int | |
| VendorAccountNumber | String | |
| WorkflowPriority | String | |
| WorkflowsAggregate | String | |
| WriteoffGLAccountId | String | |
| WriteoffGLAccountKeyIsEncrypted | Bool |
Pseudo-Columns
Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| PagingColumn | String |