CSE_ASSETS_HIST
The history entity that holds all the physical attributes of the operational asset.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CSE_ASSETS_HIST_PK |
TRANSACTED_ASSET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTED_ASSET_ID | NUMBER | 18 | Yes | The primary key column - Transacted Asset Identifier. | |
| HISTORY_ACTION_CODE | VARCHAR2 | 30 | Actions that can be performed on the asset. Like Create, Update, e.t.c., | ||
| ASSET_ID | NUMBER | 18 | Unique identifier and Primary Key for the asset. System Generated using the Fusion Global Unique ID generator | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ASSET_NUMBER | VARCHAR2 | 80 | An user identifier for the asset object. This is the user primary key for the asset. If user does not enter a value then it is system generated using the Asset Document Number Sequence. | ||
| ASSET_TAG | VARCHAR2 | 240 | Asset Tag. This is an additional way of identifying the asset. | ||
| DESCRIPTION_ASSET_FLAG | VARCHAR2 | 1 | Flag indicating whether the asset created is based just on the description and not an item or product. It is a free format way of defining an asset by not associating it to a product. | ||
| VLD_ORGANIZATION_ID | NUMBER | 18 | The last validation organization used from the source application transaction. | ||
| ITEM_ID | NUMBER | 18 | Product/Item reference as defined in the Fusion Item Master. | ||
| ITEM_ORGANIZATION_ID | NUMBER | 18 | The organization id where this product instance is instantiated. This is usually the context organization when done from the workarea landing page. However transactional instantians will inherit the organization context of the transaction. | ||
| ITEM_REVISION | VARCHAR2 | 18 | The current revision of the product. As captured from the latest transaction. | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | The Serial Number of the product. Which uniquely identifies the product instance that is either manufactured as an end assembly product or as components bought from the supplier. | ||
| LOT_NUMBER | VARCHAR2 | 80 | The unique lot number at the product instance level that tracks the batch of assemblies that are manufactured or procured from supplier. | ||
| GEN_OBJECT_ID | NUMBER | 18 | Genealogy Object Identifier. The foreign key to the genealogy object. | ||
| QUANTITY | NUMBER | Product Instance Quantity. It is always 1 for the serialized product instance. For the lot, it is the lot quantity at the tracked location. | |||
| UOM_CODE | VARCHAR2 | 3 | The primary unit of measure that tracks the product instance quantity. | ||
| SECONDARY_QUANTITY | NUMBER | This is the secondary quantity captured when the item supports dual units of measure. | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | The unit of measure code for the secondary quantity. This is captured only when the item supports dual units of measure. | ||
| STATUS_CODE | VARCHAR2 | 30 | The status of the Asset. Product instance when tracked in the Inventory or WIP location may not have a status to be tracked. | ||
| ACTIVE_END_DATE | TIMESTAMP | The date when the asset is terminated. | |||
| COMPETITOR_ASSET_FLAG | VARCHAR2 | 1 | Flag indicating that this asset is created in the repository just as a competitor asset to aid in the cross selling and up selling functional flows in CRM. | ||
| IOT_ENABLED_FLAG | VARCHAR2 | 1 | This flag indicates whether the asset is enabled to be synced to the IOT application. IOT enabled assets will be automatically synced to the IOT application when the SCM cloud env is wired to the native Oracle Asset Monitoring IOT app. | ||
| CURRENT_LOCATION_CONTEXT | VARCHAR2 | 80 | The current location context. This identifies the asset being located in the work center, inventory, wip job or in a customer location. | ||
| CURRENT_LOCATION_ID | NUMBER | 18 | Current Location Identifier. The address location identifier. | ||
| LOCATION_ORGANIZATION_ID | NUMBER | 18 | The organization id where the asset is located now. This works in conjunction with the other location columns like the work_center_id and the subinventory and locator. | ||
| SUBINVENTORY_CODE | VARCHAR2 | 30 | Subinventory Identifier. The inventory warehouse location. | ||
| INVENTORY_LOCATOR_ID | NUMBER | 18 | The inventory item locator identifier. | ||
| WORK_ORDER_ID | NUMBER | 18 | Work Order Reference when the component is issues to the work order. | ||
| WORK_ORDER_OPERATION_ID | NUMBER | 18 | Work Order Operation Identifier. | ||
| WORK_CENTER_ID | NUMBER | 18 | Work Center Identifier. The foreign key to the work center entity. | ||
| PROJECT_ID | NUMBER | 18 | The foreign key reference to the Project. Assets created from supply chain transactions that are performed in the context of a project will have this value populated. | ||
| TASK_ID | NUMBER | 18 | The foreign key reference to the Project Task. Assets created from supply chain transactions that are performed in the context of a project task will have this value populated. | ||
| EXTERNAL_LOCATION | VARCHAR2 | 240 | An external location which is defined in the third party system and is not a defined location either in TCA or HR fusion system is captured in this column. A free format non translatable value is captured. | ||
| PARTIALLY_FINISHED_FLAG | VARCHAR2 | 1 | Flag indicating whether the assembly serail is still a partially finished assembly. | ||
| UNASSIGNED_FLAG | VARCHAR2 | 1 | A flag that indicates whether the asset is assigned to the parent during the manufacturing process. | ||
| SALES_ORDER_SOURCE_SYSTEM_TYPE | VARCHAR2 | 30 | The type of the source sales order system. | ||
| SALES_ORDER_SOURCE_SYSTEM | VARCHAR2 | 30 | The source sales order system from which the order is captured. | ||
| SALES_ORDER_NUMBER | VARCHAR2 | 120 | The user key to the sales order business object | ||
| SALES_ORDER_ID | NUMBER | 18 | Sales Order Identifier. Foreign key to the FOM Sales Order Entity. | ||
| SALES_ORDER_LINE_NUMBER | VARCHAR2 | 120 | The user key to the sales order lines entity. | ||
| SALES_ORDER_LINE_ID | NUMBER | 18 | Sales Order Line Identifier. Foreign key to the FOM Sales Order Lines entity. | ||
| INSTALLED_LOCATION_CONTEXT | VARCHAR2 | 80 | The installed location context. The type of location where the asset is installed. | ||
| INSTALLED_LOCATION_ID | NUMBER | 18 | Installed Location Identifier. Foreign key to either the hr location or hz location. | ||
| SHIPMENT_DATE | DATE | Date when the asset is shipped to the customer. | |||
| INSTALLED_DATE | DATE | Installation Date. Date when the equipment/asset is installed. | |||
| IN_SERVICE_DATE | DATE | Date when the asset is placed in service. | |||
| PURCHASE_DATE | DATE | Procurement Date. Date when the asset is procured from the Supplier. | |||
| ORIGINATION_DATE | TIMESTAMP | The original creation date of the Lot Number or Serial Number. | |||
| SOLD_BY_BUSINESS_UNIT_ID | NUMBER | 18 | Sold By Business Unit Identifier | ||
| CUSTOMER_ASSET_START_DATE | TIMESTAMP | The date when the customer asset was instantiated. Either during the creation of the asset when the item was set to track customer assets only or updated to the customer asset when the item is enabled for lifecycle tracking. | |||
| CUSTOMER_ASSET_END_DATE | TIMESTAMP | The date when the asset is no longer a customer asset. Either during the return of the asset back to the enterprise for good or when manually terminated from being a customer asset. | |||
| REGISTERED_FLAG | VARCHAR2 | 1 | Flag to indicate if the customer asset is registered or not. | ||
| REGISTRATION_DATE | DATE | Date when the asset is registered as a customer asset. | |||
| CUSTOMER_ID | NUMBER | 18 | Customer Identifier. This is the sold to party id for which the asset is sold to. Sales order issue inventory transaction populates this value by reading this from the shipping details table. | ||
| CUSTOMER_SITE_PARTY_ID | NUMBER | 18 | The ship to party identifier captured at ths shiment transaction. | ||
| CUSTOMER_SITE_ID | NUMBER | 18 | Customer Site Identifier. This is the ship to party site id of the customer that bought the customer asset. | ||
| CUSTOMER_BILLING_PARTY_ID | NUMBER | 18 | The billing party that bought the asset. | ||
| CUSTOMER_BILLING_PARTY_SITE_ID | NUMBER | 18 | The billing party site identifier. This is used in the derivation of the bill to location and there by the address of the billing party. | ||
| CUSTOMER_ACCOUNT_ID | NUMBER | 18 | The billing customer account identifier. | ||
| CUSTOMER_ACCOUNT_SITE_ID | NUMBER | 18 | The customer account site identifier. | ||
| CUSTOMER_ACCOUNT_SITE_USE_ID | NUMBER | 18 | The identifier of the bill to account site use. | ||
| CONTACT_ID | NUMBER | 18 | The contact of the asset. In the case of customer asset, the asset contact could be one of the party contacts that is defined in TCA for the customer that is associated with the asset. In the case of enterprise asset, it is simply an internal employee that is the custodian of the asset. | ||
| SUPPLIER_ID | NUMBER | 18 | Supplier Identifier. The supplier from whom the asset was purchased. | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Supplier Site Identifier. The primary key of the supplier site. | ||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of origin used to stripe the product genealogy data | ||
| NEW_WO_ALLOWED_FLAG | VARCHAR2 | 1 | This flag denotes whether the asset is maintainable or not. When the asset is not maintainable (New WO Allowed Flag = 'N'), a new work order cannot be created for the asset. | ||
| DFLT_WO_TYPE | VARCHAR2 | 30 | The work order type captured at the asset for the purpose of defaulting in the work order when created. | ||
| DFLT_WO_SUB_TYPE | VARCHAR2 | 30 | The work order sub type captured at the asset for the purpose of defaulting in the work order when created. | ||
| MAINTAINABLE_FLAG | VARCHAR2 | 1 | Flag indicating whether the asset is used to drive maintenance management functions. | ||
| OWNED_BY | VARCHAR2 | 1 | Who is the owner of the asset. Values are 'E' for Enterprise and 'C' for Customer. | ||
| USED_BY | VARCHAR2 | 1 | Who is the user of the asset. Values are 'E' for Enterprise and 'C' for Customer. | ||
| PARENT_ORDER_LINE_NUMBER | VARCHAR2 | 120 | The order line number of the parent order line. When assets are created from om integration, the parent order line reference is provided, we capture that against the asset. | ||
| PARENT_ORDER_LINE_ID | NUMBER | 18 | The order line identifier of the parent order line. When assets are created from om integration, the parent order line reference is provided, we capture that against the asset. | ||
| FULFILL_LINE_ID | NUMBER | 18 | The distributed order orchestration fulfillment line reference. | ||
| PARENT_FULFILL_LINE_ID | NUMBER | 18 | The parent fulfillment line reference in the context of the asset that was fulfilled by distributed order orchestration's fulfillment line. | ||
| LOGICAL_FLAG | VARCHAR2 | 1 | Flag to indicate if this asset is for the purpose of logically grouping the tangible or software assets underneath the option class or model to project a sales view of the asset tree. More specifically to present the "As Sold" view. | ||
| SPLIT_FROM_ASSET_ID | NUMBER | 18 | For non serial assets, when assets are split during partial return, the new asset created with the remaining quantity will have the split from asset reference. | ||
| SHIPMENT_ID | NUMBER | 18 | From Outbound Shipments, the delivery_id is captured in this. From Inbound Receipts, the shipment_lind_id is captured here. This is an internal column used for processing. | ||
| SHIPMENT_NUMBER | VARCHAR2 | 30 | The shipment number that is used as the handle in the movement of products from one organization to another using an intransit stop. | ||
| EXTERNAL_SYSTEM_PACKING_UNIT | VARCHAR2 | 150 | The external system packing unit that is gathered from the upstream logistics flows. | ||
| BOM_EXPLOSION_FLAG | VARCHAR2 | 1 | This flag indicates whether this root asset is exploded to create the component assets using the primary item structure of the item at the root asset. This flag is only applicable at the root asset. | ||
| QUANTITY_PER_ASSEMBLY | NUMBER | When this asset is created as a component asset as part of BOM explosion, the quantity per assembly from the item structure is captured here. Asset will be created with the extended quantity for the item structure component. | |||
| RETURN_ORDER_ID | NUMBER | 18 | The return order header identifier. Populated internally by the rma receiving transaction. | ||
| RETURN_ORDER_LINE_ID | NUMBER | 18 | The return order line identifier. Populated internally by the rma receiving transaction. | ||
| RETURN_ORDER_FULFILL_LINE_ID | NUMBER | 18 | The return order fulfillment line identifier. Populated internally by the rma receiving transaction. | ||
| CONFIGURATOR_PATH | VARCHAR2 | 2000 | Configurator runtime representation of the Inventory Item Id path to the component. Path format is "." Separated inventory item id. For multi-instantiable components instances are denoted by [<instance number>]. | ||
| CONFIG_HEADER_ID | NUMBER | 18 | Header identifier of the configuration. | ||
| CONFIG_REVISION_NUMBER | NUMBER | 18 | Revision number of the configuration. | ||
| CRITICALITY_CODE | VARCHAR2 | 30 | The criticality of the asset. Maintenance activities and performance metrics are defined based on the criticality of the asset. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR21 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR22 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR23 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR24 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR25 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR26 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR27 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR28 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR29 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR30 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| EXTN_ATTRIBUTE_CHAR001 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR002 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR003 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR004 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR005 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR006 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR007 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR008 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR009 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR010 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR011 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR012 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR013 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR014 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR015 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR016 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR017 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR018 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR019 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR020 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR021 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR022 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR023 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR024 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR025 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR026 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR027 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR028 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR029 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR030 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR031 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR032 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR033 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR034 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR035 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR036 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR037 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR038 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR039 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR040 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR041 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR042 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR043 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR044 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR045 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR046 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR047 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR048 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR049 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR050 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR051 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR052 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR053 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR054 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR055 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR056 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR057 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR058 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR059 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR060 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR061 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR062 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR063 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR064 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR065 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR066 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR067 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR068 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR069 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR070 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR071 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR072 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR073 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR074 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR075 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR076 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR077 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR078 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR079 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR080 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR081 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR082 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR083 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR084 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR085 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR086 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR087 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR088 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR089 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR090 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR091 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR092 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR093 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR094 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR095 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR096 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR097 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR098 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR099 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR100 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_NUMBER001 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER002 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER003 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER004 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER005 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER006 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER007 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER008 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER009 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER010 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER011 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER012 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER013 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER014 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER015 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER016 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER017 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER018 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER019 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER020 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER021 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER022 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER023 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER024 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER025 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER026 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER027 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER028 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER029 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER030 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER031 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER032 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER033 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER034 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER035 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER036 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER037 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER038 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER039 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER040 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER041 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER042 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER043 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER044 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER045 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER046 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER047 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER048 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER049 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER050 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP001 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP002 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP003 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP004 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP005 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP006 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP007 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP008 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP009 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP010 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CLOB001 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CLOB002 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CLOB003 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CLOB004 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CLOB005 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | currency code for the extensibility | ||
| CORP_CURRENCY_CODE | VARCHAR2 | 15 | corporate currency code for extensibility | ||
| CURCY_CONV_RATE_TYPE | VARCHAR2 | 30 | currency conversion rate type for extensibility | ||
| 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_ASSETS_HIST_N01 | Non Unique | Default | ASSET_ID |
| CSE_ASSETS_HIST_U01 | Unique | Default | TRANSACTED_ASSET_ID |