AP_XCC_INVOICE_DTLS_EXTRACT_V

Details

• Schema: FUSION

• Object owner: AP

• Object type: VIEW

Columns

Name

DATA_SET_ID SOURCE_HEADER_ID_1 SOURCE_HEADER_ID_2 TRANSACTION_NUMBER SOURCE_LINE_ID_1 SOURCE_LINE_ID_2 SOURCE_LINE_ID_3 SOURCE_LINE_ID_4 SOURCE_LINE_ID_5 SOURCE_LINE_ID_6 LINE_GROUP_CODE LINE_NUM LEDGER_ID BUSINESS_UNIT_ID DESTINATION_TYPE_CODE DOCUMENT_TYPE_CODE TRANSACTION_SOURCE_CODE TRANSACTION_SUBTYPE_CODE JE_SOURCE_CODE JE_CATEGORY_CODE BUDGET_DATE ACCOUNTING_DATE ENCUMBRANCE_TYPE_CODE ENTERED_CURRENCY UOM_CODE QUANTITY PRICE ENTERED_AMOUNT CONVERSION_TYPE_CODE CONVERSION_DATE LEDGER_AMOUNT LIQUIDATION_DATE LIQUIDATION_QUANTITY LIQUIDATION_AMOUNT LIQUIDATION_TRANS_TYPE_CODE LIQUIDATION_LINE_ID_1 LIQUIDATION_LINE_ID_2 LIQUIDATION_LINE_ID_3 LIQUIDATION_LINE_ID_4 LIQUIDATION_LINE_ID_5 LIQUIDATION_LINE_ID_6 STATISTICAL_AMOUNT BUDGET_CCID VENDOR_ID INVENTORY_ITEM_ID ORDER_TYPE_INFO CODE_COMBINATION_ID PJC_PROJECT_ID PJC_TASK_ID PJC_RESOURCE_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID PJC_FUNDING_ALLOCATION_ID PJC_BILLABLE_FLAG PJC_CAPITALIZABLE_FLAG PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_WORK_TYPE_ID CONTROL_BUDGET_ID PJC_FUNDING_SOURCE

Query

SQL_Statement

SELECT DATA_SET_ID, SOURCE_HEADER_ID_1, SOURCE_HEADER_ID_2, TRANSACTION_NUMBER, SOURCE_LINE_ID_1, SOURCE_LINE_ID_2, SOURCE_LINE_ID_3, SOURCE_LINE_ID_4, SOURCE_LINE_ID_5, SOURCE_LINE_ID_6, LINE_GROUP_CODE, LINE_NUM, LEDGER_ID, BUSINESS_UNIT_ID, DESTINATION_TYPE_CODE, DOCUMENT_TYPE_CODE, TRANSACTION_SOURCE_CODE, TRANSACTION_SUBTYPE_CODE, JE_SOURCE_CODE, JE_CATEGORY_CODE, BUDGET_DATE, ACCOUNTING_DATE, ENCUMBRANCE_TYPE_CODE, ENTERED_CURRENCY, UOM_CODE, QUANTITY, PRICE, ENTERED_AMOUNT, CONVERSION_TYPE_CODE, CONVERSION_DATE, LEDGER_AMOUNT, LIQUIDATION_DATE, LIQUIDATION_QUANTITY, LIQUIDATION_AMOUNT, LIQUIDATION_TRANS_TYPE_CODE, LIQUIDATION_LINE_ID_1, LIQUIDATION_LINE_ID_2, LIQUIDATION_LINE_ID_3, LIQUIDATION_LINE_ID_4, LIQUIDATION_LINE_ID_5, LIQUIDATION_LINE_ID_6, STATISTICAL_AMOUNT, BUDGET_CCID, VENDOR_ID, INVENTORY_ITEM_ID, ORDER_TYPE_INFO, CODE_COMBINATION_ID, PJC_PROJECT_ID, PJC_TASK_ID, PJC_RESOURCE_ID, PJC_CONTRACT_ID, PJC_CONTRACT_LINE_ID, PJC_FUNDING_ALLOCATION_ID, PJC_BILLABLE_FLAG, PJC_CAPITALIZABLE_FLAG, PJC_EXPENDITURE_TYPE_ID, PJC_EXPENDITURE_ITEM_DATE, PJC_ORGANIZATION_ID, PJC_WORK_TYPE_ID, CONTROL_BUDGET_ID, PJC_RESERVED_ATTRIBUTE1 PJC_FUNDING_SOURCE FROM AP_XCC_EXTRACT_GT