legal/CompiereAddendum.txt
author RM packaging bot <staff.rm@openbravo.com>
Tue, 29 May 2012 17:31:09 +0000
changeset 16679 2152016488dc
parent 13066 97a962abd3bb
child 25221 9787b99f5b18
permissions -rw-r--r--
Merge temporary head for 3.0MP10.3
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@13066
    29
  src/org/openbravo/erpCommon/ad_forms        DocLineInOut_data.xsql        server/src/org/compiere/acct    DocLine.java
juanpablo@797
    30
  src/org/openbravo/erpCommon/ad_forms        DocInOut.java                 server/src/org/compiere/acct    Doc_InOut.java
juanpablo@797
    31
  src/org/openbravo/erpCommon/ad_forms        DocInOut_data.xsql            server/src/org/compiere/acct    Doc_InOut.java
juanpablo@797
    32
  src/org/openbravo/erpCommon/ad_forms        DocInventory.java             server/src/org/compiere/acct    Doc_Inventory.java
juanpablo@797
    33
  src/org/openbravo/erpCommon/ad_forms        DocInventory_data.xsql        server/src/org/compiere/acct    Doc_Inventory.java
juanpablo@797
    34
  src/org/openbravo/erpCommon/ad_forms        DocInvoice.java               server/src/org/compiere/acct    Doc_Invoice.java
juanpablo@797
    35
  src/org/openbravo/erpCommon/ad_forms        DocInvoice_data.xsql          server/src/org/compiere/acct    Doc_Invoice.java
juanpablo@797
    36
  src/org/openbravo/erpCommon/ad_forms        DocLine.java                  server/src/org/compiere/acct    DocLine.java
juanpablo@797
    37
  src/org/openbravo/erpCommon/ad_forms        DocLineBank_data.xsql         server/src/org/compiere/acct    DocLine_Bank.java
juanpablo@797
    38
  src/org/openbravo/erpCommon/ad_forms        DocLineCash_data.xsql         server/src/org/compiere/acct    DocLine_Cash.java
juanpablo@797
    39
  src/org/openbravo/erpCommon/ad_forms        DocLineGLJournal_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@13066
    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        DocLineMovement_data.xsql     server/src/org/compiere/acct    DocLine.java
juanpablo@13066
    43
  src/org/openbravo/erpCommon/ad_forms        DocLineOrder_data.xsql        server/src/org/compiere/acct    DocLine.java
juanpablo@797
    44
  src/org/openbravo/erpCommon/ad_forms        DocLine_Bank.java             server/src/org/compiere/acct    DocLine_Bank.java
juanpablo@797
    45
  src/org/openbravo/erpCommon/ad_forms        DocLine_Cash.java             server/src/org/compiere/acct    DocLine_Cash.java
juanpablo@797
    46
  src/org/openbravo/erpCommon/ad_forms        DocLine_data.xsql             server/src/org/compiere/acct    DocLine.java
juanpablo@797
    47
  src/org/openbravo/erpCommon/ad_forms        DocLine_Invoice.java          server/src/org/compiere/acct    DocLine_Invoice.java
juanpablo@797
    48
  src/org/openbravo/erpCommon/ad_forms        DocLine_Material.java         server/src/org/compiere/acct    DocLine_Material.java
juanpablo@797
    49
  src/org/openbravo/erpCommon/ad_forms        DocMovement.java              server/src/org/compiere/acct    Doc_Movement.java
juanpablo@797
    50
  src/org/openbravo/erpCommon/ad_forms        DocMovement_data.xsql         server/src/org/compiere/acct    Doc_Movement.java
juanpablo@797
    51
  src/org/openbravo/erpCommon/ad_forms        DocOrder.java                 server/src/org/compiere/acct    Doc_Order.java
juanpablo@797
    52
  src/org/openbravo/erpCommon/ad_forms        DocOrder_data.xsql            server/src/org/compiere/acct    Doc_Order.java
juanpablo@797
    53
  src/org/openbravo/erpCommon/ad_forms        DocTax.java                   server/src/org/compiere/acct    DocTax.java
juanpablo@797
    54
  src/org/openbravo/erpCommon/ad_forms        DocTax_data.xsql              server/src/org/compiere/acct    DocTax.java
juanpablo@797
    55
  src/org/openbravo/erpCommon/ad_forms        Fact.java                     server/src/org/compiere/acct    Fact.java
