1

This file contains a description of the usage of Compiere Inc. assets within

     2

Openbravo ERP and the changes that Openbravo implemented on those assets.

     3

     4

Java and XSQL Code

     5

------------------

     6

Some Java and XSQL files are inspired by Compiere ERP & CRM v.2.5.0c. In 

     7

particular, some of Openbravo Java classes use some Compiere files as model

     8

and replicate their business logic in a different implementation.

     9

The following list contains the name of the Openbravo files that have been

    10

developed in this manner and maps them to the Compiere files that have been

    11

used as model:

    12

    13

  Openbravo Path                              Openbravo File                Compiere Path                    Compiere file

    14

  --------------                              --------------                -------------                   -------------

    15

  src/org/openbravo/erpCommon/ad_forms        Account.java                  base/src/org/compiere/model     Account.java

    16

  src/org/openbravo/erpCommon/ad_forms        Account_data.xsql             base/src/org/compiere/model     Account.java

    17

  src/org/openbravo/erpCommon/ad_forms        AcctSchema.java               base/src/org/compiere/model     AcctSchema.java

    18

  src/org/openbravo/erpCommon/ad_forms        AcctSchema_data.xsql          base/src/org/compiere/model     AcctSchema.java

    19

  src/org/openbravo/erpCommon/ad_forms        AcctSchemaElement.java        base/src/org/compiere/model     AcctSchemaElement.java

    20

  src/org/openbravo/erpCommon/ad_forms        AcctSchemaElement_data.xsql   base/src/org/compiere/model     AcctSchemaElement.java

    21

  src/org/openbravo/erpCommon/ad_forms        AcctServer.java               server/src/org/compiere/acct    AcctServer.java + DocVO.java

    22

  src/org/openbravo/erpCommon/ad_forms        AcctServer_data.xsql          server/src/org/compiere/acct    AcctServer.java + DocVO.java

    23

  src/org/openbravo/erpCommon/ad_forms        DocBank.java                  server/src/org/compiere/acct    Doc_Bank.java

    24

  src/org/openbravo/erpCommon/ad_forms        DocBank_data.xsql             server/src/org/compiere/acct    Doc_Bank.java

    25

  src/org/openbravo/erpCommon/ad_forms        DocCash.java                  server/src/org/compiere/acct    Doc_Cash.java

    26

  src/org/openbravo/erpCommon/ad_forms        DocCash_data.xsql             server/src/org/compiere/acct    Doc_Cash.java

    27

  src/org/openbravo/erpCommon/ad_forms        DocGLJournal.java             server/src/org/compiere/acct    Doc_GLJournal.java

    28

  src/org/openbravo/erpCommon/ad_forms        DocGLJournal_data.xsql        server/src/org/compiere/acct    Doc_GLJournal.java

    29

  src/org/openbravo/erpCommon/ad_forms        DocLineInOut_data.xsql        server/src/org/compiere/acct    DocLine.java

    30

  src/org/openbravo/erpCommon/ad_forms        DocInOut.java                 server/src/org/compiere/acct    Doc_InOut.java

    31

  src/org/openbravo/erpCommon/ad_forms        DocInOut_data.xsql            server/src/org/compiere/acct    Doc_InOut.java

    32

  src/org/openbravo/erpCommon/ad_forms        DocInventory.java             server/src/org/compiere/acct    Doc_Inventory.java

    33

  src/org/openbravo/erpCommon/ad_forms        DocInventory_data.xsql        server/src/org/compiere/acct    Doc_Inventory.java

    34

  src/org/openbravo/erpCommon/ad_forms        DocInvoice.java               server/src/org/compiere/acct    Doc_Invoice.java

    35

  src/org/openbravo/erpCommon/ad_forms        DocInvoice_data.xsql          server/src/org/compiere/acct    Doc_Invoice.java

    36

  src/org/openbravo/erpCommon/ad_forms        DocLine.java                  server/src/org/compiere/acct    DocLine.java

    37

  src/org/openbravo/erpCommon/ad_forms        DocLineBank_data.xsql         server/src/org/compiere/acct    DocLine_Bank.java

    38

  src/org/openbravo/erpCommon/ad_forms        DocLineCash_data.xsql         server/src/org/compiere/acct    DocLine_Cash.java

    39

  src/org/openbravo/erpCommon/ad_forms        DocLineGLJournal_data.xsql    server/src/org/compiere/acct    DocLine.java

    40

  src/org/openbravo/erpCommon/ad_forms        DocLineInventory_data.xsql    server/src/org/compiere/acct    DocLine.java

    41

  src/org/openbravo/erpCommon/ad_forms        DocLineInvoice_data.xsql      server/src/org/compiere/acct    DocLine.java

    42

  src/org/openbravo/erpCommon/ad_forms        DocLineMovement_data.xsql     server/src/org/compiere/acct    DocLine.java

    43

  src/org/openbravo/erpCommon/ad_forms        DocLineOrder_data.xsql        server/src/org/compiere/acct    DocLine.java

    44

  src/org/openbravo/erpCommon/ad_forms        DocLine_Bank.java             server/src/org/compiere/acct    DocLine_Bank.java

    45

  src/org/openbravo/erpCommon/ad_forms        DocLine_Cash.java             server/src/org/compiere/acct    DocLine_Cash.java

    46

  src/org/openbravo/erpCommon/ad_forms        DocLine_data.xsql             server/src/org/compiere/acct    DocLine.java

    47

  src/org/openbravo/erpCommon/ad_forms        DocLine_Invoice.java          server/src/org/compiere/acct    DocLine_Invoice.java

    48

  src/org/openbravo/erpCommon/ad_forms        DocLine_Material.java         server/src/org/compiere/acct    DocLine_Material.java

    49

  src/org/openbravo/erpCommon/ad_forms        DocMovement.java              server/src/org/compiere/acct    Doc_Movement.java

    50

  src/org/openbravo/erpCommon/ad_forms        DocMovement_data.xsql         server/src/org/compiere/acct    Doc_Movement.java

    51

  src/org/openbravo/erpCommon/ad_forms        DocOrder.java                 server/src/org/compiere/acct    Doc_Order.java

    52

  src/org/openbravo/erpCommon/ad_forms        DocOrder_data.xsql            server/src/org/compiere/acct    Doc_Order.java

    53

  src/org/openbravo/erpCommon/ad_forms        DocTax.java                   server/src/org/compiere/acct    DocTax.java

    54

  src/org/openbravo/erpCommon/ad_forms        DocTax_data.xsql              server/src/org/compiere/acct    DocTax.java

    55

  src/org/openbravo/erpCommon/ad_forms        Fact.java                     server/src/org/compiere/acct    Fact.java

    56

  src/org/openbravo/erpCommon/ad_forms        FactLine.java                 server/src/org/compiere/acct    FactLine.java

    57

  src/org/openbravo/erpCommon/ad_forms        FactLine_data.xsql            server/src/org/compiere/acct    FactLine.java

    58

  src/org/openbravo/erpCommon/ad_forms        ProductInfo.java              server/src/org/compiere/acct    ProductInfo.java

    59

  src/org/openbravo/erpCommon/ad_forms        ProductInfo_data.xsql         server/src/org/compiere/acct    ProductInfo.java

    60

  src/org/openbravo/erpCommon/ad_forms        Translation.java              client/Src/org/compiere/install Translation.java

    61

  src/org/openbravo/erpCommon/ad_forms        TranslationHandler.java       client/Src/org/compiere/install TranslationHandler.java

    62

  src/org/openbravo/erpCommon/businessUtility AccountTree.java              base/src/org/compiere/model     Account.java

    63

  src/org/openbravo/erpCommon/businessUtility AccountTree_data.xsql         base/src/org/compiere/model     Account.java

    64

  src/org/openbravo/erpCommon/businessUtility ByteArrayDataSource.java      base/src/org/compiere/util      ByteArrayDataSource.java

    65

  src/org/openbravo/erpCommon/businessUtility EMail.java                    base/src/org/compiere/util      EMail.java

    66

  src/org/openbravo/erpCommon/businessUtility EMailAuthenticator.java       base/src/org/compiere/util      EMailAuthenticator.java

    67

    68

