FS
AppointmentToPost
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
APBillLineCntr | int | - | ||
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 | ||||
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 | ||||
AppCompletedBillableTotalNonexistent in DB | decimal? | Appointment Billable Total | - | |
Description:No description available | ||||
AppointmentID | int | - | ||
Description:No description available | ||||
AppointmentRefReportNonexistent in DB | int? | FSAppointment | ||
Description:No description available | ||||
AreActualFieldsActiveNonexistent in DB | bool? | - | ||
Description:No description available | ||||
AttributesNonexistent in DB | string | - | ||
Description:A service field, which is necessary for the dynamically added attributes defined at the customer class level to function correctly. | ||||
AutoDocDesc | nvarchar(255) | Service Description | - | |
Description:No description available | ||||
Awaiting | bit | Awaiting | - | |
Description:No description available | ||||
BatchIDNonexistent in DB | int? | Batch Nbr. | FSPostBatch | |
Description:No description available | ||||
BillContractPeriodID | int | Contract Period | FSContractPeriod | |
Description:No description available | ||||
BillCustomerID | int | Billing Customer | Customer | |
Description:No description available | ||||
BillLocationID | int | Billing Location | Location | |
Description:No description available | ||||
BillServiceContractID | int | Service Contract | FSServiceContract | |
Description:No description available | ||||
BillableLineTotal | decimal | Base Billable Total | - | |
Description:No description available | ||||
Billed | bit | Billed | - | |
Description:No description available | ||||
BillingByNonexistent in DB | string | - | ||
Description:No description available | ||||
BillingCycleCD | nvarchar(15) | Billing Cycle ID | FSBillingCycle | |
Description:No description available | ||||
BillingCycleID | int | Billing Cycle ID | FSBillingCycle | |
Description:No description available | ||||
BillingCycleType | char(2) | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
BranchLocationID | int | Branch Location | FSBranchLocation | |
Description:No description available | ||||
CancelActionRunningNonexistent in DB | bool? | - | ||
Description:No description available | ||||
Canceled | bit | Canceled | - | |
Description:No description available | ||||
CloseActionRunningNonexistent in DB | bool? | - | ||
Description:No description available | ||||
Closed | bit | Closed | - | |
Description:No description available | ||||
Commissionable | bit | Commissionable | - | |
Description:No description available | ||||
CompleteActionRunningNonexistent in DB | bool? | - | ||
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
Confirmed | bit | Confirmed | - | |
Description:No description available | ||||
CostTotal | decimal | - | ||
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 | 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? | - | ||
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 | ||||
CustPORefNbr | nvarchar(40) | Customer Purchase Order Ref. Nbr. | - | |
Description:No description available | ||||
CustWorkOrderRefNbr | nvarchar(40) | Customer Work Order Ref. Nbr. | - | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
CustomerSignedReport | uniqueidentifier | Signed Report ID | - | |
Description:No description available | ||||
CutOffDate | datetime | Cut-Off Date | - | |
Description:Non-used field | ||||
DeliveryNotes | nvarchar(MAX) | Delivery Notes | - | |
Description:No description available | ||||
DfltProjectTaskID | int | Default Project Task | PMTask | |
Description:No description available | ||||
DfltTermIDARSO | nvarchar(10) | Terms | ||
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 | ||||
DocType | nvarchar(4) | - | ||
Description:No description available | ||||
DriveTime | int | Driving Time | - | |
Description:No description available | ||||
EditActionRunningNonexistent in DB | bool? | - | ||
Description:Check whether appointment edit action button click is executed. | ||||
EffDocDateNonexistent in DB | DateTime? | Effective Document Date | - | |
Description:No description available | ||||
EmployeeLineCntr | int | - | ||
Description:No description available | ||||
EntityUsageType | char(1) | Tax Exemption Type | - | |
Description:The entity usage type for reporting purposes. The field is used if the system is integrated with External Tax Calculation and the External Tax Calculation Integration feature is enabled. The field can have one of the values described in . Defaults to the Tax Exemption Type that is specified for the location of the customer. | ||||
ErrorFlagNonexistent in DB | bool? | - | ||
Description:No description available | ||||
EstimatedCostTotal | decimal | - | ||
Description:No description available | ||||
EstimatedDurationTotal | int | Estimated Duration | - | |
Description:No description available | ||||
EstimatedLineTotal | decimal | Base Estimated Total | - | |
Description:No description available | ||||
ExecutionDate | datetime | Actual Start Date | - | |
Description:No description available | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:The tax exemption number for reporting purposes. The field is used if the system is integrated with External Tax Calculation and the External Tax Calculation Integration feature is enabled. | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
Finished | bit | Finished | - | |
Description:No description available | ||||
FormCaptionDescriptionNonexistent in DB | string | - | ||
Description:No description available | ||||
FrequencyType | char(2) | Frequency Type | - | |
Description:No description available | ||||
FullNameSignature | nvarchar(255) | Full Name | - | |
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 | ||||
GeneratedByContract | bit | Generated by Contract | - | |
Description:No description available | ||||
GenerationID | int | Generation ID | - | |
Description:No description available | ||||
GroupBillByLocations | bit | Create Separate Invoices for Customer Locations | - | |
Description:No description available | ||||
GroupKeyNonexistent in DB | string | - | ||
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 | ||||
InvoiceOnlyCompletedServiceOrder | bit | Invoice only completed or closed Service Orders | - | |
Description:No description available | ||||
IsCalledFromQuickProcessNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsINReleaseProcessNonexistent in DB | bool | - | ||
Description:No description available | ||||
IsPostedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsPrepaymentEnableNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsReassignedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsRouteAppoinmentNonexistent in DB | bool? | - | ||
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 | datetime | Last Modified On | - | |
Description:No description available | ||||
LastSelectedSplitSourceNonexistent in DB | int? | - | ||
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineTotal | decimal | Base Ext. Price Total | - | |
Description:No description available | ||||
LogBillableTranAmountTotal | decimal | Base Billable Labor Total | - | |
Description:No description available | ||||
LogLineCntr | int | - | ||
Description:No description available | ||||
LongDescr | nvarchar(MAX) | 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 | datetime | Max Log Time End | - | |
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_ActualDateTime_MonthNonexistent in DB | string | Month | - | |
Description:No description available | ||||
Mem_ActualDateTime_YearNonexistent in DB | int? | Year | - | |
Description:No description available | ||||
Mem_AppointmentHoursNonexistent in DB | decimal? | Appointment Hours | - | |
Description:No description available | ||||
Mem_BatchNbrNonexistent in DB | string | Batch Nbr. | - | |
Description:No description available | ||||
Mem_BusinessDateTimeNonexistent in DB | DateTime? | - | ||
Description:No description available | ||||
Mem_GPSLatitudeLongitudeNonexistent in DB | string | 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 | string | Invoice Doc Type | - | |
Description:No description available | ||||
Mem_InvoiceRefNonexistent in DB | string | Invoice Ref. Nbr. | - | |
Description:No description available | ||||
Mem_LastRouteDocumentIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
Mem_OccupationalRateNonexistent in DB | decimal? | Occupational Rate (%) | - | |
Description:No description available | ||||
Mem_ReturnValueIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
Mem_SMequipmentIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
Mem_ScheduledHoursNonexistent in DB | decimal? | Scheduled Hours | - | |
Description:No description available | ||||
Mem_ScheduledTimeBeginNonexistent in DB | DateTime? | - | ||
Description:No description available | ||||
MinLogTimeBegin | datetime | Min Log Time Begin | - | |
Description:No description available | ||||
MonthlyFrequency | int | Frequency Month Day | - | |
Description:No description available | ||||
MustUpdateServiceOrderNonexistent in DB | bool? | - | ||
Description:No description available | ||||
NotStarted | bit | Not Started | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | NoteID | - | |
Description:No description available | ||||
OriginalAppointmentID | int | Original Appointment ID | - | |
Description:No description available | ||||
PauseActionRunningNonexistent in DB | bool? | - | ||
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 | ||||
PostNegBalanceToAP | bit | Create a Bill Document in AP for Negative Balances | - | |
Description:No description available | ||||
PostOrderType | nvarchar(2) | SOOrderType | ||
Description:No description available | ||||
PostOrderTypeNegativeBalance | nvarchar(2) | SOOrderType | ||
Description:No description available | ||||
PostTo | nvarchar(2) | Post To | - | |
Description:No description available | ||||
PostedBy | char(2) | - | ||
Description:No description available | ||||
PostingStatusAPARSO | char(2) | - | ||
Description:No description available | ||||
PostingStatusIN | char(2) | - | ||
Description:No description available | ||||
PrimaryDriver | int | Primary Driver | BAccountStaffMember | |
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 ID | PMProject | |
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 | ||||
RefNbr | nvarchar(20) | Appointment Nbr. | FSAppointment | |
Description:No description available | ||||
ReloadServiceOrderRelatedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
ReopenActionRunningNonexistent in DB | bool? | - | ||
Description:No description available | ||||
ResumeActionRunningNonexistent in DB | bool? | - | ||
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 | ||||
RowIndexNonexistent in DB | int? | - | ||
Description:No description available | ||||
SOID | int | - | ||
Description:No description available | ||||
SORefNbr | nvarchar(15) | Service Order Nbr. | FSServiceOrder | |
Description:No description available | ||||
SalesPersonID | int | Salesperson | SalesPerson | |
Description:No description available | ||||
ScheduleID | int | Source Schedule ID | FSSchedule | |
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 | ||||
ScheduledDurationNonexistent in DB | int? | Scheduled Duration | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SendInvoicesTo | char(2) | Send Invoices to | - | |
Description:No description available | ||||
ServiceContractID | int | Source Service Contract ID | FSServiceContract | |
Description:No description available | ||||
ServiceOrderStatus | char(1) | Status | - | |
Description:No description available | ||||
SkipExternalTaxCalculationNonexistent in DB | bool? | Skip External Tax Calculation | - | |
Description:No description available | ||||
SplitLineCntr | int | - | ||
Description:No description available | ||||
SrvOrdType | char(4) | Service Order Type | FSSrvOrdType | |
Description:No description available | ||||
SrvOrdTypeCodeNonexistent in DB | string | - | ||
Description:No description available | ||||
StaffCntr | int | - | ||
Description:No description available | ||||
StartActionRunningNonexistent in DB | bool? | - | ||
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 | ||||
TimeCycleDayOfMonth | int | Day of Month | - | |
Description:No description available | ||||
TimeCycleType | char(2) | Time Cycle Type | - | |
Description:No description available | ||||
TimeCycleWeekDay | int | Day of Week | - | |
Description:No description available | ||||
TimeLocked | bit | Time Locked | - | |
Description:No description available | ||||
TimeRegistered | bit | Approved Staff Times | - | |
Description:No description available | ||||
TrackTimeChangedNonexistent in DB | bool? | - | ||
Description:Specifies (if set to true) that there is inconsistency with the trackTime flags in log records. | ||||
TravelCanBeCompletedNonexistent in DB | bool? | TravelCanBeCompleted | - | |
Description:No description available | ||||
TravelCanBeStartedNonexistent in DB | bool? | TravelCanBeStarted | - | |
Description:No description available | ||||
TravelInProcess | bit | Travel in Process | - | |
Description:No description available | ||||
UnCloseActionRunningNonexistent in DB | bool? | - | ||
Description:No description available | ||||
UnreachedCustomer | bit | Unreached Customer | - | |
Description:No description available | ||||
UserConfirmedUnclosingNonexistent in DB | bool? | - | ||
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 | FSVehicle | |
Description:No description available | ||||
WFStageID | int | Workflow Stage | FSWFStage | |
Description:No description available | ||||
WaitingForParts | bit | Waiting for Purchased Items | - | |
Description:No description available | ||||
WeeklyFrequency | int | Frequency Week Day | - | |
Description:No description available | ||||
WildCard_AssignedEmployeesCellPhoneListNonexistent in DB | string | Assigned employees cells list | - | |
Description:No description available | ||||
WildCard_AssignedEmployeesListNonexistent in DB | string | Assigned employees list | - | |
Description:No description available | ||||
WildCard_CustomerPrimaryContactNonexistent in DB | string | Customer primary contact | - | |
Description:No description available | ||||
WildCard_CustomerPrimaryContactCellNonexistent in DB | string | Customer primary contact cell | - | |
Description:No description available | ||||
WorkflowTypeID | varchar(2) | Workflow Type | - | |
Description:No description available | ||||
customerSignaturePath | nvarchar | Customer Signature | - | |
Description:No description available | ||||
isBeingClonedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
tstamp | timestamp | tstamp | - | |
Description:No description available | ||||