x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 1067 views
  • Users 0 members are here
Browse Forums
Announcements
234
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
209
topics
408
replies
Sage Intelligence Reporting
121
topics
322
replies
Ruben Ferreira

Query tool - How to get data from custom fields

SUGGESTED
Posted By

Hello everyone,

I am running a Query to get some info about a item.

Table ITMMASTER; Field ITMREF; Others Fields by default.

The info that i need is related with a Custom Field, where i need the value of the field and their descripton. 

Table ITMMASTER; Field YACAB; Others Fields by default. Will return "V02", How do i get "VZ MT"? 

I already try collect the descripton from the tables ATABDIV and ATEXTRA but i do not know how to make the connection. 

Someone can help me?

Thank you guys.

  • 0
    SUGGESTED

    Hi,

    You will get the value from the ATEXTRA, the index on the table ATEXTRA is as follow:

    CODFIC+ZONE+LANGUE+IDENT1+IDENT2
    CODFIC = "ATABDIV" : if We are using the miscellaneous table to fetch and retrieve the value.
    ZONE = "LNGDES": It is use to store data type "LNGDES/SHODES"
    LANGUE = "ENG": The language for storing the data.
    IDENT1 = "6012" : Miscellaneous table code if you are using the miscellaneous table.
    IDENT2 = VALUE #Code from miscellaneous table '6012'

    After applying the above filter you will receive value in "TEXTE" field.

*Community Hub is the new name for Sage City