VRM_XLA_LINES_EXTRACT_GT
VRM_XLA_LINES_EXTRACT_GT temporarily contains the extracted accounting lines belonging to the specific Create Accounting session. The lines are deleted when the session expires.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EVENT_ID | NUMBER | 18 | SLA event unique identifier. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity unique identifier. | ||
| LINE_NUMBER | NUMBER | 18 | Extract accounting unique identifier. | ||
| LEDGER_ID | NUMBER | 18 | Ledger unique identifier. | ||
| LINE_ID | NUMBER | 18 | Extract line unique identifier. | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type of the extract line. | ||
| EXCHANGE_RATE | NUMBER | Conversion rate of the extract line. | |||
| EXCHANGE_DATE | DATE | Conversion rate date of the extract line. | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| SET_OF_BOOKS_ID | NUMBER | 18 | Unique identifier of a ledger. | ||
| LEVEL_FLAG | VARCHAR2 | 1 | Indicates if record is header or line level data. Possible values are Yes or No. | ||
| AMOUNT | NUMBER | Amount in transaction currency for the extract line. | |||
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Code name of the event type. | ||
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Code name of the event class. | ||
| UOM_CODE | VARCHAR2 | 3 | Code name of the unit of measure. | ||
| ACCTD_AMOUNT | NUMBER | Amount in functional currency for the extract line. | |||
| ENTITY_CODE | VARCHAR2 | 30 | Code name of the entity. | ||
| XLA_ENTITY_ID | NUMBER | 18 | Identifies the record that references the parent entity in XLA_TRANSACTION_ENTITIES tables. | ||
| REVENUE_DOCUMENT_ID | NUMBER | 18 | Revenue document unique identifier. | ||
| REVENUE_DOCUMENT_LINE_ID | NUMBER | 18 | Revenue document line unique identifier. | ||
| REVENUE_DOC_LINE_SCHEDULE_ID | NUMBER | 18 | Revenue document line schedule unique identifier. | ||
| REVENUE_LINE_SPLIT_ID | NUMBER | 18 | Revenue document line split unique identifier. | ||
| SOURCE_DOCUMENT_ID | NUMBER | 18 | Source document unique identifier. | ||
| SOURCE_DOCUMENT_LINE_ID | NUMBER | 18 | Source document line unique identifier. | ||
| BILL_CUSTOMER_ID | NUMBER | 18 | Bill to customer unique identifier. | ||
| BILL_SITE_USE_ID | NUMBER | 18 | Bill to customer site unique identifier. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item unique identifier. | ||
| REV_DOC_LINE_SALESREP_ID | NUMBER | 18 | Salesperson unique identifier. | ||
| SHIP_CUSTOMER_ID | NUMBER | 18 | Ship to customer unique identifier. | ||
| SHIP_SITE_USE_ID | NUMBER | 18 | Ship to customer site unique identifier. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_XLA_LINES_EXTRACT_GT_N1 | Non Unique | EVENT_ID, LINE_NUMBER, LEVEL_FLAG, EVENT_CLASS_CODE |
| VRM_XLA_LINES_EXTRACT_GT_N2 | Non Unique | LINE_ID |