iVend Database Database > Tables

Navigation: iVend Database Database > Tables >

iVend 6.6 Database Help

TaxTaxCode Table

Collapse All Expand All

iVend Database Database : TaxTaxCode Table

Description

TaxCode is defined at the SBO and it's replicated from SBO to iVend. We can only view the TaxCodes at MC and associate them with the different objects, like Product, Customer, Enterprise, etc.

Properties

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

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
TaxCodeKey	Primary Key	VarWChar	50
Id	Unique id of for taxcode	VarWChar	20
Description	Description of taxcode	VarWChar	100
Rate	TaxCode rate	Numeric	9 (20,5)
TaxExpenses	For future use	Boolean	1
Threshhold	For future use	Numeric	9 (20,5)
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
IsDeleted	Value is True if the record has been deleted from the system. Record is always Soft Deleted	Boolean	1
IsExempt	Flag for checking the exemption of tax	Boolean	1
AccountingID	Unique id for reference with SAP Business One(used for replication)	VarWChar	50
TaxType	Type of tax	Integer	4
LoadonItemCost	Specifies if this tax has to be accounted while calculating the cost for an item.	Boolean	1		((0))
SubsidiaryKey	Reference key of the Subsidiary. See also Subsidiary	VarWChar	50		((0))

Indexes

Index	Description	Primary	Unique
PK_TaxTaxCode

Objects that depend on TaxTaxCode

Database Object	Object Type	Description	Dep Level
GetMobileReplicationData	Stored Procedure		1
Integration_Consolidated_Transaction	Stored Procedure		1
Integration_Consolidated_TransactionSurcharge	Stored Procedure		1
Integration_GoodsReceipt	Stored Procedure		1
Integration_GoodsReturn	Stored Procedure		1
Integration_PurchaseOrder	Stored Procedure		1
Integration_TransactionSurcharge	Stored Procedure		1
uspTapeReport	Stored Procedure		1

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[TaxTaxCode](

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

[Id] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

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

[Rate] [decimal](20, 5) NOT NULL,

[TaxExpenses] [bit] NOT NULL,

[Threshhold] [decimal](20, 5) NOT 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,

[IsDeleted] [bit] NOT NULL,

[IsExempt] [bit] NOT NULL,

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

[TaxType] [int] NOT NULL,

[LoadonItemCost] [bit] NOT NULL,

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

CONSTRAINT [PK_TaxTaxCode] PRIMARY KEY CLUSTERED

(

[TaxCodeKey] ASC

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

) ON [PRIMARY]

ALTER TABLE [dbo].[TaxTaxCode] ADD CONSTRAINT [DF_TaxTaxCode_LoadonItemCost] DEFAULT ((0)) FOR [LoadonItemCost]

ALTER TABLE [dbo].[TaxTaxCode] ADD CONSTRAINT [DF_TaxTaxCode_SubsidiaryKey] DEFAULT ((0)) FOR [SubsidiaryKey]

Related Objects

iVend Database Database

Send comments on this topic.