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

TABLE: FEM.FEM_MERCHANT_CARDS

Object Details
Object Name: FEM_MERCHANT_CARDS
Object Type: TABLE
Owner: FEM
Subobject Name:
Status: VALID


Merchant Cards


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_MERCHANT_CARDS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCAL_PERIOD_ID
ColumnDATASET_CODE
ColumnSOURCE_SYSTEM_CODE
ColumnID_NUMBER
FEM_MERCHANT_CARDS_01 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREATED_BY_REQUEST_ID
ColumnCREATED_BY_OBJECT_ID
ColumnID_NUMBER
Columns
Name Datatype Length Mandatory Comments
CAL_PERIOD_ID NUMBER
Yes Calendar Period
DATASET_CODE NUMBER
Yes Dataset Code
SOURCE_SYSTEM_CODE NUMBER
Yes Source System
ID_NUMBER NUMBER
Yes Uniquely identifies an instrument.
CREATED_BY_OBJECT_ID NUMBER (9) Yes Object that created the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID
CREATED_BY_REQUEST_ID NUMBER
Yes Request that created the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID
LAST_UPDATED_BY_OBJECT_ID NUMBER (9) Yes Object that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID
LAST_UPDATED_BY_REQUEST_ID NUMBER
Yes Request that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
LEDGER_ID NUMBER
Yes Ledger
EMBEDDED_OPTIONS_FLG VARCHAR2 (30)
Embedded Options Flag; Y means this account has one or related rows in the EMBEDDED_OPTIONS table.
JOINT_ACCOUNT_FLG VARCHAR2 (30)
Y designates that the account is joint-owned
MC_MERCHANT_FLG VARCHAR2 (30)
Y designates that the merchant is a MasterCard merchant
MC_TRANS_FLG VARCHAR2 (30)
Y designates that the merchant is a MasterCard merchant
OPEN_ACCOUNT_FLG VARCHAR2 (30)
Identifies that the account is open
VIP_ACCOUNT_FLG VARCHAR2 (30)
Y designates that the account belongs to a privileged customer
VISA_MERCHANT_FLG VARCHAR2 (30)
Y designates that the merchant is a Visa merchant
VISA_TRANSACTIONS_FLG VARCHAR2 (30)
Y designates that the merchant accepts Visa transactions
ACCOUNT_AGE NUMBER

The age of the account (period since account was opened).
ACCOUNT_AGE_MULT VARCHAR2 (30)
Units (days or months or years) of Account_age_c.
ACCOUNT_CONTRIB NUMBER

The current net profit contribution for the account
ACCOUNT_CONTRIB_AFTER_TAX NUMBER

Account Contribution After Tax
ACCOUNT_NUMBER VARCHAR2 (50)
The account number
ACCOUNT_OFFICER VARCHAR2 (50)
The primary officer responsible for this account.
ACCRUAL_BASIS_ID NUMBER

Basis on which interest accrual is calculated. Suggested defaults: 1=30/360 for amortizing transactions OR 3=Act/Act. for nonamort.
ACCRUED_INTEREST NUMBER

The interest accrued on the account
ADJUSTABLE_TYPE_CODE NUMBER

Frequency or method by which the coupon or rate is adjusted.
ADVICE_TYPE_CODE VARCHAR2 (30)
The type of written confirmation received on the account, for example debit, credit or payment
AGENT_BANK_CODE VARCHAR2 (30)
An organization-defined code for the agent organization associated with the account
ALLOCATED_EQUITY NUMBER

Allocated equity; typically average balance * product-specific rate
ANNUAL_FEE_CODE VARCHAR2 (30)
An organization-defined code for the annual fee amount
APPLICATION_ANALYST_CODE VARCHAR2 (30)
An organization-defined code for the application analyst
APPLICATION_FINAL_SCORE VARCHAR2 (50)
The account''s final application score
APPLICATION_SCORE VARCHAR2 (50)
The account''s application score
APPL_OVERRIDE_REASON_CODE VARCHAR2 (30)
An organization-defined code for the reason the account''s application score was overridden
ATM_EXP NUMBER

Automated Teller Machine expense; typically based on number of Automated Teller Machine transactions * unit cost
AUTHORIZATION_EXP NUMBER

The total organization cost for authorizations on the account
AUTHORIZATION_FEES NUMBER

The amount of authorization fees charged to the account
AUTH_DEVICE_TYPE_CODE VARCHAR2 (30)
Type of authorization device used
AVAILABLE_CREDIT NUMBER

The difference between the credit line and the amount borrowed
AVG_BOOK_BAL NUMBER

Average gross book balance for latest month.
AVG_NET_BOOK_BAL NUMBER

Average book balance - net of participations - for latest month.
AVG_TICKET_BAL NUMBER

The account''s average ticket amount in the current Update period
BANK_ID NUMBER

The bank which owns the transaction.
BATCH_EXP NUMBER

