iVend Database Database > Tables > CfgEnterprise Table

Navigation: iVend Database Database > Tables >

iVend 6.6 Database Help

CfgEnterprise Table

Collapse All Expand All

iVend Database Database : CfgEnterprise Table

Description

Stores the basic configuration entries for the system . These settings are mandatory for the system to work properly.

Properties

Creation Date	4/13/2015 12:00 PM
File Group	PRIMARY
Text File Group	PRIMARY
System Object
Published for Replication
Rows	1
Data Space Used	8.00 KB
Index Space Used	8.00 KB

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
EnterpriseKey	Value is the system generated Primary Key of the table.	VarWChar	50
CompanyName	Value is the company name for which iVend will function.	VarWChar	50
AddressKey	Value is the address of the company.	VarWChar	50
SellTaxCodeKey	Refers to the sales tax code key.See also Tax	VarWChar	50
PurchaseTaxCodeKey	Refers to the purchase tax code key.See also Tax	VarWChar	50
FederalTaxId	Value is the unique id of the company e.g. SSN , used in selected countries like USA.	VarWChar	50
RetailProfileKey	Value is the retail profile key i.e. the enterprise profile which has entries about how the retail stores will actual carry out their functions. E.g. ManagerOverrideRequiredForCreditLimitOverride and MaxSaleDiscountAllowed.	VarWChar	50
AllowNegativeInventory	Value is true if the negative inventory transactions are allowed at POS else false.	Boolean	1
ERPSystemType	Store the ERP system type with iVend is integrated to. Valid values are: SAPBusinessOne = 1	Integer	4
Localization	Localization under which the system works. This setting should match with the Localization setting in the ERP system (i.e SAP Business One). SAPBusinessOne = 1 USA = 1 UK = 2 AUSTRALIA = 3 INDIA = 4 CANADA = 5 SINGAPORE = 6	Integer	4
RoundingType	Value is the rounding type to be used in system for numeric values. Supported modes are: RoundUp = 0 RoundDown = 1 RoundToNearest = 2	Integer	4
CheckCustomerCreditLimit	Value is true if the customer credit limit of a customer has to be checked by the system before carrying out any OnAccount transaction at POS. If false then no check is required.	Boolean	1
LogoData	Company Logo	LongVarBinary	16
CreatedBy	Reference of user who has created this record. See also Security User	VarWChar	50
Created	Date of creation of this record	DBTimeStamp	4
ModifiedBy	Reference of user who has modified this record. See also Security User	VarWChar	50
Modified	Date of last modification of this record	DBTimeStamp	4
PricingResolution	Value is price resolution method for a product while doing transaction as POS. Valid values are: None = 0 ResolvedToLowest = 1 ResolvedToHighest = 2	Integer	4
ShowProductListByVendor	Check for shown prduct list according to vendor.	Boolean	1
UseTransactionConsolidation	Check for using trnsaction consolidation.	Boolean	1
UseCashCustomerForConsolidation	Check for using cash customer for transaction consolidation	Boolean	1
RollupIntervalType	User can specify the processing of the job based on daily basis or based on the hour interval.	Integer	4
RollupInterval	Select this to enable transaction rollup in iVend. One invoice per store/ per customer/ per business day will be posted in SAP business one. The user would be able to turn on this setting any time, even after the system is live. Once this setting is checked then user would not be allowed to change it.	Integer	4
UseInterstoreTransaction	The flag specifies if the system is setup for the interstore transactions allowing sale and refund from different stores	Boolean	1		((0))
UseSerialBasedPricing	The flag sepcifies if the system uses the price specified for the individual serial and batches instead of using the product price	Boolean	1		((0))
SaleDiscountAfterTax	If this flag is checked then system will apply the same level discount on the Sale Total After Tax else the system will apply the same discount on Sale Total Before Tax. For e.g. Sale Total Before Tax (A)= $100 Tax Percent (B)= 10% Sale Discount (C) = $10 Scenario 1: Sale Discount On Sale Total After Tax Sale Total Before Discount (D)= A + (A(B)/100) = 110 Sale Total = D C = 110 10 = 100 Scenario 2: Sale Discount On Sale Total Before Tax Sale Total Before Discount (D) = A C = 100 10 = 90 Sale Total = D + (DB/100) = 99	Boolean	1		((0))
IgnoreDiscountItemsForSaleDiscount	If this flag is checked then sale discount would not be applied on the items for which the line level discount is given.	Boolean	1		((0))
AllowMultipleTransactionMode	The setting specifies, if cashier can combine multiple type of transaction in a single transaction at POS. e.g. doing sale and sales order in a single transaction	Boolean	1		((1))
AllowMultipleSalesPersonOnItem	The setting specifies, if multiple sales person can be allowed in a single transaction at POS.	Boolean	1		((0))
IsLoyaltyEnabled	The setting specifies, if the Loyalty module is enabled or not	Boolean	1		((0))
LoyaltyServiceEndPoint	Defines the Loyalty Service endpoint (where the service is hosted) to work with the iVend.	VarWChar	1000
OpenSalesAttributeAutomatically	The setting specifies, if to open the Attribute collection screen at the POS automatically or not while starting a new transaction.	Boolean	1		((1))
ApplyLayawayOnSale	The setting specifies, if the all the items in a transaction are to be treated as a single layways transaction or not. By default this flag is false which indicates that all the items in a layaway are separate layaway documents.	Boolean	1		((0))
CollectSaleOrderAdvance	The setting specifies, if it is mandatory to take all the payments in advance for the sales orders that are being raised from POS	Boolean	1		((0))
RoundAmountInInvoice	Flag for specifying that if the rounding of the invoices are to be done in SAP B1. By default this setting is set to False which means that the invoices are not rounded off in SAP Business One	Boolean	1		((0))
IsClubEnabled	Future Use	Boolean	1		((0))
ClubServiceEndPoint	Future Use	VarWChar	200
ClubUserId	Future Use	VarWChar	50
ClubPassword	Future Use	VarWChar	50
AllowGiftCertificateSaleRedemption	Value is true if system will allow cashier to sell and redeem the Gift Card/ Certificate in the same transaction.	Boolean	1		((0))
CanDeliverFromGeneralWarehouse	Value is True if the user want to capture the Sales/Order at Store which are to be delivered from General Warehouse from SAP Business One	Boolean	1		((0))
ParticipateInUserExperience	Value is True if the system is allowed to send the performance data anonymously. For more detail please read the End User License Agreement of iVend.	Boolean	1		((0))
RollupOnlyCashCustomerInvoices	Value is true if the invoices generated for Cash Customer would be rolled up by the iVend.	Boolean	1		((0))
IsPassbookIntegrated	Value is true if the iVend Pass is integrated.	Boolean	1		((0))
AllowPriceChangeInGRPO	Value is true if users are allowed to change the price of an item while doing a goods receipt against a purchase order.	Integer	4		((0))
SmtpServerHost	Defines the detail of the SMTP Sever Host (IP address)	VarWChar	1000
SmtpUserName	Defines the detail of the SMTP Sever User Name	VarWChar	500
SmtpUserPassword	Defines the detail of the SMTP Sever User Password	VarWChar	500
SmtpServerPort	Defines the detail of the SMTP Sever Port	Integer	4
SmtpServerEnableSSL	Sets the value as True / False, if the Smtp Server supports SSL.	Boolean	1
Email	Defines the Default Email of the sender	VarWChar	100
AutoSelectSerialBatchType	Value is True if the Serial/ Batch should be selected automatically based on dfined criteria	Integer	4		((0))
TransactionServerType	Obselete	Integer	4
ApiServerEnableSSL	Value is True if the Transaction Server has SSL Enabled else False	Boolean	1
ApiServerAdvanceSetting	Value is True if the complete Transaction Server URL has been provided	Boolean	1
ApiServerAddress	Stores the API server address	VarWChar	100
AllowPartialReceivingOfInventory	Value is True if the application allows the partial receiving of the Inventory	Boolean	1		((1))
CompanyId	Value is the Company Id for the Cloud	VarWChar	20
IsTrxServerIntegrated	Value is True is the Transaction sever is available with the iVend	Boolean	1		((0))
TransactionSearchType	Stores the value based on which the Transaction needs to be search. Valid values are: All = 0, Sale = 1, Refund = 2, Exchange = 3, Order = 4, Layaway = 5, Quotation = 6, Delivery = 7, OnAccount = 8, LostSale = 9, GiftCertificate = 10, CouponIssue = 11	Integer	4
TransactionRecordsCount	Stores the count of the records fetched from Transaction server	Integer	4		((500))
ExchangeTransactionDataBetweenStore	Value is True if the Transaction at one store can be sent to other stores	Boolean	1		((0))
FontName	Font Name required for the application	VarWChar	100
ReplicationBatchSize	Value is the Batch size used by the Replication for the data movement	Integer	4		((5000))
AllowUserDefinedProductId	Value is True if the user is allowed to Define the Product ID manually	Boolean	1		((0))
ExpiryDateRequiredForBatch	Value is True if the Expiry date is required for Batch	Boolean	1
ExpiryDateRequiredForSerial	Value is True if the Expiry date is required for Serial	Boolean	1
ManageStoreWiseExchangeRates	Value is True if the Exchange Rates to be managed storewise	Boolean	1
IsBranchEnabled	Value is True if the Branch mode is enabled in iVend	Boolean	1		((0))
AllowAddItemInGoodReturnForGRPO	Value is True if the product is allowed to Add in GRPO while return	Boolean	1
AllowBackDateAtEndOfDay	Value is True if the user can use previous date while doing the End of Day	Boolean	1
AllowDuplicateBarCode	Value is True if the product is allowed to have same Barcode	Boolean	1
EnableSMSNotification	Value is True if the SMS Notification is enabled	Boolean	1
SMSGateway	Stores the SMS Gateway information	VarWChar	200
Location	Value is the path where the assemblies can be found.	VarWChar	500
AssemblyName	Stores the Assembly name	VarWChar	500
ClassName	Stores the Class name for the Assembly	VarWChar	500
ConfigData	Specifies configuration data.	LongVarWChar	16
CompanyTimeZoneId	Stores the Company Time Zone	VarWChar	100
CompanyTimeZoneOffSetInMinutes	Stores the Company Time Zone Off Set	Numeric	9 (20,5)
AssignCustomerToAllBranch	Value is True if the Customer is assigned to all Stores	Boolean	1		((0))
UseAdvanceAuthorization	Value is true if the Multilevel user authentication has to be used in the application with the manager override	Boolean	1		((0))
CultureInfo	Value is the culture info that is attached with an enterprise	VarWChar	20
AllowOverReceivingInGRPO	Hold true if system will allow to receive more inventories in GRPO	Boolean	1
AllowOverReceivingInStockTransfer	Hold true if system will allow to receive more inventories against stock transfer	Boolean	1
EnableLocation	Hold true if System will allow to maintain inventories location wise	Boolean	1
IsMultipleSubsidiaryEnabled	Value is true if the Multiple Subsidiary feature is enabled	Boolean	1
AllowGCRedemptionAcrossSubsidiaries	Value is true if the Gifet Certificates are available for redemption across all subsidiaries	Boolean	1
AllowLoyaltyAcrossSubsidiaries	Value is True if the Loyalty can be used with Subsidiaries	Boolean	1
EnableLogReplication	Value if True if the Replication log has to be enable. This check will allow the replication to start logging the replication events in detail.	Boolean	1
AssignCustomersToAllSubsidiary	Flag to check whether new customers created from Store is assigned to All subsidiaries	Boolean	1		((0))
InventoryCountMergeDateType	Stores the Counting Date in case the Invnetory Counts are Merged Valid values are: CurrentDate = 0 EarliestDate = 1 LatestDate = 2	Integer	4		((0))
AllowZeroPrice	Value is True if the user would allow selling of an item at 0 price at POS. This value is defauled to the product when the product is being defined in the system. User can change the value of the Product Level. Please refer to InvProduct for more details.	Boolean	1		((1))
InventoryReplicationInStoreGroup	Value is True if the invnetory updates are to be sent only within the stores belonging to the store group. This setting would ensure that data replication of the invntory happens within store group.	Boolean	1		((0))
ValidateTransactionOnRefund	Flag to check whether to validate transaction on refund from transaction server if transaction server configured.	Boolean	1
NoOfDaysForQuotationValidity		Integer	4		((1))
AllowExpiredQuotationConversion		Boolean	1		((1))
SODeliveryMinimumPercentPaid		Double	9		((0))
SOMinimumDepositRequired		Double	9		((0))
CreatePerOrderPicklist		Boolean	1		((0))
ReplicateInterStoreInventory		Boolean	1

