WO2019098428A1

WO2019098428A1 - Erp function provision method using user-specific expandable management table, and erp function provision system for performing same

Info

Publication number: WO2019098428A1
Application number: PCT/KR2017/013202
Authority: WO
Inventors: 이상철
Original assignee: (주) 더존비즈온
Priority date: 2017-11-20
Filing date: 2017-11-20
Publication date: 2019-05-23
Also published as: KR20190058740A; KR102160795B1

Abstract

Disclosed are a system and a method having no effect on other users even when a specific user adds a new data field to a predetermined ERP function. According to one aspect of the present invention, provided is an ERP function provision method using a user-specific expandable management table, comprising the steps of: (a) providing, by an ERP function provision system, a DB including a common management table and expandable management tables respectively corresponding to a plurality of users, wherein the common management table stores description information relating to a common data field handled by each of a plurality of ERP functions; (b) storing, in an expandable management table corresponding to a first target user, by the ERP function provision system, description information relating to a new data field newly added to a predetermined first target ERP function by a terminal of the first target user, who is any one of the plurality of users; and (c) providing the first ERP function to the terminal of the first target user on the basis of the common management table and the expandable management table corresponding to the first target user.

Description

An ERP function providing method using an expandable management table for each user and an ERP function providing system performing the method

The present invention relates to an ERP function providing method using an expandable management table for each user and an ERP function providing system for performing the same. More specifically, even if a specific user adds a new data field to a predetermined ERP function, And more particularly,

Recently, with the development of computer technology, there is an increasing trend of introducing enterprise resource planning (ERP) solution software, which is a computer system for business management and management. Using these ERP solution software, companies will deal with a lot of data needed for the management and management of the company, such as finance, production and inventory.

Data handled in the ERP solution is stored and managed in the form of data tables with various fields. In a typical ERP solution, it is common to include all the functions that should be provided to all users in the enterprise using the solution. If any of the functions are missing, the entire solution can be treated as an incomplete solution.

Therefore, despite the fact that the type of data handled by each company or department is different and the type of data to be handled / managed by the target company to which the company / department is dealing is slightly different, as described above, The data table is used only for a specific user, and any user does not include any items that are not used at all, so that the size of the data table is excessively large and the usability is deteriorated.

SUMMARY OF THE INVENTION The present invention has been made in an effort to solve the above problems, and it is an object of the present invention to provide a system and a method for adding a data field to an ERP function so that a specific user does not affect other users even if the ERP function is customized will be.

It is also possible to group several ERP functions that have similar functions or can be grouped into one category, and provide a technical idea that allows to add data fields in group units.

According to an aspect of the present invention, there is provided a method for providing an ERP function using an expandable management table for each user, the method comprising: (a) providing a common management table and a DB including an expandable management table corresponding to each of a plurality of users, Wherein the common management table stores description information on a common data field handled by each of a plurality of ERP functions, (b) the ERP function providing system comprises: 1) storing description information on a new data field newly added to a predetermined first target ERP function by a terminal of a target user in an expandable management table corresponding to the first target user; and (c) Based on a table and an expandable management table corresponding to the first target user, The ERP provides the function comprises the step of providing to the user terminal is provided.

In one embodiment, the step (b) may be further performed at least once before the step (c) is performed.

In one embodiment, the ERP function providing system may transmit description information about a new data field newly added to a predetermined second target ERP function by a terminal of a second target user, which is one of the plurality of users, 2 target user based on the common management table and an expandable management table corresponding to the second target user, and storing the second ERP function in the expandable management table corresponding to the second user, To the terminal of the second target user.

In one embodiment, the scalable management table comprises a group management master table and a function management table, wherein step (b) comprises: (b-1) selecting the first target ERP function and the at least one other ERP function (B-2) generating predetermined information corresponding to the new data field to be applied to the ERP function group, in response to the generation command, in response to the generating command of the new data field to be applied to the ERP function group including the ERP function group (B-3) receiving an additional command for adding the new data field to the first target ERP function; and (b-4) adding, in response to the additional command, Generating new information corresponding to the new data field, wherein the step (b-2) comprises the steps of: generating identification information of the new data field; Obtaining a group common description information of the new data field including a data type and a data type, and adding a new master record corresponding to the new data field to a group management master table, The identification information of the new data field, and the group common description information of the new data field, wherein the key of the new master record is identification information of the ERP function group and identification information of the new data field, Wherein the step (b-4) comprises: obtaining function description description information of the new data field to be added to the first target ERP function; and adding the function applying description information to the new target data field to be added to the first target ERP function Adding a corresponding new reference information record to the function management table, Wherein the information record includes identification information of the first target ERP function and identification information of the new data field and function application description information of a new data field to be added to the first target ERP function, Is identification information of the target ERP function and identification information of the new data field.

