legal/CompiereAddendum.txt
author Iván Perdomo <ivan.perdomo@openbravo.com>
Fri, 22 Oct 2010 01:54:26 +0200
changeset 8742 e8e32dd85644
parent 3135 bb9f33f7270b
permissions -rw-r--r--
[communityBranding] Fixes script in IE
- IE is reporting 'loaded' status instead of 'complete' therefore the callback
was never executed
- Small format changes (spaces instead of tab)
juanpablo@797
     1
This file contains a description of the usage of Compiere Inc. assets within
juanpablo@797
     2
Openbravo ERP and the changes that Openbravo implemented on those assets.
juanpablo@797
     3
juanpablo@797
     4
Java and XSQL Code
juanpablo@797
     5
------------------
juanpablo@797
     6
Some Java and XSQL files are inspired by Compiere ERP & CRM v.2.5.0c. In 
juanpablo@797
     7
particular, some of Openbravo Java classes use some Compiere files as model
juanpablo@797
     8
and replicate their business logic in a different implementation.
juanpablo@797
     9
The following list contains the name of the Openbravo files that have been
juanpablo@797
    10
developed in this manner and maps them to the Compiere files that have been
juanpablo@797
    11
used as model:
juanpablo@797
    12
juanpablo@797
    13
  Openbravo Path                              Openbravo File                Compiere Path                    Compiere file
juanpablo@797
    14
  --------------                              --------------                -------------                   -------------
juanpablo@797
    15
  src/org/openbravo/erpCommon/ad_forms        Account.java                  base/src/org/compiere/model     Account.java
juanpablo@797
    16
  src/org/openbravo/erpCommon/ad_forms        Account_data.xsql             base/src/org/compiere/model     Account.java
juanpablo@797
    17
  src/org/openbravo/erpCommon/ad_forms        AcctSchema.java               base/src/org/compiere/model     AcctSchema.java
juanpablo@797
    18
  src/org/openbravo/erpCommon/ad_forms        AcctSchema_data.xsql          base/src/org/compiere/model     AcctSchema.java
juanpablo@797
    19
  src/org/openbravo/erpCommon/ad_forms        AcctSchemaElement.java        base/src/org/compiere/model     AcctSchemaElement.java
juanpablo@797
    20
  src/org/openbravo/erpCommon/ad_forms        AcctSchemaElement_data.xsql   base/src/org/compiere/model     AcctSchemaElement.java
juanpablo@797
    21
  src/org/openbravo/erpCommon/ad_forms        AcctServer.java               server/src/org/compiere/acct    AcctServer.java + DocVO.java
juanpablo@797
    22
  src/org/openbravo/erpCommon/ad_forms        AcctServer_data.xsql          server/src/org/compiere/acct    AcctServer.java + DocVO.java
juanpablo@797
    23
  src/org/openbravo/erpCommon/ad_forms        DocBank.java                  server/src/org/compiere/acct    Doc_Bank.java
juanpablo@797
    24
  src/org/openbravo/erpCommon/ad_forms        DocBank_data.xsql             server/src/org/compiere/acct    Doc_Bank.java
juanpablo@797
    25
  src/org/openbravo/erpCommon/ad_forms        DocCash.java                  server/src/org/compiere/acct    Doc_Cash.java
juanpablo@797
    26
  src/org/openbravo/erpCommon/ad_forms        DocCash_data.xsql             server/src/org/compiere/acct    Doc_Cash.java
juanpablo@797
    27
  src/org/openbravo/erpCommon/ad_forms        DocGLJournal.java             server/src/org/compiere/acct    Doc_GLJournal.java
juanpablo@797
    28
  src/org/openbravo/erpCommon/ad_forms        DocGLJournal_data.xsql        server/src/org/compiere/acct    Doc_GLJournal.java
juanpablo@797
    29
  src/org/openbravo/erpCommon/ad_forms        DocInOut.java                 server/src/org/compiere/acct    Doc_InOut.java
juanpablo@797
    30
  src/org/openbravo/erpCommon/ad_forms        DocInOut_data.xsql            server/src/org/compiere/acct    Doc_InOut.java
juanpablo@797
    31
  src/org/openbravo/erpCommon/ad_forms        DocInventory.java             server/src/org/compiere/acct    Doc_Inventory.java
juanpablo@797
    32
  src/org/openbravo/erpCommon/ad_forms        DocInventory_data.xsql        server/src/org/compiere/acct    Doc_Inventory.java
juanpablo@797
    33
  src/org/openbravo/erpCommon/ad_forms        DocInvoice.java               server/src/org/compiere/acct    Doc_Invoice.java
juanpablo@797
    34
  src/org/openbravo/erpCommon/ad_forms        DocInvoice_data.xsql          server/src/org/compiere/acct    Doc_Invoice.java
juanpablo@797
    35
  src/org/openbravo/erpCommon/ad_forms        DocLine.java                  server/src/org/compiere/acct    DocLine.java
juanpablo@797
    36
  src/org/openbravo/erpCommon/ad_forms        DocLineBank_data.xsql         server/src/org/compiere/acct    DocLine_Bank.java
juanpablo@797
    37
  src/org/openbravo/erpCommon/ad_forms        DocLineCash_data.xsql         server/src/org/compiere/acct    DocLine_Cash.java
juanpablo@797
    38
  src/org/openbravo/erpCommon/ad_forms        DocLineGLJournal_data.xsql    server/src/org/compiere/acct    DocLine.java
juanpablo@797
    39
  src/org/openbravo/erpCommon/ad_forms        DoclineInOut_data.xsql        server/src/org/compiere/acct    DocLine.java
juanpablo@797
    40
  src/org/openbravo/erpCommon/ad_forms        DocLineInventory_data.xsql    server/src/org/compiere/acct    DocLine.java
juanpablo@797
    41
  src/org/openbravo/erpCommon/ad_forms        DoclineInvoice_data.xsql      server/src/org/compiere/acct    DocLine.java
