Create Table Prop_Hist_Sales_Header (HPAID Char(12),
              PAID Char(12), 
              PBKEY Char(12),
              PARENT Char(12),
              PLINKID Char(40),
              SELLER1_FIRST_MIDDLE Char(40),  
              SELLER1_LAST_CORPNAME Char(40),          
              SELLER1_ID_CODE Char(2),
              SELLER2_FIRST_MIDDLE Char(40),
              SELLER2_LAST_CORPNAME Char(40),
              SELLER2_ID_CODE          Char(2),
              SELLER_MAIL_FORMATADDR     Char(80),
              SELLER_MAIL_CITY Char(30),
              SELLER_MAIL_STATE Char(2),
              SELLER_MAIL_POSTCODE Char(7),
              SELLER_MAIL_PLUS4 Char(4),
              BUYER1_FIRST_MIDDLE Char(40),
              BUYER1_LAST_CORPNAME Char(40),
              BUYER1_ID_CODE Char(2),
              BUYER2_FIRST_MIDDLE Char(40),
              BUYER2_LAST_CORPNAME Char(40),
              BUYER2_ID_CODE Char(2),
              BUYER_VEST_CODE Char(2),
              BUYER_MAIL_FORMATADDR Char(80),
              BUYER_MAIL_CITY Char(30),
              BUYER_MAIL_STATE Char(2),
              BUYER_MAIL_POSTCODE            Char(7),
              BUYER_MAIL_PLUS4 Char(4),
              ADDRESS Char(80),
              ADD_NUMBER Char(13),
              PREDIR Char(2),
              STREETNAME Char(60),
              STRTYPE    Char(15),
              POSTDIR Char(2),
              UNIT_DES Char(4),
              UNIT_NUM Char(15),
              CITY Char(30),
              STATE Char(2),
              ZIPCODE Char(5),
              PLUS4 Char(4),
              PROP_APN Char(45),
              MULTI_APN Char(2),
              FIPS Char(5),
              PROP_USE_CODE Char(3),
              DEED_DOC_TYPE Char(2),
              INTER_FAMILY Char(1),
              RECORDING_DATE Char(8),
              RECORDER_BKNUM Char(10),
              RECORDER_PGNUM Char(10),
              RECORDER_DOCNUM    Char(20),
              PAR_INT_TRANSFERRED Char(2),
              LEGAL_LOT Char(2),
              LEGAL_LOTNUMS Char(10),
              LEGAL_BLOCK    Char(7),
              LEGAL_SECTION Char(7),
              LEGAL_DISTRICT Char(7),
              LEGAL_LANDLOT Char(7),
              LEGAL_UNIT Char(6),
              LEGAL_CITY_TWP_MUNI             Char(30),
              LEGAL_SUBNAME Char(50),
              LEGAL_PHASENUM Char(7),
              LEGAL_TRACTNUM Char(10),
              LEGAL_SHORTDESC        Char(200),
              LEGAL_SEC_TWP_RGE_MER Char(30),
              LEGAL_DESC_CODE Char(2),
              RECORDER_MAPREF      Char(20),
              DEED_TRANS_TYPE Char(2),
              CONTD_DOCNUM Char(19),
              CONTRACT_DATE Char(8),
              SALES_PRICE      Integer,
              SALESPRICE_CODE Char(2),
              CITY_TRANSFER_TAX Float,
              CTY_TRANSFER_TAX Float,
              TOTAL_TRANSFER_TAX Float,
              CONTD_LENDER_NAME Char(40),
              CONTD_LENDER_TYPE Char(1),
              CONTD_LOAN_AMT Integer,
              CONTD_LOAN_TYPE Char(2),
              CONTD_TYPE_FINANCING Char(4),
              CONTD_INT_RATE Float,
              CONTD_DUE_DATE Char(8),
              CONTD2_LOAN_AMT Integer,
              ADJ_RATE_RIDER Char(1),
              ADJ_RATE_INDEX Char(15),
              CHANGE_INDEX Float,
              RATE_CHANGE_FREQ Char(1),
              INT_RATE_NOGREATTHAN Float,
              INT_RATE_NOLESSTHAN Float,
              MAX_INT_RATE Float,
              INT_ONLY_PERIOD         Char(2),
              FIXED_CONV_RATE_RIDER Char(1),
              FIRST_CHANGE_DATE_YR_CONV Char(2),
              FIRST_CHANGE_DATE_MTH_DAY_CONV Char(4),
              PREPAYMENT_RIDER Char(1),
              PREPAYMENT_TERM_PENALTY  Char(2),
              TITLE_COMP_NAME      Char(28),
              REO_FLAG Char(1),
              DISTRESSED_SALE_FLAG Char(1),
              LOAN_ORG_NMLS_ID Char(12),
              LOAN_ORG_NAME Char(100),
              MORT_BROKER_NMLS_ID           Char(12),
              MORT_BROKER Char(100),
              LOAN_OFFICER_NMLD_ID Char(12),
              LOAN_OFFICER_NAME Char(150),
              LOAN_TRANS_TYPE Char(2)
) file "D:\Property_Historical_Sales\Prop_Hist_Sales_Header.TAB" TYPE NATIVEX Charset "UTF-16" Locale "en-US"
Create Map For Prop_Hist_Sales_Header CoordSys Earth Projection 1, 104
Browse * From Prop_Hist_Sales_Header