Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ItemStocktakeSeq | int identity | 4 | √ | null |
|
|
||||
| SystemProcessNumber | int | 4 | null |
|
|
|||||
| BusinessUnitCode | varchar | 15 | ('') |
|
|
|||||
| ItemCode | varchar | 15 | null |
|
|
|||||
| StockOnHand | decimal | 16,4 | √ | ((0)) |
|
|
||||
| Count1 | decimal | 16,4 | √ | null |
|
|
||||
| Count2 | decimal | 16,4 | √ | null |
|
|
||||
| AverageCost | decimal | 14,4 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ItemStocktake | Primary key | Asc | ItemStocktakeSeq |
| AK_ItemStocktake | Must be unique | Asc/Asc/Asc | SystemProcessNumber + BusinessUnitCode + ItemCode |
Relationships
Close relationships within degrees of separation
