CST_COGS_TRANSACTIONS
This table contains the COGS / RMA Recognition events created by COGS Processor for the Shipment / RMA Transactions specific to cost org and cost book, to be used by the distribution processor for accounting.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_COGS_TRANSACTIONS_PK |
TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Unique identifier for COGS Event. | |
| POSTED_FLAG | VARCHAR2 | 5 | Posted Flag: Y to be picked for distributions, E for error status. | ||
| 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. E : Variance cost is expected. COGS or RMA Recognition transaction is processed by the distribution processor and variance cost is not created. The flag is updated to E (error) so that the transaction is picked up again for processing by the distribution processor in subsequent execution. | ||
| CST_TRANSACTION_ID | NUMBER | 18 | Yes | Stores the Costing specific transaction identifier from CST_TRANSACTIONS table. | |
| 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 | For ship-bill case, indicates the accounting date when the revenue recognition had happened. For ship-only case, indicates the transaction date of sales order shipment or RMA receipt transaction. | |||
| PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | ||
| 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 COGS recognition and 9 for RMA recognition. | ||
| TRANSACTION_SOURCE_TYPE_ID | NUMBER | Transaction source type identifier: 0 for both COGS and RMA recognition. | |||
| COGS_PERCENTAGE | NUMBER | Indicates COGS or RMA recognition percentage. | |||
| SHIPMENT_FULLFILL_LINE_ID | NUMBER | 18 | Yes | Reference to the unique identifier of the source fulfillment line in distributed order orchestration (DOO). | |
| 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 | Document identifier: Invoice & Credit Memo. | ||
| TRANSACTION_TYPE_ID | NUMBER | 18 | Transaction type identifier: 1 for COGS recognition and 9 for RMA recognition. | ||
| RMA_TRANSACTION_ID | NUMBER | 18 | Yes | Identifies the receipt associated with the RMA receipt transactions. | |
| COST_STATUS | VARCHAR2 | 1 | Costing status of the transaction. N-Not Processed, P-Partially Processed, C-Fully Costed, E-Error, X-Excluded from Costing. | ||
| ACCOUNTING_STATUS | VARCHAR2 | 1 | Accounting status of the transaction. 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| CST_COGS_TRANSACTIONS_N1 | Non Unique | Default | TRUNC("TRANSACTION_DATE"), COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID | Obsolete |
| CST_COGS_TRANSACTIONS_N2 | Non Unique | Default | CST_TRANSACTION_ID, REVENUE_LINE_ID | |
| CST_COGS_TRANSACTIONS_N3 | Non Unique | Default | VARIANCE_POSTED_FLAG | |
| CST_COGS_TRANSACTIONS_N4 | Non Unique | Default | COST_STATUS | |
| CST_COGS_TRANSACTIONS_N5 | Non Unique | Default | TRANSACTION_DATE | |
| CST_COGS_TRANSACTIONS_N6 | Non Unique | Default | INVENTORY_ITEM_ID, COST_ORG_ID, COST_BOOK_ID, TRUNC("TRANSACTION_DATE") | |
| CST_COGS_TRANSACTIONS_N7 | Non Unique | Default | ACCOUNTING_STATUS | |
| CST_COGS_TRANSACTIONS_U1 | Unique | FUSION_TS_TX_DATA | CST_TRANSACTION_ID, TRANSACTION_ID | Obsolete |
| CST_COGS_TRANSACTIONS_U2 | Unique | Default | TRANSACTION_ID |