WorkOrderLineItem

Name	Label	Type	Description
Id	Work Order Line Item ID	ID
IsDeleted	Deleted	CHECKBOX
LineItemNumber	Work Order Line Item Number	AUTO NUMBER
CreatedDate	Created Date	DATETIME
CreatedById	Created By ID	LOOKUP
LastModifiedDate	Last Modified Date	DATETIME
LastModifiedById	Last Modified By ID	LOOKUP
SystemModstamp	System Modstamp	DATETIME
LastViewedDate	Last Viewed Date	DATETIME
LastReferencedDate	Last Referenced Date	DATETIME
WorkOrderId	Work Order ID	MASTER-DETAIL
ParentWorkOrderLineItemId	Parent Work Order Line Item ID	LOOKUP
Product2Id	Product ID	LOOKUP
AssetId	Asset ID	LOOKUP
OrderId	Order ID	LOOKUP
RootWorkOrderLineItemId	Root Work Order Line Item ID	LOOKUP
Description	Description	TEXT AREA (LONG)(32000)
StartDate	Start Date	DATETIME
EndDate	End Date	DATETIME
Status	Status	PICKLIST
PricebookEntryId	Product ID	LOOKUP
Quantity	Quantity	NUMBER(10,2)
UnitPrice	Unit Price	CURRENCY(16,2)
Discount	Discount	PERCENT(3,2)
ListPrice	List Price	CURRENCY(16,2)
Subtotal	Subtotal	CURRENCY(16,2)
TotalPrice	Total Price	CURRENCY(16,2)
Duration	Duration	NUMBER(16,2)
DurationType	Duration Type	PICKLIST
DurationInMinutes	Duration in Minutes	NUMBER(16,2)
WorkTypeId	Work Type ID	LOOKUP
Street	Street	TEXT AREA(255)
City	City	TEXT(40)
State	State/Province	TEXT(80)
PostalCode	Zip/Postal Code	TEXT(20)
Country	Country	TEXT(80)
StateCode	State/Province Code	PICKLIST
CountryCode	Country Code	PICKLIST
Latitude	Latitude	NUMBER(3,15)
Longitude	Longitude	NUMBER(3,15)
GeocodeAccuracy	Geocode Accuracy	PICKLIST
Address	Address	AUTO NUMBER
ServiceTerritoryId	Territory ID	LOOKUP
Subject	Subject	TEXT(255)
StatusCategory	Status Category	PICKLIST
IsClosed	Is Closed	CHECKBOX
Priority	Priority	PICKLIST
ServiceAppointmentCount	Service Appointment Count	AUTO NUMBER
LocationId	Location ID	LOOKUP
MinimumCrewSize	Minimum Crew Size	AUTO NUMBER
RecommendedCrewSize	Recommended Crew Size	AUTO NUMBER
ServiceReportTemplateId	Service Report Layout ID	LOOKUP
ReturnOrderLineItemId	Return Order Line Item ID	LOOKUP
ReturnOrderId	Return Order ID	LOOKUP
SuggestedMaintenanceDate	Suggested Maintenance Date	DATE
MaintenancePlanId	Maintenance Plan ID	LOOKUP
IsGeneratedFromMaintenancePlan	Generated from maintenance plan	CHECKBOX
MaintenanceWorkRuleId	Maintenance Work Rule ID	LOOKUP
AssetWarrantyId	Asset Warranty ID	LOOKUP
ProductServiceCampaignId	Product Service Campaign ID	LOOKUP
ProductServiceCampaignItemId	Product Service Campaign Item ID	LOOKUP
FSL__IsFillInCandidate__c	Is Fill In Candidate	CHECKBOX
FSL__VisitingHours__c	Visiting Hours	LOOKUP

Name	Label
TR022_WorkOrderLineItem_AfterInsert	FSL.TR022_WorkOrderLineItem_AfterInsert
TR022_WorkOrderLineItem_AfterUpdate	FSL.TR022_WorkOrderLineItem_AfterUpdate
TR022_WorkOrderLineItem_BeforeInsert	FSL.TR022_WorkOrderLineItem_BeforeInsert
TR022_WorkOrderLineItem_BeforeUpdate	FSL.TR022_WorkOrderLineItem_BeforeUpdate

Name	Id
Label	Work Order Line Item ID
Type	ID
Required	Yes

Name	IsDeleted
Label	Deleted
Type	CHECKBOX
Required	Yes
Default value	false

Name	LineItemNumber
Label	Work Order Line Item Number
Type	AUTO NUMBER
Required	Yes

Name	CreatedDate
Label	Created Date
Type	DATETIME
Required	Yes

