The location code; links to CFGInvLocations.Code.
The inventory item's item number.
The Quantity on Hand for this inventory item.
The total cost amount; calculated as Qty * Cost.
| Inventory |
| Default Table Name | Inventory |
| Definition | Inventory Table - Quantity on Hand by Location |
| Inventory Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| Location |
nvarchar(20) | NO | The location code; links to CFGInvLocations.Code. |
|
| Item |
nvarchar(30) | NO | The inventory item's item number. |
|
| QtyOnHand | decimal(19, 4) | NO | The Quantity on Hand for this inventory item. |
|
| Amount | decimal(19, 4) | NO | The total cost amount; calculated as Qty * Cost. |
| Inventory Primary and Unique Keys |
| Key Name | Key Type | Keys |
| InventoryPK | PrimaryKey | Location, Item |
| Inventory Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |