SchemaSpy Analysis of orclqss.ADEMPIERE340 Hosted by Idalica
Compiled by GlobalQSS
Using SchemaSpy
SourceForge.net Logo
Database Type: Oracle - Oracle Database 10g Release 10.2.0.1.0 - Production

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

617 Tables and 111 Views:

Table Children Parents Rows Comments
AD_ACCESSLOG 2 0 Log of Access to the System
AD_ALERT 2 1 1 Adempiere Alert
AD_ALERTPROCESSOR 2 1 1 Alert Processor/Server Parameter
AD_ALERTPROCESSORLOG 1 0 Result of the execution of the Alert Processor
AD_ALERTRECIPIENT 3 1 Recipient of the Alert Notification
AD_ALERTRULE 2 1 Definition of the alert element
AD_ARCHIVE 3 0 Document Archive
AD_ATTACHMENT 1 1 2 Attachment for the document
AD_ATTACHMENTNOTE 2 0 Personal Attachment Note
AD_ATTRIBUTE 1 4 0 System Attribute
AD_ATTRIBUTE_VALUE 1 0 AD_Attribute_Value
AD_CHANGELOG 3 0 Log of data changes
AD_CHANGELOG_V view
AD_CLIENT 67 1 2 Client/Tenant for this installation.
AD_CLIENTINFO 17 2 AD_ClientInfo
AD_CLIENTSHARE 3 0 Client Share
AD_COLOR 3 1 0 Color for backgrounds or indicators
AD_COLUMN 21 9 13,335 Column in the table
AD_COLUMN_ACCESS 3 0 AD_Column_Access
AD_COLUMN_TRL 2 13,335 Column in the table
AD_DESKTOP 2 2 1 Collection of Workbenches
AD_DESKTOPWORKBENCH 2 1 Desktop Workbench
AD_DESKTOP_TRL 2 1 Collection of Workbenches
AD_DOCUMENT_ACTION_ACCESS 3 1,064 Define access to document type / document action / role combinations.
AD_ELEMENT 4 1 2,406 System Element enables the central maintenance of column description and help.
AD_ELEMENT_TRL 2 2,406 System Element enables the central maintenance of column description and help.
AD_ENTITYTYPE 37 7 System Entity Type
AD_ERROR 1 0 Error
AD_FIELD 4 9 11,792 Field on a database table
AD_FIELDGROUP 2 1 36 Logical grouping of fields
AD_FIELDGROUP_TRL 2 36 Logical grouping of fields
AD_FIELD_TRL 2 11,792 Field on a database table
AD_FIELD_V view
AD_FIELD_VT view
AD_FIND 1 0 Find
AD_FORM 10 1 21 Special Form
AD_FORM_ACCESS 2 58 AD_Form_Access
AD_FORM_TRL 2 21 Special Form
AD_IMAGE 6 1 11 System Image or Icon
AD_IMPFORMAT 3 1 10 Import Format
AD_IMPFORMAT_ROW 2 61 Format Field
AD_INFOCOLUMN 1 4 0 Info Column
AD_INFOCOLUMN_TRL 2 0 Info Window Column
AD_INFOWINDOW 2 2 0 Info Window
AD_INFOWINDOW_TRL 2 0 Info and search/select Window
AD_ISSUE 9 0 System Issue
AD_LABELPRINTER 2 0 Label Printer Definition
AD_LABELPRINTERFUNCTION 1 1 0 Function of Label Printer
AD_LANGUAGE 48 2 95 Language ID
AD_LDAPACCESS 3 0 Ldap Access Log
AD_LDAPPROCESSOR 2 1 1 LDAP Server
AD_LDAPPROCESSORLOG 1 0 LDAP Server Log
AD_MENU 3 9 474 Identifies a Menu
AD_MENU_TRL 2 474 Identifies a Menu
AD_MESSAGE 5 3 1,250 System Message
AD_MESSAGE_TRL 2 1,250 System Message
AD_MIGRATIONSCRIPT 0 Migration Scripts for the System
AD_MODELVALIDATOR 1 0 Global Model Validator
AD_MODIFICATION 1 0 Modification
AD_NOTE 4 0 System Notice
AD_ORG 121 1 3 Organizational entity within client
AD_ORGINFO 6 3 Organization Info
AD_ORGTYPE 1 1 3 Organization Type allows you to categorize your organizations
AD_ORG_V view
AD_PACKAGE_EXP 0 AD_Package_Exp_ID
AD_PACKAGE_EXP_COMMON 10 0 AD_Package_Exp_Common_ID
AD_PACKAGE_EXP_DETAIL 12 0 AD_Package_Exp_Detail_ID
AD_PACKAGE_IMP 0 AD_Package_Imp_ID
AD_PACKAGE_IMP_BACKUP 2 0 AD_Package_Imp_Backup_ID
AD_PACKAGE_IMP_DETAIL 0 AD_Package_Imp_Detail_ID
AD_PACKAGE_IMP_INST 0 Packages Installed
AD_PACKAGE_IMP_PROC 0 AD_Package_Imp_Proc_ID
AD_PINSTANCE 11 2 0 Instance of the process
AD_PINSTANCE_LOG 1 0 (Non Standard Table)
AD_PINSTANCE_PARA 1 0 AD_PInstance_Para
AD_PREFERENCE 4 13 Personal Preference
AD_PRINTCOLOR 17 20 Color used for printing and display
AD_PRINTFONT 4 66 Maintain Print Font
AD_PRINTFORM 11 2 Form
AD_PRINTFORMAT 16 7 36 Data Print Format
AD_PRINTFORMATITEM 7 6 1,254 Item/Column in the Print format
AD_PRINTFORMATITEM_TRL 2 1,254 Item/Column in the Print format
AD_PRINTGRAPH 1 7 0 Graph included in Reports
AD_PRINTLABEL 1 2 0 Label Format to print
AD_PRINTLABELLINE 1 3 0 Print Label Line Format
AD_PRINTLABELLINE_TRL 2 0 Print Label Line Format
AD_PRINTPAPER 1 4 Printer paper definition
AD_PRINTTABLEFORMAT 1 8 2 Table Format in Reports
AD_PRIVATE_ACCESS 2 0 AD_Private_Access
AD_PROCESS 19 4 261 Process or Report
AD_PROCESS_ACCESS 4 730 Process Access
AD_PROCESS_PARA 5 6 626 Process Parameter
AD_PROCESS_PARA_TRL 2 626 Process Parameter Trl
AD_PROCESS_TRL 2 261 Process or Report
AD_RECORD_ACCESS 2 0 AD_Record_Access
AD_REFERENCE 15 3 329 System Reference (Pick List)
AD_REFERENCE_TRL 2 329 System Reference and Validation
AD_REF_LIST 2 4 885 Reference List based on Table
AD_REF_LIST_TRL 2 885 Reference List based on Table
AD_REF_TABLE 7 119 Reference Table Definitions
AD_REGISTRATION 3 0 System Registration
AD_REPLICATION 1 3 1 Data Replication Target
AD_REPLICATIONSTRATEGY 2 1 1 Data Replication Strategy
AD_REPLICATIONTABLE 1 3 473 Data Replication Strategy Table Info
AD_REPLICATION_LOG 2 0 Data Replication Log Details
AD_REPLICATION_RUN 1 1 0 Data Replication Run
AD_REPORTVIEW 5 2 66 View used to generate this report
AD_REPORTVIEW_COL 2 0 Report view Column
AD_ROLE 23 6 4 Responsibility Role
AD_ROLE_ORGACCESS 2 6 AD_Role_OrgAccess
AD_RULE 1 1 0 Rule
AD_SCHEDULER 3 2 1 Schedule Processes
AD_SCHEDULERLOG 1 0 Result of the execution of the Scheduler
AD_SCHEDULERRECIPIENT 3 0 Recipient of the Scheduler Notification
AD_SCHEDULER_PARA 2 2 AD_Scheduler_Para
AD_SEQUENCE 6 2 914 Document Sequence
AD_SEQUENCE_AUDIT 4 0 AD_Sequence_Audit
AD_SEQUENCE_NO 3 0 AD_Sequence_No
AD_SESSION 3 1 0 User Session Online or Web
AD_SYSCONFIG 1 16 System Configurator
AD_SYSTEM 2 1 System Definition
AD_TAB 8 11 709 Tab within a Window
AD_TABLE 44 6 681 Table for the Fields
AD_TABLE_ACCESS 4 1 AD_Table_Access
AD_TABLE_SCRIPTVALIDATOR 2 0 Script model validator for tables
AD_TABLE_TRL 2 681 Database Table information
AD_TAB_TRL 2 709 Tab within a Window
AD_TAB_V view
AD_TAB_VT view
AD_TASK 8 3 3 Operation System Task
AD_TASKINSTANCE 3 0 Task Instance
AD_TASK_ACCESS 4 3 AD_Task_Access
AD_TASK_TRL 2 3 Operation System Task
AD_TREE 36 23 Identifies a Tree
AD_TREEBAR 2 20 User Selected tree nodes
AD_TREENODE 1 392 Tree Node
AD_TREENODEBP 1 8 Tree Node BP
AD_TREENODECMC 1 5 Tree Node CM Container
AD_TREENODECMM 1 3 Tree Node CM Media
AD_TREENODECMS 1 5 Tree Node CM Stage
AD_TREENODECMT 1 5 Tree Node CM Template
AD_TREENODEMM 1 480 Tree Node MM
AD_TREENODEPR 1 27 Tree Node PR
AD_TREENODEU1 1 0 User defined tree 1
AD_TREENODEU2 1 0 User defined tree 2
AD_TREENODEU3 1 0 User defined tree 3
AD_TREENODEU4 1 0 User defined tree 4
AD_USER 94 8 7 User within the system - Internal or Business Partner Contact
AD_USERBPACCESS 2 0 User/concat access to Business Partner information and resources
AD_USERDEF_FIELD 2 0 User defined Field
AD_USERDEF_TAB 1 2 0 User defined Tab
AD_USERDEF_WIN 1 4 0 User defined Window
AD_USERMAIL 3 1 Mail sent to the user
AD_USERQUERY 3 0 Saved User Query
AD_USER_ORGACCESS 2 0 AD_User_OrgAccess
AD_USER_ROLES 4 7 AD_User_Roles
AD_USER_ROLES_V view
AD_USER_SUBSTITUTE 2 0 Substitute of the user
AD_VAL_RULE 5 3 167 Dynamic Validation Rule
AD_WF_ACTIVITY 2 7 0 Workflow Activity
AD_WF_ACTIVITYRESULT 1 0 Result of the Workflow Process Activity
AD_WF_BLOCK 1 1 0 Workflow Transaction Execution Block
AD_WF_EVENTAUDIT 5 0 Workflow Process Activity Event Audit Information
AD_WF_NEXTCONDITION 3 1 Workflow Node Transition Condition
AD_WF_NODE 8 14 140 Workflow Node (activity), step or process
AD_WF_NODENEXT 1 5 112 Workflow Node Transition
AD_WF_NODE_PARA 3 1 Workflow Node Execution Parameter
AD_WF_NODE_TRL 2 140 Workflow Node (activity), step or process
AD_WF_PROCESS 4 8 0 Actual Workflow Process Instance
AD_WF_PROCESSDATA 1 0 Workflow Process Context
AD_WF_RESPONSIBLE 5 4 2 Responsible for Workflow Execution
AD_WINDOW 17 5 277 Data entry or display window
AD_WINDOW_ACCESS 4 737 AD_Window_Access
AD_WINDOW_TRL 2 277 Data entry or display window
AD_WINDOW_VT view
AD_WORKBENCH 6 4 1 Collection of windows, reports
AD_WORKBENCHWINDOW 6 2 Workbench Window
AD_WORKBENCH_TRL 2 1 Collection of windows, reports
AD_WORKFLOW 13 7 30 Workflow or combination of tasks
AD_WORKFLOWPROCESSOR 2 1 1 Workflow Processor Server
AD_WORKFLOWPROCESSORLOG 1 0 Result of the execution of the Workflow Processor
AD_WORKFLOW_ACCESS 4 89 AD_Workflow_Access
AD_WORKFLOW_TRL 2 30 Workflow or combination of tasks
ASP_CLIENTEXCEPTION 9 0 Client Exception
ASP_CLIENTLEVEL 2 0 Client Level
ASP_FIELD 3 0 ASP Field
ASP_FORM 2 0 ASP Form
ASP_LEVEL 9 1 0 ASP Level
ASP_MODULE 2 0 ASP Module
ASP_PROCESS 2 0 ASP Process
ASP_PROCESS_PARA 3 0 ASP Process Parameter
ASP_TAB 3 0 ASP Tab
ASP_TASK 2 0 ASP Task
ASP_WINDOW 2 0 ASP Window
ASP_WORKFLOW 2 0 ASP Workflow
A_ASSET 15 12 0 Asset used internally or by customers
A_ASSET_ACCT 3 0
A_ASSET_ADDITION 1 2 0
A_ASSET_CHANGE 1 3 0
A_ASSET_CHANGE_AMT 2 0
A_ASSET_DELIVERY 4 0 Delivery of Asset
A_ASSET_GROUP 3 1 Group of Assets
A_ASSET_GROUP_ACCT 3 0
A_ASSET_RETIREMENT 1 2 0 Internally used asset is not longer used.
A_ASSET_USE 1 0
A_DEPRECIATION 2 0
A_REGISTRATION 1 4 0 User Asset Registration
A_REGISTRATIONATTRIBUTE 2 2 0 Asset Registration Attribute
A_REGISTRATIONPRODUCT 2 0 Registration Product
A_REGISTRATIONVALUE 2 0 A_RegistrationValue
B_BID 4 0 Bid for a Topic
B_BIDCOMMENT 2 0 Make a comment to a Bid Topic
B_BUYER 2 1 0 B_Buyer
B_BUYERFUNDS 1 4 0 Buyer Funds for Bids on Topics
B_OFFER 4 0 Offer for a Topic
B_SELLER 2 1 0 B_Seller
B_SELLERFUNDS 1 4 0 Seller Funds from Offers on Topics
B_TOPIC 3 2 0 Auction Topic
B_TOPICCATEGORY 1 1 0 Auction Topic Category
B_TOPICTYPE 2 3 0 Auction Topic Type
CM_ACCESSCONTAINER 2 0 Web Access Container
CM_ACCESSLISTBPGROUP 2 0 Web Access BP Group
CM_ACCESSLISTROLE 2 0 Web Access Role
CM_ACCESSMEDIA 2 0 Web Access Media
CM_ACCESSNEWSCHANNEL 2 0 Web Access NewsChannel
CM_ACCESSPROFILE 6 0 Web Access Profile
CM_ACCESSSTAGE 2 0 Web Access Stage
CM_AD 2 0 An Advertisement is something like a banner
CM_AD_CAT 2 1 0 Advertisement Categories define rotations and ad blocks
CM_BROADCASTSERVER 1 1 0 Web Broadcast Server
CM_CHAT 2 2 0 Chat
CM_CHATENTRY 2 4 0 Chat Entry
CM_CHATTYPE 2 1 0 Chat Type
CM_CHATTYPEUPDATE 2 0 Chat Type Update
CM_CHATUPDATE 2 0 Chat Update
CM_CONTAINER 7 3 5 Web Container contains content like images, text etc.
CM_CONTAINERTTABLE 2 0 Container Template Table
CM_CONTAINER_ELEMENT 1 1 6 Container element i.e. Headline, Content, Footer etc.
CM_CONTAINER_ELEMENT_TRL 2 6 Container element i.e. Headline, Content, Footer etc.
CM_CONTAINER_TRL 2 5 Web Container contains content like images, text etc.
CM_CONTAINER_URL 1 0 Contains info on used URLs
CM_CSTAGE 5 3 5 Container Stage contains the staging content like images, text etc.
CM_CSTAGETTABLE 2 0 Containet Stage Template Table
CM_CSTAGE_ELEMENT 1 1 7 Container element i.e. Headline, Content, Footer etc.
CM_CSTAGE_ELEMENT_TRL 2 7 Container element i.e. Headline, Content, Footer etc.
CM_CSTAGE_TRL 2 5 Web Container Stage contains the staging content like images, text etc.
CM_MEDIA 4 1 3 Contains media content like images, flash movies etc.
CM_MEDIADEPLOY 2 0 Media Deployment Log
CM_MEDIA_SERVER 1 1 1 Media Server list to which content should get transfered
CM_NEWSCHANNEL 2 2 0 News channel for rss feed
CM_NEWSITEM 1 0 News item or article defines base content
CM_TEMPLATE 4 1 4 Template defines how content is displayed
CM_TEMPLATETABLE 2 2 0 CM Template Table Link
CM_TEMPLATE_AD_CAT 2 0 Get together the Template and the Advertising Category
CM_WEBACCESSLOG 4 0 Web Access Log
CM_WEBPROJECT 12 4 1 A web project is the main data container for Containers, URLs, Ads, Media etc.
CM_WEBPROJECT_DOMAIN 2 1 Web Project Domain handling
CM_WIKITOKEN 1 0 Wiki Token
C_ACCTPROCESSOR 1 3 1 Accounting Processor/Server Parameters
C_ACCTPROCESSORLOG 1 0 Result of the execution of the Accounting Processor
C_ACCTSCHEMA 39 6 1 Rules for accounting
C_ACCTSCHEMA_DEFAULT 58 1 C_AcctSchema_Default
C_ACCTSCHEMA_ELEMENT 14 6 Acct.Schema Element
C_ACCTSCHEMA_GL 9 1 C_AcctSchema_GL
C_ACTIVITY 27 0 Business Activity
C_ALLOCATIONHDR 1 1 3 Payment allocation
C_ALLOCATIONLINE 2 6 3 Allocation Line
C_BANK 2 1 1 Bank
C_BANKACCOUNT 11 2 2 Account at the Bank
C_BANKACCOUNTDOC 2 1 Checks, Transfers, etc.
C_BANKACCOUNT_ACCT 14 2 C_BankAccount_Acct
C_BANKSTATEMENT 2 1 2 Bank Statement of account
C_BANKSTATEMENTLINE 1 6 2 Line on a statement from this Bank
C_BANKSTATEMENTLOADER 1 0 Definition of Bank Statement Loader (SWIFT, OFX)
C_BANKSTATEMENTMATCHER 0 Algorithm to match Bank Statement Info to Business Partners, Invoices and Payments
C_BPARTNER 75 17 8 Identifies a Business Partner
C_BPARTNER_LOCATION 23 5 8 Identifies the (ship to) address for this Business Partner
C_BPARTNER_PRODUCT 2 1 Product Business Partner
C_BP_BANKACCOUNT 2 3 1 Bank Account of the Business Partner
C_BP_CUSTOMER_ACCT 4 8 C_BP_Customer_Acct
C_BP_EDI 1 3 0 Electronic Data Interchange
C_BP_EMPLOYEE_ACCT 4 8 C_BP_Employee_Acct
C_BP_GROUP 7 6 3 Business Partner Group
C_BP_GROUP_ACCT 14 3 Business Partner Group Acct
C_BP_RELATION 4 1 Business Partner Relation
C_BP_VENDOR_ACCT 5 8 C_BP_Vendor_Acct
C_BP_WITHHOLDING 2 0 C_BP_Withholding
C_CALENDAR 6 2 1 Accounting Calendar Name
C_CAMPAIGN 26 1 2 Marketing Campaign
C_CASH 1 8 3 Cash Journal
C_CASHBOOK 3 1 2 Cash Book for recording petty cash transactions
C_CASHBOOK_ACCT 7 2 C_CashBook_Acct
C_CASHLINE 3 5 5 Cash Journal Line
C_CHANNEL 1 1 2 Sales Channel
C_CHARGE 18 2 2 Additional document charges
C_CHARGE_ACCT 4 2 C_Charge_Acct
C_CITY 1 4 1 City
C_COMMISSION 2 3 1 Commission
C_COMMISSIONAMT 1 2 0 Generated Commission Amount
C_COMMISSIONDETAIL 4 0 Supporting information for Commission Amounts
C_COMMISSIONLINE 1 7 1 Commission Line
C_COMMISSIONRUN 1 1 0 Commission Run or Process
C_CONVERSIONTYPE 11 4 Currency Conversion Rate Type
C_CONVERSION_RATE 1 5 7 Rate used for converting currencies
C_COUNTRY 12 5 241 Country
C_COUNTRY_TRL 2 241 Country
C_CURRENCY 49 2 174 The Currency for this record
C_CURRENCY_ACCT 6 0 C_Currency_Acct
C_CURRENCY_TRL 2 174 The Currency for this record
C_CYCLE 1 1 2 Identifier for this Project Reporting Cycle
C_CYCLEPHASE 2 10 C_CyclePhase
C_CYCLESTEP 1 1 4 The step for this Cycle
C_DOCTYPE 31 8 38 Document type or rules
C_DOCTYPECOUNTER 2 1 Counter Document Relationship
C_DOCTYPE_TRL 2 38 Document type or rules
C_DUNNING 3 2 Dunning Rules for overdue invoices
C_DUNNINGLEVEL 3 3 2 Dunning Level
C_DUNNINGLEVEL_TRL 2 2 Dunning Level Trl
C_DUNNINGRUN 1 1 0 Dunning Run
C_DUNNINGRUNENTRY 1 6 0 Dunning Run Entry
C_DUNNINGRUNLINE 4 0 Dunning Run Line
C_DUNNING_HEADER_V view
C_DUNNING_HEADER_VT view
C_DUNNING_LINE_V view
C_DUNNING_LINE_VT view
C_ELEMENT 3 3 1 Accounting Element
C_ELEMENTVALUE 52 5 364 Account Element
C_ELEMENTVALUE_TRL 2 364 Account Element
C_GREETING 4 1 Greeting to print on correspondence
C_GREETING_TRL 2 1 Greeting to print on correspondence
C_INTERORG_ACCT 5 0 C_InterOrg_Acct
C_INVOICE 24 24 8 Invoice Identifier
C_INVOICEBATCH 1 3 0 Expense Invoice Batch Header
C_INVOICEBATCHLINE 15 0 Expense Invoice Batch Line
C_INVOICELINE 15 21 24 Invoice Detail Line
C_INVOICELINE_V view
C_INVOICEPAYSCHEDULE 1 2 2 Invoice Payment Schedule
C_INVOICESCHEDULE 1 1 Schedule for generating Invoices
C_INVOICETAX 2 8 C_InvoiceTax
C_INVOICE_CANDIDATE_V view
C_INVOICE_HEADER_V view
C_INVOICE_HEADER_VT view
C_INVOICE_LINETAX_V view
C_INVOICE_LINETAX_VT view
C_INVOICE_V view
C_INVOICE_V1 view
C_JOB 4 1 4 Position
C_JOBASSIGNMENT 2 0 Position Assignment
C_JOBCATEGORY 1 4 Position Category
C_JOBREMUNERATION 2 0 Position Remuneration
C_LANDEDCOST 5 0 Landed Cost
C_LANDEDCOSTALLOCATION 4 0 Landed Cost Allocation
C_LOCATION 22 5 13 Location or Address
C_NONBUSINESSDAY 3 1 Day on which business is not transacted
C_ORDER 20 29 7 Order
C_ORDERLINE 10 22 25 Sales Order Line
C_ORDERTAX 2 7 Order Tax
C_ORDER_HEADER_V view
C_ORDER_HEADER_VT view
C_ORDER_LINETAX_V view
C_ORDER_LINETAX_VT view
C_ORGASSIGNMENT 2 0 Assigment to (transaction) Organization
C_PAYMENT 16 18 2 Payment identifier
C_PAYMENTALLOCATE 3 0 Allocate Payment to Invoices
C_PAYMENTBATCH 1 1 0 Payment batch for EFT
C_PAYMENTPROCESSOR 1 3 2 Payment processor for electronic payments
C_PAYMENTTERM 12 5 The terms for Payment of this transaction
C_PAYMENTTERM_TRL 2 5 The terms of Payment (timing, discount)
C_PAYMENT_V view
C_PAYSCHEDULE 1 1 2 Payment Schedule Template
C_PAYSELECTION 2 1 1 Payment Selection
C_PAYSELECTIONCHECK 1 4 1 Payment Selection Check
C_PAYSELECTIONLINE 3 1 Payment Selection Line
C_PAYSELECTION_CHECK_V view
C_PAYSELECTION_CHECK_VT view
C_PAYSELECTION_REMITTANCE_V view
C_PAYSELECTION_REMITTANCE_VT view
C_PERIOD 8 3 96 Period of the Calendar
C_PERIODCONTROL 1 2,208 Period Control
C_PHASE 4 2 13 Standard Phase of the Project Type
C_POS 1 7 1 Point of Sales Terminal
C_POSKEY 3 3 POS Function Key
C_POSKEYLAYOUT 2 1 POS Function Key Layout
C_PROJECT 35 14 2 Financial Project
C_PROJECTISSUE 5 6 0 Project Issues (Material, Labor)
C_PROJECTISSUEMA 2 0 C_ProjectIssueMA
C_PROJECTLINE 8 1 Task or step in a project
C_PROJECTPHASE 8 4 0 Phase of a Project
C_PROJECTTASK 7 3 0 Actual Project Task in a Phase
C_PROJECTTYPE 3 4 Type of the project
C_PROJECT_ACCT 4 2 C_Project_Acct
C_PROJECT_DETAILS_V view
C_PROJECT_DETAILS_VT view
C_PROJECT_HEADER_V view
C_PROJECT_HEADER_VT view
C_RECURRING 1 5 1 Recurring Document
C_RECURRING_RUN 6 0 Recurring Document Run
C_REGION 9 3 253 Identifies a geographical Region
C_REMUNERATION 2 0 Remuneration
C_REVENUERECOGNITION 2 2 Method for recording revenue
C_REVENUERECOGNITION_PLAN 2 6 0 Plan for recognizing or recording revenue
C_REVENUERECOGNITION_RUN 2 0 Revenue Recognition Run or Process
C_RFQ 2 7 1 Request for Quotation
C_RFQLINE 2 3 2 Request for Quotation Line
C_RFQLINEQTY 1 2 2 Request for Quotation Line Quantity
C_RFQRESPONSE 1 6 0 Request for Quotation Response from a potential Vendor
C_RFQRESPONSELINE 1 2 0 Request for Quotation Response Line
C_RFQRESPONSELINEQTY 2 0 Request for Quotation Response Line Quantity
C_RFQRESPONSELINEQTY_V view
C_RFQRESPONSELINEQTY_VT view
C_RFQRESPONSELINE_V view
C_RFQRESPONSELINE_VT view
C_RFQRESPONSE_V view
C_RFQRESPONSE_VT view
C_RFQ_TOPIC 2 1 1 Topic for Request for Quotations
C_RFQ_TOPICSUBSCRIBER 1 4 2 Request for Quotation Topic Subscriber
C_RFQ_TOPICSUBSCRIBERONLY 3 0 Include Subscriber only for certain products or product categories
C_SALESREGION 11 1 2 Sales coverage region
C_SERVICELEVEL 1 2 0 Product Revenue Recognition Service Level
C_SERVICELEVELLINE 1 0 Product Revenue Recognition Service Level Line
C_SUBACCT 3 1 0 Sub account for Element Value
C_SUBSCRIPTION 1 3 0 Subscription of a Business Partner of a Product to renew
C_SUBSCRIPTIONTYPE 2 0 Type of subscription
C_SUBSCRIPTION_DELIVERY 1 0 Optional Delivery Record for a Subscription
C_TASK 1 2 9 Standard Project Type Task
C_TAX 13 6 6 Tax identifier
C_TAXCATEGORY 7 1 Tax Category
C_TAXCATEGORY_TRL 2 1 Tax Category
C_TAXDECLARATION 2 0 Define the declaration to the tax authorities
C_TAXDECLARATIONACCT 3 0 Tax Accounting Reconciliation
C_TAXDECLARATIONLINE 7 0 Tax Declaration Document Information
C_TAXPOSTAL 1 0 Tax Postal/ZIP
C_TAX_ACCT 7 6 C_Tax_Acct
C_TAX_TRL 2 6 Tax identifier
C_UOM 22 2 10 Unit of Measure
C_UOM_CONVERSION 5 1 Unit of Measure Conversion
C_UOM_TRL 2 10 Unit of Measure
C_USERREMUNERATION 2 0 Employee Wage or Salary Overwrite
C_VALIDCOMBINATION 142 16 77 Valid Account Combination
C_WITHHOLDING 2 2 0 Withholding type defined
C_WITHHOLDING_ACCT 3 0 C_Withholding_Acct
C_YEAR 3 3 8 Calendar Year
FACT_ACCT 2 27 0 Accounting Fact
FACT_ACCT_BALANCE 19 0 Fact_Acct_Balance
GL_BUDGET 7 1 General Ledger Budget
GL_BUDGETCONTROL 2 0 Budget Control
GL_CATEGORY 5 7 General Ledger Category
GL_DISTRIBUTION 1 16 1 General Ledger Distribution
GL_DISTRIBUTIONLINE 15 2 General Ledger Distribution Line
GL_FUND 1 1 0 General Ledger Funds Control
GL_FUNDRESTRICTION 2 0 Restriction of Funds
GL_JOURNAL 3 8 1 General Ledger Journal
GL_JOURNALBATCH 4 4 1 General Ledger Journal Batch
GL_JOURNALLINE 1 7 2 General Ledger Journal Line
GL_JOURNALLINE_ACCT_V view
I_BANKSTATEMENT 8 0 Import of the Bank Statement
I_BPARTNER 8 0 Import Business Partner
I_CONVERSION_RATE 4 2 Import Currency Conversion Rate
I_ELEMENTVALUE 4 0 Import Account Value
I_GLJOURNAL 26 0 Import General Ledger Journal
I_INOUTLINECONFIRM 1 0 Material Shipment or Receipt Confirmation Import Line
I_INVENTORY 5 0 Import Inventory Transactions
I_INVOICE 21 0 Import Invoice
I_ORDER 24 0 Import Orders
I_PAYMENT 7 0 Import Payment
I_PRODUCT 5 0 Import Item or Service
I_REPORTLINE 4 0 Import Report Line Set values
K_CATEGORY 2 1 Knowledge Category
K_CATEGORYVALUE 1 1 0 The value of the category
K_COMMENT 2 0 Knowledge Entry Comment
K_ENTRY 4 3 0 Knowledge Entry
K_ENTRYCATEGORY 3 0 K_EntryCategory
K_ENTRYRELATED 2 0 Related Entry for this Enntry
K_INDEX 4 0 Index
K_INDEXLOG 0 Index Log
K_INDEXSTOP 3 0 Index Stop
K_SOURCE 1 1 Source of a Knowledge Entry
K_SYNONYM 1 0 Knowlege Keyword Synonym
K_TOPIC 1 1 1 Knowledge Topic
K_TYPE 1 2 Knowledge Type
M_ATTRIBUTE 3 1 4 Product Attribute
M_ATTRIBUTEINSTANCE 3 5 M_AttributeInstance
M_ATTRIBUTESEARCH 1 1 Common Search Attribute
M_ATTRIBUTESET 4 2 4 Product Attribute Set
M_ATTRIBUTESETEXCLUDE 2 0 Exclude the ability to enter Attribute Sets
M_ATTRIBUTESETINSTANCE 26 2 4 Product Attribute Set Instance
M_ATTRIBUTEUSE 2 5 M_AttributeUse
M_ATTRIBUTEVALUE 1 1 9 Product Attribute Value
M_BOM 3 2 1 Bill of Material
M_BOMALTERNATIVE 1 1 1 Product BOM Alternative Group
M_BOMPRODUCT 6 0 Bill of Material Component (Product)
M_CHANGENOTICE 6 1 Change Notice
M_CHANGEREQUEST 1 3 0 Change Request
M_COST 7 27 Product Cost
M_COSTDETAIL 13 0 Cost Detail Information
M_COSTELEMENT 6 6 Cost Element
M_COSTQUEUE 5 0 FiFo/LiFo Cost Queue
M_COSTTYPE 3 1 Type of Cost
M_DEMAND 1 2 0 Material Demand
M_DEMANDDETAIL 4 0 Material Demand Line Source Detail
M_DEMANDLINE 1 3 0 Material Demand Line
M_DISCOUNTSCHEMA 7 3 Schema to calculate the trade discount percentage
M_DISCOUNTSCHEMABREAK 3 1 Trade Discount Break
M_DISCOUNTSCHEMALINE 5 11 Line of the pricelist trade discount schema
M_DISTRIBUTIONLIST 3 1 Distribution Lists allow to distribute products to a selected list of partners
M_DISTRIBUTIONLISTLINE 1 3 3 Distribution List Line with Business Partner and Quantity/Percentage
M_DISTRIBUTIONRUN 2 2 1 Distribution Run create Orders to distribute products to a selected list of partners
M_DISTRIBUTIONRUNLINE 1 3 1 Distribution Run Lines define Distribution List, the Product and Quantiries
M_EDI 1 3 0 EDI Transaction
M_EDI_INFO 1 0 EDI Log
M_FORECAST 1 2 0 Material Forecast
M_FORECASTLINE 1 3 0 Forecast Line
M_FREIGHT 7 1 Freight Rate
M_FREIGHTCATEGORY 2 2 Category of the Freight
M_INOUT 8 19 9 Material Shipment Document
M_INOUTCONFIRM 1 3 1 Material Shipment or Receipt Confirmation
M_INOUTCONFIRM_V view
M_INOUTCONFIRM_VT view
M_INOUTLINE 17 18 27 Line on Shipment or Receipt document
M_INOUTLINECONFIRM 1 4 1 Material Shipment or Receipt Confirmation Line
M_INOUTLINEMA 2 0 M_InOutLineMA
M_INOUTLINEMA_V view
M_INOUTLINEMA_VT view
M_INOUT_CANDIDATE_V view
M_INOUT_HEADER_V view
M_INOUT_HEADER_VT view
M_INOUT_LINECONFIRM_V view
M_INOUT_LINECONFIRM_VT view
M_INOUT_LINE_V view
M_INOUT_LINE_VT view
M_INVENTORY 4 10 1 Parameters for a Physical Inventory
M_INVENTORYLINE 9 5 1 Unique line in an Inventory document
M_INVENTORYLINEMA 2 0 M_InventoryLineMA
M_LOCATOR 14 3 2 Warehouse Locator
M_LOT 1 2 0 Product Lot Definition
M_LOTCTL 3 1 Product Lot Control
M_LOTCTLEXCLUDE 2 0 Exclude the ability to create Lots in Attribute Sets
M_MATCHINV 3 18 Match Shipment/Receipt to Invoice
M_MATCHPO 4 35 Match Purchase Order to Shipment/Receipt and Invoice
M_MOVEMENT 2 8 1 Movement of Inventory
M_MOVEMENTCONFIRM 1 2 0 Inventory Move Confirmation
M_MOVEMENTLINE 5 5 1 Inventory Move document Line
M_MOVEMENTLINECONFIRM 3 0 Inventory Move Line Confirmation
M_MOVEMENTLINEMA 2 0 M_MovementLineMA
M_MOVEMENTLINEMA_V view
M_MOVEMENTLINEMA_VT view
M_OPERATIONRESOURCE 3 0 Product Operation Resource
M_PACKAGE 1 2 1 Shipment Package
M_PACKAGELINE 2 1 The detail content of the Package
M_PERPETUALINV 1 2 0 Rules for generating physical inventory
M_PRICELIST 16 2 3 Unique identifier of a Price List
M_PRICELIST_VERSION 4 3 5 Identifies a unique instance of a Price List
M_PRODUCT 89 15 27 Product, Service, Item
M_PRODUCTDOWNLOAD 1 1 1 Product downloads
M_PRODUCTION 1 7 0 Plan for producing a product
M_PRODUCTIONLINE 6 4 0 Document Line representing a production
M_PRODUCTIONLINEMA 2 0 Production Line MA
M_PRODUCTIONPLAN 1 3 0 Plan for how a product is produced
M_PRODUCTOPERATION 2 1 0 Product Operation
M_PRODUCTPRICE 2 85 Product Price
M_PRODUCT_ACCT 10 27 Product Acct
M_PRODUCT_BOM 2 3 BOM Line
M_PRODUCT_CATEGORY 14 3 8 Category of a Product
M_PRODUCT_CATEGORY_ACCT 10 8 Product Category Acct
M_PRODUCT_COSTING 2 27 Product Costing
M_PRODUCT_PO 6 21 Product Purchasing
M_PRODUCT_STOCK_V view
M_PRODUCT_SUBSTITUTERELATED_V view
M_PRODUCT_SUBSTITUTERELATE_V view
M_PRODUCT_TRL 2 27 Product, Service, Item
M_RELATEDPRODUCT 2 1 Product Related
M_REPLENISH 3 19 M_Replenish
M_REQUISITION 1 4 1 Material Requisition
M_REQUISITIONLINE 1 4 1 Material Requisition Line
M_RMA 5 7 1 Return Material Authorization
M_RMALINE 2 3 1 Return Material Authorization Line
M_RMATYPE 1 1 Return Material Authorization Type
M_SERNOCTL 2 1 Product Serial Number Control
M_SERNOCTLEXCLUDE 2 0 Exclude the ability to create Serial Numbers in Attribute Sets
M_SHIPPER 6 1 1 Method or manner of product delivery
M_STORAGE 5 20 M_Storage
M_SUBSTITUTE 4 0 M_Substitute
M_TRANSACTION 3 8 28 Inventory Transaction
M_TRANSACTIONALLOCATION 10 0 M_TransactionAllocation
M_TRANSACTION_V view
M_WAREHOUSE 24 4 2 Storage Warehouse and Service Point
M_WAREHOUSE_ACCT 6 2 M_Warehouse_Acct
PA_ACHIEVEMENT 1 0 Performance Achievement
PA_BENCHMARK 2 0 Performance Benchmark
PA_BENCHMARKDATA 1 0 Performance Benchmark Data Point
PA_COLORSCHEMA 1 5 2 Performance Color Schema
PA_DASHBOARDCONTENT 2 0 PA_DashboardContent_ID
PA_GOAL 3 5 4 Performance Goal
PA_GOALRESTRICTION 7 0 Performance Goal Restriction
PA_HIERARCHY 1 8 0 Reporting Hierarchy
PA_MEASURE 2 6 4 Concrete Performance Measurement
PA_MEASURECALC 2 2 6 Calculation method for measuring performance
PA_RATIO 3 1 1 Performace Ratio
PA_RATIOELEMENT 4 3 Performance Ratio Element
PA_REPORT 7 3 Financial Report
PA_REPORTCOLUMN 2 14 17 Column in Report
PA_REPORTCOLUMNSET 2 3 Collection of Columns for Report
PA_REPORTLINE 6 5 113 Report Line
PA_REPORTLINESET 3 3 Report Line Set
PA_REPORTSOURCE 1 10 93 Restriction of what will be shown in Report Line
PA_SLA_CRITERIA 1 2 Service Level Agreement Criteria
PA_SLA_GOAL 1 2 1 Service Level Agreement Goal
PA_SLA_MEASURE 2 1 Service Level Agreement Measure
RV_ALLOCATION view
RV_ASSET_CUSTOMER view
RV_ASSET_DELIVERY view
RV_ASSET_SUMMONTH view
RV_BPARTNER view
RV_BPARTNEROPEN view
RV_CASH_DETAIL view
RV_CLICK_MONTH view
RV_CLICK_UNPROCESSED view
RV_COMMISSIONRUNDETAIL view
RV_COST view
RV_COSTDETAIL view
RV_COSTSUMMARY view
RV_C_INVOICE view
RV_C_INVOICELINE view
RV_C_INVOICETAX view
RV_C_INVOICE_CUSTOMERPRODQTR view
RV_C_INVOICE_CUSTOMERVENDQTR view
RV_C_INVOICE_DAY view
RV_C_INVOICE_MONTH view
RV_C_INVOICE_PRODMONTH view
RV_C_INVOICE_PRODUCTMONTH view
RV_C_INVOICE_PRODUCTQTR view
RV_C_INVOICE_PRODWEEK view
RV_C_INVOICE_VENDORMONTH view
RV_C_INVOICE_WEEK view
RV_C_RFQRESPONSE view
RV_C_RFQ_UNANSWERED view
RV_FACT_ACCT view
RV_FACT_ACCT_DAY view
RV_FACT_ACCT_PERIOD view
RV_INOUTCONFIRM view
RV_INOUTDETAILS view
RV_INOUTLINECONFIRM view
RV_M_REQUISITION view
RV_M_TRANSACTION view
RV_M_TRANSACTION_SUM view
RV_OPENITEM view
RV_ORDERDETAIL view
RV_PAYMENT view
RV_PRINTFORMATDETAIL view
RV_PRODUCT_COSTING view
RV_PROJECTCYCLE view
RV_PROJECTLINEISSUE view
RV_REQUESTUPDATES view
RV_REQUESTUPDATES_ONLY view
RV_REQUESTUPDATES_V view
RV_STORAGE view
RV_TRANSACTION view
RV_UNPOSTED view
RV_WAREHOUSEPRICE view
R_CATEGORY 3 1 3 Request Category
R_CATEGORYUPDATES 2 1 R_CategoryUpdates
R_CONTACTINTEREST 2 1 R_ContactInterest
R_GROUP 3 2 2 Request Group
R_GROUPUPDATES 2 1 R_GroupUpdates
R_INTERESTAREA 3 2 Interest Area or Topic
R_ISSUEKNOWN 1 2 0 Known Issue
R_ISSUEPROJECT 2 2 0 Issue Project
R_ISSUERECOMMENDATION 0 Issue Recommendation
R_ISSUESOURCE 3 0
R_ISSUESTATUS 1 0 Issue Status
R_ISSUESYSTEM 2 1 0 Issue System
R_ISSUEUSER 2 1 0 User who reported issues
R_MAILTEXT 10 1 Text templates for mailings
R_MAILTEXT_TRL 2 1 Text templates for mailings
R_REQUEST 6 27 1 Request from a Business Partner or Prospect
R_REQUESTACTION 20 2 Request History
R_REQUESTPROCESSOR 2 2 1 Request Processor
R_REQUESTPROCESSORLOG 1 0 Request Processor Log
R_REQUESTPROCESSOR_ROUTE 3 1 Automatic routing of requests
R_REQUESTTYPE 9 1 3 Type of request (e.g. Inquiry, Complaint, ..)
R_REQUESTTYPEUPDATES 2 1 Request Type Updates
R_REQUESTUPDATE 2 1 Request Update
R_REQUESTUPDATES 2 0 Request Update Recipiants
R_REQUEST_V view
R_RESOLUTION 2 3 Request Resolution
R_STANDARDRESPONSE 1 1 Request Standard Response
R_STATUS 4 3 4 Request Status
R_STATUSCATEGORY 2 1 Request Status Category
S_EXPENSETYPE 1 3 1 Expense report type
S_RESOURCE 3 3 1 Resource
S_RESOURCEASSIGNMENT 3 1 2 Resource Assignment
S_RESOURCETYPE 1 3 1 Resource Type
S_RESOURCEUNAVAILABLE 1 2 Resource Unavailability
S_TIMEEXPENSE 1 3 1 Time and Expense Report
S_TIMEEXPENSELINE 1 14 4 Time and Expense Report Line
S_TIMETYPE 1 0 Type of time recorded
S_TRAINING 1 3 1 Repeated Training
S_TRAINING_CLASS 2 0 The actual training class instance
TEST 1 1 Test ID
T_AGING 7 0 T_Aging
T_DISTRIBUTIONRUNDETAIL 7 0 T_DistributionRunDetail
T_INVENTORYVALUE 7 0 T_InventoryValue
T_INVOICEGL 5 0 Gain/Loss - actual data shown id T_InvoiceGL_v
T_INVOICEGL_V view
T_INVOICEGL_VT view
T_REPLENISH 5 0 T_Replenish
T_REPORT 2 0 Temporary Reporting Table
T_REPORTSTATEMENT 1 0 T_ReportStatement
T_SELECTION 0
T_SELECTION2 0
T_SPOOL 1 0 Temporary Spool Table
T_TRANSACTION 10 0 T_Transaction
T_TRIALBALANCE 1 0 Trial Balance
U_BLACKLISTCHEQUE 0 Black List Cheque
U_ROLEMENU 2 0 Role Menu
U_WEBMENU 2 1 0 Web Menu
U_WEB_PROPERTIES 0 Web Properties
W_ADVERTISEMENT 4 1 Web Advertisement
W_BASKET 1 3 0 Web Basket
W_BASKETLINE 2 0 Web Basket Line
W_CLICK 2 0 Individual Web Click
W_CLICKCOUNT 2 1 1 Web Click Management
W_COUNTER 2 0 Individual Count hit
W_COUNTERCOUNT 2 1 1 Web Counter Count Management
W_MAILMSG 2 1 0 Web Store Mail Message Template
W_MAILMSG_TRL 2 0 Web Store Mail Message Template
W_STORE 2 5 1 A Web Store of the Client
W_STORE_TRL 2 1 A Web Store of the Client

Total rows: 80,449