CustomerAddresses
Return a list of: CustomerAddresses
Columns
| Name | Type | Description |
| ExtensionsExtensionAggregate | String | |
| AccountsReceivableGLAccountId | String | |
| AccountsReceivableGLAccountKeyIsEncrypted | 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 | |
| AddressesKeyCustomerId [KEY] | String | |
| AddressesId [KEY] | String | |
| AddressesSalesTerritoryId | String | |
| AddressesSalespersonId | String | |
| AddressesWarehouseId | String | |
| AllowRevaluation | Bool | |
| BalanceType | String | |
| BankAccountId | String | |
| BankBranch | String | |
| BankName | String | |
| BillToAddressKeyCustomerId | String | |
| BillToAddressId | String | |
| CashGLAccountId | String | |
| CashGLAccountKeyIsEncrypted | Bool | |
| ClassId | String | |
| Comment1 | String | |
| Comment2 | String | |
| CorporateAccountId | String | |
| CostOfGoodsSoldGLAccountId | String | |
| CostOfGoodsSoldGLAccountKeyIsEncrypted | Bool | |
| CreatedDate | Datetime | |
| CreditLimitItem | String | |
| CreditLimitPeriod | Int | |
| CreditLimitPeriodAmountCurrency | String | |
| CreditLimitPeriodAmount | Decimal | |
| CurrencyKeyISOCode | String | |
| DefaultAddressKeyCustomerId | String | |
| DefaultAddressId | String | |
| DefaultCashAccountType | String | |
| DiscountGracePeriod | Int | |
| DueDateGracePeriod | Int | |
| FinanceChargeItem | String | |
| FinanceChargesGLAccountId | String | |
| FinanceChargesGLAccountKeyIsEncrypted | Bool | |
| HistoryOptionsKeepCalendarHistory | Bool | |
| HistoryOptionsKeepDistributionHistory | Bool | |
| HistoryOptionsKeepFiscalHistory | Bool | |
| HistoryOptionsKeepTransactionHistory | Bool | |
| IncludeInDemandPlanning | Bool | |
| InventoryGLAccountId | String | |
| InventoryGLAccountKeyIsEncrypted | Bool | |
| IsActive | Bool | |
| IsOnHold | Bool | |
| Id | String | |
| LastModifiedDate | Datetime | |
| MaximumWriteoffItem | String | |
| MinimumPaymentItem | String | |
| ModifiedDate | Datetime | |
| Name | String | |
| Notes | String | |
| OrderFullfillmentShortageDefault | String | |
| OverpaymentWriteoffGLAccountId | String | |
| OverpaymentWriteoffGLAccountKeyIsEncrypted | Bool | |
| PaymentCardAccountExpirationDate | Datetime | |
| PaymentCardAccountKeyNumber | String | |
| PaymentCardAccountKeyPaymentCardTypeId | String | |
| PaymentTermsDiscountAvailableGLAccountId | String | |
| PaymentTermsDiscountAvailableGLAccountKeyIsEncrypted | Bool | |
| PaymentTermsDiscountTakenGLAccountId | String | |
| PaymentTermsDiscountTakenGLAccountKeyIsEncrypted | Bool | |
| PaymentTermsId | String | |
| PostResultsTo | String | |
| PriceLevelId | String | |
| Priority | Int | |
| RateTypeId | String | |
| SalesGLAccountId | String | |
| SalesGLAccountKeyIsEncrypted | Bool | |
| SalesOrderReturnsGLAccountId | String | |
| SalesOrderReturnsGLAccountKeyIsEncrypted | Bool | |
| SendEmailStatements | Bool | |
| ShipCompleteOnly | Bool | |
| ShipToAddressKeyCustomerId | String | |
| ShipToAddressId | String | |
| Shortname | String | |
| StatementCycle | String | |
| StatementName | String | |
| StatementRecipientsBCCAggregate | String | |
| StatementRecipientsCCAggregate | String | |
| StatementRecipientsToAggregate | String | |
| StatementToAddressKeyCustomerId | String | |
| StatementToAddressId | String | |
| TaxExemptNumbersAggregate | String | |
| TaxRegistrationNumber | String | |
| TradeDiscountPercent | Decimal | |
| UserDefined1 | String | |
| UserDefined2 | String | |
| UserLanguageId | Int | |
| 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 |