CN104915416A - Method capable of quickly deriving bill of material of components containing specific attributes - Google Patents

Method capable of quickly deriving bill of material of components containing specific attributes Download PDF

Info

Publication number
CN104915416A
CN104915416A CN201510307939.7A CN201510307939A CN104915416A CN 104915416 A CN104915416 A CN 104915416A CN 201510307939 A CN201510307939 A CN 201510307939A CN 104915416 A CN104915416 A CN 104915416A
Authority
CN
China
Prior art keywords
bom
components
storehouse
parts
information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201510307939.7A
Other languages
Chinese (zh)
Inventor
崔铭航
翟西斌
于治楼
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Inspur Group Co Ltd
Original Assignee
Inspur Group Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Inspur Group Co Ltd filed Critical Inspur Group Co Ltd
Priority to CN201510307939.7A priority Critical patent/CN104915416A/en
Publication of CN104915416A publication Critical patent/CN104915416A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • General Factory Administration (AREA)

Abstract

The invention relates to the technical field of schematic circuit diagrams, in particular to a method capable of quickly deriving a bill of material of components containing specific attributes. The method comprises the steps of setting specific component attributes; setting a bill of material (BOM) form pattern; loading a component database containing component information, a PCB package library and a schematic diagram symbol library according to the design requirements; and quickly deriving the complete BOM. The method enhances overall management systematicness of the component database, the maintenance efficiency of the schematic diagram symbol library and the PCB package library are obviously improved, the management efficiency and management are also improved; and the efficiency is improved and the time is saved for the BOM of the components containing the specific attributes.

Description

A kind of method that can derive fast containing particular community device Bill of Material (BOM)
Technical field
The present invention relates to schematic diagram design technical field, particularly a kind of method that can derive fast containing particular community device Bill of Material (BOM).
Background technology
Bill of Material (BOM) (Bill of Material, BOM), adopt area of computer aided enterprise production management, first computing machine will be enable to read product slate manufactured by enterprise and all materials that will relate to, for the ease of computer recognizing, the product structure of expressing by diagram must be changed into certain data layout, this file describing product structure is in data format exactly Bill of Material (BOM), is namely BOM.
Along with the development that electron trade is advanced by leaps and bounds, board design difficulty strengthens, and components and parts kind is various especially, and the method for traditional artificial integration BOM has no longer been applicable to complicated Electronic Design.
Summary of the invention
In order to solve the problem of prior art, the invention provides a kind of method that can derive fast containing particular community device Bill of Material (BOM), it better can solve problems such as deriving the complete or error that tank farm stock is inaccurate and manual retrieval brings of BOM information.
The technical solution adopted in the present invention is as follows:
The method containing particular community device Bill of Material (BOM) can be derived fast, comprise the following steps:
A, components and parts particular community is set;
B, BOM sheet format is set;
C, connection components and parts database, components and parts database is according to information in components and parts in tables of data, encapsulate in storehouse at PCB respectively and transfer corresponding packaging information, in schematic symbol storehouse, call corresponding symbolic information, in material code system, call relevant producer, producer's item number and inventory information;
D, the information in described components and parts database is loaded in described BOM table and derives.
In steps A, the described components and parts particular community that arranges specifically sets the association attributes needing the BOM derived in the attribute of schematic symbol.
In step B, the gauge outfit order of the BOM form that needs are arranged is: sequence number, quantity, material code, name of material, value value, encapsulation, producer, producer's item number.
A steps A 1 is also comprised: independently PCB is encapsulated storehouse, schematic symbol storehouse and material code system and read in each storehouse by a component management system and call relevant information and be integrated into a complete components and parts database before steps A.
The beneficial effect that technical scheme provided by the invention is brought is:
Directly available complete BOM information can be derived according to method of the present invention, deviser is undertaken producing by this BOM, material is standby produces, improve the promptness of BOM, high efficiency, save time, raise the efficiency.
In addition, invention also improves the systematicness of Component library holistic management, the maintenance efficiency that schematic symbol storehouse and PCB encapsulate storehouse is improved significantly, and also improves the efficiency of management and management quality.
Accompanying drawing explanation
In order to be illustrated more clearly in the technical scheme in the embodiment of the present invention, below the accompanying drawing used required in describing embodiment is briefly described, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is internal library johning knot composition of the present invention.
Fig. 2 is schematic symbol storehouse of the present invention.
Fig. 3 is that PCB of the present invention encapsulates storehouse.
Fig. 4 is BOM sheet format schematic diagram of the present invention.
Embodiment
For making the object, technical solutions and advantages of the present invention clearly, below in conjunction with accompanying drawing, embodiment of the present invention is described further in detail.
Embodiment one
The method containing particular community device Bill of Material (BOM) can be derived fast, comprise the following steps:
A, components and parts particular community is set; The association attributes needing the BOM derived is set in the attribute of schematic symbol.
B, BOM sheet format is set; The gauge outfit order of the BOM form that needs are arranged is: sequence number, quantity, material code, name of material, value value, encapsulation, producer, producer's item number.
C, connection components and parts database, components and parts database is according to information in components and parts in tables of data, encapsulate in storehouse at PCB respectively and transfer corresponding packaging information, in schematic symbol storehouse, call corresponding symbolic information, in material code system, call relevant producer, producer's item number and inventory information.
D, the information in described components and parts database is loaded in described BOM table and derives.
In steps A, described components and parts particular community is set specifically in step B,
As shown in Figure 1, components and parts are given corresponding schematic symbol by setting principle Symbol Database, use symbol of the same race, avoid design iterations, raise the efficiency for similar components and parts, better resource sharing.
As shown in Figure 2, components and parts are given corresponding schematic symbol by setting principle Symbol Database, use symbol of the same race, avoid design iterations, raise the efficiency for similar components and parts, better resource sharing.
As shown in Figure 3, PCB is set and encapsulates storehouse, set up encapsulation according to often kind of components and parts, use same package for different devices, avoid design iterations, raise the efficiency, better resource sharing;
PCB is set and encapsulates storehouse, set up pad according to often kind of components and parts, use identical pad for different devices, avoid design iterations, raise the efficiency, better resource sharing;
Setting data list item also comprises:
The path in corresponding schematic symbol storehouse, databook path and title are set.
As shown in Figure 4, BOM tables of data comprises sequence number, quantity, material code, name of material, value value, encapsulation, producer, producer's item number.
Embodiment two:
The difference of the present embodiment and embodiment one is: also comprise a steps A 1 before steps A: independently PCB is encapsulated storehouse, schematic symbol storehouse and material code system and read in each storehouse by a component management system and call relevant information and be integrated into a complete components and parts database.
The foregoing is only preferred embodiment of the present invention, not in order to limit the present invention, within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.