In one embodiment, the expandable management table further includes a group management detail table, and in the step (b-2), when the type of the new data field is a list, Further comprising: generating a record corresponding to the new list item in response to receiving an additional command of the item and in response to an additional command of the new list item, wherein the step of generating a record corresponding to the new list item , Generating identification information of the new list item, acquiring description information of the new list item including the item name of the new list item, adding a new detail record corresponding to the new list item to the group management detail table Wherein the new detail record comprises identification information of the ERP function group , Identification information of the new data field, identification information of the new list item, and description information of the new list item, wherein the key of the new detail record includes identification information of the ERP function group, identification information of the new data field And identification information of the new list item.

According to another aspect of the present invention, there is provided a computer program installed in a data processing apparatus for performing the above-described method.

According to another aspect of the present invention there is provided an ERP function provisioning system comprising a processor and a memory in which a program is stored, wherein the program, when executed by the processor, causes the ERP function providing system to perform the method An ERP function provision system is provided.

According to another aspect of the present invention, there is provided a DB including a common management table and an extensible management table corresponding to each of a plurality of users, wherein the common management table includes a common data field handled by each of a plurality of ERP functions Storing description information of a new target data item in a first target ERP function by a terminal of a first target user which is one of a plurality of users, And a providing module for providing the first ERP function to the terminal of the first target user based on the common management table and the expandable management table corresponding to the first target user An ERP function providing system is provided.

In one embodiment, the storage module stores description information on a new data field to be added to the first target ERP function by the terminal of the first target user in an expandable management table corresponding to the first target user Can be performed at least once.

In one embodiment, the storage module stores description information about a new data field newly added to a predetermined second target ERP function by a terminal of a second target user, which is one of the plurality of users, Wherein the provisioning module stores the second ERP function in the expandable management table corresponding to the user based on the common management table and the expandable management table corresponding to the second target user, And can provide it to the terminal.

In one embodiment, the scalable management table includes a group management master table and a function management table, wherein the storage module comprises: (b-1) a first target ERP function and at least one other ERP function (B-2) generating predetermined information corresponding to the new data field to be applied to the ERP function group, in response to the generation command, the new data field to be applied to the ERP function group; (b-3) receiving an additional command for adding the new data field to the first target ERP function; and (b-4) receiving, in response to the additional command, Wherein the step (b-2) comprises: generating identification information of the new data field; generating a new field corresponding to a field name of the new data field, Obtaining a group common description information of the new data field including a data type and a data type, and adding a new master record corresponding to the new data field to a group management master table, The identification information of the new data field, and the group common description information of the new data field, wherein the key of the new master record is identification information of the ERP function group and identification information of the new data field, Wherein the step (b-4) comprises: obtaining function description description information of the new data field to be added to the first target ERP function; and adding the function applying description information to the new target data field to be added to the first target ERP function Adding a corresponding new reference information record to the function management table, Wherein the quasi information record includes identification information of the first target ERP function and identification information of the new data field and function application description information of a new data field to be added to the first target ERP function, And the key is the identification information of the target ERP function and the identification information of the new data field.

In the conventional ERP system, when a data field is added to a specific ERP function provided by the ERP system according to a request of a specific user, the change of the DB table due to the addition of the field is implemented to be applied to all users using the ERP system It was common. Therefore, there is a problem that the corresponding data field is displayed even to users who do not need the added data field. To solve this problem, there is a problem that it is necessary to set a separate field for designating whether or not to use each user. There is a problem that it becomes large and complicated.

According to an embodiment of the present invention, a system and a method may be provided in which a specific user adds a data field to an ERP function to customize the corresponding ERP function but does not affect other users.

In addition, it is possible to group various ERP functions that have similar functions or can be grouped into one category, and it is possible to add data fields in group units, thereby enhancing development efficiency and work productivity.

BRIEF DESCRIPTION OF THE DRAWINGS A brief description of each drawing is provided to more fully understand the drawings recited in the description of the invention.

1 is a diagram illustrating an operating environment of an ERP function providing system according to an embodiment of the present invention.

2 is a diagram illustrating an example of a hierarchical structure of an ERP function group and an ERP function included therein.

FIG. 3 is a view schematically showing a table included in a DB according to an embodiment of the present invention.

4 is a block diagram schematically illustrating the structure of an ERP function providing system according to an embodiment of the present invention.

5 is a diagram illustrating a specific configuration of an extensible table according to an embodiment of the present invention.

6A is a diagram showing an example of the structure of a master record.

6B is a diagram showing an example of the structure of the detail record.

6C is a diagram showing an example of the structure of a reference information record.

7 is a diagram illustrating an example of an ERP function UI.

8 is a flowchart specifically illustrating a process of storing description information on a new data field in an expandable management table.

