legal/CompiereAddendum.txt
author Asier Lostalé <asier.lostale@openbravo.com>
Wed, 18 Mar 2015 10:50:25 +0100
changeset 26205 e7c1d9e51ba8
parent 25221 9787b99f5b18
child 37403 c87bc75ae00e
permissions -rw-r--r--
fixed bug 29329: can't download attachments for 2 rows with same name & no ext

When trying to download at once attachemnts for different records that have the
same name and it does not have extension, it fails.

The problem is in case of duplicated names to be included within the zipped file,
a number is appended to the file name before the extension. Extesion is present
is assumed, failing if not.

Fix: don't assume file name has extension.
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_RESOURCE_TRG
juanpablo@797
   217
  TRIGGER       S_RESOURCETYPE_TRG
juanpablo@797
   218
  TRIGGER       S_RESOURCEUNAVAILABLE_TRG
juanpablo@797
   219
juanpablo@797
   220
juanpablo@797
   221
Database Tables
juanpablo@797
   222
---------------
juanpablo@797
   223
The following database tables and views were originally designed by Compiere
juanpablo@797
   224
Inc. and distributed in Compiere ERP & CRM v.2.5.0c.
juanpablo@797
   225
Openbravo modified them in order to satisfy its own functional and technical
juanpablo@2071
   226
requirements. Whenever the name was change, the table is listed with its new
juanpablo@2071
   227
name and the original Compiere name is reported in brackets:
juanpablo@797
   228
juanpablo@2071
   229
  A_ASSET
juanpablo@2071
   230
  A_ASSET_GROUP
juanpablo@2071
   231
  AD_ALERT
juanpablo@2071
   232
  AD_ALERTRECIPIENT
juanpablo@2071
   233
  AD_ALERTRULE
juanpablo@2071
   234
  AD_CLIENT
juanpablo@2071
   235
  AD_CLIENTINFO
juanpablo@2071
   236
  AD_COLUMN
juanpablo@2071
   237
  AD_ELEMENT
juanpablo@2071
   238
  AD_ELEMENT_TRL
juanpablo@2071
   239
  AD_FIELD
juanpablo@2071
   240
  AD_FIELD_TRL
juanpablo@2071
   241
  AD_FIELDGROUP
juanpablo@2071
   242
  AD_FIELDGROUP_TRL
juanpablo@2071
   243
  AD_FORM
juanpablo@2071
   244
  AD_FORM_ACCESS
juanpablo@2071
   245
  AD_FORM_TRL
juanpablo@2071
   246
  AD_IMAGE
juanpablo@2071
   247
  AD_LANGUAGE
juanpablo@2071
   248
  AD_MENU
juanpablo@2071
   249
  AD_MENU_TRL
juanpablo@2071
   250
  AD_MESSAGE
juanpablo@2071
   251
  AD_MESSAGE_TRL
juanpablo@2071
   252
  AD_ORG
juanpablo@2071
   253
  AD_ORGINFO
juanpablo@2071
   254
  AD_PINSTANCE
juanpablo@2071
   255
  AD_PINSTANCE_PARA
juanpablo@2071
   256
  AD_PREFERENCE
juanpablo@2071
   257
  AD_PROCESS
juanpablo@2071
   258
  AD_PROCESS_ACCESS
juanpablo@2071
   259
  AD_PROCESS_PARA
juanpablo@2071
   260
  AD_PROCESS_PARA_TRL
juanpablo@2071
   261
  AD_PROCESS_TRL
juanpablo@2071
   262
  AD_REF_LIST
juanpablo@2071
   263
  AD_REF_LIST_TRL
juanpablo@2071
   264
  AD_REF_TABLE
juanpablo@2071
   265
  AD_REFERENCE
juanpablo@2071
   266
  AD_REFERENCE_TRL
juanpablo@2071
   267
  AD_ROLE
juanpablo@2071
   268
  AD_ROLE_ORGACCESS
juanpablo@2071
   269
  AD_SEQUENCE
juanpablo@2071
   270
  AD_SESSION
juanpablo@2071
   271
  AD_SYSTEM
