AR_INTEREST_HEADERS_ALL
The AR_INTEREST_HEADERS_ALL table contains header level late charge document information.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_INTEREST_HEADERS_PK |
INTEREST_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTEREST_HEADER_ID | NUMBER | 18 | Yes | Interest header identifier. It is used as a primary key. | |
| INTEREST_BATCH_ID | NUMBER | 18 | Yes | Foreign key to ra_interest_batches_all.interest_batch_id | |
| CUSTOMER_ID | NUMBER | 18 | Yes | Foreign key to HZ_CUST_ACCOUNTS_ALL.CUST_ACCOUNT_ID. | |
| CUSTOMER_SITE_USE_ID | NUMBER | 18 | Yes | Foreign Key to HZ_CUST_SITE_USES_ALL.SITE_USE_ID. | |
| HEADER_TYPE | VARCHAR2 | 30 | Yes | Type of late charges documents ADJ, DM, INV | |
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code from FND_CURRENCIES. | |
| LATE_CHARGE_CALCULATION_TRX | VARCHAR2 | 30 | Yes | Eligibility criteria to select transactions for late charge processing based on overdue invoices and late payments. | |
| CREDIT_ITEMS_FLAG | VARCHAR2 | 1 | Eligibility criteria to select transactions for late charge processing based on optional late charges | ||
| DISPUTED_TRANSACTIONS_FLAG | VARCHAR2 | 1 | Eligibility criteria to select transactions for late charge processing based on optional late charges | ||
| PAYMENT_GRACE_DAYS | NUMBER | Grace days after which payment is considered late and eligible for late charge calculation. | |||
| LATE_CHARGE_TERM_ID | NUMBER | 18 | If late charge type is DEBIT_MEMO/INTEREST_INVOICE then the payment term must be populated,this is used to create the Invoice or Debit Memo | ||
| INTEREST_PERIOD_DAYS | NUMBER | Days in interest period | |||
| INTEREST_CALCULATION_PERIOD | VARCHAR2 | 30 | Period over which to calculate late charges for the customer. | ||
| CHARGE_ON_FINANCE_CHARGE_FLAG | VARCHAR2 | 1 | Formula on overdue amount to compute interest. | ||
| HOLD_CHARGED_INVOICES_FLAG | VARCHAR2 | 1 | Place a hold on charged invoices | ||
| MESSAGE_TEXT_ID | NUMBER | 18 | Message text printed on the late charge transaction. Applies only to late charges recorded as invoices or debit memos. Foreign key to AR_STANDARD_TEXT.STANDARD_TEXT_ID. | ||
| MULTIPLE_INTEREST_RATES_FLAG | VARCHAR2 | 1 | Use Multiple Interest Rates | ||
| CHARGE_BEGIN_DATE | DATE | Start date for last charge calculation. | |||
| CUST_ACCT_PROFILE_AMT_ID | NUMBER | 18 | Foreign Key to HZ_CUST_PROFILE_AMTS.CUST_ACCT_PROFILE_AMT_ID | ||
| EXCHANGE_RATE | NUMBER | 18 | Conversion rate. | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type. | ||
| MIN_FC_INVOICE_OVERDUE_TYPE | VARCHAR2 | 30 | Minimum Invoice amount overdue type | ||
| MIN_FC_INVOICE_AMOUNT | NUMBER | Invoice balance threshold amount below which late charges must not be charged. | |||
| MIN_FC_INVOICE_PERCENT | NUMBER | Invoice balance threshold percentage below which late charges must not be charged. | |||
| MIN_FC_BALANCE_OVERDUE_TYPE | VARCHAR2 | 30 | Minimum customer balance overdue type | ||
| MIN_FC_BALANCE_AMOUNT | NUMBER | Customer balance threshold amount below which the late charge must not be charged | |||
| MIN_FC_BALANCE_PERCENT | NUMBER | Customer balance percentage threshold below which the late charge must not be charged | |||
| MIN_INTEREST_CHARGE | NUMBER | Threshold amount below which the late charge must not charged. | |||
| MAX_INTEREST_CHARGE | NUMBER | Threshold amount above which the late charge must not be charged. | |||
| INTEREST_TYPE | VARCHAR2 | 30 | Fixed amount, percent, charges schedule based interest. | ||
| INTEREST_RATE | NUMBER | Interest rate | |||
| INTEREST_FIXED_AMOUNT | NUMBER | Interest amount | |||
| INTEREST_SCHEDULE_ID | NUMBER | 18 | Foreign key to AR_CHARGES_SCHEDULES.SCHEDULE_ID. | ||
| PENALTY_TYPE | VARCHAR2 | 30 | Fixed amount, percent, charges schedule based penalty. | ||
| PENALTY_RATE | NUMBER | Penalty rate | |||
| PENALTY_FIXED_AMOUNT | NUMBER | Penalty amount | |||
| PENALTY_SCHEDULE_ID | NUMBER | 18 | Foreign key to AR_CHARGES_SCHEDULES.SCHEDULE_ID. | ||
| LAST_ACCRUE_CHARGE_DATE | DATE | Date as of which last compounded | |||
| CUSTOMER_PROFILE_ID | NUMBER | 18 | Foreign key to HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_PROFILE_ID. | ||
| COLLECTOR_ID | NUMBER | 18 | Foreign key to collectors entity | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Foreign key of the legal entity | ||
| PROCESS_MESSAGE | VARCHAR2 | 2000 | Error message text | ||
| PROCESS_STATUS | VARCHAR2 | 30 | Status code to indicate Success or Error | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to 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. | |
| WORKER_NUM | NUMBER | 18 | Worker Id which created the header for the request id | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| FINANCE_CHARGE_DATE | DATE | Date as of which the finance charge was generated | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who 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. | ||
| DISPLAY_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| CUST_TRX_TYPE_SEQ_ID | NUMBER | 18 | Transaction type sequence identifier. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_INTEREST_HEADERS_ALL | ar_collectors | COLLECTOR_ID |
| AR_INTEREST_HEADERS_ALL | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
| AR_INTEREST_HEADERS_ALL | xle_entity_profiles | LEGAL_ENTITY_ID |
| AR_INTEREST_HEADERS_ALL | hz_cust_accounts | CUSTOMER_ID |
| AR_INTEREST_HEADERS_ALL | hz_cust_site_uses_all | CUSTOMER_SITE_USE_ID |
| AR_INTEREST_HEADERS_ALL | ra_terms_b | LATE_CHARGE_TERM_ID |
| AR_INTEREST_HEADERS_ALL | hz_cust_profile_amts_f | CUST_ACCT_PROFILE_AMT_ID, CREATION_DATE, LAST_UPDATE_DATE |
| AR_INTEREST_HEADERS_ALL | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| AR_INTEREST_HEADERS_ALL | ar_charge_schedules | INTEREST_SCHEDULE_ID |
| AR_INTEREST_HEADERS_ALL | ar_charge_schedules | PENALTY_SCHEDULE_ID |
| AR_INTEREST_HEADERS_ALL | hz_customer_profiles_f | CUSTOMER_PROFILE_ID, CREATION_DATE, LAST_UPDATE_DATE |
| ra_customer_trx_all | ar_interest_headers_all | INTEREST_HEADER_ID |
| ar_adjustments_all | ar_interest_headers_all | INTEREST_HEADER_ID |
| ar_interest_lines_all | ar_interest_headers_all | INTEREST_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_INTEREST_HEADERS_U1 | Unique | Default | INTEREST_HEADER_ID |
| AR_INTEREST_HEADERS_U2 | Unique | Default | INTEREST_BATCH_ID, INTEREST_HEADER_ID |