PL/SQL Code

    69

-----------

    70

The following PL/SQL functions, procedures and triggers were originally

    71

developed by Compiere Inc. and distributed in Compiere ERP & CRM v.2.5.0c. 

    72

Openbravo has modified them in order to satisfy its own functional and

    73

technical requirements. Whenever the name was change, the PL/SQL object is 

    74

listed with its new name and the original Compiere name is reported in brackets.

    75

This PL/SQL code is currently distributed by Openbravo using XML files stored

    76

in the /src-db/database folder and named after the database objects

    77

themselves. Each file properly identifies Compiere Inc. as the original 

    78

developer using comments.

    79

  Type          Name

    80

  ----          ----

    81

  FUNCTION      AD_SEQUENCE_NEXTNO

    82

  FUNCTION      M_BOM_PRICELIMIT (original name: BOM_PRICELIMIT)

    83

  FUNCTION      M_BOM_PRICELIST (original name: BOM_PRICELIST)

    84

  FUNCTION      M_BOM_PRICESTD (original name: BOM_PRICESTD)

    85

  FUNCTION      M_BOM_QTY_AVAILABLE (original name: BOM_QTY_AVAILABLE)

    86

  FUNCTION      M_BOM_QTY_ONHAND (original name: BOM_QTY_ONHAND)

    87

  FUNCTION      M_BOM_QTY_ORDERED (original name: BOM_QTY_ORDERED)

    88

  FUNCTION      M_BOM_QTY_RESERVED (original name: BOM_QTY_RESERVED)

    89

  FUNCTION      C_BASE_CONVERT

    90

  FUNCTION      C_CURRENCY_CONVERT

    91

  FUNCTION      C_CURRENCY_CONVERT0

    92

  FUNCTION      C_CURRENCY_RATE

    93

  FUNCTION      C_CURRENCY_ROUND

    94

  FUNCTION      C_UOM_CONVERT

    95

  PROCEDURE     A_ASSET_CREATE

    96

  PROCEDURE     AD_LANGUAGE_CREATE

    97

  PROCEDURE     AD_SEQUENCE_DOC

    98

  PROCEDURE     AD_SEQUENCE_DOCTYPE

    99

  PROCEDURE     AD_SEQUENCE_NEXT

   100

  PROCEDURE     AD_SYNCHRONIZE

   101

  PROCEDURE     AD_TAB_COPY

   102

  PROCEDURE     AD_TAB_IMPORT

   103

  PROCEDURE     AD_TAB_IMPORT0

   104

  PROCEDURE     AD_TABLE_IMPORT

   105

  PROCEDURE     AD_TABLE_IMPORT0

   106

  PROCEDURE     AD_WINDOW_COPY

   107

  PROCEDURE     C_ACCTSCHEMA_DEFAULT_COPY

   108

  PROCEDURE     C_BANKSTATEMENT_POST

   109

  PROCEDURE     C_BP_GROUP_ACCT_COPY

   110

  PROCEDURE     C_CASH_POST

   111

  PROCEDURE     C_COMMISSION_COPY

   112

  PROCEDURE     C_COMMISSION_PROCESS

   113

  PROCEDURE     C_COMMISSIONRUN_PROCESS

   114

  PROCEDURE     C_INVOICE_CANCEL

   115

  PROCEDURE     C_INVOICE_CREATE

   116

  PROCEDURE     C_INVOICE_CREATERECEIPT

   117

  PROCEDURE     C_INVOICE_CREATE0

   118

  PROCEDURE     C_INVOICE_POST

   119

  PROCEDURE     C_INVOICE_POST0

   120

  PROCEDURE     C_ORDER_PO_CREATE

   121

  PROCEDURE     C_ORDER_POST

   122

  PROCEDURE     C_PERIODCONTROL_PROCESS

   123

  PROCEDURE     C_PERIOD_PROCESS

   124

  PROCEDURE     C_PROJECT_GENERATE

   125

  PROCEDURE     C_VALIDCOMBINATION_GET

   126

  PROCEDURE     C_YEARPERIODS

   127

  PROCEDURE     FACT_ACCT_RESET

   128

  PROCEDURE     GL_JOURNALBATCH_POST

   129

  PROCEDURE     GL_JOURNAL_POST

   130

  PROCEDURE     GL_JOURNAL_POST0

   131

  PROCEDURE     M_DISCOUNTSCHEMA_RESEQ

   132

  PROCEDURE     M_INOUT_CANCEL

   133

  PROCEDURE     M_INOUT_CREATE

   134

  PROCEDURE     M_INOUT_CREATEINVOICE

   135

  PROCEDURE     M_INOUT_CREATE0

   136

  PROCEDURE     M_INOUT_POST

   137

  PROCEDURE     M_INOUT_POST0

   138

  PROCEDURE     M_INVENTORY_LISTCREATE

   139

  PROCEDURE     M_INVENTORY_LISTUPDATE

   140

  PROCEDURE     M_INVENTORY_POST

   141

  PROCEDURE     M_MOVEMENT_POST

   142

  PROCEDURE     M_PRICELIST_CREATE

   143

  PROCEDURE     M_PRODUCT_BOM_CHECK

   144

  PROCEDURE     M_PRODUCT_CATEGORY_ACCT_COPY

   145

  PROCEDURE     M_PRODUCTION_RUN

   146

  PROCEDURE     S_TIMEEXPENSE_POST

   147

  TRIGGER       AD_CLIENT_TRG

   148

  TRIGGER       AD_COLUMN_TRG

   149

  TRIGGER       AD_ELEMENT_TRG

   150

  TRIGGER       AD_ELEMENT_TRL_TRG

   151

  TRIGGER       AD_FIELDGROUP_TRG

   152

  TRIGGER       AD_FIELD_TRG

   153

  TRIGGER       AD_FORM_TRG

   154

  TRIGGER       AD_MENU_TRG

   155

  TRIGGER       AD_MESSAGE_TRG

   156

  TRIGGER       AD_ORG_TRG

   157

  TRIGGER       AD_PROCESS_PARA_TRG

   158

  TRIGGER       AD_PROCESS_TRG

   159

  TRIGGER       AD_PROCESS_TRL_TRG

   160

  TRIGGER       AD_REFERENCE_TRG

   161

  TRIGGER       AD_REF_LIST_TRG

   162

  TRIGGER       AD_ROLE_ORGACCESS_TRG

   163

  TRIGGER       AD_ROLE_TRG

   164

  TRIGGER       AD_TABLE_TRG

   165

  TRIGGER       AD_TAB_TRG

   166

  TRIGGER       AD_TREE_TRG

   167

  TRIGGER       AD_WINDOW_TRG

   168

  TRIGGER       AD_WINDOW_TRL_TRG

   169

  TRIGGER       C_ACCTSCHEMA_ELEMENT_TRG

   170

  TRIGGER       C_BANKACCOUNT_TRG

   171

  TRIGGER       C_BANKSTATEMENTLINE_TRG

   172

  TRIGGER       C_BANKSTATEMENT_TRG

   173

  TRIGGER       C_BPARTNER_LOCATION_TRG

   174

  TRIGGER       C_BPARTNER_TRG

   175

  TRIGGER       C_BP_GROUP_TRG

   176

  TRIGGER       C_CASHBOOK_TRG

   177

  TRIGGER       C_CASHLINE_TRG

   178

  TRIGGER       C_CASH_TRG

   179

  TRIGGER       C_CHARGE_TRG

   180

  TRIGGER       C_COMMISSIONAMT_TRG

   181

  TRIGGER       C_COMMISSIONDETAIL_TRG

   182

  TRIGGER       C_CONVERSION_RATE_TRG

   183

  TRIGGER       C_DOCTYPE_TRG

   184

  TRIGGER       C_ELEMENTVALUE_TRG

   185

  TRIGGER       C_GREETING_TRG

   186

  TRIGGER       C_INVOICELINE_TRG

   187

  TRIGGER       C_INVOICETAX_TRG

   188

  TRIGGER       C_ORDERLINE_TRG

   189

  TRIGGER       C_ORDERTAX_TRG

   190

  TRIGGER       C_ORDER_TRG

   191

  TRIGGER       C_PAYMENTTERM_TRG

   192

  TRIGGER       C_PERIOD_TRG

   193

  TRIGGER       C_PERIOD_TRG2

   194

  TRIGGER       C_PROJECTLINE_TRG

   195

  TRIGGER       C_PROJECTLINE_TRG3

   196

  TRIGGER       C_PROJECT_TRG

   197

  TRIGGER       C_SALESREGION_TRG

   198

  TRIGGER       C_TAXCATEGORY_TRG

   199

  TRIGGER       C_TAX_TRG

   200

  TRIGGER       C_UOM_TRG

   201

  TRIGGER       C_VALIDCOMBINATION_TRG

   202

  TRIGGER       C_WITHHOLDING_TRG

   203

  TRIGGER       GL_JOURNALLINE_TRG

   204

  TRIGGER       GL_JOURNAL_TRG

   205

  TRIGGER       M_INOUTLINE_TRG

   206

  TRIGGER       M_INVENTORYLINE_TRG

   207

  TRIGGER       M_MATCHPO_TRG

   208

  TRIGGER       M_MOVEMENTLINE_TRG

   209

  TRIGGER       M_PRODUCT_BOM_TRG

   210

  TRIGGER       M_PRODUCT_CATEGORY_TRG

   211

  TRIGGER       M_PRODUCTIONLINE_TRG

   212

  TRIGGER       M_PRODUCTIONPLAN_TRG

   213

  TRIGGER       M_PRODUCT_TRG

   214

  TRIGGER       M_WAREHOUSE_TRG

   215

  TRIGGER       S_EXPENSETYPE_TRG

   216

  TRIGGER       S_RESOURCE_TRG

   217

  TRIGGER       S_RESOURCETYPE_TRG

   218

  TRIGGER       S_RESOURCEUNAVAILABLE_TRG

   219

   220

   221

