CT
ContractDetailAcum
PX.Objects.CT69 of 69 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ContractDetailID | int | - | ||
Description:No description available | ||||
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 | bit | - | ||
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 | ||||
ContractID | int | - | ||
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 | bit | - | ||
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 | bit | - | ||
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(25, 6) | Included | - | |
Description:No description available | ||||
InventoryID | int | - | ||
Description:No description available | ||||
IsBaseValid | bit | - | ||
Description:No description available | ||||
IsFixedRecurringValid | bit | - | ||
Description:No description available | ||||
IsRenewalValid | bit | - | ||
Description:No description available | ||||
IsUsageValid | bit | - | ||
Description:No description available | ||||
LastBaseDiscountPct | decimal | - | ||
Description:No description available | ||||
LastBilledDate | datetime2 | Last Billed Date | - | |
Description:No description available | ||||
LastBilledQty | decimal(19, 4) | 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 | - | ||
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 | bit | - | ||
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 | bit | Selected | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UsagePrice | decimal | Price/Percent | - | |
Description:No description available | ||||
UsagePriceEditableNonexistent in DB | bit | - | ||
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(25, 6) | Used | - | |
Description:No description available | ||||
UsedTotal | decimal(25, 6) | Used Total | - | |
Description:No description available | ||||
WarningAmountForDepositNonexistent in DB | bit | - | ||
Description:No description available | ||||