name: "{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.CustomersMD"
description: "This view represents customer master data and describes the various fields related to the customers, such as name, address details and contact details, along with several flags defining their business. This view has a granularity of Client(System), Customer number, valid-from date and version ID for international addresses."
catalog_tags:
  - display_name: "line_of_business"
    fields:
      - display_name: "group"
        value: "Master Data"
fields:
  - name: "Client_MANDT"
    description: "Client (Mandant), PK"
  - name: "CustomerNumber_KUNNR"
    description: "Customer Number, PK"
  - name: "ValidFromDate_DATE_FROM"
    description: "Valid-from date, PK"
  - name: "VersionIdForInternationalAddresses_NATION"
    description: "Version ID for International Addresses, PK"
  - name: "CountryKey_LAND1"
    description: "Country Key"
  - name: "Name1_NAME1"
    description: "Name 1"
  - name: "Name2_NAME2"
    description: "Name 2"
  - name: "City_ORT01"
    description: "City"
  - name: "PostalCode_PSTLZ"
    description: "Postal Code"
  - name: "CustomerRegion_REGIO"
    description: "Region (State, Province, Country)"
  - name: "SortField_SORTL"
    description: "Sort Field"
  - name: "StreetAndNumber_STRAS"
    description: "Street and House Number"
  - name: "FirstTelephoneNumber_TELF1"
    description: "First Telephone Number"
  - name: "FaxNumber_TELFX"
    description: "Fax Number"
  - name: "OneTimeAccount_XCPDK"
    description: "Indicator: Is the Account a One-Time Account?"
  - name: "Address_ADRNR"
    description: "Address"
  - name: "MatchcodeSearch_MCOD1"
    description: "Search Term for Matchcode Search"
  - name: "MatchcodeSearch_MCOD2"
    description: "Search Term 2 for Matchcode Search"
  - name: "MatchcodeSearch_MCOD3"
    description: "Search Term 3 for Matchcode Search"
  - name: "Title_ANRED"
    description: "Title"
  - name: "CentralOrderBlockForCustomer_AUFSD"
    description: "Central Order Block for Customer"
  - name: "ExpressTrainStation_BAHNE"
    description: "Express Train Station"
  - name: "TrainStation_BAHNS"
    description: "Train Station"
  - name: "InternationalLocationNumber_BBBNR"
    description: "International Location Number (Part 1)"
  - name: "InternationalLocationNumber_BBSNR"
    description: "International Location Number (Part 2)"
  - name: "AuthorizationGroup_BEGRU"
    description: "Authorization Group"
  - name: "IndustryKey_BRSCH"
    description: "Industry Key"
  - name: "CheckDigitForTheInternationalLocationNumber_BUBKZ"
    description: "Check Digit for the International Location Number"
  - name: "DataCommunicationLineNo_DATLT"
    description: "Data Communication Line Number"
  - name: "DateCreated_ERDAT"
    description: "Date on which the Record Was Created"
  - name: "CreatedBy_ERNAM"
    description: "Name of Person who Created the Object"
  - name: "UnloadingPointsExist_EXABL"
    description: "Indicator: Unloading points exist"
  - name: "CentralBillingBlock_FAKSD"
    description: "Central billing block for Customer"
  - name: "AccountNumberFiscalAddress_FISKN"
    description: "Account Number of the Master Record with the Fiscal Address"
  - name: "WorkingTimeCalendar_KNAZK"
    description: "Working Time Calendar"
  - name: "AlternativePayer_KNRZA"
    description: "Account Number of an Alternative Payer"
  - name: "GroupKey_KONZS"
    description: "Group Key"
  - name: "CustomerAccountGroup_KTOKD"
    description: "Customer Account Group"
  - name: "CustomerClassification_KUKLA"
    description: "Customer Classification"
  - name: "AccountNumberOfVendorOrCreditor_LIFNR"
    description: "Account Number of Vendor or Creditor"
  - name: "CentralDeliveryBlockForTheCustomer_LIFSD"
    description: "Central Delivery Block for the Customer"
  - name: "CityCoordinates_LOCCO"
    description: "City Coordinates"
  - name: "CentralDeletionFlagForMasterRecord_LOEVM"
    description: "Central Deletion Flag for Master Record"
  - name: "Name3_NAME3"
    description: "Name 3"
  - name: "Name4_NAME4"
    description: "Name 4"
  - name: "NielsenId_NIELS"
    description: "Nielsen ID"
  - name: "District_ORT02"
    description: "District"
  - name: "PoBox_PFACH"
    description: "PO Box"
  - name: "POBoxPostalCode_PSTL2"
    description: "P.O. Box Postal Code"
  - name: "CountyCode_COUNC"
    description: "County Code"
  - name: "CityCode_CITYC"
    description: "City Code"
  - name: "RegionalMarket_RPMKR"
    description: "Regional Market"
  - name: "CentralPostingBlock_SPERR"
    description: "Central Posting Block"
  - name: "LanguageKey_SPRAS"
    description: "Language Key"
  - name: "TaxNumber1_STCD1"
    description: "Tax Number 1"
  - name: "TaxNumber2_STCD2"
    description: "Tax Number 2"
  - name: "SubjectToEqualizationTax_STKZA"
    description: "Indicator: Business Partner Subject to Equalization Tax?"
  - name: "LiableForVat_STKZU"
    description: "Liable for VAT"
  - name: "TeleboxNumber_TELBX"
    description: "Telebox number"
  - name: "SecondTelephoneNumber_TELF2"
    description: "Second Telephone Number"
  - name: "TeletexNumber_TELTX"
    description: "Teletex number"
  - name: "TelexNumber_TELX1"
    description: "Telex number"
  - name: "TransportationZone_LZONE"
    description: "Transportation Zone to or from which the goods are delivered"
  - name: "AlternativePayerAllowed_XZEMP"
    description: "Indicator: Is an alternative payer allowed in document?"
  - name: "CompanyIdOfTradingPartner_VBUND"
    description: "Company ID of Trading Partner"
  - name: "VatRegistrationNumber_STCEG"
    description: "VAT Registration Number"
  - name: "Competitor_DEAR1"
    description: "Indicator: Competitor"
  - name: "SalesPartner_DEAR2"
    description: "Indicator: Sales partner"
  - name: "SalesProspect_DEAR3"
    description: "Indicator: Sales Prospect"
  - name: "CustomerType4_DEAR4"
    description: "Indicator for Customer type 4"
  - name: "IdForDefaultSoldToParty_DEAR5"
    description: "ID for Default Sold-to Party"
  - name: "LegalStatus_GFORM"
    description: "Legal Status"
  - name: "IndustryCode1_BRAN1"
    description: "Industry Code 1"
  - name: "IndustryCode2_BRAN2"
    description: "Industry Code 2"
  - name: "IndustryCode3_BRAN3"
    description: "Industry Code 3"
  - name: "IndustryCode4_BRAN4"
    description: "Industry Code 4"
  - name: "IndustryCode5_BRAN5"
    description: "Industry Code 5"
  - name: "InitialContact_EKONT"
    description: "Initial Contact"
  - name: "AnnualSales_UMSAT"
    description: "Annual Sales"
  - name: "YearForWhichSalesAreGiven_UMJAH"
    description: "Year For Which Sales are Given"
  - name: "CurrencyOfSalesFigure_UWAER"
    description: "Currency of Sales figures"
  - name: "YearlyNumberOfEmployees_JMZAH"
    description: "Yearly number of Employees"
  - name: "YearForWhichTheNumberOfEmployeesIsGiven_JMJAH"
    description: "Year for which the Number of Employees is Given"
  - name: "Attribute1_KATR1"
    description: "Attribute 1"
  - name: "Attribute2_KATR2"
    description: "Attribute 2"
  - name: "Attribute3_KATR3"
    description: "Attribute 3"
  - name: "Attribute4_KATR4"
    description: "Attribute 4"
  - name: "Attribute5_KATR5"
    description: "Attribute 5"
  - name: "Attribute6_KATR6"
    description: "Attribute 6"
  - name: "Attribute7_KATR7"
    description: "Attribute 7"
  - name: "Attribute8_KATR8"
    description: "Attribute 8"
  - name: "Attribute9_KATR9"
    description: "Attribute 9"
  - name: "Attribute10_KATR10"
    description: "Attribute 10"
  - name: "NaturalPerson_STKZN"
    description: "Natural Person"
  - name: "AnnualSales_UMSA1"
    description: "Annual Sales"
  - name: "TaxJurisdiction_TXJCD"
    description: "Tax Jurisdiction"
  - name: "FiscalYearVariant_PERIV"
    description: "Fiscal Year Variant"
  - name: "UsageIndicator_ABRVW"
    description: "Usage Indicator"
  - name: "InspectionCarriedOutByCustomer_INSPBYDEBI"
    description: "Inspection Carried Out By Customer (No Inspection Lot)"
  - name: "InspectionForADeliveryNote_INSPATDEBI"
    description: "Inspection for a Delivery Note After Outbound Delivery"
  - name: "ReferenceAccountGroup_KTOCD"
    description: "Reference Account Group for One-Time Account (Customer)"
  - name: "PoBoxCity_PFORT"
    description: "PO Box city"
  - name: "Plant_WERKS"
    description: "Plant"
  - name: "ReportKeyForDataMediumExchange_DTAMS"
    description: "Report key for Data Medium Exchange "
  - name: "InstructionKeyForDataMediumExchange_DTAWS"
    description: "Instruction key for Data Medium Exchange"
  - name: "StatusOfDataTransferIntoSubsequentRelease_DUEFL"
    description: "Status of Data Transfer to Next Release"
  - name: "AssignmentToHierarchy_HZUOR"
    description: "Assignment to Hierarchy"
  - name: "PaymentBlock_SPERZ"
    description: "Payment Block"
  - name: "RLabeling_CustomerplantGroup_ETIKG"
    description: "IS-R Labeling: Customer/Plant Group"
  - name: "IdNonMilitaryUse_CIVVE"
    description: "ID for mainly Non-Military Use"
  - name: "IdForMilitaryUse_MILVE"
    description: "ID for mainly Military Use"
  - name: "ConditionGroup1_KDKG1"
    description: "Customer Condition group 1"
  - name: "ConditionGroup2_KDKG2"
    description: "Customer Condition group 2"
  - name: "ConditionGroup3_KDKG3"
    description: "Customer Condition group 3"
  - name: "ConditionGroup4_KDKG4"
    description: "Customer Condition group 4"
  - name: "ConditionGroup5_KDKG5"
    description: "Customer Condition group 5"
  - name: "AlternativePayerUsingAccountNumber_XKNZA"
    description: "Indicator: Alternative payer using Account Number"
  - name: "TaxType_FITYP"
    description: "Tax Type"
  - name: "TaxNumberType_STCDT"
    description: "Tax Number Type"
  - name: "TaxNumber3_STCD3"
    description: "Tax Number 3"
  - name: "TaxNumber4_STCD4"
    description: "Tax Number 4"
  - name: "TaxNumber5_STCD5"
    description: "Tax Number 5"
  - name: "CustomerIsIcmsExempt_XICMS"
    description: "Customer is ICMS-exempt"
  - name: "CustomerIsIpiExempt_XXIPI"
    description: "Customer is IPI-exempt"
  - name: "CustomerGroupForSubstituicaoTributariaCalculation_XSUBT"
    description: "Customer Group for Substituicao Tributaria group"
  - name: "CustomerCfopCategory_CFOPC"
    description: "Customer's CFOP Category"
  - name: "TaxLaw_Icms_TXLW1"
    description: "Tax law: ICMS"
  - name: "TaxLaw_Ipi_TXLW2"
    description: "Tax law: IPI"
  - name: "IndicatorForBiochemicalWarfare_CCC01"
    description: "Indicator for Biochemical Warfare for Legal Control"
  - name: "IndicatorForNuclearNonproliferation_CCC02"
    description: "Indicator for Nuclear Nonproliferation for Legal Control"
  - name: "IndicatorForNationalSecurity_CCC03"
    description: "Indicator for National Security for Legal Control"
  - name: "IndicatorForMissileTechnology_CCC04"
    description: "Indicator for Missile Technology for Legal Control"
  - name: "CentralSalesBlock_CASSD"
    description: "Central Sales Block for Customer"
  - name: "UniformResourceLocator_KNURL"
    description: "Uniform Resource Locator"
  - name: "NameOfRepresentative_J_1KFREPRE"
    description: "Name of Representative"
  - name: "TypeOfBusiness_J_1KFTBUS"
    description: "Type of Business"
  - name: "TypeOfIndustry_J_1KFTIND"
    description: "Type of Industry"
  - name: "StatusOfChangeAuthorization_CONFS"
    description: "Status of Change Authorization (Central)"
  - name: "DateOnWhichTheChangesWereConfirmed_UPDAT"
    description: "Date on Which the Changes Were Confirmed"
  - name: "TimeOfLastChangeConfirmation_UPTIM"
    description: "Time of Last Change Confirmation"
  - name: "CentralDeletionBlockForMasterRecord_NODEL"
    description: "Central Deletion Block for Master Record"
  - name: "Indicator_Consumer_DEAR6"
    description: "Indicator: Consumer"
  - name: "BusinessPurposeCompletedFlag_CVP_XBLCK"
    description: "Business Purpose Completed Flag"
  - name: "SuframaCode_SUFRAMA"
    description: "Suframa Code"
  - name: "RgNumber_RG"
    description: "RG Number"
  - name: "IssuedBy_EXP"
    description: "Issued By"
  - name: "State_UF"
    description: "State"
  - name: "RgIssuingDate_RGDATE"
    description: "RG Issuing Date"
  - name: "RicNumber_RIC"
    description: "RIC Number"
  - name: "ForeignNationalRegistration_RNE"
    description: "Foreign National Registration"
  - name: "RneIssuingDate_RNEDATE"
    description: "RNE Issuing Date"
  - name: "Cnae_CNAE"
    description: "CNAE"
  - name: "LegalNature_LEGALNAT"
    description: "Legal Nature"
  - name: "CrtNumber_CRTN"
    description: "CRT Number"
  - name: "IcmsTaxpayer_ICMSTAXPAY"
    description: "ICMS Taxpayer"
  - name: "IndustryMainType_INDTYP"
    description: "Industry Main Type"
  - name: "TaxDeclarationType_TDT"
    description: "Tax Declaration Type"
  - name: "CompanySize_COMSIZE"
    description: "Company Size"
  - name: "DeclarationRegimenForPiscofins_DECREGPC"
    description: "Declaration Regimen for PIS/COFINS"
  - name: "AgencyLocationCode_ALC"
    description: "Agency Location Code"
  - name: "PaymentOffice_PMT_OFFICE"
    description: "Payment Office"
  - name: "FeeSchedule_FEE_SCHEDULE"
    description: "Fee Schedule"
  - name: "DunsNumber_DUNS"
    description: "DUNS Number"
  - name: "Duns4_DUNS4"
    description: "DUNS+4"
  - name: "ProcessorGroup_PSOFG"
    description: "Processor group"
  - name: "SubledgerAcctPreprocessingProcedure_PSOIS"
    description: "Subledger acct Preprocessing Procedure"
  - name: "Name1_PSON1"
    description: "Name 1"
  - name: "Name2_PSON2"
    description: "Name 2"
  - name: "Name3_PSON3"
    description: "Name 3"
  - name: "FirstName_PSOVN"
    description: "First Name"
  - name: "Title_PSOTL"
    description: "Title"
  - name: "Description_PSOO1"
    description: "Description"
  - name: "Description_PSOO2"
    description: "Description"
  - name: "Description_PSOO3"
    description: "Description"
  - name: "Description_PSOO4"
    description: "Description"
  - name: "Description_PSOO5"
    description: "Description"
  - name: "ValidToDate_DATE_TO"
    description: "Valid-to date"
  - name: "FormOfAddressKey_TITLE"
    description: "Form-of-Address Key"
  - name: "Addr_NAME1"
    description: "Name 1"
  - name: "Addr_NAME2"
    description: "Name 2"
  - name: "Addr_NAME3"
    description: "Name 3"
  - name: "Addr_NAME4"
    description: "Name 4"
  - name: "City_CITY1"
    description: "City"
  - name: "District_CITY2"
    description: "District"
  - name: "CityCodeForCitystreetFile_CITY_CODE"
    description: "City Code for City/Street file"
  - name: "DistrictCodeForCityAndStreetFile_CITYP_CODE"
    description: "District Code for City/Street file"
  - name: "City_HOME_CITY"
    description: "City (Different from Postal City)"
  - name: "DifferentCityForCitystreetFile_CITYH_CODE"
    description: "Different City for City/Street file"
  - name: "RegionalStructureGrouping_REGIOGROUP"
    description: "Regional Structure Grouping"
  - name: "CityPostalCode_POST_CODE1"
    description: "City Postal Code"
  - name: "PoBoxPostalCode_POST_CODE2"
    description: "PO Box Postal Code"
  - name: "CompanyPostalCode_POST_CODE3"
    description: "Company Postal Code (for Large Customers)"
  - name: "PoBox_PO_BOX"
    description: "PO Box"
  - name: "PoBoxAddressUndeliverableFlag_DONT_USE_P"
    description: "PO Box Address Undeliverable Flag"
  - name: "Flag_PoBoxWithoutNumber_PO_BOX_NUM"
    description: "Flag: PO Box Without Number"
  - name: "PoBoxCity_PO_BOX_LOC"
    description: "PO Box City"
  - name: "CityPoBoxCode_CityFile_CITY_CODE2"
    description: "City PO Box Code (City file)"
  - name: "RegionForPoBox_PO_BOX_REG"
    description: "Region for PO Box (Country, State, Province, ...)"
  - name: "PoBoxCountry_PO_BOX_CTY"
    description: "PO Box Country"
  - name: "TransportationZoneToOrFromWhichTheGoodsAreDelivered_TRANSPZONE"
    description: "Transportation Zone to or from which the Goods are Delivered"
  - name: "Street_STREET"
    description: "Street"
  - name: "StreetAddressUndeliverableFlag_DONT_USE_S"
    description: "Street Address Undeliverable Flag"
  - name: "StreetNumberForCitystreetFile_STREETCODE"
    description: "Street Number for City/Street File"
  - name: "HouseNumber_HOUSE_NUM1"
    description: "House Number"
  - name: "HouseNumberSupplement_HOUSE_NUM2"
    description: "House Number Supplement"
  - name: "Street2_STR_SUPPL1"
    description: "Street 2"
  - name: "Street3_STR_SUPPL2"
    description: "Street 3"
  - name: "Street4_STR_SUPPL3"
    description: "Street 4"
  - name: "Street5_LOCATION"
    description: "Street 5"
  - name: "Building_NumberOrCode_BUILDING"
    description: "Building (Number or Code)"
  - name: "FloorInBuilding_FLOOR"
    description: "Floor in Building"
  - name: "RoomOrAppartmentNumber_ROOMNUMBER"
    description: "Room or Apartment Number"
  - name: "CountryKey_COUNTRY"
    description: "Country Key"
  - name: "Language_LANGU"
    description: "Language Key"
  - name: "Region__REGION"
    description: "Region (State, Province, County)"
  - name: "AddressGroup_Key_BusinessAddressServices_ADDR_GROUP"
    description: "Address Group (Key) (Business Address Services)"
  - name: "Flag_ThereAreMoreAddressGroupAssignments_FLAGGROUPS"
    description: "Flag: There are more address group assignments"
  - name: "Flag_ThisIsAPersonalAddress_PERS_ADDR"
    description: "Flag: This is a personal address"
  - name: "SearchTerm1_SORT1"
    description: "Search Term 1"
  - name: "SearchTerm2_SORT2"
    description: "Search Term 2"
  - name: "FirstTelephoneNo_DiallingCodenumber_TEL_NUMBER"
    description: "First Telephone Number: Dialling Code + Number"
  - name: "FirstTelephoneNo_Extension_TEL_EXTENS"
    description: "First Telephone Number: Extension"
  - name: "CountyCodeForCounty_COUNTY_CODE"
    description: "County Code for County"
  - name: "County_COUNTY"
    description: "County"
  - name: "TownshipCodeForTownship_TOWNSHIP_CODE"
    description: "Township Code for Township"
  - name: "Township_TOWNSHIP"
    description: "Township"
  - name: "CountyNameInUpperCaseForSearchHelp_MC_COUNTY"
    description: "County Name is Upper Case for Search Help"
  - name: "TownshipNameInUpperCaseForSearchHelp_MC_TOWNSHIP"
    description: "Township Name is Upper Case for Search Help"
  - name: "BusinessPurposeCompletedFlag_XPCPT"
    description: "Business Purpose Completed Flag"
