FS
FSContractForecastDet
PX.Objects.FS34 of 34 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ForecastID | uniqueidentifier | FSContractForecast | ||
Description:No description available | ||||
LineNbr | int | - | ||
Description:No description available | ||||
ServiceContractID | int | - | ||
Description:No description available | ||||
BillingRule | char(4) | Billing Rule | - | |
Description:No description available | ||||
ComponentID | int | - | ||
Description:No description available | ||||
ContractPeriodDetID | int | - | ||
Description:No description available | ||||
ContractPeriodID | int | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | CreatedByID | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | CreatedByScreenID | - | |
Description:No description available | ||||
CreatedDateTime | datetime | CreatedDateTime | - | |
Description:No description available | ||||
EquipmentAction | char(2) | Equipment Action | - | |
Description:No description available | ||||
EquipmentLineRef | int | Component Line Ref. | FSEquipmentComponent | |
Description:No description available | ||||
ExtPrice | decimal(19, 4) | Ext. Price | - | |
Description:No description available | ||||
ForecastDetType | char(1) | Forecast Type | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | LastModifiedByID | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | LastModifiedByScreenID | - | |
Description:No description available | ||||
LastModifiedDateTime | datetime | LastModifiedDateTime | - | |
Description:No description available | ||||
LineType | char(5) | Line Type | - | |
Description:No description available | ||||
Occurrences | int | - | ||
Description:No description available | ||||
OveragePrice | decimal(19, 6) | Overage Price | - | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
ProjectTaskID | int | Project Task | PMTask | |
Description:No description available | ||||
Qty | decimal(25, 6) | Quantity | - | |
Description:No description available | ||||
RecurrenceDesc | varchar(MAX) | Recurrence Description | - | |
Description:No description available | ||||
ScheduleDetID | int | - | ||
Description:No description available | ||||
ScheduleID | int | - | ||
Description:No description available | ||||
SMEquipmentID | int | Target Equipment ID | - | |
Description:No description available | ||||
TimeDuration | int | Duration | - | |
Description:No description available | ||||
TotalPrice | decimal(19, 4) | Total Price per Duration | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitPrice | decimal(19, 6) | Unit Price | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||