Posts

Showing posts with the label Tax Rate Code

Getting the Tax Rate Codes by Business Unit and Reference Set

Use the Below QUERY to get the Tax Rate Codes corresponding to each Business Unit and Reference Data Set. SELECT A.INTERNAL_ORGANIZATION_ID,        BU.BU_NAME,        R.TAX_RATE_CODE,        RM.COUNTRY_CODE,        T.TAX_TYPE_CODE,        RM.TAX_REGIME_CODE,        RM.REGIME_TYPE_FLAG,        LC.LOOKUP_TYPE,        LC.LOOKUP_CODE,        LC.DISPLAY_SEQUENCE,        LC.ENABLED_FLAG,        LC.START_DATE_ACTIVE,        LC.END_DATE_ACTIVE,        LC.MEANING,        LC.DESCRIPTION,        LC.TAG,   ...