Claims (4)

1. can derive the method containing particular community device Bill of Material (BOM) fast, comprise the following steps:
A, components and parts particular community is set;
B, BOM sheet format is set;
C, connection components and parts database, components and parts database is according to information in components and parts in tables of data, encapsulate in storehouse at PCB respectively and transfer corresponding packaging information, in schematic symbol storehouse, call corresponding symbolic information, in material code system, call relevant producer, producer's item number and inventory information;
D, the information in described components and parts database is loaded in described BOM table and derives.
2. a kind of method that can derive fast containing particular community device Bill of Material (BOM) according to claim 1, it is characterized in that, in described steps A, the described components and parts particular community that arranges specifically sets the association attributes needing the BOM derived in the attribute of schematic symbol.
3. a kind of method that can derive fast containing particular community device Bill of Material (BOM) according to claim 1, it is characterized in that, in described step B, the gauge outfit order of the BOM form that needs are arranged is: sequence number, quantity, material code, name of material, value value, encapsulation, producer, producer's item number.
4. a kind of method that can derive fast containing particular community device Bill of Material (BOM) according to claim 1, it is characterized in that, before described steps A, also comprise a steps A 1: independently PCB is encapsulated storehouse, schematic symbol storehouse and material code system and read in each storehouse by a component management system and call relevant information and be integrated into a complete components and parts database.
CN201510307939.7A 2015-06-08 2015-06-08 Method capable of quickly deriving bill of material of components containing specific attributes Pending CN104915416A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201510307939.7A CN104915416A (en) 2015-06-08 2015-06-08 Method capable of quickly deriving bill of material of components containing specific attributes

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201510307939.7A CN104915416A (en) 2015-06-08 2015-06-08 Method capable of quickly deriving bill of material of components containing specific attributes

Publications (1)

