AR_SUM_PENDING_RECAPP
AR_SUM_PENDING_RECAPP is used in the Receivables Dashboard and displays the summary information of receipts pending application.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: SUMMARY
Primary Key
| Name | Columns |
|---|---|
|
AR_SUM_PENDING_RECAPP_PK |
RECAPP_PENDING_SUM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECAPP_PENDING_SUM_ID | NUMBER | 18 | Yes | Indicates the identifier of Primary Key associated to the row | |
| PARTY_ID | NUMBER | 18 | Receivables Specialist Identifier associated to the row | ||
| RECEIPT_COUNT | NUMBER | Indicates count of receipts pending application associated to the row | |||
| RECEIPT_AMT | NUMBER | Indicates accounted amount of receipts pending application associated to the row | |||
| RECEIPT_DATE | DATE | Indicates receipt date 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 | 15 | Indicates Currency Code associated to the row |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_SUM_PENDING_RECAPP | hz_parties | PARTY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_SUM_PENDING_RECAPP_U1 | Unique | Default | RECAPP_PENDING_SUM_ID |