The total organization cost for processing the account as part of a batch
BEHAVIOR_SCORE VARCHAR2 (50)
The account''s overall behavior score
BILLING_METHOD_CODE VARCHAR2 (30)
The method used to bill the account
BONUS_AMT NUMBER

The account''s usage bonus
BRANCH_CODE VARCHAR2 (30)
The branch where the account currently resides.
BRANCH_PLATFORM_EXP NUMBER

Fixed cost per product or # of transactions * unit cost
BRANCH_TELLER_EXP NUMBER

Branch Teller Expense: typically based on the number of teller transactions * unit cost
CALL_CENTER_EXP NUMBER

Call center expense; typically based on number of calls * unit cost
CASH_BALANCE NUMBER

Current Outstanding Cash Advance Balance.
CASH_RATE NUMBER

Interest Rate for Accrual of Cash Advance Balance.
CHANNEL_ID NUMBER

Channel
CHARGEBACK_EXP NUMBER

The total organization cost of chargebacks on the account
CHARGE_OFF_BAL NUMBER

The charge-off amount
CHARGE_OFF_DATE DATE

The last charge-off date
CHARGE_OFF_REASON_CODE VARCHAR2 (30)
The reason for the last charge-off
COMPANY_COST_CENTER_ORG_ID NUMBER

Company Cost Center Organization
COMPOUND_BASIS_CODE NUMBER

Frequency by which interest is compounded.
CONTRIB_AFTER_CAPITAL_CHG NUMBER

Contribution after capital charge; typically Account Contribution - Allocated Equity * hurdle rate
CORRECTIONS_EXP NUMBER

The total organization cost of corrections on the account
CORRECTION_FEES NUMBER

The amount of correction fees charged to the account
CREDIT_BAL_INT_RATE NUMBER

Interest rate for credit balances
CREDIT_SCORE NUMBER

Credit score of borrower on original application
CREDIT_SCORE_DATE DATE

The date of the credit score.
CREDIT_STATUS_ID NUMBER

Current performance status of the loan.
CURRENT_FEES NUMBER

The amount of fees charged to the account
CUR_BOOK_BAL NUMBER

Current gross book balance.
CUR_CREDIT_LIMIT NUMBER

Maximum allowable balance for this card.
CUR_GROSS_RATE NUMBER

Current rate on the instrument.(i.e. owned by the customer).
CUR_NET_BOOK_BAL NUMBER

Current book balance- net of participations.
CUR_NET_PAR_BAL NUMBER

Current par value- net of participations.
CUR_NET_RATE NUMBER

Current nominal interest rate on instrument owed to or paid by the financial institution.
CUR_OAS NUMBER

Option Adjusted Spread, as calculated from the as-of-date.
CUR_PAR_BAL NUMBER

Current gross par value.
CUR_PAYMENT NUMBER

Periodic principal and interest payment associated with gross balance. Principal portion only for level principal amort. type.
CUR_STATIC_SPREAD NUMBER

Static spread, as calculated from the as-of date.
CUR_TP_PER_ADB NUMBER

Average Daily Balance for Current Transfer Pricing Repricing Period - used in selected Transfer Pricing methods - with Mid-Period Repricing option.
CUR_YIELD NUMBER

Effective annual yield based on book value.
CUSTOMER_ID NUMBER

Unique numeric identifier of the Customer
CYCLE_DAY_OF_MONTH NUMBER

Day of the month on which account is cycled (processed).
DATA_PROCESSING_EXP NUMBER

Data processing expense; typically based on number of transactions * unit cost
DEFERRED_ORG_BAL NUMBER

Original Deferred Balance associated with Instrument (i.e. Premium or Discount or Fees or etc...).
DEL_CUR_DAYS NUMBER

Number of days the account is currently delinquent ( number of days past grace period ) .
DEL_LIFE_TIMES NUMBER

Number of times the account has been delinquent during life.
DEL_YEAR_TIMES NUMBER

Number of times the account has been delinquent during the past 12 months.
DEPOSIT_TYPE_CODE VARCHAR2 (30)
An organization-defined code for the type of deposit to the account, for example check or cash
DISCOUNTED_FEES NUMBER

Discounted fees for the service
DISCOUNT_RATE NUMBER

Bank quoted rate for acceptances and bills of exchange
ELECTRONIC_BANKING_EXP NUMBER

Electronic banking expense; typically based on number of electronic transactions * unit cost
EQUITY_CREDIT NUMBER

Equity credit for the account; typically Allocated Equity * equity credit rate
EXPIRATION_DATE DATE

The expiration date of the debit card or credit card
FEE_CHARGE_DATE DATE

Date on which fee (usually annually) is applied.
FINANCE_CHARGE_BAL NUMBER

Balance on which finance charge was calculated.
FIXED_EXP NUMBER

The total organization cost for fixed expenses for the account
FLOAT_DAYS_YTD NUMBER

Number of float days year to date
FLOAT_EXP NUMBER

