FUN_ADM_OUTPUT_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: fun_adm_output_gt
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| APPLICATION_ID | NUMBER | 18 | Yes | Key Column: Application Identifier of the transaction. | |
| TRX_ID | NUMBER | 18 | Yes | Key Column: Primary transaction identifier. | |
| TRX_LINE_ID | NUMBER | 18 | Key Column: Transaction line identifier. | ||
| LEVEL_CODE | VARCHAR2 | 30 | Key Column: Column to record the level at which the transaction line identifier is stored. Possible values are HEADER and LINE. | ||
| PROGRAM_ID | NUMBER | 18 | Request identifier for set of transactions for defaulting rules processing. | ||
| STATUS_CODE | VARCHAR2 | 1 | Status Identifier to indicate if the defaulting rules applied successfully for the transaction row. | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| LEDGER_ID | NUMBER | 18 | Enterprise Attribute: Ledger identifying column. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Enterprise Attribute: Legal entity identifier for the transaction. | ||
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Unique book identification name. | ||
| DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | Tax Attribute: Default taxation country code. | ||
| FIRST_PTY_REG_ID | NUMBER | 18 | First Party Tax Registration ID for the transaction. | ||
| THIRD_PTY_REG_ID | NUMBER | 18 | Third Party Tax Registration ID for the transaction. | ||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | 240 | User defined fiscal classification. | ||
| FINAL_DISCHARGE_LOCATION_ID | NUMBER | 18 | Final destination location identifier for the purchases made by the customer. | ||
| AWARD_ID | NUMBER | 18 | Project Attribute: the award ID is used with data in project columns to track grant information | ||
| EXPENDITURE_TYPE | VARCHAR2 | 30 | Project Attribute: Project expenditure type. | ||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Project Attribute: Project expenditure type identifier. | ||
| PROJECT_ID | NUMBER | 18 | Project Attribute: Project identifier. | ||
| TASK_ID | NUMBER | 18 | Project Attribute: Task identifier for project related lines. | ||
| VENDOR_ID | NUMBER | 18 | Payables invoice supplier identifier. | ||
| VENDOR_SITE_ID | NUMBER | 18 | Physical location of the supplier. | ||
| PARTY_ID | NUMBER | 18 | An entity that can enter into business relationships with other entities and that submits invoices or other requests for payment. In some cases, goods or services or both are provided in return for payment. | ||
| PARTY_SITE_ID | NUMBER | 18 | Unique identity of the party site. | ||
| NUMBER1 | NUMBER | Extended Attribute: Placeholder for numeric attribute. | |||
| NUMBER2 | NUMBER | Extended Attribute: Placeholder for numeric attribute. | |||
| NUMBER3 | NUMBER | Extended Attribute: Placeholder for numeric attribute. | |||
| NUMBER4 | NUMBER | Extended Attribute: Placeholder for numeric attribute. | |||
| NUMBER5 | NUMBER | Extended Attribute: Placeholder for numeric attribute. | |||
| CHAR1 | VARCHAR2 | 150 | Extended Attribute: Placeholder for character attribute. | ||
| CHAR2 | VARCHAR2 | 150 | Extended Attribute: Placeholder for character attribute. | ||
| CHAR3 | VARCHAR2 | 150 | Extended Attribute: Placeholder for character attribute. | ||
| CHAR4 | VARCHAR2 | 150 | Extended Attribute: Placeholder for character attribute. | ||
| CHAR5 | VARCHAR2 | 150 | Extended Attribute: Placeholder for character attribute. | ||
| DATE1 | DATE | Extended Attribute: Placeholder for date attribute. | |||
| DATE2 | DATE | Extended Attribute: Placeholder for date attribute. | |||
| DATE3 | DATE | Extended Attribute: Placeholder for date attribute. | |||
| DATE4 | DATE | Extended Attribute: Placeholder for date attribute. | |||
| DATE5 | DATE | Extended Attribute: Placeholder for date attribute. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| FUN_ADM_OUTPUT_GT_N1 | Non Unique | PROGRAM_ID |