WO2019098428A1 - Procédé de fourniture de fonction erp faisant appel à une table de gestion extensible spécifique à un utilisateur, et système de fourniture de fonction erp permettant la mise en œuvre dudit procédé - Google Patents

Procédé de fourniture de fonction erp faisant appel à une table de gestion extensible spécifique à un utilisateur, et système de fourniture de fonction erp permettant la mise en œuvre dudit procédé Download PDF

Info

Publication number
WO2019098428A1
WO2019098428A1 PCT/KR2017/013202 KR2017013202W WO2019098428A1 WO 2019098428 A1 WO2019098428 A1 WO 2019098428A1 KR 2017013202 W KR2017013202 W KR 2017013202W WO 2019098428 A1 WO2019098428 A1 WO 2019098428A1
Authority
WO
WIPO (PCT)
Prior art keywords
data field
new
erp function
erp
function
Prior art date
Application number
PCT/KR2017/013202
Other languages
English (en)
Korean (ko)
Inventor
이상철
Original Assignee
(주) 더존비즈온
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 (주) 더존비즈온 filed Critical (주) 더존비즈온
Publication of WO2019098428A1 publication Critical patent/WO2019098428A1/fr

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00—Arrangements for software engineering
    • G06F8/70—Software maintenance or management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44—Arrangements for executing specific programs

Definitions

  • 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,
  • ERP enterprise resource planning
  • ERP Transactional resource planning
  • data handled in the ERP solution is stored and managed in the form of data tables with various fields.
  • 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.
  • 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.
  • 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.
  • a method for providing an ERP function using an expandable management table for each user 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.
  • the step (b) may be further performed at least once before the step (c) is performed.
  • 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.
  • the scalable management table comprises a group management master table and a function management table
  • 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
  • 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
  • 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
  • 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
  • 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 installed in a data processing apparatus for performing the above-described method.
  • 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.
  • a DB including a common management table and an extensible management table corresponding to each of a plurality of users
  • 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
  • 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
  • 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.
  • 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,
  • 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.
  • the scalable management table includes a group management master table and a function management table
  • 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,
  • 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 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
  • 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
  • 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 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.
  • FIG. 1 is a diagram illustrating an operating environment of an ERP function providing system according to an embodiment of the present invention.
  • FIG. 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.
  • FIG. 4 is a block diagram schematically illustrating the structure of an ERP function providing system according to an embodiment of the present invention.
  • FIG. 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.
  • FIG. 7 is a diagram illustrating an example of an ERP function UI.
  • FIG. 8 is a flowchart specifically illustrating a process of storing description information on a new data field in an expandable management table.
  • FIG. 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.
  • 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.
  • FIG. 13 is a diagram showing an example of a UI for adding / modifying / deleting a reference information record.
  • FIG. 14 is a diagram showing an example of an ERP function to which a new data field is added.
  • 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 element 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.
  • FIG. 1 is a diagram illustrating an operating environment of an ERP function providing system according to an embodiment of the present invention.
  • 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.
  • UI user interface
  • 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 / Disass,
  • 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.
  • FIG. 2 is a diagram illustrating an example of a hierarchical structure of an ERP function group and an ERP function included therein.
  • a plurality of ERP function groups may be designated in the ERP function providing system 100, and each of the ERP function groups May include a plurality of ERP functions.
  • an ERP function group A is an ERP function A-1, an ERP function A-2, ... , ERP function A-N
  • ERP function group B may include ERP function B-1, ERP function B-2, ... , And an ERP function B-M.
  • 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.
  • 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.
  • a computing device including a computer, a laptop, a desktop, a tablet PC, and a PDA (Personal Digital Assistant)
  • PDA Personal Digital Assistant
  • 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.
  • the DB 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.
  • DBMS Database Management System
  • 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.
  • 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.
  • the description information on the data field may be various information necessary to implement or express the data field.
  • 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.
  • the description information on the data field may further include various information such as the appearance of the UI component corresponding to the corresponding
  • FIG. 4 is a block diagram schematically illustrating the structure of an ERP function providing system 100 according to an embodiment of the present invention.
  • the ERP function providing system 100 may include a storage module 110 and a providing module 120.
  • the ERP function providing system 100 may further include, Of course, may include more components.
  • 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.
  • 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.
  • 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 .
  • 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.
  • 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.
  • FIG. 5 is a diagram showing a specific configuration of an expandable table 220 according to an embodiment of the present invention.
  • the extensible management table 220 may include a group management master table 221 and a function management table 223.
  • 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.
  • 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,
  • ID identification information
  • ID identification information 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.
  • 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.
  • 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)
  • ID identification information
  • 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.
  • the function management detail table 223 may store a reference information record corresponding to each data field.
  • 6C is a diagram showing an example of the structure of a reference information record.
  • 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)
  • ID identification information
  • ID identification information of the data field
  • ID identification information of the data field
  • 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
  • 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
  • FIG. 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.
  • 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.
  • 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.
  • 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).
  • 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.
  • 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).
  • 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.
  • 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.
  • the storage module 110 may generate identification information of the new data field (S111).
  • the identification information of the new data field in one group management master table 220 may be unique.
  • 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.
  • 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).
  • the storage module 120 may obtain the group common description information of the new data field through the UI as shown in FIG.
  • 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.
  • the storage module 110 may add a new master record corresponding to the new data field to the group management master table 220 (S113).
  • 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.
  • the key of the new master record may be identification information of the ERP function group and identification information of the new data field.
  • 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).
  • 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.
  • 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.
  • the storage module 110 may generate identification information of the new list item (S116).
  • the storage module 110 may obtain description information of the new list item including the item name of the new list item.
  • the storage module 120 may obtain the description information of the new list item through the UI as shown in FIG.
  • 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.
  • the storage module 110 may add a new detail record corresponding to the new list item to the group management detail table (S118).
  • 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.
  • step S130 of FIG. 12 is a flowchart illustrating a detailed process of step S130 of FIG.
  • the storage module 110 may obtain function description description information of the new data field to be added to the target ERP function (S131).
  • the storage module 120 may obtain the function description description information of the new data field through the UI as shown in FIG.
  • 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.
  • 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).
  • 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.
  • 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.
  • 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.
  • 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 is a diagram showing an example of an ERP function to which a new data field is added.
  • 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.
  • 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.
  • the program 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.
  • 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.
  • 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.
  • the present invention can be used in an ERP system.

