INV_GENERIC_DISPOSITIONS
INV_GENERIC_DISPOSITIONS stores the user- defined account alias. Account alias provides an easy way to use accounting numbers, and makes it easier to transact account issues and receipts. Note that this is different from Application Object Library's shorthand alias, because account aliases have their own database entity which is used as a distinct transaction source type apart from accounts during transactions.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_GENRC_DISPOSITIONS_PK |
DISPOSITION_ID, ORGANIZATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| DISPOSITION_ID | NUMBER | 18 | Yes | This identifies an account alias. | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory organization. | ||
| STRUCTURE_INSTANCE_NUMBER | NUMBER | 18 | Structure instance number of the locator key field. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| DESCRIPTION | VARCHAR2 | 50 | This is the description of the user-defined account alias. | |||
| DISABLE_DATE | DATE | Date this account alias is disabled. | ||||
| ENABLE_DATE | DATE | Yes | Date when the account alias becomes enabled. | |||
| DISTRIBUTION_ACCOUNT | NUMBER | 18 | Yes | This is the distribution account number. | ||
| SEGMENT1 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT2 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT3 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT4 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT5 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT6 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT7 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT8 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT9 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT10 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT11 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT12 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT13 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT14 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT15 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT16 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT17 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT18 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT19 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SEGMENT20 | VARCHAR2 | 40 | Key Flexfield: segment of the key flexfield. | |||
| SUMMARY_FLAG | VARCHAR2 | 1 | Yes | Flag indicating whether segment combination includes a summary segment | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Flag indicating whether segment combination is enabled | ||
| START_DATE_ACTIVE | DATE | Date segment combination becomes active | ||||
| END_DATE_ACTIVE | DATE | Date segment combination becomes inactive | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Account aliases (INV_GENERIC_DISPOSITIONS) | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_GENERIC_DISPOSITIONS | gl_code_combinations | DISTRIBUTION_ACCOUNT |
| INV_GENERIC_DISPOSITIONS | inv_org_parameters | ORGANIZATION_ID |
| inv_material_txns_temp | inv_generic_dispositions | TRANSACTION_SOURCE_TYPE_ID, ORGANIZATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_GENERIC_DISPOSITIONS_U1 | Unique | Default | DISPOSITION_ID, ORGANIZATION_ID |
| INV_GENRC_DISPOSITIONS_N2 | Non Unique | Default | SEGMENT1 |
| INV_GENRC_DISPOSITIONS_N3 | Non Unique | Default | SEGMENT2 |
| INV_GENRC_DISPOSITIONS_N4 | Non Unique | Default | SEGMENT3 |
| INV_GENRC_DISPOSITIONS_N5 | Non Unique | Default | SEGMENT4 |