9 is a diagram showing an example of a UI for adding / modifying / deleting a master record.

FIG. 10 is a flowchart illustrating a detailed procedure of step S110 of FIG.

11 is a diagram showing an example of a UI for adding / modifying / deleting a detail record.

FIG. 12 is a flowchart illustrating the detailed procedure of step S130 of FIG.

13 is a diagram showing an example of a UI for adding / modifying / deleting a reference information record.

14 is a diagram showing an example of an ERP function to which a new data field is added.

BRIEF DESCRIPTION OF THE DRAWINGS The present invention is capable of various modifications and various embodiments, and specific embodiments are illustrated in the drawings and described in detail in the detailed description. It is to be understood, however, that the invention is not to be limited to the specific embodiments, but includes all modifications, equivalents, and alternatives falling within the spirit and scope of the invention. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, the present invention will be described in detail with reference to the accompanying drawings.

The terms first, second, etc. may be used to describe various components, but the components should not be limited by the terms. The terms are used only for the purpose of distinguishing one component from another.

The terminology used in this application is used only to describe a specific embodiment and is not intended to limit the invention. The singular expressions include plural expressions unless the context clearly dictates otherwise.

In this specification, the terms "comprises" or "having" and the like refer to the presence of stated features, integers, steps, operations, elements, components, or combinations thereof, But do not preclude the presence or addition of features, numbers, steps, operations, components, parts, or combinations thereof.

Also, in this specification, when any one element 'transmits' data to another element, the element may transmit the data directly to the other element, or may be transmitted through at least one other element And may transmit the data to the other component. Conversely, when one element 'directly transmits' data to another element, it means that the data is transmitted to the other element without passing through another element in the element.

Hereinafter, the present invention will be described in detail with reference to the embodiments of the present invention with reference to the accompanying drawings. Like reference symbols in the drawings denote like elements.

Referring to FIG. 1, an ERP function providing system 100 may provide a plurality of ERP functions to a user. ERP services can be integrated into an ERP system and can be a unit function that has its own meaning. The ERP function can perform functions of managing, manipulating, using and analyzing enterprise information, and can provide a customized user interface (UI) so that a user can perform such functions. That is, the user can manage, manipulate, use and analyze enterprise information through the UI provided by the ERP function.

Examples of ERP functions are customer management, product management, credit management, cost element management, journal entry, book management, account change management, bond age analysis / management, settlement management, Management of income tax, management of daily taxation, establishment of domestic sales plan / management of taxation, management of taxation report, financial account management, etc.), personnel management, attendance management, salary management, social insurance management, Management, quotation / order processing, referral / inspection management, delivery / return processing, sales contribution analysis, delivery / delivery management, temporary delivery / consignment management, sales settlement, electronic tax bill processing, collection / bond management, bond age analysis, export Purchase / Settlement Management, Shipping / Receipt Management, Processing of Import Costs, Disposition Settlement Processing, Distribution of Revenue Costs, MPS, Calculation of Required Material, Request / Ordering, Goods Receipt Request / Inspection, Temporary Goods Receipt Management, Purchase Production / Disposal Management (LOT), Production Planning / Management, In-house Production Management, Confusion Process Management, By-product / Disassembly Management, Production Management, Input Production Management, Outsourced Production Management, Service Reception / Processing , Service bond management, financial / profit analysis, profit / profit analysis, major fund analysis, logistics / fish summary analysis, sales analysis by characteristics, seasonal / quarterly production performance analysis, characteristic time attendance analysis, salary / bonus simulation, contract management , Site management, contracting / outsourcing management, work daily reports, prepayment / unpaid management, labor equipment management, finishing settlement management, labor report management, outsourcing management, and cost benefit management. Of course.

In one embodiment, the ERP function provisioning system 100 may group and manage a plurality of ERP functions, which may have similar characteristics or be grouped into one category, in an ERP function group.

2, a plurality of ERP function groups (for example, an ERP function group A and an ERP function group B) may be designated in the ERP function providing system 100, and each of the ERP function groups May include a plurality of ERP functions. For example, an ERP function group A is an ERP function A-1, an ERP function A-2, ... , ERP function A-N, and ERP function group B may include ERP function B-1, ERP function B-2, ... , And an ERP function B-M.

Of course, depending on the embodiment, the concept of the ERP function group may not be applied.

Referring again to FIG. 1, a plurality of users can subscribe to a service provided by the ERP function providing system 100, and the ERP function providing system 100 includes a terminal 300 (for example, a 300- 1 to < RTI ID = 0.0 > 300-N). &Lt; / RTI >

The user may be an individual, but may be a corporation or a corporation. In the latter case, people belonging to the same organization can be regarded as the same user. The ERP function providing system 100 can identify a user by a user ID input from the terminal connected to the ERP function providing system 100.

