Not Implemented DB Objects
Contents |
Preface
This page describes all the objects that aren't used in Openbravo's database, starting in version 2.3x, it's open to any comment.
The not implemented tables and columns are those ones that are not implemented yet but are planned to be implemented in future releases.
The deprecated tables and columns are the ones that are not used by the ERP and will be removed from the dictionary. In a first step, the fields that point to these objects will be removed (the effect of this will be that they will not be longer shown in the user interface). In a second phase they will be definitely removed from the database.
Custom code tables and columns are objects that are used in different live installations but they don't belong to the core product, so they will be treated as deprecated objects.
Tables
Not implemented Yet
| Table Name | Description | Comment |
|---|---|---|
| AD_Alert | This table stores a line per each of the raised alerts. | |
| AD_AlertRecipient | This table contains the recipients of the alert, they can be defined as individual users or as roles. | |
| AD_AlertRule | Alert Rule defines the condition that will raise alerts. | |
| AD_Attachment | The Attachment tab displays the attributes of an attachment. | |
| AD_ChangeLog | Log of data changes\\Log of data changes | |
| AD_Column_Access | If listed here, the Role can(not) access the column of this table, even if the role has access to the functionality | |
| AD_Record_Access | If listed here, the Role can(not) access the data records of this table, even if the role has access to the functionality | |
| C_City | The Cities Tab defines Cities within a Country or Region. Cities entered here are not referenced when entering the address. | |
| C_InterOrg_Acct | The Organization Accounting Tab defines the default accounting parameters to be used by this Organization. | |
| C_OrgAssignment | ||
| C_ProjectIssue | The lab lists the Issues to the project initiated by the Issue to Project process. You can issue Receipts, Time and Expenses, or Stock. | |
| C_RevenueRecognition | The Revenue Recognition Tab defines the intervals at which revenue will be recognized. You can also base the revenue recognition on provided Service Levels. | |
| C_RevenueRecognition_Plan | The Revenue Recognition plan is generated then invoicing a product with revenue recognition. With Revenue Recognition, the amount is posted to the Unrecognized revenue and over time or based on Service Level booked to Earned Revenue. | |
| C_RevenueRecognition_Run | ||
| C_ServiceLevel | The service level is automatically created when creating an invoice with products using revenue recognition based on service levels. | |
| C_ServiceLevelLine | Add new service level lines to change the recognized amount | |
| I_BankStatement | Allows the bank statement import configuration and its execution | |
| I_GLJournal | A new Journal Batch is created, if the Batch Document No is different. A new Journal is created, if the Document No, Accounting Schema, Currency, Document Type, GL Category, Posting Type or Accounting type is different. Please note that there are three | |
| I_Inventory | Validate and Import Inventory Transactions. The Locator is primarily determined by the Locator Key, then the Warehouse and X,Y,Z fields.<p>A Physical Inventory is created per Warehouse and Movement Date. | |
| I_Invoice | You should supply the Document Type Name (or ID). The Document Type is on purpose not fully derived as it has too many consequences if it's wrong. The best way is to set the Document Type Name as a Constant in your Import File Format or as an imported fi | |
| M_PerpetualInv | ||
| M_Replenish | The Replenishment defines the type of replenishment quantities. This is used for automated ordering. | |
| R_MailText | The mail template configuration includes all template parameter configurations for the use. | |
| R_Request | The Request Tab defines any Request submitted by a Business Partner.\\The Request Tab defines any Request submitted by a Business Partner.\\Shows all the resquests of the partner selected. | |
| R_RequestAction | The Action History Tab displays any actions which have been taken for a Request.\\The Action History Tab displays any actions which have been taken for a Request. | |
| R_RequestProcessor | The Request Processor Tab allows you to define processes that you want to occur and the frequency and timing of these processes. If no other user is found, the items are assigned to the supervisor. | |
| R_RequestProcessor_Route | Define the sequence of keywords and to whom the web and mail requests should be routed to. | |
| R_RequestType | Request Types are used for processing and categorizing requests. Options are Account Inquiry, Warranty Issue, etc. | |
| R_ResourcePlanCost | Planned (budgeted) Costs of the Resource | |
| S_Resource | Maintain Resources | |
| S_ResourceAssignment | History of Assignments | |
| S_ResourceType | Maintain Resource types and their principal availability. | |
| S_ResourceUnAvailable | Dates, when the resource is not available (e.g. vacation) |
Deprecated
| Table Name | Description | Comment |
|---|---|---|
| A_Asset_Delivery | Record of delivery or availability | |
| A_Asset_Retirement | ||
| AD_Attribute | The Custom Attribute Tab defines additional attributes or information for a product or entity. | |
| AD_Attribute_Value | ||
| AD_Color | ||
| AD_Desktop | Desktop is a collection of Workbenches | |
| AD_Desktop_Trl | ||
| AD_DesktopWorkbench | ||
| A_Depreciation | ||
| AD_Error | The Error Message Tab displays error messages that have been generated. They can be deleted with an automated clean up process. | |
| AD_Find | ||
| AD_PrintColor | Colors used for printing | |
| AD_PrintFont | Font used for printing | |
| AD_PrintForm | The selection determines what Print Format is used to print a particular Form for your Organization. | |
| AD_PrintFormat | The print format determines how data is rendered for print. | |
| AD_PrintFormatItem | Display Order of the Print Format Items\\Sort Order of the Print Format Items\\Item in the print format maintaining layout information | |
| AD_PrintFormatItem_Trl | Print Format Translation | |
| AD_PrintGraph | Define Graph to be included | |
| AD_PrintLabel | Maintain the Format for printing Labels | |
| AD_PrintLabelLine | Maintain Format of the line on a Label | |
| AD_PrintLabelLine_Trl | Maintain the translation for Label Line formats | |
| AD_PrintPaper | Printer Paper Size, Orientation and Margins. The Validation Code contains the Media Size name. The names of the media sizes correspond to those in the IPP 1.1 RFC 2911 - http://www.ietf.org/rfc/rfc2911.txt | |
| AD_PrintTableFormat | The Print Table Format lets you define how table header, etc. is printed. If you leave the entries empty, the default colors and fonts are used: Fonts are based on the Font used in the Report; Page Header and Table Header will be bold, the Function Fo | |
| AD_Process_Scheduling | ||
| AD_Replication | Data Replication Target Details. Maintained on the central server. Make sure that the IP range is unique for every remote system - Otherwise you will loose data!! | |
| AD_Replication_Log | Detail Info | |
| AD_Replication_Run | Historic Info | |
| AD_ReplicationStrategy | The Data Replication Strategy determines which tables and how they are replicated. Note that the migration does not syncronize Application Dictionary items. | |
| AD_ReplicationTable | Determines how the table is replicated. You have full access to Local tables, Reference tables are on Remote systems and are read-only. The data of Merge tables on Remote systems is copied to the central system. | |
| AD_ReportView | The Define Report View defines the views used in report generation | |
| AD_ReportView_Col | The Report View Column Tab defines any columns which will be overridden in the generation of the select SQL | |
| AD_Sequence_Audit | ||
| AD_Sequence_No | ||
| AD_TaskInstance | ||
| AD_Trace | ||
| AD_UserDef_Field | ||
| AD_UserDef_Tab | ||
| AD_UserDef_Win | ||
| AD_WF_Instance | ||
| AD_Workbench | ||
| AD_Workbench_Trl | ||
| AD_WorkbenchWindow | ||
| C_Approval | The Approval Tab defines the approval types to be used in documents. | |
| C_BankAccountDoc | In this tab, you define the documents used for this bank account. You define your check and other payment document (sequence) number as well as format. | |
| C_BP_EDI | ||
| C_BP_Withholding | The Withholding Tab defines any withholding information for this business partner. | |
| C_CostType | ||
| C_Cycle | Define the currency that projects Project are reported. The projects themselves could be in a different currency. | |
| C_CyclePhase | Link similar Project Phases to a Cycle Step | |
| C_CycleStep | The Cycle Step determines the logical sequence of events within your cycle. It is the common of similar Project Phases making different project types comparable. | |
| C_DocType_Copy | This tab sets number of copies for each document by default. | |
| C_DocType_Copy_Trl | ||
| C_Dunning | The Dunning Tab defines the parameters for a dunning level. | |
| C_DunningLevel | The Dunning Level Tab defines the timing and frequency of the dunning notices. | |
| C_DunningLevel_Trl | Dunning Level Translation contains the tab translation to different languages | |
| C_DunningRun | ||
| C_DunningRunEntry | ||
| C_InvoicePaySchedule | ||
| C_InvoiceSchedule | The Invoice Schedule Tab defines the frequency for which batch invoices will be generated for a Business Partner. | |
| C_PaySchedule | ||
| C_Withholding | The Withholding Rules Tab define the rules governing the withholding of amounts. | |
| C_Withholding_Acct | The Withholding Accounting Tab defines the accounting parameters for Withholding. | |
| Fact_Acct_Balance | ||
| GL_Budget | The GL Budgets are used to define the anticipated costs of doing business. They are used in reporting as a comparison to actual amounts. | |
| I_ReportLine | ||
| K_Category | Set up knowledge categories and values as a search aid. Examples are Release Version, Product Area, etc. Knowledge Category values act like keyworks. | |
| K_CategoryValue | The value of the category is a keyword | |
| K_Comment | Comment regarding a knowledge entry | |
| K_Entry | The searchable Knowledge Entry | |
| K_EntryCategory | Assiged Category - Value for the Knowlede Entry | |
| K_EntryRelated | Related Knowlege Entry for this Knowledge Entry | |
| K_Source | The Source of a Knowlegde Entry is a pointer to the originating system. The Knowledge Entry has an additional entry (Description URL) for more detailed info. | |
| K_Synonym | Search Synonyms for Knowledge Keywords; Example: Product = Item | |
| K_Topic | Topic or Discussion Thead | |
| K_Type | Area of knowlege - A Type has multiple Topics | |
| MA_CalcStd | Standard calculation costs registration is generated automatically | |
| MA_DefaultPlan | ||
| MA_ProductType | The product type defines any products role at any production chain: raw material, intermediate product, final product, consume product,... | |
| MA_SequenceProduct_Cost | This tab contins de production costs configuration | |
| M_AttributeSearch | Attributes are specific to a Product Attribute Set (e.g. Size for T-Shirts: S,M,L). If you have multiple attributes and want to search under a common sttribute, you define a search sttribute. Example: have one Size search attribute combining the values of | |
| MA_WETechnicalSupport | In this tab are introduced all the technical supports done during the work | |
| M_DiscountSchemaBreak | ||
| M_EDI | ||
| M_EDI_Info | ||
| M_Lot | Maintain the individual Lot of a Product | |
| M_LotCtl | Definition to create Lot numbers for Products | |
| M_Product_Costing | Define Costing | |
| M_SerNoCtl | Definition to create Serial numbers for Products | |
| PA_Achievement | The Performance Achievement Tab defines the Tasks to be achieved. The performance is measured by the percentage of reached achievements. | |
| PA_Color | The Performance Color Tab allows you to alter the system default colors to indicate a performance level. | |
| PA_Goal | The Performance Goal Tab defines specific goals for performance. | |
| PA_Measure | The Performance Measure Tab defines the date range and method to be used for measuring performance. | |
| PA_MeasureCalc | The Performance Measure Calculation defines how performance measures will be calculated. Please test the statement in SQL*Plus first.The select statement needs to return a single value!Any restrictions for Date range, Organizations, Business Partners, | |
| PA_Report | ||
| PA_ReportColumn | A column represents a column in a Financial Report | |
| PA_ReportColumnSet | Column Sets are the combination of Columns to be included in a Financial Report | |
| PA_ReportLine | ||
| PA_ReportLineSet | ||
| PA_ReportSource | ||
| S_Training | The training may have multiple actual classes. New Classes are created here. | |
| S_Training_Class | A scheduled class | |
| TIRE_Storage | ||
| W_Advertisement | Advertisement on the Web | |
| W_Basket | ||
| W_BasketLine | ||
| W_Click | ||
| W_ClickCount | ||
| W_Counter | ||
| W_CounterCount |
Custom code
| Table Name | Description | Comment |
|---|---|---|
| MA_ConsumeProduct | The Product tab is used to detail the product which at the same time needs to be activated in the Product window. | |
| MA_ConsumeRM | The Raw Materials tab is used to detail the raw materials which compose a product, | |
| M_Locator_Renting | Contains all the rented locators |
Columns
Not Implemented Yet
| Table Name | Column Name | Description | Comment |
|---|---|---|---|
| a_asset | depreciatedplan | value that is planned to be depreciated. | |
| a_asset_acct | a_disposal_gain | disposal gain account | |
| a_asset_acct | a_disposal_loss | disposal loss account | |
| a_asset_group_acct | a_disposal_gain | disposal gain account | |
| a_asset_group_acct | a_disposal_loss | disposal loss account | |
| ad_column | vformat | value format is the format the value will be displayed with. | |
| ad_field | isfieldonly | the field only checkbox indicates that the column will display without a label. | |
| ad_process | isuserstartable | the user can start process checkbox indicates that this process can be initiated by the user (as opposed to system initiated) | |
| ad_process_para | vformat | value format is the format the value will be displayed with. | |
| ad_reference | vformat | value format is the format the value will be displayed with. | |
| ad_sequence | vformat | value format is the format the value will be displayed with. | |
| ad_system | info | the information displays data from the source document line. | |
| ad_system | name | the name of an entity (record) is used as an default search option in addition to the search key. the name is up to 60 characters in lenght. | |
| ad_tab | commitwarning | warning or information displayed when committing the record | |
| ad_table | ischangelog | if selected, a log of all changes is maintained. | |
| ad_table | isdefaultacct | is default account | |
| ad_table | issecurityenabled | the security enabled checkbox indicates that user access to the data in this table can be restricted using roles. | |
| ad_user | ad_orgtrx_id | the organization which performs or initiates this transaction (for another organization). the owning organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. | |
| ad_wf_node | xposition | absolute x (horizontal) position in 1/72 of an inch | |
| ad_wf_node | yposition | absolute y (vertical) position in 1/72 of an inch | |
| ad_wf_nodenext | condition | the condition field identifies the condition that must be met before the workflow can proceed to the next task. | |
| c_acctschema | autoperiodcontrol | in the automatic period control, periods are opened and closed based on the current date. if the manual alternative is activated, you have to open and close periods explicitly. | |
| c_acctschema | costingmethod | the costing method indicates how costs will be calculated (standard, average) | |
| c_acctschema | hasalias | the alias checkbox indicates that account combination can be selected using a user defined alias or short key. | |
| c_acctschema | hascombination | the combination control checkbox indicates if the combination of account elements will be verified against the defined acceptable combination. | |
| c_acctschema | isaccrual | the accrual checkbox indicates if this accounting schema will use accrual based account or cash based accounting. the accrual method recognizes revenue when the product or service is delivered. cash based method recognizes income when then payment is received. | |
| c_acctschema | isdiscountcorrectstax | payment discounts may require to correct the tax. this primarily applicable in vat systems. if the original invoice had tax records, the payment discount, write-off, etc. is corrected by the tax. the calculation of the tax is prorated based on the invoice. | |
| c_acctschema | istradediscountposted | if the invoice is based on an item with a list price, the amount based on the list price and the discount is posted instead of the net amount.example: quantity 10 - list price: 20 - actual price: 17if selected for a sales invoice 200 is posted to produc | |
| c_acctschema | period_openfuture | if automatic period control is enabled, the current period is calculated based on the system date and you can always post to all days in the current period. future days enable to post to future periods. e.g. today is apr 15th and future days is set to 30, you can post up to may 15th | |
| c_acctschema | period_openhistory | if automatic period control is enabled, the current period is calculated based on the system date and you can always post to all days in the current period. history days enable to post to previous periods. e.g. today is may 15th and history days is set to 30, you can post back to april 15th | |
| c_acctschema_default | a_accumdepreciation_acct | accumulated depreciation account | |
| c_acctschema_default | a_depreciation_acct | depreciation account | |
| c_acctschema_default | a_disposal_gain | disposal gain account | |
| c_acctschema_default | a_disposal_loss | disposal loss account | |
| c_acctschema_default | b_interestexp_acct | the bank interest expense account identifies the account to be used for recording interest expenses. | |
| c_acctschema_default | b_interestrev_acct | the bank interest revenue account identifies the account to be used for recording interest revenue from this bank. | |
| c_acctschema_default | b_settlementgain_acct | the bank settlement gain account identifies the account to be used when recording a currency gain when the settlement and receipt currency are not the same. | |
| c_acctschema_default | b_settlementloss_acct | the bank settlement loss account identifies the account to be used when recording a currency loss when the settlement and receipt currency are not the same. | |
| c_acctschema_default | b_unallocatedcash_acct | receipts not allocated to invoices | |
| c_acctschema_default | b_unidentified_acct | the bank unidentified receipts account identifies the account to be used when recording receipts that can not be reconciled at the present time. | |
| c_acctschema_default | cb_cashtransfer_acct | account for invoices paid by cash | |
| c_acctschema_default | ch_revenue_acct | the charge revenue account identifies the account to use when recording charges paid by customers. | |
| c_acctschema_default | c_prepayment_acct | the customer prepayment account indicates the account to be used for recording prepayments from a customer. | |
| c_acctschema_default | e_expense_acct | the employee expense account identifies the account to use for recording expenses for this employee. | |
| c_acctschema_default | e_prepayment_acct | the employee prepayment account identifies the account to use for recording expense advances made to this employee. | |
| c_acctschema_default | notinvoicedreceipts_acct | the not invoiced receipts account indicates the account used for recording receipts for materials that have not yet been invoiced. | |
| c_acctschema_default | notinvoicedreceivables_acct | the not invoiced receivables account indicates the account used for recording receivables that have not yet been invoiced. | |
| c_acctschema_default | notinvoicedrevenue_acct | the not invoiced revenue account indicates the account used for recording revenue that has not yet been invoiced. | |
| c_acctschema_default | paydiscount_exp_acct | indicates the account to be charged for payment discount expenses. | |
| c_acctschema_default | paydiscount_rev_acct | indicates the account to be charged for payment discount revenues. | |
| c_acctschema_default | p_invoicepricevariance_acct | the invoice price variance is used reflects the difference between the current costs and the invoice price. | |
| c_acctschema_default | pj_asset_acct | the project asset account is the account used as the final asset account in capital projects | |
| c_acctschema_default | p_purchasepricevariance_acct | the purchase price variance is used in standard costing. it reflects the difference between the standard cost and the purchase order price. | |
| c_acctschema_default | p_tradediscountgrant_acct | the trade discount granted account indicates the account for granted trade discount in sales invoices | |
| c_acctschema_default | p_tradediscountrec_acct | the trade discount receivables account indicates the account for received trade discounts in vendor invoices | |
| c_acctschema_default | realizedgain_acct | the realized gain account indicates the account to be used when recording gains achieved from currency revaluation that have been realized. | |
| c_acctschema_default | realizedloss_acct | the realized loss account indicates the account to be used when recording losses incurred from currency revaluation that have yet to be realized. | |
| c_acctschema_default | t_expense_acct | the tax expense account indicates the account used to record the taxes that have been paid that cannot be reclaimed. | |
| c_acctschema_default | t_liability_acct | the tax liability account indicates the account used to record your tax liability declaration. | |
| c_acctschema_default | t_receivables_acct | the tax receivables account indicates the account used to record the tax credit amount after your tax declaration. | |
| c_acctschema_default | unearnedrevenue_acct | the unearned revenue indicates the account used for recording invoices sent for products or services not yet delivered. it is used in revenue recognition | |
| c_acctschema_default | unrealizedgain_acct | the unrealized gain account indicates the account to be used when recording gains achieved from currency revaluation that have yet to be realized. | |
| c_acctschema_default | unrealizedloss_acct | the unrealized loss account indicates the account to be used when recording losses incurred from currency revaluation that have yet to be realized. | |
| c_acctschema_default | v_liability_services_acct | the vendor service liability account indicates the account to use for recording service liabilities. it is used if you need to distinguish between liability for products and services | |
| c_acctschema_default | v_prepayment_acct | the vendor prepayment account indicates the account used to record prepayments from a vendor. | |
| c_acctschema_default | w_invactualadjust_acct | in actual costing systems, this account is used to post inventory value adjustments. you could set it to the standard inventory asset account. | |
| c_acctschema_gl | intercompanydueto_acct | the intercompany due to account indicates the account that represents money owed to other organizations. | |
| c_bank | isownbank | the own bank field indicates if this bank is for this organization as opposed to a bank for a business partner. | |
| c_bank | routingno | the bank routing number (aba number) identifies a legal bank. it is used in routing checks and electronic transactions. | |
| c_bank | swiftcode | the swift code is an identifier of a bank | |
| c_bankaccount_acct | b_interestexp_acct | the bank interest expense account identifies the account to be used for recording interest expenses. | |
| c_bankaccount_acct | b_interestrev_acct | the bank interest revenue account identifies the account to be used for recording interest revenue from this bank. | |
| c_bankaccount_acct | b_paymentselect_acct | ap payment selection clearing account | |
| c_bankaccount_acct | b_settlementgain_acct | the bank settlement gain account identifies the account to be used when recording a currency gain when the settlement and receipt currency are not the same. | |
| c_bankaccount_acct | b_settlementloss_acct | the bank settlement loss account identifies the account to be used when recording a currency loss when the settlement and receipt currency are not the same. | |
| c_bankaccount_acct | b_unallocatedcash_acct | receipts not allocated to invoices | |
| c_bankaccount_acct | b_unidentified_acct | the bank unidentified receipts account identifies the account to be used when recording receipts that can not be reconciled at the present time. | |
| c_bpartner | bpartner_parent_id | the parent (organization) of the business partner for reporting purposes. | |
| c_bpartner | socreditstatus | for documentation only | |
| c_bp_customer_acct | c_prepayment_acct | the customer prepayment account indicates the account to be used for recording prepayments from a customer. | |
| c_bp_employee_acct | e_expense_acct | the employee expense account identifies the account to use for recording expenses for this employee. | |
| c_bp_employee_acct | e_prepayment_acct | the employee prepayment account identifies the account to use for recording expense advances made to this employee. | |
| c_bp_group_acct | c_prepayment_acct | the customer prepayment account indicates the account to be used for recording prepayments from a customer. | |
| c_bp_group_acct | c_receivable_acct | the customer receivables accounts indicates the account to be used for recording transaction for customers receivables. | |
| c_bp_group_acct | notinvoicedreceipts_acct | the not invoiced receipts account indicates the account used for recording receipts for materials that have not yet been invoiced. | |
| c_bp_group_acct | notinvoicedreceivables_acct | the not invoiced receivables account indicates the account used for recording receivables that have not yet been invoiced. | |
| c_bp_group_acct | notinvoicedrevenue_acct | the not invoiced revenue account indicates the account used for recording revenue that has not yet been invoiced. | |
| c_bp_group_acct | paydiscount_exp_acct | indicates the account to be charged for payment discount expenses. | |
| c_bp_group_acct | paydiscount_rev_acct | indicates the account to be charged for payment discount revenues. | |
| c_bp_group_acct | realizedgain_acct | the realized gain account indicates the account to be used when recording gains achieved from currency revaluation that have been realized. | |
| c_bp_group_acct | realizedloss_acct | the realized loss account indicates the account to be used when recording losses incurred from currency revaluation that have yet to be realized. | |
| c_bp_group_acct | unearnedrevenue_acct | the unearned revenue indicates the account used for recording invoices sent for products or services not yet delivered. it is used in revenue recognition | |
| c_bp_group_acct | unrealizedgain_acct | the unrealized gain account indicates the account to be used when recording gains achieved from currency revaluation that have yet to be realized. | |
| c_bp_group_acct | unrealizedloss_acct | the unrealized loss account indicates the account to be used when recording losses incurred from currency revaluation that have yet to be realized. | |
| c_bp_group_acct | v_liability_services_acct | the vendor service liability account indicates the account to use for recording service liabilities. it is used if you need to distinguish between liability for products and services | |
| c_bp_group_acct | v_prepayment_acct | the vendor prepayment account indicates the account used to record prepayments from a vendor. | |
| c_bp_vendor_acct | v_liability_services_acct | the vendor service liability account indicates the account to use for recording service liabilities. it is used if you need to distinguish between liability for products and services | |
| c_bp_vendor_acct | v_prepayment_acct | the vendor prepayment account indicates the account used to record prepayments from a vendor. | |
| c_budgetline | ad_orgtrx_id | the organization which performs or initiates this transaction (for another organization). the owning organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. | |
| c_cash | ad_orgtrx_id | the organization which performs or initiates this transaction (for another organization). the owning organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. | |
| c_charge | ad_client_id | a client is a company or a legal entity. you cannot share data between clients. | |
| c_charge | chargeamt | the charge amount indicates the amount for an additional charge. | |
| c_charge | c_taxcategory_id | the tax category provides a method of grouping similar taxes. for example, sales tax or value added tax. | |
| c_charge | description | a description is limited to 255 characters. | |
| c_charge | issamecurrency | ||
| c_charge | issametax | the same tax checkbox indicates that this charge should use the same tax as the main transaction. | |
| c_charge | istaxincluded | the tax included checkbox indicates if the prices include tax. this is also known as the gross price. | |
| c_charge | name | the name of an entity (record) is used as an default search option in addition to the search key. the name is up to 60 characters in lenght. | |
| c_element | add1tree_id | the additional tree is used to define alternate roll ups which can be used in reporting. for example, you may have a business partner tree which rolls up based on geographic location and an additional tree which rolls up based on industry. | |
| c_element | add2tree_id | the additional tree is used to define alternate roll ups which can be used in reporting. for example, you may have a business partner tree which rolls up based on geographic location and an additional tree which rolls up based on industry. | |
| c_element | isbalancing | the balancing checkbox indicates the this element must balance in each journal transaction. for example, if cost centers have been defined as an element which is balance then the debits and credits for each unique cost center must net to 0.00. this is commonly used to define parts of an organization which report as their own entity. balancing is not an option for the account element. | |
| c_element | isnaturalaccount | the natural account is often based on (industry specific) chart of accounts | |
| c_elementvalue | isdoccontrolled | ||
| c_elementvalue | postactual | the post actual indicates if actual values can be posted to this element value. | |
| c_elementvalue | postbudget | the post budget indicates if budget values can be posted to this element value. | |
| c_elementvalue | postencumbrance | ||
| c_elementvalue | poststatistical | ||
| c_elementvalue | validfrom | the valid from date indicates the first day of a date range | |
| c_elementvalue | validto | the valid to date indicates the last day of a date range | |
| c_invoice | istaxincluded | the tax included checkbox indicates if the prices include tax. this is also known as the gross price. | |
| c_invoiceline | chargeamt | the charge amount indicates the amount for an additional charge. | |
| c_order | istaxincluded | the tax included checkbox indicates if the prices include tax. this is also known as the gross price. | |
| c_orderline | chargeamt | the charge amount indicates the amount for an additional charge. | |
| c_orderline | ref_orderline_id | reference of the sales order line to the corresponding purchase order line or vice versa. | |
| c_project_acct | pj_asset_acct | the project asset account is the account used as the final asset account in capital projects | |
| c_project_acct | pj_wip_acct | the work in process account is the account used in capital projects until the project is completed | |
| c_settlement | settlementopen | ||
| c_tax_acct | t_expense_acct | the tax expense account indicates the account used to record the taxes that have been paid that cannot be reclaimed. | |
| c_tax_acct | t_liability_acct | the tax liability account indicates the account used to record your tax liability declaration. | |
| c_tax_acct | t_receivables_acct | the tax receivables account indicates the account used to record the tax credit amount after your tax declaration. | |
| c_validcombination | ad_orgtrx_id | the organization which performs or initiates this transaction (for another organization). the owning organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. | |
| fact_acct | a_asset_id | any item of economic value owned by the corporation, especially that which could be converted to cash. | |
| fact_acct | ad_orgtrx_id | the organization which performs or initiates this transaction (for another organization). the owning organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. | |
| gl_journal | isprinted | the printed checkbox indicates if this document or line will included when printing. | |
| ma_costcenter | cost | cost amount. | |
| ma_costcenter | costuom | unit of measure for cost | |
| ma_machine | ma_costcenter_id | identifies a cost center. | |
| ma_machine_cost | consume | ||
| ma_process | ma_cc_idprep | ||
| ma_process | ma_cc_idwork | ||
| ma_sequence | calculated | indicates that the record has been calculated. | |
| ma_workrequirement | name | the name of an entity (record) is used as an default search option in addition to the search key. the name is up to 60 characters in lenght. | |
| ma_wrphase | name | the name of an entity (record) is used as an default search option in addition to the search key. the name is up to 60 characters in lenght. | |
| ma_wrphase | preptime | preparation time needed in hours. | |
| ma_wrphaseproduct | name | the name of an entity (record) is used as an default search option in addition to the search key. the name is up to 60 characters in lenght. | |
| m_discountschema | cumulativelevel | ||
| m_discountschema | discounttype | type of procedure used to calculate the trade discount percentage | |
| m_discountschema | flatdiscount | ||
| m_discountschema | isquantitybased | the calculation of the trade discount level is based on the quantity of the order and not the value amount of the order | |
| m_discountschema | script | use java language constructs to define the result of the calculation | |
| m_discountschema | validfrom | the valid from date indicates the first day of a date range | |
| m_pricelist | basepricelist_id | the base price list identifies the default price list to be used if a product is not found on the selected price list | |
| m_product | enforce_attribute | for differing the stock of a product by the attribute | |
| m_product | s_resource_id | the id identifies a unique resource | |
| m_product | stock_min | minimum stock of a product | |
| m_product | versionno | version number | |
| m_product_acct | p_asset_acct | the product asset account indicates the account used for valuing this a product in inventory. | |
| m_product_acct | p_cogs_acct | the product cogs account indicates the account used when recording costs associated with this product. | |
| m_product_acct | p_invoicepricevariance_acct | the invoice price variance is used reflects the difference between the current costs and the invoice price. | |
| m_product_acct | p_purchasepricevariance_acct | the purchase price variance is used in standard costing. it reflects the difference between the standard cost and the purchase order price. | |
| m_product_acct | p_tradediscountgrant_acct | the trade discount granted account indicates the account for granted trade discount in sales invoices | |
| m_product_acct | p_tradediscountrec_acct | the trade discount receivables account indicates the account for received trade discounts in vendor invoices | |
| m_product_category_acct | p_asset_acct | the product asset account indicates the account used for valuing this a product in inventory. | |
| m_product_category_acct | p_invoicepricevariance_acct | the invoice price variance is used reflects the difference between the current costs and the invoice price. | |
| m_product_category_acct | p_purchasepricevariance_acct | the purchase price variance is used in standard costing. it reflects the difference between the standard cost and the purchase order price. | |
| m_product_category_acct | p_tradediscountgrant_acct | the trade discount granted account indicates the account for granted trade discount in sales invoices | |
| m_product_category_acct | p_tradediscountrec_acct | the trade discount receivables account indicates the account for received trade discounts in vendor invoices | |
| m_product_po | royaltyamt | ||
| m_warehouse_acct | w_invactualadjust_acct | in actual costing systems, this account is used to post inventory value adjustments. you could set it to the standard inventory asset account. | |
| m_warehouse_acct | w_inventory_acct | the warehouse inventory asset account identifies the account used for recording the value of your inventory. | |
| m_warehouse_acct | w_revaluation_acct | the inventory revaluation account identifies the account used to records changes in inventory value due to currency revaluation. |
Deprecated
| Table Name | Column Name | Description | Comment |
|---|---|---|---|
| a_asset | cause | ||
| a_asset | profit | ||
| ad_client | documentdir | directory to store documents by the application server. the path/directory is accessed by the application server and may not be accessible to clients. | |
| ad_client | webdir | the web directory defines the look and feel for the web interface. | |
| ad_client | webinfo | display html info in the web store - by default in the header. | |
| ad_client | weborderemail | when processig a web order, a confirmation is sent to the email addess of the customer from the request email address copying this email address when entered. | |
| ad_client | webparam1 | the parameter could be used in the jsp page for variables like logos, passwords, urls or entire html blocks. the access is via ctx.webparam1 | |
| ad_client | webparam2 | the parameter could be used in the jsp page for variables like logos, passwords, urls or entire html blocks. the access is via ctx.webparam2 | |
| ad_client | webparam3 | the parameter could be used in the jsp page for variables like logos, passwords, urls or entire html blocks. the access is via ctx.webparam3 | |
| ad_client | webparam4 | the parameter could be used in the jsp page for variables like logos, passwords, urls or entire html blocks. the access is via ctx.webparam4 | |
| ad_client | webparam5 | the parameter could be used in the jsp page for variables like logos, passwords, urls or entire html blocks. the access is via ctx.webparam5 | |
| ad_client | webparam6 | the parameter could be used in the jsp page for variables like logos, passwords, urls or entire html blocks. the access is via ctx.webparam6 | |
| ad_column | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_column | version | the version indicates the version of this table definition. | |
| ad_element | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_field | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_field | isheading | the heading only checkbox indicates if just the label will display on the screen | |
| ad_form | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_menu | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_menu | isreadonly | the read only indicates that this field may only be read. it may not be updated. | |
| ad_menu | issotrx | the sales transaction checkbox indicates if this item is a sales transaction. | |
| ad_message | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_model_object | ad_workbench_id | collection of windows, reports | |
| ad_process | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_process_para | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_reference | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_ref_list | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_ref_table | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_sequence | isaudited | the activate audit checkbox indicates if an audit trail of numbers generated will be kept. | |
| ad_system | idrangeend | the id range allows to restrict the range of the internally used ids. please note that the id range is not enforced. | |
| ad_system | idrangestart | the id range allows to restrict the range of the internally used ids. the standard rages are 0-899,999 for the application dictionary 900,000-999,999 for application dictionary customizations/extensions and > 1,000,000 for client data. the standard system limit is 9,999,999,999 but can easily be extended. the id range is on a per table basis.please note that the id range is not enforced. | |
| ad_system | password | the password indicates the password for this user id. passwords are required to identify authorized users. | |
| ad_system | replicationtype | the type of data replication determines the directon of the data replication. reference means that the data in this system is read only -> local means that the data in this system is not replicated to other systems - merge means that the d | |
| ad_system | supportunits | ||
| ad_system | username | name that identifies the user in the system | |
| ad_tab | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_table | ad_val_rule_id | the validation rule indicates a unique validation rule. these rules define how an entry is determined to valid or invalid. | |
| ad_table | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_table | loadseq | sequence of the table | |
| ad_table | replicationtype | the type of data replication determines the directon of the data replication. reference means that the data in this system is read only -> local means that the data in this system is not replicated to other systems - merge means that the d | |
| ad_task | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_user | pa_goal_id | the performance goal indicates what this users performance will be measured against. | |
| ad_user | pa_goalprivate_id | the personal goals displays goals that a user will set for themselves. | |
| ad_val_rule | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_wf_node | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_window | ad_color_id | color for backgrounds or indicators | |
| ad_window | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| ad_workflow | entitytype | the entity types dictionary, core and application might be automatically synchronized and customizations deleted or overwritten. | |
| c_bankaccount | accountno | the account number indicates the number assigned to this account | |
| c_bankaccount | stmtprocessorclass | the statement processor class indicates the java class to process bank statements | |
| c_bankstatementline | isreversal | the reversal check box indicates if this is a reversal of a prior transaction. | |
| c_bpartner | ad_forced_org_id | an organization is a unit of your client or legal entity - examples are store, department. you can share data between organizations. | |
| c_bpartner | c_dunning_id | the dunning indicates the rules and method of dunning for past due payments. | |
| c_bpartner | freightcostrule | the freight cost rule indicates the method used when charging for freight. | |
| c_bpartner | invoice_printformat_id | you need to define a print format to print the document. | |
| c_bpartner | m_discountschema_id | after calculation of the (standard) price, the trade discount percentage is calculated and applied resulting in the final price. | |
| c_bpartner | po_discountschema_id | ||
| c_bpartner | sendemail | send emails with document attached (e.g. invoice, delivery note, etc.) | |
| c_bpartner_location | isdn | the isdn identifies a isdn or modem line number. | |
| c_bpartner_location | upc | use this field to enter the bar code for the product in any of the bar code symbologies (codabar, code 25, code 39, code 93, code 128, upc (a), upc (e), ean-13, ean-8, itf, itf-14, isbn, issn, jan-13, jan-8, postnet and fim, msi/plessey, and pharmacode) | |
| c_bp_bankaccount | c_bank_id | the bank is a unique identifier of a bank for this organization or for a business partner with whom this organization transacts. | |
| c_bp_bankaccount | creditcardvv | the credit card verification indicates the verification code on the credit card (amex 4 digits on front; mc,visa 3 digits back) | |
| c_bp_bankaccount | isach | the ach checkbox indicates if this bank account accepts ach transactions. | |
| c_bp_bankaccount | r_avsaddr | the address verified indicates if the address has been verified by the credit card company. | |
| c_currency | emuentrydate | the emu entry date defines the date that this currency entered, or will enter the economic monetary union. | |
| c_currency | emurate | the emu rate defines the official rate to be used when converting from this currency to the euro. | |
| c_currency | isemumember | the emu member checkbox is used to indicate if this currency is a member of the european economic union. | |
| c_currency | iseuro | the euro currency checkbox is used to indicate if this currency is the euro currency. | |
| c_doctype | ad_printformat_id | the print format determines how data is rendered for print. | |
| c_doctype | batchnosequence_id | ||
| c_doctype | c_approval_id | the approval indicates the type of approval. this field is displayed only if the approved checkbox has been selected | |
| c_doctype | c_doctypeproforma_id | the document type for invoice indicates the document type that will be used when an invoice is generated from this sales document. this field will display only when the base document type is sales order and the pro forma invoice checkbox is selected | |
| c_doctype | createpicklist | ||
| c_doctype | hascharges | the charges checkbox indicates that charges can be added to this document. charges can include items like shipping, handling or bank charges. | |
| c_doctype | hasproforma | the pro forma invoice checkbox indicates if pro forma invoices can be generated from this sales document. a pro forma invoice indicates the amount that will be due should an order be shipped. | |
| c_doctype | isapproved | the approved checkbox indicates if this document requires approval before it can be processed. | |
| c_doctype | isbatchcontrolenforced | ||
| c_doctype | isbatchdocnocontrolled | ||
| c_doctype | isbatched | ||
| c_doctype | ismaxtable | this field is associated with isorgfiltered field. if isorgfiltered='y' ismaxtable must be equal to 'y' this will calculate the correct document number of the organization. a different document number for each organization. | |
| c_doctype | isprinted | the printed checkbox indicates if this document or line will included when printing. | |
| c_doctype | istransferred | the transferred checkbox indicates if the transactions associated with this document should be transferred to the general ledger. | |
| c_invoice | isapproved | the approved checkbox indicates if this document requires approval before it can be processed. | |
| c_invoice | ispaid | the document is paid | |
| c_invoice | istransferred | the transferred checkbox indicates if the transactions associated with this document should be transferred to the general ledger. | |
| c_invoice | sendemail | send emails with document attached (e.g. invoice, delivery note, etc.) | |
| c_invoiceline | a_asset_id | any item of economic value owned by the corporation, especially that which could be converted to cash. | |
| c_order | isapproved | the approved checkbox indicates if this document requires approval before it can be processed. | |
| c_order | iscreditapproved | credit approved indicates if the credit approval was successful for orders | |
| c_order | istransferred | the transferred checkbox indicates if the transactions associated with this document should be transferred to the general ledger. | |
| c_order | sendemail | send emails with document attached (e.g. invoice, delivery note, etc.) | |
| c_orderline | lot | the lot number indicates the specific lot that a product was part of. | |
| c_orderline | serno | the serial number identifies a tracked, warranted product. it can only be used when the quantity is 1. | |
| c_paymentterm | afterdelivery | the after delivery checkbox indicates that payment is due after delivery as opposed to after invoicing. | |
| c_paymentterm | discount | the discount indicates the discount applied or taken as a percentage. | |
| c_paymentterm | discountdays | the discount days indicates the number of days that payment must be received in to be eligible for the stated discount. | |
| c_paymentterm | discountdays2 | the discount days indicates the number of days that payment must be received in to be eligible for the stated discount. | |
| c_paymentterm | discount2 | the discount indicates the discount applied or taken as a percentage. | |
| c_paymentterm | fixmonthcutoff | the fix month cutoff indicates the last day invoices can have to be included in the current due date. this field only displays when the fixed due date checkbox has been selected. | |
| c_paymentterm | gracedays | the grace days indicates the number of days after the due date to send the first dunning letter. this field displays only if the send dunning letters checkbox has been selected. | |
| c_tax | isdocumentlevel | if the tax is calculated on document level, all lines with that tax rate are added before calculating the total tax for the document.otherwise the tax is calculated per line and then added.due to rounding, the tax amount can differ. | |
| c_tax | requirestaxcertificate | the requires tax certificate indicates that a tax certificate is required for a business partner to be tax exempt. | |
| c_taxcategory | commoditycode | the commodity code indicates a code that is used in tax calculations | |
| fact_acct | gl_budget_id | the general ledger budget identifies a user defined budget. these can be used in reporting as a comparison against your actual amounts. | |
| i_order | freightamt | the freight amount indicates the amount charged for freight in the document currency. | |
| m_attribute | m_attributesearch_id | attributes are specific to a product attribute set (e.g. size for t-shirts: s,m,l). if you have multiple attributes and want to search under a common sttribute, you define a search sttribute. example: have one size search attribute combining the values of all different sizes (size for dress shirt xl,l,m,s,xs). the attribute search allows you to have all values available for selection. this eases the maintenance of the individual product attribute. | |
| m_inout | sendemail | send emails with document attached (e.g. invoice, delivery note, etc.) | |
| m_inoutline | lot | the lot number indicates the specific lot that a product was part of. | |
| m_inoutline | serno | the serial number identifies a tracked, warranted product. it can only be used when the quantity is 1. | |
| m_product | c_revenuerecognition_id | the revenue recognition indicates how revenue will be recognized for this product | |
| m_product | ma_producttype_id | ||
| m_product | r_mailtext_id | the mail template indicates the mail template for return messages. | |
| m_productionplan | realcost | real cost | |
| mrp_run_purchase | recalculatestock | process to recalculate the product quantities of the lines. | |
| m_shipper | trackingurl | the variable @trackingno@ in the url is replaced by the actual tracking number of the shipment. | |
| r_interestarea | isselfservice | self-service allows users to enter data or update their data. the flag indicates, that this record was entered or created via self-service or that the user can change it via the self-service functionality. | |
| s_timeexpense | isapproved | the approved checkbox indicates if this document requires approval before it can be processed. |
Custom code Deprecated
| Table Name | Column Name | Description | Comment |
|---|---|---|---|
| ad_org | upc | use this field to enter the bar code for the product in any of the bar code symbologies (codabar, code 25, code 39, code 93, code 128, upc (a), upc (e), ean-13, ean-8, itf, itf-14, isbn, issn, jan-13, jan-8, postnet and fim, msi/plessey, and pharmacode) | |
| c_bpartner | ismanager | ||
| c_bpartner | isworker | ||
| c_bpartner | managers | ||
| c_bpartner | m_wh_schedule_id | the warehouse schedule id identifies a unique schedule for renting locators. | |
| c_bpartner | storagepaymentrule | ||
| c_orderline | lastpriceso | the last sales order price of the product with the business partner of the sales order | |
| c_tax | isprinttax | ||
| ma_ccp_group | hassecproduct | indicates that the group has a secondary product. | |
| ma_measure_group | hassecproduct | indicates that the group has a secondary product. | |
| ma_measure_group | product | is the product that is being measured. | |
| ma_measure_shift | lot | the lot number indicates the specific lot that a product was part of. | |
| ma_measure_shift | product | is the product that is being measured. | |
| ma_measure_shift | sellbydate | ||
| ma_sequenceproduct | consumerm | ||
| ma_sequenceproduct | decreaseind | ||
| ma_sequenceproduct | rminput | ||
| ma_workrequirement | wrtype | ||
| ma_wrphaseproduct | consumerm | ||
| ma_wrphaseproduct | decreaseind | ||
| m_inout | updatelines | update attribute lines from shipment | |
| m_inoutline | m_inoutline_type_id | the id identifies a unique record | |
| m_locator | invoicingtype | how to invoice a locator is being renting | |
| m_locator | m_locator_type_id | the id identifies the unique type for the locator | |
| m_locator | sizemultiplier | ||
| m_product | bundle_uom | ||
| m_product | greenpoint_uom | ||
| m_product | upc2 | ||
| m_productionline | printlabel | process to print labels for the product. | |
| m_productionline | secquality | ||
| m_warehouse | locatorunitsperpallet | ||
| m_warehouse | warehouse_size |
Categories: Development | Legacy