CML_TROP_CHARGE_REF_VALUES

This table stores the reference types for a charge. At the time of entering a charge line in a trade operation, user will be prompted to enter the applicable reference types. It will be derived based on the setup done while defining landed cost charges. Users can add new reference types if they need to provide more information.

Details

• Schema: FUSION

• Object owner: CML

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CML_TROP_CHARGE_REF_VALUE_PK	TROP_CHARGE_REF_VALUE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TROP_CHARGE_REF_VALUE_ID	NUMBER		18	Yes	Surrogate key that identifies a row in this table.
TRADE_OPERATION_CHARGE_ID	NUMBER		18	Yes	Foreign Key from CML_TRADE_OPERATION_CHARGES
CHARGE_REF_TYPE_ID	NUMBER		18	Yes	Foreign key from CML_CHARGE_REF_TYPES_B
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	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.
REFERENCE_VALUE_VARCHAR	VARCHAR2	60			Reference type value stored if data type is Alphanumeric
REFERENCE_VALUE_NUMBER	NUMBER				Reference type value stored if data type is Numeric
REFERENCE_VALUE_TIMESTAMP	TIMESTAMP				Reference type value stored if data type is Date
AUTO_ASSOCIATE_FLAG	VARCHAR2	1			Defaulted from Charge name Setup. Can be checked/unchecked by the user if an invoice is not associated to the Trade Operation charge.
PRE_DEFINED_FLAG	VARCHAR2	1			This field shows whether the reference type was pre-defined in default Charge references setup.
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.
CREATION_SOURCE	VARCHAR2	11			Source which created the record
LAST_UPDATION_SOURCE	VARCHAR2	11			Source which last updated the record

Foreign Keys

Table	Foreign Table	Foreign Key Column
CML_TROP_CHARGE_REF_VALUES	cml_trade_operation_charges	TRADE_OPERATION_CHARGE_ID
CML_TROP_CHARGE_REF_VALUES	cml_charge_ref_types_b	CHARGE_REF_TYPE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CML_TROP_CHARGE_REF_VALUE_PK	Unique	Default	TROP_CHARGE_REF_VALUE_ID