FS
FSAppointmentDet
PX.Objects.FS144 of 144 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
RefNbr | nvarchar(20) | Appointment Nbr. | FSAppointment | |
Description:No description available | ||||
SrvOrdType | char(4) | Service Order Type | FSSrvOrdType | |
Description:No description available | ||||
AcctID | int | Account | Account | |
Description:No description available | ||||
ActualDuration | int | Actual Duration | - | |
Description:No description available | ||||
ActualQty | decimal(25, 6) | Actual Quantity | - | |
Description:No description available | ||||
AllocatedFromSrvOrdPOQty | decimal(25, 6) | Allocated from Service Order PO Qty. | - | |
Description:No description available | ||||
AppDetID | int | - | ||
Description:No description available | ||||
AppointmentID | int | Appointment Nbr. | - | |
Description:No description available | ||||
AreActualFieldsActiveNonexistent in DB | bit | - | ||
Description:No description available | ||||
BaseActualQty | decimal(25, 6) | Base Actual Qty. | - | |
Description:No description available | ||||
BaseAllocatedFromSrvOrdPOQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseBillableQty | decimal(25, 6) | Base Billable Qty. | - | |
Description:No description available | ||||
BaseEffTranQty | decimal(25, 6) | Base Transaction Qty. | - | |
Description:No description available | ||||
BaseEstimatedQty | decimal(25, 6) | Base Estimated Qty. | - | |
Description:No description available | ||||
BillableExtPrice | decimal(19, 4) | - | ||
Description:No description available | ||||
BillableQty | decimal(25, 6) | Billable Quantity | - | |
Description:No description available | ||||
BillableTranAmt | decimal(19, 4) | Base Billable Amount | - | |
Description:No description available | ||||
BillingRule | char(4) | Billing Rule | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CanChangeMarkForPONonexistent in DB | bit | - | ||
Description:No description available | ||||
Comment | varchar(255) | Equipment Action Comment | - | |
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 | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CoveredQty | decimal(25, 6) | Covered Quantity | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | CreatedByID | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | CreatedByScreenID | - | |
Description:No description available | ||||
CreatedDateTime | datetime | CreatedDateTime | - | |
Description:No description available | ||||
CuryBillableExtPrice | decimal(19, 4) | Ext. Price | - | |
Description:No description available | ||||
CuryBillableTranAmt | decimal(19, 4) | Billable Amount | - | |
Description:No description available | ||||
CuryDiscAmt | decimal(19, 4) | Discount Amount | - | |
Description:No description available | ||||
CuryEstimatedExtCost | decimal(19, 4) | CuryEstimatedExtCost | - | |
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 | ||||
CuryTranAmt | decimal(19, 4) | Actual Amount | - | |
Description:No description available | ||||
CuryUnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
CuryUnitPrice | decimal(19, 6) | Unit Price | - | |
Description:No description available | ||||
DiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
DiscountID | nvarchar(10) | Discount Code | ARDiscount | |
Description:No description available | ||||
DiscountsAppliedToLine | varbinary(MAX) | - | ||
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 | ||||
EffTranQty | decimal(25, 6) | Transaction Qty. | - | |
Description:No description available | ||||
EnablePO | bit | Mark for PO | - | |
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 | ||||
EstimatedExtCost | decimal(19, 4) | - | ||
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 | ||||
ExpenseEmployeeID | int | Expense Staff Member ID | BAccount | |
Description:No description available | ||||
ExpireDateNonexistent in DB | datetime | 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 | ||||
INOpenQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
InventoryCDNonexistent in DB | nvarchar(MAX) | Inventory ID | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InventoryIDReportNonexistent in DB | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvtMultNonexistent in DB | smallint | Inventory Multiplier | - | |
Description:No description available | ||||
IsBillable | bit | Billable | - | |
Description:No description available | ||||
IsCanceledNotPerformed | bit | - | ||
Description:No description available | ||||
IsFree | bit | Free Item | - | |
Description:No description available | ||||
IsLotSerialRequiredNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsPrepaid | bit | Prepaid Item | - | |
Description:No description available | ||||
IsTravelItem | bit | Is a Travel Item | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | LastModifiedByID | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | LastModifiedByScreenID | - | |
Description:No description available | ||||
LastModifiedDateTime | datetime | LastModifiedDateTime | - | |
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 | ||||
LogActualDuration | int | Log Actual Duration | - | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | - | |
Description:No description available | ||||
LotSerTrack | nchar(1) | - | ||
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_BatchNbrNonexistent in DB | nchar(15) | Batch Nbr. | - | |
Description:No description available | ||||
NewTargetEquipmentLineNbr | char(4) | Model Equipment Ref. Nbr. | FSAppointmentDet | |
Description:No description available | ||||
NoteID | uniqueidentifier | NoteID | - | |
Description:No description available | ||||
OperationNonexistent in DB | nchar(1) | - | ||
Description:No description available | ||||
OrigLineNbr | int | Service Order Line Nbr. | FSSODet | |
Description:No description available | ||||
OrigSrvOrdNbr | nvarchar(15) | Service Order Nbr. | FSServiceOrder | |
Description:No description available | ||||
PickupDeliveryAppLineRef | char(4) | Pickup/Delivery Ref. Nbr. | FSAppointmentDet | |
Description:No description available | ||||
PickupDeliveryServiceID | int | Pickup/Delivery Service ID | InventoryItem | |
Description:No description available | ||||
POCompleted | bit | PO Completed | - | |
Description:No description available | ||||
POLineNbr | int | PO Line Nbr. | - | |
Description:No description available | ||||
PONbr | nvarchar(15) | PO Nbr. | POOrder | |
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 | ||||
PriceCode | nvarchar(30) | Price Code | - | |
Description:No description available | ||||
PriceType | char(5) | Price Type | - | |
Description:No description available | ||||
ProjectID | int | ProjectID | PMProject | |
Description:No description available | ||||
ProjectTaskID | int | Project Task | PMTask | |
Description:No description available | ||||
QtyNonexistent in DB | unspecified | Qty. | - | |
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 | ||||
ServiceType | char(1) | Pickup/Delivery Action | - | |
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 | ||||
SMEquipmentID | int | Target Equipment ID | FSEquipment | |
Description:No description available | ||||
SODetCreate | bit | SODetCreate | - | |
Description:No description available | ||||
SODetID | int | Service Order Detail Ref. Nbr. | FSSODet | |
Description:No description available | ||||
SOLineTypeNonexistent in DB | nchar(2) | SO Line Type | - | |
Description:No description available | ||||
SortOrder | int | Sort Order | - | |
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 | ||||
TaskIDNonexistent in DB | int | - | ||
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TranAmt | decimal(19, 4) | Base Actual Amount | - | |
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 | ||||
UIStatusNonexistent in DB | nchar(2) | Line Status | - | |
Description:No description available | ||||
UnassignedQty | decimal(25, 6) | Unassigned Qty. | - | |
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 | ||||
Warranty | bit | Warranty | - | |
Description:No description available | ||||