[Home] [Help] [Dependency Information]
Object Name: | XTR_SETTLEMENT_SCRIPTS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_SETTLEMENT_SCRIPTS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUTHORISED | VARCHAR2 | (1) | Yes | Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised). |
COMMENTS | VARCHAR2 | (50) | Additional note. | |
COMPANY_CODE | VARCHAR2 | (7) | Company identifier. Foreign key to XTR_PARTIES_V. | |
CURRENCY_CODE | VARCHAR2 | (15) | ||
EFT_SCRIPT_OUTPUT_PATH | VARCHAR2 | (50) | ||
LAST_FILE_CREATED | VARCHAR2 | (70) | ||
LAST_RUN_BY | VARCHAR2 | (10) | ||
LAST_RUN_ON | DATE | |||
ONLY_NEW_TRANSACTIONS | VARCHAR2 | (1) | ||
PACKAGE_NAME | VARCHAR2 | (20) | ||
RUN_REQUESTED_ON | DATE | |||
SCRIPT_NAME | VARCHAR2 | (8) | Yes | |
SCRIPT_TYPE | VARCHAR2 | (10) | Yes | |
TRANSMISSION_CODE | VARCHAR2 | (100) | No longer used in R12 | |
IBY_TRANSMIT_CONFIGURATION_ID | NUMBER | (15) | Transmit Configuration Id |
Cut, paste (and edit) the following text to query this object:
SELECT AUTHORISED
, COMMENTS
, COMPANY_CODE
, CURRENCY_CODE
, EFT_SCRIPT_OUTPUT_PATH
, LAST_FILE_CREATED
, LAST_RUN_BY
, LAST_RUN_ON
, ONLY_NEW_TRANSACTIONS
, PACKAGE_NAME
, RUN_REQUESTED_ON
, SCRIPT_NAME
, SCRIPT_TYPE
, TRANSMISSION_CODE
, IBY_TRANSMIT_CONFIGURATION_ID
FROM XTR.XTR_SETTLEMENT_SCRIPTS;
XTR.XTR_SETTLEMENT_SCRIPTS does not reference any database object
XTR.XTR_SETTLEMENT_SCRIPTS is referenced by following:
|
|
|