juanpablo@2071
   272
  AD_TAB
juanpablo@2071
   273
  AD_TAB_TRL
juanpablo@797
   274
  AD_TABLE
juanpablo@2071
   275
  AD_TABLE_ACCESS
juanpablo@2071
   276
  AD_TREE
juanpablo@2071
   277
  AD_TREENODE
juanpablo@2071
   278
  AD_USER
juanpablo@2071
   279
  AD_USER_ROLES
juanpablo@797
   280
  AD_VAL_RULE
juanpablo@2071
   281
  AD_WINDOW
juanpablo@2071
   282
  AD_WINDOW_ACCESS
juanpablo@797
   283
  AD_WINDOW_TRL
juanpablo@2071
   284
  C_ACCTSCHEMA
juanpablo@2071
   285
  C_ACCTSCHEMA_DEFAULT
juanpablo@2071
   286
  C_ACCTSCHEMA_ELEMENT
juanpablo@2071
   287
  C_ACCTSCHEMA_GL
juanpablo@2071
   288
  C_ACTIVITY
juanpablo@2071
   289
  C_BANK
juanpablo@2071
   290
  C_BANKACCOUNT
juanpablo@2071
   291
  C_BANKACCOUNT_ACCT
juanpablo@2071
   292
  C_BANKSTATEMENT
juanpablo@2071
   293
  C_BANKSTATEMENTLINE
juanpablo@2071
   294
  C_BP_BANKACCOUNT
juanpablo@2071
   295
  C_BP_CUSTOMER_ACCT
juanpablo@2071
   296
  C_BP_EMPLOYEE_ACCT
juanpablo@2071
   297
  C_BP_GROUP
juanpablo@2071
   298
  C_BP_GROUP_ACCT
juanpablo@2071
   299
  C_BP_VENDOR_ACCT
juanpablo@2071
   300
  C_BP_WITHHOLDING
juanpablo@2071
   301
  C_BPARTNER
juanpablo@2071
   302
  C_BPARTNER_LOCATION
juanpablo@797
   303
  C_CALENDAR
juanpablo@2071
   304
  C_CAMPAIGN
juanpablo@2071
   305
  C_CASH
juanpablo@2071
   306
  C_CASHBOOK
juanpablo@2071
   307
  C_CASHBOOK_ACCT
juanpablo@2071
   308
  C_CASHLINE
juanpablo@2071
   309
  C_CHANNEL
juanpablo@2071
   310
  C_CHARGE
juanpablo@2071
   311
  C_CHARGE_ACCT
juanpablo@13066
   312
  C_INVOICE_V2 (original name: RV_C_INVOICE)
juanpablo@2071
   313
  C_INVOICELINE (original name: RV_C_INVOICELINE)
juanpablo@2071
   314
  C_CITY
juanpablo@2071
   315
  C_COMMISSION
juanpablo@2071
   316
  C_COMMISSIONAMT
juanpablo@2071
   317
  C_COMMISSIONDETAIL
juanpablo@2071
   318
  C_COMMISSIONLINE
juanpablo@2071
   319
  C_COMMISSIONRUN
juanpablo@797
   320
  C_CONVERSION_RATE
juanpablo@2071
   321
  C_COUNTRY
juanpablo@2071
   322
  C_COUNTRY_TRL
juanpablo@797
   323
  C_CURRENCY
juanpablo@2071
   324
  C_CURRENCY_TRL
juanpablo@13066
   325
  C_DEBT_PAYMENT_V
juanpablo@2071
   326
  C_DOCTYPE
juanpablo@2071
   327
  C_DOCTYPE_TRL
juanpablo@797
   328
  C_ELEMENT
juanpablo@2071
   329
  C_ELEMENTVALUE
juanpablo@2071
   330
  C_ELEMENTVALUE_TRL
juanpablo@2071
   331
  C_GREETING
juanpablo@2071
   332
  C_GREETING_TRL
juanpablo@2071
   333
  C_INVOICE
juanpablo@2071
   334
  C_INVOICELINE
juanpablo@2071
   335
  C_INVOICESCHEDULE
