BOMQPS: BOM Progressive Scrap Query
The BOM Progressive Scrap Query business object is used to show how progressive scrap, defined against the parent item’s operations, affects the parent quantity to manufacture through the manufacturing process.
It can also optionally return information about the item’s components and operation showing what effect progressive scrap has against the operations in total times (quantity in the case of subcontract) and against components in total quantities required. BOM or what-if total costs can also be returned for both operation and materials.
The following information is always returned for the entered parent stock code/route:Static information e.g. stock code description, part category warehouse to use.Route and route descriptionGross quantityNet quantity after progressive scrap has been applied on the gross quantity
The following information is optionally returned for operations defined against the parent item or route:Static information e.g. operation, work center, work center description, lead time.Progressive scrap percentage and quantity.Parent quantity at the start of the operation and quantity at the end of the operation.Total times required for the parent start quantity.Total costs (what if or BOM) are optionally returned based on the parent start quantity.Operation Narrations are optionally returned.Custom form fields are optionally returned.
The following information is optionally returned for materials defined against the parent item or route:Static information e.g. stock code description, part category warehouse to use.Parent quantity against which the component quantity is calculated. If the material is offset by operation then this is the parent quantity at the start of that operation. If the material is offset by days then this is the net parent quantity.It is important to note that if the component is defined as a fixed quantity per and has the parent quantity defined then the total quantity is always based on the Net quantity for the parent.Total quantity required based on the parent quantity. Total times required for the parent start quantity.Total costs (what if or BOM) are optionally returned based on the quantity required.Structure Narrations are optionally returned.Custom form fields are optionally returned.
Properties
| Syspro Module | Bill of Materials |
| Class | Query |
| Methods | Query |
| Functional Area | Bill of Material Primary Query |
| Initial version released | Syspro 6.1 |
Input XML
The .XML and .XSD input files indicate the parameters schema and an instance of an XML document for this business object.
BOMQPS.XML
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2014 SYSPRO Ltd.-->
<!--
Sample XML for the BOM Progressive Scrap Query Business Object
-->
<Query xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="BOMQPS.XSD">
<Options>
<QuantityBasis>E</QuantityBasis>
<GrossOrNet>N</GrossOrNet>
<IncludeComponents>Y</IncludeComponents>
<IncludeOperations>Y</IncludeOperations>
<IncludeCustomForms>N</IncludeCustomForms>
<IncludeNarrations>N</IncludeNarrations>
<IncludeCoProduct>N</IncludeCoProduct>
<CostBasis>B</CostBasis>
<UseWhRoute>Y</UseWhRoute>
<UnitOfMeasure>S</UnitOfMeasure>
<XslStylesheet/>
</Options>
<Item>
<StockCode><![CDATA[B100]]></StockCode>
<Version/>
<Release/>
<Route>0</Route>
<Quantity>10.000</Quantity>
<Warehouse/>
</Item>
<Item>
<StockCode><![CDATA[B100]]></StockCode>
<Version/>
<Release/>
<Route>1</Route>
<Quantity>5.000</Quantity>
<Warehouse>FG</Warehouse>
</Item>
</Query>
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2014 SYSPRO Ltd.-->
<!--
Schema for BOM Progressive Scrap Query Business Object
-->
<xsd:schema elementFormDefault="qualified" attributeFormDefault="unqualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element name="Query">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Options" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This element contains options which will affect the way in which the query works as well as what is to be returned.</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:all>
<xsd:element name="QuantityBasis" default="M" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This indicates the quantity you wish to use as the base for the query calculations.
Select M if you wish to use the manufacturing quantity basis defined against the parent stock code (EBQ or Pan).
Select S if you wish to use a single unit (i.e. 1)
Select E if you wish to use the quantity entered against each stock code in the list.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="M"/>
<xsd:enumeration value="S"/>
<xsd:enumeration value="E"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="GrossOrNet" default="N" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This indicates whether the quantity to use is net or gross
Enter N to indicate Net (quantity to make)
Enter G to indicate Gross (quantity before progressive scrap is applied).
</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="N"/>
<xsd:enumeration value="G"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeComponents" default="N" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Do you wish to include information on the components attached (Y - Yes, N - No). The default is No.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeOperations" default="Y" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Do you wish to include information on operations attached (Y - Yes, N - No). The default is Yes.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeCustomForms" default="N" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Do you wish to include custom form fields attached to components or operations if they are included (Y - Yes, N - No). The default is No.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeNarrations" default="N" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Do you wish to include custom narrations attached to components or operations if they are included (Y - Yes, N - No). The default is No.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeCoProduct" default="N" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Do you wish to include Co-Product information. (Y - Yes, N - No). The default is No.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:pattern value="N"/>
<xsd:pattern value="Y"/>
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="CostBasis" default="N" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies your costing preference to calculate costs against components and operations if they are included (N - None, B - Bom, W - What-if,)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="N"/>
<xsd:enumeration value="B"/>
<xsd:enumeration value="W"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="XslStylesheet" minOccurs="0">
<xsd:annotation>
<xsd:documentation>The Stylesheet to be applied</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="UseWhRoute" default="N" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies whether or not to use the route (and component warehouse) defined against the warehouse control. (Y - Yes, N - No) The default is No</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="UnitOfMeasure" default="S">
<xsd:annotation>
<xsd:documentation>Select 'S' for stocking u/m, 'A' for alternate u/m, 'O' for other u/m or 'M' for manufacturing u/m. Quantities and times entered will be according to the unit of measure selected.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="S"/>
<xsd:enumeration value="A"/>
<xsd:enumeration value="O"/>
<xsd:enumeration value="M"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:all>
</xsd:complexType>
</xsd:element>
<xsd:element name="Item" maxOccurs="unbounded">
<xsd:annotation>
<xsd:documentation>This is the top element for each parent item being queried.</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:all>
<xsd:element name="StockCode">
<xsd:annotation>
<xsd:documentation>The parent stock code to use for the query</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Version" minOccurs="0">
<xsd:annotation>
<xsd:documentation>The ECC revision to use for the query. This is ignored if the item is not ECC controlled. If the parent stock code is ECC controlled and this is not submitted then the query will default to the current revision for the parent.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Release" minOccurs="0">
<xsd:annotation>
<xsd:documentation>The ECC release to use for the query. This is ignored if the item is not ECC controlled. If the parent stock code is ECC controlled and this is not submitted then the query will default to the current release for the parent.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Route" minOccurs="0">
<xsd:annotation>
<xsd:documentation>The BOM route to use for the query. This is ignored if alternate routes are not in use. If not submitted then this will default to route 0.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Quantity" minOccurs="0">
<xsd:annotation>
<xsd:documentation>If quantity basis in options is set to entered quantity (E) then this is the quantity that will be used when processing.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Warehouse" minOccurs="0">
<xsd:annotation>
<xsd:documentation>The warehouse to use for the query. If you have the option 'UseWhRoute' set to 'Y' then the object will pick up the route (and component warehouse) defined against this warehouse. It is important to note that the parent stock code must be defined against this warehouse. If it is left as spaces then the parent stock code's warehouse to use will be applied.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:all>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
Output XML
The OUT.XML indicates a sample of the XML returned by this business object.
BOMQPSOUT.XML
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2014 SYSPRO Ltd.-->
<!--
Sample XML for the BOM Progressive Scrap Query Business Object
-->
<BomScrapQuery xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="BOMQPSOUT.XSD">
<Items>
<Item>
<StockCode>B100</StockCode>
<Description>Bicycle</Description>
<LongDesc>Parent</LongDesc>
<PartCategory>M</PartCategory>
<StockUom>EA</StockUom>
<AlternateUom>EA</AlternateUom>
<OtherUom>EA</OtherUom>
<Mass>1.000000</Mass>
<Volume>0.000000</Volume>
<Supplier/>
<ProductClass>FGC</ProductClass>
<Buyer/>
<Planner>AB</Planner>
<WarehouseToUse>FG</WarehouseToUse>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EbqPan>E</EbqPan>
<Version/>
<Release/>
<Route>0</Route>
<RouteDescription>Factory Main Routing</RouteDescription>
<GrossQuantity>14.000</GrossQuantity>
<NetQuantity>10.000</NetQuantity>
<Operations>
<Operation>
<OperationNo>1</OperationNo>
<WorkCentre>GALV</WorkCentre>
<Description>Galvanizing/Plating</Description>
<Milestone>Y</Milestone>
<TimeCalcFlag>Y</TimeCalcFlag>
<SubLeadTime>1</SubLeadTime>
<SubDockToStock>1</SubDockToStock>
<SubOffsiteDays>1</SubOffsiteDays>
<ElapsedTime>2</ElapsedTime>
<MovementTime>0</MovementTime>
<OperYieldPct>20.00</OperYieldPct>
<OperYieldQty>0.000</OperYieldQty>
<GrossQuantity>14.000</GrossQuantity>
<NetQuantity>11.000</NetQuantity>
<TimeUom>hrs</TimeUom>
<WcRateInd>1</WcRateInd>
<WhatIfWcInd>1</WhatIfWcInd>
<SubcontractFlag>Y</SubcontractFlag>
<SubSupplier>0000018</SubSupplier>
<SubPoStockCode>Galvanise frame</SubPoStockCode>
<SubTotalQty>14.000000</SubTotalQty>
<SubOrderUom>EA</SubOrderUom>
<OpTotalCost>1246.00000</OpTotalCost>
</Operation>
<Operation>
<OperationNo>2</OperationNo>
<WorkCentre>PAINT</WorkCentre>
<Description>Spray Painting</Description>
<Milestone>Y</Milestone>
<TimeCalcFlag>Y</TimeCalcFlag>
<ElapsedTime>1</ElapsedTime>
<MovementTime>0</MovementTime>
<OperYieldPct>10.00</OperYieldPct>
<OperYieldQty>0.000</OperYieldQty>
<GrossQuantity>11.000</GrossQuantity>
<NetQuantity>10.000</NetQuantity>
<TimeUom>hrs</TimeUom>
<WcRateInd>1</WcRateInd>
<WhatIfWcInd>1</WhatIfWcInd>
<SubcontractFlag>N</SubcontractFlag>
<Machine/>
<ProdUnits>1.00</ProdUnits>
<MaxOperators>1.00</MaxOperators>
<SetUpTime>0.0000</SetUpTime>
<StartupTime>1.0000</StartupTime>
<StartupQuantity>1.000</StartupQuantity>
<RunTime>10.0000</RunTime>
<TeardownTime>0.0000</TeardownTime>
<TotalTime>11.0000</TotalTime>
<WaitTime>0.0000</WaitTime>
<OpSetupCost>0.00000</OpSetupCost>
<OpStartupCost>6.00000</OpStartupCost>
<OpRuntimeCost>150.00000</OpRuntimeCost>
<OpTeardownCost>0.00000</OpTeardownCost>
<OpFixedOverhead>330.00000</OpFixedOverhead>
<OpVariableOverhead>132.00000</OpVariableOverhead>
<OpTotalCost>618.00000</OpTotalCost>
</Operation>
<Operation>
<OperationNo>3</OperationNo>
<WorkCentre>MBFA</WorkCentre>
<Description>Bicycle Assembly</Description>
<Milestone>Y</Milestone>
<TimeCalcFlag>Y</TimeCalcFlag>
<ElapsedTime>1</ElapsedTime>
<MovementTime>0</MovementTime>
<OperYieldPct>0.00</OperYieldPct>
<OperYieldQty>0.000</OperYieldQty>
<GrossQuantity>10.000</GrossQuantity>
<NetQuantity>10.000</NetQuantity>
<TimeUom>hrs</TimeUom>
<WcRateInd>1</WcRateInd>
<WhatIfWcInd>1</WhatIfWcInd>
<SubcontractFlag>N</SubcontractFlag>
<Machine/>
<ProdUnits>1.00</ProdUnits>
<MaxOperators>1.00</MaxOperators>
<SetUpTime>0.2500</SetUpTime>
<StartupTime>0.0000</StartupTime>
<StartupQuantity>0.000</StartupQuantity>
<RunTime>10.0000</RunTime>
<TeardownTime>0.0000</TeardownTime>
<TotalTime>10.2500</TotalTime>
<WaitTime>0.0000</WaitTime>
<OpSetupCost>5.00000</OpSetupCost>
<OpStartupCost>0.00000</OpStartupCost>
<OpRuntimeCost>150.00000</OpRuntimeCost>
<OpTeardownCost>0.00000</OpTeardownCost>
<OpFixedOverhead>307.50000</OpFixedOverhead>
<OpVariableOverhead>123.00000</OpVariableOverhead>
<OpTotalCost>585.50000</OpTotalCost>
</Operation>
<Operation>
<OperationNo>4</OperationNo>
<WorkCentre>MBQA</WorkCentre>
<Description>Quality and Inspection</Description>
<Milestone>Y</Milestone>
<TimeCalcFlag>Y</TimeCalcFlag>
<ElapsedTime>1</ElapsedTime>
<MovementTime>0</MovementTime>
<OperYieldPct>0.00</OperYieldPct>
<OperYieldQty>0.000</OperYieldQty>
<GrossQuantity>10.000</GrossQuantity>
<NetQuantity>10.000</NetQuantity>
<TimeUom>hrs</TimeUom>
<WcRateInd>1</WcRateInd>
<WhatIfWcInd>1</WhatIfWcInd>
<SubcontractFlag>N</SubcontractFlag>
<Machine/>
<ProdUnits>1.00</ProdUnits>
<MaxOperators>1.00</MaxOperators>
<SetUpTime>0.0000</SetUpTime>
<StartupTime>0.0000</StartupTime>
<StartupQuantity>0.000</StartupQuantity>
<RunTime>20.0000</RunTime>
<TeardownTime>0.0000</TeardownTime>
<TotalTime>20.0000</TotalTime>
<WaitTime>0.0000</WaitTime>
<OpSetupCost>0.00000</OpSetupCost>
<OpStartupCost>0.00000</OpStartupCost>
<OpRuntimeCost>300.00000</OpRuntimeCost>
<OpTeardownCost>0.00000</OpTeardownCost>
<OpFixedOverhead>600.00000</OpFixedOverhead>
<OpVariableOverhead>240.00000</OpVariableOverhead>
<OpTotalCost>1140.00000</OpTotalCost>
</Operation>
<Operation>
<OperationNo>5</OperationNo>
<WorkCentre>MBCC</WorkCentre>
<Description>Bicycle Cleaning Center</Description>
<Milestone>Y</Milestone>
<TimeCalcFlag>Y</TimeCalcFlag>
<ElapsedTime>1</ElapsedTime>
<MovementTime>0</MovementTime>
<OperYieldPct>0.00</OperYieldPct>
<OperYieldQty>0.000</OperYieldQty>
<GrossQuantity>10.000</GrossQuantity>
<NetQuantity>10.000</NetQuantity>
<TimeUom>hrs</TimeUom>
<WcRateInd>1</WcRateInd>
<WhatIfWcInd>1</WhatIfWcInd>
<SubcontractFlag>N</SubcontractFlag>
<Machine/>
<ProdUnits>1.00</ProdUnits>
<MaxOperators>1.00</MaxOperators>
<SetUpTime>0.2500</SetUpTime>
<StartupTime>0.0000</StartupTime>
<StartupQuantity>0.000</StartupQuantity>
<RunTime>2.5000</RunTime>
<TeardownTime>0.0000</TeardownTime>
<TotalTime>2.7500</TotalTime>
<WaitTime>0.0000</WaitTime>
<OpSetupCost>5.00000</OpSetupCost>
<OpStartupCost>0.00000</OpStartupCost>
<OpRuntimeCost>37.50000</OpRuntimeCost>
<OpTeardownCost>0.00000</OpTeardownCost>
<OpFixedOverhead>82.50000</OpFixedOverhead>
<OpVariableOverhead>33.00000</OpVariableOverhead>
<OpTotalCost>158.00000</OpTotalCost>
</Operation>
</Operations>
<Components>
<Component>
<ComStockCode>B111</ComStockCode>
<Description>Diamond Frame</Description>
<LongDesc>Sub Assembly</LongDesc>
<PartCategory>M</PartCategory>
<StockUom/>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EccConsumption/>
<ComVersion/>
<ComRelease/>
<SequenceNum>00</SequenceNum>
<StructureOnDate/>
<StructureOffDate/>
<IncludeFromJob/>
<IncludeToJob/>
<OpOffsetFlag>O</OpOffsetFlag>
<OperationOffset>1</OperationOffset>
<QtyPer>1.000000</QtyPer>
<ScrapPercentage>2.00</ScrapPercentage>
<ScrapQuantity>0.000</ScrapQuantity>
<FixedQtyPerFlag>N</FixedQtyPerFlag>
<FixedQtyPer>0.000</FixedQtyPer>
<ParentQuantity>14.000</ParentQuantity>
<TotalQtyReqd>14.280</TotalQtyReqd>
<ComMaterial>7775.46000</ComMaterial>
<ComSubContractCost>0.00000</ComSubContractCost>
<ComLabour>664.02000</ComLabour>
<ComFixedOverHead>1135.26000</ComFixedOverHead>
<ComVariableOverHead>1135.26000</ComVariableOverHead>
<ComTotalCost>10710.00000</ComTotalCost>
</Component>
<Component>
<ComStockCode>B112</ComStockCode>
<Description>Drive Train Assembly</Description>
<LongDesc>Component</LongDesc>
<PartCategory>B</PartCategory>
<StockUom/>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EccConsumption/>
<ComVersion/>
<ComRelease/>
<SequenceNum>00</SequenceNum>
<StructureOnDate/>
<StructureOffDate/>
<IncludeFromJob/>
<IncludeToJob/>
<OpOffsetFlag>O</OpOffsetFlag>
<OperationOffset>3</OperationOffset>
<QtyPer>1.000000</QtyPer>
<ScrapPercentage>2.00</ScrapPercentage>
<ScrapQuantity>0.000</ScrapQuantity>
<FixedQtyPerFlag>N</FixedQtyPerFlag>
<FixedQtyPer>0.000</FixedQtyPer>
<ParentQuantity>10.000</ParentQuantity>
<TotalQtyReqd>10.200</TotalQtyReqd>
<ComMaterial>51.00000</ComMaterial>
<ComSubContractCost>0.00000</ComSubContractCost>
<ComLabour>0.00000</ComLabour>
<ComFixedOverHead>0.00000</ComFixedOverHead>
<ComVariableOverHead>0.00000</ComVariableOverHead>
<ComTotalCost>51.00000</ComTotalCost>
</Component>
<Component>
<ComStockCode>B113</ComStockCode>
<Description>Handle Bar Assembly</Description>
<LongDesc>Sub Assembly</LongDesc>
<PartCategory>M</PartCategory>
<StockUom/>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EccConsumption/>
<ComVersion/>
<ComRelease/>
<SequenceNum>00</SequenceNum>
<StructureOnDate/>
<StructureOffDate/>
<IncludeFromJob/>
<IncludeToJob/>
<OpOffsetFlag>O</OpOffsetFlag>
<OperationOffset>3</OperationOffset>
<QtyPer>1.000000</QtyPer>
<ScrapPercentage>0.00</ScrapPercentage>
<ScrapQuantity>0.000</ScrapQuantity>
<FixedQtyPerFlag/>
<FixedQtyPer>0.000</FixedQtyPer>
<ParentQuantity>10.000</ParentQuantity>
<TotalQtyReqd>10.000</TotalQtyReqd>
<ComMaterial>6210.40000</ComMaterial>
<ComSubContractCost>0.00000</ComSubContractCost>
<ComLabour>232.50000</ComLabour>
<ComFixedOverHead>465.00000</ComFixedOverHead>
<ComVariableOverHead>465.00000</ComVariableOverHead>
<ComTotalCost>7372.90000</ComTotalCost>
</Component>
<Component>
<ComStockCode>B114</ComStockCode>
<Description>Radially Spoked Front Wheel</Description>
<LongDesc>Sub Assembly</LongDesc>
<PartCategory>M</PartCategory>
<StockUom/>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EccConsumption/>
<ComVersion/>
<ComRelease/>
<SequenceNum>00</SequenceNum>
<StructureOnDate/>
<StructureOffDate/>
<IncludeFromJob/>
<IncludeToJob/>
<OpOffsetFlag>O</OpOffsetFlag>
<OperationOffset>3</OperationOffset>
<QtyPer>1.000000</QtyPer>
<ScrapPercentage>0.00</ScrapPercentage>
<ScrapQuantity>0.000</ScrapQuantity>
<FixedQtyPerFlag/>
<FixedQtyPer>0.000</FixedQtyPer>
<ParentQuantity>10.000</ParentQuantity>
<TotalQtyReqd>10.000</TotalQtyReqd>
<ComMaterial>6305.00000</ComMaterial>
<ComSubContractCost>0.00000</ComSubContractCost>
<ComLabour>187.50000</ComLabour>
<ComFixedOverHead>435.00000</ComFixedOverHead>
<ComVariableOverHead>435.00000</ComVariableOverHead>
<ComTotalCost>7362.50000</ComTotalCost>
</Component>
<Component>
<ComStockCode>B115</ComStockCode>
<Description>Radially Spoked Rear Wheel</Description>
<LongDesc>Sub Assembly</LongDesc>
<PartCategory>M</PartCategory>
<StockUom/>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EccConsumption/>
<ComVersion/>
<ComRelease/>
<SequenceNum>00</SequenceNum>
<StructureOnDate/>
<StructureOffDate/>
<IncludeFromJob/>
<IncludeToJob/>
<OpOffsetFlag>O</OpOffsetFlag>
<OperationOffset>3</OperationOffset>
<QtyPer>1.000000</QtyPer>
<ScrapPercentage>0.00</ScrapPercentage>
<ScrapQuantity>0.000</ScrapQuantity>
<FixedQtyPerFlag/>
<FixedQtyPer>0.000</FixedQtyPer>
<ParentQuantity>10.000</ParentQuantity>
<TotalQtyReqd>10.000</TotalQtyReqd>
<ComMaterial>6155.00000</ComMaterial>
<ComSubContractCost>0.00000</ComSubContractCost>
<ComLabour>187.50000</ComLabour>
<ComFixedOverHead>435.00000</ComFixedOverHead>
<ComVariableOverHead>435.00000</ComVariableOverHead>
<ComTotalCost>7212.50000</ComTotalCost>
</Component>
<Component>
<ComStockCode>LOT1203</ComStockCode>
<Description>Racing Frame Paint - Pewter</Description>
<LongDesc>Component - Lot Traceable</LongDesc>
<PartCategory>B</PartCategory>
<StockUom/>
<Ebq>25.000</Ebq>
<PanSize>0.000</PanSize>
<EccConsumption/>
<ComVersion/>
<ComRelease/>
<SequenceNum>000000</SequenceNum>
<StructureOnDate/>
<StructureOffDate/>
<IncludeFromJob/>
<IncludeToJob/>
<OpOffsetFlag>O</OpOffsetFlag>
<OperationOffset>2</OperationOffset>
<QtyPer>10.000000</QtyPer>
<ScrapPercentage>0.00</ScrapPercentage>
<ScrapQuantity>0.000</ScrapQuantity>
<FixedQtyPerFlag>Y</FixedQtyPerFlag>
<FixedQtyPer>10.000</FixedQtyPer>
<ParentQuantity>10.000</ParentQuantity>
<TotalQtyReqd>10.000</TotalQtyReqd>
<ComMaterial>500.00000</ComMaterial>
<ComSubContractCost>0.00000</ComSubContractCost>
<ComLabour>0.00000</ComLabour>
<ComFixedOverHead>0.00000</ComFixedOverHead>
<ComVariableOverHead>0.00000</ComVariableOverHead>
<ComTotalCost>500.00000</ComTotalCost>
</Component>
</Components>
</Item>
<Item>
<StockCode>B100</StockCode>
<Description>Bicycle</Description>
<LongDesc>Parent</LongDesc>
<PartCategory>M</PartCategory>
<StockUom>EA</StockUom>
<AlternateUom>EA</AlternateUom>
<OtherUom>EA</OtherUom>
<Mass>1.000000</Mass>
<Volume>0.000000</Volume>
<Supplier/>
<ProductClass>FGC</ProductClass>
<Buyer/>
<Planner>AB</Planner>
<WarehouseToUse>FG</WarehouseToUse>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EbqPan>E</EbqPan>
<Version/>
<Release/>
<Route>1</Route>
<RouteDescription>Factory Secondary Routing</RouteDescription>
<GrossQuantity>5.000</GrossQuantity>
<NetQuantity>5.000</NetQuantity>
<Operations>
<Operation>
<OperationNo>1</OperationNo>
<WorkCentre>MBFA</WorkCentre>
<Description>Bicycle Assembly</Description>
<Milestone>Y</Milestone>
<TimeCalcFlag>Y</TimeCalcFlag>
<ElapsedTime>1</ElapsedTime>
<MovementTime>0</MovementTime>
<OperYieldPct>0.00</OperYieldPct>
<OperYieldQty>0.000</OperYieldQty>
<GrossQuantity>5.000</GrossQuantity>
<NetQuantity>5.000</NetQuantity>
<TimeUom>hrs</TimeUom>
<WcRateInd>1</WcRateInd>
<WhatIfWcInd>1</WhatIfWcInd>
<SubcontractFlag>N</SubcontractFlag>
<Machine/>
<ProdUnits>1.00</ProdUnits>
<MaxOperators>1.00</MaxOperators>
<SetUpTime>0.2500</SetUpTime>
<StartupTime>0.0000</StartupTime>
<StartupQuantity>0.000</StartupQuantity>
<RunTime>5.0000</RunTime>
<TeardownTime>0.0000</TeardownTime>
<TotalTime>5.2500</TotalTime>
<WaitTime>0.0000</WaitTime>
<OpSetupCost>5.00000</OpSetupCost>
<OpStartupCost>0.00000</OpStartupCost>
<OpRuntimeCost>75.00000</OpRuntimeCost>
<OpTeardownCost>0.00000</OpTeardownCost>
<OpFixedOverhead>157.50000</OpFixedOverhead>
<OpVariableOverhead>63.00000</OpVariableOverhead>
<OpTotalCost>300.50000</OpTotalCost>
</Operation>
<Operation>
<OperationNo>2</OperationNo>
<WorkCentre>MBQA</WorkCentre>
<Description>Quality and Inspection</Description>
<Milestone>Y</Milestone>
<TimeCalcFlag>Y</TimeCalcFlag>
<ElapsedTime>1</ElapsedTime>
<MovementTime>0</MovementTime>
<OperYieldPct>0.00</OperYieldPct>
<OperYieldQty>0.000</OperYieldQty>
<GrossQuantity>5.000</GrossQuantity>
<NetQuantity>5.000</NetQuantity>
<TimeUom>hrs</TimeUom>
<WcRateInd>1</WcRateInd>
<WhatIfWcInd>1</WhatIfWcInd>
<SubcontractFlag>N</SubcontractFlag>
<Machine/>
<ProdUnits>1.00</ProdUnits>
<MaxOperators>1.00</MaxOperators>
<SetUpTime>0.0000</SetUpTime>
<StartupTime>0.0000</StartupTime>
<StartupQuantity>0.000</StartupQuantity>
<RunTime>10.0000</RunTime>
<TeardownTime>0.0000</TeardownTime>
<TotalTime>10.0000</TotalTime>
<WaitTime>0.0000</WaitTime>
<OpSetupCost>0.00000</OpSetupCost>
<OpStartupCost>0.00000</OpStartupCost>
<OpRuntimeCost>150.00000</OpRuntimeCost>
<OpTeardownCost>0.00000</OpTeardownCost>
<OpFixedOverhead>300.00000</OpFixedOverhead>
<OpVariableOverhead>120.00000</OpVariableOverhead>
<OpTotalCost>570.00000</OpTotalCost>
</Operation>
<Operation>
<OperationNo>3</OperationNo>
<WorkCentre>MBCC</WorkCentre>
<Description>Bicycle Cleaning Center</Description>
<Milestone>Y</Milestone>
<TimeCalcFlag>Y</TimeCalcFlag>
<ElapsedTime>1</ElapsedTime>
<MovementTime>0</MovementTime>
<OperYieldPct>0.00</OperYieldPct>
<OperYieldQty>0.000</OperYieldQty>
<GrossQuantity>5.000</GrossQuantity>
<NetQuantity>5.000</NetQuantity>
<TimeUom>hrs</TimeUom>
<WcRateInd>1</WcRateInd>
<WhatIfWcInd>1</WhatIfWcInd>
<SubcontractFlag>N</SubcontractFlag>
<Machine/>
<ProdUnits>1.00</ProdUnits>
<MaxOperators>1.00</MaxOperators>
<SetUpTime>0.2500</SetUpTime>
<StartupTime>0.0000</StartupTime>
<StartupQuantity>0.000</StartupQuantity>
<RunTime>1.2500</RunTime>
<TeardownTime>0.0000</TeardownTime>
<TotalTime>1.5000</TotalTime>
<WaitTime>0.0000</WaitTime>
<OpSetupCost>5.00000</OpSetupCost>
<OpStartupCost>0.00000</OpStartupCost>
<OpRuntimeCost>18.75000</OpRuntimeCost>
<OpTeardownCost>0.00000</OpTeardownCost>
<OpFixedOverhead>45.00000</OpFixedOverhead>
<OpVariableOverhead>18.00000</OpVariableOverhead>
<OpTotalCost>86.75000</OpTotalCost>
</Operation>
<Operation>
<OperationNo>4</OperationNo>
<WorkCentre>GALV</WorkCentre>
<Description>Galvanizing/Plating</Description>
<Milestone>Y</Milestone>
<TimeCalcFlag>Y</TimeCalcFlag>
<SubLeadTime>4</SubLeadTime>
<SubDockToStock>0</SubDockToStock>
<SubOffsiteDays>2</SubOffsiteDays>
<ElapsedTime>2</ElapsedTime>
<MovementTime>0</MovementTime>
<OperYieldPct>0.00</OperYieldPct>
<OperYieldQty>0.000</OperYieldQty>
<GrossQuantity>5.000</GrossQuantity>
<NetQuantity>5.000</NetQuantity>
<TimeUom>hrs</TimeUom>
<WcRateInd>1</WcRateInd>
<WhatIfWcInd>1</WhatIfWcInd>
<SubcontractFlag>Y</SubcontractFlag>
<SubSupplier>0000018</SubSupplier>
<SubPoStockCode>Galvanizing</SubPoStockCode>
<SubTotalQty>5.000000</SubTotalQty>
<SubOrderUom>LOT</SubOrderUom>
<OpTotalCost>15.00000</OpTotalCost>
</Operation>
</Operations>
<Components>
<Component>
<ComStockCode>B111</ComStockCode>
<Description>Diamond Frame</Description>
<LongDesc>Sub Assembly</LongDesc>
<PartCategory>M</PartCategory>
<StockUom/>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EccConsumption/>
<ComVersion/>
<ComRelease/>
<SequenceNum>00</SequenceNum>
<StructureOnDate/>
<StructureOffDate/>
<IncludeFromJob/>
<IncludeToJob/>
<OpOffsetFlag>O</OpOffsetFlag>
<OperationOffset>1</OperationOffset>
<QtyPer>1.000000</QtyPer>
<ScrapPercentage>0.00</ScrapPercentage>
<ScrapQuantity>0.000</ScrapQuantity>
<FixedQtyPerFlag/>
<FixedQtyPer>0.000</FixedQtyPer>
<ParentQuantity>5.000</ParentQuantity>
<TotalQtyReqd>5.000</TotalQtyReqd>
<ComMaterial>2722.50000</ComMaterial>
<ComSubContractCost>0.00000</ComSubContractCost>
<ComLabour>232.50000</ComLabour>
<ComFixedOverHead>397.50000</ComFixedOverHead>
<ComVariableOverHead>397.50000</ComVariableOverHead>
<ComTotalCost>3750.00000</ComTotalCost>
</Component>
<Component>
<ComStockCode>B112</ComStockCode>
<Description>Drive Train Assembly</Description>
<LongDesc>Component</LongDesc>
<PartCategory>B</PartCategory>
<StockUom/>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EccConsumption/>
<ComVersion/>
<ComRelease/>
<SequenceNum>00</SequenceNum>
<StructureOnDate/>
<StructureOffDate/>
<IncludeFromJob/>
<IncludeToJob/>
<OpOffsetFlag>O</OpOffsetFlag>
<OperationOffset>1</OperationOffset>
<QtyPer>1.000000</QtyPer>
<ScrapPercentage>0.00</ScrapPercentage>
<ScrapQuantity>0.000</ScrapQuantity>
<FixedQtyPerFlag/>
<FixedQtyPer>0.000</FixedQtyPer>
<ParentQuantity>5.000</ParentQuantity>
<TotalQtyReqd>5.000</TotalQtyReqd>
<ComMaterial>25.00000</ComMaterial>
<ComSubContractCost>0.00000</ComSubContractCost>
<ComLabour>0.00000</ComLabour>
<ComFixedOverHead>0.00000</ComFixedOverHead>
<ComVariableOverHead>0.00000</ComVariableOverHead>
<ComTotalCost>25.00000</ComTotalCost>
</Component>
<Component>
<ComStockCode>B113</ComStockCode>
<Description>Handle Bar Assembly</Description>
<LongDesc>Sub Assembly</LongDesc>
<PartCategory>M</PartCategory>
<StockUom/>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EccConsumption/>
<ComVersion/>
<ComRelease/>
<SequenceNum>00</SequenceNum>
<StructureOnDate/>
<StructureOffDate/>
<IncludeFromJob/>
<IncludeToJob/>
<OpOffsetFlag>O</OpOffsetFlag>
<OperationOffset>1</OperationOffset>
<QtyPer>1.000000</QtyPer>
<ScrapPercentage>0.00</ScrapPercentage>
<ScrapQuantity>0.000</ScrapQuantity>
<FixedQtyPerFlag/>
<FixedQtyPer>0.000</FixedQtyPer>
<ParentQuantity>5.000</ParentQuantity>
<TotalQtyReqd>5.000</TotalQtyReqd>
<ComMaterial>3105.20000</ComMaterial>
<ComSubContractCost>0.00000</ComSubContractCost>
<ComLabour>116.25000</ComLabour>
<ComFixedOverHead>232.50000</ComFixedOverHead>
<ComVariableOverHead>232.50000</ComVariableOverHead>
<ComTotalCost>3686.45000</ComTotalCost>
</Component>
<Component>
<ComStockCode>B114</ComStockCode>
<Description>Radially Spoked Front Wheel</Description>
<LongDesc>Sub Assembly</LongDesc>
<PartCategory>M</PartCategory>
<StockUom/>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EccConsumption/>
<ComVersion/>
<ComRelease/>
<SequenceNum>00</SequenceNum>
<StructureOnDate/>
<StructureOffDate/>
<IncludeFromJob/>
<IncludeToJob/>
<OpOffsetFlag>O</OpOffsetFlag>
<OperationOffset>1</OperationOffset>
<QtyPer>1.000000</QtyPer>
<ScrapPercentage>0.00</ScrapPercentage>
<ScrapQuantity>0.000</ScrapQuantity>
<FixedQtyPerFlag/>
<FixedQtyPer>0.000</FixedQtyPer>
<ParentQuantity>5.000</ParentQuantity>
<TotalQtyReqd>5.000</TotalQtyReqd>
<ComMaterial>3152.50000</ComMaterial>
<ComSubContractCost>0.00000</ComSubContractCost>
<ComLabour>93.75000</ComLabour>
<ComFixedOverHead>217.50000</ComFixedOverHead>
<ComVariableOverHead>217.50000</ComVariableOverHead>
<ComTotalCost>3681.25000</ComTotalCost>
</Component>
<Component>
<ComStockCode>B115</ComStockCode>
<Description>Radially Spoked Rear Wheel</Description>
<LongDesc>Sub Assembly</LongDesc>
<PartCategory>M</PartCategory>
<StockUom/>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EccConsumption/>
<ComVersion/>
<ComRelease/>
<SequenceNum>00</SequenceNum>
<StructureOnDate/>
<StructureOffDate/>
<IncludeFromJob/>
<IncludeToJob/>
<OpOffsetFlag>O</OpOffsetFlag>
<OperationOffset>1</OperationOffset>
<QtyPer>1.000000</QtyPer>
<ScrapPercentage>0.00</ScrapPercentage>
<ScrapQuantity>0.000</ScrapQuantity>
<FixedQtyPerFlag/>
<FixedQtyPer>0.000</FixedQtyPer>
<ParentQuantity>5.000</ParentQuantity>
<TotalQtyReqd>5.000</TotalQtyReqd>
<ComMaterial>3077.50000</ComMaterial>
<ComSubContractCost>0.00000</ComSubContractCost>
<ComLabour>93.75000</ComLabour>
<ComFixedOverHead>217.50000</ComFixedOverHead>
<ComVariableOverHead>217.50000</ComVariableOverHead>
<ComTotalCost>3606.25000</ComTotalCost>
</Component>
<Component>
<ComStockCode>A200</ComStockCode>
<Description>Bicycle Pump</Description>
<LongDesc>Distrib./Alt. Unit Meas/Alt Su</LongDesc>
<PartCategory>B</PartCategory>
<StockUom/>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EccConsumption/>
<ComVersion/>
<ComRelease/>
<SequenceNum>000000</SequenceNum>
<StructureOnDate/>
<StructureOffDate/>
<IncludeFromJob/>
<IncludeToJob/>
<OpOffsetFlag>O</OpOffsetFlag>
<OperationOffset>1</OperationOffset>
<QtyPer>1.000000</QtyPer>
<ScrapPercentage>0.00</ScrapPercentage>
<ScrapQuantity>0.000</ScrapQuantity>
<FixedQtyPerFlag/>
<FixedQtyPer>0.000</FixedQtyPer>
<ParentQuantity>5.000</ParentQuantity>
<TotalQtyReqd>5.000</TotalQtyReqd>
<ComMaterial>63.14900</ComMaterial>
<ComSubContractCost>0.00000</ComSubContractCost>
<ComLabour>0.00000</ComLabour>
<ComFixedOverHead>0.00000</ComFixedOverHead>
<ComVariableOverHead>0.00000</ComVariableOverHead>
<ComTotalCost>63.14900</ComTotalCost>
</Component>
<Component>
<ComStockCode>A201</ComStockCode>
<Description>Bicycle Chain and Lock</Description>
<LongDesc>Distrib. / Alternate Supplier</LongDesc>
<PartCategory>B</PartCategory>
<StockUom/>
<Ebq>1.000</Ebq>
<PanSize>0.000</PanSize>
<EccConsumption/>
<ComVersion/>
<ComRelease/>
<SequenceNum>000000</SequenceNum>
<StructureOnDate/>
<StructureOffDate/>
<IncludeFromJob/>
<IncludeToJob/>
<OpOffsetFlag>O</OpOffsetFlag>
<OperationOffset>1</OperationOffset>
<QtyPer>1.000000</QtyPer>
<ScrapPercentage>0.00</ScrapPercentage>
<ScrapQuantity>0.000</ScrapQuantity>
<FixedQtyPerFlag/>
<FixedQtyPer>0.000</FixedQtyPer>
<ParentQuantity>5.000</ParentQuantity>
<TotalQtyReqd>5.000</TotalQtyReqd>
<ComMaterial>13.03275</ComMaterial>
<ComSubContractCost>0.00000</ComSubContractCost>
<ComLabour>0.00000</ComLabour>
<ComFixedOverHead>0.00000</ComFixedOverHead>
<ComVariableOverHead>0.00000</ComVariableOverHead>
<ComTotalCost>13.03275</ComTotalCost>
</Component>
</Components>
</Item>
</Items>
<StatusOfItems>
<ItemsProcessed>2</ItemsProcessed>
<ItemsInvalid>0</ItemsInvalid>
</StatusOfItems>
</BomScrapQuery>
Prerequisites
No prerequisites are required to use this business object.
Limitations
No limitations apply to this business object.
Copyright © 2026 Syspro PTY Ltd.