LOY_PROG_ORG

Details

Schema: FUSION
Object owner: LOY
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
LOY_PROG_ORG_INT_PK	BATCH_ID, INTERFACE_ROW_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
LOY_PROG_ORG_INT_ID	NUMBER		18		Unique identifier of the Program Organization Intersection line in the interface table. System generated.
PROGRAM_NAME	VARCHAR2	50			Program Name refers to Program Interface table as an alternate key.
BATCH_ID	NUMBER		18	Yes	Unique Identifier for a Batch
IMPORT_STATUS_CODE	VARCHAR2	30			Status for the data in the interface table
INTERFACE_ROW_ID	NUMBER		18	Yes	Unique identifier of the interface record. Internal use only.
ACTION_CODE	VARCHAR2	30			Indicates delete action entered by user
INTERNAL_ACTION_CODE	VARCHAR2	30			This column is created for internal use and will be populated and used by bulk import logic.
INTERNAL_PROG_ORG_OVN	NUMBER		9		Object Version Number copied from corresponding Program Organization Intersection record. This is used for UPDATE cases to see if record is updated by another user during processing of bulk import and throw error appropriately.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of 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.
LOY_PROG_ORG_ID	NUMBER		18		Reference Column to the LOY_PROG_ORG (Primary Key to LOY_PROG_ORG table)
ACRL_VALID_PD_LEN	NUMBER		22		The maximum time gap (after activity date) upto which a partner is allowed to send accruals
ACRL_VALID_UOM_CODE	VARCHAR2	30			Accrual Validity UOM
ALLW_NEGATIVE_FLAG	VARCHAR2	1			Indicates if the partner is allowed to go negative
BILLING_TYPE_CODE	VARCHAR2	30			Partner Billing Type
CREDIT_LIMIT	NUMBER		22		For partners that are allowed to go negative, this is the threshold of the points that they can go negative
MIN_ORDER_QTY	NUMBER				Minimum Order quantity
ORG_EXT_ID	NUMBER		18		Associated Loyalty Partner under the Loyalty Program
PRECALC_ACRL_FLAG	VARCHAR2	1			Determines whether partner sends precalcualted accruals or not
PRICING_RULE_ID	NUMBER		18		Pricing Rule
PROGRAM_ID	NUMBER		18		Program Id
REORDER_LIMIT	NUMBER		22		If the partners available points fall below this level, reordering should be initiated
RET_BEFORE_DAYS	NUMBER		22		Denotes the number of days before which the Goods might be returned by the customer
SKIP_ACRL_VAL_FLAG	VARCHAR2	1			Flag at the Prog Org level to force basic validations for transaction processing.
VALDT_DISPUTE_USR	VARCHAR2	30			Validate Dispute User Submit To Validate Dispute User Submit To
VALID_DISPUTE_FLAG	VARCHAR2	1			In case of dipute lodged by member, this flag will determine whether partner validation is required or not

Indexes

Index	Uniqueness	Tablespace	Columns
LOY_PROG_ORG_INT_U1	Unique	Default	BATCH_ID, INTERFACE_ROW_ID