Baanboard.com

Go Back   Baanboard.com > Forum > BB Language Forums > Deutsches Forum

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 24th July 2017, 15:58
MS-Tech MS-Tech is offline
Member
 
Join Date: Dec 2015
Posts: 66
MS-Tech is on a distinguished road
Baan: 6 - DB: SQL-Server - OS: Windows 7
CustomerDefinedFields
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?

Grüße
Reply With Quote
  #2  
Old 3rd August 2017, 13:00
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,639
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

Hallo,
Code:
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.

Restrictions

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
----------------------------------------------------------------
rdi.table.column()
Syntax:

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

Description

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

Arguments

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:

DB.ARRAY

DB.CDF

DB.CHILD

DB.FILLED 
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

Context

This function can be used in all script types.
------------------------------------------------------------------------------------------
Regards
__________________
//Bernd
Reply With Quote
  #3  
Old 22nd August 2017, 08:15
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 728
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
Sponsored Links
Reply


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 21:03.


©2001-2017 - Baanboard.com - Baanforums.com