[Home] [Help] [Dependency Information]
Object Name: | JAI_AR_TRX_UPDATE_T |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_AR_TRX_UPDATE_T |
Subobject Name: | |
Status: | VALID |
Data is temporarily stored in this table after update on Standard Orders and Invoices in OE and AR respectively so as to facilitate the querying of the record in the localized form.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_AR_TRX_UPDATE_T_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRX_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_ID | NUMBER | Customer transaction identifier of the invoices created in AR transactions screen (Manual AR invoice) | ||
MODIFIED_FLAG | VARCHAR2 | (1) | Indicates whether this invoice is modified. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT TRX_ID
, MODIFIED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM JA.JAI_AR_TRX_UPDATE_T;
JA.JAI_AR_TRX_UPDATE_T does not reference any database object
JA.JAI_AR_TRX_UPDATE_T is referenced by following:
|
|
|