juanpablo@797
    56
  src/org/openbravo/erpCommon/ad_forms        FactLine.java                 server/src/org/compiere/acct    FactLine.java
juanpablo@797
    57
  src/org/openbravo/erpCommon/ad_forms        FactLine_data.xsql            server/src/org/compiere/acct    FactLine.java
juanpablo@797
    58
  src/org/openbravo/erpCommon/ad_forms        ProductInfo.java              server/src/org/compiere/acct    ProductInfo.java
juanpablo@797
    59
  src/org/openbravo/erpCommon/ad_forms        ProductInfo_data.xsql         server/src/org/compiere/acct    ProductInfo.java
juanpablo@797
    60
  src/org/openbravo/erpCommon/ad_forms        Translation.java              client/Src/org/compiere/install Translation.java
juanpablo@797
    61
  src/org/openbravo/erpCommon/ad_forms        TranslationHandler.java       client/Src/org/compiere/install TranslationHandler.java
juanpablo@797
    62
  src/org/openbravo/erpCommon/businessUtility AccountTree.java              base/src/org/compiere/model     Account.java
juanpablo@797
    63
  src/org/openbravo/erpCommon/businessUtility AccountTree_data.xsql         base/src/org/compiere/model     Account.java
juanpablo@13066
    64
  src/org/openbravo/erpCommon/businessUtility ByteArrayDataSource.java      base/src/org/compiere/util      ByteArrayDataSource.java
juanpablo@13066
    65
  src/org/openbravo/erpCommon/businessUtility EMail.java                    base/src/org/compiere/util      EMail.java
juanpablo@797
    66
  src/org/openbravo/erpCommon/businessUtility EMailAuthenticator.java       base/src/org/compiere/util      EMailAuthenticator.java
juanpablo@797
    67
juanpablo@797
    68
PL/SQL Code
juanpablo@797
    69
-----------
juanpablo@797
    70
The following PL/SQL functions, procedures and triggers were originally
juanpablo@797
    71
developed by Compiere Inc. and distributed in Compiere ERP & CRM v.2.5.0c. 
juanpablo@797
    72
Openbravo has modified them in order to satisfy its own functional and
juanpablo@2071
    73
technical requirements. Whenever the name was change, the PL/SQL object is 
juanpablo@2071
    74
listed with its new name and the original Compiere name is reported in brackets.
juanpablo@797
    75
This PL/SQL code is currently distributed by Openbravo using XML files stored
juanpablo@797
    76
in the /src-db/database folder and named after the database objects
juanpablo@797
    77
themselves. Each file properly identifies Compiere Inc. as the original 
juanpablo@797
    78
developer using comments.
juanpablo@797
    79
  Type          Name
juanpablo@797
    80
  ----          ----
juanpablo@797
    81
  FUNCTION      AD_SEQUENCE_NEXTNO
juanpablo@2071
    82
  FUNCTION      M_BOM_PRICELIMIT (original name: BOM_PRICELIMIT)
juanpablo@2071
    83
  FUNCTION      M_BOM_PRICELIST (original name: BOM_PRICELIST)
juanpablo@2071
    84
  FUNCTION      M_BOM_PRICESTD (original name: BOM_PRICESTD)
juanpablo@2071
    85
  FUNCTION      M_BOM_QTY_AVAILABLE (original name: BOM_QTY_AVAILABLE)
juanpablo@2071
    86
  FUNCTION      M_BOM_QTY_ONHAND (original name: BOM_QTY_ONHAND)
juanpablo@2071
    87
  FUNCTION      M_BOM_QTY_ORDERED (original name: BOM_QTY_ORDERED)
juanpablo@2071
    88
  FUNCTION      M_BOM_QTY_RESERVED (original name: BOM_QTY_RESERVED)
juanpablo@797
    89
  FUNCTION      C_BASE_CONVERT
juanpablo@797
    90
  FUNCTION      C_CURRENCY_CONVERT
juanpablo@797
    91
  FUNCTION      C_CURRENCY_CONVERT0
juanpablo@797
    92
  FUNCTION      C_CURRENCY_RATE
juanpablo@797
    93
  FUNCTION      C_CURRENCY_ROUND
juanpablo@797
    94
  FUNCTION      C_UOM_CONVERT
juanpablo@797
    95
  PROCEDURE     A_ASSET_CREATE
