View source | View content page | Page history | Printable version   

Projects:Documentmanagement/Technical Documentation

Contents

Document Management - Technical Specification

Overview

A new module 'Openbravo Add-on Functionalities', is intended to add new functionalities at obatob. The one of the functionality is document management, in order to store document against each product. Each document may have different versions.This new process has to be started with new module creation,table, window,menu and process.

New Module Specifications

Tab Details

In the dependency tab: Dependant on core MP8
In the prefix tab: Prefix=OBDM
In the datapackage tab: org.openbravo.documentmanagement

New Table in DB

Header Table Name – OBDM_DOC_MANAGEMENT

Field Name Data Type Length

OBDM_DOC_MANAGEMENT_ID

Varchar2

32

DocumentNo

NVarchar2

30

Name

NVarchar2

60

Ad_Client_Id

Varchar2

32

Ad_Org_Id

Varchar2

32

PARENT_DOC_ID

Varchar2

32

DocumentType

Varchar2

60

Created

Date

Default - Sysdate

Created By

Varchar2

32

Updated

Date

Default - Sysdate

Updated By

Varchar

32

ISACTIVE

char

1


Lines Table Name – OBDM_DOC_MANAGEMENTLINE

Field Name Data Type Length

OBDM_DOC_MANAGEMENTLINE_ID

Varchar2

32

OBDM_DOC_MANAGEMENT_ID

Varchar2

32

AD_CLIENT_ID

Varchar2

32

AD_ORG_ID

Varchar2

32

Release

NVarchar2

60

DateFrom

Date

DataTo

Date

DocumentStatus

Varchar2

60

Description

Nvarchar2

6000

URL

NVarchar2

120

Created

Date

Default - Sysdate

Created By

Varchar2

32

Updated

Date

Default - Sysdate

Updated By

Varchar2

32

ISACTIVE

CHAR

1 - Default - 'Y'

Table Specifications

Document Header Table

Document Header Columns

Document Line Table

Document Line Columns

Window Specifications

Changes in Product Window

Create a new reference "OBDM_DOC_MANAGEMENT_ID":

Create a new column and field in M_Product:

Menu Entry Specification

This new menu entry should be under (Master Data Management)

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Documentmanagement/Technical_Documentation"

This page has been accessed 3,259 times. This page was last modified on 8 June 2012, at 05:31. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.