Asset

Asset Data Model

The following data model illustrates the asset object.

Asset Data Model

Asset Table Names

Data Model Name

Table Name

Generated Keys

Object Validation Batch Control

Referential Integrity Validation Batch Control

Key Assignment Batch Control

Insertion Batch Control

Asset

CI_​ASSET

Yes. CI_​ASSET_​K

VAL-ASST

CIPVASTV

CIPVASTK

CIPVASTI

Asset Billing Address

CI_​ASSET_​BILLING_​ADDR

No. The key is Asset ID, Sequence Number.

CIPVASBV

CIPVASBI

Asset External ID

CI_​ASSET_​EXT_​ID

No. The key is Asset ID, Sequence Number.

CIPVASEV

CIPVASEI

Asset Related Persons

CI_​ASSET_​PER

No. The key is Asset ID, Sequence Number.

CIPVASRV

CIPVASRI

Asset Characteristic

CI_​ASSET_​CHAR

No. The key is Asset ID, Characteristic Type, and Sequence Number.

CIPVASCV

CIPVASCI

Asset Log

CI_​ASSET_​LOG

No. The key is Asset ID, Sequence Number.

CIPVASLV

CIPVASLI

Asset Log Parameter

CI_​ASSET_​LOG_​PARM

No. The key is Asset ID, Sequence, and Message Parameter Sequence.

CIPVASPV

CIPVASPI

Asset Ownership

C1_​ASSET_​OWN

Yes. CI_​ASSET_​OWN_​K

VAL-AOWN

CIPVAOWV

CIPVAOWK

Has dependencies

CIPVAOWI

Asset Owners

C1_​ASSET_​OWN_​OWNER

No. The key is Asset Ownership ID and Sequence Number.

CIPVAOOV

CIPVAOOI

Asset Ownership Characteristic

C1_​ASSET_​OWN_​CHAR

No. The key is Asset Ownership ID, Characteristic Type, and Sequence Number.

CIPVAOCV

CIPVAOCI

Asset Ownership Log

C1_​ASSET_​OWN_​LOG

No. The key is Asset Ownership ID, Sequence Number.

CIPVAOLV

CIPVAOLI

Asset Ownership Log Parameter

C1_​ASSET_​OWN_​LOG_​PARM

No. The key is Asset Ownership ID, Sequence, and Message Parameter Sequence.

CIPVAOPV

CIPVAOPI

Asset Suggestions

This maintenance object includes a character large object field that your organization may be using to capture implementation specific data as defined by your business objects. For records of this type, the process to insert the records to the staging table is responsible for populating the data in this CLOB as per the record's business object schema.