[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_DRAFT_INV_DETS_AR |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_DRAFT_INV_DETS_AR
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_DRAFT_INV_DETS_AR_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 PURGE_PROJECT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PURGE_BATCH_ID | NUMBER | (15) | Yes | Purge batch Id |
| ACCT_CURRENCY_CODE | VARCHAR2 | (15) | Functional currency code of the provider operating unit | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| LINE_NUM | NUMBER | (22) | The sequential line number that identifies the invoice detail for an expenditure item | |
| LINE_NUM_REVERSED | NUMBER | (22) | The invoice detail line number for the same expenditure item that is reversed by this invoice detail line | |
| MARKUP_CALC_BASE_CODE | VARCHAR2 | (1) | Audit column. Transaction amount on which the cross charge rate will be based. | |
| ORG_ID | NUMBER | (15) | Identifier of the Operating Unit to which the detail line belongs | |
| ORIG_DRAFT_INVOICE_LINE_NUM | NUMBER | (22) | Draft Invoice Number on which the reversed line is invoiced. The column is populated for reversing lines only. | |
| ORIG_DRAFT_INVOICE_NUM | NUMBER | (22) | Draft Invoice Number on which the reversed line is invoiced. The column is populated for reversing lines only. | |
| 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_NUMBER | VARCHAR2 | (80) | Exemption Certificate Number for lines that have tax_exempt_flag set to (E-exempt) | |
| OUTPUT_TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax Exempt Reason for lines that have tax_exempt_flag set to (E-exempt) | |
| OUTPUT_VAT_TAX_ID | NUMBER | (15) | Identifier for default output tax code | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who Column | |
| PROGRAM_ID | NUMBER | (15) | Standard Who Column | |
| PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
| PROJACCT_BILL_AMOUNT | NUMBER | (22) | Transfer price amount in the project functional currency. This currency amount does not have other currency attributes since it is determined by proration. This column is for future use | |
| PROJACCT_COST_AMOUNT | NUMBER | (22) | Cost amount at the time of creating the invoice detail in the project currency. This column is for future use | |
| PROJACCT_CURRENCY_CODE | VARCHAR2 | (15) | Functional currency code of the receiver operating unit. Populated but not currently used | |
| PROJECT_ID | NUMBER | (15) | Identifier of the project which will be used to bill the transaction For cross charged transactions, this is the intercompany billing project | |
| PROJECT_TP_CURRENCY_CODE | VARCHAR2 | (15) | The currency code of the operating unit that owns the project for transfer price | |
| PROJECT_TP_RATE_DATE | DATE | Rate date used to convert raw and burdened cost from transaction currency to project currency | ||
| PROJECT_TP_RATE_TYPE | VARCHAR2 | (30) | Rate type used to convert raw and burdened cost from transaction currency to project currency | |
| PROJECT_TRANSFER_PRICE | NUMBER | (22) | Transfer price in project currency. | |
| PROJFUNC_TP_CURRENCY_CODE | VARCHAR2 | (15) | The currency code of the operating unit that owns the project for transfer price | |
| PROJFUNC_TP_EXCHANGE_RATE | NUMBER | (22) | Exchange rate for the project functional currency for the transafer price for OU | |
| PROJFUNC_TP_RATE_DATE | DATE | Rate date used to convert raw and burdened cost from transaction currency to project currency for OU | ||
| PROJFUNC_TP_RATE_TYPE | VARCHAR2 | (30) | Rate type used to convert raw and burdened cost from transaction currency to project currency for OU | |
| PROJFUNC_TRANSFER_PRICE | NUMBER | (22) | Transfer price in project functional | |
| PROV_PROJ_BILL_JOB_ID | NUMBER | (15) | Provider project bill job id | |
| PURGE_PROJECT_ID | NUMBER | (15) | Yes | Purged project Id |
| PURGE_RELEASE | VARCHAR2 | (50) | Yes | Purge release version |
| REQUEST_ID | NUMBER | (15) | Identifier of the concurrent program that last processed the item | |
| REVERSED_FLAG | VARCHAR2 | (1) | Indicates whether the line has been reversed | |
| REV_CODE_COMBINATION_ID | NUMBER | (15) | Identifier of the GL account for intercompany revenue associated with the transaction | |
| RULE_PERCENTAGE | NUMBER | (22) | Audit column. Percentage applied to the calculated transfer price from the rule definition | |
| SCHEDULE_LINE_PERCENTAGE | NUMBER | (22) | Audit column. Percentage applied to the calculated transfer price from the schedule line | |
| TP_AMT_TYPE_CODE | VARCHAR2 | (30) | Transfer price amount type code | |
| TP_JOB_ID | NUMBER | (15) | Transfer price job id. | |
| ACCT_EXCHANGE_RATE | NUMBER | (22) | Exchange rate used to convert the transfer price from the transaction currency to the functional currency | |
| ACCT_RATE_DATE | DATE | Rate date used to convert the transfer price from the transaction currency to the functional currency. Derived from the implementation options currency rate date code for transfer price conversion | ||
| ACCT_RATE_TYPE | VARCHAR2 | (30) | Rate type used to convert the transfer price from the transaction currency to the functional currency. Defaulted from the implementation options currency conversion attributes for transfer price | |
| BASE_AMOUNT | NUMBER | (22) | Audit column. Base amount used to derive the bill amount held in transaction currency | |
| BILL_AMOUNT | NUMBER | (22) | Functional currency amount of the transfer price | |
| BILL_MARKUP_PERCENTAGE | NUMBER | (22) | Audit column. Percentage used in deriving the transfer price if the transfer price was based on a markup in bill rate schedule | |
| BILL_RATE | NUMBER | (22) | 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 | |
| CC_PROJECT_ID | NUMBER | (15) | Identifier of the cross charged project for the transaction. | |
| CC_TAX_TASK_ID | NUMBER | (15) | Identifier of the task id used to capture non-recoverable tax on the cross charged project | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| DENOM_BILL_AMOUNT | NUMBER | (22) | Transaction amount of the transfer price | |
| DENOM_CURRENCY_CODE | VARCHAR2 | (15) | Transaction currency code of the transfer price | |
| DETAIL_ID_REVERSED | NUMBER | (22) | Identifier of the detail line that the line reverses. | |
| DRAFT_INVOICE_DETAIL_ID | NUMBER | (15) | The system generated number that uniquely identifies the invoice detail | |
| DRAFT_INVOICE_LINE_NUM | NUMBER | (22) | Line number in the draft invoice in which the invoice detail is billed | |
| DRAFT_INVOICE_NUM | NUMBER | (22) | Invoice number of the draft invoice in which the invoice detail is billed | |
| EXPENDITURE_ITEM_ID | NUMBER | (15) | Identifier of the Expenditure Item to which the distribution belongs | |
| IND_COMPILED_SET_ID | NUMBER | (15) | Audit column. Identifier of the burden compiled set if a burden schedule is used in determining the transfer price | |
| INVOICED_FLAG | VARCHAR2 | (1) | Indicates whether the detail line has been invoiced(included on an invoice). Default value is 'N'. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| PROJECT_TP_EXCHANGE_RATE | NUMBER | (22) | Exchange rate for the project functional currency for the transafer price | |
| OUTPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | (50) | eTax change |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_BATCH_ID
, ACCT_CURRENCY_CODE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_NUM
, LINE_NUM_REVERSED
, MARKUP_CALC_BASE_CODE
, ORG_ID
, ORIG_DRAFT_INVOICE_LINE_NUM
, ORIG_DRAFT_INVOICE_NUM
, OUTPUT_TAX_EXEMPT_FLAG
, OUTPUT_TAX_EXEMPT_NUMBER
, OUTPUT_TAX_EXEMPT_REASON_CODE
, OUTPUT_VAT_TAX_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJACCT_BILL_AMOUNT
, PROJACCT_COST_AMOUNT
, PROJACCT_CURRENCY_CODE
, PROJECT_ID
, PROJECT_TP_CURRENCY_CODE
, PROJECT_TP_RATE_DATE
, PROJECT_TP_RATE_TYPE
, PROJECT_TRANSFER_PRICE
, PROJFUNC_TP_CURRENCY_CODE
, PROJFUNC_TP_EXCHANGE_RATE
, PROJFUNC_TP_RATE_DATE
, PROJFUNC_TP_RATE_TYPE
, PROJFUNC_TRANSFER_PRICE
, PROV_PROJ_BILL_JOB_ID
, PURGE_PROJECT_ID
, PURGE_RELEASE
, REQUEST_ID
, REVERSED_FLAG
, REV_CODE_COMBINATION_ID
, RULE_PERCENTAGE
, SCHEDULE_LINE_PERCENTAGE
, TP_AMT_TYPE_CODE
, TP_JOB_ID
, ACCT_EXCHANGE_RATE
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, BASE_AMOUNT
, BILL_AMOUNT
, BILL_MARKUP_PERCENTAGE
, BILL_RATE
, CC_PROJECT_ID
, CC_TAX_TASK_ID
, CREATED_BY
, CREATION_DATE
, DENOM_BILL_AMOUNT
, DENOM_CURRENCY_CODE
, DETAIL_ID_REVERSED
, DRAFT_INVOICE_DETAIL_ID
, DRAFT_INVOICE_LINE_NUM
, DRAFT_INVOICE_NUM
, EXPENDITURE_ITEM_ID
, IND_COMPILED_SET_ID
, INVOICED_FLAG
, LAST_UPDATED_BY
, PROJECT_TP_EXCHANGE_RATE
, OUTPUT_TAX_CLASSIFICATION_CODE
FROM PA.PA_DRAFT_INV_DETS_AR;
PA.PA_DRAFT_INV_DETS_AR does not reference any database object
PA.PA_DRAFT_INV_DETS_AR is referenced by following:
APPS
PA_DRAFT_INV_DETS_AR
|
|
|
|