CSE_FIXED_ASSET_IB_REFS
This table is an internal staging table that stores the received, corrected, or returned item instances for which a fixed asset integration is desired. This is mainly used in the Capitalize at Receipt functional flow. The item involved here could be enabled for operational asset tracking or not.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CSE_FIXED_ASSET_IB_REFS_PK |
IB_REFERENCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| IB_REFERENCE_ID | NUMBER | 18 | Yes | The fixed asset installed base reference identifier. This is the primary key of the entity. | |
| SRC_TRANSACTION_TYPE_ID | VARCHAR2 | 30 | Yes | The transaction type identifier for which the fixed asset interface is required. | |
| SRC_TRANSACTION_ID | NUMBER | 18 | Yes | The transaction id reference from the receiving module. | |
| INTERFACE_STATUS_CODE | VARCHAR2 | 30 | Yes | The interface status code that identifies the various stage of the the interface process. | |
| CSE_TRANSACTION_ID | NUMBER | 18 | The transaction id reference from the installed base module. | ||
| ASSET_ID | NUMBER | 18 | The asset transacted in receiving that needs to be interfaced to fixed asset. This value for a non asset tracked item will be null. | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | The organization where the item instance is received. | |
| ITEM_ID | NUMBER | 18 | Yes | The item transacted in receiving that needs to be interfaced to fixed asset. | |
| SERIAL_NUMBER | VARCHAR2 | 80 | The serial number transacted in receiving that needs to be interfaced to fixed asset. | ||
| LOT_NUMBER | VARCHAR2 | 80 | The serial number transacted in receiving that needs to be interfaced to fixed asset. | ||
| PRIMARY_QUANTITY | NUMBER | Yes | The quantity in primary unit of measure transacted in receiving. | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Yes | The primary unit of measure of the item transacted in receiving. | |
| PO_HEADER_ID | NUMBER | 18 | The purchase order header identifier. | ||
| PO_LINE_ID | NUMBER | 18 | The purchase order line identifier. | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | The purchase order line location identifier. | ||
| PO_DISTRIBUTION_ID | NUMBER | 18 | The purchase order distribution identifier. | ||
| ASSET_COST | NUMBER | The asset cost including the po price, tax, any cost adjustments, and landed costs. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | The currency in which the cost is persisted. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSE_FIXED_ASSET_IB_REFS_N01 | Non Unique | Default | SRC_TRANSACTION_ID, ORGANIZATION_ID |
| CSE_FIXED_ASSET_IB_REFS_N02 | Non Unique | Default | SRC_TRANSACTION_TYPE_ID |
| CSE_FIXED_ASSET_IB_REFS_U01 | Unique | Default | IB_REFERENCE_ID |