DW_PROJECT_INVOICE_PRE_ACCPTD_CF

This table stores data for pre accepted 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     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
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    

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