Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
IX table file 2
- Thread starter Jakov
- Start date
-
1
- #2
It's used when you have multiple currencies, not sure of what the data is but I'm guessing something relating to the indices between two currencies.
When checking the data dictionary It is referenced in two database tables msf052 (storing date and value of currency conversion) and in msf225 (price adjustments) - also say used in msf221 (purchase order items) and msf210 (stock codes/suppliers/price codes).
Hope this helps... Drew
When checking the data dictionary It is referenced in two database tables msf052 (storing date and value of currency conversion) and in msf225 (price adjustments) - also say used in msf221 (purchase order items) and msf210 (stock codes/suppliers/price codes).
Hope this helps... Drew
-
1
- #3
Ellipse User ref documenattion:
IX Table File
Table File Name
Index Types
Defined By
Client-defined
Description
This code is used to describe the index type per currency used for price adjustment calculations.
IX Table File - Associated Values
Position
Associated Value Description
1
Y indicates that the particular code is Active.
N or Space indicates Inactive. If the code is inactive, the rates stored against the index type will not be used.
Also:
MSO011 /Table Type XX Table Code IX shows that this table
is NOT maintained by MSO010, so there must be a dedicated screen to maintain it . The program to miantain is MSO052
The program to review is MSO053.
Following Unix commnad can be used to list all programs that refer to 'IX':
grep -li "'IX'" mso*
IX Table File
Table File Name
Index Types
Defined By
Client-defined
Description
This code is used to describe the index type per currency used for price adjustment calculations.
IX Table File - Associated Values
Position
Associated Value Description
1
Y indicates that the particular code is Active.
N or Space indicates Inactive. If the code is inactive, the rates stored against the index type will not be used.
Also:
MSO011 /Table Type XX Table Code IX shows that this table
is NOT maintained by MSO010, so there must be a dedicated screen to maintain it . The program to miantain is MSO052
The program to review is MSO053.
Following Unix commnad can be used to list all programs that refer to 'IX':
grep -li "'IX'" mso*
- Status
Similar threads
