BOMBatch entry

Confirm (F1)The data check of the data specified by Information type and File name is carried out.
Entry (F2)The data check of the data specified by Information type and File name is carried out.
Result confirmation (F5)Display a data check result.
Result outputOutput a data check result to a CSV file.
Input item nameCharacterNumber of bitsMandatoryExplanation
Information typeSpecify any one contents included in the file which uploads.
File nameSpecify the full path of the file which uploads.
Register typeSpecify any of Add, Change, and Delete they are.
DB entrySpecify whether it Entr(ies) by being under work about Formal entry [ BOM (Structure information) which performs Entry and Change ].
Change content30Only when Entry(ing) to DB during work, input Remark(s), such as contents, a reason, etc. for Design Change.

Upload file layout(Basic)

Input item nameCharacterNumber of bitsMandatoryAddChangeExplanationA related master
Itemalphabet/number/symbol20
Item nameCharacter40
Item categoryCharacter20
Drawing numberCharacter20
Drawing sizeCharacter2
Material markCharacter10Material mark master
Weight unitCharacter3It chooses from Code set up beforehand.
WeightNumeric12,4
Material weight unitCharacter3It chooses from Code set up beforehand.
Material weightNumeric12,4
Number of drawingNumeric2
Mfg. nameCharacter20
RemarksCharacter40
Sales order stopClassificationCharacter1Order propriety is set up.(0:Sales order stopでない、1:Sales order stop)
Sales order stopDayDate-In the case of Sales order stop、Mandatory
RevisionNoCharacter4
Revision enforcement DayDate-The form of Date changes with setup of a system.
SpecificationCharacter40
Quantity unitCharacter3It chooses from Code set up beforehand.
Mfg. modelCharacter20
LengthNumeric12,4
Length unitCharacter3It chooses from Code set up beforehand.
DiameterNumeric12,4
Diameter unitCharacter3It chooses from Code set up beforehand.
Mother plantCharacter2Plant which supervises production
Low Level CodeNumeric2×System automatic setup、Entry needlessness.
SizeCharacter15

Upload file layout(General)

Input item nameCharacterNumber of bitsMandatoryAddChangeExplanationA related master
ItemCharacter20
Item typeCharacter1"0"Bulk:Purchase pointOrder
"1"Product:MRPObject
"2"Material:MRPObject
"3"Parts:MRPObject
"4"Middle article(Semimanufactured goods):MRPObject、半成品、SubAssy article
"5"Other Plant articles:MRPObject
"9"Phantom article:It is OrderNo..n-object although it is MRPCaculate Object.
"A"Construction store:MRPNo..n-object
"B"Consumables:MRPNo..n-object
"E"Other:MRPNo..n-object
Classification made from M/PCharacter1"M" Insourcing
  Item produced by in-company Process. It is Generation about a manufacture order.It sets to "M" insourcing also about the passage subcontracted goods which do not pass along in-company Process.
"P" Made in outside
  Item supplied from external. It is Generation about a Purchase order.In the case of Item type '9:phantom article', "M" Insourcing
In the case of Item type alphabetic characters (submaterials, consumables, etc.), "P":Made in outside
Production number management, order and classificationCharacter1"0"Inventory stock article :It treats as having no Production number.
"1"Production number management article :It treats as a Production number management article.
Cost element classificationCharacter10It chooses from Code set up beforehand.
MRPCharacter1"1"MRP Object article:It is Generation about a Plan order by MRP processing.
"0"MRPNo..n-object:A Plan order is not created by MRP processing.
Cock productCharacter1"0"Non-Cock product:Reception quantity Acceptance article
"1"Cock product  :Use quantity Acceptance article

Upload file layout(Order)

