AQB310 のバックアップ(No.17)

BOMBatch entry †

BOM control

BOMBatch entry
Item, and Batch entry and Change-Delete of BOM

【Function Outline】
ItemEntry and Change, and Entry and Change of BOM are possible by correcting the CSV file outputted by 【Item attribute download】 and 【Item composition download】, and performing Batch entry from this screen.

【Function button explanation】

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 output	Output a data check result to a CSV file.

【ItemExplanation】

Input item name	Character	Number of bits	Mandatory	Explanation
Information type	－	－	○	Specify any one contents included in the file which uploads.
File name	－	－	○	Specify the full path of the file which uploads.
Register type	－	－	○	情報種別「構成情報｣以外の場合：　新規、変更の何れかを指定情報種別「構成情報｣の場合：　新規、変更、構成変更の何れかを指定　・新規･･･構成情報の新規作成　・変更･･･構成情報の属性変更(親1単位当たり数、構成PH区分は変更不可) 　・構成変更･･･構成品目追加、変更、削除、属性変更(親1単位当たり数、構成PH区分の変更可能)
DB entry	－	－	○	情報種別「構成情報｣以外の場合：　正規を指定情報種別「構成情報｣の場合：　登録種別「新規」「変更」の場合：　　登録、変更を行う部品表（構成情報）を正式登録するのか、作業中で登録するのかを指定　登録種別「構成変更」の場合：　　作業中を指定
Change content		30	△	Only 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 name	Character	Number of bits	MandatoryAdd	Explanation	A related master
Item	alphabet/number/symbol	20	○
Item name	Character	40	△
Item category	Character	20
Drawing number	Character	20
Drawing size	Character	2
Material mark	Character	10			Material mark master
Weight unit	Character	3	△	It chooses from Code set up beforehand.
Weight	Numeric	12,4	△
Material weight unit	Character	3	△	It chooses from Code set up beforehand.
Material weight	Numeric	12,4	△
Number of drawing	Numeric	2	△
Mfg. name	Character	20
Remarks	Character	40
Sales order stopClassification	Character	1	△	Order propriety is set up.（0:It is not Sales order stop、１:Sales order stop）
Sales order stopDay	Date	-		In the case of Sales order stop、Mandatory
RevisionNo	Character	4
Revision enforcement Day	Date	-		The form of Date changes with setup of a system.
Specification	Character	40
Quantity unit	Character	3	△	It chooses from Code set up beforehand.
Mfg. model	Character	20
Length	Numeric	12,4	△
Length unit	Character	3	△	It chooses from Code set up beforehand.
Diameter	Numeric	12,4	△
Diameter unit	Character	3	△	It chooses from Code set up beforehand.
Mother plant	Character	2	△	Plant which supervises production
Low Level Code	Numeric	2	×	System automatic setup、Entry needlessness.
Size	Character	15

↑

Upload file layout（General） †

Input item name	Character	Number of bits	MandatoryAdd	Explanation
Item	Character	20	○
Item type	Character	1	△	"0"Bulk:Purchase pointOrder "1"Product:MRPObject "2"Material:MRPObject "3"Parts:MRPObject "4"Middle article(Semimanufactured goods):MRPObject、Half finished product、SubAssy article "5"Other Plant articles:MRPObject "9"Phantom article:It is Order Non-object although it is MRPCaculate Object. "A"Construction store:MRP Non-object "B"Consumables:MRP Non-object "E"Other:MRP Non-object
Classification made from M/P	Character	1	△	"M" Insourcing Item produced by in-company Process. It is Generation about a Production 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 classification	Character	1	△	"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 classification	Character	10	△	It chooses from Code set up beforehand.
MRP	Character	1	△	"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 product	Character	1	△	"0"Non-Cock product:Reception quantity Acceptance article "1"Cock product　 :Use quantity Acceptance article

↑

Upload file layout（Order） †

