Monday, March 8, 2021

Financial Dimension Query

 

select IT.ITEMID, IT.DATAAREAID, ETDGI.TRACKINGDIMENSIONGROUP, ETDG.RECID, ETDGF.DIMENSIONFIELDID from PRODTABLE PT

join INVENTTABLE IT on PT.ITEMID=IT.ITEMID

join EcoResTrackingDimensionGroupItem ETDGI on ETDGI.ITEMID=IT.ITEMID and ETDGI.ITEMDATAAREAID=IT.DATAAREAID

join EcoResTrackingDimensionGroup ETDG on ETDG.RECID=ETDGI.TRACKINGDIMENSIONGROUP

join EcoResTrackingDimensionGroupFldSetup ETDGF on ETDGF.TRACKINGDIMENSIONGROUP=ETDG.RECID

where PT.PRODID='TST1-000060'

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How get primary email of customer or vendor

Below code is for customer only, for vendor we need to replace  CustTable  with VendTable.   dirPartyContactInfoView        dirPartyContactI...

  • Customer Aging Report
     /// <summary> /// Extension of <c>CustVendBalanceList</c> class /// </summary> [ExtensionOf(classStr(CustVendBalanc...
  • Purchase order
        Purchase order overview             A purchase order (PO) is an agreement with a vendor to buy goods or services. This helps keep trac...
  • ExtensionOf versus extends
      "extends" is about inheritance in the usual object-oriented way. You create a new class inheriting from the base class and you c...