iVend Database Database : SBOInventoryUpdates Table

Creation Date

10/8/2018 5:57 PM

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

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

RecordId

VarWChar

50

TransNum

VarWChar

50

TransType

VarWChar

50

((-1))

CreatedBy

Integer

4

BASE_REF

VarWChar

11

ItemCode

VarWChar

50

InQty

Numeric

9 (19,6)

OutQty

Numeric

9 (19,6)

Warehouse

VarWChar

20

Location

VarWChar

50

BranchCode

VarWChar

50

Index

Description

Primary

Unique

OINM_PRIMARY

Trigger

Description

TrgSBOInventoryUpdate

Handles updates made to item inventory in the ERP system (Business One in this case)

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[SBOInventoryUpdates](

[RecordId] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[TransNum] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[TransType] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CreatedBy] [int] NULL,

[BASE_REF] [nvarchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ItemCode] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[InQty] [numeric](19, 6) NOT NULL,

[OutQty] [numeric](19, 6) NOT NULL,

[Warehouse] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Location] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[BranchCode] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

CONSTRAINT [OINM_PRIMARY] PRIMARY KEY CLUSTERED

(

[RecordId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

ALTER TABLE [dbo].[SBOInventoryUpdates] ADD CONSTRAINT [DF_OINM_TransType] DEFAULT ((-1)) FOR [TransType]