Skip to main content
Question

Purchase order attributes.

  • December 15, 2021
  • 2 replies
  • 174 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

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings