| create DFF which should be unique and Non Mandatory [message #358627] |
Wed, 12 November 2008 00:13  |
radhavijay
Messages: 29
Registered: July 2008
|
Junior Member |
|
|
Hi All,
I want to create a DFF the filed which must be unique and non mandatory in AP-->Supplier-->entry form
when we are entering values in DFF then the Values must be in 3 formats
1. for local companies(yyyynnnnnX)
2. for business (nnnnnnnnX)
3. for others entity tpyes(TyyPQnnnnX)
where y=year
n=0-9 numbers
X= a,b,c,d.....
Tyy= year of issuance T standsfor 20
PQ = entity type
available with in respective agency.
i had created the DFF but im not getting how to create the value sets in above formats
so any one please help me.
Im new to this work.
please this is an Urgent work for me.
this same DFF im must Create in AR-->Customers-->Standard form also
Thanks in Advance
Regards,
Radha
|
|
|
|
| Re: create DFF which should be unique and Non Mandatory [message #358684 is a reply to message #358627] |
Wed, 12 November 2008 02:51  |
ggr88
Messages: 31
Registered: October 2007
Location: Wellington, New Zealand
|
Member |
|
|
Hi,
Part 1. Validation - Trivilal - this is just where clause on a select from dual - possibly with use of regular expressions to ease the pain.
Part 2. Uniqueness - 2 options here:
- 2a) create a unique index on the attributeXX column. Best option if you plan to report with parameter based on this attribute.
- 2b) value set that selects on existing values in table (harder) but trivial - needs to tie into 1.
Regards,
Gareth
|
|
|
|
|
|
| Re: create DFF which should be unique and Non Mandatory [message #381951 is a reply to message #358627] |
Tue, 20 January 2009 07:07 |
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
|
Senior Member |
|
|
Hi
DFF has fixed type of format types. the format which your asking i dont think it is possible but you can do workaround
create three context field values
1. for local companies
2. for business
3. for others entity tpyes
based on the selection you can divide the fields like
if you select
1. for local companies
create three
1. segment yyyy,
2. segment nnnnn,
3. segment xxxxx
in this way you can fix the format type validation.
In reports you can concatinate all the segments
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
