Name |
Datatype |
Length |
Prcn |
INSTANCE_ID |
NUMBER
|
|
|
INSTANCE_NUMBER |
VARCHAR2
|
(30)
|
|
INSTANCE_DESCRIPTION |
VARCHAR2
|
(240)
|
|
SERIAL_NUMBER |
VARCHAR2
|
(30)
|
|
MFG_SERIAL_NUMBER_FLAG |
VARCHAR2
|
(1)
|
|
INV_MASTER_ORGANIZATION_ID |
NUMBER
|
|
|
INV_MASTER_ORGANIZATION_NAME |
VARCHAR2
|
(240)
|
|
INV_MASTER_ORGANIZATION_CODE |
VARCHAR2
|
(3)
|
|
LAST_VLD_ORGANIZATION_ID |
NUMBER
|
|
|
LAST_VLD_ORGANIZATION_NAME |
VARCHAR2
|
(240)
|
|
LAST_VLD_ORGANIZATION_CODE |
VARCHAR2
|
(3)
|
|
INVENTORY_ITEM_ID |
NUMBER
|
|
|
INVENTORY_ITEM_NAME |
VARCHAR2
|
(40)
|
|
INVENTORY_ITEM_DESCRIPTION |
VARCHAR2
|
(240)
|
|
INVENTORY_REVISION |
VARCHAR2
|
(3)
|
|
SYSTEM_ID |
NUMBER
|
|
|
SYSTEM_NAME |
VARCHAR2
|
(50)
|
|
SYSTEM_DESCRIPTION |
VARCHAR2
|
(240)
|
|
SYSTEM_TYPE_CODE |
VARCHAR2
|
(30)
|
|
SYSTEM_NUMBER |
VARCHAR2
|
(30)
|
|
OWNER_PARTY_SOURCE_TABLE |
VARCHAR2
|
(30)
|
|
OWNER_PARTY_ID |
NUMBER
|
|
|
OWNER_PARTY_ACCOUNT_ID |
NUMBER
|
|
|
OWNER_PARTY_ACCOUNT_NAME |
VARCHAR2
|
(240)
|
|
OWNER_PARTY_ACCOUNT_NUMBER |
VARCHAR2
|
(30)
|
|
CUSTOMER_ID |
NUMBER
|
|
|
CUSTOMER_NAME |
VARCHAR2
|
(240)
|
|
CUSTOMER_NUMBER |
VARCHAR2
|
(30)
|
|
EXTERNAL_REFERENCE |
VARCHAR2
|
(30)
|
|
LOT_NUMBER |
VARCHAR2
|
(80)
|
|
QUANTITY |
NUMBER
|
|
|
UNIT_OF_MEASURE |
VARCHAR2
|
(3)
|
|
ACCOUNTING_CLASS_CODE |
VARCHAR2
|
(10)
|
|
INSTANCE_CONDITION_ID |
NUMBER
|
|
|
INSTANCE_USAGE_CODE |
VARCHAR2
|
(30)
|
|
INSTANCE_TYPE_CODE |
VARCHAR2
|
(30)
|
|
INSTANCE_STATUS_ID |
NUMBER
|
|
|
INSTANCE_STATUS_NAME |
VARCHAR2
|
(50)
|
|
INSTANCE_STATUS_DESCRIPTION |
VARCHAR2
|
(240)
|
|
CUSTOMER_VIEW_FLAG |
VARCHAR2
|
(1)
|
|
MERCHANT_VIEW_FLAG |
VARCHAR2
|
(1)
|
|
SELLABLE_FLAG |
VARCHAR2
|
(1)
|
|
LOCATION_TYPE_CODE |
VARCHAR2
|
(30)
|
|
LOCATION_ID |
NUMBER
|
|
|
INV_ORGANIZATION_ID |
NUMBER
|
|
|
INV_ORGANIZATION_NAME |
VARCHAR2
|
(240)
|
|
INV_ORGANIZATION_CODE |
VARCHAR2
|
(3)
|
|
INV_SUBINVENTORY_NAME |
VARCHAR2
|
(10)
|
|
INV_LOCATOR_ID |
NUMBER
|
|
|
PA_PROJECT_ID |
NUMBER
|
|
|
PA_PROJECT_TASK_ID |
NUMBER
|
|
|
IN_TRANSIT_ORDER_LINE_ID |
NUMBER
|
|
|
WIP_JOB_ID |
NUMBER
|
|
|
PO_ORDER_LINE_ID |
NUMBER
|
|
|
LAST_OE_ORDER_LINE_ID |
NUMBER
|
|
|
LAST_OE_RMA_LINE_ID |
NUMBER
|
|
|
LAST_PO_PO_LINE_ID |
NUMBER
|
|
|
LAST_OE_PO_NUMBER |
VARCHAR2
|
(50)
|
|
LAST_WIP_JOB_ID |
NUMBER
|
|
|
LAST_PA_PROJECT_ID |
NUMBER
|
|
|
LAST_PA_TASK_ID |
NUMBER
|
|
|
LAST_OE_AGREEMENT_ID |
NUMBER
|
|
|
LAST_TXN_LINE_DETAIL_ID |
NUMBER
|
|
|
MANUALLY_CREATED_FLAG |
VARCHAR2
|
(1)
|
|
INSTALL_DATE |
DATE
|
|
|
INSTALL_LOCATION_TYPE_CODE |
VARCHAR2
|
(30)
|
|
INSTALL_LOCATION_ID |
NUMBER
|
|
|
RETURN_BY_DATE |
DATE
|
|
|
ACTUAL_RETURN_DATE |
DATE
|
|
|
ACTIVE_START_DATE |
DATE
|
|
|
ACTIVE_END_DATE |
DATE
|
|
|
CREATION_COMPLETE_FLAG |
VARCHAR2
|
(1)
|
|
COMPLETENESS_FLAG |
VARCHAR2
|
(1)
|
|
RELATIONSHIP_TYPE_CODE |
VARCHAR2
|
(30)
|
|
PARENT_INSTANCE_ID |
NUMBER
|
|
|
ROOT_PARENT_INSTANCE_ID |
NUMBER
|
|
|
SECURITY_GROUP_ID |
NUMBER
|
|
|
MIGRATED_FLAG |
VARCHAR2
|
(1)
|
|
REQUEST_ID |
NUMBER
|
|
|
PROGRAM_APPLICATION_ID |
NUMBER
|
|
|
PROGRAM_ID |
NUMBER
|
|
|
PROGRAM_UPDATE_DATE |
DATE
|
|
|
CONFIG_INST_HDR_ID |
NUMBER
|
|
|
CONFIG_INST_REV_NUM |
NUMBER
|
|
|
CONFIG_INST_ITEM_ID |
NUMBER
|
|
|
CONFIG_VALID_STATUS |
VARCHAR2
|
(30)
|
|
LAST_PURGE_DATE |
DATE
|
|
|
NETWORK_ASSET_FLAG |
VARCHAR2
|
(1)
|
|
MAINTAINABLE_FLAG |
VARCHAR2
|
(1)
|
|
PN_LOCATION_ID |
NUMBER
|
|
|
ASSET_CRITICALITY_CODE |
VARCHAR2
|
(30)
|
|
CATEGORY_ID |
NUMBER
|
|
|
EQUIPMENT_GEN_OBJECT_ID |
NUMBER
|
|
|
INSTANTIATION_FLAG |
VARCHAR2
|
(1)
|
|
LINEAR_LOCATION_ID |
NUMBER
|
|
|
OPERATIONAL_LOG_FLAG |
VARCHAR2
|
(1)
|
|
CHECKIN_STATUS |
NUMBER
|
|
|
SUPPLIER_WARRANTY_EXP_DATE |
DATE
|
|
|
PURCHASE_UNIT_PRICE |
NUMBER
|
|
|
PURCHASE_CURRENCY_CODE |
VARCHAR2
|
(15)
|
|
PAYABLES_UNIT_PRICE |
NUMBER
|
|
|
PAYABLES_CURRENCY_CODE |
VARCHAR2
|
(15)
|
|
SALES_UNIT_PRICE |
NUMBER
|
|
|
SALES_CURRENCY_CODE |
VARCHAR2
|
(15)
|
|
OPERATIONAL_STATUS_CODE |
VARCHAR2
|
(30)
|
|
SOURCE_CODE |
VARCHAR2
|
(10)
|
|
CONTEXT |
VARCHAR2
|
(30)
|
|
ATTRIBUTE1 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE2 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE3 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE4 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE5 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE6 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE7 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE8 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE9 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE10 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE11 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE12 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE13 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE14 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE15 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE16 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE17 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE18 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE19 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE20 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE21 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE22 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE23 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE24 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE25 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE26 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE27 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE28 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE29 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE30 |
VARCHAR2
|
(240)
|
|
CREATED_BY |
NUMBER
|
|
15 |
CREATION_DATE |
DATE
|
|
|
LAST_UPDATED_BY |
NUMBER
|
|
15 |
LAST_UPDATE_DATE |
DATE
|
|
|
LAST_UPDATE_LOGIN |
NUMBER
|
|
15 |
OBJECT_VERSION_NUMBER |
NUMBER
|
|
|