iVend Database Database : vw_RtlPrintFormat View

Creation Date

6/21/2016 6:14 PM

Is Schema Bound

Encrypted

Ansi Nulls

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

PrintFormatKey

BigInt

8

FollowUpFormatKey

BigInt

8

Description

VarWChar

100

FollowUpFormat

VarWChar

20

Database Object

Object Type

Description

Dep Level

RtlPrintFormat

Table

Stores the format for types of printing that is done in POS. E.g Transaction Receipt, X-Tape Report.

1

CREATE VIEW [dbo].[vw_RtlPrintFormat]

AS

SELECT        rtf.PrintFormatKey,

             rtf.FollowUpFormatKey,

             rtf1.Description,

             rtf1.Id AS FollowUpFormat

FROM          dbo.RtlPrintFormat AS rtf LEFT OUTER JOIN

             dbo.RtlPrintFormat AS rtf1

            ON rtf.FollowUpFormatKey = rtf1.PrintFormatKey