Skip to main content
Skip table of contents

RepoSetupsItems, 60 (ver3.6.1)

Reporting engine individual items that make up the report.

Column Name

Initial Version

Data Type

Description

ConversionTable

3.6.1

CLOB

Values that need to be converted from their original settings separated by semicolon, such as 1=Y, 2=N.

Conversion_Table_Def_Value

3.6.1

CLOB

A default value to be given when there is no conversion value available.

DataToExport

3.6.1

CLOB

Actual data/columns to be exported in a Data Code format.

DCID

4.0.0

Number(10,0)

Unique identifier for this table. Indexed. Required.

Description

3.6.1

CLOB

An optional area to describe any information about this item.

Display_Format

3.6.1

Varchar(79)

The format this item is to be displayed, such as ###0 = number greater than 0.

FixedLength_FillChar

3.6.1

Varchar(11)

For fixed length fields the character to fill the field. This can be in an ASCII format.

FixedLength_Justification

3.6.1

Number(10,0)

Alignment for this field: Right, Center or Left.

FixedLength_Length

3.6.1

Number(10,0)

Length of this fixed length field.

FixedLength_StartPosition

3.6.1

Number(10,0)

When import the start position of the field.

Internal_ID

3.6.1

Number(10,0)

Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed.

ItemNbr

3.6.1

Number(10,0)

Number that can be manually assigned to this item for reference purposes.

MissingValueSymbol

3.6.1

Varchar(79)

What symbol to use if the item value is missing, such as for decimal use 0.00.

Nbr_Of_Decimals

3.6.1

Number(10,0)

Number of decimals to be used for the value of this item. For numeric values only and up to 12.

ReportSetupID

3.6.1

Number(10,0)

The internal number for the parent RepoSetupID with which this record is associated. Indexed.

TitleHeading

3.6.1

CLOB

Heading for this field on the report.

Trim_Nbr_Of_Chars

3.6.1

Number(10,0)

Trim number of characters at the start point given. Passed in through an Import for Exporting.

Trim_Start_At

3.6.1

Number(10,0)

The point to start trimming the characters. Passed in through an Import for Exporting.

Unused1

3.6.1

Number(10,0)

Currently unused field.

User_Info

3.6.1

CLOB

Any user information passed in through Import for Exporting purposes.

User_Modifiable

3.6.1

Number(10,0)

Indicates whether this item is user modifiable. Passed in through Import for Exporting purposes.

Value_Type

3.6.1

Number(10,0)

Datatype of the Variable to be used: 1=Integer, 2=Real, 3=Text, 4=Date, 5=Boolean, 6=Time, 7= Undefined.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.