AR_ADJUSTMENTS table overview

AR_ADJUSTMENTS
adjustment_id	amount	customer_trx_id	type	payment_schedule_id	code_combination_id

AR_ADJUSTMENTS stores information about invoice adjustments. Each adjustment is stored as a unique record, based on the primary key, adjustment_id. The amount column stores the amount of the adjustment. Receivables uses the customer_trx_id and payment_schedule_id to link the adjustment to the adjusted transaction and to update the amount_due_remaining and amount_adjusted columns of the adjusted transaction's payment schedule in the AR_PAYMENT_SCHEDULES table. The type column stores a description of the transaction to which the adjustment applies. Valid types include:

• Charges Adjustments

• Freight Adjustments

• Invoice Adjustments

• Line Adjustments

• Tax Adjustments

The code_combination_id column stores the accounting distribution associated with the adjustment transaction.