Transformations worksheet
Lot Management
•
Article
•
7/2/2025
•
On the Transformations worksheet of the exported Excel document, you can view all production transactions, including input and output details, in the following fields:
| Field | Description |
|---|---|
| Lot Code of Input | Specifies the lot number associated with the input item. |
| Traceability Lot Code of Input | Specifies the vendor lot number associated with the input item. |
| Product Description of Input | Specifies the product description of the input item. |
| Item Category Description of Input | Specifies the item category description of the input item. |
| Quantity of Input | Specifies the quantity of the input item consumed. |
| Unit of Measure of Input | Specifies the unit used to measure the input item. |
| Lot Code of Output | Specifies the lot number associated with the output item. |
| New Traceability Lot Code | Specifies the vendor lot number associated with the output item. |
| Product Description of Output | Specifies the product description of the output item. |
| Item Category Description of Output | Specifies the item category description of the output item. |
| Quantity of Output | Specifies the quantity of the output item produced. |
| Unit of Measure of Output | Specifies the unit used to measure the output item. |
| Transformation Source Location Name | Specifies the location associated with the production order. |
| Transformation Source Phone No. | Specifies the phone number associated with the location. |
| Transformation Source Address | Specifies the address associated with the location. |
| Transformation Source City | Specifies the city associated with the location. |
| Transformation Source County/State/Region | Specifies the county, state, or region associated with the location. |
| Transformation Source Zip/Postal | Specifies the zip or postal code associated with the location. |
| Transformation Source Country | Specifies the country associated with the location. |
| Transformation Date | Specifies the posting date of the output item derived from the item ledger entries. |
| Traceability Source Reference | Specifies the traceability information of the source, such as an address, URL, GLN, or phone number associated with the output item. |
| Reference Document Type | Specifies the type of document the data is derived from. |
| Reference Document No. | Specifies the number of the document the data is derived from. |