Database Tables

   222

---------------

   223

The following database tables and views were originally designed by Compiere

   224

Inc. and distributed in Compiere ERP & CRM v.2.5.0c.

   225

Openbravo modified them in order to satisfy its own functional and technical

   226

requirements. Whenever the name was change, the table is listed with its new

   227

name and the original Compiere name is reported in brackets:

   228

   229

  A_ASSET

   230

  A_ASSET_GROUP

   231

  AD_ALERT

   232

  AD_ALERTRECIPIENT

   233

  AD_ALERTRULE

   234

  AD_CLIENT

   235

  AD_CLIENTINFO

   236

  AD_COLUMN

   237

  AD_ELEMENT

   238

  AD_ELEMENT_TRL

   239

  AD_FIELD

   240

  AD_FIELD_TRL

   241

  AD_FIELDGROUP

   242

  AD_FIELDGROUP_TRL

   243

  AD_FORM

   244

  AD_FORM_ACCESS

   245

  AD_FORM_TRL

   246

  AD_IMAGE

   247

  AD_LANGUAGE

   248

  AD_MENU

   249

  AD_MENU_TRL

   250

  AD_MESSAGE

   251

  AD_MESSAGE_TRL

   252

  AD_ORG

   253

  AD_ORGINFO

   254

  AD_PINSTANCE

   255

  AD_PINSTANCE_PARA

   256

  AD_PREFERENCE

   257

  AD_PROCESS

   258

  AD_PROCESS_ACCESS

   259

  AD_PROCESS_PARA

   260

  AD_PROCESS_PARA_TRL

   261

  AD_PROCESS_TRL

   262

  AD_REF_LIST

   263

  AD_REF_LIST_TRL

   264

  AD_REF_TABLE

   265

  AD_REFERENCE

   266

  AD_REFERENCE_TRL

   267

  AD_ROLE

   268

  AD_ROLE_ORGACCESS

   269

  AD_SEQUENCE

   270

  AD_SESSION

   271

  AD_SYSTEM

   272

  AD_TAB

   273

  AD_TAB_TRL

   274

  AD_TABLE

   275

  AD_TABLE_ACCESS

   276

  AD_TREE

   277

  AD_TREENODE

   278

  AD_USER

   279

  AD_USER_ROLES

   280

  AD_VAL_RULE

   281

  AD_WINDOW

   282

  AD_WINDOW_ACCESS

   283

  AD_WINDOW_TRL

   284

  C_ACCTSCHEMA

   285

  C_ACCTSCHEMA_DEFAULT

   286

  C_ACCTSCHEMA_ELEMENT

   287

  C_ACCTSCHEMA_GL

   288

  C_ACTIVITY

   289

  C_BANK

   290

  C_BANKACCOUNT

   291

  C_BANKACCOUNT_ACCT

   292

  C_BANKSTATEMENT

   293

  C_BANKSTATEMENTLINE

   294

  C_BP_BANKACCOUNT

   295

  C_BP_CUSTOMER_ACCT

   296

  C_BP_EMPLOYEE_ACCT

   297

  C_BP_GROUP

   298

  C_BP_GROUP_ACCT

   299

  C_BP_VENDOR_ACCT

   300

  C_BP_WITHHOLDING

   301

  C_BPARTNER

   302

  C_BPARTNER_LOCATION

   303

  C_CALENDAR

   304

  C_CAMPAIGN

   305

  C_CASH

   306

  C_CASHBOOK

   307

  C_CASHBOOK_ACCT

   308

  C_CASHLINE

   309

  C_CHANNEL

   310

  C_CHARGE

   311

  C_CHARGE_ACCT

   312

  C_INVOICE_V2 (original name: RV_C_INVOICE)

   313

  C_INVOICELINE (original name: RV_C_INVOICELINE)

   314

  C_CITY

   315

  C_COMMISSION

   316

  C_COMMISSIONAMT

   317

  C_COMMISSIONDETAIL

   318

  C_COMMISSIONLINE

   319

  C_COMMISSIONRUN

   320

  C_CONVERSION_RATE

   321

  C_COUNTRY

   322

  C_COUNTRY_TRL

   323

  C_CURRENCY

   324

  C_CURRENCY_TRL

   325

  C_DEBT_PAYMENT_V

   326

  C_DOCTYPE

   327

  C_DOCTYPE_TRL

   328

  C_ELEMENT

   329

  C_ELEMENTVALUE

   330

  C_ELEMENTVALUE_TRL

   331

  C_GREETING

   332

  C_GREETING_TRL

   333

  C_INVOICE

   334

  C_INVOICELINE

   335

  C_INVOICESCHEDULE

   336

  C_INVOICETAX

   337

  C_LOCATION

   338

  C_NONBUSINESSDAY

   339

  C_ORDER

   340

  C_ORDERLINE

   341

  C_ORDERTAX

   342

  C_PAYMENTTERM

   343

  C_PAYMENTTERM_TRL

   344

  C_PERIOD

   345

  C_PERIODCONTROL

   346

  C_PHASE

   347

  C_PROJECT

   348

  C_PROJECT_ACCT

   349

  C_PROJECTLINE

   350

  C_PROJECTPHASE

   351

  C_PROJECTTASK

   352

  C_PROJECTTYPE

   353

  C_REGION

   354

  C_SALESREGION

   355

  C_TASK

   356

  C_TAX

   357

  C_TAX_ACCT

   358

  C_TAX_TRL

   359

  C_TAXCATEGORY

   360

  C_TAXCATEGORY_TRL

   361

  C_UOM

   362

  C_UOM_CONVERSION

   363

  C_UOM_TRL

   364

  C_VALIDCOMBINATION

   365

  C_WITHHOLDING

   366

  C_WITHHOLDING_ACCT

   367

  C_YEAR

   368

  FACT_ACCT

   369

  GL_CATEGORY

   370

  GL_JOURNAL

   371

  GL_JOURNALBATCH

   372

  GL_JOURNALLINE

   373

  M_ATTRIBUTE

   374

  M_ATTRIBUTEINSTANCE

   375

  M_ATTRIBUTESET

   376

  M_ATTRIBUTESETINSTANCE

   377

  M_ATTRIBUTEUSE

   378

  M_ATTRIBUTEVALUE

   379

  M_DISCOUNTSCHEMA

   380

  M_DISCOUNTSCHEMALINE

   381

  M_FREIGHT

   382

  M_FREIGHTCATEGORY

   383

  M_INOUT

   384

  M_INOUTLINE

   385

  M_INVENTORY

   386

  M_INVENTORYLINE

   387

  M_LOCATOR

   388

  M_LOT

   389

  M_LOTCTL

   390

  M_MATCHINV

   391

  M_MATCHPO

   392

  M_MOVEMENT

   393

  M_MOVEMENTLINE

   394

  M_PRICELIST

   395

  M_PRICELIST_VERSION

   396

  M_PRODUCT

   397

  M_PRODUCT_ACCT

   398

  M_PRODUCT_BOM

   399

  M_PRODUCT_CATEGORY

   400

  M_PRODUCT_CATEGORY_ACCT

   401

  M_PRODUCT_PO

   402

  M_PRODUCT_TRL

   403

  M_PRODUCTION

   404

  M_PRODUCTIONLINE

   405

  M_PRODUCTIONPLAN

   406

  M_PRODUCTPRICE

   407

  M_SERNOCTL

   408

  M_SHIPPER

   409

  M_SUBSTITUTE

   410

  M_TRANSACTION

   411

  M_TRANSACTION_V (original name: RV_M_TRANSACTION)

   412

  M_WAREHOUSE

   413

  M_WAREHOUSE_ACCT

   414

  S_EXPENSETYPE

   415

  S_RESOURCE

   416

  S_RESOURCEASSIGNMENT

   417

  S_RESOURCETYPE

   418

  S_RESOURCEUNAVAILABLE

   419

  S_TIMEEXPENSE

   420

  S_TIMEEXPENSELINE

   421

  S_TIMETYPE

   422

   423

