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);
}