CST_I_AR_REVENUE_LINES_GT
This is global temporary table to process the data in interface table basing on commit limit and then move it to persistent table.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REF_ID | NUMBER | 18 | Yes | Value that uniquely identifies the unique transaction in the source system. | |
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Value that uniquely identifies the external source system. | |
| CUSTOMER_TRX_LINE_ID | NUMBER | 18 | The unique identifier of the invoice or the performance obligation line. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Billing or selling business unit identifier of the revenue line. | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | The currency code of the invoice or performance obligation associated with the revenue line. | ||
| LEDGER_ID | NUMBER | 18 | Yes | The unique identifier of the ledger where the revenue distribution is recorded. | |
| LEGAL_ENTITY_ID | NUMBER | 18 | The unique identifier of the legal entity corresponding to the revenue line. | ||
| INVOICE_NUMBER | VARCHAR2 | 20 | Yes | The invoice or contract number associated with the revenue line. | |
| UNIT_SELLING_PRICE | NUMBER | Selling price per unit for the transaction line. | |||
| QUANTITY_INVOICED | NUMBER | Quantity associated with the revenue line. | |||
| UOM_CODE | VARCHAR2 | 10 | Code for the unit of measure associated with the revenue line. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Value that uniquely identifies the inventory item. | ||
| INVOICE_DATE | TIMESTAMP | The date of the invoice or customer contract associated with the revenue line. | |||
| WAREHOUSE_ID | NUMBER | 18 | Value that uniquely identifies the inventory organization for the ship-from location. | ||
| DELIVERY_ID | VARCHAR2 | 30 | Value that uniquely identifies the delivery or the RMA receipt transaction. | ||
| GL_DATE | TIMESTAMP | The accounting date of the revenue distribution in the general ledger. | |||
| PREVIOUS_CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Value that uniquely identifies invoice or the performance obligation line for the Credit Memo. | ||
| CUSTOMER_TRX_ID | NUMBER | 18 | The unique identifier of the invoice or the customer contract header. | ||
| PREVIOUS_CUSTOMER_TRX_ID | NUMBER | 18 | Value that uniquely identifies invoice or customer contract header for the Credit Memo. | ||
| REVENUE_AMOUNT | NUMBER | Transaction line revenue amount. | |||
| EXTENDED_AMOUNT | NUMBER | Transaction line extended amount. | |||
| ACCTD_AMOUNT | NUMBER | Accounted amount in the functional currency. | |||
| INVOICE_LINE_AMOUNT | NUMBER | Amount in the invoice currency. | |||
| 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. | ||
| 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. | ||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | Value that uniquely identifies the bill to site. | ||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | Value that uniquely identifies the bill to customer. | ||
| DOO_FULFILL_LINE_ID | NUMBER | 18 | Value that uniquely identifies the Distributed Order Orchestration fulfillment key. | ||
| DOO_REFERENCE_FULFILL_LINE_ID | NUMBER | 18 | Value that uniquely identifies the Distributed Order Orchestration reference fulfillment line. | ||
| 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. | ||
| PARENT_FULFILL_LINE_ID | NUMBER | 18 | Value that uniquely identifies the parent fulfillment line for the component of a complex item. | ||
| REFERENCE_LINE_ID | NUMBER | 18 | Value that uniquely identifies the reference line. | ||
| DOO_ORDER_NUMBER | VARCHAR2 | 30 | Value that indicates Distributed Order Orchestration order number. | ||
| DOO_ORDER_TYPE | VARCHAR2 | 30 | Value that indicates Distributed Order Orchestration order type. | ||
| DOO_FLINE_PRICE_ADJUSTMENT_ID | NUMBER | 18 | Value that uniquely identifies the discount value for the item or manual price adjustment. | ||
| REVENUE_ACCOUNT | NUMBER | 18 | Value that uniquely identifies the sales representative related code combination. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Load request identifier used by file based data import process. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Value that uniquely identifies the inventory organization associated with the revenue line. | ||
| REVENUE_PERCENTAGE | NUMBER | Percentage of the revenue recognized. | |||
| ITEM_SUB_TYPE_CODE | VARCHAR2 | 30 | More specific sub group for the item type code in Distributed Order Orchestration (DOO). Possible values are: STANDARD, ATO, ATO-OPTION-CLASS, ATO-OPTION, PTO-SMC, PTO-NONSMC, OPTION-CLASS, OPTION, KIT-SMC, KIT-NONSMC, INCLUDED, etc. | ||
| ATO_TOP_MODEL_FLINE_ID | NUMBER | 18 | The unique identifier of the ATO model fulfillment line. In case of nested ATO, it represents the top level ATO model fulfillment line identifier. | ||
| ATO_TOP_MODEL_ITEM_ID | NUMBER | 18 | The unique identifier of the ATO model item. In case of nested ATO, it represents the top level ATO model item identifier. | ||
| CONFIG_INVENTORY_ITEM_ID | NUMBER | 18 | The unique identifier of the shippable ATO configured item. | ||
| STATUS | VARCHAR2 | 2 | Indicates the status of the revenue line. Possible values are: NULL: New revenue line. Not yet processed by COGS Processor. P: Picked for processing by COGS Processor. D: Indicates duplicate or invalid revenue line. PR: Indicates Projects related revenue line. SE: Ship-bill reference is not available to create COGS or RMA Recognition transaction. | ||
| SHIP_BILL_REF_FLAG | VARCHAR2 | 1 | Indicates if the ship-bill reference is generated for the revenue line. Possible values are: NULL: For invoice source other than Distributed Order Orchestration (DOO). N: Ship-bill reference is not yet generated for the revenue line with invoice source as Distributed Order Orchestration (DOO). Y: Ship-bill reference is generated for the revenue line with invoice source as Distributed Order Orchestration (DOO). | ||
| PRJ_REC_INDICATOR | VARCHAR2 | 1 | A flag that indicates if the revenue line is for Projects related fulfillment. Possible values are: Y: Revenue line is for Project related fulfillment. N: Revenue line is not for Projects related fulfillment. | ||
| VRM_SRC_DOC_ID | NUMBER | 18 | For the revenue line with source as Revenue Management, this will be the unique identifier of the source document for a sales order, invoice, project or service contract. | ||
| VRM_SRC_DOC_LINE_ID | NUMBER | 18 | For the revenue line with source as Revenue Management, this will be the unique identifier of the source document line. Examples of source document line include sales order line, invoice line, project line, and service contract line. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_I_AR_REVENUE_LINES_GT_U1 | Unique | EXTERNAL_SYSTEM_REF_ID, EXTERNAL_SYSTEM_REFERENCE |