Input item name	Character	Number of bits	MandatoryAdd	Explanation	A related master
Plant code	Character	2	○	Plant which performs Order by the set-up contents is set up.
Item	Character	20	○
Standard lead time	Numeric	5	△	Period required to manufacture or supply the Item concerned
Standard lead time unit	Character	1	△	D:Day、H:Hour、M:Minute
Storing lead time	Numeric	5	△	It is required Period after completion or Reception before Storing(ing).
Storing lead timeUnit	Character	1	△	D:Day、H:Hour、M:Minute
Picking lead time	Numeric	5	△	Period required for Picking work
Picking lead timeUnit	Character	1	△	D:Day、H:Hour、M:Minute
Package lead time	Numeric	5	△	PeriodPeriod required for Shipping work (packing etc.)
Package lead timeUnit	Character	1	△	D:Day、H:Hour、M:Minute
Purchase system	Character	1	△	Order systems (the lot round-off method etc.) are set up.
Purchase point	Numeric	12,4	△	Purchase policy　In 'H:Purchase pointOrder system', One or more
Safe inventory	Numeric	12,4	△	The always secured amount of Inventory qty. is set up to Order qty.
Lot size	Numeric	12,4	△	a lot -- more round Quantity is setting
Defective item rate	Numeric	5	△	The yield is set up.　　Order qty. is seasoned with a defective fraction.
Number of requirements summary days	Numeric	5	△	Purchase 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 week1	Character	1	△	Purchase 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 week2	Character	1	△	Purchase 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 week3	Character	1	△	Purchase 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 week4	Character	1	△	Purchase 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 week5	Character	1	△	Purchase 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 week6	Character	1	△	Purchase 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 week7	Character	1	△	Purchase policy In 'C:Summary on specific day of the week', "1" is set up when summarizing Order qty. to Saturday.
Minimum purchase quantity	Numeric	12,4	△	Not used
Maximum purchase quantity	Numeric	12,4	△	Not used
Delivery destination	Character	6		Delivery destination (Picking locationWork center, Supplier, etc.) of the Item concerned is set up.	Work center master/Supplier master
Location	Character	8	△	The place where the Item concerned is kept is set up.	Location master
Charge	Character	6		The charge of the Item concerned is set up.	Code master
ABC classification	Character	1		A, B, and CClassification are set up. It is Invalid to present and stocktaking processing.
Delivery destination	Character	8		When 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.1	Character	10		User free setup Item. Use is possible as Query article Piece on each screen.
Item class.2	Character	10		User free setup Item. Use is possible as Query article Piece on each screen.
Item class.3	Character	10		User free setup Item. Use is possible as Query article Piece on each screen.
Item class.4	Character	10		User free setup Item. Use is possible as Query article Piece on each screen.
Picking instruction sheet release classification	Character	1	△	"1" Required:It is Output to Picking instruction sheet. "0" Needlessness:It does not output to Picking instruction sheet.
Picking report classification	Character	1	△	"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 classification	Character	1	△	A "1" point Delivery date mortgage is carried out. In MRP processing, when the future has a Production 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 classification	Character	1	△	"I"Individual :It fixes in primaryRelease. "M"Marshaling :At primaryRelease, it is No..t used.
Central purchasing	Character	1	△	0: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 classification	Character	1	△	"0"Valid:MRPObject "１"Invalid:MRPNo..n-object
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:Order production、　1:Forecast production item
Plan regeneration object exclusion setting classification	Character	1	△	0:System parameter、　1:Individual setup、　2:No..t set
Plan regeneration object exclusion period	Numeric	3	△	Indispensable at the time of AddEntry
Plan regeneration object exclusion periodClassification	Character	1	△	M:Month number specification、　T:The number specification of seasons、　W:Week number specification、　D:Number of days specification

↑

Upload file layout（Process） †

Input item name	Character	Number of bits	MandatoryAdd	Explanation	A related master
Item	Character	20	○
Process	Character	3	○
FirstProcessClassification	Character	1		System automatic setup. Input needlessness.
LastProcessClassification	Character	1		System automatic setup. Input needlessness.
Process code	Character	10		Process content of the Process concerned is Code-ized and it chooses from the Code.	Code master
Process content	Character	20		Process content of the Process concerned is set up.
Device No	Character	10		It sets up, when using specific equipment.
Work center	Character	6		In the case of insourcing, Work center Entr(ied) is set up. An outside case is a blank.
Process lead time	Numeric	5	△	A 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 unit	Character	1	△	"D"Day、"H"Hour、"M"Minute
Standard Man working hours	Numeric	5	△	The required labor hours of the person per 1Unit in the Process concerned are set up.
Standard Preparation working hours	Numeric	5	△	Inner Preparation working hours per 1 manufacture lot in the Process concerned is set up.
Standard Machine working hours	Numeric	5	△	The required labor hours of the machine per 1Unit in the Process concerned are set up.
Yield reportClassification	Character	1	△	The 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 those with Yield report.
Outsource	Character	1	△	The Process concerned sets up insourcing (M) and made in outside (P).
Cost element classification	Character	10	△	It chooses from Code set up beforehand.
Direct delivery	Character	1	△	In 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,１:Direct delivery）

