config/s4/annotations/cdc/lfa1.yaml

name: "{{ project_id_src }}.{{ dataset_cdc_processed }}.lfa1"
description: "Supplier Master (General Section)"
fields:
  - name: "actss"
    description: "Social Ins. Code"
  - name: "addr2_city"
    description: "City"
  - name: "addr2_country"
    description: "Country/Region Key"
  - name: "addr2_house_num"
    description: "House Number"
  - name: "addr2_post"
    description: "Postal Code"
  - name: "addr2_street"
    description: "Street"
  - name: "adrnr"
    description: "Address"
  - name: "aedat"
    description: "(Obsolete) Last Changed"
  - name: "alc"
    description: "Agency Location Code"
  - name: "allowance_type"
    description: "Allowance Type"
  - name: "anred"
    description: "Title"
  - name: "ausdiv"
    description: "Absence of debt"
  - name: "au_carrying_ent"
    description: "Enterprise in AU"
  - name: "au_domestic_nature"
    description: "wholly of a private or domestic nature"
  - name: "au_ind_under_18"
    description: "Individual under 18"
  - name: "au_not_entitled_abn"
    description: "The supplier is not entitled to an ABN"
  - name: "au_partner_without_gain"
    description: "Individual w/o gain"
  - name: "au_payment_exempt"
    description: "The whole of the payment is exempt incom"
  - name: "au_payment_not_exceed_75"
    description: "Payment does not exceed"
  - name: "au_private_hobby"
    description: "An activity done as a private recreation"
  - name: "au_wholly_inp_taxed"
    description: "Wholly Input Taxed"
  - 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: "borgr_datun"
    description: "Date limit: Ext. ID"
  - name: "borgr_yeaun"
    description: "Annual repetition"
  - name: "brsch"
    description: "Industry"
  - name: "bubkz"
    description: "Check digit"
  - name: "carrier_conf"
    description: "Carrier confirmation expected"
  - name: "categ"
    description: "Business Type"
  - name: "cnae"
    description: "CNAE"
  - name: "codcae"
    description: "CAE code"
  - name: "comsize"
    description: "Company Size"
  - name: "confs"
    description: "Confirmation status"
  - name: "crc_num"
    description: "CRC number"
  - name: "crn"
    description: "Companies House Registration 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: "dvalss"
    description: "Social Sec.certificate valid."
  - name: "emnfr"
    description: "Ext. manufacturer"
  - name: "entpub"
    description: "Public entity"
  - name: "erdat"
    description: "Created on"
  - name: "ernam"
    description: "Created by"
  - name: "escrit"
    description: "Deed public use"
  - 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: "frmcss"
    description: "Social Sec.certif.submission"
  - name: "fr_occupation"
    description: "Occupation"
  - 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_1icstno"
    description: "CST number"
  - name: "j_1idedref"
    description: "Deductee Reference Number"
  - name: "j_1iexcd"
    description: "ECC No."
  - name: "j_1iexcive"
    description: "Exc.Tax Ind. Vendor"
  - name: "j_1iexco"
    description: "Excise Commissionerate"
  - name: "j_1iexdi"
    description: "Excise Division"
  - name: "j_1iexrg"
    description: "Excise Range"
  - name: "j_1iexrn"
    description: "Excise Reg. No."
  - name: "j_1ilstno"
    description: "LST number"
  - name: "j_1ipanno"
    description: "Permanent account number"
  - name: "j_1ipanref"
    description: "PAN Reference Number"
  - name: "j_1ipanvaldt"
    description: "PAN Valid From Date"
  - name: "j_1isern"
    description: "Service Tax Regn.No"
  - name: "j_1issist"
    description: "SSI status"
  - name: "j_1ivencre"
    description: "CENVAT Scheme Participant"
  - name: "j_1ivtyp"
    description: "Type of Vendor"
  - name: "j_1i_customs"
    description: "Vendor for customs"
  - 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: "Information 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: "lfa1_eew_supp"
  - 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: "partner_name"
    description: "Prtnr's Trading Name"
  - name: "partner_utr"
    description: "Partner's UTR"
  - 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 External 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: "status"
    description: "Verification Status"
  - 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: "usnam"
    description: "(Obsolete) Changed by the user"
  - name: "vbund"
    description: "Trading Partner No."
  - name: "ven_class"
    description: "GST Vendor Classification"
  - name: "vfnid"
    description: "Tax Status"
  - name: "vfnum"
    description: "Verification Number"
  - name: "weora"
    description: "Origin Acceptance"
  - 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"