Tables [dbo].[ARInvoiceUnifiedDetailExtended]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:56:48 AM Thursday, March 21, 2019
Last Modified12:56:48 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsIdentity
IDint4
False
1 - 1
InvoiceIDint4
False
SourceID1int4
False
SourceID2int4
False
InvTypePlusDetailvarchar(37)37
False
InvoiceNumbervarchar(15)15
False
Datedatetime8
False
Periodint4
False
Itemvarchar(255)255
True
Descriptionvarchar(1068)1068
True
Quantitydecimal(29,6)17
True
Pricedecimal(21,6)13
True
Costmoney8
True
Amountmoney8
True
ItemIDint4
True
WarehouseIDint4
True
BinIDint4
True
Outcostmoney8
True
OutcostExtendedmoney8
True
Taxnumeric(10,2)9
True
ItemTypevarchar(37)37
False
InvoiceTypevarchar(16)16
False
TransactionTypevarchar(64)64
False
SalesRepIDint4
True
CustomerIDint4
False
BillToIDint4
False
BillCodeIDint4
True
CallIDint4
True
ContractIDint4
True
EquipmentIDint4
True
TransactionDetailBinIDint4
True
SOIDint4
True
SODetailIDint4
True
OriginalInvoiceNumbervarchar(15)15
False
ARInvoiceLastUpdatedatetime8
False
CREATE TABLE [dbo].[ARInvoiceUnifiedDetailExtended]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[InvoiceID] [int] NOT NULL,
[SourceID1] [int] NOT NULL,
[SourceID2] [int] NOT NULL,
[InvTypePlusDetail] [varchar] (37) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[InvoiceNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Date] [datetime] NOT NULL,
[Period] [int] NOT NULL,
[Item] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (1068) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Quantity] [decimal] (29, 6) NULL,
[Price] [decimal] (21, 6) NULL,
[Cost] [money] NULL,
[Amount] [money] NULL,
[ItemID] [int] NULL,
[WarehouseID] [int] NULL,
[BinID] [int] NULL,
[Outcost] [money] NULL,
[OutcostExtended] [money] NULL,
[Tax] [numeric] (10, 2) NULL,
[ItemType] [varchar] (37) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[InvoiceType] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TransactionType] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SalesRepID] [int] NULL,
[CustomerID] [int] NOT NULL,
[BillToID] [int] NOT NULL,
[BillCodeID] [int] NULL,
[CallID] [int] NULL,
[ContractID] [int] NULL,
[EquipmentID] [int] NULL,
[TransactionDetailBinID] [int] NULL,
[SOID] [int] NULL,
[SODetailID] [int] NULL,
[OriginalInvoiceNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ARInvoiceLastUpdate] [datetime] NOT NULL
) ON [PRIMARY]
GO