List of Contributions

The SQL statement that will run is the concatenation of the current effective dated from table EQTN_SQL_CHUNKS. This can be different from field EQTN_SQL_TEXT on table EQTN_SQL_TBL. 1) DELETING a row from EQTN_SQL_TBL does not automatically delete from EQTN_SQL_CHUNKS. To properly delete it you need ...

Hello Lidia, On table ITEM_SF, a single PAYMENT_ID_NBR value may appear on several rows for any unique combination of BUSINESS_UNIT, COMMON_ID, and SA_ID_TYPE. This is based on how a payment is split. Table ITEM_LINE_SF is a child record of ITEM_SF. I generally think of ITEM_LINE_SF as a ...

Good morning, Lee, Your screenshots of the fields tab from query manager show that only the first 10 characters of your fourth column are included in the output, and the dates are sorted within the listagg by themselves. To simply your SQL statements, you could replace your expressions that combine ...