Company
Return a list of: Company
Columns
Name | Type | Description |
Id [KEY] | Int | |
ExtensionsExtensionAggregate | String | |
AccountSegmentSeparator | String | |
BusinessType | String | |
CreatedDate | Datetime | |
DUNSNumber | String | |
DefaultAddressExtensionsExtensionAggregate | String | |
DefaultAddressCity | String | |
DefaultAddressLine1 | String | |
DefaultAddressLine2 | String | |
DefaultAddressLine3 | String | |
DefaultAddressPostalCode | String | |
DefaultAddressState | String | |
DefaultAddressCountryRegion | String | |
DefaultAddressFaxCountryCode | String | |
DefaultAddressFaxExtension | String | |
DefaultAddressFax | String | |
DefaultAddressPhone1CountryCode | String | |
DefaultAddressPhone1Extension | String | |
DefaultAddressPhone1 | String | |
DefaultAddressPhone2CountryCode | String | |
DefaultAddressPhone2Extension | String | |
DefaultAddressPhone2 | String | |
DefaultAddressPhone3CountryCode | String | |
DefaultAddressPhone3Extension | String | |
DefaultAddressPhone3 | String | |
DefaultAddressCountryRegionCodeId | String | |
DefaultAddressContactPerson | String | |
DefaultAddressName | String | |
DefaultAddressCounty | String | |
DefaultAddressId | String | |
IsValueAddedTaxReturnEnabled | Bool | |
IsWorkflowEnabled | Bool | |
ModifiedBy | String | |
ModifiedDate | Datetime | |
Name | String | |
Options | String | |
PayablesProcessesTaxDetailId | String | |
PurchasesTaxScheduleId | String | |
ReceivablesProcessesTaxDetailId | String | |
SICNumber | String | |
SalesTaxScheduleId | String | |
TaxExempt1 | String | |
TaxExempt2 | String | |
TaxRegistration | String | |
UserDefined1 | String | |
UserDefined2 | String | |
Vets100Number | String | |
WithholdingVendorId | String | |
WitholdingFileOrReconciliationNumber | String | |
WitholdingTaxRate | Int |
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 |