CST_OPERATION_ADJ_TXNS_I_GT
This global temporary table is used to hold the scrap adjustment transactions that are triggered to revalue scrap at the time of work order close for internal processing within the cost processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OPERATION_ADJ_TXN_ID | NUMBER | 18 | Yes | Surrogate ID identifying a scrap adjustment transaction. | |
| OPERATION_TRANSACTION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the operation transaction which needs to be adjusted. | |
| WO_UPDATE_EVENT_TXN_ID | NUMBER | 18 | Indicates the job close transaction that triggered the adjustment. | ||
| BASE_TXN_TYPE_ID | NUMBER | 18 | Yes | Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table. | |
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Base transaction source identifier. This value will be 0 for costing only adjustments. | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | Yes | Base transaction action identifier. | |
| EFF_DATE | TIMESTAMP | Yes | Indicates the date and time at which this transaction was created. | ||
| COST_DATE | TIMESTAMP | Indicates the cost date used to sequence this transaction for processing. | |||
| PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | ||
| COST_ORG_ID | NUMBER | 18 | Surrogate ID identifying the cost organization. | ||
| COST_BOOK_ID | NUMBER | 18 | Surrogate ID identifying the cost book assigned to the cost organization. | ||
| POSTED_FLAG | VARCHAR2 | 1 | Yes | Indicates the processing status of the transaction. Possible values are N-No and Y -Yes. | |
| COSTING_STATUS | VARCHAR2 | 1 | Status of the transaction which denotes, whether a transaction has been pre-processed, processed by cost processors, distributions have been created or processed by sub-ledger accounting etc. C Fully costed E Error N Not processed P Partially costed X Excluded. | ||
| ACCOUNTING_STATUS | VARCHAR2 | 1 | Current accounting status of the transaction for display: D Draft accounted E Error F Final accounted N Not accounted X Excluded from accounting Z Not applicable. | ||
| 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. | ||
| 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. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| COST_CUTOFF_DATE | TIMESTAMP | Identifies the cost cutoff date for the transaction's cost organization and book. | |||
| SERVER_TZ_COST_CUTOFF_DATE | TIMESTAMP | Cost cutoff date in server time zone. | |||
| PERIODIC_AVERAGE_FLAG | VARCHAR2 | 1 | Flag to identify if the cost book is periodic average cost book. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_OPRTN_ADJ_TXNS_I_GT_U1 | Unique | OPERATION_ADJ_TXN_ID |
| CST_OPRTN_ADJ_TXNS_I_GT_U2 | Unique | OPERATION_TRANSACTION_ID, EFF_DATE |