Input item nameCharacterNumber of bitsMandatoryAddChangeExplanationA related master
Plant codeCharacter2Plant which performs Order by the set-up contents is set up.
ItemCharacter20
Standard lead timeNumeric5Period required to manufacture or supply the Item concerned
Standard lead time unitCharacter1D:Day、H:Hour、M:Minute
Storing lead timeNumeric5It is required Period after completion or Reception before Storing(ing).
Storing lead timeUnitCharacter1D:Day、H:Hour、M:Minute
Picking lead timeNumeric5Period required for Picking work
Picking lead timeUnitCharacter1D:Day、H:Hour、M:Minute
Package lead timeNumeric5PeriodPeriod required for Shipping work (packing etc.)
Package lead timeUnitCharacter1D:Day、H:Hour、M:Minute
Purchase systemCharacter1Order systems (the lot round-off method etc.) are set up.
Purchase pointNumeric12,4Purchase policy In 'H:Purchase pointOrder system', One or more
Safe inventoryNumeric12,4The always secured amount of Inventory qty. is set up to Order qty.
Lot sizeNumeric12,4a lot -- more round Quantity is set up
Defective item rateNumeric5The yield is set up.  Order qty. is seasoned with a defective fraction.
Number of requirements summary daysNumeric5Purchase policy In 'B:Period conclusion', Number of days summarized on a Delivery date basis of Order qty. is set up.
Requirements summary on specific day of the week1Character1Purchase policy In 'C:Summary on specific day of the week', "1" is set up when summarizing Order qty. to Sunday.
Requirements summary on specific day of the week2Character1Purchase policy In 'C:Summary on specific day of the week', "1" is set up when summarizing Order qty. to Monday.
Requirements summary on specific day of the week3Character1Purchase policy In 'C:Summary on specific day of the week', "1" is set up when summarizing Order qty. to Tuesday.
Requirements summary on specific day of the week4Character1Purchase policy In 'C:Summary on specific day of the week', "1" is set up when summarizing Order qty. to Wednesday.
Requirements summary on specific day of the week5Character1Purchase policy In 'C:Summary on specific day of the week', "1" is set up when summarizing Order qty. to Thursday.
Requirements summary on specific day of the week6Character1Purchase policy In 'C:Summary on specific day of the week', "1" is set up when summarizing Order qty. to Friday.
Requirements summary on specific day of the week7Character1Purchase policy In 'C:Summary on specific day of the week', "1" is set up when summarizing Order qty. to Saturday.
Minimum purchase quantityNumeric12,4No..t used
Maximum purchase quantityNumeric12,4No..t used
Delivery destinationCharacter6Delivery destination (Picking locationWork center, Supplier, etc.) of the Item concerned is set up.Work center master/Supplier master
LocationCharacter8The place where the Item concerned is kept is set up.Location master
ChargeCharacter6The charge of the Item concerned is set up.Code master
ABC classificationCharacter1A, B, and C Classification are set up. It is Invalid to Present 在 and stocktaking processing.
Delivery destinationCharacter8When set to this master that sets up Delivery destination of the Item concerned, the Item concerned is used, and when not set up, Delivery destination of a Plant master is used.Code master
Item class.1Character10User free setup Item. Use is possible as Query article Piece on each screen.
Item class.2Character10User free setup Item. Use is possible as Query article Piece on each screen.
Item class.3Character10User free setup Item. Use is possible as Query article Piece on each screen.
Item class.4Character10User free setup Item. Use is possible as Query article Piece on each screen.
Picking instruction sheet release classificationCharacter1"1" Required:It is Output to Picking instruction sheet.
"0" Needlessness:It does not output to Picking instruction sheet.
Picking report classificationCharacter1"00" Needlessness :Backflash performs Picking and redemption.
"01" Needlessness :Picking and redemption are performed at the time of Picking instruction.
"10" Required :Picking is performed by Picking report and backflash performs redemption.
"12" Required :Picking and redemption are performed by Picking report.
Allocation of goods to be arrived classificationCharacter1A "1" point Delivery date mortgage is carried out. In MRP processing, when the future has a manufacture order or a Purchase order, the order is drawn and requird-quantity Caculate is performed. Since it is outputted to an action list that, Adjustment is required.A "0" point Delivery date mortgage is not carried out. In MRP processing, requirements Caculate is performed so that it may be enough for Required date.
Picking instruction classificationCharacter1"I"Individual :It fixes in primaryRelease.
"M"Marshaling :At primaryRelease, it is No..t used.
Central purchasingCharacter10:Individual
 MRP processing is performed by ItemOrder for every Plant.
1:Central purchasing
 Only 1 Item can be set up in the Item.
 MRP processing is performed by ItemOrder which carried out central purchasing.
Invalid classificationCharacter1"0"Valid:MRPObject
"1"Invalid:MRPNo..n-object
Pouring quantityNumeric12,4
Shipping container unitCharacter12,4BX:Box 、 PCE:個、枚、本、台、 RO:Roll、 BG:Bag、 CS:Case、 DR:Drum、 CA:Can、 PF:Palette
Plan classificationCharacter10:Order production、 1:Forecast production item
Plan regeneration object exclusion setting classificationCharacter10:System parameter、 1:Individual setup、 2:No..t set
Plan regeneration object exclusion periodNumeric3Indispensable at the time of AddEntry
Plan regeneration object exclusion periodClassificationCharacter1M:Month number specification、 T:The number specification of seasons、 W:Week number specification、 D:Number of days specification

Upload file layout(Process)

Input item nameCharacterNumber of bitsMandatoryAddChangeExplanation関連マスタ
ItemCharacter20
ProcessCharacter3
FirstProcessClassificationCharacter1System automatic setup. Input needlessness.
LastProcessClassificationCharacter1System automatic setup. Input needlessness.
Process codeCharacter10Process content of the Process concerned is Code-ized and it chooses from the Code.Code master
Process contentCharacter20Process content of the Process concerned is set up.
Device No...Character10It sets up, when using specific equipment.
Work centerCharacter6In the case of insourcing, Work center Entr(ied) is set up. An outside case is a blank.
Process lead timeNumeric5A lead time required for the Process concerned is set up. Become total of the Process lead time of standard lead time ≧ all Process of an Item order master.
Process lead time unitCharacter1"D"Day、"H"Hour、"M"Minute
Standard Man working hoursNumeric5The required labor hours of the person per 1Unit in the Process concerned are set up.
Standard Preparation working hoursNumeric5Inner Preparation working hours per 1 manufacture lot in the Process concerned is set up.
Standard Machine working hoursNumeric5The required labor hours of the machine per 1Unit in the Process concerned are set up.
Yield reportClassificationCharacter1The existence of Yield report to the Process concerned is set up. When Yield report, a deemed report is given in Yield report after the following Process. In Subcontract Process, it sets to Yield report 有.
OutsourceCharacter1The Process concerned sets up insourcing (M) and made in outside (P).
Cost element classificationCharacter10It chooses from Code set up beforehand.
Direct deliveryCharacter1In a subcontract and a subcontract of the following Process of the Process concerned, the existence of Direct delivery is set up. (0:Not direct delivery,1:Direct delivery)