The ERP function providing system 100 may operate the predetermined ERP solution software or operate in conjunction with a predetermined ERP solution system (not shown) or may be included in the ERP solution system to provide the ERP function to the user terminal 300 . The ERP solution system is a computer system for business management and management. It can be an integrated system that integrates the management resources of various management systems that are operated independently across all sectors of the company such as personnel, finance, and production. In addition, the ERP solution monitors the flow and usage of various resources in the enterprise, collects and interprets data related to accounting, sales, and inventory management to efficiently manage management resources, As shown in FIG.

Meanwhile, the user terminal 300 may be a computing device capable of executing software. The user terminal 300 may be a computing device including a computer, a laptop, a desktop, a tablet PC, and a PDA (Personal Digital Assistant), and may be a mobile phone, a satellite phone, Local Loop) station, a smartphone, a wireless computing device including a handheld device having other wireless connection capabilities, or a processing device coupled to another wireless modem.

Meanwhile, the DB 200 may store enterprise data corresponding to each user, and may store various information that the ERP function providing system 100 should refer to in order to provide an ERP function to each user.

Here, the DB (DataBase) may be implemented as at least one table, and further includes a separate DBMS (Database Management System) for searching, storing, and managing information stored in the DB 200 It can also be used as a meaning. In addition, it can be implemented in various ways such as a linked-list, a tree, and a relational DB, and includes all data storage media and data structures capable of storing information to be stored in the DB 200 Can be used to mean.

FIG. 3 is a view schematically showing a table included in the DB 200 according to an embodiment of the present invention. As shown in FIG. 3, the DB 200 may include a common management table 210 and expandable management tables 220-1 to 220-N corresponding to a plurality of users, respectively. The common management table is a table commonly applied to all users, and each extensible table is a table applied to the corresponding user.

The common management table 210 may store description information on a common data field handled by each of a plurality of ERP functions.

Each ERP function provided by the ERP function providing system 100 can only handle a common data field initially (i.e., before being customized by the user). That is, the ERP function provided to each user by the ERP function providing system 100 may have only the same common data field.

Individual users may then add additional data fields needed by themselves to the ERP function, but data fields added by a particular user may not be reflected to other users. Thus, the user can customize the ERP function to suit his / her intended use.

The description information on the data field may be various information necessary to implement or express the data field. For example, the description information of the data field includes identification information of the corresponding data field, name, type and / or data type of the data that can be browsed / input / modified by the corresponding data field, information about the group (E.g., identification information of the group) and / or information on the ERP function to which the corresponding data field is to be applied (e.g., identification information of the ERP function), and may include an initial value Whether or not the field should be displayed in the UI corresponding to the ERP function (whether or not it is displayed), whether the corresponding data field is used in the ERP function (whether or not the data field is used), whether or not the corresponding data field is modifiable by the user SQL query information that takes as input the data that is input through the field, descriptive information about the data field, the scope to which the data field applies And the like. In addition, the description information on the data field may further include various information such as the appearance of the UI component corresponding to the corresponding data field, information on the display order, and the like.

4 is a block diagram schematically illustrating the structure of an ERP function providing system 100 according to an embodiment of the present invention.

Referring to FIG. 4, the ERP function providing system 100 may include a storage module 110 and a providing module 120.

According to an embodiment of the present invention, some of the above-described components may not necessarily correspond to components necessary for implementation of the present invention, and the ERP function providing system 100 may further include, Of course, may include more components. For example, the ERP function provisioning system 100 may include functions and / or functions of other configurations (e.g., the storage module 110 and / or the provision module 120) included in the ERP function provision system 100, Or a control module (not shown) capable of controlling a resource.

The ERP function providing system 100 may include hardware resources and / or software necessary to implement the technical idea of the present invention, and it is understood that the ERP function providing system 100 necessarily means one physical component or one device It is not. That is, the ERP function providing system 100 may mean a logical combination of hardware and / or software provided to implement the technical idea of the present invention. If necessary, May be implemented as a set of logical structures for implementing the technical idea of the present invention. In addition, the ERP function providing system 100 may mean a set of configurations separately implemented for each function or role for implementing the technical idea of the present invention. For example, the storage module 110 and / or the providing module 120 may be located in different physical devices, or may be located in the same physical device. Further, according to an embodiment, the detailed configurations of modules such as the storage module 110 and / or the providing module 120 are also located in different physical devices, and detailed configurations located in different physical devices are organized So as to realize the functions performed by the respective modules.

In this specification, a module may mean a functional and structural combination of hardware for carrying out the technical idea of the present invention and software for driving the hardware. For example, the module may mean a logical unit of a predetermined code and a hardware resource for executing the predetermined code, and it does not necessarily mean a physically connected code or a kind of hardware. It can easily be deduced to a technician.

