Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
XMLReportHierarchy Table
Collapse All Expand All
iVend Database Database : XMLReportHierarchy Table |
Description
stores the hierarchy information of the data objects of the reports in the system.
Properties
Creation Date |
9/18/2015 10:05 AM |
File Group |
PRIMARY |
Text File Group |
|
System Object |
|
Published for Replication |
|
Rows |
2915 |
Data Space Used |
680.00 KB |
Index Space Used |
16.00 KB |
Columns
|
Column Name |
Description |
Datatype |
Length |
Allow Nulls |
Default |
Formula |
|
ReportHierarchyKey |
Primary Key of ReportHierarchyKey |
VarWChar |
50 |
|
|
|
|
SectionType |
Define Report Section (Header, Footer & Detail). |
Integer |
4 |
|
|
|
|
SequenceNumber |
Sequence number reset on base of GroupName. |
Integer |
4 |
|
|
|
|
GroupName |
XML Report Object Name and Enumerator Name |
VarWChar |
200 |
|
|
|
|
FieldName |
XML Report property name prefix with table or object name. |
VarWChar |
200 |
|
|
|
|
DefaultName |
Actual name of property which is use as column in database related table. |
VarWChar |
200 |
|
|
|
|
IsVariable |
Values is true if Text box value comes from Database. |
Boolean |
1 |
|
|
|
|
DefaultLenght |
Text box default length to place on base on colspan. |
Integer |
4 |
|
|
|
|
DefaultAlign |
XML Report text box default alignment like (Left, Right or Center) |
VarWChar |
100 |
|
|
|
|
Type |
XML Report Object data types |
VarWChar |
100 |
|
|
|
|
CaptionName |
XML Report text box default length to place on base on colspan. |
VarWChar |
500 |
|
|
|
|
ReportType |
Valid Values are LaborChit = 1 DayLaborChit = 2 TransactionReceipt = 3 DrawerCountChit = 4 XTapeReport = 5 GiftReceipt = 6 QuotationReceipt = 7 ExpenseChit = 8 ZTapeReport = 9 CashInCashOut = 10 GiftCertificate = 11 Coupon = 12 CustomerDisplayReceipt = 13 PaymentReceipt=14 |
Integer |
4 |
|
|
|
|
ParentObjectID |
Stores the id of immediate parent object |
Integer |
4 |
|
((0)) |
|
|
SubSectionType |
Stores the information regarding supported enumerators. |
Integer |
4 |
|
((0)) |
|
Indexes
Index |
Description |
Primary |
Unique |
|
|
|
Objects that depend on XMLReportHierarchy
|
Database Object |
Object Type |
Description |
Dep Level |
|
Stored Procedure |
|
1 |
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[XMLReportHierarchy]( [ReportHierarchyKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [SectionType] [int] NOT NULL, [SequenceNumber] [int] NOT NULL, [GroupName] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [FieldName] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [DefaultName] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [IsVariable] [bit] NULL, [DefaultLenght] [int] NULL, [DefaultAlign] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Type] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [CaptionName] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ReportType] [int] NULL, [ParentObjectID] [int] NOT NULL, [SubSectionType] [int] NULL, CONSTRAINT [XmlReportHierarchy_Pk] PRIMARY KEY CLUSTERED ( [ReportHierarchyKey] 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].[XMLReportHierarchy] ADD CONSTRAINT [DF__XMLReport__Paren__03275C9C] DEFAULT ((0)) FOR [ParentObjectID] ALTER TABLE [dbo].[XMLReportHierarchy] ADD CONSTRAINT [DF__XMLReport__SubSe__7CBA562F] DEFAULT ((0)) FOR [SubSectionType] |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.