BATCHMERCHANDISEINVENTORY

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
SEQUENCE	int		Default = 0
ACTIONTYPECODE	tinyint		Default = 0
LOOKUPCODE	nvarchar(25)		Default = ''
QUANTITY	int		Default = 0
COST	decimal(20, 4)	yes	Default = 0
PRICE	decimal(20, 4)	yes	Default = 0
COMMENTS	nvarchar(255)		Default = ''
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)
ACTIONTYPE	nvarchar(14) (Computed)	yes	CASE [ACTIONTYPECODE] WHEN 0 THEN N'Shipment' WHEN 1 THEN N'Adjustment' WHEN 2 THEN N'Physical count' END
UPDATECURRENTCOST	bit		Default = 1

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
BATCHID	uniqueidentifier		BATCH.ID
MERCHANDISEPRODUCTID	uniqueidentifier		MERCHANDISEPRODUCT.ID
MERCHANDISEPRODUCTINSTANCEID	uniqueidentifier		MERCHANDISEPRODUCTINSTANCE.ID
VENDORID	uniqueidentifier	yes	VENDOR.ID
MERCHANDISEADJUSTMENTREASONCODEID	uniqueidentifier	yes	MERCHANDISEADJUSTMENTREASONCODE.ID
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BATCHMERCHANDISEINVENTORY_BATCHID	BATCHID
IX_BATCHMERCHANDISEINVENTORY_DATEADDED	DATEADDED			yes
IX_BATCHMERCHANDISEINVENTORY_DATECHANGED	DATECHANGED
PK_BATCHMERCHANDISEINVENTORY	ID	yes	yes

Triggers

Trigger Name	Description
TR_BATCHMERCHANDISEINVENTORY_AUDIT_UPDATE
TR_BATCHMERCHANDISEINVENTORY_AUDIT_DELETE

Referenced by

Referenced by	Field
BATCHMERCHANDISEINVENTORYBATCHSYSTEMMESSAGES	BATCHMERCHANDISEINVENTORYID
BATCHMERCHANDISEINVENTORYBATCHUSERMESSAGE	ID
BATCHMERCHANDISEINVENTORYLOOKUPCODE	BATCHMERCHANDISEINVENTORYID