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 |