CJM_CUST_TRADE_PROFILES

Details

Schema: FUSION
Object owner: CJM
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
CJM_CUST_TRADE_PRFLS_PK	CUSTOMER_TRADE_PROFILE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CUSTOMER_TRADE_PROFILE_ID	NUMBER		18	Yes	Unique identifier for the customer trade profile created in the application.
BU_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
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.
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.
PARTY_ID	NUMBER		18		Unique party identifier of the customer that the claim is created for.
CUST_ACCOUNT_ID	NUMBER		18		Unique identifier of the customer account that the claim is created for.
BILL_TO_SITE_USE_ID	NUMBER		18		Unique identifier for the bill-to site use of the selected customer account site.
ENABLED_FLAG	VARCHAR2	1			Indicates whether the customer trade profile is enabled or disabled. Values are from the lookup ORA_CJM_YES_NO.
CLAIM_OWNER_ID	NUMBER		18		Default claim owner identifier for the given customer, account, and site.
WRITE_OFF_THRESHOLD_DED	NUMBER				Indicates the write off threshold amount for deduction.
WRITE_OFF_THRESHOLD_OPM	NUMBER				Indicates the write off threshold amount for over payment.
PAY_OVER_EARNINGS_TYPE_CODE	VARCHAR2	30			Indicates whether the pay over earning is allowed or disallowed. Values are from the lookup ORA_CJM_CLAIM_PAY_OVER_EARNING.
PAY_OVER_THRESHOLD_TYPE_CODE	VARCHAR2	30			Indicated the code for pay over earning threshold type. Values are from lookup ORA_CJM_CLM_PAY_OVER_THLD_TYPE.
PAY_OVER_THRESHOLD_VALUE	NUMBER				Indicates the value for the pay over threshold. This value is null when the pay over threshold type is Unconditional.
PAY_OVER_OVERRIDE_THRESH_FLAG	VARCHAR2	1			Indicator to identify if the threshold can be overridden. If selected, then the claim accruals association can be initiated even if the pay over earning amount exceeds the threshold amount.
OWNER_USER_ID	NUMBER		18		Indicates the value for the CLAIM_OWNER_ID before data migration. This is the default claim owner identifier for the given customer, account, and site.
VENDOR_ID	NUMBER		18		Unique identifier for the Payables invoice supplier created in the system. If selected, this value is set as the default supplier when the Check or Payables Default settlement methods are selected to settle a manual claim.
VENDOR_SITE_ID	NUMBER		18		Unique identifier for the Payables vendor site created in the system. If selected, this value is set as the default supplier site when the Check or Payables Default settlement methods are selected to settle a manual claim.
SPA_BATCH_PROCESS_MODE_CODE	VARCHAR2	30			Indicates the value of the special pricing agreement batch processing mode for the Process Indirect Sales Data ESS Job. Values are from the lookup SPA_POS_BATCH_PROCESS_MODE.
DISTRIBUTOR_CONTACT_ID	NUMBER		18		Contains the identifier of the contact for the distributor for the special pricing agreement.
SPA_BATCH_EXPORT_REPORT	VARCHAR2	240			Indicates the name of the Analytics Publisher report used to export the special price agreement batch.

Indexes

Index	Uniqueness	Tablespace	Columns
CJM_CUST_TRADE_PRFLS_U1	Unique	Default	CUSTOMER_TRADE_PROFILE_ID