Name	CreatedById
Label	Created By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	LastModifiedDate
Label	Last Modified Date
Type	DATETIME
Required	Yes

Name	LastModifiedById
Label	Last Modified By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	SystemModstamp
Label	System Modstamp
Type	DATETIME
Required	Yes

Name	LastViewedDate
Label	Last Viewed Date
Type	DATETIME

Name	LastReferencedDate
Label	Last Referenced Date
Type	DATETIME

Name	WorkOrderId
Label	Work Order ID
Type	MASTER-DETAIL
Foreign key	Yes
Required	Yes

Name	ParentWorkOrderLineItemId
Label	Parent Work Order Line Item ID
Type	LOOKUP
Foreign key	Yes

Name	Product2Id
Label	Product ID
Type	LOOKUP
Foreign key	Yes

Name	AssetId
Label	Asset ID
Type	LOOKUP
Foreign key	Yes

Name	OrderId
Label	Order ID
Type	LOOKUP
Foreign key	Yes

Name	RootWorkOrderLineItemId
Label	Root Work Order Line Item ID
Type	LOOKUP
Foreign key	Yes

Name	Description
Label	Description
Type	TEXT AREA (LONG)(32000)

Name	StartDate
Label	Start Date
Type	DATETIME

Name	EndDate
Label	End Date
Type	DATETIME

Name	Status
Label	Status
Type	PICKLIST
Picklist values	New In Progress On Hold Completed Closed Cannot Complete Canceled

Name	PricebookEntryId
Label	Product ID
Type	LOOKUP
Foreign key	Yes

Name	Quantity
Label	Quantity
Type	NUMBER(10,2)

Name	UnitPrice
Label	Unit Price
Type	CURRENCY(16,2)

Name	Discount
Label	Discount
Type	PERCENT(3,2)

Name	ListPrice
Label	List Price
Type	CURRENCY(16,2)

Name	Subtotal
Label	Subtotal
Type	CURRENCY(16,2)

Name	TotalPrice
Label	Total Price
Type	CURRENCY(16,2)

Name	Duration
Label	Duration
Type	NUMBER(16,2)

Name	DurationType
Label	Duration Type
Type	PICKLIST
Picklist values	Hours Minutes

Name	DurationInMinutes
Label	Duration in Minutes
Type	NUMBER(16,2)

Name	WorkTypeId
Label	Work Type ID
Type	LOOKUP
Foreign key	Yes

Name	Street
Label	Street
Type	TEXT AREA(255)

Name	City
Label	City
Type	TEXT(40)

Name	State
Label	State/Province
Type	TEXT(80)

Name	PostalCode
Label	Zip/Postal Code
Type	TEXT(20)

Name	Country
Label	Country
Type	TEXT(80)

Name	StateCode
Label	State/Province Code
Type	PICKLIST
Picklist values	AC AG AG 05 02 AL AL AK AB AL AP AM AN AN AP 34 23 AO AR AZ AR AR AP AS AT ACT AV BA BC BS BA BT 11 BL BN BG BI BR BO BZ BS BR BC CA CA CL CM CB CI CW CE CT CZ CN CE CH CT CS 12 CH CH 50 CE CO CL CO CO CT CO CS CR KR CN DN DD DE DL DC DF DL D DG 38 EN ES DF FM FE FI FL FG FC FR 35 18 40 07 G 62 GE GA 21 GA GO GO GR GT 44 45 GR 52 GJ 10 46 HR HI 13 23 41 HG HP 34 01 91 42 43 28 08 ID IL IM IN IA IS 17 03 JA JK JH 32 36 22 37 46 14 KS KA KY KL KY KE KK 39 43 26 AQ LD LS SP LT LE LC LM 21 LK LI LO LD LA LH LU 92 MC MP MH ME MN MB MN MA MD MS MA MT MT MS MO MH VS ML ME ME MI MI 24 MI MG MN MS MO 04 45 MZ MO MN MT MB MO NL 20 42 NA 29 NA NE 15 NV NB NL NH NJ NM NSW NY 15 64 NC ND NT NT NO NS NL NU NU OA OR OY OG OH 44 33 47 OK OT ON OR OR 27 PD PA PA PB PR PR PV PA PE PG PU PE PC PI PI PT PN PZ PO PE PY PB PB 63 QC QLD QE QR RG RJ RA RC RE RI RI RN RJ RN RS RM RO RR RN RO 41 11 SA SL SC SP SK SS SV SE 61 37 31 14 25 32 22 51 SI SK SI SO SO SO SA SC SD SR TB 71 TM TN TA TAS TG TN TE TR TX 12 TA TL TO 09 36 13 31 16 TP TN TV TS TR TO UD UT UT UP VA VE VE VB VC VT VR VV VI VIC VA VT 30 WA WD WB WA WH WV WX WW WI WY 65 54 06 35 19 YU YT 53 ZA 33

