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 |