juanpablo@797
    42
  src/org/openbravo/erpCommon/ad_forms        DocLineMaterial_data.xsql     server/src/org/compiere/acct    DocLine_Material.java
juanpablo@797
    43
  src/org/openbravo/erpCommon/ad_forms        DocLineMovement_data.xsql     server/src/org/compiere/acct    DocLine.java
juanpablo@797
    44
  src/org/openbravo/erpCommon/ad_forms        DocLineOrder.xsql             server/src/org/compiere/acct    DocLine.java
juanpablo@797
    45
  src/org/openbravo/erpCommon/ad_forms        DocLine_Bank.java             server/src/org/compiere/acct    DocLine_Bank.java
juanpablo@797
    46
  src/org/openbravo/erpCommon/ad_forms        DocLine_Cash.java             server/src/org/compiere/acct    DocLine_Cash.java
juanpablo@797
    47
  src/org/openbravo/erpCommon/ad_forms        DocLine_data.xsql             server/src/org/compiere/acct    DocLine.java
juanpablo@797
    48
  src/org/openbravo/erpCommon/ad_forms        DocLine_Invoice.java          server/src/org/compiere/acct    DocLine_Invoice.java
juanpablo@797
    49
  src/org/openbravo/erpCommon/ad_forms        DocLine_Material.java         server/src/org/compiere/acct    DocLine_Material.java
juanpablo@797
    50
  src/org/openbravo/erpCommon/ad_forms        DocMovement.java              server/src/org/compiere/acct    Doc_Movement.java
juanpablo@797
    51
  src/org/openbravo/erpCommon/ad_forms        DocMovement_data.xsql         server/src/org/compiere/acct    Doc_Movement.java
juanpablo@797
    52
  src/org/openbravo/erpCommon/ad_forms        DocOrder.java                 server/src/org/compiere/acct    Doc_Order.java
juanpablo@797
    53
  src/org/openbravo/erpCommon/ad_forms        DocOrder_data.xsql            server/src/org/compiere/acct    Doc_Order.java
juanpablo@797
    54
  src/org/openbravo/erpCommon/ad_forms        DocTax.java                   server/src/org/compiere/acct    DocTax.java
juanpablo@797
    55
  src/org/openbravo/erpCommon/ad_forms        DocTax_data.xsql              server/src/org/compiere/acct    DocTax.java
juanpablo@797
    56
  src/org/openbravo/erpCommon/ad_forms        Fact.java                     server/src/org/compiere/acct    Fact.java
juanpablo@797
    57
  src/org/openbravo/erpCommon/ad_forms        FactLine.java                 server/src/org/compiere/acct    FactLine.java
juanpablo@797
    58
  src/org/openbravo/erpCommon/ad_forms        FactLine_data.xsql            server/src/org/compiere/acct    FactLine.java
juanpablo@797
    59
  src/org/openbravo/erpCommon/ad_forms        ProductInfo.java              server/src/org/compiere/acct    ProductInfo.java
juanpablo@797
    60
  src/org/openbravo/erpCommon/ad_forms        ProductInfo_data.xsql         server/src/org/compiere/acct    ProductInfo.java
juanpablo@797
    61
  src/org/openbravo/erpCommon/ad_forms        Translation.java              client/Src/org/compiere/install Translation.java
juanpablo@797
    62
  src/org/openbravo/erpCommon/ad_forms        TranslationHandler.java       client/Src/org/compiere/install TranslationHandler.java
juanpablo@797
    63
  src/org/openbravo/erpCommon/process         ImportAccount.java            base/src/org/compiere/process   ImportAccount.java
juanpablo@797
    64
  src/org/openbravo/erpCommon/process         ImportAccountServlet.java     base/src/org/compiere/process   ImportAccount.java
juanpablo@797
    65
  src/org/openbravo/erpCommon/process         ImportAccount_data.xsql       base/src/org/compiere/process   ImportAccount.java
juanpablo@797
    66
  src/org/openbravo/erpCommon/process         ImportBPartner.java           base/src/org/compiere/process   ImportBPartner.java
juanpablo@797
    67
  src/org/openbravo/erpCommon/process         ImportBPartnerServlet.java    base/src/org/compiere/process   ImportBPartner.java
juanpablo@797
    68
  src/org/openbravo/erpCommon/process         ImportBPartner_data.xsql      base/src/org/compiere/process   ImportBPartner.java
juanpablo@797
    69
  src/org/openbravo/erpCommon/process         ImportOrder.java              base/src/org/compiere/process   ImportOrder.java
juanpablo@797
    70
  src/org/openbravo/erpCommon/process         ImportOrderServlet.java       base/src/org/compiere/process   ImportOrder.java
juanpablo@797
    71
  src/org/openbravo/erpCommon/process         ImportOrderServlet_data.xsql  base/src/org/compiere/process   ImportOrder.java
juanpablo@797
    72
  src/org/openbravo/erpCommon/process         ImportOrder_data.xsql         base/src/org/compiere/process   ImportOrder.java
juanpablo@797
    73
  src/org/openbravo/erpCommon/ad_process      SendMailText.java             base/src/org/compiere/process   SendMailText.java
juanpablo@797
    74
  src/org/openbravo/erpCommon/ad_process      SendMailText_data.xsql        base/src/org/compiere/process   SendMailText.java
juanpablo@797
    75
  src/org/openbravo/erpCommon/businessUtility AccountTree.java              base/src/org/compiere/model     Account.java
juanpablo@797
    76
  src/org/openbravo/erpCommon/businessUtility AccountTree_data.xsql         base/src/org/compiere/model     Account.java
juanpablo@797
    77
  src/org/openbravo/erpCommon/businessUtility ByteArrayDatasource.java      base/src/org/compiere/util      ByteArrayDataSource.java
juanpablo@797
    78
  src/org/openbravo/erpCommon/businessUtility Email.java                    base/src/org/compiere/util      EMail.java
