FS
FSAppointmentLogExtItemLine
PX.Objects.FS53 of 53 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocID | int | Appointment Ref. Nbr. | - | |
Description:No description available | ||||
DocRefNbr | nvarchar(20) | Appointment Nbr. | - | |
Description:No description available | ||||
DocType | char(4) | Service Order Type | - | |
Description:No description available | ||||
LineNbr | int | - | ||
Description:No description available | ||||
LineRef | char(3) | Log Ref. Nbr. | - | |
Description:No description available | ||||
ApprovedTime | bit | Approved | - | |
Description:No description available | ||||
BAccountID | int | Staff Member | - | |
Description:No description available | ||||
BAccountType | char(2) | Staff Type | - | |
Description:No description available | ||||
BillableQty | decimal | Billable Quantity | - | |
Description:No description available | ||||
BillableTimeDuration | int | Billable Time | - | |
Description:No description available | ||||
BillableTranAmount | decimal | Base Billable Amount | - | |
Description:No description available | ||||
CostCodeID | int | Cost Code | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | CreatedByID | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | CreatedByScreenID | - | |
Description:No description available | ||||
CreatedDateTime | datetime | CreatedDateTime | - | |
Description:No description available | ||||
CuryBillableTranAmount | decimal | Billable Amount | - | |
Description:No description available | ||||
CuryExtCost | decimal | CuryExtCost | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryUnitCost | decimal | CuryUnitCost | - | |
Description:No description available | ||||
DateTimeBegin | datetime2 | Start Time | - | |
Description:No description available | ||||
DateTimeEnd | datetime2 | End Time | - | |
Description:No description available | ||||
Descr | nvarchar(256) | Description | - | |
Description:No description available | ||||
DetLineRef | char(4) | Detail Ref. Nbr. | - | |
Description:No description available | ||||
EarningType | nvarchar(15) | Earning Type | - | |
Description:No description available | ||||
ExtCost | decimal | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsBillable | bit | Billable Labor | - | |
Description:No description available | ||||
ItemType | char(2) | - | ||
Description:No description available | ||||
KeepDateTimes | bit | Manage Time Manually | - | |
Description:No description available | ||||
LaborItemID | int | Labor Item ID | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | LastModifiedByID | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | LastModifiedByScreenID | - | |
Description:No description available | ||||
LastModifiedDateTime | datetime | LastModifiedDateTime | - | |
Description:No description available | ||||
LogID | int | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | NoteID | - | |
Description:No description available | ||||
ProjectID | int | Project | - | |
Description:No description available | ||||
ProjectTaskID | int | Project Task | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
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. | - | |
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 | - | ||
Description:No description available | ||||
UserID | uniqueidentifier | UserID | Users | |
Description:No description available | ||||
WorkgroupID | int | Workgroup | - | |
Description:No description available | ||||