The total organization cost for float on the account
FLOAT_MGMT_FEES NUMBER

The amount of float fees charged to the account
GEOGRAPHY_ID NUMBER

Geography
GROSS_FEE_INCOME NUMBER

Sum of fee income components (before waivers)
HEDGE_PORTFOLIO_SET NUMBER

Identifies the portfolio being hedged.
HISTORIC_OAS NUMBER

Historic Option Adjusted Spread
HISTORIC_STATIC_SPREAD NUMBER

Static spread, as calculated from the origination date.
IMPRINT_MACHINE_EXP NUMBER

The total organization cost for imprint machines for the account
INSTRUMENT_TYPE_CODE NUMBER

Instrument category (record type).
INTERCHANGE_DISCOUNT_EXP NUMBER

The total organization cost for interchange discounts on the account
INTERCHANGE_EXP NUMBER

The total organization cost for interchange charges on the account
INTEREST_INC_EXP NUMBER

Interest income/expense; typically average balance * interest rate
INTEREST_RATE_CODE NUMBER

Index to which interest rate is contractually tied.
INTERNATL_INTERCHANGE_EXP NUMBER

The total organization cost for international interchange charges on the account
INTRACHANGE_EXP NUMBER

The total organization cost for intrachange charges on the account
INVESTOR_NBR VARCHAR2 (50)
Investor number for sold or participated accounts.
ITEM_PROCESSING_EXP NUMBER

Item Processing Expense; typically a set expense for the type or item
LARGEST_OUTST_BAL NUMBER

Largest balance borrowed historically on this card.
LAST_ACTIVE_DATE DATE

The last date the account had activity
LAST_CR_LINE_CHANGE_DATE DATE

The date of the last credit line change
LAST_PAYMENT_AMT NUMBER

The amount of the last payment on the account
LAST_REJECTED_DATE DATE

The last date a credit line increase was rejected
LAST_REPRICE_DATE DATE

Date upon which adjustable instruments last repriced.
LAST_TRANSACTION_DATE DATE

The date of the account''s last transaction
LIMIT_USE_RATIO NUMBER

Ratio of current balance to credit limit.
LINE_ITEM_ID NUMBER

Line Item
LOAN_LOSS_PROVISION NUMBER

Loan loss provision for the account; typically average balance * product-specific rate
LOAN_LOSS_RESERVE NUMBER

Loan Loss Reserve for the account; typically average balance * product specific rate
MANUAL_INTERCHANGE_EXP NUMBER

The total organization cost for manual interchange charges on the account
MANUAL_INTRACHANGE_EXP NUMBER

The total organization cost for manual intrachange charges on the account
MARGIN NUMBER

Contractual spread above or below pricing index
MARGIN_GROSS NUMBER

Contractual spread above or below pricing index applied to CUR_GROSS_RATE
MARGIN_T_RATE NUMBER

Margin Transfer Rate
MARKET_SEGMENT_ID NUMBER

Specific market segment of borrower.
MARKET_VALUE NUMBER

Calculated market value price (i.e. 100 x market value / current net par balance).
MATCHED_SPREAD NUMBER

Interest margin on product. For assets = Current net rate - Transfer rate OR Liabilities = Transfer rate - Current net Rate.
MATURITY_DATE DATE

Original contractual specified maturity date of instrument.
MEMBERSHIP_ANNIV_DATE DATE

The membership anniversary date
MEMBERSHIP_EXP NUMBER

The total organization cost for the account''s membership
MEMBER_DUES NUMBER

The account''s membership dues for the current Update period
MERCHANDISE_BAL NUMBER

Current outstanding merchandise balance.
MERCHANDISE_RATE NUMBER

Interest rate for accrual of merchandise balance.
MERCHANT_CHAIN_CODE VARCHAR2 (30)
An organization-defined code for the chain the account belongs to
MERCHANT_CHARGES NUMBER

The amount of merchant charges for the current Update period
MERCHANT_CLASS_CODE VARCHAR2 (30)
The account''s merchant classification
MERCH_SYSTEM_NUMBER VARCHAR2 (50)
The account''s merchant system number
NATURAL_ACCOUNT_ID NUMBER

Natural Account
NEG_AMRT_AMT NUMBER

Total amount of principal increase due to negative amortization.
NEG_AMRT_EQ_DATE DATE

Date at which current payment necessary to fully amortize the instrument will be re-computed.
NEG_AMRT_EQ_FREQ NUMBER

Frequency at which current payment necessary to fully amortize the instrument is re-computed.
NEG_AMRT_EQ_MULT VARCHAR2 (30)
Units (days or months or years) of Neg_amrt_eq_freq.
NEG_AMRT_LIMIT NUMBER

Maximum negative amortization allowed as a percentage of the original balance
NET_FEE_INCOME NUMBER

Gross Fee Income - Waived Fees
NET_INT_MARGIN NUMBER

Net interest margin; typically Transfer Charge/Credit + Interest Income/Expense - Loan Loss Provision
NET_MARGIN_CODE NUMBER

