Spreadsheet: 853342d1703216088-how-to-detect-duplicates-using-a-formula-test
Sheet:  Decommissioning Request Form

To Be Completed by Requestor | Decommissioning Product | Enter Product Details | Description
 | Supply Site / Market Warehouse / LOC | A | Enter the site / warehouse / LOC raising the request.
 | GTIN Market | USA | Choose the GTIN Lead Market from the dropdown list.
 | Batch / Lot Number | EG3T | Enter the batch/lot number (only one batch per DRF) .
 | GTIN (Global Trade Item Number) | 09876545678909 | Enter the 14 digit GTIN. Prefix ' if GTIN starts with a zero (0).
 | Trade Item Description | A | Enter the Global Material Master (GMM) description.
 | SKU / Material Number | 60000000129419 | Enter the Global Material Master (GMM) code.
 | Case GTIN (for US Market Only) | 25054290000931 | Enter the 14 digit Case GTIN. If not applicable, enter as N/A.
 | Types of Decommissioning | Choose Type of Decommissioning | Description
 | [NAME] with Rework | Partial Batch Decommissioning | Fully decommissioned with the potential to rework (Batch ID can be used again).
 | [NAME] without Rework |  | Fully decommissioned without the possibility of rework (Batch ID is made inactive and cannot be used again).
 | Partial Batch Decommissioning |  | Choose the higher level of hierarchy that is required (child objects will be decommissioned when parent is decommissioned). For PODA that will always be [NAME] (SGTIN) level due to there being no aggregation to higher levels.
 |  | Click here or scroll down for further entries
 | Levels of Decommissioning | Choose Level of Decommissioning | Description
 | SGTIN Level | SGTIN + Cases + Pallets | Only SGTINs will be decommissioned.
 | Case Level |  | Cases and all its respective SGTINs will be decommissioned.
 | Pallet Level |  | Pallets and all its respective Cases/SGTINs will be decommissioned.
 | Cases + Pallets |  | To be selected if some of the given cases are not the child objects of the given pallets. All the child objects of Cases/Pallets will be decommissioned.
 | SGTIN + Cases |  | To be selected if some of the given SGTINs are not the child objects of the given cases. All the SGTINs and all child objects of Cases will be decommissioned.
 | SGTIN + Pallets |  | To be selected if some of the given SGTINs are not the child objects of the given pallets. All the SGTINs and all child objects of Pallets will be decommissioned.
 | SGTIN + Cases + Pallets |  | To be selected if the some of the given SGTINs, Cases are not child objects of the given pallets. All SGTINs and all child objects of Cases/Pallets will be decommissioned.
 | Enter SGTIN Quantity | Enter Case Quantity | Enter Pallet Quantity
 | 1 | 1 | 1
 | Note
 | Decommissioning Reason Codes | Choose Reason Code for Decommissioning | Description
 | FREE SAMPLE | DESTROYED | Free samples that are sent to health care practitioners or other similar qualified persons.
 | SAMPLE |  | Samples provided to the National competent authorities.
 | DESTROYED |  | Serialised packs to be destroyed, rejected or serialised packs that are repacked and supplied with a new serial number.
 | SUPPLIED |  | Serialised packs to be supplied to article 23 customers.
 | EXPORTED |  | Serialised packs to be  exported to non-FMD countries.
 | OTHERS |  | Only to be used for decommissioning for RUSSIA market.
 | [NAME] |  | This is to be performed and applied to the full batch. Note: [NAME] which have their status changed to Locked CANNOT be reverted, they can only be progressed to Recall.
 | RECALL |  | This is to be performed and applied to the full batch.  Note: The status ‘Recalled’ must only be assigned for batches that have been recalled from the market (externally) after approval from the respective market Health Authority and recall activities have commenced. This status cannot be reversed.
 | Decommissioning Comments (if any) | N/A | Enter comments relevant to decommissioning such as why decommissioning is being performed. This field is optional and to be entered as N/A if there are no comments.
 | Data Provider | Enter Details | Description of Role
 | MUDID | A | The Data Provider is providing the data to decommission the batch / serial numbers in the batch provided in this form.
 | Name | A
 | Quality Approver | Enter Details | Description of Role
 | MUDID | A | The Quality Approver is confirming the data provided in this request to decommission the batch /  serial numbers is correct.  The Quality Approver must be a representative from either a Quality or Regulatory function.
 | Name | A
 | SUMMARY
 | DRF Completion Status  (For details, refer row 20 in Instructions sheet)
To Be Completed by Requestor | Quantity Verification: (For details, refer row 23 in Instructions sheet)
 | Quantity of Serial Number/SGTINs Entered | Quantity of Cases Entered | Quantity of Pallets Entered
 | Enter Serial numbers / SGTINs to be decommissioned | Enter Case numbers (SGTINs / SSCCs) to be decommissioned | Enter [NAME] numbers (SSCCs) to be decommissioned
 | 1 | 1 | 1