Hi,
There is one table that stores index names, yes.
The index for field id 1 is implicit for all regular forms, so that would not
be in there I think.
No, I do not think any tables are created for each currency.
For each functional currency defined for an individual currency field the
system stores amount, current currency type, timestamp and exchange rates for
al the functional currencies. But this is done within normal text-data of that
field, and does not add additional columns to the database.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hey Misi thanks for responding. I know how to find the tables from
> database and I also know how to use ar schema metadata form.
>
> Just wanted to know if ar system really creates individual tables for
> each regular form when we add a currency fields.
>
> As per your comments we it seems there is only a single table which
> stores indexes for all form - Please confirm this.
>
> Thank you Misi.
>
> On 3/6/14, Misi Mladoniczky <[email protected]> wrote:
>> Hi,
>>
>> The two main currency forms are:
>> AR System Currency Codes - allowed currencies of your system
>> AR System Currency Ratios - dates and exchange rate
>>
>> To find out which table things are stored in, you can check the form "AR
>> System Metadata: arschema", or the arschema-table directly. It contain a
>> mapping between the Name and the SchemaId.
>>
>> The SchemaId is a number, for example 123. This means that the man table of
>> the form is T123. Note that the numbers for a specific form varies between
>> systems.
>>
>> All normal forms has at least one index for the request id field. They can
>> also have more indexes defined through Developer Studio under form
>> properties.
>> You can also find these indexes in the form "AR System Metadata:
>> schema_index"
>> table or the corresponding table schema_index.
>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
>> Find these products, and many free tools and utilities, at http://rrr.se.
>>
>>> Hi List,
>>>
>>> It is given in the docs as currency table under that they gave an
>>> explanation
>>> for a currency field. Just wondering does currency table really exist? I
>>> don't
>>> think so. Correct me I am thinking wrong.
>>>
>>> https://docs.bmc.com/docs/display/public/ars81/The+currency+table+for+a+form
>>>
>>> One more thing how can I find the index table for a corresponding form?
>>> Does
>>> AR System creates a separate index table for each regular form?
>>>
>>> Mercy,
>>> Sweety.
>>>
>>> _______________________________________________________________________________
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> "Where the Answers Are, and have been for 20 years"
>>>
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> "Where the Answers Are, and have been for 20 years"
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