juanpablo@797
    79
  src/org/openbravo/erpCommon/businessUtility EMailAuthenticator.java       base/src/org/compiere/util      EMailAuthenticator.java
juanpablo@797
    80
juanpablo@797
    81
PL/SQL Code
juanpablo@797
    82
-----------
juanpablo@797
    83
The following PL/SQL functions, procedures and triggers were originally
juanpablo@797
    84
developed by Compiere Inc. and distributed in Compiere ERP & CRM v.2.5.0c. 
juanpablo@797
    85
Openbravo has modified them in order to satisfy its own functional and
juanpablo@2071
    86
technical requirements. Whenever the name was change, the PL/SQL object is 
juanpablo@2071
    87
listed with its new name and the original Compiere name is reported in brackets.
juanpablo@797
    88
This PL/SQL code is currently distributed by Openbravo using XML files stored
juanpablo@797
    89
in the /src-db/database folder and named after the database objects
juanpablo@797
    90
themselves. Each file properly identifies Compiere Inc. as the original 
juanpablo@797
    91
developer using comments.
juanpablo@797
    92
  Type          Name
juanpablo@797
    93
  ----          ----
juanpablo@797
    94
  FUNCTION      AD_MESSAGE_GET
juanpablo@797
    95
  FUNCTION      AD_SEQUENCE_NEXTNO
juanpablo@2071
    96
  FUNCTION      M_BOM_PRICELIMIT (original name: BOM_PRICELIMIT)
juanpablo@2071
    97
  FUNCTION      M_BOM_PRICELIST (original name: BOM_PRICELIST)
juanpablo@2071
    98
  FUNCTION      M_BOM_PRICESTD (original name: BOM_PRICESTD)
juanpablo@2071
    99
  FUNCTION      M_BOM_QTY_AVAILABLE (original name: BOM_QTY_AVAILABLE)
juanpablo@2071
   100
  FUNCTION      M_BOM_QTY_ONHAND (original name: BOM_QTY_ONHAND)
juanpablo@2071
   101
  FUNCTION      M_BOM_QTY_ORDERED (original name: BOM_QTY_ORDERED)
juanpablo@2071
   102
  FUNCTION      M_BOM_QTY_RESERVED (original name: BOM_QTY_RESERVED)
juanpablo@797
   103
  FUNCTION      C_BASE_CONVERT
juanpablo@797
   104
  FUNCTION      C_CURRENCY_CONVERT
juanpablo@797
   105
  FUNCTION      C_CURRENCY_CONVERT0
juanpablo@797
   106
  FUNCTION      C_CURRENCY_RATE
juanpablo@797
   107
  FUNCTION      C_CURRENCY_ROUND
juanpablo@797
   108
  FUNCTION      C_UOM_CONVERT
juanpablo@797
   109
  FUNCTION      GL_PERIOD_OPEN
juanpablo@797
   110
  FUNCTION      R_REQUEST_DUETYPE
juanpablo@797
   111
  PROCEDURE     A_ASSET_CREATE
juanpablo@797
   112
  PROCEDURE     AD_IMPFORMAT_COPY
juanpablo@797
   113
  PROCEDURE     AD_LANGUAGE_CREATE
juanpablo@797
   114
  PROCEDURE     AD_SEQUENCE_DOC
juanpablo@797
   115
  PROCEDURE     AD_SEQUENCE_DOCTYPE
juanpablo@797
   116
  PROCEDURE     AD_SEQUENCE_NEXT
juanpablo@797
   117
  PROCEDURE     AD_SYNCHRONIZE
juanpablo@797
   118
  PROCEDURE     AD_TAB_COPY
juanpablo@797
   119
  PROCEDURE     AD_TAB_IMPORT
juanpablo@797
   120
  PROCEDURE     AD_TAB_IMPORT0
juanpablo@797
   121
  PROCEDURE     AD_TABLE_IMPORT
juanpablo@797
   122
  PROCEDURE     AD_TABLE_IMPORT0
juanpablo@797
   123
  PROCEDURE     AD_WINDOW_COPY
juanpablo@797
   124
  PROCEDURE     C_ACCTSCHEMA_DEFAULT_COPY
juanpablo@797
   125
  PROCEDURE     C_BANKSTATEMENT_POST
juanpablo@797
   126
  PROCEDURE     C_BP_GROUP_ACCT_COPY
juanpablo@797
   127
  PROCEDURE     C_CASH_POST
juanpablo@797
   128
  PROCEDURE     C_COMMISSION_COPY
juanpablo@797
   129
  PROCEDURE     C_COMMISSION_PROCESS
juanpablo@797
   130
  PROCEDURE     C_COMMISSIONRUN_PROCESS
juanpablo@797
   131
  PROCEDURE     C_ELEMENTVALUE_COPY
juanpablo@797
   132
  PROCEDURE     C_INVOICE_CANCEL
juanpablo@797
   133
  PROCEDURE     C_INVOICE_CREATE
juanpablo@797
   134
  PROCEDURE     C_INVOICE_CREATERECEIPT
juanpablo@797
   135
  PROCEDURE     C_INVOICE_CREATE0
juanpablo@797
   136
  PROCEDURE     C_INVOICE_POST
juanpablo@797
   137
  PROCEDURE     C_INVOICE_POST0
juanpablo@797
   138
  PROCEDURE     C_ORDER_DRILLDOWN
juanpablo@797
   139
  PROCEDURE     C_ORDER_PO_CREATE
juanpablo@797
   140
  PROCEDURE     C_ORDER_POST
juanpablo@797
   141
  PROCEDURE     C_PERIODCONTROL_PROCESS
juanpablo@797
   142
  PROCEDURE     C_PERIOD_PROCESS
juanpablo@797
   143
  PROCEDURE     C_PROJECT_GENERATE
juanpablo@797
   144
  PROCEDURE     C_VALIDCOMBINATION_GET
juanpablo@797
   145
  PROCEDURE     C_YEARPERIODS
