User Tools

Site Tools


implementation:manufacturing:import_productionorder

Differences

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

Link to this comparison view

implementation:manufacturing:import_productionorder [2018/02/02 11:56]
csuhaa created
implementation:manufacturing:import_productionorder [2018/03/12 11:03] (current)
csuhaa 18.1
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==== ​
implementation/manufacturing/import_productionorder.txt · Last modified: 2018/03/12 11:03 by csuhaa