CML_TOPT_CHARGE_REF_VALUES

Landed Cost Trade Operation Template Charges Ref Values Table - This table stores the reference types for a charge. At the time of entering a charge line in a template, user will be prompted to enter the applicable reference types. It will be derived based on the setup done while defining landed cost charges. User can add new reference types as well.

Details

• Schema: FUSION

• Object owner: CML

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CML_TOPT_CHARGE_REF_VALUES_PK	TOPT_CHARGE_REF_VALUE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TOPT_CHARGE_REF_VALUE_ID	NUMBER		18	Yes	Surrogate key that identifies a row in this table.
TOPT_CHARGE_ID	NUMBER		18	Yes	Foreign Key that identifies trade operation template charge.
CHARGE_REF_TYPE_ID	NUMBER		18	Yes	Foreign Key that identifies charge reference type.
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	64			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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CML_TOPT_CHARGE_REF_VALUES	cml_topt_charges	TOPT_CHARGE_ID
CML_TOPT_CHARGE_REF_VALUES	cml_charge_ref_types_b	CHARGE_REF_TYPE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CML_TOPT_CHARGE_REF_VALUES_PK	Unique	Default	TOPT_CHARGE_REF_VALUE_ID
CML_TOPT_CHARGE_REF_VALUES_U1	Unique	Default	TOPT_CHARGE_ID, CHARGE_REF_TYPE_ID