Indexes

Index	Description	Primary	Unique
PK_CfgEnterprise

Objects that depend on CfgEnterprise

Database Object	Object Type	Description	Dep Level
AssignTill	Stored Procedure	Assigns a Till to the selected POS	2
BarCodeResolution	Stored Procedure		1
BatchLocationQuantityUpdates	Stored Procedure	Used in replication to update the Batch quantities	2
BatchQuantityUpdates	Stored Procedure		2
BreakBuildKit	Stored Procedure		2
CancelStockTransfer	Stored Procedure		2
CustomeLabelReport	Stored Procedure		3
DataNotification	Stored Procedure		1
ExecuteInventoryItemLogUpdate	Stored Procedure		3
GenerateLabelData	Stored Procedure	Generates label data depending on the parameter specified	2
GetCompanyDateTime	User Defined Function		1
GetInventoryItemForStockCount	Stored Procedure		2
GetMobileReplicationData	Stored Procedure		1
GetNextDocumentNumberForPOS	Stored Procedure	Generates the next Transaction Number depending on the Parameters provided	2
GetUserRights	Stored Procedure	Gets the valid rights for the user	1
GetValidPromotionsForProduct	Stored Procedure		2
Integration_ARPayment	Stored Procedure		1
Integration_Transaction	Stored Procedure		1
Integration_TransactionSurcharge	Stored Procedure		1
InventoryItemQuantityUpdates	Stored Procedure		1
InventoryItemSerialStatusUpdates	Stored Procedure		2
InvWarehouseInventoryLocation	Stored Procedure		2
LogAuditInformation	Stored Procedure		2
Loy_GetMonthlyPointSummary	Stored Procedure		2
MRP	Stored Procedure		1
RemoveTill	Stored Procedure	Removes a Till from the selected POS	2
Rpt_ItemWithoutSale	User Defined Function		1
TrgSBOBatchUpdate	Trigger	Handles updates made to Batch table from ERP system (Business One in this case)	3
TrgSBOInventoryUpdate	Trigger	Handles updates made to item inventory in the ERP system (Business One in this case)	2
TrxCompleteTransactionUpdates	Stored Procedure		1
TrxConsolidateTransaction	Stored Procedure		1
TrxConsolidateTransactionForCreditCustomers	Stored Procedure		1
TrxGetLaybyInstallmentPlan	Stored Procedure	Computes the Layaway details like Duration, Starting Date etc for the layaway depending on the Layaway Plan	1
TrxInventoryUpdateBatchNumber	Stored Procedure		2
TrxInventoryUpdateLaybyCancellationItem	Stored Procedure		1
TrxInventoryUpdateLaybyItem	Stored Procedure		1
TrxInventoryUpdateOrder	Stored Procedure	Handles updates related to Order item	2
TrxInventoryUpdatePaymentDiscount	Stored Procedure	Handles updates related to sale item	2
TrxInventoryUpdateQuotation	Stored Procedure	Handles updates related to Quotation item	2
TrxInventoryUpdateSaleDelivery	Stored Procedure	Handles updates related to delivery of a Sale item	2
TrxInventoryUpdateSaleItem	Stored Procedure	Handles updates related to sale item	2
TrxInventoryUpdatesSaleRefund	Stored Procedure	Handles updates related to On Account payments	2
TrxUpdateCustomerBalance	Stored Procedure		1
UpdateTillAmounts	Stored Procedure	Handles updates to Till once payment against a transaction has been taken	2
UseDrawer	Stored Procedure	Creates a valid Till User session depending on the Cash drawer selected by the user	2
uspGetItemPrice	Stored Procedure		1
uspGetItemSpecialPrice	Stored Procedure	Determines the price of the Product for the customer specified and other parameters	1
vw_ProductCost	View		2
ZTapeReport	Stored Procedure		2

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[CfgEnterprise](

[EnterpriseKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[CompanyName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[AddressKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[SellTaxCodeKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[PurchaseTaxCodeKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[FederalTaxId] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[RetailProfileKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[AllowNegativeInventory] [bit] NOT NULL,

[ERPSystemType] [int] NOT NULL,

[Localization] [int] NOT NULL,

[RoundingType] [int] NOT NULL,

[CheckCustomerCreditLimit] [bit] NOT NULL,

[LogoData] [image] NULL,

[CreatedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Created] [datetime] NOT NULL,

[ModifiedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Modified] [datetime] NOT NULL,

[PricingResolution] [int] NOT NULL,

[ShowProductListByVendor] [bit] NOT NULL,

[UseTransactionConsolidation] [bit] NOT NULL,

[UseCashCustomerForConsolidation] [bit] NOT NULL,

[RollupIntervalType] [int] NOT NULL,

[RollupInterval] [int] NOT NULL,

[UseInterstoreTransaction] [bit] NOT NULL,

[UseSerialBasedPricing] [bit] NOT NULL,

[SaleDiscountAfterTax] [bit] NOT NULL,

[IgnoreDiscountItemsForSaleDiscount] [bit] NOT NULL,

[AllowMultipleTransactionMode] [bit] NOT NULL,

[AllowMultipleSalesPersonOnItem] [bit] NOT NULL,

[IsLoyaltyEnabled] [bit] NOT NULL,

[LoyaltyServiceEndPoint] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[OpenSalesAttributeAutomatically] [bit] NOT NULL,

[ApplyLayawayOnSale] [bit] NOT NULL,

[CollectSaleOrderAdvance] [bit] NOT NULL,

[RoundAmountInInvoice] [bit] NOT NULL,

[IsClubEnabled] [bit] NOT NULL,

[ClubServiceEndPoint] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ClubUserId] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ClubPassword] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AllowGiftCertificateSaleRedemption] [bit] NOT NULL,

[CanDeliverFromGeneralWarehouse] [bit] NOT NULL,

[ParticipateInUserExperience] [bit] NOT NULL,

[RollupOnlyCashCustomerInvoices] [bit] NOT NULL,

[IsPassbookIntegrated] [bit] NOT NULL,

[AllowPriceChangeInGRPO] [int] NOT NULL,

[SmtpServerHost] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[SmtpUserName] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[SmtpUserPassword] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[SmtpServerPort] [int] NULL,

[SmtpServerEnableSSL] [bit] NULL,

[Email] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AutoSelectSerialBatchType] [int] NULL,

[TransactionServerType] [int] NULL,

[ApiServerEnableSSL] [bit] NULL,

[ApiServerAdvanceSetting] [bit] NULL,

[ApiServerAddress] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AllowPartialReceivingOfInventory] [bit] NOT NULL,

[CompanyId] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[IsTrxServerIntegrated] [bit] NULL,

[TransactionSearchType] [int] NULL,

[TransactionRecordsCount] [int] NULL,

[ExchangeTransactionDataBetweenStore] [bit] NULL,

[FontName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ReplicationBatchSize] [int] NOT NULL,

[AllowUserDefinedProductId] [bit] NULL,

[ExpiryDateRequiredForBatch] [bit] NULL,

[ExpiryDateRequiredForSerial] [bit] NULL,

[ManageStoreWiseExchangeRates] [bit] NULL,

[IsBranchEnabled] [bit] NULL,

[AllowAddItemInGoodReturnForGRPO] [bit] NULL,

[AllowBackDateAtEndOfDay] [bit] NULL,

[AllowDuplicateBarCode] [bit] NULL,

[EnableSMSNotification] [bit] NULL,

[SMSGateway] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Location] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AssemblyName] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ClassName] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ConfigData] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CompanyTimeZoneId] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CompanyTimeZoneOffSetInMinutes] [decimal](20, 5) NULL,

