[Home] [Help] [Dependency Information]
Object Name: | IGI_EXP_DIAL_UNIT_DEF_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_EXP_DIAL_UNIT_DEF_ALL |
Subobject Name: | |
Status: | VALID |
IGI_EXP_DIAL_UNIT_DEF_ALL stores all information pertaining to dialog unit setup.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGI_EXP_DIAL_UNIT_DEF_ALL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | DIAL_UNIT_ID |
IGI_EXP_DIAL_UNIT_DEF_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DIAL_UNIT_NUM
DIAL_UNIT_NUM_TYPE DOC_TYPE_ID TRX_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIAL_UNIT_ID | NUMBER | Yes | Dialog unit identifier | |
DIAL_UNIT_NUM | VARCHAR2 | (30) | Yes | Dialog unit number |
TRX_TYPE_ID | NUMBER | Yes | Transaction type identifier | |
DOC_TYPE_ID | NUMBER | Yes | Document type identifier | |
THIRD_PARTY_ID | NUMBER | (30) | Yes | Single third party identifier |
DIAL_UNIT_NUM_TYPE | VARCHAR2 | (30) | Yes | Type of dialog unit number. Actual or Legal. |
ACT_NUMBER | VARCHAR2 | (30) | Yes | Actual number |
STATUS | VARCHAR2 | (30) | Yes | Status. Selected, Rejected, Put in transmission unit, Point of acceptance, Requisitioned or Transmitted. |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
ORG_ID | NUMBER | Organization identifier | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency code. Introduced to ensure that documents of differing currencies are not included in the same dialog unit. | |
SITE_ID | NUMBER | (30) | Site identifier | |
MRC_EXCHANGE_RATE_TYPE | VARCHAR2 | (2000) | Exchange rate type for a foreign currency invoice in Multi-Reporting Currencies (MRC) defined reporting currency | |
MRC_EXCHANGE_RATE | VARCHAR2 | (2000) | Exchange rate for a foreign currency invoice in Multi-Reporting Currencies (MRC) defined reporting currency | |
MRC_EXCHANGE_DATE | VARCHAR2 | (2000) | Date exchange rate is obtained from daily rates table in Multi-Reporting Currencies (MRC) defined reporting currency. | |
LEGAL_NUMBER | VARCHAR2 | (30) | Legal number | |
AMOUNT | NUMBER | Amount | ||
MRC_AMOUNT | VARCHAR2 | (2000) | Dialog unit amount in Multi-Reporting Currencies (MRC) defined reporting currency | |
MRC_AMOUNT_EXCHANGE_RATE_TYPE | VARCHAR2 | (2000) | Exchange rate type for a foreign currency invoice in Multi-Reporting Currencies (MRC) defined reporting currency | |
MRC_AMOUNT_EXCHANGE_DATE | VARCHAR2 | (2000) | Date exchange rate is obtained from daily rates table in Multi-Reporting Currencies (MRC) defined reporting currency | |
MRC_AMOUNT_EXCHANGE_RATE | VARCHAR2 | (2000) | Exchange rate for a foreign currency invoice in Multi-Reporting Currencies (MRC) defined reporting currency | |
DESCRIPTION | VARCHAR2 | (80) | User defined dialog unit description | |
TRANS_UNIT_ID | NUMBER | Transmission unit identifier | ||
DIAL_UNIT_SELECTED_FLAG | VARCHAR2 | (1) | Flag to indicate whether the dialog unit is selected for inclusion in a transmission unit | |
DIAL_UNIT_CALL_NUM | NUMBER | (15) | Dialog unit call number | |
MAIN_AUTHORIZER | VARCHAR2 | (25) | Authorizer of dialog unit | |
ACCOUNT_OFFICER | VARCHAR2 | (25) | Creator of dialog unit | |
PRINT_DATE | DATE | Print date | ||
REQ_REJECT | VARCHAR2 | (1) | Indicates who rejected a dialog unit. Values are N when rejected by an authorizer and Y when rejected by an accounts officer. | |
UPGRADE_STATUS | VARCHAR2 | (1) | This column has been added for tracking the migration status ofa Dialog Unit packet, which is not attached to a Transmission Unit, from old EXP to new EXP. A null value means the record is a candidate for migration, 0 means it has been migrated successfully across |
Cut, paste (and edit) the following text to query this object:
SELECT DIAL_UNIT_ID
, DIAL_UNIT_NUM
, TRX_TYPE_ID
, DOC_TYPE_ID
, THIRD_PARTY_ID
, DIAL_UNIT_NUM_TYPE
, ACT_NUMBER
, STATUS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, ORG_ID
, CURRENCY_CODE
, SITE_ID
, MRC_EXCHANGE_RATE_TYPE
, MRC_EXCHANGE_RATE
, MRC_EXCHANGE_DATE
, LEGAL_NUMBER
, AMOUNT
, MRC_AMOUNT
, MRC_AMOUNT_EXCHANGE_RATE_TYPE
, MRC_AMOUNT_EXCHANGE_DATE
, MRC_AMOUNT_EXCHANGE_RATE
, DESCRIPTION
, TRANS_UNIT_ID
, DIAL_UNIT_SELECTED_FLAG
, DIAL_UNIT_CALL_NUM
, MAIN_AUTHORIZER
, ACCOUNT_OFFICER
, PRINT_DATE
, REQ_REJECT
, UPGRADE_STATUS
FROM IGI.IGI_EXP_DIAL_UNIT_DEF_ALL;
IGI.IGI_EXP_DIAL_UNIT_DEF_ALL does not reference any database object
IGI.IGI_EXP_DIAL_UNIT_DEF_ALL is referenced by following:
|
|
|