Portals
SPInventoryItem
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AddToCartNonexistent in DB | string? | Add to Cart | - | |
Description:No description available | ||||
BaseCardQty | decimal | - | ||
Description:No description available | ||||
BaseDiscountAmtNonexistent in DB | decimal? | Discount Amt | - | |
Description:No description available | ||||
BaseDiscountIDNonexistent in DB | string | - | ||
Description:No description available | ||||
BaseDiscountPctNonexistent in DB | decimal? | Discount Pct,% | - | |
Description:No description available | ||||
BaseDiscountSeqNonexistent in DB | string | - | ||
Description:No description available | ||||
BasePrice | decimal | Default Price | - | |
Description:No description available | ||||
BaseQtyAvail | decimal | Qty. Available | - | |
Description:No description available | ||||
BlobData | varbinary | - | ||
Description:No description available | ||||
BlobHandler | uniqueidentifier | - | ||
Description:No description available | ||||
Body | nvarchar | Body | - | |
Description:No description available | ||||
CardQty | decimal | - | ||
Description:No description available | ||||
CardUOM | nvarchar | - | ||
Description:No description available | ||||
CartRecordID | int | - | ||
Description:No description available | ||||
CategoryIDNonexistent in DB | int? | Category | - | |
Description:This artificial field will not contain valid data as there is a "many-to-many" relationship between invenoty items and categories. But it is required for the quick filter to be present. | ||||
CuryID | nvarchar | Currency | CurrencyList | |
Description:No description available | ||||
CuryInfoIDNonexistent in DB | long? | - | ||
Description:No description available | ||||
CurySymbol | nvarchar | Currency Symbol | - | |
Description:No description available | ||||
CuryUnitPriceNonexistent in DB | decimal? | Price | - | |
Description:No description available | ||||
CuryUnitPriceWithSymbolNonexistent in DB | string? | Price | - | |
Description:No description available | ||||
CuryUnitPriceWithSymbolTotalNonexistent in DB | string? | Price Total | - | |
Description:No description available | ||||
DecimalSalesUnit | bit | - | ||
Description:No description available | ||||
Descr | nvarchar(255) | Description | - | |
Description:No description available | ||||
DiscountNonexistent in DB | string? | Discount | - | |
Description:No description available | ||||
IAStatusNonexistent in DB | string? | Availability | - | |
Description:No description available | ||||
ImageUrl | nvarchar(255) | Image | - | |
Description:No description available | ||||
InventoryCD | nvarchar | Inventory ID | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
ItemStatus | nvarchar | Item Status | - | |
Description:No description available | ||||
LineTotalNonexistent in DB | decimal? | Line Total | - | |
Description:No description available | ||||
QtyNonexistent in DB | decimal? | Qty. | - | |
Description:No description available | ||||
QtyAvailNonexistent in DB | decimal? | Qty. Available | - | |
Description:No description available | ||||
RemoveFromCartNonexistent in DB | string | Remove | - | |
Description:No description available | ||||
SiteBaseQtyAvail | decimal | - | ||
Description:No description available | ||||
SiteId | int | Warehouse | SPWarehouseReference | |
Description:No description available | ||||
SiteIdListNonexistent in DB | int? | Warehouse | - | |
Description:List of available warehouses | ||||
SiteQtyAvailNonexistent in DB | decimal? | In Stock | - | |
Description:No description available | ||||
StkItem | bit | Stock Item | - | |
Description:No description available | ||||
UOM | nvarchar(6) | Unit | INUnit | |
Description:No description available | ||||
UOMListNonexistent in DB | string? | Unit | - | |
Description:No description available | ||||
WeightItem | bit | - | ||
Description:When set to "true", indicates that this item is a Weight Item. | ||||
siteCD | nvarchar | Warehouse | - | |
Description:No description available | ||||