CSE_INTG_CHARGES_DEBUG
The charges payload passed in the capture api is persisted here for debugging purposes.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CSE_INTG_CHARGES_DEBUG_PK |
DEBUG_CHARGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DEBUG_CHARGE_ID | NUMBER | 18 | Yes | The unique primary key of the table. Auto generated. | |
| DEBUG_TXN_ID | NUMBER | 18 | The foreign key to the debug transaction id to link the charges to the transaction. | ||
| ASSET_ID | NUMBER | 18 | The asset identifier to which this charge will be associated to. | ||
| CHARGES_OVN | NUMBER | 9 | 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. | ||
| CHARGE_DEFINITION_CODE | VARCHAR2 | 120 | The charge definition code as passed in by order management. | ||
| CHARGES_ROLLUP_FLAG | VARCHAR2 | 4 | The charge rollup flag as passed in by order management. | ||
| CHARGE_COMPONENTS_ROLLUP_FLAG | VARCHAR2 | 4 | The charge components rollup flag as passed in by order management. | ||
| PRICE_PERIODICITY_CODE | VARCHAR2 | 120 | The charge price periodicity code as passed in by order management. | ||
| PRICED_QUANTITY_UOM_CODE | VARCHAR2 | 12 | The charge priced quantity unit of measure code as passed in by order management. | ||
| CHARGE_CURRENCY_CODE | VARCHAR2 | 60 | The charge currency code as passed in by order management. | ||
| PRIMARY_FLAG | VARCHAR2 | 4 | The charge primary flag as passed in by order management. | ||
| AVG_UNIT_SELLING_PRICE | NUMBER | 22 | The average selling price as passed in by order management. | ||
| PRICED_QUANTITY | NUMBER | The quantity for which this price is captured. | |||
| PRICE_ELEMENT_CODE | VARCHAR2 | 120 | The elemental breakdown of the charge. | ||
| PRICE_ELEMENT_USAGE_CODE | VARCHAR2 | 120 | The usage of the pricing element. | ||
| TAX_INCLUDED_FLAG | VARCHAR2 | 4 | Flag to say whether the tax is included in the price or not. | ||
| ACTIVE_START_DATE | TIMESTAMP | The date when this charge is active. | |||
| ACTIVE_END_DATE | TIMESTAMP | The date when this charge is inactive. | |||
| 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_INTG_CHARGES_DEBUG_U01 | Unique | Default | DEBUG_CHARGE_ID |