[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EAM_WORK_ORDER_BILLS |
|---|---|
| Object Type: | TABLE |
| Owner: | EAM |
| FND Design Data: |  EAM.EAM_WORK_ORDER_BILLS
|
| Subobject Name: | |
| Status: | VALID |
This table stores the bills created for maintenance work orders. Bills may also be treated as reference invoices and actual invoices may be created through Accounts Receivables. The information in this bill is either populated to the AR interface tables or, for work orders related to contract projects, is transferred to Project Accounting as a manual event. Relevant information within this table includes the work order, customer, billed item, billing basis, billed amount and more.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| EAM_WORK_ORDER_BILLS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 BILLED_INVENTORY_ITEM_ID
ORGANIZATION_ID
WIP_ENTITY_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | (38) | Yes | Inventory Organization ID |
| CUSTOMER_ID | NUMBER | (38) | Customer ID | |
| BILL_TO_ADDRESS_ID | NUMBER | (38) | Customer Billing Address ID | |
| WIP_ENTITY_ID | NUMBER | (38) | Yes | Work Order ID |
| OPERATION_SEQ_NUM | NUMBER | (38) | Operation Sequence Number within Work Order (for "Bill By Requirements" only) | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (38) | Yes | Standard Who Column |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| CREATED_BY | NUMBER | (38) | Yes | Standard Who Column |
| LAST_UPDATE_LOGIN | NUMBER | (38) | Standard Who Column | |
| INVENTORY_ITEM_ID | NUMBER | (38) | Item ID of item desired to be billed. This field is null for Resource Items. If not null, this item may or may not be actually billable, if it is not, BILLED_INVENTORY_ITEM_ID is different from this field, else it is same. | |
| RESOURCE_ID | NUMBER | (38) | Resource ID (Only if Billed Item is of type Labor) | |
| BILLED_INVENTORY_ITEM_ID | NUMBER | (38) | Yes | Item ID of item against which bill is actually cut. This item is always billable and is the one against which the invoice will be created. |
| BILLED_UOM_CODE | VARCHAR2 | (3) | Unit Of Measure Code for Billed Item | |
| BILLED_QUANTITY | NUMBER | Quantity of Billed Item | ||
| BILLING_BASIS | NUMBER | (38) | Billing Basis: 1= Price List, 2= Cost Plus | |
| PRICE_LIST_HEADER_ID | NUMBER | (38) | Header ID of Price List used (only if Billing Basis is 'Price List') | |
| COST_TYPE_ID | NUMBER | (38) | ID of Cost Type for the billed item (only if Billing Basis is 'Cost Plus') | |
| COST_OR_LISTPRICE | NUMBER | (38) | Unit Price for Billed Item | |
| COSTPLUS_PERCENTAGE | NUMBER | (38) | Markup percentage (only if Billing Basis is 'Cost Plus') | |
| BILLED_AMOUNT | NUMBER | Billed Amount for this billed item (BILLED_QUANTITY * COST_OR_LISTPRICE) | ||
| INVOICE_TRX_NUMBER | NUMBER | (38) | Header Number for Reference Invoice related to this billed item | |
| INVOICE_LINE_NUMBER | NUMBER | (38) | Line Number for Reference Invoice related to this billed item | |
| CURRENCY_CODE | VARCHAR2 | (15) | Billed Currency Code | |
| CONVERSION_RATE | NUMBER | (38) | Currency Conversion Rate | |
| CONVERSION_TYPE_CODE | VARCHAR2 | (30) | Currenct ConversionType Code | |
| CONVERSION_RATE_DATE | DATE | Date on which the Currency Conversion is done | ||
| PROJECT_ID | NUMBER | (38) | ID of Project to be billed to (for Work Orders related to Contract Projects) | |
| TASK_ID | NUMBER | (38) | ID of Task to be billed to (for Work Orders related to Contract Projects) | |
| WORK_REQUEST_ID | NUMBER | (38) | ID of Work Request associated with billed work order | |
| PA_EVENT_ID | NUMBER | (38) | ID of Manual Project Accounting Event (for Work Orders related to Contract Projects) | |
| BILLING_METHOD | NUMBER | Billing Method: 1=Bill By Requirements, 2=Bill By Activity | ||
| OVERRIDE_BILL_AMOUNT | VARCHAR2 | (1) | Reserved for future use | |
| DYNAMIC_BILLING_ACTIVITY | VARCHAR2 | (1) | Reserved for future use | |
| MASS_ADDITION_ID | NUMBER | Unique identifier to search the status of Cost Adjustment in Oracle Assets | ||
| CAPITALIZATION_DATE | DATE | Date on which Capitalization was carried out. This column is just for information purpose to know when the capitalization was carried out. User wont be able fa_mass_additions based on this | ||
| COMMENTS | VARCHAR2 | (64) | This column will be used to store the indentifier that can be used to query the corresponding transactionin Oracle Assets.It will have the concatenated value Work Order:Organization:Dept:Work Order Description | |
| FIXED_ASSET_NUMBER | NUMBER | This can be used for querying the Oracle Assets for the posted transaction. | ||
| OFFSET_ACCOUNT_CCID | VARCHAR2 | (1000) | Used to post the Offset Account Id to fa_mass_additions table |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, CUSTOMER_ID
, BILL_TO_ADDRESS_ID
, WIP_ENTITY_ID
, OPERATION_SEQ_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, INVENTORY_ITEM_ID
, RESOURCE_ID
, BILLED_INVENTORY_ITEM_ID
, BILLED_UOM_CODE
, BILLED_QUANTITY
, BILLING_BASIS
, PRICE_LIST_HEADER_ID
, COST_TYPE_ID
, COST_OR_LISTPRICE
, COSTPLUS_PERCENTAGE
, BILLED_AMOUNT
, INVOICE_TRX_NUMBER
, INVOICE_LINE_NUMBER
, CURRENCY_CODE
, CONVERSION_RATE
, CONVERSION_TYPE_CODE
, CONVERSION_RATE_DATE
, PROJECT_ID
, TASK_ID
, WORK_REQUEST_ID
, PA_EVENT_ID
, BILLING_METHOD
, OVERRIDE_BILL_AMOUNT
, DYNAMIC_BILLING_ACTIVITY
, MASS_ADDITION_ID
, CAPITALIZATION_DATE
, COMMENTS
, FIXED_ASSET_NUMBER
, OFFSET_ACCOUNT_CCID
FROM EAM.EAM_WORK_ORDER_BILLS;
EAM.EAM_WORK_ORDER_BILLS does not reference any database object
EAM.EAM_WORK_ORDER_BILLS is referenced by following:
EAM
EAM_WORK_ORDER_BILLS#
|
|
|
|