juanpablo@797
    96
  PROCEDURE     AD_LANGUAGE_CREATE
juanpablo@797
    97
  PROCEDURE     AD_SEQUENCE_DOC
juanpablo@797
    98
  PROCEDURE     AD_SEQUENCE_DOCTYPE
juanpablo@797
    99
  PROCEDURE     AD_SEQUENCE_NEXT
juanpablo@797
   100
  PROCEDURE     AD_SYNCHRONIZE
juanpablo@797
   101
  PROCEDURE     AD_TAB_COPY
juanpablo@797
   102
  PROCEDURE     AD_TAB_IMPORT
juanpablo@797
   103
  PROCEDURE     AD_TAB_IMPORT0
juanpablo@797
   104
  PROCEDURE     AD_TABLE_IMPORT
juanpablo@797
   105
  PROCEDURE     AD_TABLE_IMPORT0
juanpablo@797
   106
  PROCEDURE     AD_WINDOW_COPY
juanpablo@797
   107
  PROCEDURE     C_ACCTSCHEMA_DEFAULT_COPY
juanpablo@797
   108
  PROCEDURE     C_BANKSTATEMENT_POST
juanpablo@797
   109
  PROCEDURE     C_BP_GROUP_ACCT_COPY
juanpablo@797
   110
  PROCEDURE     C_CASH_POST
juanpablo@797
   111
  PROCEDURE     C_COMMISSION_COPY
juanpablo@797
   112
  PROCEDURE     C_COMMISSION_PROCESS
juanpablo@797
   113
  PROCEDURE     C_COMMISSIONRUN_PROCESS
juanpablo@797
   114
  PROCEDURE     C_INVOICE_CANCEL
juanpablo@797
   115
  PROCEDURE     C_INVOICE_CREATE
juanpablo@797
   116
  PROCEDURE     C_INVOICE_CREATERECEIPT
juanpablo@797
   117
  PROCEDURE     C_INVOICE_CREATE0
juanpablo@797
   118
  PROCEDURE     C_INVOICE_POST
juanpablo@797
   119
  PROCEDURE     C_INVOICE_POST0
juanpablo@797
   120
  PROCEDURE     C_ORDER_PO_CREATE
juanpablo@797
   121
  PROCEDURE     C_ORDER_POST
juanpablo@797
   122
  PROCEDURE     C_PERIODCONTROL_PROCESS
juanpablo@797
   123
  PROCEDURE     C_PERIOD_PROCESS
juanpablo@797
   124
  PROCEDURE     C_PROJECT_GENERATE
juanpablo@797
   125
  PROCEDURE     C_VALIDCOMBINATION_GET
juanpablo@797
   126
  PROCEDURE     C_YEARPERIODS
juanpablo@797
   127
  PROCEDURE     FACT_ACCT_RESET
juanpablo@797
   128
  PROCEDURE     GL_JOURNALBATCH_POST
juanpablo@797
   129
  PROCEDURE     GL_JOURNAL_POST
juanpablo@797
   130
  PROCEDURE     GL_JOURNAL_POST0
juanpablo@797
   131
  PROCEDURE     M_DISCOUNTSCHEMA_RESEQ
juanpablo@797
   132
  PROCEDURE     M_INOUT_CANCEL
juanpablo@797
   133
  PROCEDURE     M_INOUT_CREATE
juanpablo@797
   134
  PROCEDURE     M_INOUT_CREATEINVOICE
juanpablo@797
   135
  PROCEDURE     M_INOUT_CREATE0
juanpablo@797
   136
  PROCEDURE     M_INOUT_POST
juanpablo@797
   137
  PROCEDURE     M_INOUT_POST0
juanpablo@797
   138
  PROCEDURE     M_INVENTORY_LISTCREATE
juanpablo@797
   139
  PROCEDURE     M_INVENTORY_LISTUPDATE
juanpablo@797
   140
  PROCEDURE     M_INVENTORY_POST
juanpablo@797
   141
  PROCEDURE     M_MOVEMENT_POST
juanpablo@797
   142
  PROCEDURE     M_PRICELIST_CREATE
juanpablo@797
   143
  PROCEDURE     M_PRODUCT_BOM_CHECK
juanpablo@797
   144
  PROCEDURE     M_PRODUCT_CATEGORY_ACCT_COPY
juanpablo@797
   145
  PROCEDURE     M_PRODUCTION_RUN
