Question

Purchase order attributes.

  • 15 December 2021
  • 2 replies
  • 165 views

Userlevel 2
Badge +2

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

Userlevel 5
Badge +13

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?

Userlevel 3
Badge +5

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