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