juanpablo@797
   146
  PROCEDURE     S_TIMEEXPENSE_POST
juanpablo@797
   147
  TRIGGER       AD_CLIENT_TRG
juanpablo@797
   148
  TRIGGER       AD_COLUMN_TRG
juanpablo@797
   149
  TRIGGER       AD_ELEMENT_TRG
juanpablo@797
   150
  TRIGGER       AD_ELEMENT_TRL_TRG
juanpablo@797
   151
  TRIGGER       AD_FIELDGROUP_TRG
juanpablo@797
   152
  TRIGGER       AD_FIELD_TRG
juanpablo@797
   153
  TRIGGER       AD_FORM_TRG
juanpablo@797
   154
  TRIGGER       AD_MENU_TRG
juanpablo@797
   155
  TRIGGER       AD_MESSAGE_TRG
juanpablo@797
   156
  TRIGGER       AD_ORG_TRG
juanpablo@797
   157
  TRIGGER       AD_PROCESS_PARA_TRG
juanpablo@797
   158
  TRIGGER       AD_PROCESS_TRG
juanpablo@797
   159
  TRIGGER       AD_PROCESS_TRL_TRG
juanpablo@797
   160
  TRIGGER       AD_REFERENCE_TRG
juanpablo@797
   161
  TRIGGER       AD_REF_LIST_TRG
juanpablo@797
   162
  TRIGGER       AD_ROLE_ORGACCESS_TRG
juanpablo@797
   163
  TRIGGER       AD_ROLE_TRG
juanpablo@797
   164
  TRIGGER       AD_TABLE_TRG
juanpablo@797
   165
  TRIGGER       AD_TAB_TRG
juanpablo@797
   166
  TRIGGER       AD_TREE_TRG
juanpablo@797
   167
  TRIGGER       AD_WINDOW_TRG
juanpablo@797
   168
  TRIGGER       AD_WINDOW_TRL_TRG
juanpablo@797
   169
  TRIGGER       C_ACCTSCHEMA_ELEMENT_TRG
juanpablo@797
   170
  TRIGGER       C_BANKACCOUNT_TRG
juanpablo@797
   171
  TRIGGER       C_BANKSTATEMENTLINE_TRG
juanpablo@797
   172
  TRIGGER       C_BANKSTATEMENT_TRG
juanpablo@797
   173
  TRIGGER       C_BPARTNER_LOCATION_TRG
juanpablo@797
   174
  TRIGGER       C_BPARTNER_TRG
juanpablo@797
   175
  TRIGGER       C_BP_GROUP_TRG
juanpablo@797
   176
  TRIGGER       C_CASHBOOK_TRG
juanpablo@797
   177
  TRIGGER       C_CASHLINE_TRG
juanpablo@797
   178
  TRIGGER       C_CASH_TRG
juanpablo@797
   179
  TRIGGER       C_CHARGE_TRG
juanpablo@797
   180
  TRIGGER       C_COMMISSIONAMT_TRG
juanpablo@797
   181
  TRIGGER       C_COMMISSIONDETAIL_TRG
juanpablo@797
   182
  TRIGGER       C_CONVERSION_RATE_TRG
juanpablo@797
   183
  TRIGGER       C_DOCTYPE_TRG
juanpablo@797
   184
  TRIGGER       C_ELEMENTVALUE_TRG
juanpablo@797
   185
  TRIGGER       C_GREETING_TRG
juanpablo@797
   186
  TRIGGER       C_INVOICELINE_TRG
juanpablo@797
   187
  TRIGGER       C_INVOICETAX_TRG
juanpablo@797
   188
  TRIGGER       C_ORDERLINE_TRG
juanpablo@797
   189
  TRIGGER       C_ORDERTAX_TRG
juanpablo@797
   190
  TRIGGER       C_ORDER_TRG
juanpablo@797
   191
  TRIGGER       C_PAYMENTTERM_TRG
juanpablo@797
   192
  TRIGGER       C_PERIOD_TRG
juanpablo@797
   193
  TRIGGER       C_PERIOD_TRG2
juanpablo@797
   194
  TRIGGER       C_PROJECTLINE_TRG
juanpablo@13066
   195
  TRIGGER       C_PROJECTLINE_TRG3
juanpablo@797
   196
  TRIGGER       C_PROJECT_TRG
juanpablo@797
   197
  TRIGGER       C_SALESREGION_TRG
