config/ecc/annotations/cdc/lfa1.yaml

name: "{{ project_id_src }}.{{ dataset_cdc_processed }}.lfa1"
description: "Vendor Master (General Section)"
fields:
  - name: "actss"
    description: "Social Ins. Code"
  - name: "adrnr"
    description: "Address"
  - name: "alc"
    description: "Agency Location Code"
  - name: "anred"
    description: "Title"
  - name: "bahns"
    description: "Train station"
  - name: "bbbnr"
    description: "Int. location no. 1"
  - name: "bbsnr"
    description: "Int. location no. 2"
  - name: "begru"
    description: "Authorization Group"
  - name: "brsch"
    description: "Industry"
  - name: "bubkz"
    description: "Check digit"
  - name: "carrier_conf"
    description: "Carrier confirmation expected"
  - name: "cnae"
    description: "CNAE"
  - name: "comsize"
    description: "Company Size"
  - name: "confs"
    description: "Confirmation status"
  - name: "crc_num"
    description: "CRC number"
  - name: "crtn"
    description: "CRT Number"
  - name: "cvp_xblck"
    description: "Business Purpose Completed Flag"
  - name: "datlt"
    description: "Data line"
  - name: "decregpc"
    description: "Declaration Regimen for PIS/COFINS"
  - name: "dlgrp"
    description: "ServAgntProcGrp"
  - name: "dtams"
    description: "DME indicator"
  - name: "dtaws"
    description: "Instruction key"
  - name: "duefl"
    description: "Status of Data Transfer to Next Release"
  - name: "emnfr"
    description: "Ext. manufacturer"
  - name: "erdat"
    description: "Created on"
  - name: "ernam"
    description: "Created by"
  - name: "esrnr"
    description: "PBC/ISR number"
  - name: "exp"
    description: "Issued by"
  - name: "fiskn"
    description: "Fiscal address"
  - name: "fisku"
    description: "Tax office responsible"
  - name: "fityp"
    description: "Tax type"
  - name: "gbdat"
    description: "Date of birth"
  - name: "gbort"
    description: "Place of birth"
  - name: "icmstaxpay"
    description: "ICMS Taxpayer"
  - name: "indtyp"
    description: "Industry Main Type"
  - name: "ipisp"
    description: "Tax split"
  - name: "j_1kfrepre"
    description: "Name of Representative"
  - name: "j_1kftbus"
    description: "Type of Business"
  - name: "j_1kftind"
    description: "Type of Industry"
  - name: "j_sc_capital"
    description: "Capital Amount"
  - name: "j_sc_currency"
    description: "Currency"
  - name: "konzs"
    description: "Group key"
  - name: "kraus"
    description: "Cred.info number"
  - name: "ktock"
    description: "Reference acct group"
  - name: "ktokk"
    description: "Account Group"
  - name: "kunnr"
    description: "Customer"
  - name: "land1"
    description: "Country"
  - name: "legalnat"
    description: "Legal Nature"
  - name: "lfurl"
    description: "URL"
  - name: "lifnr"
    description: "Vendor"
  - name: "lnrza"
    description: "Alternative payee"
  - name: "loevm"
    description: "Central deletion flag"
  - name: "ltsna"
    description: "Vendor sub-range relevant"
  - name: "lzone"
    description: "Transportation Zone"
  - name: "mandt"
    description: "Client (Mandant)"
  - name: "mcod1"
    description: "Name"
  - name: "mcod2"
    description: "Name 2"
  - name: "mcod3"
    description: "City"
  - name: "min_comp"
    description: "Micro Company"
  - name: "name1"
    description: "Name"
  - name: "name2"
    description: "Name 2"
  - name: "name3"
    description: "Name 3"
  - name: "name4"
    description: "Name 4"
  - name: "nodel"
    description: "Central del.block"
  - name: "ort01"
    description: "City"
  - name: "ort02"
    description: "District"
  - name: "pfach"
    description: "PO Box"
  - name: "pfort"
    description: "P.O. Box city"
  - name: "plkal"
    description: "Factory calendar"
  - name: "pmt_office"
    description: "Payment Office"
  - name: "podkzb"
    description: "Relevant for POD"
  - name: "ppa_relevant"
    description: "PPA Relevant"
  - name: "profs"
    description: "Profession"
  - name: "psofg"
    description: "Processor group"
  - name: "psohs"
    description: "House number"
  - name: "psois"
    description: "SLAPrepr.Proced"
  - name: "pson1"
    description: "Name"
  - name: "pson2"
    description: "Name 2"
  - name: "pson3"
    description: "Name 3"
  - name: "psost"
    description: "Street"
  - name: "psotl"
    description: "Title"
  - name: "psovn"
    description: "First Name"
  - name: "pstl2"
    description: "P.O. Box Postal Code"
  - name: "pstlz"
    description: "Postal Code"
  - name: "qssys"
    description: "Actual QM system"
  - name: "qssysdat"
    description: "QM system valid to"
  - name: "regio"
    description: "Region"
  - name: "regss"
    description: "Social Insurance"
  - name: "revdb"
    description: "Last ext.review"
  - name: "rg"
    description: "RG Number"
  - name: "rgdate"
    description: "RG Issuing Date"
  - name: "ric"
    description: "RIC Number"
  - name: "rne"
    description: "Foreign National Registration"
  - name: "rnedate"
    description: "RNE Issuing Date"
  - name: "sam_eft_ind"
    description: "SAM Electronic Fund Transfer Indicator"
  - name: "sam_ue_id"
    description: "SAM Unique Entity Identifier"
  - name: "scacd"
    description: "SCAC"
  - name: "scheduling_type"
    description: "Scheduling Procedure"
  - name: "sexkz"
    description: "Sex"
  - name: "sfrgr"
    description: "Carrier freight grp"
  - name: "sortl"
    description: "Search term"
  - name: "sperm"
    description: "Central purchasing block"
  - name: "sperq"
    description: "Block function"
  - name: "sperr"
    description: "Central posting block"
  - name: "sperz"
    description: "Payment block"
  - name: "spras"
    description: "Language Key"
  - name: "staging_time"
    description: "Staging Time"
  - name: "stcd1"
    description: "Tax Number 1"
  - name: "stcd2"
    description: "Tax Number 2"
  - name: "stcd3"
    description: "Tax Number 3"
  - name: "stcd4"
    description: "Tax Number 4"
  - name: "stcd5"
    description: "Tax Number 5"
  - name: "stcd6"
    description: "Tax Number 6"
  - name: "stcdt"
    description: "Tax number type"
  - name: "stceg"
    description: "VAT Registration No."
  - name: "stenr"
    description: "Tax Number at Responsible Tax Authority"
  - name: "stgdl"
    description: "Stat. grp, service agent"
  - name: "stkza"
    description: "Sales equalizatn tax"
  - name: "stkzn"
    description: "Natural Person"
  - name: "stkzu"
    description: "Liable for VAT"
  - name: "stras"
    description: "Street"
  - name: "submi_relevant"
    description: "CD: Relevant for Collective Numbering"
  - name: "taxbs"
    description: "Tax base"
  - name: "tdt"
    description: "Tax Declaration Type"
  - name: "telbx"
    description: "Telebox number"
  - name: "telf1"
    description: "Telephone 1"
  - name: "telf2"
    description: "Telephone 2"
  - name: "telfx"
    description: "Fax Number"
  - name: "teltx"
    description: "Teletex number"
  - name: "telx1"
    description: "Telex number"
  - name: "term_li"
    description: "Terms of Liability"
  - name: "transport_chain"
    description: "Transportation Chain"
  - name: "txjcd"
    description: "Tax Jurisdiction"
  - name: "uf"
    description: "State"
  - name: "updat"
    description: "Confirmation date"
  - name: "uptim"
    description: "Confirmation time"
  - name: "vbund"
    description: "Trading partner"
  - name: "werkr"
    description: "Plant level relevant"
  - name: "werks"
    description: "Plant"
  - name: "xcpdk"
    description: "One-time account"
  - name: "xlfza"
    description: "Accts for alt. payee"
  - name: "xzemp"
    description: "Payee in document"