Upload file layout(Purchase)

Input item nameCharacterNumber of bitsMandatoryAddChangeExplanation関連マスタ
Plant codeCharacter2Plant which Purchase(s) is set up.
ItemCharacter20
Item nameCharacter40Setting needlessness. Reference value.
ProcessCharacter3Only Process outsource sets up Relevance Process.
Effective dateDate0Day which carries out the adoption start of Supplier and Unit price. Effective date contains. 1st of this Month or subsequent ones is set up.
Expire dateDate0Day which carries out the end of adoption of Supplier and Unit price. Expire date does not contain.
Priority sequenceNumeric2Seq is set up when using it at the time of blank IndividualPurchase and Purchase order change in information acquired when Releas(ing) a Purchase order at the time of MRP processing.
SupplierCharacter6Supplier which Purchase(s) the Item concerned from Setup Plant is set up.
Supplier nameCharacter40×Setting needlessness. Reference value.
Unit price classificationCharacter10:FormalUnit price、1:Unit price
Purchase unit priceNumeric16,4Unit price which Purchase(s) the Item concerned from Setup Plant to Setup Supplier is set up.
Purchase unitCharacter3It chooses from Code of Quantity unit set up beforehand. When blank, Quantity unit of Item master is set up automatically.

Upload file layout(Structure information)

Input item nameCharacterNumber of bitsMandatoryAddChangeExplanation関連マスタ
The top ItemCharacter20It is Mandatory only while DB entry 「is working.」
ItemCharacter20Parent item is set up.
PrefixCharacter4The order of a display of Sub-item of the level said Item is set up.
Structure itemCharacter20Sub-item to parents is set up.
SuffixCharacter4×System automatic setup.
Number required per unit parent itemNumeric12,4×Required Quantity of Sub-item per parent 1Unit is set up.
Lead time off-set lead timeNumeric5Period which may delay delivery to a child's Required date to parents
Lead time off-set lead time UnitCharacter1"D":Day、"H":Hour、"M":Minute
Delivery destinationCharacter6When this Item that sets up Delivery destination(Picking locationWork center、Supplier,etc) of the Item concerned is not set up, Delivery destination of an Item order master is adopted.
Supply classificationCharacter1"0"Supplier procured item: Item supplied or manufactured at its company
"1"The Free supply article to Supplier: Item which Suppl(ies) free to Supplier
"2"The Paid supply article to Supplier: Item which Suppl(ies) free to Supplier
Structure PHClassificationCharacter1×"P"Composition phantom article :Only in this 親品, Sub-item is treated as a phantom article.
"M"Non-phantom article(MRP article):In this 親品, Sub-item is not a phantom article.
Item type of Item master is followed.
Defective structure rateNumeric5,2The defective fraction of Sub-item at the time of using it for the Parent item concerned is set up.
Change systemCharacter2×It is fixed by Change method specified as 1st Change method of BOM specified at the time of BOMFormal entry.
  It changes by "CE"Date :It is Specified about owner Expire date.
  It changes by "SE"Production number :It is Specified about the number range of Production number to adopt.
Change management No...Character10×The number which identifies Change content of BOM uniquely It sets up automatically by a system.
Effective timeDate0×In the change by "CE"Date of Effective date 「Change system」 of BOM specified at the time of BOMFormal entry, it sets up.
 Effective date contains.
Expire timeDate0×In the change by "CE"Date of Expire date 「Change system」 of BOM specified at the time of BOMFormal entry, it sets up.
  Expire date does not contain.
Valid production numberCharacter10×In the change by "SE"Production number of the adoption start Production number of BOM specified at the time of BOMFormal entry "Change system", it sets up.
Invalid production numberCharacter10×In the change by "SE"Production number of the end Production number of adoption of BOM specified at the time of BOMFormal entry "Change system", it sets up.
Receive classificationCharacter1"M" The Free supply article from Customer :Item Suppl(ied) free from Customer
"Y" The Paid supply article from Customer :Item Suppl(ied) for counter value from Customer
"0" Receipt No..n-object :Item manufactured or supplied at its company
Direct deliveryCharacter1"1" Direct delivery :「Direct delivery from Supplier at the time of the subcontract material Supply to a subcontract place」
          「Direct delivery on a line side from the Process outsource point」
"0" Not direct delivery

Item, and Batch entry and Change-Delete of BOM


top   new list search recent   help   rss