protected sealed override void CheckProperties(IUpdateVisitor visitor) { _StockGroupID.Welcome(visitor, "StockGroupID", "Int NOT NULL", false); _StockGroupName.Welcome(visitor, "StockGroupName", "NVarChar(50) NOT NULL", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _ValidFrom.Welcome(visitor, "ValidFrom", "DateTime2(7) NOT NULL", false); _ValidTo.Welcome(visitor, "ValidTo", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _ColdRoomSensorNumber.Welcome(visitor, "ColdRoomSensorNumber", "Int NOT NULL", false); _RecordedWhen.Welcome(visitor, "RecordedWhen", "DateTime2(7) NOT NULL", false); _Temperature.Welcome(visitor, "Temperature", "Decimal(10,2) NOT NULL", false); _ValidFrom.Welcome(visitor, "ValidFrom", "DateTime2(7) NOT NULL", false); _ValidTo.Welcome(visitor, "ValidTo", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _StockItemStockGroupID.Welcome(visitor, "StockItemStockGroupID", "Int NOT NULL", false); _StockItemID.Welcome(visitor, "StockItemID", "Int NOT NULL", false); _StockGroupID.Welcome(visitor, "StockGroupID", "Int NOT NULL", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _LastEditedWhen.Welcome(visitor, "LastEditedWhen", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _CityID.Welcome(visitor, "CityID", "Int NOT NULL", false); _CityName.Welcome(visitor, "CityName", "NVarChar(50) NOT NULL", false); _StateProvinceID.Welcome(visitor, "StateProvinceID", "Int NOT NULL", false); _LatestRecordedPopulation.Welcome(visitor, "LatestRecordedPopulation", "BigInt", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _ValidFrom.Welcome(visitor, "ValidFrom", "DateTime2(7) NOT NULL", false); _ValidTo.Welcome(visitor, "ValidTo", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _VehicleRegistration.Welcome(visitor, "VehicleRegistration", "NVarChar(20) NOT NULL", false); _ChillerSensorNumber.Welcome(visitor, "ChillerSensorNumber", "Int NOT NULL", false); _RecordedWhen.Welcome(visitor, "RecordedWhen", "DateTime2(7) NOT NULL", false); _Temperature.Welcome(visitor, "Temperature", "Decimal(10,2) NOT NULL", false); _FullSensorData.Welcome(visitor, "FullSensorData", "NVarChar(1000)", false); _IsCompressed.Welcome(visitor, "IsCompressed", "Bit NOT NULL", false); _CompressedSensorData.Welcome(visitor, "CompressedSensorData", "VarBinary(MAX)", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _StockItemID.Welcome(visitor, "StockItemID", "Int NOT NULL", false); _QuantityOnHand.Welcome(visitor, "QuantityOnHand", "Int NOT NULL", false); _BinLocation.Welcome(visitor, "BinLocation", "NVarChar(20) NOT NULL", false); _LastStocktakeQuantity.Welcome(visitor, "LastStocktakeQuantity", "Int NOT NULL", false); _LastCostPrice.Welcome(visitor, "LastCostPrice", "Decimal(18,2) NOT NULL", false); _ReorderLevel.Welcome(visitor, "ReorderLevel", "Int NOT NULL", false); _TargetStockLevel.Welcome(visitor, "TargetStockLevel", "Int NOT NULL", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _LastEditedWhen.Welcome(visitor, "LastEditedWhen", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _StockItemTransactionID.Welcome(visitor, "StockItemTransactionID", "Int NOT NULL", false); _StockItemID.Welcome(visitor, "StockItemID", "Int NOT NULL", false); _TransactionTypeID.Welcome(visitor, "TransactionTypeID", "Int NOT NULL", false); _CustomerID.Welcome(visitor, "CustomerID", "Int", false); _InvoiceID.Welcome(visitor, "InvoiceID", "Int", false); _SupplierID.Welcome(visitor, "SupplierID", "Int", false); _PurchaseOrderID.Welcome(visitor, "PurchaseOrderID", "Int", false); _TransactionOccurredWhen.Welcome(visitor, "TransactionOccurredWhen", "DateTime2(7) NOT NULL", false); _Quantity.Welcome(visitor, "Quantity", "Decimal(18,3) NOT NULL", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _LastEditedWhen.Welcome(visitor, "LastEditedWhen", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _PurchaseOrderLineID.Welcome(visitor, "PurchaseOrderLineID", "Int NOT NULL", false); _PurchaseOrderID.Welcome(visitor, "PurchaseOrderID", "Int NOT NULL", false); _StockItemID.Welcome(visitor, "StockItemID", "Int NOT NULL", false); _OrderedOuters.Welcome(visitor, "OrderedOuters", "Int NOT NULL", false); _Description.Welcome(visitor, "Description", "NVarChar(100) NOT NULL", false); _ReceivedOuters.Welcome(visitor, "ReceivedOuters", "Int NOT NULL", false); _PackageTypeID.Welcome(visitor, "PackageTypeID", "Int NOT NULL", false); _ExpectedUnitPricePerOuter.Welcome(visitor, "ExpectedUnitPricePerOuter", "Decimal(18,2)", false); _LastReceiptDate.Welcome(visitor, "LastReceiptDate", "Date", false); _IsOrderLineFinalized.Welcome(visitor, "IsOrderLineFinalized", "Bit NOT NULL", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _LastEditedWhen.Welcome(visitor, "LastEditedWhen", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _PurchaseOrderID.Welcome(visitor, "PurchaseOrderID", "Int NOT NULL", false); _SupplierID.Welcome(visitor, "SupplierID", "Int NOT NULL", false); _OrderDate.Welcome(visitor, "OrderDate", "Date NOT NULL", false); _DeliveryMethodID.Welcome(visitor, "DeliveryMethodID", "Int NOT NULL", false); _ContactPersonID.Welcome(visitor, "ContactPersonID", "Int NOT NULL", false); _ExpectedDeliveryDate.Welcome(visitor, "ExpectedDeliveryDate", "Date", false); _SupplierReference.Welcome(visitor, "SupplierReference", "NVarChar(20)", false); _IsOrderFinalized.Welcome(visitor, "IsOrderFinalized", "Bit NOT NULL", false); _Comments.Welcome(visitor, "Comments", "NVarChar(MAX)", false); _InternalComments.Welcome(visitor, "InternalComments", "NVarChar(MAX)", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _LastEditedWhen.Welcome(visitor, "LastEditedWhen", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _OrderLineID.Welcome(visitor, "OrderLineID", "Int NOT NULL", false); _OrderID.Welcome(visitor, "OrderID", "Int NOT NULL", false); _StockItemID.Welcome(visitor, "StockItemID", "Int NOT NULL", false); _Description.Welcome(visitor, "Description", "NVarChar(100) NOT NULL", false); _PackageTypeID.Welcome(visitor, "PackageTypeID", "Int NOT NULL", false); _Quantity.Welcome(visitor, "Quantity", "Int NOT NULL", false); _UnitPrice.Welcome(visitor, "UnitPrice", "Decimal(18,2)", false); _TaxRate.Welcome(visitor, "TaxRate", "Decimal(18,3) NOT NULL", false); _PickedQuantity.Welcome(visitor, "PickedQuantity", "Int NOT NULL", false); _PickingCompletedWhen.Welcome(visitor, "PickingCompletedWhen", "DateTime2(7)", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _LastEditedWhen.Welcome(visitor, "LastEditedWhen", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _SystemParameterID.Welcome(visitor, "SystemParameterID", "Int NOT NULL", false); _DeliveryAddressLine1.Welcome(visitor, "DeliveryAddressLine1", "NVarChar(60) NOT NULL", false); _DeliveryAddressLine2.Welcome(visitor, "DeliveryAddressLine2", "NVarChar(60)", false); _DeliveryCityID.Welcome(visitor, "DeliveryCityID", "Int NOT NULL", false); _DeliveryPostalCode.Welcome(visitor, "DeliveryPostalCode", "NVarChar(10) NOT NULL", false); _PostalAddressLine1.Welcome(visitor, "PostalAddressLine1", "NVarChar(60) NOT NULL", false); _PostalAddressLine2.Welcome(visitor, "PostalAddressLine2", "NVarChar(60)", false); _PostalCityID.Welcome(visitor, "PostalCityID", "Int NOT NULL", false); _PostalPostalCode.Welcome(visitor, "PostalPostalCode", "NVarChar(10) NOT NULL", false); _ApplicationSettings.Welcome(visitor, "ApplicationSettings", "NVarChar(MAX) NOT NULL", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _LastEditedWhen.Welcome(visitor, "LastEditedWhen", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _InvoiceLineID.Welcome(visitor, "InvoiceLineID", "Int NOT NULL", false); _InvoiceID.Welcome(visitor, "InvoiceID", "Int NOT NULL", false); _StockItemID.Welcome(visitor, "StockItemID", "Int NOT NULL", false); _Description.Welcome(visitor, "Description", "NVarChar(100) NOT NULL", false); _PackageTypeID.Welcome(visitor, "PackageTypeID", "Int NOT NULL", false); _Quantity.Welcome(visitor, "Quantity", "Int NOT NULL", false); _UnitPrice.Welcome(visitor, "UnitPrice", "Decimal(18,2)", false); _TaxRate.Welcome(visitor, "TaxRate", "Decimal(18,3) NOT NULL", false); _TaxAmount.Welcome(visitor, "TaxAmount", "Decimal(18,2) NOT NULL", false); _LineProfit.Welcome(visitor, "LineProfit", "Decimal(18,2) NOT NULL", false); _ExtendedPrice.Welcome(visitor, "ExtendedPrice", "Decimal(18,2) NOT NULL", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _LastEditedWhen.Welcome(visitor, "LastEditedWhen", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _CountryID.Welcome(visitor, "CountryID", "Int NOT NULL", false); _CountryName.Welcome(visitor, "CountryName", "NVarChar(60) NOT NULL", false); _FormalName.Welcome(visitor, "FormalName", "NVarChar(60) NOT NULL", false); _IsoAlpha3Code.Welcome(visitor, "IsoAlpha3Code", "NVarChar(3)", false); _IsoNumericCode.Welcome(visitor, "IsoNumericCode", "Int", false); _CountryType.Welcome(visitor, "CountryType", "NVarChar(20)", false); _LatestRecordedPopulation.Welcome(visitor, "LatestRecordedPopulation", "BigInt", false); _Continent.Welcome(visitor, "Continent", "NVarChar(30) NOT NULL", false); _Region.Welcome(visitor, "Region", "NVarChar(30) NOT NULL", false); _Subregion.Welcome(visitor, "Subregion", "NVarChar(30) NOT NULL", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _ValidFrom.Welcome(visitor, "ValidFrom", "DateTime2(7) NOT NULL", false); _ValidTo.Welcome(visitor, "ValidTo", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _SpecialDealID.Welcome(visitor, "SpecialDealID", "Int NOT NULL", false); _StockItemID.Welcome(visitor, "StockItemID", "Int", false); _CustomerID.Welcome(visitor, "CustomerID", "Int", false); _BuyingGroupID.Welcome(visitor, "BuyingGroupID", "Int", false); _CustomerCategoryID.Welcome(visitor, "CustomerCategoryID", "Int", false); _StockGroupID.Welcome(visitor, "StockGroupID", "Int", false); _DealDescription.Welcome(visitor, "DealDescription", "NVarChar(30) NOT NULL", false); _StartDate.Welcome(visitor, "StartDate", "Date NOT NULL", false); _EndDate.Welcome(visitor, "EndDate", "Date NOT NULL", false); _DiscountAmount.Welcome(visitor, "DiscountAmount", "Decimal(18,2)", false); _DiscountPercentage.Welcome(visitor, "DiscountPercentage", "Decimal(18,3)", false); _UnitPrice.Welcome(visitor, "UnitPrice", "Decimal(18,2)", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _LastEditedWhen.Welcome(visitor, "LastEditedWhen", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _CustomerTransactionID.Welcome(visitor, "CustomerTransactionID", "Int NOT NULL", false); _CustomerID.Welcome(visitor, "CustomerID", "Int NOT NULL", false); _TransactionTypeID.Welcome(visitor, "TransactionTypeID", "Int NOT NULL", false); _InvoiceID.Welcome(visitor, "InvoiceID", "Int", false); _PaymentMethodID.Welcome(visitor, "PaymentMethodID", "Int", false); _TransactionDate.Welcome(visitor, "TransactionDate", "Date NOT NULL", false); _AmountExcludingTax.Welcome(visitor, "AmountExcludingTax", "Decimal(18,2) NOT NULL", false); _TaxAmount.Welcome(visitor, "TaxAmount", "Decimal(18,2) NOT NULL", false); _TransactionAmount.Welcome(visitor, "TransactionAmount", "Decimal(18,2) NOT NULL", false); _OutstandingBalance.Welcome(visitor, "OutstandingBalance", "Decimal(18,2) NOT NULL", false); _FinalizationDate.Welcome(visitor, "FinalizationDate", "Date", false); _IsFinalized.Welcome(visitor, "IsFinalized", "Bit", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _LastEditedWhen.Welcome(visitor, "LastEditedWhen", "DateTime2(7) NOT NULL", false); }
protected sealed override void CheckProperties(IUpdateVisitor visitor) { _OrderID.Welcome(visitor, "OrderID", "Int NOT NULL", false); _CustomerID.Welcome(visitor, "CustomerID", "Int NOT NULL", false); _SalespersonPersonID.Welcome(visitor, "SalespersonPersonID", "Int NOT NULL", false); _PickedByPersonID.Welcome(visitor, "PickedByPersonID", "Int", false); _ContactPersonID.Welcome(visitor, "ContactPersonID", "Int NOT NULL", false); _BackorderOrderID.Welcome(visitor, "BackorderOrderID", "Int", false); _OrderDate.Welcome(visitor, "OrderDate", "Date NOT NULL", false); _ExpectedDeliveryDate.Welcome(visitor, "ExpectedDeliveryDate", "Date NOT NULL", false); _CustomerPurchaseOrderNumber.Welcome(visitor, "CustomerPurchaseOrderNumber", "NVarChar(20)", false); _IsUndersupplyBackordered.Welcome(visitor, "IsUndersupplyBackordered", "Bit NOT NULL", false); _Comments.Welcome(visitor, "Comments", "NVarChar(MAX)", false); _DeliveryInstructions.Welcome(visitor, "DeliveryInstructions", "NVarChar(MAX)", false); _InternalComments.Welcome(visitor, "InternalComments", "NVarChar(MAX)", false); _PickingCompletedWhen.Welcome(visitor, "PickingCompletedWhen", "DateTime2(7)", false); _LastEditedBy.Welcome(visitor, "LastEditedBy", "Int NOT NULL", false); _LastEditedWhen.Welcome(visitor, "LastEditedWhen", "DateTime2(7) NOT NULL", false); }