Projects:Documentmanagement/Technical Documentation

Contents 1 Document Management - Technical Specification 1.1 Overview 1.2 New Module Specifications 1.2.1 Tab Details 1.3 New Table in DB 1.4 Table Specifications 1.4.1 Document Header Table 1.4.2 Document Header Columns 1.4.3 Document Line Table 1.4.4 Document Line Columns 1.5 Window Specifications 1.6 Changes in Product Window 1.7 Menu Entry Specification

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

• Name - Openbravo Document Management
• Version - 0.1.0
• Java package - org.openbravo.documentmanagement
• Description -
• Transulation Required - Enable
• Module_Language - En_US
• License - Openbravo Comercial License
• License Text -
• Author - Openbravo S.L.

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

• Name: OBDM_Document_Management
• Table Name: OBDM_DOC_MANAGEMENT
• Java Class Name: DocManagement
• Data Access Level: Client/Org

Document Header Columns

• Obdm_Doc_Management_ID - ID Reference
• Parent_Doc_ID – Table Reference
• Documenttype – List Reference with values (Professional,Subscription,Parnership)

Document Line Table

• Table Name – OBDM_Doc_managementLine
• Jave Class Name – DocManagementLine
• Data Access Level – Client/Org
• Deletable Records - Enable

Document Line Columns

• ValidFromDate – Default – Sysdate
• DocumentStatus – List Reference with Values(Draft,Active,Absolute)
• URL – Link
• Obdm_Doc_Management_ID - TableDir

Window Specifications

• Name – Document Management
• Tab – Header,Lines(With coresponding Tables)
• Field Sequence – As specified in functional mock-ups

Changes in Product Window

Create a new reference "OBDM_DOC_MANAGEMENT_ID":

• Reference type: Table
• Name : OBDM Document Management
• Table Referenced: OBDM_DOC_MANAGEMENT
• Display columns: DocumentNo, Name

Create a new column and field in M_Product:

• Column: EM_Obdm_Doc_Management_ID as a foreign key to OBDM_DOC_MANAGEMENT
• Field: Reference > Table > OBDM_DOC_MANAGEMENT

Menu Entry Specification

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

• Search Key: Document Management
• Name: Document Management
• Active: Checked
• Action: Window
• Process: Select here the recently created Window