AR_ADJUSTMENTS_ALL
The AR_ADJUSTMENT_ALL table stores information about your invoice adjustments. Each row includes general information about the adjustment that you make, such as activity name, amount, accounting information, reason, and type of adjustment. You need one row for each adjustment that you make to an invoice. . Oracle Receivables uses the information in the AR_ADJUSTMENT_ALL table to update the AMOUNT_ADJUSTED and AMOUNT_DUE_REMAINING columns in the AR_PAYMENT_SCHEDULES_ALL table. . If you create an adjustment through the Receipts window, the ASSOCIATED_CASH_RECEIPT_ID column in the AR_PAYMENT_SCHEDULES_ALL table stores the cash receipt ID of the receipt that you entered when you created the adjustment to your invoice, debit memo, or chargeback. . The primary key for this table is ADJUSTMENT_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_ADJUSTMENTS_PK |
ADJUSTMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| ADJUSTMENT_ID | NUMBER | 18 | Yes | Adjustment identifier | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| AMOUNT | NUMBER | Yes | Adjustment amount | |||
| APPLY_DATE | DATE | Date adjustment applied to payment | ||||
| GL_DATE | DATE | Yes | Accounting date. | |||
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | General Ledger Set of Books used, only one currently supported | ||
| CODE_COMBINATION_ID | NUMBER | 18 | General Ledger account code combination | |||
| TYPE | VARCHAR2 | 15 | Yes | Lookup code for adjustment type in AR_LOOKUPS | ||
| ADJUSTMENT_TYPE | VARCHAR2 | 3 | Yes | Lookup code for adjustment creation type. Values exist in AR_LOOKUPS and are CHARGES, FREIGHT, INVOICE, LINE and TAX. | ||
| STATUS | VARCHAR2 | 30 | Yes | Approval status, A for approve, U for unaccrued adjustments, R for rejected, and any other code for unapproved | ||
| LINE_ADJUSTED | NUMBER | Line amount adjusted as part of this adjustment | ||||
| LINE_NONRECOVERABLE | NUMBER | Nonrecoverable adjustment of transaction line amount | ||||
| FREIGHT_ADJUSTED | NUMBER | Freight amount adjusted as part of this adjustment | ||||
| TAX_ADJUSTED | NUMBER | Tax amount adjusted as part of this adjustment | ||||
| TAX_NONRECOVERABLE | NUMBER | Nonrecoverable adjustment of transaction tax amount | ||||
| RECEIVABLES_CHARGES_ADJUSTED | NUMBER | Charges adjusted as part of this adjustment | ||||
| ASSOCIATED_CASH_RECEIPT_ID | NUMBER | 18 | Identifier of cash receipt associated with this adjustment | |||
| CHARGEBACK_CUSTOMER_TRX_ID | NUMBER | 18 | Identifier of chargeback transaction associated with this adjustment | |||
| BATCH_ID | NUMBER | 18 | Identifier of batch associated with this adjustment | |||
| CUSTOMER_TRX_ID | NUMBER | 18 | Identifier of customer transaction associated with this adjustment | |||
| CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Identifier of customer transaction line associated with this adjustment | |||
| SUBSEQUENT_TRX_ID | NUMBER | 18 | CUSTOMER_TRX_ID of the invoice against the guarantee | |||
| PAYMENT_SCHEDULE_ID | NUMBER | 18 | Identifier of payment schedule associated with this adjustment | |||
| RECEIVABLES_TRX_ID | NUMBER | 18 | Identifier of receivables transaction associated with this adjustment | |||
| DISTRIBUTION_SET_ID | NUMBER | 18 | Identifier of distribution set associated with this adjustment | |||
| GL_POSTED_DATE | DATE | Date adjustment posted to General Ledger | ||||
| COMMENTS | VARCHAR2 | 2000 | User-entered comments about the adjustment. | |||
| AUTOMATICALLY_GENERATED | VARCHAR2 | 1 | Not currently used. | |||
| CREATED_FROM | VARCHAR2 | 30 | Yes | Form or concurrent program name that this adjustment was created from | ||
| REASON_CODE | VARCHAR2 | 30 | Identifier of reason for this adjustment | |||
| POSTABLE | VARCHAR2 | 1 | Y or null indicates whether this adjustment is postable or not. | |||
| APPROVED_BY | VARCHAR2 | 64 | Identifier of user approving the adjustment | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| POSTING_CONTROL_ID | NUMBER | 18 | Yes | Receivables posting batch identifier, -1, -2, and -4 for posted in previous releases and -3 for not posted | ||
| ACCTD_AMOUNT | NUMBER | Yes | Accounted amount in ledger currency. | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Adjustments (AR_ADJUSTMENTS) | ||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |||
| PROGRAM_ID | NUMBER | 18 | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| ADJUSTMENT_NUMBER | VARCHAR2 | 20 | Yes | Adjustment number automatically generated from AR_ADJUSTMENT_NUMBER_S | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Value for the USSGL Transaction Code Flexfield | Government Adjustments (AR_ADJUSTMENTS_GOV) | ||
| USSGL_TRANSACTION_CODE_CONTEXT | VARCHAR2 | 30 | Context value for the USSGL Transaction Code Flexfield | Government Adjustments (AR_ADJUSTMENTS_GOV) | ||
| DOC_SEQUENCE_VALUE | NUMBER | 18 | Document sequence number | |||
| DOC_SEQUENCE_ID | NUMBER | 18 | Document sequence identifier | |||
| ASSOCIATED_APPLICATION_ID | NUMBER | 18 | Identifier of the receipt application associated with this adjustment | |||
| CONS_INV_ID | NUMBER | 18 | Consolidated invoice number on which this transaction appeared | |||
| MRC_GL_POSTED_DATE | VARCHAR2 | 2000 | Not currently used. | |||
| MRC_POSTING_CONTROL_ID | VARCHAR2 | 2000 | Not currently used. | |||
| MRC_ACCTD_AMOUNT | VARCHAR2 | 2000 | Not currently used. | |||
| ADJ_TAX_ACCT_RULE | VARCHAR2 | 3 | Numeric code that identifies the tax accounting rule used to create the accounting | |||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| LINK_TO_TRX_HIST_ID | NUMBER | 18 | Transaction history record identifier, associated with movement of deferred tax due to maturity date event or subsequent reversal event | |||
| EVENT_ID | NUMBER | 18 | Subledger accounting event identifier. | |||
| UPGRADE_METHOD | VARCHAR2 | 30 | Upgrade flag to indicate the origin of the adjustments. | |||
| AX_ACCOUNTED_FLAG | VARCHAR2 | 1 | Upgrade flag to indicate the distributions have been upgraded by AX | |||
| INTEREST_HEADER_ID | NUMBER | 18 | Foreign key for late charge adjustment. | |||
| INTEREST_LINE_ID | NUMBER | 18 | Foreign key for late charge adjustment. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_ADJUSTMENTS_ALL | ra_customer_trx_all | SUBSEQUENT_TRX_ID |
| AR_ADJUSTMENTS_ALL | ar_cash_receipts_all | ASSOCIATED_CASH_RECEIPT_ID |
| AR_ADJUSTMENTS_ALL | ar_receivable_applications_all | ASSOCIATED_APPLICATION_ID |
| AR_ADJUSTMENTS_ALL | ar_interest_headers_all | INTEREST_HEADER_ID |
| AR_ADJUSTMENTS_ALL | ar_interest_lines_all | INTEREST_LINE_ID |
| AR_ADJUSTMENTS_ALL | ra_customer_trx_all | CHARGEBACK_CUSTOMER_TRX_ID |
| AR_ADJUSTMENTS_ALL | gl_code_combinations | CODE_COMBINATION_ID |
| AR_ADJUSTMENTS_ALL | ar_cons_inv_all | CONS_INV_ID |
| AR_ADJUSTMENTS_ALL | xla_events | EVENT_ID, PROGRAM_APPLICATION_ID |
| AR_ADJUSTMENTS_ALL | ar_batches_all | BATCH_ID |
| AR_ADJUSTMENTS_ALL | ra_customer_trx_all | CUSTOMER_TRX_ID |
| AR_ADJUSTMENTS_ALL | ra_customer_trx_lines_all | CUSTOMER_TRX_LINE_ID |
| AR_ADJUSTMENTS_ALL | ar_distribution_sets_all | DISTRIBUTION_SET_ID |
| AR_ADJUSTMENTS_ALL | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| AR_ADJUSTMENTS_ALL | ar_receivables_trx_all | RECEIVABLES_TRX_ID, ORG_ID |
| iex_prd_appl_xref | ar_adjustments_all | ADJUSTMENT_ID |
| ar_approval_action_history | ar_adjustments_all | ADJUSTMENT_ID |
| ar_statement_line_clusters | ar_adjustments_all | ADJUSTMENT_ID |
| ar_payment_schedules_all | ar_adjustments_all | ADJUSTMENT_ID_LAST |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_ADJUSTMENTS_N10 | Non Unique | Default | CUSTOMER_TRX_LINE_ID |
| AR_ADJUSTMENTS_N11 | Non Unique | Default | CHARGEBACK_CUSTOMER_TRX_ID |
| AR_ADJUSTMENTS_N13 | Non Unique | Default | POSTING_CONTROL_ID, GL_DATE |
| AR_ADJUSTMENTS_N14 | Non Unique | Default | LAST_UPDATED_BY |
| AR_ADJUSTMENTS_N15 | Non Unique | Default | SUBSEQUENT_TRX_ID |
| AR_ADJUSTMENTS_N16 | Non Unique | Default | REQUEST_ID |
| AR_ADJUSTMENTS_N17 | Non Unique | Default | EVENT_ID |
| AR_ADJUSTMENTS_N18 | Non Unique | Default | STATUS |
| AR_ADJUSTMENTS_N2 | Non Unique | Default | CUSTOMER_TRX_ID |
| AR_ADJUSTMENTS_N3 | Non Unique | Default | PAYMENT_SCHEDULE_ID |
| AR_ADJUSTMENTS_N4 | Non Unique | Default | RECEIVABLES_TRX_ID |
| AR_ADJUSTMENTS_N5 | Non Unique | Default | APPLY_DATE |
| AR_ADJUSTMENTS_N6 | Non Unique | Default | GL_DATE |
| AR_ADJUSTMENTS_N7 | Non Unique | Default | CREATION_DATE |
| AR_ADJUSTMENTS_N8 | Non Unique | Default | CREATED_BY |
| AR_ADJUSTMENTS_N9 | Non Unique | Default | ASSOCIATED_CASH_RECEIPT_ID |
| AR_ADJUSTMENTS_U1 | Unique | Default | ADJUSTMENT_ID |
| AR_ADJUSTMENTS_U2 | Unique | Default | ADJUSTMENT_NUMBER, ORG_ID |