Abstract

L'invention concerne un système et un procédé n'ayant aucun effet sur d'autres utilisateurs même lorsqu'un utilisateur spécifique ajoute un nouveau champ de données à une fonction ERP prédéfinie. Selon un aspect, la présente invention concerne un procédé de fourniture de fonction ERP faisant appel à une table de gestion extensible spécifique à un utilisateur, comprenant les étapes consistant : (a) à fournir, par un système de fourniture de fonction ERP, une base de données comprenant une table de gestion commune et des tables de gestion extensibles correspondant respectivement à une pluralité d'utilisateurs, la table de gestion commune stockant des informations de description associées à un champ de données commun traité par chaque fonction ERP d'une pluralité de fonctions ERP; (b) à stocker, dans une table de gestion extensible correspondant à un premier utilisateur cible, par le système de fourniture de fonction ERP, des informations de description concernant un nouveau champ de données nouvellement ajouté à une première fonction ERP cible prédéfinie par un terminal du premier utilisateur cible, qui est l'un quelconque de la pluralité d'utilisateurs; et (c) à fournir la première fonction ERP au terminal du premier utilisateur cible sur la base de la table de gestion commune et de la table de gestion extensible correspondant au premier utilisateur cible.
PCT/KR2017/013202 2017-11-20 2017-11-20 Procédé de fourniture de fonction erp faisant appel à une table de gestion extensible spécifique à un utilisateur, et système de fourniture de fonction erp permettant la mise en œuvre dudit procédé WO2019098428A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
KR10-2017-0154904 2017-11-20
KR1020170154904A KR102160795B1 (ko) 2017-11-20 2017-11-20 사용자 별 확장 가능 관리 테이블을 이용한 erp 펑션 제공 방법 및 이를 수행하는 erp 펑션 제공 시스템

Publications (1)

Publication Number Publication Date
WO2019098428A1 true WO2019098428A1 (fr) 2019-05-23

Family

ID=66538641

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/KR2017/013202 WO2019098428A1 (fr) 2017-11-20 2017-11-20 Procédé de fourniture de fonction erp faisant appel à une table de gestion extensible spécifique à un utilisateur, et système de fourniture de fonction erp permettant la mise en œuvre dudit procédé

Country Status (2)

