Which table in the ERP database is of the unit type

Specific software analysis.

Oracle doesn't have this feature, but every ERP software has its own database dictionary.

It's better to send out the name of your ERP software, and there may be someone who can do it for you.

Oracle doesn't listen to which table it corresponds to, you can find out which table it corresponds to through the parser**.

The data table in the erp... You're really strong. An ERP system has thousands of tables, and you ask someone else to provide you with an ER diagram.

This is different for every ERP, right? . .

If there is an injection point, you can check it slowly little by little.

If there is no injection point, then I can't think of a way.

Let's see what database you're using!

Sales data? What kind of list do you see? Store pick-up? Channel allocation? Or wholesale.

The Query Analyzer, where you operate your ERP software and look at the output, will display all the sqlserver command statements.

You should first know which table in Oracle the form in ERP corresponds to. Every piece of software will have something like a data dictionary, just look it up.

You'll have to ask the database designer about that.

1 first of all, all of them are the three major tables, namely the balance sheet, income statement, cash flow statement, followed by the corresponding balance statement and auxiliary balance table, sequence account ledger, etc., these are the most basic financial audit data, others such as inventory purchase, sale and inventory, fixed assets list, purchase list, sales list, etc. are screened and obtained according to the audit needs, including the basic information involved in the audit process, such as ERP can be realized, and the basic information can be screened and obtained, which is required according to the actual audit process and such as operationAfter all, there are a lot of them, not every one of them is used, and the focus is to look at the audit evidence needed in the process to sort out and screen.

Structured Query Language (TLING) was originally developed by IBM's St. Joseph Research Lab for its relational database management system, System R, and its predecessor was the Square language. The SQL language is concise, powerful, and easy to learn, so it has been widely used since IBM was introduced in 1981. Nowadays, SQL language is supported as a query language in large database management systems such as Oracle, Sybase, Informix, and SQL Server, as well as database development systems commonly used on PCs such as Visual FoxPro and PowerBuilder.

Data Definition Language (DDL), such as create, drop, alter, and other statements.

Data manipulation language (DML), such as insert, update, and delete statements.

Data Query Language (DQL), such as the Select statement.

Data Control Language (DCL), such as Grant, Revoke, Commit, Rollback, and other statements.

The SQL language includes three main programming language categories of statements: Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL).

ERP is a type of system, not a database, and the databases in the world are basically SQL-92 syntax, but there are some nuances.

ERP is an enterprise resource management system, which can be understood as a set of software.

The database is a system that supports ERP backend data, generally including Oracle, SQL Server, etc., they all support structured query language SQL and other such as DDL DML DCL, DCL, etc.

At present, the mainstream is Oracle's PL SQL language, I hope it will help you!

ERP is a type of system, not a database.

Oracle, Oracle, MySQL, etc.