1. Tables and Views for SCM
  2. CST_USER_ADJUSTMENT_HEADERS

CST_USER_ADJUSTMENT_HEADERS

This table contains user cost adjustment header details entered from the cost adjustments UI. This specifies the type of adjustment and the transaction for which the adjustment is done.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CST_USER_ADJUSTMENT_HEADERS_PK

ADJUSTMENT_HEADER_ID

Columns

Name Datatype Length Precision Not-null Comments
ADJUSTMENT_HEADER_ID NUMBER 18 Yes Unique identifier of the user cost adjustment header record.
EXPENSE_POOL_ID NUMBER 18 Identifies the expense pool of cost.
SOURCE_TRANSACTION_ID NUMBER 18 Identifier for source transaction.
ADJUSTMENT_NUMBER VARCHAR2 50 Yes Document number for this adjustment.
ADJUSTMENT_TYPE VARCHAR2 25 Yes Type of adjustment, P-Perpetual, R-Receipt, and L-Layer.
ADJUSTMENT_DATE TIMESTAMP Date time the adjustment is made.
STATUS_CODE VARCHAR2 30 Yes Status of the adjustment document. P-Pending, S-Submitted, C-Voided.
REASON_CODE VARCHAR2 200 Yes Identifies the reason code for the user cost adjustment transaction.
TRANSACTION_ID NUMBER 18 Yes Identifier for the transaction that the cost adjustment is made.
COST_ORG_ID NUMBER 18 Yes Identifier for cost organization.
COST_BOOK_ID NUMBER 18 Yes Identifies the cost book assigned to the cost organization.
INVENTORY_ITEM_ID NUMBER 18 Yes Identifier for the inventory item.
INVENTORY_ORG_ID NUMBER 18 Identifier for the inventory organization.
RECEIPT_QUANTITY NUMBER Original quantity received for the receipt.
QUANTITY_ONHAND NUMBER Remaining quantity for the receipt.
UOM_CODE VARCHAR2 3 Quantity Unit of Measure for the cost.
TOTAL_UNIT_COST NUMBER Total unit cost for the adjustment of the transaction.
TOTAL_NEW_COST NUMBER User entered the total unit cost adjustment for the transaction.
BASE_TXN_TYPE_ID NUMBER 18 Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table.
BASE_TXN_SOURCE_TYPE_ID NUMBER 18 Inventory transaction source type identifier. For origin as INV the value comes from INV_TXN_SOURCE_TYPES_TL table, and for CST it comes from Lookup_type CST_BASE_TXN_SOURCE_TYPES.
BASE_TXN_ACTION_ID NUMBER 18 Inventory transaction action identifier. For Origin as INV, the value comes from lookup INV_TRANSACTION_ACTIONS and for Origin as CST the value is from lookup_type CST_BASE_TXN_ACTIONS.
VAL_UNIT_ID NUMBER 18 Identifier for valuation unit for transaction.
VAL_STRUCTURE_ID NUMBER 18 Identifier for valuation structure.
COST_DATE TIMESTAMP Cost of date of the transaction that adjustment is made.
EFF_DATE TIMESTAMP Effective date of the transaction that the adjustment is made.
RECEIPT_NUM VARCHAR2 200 Receipt number for the transaction that the adjustment is made.
CURRENCY_CODE VARCHAR2 200 Identifies the currency code of the cost.
POSTED_FLAG VARCHAR2 5 Flag indicating the transaction is already posted or not. Y-posted, N-not posted.
SHIPMENT_HEADER_ID NUMBER 18 Identifier for the shipment header.
TRANSACTION_DATE TIMESTAMP Transaction date of the transaction that the adjustment is made.
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.

Indexes

Index Uniqueness Tablespace Columns
CST_USER_ADJUSTMENT_HEADERS_N1 Non Unique Default INVENTORY_ITEM_ID, INVENTORY_ORG_ID
CST_USER_ADJUSTMENT_HEADERS_U1 Unique FUSION_TS_TX_DATA ADJUSTMENT_HEADER_ID