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"
