Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
InvInventoryLocationLog Table
Collapse All Expand All
iVend Database Database : InvInventoryLocationLog Table |
Description
Stores the logs or Audit information of location for the Inventory available at different locations
Properties
Creation Date |
9/18/2015 10:05 AM |
File Group |
PRIMARY |
Text File Group |
|
System Object |
|
Published for Replication |
|
Rows |
0 |
Data Space Used |
0.00 KB |
Index Space Used |
0.00 KB |
Columns
|
Column Name |
Description |
Datatype |
Length |
Allow Nulls |
Default |
Formula |
|
InventoryLocationLogKey |
Primary Key |
VarWChar |
50 |
|
|
|
|
WarehouseKey |
Reference Key of Warehouse. See also InvWarehouse. |
VarWChar |
50 |
|
|
|
|
ProductKey |
Reference Key of Product. See also InvProduct. |
VarWChar |
50 |
|
|
|
|
LocationKey |
Reference Key of Location. See also InvLocation. |
VarWChar |
50 |
|
|
|
|
InQty |
Quantity Received |
Numeric |
9 (20,5) |
|
|
|
|
OutQty |
Quantity Consumed |
Numeric |
9 (20,5) |
|
|
|
|
SourceType |
Refers to the source document. Valid values are: External = -1 Unknown = 0 GoodsReceipt = 1 GoodsReceiptPO = 2 GoodsReceiptSTN = 3 StockTransfer = 4 KitBuildBreak = 5 StoreUseInventory = 6 SaleTransaction = 7 LayawayTransaction = 8 SpecialOrderTransaction = 9 GiftCertificateReceipt = 10, GiftCertificateStockTransfer = 11, GoodsReturn = 12, InventoryReconciliation = 13, StockTransferCancellation = 14, DeliveryPackage = 15, InventoryRevaluation = 16, LocationStockTransfer = 17 |
Integer |
4 |
|
|
|
|
SourceKey |
Refers to the source document key |
VarWChar |
50 |
|
|
|
|
SourceDetailKey |
Refers to the source document detail key |
VarWChar |
50 |
|
|
|
|
UpdateType |
Referes to the type of information that needs to be updated on the other store database. Valid values are: All = 0 AvaliableQuantity = 1 InStockQuantity = 2 |
Integer |
4 |
|
|
|
|
Created |
Date of creation of this record |
DBTimeStamp |
4 |
|
|
|
|
OnFulfillmentQuanity |
Quantity need to be fulfilled |
Numeric |
9 (20,5) |
|
|
|
|
AllocatedQuantity |
Quantity allocated while creating package |
Numeric |
9 (20,5) |
|
|
|
Indexes
Index |
Description |
Primary |
Unique |
|
|
|
Objects that depend on InvInventoryLocationLog
|
Database Object |
Object Type |
Description |
Dep Level |
|
Stored Procedure |
Updates the inventory location quantity depending on the delata update |
1 |
|
|
Stored Procedure |
|
1 |
|
|
User Defined Function |
|
2 |
|
|
User Defined Function |
|
1 |
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvInventoryLocationLog]( [InventoryLocationLogKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [WarehouseKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ProductKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [LocationKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [InQty] [decimal](20, 5) NOT NULL, [OutQty] [decimal](20, 5) NOT NULL, [SourceType] [int] NOT NULL, [SourceKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [SourceDetailKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [UpdateType] [int] NOT NULL, [Created] [datetime] NOT NULL, [OnFulfillmentQuanity] [decimal](20, 5) NULL, [AllocatedQuantity] [decimal](20, 5) NULL, CONSTRAINT [PK_InvInventoryLocationLog] PRIMARY KEY CLUSTERED ( [InventoryLocationLogKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.