juanpablo@797
   198
  TRIGGER       C_TAXCATEGORY_TRG
juanpablo@797
   199
  TRIGGER       C_TAX_TRG
juanpablo@797
   200
  TRIGGER       C_UOM_TRG
juanpablo@797
   201
  TRIGGER       C_VALIDCOMBINATION_TRG
juanpablo@797
   202
  TRIGGER       C_WITHHOLDING_TRG
juanpablo@797
   203
  TRIGGER       GL_JOURNALLINE_TRG
juanpablo@797
   204
  TRIGGER       GL_JOURNAL_TRG
juanpablo@797
   205
  TRIGGER       M_INOUTLINE_TRG
juanpablo@797
   206
  TRIGGER       M_INVENTORYLINE_TRG
juanpablo@797
   207
  TRIGGER       M_MATCHPO_TRG
juanpablo@797
   208
  TRIGGER       M_MOVEMENTLINE_TRG
juanpablo@797
   209
  TRIGGER       M_PRODUCT_BOM_TRG
juanpablo@797
   210
  TRIGGER       M_PRODUCT_CATEGORY_TRG
juanpablo@797
   211
  TRIGGER       M_PRODUCTIONLINE_TRG
juanpablo@797
   212
  TRIGGER       M_PRODUCTIONPLAN_TRG
juanpablo@797
   213
  TRIGGER       M_PRODUCT_TRG
juanpablo@797
   214
  TRIGGER       M_WAREHOUSE_TRG
juanpablo@797
   215
  TRIGGER       S_EXPENSETYPE_TRG
juanpablo@797
   216
  TRIGGER       S_RESOURCEASSIGNMENT_TRG
juanpablo@797
   217
  TRIGGER       S_RESOURCE_TRG
juanpablo@797
   218
  TRIGGER       S_RESOURCETYPE_TRG
juanpablo@797
   219
  TRIGGER       S_RESOURCEUNAVAILABLE_TRG
juanpablo@797
   220
juanpablo@797
   221
juanpablo@797
   222
Database Tables
juanpablo@797
   223
---------------
juanpablo@797
   224
The following database tables and views were originally designed by Compiere
juanpablo@797
   225
Inc. and distributed in Compiere ERP & CRM v.2.5.0c.
juanpablo@797
   226
Openbravo modified them in order to satisfy its own functional and technical
juanpablo@2071
   227
requirements. Whenever the name was change, the table is listed with its new
juanpablo@2071
   228
name and the original Compiere name is reported in brackets:
juanpablo@797
   229
juanpablo@2071
   230
  A_ASSET
juanpablo@2071
   231
  A_ASSET_GROUP
juanpablo@2071
   232
  AD_ALERT
juanpablo@2071
   233
  AD_ALERTRECIPIENT
juanpablo@2071
   234
  AD_ALERTRULE
juanpablo@2071
   235
  AD_CLIENT
juanpablo@2071
   236
  AD_CLIENTINFO
juanpablo@2071
   237
  AD_COLUMN
juanpablo@2071
   238
  AD_ELEMENT
juanpablo@2071
   239
  AD_ELEMENT_TRL
juanpablo@2071
   240
  AD_FIELD
juanpablo@2071
   241
  AD_FIELD_TRL
juanpablo@2071
   242
  AD_FIELDGROUP
juanpablo@2071
   243
  AD_FIELDGROUP_TRL
juanpablo@2071
   244
  AD_FORM
juanpablo@2071
   245
  AD_FORM_ACCESS
juanpablo@2071
   246
  AD_FORM_TRL
juanpablo@2071
   247
  AD_IMAGE
juanpablo@2071
   248
  AD_LANGUAGE
juanpablo@2071
   249
  AD_MENU
juanpablo@2071
   250
  AD_MENU_TRL
juanpablo@2071
   251
  AD_MESSAGE
juanpablo@2071
   252
  AD_MESSAGE_TRL
juanpablo@2071
   253
  AD_ORG
juanpablo@2071
   254
  AD_ORGINFO
juanpablo@2071
   255
  AD_PINSTANCE
juanpablo@2071
   256
  AD_PINSTANCE_PARA
juanpablo@2071
   257
  AD_PREFERENCE
juanpablo@2071
   258
  AD_PROCESS
juanpablo@2071
   259
  AD_PROCESS_ACCESS