juanpablo@797
   146
  PROCEDURE     FACT_ACCT_RESET
juanpablo@797
   147
  PROCEDURE     GL_JOURNALBATCH_POST
juanpablo@797
   148
  PROCEDURE     GL_JOURNAL_POST
juanpablo@797
   149
  PROCEDURE     GL_JOURNAL_POST0
juanpablo@797
   150
  PROCEDURE     IMPORT_PRODUCT
juanpablo@797
   151
  PROCEDURE     M_DISCOUNTSCHEMA_RESEQ
juanpablo@797
   152
  PROCEDURE     M_INOUT_CANCEL
juanpablo@797
   153
  PROCEDURE     M_INOUT_CREATE
juanpablo@797
   154
  PROCEDURE     M_INOUT_CREATEINVOICE
juanpablo@797
   155
  PROCEDURE     M_INOUT_CREATE0
juanpablo@797
   156
  PROCEDURE     M_INOUT_POST
juanpablo@797
   157
  PROCEDURE     M_INOUT_POST0
juanpablo@797
   158
  PROCEDURE     M_INVENTORY_LISTCREATE
juanpablo@797
   159
  PROCEDURE     M_INVENTORY_LISTUPDATE
juanpablo@797
   160
  PROCEDURE     M_INVENTORY_POST
juanpablo@797
   161
  PROCEDURE     M_MOVEMENT_POST
juanpablo@797
   162
  PROCEDURE     M_PRICELIST_CREATE
juanpablo@797
   163
  PROCEDURE     M_PRODUCT_BOM_CHECK
juanpablo@797
   164
  PROCEDURE     M_PRODUCT_CATEGORY_ACCT_COPY
juanpablo@797
   165
  PROCEDURE     M_PRODUCT_DELETE
juanpablo@797
   166
  PROCEDURE     M_PRODUCTION_RUN
juanpablo@797
   167
  PROCEDURE     R_REQUEST_PROCESS
juanpablo@797
   168
  PROCEDURE     R_REQUEST_PROCESS0
juanpablo@797
   169
  PROCEDURE     R_REQUEST_REOPEN
juanpablo@797
   170
  PROCEDURE     S_TIMEEXPENSE_POST
juanpablo@797
   171
  TRIGGER       AD_CLIENT_TRG
juanpablo@797
   172
  TRIGGER       AD_COLUMN_TRG
juanpablo@797
   173
  TRIGGER       AD_ELEMENT_TRG
juanpablo@797
   174
  TRIGGER       AD_ELEMENT_TRL_TRG
juanpablo@797
   175
  TRIGGER       AD_FIELDGROUP_TRG
juanpablo@797
   176
  TRIGGER       AD_FIELD_TRG
juanpablo@797
   177
  TRIGGER       AD_FORM_TRG
juanpablo@797
   178
  TRIGGER       AD_MENU_TRG
juanpablo@797
   179
  TRIGGER       AD_MESSAGE_TRG
juanpablo@797
   180
  TRIGGER       AD_ORG_TRG
juanpablo@797
   181
  TRIGGER       AD_PROCESS_PARA_TRG
juanpablo@797
   182
  TRIGGER       AD_PROCESS_TRG
juanpablo@797
   183
  TRIGGER       AD_PROCESS_TRL_TRG
juanpablo@797
   184
  TRIGGER       AD_REFERENCE_TRG
juanpablo@797
   185
  TRIGGER       AD_REF_LIST_TRG
juanpablo@797
   186
  TRIGGER       AD_ROLE_ORGACCESS_TRG
juanpablo@797
   187
  TRIGGER       AD_ROLE_TRG
juanpablo@797
   188
  TRIGGER       AD_TABLE_TRG
juanpablo@797
   189
  TRIGGER       AD_TAB_TRG
juanpablo@797
   190
  TRIGGER       AD_TASK_TRG
juanpablo@797
   191
  TRIGGER       AD_TREE_TRG
juanpablo@797
   192
  TRIGGER       AD_WF_NODE_TRG
juanpablo@797
   193
  TRIGGER       AD_WINDOW_TRG
juanpablo@797
   194
  TRIGGER       AD_WINDOW_TRL_TRG
juanpablo@797
   195
  TRIGGER       AD_WORKFLOW_TRG
juanpablo@797
   196
  TRIGGER       C_ACCTSCHEMA_ELEMENT_TRG
juanpablo@797
   197
  TRIGGER       C_BANKACCOUNT_TRG
juanpablo@797
   198
  TRIGGER       C_BANKSTATEMENTLINE_TRG
juanpablo@797
   199
  TRIGGER       C_BANKSTATEMENT_TRG
juanpablo@797
   200
  TRIGGER       C_BPARTNER_LOCATION_TRG
juanpablo@797
   201
  TRIGGER       C_BPARTNER_TRG
juanpablo@797
   202
  TRIGGER       C_BP_GROUP_TRG
juanpablo@797
   203
  TRIGGER       C_CASHBOOK_TRG
juanpablo@797
   204
  TRIGGER       C_CASHLINE_TRG
juanpablo@797
   205
  TRIGGER       C_CASH_TRG
juanpablo@797
   206
  TRIGGER       C_CHARGE_TRG
juanpablo@797
   207
  TRIGGER       C_COMMISSIONAMT_TRG
juanpablo@797
   208
  TRIGGER       C_COMMISSIONDETAIL_TRG
juanpablo@797
   209
  TRIGGER       C_CONVERSION_RATE_TRG
juanpablo@797
   210
  TRIGGER       C_DOCTYPE_TRG
juanpablo@797
   211
  TRIGGER       C_ELEMENTVALUE_TRG
juanpablo@797
   212
  TRIGGER       C_GREETING_TRG
juanpablo@797
   213
  TRIGGER       C_INVOICELINE_TRG
juanpablo@797
   214
  TRIGGER       C_INVOICETAX_TRG
juanpablo@797
   215
  TRIGGER       C_ORDERLINE_TRG
