VRM_REVENUE_ASSIGNMENTS_GT
VRM_REVENUE_ASSIGNMENTS_GT is a global temporary table used while processing return or version lines.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SESSION_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| REVENUE_DOCUMENT_LINE_ID | NUMBER | 18 | Yes | Revenue document line identifier. | |
| COMPLETE_FLAG | VARCHAR2 | 1 | Yes | A flag that indicates if a revenue document is completed. | |
| ACCOUNT_CLASS | VARCHAR2 | 80 | Yes | Account class associated with the revenue adjustment schedule line account code. | |
| LUMP_SUM_FLAG | VARCHAR2 | 1 | A flag derived from type of rule which is used for internal processing. | ||
| RULE_TYPE | VARCHAR2 | 40 | Yes | Rule type assigned to the revenue line. Values are from the lookup RULE_TYPE. | |
| PERIOD_NUMBER | NUMBER | 18 | Yes | Sequence number of this schedule. | |
| PERCENT | NUMBER | Percent of the line amount to be recognized on a specified accounting date. | |||
| RULE_DATE | DATE | Date on which to recognize revenue. | |||
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Ledger unique identifier. | |
| PERIOD_TYPE | VARCHAR2 | 120 | Accounting period type. Examples are Weekly, Monthly, Quarterly. | ||
| MAX_REGULAR_PERIOD_LENGTH | NUMBER | 18 | Maximum number of days in a period within this period type. | ||
| PPRR_AMOUNT | NUMBER | Used by rules for processing the partial amounts. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_REVENUE_ASSIGNMENTS_GT_N1 | Non Unique | REVENUE_DOCUMENT_LINE_ID |