↑

Upload file layout（Purchase） †

Input item name	Character	Number of bits	MandatoryAdd	Explanation
Plant code	Character	2	○	Plant which Purchase(s) is set up.
Item	Character	20	○
Item name	Character	40		Setting needlessness. Reference value.
Process	Character	3		Only Process outsource sets up Relevance Process.
Effective date	Date	0	○	Day 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 date	Date	0		Day which carries out the end of adoption of Supplier and Unit price. Expire date does not contain.
Priority sequence	Numeric	2		Seq 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.
Supplier	Character	6	△	Supplier which Purchase(s) the Item concerned from Setup Plant is set up.
Supplier name	Character	40	×	Setting needlessness. Reference value.
Unit price classification	Character	1	△	0:FormalUnit price、1:Unit price
Purchase unit price	Numeric	16,4	△	Unit price which Purchase(s) the Item concerned from Setup Plant to Setup Supplier is set up.
Purchase unit	Character	3		It 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 name	Character	Number of bits	MandatoryAdd	Change	構成変更	Explanation
The top Item	Character	20	△		○	It is Mandatory only while DB entry 「is working.」
Item	Character	20	○	○	○	Parent item is set up.
Prefix	Character	4	○	○	○	The order of a display of Sub-item of the level said Item is set up.
Structure item	Character	20	○	○		Sub-item to parents is set up.構成変更で削除する場合はブランクで入力する。
Suffix	Character	4	×	○		System automatic setup.
Number required per unit parent item	Numeric	12,4	○	×	○	Required Quantity of Sub-item per parent 1Unit is set up.
Lead time off-set lead time	Numeric	5	○		○	Period which may delay delivery to a child's Required date to parents
Lead time off-set lead time Unit	Character	1	○		○	"D":Day、"H":Hour、"M":Minute
Delivery destination	Character	6				When 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 classification	Character	1	○		○	"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 PHClassification	Character	1	○	×	○	"P"Composition phantom article :Only in Parent Item, Sub-item is treated as a phantom article. "M"Non-phantom article（MRP article）:In Parent Item, Sub-item is not a phantom article. Item type of Item master is followed.
Defective structure rate	Numeric	5,2	○		○	The defective fraction of Sub-item at the time of using it for the Parent item concerned is set up.
Change system	Character	2	○	×		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...	Character	10		×		The number which identifies Change content of BOM uniquely It sets up automatically by a system.
Effective time	Date	0		×		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 time	Date	0		×		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 number	Character	10		×		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 number	Character	10		×		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 classification	Character	1	○		○	"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 delivery	Character	1	○		○	"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 †

When performing Batch processing of Item and BOM, 【BOMBatch entry】 is started and information discernment, File name, Register type, DB entry, and Change content are specified.

※the direct entry of File name cannot be performed -- please be sure to specify File name using a reference button。

After specification of upload conditions, although Batch entry and Change-Delete are performed, the Function of each button for StatusConfirm is as follows.
- 〔Confirm 〕 A button performs only the data check of the file which uploads. The various checks of the compatibility of each Code, Date, Number of bits of Number valueItem, value, etc. are performed, and a duplication check also carries out at the time of Entry.
- 〔Entry 〕 A button performs processing based on "Register type" to specified "DB entry." In that case, it checks like the 〔Confirm〕 button and only the data in which an error does not exist in the data of a file performs Entry and Change-Delete.
- The 〔Result confirmation 〕 button Confirm(s) the result processed with the 〔Confirm〕 and 〔Entry〕 button.
  Also when an error occurs, Confirm is possible on this screen. In addition, that can Confirm is the processing Message carried out at the last for every Information type.
- 〔a result -- an output〕 a button downloads the contents of Result confirmation by CSV.