IEX_DELINQ_SUMMARIES_ALL
Stores delinquency summary information of all delinquent customers, accounts or sites.
Details
-
Schema: FUSION
-
Object owner: IEX
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
IEX_DELINQ_SUMMARIES_ALL_PK |
DEL_SUMMARY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DEL_SUMMARY_ID | NUMBER | 18 | Yes | Primary key. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Identifies the concurrent program fnd_global.conc_program_name | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Identifies the Application name spawning the Concurrent Request fnd_global.prog_appl_name | ||
| 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. | ||
| 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. | |
| PARTY_ID | NUMBER | 18 | Yes | Foreign key to HZ_PARTIES. Delinquent customer. | |
| CUST_ACCOUNT_ID | NUMBER | 18 | Foreign key to HZ_CUST_ACCOUNTS. Delinquent account. | ||
| SITE_USE_ID | NUMBER | 18 | Foreign key to HZ_CUST_SITE_USES_ALL. Delinquent bill-to site. | ||
| CURRENCY | VARCHAR2 | 15 | Yes | Currency code of the country of customer. | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| ACCOUNT_NUMBER | VARCHAR2 | 30 | Account number of the customer. | ||
| AGING_AMT_LINE_1 | NUMBER | Amount in aging line 1. | |||
| AGING_AMT_LINE_2 | NUMBER | Amount in aging line 2. | |||
| AGING_AMT_LINE_3 | NUMBER | Amount in aging line 3. | |||
| AGING_AMT_LINE_4 | NUMBER | Amount in aging line 4 | |||
| AGING_AMT_LINE_5 | NUMBER | Amount in aging line 5. | |||
| AGING_AMT_LINE_6 | NUMBER | Amount in aging line 6. | |||
| AGING_AMT_LINE_7 | NUMBER | Amount in aging line 7. | |||
| AGING_BUCKET_ID | NUMBER | 18 | Identifier of aging bucket from aging bucket table. | ||
| TOTAL_AMOUNT_DUE | NUMBER | Sum of the amounts from Aging bucket line 1 to 7. This is total amount due for the customer, account or site. | |||
| BUCKET_NAME | VARCHAR2 | 30 | Name of the aging bucket. | ||
| COLLECTOR_ID | NUMBER | 18 | Identifier for the collector assigned to the record. | ||
| COLLECTOR_NAME | VARCHAR2 | 30 | Name of the collector assigned to the record. | ||
| DISPLAY_NAME | VARCHAR2 | 360 | The customer name, account or site associated with this record. | ||
| NUMBER_DELINQUENCIES | NUMBER | 18 | Total number of delinquencies per customer. | ||
| OPEN_CHARBACK_AMOUNT | NUMBER | Chargeback amount related to the the delinquency record. | |||
| OPEN_CHARGEBACK_NUMBER | NUMBER | 18 | Chargeback number related to the the delinquency record. | ||
| OPEN_DEBITMEMO_AMOUNT | NUMBER | Debit memo amount related to the the delinquency record. | |||
| OPEN_DEBITMEMO_NUMBER | NUMBER | 18 | Debit memo number related to the the delinquency record. | ||
| OPEN_INVOICE_AMOUNT | NUMBER | Invoice amount related to the the delinquency record. | |||
| OPEN_INVOICE_NUMBER | NUMBER | 18 | Invoice number related to the the delinquency record. | ||
| PARTY_NAME | VARCHAR2 | 360 | Customer name. | ||
| PARTY_NUMBER | VARCHAR2 | 30 | Customer number. | ||
| RESERVED1 | NUMBER | Reserved column. | |||
| RESERVED2 | NUMBER | Reserved column. | |||
| RESERVED3 | VARCHAR2 | 30 | Reserved column. | ||
| RESERVED4 | VARCHAR2 | 30 | Reserved column. | ||
| RESERVED5 | VARCHAR2 | 30 | Reserved column. | ||
| SITE_LOCATION | VARCHAR2 | 360 | Location of the delinquent customer. | ||
| STATUS_DATE | DATE | Date on which the status was created or updated. | |||
| STATUS_TYPE | VARCHAR2 | 30 | The type of status related to the delinquency. | ||
| WORKER_NUMBER | NUMBER | 18 | Used for parallel programming . | ||
| BUSINESS_LEVEL | VARCHAR2 | 30 | Business level of each party. | ||
| OPEN_CREDITMEMO_NUMBER | NUMBER | Credit memo number related to the the delinquency record. | |||
| OPEN_CREDITMEMO_AMOUNT | NUMBER | Credit memo amount related to the the delinquency record. | |||
| DISPUTED_INV_NUMBER | NUMBER | Invoice number in dispute. | |||
| DISPUTED_INV_AMOUNT | NUMBER | Invoice amount in dispute. | |||
| NEW_FLAG | VARCHAR2 | 1 | Indicates if newly delinquent customer, set to Y, otherwise N | ||
| LAST_PAYMENT_DATE | DATE | Last payment date for customer | |||
| CONTACT_PARTY_ID | NUMBER | 18 | Unique identifier of contact party | ||
| FIRST_DUE_DATE | DATE | Oldest unpaid due date for the customer | |||
| STRATEGY_ID | NUMBER | 18 | Unique identifier of a strategy | ||
| SCORE_VALUE | NUMBER | Score value for customer | |||
| PREDELINQ_STRATEGY_ID | NUMBER | 18 | Unique identifier of the predelinquent strategy assigned to the customer. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IEX_DELINQ_SUMMARIES_ALL | hz_parties | PARTY_ID |
| IEX_DELINQ_SUMMARIES_ALL | hz_cust_accounts | CUST_ACCOUNT_ID |
| IEX_DELINQ_SUMMARIES_ALL | hz_cust_site_uses_all | SITE_USE_ID |
| IEX_DELINQ_SUMMARIES_ALL | hz_parties | CONTACT_PARTY_ID |
| IEX_DELINQ_SUMMARIES_ALL | iex_strategies | STRATEGY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IEX_DELINQ_SUMMARIES_ALL_N1 | Non Unique | Default | COLLECTOR_ID, STATUS_TYPE |
| IEX_DELINQ_SUMMARIES_ALL_N2 | Non Unique | Default | ACCOUNT_NUMBER |
| IEX_DELINQ_SUMMARIES_ALL_N3 | Non Unique | Default | UPPER("PARTY_NAME") |
| IEX_DELINQ_SUMMARIES_ALL_U1 | Unique | Default | ORG_ID, PARTY_ID, CUST_ACCOUNT_ID, SITE_USE_ID |
| IEX_DELINQ_SUMMARIES_ALL_U2 | Unique | Default | DEL_SUMMARY_ID |