# DW_PROJECT_COST_CF

This table stores data for the smallest categorized expenditure units charged to projects and tasks.

## Details

Module: Project Costing

## Key Columns

EXPENDITURE_ITEM_ID, LINE_NUM

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
EXPENDITURE_ITEM_ID | NUMBER | 38 | 0 | True | The identifier of the expenditure item that is cost distributed by the distribution line |  |
LINE_NUM | NUMBER | 38 | 0 | True | The sequential number that identifies the cost distribution line for an expenditure item |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. System Generated Unique Identifier |  |
PROJECT_ID | NUMBER | 38 | 0 |  | Identifier of the project | DW_PROJECT_D | PROJECT_ID
PROJECT_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Identifier of the project organization. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
DOCUMENT_ENTRY_ID | NUMBER | 38 | 0 |  | Projects-relates sub-categorication of the document type that is creating this transaction. | DW_PROJECT_TXN_DOC_ENTRY_TL | DOCUMENT_ENTRY_ID
DOCUMENT_ID | NUMBER | 38 | 0 |  | Projects-related categorization of the document type that is creating this transaction. | DW_PROJECT_TXN_DOCUMENT_TL | DOCUMENT_ID
EXPENDITURE_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Expenditure Organization for the Expenditure item. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Identifier of the expenditure type | DW_PROJECT_EXPENDITURE_TYPE_D | EXPENDITURE_TYPE_ID
NON_LABOR_RESOURCE_ID | NUMBER | 38 | 0 |  | Identifier of the non labor resource | DW_PROJECT_NON_LABOR_RES_TL | NON_LABOR_RESOURCE_ID
NON_LABOR_RESOURCE_ORG_ID | NUMBER | 38 | 0 |  | The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. This column is only populated for usage items | DW_INTERNAL_ORG_D | ORGANIZATION_ID
TRANSACTION_SOURCE_ID | NUMBER | 38 | 0 |  | Identifier of Transaction Source. | DW_PROJECT_TXN_SOURCE_TL | TRANSACTION_SOURCE_ID
PROJECT_UNIT_ID | NUMBER | 38 | 0 |  | Project unit assigned to the project | DW_INTERNAL_ORG_D | ORGANIZATION_ID
TASK_ID | NUMBER | 38 | 0 |  | Identifier of the task | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
TASK_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization that is responsible for the work | DW_INTERNAL_ORG_D | ORGANIZATION_ID
WORK_TYPE_ID | NUMBER | 38 | 0 |  | Identifier for a work type assigned to the transaction. | DW_PROJECT_WORK_TYPE_TL | WORK_TYPE_ID
TRANSFER_PRICE_JOB_ID | NUMBER | 38 | 0 |  | Borrowed/Lent Job ID | DW_JOB_D | JOB_ID
SUPPLIER_ID | NUMBER | 38 | 0 |  | This column indicates the vendor identifier for supplier cost transactions. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICES_ALL.VENDOR_ID. If the expenditure item originated in Oracle Purchasing, it holds the | DW_PARTY_D | SUPPLIER_ID
EXPENDITURE_GROUP_ID | NUMBER | 38 | 0 |  | Indicates the Expenditure Group ID. | DW_PROJECT_EXPENDITURE_BATCH_D | EXPENDITURE_GROUP_ID
PRVDR_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Indicates the identifier of the business unit associated to the row. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PRVDR_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity assigned to the Provider business unit. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
PRVDR_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger of Provider Organization | DW_LEDGER_D | LEDGER_ID
RECVR_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Receiver Operating Unit Identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
RECVR_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity assigned to the Receiver business unit. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
RECVR_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger of Receiver Organization | DW_LEDGER_D | LEDGER_ID
PERSON_JOB_ID | NUMBER | 38 | 0 |  | The identifier of the job of an employee as of the expenditure item date. Required for all items incurred by an employee. This may be used in the mapping of the transaction to a resource for project summary amounts. | DW_JOB_D | JOB_ID
INCURRED_BY_PERSON_ID | NUMBER | 38 | 0 |  | Identifier of employee. | DW_PERSON_D | PERSON_ID
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Inventory item identifier | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
CC_PRVDR_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Identifier of the provider organization. This may be different than the expenditure organization or the non-labor resource organization, if it is overridden by the client extension to derive provider organization | DW_INTERNAL_ORG_D | ORGANIZATION_ID
CC_RECVR_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Identifier of the receiver organization. This may be different than the project organization, if it is overridden by the client extension to derive receiver organization | DW_INTERNAL_ORG_D | ORGANIZATION_ID
FISCAL_PERIOD_NAME | VARCHAR2 | 16 |  |  | The GL period in which the transaction is posted. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
PRVDR_GL_DATE | DATE |  |  |  | Date used to determine the correct general ledger accounting period in the provider operating unit. The GL date is determined by the Distribution programs from the open or future GL period on or after the transaction date. For supplier invoices this date is copied from AP. | DW_DAY_D | CALENDAR_DATE
PRVDR_GL_PERIOD_NAME | VARCHAR2 | 16 |  |  | The GL period in which the transaction is posted. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
PRVDR_GL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | The GL period type in which the transaction is posted. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
PRVDR_GL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | GL Calendar Name for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
PRVDR_PA_DATE | DATE |  |  |  | Date used to determine the correct project accounting period in the provider operating unit. The PA date is determined by the Distribution programs from the open or future PA period on or after the transaction date | DW_DAY_D | CALENDAR_DATE
PRVDR_PA_PERIOD_NAME | VARCHAR2 | 16 |  |  | The PA period for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
PRVDR_PA_PERIOD_TYPE | VARCHAR2 | 16 |  |  | The PA period type for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
PRVDR_PA_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | PA Calendar Name for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
RECVR_GL_DATE | DATE |  |  |  | Date used to determine the correct general ledgert accounting period in the receiver operating unit. The GL date is determined by the Distribution programs from the open or future GL period on or after the transaction date | DW_DAY_D | CALENDAR_DATE
RECVR_GL_PERIOD_NAME | VARCHAR2 | 16 |  |  | The GL period in which the transaction is posted on the receiving ledger. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
RECVR_GL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | The GL period type in which the transaction is posted on the receiving ledger. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
RECVR_GL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | The GL period in which the transaction is posted on the receiving ledger. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
RECVR_PA_DATE | DATE |  |  |  | Date used to determine the correct project accounting period in the receiver operating unit. The PA date is determined by the Distribution programs from the open or future PA period on or after the transaction date | DW_DAY_D | CALENDAR_DATE
RECVR_PA_PERIOD_NAME | VARCHAR2 | 16 |  |  | The PA period for Receiver business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
RECVR_PA_PERIOD_TYPE | VARCHAR2 | 16 |  |  | The PA period type for Receiver business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
RECVR_PA_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | PA Calendar Name for Receiver business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
LINE_TYPE | VARCHAR2 | 16 |  |  | The type of the cost distribution line | DW_COST_DIST_LINE_TYPE_LKP_TL | LINE_TYPE
REVERSED_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates if the distribution line is reversed by another distribution line | DW_Y_N_D_TL | CODE
REVERSED_LINE_NUMBER | NUMBER | 38 | 0 |  | The distribution line number that is reversed by this distribution line |  |
TRANSFERRED_FROM_EXP_ITEM_ID | NUMBER | 38 | 0 |  | The identifier of the expenditure item from which this expenditure item originated. This expenditure item is the new item that is system created when an item is transferred and is charged to the new project/task |  |
RAW_COST_RATE | NUMBER |  |  |  | The raw cost rate used to cost the item |  |
BURDEN_COST_RATE | NUMBER |  |  |  | The burdened cost rate of the item. Burdened cost rate = (burden cost / quantity ). |  |
QUANTITY | NUMBER |  |  |  | The number of units that are costed in the distribution line cost. The quantity is set from the expenditure item quantity when the distribution line is created and is used for populating the quantities in the accumulation tables |  |
UOM_CODE | VARCHAR2 | 32 |  |  | Base unit of measure | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PRVDR_LEDGER_RAW_COST | NUMBER |  |  |  | The amount in functional currency to be charged to the gl account for the expenditure item The amount is stored as a debit, so the burden credit amounts and adjustment amounts are negative |  |
PRVDR_LEDGER_BURDENED_COST | NUMBER |  |  |  | Burdened cost in functional currency |  |
PRVDR_LEDGER_BURDEN_COST | NUMBER |  |  |  | Burden cost in functional currency |  |
PRVDR_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Functional Currency Code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
PRVDR_LEDGER_EXCHANGE_RATE | NUMBER |  |  |  | Conversion rate used to convert raw cost from transaction currency to functional currency |  |
PRVDR_LEDGER_RATE_DATE | DATE |  |  |  | Conversion rate date used to convert raw cost from transaction currency to functional currency |  |
PRVDR_LEDGER_RATE_TYPE | VARCHAR2 | 32 |  |  | Conversion rate type used to convert raw cost from transaction currency to functional currency |  |
PRVDR_LEDGER_TRANSFER_PRICE | NUMBER |  |  |  | Transfer price in functional currency of the provider operating unit |  |
PROJACCT_TRANSFER_PRICE | NUMBER |  |  |  | Transfer price in the functional currency of cross charged project (receiver operating unit) |  |
RECVR_LEDGER_RAW_COST | NUMBER |  |  |  | Amount in project functional currency. Derrived by converting raw cost in transaction currency to project functional currency |  |
RECVR_LEDGER_BURDENED_COST | NUMBER |  |  |  | Amount of the burdened cost in project functional currency |  |
RECVR_LEDGER_BURDEN_COST | NUMBER |  |  |  | Amount of the burden cost in project functional currency |  |
RECVR_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Project functional currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
RECVR_LEDGER_EXCHANGE_RATE | NUMBER |  |  |  | Exchange rate used to convert costs from the transaction currency to the project functional currency. |  |
RECVR_LEDGER_RATE_DATE | DATE |  |  |  | Rate date used to convert costs from the transaction currency to the project functional currency. |  |
RECVR_LEDGER_RATE_TYPE | VARCHAR2 | 32 |  |  | Rate type used to convert costs from the transaction currency to the project functional currency. |  |
RECVR_LEDGER_TRANSFER_PRICE | NUMBER |  |  |  | Transfer price in project functional currency. |  |
PROJECT_RAW_COST | NUMBER |  |  |  | Raw cost in project currency. |  |
PROJECT_BURDENED_COST | NUMBER |  |  |  | Burdened cost in project currency. |  |
PROJECT_BURDEN_COST | NUMBER |  |  |  | Burden cost in project currency. |  |
PROJECT_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Project currency code of the transaction | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
PROJECT_EXCHANGE_RATE | NUMBER |  |  |  | Exchange rate used to convert costs from the transaction currency to the project currency. |  |
PROJECT_RATE_DATE | DATE |  |  |  | Rate date used to convert costs from the transaction currency to the project currency. |  |
PROJECT_RATE_TYPE | VARCHAR2 | 32 |  |  | Rate type used to convert costs from the transaction currency to the project currency. |  |
PROJECT_TRANSFER_PRICE | NUMBER |  |  |  | Transfer price in project currency. |  |
TRANSACTION_RAW_COST | NUMBER |  |  |  | The raw cost in transaction currency |  |
TRANSACTION_BURDENED_COST | NUMBER |  |  |  | The amount of the burdened cost in transaction currency It is only populated for raw cost distribution lines |  |
TRANSACTION_BURDEN_COST | NUMBER |  |  |  | The amount of the burdend cost in transaction currency It is only populated for raw cost distribution lines |  |
TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Transaction Currency code of the transaction | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
TRANSACTION_TRANSFER_PRICE | NUMBER |  |  |  | Transfer price in the transaction currency |  |
GLOBAL_RAW_COST | NUMBER |  |  |  | The raw cost in Global currency |  |
GLOBAL_BURDENED_COST | NUMBER |  |  |  | The amount of the burdened cost in Global currency. |  |
GLOBAL_BURDEN_COST | NUMBER |  |  |  | The amount of the burden cost in Global currency. |  |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Global Currency Code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
GLOBAL_EXCHANGE_RATE | NUMBER |  |  |  | Exchange rate used to convert costs from the transaction currency to the Global currency. |  |
GLOBAL_RATE_DATE | DATE |  |  |  | Rate date used to convert costs from the transaction currency to the Global currency. |  |
GLOBAL_RATE_TYPE | VARCHAR2 | 32 |  |  | Rate type used to convert costs from the transaction currency to the Global currency. |  |
GLOBAL_TRANSFER_PRICE_AMOUNT | NUMBER |  |  |  | Transfer price in Global currency. |  |
EXPENDITURE_ITEM_DATE | DATE |  |  |  | The date on which the work occurred | DW_DAY_D | CALENDAR_DATE
EXPENDITURE_ENDING_DATE | DATE |  |  |  | Expenditure End date. |  |
EXPENDITURE_CREATION_DATE | TIMESTAMP |  |  |  | indicates the date and time of the creation of expenditure row |  |
COST_DIST_LINE_CREATION_DATE | TIMESTAMP |  |  |  | indicates the date and time of the creation of the cost distribution row |  |
COST_DIST_LINE_CREATED_BY | VARCHAR2 | 128 |  |  | indicates the user who created the cost distribution row. | DW_USER_D | USERNAME
ACCOUNTING_STATUS_CODE | VARCHAR2 | 16 |  |  | The status of the distribution line as the cost information is transferred to another application |  |
ACCOUNT_SOURCE_CODE | VARCHAR2 | 16 |  |  | Code used to identify accounting transactions, which are not migrated to SLA |  |
EXPENDITURE_CLASS_CODE | VARCHAR2 | 16 |  |  | The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type | DW_PROJECT_SYSTEM_LINKAGE_TL | SYSTEM_LINKAGE_FUNCTION
INCURRED_BY_PERSON_TYPE | VARCHAR2 | 32 |  |  | Identifies the type of person - employee or contingent worker. | DW_EXP_PERSON_TYPE_LKP_TL | PERSON_TYPE
TRANSFER_REJECTION_REASON | VARCHAR2 | 256 |  |  | The reason why the distribution line was rejected by the PA Cost Transfer program or rejected by the other application's interface program |  |
TRANSFER_STATUS_CODE | VARCHAR2 | 16 |  |  | It contain Y or N for Extracted and non extracted records. |  |
EXPENDITURE_COMMENT | VARCHAR2 | 256 |  |  | The free text comment entered for an expenditure item |  |
LABOR_COST_MULTIPLIER_NAME | VARCHAR2 | 32 |  |  | The labor cost multiplier specified for a premium labor expenditure item in order to determine the premium labor cost. Cost = (cost rate*quantity*LCM). This is populated by the timecard entry forms or the Overtime Calculation program |  |
BILLABLE_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates whether the cost amount is billable. The flag is set from the expenditure item billable flag when the distribution line is created and is used for determining billable/non-billable costs in the accumulation tables |  |
CAPITALIZABLE_FLAG | VARCHAR2 | 16 |  |  | Capitalizable Flag |  |
BILL_HOLD_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates if the item is held from invoicing. Upon entry, this flag is defaulted to 'N'. | DW_PROJ_BILL_HOLD_LKP_TL | BILL_HOLD_FLAG
INVOICED_FLAG | VARCHAR2 | 16 |  |  | Indicates the Invoice status of event. | DW_EVT_INVOICED_FLAG_LKP_TL | INVOICED_FLAG
REVENUE_HOLD_FLAG | VARCHAR2 | 16 |  |  | Indicates the Revenue status of event. | DW_PROJ_REVENUE_HOLD_LKP_TL | REVENUE_HOLD_FLAG
REVENUE_RECOGNIZED_FLAG | VARCHAR2 | 16 |  |  | Identify if Revenue Recognition is on Hold. | DW_REVENUE_RECOGNIZED_LKP_TL | REVENUE_RECOGNIZED_FLAG
IC_BILL_HOLD_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates if the item is held from invoicing | DW_PROJ_BILL_HOLD_LKP_TL | BILL_HOLD_FLAG
IC_BILLABLE_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates if transaction is eligible for Intercompany billing. |  |
IC_INVOICED_FLAG | VARCHAR2 | 16 |  |  | Indicates the Invoice status of event. | DW_EVT_INVOICED_FLAG_LKP_TL | INVOICED_FLAG
IC_REVENUE_HOLD_FLAG | VARCHAR2 | 16 |  |  | Indicates the Revenue status of event. | DW_PROJ_REVENUE_HOLD_LKP_TL | REVENUE_HOLD_FLAG
IC_REVENUE_RECOGNIZED_FLAG | VARCHAR2 | 16 |  |  | Identify if Revenue Recognition is on Hold. | DW_REVENUE_RECOGNIZED_LKP_TL | REVENUE_RECOGNIZED_FLAG
CC_BL_DISTRIBUTED_CODE | VARCHAR2 | 16 |  |  | Indicates the processing status of the Expenditure Item by the Distribute Borrowed and Lent Accounts process | DW_CC_PROCESSED_CODE_LKP_TL | CC_PROCESSED_CODE
CC_CROSS_CHARGE_TYPE | VARCHAR2 | 16 |  |  | Cross Charge Type | DW_CC_CHARGE_TYPE_LKP_TL | CC_CROSS_CHARGE_TYPE
ORIGINAL_TRANSACTION_REFERENCE | VARCHAR2 | 128 |  |  | Only populated for expenditure items created from transactions imported into PA from an external system. The TRANSACTION_SOURCE and ORIG_TRANSACTION_REFERENCE columns together identify the expenditure item created after import. |  |
SOURCE_TRNX_DIST_ID | NUMBER | 38 | 0 |  | Source Transaction Distribution Reference which is the identifier used to retrieve the account for the inventory and receipt costs imported into Project Costing. For example, in the case of miscellaneous issue to project transactions, this is the offset account identifier. |  |
SOURCE_TRNX_HEADER_ID | NUMBER | 38 | 0 |  | Source Transaction Header Reference |  |
SOURCE_TRNX_LINE_NUMBER | NUMBER | 38 | 0 |  | Source Transaction Line Reference |  |
SOURCE_TRNX_PARENT_DIST_ID | NUMBER | 38 | 0 |  | Source Transaction DIstribution Reference |  |
SOURCE_TRNX_PARENT_HEADER_ID | NUMBER | 38 | 0 |  | Source Transaction Parent Header Reference |  |
SOURCE_TRNX_PARENT_LINE_NUMBER | NUMBER | 38 | 0 |  | Source Transaction Parent Line Reference |  |
PARENT_LINE_NUMBER | NUMBER | 38 | 0 |  | Line Number for the raw cost distribution line. Valid for I line types only. |  |
SUPPLIER_INVOICE_NUM | VARCHAR2 | 64 |  |  | Unique number for supplier invoice. |  |
SUPPLIER_INVOICE_LINE_NUM | NUMBER |  |  |  | The unique number for the invoice line associated with the invoice distribution. |  |
SUPPLIER_INVOICE_DIST_LINE_NUM | NUMBER | 38 | 0 |  | The line number associated with the invoice distribution. |  |
PURCHASE_ORDER_NUMBER | VARCHAR2 | 32 |  |  | Purchase order number |  |
PURCHASE_ORDER_LINE_NUMBER | NUMBER |  |  |  | Line number |  |
PURCHASE_ORDER_DIST_NUMBER | NUMBER |  |  |  | Distribution number |  |
INVENTORY_TRANSACTION | VARCHAR2 | 512 |  |  | Inventory Transaction |  |
SALES_ORDER_NUMBER | VARCHAR2 | 512 |  |  | Sales Order Number |  |
SHIPMENT_NUMBER | VARCHAR2 | 512 |  |  | Shipment Number |  |
TRANSFER_ORDER_NUMBER | VARCHAR2 | 512 |  |  | Transfer Order Number |  |
WORK_ORDER_NUMBER | VARCHAR2 | 512 |  |  | Work Order Number |  |
RESOURCE_CLASS_CODE | VARCHAR2 | 32 |  |  | Resource Class name. |  |
COST_ELEMENT_ID | NUMBER | 38 | 0 |  | Unique identifier of the cost element | DW_CST_COST_ELEMENTS_D | COST_ELEMENT_ID
RECEIPT_NUMBER | VARCHAR2 | 512 |  |  | Receipt Number |  |
AWARD_BUDGET_PERIOD_ID | NUMBER | 38 | 0 |  | Identifier of Budget Period for which the funding is made | DW_AWARD_BUDGET_PERIOD_D | AWARD_BUDGET_PERIO_ID
AWARD_FUNDING_SOURCE_ID | NUMBER | 38 | 0 |  | Unique identifier of the funding source | DW_AWARD_FUNDING_SOURCE_D | FUNDING_SOURCE_ID
CONTRACT_HEADER_ID | NUMBER | 38 | 0 |  | Unique identifier of the contract | DW_PROJECT_AWARD_D | AWARD_ID
ACCOUNTED_FLAG | VARCHAR2 | 16 |  |  | Flag to identify if Expenditure item is Accounted. | DW_Y_N_D_TL | CODE

Copyright Â© 2019, 2026, Oracle and/or its affiliates.