juanpablo@797
   216
  TRIGGER       C_ORDERTAX_TRG
juanpablo@797
   217
  TRIGGER       C_ORDER_TRG
juanpablo@797
   218
  TRIGGER       C_PAYMENTTERM_TRG
juanpablo@797
   219
  TRIGGER       C_PERIOD_TRG
juanpablo@797
   220
  TRIGGER       C_PERIOD_TRG2
juanpablo@797
   221
  TRIGGER       C_PROJECTLINE_TRG
juanpablo@797
   222
  TRIGGER       C_PROJECTLINE_TRG2
juanpablo@797
   223
  TRIGGER       C_PROJECT_TRG
juanpablo@797
   224
  TRIGGER       C_PROJECT_TRG2
juanpablo@797
   225
  TRIGGER       C_REVENUERECOGNITION_PLAN_TRG
juanpablo@797
   226
  TRIGGER       C_SALESREGION_TRG
juanpablo@797
   227
  TRIGGER       C_TAXCATEGORY_TRG
juanpablo@797
   228
  TRIGGER       C_TAX_TRG
juanpablo@797
   229
  TRIGGER       C_UOM_TRG
juanpablo@797
   230
  TRIGGER       C_VALIDCOMBINATION_TRG
juanpablo@797
   231
  TRIGGER       C_WITHHOLDING_TRG
juanpablo@797
   232
  TRIGGER       GL_JOURNALLINE_TRG
juanpablo@797
   233
  TRIGGER       GL_JOURNAL_TRG
juanpablo@797
   234
  TRIGGER       M_INOUTLINE_TRG
juanpablo@797
   235
  TRIGGER       M_INVENTORYLINE_TRG
juanpablo@797
   236
  TRIGGER       M_MATCHPO_TRG
juanpablo@797
   237
  TRIGGER       M_MOVEMENTLINE_TRG
juanpablo@797
   238
  TRIGGER       M_PRODUCT_BOM_TRG
juanpablo@797
   239
  TRIGGER       M_PRODUCT_CATEGORY_TRG
juanpablo@797
   240
  TRIGGER       M_PRODUCTIONLINE_TRG
juanpablo@797
   241
  TRIGGER       M_PRODUCTIONPLAN_TRG
juanpablo@797
   242
  TRIGGER       M_PRODUCT_TRG
juanpablo@797
   243
  TRIGGER       M_WAREHOUSE_TRG
juanpablo@797
   244
  TRIGGER       S_EXPENSETYPE_TRG
juanpablo@797
   245
  TRIGGER       S_RESOURCEASSIGNMENT_TRG
juanpablo@797
   246
  TRIGGER       S_RESOURCE_TRG
juanpablo@797
   247
  TRIGGER       S_RESOURCETYPE_TRG
juanpablo@797
   248
  TRIGGER       S_RESOURCEUNAVAILABLE_TRG
juanpablo@797
   249
juanpablo@797
   250
juanpablo@797
   251
Database Tables
juanpablo@797
   252
---------------
juanpablo@797
   253
The following database tables and views were originally designed by Compiere
juanpablo@797
   254
Inc. and distributed in Compiere ERP & CRM v.2.5.0c.
juanpablo@797
   255
Openbravo modified them in order to satisfy its own functional and technical
juanpablo@2071
   256
requirements. Whenever the name was change, the table is listed with its new
juanpablo@2071
   257
name and the original Compiere name is reported in brackets:
juanpablo@797
   258
juanpablo@2071
   259
  A_ASSET
juanpablo@2071
   260
  A_ASSET_GROUP
juanpablo@2071
   261
  AD_ALERT
juanpablo@2071
   262
  AD_ALERTRECIPIENT
juanpablo@2071
   263
  AD_ALERTRULE
juanpablo@2071
   264
  AD_ATTACHMENT
juanpablo@2071
   265
  AD_CHANGELOG
juanpablo@2071
   266
  AD_CLIENT
juanpablo@2071
   267
  AD_CLIENTINFO
juanpablo@2071
   268
  AD_COLUMN
juanpablo@2071
   269
  AD_COLUMN_ACCESS
juanpablo@2071
   270
  AD_ELEMENT
juanpablo@2071
   271
  AD_ELEMENT_TRL
juanpablo@2071
   272
  AD_FIELD
juanpablo@2071
   273
  AD_FIELD_TRL
juanpablo@2071
   274
  AD_FIELDGROUP
juanpablo@2071
   275
  AD_FIELDGROUP_TRL
juanpablo@2071
   276
  AD_FORM
juanpablo@2071
   277
  AD_FORM_ACCESS
juanpablo@2071
   278
  AD_FORM_TRL
juanpablo@2071
   279
  AD_IMAGE
juanpablo@2071
   280
  AD_IMPFORMAT
juanpablo@2071
   281
  AD_IMPFORMAT_ROW
juanpablo@2071
   282
  AD_LANGUAGE
juanpablo@2071
   283
  AD_MENU
juanpablo@2071
   284
  AD_MENU_TRL
juanpablo@2071
   285
  AD_MESSAGE
juanpablo@2071
   286
  AD_MESSAGE_TRL
juanpablo@2071
   287
  AD_NOTE
juanpablo@2071
   288
  AD_ORG
juanpablo@2071
   289
  AD_ORGINFO
juanpablo@2071
   290
  AD_PINSTANCE
juanpablo@2071
   291
  AD_PINSTANCE_PARA
juanpablo@2071
   292
  AD_PREFERENCE
juanpablo@2071
   293
  AD_PROCESS
juanpablo@2071
   294
  AD_PROCESS_ACCESS
juanpablo@2071
   295
  AD_PROCESS_PARA
juanpablo@2071
   296
  AD_PROCESS_PARA_TRL
juanpablo@2071
   297
  AD_PROCESS_TRL
juanpablo@2071
   298
  AD_RECORD_ACCESS
juanpablo@2071
   299
  AD_REF_LIST