Name	CountryCode
Label	Country Code
Type	PICKLIST
Picklist values	AF AX AL DZ AD AO AI AQ AG AR AM AW AU AT AZ BS BH BD BB BY BE BZ BJ BM BT BO BQ BA BW BV BR IO BN BG BF BI KH CM CA CV KY CF TD CL CN CX CC CO KM CG CD CK CR CI HR CW CY CZ DK DJ DM DO EC EG SV GQ ER EE SZ ET FK FO FJ FI FR GF PF TF GA GM GE DE GH GI GR GL GD GP GT GG GN GW GY HT HM VA HN HU IS IN ID IQ IE IM IL IT JM JP JE JO KZ KE KI KR XK KW KG LA LV LB LS LR LY LI LT LU MO MG MW MY MV ML MT MQ MR MU YT MX MD MC MN ME MS MA MZ MM NA NR NP NL NC NZ NI NE NG NU NF MK NO OM PK PS PA PG PY PE PH PN PL PT QA RE RO RU RW BL SH KN LC MF PM VC WS SM ST SA SN RS SC SL SG SX SK SI SB SO ZA GS SS ES LK SR SJ SE CH TW TJ TZ TH TL TG TK TO TT TN TR TM TC TV UG UA AE GB US UY UZ VU VE VN VG WF EH YE ZM ZW

Name	Latitude
Label	Latitude
Type	NUMBER(3,15)

Name	Longitude
Label	Longitude
Type	NUMBER(3,15)

Name	GeocodeAccuracy
Label	Geocode Accuracy
Type	PICKLIST
Picklist values	Address NearAddress Block Street ExtendedZip Zip Neighborhood City County State Unknown

Name	Address
Label	Address
Type	AUTO NUMBER

Name	ServiceTerritoryId
Label	Territory ID
Type	LOOKUP
Foreign key	Yes

Name	Subject
Label	Subject
Type	TEXT(255)

Name	StatusCategory
Label	Status Category
Type	PICKLIST
Picklist values	New InProgress OnHold Completed Closed None CannotComplete Canceled

Name	IsClosed
Label	Is Closed
Type	CHECKBOX
Required	Yes
Default value	false

Name	Priority
Label	Priority
Type	PICKLIST
Picklist values	Low Medium High Critical

Name	ServiceAppointmentCount
Label	Service Appointment Count
Type	AUTO NUMBER

Name	LocationId
Label	Location ID
Type	LOOKUP
Foreign key	Yes

Name	MinimumCrewSize
Label	Minimum Crew Size
Type	AUTO NUMBER

Name	RecommendedCrewSize
Label	Recommended Crew Size
Type	AUTO NUMBER

Name	ServiceReportTemplateId
Label	Service Report Layout ID
Type	LOOKUP

Name	ReturnOrderLineItemId
Label	Return Order Line Item ID
Type	LOOKUP
Foreign key	Yes

Name	ReturnOrderId
Label	Return Order ID
Type	LOOKUP
Foreign key	Yes

Name	SuggestedMaintenanceDate
Label	Suggested Maintenance Date
Type	DATE

Name	MaintenancePlanId
Label	Maintenance Plan ID
Type	LOOKUP
Foreign key	Yes

Name	IsGeneratedFromMaintenancePlan
Label	Generated from maintenance plan
Type	CHECKBOX
Required	Yes
Default value	false

Name	MaintenanceWorkRuleId
Label	Maintenance Work Rule ID
Type	LOOKUP
Foreign key	Yes

Name	AssetWarrantyId
Label	Asset Warranty ID
Type	LOOKUP
Foreign key	Yes

Name	ProductServiceCampaignId
Label	Product Service Campaign ID
Type	LOOKUP
Foreign key	Yes

Name	ProductServiceCampaignItemId
Label	Product Service Campaign Item ID
Type	LOOKUP
Foreign key	Yes

Name	FSL__IsFillInCandidate__c
Label	Is Fill In Candidate
Type	CHECKBOX
Required	Yes
Default value	true

Name	FSL__VisitingHours__c
Label	Visiting Hours
Type	LOOKUP
Foreign key	Yes

Name
Home Health