Defines relationship between CUR_GROSS_RATE and CUR_NET_RATE for Risk Manager processing
NEXT_PAYMENT_DATE DATE

Date upon which the next scheduled payment is due.
NEXT_REPRICE_DATE DATE

Date upon which adjustable instuments will next reprice.
ORG_BOOK_BAL NUMBER

Gross book balance at date of origination. Rule of 78s should exclude add on interest.
ORG_MARKET_VALUE NUMBER

Market Value as of originaton date.
ORG_NET_BOOK_BAL NUMBER

Book value - net of participations, at date of origination
ORG_NET_PAR_BAL NUMBER

Par value - net of participations, at date of of origination
ORG_PAR_BAL NUMBER

Gross par value at date of purchase. Rule of 78s should exclude add on interest.
ORG_RATE NUMBER

Contractual interest rate at origination date.
ORIGINAL_CREDIT_LINE NUMBER

The original credit line for the account
ORIGINATION_DATE DATE

Date the current institution originated or acquired the instrument. For rolled instruments the greater of date last rolled or date acquired.
OTHER_ACCOUNT_EXP NUMBER

Additional expenses applied to the account
OTHER_EXP NUMBER

The total organization cost for other charges on the account
OTHER_PROCESSING_EXP NUMBER

Additional processing expenses applied to the account
OVER_LIMIT_BAL NUMBER

Amount account is currently over credit limit.
OVER_LIMIT_CURRENT_CYCLE NUMBER

The number of times the account has been over the credit limit in the current billing cycle
OVER_LIMIT_LF_TIME NUMBER

Number of times account was over credit limit throughout life of account.
OWNERSHIP_TYPE_CODE VARCHAR2 (30)
An organization-defined code for the account''s ownership type
PAYMENT_HISTORY_CODE VARCHAR2 (30)
An organization-defined code for the payment history on the account
PAY_AHEAD_CODE VARCHAR2 (30)
An organization-defined code indicating the time period the account is paid-ahead
PERCENT_SOLD NUMBER

Total percent of balance sold to investors.
PMT_ADJUST_DATE DATE

Date of next payment adjustment on an adjustable rate instrument.
PMT_CHG_FREQ NUMBER

The frequency at which the payment adjusts.
PMT_CHG_FREQ_MULT VARCHAR2 (30)
Units (days or months or years) of Pmt_chg_freq.
PMT_DECR_CYCLE NUMBER

Maximum payment decrease allowed during a repricing cycle of an adjustable rate instrument.
PMT_DECR_LIFE NUMBER

Maximum payment decrease allowed during life of an adjustable rate instrument.
PMT_FREQ NUMBER

Frequency of payment (Principal and Interest, Interest or Principal).
PMT_FREQ_MULT VARCHAR2 (30)
Units (days or months or years) of Pmt_freq.
PMT_INCR_CYCLE NUMBER

Maximum payment increase allowed during a repricing cycle on an adjustable rate instrument.
PMT_INCR_LIFE NUMBER

Maximum payment increase allowed during the life of an adjustable rate instrument.
PRIOR_TP_PER_ADB NUMBER

Average Daily Balance for Prior Transfer Pricing Repricing Period - used in selected Transfer Pricing methods - with Mid-Period Repricing
PRODUCT_ID NUMBER

Product
PRODUCT_TYPE_ID NUMBER

The specific type of product given an instrument type.
RATE_CAP_LIFE NUMBER

Maximum rate allowed during life of the instrument.
RATE_CHG_MIN NUMBER

Minimum change in repricing index necessary for a change in the interest rate.
RATE_CHG_RND_CODE NUMBER

Factor to which the rate change on an adjustable instrument is rounded.
RATE_CHG_RND_FAC NUMBER

Method used for rounding of interest rate change.
RATE_DECR_YEAR NUMBER

Maximum rate decrease allowed on an adjustable product per year.
RATE_FLOOR_LIFE NUMBER

Minimum rate for life of the instrument.
RATE_INCR_YEAR NUMBER

Maximum interest rate increase allowed during a year for an adjustable rate instrument.
REASON_CLOSED_CODE VARCHAR2 (30)
Indicates the reason the customer gave for closing the account
RECORD_COUNT NUMBER

The number of source transaction records represented by each record.
REMAIN_TERM NUMBER

Period until the instrument matures.
REMAIN_TERM_MULT VARCHAR2 (30)
Units (days or months or years) of Remain_term_c.
REPRICE_FREQ NUMBER

Contractual frequency of rate adjustment.
REPRICE_FREQ_MULT VARCHAR2 (30)
Units (days or months or years) of Reprice_freq.
RESERVE_CHARGE_CREDIT NUMBER

Charge or credit for funds based on the loan loss reserve balance
RETAIL_EXP NUMBER

Retail operations expense; typically a fixed cost per product or number of transactions * unit cost
RETURN_ITEMS NUMBER

