Tables [dbo].[QVInventoryAging]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:58:42 AM Thursday, March 21, 2019
Last Modified12:58:42 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
ItemIDint4
True
StandardQtydecimal(18,0)9
True
OnHandQtydecimal(18,0)9
True
AvailableQtydecimal(18,0)9
True
Allocateddecimal(18,0)9
True
Rcv30decimal(18,0)9
True
Rcv60decimal(18,0)9
True
Rcv90decimal(18,0)9
True
Rcv120decimal(18,0)9
True
Rcv150decimal(18,0)9
True
RcvOverdecimal(18,0)9
True
Sales30decimal(18,0)9
True
Sales60decimal(18,0)9
True
Sales90decimal(18,0)9
True
Sales120decimal(18,0)9
True
Sales150decimal(18,0)9
True
SalesOverdecimal(18,0)9
True
AvgCostmoney8
True
ItemDescvarchar(256)256
True
Categoryvarchar(60)60
True
InvCodevarchar(50)50
True
SalesCodevarchar(50)50
True
ServiceCodevarchar(50)50
True
Modelvarchar(128)128
True
Serializedbit1
True
Itemvarchar(64)64
True
Updateddatetime8
True
CREATE TABLE [dbo].[QVInventoryAging]
(
[ItemID] [int] NULL,
[StandardQty] [decimal] (18, 0) NULL,
[OnHandQty] [decimal] (18, 0) NULL,
[AvailableQty] [decimal] (18, 0) NULL,
[Allocated] [decimal] (18, 0) NULL,
[Rcv30] [decimal] (18, 0) NULL,
[Rcv60] [decimal] (18, 0) NULL,
[Rcv90] [decimal] (18, 0) NULL,
[Rcv120] [decimal] (18, 0) NULL,
[Rcv150] [decimal] (18, 0) NULL,
[RcvOver] [decimal] (18, 0) NULL,
[Sales30] [decimal] (18, 0) NULL,
[Sales60] [decimal] (18, 0) NULL,
[Sales90] [decimal] (18, 0) NULL,
[Sales120] [decimal] (18, 0) NULL,
[Sales150] [decimal] (18, 0) NULL,
[SalesOver] [decimal] (18, 0) NULL,
[AvgCost] [money] NULL,
[ItemDesc] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Category] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SalesCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ServiceCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Model] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Serialized] [bit] NULL,
[Item] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Updated] [datetime] NULL
) ON [PRIMARY]
GO