InventoriedItem
Return a list of: InventoriedItem
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 |