CSE_ASSETS_INT
The staging entity that holds all the physical attributes of the operational asset.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
CSE_ASSETS_INT_PK |
INTERFACE_ROW_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INTERFACE_ROW_ID | NUMBER | 18 | Yes | Interface Row Identifier. The primary key column of this table. | |
INTERFACE_STATUS_CODE | VARCHAR2 | 30 | The status of the interface row. The processor heavily relies on this column to persist interim status of the row upon processing data in bulk. | ||
INTERFACE_BATCH_ID | NUMBER | 18 | Interface Batch Identifier. This is the foreign key to the Interface Batch entity. | ||
INTERFACE_BATCH_CODE | VARCHAR2 | 30 | The interface batch code. The user key to the interface batch entity. | ||
INTERFACE_RECORD_NUMBER | VARCHAR2 | 18 | Interface Record Number. This is the user key to link the child interface entities together. | ||
ACTION_CODE | VARCHAR2 | 30 | Yes | The various actions that can be performed via the import functionality at the asset level. | |
ASSET_ID | NUMBER | 18 | Unique identifier and Primary Key for the asset. System Generated using the Fusion Global Unique ID generator | ||
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_DESCRIPTION | VARCHAR2 | 240 | The detailed description of 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_NUMBER | VARCHAR2 | 300 | Inventory Item Number. The user key to identify the product associated to the asset. | ||
ITEM_ORGANIZATION_ID | NUMBER | 18 | The organization id where this product instance is instantiated. | ||
ITEM_ORGANIZATION_CODE | VARCHAR2 | 18 | The item organization user key. The organization where the asset was last located. | ||
ASSET_TRACKING_CODE | VARCHAR2 | 1 | The tracking level of the asset. Whether the asset is tracked for full lifecycle, tracked as a customer asset only, or not tracked. This is a denormalized column from the item master. | ||
GENEALOGY_ENABLED_FLAG | VARCHAR2 | 1 | Flag indicating whether this asset is created from an item for which genealogy is enabled at the item master or not. | ||
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. | ||
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. | ||
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 location organization identifier of the current location. | ||
LOCATION_ORGANIZATION_CODE | VARCHAR2 | 18 | The location organization code of the current location. | ||
SUBINVENTORY_CODE | VARCHAR2 | 30 | Subinventory Identifier. The inventory warehouse location. | ||
INVENTORY_LOCATOR_ID | NUMBER | 18 | The inventory item locator identifier. | ||
INVENTORY_LOCATOR_SEGMENT1 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT2 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT3 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT4 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT5 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT6 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT7 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT8 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT9 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT10 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT11 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT12 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT13 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT14 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT15 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT16 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT17 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT18 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT19 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
INVENTORY_LOCATOR_SEGMENT20 | VARCHAR2 | 40 | One of the segment used to break down the inventory locator. | ||
WORK_CENTER_ID | NUMBER | 18 | The foreign key to the work center entitiy. | ||
WORK_CENTER_CODE | VARCHAR2 | 30 | The user key to the work center business object. | ||
WORK_ORDER_ID | NUMBER | 18 | Work Order Reference when the component is issues to the work order. | ||
WORK_ORDER_NUMBER | VARCHAR2 | 120 | Work Order Number. The user key to the work order business object. | ||
WORK_ORDER_OPERATION_ID | NUMBER | 18 | Work Order Operation Identifier. | ||
WO_OPERATION_SEQ_NUMBER | NUMBER | The user key to the work order operation entity. | |||
INTERNAL_LOCATION_CODE | VARCHAR2 | 150 | Internal Location Code. This is validated from HR_LOCATIONS.INTERNAL_LOCATION_CODE. This is populated when the current location context is 'ORA_INTERNAL_LOCATION'. | ||
COUNTRY | VARCHAR2 | 2 | External or Internal Location: Validated from FND_TERRITORY.territory_code table. This is populated to identify a predefined address in either HZ_LOCATIONS or HR_LOCATIONS. | ||
ADDRESS1 | VARCHAR2 | 240 | External or Internal Location: First line for address. This is populated to identify a predefined address in either HZ_LOCATIONS or HR_LOCATIONS. | ||
ADDRESS2 | VARCHAR2 | 240 | External or Internal Location: Second line for address. This is populated to identify a predefined address in either HZ_LOCATIONS or HR_LOCATIONS. | ||
ADDRESS3 | VARCHAR2 | 240 | External or Internal Location: Third line for address. This is populated to identify a predefined address in either HZ_LOCATIONS or HR_LOCATIONS. | ||
ADDRESS4 | VARCHAR2 | 240 | External or Internal Location: Fourth line for address. This is populated to identify a predefined address in either HZ_LOCATIONS or HR_LOCATIONS. | ||
CITY | VARCHAR2 | 60 | External or Internal Location: City. This is populated to identify a predefined address in either HZ_LOCATIONS or HR_LOCATIONS. | ||
POSTAL_CODE | VARCHAR2 | 60 | External or Internal Location: Postal code. This is populated to identify a predefined address in either HZ_LOCATIONS or HR_LOCATIONS. | ||
STATE | VARCHAR2 | 60 | External or Internal Location: State. This is populated to identify a predefined address in either HZ_LOCATIONS or HR_LOCATIONS. | ||
PROVINCE | VARCHAR2 | 60 | External or Internal Location: Province. This is populated to identify a predefined address in either HZ_LOCATIONS or HR_LOCATIONS. | ||
COUNTY | VARCHAR2 | 60 | External or Internal Location: County. This is populated to identify a predefined address in either HZ_LOCATIONS or HR_LOCATIONS. | ||
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_ID | NUMBER | 18 | Foreign key to the sales order business object. | ||
SALES_ORDER_NUMBER | VARCHAR2 | 120 | The user key to the sales order business object | ||
SALES_ORDER_LINE_ID | NUMBER | 18 | Foreign key to the sales order lines entity. | ||
SALES_ORDER_LINE_NUMBER | VARCHAR2 | 120 | The user key to the sales order lines entity. | ||
SOLD_BY_BUSINESS_UNIT_NAME | VARCHAR2 | 240 | The sold by business unit name. This is the business unit that sells the asset to the customer. | ||
SOLD_BY_BUSINESS_UNIT_ID | NUMBER | 18 | The business unit identifier that solds the asset to the customer. | ||
SHIPMENT_DATE | DATE | Date when the asset is shipped to the customer. | |||
PURCHASE_DATE | DATE | Procurement Date. Date when the asset is procured from the Supplier. | |||
CUSTOMER_NUMBER | VARCHAR2 | 30 | The party number of the sold to party. | ||
CUSTOMER_NAME | VARCHAR2 | 360 | The party name of the sold to party. | ||
CUSTOMER_ID | NUMBER | 18 | The sold-to party Identifier. The foreign key to the hz_parties entity. | ||
CUSTOMER_PARTY_TYPE | VARCHAR2 | 30 | The party type of the customer. It could be an Organization Party or Person Party. | ||
CUSTOMER_SITE_PARTY_NUMBER | VARCHAR2 | 30 | The party number of the ship to party. | ||
CUSTOMER_SITE_PARTY_NAME | VARCHAR2 | 360 | The party name of the ship-to party. | ||
CUSTOMER_SITE_PARTY_ID | NUMBER | 18 | The party identifier of the ship-to party. This is stored in the asset as a customer site's party id. | ||
CUSTOMER_SITE_NUMBER | VARCHAR2 | 30 | The party site number of the shippped to party. | ||
CUSTOMER_SITE_NAME | VARCHAR2 | 240 | The site name of the ship to party site. | ||
CUSTOMER_SITE_ID | NUMBER | 18 | The ship-to party site identifier. The foreign key to the hz_party_sites entity. This is where the asset is shipped to and assumed to be the customer site identifier.. | ||
CUSTOMER_ACCOUNT_NUMBER | VARCHAR2 | 30 | The account number of the customer account. | ||
CUSTOMER_ACCOUNT_NAME | VARCHAR2 | 240 | The account name of the customer account. | ||
CUSTOMER_ACCOUNT_ID | NUMBER | 18 | The billing customer account identifier. | ||
CUSTOMER_ACCOUNT_SITE_NUMBER | VARCHAR2 | 30 | The site number of the customer account site. | ||
CUSTOMER_ACCOUNT_SITE_NAME | VARCHAR2 | 240 | The account site name of the customer account. | ||
CUSTOMER_ACCOUNT_SITE_ID | NUMBER | 18 | The customer account site identifier. | ||
CUSTOMER_ACCOUNT_SITE_USE_CODE | VARCHAR2 | 30 | The site use code of the customer account site. | ||
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. | ||
CONTACT_NUMBER | VARCHAR2 | 30 | The party number of the contact. This is the party_number from hz_parties for the contact_id. | ||
CONTACT_NAME | VARCHAR2 | 360 | The party name of the contact. This is the party_name from hz_parties for the contact_id. | ||
SUPPLIER_ID | NUMBER | 18 | Supplier Identifier. The foreign key to the Suppliers business object. | ||
SUPPLIER_NAME | VARCHAR2 | 360 | The user key to the supplier business object. The party name in hz_parties. | ||
SUPPLIER_SITE_ID | NUMBER | 18 | Supplier Site Identifier. The primary key of the supplier site. | ||
SUPPLIER_SITE_CODE | VARCHAR2 | 15 | The user key to the supplier site business object. | ||
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 | The flag that indicates whether the asset is maintainable using the maintenance management functions. | ||
ACTIVE_END_DATE | TIMESTAMP | The date when the asset is terminated. | |||
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. | |||
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. | ||
OKC_INTERFACE_FLAG | VARCHAR2 | 1 | Flag to indicate whether service contract interface is required or not. | ||
EXPLODE_BOM_FLAG | VARCHAR2 | 1 | Flag indicating whether component assets are created as a result of exploding the bills of materials of the item for which the asset is created. | ||
NEW_ASSET_NUMBER | VARCHAR2 | 80 | Populate a value in this field to change the asset number. | ||
GEN_OBJECT_ID | NUMBER | 18 | Genealogy object identifier. Foreign key to CSE_GENEALOGY_OBJECTS. | ||
ROOT_ASSET_ID | NUMBER | 18 | The root asset in the asset hierarchy. This is a denormalized column. | ||
LOGICAL_ROOT_ASSET_ID | NUMBER | 18 | The logical root asset in the as-sold logical hierarchy. This is a denormalized column. | ||
PARENT_INT_RECORD_NUMBER | VARCHAR2 | 18 | When this asset that is being created or updated as a component of another parent asset, and the parent asset creation is inflight in the same batch that parent asset can be referenced here using its interface_record_number. | ||
PARENT_INT_RECORD_ID | NUMBER | 18 | The internal column to identify the parent asset's interface record number. Derived for parent_int_record_number. | ||
PARENT_ASSET_NUMBER | VARCHAR2 | 80 | When a parent asset is referenced here, a component relationship is created between the parent asset and the asset that is being processed. | ||
PARENT_ASSET_ID | NUMBER | 18 | Internal identifier for the referenced parent asset number. Used for internal processing. | ||
RELATIONSHIP_ACTION_CODE | VARCHAR2 | 30 | The actions that can be done when a parent asset is referenced. It could be either an add or remove. The lookup values are drawn from the lookup type ORA_CSE_ASSET_IMPORT_CFG_ACTION. | ||
RELATIONSHIP_TYPE_CODE | VARCHAR2 | 30 | When a parent asset is referenced, the relationship that is created between the parent and its subject is established by this relationship type. This is defined as an internal column. | ||
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. | ||
IN_SERVICE_DATE | DATE | Date when the asset is placed in service. | |||
INSTALLED_DATE | DATE | Installation Date. Date when the equipment/asset is installed. | |||
INVENTORY_LOCATOR_NAME | VARCHAR2 | 1000 | The concatenated segments put together in the form of locator name. | ||
PARENT_ITEM_ID | NUMBER | 18 | The parent asset's item identifier captured so that the asset can be resolved when the parent_asset_id is not passed. | ||
PARENT_ITEM_NUMBER | VARCHAR2 | 300 | The parent asset's item number captured so that the asset can be resolved when the parent_asset_id is not passed. | ||
PARENT_SERIAL_NUMBER | VARCHAR2 | 80 | The parent asset's serial number captured so that the asset can be resolved when the parent_asset_id is not passed. | ||
PARENT_LOT_NUMBER | VARCHAR2 | 80 | The parent asset's lot number captured so that the asset can be resolved when the parent_asset_id is not passed. | ||
REGISTRATION_DATE | DATE | Date when the asset is registered as a customer asset. | |||
SRC_SYSTEM_TYPE | VARCHAR2 | 30 | Type of the Source System. Internal or External. | ||
SRC_SYSTEM_CODE | VARCHAR2 | 30 | Source System Code. Application short code when the source system type is Internal. Original system code when it is external. | ||
SRC_SYSTEM_ID | NUMBER | 18 | Source System Identifier. Application Identifier when the source system type is Internal. | ||
SRC_TRANSACTION_DATE | TIMESTAMP | Source Transaction Date. Date when the transaction was performed in the source system. | |||
SRC_TRANSACTION_ID | NUMBER | Source Transaction Identifier. The unique transaction identifier in the source system. | |||
SRC_TRANSACTION_TYPE_ID | VARCHAR2 | 30 | Source Transaction Type Code/Identifier. | ||
SRC_TRANSACTION_TYPE | VARCHAR2 | 240 | Source Transaction type. The type of transaction performed in the source system. | ||
SRC_TRANSACTION_QTY | NUMBER | Source Transaction Quantity. The quantity transacted in the source system. | |||
SRC_TRANSACTION_UOM_CODE | VARCHAR2 | 3 | The unit of measure code captured for the quantity transacted in the source system. | ||
TXN_DOC_TYPE_CODE | VARCHAR2 | 30 | Any generic document type that is captured as part of the transaction that is being imported during genealogy import. | ||
TXN_DOC_NUMBER | VARCHAR2 | 30 | Any generic document number reference that is captured as part of the transaction that is being imported during genealogy import. | ||
TXN_DOC_ID | NUMBER | 18 | Any generic document identifier that is captured as part of the transaction that is being imported during genealogy import. | ||
TXN_DOC_LINE_NUMBER | VARCHAR2 | 30 | Any generic document line number reference that is captured as part of the transaction that is being imported during genealogy import. | ||
TXN_DOC_LINE_ID | NUMBER | 18 | Any generic document line identifier that is captured as part of the transaction that is being imported during genealogy import. | ||
TXN_DOC_SUB_LINE_NUMBER | VARCHAR2 | 30 | Any generic document sub line number reference that is captured as part of the transaction that is being imported during genealogy import. | ||
TXN_DOC_SUB_LINE_ID | NUMBER | 18 | Any generic document sub line identifier that is captured as part of the transaction that is being imported during genealogy import. | ||
PARTITION_NUMBER | NUMBER | 18 | For parallel processing, the internal logic uses this column to stripe the bunch of assets in to a partition. | ||
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 | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | 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. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Load Request Identifier. This is to support the loading of the interface records from the data files using the cloud framework. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CSE_ASSETS_INT_N01 | Non Unique | Default | INTERFACE_RECORD_NUMBER |
CSE_ASSETS_INT_N02 | Non Unique | Default | PARENT_INT_RECORD_NUMBER |
CSE_ASSETS_INT_N03 | Non Unique | Default | INTERFACE_BATCH_ID, INTERFACE_STATUS_CODE, ACTION_CODE |
CSE_ASSETS_INT_N04 | Non Unique | Default | INTERFACE_BATCH_CODE, INTERFACE_STATUS_CODE, ACTION_CODE |
CSE_ASSETS_INT_N05 | Non Unique | Default | PARTITION_NUMBER, INTERFACE_STATUS_CODE, INTERFACE_BATCH_ID, INTERFACE_BATCH_CODE |
CSE_ASSETS_INT_N06 | Non Unique | Default | ASSET_NUMBER |
CSE_ASSETS_INT_U01 | Unique | Default | INTERFACE_ROW_ID |