Compensation

{
    "order": 0,
    "index_patterns": ["logstash-hvms-fcd-*"],
    "settings": {
    "number_of_shards": 1
  	},
    "mappings": {
      "hvmsfcd": {
        "properties": {
          "container": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "date": {
            "type": "date"
          },
          "exemptamount": {
            "type": "long"
          },
          "totalcommissionpaid": {
            "type": "float"
          },
          "collectedamount": {
            "type": "float"
          },
          "physicianaccountnumber": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "software": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "year": {
            "type": "long"
          },
          "losscommduetodiscount": {
            "type": "float"
          },
          "weekday": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "discount": {
            "type": "long"
          },
          "itemcategory": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "postalzip": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "drug": {
            "type": "boolean"
          },
          "totalcost": {
            "type": "float"
          },
          "totalprofit": {
            "type": "float"
          },
          "number": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "profitaftercomm": {
            "type": "float"
          },
          "view": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "profitcenter": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "monthname": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "financialrecordid": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "id": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "lat": {
            "type": "float"
          },
          "invoicenumber": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "potentialamount": {
            "type": "float"
          },
          "commissionitemid": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "offset": {
            "type": "float"
          },
          "practiceaccountnumber": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "targettypename": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "rlon": {
            "type": "float"
          },
          "vetseasona": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "tags": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "vetseasonb": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "zipforgps": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "commissionamount": {
            "type": "float"
          },
          "field": {
            "type": "boolean"
          },
          "month": {
            "type": "long"
          },
          "accrualamount": {
            "type": "float"
          },
          "rzipforgps": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "customerid": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "provstate": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "customernumbername": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "patientprofession": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "status": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "commissionpercentage": {
            "type": "float"
          },
          "dispensed": {
            "type": "boolean"
          },
          "week": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "hidden": {
            "type": "boolean"
          },
          "city": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "practicename": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "practiceid": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "description": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "lon": {
            "type": "float"
          },
          "totallistprice": {
            "type": "float"
          },
          "locationaccountnumber": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "sourcetypefullname": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "itemclass": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "locationname": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "practiceshortname": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "invoiceitemid": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "patientnumbername": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "@version": {
            "type": "keyword"
          },
          "invoicepercentage": {
            "type": "float"
          },
          "rlat": {
            "type": "float"
          },
          "invoiceid": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "physician": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "customername": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "profitcenteraccountnumber": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "email": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "accountnumber": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "geoip": {
            "dynamic": "true",
            "properties": {
              "ip": {
                "type": "ip"
              },
              "latitude": {
                "type": "half_float"
              },
              "location": {
                "type": "geo_point"
              },
              "longitude": {
                "type": "half_float"
              }
            }
          },
          "patientid": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "rgeoip": {
            "dynamic": "true",
            "properties": {
              "rip": {
                "type": "ip"
              },
              "rlongitude": {
                "type": "half_float"
              },
              "rlatitude": {
                "type": "half_float"
              },
              "rlocation": {
                "type": "geo_point"
              }
            }
          },
          "totalprice": {
            "type": "float"
          },
          "practicesortorder": {
            "type": "long"
          },
          "rlocation": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "patientname": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "recordid": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "physicianid": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "@timestamp": {
            "type": "date"
          },
          "patientstatus": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "servicedate": {
            "type": "date"
          },
          "species": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "monthendnumber": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "practicenumber": {
            "type": "long"
          },
          "location": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "offsetgrosscomm": {
            "type": "float"
          },
          "sourcetypename": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          },
          "quarter": {
            "norms": false,
            "fields": {
              "keyword": {
                "type": "keyword"
              }
            },
            "type": "text"
          }
        }
      }
    },
    "aliases": {}
  }