<?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="ADR6" alt_name="ADR6 (E-Mail Addresses (Business Address Services))">
<description>E-Mail Addresses (Business Address Services)</description>
<user_data>TRANSP</user_data>
<field name="CLIENT" primary_key="True" type="String" size="3" precision="3" scale="1">
<description>Client</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CLNT</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ADDRNUMBER" primary_key="True" type="String" size="10" precision="3">
<description>Address 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>ADRC</name>
</referenced_object>
<referencing_field name="ADDRNUMBER" referenced_field="ADDRNUMBER" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="PERSNUMBER" primary_key="True" type="String" size="10" precision="3">
<description>Person 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>ADRP</name>
</referenced_object>
<referencing_field name="PERSNUMBER" referenced_field="PERSNUMBER" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="DATE_FROM" primary_key="True" type="Date" size="10" precision="3" scale="1">
<description>Valid-from date - in current Release only 00010101 possible</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CONSNUMBER" primary_key="True" type="String" size="3" precision="3" scale="1">
<description>Sequence Number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FLGDEFAULT" type="String" size="1">
<description>Flag: this address is the default address</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FLG_NOUSE" type="String" size="1">
<description>Flag: This Communication Number is Not Used</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="HOME_FLAG" type="String" size="1">
<description>Recipient address in this communication type (mail sys.grp)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="SMTP_ADDR" type="String" size="241">
<description>E-Mail Address</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="SMTP_SRCH" primary_key="True" type="String" size="20" precision="2">
<description>E-Mail Address Search Field</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DFT_RECEIV" type="String" size="1">
<description>Flag: Recipient is standard recipient for this address</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="R3_USER" type="String" size="1">
<description>Flag: Connected to an SAP System</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ENCODE" type="String" size="1">
<description>Desired Data Coding (E-Mail)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TNEF" type="String" size="1">
<description>Flag: Receiver can receive TNEF coding via SMTP</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VALID_FROM" type="String" size="14">
<description>Communication Data: Valid From (YYYYMMDDHHMMSS)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VALID_TO" type="String" size="14">
<description>Communication Data: Valid To (YYYYMMDDHHMMSS)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
</table>
<table name="LFA1" alt_name="LFA1 (Vendor Master (General Section))">
<description>Vendor Master (General Section)</description>
<user_data>TRANSP</user_data>
<field name="LIFNR" primary_key="True" type="String" size="10" precision="3" scale="1">
<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="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="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="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="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="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>House number and street</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="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="DTAMS" type="String" size="1">
<description>Indicator 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="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="ESRNR" primary_key="True" type="String" size="11" precision="2">
<description>ISR Subscriber Number</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="KTOKK" type="String" size="4">
<description>Vendor account group</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KUNNR" type="String" size="10">
<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="LNRZA" type="String" size="10">
<description>Account Number of the Alternative Payee</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="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="SPERM" type="String" size="1">
<description>Centrally imposed purchasing 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="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="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="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="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="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="XZEMP" type="String" size="1">
<description>Indicator: Alternative payee in document allowed ?</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="FISKN" primary_key="True" type="String" size="10" precision="2">
<description>Account number of the master record with fiscal address</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="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="SPERQ" type="String" size="2">
<description>Function That Will Be Blocked</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="GBORT" type="String" size="25">
<description>Place of birth of the person subject to withholding tax</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="GBDAT" type="Date" size="10">
<description>Date of birth of the person subject to withholding tax</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="SEXKZ" type="String" size="1">
<description>Key for the Sex of the Person Subject to Withholding Tax</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KRAUS" type="String" size="11">
<description>Credit information number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="REVDB" type="Date" size="10">
<description>Last review (external)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="QSSYS" type="String" size="4">
<description>Vendor's QM system</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KTOCK" type="String" size="4">
<description>Reference Account Group for One-Time Account (Vendor)</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 (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="LTSNA" type="String" size="1">
<description>Indicator: vendor sub-range relevant</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="WERKR" type="String" size="1">
<description>Indicator: plant level relevant</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PLKAL" type="String" size="2">
<description>Factory calendar key</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="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="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="SCACD" type="String" size="4">
<description>Standard carrier access code</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="SFRGR" type="String" size="4">
<description>Forwarding agent freight group</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="XLFZA" type="String" size="1">
<description>Indicator: Alternative payee 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="DLGRP" type="String" size="4">
<description>Service agent procedure group</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="REGSS" type="String" size="1">
<description>Registered for Social Insurance</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ACTSS" type="String" size="3">
<description>Activity Code for Social Insurance</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="IPISP" type="String" size="1">
<description>Tax Split</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TAXBS" type="String" size="1">
<description>Tax Base in Percentage</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PROFS" type="String" size="30">
<description>Profession</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STGDL" type="String" size="2">
<description>Shipment: statistics group, transportation service agent</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="EMNFR" primary_key="True" type="String" size="10" precision="2">
<description>External manufacturer code name or number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LFURL" 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="QSSYSDAT" type="Date" size="10">
<description>Validity date of certification</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PODKZB" type="String" size="1">
<description>Vendor indicator relevant for proof of delivery</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FISKU" type="String" size="10">
<description>Account Number of Master Record of Tax Office Responsible</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STENR" type="String" size="18">
<description>Tax Number at Responsible Tax Authority</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CARRIER_CONF" type="String" size="1">
<description>Carrier confirmation is expected</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="MIN_COMP" type="String" size="1">
<description>Micro company indicator</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TERM_LI" type="String" size="1">
<description>Terms of Liability</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CRC_NUM" type="String" size="25">
<description>CRC number</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="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 Issue 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 Issue 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="J_SC_CAPITAL" type="Decimal" size="20">
<description>Capital Amount</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CURR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="J_SC_CURRENCY" 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="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="PPA_RELEVANT" type="String" size="1">
<description>Vendor is PPA relevant</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="TRANSPORT_CHAIN" type="String" size="10">
<description>Transportation Chain</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="STAGING_TIME" type="Decimal" size="3">
<description>Staging Time in Days</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DEC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="SCHEDULING_TYPE" type="String" size="1">
<description>Scheduling Procedure</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="SUBMI_RELEVANT" type="String" size="1">
<description>Cross Docking: Relevant for Collective Numbering</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
</table>
<table name="ADRT" alt_name="ADRT (Communication Data Text (Business Address Services))">
<description>Communication Data Text (Business Address Services)</description>
<user_data>TRANSP</user_data>
<field name="CLIENT" primary_key="True" type="String" size="3" precision="3" scale="1">
<description>Client</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CLNT</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ADDRNUMBER" primary_key="True" type="String" size="10" precision="3">
<description>Address 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>ADRC</name>
</referenced_object>
<referencing_field name="ADDRNUMBER" referenced_field="ADDRNUMBER" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="PERSNUMBER" primary_key="True" type="String" size="10" precision="3">
<description>Person 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>ADRP</name>
</referenced_object>
<referencing_field name="PERSNUMBER" referenced_field="PERSNUMBER" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="COMM_TYPE" primary_key="True" type="String" size="3" precision="3">
<description>Communication Method (Key) (Business Address Services)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>TSAC</name>
</referenced_object>
<referencing_field name="COMM_TYPE" referenced_field="COMM_TYPE" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="DATE_FROM" primary_key="True" type="Date" size="10" precision="3" scale="1">
<description>Valid-from date - in current Release only 00010101 possible</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CONSNUMBER" primary_key="True" type="String" size="3" precision="3" scale="1">
<description>Sequence Number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LANGU" primary_key="True" type="String" size="2" precision="3">
<description>Language Key</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>LANG</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>T002</name>
</referenced_object>
<referencing_field name="LANGU" referenced_field="SPRAS" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="REMARK" type="String" size="50">
<description>Communication link notes</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>ADR6</name>
</referenced_object>
<referencing_field name="CLIENT" referenced_field="CLIENT" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<foreignkey>
<referenced_object>
<name>ADR6</name>
</referenced_object>
<referencing_field name="DATE_FROM" referenced_field="DATE_FROM" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<foreignkey>
<referenced_object>
<name>ADR6</name>
</referenced_object>
<referencing_field name="CONSNUMBER" referenced_field="CONSNUMBER" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
</table>
</schema>
</database>
</metadata>
ADR6,LFA1,ADRT
<ActiveQueryBuilderLayout><SQL>Select Winshuttle.WinshuttleDD.ADR6.SMTP_ADDR, Winshuttle.WinshuttleDD.LFA1.LIFNR, Winshuttle.WinshuttleDD.ADR6.SMTP_SRCH, Winshuttle.WinshuttleDD.LFA1.NAME1, Winshuttle.WinshuttleDD.ADR6.CONSNUMBER, Winshuttle.WinshuttleDD.ADR6.CLIENT, Winshuttle.WinshuttleDD.ADR6.FLGDEFAULT, Winshuttle.WinshuttleDD.ADRT.REMARK From Winshuttle.WinshuttleDD.ADR6 Inner Join Winshuttle.WinshuttleDD.LFA1 On Winshuttle.WinshuttleDD.LFA1.ADRNR = Winshuttle.WinshuttleDD.ADR6.ADDRNUMBER Inner Join Winshuttle.WinshuttleDD.ADRT On Winshuttle.WinshuttleDD.ADRT.CLIENT = Winshuttle.WinshuttleDD.ADR6.CLIENT And Winshuttle.WinshuttleDD.ADRT.DATE_FROM = Winshuttle.WinshuttleDD.ADR6.DATE_FROM And Winshuttle.WinshuttleDD.ADRT.CONSNUMBER = Winshuttle.WinshuttleDD.ADR6.CONSNUMBER And Winshuttle.WinshuttleDD.ADR6.ADDRNUMBER = Winshuttle.WinshuttleDD.ADRT.ADDRNUMBER And Winshuttle.WinshuttleDD.ADR6.PERSNUMBER = Winshuttle.WinshuttleDD.ADRT.PERSNUMBER</SQL><SubQueries><SubQuery SQL="Select Winshuttle.WinshuttleDD.ADR6.SMTP_ADDR, Winshuttle.WinshuttleDD.LFA1.LIFNR, Winshuttle.WinshuttleDD.ADR6.SMTP_SRCH, Winshuttle.WinshuttleDD.LFA1.NAME1, Winshuttle.WinshuttleDD.ADR6.CONSNUMBER, Winshuttle.WinshuttleDD.ADR6.CLIENT, Winshuttle.WinshuttleDD.ADR6.FLGDEFAULT, Winshuttle.WinshuttleDD.ADRT.REMARK From Winshuttle.WinshuttleDD.ADR6 Inner Join Winshuttle.WinshuttleDD.LFA1 On Winshuttle.WinshuttleDD.LFA1.ADRNR = Winshuttle.WinshuttleDD.ADR6.ADDRNUMBER Inner Join Winshuttle.WinshuttleDD.ADRT On Winshuttle.WinshuttleDD.ADRT.CLIENT = Winshuttle.WinshuttleDD.ADR6.CLIENT And Winshuttle.WinshuttleDD.ADRT.DATE_FROM = Winshuttle.WinshuttleDD.ADR6.DATE_FROM And Winshuttle.WinshuttleDD.ADRT.CONSNUMBER = Winshuttle.WinshuttleDD.ADR6.CONSNUMBER And Winshuttle.WinshuttleDD.ADR6.ADDRNUMBER = Winshuttle.WinshuttleDD.ADRT.ADDRNUMBER And Winshuttle.WinshuttleDD.ADR6.PERSNUMBER = Winshuttle.WinshuttleDD.ADRT.PERSNUMBER"><UnionSubQuery><DataSource SQL="Winshuttle.WinshuttleDD.ADR6" X="3" Y="9" Width="646" Height="526" Collapsed="False" /><DataSource SQL="Winshuttle.WinshuttleDD.LFA1" X="658" Y="8" Width="439" Height="528" Collapsed="False" /><DataSource SQL="Winshuttle.WinshuttleDD.ADRT" X="1110" Y="4" Width="350" Height="399" Collapsed="False" /></UnionSubQuery></SubQuery></SubQueries></ActiveQueryBuilderLayout>
QAS
401
JKE
jan.ketele@flintgrp.com
2023-02-17T10:27:17.4443511+01:00
Table
ERP
Table
true
false
SELECT ADR6.SMTP_ADDR,
LFA1.LIFNR,
ADR6.SMTP_SRCH,
LFA1.NAME1,
ADR6.CONSNUMBER,
ADR6.CLIENT,
ADR6.FLGDEFAULT,
ADRT.REMARK
FROM ADR6
INNER JOIN LFA1 ON LFA1.ADRNR = ADR6.ADDRNUMBER
INNER JOIN ADRT ON (ADRT.CLIENT = ADR6.CLIENT) AND (ADRT.DATE_FROM =
ADR6.DATE_FROM) AND (ADRT.CONSNUMBER = ADR6.CONSNUMBER) AND
(ADR6.ADDRNUMBER = ADRT.ADDRNUMBER) AND (ADR6.PERSNUMBER = ADRT.PERSNUMBER)
ADR6,LFA1,ADRT
0
false
Inner
false
false
false
false
false
true
false
false
false
0
0
false
false
true
false
false
false
false
\\Xeikon05\IQA\RM\Winshuttle\productie\Data\32-QUERY-WRITE_Vendor-mail\query LFA1-ADR6 mailadres vendor.xlsx
Sheet2
2
Excel
O1
TAB
TAB
ONPREMISE
false
UserDefinedRow
ADR6
ADR6
SMTP_ADDR
E-Mail Address
CHAR
String
241
false
QueryRow
false
AD_SMTPADR
false
F
0
false
None
false
true
UserDefinedRow
LFA1
LFA1
LIFNR
Account Number of Vendor or Creditor
CHAR
String
10
true
QueryRow
false
LIFNR
false
B
0
false
None
false
false
false
false
false
None
false
RunTime
In
false
PrePadWithZeros
FileValue
Excel
Sheet1
A
2
0
true
true
true
false
UserDefinedRow
ADR6
ADR6
SMTP_SRCH
E-Mail Address Search Field
CHAR
String
20
false
QueryRow
false
CHAR20
false
E
0
false
None
false
false
UserDefinedRow
LFA1
LFA1
NAME1
Name 1
CHAR
String
35
false
QueryRow
false
NAME
false
C
0
false
None
false
false
UserDefinedRow
ADR6
ADR6
CONSNUMBER
Sequence Number
NUMC
String
3
true
QueryRow
false
NUMC3
false
G
0
false
None
false
false
UserDefinedRow
ADR6
ADR6
CLIENT
Client
CLNT
String
3
true
QueryRow
false
MANDT
false
D
0
false
None
false
false
UserDefinedRow
ADR6
ADR6
FLGDEFAULT
Flag: this address is the default address
CHAR
String
1
false
QueryRow
false
XFELD
false
H
0
false
None
false
false
UserDefinedRow
ADRT
ADRT
REMARK
Communication link notes
CHAR
String
50
false
QueryRow
false
TEXT50
false
I
0
false
None
false
ADDRNUMBER
10
ADR6
ADR6.ADDRNUMBER
LFA1.ADRNR
ADRNR
10
LFA1
Equal
Inner
CLIENT
3
ADR6
ADR6.CLIENT
ADRT.CLIENT
CLIENT
3
ADRT
Equal
Inner
DATE_FROM
10
ADR6
ADR6.DATE_FROM
ADRT.DATE_FROM
DATE_FROM
10
ADRT
Equal
Inner
CONSNUMBER
3
ADR6
ADR6.CONSNUMBER
ADRT.CONSNUMBER
CONSNUMBER
3
ADRT
Equal
Inner
ADDRNUMBER
10
ADR6
ADR6.ADDRNUMBER
ADRT.ADDRNUMBER
ADDRNUMBER
10
ADRT
Equal
Inner
PERSNUMBER
10
ADR6
ADR6.PERSNUMBER
ADRT.PERSNUMBER
PERSNUMBER
10
ADRT
Equal
Inner
KtFfEePm5h0xr4G0scoqZCY0aak=