Number of return items
RETURN_ON_EQUITY NUMBER

Return on equity for the account; typically Account Contribution / Allocated Equity (annualized by 12)
SERVICING_AGENT_ID NUMBER

Outside servicer - if applicable.
SETTLEMENT_ACCT_NBR VARCHAR2 (50)
The settlement account''s number
SETTLEMENT_ACCT_SERV_CODE VARCHAR2 (30)
The settlement account''s service type
SOLICIT_SOURCE_ID NUMBER

Credit Card Program source of business.
TAPE_PROCESSING_EXP NUMBER

The total organization cost for tape processing on the account
TAX_EXEMPT_PCT NUMBER

Percent of interest that is tax exempt.
TAX_EXP NUMBER

Tax Expense
TEASER_END_DATE DATE

Termination date of rate tease period.
TERMINALS_EXP NUMBER

The total organization cost for terminals for the account
TOTAL_ACCOUNT_EXP NUMBER

Sum of all account expenses
TOTAL_CHARGES NUMBER

The total number of charges to the account in the current Update period
TOTAL_DISTRIBUTION_EXP NUMBER

Sum of distribution related expenses for the account
TOTAL_EXP NUMBER

The total cost to the organization for the account for the current Update period
TOTAL_FEES NUMBER

The total fees for the current Update period
TOTAL_PROCESS_EXP NUMBER

Sum of Data Processing, Item Processing, Retail Operations, Deposit Insurance and Other Processing expenses
TOTAL_TRANSACTIONS NUMBER

Total number of account transactions
TRANSFER_CHARGE_CREDIT NUMBER

Transfer Charge Credit
TRANSFER_RATE NUMBER

The associated transfer rate for the account.
TRAN_RATE_REM_TERM NUMBER

The associated remaining term transfer rate for the account.
T_RATE_INT_RATE_CODE NUMBER

Transfer Rate Interest Rate Code.
USER_DIM1_ID NUMBER

User Dimension1
USER_DIM2_ID NUMBER

User Dimension2
USER_DIM3_ID NUMBER

User Dimension3
USER_DIM4_ID NUMBER

User Dimension4
USER_DIM5_ID NUMBER

User Dimension5
USER_DIM6_ID NUMBER

User Dimension6
USER_DIM7_ID NUMBER

User Dimension7
USER_DIM8_ID NUMBER

User Dimension8
USER_DIM9_ID NUMBER

User Dimension9
USER_DIM10_ID NUMBER

User Dimension10
VOLUME_REBATE_AMT NUMBER

Volume rebate to the account in the current Update period
WAIVED_FEES NUMBER

Sum of fee income waiver components
WARNING_BULLETINS_EXP NUMBER

The total organization cost for warning bulletins for the account year to date
ALPHANUMERIC_MEASURE01 VARCHAR2 (4000)
Alphanumeric Measure1
ALPHANUMERIC_MEASURE02 VARCHAR2 (4000)
Alphanumeric Measure2
ALPHANUMERIC_MEASURE03 VARCHAR2 (4000)
Alphanumeric Measure3
ALPHANUMERIC_MEASURE04 VARCHAR2 (4000)
Alphanumeric Measure4
ALPHANUMERIC_MEASURE05 VARCHAR2 (4000)
Alphanumeric Measure5
ALPHANUMERIC_MEASURE06 VARCHAR2 (4000)
Alphanumeric Measure6
ALPHANUMERIC_MEASURE07 VARCHAR2 (4000)
Alphanumeric Measure7
ALPHANUMERIC_MEASURE08 VARCHAR2 (4000)
Alphanumeric Measure8
ALPHANUMERIC_MEASURE09 VARCHAR2 (4000)
Alphanumeric Measure9
ALPHANUMERIC_MEASURE10 VARCHAR2 (4000)
Alphanumeric Measure10
DATE_MEASURE01 DATE

Date Measure1
DATE_MEASURE02 DATE

Date Measure2
DATE_MEASURE03 DATE

Date Measure3
DATE_MEASURE04 DATE

Date Measure4
DATE_MEASURE05 DATE

Date Measure5
DATE_MEASURE06 DATE

Date Measure6
DATE_MEASURE07 DATE

Date Measure7
DATE_MEASURE08 DATE

Date Measure8
DATE_MEASURE09 DATE

Date Measure9
DATE_MEASURE10 DATE

Date Measure10
NUMERIC_MEASURE01 NUMBER

Numeric Measure1
NUMERIC_MEASURE02 NUMBER

Numeric Measure2
NUMERIC_MEASURE03 NUMBER

Numeric Measure3
NUMERIC_MEASURE04 NUMBER

Numeric Measure4
NUMERIC_MEASURE05 NUMBER

Numeric Measure5
NUMERIC_MEASURE06 NUMBER

Numeric Measure6
NUMERIC_MEASURE07 NUMBER

Numeric Measure7
NUMERIC_MEASURE08 NUMBER

