<?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="JEST" alt_name="JEST (Individual Object Status)"> <description>Individual Object Status</description> <user_data>TRANSP</user_data> <field name="OBJNR" primary_key="True" type="String" size="22" precision="3"> <description>Object number</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <foreignkey> <referenced_object> <name>ONR00</name> </referenced_object> <referencing_field name="OBJNR" referenced_field="OBJNR" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> <field name="STAT" primary_key="True" type="String" size="5" precision="3" scale="1"> <description>Object status</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="INACT" primary_key="True" type="String" size="1" precision="2"> <description>Indicator: Status Is Inactive</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="CHGNR" type="String" size="3"> <description>Change number</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;NUMC&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="_DATAAGING" type="Date" size="10"> <description>Data Filter Value for Data Aging</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;DATS&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> </table> <table name="TJ02T" alt_name="TJ02T (System status texts)"> <description>System status texts</description> <user_data>TRANSP</user_data> <field name="ISTAT" primary_key="True" type="String" size="5" precision="3"> <description>System status</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <foreignkey> <referenced_object> <name>TJ02</name> </referenced_object> <referencing_field name="ISTAT" referenced_field="ISTAT" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> <field name="SPRAS" primary_key="True" type="String" size="2" precision="3"> <description>Language Key</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;LANG&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <foreignkey> <referenced_object> <name>T002</name> </referenced_object> <referencing_field name="SPRAS" referenced_field="SPRAS" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> <field name="TXT04" primary_key="True" type="String" size="4" precision="2"> <description>Individual status of an object (short form)</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="TXT30" type="String" size="30"> <description>Object status</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> </table> </schema> </database> </metadata> JEST,TJ02T <ActiveQueryBuilderLayout><SQL>Select Winshuttle.WinshuttleDD.JEST.OBJNR, Winshuttle.WinshuttleDD.TJ02T.TXT04, Winshuttle.WinshuttleDD.TJ02T.TXT30 From Winshuttle.WinshuttleDD.JEST Inner Join Winshuttle.WinshuttleDD.TJ02T On Winshuttle.WinshuttleDD.JEST.STAT = Winshuttle.WinshuttleDD.TJ02T.ISTAT</SQL><SubQueries><SubQuery SQL="Select Winshuttle.WinshuttleDD.JEST.OBJNR, Winshuttle.WinshuttleDD.TJ02T.TXT04, Winshuttle.WinshuttleDD.TJ02T.TXT30 From Winshuttle.WinshuttleDD.JEST Inner Join Winshuttle.WinshuttleDD.TJ02T On Winshuttle.WinshuttleDD.JEST.STAT = Winshuttle.WinshuttleDD.TJ02T.ISTAT"><UnionSubQuery><DataSource SQL="Winshuttle.WinshuttleDD.JEST" X="20" Y="20" Width="724" Height="400" Collapsed="False" /><DataSource SQL="Winshuttle.WinshuttleDD.TJ02T" X="764" Y="20" Width="350" Height="400" Collapsed="False" /></UnionSubQuery></SubQuery></SubQueries></ActiveQueryBuilderLayout>
EPA 150 bkielas ben.kielas@generac.com 2023-03-15T10:52:31.1783618-05:00 Table ERP Table
false SELECT JEST.OBJNR, TJ02T.TXT04, TJ02T.TXT30 FROM JEST INNER JOIN TJ02T ON JEST.STAT = TJ02T.ISTAT JEST,TJ02T 0 false Inner false false false true false true false false true 25000 0 false false true false false false false T:\Application Systems\Winshuttle\Studio\Data\SR-553597 UPDATE ORDER DATES.xlsx STEP 2 2 Excel D1 TAB TAB ONPREMISE true true UserDefinedRow JEST JEST OBJNR Object number CHAR String 22 true QueryRow false J_OBJNR false A 0 =TRIM(A2) =TRIM(A2) AA2 false None true false false false false None false RunTime In false PrePadWithZeros FileValue Excel STEP 1 A 2 0 true true true false true UserDefinedRow JEST JEST INACT Indicator: Status Is Inactive CHAR String 1 false QueryRow false false false false false false None false Fixed Is Null false PrePadWithZeros UserDefined true true UserDefinedRow TJ02T TJ02T TXT04 Individual status of an object (short form) CHAR String 4 false QueryRow false TEXT4 false B 0 false None false false false false false SapOptional false RunTime = false Or PrePadWithZeros REL UserDefined SapOptional false RunTime = false And PrePadWithZeros CRTD UserDefined SapOptional false RunTime = true PrePadWithZeros DLV UserDefined false true UserDefinedRow TJ02T TJ02T SPRAS Language Key LANG String 2 true QueryRow false SPRAS false false false false false SapOptional false RunTime = false PrePadWithZeros E UserDefined true false UserDefinedRow TJ02T TJ02T TXT30 Object status CHAR String 30 false QueryRow false TEXT30 false C 0 false None false STAT 5 JEST JEST.STAT TJ02T.ISTAT ISTAT 5 TJ02T Equal Inner 2EtImU3RexxFEunijraaZld09mk=