juanpablo@2071
   336
  C_INVOICETAX
juanpablo@797
   337
  C_LOCATION
juanpablo@797
   338
  C_NONBUSINESSDAY
juanpablo@2071
   339
  C_ORDER
juanpablo@2071
   340
  C_ORDERLINE
juanpablo@2071
   341
  C_ORDERTAX
juanpablo@2071
   342
  C_PAYMENTTERM
juanpablo@2071
   343
  C_PAYMENTTERM_TRL
juanpablo@2071
   344
  C_PERIOD
juanpablo@2071
   345
  C_PERIODCONTROL
juanpablo@2071
   346
  C_PHASE
juanpablo@797
   347
  C_PROJECT
juanpablo@797
   348
  C_PROJECT_ACCT
juanpablo@2071
   349
  C_PROJECTLINE
juanpablo@2071
   350
  C_PROJECTPHASE
juanpablo@2071
   351
  C_PROJECTTASK
juanpablo@2071
   352
  C_PROJECTTYPE
juanpablo@2071
   353
  C_REGION
juanpablo@2071
   354
  C_SALESREGION
juanpablo@2071
   355
  C_TASK
juanpablo@2071
   356
  C_TAX
juanpablo@2071
   357
  C_TAX_ACCT
juanpablo@2071
   358
  C_TAX_TRL
juanpablo@2071
   359
  C_TAXCATEGORY
juanpablo@2071
   360
  C_TAXCATEGORY_TRL
juanpablo@2071
   361
  C_UOM
juanpablo@2071
   362
  C_UOM_CONVERSION
juanpablo@2071
   363
  C_UOM_TRL
juanpablo@2071
   364
  C_VALIDCOMBINATION
juanpablo@2071
   365
  C_WITHHOLDING
juanpablo@2071
   366
  C_WITHHOLDING_ACCT
juanpablo@2071
   367
  C_YEAR
juanpablo@2071
   368
  FACT_ACCT
juanpablo@797
   369
  GL_CATEGORY
juanpablo@797
   370
  GL_JOURNAL
juanpablo@797
   371
  GL_JOURNALBATCH
juanpablo@797
   372
  GL_JOURNALLINE
juanpablo@2071
   373
  M_ATTRIBUTE
juanpablo@2071
   374
  M_ATTRIBUTEINSTANCE
juanpablo@2071
   375
  M_ATTRIBUTESET
juanpablo@2071
   376
  M_ATTRIBUTESETINSTANCE
juanpablo@2071
   377
  M_ATTRIBUTEUSE
juanpablo@2071
   378
  M_ATTRIBUTEVALUE
juanpablo@2071
   379
  M_DISCOUNTSCHEMA
juanpablo@2071
   380
  M_DISCOUNTSCHEMALINE
juanpablo@2071
   381
  M_FREIGHT
juanpablo@2071
   382
  M_FREIGHTCATEGORY
juanpablo@797
   383
  M_INOUT
juanpablo@797
   384
  M_INOUTLINE
juanpablo@797
   385
  M_INVENTORY
juanpablo@797
   386
  M_INVENTORYLINE
juanpablo@2071
   387
  M_LOCATOR
juanpablo@2071
   388
  M_LOT
juanpablo@2071
   389
  M_LOTCTL
juanpablo@2071
   390
  M_MATCHINV
juanpablo@2071
   391
  M_MATCHPO
juanpablo@797
   392
  M_MOVEMENT
juanpablo@797
   393
  M_MOVEMENTLINE
juanpablo@2071
   394
  M_PRICELIST
juanpablo@2071
   395
  M_PRICELIST_VERSION
juanpablo@2071
   396
  M_PRODUCT
juanpablo@2071
   397
  M_PRODUCT_ACCT
juanpablo@2071
   398
  M_PRODUCT_BOM
juanpablo@2071
   399
  M_PRODUCT_CATEGORY
juanpablo@2071
   400
  M_PRODUCT_CATEGORY_ACCT
juanpablo@2071
   401
  M_PRODUCT_PO
juanpablo@2071
   402
  M_PRODUCT_TRL
juanpablo@797
   403
  M_PRODUCTION