Publication Number Publication Date
CN104915416A true CN104915416A (en) 2015-09-16

Family

ID=54084479

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201510307939.7A Pending CN104915416A (en) 2015-06-08 2015-06-08 Method capable of quickly deriving bill of material of components containing specific attributes

Country Status (1)

Country Link
CN (1) CN104915416A (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106408148A (en) * 2016-04-26 2017-02-15 浪潮电子信息产业股份有限公司 Subsystem and realization method of automatically leading out production specification based on SAP system
CN107944685A (en) * 2017-11-16 2018-04-20 郑州云海信息技术有限公司 A kind of method that packing list is automatically generated based on PLM system and SAP system
CN108228917A (en) * 2016-12-09 2018-06-29 展讯通信(上海)有限公司 Circuit diagram check device and method
CN109165227A (en) * 2018-07-25 2019-01-08 上海望友信息科技有限公司 Update/application method, system, medium and the terminal in EDA pad encapsulation library
CN109886623A (en) * 2019-01-30 2019-06-14 美林数据技术股份有限公司 The group packet processing method and device of product data

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103106563A (en) * 2013-02-05 2013-05-15 深圳杰科电器制造有限公司 Method and device for generating dedicated bill of material for producing printed circuit board

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103106563A (en) * 2013-02-05 2013-05-15 深圳杰科电器制造有限公司 Method and device for generating dedicated bill of material for producing printed circuit board

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106408148A (en) * 2016-04-26 2017-02-15 浪潮电子信息产业股份有限公司 Subsystem and realization method of automatically leading out production specification based on SAP system
CN108228917A (en) * 2016-12-09 2018-06-29 展讯通信(上海)有限公司 Circuit diagram check device and method
CN108228917B (en) * 2016-12-09 2021-08-03 展讯通信(上海)有限公司 Circuit schematic diagram inspection device and method
CN107944685A (en) * 2017-11-16 2018-04-20 郑州云海信息技术有限公司 A kind of method that packing list is automatically generated based on PLM system and SAP system
CN109165227A (en) * 2018-07-25 2019-01-08 上海望友信息科技有限公司 Update/application method, system, medium and the terminal in EDA pad encapsulation library
CN109165227B (en) * 2018-07-25 2022-02-11 上海望友信息科技有限公司 Method, system, medium and terminal for updating/applying EDA (electronic design automation) pad packaging library
CN109886623A (en) * 2019-01-30 2019-06-14 美林数据技术股份有限公司 The group packet processing method and device of product data

Similar Documents

Publication Publication Date Title
CN104915416A (en) Method capable of quickly deriving bill of material of components containing specific attributes
CN103677789B (en) Table data based on GRID components shows method and system
CN103729493B (en) The layout method of printed circuit board (PCB)
CN105045980A (en) Method for configuring component library in PCB
CN103810346A (en) Method for checking part height restrictions through ALLEGRO software
CN102929633B (en) For program transformation method and the system of SMT processing procedure
CN104216961A (en) Method and device for data processing
CN104572032A (en) Report creation method and electronic equipment
CN102298739A (en) Method for changing bill of materials (BOM) and apparatus thereof
CN105205038A (en) Complete material list table generation method and device
CN110245128B (en) Meta-model establishing method and device, storage medium and electronic device
CN103164573B (en) PDM managing and designing system
CN109992567A (en) One kind is based on the matched PCB package file search method of figure
CN108134812A (en) Data processing method and device
CN100498808C (en) Printing circuit board element height outputting method and device thereof
CN103853895A (en) Method and device for designing PCB (Printed Circuit Board)
CN102855305B (en) Data upgrading method and device
CN105573774A (en) Application parameter managing and configuring method
CN105405002A (en) Formula data configuration method and system based on SAP platform
CN102306163A (en) Dynamic integration technology based on B2B (business to business) platform
CN107085641A (en) A kind of quick positioning copper sheet void method in Allegro softwares
CN113705143B (en) Automatic simulation system and automatic simulation method
CN107644122A (en) A kind of ODB++ file modifications method, apparatus and readable storage medium storing program for executing
CN111708529A (en) Implementation method for generating form through dragging based on angular
CN102243663A (en) Dynamic labeling method based on electronic drawing

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20150916

WD01 Invention patent application deemed withdrawn after publication