Navigation:  General Information >

Data Types

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic

The following user defined data types exist in a Qmuzik database:

Data Type

Notes

Acceptance_Criteria

char (3)

Account

varchar (10)

Account_Code

varchar (10)

Action_Code

varchar (3)

Application_Scenario

varchar (30)

Asset

varchar (35)

Asset_Group

int

Authorisation_ID

varchar (20)

Bank

char (3)

Bank_Branch

char (5)

Budget_Scenario

varchar (10)

Calendar_Descriptions

varchar (100)

Calendar_IDs

bigint

Calendar_Names

varchar (50)

Characteristic_ID

int

City

varchar (7)

Commodity

char (6)

Container

varchar (30)

Contract_Number

varchar (30)

Cost_Centre

varchar (10)

Country_Code

varchar (6)

Crate

varchar (30)

Credit_Note

varchar (10)

Currency

char (3)

Cycle_Count_Run

varchar (10)

Cycle_Count_Set

varchar (20)

Debtor_Invoice_Line

smallint

Depreciation_Model

int

Division

varchar (4)

Document

varchar (50)

DOL_Code

varchar (10)

ECP

varchar (10)

ECP_Classification

char (3)

EFT_Ref_Number

varchar (20)

EFT_Tran_Number

varchar (5)

Employee_ID

varchar (20)

Equipment

varchar (50)

Facility

varchar (30)

Failure

varchar (30)

Failure_Report

varchar (20)

Field_Name

varchar (30)

Financial_Period

varchar (15)

Financial_Year

varchar (15)

Forecast_ID

varchar (20)

Freight_Term

char (3)

GEO_Code

varchar (15)

Glossary_ID

int

Invoice

varchar (15)

Invoice_Line

varchar (10)

Labour_Resource

varchar (25)

Language_Code

char (1)

Levy_Type

varchar (10)

License_Code

varchar (15)

Material_Resource

varchar (25)

Mission

varchar (20)

Movement_Reason

varchar (10)

Node

varchar (20)

Non_Posting_Entity

varchar (15)

Operation

varchar (10)

Order_Line

smallint

Order_Number

varchar (30)

Order_Type

char (4)

Organisation

varchar (20)

Pallet

varchar (30)

Pallet_Type

varchar (30)

Part

varchar (30)

Percentage

tinyint

Percentage_Decimal

decimal (7,3)

Position

varchar (20)

Positive_Money

decimal (12,3)

Positive_Small_Money

decimal (7,2)

Postal_Code

varchar (8)

Priority_Code

varchar (10)

Product

char (3)

Product_Family

varchar (10)

Project_Group

varchar (20)

Rating_Code

varchar (20)

Reason

varchar (20)

Region

varchar (10)

Request_Category

varchar (3)

Request_Grouping_Code

varchar (10)

Requirement_Code

varchar (10)

Requisition

char (5)

Result_Code

varchar (3)

Revision

varchar (5)

Serial_Number

varchar (30)

Settlement_Term

varchar (10)

Skill

varchar (10)

Small_Money

decimal (7,2)

Standard_Item

varchar (30)

Store

varchar (4)

Store_Location

varchar (20)

Table_Name

varchar (30)

Tax_Code

varchar (6)

Timesheet_Type

varchar (5)

Transport_Code

varchar (5)

Unit_Of_Measure

char (3)

Vehicle_Type

varchar (15)

Work_Centre

varchar (10)

Yes_No

char (1)

Zip_Postal_Code

varchar (15)

 

 

The following are the native SQL data types:

Data Type

Notes

Bigint

Integers between -263 and 263 - 1.

Bit

Valid values: 1 or 0 (Yes / Active vs No / Inactive).

Char (n)

Character Data. Maximum length is n

Datetime

Date and Time in the format YYYY-MM-DD HH:MM:SSS.000

Decimal (p, s)

Decimal values (Positive and Negative): p (precision) = the maximum total number of decimal digits that can be stored, both to the left and to the right of the decimal point ; s (scale) = the maximum number of decimal digits that can be stored to the right of the decimal point

Int

Integers values between -231 and 231 – 1.

Numeric (p, s)

Decimal values (Positive and Negative): p (precision) = the maximum total number of decimal digits that can be stored, both to the left and to the right of the decimal point ; s (scale) = the maximum number of decimal digits that can be stored to the right of the decimal point

Smalldatetime

Date and Time in the format YYYY-MM-DD HH:MM

Smallint

Integer values between –32,768 and 32,767.

Sql_Variant

Character Data. Maximum of 8016 characters

Text

Character Data with a maximum field length of 231-1 (2,147,483,647) characters

Tinyint

Positive Integers between 0 and 255.

Varchar (n)

Character Data. Maximum length is n

Yes_No

Valid values: Y or N (Yes or No).