juanpablo@2071
   300
  AD_REF_LIST_TRL
juanpablo@2071
   301
  AD_REF_TABLE
juanpablo@2071
   302
  AD_REFERENCE
juanpablo@2071
   303
  AD_REFERENCE_TRL
juanpablo@2071
   304
  AD_ROLE
juanpablo@2071
   305
  AD_ROLE_ORGACCESS
juanpablo@2071
   306
  AD_SEQUENCE
juanpablo@2071
   307
  AD_SESSION
juanpablo@2071
   308
  AD_SYSTEM
juanpablo@2071
   309
  AD_TAB
juanpablo@2071
   310
  AD_TAB_TRL
juanpablo@797
   311
  AD_TABLE
juanpablo@2071
   312
  AD_TABLE_ACCESS
juanpablo@2071
   313
  AD_TASK
juanpablo@2071
   314
  AD_TASK_ACCESS
juanpablo@2071
   315
  AD_TASK_TRL
juanpablo@2071
   316
  AD_TEST (original name: TEST)
juanpablo@2071
   317
  AD_TREE
juanpablo@2071
   318
  AD_TREEBAR
juanpablo@2071
   319
  AD_TREENODE
juanpablo@2071
   320
  AD_TREENODEBP
juanpablo@2071
   321
  AD_TREENODEMM
juanpablo@2071
   322
  AD_TREENODEPR
juanpablo@2071
   323
  AD_USER
juanpablo@2071
   324
  AD_USER_ROLES
juanpablo@797
   325
  AD_VAL_RULE
juanpablo@797
   326
  AD_WF_NODE
juanpablo@797
   327
  AD_WF_NODE_TRL
juanpablo@797
   328
  AD_WF_NODENEXT
juanpablo@2071
   329
  AD_WINDOW
juanpablo@2071
   330
  AD_WINDOW_ACCESS
juanpablo@797
   331
  AD_WINDOW_TRL
juanpablo@2071
   332
  AD_WORKFLOW
juanpablo@2071
   333
  AD_WORKFLOW_ACCESS
juanpablo@797
   334
  AD_WORKFLOW_TRL
juanpablo@2071
   335
  C_ACCTSCHEMA
juanpablo@2071
   336
  C_ACCTSCHEMA_DEFAULT
juanpablo@2071
   337
  C_ACCTSCHEMA_ELEMENT
juanpablo@2071
   338
  C_ACCTSCHEMA_GL
juanpablo@2071
   339
  C_ACTIVITY
juanpablo@2071
   340
  C_BANK
juanpablo@2071
   341
  C_BANKACCOUNT
juanpablo@2071
   342
  C_BANKACCOUNT_ACCT
juanpablo@2071
   343
  C_BANKSTATEMENT
juanpablo@2071
   344
  C_BANKSTATEMENTLINE
juanpablo@2071
   345
  C_BP_BANKACCOUNT
juanpablo@2071
   346
  C_BP_CUSTOMER_ACCT
juanpablo@2071
   347
  C_BP_EMPLOYEE_ACCT
juanpablo@2071
   348
  C_BP_GROUP
juanpablo@2071
   349
  C_BP_GROUP_ACCT
juanpablo@2071
   350
  C_BP_VENDOR_ACCT
juanpablo@2071
   351
  C_BP_WITHHOLDING
juanpablo@2071
   352
  C_BPARTNER
juanpablo@2071
   353
  C_BPARTNER_V (original name: RV_BPARTNER)
juanpablo@2071
   354
  C_BPARTNER_LOCATION
juanpablo@797
   355
  C_CALENDAR
juanpablo@2071
   356
  C_CAMPAIGN
juanpablo@2071
   357
  C_CASH
juanpablo@2071
   358
  C_CASH_DETAIL (original name: RV_CASH_DETAIL)
juanpablo@2071
   359
  C_CASHBOOK
juanpablo@2071
   360
  C_CASHBOOK_ACCT
juanpablo@2071
   361
  C_CASHLINE
juanpablo@2071
   362
  C_CHANNEL
juanpablo@2071
   363
  C_CHARGE
juanpablo@2071
   364
  C_CHARGE_ACCT
juanpablo@2071
   365
  C_INVOICE_V2 (original name: RV_C_INVOICE)
juanpablo@2071
   366
  C_INVOICE_CUSTOMERPRODQTR (original name: RV_C_INVOICE_CUSTOMERPRODQTR)
juanpablo@2071
   367
  C_INVOICE_CUSTOMERVENDQTR (original name: RV_C_INVOICE_CUSTOMERVENDQTR)
juanpablo@2071
   368
  C_INVOICE_DAY (original name: RV_C_INVOICE_DAY)
juanpablo@2071
   369
  C_INVOICE_MONTH (original name: RV_C_INVOICE_MONTH)
juanpablo@2071
   370
  C_INVOICE_PRODMONTH (original name: RV_C_INVOICE_PRODMONTH)
juanpablo@2071
   371
  C_INVOICE_PRODWEEK (original name: RV_C_INVOICE_PRODWEEK)
juanpablo@2071
   372
  C_INVOICE_VENDORMONTH (original name: RV_C_INVOICE_VENDORMONTH)
juanpablo@2071
   373
  C_INVOICE_WEEK (original name: RV_C_INVOICE_WEEK)
juanpablo@2071
   374
  C_INVOICELINE (original name: RV_C_INVOICELINE)
juanpablo@2071
   375
  C_CITY
juanpablo@2071
   376
  C_COMMISSION
juanpablo@2071
   377
  C_COMMISSIONAMT
juanpablo@2071
   378
  C_COMMISSIONDETAIL
juanpablo@2071
   379
  C_COMMISSIONLINE
juanpablo@2071
   380
  C_COMMISSIONRUN
juanpablo@797
   381
  C_CONVERSION_RATE
juanpablo@2071
   382
  C_COUNTRY
juanpablo@2071
   383
  C_COUNTRY_TRL
