[Home] [Help] [Dependency Information]
Object Name: | PA_PROJ_AP_INV_DIST_V1 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_NUMBER | VARCHAR2 | (50) | Yes | Invoice number |
VENDOR_NAME | VARCHAR2 | (240) | Supplier name | |
INVOICE_DATE | DATE | Invoice date | ||
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Yes | Invoice Distribution ID |
DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Yes | Distribution Line Number |
DESCRIPTION | VARCHAR2 | (240) | Description of the invoice distribution | |
GL_DATE | DATE | Yes | The GL date on which the costs are posted, which is entered during invoice entry | |
POSTED_FLAG | VARCHAR2 | (1) | Flag that indicates if invoice distribution has been posted to Oracle General Ledger | |
APPROVED_FLAG | VARCHAR2 | (1) | Indicates if the invoice is approved | |
QUANTITY | NUMBER | Quantity of units as defined by the expenditure type, which is entered for the project-related distribution | ||
DENOM_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Transaction Currency Code of the Invoice |
DENOM_AMOUNT | NUMBER | Invoice amount entered in transaction currency | ||
ACCT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Functional currency code. |
AMOUNT | NUMBER | Invoice amount in functional curency for project-related invoice distribution | ||
ACCT_RATE_DATE | DATE | Conversion date used to convert invoice amount from transaction currency to functional currency . | ||
ACCT_RATE_TYPE | VARCHAR2 | (30) | Conversion type used to convert invoice amount from transaction currency to functional currency . e.g. Spot,Corporate | |
ACCT_EXCHANGE_RATE | NUMBER | Conversion rate used to convert invoice amount from transaction currency to functional currency . | ||
RECEIPT_CURRENCY_CODE | VARCHAR2 | (15) | ||
RECEIPT_CURRENCY_AMOUNT | NUMBER | |||
RECEIPT_EXCHANGE_RATE | NUMBER | |||
PROJECT_NUMBER | VARCHAR2 | (25) | Yes | Project number incurring the charge |
PROJECT_NAME | VARCHAR2 | (30) | Yes | Name of the project incurring the charge |
TASK_NUMBER | VARCHAR2 | (25) | Yes | Number of the lowest level task incurring the charge |
TASK_NAME | VARCHAR2 | (20) | Yes | Name of the lowest level task incurring the charge |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Expenditure type charged | |
EXPENDITURE_CATEGORY | VARCHAR2 | (30) | Yes | The expenditure category of the expenditure type |
REVENUE_CATEGORY | VARCHAR2 | (30) | Yes | The revenue category of the expenditure type |
EXPENDITURE_ITEM_DATE | DATE | The expenditure item date on which you incur the invoice costs | ||
INVOICE_ID | NUMBER | (15) | Yes | The identifier of the invoice |
VENDOR_ID | NUMBER | (15) | The identifier of the vendor | |
PROJECT_ID | NUMBER | (15) | Yes | The identifier of the project |
TASK_ID | NUMBER | (15) | Yes | The identifier of the lowest level task |
EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | The identifier of the expenditure organization | |
RESOURCE_CLASS | CHAR | (18) | Resource Class |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_NUMBER
, VENDOR_NAME
, INVOICE_DATE
, INVOICE_DISTRIBUTION_ID
, DISTRIBUTION_LINE_NUMBER
, DESCRIPTION
, GL_DATE
, POSTED_FLAG
, APPROVED_FLAG
, QUANTITY
, DENOM_CURRENCY_CODE
, DENOM_AMOUNT
, ACCT_CURRENCY_CODE
, AMOUNT
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, RECEIPT_CURRENCY_CODE
, RECEIPT_CURRENCY_AMOUNT
, RECEIPT_EXCHANGE_RATE
, PROJECT_NUMBER
, PROJECT_NAME
, TASK_NUMBER
, TASK_NAME
, EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY
, EXPENDITURE_ITEM_DATE
, INVOICE_ID
, VENDOR_ID
, PROJECT_ID
, TASK_ID
, EXPENDITURE_ORGANIZATION_ID
, RESOURCE_CLASS
FROM APPS.PA_PROJ_AP_INV_DIST_V1;
|
|
|