Confirm (F1) | Process the data check of the data specified by Information type and File name. |
Entry (F2) | Process the data check・entry of the data specified by Information type and File name. |
Result confirmation (F5) | Display a data check result. |
Result output (F9) | Output a data check result to a CSV file. |
Input Item Name | Character | Number of digits | Mandatory | Explanation |
---|---|---|---|---|
Information type | - | - | ○ | Specify any one contents included in the file to be uploaded. |
File name | - | - | ○ | Specify the full path of the file to be uploaded. |
Register type | - | - | ○ | Information type other than 「Structure Information」: Specify Add or Change Information type 「Structure Information」: Specify Add, Change or Structure change ・Add・・・Create new structure information ・Change・・・Change attribute of structure information (can not change Quantity per 1 parent unit nor Classification of structure PH) ・Structure change・・・Add・Change・Delete・Attribute change of Item structure (possible to change Quantity per 1 parent unit or Classification of structure PH) |
DB entry | - | - | ○ | Information type other than 「Structure Information」: Specify formal entry Information type 「Structure Information」: Entry type 「Add」「Change」: Specify formal entry or work-in-progress of BOM (Structure information) to be entered・changed Entry type 「Structure change」: Specify work-in-progress |
Change contents | 30 | △ | Enter comments on the contents・reason etc. of design changes, only the case of entering DB work-in-progress. |
Input Item Name | Character | Number of digits | Mandatory Add | Change | Explanation | Related Master |
---|---|---|---|---|---|---|
Item | alphabet/numeric/symbol | 20 | ○ | |||
Item name | Character | 40 | △ | |||
Item category | Character | 20 | ||||
Drawing number | Character | 20 | ||||
Drawing size | Character | 2 | ||||
Material code | Character | 10 | Material code master | |||
Weight unit | Character | 3 | △ | Select a code pre- setup. | ||
Weight | Numeric | 12,4 | △ | |||
Material weight unit | Character | 3 | △ | Select a code pre- setup. | ||
Material weight | Numeric | 12,4 | △ | |||
Number of drawing | Numeric | 2 | △ | |||
Mfg. name | Character | 20 | ||||
Remarks | Character | 40 | ||||
Classification of Sales Order Suspension | Character | 1 | △ | Set sales order to be accepted or not(0:It is not suspended 、1:Sales order to be suspended) | ||
Date Sales order Suspended | Date | - | In case of sales order suspended、Mandatory | |||
Revision No | Character | 4 | ||||
Revision Enforcement Date | Date | - | The date format will be varied by system setup. | |||
Specification | Character | 40 | ||||
Quantity unit | Character | 3 | △ | Select a code pre- setup. | ||
Mfg. model | Character | 20 | ||||
Length | Numeric | 12,4 | △ | |||
Length unit | Character | 3 | △ | Select a code pre- setup. | ||
Diameter | Numeric | 12,4 | △ | |||
Diameter unit | Character | 3 | △ | Select a code pre- setup. | ||
Mother plant | Character | 2 | △ | Plant which supervises production | ||
Low Level Code | Numeric | 2 | × | Setup by system automatically. No entry required. | ||
Size | Character | 15 |
Input Item Name | Character | Number of digits | Mandatory Add | Change | Explanation | Related Master |
---|---|---|---|---|---|---|
Item | Character | 20 | ○ | |||
Item type | Character | 1 | △ | "0" Bulk: Purchasing with Order point method "1" Product: MRP process "2" Material: MRP process "3" Parts: MRP process "4" Middle article(Half-manufactured goods): MRP process、Half finished product、Sub-Assy article "5" Other Plant articles: MRP process "9" Phantom article: To be processed by MRP; but not to be ordered "A" Auxiliary material: Non MRP process "B" Consumables: Non MRP process "E" Others: Non MRP process | ||
Classification of M/P | Character | 1 | △ | "M" Manufactured items Items produced in-company process. Create a production order. Set also "M" insourcing to the passage subcontracted goods which do not pass along in-company Process. "P" Purchasing itemsItems acquired from outside. Create purchase order. In case of Item type '9: phantom articles’, "M" manufactured insourcing In case of Item type alphabetic characters (sub-materials, consumables, etc.), "P": purchasing from outside | ||
Classification of Production number management | Character | 1 | △ | "0" Inventory stock items: Treated as non production number items. "1" Production number management items: Treated as production number management items. | ||
Classification of cost element | Character | 10 | △ | Select a code pre- setup | ||
Classification of MRP expansion | Character | 1 | △ | "1" MRP processed items: Create a plan order by MRP processing. "0" Non MRP processed items: Do not create a plan order by MRP processing. | ||
Classification of cock product | Character | 1 | △ | "0" Non-Cock product: Receipt quantity base acceptance. "1" Cock product: Use quantity base acceptance |
Input item Name | Character | Number of digits | Mandatory Add | Change | Explanation | Related Master |
---|---|---|---|---|---|---|
Plant code | Character | 2 | ○ | Set order plant with the set-up contents. | ||
Item | Character | 20 | ○ | |||
Standard lead time | Numeric | 5 | △ | Period required to manufacture or purchase the item | ||
Standard lead time Unit | Character | 1 | △ | D:Day、H:Hour、M:Minute | ||
Storing lead time | Numeric | 5 | △ | Period required for storing after completion or reception | ||
Storing lead time Unit | Character | 1 | △ | D:Day、H:Hour、M:Minute | ||
Picking lead time | Numeric | 5 | △ | Period required for Picking work | ||
Picking lead time Unit | Character | 1 | △ | D:Day、H:Hour、M:Minute | ||
Package lead time | Numeric | 5 | △ | Period required for Shipping work (packing etc.) | ||
Package lead timeUnit | Character | 1 | △ | D:Day、H:Hour、M:Minute | ||
Ordering method | Character | 1 | △ | Set order systems (the lot round-up method etc.) | ||
Order point | Numeric | 12,4 | △ | Ordering policy, in case of 'H: order point method ', it should be one or more | ||
Safe inventory | Numeric | 12,4 | △ | Set up the stock quantity to be maintained consistently to order | ||
Lot size | Numeric | 12,4 | △ | Set up the rounding quantity of lot size | ||
Item Defective rate | Numeric | 5 | △ | Set up yield by considering defective ratio to order quantity | ||
Number of requirements summary days | Numeric | 5 | △ | Set up the number of days for summarizing order quantity by delivery in case of purchasing policy is 'B: summarizing by period' | ||
Summarize requirements on the specific day of the week1 | Character | 1 | △ | Set "1", in case of purchasing policy is 'C: Summary on specific day of the week', and summarize order quantity to Sunday. | ||
Summarize requirements on the specific day of the week2 | Character | 1 | △ | Set "1", in case of purchasing policy is 'C: Summary on specific day of the week', and summarize order quantity to Monday. | ||
Summarize requirements on the specific day of the week3 | Character | 1 | △ | Set "1", in case of purchasing policy is 'C: Summary on specific day of the week', and summarize order quantity to Tuesday. | ||
Summarize requirements on the specific day of the week4 | Character | 1 | △ | Set "1", in case of purchasing policy is 'C: Summary on specific day of the week', and summarize order quantity to Wednesday. | ||
Summarize requirements on the specific day of the week5 | Character | 1 | △ | Set "1", in case of purchasing policy is 'C: Summary on specific day of the week', and summarize order quantity to Thursday. | ||
Summarize requirements on the specific day of the week6 | Character | 1 | △ | Set "1", in case of purchasing policy is 'C: Summary on specific day of the week', and summarize order quantity to Friday. | ||
Summarize requirements on the specific day of the week7 | Character | 1 | △ | Set "1", in case of purchasing policy is 'C: Summary on specific day of the week', and summarize order quantity to Saturday. | ||
Minimum purchase quantity | Numeric | 12,4 | △ | Not in use | ||
Maximum purchase quantity | Numeric | 12,4 | △ | Not in use | ||
Delivery destination | Character | 6 | Set delivery destination of the item (Work center to be delivered, Supplier, etc.) | Work center master/Supplier master | ||
Stored location | Character | 8 | △ | Set the stored location of the item. | Store Location master | |
Production in Charge | Character | 6 | Set the production in charge of the Item. | Code master | ||
ABC classification | Character | 1 | Set A, B, and C Classification. It is not in usable to stocktaking processing. | |||
Carry-in destination | Character | 8 | Set carry-in destination of the item.Use the data on master if it is available, or if not, will be used the carry-in destination on plant master. | Code master | ||
Item class.1 | Character | 10 | Item set-up by user freely. Usable as the search condition on each screen. | |||
Item class.2 | Character | 10 | Item set-up by user freely. Usable as the search condition on each screen. | |||
Item class.3 | Character | 10 | Item set-up by user freely. Usable as the search condition on each screen. | |||
Item class.4 | Character | 10 | Item set-up by user freely. Usable as the search condition on each screen. | |||
Picking instruction sheet release classification | Character | 1 | △ | "1" Required: Outputted to Picking instruction sheet. "0" Not-required: It does not output to Picking instruction sheet. | ||
Picking report classification | Character | 1 | △ | "00" Not-required: Backflush performs Picking and deduction. "01" Not-required: Picking and deduction will be processed at the time of releasing picking instruction. "10" Required : Picking is performed by Picking report and backflush performs deduction. "12" Required : Picking and deduction are performed by Picking report. | ||
Classification of allocation to future delivery | Character | 1 | △ | "1" Allocation to future delivery If it is available the production order or purchase order in future, allocate such an order and calculate requirements. Since it is outputted to an action list, and adjustment is required. "0" No allocation to future delivery Calculate requirements in MRP processing for making it in time of required. is performed so that it may be enough for Required date. | ||
Picking instruction classification | Character | 1 | △ | "I" Individual: Fixes in primary release. "M" Marshaling: Not in use at primary release. | ||
Classification of central purchasing | Character | 1 | △ | 0: Individual MRP processing is performed by Item Order information for every Plant. 1: Central purchasing Only 1 Item can be set up in the Item. MRP processing is performed by Item Order information of central purchasing. | ||
Invalid classification | Character | 1 | △ | "0" Valid: to be processed in MRP "1" Invalid: out of MRP processing | ||
Pouring quantity | Numeric | 12,4 | ||||
Shipping container unit | Character | 12,4 | BX:Box 、 PCE:piece、sheet、number、unit、 RO:Roll、 BG:Bag、 CS:Case、 DR:Drum、 CA:Can、 PF:Palette | |||
Plan classification | Character | 1 | △ | 0: Make to Order production 1: Make to stock production item | ||
Out of Plan regeneration setting classification | Character | 1 | △ | 0: System parameter 1:Individual setup 2: No setting | ||
Period for out of Plan regeneration | Numeric | 3 | △ | Mandatory item at the time of Add Entry | ||
Out of Plan regeneration period classification | Character | 1 | △ | M: Specify number of months T: Specify number of 10 day periods W: Specify number of weeks number specification D: Specify number of days |
Input Item Name | Character | Number of digits | Mandatory Add | Change | Explanation | Related Master |
---|---|---|---|---|---|---|
Item | Character | 20 | ○ | |||
Process | Character | 3 | ○ | |||
First Process Classification | Character | 1 | Set up by system automatically. Input not required. | |||
Last Process Classification | Character | 1 | Set up by system automatically. Input not required. | |||
Process code | Character | 10 | Set a code for the contents of process and select a code out of them. | Code master | ||
Process content | Character | 20 | Define process contents of the process. | |||
Equipment Number | Character | 10 | Set up, when using specific equipment. | |||
Work center | Character | 6 | In case of item manufacturing in side, set the registered work center. To be blank, in case of purchasing item. | |||
Process lead time | Numeric | 5 | △ | Set required lead time for the process.It should be the standard lead time of the process in item order master ≧ the sum of the lead time of every process. | ||
Process lead time unit | Character | 1 | △ | "D"Day、"H"Hour、"M"Minute | ||
Standard Man working hours | Numeric | 5 | △ | The required man hours per 1 Unit of the process. | ||
Standard Preparation working hours | Numeric | 5 | △ | Set Inner Preparation working hours per 1 manufacturing lot for the process. | ||
Standard Machine working hours | Numeric | 5 | △ | Set the required working hours of the machine per 1 Unit in the Process. | ||
Classification of Yield report | Character | 1 | △ | Set yes or no of Production Status Report to the Process. In case of no Production Status Report, provide an estimated results report in Production Status Report of the following Processes. In case of outsourced process, set Production Status Report of yes. | ||
Outsource process classification | Character | 1 | △ | Set the process is Manufacturing inside (M) or purchasing in outside (P). | ||
Cost element classification | Character | 10 | △ | Select a code pre- setup | ||
Direct delivery/shipment classification | Character | 1 | △ | Set direct shipment yes or no, in case of the process is outsource and the following process is also outsource. (0: Not direct shipment, 1: Direct shipment yes) |
Input Item Name | Character | Number of digits | Mandatory Add | Change | Explanation | Related Master |
---|---|---|---|---|---|---|
Plant code | Character | 2 | ○ | Set plant to be ordered. | ||
Item | Character | 20 | ○ | |||
Item name | Character | 40 | Set is not required. Reference value. | |||
Process | Character | 3 | Set the appropriate process only for outsourcing process. | |||
Effective date | Date | 0 | ○ | Starting date of using the supplier and unit price. Including the effective date and set the 1st day of the current month and after. | ||
Expire date | Date | 0 | Last date of using the supplier and unit price.Not including expire date. | |||
Priority ranki | Numeric | 2 | Set blank in case of the information obtained at releasing a purchase order in MRP processing. Set rank in case of using individual purchase order or change of purchase order. | |||
Supplier | Character | 6 | △ | Set supplier to which the setup plant purchase the item. | ||
Supplier name | Character | 40 | × | Set is not required. Reference value. | ||
Unit price classification | Character | 1 | △ | 0:FormalUnit price、1:Unit price | ||
Purchase unit price | Numeric | 16,4 | △ | Set unit price of the setup supplier from which setup plant is purchasing the item. | ||
Purchase unit | Character | 3 | Select a pre- setup quantity unit code. In case of blank, quantity unit of Item master is set up automatically. |
Input Item Name | Character | Number of digits | Mandatory Add | Change | 構成変更 | Explanation | Related Master |
---|---|---|---|---|---|---|---|
The top level Item | Character | 20 | △ | ○ | It is Mandatory only the case of DB entry is「Working-in-progress」. | ||
Item | Character | 20 | ○ | ○ | ○ | Parent item is set up. | |
Prefix | Character | 4 | ○ | ○ | ○ | Set up display sequence of the sub-item in the same item of the same level. | |
Structure item | Character | 20 | ○ | ○ | Set sub-item to parents.Enter blank in case of deleting in the structure change. | ||
Suffix | Character | 4 | × | ○ | Automatically setup by system. | ||
Number required per unit parent item | Numeric | 12,4 | ○ | × | ○ | Set required quantity of Sub-item per parent 1 Unit. | |
Lead time off-set lead time | Numeric | 5 | ○ | ○ | Period for the delivery delay allowance to the required date of sub-item to parent. | ||
Lead time off-set lead time Unit | Character | 1 | ○ | ○ | "D":Day、"H":Hour、"M":Minute | ||
Delivery destination | Character | 6 | If it is not setup this destination (Delivered work center、Supplier etc)of the item, use delivery destination of an Item order master. | ||||
Supply classification | Character | 1 | ○ | ○ | "0" Procured item from supplier: Item supplied or manufactured at the supplier."1" The Free supply article to supplier: Item to be supplied free to Supplier"2" The selling article to supplier: Item which Supplied with fare to Supplier | ||
Structure PH Classification | Character | 1 | ○ | × | ○ | "P" Phantom item in the structure: Only the case of parent item, Sub-item is treated as phantom."M" Non-phantom item(MRP item):In case of parent item, Sub-item is not a phantom article and apply Item type of Item master. | |
Defective structure rate | Numeric | 5,2 | ○ | ○ | Set the defective rate of Sub-item at the time of using it for the Parent item. | ||
Change method | Character | 2 | ○ | × | To be fixed with the change method specified at the BOM formal entry. It changes by "CE" Date: Specifying effective/expire date. It changes by "SE" Production number: Specifying the number range of Production number to be used. | ||
Change control number | Character | 10 | × | The number of uniquely identifying change contents of BOM.Automatically setup by system. | |||
Effective time | Date | 0 | × | The effective date specified at BOM formal entry. Set in case of the changeover is made by "CE" Date as the「Change method」, it is including the effective date. | |||
Expire time | Date | 0 | × | The expired date specified at BOM formal entry.Set in case of the changeover is made by "CE" Date as the「Change method」, it is not including the expired date. | |||
Valid production number | Character | 10 | × | The selected starting production number specified at BOM formal entry.Set in case of the changeover is made by "SE" production number as the「Change method」. | |||
Invalid production number | Character | 10 | × | The selected last production number specified at BOM formal entry.Set in case of the changeover is made by "SE" production number as the「Change method」. | |||
Receipt classification | Character | 1 | ○ | ○ | "M" The Free supply items from Customer: Item Supplied free from Customer"Y" The Paid supply items from Customer: Item Supplied with payment from Customer"0" Non Receipt items: Item manufactured or supplied at its company | ||
Classification of direct delivery/shipment | Character | 1 | ○ | ○ | "1" Direct delivery: 「Direct delivery from Supplier at the time of the subcontract material supplying to a subcontract place」 「Direct delivery to a line side from the Process outsource point」 "0" Not direct delivery |