Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 1:00:55 AM Thursday, March 21, 2019 |
Last Modified | 1:00:55 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls |
---|---|---|---|
ID | int | 4 | False |
InvoiceID | int | 4 | False |
Period | int | 4 | False |
ComOutcostGP | money | 8 | True |
ComContrivedGP | decimal(38,6) | 17 | True |
ComMethod | varchar(5) | 5 | True |
ComCode | varchar(5) | 5 | True |
ComRate | decimal(18,2) | 9 | True |
ComNetVal1 | varchar(32) | 32 | True |
ComNetVal1Amount | money | 8 | True |
ComNetFactor1 | decimal(18,2) | 9 | True |
Cost | money | 8 | True |
Amount | money | 8 | True |
ComNetVal2 | varchar(32) | 32 | True |
ComNetVal2Amount | money | 8 | True |
ComNetFactor2 | decimal(18,2) | 9 | True |
ComNetFee | money | 8 | True |
ComLinkedPONumbers | varchar(224) | 224 | True |
ComDepartmentExpense | money | 8 | True |
ComAllocatedUnitDeptPOExpense | money | 8 | True |
ComContrivedOutcost | decimal(21,6) | 13 | True |
ComContrivedOutcostExtended | decimal(38,6) | 17 | True |
ComContrivedPrice | decimal(21,6) | 13 | True |
ComContrivedAmount | decimal(38,6) | 17 | True |
ComContrivedSource | varchar(3) | 3 | True |
ComEligible | bit | 1 | True |
ComOverride | bit | 1 | True |
ComOverrideRule | varchar(32) | 32 | False |
ComPreRuleRate | decimal(18,2) | 9 | False |
ComPrevalentRuleRate | decimal(18,2) | 9 | False |
ComRule1 | varchar(32) | 32 | False |
ComRule1Desc | varchar(256) | 256 | False |
ComRule1EligibilityFactor | bit | 1 | True |
ComRule1Override | bit | 1 | True |
ComRule1UseQryRate | bit | 1 | True |
ComRule1Rate | decimal(18,2) | 9 | False |
ComRule2 | varchar(32) | 32 | False |
ComRule2Desc | varchar(256) | 256 | False |
ComRule2EligibilityFactor | bit | 1 | True |
ComRule2Override | bit | 1 | True |
ComRule2UseQryRate | bit | 1 | True |
ComRule2Rate | decimal(18,2) | 9 | False |