[Home] [Help] [Dependency Information]
Object Name: | RA_RECUR_INTERIM |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.RA_RECUR_INTERIM |
Subobject Name: | |
Status: | VALID |
The RA_RECUR_INTERIM table temporarily holds invoices that Oracle Receivables will copy in the future. Receivables deletes these records after the records are successfully loaded into permanent Receivables invoice tables. For example, if you create a recurring invoice for $1200 over 12 months, Receivables temporarily holds the invoice that you created for January in this table until the identical invoices are generated.
.
The primary keys for this table are CUSTOMER_TRX_ID and TRX_NUMBER.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RA_RECUR_INTERIM_N1 | NORMAL | NONUNIQUE | APPS_TS_NOLOGGING | TRX_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Unique identifier of the original invoice from which to recur invoices |
TRX_NUMBER | VARCHAR2 | (20) | Yes | The transaction number of the newly recurred invoices |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
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). | |
TRX_DATE | DATE | Yes | The transaction date of the newly recurred invoice | |
TERM_DUE_DATE | DATE | The due date of the first installment of the newly recurred invoice | ||
GL_DATE | DATE | The General Ledger date of the newly recurred invoice | ||
TERM_DISCOUNT_DATE | DATE | No longer used | ||
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). | |
DOC_SEQUENCE_VALUE | NUMBER | (15) | The value of the document sequence | |
NEW_CUSTOMER_TRX_ID | NUMBER | (15) | Unique identifier of the new recurred invoice | |
BILLING_DATE | DATE | Billing date for balance forward transactions |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_TRX_ID
, TRX_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, TRX_DATE
, TERM_DUE_DATE
, GL_DATE
, TERM_DISCOUNT_DATE
, REQUEST_ID
, DOC_SEQUENCE_VALUE
, NEW_CUSTOMER_TRX_ID
, BILLING_DATE
FROM AR.RA_RECUR_INTERIM;
AR.RA_RECUR_INTERIM does not reference any database object
AR.RA_RECUR_INTERIM is referenced by following:
|
|
|