Information Technology Blog

Showing posts with label Database Management in BAAN ERP. Show all posts

Create Table in BAAN ERP

23:17 Admin 4 comments

1st Method
The purpose of the Create Tables (ttaad4230m000) session is to create tables by company and package.
Menu: BAAN IV Tools / Database Management / Miscellaneous
Session: Create Tables (ttaad4230m000)

2nd Method

Step1: First create domain if you don't want to use exixting domians.

Step2: After creating new domains, convert them to runtime data dictionary and log out the BAAN

Step3:Now create new tables based on new domains because table structure is dependent on domains.

Step4: Convert them to Runtime Data dictionary and after this log out the BAAN again for saving the changes.

Step5: There is one option in Special in maintain domain and table definition in BAAN tools. Under Special there is one option create table , from where you can create table if you don't want to use 1st Method.

Related Posts:

Maintaining Database Definition

23:00 Admin No comments

The purpose of the Maintain Database Definitions (ttaad4110m000) session is to define databases, database description types, mirroring specifications, audit trail generation, and whether or not a remote server is utilized.
Menu: BAAN IV Tools / Database Management / Maintenance
Session: Maintain Database Definitions (ttaad4110m000)

Important Fields

Database

Database Type

Audit Trail

Note:

You do not have to run this session very often, since these things are set up at installation.

Database Management in BAAN ERP

Create Company

Create Table

Create Company

22:54 Admin 1 comment

The purpose of the Maintain Companies (ttaad1100m000) session is to define company numbers, specify first day of week, default currency and the package combinations to be used by the company.
Menu: BAAN IV Tools / Application Configuration
Session: Maintain Companies (ttaad1100m000)

Related Posts

Database Management in BAAN ERP

22:45 Admin 23 comments

Introduction
BAAN applications store data in tables. This data is modified, processed, and printed using several different sessions. BAAN Tools offers tremendous flexibility regarding data storage.

Database Management Procedure

Database Management Overview

BAAN is database and hardware independent. In other words, you can store your data in BAAN Base, Oracle, Informix, and other formats. Moreover, this data can be stored on the machine where BAAN is started or on one or more remote machines on your network. The format and location of data is totally transparent to your application.

Database Management within a Package Combination