PON_PRICE_ELEMENT_TYPES_B

PON_PRICE_ELEMENT_TYPES stores details of cost factors. Cost factors include costs associated with the movement of goods from one location to another. They also include intangible costs such as the cost of switching over to a new supplier when used in the Sourcing process. This component was called "Price Elements" or "Price Factors" in earlier releases.

Details

• Schema: FUSION

• Object owner: PON

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
PON_PRICE_ELEMENT_TYPES_B_PK	PRICE_ELEMENT_TYPE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PRICE_ELEMENT_TYPE_ID	NUMBER		18	Yes	Unique system generated ID of the price element
PRICE_ELEMENT_CODE	VARCHAR2	30		Yes	Alpha-numeric code for price element defined by user
PRICING_BASIS	VARCHAR2	30		Yes	Use lookup code PON_PRICING_BASIS. Values are:PER_UNIT, FIXED_AMOUNT, PERCENTAGE
ENABLED_FLAG	VARCHAR2	1		Yes	A flag to indicate whether this price element type is enabled or not: Y / N
SYSTEM_FLAG	VARCHAR2	1		Yes	For pre-seeded price element "item price"Y / N
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
ALLOCATION_BASIS	VARCHAR2	30			Method for prorating summary charges to the line level (e.g. weight, volume, value)
INVOICE_LINE_TYPE	VARCHAR2	30			Invoice line type that will be used in Oracle Accounts Payable corresponding to this cost factor
COST_COMPONENT_CLASS_ID	NUMBER				Identifier of the cost component class. Cost Component Classes are used to identify the individual buckets or component costs that make up the total cost of an item, for example, direct material costs, freight costs, labor costs, production or conversion costs and so on.
COST_ANALYSIS_CODE	VARCHAR2	4			Cost Analysis Codes can be used to further break down an individual component cost for more granular tracking or group component costs across multiple component classes for an alternate view of the item cost.
COST_ACQUISITION_CODE	VARCHAR2	1			Indicates if the cost factor is of type expense or inventory and records corresponding values as E or I
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.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
SEED_DATA_SOURCE	VARCHAR2	512			Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
COST_FACTOR_TYPE	VARCHAR2	30			Cost Factor Type which indiciates whether it is visible to supliers or not when included in a negotiaiton. Values are INTERNAL / EXTERNAL.
ORA_SEED_SET1	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table	Foreign Table	Foreign Key Column
pon_price_element_types_tl	pon_price_element_types_b	PRICE_ELEMENT_TYPE_ID
pon_list_price_elements	pon_price_element_types_b	PRICE_ELEMENT_TYPE_ID
pon_price_elements	pon_price_element_types_b	PRICE_ELEMENT_TYPE_ID
pon_supplier_icf_values	pon_price_element_types_b	PRICE_ELEMENT_TYPE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PON_PRICE_ELEMENT_TYPES_B_U1	Unique	Default	PRICE_ELEMENT_TYPE_ID, ORA_SEED_SET1
PON_PRICE_ELEMENT_TYPES_B_U11	Unique	Default	PRICE_ELEMENT_TYPE_ID, ORA_SEED_SET2