juanpablo@2071
   260
  AD_PROCESS_PARA
juanpablo@2071
   261
  AD_PROCESS_PARA_TRL
juanpablo@2071
   262
  AD_PROCESS_TRL
juanpablo@2071
   263
  AD_REF_LIST
juanpablo@2071
   264
  AD_REF_LIST_TRL
juanpablo@2071
   265
  AD_REF_TABLE
juanpablo@2071
   266
  AD_REFERENCE
juanpablo@2071
   267
  AD_REFERENCE_TRL
juanpablo@2071
   268
  AD_ROLE
juanpablo@2071
   269
  AD_ROLE_ORGACCESS
juanpablo@2071
   270
  AD_SEQUENCE
juanpablo@2071
   271
  AD_SESSION
juanpablo@2071
   272
  AD_SYSTEM
juanpablo@2071
   273
  AD_TAB
juanpablo@2071
   274
  AD_TAB_TRL
juanpablo@797
   275
  AD_TABLE
juanpablo@2071
   276
  AD_TABLE_ACCESS
juanpablo@2071
   277
  AD_TREE
juanpablo@2071
   278
  AD_TREENODE
juanpablo@2071
   279
  AD_USER
juanpablo@2071
   280
  AD_USER_ROLES
juanpablo@797
   281
  AD_VAL_RULE
juanpablo@2071
   282
  AD_WINDOW
juanpablo@2071
   283
  AD_WINDOW_ACCESS
juanpablo@797
   284
  AD_WINDOW_TRL
juanpablo@2071
   285
  C_ACCTSCHEMA
juanpablo@2071
   286
  C_ACCTSCHEMA_DEFAULT
juanpablo@2071
   287
  C_ACCTSCHEMA_ELEMENT
juanpablo@2071
   288
  C_ACCTSCHEMA_GL
juanpablo@2071
   289
  C_ACTIVITY
juanpablo@2071
   290
  C_BANK
juanpablo@2071
   291
  C_BANKACCOUNT
juanpablo@2071
   292
  C_BANKACCOUNT_ACCT
juanpablo@2071
   293
  C_BANKSTATEMENT
juanpablo@2071
   294
  C_BANKSTATEMENTLINE
juanpablo@2071
   295
  C_BP_BANKACCOUNT
juanpablo@2071
   296
  C_BP_CUSTOMER_ACCT
juanpablo@2071
   297
  C_BP_EMPLOYEE_ACCT
juanpablo@2071
   298
  C_BP_GROUP
juanpablo@2071
   299
  C_BP_GROUP_ACCT
juanpablo@2071
   300
  C_BP_VENDOR_ACCT
juanpablo@2071
   301
  C_BP_WITHHOLDING
juanpablo@2071
   302
  C_BPARTNER
juanpablo@2071
   303
  C_BPARTNER_LOCATION
juanpablo@797
   304
  C_CALENDAR
juanpablo@2071
   305
  C_CAMPAIGN
juanpablo@2071
   306
  C_CASH
juanpablo@2071
   307
  C_CASHBOOK
juanpablo@2071
   308
  C_CASHBOOK_ACCT
juanpablo@2071
   309
  C_CASHLINE
juanpablo@2071
   310
  C_CHANNEL
juanpablo@2071
   311
  C_CHARGE
juanpablo@2071
   312
  C_CHARGE_ACCT
juanpablo@13066
   313
  C_INVOICE_V2 (original name: RV_C_INVOICE)
juanpablo@2071
   314
  C_INVOICELINE (original name: RV_C_INVOICELINE)
juanpablo@2071
   315
  C_CITY
juanpablo@2071
   316
  C_COMMISSION
juanpablo@2071
   317
  C_COMMISSIONAMT
juanpablo@2071
   318
  C_COMMISSIONDETAIL
juanpablo@2071
   319
  C_COMMISSIONLINE
juanpablo@2071
   320
  C_COMMISSIONRUN
juanpablo@797
   321
  C_CONVERSION_RATE
juanpablo@2071
   322
  C_COUNTRY
juanpablo@2071
   323
  C_COUNTRY_TRL
juanpablo@797
   324
  C_CURRENCY
juanpablo@2071
   325
  C_CURRENCY_TRL
juanpablo@13066
   326
  C_DEBT_PAYMENT_V
juanpablo@2071
   327
  C_DOCTYPE
juanpablo@2071
   328
  C_DOCTYPE_TRL
