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 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.

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
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
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 (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
AMOUNT	NUMBER		Yes	Adjustment amount
APPLY_DATE	DATE			Date adjustment applied to payment
GL_DATE	DATE		Yes	General Ledger date
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	General Ledger Set of Books used, only one currently supported
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	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
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 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)		CUSTOMER_TRX_ID of the invoice against the guarantee
PAYMENT_SCHEDULE_ID	NUMBER	(15)		Identifier of payment schedule associated with this adjustment
RECEIVABLES_TRX_ID	NUMBER	(15)		Identifier of receivables transaction associated with this 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
AUTOMATICALLY_GENERATED	VARCHAR2	(1)		Y or N. No longer 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	NUMBER	(15)		Identifier of user approving the adjustment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
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
ACCTD_AMOUNT	NUMBER		Yes	Amount of journal entries
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 id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		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	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
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)		Concatenated string of reporting Set of Books identifier and posted date for reporting book or books. MRC only.
MRC_POSTING_CONTROL_ID	VARCHAR2	(2000)		Concatenated string of reporting Set of Books identifier and receivables posting batch identifier. MRC only.
MRC_ACCTD_AMOUNT	VARCHAR2	(2000)		Concatenated string of reporting Set of Books identifier and amount in reporting currency or currencies. MRC only.
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)		SLA event_id
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)		Fkey late charge
INTEREST_LINE_ID	NUMBER	(15)		Fkey late charge

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:

AR: AR_ADJUSTMENTS_ALL#