1. Tables and Views for SCM
  2. CST_RAPID_IMPL_PC_BU

CST_RAPID_IMPL_PC_BU

This table captures the user entered parameters for the Rapid Implementation requests that are issued from the UI.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

CST_RAPID_IMPL_PC_BU_PK

PROFIT_CENTER_BU_ID, QUICK_SETUP_ID

Columns

Name Datatype Length Precision Not-null Comments
PROFIT_CENTER_BU_ID NUMBER 18 Yes The Business unit ID of the Profit Center UI.
COST_ORG_CODE VARCHAR2 500 Yes Indicates the Cost Organization Code.
COST_ORG_NAME VARCHAR2 240 Yes Indicates the Cost Organization Name.
COST_METHOD VARCHAR2 30 Yes The cost method code like PERPETUAL AVERAGE, ACTUAL etc. Value comes from lookup_type CST_COST_METHODS
STATUS VARCHAR2 1 Yes Indicates the status of the complete Cost Management setup for the given Profit Center BU.
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.
QUICK_SETUP_ID NUMBER 18 Yes Surrogate key to identify each cost accounting quick setup executed.
COST_BOOK_CODE VARCHAR2 30 A unique code given for a particular cost book. Usually named to indicate the purpose of that cost book
NEGATIVE_QTY_CODE VARCHAR2 30 Indicates the logic to be used to process issue transactions when there is insufficient quantity available in costing. Options include Always, Never and To Zero.
OPERATION_SCRAP_COST_TYPE VARCHAR2 30 Indicates the accounting treatment for scrap transactions. The scrap value can be expensed or can be included in inventory.
FIRST_LEDGER_PERIOD_NAME VARCHAR2 15 Single column FK: This is the first period value of the associated accounting period set for cost transactions to be accounted in. It allows the costing period maintenance of open/close, etc. for all subsequent periods including this period.
COST_LEVEL VARCHAR2 30 Indicates the level of the cost detail to be set in the valuation structure entity.
VALIDATION_ORGANIZATION_ID NUMBER 18 This is the identifier of Item validation Organization associated to the Cost Organization
VAL_STRUCTURE_CODE VARCHAR2 30 Indicates the Valuation Structure Code given by the user.
PROPAGATE_COST_ADJ_FLAG VARCHAR2 1 Identifies if the cost propagation is enabled. This flag is applicable only for Actual cost method and valid values are Y and N.
ENFORCE_TXN_DATE_ORDER_FLAG VARCHAR2 5 Profile option to ensure that cost date is always in the same order as transaction date. This option is always available if negative inventory code is ALWAYS and propagate cost adjustment is set to No. Possible values are (Y)es and (N)o.
ASSET_COST_PROFILE_CODE VARCHAR2 30 A unique code given for a particular cost profile. Usually named to indicate the usage of the cost profile.
EXPENSE_COST_PROFILE_CODE VARCHAR2 30 A unique code given for a particular cost profile. Usually named to indicate the usage of the cost profile.
CREATION_SOURCE VARCHAR2 4 Indicates the source of the record. Valid values are 'REST', 'ADF', 'RW'.

Indexes

Index Uniqueness Tablespace Columns
CST_RAPID_IMPL_PC_BU_U1 Unique Default PROFIT_CENTER_BU_ID, QUICK_SETUP_ID