eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.AR_ADJUSTMENTS_ALL

Object Details

Object Name:	AR_ADJUSTMENTS_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_ADJUSTMENTS_ALL
Subobject Name:
Status:	VALID

The AR_ADJUSTMENT_ALL table stores information about invoice adjustments. Each row includes general information about the adjustment, such as activity name, amount, accounting information, reason, and type of adjustment. One row is created for each adjustment that is made 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.
When an adjustment is created 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 is entered when the adjustment is created for invoice, debit memo, or chargeback.
The accounting code combinations stored in this table is meta data for creating accounting entries in Subledger Accounting. Receivables provides the code combinations stored in this table to Subledger Accounting as a source for accounting attributes for deriving the accounting code combinations. Subledger Accounting generates the final accounting entries that are posted to General Ledger. The accounting code combination used in the final accounting entries can be same as that stored in AR_ADJUSTMENT_ALL table or can be different depending on the rules setup in Subledger Accounting. The XLA_AE_HEADERS and XLA_AE_LINES tables in Subledger Accounting stores the accounting entries posted to General Ledger. The EVENT_ID column serves as link between AR_ADJUSTMENT_ALL and the XLA_AE_HEADERS tables.
The primary key for this table is ADJUSTMENT_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_ADJUSTMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADJUSTMENT_ID
AR_ADJUSTMENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADJUSTMENT_NUMBER ORG_ID
AR_ADJUSTMENTS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_LINE_ID
AR_ADJUSTMENTS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHARGEBACK_CUSTOMER_TRX_ID
AR_ADJUSTMENTS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSTING_CONTROL_ID GL_DATE
AR_ADJUSTMENTS_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATED_BY
AR_ADJUSTMENTS_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUBSEQUENT_TRX_ID
AR_ADJUSTMENTS_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
AR_ADJUSTMENTS_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_ID
AR_ADJUSTMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_ID
AR_ADJUSTMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_ID
AR_ADJUSTMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIVABLES_TRX_ID
AR_ADJUSTMENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLY_DATE
AR_ADJUSTMENTS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_DATE
AR_ADJUSTMENTS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
AR_ADJUSTMENTS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATED_BY
AR_ADJUSTMENTS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSOCIATED_CASH_RECEIPT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ADJUSTMENT_ID	NUMBER	(15)	Yes	Adjustment identifier and primary key for this table.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column. User who last updated this row.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column. Date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column. Operating system login of user who last updated this row
CREATED_BY	NUMBER	(15)	Yes	Standard who column. User who created this row.
CREATION_DATE	DATE		Yes	Standard who column. Date when this row was created.
AMOUNT	NUMBER		Yes	Adjustment amount
APPLY_DATE	DATE			Date adjustment is performed
GL_DATE	DATE		Yes	General Ledger accounting date for the adjustment
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Identifier of the Ledger to which the accounting entries for this adjustment will be posted
CODE_COMBINATION_ID	NUMBER	(15)		General Ledger account code combination
TYPE	VARCHAR2	(15)	Yes	Lookup code for adjustment type in AR_LOOKUPS
ADJUSTMENT_TYPE	VARCHAR2	(3)	Yes	Type of adjustment. Available types are CHARGES, FREIGHT, INVOICE, LINE and TAX.
STATUS	VARCHAR2	(30)	Yes	Approval status, A for approve, U for unapproved adjustment, R for rejected, and any other code for unapproved
LINE_ADJUSTED	NUMBER			Line amount adjusted as part of this adjustment
FREIGHT_ADJUSTED	NUMBER			Freight amount adjusted as part of this adjustment
TAX_ADJUSTED	NUMBER			Tax amount adjusted as part of this adjustment
RECEIVABLES_CHARGES_ADJUSTED	NUMBER			Charges adjusted as part of this adjustment
ASSOCIATED_CASH_RECEIPT_ID	NUMBER	(15)		Identifier of cash receipt associated with this adjustment
CHARGEBACK_CUSTOMER_TRX_ID	NUMBER	(15)		Identifier of chargeback transaction associated with this adjustment
BATCH_ID	NUMBER	(15)		Identifier of transaction batch associated with this adjustment
CUSTOMER_TRX_ID	NUMBER	(15)		Identifier of customer transaction associated with this adjustment
CUSTOMER_TRX_LINE_ID	NUMBER	(15)		Identifier of customer transaction line associated with this adjustment
SUBSEQUENT_TRX_ID	NUMBER	(15)		Identifier of the invoice created against the guarantee that resulted in this adjustment
PAYMENT_SCHEDULE_ID	NUMBER	(15)		Identifier of payment schedule associated with this adjustment
RECEIVABLES_TRX_ID	NUMBER	(15)		Identifier of the receivable activity assigned to the adjustment
DISTRIBUTION_SET_ID	NUMBER	(15)		Identifier of distribution set associated with this adjustment
GL_POSTED_DATE	DATE			Date adjustment posted to General Ledger
COMMENTS	VARCHAR2	(2000)		Comments provided for the adjustment
AUTOMATICALLY_GENERATED	VARCHAR2	(1)		No longer in use
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	NUMBER	(15)		Identifier of user approving the adjustment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure context.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
POSTING_CONTROL_ID	NUMBER	(15)	Yes	Receivables posting batch identifier, -1, -2, and -4 for posted in previous releases and -3 for not posted. Stores the identifier of the concurrent request for posted records.
ACCTD_AMOUNT	NUMBER		Yes	Adjustment amount in functional currency
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent program who column. Application identifier of the program that last updated this row.
PROGRAM_ID	NUMBER	(15)		Concurrent program who column. Identifier of the program that last updated this row
PROGRAM_UPDATE_DATE	DATE			Concurrent program who column. Date when a program last updated this row
REQUEST_ID	NUMBER	(15)		Concurrent program who column. Identifier of the concurrent request that last updated this row.
ADJUSTMENT_NUMBER	VARCHAR2	(20)	Yes	Adjustment number automatically generated from AR_ADJUSTMENT_NUMBER_S
ORG_ID	NUMBER	(15)		Organization identifier
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Value for the USSGL Transaction Code Flexfield
USSGL_TRANSACTION_CODE_CONTEXT	VARCHAR2	(30)		Context value for the USSGL Transaction Code Flexfield
DOC_SEQUENCE_VALUE	NUMBER	(15)		Document sequence number
DOC_SEQUENCE_ID	NUMBER	(15)		Document sequence identifier
ASSOCIATED_APPLICATION_ID	NUMBER	(15)		Identifier of the receipt application associated with this adjustment
CONS_INV_ID	NUMBER	(15)		Consolidated invoice number on which this transaction appeared
MRC_GL_POSTED_DATE	VARCHAR2	(2000)		No longer in use
MRC_POSTING_CONTROL_ID	VARCHAR2	(2000)		No longer in use
MRC_ACCTD_AMOUNT	VARCHAR2	(2000)		No longer in use
ADJ_TAX_ACCT_RULE	VARCHAR2	(3)		Numeric code that identifies the tax accounting rule used to create the accounting
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
LINK_TO_TRX_HIST_ID	NUMBER	(15)		Transaction history record identifier, associated with movement of deferred tax due to maturity date event or subsequent reversal event
EVENT_ID	NUMBER	(15)		Identifier of the accounting event created in Subledger Accounting
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	(15)		Internal identifier of the late charge transaction header. Applicable only for late charge adjustments
INTEREST_LINE_ID	NUMBER	(15)		Internal identifier of the late charge transaction line. Applicable only for late charge adjustments.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ADJUSTMENT_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      AMOUNT
,      APPLY_DATE
,      GL_DATE
,      SET_OF_BOOKS_ID
,      CODE_COMBINATION_ID
,      TYPE
,      ADJUSTMENT_TYPE
,      STATUS
,      LINE_ADJUSTED
,      FREIGHT_ADJUSTED
,      TAX_ADJUSTED
,      RECEIVABLES_CHARGES_ADJUSTED
,      ASSOCIATED_CASH_RECEIPT_ID
,      CHARGEBACK_CUSTOMER_TRX_ID
,      BATCH_ID
,      CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      SUBSEQUENT_TRX_ID
,      PAYMENT_SCHEDULE_ID
,      RECEIVABLES_TRX_ID
,      DISTRIBUTION_SET_ID
,      GL_POSTED_DATE
,      COMMENTS
,      AUTOMATICALLY_GENERATED
,      CREATED_FROM
,      REASON_CODE
,      POSTABLE
,      APPROVED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      POSTING_CONTROL_ID
,      ACCTD_AMOUNT
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ADJUSTMENT_NUMBER
,      ORG_ID
,      USSGL_TRANSACTION_CODE
,      USSGL_TRANSACTION_CODE_CONTEXT
,      DOC_SEQUENCE_VALUE
,      DOC_SEQUENCE_ID
,      ASSOCIATED_APPLICATION_ID
,      CONS_INV_ID
,      MRC_GL_POSTED_DATE
,      MRC_POSTING_CONTROL_ID
,      MRC_ACCTD_AMOUNT
,      ADJ_TAX_ACCT_RULE
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      LINK_TO_TRX_HIST_ID
,      EVENT_ID
,      UPGRADE_METHOD
,      AX_ACCOUNTED_FLAG
,      INTEREST_HEADER_ID
,      INTEREST_LINE_ID
FROM AR.AR_ADJUSTMENTS_ALL;

Dependencies

[top of page]

AR.AR_ADJUSTMENTS_ALL does not reference any database object

AR.AR_ADJUSTMENTS_ALL is referenced by following:

APPS: AR_ADJUSTMENTS; AR_ADJUSTMENTS_ALL; JL_BR_AR_OCC_DOCS_WRT_N_ABTMT2