VRM_PO_ASSET_LIAB_NETTING
This table contains the netting details of the Contract Asset and Contract Liability accounts for performance obligations for each period.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
VRM_PO_ASSET_LIAB_NETTING_PK |
PO_ASSET_LIAB_NETTING_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| PO_ASSET_LIAB_NETTING_ID | NUMBER | 18 | Yes | Contract asset and liability netting details table unique identifier. | ||
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Number that identifies the customer contract header. | |||
| PERF_OBLIGATION_ID | NUMBER | 18 | Number that identifies the performance obligation. | |||
| CURRENCY_CODE | VARCHAR2 | 30 | Transaction currency code of the contract. | |||
| ALLOCATION_METHOD_CODE | VARCHAR2 | 30 | Allocation currency basis used to allocate and recognize revenue for a contract. Valid values are from the lookup type ORA_VRM_ALLOCATION_METHOD. | |||
| CONTRACT_ASSET_AMT_ENT_CURR | NUMBER | Total contract asset amount of the performance obligation in the entered currency. | ||||
| CONTRACT_ASSET_AMT_ACCTD_CURR | NUMBER | Total contract asset amount of the performance obligation in the accounted currency. | ||||
| CONTRACT_LIAB_AMT_ENTERED_CURR | NUMBER | Total contract liability amount of the performance obligation in the entered currency. | ||||
| CONTRACT_LIAB_AMT_ACCTD_CURR | NUMBER | Total contract liability amount of the performance obligation in the accounted currency. | ||||
| CONTRACT_DISC_AMT_ENTERED_CURR | NUMBER | Total contract discount amount of the performance obligation in the entered currency. | ||||
| CONTRACT_DISC_AMT_ACCTD_CURR | NUMBER | Total contract discount amount of the performance obligation in the accounted currency. | ||||
| NET_POSITION_AMT_ENTERED_CURR | NUMBER | Net position of the performance obligation in the entered currency. | ||||
| NET_POSITION_AMT_ACCTD_CURR | NUMBER | Net position of the performance obligation in the accounted currency. | ||||
| CAL_CONTRACT_ASSET_AMT_ENT_CUR | NUMBER | Total contract asset amount of the performance obligation converted into the entered currency using the period end conversion rate. This amount is calculated for foreign currency contracts where the allocation currency basis is Accounted. | ||||
| CAL_CONTRACT_ASSET_AMT_ACC_CUR | NUMBER | Total contract asset amount of the performance obligation converted into the accounted currency using the period end conversion rate. This amount is calculated for foreign currency contracts where the allocation currency basis is Entered. | ||||
| CAL_CONTRACT_LIAB_AMT_ENT_CUR | NUMBER | Total contract liability amount of the performance obligation converted into the entered currency using the period end conversion rate. This amount is calculated for foreign currency contracts where the allocation currency basis is Accounted. | ||||
| CAL_CONTRACT_LIAB_AMT_ACC_CUR | NUMBER | Total contract liability amount of the performance obligation converted into the accounted currency using the period end conversion rate. This amount is calculated for foreign currency contracts where the allocation currency basis is Entered. | ||||
| CAL_CONTRACT_DISC_AMT_ENT_CUR | NUMBER | Total contract discount amount of the performance obligation converted into the entered currency using the period end conversion rate. This amount is calculated for foreign currency contracts where the allocation currency basis is Accounted. | ||||
| CAL_CONTRACT_DISC_AMT_ACC_CUR | NUMBER | Total contract discount amount of the performance obligation converted into the accounted currency using the period end conversion rate. This amount is calculated for foreign currency contracts where the allocation currency basis is Entered. | ||||
| CALC_NET_POSITION_ENTERED_CUR | NUMBER | Net position of the performance obligation converted into the entered currency using the period end conversion rate. This amount is calculated for foreign currency contracts where the allocation currency basis is Accounted. | ||||
| CALC_NET_POSITION_ACCTD_CUR | NUMBER | Net position of the performance obligation converted into the accounted currency using the period end conversion rate. This amount is calculated for foreign currency contracts where the allocation currency basis is Entered. | ||||
| LEDGER_ID | NUMBER | 18 | Number that identifies the ledger of the contract. | |||
| EVENT_ID | NUMBER | 18 | Number that identifies the subledger accounting event. | |||
| ACCOUNTING_DATE | DATE | Accounting date of the netting entry. | ||||
| EXECUTION_MODE_CODE | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Obsolete | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| 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. | |||
| DISTRIBUTIONS_CREATED_FLAG | VARCHAR2 | 1 | Indicates whether the performance obligation netting distributions are created. | |||
| LATEST_RECORD_FLAG | VARCHAR2 | 1 | Latest record for the given ledger, contract, and performance obligation. | |||
| EXCHANGE_RATE | NUMBER | Conversion rate for converting amounts from the obligation currency to the ledger currency. | ||||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type used for converting amounts from the entered currency to the ledger currency. | |||
| PERIOD_NAME | VARCHAR2 | 15 | Fiscal period a company uses to report financial results, such as a calendar month or fiscal period. Accounting periods make up an accounting calendar. | |||
| LEDGER_CURRENCY | VARCHAR2 | 15 | Functional currency of the ledger. | |||
| POSTING_CONTROL_ID | NUMBER | 18 | Posting batch identifier. -3 Indicates unposted distributions. | |||
| POSTED_TO_SLA_FLAG | VARCHAR2 | 1 | Indicates if a revenue line is posted to subledger application. | |||
| POSTED_TO_SLA_DATE | DATE | Date when the revenue is posted to the subledger application. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_PO_ASSET_LIAB_NETTING | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
| VRM_PO_ASSET_LIAB_NETTING | vrm_perf_obligations | PERF_OBLIGATION_ID |
| VRM_PO_ASSET_LIAB_NETTING | gl_ledgers | LEDGER_ID |
| VRM_PO_ASSET_LIAB_NETTING | GL_DAILY_CONVERSION_TYPES | EXCHANGE_RATE_TYPE |
| VRM_PO_ASSET_LIAB_NETTING | FND_CURRENCIES_B | CURRENCY_CODE |
| VRM_PO_ASSET_LIAB_NETTING | FND_CURRENCIES_B | LEDGER_CURRENCY |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_PO_ASSET_LIAB_NETTING_N1 | Non Unique | VRM_PO_ASSET_LIAB_NETTING_N1 | PERF_OBLIGATION_ID, LATEST_RECORD_FLAG |
| VRM_PO_ASSET_LIAB_NETTING_N2 | Non Unique | VRM_PO_ASSET_LIAB_NETTING_N2 | ACCOUNTING_DATE, DISTRIBUTIONS_CREATED_FLAG, LEDGER_ID |
| VRM_PO_ASSET_LIAB_NETTING_U1 | Unique | VRM_PO_ASSET_LIAB_NETTING_U1 | PO_ASSET_LIAB_NETTING_ID |
| VRM_PO_ASSET_LIAB_NETTING_U2 | Unique | VRM_PO_ASSET_LIAB_NETTING_U2 | PERF_OBLIGATION_ID, ACCOUNTING_DATE |