Added in the T1.ResDelivery and am getting the error Incorrect Syntax near keyword ‘as’ I am thinking this is because it needs to be capitalized?? Here is the query.
SELECT
T1.RptLanguageID,
T1.CardNumber,
T1.NeedByDate,
T1.OrderComment,
T1.OrderDate,
T1.OrderNum,
T1.PONum,
T1.ResDelivery,
T1.Calc_BillToAddressList,
T1.Calc_BillToContact,
T1.Calc_CardNumber,
T1.Calc_CustPartOpts,
T1.Calc_FobDesc,
T1.Calc_MultiNeedDate,
T1.Calc_MultiRef,
T1.Calc_MultiShipContacts,
T1.Calc_MultiShipTo,
T1.Calc_MultiShipVia,
T1.Calc_PrcEmail,
T1.Calc_PrcFax,
T1.Calc_PrcPhone,
T1.Calc_SalesPerson,
T1.Calc_ShipToAddressList,
T1.Calc_ShipToContact,
T1.Calc_ShipToEmail,
T1.Calc_ShipToFax,
T1.Calc_ShipToPhone,
T1.Calc_ShipViaDesc,
T1.Calc_TermsDesc,
T1.CurrencyCode_CurrDesc,
T1.CurrencyCode_CurrSymbol,
T1.Customer_ResaleID,
T1.PayFlag,
T1.PayAccount,
T1.Customer_CustID,
T1.Customer_SamplesOnAll_c,
T1.Customer_SamplesOnNew_c,
T1.EntryPerson,
T1.ShipToNum,
T2.Company,
T2.ContractNum,
T2.DisplaySeq,
T2.DocDiscount,
T2.DocUnitPrice,
T2.KitFlag,
T2.KitPricing,
T2.KitPrintCompsInv,
T2.KitShipComplete,
T2.OrderComment AS OrderDtl_OrderComment,
T2.OrderLine,
T2.PartNum,
T2.POLine,
T2.PricePerCode,
T2.Reference,
T2.RevisionNum,
T2.SalesUM,
T2.SellingQuantity,
T2.WarrantyComment,
T2.XPartNum,
T2.XRevisionNum,
T2.Calc_ExtPrice,
T2.Calc_LineDesc,
T2.PartNum_PartDescription,
T2.WarrantyCode_WarrDescription,
T2.Calc_UOMForeignDesc,
T3.NeedByDate AS OrderRel_NeedByDate,
T3.OrderRelNum,
T3.Reference AS OrderRel_Reference,
T3.ReqDate,
T3.SellingReqQty,
T3.ShipViaCode,
T3.Calc_ResaleID,
T3.Calc_ShipToAddressList AS OrderRel_Calc_ShipToAddressList,
T3.Calc_ShipToContact AS OrderRel_Calc_ShipToContact,
T3.ShipViaCode_Description,
T3.ShipToNum AS OrderRel_ShipToNum,
T4.Calc_ExtPrice AS RptLiteralsCalc_ExtPrice,
T4.Calc_OrderTotal AS RptLiteralsCalc_OrderTotal,
T4.Calc_SalesPerson AS RptLiteralsCalc_SalesPerson,
T4.Calc_ShipToContact AS RptLiteralsCalc_ShipToContact,
T4.RptLiteralsDiscount,
T4.FaxNum AS RptLiteralsFaxNum,
T4.FOB AS RptLiteralsFOB,
T4.NeedByDate AS RptLiteralsNeedByDate,
T4.OrderDate AS RptLiteralsOrderDate,
T4.RptLiteralsLLine,
T4.OrderQty AS RptLiteralsOrderQty,
T4.OrderRelNum AS RptLiteralsOrderRelNum,
T4.PhoneNum AS RptLiteralsPhoneNum,
T4.Reference AS RptLiteralsReference,
T4.ResaleID AS RptLiteralsResaleID,
T4.RevisionNum AS RptLiteralsRevisionNum,
T4.RptLiteralsLCrdNum,
T4.RptLiteralsLCustPart,
T4.RptLiteralsLDate,
T4.RptLiteralsLEmail,
T4.RptLiteralsLFax,
T4.RptLiteralsLPhone,
T4.RptLiteralsLLNMSC,
T4.RptLiteralsLOrderAck,
T4.RptLiteralsLORMSC,
T4.RptLiteralsLORNUM,
T4.RptLiteralsLOurPart,
T4.RptLiteralsLPage,
T4.RptLiteralsLPONum,
T4.RptLiteralsLPriPer,
T4.RptLiteralsLPrtDes,
T4.RptLiteralsLQty,
T4.RptLiteralsLShipTo,
T4.RptLiteralsLSHSHC,
T4.RptLiteralsLSHSHM,
T4.RptLiteralsLSLSHE,
T4.RptLiteralsLSoldTo,
T4.RptLiteralsLSubTotal,
T4.RptLiteralsLTerms,
T4.RptLiteralsLYURPOLN,
T4.RptLiteralsSalesKit,
T4.UnitPrice AS RptLiteralsUnitPrice,
T4.Warranty AS RptLiteralsWarranty,
T4.ShipViaCode AS RptLiteralsShipViaCode,
T4.OrderLine AS RptLiteralsOrderLine,
T1.[AGUseGoodDefaultMark],
T1.[ccToken],
T1.[ChangedBy],
T1.[CounterSOAck],
T1.[DispatchReason],
T1.[ECCOrderNum],
T1.[ECCPaymentMethod],
T1.[ECCPONum],
T1.[FOB],
T1.[InvcOrderCmp],
T1.[IsCSRSet],
T1.[OrderCSR],
T1.[OTSShipToNum],
T1.[Plant],
T1.[ProFormaInvComment],
T1.[ReadyToFulfill],
T1.[ReprintSOAck],
T1.[ShipByTime],
T1.[WIApplication],
T1.[WICreditCardorder],
T1.[WIOrder],
T1.[WIUserID],
T1.[WIUsername],
T1.[BlindShip_c],
T1.[Calc_BTAddressList],
T1.[Calc_CarrierDesc],
T1.[Calc_CarrierSCAC],
T1.[Calc_CurrSymbol],
T1.[Calc_CustAddrList],
T1.[Calc_LineMiscTotal],
T1.[Calc_MiscTotal],
T1.[Calc_MultiRel],
T1.[Calc_OrderTotal],
T1.[Calc_RepRate],
T1.[Calc_SoldToBillToSameFlag],
T1.[Calc_SubTotal],
T1.[CardType_Description],
T1.[CurrencyCode_CurrName],
T1.[CurrencyCode_DocumentDesc],
T1.[Customer_BTName],
T1.[Customer_EMailAddress],
T1.[Customer_FaxNum],
T1.[Customer_Name],
T1.[Customer_PhoneNum],
T1.[Customer_TradingPartnerName],
T1.[FOB_Description],
T1.[ShipViaCode_WebDesc],
T1.[TermsCode_Description],
T2.[ChangeDate],
T2.[ChangeTime],
T2.[ContractID],
T2.[CreateJob],
T2.[CustNum],
T2.[DefaultOversPricing],
T2.[DemandContractLine],
T2.[DemandContractNum],
T2.[DemandDtlSeq],
T2.[DemandHeadSeq],
T2.[DiscBreakListCode],
T2.[DiscListPrice],
T2.[DocExtPriceDtl],
T2.[DocInAdvanceBillBal],
T2.[DocInDiscount],
T2.[DocInExtPriceDtl],
T2.[DocInListPrice],
T2.[DocInOrdBasedPrice],
T2.[DocInUnitPrice],
T2.[DoNotShipAfterDate],
T2.[DoNotShipBeforeDate],
T2.[DupOnJobCrt],
T2.[ECCOrderLine],
T2.[ECCPlant],
T2.[ECCQuoteLine],
T2.[ECCQuoteNum],
T2.[ExtPriceDtl],
T2.[GroupSeq],
T2.[InAdvanceBillBal],
T2.[InDiscount],
T2.[InExtPriceDtl],
T2.[InListPrice],
T2.[InOrdBasedPrice],
T2.[InUnitPrice],
T2.[KitCompOrigPart],
T2.[KitCompOrigSeq],
T2.[KitParentLine],
T2.[KitPrintCompsPS],
T2.[KitQtyPer],
T2.[LineStatus],
T2.[LinkToContract],
T2.[LockDisc],
T2.[MfgJobType],
T2.[MOMsourceEst],
T2.[MOMsourceType],
T2.[OldOpenValue],
T2.[OldOurOpenQty],
T2.[OldProdCode],
T2.[OldSellingOpenQty],
T2.[OpenLine],
T2.[OrderQty],
T2.[OverrideDiscPriceList],
T2.[Overs],
T2.[OversUnitPrice],
T2.[PCLinkRemoved],
T2.[PlanGUID],
T2.[PlanUserID],
T2.[PrevPartNum],
T2.[PrevSellQty],
T2.[PrevXPartNum],
T2.[RenewalNbr],
T2.[ReverseCharge],
T2.[Rpt1AdvanceBillBal],
T2.[Rpt1Discount],
T2.[Rpt1ExtPriceDtl],
T2.[Rpt1InAdvanceBillBal],
T2.[Rpt1InDiscount],
T2.[Rpt1InExtPriceDtl],
T2.[Rpt1InListPrice],
T2.[Rpt1InOrdBasedPrice],
T2.[Rpt1InUnitPrice],
T2.[Rpt1ListPrice],
T2.[Rpt1OrdBasedPrice],
T2.[Rpt1UnitPrice],
T2.[Rpt2AdvanceBillBal],
T2.[Rpt2Discount],
T2.[Rpt2ExtPriceDtl],
T2.[Rpt2InAdvanceBillBal],
T2.[Rpt2InDiscount],
T2.[Rpt2InExtPriceDtl],
T2.[Rpt2InListPrice],
T2.[Rpt2InOrdBasedPrice],
T2.[Rpt2InUnitPrice],
T2.[Rpt2ListPrice],
T2.[Rpt2OrdBasedPrice],
T2.[Rpt2UnitPrice],
T2.[Rpt3AdvanceBillBal],
T2.[Rpt3Discount],
T2.[Rpt3ExtPriceDtl],
T2.[Rpt3InAdvanceBillBal],
T2.[Rpt3InDiscount],
T2.[Rpt3InExtPriceDtl],
T2.[Rpt3InListPrice],
T2.[Rpt3InOrdBasedPrice],
T2.[Rpt3InUnitPrice],
T2.[Rpt3ListPrice],
T2.[Rpt3OrdBasedPrice],
T2.[Rpt3UnitPrice],
T2.[SellingFactorDirection],
T2.[SmartString],
T2.[SmartStringProcessed],
T2.[TotalReleases],
T2.[Unders],
T2.[UndersPct],
T2.[UnitPrice],
T2.[Warranty],
T2.[WarrantyCode],
T2.[JobCode_c],
T2.[JobID_c],
T2.[OrderDate_c],
T2.[OverUnder_c],
T2.[PriceLockBy_c],
T2.[PriceLockNotes_c],
T2.[PriceLockReason_c],
T2.[Shape_c],
T2.[Size_c],
T2.[Calc_Duration],
T2.[Calc_LabDur],
T2.[Calc_LabMod],
T2.[Calc_Labor],
T2.[Calc_MatDur],
T2.[Calc_Mate],
T2.[Calc_MatMod],
T2.[Calc_Misc],
T2.[Calc_MiscDur],
T2.[Calc_MiscMod],
T2.[Calc_Modifier],
T2.[Calc_POLine],
T2.[Calc_PrevPartNum],
T2.[Calc_PrevSellQty],
T2.[Calc_PrevXPartNum],
T2.[Calc_WarrComment],
T2.[Calc_WarrDesc],
T2.[ContractCode_ContractDescription],
T2.[MktgCampaignID_CampDescription],
T2.[MktgEvnt_EvntDescription],
T2.[OrderNum_CardMemberName],
T2.[OrderNum_CurrencyCode],
T2.[PartNum_MfgComment],
T2.[PartNum_PurComment],
T2.[PartNum_TrackDimension],
T2.[PartNum_TrackLots],
T2.[PartNum_TrackSerialNum],
T2.[ProdCode_Description],
T2.[ProjectID_Description],
T2.[QuoteNum_CurrencyCode],
T2.[SalesCatID_Description],
T2.[SalesUM_UOMSymbol],
T2.[TaxCatID_Description],
T3.[ApplyChrg],
T3.[BuyToOrder],
T3.[ChrgAmount],
T3.[COD],
T3.[CODAmount],
T3.[CODCheck],
T3.[CODFreight],
T3.[ComplianceMsg],
T3.[DeclaredAmt],
T3.[DeclaredIns],
T3.[DeliveryType],
T3.[DemandReference],
T3.[DockingStation],
T3.[DocOnly],
T3.[DropShip],
T3.[DropShipName],
T3.[EntityUseCode],
T3.[GetDfltTaxIds],
T3.[GroundType],
T3.[Hazmat],
T3.[IUM],
T3.[LineType],
T3.[Location],
T3.[MarkForNum],
T3.[MFCustNum],
T3.[NotifyEMail],
T3.[NotifyFlag],
T3.[OpenOrder],
T3.[OTMFAddress1],
T3.[OTMFAddress2],
T3.[OTMFAddress3],
T3.[OTMFCity],
T3.[OTMFContact],
T3.[OTMFCountryNum],
T3.[OTMFFaxNum],
T3.[OTMFName],
T3.[OTMFPhoneNum],
T3.[OTMFState],
T3.[OTMFZIP],
T3.[OTSAddress1],
T3.[OTSAddress2],
T3.[OTSAddress3],
T3.[OTSCity],
T3.[OTSContact],
T3.[OTSCountryNum],
T3.[OTSCustSaved],
T3.[OTSFaxNum],
T3.[OTSName],
T3.[OTSPhoneNum],
T3.[OTSResaleID],
T3.[OTSSaveAs],
T3.[OTSSaveCustID],
T3.[OTSState],
T3.[OTSZIP],
T3.[OverrideCarrier],
T3.[OverrideService],
T3.[PhaseID],
T3.[PORelNum],
T3.[PrevNeedByDate],
T3.[PrevReqDate],
T3.[PrevShipToNum],
T3.[PurPoint],
T3.[RAN],
T3.[RefNotes],
T3.[RelStatus],
T3.[SatDelivery],
T3.[SatPickup],
T3.[ScheduleNumber],
T3.[ServAlert],
T3.[ServAOD],
T3.[ServAuthNum],
T3.[ServDeliveryDate],
T3.[ServHomeDel],
T3.[ServInstruct],
T3.[ServPhone],
T3.[ServPOD],
T3.[ServRelease],
T3.[ServSatDelivery],
T3.[ServSatPickup],
T3.[ServSignature],
T3.[ShipOvers],
T3.[ShipRouting],
T3.[ShipToCustNum],
T3.[ShpConNum],
T3.[SubShipTo],
T3.[TaxConnectCalc],
T3.[TaxExempt],
T3.[TaxRegionCode],
T3.[TransportID],
T3.[UseOTMF],
T3.[UseOTS],
T3.[VendorNum],
T3.[VerbalConf],
T3.[WasRecInvoiced],
T3.[WebSKU],
T3.[WIItemPrice],
T3.[WIItemShipCost],
T3.[WIOrderLine],
T3.[Calc_OrderRelCounter],
T3.[Calc_PrevNeedByDate],
T3.[Calc_PrevReqDate],
T3.[Calc_PrevSellReqQty],
T3.[Calc_PrevShipToNum],
T3.[Calc_TaxCodes],
T3.[Plant_Name],
T3.[WarehouseCode_Description],
T5.[ChangeTrackAmount],
T5.[ChangeTrackApproved],
T5.[ChangeTrackMemoDesc],
T5.[ChangeTrackMemoText],
T5.[ChangeTrackStatus],
T5.[DocMiscAmt],
T5.[FreqCode],
T5.[MiscCode],
T5.[SeqNum],
T5.[Calc_ChargeDesc],
T5.[Calc_NumRels],
T5.[Calc_SalesAnalysis],
T6.[Description],
T6.[DocInMiscAmt],
T6.[ExtCompany],
T6.[InMiscAmt],
T6.[MiscAmt],
T6.[Percentage],
T6.[Rpt1InMiscAmt],
T6.[Rpt1MiscAmt],
T6.[Rpt2InMiscAmt],
T6.[Rpt2MiscAmt],
T6.[Rpt3InMiscAmt],
T6.[Rpt3MiscAmt],
T6.[Type],
T6.[MiscCode_Description],
T7.[BillEndDate],
T7.[BillStartDate],
T7.[ContractLine],
T7.[ContractQty],
T7.[DateInactivated],
T7.[DateInvoiced],
T7.[DocPricePerUnit],
T7.[Inactive],
T7.[Invoiced],
T7.[Rpt1PricePerUnit],
T7.[Rpt2PricePerUnit],
T7.[Rpt3PricePerUnit],
T7.[Calc_OrderLine],
T7.[Calc_OrderNum],
T1.[CCCity],
T1.[CCState],
T1.[ClosedNotShipped],
T1.[InvCurrDepositBal],
T1.[OrderOpenCredit],
T1.[PLArticle106c],
T1.[PLEnforcementAuthAddr],
T1.[PLEnforcementAuthName],
T1.[PLGoodsOrServiceVATExempt],
T1.[PLInvIssuedBySecondTaxpayer],
T1.[PLInvIssuedByTaxpayer],
T1.[PLLegalArticleAct],
T1.[PLLegalArticleOther],
T1.[PLLegalArticleWEDirective],
T1.[PLMarginScheme],
T1.[PLSecondHandOrArts],
T1.[PLTaxRepresentativeAddr],
T1.[PLTaxRepresentativeName],
T1.[PLTaxRepresentativeTaxID],
T1.[PLTouristService],
T1.[TWFiscalPeriod],
T1.[TWFiscalYear],
T1.[TWFiscalYearSuffix],
T1.[TWGUIGroup],
T1.[TWGUIRegNumBuyer],
T1.[TWGUIRegNumSeller],
T2.[CommodityCode],
T2.[DocEndCustomerPrice],
T2.[DocMSRP],
T2.[EndCustomerPrice],
T2.[MSRP],
T2.[Rpt1EndCustomerPrice],
T2.[Rpt1MSRP],
T2.[Rpt2EndCustomerPrice],
T2.[Rpt2MSRP],
T2.[Rpt3EndCustomerPrice],
T2.[Rpt3MSRP],
T4.[DecimalsGeneral] as RptLabelsDecimalsGeneral,
T4.[DecimalsPrice] as RptLabelsDecimalsPrice,
T4.[DecimalsCost] as RptLabelsDecimalsCost,
T4.[GlbDecimalsGeneral] as RptLabelsGlbDecimalsGeneral,
T4.[GlbDecimalsPrice] as RptLabelsGlbDecimalsPrice,
T4.[GlbDecimalsCost] as RptLabelsGlbDecimalsCost,
T4.[RptLiteralsPage],
T4.[RptLiteralsTime],
T4.[RptLiteralsUser],
T4.[RptLiteralsDate],
T4.[RptLiteralsComponentPrice],
T4.[RptLiteralsCompPrice],
T4.[RptLiteralsLBLQT],
T4.[RptLiteralsLCarrier],
T4.[RptLiteralsLCarrierSCAC],
T4.[RptLiteralsLComp],
T4.[RptLiteralsLComponents],
T4.[RptLiteralsLCont],
T4.[RptLiteralsLKit],
T4.[RptLiteralsLKitComponents],
T4.[RptLiteralsLKitHeading],
T4.[RptLiteralsLKits],
T4.[RptLiteralsLKitSeq],
T4.[RptLiteralsLMSCTot],
T4.[RptLiteralsLOrderLine],
T4.[RptLiteralsLOrderLn],
T4.[RptLiteralsLOrdQty],
T4.[RptLiteralsLParent],
T4.[RptLiteralsLQPParent],
T4.[RptLiteralsLQtyPer],
T4.[RptLiteralsLRounding],
T4.[RptLiteralsSeeBelow],
T4.[Address1] as RptLabelsAddress1,
T4.[Address2] as RptLabelsAddress2,
T4.[Address3] as RptLabelsAddress3,
T4.[APBOECheck] as RptLabelsAPBOECheck,
T4.[City] as RptLabelsCity,
T4.[Company] as RptLabelsCompany,
T4.[COSequenceCert] as RptLabelsCOSequenceCert,
T4.[Country] as RptLabelsCountry,
T4.[DeepCopy] as RptLabelsDeepCopy,
T4.[DeepCopyDupOrRevEst] as RptLabelsDeepCopyDupOrRevEst,
T4.[EpicorAccountNum] as RptLabelsEpicorAccountNum,
T4.[FaxNum] as RptLabelsFaxNum,
T4.[MapURL] as RptLabelsMapURL,
T4.[MXMunicipio] as RptLabelsMXMunicipio,
T4.[Name] as RptLabelsName,
T4.[PhoneNum] as RptLabelsPhoneNum,
T4.[SendToFSA] as RptLabelsSendToFSA,
T4.[State] as RptLabelsState,
T4.[WIApplication] as RptLabelsWIApplication,
T4.[WIAutoCreateJob] as RptLabelsWIAutoCreateJob,
T4.[WIGetDetails] as RptLabelsWIGetDetails,
T4.[WIRelease] as RptLabelsWIRelease,
T4.[WISchedule] as RptLabelsWISchedule,
T4.[WIShippingCosts] as RptLabelsWIShippingCosts,
T4.[Zip] as RptLabelsZip,
T4.[Calc_AddressList] as RptLabelsCalc_AddressList,
T4.[Calc_PrintCompanyName] as RptLabelsCalc_PrintCompanyName,
T4.[AGUseGoodDefaultMark] as RptLabelsAGUseGoodDefaultMark,
T4.[CardNumber] as RptLabelsCardNumber,
T4.[CCCity] as RptLabelsCCCity,
T4.[CCState] as RptLabelsCCState,
T4.[ccToken] as RptLabelsccToken,
T4.[ChangedBy] as RptLabelsChangedBy,
T4.[ClosedNotShipped] as RptLabelsClosedNotShipped,
T4.[CounterSOAck] as RptLabelsCounterSOAck,
T4.[DispatchReason] as RptLabelsDispatchReason,
T4.[ECCOrderNum] as RptLabelsECCOrderNum,
T4.[ECCPaymentMethod] as RptLabelsECCPaymentMethod,
T4.[ECCPONum] as RptLabelsECCPONum,
T4.[FOB] as RptLabelsFOB,
T4.[InvcOrderCmp] as RptLabelsInvcOrderCmp,
T4.[InvCurrDepositBal] as RptLabelsInvCurrDepositBal,
T4.[IsCSRSet] as RptLabelsIsCSRSet,
T4.[NeedByDate] as RptLabelsNeedByDate,
T4.[OrderComment] as RptLabelsOrderComment,
T4.[OrderCSR] as RptLabelsOrderCSR,
T4.[OrderDate] as RptLabelsOrderDate,
T4.[OrderNum] as RptLabelsOrderNum,
T4.[OrderOpenCredit] as RptLabelsOrderOpenCredit,
T4.[OTSShipToNum] as RptLabelsOTSShipToNum,
T4.[Plant] as RptLabelsPlant,
T4.[PLArticle106c] as RptLabelsPLArticle106c,
T4.[PLEnforcementAuthAddr] as RptLabelsPLEnforcementAuthAddr,
T4.[PLEnforcementAuthName] as RptLabelsPLEnforcementAuthName,
T4.[PLGoodsOrServiceVATExempt] as RptLabelsPLGoodsOrServiceVATExempt,
T4.[PLInvIssuedBySecondTaxpayer] as RptLabelsPLInvIssuedBySecondTaxpayer,
T4.[PLInvIssuedByTaxpayer] as RptLabelsPLInvIssuedByTaxpayer,
T4.[PLLegalArticleAct] as RptLabelsPLLegalArticleAct,
T4.[PLLegalArticleOther] as RptLabelsPLLegalArticleOther,
T4.[PLLegalArticleWEDirective] as RptLabelsPLLegalArticleWEDirective,
T4.[PLMarginScheme] as RptLabelsPLMarginScheme,
T4.[PLSecondHandOrArts] as RptLabelsPLSecondHandOrArts,
T4.[PLTaxRepresentativeAddr] as RptLabelsPLTaxRepresentativeAddr,
T4.[PLTaxRepresentativeName] as RptLabelsPLTaxRepresentativeName,
T4.[PLTaxRepresentativeTaxID] as RptLabelsPLTaxRepresentativeTaxID,
T4.[PLTouristService] as RptLabelsPLTouristService,
T4.[PONum] as RptLabelsPONum,
T4.[ProFormaInvComment] as RptLabelsProFormaInvComment,
T4.[ReadyToFulfill] as RptLabelsReadyToFulfill,
T4.[ReprintSOAck] as RptLabelsReprintSOAck,
T4.[ShipByTime] as RptLabelsShipByTime,
T4.[TWFiscalPeriod] as RptLabelsTWFiscalPeriod,
T4.[TWFiscalYear] as RptLabelsTWFiscalYear,
T4.[TWFiscalYearSuffix] as RptLabelsTWFiscalYearSuffix,
T4.[TWGUIGroup] as RptLabelsTWGUIGroup,
T4.[TWGUIRegNumBuyer] as RptLabelsTWGUIRegNumBuyer,
T4.[TWGUIRegNumSeller] as RptLabelsTWGUIRegNumSeller,
T4.[WICreditCardorder] as RptLabelsWICreditCardorder,
T4.[WIOrder] as RptLabelsWIOrder,
T4.[WIUserID] as RptLabelsWIUserID,
T4.[WIUsername] as RptLabelsWIUsername,
T4.[Calc_BillToAddressList] as RptLabelsCalc_BillToAddressList,
T4.[Calc_BillToContact] as RptLabelsCalc_BillToContact,
T4.[Calc_BTAddressList] as RptLabelsCalc_BTAddressList,
T4.[Calc_CardNumber] as RptLabelsCalc_CardNumber,
T4.[Calc_CarrierDesc] as RptLabelsCalc_CarrierDesc,
T4.[Calc_CarrierSCAC] as RptLabelsCalc_CarrierSCAC,
T4.[Calc_CurrSymbol] as RptLabelsCalc_CurrSymbol,
T4.[Calc_CustAddrList] as RptLabelsCalc_CustAddrList,
T4.[Calc_CustPartOpts] as RptLabelsCalc_CustPartOpts,
T4.[Calc_FobDesc] as RptLabelsCalc_FobDesc,
T4.[Calc_LineMiscTotal] as RptLabelsCalc_LineMiscTotal,
T4.[Calc_MiscTotal] as RptLabelsCalc_MiscTotal,
T4.[Calc_MultiNeedDate] as RptLabelsCalc_MultiNeedDate,
T4.[Calc_MultiRef] as RptLabelsCalc_MultiRef,
T4.[Calc_MultiRel] as RptLabelsCalc_MultiRel,
T4.[Calc_MultiShipContacts] as RptLabelsCalc_MultiShipContacts,
T4.[Calc_MultiShipTo] as RptLabelsCalc_MultiShipTo,
T4.[Calc_MultiShipVia] as RptLabelsCalc_MultiShipVia,
T4.[Calc_OrderTotal] as RptLabelsCalc_OrderTotal,
T4.[Calc_PrcEmail] as RptLabelsCalc_PrcEmail,
T4.[Calc_PrcFax] as RptLabelsCalc_PrcFax,
T4.[Calc_PrcPhone] as RptLabelsCalc_PrcPhone,
T4.[Calc_RepRate] as RptLabelsCalc_RepRate,
T4.[Calc_SalesPerson] as RptLabelsCalc_SalesPerson,
T4.[Calc_ShipToAddressList] as RptLabelsCalc_ShipToAddressList,
T4.[Calc_ShipToContact] as RptLabelsCalc_ShipToContact,
T4.[Calc_ShipToEmail] as RptLabelsCalc_ShipToEmail,
T4.[Calc_ShipToFax] as RptLabelsCalc_ShipToFax,
T4.[Calc_ShipToPhone] as RptLabelsCalc_ShipToPhone,
T4.[Calc_ShipViaDesc] as RptLabelsCalc_ShipViaDesc,
T4.[Calc_SoldToBillToSameFlag] as RptLabelsCalc_SoldToBillToSameFlag,
T4.[Calc_SubTotal] as RptLabelsCalc_SubTotal,
T4.[Calc_TermsDesc] as RptLabelsCalc_TermsDesc,
T4.[Description] as RptLabelsDescription,
T4.[CurrDesc] as RptLabelsCurrDesc,
T4.[CurrName] as RptLabelsCurrName,
T4.[CurrSymbol] as RptLabelsCurrSymbol,
T4.[DocumentDesc] as RptLabelsDocumentDesc,
T4.[BTName] as RptLabelsBTName,
T4.[CustID] as RptLabelsCustID,
T4.[EMailAddress] as RptLabelsEMailAddress,
T4.[ResaleID] as RptLabelsResaleID,
T4.[SamplesOnAll_c] as RptLabelsSamplesOnAll_c,
T4.[SamplesOnNew_c] as RptLabelsSamplesOnNew_c,
T4.[TradingPartnerName] as RptLabelsTradingPartnerName,
T4.[WebDesc] as RptLabelsWebDesc,
T4.[ChangeTrackAmount] as RptLabelsChangeTrackAmount,
T4.[ChangeTrackApproved] as RptLabelsChangeTrackApproved,
T4.[ChangeTrackMemoDesc] as RptLabelsChangeTrackMemoDesc,
T4.[ChangeTrackMemoText] as RptLabelsChangeTrackMemoText,
T4.[ChangeTrackStatus] as RptLabelsChangeTrackStatus,
T4.[DocMiscAmt] as RptLabelsDocMiscAmt,
T4.[FreqCode] as RptLabelsFreqCode,
T4.[MiscCode] as RptLabelsMiscCode,
T4.[OrderLine] as RptLabelsOrderLine,
T4.[SeqNum] as RptLabelsSeqNum,
T4.[Calc_ChargeDesc] as RptLabelsCalc_ChargeDesc,
T4.[Calc_NumRels] as RptLabelsCalc_NumRels,
T4.[Calc_SalesAnalysis] as RptLabelsCalc_SalesAnalysis,
T4.[CardMemberName] as RptLabelsCardMemberName,
T4.[CurrencyCode] as RptLabelsCurrencyCode,
T4.[ChangeDate] as RptLabelsChangeDate,
T4.[ChangeTime] as RptLabelsChangeTime,
T4.[CommodityCode] as RptLabelsCommodityCode,
T4.[ContractID] as RptLabelsContractID,
T4.[ContractNum] as RptLabelsContractNum,
T4.[CreateJob] as RptLabelsCreateJob,
T4.[CustNum] as RptLabelsCustNum,
T4.[DefaultOversPricing] as RptLabelsDefaultOversPricing,
T4.[DemandContractLine] as RptLabelsDemandContractLine,
T4.[DemandContractNum] as RptLabelsDemandContractNum,
T4.[DemandDtlSeq] as RptLabelsDemandDtlSeq,
T4.[DemandHeadSeq] as RptLabelsDemandHeadSeq,
T4.[DiscBreakListCode] as RptLabelsDiscBreakListCode,
T4.[DiscListPrice] as RptLabelsDiscListPrice,
T4.[DisplaySeq] as RptLabelsDisplaySeq,
T4.[DocDiscount] as RptLabelsDocDiscount,
T4.[DocEndCustomerPrice] as RptLabelsDocEndCustomerPrice,
T4.[DocExtPriceDtl] as RptLabelsDocExtPriceDtl,
T4.[DocInAdvanceBillBal] as RptLabelsDocInAdvanceBillBal,
T4.[DocInDiscount] as RptLabelsDocInDiscount,
T4.[DocInExtPriceDtl] as RptLabelsDocInExtPriceDtl,
T4.[DocInListPrice] as RptLabelsDocInListPrice,
T4.[DocInOrdBasedPrice] as RptLabelsDocInOrdBasedPrice,
T4.[DocInUnitPrice] as RptLabelsDocInUnitPrice,
T4.[DocMSRP] as RptLabelsDocMSRP,
T4.[DocUnitPrice] as RptLabelsDocUnitPrice,
T4.[DoNotShipAfterDate] as RptLabelsDoNotShipAfterDate,
T4.[DoNotShipBeforeDate] as RptLabelsDoNotShipBeforeDate,
T4.[DupOnJobCrt] as RptLabelsDupOnJobCrt,
T4.[ECCOrderLine] as RptLabelsECCOrderLine,
T4.[ECCPlant] as RptLabelsECCPlant,
T4.[ECCQuoteLine] as RptLabelsECCQuoteLine,
T4.[ECCQuoteNum] as RptLabelsECCQuoteNum,
T4.[EndCustomerPrice] as RptLabelsEndCustomerPrice,
T4.[ExtPriceDtl] as RptLabelsExtPriceDtl,
T4.[GroupSeq] as RptLabelsGroupSeq,
T4.[InAdvanceBillBal] as RptLabelsInAdvanceBillBal,
T4.[InDiscount] as RptLabelsInDiscount,
T4.[InExtPriceDtl] as RptLabelsInExtPriceDtl,
T4.[InListPrice] as RptLabelsInListPrice,
T4.[InOrdBasedPrice] as RptLabelsInOrdBasedPrice,
T4.[InUnitPrice] as RptLabelsInUnitPrice,
T4.[KitCompOrigPart] as RptLabelsKitCompOrigPart,
T4.[KitCompOrigSeq] as RptLabelsKitCompOrigSeq,
T4.[KitFlag] as RptLabelsKitFlag,
T4.[KitParentLine] as RptLabelsKitParentLine,
T4.[KitPricing] as RptLabelsKitPricing,
T4.[KitPrintCompsInv] as RptLabelsKitPrintCompsInv,
T4.[KitPrintCompsPS] as RptLabelsKitPrintCompsPS,
T4.[KitQtyPer] as RptLabelsKitQtyPer,
T4.[KitShipComplete] as RptLabelsKitShipComplete,
T4.[LineStatus] as RptLabelsLineStatus,
T4.[LinkToContract] as RptLabelsLinkToContract,
T4.[LockDisc] as RptLabelsLockDisc,
T4.[MfgJobType] as RptLabelsMfgJobType,
T4.[MOMsourceEst] as RptLabelsMOMsourceEst,
T4.[MOMsourceType] as RptLabelsMOMsourceType,
T4.[MSRP] as RptLabelsMSRP,
T4.[OldOpenValue] as RptLabelsOldOpenValue,
T4.[OldOurOpenQty] as RptLabelsOldOurOpenQty,
T4.[OldProdCode] as RptLabelsOldProdCode,
T4.[OldSellingOpenQty] as RptLabelsOldSellingOpenQty,
T4.[OpenLine] as RptLabelsOpenLine,
T4.[OrderQty] as RptLabelsOrderQty,
T4.[OverrideDiscPriceList] as RptLabelsOverrideDiscPriceList,
T4.[Overs] as RptLabelsOvers,
T4.[OversUnitPrice] as RptLabelsOversUnitPrice,
T4.[PartNum] as RptLabelsPartNum,
T4.[PCLinkRemoved] as RptLabelsPCLinkRemoved,
T4.[PlanGUID] as RptLabelsPlanGUID,
T4.[PlanUserID] as RptLabelsPlanUserID,
T4.[POLine] as RptLabelsPOLine,
T4.[PrevPartNum] as RptLabelsPrevPartNum,
T4.[PrevSellQty] as RptLabelsPrevSellQty,
T4.[PrevXPartNum] as RptLabelsPrevXPartNum,
T4.[PricePerCode] as RptLabelsPricePerCode,
T4.[Reference] as RptLabelsReference,
T4.[RenewalNbr] as RptLabelsRenewalNbr,
T4.[ReverseCharge] as RptLabelsReverseCharge,
T4.[RevisionNum] as RptLabelsRevisionNum,
T4.[Rpt1AdvanceBillBal] as RptLabelsRpt1AdvanceBillBal,
T4.[Rpt1Discount] as RptLabelsRpt1Discount,
T4.[Rpt1EndCustomerPrice] as RptLabelsRpt1EndCustomerPrice,
T4.[Rpt1ExtPriceDtl] as RptLabelsRpt1ExtPriceDtl,
T4.[Rpt1InAdvanceBillBal] as RptLabelsRpt1InAdvanceBillBal,
T4.[Rpt1InDiscount] as RptLabelsRpt1InDiscount,
T4.[Rpt1InExtPriceDtl] as RptLabelsRpt1InExtPriceDtl,
T4.[Rpt1InListPrice] as RptLabelsRpt1InListPrice,
T4.[Rpt1InOrdBasedPrice] as RptLabelsRpt1InOrdBasedPrice,
T4.[Rpt1InUnitPrice] as RptLabelsRpt1InUnitPrice,
T4.[Rpt1ListPrice] as RptLabelsRpt1ListPrice,
T4.[Rpt1MSRP] as RptLabelsRpt1MSRP,
T4.[Rpt1OrdBasedPrice] as RptLabelsRpt1OrdBasedPrice,
T4.[Rpt1UnitPrice] as RptLabelsRpt1UnitPrice,
T4.[Rpt2AdvanceBillBal] as RptLabelsRpt2AdvanceBillBal,
T4.[Rpt2Discount] as RptLabelsRpt2Discount,
T4.[Rpt2EndCustomerPrice] as RptLabelsRpt2EndCustomerPrice,
T4.[Rpt2ExtPriceDtl] as RptLabelsRpt2ExtPriceDtl,
T4.[Rpt2InAdvanceBillBal] as RptLabelsRpt2InAdvanceBillBal,
T4.[Rpt2InDiscount] as RptLabelsRpt2InDiscount,
T4.[Rpt2InExtPriceDtl] as RptLabelsRpt2InExtPriceDtl,
T4.[Rpt2InListPrice] as RptLabelsRpt2InListPrice,
T4.[Rpt2InOrdBasedPrice] as RptLabelsRpt2InOrdBasedPrice,
T4.[Rpt2InUnitPrice] as RptLabelsRpt2InUnitPrice,
T4.[Rpt2ListPrice] as RptLabelsRpt2ListPrice,
T4.[Rpt2MSRP] as RptLabelsRpt2MSRP,
T4.[Rpt2OrdBasedPrice] as RptLabelsRpt2OrdBasedPrice,
T4.[Rpt2UnitPrice] as RptLabelsRpt2UnitPrice,
T4.[Rpt3AdvanceBillBal] as RptLabelsRpt3AdvanceBillBal,
T4.[Rpt3Discount] as RptLabelsRpt3Discount,
T4.[Rpt3EndCustomerPrice] as RptLabelsRpt3EndCustomerPrice,
T4.[Rpt3ExtPriceDtl] as RptLabelsRpt3ExtPriceDtl,
T4.[Rpt3InAdvanceBillBal] as RptLabelsRpt3InAdvanceBillBal,
T4.[Rpt3InDiscount] as RptLabelsRpt3InDiscount,
T4.[Rpt3InExtPriceDtl] as RptLabelsRpt3InExtPriceDtl,
T4.[Rpt3InListPrice] as RptLabelsRpt3InListPrice,
T4.[Rpt3InOrdBasedPrice] as RptLabelsRpt3InOrdBasedPrice,
T4.[Rpt3InUnitPrice] as RptLabelsRpt3InUnitPrice,
T4.[Rpt3ListPrice] as RptLabelsRpt3ListPrice,
T4.[Rpt3MSRP] as RptLabelsRpt3MSRP,
T4.[Rpt3OrdBasedPrice] as RptLabelsRpt3OrdBasedPrice,
T4.[Rpt3UnitPrice] as RptLabelsRpt3UnitPrice,
T4.[SalesUM] as RptLabelsSalesUM,
T4.[SellingFactorDirection] as RptLabelsSellingFactorDirection,
T4.[SellingQuantity] as RptLabelsSellingQuantity,
T4.[SmartString] as RptLabelsSmartString,
T4.[SmartStringProcessed] as RptLabelsSmartStringProcessed,
T4.[TotalReleases] as RptLabelsTotalReleases,
T4.[Unders] as RptLabelsUnders,
T4.[UndersPct] as RptLabelsUndersPct,
T4.[UnitPrice] as RptLabelsUnitPrice,
T4.[Warranty] as RptLabelsWarranty,
T4.[WarrantyCode] as RptLabelsWarrantyCode,
T4.[WarrantyComment] as RptLabelsWarrantyComment,
T4.[XPartNum] as RptLabelsXPartNum,
T4.[XRevisionNum] as RptLabelsXRevisionNum,
T4.[Calc_Duration] as RptLabelsCalc_Duration,
T4.[Calc_ExtPrice] as RptLabelsCalc_ExtPrice,
T4.[Calc_LabDur] as RptLabelsCalc_LabDur,
T4.[Calc_LabMod] as RptLabelsCalc_LabMod,
T4.[Calc_Labor] as RptLabelsCalc_Labor,
T4.[Calc_LineDesc] as RptLabelsCalc_LineDesc,
T4.[Calc_MatDur] as RptLabelsCalc_MatDur,
T4.[Calc_Mate] as RptLabelsCalc_Mate,
T4.[Calc_MatMod] as RptLabelsCalc_MatMod,
T4.[Calc_Misc] as RptLabelsCalc_Misc,
T4.[Calc_MiscDur] as RptLabelsCalc_MiscDur,
T4.[Calc_MiscMod] as RptLabelsCalc_MiscMod,
T4.[Calc_Modifier] as RptLabelsCalc_Modifier,
T4.[Calc_POLine] as RptLabelsCalc_POLine,
T4.[Calc_PrevPartNum] as RptLabelsCalc_PrevPartNum,
T4.[Calc_PrevSellQty] as RptLabelsCalc_PrevSellQty,
T4.[Calc_PrevXPartNum] as RptLabelsCalc_PrevXPartNum,
T4.[Calc_UOMForeignDesc] as RptLabelsCalc_UOMForeignDesc,
T4.[Calc_WarrComment] as RptLabelsCalc_WarrComment,
T4.[Calc_WarrDesc] as RptLabelsCalc_WarrDesc,
T4.[ContractDescription] as RptLabelsContractDescription,
T4.[CampDescription] as RptLabelsCampDescription,
T4.[EvntDescription] as RptLabelsEvntDescription,
T4.[MfgComment] as RptLabelsMfgComment,
T4.[PartDescription] as RptLabelsPartDescription,
T4.[PurComment] as RptLabelsPurComment,
T4.[TrackDimension] as RptLabelsTrackDimension,
T4.[TrackLots] as RptLabelsTrackLots,
T4.[TrackSerialNum] as RptLabelsTrackSerialNum,
T4.[UOMSymbol] as RptLabelsUOMSymbol,
T4.[WarrDescription] as RptLabelsWarrDescription,
T4.[DocInMiscAmt] as RptLabelsDocInMiscAmt,
T4.[ExtCompany] as RptLabelsExtCompany,
T4.[InMiscAmt] as RptLabelsInMiscAmt,
T4.[MiscAmt] as RptLabelsMiscAmt,
T4.[Percentage] as RptLabelsPercentage,
T4.[Rpt1InMiscAmt] as RptLabelsRpt1InMiscAmt,
T4.[Rpt1MiscAmt] as RptLabelsRpt1MiscAmt,
T4.[Rpt2InMiscAmt] as RptLabelsRpt2InMiscAmt,
T4.[Rpt2MiscAmt] as RptLabelsRpt2MiscAmt,
T4.[Rpt3InMiscAmt] as RptLabelsRpt3InMiscAmt,
T4.[Rpt3MiscAmt] as RptLabelsRpt3MiscAmt,
T4.[Type] as RptLabelsType,
T4.[ApplyChrg] as RptLabelsApplyChrg,
T4.[BuyToOrder] as RptLabelsBuyToOrder,
T4.[ChrgAmount] as RptLabelsChrgAmount,
T4.[COD] as RptLabelsCOD,
T4.[CODAmount] as RptLabelsCODAmount,
T4.[CODCheck] as RptLabelsCODCheck,
T4.[CODFreight] as RptLabelsCODFreight,
T4.[ComplianceMsg] as RptLabelsComplianceMsg,
T4.[DeclaredAmt] as RptLabelsDeclaredAmt,
T4.[DeclaredIns] as RptLabelsDeclaredIns,
T4.[DeliveryType] as RptLabelsDeliveryType,
T4.[DemandReference] as RptLabelsDemandReference,
T4.[DockingStation] as RptLabelsDockingStation,
T4.[DocOnly] as RptLabelsDocOnly,
T4.[DropShip] as RptLabelsDropShip,
T4.[DropShipName] as RptLabelsDropShipName,
T4.[EntityUseCode] as RptLabelsEntityUseCode,
T4.[GetDfltTaxIds] as RptLabelsGetDfltTaxIds,
T4.[GroundType] as RptLabelsGroundType,
T4.[Hazmat] as RptLabelsHazmat,
T4.[IUM] as RptLabelsIUM,
T4.[LineType] as RptLabelsLineType,
T4.[Location] as RptLabelsLocation,
T4.[MarkForNum] as RptLabelsMarkForNum,
T4.[MFCustNum] as RptLabelsMFCustNum,
T4.[NotifyEMail] as RptLabelsNotifyEMail,
T4.[NotifyFlag] as RptLabelsNotifyFlag,
T4.[OpenOrder] as RptLabelsOpenOrder,
T4.[OrderRelNum] as RptLabelsOrderRelNum,
T4.[OTMFAddress1] as RptLabelsOTMFAddress1,
T4.[OTMFAddress2] as RptLabelsOTMFAddress2,
T4.[OTMFAddress3] as RptLabelsOTMFAddress3,
T4.[OTMFCity] as RptLabelsOTMFCity,
T4.[OTMFContact] as RptLabelsOTMFContact,
T4.[OTMFCountryNum] as RptLabelsOTMFCountryNum,
T4.[OTMFFaxNum] as RptLabelsOTMFFaxNum,
T4.[OTMFName] as RptLabelsOTMFName,
T4.[OTMFPhoneNum] as RptLabelsOTMFPhoneNum,
T4.[OTMFState] as RptLabelsOTMFState,
T4.[OTMFZIP] as RptLabelsOTMFZIP,
T4.[OTSAddress1] as RptLabelsOTSAddress1,
T4.[OTSAddress2] as RptLabelsOTSAddress2,
T4.[OTSAddress3] as RptLabelsOTSAddress3,
T4.[OTSCity] as RptLabelsOTSCity,
T4.[OTSContact] as RptLabelsOTSContact,
T4.[OTSCountryNum] as RptLabelsOTSCountryNum,
T4.[OTSCustSaved] as RptLabelsOTSCustSaved,
T4.[OTSFaxNum] as RptLabelsOTSFaxNum,
T4.[OTSName] as RptLabelsOTSName,
T4.[OTSPhoneNum] as RptLabelsOTSPhoneNum,
T4.[OTSResaleID] as RptLabelsOTSResaleID,
T4.[OTSSaveAs] as RptLabelsOTSSaveAs,
T4.[OTSSaveCustID] as RptLabelsOTSSaveCustID,
T4.[OTSState] as RptLabelsOTSState,
T4.[OTSZIP] as RptLabelsOTSZIP,
T4.[OverrideCarrier] as RptLabelsOverrideCarrier,
T4.[OverrideService] as RptLabelsOverrideService,
T4.[PhaseID] as RptLabelsPhaseID,
T4.[PORelNum] as RptLabelsPORelNum,
T4.[PrevNeedByDate] as RptLabelsPrevNeedByDate,
T4.[PrevReqDate] as RptLabelsPrevReqDate,
T4.[PrevShipToNum] as RptLabelsPrevShipToNum,
T4.[PurPoint] as RptLabelsPurPoint,
T4.[RAN] as RptLabelsRAN,
T4.[RefNotes] as RptLabelsRefNotes,
T4.[RelStatus] as RptLabelsRelStatus,
T4.[ReqDate] as RptLabelsReqDate,
T4.[ResDelivery] as RptLabelsResDelivery,
T4.[SatDelivery] as RptLabelsSatDelivery,
T4.[SatPickup] as RptLabelsSatPickup,
T4.[ScheduleNumber] as RptLabelsScheduleNumber,
T4.[SellingReqQty] as RptLabelsSellingReqQty,
T4.[ServAlert] as RptLabelsServAlert,
T4.[ServAOD] as RptLabelsServAOD,
T4.[ServAuthNum] as RptLabelsServAuthNum,
T4.[ServDeliveryDate] as RptLabelsServDeliveryDate,
T4.[ServHomeDel] as RptLabelsServHomeDel,
T4.[ServInstruct] as RptLabelsServInstruct,
T4.[ServPhone] as RptLabelsServPhone,
T4.[ServPOD] as RptLabelsServPOD,
T4.[ServRelease] as RptLabelsServRelease,
T4.[ServSatDelivery] as RptLabelsServSatDelivery,
T4.[ServSatPickup] as RptLabelsServSatPickup,
T4.[ServSignature] as RptLabelsServSignature,
T4.[ShipOvers] as RptLabelsShipOvers,
T4.[ShipRouting] as RptLabelsShipRouting,
T4.[ShipToCustNum] as RptLabelsShipToCustNum,
T4.[ShipToNum] as RptLabelsShipToNum,
T4.[ShipViaCode] as RptLabelsShipViaCode,
T4.[ShpConNum] as RptLabelsShpConNum,
T4.[SubShipTo] as RptLabelsSubShipTo,
T4.[TaxConnectCalc] as RptLabelsTaxConnectCalc,
T4.[TaxExempt] as RptLabelsTaxExempt,
T4.[TaxRegionCode] as RptLabelsTaxRegionCode,
T4.[TransportID] as RptLabelsTransportID,
T4.[UseOTMF] as RptLabelsUseOTMF,
T4.[UseOTS] as RptLabelsUseOTS,
T4.[VendorNum] as RptLabelsVendorNum,
T4.[VerbalConf] as RptLabelsVerbalConf,
T4.[WasRecInvoiced] as RptLabelsWasRecInvoiced,
T4.[WebSKU] as RptLabelsWebSKU,
T4.[WIItemPrice] as RptLabelsWIItemPrice,
4.[WIItemShipCost] as RptLabelsWIItemShipCost,
T4.[WIOrderLine] as RptLabelsWIOrderLine,
T4.[Calc_OrderRelCounter] as RptLabelsCalc_OrderRelCounter,
T4.[Calc_PrevNeedByDate] as RptLabelsCalc_PrevNeedByDate,
T4.[Calc_PrevReqDate] as RptLabelsCalc_PrevReqDate,
T4.[Calc_PrevSellReqQty] as RptLabelsCalc_PrevSellReqQty,
T4.[Calc_PrevShipToNum] as RptLabelsCalc_PrevShipToNum,
T4.[Calc_ResaleID] as RptLabelsCalc_ResaleID,
T4.[Calc_TaxCodes] as RptLabelsCalc_TaxCodes,
T4.[BillEndDate] as RptLabelsBillEndDate,
T4.[BillStartDate] as RptLabelsBillStartDate,
T4.[ContractLine] as RptLabelsContractLine,
T4.[ContractQty] as RptLabelsContractQty,
T4.[DateInactivated] as RptLabelsDateInactivated,
T4.[DateInvoiced] as RptLabelsDateInvoiced,
T4.[DocPricePerUnit] as RptLabelsDocPricePerUnit,
T4.[Inactive] as RptLabelsInactive,
T4.[Invoiced] as RptLabelsInvoiced,
T4.[Rpt1PricePerUnit] as RptLabelsRpt1PricePerUnit,
T4.[Rpt2PricePerUnit] as RptLabelsRpt2PricePerUnit,
T4.[Rpt3PricePerUnit] as RptLabelsRpt3PricePerUnit,
T4.[Calc_OrderLine] as RptLabelsCalc_OrderLine,
T4.[Calc_OrderNum] as RptLabelsCalc_OrderNum,
T4.[Discount] as RptLabelsDiscount,
T4.[DocReportableAmt] as RptLabelsDocReportableAmt,
T4.[DocTaxableAmt] as RptLabelsDocTaxableAmt,
T4.[DocTaxAmt] as RptLabelsDocTaxAmt,
T4.[Percent] as RptLabelsPercent,
T4.[ReportableAmt] as RptLabelsReportableAmt,
T4.[TaxableAmt] as RptLabelsTaxableAmt,
T4.[TaxAmt] as RptLabelsTaxAmt,
T4.[TaxCode] as RptLabelsTaxCode,
T4.[AcceptType] as RptLabelsAcceptType,
T4.[AltTradingPartnerName] as RptLabelsAltTradingPartnerName,
T4.[DocDirection] as RptLabelsDocDirection,
T4.[DocumentName] as RptLabelsDocumentName,
T4.[DocumentType] as RptLabelsDocumentType,
T4.[EDIPartValidation] as RptLabelsEDIPartValidation,
T4.[MapID] as RptLabelsMapID,
T4.[OutboundAutomatic] as RptLabelsOutboundAutomatic,
T4.[OutboundDocName] as RptLabelsOutboundDocName,
T4.[OutBoundDocReq] as RptLabelsOutBoundDocReq,
T4.[OutboundManual] as RptLabelsOutboundManual,
T4.[PartOptionAvailList] as RptLabelsPartOptionAvailList,
T4.[PartOptionSelList] as RptLabelsPartOptionSelList
FROM
OrderHed_" + Parameters ! TableGuid.Value + " T1
LEFT OUTER JOIN
OrderDtl_" + Parameters ! TableGuid.Value + " T2
ON T1.Company = T2.Company
AND T1.OrderNum = T2.OrderNum
LEFT OUTER JOIN
OrderRel_" + Parameters ! TableGuid.Value + " T3
ON T2.Company = T3.Company
AND T2.OrderNum = T3.OrderNum
AND T2.OrderLine = T3.OrderLine
LEFT OUTER JOIN
RptLabels_" + Parameters ! TableGuid.Value + " T4
ON T1.RptLanguageID = T4.RptLanguageID
LEFT OUTER JOIN
OHOrderMsc_" + Parameters ! TableGuid.Value + " T5
ON T1.[Company] = T5.[Company]
AND T1.[OrderNum] = T5.[OrderNum]
LEFT OUTER JOIN
OrderMsc_" + Parameters ! TableGuid.Value + " T6
ON T3.[Company] = T6.[Company]
AND T3.[OrderLine] = T6.[OrderLine]
AND T3.[OrderNum] = T6.[OrderNum]
LEFT OUTER JOIN
FSContDt_" + Parameters ! TableGuid.Value + " T7
ON T6.[Company] = T7.[Company]
AND T6.[OrderLine] = T7.[OrderLine]
AND T6.[OrderNum] = T7.[OrderNum]