Name	Parent object	Child object	Parent object field	Child object field
ForecastContext	WorkOrderLineItem	AdvAcctForecastSetUse	Id	ForecastContextId
ContentContext	WorkOrderLineItem	AssessmentTaskContentDocument	Id	ContentContextId
FirstPublishLocation	WorkOrderLineItem	ContentVersion	Id	FirstPublishLocationId
ParentRecord	WorkOrderLineItem	DocumentChecklistItem	Id	ParentRecordId
ReferenceObject	WorkOrderLineItem	DocumentEnvelope	Id	ReferenceObjectId
RelatedTo	WorkOrderLineItem	EmailMessage	Id	RelatedToId
What	WorkOrderLineItem	Event	Id	WhatId
RelatedRecord	WorkOrderLineItem	FlowOrchestrationWorkItem	Id	RelatedRecordId
ReferenceObject	WorkOrderLineItem	GeneratedDocument	Id	ReferenceObjectId
Context	WorkOrderLineItem	GenericVisitTaskContext	Id	ContextId
LinkedEntity	WorkOrderLineItem	LinkedArticle	Id	LinkedEntityId
WorkOrderLineItem	WorkOrderLineItem	ProductConsumed	Id	WorkOrderLineItemId
WorkOrderLineItem	WorkOrderLineItem	ProductRequest	Id	WorkOrderLineItemId
WorkOrderLineItem	WorkOrderLineItem	ProductRequestLineItem	Id	WorkOrderLineItemId
ParentRecord	WorkOrderLineItem	ProductRequired	Id	ParentRecordId
RelatedRecord	WorkOrderLineItem	ResourcePreference	Id	RelatedRecordId
ParentRecord	WorkOrderLineItem	ServiceAppointment	Id	ParentRecordId
RelatedRecord	WorkOrderLineItem	SkillRequirement	Id	RelatedRecordId
What	WorkOrderLineItem	Task	Id	WhatId
Relation	WorkOrderLineItem	TaskRelation	Id	RelationId
WorkOrderLineItem	WorkOrderLineItem	TimeSheetEntry	Id	WorkOrderLineItemId
ParentWorkOrderLineItem	WorkOrderLineItem	WorkOrderLineItem	Id	ParentWorkOrderLineItemId
RootWorkOrderLineItem	WorkOrderLineItem	WorkOrderLineItem	Id	RootWorkOrderLineItemId
WorkOrderLineItem	WorkOrderLineItem	WorkPlan	Id	WorkOrderLineItemId
ParentRecord	WorkOrderLineItem	WorkPlan	Id	ParentRecordId
WorkOrderLineItem	WorkOrderLineItem	WorkStep	Id	WorkOrderLineItemId
ParentRecord	WorkOrderLineItem	WorkStep	Id	ParentRecordId

Name	Parent object	Child object	Parent object field	Child object field
CreatedBy	User	WorkOrderLineItem	Id	CreatedById
LastModifiedBy	User	WorkOrderLineItem	Id	LastModifiedById
WorkOrder	WorkOrder	WorkOrderLineItem	Id	WorkOrderId
ParentWorkOrderLineItem	WorkOrderLineItem	WorkOrderLineItem	Id	ParentWorkOrderLineItemId
Product2	Product2	WorkOrderLineItem	Id	Product2Id
Asset	Asset	WorkOrderLineItem	Id	AssetId
Order	Order	WorkOrderLineItem	Id	OrderId
RootWorkOrderLineItem	WorkOrderLineItem	WorkOrderLineItem	Id	RootWorkOrderLineItemId
PricebookEntry	PricebookEntry	WorkOrderLineItem	Id	PricebookEntryId
WorkType	WorkType	WorkOrderLineItem	Id	WorkTypeId
ServiceTerritory	ServiceTerritory	WorkOrderLineItem	Id	ServiceTerritoryId
Location	Location	WorkOrderLineItem	Id	LocationId
ReturnOrderLineItem	ReturnOrderLineItem	WorkOrderLineItem	Id	ReturnOrderLineItemId
ReturnOrder	ReturnOrder	WorkOrderLineItem	Id	ReturnOrderId
MaintenancePlan	MaintenancePlan	WorkOrderLineItem	Id	MaintenancePlanId
MaintenanceWorkRule	MaintenanceWorkRule	WorkOrderLineItem	Id	MaintenanceWorkRuleId
AssetWarranty	AssetWarranty	WorkOrderLineItem	Id	AssetWarrantyId
ProductServiceCampaign	ProductServiceCampaign	WorkOrderLineItem	Id	ProductServiceCampaignId
ProductServiceCampaignItem	ProductServiceCampaignItem	WorkOrderLineItem	Id	ProductServiceCampaignItemId
FSL__VisitingHours__r	OperatingHours	WorkOrderLineItem	Id	FSL__VisitingHours__c

Label	Value