BOMQSP: Shift Pattern Query
The Shift Pattern Query business object caters for the creation of the BOM Shift Pattern Report.
Properties
| Syspro Module | Bill of Materials |
| Class | Query |
| Methods | Query |
| Functional Area | Bill of Material Primary Query |
| Initial version released | Syspro 8 2021 R2 |
Input XML
The .XML and .XSD input files indicate the parameters schema and an instance of an XML document for this business object.
BOMQSP.XML
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2021 SYSPRO Ltd.-->
<!--
Sample XML for the Shift Pattern Selections Query Business Object
-->
<Query xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="BOMQSP.XSD">
<Option>
<IncludeAlternateShifts>N</IncludeAlternateShifts>
<XslStyleSheet></XslStyleSheet>
</Option>
<Filter>
<ShiftCode FilterType="A" FilterValue=" "/>
<Site FilterType="A" FilterValue=" "/>
<WorkCenter FilterType="A" FilterValue=" "/>
<ProductionLine FilterType="A" FilterValue=" "/>
<Machine FilterType="A" FilterValue=" "/>
<Warehouse FilterType="A" FilterValue=" "/>
</Filter>
</Query>
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2021 SYSPRO Ltd.-->
<!--
Schema for the Shift Pattern Selections Query Business Object
-->
<xsd:schema elementFormDefault="qualified" attributeFormDefault="unqualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element name="Filter">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="ShiftCode" minOccurs="0"/>
<xsd:element ref="Site" minOccurs="0"/>
<xsd:element ref="WorkCenter" minOccurs="0"/>
<xsd:element ref="ProductionLine" minOccurs="0"/>
<xsd:element ref="Machine" minOccurs="0"/>
<xsd:element ref="Warehouse" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="Option">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="IncludeAlternateShifts" minOccurs="0"/>
<xsd:element ref="XslStyleSheet" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="Query">
<xsd:annotation>
<xsd:documentation>This is the root element</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="Option"/>
<xsd:element ref="Filter"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="XslStyleSheet">
<xsd:annotation>
<xsd:documentation>The stylesheet to be applied</xsd:documentation>
<xsd:appinfo source="screenItem=N"/>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="ShiftCode">
<xsd:annotation>
<xsd:documentation>This indicates the Shift code selection (A - All, R - Range, S - Single, L - List). If not provided the default is A (All).</xsd:documentation>
<xsd:appinfo source="screenItem=Y;browse=BomShiftHdr;A=All;S=Single;R=Range;L=List"/>
</xsd:annotation>
<xsd:complexType>
<xsd:attribute name="FilterType" use="optional" default="A">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="A"/>
<xsd:enumeration value="R"/>
<xsd:enumeration value="S"/>
<xsd:enumeration value="L"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="FilterValue" type="xsd:string" use="optional"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="Site">
<xsd:annotation>
<xsd:documentation>This indicates the Site selection (A - All, R - Range, S - Single, L - List). Only applies when the Shift pattern level is at Site. If not provided the default is A (All).</xsd:documentation>
<xsd:appinfo source="screenItem=Y;browse=BomSiteCode;A=All;S=Single;R=Range;L=List"/>
</xsd:annotation>
<xsd:complexType>
<xsd:attribute name="FilterType" use="optional" default="A">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="A"/>
<xsd:enumeration value="R"/>
<xsd:enumeration value="S"/>
<xsd:enumeration value="L"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="FilterValue" type="xsd:string" use="optional"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="WorkCenter">
<xsd:annotation>
<xsd:documentation>This indicates the Work center selection (A - All, R - Range, S - Single, L - List). Only applies if the Shift pattern level is at Work center. If not provided the default is A (All).</xsd:documentation>
<xsd:appinfo source="screenItem=Y;browse=BomWorkCentre;A=All;S=Single;R=Range;L=List"/>
</xsd:annotation>
<xsd:complexType>
<xsd:attribute name="FilterType" use="optional" default="A">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="A"/>
<xsd:enumeration value="R"/>
<xsd:enumeration value="S"/>
<xsd:enumeration value="L"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="FilterValue" type="xsd:string" use="optional"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="ProductionLine">
<xsd:annotation>
<xsd:documentation>This indicates the Production line selection (A - All, R - Range, S - Single, L - List). Only applies if the Shift pattern level is at Production Line. If not provided the default is A (All).</xsd:documentation>
<xsd:appinfo source="screenItem=Y;browse=BomProdLine;A=All;S=Single;R=Range;L=List"/>
</xsd:annotation>
<xsd:complexType>
<xsd:attribute name="FilterType" use="optional" default="A">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="A"/>
<xsd:enumeration value="R"/>
<xsd:enumeration value="S"/>
<xsd:enumeration value="L"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="FilterValue" type="xsd:string" use="optional"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="Machine">
<xsd:annotation>
<xsd:documentation>This indicates the Machine selection (A - All, R - Range, S - Single, L - List).Only applies if the Shift pattern level is at Machine. If not provided the default is A (All).</xsd:documentation>
<xsd:appinfo source="screenItem=Y;browse=BomMachine;A=All;S=Single;R=Range;L=List"/>
</xsd:annotation>
<xsd:complexType>
<xsd:attribute name="FilterType" use="optional" default="A">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="A"/>
<xsd:enumeration value="R"/>
<xsd:enumeration value="S"/>
<xsd:enumeration value="L"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="FilterValue" type="xsd:string" use="optional"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="Warehouse">
<xsd:annotation>
<xsd:documentation>This indicates the Warehouse selection (A - All, R - Range, S - Single, L - List). Only applies if the Shift pattern level is at Warehouse. If not provided the default is A (All).</xsd:documentation>
<xsd:appinfo source="screenItem=Y;browse=InvWhControl;A=All;S=Single;R=Range;L=List"/>
</xsd:annotation>
<xsd:complexType>
<xsd:attribute name="FilterType" use="optional" default="A">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="A"/>
<xsd:enumeration value="R"/>
<xsd:enumeration value="S"/>
<xsd:enumeration value="L"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="FilterValue" type="xsd:string" use="optional"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="IncludeAlternateShifts" default="N">
<xsd:annotation>
<xsd:documentation>This indicates if alternate shifts should be output. (Y - Yes, N - No) Default to N (No).</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:schema>
Output XML
The OUT.XML indicates a sample of the XML returned by this business object.
BOMQSPOUT.XML
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2021 SYSPRO Ltd.-->
<!--
Sample XML for the Shift Pattern Query Business Object
-->
<Query xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="BOMQSPOUT.XSD">
<SystemInformation>
<CssStyle/>
<Language>05</Language>
<DecFormat>1</DecFormat>
<DateFormat>01</DateFormat>
<Role>01</Role>
<Version>6.0.009</Version>
<CompanyId>0</CompanyId>
<CompanyName>The OUTDOORS Company</CompanyName>
<OperatorCode>ADMIN</OperatorCode>
<OperatorName>SYSPRO Administrator</OperatorName>
<OperatorGroup>ADMIN</OperatorGroup>
<OperatorEmailAddress/>
<OperatorLocation/>
<ReportDate>Thursday November 2006 14:05 PM</ReportDate>
<UseSeparatorOnReports>N</UseSeparatorOnReports>
<SeparatorToUse>,</SeparatorToUse>
<OperatorPrimaryRole/>
<NoOfDigits>2</NoOfDigits>
<DecCharToUse>,</DecCharToUse>
<BOMQtyPerDecimals>6</BOMQtyPerDecimals>
</SystemInformation>
<QueryOptions>
<IncludeAlternateShifts>N</IncludeAlternateShifts>
<Translated_IncludeAlternateShifts>No</Translated_IncludeAlternateShifts>
<ShiftCodeFilterType>A</ShiftCodeFilterType>
<ShiftCodeFilterValue>All</ShiftCodeFilterValue>
<Translated_ShiftCodeFilterValue>All</Translated_ShiftCodeFilterValue>
<SiteFilterType>A</SiteFilterType>
<SiteFilterValue>All</SiteFilterValue>
<Translated_SiteFilterValue>All</Translated_SiteFilterValue>
<WorkCenterFilterType>A</WorkCenterFilterType>
<WorkCenterFilterValue>All</WorkCenterFilterValue>
<Translated_WorkCenterFilterValue>All</Translated_WorkCenterFilterValue>
<ProductionLineFilterType>A</ProductionLineFilterType>
<ProductionLineFilterValue>All</ProductionLineFilterValue>
<Translated_ProductionLineFilterValue>All</Translated_ProductionLineFilterValue>
<MachineFilterType>A</MachineFilterType>
<MachineFilterValue>All</MachineFilterValue>
<Translated_MachineFilterValue>All</Translated_MachineFilterValue>
<WarehouseFilterType>A</WarehouseFilterType>
<WarehouseFilterValue>All</WarehouseFilterValue>
<Translated_WarehouseFilterValue>All</Translated_WarehouseFilterValue>
<ShiftPatternLevel>C</ShiftPatternLevel>
</QueryOptions>
<AffectedItems>
<AffectedItem>
<ShiftCode>Week1</ShiftCode>
<Description>Weekly pattern</Description>
<RecurPattern>W</RecurPattern>
<Translated_RecurPattern>Weekly</Translated_RecurPattern>
<StartDate>2021/01/01</StartDate>
<EndType>N</EndType>
<Translated_EndType>No end</Translated_EndType>
<EndDate/>
<EndOccur/>
<MachineEfficiency>80</MachineEfficiency>
<DailyInfo>
<DailyType>W</DailyType>
<Translated_DailyType>Every weekday</Translated_DailyType>
<DailyOccurrences/>
</DailyInfo>
<WeeklyInfo>
<WeeklyOccurrences>2</WeeklyOccurrences>
</WeeklyInfo>
<MonthlyInfo>
<MonthlyType>D</MonthlyType>
<Translated_MonthlyType>Day of month</Translated_MonthlyType>
<DayOfMonth>15</DayOfMonth>
<SpecificDay>1</SpecificDay>
<Translated_SpecificDay>First</Translated_SpecificDay>
<MonthlyOccurrences>2</MonthlyOccurrences>
<MonthDailyPattern>W</MonthDailyPattern>
<Translated_MonthDailyPattern>Weekday</Translated_MonthDailyPattern>
</MonthlyInfo>
<YearlyInfo>
<YearlyOccurrences>1</YearlyOccurrences>
<YearlyType>D</YearlyType>
<Translated_YearlyType>Specific day</Translated_YearlyType>
<Month>06</Month>
<Day>15</Day>
<OccuranceDay>2</OccuranceDay>
<Translated_OccuranceDay>Second</Translated_OccuranceDay>
<YearDailyPattern>TUE</YearDailyPattern>
<Translated_YearDailyPattern>Tuesday</Translated_YearDailyPattern>
</YearlyInfo>
<ShiftDetails>
<ShiftDetailCode>MON</ShiftDetailCode>
<Description>Monday Shift</Description>
<DayOfWeek>1</DayOfWeek>
<Translated_DayOfWeek>Monday</Translated_DayOfWeek>
<MaintInProcess/>
<Trans_MaintInProcess>No</Trans_MaintInProcess>
<StartTime>08:30:00</StartTime>
<EndTime>04:30:00</EndTime>
<Duration>8</Duration>
</ShiftDetails>
<ShiftDetails>
<ShiftDetailCode>THU</ShiftDetailCode>
<Description>Thursday Shift</Description>
<DayOfWeek>4</DayOfWeek>
<Translated_DayOfWeek>Thursday</Translated_DayOfWeek>
<MaintInProcess/>
<Trans_MaintInProcess>No</Trans_MaintInProcess>
<StartTime>10:00:00</StartTime>
<EndTime>02:00:00</EndTime>
<Duration>4</Duration>
</ShiftDetails>
</AffectedItem>
<ShiftWhereUsed>
<ShiftCode>Week1</ShiftCode>
<WhereUsedDetails>
<Site>North</Site>
<WorkCenter>ASSEMB</WorkCenter>
<ProductionLine>PRODN</ProductionLine>
<Machine>ASSE01</Machine>
<Warehouse/>
</WhereUsedDetails>
<WhereUsedDetails>
<Site>South</Site>
<WorkCenter>ASSEMB</WorkCenter>
<ProductionLine>PRODS</ProductionLine>
<Machine>ASSE01</Machine>
<Warehouse/>
</WhereUsedDetails>
</ShiftWhereUsed>
</AffectedItems>
</Query>
Prerequisites
No prerequisites are required to use this business object.
Limitations
No limitations apply to this business object.
Copyright © 2026 Syspro PTY Ltd.