FS
RouteAppointmentInfo
PX.Objects.FS206 of 206 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 | datetime2 | Actual Start Date | - | |
Description:No description available | ||||
ActualDateTimeBeginUTC | datetime2 | Actual Date | - | |
Description:No description available | ||||
ActualDateTimeEnd | datetime2 | Actual End Date | - | |
Description:No description available | ||||
ActualDateTimeEndUTC | datetime2 | Actual Date End | - | |
Description:No description available | ||||
ActualDurationNonexistent in DB | int | Actual Duration | - | |
Description:No description available | ||||
ActualDurationTotal | int | Actual Duration | - | |
Description:No description available | ||||
ActualDurationTotalReportNonexistent in DB | int | - | ||
Description:No description available | ||||
AddressLine1 | nvarchar(50) | Address Line 1 | - | |
Description:No description available | ||||
AddressLine2 | nvarchar(50) | Address Line 2 | - | |
Description:No description available | ||||
AddressLine3 | nvarchar(50) | Address Line 3 | - | |
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 | Base Billable Total | - | |
Description:No description available | ||||
BillContractPeriodID | int | Contract Period | - | |
Description:No description available | ||||
BillCustomerID | int | Billing Customer ID | Customer | |
Description:No description available | ||||
Billed | bit | Billed | - | |
Description:No description available | ||||
BillLocationID | int | Billing Location | Location | |
Description:No description available | ||||
BillServiceContractID | int | Service Contract | FSServiceContract | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
BranchLocationID | int | Branch Location ID | FSBranchLocation | |
Description:No description available | ||||
CancelActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
Canceled | bit | Canceled | - | |
Description:No description available | ||||
City | nvarchar(50) | City | - | |
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 | bit | Confirmed | - | |
Description:No description available | ||||
CostTotal | decimal | CostTotal | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(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 | Actual Billable Total | - | |
Description:No description available | ||||
CuryCostTotal | decimal | Cost Total | - | |
Description:No description available | ||||
CuryDiscTot | decimal | Discount Total | - | |
Description:No description available | ||||
CuryDocDiscNonexistent in DB | decimal | Document Discount | - | |
Description:No description available | ||||
CuryDocTotal | decimal | Invoice Total | - | |
Description:No description available | ||||
CuryEstimatedCostTotal | decimal | Estimated Cost Total | - | |
Description:No description available | ||||
CuryEstimatedLineTotal | decimal | 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 | Ext. Price Total | - | |
Description:No description available | ||||
CuryLogBillableTranAmountTotal | decimal | Billable Labor Total | - | |
Description:No description available | ||||
CuryTaxTotal | decimal | Actual Tax Total | - | |
Description:No description available | ||||
CuryVatExemptTotal | decimal | VAT Exempt Total | - | |
Description:No description available | ||||
CuryVatTaxableTotal | decimal | VAT Taxable Total | - | |
Description:No description available | ||||
CustomerBillingCycleID | int | Billing Cycle ID | FSBillingCycle | |
Description:No description available | ||||
CustomerBillingSrvOrdType | varchar(MAX) | Service Order Type | FSSrvOrdType | |
Description:No description available | ||||
CustomerID | int | Customer | BAccount | |
Description:No description available | ||||
customerSignaturePath | nvarchar(MAX) | Customer Signature | - | |
Description:No description available | ||||
CustomerSignedReport | uniqueidentifier | Signed Report ID | - | |
Description:No description available | ||||
CutOffDate | datetime2 | Cut-Off Date | - | |
Description:No description available | ||||
DeliveryNotes | nvarchar(2147483647) | Delivery Notes | - | |
Description:No description available | ||||
DfltProjectTaskID | int | Default Project Task | PMTask | |
Description:No description available | ||||
DiscTot | decimal | Discount Total | - | |
Description:No description available | ||||
DocDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
DocDiscNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DocTotal | decimal | 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 | ||||
EmployeeID | int | Staff Member ID | BAccount | |
Description:No description available | ||||
EmployeeLineCntr | int | - | ||
Description:No description available | ||||
EntityUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
EstimatedCostTotal | decimal | EstimatedCostTotal | - | |
Description:No description available | ||||
EstimatedDurationTotal | int | Estimated Duration | - | |
Description:No description available | ||||
EstimatedLineTotal | decimal | Base Estimated Total | - | |
Description:No description available | ||||
ExecutionDate | datetime2 | Actual Start Date | - | |
Description:No description available | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:No description available | ||||
Finished | bit | Finished | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
FSxCustomerBillingCycleID | int | Billing Cycle ID | FSBillingCycle | |
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 | ||||
GeoZoneID | int | Geographical Zone ID | FSGeoZone | |
Description:No description available | ||||
GPSLatitudeComplete | decimal | Latitude | - | |
Description:No description available | ||||
GPSLatitudeStart | decimal | Latitude | - | |
Description:No description available | ||||
GPSLongitudeComplete | decimal | Longitude | - | |
Description:No description available | ||||
GPSLongitudeStart | decimal | Longitude | - | |
Description:No description available | ||||
HandleManuallyActualTime | bit | Handle Manually | - | |
Description:No description available | ||||
HandleManuallyScheduleTime | bit | Handle Manually | - | |
Description:No description available | ||||
Hold | 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 | varchar(8) | LastModifiedByScreenID | - | |
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineTotal | decimal | Base Ext. Price Total | - | |
Description:No description available | ||||
LocationID | int | Location | Location | |
Description:No description available | ||||
LogBillableTranAmountTotal | decimal | Base Billable Labor Total | - | |
Description:No description available | ||||
LogLineCntr | int | - | ||
Description:No description available | ||||
LongDescr | nvarchar(2147483647) | Description | - | |
Description:No description available | ||||
MapLatitude | decimal | Latitude | - | |
Description:No description available | ||||
MapLongitude | decimal | Longitude | - | |
Description:No description available | ||||
MaxLineNbr | int | - | ||
Description:No description available | ||||
MaxLogTimeEnd | datetime2 | 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 | datetime2 | 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 | ||||
PostalCode | varchar(20) | Postal code | - | |
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 | ||||
Priority | char(1) | Priority | - | |
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 | ||||
RoomID | nvarchar(10) | Room | FSRoom | |
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 | datetime2 | Scheduled Start Date | - | |
Description:No description available | ||||
ScheduledDateTimeBeginUTC | datetime2 | Scheduled Date | - | |
Description:No description available | ||||
ScheduledDateTimeEnd | datetime2 | Scheduled End Date | - | |
Description:No description available | ||||
ScheduledDateTimeEndUTC | datetime2 | Scheduled Date End | - | |
Description:No description available | ||||
ScheduledDurationNonexistent in DB | 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 | ||||
ServiceID | int | InventoryItem | ||
Description:No description available | ||||
SkipExternalTaxCalculationNonexistent in DB | bit | Skip External Tax Calculation | - | |
Description:No description available | ||||
SLAETA | datetime2 | Deadline - SLA | - | |
Description:No description available | ||||
SODetID | int | Service Order Detail Ref. Nbr. | FSSODet | |
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 | ||||
State | nvarchar(50) | State | State | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxTotal | decimal | - | ||
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 | bit | Unreached Customer | - | |
Description:No description available | ||||
UserConfirmedUnclosingNonexistent in DB | bit | - | ||
Description:No description available | ||||
ValidatedByDispatcher | bit | Validated by Dispatcher | - | |
Description:No description available | ||||
VatExemptTotal | decimal | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal | - | ||
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 | varchar(2) | Workflow Type | - | |
Description:No description available | ||||