### Site Tools

implementation:manufacturing:import_productionorder

# Differences

This shows you the differences between two versions of the page.

 implementation:manufacturing:import_productionorder [2018/02/02 11:56]csuhaa created implementation:manufacturing:import_productionorder [2018/03/12 11:03] (current)csuhaa 18.1 2018/03/12 11:03 csuhaa 18.12018/02/02 11:56 csuhaa created 2018/03/12 11:03 csuhaa 18.12018/02/02 11:56 csuhaa created Line 23: Line 23: |7|Sales Order| |Text|Add the DocEntry of the sales order.| |7|Sales Order| |Text|Add the DocEntry of the sales order.| |8|Customer| |Text|Must be an existing customer.| |8|Customer| |Text|Must be an existing customer.| - |9|Distribution Rule| |Text|Must be a valid identifier of a distribution rule.| + |9|Distribution Rule 1| |Text|The Distribution rule for Dimension 1. Must be a valid identifier of a distribution rule.| - |10|Project| |Text|Must be a valid identifier of a project.| + |10|Distribution Rule 2| |Text|The Distribution rule for Dimension 2. Must be a valid identifier of a distribution rule.| - |11|Allocation Strategy|✔|Integer between 0 and 3|0 - \\ 1 - Back from due date \\ 2 -  Forward from earliest date \\ 3 - Forward from preferred date| + |11|Distribution Rule 3| |Text|The Distribution rule for Dimension 3. Must be a valid identifier of a distribution rule.| - |12|Due Time| |Date|Format:​ hh:mm| + |12|Distribution Rule 4| |Text|The Distribution rule for Dimension 4. Must be a valid identifier of a distribution rule.| - |13|Milestone Type| |Integer between 0 and 4|0 - \\ 1 - Milestone \\ 2 - Depends On Begin \\ 3 - Depends On Every \\ 4 - Depends On End| + |13|Distribution Rule 5| |Text|The Distribution rule for Dimension 5. Must be a valid identifier of a distribution rule.| - |14|Operation Granularity| |Number| | + |14|Project| |Text|Must be a valid identifier of a project.| - |15|Rejected warehouse|✔|Text|Must be a valid code of a warehouse.| + |15|Allocation Strategy|✔|Integer between 0 and 3|0 - \\ 1 - Back from due date \\ 2 -  Forward from earliest date \\ 3 - Forward from preferred date| - |16|Is Auto Roll|✔|N/​Y|N - No \\ Y - Yes| + |16|Due Time| |Date|Format:​ hh:mm| - |17|Force Reallocation|✔|N/​Y|N - No \\ Y - Yes| + |17|Milestone Type| |Integer between 0 and 4|0 - \\ 1 - Milestone \\ 2 - Depends On Begin \\ 3 - Depends On Every \\ 4 - Depends On End| - |18|Custom Code| |Text| | + |18|Operation Granularity| |Number| | + |19|Rejected warehouse|✔|Text|Must be a valid code of a warehouse.| + |20|Is Auto Roll|✔|N/​Y|N - No \\ Y - Yes| + |21|Force Reallocation|✔|N/​Y|N - No \\ Y - Yes| + |22|Custom Code| |Text| | - If there is a value beyond ​18th column, the row is invalid. A format error message is generated, and the production order is not processed. + If there is a value beyond ​22th column, the row is invalid. A format error message is generated, and the production order is not processed. ====Item row type==== ====Item row type==== Line 45: Line 49: |4|Quantity|✔|Number|This value will be saved as the Base quantity. The Planned quantity will be calculated based on the Base quantity and the Quantity on the header. ​ \\ Only mandatory for Material rows.| |4|Quantity|✔|Number|This value will be saved as the Base quantity. The Planned quantity will be calculated based on the Base quantity and the Quantity on the header. ​ \\ Only mandatory for Material rows.| |5|Warehouse| |Text|Must be a valid code of a warehouse.| |5|Warehouse| |Text|Must be a valid code of a warehouse.| - |6|Distribution Rule| |TextvMust ​be a valid identifier of a distribution rule.| + |6|Distribution Rule 1| |Text|The Distribution rule for Dimension 1. Must be a valid identifier of a distribution rule.| - |7|WIP Account| |Text|The internal reference of a WIP Account. The internal reference code can be found in the OACT.ACCTCODE field.| + |7|Distribution Rule 2| |Text|The Distribution rule for Dimension 2. Must be a valid identifier of a distribution rule.| - |8|Consignation Size| |Number| | + |8|Distribution Rule 3| |Text|The Distribution rule for Dimension 3. Must be a valid identifier of a distribution rule.| - |9|Drawing Position Number| |Integer| | + |9|Distribution Rule 4| |Text|The Distribution rule for Dimension 4. Must be a valid identifier of a distribution rule.| - |10|Due Date| |Date|Format:​ YYYYMMDD. If left empty, the due date will be the current date.| + |10|Distribution Rule 5| |Text|The Distribution rule for Dimension 5. Must be a valid identifier of a distribution rule.| - |11|Due Time| |Date|Format:​ hh:mm| + |11|WIP Account| |Text|The internal reference of a WIP Account. The internal reference code can be found in the OACT.ACCTCODE field.| - |12|Manual Planning|✔|Y/​N|N - No \\ Y - Yes| + |12|Consignation Size| |Number| | - |13|Issue Method|✔|B/​M |M - Manual \\ B - Backflush \\ Mandatory for materials only. If left empty for other row sub-types, the value wiil be '​B'​.| + |13|Drawing Position Number| |Integer| | - |14|Milestone Type| |Integer between 0 and 4|0 - \\ 1 - Milestone \\ 2 - Depends On Begin \\ 3 - Depends On Every \\ 4 - Depends On End \\ If left empty, the value will be '​0'​. | + |14|Due Date| |Date|Format:​ YYYYMMDD. If left empty, the due date will be the current date.| - |15|Profit Center| |Text| | + |15|Due Time| |Date|Format:​ hh:mm| - |16|Rejected Warehouse| |Text|Must be a valid code of a warehouse.| + |16|Manual Planning|✔|Y/​N|N - No \\ Y - Yes| - |17|Comment| |Text| | + |17|Issue Method|✔|B/​M |M - Manual \\ B - Backflush \\ Mandatory for materials only. If left empty for other row sub-types, the value wiil be '​B'​.| + |18|Milestone Type| |Integer between 0 and 4|0 - \\ 1 - Milestone \\ 2 - Depends On Begin \\ 3 - Depends On Every \\ 4 - Depends On End \\ If left empty, the value will be '​0'​. | + |19|Profit Center| |Text| | + |20|Rejected Warehouse| |Text|Must be a valid code of a warehouse.| + |21|Comment| |Text| | - If the sub-type of the row is not operation, and there is a value beyond ​17th column, the row is invalid. A format error message is generated, and the production order is not processed. + If the sub-type of the row is not operation, and there is a value beyond ​21th column, the row is invalid. A format error message is generated, and the production order is not processed. ===Operation row sub-type=== ===Operation row sub-type=== Line 64: Line 72: ^No.^Name^Mandatory^Possible types/​values^Description^ ^No.^Name^Mandatory^Possible types/​values^Description^ - |18|Before Time| |Number|The importer converts it to a base time using the Operation Time UoM from actual row.| + |22|Before Time| |Number|The importer converts it to a base time using the Operation Time UoM from actual row.| - |19|Safety Time| |Number|:::​| + |23|Safety Time| |Number|:::​| - |20|Setup Time| |Number|:::​| + |24|Setup Time| |Number|:::​| - |21|Job Time|✔|Number|:::​| + |25|Job Time|✔|Number|:::​| - |22|Teardown Time| |Number|:::​| + |26|Teardown Time| |Number|:::​| - |23|After Time| |Number|:::​| + |27|After Time| |Number|:::​| - |24|Time Base| |Number| | + |28|Time Base| |Number| | - |25|Operation Break| |Integer between 0 and 5|0 - \\ 3 - Allowed \\ 1 - Denied \\ 2 - Allowed WC \\ 4 - Allowed NBP \\ 5 - Allowed WCNBP \\ If left empty, the value will be '​3'​.| + |29|Operation Break| |Integer between 0 and 5|0 - \\ 3 - Allowed \\ 1 - Denied \\ 2 - Allowed WC \\ 4 - Allowed NBP \\ 5 - Allowed WCNBP \\ If left empty, the value will be '​3'​.| - |26|Operation Time UoM| |Text|The value must be a valid time code defined on the TimeUnits (BXPTIMEUNITS) user table.*| + |30|Operation Time UoM| |Text|The value must be a valid time code defined on the TimeUnits (BXPTIMEUNITS) user table.*| - |27|Is parallel operation| |N/Y|N - No \\ Y - Yes \\ If left empty, the value will be '​N'​.| + |31|Is parallel operation| |N/Y|N - No \\ Y - Yes \\ If left empty, the value will be '​N'​.| - |28|Is overlapping operation| |N/Y|N - No \\ Y - Yes \\ If left empty, the value will be '​N'​.| + |32|Is overlapping operation| |N/Y|N - No \\ Y - Yes \\ If left empty, the value will be '​N'​.| - |29|Max Parallel Operations| |Integer| | + |33|Max Parallel Operations| |Integer| | - |30|Overlapping Quantity| |Number| | + |34|Overlapping Quantity| |Number| | - |31|Allocation Window| |Number|The importer converts it to a base time using Allocation Window UoM from actual row.| + |35|Allocation Window| |Number|The importer converts it to a base time using Allocation Window UoM from actual row.| - |32|Allocation Window UoM| |Text|The value must be a valid time code defined on the TimeUnits (BXPTIMEUNITS) user table.*| + |36|Allocation Window UoM| |Text|The value must be a valid time code defined on the TimeUnits (BXPTIMEUNITS) user table.*| - |33|Min Job Quantity| |Number| | + |37|Min Job Quantity| |Number| | - |34|Feature|✔|Text|Must be an existing work center feature.| + |38|Feature|✔|Text|Must be an existing work center feature.| - |35|Is Mandatory Work Center| |N/Y|N - No \\ Y - Yes \\ If left empty, the system will copy the value from the manufacturing operation.| + |39|Is Mandatory Work Center| |N/Y|N - No \\ Y - Yes \\ If left empty, the system will copy the value from the manufacturing operation.| - |36|Preferred Work Center| |Text|Must be an existing Work Center which supports selected Work Center Feature.| + |40|Preferred Work Center| |Text|Must be an existing Work Center which supports selected Work Center Feature.| - |37|Outsourced| |N/Y|N - No \\ Y - Yes \\ If left empty, the system will copy the value from the manufacturing operation.| + |41|Outsourced| |N/Y|N - No \\ Y - Yes \\ If left empty, the system will copy the value from the manufacturing operation.| - |38|In House Quantity| |Number|If the Outsourced flag is set to Y, this field is mandatory. \\ If the Outsourced flag is set to N, this field must be empty. + |42|In House Quantity| |Number|If the Outsourced flag is set to Y, this field is mandatory. \\ If the Outsourced flag is set to N, this field must be empty. - |39|Outsourcing Lead Time| |Number|If the Outsourced flag is set to Y, the importer converts it to a base time using Outsourcing UoM from actual row. \\ If the Outsourced flag is set to N, this field must be empty.| + |43|Outsourcing Lead Time| |Number|If the Outsourced flag is set to Y, the importer converts it to a base time using Outsourcing UoM from actual row. \\ If the Outsourced flag is set to N, this field must be empty.| - |40|Outsourcing UoM| |Number|If the Outsourced flag is set to Y, the value must be a valid time code defined on the TimeUnits (BXPTIMEUNITS) user table.* \\ If the Outsourced flag is set to N, this field must be empty.| + |44|Outsourcing UoM| |Number|If the Outsourced flag is set to Y, the value must be a valid time code defined on the TimeUnits (BXPTIMEUNITS) user table.* \\ If the Outsourced flag is set to N, this field must be empty.| - |41|Items per Outsourcing Unit| |Number|If the Outsourced flag is set to N, this field must be empty.| + |45|Items per Outsourcing Unit| |Number|If the Outsourced flag is set to N, this field must be empty.| * //In order to use Produmex Manufacturing integrated with Produmex WMS. the UoM must exist in the Units of Measure - Setup (OUOM) standard SBO table as well.// * //In order to use Produmex Manufacturing integrated with Produmex WMS. the UoM must exist in the Units of Measure - Setup (OUOM) standard SBO table as well.// - If the row is an operation row, and there is a value beyond ​41th column, the row is invalid. A format error message is generated, and the production order is not processed. + If the row is an operation row, and there is a value beyond ​45th column, the row is invalid. A format error message is generated, and the production order is not processed. ====Supplier row type==== ====Supplier row type==== Line 110: Line 118: |5|Issue Method| |M/B|M - Manual \\ B - Backflush \\ If left empty, the value wiil be '​B'​.| |5|Issue Method| |M/B|M - Manual \\ B - Backflush \\ If left empty, the value wiil be '​B'​.| |6|Comment| |Text| | |6|Comment| |Text| | - |7|Distribution Rule| |Text|Must be a valid identifier of a distribution rule. + |7|Distribution Rule 1| |Text|The Distribution rule for Dimension 1. Must be a valid identifier of a distribution rule.| - |8|WIP Account| |Text|The internal reference of a WIP Account. The internal reference code can be found in the OACT.ACCTCODE field.| + |8|Distribution Rule 2| |Text|The Distribution rule for Dimension 2. Must be a valid identifier of a distribution rule.| + |9|Distribution Rule 3| |Text|The Distribution rule for Dimension 3. Must be a valid identifier of a distribution rule.| + |10|Distribution Rule 4| |Text|The Distribution rule for Dimension 4. Must be a valid identifier of a distribution rule.| + |11|Distribution Rule 5| |Text|The Distribution rule for Dimension 5. Must be a valid identifier of a distribution rule.| + |12|WIP Account| |Text|The internal reference of a WIP Account. The internal reference code can be found in the OACT.ACCTCODE field.| - If there is a value beyond ​8th column, the row is invalid. A format error message is generated, and the production order is not processed. + If there is a value beyond ​12th column, the row is invalid. A format error message is generated, and the production order is not processed. ====Text row type==== ​ ====Text row type==== ​