[Home] [Help] [Dependency Information]
Object Name: | FEM_MERCHANT_CARDS |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
Merchant Cards
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_MERCHANT_CARDS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CAL_PERIOD_ID
DATASET_CODE SOURCE_SYSTEM_CODE ID_NUMBER |
FEM_MERCHANT_CARDS_01 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CREATED_BY_REQUEST_ID
CREATED_BY_OBJECT_ID ID_NUMBER |
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 |
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;
FEM.FEM_MERCHANT_CARDS does not reference any database object
FEM.FEM_MERCHANT_CARDS is referenced by following:
|
|
|