Skip to main content
FS

FSAppointmentStaffScheduleBoard

PX.Objects.FS
Field NameTypeDisplay NameForeign Key
RefNbr
nvarchar(20)Appointment Nbr.FSAppointment
Description:No description available
SrvOrdType
nchar(4)Service Order TypeFSSrvOrdType
Description:No description available
AddressID
int-
Description:No description available
AppointmentCustomIDNonexistent in DB
int-
Description:No description available
AppointmentID
int-
Description:No description available
Billed
bitBilled-
Description:No description available
BranchID
intBranch IDBranch
Description:No description available
BranchLocationDesc
nvarchar(60)Branch Location Desc-
Description:No description available
BranchLocationID
intBranch Location IDFSBranchLocation
Description:No description available
Canceled
bitCanceled-
Description:No description available
CanDeleteAppointmentNonexistent in DB
unspecified-
Description:No description available
Closed
bitClosed-
Description:No description available
Confirmed
bitConfirmed-
Description:No description available
ContactEmail
char(50)Contact Email-
Description:No description available
ContactName
char(50)Contact Name-
Description:No description available
ContactPhone
char(50)Contact Phone-
Description:No description available
CustomDateIDNonexistent in DB
nvarchar(MAX)-
Description:No description available
CustomDateTimeEndNonexistent in DB
nvarchar(MAX)-
Description:No description available
CustomDateTimeStartNonexistent in DB
nvarchar(MAX)-
Description:No description available
CustomerID
int-
Description:No description available
CustomerLocation
intCustomer Location-
Description:No description available
CustomerName
varchar(60)Customer Name-
Description:No description available
CustomIDNonexistent in DB
nvarchar(MAX)-
Description:No description available
CustomRoomIDNonexistent in DB
nvarchar(MAX)-
Description:No description available
DocDesc
nvarchar(255)DocDesc-
Description:No description available
DraggableNonexistent in DB
bit-
Description:No description available
EmployeeCountNonexistent in DB
int-
Description:No description available
EmployeeID
intBAccount
Description:No description available
EmployeeListNonexistent in DB
nvarchar(MAX)-
Description:No description available
FirstServiceDescNonexistent in DB
nvarchar(MAX)-
Description:No description available
IsPostedNonexistent in DB
bit-
Description:No description available
LocationDesc
char(1)LocationDesc-
Description:No description available
MemAcctNameNonexistent in DB
nvarchar(62)-
Description:No description available
MemRefNbrNonexistent in DB
nvarchar(22)-
Description:No description available
OldEmployeeIDNonexistent in DB
int-
Description:No description available
PostingStatusAPARSO
char(2)-
Description:No description available
PostingStatusIN
char(2)-
Description:No description available
ResizableNonexistent in DB
bit-
Description:No description available
RoomDescNonexistent in DB
nvarchar(MAX)-
Description:No description available
RoomID
nchar(1)RoomFSRoom
Description:No description available
ScheduledDateTimeBegin
datetime2Scheduled Start Date-
Description:No description available
ScheduledDateTimeEnd
datetime2Scheduled End Date-
Description:No description available
ServiceCountNonexistent in DB
int-
Description:No description available
ServiceListNonexistent in DB
nvarchar(MAX)-
Description:No description available
SMEquipmentID
int-
Description:No description available
SOID
int-
Description:No description available
SORefNbr
nvarchar(15)Service Order Nbr.-
Description:No description available
Status
char(1)Status-
Description:No description available
StatusUINonexistent in DB
nvarchar(MAX)-
Description:No description available
ValidatedByDispatcher
bitConfirmed-
Description:No description available
WFStageCD
nchar(1)WFStageCD-
Description:No description available