FS
FSAppointmentLog
PX.Objects.FS50 of 50 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocRefNbr | nvarchar(20) | Appointment Nbr. | FSAppointment | |
Description:No description available | ||||
DocType | char(4) | Service Order Type | FSSrvOrdType | |
Description:No description available | ||||
LineNbr | int | - | ||
Description:No description available | ||||
ApprovedTime | bit | Approved | - | |
Description:No description available | ||||
BAccountID | int | Staff Member | Vendor | |
Description:No description available | ||||
BAccountType | char(2) | Staff Type | - | |
Description:No description available | ||||
BillableQty | decimal(25, 6) | Billable Quantity | - | |
Description:No description available | ||||
BillableTimeDuration | int | Billable Time | - | |
Description:No description available | ||||
BillableTranAmount | decimal(19, 6) | Base Billable Amount | - | |
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
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 | ||||
CuryBillableTranAmount | decimal(19, 6) | Billable Amount | - | |
Description:No description available | ||||
CuryExtCost | decimal(19, 6) | CuryExtCost | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryUnitCost | decimal(19, 6) | CuryUnitCost | - | |
Description:No description available | ||||
DateTimeBegin | datetime | Start Date | - | |
Description:No description available | ||||
DateTimeEnd | datetime | End Date | - | |
Description:No description available | ||||
Descr | nvarchar(256) | Description | - | |
Description:No description available | ||||
DetLineRef | char(4) | Detail Ref. Nbr. | FSAppointmentDet | |
Description:No description available | ||||
DocID | int | Appointment Ref. Nbr. | - | |
Description:No description available | ||||
EarningType | nvarchar(15) | Earning Type | EPEarningType | |
Description:No description available | ||||
ExtCost | decimal(19, 6) | - | ||
Description:No description available | ||||
IsBillable | bit | Billable Labor | - | |
Description:No description available | ||||
ItemType | char(2) | Log Type | - | |
Description:No description available | ||||
KeepDateTimes | bit | Manage Time Manually | - | |
Description:No description available | ||||
LaborItemID | int | Labor Item 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 | ||||
LineRef | char(3) | Log Ref. Nbr. | - | |
Description:No description available | ||||
LogID | int | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | NoteID | - | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
ProjectTaskID | int | Project Task | PMTask | |
Description:No description available | ||||
ServiceDateTimeBeginNonexistent in DB | datetime | ServiceDateTimeBegin | - | |
Description:No description available | ||||
ServiceDateTimeEndNonexistent in DB | datetime | ServiceDateTimeEnd | - | |
Description:No description available | ||||
SkipCostCodeValidationNonexistent in DB | bit | - | ||
Description:No description available | ||||
Status | char(1) | Log Line Status | - | |
Description:No description available | ||||
TimeActivityStatus | nvarchar(2) | - | ||
Description:No description available | ||||
TimeCardCD | nvarchar(10) | Time Card Ref. Nbr. | EPTimeCard | |
Description:No description available | ||||
TimeDuration | int | Duration | - | |
Description:No description available | ||||
TimeDurationReportNonexistent in DB | int | - | ||
Description:No description available | ||||
TrackOnService | bit | Add to Actual Duration | - | |
Description:No description available | ||||
TrackTime | bit | Track Time | - | |
Description:No description available | ||||
TravelNonexistent in DB | bit | Travel | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitCost | decimal(19, 6) | - | ||
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||