PJC_ASSET_INT
PJC_ASSET_INT stores information about assets imported using FBDI.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJC_ASSET_INT_PK |
ASSET_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ASSET_INTERFACE_ID | NUMBER | 18 | Yes | System generated identifier that uniquely identifies an imported asset. | |
| IB_REFERENCE_ID | NUMBER | 18 | The installed base asset reference identifier. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifier of the inventory item that will be created as an asset. | ||
| AP_INVOICE_DISTRIBUTION_ID | NUMBER | 18 | The accounts payables invoice distribution identifier. This is used to associate eligible project related non-accrual expense costs to an asset or assets. | ||
| CST_TRANSACTION_ID | NUMBER | 18 | The transaction identifier of a supply chain inventory cost transaction. This is used to associate eligible project related inventory costs to an asset or assets. | ||
| PO_DISTRIBUTION_ID | NUMBER | 18 | The identifier of a purchase order distribution that is populated by the Installed Base product that belongs to Oracle Fusion Maintenance. This is used to associate project related expense accrual variances to an asset or assets. Applies for both 2-way and 3-way invoice match options. | ||
| PROJECT_ASSET_ID | NUMBER | 18 | The system-generated number that uniquely identifies the asset. | ||
| RECEIPT_TRANSACTION_ID | NUMBER | 18 | The parent or root transaction identifier of a purchase order receipt. This is used to associate project related expense accrual variances to an asset or assets. Applies only for a 3-way invoie match option. | ||
| DELIVER_TRANSACTION_ID | NUMBER | 18 | The transaction identifier of a supply chain receipt delivery transaction. This is used to associate eligible project related accrual expense costs to an asset or assets. | ||
| ASSET_SOURCE | VARCHAR2 | 20 | The Oracle Fusion source document from which the automatic creation of the asset originated. Eligible source documents are Oracle Fusion Supply Chain expense, inventory receipts and Oracle Fusion Payables invoices. | ||
| BATCH_NAME | VARCHAR2 | 50 | User-entered name for a grouping of assets in the interface table. | ||
| ASSET_NAME | VARCHAR2 | 240 | User-defined name that uniquely identifies an asset within a project. | ||
| ASSET_NUMBER | VARCHAR2 | 30 | Unique asset identifier; can be user-entered or system-generated by Oracle Assets. | ||
| ASSET_DESCRIPTION | VARCHAR2 | 80 | Description; placed on parent mass additions line upon transfer to Oracle Assets. | ||
| STATUS_CODE | VARCHAR2 | 1 | Yes | Processing status. P- Pending, S-Success,R-Rejected, T-Transferred. | |
| PROCESSING_MODE | VARCHAR2 | 10 | Yes | Processing Mode-Create/Update/Delete. | |
| PROJECT_ID | NUMBER | 18 | The identifier of the project to which this asset belongs. | ||
| PROJECT_NAME | VARCHAR2 | 240 | The name of the project to which the asset belongs. | ||
| PROJECT_NUMBER | VARCHAR2 | 25 | The number of the project to which the asset belongs. | ||
| PROJECT_ASSET_TYPE | VARCHAR2 | 30 | Project Asset Classification. Default value is ESTIMATED. | ||
| LOCATION_ID | NUMBER | 18 | The identifier of the location to which the asset is assigned. | ||
| LOCATION | VARCHAR2 | 300 | The location of the project to which the asset belongs. | ||
| ASSIGNED_TO_PERSON_ID | NUMBER | 18 | The identifier of the employee to whom the asset is assigned. | ||
| ASSIGNED_TO_PERSON_NAME | VARCHAR2 | 2000 | The name of the employee to whom the asset is assigned. | ||
| ASSIGNED_TO_PERSON_NUMBER | VARCHAR2 | 30 | The number of the employee to whom the asset is assigned. | ||
| DATE_PLACED_IN_SERVICE | DATE | Date in which the asset has been placed in service. | |||
| ASSET_UNITS | NUMBER | The number of asset units. | |||
| ESTIMATED_IN_SERVICE_DATE | DATE | The asset's estimated date placed in service. | |||
| ESTIMATED_COST | NUMBER | Estimated Asset Cost. | |||
| ESTIMATED_ASSET_UNITS | NUMBER | Estimated Asset Units. | |||
| ASSET_CATEGORY_ID | NUMBER | 18 | The identifier of the asset category to which the asset is assigned. | ||
| ASSET_CATEGORY | VARCHAR2 | 300 | The asset category of the project to which the asset belongs. | ||
| ASSET_KEY_CCID | NUMBER | 18 | Key flexfield code combination identifier for asset key flexfield. | ||
| ASSET_KEY | VARCHAR2 | 325 | Asset Key. | ||
| BOOK_TYPE_CODE | VARCHAR2 | 30 | The corporate book to which the asset is assigned. | ||
| BOOK_TYPE | VARCHAR2 | 30 | The value of the book type entered. | ||
| DEPRECIATE_FLAG | VARCHAR2 | 1 | Indicates whether or not the asset should be depreciated in Oracle Assets. | ||
| DEPRECIATION_EXPENSE_CCID | NUMBER | 18 | The identifier of the depreciation expense account for the asset. | ||
| DEPRECIATION_EXPENSE_ACCT | VARCHAR2 | 1000 | Depreciation Expense Account Segments. | ||
| AMORTIZE_FLAG | VARCHAR2 | 1 | Indicates whether or not cost adjustments should be amortized in Oracle Assets. | ||
| COST_ADJUSTMENT_FLAG | VARCHAR2 | 1 | Indicates whether asset cost adjustments have been interfaced to Oracle Assets. | ||
| PM_PRODUCT_CODE | VARCHAR2 | 30 | The identifier of the external project management system from which the project was imported. | ||
| PM_ASSET_REFERENCE | VARCHAR2 | 240 | The identifier of the project in the external project management system from which the project was imported. | ||
| MANUFACTURER_NAME | VARCHAR2 | 30 | Name of the Asset Manufacturer. | ||
| MODEL_NUMBER | VARCHAR2 | 40 | Model Number of the Asset. | ||
| TAG_NUMBER | VARCHAR2 | 15 | Tag Number of the Asset. | ||
| SERIAL_NUMBER | VARCHAR2 | 35 | Serial Number of the Asset. | ||
| CAPITAL_HOLD_FLAG | VARCHAR2 | 1 | Capital Hold Flag. | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| PARENT_ASSET_ID | NUMBER | 18 | Parent Asset Identifier. | ||
| PARENT_ASSET_NAME | VARCHAR2 | 240 | Parent Asset Name. | ||
| PARENT_ASSET_NUMBER | VARCHAR2 | 30 | Parent Asset Number. | ||
| RET_TARGET_ASSET_ID | NUMBER | 18 | Identifies the asset to be adjusted as retirement costs are processed. | ||
| RET_TARGET_ASSET_NAME | VARCHAR2 | 240 | Retirement Target Asset Name. | ||
| RET_TARGET_ASSET_NUMBER | VARCHAR2 | 30 | Retirement Target Asset Number. | ||
| NEW_MASTER_FLAG | VARCHAR2 | 1 | Determines whether Oracle Assets will reclassify asset based on cost adjustment. | ||
| REVERSE_FLAG | VARCHAR2 | 1 | Indicates whether the asset will be reversed in the next Generate Asset Lines run. | ||
| REVERSAL_DATE | DATE | The last date reversing asset lines were created. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| CAPITALIZED_FLAG | VARCHAR2 | 1 | Indicates whether or not the asset has been interfaced to Oracle Assets. | ||
| CAPITALIZED_DATE | DATE | The last date non-reversing cost adjustments were interfaced to Oracle Assets. | |||
| CAPITALIZED_COST | NUMBER | The cost amount which has been interfaced to Oracle Assets for capitalization. | |||
| CAPITAL_EVENT_ID | NUMBER | 18 | Capital Event Identifier. | ||
| CAPITAL_EVENT_NAME | VARCHAR2 | 240 | User defined capital event name. | ||
| CAPITAL_EVENT_NUMBER | NUMBER | 18 | Number that identifies the event within the Project. | ||
| GROUPED_CIP_COST | NUMBER | The asset's cost amount which has been grouped into asset lines. | |||
| FA_PERIOD_NAME | VARCHAR2 | 15 | Asset book depreciation calendar period name to which the asset was posted. | ||
| FA_ASSET_ID | NUMBER | 18 | Identifier of an asset that exists in Fixed Assets. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PREV_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the previous request ID of the job that processed this record. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that loaded this record. | |
| PROCESS_GROUP_ID | NUMBER | 18 | Identifier on each record to group a batch of records for parallel processing. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ASSOCIATE_FA_TO_PPM_ASSET | VARCHAR2 | 1 | Flag indicating that the asset number recorded exists in Fixed Assets. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJC_ASSET_INT_N1 | Non Unique | Default | BATCH_NAME |
| PJC_ASSET_INT_N2 | Non Unique | Default | PROJECT_NUMBER |
| PJC_ASSET_INT_N3 | Non Unique | Default | PROCESS_GROUP_ID, STATUS_CODE |
| PJC_ASSET_INT_N4 | Non Unique | Default | REQUEST_ID |
| PJC_ASSET_INT_N5 | Non Unique | Default | PROJECT_ASSET_ID |
| PJC_ASSET_INT_N6 | Non Unique | Default | ASSET_NAME, PROJECT_ID |
| PJC_ASSET_INT_N7 | Non Unique | Default | ASSET_NUMBER |
| PJC_ASSET_INT_U1 | Unique | Default | ASSET_INTERFACE_ID |