FS
ServiceOrderToPost
PX.Objects.FS207 of 207 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 | ||||
AppointmentIDNonexistent in DB | int | - | ||
Description:No description available | ||||
AppointmentsNeeded | 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 | 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 | ||||
BatchIDNonexistent in DB | int | Batch Nbr. | FSPostBatch | |
Description:No description available | ||||
BillableOrderTotal | decimal | 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 | ||||
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 | ||||
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 | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(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 | Actual Billable Total | - | |
Description:No description available | ||||
CuryBillableOrderTotal | decimal | Estimated 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 | 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 | 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 | Estimated Tax Total | - | |
Description:No description available | ||||
CuryVatExemptTotal | decimal | VAT Exempt Total | - | |
Description:No description available | ||||
CuryVatTaxableTotal | decimal | 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 | datetime2 | Cut-Off Date | - | |
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 Service Order Total | - | |
Description:No description available | ||||
DocType | varchar(4) | - | ||
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 | ||||
ErrorFlagNonexistent in DB | bit | - | ||
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 | 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 | ||||
FrequencyType | char(2) | Frequency Type | - | |
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 | nvarchar(MAX) | - | ||
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:No description available | ||||
InvoicedByContract | bit | InvoicedByContract | - | |
Description:No description available | ||||
InvoiceOnlyCompletedServiceOrder | bit | Invoice only completed or closed Service Orders | - | |
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 | varchar(8) | Last Modified By Screen ID | - | |
Description:No description available | ||||
LastModifiedDateTime | 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(2147483647) | 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 | ||||
MonthlyFrequency | int | Frequency Month Day | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenDoc | bit | Open | - | |
Description:No description available | ||||
OrderDate | datetime2 | 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 | ||||
PostNegBalanceToAP | bit | Create a Bill Document in AP for Negative Balances | - | |
Description:No description available | ||||
PostOrderType | varchar(2) | SOOrderType | ||
Description:No description available | ||||
PostOrderTypeNegativeBalance | varchar(2) | SOOrderType | ||
Description:No description available | ||||
PostTo | varchar(2) | Post To | - | |
Description:No description available | ||||
Priority | 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 | ||||
RowIndexNonexistent in DB | int | - | ||
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 | ||||
SendInvoicesTo | char(2) | Send Invoices to | - | |
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 | 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 | datetime2 | SLA | - | |
Description:No description available | ||||
SLAETAUTC | datetime2 | 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 | 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 | decimal | - | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Customer Tax Zone | TaxZone | |
Description:No description available | ||||
TextNonexistent in DB | nvarchar(MAX) | - | ||
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 | ||||
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 | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal | - | ||
Description:No description available | ||||
WaitingForParts | bit | Waiting for Purchased Items | - | |
Description:No description available | ||||
WeeklyFrequency | int | Frequency Week Day | - | |
Description:No description available | ||||
WFStageID | int | Workflow Stage | FSWFStage | |
Description:No description available | ||||
WorkflowTypeID | char(2) | Workflow Type | - | |
Description:No description available | ||||