| ServiceOrderHead.FacilityID |
MFS@DisplayList={"Col":["Facility.Facility"],"Tbl":["Facility"]}
|
| ServiceAssignment.EquipmentID |
MFS@DisplayList={"Col":["Product.ProductNo","Equipment.SerialNumber","Equipment.ModelDescription"],"Tbl":["Product","Equipment","EquipmentAccount"],"Join":[["PrimaryKey","ProductID"],["PrimaryKey","EquipmentID"]],"JoinType":["Join","LeftJoin"],"SetVal":["Equipment.OriginIdentity","EquipmentAccount.AccountID=ServiceOrderHead.AccountID","Equipment.AgreementHeaderID=ServiceOrderHead.AgreementHeaderID","Equipment.ProductID=ServiceAssignment.EquipmentProductID","Equipment.PrimaryKey=ServiceAssignment.EquipmentSerialNumber","Equipment.ManufacturerSerialNumber=Equipment.ManufacturerSerialNumber","Equipment.PrimaryKey=ServiceAssignment.EquipmentID"],"Ftr":["EquipmentAccount.AccountID=","Equipment.PrimaryKey","Equipment.Status>"],"Val":["ServiceOrderHead.AccountID","IS NOT NULL","15"],"Op":["AND"],"Pk":"Equipment.EquipmentID","Clr":["Equipment.OriginIdentity","ServiceOrderHead.ServiceWarrantyID","ServiceAssignment.ServiceID","ServiceOrderHead.FacilityID"],"IsReadOnlySetVal":true,"UseEntityValOnLoad":["ServiceOrderHead.AgreementHeaderID","ServiceOrderHead.AccountID"],"barcodeEnabled":"true"}
|
| Service.ProductStructureTypeCODE |
MFS@DisplayList={"Col":["Code.GlobalCodeId","Code.Description"],"Tbl":["Service","Code"],"Join":[["ProductStructureTypeCODE","PrimaryKey"]],"Clr":["ServiceAssignment.ServiceID","ServiceOrderHead.FacilityID"],"Pk":"Code.PrimaryKey","RemoveDuplicate":1}
|
| ServiceOrderHead.ServiceOrderTypeCODE |
MFS@DisplayList={"Col":["Code.GlobalCodeId","Code.Description"],"Tbl":["Service","ServiceFacility","Code"],"Join":[["PrimaryKey","ServiceID"],["ServiceOrderTypeCODE","PrimaryKey"]],"Clr":["ServiceAssignment.ServiceID","Service.ProductStructureTypeCODE","ServiceOrderHead.FacilityID"],"Pk":"Code.PrimaryKey","RemoveDuplicate":1}
|
| ServiceAssignment.EquipmentSerialNumber |
MFS@DisplayList={"Col":["Equipment.SerialNumber","Equipment.ModelDescription"],"Tbl":["Equipment","EquipmentAccount","AccountAddress"],"LeftJoin":[["PrimaryKey","EquipmentID"],["AccountAddressID","PrimaryKey"]],"Ftr":["Equipment.ProductID=","Equipment.PlanFacilityID=","Equipment.Status>"],"Val":["ServiceAssignment.EquipmentProductID","CRMUser.FacilityID","15"],"Op":["AND"],"SetVal":["Equipment.SerialNumber=ServiceAssignment.EquipmentSerialNumber","Equipment.ProductID=ServiceAssignment.EquipmentProductID","Equipment.PrimaryKey=Equipment.ManufacturerSerialNumber","Equipment.PrimaryKey=ServiceAssignment.EquipmentID","EquipmentAccount.AccountID=ServiceOrderHead.AccountID","Equipment.AgreementHeaderID=ServiceOrderHead.AgreementHeaderID","AccountAddress.AddressId=ServiceOrderHeadAddress.ExternalAddressIdentifier","AccountAddress.Address=ServiceOrderHeadAddress.Address","Equipment.ModelDescription"],"IgnoreNullOnSetVal":["ServiceOrderHeadAddress.ExternalAddressIdentifier","ServiceOrderHeadAddress.Address"],"IsReadOnlySetVal":true,"Clr":["ServiceOrderHead.ServiceWarrantyID","ServiceAssignment.ServiceID","ServiceOrderHead.FacilityID"],"UseEntityValOnLoad":["ServiceOrderHead.AccountID","ServiceOrderHead.AgreementHeaderID","ServiceOrderHeadAddress.ExternalAddressIdentifier","ServiceOrderHeadAddress.Address"],"barcodeEnabled":"true"}
|
| ServiceAssignment.ServiceID |
MFS@DisplayList={"Col":["Service.Service"],"Tbl":["ServiceFacility","Service","Code"],"Join":[["ServiceID","PrimaryKey"],["ProductStructureTypeCODE","PrimaryKey"]],"Clr":["ServiceOrderHead.FacilityID"],"Ftr":["Service.ProductStructureTypeCODE=","ServiceFacility.ServiceOrderTypeCODE=","Service.ProductID=","Service.ProductID","Service.ProductID","Service.ProductStructureTypeCODE=","ServiceFacility.ServiceOrderTypeCODE="],"Val":["Service.ProductStructureTypeCODE","ServiceOrderHead.ServiceOrderTypeCODE","ServiceAssignment.EquipmentProductID","IS NOT NULL","IS NULL","Service.ProductStructureTypeCODE","ServiceOrderHead.ServiceOrderTypeCODE"],"Op":["AND","AND","AND","OR","AND","AND"],"SetVal":["Service.ProductStructureTypeCODE","ServiceFacility.ServiceOrderTypeCODE=ServiceOrderHead.ServiceOrderTypeCODE","Service.Description=ServiceOrderHead.FreeText1","Service.Description=ServiceOrderHead.Description","Service.WarrantyCheck=ServiceOrderHead.WarrantyCheck","ServiceFacility.FacilityID","ServiceFacility.PrimaryKey","Code.GlobalCodeId","Service.ComponentInstalled"],"Pk":"ServiceFacility.ServiceID","RemoveDuplicate":1}
|