AP_XCC_EXTRACT_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| DATA_SET_ID | NUMBER | DATA_SET_ID | ||
| SOURCE_HEADER_ID_1 | VARCHAR2 | 50 | SOURCE_HEADER_ID_1 | |
| SOURCE_HEADER_ID_2 | VARCHAR2 | 50 | SOURCE_HEADER_ID_2 | |
| TRANSACTION_NUMBER | VARCHAR2 | 50 | TRANSACTION_NUMBER | |
| SOURCE_LINE_ID_1 | VARCHAR2 | 50 | SOURCE_LINE_ID_1 | |
| SOURCE_LINE_ID_2 | VARCHAR2 | 50 | SOURCE_LINE_ID_2 | |
| SOURCE_LINE_ID_3 | VARCHAR2 | 50 | SOURCE_LINE_ID_3 | |
| SOURCE_LINE_ID_4 | VARCHAR2 | 50 | SOURCE_LINE_ID_4 | |
| SOURCE_LINE_ID_5 | VARCHAR2 | 50 | SOURCE_LINE_ID_5 | |
| SOURCE_LINE_ID_6 | VARCHAR2 | 50 | SOURCE_LINE_ID_6 | |
| LINE_GROUP_CODE | VARCHAR2 | 30 | LINE_GROUP_CODE | |
| LINE_NUM | VARCHAR2 | 50 | LINE_NUM | |
| LEDGER_ID | NUMBER | LEDGER_ID | ||
| BUSINESS_UNIT_ID | NUMBER | BUSINESS_UNIT_ID | ||
| DESTINATION_TYPE_CODE | VARCHAR2 | 30 | DESTINATION_TYPE_CODE | |
| DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | DOCUMENT_TYPE_CODE | |
| TRANSACTION_SOURCE_CODE | VARCHAR2 | 30 | TRANSACTION_SOURCE_CODE | |
| TRANSACTION_SUBTYPE_CODE | VARCHAR2 | 30 | TRANSACTION_SUBTYPE_CODE | |
| JE_SOURCE_CODE | VARCHAR2 | 30 | JE_SOURCE_CODE | |
| JE_CATEGORY_CODE | VARCHAR2 | 30 | JE_CATEGORY_CODE | |
| BUDGET_DATE | DATE | BUDGET_DATE | ||
| ACCOUNTING_DATE | DATE | ACCOUNTING_DATE | ||
| ENCUMBRANCE_TYPE_CODE | VARCHAR2 | 30 | ENCUMBRANCE_TYPE_CODE | |
| ENTERED_CURRENCY | VARCHAR2 | 10 | ENTERED_CURRENCY | |
| UOM_CODE | VARCHAR2 | 30 | UOM_CODE | |
| QUANTITY | VARCHAR2 | 30 | QUANTITY | |
| PRICE | NUMBER | PRICE | ||
| ENTERED_AMOUNT | NUMBER | ENTERED_AMOUNT | ||
| CONVERSION_TYPE_CODE | VARCHAR2 | 30 | CONVERSION_TYPE_CODE | |
| CONVERSION_DATE | DATE | CONVERSION_DATE | ||
| LEDGER_AMOUNT | NUMBER | LEDGER_AMOUNT | ||
| LIQUIDATION_DATE | DATE | LIQUIDATION_DATE | ||
| LIQUIDATION_QUANTITY | VARCHAR2 | 30 | LIQUIDATION_QUANTITY | |
| LIQUIDATION_AMOUNT | NUMBER | LIQUIDATION_AMOUNT | ||
| LIQUIDATION_TRANS_TYPE_CODE | VARCHAR2 | 30 | LIQUIDATION_TRANS_TYPE_CODE | |
| LIQUIDATION_LINE_ID_1 | VARCHAR2 | 50 | LIQUIDATION_LINE_ID_1 | |
| LIQUIDATION_LINE_ID_2 | VARCHAR2 | 50 | LIQUIDATION_LINE_ID_2 | |
| LIQUIDATION_LINE_ID_3 | VARCHAR2 | 50 | LIQUIDATION_LINE_ID_3 | |
| LIQUIDATION_LINE_ID_4 | VARCHAR2 | 50 | LIQUIDATION_LINE_ID_4 | |
| LIQUIDATION_LINE_ID_5 | VARCHAR2 | 50 | LIQUIDATION_LINE_ID_5 | |
| LIQUIDATION_LINE_ID_6 | VARCHAR2 | 50 | LIQUIDATION_LINE_ID_6 | |
| STATISTICAL_AMOUNT | VARCHAR2 | 30 | STATISTICAL_AMOUNT | |
| BUDGET_CCID | NUMBER | BUDGET_CCID | ||
| VENDOR_ID | NUMBER | VENDOR_ID | ||
| INVENTORY_ITEM_ID | NUMBER | INVENTORY_ITEM_ID | ||
| ORDER_TYPE_INFO | VARCHAR2 | 30 | ORDER_TYPE_INFO | |
| CODE_COMBINATION_ID | NUMBER | CODE_COMBINATION_ID | ||
| PJC_PROJECT_ID | NUMBER | PJC_PROJECT_ID | ||
| PJC_TASK_ID | NUMBER | PJC_TASK_ID | ||
| PJC_RESOURCE_ID | NUMBER | PJC_RESOURCE_ID | ||
| PJC_CONTRACT_ID | NUMBER | PJC_CONTRACT_ID | ||
| PJC_CONTRACT_LINE_ID | NUMBER | PJC_CONTRACT_LINE_ID | ||
| PJC_FUNDING_ALLOCATION_ID | NUMBER | PJC_FUNDING_ALLOCATION_ID | ||
| PJC_BILLABLE_FLAG | VARCHAR2 | 10 | PJC_BILLABLE_FLAG | |
| PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 10 | PJC_CAPITALIZABLE_FLAG | |
| PJC_EXPENDITURE_TYPE_ID | NUMBER | PJC_EXPENDITURE_TYPE_ID | ||
| PJC_EXPENDITURE_ITEM_DATE | DATE | PJC_EXPENDITURE_ITEM_DATE | ||
| PJC_ORGANIZATION_ID | NUMBER | PJC_ORGANIZATION_ID | ||
| PJC_WORK_TYPE_ID | NUMBER | PJC_WORK_TYPE_ID | ||
| CONTROL_BUDGET_ID | NUMBER | CONTROL_BUDGET_ID | ||
| PARENT_REVERSAL_ID | NUMBER | Invoice distribution identifier for distribution being reversed by the current distribution. | ||
| LIQUIDATION_BASE_AMOUNT | NUMBER | Amount of funds being released by the current distribution in ledger currency. | ||
| PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project related standardized code collection. | |
| PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future project-related functionality. | |
| PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for future project-related functionality. | |
| PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future project-related functionality. | |
| PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for future project-related functionality. | |
| PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for future project-related functionality. | |
| PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for future project-related functionality. | |
| PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for future project-related functionality. | |
| PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for future project-related functionality. | |
| PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for future project-related functionality. | |
| PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for future project-related functionality. | |
| PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user definable project information. | |
| PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user definable project information. | |
| PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user definable project information. | |
| PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user definable project information. | |
| PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user definable project information. | |
| PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user definable project information. | |
| PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user definable project information. | |
| PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user definable project information. | |
| PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user definable project information. | |
| PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user definable project information. | |
| CORRECTED_INVOICE_DIST_ID | NUMBER | 18 | Corrected invoice distribution identifier. For examples, current distribution correction on price, quantity, or invoice line. | |
| PREPAY_DISTRIBUTION_ID | NUMBER | 18 | Prepayment invoice distribution identifier that originated the prepayment application represented by the current distribution. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AP_XCC_EXTRACT_GT_N1 | Non Unique | DATA_SET_ID |