name: "{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.CountriesMD"
description: "Master data is the fundamental business data in an enterprise and defines the business objects and classifications. CountriesMD gives different details about the countries for the companies and it key characteristics including name, postal code details, currencies, etc. at  at the granularity of Client(System), country key and Language key."
catalog_tags:
  - display_name: "line_of_business"
    fields:
      - display_name: "group"
        value: "Master Data"
fields:
  - name: "Client_MANDT"
    description: "Client (Mandant), PK"
  - name: "CountryKey_LAND1"
    description: "Country Key, PK"
  - name: "CountryName_LANDX"
    description: "Country Name"
  - name: "Language_SPRAS"
    description: "Language Key, PK"
  - name: "Nationality_NATIO"
    description: "Nationality"
  - name: "CountryName__max50Characters___LANDX50"
    description: "Country Name (Long)"
  - name: "Nationality__max50Characters___NATIO50"
    description: "Nationality (Long)"
  - name: "SuperRegionPerCountryText_PRQ_SPREGT"
    description: "Super Region Per Country Text"
  - name: "VehicleCountryKey_LANDK"
    description: "Vehicle Country Key"
  - name: "PostalCodeLength_LNPLZ"
    description: "Postal Code Length"
  - name: "RuleForThePostalCodeFieldCheck_PRPLZ"
    description: "Rule For The Postal Code Field Check"
  - name: "FormattingRoutineKeyForPrintingAddresses_ADDRS"
    description: "Formatting Routine Key For Printing Addresses"
  - name: "Flag_StreetAddressPostalCodeRequiredEntry_XPLZS"
    description: "Flag: Street Address Postal code required entry?"
  - name: "Flag_PoBoxPostalCodeRequired_XPLPF"
    description: "Flag: PO Box postal code required?"
  - name: "CountryLanguage_SPRAS"
    description: "Country Language Key"
  - name: "CountryVersionFlag_XLAND"
    description: "Country Version Flag"
  - name: "Flag_PrintCountryNameInForeignAddresses_XADDR"
    description: "Flag: Print country name in foreign addresses?"
  - name: "StandardNameFormat_NMFMT"
    description: "Standard Name Format"
  - name: "Flag_CityFileAddressCheck_XREGS"
    description: "Flag: City file address check"
  - name: "FlagStreetSpecificPostalCode__cityFile___XPLST"
    description: "Flag: Street-specific postal code? (City file)"
  - name: "CountryIsoCode_INTCA"
    description: "Country ISO Code"
  - name: "IsoCountryCode3Char_INTCA3"
    description: "ISO Country Code 3-Characters"
  - name: "IsoCountryCodeNumeric3Characters_INTCN3"
    description: "ISO Country Code Numeric 3-Characters"
  - name: "Indicator_EuropeanUnionMember_XEGLD"
    description: "Indicator: European Union Member?"
  - name: "Indicator_DiscountBaseAmountIsTheNetValue_XSKFN"
    description: "Indicator: Discount base amount is the net value"
  - name: "Indicator_BaseAmountForTaxIsNetOfDiscount_XMWSN"
    description: "Indicator: Base amount for tax is net of discount?"
  - name: "BankAccountNumberLength_LNBKN"
    description: "Bank Account Number Length"
  - name: "RuleForCheckingBankAccountNumberField_PRBKN"
    description: "Rule For Checking Bank Account Number Field"
  - name: "BankNumberLength_LNBLZ"
    description: "Bank Number Length"
  - name: "RuleForCheckingBankNumberField_PRBLZ"
    description: "Rule For Checking Bank Number Field"
  - name: "PostOfficeBankCurrentAccountNumberLength_LNPSK"
    description: "Post Office Bank Current Account Number Length"
  - name: "RuleForCheckingPostalCheckAccountNumberField_PRPSK"
    description: "Rule For Checking Postal Check Account Number Field"
  - name: "Indicator_UseCheckModuleForBankFields_XPRBK"
    description: "Indicator: Use check module for bank fields?"
  - name: "NameOfTheBankKey_BNKEY"
    description: "Name Of The Bank Key"
  - name: "LengthOfBankKey_LNBKS"
    description: "Length Of Bank Key"
  - name: "RuleForCheckingBankKeyField_PRBKS"
    description: "Rule For Checking Bank Key Field"
  - name: "Indicator_UseCheckModuleForTaxFieldsEtc_XPRSO"
    description: "Indicator: Use check module for tax fields etc.?"
  - name: "RuleForCheckingVatRegistrationNumberField_PRUIN"
    description: "Rule For Checking VAT Registration Number Field"
  - name: "VatRegistrationNumberLength_UINLN"
    description: "Vat Registration Number Length"
  - name: "PermittedInputLengthForTaxNumbre1_LNST1"
    description: "Permitted Input Length For Tax Number 1"
  - name: "RuleForCheckingTaxCode1Field_PRST1"
    description: "Rule For Checking Tax Code 1 Field"
  - name: "PermittedInputLengthForTaxNumber2_LNST2"
    description: "Permitted Input Length For Tax Number 2"
  - name: "RuleForCheckingTaxCode2Field_PRST2"
    description: "Rule For Checking Tax Code 2 Field"
  - name: "PermittedInputLengthForTaxNumber3_LNST3"
    description: "Permitted Input Length For Tax Number 3"
  - name: "RuleForCheckingTaxCode3Field_PRST3"
    description: "Rule For Checking Tax Code 3 Field"
  - name: "PermittedInputLengthForTaxNumber4_LNST4"
    description: "Permitted Input Length For Tax Number 4"
  - name: "RuleForCheckingTaxCode4Field_PRST4"
    description: "Rule For Checking Tax Code 4 Field"
  - name: "PermittedInputLengthForTaxNumber5_LNST5"
    description: "Permitted Input Length For Tax Number 5"
  - name: "RuleForCheckingTaxCode5Field_PRST5"
    description: "Rule For Checking Tax Code 5 Field"
  - name: "Duevo_Nationality_LANDD"
    description: "DUEVO: Nationality"
  - name: "Procedure__pricing_KALSM"
    description: "(Pricing, Output Control, Acct. Det., Costing,etc)"
  - name: "AlternativeCountryKey_LANDA"
    description: "Alternative Country Key"
  - name: "PaymentPeriodForBillOfExchange_WECHF"
    description: "Bill of Exchange Payment Period"
  - name: "ShortNameForForeignTradeStatistics_LKVRZ"
    description: "Short Name For Foreign Trade Statistics"
  - name: "IntrastatCode_INTCN"
    description: "Intrastat Code"
  - name: "DecimalPointFormat_XDEZP"
    description: "Decimal Point Format"
  - name: "DateFormat_DATFM"
    description: "Date Format"
  - name: "CurrencyKeyOfTheIndexBasedCurrency_CURIN"
    description: "Currency Key Of The Index-Based Currency"
  - name: "CurrencyKeyOfTheHardCurrency_CURHA"
    description: "Currency Key Of The Hard Currency"
  - name: "CountryCurrency_WAERS"
    description: "Country Currency"
  - name: "ExchangeRateTypeForTranslationIntoCountryCurrency_KURST"
    description: "Exchange Rate Type For Translation Into Country Currency"
  - name: "ChartOfDepreciatonForAssetValuation_AFAPL"
    description: "Chart Of Depreciaton For Asset Valuation"
  - name: "MaximumLowValueAssetAmount_GWGWRT"
    description: "Maximum Low-Value Asset Amount"
  - name: "NetBookValueForChangeoverOfDepreciationMethod_UMRWRT"
    description: "Net Book Value For Changeover Of Depreciation Method"
  - name: "IndicatorPostNetBookValueForRetirement_KZRBWB"
    description: "Indicator Post Net Book Value For Retirement"
  - name: "IndicatorTransferDownPaymentsFromPreviousYears_XANZUM"
    description: "Indicator Transfer Down Payments From Previous Years"
  - name: "WithholdingTaxCertificateNumbering_Concepts_CTNCONCEPT"
    description: "Withholding Tax Certificate Numbering: Concepts"
  - name: "TaxesAtIndividualServiceLevel_KZSRV"
    description: "Taxes At Individual Service Level"
  - name: "Indicator_DisplayCapitalGoodsIndicator_XXINVE"
    description: "Indicator: Display Capital Goods Indicator?"
  - name: "SuperRegionPerCountry_SUREG"
    description: "Super Region Per Country"