juanpablo@797
   384
  C_CURRENCY
juanpablo@2071
   385
  C_CURRENCY_TRL
juanpablo@2071
   386
  C_DEBT_PAYMENT_V
juanpablo@2071
   387
  C_DOCTYPE
juanpablo@2071
   388
  C_DOCTYPE_TRL
juanpablo@797
   389
  C_ELEMENT
juanpablo@2071
   390
  C_ELEMENTVALUE
juanpablo@2071
   391
  C_ELEMENTVALUE_TRL
juanpablo@2071
   392
  C_GREETING
juanpablo@2071
   393
  C_GREETING_TRL
juanpablo@2071
   394
  C_INTERORG_ACCT
juanpablo@2071
   395
  C_INVOICE
juanpablo@2071
   396
  C_INVOICE_HEADER_V
juanpablo@2071
   397
  C_INVOICE_LINETAX_V
juanpablo@2071
   398
  C_INVOICELINE
juanpablo@2071
   399
  C_INVOICESCHEDULE
juanpablo@2071
   400
  C_INVOICETAX
juanpablo@797
   401
  C_LOCATION
juanpablo@797
   402
  C_NONBUSINESSDAY
juanpablo@2071
   403
  C_ORDER
juanpablo@2071
   404
  C_ORDER_HEADER_V
juanpablo@2071
   405
  C_ORDER_LINETAX_V
juanpablo@2071
   406
  C_ORDERLINE
juanpablo@2071
   407
  C_ORDER_OPEN (original name: RV_ORDER_OPEN)
juanpablo@2071
   408
  C_ORDERTAX
juanpablo@2071
   409
  C_ORGASSIGNMENT
juanpablo@2071
   410
  C_PAYMENTTERM
juanpablo@2071
   411
  C_PAYMENTTERM_TRL
juanpablo@2071
   412
  C_PERIOD
juanpablo@2071
   413
  C_PERIODCONTROL
juanpablo@2071
   414
  C_PHASE
juanpablo@797
   415
  C_PROJECT
juanpablo@797
   416
  C_PROJECT_ACCT
juanpablo@2071
   417
  C_PROJECT_DETAILS_V
juanpablo@2071
   418
  C_PROJECT_HEADER_V
juanpablo@2071
   419
  C_PROJECTLINE
juanpablo@2071
   420
  C_PROJECTPHASE
juanpablo@2071
   421
  C_PROJECTTASK
juanpablo@2071
   422
  C_PROJECTTYPE
juanpablo@2071
   423
  C_REGION
juanpablo@2071
   424
  C_REVENUERECOGNITION
juanpablo@2071
   425
  C_REVENUERECOGNITION_PLAN
juanpablo@2071
   426
  C_REVENUERECOGNITION_RUN
juanpablo@2071
   427
  C_SALESREGION
juanpablo@2071
   428
  C_SERVICELEVEL
juanpablo@2071
   429
  C_SERVICELEVELLINE
juanpablo@2071
   430
  C_TASK
juanpablo@2071
   431
  C_TAX
juanpablo@2071
   432
  C_TAX_ACCT
juanpablo@2071
   433
  C_TAX_TRL
juanpablo@2071
   434
  C_TAXCATEGORY
juanpablo@2071
   435
  C_TAXCATEGORY_TRL
juanpablo@2071
   436
  C_UOM
juanpablo@2071
   437
  C_UOM_CONVERSION
juanpablo@2071
   438
  C_UOM_TRL
juanpablo@2071
   439
  C_VALIDCOMBINATION
juanpablo@2071
   440
  C_WITHHOLDING
juanpablo@2071
   441
  C_WITHHOLDING_ACCT
juanpablo@2071
   442
  C_YEAR
juanpablo@2071
   443
  FACT_ACCT
juanpablo@797
   444
  GL_CATEGORY
juanpablo@797
   445
  GL_JOURNAL
juanpablo@797
   446
  GL_JOURNALBATCH
juanpablo@797
   447
  GL_JOURNALLINE
juanpablo@2071
   448
  I_BANKSTATEMENT
juanpablo@2071
   449
  I_BPARTNER
juanpablo@2071
   450
  I_ELEMENTVALUE
juanpablo@2071
   451
  I_GLJOURNAL
juanpablo@2071
   452
  I_INVENTORY
juanpablo@2071
   453
  I_INVOICE
juanpablo@2071
   454
  I_ORDER
juanpablo@2071
   455
  I_PRODUCT
juanpablo@2071
   456
  M_ATTRIBUTE
juanpablo@2071
   457
  M_ATTRIBUTEINSTANCE
juanpablo@2071
   458
  M_ATTRIBUTESET
juanpablo@2071
   459
  M_ATTRIBUTESETINSTANCE
juanpablo@2071
   460
  M_ATTRIBUTEUSE
juanpablo@2071
   461
  M_ATTRIBUTEVALUE
juanpablo@2071
   462
  M_DISCOUNTSCHEMA
juanpablo@2071
   463
  M_DISCOUNTSCHEMALINE
juanpablo@2071
   464
  M_FREIGHT
juanpablo@2071
   465
  M_FREIGHTCATEGORY
juanpablo@797
   466
  M_INOUT
juanpablo@2071
   467
  M_INOUT_HEADER_V
juanpablo@2071
   468
  M_INOUT_LINE_V
juanpablo@797
   469
  M_INOUTLINE
juanpablo@797
   470
  M_INVENTORY
juanpablo@797
   471
  M_INVENTORYLINE
juanpablo@2071
   472
  M_LOCATOR
juanpablo@2071
   473
  M_LOT
juanpablo@2071
   474
  M_LOTCTL
juanpablo@2071
   475
  M_MATCHINV
juanpablo@2071
   476
  M_MATCHPO
juanpablo@797
   477
  M_MOVEMENT
juanpablo@797
   478
  M_MOVEMENTLINE
juanpablo@2071
   479
  M_PERPETUALINV
