BOMBatch Entry

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 NameCharacterNumber of digitsMandatoryExplanation
Information typeSpecify any one contents included in the file to be uploaded.
File nameSpecify the full path of the file to be uploaded.
Register typeInformation 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 entryInformation 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 contents30Enter comments on the contents・reason etc. of design changes, only the case of entering DB work-in-progress.

Upload File Layout(Basic Information)

Input Item NameCharacterNumber of digitsMandatory AddChangeExplanationRelated Master
Itemalphabet/numeric/symbol20
Item nameCharacter40
Item categoryCharacter20
Drawing numberCharacter20
Drawing sizeCharacter2
Material codeCharacter10Material code master
Weight unitCharacter3Select a code pre- setup.
WeightNumeric12,4
Material weight unitCharacter3Select a code pre- setup.
Material weightNumeric12,4
Number of drawingNumeric2
Mfg. nameCharacter20
RemarksCharacter40
Classification of Sales Order SuspensionCharacter1Set sales order to be accepted or not(0:It is not suspended 、1:Sales order to be suspended)
Date Sales order SuspendedDate-In case of sales order suspended、Mandatory
Revision NoCharacter4
Revision Enforcement DateDate-The date format will be varied by system setup.
SpecificationCharacter40
Quantity unitCharacter3Select a code pre- setup.
Mfg. modelCharacter20
LengthNumeric12,4
Length unitCharacter3Select a code pre- setup.
DiameterNumeric12,4
Diameter unitCharacter3Select a code pre- setup.
Mother plantCharacter2Plant which supervises production
Low Level CodeNumeric2×Setup by system automatically. No entry required.
SizeCharacter15

Upload file layout (General Order Infomation)

Input Item NameCharacterNumber of digitsMandatory AddChangeExplanationRelated Master
ItemCharacter20
Item typeCharacter1"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/PCharacter1"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 managementCharacter1"0" Inventory stock items: Treated as non production number items.
"1" Production number management items: Treated as production number management items.
Classification of cost elementCharacter10Select a code pre- setup
Classification of MRP expansionCharacter1"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 productCharacter1"0" Non-Cock product: Receipt quantity base acceptance.
"1" Cock product: Use quantity base acceptance

Upload File Layout(Order Information)

Input item NameCharacterNumber of digitsMandatory AddChangeExplanationRelated Master
Plant codeCharacter2Set order plant with the set-up contents.
ItemCharacter20
Standard lead time(Fixed)Numeric5Period required to manufacture or purchase the item
Standard lead time(Fixed) UnitCharacter1D:Day、H:Hour、M:Minute
Storing lead timeNumeric5Period required for storing after completion or reception
Storing lead time UnitCharacter1D:Day、H:Hour、M:Minute
Picking lead timeNumeric5Period required for Picking work
Picking lead time UnitCharacter1D:Day、H:Hour、M:Minute
Package lead timeNumeric5Period required for Shipping work (packing etc.)
Package lead timeUnitCharacter1D:Day、H:Hour、M:Minute
Ordering methodCharacter1Set order systems (the lot round-up method etc.)
Order pointNumeric12,4Ordering policy, in case of 'H: order point method ', it should be one or more
Safe inventoryNumeric12,4Set up the stock quantity to be maintained consistently to order
Lot sizeNumeric12,4Set up the rounding quantity of lot size
Item Defective rateNumeric5Set up yield by considering defective ratio to order quantity
Number of requirements summary daysNumeric5Set 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 week1Character1Set "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 week2Character1Set "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 week3Character1Set "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 week4Character1Set "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 week5Character1Set "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 week6Character1Set "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 week7Character1Set "1", in case of purchasing policy is 'C: Summary on specific day of the week', and summarize order quantity to Saturday.
Minimum purchase quantityNumeric12,4It can be enabled for MRP by the system parameters.
"0" means not set.
Maximum purchase quantityNumeric12,4It can be enabled for MRP by the system parameters.
"0" means not set.
Delivery destinationCharacter6Set delivery destination of the item (Work center to be delivered, Supplier, etc.)Work center master/Supplier master
Stored locationCharacter8Set the stored location of the item.Store Location master
Production in ChargeCharacter6Set the production in charge of the Item.Code master
ABC classificationCharacter1Set A, B, and C Classification. It is not in usable to stocktaking processing.
Carry-in destinationCharacter8Set 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.1Character10Item set-up by user freely. Usable as the search condition on each screen.
Item class.2Character10Item set-up by user freely. Usable as the search condition on each screen.
Item class.3Character10Item set-up by user freely. Usable as the search condition on each screen.
Item class.4Character10Item set-up by user freely. Usable as the search condition on each screen.
Picking instruction sheet release classificationCharacter1"1" Required: Outputted to Picking instruction sheet.
"0" Not-required: It does not output to Picking instruction sheet.
Picking report classificationCharacter1"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 deliveryCharacter1"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 classificationCharacter1"I" Individual: Fixes in primary release.
"M" Marshaling: Not in use at primary release.
Classification of central purchasingCharacter10: 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 classificationCharacter1"0" Valid: to be processed in MRP
"1" Invalid: out of MRP processing
Pouring quantityNumeric12,4
Shipping container unitCharacter12,4BX:Box 、 PCE:piece、sheet、number、unit、 RO:Roll、 BG:Bag、 CS:Case、 DR:Drum、 CA:Can、 PF:Palette
Plan classificationCharacter10: Make to Order production
1: Make to stock production item
Out of Plan regeneration setting classificationCharacter10: System parameter
1:Individual setup
2: No setting
Period for out of Plan regenerationNumeric3Mandatory item at the time of Add Entry
Out of Plan regeneration period classificationCharacter1M: Specify number of months
T: Specify number of 10 day periods
W: Specify number of weeks number specification
D: Specify number of days
Standard Lead time class.Character1“0”: Fixed /“1”: Fixed + Variable
Standard Lead time(Variable)Numeric5当該品目を製造または調達するのに必要な期間
Standard Lead time unit(Variable)Character1D: Day, H: Hour, M: Minute

