Go Back > Forum > BB Language Forums > Deutsches Forum

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 54

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 24th July 2017, 16:58
MS-Tech MS-Tech is offline
Join Date: Dec 2015
Posts: 66
MS-Tech is on a distinguished road
Baan: 6 - DB: SQL-Server - OS: Windows 7
Baan: ERP LN 6.1 FP9 (Infor ERP 10.3)

Hallo Zusammen,

ist es möglich CustomerDefinedFields einzufügen, deren Basis eine Enumeration ist? Ich habe eine eigene Domain (Enumeration) gebaut. Dieses würde ich gerne als CDF-Field einfügen.

Wenn nun ein Angebot gedruckt wird, dann können/sollten hier noch zusätzliche Informationen angegeben werden. Ist das aber generell möglich? Wenn nicht, wie könnte ich das sonst bewerkstelligen?

Reply With Quote
Sponsored Links
Old 3rd August 2017, 14:00
bdittmar's Avatar
bdittmar bdittmar is offline
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,760
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES

CDF handling overview
In some areas of the application there is a requirement
to add easy and for free Customer Defined Fields.
This fields solve the business requirements of (a group of)
customers, but their need is not generic enough for deployment
in the standard. Free Customer Defined Fields could help
a customer to store his specific data requirements without
having to customize the system. The information in the CDFs
are, when possible, carried forward through the business process.
For instance when customer specific data is stored on the requisition
header it should be carried forward when the requisition is turned
into a purchase order and finally into an invoice.


The following restrictions on CDFs are imposed:

There can not be references on a CDF
There can not be permissions on a CDF
There can not be indexes on a CDF
It is not possible to have an array column defined as CDF
A CDF can not be defined as a MLF

function long  rdi.table.column  (string table_name(9), long column_number,
ref string column_name, ref string domain_name(14), ref long offset,
ref long size, ref long dept, ref long type, ref long flag,
ref long default_value [, long flag_filter])


This returns information about a specified column which is identified
by the table name and the column number. Note that the first columns
in the table are reserved for the following columns: Refcntd, Refcntu,
_compnr, _dlock, and _index<number> (one column for each index).


string table_name(9) The name of the table in which the column occurs (omit the leading 't').
long column_number The column number.
ref string column_name This returns the name of the column.
ref string domain_name(14) This returns the name of the column's domain.
ref long offset This returns the position of the column in the row.
ref long size This returns the size of the column, in bytes.
ref long dept This returns the depth of the column (array columns only).
ref long type This returns the database type of the column. For example, DB.LONG, DB.FLOAT, and so on.
For a list of all possible database types, see Database handling overview.
ref long flag This returns a bit pattern that represents one or more of the following values:




ref long default_value This returns the default value of the column.
[long flag_filter ] This optional argument can be used to get a filtered list
of columns that have the specified flag set.

For example, the 2nd CDF column from a table can be retrieved by callimg
this finction with column_name = 2 and flag_filter = DB.CDF
Return values

 0         success

-1         error


This function can be used in all script types.
Reply With Quote
Old 22nd August 2017, 09:15
JaapJD's Avatar
JaapJD JaapJD is offline
Join Date: Sep 2002
Location: Netherlands
Posts: 823
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
As of LN Tools 10.5.1 you can link a standard or own (enum) domain to CDFs.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +2. The time now is 20:50.

©2001-2018 - -