Tables [dbo].[v_ARInvoiceCommonDetail_Commission]
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
ComOutcostGPmoney8
True
ComContrivedGPdecimal(38,6)17
True
ComMethodvarchar(5)5
True
ComCodevarchar(5)5
True
ComRatedecimal(18,2)9
True
ComNetVal1varchar(32)32
True
ComNetVal1Amountmoney8
True
ComNetFactor1decimal(18,2)9
True
Costmoney8
True
Amountmoney8
True
ComNetVal2varchar(32)32
True
ComNetVal2Amountmoney8
True
ComNetFactor2decimal(18,2)9
True
ComNetFeemoney8
True
ComLinkedPONumbersvarchar(224)224
True
ComDepartmentExpensemoney8
True
ComAllocatedUnitDeptPOExpensemoney8
True
ComContrivedOutcostdecimal(21,6)13
True
ComContrivedOutcostExtendeddecimal(38,6)17
True
ComContrivedPricedecimal(21,6)13
True
ComContrivedAmountdecimal(38,6)17
True
ComContrivedSourcevarchar(3)3
True
ComEligiblebit1
True
ComOverridebit1
True
ComOverrideRulevarchar(32)32
False
ComPreRuleRatedecimal(18,2)9
False
ComPrevalentRuleRatedecimal(18,2)9
False
ComRule1varchar(32)32
False
ComRule1Descvarchar(256)256
False
ComRule1EligibilityFactorbit1
True
ComRule1Overridebit1
True
ComRule1UseQryRatebit1
True
ComRule1Ratedecimal(18,2)9
False
ComRule2varchar(32)32
False
ComRule2Descvarchar(256)256
False
ComRule2EligibilityFactorbit1
True
ComRule2Overridebit1
True
ComRule2UseQryRatebit1
True
ComRule2Ratedecimal(18,2)9
False
CREATE TABLE [dbo].[v_ARInvoiceCommonDetail_Commission]
(
[ID] [int] NOT NULL,
[InvoiceID] [int] NOT NULL,
[Period] [int] NOT NULL,
[ComOutcostGP] [money] NULL,
[ComContrivedGP] [decimal] (38, 6) NULL,
[ComMethod] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ComCode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ComRate] [decimal] (18, 2) NULL,
[ComNetVal1] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ComNetVal1Amount] [money] NULL,
[ComNetFactor1] [decimal] (18, 2) NULL,
[Cost] [money] NULL,
[Amount] [money] NULL,
[ComNetVal2] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ComNetVal2Amount] [money] NULL,
[ComNetFactor2] [decimal] (18, 2) NULL,
[ComNetFee] [money] NULL,
[ComLinkedPONumbers] [varchar] (224) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ComDepartmentExpense] [money] NULL,
[ComAllocatedUnitDeptPOExpense] [money] NULL,
[ComContrivedOutcost] [decimal] (21, 6) NULL,
[ComContrivedOutcostExtended] [decimal] (38, 6) NULL,
[ComContrivedPrice] [decimal] (21, 6) NULL,
[ComContrivedAmount] [decimal] (38, 6) NULL,
[ComContrivedSource] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ComEligible] [bit] NULL,
[ComOverride] [bit] NULL,
[ComOverrideRule] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ComPreRuleRate] [decimal] (18, 2) NOT NULL,
[ComPrevalentRuleRate] [decimal] (18, 2) NOT NULL,
[ComRule1] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ComRule1Desc] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ComRule1EligibilityFactor] [bit] NULL,
[ComRule1Override] [bit] NULL,
[ComRule1UseQryRate] [bit] NULL,
[ComRule1Rate] [decimal] (18, 2) NOT NULL,
[ComRule2] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ComRule2Desc] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ComRule2EligibilityFactor] [bit] NULL,
[ComRule2Override] [bit] NULL,
[ComRule2UseQryRate] [bit] NULL,
[ComRule2Rate] [decimal] (18, 2) NOT NULL
) ON [PRIMARY]
GO