PO_CONFIG_COMPONENTS_DRAFT
PO_CONFIG_COMPONENTS_DRAFT stores draft changes information about components (options and models) associated with configurable line items that have not yet been accepted by buyer. Only documents associated with a Configure to Order Style are allowed to have configurable to order lines in their component details are stored in this table. When the draft changes are accepted, the record is moved to PO_CONFIG_COMPONENTS. Changes from buyer are automatically accepted. PO_CONFIG_COMPONENTS_DRAFT contains all columns from PO_CONFIG_COMPONENTS.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
PO_CONFIG_COMPONENTS_DRAFT_PK |
PO_CONFIG_COMPONENT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
PO_CONFIG_COMPONENT_ID | NUMBER | 18 | Yes | Unique identifier of Configurable Option Component. | |
PARENT_PO_CONFIG_COMPONENT_ID | NUMBER | 18 | Corresponds to the parent component line. If the parent is the base model, this field will be null. | ||
OBJECT_HEADER_ID | NUMBER | 18 | Yes | Object header unique identifier. | |
OBJECT_LINE_ID | NUMBER | 18 | Yes | Object line unique identifier. | |
OBJECT_TYPE_CODE | VARCHAR2 | 25 | Yes | Type of the object. Possible object_type_codes are PO and REQ. | |
COMPONENT_LINE_NUMBER | NUMBER | Configuration Component Line display value. | |||
ITEM_ID | NUMBER | 18 | The buying organization's identification number or code for the component used in the configuration. | ||
ITEM_REVISION | VARCHAR2 | 18 | Identifier that indicates the version of the component referenced in the configuration details. | ||
ITEM_DESCRIPTION | VARCHAR2 | 240 | Text describing the component used in the configuration. | ||
ITEM_TYPE | VARCHAR2 | 30 | Used to indicate whether item is a configured product, an option class, or an option/standard item. | ||
SUPPLIER_ITEM_NUMBER | VARCHAR2 | 300 | The supplier's identification number or code for the component. | ||
BASE_MODEL_ID | NUMBER | 18 | The buying organization's identification number or code for the model on which the unique submodel is built. | ||
COMPONENT_QUANTITY | NUMBER | Number of units needed to complete a single configuration. | |||
UOM_CODE | VARCHAR2 | 3 | Yes | UOM of the component | |
UNIT_PRICE | NUMBER | Price of the component | |||
FROM_HEADER_ID | NUMBER | 18 | The purchase agreement against which this configuration component is released. | ||
FROM_LINE_ID | NUMBER | 18 | The purchase agreement line against which this configuration component is released. | ||
REASON_FOR_CHANGE | VARCHAR2 | 240 | REASON_FOR_CHANGE | ||
ENTITY_CHANGE_TYPE_CODE | VARCHAR2 | 1 | ENTITY_CHANGE_TYPE_CODE | ||
EXTERNAL_CHANGE_FLAG | VARCHAR2 | 1 | indicates if the change is external (supplier facing ) or not | ||
CHANGE_ACCEPTED_FLAG | VARCHAR2 | 20 | CHANGE_ACCEPTED_FLAG | ||
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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to 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. | ||
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PO_CONFIG_COMPS_DRAFT_N1 | Non Unique | Default | OBJECT_TYPE_CODE, OBJECT_LINE_ID |
PO_CONFIG_COMPS_DRAFT_N2 | Non Unique | Default | OBJECT_TYPE_CODE, OBJECT_HEADER_ID |
PO_CONFIG_COMPS_DRAFT_U1 | Unique | Default | PO_CONFIG_COMPONENT_ID |