DBA Data[Home] [Help] [Dependency Information]

TABLE: AR.AR_INTEREST_HEADERS_ALL

Object Details
Object Name: AR_INTEREST_HEADERS_ALL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_INTEREST_HEADERS_ALL
Subobject Name:
Status: VALID


Late Charges interest decoument headers


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_INTEREST_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTEREST_HEADER_ID
AR_INTEREST_HEADERS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTEREST_BATCH_ID
ColumnINTEREST_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
INTEREST_HEADER_ID NUMBER (15) Yes Primary Key
INTEREST_BATCH_ID NUMBER (15) Yes Foreign key to ra_interest_batches_all.interest_batch_id
CUSTOMER_ID NUMBER (15) Yes Foreign key to hz_cust_accounts_all.cust_account_id
CUSTOMER_SITE_USE_ID NUMBER (15) 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 orlate 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

Receipt grace days
LATE_CHARGE_TERM_ID NUMBER (15)
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)
Interest calculation period
CHARGE_ON_FINANCE_CHARGE_FLAG VARCHAR2 (1)
Formulae on overdue amount to compute interest
HOLD_CHARGED_INVOICES_FLAG VARCHAR2 (1)
Place a hold on charged invoices
MESSAGE_TEXT_ID NUMBER (15)
Message text ar_standard_text.standard_text_id
MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 (1)
Use Multiple Interest Rates
CHARGE_BEGIN_DATE DATE

Charge begin date
CUST_ACCT_PROFILE_AMT_ID NUMBER (15)
Foreign Key to HZ_CUST_PROFILE_AMTS.CUST_ACCT_PROFILE_AMT_ID
EXCHANGE_RATE NUMBER (15)
Exchange rate
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange 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 (15)
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 (15)
Foreign key to ar_charges_schedules.schedule_id
LAST_ACCRUE_CHARGE_DATE DATE

Date as of which last compounded
CUSTOMER_PROFILE_ID NUMBER (15)
Foreign key to hz_customer_profiles.cust_account_profile_id
COLLECTOR_ID NUMBER (15)
Foreign key to collectors entity
LEGAL_ENTITY_ID NUMBER (15)
Foreign key of the legal entity
PROCESS_MESSAGE VARCHAR2 (2000)
Error message text
PROCESS_STATUS VARCHAR2 (30)
Status code to indicate Success or Error
CUST_TRX_TYPE_ID NUMBER (15)
Interest Type i.e. Invoice/Debit Memo, ar_receivables_trx_all.receivable_trx_id
ORG_ID NUMBER (15) Yes Organization Id
OBJECT_VERSION_NUMBER NUMBER

Object version number
WORKER_NUM NUMBER (15)
Worker Id which created the header for the request id
REQUEST_ID NUMBER (15)
Request id which created the header
FINANCE_CHARGE_DATE DATE

Date as of which the finance charge was generated
LAST_UPDATE_DATE DATE
Yes Who Column
LAST_UPDATED_BY NUMBER (15) Yes Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Who Column
CREATED_BY NUMBER (15) Yes Who Column
CREATION_DATE DATE
Yes Who Column
DISPLAY_FLAG VARCHAR2 (1)
For Internal processing only
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTEREST_HEADER_ID
,      INTEREST_BATCH_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      HEADER_TYPE
,      CURRENCY_CODE
,      LATE_CHARGE_CALCULATION_TRX
,      CREDIT_ITEMS_FLAG
,      DISPUTED_TRANSACTIONS_FLAG
,      PAYMENT_GRACE_DAYS
,      LATE_CHARGE_TERM_ID
,      INTEREST_PERIOD_DAYS
,      INTEREST_CALCULATION_PERIOD
,      CHARGE_ON_FINANCE_CHARGE_FLAG
,      HOLD_CHARGED_INVOICES_FLAG
,      MESSAGE_TEXT_ID
,      MULTIPLE_INTEREST_RATES_FLAG
,      CHARGE_BEGIN_DATE
,      CUST_ACCT_PROFILE_AMT_ID
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      MIN_FC_INVOICE_OVERDUE_TYPE
,      MIN_FC_INVOICE_AMOUNT
,      MIN_FC_INVOICE_PERCENT
,      MIN_FC_BALANCE_OVERDUE_TYPE
,      MIN_FC_BALANCE_AMOUNT
,      MIN_FC_BALANCE_PERCENT
,      MIN_INTEREST_CHARGE
,      MAX_INTEREST_CHARGE
,      INTEREST_TYPE
,      INTEREST_RATE
,      INTEREST_FIXED_AMOUNT
,      INTEREST_SCHEDULE_ID
,      PENALTY_TYPE
,      PENALTY_RATE
,      PENALTY_FIXED_AMOUNT
,      PENALTY_SCHEDULE_ID
,      LAST_ACCRUE_CHARGE_DATE
,      CUSTOMER_PROFILE_ID
,      COLLECTOR_ID
,      LEGAL_ENTITY_ID
,      PROCESS_MESSAGE
,      PROCESS_STATUS
,      CUST_TRX_TYPE_ID
,      ORG_ID
,      OBJECT_VERSION_NUMBER
,      WORKER_NUM
,      REQUEST_ID
,      FINANCE_CHARGE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      DISPLAY_FLAG
FROM AR.AR_INTEREST_HEADERS_ALL;

Dependencies

[top of page]

AR.AR_INTEREST_HEADERS_ALL does not reference any database object

AR.AR_INTEREST_HEADERS_ALL is referenced by following:

SchemaAR
ViewAR_INTEREST_HEADERS_ALL#