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

TABLE: AR.AR_ADJUSTMENTS_REP_ITF

Object Details
Object Name: AR_ADJUSTMENTS_REP_ITF
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_ADJUSTMENTS_REP_ITF
Subobject Name:
Status: VALID


The AR_ADJUSTMENTS_REP_ITF table stores invoice adjustment information that Report eXchange Designer (RXi) reports use. For example, when you run the Adjustment Register, an RXi report which lets you specify report content and layout, information from this table is printed.


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_ADJUSTMENTS_REP_ITF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_NOLOGGING ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_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.
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).
ORGANIZATION_NAME VARCHAR2 (50)
Set of Books name
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
Functional currency code
POSTABLE VARCHAR2 (15)
Postable
ADJ_CURRENCY_CODE VARCHAR2 (15)
Adjustment currency code
CONS VARCHAR2 (15)
Cons
SORTBY VARCHAR2 (30)
Sort by
ADJ_TYPE VARCHAR2 (30)
Adjustment type
TRX_NUMBER VARCHAR2 (36)
Transaction number
DUE_DATE DATE

Adjustment due date
GL_DATE DATE

General Ledger date
ADJ_NUMBER VARCHAR2 (20)
Adjustment number
ADJ_CLASS VARCHAR2 (30)
Adjustment class
ADJ_TYPE_CODE VARCHAR2 (30)
Adjustment code
ADJ_TYPE_MEANING VARCHAR2 (30)
Adjustment type meaning
CUSTOMER_NAME VARCHAR2 (50)
Customer name
CUSTOMER_NUMBER VARCHAR2 (30)
Customer number
TRX_DATE DATE

Invoice date
ACCTD_ADJ_AMOUNT NUMBER

Adjustment amount in functional currency
DOC_SEQUENCE_NAME VARCHAR2 (30)
Document sequence name
DOC_SEQUENCE_VALUE NUMBER

Document sequence number
CUSTOMER_ID NUMBER (15)
Customer identifier
ADJ_NAME VARCHAR2 (30)
Adjustment name
D_OR_I VARCHAR2 (6)
Deposit or invoice
ADJ_AMOUNT NUMBER

Adjustment amount
DEBIT_ACCOUNT VARCHAR2 (240)
Debit account
DEBIT_ACCOUNT_DESC VARCHAR2 (240)
Debit account description
DEBIT_BALANCING VARCHAR2 (240)
Debit balancing
DEBIT_BALANCING_DESC VARCHAR2 (240)
Debit balancing description
DEBIT_NATACCT VARCHAR2 (240)
Natural debit account
DEBIT_NATACCT_DESC VARCHAR2 (240)
Natural debit account description
ACCOUNT_CODE_COMBINATION_ID NUMBER (15)
Account code combination identifier
Query Text

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


SELECT REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_NAME
,      FUNCTIONAL_CURRENCY_CODE
,      POSTABLE
,      ADJ_CURRENCY_CODE
,      CONS
,      SORTBY
,      ADJ_TYPE
,      TRX_NUMBER
,      DUE_DATE
,      GL_DATE
,      ADJ_NUMBER
,      ADJ_CLASS
,      ADJ_TYPE_CODE
,      ADJ_TYPE_MEANING
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      TRX_DATE
,      ACCTD_ADJ_AMOUNT
,      DOC_SEQUENCE_NAME
,      DOC_SEQUENCE_VALUE
,      CUSTOMER_ID
,      ADJ_NAME
,      D_OR_I
,      ADJ_AMOUNT
,      DEBIT_ACCOUNT
,      DEBIT_ACCOUNT_DESC
,      DEBIT_BALANCING
,      DEBIT_BALANCING_DESC
,      DEBIT_NATACCT
,      DEBIT_NATACCT_DESC
,      ACCOUNT_CODE_COMBINATION_ID
FROM AR.AR_ADJUSTMENTS_REP_ITF;

Dependencies

[top of page]

AR.AR_ADJUSTMENTS_REP_ITF does not reference any database object

AR.AR_ADJUSTMENTS_REP_ITF is referenced by following:

SchemaAR
ViewAR_ADJUSTMENTS_REP_ITF#