Skip to main content

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

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?


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