<?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>
</schema>
</database>
</metadata>
ADR6
<ActiveQueryBuilderLayout><SQL>Select Winshuttle.WinshuttleDD.ADR6.ADDRNUMBER, Winshuttle.WinshuttleDD.ADR6.PERSNUMBER, Winshuttle.WinshuttleDD.ADR6.FLGDEFAULT, Winshuttle.WinshuttleDD.ADR6.FLG_NOUSE, Winshuttle.WinshuttleDD.ADR6.HOME_FLAG, Winshuttle.WinshuttleDD.ADR6.SMTP_ADDR, Winshuttle.WinshuttleDD.ADR6.VALID_FROM, Winshuttle.WinshuttleDD.ADR6.VALID_TO From Winshuttle.WinshuttleDD.ADR6</SQL><SubQueries><SubQuery SQL="Select Winshuttle.WinshuttleDD.ADR6.ADDRNUMBER, Winshuttle.WinshuttleDD.ADR6.PERSNUMBER, Winshuttle.WinshuttleDD.ADR6.FLGDEFAULT, Winshuttle.WinshuttleDD.ADR6.FLG_NOUSE, Winshuttle.WinshuttleDD.ADR6.HOME_FLAG, Winshuttle.WinshuttleDD.ADR6.SMTP_ADDR, Winshuttle.WinshuttleDD.ADR6.VALID_FROM, Winshuttle.WinshuttleDD.ADR6.VALID_TO From Winshuttle.WinshuttleDD.ADR6"><UnionSubQuery><DataSource SQL="Winshuttle.WinshuttleDD.ADR6" X="20" Y="20" Width="350" Height="400" Collapsed="False" /></UnionSubQuery></SubQuery></SubQueries></ActiveQueryBuilderLayout>
WE6
800
mscroggs
maria.simpson@winshuttle.com
2022-08-23T08:27:02.4324542-07:00
Table
ERP
Table
true
true
SELECT ADR6.ADDRNUMBER,
ADR6.PERSNUMBER,
ADR6.FLGDEFAULT,
ADR6.FLG_NOUSE,
ADR6.HOME_FLAG,
ADR6.SMTP_ADDR,
ADR6.VALID_FROM,
ADR6.VALID_TO
FROM ADR6
ADR6
0
false
None
false
false
false
false
false
true
false
false
true
0
0
false
false
true
false
false
false
false
C:\Users\msimpson\Desktop\ADR6.xlsx
Sheet1
2
Excel
J1
TAB
TAB
ONPREMISE
true
UserDefinedRow
ADR6
ADR6
ADDRNUMBER
Address number
CHAR
String
10
true
QueryRow
false
AD_ADDRNUM
false
B
0
false
None
false
false
false
false
false
None
false
Fixed
In
false
PrePadWithZeros
FileValue
Excel
Sheet1
A
1
0
true
true
true
false
UserDefinedRow
ADR6
ADR6
PERSNUMBER
Person number
CHAR
String
10
true
QueryRow
false
AD_PERSNUM
false
C
0
false
None
false
false
UserDefinedRow
ADR6
ADR6
FLGDEFAULT
Flag: this address is the default address
CHAR
String
1
false
QueryRow
false
XFELD
false
D
0
false
None
false
false
UserDefinedRow
ADR6
ADR6
FLG_NOUSE
Flag: This Communication Number is Not Used
CHAR
String
1
false
QueryRow
false
XFELD
false
E
0
false
None
false
false
UserDefinedRow
ADR6
ADR6
HOME_FLAG
Recipient address in this communication type (mail sys.grp)
CHAR
String
1
false
QueryRow
false
XFELD
false
F
0
false
None
false
false
UserDefinedRow
ADR6
ADR6
SMTP_ADDR
E-Mail Address
CHAR
String
241
false
QueryRow
false
AD_SMTPADR
false
G
0
false
None
false
false
UserDefinedRow
ADR6
ADR6
VALID_FROM
Communication Data: Valid From (YYYYMMDDHHMMSS)
CHAR
String
14
false
QueryRow
false
TIMESTMP
false
H
0
false
None
false
false
UserDefinedRow
ADR6
ADR6
VALID_TO
Communication Data: Valid To (YYYYMMDDHHMMSS)
CHAR
String
14
false
QueryRow
false
TIMESTAMP
false
I
0
false
None
false
uFmigE+ZuzE09RxvKztdg4f5de8=