juanpablo@2071
   480
  M_PRICELIST
juanpablo@2071
   481
  M_PRICELIST_VERSION
juanpablo@2071
   482
  M_PRODUCT
juanpablo@2071
   483
  M_PRODUCT_ACCT
juanpablo@2071
   484
  M_PRODUCT_BOM
juanpablo@2071
   485
  M_PRODUCT_CATEGORY
juanpablo@2071
   486
  M_PRODUCT_CATEGORY_ACCT
juanpablo@2071
   487
  M_PRODUCT_PO
juanpablo@2071
   488
  M_PRODUCT_TRL
juanpablo@797
   489
  M_PRODUCTION
juanpablo@797
   490
  M_PRODUCTIONLINE
juanpablo@2071
   491
  M_PRODUCTIONPLAN
juanpablo@2071
   492
  M_PRODUCTPRICE
juanpablo@2071
   493
  M_REPLENISH
juanpablo@2071
   494
  M_SERNOCTL
juanpablo@2071
   495
  M_SHIPPER
juanpablo@2071
   496
  M_SUBSTITUTE
juanpablo@797
   497
  M_TRANSACTION
juanpablo@2071
   498
  M_TRANSACTION_V (original name: RV_M_TRANSACTION)
juanpablo@2071
   499
  M_TRANSACTION_SUM (original name: RV_M_TRANSACTION_SUM)
juanpablo@2071
   500
  M_WAREHOUSE
juanpablo@2071
   501
  M_WAREHOUSE_ACCT
juanpablo@2071
   502
  R_CONTACTINTEREST
juanpablo@2071
   503
  R_INTERESTAREA
juanpablo@797
   504
  R_MAILTEXT
juanpablo@797
   505
  R_REQUEST
juanpablo@797
   506
  R_REQUESTACTION
juanpablo@797
   507
  R_REQUESTPROCESSOR
juanpablo@797
   508
  R_REQUESTPROCESSOR_ROUTE
juanpablo@2071
   509
  R_REQUESTTYPE
juanpablo@2071
   510
  R_RESOURCEPLANCOST
juanpablo@2071
   511
  S_EXPENSETYPE
juanpablo@2071
   512
  S_RESOURCE
juanpablo@2071
   513
  S_RESOURCEASSIGNMENT
juanpablo@797
   514
  S_RESOURCETYPE
juanpablo@797
   515
  S_RESOURCEUNAVAILABLE
juanpablo@797
   516
  S_TIMEEXPENSE
juanpablo@797
   517
  S_TIMEEXPENSELINE
juanpablo@797
   518
  S_TIMETYPE
juanpablo@797
   519
juanpablo@797
   520
These tables and views are currently distributed by Openbravo using XML files
juanpablo@797
   521
stored in the /src-db/database folder and named after the tables themselves.
juanpablo@797
   522
juanpablo@797
   523
Database Records
juanpablo@797
   524
----------------
juanpablo@797
   525
The following database tables contain records that have been originally 
juanpablo@797
   526
defined by Compiere Inc. and distributed in Compiere ERP & CRM v.2.5.0c.
juanpablo@797
   527
Openbravo modified them in order to satisfy its own functional and
juanpablo@797
   528
technical requirements:
juanpablo@797
   529
juanpablo@797
   530
  AD_CLIENT
juanpablo@797
   531
  AD_CLIENTINFO
juanpablo@797
   532
  AD_COLUMN
juanpablo@797
   533
  AD_ELEMENT
juanpablo@797
   534
  AD_FIELD
juanpablo@797
   535
  AD_FIELDGROUP
juanpablo@797
   536
  AD_FORM
juanpablo@797
   537
  AD_IMPFORMAT
juanpablo@797
   538
  AD_IMPFORMAT_ROW
juanpablo@797
   539
  AD_LANGUAGE
juanpablo@797
   540
  AD_MENU
juanpablo@797
   541
  AD_MESSAGE
juanpablo@797
   542
  AD_ORG
juanpablo@797
   543
  AD_ORGINFO
juanpablo@797
   544
  AD_PREFERENCE
juanpablo@797
   545
  AD_PROCESS
juanpablo@797
   546
  AD_PROCESS_PARA
juanpablo@797
   547
  AD_REFERENCE
juanpablo@797
   548
  AD_REF_LIST
juanpablo@797
   549
  AD_REF_TABLE
juanpablo@797
   550
  AD_ROLE
juanpablo@797
   551
  AD_ROLE_ORGACCESS
juanpablo@797
   552
  AD_TAB
juanpablo@797
   553
  AD_TABLE
juanpablo@797
   554
  AD_TASK
juanpablo@797
   555
  AD_TREE
juanpablo@797
   556
  AD_TREENODE
juanpablo@797
   557
  AD_TREENODEBP
juanpablo@797
   558
  AD_TREENODEPR
juanpablo@797
   559
  AD_USER
juanpablo@797
   560
  AD_USER_ROLES
juanpablo@797
   561
  AD_VAL_RULE
juanpablo@797
   562
  AD_WF_NODE
juanpablo@797
   563
  AD_WF_NODENEXT
juanpablo@797
   564
  AD_WINDOW
juanpablo@797
   565
  AD_WORKFLOW
juanpablo@797
   566
juanpablo@797
   567
These tables also contain additional records that have been autonomously 
juanpablo@797
   568
defined by Openbravo. The  records derived by Compiere can be identified by
juanpablo@797
   569
their ID range:
juanpablo@797
   570
        - Records identified by an ID lower than 100000 are based upon
juanpablo@797
   571
          Compiere
juanpablo@797
   572
        - Records identified by an ID higher or equal to 100000 have been 
juanpablo@797
   573
          added by Openbravo
juanpablo@797
   574
The content of these tables is currently distributed by Openbravo using XML
juanpablo@797
   575
files stored in the /src-db/database folder and named after the tables
juanpablo@797
   576
themselves.
juanpablo@2071
   577