[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_DRAFT_INVOICE_ITEMS |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_DRAFT_INVOICE_ITEMS
|
| Subobject Name: | |
| Status: | VALID |
PA_DRAFT_INVOICE_ITEMS stores the lines of a draft invoice. The
Generate Draft Invoice process creates an invoice line for each
billing event and for each grouping of expenditure items.
Groupings of expenditure items are determined by a
project's invoice formats.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_DRAFT_INVOICE_ITEMS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PROJECT_ID
DRAFT_INVOICE_NUM
LINE_NUM
|
| PA_DRAFT_INVOICE_ITEMS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TASK_ID
|
| PA_DRAFT_INVOICE_ITEMS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
EVENT_NUM
EVENT_TASK_ID
TASK_ID
|
| PA_DRAFT_INVOICE_ITEMS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
REQUEST_ID
|
| PA_DRAFT_INVOICE_ITEMS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SHIP_TO_ADDRESS_ID
|
| PA_DRAFT_INVOICE_ITEMS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROGRAM_ID
RETN_DRAFT_INVOICE_NUM
RETN_DRAFT_INVOICE_LINE_NUM
|
| PA_DRAFT_INVOICE_ITEMS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
TASK_ID
FUNDING_CURRENCY_CODE
INVOICE_LINE_TYPE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT_ID | NUMBER | (15) | Yes | The identifier of the project for which the invoice is generated |
| DRAFT_INVOICE_NUM | NUMBER | (15) | Yes | The draft invoice number to which the invoice line belongs |
| LINE_NUM | NUMBER | (15) | Yes | The sequential number that identifies and orders the draft invoice item for a draft invoice |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| AMOUNT | NUMBER | (22) | Yes | The amount to be billed for the draft invoice item |
| TEXT | VARCHAR2 | (240) | Yes | The invoice line description. For a line billing an event, this description is the event description. For a line billing expenditure items, this description is formatted according to the project invoice formats |
| INVOICE_LINE_TYPE | VARCHAR2 | (30) | Yes | The type of draft invoice line |
| REQUEST_ID | NUMBER | (15) | Standard Who Column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who Column | |
| PROGRAM_ID | NUMBER | (15) | Standard Who Column | |
| PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
| UNEARNED_REVENUE_CR | NUMBER | (22) | No longer used | |
| UNBILLED_RECEIVABLE_DR | NUMBER | (22) | No longer used | |
| TASK_ID | NUMBER | (15) | The identifier of the top task. This column is populated if: the project is funded at top task level, or for expenditure item lines, the invoice format groups by Top Task, or for event lines, both invoice formats group by Top Task | |
| EVENT_TASK_ID | NUMBER | (15) | The identifier of the task id to which the event, billed by the invoice line, is assigned | |
| EVENT_NUM | NUMBER | (15) | The event number that is billed by the invoice line | |
| SHIP_TO_ADDRESS_ID | NUMBER | (15) | The identifier of the ship-to address and used for taxation. This column is populated only if the invoice formats groups by work site and for events using the work site of the event task | |
| TAXABLE_FLAG | VARCHAR2 | (1) | Obsolete | |
| DRAFT_INV_LINE_NUM_CREDITED | NUMBER | (15) | The draft invoice line number that is credited by this invoice line | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| INV_AMOUNT | NUMBER | The amount to be billed in the invoicing currency code for the draft invoice item. | ||
| OUTPUT_VAT_TAX_ID | NUMBER | Identifier for default output tax code | ||
| OUTPUT_TAX_EXEMPT_FLAG | VARCHAR2 | (1) | Standard, Exempt, or required Allows the user to use Standard Exemption rules, force an exemption or require tax to a normally exempt invoice This is defaulted based on user setup | |
| OUTPUT_TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax Exempt Reason for item lines that have tax_exempt_flag set to (E-exempt) | |
| OUTPUT_TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | Exemption Certificate Number for item lines that have tax_exempt_flag set to (E-exempt) | |
| ACCT_AMOUNT | NUMBER | The Functional Currency amount of that has been accounted in Oracle ReceivablesThis column is populated in the Transfer Invoice to Oracle Receivables process | ||
| ROUNDING_AMOUNT | NUMBER | The Functional Rounding amount This column is populated in the Transfer Invoice to Oracle Receivables process | ||
| UNBILLED_ROUNDING_AMOUNT_DR | NUMBER | The Functional Currency Unbilled Receivable Rounding amount This column is populated in the Transfer Invoice to Oracle Receivables process | ||
| UNEARNED_ROUNDING_AMOUNT_CR | NUMBER | The Functional Currency Unearned Revenue Rounding amount This column is populated in the Transfer Invoice to Oracle Receivables process | ||
| TRANSLATED_TEXT | VARCHAR2 | (240) | The translated text of the invoice line.This will be in the language defined in invoice header. | |
| CC_REV_CODE_COMBINATION_ID | NUMBER | Identifier of the GL account for intercompany revenue. Used only for intercompany invoices | ||
| CC_PROJECT_ID | NUMBER | Identifier of the cross charged project for which the invoice line was created This is populated for intercompany invoices only | ||
| CC_TAX_TASK_ID | NUMBER | Identifier of the task on which non-recoverable tax for the cross charged project will be charged | ||
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | Project functional currency code | |
| PROJFUNC_BILL_AMOUNT | NUMBER | Bill Amount in the project functional currency. This is calculated by applying the conversion rules set up for project functional currency during invoice generation. | ||
| PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Bill Amount in the project currency. This is calculated by applying the conversion rules set up for project currency during invoice generation. | |
| PROJECT_BILL_AMOUNT | NUMBER | Bill Amount in the project currency. This is calculated by applying the conversion rules set up for project currency during invoice generation. | ||
| FUNDING_CURRENCY_CODE | VARCHAR2 | (15) | Funding currency code | |
| FUNDING_BILL_AMOUNT | NUMBER | Bill Amount in the funding currency. This is calculated by applying the conversion rules set up for funding currency during invoice generation. | ||
| FUNDING_RATE_DATE | DATE | Exchange rate date to use for conversion from bill transaction currency to funding currency if Fixed Date rate date type is used during invoice generation (only for events | ||
| FUNDING_EXCHANGE_RATE | NUMBER | Exchange rate to use for conversion from bill transaction currency to funding currency during invoice generation (only for events) | ||
| FUNDING_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type to use for conversion from bill transaction currency to funding currency during invoice generation (only for events) | |
| INVPROC_CURRENCY_CODE | VARCHAR2 | (15) | Invoice processing currency code | |
| BILL_TRANS_CURRENCY_CODE | VARCHAR2 | (15) | Transaction currency code | |
| BILL_TRANS_BILL_AMOUNT | NUMBER | Bill Amount in the transaction currency. This is calculated by applying the conversion rules set up for transaction currency during invoice generation. | ||
| RETN_BILLING_METHOD | VARCHAR2 | (30) | This indicates how the retention invoice is generated. Applicable only for retention invoices. | |
| RETN_PERCENT_COMPLETE | NUMBER | Audit column for percent complete percentage. Applicable only if the billing method is "Percent Complete". | ||
| RETN_TOTAL_RETENTION | NUMBER | Audit column for total retention amount . Applicable only if the billing method is total retention amount. | ||
| RETN_BILLING_CYCLE_ID | NUMBER | (15) | Audit column for billing cycle method. Applicable only if the billing method is retention billing cycle. This is the billing cycle method which is used to derive the retention billing percentage or retention billing amount. | |
| RETN_CLIENT_EXTENSION_FLAG | VARCHAR2 | (1) | Audit column for client extension flag. Applicable only if the invoice is retention invoice. | |
| RETN_BILLING_PERCENTAGE | NUMBER | Audit column for billing percentage which is used to bill the retained amount by applying on total unbilled retained amount. Applicable only if the invoice is retention invoice. | ||
| RETN_BILLING_AMOUNT | NUMBER | Audit column for retention billing amount. this is amount which is used to bill the retained amount. Applicable only if the invoice is retention invoice. | ||
| RETENTION_RULE_ID | NUMBER | (15) | Audit column for retention setup. Applicable only if the invoice is project invoice and invoice line type is retention. | |
| RETAINED_AMOUNT | NUMBER | Retained Amount for only Events | ||
| RETN_DRAFT_INVOICE_NUM | NUMBER | Project Invoice number. Applicable for Events only.This will be used to drilldown the retention line from invoice review screen. | ||
| RETN_DRAFT_INVOICE_LINE_NUM | NUMBER | Project Invoice retention line number. This will be used to drilldown the retention line from invoice review screen. | ||
| CREDIT_AMOUNT | NUMBER | Line level credit amount used during the credit invoice processing. Applicable only for concession and write off line level credits. | ||
| CREDIT_PROCESS_FLAG | VARCHAR2 | (1) | Flag indicating whether the invoice line is selected for credit invoice processing. Applicable only for concession and write off line level credits. | |
| OUTPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | (50) | eTax change | |
| INV_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type used to convert the amount from IPC to IC. | |
| INV_RATE_DATE | DATE | Exchange rate date used to convert the amount from IPC to IC. | ||
| INV_EXCHANGE_RATE | NUMBER | Exchange rate used to convert the amount from IPC to IC. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE21 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE22 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE23 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE24 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE25 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE26 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE27 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE28 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE29 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE30 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| PROVIDER_ORGANIZATION_ID | NUMBER | (15) | This is the ID of the Provider Organization. | |
| RECEIVER_ORGANIZATION_ID | NUMBER | (15) | This is the ID of the Receiver Organization. |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, DRAFT_INVOICE_NUM
, LINE_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, AMOUNT
, TEXT
, INVOICE_LINE_TYPE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, UNEARNED_REVENUE_CR
, UNBILLED_RECEIVABLE_DR
, TASK_ID
, EVENT_TASK_ID
, EVENT_NUM
, SHIP_TO_ADDRESS_ID
, TAXABLE_FLAG
, DRAFT_INV_LINE_NUM_CREDITED
, LAST_UPDATE_LOGIN
, INV_AMOUNT
, OUTPUT_VAT_TAX_ID
, OUTPUT_TAX_EXEMPT_FLAG
, OUTPUT_TAX_EXEMPT_REASON_CODE
, OUTPUT_TAX_EXEMPT_NUMBER
, ACCT_AMOUNT
, ROUNDING_AMOUNT
, UNBILLED_ROUNDING_AMOUNT_DR
, UNEARNED_ROUNDING_AMOUNT_CR
, TRANSLATED_TEXT
, CC_REV_CODE_COMBINATION_ID
, CC_PROJECT_ID
, CC_TAX_TASK_ID
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_BILL_AMOUNT
, PROJECT_CURRENCY_CODE
, PROJECT_BILL_AMOUNT
, FUNDING_CURRENCY_CODE
, FUNDING_BILL_AMOUNT
, FUNDING_RATE_DATE
, FUNDING_EXCHANGE_RATE
, FUNDING_RATE_TYPE
, INVPROC_CURRENCY_CODE
, BILL_TRANS_CURRENCY_CODE
, BILL_TRANS_BILL_AMOUNT
, RETN_BILLING_METHOD
, RETN_PERCENT_COMPLETE
, RETN_TOTAL_RETENTION
, RETN_BILLING_CYCLE_ID
, RETN_CLIENT_EXTENSION_FLAG
, RETN_BILLING_PERCENTAGE
, RETN_BILLING_AMOUNT
, RETENTION_RULE_ID
, RETAINED_AMOUNT
, RETN_DRAFT_INVOICE_NUM
, RETN_DRAFT_INVOICE_LINE_NUM
, CREDIT_AMOUNT
, CREDIT_PROCESS_FLAG
, OUTPUT_TAX_CLASSIFICATION_CODE
, INV_RATE_TYPE
, INV_RATE_DATE
, INV_EXCHANGE_RATE
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE21
, GLOBAL_ATTRIBUTE22
, GLOBAL_ATTRIBUTE23
, GLOBAL_ATTRIBUTE24
, GLOBAL_ATTRIBUTE25
, GLOBAL_ATTRIBUTE26
, GLOBAL_ATTRIBUTE27
, GLOBAL_ATTRIBUTE28
, GLOBAL_ATTRIBUTE29
, GLOBAL_ATTRIBUTE30
, PROVIDER_ORGANIZATION_ID
, RECEIVER_ORGANIZATION_ID
FROM PA.PA_DRAFT_INVOICE_ITEMS;
PA.PA_DRAFT_INVOICE_ITEMS does not reference any database object
PA.PA_DRAFT_INVOICE_ITEMS is referenced by following:
PA
PA_DRAFT_INVOICE_ITEMS#
|
|
|
|