The storage module 110 may store description information on a new data field newly added to a predetermined ERP function by one of a plurality of users (target users) in an expandable management table corresponding to the target user .

For example, the storage module 110 may store description information about a new data field newly added to the ERP function B-1 (see FIG. 2) by the terminal 300-1 of the first user, Can be stored in the scalable management table 220-1 corresponding to the mobile terminal 300-1. Also, the storage module 110 stores the description information about the new data field added to the ERP function A-2 (see FIG. 2) by the terminal 300-2 of the second user to the second user 300- 2) in the expandable management table 220-2.

In addition, a plurality of new data fields may be added to the ERP function, and the storage module 110 stores description information about the new data field corresponding to the user whenever a new data field is added to the ERP function by the user Can be stored in an extensible management table.

The storage module 110 may perform the functions described above for each user and each ERP function.

5 is a diagram showing a specific configuration of an expandable table 220 according to an embodiment of the present invention.

Referring to FIG. 5, the extensible management table 220 may include a group management master table 221 and a function management table 223. According to an embodiment, the scalable management table 220 may further include a group management detail table 222.

The group management master table 221 may store a master record corresponding to each data field.

6A is a diagram showing an example of the structure of a master record.

6A, the master record may include identification information (ID) of an ERP function group to which a data field is applied, identification information (ID) of the data field, identification information (ID) of an ERP function group, The identification information (ID) of the data field may be a key of the master record.

The master record may further include group common description information. The group common description information may include a name (field name) of a data field, a type of a data field, a data type, an initial value, necessity, whether or not the data is modified, whether or not to use the data, description, SQL and related table information. According to an embodiment, the group common description information may include less or more information.

The name (field name) of the data field may be a name displayed on the label of the corresponding data field.

The form of the data field is information on the type of data that can be read / input / modified by the corresponding data field, and may be a general type, character type, numeric type, date type, ratio type, date type, period type, A list type having a plurality of specified items, and the like, but is not limited thereto.

The data type is information on the type of storage space in which data is to be stored, and can be defined as the type of data to be stored in the storage space and the size of the storage space.

The default value may refer to an initial value that is predetermined by the system before data is assigned by the user.

Whether the data field is required to be displayed in the ERP function or not is whether the corresponding data field is used in the ERP function. Whether or not the data field is modified is determined by the user. And whether or not it is possible.

The SQL information is SQL query information that takes data inputted through the corresponding data field as a parameter, and the description may mean descriptive information about the corresponding data field. The related table may be information about the table to be referred to.

On the other hand, the group management detail table 222 may store corresponding list items corresponding to the selectable detail records in the specific data field. The detail record may be a record for each list item that can be entered in the data field if the form of the data field is list type.

6B is a diagram showing an example of the structure of the detail record.

6B, the detail record may include identification information (ID) of an ERP function group to which the corresponding data field is applied, identification information (ID) of the data field, and identification information (ID) The identification information (ID) of the ERP function group, the identification information (ID) of the data field, and the identification information (ID) of the list item may be keys of the detail record.

The detail record may further include list item description information. The list item description information may include the name (item name) of the list item, whether or not the item is used, an applicable range, an applied company, and explanation information. According to an embodiment, the list item description information may include more or less information.

The coverage is information about the scope of the company to which the list item applies (for example, an affiliate), for example, it may be the entire company or a selected company. If the scope is a selected company, information about which company is selected can be entered in the applicable company column.

The information included in the records stored in the group management master table 221 and the group management detail table 222 is commonly applied to all ERP functions included in the ERP function group corresponding to the ERP function group ID of the record Information.