[AssignCustomerToAllBranch] [bit] NULL,

[UseAdvanceAuthorization] [bit] NULL,

[CultureInfo] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AllowOverReceivingInGRPO] [bit] NULL,

[AllowOverReceivingInStockTransfer] [bit] NULL,

[EnableLocation] [bit] NULL,

[IsMultipleSubsidiaryEnabled] [bit] NULL,

[AllowGCRedemptionAcrossSubsidiaries] [bit] NULL,

[AllowLoyaltyAcrossSubsidiaries] [bit] NULL,

[EnableLogReplication] [bit] NULL,

[AssignCustomersToAllSubsidiary] [bit] NULL,

[InventoryCountMergeDateType] [int] NULL,

[AllowZeroPrice] [bit] NOT NULL,

[InventoryReplicationInStoreGroup] [bit] NULL,

[ValidateTransactionOnRefund] [bit] NULL,

[NoOfDaysForQuotationValidity] [int] NULL,

[AllowExpiredQuotationConversion] [bit] NULL,

[SODeliveryMinimumPercentPaid] [float] NOT NULL,

[SOMinimumDepositRequired] [float] NOT NULL,

[CreatePerOrderPicklist] [bit] NULL,

[ReplicateInterStoreInventory] [bit] NULL,

CONSTRAINT [PK_CfgEnterprise] PRIMARY KEY CLUSTERED

