---

{
  "application_name": "externalGTT",
  "data_type"       : "gtt",
  "import_group"    : "GTT",
  "import_name"     : "ETERNAL GTT",
  "document_name"   : "EXTERNAL_GTT",
  "storage_name"    : "externalGTT",
  "merge_list"      : "",
  "sources"         :
  [
    {
      "source"          : "f'{BASE_URL}'",
      "source_type"     : "url",
      "attributes"      :
      [
        {
          "origin"      : "Reporter_Code",
          "destination" : "Reporter_Code",
          "type"        : "varchar2(64)"
        },
        {
          "origin"      : "Trade_Flow",
          "destination" : "Trade_Flow",
          "type"        : "varchar2(128)"
        },
        {
          "origin"      : "Is_Mirror_Data",
          "destination" : "Is_Mirror_Data",
          "type"        : "varchar2(64)"
        },
        {
          "origin"      : "Period",
          "destination" : "Period",
          "type"        : "date"
        },
        {
          "origin"      : "Reporter_Name",
          "destination" : "Reporter_Name",
          "type"        : "varchar2(128)"
        },
        {
          "origin"      : "Reporter_Description",
          "destination" : "Reporter_Description",
          "type"        : "varchar2(128)"
        },
        {
          "origin"      : "Reporter_Source",
          "destination" : "Reporter_Source",
          "type"        : "varchar2(128)"
        },
        {
          "origin"      : "Incoterm",
          "destination" : "Incoterm",
          "type"        : "varchar2(64)"
        },
        {
          "origin"      : "Partner_Code",
          "destination" : "Partner_Code",
          "type"        : "varchar2(64)"
        },
        {
          "origin"      : "Partner_Name",
          "destination" : "Partner_Name",
          "type"        : "varchar2(128)"
        },
        {
          "origin"      : "Commodity_HS_Code",
          "destination" : "Commodity_HS_Code",
          "type"        : "number"
        },
        {
          "origin"      : "Commodity_Description",
          "destination" : "Commodity_Description",
          "type"        : "varchar2(256)"
        },
        {
          "origin"      : "HS6_Code",
          "destination" : "HS6_Code",
          "type"        : "number"
        },
        {
          "origin"      : "HS6_Code_Description",
          "destination" : "HS6_Code_Description",
          "type"        : "varchar2(256)"
        },
        {
          "origin"      : "Subdivision",
          "destination" : "Subdivision",
          "type"        : "varchar2(128)"
        },
        {
          "origin"      : "Port",
          "destination" : "Port",
          "type"        : "varchar2(128)"
        },
        {
          "origin"      : "Transport",
          "destination" : "Transport",
          "type"        : "varchar2(128)"
        },
        {
          "origin"      : "Foreign_Port",
          "destination" : "Foreign_Port",
          "type"        : "varchar2(128)"
        },
        {
          "origin"      : "US_State",
          "destination" : "US_State",
          "type"        : "varchar2(128)"
        },
        {
          "origin"      : "Customs_Regime",
          "destination" : "Customs_Regime",
          "type"        : "varchar2(128)"
        },
        {
          "origin"      : "Suppression",
          "destination" : "Suppression",
          "type"        : "varchar2(4000)"
        },
        {
          "origin"      : "Monetary_Value",
          "destination" : "Monetary_Value",
          "type"        : "number"
        },
        {
          "origin"      : "Currency",
          "destination" : "Currency",
          "type"        : "varchar2(64)"
        },
        {
          "origin"      : "Secondary_Monetary_Value",
          "destination" : "Secondary_Monetary_Value",
          "type"        : "number"
        },
        {
          "origin"      : "Secondary_Currency",
          "destination" : "Secondary_Currency",
          "type"        : "varchar2(64)"
        },
        {
          "origin"      : "Primary_Quantity",
          "destination" : "Primary_Quantity",
          "type"        : "number"
        },
        {
          "origin"      : "Primary_Quantity_Unit",
          "destination" : "Primary_Quantity_Unit",
          "type"        : "varchar2(64)"
        },
        {
          "origin"      : "Secondary_Quantity",
          "destination" : "Secondary_Quantity",
          "type"        : "number"
        },
        {
          "origin"      : "Secondary_Quantity_Unit",
          "destination" : "Secondary_Quantity_Unit",
          "type"        : "varchar2(64)"
        },
        {
          "origin"      : "Primary_Quantity_Price",
          "destination" : "Primary_Quantity_Price",
          "type"        : "number"
        },
        {
          "origin"      : "Primary_Quantity_Price_Unit",
          "destination" : "Primary_Quantity_Price_Unit",
          "type"        : "varchar2(64)"
        },
        {
          "origin"      : "Secondary_Quantity_Price",
          "destination" : "Secondary_Quantity_Price",
          "type"        : "number"
        },
        {
          "origin"      : "Secondary_Quantity_Price_Unit",
          "destination" : "Secondary_Quantity_Price_Unit",
          "type"        : "varchar2(64)"
        }
      ]
    }
  ]
}