CSE_ASSET_CHARGES_GT_DEBUG
This is a debug capture table during the processing of data for asset changes in the process of integrating order management fulfillments to Installed Base.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CSE_ASSET_CHARGES_GTD_PK |
GTT_DOC_ID, DEBUG_STAGE |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
GTT_DOC_ID | NUMBER | 18 | Yes | The primary key of the entity. To locate the unique inprocess row. | |
DEBUG_STAGE | VARCHAR2 | 30 | Yes | The developer handle to indicate the stage in the processing where the debug is captured. | |
API_NAME | VARCHAR2 | 120 | The api from where the debugging is initiated. | ||
GTT_GROUP_ID | NUMBER | 18 | The processing group identifier. At the session level, there could be multiple groups. | ||
GTT_TXN_ID | NUMBER | 18 | The foreign key to the asset transaction that is being processed. | ||
ASSET_CHARGE_ID | NUMBER | 18 | The charge identifier. The foreign key to the asset charges entity. | ||
ASSET_ID | NUMBER | 18 | The asset identifier. Foreigk key to the asset entity. | ||
CHARGE_DEFINITION_CODE | VARCHAR2 | 30 | The unique charge definition code | ||
PRICE_ELEMENT_CODE | VARCHAR2 | 30 | The elemental breakdown of the charge. The type code that denotes that breakdown. | ||
PRICE_ELEMENT_USAGE_CODE | VARCHAR2 | 30 | The usage of the price element where is charge is recorded. | ||
PRICED_QUANTITY_UOM_CODE | VARCHAR2 | 3 | The unit of measure at which the order line quantity is priced. The priced quantity would be the asset quantity. | ||
UNIT_PRICE | NUMBER | The unit price of the item on the order line. | |||
CURRENCY_CODE | VARCHAR2 | 15 | The currency code with which the order line was priced. | ||
PRIMARY_FLAG | VARCHAR2 | 1 | Flag indicating which of the price element is to be treated as the primary charge. | ||
PRICE_PERIODICITY_CODE | VARCHAR2 | 30 | The price periodicity code when there is recurring billing involved. | ||
CHARGES_ROLLUP_FLAG | VARCHAR2 | 1 | Rollup flag for the charges entity. | ||
CHARGE_COMPONENTS_ROLLUP_FLAG | VARCHAR2 | 1 | The rollup flag at the charge comonents level. | ||
TAX_INCLUDED_FLAG | VARCHAR2 | 1 | Flag that indicates whether tax is included in the charge or not. | ||
ACTIVE_START_DATE | TIMESTAMP | The date when the asset charge became active. | |||
ACTIVE_END_DATE | TIMESTAMP | The date when the asset charge was terminated. | |||
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CSE_ASSET_CHARGES_GTD_U01 | Unique | Default | GTT_DOC_ID, DEBUG_STAGE |