SCH_EPP_PA_DEFAULTS
SCH_EPP_PA_DEFAULTS stores the default values for certain purchase agreement attributes to be used during the creation of purchase agreements from external purchase prices. The external purchase prices purchase agreement defaults can be defined for specific requisitioning business unit groups. You can also define a default selection criteria for all business unit groups with the REQ_BU_ID as -1.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SCH_EPP_PA_DEFAULTS_PK |
PA_DEFAULT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PA_DEFAULT_ID | NUMBER | 18 | Yes | Unique identifier of BPA source external recall notification. | |
| REQ_GROUP_ID | NUMBER | 18 | External Purchase Prices Mapping Unique identifier. | ||
| CONFIRMING_ORDER_FLAG | VARCHAR2 | 1 | Indicates whether purchase order is a confirming order. | ||
| ALLOW_PRICE_OVERRIDE_FLAG | VARCHAR2 | 1 | Indicates whether you can change the price on a release. | ||
| ROUNDING_FACTOR | NUMBER | 3 | Attribute indicating how to round the quantity on an internal requisition that results from conversions between the requisition line unit of measure and the item unit of issue. This factor ensures that the unit of issue resolves to an integer rather than a fractional amount. | ||
| RETRO_PRICE_COMM_UPDATES_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not the retroactive price update background process should only reprice open unfulfilled orders referencing the agreement. | ||
| RETRO_PRICE_OPEN_ORDER_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not the retroactive price update background process should only reprice open unfulfilled orders referencing the agreement. | ||
| RETRO_PRICE_INIT_APPROVAL_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not the retroactive price update background process should be initiated upon agreement approval. | ||
| RETRO_PRICE_APPLY_UPDATES_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not price updates on the agreement should be propagated to orders referencing the agreement. | ||
| ALLOW_MULTIPLE_SITES_FLAG | VARCHAR2 | 1 | A flag to indicate that an agreement can be used across all supplier sites for a given supplier. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| APPROVAL_ACTION | VARCHAR2 | 25 | This value is either BYPASS or SUBMIT. | ||
| 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. | |
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| 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_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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SCH_EPP_PA_DEFAULTS_U1 | Unique | Default | PA_DEFAULT_ID |