Alternatively, information applied only to individual ERP functions may be stored in the function management detail table 223. [ That is, the function management detail table 223 may store a reference information record corresponding to each data field.

Referring to FIG. 6C, the reference information record may include identification information (ID) of an ERP function to which a data field is applied, identification information (ID) of the data field, identification information (ID) The identification information (ID) of the data field may be the key of the reference information record.

The reference information record may further include function description description information. The function description description information may include a tab number, a display order number, an application range, and applicable company information. According to an embodiment, the function description description information may include less or more information.

The tab number is information on how many tabs the corresponding data field should be displayed when the ERP function to which the corresponding data field is applied has a plurality of tabs, and the display order number is a case where the ERP function to which the corresponding data field is applied has a plurality of data fields And information about how many times the corresponding data field should be displayed.

Hereinafter, a UI provided by the ERP function providing system 100 and a process performed by the storage module 110 when a user desires to add a new data field to a predetermined target ERP function will be described.

7 is a diagram illustrating an example of an ERP function UI for providing a predetermined target ERP function. 7 shows a UI of a target ERP function for registering and managing a customer. Hereinafter, an ERP function to be provided to the first user (the user corresponding to the first user terminal 300-1) A process of adding a new data field having a name will be described. Meanwhile, it is assumed that the target ERP function of FIG. 7 belongs to an ERP function group named 'company standard management'.

FIG. 8 is a diagram illustrating an example of a case where the storage module 110 stores descriptive information about a new data field newly added to the target ERP function by a target user (i.e., a first user) In the expandable management table 220-1.

Referring to FIG. 8, the storage module 110 may receive a command to generate the new data field to be applied to the ERP function group to which the target ERP function belongs (i.e., 'company standard management') (S100).

To this end, the ERP function providing system 100 may provide the UI as shown in FIG. 9 to the terminal 300-1 of the target user (i.e., the first user).

The UI shown in FIG. 9 may display information on previously registered data fields, and may include a UI component for receiving a generation command of a new data field.

In response to the generation command, the storage module 110 may generate predetermined information corresponding to the new data field to be applied to the ERP function group (S110). Referring to FIG. 10, do.

The storage module 110 may then receive an additional command to add the new data field to the target ERP function (S120).

To this end, the ERP function providing system 100 may provide the UI as shown in FIG. 13 to the terminal 300-1 of the target user (i.e., the first user).

The UI shown in FIG. 13 may display information about previously registered data fields, and may include a UI component for receiving a generation command of a new data field.

In response to the additional command, the storage module 110 may generate predetermined information corresponding to the new data field to be added to the target ERP function (S130). Referring to FIG. 12, .

FIG. 10 is a flowchart illustrating a detailed procedure of step S110 of FIG.

Referring to FIG. 10, the storage module 110 may generate identification information of the new data field (S111). In one embodiment, the identification information of the new data field in one group management master table 220 may be unique. Or a combination of the identification information of the new data field and the identification information of the ERP function group to which the new data field is to be applied in one group management master table 220 may be unique.

Meanwhile, the storage module 120 may obtain the group common description information of the new data field including the field name, the type, and the data type of the new data field (S112).

In one embodiment, the storage module 120 may obtain the group common description information of the new data field through the UI as shown in FIG.

9, a new row having the identification information (management item code) of the data field M004 can be created on the UI, and the item name (management item name, management item name 2) can be generated through each column of the generated new row, , Data type (management item type), data type (type), basic value, necessity or the like can be inputted.

Referring again to FIG. 10, the storage module 110 may add a new master record corresponding to the new data field to the group management master table 220 (S113).

At this time, the new master record may include identification information of the ERP function group, identification information (M0004) of the new data field, and group common description information of the new data field. Also, the key of the new master record may be identification information of the ERP function group and identification information of the new data field.

Meanwhile, if the data type of the new data field is designated as a list type, the storage module 110 may receive an additional command of a new list item that can be input to the new data field (S114, S115). To this end, the ERP function providing system 100 can provide the UI as shown in FIG. 11 to the terminal 300-1 of the target user (i.e., the first user).

The UI shown in FIG. 11 can display information about previously registered list items, and can include a UI component for receiving a command for generating a new list item. The user can input a command for generating a new list item on the UI as shown in Fig.

Referring again to FIG. 10, the storage module 110 may generate a record corresponding to the new list item, in response to an addition instruction of the new list item.

More specifically, the storage module 110 may generate identification information of the new list item (S116).

Also, the storage module 110 may obtain description information of the new list item including the item name of the new list item. In one embodiment, the storage module 120 may obtain the description information of the new list item through the UI as shown in FIG.

As shown in FIG. 11, a new row having identification information (management detail code) of a list item 100 can be created on the UI, and an item name (management history name, management history name 2), an application range, an application company, a description, and the like.

Referring again to FIG. 10, the storage module 110 may add a new detail record corresponding to the new list item to the group management detail table (S118).

Here, the new detail record includes unique identification information of the ERP function group, unique identification information of the new data field, unique identification information of the new list item, and description information of the new list item, May be unique identification information of the ERP function group, unique identification information of the new data field, and unique identification information of the new list item.

12 is a flowchart illustrating a detailed process of step S130 of FIG.

Referring to FIG. 12, the storage module 110 may obtain function description description information of the new data field to be added to the target ERP function (S131).

In one embodiment, the storage module 120 may obtain the function description description information of the new data field through the UI as shown in FIG.

As shown in FIG. 13, a new row having identification information (management item code) of the data field M004 can be created on the UI, and tab numbers (tabs), display order numbers, The application scope, and the application company description information of the function can be inputted. On the other hand, as shown in FIG. 13, the UI for acquiring the function description information includes various information in the master record related to the new data field previously registered in the ERP function group to which the ERP function belongs (for example, Identification information of the data field, identification information of the data field, item name, type, data type, etc.) can be obtained and can be displayed in an unchangeable state.

The storage module 110 may add a new reference information record corresponding to the new data field to be added to the target ERP function to the function management table (S132).

Wherein the new reference information record includes identification information of the target ERP function, identification information of the new data field, and function application description information of a new data field to be added to the target ERP function, May be the identification information of the target ERP function and the identification information of the new data field.

4, the providing module 120 transmits an ERP function to the target user's terminal (user) based on the common management table and an expandable management table corresponding to any one of a plurality of users As shown in FIG.

For example, the providing module 120 may refer to the group management master table, the group management detail table, and the function management table included in the common management table 210 and the expandable table 220-1 corresponding to the first user The ERP function may be implemented based on the obtained description information, and the implemented ERP function may be provided to the terminal 300-1 of the first user. Also, the providing module 120 provides the ERP function to the terminal 300-2 of the second user based on the common management table 210 and the expandable table 220-2 corresponding to the second user You may.

The providing module 120 may perform the functions described above for each user and each ERP function.

FIG. 14 shows the UI of the ERP function provided by the providing module 12 after a new data field ('customer location') has been added by the example described with reference to FIG. 8 to FIG.

Meanwhile, according to an embodiment, the ERP function providing system 100 may include a processor and a memory for storing a program executed by the processor. The processor may include a single-core CPU or a multi-core CPU. The memory 11 may include a high speed random access memory and may include non-volatile memory such as one or more magnetic disk storage devices, flash memory devices, or other non-volatile solid state memory devices. Access to the memory by the processor and other components can be controlled by the memory controller. Here, when the program is executed by a processor, the program may cause the ERP function providing system 100 according to the present embodiment to perform the above-described method of providing an expandable table.

Meanwhile, the method for providing an extensible table according to an embodiment of the present invention may be implemented in the form of computer-readable program instructions and stored in a computer-readable recording medium. A computer-readable recording medium includes all kinds of recording apparatuses in which data that can be read by a computer system is stored.

Program instructions to be recorded on a recording medium may be those specially designed and constructed for the present invention or may be available to those skilled in the art of software.

Examples of the computer-readable recording medium include magnetic media such as a hard disk, a floppy disk and a magnetic tape, optical media such as CD-ROM and DVD, a floptical disk, And hardware devices that are specially configured to store and execute program instructions such as magneto-optical media and ROM, RAM, flash memory, and the like. The above-mentioned medium may also be a transmission medium such as a light or metal wire, wave guide, etc., including a carrier wave for transmitting a signal designating a program command, a data structure and the like. The computer readable recording medium may also be distributed over a networked computer system so that computer readable code can be stored and executed in a distributed manner.

Examples of program instructions include machine language code such as those produced by a compiler, as well as devices for processing information electronically using an interpreter or the like, for example, a high-level language code that can be executed by a computer.

The hardware devices described above may be configured to operate as one or more software modules to perform the operations of the present invention, and vice versa.

It will be understood by those skilled in the art that the foregoing description of the present invention is for illustrative purposes only and that those of ordinary skill in the art can readily understand that various changes and modifications may be made without departing from the spirit or essential characteristics of the present invention. will be.

It is therefore to be understood that the above-described embodiments are illustrative in all aspects and not restrictive. For example, each component described as a single entity may be distributed and implemented, and components described as being distributed may also be implemented in a combined form.

It is intended that the present invention covers the modifications and variations of this invention provided they come within the scope of the appended claims and their equivalents. .

The present invention can be used in an ERP system.

Claims

A method for providing an ERP function using an expandable management table for each user,

(a) providing an ERP function providing system with a DB including a common management table and an extensible management table corresponding to each of a plurality of users, wherein the common management table is shared by a plurality of ERP functions Storing description information about a data field;

(b) the ERP function providing system transmits description information on a new data field newly added to a predetermined first target ERP function by a terminal of a first target user, which is one of a plurality of users, In an extensible management table corresponding to the database; And

(c) providing the first ERP function to the terminal of the first target user based on the common management table and the scalable management table corresponding to the first target user.
The method according to claim 1,

Further comprising the step (b) being performed at least once before the step (c) is performed.
The method according to claim 1,

Wherein the ERP function providing system is adapted to send description information on a new data field newly added to a predetermined second target ERP function by a terminal of a second target user which is one of the plurality of users to the second target user To a scalable management table; And

The ERP function providing system further comprises providing the second ERP function to the terminal of the second target user based on the common management table and the scalable management table corresponding to the second target user, Method of providing function.
The method according to claim 1,

Wherein the scalable management table includes a group management master table and a function management table,

The step (b)

(b-1) receiving a generation command of the new data field to be applied to an ERP function group including the first target ERP function and at least one other ERP function;

(b-2) generating, in response to the generation command, predetermined information corresponding to the new data field to be applied to the ERP function group;

(b-3) receiving an additional command for adding the new data field to the first target ERP function; And

(b-4) generating, in response to the additional instruction, predetermined information corresponding to the new data field to be added to the first target ERP function,

The step (b-2)

Generating identification information of the new data field;

Obtaining group common description information of the new data field including a field name, a type, and a data type of the new data field; And

Adding a new master record corresponding to the new data field to a group management master table, the new master record including identification information of the ERP function group, identification information of the new data field, Wherein the key of the new master record is identification information of the ERP function group and identification information of the new data field,

The step (b-4)

Obtaining function description description information of the new data field to be added to the first target ERP function; And

Adding a new reference information record to the function management table corresponding to the new data field to be added to the first target ERP function, the new reference information record including identification information of the first target ERP function, And a function application description information of a new data field to be added to the first target ERP function, wherein a key of the new reference information record is identification information of the target ERP function and identification information of the new data field, And an ERP function.
5. The method of claim 4,

Wherein the expandable management table further includes a group management detail table,

The step (b-2)

Receiving an additional command of a new list item inputable in the new data field if the type of the new data field is a list; And

Further comprising the step of generating a record corresponding to the new list item in response to an addition instruction of the new list item,

Wherein the step of generating a record corresponding to the new list item comprises:

Generating identification information of the new list item;

Obtaining description information of the new list item including an item name of the new list item;

Adding a new detail record corresponding to the new list item to a group management detail table, the new detail record including identification information of the ERP function group, identification information of the new data field, identification information of the new list item, Wherein the key of the new detail record includes identification information of the ERP function group, identification information of the new data field, and identification information of the new list item. .
A computer program for performing the method according to any one of claims 1 to 5, installed in a data processing apparatus.
An ERP function providing system,

A processor; And a memory in which the program is stored,

Wherein the program causes the ERP function providing system to perform the method according to any one of claims 1 to 5 when executed by the processor.
A DB including a common management table and an extensible management table corresponding to each of a plurality of users, wherein the common management table stores description information about common data fields handled by each of a plurality of ERP functions;

The description information on the new data field newly added to the predetermined first target ERP function by the terminal of the first target user, which is one of the plurality of users, is stored in the expandable management table corresponding to the first target user Storage module; And

And a provision module for providing the first ERP function to the terminal of the first target user based on the common management table and the scalable management table corresponding to the first target user.
9. The method of claim 8,

Wherein the storage module comprises:

An ERP that performs at least one more process of storing description information on a new data field to be added to the first target ERP function by the terminal of the first target user in an expandable management table corresponding to the first target user; Function providing system.
9. The method of claim 8,

Wherein the storage module comprises:

The description information about the new data field newly added to the predetermined second target ERP function by the terminal of the second target user which is one of the plurality of users is stored in the expandable management table corresponding to the second target user and,

The providing module includes:

And provides the second ERP function to the terminal of the second target user based on the common management table and the scalable management table corresponding to the second target user.
9. The method of claim 8,

Wherein the scalable management table includes a group management master table and a function management table,

Wherein the storage module comprises:

(b-1) receiving a generation command of the new data field to be applied to an ERP function group including the first target ERP function and at least one other ERP function;

(b-2) generating, in response to the generation command, predetermined information corresponding to the new data field to be applied to the ERP function group;

(b-3) receiving an additional command for adding the new data field to the first target ERP function; And

(b-4) in response to the additional command, generating predetermined information corresponding to the new data field to be added to the first target ERP function,

The step (b-2)

Generating identification information of the new data field;

Obtaining group common description information of the new data field including a field name, a type, and a data type of the new data field; And

Adding a new master record corresponding to the new data field to a group management master table, the new master record including identification information of the ERP function group, identification information of the new data field, Wherein the key of the new master record is identification information of the ERP function group and identification information of the new data field,

The step (b-4)

Obtaining function description description information of the new data field to be added to the first target ERP function; And

Adding a new reference information record to the function management table corresponding to the new data field to be added to the first target ERP function, the new reference information record including identification information of the first target ERP function, And a function application description information of a new data field to be added to the first target ERP function, wherein a key of the new reference information record is identification information of the target ERP function and identification information of the new data field, And an ERP function providing system.
12. The method of claim 11,

Wherein the expandable management table further includes a group management detail table,

The step (b-2)

Receiving an additional command of a new list item inputable in the new data field if the type of the new data field is a list; And

Further comprising the step of generating a record corresponding to the new list item in response to an addition instruction of the new list item,

Wherein the step of generating a record corresponding to the new list item comprises:

Generating identification information of the new list item;

Obtaining description information of the new list item including an item name of the new list item;

Adding a new detail record corresponding to the new list item to a group management detail table, the new detail record including identification information of the ERP function group, identification information of the new data field, identification information of the new list item, Wherein the key of the new detail record includes identification information of the ERP function group, identification information of the new data field, and identification information of the new list item. .