CT
ContractDetailAcum
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BaseDiscountAmtNonexistent in DB | decimal? | Setup Discount | - | |
Description:No description available | ||||
BaseDiscountID | nvarchar(10) | - | ||
Description:No description available | ||||
BaseDiscountPct | decimal | Setup Discount,% | - | |
Description:No description available | ||||
BaseDiscountSeq | nvarchar(10) | - | ||
Description:No description available | ||||
BasePrice | decimal | Price/Percent | - | |
Description:No description available | ||||
BasePriceEditableNonexistent in DB | bool? | - | ||
Description:No description available | ||||
BasePriceOption | char(1) | Setup Pricing | - | |
Description:No description available | ||||
BasePriceValNonexistent in DB | decimal? | Setup Price | - | |
Description:No description available | ||||
ChangeNonexistent in DB | decimal? | Difference | - | |
Description:No description available | ||||
ContractDetailID | int | - | ||
Description:No description available | ||||
ContractID | int | Contract | ||
Description:No description available | ||||
ContractItemID | int | Item Code | ContractItem | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
DepositNonexistent in DB | bool? | - | ||
Description:No description available | ||||
DepositAmt | decimal | Deposit Amount | - | |
Description:No description available | ||||
DepositUsed | decimal | Deposit Used | - | |
Description:No description available | ||||
DepositUsedTotal | decimal | Deposit Used Total | - | |
Description:No description available | ||||
Description | nvarchar(255) | Description | - | |
Description:No description available | ||||
FixedRecurringPrice | decimal | Price/Percent | - | |
Description:No description available | ||||
FixedRecurringPriceEditableNonexistent in DB | bool? | - | ||
Description:No description available | ||||
FixedRecurringPriceOption | char(1) | Fixed Recurring | - | |
Description:No description available | ||||
FixedRecurringPriceValNonexistent in DB | decimal? | Recurring Price | - | |
Description:No description available | ||||
Included | decimal | Included | - | |
Description:No description available | ||||
InventoryID | int | Non-Stock Item | InventoryItem | |
Description:No description available | ||||
IsBaseValidNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsFixedRecurringValidNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsRenewalValidNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsUsageValidNonexistent in DB | bool? | - | ||
Description:No description available | ||||
LastBaseDiscountPct | decimal | - | ||
Description:No description available | ||||
LastBilledDate | datetime | Last Billed Date | - | |
Description:No description available | ||||
LastBilledQty | decimal | Last Billed Qty. | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LastQty | decimal | - | ||
Description:No description available | ||||
LastRecurringDiscountPct | decimal | - | ||
Description:No description available | ||||
LastRenewalDiscountPct | decimal | - | ||
Description:No description available | ||||
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
Qty | decimal | Quantity | - | |
Description:No description available | ||||
RecurringDiscountAmtNonexistent in DB | decimal? | Recurring Discount | - | |
Description:No description available | ||||
RecurringDiscountID | nvarchar(10) | - | ||
Description:No description available | ||||
RecurringDiscountPct | decimal | Recurring Discount,% | - | |
Description:No description available | ||||
RecurringDiscountSeq | nvarchar(10) | - | ||
Description:No description available | ||||
RecurringIncludedNonexistent in DB | decimal? | Included | - | |
Description:No description available | ||||
RecurringUsedNonexistent in DB | decimal? | Unbilled | - | |
Description:No description available | ||||
RecurringUsedTotalNonexistent in DB | decimal? | Used Total | - | |
Description:No description available | ||||
RenewalDiscountAmtNonexistent in DB | decimal? | Renewal Discount | - | |
Description:No description available | ||||
RenewalDiscountID | nvarchar(10) | - | ||
Description:No description available | ||||
RenewalDiscountPct | decimal | Renewal Discount,% | - | |
Description:No description available | ||||
RenewalDiscountSeq | nvarchar(10) | - | ||
Description:No description available | ||||
RenewalPrice | decimal | Price/Percent | - | |
Description:No description available | ||||
RenewalPriceEditableNonexistent in DB | bool? | - | ||
Description:No description available | ||||
RenewalPriceOption | char(1) | Renewal Pricing | - | |
Description:No description available | ||||
RenewalPriceValNonexistent in DB | decimal? | Renewal Price | - | |
Description:No description available | ||||
ResetUsage | char(1) | Reset Usage | - | |
Description:No description available | ||||
RevID | int | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UsagePrice | decimal | Price/Percent | - | |
Description:No description available | ||||
UsagePriceEditableNonexistent in DB | bool? | - | ||
Description:No description available | ||||
UsagePriceOption | char(1) | Usage Price | - | |
Description:No description available | ||||
UsagePriceValNonexistent in DB | decimal? | Extra Usage Price | - | |
Description:No description available | ||||
Used | decimal | Used | - | |
Description:No description available | ||||
UsedTotal | decimal | Used Total | - | |
Description:No description available | ||||
WarningAmountForDepositNonexistent in DB | bool? | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||