Numeric Measure8
NUMERIC_MEASURE09 NUMBER

Numeric Measure9
NUMERIC_MEASURE10 NUMBER

Numeric Measure10
DEFERRED_CUR_BAL NUMBER

Deferred Balance Current
INT_TYPE_CODE NUMBER

Interest Type Code
ISSUE_DATE DATE

Issue Date
LAST_PAYMENT_DATE DATE

Last Payment Date
LRD_BALANCE NUMBER

Last Repricing Date Balance
ORG_PAYMENT_AMT NUMBER

Original Payment Amount
ORG_TERM NUMBER

Original Term to Maturity
ORG_TERM_MULT VARCHAR2 (30)
Original Term Multiplier
RATE_DECR_CYCLE NUMBER

Rate Decrease Cycle
RATE_INCR_CYCLE NUMBER

Rate Increase Cycle
RATE_SET_LAG NUMBER

Rate Set Lag
RATE_SET_LAG_MULT VARCHAR2 (30)
Rate Set Lag Multiplier
REMAIN_NO_PMTS NUMBER

Remaining Number of Payments
AMRT_TYPE_CODE NUMBER

Method of amortizing principal and interest.
AMRT_TERM NUMBER

Term upon which amortization is based - units specified by Amrt_term_mult.
AMRT_TERM_MULT VARCHAR2 (30)
Units (days or months or years) in which Amrt_Term is specified.
LIQUIDITY_PREMIUM_RATE NUMBER

LIQUIDITY_PREMIUM_AMT NUMBER

BASIS_RISK_COST_RATE NUMBER

BASIS_RISK_COST_AMT NUMBER

PRICING_INCENTIVE_RATE NUMBER

PRICING_INCENTIVE_AMT NUMBER

OTHER_ADJUSTMENTS_RATE NUMBER

OTHER_ADJUSTMENTS_AMT NUMBER

TRANSFER_RATE_ALT NUMBER

MATCHED_SPREAD_ALT NUMBER

TRAN_RATE_REM_TERM_ALT NUMBER

OTHER_ADJ_RATE_ALT NUMBER

OTHER_ADJ_AMOUNT_ALT NUMBER

HISTORIC_OAS_ALT NUMBER

HISTORIC_STATIC_SPREAD_ALT NUMBER

CUR_OAS_ALT NUMBER

CUR_STATIC_SPREAD_ALT NUMBER

Query Text

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


