CST_COGS_TRANSACTIONS_I_GT
This table is used to temporarily store a subset of the data from cst_cogs_transactions table for internal processing within the cost processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_COGS_TRANSACTIONS_I_GT_PK |
TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Unique Identifier for COGS Event | |
| COST_ORG_ID | NUMBER | 18 | Single Column FK: Identifies the Cost Organization associated with the inventory organization. | ||
| COST_BOOK_ID | NUMBER | 18 | Single column FK: Identifies the Cost Book assigned to the cost Organization | ||
| TRANSACTION_DATE | TIMESTAMP | The date when the revenue recognition had happened | |||
| REVENUE_LINE_ID | NUMBER | 18 | Yes | Unique Revenue distribution identifier | |
| INVENTORY_ORG_ID | NUMBER | 18 | Indicates the Inventory Organization To which the Item belongs | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Value that uniquely identifies the inventory item. | ||
| TRANSACTION_ACTION_ID | NUMBER | 18 | Transaction action identifier : 1 for RMA and COGS Recognition | ||
| TRANSACTION_SOURCE_TYPE_ID | NUMBER | Transaction Source Type Identifier : 1 for RMA and COGS Recognition | |||
| COGS_PERCENTAGE | NUMBER | COGS Percentage for COGS recognition. | |||
| 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. | ||
| DELIVERY_ID | NUMBER | 18 | Identifies the delivery associated with the Shipment transactions. | ||
| DOCUMENT_TYPE | VARCHAR2 | 20 | Accounts receivables document identifier - Invoice and Credit Memo | ||
| POSTED_FLAG | VARCHAR2 | 5 | Posted Flag Y to be picked for distributions E for error status | ||
| TRANSACTION_TYPE_ID | NUMBER | 18 | Transaction type identifier : 1 - COGS Recognition and 9 - RMA Recognition | ||
| CST_TRANSACTION_ID | NUMBER | 18 | Yes | Stores the Costing specific transaction identifier from CST_TRANSACTIONS table | |
| SHIPMENT_FULLFILL_LINE_ID | NUMBER | 18 | Yes | DOO Fulfillment key identifier | |
| RMA_TRANSACTION_ID | NUMBER | 18 | Yes | Identifies the receipt associated with the RMA Receipt transactions. | |
| COST_STATUS | VARCHAR2 | 1 | Current costing status of the transaction for display: N-Not Processed, P-Partially Processed, C-Fully Costed, E-Error, X-Excluded from Costing | ||
| ACCOUNTING_STATUS | VARCHAR2 | 1 | Current accounting status of the transaction for display: N-Not Processed, D-Draft Accounted, F-Final Accounted, E-Error, X-Excluded from Accounting | ||
| LE_TIMEZONE_CODE | VARCHAR2 | 50 | Value that identifies the legal entity time zone. If NULL, then LE time zone is not enabled for the data in the row and the dates are assumed to be in database time zone. | ||
| VARIANCE_POSTED_FLAG | VARCHAR2 | 5 | A flag that indicates whether variance cost is created for COGS or RMA Recognition transaction. Possible values are: NULL or X: Variance cost is not expected. N: Variance cost is expected and is yet to be created by the distribution processor. Y: Variance cost is created by the distribution processor. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_COGS_TRANSACTIONS_I_GT_U1 | Unique | CST_TRANSACTION_ID, TRANSACTION_ID |
| CST_COGS_TRANSACTIONS_I_GT_U2 | Unique | TRANSACTION_ID |