FS
FSSODet
PX.Objects.FS154 of 154 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Service Order Nbr. | FSServiceOrder | |
Description:No description available | ||||
SrvOrdType | char(4) | Service Order Type | FSSrvOrdType | |
Description:No description available | ||||
AcctID | int | Account | Account | |
Description:No description available | ||||
AlreadyCalculatedUnitPriceNonexistent in DB | decimal | - | ||
Description:No description available | ||||
ApptCntr | int | Appointment Count | - | |
Description:No description available | ||||
ApptDuration | int | Appointment Duration | - | |
Description:No description available | ||||
ApptEstimatedDuration | int | Appointment Estimated Duration | - | |
Description:No description available | ||||
ApptQty | decimal(25, 6) | Appointment Quantity | - | |
Description:No description available | ||||
ApptTranAmt | decimal(19, 4) | Base Appointment Amount | - | |
Description:No description available | ||||
BaseBillableQty | decimal(25, 6) | Base Billable Qty. | - | |
Description:No description available | ||||
BaseClosedQty | decimal | - | ||
Description:No description available | ||||
BaseDeductQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
BaseEstimatedQty | decimal(25, 6) | Base Estimated Qty. | - | |
Description:No description available | ||||
BaseOpenQty | decimal(25, 6) | Base Open Qty. | - | |
Description:No description available | ||||
BaseOrderQtyNonexistent in DB | decimal | Base Order Qty. | - | |
Description:No description available | ||||
BaseShippedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BehaviorNonexistent in DB | nchar(2) | - | ||
Description:No description available | ||||
BillableExtPrice | decimal(19, 4) | - | ||
Description:No description available | ||||
BillableQty | decimal(25, 6) | Quantity | - | |
Description:No description available | ||||
BillableTranAmt | decimal(19, 4) | Base Billable Amount | - | |
Description:No description available | ||||
BillCustomerID | int | Customer | ||
Description:No description available | ||||
BillingRule | char(4) | Billing Rule | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
ClosedQty | decimal | - | ||
Description:No description available | ||||
Comment | varchar(255) | Equipment Action Comment | - | |
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
ComponentID | int | Component ID | FSModelTemplateComponent | |
Description:No description available | ||||
ContractRelated | bit | Service Contract Item | - | |
Description:No description available | ||||
CostCenterID | int | INCostCenter | ||
Description:No description available | ||||
CostCodeDescrNonexistent in DB | nvarchar(MAX) | Cost Code Description | - | |
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CoveredQty | decimal(25, 6) | Covered Quantity | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryApptTranAmt | decimal(19, 4) | Appointment Amount | - | |
Description:No description available | ||||
CuryBillableExtPrice | decimal(19, 4) | Ext. Price | - | |
Description:No description available | ||||
CuryBillableTranAmt | decimal(19, 4) | Amount | - | |
Description:No description available | ||||
CuryDiscAmt | decimal(19, 4) | Discount Amount | - | |
Description:No description available | ||||
CuryEstimatedTranAmt | decimal(19, 4) | Estimated Amount | - | |
Description:No description available | ||||
CuryExtCost | decimal(19, 6) | Ext. Cost | - | |
Description:No description available | ||||
CuryExtPriceNonexistent in DB | decimal | Ext. Price | - | |
Description:No description available | ||||
CuryExtraUsageUnitPrice | decimal(19, 6) | Overage Unit Price | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineAmtNonexistent in DB | decimal | Amount | - | |
Description:No description available | ||||
CuryOrigUnitCost | decimal(19, 6) | Orig. Unit Cost | - | |
Description:No description available | ||||
CuryUnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
CuryUnitPrice | decimal(19, 6) | Unit Price | - | |
Description:No description available | ||||
DeductQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
DiscountID | nvarchar(10) | Discount Code | ARDiscount | |
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | Discount Sequence | - | |
Description:No description available | ||||
DiscPct | decimal(19, 6) | Discount Percent | - | |
Description:No description available | ||||
DocumentDiscountRate | decimal(9, 6) | - | ||
Description:No description available | ||||
EnablePO | bit | Mark for PO | - | |
Description:No description available | ||||
EnableStaffIDNonexistent in DB | bit | - | ||
Description:No description available | ||||
EquipmentAction | char(2) | Equipment Action | - | |
Description:No description available | ||||
EquipmentItemClass | char(2) | - | ||
Description:No description available | ||||
EquipmentLineRef | int | Component Ref. Nbr. | FSEquipmentComponent | |
Description:No description available | ||||
EstimatedDuration | int | Estimated Duration | - | |
Description:No description available | ||||
EstimatedDurationReportNonexistent in DB | int | - | ||
Description:No description available | ||||
EstimatedQty | decimal(25, 6) | Estimated Quantity | - | |
Description:No description available | ||||
EstimatedTranAmt | decimal(19, 4) | Base Estimated Amount | - | |
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
ExtCost | decimal(19, 6) | - | ||
Description:No description available | ||||
ExtraUsageQty | decimal(25, 6) | Overage Quantity | - | |
Description:No description available | ||||
ExtraUsageUnitPrice | decimal(19, 6) | Base Overage Unit Price | - | |
Description:No description available | ||||
GroupDiscountRate | decimal(9, 6) | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InventoryIDReportNonexistent in DB | int | InventoryItem | ||
Description:No description available | ||||
InvtMult | smallint | Inventory Multiplier | - | |
Description:No description available | ||||
IsBillable | bit | Billable | - | |
Description:No description available | ||||
IsFree | bit | Free Item | - | |
Description:No description available | ||||
IsKitNonexistent in DB | bit | Is a Kit | - | |
Description:No description available | ||||
IsPrepaid | bit | Prepaid Item | - | |
Description:No description available | ||||
IsStockItemNonexistent in DB | bit | Is stock | - | |
Description:No description available | ||||
IsTravelItemNonexistent in DB | bit | Is a Travel Item | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineQtyAvailNonexistent in DB | decimal | - | ||
Description:No description available | ||||
LineQtyHardAvailNonexistent in DB | decimal | - | ||
Description:No description available | ||||
LineRef | char(4) | Ref. Nbr. | - | |
Description:No description available | ||||
LineType | char(5) | Line Type | - | |
Description:No description available | ||||
LinkedDisplayRefNbrNonexistent in DB | nvarchar(MAX) | Related Doc. Nbr. | - | |
Description:No description available | ||||
LinkedDocRefNbr | nvarchar(15) | LinkedDocRefNbr | - | |
Description:No description available | ||||
LinkedDocType | varchar(4) | LinkedDocType | - | |
Description:No description available | ||||
LinkedEntityType | char(2) | Related Doc. Type | - | |
Description:No description available | ||||
LinkedLineNbr | int | Related Doc. Line Nbr. | - | |
Description:No description available | ||||
LocationIDNonexistent in DB | int | INLocation | ||
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | INLotSerialStatus | |
Description:No description available | ||||
ManualCost | bit | Manual Cost | - | |
Description:No description available | ||||
ManualDisc | bit | Manual Discount | - | |
Description:No description available | ||||
ManualPrice | bit | Manual Price | - | |
Description:No description available | ||||
Mem_LastReferencedByNonexistent in DB | nvarchar(50) | Last Reference | FSAppointment | |
Description:No description available | ||||
NewTargetEquipmentLineNbr | char(4) | Model Equipment Ref. Nbr. | FSSODet | |
Description:No description available | ||||
NoteID | uniqueidentifier | NoteID | - | |
Description:No description available | ||||
OpenQty | decimal(25, 6) | Open Qty. | - | |
Description:No description available | ||||
Operation | char(1) | Operation | SOOrderTypeOperation | |
Description:No description available | ||||
OrderQtyNonexistent in DB | decimal | Allocation Quantity | - | |
Description:No description available | ||||
OrigUnitCost | decimal(19, 6) | - | ||
Description:No description available | ||||
PlanType | nchar(2) | - | ||
Description:No description available | ||||
POCompleted | bit | PO Completed | - | |
Description:No description available | ||||
POCreateNonexistent in DB | bit | Mark for PO | - | |
Description:No description available | ||||
POLineNbr | int | PO Line Nbr. | - | |
Description:No description available | ||||
PONbr | nvarchar(15) | PO Nbr. | POOrder | |
Description:No description available | ||||
POSiteID | int | Purchase Warehouse | INSite | |
Description:No description available | ||||
POSource | char(1) | PO Source | - | |
Description:No description available | ||||
POStatus | char(1) | PO Status | - | |
Description:No description available | ||||
PostID | int | Post ID | FSPostInfo | |
Description:No description available | ||||
POType | char(2) | Order Type | SOOrderType | |
Description:No description available | ||||
POVendorID | int | Vendor ID | Vendor | |
Description:No description available | ||||
POVendorLocationID | int | Vendor Location ID | Location | |
Description:No description available | ||||
ProjectID | int | ProjectID | PMProject | |
Description:No description available | ||||
ProjectTaskID | int | Project Task | PMTask | |
Description:No description available | ||||
RequireAllocationNonexistent in DB | bit | - | ||
Description:No description available | ||||
RequireLocationNonexistent in DB | bit | - | ||
Description:No description available | ||||
RequireShippingNonexistent in DB | bit | - | ||
Description:No description available | ||||
ScheduleDetID | int | ScheduleDetID | - | |
Description:No description available | ||||
ScheduleID | int | FSSchedule | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ShipComplete | char(1) | Shipping Rule | - | |
Description:No description available | ||||
ShipDate | datetime2 | Ship On | - | |
Description:No description available | ||||
ShippedQty | decimal(25, 6) | Qty. On Shipments | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SiteLocationID | int | Location | INLocation | |
Description:No description available | ||||
SkipCostCodeValidationNonexistent in DB | bit | - | ||
Description:No description available | ||||
SkipUnitPriceCalcNonexistent in DB | bit | - | ||
Description:No description available | ||||
SMEquipmentID | int | Target Equipment ID | FSEquipment | |
Description:No description available | ||||
SODetID | int | SODetID | - | |
Description:No description available | ||||
SOID | int | SOID | - | |
Description:No description available | ||||
SOLineTypeNonexistent in DB | nchar(2) | SO Line Type | - | |
Description:No description available | ||||
SONewTargetEquipmentLineNbrNonexistent in DB | int | SO NewTargetEquipmentLineNbr | - | |
Description:No description available | ||||
SortOrder | int | Sort Order | - | |
Description:No description available | ||||
SourceLineID | int | Source Line ID | - | |
Description:No description available | ||||
SourceLineNbr | int | Source Line Nbr. | - | |
Description:No description available | ||||
SourceNoteID | uniqueidentifier | Source Note ID | - | |
Description:No description available | ||||
StaffID | int | Staff Member ID | BAccount | |
Description:No description available | ||||
Status | char(2) | Line Status | - | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TabOriginNonexistent in DB | int | - | ||
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TranDate | datetime | Transaction Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
TranTypeNonexistent in DB | nchar(3) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnassignedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
UnitCost | decimal(19, 6) | - | ||
Description:No description available | ||||
UnitPrice | decimal(19, 6) | Base Unit Price | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VendorIDNonexistent in DB | int | Vendor ID | Vendor | |
Description:No description available | ||||
Warranty | bit | Warranty | - | |
Description:No description available | ||||