(

[EnterpriseKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_UseInterstoreTransaction] DEFAULT ((0)) FOR [UseInterstoreTransaction]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_UseSerialBasedPricing] DEFAULT ((0)) FOR [UseSerialBasedPricing]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_SaleDiscountAfterTax] DEFAULT ((0)) FOR [SaleDiscountAfterTax]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_IgnoreDiscountItemsForSaleDiscount] DEFAULT ((0)) FOR [IgnoreDiscountItemsForSaleDiscount]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_AllowMultipleTransactionMode] DEFAULT ((1)) FOR [AllowMultipleTransactionMode]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_AllowMultipleSalesPersonOnItem] DEFAULT ((0)) FOR [AllowMultipleSalesPersonOnItem]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_IsLoyaltyEnabled] DEFAULT ((0)) FOR [IsLoyaltyEnabled]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_OpenSalesAttributeAutomatically] DEFAULT ((1)) FOR [OpenSalesAttributeAutomatically]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_ApplyLayawayOnSale] DEFAULT ((0)) FOR [ApplyLayawayOnSale]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_CollectSaleOrderAdvance] DEFAULT ((0)) FOR [CollectSaleOrderAdvance]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_RoundAmountInInvoice] DEFAULT ((0)) FOR [RoundAmountInInvoice]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_IsClubEnabled] DEFAULT ((0)) FOR [IsClubEnabled]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_AllowGiftCertificateSaleRedemption] DEFAULT ((0)) FOR [AllowGiftCertificateSaleRedemption]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_CanDeliverFromGeneralWarehouse] DEFAULT ((0)) FOR [CanDeliverFromGeneralWarehouse]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_ParticipateInUserExperience] DEFAULT ((0)) FOR [ParticipateInUserExperience]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_RollupOnlyCashCustomerInvoices] DEFAULT ((0)) FOR [RollupOnlyCashCustomerInvoices]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_IsPassbookIntegrated] DEFAULT ((0)) FOR [IsPassbookIntegrated]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_AllowPriceChangeInGRPO] DEFAULT ((0)) FOR [AllowPriceChangeInGRPO]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_AutoSelectSerialBatchType] DEFAULT ((0)) FOR [AutoSelectSerialBatchType]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_AllowPartialReceivingOfInventory] DEFAULT ((1)) FOR [AllowPartialReceivingOfInventory]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_IsTrxServerIntegrated] DEFAULT ((0)) FOR [IsTrxServerIntegrated]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_TransactionRecordsCount] DEFAULT ((500)) FOR [TransactionRecordsCount]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_ExchangeTransactionDataBetweenServer] DEFAULT ((0)) FOR [ExchangeTransactionDataBetweenStore]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_ReplicationBatchSize] DEFAULT ((5000)) FOR [ReplicationBatchSize]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_AllowUserDefinedProductId] DEFAULT ((0)) FOR [AllowUserDefinedProductId]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_IsBranchEnabled] DEFAULT ((0)) FOR [IsBranchEnabled]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_AssignCustomerToAllBranch] DEFAULT ((0)) FOR [AssignCustomerToAllBranch]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_UseAdvanceAuthorization] DEFAULT ((0)) FOR [UseAdvanceAuthorization]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF__CfgEnterp__Assig__043B7C66] DEFAULT ((0)) FOR [AssignCustomersToAllSubsidiary]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_InventoryCountMergeDateType] DEFAULT ((0)) FOR [InventoryCountMergeDateType]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF__CfgEnterp__Allow__31ED387D] DEFAULT ((1)) FOR [AllowZeroPrice]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF_CfgEnterprise_InventoryReplicationInStoreGroup] DEFAULT ((0)) FOR [InventoryReplicationInStoreGroup]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF__CfgEnterp__NoOfD__2260DC2A] DEFAULT ((1)) FOR [NoOfDaysForQuotationValidity]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF__CfgEnterp__Allow__23550063] DEFAULT ((1)) FOR [AllowExpiredQuotationConversion]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [Cons_SODeliveryMinimumPercentPaid] DEFAULT ((0)) FOR [SODeliveryMinimumPercentPaid]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [Cons_SOMinimumDepositRequired] DEFAULT ((0)) FOR [SOMinimumDepositRequired]

ALTER TABLE [dbo].[CfgEnterprise] ADD CONSTRAINT [DF__CfgEnterp__Creat__4A6ECD84] DEFAULT ((0)) FOR [CreatePerOrderPicklist]

Related Objects

iVend Database Database

Send comments on this topic.