<?xml version="1.0" encoding="utf-8"?>
<metadata xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.activequerybuilder.com/schemas/metadata2.xsd">
<database name="Winshuttle">
<schema name="WinshuttleDD">
<table name="KNA1" alt_name="KNA1 (General Data in Customer Master)">
<description>General Data in Customer Master</description>
<user_data>TRANSP</user_data>
<field name="KUNNR" primary_key="True" type="String" size="10" precision="3" scale="1">
<description>Customer Number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LAND1" primary_key="True" type="String" size="3" precision="2">
<description>Country Key</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="NAME1" type="String" size="35">
<description>Name 1</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="NAME2" type="String" size="35">
<description>Name 2</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ORT01" type="String" size="35">
<description>City</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSTLZ" primary_key="True" type="String" size="10" precision="2">
<description>Postal Code</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="REGIO" type="String" size="3">
<description>Region (State, Province, County)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="SORTL" primary_key="True" type="String" size="10" precision="2">
<description>Sort field</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STRAS" type="String" size="35">
<description>Street and House Number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TELF1" type="String" size="16">
<description>First telephone number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TELFX" type="String" size="31">
<description>Fax Number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="XCPDK" type="String" size="1">
<description>Indicator: Is the account a one-time account?</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ADRNR" type="String" size="10">
<description>Address</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="MCOD1" primary_key="True" type="String" size="25" precision="2">
<description>Search term for matchcode search</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="MCOD2" primary_key="True" type="String" size="25" precision="2">
<description>Search Term for Matchcode Search</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="MCOD3" primary_key="True" type="String" size="25" precision="2">
<description>Search term for matchcode search</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ANRED" type="String" size="15">
<description>Title</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="AUFSD" type="String" size="2">
<description>Central order block for customer</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BAHNE" type="String" size="25">
<description>Express train station</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BAHNS" type="String" size="25">
<description>Train station</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BBBNR" primary_key="True" type="String" size="7" precision="2">
<description>International location number (part 1)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BBSNR" primary_key="True" type="String" size="5" precision="2">
<description>International location number (Part 2)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BEGRU" type="String" size="4">
<description>Authorization Group</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BRSCH" type="String" size="4">
<description>Industry key</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BUBKZ" primary_key="True" type="String" size="1" precision="2">
<description>Check digit for the international location number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DATLT" type="String" size="14">
<description>Data communication line no.</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ERDAT" type="Date" size="10">
<description>Date on which the Record Was Created</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ERNAM" type="String" size="12">
<description>Name of Person who Created the Object</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="EXABL" type="String" size="1">
<description>Indicator: Unloading points exist</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FAKSD" type="String" size="2">
<description>Central billing block for customer</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FISKN" primary_key="True" type="String" size="10" precision="2">
<description>Account number of the master record with the fiscal address</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KNAZK" type="String" size="2">
<description>Working Time Calendar</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KNRZA" type="String" size="10">
<description>Account number of an alternative payer</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KONZS" type="String" size="10">
<description>Group key</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KTOKD" type="String" size="4">
<description>Customer Account Group</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KUKLA" type="String" size="2">
<description>Customer Classification</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LIFNR" type="String" size="10">
<description>Account Number of Vendor or Creditor</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LIFSD" type="String" size="2">
<description>Central delivery block for the customer</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LOCCO" type="String" size="10">
<description>City Coordinates</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LOEVM" type="String" size="1">
<description>Central Deletion Flag for Master Record</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="NAME3" type="String" size="35">
<description>Name 3</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="NAME4" type="String" size="35">
<description>Name 4</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="NIELS" type="String" size="2">
<description>Nielsen ID</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ORT02" type="String" size="35">
<description>District</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PFACH" type="String" size="10">
<description>PO Box</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSTL2" type="String" size="10">
<description>P.O. Box Postal Code</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="COUNC" type="String" size="3">
<description>County Code</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CITYC" type="String" size="4">
<description>City Code</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="RPMKR" type="String" size="5">
<description>Regional market</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="SPERR" type="String" size="1">
<description>Central posting block</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="SPRAS" type="String" size="2">
<description>Language Key</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>LANG</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STCD1" type="String" size="16">
<description>Tax Number 1</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STCD2" type="String" size="11">
<description>Tax Number 2</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STKZA" type="String" size="1">
<description>Indicator: Business Partner Subject to Equalization Tax?</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STKZU" type="String" size="1">
<description>Liable for VAT</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TELBX" type="String" size="15">
<description>Telebox number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TELF2" type="String" size="16">
<description>Second telephone number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TELTX" type="String" size="30">
<description>Teletex number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TELX1" type="String" size="30">
<description>Telex number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LZONE" type="String" size="10">
<description>Transportation zone to or from which the goods are delivered</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="XZEMP" type="String" size="1">
<description>Indicator: Is an alternative payer allowed in document?</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VBUND" type="String" size="6">
<description>Company ID of trading partner</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STCEG" type="String" size="20">
<description>VAT Registration Number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DEAR1" type="String" size="1">
<description>Indicator: Competitor</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DEAR2" type="String" size="1">
<description>Indicator: Sales partner</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DEAR3" type="String" size="1">
<description>Indicator: Sales prospect</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DEAR4" type="String" size="1">
<description>Indicator for customer type 4</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DEAR5" type="String" size="1">
<description>ID for default sold-to party</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="GFORM" type="String" size="2">
<description>Legal status</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BRAN1" type="String" size="10">
<description>Industry code 1</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BRAN2" type="String" size="10">
<description>Industry code 2</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BRAN3" type="String" size="10">
<description>Industry code 3</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BRAN4" type="String" size="10">
<description>Industry code 4</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BRAN5" type="String" size="10">
<description>Industry code 5</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="EKONT" type="String" size="10">
<description>Initial contact</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UMSAT" type="Decimal" size="10">
<description>Annual sales</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CURR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UMJAH" type="String" size="4">
<description>Year For Which Sales are Given</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UWAER" type="String" size="5">
<description>Currency of sales figure</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CUKY</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="JMZAH" type="String" size="6">
<description>Yearly number of employees</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="JMJAH" type="String" size="4">
<description>Year for which the number of employees is given</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KATR1" type="String" size="2">
<description>Attribute 1</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KATR2" type="String" size="2">
<description>Attribute 2</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KATR3" type="String" size="2">
<description>Attribute 3</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KATR4" type="String" size="2">
<description>Attribute 4</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KATR5" type="String" size="2">
<description>Attribute 5</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KATR6" type="String" size="3">
<description>Attribute 6</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KATR7" type="String" size="3">
<description>Attribute 7</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KATR8" type="String" size="3">
<description>Attribute 8</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KATR9" type="String" size="3">
<description>Attribute 9</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KATR10" type="String" size="3">
<description>Attribute 10</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STKZN" type="String" size="1">
<description>Natural Person</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UMSA1" type="Decimal" size="20">
<description>Annual sales</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CURR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TXJCD" type="String" size="15">
<description>Tax Jurisdiction</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PERIV" type="String" size="2">
<description>Fiscal Year Variant</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ABRVW" type="String" size="3">
<description>Usage Indicator</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="INSPBYDEBI" type="String" size="1">
<description>Inspection Carried Out By Customer (No Inspection Lot)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="INSPATDEBI" type="String" size="1">
<description>Inspection for a Delivery Note After Outbound Delivery</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KTOCD" type="String" size="4">
<description>Reference Account Group for One-Time Account (Customer)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PFORT" type="String" size="35">
<description>PO Box city</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="WERKS" type="String" size="4">
<description>Plant</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DTAMS" type="String" size="1">
<description>Report key for data medium exchange</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DTAWS" type="String" size="2">
<description>Instruction key for data medium exchange</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DUEFL" type="String" size="1">
<description>Status of Data Transfer into Subsequent Release</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="HZUOR" type="String" size="2">
<description>Assignment to Hierarchy</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="SPERZ" type="String" size="1">
<description>Payment Block</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ETIKG" type="String" size="10">
<description>IS-R Labeling: customer/plant group</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CIVVE" type="String" size="1">
<description>ID for mainly non-military use</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="MILVE" type="String" size="1">
<description>ID for mainly military use</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KDKG1" type="String" size="2">
<description>Customer condition group 1</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KDKG2" type="String" size="2">
<description>Customer condition group 2</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KDKG3" type="String" size="2">
<description>Customer condition group 3</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KDKG4" type="String" size="2">
<description>Customer condition group 4</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KDKG5" type="String" size="2">
<description>Customer condition group 5</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="XKNZA" type="String" size="1">
<description>Indicator: Alternative payer using account number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FITYP" type="String" size="2">
<description>Tax type</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STCDT" type="String" size="2">
<description>Tax Number Type</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STCD3" type="String" size="18">
<description>Tax Number 3</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STCD4" type="String" size="18">
<description>Tax Number 4</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STCD5" type="String" size="60">
<description>Tax Number 5</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STCD6" type="String" size="20">
<description>Tax Number 6</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="XICMS" type="String" size="1">
<description>Customer is ICMS-exempt</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="XXIPI" type="String" size="1">
<description>Customer is IPI-exempt</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="XSUBT" type="String" size="3">
<description>Customer group for Substituiçao Tributária calculation</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CFOPC" type="String" size="2">
<description>Customer's CFOP category</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TXLW1" type="String" size="3">
<description>Tax law: ICMS</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TXLW2" type="String" size="3">
<description>Tax law: IPI</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CCC01" type="String" size="1">
<description>Indicator for biochemical warfare for legal control</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CCC02" type="String" size="1">
<description>Indicator for nuclear nonproliferation for legal control</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CCC03" type="String" size="1">
<description>Indicator for national security for legal control</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CCC04" type="String" size="1">
<description>Indicator for missile technology for legal control</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CASSD" type="String" size="2">
<description>Central sales block for customer</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KNURL" type="String" size="132">
<description>Uniform resource locator</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="J_1KFREPRE" type="String" size="10">
<description>Name of Representative</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="J_1KFTBUS" type="String" size="30">
<description>Type of Business</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="J_1KFTIND" type="String" size="30">
<description>Type of Industry</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CONFS" primary_key="True" type="String" size="1" precision="2">
<description>Status of Change Authorization (Central)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UPDAT" type="Date" size="10">
<description>Date on Which the Changes Were Confirmed</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UPTIM" type="Time" size="8">
<description>Time of Last Change Confirmation</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>TIMS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="NODEL" type="String" size="1">
<description>Central deletion block for master record</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DEAR6" type="String" size="1">
<description>Indicator: Consumer</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CVP_XBLCK" type="String" size="1">
<description>Business Purpose Completed Flag</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="SUFRAMA" type="String" size="9">
<description>Suframa Code</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="RG" type="String" size="11">
<description>RG Number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="EXP" type="String" size="3">
<description>Issued by</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UF" type="String" size="2">
<description>State</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="RGDATE" type="Date" size="10">
<description>RG Issuing Date</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="RIC" type="String" size="11">
<description>RIC Number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="RNE" type="String" size="10">
<description>Foreign National Registration</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="RNEDATE" type="Date" size="10">
<description>RNE Issuing Date</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CNAE" type="String" size="7">
<description>CNAE</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LEGALNAT" type="String" size="4">
<description>Legal Nature</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CRTN" type="String" size="1">
<description>CRT Number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ICMSTAXPAY" type="String" size="2">
<description>ICMS Taxpayer</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="INDTYP" type="String" size="2">
<description>Industry Main Type</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TDT" type="String" size="2">
<description>Tax Declaration Type</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="COMSIZE" type="String" size="2">
<description>Company Size</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DECREGPC" type="String" size="2">
<description>Declaration Regimen for PIS/COFINS</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="/VSO/R_PALHGT" type="Decimal" size="17">
<description>Maximum Stacking Height of the Packaging Material (VSO)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>QUAN</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="/VSO/R_PAL_UL" type="String" size="3">
<description>Unit of Length for Packaging Material (VSO)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>UNIT</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="/VSO/R_PK_MAT" type="String" size="1">
<description>Customer-Related Packing for Each Packaging Material (VSO)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="/VSO/R_MATPAL" type="String" size="18">
<description>Packaging Material of the Customer in VSO</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="/VSO/R_I_NO_LYR" type="String" size="2">
<description>Number Layers Under an Inter-Pallet (VSO)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="/VSO/R_ONE_MAT" type="String" size="1">
<description>Packing Material-Specific for Each Packaging Material</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="/VSO/R_ONE_SORT" type="String" size="1">
<description>Pack Only One Package Type for Each PKM (VSO)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="/VSO/R_ULD_SIDE" type="String" size="1">
<description>Side Preference of Loading/Unloading (VSO)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="/VSO/R_LOAD_PREF" type="String" size="1">
<description>Front/Back Preference of Loading/Unloading (VSO)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="/VSO/R_DPOINT" type="String" size="10">
<description>Collective Unloading Point for VSO</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ALC" type="String" size="8">
<description>Agency Location Code</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PMT_OFFICE" type="String" size="5">
<description>Payment Office</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FEE_SCHEDULE" type="String" size="4">
<description>Fee schedule</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DUNS" type="String" size="9">
<description>DUNS Number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DUNS4" type="String" size="4">
<description>DUNS+4</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSOFG" type="String" size="10">
<description>Processor group</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSOIS" type="String" size="20">
<description>Subledger acct preprocessing procedure</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSON1" type="String" size="35">
<description>Name 1</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSON2" type="String" size="35">
<description>Name 2</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSON3" type="String" size="35">
<description>Name 3</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSOVN" type="String" size="35">
<description>First Name</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSOTL" type="String" size="20">
<description>Title</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSOHS" type="String" size="6">
<description>House number: is no longer used from Release 4.6B</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSOST" type="String" size="28">
<description>Street: No longer used from Release 4.6B</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSOO1" type="String" size="50">
<description>Description</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSOO2" type="String" size="50">
<description>Description</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSOO3" type="String" size="50">
<description>Description</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSOO4" type="String" size="50">
<description>Description</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PSOO5" type="String" size="50">
<description>Description</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>KNA1</name>
</referenced_object>
<referencing_field name="KUNNR" referenced_field="KUNNR" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
</table>
<table name="KNVV" alt_name="KNVV (Customer Master Sales Data)">
<description>Customer Master Sales Data</description>
<user_data>TRANSP</user_data>
<field name="KUNNR" primary_key="True" type="String" size="10" precision="3">
<description>Customer Number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>KNA1</name>
</referenced_object>
<referencing_field name="KUNNR" referenced_field="KUNNR" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="VKORG" primary_key="True" type="String" size="4" precision="3">
<description>Sales Organization</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>TVKO</name>
</referenced_object>
<referencing_field name="VKORG" referenced_field="VKORG" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="VTWEG" primary_key="True" type="String" size="2" precision="3">
<description>Distribution Channel</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>TVTW</name>
</referenced_object>
<referencing_field name="VTWEG" referenced_field="VTWEG" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="SPART" primary_key="True" type="String" size="2" precision="3">
<description>Division</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>TSPA</name>
</referenced_object>
<referencing_field name="SPART" referenced_field="SPART" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="ERNAM" type="String" size="12">
<description>Name of Person Who Created the Object</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ERDAT" type="Date" size="10">
<description>Date on Which Record Was Created</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BEGRU" type="String" size="4">
<description>Authorization Group</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LOEVM" type="String" size="1">
<description>Deletion flag for customer (sales level)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VERSG" type="String" size="1">
<description>Customer Statistics Group</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="AUFSD" type="String" size="2">
<description>Customer order block (sales area)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KALKS" type="String" size="1">
<description>Pricing procedure assigned to this customer</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KDGRP" type="String" size="2">
<description>Customer group</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BZIRK" type="String" size="6">
<description>Sales district</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KONDA" type="String" size="2">
<description>Price group (customer)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PLTYP" type="String" size="2">
<description>Price list type</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="AWAHR" type="String" size="3">
<description>Order probability of the item</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="INCO1" type="String" size="3">
<description>Incoterms (Part 1)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="INCO2" type="String" size="28">
<description>Incoterms (Part 2)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LIFSD" type="String" size="2">
<description>Customer delivery block (sales area)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="AUTLF" type="String" size="1">
<description>Complete delivery defined for each sales order?</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ANTLF" type="Decimal" size="1">
<description>Maximum Number of Partial Deliveries Allowed Per Item</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DEC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KZTLF" type="String" size="1">
<description>Partial Delivery at Item Level</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KZAZU" type="String" size="1">
<description>Order Combination Indicator</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CHSPL" type="String" size="1">
<description>Batch split allowed</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LPRIO" type="String" size="2">
<description>Delivery Priority</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="EIKTO" type="String" size="12">
<description>Shipper's (Our) Account Number at the Customer or Vendor</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VSBED" type="String" size="2">
<description>Shipping Conditions</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FAKSD" type="String" size="2">
<description>Billing block for customer (sales and distribution)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="MRNKZ" type="String" size="1">
<description>Manual invoice maintenance</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PERFK" type="String" size="2">
<description>Invoice dates (calendar identification)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PERRL" type="String" size="2">
<description>Invoice list schedule (calendar identification)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KVAKZ" type="String" size="1">
<description>Cost estimate indicator (inactive)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KVAWT" type="Decimal" size="16">
<description>Value limit for cost estimate (inactive)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CURR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="WAERS" type="String" size="5">
<description>Currency</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CUKY</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KLABC" type="String" size="2">
<description>Customer classification (ABC analysis)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KTGRD" type="String" size="2">
<description>Account Assignment Group for Customer</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ZTERM" type="String" size="4">
<description>Terms of Payment Key</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VWERK" type="String" size="4">
<description>Delivering Plant (Own or External)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VKGRP" primary_key="True" type="String" size="3" precision="2">
<description>Sales Group</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VKBUR" type="String" size="4">
<description>Sales Office</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VSORT" type="String" size="10">
<description>Item proposal</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KVGR1" type="String" size="3">
<description>Customer group 1</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KVGR2" type="String" size="3">
<description>Customer group 2</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KVGR3" type="String" size="3">
<description>Customer group 3</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KVGR4" type="String" size="3">
<description>Customer group 4</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KVGR5" type="String" size="3">
<description>Customer group 5</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BOKRE" type="String" size="1">
<description>Indicator: Customer Is Rebate-Relevant</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BOIDT" type="Date" size="10">
<description>Start of validity per.for the rebate index for the customer</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KURST" type="String" size="4">
<description>Exchange Rate Type</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PRFRE" type="String" size="1">
<description>Relevant for price determination ID</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PRAT1" type="String" size="1">
<description>ID for product attribute 1</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PRAT2" type="String" size="1">
<description>ID for product attribute 2</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PRAT3" type="String" size="1">
<description>ID for product attribute 3</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PRAT4" type="String" size="1">
<description>ID for product attribute 4</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PRAT5" type="String" size="1">
<description>ID for product attribute 5</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PRAT6" type="String" size="1">
<description>ID for product attribute 6</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PRAT7" type="String" size="1">
<description>ID for product attribute 7</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PRAT8" type="String" size="1">
<description>ID for product attribute 8</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PRAT9" type="String" size="1">
<description>ID for product attribute 9</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PRATA" type="String" size="1">
<description>ID for product attribute 10</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KABSS" type="String" size="4">
<description>Customer payment guarantee procedure</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KKBER" type="String" size="4">
<description>Credit control area</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CASSD" type="String" size="2">
<description>Sales block for customer (sales area)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="RDOFF" type="String" size="1">
<description>Switch off rounding?</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="AGREL" type="String" size="1">
<description>Indicator: Relevant for agency business</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="MEGRU" type="String" size="4">
<description>Unit of Measure Group</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UEBTO" type="Decimal" size="4">
<description>Overdelivery Tolerance Limit</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DEC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UNTTO" type="Decimal" size="4">
<description>Underdelivery Tolerance Limit</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DEC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UEBTK" type="String" size="1">
<description>Unlimited overdelivery allowed</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PVKSM" type="String" size="2">
<description>Customer procedure for product proposal</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PODKZ" type="String" size="1">
<description>Relevant for POD processing</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PODTG" type="Decimal" size="11">
<description>Timeframe for Confirmation of POD</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DEC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BLIND" type="String" size="1">
<description>Index Structure Active for Subsequent Settlement (in AB)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CARRIER_NOTIF" type="String" size="1">
<description>Carrier is to be notified</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CVP_XBLCK_V" type="String" size="1">
<description>Business Purpose Completed Flag</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="INCOV" type="String" size="4">
<description>Incoterms Version</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="INCO2_L" type="String" size="70">
<description>Incoterms Location 1</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="INCO3_L" type="String" size="70">
<description>Incoterms Location 2</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="/BEV1/EMLGPFAND" type="String" size="1">
<description>Deposit on Empties</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="/BEV1/EMLGFORTS" type="String" size="1">
<description>Indicator for Empties Update</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_KVGR6" type="String" size="3">
<description>Customer Group 6</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_KVGR7" type="String" size="3">
<description>Customer Group 7</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_KVGR8" type="String" size="3">
<description>Customer Group 8</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_KVGR9" type="String" size="3">
<description>Customer Group 9</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_KVGR10" type="String" size="3">
<description>Customer Group 10</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_GRREG" type="String" size="4">
<description>Grouping Rule</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_RESGY" type="String" size="4">
<description>Release Strategy</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_SC_CID" type="String" size="2">
<description>Customer/Vendor ID</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_VAS_DETC" type="String" size="1">
<description>VAS Determination Mode</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_VAS_CG" type="String" size="3">
<description>Value-Added Services Customer Group</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_GRSGY" type="String" size="4">
<description>ARUN Grouping Strategy</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_SS" type="String" size="3">
<description>Order Scheduling Strategy</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_MSOCDC" type="String" size="10">
<description>Distribution Center of Customer</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FSH_MSOPID" type="String" size="20">
<description>Identification of the Customer in the Partner System</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ZDLV_NOTE_QTY" type="String" size="1">
<description>No. times Delivery Note to be output</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ZDLV_NO_OUTQTY" type="String" size="1">
<description>No output qty required</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ZDLV_NOTEP_QTY" type="String" size="1">
<description>No. times Delivery Note with Price to be output</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ZDLV_NO_OUTPQTY" type="String" size="1">
<description>No Output required for Price</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ZDLV_EAN_LABEL" type="String" size="1">
<description>EAN Label output required</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ZSD_LOB_CTRY" type="String" size="3">
<description>SD: Line Of Business</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>KNVV</name>
</referenced_object>
<referencing_field name="KUNNR" referenced_field="KUNNR" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
</table>
</schema>
</database>
</metadata>
KNA1,KNVV
<ActiveQueryBuilderLayout><SQL>Select Winshuttle.WinshuttleDD.KNA1.NAME1, Winshuttle.WinshuttleDD.KNA1.STRAS, Winshuttle.WinshuttleDD.KNA1.LOCCO, Winshuttle.WinshuttleDD.KNA1.NODEL, Winshuttle.WinshuttleDD.KNA1.NAME2, Winshuttle.WinshuttleDD.KNA1.ORT01, Winshuttle.WinshuttleDD.KNA1.REGIO, Winshuttle.WinshuttleDD.KNA1.PSTLZ, Winshuttle.WinshuttleDD.KNA1.LAND1, Winshuttle.WinshuttleDD.KNA1.TELF1 From Winshuttle.WinshuttleDD.KNA1 Inner Join Winshuttle.WinshuttleDD.KNVV On Winshuttle.WinshuttleDD.KNVV.KUNNR = Winshuttle.WinshuttleDD.KNA1.KUNNR</SQL><SubQueries><SubQuery SQL="Select Winshuttle.WinshuttleDD.KNA1.NAME1, Winshuttle.WinshuttleDD.KNA1.STRAS, Winshuttle.WinshuttleDD.KNA1.LOCCO, Winshuttle.WinshuttleDD.KNA1.NODEL, Winshuttle.WinshuttleDD.KNA1.NAME2, Winshuttle.WinshuttleDD.KNA1.ORT01, Winshuttle.WinshuttleDD.KNA1.REGIO, Winshuttle.WinshuttleDD.KNA1.PSTLZ, Winshuttle.WinshuttleDD.KNA1.LAND1, Winshuttle.WinshuttleDD.KNA1.TELF1 From Winshuttle.WinshuttleDD.KNA1 Inner Join Winshuttle.WinshuttleDD.KNVV On Winshuttle.WinshuttleDD.KNVV.KUNNR = Winshuttle.WinshuttleDD.KNA1.KUNNR"><UnionSubQuery><DataSource SQL="Winshuttle.WinshuttleDD.KNA1" X="20" Y="20" Width="350" Height="400" Collapsed="False" /><DataSource SQL="Winshuttle.WinshuttleDD.KNVV" X="390" Y="20" Width="350" Height="0" Collapsed="False" /></UnionSubQuery></SubQuery></SubQueries></ActiveQueryBuilderLayout>
Q03
200
KNMCGOWAN
knavis.mcgowan@abbott.com
2022-09-08T11:36:34.1147355-04:00
Query XD02 Export Location Code
ERP
Table
true
false
SELECT KNA1.NAME1,
KNA1.STRAS,
KNA1.LOCCO,
KNA1.NODEL,
KNA1.NAME2,
KNA1.ORT01,
KNA1.REGIO,
KNA1.PSTLZ,
KNA1.LAND1,
KNA1.TELF1
FROM KNA1
INNER JOIN KNVV ON KNVV.KUNNR = KNA1.KUNNR
KNA1,KNVV
0
false
Inner
false
false
false
false
false
true
false
false
true
0
0
false
false
true
false
false
false
false
C:\Users\MCGOWKX4\OneDrive - Abbott\Documents\Winshuttle Scripts\Query XD02 Export Location Code.xlsx
Sheet1
2
Excel
A1
TAB
TAB
ONPREMISE
false
UserDefinedRow
KNA1
KNA1
NAME1
Name 1
CHAR
String
35
false
QueryRow
false
NAME
false
C
0
false
None
false
false
UserDefinedRow
KNA1
KNA1
LOCCO
City Coordinates
CHAR
String
10
false
QueryRow
false
LOCCO
false
L
0
false
None
false
false
UserDefinedRow
KNA1
KNA1
STRAS
Street and House Number
CHAR
String
35
false
QueryRow
false
TEXT35
false
E
0
false
None
false
true
UserDefinedRow
KNVV
KNVV
KUNNR
Customer Number
CHAR
String
10
true
QueryRow
false
KUNNR
false
false
false
false
false
SapOptional
true
Cell
=
false
PrePadWithZeros
B2
Cell
true
UserDefinedRow
KNVV
KNVV
VKORG
Sales Organization
CHAR
String
4
true
QueryRow
false
VKORG
false
false
false
false
false
SapOptional
true
RunTime
=
false
PrePadWithZeros
1087
UserDefined
true
UserDefinedRow
KNVV
KNVV
VTWEG
Distribution Channel
CHAR
String
2
true
QueryRow
false
VTWEG
false
false
false
false
false
SapOptional
true
RunTime
=
false
PrePadWithZeros
10
UserDefined
true
UserDefinedRow
KNVV
KNVV
SPART
Division
CHAR
String
2
true
QueryRow
false
SPART
false
false
false
false
false
SapOptional
true
RunTime
=
false
PrePadWithZeros
10
UserDefined
false
UserDefinedRow
KNA1
KNA1
NODEL
Central deletion block for master record
CHAR
String
1
false
QueryRow
false
XFELD
false
K
0
false
None
false
false
UserDefinedRow
KNA1
KNA1
NAME2
Name 2
CHAR
String
35
false
QueryRow
false
NAME
false
D
0
false
None
false
false
UserDefinedRow
KNA1
KNA1
ORT01
City
CHAR
String
35
false
QueryRow
false
TEXT35
false
F
0
false
None
false
false
UserDefinedRow
KNA1
KNA1
REGIO
Region (State, Province, County)
CHAR
String
3
false
QueryRow
false
REGIO
false
G
0
false
None
false
false
UserDefinedRow
KNA1
KNA1
PSTLZ
Postal Code
CHAR
String
10
false
QueryRow
false
PSTLZ
false
H
0
false
None
false
false
UserDefinedRow
KNA1
KNA1
LAND1
Country Key
CHAR
String
3
false
QueryRow
false
LAND1
false
I
0
false
None
false
false
UserDefinedRow
KNA1
KNA1
TELF1
First telephone number
CHAR
String
16
false
QueryRow
false
TEXT16
false
J
0
false
None
false
KUNNR
10
KNA1
KNA1.KUNNR
KNVV.KUNNR
KUNNR
10
KNVV
Equal
Inner
MscuxXFarkOpWdI3y8CkF3EbgS8=