Item
Return a list of: Item
Columns
| Name | Type | Description |
| ExtensionsExtensionAggregate | String | |
| ABCCode | String | |
| AllowBackOrder | Bool | |
| AssemblyVarianceGLAccountId | String | |
| AssemblyVarianceGLAccountKeyIsEncrypted | Bool | |
| ClassId | String | |
| CostofGoodsSoldGLAccountId | String | |
| CostofGoodsSoldGLAccountKeyIsEncrypted | Bool | |
| CreatedDate | Datetime | |
| CurrencyDecimalPlaces | String | |
| CurrentCostCurrency | String | |
| CurrentCost | Decimal | |
| DamagedGLAccountId | String | |
| DamagedGLAccountKeyIsEncrypted | Bool | |
| DefaultPriceLevelId | String | |
| DefaultSellingUofM | String | |
| DefaultWarehouseId | String | |
| Description | String | |
| DropShipGLAccountId | String | |
| DropShipGLAccountKeyIsEncrypted | Bool | |
| FunctionalCurrencyDecimalPlaces | String | |
| GenericDescription | String | |
| InServiceGLAccountId | String | |
| InServiceGLAccountKeyIsEncrypted | Bool | |
| InUseGLAccountId | String | |
| InUseGLAccountKeyIsEncrypted | Bool | |
| IncludeInDemandPlanning | Bool | |
| InternetAddressesAdditionalInformation | String | |
| InternetAddressesEmailBccAddress | String | |
| InternetAddressesEmailCcAddress | String | |
| InternetAddressesEmailToAddress | String | |
| InternetAddressesInternetField1 | String | |
| InternetAddressesInternetField2 | String | |
| InternetAddressesInternetField3 | String | |
| InternetAddressesInternetField4 | String | |
| InternetAddressesInternetField5 | String | |
| InternetAddressesInternetField6 | String | |
| InternetAddressesInternetField7 | String | |
| InternetAddressesInternetField8 | String | |
| InternetAddressesMessengerAddress | String | |
| InventoryGLAccountId | String | |
| InventoryGLAccountKeyIsEncrypted | Bool | |
| InventoryOffsetGLAccountId | String | |
| InventoryOffsetGLAccountKeyIsEncrypted | Bool | |
| InventoryReturnGLAccountId | String | |
| InventoryReturnGLAccountKeyIsEncrypted | Bool | |
| IsDiscontinued | Bool | |
| KeepCalendarYearHistory | Bool | |
| KeepDistributionHistory | Bool | |
| KeepFiscalYearHistory | Bool | |
| KeepTransactionHistory | Bool | |
| Id [KEY] | String | |
| LastModifiedDate | Datetime | |
| MarkdownGLAccountId | String | |
| MarkdownGLAccountKeyIsEncrypted | Bool | |
| ModifiedDate | Datetime | |
| PriceMethod | String | |
| PurchasePriceVarianceGLAccountId | String | |
| PurchasePriceVarianceGLAccountKeyIsEncrypted | Bool | |
| PurchaseTaxBasis | String | |
| PurchaseTaxScheduleId | String | |
| PurchaseUofM | String | |
| QuantityDecimalPlaces | String | |
| SalesGLAccountId | String | |
| SalesGLAccountKeyIsEncrypted | Bool | |
| SalesReturnGLAccountId | String | |
| SalesReturnGLAccountKeyIsEncrypted | Bool | |
| SalesTaxBasis | String | |
| SalesTaxScheduleId | String | |
| ShippingWeight | Decimal | |
| ShortDescription | String | |
| StandardCostCurrency | String | |
| StandardCost | Decimal | |
| SubstituteItem1Id | String | |
| SubstituteItem2Id | String | |
| Type | String | |
| UnrealizedPurchasePriceVarianceGLAccountId | String | |
| UnrealizedPurchasePriceVarianceGLAccountKeyIsEncrypted | Bool | |
| UofMScheduleId | String | |
| UserCategoryList1 | String | |
| UserCategoryList2 | String | |
| UserCategoryList3 | String | |
| UserCategoryList4 | String | |
| UserCategoryList5 | String | |
| UserCategoryList6 | String | |
| VarianceGLAccountId | String | |
| VarianceGLAccountKeyIsEncrypted | Bool | |
| WarrantyDays | Short |
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 |