AR_SUM_INCOMPLETE_TRX
AR_SUM_INCOMPLETE_TRX is used in the Receivables Dashboard and displays the summary information of incomplete transactions.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: SUMMARY
Primary Key
Name | Columns |
---|---|
AR_SUM_INCOMPLETE_TRX_PK |
INCOMPLETE_TRX_SUM_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INCOMPLETE_TRX_SUM_ID | NUMBER | 18 | Yes | Indicates the identifier of Primary Key associated to the row | |
TRX_CLASS | VARCHAR2 | 20 | Indicates transaction class of the incomplete transaction | ||
TRX_COUNT | NUMBER | Indicates count of incomplete transaction associated to the row. | |||
TRX_AMT | NUMBER | Indicates accounted amount of incomplete transaction associated to the row. | |||
ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
PERIOD_NAME | VARCHAR2 | 15 | Indicates General Ledger Period Name associated to the row | ||
CURRENCY_CODE | VARCHAR2 | 20 | Indicates Currency Code associated to the row |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
AR_SUM_INCOMPLETE_TRX_U1 | Unique | Default | INCOMPLETE_TRX_SUM_ID |