CST_REVENUE_LINES_S_GT
This is a global temporary table that will act as supporting table to load the revenue lines for which COGS and RMA Recognition transactions are supposed to be created.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_REVENUE_LINES_S_GT_PK |
REVENUE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REVENUE_LINE_ID | NUMBER | 18 | Yes | Unique revenue distribution identifier auto-created within costing. | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Billing / selling business unit identifier of the revenue line. | ||
| GL_DATE | DATE | The accounting date of the revenue distribution in the general ledger. | |||
| DOO_FULFILL_LINE_ID | NUMBER | 18 | Value that uniquely identifies the Distributed Order Orchestration fulfillment key. | ||
| ROOT_PARENT_FULFILL_LINE_ID | NUMBER | 18 | Unique identifier of the root or model item in case of complex flows involving KIT, PTO or ATO. | ||
| DOO_FLINE_PRICE_ADJUSTMENT_ID | NUMBER | 18 | Value that uniquely identifies the discount value for the item or manual price adjustment. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Value that uniquely identifies the inventory organization associated with the revenue line. | ||
| WAREHOUSE_ID | NUMBER | 18 | Value that uniquely identifies the inventory organization for the ship-from location. | ||
| DOCUMENT_TYPE | VARCHAR2 | 20 | Indicates the type of document associated with the revenue line. Possible values are: INV: Invoice. CM: Credit Memo. DM: Debit Memo. | ||
| REVENUE_PERCENTAGE | NUMBER | Percentage of the revenue recognized. | |||
| INVOICE_SOURCE | VARCHAR2 | 30 | The source of the invoice or contract associated with the revenue line. Possible values are: DOO: Distributed Order Orchestration. FOS: Supply Chain Financial Orchestration. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_REVENUE_LINES_S_GT_U1 | Unique | REVENUE_LINE_ID |