' ============================================================
'   Database name:  rem_web                                   
'   DBMS name:      Microsoft Access 95 & 97                  
'   Created on:     8/16/99  11:22 PM                         
' ============================================================

    ' ============================================================
    '   Table: user_security                                      
    ' ============================================================
    Begin Table  user_security
       Name            = User Security
       Begin Column user_id
          Name            = User ID
          DataType        = Text(8)
          Length          = 8
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column cont_id
          Name            = Contact ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column user_cont_type_cd
          Name            = Contact Type Code
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column user_passwd
          Name            = User Password
          DataType        = Text(8)
          Length          = 8
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column user_access_lvl_cd
          Name            = User Access Level Code
          DataType        = Text(50)
          Length          = 50
          ServerRule      = user_access_lvl_cd is null or ()
          OrdinalNumber   = 0
       End Column
    End Table

    ' ============================================================
    '   Table: address_list                                       
    ' ============================================================
    Begin Table  address_list
       Name            = Address List
       Begin Column addr_id
          Name            = Address ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column addr_typ_cd
          Name            = Address Type Code
          DataType        = Text(50)
          Length          = 50
          ServerRule      = addr_typ_cd is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column addr_addr1
          Name            = Address 1
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column addr_addr2
          Name            = Address 2
          DataType        = Text(50)
          Length          = 50
          ServerRule      = addr_addr2 is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column addr_city
          Name            = City
          DataType        = Text(40)
          Length          = 40
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column state_cd
          Name            = State Code
          DataType        = Text(50)
          Length          = 50
          ServerRule      = state_cd is null or ()
          OrdinalNumber   = 0
       End Column
    End Table

    ' ============================================================
    '   Table: phone_list                                         
    ' ============================================================
    Begin Table  phone_list
       Name            = Phone Numbers List
       Begin Column phone_list_id
          Name            = Phone Number ID
          DataType        = Text(30)
          Length          = 30
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column phone_area_cd
          Name            = Phone Area Code
          DataType        = char(3)
          Length          = 3
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column phone_num
          Name            = Phone Number
          DataType        = char(12)
          Length          = 12
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
    End Table

    ' ============================================================
    '   Table: code_types                                         
    ' ============================================================
    Begin Table  code_types
       Name            = Code Types
       Begin Column code_type_id
          Name            = code type id
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column code_type_nm
          Name            = code type name
          DataType        = Text(30)
          Length          = 30
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column code_type_ds
          Name            = code type description
          DataType        = Text(100)
          Length          = 100
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column code_type_sts_cd
          Name            = code type status
          DataType        = Text(1)
          Length          = 1
          ServerRule      = code_type_sts_cd is null or ()
          OrdinalNumber   = 0
       End Column
    End Table

    ' ============================================================
    '   Table: customer                                           
    ' ============================================================
    Begin Table  customer
       Name            = Customer
       Begin Column cust_id
          Name            = Customer ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column cust_dept
          Name            = Customer Department
          DataType        = text(30)
          Length          = 30
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column cust_nm
          Name            = Customer Name
          DataType        = text(40)
          Length          = 40
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column cust_addr_id
          Name            = Customer Street Address ID
          DataType        = integer
          Length          = 0
          ServerRule      = cust_addr_id is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column cust_bill_addr_id
          Name            = Customer Billing Address ID
          DataType        = integer
          Length          = 0
          ServerRule      = cust_bill_addr_id is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column cust_allow_inv_cd
          Name            = Allow Customer to create invoice
          DataType        = Text(50)
          Length          = 50
          ServerRule      = cust_allow_inv_cd is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column cust_inv_terms
          Name            = Customer Invoice Terms
          DataType        = Text(50)
          Length          = 50
          ServerRule      = cust_inv_terms is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column cust_approved_cd
          Name            = Customer Approved Code
          DataType        = Text(1)
          Length          = 1
          ServerRule      = cust_approved_cd is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column cust_approved_dt
          Name            = Customer Approved by REM Date
          DataType        = DateTime
          Length          = 0
          ServerRule      = cust_approved_dt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column cust_end_dt
          Name            = Customer Termination Date
          DataType        = DateTime
          Length          = 0
          ServerRule      = cust_end_dt is null or ()
          OrdinalNumber   = 0
       End Column
    End Table

    ' ============================================================
    '   Table: invoice                                            
    ' ============================================================
    Begin Table  invoice
       Name            = Invoice
       Begin Column inv_no
          Name            = Invoice Number
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column cust_id
          Name            = Customer ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column inv_creat_dt
          Name            = Invoice Creation Date
          DataType        = DateTime
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column inv_paid_dt
          Name            = Invoice Paid Date
          DataType        = DateTime
          Length          = 0
          ServerRule      = inv_paid_dt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column inv_num_of_orders
          Name            = Number of Orders on Invoice
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column inv_tot_cost
          Name            = Total Cost of Invoice
          DataType        = Currency
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column c_cont_id
          Name            = Invoice Requested by
          DataType        = integer
          Length          = 0
          ServerRule      = c_cont_id is null or ()
          OrdinalNumber   = 0
       End Column
    End Table

    ' ============================================================
    '   Table: fieldrep                                           
    ' ============================================================
    Begin Table  fieldrep
       Name            = Field Rep
       Begin Column fr_id
          Name            = Field Rep ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column fr_nm
          Name            = Field Rep Name
          DataType        = text(40)
          Length          = 40
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column fr_addr_id
          Name            = Field Rep Street Address ID
          DataType        = integer
          Length          = 0
          ServerRule      = fr_addr_id is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column fr_rec_addr_id
          Name            = Field Rep Receivable Address ID
          DataType        = integer
          Length          = 0
          ServerRule      = fr_rec_addr_id is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column fr_rec_terms
          Name            = Field Rep Receivable Terms
          DataType        = Text(50)
          Length          = 50
          ServerRule      = fr_rec_terms is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column fr_approved_cd
          Name            = Field Rep Approved Code
          DataType        = Text(1)
          Length          = 1
          ServerRule      = fr_approved_cd is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column fr_approved_dt
          Name            = Field Rep Approved by REM Date
          DataType        = DateTime
          Length          = 0
          ServerRule      = fr_approved_dt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column fr_end_dt
          Name            = Field Rep Termination Date
          DataType        = DateTime
          Length          = 0
          ServerRule      = fr_end_dt is null or ()
          OrdinalNumber   = 0
       End Column
    End Table

    ' ============================================================
    '   Table: rem_bpo_rpt                                        
    ' ============================================================
    Begin Table  rem_bpo_rpt
       Name            = REM BPO Report
       Begin Column bpo_id
          Name            = REM BPO ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_type_cd
          Name            = REM BPO Type Code
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column field_rep_id
          Name            = Field Rep ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column fr_cont_id
          Name            = Field Rep Contact ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column fr_addr_id
          Name            = Field Rep Address ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column fr_phone_id
          Name            = Field Rep Phone ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column cust_id
          Name            = Customer ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_assed_amt
          Name            = Assessed Amount
          DataType        = Currency
          Length          = 0
          ServerRule      = bpo_assed_amt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_ann_tax_amt
          Name            = BPO Annual Taxes
          DataType        = Currency
          Length          = 0
          ServerRule      = bpo_ann_tax_amt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_legal_desc
          Name            = BPO Legal Description
          DataType        = Text(250)
          Length          = 250
          ServerRule      = bpo_legal_desc is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_occupied
          Name            = BPO Property Occupied
          DataType        = YesNo
          Length          = 0
          ServerRule      = bpo_occupied is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_insp_ext
          Name            = BPO Exterior Inspection
          DataType        = YesNo
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_insp_int
          Name            = BPO Interior Inspection
          DataType        = YesNo
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_prop_type_cd
          Name            = BPO Property Type
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_90is_sale_amt
          Name            = BPO Est 90_120 Day As Is Sale Price
          DataType        = Currency
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_30qck_sale_amt
          Name            = BPO Est 30_60 Day Quick Sale Price
          DataType        = Currency
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_90rep_sale_amt
          Name            = BPO Est 90_120 Day Repaired Sale Price
          DataType        = Currency
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_90is_list_amt
          Name            = BPO Est 90_120 Day As Is List Price
          DataType        = Currency
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_30qck_list_amt
          Name            = BPO Est 30_60 Day Quick List Price
          DataType        = Currency
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_90rep_list_amt
          Name            = BPO Est 90_120 Day Repair List Price
          DataType        = Currency
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_sug_rep_imp
          Name            = Suggested Repairs and Impovements
          DataType        = Text(250)
          Length          = 250
          ServerRule      = bpo_sug_rep_imp is null or ()
          OrdinalNumber   = 0
       End Column
    End Table

    ' ============================================================
    '   Table: codes                                              
    ' ============================================================
    Begin Table  codes
       Name            = Codes Table
       Begin Column code_type_id
          Name            = Code Type ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column code_id
          Name            = Code ID
          DataType        = Integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column code_val
          Name            = Code Value
          DataType        = Text(100)
          Length          = 100
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column code_key
          Name            = Code Key
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column code_status_cd
          Name            = Code Status Code
          DataType        = Text(1)
          Length          = 1
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
    End Table

    ' ============================================================
    '   Index: fk_code_type                                       
    ' ============================================================
    Begin Index fk_code_type
       Table   = codes
       Foreign = foreignkey
       Field = code_id
    End Index

    ' ============================================================
    '   Table: customer_contact                                   
    ' ============================================================
    Begin Table  customer_contact
       Name            = Customer Contacts
       Begin Column cust_id
          Name            = Customer ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column c_cont_id
          Name            = Customer Contact ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column c_cont_pre_nm
          Name            = Contact Sir Name
          DataType        = Text(1)
          Length          = 1
          ServerRule      = c_cont_pre_nm is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column c_cont_f_name
          Name            = Contact First Name
          DataType        = Text(25)
          Length          = 25
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column c_cont_l_name
          Name            = Contact Last Name
          DataType        = Text(40)
          Length          = 40
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column c_cont_s_name
          Name            = Contact Suffix Name
          DataType        = Text(1)
          Length          = 1
          ServerRule      = c_cont_s_name is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column c_cont_access_cd
          Name            = Contact Access Level Code
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column c_cont_email
          Name            = Contact Email
          DataType        = Text(75)
          Length          = 75
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column c_cont_phone_id
          Name            = Contact Phone Number
          DataType        = integer
          Length          = 0
          ServerRule      = c_cont_phone_id is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column c_cont_fax_id
          Name            = Contact FAX Number
          DataType        = integer
          Length          = 0
          ServerRule      = c_cont_fax_id is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column c_cont_addr_id
          Name            = Contact Address Number
          DataType        = integer
          Length          = 0
          ServerRule      = c_cont_addr_id is null or ()
          OrdinalNumber   = 0
       End Column
    End Table

    ' ============================================================
    '   Table: orders                                             
    ' ============================================================
    Begin Table  orders
       Name            = REM OnLine Orders
       Begin Column orders_id
          Name            = Orders ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column inv_no
          Name            = Invoice Number
          DataType        = integer
          Length          = 0
          ServerRule      = inv_no is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column orders_rem_req_no
          Name            = Order REM Request Number
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column cust_id
          Name            = Customer ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column ord_cust_loan_no
          Name            = Customer Loan Number
          DataType        = Integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column ord_prod_type_cd
          Name            = Product Type Ordered Code
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column ord_rush_cd
          Name            = Rush Order Code
          DataType        = Text(1)
          Length          = 1
          ServerRule      = ord_rush_cd is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_addr1
          Name            = Order Address 1
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column ord_addr2
          Name            = Order Address 2
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column ord_city
          Name            = Order City
          DataType        = Text(40)
          Length          = 40
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column ord_county
          Name            = Order County
          DataType        = Text(40)
          Length          = 40
          ServerRule      = ord_county is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_state
          Name            = Order State Code
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column ord_zip
          Name            = Order Zip Code
          DataType        = Text(10)
          Length          = 10
          ServerRule      = ord_zip is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_desired_dt
          Name            = Order Desired Date
          DataType        = DateTime
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column field_rep_id
          Name            = Order by Field Rep ID
          DataType        = integer
          Length          = 0
          ServerRule      = field_rep_id is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column fr_cont_id
          Name            = Order by Field Rep Contact
          DataType        = integer
          Length          = 0
          ServerRule      = fr_cont_id is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_ent_dt
          Name            = Order Entered Date
          DataType        = DateTime
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column fr_assign_dt
          Name            = Field Rep Assigned Date
          DataType        = DateTime
          Length          = 0
          ServerRule      = fr_assign_dt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column fr_report_dt
          Name            = Field Rep Report Completed Date
          DataType        = DateTime
          Length          = 0
          ServerRule      = fr_report_dt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_comp_dt
          Name            = Order Completed Date
          DataType        = DateTime
          Length          = 0
          ServerRule      = ord_comp_dt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_inv_dt
          Name            = Order Invoiced Date
          DataType        = DateTime
          Length          = 0
          ServerRule      = ord_inv_dt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_paid_dt
          Name            = Order Paid Date
          DataType        = DateTime
          Length          = 0
          ServerRule      = ord_paid_dt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_inv_no
          Name            = Order Invoice Number
          DataType        = integer
          Length          = 0
          ServerRule      = ord_inv_no is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_mrk_val_form_cd
          Name            = Market Valuation Form Type
          DataType        = Text(50)
          Length          = 50
          ServerRule      = ord_mrk_val_form_cd is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_prpty_type_cd
          Name            = Order Property Type Code
          DataType        = Text(50)
          Length          = 50
          ServerRule      = ord_prpty_type_cd is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_occ_sts_cd
          Name            = Order Occupancy Status
          DataType        = Text(50)
          Length          = 50
          ServerRule      = ord_occ_sts_cd is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_num_of_rooms
          Name            = Number of Rooms
          DataType        = integer
          Length          = 0
          ServerRule      = ord_num_of_rooms is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_num_of_bedrms
          Name            = Number of Bedrooms
          DataType        = integer
          Length          = 0
          ServerRule      = ord_num_of_bedrms is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_num_of_baths
          Name            = Number of Baths
          DataType        = integer
          Length          = 0
          ServerRule      = ord_num_of_baths is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_sq_ft
          Name            = Square Feet
          DataType        = integer
          Length          = 0
          ServerRule      = ord_sq_ft is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column ord_comments
          Name            = Order Comments
          DataType        = Text(250)
          Length          = 250
          ServerRule      = ord_comments is null or ()
          OrdinalNumber   = 0
       End Column
    End Table

    ' ============================================================
    '   Table: fieldrep_contact                                   
    ' ============================================================
    Begin Table  fieldrep_contact
       Name            = Field Rep Contacts
       Begin Column fr_id
          Name            = Field Rep ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column fr_cont_id
          Name            = Field Rep Contact ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column fr_cont_pre_nm
          Name            = Field Rep Sir Name
          DataType        = Text(1)
          Length          = 1
          ServerRule      = fr_cont_pre_nm is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column fr_cont_f_name
          Name            = Field Rep First Name
          DataType        = Text(25)
          Length          = 25
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column fr_cont_l_name
          Name            = Field Rep Last Name
          DataType        = Text(40)
          Length          = 40
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column fr_cont_s_name
          Name            = Field Rep Last NameSuffix Name
          DataType        = Text(1)
          Length          = 1
          ServerRule      = fr_cont_s_name is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column fr_cont_access_cd
          Name            = Field Rep Last NameAccess Level Code
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column fr_cont_email
          Name            = Field Rep Last NameEmail
          DataType        = Text(75)
          Length          = 75
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column fr_cont_phone_id
          Name            = Field Rep Last NamePhone Number
          DataType        = integer
          Length          = 0
          ServerRule      = fr_cont_phone_id is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column fr_cont_fax_id
          Name            = Field Rep Last NameFAX Number
          DataType        = integer
          Length          = 0
          ServerRule      = fr_cont_fax_id is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column fr_cont_addr_id
          Name            = Field Rep Last NameAddress Number
          DataType        = integer
          Length          = 0
          ServerRule      = fr_cont_addr_id is null or ()
          OrdinalNumber   = 0
       End Column
    End Table

    ' ============================================================
    '   Table: comp_sales_and_lists                               
    ' ============================================================
    Begin Table  comp_sales_and_lists
       Name            = Comparable Sales and Competitive Listings
       Begin Column csl_id
          Name            = Comp Sales and Lists ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_id
          Name            = BPO ID
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column bpo_type_cd
          Name            = BPO Type Code
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column csl_type_cd
          Name            = Comp Sales and Lists Type Code
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column csl_addr_id
          Name            = Comparative Address
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column csl_proximity
          Name            = Comparative Proximity to
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column csl_list_amt
          Name            = Comparative Listing Price
          DataType        = Currency
          Length          = 0
          ServerRule      = csl_list_amt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column csl_sale_amt
          Name            = Comparative Sale Amount
          DataType        = Currency
          Length          = 0
          ServerRule      = csl_sale_amt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column csl_sale_dt
          Name            = Comparative Sale Date
          DataType        = DateTime
          Length          = 0
          ServerRule      = csl_sale_dt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column csl_days_on_mkt
          Name            = Comparative Days on Market
          DataType        = integer
          Length          = 0
          ServerRule      = csl_days_on_mkt is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column csl_levels_style
          Name            = Comparative Levels or Style
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column csl_ext_const
          Name            = Comparative Exterior Construction
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column csl_sq_ft
          Name            = Comparative Square Feet
          DataType        = integer
          Length          = 0
          ServerRule      = csl_sq_ft is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column csl_age
          Name            = Comparative Age
          DataType        = integer
          Length          = 0
          ServerRule      = csl_age is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column csl_basement
          Name            = Comparative Basement
          DataType        = YesNo
          Length          = 0
          ServerRule      = csl_basement is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column csl_total_rooms
          Name            = Comparative Total Rooms
          DataType        = integer
          Length          = 0
          ServerRule      = csl_total_rooms is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column csl_num_bedrooms
          Name            = Comparative Number of Bedrooms
          DataType        = integer
          Length          = 0
          ServerRule      = csl_num_bedrooms is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column csl_num_baths
          Name            = Comparative Number of Baths
          DataType        = integer
          Length          = 0
          ServerRule      = csl_num_baths is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column csl_family_room
          Name            = Comparative Family Room
          DataType        = YesNo
          Length          = 0
          ServerRule      = csl_family_room is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column csl_garage_num
          Name            = Comparative Garage Number of Cars
          DataType        = integer
          Length          = 0
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column csl_lot_size
          Name            = Comparative Lot Size
          DataType        = Text(20)
          Length          = 20
          ServerRule      = csl_lot_size is null or ()
          OrdinalNumber   = 0
       End Column
       Begin Column csl_overall_cond
          Name            = Comparative Overall Condition
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column csl_design_appeal
          Name            = Comparative Design and Appeal
          DataType        = Text(50)
          Length          = 50
          Mandatory       = YES
          OrdinalNumber   = 0
       End Column
       Begin Column csl_comments
          Name            = Comparative Comments
          DataType        = Text(250)
          Length          = 250
          ServerRule      = csl_comments is null or ()
          OrdinalNumber   = 0
       End Column
    End Table

    
    ' ============================================================
    '   Reference: Ref_35                                         
    ' ============================================================
    Begin Reference Ref_35
       PrimaryTable = code_types
       ForeignTable = codes
       Begin Join
          PrimaryColumn = code_type_id
          ForeignColumn = code_type_id
       End Join
    End Reference
    
    ' ============================================================
    '   Reference: Ref_65                                         
    ' ============================================================
    Begin Reference Ref_65
       PrimaryTable = customer
       ForeignTable = customer_contact
       Begin Join
          PrimaryColumn = cust_id
          ForeignColumn = cust_id
       End Join
    End Reference
    
    ' ============================================================
    '   Reference: Ref_250                                        
    ' ============================================================
    Begin Reference Ref_250
       PrimaryTable = invoice
       ForeignTable = orders
       Begin Join
          PrimaryColumn = inv_no
          ForeignColumn = inv_no
       End Join
    End Reference
    
    ' ============================================================
    '   Reference: Ref_239                                        
    ' ============================================================
    Begin Reference Ref_239
       PrimaryTable = fieldrep
       ForeignTable = fieldrep_contact
       Begin Join
          PrimaryColumn = fr_id
          ForeignColumn = fr_id
       End Join
    End Reference
    
    ' ============================================================
    '   Reference: Ref_552                                        
    ' ============================================================
    Begin Reference Ref_552
       PrimaryTable = rem_bpo_rpt
       ForeignTable = comp_sales_and_lists
       Begin Join
          PrimaryColumn = bpo_id
          ForeignColumn = bpo_id
       End Join
       Begin Join
          PrimaryColumn = bpo_type_cd
          ForeignColumn = bpo_type_cd
       End Join
    End Reference