ProsperityErp 9Fzzz0ZKWoHiX9XMYQRpJ9FWy+tIXUuky0ztXGpM4RvVEvfrxlf63eBBuVhhSaRn38j7jEZOw9V5R7nsw3TnRtFa+etGbVsFaV2c8GEM9i/CKvXCyVySzUZBnIhqhOAbxFI= ProsperityErp VwCustomer PriceModifier,System.Decimal CreatedDate,System.DateTime CreatedById,System.Int32 LastModifiedDate,System.DateTime LastModifiedById,System.Int32 SystemStateId,System.Byte CustomerSortName,System.String PaymentTermId,System.Int32 ChecksAllowed,System.Boolean CreditCardsAllowed,System.Boolean HasSubAccounts,System.Boolean CustomerId,System.Int32 BusinessId,System.Int16 CustomerStatusName,System.String CustomerTypeId,System.Byte CustomerTypeName,System.String AddressLine1,System.String AddressLine2,System.String AddressLine3,System.String AddressLine4,System.String City,System.String StateId,System.Int32 StateCode,System.String StateName,System.String ZipCode,System.String CountryId,System.Int32 CountryCode,System.String CountryName,System.String PhoneNumber1,System.String PhoneNumberExt1,System.String PhoneNumber2,System.String PhoneNumberExt2,System.String PhoneNumber3,System.String PhoneNumberExt3,System.String ShipToName,System.String ShipToAddressLine1,System.String ShipToAddressLine2,System.String ShipToAddressLine3,System.String ShipToAddressLine4,System.String ShipToCity,System.String ShipToStateId,System.Int32 ShipToStateCode,System.String ShipToStateName,System.String ShipToZipCode,System.String ContactName,System.String ContactAddressLine1,System.String ContactAddressLine2,System.String ContactAddressLine3,System.String ContactCity,System.String ContactStateId,System.String ContactStateCode,System.String ContactStateName,System.String ContactZipCode,System.String EmailAddress,System.String FederalTaxNumber,System.String BusinessBranchId,System.Int16 CustomerNumber,System.String CustomerName,System.String PosNotes,System.String PosNotesValidThruDate,System.DateTime NoteCategoryToDisplayAtPos,System.Int16 NoteCategoryToPrintOnInvoice,System.Int16 AlternateLookupCode,System.String InterestRate,System.Decimal DefaultBusinessBranchId,System.Int32 AccountRepId,System.Int32 CurrencyCodeId,System.Int32 PaymentTermCode,System.String PaymentTermName,System.String PriceLevel,System.Byte PricingCalculationModeId,System.Byte CustomerStatusId,System.Byte CreditLimit,System.Decimal CreditRating,System.String 30 VwCustomer ProsperityErp select * from VwCustomer VwCustomerTypeLookup CustomerTypeCode,System.String BusinessId,System.Int16 CustomerTypeId,System.Byte CustomerTypeName,System.String 30 VwCustomerTypeLookup ProsperityErp select * from VwCustomerTypeLookup VwInvoice PosShipViaCodeId,System.Int32 BusinessId,System.Int16 BusinessBranchId,System.Int16 InvoiceId,System.Int32 InvoiceNumber,System.String InvoiceDate,System.DateTime InvoiceStatusId,System.Byte TerminalId,System.Int32 CustomerId,System.Int32 DepositAmount,System.Decimal CashTendered,System.Decimal CheckTendered,System.Decimal CardTendered,System.Decimal CouponTendered,System.Decimal FoodStampTendered,System.Decimal FoodStampChange,System.Decimal GiftCertificateTendered,System.Decimal CreatedDate,System.DateTime CreatedById,System.Int32 LastModifiedDate,System.DateTime LastModifiedById,System.Int32 SystemStateId,System.Byte Subtotal,System.Decimal TaxableAmount,System.Decimal NontaxableAmount,System.Decimal Tax,System.Decimal Total,System.Decimal AmountTendered,System.Decimal ChangeAmount,System.Decimal AmountDue,System.Decimal ChargeAmount,System.Decimal InvoiceDueDate,System.DateTime ZZZZZZZZZZZZZZZZ1,System.Boolean CurrencyId,System.Int32 DirectShip,System.Boolean DirectShipPurchaseOrderNumber,System.String DirectShipPurchaseOrderReceived,System.Boolean AllowBackOrder,System.Boolean BackOrderedFromOrderId,System.Int32 BackOrderedToOrderId,System.Int32 TimesPrinted,System.Int32 OriginalQuoteId,System.Int32 OriginalOrderDate,System.DateTime OriginalSalesOrderNumber,System.Int32 NoFurtherUpdatesAllowed,System.Boolean GlAccountId,System.Int32 TotalOfItems,System.Decimal TotalDiscounts,System.Decimal TotalItemTaxes,System.Decimal TotalFrgtAddlTaxes,System.Decimal Taxable,System.String TaxCodeId,System.Int32 TaxRate,System.Decimal TaxableTotalForeign,System.Decimal SalesTaxOverriddenOnHeader,System.String LastKitOrTallyAssocRefNumber,System.Int16 NextKitOrTallySeqNumber,System.Int16 CopyFreightToBackOrder,System.Boolean PricingCode,System.Int16 Cancelled,System.Boolean StatementType,System.String CopyToBackOrder,System.Boolean PurchaseOrderRequired,System.Boolean HighInvoiceTotal,System.Decimal OriginalInvoiceTotal,System.Decimal TotalAppliedToInvoice,System.Decimal OriginalTotalAppliedToInvoice,System.Decimal InvoiceBalance,System.Decimal NumberOfInvoiceCopies,System.Byte OrderQuoteOrEstimateTimesPrinted,System.Int16 DeliveryTicketTimesPrinted,System.Int16 PickingTicketTimesPrinted,System.Int16 SpecialOrderTicketTimesPrinted,System.Int16 QuoteOrEstimateConsolidationCode,System.String UseCashPromosEvenForChargeSales,System.Boolean MaterialsAreReadyToShip,System.Boolean LocationBufferForOrderViewQuery,System.String SentToCommerceHub,System.Boolean SuppressOHQtyUpdate,System.Boolean ZZZZZZZZZZZZZZZ50,System.Boolean WebsiteOrder,System.Boolean ImportSourceProviderId,System.Int32 ImportSourceRecordId,System.String RestockGlAccountId,System.Int32 RestockTaxable,System.Boolean RestockDiscountable,System.Boolean RestockType,System.String WeightTotal,System.Decimal VolumeTotal,System.Decimal ReturnCode,System.String NextUniqueDetailLineIdNumber,System.Int16 ApVoucherRefundAmount,System.Decimal ApVoucherRefundVoucherId,System.Decimal OrderedOnPurchseOrderId,System.Int32 OrderedOnPurchaseOrderNumber,System.String OrderedOnPurchaseOrderVendorNumber,System.String OrderedOnPurchaseOrderVendorName,System.String NoteLine1,System.String NoteLine2,System.String NoteLine3,System.String ShipBranchInventoryTransferOutGlAccountId,System.String ThisBranchInventoryTransferInGlAccountId,System.String InventoryTransferNumber,System.String UseCustomerTypeSalesGlAccount,System.Boolean CustTypeSalesGlAccountId,System.String CustTypeCostOfSalesGlAccountId,System.String CustTypeCashReturnGlAccountId,System.String CustTypeChargeReturnGlAccountId,System.String FreightGlAccountId,System.String FreightAsCostGlAccountId,System.String FreightType,System.String FreightAsCost,System.Boolean FreightTotal,System.Decimal Discountable,System.Boolean DiscountRate,System.Decimal DiscountExceptionAmount,System.Decimal EarlyPayDiscountRate,System.Decimal EarlyPayDueDate,System.DateTime EarlyPayDiscountByAmtOrPercent,System.String EarlyPayDiscountAmt,System.Decimal EarlyPayDiscountAmtForeign,System.Decimal EarlyPayDiscountTaken,System.Decimal DiscountableTotal,System.Decimal DiscountableTaxableTotal,System.Decimal DiscountableNonTaxableTotal,System.Decimal NonDiscountableTaxableTotal,System.Decimal NonDiscountableNonTaxableTotal,System.Decimal EarlyPayDiscountableTotal,System.Decimal EPDiscTotalTaxRebateTaken,System.Decimal CouponTaxDiscountTotal,System.Decimal DutyIsToBePaidOnThisInvoice,System.Boolean TotalDutyTax,System.Decimal TotalDutyTaxNotForCosting,System.Decimal TotalDutyPaidCost,System.Decimal DutyPaidCustomer,System.Boolean SrepsalsDirectSales,System.Decimal SrepsalsDirectCost,System.Decimal SrepsalsRegularSales,System.Decimal SrepsalsRegularCost,System.Decimal SrepsalsSpecialOrderSales,System.Decimal SrepsalsSpecialOrderCost,System.Decimal CreditOverrideRepId,System.Int32 CreditOverridePasswordUsed,System.String CreditOverrideAmount,System.Decimal ForceManagerSignatureAtSave,System.Boolean ControllerLevelAuthAmount,System.Decimal CurrencyConversionFactor,System.Decimal AccountRepCommissionAmountForOrder,System.Decimal AccountRepDerivedCommissionPercent,System.Decimal SalesRepCommissionAmountForOrder,System.Decimal SalesRepDerivedCommissionPercent,System.Decimal TotalRepCommissionAmountForOrder,System.Decimal BlueTarpTransaction,System.Boolean BlueTarpSequenceNumber,System.Int16 BlueTarpAuthorization,System.String BlueTarpAmt,System.Decimal BadCheckIDOverrideRepId,System.Int32 BadCheckIDOverrideDate,System.DateTime BadCheckIDOverrideTime,System.DateTime BadCheckIDCode,System.String GiftCardSaleAmount,System.Decimal GiftCardCostAmount,System.Decimal WarehouseLocationCode,System.String WarehouseStatusCode,System.String WarehouseRepId,System.Int32 WarehouseStartDate,System.DateTime WarehouseStartTime,System.DateTime WarehouseEndDate,System.DateTime WarehouseEndTime,System.DateTime WarehouseTotalBoxes,System.Int16 WarehouseTotalPallets,System.Int16 TotalVendorRebate,System.Decimal TotalVendorRebateNetCost,System.Decimal LoyaltyCustomerNumber,System.String MemberDiscountableTotal,System.Decimal MemberTotalDiscount,System.Decimal MembershipConfirmed,System.Boolean ZZZZZZZZZZZZZZZ99,System.Boolean ReferenceLine,System.String CustomerNumberOnOrderId,System.Int32 SubAccountNumberOnOrderId,System.Int32 BillToCustomerId,System.String ImportOrderNumber,System.String PlacedByIdentificationTagScanned,System.Boolean TermCodeManuallyChanged,System.Boolean DriversLicenseNumber,System.String SocialSecurityNumber,System.String CheckNumber,System.String CardNumber,System.String CardTypeId,System.String CardExpirationDate,System.DateTime CardAmount,System.Decimal CardApprovalReturnedCode,System.String CardApprovalVoiceCode,System.String CustomerNumber,System.String CustomerName,System.String CustomerSubAccountId,System.Int32 CustomerSubAccountNumber,System.String CustomerSubAccountName,System.String CustomerTermId,System.Int32 CustomerPurchaseOrderNumber,System.String TerminalCode,System.String TerminalName,System.String SalesRepId,System.Int32 AccountRepId,System.Int32 WhoPlacedTheOrder,System.String ShipToName,System.String ShipToAddress1,System.String ShipToAddress2,System.String ShipToAddress3,System.String ShipToCity,System.String ShipToState,System.String ShipToZipCode,System.String ShipToPhoneNumber,System.String RequestedShipDate,System.DateTime ShipDate,System.DateTime SoldToAddress1,System.String SoldToAddress2,System.String SoldToAddress3,System.String DocumentConsolidationId,System.Int64 OriginalSalesRepId,System.Int32 30 VwInvoice ProsperityErp select * from VwInvoice VwInvoiceDetail ItemCost,System.Decimal PosSellingPrice,System.Decimal PosSellingUomId,System.Int16 PosPricingPrice,System.Decimal PosPricingUomId,System.Int16 PosPricingToPosSellingUnitFactor,System.Decimal ExtPrice,System.Decimal Taxable,System.String TaxAmount,System.Decimal BusinessId,System.Int16 BusinessBranchId,System.Int16 InvoiceDetailId,System.Int32 InvoiceId,System.Int32 LineNumber,System.Int16 InventoryBranchId,System.Int32 InventoryId,System.Int32 ItemNumber,System.String ItemName,System.String OrderQuantity,System.Decimal BackOrderQuantity,System.Decimal ShippedQuantity,System.Decimal CreatedDate,System.DateTime CreatedById,System.Int32 LastModifiedDate,System.DateTime LastModifiedById,System.Int32 SystemStateId,System.Byte OverridePrice,System.Boolean OverrideExtPrice,System.Boolean IsBelowCost,System.Boolean ZZZZZZZZZ1,System.Boolean OriginalOrderQuantity,System.Decimal OriginalSellingPrice,System.Decimal WhatWasEntered,System.String SerialNumber,System.String ExtraDescription,System.String DescriptionsMayBeEdited,System.Boolean IsPriceAdderItem,System.Boolean PriceAdderInventoryId,System.Int32 PriceAdderInventoryBranchId,System.Int32 AdderDescriptionCombineMode,System.String ChargeFreightOnAdderItem,System.Boolean ChargeRestockOnAdderItem,System.Boolean TallyOrKit,System.String TallyOrKitContentsSequenceNumber,System.Int16 TallyOrKitUnitForComponentList,System.String TallyOrKitFactorForComponentList,System.Decimal PricingCode,System.String TaxableOverriddenByItemInformationOption,System.Boolean TaxableItemInformationOptionOverride,System.String PosDetailTaxAmount,System.Decimal PosDetailTaxableAmount,System.Decimal ReturnCode,System.String ReturnOriginalPriceSourceCode,System.String LoadedOrPickedUp,System.String BftEmbeddedInCommentLine,System.Boolean SetQuantity,System.Decimal SetActive,System.Boolean GroupSalesDiscountActive,System.Boolean GroupSalesDiscountRate,System.Decimal InitialOrderedQuantityForComparison,System.Decimal OrderedQuantityPerSet,System.Decimal FactoredOrderedQuantity,System.Decimal ShippedQuantityPerSet,System.Decimal FactoredShippedQuantity,System.Decimal BackorderQuantityPerSet,System.Decimal FactoredBackorderQuantity,System.Decimal WarehousePulledQuantity,System.Decimal WarehousePulledRepId,System.Int32 BackorderGenerated,System.Boolean ContractQuantitySoldSoFar,System.Decimal ContractQuantityComittedSoFar,System.Decimal ReservedQuantity,System.Decimal StockingUomFromInventory,System.String SaleFactor,System.Decimal PricingFactor,System.Decimal PricingFactorFromInventory,System.Decimal SystemAssignedSalePrice,System.Decimal SalePriceBeforeVolumeDiscount,System.Decimal SalePriceForVolumeDiscount,System.Decimal VolumeDiscountApplied,System.String PriceSourceCode,System.String FactoredSalePrice,System.Decimal SalePriceInInvPricingUnit,System.Decimal SalePriceInInvStockingUnit,System.Decimal ManualMarkUpMarkDownMode,System.String ManualMarkUpMarkDownPercent,System.Decimal ManualMarkUpMarkDownOldPrice,System.Decimal AllowRepricing,System.Boolean ShippingContainer,System.String Weight,System.Decimal WeightFactor,System.Decimal FactoredWeight,System.Decimal WeightExtension,System.Decimal Volume,System.Decimal VolumeFactor,System.Decimal FactoredVolume,System.Decimal VolumeExtension,System.Decimal FreightExtension,System.Decimal Extension,System.Decimal ForcedExtension,System.Decimal ExtensionForced,System.Boolean MemoCost,System.Decimal BurdenCost,System.Decimal LaborCost,System.Decimal OverheadPercent,System.Decimal RawCostOnPurchaseOrder,System.Decimal AverageCostInInvPricingUnit,System.Decimal AverageCostAtInvoicing,System.Decimal MarketCostInInvPricingUnit,System.Decimal LastCost,System.Decimal LastCostInInvPricingUnit,System.Decimal FactoredAverageCost,System.Decimal FactoredMarketCost,System.Decimal FactoredLastCost,System.Decimal CostExtension,System.Decimal CostExtensionAtMarket,System.Decimal CostExtensionAtLast,System.Decimal ContractBranchId,System.Int32 ContractLineNumber,System.Int16 ContractQuantityLimit,System.Decimal ContractQuantityLimitUnit,System.String ContractQuantityLimitFactor,System.Decimal FactoredContractQuantityLimit,System.Decimal CostGlAccountId,System.Int32 InventoryGlAccountId,System.Int32 SalesGlAccountId,System.String UseGLAcctNumbersFromItemRecord,System.Boolean PlaceOnPurchaseOrder,System.Boolean PlacedOnPurchaseOrder,System.Boolean PlaceOnPurchaseOrderNumber,System.Int32 PlaceOnPurchaseOrderVendorId,System.String PlacedOnUnlinkedPurchaseOrderNumber,System.String PurchaseOrderDetailLineId,System.Int16 EligibleForFoodStamp,System.Boolean CommodityCode,System.String RentalEquipment,System.Boolean RentalSaved,System.Boolean RentalItemId,System.Int32 RentalContract,System.Int16 DutyRegistrationNumber,System.String AllowBondedDutyFree,System.Boolean DutyAmount,System.Decimal DutyAmountNotForCosting,System.Decimal PromoCodeId,System.Int32 AccountRepCommissionPercentage,System.Decimal SalesRepCommissionPercentage,System.Decimal AcctRepDerivedCommissionPercent,System.Decimal SalesRepDerivedCommissionPercent,System.Decimal AcctRepDerivedCommissionAmount,System.Decimal SalesRepDerivedCommissionAmount,System.Decimal CommittedPurchaseOrderNumber,System.Int32 CommittedPurchaseOrderQuantity,System.Decimal PackingListBeginningCarton,System.Int16 PackingListEndingCarton,System.Int16 PackingListLength,System.Int16 PackingListWidth,System.Int16 PackingListHeight,System.Int16 PackingListWeight,System.Decimal EarlyPayDiscountReturnDiscount,System.Decimal EarlyPayDiscountReturnTaxRebate,System.Decimal PlaceLineOnTransfer,System.String PlaceLineOnRequisition,System.String RequisitionNumber,System.Int32 KitOrTallyAssocRefNumber,System.Int32 ItemStatusText,System.String ManagerPriceOverrideRepId,System.Int32 ManagerNegQtyOverrideRepId,System.Int32 AllowCostReload,System.Boolean IsANetItem,System.Boolean AllowQuantityEntry,System.String ReloadingGiftCard,System.Boolean RemoteSiteLocationCode,System.String ImportedFromOriginalOrderNumber,System.Int32 ImportedFromUniqueDetailLineId,System.Int32 RemoteGiftCardSequenceNumber,System.Int32 VendorRebateCode,System.Byte VendorRebateAmount,System.Decimal FactoredVendorRebateAmount,System.Decimal VendorRebateExtension,System.Decimal VendorRebateNetCost,System.Decimal FactoredVendorRebateNetCost,System.Decimal VendorRebateNetCostExtension,System.Decimal AllowLevelVolumeDisc,System.Boolean OneDimensionalCutTransactionNumber,System.Int32 TimesScanned,System.Decimal ReturnedFromOriginalOrderNumber,System.Int32 ReturnedFromUniqueDetailLineId,System.Int16 MemberTotalDiscountable,System.Decimal PriceSourceNumber,System.String PriceSourceType,System.String ManagerOverrideId,System.Int32 30 VwInvoiceDetail ProsperityErp select * from VwInvoiceDetail VwSalesRep BusinessId,System.Int16 BusinessBranchId,System.Int16 SalesRepId,System.Int32 SalesRepNumber,System.String CreatedDate,System.DateTime CreatedById,System.Int32 LastModifiedDate,System.DateTime LastModifiedById,System.Int32 SystemStateId,System.Byte EmployeeId,System.Int32 Quota,System.Decimal Basis,System.Decimal CommissionTableCode,System.String DirectSaleCommissionTable,System.String ManagersPriceOverridePassword,System.String EmailAddress,System.String NextSpecOrdItemSeqNumber,System.Int16 SpecialOrderItemNumberCode,System.String ControllerLevelPassword,System.String EmailPurchaseOrdersToSelf,System.Boolean EmailPurchaseOrdersFormName,System.String Name,System.String Address1,System.String Address2,System.String City,System.String State,System.String ZipCode,System.String 30 VwSalesRep ProsperityErp select * from VwSalesRep VwTaxCode TaxCodeId,System.Int32 BusinessId,System.Int16 BusinessBranchId,System.Int16 ReportAsDetailLine,System.Boolean RoundingMode,System.String InventoryItemTaxQualifier,System.String TaxRate,System.Decimal TaxableSalesLimit,System.Decimal TaxCode,System.String TaxDescription,System.String GlAccountId,System.Int32 30 VwTaxCode ProsperityErp select * from VwTaxCode VwTerminal BusinessId,System.Int16 BusinessBranchId,System.Int16 TerminalId,System.Int32 TerminalCode,System.String TerminalName,System.String IpAddress,System.String MacAddress,System.String Comments,System.String SessionsAllowed,System.Byte 30 VwTerminal ProsperityErp select * from VwTerminal VwCustomerSubAccount BusinessId,System.Int16 BusinessBranchId,System.Int16 CustomerSubAccountId,System.Int32 CustomerId,System.Int32 CustomerSubAccountStatusName,System.String CreditLimit,System.Decimal IsOverCreditLimit,System.Boolean DaysPastDue,System.Int32 AccountBalance,System.Decimal CustomerSubAccountTypeId,System.Byte CustomerSubAccountTypeName,System.String CustomerSubAccountNumber,System.String DefaultBusinessBranchId,System.Int16 PaymentTermId,System.Int32 CustomerSubAccountStatusId,System.Byte PriceModifier,System.Decimal InterestRate,System.Decimal CustomerSubAccountStatusCode,System.String PaymentTermCode,System.String PaymentTermName,System.String PriceLevel,System.Byte PricingCalculationModeId,System.Byte CustomerSubAccountName,System.String PosNotes,System.String PosNotesValidThruDate,System.DateTime NoteCategoryToDisplayAtPos,System.Int16 NoteCategoryToPrintOnInvoice,System.Int16 CustomerSubAccountAddressLine1,System.String CustomerSubAccountAddressLine2,System.String CustomerSubAccountAddressLine3,System.String CustomerSubAccountCity,System.String CustomerSubAccountStateId,System.Int32 CustomerSubAccountStateCode,System.String CustomerSubAccountStateName,System.String CustomerSubAccountZipCode,System.String CustomerSubAccountCountryId,System.Int16 CustomerSubAccountCountryCode,System.String CustomerSubAccountCountryName,System.String CustomerSubAccountTelephoneNumber,System.String CustomerSubAccountTelephoneNumberExt,System.String CustomerSubAccountContactName,System.String CustomerSubAccountEmailAddress,System.String Taxable,System.String TaxNumber,System.String TaxNumberExpirationDate,System.DateTime AccountRepId,System.Int32 CustomerNumber,System.String CustomerName,System.String 30 VwCustomerSubAccount ProsperityErp select * from VwCustomerSubAccount VwBusiness BusinessId,System.Int16 BusinessCode,System.String BusinessName,System.String BusinessStatusId,System.Byte BusinessAddress1,System.String BusinessAddress2,System.String BusinessCity,System.String BusinessStateId,System.Int32 BusinessStateCode,System.String BusinessStateName,System.String BusinessZipCode,System.String BusinessTelephone1,System.String BusinessTelephone2,System.String BusinessFaxNumber,System.String 30 VwBusiness ProsperityErp select * from VwBusiness InvoiceToInvoiceDetail InvoiceId InvoiceToInvoiceDetail relInvoiceToInvoiceDetail InvoiceId InvoiceToCustomer CustomerId InvoiceToCustomer relInvoiceToCustomer CustomerId InvoiceToSalesRep SalesRepId InvoiceToSalesRep relInvoiceToSalesRep SalesRepId CustomerToCustomerType CustomerTypeId CustomerToCustomerType relCustomerToCustomerType CustomerTypeId InvoiceToTaxCode TaxCodeId InvoiceToTaxCode relInvoiceToTaxCode TaxCodeId InvoiceToTerminal TerminalId InvoiceToTerminal relInvoiceToTerminal TerminalId CustomerToCustomerSubAccount CustomerId CustomerToCustomerSubAccount relCustomerToCustomerSubAccount CustomerId ,p_intReportSortSequence,p_intReportSortSequence,Parameter_x0020_Report_x0020_Sort_x0020_Sequence,System.Int32,_x0030_,False,False,True,False,,,True ,strINVOICENUMBER,strINVOICENUMBER,,System.String,InvoiceNumber,True,False,False,False,,,True ,strCUSTOMERNAME,strCUSTOMERNAME,,System.String,CustomerName,True,False,False,False,,,True ,strSALESREPNUMBER,strSALESREPNUMBER,,System.String,SalesRepNumber,True,False,False,False,,,True ,strTERMINALNAME,strTERMINALNAME,,System.String,TerminalName,True,False,False,False,,,True ,strCUSTOMERTYPECODE,strCUSTOMERTYPECODE,,System.String,CustomerTypeCode,True,False,False,False,,,True ,blnUseMarketCost,blnUseMarketCost,,System.Boolean,false,False,False,False,False,,,True ,decInvoiceProfit,decInvoiceProfit,Calculated,System.Decimal,_x0028_VwInvoiceDetail.PosSellingPrice_x0020_-_x0020_decInvoiceCost_x0029_,True,True,False,False ,decMarkup,decMarkup,,System.Decimal,_x0028_decInvoiceCost_x0020__x003D__x003D__x0020_0_x0020__x003F__x0020_0_x0020_:_x0020_decInvoiceProfit_x0020__x002F__x0020_decInvoiceCost_x0029_,True,True,False,False ,decMargin,decMargin,,System.Decimal,_x0028_VwInvoiceDetail.PosSellingPrice_x0020__x003D__x003D__x0020_0_x0020__x003F__x0020_0_x0020_:_x0020_decInvoiceProfit_x0020__x002F__x0020_VwInvoiceDetail.PosSellingPrice_x0029_,True,True,False,False ,decInvoiceCost,decInvoiceCost,,System.Decimal,_x0028_blnUseMarketCost_x0020__x003F__x0020_VwInvoiceDetail.MarketCostInInvPricingUnit_x0020_:_x0020_VwInvoiceDetail.AverageCostInInvPricingUnit_x0029_,True,True,False,False ,blnUseMarkupCost,blnUseMarkupCost,,System.Boolean,false,False,False,False,False,,,True ,p_intWhichInvoice,p_intWhichInvoice,Parameter_x0020_-_x0020_Which_x0020_Invoices_x0020_to_x0020_display,System.Int32,_x0030_,False,False,True,False,,,True ,p_intWhichCost,p_intWhichCost,Parameter_x0020_-_x0020_Which_x0020_Cost_x0020_to_x0020_display,System.Int32,_x0030_,False,False,True,False,,,True ,p_intWhichSales,p_intWhichSales,Parameter_x0020_-_x0020_Which_x0020_Sales_x0020_to_x0020_display,System.Int32,_x0030_,False,False,True,False,,,True ,p_intWhichFormat,p_intWhichFormat,Parameter_x0020_-_x0020_Which_x0020_Format_x0020_to_x0020_display,System.Int32,_x0030_,False,False,True,False,,,True ,p_strInvoiceBegin,p_strInvoiceBegin,Parameter_x0020_-_x0020_Beginning_x0020_Invoice_x0020_Sequence_x0020__x0023_,System.String,,False,False,True,False,,,True ,p_strInvoiceEnd,p_strInvoiceEnd,Parameter_x0020_-_x0020_Ending_x0020_Invoice_x0020_Sequence_x0020__x0023_,System.String,,False,False,True,False,,,True ,p_dtInvoiceBegin,p_dtInvoiceBegin,Parameter_x0020_-_x0020_Begin_x0020_Invoice_x0020_Date,System.DateTime,_x0031__x002F_1_x002F_2010_x0020_12:00:00_x0020_AM,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_DateTimeType_x003E_DateAndTime_x003C__x002F_DateTimeType_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_1_x0022__x003E__x003C_value_x003E_1_x002F_1_x002F_2010_x0020_12:00:00_x0020_AM_x003C__x002F_value_x003E__x003C__x002F_Keys_x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_1_x0022__x003E__x003C_value_x0020__x002F__x003E__x003C__x002F_Values_x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_,,True ,p_dtInvoiceEnd,p_dtInvoiceEnd,Parameter_x0020_-_x0020_End_x0020_Invoice_x0020_Date,System.DateTime,_x0032__x002F_11_x002F_2016_x0020_3:55:29_x0020_PM,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_DateTimeType_x003E_DateAndTime_x003C__x002F_DateTimeType_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_,,True ,p_boolPrintAmounts,p_boolPrintAmounts,Parameter_x0020_-_x0020_Print_x0020_Amounts_x0020_Tendered,System.Boolean,true,False,False,True,False,,,True ,p_boolPrintTaxCodeAmounts,p_boolPrintTaxCodeAmounts,Parameter_x0020_-_x0020_Print_x0020_Tax_x0020_Codes_x0020_and_x0020_Amounts_x003F_,System.Boolean,true,False,False,True,False,,,True ,p_boolPrintProfit,p_boolPrintProfit,Parameter_x0020_-_x0020_Print_x0020_Profit_x0020_and_x0020_Margin,System.Boolean,true,False,False,True,False,,,True ,strReportSortSequence,strReportSortSequence,Calculated_x0020_value_x0020_to_x0020_Display_x0020_in_x0020_Header,System.String,_x0028_String_x0029_Switch_x0028_p_intReportSortSequence_x003D__x003D_0_x002C__x0020_strINVOICENUMBER_x002C__x0020_p_intReportSortSequence_x003D__x003D_1_x002C__x0020_strCUSTOMERNAME_x002C__x0020_p_intReportSortSequence_x003D__x003D_2_x002C__x0020_strSALESREPNUMBER_x002C__x0020_p_intReportSortSequence_x003D__x003D_3_x002C__x0020_strTERMINALNAME_x002C__x0020_p_intReportSortSequence_x003D__x003D_4_x002C__x0020_strCUSTOMERTYPECODE_x0029_,True,True,False,False EngineV2 None;Black;2;None;False;4;Black Transparent Transparent 0,0.2,7.72,0.3 Transparent 0,0,2,0.2 Arial,8 0,0,0,0 Text2 Report Created {ReportCreated} Black Expression Transparent 2,0,4,0.2 Arial,8 Center 0,0,0,0 Text6 Sales Register Report for {VwBusiness.BusinessName} Sorted by {strReportSortSequence} Black Expression Transparent 6.5,0,1.2,0.2 Arial,8 Right 0,0,0,0 Text4 {PageNofM} Black Expression PageHeaderBand1 All;Black;1;Solid;False;4;Black Transparent 0,0.9,7.72,0.3 Bottom;Black;1;Solid;False;4;Black Transparent 0,0,0.6,0.3 Arial,8 Center 0,0,0,0 hdrInvoice INVOICE # Black Expression Center Bottom;Black;1;Solid;False;4;Black Transparent 0.6,0,0.6,0.3 Arial,8 a991eb6464064596af19e1d20372a1dc Center 0,0,0,0 hdrDate INVOICE DATE Black Expression Center Bottom;Black;1;Solid;False;4;Black Transparent 1.2,0,0.6,0.3 Arial,8 060f1318aa034272bbce1f98705ad46f Center 0,0,0,0 hdrCustNum CUST # Black Expression Center Bottom;Black;1;Solid;False;4;Black Transparent 3.9,0,0.8,0.3 Arial,8 12d755d756444261b913ae1c1f27527a Center 0,0,0,0 hdrCustName CUSTOMER Black Center Bottom;Black;1;Solid;False;4;Black Transparent 4.7,0,0.5,0.3 Arial,8 de45382fbff34d0ab284133d47002f14 Center 0,0,0,0 hdrSalesRep SALES REP Black Expression Center Bottom;Black;1;Solid;False;4;Black Transparent 5.2,0,0.5,0.3 Arial,8 6181a7c5c4d24c7bb97beb31eb810007 Center 0,0,0,0 hdrInvAmount INVOICE AMOUNT Black Expression Center Bottom;Black;1;Solid;False;4;Black Transparent 5.7,0,0.5,0.3 Arial,8 92dc894052a641d4ac3a15f18f1553ae Center 0,0,0,0 invTax TAX TOTALS Black Expression Center Bottom;Black;1;Solid;False;4;Black Transparent 6.2,0,0.5,0.3 Arial,8 96f4c18562924de5be90b9c637f28882 Center 0,0,0,0 hdrTotal SALES TOTAL Black Expression Center Bottom;Black;1;Solid;False;4;Black Transparent 6.7,0,0.5,0.3 Arial,8 8ec1b7961e0b47cd9a3d1b3da382d5b8 Center 0,0,0,0 hdrProfit PROFIT Black Center Bottom;Black;1;Solid;False;4;Black Transparent 7.2,0,0.5,0.3 Arial,8 8901d54683ff490d955d70e368c38d8a Center 0,0,0,0 hdrMargin MARGIN Black Center Bottom;Black;1;Solid;False;4;Black Transparent 1.8,0,2.1,0.3 Arial,8 270bc3eeec7e4ee39aa4872749a5af83 Center 0,0,0,0 Text14 SUB ACCT Black Expression Center HeaderBand1 Transparent 0,1.6,7.72,0.2 Transparent 0,0,0.6,0.2 Arial,8 85963457f7cc44f8a43a7cc9c618ba84 0,0,0,0 txtInvoiceNumber {VwInvoice.InvoiceNumber} Black DataColumn Center Transparent 7.2,0,0.5,0.2 Arial,8 3895ca18f39b4fedb922bde260f11b92 Right 0,0,0,0 Text3 {blnUseMarkupCost ? decMarkup : decMargin} Black Expression Center Transparent 0.6,0,0.6,0.2 Arial,8 87b3ff82fc8f479590de8101d63fdf49 Right 0,0,0,0 Text5 {Format("{0:MM/dd/yyyy}", VwInvoice.InvoiceDate)} Black Expression Center Transparent 1.2,0,0.6,0.2 Arial,8 46a93db8e30d4e8e8fca957917d3bdf6 Right 0,0,0,0 Text7 {VwCustomer.CustomerNumber} Black Center Transparent 3.9,0,0.8,0.2 Arial,8 f1e956d5de5249c2b616ff6226882440 Center 0,0,0,0 Text8 {VwCustomer.CustomerName} Black Center Transparent 4.7,0,0.5,0.2 Arial,8 1c2e0bb3382b4b68a3747f0f1bdde1de Center 0,0,0,0 Text9 {VwSalesRep.SalesRepNumber} Black DataColumn Center Transparent 5.2,0,0.5,0.2 Arial,8 e94fbb09cacd462b9fc21ae958198bd0 Right 0,0,0,0 Text10 {VwInvoice.Total} Black Expression Center Transparent 5.7,0,0.5,0.2 Arial,8 4ca046344f0f46b68c4983a14cadb9aa Right 0,0,0,0 Text11 {VwInvoice.TotalItemTaxes} Black Expression Center Transparent 6.2,0,0.5,0.2 Arial,8 05eb390c86aa418bb6afde48ad160691 Right 0,0,0,0 Text12 {VwInvoice.TotalOfItems} Black Expression Center Transparent 6.7,0,0.5,0.2 Arial,8 5a43e8b2e7b947898180b36a590de2c9 Right 0,0,0,0 Text13 {decInvoiceProfit} Black Expression Center Transparent 1.8,0,2.1,0.2 Arial,8 Center 0,0,0,0 Text15 {VwCustomerSubAccount.CustomerSubAccountName} Black Expression Center VwInvoice _x007B__x0028_p_intWhichInvoice_x0020__x003D__x003D__x0020_1_x0020__x003F__x0020_0_x0020__x003C__x0020_VwInvoice.AmountDue_x0020_:_x0020_p_intWhichInvoice_x0020__x003D__x003D__x0020_2_x0020__x003F__x0020_VwInvoice.AmountDue_x0020__x003D__x003D__x0020_0_x0020_:_x0020_1_x0020__x003D__x003D__x0020_1_x0029__x007D_ _x007B__x0028_p_dtInvoiceBegin_x0020__x003C__x0020_VwInvoice.InvoiceDate_x0020__x0026__x0026__x0020_VwInvoice.InvoiceDate_x0020__x003C__x0020_p_dtInvoiceEnd_x0029__x007D_ DataBand1 Style1 Transparent 0,2.2,7.72,0.6 Transparent 3.9,0,1,0.2 Arial,8 Right 0,0,0,0 Text16 Grand totals: Black Center Transparent 5.2,0,0.5,0.2 Arial,8 569c30c7f66f4271a3561f766e9365dd Right 0,0,0,0 txtFooterGrossWTax {Sum(VwInvoice.Total)} Black Expression Center Transparent 7.2,0,0.5,0.2 Arial,8 6816f53ecbc44c04b3a4fb2f9e4368f0 Right 0,0,0,0 txtGrossMargin {Sum(IIF(blnUseMarkupCost,decMarkup,decMargin))} Black Expression Center Transparent 5.7,0,0.5,0.2 Arial,8 c5398356003044908a5690be684ea47c Right 0,0,0,0 txtFooterGrossTax {Sum(VwInvoice.TotalItemTaxes)} Black Expression Center Transparent 6.2,0,0.5,0.2 Arial,8 ec4f9d1e41634625aa7a0324e7c4ef8d Right 0,0,0,0 txtFooterGrandTotalWoTax {Sum(VwInvoice.TotalOfItems)} Black Expression Center Transparent 6.7,0,0.5,0.2 Arial,8 22be97980c11469b8bac6db9b8cec829 Right 0,0,0,0 txtGrossProfit {Sum(decInvoiceProfit)} Black Expression Center Transparent 2.8,0.2,2.1,0.2 Arial,8 Right 0,0,0,0 Text22 Less deposits applied to charge sales: Black Expression Center Bottom;Black;1;Solid;False;4;Black Transparent 5.2,0.2,0.5,0.2 Arial,8 a8e8686e6bb740b09ccf9bf58dfe357b Right 0,0,0,0 txtFooterTotalDiscount {Sum(VwInvoice.DiscountExceptionAmount)} Black Expression Center Bottom;Black;1;Solid;False;4;Black Transparent 6.2,0.2,0.5,0.2 Arial,8 f0668cac97b44c1ca68ca9f75b98b99a Right 0,0,0,0 txtFooterTotalDiscount2 {Sum(VwInvoice.DiscountableTotal)} Black Expression Center Transparent 6.7,0.2,1,0.2 Arial,8 0,0,0,0 Text25 Imm. Discount Black Expression Center Transparent 0,0.4,1.8,0.2 Arial,8 Right 0,0,0,0 Text26 Early pay discounts allowed: Black Expression Center Transparent 1.8,0.4,0.6,0.2 Arial,8 0,0,0,0 Text27 {VwInvoice.EarlyPayDiscountAmt} Black Expression Center Transparent 5.2,0.4,0.5,0.2 Arial,8 3e7401dac84e4779a79af65bd4c092cd Right 0,0,0,0 txtFooterGrossWithDiscount {Sum(VwInvoice.Total) - Sum(VwInvoice.DiscountExceptionAmount)} Black Expression Center Transparent 6.2,0.4,0.5,0.2 Arial,8 0c00317eae9048e991014f3fb53884ac Right 0,0,0,0 txtFooterGrossSales {Sum(VwInvoice.TotalOfItems) - Sum(VwInvoice.DiscountableTotal)} Black Expression Center Transparent 6.7,0.4,1,0.2 Arial,8 7937a40f24fa48cb9a422ebbb179c169 0,0,0,0 Text30 Gross w/discount Black Expression Center FooterBand1 Transparent True 0,3.2,7.72,4.4 Transparent 0,0,1.8,0.2 Arial,8 003cd50dd942421eadf586e660122422 Right 0,0,0,0 lblCashInvoiceTotalCount Number of cash sales: Black Expression Center Transparent 1.8,0,0.6,0.2 Arial,8 3bd5c97ce55c42daa45ce0b3f6c455fe 0,0,0,0 txtCashInvoiceTotalCount {Count(DataBand1, VwInvoice.AmountDue == 0)} Black Expression Center Transparent 0,0.2,1.8,0.2 Arial,8 bb35b01b5d1c49caa4e69d382b71a326 Right 0,0,0,0 lblChargeInvoiceTotalCount Charged sales: Black Expression Center Bottom;Black;1;Solid;False;4;Black Transparent 1.8,0.2,0.6,0.2 Arial,8 f55fcdd9bd784beb8c646fe188543602 0,0,0,0 txtChargeInvoiceTotalCount {Count(DataBand1, VwInvoice.AmountDue != 0)} Black Expression Center Transparent 2.8,0,1.8,0.2 Arial,8 766877166e8640eb84fd463912159467 Right 0,0,0,0 lblCashInvoiceTotal Cash invoice total: Black Expression Center Transparent 4.6,0,0.6,0.2 Arial,8 1810d9cc95064d109983e33cecc6228e 0,0,0,0 txtCashInvoiceTotal {Sum(DataBand1, VwInvoice.AmountDue == 0 ? VwInvoice.Total : 0)} Black Expression Center Transparent 2.8,0.2,1.8,0.2 Arial,8 bdd74b09257f4ddb9bcee5db81d1d6a6 Right 0,0,0,0 lblChargeInvoiceTotal Charge invoice total: Black Expression Center Bottom;Black;1;Solid;False;4;Black Transparent 4.6,0.2,0.6,0.2 Arial,8 069145e9c8f94cf1b773aca930c4fb27 0,0,0,0 txtChargeInvoiceTotal {Sum(DataBand1, VwInvoice.AmountDue != 0 ? VwInvoice.Total : 0)} Black Expression Center Transparent 2.8,0.4,1.8,0.2 Arial,8 576f8541f8b940a2824809755d388725 Right 0,0,0,0 lblGrandInvoiceTotal Grand total received: Black Expression Center Transparent 4.6,0.4,0.6,0.2 Arial,8 65df47f54e7d454da5f5370a8e759ec2 0,0,0,0 txtGrandInvoiceTotal {Sum(DataBand1, VwInvoice.Total)} Black Expression Center Transparent 0,0.4,1.8,0.2 Arial,8 47c38436c80e4a58842a648d863cc409 Right 0,0,0,0 lblGrandInvoiceTotalCount Total transactions: Black Expression Center Transparent 1.8,0.4,0.6,0.2 Arial,8 e781a2888db74b1eb0ebc7555e1e9a08 0,0,0,0 txtGrandInvoiceTotalCount {Count(DataBand1, VwInvoice.AmountDue == 0) + Count(DataBand1, VwInvoice.AmountDue != 0)} Black Expression Center ReportSummaryBand1 f77457a294b4443c8e1f6fc57ef6259d 0.39,0.39,0.39,0.39 Page1 11 8.5 Letter Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 2/14/2016 3:15:05 AM 2/10/2016 1:41:35 PM D:\SalesRegisterReport.mrt 3122f61897cf4c2896bd3b24add88b1e Report Inches 2015.3.4 CSharp Ivory Arial,8 Style1 Black