Country Link
KR (1) KR102160795B1 (fr)
WO (1) WO2019098428A1 (fr)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR102240891B1 (ko) * 2019-10-01 2021-04-16 (주) 더존비즈온 다차원 분석 리포트 생성 방법 및 시스템
KR102544559B1 (ko) * 2022-11-24 2023-06-21 주식회사 인젠트 일원화 방식의 금융 단말기의 인터페이스 화면 자동 생성 장치 및 방법

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20100081448A (ko) * 2009-01-06 2010-07-15 주식회사 영림원소프트랩 전사적 자원 관리 시스템에서의 화면등록 마법사를 이용한 업무 화면 자동 생성 방법
KR20120043856A (ko) * 2010-10-27 2012-05-07 현대중공업 주식회사 기업자원관리 프로그램용 메뉴화면 운영시스템
JP2014059666A (ja) * 2012-09-14 2014-04-03 Hitachi Systems Ltd 業務入力画面カスタマイズシステム
KR20150061739A (ko) * 2013-11-28 2015-06-05 주식회사 영림원소프트랩 전사적 자원 관리 시스템에서의 새로운 업무용 화면을 개발하는 방법
KR101614908B1 (ko) * 2015-09-18 2016-04-22 (주)트러시스 Erp 서비스제공시스템 및 그 방법

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20100081448A (ko) * 2009-01-06 2010-07-15 주식회사 영림원소프트랩 전사적 자원 관리 시스템에서의 화면등록 마법사를 이용한 업무 화면 자동 생성 방법
KR20120043856A (ko) * 2010-10-27 2012-05-07 현대중공업 주식회사 기업자원관리 프로그램용 메뉴화면 운영시스템
JP2014059666A (ja) * 2012-09-14 2014-04-03 Hitachi Systems Ltd 業務入力画面カスタマイズシステム
KR20150061739A (ko) * 2013-11-28 2015-06-05 주식회사 영림원소프트랩 전사적 자원 관리 시스템에서의 새로운 업무용 화면을 개발하는 방법
KR101614908B1 (ko) * 2015-09-18 2016-04-22 (주)트러시스 Erp 서비스제공시스템 및 그 방법

Also Published As

Publication number Publication date
KR20190058740A (ko) 2019-05-30
KR102160795B1 (ko) 2020-10-05

Similar Documents

Publication Publication Date Title
WO2018097407A1 (fr) Procédé et système de partage de fonctions erp définies par l'utilisateur
WO2014065444A1 (fr) Système de collaboration utilisant un réseau public ouvert
US20090063386A1 (en) Systems and methods for linking an issue with an entry in a knowledgebase
WO2016047995A1 (fr) Système et procédé pour un service de consultation de clients en temps réel par le biais d'un réseau de communication de données
TW201405452A (zh) 工作流程管理裝置及工作流程管理方法
WO2019098428A1 (fr) Procédé de fourniture de fonction erp faisant appel à une table de gestion extensible spécifique à un utilisateur, et système de fourniture de fonction erp permettant la mise en œuvre dudit procédé
WO2020122291A1 (fr) Appareil et procédé d'automatisation d'instructions de travail de gestion d'immeuble d'appartements se basant sur l'intelligence artificielle
JP2003323528A (ja) 人事管理システムおよびその方法
WO2023042949A1 (fr) Dispositif électronique pour fournir des informations d'article, et procédé associé
WO2019216565A1 (fr) Équipement terminal pour effectuer une opération de gestion et de partage de réactif, son procédé de commande et support d'enregistrement lisible par un dispositif de traitement numérique pour la mise en œuvre de ce dernier
WO2021066231A1 (fr) Procédé et système de recommandation de requête sql
WO2023243964A1 (fr) Système de gestion d'événements utilisant des badges intelligents
JP2020529652A (ja) システム中にユーザー／従業員がメールボックスアカウントを取得する方法
WO2018097361A1 (fr) Procédé de création de fonctions erp définies par l'utilisateur et système informatique d'exécution associé
WO2023080284A1 (fr) Procédé de fourniture d'informations relatives à un article de location, et dispositif électronique l'utilisant
JP2020052951A (ja) ヘルプ情報表示システム、ヘルプ情報表示方法及びヘルプ情報表示プログラム
CN101320415A (zh) 应用程序的控管模块与其方法
JP2015103007A (ja) 運用レポート管理システムおよび運用レポート管理プログラム
WO2016036050A1 (fr) Procédé publicitaire permettant de procurer des clients et de développer une base de clients au moyen d'un contenu
US5386555A (en) Data processing system having a plurality of units in which design of the system can be changed by simple definition
WO2018212536A1 (fr) Dispositif de fourniture d'informations numériques détaillées de contenu
WO2024101843A1 (fr) Système de gouvernance de données et procédé de gestion de données pour système de gouvernance de données
WO2010011073A2 (fr) Procédé et système de transaction d'annonce publicitaire ouverte, et procédé et système de transaction d'annonce publicitaire reposant sur des unités de ventes
JP2000181954A (ja) データ処理システム
WO2023182556A1 (fr) Dispositif électronique et procédé de traitement d'informations pour le calcul de salaire sur la base de l'exécution de tâches de travailleur

Legal Events

Date Code Title Description
122 Ep: pct application non-entry in european phase

Ref document number: 17932400

Country of ref document: EP

Kind code of ref document: A1