These tables and views are currently distributed by Openbravo using XML files

   424

stored in the /src-db/database folder and named after the tables themselves.

   425

   426

Database Records

   427

----------------

   428

The following database tables contain records that have been originally 

   429

defined by Compiere Inc. and distributed in Compiere ERP & CRM v.2.5.0c.

   430

Openbravo modified them in order to satisfy its own functional and

   431

technical requirements:

   432

   433

  AD_CLIENT

   434

  AD_CLIENTINFO

   435

  AD_COLUMN

   436

  AD_ELEMENT

   437

  AD_FIELD

   438

  AD_FIELDGROUP

   439

  AD_FORM

   440

  AD_LANGUAGE

   441

  AD_MENU

   442

  AD_MESSAGE

   443

  AD_ORG

   444

  AD_ORGINFO

   445

  AD_PREFERENCE

   446

  AD_PROCESS

   447

  AD_PROCESS_PARA

   448

  AD_REFERENCE

   449

  AD_REF_LIST

   450

  AD_REF_TABLE

   451

  AD_ROLE

   452

  AD_ROLE_ORGACCESS

   453

  AD_TAB

   454

  AD_TABLE

   455

  AD_TREE

   456

  AD_TREENODE

   457

  AD_USER

   458

  AD_USER_ROLES

   459

  AD_VAL_RULE

   460

  AD_WINDOW

   461

   462

These tables also contain additional records that have been autonomously 

   463

defined by Openbravo. The  records derived by Compiere can be identified by

   464

their ID range:

   465

        - Records identified by an ID lower than 100000 are based upon

   466

          Compiere

   467

        - Records identified by an ID higher or equal to 100000 have been 

   468

          added by Openbravo

   469

The content of these tables is currently distributed by Openbravo using XML

   470

files stored in the /src-db/database folder and named after the tables

   471

themselves.

   472