[Home] [Help] [Dependency Information]
Object Name: | AX_THIRD_PARTY_MERGES |
---|---|
Object Type: | TABLE |
Owner: | AX |
Subobject Name: | |
Status: | VALID |
This table stores balance snapshot at the time of customer merge.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AX_THIRD_PARTY_MERGES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EVENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | Yes | Event identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Extended Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Extended Who column | ||
PROGRAM_ID | NUMBER | Extended Who column | ||
PROGRAM_UPDATE_DATE | DATE | Extended Who column | ||
SET_OF_BOOKS_ID | NUMBER | Yes | Set of books identifier | |
CODE_COMBINATION_ID | NUMBER | Yes | Code combination identifier | |
THIRD_PARTY_ID_FROM | NUMBER | Yes | Third party identifier | |
SUB_ID_FROM | NUMBER | Yes | Site use Id / Vendor site Id being merged from | |
THIRD_PARTY_ID_TO | NUMBER | Yes | Customer Id / Vendor Id being merged to | |
SUB_ID_TO | NUMBER | Yes | Site use Id / Vendor site Id being merged to | |
PERIOD_NAME | VARCHAR2 | (240) | Yes | Period name |
ACCOUNTED_DR | NUMBER | Debit amount to be transferred between the parties | ||
ACCOUNTED_CR | NUMBER | Credit amount to be transferred between the parties |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, THIRD_PARTY_ID_FROM
, SUB_ID_FROM
, THIRD_PARTY_ID_TO
, SUB_ID_TO
, PERIOD_NAME
, ACCOUNTED_DR
, ACCOUNTED_CR
FROM AX.AX_THIRD_PARTY_MERGES;
AX.AX_THIRD_PARTY_MERGES does not reference any database object
AX.AX_THIRD_PARTY_MERGES is referenced by following:
|
|
|