This table stores data for pre accepted invoice distributions generated for expenditure items and billing events
Module: Project Billing
INVOICE_DIST_ID
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 | 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 | 16 | 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, 2023, Oracle and/or its affiliates.