# DW_PROJECT_INVOICE_CF

This table stores data for invoice distributions generated for expenditure items and billing events

## Details

Module: Project Billing

## Key Columns

INVOICE_DIST_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
INVOICE_DIST_ID | NUMBER | 38 | 0 | True | Identifier of the Invoice Distribution Line |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System |  |
INVOICE_ID | NUMBER | 38 | 0 |  | Identifier of the Invoice |  |
INVOICE_LINE_ID | NUMBER | 38 | 0 |  | Identifier of the invoice line |  |
INV_LINE_DIST_NUM | NUMBER | 38 | 0 |  | Invoice distribution number |  |
MAJOR_VERSION | NUMBER | 38 | 0 |  | Contract Version |  |
CONTRACT_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Contract business unit identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
CONTRACT_HEADER_ID | NUMBER | 38 | 0 |  | Identifier of the contract | DW_CONTRACT_HEADER_D | CONTRACT_HEADER_ID
CONTRACT_LINE_ID | NUMBER | 38 | 0 |  | Identifier of the contract line | DW_CONTRACT_LINE_CF | CONTRACT_LINE_ID
CONTRACT_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Contract legal entity identifier | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
CONTRACT_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger identifier of Contract | DW_LEDGER_D | LEDGER_ID
PROJECT_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger identifier of Project | DW_LEDGER_D | LEDGER_ID
BILL_PLAN_ID | NUMBER | 38 | 0 |  | Identifier of the bill plan | DW_CONTRACT_BILL_PLAN_D | BILL_PLAN_ID
BILL_SET_NUM | NUMBER | 38 | 0 |  | Identifier of the bill set which is defined in bill plan |  |
LINKED_PROJECT_ID | NUMBER | 38 | 0 |  | Identifier of project that is linked to contract | DW_PROJECT_D | PROJECT_ID
LINKED_TASK_ID | NUMBER | 38 | 0 |  | Identifier of task that is linked to contract | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
TRANSACTION_PROJECT_ID | NUMBER | 38 | 0 |  | Identifier of project | DW_PROJECT_D | PROJECT_ID
TRANSACTION_TASK_ID | NUMBER | 38 | 0 |  | Identifier of task | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
EXPENDITURE_ITEM_ID | NUMBER | 38 | 0 |  | Expenditure Iten Identifier |  |
EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Expenditure Type Identifier | DW_PROJECT_EXPENDITURE_TYPE_D | EXPENDITURE_TYPE_ID
EXPENDITURE_CATEGORY_ID | NUMBER | 38 | 0 |  | Category of the expenditure type | DW_PROJECT_EXP_CATEGORY_D | EXPENDITURE_CATEGORY_ID
EVENT_ID | NUMBER | 38 | 0 |  | Event Identifier |  |
EVENT_TYPE_ID | NUMBER | 38 | 0 |  | Identifier of the event type | DW_PROJECT_EVENT_TYPE_D | EVENT_TYPE_ID
BILL_JOB_ID | NUMBER | 38 | 0 |  | The identifier of the effective job used when invoicing a labor item as of the last time the expenditure item was invoiced | DW_JOB_D | JOB_ID
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Identifier of the inventory item. | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ITEM_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Identifier of the inventory item organization. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PROJECT_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity assigned to the project. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
PROJECT_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Project business unit identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PROJECT_ORGANIZATION_ID | NUMBER | 38 | 0 |  | The identifier of the organization that is responsible for the project work | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PROJECT_UNIT_ID | NUMBER | 38 | 0 |  | Project unit assigned to the project. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
APPROVED_BY_PERSON_ID | NUMBER | 38 | 0 |  | The identifier of the employee that approved the invoice | DW_PERSON_D | PERSON_ID
RELEASED_BY_PERSON_ID | NUMBER | 38 | 0 |  | The identifier of the employee that released the invoice | DW_PERSON_D | PERSON_ID
BILL_TO_CUSTOMER_ACCOUNT_ID | NUMBER | 38 | 0 |  | Identifier for Bill to Customer Account | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
BILL_TO_PARTY_ID | NUMBER | 38 | 0 |  | Party Identifier for Bill to Customer | DW_PARTY_D | PARTY_ID
BILL_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Bill to Location Identifier | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
BILL_TO_LOCATION | VARCHAR2 | 256 |  |  | Bill to Location Name |  |
SHIP_TO_CUSTOMER_ACCOUNT_ID | NUMBER | 38 | 0 |  | Identifier for Ship to Customer Account | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
SHIP_TO_PARTY_ID | NUMBER | 38 | 0 |  | Party Identifier for Ship to Customer | DW_PARTY_D | PARTY_ID
SHIP_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Ship to Location Identifier | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
SHIP_TO_LOCATION | VARCHAR2 | 256 |  |  | Ship to Location Name |  |
SOLD_TO_CUSTOMER_ACCOUNT_ID | NUMBER | 38 | 0 |  | Sold to Customer Account. | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
SOLD_TO_PARTY_ID | NUMBER | 38 | 0 |  | Sold to Cistomer Party ID. | DW_PARTY_D | PARTY_ID
SOLD_TO_LOCATION | VARCHAR2 | 256 |  |  | Sold to Location Name |  |
SOLD_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Sold to Location Identifier | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
GL_DATE | DATE |  |  |  | The date within a GL accounting period to which the invoice transactions are posted. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
FISCAL_PERIOD_NAME | VARCHAR2 | 16 |  |  | GL Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
PA_DATE | DATE |  |  |  | The end date of the PA period in which the invoice was generated. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
PA_PERIOD_NAME | VARCHAR2 | 16 |  |  | Project Accounting Period | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
PA_PERIOD_TYPE | VARCHAR2 | 16 |  |  | PA Calendar type. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
PA_PERIOD_SETNAME | VARCHAR2 | 16 |  |  | PA Calendar name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Name of the accounting calendar | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | GL Accounting period type. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
PROJECT_FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Name of the accounting calendar associated with Project ledger | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
PROJECT_FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | GL Accounting period type associated with Project ledger | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
INVOICE_NUM | NUMBER | 38 | 0 |  | Invoice Number |  |
INVOICE_LINE_NUM | NUMBER | 38 | 0 |  | Invoice Line Number |  |
INVOICE_LINE_DESC | VARCHAR2 | 256 |  |  | Invoice Line description |  |
INVOICE_TYPE_CODE | VARCHAR2 | 32 |  |  | Invoice Type | DW_INVOICE_TYPE_LKP_TL | INVOICE_TYPE_CODE
INVOICE_STATUS_CODE | VARCHAR2 | 32 |  |  | Status code of invoice | DW_INVOICE_STATUS_LKP_TL | INVOICE_STATUS_CODE
INVOICE_FORMAT_NAME | VARCHAR2 | 32 |  |  | Invoice Format Name |  |
INVOICE_LINE_TYPE | VARCHAR2 | 32 |  |  | Invoice Line Type | DW_INVOICE_LINE_TYPE_LKP_TL | INVOICE_LINE_TYPE
INVOICE_BILL_TO_DATE | DATE |  |  |  | The date through which to invoice the project |  |
INVOICE_APPROVED_DATE | DATE |  |  |  | The date on which the draft invoice is approved |  |
INVOICE_RELEASED_DATE | DATE |  |  |  | The date that the draft invoice was released for transfer |  |
INVOICE_TRANSFERRED_DATE | DATE |  |  |  | The date that the draft invoice was transferred to the Oracle Receivables interface tables |  |
INVOICE_DATE | DATE |  |  |  | Invoice Date |  |
TRANSACTION_DATE | DATE |  |  |  | Date when transaction occurs |  |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Global Currency Code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
CONTRACT_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Contract currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
LEDGER_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Ledger currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
PROJECT_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Project currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
INVOICE_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Invoice currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
TRNX_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Transaction Currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
PROJECT_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Project functional currency. The default value is the value entered for the associated ledger. |  |
CONT_CURR_INV_RATE_TYPE | VARCHAR2 | 32 |  |  | Contract Currency Invoice Rate Type | DW_CONVERSION_RATE_TYPE_D | CONVERSION_TYPE
CONT_CURR_INV_EXCHG_DATE | DATE |  |  |  | Contract Currency Invoice Conversion Date |  |
CONT_CURR_INV_EXCHG_RATE | NUMBER |  |  |  | Contract Currency Invoice Conversion Rate |  |
LEDGER_CURR_INV_RATE_TYPE | VARCHAR2 | 32 |  |  | Ledger Currency Conversion Rate Type | DW_CONVERSION_RATE_TYPE_D | CONVERSION_TYPE
LEDGER_CURR_INV_EXCHG_DATE | DATE |  |  |  | Ledger Currency Conversion Date |  |
LEDGER_CURR_INV_EXCHG_RATE | NUMBER |  |  |  | Ledger Currency Conversion Rate |  |
PROJECT_CURR_INV_RATE_TYPE | VARCHAR2 | 32 |  |  | Project Currency Conversion Rate Type | DW_CONVERSION_RATE_TYPE_D | CONVERSION_TYPE
PROJECT_CURR_INV_EXCHG_DATE | DATE |  |  |  | Project Currency Conversion Date |  |
PROJECT_CURR_INV_EXCHG_RATE | NUMBER |  |  |  | Project Currency Conversion Rate |  |
INVOICE_CURR_RATE_TYPE | VARCHAR2 | 32 |  |  | Invoice Currency Conversion Rate Type | DW_CONVERSION_RATE_TYPE_D | CONVERSION_TYPE
INVOICE_CURR_EXCHG_DATE | DATE |  |  |  | Invoice Currency Conversion Date |  |
INVOICE_CURR_EXCHG_RATE | NUMBER |  |  |  | Invoice Currency Conversion Rate |  |
GLOBAL_CURR_INV_RATE_TYPE | VARCHAR2 | 32 |  |  | Global Currency Conversion Rate Type | DW_CONVERSION_RATE_TYPE_D | CONVERSION_TYPE
GLOBAL_CURR_INV_EXCHG_DATE | DATE |  |  |  | Global Currency Conversion Date |  |
GLOBAL_CURR_INV_EXCHG_RATE | NUMBER |  |  |  | Global Currency Conversion Rate |  |
GLOBAL_CURR_BILLED_AMT | NUMBER |  |  |  | Invoice Amount in Global Currency |  |
TRNX_CURR_BILLED_AMT | NUMBER |  |  |  | Invoice Amount in Bill Transaction Currency |  |
CONTRACT_CURR_BILLED_AMT | NUMBER |  |  |  | Invoice Amount in Contract Currency |  |
INVOICE_CURR_BILLED_AMT | NUMBER |  |  |  | Invoice Amount in Invoice Currency |  |
PROJECT_CURR_BILLED_AMT | NUMBER |  |  |  | Invoice Amount in Project Currency |  |
LEDGER_CURR_BILLED_AMT | NUMBER |  |  |  | Invoice Amount in Ledger Currency |  |
INV_BILLED_QUANTITY | NUMBER |  |  |  | Quantity that has been invoiced. |  |
INVOICE_CURR_CREDIT_AMT | NUMBER |  |  |  | Credit Amount in Invoice Currency |  |
TRNS_CURR_CREDIT_AMT | NUMBER |  |  |  | Credit Amount in Bill Transaction Currency |  |
CONTRACT_CURR_CREDIT_AMT | NUMBER |  |  |  | Credit Amount in Contract Currency |  |
INVOICE_CURR_CONCESSION_AMT | NUMBER |  |  |  | Concession Amount in Invoice Currency |  |
TRNS_CURR_CONCESSION_AMT | NUMBER |  |  |  | Concession Amount in Bill Transaction Currency |  |
CONTRACT_CURR_CONCESSION_AMT | NUMBER |  |  |  | Concession Amount in Contract Currency |  |
INVOICE_CURR_WRITEOFF_AMT | NUMBER |  |  |  | InvoiceDistributionPEOInvCurrWriteoffAmt |  |
TRNS_CURR_WRITEOFF_AMT | NUMBER |  |  |  | Write-off Amount in Transaction Currency |  |
CONTRACT_CURR_WRITEOFF_AMT | NUMBER |  |  |  | InvoiceDistributionPEOContCurrWriteoffAmt |  |
INVOICE_LABOR_MULTIPLIER | NUMBER |  |  |  | Audit Column for rate derivation |  |
INVOICE_MARKUP_PERCENTAGE | NUMBER |  |  |  | Audit Column for bill rate derivation. Markup Percentage used in derving bill rate was based on a markup in bill rate schedule. |  |
INVOICE_DISCOUNT_PERCENTAGE | NUMBER |  |  |  | Discount Percentage is used to calculate the adjusted invoice and rate |  |
TP_BASE_AMOUNT | NUMBER |  |  |  | Transfer Price Base Amount |  |
TP_INV_RULE_PERCENTAGE | NUMBER |  |  |  | Transfer Price Invoice Rule Percentage |  |
TP_INV_SCH_LINE_PERCENTAGE | NUMBER |  |  |  | Transfer Price Invoice Schedule Line Percentage |  |
RA_INVOICE_NUMBER | VARCHAR2 | 32 |  |  | The Oracle Receivables invoice number that is determined upon release of the draft invoice and passed to Oracle Receivables upon transfer. |  |
CREDIT_MEMO_REASON_CODE | VARCHAR2 | 32 |  |  | Reason code for releasing credit invoices | DW_CREDIT_MEMO_REASON_LKP_TL | CREDIT_MEMO_REASON_CODE
BILLING_TYPE_CODE | VARCHAR2 | 32 |  |  | Identifier of billing type. IC(Inter company), IP(Inter project), EX(External) | DW_PJB_BILLING_TYPE_LKP_TL | BILLING_TYPE_CODE
BILL_TRANSACTION_TYPE_CODE | VARCHAR2 | 32 |  |  | Billing Transaciton Type Code |  |
REVENUE_CATEGORY_CODE | VARCHAR2 | 32 |  |  | The revenue category that classifies the expenditure type into a revenue group | DW_REVENUE_CATEGORY_LKP_TL | REVENUE_CATEGORY_CODE
INV_DISCOUNT_REASON_CODE | VARCHAR2 | 32 |  |  | Reason code for discount override or rate override | DW_INV_DISCOUNT_REASON_LKP_TL | INV_DISCOUNT_REASON_CODE
IC_TP_AMT_TYPE_CODE | VARCHAR2 | 32 |  |  | Intercompany Transfer Price Amount Type | DW_IC_TP_AMT_TYPE_LKP_TL | IC_TP_AMT_TYPE_CODE
IC_TP_BASE_CODE | VARCHAR2 | 32 |  |  | Intercompany Transfer Price Base | DW_TP_RULE_BASE_LKP_TL | TP_RULE_BASE_CODE
INV_DISTRIBUTION_TYPE_CODE | VARCHAR2 | 32 |  |  | Invoice Distribution Type |  |
CANCELLED_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates that the draft invoice was credited by another draft invoice, a credit memo | DW_YN_LKP_TL | YN_LKP_CODE
CONVERTED_FLAG | VARCHAR2 | 16 |  |  | Flag indicating if the invoice is converted. 'Y' denotes a converted invoice with no detail in AR as PA expects. A value of 'N' or null denotes a non-converted invoice. A converted invoice cannot be cancelled or written off. | DW_YN_LKP_TL | YN_LKP_CODE
WRITE_OFF_FLAG | VARCHAR2 | 16 |  |  | Indicator if this invoice line is write-off | DW_YN_LKP_TL | YN_LKP_CODE
NET_CREDIT_FLAG | VARCHAR2 | 16 |  |  | Identified for Net Credit . | DW_YN_LKP_TL | YN_LKP_CODE
TAXATION_COUNTRY | VARCHAR2 | 16 |  |  | The country for taxation for tax calculation purpose. |  |
UOM_CODE | VARCHAR2 | 32 |  |  | UOM Code | DW_PROJECT_UNIT_OF_MEASURE_TL | UOM_CODE
INV_CURR_UNIT_PRICE | NUMBER |  |  |  | Unit Price in Invoice Currency |  |
BILL_TRX_ID | NUMBER | 38 | 0 |  | The identifier of the expenditure item/event that is invoice distributed by the distribution line |  |
CREDITED_DIST_ID | NUMBER | 38 | 0 |  | Origin of Adjustment |  |
REVERSED_DIST_ID | NUMBER | 38 | 0 |  | Identifier of the distribution reversed by this distribution. |  |
BILL_RATE | NUMBER |  |  |  | Audit column. Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule |  |
EVENT_NUM | NUMBER | 38 | 0 |  | Event Number |  |
EVENT_ITEM_BASED_FLAG | VARCHAR2 | 16 |  |  | Item based event flag | DW_YN_LKP_TL | YN_LKP_CODE
EVENT_COMPLETION_DATE | DATE |  |  |  | Event Completion Date |  |
EVENT_DESC | VARCHAR2 | 256 |  |  | Event Description |  |
EVENT_SOURCE | VARCHAR2 | 128 |  |  | Event Source |  |
EVENT_NUM_REVERSED | NUMBER | 38 | 0 |  | Reversed Event Number |  |
EVENT_ORGANIZATION_ID | NUMBER | 38 | 0 |  | The identifier of the organization for the event | DW_INTERNAL_ORG_D | ORGANIZATION_ID
IN_AP_TRANSFER_STATUS_CODE | VARCHAR2 | 16 |  |  | Tax calssification code |  |
RECEIVER_PROJECT_ID | NUMBER | 38 | 0 |  | Receiver Project Identifier for Intercompany invoice. |  |
RECEIVER_TASK_ID | NUMBER | 38 | 0 |  | Receiver Task Identifier for Intercompany invoice. |  |
RECEIVER_EXPENDITURE_ORG_ID | NUMBER | 38 | 0 |  | Receiver Expenditure Organisation Identifier for Intercompany invoice. |  |
RECEIVER_EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Receiver Expenditure Type for Intercompany invoice. |  |
INVOICE_CREATED_BY | VARCHAR2 | 64 |  |  | Invoice Created By | DW_USER_D | USERNAME
INVOICE_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Invoice Creation Date |  |
INVOICE_CREATION_DATE | DATE |  |  |  | Invoice Creation Date | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
INV_DIST_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Invoice Distribution Creation timestamp |  |
INV_DIST_CREATION_DATE | DATE |  |  |  | Invoice Distribution Creation Date | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
INV_DIST_CREATED_BY | VARCHAR2 | 64 |  |  | Invoice Distribution Created By | DW_USER_D | USERNAME
RA_CUSTOMER_TRX_ID | NUMBER | 38 | 0 |  | Receivables Number |  |
AWARD_BUDGET_PERIOD_ID | NUMBER | 38 | 0 |  | Award Budget period identifier. | DW_AWARD_BUDGET_PERIOD_D | AWARD_BUDGET_PERIOD_ID

Copyright © 2019, 2025, Oracle and/or its affiliates.