FS
FSServiceOrder
PX.Objects.FSView API Entity: ServiceOrder
/entity/Default/24.200.001/ServiceOrder184 of 184 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
RefNbr | nvarchar(15) | Order Nbr. | - | |
Description:No description available | ||||
SrvOrdType | char(4) | Order Type | FSSrvOrdType | |
Description:No description available | ||||
AllowInvoice | bit | Allow Billing | - | |
Description:No description available | ||||
AllowOverrideContactAddress | bit | Override | - | |
Description:No description available | ||||
APBillLineCntr | int | - | ||
Description:No description available | ||||
AppointmentDocTotalNonexistent in DB | decimal | Base Invoice Total | - | |
Description:No description available | ||||
AppointmentsNeeded API | bit | Appointments Needed | - | |
Description:No description available | ||||
AppointmentTaxTotalNonexistent in DB | decimal | Base Appointment Tax Total | - | |
Description:No description available | ||||
ApptDurationTotal | int | Appointment Duration | - | |
Description:No description available | ||||
ApptNeededLineCntr | int | - | ||
Description:No description available | ||||
ApptOrderTotal | decimal(19, 4) | Base Appointment Line Total | - | |
Description:No description available | ||||
AssignedEmpID | int | Supervisor | BAccount | |
Description:No description available | ||||
AssignedEmployeeDisplayNameNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
AutoDocDesc | nvarchar(255) | Service description | - | |
Description:No description available | ||||
Awaiting | bit | Awaiting | - | |
Description:No description available | ||||
BAccountRequired | bit | Customer Required | - | |
Description:No description available | ||||
BillableOrderTotal | decimal(19, 4) | Base Estimated Billable Total | - | |
Description:No description available | ||||
BillContractPeriodID | int | Contract Period | - | |
Description:No description available | ||||
BillCustomerID | int | Billing Customer | Customer | |
Description:No description available | ||||
Billed | bit | Billed | - | |
Description:No description available | ||||
BillingBy | char(2) | Billing By | - | |
Description:No description available | ||||
BillLocationID | int | Billing Location | Location | |
Description:No description available | ||||
BillOnlyCompletedClosed | bit | Bill Only Completed or Closed Service Orders | - | |
Description:No description available | ||||
BillServiceContractID | int | Service Contract | FSServiceContract | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
BranchLocationDescNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
BranchLocationID | int | Branch Location | FSBranchLocation | |
Description:No description available | ||||
CancelActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
CancelAppointmentsNonexistent in DB | bit | - | ||
Description:No description available | ||||
Canceled | bit | Canceled | - | |
Description:No description available | ||||
CanCreatePurchaseOrderNonexistent in DB | bit | - | ||
Description:No description available | ||||
CBID | int | FSCustomerBillingSetup | ||
Description:No description available | ||||
CloseActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
CloseAppointmentsNonexistent 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 | ||||
CompleteAppointmentsNonexistent in DB | bit | - | ||
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
CompleteServiceCount | int | Complete Service Count | - | |
Description:No description available | ||||
Confirmed | bit | Confirmed | - | |
Description:No description available | ||||
ContactEmailNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
ContactID | int | Contact | Contact | |
Description:No description available | ||||
ContactNameNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
ContactPhoneNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
ContractID | int | Contract | Contract | |
Description:No description available | ||||
Copied | bit | Copied | - | |
Description:No description available | ||||
CostTotal | decimal(19, 6) | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | Created By Screen ID | - | |
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryAppointmentDocTotalNonexistent in DB | decimal | Invoice Total | - | |
Description:No description available | ||||
CuryAppointmentTaxTotalNonexistent in DB | decimal | Actual Tax Total | - | |
Description:No description available | ||||
CuryApptOrderTotal | decimal(19, 4) | Actual Billable Total | - | |
Description:No description available | ||||
CuryBillableOrderTotal | decimal(19, 4) | Estimated 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) | Estimated Total | - | |
Description:No description available | ||||
CuryEffectiveBillableDocTotalNonexistent in DB | decimal | Invoice Total | - | |
Description:No description available | ||||
CuryEffectiveBillableLineTotalNonexistent in DB | decimal | Line Total | - | |
Description:No description available | ||||
CuryEffectiveBillableTaxTotalNonexistent in DB | decimal | Tax Total | - | |
Description:No description available | ||||
CuryEffectiveCostTotalNonexistent in DB | decimal | Cost Total | - | |
Description:No description available | ||||
CuryEffectiveLogBillableTranAmountTotalNonexistent in DB | decimal | Billable Labor Total | - | |
Description:No description available | ||||
CuryEstimatedBillableTotalNonexistent in DB | decimal | Estimated Billable Total | - | |
Description:No description available | ||||
CuryEstimatedOrderTotal | decimal(19, 4) | Ext. Price 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 | ||||
CuryShortLabelEffectiveBillableDocTotalNonexistent in DB | decimal | Billable Total | - | |
Description:No description available | ||||
CuryTaxTotal | decimal(19, 4) | Estimated 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 | ||||
CustomerDisplayNameNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
CustomOrderDateNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
CustPORefNbr | nvarchar(40) | Customer Order | - | |
Description:No description available | ||||
CustWorkOrderRefNbr | nvarchar(40) | External Reference | - | |
Description:No description available | ||||
CutOffDate | datetime | Cut-Off Date | - | |
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 Service Order Total | - | |
Description:No description available | ||||
EffectiveBillableDocTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
EffectiveBillableLineTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
EffectiveBillableTaxTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
EffectiveCostTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
EffectiveLogBillableTranAmountTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
EntityUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
EstimatedBillableTotalNonexistent in DB | decimal | Estimated Billable Total | - | |
Description:No description available | ||||
EstimatedDurationTotal | int | Estimated Duration | - | |
Description:No description available | ||||
EstimatedOrderTotal | decimal(19, 4) | Base Ext. Price Total | - | |
Description:No description available | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
GenerationID | int | Generation ID | - | |
Description:No description available | ||||
Hold API | bit | Hold | - | |
Description:No description available | ||||
InvoicedByContract | bit | InvoicedByContract | - | |
Description:No description available | ||||
IsCalledFromQuickProcessNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsPrepaymentEnableNonexistent in DB | bit | IsPrepaymentEnable | - | |
Description:No description available | ||||
IsTaxValid | bit | Tax Is Up to Date | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | Last Modified By Screen ID | - | |
Description:No description available | ||||
LastModifiedDateTime API | datetime | Last Modified On | - | |
Description:No description available | ||||
LeafNonexistent in DB | bit | - | ||
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LocationID | int | Location | Location | |
Description:No description available | ||||
LongDescr | nvarchar(MAX) | Description | - | |
Description:No description available | ||||
MaxLineNbr | int | - | ||
Description:No description available | ||||
Mem_InvoicedNonexistent in DB | bit | Billed | - | |
Description:No description available | ||||
MemAcctNameNonexistent in DB | nvarchar(62) | - | ||
Description:No description available | ||||
MemRefNbrNonexistent in DB | nvarchar(17) | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenDoc | bit | Open | - | |
Description:No description available | ||||
OrderDate | datetime | Date | - | |
Description:No description available | ||||
PendingAPARSOPost | bit | - | ||
Description:No description available | ||||
PendingINPost | bit | - | ||
Description:No description available | ||||
PendingPOLineCntr | int | - | ||
Description:No description available | ||||
PostedBy | char(2) | - | ||
Description:No description available | ||||
Priority API | char(1) | Priority | - | |
Description:No description available | ||||
ProblemID | int | Problem | FSProblem | |
Description:No description available | ||||
ProcessCancelActionNonexistent in DB | bit | - | ||
Description:No description available | ||||
ProcessCloseActionNonexistent in DB | bit | - | ||
Description:No description available | ||||
ProcessCompleteActionNonexistent in DB | bit | - | ||
Description:No description available | ||||
ProcessReopenActionNonexistent in DB | bit | - | ||
Description:No description available | ||||
ProfitMarginPercentNonexistent in DB | decimal | Profit Margin (%) | - | |
Description:No description available | ||||
ProfitPercentNonexistent in DB | decimal | Profit Markup (%) | - | |
Description:No description available | ||||
ProjectCDNonexistent in DB | nvarchar(MAX) | Project ID | - | |
Description:No description available | ||||
ProjectDescrNonexistent in DB | nvarchar(MAX) | Project Description | - | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
ProjectTaskDescrNonexistent in DB | nvarchar(MAX) | Task Description | - | |
Description:No description available | ||||
Quote | bit | Quote | - | |
Description:No description available | ||||
ReopenActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
ReportLocationIDNonexistent in DB | int | Location | ||
Description:No description available | ||||
RoomID | nvarchar(10) | Room | FSRoom | |
Description:No description available | ||||
RowsNonexistent in DB | unspecified | - | ||
Description:No description available | ||||
SalesPersonID | int | Salesperson | SalesPerson | |
Description:No description available | ||||
ScheduledServiceCount | int | Scheduled Service Count | - | |
Description:No description available | ||||
ScheduleID | int | Source Schedule ID | FSSchedule | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ServiceClassIDsNonexistent in DB | int | - | ||
Description:No description available | ||||
ServiceContractID | int | Source Service Contract ID | FSServiceContract | |
Description:No description available | ||||
ServiceCount | int | Service Count | - | |
Description:No description available | ||||
ServiceOrderAddressID | int | FSAddress | ||
Description:No description available | ||||
ServiceOrderContactID | int | FSContact | ||
Description:No description available | ||||
ServicesCountNonexistent in DB | int | - | ||
Description:No description available | ||||
ServicesRemainingNonexistent in DB | int | - | ||
Description:No description available | ||||
Severity API | char(1) | Severity | - | |
Description:No description available | ||||
ShortLabelEffectiveBillableDocTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
ShowInvoicesTabNonexistent in DB | bit | ShowInvoicesTab | - | |
Description:No description available | ||||
SkipExternalTaxCalculationNonexistent in DB | bit | Skip External Tax Calculation | - | |
Description:No description available | ||||
SLAETA | datetime | SLA | - | |
Description:No description available | ||||
SLAETAUTC | datetime | Deadline - SLA | - | |
Description:No description available | ||||
SLARemainingNonexistent in DB | int | - | ||
Description:No description available | ||||
SOBillableUnpaidBalanaceNonexistent in DB | decimal | - | ||
Description:No description available | ||||
SOCuryBillableUnpaidBalanaceNonexistent in DB | decimal | Service Order Billable Unpaid Balance | - | |
Description:No description available | ||||
SOCuryUnpaidBalanaceNonexistent in DB | decimal | Service Order Unpaid Balance | - | |
Description:No description available | ||||
SOID | int | - | ||
Description:No description available | ||||
SOPrepaymentAppliedNonexistent in DB | decimal | Prepayment Applied | - | |
Description:No description available | ||||
SOPrepaymentReceivedNonexistent in DB | decimal | Prepayment Received | - | |
Description:No description available | ||||
SOPrepaymentRemainingNonexistent in DB | decimal | Prepayment Remaining | - | |
Description:No description available | ||||
SOUnpaidBalanaceNonexistent in DB | decimal | - | ||
Description:No description available | ||||
SourceDocType | char(4) | Source Document Type | - | |
Description:No description available | ||||
SourceID | int | - | ||
Description:No description available | ||||
SourceReferenceNbrNonexistent in DB | nvarchar(MAX) | Reference Nbr. | - | |
Description:No description available | ||||
SourceRefNbr | nvarchar(15) | Source Ref. Nbr. | - | |
Description:No description available | ||||
SourceType | char(2) | Document Type | - | |
Description:No description available | ||||
SplitLineCntr | int | - | ||
Description:No description available | ||||
Status API | char(1) | Status | - | |
Description:No description available | ||||
TaskCDNonexistent in DB | nvarchar(MAX) | Task ID | - | |
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 | ||||
TextNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
TreeIDNonexistent in DB | int | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnCloseActionRunningNonexistent in DB | bit | - | ||
Description:No description available | ||||
UserConfirmedClosingNonexistent in DB | bit | - | ||
Description:No description available | ||||
UserConfirmedUnclosingNonexistent in DB | bit | - | ||
Description:No description available | ||||
VatExemptTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
WaitingForParts | bit | Waiting for Purchased Items | - | |
Description:No description available | ||||
WFStageID | int | Workflow Stage | FSWFStage | |
Description:No description available | ||||
WorkflowTypeID | char(2) | Workflow Type | - | |
Description:No description available | ||||