FS
FSAppointment
PX.Objects.FSView API Entity: Appointment
/entity/Default/24.200.001/Appointment187 of 187 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
RefNbr | nvarchar(20) | Appointment Nbr. | FSAppointment | |
Description:No description available | ||||
SrvOrdType | char(4) | Service Order Type | FSSrvOrdType | |
Description:No description available | ||||
ActualBillableTotalNonexistent in DB | decimal | Actual Billable Total | - | |
Description:No description available | ||||
ActualDateTimeBegin | datetime | Actual Start Date | - | |
Description:No description available | ||||
ActualDateTimeBeginUTC | datetime | Actual Date | - | |
Description:No description available | ||||
ActualDateTimeEnd | datetime | Actual End Date | - | |
Description:No description available | ||||
ActualDateTimeEndUTC | datetime | Actual Date End | - | |
Description:No description available | ||||
int | Actual Duration | - | ||
Description:No description available | ||||
ActualDurationTotal | int | Actual Duration | - | |
Description:No description available | ||||
ActualDurationTotalReportNonexistent in DB | int | - | ||
Description:No description available | ||||
APBillLineCntr | int | - | ||
Description:No description available | ||||
AppCompletedBillableTotalNonexistent in DB | decimal | Appointment Billable Total | - | |
Description:No description available | ||||
AppointmentID | int | - | ||
Description:No description available | ||||
AppointmentRefReportNonexistent in DB | int | - | ||
Description:No description available | ||||
AreActualFieldsActiveNonexistent in DB | bit | - | ||
Description:No description available | ||||
AutoDocDesc | nvarchar(255) | Service Description | - | |
Description:No description available | ||||
Awaiting | bit | Awaiting | - | |
Description:No description available | ||||
BillableLineTotal | decimal(19, 4) | Base Billable Total | - | |
Description:No description available | ||||
BillContractPeriodID | int | Contract Period | - | |
Description:No description available | ||||
BillCustomerIDNonexistent in DB | int | Billing Customer | Customer | |
Description:No description available | ||||
Billed | bit | Billed | - | |
Description:No description available | ||||
BillServiceContractID | int | Service Contract | FSServiceContract | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CancelActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
Canceled | bit | Canceled | - | |
Description:No description available | ||||
CloseActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
Closed | bit | Closed | - | |
Description:No description available | ||||
Commissionable | bit | Commissionable | - | |
Description:No description available | ||||
CompleteActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
Confirmed API | bit | Confirmed | - | |
Description:No description available | ||||
CostTotal API | decimal(19, 6) | CostTotal | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | CreatedByScreenID | - | |
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryActualBillableTotalNonexistent in DB | decimal | Actual Billable Total | - | |
Description:No description available | ||||
CuryBillableLineTotal | decimal(19, 4) | Actual Billable Total | - | |
Description:No description available | ||||
CuryCostTotal | decimal(19, 6) | Cost Total | - | |
Description:No description available | ||||
CuryDiscTot | decimal(19, 4) | Discount Total | - | |
Description:No description available | ||||
CuryDocDiscNonexistent in DB | decimal | Document Discount | - | |
Description:No description available | ||||
CuryDocTotal | decimal(19, 4) | Invoice Total | - | |
Description:No description available | ||||
CuryEstimatedCostTotal | decimal(19, 4) | Estimated Cost Total | - | |
Description:No description available | ||||
CuryEstimatedLineTotal | decimal(19, 4) | Estimated Total | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineDocDiscountTotalNonexistent in DB | decimal | CuryLineDocDiscountTotal | - | |
Description:No description available | ||||
CuryLineTotal | decimal(19, 4) | Ext. Price Total | - | |
Description:No description available | ||||
CuryLogBillableTranAmountTotal | decimal(19, 6) | Billable Labor Total | - | |
Description:No description available | ||||
CuryTaxTotal | decimal(19, 4) | Actual Tax Total | - | |
Description:No description available | ||||
CuryVatExemptTotal | decimal(19, 4) | VAT Exempt Total | - | |
Description:No description available | ||||
CuryVatTaxableTotal | decimal(19, 4) | VAT Taxable Total | - | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
customerSignaturePath | nvarchar(MAX) | Customer Signature | - | |
Description:No description available | ||||
CustomerSignedReport | uniqueidentifier | Signed Report ID | - | |
Description:No description available | ||||
CutOffDate | datetime | Cut-Off Date | - | |
Description:No description available | ||||
DeliveryNotes | nvarchar(MAX) | Delivery Notes | - | |
Description:No description available | ||||
DfltProjectTaskID | int | Default Project Task | PMTask | |
Description:No description available | ||||
DiscTot | decimal(19, 4) | Discount Total | - | |
Description:No description available | ||||
DocDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
DocDiscNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DocTotal | decimal(19, 4) | Base Order Total | - | |
Description:No description available | ||||
DriveTime | int | Driving Time | - | |
Description:No description available | ||||
EditActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
EffDocDateNonexistent in DB | datetime | Effective Document Date | - | |
Description:No description available | ||||
EmployeeLineCntr | int | - | ||
Description:No description available | ||||
EntityUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
EstimatedCostTotal | decimal(19, 4) | EstimatedCostTotal | - | |
Description:No description available | ||||
EstimatedDurationTotal | int | Estimated Duration | - | |
Description:No description available | ||||
EstimatedLineTotal | decimal(19, 4) | Base Estimated Total | - | |
Description:No description available | ||||
ExecutionDate | datetime | Actual Start Date | - | |
Description:No description available | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:No description available | ||||
Finished API | bit | Finished | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
FullNameSignature | nvarchar(255) | Full Name | - | |
Description:No description available | ||||
GeneratedByContract | bit | Generated by Contract | - | |
Description:No description available | ||||
GenerationID | int | Generation ID | - | |
Description:No description available | ||||
GPSLatitudeComplete | decimal(9, 6) | Latitude | - | |
Description:No description available | ||||
GPSLatitudeStart | decimal(9, 6) | Latitude | - | |
Description:No description available | ||||
GPSLongitudeComplete | decimal(9, 6) | Longitude | - | |
Description:No description available | ||||
GPSLongitudeStart | decimal(9, 6) | Longitude | - | |
Description:No description available | ||||
HandleManuallyActualTime | bit | Handle Manually | - | |
Description:No description available | ||||
HandleManuallyScheduleTime | bit | Handle Manually | - | |
Description:No description available | ||||
Hold API | bit | Hold | - | |
Description:No description available | ||||
InProcess | bit | In Process | - | |
Description:No description available | ||||
IntTravelInProcessNonexistent in DB | int | - | ||
Description:No description available | ||||
IsCalledFromQuickProcessNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsPostedNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsPrepaymentEnableNonexistent in DB | bit | IsPrepaymentEnable | - | |
Description:No description available | ||||
IsReassignedNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsRouteAppoinmentNonexistent in DB | bit | IsRouteAppoinment | - | |
Description:No description available | ||||
IsTaxValid | bit | Tax Is Up to Date | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | LastModifiedByID | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | LastModifiedByScreenID | - | |
Description:No description available | ||||
LastModifiedDateTime API | datetime | Last Modified On | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineTotal | decimal(19, 4) | Base Ext. Price Total | - | |
Description:No description available | ||||
LogBillableTranAmountTotal | decimal(19, 6) | Base Billable Labor Total | - | |
Description:No description available | ||||
LogLineCntr | int | - | ||
Description:No description available | ||||
LongDescr | nvarchar(MAX) | Description | - | |
Description:No description available | ||||
MapLatitude | decimal(9, 6) | Latitude | - | |
Description:No description available | ||||
MapLongitude | decimal(9, 6) | Longitude | - | |
Description:No description available | ||||
MaxLineNbr | int | - | ||
Description:No description available | ||||
MaxLogTimeEnd | datetime | Max Log Time End | - | |
Description:No description available | ||||
Mem_ActualDateTime_MonthNonexistent in DB | nvarchar(MAX) | Month | - | |
Description:No description available | ||||
Mem_ActualDateTime_YearNonexistent in DB | int | Year | - | |
Description:No description available | ||||
Mem_ActualDateTimeBegin_TimeNonexistent in DB | int | Actual Start Time | - | |
Description:No description available | ||||
Mem_ActualDateTimeEnd_TimeNonexistent in DB | int | Actual End Time | - | |
Description:No description available | ||||
Mem_AppointmentHoursNonexistent in DB | decimal | Appointment Hours | - | |
Description:No description available | ||||
Mem_BatchNbrNonexistent in DB | nchar(15) | Batch Nbr. | - | |
Description:No description available | ||||
Mem_BusinessDateTimeNonexistent in DB | datetime | - | ||
Description:No description available | ||||
Mem_GPSLatitudeLongitudeNonexistent in DB | nvarchar(255) | GPS Latitude Longitude | - | |
Description:No description available | ||||
Mem_IdleRateNonexistent in DB | decimal | Idle Rate (%) | - | |
Description:No description available | ||||
Mem_InvoiceDateNonexistent in DB | datetime | - | ||
Description:No description available | ||||
Mem_InvoiceDocTypeNonexistent in DB | nvarchar(MAX) | Invoice Doc Type | - | |
Description:No description available | ||||
Mem_InvoiceRefNonexistent in DB | nvarchar(15) | Invoice Ref. Nbr. | - | |
Description:No description available | ||||
Mem_OccupationalRateNonexistent in DB | decimal | Occupational Rate (%) | - | |
Description:No description available | ||||
Mem_ScheduledHoursNonexistent in DB | decimal | Scheduled Hours | - | |
Description:No description available | ||||
Mem_ScheduledTimeBeginNonexistent in DB | datetime | - | ||
Description:No description available | ||||
Mem_SMequipmentIDNonexistent in DB | int | - | ||
Description:No description available | ||||
MinLogTimeBegin | datetime | Min Log Time Begin | - | |
Description:No description available | ||||
MustUpdateServiceOrderNonexistent in DB | bit | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | NoteID | - | |
Description:No description available | ||||
NotStarted | bit | Not Started | - | |
Description:No description available | ||||
OriginalAppointmentID | int | Original Appointment ID | - | |
Description:No description available | ||||
PauseActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
Paused | bit | Paused | - | |
Description:No description available | ||||
PendingAPARSOPost | bit | - | ||
Description:No description available | ||||
PendingApptPOLineCntr | int | - | ||
Description:No description available | ||||
PendingINPost | bit | - | ||
Description:No description available | ||||
PendingPOLineCntr | int | - | ||
Description:No description available | ||||
PostingStatusAPARSO | char(2) | PostingStatusAPARSO | - | |
Description:No description available | ||||
PostingStatusIN | char(2) | PostingStatusIN | - | |
Description:No description available | ||||
PrimaryDriver | int | Primary Driver | BAccount | |
Description:No description available | ||||
ProfitMarginPercentNonexistent in DB | decimal | Profit Margin (%) | - | |
Description:No description available | ||||
ProfitPercentNonexistent in DB | decimal | Profit Markup (%) | - | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
ReloadServiceOrderRelatedNonexistent in DB | bit | - | ||
Description:No description available | ||||
ReopenActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
ResumeActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
ROOptimizationStatus | char(2) | Optimization Result | - | |
Description:No description available | ||||
ROOriginalSortOrder | int | Nbr. in Original Sequence | - | |
Description:No description available | ||||
ROSortOrder | int | Nbr. in Optimized Sequence | - | |
Description:No description available | ||||
RouteDocumentID | int | Route Nbr. | FSRouteDocument | |
Description:No description available | ||||
RouteID | int | Route ID | FSRoute | |
Description:No description available | ||||
RoutePosition | int | Route Position | - | |
Description:No description available | ||||
SalesPersonID | int | Salesperson | SalesPerson | |
Description:No description available | ||||
ScheduledDateBeginNonexistent in DB | datetime | - | ||
Description:No description available | ||||
ScheduledDateTimeBegin | datetime | Scheduled Start Date | - | |
Description:No description available | ||||
ScheduledDateTimeBeginUTC | datetime | Scheduled Date | - | |
Description:No description available | ||||
ScheduledDateTimeEnd | datetime | Scheduled End Date | - | |
Description:No description available | ||||
ScheduledDateTimeEndUTC | datetime | Scheduled Date End | - | |
Description:No description available | ||||
int | Scheduled Duration | - | ||
Description:No description available | ||||
ScheduleID | int | Source Schedule ID | FSSchedule | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ServiceContractID | int | Source Service Contract ID | FSServiceContract | |
Description:No description available | ||||
SkipExternalTaxCalculationNonexistent in DB | bit | Skip External Tax Calculation | - | |
Description:No description available | ||||
SOID | int | - | ||
Description:No description available | ||||
SORefNbr | nvarchar(15) | Service Order Nbr. | FSServiceOrder | |
Description:No description available | ||||
SplitLineCntr | int | - | ||
Description:No description available | ||||
SrvOrdTypeCodeNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
StaffCntr | int | - | ||
Description:No description available | ||||
StartActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
Status API | char(1) | Status | - | |
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxTotal API | decimal(19, 4) | - | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Customer Tax Zone | TaxZone | |
Description:No description available | ||||
TimeLocked | bit | Time Locked | - | |
Description:No description available | ||||
TimeRegistered | bit | Approved Staff Times | - | |
Description:No description available | ||||
TrackTimeChangedNonexistent in DB | bit | TrackTimeChanged | - | |
Description:No description available | ||||
TravelCanBeCompletedNonexistent in DB | bit | TravelCanBeCompleted | - | |
Description:No description available | ||||
TravelCanBeStartedNonexistent in DB | bit | TravelCanBeStarted | - | |
Description:No description available | ||||
TravelInProcess | bit | Travel in Process | - | |
Description:No description available | ||||
tstamp | timestamp | tstamp | - | |
Description:No description available | ||||
UnCloseActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
UnreachedCustomer API | bit | Unreached Customer | - | |
Description:No description available | ||||
UserConfirmedUnclosingNonexistent in DB | bit | - | ||
Description:No description available | ||||
ValidatedByDispatcher API | bit | Validated by Dispatcher | - | |
Description:No description available | ||||
VatExemptTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
VehicleID | int | Vehicle ID | FSEquipment | |
Description:No description available | ||||
WaitingForParts | bit | Waiting for Purchased Items | - | |
Description:No description available | ||||
WFStageID | int | Workflow Stage | FSWFStage | |
Description:No description available | ||||
WildCard_AssignedEmployeesCellPhoneListNonexistent in DB | nvarchar(MAX) | Assigned employees cells list | - | |
Description:No description available | ||||
WildCard_AssignedEmployeesListNonexistent in DB | nvarchar(MAX) | Assigned employees list | - | |
Description:No description available | ||||
WildCard_CustomerPrimaryContactNonexistent in DB | nvarchar(MAX) | Customer primary contact | - | |
Description:No description available | ||||
WildCard_CustomerPrimaryContactCellNonexistent in DB | nvarchar(MAX) | Customer primary contact cell | - | |
Description:No description available | ||||
WorkflowTypeID | char(2) | Workflow Type | - | |
Description:No description available | ||||