Skip to main content
Question

Purchase order attributes.

  • December 15, 2021
  • 2 replies
  • 177 views

VIMNLK
Do Gooder (Customer)
Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • 2 replies

How to find the below attributes in a purchase order? Need to know where it is fetching data from (Like from which fields in the purchase order)

  •    BASE_CURRENCY_CODE
  •    REP_CURR_CODE
  •    REP_CURR_RATE

  •    REP_CURR_DISCOUNT_AMOUNT_BASE

  •    REP_CURR_NET_LINE_PRICE_BASE

2 replies

Forum|alt.badge.img+14
  • Superhero (Employee)
  • 159 replies
  • December 15, 2021

These fields aren’t available on the purchase order screen itself. Can I ask where you got these attributes from? Did you get them from a specific table or view?


Forum|alt.badge.img+6

Hi Vimukthi,

Found above attributes mentioned in file “dbo.Dm_FACT_PURCHASE_ORDER_LINE.sql” of component PURCFT. It is a Business Intelligence related component. Those attributes are fetched from table “Dm_FACT_PURCHASE_ORDER_LINE”.

 

Best Regards,

Anjaleen