Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
<b>This reference table</b> must contain a field with the format for the currency key (data type CUKY) or unit of measure (data type UNIT). This field is called the reference field of the output field. The reference field can also reside in the table itself.
Check this examples.
<b>A field containing currency amounts (data type CURR) must be assigned to a reference table and a reference field.</b>
• As a reference table, a system table containing all the valid currencies is assigned or any other table which contains a field with the currency key format. This field is called as reference field. The assignment of the field containing currency amounts to the reference field is made at runtime. The value in the reference field determines the currency of the amount.
<b> A field containing quantity amounts (data type QUAN) must be assigned to a reference table and a reference field.</b>
• As a reference table, a system table containing all the valid quantity units is assigned or any other table which contains a field with the format for quantity units (data type UNIT). This field is called as reference field. The assignment of the field containing quantity amounts to the reference field is made at runtime. The value in the reference field determines the quantity unit of the amount.
The reference table and reference field are the fields which specify the currency key or Unit of Measure. Suppose if the user specifies a currency amount say 1000$, the currency amount field would indicate the amount 1000 and the currency key indicates that the currency specified is in Dollars.
Different geological locations have different currencies and they use different quantitative units for eg. meters in India and yards in United Kingdom. So for making the data in the table be understandable by people of different locations who are comfortable with the local currencies and quantities, currency fields (data type CURR) and quantity fields (data type QUAN) are linked to their respective reference table.
This reference table contain a field with the format for the currency key (data type CUKY) orunit of measure (data type UNIT). This field is called the reference field of the output field. The reference field can also reside in the table itself.
Reference Table::A data table that you create or use for data analysis.
A table generated to implement a many-to-many relationship.
A reference table (or table of reference) may mean a set of references that an author may have cited or gained inspiration from whilst writing an article, similar to a bibliography.
It can also mean an information table that is used as a quick and easy reference for things that are difficult to remember such as comparing imperial with metric measurements.
In the context of Database Design a Reference Table is a table into which an enumerated set of possible values of a certain field data type is divested. For example, in a relational database model of a warehouse the entity 'Item' may have a field called 'status' with a predefined set of values such as 'sold', 'reserved', 'out of stock'. In a purely designed database these values would be divested into an extra entity or Reference Table called 'status' in order to achieve database normalisation. The entity 'status' in this case has no true representative in the real world but rather would an exceptional case where the attribute of a certain database entity is divested into its own table. The advantage of doing this is that internal functionality and optional conditions within the database and the software which utilizes it are easier to modify and extend on that particular aspect. Establishing an enterprise-wide view of reference tables is called master data management.
Bluesky