Upload File Layout(Process Information)

Input Item NameCharacterNumber of digitsMandatory AddChangeExplanationRelated Master
ItemCharacter20
ProcessCharacter3
First Process ClassificationCharacter1Set up by system automatically. Input not required.
Last Process ClassificationCharacter1Set up by system automatically. Input not required.
Process codeCharacter10Set a code for the contents of process and select a code out of them.Code master
Process contentCharacter20Define process contents of the process.
Equipment NumberCharacter10Set up, when using specific equipment.
Work centerCharacter6In case of item manufacturing in side, set the registered work center. To be blank, in case of purchasing item.
Process lead time(Fixed)Numeric5Set 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(Fixed) unitCharacter1"D"Day、"H"Hour、"M"Minute
Standard Man working hoursNumeric5The required man hours per 1 Unit of the process.
Standard Preparation working hoursNumeric5Set Inner Preparation working hours per 1 manufacturing lot for the process.
Standard Machine working hoursNumeric5Set the required working hours of the machine per 1 Unit in the Process.
Classification of Yield reportCharacter1Set 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 classificationCharacter1Set the process is Manufacturing inside (M) or purchasing in outside (P).
Cost element classificationCharacter10Select a code pre- setup
Direct delivery/shipment classificationCharacter1Set 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)
Process Lead time(Variable)Numeric5当該工順に必要なリードタイムを設定する。品目手配マスタの標準リ-ドタイム(変動)≧全工順の工順リードタイム(変動)の総和になること。
Process Lead time unit(Variable)Character1D: Day, H: Hour, M: Minute

Upload File Layout(Purchase Criteria)

Input Item NameCharacterNumber of digitsMandatory AddChangeExplanationRelated Master
Plant codeCharacter2Set plant to be ordered.
ItemCharacter20
Item nameCharacter40Set is not required. Reference value.
ProcessCharacter3Set the appropriate process only for outsourcing process.
Effective dateDate0Starting date of using the supplier and unit price. Including the effective date and set the 1st day of the current month and after.
Expire dateDate0Last date of using the supplier and unit price.Not including expire date.
Priority rankiNumeric2Set 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.
SupplierCharacter6Set supplier to which the setup plant purchase the item.
Supplier nameCharacter40×Set is not required. Reference value.
Unit price classificationCharacter10:FormalUnit price、1:Unit price
Purchase unit priceNumeric16,4Set unit price of the setup supplier from which setup plant is purchasing the item.
Purchase unitCharacter3Select a pre- setup quantity unit code. In case of blank, quantity unit of Item master is set up automatically.

Upload File Layout(Structure Information)

Input Item NameCharacterNumber of digitsMandatory AddChange構成変更ExplanationRelated Master
The top level ItemCharacter20It is Mandatory only the case of DB entry is「Working-in-progress」.
ItemCharacter20Parent item is set up.
PrefixCharacter4Set up display sequence of the sub-item in the same item of the same level.
Structure itemCharacter20Set sub-item to parents.Enter blank in case of deleting in the structure change.
SuffixCharacter4×Automatically setup by system.
Number required per unit parent itemNumeric12,4×Set required quantity of Sub-item per parent 1 Unit.
Lead time off-set lead timeNumeric5Period for the delivery delay allowance to the required date of sub-item to parent.
Lead time off-set lead time UnitCharacter1"D":Day、"H":Hour、"M":Minute
Delivery destinationCharacter6If it is not setup this destination (Delivered work center、Supplier etc)of the item, use delivery destination of an Item order master.
Supply classificationCharacter1"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 ClassificationCharacter1×"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 rateNumeric5,2Set the defective rate of Sub-item at the time of using it for the Parent item.
Change methodCharacter2×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 numberCharacter10×The number of uniquely identifying change contents of BOM.Automatically setup by system.
Effective timeDate0×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 timeDate0×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 numberCharacter10×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 numberCharacter10×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 classificationCharacter1"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/shipmentCharacter1"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
NoteCharacter200

Batch entry・Change・Delete of Item and BOM


top   new list search recent   help   rss