Warehouse.StockItems_Archive
Documentation | WideWorldImporters |
Schema | Warehouse |
Name | StockItems_Archive |
Modules | Warehouse, History tables |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | StockItemID | int | Numeric ID used for reference to a stock item within the database | |||||
Numeric ID used for reference to a stock item within the database |
||||||||
2 | StockItemName | nvarchar(100) | Full name of a stock item (but not a full description) | |||||
Full name of a stock item (but not a full description) |
||||||||
3 | SupplierID | int | Usual supplier for this stock item | |||||
Usual supplier for this stock item |
||||||||
4 | ColorID | int | Color (optional) for this stock item | |||||
Color (optional) for this stock item |
||||||||
5 | UnitPackageID | int | Usual package for selling units of this stock item | |||||
Usual package for selling units of this stock item |
||||||||
6 | OuterPackageID | int | Usual package for selling outers of this stock item (ie cartons, boxes, etc.) | |||||
Usual package for selling outers of this stock item (ie cartons, boxes, etc.) |
||||||||
7 | Brand | nvarchar(50) | Brand for the stock item (if the item is branded) | |||||
Brand for the stock item (if the item is branded) |
||||||||
8 | Size | nvarchar(20) | Size of this item (eg: 100mm) | |||||
Size of this item (eg: 100mm) |
||||||||
9 | LeadTimeDays | int | Number of days typically taken from order to receipt of this stock item | |||||
Number of days typically taken from order to receipt of this stock item |
||||||||
10 | QuantityPerOuter | int | Quantity of the stock item in an outer package | |||||
Quantity of the stock item in an outer package |
||||||||
11 | IsChillerStock | bit | Does this stock item need to be in a chiller? | |||||
Does this stock item need to be in a chiller? |
||||||||
12 | Barcode | nvarchar(50) | Barcode for this stock item | |||||
Barcode for this stock item |
||||||||
13 | TaxRate | decimal(18, 3) | Tax rate to be applied | |||||
Tax rate to be applied |
||||||||
14 | UnitPrice | decimal(18, 2) | Selling price (ex-tax) for one unit of this product | |||||
Selling price (ex-tax) for one unit of this product |
||||||||
15 | RecommendedRetailPrice | decimal(18, 2) | Recommended retail price for this stock item | |||||
Recommended retail price for this stock item |
||||||||
16 | TypicalWeightPerUnit | decimal(18, 3) | Typical weight for one unit of this product (packaged) | |||||
Typical weight for one unit of this product (packaged) |
||||||||
17 | MarketingComments | nvarchar(MAX) | Marketing comments for this stock item (shared outside the organization) | |||||
Marketing comments for this stock item (shared outside the organization) |
||||||||
18 | InternalComments | nvarchar(MAX) | Internal comments (not exposed outside organization) | |||||
Internal comments (not exposed outside organization) |
||||||||
19 | Photo | varbinary(MAX) | Photo of the product | |||||
Photo of the product |
||||||||
20 | CustomFields | nvarchar(MAX) | Custom fields added by system users | |||||
Custom fields added by system users |
||||||||
21 | Tags | nvarchar(MAX) | Advertising tags associated with this stock item (JSON array retrieved from CustomFields) | |||||
Advertising tags associated with this stock item (JSON array retrieved from CustomFields) |
||||||||
22 | SearchDetails | nvarchar(MAX) | Combination of columns used by full text search | |||||
Combination of columns used by full text search |
||||||||
23 | LastEditedBy | int | ||||||
24 | ValidFrom | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
25 | ValidTo | datetime2(7) | Valid until this date and time | |||||
Valid until this date and time |
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51