RA_RECUR_INTERIM
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.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CUSTOMER_TRX_ID | NUMBER | 18 | 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 | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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 | Not currently used. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| DOC_SEQUENCE_VALUE | NUMBER | 18 | The value of the document sequence | ||
| NEW_CUSTOMER_TRX_ID | NUMBER | 18 | Unique identifier of the new recurred invoice | ||
| BILLING_DATE | DATE | Billing date for balance forward transactions |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| RA_RECUR_INTERIM | ra_customer_trx_all | CUSTOMER_TRX_ID |
| RA_RECUR_INTERIM | ra_customer_trx_all | NEW_CUSTOMER_TRX_ID |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| RA_RECUR_INTERIM_N1 | Non Unique | TRX_NUMBER |