[Home] [Help] [Dependency Information]
Object Name: | FEM_MERCHANT_CARDS_T |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
FEM_MERCHANT_CARDS_T is an interface table for loading and updating Analytic Merchant Cards data into the FEM_MERCHANT_CARDS table using the Detail Client Data Loader. With the exception of the information required for the Calendar Period dimension as well as the STATUS column, each column on the interface table maps to a column in the destination table. The mapping between the columns on the interface table and the destination table is stored as Table Registration metadata. Users can go to the Table Registration user interface to view and update the column mapping metadata. Most columns that have a one-to-one mapping between the interface and destination tables share the same column name. If the interface table column maps to a destination table column with a different name, then the column most likely represents a dimension that has both a user-defined non-translatable alphanumeric identifier (or "Display Code") and a system generated numeric identifier (or "ID") for its members. Users should always populate the interface table column with the dimension "Display Code" value. The Detail Client Data Loader transforms the member values in the interface table into the correct internal numeric identifiers for each member. For example, LEDGER_DISPLAY_CODE and LEDGER_ID are columns that represent the Ledger dimension on the interface table and destination table, respectively. Users just need to populate the LEDGER_DISPLAY_CODE with the "Display Code" value. The data loader transforms the "Display Code" value into an internal numeric identifier before storing into the LEDGER_ID column on the destination table.
As noted above, members for the Calendar Period dimension are not identified in this manner. Rather, they are identified by a combination of the following information:
Level (CALP_DIM_GRP_DISPLAY_CODE), End Date (CAL_PERIOD_END_DATE), and Period Number (CAL_PERIOD_NUMBER). The loader also uses the Ledger (LEDGER_DISPLAY_CODE) to identify the Calendar to be used to verify the existence of all of the Calendar Period members in the load.
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic Merchant Cards Data
Category: BUSINESS_ENTITY FEM_FACT_REPOSITORY
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_MERCHANT_CARDS_T_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CALP_DIM_GRP_DISPLAY_CODE
CAL_PERIOD_NUMBER CAL_PERIOD_END_DATE DATASET_DISPLAY_CODE SOURCE_SYSTEM_DISPLAY_CODE ID_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATUS | VARCHAR2 | (60) | Yes | Designates the Status of the row for loading. Records with a STATUS of "LOAD" will be loaded by the Source Data Loader. All other STATUS codes designate some sort of error from the load. The user (translated) text description can be found in FND Messages using this error status code as the Message Name. |
CALP_DIM_GRP_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Calendar Period Dimension Group |
CAL_PERIOD_NUMBER | NUMBER | (15) | Yes | Calendar Period Number. Provides alternate identification for the Calendar Period, together with Ledger ID, Calendar Period End Date, and Calendar Period Dimension Group Name. |
CAL_PERIOD_END_DATE | DATE | Yes | The end date of the calendar period | |
DATASET_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Dataset Code |
SOURCE_SYSTEM_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Source System |
ID_NUMBER | NUMBER | Yes | Uniquely identifies an instrument. | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency Code |
LEDGER_DISPLAY_CODE | VARCHAR2 | (150) | 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_DISPLAY_CODE | VARCHAR2 | (150) | 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_DISPLAY_CODE | VARCHAR2 | (150) | 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_DISPLAY_CODE | VARCHAR2 | (150) | 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 | |
CCTR_ORG_DISPLAY_CODE | VARCHAR2 | (150) | 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_DISPLAY_CODE | VARCHAR2 | (150) | 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_DISPLAY_CODE | VARCHAR2 | (150) | 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_DISPLAY_CODE | VARCHAR2 | (150) | 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_DISPLAY_CODE | VARCHAR2 | (150) | 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_DISPLAY_CODE | VARCHAR2 | (150) | 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_DISPLAY_CODE | VARCHAR2 | (150) | 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_DISPLAY_CODE | VARCHAR2 | (150) | Product | |
PRODUCT_TYPE_DISPLAY_CODE | VARCHAR2 | (150) | 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_DISPLAY_CODE | VARCHAR2 | (150) | 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_DISPLAY_CODE | VARCHAR2 | (150) | 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_DIM10_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension10 | |
USER_DIM1_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension1 | |
USER_DIM2_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension2 | |
USER_DIM3_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension3 | |
USER_DIM4_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension4 | |
USER_DIM5_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension5 | |
USER_DIM6_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension6 | |
USER_DIM7_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension7 | |
USER_DIM8_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension8 | |
USER_DIM9_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension9 | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT STATUS
, CALP_DIM_GRP_DISPLAY_CODE
, CAL_PERIOD_NUMBER
, CAL_PERIOD_END_DATE
, DATASET_DISPLAY_CODE
, SOURCE_SYSTEM_DISPLAY_CODE
, ID_NUMBER
, CURRENCY_CODE
, LEDGER_DISPLAY_CODE
, 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_DISPLAY_CODE
, 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_DISPLAY_CODE
, 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_DISPLAY_CODE
, CHARGEBACK_EXP
, CHARGE_OFF_BAL
, CHARGE_OFF_DATE
, CHARGE_OFF_REASON_CODE
, CCTR_ORG_DISPLAY_CODE
, COMPOUND_BASIS_CODE
, CONTRIB_AFTER_CAPITAL_CHG
, CORRECTIONS_EXP
, CORRECTION_FEES
, CREDIT_BAL_INT_RATE
, CREDIT_SCORE
, CREDIT_SCORE_DATE
, CREDIT_STATUS_DISPLAY_CODE
, 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_DISPLAY_CODE
, 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_DISPLAY_CODE
, 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_DISPLAY_CODE
, LOAN_LOSS_PROVISION
, LOAN_LOSS_RESERVE
, MANUAL_INTERCHANGE_EXP
, MANUAL_INTRACHANGE_EXP
, MARGIN
, MARGIN_GROSS
, MARGIN_T_RATE
, MARKET_SEGMENT_DISPLAY_CODE
, 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_DISPLAY_CODE
, 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_DISPLAY_CODE
, PRODUCT_TYPE_DISPLAY_CODE
, 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_DISPLAY_CODE
, SETTLEMENT_ACCT_NBR
, SETTLEMENT_ACCT_SERV_CODE
, SOLICIT_SOURCE_DISPLAY_CODE
, 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_DIM10_DISPLAY_CODE
, USER_DIM1_DISPLAY_CODE
, USER_DIM2_DISPLAY_CODE
, USER_DIM3_DISPLAY_CODE
, USER_DIM4_DISPLAY_CODE
, USER_DIM5_DISPLAY_CODE
, USER_DIM6_DISPLAY_CODE
, USER_DIM7_DISPLAY_CODE
, USER_DIM8_DISPLAY_CODE
, USER_DIM9_DISPLAY_CODE
, 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
FROM FEM.FEM_MERCHANT_CARDS_T;
FEM.FEM_MERCHANT_CARDS_T does not reference any database object
FEM.FEM_MERCHANT_CARDS_T is referenced by following:
|
|
|