AR_LINE_CONTS_ALL

The AR_LINE_CONTS_ALL table stores, for each line, contingencies that impact revenue.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

AR_LINE_CONTS_PK

CUSTOMER_TRX_LINE_ID, CONTINGENCY_CODE

Columns

Name Datatype Length Precision Not-null Comments
CUSTOMER_TRX_LINE_ID NUMBER Yes Invoice Line Identifier
COMMENTS VARCHAR2 2000 This column contains the comments entered by the user during the Add Revenue Contingency revenue adjustment action.
CONTINGENCY_CODE VARCHAR2 30 Yes Contingency Code Lookup Code for lookup type AR_REVENUE_CONTINGENCIES
EXPIRATION_DATE DATE Contingency Expiration Date
EXPIRATION_DAYS NUMBER Contingency Expiration in Days
COMPLETED_FLAG VARCHAR2 1 Flag indicating that the contingencies are removed on the line.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
REQUEST_ID NUMBER Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
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.
EXPIRATION_EVENT_DATE DATE Expiration event date
REASON_REMOVAL_DATE DATE Removal date of the revenue contingency.
COMPLETED_BY NUMBER Standard Who column - user who completed the contingency
DEFAULTED_IN_AR_FLAG VARCHAR2 1 Yes or No Flag indicating if contingencies default to invoice based on rule.
CONTINGENCY_ID NUMBER 18 Yes Contingency identifier
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.

Foreign Keys

Table Foreign Table Foreign Key Column
AR_LINE_CONTS_ALL ra_customer_trx_lines_all CUSTOMER_TRX_LINE_ID
AR_LINE_CONTS_ALL ar_deferral_reasons CONTINGENCY_ID

Indexes

Index Uniqueness Tablespace Columns
AR_LINE_CONTS_N1 Non Unique Default COMPLETED_FLAG
AR_LINE_CONTS_U1 Unique Default CUSTOMER_TRX_LINE_ID, CONTINGENCY_CODE