juanpablo@797
   329
  C_ELEMENT
juanpablo@2071
   330
  C_ELEMENTVALUE
juanpablo@2071
   331
  C_ELEMENTVALUE_TRL
juanpablo@2071
   332
  C_GREETING
juanpablo@2071
   333
  C_GREETING_TRL
juanpablo@2071
   334
  C_INVOICE
juanpablo@2071
   335
  C_INVOICELINE
juanpablo@2071
   336
  C_INVOICESCHEDULE
juanpablo@2071
   337
  C_INVOICETAX
juanpablo@797
   338
  C_LOCATION
juanpablo@797
   339
  C_NONBUSINESSDAY
juanpablo@2071
   340
  C_ORDER
juanpablo@2071
   341
  C_ORDERLINE
juanpablo@2071
   342
  C_ORDERTAX
juanpablo@2071
   343
  C_PAYMENTTERM
juanpablo@2071
   344
  C_PAYMENTTERM_TRL
juanpablo@2071
   345
  C_PERIOD
juanpablo@2071
   346
  C_PERIODCONTROL
juanpablo@2071
   347
  C_PHASE
juanpablo@797
   348
  C_PROJECT
juanpablo@797
   349
  C_PROJECT_ACCT
juanpablo@2071
   350
  C_PROJECTLINE
juanpablo@2071
   351
  C_PROJECTPHASE
juanpablo@2071
   352
  C_PROJECTTASK
juanpablo@2071
   353
  C_PROJECTTYPE
juanpablo@2071
   354
  C_REGION
juanpablo@2071
   355
  C_SALESREGION
juanpablo@2071
   356
  C_TASK
juanpablo@2071
   357
  C_TAX
juanpablo@2071
   358
  C_TAX_ACCT
juanpablo@2071
   359
  C_TAX_TRL
juanpablo@2071
   360
  C_TAXCATEGORY
juanpablo@2071
   361
  C_TAXCATEGORY_TRL
juanpablo@2071
   362
  C_UOM
juanpablo@2071
   363
  C_UOM_CONVERSION
juanpablo@2071
   364
  C_UOM_TRL
juanpablo@2071
   365
  C_VALIDCOMBINATION
juanpablo@2071
   366
  C_WITHHOLDING
juanpablo@2071
   367
  C_WITHHOLDING_ACCT
juanpablo@2071
   368
  C_YEAR
juanpablo@2071
   369
  FACT_ACCT
juanpablo@797
   370
  GL_CATEGORY
juanpablo@797
   371
  GL_JOURNAL
juanpablo@797
   372
  GL_JOURNALBATCH
juanpablo@797
   373
  GL_JOURNALLINE
juanpablo@2071
   374
  M_ATTRIBUTE
juanpablo@2071
   375
  M_ATTRIBUTEINSTANCE
juanpablo@2071
   376
  M_ATTRIBUTESET
juanpablo@2071
   377
  M_ATTRIBUTESETINSTANCE
juanpablo@2071
   378
  M_ATTRIBUTEUSE
juanpablo@2071
   379
  M_ATTRIBUTEVALUE
juanpablo@2071
   380
  M_DISCOUNTSCHEMA
juanpablo@2071
   381
  M_DISCOUNTSCHEMALINE
juanpablo@2071
   382
  M_FREIGHT
juanpablo@2071
   383
  M_FREIGHTCATEGORY
juanpablo@797
   384
  M_INOUT
juanpablo@797
   385
  M_INOUTLINE
juanpablo@797
   386
  M_INVENTORY
juanpablo@797
   387
  M_INVENTORYLINE
juanpablo@2071
   388
  M_LOCATOR
juanpablo@2071
   389
  M_LOT
juanpablo@2071
   390
  M_LOTCTL
juanpablo@2071
   391
  M_MATCHINV
juanpablo@2071
   392
  M_MATCHPO
juanpablo@797
   393
  M_MOVEMENT
juanpablo@797
   394
  M_MOVEMENTLINE
juanpablo@2071
   395
  M_PRICELIST
juanpablo@2071
   396
  M_PRICELIST_VERSION
juanpablo@2071
   397
  M_PRODUCT
juanpablo@2071
   398
  M_PRODUCT_ACCT
juanpablo@2071
   399
  M_PRODUCT_BOM
juanpablo@2071
   400
  M_PRODUCT_CATEGORY
