-- Start of DDL script for T_FEE_RATES
-- Generated 25-Feb-03  8:13:53 pm
-- from gmac_uk-GMAC_ADM:1

-- Table T_FEE_RATES

CREATE TABLE gmac_adm.t_fee_rates
 (
  fr_id                      NUMBER(12),
  fr_ltr_code                VARCHAR2(12),-- either letter code for auto
  ft_tp_id                   NUMBER (12),-- OR tp for front end insert
  fr_amount                  NUMBER(12,2),
  fr_brand                   NUMBER(1),
  fr_date_from               DATE,
  fr_desc                    VARCHAR2(50)
 )
 PCTFREE    10
 PCTUSED    40
 INITRANS   1
 MAXTRANS   255
/

-- Column Comments for T_FEE_RATES

COMMENT ON COLUMN gmac_adm.t_fee_rates.fr_date_from IS 'contract start date'
/
COMMENT ON COLUMN gmac_adm.t_fee_rates.fr_ltr_code IS 'I see using the letter code for this'
/

-- End of DDL script for T_FEE_RATES

-- Start of DDL script for T_FEE_TRANSACTION
-- Generated 25-Feb-03  8:14:00 pm
-- from gmac_uk-GMAC_ADM:1

-- Table T_FEE_TRANSACTION

CREATE TABLE gmac_adm.t_fee_transaction
 (
  ft_id                      NUMBER(12),
  ft_ct_id                   NUMBER(12),
  ft_tp_id                   NUMBER(12),
  ft_user                    VARCHAR2(50),
  ft_amount                  NUMBER(12,2),
  ft_datestamp                    DATE,
  ft_reason                  VARCHAR2(2000)
 )
 PCTFREE    10
 PCTUSED    40
 INITRANS   1
 MAXTRANS   255
/

-- Comments for T_FEE_TRANSACTION

COMMENT ON TABLE gmac_adm.t_fee_transaction IS 'main transaction record'
/

-- Column Comments for T_FEE_TRANSACTION

COMMENT ON COLUMN gmac_adm.t_fee_transaction.ft_tp_id IS 'TYPE OF CHARGE'
/
COMMENT ON COLUMN gmac_adm.t_fee_transaction.ft_user IS 'USE FOR AUDIT'
/

-- End of DDL script for T_FEE_TRANSACTION

-- Start of DDL script for V_FEES_TYPE
-- Generated 25-Feb-03  8:14:21 pm
-- from gmac_uk-GMAC_ADM:1

-- View V_FEES_TYPE

CREATE OR REPLACE VIEW gmac_adm.v_fees_type (
   tp_id,
   tp_type_category,
   tp_code,
   tp_desc,
   tp_internalinfo,
   tp_datapoint_code )
AS
select "TP_ID","TP_TYPE_CATEGORY","TP_CODE","TP_DESC","TP_INTERNALINFO","TP_DATAPOINT_CODE" from t_Types where TP_TYPE_CATEGORY=100
/

-- End of DDL script for V_FEES_TYPE