SELECT CAL_PERIOD_ID
,      DATASET_CODE
,      SOURCE_SYSTEM_CODE
,      ID_NUMBER
,      CREATED_BY_OBJECT_ID
,      CREATED_BY_REQUEST_ID
,      LAST_UPDATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
,      CURRENCY_CODE
,      LEDGER_ID
,      EMBEDDED_OPTIONS_FLG
,      JOINT_ACCOUNT_FLG
,      MC_MERCHANT_FLG
,      MC_TRANS_FLG
,      OPEN_ACCOUNT_FLG
,      VIP_ACCOUNT_FLG
,      VISA_MERCHANT_FLG
,      VISA_TRANSACTIONS_FLG
,      ACCOUNT_AGE
,      ACCOUNT_AGE_MULT
,      ACCOUNT_CONTRIB
,      ACCOUNT_CONTRIB_AFTER_TAX
,      ACCOUNT_NUMBER
,      ACCOUNT_OFFICER
,      ACCRUAL_BASIS_ID
,      ACCRUED_INTEREST
,      ADJUSTABLE_TYPE_CODE
,      ADVICE_TYPE_CODE
,      AGENT_BANK_CODE
,      ALLOCATED_EQUITY
,      ANNUAL_FEE_CODE
,      APPLICATION_ANALYST_CODE
,      APPLICATION_FINAL_SCORE
,      APPLICATION_SCORE
,      APPL_OVERRIDE_REASON_CODE
,      ATM_EXP
,      AUTHORIZATION_EXP
,      AUTHORIZATION_FEES
,      AUTH_DEVICE_TYPE_CODE
,      AVAILABLE_CREDIT
,      AVG_BOOK_BAL
,      AVG_NET_BOOK_BAL
,      AVG_TICKET_BAL
,      BANK_ID
,      BATCH_EXP
,      BEHAVIOR_SCORE
,      BILLING_METHOD_CODE
,      BONUS_AMT
,      BRANCH_CODE
,      BRANCH_PLATFORM_EXP
,      BRANCH_TELLER_EXP
,      CALL_CENTER_EXP
,      CASH_BALANCE
,      CASH_RATE
,      CHANNEL_ID
,      CHARGEBACK_EXP
,      CHARGE_OFF_BAL
,      CHARGE_OFF_DATE
,      CHARGE_OFF_REASON_CODE
,      COMPANY_COST_CENTER_ORG_ID
,      COMPOUND_BASIS_CODE
,      CONTRIB_AFTER_CAPITAL_CHG
,      CORRECTIONS_EXP
,      CORRECTION_FEES
,      CREDIT_BAL_INT_RATE
,      CREDIT_SCORE
,      CREDIT_SCORE_DATE
,      CREDIT_STATUS_ID
,      CURRENT_FEES
,      CUR_BOOK_BAL
,      CUR_CREDIT_LIMIT
,      CUR_GROSS_RATE
,      CUR_NET_BOOK_BAL
,      CUR_NET_PAR_BAL
,      CUR_NET_RATE
,      CUR_OAS
,      CUR_PAR_BAL
,      CUR_PAYMENT
,      CUR_STATIC_SPREAD
,      CUR_TP_PER_ADB
,      CUR_YIELD
,      CUSTOMER_ID
,      CYCLE_DAY_OF_MONTH
,      DATA_PROCESSING_EXP
,      DEFERRED_ORG_BAL
,      DEL_CUR_DAYS
,      DEL_LIFE_TIMES
,      DEL_YEAR_TIMES
,      DEPOSIT_TYPE_CODE
,      DISCOUNTED_FEES
,      DISCOUNT_RATE
,      ELECTRONIC_BANKING_EXP
,      EQUITY_CREDIT
,      EXPIRATION_DATE
,      FEE_CHARGE_DATE
,      FINANCE_CHARGE_BAL
,      FIXED_EXP
,      FLOAT_DAYS_YTD
,      FLOAT_EXP
,      FLOAT_MGMT_FEES
,      GEOGRAPHY_ID
,      GROSS_FEE_INCOME
,      HEDGE_PORTFOLIO_SET
,      HISTORIC_OAS
,      HISTORIC_STATIC_SPREAD
,      IMPRINT_MACHINE_EXP
,      INSTRUMENT_TYPE_CODE
,      INTERCHANGE_DISCOUNT_EXP
,      INTERCHANGE_EXP
,      INTEREST_INC_EXP
,      INTEREST_RATE_CODE
,      INTERNATL_INTERCHANGE_EXP
,      INTRACHANGE_EXP
,      INVESTOR_NBR
,      ITEM_PROCESSING_EXP
,      LARGEST_OUTST_BAL
,      LAST_ACTIVE_DATE
,      LAST_CR_LINE_CHANGE_DATE
,      LAST_PAYMENT_AMT
,      LAST_REJECTED_DATE
,      LAST_REPRICE_DATE
,      LAST_TRANSACTION_DATE
,      LIMIT_USE_RATIO
,      LINE_ITEM_ID
,      LOAN_LOSS_PROVISION
,      LOAN_LOSS_RESERVE
,      MANUAL_INTERCHANGE_EXP
,      MANUAL_INTRACHANGE_EXP
,      MARGIN
,      MARGIN_GROSS
,      MARGIN_T_RATE
,      MARKET_SEGMENT_ID
,      MARKET_VALUE
,      MATCHED_SPREAD
,      MATURITY_DATE
,      MEMBERSHIP_ANNIV_DATE
,      MEMBERSHIP_EXP
,      MEMBER_DUES
,      MERCHANDISE_BAL
,      MERCHANDISE_RATE
,      MERCHANT_CHAIN_CODE
,      MERCHANT_CHARGES
,      MERCHANT_CLASS_CODE
,      MERCH_SYSTEM_NUMBER
,      NATURAL_ACCOUNT_ID
,      NEG_AMRT_AMT
,      NEG_AMRT_EQ_DATE
,      NEG_AMRT_EQ_FREQ
,      NEG_AMRT_EQ_MULT
,      NEG_AMRT_LIMIT
,      NET_FEE_INCOME
,      NET_INT_MARGIN
,      NET_MARGIN_CODE
,      NEXT_PAYMENT_DATE
,      NEXT_REPRICE_DATE
,      ORG_BOOK_BAL
,      ORG_MARKET_VALUE
,      ORG_NET_BOOK_BAL
,      ORG_NET_PAR_BAL
,      ORG_PAR_BAL
,      ORG_RATE
,      ORIGINAL_CREDIT_LINE
,      ORIGINATION_DATE
,      OTHER_ACCOUNT_EXP
,      OTHER_EXP
,      OTHER_PROCESSING_EXP
,      OVER_LIMIT_BAL
,      OVER_LIMIT_CURRENT_CYCLE
,      OVER_LIMIT_LF_TIME
,      OWNERSHIP_TYPE_CODE
,      PAYMENT_HISTORY_CODE
,      PAY_AHEAD_CODE
,      PERCENT_SOLD
,      PMT_ADJUST_DATE
,      PMT_CHG_FREQ
,      PMT_CHG_FREQ_MULT
,      PMT_DECR_CYCLE
,      PMT_DECR_LIFE
,      PMT_FREQ
,      PMT_FREQ_MULT
,      PMT_INCR_CYCLE
,      PMT_INCR_LIFE
,      PRIOR_TP_PER_ADB
,      PRODUCT_ID
,      PRODUCT_TYPE_ID
,      RATE_CAP_LIFE
,      RATE_CHG_MIN
,      RATE_CHG_RND_CODE
,      RATE_CHG_RND_FAC
,      RATE_DECR_YEAR
,      RATE_FLOOR_LIFE
,      RATE_INCR_YEAR
,      REASON_CLOSED_CODE
,      RECORD_COUNT
,      REMAIN_TERM
,      REMAIN_TERM_MULT
,      REPRICE_FREQ
,      REPRICE_FREQ_MULT
,      RESERVE_CHARGE_CREDIT
,      RETAIL_EXP
,      RETURN_ITEMS
,      RETURN_ON_EQUITY
,      SERVICING_AGENT_ID
,      SETTLEMENT_ACCT_NBR
,      SETTLEMENT_ACCT_SERV_CODE
,      SOLICIT_SOURCE_ID
,      TAPE_PROCESSING_EXP
,      TAX_EXEMPT_PCT
,      TAX_EXP
,      TEASER_END_DATE
,      TERMINALS_EXP
,      TOTAL_ACCOUNT_EXP
,      TOTAL_CHARGES
,      TOTAL_DISTRIBUTION_EXP
,      TOTAL_EXP
,      TOTAL_FEES
,      TOTAL_PROCESS_EXP
,      TOTAL_TRANSACTIONS
,      TRANSFER_CHARGE_CREDIT
,      TRANSFER_RATE
,      TRAN_RATE_REM_TERM
,      T_RATE_INT_RATE_CODE
,      USER_DIM1_ID
,      USER_DIM2_ID
,      USER_DIM3_ID
,      USER_DIM4_ID
,      USER_DIM5_ID
,      USER_DIM6_ID
,      USER_DIM7_ID
,      USER_DIM8_ID
,      USER_DIM9_ID
,      USER_DIM10_ID
,      VOLUME_REBATE_AMT
,      WAIVED_FEES
,      WARNING_BULLETINS_EXP
,      ALPHANUMERIC_MEASURE01
,      ALPHANUMERIC_MEASURE02
,      ALPHANUMERIC_MEASURE03
,      ALPHANUMERIC_MEASURE04
,      ALPHANUMERIC_MEASURE05
,      ALPHANUMERIC_MEASURE06
,      ALPHANUMERIC_MEASURE07
,      ALPHANUMERIC_MEASURE08
,      ALPHANUMERIC_MEASURE09
,      ALPHANUMERIC_MEASURE10
,      DATE_MEASURE01
,      DATE_MEASURE02
,      DATE_MEASURE03
,      DATE_MEASURE04
,      DATE_MEASURE05
,      DATE_MEASURE06
,      DATE_MEASURE07
,      DATE_MEASURE08
,      DATE_MEASURE09
,      DATE_MEASURE10
,      NUMERIC_MEASURE01
,      NUMERIC_MEASURE02
,      NUMERIC_MEASURE03
,      NUMERIC_MEASURE04
,      NUMERIC_MEASURE05
,      NUMERIC_MEASURE06
,      NUMERIC_MEASURE07
,      NUMERIC_MEASURE08
,      NUMERIC_MEASURE09
,      NUMERIC_MEASURE10
,      DEFERRED_CUR_BAL
,      INT_TYPE_CODE
,      ISSUE_DATE
,      LAST_PAYMENT_DATE
,      LRD_BALANCE
,      ORG_PAYMENT_AMT
,      ORG_TERM
,      ORG_TERM_MULT
,      RATE_DECR_CYCLE
,      RATE_INCR_CYCLE
,      RATE_SET_LAG
,      RATE_SET_LAG_MULT
,      REMAIN_NO_PMTS
,      AMRT_TYPE_CODE
,      AMRT_TERM
,      AMRT_TERM_MULT
,      LIQUIDITY_PREMIUM_RATE
,      LIQUIDITY_PREMIUM_AMT
,      BASIS_RISK_COST_RATE
,      BASIS_RISK_COST_AMT
,      PRICING_INCENTIVE_RATE
,      PRICING_INCENTIVE_AMT
,      OTHER_ADJUSTMENTS_RATE
,      OTHER_ADJUSTMENTS_AMT
,      TRANSFER_RATE_ALT
,      MATCHED_SPREAD_ALT
,      TRAN_RATE_REM_TERM_ALT
,      OTHER_ADJ_RATE_ALT
,      OTHER_ADJ_AMOUNT_ALT
,      HISTORIC_OAS_ALT
,      HISTORIC_STATIC_SPREAD_ALT
,      CUR_OAS_ALT
,      CUR_STATIC_SPREAD_ALT
FROM FEM.FEM_MERCHANT_CARDS;

Dependencies

[top of page]

FEM.FEM_MERCHANT_CARDS does not reference any database object

FEM.FEM_MERCHANT_CARDS is referenced by following:

SchemaAPPS
SynonymFEM_MERCHANT_CARDS