VRM_XLA_IFRS15_EXTRACT_GT

This table 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: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
EVENT_ID	NUMBER		18	Yes	Accounting event.	Active
OBLIG_CURRENCY_CODE	VARCHAR2	15			Currency code of the obligation.
LEGAL_ENTITY_ID	NUMBER		18		Legal entity of the source document.	Active
LINE_NUMBER	NUMBER		18		Oracle internal use only.	Active
LEDGER_ID	NUMBER		18		Ledger of the source document.	Active
EXCHANGE_RATE_TYPE	VARCHAR2	30			Conversion rate type used for converting amounts from the entered currency to the ledger currency.	Active
EXCHANGE_RATE	NUMBER				Conversion rate for converting amounts from the entered currency to the ledger currency.	Active
EXCHANGE_RATE_DATE	DATE				Conversion rate date used for converting amounts from the entered currency to the ledger currency.
AMOUNT	NUMBER				Amount in the entered currency for the extract line.	Active
EVENT_TYPE_CODE	VARCHAR2	30		Yes	Unique abbreviated name assigned to an event type and used for reporting or in reference to an option.	Active
EVENT_CLASS_CODE	VARCHAR2	30		Yes	Unique abbreviated name assigned to an event class and used for reporting or in reference to an option.	Active
UOM_CODE	VARCHAR2	3			Unit of measure of inventory item or memo line on a source document line.	Active
ACCOUNTED_AMOUNT	NUMBER				Accounted amount in the ledger currency.
ENTITY_CODE	VARCHAR2	30		Yes	Entity code of the transaction event.	Active
XLA_ENTITY_ID	NUMBER		18	Yes	Subledger transactions associated with the accounting events.	Active
CUSTOMER_CONTRACT_HEADER_ID	NUMBER		18		Customer contract header.	Active
PERF_OBLIGATION_LINE_ID	NUMBER		18		Performance obligation line.	Active
PERF_OBLIGATION_LINE_DIST_ID	NUMBER		18		Performance obligation line distribution.	Active
PERF_OBLIGATION_LINE_SPLIT_ID	NUMBER		18		Performance obligation line split.	Active
DOCUMENT_ID	NUMBER		18		Source document.	Active
DOCUMENT_LINE_ID	NUMBER		18		Source document line.	Active
H_BILL_CUSTOMER_ID	NUMBER		18		Bill-to customer.	Active
H_BILL_SITE_USE_ID	NUMBER		18		Bill-to customer site.	Active
INVENTORY_ITEM_ID	NUMBER		18		Inventory item.	Active
PERF_OBLIG_LINE_SALESREP_ID	NUMBER		18		Performance obligation line salesperson.	Active
L_BILL_CUSTOMER_ID	NUMBER		18		Bill-to customer for the source document line.	Active
L_BILL_SITE_USE_ID	NUMBER		18		Bill-to customer site for the source document line.	Active
DOCUMENT_TYPE_ID	NUMBER		18		Source document type.	Active
INVENTORY_ORG_ID	NUMBER		18		Inventory organization.	Active
MEMO_LINE_SEQ_ID	NUMBER		18		Memo line sequence.	Active
PERF_OBLIGATION_ID	NUMBER		18		Performance obligation.	Active
BU_ID	NUMBER		18		The business unit associated with the row.
LEVEL_CODE	VARCHAR2	1		Yes	Level of the standard source assignment. Possible values are H for Header, L for Line, and C for Currency.

Indexes

Index	Uniqueness	Columns
VRM_XLA_IFRS15_EXTRACT_GT_N1	Non Unique	EVENT_ID, LINE_NUMBER, LEVEL_CODE, EVENT_CLASS_CODE