Sunday, July 22, 2018

AR_CREDIT_MEMO_AMOUNTS table Overview

AR_CREDIT_MEMO_AMOUNTS
credit_memo_amount_id
customer_trx_line_id
gl_date
amount


AR_CREDIT_MEMO_AMOUNTS stores the GL dates and amounts for credit memos to use when
they are applied to invoices with rules.

Each credit memo application date is stored as a unique record, based on the primary key, credit_memo_amount_id.

The customer_trx_line_id references the transaction line to which this credit memo applies.

The gl_date column stores the date the credit memo should be applied to the invoice and the amount column stores the amount to apply.

No comments:

Post a Comment

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...