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