[Home] [Help] [Dependency Information]
Object Name: | AX_SETUP_SUBLEDGERS |
---|---|
Object Type: | TABLE |
Owner: | AX |
FND Design Data: | AX.AX_SETUP_SUBLEDGERS |
Subobject Name: | |
Status: | VALID |
This table stores the subledger dependent parameters. It contains a
row for each subledger (application and Main set of books).
The following columns are populated only if the application is Oracle
Inventory:
- IPV_AUTOMATIC_PROCESSING
- PPV_AUTOMATIC_PROCESSING
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AX_SETUP_SUBLEDGERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
MAIN_SET_OF_BOOKS_ID |
Table | |
Foreign Table | Foreign Key Column | AX_SETUP_SUBLEDGERS | AX_SETUP_BOOKS | AX_SETUP_SUBLEDGERS MAIN_SET_OF_BOOKS_ID | AX_SETUP_POSTING_BOOKS | AX_SETUP_SUBLEDGERS |
AX_SETUP_POSTING_BOOKS
APPLICATION_ID
AX_SETUP_POSTING_BOOKS MAIN_SET_OF_BOOKS_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | Yes | Application identifier | |
MAIN_SET_OF_BOOKS_ID | NUMBER | Yes | Main set of books 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 | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
TRANSLATE_EVENTS | VARCHAR2 | (1) | Yes | Default for Submit Posting Manager form |
SECURE_POSTING | VARCHAR2 | (1) | Yes | Secure Posting Manager parameters |
IPV_AUTOMATIC_PROCESSING | VARCHAR2 | (1) | Automatic processing for IPV | |
PPV_AUTOMATIC_PROCESSING | VARCHAR2 | (1) | Automatic processing for PPV | |
PERIOD_FROM | NUMBER | Starting Period | ||
PERIOD_TO | NUMBER | End Period | ||
REFERENCE_1 | VARCHAR2 | (240) | Reserved for future use | |
REFERENCE_2 | VARCHAR2 | (240) | Reserved for future use | |
REFERENCE_3 | VARCHAR2 | (240) | Reserved for future use | |
REFERENCE_4 | VARCHAR2 | (240) | Reserved for future use | |
REFERENCE_5 | VARCHAR2 | (240) | Reserved for future use | |
INTER_COMPANY_BALANCING_FLAG | VARCHAR2 | (1) | Execute InterCompany Balancing |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, MAIN_SET_OF_BOOKS_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TRANSLATE_EVENTS
, SECURE_POSTING
, IPV_AUTOMATIC_PROCESSING
, PPV_AUTOMATIC_PROCESSING
, PERIOD_FROM
, PERIOD_TO
, REFERENCE_1
, REFERENCE_2
, REFERENCE_3
, REFERENCE_4
, REFERENCE_5
, INTER_COMPANY_BALANCING_FLAG
FROM AX.AX_SETUP_SUBLEDGERS;
AX.AX_SETUP_SUBLEDGERS does not reference any database object
AX.AX_SETUP_SUBLEDGERS is referenced by following:
|
|
|