juanpablo@2071
   401
  M_PRODUCT_CATEGORY_ACCT
juanpablo@2071
   402
  M_PRODUCT_PO
juanpablo@2071
   403
  M_PRODUCT_TRL
juanpablo@797
   404
  M_PRODUCTION
juanpablo@797
   405
  M_PRODUCTIONLINE
juanpablo@2071
   406
  M_PRODUCTIONPLAN
juanpablo@2071
   407
  M_PRODUCTPRICE
juanpablo@2071
   408
  M_SERNOCTL
juanpablo@2071
   409
  M_SHIPPER
juanpablo@2071
   410
  M_SUBSTITUTE
juanpablo@797
   411
  M_TRANSACTION
juanpablo@13066
   412
  M_TRANSACTION_V (original name: RV_M_TRANSACTION)
juanpablo@2071
   413
  M_WAREHOUSE
juanpablo@2071
   414
  M_WAREHOUSE_ACCT
juanpablo@2071
   415
  S_EXPENSETYPE
juanpablo@2071
   416
  S_RESOURCE
juanpablo@2071
   417
  S_RESOURCEASSIGNMENT
juanpablo@797
   418
  S_RESOURCETYPE
juanpablo@797
   419
  S_RESOURCEUNAVAILABLE
juanpablo@797
   420
  S_TIMEEXPENSE
juanpablo@797
   421
  S_TIMEEXPENSELINE
juanpablo@797
   422
  S_TIMETYPE
juanpablo@797
   423
juanpablo@797
   424
These tables and views are currently distributed by Openbravo using XML files
juanpablo@797
   425
stored in the /src-db/database folder and named after the tables themselves.
juanpablo@797
   426
juanpablo@797
   427
Database Records
juanpablo@797
   428
----------------
juanpablo@797
   429
The following database tables contain records that have been originally 
juanpablo@797
   430
defined by Compiere Inc. and distributed in Compiere ERP & CRM v.2.5.0c.
juanpablo@797
   431
Openbravo modified them in order to satisfy its own functional and
juanpablo@797
   432
technical requirements:
juanpablo@797
   433
juanpablo@797
   434
  AD_CLIENT
juanpablo@797
   435
  AD_CLIENTINFO
juanpablo@797
   436
  AD_COLUMN
juanpablo@797
   437
  AD_ELEMENT
juanpablo@797
   438
  AD_FIELD
juanpablo@797
   439
  AD_FIELDGROUP
juanpablo@797
   440
  AD_FORM
juanpablo@797
   441
  AD_LANGUAGE
juanpablo@797
   442
  AD_MENU
juanpablo@797
   443
  AD_MESSAGE
juanpablo@797
   444
  AD_ORG
juanpablo@797
   445
  AD_ORGINFO
juanpablo@797
   446
  AD_PREFERENCE
juanpablo@797
   447
  AD_PROCESS
juanpablo@797
   448
  AD_PROCESS_PARA
juanpablo@797
   449
  AD_REFERENCE
juanpablo@797
   450
  AD_REF_LIST
juanpablo@797
   451
  AD_REF_TABLE
juanpablo@797
   452
  AD_ROLE
juanpablo@797
   453
  AD_ROLE_ORGACCESS
juanpablo@797
   454
  AD_TAB
juanpablo@797
   455
  AD_TABLE
juanpablo@797
   456
  AD_TREE
juanpablo@797
   457
  AD_TREENODE
juanpablo@797
   458
  AD_USER
juanpablo@797
   459
  AD_USER_ROLES
juanpablo@797
   460
  AD_VAL_RULE
juanpablo@797
   461
  AD_WINDOW
juanpablo@797
   462
juanpablo@797
   463
These tables also contain additional records that have been autonomously 
juanpablo@797
   464
defined by Openbravo. The  records derived by Compiere can be identified by
juanpablo@797
   465
their ID range:
juanpablo@797
   466
        - Records identified by an ID lower than 100000 are based upon
juanpablo@797
   467
          Compiere
juanpablo@797
   468
        - Records identified by an ID higher or equal to 100000 have been 
juanpablo@797
   469
          added by Openbravo
juanpablo@797
   470
The content of these tables is currently distributed by Openbravo using XML
juanpablo@797
   471
files stored in the /src-db/database folder and named after the tables
juanpablo@797
   472
themselves.
juanpablo@2071
   473