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
- 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