Tables [dbo].[SOSChargeOutUpload]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:52 AM Thursday, March 21, 2019
Last Modified1:00:52 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
Itemidint4
True
Itemvarchar(30)30
True
PriceLevelidint4
True
PriceLevelvarchar(30)30
True
Chargeoutmoney8
True
Productvarchar(30)30
True
PGroupvarchar(30)30
True
ProductDescvarchar(50)50
True
ItemPriceIdint4
True
CREATE TABLE [dbo].[SOSChargeOutUpload]
(
[Itemid] [int] NULL,
[Item] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PriceLevelid] [int] NULL,
[PriceLevel] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Chargeout] [money] NULL,
[Product] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PGroup] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProductDesc] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ItemPriceId] [int] NULL
) ON [PRIMARY]
GO