Tables [dbo].[v_ARInvoiceCommonDetail_Commission_Distributed]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:55 AM Thursday, March 21, 2019
Last Modified1:00:55 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
IDint4
False
InvoiceIDint4
False
Periodint4
False
DistNextEFDdatetime8
True
DistPrevEFDdatetime8
True
DistEFDdatetime8
True
DistSalesRepSharedecimal(16,4)9
True
DistHWAmountdecimal(38,10)17
True
DistSVCAmountdecimal(38,10)17
True
DistSUPAmountdecimal(38,10)17
True
DistOTHAmountdecimal(38,10)17
True
DistOutcostCommAmountmoney8
True
DistOutcostCommPaymoney8
True
DistSalesRepIDint4
True
DistSalesRepNumbervarchar(15)15
True
DistSalesRepManagerIDbigint8
True
DistSalesRepManagerNumbervarchar(15)15
True
DistConfigTypevarchar(255)255
True
DistContrivedGPdecimal(38,6)17
True
DistContrivedOutcostExtendeddecimal(38,6)17
True
DistContrivedAmountdecimal(38,6)17
True
CREATE TABLE [dbo].[v_ARInvoiceCommonDetail_Commission_Distributed]
(
[ID] [int] NOT NULL,
[InvoiceID] [int] NOT NULL,
[Period] [int] NOT NULL,
[DistNextEFD] [datetime] NULL,
[DistPrevEFD] [datetime] NULL,
[DistEFD] [datetime] NULL,
[DistSalesRepShare] [decimal] (16, 4) NULL,
[DistHWAmount] [decimal] (38, 10) NULL,
[DistSVCAmount] [decimal] (38, 10) NULL,
[DistSUPAmount] [decimal] (38, 10) NULL,
[DistOTHAmount] [decimal] (38, 10) NULL,
[DistOutcostCommAmount] [money] NULL,
[DistOutcostCommPay] [money] NULL,
[DistSalesRepID] [int] NULL,
[DistSalesRepNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DistSalesRepManagerID] [bigint] NULL,
[DistSalesRepManagerNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DistConfigType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DistContrivedGP] [decimal] (38, 6) NULL,
[DistContrivedOutcostExtended] [decimal] (38, 6) NULL,
[DistContrivedAmount] [decimal] (38, 6) NULL
) ON [PRIMARY]
GO