juanpablo@797
   404
  M_PRODUCTIONLINE
juanpablo@2071
   405
  M_PRODUCTIONPLAN
juanpablo@2071
   406
  M_PRODUCTPRICE
juanpablo@2071
   407
  M_SERNOCTL
juanpablo@2071
   408
  M_SHIPPER
juanpablo@2071
   409
  M_SUBSTITUTE
juanpablo@797
   410
  M_TRANSACTION
juanpablo@13066
   411
  M_TRANSACTION_V (original name: RV_M_TRANSACTION)
juanpablo@2071
   412
  M_WAREHOUSE
juanpablo@2071
   413
  M_WAREHOUSE_ACCT
juanpablo@2071
   414
  S_EXPENSETYPE
juanpablo@2071
   415
  S_RESOURCE
juanpablo@2071
   416
  S_RESOURCEASSIGNMENT
juanpablo@797
   417
  S_RESOURCETYPE
juanpablo@797
   418
  S_RESOURCEUNAVAILABLE
juanpablo@797
   419
  S_TIMEEXPENSE
juanpablo@797
   420
  S_TIMEEXPENSELINE
juanpablo@797
   421
  S_TIMETYPE
juanpablo@797
   422
juanpablo@797
   423
These tables and views are currently distributed by Openbravo using XML files
juanpablo@797
   424
stored in the /src-db/database folder and named after the tables themselves.
juanpablo@797
   425
juanpablo@797
   426
Database Records
juanpablo@797
   427
----------------
juanpablo@797
   428
The following database tables contain records that have been originally 
juanpablo@797
   429
defined by Compiere Inc. and distributed in Compiere ERP & CRM v.2.5.0c.
juanpablo@797
   430
Openbravo modified them in order to satisfy its own functional and
juanpablo@797
   431
technical requirements:
juanpablo@797
   432
juanpablo@797
   433
  AD_CLIENT
juanpablo@797
   434
  AD_CLIENTINFO
juanpablo@797
   435
  AD_COLUMN
juanpablo@797
   436
  AD_ELEMENT
juanpablo@797
   437
  AD_FIELD
juanpablo@797
   438
  AD_FIELDGROUP
juanpablo@797
   439
  AD_FORM
juanpablo@797
   440
  AD_LANGUAGE
juanpablo@797
   441
  AD_MENU
juanpablo@797
   442
  AD_MESSAGE
juanpablo@797
   443
  AD_ORG
juanpablo@797
   444
  AD_ORGINFO
juanpablo@797
   445
  AD_PREFERENCE
juanpablo@797
   446
  AD_PROCESS
juanpablo@797
   447
  AD_PROCESS_PARA
juanpablo@797
   448
  AD_REFERENCE
juanpablo@797
   449
  AD_REF_LIST
juanpablo@797
   450
  AD_REF_TABLE
juanpablo@797
   451
  AD_ROLE
juanpablo@797
   452
  AD_ROLE_ORGACCESS
juanpablo@797
   453
  AD_TAB
juanpablo@797
   454
  AD_TABLE
juanpablo@797
   455
  AD_TREE
juanpablo@797
   456
  AD_TREENODE
juanpablo@797
   457
  AD_USER
juanpablo@797
   458
  AD_USER_ROLES
juanpablo@797
   459
  AD_VAL_RULE
juanpablo@797
   460
  AD_WINDOW
juanpablo@797
   461
juanpablo@797
   462
These tables also contain additional records that have been autonomously 
juanpablo@797
   463
defined by Openbravo. The  records derived by Compiere can be identified by
juanpablo@797
   464
their ID range:
juanpablo@797
   465
        - Records identified by an ID lower than 100000 are based upon
juanpablo@797
   466
          Compiere
juanpablo@797
   467
        - Records identified by an ID higher or equal to 100000 have been 
juanpablo@797
   468
          added by Openbravo
juanpablo@797
   469
The content of these tables is currently distributed by Openbravo using XML
juanpablo@797
   470
files stored in the /src-db/database folder and named after the tables
juanpablo@797
   471
themselves.
juanpablo@2071
   472